openregs: legislation: 26 rows where congress = 100 and policy_area = "Emergency Management" sorted by introduced

Congressional bills and resolutions from Congress.gov, filtered to policy areas relevant to environmental, health, agriculture, and wildlife regulation.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

26 rows where congress = 100 and policy_area = "Emergency Management" sorted by introduced_date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

bill_id	congress	bill_type	bill_number	title	policy_area	introduced_date ▲	latest_action_date	latest_action_text	origin_chamber	sponsor_name	sponsor_state	sponsor_party	sponsor_bioguide_id	cosponsor_count	summary_text	update_date
100-sconres-131	100	sconres	131	A concurrent resolution supporting the International Decade for Natural Disaster Reduction by endorsing the establishment of a United States Decade for Natural Disaster Reduction.	Emergency Management	1988-07-07	1988-10-19	Message on Senate action sent to the House.	Senate	Sen. Hatch, Orrin G. [R-UT]	UT	R	H000338	8	Declares that the Congress endorses the establishment of a United States Decade for Natural Disaster Reduction as a means of supporting the goal of the International Decade for Natural Disaster Reduction to enhance existing cooperative efforts and promote new cooperative efforts to reduce the devastating impact of natural hazards.	2025-01-14T19:00:46Z
100-hr-4936	100	hr	4936	Wildfire Suppression Assistance Act	Emergency Management	1988-06-28	1988-10-21	Received in the Senate and read twice and referred to the Committee on Agriculture.	House	Rep. Volkmer, Harold L. [D-MO-9]	MO	D	V000112	8	(Measure passed House, amended) Wildfire Suppression Assistance Act - Amends the Temporary Emergency Wildfire Suppression Act to make permanent the authority of the Secretary of Agriculture or the Secretary of the Interior to enter into reciprocal agreements with foreign fire organizations for wildfire protection and, in the absence of such an agreement, to accept emergency wildfire protection from a foreign fire organization or provide it to a foreign nation when to do so is in our best interest. Continues, on a permanent basis, the reimbursement of Canada or Canadian fire organizations for U.S. wildfire protection furnished pursuant to specified agreements.	2025-01-14T16:41:20Z
100-hr-4687	100	hr	4687	A bill to establish a trust fund using civil penalties collected under the Occupational Health and Safety Act of 1970 to compensate victims of the collapse of the L'Ambiance Plaza in Bridgeport, Connecticut.	Emergency Management	1988-05-25	1988-07-05	Referred to Subcommittee on Health and Safety.	House	Rep. Shays, Christopher [R-CT-4]	CT	R	S001144	5	Establishes a trust fund using civil penalties collected under the Occupational Safety and Health Act of 1970 to compensate victims of the collapse of the L'Ambiance Plaza in Bridgeport, Connecticut.	2025-07-21T19:44:15Z
100-hr-4647	100	hr	4647	A bill to provide for the establishment of the National Commission on Natural Resources Disasters, to provide for increased planning and cooperation with local fire fighting forces in the event of forest fires, and for other purposes.	Emergency Management	1988-05-19	1988-06-28	See H.R.4936.	House	Rep. Herger, Wally [R-CA-2]	CA	R	H000528	0	Title I: National Commission on Natural Resources Disasters - Establishes a National Commission on the 1987 Natural Resources Disaster to study the effects of the fires in western and southeastern States and make recommendations concerning a smooth transition from the loss of natural resources. Directs the Commission to study the effects of the fires on: (1) the economic stability of the affected communities; (2) the availability of sufficient timber supplies to meet future industry needs; (3) fish and wildlife habitats; (4) recreation in the affected areas; (5) the ecosystems in the areas; and (6) management plans of the affected National Forest System lands. Requires a report to the Secretary of Agriculture by December 1, 1989. Authorizes the Commission to accept contributions of money and services in carrying out its duties. Authorizes the Secretary, if contributions are insufficient, to transfer to the Commission funds available from the general fund of the Treasury. Terminates the Commission 90 days after submission of its report to the Secretary. Title II: Forest Fire Fighting Planning and Cooperation - Directs the Secretary of Agriculture to report to the Congress on the rehabilitation needs of each national forest resulting from forest fire damage during the previous year. Requires the Secretary to offer training programs annually to certify volunteers for suppressing forest fires on National Forest System lands. Requires the Secretary to report to the Congress on the local fire emergency mobilization plans for fire fighting equipment in each area of the National Forest System which is prone to forest fires. Amends Federal law authorizing reciprocal fire protection agreements between U.S. agencies and other fire fighting organizations by deleting proximity restrictions on the use and reimbursement of foreign firefighting organizations for fighting wildfires throughout the United States. Requires the agency head to determine that no U.S. firefighting organization is reasonably available to provide su…	2024-02-05T11:45:06Z
100-s-2380	100	s	2380	Disaster Relief Act Amendments of 1988	Emergency Management	1988-05-12	1988-10-22	Indefinitely postponed by Senate by Unanimous Consent.	Senate	Sen. Stafford, Robert T. [R-VT]	VT	R	S000776	3	Disaster Relief Act Amendments of 1988 - Renames the Disaster Relief Act of 1974 the Major Disaster Relief and Emergency Assistance Act. Amends such Act to establish an emergency assistance program. Sets forth procedures for State governors to request the President to determine an emergency. Describes general Federal assistance under such an emergency, including debris removal assistance. Limits the amount of emergency assistance to $5,000,000, which may be exceeded if the President finds it necessary. Requires the President to report to the Congress on the nature and extent of an emergency when such limitation is exceeded. Increases from $25,000 to $50,000 the maximum amount of grants to States for improvement, maintenance, and updating of State plans. Allows the consideration of economic status when providing disaster assistance. Requires public and private nonprofit facilities in flood hazard areas to maintain flood insurance. Declares that major disaster and emergency assistance shall not be considered income or a resource when determining benefit levels for Federal programs. Declares that major disaster and emergency assistance shall not be deemed a major Federal action under the National Environmental Policy Act of 1969. Authorizes the Federal Government to recover the cost of assistance from any person whose negligent act or omission, or whose act or omission while engaged in ultra-hazardous activity, resulted in an emergency of major disaster. Directs the President to conduct audits and investigations necessary to ensure compliance with this Act. Sets forth provisions relating to criminal and civil penalties. Sets forth procedures for State governors to request declarations by the President that a major disaster exists. Requires such request to be based on a finding that effective response to such disaster is beyond the capabilities of the State and local governments and that Federal assistance is necessary. Describes general and essential assistance that the President may provide. Decreases from 10…	2025-08-28T20:06:11Z
100-s-2381	100	s	2381	A bill to authorize appropriations for activities under the Federal Fire Prevention and Control Act of 1974.	Emergency Management	1988-05-12	1988-06-22	Subcommittee on Consumer. Hearings held.	Senate	Sen. Gore, Albert, Jr. [D-TN]	TN	D	G000321	1	Amends the Federal Fire Prevention and Control Act of 1974 to authorize appropriations for FY 1989 through 1991.	2025-01-14T18:51:33Z
100-hconres-290	100	hconres	290	A concurrent resolution supporting the International Decade for Natural Disaster Reduction by endorsing the establishment of a United States Decade for Natural Disaster Reduction.	Emergency Management	1988-05-03	1988-09-22	Received in the Senate and referred to the Committee on Foreign Relations.	House	Rep. Brown, George E., Jr. [D-CA-36]	CA	D	B000918	12	Declares that the Congress endorses the establishment of a United States Decade for Natural Disaster Reduction as a means of supporting the goal of the International Decade for Natural Disaster Reduction to enhance existing cooperative efforts and promote new cooperative efforts to reduce the devastating impact of natural hazards.	2025-01-14T19:00:46Z
100-hr-4419	100	hr	4419	A bill to authorize appropriations for activities under the Federal Fire Prevention and Control Act of 1974.	Emergency Management	1988-04-20	1988-10-06	Became Public Law No: 100-476.	House	Rep. Walgren, Doug [D-PA-18]	PA	D	W000044	0	(Measure passed Senate, amended) Amends the Federal Fire Prevention and Control Act of 1974 to authorize appropriations for FY 1989 through 1991. Sets a limit on the authorization of such appropriations for National Emergency Training Center site administration. Requires the Administrator of the United States Fire Administration to study and report to the Congress by January 1, 1989, concerning the quality, availability, and degree of use of fire prevention systems for the hearing impaired.	2025-01-14T18:51:33Z
100-s-2086	100	s	2086	A bill to establish a trust fund using civil penalties collected under the Occupational Health and Safety Act of 1970 to compensate victims of the collapse of the L'Ambiance Plaza in Bridgeport, Connecticut.	Emergency Management	1988-02-24	1988-09-26	Placed on Senate Legislative Calendar under General Orders. Calendar No. 998.	Senate	Sen. Weicker, Lowell P., Jr. [R-CT]	CT	R	W000253	1	Establishes a trust fund using civil penalties collected under the Occupational Safety and Health Act of 1970 to compensate victims of the collapse of the L'Ambiance Plaza in Bridgeport, Connecticut.	2025-04-21T12:24:17Z
100-hr-3792	100	hr	3792	A bill to direct the Administrator of the Small Business Administration to declare the recent Long Island brown tide contamination a disaster for purposes of providing disaster assistance under the Small Business Act, and for other purposes.	Emergency Management	1987-12-17	1987-12-22	Referred to Subcommittee on SBA, and the General Economy.	House	Rep. Hochbrueckner, George J. [D-NY-1]	NY	D	H000670	19	Directs the Administrator of the Small Business Administration to declare the recent Long Island brown tide contamination a disaster for purposes of providing disaster assistance under the Small Business Act. Prohibits making eligibility of individual applicants for assistance dependent on: (1) the number of disaster victims in any county or other political subdivision; or (2) whether or not an applicant who normally conducts operations in the area of such contamination is otherwise situated or located in such area.	2024-02-07T15:46:26Z
100-hr-3694	100	hr	3694	A bill to direct the Administrator of the Small Business Administration to declare the recent North Carolina coast red tide contamination a disaster for purposes of providing disaster assistance under the Small Business Act, and for other purposes.	Emergency Management	1987-12-03	1987-12-10	Referred to Subcommittee on SBA, and the General Economy.	House	Rep. Jones, Walter B. [D-NC-1]	NC	D	J000256	7	Directs the Administrator of the Small Business Administration to declare the recent North Carolina coast red tide contamination a disaster for purposes of providing disaster assistance under the Small Business Act. Prohibits making eligibility of individual applicants for assistance dependent on: (1) the number of disaster victims in any county or other political subdivision; or (2) whether or not an applicant who normally conducts operations in the area of such contamination is otherwise situated or located in such area.	2024-02-07T15:46:26Z
100-hr-3704	100	hr	3704	Hotel and Motel Fire Safety Act of 1988	Emergency Management	1987-12-03	1988-09-29	Received in the Senate and read twice and referred to the Committee on Commerce.	House	Rep. Walgren, Doug [D-PA-18]	PA	D	W000044	3	(Measure passed House, amended) Hotel and Motel Fire Safety Act of 1988 - Amends the Federal Fire Prevention and Control Act of 1974 to require the Director of the Federal Emergency Management Agency to issue guidelines governing the use and installation of automatic sprinkler systems and smoke detectors in places of public accommodation. Includes within such guidelines the requirements that, in each public accommodation: (1) an automatic smoke detection system be installed in accordance with the appropriate American National Standard for Fire Alarm Systems; and (2) an automatic sprinkler system be installed in accordance with the appropriate American National Standard for the Installation of Sprinkler Systems, except in places that are two stories or lower, have no interior corridors, and have immediate exterior egress from rooms to a ground level area. Requires States to submit to the Director lists of public accommodations which meet such guidelines so that the Director can compile, publish, and distribute to Federal agencies a master list of all public accommodations that meet such guidelines. Authorizes the Director to take steps to encourage States to promote the use of automatic sprinkler and smoke detection systems and to disseminate information on the life safety value and use of such systems. Amends Federal law to limit the studies and surveys conducted to establish the lodging expenses of Federal employees on official business to public accommodations which meet such guidelines. Prohibits the General Services Administration (GSA) from listing rates offered by places of public accommodation which do not meet such guidelines in any directory of lodging accommodations for Federal employees on official business. Requires that such directories include a description of the access and safety devices which each listed public accommodation provides for handicapped guests. Prohibits Federal funding for the specified purpose of sponsoring conferences, meetings, and similar events at public accommodations that d…	2025-01-14T18:51:33Z
100-hr-3630	100	hr	3630	A bill to provide for the establishment of the National Commission on the 1987 Natural Resources Disaster.	Emergency Management	1987-11-10	1988-06-28	See H.R.4936.	House	Rep. Herger, Wally [R-CA-2]	CA	R	H000528	5	Establishes a National Commission on the 1987 Natural Resources Disaster to study the effects of the fires in two western States and make recommendations concerning a smooth transition from the loss of natural resources. Directs the Commission to study the effects of the fires on: (1) the economic stability of the affected communities; (2) the availability of sufficient timber supplies to meet future industry needs; (3) fish and wildlife habitats; (4) recreation in the affected areas; (5) the ecosystems in the areas; and (6) management plans of the affected National Forest System lands. Requires a report to the Secretary of Agriculture by December 1, 1988. Authorizes the Commission to accept contributions of money and services in carrying out its duties. Authorizes the Secretary, if contributions are insufficient, to transfer to the Commission funds available to the Commodity Credit Corporation. Terminates the Commission 90 days after submission of its report to the Secretary.	2024-02-07T13:32:55Z
100-hres-284	100	hres	284	A resolution honoring the firefighters of the United States for their efforts and sacrifices during the summer fire season of 1987.	Emergency Management	1987-10-09	1987-10-13	Resolution Agreed to in House by Voice Vote.	House	Rep. Lehman, Richard H. [D-CA-18]	CA	D	L000225	58	Declares that the House of Representatives: (1) honors U.S. firefighters for their efforts and sacrifices during the summer fire season of 1987; (2) commends those who gave their lives and conveys condolences to their families and loved ones; and (3) expresses gratitude to all firefighters who fought to protect lives and land in the western United States.	2024-02-06T20:04:02Z
100-s-1503	100	s	1503	A bill to cancel repayment of the community disaster loan made to the City of Prichard, Alabama.	Emergency Management	1987-07-17	1987-07-17	Read twice and referred to the Committee on Environment and Public Works.	Senate	Sen. Heflin, Howell [D-AL]	AL	D	H000445	1	Cancels repayment of the community disaster loan made to the city of Prichard, Alabama.	2025-01-14T17:12:38Z
100-hjres-328	100	hjres	328	A joint resolution to recognize the National Fallen Firefighters' Memorial on the campus of the National Fire Academy in Emmitsburg, Maryland, as the official national memorial to career and volunteer firefighters who die in the line of duty.	Emergency Management	1987-07-01	1987-10-28	Received in the Senate and read twice and referred to the Committee on Rules.	House	Rep. Byron, Beverly B. [D-MD-6]	MD	D	B001220	50	(Measure passed House, amended) Recognizes the National Fallen Firefighters' Memorial at the National Fire Academy in Emmitsburg, Maryland, as the official national memorial to volunteer and career firefighters who die in the line of duty.	2025-01-14T17:21:40Z
100-s-1453	100	s	1453	Major Disaster Relief and Emergency Assistance Amendments of 1987	Emergency Management	1987-06-30	1987-06-30	Read twice and referred to the Committee on Environment and Public Works.	Senate	Sen. Heinz, John [R-PA]	PA	R	H000456	22	Major Disaster Relief and Emergency Assistance Amendments of 1987 - Amends the Disaster Relief Act of 1974 to make eligible for assistance for the repair, restoration, reconstruction, and replacement of damaged facilities special purpose local governments such as levee districts, irrigation districts, and reclamation districts. Declares that the Federal share of such assistance shall not be less than 75 percent (currently, such assistance must not exceed 100 percent). Requires the President to issue rules which provide for the recognition of differences existing among urban, suburban, and rural lands to facilitate adequate removal of debris and wreckage from large lots. Declares the Federal share of assistance for debris removal to be 75 percent. Provides for temporary housing assistance for up to 18 months after the date of a major disaster. Authorizes the President to extend such period for an additional 18 months due to extraordinary circumstances. Declares the Federal share of such assistance to be 100 percent of eligible costs. Provides that temporary housing assistance may not be used for reconstruction or rehabilitation of damaged property when the cost of such assistance exceeds the cost of other applicable types of housing. Sets forth notification requirements for the President when persons apply for temporary housing assistance, including: (1) all forms of assistance available; (2) criteria that must be met to qualify for each type of assistance; (3) limitations which apply to each type of assistance; and (4) the address and telephone number of offices responsible for assisting applicants. Requires that housing assistance account for the applicant's location of and travel time to: (1) the applicant's place of business; (2) schools which family members may attend; (3) any home or place of business whose destruction or damage is the result of the major disaster which created the need for assistance; and (4) crops or livestock the applicant tends which provide 25 percent or more of the applicant's ann…	2025-08-28T20:06:26Z
100-hr-2707	100	hr	2707	Major Disaster Relief and Emergency Assistance Amendments of 1987	Emergency Management	1987-06-17	1988-11-23	Became Public Law No: 100-707.	House	Rep. Ridge, Thomas J. [R-PA-21]	PA	R	R000243	111	(Measure passed Senate, amended) Title I: Disaster Relief and Emergency Assistance Amendments - Disaster Relief and Emergency Assistance Amendments of 1988 - Renames the Disaster Relief Act of 1974 as the Robert T. Stafford Disaster Relief and Emergency Assistance Act. Amends such Act to eliminate the congressional intent to provide a long-range economic recovery program for major disaster areas as a means of assistance to State and local governments. Amends such Act to revise the definition of an emergency to mean any occasion or instance for which, in the determination of the President, Federal assistance is needed to supplement State and local efforts and capabilities to save lives, protect property and public health and safety, and lessen or avert the threat of a catastrophe. Provides that a major disaster means any natural catastrophe. (Currently, both definitions specify types of emergencies and disasters.) Increases the maximum amount that may be authorized for grants to States for plans for disaster preparedness programs. Reorganizes existing titles III, IV, and V of such Act (major disaster and emergency assistance administration, major disaster assistance programs, and emergency assistance programs, respectively) and makes various technical and conforming changes. Provides that Federal major disaster and emergency assistance and comparable assistance provided by States, local governments, and disaster assistance organizations shall not be considered as income or a resource when determining benefit levels under federally funded income assistance or resource-tested benefit programs. Requires the President to establish comprehensive standards to assess the efficiency and effectiveness of major disaster and emergency assistance programs under this Act. Establishes penalties for the misuse of funds and the violation of provisions under this Act. Authorizes the Attorney General to seek relief in an appropriate United States district court. Declares that any person who intentionally causes a condition for wh…	2025-08-28T20:06:03Z
100-hr-2500	100	hr	2500	National Flood Insurance Improvement Act of 1987	Emergency Management	1987-05-21	1987-06-01	Referred to Subcommittee on Housing and Community Development.	House	Rep. Upton, Fred [R-MI-4]	MI	R	U000031	36	National Flood Insurance Improvement Act of 1987 - Amends the National Flood Insurance Act of 1968 to establish a schedule of payments for a structure covered by flood insurance if such structure is condemned by a State or local authority because it is located on land along the shore of a body of water that is subject to imminent collapse. Sets forth a schedule of payments following condemnation and demolition before the structure collapses. Limits the amount of payment if such land collapses or subsides before the owner demolishes and removes the structure, but after the owner has a reasonable period of time following condemnation (or after the date of enactment of the Housing, Community Development, and Homelessness Prevention Act of 1987, whichever occurs later) to demolish and remove it.	2025-08-28T20:07:24Z
100-hconres-87	100	hconres	87	A concurrent resolution to recognize the International Association of Fire Fighters and the National Fallen Fire Fighter Memorial in Colorado Springs, Colorado.	Emergency Management	1987-03-25	1987-10-27	Other Measure S.Con.Res.38 Passed House in Lieu.	House	Rep. Hefley, Joel [R-CO-5]	CO	R	H000444	78	(Measure passed House, amended) Recognizes the memorial to be built in Colorado Springs, Colorado, in honor of fire fighters who have died in the line of duty, as the International Association of Fire Fighters Fallen Fire Fighter Memorial.	2024-02-07T11:39:48Z
100-hr-1823	100	hr	1823	National Flood Insurance Improvement Act of 1987	Emergency Management	1987-03-25	1987-04-01	Referred to Subcommittee on Housing and Community Development.	House	Rep. Upton, Fred [R-MI-4]	MI	R	U000031	23	National Flood Insurance Improvement Act of 1987 - Amends the National Flood Insurance Act of 1968 to establish a schedule of payments for a structure covered by flood insurance if such structure is condemned by a State or local authority because it is located on land along the shore of a body of water that is subject to imminent collapse. Sets forth a schedule of payments following condemnation and dismantlement before the structure collapses. Limits the amount of payment if such land collapses or subsides before the owner dismantles and removes the structure, but after the owner has a reasonable period of time following condemnation (or after the date of enactment of this Act, whichever occurs later) to dismantle and remove it.	2025-08-28T20:05:27Z
100-sconres-38	100	sconres	38	A concurrent resolution to recognize the International Association of Fire Fighters and the National Fallen Fire Fighter Memorial in Colorado Springs, Colorado.	Emergency Management	1987-03-24	1987-11-09	Message on Senate action sent to the House.	Senate	Sen. Armstrong, William L. [R-CO]	CO	R	A000219	9	(Measure passed House, amended, in lieu of H.Con.Res. 87) Recognizes the memorial to be built in Colorado Springs, Colorado, in honor of fire fighters who have died in the line of duty, as the International Association of Fire Fighters Fallen Fire Fighter Memorial.	2025-01-14T17:21:40Z
100-hr-1612	100	hr	1612	A bill to authorize appropriations under the Earthquake Hazards Reduction Act of 1977 for fiscal years 1988 and 1989.	Emergency Management	1987-03-16	1988-02-29	Became Public Law No: 100-252.	House	Rep. Roe, Robert A. [D-NJ-8]	NJ	D	R000383	0	(Measure passed Senate, amended) Amends the Earthquake Hazards Reduction Act of 1977 to authorize appropriations through FY 1990 for contributions to the National Earthquake Hazards Reduction Program by the Federal Emergency Management Agency (FEMA), the U.S. Geological Survey, the National Science Foundation, and the National Bureau of Standards. Limits the level of cost sharing for activities under this Act for States which voluntarily engaged in such sharing with FEMA. Prohibits for States meeting certain qualifications the imposition of new cost-sharing requirements for activities under such Act for FY 1988, but permits FEMA to require up to a 25 percent match in FY 1989.	2025-01-14T18:51:33Z
100-hr-1522	100	hr	1522	A bill to authorize appropriations for activities under the Federal Fire Prevention and Control Act of 1974.	Emergency Management	1987-03-10	1987-06-09	Received in the Senate and read twice and referred to the Committee on Commerce.	House	Rep. Roe, Robert A. [D-NJ-8]	NJ	D	R000383	0	(Measure passed House, amended) Amends the Federal Fire Prevention and Control Act of 1974 to authorize appropriations for FY 1988.	2025-01-14T18:51:33Z
100-hr-981	100	hr	981	A bill to require certain flammable liquid storage facilities to have overflow alarm systems, and for other purposes.	Emergency Management	1987-02-04	1987-02-23	Referred to Subcommittee on Health and Safety.	House	Rep. Guarini, Frank J. [D-NJ-14]	NJ	D	G000511	0	Requires storage tank facilities which contain flammable liquids to be equipped with high level alarm systems designed to activate upon the threat of an overflow. Subjects plans and specifications to the approval of the Assistant Secretary of Labor for Occupational Safety and Health prior to installation. Requires the Assistant Secretary to inspect such installations for compliance with this Act. Requires an alarm system to have a distinctive sound signal audible to all personnel in the event of specified occurrences. Requires any high level alarm system at an unattended facility to prevent the flow of flammable liquid in the event of a power failure. Requires systems installed prior to enactment of this Act to be inspected by the Assistant Secretary. Requires fire and emergency plans for facilities to be filed with the appropriate fire department. Directs the Assistant Secretary to assess civil penalties against owners or operators of noncomplying terminals at a certain sum per day.	2025-07-21T19:44:15Z
100-sres-22	100	sres	22	A resolution commending the community of Chase, Maryland for its assistance to the rescue workers and the survivors of the Amtrak train accident of January 4, 1987.	Emergency Management	1987-01-06	1987-01-06	Submitted in the Senate, considered, and agreed to without amendment and with a preamble by Voice Vote.	Senate	Sen. Byrd, Robert C. [D-WV]	WV	D	B001210	3	Commends the community of Chase, Maryland, for its assistance to the rescue workers and passengers of the Amtrak train accident of January 4, 1987.	2021-06-10T21:48:12Z

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE legislation (
    bill_id TEXT PRIMARY KEY,
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    title TEXT,
    policy_area TEXT,
    introduced_date TEXT,
    latest_action_date TEXT,
    latest_action_text TEXT,
    origin_chamber TEXT,
    sponsor_name TEXT,
    sponsor_state TEXT,
    sponsor_party TEXT,
    sponsor_bioguide_id TEXT,
    cosponsor_count INTEGER DEFAULT 0,
    summary_text TEXT,
    update_date TEXT,
    url TEXT
);
CREATE INDEX idx_leg_congress ON legislation(congress);
CREATE INDEX idx_leg_type ON legislation(bill_type);
CREATE INDEX idx_leg_policy ON legislation(policy_area);
CREATE INDEX idx_leg_date ON legislation(introduced_date);
CREATE INDEX idx_leg_sponsor ON legislation(sponsor_name);
CREATE INDEX idx_leg_sponsor_bioguide ON legislation(sponsor_bioguide_id);