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 description filing_count client_count total_income
1 1 BUD Budget/Appropriations 323669 18639 6925416365
2 2 HCR Health Issues 214520 11564 5713559334
3 3 TAX Taxation/Internal Revenue Code 212623 9717 6205188866
4 4     207789 35223 650251849
5 5 DEF Defense 139366 10381 3377300540
6 6 TRA Transportation 122178 7161 2572928456
7 7 ENG Energy/Nuclear 115358 7180 2991418845
8 8 MMM Medicare/Medicaid 104639 4790 2967386615
9 9 TRD Trade (domestic/foreign) 97113 6021 2634516013
10 10 ENV Environment/Superfund 82547 5522 1853624784
11 11 EDU Education 78466 4508 1280681690
12 12 FIN Financial Institutions/Investments/Securities 69254 4283 2230791213
13 13 AGR Agriculture 67073 3982 1359985573
14 14 LBR Labor Issues/Antitrust/Workplace 59644 3688 1238985223
15 15 NAT Natural Resources 53549 3442 1117328696
16 16 HOM Homeland Security 52638 3957 1198260346
17 17 TEC Telecommunications 50252 2859 1554368862
18 18 GOV Government Issues 49888 4810 1183670869
19 19 BAN Banking 40825 2536 1152364689
20 20 SCI Science/Technology 39429 3160 968935394
21 21 IMM Immigration 38866 2451 726187834
22 22 CPT Copyright/Patent/Trademark 38841 1873 1105248155
23 23 CAW Clean Air and Water (quality) 34627 2029 626759299
24 24 AVI Aviation/Airlines/Airports 32061 2039 808354961
25 25 CSP Consumer Issues/Safety/Products 31023 1962 753072171
26 26 LAW Law Enforcement/Crime/Criminal Justice 30736 2561 604443898
27 27 FOR Foreign Relations 28978 2537 727390616
28 28 HOU Housing 28638 2210 643925506
29 29 ECN Economics/Economic Development 25902 2712 560119006
30 30 INS Insurance 25371 1340 661936363
31 31 IND Indian/Native American Affairs 24901 1212 646422899
32 32 MAR Marine/Maritime/Boating/Fisheries 24222 1459 520991734
33 33 VET Veterans 24053 2090 468114248
34 34 COM Communications/Broadcasting/Radio/TV 21679 1357 664278592
35 35 MED Medical/Disease Research/Clinical Labs 21169 1858 468058382
36 36 FOO Food Industry (safety, labeling, etc.) 20907 1211 419819449
37 37 MAN Manufacturing 20564 1959 549161822
38 38 CPI Computer Industry 19433 1290 650037673
39 39 RET Retirement 19361 930 378467605
40 40 PHA Pharmacy 19060 1209 542635520
41 41 SMB Small Business 18276 1693 296371656
42 42 DIS Disaster Planning/Emergencies 16869 1958 337170070
43 43 URB Urban Development/Municipalities 15343 1156 298159793
44 44 FUE Fuel/Gas/Oil 14807 1066 446283509
45 45 UTI Utilities 12198 790 305718387
46 46 RES Real Estate/Land Use/Conservation 11926 1228 243180441
47 47 AUT Automotive Industry 11727 649 304249923
48 48 CIV Civil Rights/Civil Liberties 11288 895 203362830
49 49 AER Aerospace 11130 946 289342828
50 50 CHM Chemicals/Chemical Industry 10928 676 225432284
51 51 RRR Railroads 10697 618 232304326
52 52 ANI Animals 9370 537 138935820
53 53 TAR Tariff (miscellaneous tariff bills) 9141 1084 155426031
54 54 ROD Roads/Highway 8942 777 164151391
55 55 GAM Gaming/Gambling/Casino 7697 429 290176844
56 56 TOB Tobacco 7614 295 235008165
57 57 POS Postal 7600 543 164314509
58 58 INT Intelligence 6848 658 162549653
59 59 TOU Travel/Tourism 6587 511 191234533
60 60 TOR Torts 6149 419 118312812
61 61 TRU Trucking/Shipping 5624 443 97344551
62 62 ART Arts/Entertainment 5521 448 88067736
63 63 FAM Family issues/Abortion/Adoption 5520 424 67298116
64 64 ALC Alcohol and Drug Abuse 4793 354 72759075
65 65 SPO Sports/Athletics 4658 391 109276027
66 66 ACC Accounting 4493 477 198355330
67 67 WAS Waste (hazardous/solid/interstate/nuclear) 4364 386 81846539
68 68 ADV Advertising 3807 268 61864726
69 69 WEL Welfare 3756 355 54359715
70 70 FIR Firearms/Guns/Ammunition 3715 277 60966309
71 71 CON Constitution 3689 301 122088372
72 72 BEV Beverage Industry 3516 180 94732500
73 73 CDT Commodities (big ticket) 3263 272 73634098
74 74 BNK Bankruptcy 3195 337 86272930
75 75 MIA Media (information/publishing) 2877 267 86392400
76 76 UNM Unemployment 1878 193 16799816
77 77 APP Apparel/Clothing Industry/Textiles 1771 155 36441913
78 78 REL Religion 1311 110 8058900
79 79 DOC District of Columbia 1095 118 16595731
80 80 MON Minting/Money/Gold Standard 868 99 24363599

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE lobbying_issue_summary(
  issue_code TEXT,
  description TEXT,
  filing_count,
  client_count,
  total_income INT
);
CREATE UNIQUE INDEX idx_lis_code ON lobbying_issue_summary(issue_code);