text: DROP TABLE IF EXISTS "cfc_app_law";
  CREATE TABLE "cfc_app_law"(
    id SERIAL UNIQUE,
    "key" VARCHAR(25),
    title VARCHAR(200),
    summary VARCHAR(1000),
    impact_id INT,
    location_id INT,
    bill_id VARCHAR(15),
    doc_date DATE,
    cite_url VARCHAR(200),
    relevance VARCHAR(800)
  );
  INSERT INTO cfc_app_law VALUES(1,'AZ-HB2002-1717-Y2019','Student Apprenticeship Program; Tax Credits.','Student apprenticeship program; tax credits.',6,3,'1284246','2020-03-05','http://legiscan.com/AZ/HB2002/2020','(NLU)''Taxation in the United States'' => ''Taxes'', ''Tax'' => ''Taxes'', ''Tax refund'' => ''Taxes'', ''Income tax'' => ''Taxes'', ''Taxation'' => ''Taxes'', ''Taxation in the United Kingdom'' => ''Taxes'', ''Arizona'' => ''Location'', ''High school'' => ''Education'', ''Employment'' => ''Jobs'', ''Withholding tax'' => ''Taxes''');
  INSERT INTO cfc_app_law VALUES(2,'AZ-HB2031-1717-Y2019','School Marshals; Requirements; Training.','School marshals; requirements; training.',3,3,'1284401','2019-11-19','http://legiscan.com/AZ/HB2031/2019','(NLU)''Concealed carry in the United States'' => ''Safety'', ''Firearm'' => ''Safety'', ''High school'' => ''Education'', ''College'' => ''Education'', ''Police'' => ''Safety'', ''Gun laws in the United States'' => ''Safety'', ''Parking'' => ''Transportation'', ''Constable'' => ''None'', ''Psychology'' => ''Healthcare'', ''Law enforcement agency powers'' => ''Safety''');
  INSERT INTO cfc_app_law VALUES(3,'AZ-HB2040-1717-Y2019','Abandoned Vehicle Fees','Abandoned vehicle fees',4,3,'1285662','2019-11-27','http://legiscan.com/AZ/HB2040/2019','(NLU)''Arizona'' => ''Location'', ''Bureau of Land Management'' => ''Environment'', ''Property'' => ''None'', ''City'' => ''None'', ''United States House of Representatives'' => ''None'', ''Phoenix, Arizona'' => ''Location'', ''United States'' => ''Location'', ''Town'' => ''None'', ''Legislature'' => ''None'', ''Alaska'' => ''Location''');
  INSERT INTO cfc_app_law VALUES(4,'AZ-HB2090-1717-Y2020','Wind Energy; Siting','Wind energy; siting',4,3,'1295302','2020-02-27','https://www.azleg.gov/legtext/54leg/2r/bills/hb2090h.htm','(NLU)''United States'' => ''Location'', ''United States House of Representatives'' => ''None'', ''United States Congress'' => ''None'', ''Wind turbine'' => ''Environment'', ''Legislature'' => ''None'', ''Democratic Party'' => ''None'', ''Arizona'' => ''Location'', ''Renewable energy'' => ''Environment'', ''Wind power'' => ''Environment'', ''Windmill'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(5,'AZ-HB2104-1717-Y2020','Child Care Assistance; Education; Training','Child care assistance; education; training',6,3,'1296767','2020-01-07','https://www.azleg.gov/legtext/54leg/2r/bills/hb2104p.htm','(NLU)''Household income in the United States'' => ''Jobs'', ''Family'' => ''None'', ''Childhood'' => ''None'', ''United States'' => ''Location'', ''Education'' => ''Education'', ''Income'' => ''Jobs'', ''Day care'' => ''Healthcare'', ''High school diploma'' => ''Education'', ''Poverty in the United States'' => ''Jobs'', ''Arizona'' => ''Location''');
  INSERT INTO cfc_app_law VALUES(6,'AZ-HB2135-1717-Y2020','Veteran Suicides; Annual Report','Veteran suicides; annual report',2,3,'1300603','2020-02-05','https://www.azleg.gov/legtext/54leg/2r/bills/hb2135h.htm','(NLU)''Suicide'' => ''Healthcare'', ''United States'' => ''Location'', ''Demography'' => ''Racial Justice'', ''Arizona'' => ''Location'', ''Veteran'' => ''Military'', ''United States Department of Veterans Affairs'' => ''Military'', ''United States House of Representatives'' => ''None'', ''Veterans Affairs Canada'' => ''Unknown'', ''American Legion'' => ''Military'', ''U.S. state'' => ''None''');
  INSERT INTO cfc_app_law VALUES(7,'AZ-HB2005-1623-Y2018','Traffic Survival School; Required Completion.','Traffic survival school; required completion.',5,3,'1134010','2019-05-13','https://www.azleg.gov/legtext/54leg/1r/laws/0201.htm','(NLU)''Traffic law'' => ''Transportation'', ''Driving'' => ''Transportation'', ''Driver''s license'' => ''Transportation'', ''Arizona'' => ''Location'', ''Law'' => ''None'', ''Road transport'' => ''Transportation'', ''Driver''s education'' => ''Transportation'', ''Learner''s permit'' => ''Unknown'', ''Commercial driver''s license'' => ''Transportation''');
  INSERT INTO cfc_app_law VALUES(8,'AZ-HB2014-1623-Y2018','Schools; Voluntary Posting; Abuse Hotline.','Schools; voluntary posting; abuse hotline.',3,3,'1135514','2018-12-20','http://legiscan.com/AZ/HB2014/2018','(NLU)''United States House of Representatives'' => ''None'', ''Arizona'' => ''Location'', ''Neglect'' => ''Safety'', ''United States'' => ''Location'', ''High school'' => ''Education'', ''Child abuse'' => ''Safety'', ''Legislature'' => ''None'', ''United States Congress'' => ''None'', ''Democratic Party'' => ''None'', ''Statutory law'' => ''None''');
  INSERT INTO cfc_app_law VALUES(9,'AZ-HB2142-1623-Y2019','Driver License Fees; Homeless Exemption','Driver license fees; homeless exemption',5,3,'1154737','2019-01-16','http://legiscan.com/AZ/HB2142/2019','(NLU)''Driver''s license'' => ''Transportation'', ''Driving'' => ''Transportation'', ''License'' => ''None'', ''Driving test'' => ''Transportation'', ''Driver''s education'' => ''Transportation'', ''Arizona'' => ''Location'', ''Patent'' => ''Jobs'', ''Law'' => ''None'', ''Passport'' => ''Transportation'', ''Learner''s permit'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(10,'AZ-HB2127-1517-Y2018','Children''s Health Insurance Program','Children''s health insurance program',2,3,'1049589','2018-01-31','https://www.azleg.gov/legtext/53leg/2r/bills/hb2127h.htm','(NLU)''Health care'' => ''Healthcare'', ''Medicine'' => ''Healthcare'', ''Health insurance'' => ''Healthcare''');
  INSERT INTO cfc_app_law VALUES(11,'OH-HB0002-1646-Y2019','Create TechCred and Microcredential Assistance Programs.','To enact sections of the Revised Code and to amend Sections of HB166 of the 133rd General Assembly to create the TechCred Program and the Individual Microcredential Assistance Program and to develop a grant program to support industry sector partnerships.',6,4,'1260285','2019-12-13','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb2/EN/08?format=pdf','(NLU)''Development aid'' => ''None'', ''Fiscal year'' => ''None'', ''Economic development'' => ''Jobs'', ''Training'' => ''Jobs'', ''Source code'' => ''Technology'', ''Development Assistance Committee'' => ''Unknown'', ''International development'' => ''Unknown'', ''Christopher Nolan'' => ''Healthcare'', ''Programming language'' => ''Jobs'', ''Shall and will'' => ''None''(MAP)''Training'' => ''Jobs'', ''Energy'' => ''Environment'', ''Small business'' => ''Jobs'', ''Income'' => ''Jobs'', ''Coal'' => ''Environment'', ''Economic development'' => ''Jobs'', ''Housing'' => ''Safety'', ''Manufacturing'' => ''Jobs'', ''Home'' => ''Safety'', ''Employment'' => ''Jobs''');
  INSERT INTO cfc_app_law VALUES(12,'OH-HB0003-1646-Y2019','Address High-Risk Domestic Violence and Victimization.','To amend sections; to amend, for the purpose of adopting a new section number as indicated in parentheses, section 2935.033; and to enact new section 2935.033 and section 2919.261 of the Revised Code; and to amend Section 221.10 of HB166 of the 133rd General Assembly to add domestic violence circumstances to the offense of aggravated murder, to expand the offense of domestic violence to also prohibit strangulation of a family or household member, to require law enforcement officers to utilize a qualified lethality assessment screening tool to refer high risk victims to domestic violence resources, to create the Domestic Violence Prosecution Study Committee, to name this act Aisha''s Law, and to make an appropriation.',3,4,'1261925','2020-05-21','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb3/PH/04?format=pdf','(NLU)''Felony'' => ''None'', ''Misdemeanor'' => ''None'', ''Crime'' => ''Safety'', ''Domestic violence'' => ''Safety'', ''Criminal law'' => ''None'', ''Police'' => ''Safety'', ''Law enforcement officer'' => ''Safety'', ''Assault'' => ''Safety'', ''Law enforcement agency'' => ''Safety'', ''Criminal justice'' => ''None''(MAP)''Violence'' => ''Safety'', ''Domestic violence'' => ''Safety'', ''Victim'' => ''Safety'', ''Child'' => ''Safety'', ''Law enforcement'' => ''Safety'', ''Firearm'' => ''Safety'', ''Training'' => ''Jobs'', ''Assault'' => ''Safety'', ''Drug'' => ''Healthcare'', ''Hearing'' => ''Healthcare''');
  INSERT INTO cfc_app_law VALUES(13,'OH-HB0006-1646-Y2019','Creates Ohio Clean Air Program','To amend sections to enact sections and to repeal section 4928.6616 of the Revised Code to facilitate and continue the development, production, and use of electricity from nuclear, coal, and renewable energy resources in this state, to modify the existing mandates for renewable energy and energy efficiency savings, and to determine amounts of federal funding received for home weatherization services.',4,4,'1251863','2019-07-23','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb6/EN/06?format=pdf','(NLU)''Wind power'' => ''Environment'', ''Nuclear power'' => ''Environment'', ''Renewable energy'' => ''Environment'', ''Public utility'' => ''Environment'', ''World energy resources and consumption'' => ''Environment'', ''Energy development'' => ''Unknown'', ''Energy'' => ''Environment'', ''Peak oil'' => ''Environment'', ''Electricity distribution'' => ''Environment'', ''Solar energy'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(14,'OH-HB0007-1646-Y2019','Create Water Quality Protection and Preservation Programs','To amend sections and to enact sections of the Revised Code to create the H2Ohio Trust Fund for the protection and preservation of Ohio''s water quality, to create the H2Ohio Advisory Council to establish priorities for use of the Fund for water quality programs, and to authorize the Ohio Water Development Authority to invest the money in the Fund and to make recommendations to the Treasurer of State regarding the issuance of securities to pay for costs related to the purposes of the Fund.',4,4,'1260277','2019-06-20','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb7/PH/02?format=pdf','(NLU)''Water management'' => ''Environment'', ''Water'' => ''Environment'', ''Water supply'' => ''Environment'', ''Internal Revenue Code'' => ''Taxes'', ''Fiscal year'' => ''None'', ''Water pollution'' => ''Environment'', ''Water quality'' => ''Environment'', ''Water resources'' => ''Environment'', ''Hydrology'' => ''Jobs'', ''Water conservation'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(15,'OH-HB0008-1646-Y2019','Regards Foster Caregiver Training','To amend sections and to repeal sections of the Revised Code regarding foster caregiver training.',3,4,'1260359','2020-09-24','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb8/EN/05?format=pdf','(NLU)''Foster care'' => ''Safety'', ''Child protection'' => ''Safety'', ''Adoption'' => ''Safety'', ''Foster care adoption'' => ''Safety''');
  INSERT INTO cfc_app_law VALUES(16,'OH-HB0011-1646-Y2019','Regards Tobacco Cessation and Prenatal Initiatives','To amend sections to amend, for the purpose of adopting a new section number as indicated in parentheses, section 5164.10 and to enact new section 5164.10 and sections of the Revised Code; and to amend Section 333.10 of HB166 of the 133rd General Assembly to address tobacco cessation and prenatal initiatives and to make an appropriation.',2,4,'1261848','2020-06-12','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb11/EN/07?format=pdf','(NLU)''Health care'' => ''Healthcare'', ''Managed care'' => ''Healthcare'', ''Medicaid'' => ''Healthcare'', ''Health insurance'' => ''Healthcare'', ''Public health'' => ''Healthcare'', ''Smoking cessation'' => ''Healthcare'', ''Health economics'' => ''Healthcare'', ''Health'' => ''Healthcare'', ''Massachusetts'' => ''Location'', ''Medicine'' => ''Healthcare''');
  INSERT INTO cfc_app_law VALUES(17,'OH-HB0021-1646-Y2019','Regards Unemployment Comp When Mass Layoff','To amend sections of the Revised Code regarding notices, resources, and benefits under the Unemployment Compensation Law when a mass layoff occurs.',6,4,'1200782','2019-02-12','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb21/IN/00?format=pdf','(NLU)''Unemployment'' => ''Jobs'', ''Unemployment benefits'' => ''Jobs'', ''Ghent system'' => ''Jobs'', ''Employment'' => ''Jobs''');
  INSERT INTO cfc_app_law VALUES(18,'OH-HB0052-1646-Y2019','Require Certain Entities Inform Veterans of Health Care Benefits','To amend section 5901.01 and to enact section 5901.40 of the Revised Code to require certain entities to inform veterans about health care benefits available to veterans.',2,4,'1200844','2019-02-12','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb52/IN/00?format=pdf','(NLU)''United States'' => ''Location'', ''Veteran'' => ''Military'', ''United States Army'' => ''Military'', ''Health care'' => ''Healthcare'', ''Nursing home'' => ''Healthcare'', ''United States Department of Veterans Affairs'' => ''Military'', ''Care of residents'' => ''Safety'', ''United States Department of Defense'' => ''Military'', ''Health'' => ''Healthcare'', ''Massachusetts'' => ''Location''');
  INSERT INTO cfc_app_law VALUES(19,'OH-HB0077-1646-Y2019','Enacts the Legalize Window Tinting Act for Motor Vehicles','To amend sections and to enact sections of the Revised Code to codify and modify rules related to the use of sunscreening and reflectorized materials on motor vehicles and to name this act the "Legalize Window Tinting Act."',5,4,'1204332','2019-02-14','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb77/IN/00?format=pdf','(NLU)''Vehicle'' => ''Transportation'', ''Vehicles'' => ''Transportation'', ''Automobile'' => ''Transportation'', ''Motor vehicle'' => ''Transportation'', ''Road transport'' => ''Transportation'', ''Crumple zone'' => ''Unknown'', ''Car safety'' => ''Unknown'', ''Road traffic safety'' => ''Safety'', ''Automobile safety'' => ''Unknown'', ''Misdemeanor'' => ''None''');
  INSERT INTO cfc_app_law VALUES(20,'OH-HB0119-1646-Y2019','Regards Traffic Law Violations','To amend sections of the Revised Code to make corrective changes to the distracted driving and texting-while-driving law and to add the offenses of failure to control and passing a stopped school bus to the distracted driving law.',5,4,'1229959','2019-10-24','http://search-prod.lis.state.oh.us/solarapi/v1/general_assembly_133/bills/hb119/PH/02?format=pdf','(NLU)''Bluetooth'' => ''None'', ''Wireless'' => ''None'', ''Wireless network'' => ''Technology'', ''School bus'' => ''Transportation'', ''History of radio'' => ''None'', ''Automobile'' => ''Transportation'', ''Cordless telephone'' => ''None'', ''Bus'' => ''Transportation'', ''Amateur radio'' => ''Unknown'', ''Vehicle'' => ''Transportation''');
  INSERT INTO cfc_app_law VALUES(21,'US-HB0003-1658-Y2019','Elijah E. Cummings Lower Drug Costs Now Act.','Elijah E. Cummings Lower Drug Costs Now Act This bill establishes several programs and requirements relating to the prices of prescription drugs, health care coverage and costs, and public health. TITLE I--LOWERING PRICES THROUGH FAIR DRUG PRICE NEGOTIATION The bill requires the Department of Health and Human Services (HHS) to negotiate prices for certain drugs. (Under current law, HHS may not negotiate the prices of covered drugs under the Medicare prescription drug benefit.) Specifically, HHS must negotiate maximum prices for (1) insulin products; (2) with respect to FY2023, at least 25 single-source, brand-name drugs that do not have generic competition and that are among either the 125 drugs that account for the greatest national spending or the 125 drugs that account for the greatest spending under the Medicare prescription drug benefit and Medicare Advantage (MA); (3) beginning in FY2024, at least 50 such single-source, brand-name drugs; and (4) newly approved single-source, bran',2,2,'1275160','2020-09-11','https://www.congress.gov/116/bills/hr3/BILLS-116hr3pcs.pdf','(NLU)''Medicare'' => ''Healthcare'', ''Medicare Part D'' => ''Unknown'', ''Pharmacology'' => ''Healthcare'', ''Medicare and Medicaid'' => ''Unknown'', ''Centers for Medicare and Medicaid Services'' => ''Healthcare'', ''Mark McClellan'' => ''Unknown'', ''Health insurance'' => ''Healthcare'', ''Medicaid'' => ''Healthcare'', ''Drugs'' => ''Healthcare'', ''Medicare Prescription Drug, Improvement, and Modernization Act'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(22,'US-HB0006-1658-Y2019','American Dream and Promise Act of 2019.','American Dream and Promise Act of 2019 This bill cancels and prohibits removal proceedings against certain aliens and provides such aliens with a path toward permanent resident status. The Department of Homeland Security (DHS) or the Department of Justice (DOJ) shall cancel removal proceedings against certain aliens who entered the United States as minors and grant such aliens conditional permanent residence status for 10 years. The bill imposes various qualification requirements, such as the alien being continuously physically present in the United States and being enrolled in or having completed certain educational programs. DHS shall establish streamlined procedures to apply for conditional permanent residence for aliens who received Deferred Action for Childhood Arrivals (DACA) status and were not disqualified for renewal. DHS shall remove the conditional permanent resident status granted to such aliens, if the alien applies and meets certain requirements, such as completing certai',6,2,'1238134','2019-06-11','https://www.congress.gov/116/bills/hr6/BILLS-116hr6pcs.pdf','(NLU)''Permanent residency'' => ''Unknown'', ''Immigration to the United States'' => ''Jobs'', ''United States'' => ''Location'', ''Residency'' => ''None'', ''United States Code'' => ''None'', ''Selective Service System'' => ''Military'', ''U.S. state'' => ''None'', ''United States Department of Homeland Security'' => ''Safety'', ''Visa'' => ''Unknown'', ''Human migration'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(23,'US-HB0007-1658-Y2019','Paycheck Fairness Act.','Paycheck Fairness Act This bill addresses wage discrimination on the basis of sex. It amends equal pay provisions of the Fair Labor Standards Act of 1938 to (1) restrict the use of the bona fide factor defense to wage discrimination claims, (2) enhance nonretaliation prohibitions, (3) make it unlawful to require an employee to sign a contract or waiver prohibiting the employee from disclosing information about the employee''s wages, and (4) increase civil penalties for violations of equal pay provisions. The Equal Employment Opportunity Commission (EEOC) and the Office of Federal Contract Compliance Programs shall train EEOC employees and other affected parties on wage discrimination. The bill directs the Department of Labor to (1) establish and carry out a grant program for negotiation skills training programs to address pay disparities, including through outreach to women and girls; (2) conduct studies to eliminate pay disparities between men and women; (3) report on the gender pay ga',6,2,'1182221','2019-04-04','https://www.congress.gov/116/bills/hr7/BILLS-116hr7pcs.pdf','(NLU)''Employment'' => ''Jobs'', ''Equal Employment Opportunity Commission'' => ''Jobs'', ''United States Department of Labor'' => ''Unknown'', ''Collective bargaining'' => ''Jobs'', ''Equal pay for women'' => ''Unknown'', ''Bureau of Labor Statistics'' => ''Unknown'', ''Fair Labor Standards Act'' => ''Jobs'', ''Wage'' => ''Jobs'', ''September 11'' => ''Unknown'', ''2003'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(24,'US-HB0008-1658-Y2019','Bipartisan Background Checks Act of 2019.','Bipartisan Background Checks Act of 2019 This bill establishes new background check requirements for firearm transfers between private parties (i.e., unlicensed individuals). Specifically, it prohibits a firearm transfer between private parties unless a licensed gun dealer, manufacturer, or importer first takes possession of the firearm to conduct a background check. The prohibition does not apply to certain firearm transfers, such as a gift between spouses in good faith.',3,2,'1141970','2019-03-05','https://www.congress.gov/116/bills/hr8/BILLS-116hr8pcs.pdf','(NLU)''United States'' => ''Location'', ''Background check'' => ''Unknown'', ''United States Code'' => ''None'', ''Suppressor'' => ''None'', ''Identity theft'' => ''Safety''');
  INSERT INTO cfc_app_law VALUES(25,'US-HB0009-1658-Y2019','Climate Action Now Act.','Climate Action Now Act This bill requires the President to develop and update annually a plan for the United States to meet its nationally determined contribution under the Paris Agreement on climate change. ( Sec#3 ) In addition, the bill prohibits federal funds from being used to withdraw from the agreement. ( Sec#4 ) The bill outlines what must be included in the plan, including descriptions of steps to (1) cut greenhouse gas emissions by 26%-28% below 2005 levels by 2025, and (2) confirm that other parties to the agreement with major economies are fulfilling their announced contributions. The President must seek and publish comments from the public when submitting and updating the plan. ( Sec#5 ) Within six months, the President must report on the effect of the Paris Agreement on clean energy job development in rural communities. ( Sec#6 ) Within six months, the President must also contract with the National Academy of Sciences to report on the potential impacts of a withdrawal by ',4,2,'1245881','2019-05-08','https://www.congress.gov/116/bills/hr9/BILLS-116hr9pcs.pdf','(NLU)''United States'' => ''Location'', ''Economy of the United States'' => ''Unknown'', ''U.S. state'' => ''None'', ''Greenhouse gas'' => ''Environment'', ''Global warming'' => ''Environment'', ''President of the United States'' => ''Unknown'', ''Climate change'' => ''Environment'', ''World War II'' => ''Military'', ''Territories of the United States'' => ''Unknown'', ''Humid subtropical climate'' => ''Environment''');
  INSERT INTO cfc_app_law VALUES(26,'US-HB0029-1658-Y2019','Public Water Supply Invasive Species Compliance Act of 2019.','Public Water Supply Invasive Species Compliance Act of 2019 This bill exempts certain water transfers between public water supplies in Texas, Arkansas, and Louisiana from prohibitions on illegal trade of plants and wildlife. Specifically, the prohibitions do not apply to covered water transfers containing a prohibited species if (1) the species are present in both public water supplies before the transfer and the water is transferred directly between them; or (2) the water is transferred in a closed conveyance system, such as a pipe system, and sent directly to treatment facilities where the species will be destroyed.',4,2,'1137335','2019-01-08','https://www.congress.gov/116/bills/hr29/BILLS-116hr29ih.pdf','(NLU)''United States'' => ''Location'', ''United States Code'' => ''None'', ''Water supply'' => ''Environment'', ''Water quality'' => ''Environment'', ''Water management'' => ''Environment'', ''U.S. state'' => ''None'', ''Water resources'' => ''Environment'', ''Aquifer'' => ''Environment''');
  INSERT INTO cfc_app_law VALUES(27,'US-HB0033-1658-Y2019','Gun Trafficking Prohibition Act.','Gun Trafficking Prohibition Act This bill establishes stand-alone criminal offenses for trafficking in firearms and straw purchasing of firearms. The bill expands the categories of prohibited persons (i.e., persons barred from receiving or possessing a firearm or ammunition) to include persons who intend (1) to sell or transfer a firearm or ammunition to a prohibited person, (2) to sell or transfer a firearm to further a crime of violence or drug trafficking offense, or (3) to unlawfully export. It increases the maximum prison term for the sale or transfer of a firearm to or the receipt or possession of a firearm by a prohibited person. The bill revises the existing prohibition on transferring a firearm knowing that it will be used to commit a crime of violence or drug trafficking offense. It broadens the scope of unlawful conduct and increases the maximum prison term for a violator. The bill also revises the existing prohibition on smuggling a firearm into the United States with the i',3,2,'1137428','2019-01-08','https://www.congress.gov/116/bills/hr33/BILLS-116hr33ih.pdf','(NLU)''United States Code'' => ''None'', ''United States'' => ''Location'', ''Federal Bureau of Investigation'' => ''Safety'', ''Ammunition'' => ''Safety'', ''U.S. state'' => ''None'', ''Arms Export Control Act'' => ''Unknown'', ''United States federal legislation'' => ''None'', ''Law of the United States'' => ''None'', ''United States House of Representatives'' => ''None'', ''Official documents of the United States'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(28,'US-HB0104-1658-Y2019','LEVEL Act Leave Ethanol Volumes at Existing Levels Act','LEVEL Act Leave Ethanol Volumes at Existing Levels Act This bill revises the renewable fuel program, including the renewable fuel standard (RFS). Under current law, the RFS specifies the minimum volume of renewable fuel, such as ethanol, that must be contained in gasoline sold in the United States, except in noncontiguous states or territories. The RFS annually increases until 2022 when a minimum of 36 billion gallons of renewable fuel must be blended into gasoline. This bill decreases the volume of renewable fuel that must be contained in gasoline to 7.5 billion gallons each year. The bill also revises the RFS to eliminate separate volume requirements for the following renewable fuel categories: advanced biofuels, cellulosic biofuel, and biomass-based diesel. Petitions for waivers from requirements under the renewable fuel program may not be brought by a person who is subject to the requirements of the program, nor by the EPA on its own motion. The EPA may not authorize the sale of ga',5,2,'1137496','2019-01-12','https://www.congress.gov/116/bills/hr104/BILLS-116hr104ih.pdf','(NLU)''Internal combustion engine'' => ''Transportation'', ''Waste'' => ''Environment'', ''Cellulosic ethanol'' => ''Unknown'', ''Gasoline'' => ''Transportation'', ''Renewable energy'' => ''Environment'', ''Biofuel'' => ''Unknown'', ''Ethanol'' => ''Transportation'', ''Petroleum'' => ''Environment'', ''Waste management'' => ''Environment'', ''United States Environmental Protection Agency'' => ''Environment''');
  INSERT INTO cfc_app_law VALUES(29,'US-HB0122-1658-Y2019','Original Living Wage Act','Original Living Wage Act This bill increases the federal minimum wage to the minimum hourly wage sufficient for a person working for 40 hours per week, 52 weeks per year, to earn an annual income 25.5% higher than the federal poverty threshold for a four-person household, with two children under age 18, and living in the 48 contiguous states. The Department of Labor shall determine the minimum wage rate by June 1, 2018, and review it every four years. Labor may not adjust the minimum wage to a lower rate.',6,2,'1137480','2019-01-11','https://www.congress.gov/116/bills/hr122/BILLS-116hr122ih.pdf','(NLU)''Minimum wage'' => ''Jobs'', ''Employment'' => ''Jobs'', ''Wage'' => ''Jobs'', ''United States'' => ''Location'', ''1985'' => ''Unknown'', ''1966'' => ''Unknown'', ''Employment compensation'' => ''Jobs'', ''1977'' => ''Unknown'', ''1961'' => ''Unknown'', ''2007'' => ''Unknown''');
  INSERT INTO cfc_app_law VALUES(30,'US-HB0228-1658-Y2019','Increase Transportation Alternatives Investment Act of 2019','Increase Transportation Alternatives Investment Act of 2019 Increase Transportation Alternatives Investment Act of 2019 This bill directs the Department of Transportation (DOT) to ensure that states give preference under the Surface Transportation Block Grant Program to eligible projects that (1) are located in areas that are undergoing extensive repair or reconstruction of transportation infrastructure, including federal-aid highways, federally owned roads open for public travel, passenger rail facilities, and public transportation facilities; and (2) will provide transportation alternatives related to the closure of transportation infrastructure in such areas. DOT shall (1) carry out a competitive grant program to support community efforts to invest in transportation alternatives; and (2) give preference in awarding grants to projects located in such areas. Entities eligible for grants include state and local governments, metropolitan planning organizations, and rural planning organi',5,2,'1137382','2019-01-18','https://www.congress.gov/116/bills/hr228/BILLS-116hr228ih.pdf','(NLU)''United States'' => ''Location'', ''Rail transport'' => ''Transportation'', ''Transportation planning'' => ''Unknown'', ''Ulysses S. Grant'' => ''None'', ''Road'' => ''Transportation'', ''Train station'' => ''Unknown'', ''Public transport'' => ''Transportation'', ''Transport'' => ''Transportation'', ''Sustainable transport'' => ''Transportation'', ''Grants'' => ''None''');
  