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

86 rows where bill_id = "115-hconres-72" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date (date)

is_original_cosponsor 2

  • 0 79
  • 1 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-hconres-72,G000535 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 2018-09-25 0
115-hconres-72,C001107 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001107 Rep. Curbelo, Carlos [R-FL-26] R FL 2018-09-25 0
115-hconres-72,T000193 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2018-09-25 0
115-hconres-72,Z000017 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 Z000017 Rep. Zeldin, Lee M. [R-NY-1] R NY 2018-09-25 0
115-hconres-72,S001191 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001191 Rep. Sinema, Kyrsten [D-AZ-9] D AZ 2018-09-24 0
115-hconres-72,R000435 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000435 Rep. Ros-Lehtinen, Ileana [R-FL-27] R FL 2018-09-24 0
115-hconres-72,D000610 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 D000610 Rep. Deutch, Theodore E. [D-FL-22] D FL 2018-09-17 0
115-hconres-72,S001145 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2018-09-17 0
115-hconres-72,T000468 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 T000468 Rep. Titus, Dina [D-NV-1] D NV 2018-09-13 0
115-hconres-72,W000797 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 W000797 Rep. Wasserman Schultz, Debbie [D-FL-23] D FL 2018-09-13 0
115-hconres-72,P000594 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 P000594 Rep. Paulsen, Erik [R-MN-3] R MN 2018-09-10 0
115-hconres-72,M001157 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2018-09-10 0
115-hconres-72,R000591 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000591 Rep. Roby, Martha [R-AL-2] R AL 2018-09-05 0
115-hconres-72,C001093 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001093 Rep. Collins, Doug [R-GA-9] R GA 2018-09-04 0
115-hconres-72,F000466 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 F000466 Rep. Fitzpatrick, Brian K. [R-PA-8] R PA 2018-09-04 0
115-hconres-72,S001170 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001170 Rep. Shea-Porter, Carol [D-NH-1] D NH 2018-08-28 0
115-hconres-72,C001084 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001084 Rep. Cicilline, David N. [D-RI-1] D RI 2018-08-03 0
115-hconres-72,H001078 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 H001078 Rep. Handel, Karen C. [R-GA-6] R GA 2018-07-31 0
115-hconres-72,C001078 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001078 Rep. Connolly, Gerald E. [D-VA-11] D VA 2018-07-31 0
115-hconres-72,J000126 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2018-07-25 0
115-hconres-72,J000032 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 J000032 Rep. Jackson Lee, Sheila [D-TX-18] D TX 2018-07-25 0
115-hconres-72,B000213 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 B000213 Rep. Barton, Joe [R-TX-6] R TX 2018-07-25 0
115-hconres-72,C000059 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C000059 Rep. Calvert, Ken [R-CA-42] R CA 2018-07-24 0
115-hconres-72,S001156 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001156 Rep. Sánchez, Linda T. [D-CA-38] D CA 2018-07-23 0
115-hconres-72,M001179 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 M001179 Rep. Marino, Tom [R-PA-10] R PA 2018-07-23 0
115-hconres-72,I000056 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 I000056 Rep. Issa, Darrell E. [R-CA-49] R CA 2018-07-23 0
115-hconres-72,D000623 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 D000623 Rep. DeSaulnier, Mark [D-CA-11] D CA 2018-07-23 0
115-hconres-72,J000255 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2018-07-18 0
115-hconres-72,W000187 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 W000187 Rep. Waters, Maxine [D-CA-43] D CA 2018-07-18 0
115-hconres-72,R000578 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000578 Rep. Reichert, David G. [R-WA-8] R WA 2018-07-16 0
115-hconres-72,C001112 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001112 Rep. Carbajal, Salud O. [D-CA-24] D CA 2018-07-16 0
115-hconres-72,L000578 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 L000578 Rep. LaMalfa, Doug [R-CA-1] R CA 2018-07-16 0
115-hconres-72,M001188 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 M001188 Rep. Meng, Grace [D-NY-6] D NY 2018-07-13 0
115-hconres-72,J000288 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2018-07-13 0
115-hconres-72,L000480 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 L000480 Rep. Lowey, Nita M. [D-NY-17] D NY 2018-07-12 0
115-hconres-72,S001193 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001193 Rep. Swalwell, Eric [D-CA-15] D CA 2018-07-11 0
115-hconres-72,G000559 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 G000559 Rep. Garamendi, John [D-CA-3] D CA 2018-07-03 0
115-hconres-72,C001110 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001110 Rep. Correa, J. Luis [D-CA-46] D CA 2018-06-27 0
115-hconres-72,S001196 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001196 Rep. Stefanik, Elise M. [R-NY-21] R NY 2018-06-13 0
115-hconres-72,R000409 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000409 Rep. Rohrabacher, Dana [R-CA-48] R CA 2018-06-12 0
115-hconres-72,C001068 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2018-06-12 0
115-hconres-72,G000578 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 G000578 Rep. Gaetz, Matt [R-FL-1] R FL 2018-06-08 0
115-hconres-72,S000244 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-5] R WI 2018-06-08 0
115-hconres-72,M001137 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 M001137 Rep. Meeks, Gregory W. [D-NY-5] D NY 2018-06-08 0
115-hconres-72,R000486 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000486 Rep. Roybal-Allard, Lucille [D-CA-40] D CA 2018-06-07 0
115-hconres-72,F000464 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 F000464 Rep. Faso, John J. [R-NY-19] R NY 2018-06-07 0
115-hconres-72,K000210 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 K000210 Rep. King, Peter T. [R-NY-2] R NY 2018-06-07 0
115-hconres-72,C001105 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001105 Rep. Comstock, Barbara [R-VA-10] R VA 2018-06-06 0
115-hconres-72,N000147 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2018-06-05 0
115-hconres-72,M001163 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 M001163 Rep. Matsui, Doris O. [D-CA-6] D CA 2018-05-22 0
115-hconres-72,L000551 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 L000551 Rep. Lee, Barbara [D-CA-13] D CA 2018-04-23 0
115-hconres-72,P000592 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 P000592 Rep. Poe, Ted [R-TX-2] R TX 2018-04-05 0
115-hconres-72,B000574 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2018-03-20 0
115-hconres-72,D000216 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2018-01-29 0
115-hconres-72,L000579 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 L000579 Rep. Lowenthal, Alan S. [D-CA-47] D CA 2018-01-29 0
115-hconres-72,P000608 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 P000608 Rep. Peters, Scott H. [D-CA-52] D CA 2018-01-29 0
115-hconres-72,J000298 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 J000298 Rep. Jayapal, Pramila [D-WA-7] D WA 2018-01-29 0
115-hconres-72,L000397 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 L000397 Rep. Lofgren, Zoe [D-CA-19] D CA 2018-01-29 0
115-hconres-72,S001150 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001150 Rep. Schiff, Adam B. [D-CA-28] D CA 2018-01-29 0
115-hconres-72,S000583 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S000583 Rep. Smith, Lamar [R-TX-21] R TX 2018-01-03 0
115-hconres-72,F000460 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 F000460 Rep. Farenthold, Blake [R-TX-27] R TX 2018-01-03 0
115-hconres-72,B001270 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 B001270 Rep. Bass, Karen [D-CA-37] D CA 2018-01-03 0
115-hconres-72,P000598 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 P000598 Rep. Polis, Jared [D-CO-2] D CO 2018-01-03 0
115-hconres-72,C001094 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001094 Rep. Cook, Paul [R-CA-8] R CA 2017-12-07 0
115-hconres-72,E000179 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 E000179 Rep. Engel, Eliot L. [D-NY-16] D NY 2017-12-07 0
115-hconres-72,R000487 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000487 Rep. Royce, Edward R. [R-CA-39] R CA 2017-11-16 0
115-hconres-72,C001080 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001080 Rep. Chu, Judy [D-CA-27] D CA 2017-11-16 0
115-hconres-72,N000179 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 N000179 Rep. Napolitano, Grace F. [D-CA-32] D CA 2017-10-12 0
115-hconres-72,J000294 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 J000294 Rep. Jeffries, Hakeem S. [D-NY-8] D NY 2017-10-12 0
115-hconres-72,D000625 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 D000625 Rep. Donovan, Daniel M., Jr. [R-NY-11] R NY 2017-10-11 0
115-hconres-72,O000171 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 O000171 Rep. O'Halleran, Tom [D-AZ-1] D AZ 2017-10-11 0
115-hconres-72,L000582 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 L000582 Rep. Lieu, Ted [D-CA-33] D CA 2017-10-04 0
115-hconres-72,R000577 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000577 Rep. Ryan, Tim [D-OH-13] D OH 2017-10-04 0
115-hconres-72,R000602 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000602 Rep. Rice, Kathleen M. [D-NY-4] D NY 2017-10-04 0
115-hconres-72,G000574 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 G000574 Rep. Gallego, Ruben [D-AZ-7] D AZ 2017-10-02 0
115-hconres-72,G000410 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 G000410 Rep. Green, Gene [D-TX-29] D TX 2017-09-28 0
115-hconres-72,M001166 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 M001166 Rep. McNerney, Jerry [D-CA-9] D CA 2017-08-04 0
115-hconres-72,K000387 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 K000387 Rep. Knight, Stephen [R-CA-25] R CA 2017-08-04 0
115-hconres-72,C001053 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001053 Rep. Cole, Tom [R-OK-4] R OK 2017-07-25 0
115-hconres-72,M000087 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 M000087 Rep. Maloney, Carolyn B. [D-NY-12] D NY 2017-07-24 1
115-hconres-72,F000448 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 F000448 Rep. Franks, Trent [R-AZ-8] R AZ 2017-07-24 1
115-hconres-72,S001201 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001201 Rep. Suozzi, Thomas R. [D-NY-3] D NY 2017-07-24 1
115-hconres-72,R000606 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 R000606 Rep. Raskin, Jamie [D-MD-8] D MD 2017-07-24 1
115-hconres-72,E000215 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 E000215 Rep. Eshoo, Anna G. [D-CA-18] D CA 2017-07-24 1
115-hconres-72,S001175 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 S001175 Rep. Speier, Jackie [D-CA-14] D CA 2017-07-24 1
115-hconres-72,C001051 Expressing the sense of Congress that child safety is the first priority of custody and visitation adjudications, and that State courts should improve adjudications of custody where family violence is alleged. 115-hconres-72 C001051 Rep. Carter, John R. [R-TX-31] R TX 2017-07-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 204.931ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API