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

82 rows where bill_id = "96-hr-6047" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state

is_original_cosponsor 1

  • 0 82
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
96-hr-6047,A000337 Telephone Privacy Act 96-hr-6047 A000337 Rep. AuCoin, Les [D-OR-1] D     0
96-hr-6047,B000298 Telephone Privacy Act 96-hr-6047 B000298 Rep. Bedell, Berkley W. [D-IA-6] D     0
96-hr-6047,B000431 Telephone Privacy Act 96-hr-6047 B000431 Rep. Bevill, Tom [D-AL-4] D     0
96-hr-6047,B000600 Telephone Privacy Act 96-hr-6047 B000600 Rep. Boland, Edward P. [D-MA-2] D     0
96-hr-6047,B000619 Telephone Privacy Act 96-hr-6047 B000619 Rep. Bonior, David E. [D-MI-12] D     0
96-hr-6047,B000862 Telephone Privacy Act 96-hr-6047 B000862 Rep. Brodhead, William [D-MI-17] D     0
96-hr-6047,C000178 Telephone Privacy Act 96-hr-6047 C000178 Rep. Carr, Bob [D-MI-6] D     0
96-hr-6047,C000488 Telephone Privacy Act 96-hr-6047 C000488 Rep. Clay, William (Bill) [D-MO-1] D     0
96-hr-6047,C000714 Telephone Privacy Act 96-hr-6047 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI   0
96-hr-6047,C000788 Telephone Privacy Act 96-hr-6047 C000788 Resident Commissioner Corrada, Baltasar [I-PR-At Large] I     0
96-hr-6047,D000416 Telephone Privacy Act 96-hr-6047 D000416 Rep. Donnelly, Brian J. [D-MA-11] D     0
96-hr-6047,D000471 Telephone Privacy Act 96-hr-6047 D000471 Rep. Downey, Thomas J. [D-NY-2] D     0
96-hr-6047,D000499 Telephone Privacy Act 96-hr-6047 D000499 Rep. Drinan, Robert F. [D-MA-4] D MA   0
96-hr-6047,E000043 Telephone Privacy Act 96-hr-6047 E000043 Rep. Edgar, Robert W. [D-PA-7] D     0
96-hr-6047,E000064 Telephone Privacy Act 96-hr-6047 E000064 Rep. Edwards, Don [D-CA-10] D     0
96-hr-6047,E000208 Telephone Privacy Act 96-hr-6047 E000208 Rep. Ertel, Allen E. [D-PA-17] D     0
96-hr-6047,F000151 Telephone Privacy Act 96-hr-6047 F000151 Rep. Fisher, Joesph L. [D-VA-10] D     0
96-hr-6047,F000270 Telephone Privacy Act 96-hr-6047 F000270 Rep. Ford, William D. [D-MI-15] D     0
96-hr-6047,G000132 Telephone Privacy Act 96-hr-6047 G000132 Rep. Gephardt, Richard A. [D-MO-3] D     0
96-hr-6047,G000321 Telephone Privacy Act 96-hr-6047 G000321 Rep. Gore, Albert, Jr. [D-TN-4] D     0
96-hr-6047,H000158 Telephone Privacy Act 96-hr-6047 H000158 Rep. Hanley, James M. [D-NY-32] D NY   0
96-hr-6047,H000930 Telephone Privacy Act 96-hr-6047 H000930 Rep. Hughes, William J. [D-NJ-2] D     0
96-hr-6047,J000033 Telephone Privacy Act 96-hr-6047 J000033 Rep. Jacobs, Andrew, Jr. [D-IN-11] D IN   0
96-hr-6047,J000099 Telephone Privacy Act 96-hr-6047 J000099 Rep. Jenrette, John W., Jr. [D-SC-6] D     0
96-hr-6047,K000020 Telephone Privacy Act 96-hr-6047 K000020 Rep. Kastenmeier, Robert W. [D-WI-2] D     0
96-hr-6047,K000172 Telephone Privacy Act 96-hr-6047 K000172 Rep. Kildee, Dale E. [D-MI-7] D     0
96-hr-6047,K000319 Telephone Privacy Act 96-hr-6047 K000319 Rep. Kostmayer, Peter H. [D-PA-8] D     0
96-hr-6047,L000556 Telephone Privacy Act 96-hr-6047 L000556 Rep. LaFalce, John J. [D-NY-36] D     0
96-hr-6047,L000187 Telephone Privacy Act 96-hr-6047 L000187 Rep. Lederer, Raymond F. [D-PA-3] D     0
96-hr-6047,L000226 Telephone Privacy Act 96-hr-6047 L000226 Rep. Lehman, William [D-FL-13] D     0
96-hr-6047,L000508 Telephone Privacy Act 96-hr-6047 L000508 Rep. Luken, Thomas A. [D-OH-2] D     0
96-hr-6047,M000365 Telephone Privacy Act 96-hr-6047 M000365 Rep. McCormack, Mike [D-WA-4] D     0
96-hr-6047,M000473 Telephone Privacy Act 96-hr-6047 M000473 Rep. McHugh, Matthew F. [D-NY-27] D     0
96-hr-6047,M000490 Telephone Privacy Act 96-hr-6047 M000490 Rep. McKay, K. Gunn [D-UT-1] D     0
96-hr-6047,M000058 Telephone Privacy Act 96-hr-6047 M000058 Rep. Maguire, Andrew [D-NJ-7] D     0
96-hr-6047,M000133 Telephone Privacy Act 96-hr-6047 M000133 Rep. Markey, Edward J. [D-MA-7] D MA   0
96-hr-6047,M000291 Telephone Privacy Act 96-hr-6047 M000291 Rep. Mazzoli, Romano L. [D-KY-3] D     0
96-hr-6047,M000826 Telephone Privacy Act 96-hr-6047 M000826 Rep. Mitchell, Parren J. [D-MD-7] D     0
96-hr-6047,M000834 Telephone Privacy Act 96-hr-6047 M000834 Rep. Moakley, John Joseph [D-MA-9] D     0
96-hr-6047,M000845 Telephone Privacy Act 96-hr-6047 M000845 Rep. Mollohan, Robert H. [D-WV-1] D WV   0
96-hr-6047,M001088 Telephone Privacy Act 96-hr-6047 M001088 Rep. Murphy, Austin J. [D-PA-22] D     0
96-hr-6047,N000016 Telephone Privacy Act 96-hr-6047 N000016 Rep. Neal, Stephen L. [D-NC-5] D     0
96-hr-6047,N000019 Telephone Privacy Act 96-hr-6047 N000019 Rep. Nedzi, Lucien N. [D-MI-14] D MI   0
96-hr-6047,N000127 Telephone Privacy Act 96-hr-6047 N000127 Rep. Nolan, Richard M. [D-MN-6] D MN   0
96-hr-6047,O000006 Telephone Privacy Act 96-hr-6047 O000006 Rep. Oberstar, James L. [D-MN-8] D     0
96-hr-6047,O000134 Telephone Privacy Act 96-hr-6047 O000134 Rep. Ottinger, Richard L. [D-NY-24] D NY   0
96-hr-6047,P000047 Telephone Privacy Act 96-hr-6047 P000047 Rep. Panetta, Leon [D-CA-16] D     0
96-hr-6047,P000170 Telephone Privacy Act 96-hr-6047 P000170 Rep. Pease, Donald J. [D-OH-13] D     0
96-hr-6047,P000522 Telephone Privacy Act 96-hr-6047 P000522 Rep. Price, Melvin [D-IL-23] D IL   0
96-hr-6047,R000053 Telephone Privacy Act 96-hr-6047 R000053 Rep. Rangel, Charles B. [D-NY-19] D NY   0
96-hr-6047,R000543 Telephone Privacy Act 96-hr-6047 R000543 Rep. Russo, Martin A. [D-IL-3] D     0
96-hr-6047,S000423 Telephone Privacy Act 96-hr-6047 S000423 Rep. Simon, Paul [D-IL-24] D     0
96-hr-6047,S000124 Telephone Privacy Act 96-hr-6047 S000124 Rep. Scheuer, James H. [D-NY-11] D NY   0
96-hr-6047,S000673 Telephone Privacy Act 96-hr-6047 S000673 Rep. Solarz, Stephen J. [D-NY-13] D     0
96-hr-6047,S000716 Telephone Privacy Act 96-hr-6047 S000716 Rep. Spellman, Gladys Noon [D-MD-5] D     0
96-hr-6047,S000810 Telephone Privacy Act 96-hr-6047 S000810 Rep. Stark, Fortney Pete [D-CA-9] D     0
96-hr-6047,S000948 Telephone Privacy Act 96-hr-6047 S000948 Rep. Stokes, Louis [D-OH-21] D OH   0
96-hr-6047,S001044 Telephone Privacy Act 96-hr-6047 S001044 Rep. Stump, Bob [D-AZ-3] R     0
96-hr-6047,U000001 Telephone Privacy Act 96-hr-6047 U000001 Rep. Udall, Morris K. [D-AZ-2] D     0
96-hr-6047,V000087 Telephone Privacy Act 96-hr-6047 V000087 Rep. Vento, Bruce F. [D-MN-4] D     0
96-hr-6047,W000044 Telephone Privacy Act 96-hr-6047 W000044 Rep. Walgren, Doug [D-PA-18] D     0
96-hr-6047,W000215 Telephone Privacy Act 96-hr-6047 W000215 Rep. Waxman, Henry A. [D-CA-24] D CA   0
96-hr-6047,W000258 Telephone Privacy Act 96-hr-6047 W000258 Rep. Weiss, Ted [D-NY-20] D     0
96-hr-6047,W000419 Telephone Privacy Act 96-hr-6047 W000419 Rep. Whitley, Charles O., Sr. [D-NC-3] D     0
96-hr-6047,W000570 Telephone Privacy Act 96-hr-6047 W000570 Rep. Wilson, Charles [D-TX-2] D     0
96-hr-6047,W000680 Telephone Privacy Act 96-hr-6047 W000680 Rep. Wolff, Lester L. [D-NY-6] D NY   0
96-hr-6047,Y000051 Telephone Privacy Act 96-hr-6047 Y000051 Rep. Young, Robert A. [D-MO-2] D     0
96-hr-6047,B000280 Telephone Privacy Act 96-hr-6047 B000280 Rep. Beard, Robin [R-TN-6] R     0
96-hr-6047,B001008 Telephone Privacy Act 96-hr-6047 B001008 Rep. Buchanan, John [R-AL-6] R     0
96-hr-6047,C000773 Telephone Privacy Act 96-hr-6047 C000773 Rep. Corcoran, Tom [R-IL-15] R     0
96-hr-6047,F000078 Telephone Privacy Act 96-hr-6047 F000078 Rep. Fenwick, Millicent H. [R-NJ-5] R     0
96-hr-6047,G000268 Telephone Privacy Act 96-hr-6047 G000268 Rep. Goldwater, Barry, Jr. [R-CA-20] R     0
96-hr-6047,G000417 Telephone Privacy Act 96-hr-6047 G000417 Rep. Green, S. William [R-NY-18] R     0
96-hr-6047,G000537 Telephone Privacy Act 96-hr-6047 G000537 Rep. Guyer, Tennyson [R-OH-4] R     0
96-hr-6047,H000797 Telephone Privacy Act 96-hr-6047 H000797 Rep. Horton, Frank J. [R-NY-34] R NY   0
96-hr-6047,H001022 Telephone Privacy Act 96-hr-6047 H001022 Rep. Hyde, Henry J. [R-IL-6] R     0
96-hr-6047,L000169 Telephone Privacy Act 96-hr-6047 L000169 Rep. Leach, James A. [R-IA-1] R     0
96-hr-6047,L000243 Telephone Privacy Act 96-hr-6047 L000243 Rep. Lent, Norman F. [R-NY-4] R NY   0
96-hr-6047,M000527 Telephone Privacy Act 96-hr-6047 M000527 Rep. McKinney, Stewart B. [R-CT-4] R     0
96-hr-6047,M000718 Telephone Privacy Act 96-hr-6047 M000718 Rep. Miller, Clarence E. [R-OH-10] R     0
96-hr-6047,W000068 Telephone Privacy Act 96-hr-6047 W000068 Rep. Walker, Robert S. [R-PA-16] R     0
96-hr-6047,W000636 Telephone Privacy Act 96-hr-6047 W000636 Rep. Winn, Larry, Jr. [R-KS-3] R     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);
Powered by Datasette · Queries took 245.979ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API