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

36 rows where bill_id = "99-hres-256" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 27
  • 1 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hres-256,O000159 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 O000159 Rep. Owens, Major R. [D-NY-12] D NY 1986-01-29 0
99-hres-256,F000041 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 F000041 Rep. Fascell, Dante B. [D-FL-19] D FL 1985-11-12 0
99-hres-256,P000047 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 P000047 Rep. Panetta, Leon [D-CA-16] D CA 1985-10-28 0
99-hres-256,C000714 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI 1985-10-01 0
99-hres-256,M000826 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1985-10-01 0
99-hres-256,L000226 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 L000226 Rep. Lehman, William [D-FL-17] D FL 1985-10-01 0
99-hres-256,G000120 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 G000120 Rep. Gejdenson, Sam [D-CT-2] D CT 1985-10-01 0
99-hres-256,C000634 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1985-10-01 0
99-hres-256,P000218 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 P000218 Rep. Pepper, Claude [D-FL-18] D FL 1985-10-01 0
99-hres-256,D000222 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 D000222 Rep. Dellums, Ronald V. [D-CA-8] D CA 1985-10-01 0
99-hres-256,E000064 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 E000064 Rep. Edwards, Don [D-CA-10] D CA 1985-10-01 0
99-hres-256,C000919 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 C000919 Rep. Crockett, George W., Jr. [D-MI-13] D MI 1985-10-01 0
99-hres-256,D000471 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 D000471 Rep. Downey, Thomas J. [D-NY-2] D NY 1985-10-01 0
99-hres-256,O000001 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 O000001 Rep. Oakar, Mary Rose [D-OH-20] D OH 1985-10-01 0
99-hres-256,S000586 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 S000586 Rep. Smith, Lawrence [D-FL-16] D FL 1985-10-01 0
99-hres-256,L000263 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 L000263 Rep. Levin, Sander M. [D-MI-17] D MI 1985-10-01 0
99-hres-256,L000237 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 L000237 Rep. Leland, Mickey [D-TX-18] D TX 1985-09-04 0
99-hres-256,R000053 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1985-09-04 0
99-hres-256,S001077 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 S001077 Del. Sunia, Foto I. F. [D-AS-At Large] D AS 1985-09-04 0
99-hres-256,M001057 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1985-09-04 0
99-hres-256,D000416 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 D000416 Rep. Donnelly, Brian J. [D-MA-11] D MA 1985-09-04 0
99-hres-256,S000124 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 S000124 Rep. Scheuer, James H. [D-NY-8] D NY 1985-09-04 0
99-hres-256,S000081 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 S000081 Rep. Savage, Gus [D-IL-2] D IL 1985-09-04 0
99-hres-256,H000367 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 H000367 Rep. Hawkins, Augustus F. [D-CA-29] D CA 1985-09-04 0
99-hres-256,K000172 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1985-09-04 0
99-hres-256,C000621 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 C000621 Rep. Coleman, Ronald D. [D-TX-16] D TX 1985-09-04 0
99-hres-256,B000711 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1985-09-04 0
99-hres-256,C000581 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 C000581 Rep. Coelho, Anthony Lee [D-CA-15] D CA 1985-08-01 1
99-hres-256,D000209 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1985-08-01 1
99-hres-256,G000047 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 G000047 Rep. Garcia, Robert [D-NY-18] D NY 1985-08-01 1
99-hres-256,O000107 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 1985-08-01 1
99-hres-256,M000206 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1985-08-01 1
99-hres-256,R000229 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 R000229 Rep. Richardson, Bill [D-NM-3] D NM 1985-08-01 1
99-hres-256,R000485 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 R000485 Rep. Roybal, Edward R. [D-CA-25] D CA 1985-08-01 1
99-hres-256,T000316 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1985-08-01 1
99-hres-256,F000435 A resolution expressing the sense of the House of Representatives with regard to recent appointments to the National Advisory and Coordinating Council on Bilingual Education. 99-hres-256 F000435 Resident Commissioner Fuster, Jamie B. [D-PR-At Large] D PR 1985-08-01 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);