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 = "112-hconres-116" 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 46
  • 1 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hconres-116,M000404 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2012-12-11 0
112-hconres-116,G000549 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 G000549 Rep. Gerlach, Jim [R-PA-6] R PA 2012-11-15 0
112-hconres-116,C001038 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 C001038 Rep. Crowley, Joseph [D-NY-7] D NY 2012-11-15 0
112-hconres-116,G000562 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 G000562 Rep. Gardner, Cory [R-CO-4] R CO 2012-11-15 0
112-hconres-116,K000376 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 K000376 Rep. Kelly, Mike [R-PA-3] R PA 2012-09-21 0
112-hconres-116,C001051 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 C001051 Rep. Carter, John R. [R-TX-31] R TX 2012-09-21 0
112-hconres-116,L000569 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 L000569 Rep. Luetkemeyer, Blaine [R-MO-9] R MO 2012-09-21 0
112-hconres-116,S001145 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2012-09-21 0
112-hconres-116,P000258 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 2012-09-21 0
112-hconres-116,K000210 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 K000210 Rep. King, Peter T. [R-NY-3] R NY 2012-09-21 0
112-hconres-116,L000571 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 L000571 Rep. Lummis, Cynthia M. [R-WY-At Large] R WY 2012-09-21 0
112-hconres-116,L000563 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 L000563 Rep. Lipinski, Daniel [D-IL-3] D IL 2012-09-19 0
112-hconres-116,B001273 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 B001273 Rep. Black, Diane [R-TN-6] R TN 2012-09-19 0
112-hconres-116,D000607 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 D000607 Rep. Donnelly, Joe [D-IN-2] D IN 2012-09-19 0
112-hconres-116,B000461 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 B000461 Rep. Bilbray, Brian P. [R-CA-50] R CA 2012-09-19 0
112-hconres-116,R000585 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 R000585 Rep. Reed, Tom [R-NY-29] R NY 2012-09-13 0
112-hconres-116,B001259 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 B001259 Rep. Braley, Bruce L. [D-IA-1] D IA 2012-09-13 0
112-hconres-116,M000309 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 M000309 Rep. McCarthy, Carolyn [D-NY-4] D NY 2012-09-11 0
112-hconres-116,N000185 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 N000185 Rep. Nugent, Richard B. [R-FL-5] R FL 2012-09-11 0
112-hconres-116,C001072 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 C001072 Rep. Carson, Andre [D-IN-7] D IN 2012-07-31 0
112-hconres-116,C000794 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 C000794 Rep. Costello, Jerry F. [D-IL-12] D IL 2012-07-31 0
112-hconres-116,R000170 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 R000170 Rep. Reyes, Silvestre [D-TX-16] D TX 2012-07-31 0
112-hconres-116,W000811 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 W000811 Rep. Walsh, Joe [R-IL-8] R IL 2012-07-31 0
112-hconres-116,K000009 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2012-07-25 0
112-hconres-116,J000292 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 J000292 Rep. Johnson, Bill [R-OH-6] R OH 2012-07-25 0
112-hconres-116,F000449 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 F000449 Rep. Fortenberry, Jeff [R-NE-1] R NE 2012-07-25 0
112-hconres-116,S000244 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-5] R WI 2012-07-23 0
112-hconres-116,W000799 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 W000799 Rep. Walz, Timothy J. [D-MN-1] D MN 2012-07-18 0
112-hconres-116,R000578 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 R000578 Rep. Reichert, David G. [R-WA-8] R WA 2012-07-18 0
112-hconres-116,C001037 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 C001037 Rep. Capuano, Michael E. [D-MA-8] D MA 2012-07-18 0
112-hconres-116,B001260 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 B001260 Rep. Buchanan, Vern [R-FL-13] R FL 2012-07-18 0
112-hconres-116,P000595 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 P000595 Rep. Peters, Gary C. [D-MI-9] D MI 2012-07-18 0
112-hconres-116,N000184 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 N000184 Rep. Noem, Kristi L. [R-SD-At Large] R SD 2012-07-11 0
112-hconres-116,M001143 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2012-07-11 0
112-hconres-116,S001179 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 S001179 Rep. Schock, Aaron [R-IL-18] R IL 2012-07-11 0
112-hconres-116,M001179 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 M001179 Rep. Marino, Tom [R-PA-10] R PA 2012-07-11 0
112-hconres-116,L000111 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 L000111 Rep. Latham, Tom [R-IA-4] R IA 2012-07-11 0
112-hconres-116,M000312 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2012-06-27 0
112-hconres-116,B001272 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 B001272 Rep. Berg, Rick [R-ND-At Large] R ND 2012-06-18 0
112-hconres-116,J000290 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 J000290 Rep. Jenkins, Lynn [R-KS-2] R KS 2012-06-06 0
112-hconres-116,L000287 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 L000287 Rep. Lewis, John [D-GA-5] D GA 2012-05-30 0
112-hconres-116,M001158 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2012-05-18 0
112-hconres-116,P000265 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2012-04-27 0
112-hconres-116,C001036 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 C001036 Rep. Capps, Lois [D-CA-23] D CA 2012-04-25 0
112-hconres-116,S001187 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 S001187 Rep. Stivers, Steve [R-OH-15] R OH 2012-04-25 0
112-hconres-116,R000587 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 R000587 Rep. Ribble, Reid J. [R-WI-8] R WI 2012-04-25 0
112-hconres-116,K000188 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 K000188 Rep. Kind, Ron [D-WI-3] D WI 2012-04-18 1
112-hconres-116,N000015 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 N000015 Rep. Neal, Richard E. [D-MA-2] D MA 2012-04-18 1
112-hconres-116,D000614 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 D000614 Rep. Duffy, Sean P. [R-WI-7] R WI 2012-04-18 1
112-hconres-116,T000462 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 T000462 Rep. Tiberi, Patrick J. [R-OH-12] R OH 2012-04-18 1
112-hconres-116,M001160 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2012-04-18 1
112-hconres-116,S000364 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 S000364 Rep. Shimkus, John [R-IL-19] R IL 2012-04-18 1
112-hconres-116,E000288 Expressing the sense of the Congress that tax-exempt fraternal benefit societies have historically and continue to provide critical benefits to Americans and United States communities. 112-hconres-116 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2012-04-18 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);