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

32 rows where bill_id = "96-hr-6842" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 32
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-6842,C000809 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 C000809 Rep. Courter, Jim [R-NJ-12] R     0
96-hr-6842,F000123 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 F000123 Rep. Findley, Paul [R-IL-20] R     0
96-hr-6842,F000286 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 F000286 Rep. Forsythe, Edwin B. [R-NJ-6] R     0
96-hr-6842,F000380 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 F000380 Rep. Frenzel, Bill [R-MN-3] R     0
96-hr-6842,J000232 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 J000232 Rep. Jones, James R. [D-OK-1] D     0
96-hr-6842,L000020 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R     0
96-hr-6842,L000169 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 L000169 Rep. Leach, James A. [R-IA-1] R     0
96-hr-6842,L000237 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 L000237 Rep. Leland, Mickey [D-TX-18] D     0
96-hr-6842,L000447 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 L000447 Rep. Lott, Trent [R-MS-5] R     0
96-hr-6842,L000508 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 L000508 Rep. Luken, Thomas A. [D-OH-2] D     0
96-hr-6842,L000517 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 L000517 Rep. Lungren, Daniel E. [R-CA-3] R     0
96-hr-6842,Y000014 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 Y000014 Rep. Yatron, Gus [D-PA-6] D     0
96-hr-6842,P000265 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI   0
96-hr-6842,M000413 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 M000413 Rep. McDonald, Lawrence P. [D-GA-7] D     0
96-hr-6842,M000260 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 M000260 Rep. Mattox, James A. [D-TX-5] D     0
96-hr-6842,M000794 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 M000794 Rep. Mineta, Norman Y. [D-CA-13] D     0
96-hr-6842,M000692 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 M000692 Rep. Michel, Robert H. [R-IL-18] R     0
96-hr-6842,O000001 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 O000001 Rep. Oakar, Mary Rose [D-OH-20] D     0
96-hr-6842,O000010 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 O000010 Rep. O'Brien, George M. [R-IL-17] R     0
96-hr-6842,P000097 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 P000097 Rep. Pashayan, Charles, Jr. [R-CA-17] R     0
96-hr-6842,P000520 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 P000520 Rep. Preyer, Richardson [D-NC-6] D     0
96-hr-6842,R000012 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 R000012 Rep. Railsback, Thomas F. [R-IL-19] R     0
96-hr-6842,T000075 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 T000075 Rep. Taylor, G. [R-MO-7] R     0
96-hr-6842,A000076 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 A000076 Rep. Albosta, Donald J. [D-MI-10] D     0
96-hr-6842,A000103 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 A000103 Rep. Alexander, Bill [D-AR-1] D     0
96-hr-6842,A000337 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 A000337 Rep. AuCoin, Les [D-OR-1] D     0
96-hr-6842,B000160 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 B000160 Rep. Barnes, Michael D. [D-MD-8] D     0
96-hr-6842,C000488 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 C000488 Rep. Clay, William (Bill) [D-MO-1] D     0
96-hr-6842,C000773 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 C000773 Rep. Corcoran, Tom [R-IL-15] R     0
96-hr-6842,C000871 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 C000871 Rep. Crane, Daniel B. [R-IL-19] R     0
96-hr-6842,D000044 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 D000044 Rep. Dannemeyer, William E. [R-CA-39] R     0
96-hr-6842,F000088 A bill to protect the confidentiality of Shippers' Export Declarations, and to standardize export data submission and disclosure requirements. 96-hr-6842 F000088 Rep. Ferraro, Geraldine A. [D-NY-9] D     0

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);