Covid Bill Data

This is a simple outline of the Covid Relief bill that can be found here: The Bill. Rather than try and read the entire 5500 page bill, I wrote a simple python script to try and extract out the relevant data. In the original PDF, there is a top level "DIVISION" with sublevels under most of those called "Title". Within each of the Title sections there is free text with all the budgetary items. You cannot simply extract out items that start with a '$' as you have text such as:

For necessary expenses of the Office of the Secretary, 11 $46,998,000, of which not to exceed $5,101,000 shall be 12 available for the immediate Office of the Secretary

So you can only grab the first dollar amount. This may or may not be accruate and I would hope there would be a more data friendly format of the line items in the bill.



    DIVISION A—AGRICULTURE, RURAL DEVELOPMENT, FOOD AND DRUG ADMINISTRATION, AND RELATED AGENCIES APPROPRIATIONS ACT, 2021
            Title I—Agricultural Programs 
            Title II—Farm Production and Conservation Programs 
            Title III—Rural Development Programs 
            Title IV—Domestic Food Programs 
            Title V—Foreign Assistance and Related Programs 
            Title VI—Related Agency and Food and Drug Administration 
            Title VII—General Provisions 
    DIVISION B—COMMERCE, JUSTICE, SCIENCE, AND RELATED AGENCIES APPROPRIATIONS ACT, 2021 December 21, 2020 (10:27 a.m.)2 U:\2021OMNI\Final\H133JLHS—68.xml 
            Title I—Department of Commerce 
            Title II—Department of Justice 
            Title III—Science 
            Title IV—Related Agencies 
            Title V—General Provisions 
    DIVISION C—DEPARTMENT OF DEFENSE APPROPRIATIONS ACT, 2021 
            Title I—Military Personnel
            Title II—Operation and Maintenance 
            Title III—Procurement 
            Title IV—Research, Development, Test and Evaluation 
            Title V—Revolving and Management Funds 
            Title VI—Other Department of Defense Programs 
            Title VII—Related Agencies 
            Title VIII—General Provisions 
            Title IX—Overseas Contingency Operations 
    DIVISION D—ENERGY AND WATER DEVELOPMENT AND RELATED AGENCIES APPROPRIATIONS ACT, 2021 
            Title I—Corps of Engineers—Civil
            Title II—Department of the Interior 
            Title III—Department of Energy 
            Title IV—Independent Agencies 
            Title V—General Provisions 
    DIVISION E—FINANCIAL SERVICES AND GENERAL GOVERNMENT APPROPRIATIONS ACT, 2021 
            Title I—Department of the Treasury 
            Title II—Executive Office of the President and Funds Appropriated to the President 
            Title III—The Judiciary 
            Title IV—District of Columbia 
            Title V—Independent Agencies 
            Title VI—General Provisions—This Act 
            Title VII—General Provisions—Government-wide 
            Title VIII—General Provisions—District of Columbia 
            Title IX—General Provision—Emergency Funding 
    DIVISION F—DEPARTMENT OF HOMELAND SECURITY APPROPRIATIONS ACT, 2021 
            Title I—Departmental Management, Operations, Intelligence, and Oversight 
            Title II—Security, Enforcement, and Investigations 
            Title III—Protection, Preparedness, Response, and Recovery 
            Title IV—Research, Development, Training, and Services 
            Title V—General Provisions 
    DIVISION G—DEPARTMENT OF THE INTERIOR, ENVIRONMENT, AND RELATED AGENCIES APPROPRIATIONS ACT, 2021 
            Title I—Department of the Interior 
            Title II—Environmental Protection Agency 
            Title III—Related Agencies December 21, 2020 (10:27 a.m.)3 U:\2021OMNI\Final\H133JLHS—68.xml 
            Title IV—General Provisions 
    DIVISION H—DEPARTMENTS OF LABOR, HEALTH AND HUMAN SERVICES, AND EDUCATION, AND RELATED AGENCIES APPRO-
            Title III—Department of Education 
            Title IV—Related Agencies 
            Title V—General Provisions
    DIVISION I—LEGISLATIVE BRANCH APPROPRIATIONS ACT, 2021
            Title I—Legislative Branch Title II—General Provisions
    DIVISION J—MILITARY CONSTRUCTION, VETERANS AFFAIRS, AND RELATED AGENCIES APPROPRIATIONS ACT, 2021 
            Title I—Department of Defense 
            Title II—Department of Veterans Affairs 
            Title III—Related Agencies 
            Title IV—Overseas Contingency Operations 
            Title V—General Provisions 
    DIVISION K—DEPARTMENT OF STATE, FOREIGN OPERATIONS, AND RELATED PROGRAMS APPROPRIATIONS ACT, 2021 
            Title I—Department of State and Related Agency 
            Title II—United States Agency for International Development 
            Title III—Bilateral Economic Assistance 
            Title IV—International Security Assistance 
            Title V—Multilateral Assistance 
            Title VI—Export and Investment Assistance 
            Title VII—General Provisions 
            Title VIII—Nita M. Lowey Middle East Partnership for Peace Act of 2020 
            Title IX—Emergency Funding and Other Matters 
    DIVISION L—TRANSPORTATION, HOUSING AND URBAN DEVELOP-MENT, AND RELATED AGENCIES APPROPRIATIONS ACT, 2021 
            Title I—Department of Transportation 
            Title II—Department of Housing and Urban Development 
            Title III—Related Agencies 
            Title IV—General Provisions—This Act 
    DIVISION M—CORONAVIRUS RESPONSE AND RELIEF SUPPLEMENTAL APPROPRIATIONS ACT, 2021 
    DIVISION N—ADDITIONAL CORONAVIRUS RESPONSE AND RELIEF 
    DIVISION O—EXTENSIONS AND TECHNICAL CORRECTIONS 
            Title I—Immigration Extensions 
            Title II—Commission on Black Men and Boys Corrections 
            Title III—U.S. Customs and Border Protection Authority to Accept Donations Extension December 21, 2020 (10:27 a.m.)4 U:\2021OMNI\Final\H133JLHS—68.xml 
            Title IV—Livestock Mandatory Reporting Extension 
            Title V—Soil Health and Income Protection Pilot Program Extension 
            Title VI—United States-Mexico-Canada Agreement Implementation Act Technical Corrections Title VII—Deputy Architect of the Capitol Amendments 
            Title VIII—Pandemic Response Accountability Committee Amendments 
            Title IX—Adjustment of Status for Liberian Nationals Extension 
            Title X—Clean Up the Code Act of 2019 
            Title XI—Amendments to Provisions Relating to Child Care Centers 
            Title XII—Alaska Natives Extension 
            Title XIII— Open Technology Fund Opportunity to Contest Proposed Debarment 
            Title XIV—Budgetary Effects 
    DIVISION P—NATIONAL BIO AND AGRO-DEFENSE FACILITY ACT OF 2020 
    DIVISION Q—FINANCIAL SERVICES PROVISIONS AND INTELLECTUAL PROPERTY 
    DIVISION R—PROTECTING OUR INFRASTRUCTURE OF PIPELINES AND ENHANCING SAFETY ACT OF 2020 
    DIVISION S—INNOVATION FOR THE ENVIRONMENT 
    DIVISION T—SMITHSONIAN AMERICAN WOMEN’S HISTORY MUSEUM ACT AND NATIONAL MUSEUM OF THE AMERICAN 
            Title III—Foreign Relations and Department of State Provisions 
            Title IV—Senate Sergeant at Arms Cloud Services 
            Title V— Repeal of Requirement to Sell Certain Federal Property in Plum Is-land, New York
            Title VI— Preventing Online Sales of E-Cigarettes to Children 
            Title VII—FAFSA Simplification 
            Title VIII—Access to Death Information Furnished to or Maintained by the Social Security Administration 
            Title IX—Telecommunications and Consumer Protection 
            Title X—Bankruptcy Relief 
            Title XI—Western Water and Indian Affairs 
            Title XII—Horse racing Integrity and Safety 
            Title XIII—Community Development Block Grants 
            Title XIV—COVID–19 Consumer Protection Act 
            Title XV—American COMPETE Act 
            Title XVI—Recording of Obligations 
            Title XVII—Sudan Claims Resolution 
            Title XVIII—Theodore Roosevelt Presidential Library Conveyance Act of 2020 
            Title XIX—United States-Mexico Economic Partnership Act 
            Title XX—Consumer Product Safety Commission Port Surveillance 
            Title XXI—COVID–19 Regulatory Relief and Work From Home Safety Act SEC. 3. (10:27 a.m.)8 U:\2021OMNI\Final\H133JLHS—68.xml December 21, 2020 (10:27 a.m.)U:\2021OMNI\Final\DivA-M2.xml SEN. APPRO. 

        

Extracted line items


        Office of the Secretary
        $46,998,000
        
         Office of the Chief Economist, 
        $24,192,000
        
         Office of Hearings and Appeals, 
        $15,394,000
        
         Office of Budget and Program Analysis, 
        $9,629,000
        
         Office of the Chief Information Officer, 
        $66,814,000
        
         Office of the Chief Financial Officer, 
        $6,109,000
        
         Office of the Assistant Secretary for Civil Rights, 
        $908,000
        
         Office of Civil Rights, 
        $22,789,000
        
         Office of Safety, Security, and Protection, 
        $23,218,000
        
         Office of the General Counsel, 
        $45,390,000
        
         Office of Ethics,
        $4,184,000
        
         Office of the Under 6Secretary for Research, Education, and Economics, 
        $809,000
        
         Economic Research Service, 
        $85,476,000
        
         National Agricultural Statistics Service, 
        $183,921,000
        
         Agricultural Research Service and for acquisition of lands by donation, exchange, or purchase at a nominal cost not to exceed 
        $100
        
         Office of the Under Secretary for Marketing and Regulatory Programs, 
        $809,000
        
         Animal and Plant Health Inspection Service, including up to 
        $30,000
        
         Agricultural Marketing Service, 
        $188,358,000
        
         Office of the Under Secretary for Food Safety, 
        $809,000
        
         Office of the Under Secretary for Farm Production and Conservation, 
        $916,000
        
         Farm Production and Conservation Business Center, 
        $231,302,000
        
         Farm Service Agency, 
        $1,142,924,000
        
         Risk Management Agency, 
        $60,131,000
        
         Office of the Under Secretary for Rural Development, 
        $812,000
        
         Office of the Under 5Secretary for Food, Nutrition, and Consumer Services, 
        $809,000
        
         Office of the Under Secretary for Trade and Foreign Agricultural Affairs, 
        $887,000
        
         Office of Codex Alimentarius, 
        $4,805,000
        
         Foreign Agricultural Service, including not to exceed 
        $250,000
        
         Food and Drug Ad-8ministration, including hire and purchase of passenger 9motor vehicles; for payment of space rental and related 10costs pursuant to Public Law 92–313 for programs and 11activities of the Food and Drug Administration which are 12included in this Act; for rental of special purpose space 13in the District of Columbia or elsewhere; in addition to 14amounts appropriated to the FDA Innovation Account, for 15carrying out the activities described in section 1002(b)(4) 16of the 21st Century Cures Act (Public Law 114–255); for 17miscellaneous and emergency expenses of enforcement ac-18tivities, authorized and approved by the Secretary and to 19be accounted for solely on the Secretary’s certificate, not 20to exceed 
        $25,000
        
         Department of Commerce in fostering, promoting, and developing minority 18business enterprises, including expenses of grants, con-19tracts, and other agreements with public or private organi-20zations, 
        $48,000,000
        
         United States Patent and Trademark Office (USPTO) provided for by law, including defense of suits instituted against the Under Sec-12retary of Commerce for Intellectual Property and Director 13of the USPTO, 
        $3,695,295,000
        
         National Institute of Standards and Technology (NIST), 
        $788,000,000
        
         Office of Inspector General, 
        $110,565,000
        
         United States Parole Commission as authorized, 
        $13,539,000
        
         Offices of the United States Attorneys, including inter-governmental and cooperative agreements, 
        $2,342,177,000
        
         United States Trustee Program, as authorized, 
        $232,361,000
        
         Community Relations Service, 
        $18,000,000
        
         United States Marshals Service, 
        $1,496,000,000
        
         Federal Bureau of Investigation for detection, investigation, and prosecution of crimes against the United States, 
        $9,748,686,000
        
         Drug Enforcement Administration, including not to exceed 
        $70,000
        
         Federal Prison System for the administration, operation, and maintenance of Federal penal and correctional institutions, and for the 6provision of technical assistance and advice on corrections 7related issues to foreign governments, 
        $7,708,375,000
        
         Office of Inspector General in carrying out the Inspector General Act of 1978, 
        $44,200,000
        
         Office of Inspector General as authorized by the Inspector General Act of 221978, 
        $17,850,000
        
         Commission on Civil Rights, including hire of passenger motor vehicles, 
        $12,500,000
        
         Equal Employment opportunity Commission as authorized by title VII of the 4Civil Rights Act of 1964, the Age Discrimination in Em-5ployment Act of 1967, the Equal Pay Act of 1963, the 6Americans with Disabilities Act of 1990, section 501 of 7the Rehabilitation Act of 1973, the Civil Rights Act of 81991, the Genetic Information Nondiscrimination Act 9(GINA) of 2008 (Public Law 110–233), the ADA Amend-10ments Act of 2008 (Public Law 110–325), and the Lilly 11Ledbetter Fair Pay Act of 2009 (Public Law 111–2), in-12cluding services as authorized by section 3109 of title 5, 13United States Code; hire of passenger motor vehicles as 14authorized by section 1343(b) of title 31, United States 15Code; nonmonetary awards to private citizens; and up to 16
        $31,500,000
        
         International Trade Commission, including hire of passenger motor vehicles 9and services as authorized by section 3109 of title 5, 10United States Code, and not to exceed 
        $2,250
        
         Office of the United States Trade Representative, including the hire of pas-11senger motor vehicles and the employment of experts and 12consultants as authorized by section 3109 of title 5, 13United States Code, 
        $55,000,000
        
         Intelligence Community Management Account, 
        $633,719,000
        
         Departmental Offices including operation and maintenance of the Treasury Building and Freedman’s Bank Building; hire of passenger motor vehicles; maintenance, repairs, and improvements of, and purchase of commercial insurance policies 12for, real properties leased or owned overseas, when nec-13essary for the performance of official business; executive 14direction program activities; international affairs and eco-15nomic policy activities; domestic finance and tax policy ac-16tivities, including technical assistance to State, local, and 17territorial entities; and Treasury-wide management poli-18cies and programs activities, 
        $233,000,000
        
         Committee on Foreign Investment in the United States, 
        $20,000,000
        
         Office of Inspector General in carrying out the provisions of the Inspector General Act of 1978, 
        $41,044,000
        
         Office of the Special Inspector General in carrying out the provisions of the Emergency Economic Stabilization Act of 2008 (Public 6Law 110–343), 
        $19,000,000
        
         Internal Revenue Service’s business systems modernization program,
        $222,724,000
        
         Executive Residence at the White House, 
        $13,641,000
        
         Office of National Drug Control Policy; for research activities pursuant to 4he Office of National Drug Control Policy Reauthoriza-5tion Act of 1998, as amended; not to exceed 
        $10,000
        
         Office of National Drug Control Policy’s High Intensity Drug Trafficking Areas Program, 
        $290,000,000
        
         Federal Judicial Center, as authorized by Public Law 90–219, 
        $29,015,000
        
         Office of Inspector General in carrying out the provisions of the Inspector General Act of 1978, 
        $42,982,000
        
         Postal Regulatory Commission in carrying out the provisions of the Postal Accountability and Enhancement Act (Public Law 109– 18435), 
        $17,000,000
        
         Office of Inspector General in carrying out the provisions of the Inspector General Act of 1978, 
        $22,011,000
        
         Office of Inspector General in carrying out the provisions of the Inspector General Act of 1978, 
        $250,000,000
        
         Office of the Secretary and for executive management for operations and support, 
        $180,819,000
        
         Office of the Secretary 19and for executive management for Federal assistance through grants, contracts, cooperative agreements, and other activities, 
        $25,000,000
        
         Management Directorate for operations and support, 
        $1,398,162,000
        
         Management Directorate for procurement, construction, and improvements, 5
        $214,795,000
        
         Office of Intelligence and Analysis and the Office of Operations Coordination for operations and support, 
        $298,500,000
        
         Office of the Inspector General for operations and support, 
        $190,186,000
        
         Transportation Security Administration for operations and support, 
        $7,793,715,000
        
         Transportation Security Administration for procurement, construction, and improvements, 
        $134,492,000
        
         Transportation Security Administration for research and development,
        $29,524,000
        
         Coast Guard for research and development; and for maintenance, rehabilitation, lease, and operation of facilities and equipment; 10
        $10,276,000
        
         United States Secret Service for procurement, construction, and improvements, 19
        $52,955,000
        
         United States Secret Service for research and development, 
        $11,937,000
        
         Cybersecurity and Infrastructure Security Agency for operations and support, 8
        $1,662,066,000
        
         Cybersecurity and Infrastructure Security Agency for procurement, construction, and improvements, 
        $353,479,000
        
         Cybersecurity and Infrastructure Security Agency for research and development, 
        $9,431,000
        
         Federal Emergency Management Agency for operations and support, 4
        $1,129,282,000
        
         Federal Emergency Management Agency for procurement, construction, and improvements, 
        $105,985,000
        
         Federal Law Enforcement Training Centers for operations and support, including the purchase of not to exceed 117 vehicles for police-type use and hire of passenger motor vehicles, and services 18as authorized by section 3109 of title 5, United States 19Code, 
        $314,348,000
        
         Federal Law Enforcement Training Centers for procurement, construction, and improvements, 
        $26,000,000
        
         Science and Tech-11nology Directorate for operations and support, including the purchase or lease of not to exceed 5 vehicles, 13
        $302,703,000
        
         Science and Tech-19nology Directorate for procurement, construction, and improvements, 
        $18,927,000
        
         Countering Weapons of Mass Destruction Office for operations and support, 6
        $179,892,000
        
         Countering Weapons of Mass Destruction Office for procurement, construction, and improvements, 
        $87,413,000
        
         Countering Weapons of Mass Destruction Office for research and development, 18
        $65,309,000
        
         United States Fish and Wildlife Service, as authorized by law, and for scientific and economic studies, general administration, and for the performance of other authorized functions related to such 24resources, 
        $1,379,828,000
        
         Office of the Solicitor, 7
        $86,813,000
        
         Office of Inspector General, 
        $58,552,000
        
         Office of Inspector General in carrying out the provisions of the Inspector General Act of 1978, 
        $43,500,000
        
         Office of the Under Secretary for Natural Resources and Environment, 7
        $875,000
        
         Forest Service, not otherwise provided for, 
        $1,026,163,000
        
         Forest Service, not otherwise provided for, for management, protection, improvement, and utilization of the National Forest System, and for hazardous fuels management on or adjacent to 20such lands, 
        $1,786,870,000
        
         Forest Service, not otherwise provided for, 
        $140,371,000
        
         Office of Navajo and Hopi Indian Relocation as authorized by Public Law 93– 4531, 
        $4,000,000
        
         Smithsonian Institu-tion, as authorized by law, including research in the fields 13of art, science, and history; development, preservation, and documentation of the National Collections; presentation of 15public exhibits and performances; collection, preparation, 16dissemination, and exchange of information and publica-17tions; conduct of education, training, and museum assist-18ance programs; maintenance, alteration, operation, lease 19agreements of no more than 30 years, and protection of 20buildings, facilities, and approaches; not to exceed 21
        $100,000
        
         Advisory Council on Historic Preservation (Public Law 89–665), 
        $7,400,000
        
         Alyce Spotted Bear and Walter Soboleff Commission on Native Children (referred to in this paragraph as the ‘‘Commission’’), 20
        $500,000
        
         Workforce Innovation and Opportunity Act (referred to in this Act as ‘‘WIOA’’) and the National Apprenticeship Act, 
        $3,663,200,000
        
         Office of Inspector General in carrying out the Inspector General Act of 1978, 12
        $6,500,000
        
         Capitol Police, including motor vehicles, communications and other equipment, security equipment and installation, uniforms, weapons, 14supplies, materials, training, medical services, forensic 15services, stenographic services, personal and professional 16services, the employee assistance program, the awards pro-17gram, postage, communication services, travel advances, 18relocation of instructor and liaison personnel for the Fed-19eral Law Enforcement Training Center, and not more 20than 
        $5,000
        
         Government Accountability Office, including not more than 
        $12,500
        
         National Cemetery Administration for operations and maintenance, not otherwise provided for, including uniforms or allowances there-16for; cemeterial expenses as authorized by law; purchase 17of one passenger motor vehicle for use in cemeterial oper-18ations; hire of passenger motor vehicles; and repair, alter-19ation or improvement of facilities under the jurisdiction 20of the National Cemetery Administration, 
        $352,000,000
        
         Department of State and the Foreign Service not otherwise provided for, 12
        $9,170,013,000
        
         Capital Investment Fund, as authorized, 
        $250,000,000
        
         Office of Inspector General, 
        $90,829,000
        
         Office of the Secretary, 9
        $126,174,000
        
         Office of Civil Rights, 24
        $9,600,000
        
         Federal Railroad Administration, not otherwise provided for, 
        $234,905,000
        
         Office of Inspector General to carry out the provisions of the Inspector General Act of 1978, as amended, 
        $98,150,000
        
         Surface Transportation Board, including services authorized by section 153109 of title 5, United States Code, 
        $37,500,000
        

    

Questions? ...

CONTACT ME