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

53 rows where bill_id = "113-hr-4698" 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 32
  • 0 21
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
113-hr-4698,B001262 Every Child is a Blessing Act of 2014 113-hr-4698 B001262 Rep. Broun, Paul C. [R-GA-10] R GA 2014-07-16 0
113-hr-4698,N000182 Every Child is a Blessing Act of 2014 113-hr-4698 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2014-07-15 0
113-hr-4698,M000689 Every Child is a Blessing Act of 2014 113-hr-4698 M000689 Rep. Mica, John L. [R-FL-7] R FL 2014-06-24 0
113-hr-4698,S001189 Every Child is a Blessing Act of 2014 113-hr-4698 S001189 Rep. Scott, Austin [R-GA-8] R GA 2014-06-24 0
113-hr-4698,M001190 Every Child is a Blessing Act of 2014 113-hr-4698 M001190 Rep. Mullin, Markwayne [R-OK-2] R OK 2014-06-10 0
113-hr-4698,R000598 Every Child is a Blessing Act of 2014 113-hr-4698 R000598 Rep. Rothfus, Keith J. [R-PA-12] R PA 2014-06-09 0
113-hr-4698,H001053 Every Child is a Blessing Act of 2014 113-hr-4698 H001053 Rep. Hartzler, Vicky [R-MO-4] R MO 2014-06-09 0
113-hr-4698,B001280 Every Child is a Blessing Act of 2014 113-hr-4698 B001280 Rep. Bentivolio, Kerry L. [R-MI-11] R MI 2014-06-09 0
113-hr-4698,O000168 Every Child is a Blessing Act of 2014 113-hr-4698 O000168 Rep. Olson, Pete [R-TX-22] R TX 2014-06-09 0
113-hr-4698,G000563 Every Child is a Blessing Act of 2014 113-hr-4698 G000563 Rep. Gibbs, Bob [R-OH-7] R OH 2014-06-09 0
113-hr-4698,B001283 Every Child is a Blessing Act of 2014 113-hr-4698 B001283 Rep. Bridenstine, Jim [R-OK-1] R OK 2014-06-09 0
113-hr-4698,J000289 Every Child is a Blessing Act of 2014 113-hr-4698 J000289 Rep. Jordan, Jim [R-OH-4] R OH 2014-06-09 0
113-hr-4698,M000508 Every Child is a Blessing Act of 2014 113-hr-4698 M000508 Rep. McKeon, Howard P. "Buck" [R-CA-25] R CA 2014-06-09 0
113-hr-4698,S000250 Every Child is a Blessing Act of 2014 113-hr-4698 S000250 Rep. Sessions, Pete [R-TX-32] R TX 2014-06-09 0
113-hr-4698,Y000063 Every Child is a Blessing Act of 2014 113-hr-4698 Y000063 Rep. Yoder, Kevin [R-KS-3] R KS 2014-06-09 0
113-hr-4698,M000485 Every Child is a Blessing Act of 2014 113-hr-4698 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2014-06-09 0
113-hr-4698,B001243 Every Child is a Blessing Act of 2014 113-hr-4698 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2014-05-23 0
113-hr-4698,R000575 Every Child is a Blessing Act of 2014 113-hr-4698 R000575 Rep. Rogers, Mike D. [R-AL-3] R AL 2014-05-23 0
113-hr-4698,P000588 Every Child is a Blessing Act of 2014 113-hr-4698 P000588 Rep. Pearce, Stevan [R-NM-2] R NM 2014-05-22 0
113-hr-4698,D000614 Every Child is a Blessing Act of 2014 113-hr-4698 D000614 Rep. Duffy, Sean P. [R-WI-7] R WI 2014-05-22 0
113-hr-4698,B001271 Every Child is a Blessing Act of 2014 113-hr-4698 B001271 Rep. Benishek, Dan [R-MI-1] R MI 2014-05-22 0
113-hr-4698,H001045 Every Child is a Blessing Act of 2014 113-hr-4698 H001045 Rep. Harper, Gregg [R-MS-3] R MS 2014-05-21 1
113-hr-4698,F000448 Every Child is a Blessing Act of 2014 113-hr-4698 F000448 Rep. Franks, Trent [R-AZ-8] R AZ 2014-05-21 1
113-hr-4698,B001256 Every Child is a Blessing Act of 2014 113-hr-4698 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2014-05-21 1
113-hr-4698,J000255 Every Child is a Blessing Act of 2014 113-hr-4698 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2014-05-21 1
113-hr-4698,G000566 Every Child is a Blessing Act of 2014 113-hr-4698 G000566 Rep. Gowdy, Trey [R-SC-4] R SC 2014-05-21 1
113-hr-4698,L000576 Every Child is a Blessing Act of 2014 113-hr-4698 L000576 Rep. Long, Billy [R-MO-7] R MO 2014-05-21 1
113-hr-4698,K000376 Every Child is a Blessing Act of 2014 113-hr-4698 K000376 Rep. Kelly, Mike [R-PA-3] R PA 2014-05-21 1
113-hr-4698,P000602 Every Child is a Blessing Act of 2014 113-hr-4698 P000602 Rep. Pompeo, Mike [R-KS-4] R KS 2014-05-21 1
113-hr-4698,H001058 Every Child is a Blessing Act of 2014 113-hr-4698 H001058 Rep. Huizenga, Bill [R-MI-2] R MI 2014-05-21 1
113-hr-4698,M001144 Every Child is a Blessing Act of 2014 113-hr-4698 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2014-05-21 1
113-hr-4698,N000186 Every Child is a Blessing Act of 2014 113-hr-4698 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2014-05-21 1
113-hr-4698,B001273 Every Child is a Blessing Act of 2014 113-hr-4698 B001273 Rep. Black, Diane [R-TN-6] R TN 2014-05-21 1
113-hr-4698,F000456 Every Child is a Blessing Act of 2014 113-hr-4698 F000456 Rep. Fleming, John [R-LA-4] R LA 2014-05-21 1
113-hr-4698,B000755 Every Child is a Blessing Act of 2014 113-hr-4698 B000755 Rep. Brady, Kevin [R-TX-8] R TX 2014-05-21 1
113-hr-4698,S001176 Every Child is a Blessing Act of 2014 113-hr-4698 S001176 Rep. Scalise, Steve [R-LA-1] R LA 2014-05-21 1
113-hr-4698,P000373 Every Child is a Blessing Act of 2014 113-hr-4698 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2014-05-21 1
113-hr-4698,L000563 Every Child is a Blessing Act of 2014 113-hr-4698 L000563 Rep. Lipinski, Daniel [D-IL-3] D IL 2014-05-21 1
113-hr-4698,W000810 Every Child is a Blessing Act of 2014 113-hr-4698 W000810 Rep. Woodall, Rob [R-GA-7] R GA 2014-05-21 1
113-hr-4698,S000937 Every Child is a Blessing Act of 2014 113-hr-4698 S000937 Rep. Stockman, Steve [R-TX-36] R TX 2014-05-21 1
113-hr-4698,S001188 Every Child is a Blessing Act of 2014 113-hr-4698 S001188 Rep. Stutzman, Marlin A. [R-IN-3] R IN 2014-05-21 1
113-hr-4698,H001052 Every Child is a Blessing Act of 2014 113-hr-4698 H001052 Rep. Harris, Andy [R-MD-1] R MD 2014-05-21 1
113-hr-4698,W000814 Every Child is a Blessing Act of 2014 113-hr-4698 W000814 Rep. Weber, Randy K., Sr. [R-TX-14] R TX 2014-05-21 1
113-hr-4698,M001179 Every Child is a Blessing Act of 2014 113-hr-4698 M001179 Rep. Marino, Tom [R-PA-10] R PA 2014-05-21 1
113-hr-4698,F000461 Every Child is a Blessing Act of 2014 113-hr-4698 F000461 Rep. Flores, Bill [R-TX-17] R TX 2014-05-21 1
113-hr-4698,S000522 Every Child is a Blessing Act of 2014 113-hr-4698 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 2014-05-21 1
113-hr-4698,H001057 Every Child is a Blessing Act of 2014 113-hr-4698 H001057 Rep. Huelskamp, Tim [R-KS-1] R KS 2014-05-21 1
113-hr-4698,P000606 Every Child is a Blessing Act of 2014 113-hr-4698 P000606 Rep. Pittenger, Robert [R-NC-9] R NC 2014-05-21 1
113-hr-4698,B000213 Every Child is a Blessing Act of 2014 113-hr-4698 B000213 Rep. Barton, Joe [R-TX-6] R TX 2014-05-21 1
113-hr-4698,C001062 Every Child is a Blessing Act of 2014 113-hr-4698 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2014-05-21 1
113-hr-4698,L000564 Every Child is a Blessing Act of 2014 113-hr-4698 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2014-05-21 1
113-hr-4698,C000266 Every Child is a Blessing Act of 2014 113-hr-4698 C000266 Rep. Chabot, Steve [R-OH-1] R OH 2014-05-21 1
113-hr-4698,M001156 Every Child is a Blessing Act of 2014 113-hr-4698 M001156 Rep. McHenry, Patrick T. [R-NC-10] R NC 2014-05-21 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);