legislation
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
759 rows where congress = 99 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99-sjres-431 | 99 | sjres | 431 | A joint resolution to designate the period January 1, 1988, through December 31, 1988, as the "Year of Workers With Disabilities". | Commemorations | 1986-10-17 | 1986-10-17 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 13 | Designates 1988 as the Year of Workers With Disabilities. Authorizes the President to conduct a program promoting the employment and career advancement of the disabled. | 2025-07-21T19:32:26Z | |
| 99-sjres-432 | 99 | sjres | 432 | A joint resolution to designate the period commencing February 9, 1987, and ending February 15, 1987, as "National Burn Awareness Week". | Commemorations | 1986-10-17 | 1986-10-17 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Wilson, Pete [R-CA] | CA | R | W000607 | 0 | Designates the week commencing February 9 and ending February 15, 1987, as National Burn Awareness Week. | 2025-07-21T19:32:26Z | |
| 99-sjres-426 | 99 | sjres | 426 | A joint resolution to designate the week of October 19 through 25, 1986, as "National CPR Awareness Week". | Commemorations | 1986-10-09 | 1986-10-16 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Warner, John [R-VA] | VA | R | W000154 | 25 | Designates the week of October 19 through October 25, 1986, as National CPR Awareness Week. | 2025-07-21T19:32:26Z | |
| 99-sjres-424 | 99 | sjres | 424 | A joint resolution to designate October 31, 1986 as "National Child Identification and Safety Information Day". | Commemorations | 1986-10-08 | 1986-10-08 | Indefinitely postponed by Senate by Voice Vote. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 25 | Designates October 31, 1986, as National Child Identification and Safety Information Day. | 2021-06-30T19:57:56Z | |
| 99-hjres-745 | 99 | hjres | 745 | A joint resolution designating March 16, 1987, as "Freedom of Information Day". | Commemorations | 1986-10-06 | 1986-10-27 | See S.J.Res.414. | House | Rep. Wirth, Timothy [D-CO-2] | CO | D | W000647 | 224 | Designates March 16, 1987, as Freedom of Information Day. | 2024-02-06T20:04:02Z | |
| 99-sjres-423 | 99 | sjres | 423 | A joint resolution to designate the week beginning January 19, 1987 as "Shays' Rebellion Week" and Sunday, January 25, 1987, as "Shays Rebellion Day". | Commemorations | 1986-10-03 | 1986-10-03 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Kerry, John F. [D-MA] | MA | D | K000148 | 27 | Designates: (1) the week beginning January 19, 1987, as Shays' Rebellion Week; and (2) Sunday, January 25, 1987, as Shays' Rebellion Day. | 2025-07-21T19:32:26Z | |
| 99-sjres-422 | 99 | sjres | 422 | An original joint resolution commemorating the 100th anniversary of the birth of the first Prime Minister of the State of Israel, David Ben-Gurion. | Commemorations | 1986-09-30 | 1986-10-27 | Became Public Law No: 99-541. | Senate | Sen. Boschwitz, Rudy [R-MN] | MN | R | B000647 | 2 | Commemorates the centennial of David Ben-Gurion's birth. Applauds the David Ben-Gurion Centennial Committee of the United States of America for its work promoting the yearlong centennial celebration. | 2025-01-14T19:00:46Z | |
| 99-hjres-742 | 99 | hjres | 742 | A joint resolution to designate March 1, 1987, as "National Yiddish Books Day". | Commemorations | 1986-09-29 | 1986-09-29 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Frank, Barney [D-MA-4] | MA | D | F000339 | 0 | Designates March 1, 1987, as National Yiddish Books Day. | 2024-02-06T20:04:02Z | |
| 99-hjres-741 | 99 | hjres | 741 | A joint resolution to designate March, 1987, as "Developmental Disabilities Awareness Month". | Commemorations | 1986-09-26 | 1986-10-16 | Became Public Law No: 99-483. | House | Rep. Hansen, James V. [R-UT-1] | UT | R | H000172 | 0 | Designates March 1987 as Developmental Disabilities Awareness Month. | 2024-02-06T20:04:02Z | |
| 99-sjres-420 | 99 | sjres | 420 | A joint resolution relating to the commemoration of January 28, 1987, as a "National Day of Excellence". | Commemorations | 1986-09-26 | 1986-10-02 | Committee on Judiciary. Ordered favorably report H.J.Res. 588 in lieu of this measure. | Senate | Sen. Goldwater, Barry [R-AZ] | AZ | R | G000267 | 35 | Designates January 28, 1987, as a National Day of Excellence in honor of the space shuttle Challenger crew. | 2025-07-21T19:32:26Z | |
| 99-hjres-739 | 99 | hjres | 739 | A joint resolution to proclaim December 7, 1986, as "My Nationality American Day". | Commemorations | 1986-09-24 | 1986-09-24 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Livingston, Bob [R-LA-1] | LA | R | L000371 | 13 | Proclaims December 7, 1986, as My Nationality American Day. | 2024-02-06T20:04:02Z | |
| 99-hjres-740 | 99 | hjres | 740 | A joint resolution to designate February 4, 1987, as "National Women in Sports Day". | Commemorations | 1986-09-24 | 1986-10-27 | See S.J.Res.418. | House | Rep. Snowe, Olympia J. [R-ME-2] | ME | R | S000663 | 161 | Designates February 4, 1987, as National Women in Sports Day. | 2024-02-06T20:04:02Z | |
| 99-sjres-419 | 99 | sjres | 419 | A joint resolution to designate December 11, 1986 as "National SEEK and College Discovery Day". | Commemorations | 1986-09-24 | 1986-09-24 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Moynihan, Daniel Patrick [D-NY] | NY | D | M001054 | 28 | Designates December 11, 1986, as National SEEK (Search for Elevation, Education, and Knowledge) and College Discovery Day. | 2025-07-21T19:32:26Z | |
| 99-hjres-735 | 99 | hjres | 735 | A joint resolution to designate December 11, 1986, as "National SEEK and College Discovery Day". | Commemorations | 1986-09-23 | 1986-10-21 | Became Public Law No: 99-512. | House | Rep. Garcia, Robert [D-NY-18] | NY | D | G000047 | 11 | Designates December 11, 1986, as National SEEK (Search for Elevation, Education, and Knowledge) and College Discovery Day. | 2024-02-06T20:04:02Z | |
| 99-hjres-737 | 99 | hjres | 737 | A joint resolution to designate the week commencing February 9, 1987 as "National Burn Awareness Week". | Commemorations | 1986-09-23 | 1986-09-23 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Hutto, Earl [D-FL-1] | FL | D | H001018 | 128 | Designates the week commencing February 9, 1987, as National Burn Awareness Week. | 2024-02-06T20:04:02Z | |
| 99-sjres-418 | 99 | sjres | 418 | A joint resolution to designate February 4, 1987, as "National Women in Sports Day". | Commemorations | 1986-09-23 | 1986-10-27 | Became Public Law No: 99-540. | Senate | Sen. Packwood, Bob [R-OR] | OR | R | P000009 | 30 | Designates February 4, 1987, as National Women in Sports Day. | 2025-07-21T19:32:26Z | |
| 99-sjres-417 | 99 | sjres | 417 | A joint resolution designating the week of January 25 through January 31, 1987 as "National Productivity Improvement Week". | Commemorations | 1986-09-22 | 1986-10-06 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Nunn, Sam [D-GA] | GA | D | N000171 | 28 | Designates the week of January 25, 1987, as National Productivity Improvement Week. | 2025-07-21T19:32:26Z | |
| 99-hconres-392 | 99 | hconres | 392 | A concurrent resolution commemorating the 100th anniversary of the birth of David Ben-Gurion. | Commemorations | 1986-09-19 | 1986-09-19 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Yates, Sidney R. [D-IL-9] | IL | D | Y000013 | 0 | Commemorates the centennial of David Ben-Gurion's birth. Applauds the David Ben-Gurion Centennial Committee of the United States of America for its work promoting the yearlong centennial celebration. | 2024-02-06T20:04:02Z | |
| 99-hjres-733 | 99 | hjres | 733 | A joint resolution to designate October 4, 1986, as "National Outreach to the Rural Disabled Day". | Commemorations | 1986-09-19 | 1986-10-08 | See S.J.Res.406. | House | Rep. de la Garza, E. [D-TX-15] | TX | D | D000203 | 135 | Designates October 4, 1986, as National Outreach to the Rural Disabled Day. | 2024-02-06T20:04:02Z | |
| 99-sconres-162 | 99 | sconres | 162 | A concurrent resolution commemorating the 100th anniversary of the birth of David Ben-Gurion. | Commemorations | 1986-09-18 | 1986-09-18 | Referred to the Committee on Judiciary. | Senate | Sen. Boschwitz, Rudy [R-MN] | MN | R | B000647 | 0 | Commemorates the centennial of David Ben-Gurion's birth. Applauds the David Ben-Gurion Centennial Committee of the United States of America for its work promoting the yearlong centennial celebration. | 2025-07-21T19:32:26Z | |
| 99-hjres-729 | 99 | hjres | 729 | A joint resolution to designate the month of October, 1986, as "Orphans and Foster Care Youth Month". | Commemorations | 1986-09-16 | 1986-09-16 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Wortley, George C. [R-NY-27] | NY | R | W000752 | 24 | Designates the month of October 1986 as Orphans and Foster Care Youth Month. | 2024-02-06T20:04:02Z | |
| 99-sjres-414 | 99 | sjres | 414 | A joint resolution to designate March 16, 1987, as "Freedom of Information Day". | Commemorations | 1986-09-16 | 1986-10-27 | Became Public Law No: 99-539. | Senate | Sen. Packwood, Bob [R-OR] | OR | R | P000009 | 27 | Designates March 16, 1987, as Freedom of Information Day. | 2025-07-21T19:32:26Z | |
| 99-sjres-413 | 99 | sjres | 413 | A joint resolution to designate the month of October 1986 as "Learning Disabilities Awareness Month". | Commemorations | 1986-09-15 | 1986-09-26 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Bumpers, Dale [D-AR] | AR | D | B001057 | 26 | Designates October 1986 as Learning Disabilities Awareness Month. | 2025-07-21T19:32:26Z | |
| 99-hjres-721 | 99 | hjres | 721 | A joint resolution to designate the week of October 12, 1986, through October 18, 1986, as "National Job Skills Week". | Commemorations | 1986-09-11 | 1986-10-08 | Became Public Law No: 99-455. | House | Rep. Martinez, Matthew G. [D-CA-30] | CA | D | M000206 | 0 | Designates the week of October 12 through October 18, 1986, as National Job Skills Week. | 2024-02-06T20:04:02Z | |
| 99-hjres-722 | 99 | hjres | 722 | A joint resolution to designate the week beginning January 25, 1987, as "National Productivity Improvement Week". | Commemorations | 1986-09-11 | 1986-09-11 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Swindall, Patrick L. [R-GA-4] | GA | R | S001122 | 18 | Designates the week beginning January 25, 1987, as National Productivity Improvement Week. | 2024-02-06T20:04:02Z | |
| 99-sjres-409 | 99 | sjres | 409 | A joint resolution to designate October 6, 1986, as "German-American Day". | Commemorations | 1986-09-11 | 1986-09-11 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Lugar, Richard G. [R-IN] | IN | R | L000504 | 3 | Designates October 6, 1986, as German-American Day. | 2025-07-21T19:32:26Z | |
| 99-sjres-410 | 99 | sjres | 410 | A joint resolution to designate the period commencing February 9, 1987, and ending February 15, 1987, as "National Burn Awareness Week". | Commemorations | 1986-09-11 | 1986-10-27 | Became Public Law No: 99-538. | Senate | Sen. Wilson, Pete [R-CA] | CA | R | W000607 | 28 | Designates the week commencing February 9 and ending February 15, 1987, as National Burn Awareness Week. | 2025-07-21T19:32:26Z | |
| 99-sjres-411 | 99 | sjres | 411 | A joint resolution to provide for the designation of April 9, 1987, as "National Former Prisoner of War Recognition Day". | Commemorations | 1986-09-11 | 1986-09-11 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Murkowski, Frank H. [R-AK] | AK | R | M001085 | 1 | Designates April 9, 1987, as National Former Prisoner of War Recognition Day. | 2025-07-21T19:32:26Z | |
| 99-hjres-719 | 99 | hjres | 719 | A joint resolution to provide for the designation of the week of October 12, 1986 through October 18, 1986 as "Myasthenia Gravis Awareness Week". | Commemorations | 1986-09-10 | 1986-09-10 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Conte, Silvio O. [R-MA-1] | MA | R | C000709 | 0 | Designates the week of October 12 through October 18, 1986, as Myasthenia Gravis Awareness Week. | 2024-02-06T20:04:02Z | |
| 99-hjres-720 | 99 | hjres | 720 | A joint resolution to designate the week of October 19 through 25, 1986 as "National CPR Awareness Week". | Commemorations | 1986-09-10 | 1986-09-10 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Parris, Stanford E. (Stan) [R-VA-8] | VA | R | P000080 | 35 | Designates the week of October 19 through October 25, 1986, as National CPR Awareness Week. | 2024-02-06T20:04:02Z | |
| 99-sjres-408 | 99 | sjres | 408 | A joint resolution designating "American Physiologists Week". | Commemorations | 1986-09-10 | 1986-10-16 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Dole, Robert J. [R-KS] | KS | R | D000401 | 27 | Designates the week beginning March 29, 1987, as American Physiologists Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-718 | 99 | hjres | 718 | A joint resolution to designate the week beginning November 30, 1986, as "National Home Health Care Week". | Commemorations | 1986-09-09 | 1986-09-15 | Referred to Subcommittee on Census and Population. | House | Rep. Panetta, Leon [D-CA-16] | CA | D | P000047 | 222 | Designates the week beginning November 30, 1986, as National Home Health Care Week. | 2024-02-06T20:04:02Z | |
| 99-sjres-407 | 99 | sjres | 407 | A joint resolution designating November 12, 1986, as "Salute to School Volunteers Day". | Commemorations | 1986-09-08 | 1986-10-27 | Became Public Law No: 99-537. | Senate | Sen. Chiles, Lawton [D-FL] | FL | D | C000356 | 29 | Designates November 12, 1986, as Salute to School Volunteers Day. | 2025-07-21T19:32:26Z | |
| 99-hjres-714 | 99 | hjres | 714 | A joint resolution to authorize and request the President of the United States to issue a proclamation designating the week beginning October 5, 1986 as "National Port Week". | Commemorations | 1986-08-15 | 1986-08-22 | Referred to Subcommittee on Census and Population. | House | Rep. Biaggi, Mario [D-NY-19] | NY | D | B000432 | 135 | Authorizes and requests the President to designate the week beginning October 5, 1986, as National Port Week. | 2024-02-06T20:04:02Z | |
| 99-hjres-715 | 99 | hjres | 715 | A joint resolution to designate July 2 and 3, 1987, as "The U.S.--Canada Days of Peace and Friendship". | Commemorations | 1986-08-15 | 1986-10-02 | See S.J.Res.402. | House | Rep. Bonior, David E. [D-MI-12] | MI | D | B000619 | 170 | Designates July 2 and July 3, 1987, as United States-Canada Days of Peace and Friendship. | 2024-02-06T20:04:02Z | |
| 99-hjres-716 | 99 | hjres | 716 | A joint resolution to designate October 1986 as "Learning Disabilities Awareness Month". | Commemorations | 1986-08-15 | 1986-09-26 | See S.J.Res.413. | House | Rep. Brown, George E., Jr. [D-CA-36] | CA | D | B000918 | 61 | Designates October 1986 as Learning Disabilities Awareness Month. | 2024-02-06T20:04:02Z | |
| 99-hjres-717 | 99 | hjres | 717 | A joint resolution designating September 20th, 1986 as "National Youth in Politics Day". | Commemorations | 1986-08-15 | 1986-08-22 | Referred to Subcommittee on Census and Population. | House | Rep. Rose, Charlie [D-NC-7] | NC | D | R000436 | 0 | Designates September 20, 1986, as National Youth in Politics Day. | 2024-02-06T20:04:02Z | |
| 99-s-2766 | 99 | s | 2766 | A bill to amend the Christopher Columbus Quincentenary Jubilee Act. | Commemorations | 1986-08-15 | 1986-08-15 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Mathias, Charles McC., Jr. [R-MD] | MD | R | M000241 | 0 | Amends the Christopher Columbus Quincentenary Jubilee Act to authorize the Christopher Columbus Quincentenary Jubilee Commission to expend a specified amount of authorized funds to entertain foreign representatives. Removes caps on donations the Commission may accept. Authorizes the Commission to permit commercial use of the Christopher Columbus Quincentenary Jubilee logo. | 2025-07-21T19:32:26Z | |
| 99-s-2773 | 99 | s | 2773 | Commission on the 100th Congress Act | Commemorations | 1986-08-15 | 1986-08-15 | Read twice and referred to the Committee on Governmental Affairs. | Senate | Sen. Simon, Paul [D-IL] | IL | D | S000423 | 11 | Commission on the 100th Congress Act - Establishes the Commission for the Bicentennial of the Congress to: (1) organize and coordinate the activities of private individuals and organizations in the commemoration of the bicentennial of the Congress; (2) provide guidance and materials about the Congress to further the celebration; (3) cooperate with the Historians of the Senate and of the House of Representatives in their programs; and (4) prepare materials necessary to enhance public knowledge of the history and accomplishments of the Congress. Requires the Commission to report annually to the Congress, with a final report within 90 days after March 4, 1989, containing a detailed statement of its activities and financial operations. Terminates the Commission on June 30, 1989. | 2025-08-29T16:32:22Z | |
| 99-sjres-402 | 99 | sjres | 402 | A joint resolution designating July 2 and 3, 1987, as the "United States-Canada Days of Peace and Friendship". | Commemorations | 1986-08-15 | 1986-10-02 | Became Public Law No: 99-438. | Senate | Sen. Lugar, Richard G. [R-IN] | IN | R | L000504 | 46 | Designates July 2 and July 3, 1987, as United States-Canada Days of Peace and Friendship. | 2025-07-21T19:32:26Z | |
| 99-sjres-403 | 99 | sjres | 403 | A joint resolution to designate 1988 as the "National Year of Friendship with Finland". | Commemorations | 1986-08-15 | 1986-08-15 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Roth Jr., William V. [R-DE] | DE | R | R000460 | 27 | Designates 1988 as the National Year of Friendship with Finland. | 2025-07-21T19:32:26Z | |
| 99-sjres-404 | 99 | sjres | 404 | A joint resolution to designate October 1986 as "Polish American Heritage Month". | Commemorations | 1986-08-15 | 1986-08-15 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Simon, Paul [D-IL] | IL | D | S000423 | 33 | Designates October 1986 as Polish American Heritage Month. | 2025-07-21T19:32:26Z | |
| 99-sjres-405 | 99 | sjres | 405 | A joint resolution to designate September 11, 1986, as 9-1-1 Emergency Number Day". | Commemorations | 1986-08-15 | 1986-10-06 | Became Public Law No: 99-448. | Senate | Sen. Glenn, John H., Jr. [D-OH] | OH | D | G000236 | 29 | (Measure passed House, amended) Designates September 11, 1987, as 9-1-1 Emergency Number Day. | 2025-07-21T19:32:26Z | |
| 99-sjres-406 | 99 | sjres | 406 | A joint resolution to designate October 4, 1986 as "National Outreach to the Rural Disabled Day". | Commemorations | 1986-08-15 | 1986-10-08 | Became Public Law No: 99-462. | Senate | Sen. Trible, Paul S., Jr. [R-VA] | VA | R | T000367 | 29 | Designates October 4, 1986, as National Outreach to the Rural Disabled Day. | 2025-07-21T19:32:26Z | |
| 99-hjres-710 | 99 | hjres | 710 | A joint resolution to designate the week beginning October 6, 1986, as "National Children's Television Awareness Week". | Commemorations | 1986-08-14 | 1986-10-06 | Became Public Law No: 99-444. | House | Rep. Wirth, Timothy [D-CO-2] | CO | D | W000647 | 218 | (Measure passed House, amended) Designates the week beginning October 12, 1986, as National Children's Television Awareness Week. | 2024-02-06T20:04:02Z | |
| 99-hjres-711 | 99 | hjres | 711 | A joint resolution to designate the week beginning October 5, 1986, as "National Birds of Prey Conservation Week". | Commemorations | 1986-08-14 | 1986-08-22 | Referred to Subcommittee on Census and Population. | House | Rep. Ritter, Don [R-PA-15] | PA | R | R000277 | 13 | Designates the week beginning October 5, 1986, as National Birds of Prey Conservation Week. | 2024-02-06T20:04:02Z | |
| 99-sjres-400 | 99 | sjres | 400 | A joint resolution designating the month of September 1986, as "National Back to School-Back Off Drugs Month". | Commemorations | 1986-08-14 | 1986-08-14 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. D'Amato, Alfonse [R-NY] | NY | R | D000018 | 3 | Designates the month of September 1986 as National Back to School-Back Off Drugs Month. Sets forth drug abuse prevention activities in which schools should engage. | 2025-07-21T19:32:26Z | |
| 99-sjres-401 | 99 | sjres | 401 | A joint resolution to designate the week of October 12, 1986, through October 18, 1986, as "National Job Skills Week". | Commemorations | 1986-08-14 | 1986-09-24 | Indefinitely postponed by Senate by Voice Vote. | Senate | Sen. Gore, Albert, Jr. [D-TN] | TN | D | G000321 | 32 | Designates the week of October 6 through October 12, 1986, as National Job Skills Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-707 | 99 | hjres | 707 | A joint resolution designating the month of October 1986 as "National High-Tech Month". | Commemorations | 1986-08-13 | 1986-08-19 | Referred to Subcommittee on Census and Population. | House | Rep. Dymally, Mervyn M. [D-CA-31] | CA | D | D000592 | 43 | Designates the month of October 1986 as National High-Tech Month. | 2024-02-06T20:04:02Z | |
| 99-hjres-708 | 99 | hjres | 708 | A joint resolution to designate September 11, 1986, "9-1-1 Emergency Number Day". | Commemorations | 1986-08-13 | 1986-10-06 | See S.J.Res.405. | House | Rep. Feighan, Edward F. [D-OH-19] | OH | D | F000059 | 68 | Designates September 11, 1986, as 9-1-1 Emergency Number Day. | 2024-02-06T20:04:02Z | |
| 99-hjres-709 | 99 | hjres | 709 | A joint resolution to designate the year beginning October 1, 1986, as the National Institute of Health Centennial Year. | Commemorations | 1986-08-13 | 1986-10-16 | See S.J.Res.395. | House | Rep. Waxman, Henry A. [D-CA-24] | CA | D | W000215 | 240 | Designates the year beginning October 1, 1986, as the National Institutes of Health Centennial Year. | 2024-02-06T20:04:02Z | |
| 99-sjres-394 | 99 | sjres | 394 | A joint resolution to designate the week of October 6, 1986, through October 12, 1986, as "National Children's Television Awareness Week". | Commemorations | 1986-08-13 | 1986-09-16 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Lautenberg, Frank R. [D-NJ] | NJ | D | L000123 | 28 | (Measure passed Senate, amended) Designates the week of october 12 through October 18, 1986, as National Children's Television Awareness Week. | 2025-07-21T19:32:26Z | |
| 99-sjres-395 | 99 | sjres | 395 | A joint resolution to designate the period October 1, 1986, through September 30, 1987, as "National Institutes of Health Centennial Year". | Commemorations | 1986-08-13 | 1986-10-16 | Became Public Law No: 99-489. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 36 | Designates October 1, 1986, through September 30, 1987, as National Institutes of Health Centennial Year. | 2025-07-21T19:32:26Z | |
| 99-sjres-396 | 99 | sjres | 396 | A joint resolution to designate the week of October 26, 1986, through November 1, 1986, as "National Adult Immunization Awareness Week". | Commemorations | 1986-08-13 | 1986-10-22 | Became Public Law No: 99-528. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 32 | Designates the week of October 26 through November 1, 1986, as National Adult Immunization Awareness Week. | 2025-07-21T19:32:26Z | |
| 99-sjres-397 | 99 | sjres | 397 | A joint resolution to designate the year beginning January 1, 1987, through December 31, 1987, as the "Year of the Reader". | Commemorations | 1986-08-13 | 1986-08-13 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Mathias, Charles McC., Jr. [R-MD] | MD | R | M000241 | 0 | Designates 1987 as the Year of the Reader. | 2025-07-21T19:32:26Z | |
| 99-sjres-398 | 99 | sjres | 398 | A joint resolution to designate the week beginning September 7, 1986, as "National Freedom of Information Act Awareness Week". | Commemorations | 1986-08-13 | 1986-08-13 | Read twice and referred to the Committee on Finance. | Senate | Sen. Leahy, Patrick J. [D-VT] | VT | D | L000174 | 26 | Designates the week beginning September 7, 1986, as National Freedom of Information Act Awareness Week. | 2025-01-03T20:55:56Z | |
| 99-hjres-704 | 99 | hjres | 704 | A joint resolution to authorize and request the President to proclaim the week of November 23, 1986, to November 30, 1986, as "American Indian Week". | Commemorations | 1986-08-12 | 1986-10-14 | See S.J.Res.390. | House | Rep. Burton, Sala [D-CA-5] | CA | D | B001158 | 68 | Authorizes and requests the President to designate the week of November 23 to November 30, 1986, as American Indian Week. | 2024-02-06T20:04:02Z | |
| 99-hjres-705 | 99 | hjres | 705 | A joint resolution to designate March 22, 1987, as "National Yiddish Books Day". | Commemorations | 1986-08-12 | 1986-08-19 | Referred to Subcommittee on Census and Population. | House | Rep. Frank, Barney [D-MA-4] | MA | D | F000339 | 0 | Designates March 22, 1987, as National Yiddish Books Day. | 2024-02-06T20:04:02Z | |
| 99-hjres-706 | 99 | hjres | 706 | A joint resolution designating November 12, 1986, as "Salute to School Volunteers Day". | Commemorations | 1986-08-12 | 1986-10-27 | See S.J.Res.407. | House | Rep. Ford, William D. [D-MI-15] | MI | D | F000270 | 94 | Designates November 12, 1986, as Salute to School Volunteers Day. | 2024-02-06T20:04:02Z | |
| 99-sjres-392 | 99 | sjres | 392 | A joint resolution to designate the month of December 1986 as "Made in America Month". | Commemorations | 1986-08-12 | 1986-10-27 | Became Public Law No: 99-568. | Senate | Sen. Thurmond, Strom [R-SC] | SC | R | T000254 | 27 | Authorizes and requests the President to designate December 1986 as Made in America Month. | 2025-07-21T19:32:26Z | |
| 99-hjres-700 | 99 | hjres | 700 | A joint resolution to designate the week of October 26, 1986, through November 1, 1986, as "National Adult Immunization Awareness Week". | Commemorations | 1986-08-11 | 1986-10-22 | See S.J.Res.396. | House | Rep. Roybal, Edward R. [D-CA-25] | CA | D | R000485 | 151 | Designates the week of October 26 through November 1, 1986, as National Adult Immunization Awareness Week. | 2024-02-06T20:04:02Z | |
| 99-hjres-701 | 99 | hjres | 701 | A joint resolution to designate October 6, 1986, as "National Drug Abuse Education Day". | Commemorations | 1986-08-11 | 1986-08-11 | Referred to House Committee on Post Office and Civil Service. | House | Rep. Gejdenson, Sam [D-CT-2] | CT | D | G000120 | 218 | Designates October 6, 1986, as National Drug Abuse Education Day. | 2024-02-06T20:04:02Z | |
| 99-hjres-703 | 99 | hjres | 703 | A joint resolution to authorize and request the President to designate the week beginning April 12, 1987, as "National Week of the American Taxpayer". | Commemorations | 1986-08-11 | 1986-08-19 | Referred to Subcommittee on Census and Population. | House | Rep. Panetta, Leon [D-CA-16] | CA | D | P000047 | 9 | Authorizes and requests the President to designate the week beginning April 12, 1987, as National Week of the American Taxpayer. | 2024-02-06T20:04:02Z | |
| 99-sjres-391 | 99 | sjres | 391 | A joint resolution to designate August 12, 1986, as "National Civil Rights Day". | Commemorations | 1986-08-11 | 1986-09-11 | Committee on Judiciary. Ordered reported H.J.Res. 686 in lieu of this measure. | Senate | Sen. Lugar, Richard G. [R-IN] | IN | R | L000504 | 33 | Designates August 12, 1986, as National Civil Rights Day. | 2025-07-21T19:32:26Z | |
| 99-sres-464 | 99 | sres | 464 | A resolution to designate October 1986 as "Crack/Cocaine Awareness Month". | Commemorations | 1986-08-11 | 1986-08-11 | Referred to the Committee on Judiciary. | Senate | Sen. Roth Jr., William V. [R-DE] | DE | R | R000460 | 26 | Designates October 1986 as Crack/Cocaine Awareness Month. | 2025-07-21T19:32:26Z | |
| 99-sjres-390 | 99 | sjres | 390 | A joint resolution to authorize and request the President to proclaim the week of November 23, 1986, to November 30, 1986, as "American Indian Week". | Commemorations | 1986-08-08 | 1986-10-14 | Became Public Law No: 99-471. | Senate | Sen. Cranston, Alan [D-CA] | CA | D | C000877 | 27 | Authorizes and requests the President to designate the week of November 23 to November 30, 1986, as American Indian Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-698 | 99 | hjres | 698 | A joint resolution designating the month of September 1986 as "National Back to School--Back Off Drugs Month". | Commemorations | 1986-08-07 | 1986-08-14 | Referred to Subcommittee on Census and Population. | House | Rep. Biaggi, Mario [D-NY-19] | NY | D | B000432 | 57 | Designates the month of September 1986 as National Back to School-Back Off Drugs Month. Sets forth drug abuse prevention activities in which schools should engage. | 2024-02-06T20:04:02Z | |
| 99-hjres-697 | 99 | hjres | 697 | A joint resolution to proclaim October 23, 1986, as "A Time of Remembrance" for all victims of terrorism throughout the world. | Commemorations | 1986-08-06 | 1986-08-14 | Referred to Subcommittee on Census and Population. | House | Rep. Garcia, Robert [D-NY-18] | NY | D | G000047 | 1 | Proclaims October 23, 1986, as A Time of Remembrance for all victims of terrorism. Urges Americans to wear a purple ribbon in honor of the sacrifices made in pursuit of peace and freedom. Authorizes and requests the President to call upon U.S. departments, agencies, and other interested parties to fly U.S. flags at half staff. | 2024-02-06T20:04:02Z | |
| 99-sjres-388 | 99 | sjres | 388 | A joint resolution designating the week beginning January 4, 1987, as "National Bowling Week". | Commemorations | 1986-08-06 | 1986-10-15 | Passed Senate without amendment and with a preamble by Voice Vote. | Senate | Sen. Levin, Carl [D-MI] | MI | D | L000261 | 25 | Designates the week beginning January 4, 1987, as National Bowling Week. | 2025-07-21T19:32:26Z | |
| 99-sjres-389 | 99 | sjres | 389 | A joint resolution to designate March 1987 as the "Month of Developmentally Disabled Persons". | Commemorations | 1986-08-06 | 1986-09-16 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 26 | Designates March 1987 as the Month of Developmentally Disabled Persons. | 2025-07-21T19:32:26Z | |
| 99-hjres-694 | 99 | hjres | 694 | A joint resolution to designate the week of December 14, 1986, through December 20, 1986, as "National Drunk and Drugged Driving Awareness Week". | Commemorations | 1986-08-05 | 1986-08-14 | Received in the Senate and read twice and referred to the Committee on Judiciary. | House | Rep. Barnes, Michael D. [D-MD-8] | MD | D | B000160 | 230 | Designates the week of December 14 through December 20, 1986, as National Drunk and Drugged Driving Awareness Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-695 | 99 | hjres | 695 | A joint resolution to designate October 1986, as "National Home Knitting Month". | Commemorations | 1986-08-05 | 1986-08-14 | Referred to Subcommittee on Census and Population. | House | Rep. Lujan, Manuel, Jr. [R-NM-1] | NM | R | L000506 | 0 | Designates the month of October 1986 as National Home Knitting Month. | 2024-02-06T20:04:02Z | |
| 99-hjres-696 | 99 | hjres | 696 | A joint resolution to designate the week beginning November 9, 1986, as "American Indian Heritage Week". | Commemorations | 1986-08-05 | 1986-08-14 | Referred to Subcommittee on Census and Population. | House | Rep. Mitchell, Parren J. [D-MD-7] | MD | D | M000826 | 0 | Designates the week beginning November 9, 1986, as American Indian Heritage Week. | 2024-02-06T20:04:02Z | |
| 99-sjres-386 | 99 | sjres | 386 | A joint resolution to designate October 6, 1986, as "National Drug Abuse Education Day". | Commemorations | 1986-08-05 | 1986-08-27 | Became Public Law No: 99-407. | Senate | Sen. Dodd, Christopher J. [D-CT] | CT | D | D000388 | 26 | Designates October 6, 1986, as National Drug Abuse Education Day. | 2025-07-21T19:32:26Z | |
| 99-sjres-387 | 99 | sjres | 387 | A joint resolution to designate the week of October 19, 1986, through October 26, 1986, "National Housing Week". | Commemorations | 1986-08-05 | 1986-08-05 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Hecht, Chic [R-NV] | NV | R | H000439 | 26 | Designates the week of October 19 through October 26, 1986, as National Housing Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-692 | 99 | hjres | 692 | A joint resolution to designate the week of October 19, 1986, through October 26, 1986, "National Housing Week". | Commemorations | 1986-08-01 | 1986-09-25 | Became Public Law No: 99-419. | House | Rep. AuCoin, Les [D-OR-1] | OR | D | A000337 | 255 | Designates the week of October 19 through October 26, 1986, as National Housing Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-693 | 99 | hjres | 693 | A joint resolution to designate the week beginning November 16, 1986, as "National Arts Week". | Commemorations | 1986-08-01 | 1986-10-22 | See S.J.Res.304. | House | Rep. Green, S. William [R-NY-15] | NY | R | G000417 | 229 | Designates the week beginning November 16, 1986, as National Arts Week. | 2024-02-06T20:04:02Z | |
| 99-sjres-385 | 99 | sjres | 385 | A joint resolution to designate October 23, 1986 as "National Hungarian Freedom Fighters Day". | Commemorations | 1986-08-01 | 1986-10-16 | Became Public Law No: 99-488. | Senate | Sen. Riegle, Donald W., Jr. [D-MI] | MI | D | R000249 | 30 | Designates October 23, 1986, as National Hungarian Freedom Fighters Day. | 2025-07-21T19:32:26Z | |
| 99-hjres-689 | 99 | hjres | 689 | A joint resolution to designate June 7, 1987, as "National Family Day". | Commemorations | 1986-07-30 | 1986-08-14 | Referred to Subcommittee on Census and Population. | House | Rep. Dannemeyer, William E. [R-CA-39] | CA | R | D000044 | 0 | Designates June 7, 1987, as National Family Day. | 2024-02-06T20:04:02Z | |
| 99-sjres-383 | 99 | sjres | 383 | A joint resolution to designate the week of September 8 through September 14, 1986, as "National Annapolis Convention Week." | Commemorations | 1986-07-30 | 1986-07-30 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Sarbanes, Paul S. [D-MD] | MD | D | S000064 | 1 | Designates the week of September 8 through September 14, 1986, as National Annapolis Convention Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-688 | 99 | hjres | 688 | A joint resolution to authorize and request the President to designate the month of December 1986, as "Made in America Month". | Commemorations | 1986-07-29 | 1986-10-27 | See S.J.Res.392. | House | Rep. Hefner, W. G. (Bill) [D-NC-8] | NC | D | H000448 | 98 | Authorizes and requests the President to designate December 1986 as Made in America Month. | 2024-02-06T20:04:02Z | |
| 99-hjres-682 | 99 | hjres | 682 | A joint resolution extending best wishes to the Board of Supervisors of the County of San Diego, California, on the occasion of the 50th anniversary celebration and rededication of the San Diego County Administration Center on August 20, 1986. | Commemorations | 1986-07-24 | 1986-08-14 | Referred to Subcommittee on Census and Population. | House | Rep. Bates, Jim [D-CA-44] | CA | D | B000236 | 39 | Authorizes and requests the President to extend best wishes to the Board of Supervisors of San Diego County, California, on the occasion of the 50th anniversary celebration and rededication of the San Diego County Administration Center on August 20, 1986. | 2024-02-06T20:04:02Z | |
| 99-hjres-686 | 99 | hjres | 686 | A joint resolution to designate August 12, 1986, as "National Civil Rights Day". | Commemorations | 1986-07-24 | 1986-10-16 | Became Public Law No: 99-482. | House | Rep. Visclosky, Peter J. [D-IN-1] | IN | D | V000108 | 230 | (Measure passed Senate, amended) Designates August 12, 1987, as National Civil Rights Day. | 2025-07-21T19:32:26Z | |
| 99-sjres-377 | 99 | sjres | 377 | A joint resolution to designate the week of May 17, 1987, through May 23, 1987, as "National Tourism Week". | Commemorations | 1986-07-24 | 1986-07-31 | Committee on Judiciary. For further action see H.J.Res. 642. | Senate | Sen. Warner, John [R-VA] | VA | R | W000154 | 33 | Designates the week of May 17 through May 23, 1987, as National Tourism Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-681 | 99 | hjres | 681 | A joint resolution to designate March 17, 1987, as "National China-Burma-India Veterans Association Day". | Commemorations | 1986-07-23 | 1986-08-13 | Referred to Subcommittee on Census and Population. | House | Rep. Montgomery, G. V. (Sonny) [D-MS-3] | MS | D | M000865 | 9 | Designates March 17, 1987, as National China-Burma-India Veterans Association Day. | 2024-02-06T20:04:02Z | |
| 99-hjres-678 | 99 | hjres | 678 | A joint resolution to designate October 1986 as "Crack/Cocaine Awareness Month". | Commemorations | 1986-07-22 | 1986-10-16 | Became Public Law No: 99-481. | House | Rep. Garcia, Robert [D-NY-18] | NY | D | G000047 | 75 | Designates October 1986 as Crack/Cocaine Awareness Month. | 2025-07-21T19:32:26Z | |
| 99-hjres-679 | 99 | hjres | 679 | A joint resolution to designate the week of September 8 through September 14, 1986, as "National Annapolis Convention Week". | Commemorations | 1986-07-22 | 1986-07-28 | Referred to Subcommittee on Census and Population. | House | Rep. Hoyer, Steny H. [D-MD-5] | MD | D | H000874 | 8 | Designates the week of September 8 through September 14, 1986, as National Annapolis Convention Week. | 2024-02-06T20:04:02Z | |
| 99-hjres-675 | 99 | hjres | 675 | A joint resolution to designate October 6, 1986, as "German-American Day". | Commemorations | 1986-07-17 | 1986-07-28 | Referred to Subcommittee on Census and Population. | House | Rep. Luken, Thomas A. [D-OH-1] | OH | D | L000508 | 57 | Designates October 6, 1986, as German-American Day. | 2024-02-06T20:04:02Z | |
| 99-hjres-677 | 99 | hjres | 677 | A joint resolution to designate the week beginning March 29, 1987, as "American Physiologists Week". | Commemorations | 1986-07-17 | 1986-07-28 | Referred to Subcommittee on Census and Population. | House | Rep. Walgren, Doug [D-PA-18] | PA | D | W000044 | 125 | Designates the week beginning March 29, 1987, as American Physiologists Week. | 2024-02-06T20:04:02Z | |
| 99-sjres-373 | 99 | sjres | 373 | A joint resolution designating the week beginning May 10, 1987 as "National Fetal Alcohol Syndrome Awareness Week". | Commemorations | 1986-07-17 | 1986-09-16 | Referred to House Committee on Post Office and Civil Service. | Senate | Sen. Hatch, Orrin G. [R-UT] | UT | R | H000338 | 25 | Designates the week beginning May 10, 1987, as National Fetal Alcohol Syndrome Awareness Week. | 2025-07-21T19:32:26Z | |
| 99-sjres-375 | 99 | sjres | 375 | A joint resolution designating the week beginning September 21, 1986, as "National Adult Day Care Center Week". | Commemorations | 1986-07-17 | 1986-10-02 | Committee on Judiciary. Ordered favorably reported H.J.Res. 617 in lieu of this measure. | Senate | Sen. Levin, Carl [D-MI] | MI | D | L000261 | 28 | Designates the week beginning September 21, 1986, as National Adult Day Care Center Week. | 2025-07-21T19:32:26Z | |
| 99-hjres-671 | 99 | hjres | 671 | A joint resolution designating 1987 as the "Year of the Reader". | Commemorations | 1986-07-16 | 1986-10-16 | Became Public Law No: 99-494. | House | Rep. Oakar, Mary Rose [D-OH-20] | OH | D | O000001 | 51 | Designates 1987 as the Year of the Reader. | 2024-02-06T20:04:02Z | |
| 99-hjres-670 | 99 | hjres | 670 | A joint resolution to designate the week beginning August 31, 1986, as "National Pedestrian Safety Week". | Commemorations | 1986-07-15 | 1986-07-28 | Referred to Subcommittee on Census and Population. | House | Rep. Hertel, Dennis M. [D-MI-14] | MI | D | H000547 | 112 | Designates the week beginning August 31, 1986, as National Pedestrian Safety Week. | 2024-02-06T20:04:02Z | |
| 99-sconres-153 | 99 | sconres | 153 | A concurrent resolution to express the sense of the Congress that a moment of silence be held during the official ceremonies for the Statue of Liberty, for the return of the American captives in Lebanon. | Commemorations | 1986-06-26 | 1986-06-26 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Simon, Paul [D-IL] | IL | D | S000423 | 28 | Expresses the sense of the Congress that during the official ceremony of the lighting of the torch of the Statue of Liberty, a moment of silence be held for the return of the American captives in Lebanon. | 2025-07-21T19:32:26Z | |
| 99-hconres-362 | 99 | hconres | 362 | A concurrent resolution to express the sense of the Congress that a moment of silence be held during the official ceremonies for the Statue of Liberty for the return of the American captives in Lebanon. | Commemorations | 1986-06-25 | 1986-06-26 | Received in the Senate, considered, and agreed to without amendment and with a preamble by Voice Vote. | House | Rep. Mineta, Norman Y. [D-CA-13] | CA | D | M000794 | 40 | Expresses the sense of the Congress that during the official ceremony of the lighting of the torch of the Statue of Liberty, a moment of silence be held for the return of the American captives in Lebanon. | 2024-02-06T20:04:02Z | |
| 99-sjres-368 | 99 | sjres | 368 | A joint resolution to designate the month of October 1986, as "National Spina Bifida Month". | Commemorations | 1986-06-25 | 1986-10-08 | Became Public Law No: 99-461. | Senate | Sen. Dixon, Alan J. [D-IL] | IL | D | D000366 | 33 | Designates the month of October 1986 as National Spina Bifida Month. | 2025-07-21T19:32:26Z | |
| 99-sjres-369 | 99 | sjres | 369 | A joint resolution to designate July 3, 1986, as "Let Freedom Ring Day", and to request the President to issue a proclamation encouraging the people of the United States to ring bells on such day immediately following the relighting of the torch of the Statue of Liberty. | Commemorations | 1986-06-25 | 1986-06-25 | Read twice and referred to the Committee on Judiciary. | Senate | Sen. Armstrong, William L. [R-CO] | CO | R | A000219 | 0 | Designates July 3, 1986, as Let Freedom Ring Day. Requests the President to encourage people to ring bells immediately following the relighting of the torch of the Statue of Liberty. | 2025-07-21T19:32:26Z | |
| 99-sjres-367 | 99 | sjres | 367 | A joint resolution to designate July 31, 1986, as "National Kidney Program Day". | Commemorations | 1986-06-23 | 1986-10-28 | Became Public Law No: 99-580. | Senate | Sen. Heinz, John [R-PA] | PA | R | H000456 | 29 | (Measure passed House, amended) Authorizes and requests the President to designate October 23, 1986, as National Kidney Program Day. | 2025-07-21T19:32:26Z | |
| 99-hjres-664 | 99 | hjres | 664 | A joint resolution to designate July 3, 1986, as "Let Freedom Ring Day", and to request the President to issue a proclamation encouraging the people of the United States to ring bells on such day immediately following the relighting of the torch of the Statue of Liberty. | Commemorations | 1986-06-19 | 1986-07-02 | Became Public Law No: 99-352. | House | Rep. Martin, Lynn M. [R-IL-16] | IL | R | M000195 | 235 | Designates July 3, 1986, as Let Freedom Ring Day. Requests the President to encourage people to ring bells immediately following the relighting of the torch of the Statue of Liberty. | 2024-02-06T20:04:02Z | |
| 99-hjres-659 | 99 | hjres | 659 | A joint resolution designating July 4, 1986 as "July 4th Family Celebration Day". | Commemorations | 1986-06-18 | 1986-06-23 | Referred to Subcommittee on Census and Population. | House | Del. Fauntroy, Walter E. [D-DC-At Large] | DC | D | F000046 | 15 | Designates July 4, 1986, as July 4th Family Celebration Day. | 2024-02-06T20:04:02Z |
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);