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

66 rows where bill_id = "99-hr-5635" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 62
  • 0 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-5635,L000225 Farm Credit Act Amendments of 1986 99-hr-5635 L000225 Rep. Lehman, Richard H. [D-CA-18] D CA 1986-10-03 0
99-hr-5635,S000675 Farm Credit Act Amendments of 1986 99-hr-5635 S000675 Rep. Solomon, Gerald B. H. [R-NY-24] R NY 1986-10-03 0
99-hr-5635,T000350 Farm Credit Act Amendments of 1986 99-hr-5635 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1986-10-03 0
99-hr-5635,M000174 Farm Credit Act Amendments of 1986 99-hr-5635 M000174 Rep. Martin, David O'B. [R-NY-26] R NY 1986-10-03 0
99-hr-5635,D000203 Farm Credit Act Amendments of 1986 99-hr-5635 D000203 Rep. de la Garza, E. [D-TX-15] D TX 1986-10-02 1
99-hr-5635,M000041 Farm Credit Act Amendments of 1986 99-hr-5635 M000041 Rep. Madigan, Edward R. [R-IL-15] R IL 1986-10-02 1
99-hr-5635,C000618 Farm Credit Act Amendments of 1986 99-hr-5635 C000618 Rep. Coleman, E. Thomas [R-MO-6] R MO 1986-10-02 1
99-hr-5635,B000298 Farm Credit Act Amendments of 1986 99-hr-5635 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1986-10-02 1
99-hr-5635,B000918 Farm Credit Act Amendments of 1986 99-hr-5635 B000918 Rep. Brown, George E., Jr. [D-CA-36] D CA 1986-10-02 1
99-hr-5635,B000971 Farm Credit Act Amendments of 1986 99-hr-5635 B000971 Rep. Bruce, Terry L. [D-IL-19] D IL 1986-10-02 1
99-hr-5635,C000581 Farm Credit Act Amendments of 1986 99-hr-5635 C000581 Rep. Coelho, Anthony Lee [D-CA-15] D CA 1986-10-02 1
99-hr-5635,C000653 Farm Credit Act Amendments of 1986 99-hr-5635 C000653 Rep. Combest, Larry [R-TX-19] R TX 1986-10-02 1
99-hr-5635,E000174 Farm Credit Act Amendments of 1986 99-hr-5635 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1986-10-02 1
99-hr-5635,E000250 Farm Credit Act Amendments of 1986 99-hr-5635 E000250 Rep. Evans, Lane [D-IL-17] D IL 1986-10-02 1
99-hr-5635,F000347 Farm Credit Act Amendments of 1986 99-hr-5635 F000347 Rep. Franklin, William W. [R-MS-2] R MS 1986-10-02 1
99-hr-5635,G000240 Farm Credit Act Amendments of 1986 99-hr-5635 G000240 Rep. Glickman, Dan [D-KS-4] D KS 1986-10-02 1
99-hr-5635,G000524 Farm Credit Act Amendments of 1986 99-hr-5635 G000524 Rep. Gunderson, Steve [R-WI-3] R WI 1986-10-02 1
99-hr-5635,H000340 Farm Credit Act Amendments of 1986 99-hr-5635 H000340 Rep. Hatcher, Charles [D-GA-2] D GA 1986-10-02 1
99-hr-5635,H000901 Farm Credit Act Amendments of 1986 99-hr-5635 H000901 Rep. Huckaby, Thomas J. (Jerry) [D-LA-5] D LA 1986-10-02 1
99-hr-5635,J000072 Farm Credit Act Amendments of 1986 99-hr-5635 J000072 Rep. Jeffords, James M. [R-VT-At Large] R VT 1986-10-02 1
99-hr-5635,J000256 Farm Credit Act Amendments of 1986 99-hr-5635 J000256 Rep. Jones, Walter B. [D-NC-1] D NC 1986-10-02 1
99-hr-5635,M000999 Farm Credit Act Amendments of 1986 99-hr-5635 M000999 Rep. Morrison, Sid [R-WA-4] R WA 1986-10-02 1
99-hr-5635,S000779 Farm Credit Act Amendments of 1986 99-hr-5635 S000779 Rep. Staggers, Harley O., Jr. [D-WV-2] D WV 1986-10-02 1
99-hr-5635,S000785 Farm Credit Act Amendments of 1986 99-hr-5635 S000785 Rep. Stallings, Richard H. [D-ID-2] D ID 1986-10-02 1
99-hr-5635,S000795 Farm Credit Act Amendments of 1986 99-hr-5635 S000795 Rep. Stangeland, Arlan [R-MN-7] R MN 1986-10-02 1
99-hr-5635,S000851 Farm Credit Act Amendments of 1986 99-hr-5635 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 1986-10-02 1
99-hr-5635,T000034 Farm Credit Act Amendments of 1986 99-hr-5635 T000034 Rep. Tallon, Robert M. (Robin) [D-SC-6] D SC 1986-10-02 1
99-hr-5635,T000184 Farm Credit Act Amendments of 1986 99-hr-5635 T000184 Rep. Thomas, Lindsay [D-GA-1] D GA 1986-10-02 1
99-hr-5635,A000069 Farm Credit Act Amendments of 1986 99-hr-5635 A000069 Rep. Akaka, Daniel K. [D-HI-2] D HI 1986-10-02 1
99-hr-5635,A000103 Farm Credit Act Amendments of 1986 99-hr-5635 A000103 Rep. Alexander, Bill [D-AR-1] D AR 1986-10-02 1
99-hr-5635,A000213 Farm Credit Act Amendments of 1986 99-hr-5635 A000213 Rep. Anthony, Beryl, Jr. [D-AR-4] D AR 1986-10-02 1
99-hr-5635,B000153 Farm Credit Act Amendments of 1986 99-hr-5635 B000153 Rep. Barnard, Doug, Jr. [D-GA-10] D GA 1986-10-02 1
99-hr-5635,B000229 Farm Credit Act Amendments of 1986 99-hr-5635 B000229 Rep. Bateman, Herbert H. [R-VA-1] R VA 1986-10-02 1
99-hr-5635,B000431 Farm Credit Act Amendments of 1986 99-hr-5635 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1986-10-02 1
99-hr-5635,B000586 Farm Credit Act Amendments of 1986 99-hr-5635 B000586 Rep. Boehlert, Sherwood [R-NY-25] R NY 1986-10-02 1
99-hr-5635,B000615 Farm Credit Act Amendments of 1986 99-hr-5635 B000615 Rep. Boner, William H. [D-TN-5] D TN 1986-10-02 1
99-hr-5635,B000780 Farm Credit Act Amendments of 1986 99-hr-5635 B000780 Rep. Breaux, John B. [D-LA-7] D LA 1986-10-02 1
99-hr-5635,B001220 Farm Credit Act Amendments of 1986 99-hr-5635 B001220 Rep. Byron, Beverly B. [D-MD-6] D MD 1986-10-02 1
99-hr-5635,C000754 Farm Credit Act Amendments of 1986 99-hr-5635 C000754 Rep. Cooper, Jim [D-TN-4] D TN 1986-10-02 1
99-hr-5635,D000051 Farm Credit Act Amendments of 1986 99-hr-5635 D000051 Rep. Darden, George (Buddy) [D-GA-7] D GA 1986-10-02 1
99-hr-5635,D000267 Farm Credit Act Amendments of 1986 99-hr-5635 D000267 Rep. Derrick, Butler C. [D-SC-3] D SC 1986-10-02 1
99-hr-5635,D000466 Farm Credit Act Amendments of 1986 99-hr-5635 D000466 Rep. Dowdy, Wayne [D-MS-4] D MS 1986-10-02 1
99-hr-5635,D000563 Farm Credit Act Amendments of 1986 99-hr-5635 D000563 Rep. Durbin, Richard J. [D-IL-20] D IL 1986-10-02 1
99-hr-5635,D000593 Farm Credit Act Amendments of 1986 99-hr-5635 D000593 Rep. Dyson, Roy [D-MD-1] D MD 1986-10-02 1
99-hr-5635,E000043 Farm Credit Act Amendments of 1986 99-hr-5635 E000043 Rep. Edgar, Robert W. [D-PA-7] D PA 1986-10-02 1
99-hr-5635,F000208 Farm Credit Act Amendments of 1986 99-hr-5635 F000208 Rep. Flippo, Ronnie G. [D-AL-5] D AL 1986-10-02 1
99-hr-5635,F000261 Farm Credit Act Amendments of 1986 99-hr-5635 F000261 Rep. Ford, Harold E. [D-TN-9] D TN 1986-10-02 1
99-hr-5635,G000105 Farm Credit Act Amendments of 1986 99-hr-5635 G000105 Rep. Gaydos, Joseph M. [D-PA-20] D PA 1986-10-02 1
99-hr-5635,G000212 Farm Credit Act Amendments of 1986 99-hr-5635 G000212 Rep. Gilman, Benjamin A. [R-NY-22] R NY 1986-10-02 1
99-hr-5635,G000309 Farm Credit Act Amendments of 1986 99-hr-5635 G000309 Rep. Gordon, Bart [D-TN-6] D TN 1986-10-02 1
99-hr-5635,K000009 Farm Credit Act Amendments of 1986 99-hr-5635 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1986-10-02 1
99-hr-5635,K000307 Farm Credit Act Amendments of 1986 99-hr-5635 K000307 Rep. Kolter, Joseph P. [D-PA-4] D PA 1986-10-02 1
99-hr-5635,L000381 Farm Credit Act Amendments of 1986 99-hr-5635 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1986-10-02 1
99-hr-5635,M000702 Farm Credit Act Amendments of 1986 99-hr-5635 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD 1986-10-02 1
99-hr-5635,M000834 Farm Credit Act Amendments of 1986 99-hr-5635 M000834 Rep. Moakley, John Joseph [D-MA-9] D MA 1986-10-02 1
99-hr-5635,M000844 Farm Credit Act Amendments of 1986 99-hr-5635 M000844 Rep. Mollohan, Alan B. [D-WV-1] D WV 1986-10-02 1
99-hr-5635,P000229 Farm Credit Act Amendments of 1986 99-hr-5635 P000229 Rep. Perkins, Carl C. [D-KY-7] D KY 1986-10-02 1
99-hr-5635,R000011 Farm Credit Act Amendments of 1986 99-hr-5635 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1986-10-02 1
99-hr-5635,R000146 Farm Credit Act Amendments of 1986 99-hr-5635 R000146 Rep. Reid, Harry [D-NV-1] D NV 1986-10-02 1
99-hr-5635,R000481 Farm Credit Act Amendments of 1986 99-hr-5635 R000481 Rep. Rowland, J. Roy [D-GA-8] D GA 1986-10-02 1
99-hr-5635,S000320 Farm Credit Act Amendments of 1986 99-hr-5635 S000320 Rep. Shelby, Richard C. [D-AL-7] D AL 1986-10-02 1
99-hr-5635,S001075 Farm Credit Act Amendments of 1986 99-hr-5635 S001075 Rep. Sundquist, Don [R-TN-7] R TN 1986-10-02 1
99-hr-5635,T000075 Farm Credit Act Amendments of 1986 99-hr-5635 T000075 Rep. Taylor, G. [R-MO-7] R MO 1986-10-02 1
99-hr-5635,V000006 Farm Credit Act Amendments of 1986 99-hr-5635 V000006 Rep. Valentine, Tim [D-NC-2] D NC 1986-10-02 1
99-hr-5635,W000194 Farm Credit Act Amendments of 1986 99-hr-5635 W000194 Rep. Watkins, Wes [D-OK-3] D OK 1986-10-02 1
99-hr-5635,W000227 Farm Credit Act Amendments of 1986 99-hr-5635 W000227 Rep. Weaver, James H. [D-OR-4] D OR 1986-10-02 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);