openregs: legislation_policy

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

34 rows

descending

Link	rowid ▼	policy_area	bill_count	sponsor_count	from_congress	to_congress
1	1	Health	18350	1193	108	119
2	2	Taxation	12723	1191	108	119
3	3	Armed Forces and National Security	12419	1192	108	119
4	4	International Affairs	11260	972	108	119
5	5	Government Operations and Politics	10277	1182	108	119
6	6	Crime and Law Enforcement	8328	1034	108	119
7	7	Public Lands and Natural Resources	7828	965	108	119
8	8	Foreign Trade and International Finance	7506	730	108	119
9	9	Education	7152	941	108	119
10	10	Congress	7009	955	108	119
11	11	Transportation and Public Works	5783	954	108	119
12	12	Finance and Financial Sector	5303	780	108	119
13	13	Commerce	4307	812	108	119
14	14	Energy	4283	793	108	119
15	15	Immigration	4252	801	108	119
16	16	Commemorations	4170	617	108	110
17	17	Labor and Employment	3910	716	108	119
18	18	Environmental Protection	3862	747	108	119
19	19	Agriculture and Food	3802	677	108	119
20	20	Science, Technology, Communications	3790	730	108	119
21	21	Economics and Public Finance	2362	606	108	119
22	22	Emergency Management	2209	608	108	119
23	23	Housing and Community Development	2132	556	108	119
24	24	Social Welfare	2123	555	108	119
25	25	Native Americans	2051	326	108	119
26	26	Law	1774	486	108	119
27	27	Civil Rights and Liberties, Minority Issues	1724	460	108	119
28	28	Water Resources Development	1535	442	108	119
29	29	Families	1098	347	108	119
30	30	Sports and Recreation	1010	391	108	119
31	31	Private Legislation	831	230	108	118
32	32	Animals	817	303	108	119
33	33	Arts, Culture, Religion	811	300	108	119
34	34	Social Sciences and History	100	61	109	118

Advanced export

JSON shape: default, array, newline-delimited

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