home / openregs

legislation

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

28 rows where bill_type = "s", congress = 95 and policy_area = "Emergency Management" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Emergency Management · 28 ✖

congress 1

  • 95 · 28 ✖

bill_type 1

  • s · 28 ✖
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 url
95-s-3522 95 s 3522 A bill to terminate the authorization for the Meramec Park Lake, Missouri, and for other purposes. Emergency Management 1978-09-25 1978-09-25 Referred to Senate Committee on Environment and Public Works. Senate Sen. Eagleton, Thomas F. [D-MO] MO D E000004 1 Terminates the authorization of the Meramec Park Lake flood control project, Missouri. Directs the Secretary of the Army, through the Chief of Engineers, to: (1) take no action to dispose of works or lands; (2) maintain project lands and structures pending further disposition by Congress; (3) investigate what manner of disposition and future utilization of the lands and structures best serves the public interest; and (4) report the results of such investigation to Congress. Authorizes the use of the funds from the deauthorized project to carry out the provisions of this Act. 2025-01-14T17:12:38Z https://www.congress.gov/bill/95th-congress/senate-bill/3522
95-s-3423 95 s 3423 Disaster Relief Amendments Emergency Management 1978-08-16 1978-08-16 Referred to Senate Select Committee on Small Business. Senate Sen. Brooke, Edward W. [R-MA] MA R B000871 0 Disaster Relief Amendments - Amends the Small Business Act to cancel $5,000 of the principal of a loan made in connection with the snow storms in Massachusetts on February 6 or 7, 1978, upon proof of loss and a bona fide estimate of the cost to rectify such loss. Limits the total amount cancelled plus the total amount of any grant under the Disaster Relief Act of 1974 to change eligibility for direct grants for disaster related expenses. Increases the Federal share in the matching grant program from 75 to 80 percent. Increases the amount of Federal loans available to a local government for disaster relief from 25 to 30 percent of such government's annual operating budget. Shortens from three to two years the period of time before repayment of such loans can be cancelled in the event of the inability of such local governments to meet their expenses. 2025-09-02T17:14:31Z https://www.congress.gov/bill/95th-congress/senate-bill/3423
95-s-2649 95 s 2649 A bill to provide loans for the prevention or retarding of streambank erosion which threatens public and private facilities. Emergency Management 1978-03-06 1978-03-06 Referred to Senate Committee on Environment and Public Works. Senate Sen. Stafford, Robert T. [R-VT] VT R S000776 0 Authorizes the Secretary of the Army, acting through the Chief of Engineers, to make loans to any public or private agency or individual for stabilizing streambanks when erosion threatens, or can be expected to threaten, any facility or structure, or produce or seriously aggravate flooding downstream. 2025-01-14T17:12:38Z https://www.congress.gov/bill/95th-congress/senate-bill/2649
95-s-2353 95 s 2353 Indian Cyclone Rehabilitation and Reconstruction Act Emergency Management 1977-12-15 1977-12-15 Referred to Senate Committee on Foreign Relations. Senate Sen. Kennedy, Edward M. [D-MA] MA D K000105 4 Indian Cyclone Rehabilitation and Reconstruction Act - Amends the Foreign Assistance Act of 1961 to authorize appropriations for a United States contribution to the rehabilitation and reconstruction programs for the disaster-stricken areas of southern India. 2025-09-02T17:13:49Z https://www.congress.gov/bill/95th-congress/senate-bill/2353
95-s-2103 95 s 2103 A bill to exempt disaster payments made in connection with the 1977 crops of wheat, feed grains, upland cotton, and rice from any payment limitation. Emergency Management 1977-09-15 1977-09-15 Referred to Senate Committee on Agriculture, Nutrition and Forestry. Senate Sen. Packwood, Bob [R-OR] OR R P000009 15 Exempts disaster payments made in connection with the 1977 crops of wheat, feed grains, upland cotton, and rice from the payment limitations contained in the Agricultural Act of 1970 and the Agricultural Act of 1949. 2025-01-14T16:41:20Z https://www.congress.gov/bill/95th-congress/senate-bill/2103
95-s-1935 95 s 1935 A bill to amend Public Law 95-18, providing for emergency drought relief measures. Emergency Management 1977-07-27 1977-08-17 Public Law 95-107. Senate Sen. Jackson, Henry M. [D-WA] WA D J000013 11 (Measure passed House, amended) Extends, by two months through January, 1978, the compulsory completion date of federally assisted construction activities undertaken to mitigate the impact of the drought of 1976-1977. Terminates the authority of the Secretary of the Interior to provide drought relief on November 30, 1977. Increases the number of uses to which funds authorized by law to facilitate emergency actions to mitigate the impacts of the 1976-1977 drought may be put. Removes limitations on the amount which the Secretary may extend to any State water resource agency for drought relief. Authorizes the Secretary to condition grants, or waive all or a portion of the repayment of loans made under this Act, upon the agreement of a recipient to undertake a program of water conservation and efficient management meeting standards established by the Secretary. Requires the Secretary to report to Congress on measures which he has undertaken to institute such conservation and management procedures. 2025-04-23T11:41:33Z https://www.congress.gov/bill/95th-congress/senate-bill/1935
95-s-1794 95 s 1794 A bill to authorize appropriations for the Federal Fire Prevention and Control Act of 1974, and to change the name of the National Fire Prevention and Control Administration to the United States Fire Administration. Emergency Management 1977-06-30 1978-06-13 Measure indefinitely postponed in Senate, H. R. 11291 passed in lieu. Senate Sen. Magnuson, Warren G. [D-WA] WA D M000053 1 (Measure indefinitely postponed in Senate, H. R. 11291 passed in lieu) Amends the Federal Fire Prevention and Control Act of 1974 to authorize an appropriation of $25,252,000 for fiscal year 1979 to the United States Fire Administration, including: (1) $6,043,000 for the renovation of the National Academy for Fire Prevention and Control; and (2) $5,600,000 for the Fire Research Center. Changes the name of the National Fire Prevention and Control Administration to the United States Fire Administration. Permits the Administrator, upon request of any State or local government, to investigate the facts, conditions, and probable cause of any serious fire of a recurring nature. Makes available information from such investigation at a reasonable cost to interested persons. Prohibits such information from being admitted as evidence in any court or used in any action for damages growing out of any matter mentioned in such investigation. 2025-01-14T18:51:33Z https://www.congress.gov/bill/95th-congress/senate-bill/1794
95-s-1676 95 s 1676 A bill to amend an emergency flood control authorization in order to authorize emergency protection work in the event of anticipated volcanic eruption. Emergency Management 1977-06-10 1977-06-10 Referred to Senate Committee on Environment and Public Works. Senate Sen. Inouye, Daniel K. [D-HI] HI D I000025 0 Amends the Flood Control Act to authorize the Chief of Engineers to furnish the minimum protection necessary to prevent loss of life and property damage caused by lava flow. 2025-01-14T17:12:38Z https://www.congress.gov/bill/95th-congress/senate-bill/1676
95-s-1512 95 s 1512 A bill to amend the Disaster Relief Act to extend authorizations for the Federal disaster assistance program. Emergency Management 1977-05-13 1977-05-24 Measure indefinitely postponed in Senate (similar provisions in H.R. 6197 as passed Senate). Senate Sen. Burdick, Quentin N. [D-ND] ND D B001077 0 Amends the Disaster Relief Act of 1974 to extend indefinitely authorizations for the Federal disaster assistance program. 2025-01-14T17:12:38Z https://www.congress.gov/bill/95th-congress/senate-bill/1512
95-s-1387 95 s 1387 A bill to authorize necessary flood protection at locations in Kentucky and West Virginia on an expedited basis. Emergency Management 1977-04-26 1977-04-26 Referred to Senate Committee on Environment and Public Works. Senate Sen. Randolph, Jennings [D-WV] WV D R000046 3 Authorizes the Secretary of the Army, acting through the Chief of Engineers, to design and construct on an expedited basis certain flood control facilities on portions of the Big Sandy River, and the Cumberland River, in Kentucky and West Virginia. 2025-01-14T17:12:38Z https://www.congress.gov/bill/95th-congress/senate-bill/1387
95-s-1362 95 s 1362 A bill to amend the Small Business Act to reduce the rate of interest on disaster relief loans under such act, to apply special provisions of such act to such loans made in connection with major disasters occurring after April 1, 1977, and before June 6, 1977. Emergency Management 1977-04-22 1977-04-22 Referred to Senate Select Committee on Small Business. Senate Sen. Byrd, Robert C. [D-WV] WV D B001210 6 Amends the Small Business Act to reduce to three percent per year the interest rate on the Small Business Administration's share of any loan made with respect to a major disaster occurring on or after April 1, 1977, and prior to June 6, 1977. Authorizes the Administrator of the Small Business Administration to grant to the recipient of a disaster loan up to $5,000 to provide immediate relief from the effects of such disaster. Allows cancellation of loans made with respect to disasters occurring on or after April, 1977, and prior to June 6, 1977, according to provisions of the Small Business Act. 2025-01-14T17:16:56Z https://www.congress.gov/bill/95th-congress/senate-bill/1362
95-s-1305 95 s 1305 A bill to amend the Small Business Act to authorize the making of economic injury disaster loans in certain extraordinary circumstances without a disaster declaration. Emergency Management 1977-04-19 1977-07-27 Measure indefinitely postponed in Senate. Senate Sen. Haskell, Floyd K. [D-CO] CO D H000317 8 (Reported to Senate from the Select Committee on Small Business with amendment, S. Rept. 95-138) =Title I: Economic Disaster Designation= - Amends the Small Business Act to authorize the making of economic injury disaster loans not in excess of $100,000 each to small businesses where no disaster has been declared, provided that the Small Business Administration has determined that such businesses have suffered economic injury as a result of the disaster and are in need of financial assistance which is not available on reasonable terms in the disaster stricken area. =Title II: Interest Rate Reductions for Physical Disaster Loans= - Amends the Small Business Act to set the interest rate for Federal disaster loans to repair uninsured residences and personal property, damaged on or after July 1, 1976, at one percent for the first $5,000 of damage, two percent on the next $5,000 of damage, and three percent on all damage valued above $10,000. Sets the interest rate for all other loans made with respect to a physical disaster occurring on or after July 1, 1976, at five percent. Cancels a portion of the principal of disaster loans made with regard to a primary residence which has incurred damage of at least ten percent of its fair market value. Authorizes the Administrator of the Small Business Administration to defer interest payments on certain disaster loans for up to three years. 2025-01-14T17:16:56Z https://www.congress.gov/bill/95th-congress/senate-bill/1305
95-s-1279 95 s 1279 Community Emergency Drought Relief Act of 1977 Emergency Management 1977-04-07 1977-05-23 Public Law 95-31. Senate Sen. Burdick, Quentin N. [D-ND] ND D B001077 0 (Measure passed Senate, amended) Community Emergency Drought Relief Act - =Title I:= Authorizes the Secretary of Commerce to make grants and loans to eligible States, localities, Indian tribes and nonprofit organizations to assist areas adversely affected by drought and water shortages. Provides that projects assisted under this Act shall be only those whose work can be completed by April 30, 1978. Establishes criteria for the allocation of assistance to emergency drought impact areas as designated under this Act. Authorizes appropriations for emergency grants and loans and administrative purposes through fiscal year 1978. States that funds available under this Act shall be available for expenditure for drought impact projects conducted heretofore by eligible applicants during fiscal year 1977 if such projects are compatible with the broad purposes of this Act. =Title II:= Amends the Public Works and Economic Development Act Amendments of 1976 to authorize a six-month delay in the convening date of a White House Conference on Balanced Growth and Economic Development. 2025-01-14T17:12:38Z https://www.congress.gov/bill/95th-congress/senate-bill/1279
95-s-1255 95 s 1255 Italy Disaster Assistance Act Emergency Management 1977-04-06 1977-04-06 Referred to Senate Committee on Foreign Relations. Senate Sen. Brooke, Edward W. [R-MA] MA R B000871 0 Italy Disaster Assistance Act - Authorizes appropriations for the relief of victims of the May 6, 1976, earthquake in Italy. 2025-09-02T17:13:04Z https://www.congress.gov/bill/95th-congress/senate-bill/1255
95-s-1206 95 s 1206 Small Business Emergency Drought Disaster Loan Act Emergency Management 1977-04-01 1977-04-01 Referred to Senate Select Committee on Small Business. Senate Sen. Nelson, Gaylord [D-WI] WI D N000033 1 Small Business Emergency Drought Disaster Loan Act - Authorizes the Small Business Administration to provide emergency drought assistance loans, at five percent interest per annum for a period up to 30 years, to assist small business concerns to overcome the effects of actual or prospective substantial economic injury resulting from the 1976-1977 drought. Requires an actual or expected decrease in business activity of at least 20 percent below normal levels as a condition of eligibility. Allows provisions of this Act to apply to an area newly designated as an emergency droughts impact area by the Administrator. 2025-09-02T17:13:03Z https://www.congress.gov/bill/95th-congress/senate-bill/1206
95-s-1209 95 s 1209 Federal Emergency Assistance and Preparedness Administration Act Emergency Management 1977-04-01 1977-04-01 Referred to Senate Committee on Governmental Affairs. Senate Sen. Proxmire, William [D-WI] WI D P000553 5 Federal Emergency Assistance and Preparedness Administration Act - Establishes the Federal Emergency Assistance and Preparedness Administration headed by a Director who shall be a permanent member of the National Security Council. Requires the Director to establish within the Administration the Offices of Disaster Assistance, Emergency Preparedness, and Program Evaluation, and an Emergency Information Center. Requires the Administration to implement and coordinate all Federal disaster assistance and emergency preparedness programs, develop policies with respect to industrial mobilization and economic readiness for emergencies relating to the national defense, undertake research and development to improve programs under its cognizance, and to gather data on natural, economic, and other phenomena for predicting and planning for industrial and economic mobilization and emergencies and disasters. Directs the Director to make such collected data available to the public and to provide such data to States and localities on a regular basis. Requires the heads of Federal agencies with jurisdiction over any program relating to emergency preparedness or disaster assistance to report annually to the Director on the status of such program. Requires the Director to coordinate such programs with States and localities participating in or applying for such assistance. Transfers to the Administration the functions and authorities of specified agencies respecting programs within the Administration's jurisdiction. Requires the Administration to report annually to Congress. Extends until September 30, 1980, the termination dates of specified provisions of the Federal Civil Defense Act, including those which empower the President to declare a civil defense emergency. 2025-09-02T17:13:05Z https://www.congress.gov/bill/95th-congress/senate-bill/1209
95-s-1147 95 s 1147 A bill to relieve the liability for the repayment of certain erroneously made contributions by the United States. Emergency Management 1977-03-28 1978-09-18 Referred to House Committee on the Judiciary. Senate Sen. Schweiker, Richard S. [R-PA] PA R S000159 1 Relieves specified privately owned libraries and units of local government in Pennsylvania from any liability for the repayment of contributions erroneously made by the United States for disaster relief activities in connection with Hurricane Agnes. 2025-07-21T19:32:26Z https://www.congress.gov/bill/95th-congress/senate-bill/1147
95-s-1124 95 s 1124 Romania Earthquake Relief and Rehabilitation Act Emergency Management 1977-03-24 1977-03-24 Referred to Senate Committee on Foreign Relations. Senate Sen. Kennedy, Edward M. [D-MA] MA D K000105 7 Romania Earthquake Relief and Rehabilitation Act - Amends the Foreign Assistance Act of 1961 to authorize appropriations for fiscal year 1977 for relief and rehabilitation assistance to the victims of recent earthquakes in Romania. Authorizes the President to furnish such assistance. 2025-09-02T17:12:57Z https://www.congress.gov/bill/95th-congress/senate-bill/1124
95-s-1113 95 s 1113 A bill to amend the Disaster Relief Act of 1974 to provide Federal assistance in the case of emergencies determined in accordance with such Act. Emergency Management 1977-03-23 1977-03-23 Referred to Senate Committee on Environment and Public Works. Senate Sen. Metzenbaum, Howard M. [D-OH] OH D M000678 4 Amends the Disaster Relief Act of 1974 to authorize the President to make contributions to States or local governments to help repair or replace a public facility damaged or destroyed in any emergency. Limits the amount of any such contribution to 75 percent of the cost of repair or replacement of such facility. Authorizes additional contributions for repairs to Federal-aid highway systems damaged in any emergency. 2025-01-14T17:12:38Z https://www.congress.gov/bill/95th-congress/senate-bill/1113
95-s-1036 95 s 1036 A bill to amend the Water Resources Control Act of 1976 relating to Federal certification of local flood control projects. Emergency Management 1977-03-18 1977-03-18 Referred to Senate Committee on Environment and Public Works. Senate Sen. Bartlett, Dewey F. [R-OK] OK R B000200 0 Amends the Water Resources Control Act of 1976 to repeal the termination date on procedures under which the Chief of the Corps of Engineers certifies that local flood control improvements are compatible with Federal projects under consideration. 2025-01-14T17:12:38Z https://www.congress.gov/bill/95th-congress/senate-bill/1036
95-s-900 95 s 900 Italy Relief and Rehabilitation Act Emergency Management 1977-03-03 1977-03-03 Referred to Senate Committee on Foreign Relations. Senate Sen. Kennedy, Edward M. [D-MA] MA D K000105 1 Italy Relief and Rehabilitation Act - Authorizes appropriations for fiscal year 1977 for the relief of victims of the May 6, 1976, earthquake in Italy. 2025-09-02T17:12:50Z https://www.congress.gov/bill/95th-congress/senate-bill/900
95-s-832 95 s 832 A bill to amend the Small Business Act and the Consolidated Farm and Rural Development Act to reduce interest rates on certain disaster and emergency loan programs. Emergency Management 1977-03-01 1977-03-01 Referred to Senate Select Committee on Small Business. Senate Sen. Haskell, Floyd K. [D-CO] CO D H000317 1 Amends the Small Business Act to reduce the interest rate on specified disaster loans offered by the Small Business Administration from six and five-eighths percent to three percent. Sets forth standards for qualification for such loans. Amends the Consolidated Farm and Rural Development Act to reduce the interest rate on Farmers Home Administration disaster and emergency loans from five to three percent. 2025-01-14T17:16:56Z https://www.congress.gov/bill/95th-congress/senate-bill/832
95-s-789 95 s 789 A bill to require automatic sprinkler systems in all skilled nursing facilities and intermediate care facilities as a condition of certification under the medicare, medicaid, and Veterans' Administration programs, and to authorize loans and grants to assist such facilities in purchasing and installing such systems. Emergency Management 1977-02-24 1977-02-24 Referred to Senate Committee on Human Resources. Senate Sen. Heinz, John [R-PA] PA R H000456 0 Requires automatic sprinkler systems in all skilled nursing facilities and intermediate care facilities certified for participation in the Medicare, Medicaid, or Veterans' Administration programs unless a waiver of such requirement is granted in accordance with conditions set forth in this Act. Establishes a program of low-interest Federal loans and grants to assist such facilities in constructing or purchasing and installing automatic sprinkler systems. 2025-04-21T12:24:17Z https://www.congress.gov/bill/95th-congress/senate-bill/789
95-s-726 95 s 726 Energy Crisis Relief Act Emergency Management 1977-02-11 1977-02-11 Referred to Senate Committee on Interior and Insular Affairs (Subsequently: Energy and Natural Resources). Senate Sen. Williams, Harrison A., Jr. [D-NJ] NJ D W000502 1 Energy Crisis Relief Act - Establishes procedures for determination by the President that an energy emergency or energy crisis exists, upon request by a Governor of an affected State. Authorizes the President to coordinate Federal energy emergency relief activities upon declaration that such an emergency exists. Stipulates that such relief may include: (1) delivery and allocation of energy supplies to the affected area; (2) establishment of an energy conservation program in the affected area; and (3) emergency energy loans to individuals, public or nonprofit organizations. Authorizes the President to take the following actions where an energy crisis is declared to exist: (1) direct Federal agencies to terminate existing contracts to provide necessary energy supplies to the affected areas; (2) impose price ceilings for energy supplies; and (3) impose compulsory energy conservation programs. Authorizes the President to exercise additional authority under the Disaster Relief Act of 1974 where appropriate. 2025-09-02T17:12:46Z https://www.congress.gov/bill/95th-congress/senate-bill/726
95-s-570 95 s 570 A bill to amend the Disaster Relief Act of 1974. Emergency Management 1977-02-01 1977-02-11 Referred jointly to Senate Committee on Environment and Public Works. Senate Sen. Mathias, Charles McC., Jr. [R-MD] MD R M000241 1 Amends the Disaster Relief Act of 1974 to provide disaster victims, with respect to disasters occurring on or after April 20, 1973, with two options for loan repayment of borrowed funds under certain provisions of the Small Business Act or the Consolidated Farm and Rural Development Act: (1) a three percent interest rate with up to $2,500 forgiveness on the loan; or (2) a one percent interest rate with no loan forgiveness clause. 2025-01-14T17:16:56Z https://www.congress.gov/bill/95th-congress/senate-bill/570
95-s-318 95 s 318 Turkey Relief and Rehabilitation Act Emergency Management 1977-01-18 1977-01-18 Referred to Senate Committee on Foreign Relations. Senate Sen. Kennedy, Edward M. [D-MA] MA D K000105 0 Turkey Relief and Rehabilitation Act - Amends the Foreign Assistance Act of 1961 to authorize the President to grant assistance to the victims of earthquakes in Turkey. Authorizes the appropriation of $10,000,000 for fiscal year 1977 for such assistance. Requires that such assistance, to the maximum extent possible: (1) be distributed by United States voluntary relief agencies and other international relief and development organizations; and (2) be used for construction of seismic-resistant housing. 2025-09-02T17:12:25Z https://www.congress.gov/bill/95th-congress/senate-bill/318
95-s-12 95 s 12 A bill to extend the rural community fire protection program. Emergency Management 1977-01-10 1977-01-10 Referred to Senate Committee on Agriculture and Forestry (Subsequently: Agriculture, Nutrition and Forestry). Senate Sen. Dole, Robert J. [R-KS] KS R D000401 3 Amends the Rural Development Act of 1972 to extend the rural community fire protection program through September, 1980. Directs the Secretary of Agriculture to report annually to the Congress on the assistance sought and rendered under the program. Directs the Secretary to encourage, with the assistance of the Administrator of General Services, the use by rural fire forces of Federal personal property not required by the agency or department holding it. 2025-01-14T16:41:20Z https://www.congress.gov/bill/95th-congress/senate-bill/12
95-s-120 95 s 120 Drought Assistance Amendment Emergency Management 1977-01-10 1977-01-10 Referred to Senate Committee on Public Works (Subsequently: Environment and Public Works). Senate Sen. Abourezk, James [D-SD] SD D A000017 3 Drought Assistance Amendment - Title I: Amendments to the Disaster Relief Act of 1974 - Declares the finding of Congress that droughts and other similar non-cataclysmic disasters require Federal assistance. Requires the President to appoint a Federal coordinator to operate in an area declared a drought emergency area. Permits Federal agencies to provide assistance to drought emergency areas by performing any emergency service essential to save lives and property, including: (1) conservation practices; (2) water supply investigations; (3) education training in conservation techniques for farmers and other affected persons; (4) provisions for water needs and the movement of supplies or persons; (5) the establishment of comprehensive employment and/or manpower training programs; and (6) contributions to State or local governments to carry out the provisions of this Act. Directs that where Federal funds for assistance activities may go by contract to private organizations or firms, preference be given to such organizations or firms in the drought emergency area. Authorizes the President to make grants to States for the purpose of State grants to individuals or families adversely affected by a drought emergency to meet necessary expenses; and to make temporary mortgage or rental payments on behalf of individuals or families who have received written notice of foreclosure on land or equipment as a result of financial hardship caused by drought. Provides for loans to local governments losing revenues as a result of a drought emergency. Title II: Amendments to the Public Works and Economic Development Act of 1965 - Extends to drought emergency areas assistance for economic recovery following the period of emergency aid and replacement of essential facilities and services. Extends coverage of federally-guaranteed loans to the purchase of land and facilities for farming usage. Title III: Miscellaneous Provisions - Makes areas suffering an emergency of any sort eligible for Federal assistance for current school expendit… 2025-09-02T17:12:17Z https://www.congress.gov/bill/95th-congress/senate-bill/120

Advanced export

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

CSV options:

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);
Powered by Datasette · Queries took 34.496ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy