legislation_policy_summary

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

717 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: from_congress, to_congress

Link rowid ▼ policy_area bill_count sponsor_count from_congress to_congress
1 1 Taxation 30587 2172 93 119
2 2 Health 28765 2014 93 119
3 3 Government Operations and Politics 25943 2264 93 119
4 4 Armed Forces and National Security 23790 2107 93 119
5 5 Congress 20801 1814 93 119
6 6 International Affairs 20481 1761 93 119
7 7 Public Lands and Natural Resources 17023 1806 93 119
8 8 Foreign Trade and International Finance 16301 1545 93 119
9 9 Crime and Law Enforcement 15137 1829 93 119
10 10 Transportation and Public Works 13028 1855 93 119
11 11 Private Legislation 12495 1285 93 118
12 12 Education 11472 1645 93 119
13 13 Social Welfare 10196 1450 93 119
14 14 Agriculture and Food 9429 1411 93 119
15 15 Energy 9424 1541 93 119
16 16 Commemorations 9340 1311 93 110
17 17 Finance and Financial Sector 8978 1358 93 119
18 18 Labor and Employment 8734 1482 93 119
19 19 Commerce 8503 1522 93 119
20 20 Environmental Protection 8435 1495 93 119
21 21 Economics and Public Finance 7638 1381 93 119
22 22 Immigration 6386 1236 93 119
23 23 Science, Technology, Communications 6289 1301 93 119
24 24 Housing and Community Development 4425 1085 93 119
25 25 Law 4173 1013 93 119
26 26 Native Americans 3668 599 94 119
27 27 Water Resources Development 3611 916 93 119
28 28 Civil Rights and Liberties, Minority Issues 3599 924 93 119
29 29 Emergency Management 3227 974 93 119
30 30 Families 2189 674 93 119
31 31 Arts, Culture, Religion 1921 698 93 119
32 32 Animals 1888 589 93 119
33 33 Sports and Recreation 1857 745 93 119
34 34 Social Sciences and History 500 281 93 118
35 35 Constitutional amendments 476 220 93 95
36 36 Income tax 290 131 95 95
37 37 Public works 290 154 93 95
38 38 Motor vehicles 281 152 93 95
39 39 Monuments and memorials 275 125 93 95
40 40 Petroleum industry 251 146 93 93
41 41 Territories (U.S.) 250 78 93 95
42 42 District of Columbia 249 67 93 94
43 43 Right of privacy 229 77 93 95
44 44 Postal service 215 110 94 94
45 45 Independent regulatory commissions 198 91 93 95
46 46 Vietnamese Conflict 185 92 93 94
47 47 Disabled 175 86 93 95
48 48 Rivers 165 105 93 95
49 49 Abortion 164 80 93 95
50 50 Cemeteries and funerals 141 73 94 95
51 51 Government publications 138 75 93 95
52 52 Congressional-executive relations 133 76 93 95
53 53 Federal advisory bodies 122 88 94 95
54 54 Administrative procedure 113 53 94 95
55 55 Credit 112 57 93 95
56 56 Executive reorganization 109 78 93 94
57 57 Awards, medals, prizes 106 76 93 95
58 58 Congressional oversight 101 57 94 95
59 59 Mines and mineral resources 98 61 93 94
60 60 Terrorism 97 37 94 95
61 61 Recreation areas 95 62 93 95
62 62 Congressional tributes 94 55 95 95
63 63 Impeachments 91 48 93 95
64 64 Congressional-Presidential relations 89 56 93 95
65 65 Drugs 86 45 93 95
66 66 Economic stabilization 86 58 93 95
67 67 Tobacco 86 45 93 95
68 68 Lotteries 82 50 93 95
69 69 Youth 81 46 93 94
70 70 Firearms 79 59 94 94
71 71 Power resources 79 49 94 94
72 72 Rural affairs legislation 79 46 93 94
73 73 Child welfare 78 37 93 95
74 74 Intergovernmental relations 75 63 93 95
75 75 Meat 73 57 93 93
76 76 Agriculture in foreign trade 70 43 95 95
77 77 Alcoholic beverages 67 50 93 95
78 78 Refugees 66 30 94 95
79 79 Import restrictions 64 40 95 95
80 80 Narcotic law and legislation 63 39 93 94
81 81 Claims 61 46 93 95
82 82 Lobbying 61 36 94 94
83 83 Strategic materials 60 40 93 94
84 84 Drug law and legislation 58 22 93 94
85 85 Marine mammal protection 58 21 95 95
86 86 Solar energy 55 22 95 95
87 87 Industrial relations 53 32 94 95
88 88 Minorities 53 34 93 95
89 89 Water conservation 53 29 93 95
90 90 Broadcasting 52 37 95 95
91 91 Gold 50 20 93 94
92 92 Women 49 24 93 94
93 93 Libraries 48 28 94 95
94 94 Dams 47 36 93 93
95 95 Narcotics 46 29 93 95
96 96 Conservation of natural resources 45 36 93 95
97 97 Federal aid programs 45 32 93 95
98 98 Citizenship 44 30 94 95
99 99 Salaries 44 36 95 95
100 100 Child abuse 43 18 95 95

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE legislation_policy_summary(
  policy_area TEXT,
  bill_count,
  sponsor_count,
  from_congress,
  to_congress
);
CREATE UNIQUE INDEX idx_lps_area ON legislation_policy_summary(policy_area);