home / openregs

legislation_cosponsors

Cosponsors for tracked legislation. Distinguishes original cosponsors (signed on at introduction) from later additions. Linked to congress_members via bioguide_id.

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

43 rows where bill_id = "109-hr-6281" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 40
  • 0 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
109-hr-6281,C000984 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 2006-11-14 0
109-hr-6281,M001163 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M001163 Rep. Matsui, Doris O. [D-CA-5] D CA 2006-11-14 0
109-hr-6281,B000410 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 B000410 Rep. Berman, Howard L. [D-CA-28] D CA 2006-11-14 0
109-hr-6281,R000053 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2006-09-29 1
109-hr-6281,S000810 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2006-09-29 1
109-hr-6281,M000404 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2006-09-29 1
109-hr-6281,L000287 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 L000287 Rep. Lewis, John [D-GA-5] D GA 2006-09-29 1
109-hr-6281,N000015 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 2006-09-29 1
109-hr-6281,M000590 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M000590 Rep. McNulty, Michael R. [D-NY-21] D NY 2006-09-29 1
109-hr-6281,B000287 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 B000287 Rep. Becerra, Xavier [D-CA-31] D CA 2006-09-29 1
109-hr-6281,J000284 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 J000284 Rep. Jones, Stephanie Tubbs [D-OH-11] D OH 2006-09-29 1
109-hr-6281,L000557 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 L000557 Rep. Larson, John B. [D-CT-1] D CT 2006-09-29 1
109-hr-6281,E000287 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 E000287 Rep. Emanuel, Rahm [D-IL-5] D IL 2006-09-29 1
109-hr-6281,A000357 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 A000357 Rep. Allen, Thomas H. [D-ME-1] D ME 2006-09-29 1
109-hr-6281,C001036 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 C001036 Rep. Capps, Lois [D-CA-23] D CA 2006-09-29 1
109-hr-6281,D000598 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2006-09-29 1
109-hr-6281,D000216 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2006-09-29 1
109-hr-6281,F000339 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 F000339 Rep. Frank, Barney [D-MA-4] D MA 2006-09-29 1
109-hr-6281,G000553 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 G000553 Rep. Green, Al [D-TX-9] D TX 2006-09-29 1
109-hr-6281,G000410 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 G000410 Rep. Green, Gene [D-TX-29] D TX 2006-09-29 1
109-hr-6281,G000551 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2006-09-29 1
109-hr-6281,H000627 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2006-09-29 1
109-hr-6281,J000032 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 2006-09-29 1
109-hr-6281,J000126 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2006-09-29 1
109-hr-6281,K000009 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2006-09-29 1
109-hr-6281,K000113 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 K000113 Rep. Kennedy, Patrick J. [D-RI-1] D RI 2006-09-29 1
109-hr-6281,K000180 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 K000180 Rep. Kilpatrick, Carolyn C. [D-MI-13] D MI 2006-09-29 1
109-hr-6281,L000559 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 L000559 Rep. Langevin, James R. [D-RI-2] D RI 2006-09-29 1
109-hr-6281,L000480 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2006-09-29 1
109-hr-6281,M000087 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 2006-09-29 1
109-hr-6281,M001143 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2006-09-29 1
109-hr-6281,M000312 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2006-09-29 1
109-hr-6281,M000627 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M000627 Rep. Meehan, Martin T. [D-MA-5] D MA 2006-09-29 1
109-hr-6281,M001160 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2006-09-29 1
109-hr-6281,M000933 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 M000933 Rep. Moran, James P. [D-VA-8] D VA 2006-09-29 1
109-hr-6281,N000002 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 N000002 Rep. Nadler, Jerrold [D-NY-8] D NY 2006-09-29 1
109-hr-6281,O000006 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 2006-09-29 1
109-hr-6281,O000107 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 2006-09-29 1
109-hr-6281,R000170 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 R000170 Rep. Reyes, Silvestre [D-TX-16] D TX 2006-09-29 1
109-hr-6281,S001145 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2006-09-29 1
109-hr-6281,W000215 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 W000215 Rep. Waxman, Henry A. [D-CA-30] D CA 2006-09-29 1
109-hr-6281,W000792 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 W000792 Rep. Weiner, Anthony D. [D-NY-9] D NY 2006-09-29 1
109-hr-6281,W000738 Medicare Prescription Drug Savings for Our Seniors (Medicare Prescription Drug SOS) Act of 2006 109-hr-6281 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2006-09-29 1

Advanced export

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

CSV options:

CREATE TABLE legislation_cosponsors (
    bill_id TEXT NOT NULL REFERENCES legislation(bill_id),
    bioguide_id TEXT NOT NULL,
    full_name TEXT,
    party TEXT,
    state TEXT,
    sponsorship_date TEXT,
    is_original_cosponsor INTEGER,
    PRIMARY KEY (bill_id, bioguide_id)
);
CREATE INDEX idx_lc_bioguide ON legislation_cosponsors(bioguide_id);
CREATE INDEX idx_lc_bill ON legislation_cosponsors(bill_id);
CREATE INDEX idx_lc_original ON legislation_cosponsors(is_original_cosponsor);
Powered by Datasette · Queries took 694.851ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API