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 329609 18839 7078322121
2 2 HCR Health Issues 218195 11736 5838143509
3 3 TAX Taxation/Internal Revenue Code 215711 9808 6309555214
4 4     211144 35784 673774662
5 5 DEF Defense 142667 10637 3487035828
6 6 TRA Transportation 124083 7260 2621500125
7 7 ENG Energy/Nuclear 117329 7289 3067089583
8 8 MMM Medicare/Medicaid 106434 4844 3025807632
9 9 TRD Trade (domestic/foreign) 99415 6149 2722708104
10 10 ENV Environment/Superfund 83774 5577 1888283404
11 11 EDU Education 79781 4564 1308661963
12 12 FIN Financial Institutions/Investments/Securities 70565 4366 2280066513
13 13 AGR Agriculture 68378 4047 1395554543
14 14 LBR Labor Issues/Antitrust/Workplace 60629 3740 1264702959
15 15 NAT Natural Resources 54626 3512 1150693666
16 16 HOM Homeland Security 53350 4003 1218063544
17 17 TEC Telecommunications 50982 2894 1581387972
18 18 GOV Government Issues 50761 4899 1254701409
19 19 BAN Banking 41504 2563 1214566536
20 20 SCI Science/Technology 40467 3251 1003588711
21 21 IMM Immigration 39379 2478 736740901
22 22 CPT Copyright/Patent/Trademark 39292 1887 1119728009
23 23 CAW Clean Air and Water (quality) 35040 2044 635919949
24 24 AVI Aviation/Airlines/Airports 32643 2066 826206461
25 25 CSP Consumer Issues/Safety/Products 31584 1993 769908525
26 26 LAW Law Enforcement/Crime/Criminal Justice 31229 2596 617055998
27 27 FOR Foreign Relations 29512 2611 746754259
28 28 HOU Housing 29315 2274 664845831
29 29 ECN Economics/Economic Development 26292 2741 611232457
30 30 INS Insurance 25718 1344 670999363
31 31 IND Indian/Native American Affairs 25288 1232 658835029
32 32 MAR Marine/Maritime/Boating/Fisheries 24653 1490 532988864
33 33 VET Veterans 24545 2120 481668117
34 34 COM Communications/Broadcasting/Radio/TV 21953 1372 673312342
35 35 MED Medical/Disease Research/Clinical Labs 21509 1883 478622382
36 36 MAN Manufacturing 21246 2014 575811820
37 37 FOO Food Industry (safety, labeling, etc.) 21242 1230 429427199
38 38 CPI Computer Industry 19916 1332 669936667
39 39 RET Retirement 19618 939 384228729
40 40 PHA Pharmacy 19413 1229 556297270
41 41 SMB Small Business 18604 1712 302948312
42 42 DIS Disaster Planning/Emergencies 17173 1975 345270787
43 43 URB Urban Development/Municipalities 15630 1166 304502027
44 44 FUE Fuel/Gas/Oil 15019 1083 454082048
45 45 UTI Utilities 12391 798 312212886
46 46 RES Real Estate/Land Use/Conservation 12119 1241 248892441
47 47 AUT Automotive Industry 11962 661 312110923
48 48 CIV Civil Rights/Civil Liberties 11468 902 245563830
49 49 AER Aerospace 11397 962 296230720
50 50 CHM Chemicals/Chemical Industry 11113 687 230278784
51 51 RRR Railroads 10861 628 237507864
52 52 ANI Animals 9539 547 142070820
53 53 TAR Tariff (miscellaneous tariff bills) 9481 1106 166357031
54 54 ROD Roads/Highway 9062 788 167107391
55 55 GAM Gaming/Gambling/Casino 7832 439 295760844
56 56 TOB Tobacco 7738 296 239959665
57 57 POS Postal 7697 547 166471509
58 58 INT Intelligence 6999 669 166639170
59 59 TOU Travel/Tourism 6712 514 195012033
60 60 TOR Torts 6220 422 119709812
61 61 TRU Trucking/Shipping 5706 449 99184551
62 62 FAM Family issues/Abortion/Adoption 5617 436 68216460
63 63 ART Arts/Entertainment 5603 452 90054236
64 64 ALC Alcohol and Drug Abuse 4854 356 74066075
65 65 SPO Sports/Athletics 4846 406 114100527
66 66 ACC Accounting 4568 488 239691830
67 67 WAS Waste (hazardous/solid/interstate/nuclear) 4425 395 83246539
68 68 ADV Advertising 3847 270 62924226
69 69 WEL Welfare 3840 358 55954459
70 70 FIR Firearms/Guns/Ammunition 3779 283 62972309
71 71 CON Constitution 3741 304 162974372
72 72 BEV Beverage Industry 3578 183 97039500
73 73 CDT Commodities (big ticket) 3314 278 75434098
74 74 BNK Bankruptcy 3222 338 87067930
75 75 MIA Media (information/publishing) 2917 267 87735795
76 76 UNM Unemployment 1896 194 16930691
77 77 APP Apparel/Clothing Industry/Textiles 1796 157 37052413
78 78 REL Religion 1332 112 8463900
79 79 DOC District of Columbia 1116 122 16765731
80 80 MON Minting/Money/Gold Standard 887 102 25008599

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);