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

63 rows where bill_id = "105-hr-3086" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_original_cosponsor 2

  • 0 57
  • 1 6
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
105-hr-3086,M000312 Meals for Achievement Act 105-hr-3086 M000312 Rep. McGovern, James P. [D-MA-3] D MA 1998-07-14 0
105-hr-3086,M000639 Meals for Achievement Act 105-hr-3086 M000639 Rep. Menendez, Robert [D-NJ-13] D NJ 1998-05-21 0
105-hr-3086,W000207 Meals for Achievement Act 105-hr-3086 W000207 Rep. Watt, Melvin L. [D-NC-12] D NC 1998-04-29 0
105-hr-3086,C000191 Meals for Achievement Act 105-hr-3086 C000191 Rep. Carson, Julia [D-IN-10] D IN 1998-03-30 0
105-hr-3086,B000657 Meals for Achievement Act 105-hr-3086 B000657 Rep. Boucher, Rick [D-VA-9] D VA 1998-03-30 0
105-hr-3086,P000422 Meals for Achievement Act 105-hr-3086 P000422 Rep. Pomeroy, Earl [D-ND-At Large] D ND 1998-03-30 0
105-hr-3086,F000339 Meals for Achievement Act 105-hr-3086 F000339 Rep. Frank, Barney [D-MA-4] D MA 1998-03-30 0
105-hr-3086,R000568 Meals for Achievement Act 105-hr-3086 R000568 Rep. Rodriguez, Ciro D. [D-TX-28] D TX 1998-03-30 0
105-hr-3086,M000090 Meals for Achievement Act 105-hr-3086 M000090 Rep. Maloney, James H. [D-CT-5] D CT 1998-03-11 0
105-hr-3086,D000191 Meals for Achievement Act 105-hr-3086 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 1998-03-11 0
105-hr-3086,M000628 Meals for Achievement Act 105-hr-3086 M000628 Rep. Meek, Carrie P. [D-FL-17] D FL 1998-03-11 0
105-hr-3086,N000015 Meals for Achievement Act 105-hr-3086 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 1998-03-11 0
105-hr-3086,S000185 Meals for Achievement Act 105-hr-3086 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 1998-03-11 0
105-hr-3086,L000397 Meals for Achievement Act 105-hr-3086 L000397 Rep. Lofgren, Zoe [D-CA-16] D CA 1998-03-04 0
105-hr-3086,B000104 Meals for Achievement Act 105-hr-3086 B000104 Rep. Ballenger, Cass [R-NC-10] R NC 1998-03-04 0
105-hr-3086,M000933 Meals for Achievement Act 105-hr-3086 M000933 Rep. Moran, James P. [D-VA-8] D VA 1998-03-04 0
105-hr-3086,S000094 Meals for Achievement Act 105-hr-3086 S000094 Rep. Sawyer, Tom [D-OH-14] D OH 1998-03-04 0
105-hr-3086,H000636 Meals for Achievement Act 105-hr-3086 H000636 Rep. Hinojosa, Ruben [D-TX-15] D TX 1998-02-26 0
105-hr-3086,M000941 Meals for Achievement Act 105-hr-3086 M000941 Rep. Morella, Constance A. [R-MD-8] R MD 1998-02-26 0
105-hr-3086,B000013 Meals for Achievement Act 105-hr-3086 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 1998-02-26 0
105-hr-3086,G000120 Meals for Achievement Act 105-hr-3086 G000120 Rep. Gejdenson, Sam [D-CT-2] D CT 1998-02-26 0
105-hr-3086,B000911 Meals for Achievement Act 105-hr-3086 B000911 Rep. Brown, Corrine [D-FL-3] D FL 1998-02-26 0
105-hr-3086,B000574 Meals for Achievement Act 105-hr-3086 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 1998-02-26 0
105-hr-3086,G000410 Meals for Achievement Act 105-hr-3086 G000410 Rep. Green, Gene [D-TX-29] D TX 1998-02-26 0
105-hr-3086,P000452 Meals for Achievement Act 105-hr-3086 P000452 Rep. Poshard, Glenn [D-IL-19] D IL 1998-02-26 0
105-hr-3086,M000627 Meals for Achievement Act 105-hr-3086 M000627 Rep. Meehan, Martin T. [D-MA-5] D MA 1998-02-26 0
105-hr-3086,A000357 Meals for Achievement Act 105-hr-3086 A000357 Rep. Allen, Thomas H. [D-ME-1] D ME 1998-02-26 0
105-hr-3086,S000510 Meals for Achievement Act 105-hr-3086 S000510 Rep. Smith, Adam [D-WA-9] D WA 1998-02-26 0
105-hr-3086,M000590 Meals for Achievement Act 105-hr-3086 M000590 Rep. McNulty, Michael R. [D-NY-21] D NY 1998-02-26 0
105-hr-3086,S000810 Meals for Achievement Act 105-hr-3086 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 1998-02-26 0
105-hr-3086,K000336 Meals for Achievement Act 105-hr-3086 K000336 Rep. Kucinich, Dennis J. [D-OH-10] D OH 1998-02-26 0
105-hr-3086,J000110 Meals for Achievement Act 105-hr-3086 J000110 Rep. John, Christopher [D-LA-7] D LA 1998-02-12 0
105-hr-3086,B000081 Meals for Achievement Act 105-hr-3086 B000081 Rep. Baldacci, John Elias [D-ME-2] D ME 1998-02-12 0
105-hr-3086,F000262 Meals for Achievement Act 105-hr-3086 F000262 Rep. Ford, Harold E., Jr. [D-TN-9] D TN 1998-02-12 0
105-hr-3086,K000180 Meals for Achievement Act 105-hr-3086 K000180 Rep. Kilpatrick, Carolyn C. [D-MI-15] D MI 1998-02-12 0
105-hr-3086,O000085 Meals for Achievement Act 105-hr-3086 O000085 Rep. Olver, John W. [D-MA-1] D MA 1998-02-12 0
105-hr-3086,H000324 Meals for Achievement Act 105-hr-3086 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 1998-02-12 0
105-hr-3086,B000619 Meals for Achievement Act 105-hr-3086 B000619 Rep. Bonior, David E. [D-MI-10] D MI 1998-02-12 0
105-hr-3086,M000404 Meals for Achievement Act 105-hr-3086 M000404 Rep. McDermott, Jim [D-WA-7] D WA 1998-02-12 0
105-hr-3086,S000033 Meals for Achievement Act 105-hr-3086 S000033 Rep. Sanders, Bernard [I-VT-At Large] I VT 1998-02-12 0
105-hr-3086,C000537 Meals for Achievement Act 105-hr-3086 C000537 Rep. Clyburn, James E. [D-SC-6] D SC 1998-02-12 0
105-hr-3086,B000918 Meals for Achievement Act 105-hr-3086 B000918 Rep. Brown, George E., Jr. [D-CA-42] D CA 1998-02-12 0
105-hr-3086,T000316 Meals for Achievement Act 105-hr-3086 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1998-02-12 0
105-hr-3086,K000110 Meals for Achievement Act 105-hr-3086 K000110 Rep. Kennedy, Joseph P., II [D-MA-8] D MA 1998-02-05 0
105-hr-3086,R000011 Meals for Achievement Act 105-hr-3086 R000011 Rep. Rahall, Nick J., II [D-WV-3] D WV 1998-02-05 0
105-hr-3086,E000226 Meals for Achievement Act 105-hr-3086 E000226 Rep. Etheridge, Bob [D-NC-2] D NC 1998-01-28 0
105-hr-3086,T000193 Meals for Achievement Act 105-hr-3086 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 1998-01-28 0
105-hr-3086,N000051 Meals for Achievement Act 105-hr-3086 N000051 Rep. Nethercutt, George R., Jr. [R-WA-5] R WA 1998-01-28 0
105-hr-3086,D000222 Meals for Achievement Act 105-hr-3086 D000222 Rep. Dellums, Ronald V. [D-CA-9] D CA 1998-01-28 0
105-hr-3086,M000087 Meals for Achievement Act 105-hr-3086 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 1998-01-28 0
105-hr-3086,F000116 Meals for Achievement Act 105-hr-3086 F000116 Rep. Filner, Bob [D-CA-50] D CA 1998-01-28 0
105-hr-3086,R000515 Meals for Achievement Act 105-hr-3086 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 1998-01-28 0
105-hr-3086,B000490 Meals for Achievement Act 105-hr-3086 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 1998-01-28 0
105-hr-3086,L000287 Meals for Achievement Act 105-hr-3086 L000287 Rep. Lewis, John [D-GA-5] D GA 1998-01-28 0
105-hr-3086,C000494 Meals for Achievement Act 105-hr-3086 C000494 Rep. Clayton, Eva M. [D-NC-1] D NC 1998-01-28 0
105-hr-3086,W000314 Meals for Achievement Act 105-hr-3086 W000314 Rep. Wexler, Robert [D-FL-19] D FL 1998-01-28 0
105-hr-3086,E000179 Meals for Achievement Act 105-hr-3086 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 1998-01-28 0
105-hr-3086,K000172 Meals for Achievement Act 105-hr-3086 K000172 Rep. Kildee, Dale E. [D-MI-9] D MI 1997-11-13 1
105-hr-3086,M000725 Meals for Achievement Act 105-hr-3086 M000725 Rep. Miller, George [D-CA-7] D CA 1997-11-13 1
105-hr-3086,M000206 Meals for Achievement Act 105-hr-3086 M000206 Rep. Martinez, Matthew G. [D-CA-31] D CA 1997-11-13 1
105-hr-3086,P000149 Meals for Achievement Act 105-hr-3086 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 1997-11-13 1
105-hr-3086,S000030 Meals for Achievement Act 105-hr-3086 S000030 Rep. Sanchez, Loretta [D-CA-46] D CA 1997-11-13 1
105-hr-3086,C000488 Meals for Achievement Act 105-hr-3086 C000488 Rep. Clay, William (Bill) [D-MO-1] D MO 1997-11-13 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 1.931ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy