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 29437 2167 93 119
2 2 Health 27749 2000 93 119
3 3 Government Operations and Politics 25461 2254 93 119
4 4 Armed Forces and National Security 23245 2096 93 119
5 5 Congress 20205 1799 93 119
6 6 International Affairs 19862 1748 93 119
7 7 Public Lands and Natural Resources 16448 1795 93 119
8 8 Foreign Trade and International Finance 15386 1535 93 119
9 9 Crime and Law Enforcement 14681 1817 93 119
10 10 Transportation and Public Works 12693 1835 93 119
11 11 Private Legislation 12318 1268 93 118
12 12 Education 11084 1631 93 119
13 13 Social Welfare 10009 1441 93 119
14 14 Energy 9214 1530 93 119
15 15 Agriculture and Food 9183 1399 93 119
16 16 Finance and Financial Sector 8762 1346 93 119
17 17 Labor and Employment 8507 1462 93 119
18 18 Commemorations 8322 1301 93 110
19 19 Commerce 8274 1506 93 119
20 20 Environmental Protection 8239 1491 93 119
21 21 Economics and Public Finance 7488 1374 93 119
22 22 Immigration 6201 1221 93 119
23 23 Science, Technology, Communications 6126 1294 93 119
24 24 Housing and Community Development 4323 1077 93 119
25 25 Law 4062 1003 93 119
26 26 Native Americans 3561 592 94 119
27 27 Civil Rights and Liberties, Minority Issues 3531 921 93 119
28 28 Water Resources Development 3457 909 93 119
29 29 Emergency Management 3153 961 93 119
30 30 Families 2103 666 93 119
31 31 Arts, Culture, Religion 1905 697 93 119
32 32 Animals 1846 585 93 119
33 33 Sports and Recreation 1839 740 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);