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 420458 24418 10274612429
2 2     279183 48664 1055061922
3 3 TAX Taxation/Internal Revenue Code 267895 12682 8971639167
4 4 HCR Health Issues 266925 14847 7758926795
5 5 DEF Defense 186764 14127 5060143707
6 6 TRA Transportation 155160 9896 3659211560
7 7 ENG Energy/Nuclear 145114 9314 4237044853
8 8 MMM Medicare/Medicaid 132347 6442 4023741114
9 9 TRD Trade (domestic/foreign) 127571 8290 4093241004
10 10 ENV Environment/Superfund 106416 7623 2712666628
11 11 EDU Education 102865 6480 1949432522
12 12 AGR Agriculture 85153 5202 1873082826
13 13 FIN Financial Institutions/Investments/Securities 84907 5411 3184590367
14 14 LBR Labor Issues/Antitrust/Workplace 74817 4806 1786069705
15 15 NAT Natural Resources 67465 4556 1543647911
16 16 TEC Telecommunications 67028 4600 2557762589
17 17 GOV Government Issues 65387 6879 1857664614
18 18 HOM Homeland Security 62893 4973 1614068518
19 19 BAN Banking 52306 3379 1853318387
20 20 SCI Science/Technology 51836 4304 1419991688
21 21 CPT Copyright/Patent/Trademark 48252 2569 1636276086
22 22 IMM Immigration 47124 3068 956934948
23 23 CAW Clean Air and Water (quality) 44231 2799 947872207
24 24 AVI Aviation/Airlines/Airports 42370 3284 1194531433
25 25 LAW Law Enforcement/Crime/Criminal Justice 39584 3595 938901462
26 26 CSP Consumer Issues/Safety/Products 38530 2629 1119299137
27 27 HOU Housing 37633 3064 1004529102
28 28 FOR Foreign Relations 37136 3432 1056344788
29 29 INS Insurance 33089 2068 1119090687
30 30 IND Indian/Native American Affairs 32951 1904 981412523
31 31 ECN Economics/Economic Development 32829 3741 829458574
32 32 MAR Marine/Maritime/Boating/Fisheries 32044 2258 766603485
33 33 COM Communications/Broadcasting/Radio/TV 28925 2225 1062737442
34 34 VET Veterans 28618 2376 580945256
35 35 MED Medical/Disease Research/Clinical Labs 28393 2777 721204809
36 36 FOO Food Industry (safety, labeling, etc.) 26458 1719 568438882
37 37 MAN Manufacturing 25890 2366 752286352
38 38 CPI Computer Industry 25636 2131 999203499
39 39 RET Retirement 25619 1391 774038192
40 40 PHA Pharmacy 24069 1641 779729808
41 41 SMB Small Business 22687 2128 414623056
42 42 DIS Disaster Planning/Emergencies 21474 2578 513298843
43 43 URB Urban Development/Municipalities 19747 1658 416860860
44 44 FUE Fuel/Gas/Oil 19224 1705 641142327
45 45 UTI Utilities 17881 1479 627449497
46 46 RES Real Estate/Land Use/Conservation 16602 1986 404461584
47 47 AER Aerospace 14740 1421 416104940
48 48 AUT Automotive Industry 14675 865 428976497
49 49 CIV Civil Rights/Civil Liberties 14346 1111 371694263
50 50 RRR Railroads 14325 1006 373320700
51 51 CHM Chemicals/Chemical Industry 13542 849 302881889
52 52 ROD Roads/Highway 12323 1293 288196177
53 53 ANI Animals 11665 727 206863943
54 54 TAR Tariff (miscellaneous tariff bills) 10866 1084 203368668
55 55 GAM Gaming/Gambling/Casino 10648 875 472653228
56 56 TOB Tobacco 10429 517 405472352
57 57 POS Postal 10376 960 316126756
58 58 TOR Torts 10245 866 383737225
59 59 TOU Travel/Tourism 8355 762 260498082
60 60 ART Arts/Entertainment 8041 735 150007813
61 61 INT Intelligence 7585 662 183480111
62 62 FAM Family issues/Abortion/Adoption 7316 580 126516104
63 63 TRU Trucking/Shipping 7237 672 147061203
64 64 WAS Waste (hazardous/solid/interstate/nuclear) 7231 810 208026981
65 65 ALC Alcohol and Drug Abuse 6485 538 123729375
66 66 SPO Sports/Athletics 6186 563 158537604
67 67 ACC Accounting 6109 713 418111654
68 68 BNK Bankruptcy 6109 778 321060882
69 69 WEL Welfare 5980 636 101623276
70 70 ADV Advertising 4897 387 93588076
71 71 FIR Firearms/Guns/Ammunition 4765 362 87438589
72 72 CON Constitution 4757 429 209153658
73 73 BEV Beverage Industry 4601 284 146853500
74 74 MIA Media (information/publishing) 3835 411 127967493
75 75 CDT Commodities (big ticket) 3751 329 162096376
76 76 APP Apparel/Clothing Industry/Textiles 2669 396 59984027
77 77 UNM Unemployment 2211 223 20687691
78 78 REL Religion 1802 152 14001925
79 79 DOC District of Columbia 1656 234 42686531
80 80 MON Minting/Money/Gold Standard 1380 218 48498771

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