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

44 rows where bill_id = "109-hconres-482" 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

  • 1 38
  • 0 6
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
109-hconres-482,B001230 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 B001230 Rep. Baldwin, Tammy [D-WI-2] D WI 2006-12-06 0
109-hconres-482,F000339 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 F000339 Rep. Frank, Barney [D-MA-4] D MA 2006-12-05 0
109-hconres-482,S000097 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 S000097 Rep. Saxton, Jim [R-NJ-3] R NJ 2006-09-29 0
109-hconres-482,K000172 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2006-09-28 0
109-hconres-482,L000491 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 L000491 Rep. Lucas, Frank D. [R-OK-3] R OK 2006-09-28 0
109-hconres-482,K000362 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 K000362 Rep. King, Steve [R-IA-5] R IA 2006-09-27 0
109-hconres-482,P000422 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 P000422 Rep. Pomeroy, Earl [D-ND-At Large] D ND 2006-09-26 1
109-hconres-482,P000258 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 2006-09-26 1
109-hconres-482,K000009 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2006-09-26 1
109-hconres-482,S000465 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 S000465 Rep. Skelton, Ike [D-MO-4] D MO 2006-09-26 1
109-hconres-482,S001158 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 S001158 Rep. Salazar, John T. [D-CO-3] D CO 2006-09-26 1
109-hconres-482,K000188 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 K000188 Rep. Kind, Ron [D-WI-3] D WI 2006-09-26 1
109-hconres-482,H000948 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 H000948 Rep. Hulshof, Kenny C. [R-MO-9] R MO 2006-09-26 1
109-hconres-482,M000485 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2006-09-26 1
109-hconres-482,K000358 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 K000358 Rep. Kennedy, Mark R. [R-MN-6] R MN 2006-09-26 1
109-hconres-482,F000449 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 F000449 Rep. Fortenberry, Jeff [R-NE-1] R NE 2006-09-26 1
109-hconres-482,L000552 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 L000552 Rep. LaHood, Ray [R-IL-18] R IL 2006-09-26 1
109-hconres-482,E000172 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 E000172 Rep. Emerson, Jo Ann [R-MO-8] R MO 2006-09-26 1
109-hconres-482,H001037 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 H001037 Rep. Herseth, Stephanie [D-SD-At Large] D SD 2006-09-26 1
109-hconres-482,C001062 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2006-09-26 1
109-hconres-482,K000364 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 K000364 Rep. Kuhl, John R. "Randy", Jr. [R-NY-29] R NY 2006-09-26 1
109-hconres-482,B001244 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 B001244 Rep. Bonner, Jo [R-AL-1] R AL 2006-09-26 1
109-hconres-482,N000181 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 N000181 Rep. Nunes, Devin [R-CA-21] R CA 2006-09-26 1
109-hconres-482,B000420 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 B000420 Rep. Berry, Marion [D-AR-1] D AR 2006-09-26 1
109-hconres-482,S001148 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 S001148 Rep. Simpson, Michael K. [R-ID-2] R ID 2006-09-26 1
109-hconres-482,H001038 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 H001038 Rep. Higgins, Brian [D-NY-27] D NY 2006-09-26 1
109-hconres-482,R000573 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 R000573 Rep. Ross, Mike [D-AR-4] D AR 2006-09-26 1
109-hconres-482,P000586 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 P000586 Rep. Putnam, Adam H. [R-FL-12] R FL 2006-09-26 1
109-hconres-482,C001050 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 C001050 Rep. Cardoza, Dennis A. [D-CA-18] D CA 2006-09-26 1
109-hconres-482,P000587 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 P000587 Rep. Pence, Mike [R-IN-6] R IN 2006-09-26 1
109-hconres-482,H000528 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 H000528 Rep. Herger, Wally [R-CA-2] R CA 2006-09-26 1
109-hconres-482,B000652 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 B000652 Rep. Boswell, Leonard L. [D-IA-3] D IA 2006-09-26 1
109-hconres-482,M000934 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 M000934 Rep. Moran, Jerry [R-KS-1] R KS 2006-09-26 1
109-hconres-482,N000172 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 N000172 Rep. Nussle, Jim [R-IA-1] R IA 2006-09-26 1
109-hconres-482,O000165 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 O000165 Rep. Osborne, Tom [R-NE-3] R NE 2006-09-26 1
109-hconres-482,T000460 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 T000460 Rep. Thompson, Mike [D-CA-1] D CA 2006-09-26 1
109-hconres-482,H000329 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 H000329 Rep. Hastings, Doc [R-WA-4] R WA 2006-09-26 1
109-hconres-482,H000067 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 H000067 Rep. Hall, Ralph M. [R-TX-4] R TX 2006-09-26 1
109-hconres-482,L000111 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 L000111 Rep. Latham, Tom [R-IA-4] R IA 2006-09-26 1
109-hconres-482,C001059 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 C001059 Rep. Costa, Jim [D-CA-20] D CA 2006-09-26 1
109-hconres-482,K000363 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 K000363 Rep. Kline, John [R-MN-2] R MN 2006-09-26 1
109-hconres-482,E000250 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 E000250 Rep. Evans, Lane [D-IL-17] D IL 2006-09-26 1
109-hconres-482,W000791 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 W000791 Rep. Walden, Greg [R-OR-2] R OR 2006-09-26 1
109-hconres-482,U000031 Expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts. 109-hconres-482 U000031 Rep. Upton, Fred [R-MI-6] R MI 2006-09-26 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);