home / openregs

crec_bills

Bills referenced in Congressional Record floor proceedings. Links floor debate to specific legislation. Cross-references with the legislation table via bill_id.

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

13,082 rows where bill_type = "sconres" sorted by congress descending

✎ View and edit SQL

This data as json, CSV (advanced)

congress 19

  • 108 1,635
  • 110 1,423
  • 107 1,328
  • 106 1,214
  • 111 1,187
  • 109 1,016
  • 105 881
  • 117 715
  • 114 693
  • 112 583
  • 104 546
  • 115 461
  • 113 454
  • 116 373
  • 118 296
  • 119 170
  • 103 91
  • 97 15
  • 100 1

bill_type 1

  • sconres · 13,082 ✖
Link granule_id congress ▲ bill_type bill_number bill_id
CREC-2025-01-06-pt1-PgS33,119,sconres,1 MORNING BUSINESS CREC-2025-01-06-pt1-PgS33 119 sconres 1 119-sconres-1
CREC-2025-01-06-pt1-PgD14-3,119,sconres,2 Daily Digest/House of Representatives CREC-2025-01-06-pt1-PgD14-3 119 sconres 2 119-sconres-2
CREC-2025-01-06-pt1-PgS33,119,sconres,2 MORNING BUSINESS CREC-2025-01-06-pt1-PgS33 119 sconres 2 119-sconres-2
CREC-2025-01-06-pt1-PgS34-3,119,sconres,2 JOINT SESSION OF THE HOUSE AND SENATE FOR COUNTING OF ELECTORAL VOTES CREC-2025-01-06-pt1-PgS34-3 119 sconres 2 119-sconres-2
CREC-2025-01-06-pt1-PgS33,119,sconres,3 MORNING BUSINESS CREC-2025-01-06-pt1-PgS33 119 sconres 3 119-sconres-3
CREC-2025-01-13-pt1-PgD29,119,sconres,4 Daily Digest/Senate CREC-2025-01-13-pt1-PgD29 119 sconres 4 119-sconres-4
CREC-2025-01-13-pt1-PgS89,119,sconres,4 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-01-13-pt1-PgS89 119 sconres 4 119-sconres-4
CREC-2025-01-13-pt1-PgS91,119,sconres,4 SENATE CONCURRENT RESOLUTION 4--EXPRESSING SUPPORT FOR THE GENEVA CONSENSUS DECLARATION ON PROMOTING WOMEN'S HEALTH AND STRENGTHENING THE FAMILY AND URGING THAT THE UNITED STATES REJOIN THIS... CREC-2025-01-13-pt1-PgS91 119 sconres 4 119-sconres-4
CREC-2025-10-06-pt1-PgS6956-3,119,sconres,4 ADDITIONAL COSPONSORS CREC-2025-10-06-pt1-PgS6956-3 119 sconres 4 119-sconres-4
CREC-2025-01-15-pt1-PgD40,119,sconres,5 Daily Digest/Senate CREC-2025-01-15-pt1-PgD40 119 sconres 5 119-sconres-5
CREC-2025-01-15-pt1-PgS186,119,sconres,5 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-01-15-pt1-PgS186 119 sconres 5 119-sconres-5
CREC-2025-01-15-pt1-PgS187,119,sconres,5 SENATE CONCURRENT RESOLUTION 5--EXPRESSING THE SENSE OF CONGRESS THAT THE PROPOSED "JOINT INTERPRETATION" OF ANNEX 14-C OF THE UNITED STATES-MEXICO-CANADA AGREEMENT PREPARED BY UNITED STATES... CREC-2025-01-15-pt1-PgS187 119 sconres 5 119-sconres-5
CREC-2025-01-24-pt1-PgD78,119,sconres,6 Daily Digest/Highlights + Senate CREC-2025-01-24-pt1-PgD78 119 sconres 6 119-sconres-6
CREC-2025-01-24-pt1-PgS371-2,119,sconres,6 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-01-24-pt1-PgS371-2 119 sconres 6 119-sconres-6
CREC-2025-01-24-pt1-PgS374,119,sconres,6 SENATE CONCURRENT RESOLUTION 6--EXPRESSING THE SENSE OF CONGRESS THAT TAX-EXEMPT FRATERNAL BENEFIT SOCIETIES HAVE HISTORICALLY PROVIDED AND CONTINUE TO PROVIDE CRITICAL BENEFITS TO THE PEOPLE AND... CREC-2025-01-24-pt1-PgS374 119 sconres 6 119-sconres-6
CREC-2025-01-30-pt1-PgS524-2,119,sconres,6 ADDITIONAL COSPONSORS CREC-2025-01-30-pt1-PgS524-2 119 sconres 6 119-sconres-6
CREC-2025-02-11-pt1-PgS860-2,119,sconres,6 ADDITIONAL COSPONSORS CREC-2025-02-11-pt1-PgS860-2 119 sconres 6 119-sconres-6
CREC-2025-04-28-pt1-PgS2607-4,119,sconres,6 ADDITIONAL COSPONSORS CREC-2025-04-28-pt1-PgS2607-4 119 sconres 6 119-sconres-6
CREC-2025-07-15-pt1-PgS4369-2,119,sconres,6 ADDITIONAL COSPONSORS CREC-2025-07-15-pt1-PgS4369-2 119 sconres 6 119-sconres-6
CREC-2026-01-28-pt1-PgS344-3,119,sconres,6 ADDITIONAL COSPONSORS CREC-2026-01-28-pt1-PgS344-3 119 sconres 6 119-sconres-6
CREC-2026-02-03-pt1-PgS470-3,119,sconres,6 ADDITIONAL COSPONSORS CREC-2026-02-03-pt1-PgS470-3 119 sconres 6 119-sconres-6
CREC-2025-02-13-pt1-PgD151,119,sconres,7 Daily Digest/Highlights + Senate CREC-2025-02-13-pt1-PgD151 119 sconres 7 119-sconres-7
CREC-2025-02-13-pt1-PgS970-5,119,sconres,7 REPORTS OF COMMITTEES CREC-2025-02-13-pt1-PgS970-5 119 sconres 7 119-sconres-7
CREC-2025-02-13-pt1-PgS972,119,sconres,7 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-02-13-pt1-PgS972 119 sconres 7 119-sconres-7
CREC-2025-02-13-pt1-PgS982-2,119,sconres,7 SENATE CONCURRENT RESOLUTION 7--SETTING FORTH THE CONGRESSIONAL BUDGET FOR THE UNITED STATES GOVERNMENT FOR FISCAL YEAR 2025 AND SETTING FORTH THE APPROPRIATE BUDGETARY LEVELS FOR FISCAL YEARS 2026... CREC-2025-02-13-pt1-PgS982-2 119 sconres 7 119-sconres-7
CREC-2025-02-18-pt1-PgD157,119,sconres,7 Daily Digest/Highlights + Senate CREC-2025-02-18-pt1-PgD157 119 sconres 7 119-sconres-7
CREC-2025-02-18-pt1-PgD158-5,119,sconres,7 Daily Digest/CONGRESSIONAL PROGRAM AHEAD CREC-2025-02-18-pt1-PgD158-5 119 sconres 7 119-sconres-7
CREC-2025-02-18-pt1-PgD159,119,sconres,7 Daily Digest/The CONGRESSIONAL RECORD (USPS 087-390). CREC-2025-02-18-pt1-PgD159 119 sconres 7 119-sconres-7
CREC-2025-02-18-pt1-PgS1006-7,119,sconres,7 SETTING FORTH THE CONGRESSIONAL BUDGET FOR THE UNITED STATES GOVERNMENT FOR FISCAL YEAR 2025 AND SETTING FORTH THE APPROPRIATE BUDGETARY LEVELS FOR FISCAL YEARS 2026 THROUGH 2034--Motion to Proceed CREC-2025-02-18-pt1-PgS1006-7 119 sconres 7 119-sconres-7
CREC-2025-02-18-pt1-PgS1007,119,sconres,7 SETTING FORTH THE CONGRESSIONAL BUDGET FOR THE UNITED STATES GOVERNMENT FOR FISCAL YEAR 2025 AND SETTING FORTH THE APPROPRIATE BUDGETARY LEVELS FOR FISCAL YEARS 2026 THROUGH 2034 CREC-2025-02-18-pt1-PgS1007 119 sconres 7 119-sconres-7
CREC-2025-02-18-pt1-PgS1011-3,119,sconres,7 ORDERS FOR WEDNESDAY, FEBRUARY 18, 2025 CREC-2025-02-18-pt1-PgS1011-3 119 sconres 7 119-sconres-7
CREC-2025-02-19-pt1-PgD161,119,sconres,7 Daily Digest/Highlights + Senate CREC-2025-02-19-pt1-PgD161 119 sconres 7 119-sconres-7
CREC-2025-02-19-pt1-PgD163-2,119,sconres,7 Daily Digest/The CONGRESSIONAL RECORD (USPS 087-390). CREC-2025-02-19-pt1-PgD163-2 119 sconres 7 119-sconres-7
CREC-2025-02-19-pt1-PgS1015-6,119,sconres,7 LEGISLATIVE SESSION CREC-2025-02-19-pt1-PgS1015-6 119 sconres 7 119-sconres-7
CREC-2025-02-19-pt1-PgS1043-2,119,sconres,7 AMENDMENTS SUBMITTED AND PROPOSED CREC-2025-02-19-pt1-PgS1043-2 119 sconres 7 119-sconres-7
CREC-2025-02-19-pt1-PgS1044,119,sconres,7 TEXT OF AMENDMENTS CREC-2025-02-19-pt1-PgS1044 119 sconres 7 119-sconres-7
CREC-2025-02-19-pt1-PgS1047-7,119,sconres,7 Text of Senate Amendment 123 CREC-2025-02-19-pt1-PgS1047-7 119 sconres 7 119-sconres-7
CREC-2025-02-19-pt1-PgS1049-8,119,sconres,7 Text of Senate Amendment 137 CREC-2025-02-19-pt1-PgS1049-8 119 sconres 7 119-sconres-7
CREC-2025-02-19-pt1-PgS1053-2,119,sconres,7 ORDERS FOR THURSDAY, FEBRUARY 20, 2025 CREC-2025-02-19-pt1-PgS1053-2 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgD165,119,sconres,7 Daily Digest/Highlights + Senate CREC-2025-02-20-pt1-PgD165 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1061-6,119,sconres,7 LEGISLATIVE SESSION CREC-2025-02-20-pt1-PgS1061-6 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1075-2,119,sconres,7 LEGISLATIVE SESSION CREC-2025-02-20-pt1-PgS1075-2 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1127-2,119,sconres,7 ADDITIONAL COSPONSORS CREC-2025-02-20-pt1-PgS1127-2 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1137,119,sconres,7 AMENDMENTS SUBMITTED AND PROPOSED CREC-2025-02-20-pt1-PgS1137 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1154,119,sconres,7 TEXT OF AMENDMENTS CREC-2025-02-20-pt1-PgS1154 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1157-8,119,sconres,7 Text of Senate Amendment 189 CREC-2025-02-20-pt1-PgS1157-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1169-7,119,sconres,7 Text of Senate Amendment 274 CREC-2025-02-20-pt1-PgS1169-7 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1180-8,119,sconres,7 Text of Senate Amendment 351 CREC-2025-02-20-pt1-PgS1180-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1185-8,119,sconres,7 Text of Senate Amendment 385 CREC-2025-02-20-pt1-PgS1185-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1205-7,119,sconres,7 Text of Senate Amendment 524 CREC-2025-02-20-pt1-PgS1205-7 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1208-8,119,sconres,7 Text of Senate Amendment 546 CREC-2025-02-20-pt1-PgS1208-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1213-8,119,sconres,7 Text of Senate Amendment 586 CREC-2025-02-20-pt1-PgS1213-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1216-8,119,sconres,7 Text of Senate Amendment 611 CREC-2025-02-20-pt1-PgS1216-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1226-8,119,sconres,7 Text of Senate Amendment 684 CREC-2025-02-20-pt1-PgS1226-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1234-8,119,sconres,7 Text of Senate Amendment 742 CREC-2025-02-20-pt1-PgS1234-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1236-7,119,sconres,7 Text of Senate Amendment 756 CREC-2025-02-20-pt1-PgS1236-7 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1238-8,119,sconres,7 Text of Senate Amendment 771 CREC-2025-02-20-pt1-PgS1238-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1240-8,119,sconres,7 Text of Senate Amendment 786 CREC-2025-02-20-pt1-PgS1240-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1244-8,119,sconres,7 Text of Senate Amendment 815 CREC-2025-02-20-pt1-PgS1244-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1254-7,119,sconres,7 Text of Senate Amendment 887 CREC-2025-02-20-pt1-PgS1254-7 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1255-8,119,sconres,7 Text of Senate Amendment 895 CREC-2025-02-20-pt1-PgS1255-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1260-8,119,sconres,7 Text of Senate Amendment 932 CREC-2025-02-20-pt1-PgS1260-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1276-8,119,sconres,7 Text of Senate Amendment 1045 CREC-2025-02-20-pt1-PgS1276-8 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1277-7,119,sconres,7 Text of Senate Amendment 1052 CREC-2025-02-20-pt1-PgS1277-7 119 sconres 7 119-sconres-7
CREC-2025-02-20-pt1-PgS1303,119,sconres,7 PRIVILEGES OF THE FLOOR CREC-2025-02-20-pt1-PgS1303 119 sconres 7 119-sconres-7
CREC-2025-03-03-pt1-PgD204,119,sconres,8 Daily Digest/Highlights + Senate CREC-2025-03-03-pt1-PgD204 119 sconres 8 119-sconres-8
CREC-2025-03-03-pt1-PgS1460,119,sconres,8 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-03-03-pt1-PgS1460 119 sconres 8 119-sconres-8
CREC-2025-03-03-pt1-PgS1463,119,sconres,8 SUBMITTED RESOLUTIONS CREC-2025-03-03-pt1-PgS1463 119 sconres 8 119-sconres-8
CREC-2025-03-10-pt1-PgS1630-2,119,sconres,8 ADDITIONAL COSPONSORS CREC-2025-03-10-pt1-PgS1630-2 119 sconres 8 119-sconres-8
CREC-2025-03-14-pt1-PgS1777-2,119,sconres,8 ADDITIONAL COSPONSORS CREC-2025-03-14-pt1-PgS1777-2 119 sconres 8 119-sconres-8
CREC-2025-04-29-pt1-PgS2664-2,119,sconres,8 ADDITIONAL COSPONSORS CREC-2025-04-29-pt1-PgS2664-2 119 sconres 8 119-sconres-8
CREC-2025-05-06-pt1-PgS2775-2,119,sconres,8 ADDITIONAL COSPONSORS CREC-2025-05-06-pt1-PgS2775-2 119 sconres 8 119-sconres-8
CREC-2025-07-30-pt1-PgS4905-2,119,sconres,8 ADDITIONAL COSPONSORS CREC-2025-07-30-pt1-PgS4905-2 119 sconres 8 119-sconres-8
CREC-2025-03-10-pt1-PgD235,119,sconres,9 Daily Digest/Highlights + Senate CREC-2025-03-10-pt1-PgD235 119 sconres 9 119-sconres-9
CREC-2025-03-10-pt1-PgS1630,119,sconres,9 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-03-10-pt1-PgS1630 119 sconres 9 119-sconres-9
CREC-2025-03-10-pt1-PgS1633-2,119,sconres,9 SENATE CONCURRENT RESOLUTION 9--EXPRESSING SUPPORT FOR THE RECOGNITION OF MARCH 10, 2025, AS "ABORTION PROVIDER APPRECIATION DAY" CREC-2025-03-10-pt1-PgS1633-2 119 sconres 9 119-sconres-9
CREC-2025-09-15-pt1-PgS6602-3,119,sconres,9 SENATE CONCURRENT RESOLUTION 22--SETTING FORTH THE CONGRESSIONAL BUDGET FOR THE UNITED STATES GOVERNMENT FOR FISCAL YEAR 2026 AND SETTING FORTH THE APPROPRIATE BUDGETARY LEVELS FOR FISCAL YEARS... CREC-2025-09-15-pt1-PgS6602-3 119 sconres 9 119-sconres-9
CREC-2025-02-13-pt1-PgS982-2,119,sconres,11 SENATE CONCURRENT RESOLUTION 7--SETTING FORTH THE CONGRESSIONAL BUDGET FOR THE UNITED STATES GOVERNMENT FOR FISCAL YEAR 2025 AND SETTING FORTH THE APPROPRIATE BUDGETARY LEVELS FOR FISCAL YEARS 2026... CREC-2025-02-13-pt1-PgS982-2 119 sconres 11 119-sconres-11
CREC-2025-02-20-pt1-PgS1075-2,119,sconres,11 LEGISLATIVE SESSION CREC-2025-02-20-pt1-PgS1075-2 119 sconres 11 119-sconres-11
CREC-2025-03-31-pt1-PgS1924,119,sconres,11 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-03-31-pt1-PgS1924 119 sconres 11 119-sconres-11
CREC-2025-03-31-pt1-PgS1931,119,sconres,11 SUBMITTED RESOLUTIONS CREC-2025-03-31-pt1-PgS1931 119 sconres 11 119-sconres-11
CREC-2025-04-03-pt1-PgS2190,119,sconres,11 TEXT OF AMENDMENTS CREC-2025-04-03-pt1-PgS2190 119 sconres 11 119-sconres-11
CREC-2025-04-03-pt1-PgS2250-6,119,sconres,11 Text of Senate Amendment 1717 CREC-2025-04-03-pt1-PgS2250-6 119 sconres 11 119-sconres-11
CREC-2025-04-09-pt1-PgH1533-2,119,sconres,11 CONCURRENT RESOLUTION ON THE BUDGET FOR FISCAL YEAR 2025 CREC-2025-04-09-pt1-PgH1533-2 119 sconres 11 119-sconres-11
CREC-2025-05-05-pt1-PgD425,119,sconres,12 Daily Digest/Senate CREC-2025-05-05-pt1-PgD425 119 sconres 12 119-sconres-12
CREC-2025-05-05-pt1-PgS2753,119,sconres,12 AUTHORIZING THE USE OF EMANCIPATION HALL IN THE CAPITOL VISITOR CENTER FOR A CEREMONY TO PRESENT THE CONGRESSIONAL GOLD MEDAL, COLLECTIVELY, TO THE UNITED STATES ARMY RANGERS VETERANS OF WORLD WAR II CREC-2025-05-05-pt1-PgS2753 119 sconres 12 119-sconres-12
CREC-2025-05-05-pt1-PgS2756,119,sconres,12 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-05-05-pt1-PgS2756 119 sconres 12 119-sconres-12
CREC-2025-05-05-pt1-PgS2760,119,sconres,12 SENATE CONCURRENT RESOLUTION 12--AUTHORIZING THE USE OF EMANCIPATION HALL IN THE CAPITOL VISITOR CENTER FOR A CEREMONY TO PRESENT THE CONGRESSIONAL GOLD MEDAL, COLLECTIVELY, TO THE UNITED STATES... CREC-2025-05-05-pt1-PgS2760 119 sconres 12 119-sconres-12
CREC-2025-05-07-pt1-PgD442-2,119,sconres,12 Daily Digest/House of Representatives CREC-2025-05-07-pt1-PgD442-2 119 sconres 12 119-sconres-12
CREC-2025-05-07-pt1-PgH1890-6,119,sconres,12 COMMUNICATION FROM THE CLERK OF THE HOUSE CREC-2025-05-07-pt1-PgH1890-6 119 sconres 12 119-sconres-12
CREC-2025-05-08-pt1-PgD451,119,sconres,12 Daily Digest/House of Representatives CREC-2025-05-08-pt1-PgD451 119 sconres 12 119-sconres-12
CREC-2025-05-08-pt1-PgH1921-2,119,sconres,12 AUTHORIZING THE USE OF EMANCIPATION HALL IN THE CAPITOL VISITOR CENTER FOR A CEREMONY TO PRESENT THE CONGRESSIONAL GOLD MEDAL, COLLECTIVELY, TO THE UNITED STATES ARMY RANGERS VETERANS OF WORLD WAR II CREC-2025-05-08-pt1-PgH1921-2 119 sconres 12 119-sconres-12
CREC-2025-05-08-pt1-PgS2832-3,119,sconres,12 MESSAGES FROM THE HOUSE CREC-2025-05-08-pt1-PgS2832-3 119 sconres 12 119-sconres-12
CREC-2025-02-13-pt1-PgS982-2,119,sconres,13 SENATE CONCURRENT RESOLUTION 7--SETTING FORTH THE CONGRESSIONAL BUDGET FOR THE UNITED STATES GOVERNMENT FOR FISCAL YEAR 2025 AND SETTING FORTH THE APPROPRIATE BUDGETARY LEVELS FOR FISCAL YEARS 2026... CREC-2025-02-13-pt1-PgS982-2 119 sconres 13 119-sconres-13
CREC-2025-02-20-pt1-PgS1075-2,119,sconres,13 LEGISLATIVE SESSION CREC-2025-02-20-pt1-PgS1075-2 119 sconres 13 119-sconres-13
CREC-2025-04-03-pt1-PgS2190,119,sconres,13 TEXT OF AMENDMENTS CREC-2025-04-03-pt1-PgS2190 119 sconres 13 119-sconres-13
CREC-2025-04-03-pt1-PgS2250-6,119,sconres,13 Text of Senate Amendment 1717 CREC-2025-04-03-pt1-PgS2250-6 119 sconres 13 119-sconres-13
CREC-2025-04-09-pt1-PgH1533-2,119,sconres,13 CONCURRENT RESOLUTION ON THE BUDGET FOR FISCAL YEAR 2025 CREC-2025-04-09-pt1-PgH1533-2 119 sconres 13 119-sconres-13
CREC-2025-05-06-pt1-PgD434,119,sconres,13 Daily Digest/Senate CREC-2025-05-06-pt1-PgD434 119 sconres 13 119-sconres-13
CREC-2025-05-06-pt1-PgS2775,119,sconres,13 SUBMISSION OF CONCURRENT AND SENATE RESOLUTIONS CREC-2025-05-06-pt1-PgS2775 119 sconres 13 119-sconres-13

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE crec_bills (
    granule_id TEXT NOT NULL REFERENCES congressional_record(granule_id),
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    bill_id TEXT,
    PRIMARY KEY (granule_id, congress, bill_type, bill_number)
);
CREATE INDEX idx_crec_bill_id ON crec_bills(bill_id);
CREATE INDEX idx_crec_bill_type ON crec_bills(bill_type, bill_number);
Powered by Datasette · Queries took 772.619ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API