lobbying_issue_summary

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

80 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ issue_code issue_description filing_count unique_clients unique_registrants total_income
1 1     207789 35223 6651 654890349
2 2 ACC Accounting 4493 477 424 198535330
3 3 ADV Advertising 3807 268 233 61864726
4 4 AER Aerospace 11130 946 604 289392828
5 5 AGR Agriculture 67073 3982 2077 1362311573
6 6 ALC Alcohol and Drug Abuse 4793 354 302 72759075
7 7 ANI Animals 9370 537 448 138960820
8 8 APP Apparel/Clothing Industry/Textiles 1771 155 110 36441913
9 9 ART Arts/Entertainment 5521 448 306 88127736
10 10 AUT Automotive Industry 11727 649 542 304369923
11 11 AVI Aviation/Airlines/Airports 32061 2039 1084 809224961
12 12 BAN Banking 40825 2536 1429 1155039689
13 13 BEV Beverage Industry 3516 180 188 94782500
14 14 BNK Bankruptcy 3195 337 294 86272930
15 15 BUD Budget/Appropriations 323669 18639 4395 6931802974
16 16 CAW Clean Air and Water (quality) 34627 2029 1145 626999299
17 17 CDT Commodities (big ticket) 3263 272 219 73944098
18 18 CHM Chemicals/Chemical Industry 10928 676 535 226302284
19 19 CIV Civil Rights/Civil Liberties 11288 895 747 203895830
20 20 COM Communications/Broadcasting/Radio/TV 21679 1357 947 664568592
21 21 CON Constitution 3689 301 274 122196372
22 22 CPI Computer Industry 19433 1290 768 650897673
23 23 CPT Copyright/Patent/Trademark 38841 1873 1256 1106118155
24 24 CSP Consumer Issues/Safety/Products 31023 1962 1256 753172171
25 25 DEF Defense 139366 10381 2873 3385820936
26 26 DIS Disaster Planning/Emergencies 16869 1958 1003 337510070
27 27 DOC District of Columbia 1095 118 104 16595731
28 28 ECN Economics/Economic Development 25902 2712 1268 561539006
29 29 EDU Education 78466 4508 2109 1282615888
30 30 ENG Energy/Nuclear 115358 7180 2894 2996119641
31 31 ENV Environment/Superfund 82547 5522 2398 1855873080
32 32 FAM Family issues/Abortion/Adoption 5520 424 356 67305002
33 33 FIN Financial Institutions/Investments/Securities 69254 4283 2031 2235100893
34 34 FIR Firearms/Guns/Ammunition 3715 277 246 60966309
35 35 FOO Food Industry (safety, labeling, etc.) 20907 1211 802 420259449
36 36 FOR Foreign Relations 28978 2537 1366 730113616
37 37 FUE Fuel/Gas/Oil 14807 1066 758 446931009
38 38 GAM Gaming/Gambling/Casino 7697 429 336 290266844
39 39 GOV Government Issues 49888 4810 2069 1186215869
40 40 HCR Health Issues 214520 11564 3950 5717323834
41 41 HOM Homeland Security 52638 3957 1908 1200246042
42 42 HOU Housing 28638 2210 1060 645505506
43 43 IMM Immigration 38866 2451 1595 726578834
44 44 IND Indian/Native American Affairs 24901 1212 578 646632899
45 45 INS Insurance 25371 1340 924 662826363
46 46 INT Intelligence 6848 658 441 162549653
47 47 LAW Law Enforcement/Crime/Criminal Justice 30736 2561 1385 605066898
48 48 LBR Labor Issues/Antitrust/Workplace 59644 3688 2243 1239630223
49 49 MAN Manufacturing 20564 1959 1049 550216822
50 50 MAR Marine/Maritime/Boating/Fisheries 24222 1459 762 521957680
51 51 MED Medical/Disease Research/Clinical Labs 21169 1858 989 468959632
52 52 MIA Media (information/publishing) 2877 267 227 86449100
53 53 MMM Medicare/Medicaid 104639 4790 1769 2968943615
54 54 MON Minting/Money/Gold Standard 868 99 92 24363599
55 55 NAT Natural Resources 53549 3442 1426 1120506092
56 56 PHA Pharmacy 19060 1209 762 543345520
57 57 POS Postal 7600 543 438 164704509
58 58 REL Religion 1311 110 107 8058900
59 59 RES Real Estate/Land Use/Conservation 11926 1228 628 243330441
60 60 RET Retirement 19361 930 716 378467605
61 61 ROD Roads/Highway 8942 777 531 164621391
62 62 RRR Railroads 10697 618 477 232524326
63 63 SCI Science/Technology 39429 3160 1687 969435394
64 64 SMB Small Business 18276 1693 1090 296980836
65 65 SPO Sports/Athletics 4658 391 301 109566027
66 66 TAR Tariff (miscellaneous tariff bills) 9141 1084 679 157810031
67 67 TAX Taxation/Internal Revenue Code 212623 9717 3982 6208057866
68 68 TEC Telecommunications 50252 2859 1469 1554878862
69 69 TOB Tobacco 7614 295 358 235228165
70 70 TOR Torts 6149 419 378 118312812
71 71 TOU Travel/Tourism 6587 511 389 191384533
72 72 TRA Transportation 122178 7161 2689 2577833852
73 73 TRD Trade (domestic/foreign) 97113 6021 2533 2637809013
74 74 TRU Trucking/Shipping 5624 443 384 97344551
75 75 UNM Unemployment 1878 193 179 16799816
76 76 URB Urban Development/Municipalities 15343 1156 428 299059793
77 77 UTI Utilities 12198 790 529 305954387
78 78 VET Veterans 24053 2090 1252 469894248
79 79 WAS Waste (hazardous/solid/interstate/nuclear) 4364 386 316 81846539
80 80 WEL Welfare 3756 355 285 54454987

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE lobbying_issue_summary(
  issue_code TEXT,
  issue_description,
  filing_count,
  unique_clients,
  unique_registrants,
  total_income INT
);
CREATE INDEX idx_lis_filing_count ON lobbying_issue_summary(filing_count DESC);