legislation
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
713 rows where congress = 100 and policy_area = "Commemorations" sorted by introduced_date descending
This data as json, CSV (advanced)
Suggested facets: origin_chamber, sponsor_party, update_date, introduced_date (date), latest_action_date (date), update_date (date)
| bill_id | congress | bill_type | bill_number | title | policy_area | introduced_date ▲ | latest_action_date | latest_action_text | origin_chamber | sponsor_name | sponsor_state | sponsor_party | sponsor_bioguide_id | cosponsor_count | summary_text | update_date | url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100-sjres-395 | 100 | sjres | 395 | A joint resolution to designate January 4, 1989, as "National Commissioned Corps of the Public Health Service Centennial Day". | Commemorations | 1988-10-21 | 1988-11-10 | Became Public Law No: 100-652. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 29 | Designates January 4, 1989, as National Commissioned Corps of the Public Health Service Centennial Day. | 2022-12-13T14:41:13Z | |
| 100-hjres-676 | 100 | hjres | 676 | A joint resolution designating December 7, 1988 as "National Pearl Harbor Remembrance Day" on the occasion of the anniversary of the attack on Pearl Harbor. | Commemorations | 1988-10-19 | 1988-10-19 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Courter, Jim [R-NJ-12] | NJ | R | C000809 | 55 | Designates December 7, 1988, as National Pearl Harbor Remembrance Day. | 2024-02-06T20:04:02Z | |
| 100-sres-501 | 100 | sres | 501 | A resolution to commemorate the dedication of the Russian Bishops House in Sitka, Alaska on Alaska Day, October 18, 1988. | Commemorations | 1988-10-17 | 1988-10-17 | Submitted in the Senate, considered, and agreed to without amendment and with a preamble by Voice Vote. | Senate | Sen. Stevens, Ted [R-AK] | AK | R | S000888 | 1 | Declares that the Senate sends its congratulations to the National Park Service and the people of Sitka, Alaska, on the dedication of the Russian Bishops House on Alaska Day. Designates October 18, 1988, as Russian-American Heritage Day. | 2021-06-10T21:50:45Z | |
| 100-hjres-674 | 100 | hjres | 674 | A joint resolution to designate June 15, 1989, as "American Victims of Terrorism Day". | Commemorations | 1988-10-13 | 1988-10-13 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Snowe, Olympia J. [R-ME-2] | ME | R | S000663 | 0 | Designates June 15, 1989, as American Victims of Terrorism Day. | 2024-02-06T20:04:02Z | |
| 100-sjres-393 | 100 | sjres | 393 | A joint resolution to designate December 7, 1988, as "National Pearl Harbor Remembrance Day" on the occasion of the anniversary of the attack on Pearl Harbor. | Commemorations | 1988-10-05 | 1988-10-05 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Lautenberg, Frank R. [D-NJ] | NJ | D | L000123 | 26 | Designates December 7, 1988, as National Pearl Harbor Remembrance Day. | 2025-07-21T19:32:26Z | |
| 100-hjres-672 | 100 | hjres | 672 | A joint resolution to designate January 4, 1989, as "National Commissioned Corps of the Public Health Service Centennial Day". | Commemorations | 1988-10-04 | 1988-10-21 | Received in the Senate and read twice and referred to the Committee on Judiciary. | House | Rep. Waxman, Henry A. [D-CA-24] | CA | D | W000215 | 1 | Designates January 4, 1989, as National Commissioned Corps of the Public Health Service Centennial Day. | 2025-07-21T19:32:26Z | |
| 100-hjres-670 | 100 | hjres | 670 | A joint resolution to designate September 15, 1989, as "National Respect for the Elderly Day". | Commemorations | 1988-09-30 | 1988-09-30 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Skelton, Ike [D-MO-4] | MO | D | S000465 | 29 | Designates September 15, 1989, as National Respect for the Elderly Day. | 2024-02-06T20:04:02Z | |
| 100-sjres-390 | 100 | sjres | 390 | A joint resolution designating November 7, 1988, as "The Memorial Day for Victims of Communism". | Commemorations | 1988-09-30 | 1988-09-30 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. D'Amato, Alfonse [R-NY] | NY | R | D000018 | 0 | Designates November 7, 1988, as Memorial Day for Victims of Communism. | 2025-07-21T19:32:26Z | |
| 100-sjres-391 | 100 | sjres | 391 | A joint resolution designating November 4 through 10, 1988, as the "Week of Remembrance of Kristallnacht". | Commemorations | 1988-09-30 | 1988-09-30 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Dodd, Christopher J. [D-CT] | CT | D | D000388 | 1 | Designates November 4 through November 10, 1988, as the Week of Remembrance of Kristallnacht (the Night of Broken Glass). | 2025-07-21T19:32:26Z | |
| 100-hjres-669 | 100 | hjres | 669 | A joint resolution to designate October 14, 1988, as "National Day of Remembrance for Political Prisoners in Iran". | Commemorations | 1988-09-29 | 1988-10-21 | Received in the Senate and read twice and referred to the Committee on Judiciary. | House | Rep. Dymally, Mervyn M. [D-CA-31] | CA | D | D000592 | 231 | (Measure passed House, amended) Designates June 20, 1989, as National Day of Remembrance for Political Prisoners in Iran. | 2025-07-21T19:32:26Z | |
| 100-hjres-666 | 100 | hjres | 666 | A joint resolution to designate October 14, 1988, as "National Day of Remembrance for Political Prisoners in Iran". | Commemorations | 1988-09-28 | 1988-09-28 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Dymally, Mervyn M. [D-CA-31] | CA | D | D000592 | 0 | Designates October 14, 1988, as National Day of Remembrance for Political Prisoners in Iran. | 2024-02-06T20:04:02Z | |
| 100-hjres-667 | 100 | hjres | 667 | A joint resolution to designate the week of June 18 through June 24, 1989, as "National Grasslands Week". | Commemorations | 1988-09-28 | 1988-09-28 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Dorgan, Byron L. [D-ND-At Large] | ND | D | D000432 | 18 | Designates the week of June 18 through June 24, 1989, as National Grasslands Week. | 2024-02-06T20:04:02Z | |
| 100-sjres-388 | 100 | sjres | 388 | A joint resolution designating October 15, 1988, as "National Fire Fighters Day". | Commemorations | 1988-09-28 | 1988-09-28 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Gore, Albert, Jr. [D-TN] | TN | D | G000321 | 50 | Designates October 15, 1988, as National Fire Fighters Day. | 2025-07-21T19:32:26Z | |
| 100-sjres-386 | 100 | sjres | 386 | A joint resolution to designate the week of June 18 through June 24, 1989 as "National Grasslands Week". | Commemorations | 1988-09-27 | 1988-11-15 | Became Public Law No: 100-664. | Senate | Sen. Conrad, Kent [D-ND] | ND | D | C000705 | 53 | Designates the week of June 18 through June 24, 1989, as National Grasslands Week. | 2025-07-21T19:32:26Z | |
| 100-hjres-664 | 100 | hjres | 664 | A joint resolution designating the week of December 4, 1988 as "National Humanities Week". | Commemorations | 1988-09-26 | 1988-09-26 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Yates, Sidney R. [D-IL-9] | IL | D | Y000013 | 0 | Designates the week of December 4 through December 10, 1988, as National Humanities Week. | 2024-02-06T20:04:02Z | |
| 100-sjres-385 | 100 | sjres | 385 | A joint resolution to designate September 11 through 17, 1988, as "National Youth 2000 Week". | Commemorations | 1988-09-26 | 1988-10-12 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 50 | Designates the week beginning September 11, 1988, as National Youth 2000 Week. | 2025-07-21T19:32:26Z | |
| 100-hjres-662 | 100 | hjres | 662 | A joint resolution to designate May 25, 1989, as "National Tap Dance Day". | Commemorations | 1988-09-23 | 1988-09-23 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Conyers, John, Jr. [D-MI-1] | MI | D | C000714 | 35 | Designates May 25, 1989, as National Tap Dance Day. | 2024-02-06T20:04:02Z | |
| 100-hjres-660 | 100 | hjres | 660 | A joint resolution to designate October 30, 1988 as "Fire Safety at Home Day - Change Your Clock, Change Your Battery". | Commemorations | 1988-09-22 | 1988-09-22 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Walgren, Doug [D-PA-18] | PA | D | W000044 | 219 | Designates October 30, 1988, as Fire Safety at Home Day: Change Your Clock, Change Your Battery. | 2024-02-06T20:04:02Z | |
| 100-hjres-661 | 100 | hjres | 661 | A joint resolution designating October 5, 1988, as "Raoul Wallenberg Day". | Commemorations | 1988-09-22 | 1988-09-22 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Weiss, Ted [D-NY-17] | NY | D | W000258 | 197 | Designates October 5, 1988, as Raoul Wallenberg Recognition Day. | 2024-02-06T20:04:02Z | |
| 100-sjres-383 | 100 | sjres | 383 | A joint resolution to designate the period commencing December 4, 1988, and ending December 10, 1988, as National Humanities Week. | Commemorations | 1988-09-22 | 1988-09-22 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Pell, Claiborne [D-RI] | RI | D | P000193 | 1 | Designates the week of December 4 through December 10, 1988, as National Humanities Week. | 2025-07-21T19:32:26Z | |
| 100-sjres-381 | 100 | sjres | 381 | A joint resolution to designate October 30, 1988 as "Fire Safety at Home Day - Change Your Clock, Change Your Battery". | Commemorations | 1988-09-19 | 1988-11-03 | Became Public Law No: 100-604. | Senate | Sen. Bond, Christopher S. [R-MO] | MO | R | B000611 | 37 | Designates October 30, 1988, as Fire Safety at Home Day--Change Your Clock, Change Your Battery. | 2025-07-21T19:32:26Z | |
| 100-hjres-658 | 100 | hjres | 658 | A joint resolution designating the week of January 15-21, 1989, as "National Jaycee Week". | Commemorations | 1988-09-16 | 1988-09-16 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Inhofe, James M. [R-OK-1] | OK | R | I000024 | 0 | Designates the week of January 15 through January 21, 1989, as National Jaycee Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-655 | 100 | hjres | 655 | A joint resolution designating the week of September 25, 1988, through October 1, 1988, as "Iron Overload Diseases Awareness Week". | Commemorations | 1988-09-15 | 1988-09-15 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Hutto, Earl [D-FL-1] | FL | D | H001018 | 0 | Designates the week of September 25 through October 1, 1988, as Iron Overload Diseases Awareness Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-653 | 100 | hjres | 653 | A joint resolution designating October 14 through 20, 1988, as "National Culinary Week". | Commemorations | 1988-09-14 | 1988-09-14 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Panetta, Leon [D-CA-16] | CA | D | P000047 | 38 | Designates October 14 through October 20, 1988, as National Culinary Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-654 | 100 | hjres | 654 | A joint resolution designating November 4 through 10, 1988, as the "Week of Remembrance of Kristallnacht". | Commemorations | 1988-09-14 | 1988-11-07 | Became Public Law No: 100-632. | House | Rep. Schumer, Charles E. [D-NY-10] | NY | D | S000148 | 69 | Designates November 4 through November 10, 1988, as the Week of Remembrance of Kristallnacht (the Night of Broken Glass). | 2024-02-06T20:04:02Z | |
| 100-sjres-378 | 100 | sjres | 378 | A joint resolution designating the week of October 2 through 8, 1988, as "National Wild and Scenic Rivers Act Week". | Commemorations | 1988-09-14 | 1988-11-05 | Became Public Law No: 100-624. | Senate | Sen. Heinz, John [R-PA] | PA | R | H000456 | 10 | Designates the week of October 2 through October 8, 1988, as National Wild and Scenic Rivers Act Week, marking the 20th anniversary of the Act. | 2025-07-21T19:32:26Z | |
| 100-hjres-650 | 100 | hjres | 650 | A joint resolution designating April 1989 as "Actors' Fund of America Appreciation Month". | Commemorations | 1988-09-13 | 1988-11-18 | Became Public Law No: 100-686. | House | Rep. Coelho, Anthony Lee [D-CA-15] | CA | D | C000581 | 22 | Designates the month of April 1989 as Actors' Fund of America Appreciation Month. | 2025-07-21T19:32:26Z | |
| 100-hjres-651 | 100 | hjres | 651 | A joint resolution to designate the week of December 11, 1988, through December 17, 1988, as "National Drunk and Drugged Driving Awareness Week". | Commemorations | 1988-09-13 | 1988-09-13 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Morella, Constance A. [R-MD-8] | MD | R | M000941 | 142 | Designates the week of December 11 through December 17, 1988, as National Drunk and Drugged Driving Awareness Week. | 2024-02-06T20:04:02Z | |
| 100-hconres-363 | 100 | hconres | 363 | A concurrent resolution recognizing the 100th anniversary of the Loyal Order of Moose and commending the accomplishments of its members in providing civic, charitable, and benevolent service to their fellow citizens in the finest spirit of American voluntarism. | Commemorations | 1988-09-09 | 1988-09-09 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Bilirakis, Michael [R-FL-9] | FL | R | B000463 | 50 | Recognizes the 100th anniversary of the Loyal Order of Moose and commends the accomplishments of its members in providing service in the spirit of voluntarism. | 2024-02-06T20:04:02Z | |
| 100-hjres-649 | 100 | hjres | 649 | A joint resolution designating October 15, 1988, as "National Fire Fighters Day". | Commemorations | 1988-09-09 | 1988-11-10 | Became Public Law No: 100-651. | House | Rep. Weldon, Curt [R-PA-7] | PA | R | W000268 | 139 | (Measure passed House, amended) Designates November 12, 1988, as National Firefighters Day. | 2024-02-06T20:04:02Z | |
| 100-sjres-376 | 100 | sjres | 376 | A joint resolution designating September 13, 1989, as "Uncle Sam Day". | Commemorations | 1988-09-09 | 1988-09-09 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. D'Amato, Alfonse [R-NY] | NY | R | D000018 | 19 | Designates September 13, 1989, as Uncle Sam Day in honor of Samuel Wilson of the city of Troy, New York, on the occasion of the 200th anniversary of the City. (Samuel Wilson was the progenitor of the national symbol, Uncle Sam.) | 2025-07-21T19:32:26Z | |
| 100-sjres-375 | 100 | sjres | 375 | A joint resolution designating October 22, 1988, as "National Chester F. Carlson Recognition Day". | Commemorations | 1988-09-08 | 1988-09-08 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Moynihan, Daniel Patrick [D-NY] | NY | D | M001054 | 8 | Designates October 22, 1988, as National Chester F. Carlson Recognition Day. | 2025-07-21T19:32:26Z | |
| 100-hjres-647 | 100 | hjres | 647 | A joint resolution designating September 24, 1989, as "United States Marshals Bicentennial Day". | Commemorations | 1988-09-07 | 1988-09-07 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Kastenmeier, Robert W. [D-WI-2] | WI | D | K000020 | 152 | Designates September 24, 1989, as United States Marshals Bicentennial Day. | 2024-02-06T20:04:02Z | |
| 100-sjres-372 | 100 | sjres | 372 | A joint resolution to designate the week beginning November 21,1988, through November 27, 1988, as "National Adoption Week". | Commemorations | 1988-09-07 | 1988-10-12 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 60 | Designates the week of November 21 through November 27, 1988, as National Adoption Week. | 2025-07-21T19:32:26Z | |
| 100-sjres-373 | 100 | sjres | 373 | A joint resolution to designate the week beginning November 13, 1988, as "National Craniofacial Deformity Awareness Week". | Commemorations | 1988-09-07 | 1988-09-07 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Byrd, Robert C. [D-WV] | WV | D | B001210 | 46 | Designates the week beginning November 13, 1988, as National Craniofacial Deformity Awareness Week. | 2025-07-21T19:32:26Z | |
| 100-hjres-639 | 100 | hjres | 639 | A joint resolution commemorating January 29, 1989, as "National Challenger Center Day" in honor of the crew of the space shuttle Challenger. | Commemorations | 1988-08-11 | 1988-08-23 | Referred to Subcommittee on Census and Population. | House | Rep. Brooks, Jack B. [D-TX-9] | TX | D | B000880 | 44 | Designates January 29, 1988, as National Challenger Center Day. (The Challenger Center is an institution offering children and teachers activities and information derived from American space research.) | 2024-02-06T20:04:02Z | |
| 100-hjres-640 | 100 | hjres | 640 | A joint resolution to designate the last full week of October, October 23 through October 29, 1988, as "National Adult Immunization Awareness Week". | Commemorations | 1988-08-11 | 1988-08-23 | Referred to Subcommittee on Census and Population. | House | Rep. Roybal, Edward R. [D-CA-25] | CA | D | R000485 | 0 | Designates October 23 through October 29, 1988, as National Adult Immunization Awareness Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-641 | 100 | hjres | 641 | A joint resolution designating the month of May 1989, as "National Stroke Awareness Month". | Commemorations | 1988-08-11 | 1988-08-23 | Referred to Subcommittee on Census and Population. | House | Rep. Brown, Hank [R-CO-4] | CO | R | B000919 | 0 | Designates the month of May 1989 as National Stroke Awareness Month. | 2024-02-06T20:04:02Z | |
| 100-hjres-643 | 100 | hjres | 643 | A joint resolution designating September 21, 1988, as "National Farm Safety Day for Kids". | Commemorations | 1988-08-11 | 1988-08-23 | Referred to Subcommittee on Census and Population. | House | Rep. Lightfoot, Jim [R-IA-5] | IA | R | L000305 | 0 | Designates September 21, 1988, as National Farm Safety Day for Kids. | 2024-02-06T20:04:02Z | |
| 100-hjres-645 | 100 | hjres | 645 | A joint resolution to designate September 24, 1988, as "National Integrity Day". | Commemorations | 1988-08-11 | 1988-08-23 | Referred to Subcommittee on Census and Population. | House | Rep. Levine, Mel [D-CA-27] | CA | D | L000264 | 17 | Designates September 24, 1988, as National Integrity Day. | 2024-02-06T20:04:02Z | |
| 100-sjres-369 | 100 | sjres | 369 | A joint resolution to designate the period of September 17 through October 10, 1988, as "Coastweeks '88." | Commemorations | 1988-08-11 | 1988-09-27 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Kerry, John F. [D-MA] | MA | D | K000148 | 55 | Designates the period of September 17 through October 10, 1988, as Coastweeks '88, recognizing the importance of coastal zones. | 2025-07-21T19:32:26Z | |
| 100-sjres-371 | 100 | sjres | 371 | A joint resolution designating October 1988 as "National Domestic Violence Awareness Month". | Commemorations | 1988-08-11 | 1988-08-11 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Specter, Arlen [R-PA] | PA | R | S000709 | 23 | Designates October 1988 as National Domestic Violence Awareness Month. | 2025-07-21T19:32:26Z | |
| 100-hjres-636 | 100 | hjres | 636 | A joint resolution designating the week of October 2 through October 8, 1988, as "National Paralysis Awareness Week". | Commemorations | 1988-08-10 | 1988-08-16 | Referred to Subcommittee on Census and Population. | House | Rep. Fascell, Dante B. [D-FL-19] | FL | D | F000041 | 57 | Designates October 2 through October 8, 1988, as National Paralysis Awareness Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-638 | 100 | hjres | 638 | A joint resolution designating December 15, 1988, as "National Arab American Day". | Commemorations | 1988-08-10 | 1988-08-23 | Referred to Subcommittee on Census and Population. | House | Rep. Traficant, James A., Jr. [D-OH-17] | OH | D | T000350 | 10 | Designates December 15, 1988, as National Arab American Day. | 2024-02-06T20:04:02Z | |
| 100-sjres-364 | 100 | sjres | 364 | A joint resolution to designate the week of October 2 through October 8, 1988, as "National Paralysis Awareness Week." | Commemorations | 1988-08-10 | 1988-10-13 | Became Public Law No: 100-484. | Senate | Sen. Helms, Jesse [R-NC] | NC | R | H000463 | 53 | Designates October 2 through October 8, 1988, as National Paralysis Awareness Week. | 2025-07-21T19:32:26Z | |
| 100-sjres-365 | 100 | sjres | 365 | A joint resolution to designate January 28, 1989, as "National Challenger Center Day" to honor the crew of the space shuttle Challenger. | Commemorations | 1988-08-10 | 1988-11-17 | Became Public Law No: 100-684. | Senate | Sen. Garn, E. J. (Jake) [R-UT] | UT | R | G000072 | 55 | Designates January 28, 1989, as National Challenger Center Day. (The Challenger Center is an institution offering children and teachers activities and information derived from American space research.) | 2025-07-21T19:32:26Z | |
| 100-sjres-366 | 100 | sjres | 366 | A joint resolution designating September 24, 1988, as "National Integrity Day". | Commemorations | 1988-08-10 | 1988-08-10 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Cranston, Alan [D-CA] | CA | D | C000877 | 1 | Designates September 24, 1988, as National Integrity Day. | 2025-07-21T19:32:26Z | |
| 100-sjres-363 | 100 | sjres | 363 | A joint resolution designating November 28 through December 2, 1988, as "Vocational-Technical Education Week". | Commemorations | 1988-08-09 | 1988-10-12 | Message on Senate action sent to the House. | Senate | Sen. Sarbanes, Paul S. [D-MD] | MD | D | S000064 | 64 | Designates November 28 through December 2, 1988, as Vocational-Technical Education Week. | 2025-07-21T19:32:26Z | |
| 100-sjres-360 | 100 | sjres | 360 | A joint resolution to designate February 12, 1989, as "World Marriage Day". | Commemorations | 1988-08-08 | 1988-08-08 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Bond, Christopher S. [R-MO] | MO | R | B000611 | 20 | Designates February 12, 1989, as World Marriage Day. | 2025-07-21T19:32:26Z | |
| 100-sjres-361 | 100 | sjres | 361 | A joint resolution designating the week of September 25, 1988, as "Religious Freedom Week". | Commemorations | 1988-08-08 | 1988-09-22 | Message on Senate action sent to the House. | Senate | Sen. Pell, Claiborne [D-RI] | RI | D | P000193 | 72 | Designates the week of September 25, 1988, as Religious Freedom Week. | 2025-07-21T19:32:26Z | |
| 100-hconres-349 | 100 | hconres | 349 | A concurrent resolution commemorating the 130th anniversary of the Lincoln-Douglas debate and the rededication of the Lincoln-Douglas debate site. | Commemorations | 1988-08-04 | 1988-08-04 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Martin, Lynn M. [R-IL-16] | IL | R | M000195 | 25 | Declares that the Congress joins the city of Freeport, Illinois, in commemorating the 130th anniversary of the Lincoln-Douglas debate and the rededication of the debate site. | 2024-02-06T20:04:02Z | |
| 100-hjres-632 | 100 | hjres | 632 | A joint resolution designating April 2, 1989, as "National Cleaning Professionals Recognition Day". | Commemorations | 1988-08-04 | 1988-08-12 | Referred to Subcommittee on Census and Population. | House | Rep. Goodling, William F. [R-PA-19] | PA | R | G000291 | 0 | Designates April 2, 1989, as National Cleaning Professionals Recognition Day. | 2024-02-06T20:04:02Z | |
| 100-hjres-633 | 100 | hjres | 633 | A joint resolution designating August 14, 1989, as "America-Pakistan Day". | Commemorations | 1988-08-04 | 1988-08-12 | Referred to Subcommittee on Census and Population. | House | Rep. Torricelli, Robert G. [D-NJ-9] | NJ | D | T000317 | 1 | Designates August 14, 1989, as America-Pakistan Day. | 2024-02-06T20:04:02Z | |
| 100-hconres-344 | 100 | hconres | 344 | A concurrent resolution commending the International Boundary and Water Commission for its efforts during the past 100 years to improve the social and economic welfare of the United States and Mexico and to improve good relations between our two countries. | Commemorations | 1988-08-03 | 1988-10-20 | Resolution agreed to in Senate without amendment and with a preamble by Voice Vote. | House | Rep. de la Garza, E. [D-TX-15] | TX | D | D000203 | 13 | Commends the International Boundary and Water Commission's efforts during the past century to improve the social and economic welfare of the United States and Mexico. | 2025-01-23T13:14:35Z | |
| 100-hjres-630 | 100 | hjres | 630 | A joint resolution designating April 16 through 22, 1989, as "National Ceramic Tile Industry Recognition Week". | Commemorations | 1988-08-03 | 1988-08-12 | Referred to Subcommittee on Census and Population. | House | Rep. Applegate, Douglas [D-OH-18] | OH | D | A000214 | 25 | Designates the week of April 16 through April 22, 1989, as National Ceramic Tile Industry Recognition Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-631 | 100 | hjres | 631 | A joint resolution to designate the 1st Sunday in October of 1988 as "National Children's Day". | Commemorations | 1988-08-03 | 1988-08-12 | Referred to Subcommittee on Census and Population. | House | Rep. Kennedy, Joseph P., II [D-MA-8] | MA | D | K000110 | 57 | Designates the first Sunday in October 1988 as National Children's Day. | 2024-02-06T20:04:02Z | |
| 100-hjres-627 | 100 | hjres | 627 | A joint resolution designating July 27, 1989, as "National Korean War Veterans Recognition Day". | Commemorations | 1988-08-02 | 1988-08-02 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Buechner, Jack [R-MO-2] | MO | R | B001036 | 76 | Designates July 27, 1989, as National Korean War Veterans Recognition Day and expresses the gratitude of the Congress and the Nation for the contributions made by the Korean War veterans. | 2024-02-06T20:04:02Z | |
| 100-hjres-628 | 100 | hjres | 628 | A joint resolution designating the period of September 17, 1988, through September 24, 1988, as "American Mushroom Week". | Commemorations | 1988-08-02 | 1988-08-02 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Schulze, Richard T. [R-PA-5] | PA | R | S000146 | 0 | Designates the period of September 17 through September 24, 1988, as American Mushroom Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-629 | 100 | hjres | 629 | A joint resolution designating October 22, 1988, as "National Chester F. Carlson Recognition Day". | Commemorations | 1988-08-02 | 1988-10-28 | Became Public Law No: 100-548. | House | Rep. Slaughter, Louise McIntosh [D-NY-30] | NY | D | S000480 | 59 | Designates October 22, 1988, as National Chester F. Carlson Recognition Day. | 2025-07-21T19:32:26Z | |
| 100-sjres-355 | 100 | sjres | 355 | A joint resolution designating October 7, 1988, as "National Teacher Appreciation Day". | Commemorations | 1988-08-02 | 1988-10-12 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Heflin, Howell [D-AL] | AL | D | H000445 | 65 | Designates October 7, 1988, as National Teacher Appreciation Day. | 2025-07-21T19:32:26Z | |
| 100-sjres-357 | 100 | sjres | 357 | A joint resolution designating the week beginning November 6, 1988, as "National Women Veterans Recognition Week". | Commemorations | 1988-08-02 | 1988-10-07 | Indefinitely postponed by Senate by Unanimous Consent. | Senate | Sen. Cranston, Alan [D-CA] | CA | D | C000877 | 49 | Designates the week beginning November 6, 1988, as National Women Veterans Recognition Week. | 2025-07-21T19:32:26Z | |
| 100-sjres-358 | 100 | sjres | 358 | A joint resolution to authorize and request the President to issue a proclamation designating August 21, 1988 as "National Senior Citizens Day". | Commemorations | 1988-08-02 | 1988-08-02 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Thurmond, Strom [R-SC] | SC | R | T000254 | 1 | Authorizes and requests the President to annually designate the third Sunday of August 1988 as National Senior Citizens Day. | 2025-07-21T19:32:26Z | |
| 100-sjres-354 | 100 | sjres | 354 | A joint resolution to designate November 6 through 12, 1988, as "National Farm Broadcasters Week". | Commemorations | 1988-08-01 | 1988-08-01 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Helms, Jesse [R-NC] | NC | R | H000463 | 20 | Designates the week of November 6 through November 12, 1988, as National Farm Broadcasters Week. | 2025-07-21T19:32:26Z | |
| 100-sjres-353 | 100 | sjres | 353 | A joint resolution to designate the period commencing September 25, 1988 ending October 2, 1988, as "National Angel Plane Week." | Commemorations | 1988-07-28 | 1988-07-28 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Hecht, Chic [R-NV] | NV | R | H000439 | 10 | Designates the period of September 25 through October 2, 1988, as National Angel Plane Week in recognition of the Angel Planes, a group of airline pilots who transport persons in need of medical treatment and blood and organs for various organizations. | 2025-07-21T19:32:26Z | |
| 100-hjres-626 | 100 | hjres | 626 | A joint resolution designating September 13, 1989, as "Uncle Sam Day". | Commemorations | 1988-07-27 | 1988-11-09 | Became Public Law No: 100-645. | House | Rep. Stratton, Samuel S. [D-NY-23] | NY | D | S000997 | 149 | Designates September 13, 1989, as Uncle Sam Day in honor of Samuel Wilson of the city of Troy, New York, on the occasion of the 200th anniversary of the city. (Samuel Wilson was the progenitor of the national symbol, Uncle Sam.) | 2024-02-06T20:04:02Z | |
| 100-hjres-621 | 100 | hjres | 621 | A joint resolution designating September 8, 1988, as "National Pledge of Allegiance Day". | Commemorations | 1988-07-26 | 1988-07-26 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Boehlert, Sherwood [R-NY-25] | NY | R | B000586 | 0 | Designates September 8, 1988, as Francis Bellamy Pledge of Allegiance Day. (Francis Bellamy wrote the Pledge of Allegiance to the Flag in 1892 in observance of the 400th anniversary of the discovery of America.) Expresses the sense of the Congress that the Christopher Columbus Quincentary Jubilee Commission should include the centennial observance of the Pledge of Allegiance in its commemorative activities. | 2024-02-06T20:04:02Z | |
| 100-hjres-622 | 100 | hjres | 622 | A joint resolution designating September 10, 1988, as "National Prune Day". | Commemorations | 1988-07-26 | 1988-07-26 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Herger, Wally [R-CA-2] | CA | R | H000528 | 14 | Designates September 10, 1988, as National Prune Day. | 2024-02-06T20:04:02Z | |
| 100-hjres-623 | 100 | hjres | 623 | A joint resolution to designate the week beginning September 11, 1988 as "National Youth 2000 Week". | Commemorations | 1988-07-26 | 1988-07-26 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Jeffords, James M. [R-VT-At Large] | VT | R | J000072 | 69 | Designates the week beginning September 11, 1988, as National Youth 2000 Week. | 2024-02-06T20:04:02Z | |
| 100-sjres-352 | 100 | sjres | 352 | A joint resolution designating September 24, 1989, as "United States Marshals Bicentennial Day". | Commemorations | 1988-07-26 | 1988-11-17 | Became Public Law No: 100-683. | Senate | Sen. Warner, John [R-VA] | VA | R | W000154 | 51 | Designates September 24, 1989, as United States Marshals Bicentennial Day. | 2025-07-21T19:32:26Z | |
| 100-hjres-611 | 100 | hjres | 611 | A joint resolution designating the week beginning on January 8, 1989, as "National Journalism Education Week". | Commemorations | 1988-07-14 | 1988-07-21 | Referred to Subcommittee on Census and Population. | House | Rep. Buechner, Jack [R-MO-2] | MO | R | B001036 | 17 | Designates the week beginning January 8, 1989, as National Journalism Education Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-612 | 100 | hjres | 612 | A joint resolution to designate February 12, 1989, as "World Marriage Day". | Commemorations | 1988-07-14 | 1988-07-21 | Referred to Subcommittee on Census and Population. | House | Rep. Emerson, Bill [R-MO-8] | MO | R | E000174 | 8 | Designates February 12, 1989, as World Marriage Day. | 2024-02-06T20:04:02Z | |
| 100-hjres-613 | 100 | hjres | 613 | A joint resolution designating the week beginning March 7, 1989, as "Deaf Awareness Week". | Commemorations | 1988-07-14 | 1988-10-21 | Received in the Senate and read twice and referred to the Committee on Judiciary. | House | Rep. Gunderson, Steve [R-WI-3] | WI | R | G000524 | 233 | Designates the week beginning March 7, 1989, as Deaf Awareness Week. | 2025-07-21T19:32:26Z | |
| 100-hjres-614 | 100 | hjres | 614 | A joint resolution designating the week beginning March 19, 1989, as "National Merit Shop Pride and Productivity Week". | Commemorations | 1988-07-14 | 1988-07-21 | Referred to Subcommittee on Census and Population. | House | Rep. Inhofe, James M. [R-OK-1] | OK | R | I000024 | 1 | Designates the week beginning March 19, 1989, as National Merit Shop Pride and Productivity Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-615 | 100 | hjres | 615 | A joint resolution commemorating the centennial of the completion of the Old Executive Office Building in the District of Columbia. | Commemorations | 1988-07-14 | 1988-07-21 | Referred to Subcommittee on Census and Population. | House | Rep. McEwen, Bob [R-OH-6] | OH | R | M000432 | 26 | Commemorates the centennial of the completion of the Old Executive Office Building in the District of Columbia. | 2024-02-06T20:04:02Z | |
| 100-hjres-616 | 100 | hjres | 616 | A joint resolution designating October 16 through 22, 1988, as "National Poetry Week". | Commemorations | 1988-07-14 | 1988-07-21 | Referred to Subcommittee on Census and Population. | House | Rep. Pelosi, Nancy [D-CA-5] | CA | D | P000197 | 103 | Designates the week of October 16 through October 22, 1988, as National Poetry Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-618 | 100 | hjres | 618 | A joint resolution designating the week of November 8 through November 14, 1988, as "National Community Care Week". | Commemorations | 1988-07-14 | 1988-07-14 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Shumway, Norman D. [R-CA-14] | CA | R | S000393 | 23 | Designates November 8 through November 14, 1988, as National Community Care Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-619 | 100 | hjres | 619 | A joint resolution designating October 1988 as "National Domestic Violence Awareness Month". | Commemorations | 1988-07-14 | 1988-07-14 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Slaughter, Louise McIntosh [D-NY-30] | NY | D | S000480 | 72 | Designates October 1988 as National Domestic Violence Awareness Month. | 2024-02-06T20:04:02Z | |
| 100-hjres-610 | 100 | hjres | 610 | A joint resolution designating the week of November 6 through 12, 1988, as "National Farm Broadcasters Week". | Commemorations | 1988-07-13 | 1988-07-21 | Referred to Subcommittee on Census and Population. | House | Rep. Lightfoot, Jim [R-IA-5] | IA | R | L000305 | 60 | Designates the week of November 6 through November 12, 1988, as National Farm Broadcasters Week. | 2024-02-06T20:04:02Z | |
| 100-sjres-350 | 100 | sjres | 350 | A joint resolution designating Labor Day Weekend, September 3-5, 1988, as "National Drive for Life Weekend." | Commemorations | 1988-07-13 | 1988-08-16 | Became Public Law No: 100-397. | Senate | Sen. Simon, Paul [D-IL] | IL | D | S000423 | 64 | Designates the Labor Day Weekend beginning on September 3, 1988, as National Drive for Life Weekend. Calls on people to observe that weekend with a pledge to not drink and drive. | 2025-07-21T19:32:26Z | |
| 100-hjres-607 | 100 | hjres | 607 | A joint resolution to designate October 8, 1988, as "National Day of Outreach to the Rural Disabled". | Commemorations | 1988-07-12 | 1988-07-21 | Referred to Subcommittee on Census and Population. | House | Rep. de la Garza, E. [D-TX-15] | TX | D | D000203 | 226 | Designates October 8, 1988, as National Day of Outreach to the Rural Disabled. | 2024-02-06T20:04:02Z | |
| 100-hjres-608 | 100 | hjres | 608 | A joint resolution designating August 29, 1988, as "National China-Burma-India Veterans Appreciation Day". | Commemorations | 1988-07-12 | 1988-07-18 | Referred to Subcommittee on Census and Population. | House | Rep. Hammerschmidt, John P. [R-AR-3] | AR | R | H000124 | 144 | Designates August 29, 1988, as National China-Burma-India Veterans Appreciation Day. | 2024-02-06T20:04:02Z | |
| 100-hjres-605 | 100 | hjres | 605 | A joint resolution designating the month of November 1988, as "American History Month". | Commemorations | 1988-07-07 | 1988-07-11 | Referred to Subcommittee on Census and Population. | House | Rep. Solomon, Gerald B. H. [R-NY-24] | NY | R | S000675 | 0 | Designates the month of November 1988 as American History Month. | 2024-02-06T20:04:02Z | |
| 100-sjres-348 | 100 | sjres | 348 | A joint resolution to designate the week of February 5, 1989, through February 11, 1989, as "National Burn Awareness Week". | Commemorations | 1988-07-07 | 1988-07-07 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Reid, Harry [D-NV] | NV | D | R000146 | 33 | Designates the week of February 5 through February 11, 1989, as National Burn Awareness Week. | 2025-07-21T19:32:26Z | |
| 100-hjres-603 | 100 | hjres | 603 | A joint resolution designating September 14, 1988, as "National Medical Research Day". | Commemorations | 1988-06-30 | 1988-07-08 | Referred to Subcommittee on Census and Population. | House | Rep. Hoyer, Steny H. [D-MD-5] | MD | D | H000874 | 204 | Designates September 14, 1988, as National Medical Research Day. | 2024-02-06T20:04:02Z | |
| 100-hjres-604 | 100 | hjres | 604 | A joint resolution designating February 5 through 11, 1989, as "National Burn Awareness Week". | Commemorations | 1988-06-30 | 1988-11-09 | Became Public Law No: 100-644. | House | Rep. Weldon, Curt [R-PA-7] | PA | R | W000268 | 173 | Designates the week of February 5 through February 11, 1989, as National Burn Awareness Week. | 2024-02-06T20:04:02Z | |
| 100-sjres-345 | 100 | sjres | 345 | A joint resolution to designate October 8, 1988, as "National Day of Outreach to the Rural Disabled". | Commemorations | 1988-06-29 | 1988-10-21 | Message on House action received in Senate and held at desk: House amendments to Senate bill. | Senate | Sen. Trible, Paul S., Jr. [R-VA] | VA | R | T000367 | 53 | (Measure passed House, amended) Designates October 7, 1989, as National Day of Outreach to the Rural Disabled. | 2025-07-21T19:32:26Z | |
| 100-sjres-346 | 100 | sjres | 346 | A joint resolution to designate March 25, 1989, as "Greek Independence Day: A National Day of Celebration of Greek and American Democracy". | Commemorations | 1988-06-29 | 1988-10-12 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Lautenberg, Frank R. [D-NJ] | NJ | D | L000123 | 59 | Designates March 25, 1989, as Greek Independence Day: A National Day of Celebration of Greek and American Democracy. | 2025-07-21T19:32:26Z | |
| 100-sjres-344 | 100 | sjres | 344 | A bill to designate the week of November 20 through November 26, 1988, as "National Family Week". | Commemorations | 1988-06-28 | 1988-10-19 | Message on Senate action sent to the House. | Senate | Sen. Burdick, Quentin N. [D-ND] | ND | D | B001077 | 10 | Authorizes and requests the President to designate the week of November 20 through November 26, 1988, as National Family Week. | 2025-07-21T19:32:26Z | |
| 100-hjres-600 | 100 | hjres | 600 | A joint resolution to commemorate the fiftieth anniversary of the passage of the Federal Food, Drug, and Cosmetic Act. | Commemorations | 1988-06-27 | 1988-09-29 | Became Public Law No: 100-452. | House | Rep. Waxman, Henry A. [D-CA-24] | CA | D | W000215 | 1 | Recognizes the 50th anniversary of the passage of the Federal Food, Drug, and Cosmetic Act. | 2025-04-21T12:24:17Z | |
| 100-hjres-598 | 100 | hjres | 598 | A joint resolution designating the week of October 2 through 8, 1988, as "National Wild and Scenic Rivers Act Week". | Commemorations | 1988-06-23 | 1988-07-08 | Referred to Subcommittee on Census and Population. | House | Rep. McDade, Joseph M. [R-PA-10] | PA | R | M000399 | 190 | Designates the week of October 2 through October 8, 1988, as National Wild and Scenic Rivers Act Week, marking the 20th anniversary of the Act. | 2024-02-06T20:04:02Z | |
| 100-hjres-599 | 100 | hjres | 599 | A joint resolution to designate the week beginning November 6, 1988, as "National Filipino American History Week". | Commemorations | 1988-06-23 | 1988-06-24 | Referred to Subcommittee on Census and Population. | House | Rep. Miller, John R. [R-WA-1] | WA | R | M000736 | 52 | Designates the week beginning November 6, 1988, as National Filipino American History Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-595 | 100 | hjres | 595 | A joint resolution to designate the week of November 28 through December 5, 1988, as "National Book Week". | Commemorations | 1988-06-22 | 1988-06-24 | Referred to Subcommittee on Census and Population. | House | Rep. Green, S. William [R-NY-15] | NY | R | G000417 | 152 | Designates the period of November 28 through December 5, 1988, as National Book Week. | 2024-02-06T20:04:02Z | |
| 100-hjres-596 | 100 | hjres | 596 | A joint resolution designating November 18, 1988, as "National Philanthropy Day". | Commemorations | 1988-06-22 | 1988-06-24 | Referred to Subcommittee on Census and Population. | House | Rep. Lungren, Daniel E. [R-CA-42] | CA | R | L000517 | 84 | Designates November 18, 1988, as National Philanthropy Day. | 2024-02-06T20:04:02Z | |
| 100-sjres-343 | 100 | sjres | 343 | A joint resolution to designate the period commencing November 13, 1988, and ending on November 19, 1988, as "Filipino American National History Week." | Commemorations | 1988-06-22 | 1988-06-22 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Adams, Brock [D-WA] | WA | D | A000031 | 13 | Designates the week of November 13 through November 19, 1988, as Filipino American National History Week, marking the 225th anniversary of Filipinos in the United States. | 2025-07-21T19:32:26Z | |
| 100-hjres-593 | 100 | hjres | 593 | A joint resolution designating March 1, 1989, as "International Boundary and Water Commission Recognition Day". | Commemorations | 1988-06-21 | 1988-06-24 | Referred to Subcommittee on Census and Population. | House | Rep. de la Garza, E. [D-TX-15] | TX | D | D000203 | 13 | Designates March 1, 1989, as International Boundary and Water Commission Recognition Day. | 2024-02-06T20:04:02Z | |
| 100-hjres-594 | 100 | hjres | 594 | A joint resolution designating October 20, 1988, as "Leyte Landing Day". | Commemorations | 1988-06-21 | 1988-06-24 | Referred to Subcommittee on Census and Population. | House | Rep. Panetta, Leon [D-CA-16] | CA | D | P000047 | 32 | Designates October 20, 1988, as Leyte Landing Day (relating to the allied forces landing in the Philippines in World War II). | 2024-02-06T20:04:02Z | |
| 100-sjres-342 | 100 | sjres | 342 | A joint resolution to designate the week of November 28 through December 5, 1988, as "National Book Week." | Commemorations | 1988-06-20 | 1988-11-07 | Became Public Law No: 100-635. | Senate | Sen. Moynihan, Daniel Patrick [D-NY] | NY | D | M001054 | 58 | Designates the period of November 28 through December 5, 1988, as National Book Week. | 2025-07-21T19:32:26Z | |
| 100-hjres-592 | 100 | hjres | 592 | A joint resolution designating Labor Day Weekend, September 3-5, 1988, as "National Drive for Life Weekend". | Commemorations | 1988-06-16 | 1988-08-09 | Other Measure S.J.Res.350 Passed House in Lieu. | House | Rep. Dymally, Mervyn M. [D-CA-31] | CA | D | D000592 | 220 | Designates the Labor Day Weekend beginning on September 3, 1988, as National Drive for Life Weekend. Calls on people to observe that weekend with a pledge to not drink and drive. | 2024-02-06T20:04:02Z | |
| 100-sjres-340 | 100 | sjres | 340 | A designating November 27 through December 3, 1988, as "National Sir Winston Churchill Recognition Week". | Commemorations | 1988-06-16 | 1988-11-15 | Became Public Law No: 100-663. | Senate | Sen. Packwood, Bob [R-OR] | OR | R | P000009 | 27 | Designates the week of November 27 through December 3, 1988, as National Sir Winston Churchill Recognition Week. | 2025-07-21T19:32:26Z | |
| 100-sjres-341 | 100 | sjres | 341 | A joint resolution to designate September 15, 1988, as "National RSDS Awareness Day." | Commemorations | 1988-06-16 | 1988-06-16 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Lautenberg, Frank R. [D-NJ] | NJ | D | L000123 | 7 | Designates September 15, 1988, as National RSDS Awareness Day. (RSDS stands for reflex sympathetic dystrophy syndrome, a disabling disease.) | 2025-07-21T19:32:26Z |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE legislation (
bill_id TEXT PRIMARY KEY,
congress INTEGER,
bill_type TEXT,
bill_number INTEGER,
title TEXT,
policy_area TEXT,
introduced_date TEXT,
latest_action_date TEXT,
latest_action_text TEXT,
origin_chamber TEXT,
sponsor_name TEXT,
sponsor_state TEXT,
sponsor_party TEXT,
sponsor_bioguide_id TEXT,
cosponsor_count INTEGER DEFAULT 0,
summary_text TEXT,
update_date TEXT,
url TEXT
);
CREATE INDEX idx_leg_congress ON legislation(congress);
CREATE INDEX idx_leg_type ON legislation(bill_type);
CREATE INDEX idx_leg_policy ON legislation(policy_area);
CREATE INDEX idx_leg_date ON legislation(introduced_date);
CREATE INDEX idx_leg_sponsor ON legislation(sponsor_name);
CREATE INDEX idx_leg_sponsor_bioguide ON legislation(sponsor_bioguide_id);