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

15 rows where bill_id = "103-hr-4133" 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 10
  • 1 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-4133,P000259 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 P000259 Rep. Peterson, Douglas (Pete) [D-FL-2] D FL 1994-07-19 0
103-hr-4133,F000434 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 F000434 Rep. Furse, Elizabeth [D-OR-1] D OR 1994-06-27 0
103-hr-4133,U000031 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 U000031 Rep. Upton, Fred [R-MI-6] R MI 1994-06-09 0
103-hr-4133,E000174 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1994-05-26 0
103-hr-4133,C000107 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 C000107 Rep. Canady, Charles T. [R-FL-12] R FL 1994-05-26 0
103-hr-4133,T000253 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 T000253 Rep. Thurman, Karen L. [D-FL-5] D FL 1994-05-12 0
103-hr-4133,W000570 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 W000570 Rep. Wilson, Charles [D-TX-2] D TX 1994-05-12 0
103-hr-4133,T000350 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1994-05-12 0
103-hr-4133,M000797 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 M000797 Rep. Mink, Patsy T. [D-HI-2] D HI 1994-04-28 0
103-hr-4133,K000312 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 K000312 Rep. Kopetski, Mike [D-OR-5] D OR 1994-04-28 0
103-hr-4133,R000436 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 R000436 Rep. Rose, Charlie [D-NC-7] D NC 1994-03-24 1
103-hr-4133,L000295 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 L000295 Rep. Lewis, Thomas F. [R-FL-16] R FL 1994-03-24 1
103-hr-4133,L000305 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 L000305 Rep. Lightfoot, Jim [R-IA-3] R IA 1994-03-24 1
103-hr-4133,L000169 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 L000169 Rep. Leach, James A. [R-IA-1] R IA 1994-03-24 1
103-hr-4133,N000172 To expand the Tree Assistance Program of the Department of Agriculture to assist agriculture producers to pay the costs of replanting commercially grown trees and seedlings, ornamental plants, and other perennial plants that are destroyed by damaging weather or related condition and to change the manner of determining crop yields for trees and seedlings, ornamental plants, and other perennial plants for purposes of emergency crop loss assistance. 103-hr-4133 N000172 Rep. Nussle, Jim [R-IA-2] R IA 1994-03-24 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 6.599ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API