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

264 rows where bill_id = "111-hconres-49" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date (date)

is_original_cosponsor 2

  • 0 153
  • 1 111
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hconres-49,G000560 Supporting the Local Radio Freedom Act. 111-hconres-49 G000560 Rep. Graves, Tom [R-GA-9] R GA 2010-08-10 0
111-hconres-49,C001074 Supporting the Local Radio Freedom Act. 111-hconres-49 C001074 Rep. Childers, Travis [D-MS-1] D MS 2010-05-11 0
111-hconres-49,B001251 Supporting the Local Radio Freedom Act. 111-hconres-49 B001251 Rep. Butterfield, G. K. [D-NC-1] D NC 2010-04-28 0
111-hconres-49,S001178 Supporting the Local Radio Freedom Act. 111-hconres-49 S001178 Rep. Schauer, Mark H. [D-MI-7] D MI 2010-03-24 0
111-hconres-49,K000370 Supporting the Local Radio Freedom Act. 111-hconres-49 K000370 Rep. Kosmas, Suzanne M. [D-FL-24] D FL 2010-03-24 0
111-hconres-49,M001137 Supporting the Local Radio Freedom Act. 111-hconres-49 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2010-03-24 0
111-hconres-49,G000554 Supporting the Local Radio Freedom Act. 111-hconres-49 G000554 Rep. Giffords, Gabrielle [D-AZ-8] D AZ 2010-03-16 0
111-hconres-49,D000355 Supporting the Local Radio Freedom Act. 111-hconres-49 D000355 Rep. Dingell, John D. [D-MI-15] D MI 2010-03-10 0
111-hconres-49,M001151 Supporting the Local Radio Freedom Act. 111-hconres-49 M001151 Rep. Murphy, Tim [R-PA-18] R PA 2010-03-10 0
111-hconres-49,M001174 Supporting the Local Radio Freedom Act. 111-hconres-49 M001174 Rep. McMahon, Michael E. [D-NY-13] D NY 2010-02-23 0
111-hconres-49,O000169 Supporting the Local Radio Freedom Act. 111-hconres-49 O000169 Rep. Owens, William L. [D-NY-23] D NY 2010-01-27 0
111-hconres-49,M001142 Supporting the Local Radio Freedom Act. 111-hconres-49 M001142 Rep. Matheson, Jim [D-UT-2] D UT 2010-01-12 0
111-hconres-49,N000183 Supporting the Local Radio Freedom Act. 111-hconres-49 N000183 Rep. Nye, Glenn C. [D-VA-2] D VA 2009-11-03 0
111-hconres-49,S001169 Supporting the Local Radio Freedom Act. 111-hconres-49 S001169 Rep. Sestak, Joe [D-PA-7] D PA 2009-09-25 0
111-hconres-49,B001229 Supporting the Local Radio Freedom Act. 111-hconres-49 B001229 Rep. Baird, Brian [D-WA-3] D WA 2009-09-17 0
111-hconres-49,L000517 Supporting the Local Radio Freedom Act. 111-hconres-49 L000517 Rep. Lungren, Daniel E. [R-CA-3] R CA 2009-09-10 0
111-hconres-49,C001050 Supporting the Local Radio Freedom Act. 111-hconres-49 C001050 Rep. Cardoza, Dennis A. [D-CA-18] D CA 2009-09-10 0
111-hconres-49,B001263 Supporting the Local Radio Freedom Act. 111-hconres-49 B001263 Rep. Boccieri, John A. [D-OH-16] D OH 2009-09-10 0
111-hconres-49,F000372 Supporting the Local Radio Freedom Act. 111-hconres-49 F000372 Rep. Frelinghuysen, Rodney P. [R-NJ-11] R NJ 2009-07-31 0
111-hconres-49,R000409 Supporting the Local Radio Freedom Act. 111-hconres-49 R000409 Rep. Rohrabacher, Dana [R-CA-46] R CA 2009-07-24 0
111-hconres-49,K000368 Supporting the Local Radio Freedom Act. 111-hconres-49 K000368 Rep. Kirkpatrick, Ann [D-AZ-1] D AZ 2009-07-24 0
111-hconres-49,R000515 Supporting the Local Radio Freedom Act. 111-hconres-49 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2009-07-21 0
111-hconres-49,S001176 Supporting the Local Radio Freedom Act. 111-hconres-49 S001176 Rep. Scalise, Steve [R-LA-1] R LA 2009-07-21 0
111-hconres-49,A000364 Supporting the Local Radio Freedom Act. 111-hconres-49 A000364 Rep. Adler, John H. [D-NJ-3] D NJ 2009-07-21 0
111-hconres-49,C001075 Supporting the Local Radio Freedom Act. 111-hconres-49 C001075 Rep. Cassidy, Bill [R-LA-6] R LA 2009-07-16 0
111-hconres-49,H001045 Supporting the Local Radio Freedom Act. 111-hconres-49 H001045 Rep. Harper, Gregg [R-MS-3] R MS 2009-07-16 0
111-hconres-49,M000844 Supporting the Local Radio Freedom Act. 111-hconres-49 M000844 Rep. Mollohan, Alan B. [D-WV-1] D WV 2009-07-16 0
111-hconres-49,M001161 Supporting the Local Radio Freedom Act. 111-hconres-49 M001161 Rep. Melancon, Charlie [D-LA-3] D LA 2009-06-23 0
111-hconres-49,G000548 Supporting the Local Radio Freedom Act. 111-hconres-49 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2009-06-18 0
111-hconres-49,W000672 Supporting the Local Radio Freedom Act. 111-hconres-49 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2009-06-18 0
111-hconres-49,C001065 Supporting the Local Radio Freedom Act. 111-hconres-49 C001065 Rep. Carney, Christopher P. [D-PA-10] D PA 2009-06-18 0
111-hconres-49,C001077 Supporting the Local Radio Freedom Act. 111-hconres-49 C001077 Rep. Coffman, Mike [R-CO-6] R CO 2009-06-18 0
111-hconres-49,P000586 Supporting the Local Radio Freedom Act. 111-hconres-49 P000586 Rep. Putnam, Adam H. [R-FL-12] R FL 2009-06-09 0
111-hconres-49,T000468 Supporting the Local Radio Freedom Act. 111-hconres-49 T000468 Rep. Titus, Dina [D-NV-3] D NV 2009-06-09 0
111-hconres-49,L000111 Supporting the Local Radio Freedom Act. 111-hconres-49 L000111 Rep. Latham, Tom [R-IA-4] R IA 2009-06-09 0
111-hconres-49,M001148 Supporting the Local Radio Freedom Act. 111-hconres-49 M001148 Rep. Meek, Kendrick B. [D-FL-17] D FL 2009-06-09 0
111-hconres-49,E000226 Supporting the Local Radio Freedom Act. 111-hconres-49 E000226 Rep. Etheridge, Bob [D-NC-2] D NC 2009-06-09 0
111-hconres-49,C000243 Supporting the Local Radio Freedom Act. 111-hconres-49 C000243 Rep. Castle, Michael N. [R-DE-At Large] R DE 2009-06-09 0
111-hconres-49,K000371 Supporting the Local Radio Freedom Act. 111-hconres-49 K000371 Rep. Kratovil, Frank, Jr. [D-MD-1] D MD 2009-06-09 0
111-hconres-49,K000372 Supporting the Local Radio Freedom Act. 111-hconres-49 K000372 Rep. Kilroy, Mary Jo [D-OH-15] D OH 2009-06-09 0
111-hconres-49,R000578 Supporting the Local Radio Freedom Act. 111-hconres-49 R000578 Rep. Reichert, David G. [R-WA-8] R WA 2009-06-09 0
111-hconres-49,F000454 Supporting the Local Radio Freedom Act. 111-hconres-49 F000454 Rep. Foster, Bill [D-IL-14] D IL 2009-06-09 0
111-hconres-49,K000009 Supporting the Local Radio Freedom Act. 111-hconres-49 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2009-06-04 0
111-hconres-49,H000324 Supporting the Local Radio Freedom Act. 111-hconres-49 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2009-06-04 0
111-hconres-49,C001079 Supporting the Local Radio Freedom Act. 111-hconres-49 C001079 Rep. Cao, Anh "Joseph" [R-LA-2] R LA 2009-06-04 0
111-hconres-49,K000172 Supporting the Local Radio Freedom Act. 111-hconres-49 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2009-06-02 0
111-hconres-49,B001257 Supporting the Local Radio Freedom Act. 111-hconres-49 B001257 Rep. Bilirakis, Gus M. [R-FL-9] R FL 2009-06-02 0
111-hconres-49,L000567 Supporting the Local Radio Freedom Act. 111-hconres-49 L000567 Rep. Lance, Leonard [R-NJ-7] R NJ 2009-06-02 0
111-hconres-49,B001231 Supporting the Local Radio Freedom Act. 111-hconres-49 B001231 Rep. Berkley, Shelley [D-NV-1] D NV 2009-06-02 0
111-hconres-49,T000466 Supporting the Local Radio Freedom Act. 111-hconres-49 T000466 Rep. Teague, Harry [D-NM-2] D NM 2009-06-02 0
111-hconres-49,L000570 Supporting the Local Radio Freedom Act. 111-hconres-49 L000570 Rep. Lujan, Ben Ray [D-NM-3] D NM 2009-06-02 0
111-hconres-49,R000487 Supporting the Local Radio Freedom Act. 111-hconres-49 R000487 Rep. Royce, Edward R. [R-CA-40] R CA 2009-06-02 0
111-hconres-49,S001162 Supporting the Local Radio Freedom Act. 111-hconres-49 S001162 Rep. Schwartz, Allyson Y. [D-PA-13] D PA 2009-06-02 0
111-hconres-49,I000023 Supporting the Local Radio Freedom Act. 111-hconres-49 I000023 Rep. Inglis, Bob [R-SC-4] R SC 2009-06-02 0
111-hconres-49,K000188 Supporting the Local Radio Freedom Act. 111-hconres-49 K000188 Rep. Kind, Ron [D-WI-3] D WI 2009-06-02 0
111-hconres-49,B001260 Supporting the Local Radio Freedom Act. 111-hconres-49 B001260 Rep. Buchanan, Vern [R-FL-13] R FL 2009-05-21 0
111-hconres-49,S001168 Supporting the Local Radio Freedom Act. 111-hconres-49 S001168 Rep. Sarbanes, John P. [D-MD-3] D MD 2009-05-21 0
111-hconres-49,B000461 Supporting the Local Radio Freedom Act. 111-hconres-49 B000461 Rep. Bilbray, Brian P. [R-CA-50] R CA 2009-05-21 0
111-hconres-49,S000522 Supporting the Local Radio Freedom Act. 111-hconres-49 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 2009-05-21 0
111-hconres-49,S001164 Supporting the Local Radio Freedom Act. 111-hconres-49 S001164 Rep. Schmidt, Jean [R-OH-2] R OH 2009-05-21 0
111-hconres-49,S000465 Supporting the Local Radio Freedom Act. 111-hconres-49 S000465 Rep. Skelton, Ike [D-MO-4] D MO 2009-05-19 0
111-hconres-49,P000523 Supporting the Local Radio Freedom Act. 111-hconres-49 P000523 Rep. Price, David E. [D-NC-4] D NC 2009-05-19 0
111-hconres-49,C000984 Supporting the Local Radio Freedom Act. 111-hconres-49 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 2009-05-19 0
111-hconres-49,L000274 Supporting the Local Radio Freedom Act. 111-hconres-49 L000274 Rep. Lewis, Jerry [R-CA-41] R CA 2009-05-19 0
111-hconres-49,H000528 Supporting the Local Radio Freedom Act. 111-hconres-49 H000528 Rep. Herger, Wally [R-CA-2] R CA 2009-05-19 0
111-hconres-49,R000004 Supporting the Local Radio Freedom Act. 111-hconres-49 R000004 Rep. Radanovich, George [R-CA-19] R CA 2009-05-14 0
111-hconres-49,K000360 Supporting the Local Radio Freedom Act. 111-hconres-49 K000360 Rep. Kirk, Mark Steven [R-IL-10] R IL 2009-05-14 0
111-hconres-49,M000508 Supporting the Local Radio Freedom Act. 111-hconres-49 M000508 Rep. McKeon, Howard P. "Buck" [R-CA-25] R CA 2009-05-14 0
111-hconres-49,B001227 Supporting the Local Radio Freedom Act. 111-hconres-49 B001227 Rep. Brady, Robert A. [D-PA-1] D PA 2009-05-14 0
111-hconres-49,R000582 Supporting the Local Radio Freedom Act. 111-hconres-49 R000582 Rep. Roe, David P. [R-TN-1] R TN 2009-05-14 0
111-hconres-49,S001165 Supporting the Local Radio Freedom Act. 111-hconres-49 S001165 Rep. Sires, Albio [D-NJ-13] D NJ 2009-05-14 0
111-hconres-49,D000609 Supporting the Local Radio Freedom Act. 111-hconres-49 D000609 Rep. Driehaus, Steve [D-OH-1] D OH 2009-05-14 0
111-hconres-49,T000238 Supporting the Local Radio Freedom Act. 111-hconres-49 T000238 Rep. Thornberry, Mac [R-TX-13] R TX 2009-05-12 0
111-hconres-49,P000422 Supporting the Local Radio Freedom Act. 111-hconres-49 P000422 Rep. Pomeroy, Earl [D-ND-At Large] D ND 2009-05-12 0
111-hconres-49,C000059 Supporting the Local Radio Freedom Act. 111-hconres-49 C000059 Rep. Calvert, Ken [R-CA-44] R CA 2009-05-12 0
111-hconres-49,C001060 Supporting the Local Radio Freedom Act. 111-hconres-49 C001060 Rep. Carnahan, Russ [D-MO-3] D MO 2009-05-12 0
111-hconres-49,P000600 Supporting the Local Radio Freedom Act. 111-hconres-49 P000600 Rep. Perriello, Thomas S.P. [D-VA-5] D VA 2009-05-12 0
111-hconres-49,P000583 Supporting the Local Radio Freedom Act. 111-hconres-49 P000583 Rep. Paul, Ron [R-TX-14] R TX 2009-05-07 0
111-hconres-49,M001140 Supporting the Local Radio Freedom Act. 111-hconres-49 M001140 Rep. Moore, Dennis [D-KS-3] D KS 2009-05-07 0
111-hconres-49,G000021 Supporting the Local Radio Freedom Act. 111-hconres-49 G000021 Rep. Gallegly, Elton [R-CA-24] R CA 2009-05-07 0
111-hconres-49,H000636 Supporting the Local Radio Freedom Act. 111-hconres-49 H000636 Rep. Hinojosa, Ruben [D-TX-15] D TX 2009-05-07 0
111-hconres-49,R000435 Supporting the Local Radio Freedom Act. 111-hconres-49 R000435 Rep. Ros-Lehtinen, Ileana [R-FL-18] R FL 2009-05-07 0
111-hconres-49,M001154 Supporting the Local Radio Freedom Act. 111-hconres-49 M001154 Rep. Miller, Brad [D-NC-13] D NC 2009-05-07 0
111-hconres-49,W000799 Supporting the Local Radio Freedom Act. 111-hconres-49 W000799 Rep. Walz, Timothy J. [D-MN-1] D MN 2009-05-07 0
111-hconres-49,C001064 Supporting the Local Radio Freedom Act. 111-hconres-49 C001064 Rep. Campbell, John [R-CA-48] R CA 2009-04-27 0
111-hconres-49,D000533 Supporting the Local Radio Freedom Act. 111-hconres-49 D000533 Rep. Duncan, John J., Jr. [R-TN-2] R TN 2009-04-27 0
111-hconres-49,B001254 Supporting the Local Radio Freedom Act. 111-hconres-49 B001254 Rep. Boren, Dan [D-OK-2] D OK 2009-04-23 0
111-hconres-49,R000572 Supporting the Local Radio Freedom Act. 111-hconres-49 R000572 Rep. Rogers, Mike J. [R-MI-8] R MI 2009-04-23 0
111-hconres-49,M001158 Supporting the Local Radio Freedom Act. 111-hconres-49 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2009-04-23 0
111-hconres-49,V000108 Supporting the Local Radio Freedom Act. 111-hconres-49 V000108 Rep. Visclosky, Peter J. [D-IN-1] D IN 2009-04-23 0
111-hconres-49,P000587 Supporting the Local Radio Freedom Act. 111-hconres-49 P000587 Rep. Pence, Mike [R-IN-6] R IN 2009-04-23 0
111-hconres-49,K000369 Supporting the Local Radio Freedom Act. 111-hconres-49 K000369 Rep. Kissell, Larry [D-NC-8] D NC 2009-04-23 0
111-hconres-49,L000287 Supporting the Local Radio Freedom Act. 111-hconres-49 L000287 Rep. Lewis, John [D-GA-5] D GA 2009-04-23 0
111-hconres-49,O000168 Supporting the Local Radio Freedom Act. 111-hconres-49 O000168 Rep. Olson, Pete [R-TX-22] R TX 2009-04-23 0
111-hconres-49,B000208 Supporting the Local Radio Freedom Act. 111-hconres-49 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2009-04-23 0
111-hconres-49,M001172 Supporting the Local Radio Freedom Act. 111-hconres-49 M001172 Rep. Markey, Betsy [D-CO-4] D CO 2009-04-23 0
111-hconres-49,H001041 Supporting the Local Radio Freedom Act. 111-hconres-49 H001041 Rep. Heller, Dean [R-NV-2] R NV 2009-04-02 0
111-hconres-49,F000043 Supporting the Local Radio Freedom Act. 111-hconres-49 F000043 Rep. Fattah, Chaka [D-PA-2] D PA 2009-04-02 0
111-hconres-49,S000822 Supporting the Local Radio Freedom Act. 111-hconres-49 S000822 Rep. Stearns, Cliff [R-FL-6] R FL 2009-04-02 0
111-hconres-49,R000576 Supporting the Local Radio Freedom Act. 111-hconres-49 R000576 Rep. Ruppersberger, C. A. Dutch [D-MD-2] D MD 2009-04-02 0

Next page

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);