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

44 rows where bill_id = "103-hres-545" 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 29
  • 1 15
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hres-545,S000718 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 S000718 Rep. Spence, Floyd [R-SC-2] R SC 1994-11-29 0
103-hres-545,S000597 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 S000597 Rep. Smith, Nick [R-MI-7] R MI 1994-11-29 0
103-hres-545,B000556 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 B000556 Rep. Bliley, Tom [R-VA-7] R VA 1994-10-07 0
103-hres-545,H000172 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 H000172 Rep. Hansen, James V. [R-UT-1] R UT 1994-10-07 0
103-hres-545,K000220 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 K000220 Rep. Kingston, Jack [R-GA-1] R GA 1994-10-07 0
103-hres-545,L000321 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 L000321 Rep. Linder, John [R-GA-4] R GA 1994-10-07 0
103-hres-545,P000066 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 P000066 Rep. Parker, Mike [D-MS-4] D MS 1994-10-07 0
103-hres-545,P000258 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 1994-10-07 0
103-hres-545,E000174 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1994-10-07 0
103-hres-545,C000830 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 C000830 Rep. Cox, Christopher [R-CA-47] R CA 1994-10-07 0
103-hres-545,G000336 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 G000336 Rep. Goss, Porter J. [R-FL-14] R FL 1994-09-30 0
103-hres-545,I000023 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 I000023 Rep. Inglis, Bob [R-SC-4] R SC 1994-09-30 0
103-hres-545,D000217 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 D000217 Rep. DeLay, Tom [R-TX-22] R TX 1994-09-30 0
103-hres-545,P000005 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 P000005 Rep. Packard, Ron [R-CA-48] R CA 1994-09-30 0
103-hres-545,R000307 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 R000307 Rep. Roberts, Pat [R-KS-1] R KS 1994-09-30 0
103-hres-545,C000107 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 C000107 Rep. Canady, Charles T. [R-FL-12] R FL 1994-09-30 0
103-hres-545,G000289 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 1994-09-30 0
103-hres-545,B000078 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 B000078 Rep. Baker, Bill [R-CA-10] R CA 1994-09-30 0
103-hres-545,T000074 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 T000074 Rep. Taylor, Gene [D-MS-5] D MS 1994-09-30 0
103-hres-545,A000217 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 A000217 Rep. Armey, Richard K. [R-TX-26] R TX 1994-09-27 0
103-hres-545,H000528 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 H000528 Rep. Herger, Wally [R-CA-2] R CA 1994-09-27 0
103-hres-545,D000533 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 D000533 Rep. Duncan, John J., Jr. [R-TN-2] R TN 1994-09-27 0
103-hres-545,S000583 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 S000583 Rep. Smith, Lamar [R-TX-21] R TX 1994-09-27 0
103-hres-545,C000640 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 C000640 Rep. Collins, Mac [R-GA-3] R GA 1994-09-27 0
103-hres-545,B001149 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 B001149 Rep. Burton, Dan [R-IN-6] R IN 1994-09-27 0
103-hres-545,T000067 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 T000067 Rep. Taylor, Charles H. [R-NC-11] R NC 1994-09-27 0
103-hres-545,B000208 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 1994-09-27 0
103-hres-545,L000371 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 L000371 Rep. Livingston, Bob [R-LA-1] R LA 1994-09-27 0
103-hres-545,R000395 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 R000395 Rep. Rogers, Harold [R-KY-5] R KY 1994-09-27 0
103-hres-545,D000429 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 D000429 Rep. Doolittle, John T. [R-CA-4] R CA 1994-09-23 1
103-hres-545,B000072 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 B000072 Rep. Baker, Richard H. [R-LA-6] R LA 1994-09-23 1
103-hres-545,H000444 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 H000444 Rep. Hefley, Joel [R-CO-5] R CO 1994-09-23 1
103-hres-545,S000522 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1994-09-23 1
103-hres-545,R000459 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 R000459 Rep. Roth, Toby [R-WI-8] R WI 1994-09-23 1
103-hres-545,S001044 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 S001044 Rep. Stump, Bob [R-AZ-3] R AZ 1994-09-23 1
103-hres-545,B000013 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 1994-09-23 1
103-hres-545,S000675 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 S000675 Rep. Solomon, Gerald B. H. [R-NY-22] R NY 1994-09-23 1
103-hres-545,A000215 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 A000215 Rep. Archer, Bill [R-TX-7] R TX 1994-09-23 1
103-hres-545,B000392 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 B000392 Rep. Bentley, Helen Delich [R-MD-2] R MD 1994-09-23 1
103-hres-545,H000151 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 H000151 Rep. Hancock, Mel [R-MO-7] R MO 1994-09-23 1
103-hres-545,J000174 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 J000174 Rep. Johnson, Sam [R-TX-3] R TX 1994-09-23 1
103-hres-545,D000435 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 D000435 Rep. Dornan, Robert K. [R-CA-46] R CA 1994-09-23 1
103-hres-545,B001066 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 B001066 Rep. Bunning, Jim [R-KY-4] R KY 1994-09-23 1
103-hres-545,S000822 Expressing the sense of the House of Representatives that Dr. Joycelyn Elders be called upon to resign her position as Surgeon General of the United States. 103-hres-545 S000822 Rep. Stearns, Cliff [R-FL-6] R FL 1994-09-23 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 170.177ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API