home / openregs

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

47 rows where bill_id = "111-hr-6507" 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 45
  • 0 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-6507,T000468 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 T000468 Rep. Titus, Dina [D-NV-3] D NV 2010-12-09 0
111-hr-6507,H001038 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 H001038 Rep. Higgins, Brian [D-NY-27] D NY 2010-12-09 0
111-hr-6507,R000011 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 R000011 Rep. Rahall, Nick J., II [D-WV-3] D WV 2010-12-08 1
111-hr-6507,Y000033 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 Y000033 Rep. Young, Don [R-AK-At Large] R AK 2010-12-08 1
111-hr-6507,D000191 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 2010-12-08 1
111-hr-6507,P000265 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2010-12-08 1
111-hr-6507,C000794 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 C000794 Rep. Costello, Jerry F. [D-IL-12] D IL 2010-12-08 1
111-hr-6507,D000533 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 D000533 Rep. Duncan, John J., Jr. [R-TN-2] R TN 2010-12-08 1
111-hr-6507,N000147 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2010-12-08 1
111-hr-6507,E000092 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 E000092 Rep. Ehlers, Vernon J. [R-MI-3] R MI 2010-12-08 1
111-hr-6507,N000002 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 N000002 Rep. Nadler, Jerrold [D-NY-8] D NY 2010-12-08 1
111-hr-6507,W000796 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 W000796 Rep. Westmoreland, Lynn A. [R-GA-3] R GA 2010-12-08 1
111-hr-6507,B000911 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 B000911 Rep. Brown, Corrine [D-FL-3] D FL 2010-12-08 1
111-hr-6507,M001150 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 M001150 Rep. Miller, Candice S. [R-MI-10] R MI 2010-12-08 1
111-hr-6507,F000116 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 F000116 Rep. Filner, Bob [D-CA-51] D CA 2010-12-08 1
111-hr-6507,C001079 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 C001079 Rep. Cao, Anh "Joseph" [R-LA-2] R LA 2010-12-08 1
111-hr-6507,J000126 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2010-12-08 1
111-hr-6507,L000553 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 L000553 Rep. LaTourette, Steven C. [R-OH-14] R OH 2010-12-08 1
111-hr-6507,C000984 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 2010-12-08 1
111-hr-6507,B000652 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 B000652 Rep. Boswell, Leonard L. [D-IA-3] D IA 2010-12-08 1
111-hr-6507,H000712 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 H000712 Rep. Holden, Tim [D-PA-17] D PA 2010-12-08 1
111-hr-6507,B001229 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 B001229 Rep. Baird, Brian [D-WA-3] D WA 2010-12-08 1
111-hr-6507,L000560 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 L000560 Rep. Larsen, Rick [D-WA-2] D WA 2010-12-08 1
111-hr-6507,C001037 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 C001037 Rep. Capuano, Michael E. [D-MA-8] D MA 2010-12-08 1
111-hr-6507,B001242 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 B001242 Rep. Bishop, Timothy H. [D-NY-1] D NY 2010-12-08 1
111-hr-6507,M001149 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2010-12-08 1
111-hr-6507,C001060 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 C001060 Rep. Carnahan, Russ [D-MO-3] D MO 2010-12-08 1
111-hr-6507,N000179 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 N000179 Rep. Napolitano, Grace F. [D-CA-38] D CA 2010-12-08 1
111-hr-6507,H001042 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 H001042 Rep. Hirono, Mazie K. [D-HI-2] D HI 2010-12-08 1
111-hr-6507,A000362 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 A000362 Rep. Altmire, Jason [D-PA-4] D PA 2010-12-08 1
111-hr-6507,W000799 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 W000799 Rep. Walz, Timothy J. [D-MN-1] D MN 2010-12-08 1
111-hr-6507,S001171 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 S001171 Rep. Shuler, Heath [D-NC-11] D NC 2010-12-08 1
111-hr-6507,A000363 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 A000363 Rep. Arcuri, Michael A. [D-NY-24] D NY 2010-12-08 1
111-hr-6507,C001065 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 C001065 Rep. Carney, Christopher P. [D-PA-10] D PA 2010-12-08 1
111-hr-6507,C001068 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2010-12-08 1
111-hr-6507,R000581 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 R000581 Rep. Richardson, Laura [D-CA-37] D CA 2010-12-08 1
111-hr-6507,S001165 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 S001165 Rep. Sires, Albio [D-NJ-13] D NJ 2010-12-08 1
111-hr-6507,E000290 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 E000290 Rep. Edwards, Donna F. [D-MD-4] D MD 2010-12-08 1
111-hr-6507,O000107 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 2010-12-08 1
111-hr-6507,H001040 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 H001040 Rep. Hare, Phil [D-IL-17] D IL 2010-12-08 1
111-hr-6507,S001178 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 S001178 Rep. Schauer, Mark H. [D-MI-7] D MI 2010-12-08 1
111-hr-6507,M001174 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 M001174 Rep. McMahon, Michael E. [D-NY-13] D NY 2010-12-08 1
111-hr-6507,P000600 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 P000600 Rep. Perriello, Thomas S.P. [D-VA-5] D VA 2010-12-08 1
111-hr-6507,G000559 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 G000559 Rep. Garamendi, John [D-CA-10] D CA 2010-12-08 1
111-hr-6507,J000288 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2010-12-08 1
111-hr-6507,M001143 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2010-12-08 1
111-hr-6507,E000288 To designate the buildings occupied by the Department of Transportation located at 1200 New Jersey Avenue, Southeast, and 1201 4th Street, Southeast, in the District of Columbia as the "James L. Oberstar United States Department of Transportation Building Complex". 111-hr-6507 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2010-12-08 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);
Powered by Datasette · Queries took 347.773ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API