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

60 rows where bill_id = "97-hjres-83" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 59
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hjres-83,O000006 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1981-12-09 0
97-hjres-83,Y000013 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 Y000013 Rep. Yates, Sidney R. [D-IL-9] D IL 1981-12-09 0
97-hjres-83,R000232 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 R000232 Rep. Richmond, Frederick W. [D-NY-14] D NY 1981-12-09 0
97-hjres-83,M000839 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 M000839 Rep. Moffett, Toby [D-CT-6] D CT 1981-12-09 0
97-hjres-83,C000488 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 C000488 Rep. Clay, William (Bill) [D-MO-1] D MO 1981-12-09 0
97-hjres-83,M001088 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 M001088 Rep. Murphy, Austin J. [D-PA-22] D PA 1981-12-09 0
97-hjres-83,W000227 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 W000227 Rep. Weaver, James H. [D-OR-4] D OR 1981-12-09 0
97-hjres-83,T000356 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 T000356 Rep. Traxler, Bob [D-MI-8] D MI 1981-12-09 0
97-hjres-83,W000258 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 W000258 Rep. Weiss, Ted [D-NY-20] D NY 1981-12-09 0
97-hjres-83,D000373 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 D000373 Rep. Dixon, Julian C. [D-CA-28] D CA 1981-12-09 0
97-hjres-83,C000581 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 C000581 Rep. Coelho, Anthony Lee [D-CA-15] D CA 1981-12-09 0
97-hjres-83,A000224 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 A000224 Rep. Aspin, Les [D-WI-1] D WI 1981-12-09 0
97-hjres-83,F000041 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 F000041 Rep. Fascell, Dante B. [D-FL-15] D FL 1981-12-09 0
97-hjres-83,E000064 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 E000064 Rep. Edwards, Don [D-CA-10] D CA 1981-12-09 0
97-hjres-83,G000511 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1981-12-09 0
97-hjres-83,I000029 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 I000029 Rep. Ireland, Andrew P. [D-FL-8] D FL 1981-12-09 0
97-hjres-83,F000392 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 F000392 Rep. Frost, Martin [D-TX-24] D TX 1981-12-09 0
97-hjres-83,W000682 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1981-12-09 0
97-hjres-83,S000136 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 S000136 Rep. Schneider, Claudine [R-RI-2] R RI 1981-12-09 0
97-hjres-83,V000087 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1981-12-09 0
97-hjres-83,F000053 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 F000053 Rep. Fazio, Vic [D-CA-4] D CA 1981-12-09 0
97-hjres-83,D000471 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 D000471 Rep. Downey, Thomas J. [D-NY-2] D NY 1981-12-09 0
97-hjres-83,R000459 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 R000459 Rep. Roth, Toby [R-WI-8] R WI 1981-12-09 0
97-hjres-83,L000556 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 L000556 Rep. LaFalce, John J. [D-NY-36] D NY 1981-12-09 0
97-hjres-83,F000270 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 F000270 Rep. Ford, William D. [D-MI-15] D MI 1981-12-09 0
97-hjres-83,C000788 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 C000788 Resident Commissioner Corrada, Baltasar [I-PR-At Large] I PR 1981-12-09 0
97-hjres-83,Z000001 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 Z000001 Rep. Zablocki, Clement J. [D-WI-4] D WI 1981-12-09 0
97-hjres-83,R000374 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 R000374 Rep. Rodino, Peter W., Jr. [D-NJ-10] D NJ 1981-12-09 0
97-hjres-83,H000797 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 H000797 Rep. Horton, Frank J. [R-NY-34] R NY 1981-12-09 0
97-hjres-83,P000047 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 P000047 Rep. Panetta, Leon [D-CA-16] D CA 1981-12-09 0
97-hjres-83,P000265 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 1981-12-09 0
97-hjres-83,W000215 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 W000215 Rep. Waxman, Henry A. [D-CA-24] D CA 1981-12-09 0
97-hjres-83,N000009 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 N000009 Rep. Natcher, William H. [D-KY-2] D KY 1981-12-09 0
97-hjres-83,P000444 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 P000444 Rep. Porter, John Edward [R-IL-10] R IL 1981-12-09 0
97-hjres-83,F000046 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1981-12-09 0
97-hjres-83,P000121 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 P000121 Rep. Patterson, Jerry M. [D-CA-38] D CA 1981-12-09 0
97-hjres-83,C000634 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1981-12-09 0
97-hjres-83,L000486 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 L000486 Rep. Lowry, Mike [D-WA-7] D WA 1981-12-09 0
97-hjres-83,W000752 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 W000752 Rep. Wortley, George C. [R-NY-32] R NY 1981-12-09 0
97-hjres-83,M000845 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 M000845 Rep. Mollohan, Robert H. [D-WV-1] D WV 1981-12-09 0
97-hjres-83,K000304 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 K000304 Rep. Kogovsek, Ray [D-CO-3] D CO 1981-12-09 0
97-hjres-83,W000636 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 W000636 Rep. Winn, Larry, Jr. [R-KS-3] R KS 1981-12-09 0
97-hjres-83,C000322 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 C000322 Rep. Chappie, Eugene A. [R-CA-1] R CA 1981-12-09 0
97-hjres-83,O000134 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 O000134 Rep. Ottinger, Richard L. [D-NY-24] D NY 1981-12-09 0
97-hjres-83,D000432 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 D000432 Rep. Dorgan, Byron L. [D-ND-At Large] D ND 1981-12-09 0
97-hjres-83,C000919 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 C000919 Rep. Crockett, George W., Jr. [D-MI-13] D MI 1981-12-09 0
97-hjres-83,W000779 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1981-12-09 0
97-hjres-83,B000037 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 B000037 Rep. Bailey, Donald A. [D-PA-21] D PA 1981-12-09 0
97-hjres-83,M000260 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 M000260 Rep. Mattox, James A. [D-TX-5] D TX 1981-12-09 0
97-hjres-83,B000403 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1981-12-09 0
97-hjres-83,G000268 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 G000268 Rep. Goldwater, Barry, Jr. [R-CA-20] R CA 1981-12-09 0
97-hjres-83,L000090 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 L000090 Rep. Lantos, Tom [D-CA-11] D CA 1981-12-09 0
97-hjres-83,F000339 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 F000339 Rep. Frank, Barney [D-MA-4] D MA 1981-12-09 0
97-hjres-83,B000620 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 B000620 Rep. Bonker, Don [D-WA-3] D WA 1981-12-09 0
97-hjres-83,S000423 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 S000423 Rep. Simon, Paul [D-IL-24] D IL 1981-12-09 0
97-hjres-83,L000226 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 L000226 Rep. Lehman, William [D-FL-13] D FL 1981-12-09 0
97-hjres-83,P000218 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 P000218 Rep. Pepper, Claude [D-FL-14] D FL 1981-12-09 0
97-hjres-83,M001044 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 M001044 Rep. Mottl, Ronald M. [D-OH-23] D OH 1981-12-09 0
97-hjres-83,C000344 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 C000344 Rep. Cheney, Dick [R-WY-At Large] R WY 1981-12-09 0
97-hjres-83,K000020 A joint resolution to designate the sixteenth day of March of each year, the anniversary of the birth date of James Madison, as "Freedom of Information Day". 97-hjres-83 K000020 Rep. Kastenmeier, Robert W. [D-WI-2] D WI 1981-01-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);