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

54 rows where bill_id = "113-hr-5285" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 34
  • 1 20
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
113-hr-5285,L000575 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 L000575 Rep. Lankford, James [R-OK-5] R OK 2014-11-13 0
113-hr-5285,S000250 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 S000250 Rep. Sessions, Pete [R-TX-32] R TX 2014-09-18 0
113-hr-5285,P000599 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 P000599 Rep. Posey, Bill [R-FL-8] R FL 2014-09-18 0
113-hr-5285,R000583 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 R000583 Rep. Rooney, Thomas J. [R-FL-17] R FL 2014-09-18 0
113-hr-5285,P000588 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 P000588 Rep. Pearce, Stevan [R-NM-2] R NM 2014-09-11 0
113-hr-5285,M001189 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 M001189 Rep. Messer, Luke [R-IN-6] R IN 2014-09-11 0
113-hr-5285,H001052 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 H001052 Rep. Harris, Andy [R-MD-1] R MD 2014-09-11 0
113-hr-5285,B001271 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 B001271 Rep. Benishek, Dan [R-MI-1] R MI 2014-09-11 0
113-hr-5285,R000598 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 R000598 Rep. Rothfus, Keith J. [R-PA-12] R PA 2014-09-11 0
113-hr-5285,P000601 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 P000601 Rep. Palazzo, Steven M. [R-MS-4] R MS 2014-09-11 0
113-hr-5285,S001172 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 S001172 Rep. Smith, Adrian [R-NE-3] R NE 2014-09-09 0
113-hr-5285,R000587 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 R000587 Rep. Ribble, Reid J. [R-WI-8] R WI 2014-09-09 0
113-hr-5285,J000295 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 J000295 Rep. Joyce, David P. [R-OH-14] R OH 2014-09-08 0
113-hr-5285,F000458 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 F000458 Rep. Fincher, Stephen Lee [R-TN-8] R TN 2014-09-08 0
113-hr-5285,B001243 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2014-09-08 0
113-hr-5285,C001096 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 C001096 Rep. Cramer, Kevin [R-ND-At Large] R ND 2014-09-08 0
113-hr-5285,H001059 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 H001059 Rep. Hultgren, Randy [R-IL-14] R IL 2014-09-08 0
113-hr-5285,W000672 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2014-09-08 0
113-hr-5285,R000591 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 R000591 Rep. Roby, Martha [R-AL-2] R AL 2014-09-08 0
113-hr-5285,W000798 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 W000798 Rep. Walberg, Tim [R-MI-7] R MI 2014-09-08 0
113-hr-5285,L000571 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 L000571 Rep. Lummis, Cynthia M. [R-WY-At Large] R WY 2014-09-08 0
113-hr-5285,S001154 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 S001154 Rep. Shuster, Bill [R-PA-9] R PA 2014-09-08 0
113-hr-5285,G000567 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 G000567 Rep. Griffin, Tim [R-AR-2] R AR 2014-09-08 0
113-hr-5285,B001282 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 B001282 Rep. Barr, Andy [R-KY-6] R KY 2014-08-01 0
113-hr-5285,C000059 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 C000059 Rep. Calvert, Ken [R-CA-42] R CA 2014-08-01 0
113-hr-5285,G000549 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 G000549 Rep. Gerlach, Jim [R-PA-6] R PA 2014-07-31 0
113-hr-5285,H001053 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 H001053 Rep. Hartzler, Vicky [R-MO-4] R MO 2014-07-31 0
113-hr-5285,R000586 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 R000586 Rep. Renacci, James B. [R-OH-16] R OH 2014-07-31 0
113-hr-5285,L000569 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 L000569 Rep. Luetkemeyer, Blaine [R-MO-3] R MO 2014-07-31 0
113-hr-5285,G000289 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2014-07-31 0
113-hr-5285,F000445 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 F000445 Rep. Forbes, J. Randy [R-VA-4] R VA 2014-07-31 0
113-hr-5285,M001144 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2014-07-31 0
113-hr-5285,F000456 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 F000456 Rep. Fleming, John [R-LA-4] R LA 2014-07-31 0
113-hr-5285,N000182 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2014-07-31 0
113-hr-5285,P000373 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2014-07-30 1
113-hr-5285,M001182 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 M001182 Rep. Mulvaney, Mick [R-SC-5] R SC 2014-07-30 1
113-hr-5285,H001057 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 H001057 Rep. Huelskamp, Tim [R-KS-1] R KS 2014-07-30 1
113-hr-5285,B001256 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2014-07-30 1
113-hr-5285,L000566 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 L000566 Rep. Latta, Robert E. [R-OH-5] R OH 2014-07-30 1
113-hr-5285,B000755 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 B000755 Rep. Brady, Kevin [R-TX-8] R TX 2014-07-30 1
113-hr-5285,N000186 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2014-07-30 1
113-hr-5285,A000055 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 A000055 Rep. Aderholt, Robert B. [R-AL-4] R AL 2014-07-30 1
113-hr-5285,B001269 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 B001269 Rep. Barletta, Lou [R-PA-11] R PA 2014-07-30 1
113-hr-5285,P000606 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 P000606 Rep. Pittenger, Robert [R-NC-9] R NC 2014-07-30 1
113-hr-5285,W000814 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 W000814 Rep. Weber, Randy K., Sr. [R-TX-14] R TX 2014-07-30 1
113-hr-5285,L000578 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 L000578 Rep. LaMalfa, Doug [R-CA-1] R CA 2014-07-30 1
113-hr-5285,C000266 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 C000266 Rep. Chabot, Steve [R-OH-1] R OH 2014-07-30 1
113-hr-5285,F000449 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 F000449 Rep. Fortenberry, Jeff [R-NE-1] R NE 2014-07-30 1
113-hr-5285,S000522 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 2014-07-30 1
113-hr-5285,L000576 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 L000576 Rep. Long, Billy [R-MO-7] R MO 2014-07-30 1
113-hr-5285,S001186 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 S001186 Rep. Southerland, Steve II [R-FL-2] R FL 2014-07-30 1
113-hr-5285,J000255 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2014-07-30 1
113-hr-5285,B001273 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 B001273 Rep. Black, Diane [R-TN-6] R TN 2014-07-30 1
113-hr-5285,J000296 Child Welfare Provider Inclusion Act of 2014 113-hr-5285 J000296 Rep. Jolly, David [R-FL-13] R FL 2014-07-30 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);