spending_awards
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
78,228 rows where fiscal_year = 2018 sorted by award_amount descending
This data as json, CSV (advanced)
Suggested facets: award_type, start_date (date), end_date (date)
agency 14
- Department of Transportation 12,676
- Department of Homeland Security 11,063
- Department of Justice 8,203
- Department of Commerce 8,129
- Department of the Interior 6,647
- National Aeronautics and Space Administration 6,054
- Department of Housing and Urban Development 4,788
- Department of Veterans Affairs 4,494
- Department of Energy 4,114
- Department of Agriculture 3,279
- Department of Labor 2,869
- Department of Education 2,782
- Department of Health and Human Services 2,225
- Small Business Administration 905
fiscal_year 1
- 2018 · 78,228 ✖
| generated_internal_id | award_id | agency | sub_agency | award_category | award_type | recipient_name | recipient_name_normalized | award_amount ▲ | total_outlays | description | start_date | end_date | fiscal_year | state_code | cfda_number | naics_code | naics_description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CONT_AWD_89233218CNA000001_8900_-NONE-_-NONE- | 89233218CNA000001 | Department of Energy | Department of Energy | contracts | DEFINITIVE CONTRACT | TRIAD NATIONAL SECURITY, LLC | TRIAD NATIONAL SECURITY, LLC | 34437648832.29 | 22557288668.42 | IGF::CL::IGF COMPETITION FOR MANAGEMENT AND OPERATION OF LOS ALAMOS NATIONAL LABORATORY | 2018-06-08 | 2028-10-31 | 2018 | NM | |||
| CONT_AWD_89233018CNR000004_8900_-NONE-_-NONE- | 89233018CNR000004 | Department of Energy | Department of Energy | contracts | DEFINITIVE CONTRACT | FLUOR MARINE PROPULSION, LLC | FLUOR MARINE PROPULSION, LLC | 14756742531.4 | 8744413828.48 | MANAGEMENT AND OPERATION OF THE NAVAL NUCLEAR LABORATORY AND NAVAL NUCLEAR PROPULSION PROGRAM SUPPORT | 2018-07-12 | 2028-09-30 | 2018 | PA | |||
| ASST_NON_B-17-DM-48-0001_086 | B-17-DM-48-0001 | Department of Housing and Urban Development | Assistant Secretary for Community Planning and Development | grants | FORMULA GRANT (A) | TEXAS GENERAL LAND OFFICE | TEXAS GENERAL LAND OFFICE | 5024215000.0 | 4523173177.93 | COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII | 2018 | TX | 14.228 | ||||
| CONT_AWD_80NM0018F0615_8000_80NM0018D0004_8000 | 80NM0018F0615 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 2924898288.98 | 2415624893.29 | EUROPA CLIPPER PROJECT THE CONTRACT IS THE SPONSORING AGREEMENT BETWEEN THE NATIONAL AERONAUTICS AND SPACE ADMINISTRATION NASA AND THE CALIFORNIA INSTITUTE OF TECHNOLOGY-CONTRACTOR, A PRIVATE NONPROFIT EDUCATIONAL INSTITUTION, WHICH ESTABLISHES THE RELATIONSHIP FOR THE OPERATION OF THE FEDERALLY FUNDED RESEARCH AND DEVELOPMENT CENTER-FFRDC KNOWN AS THE JET PROPULSION LABORATORY. THE CONTRACTOR, JPL, IS REQUIRED TO PERFORM WORK THAT IS DESIGNATED IN TASK ORDERS ISSUED BY THE NASA MANAGEMENT OFFICE-NMO CONTRACTING OFFICERS. NASA-SPONSORED WORK: JPLS PRIMARY MISSION IS TO SUPPORT THE NASA SCIENCE MISSION DIRECTORATE-SMD IN CARRYING OUT THE SPECIFIC OBJECTIVES IDENTIFIED IN THE SMD SCIENCE PLAN. THE FOUR BROAD SCIENTIFIC AREAS ARE: EARTH SCIENCE, PLANETARY SCIENCE, HELIOPHYSICS, AND ASTROPHYSICS. IN PERFORMANCE OF THIS CONTRACT, JPL SHALL: 1. SUPPLY A BROAD BASE OF SCIENTIFIC AND TECHNICAL CAPABILITIES RELEVANT TO NASA PROGRAM AND PROJECT RESPONSIBILITIES AND ASSIGNMENTS. 2. FOSTER ITS UNIQUE RELATIONSHIP WITH A TOP-TIER UNIVERSITY TO FACILITATE THE INVOLVEMENT OF SCIENTISTS, ENGINEERS, AND STUDENTS FROM THE UNIVERSITY AND RESEARCH COMMUNITIES IN NASA MISSION AND IN SUPPORTING OTHER GOVERNMENT AGENCIES. 3. SUPPORT NASA IN ENABLING PROGRAM AND INSTITUTIONAL CAPABILITIES. 4. DEVELOP SPACECRAFT AND INSTRUMENTS THAT ARE SENT TO VARIOUS DESTINATIONS WITH OUR SOLAR SYSTEM, INCLUDING EARTH ORBIT, PLANETS, PLANETARY SATELLITES, ASTEROIDS, AND COMETS. THESE MISSIONS MAY BE ORBITERS, LANDERS, OR ROVERS, AND TYPICALLY INCLUDE CUTTING-EDGE TECHNOLOGIES REQUIRED TO MEET SCIENTIFIC REQUIREMENTS. 5. PERFORM PROJECT TASKS INVOLVING: I-AUTONOMOUS DEEP-SPACE, INNER-SPACE AND EARTH-ORBITING SPACECRAFT OR MAJOR SUBSYSTEMS, II-EXPERIMENTS, INSTRUMENTS, OR OTHER DEVICES WHICH MAY BE CARRIED AS PAYLOAD ON SPACECRAFTS IN MISSIONS MANAGED BY OTHERS, AND-OR III-GROUND-BASED SYSTEMS. 6. BEYOND ITS PRIMARY MISSION, JPL MAY PERFORM WORK FOR OTHER NASA MISSION DIRECTORATES OR OFFICES. 7. JPL IS ALSO RESPONSIBLE FOR THE OPERATION, RESEARCH, TE… | 2018-10-01 | 2028-09-30 | 2018 | CA | |||
| ASST_NON_4337DRFLP00000001_070 | 4337DRFLP00000001 | Department of Homeland Security | Federal Emergency Management Agency | grants | PROJECT GRANT (B) | STATE OF FLORIDA DIVISION OF EMERGENCY MANAGEMENT | STATE OF FLORIDA DIVISION OF EMERGENCY MANAGEMENT | 2433482175.95 | 74864445.49 | GRANT TO LOCAL GOVERNMENT FOR REPAIR OR REPLACEMENT OF DISASTER DAMAGED FACILITIES | 2017-12-06 | 2026-09-30 | 2018 | FL | 97.036 | ||
| ASST_NON_S010A180005_091 | S010A180005 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | DEPARTMENT OF EDUCATION CALIFORNIA | DEPARTMENT OF EDUCATION CALIFORNIA | 1988156056.0 | 652802221.71 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | CA | 84.010 | ||
| CONT_AWD_80MSFC18C0011_8000_-NONE-_-NONE- | 80MSFC18C0011 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DEFINITIVE CONTRACT | AMENTUM TECHNOLOGY, INC. | AMENTUM TECHNOLOGY, INC. | 1870896808.85 | 1419952743.63 | ENGINEERING SERVICES AND SCIENCE CAPABILITY AUGMENTATION (ESSCA) | 2017-12-01 | 2026-11-30 | 2018 | AL | |||
| ASST_NON_S010A180043_091 | S010A180043 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | TX EDUCATION AGENCY | TX EDUCATION AGENCY | 1511185710.44 | 333661780.97 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | TX | 84.010 | ||
| ASST_NON_B-17-DM-72-0001_086 | B-17-DM-72-0001 | Department of Housing and Urban Development | Assistant Secretary for Community Planning and Development | grants | FORMULA GRANT (A) | PUERTO RICO DEPARTMENT OF HOUSING | PUERTO RICO DEPARTMENT OF HOUSING | 1507179000.0 | 1176517769.03 | COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII | 2018 | PR | 14.228 | ||||
| CONT_AWD_36C77018K0904_3600_VA797P12D0001_3600 | 36C77018K0904 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | MCKESSON CORPORATION | MCKESSON CORPORATION | 1482122645.8 | EXPRESS REPORT: PHARMACY PRIME VENDOR CMOP FY18 OCT 1, 2017 TO MAY 30, 2018 CONTRACT VA797P-12-D-0001 | 2017-10-01 | 2018-05-31 | 2018 | CA | ||||
| CONT_AWD_80NM0018F0850_8000_80NM0018D0004_8000 | 80NM0018F0850 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 1441181507.34 | 1151663228.13 | DEEP SPACE NETWORK (DSN) THE CONTRACT IS THE SPONSORING AGREEMENT BETWEEN THE NATIONAL AERONAUTICS AND SPACE ADMINISTRATION (NASA) AND THE CALIFORNIA INSTITUTE OF TECHNOLOGY (CONTRACTOR), A PRIVATE NONPROFIT EDUCATIONAL INSTITUTION, WHICH ESTABLISHES THE RELATIONSHIP FOR THE OPERATION OF THE FEDERALLY FUNDED RESEARCH AND DEVELOPMENT CENTER (FFRDC) KNOWN AS THE JET PROPULSION LABORATORY. THE CONTRACTOR, JPL, IS REQUIRED TO PERFORM WORK THAT IS DESIGNATED IN TASK ORDERS ISSUED BY THE NASA MANAGEMENT OFFICE (NMO) CONTRACTING OFFICERS. NASA - SPONSORED WORK: JPL'S PRIMARY MISSION IS TO SUPPORT THE NASA SCIENCE MISSION DIRECTORATE (SMD) IN CARRYING OUT THE SPECIFIC OBJECTIVES IDENTIFIED IN THE SMD SCIENCE PLAN. THE FOUR BROAD SCIENTIFIC AREAS ARE: EARTH SCIENCE, PLANETARY SCIENCE, HELIOPHYSICS, AND ASTROPHYSICS. IN PERFORMANCE OF THIS CONTRACT, JPL SHALL: 1) SUPPLY A BROAD BASE OF SCIENTIFIC AND TECHNICAL CAPABILITIES RELEVANT TO NASA PROGRAM AND PROJECT RESPONSIBILITIES AND ASSIGNMENTS. 2) FOSTER ITS UNIQUE RELATIONSHIP WITH A TOP-TIER UNIVERSITY TO FACILITATE THE INVOLVEMENT OF SCIENTISTS, ENGINEERS, AND STUDENTS FROM THE UNIVERSITY AND RESEARCH COMMUNITIES IN NASA MISSION AND IN SUPPORTING OTHER GOVERNMENT AGENCIES. 3) SUPPORT NASA IN ENABLING PROGRAM AND INSTITUTIONAL CAPABILITIES. 4) DEVELOP SPACECRAFT AND INSTRUMENTS THAT ARE SENT TO VARIOUS DESTINATIONS WITH OUR SOLAR SYSTEM, INCLUDING EARTH ORBIT, PLANETS, PLANETARY SATELLITES, ASTEROIDS, AND COMETS. THESE MISSIONS MAY BE ORBITERS, LANDERS, OR ROVERS, AND TYPICALLY INCLUDE CUTTING-EDGE TECHNOLOGIES REQUIRED TO MEET SCIENTIFIC REQUIREMENTS. 5) PERFORM PROJECT TASKS INVOLVING: (I) AUTONOMOUS DEEP-SPACE, INNER-SPACE AND EARTH-ORBITING SPACECRAFT OR MAJOR SUBSYSTEMS, (II) EXPERIMENTS, INSTRUMENTS, OR OTHER DEVICES WHICH MAY BE CARRIED AS PAYLOAD ON SPACECRAFTS IN MISSIONS MANAGED BY OTHERS, AND/OR (III) GROUND-BASED SYSTEMS. 6) BEYOND ITS PRIMARY MISSION, JPL MAY PERFORM WORK FOR OTHER NASA MISSION DIRECTORATES OR OFFICES. 7) JPL IS ALSO RESPONSIBLE FOR TH… | 2018-10-01 | 2028-09-30 | 2018 | CA | |||
| CONT_AWD_36C79118K0234_3600_VA79113D0054_3600 | 36C79118K0234 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | TRIWEST HEALTHCARE ALLIANCE CORP | TRIWEST HEALTHCARE ALLIANCE CORP | 1354578202.97 | EXPRESS REPORT: PCCC/CHOICE EXPRESS REPORT FY18 | 2018-09-30 | 2018-09-30 | 2018 | AZ | ||||
| ASST_NON_H027A180116_091 | H027A180116 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | DEPARTMENT OF EDUCATION CALIFORNIA | DEPARTMENT OF EDUCATION CALIFORNIA | 1281755429.0 | 609320823.27 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | CA | 84.027 | ||
| CONT_AWD_36C10B18N0003_3600_36C10B18D5000_3600 | 36C10B18N0003 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | ORACLE HEALTH GOVERNMENT SERVICES, INC. | ORACLE HEALTH GOVERNMENT SERVICES, INC. | 1276290794.61 | IGF::OT::IGF TASK ORDER 36C10B18N0003 UNDER IDIQ CONTRACT 36C10B18D5000 FOR OPERATIONAL MANAGEMENT SERVICES, TO INCLUDE HOSTING, FOR THE EHRM APPLICATIONS, APPLICATION SERVICES, AND ALL SUPPORTING EHRM DATA. | 2018-05-17 | 2026-05-16 | 2018 | KS | ||||
| CONT_AWD_80NM0018F0616_8000_80NM0018D0004_8000 | 80NM0018F0616 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 1265720994.01 | 862692117.16 | M2020 MARS SCIENCE ROVER PROJECT-PHASE A-D 60-19107 THE CONTRACT IS THE SPONSORING AGREEMENT BETWEEN THE NATIONAL AERONAUTICS AND SPACE ADMINISTRATION NASA AND THE CALIFORNIA INSTITUTE OF TECHNOLOGY-CONTRACTOR, A PRIVATE NONPROFIT EDUCATIONAL INSTITUTION, WHICH ESTABLISHES THE RELATIONSHIP FOR THE OPERATION OF THE FEDERALLY FUNDED RESEARCH AND DEVELOPMENT CENTER-FFRDC KNOWN AS THE JET PROPULSION LABORATORY. THE CONTRACTOR, JPL, IS REQUIRED TO PERFORM WORK THAT IS DESIGNATED IN TASK ORDERS ISSUED BY THE NASA MANAGEMENT OFFICE-NMO CONTRACTING OFFICERS. NASA-SPONSORED WORK: JPLS PRIMARY MISSION IS TO SUPPORT THE NASA SCIENCE MISSION DIRECTORATE-SMD IN CARRYING OUT THE SPECIFIC OBJECTIVES IDENTIFIED IN THE SMD SCIENCE PLAN. THE FOUR BROAD SCIENTIFIC AREAS ARE: EARTH SCIENCE, PLANETARY SCIENCE, HELIOPHYSICS, AND ASTROPHYSICS. IN PERFORMANCE OF THIS CONTRACT, JPL SHALL: 1. SUPPLY A BROAD BASE OF SCIENTIFIC AND TECHNICAL CAPABILITIES RELEVANT TO NASA PROGRAM AND PROJECT RESPONSIBILITIES AND ASSIGNMENTS. 2. FOSTER ITS UNIQUE RELATIONSHIP WITH A TOP-TIER UNIVERSITY TO FACILITATE THE INVOLVEMENT OF SCIENTISTS, ENGINEERS, AND STUDENTS FROM THE UNIVERSITY AND RESEARCH COMMUNITIES IN NASA MISSION AND IN SUPPORTING OTHER GOVERNMENT AGENCIES. 3. SUPPORT NASA IN ENABLING PROGRAM AND INSTITUTIONAL CAPABILITIES. 4. DEVELOP SPACECRAFT AND INSTRUMENTS THAT ARE SENT TO VARIOUS DESTINATIONS WITH OUR SOLAR SYSTEM, INCLUDING EARTH ORBIT, PLANETS, PLANETARY SATELLITES, ASTEROIDS, AND COMETS. THESE MISSIONS MAY BE ORBITERS, LANDERS, OR ROVERS, AND TYPICALLY INCLUDE CUTTING-EDGE TECHNOLOGIES REQUIRED TO MEET SCIENTIFIC REQUIREMENTS. 5. PERFORM PROJECT TASKS INVOLVING: I-AUTONOMOUS DEEP-SPACE, INNER-SPACE AND EARTH-ORBITING SPACECRAFT OR MAJOR SUBSYSTEMS, II-EXPERIMENTS, INSTRUMENTS, OR OTHER DEVICES WHICH MAY BE CARRIED AS PAYLOAD ON SPACECRAFTS IN MISSIONS MANAGED BY OTHERS, AND-OR III-GROUND-BASED SYSTEMS. 6. BEYOND ITS PRIMARY MISSION, JPL MAY PERFORM WORK FOR OTHER NASA MISSION DIRECTORATES OR OFFICES. 7. JPL IS ALSO RESPONSIBLE FO… | 2018-10-01 | 2028-09-24 | 2018 | CA | |||
| ASST_NON_FR-AMT-0015-18_069 | FR-AMT-0015-18 | Department of Transportation | Federal Railroad Administration | grants | COOPERATIVE AGREEMENT (B) | NATIONAL RAILROAD PASSENGER CORPORATION | NATIONAL RAILROAD PASSENGER CORPORATION | 1220051136.0 | 0.0 | FY2018 NATIONAL NETWORK GRANT TO THE NATIONAL RAILROAD PASSENGER CORPORATION (AMTRAK) | 2017-10-01 | 2024-02-29 | 2018 | DC | 20.315 | ||
| ASST_NON_S010A180032_091 | S010A180032 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | NEW YORK STATE EDUCATION DEPARTMENT | NEW YORK STATE EDUCATION DEPARTMENT | 1213896518.74 | 408281373.74 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | NY | 84.010 | ||
| ASST_NON_H027A180008_091 | H027A180008 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | TX EDUCATION AGENCY | TX EDUCATION AGENCY | 1068204461.0 | 269600671.26 | UNKNOWN TITLE | 2018-07-01 | 2021-09-30 | 2018 | TX | 84.027 | ||
| ASST_NON_MA-2018-004_069 | MA-2018-004 | Department of Transportation | Federal Transit Administration | grants | PROJECT GRANT (B) | MASSACHUSETTS BAY TRANSPORTATION AUTHORITY | MASSACHUSETTS BAY TRANSPORTATION AUTHORITY | 996121000.0 | 629891378.0 | MBTA GLX FFGA | 2017-12-28 | 2027-06-30 | 2018 | MA | 20.500 | ||
| CONT_AWD_89243318CFE000003_8900_-NONE-_-NONE- | 89243318CFE000003 | Department of Energy | Department of Energy | contracts | DEFINITIVE CONTRACT | LEIDOS, INC. | LEIDOS, INC. | 964758863.0 | 707034014.93 | RESEARCH SUPPORT SERVICES (RSS) | 2018-12-31 | 2028-12-30 | 2018 | WV | |||
| ASST_NON_NY-2018-060_069 | NY-2018-060 | Department of Transportation | Federal Transit Administration | grants | FORMULA GRANT (A) | METROPOLITAN TRANSPORTATION AUTHORITY | METROPOLITAN TRANSPORTATION AUTHORITY | 918000000.0 | 826906974.0 | APPLICATION PURPOSE: THIS AWARD WILL ASSIST WITH THE MTAS ROLLING STOCK PURCHASE.; ACTIVITIES PERFORMED: THE SCOPE OF WORK INCLUDES SUBWAY CAR PROCUREMENT. ; EXPECTED OUTCOMES: THIS APPLICATION WILL SUPPORT THE MTAS NEED TO RETIRE LOCALLY FUNDED SUBWAY CARS FROM THREE CAR CLASSES AND ONE SIR CAR CLASS.; INTENDED BENEFICIARIES: THE MTA AND ITS RIDERSHIP.; SUBRECIPIENT ACTIVITIES: THE MTA DOES NOT HAVE SUBRECIPIENTS UNDER THIS AWARD. | 2018-09-10 | 2031-02-28 | 2018 | NY | 20.525 | ||
| CONT_AWD_36C77018K0991_3600_VA797P12D0001_3600 | 36C77018K0991 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | MCKESSON CORPORATION | MCKESSON CORPORATION | 869057791.33 | EXPRESS REPORT: PHARMACY PRIME VENDOR CMOP FY18 JUL 1, 2018 TO SEP 30, 2018 CONTRACT VA797P-12-D-0001 | 2018-07-01 | 2018-09-30 | 2018 | CA | ||||
| ASST_NON_S010A180009_091 | S010A180009 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | FLORIDA DEPARTMENT OF EDUCATION | FLORIDA DEPARTMENT OF EDUCATION | 853679870.0 | 91823284.07 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | FL | 84.010 | ||
| CONT_AWD_36C77018K0949_3600_VA797P12D0001_3600 | 36C77018K0949 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | MCKESSON CORPORATION | MCKESSON CORPORATION | 802272236.62 | EXPRESS REPORT: PHARMACY PRIME VENDOR CMOP FY18 APR 1, 2018 TO JUN 30, 2018 CONTRACT VA797P-12-D-0001 | 2018-04-01 | 2018-06-30 | 2018 | CA | ||||
| CONT_AWD_70CDCR18FR0000002_7012_GS33F004DA_4732 | 70CDCR18FR0000002 | Department of Homeland Security | U.S. Immigration and Customs Enforcement | contracts | DELIVERY ORDER | CLASSIC AIR CHARTER INC. | CLASSIC AIR CHARTER INC. | 800164136.9 | 189668369.5 | IGF::OT::IGF DAILY CHARTER FLIGHT SERVICES | 2017-10-20 | 2023-06-30 | 2018 | NY | |||
| CONT_AWD_80NM0018F0645_8000_80NM0018D0004_8000 | 80NM0018F0645 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 797909089.59 | 672259310.22 | PSYCHE: JOURNEY TO A METAL WORLD THE CONTRACT IS THE SPONSORING AGREEMENT BETWEEN THE NATIONAL AERONAUTICS AND SPACE ADMINISTRATION (NASA) AND THE CALIFORNIA INSTITUTE OF TECHNOLOGY (CONTRACTOR), A PRIVATE NONPROFIT EDUCATIONAL INSTITUTION, WHICH ESTABLISHES THE RELATIONSHIP FOR THE OPERATION OF THE FEDERALLY FUNDED RESEARCH AND DEVELOPMENT CENTER (FFRDC) KNOWN AS THE JET PROPULSION LABORATORY. THE CONTRACTOR, JPL, IS REQUIRED TO PERFORM WORK THAT IS DESIGNATED IN TASK ORDERS ISSUED BY THE NASA MANAGEMENT OFFICE (NMO) CONTRACTING OFFICERS. NASA - SPONSORED WORK: JPL'S PRIMARY MISSION IS TO SUPPORT THE NASA SCIENCE MISSION DIRECTORATE (SMD) IN CARRYING OUT THE SPECIFIC OBJECTIVES IDENTIFIED IN THE SMD SCIENCE PLAN. THE FOUR BROAD SCIENTIFIC AREAS ARE: EARTH SCIENCE, PLANETARY SCIENCE, HELIOPHYSICS, AND ASTROPHYSICS. IN PERFORMANCE OF THIS CONTRACT, JPL SHALL: 1) SUPPLY A BROAD BASE OF SCIENTIFIC AND TECHNICAL CAPABILITIES RELEVANT TO NASA PROGRAM AND PROJECT RESPONSIBILITIES AND ASSIGNMENTS. 2) FOSTER ITS UNIQUE RELATIONSHIP WITH A TOP-TIER UNIVERSITY TO FACILITATE THE INVOLVEMENT OF SCIENTISTS, ENGINEERS, AND STUDENTS FROM THE UNIVERSITY AND RESEARCH COMMUNITIES IN NASA MISSION AND IN SUPPORTING OTHER GOVERNMENT AGENCIES. 3) SUPPORT NASA IN ENABLING PROGRAM AND INSTITUTIONAL CAPABILITIES. 4) DEVELOP SPACECRAFT AND INSTRUMENTS THAT ARE SENT TO VARIOUS DESTINATIONS WITH OUR SOLAR SYSTEM, INCLUDING EARTH ORBIT, PLANETS, PLANETARY SATELLITES, ASTEROIDS, AND COMETS. THESE MISSIONS MAY BE ORBITERS, LANDERS, OR ROVERS, AND TYPICALLY INCLUDE CUTTING-EDGE TECHNOLOGIES REQUIRED TO MEET SCIENTIFIC REQUIREMENTS. 5) PERFORM PROJECT TASKS INVOLVING: (I) AUTONOMOUS DEEP-SPACE, INNER-SPACE AND EARTH-ORBITING SPACECRAFT OR MAJOR SUBSYSTEMS, (II) EXPERIMENTS, INSTRUMENTS, OR OTHER DEVICES WHICH MAY BE CARRIED AS PAYLOAD ON SPACECRAFTS IN MISSIONS MANAGED BY OTHERS, AND/OR (III) GROUND-BASED SYSTEMS. 6) BEYOND ITS PRIMARY MISSION, JPL MAY PERFORM WORK FOR OTHER NASA MISSION DIRECTORATES OR OFFICES. 7) JPL IS ALSO RESPONSIBL… | 2018-10-01 | 2028-09-30 | 2018 | CA | |||
| ASST_NON_H027A180104_091 | H027A180104 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | NEW YORK STATE EDUCATION DEPARTMENT | NEW YORK STATE EDUCATION DEPARTMENT | 796269107.25 | 160393637.29 | UNKNOWN TITLE | 2018-07-01 | 2021-09-30 | 2018 | NY | 84.027 | ||
| ASST_NON_NY-2018-059_069 | NY-2018-059 | Department of Transportation | Federal Transit Administration | grants | FORMULA GRANT (A) | METROPOLITAN TRANSPORTATION AUTHORITY | METROPOLITAN TRANSPORTATION AUTHORITY | 795100000.0 | 583503014.0 | APPLICATION PURPOSE: THIS AWARD WILL ASSIST WITH THE MTAS ROLLLING STOCK PURCHASE.; ACTIVITIES PERFORMED: THE SCOPE OF WORK INCLUDES SUBWAY CAR PROCUREMENT. ; EXPECTED OUTCOMES: THIS APPLICATION WILL SUPPORT THE MTAS NEED TO PUT R211 CARS INTO SERVICE AND RETIRE LOCALLY FUNDED SUBWAY CARS FROM THREE CAR CLASSES AND ONE SIR CAR CLASS.; INTENDED BENEFICIARIES: THE MTA AND ITS RIDERSHIP.; SUBRECIPIENT ACTIVITIES: THE MTA DOES NOT HAVE SUBRECIPIENTS UNDER THIS AWARD. | 2018-09-10 | 2027-09-30 | 2018 | NY | 20.507 | ||
| CONT_AWD_36C10B18F0278_3600_HHSN316201200011W_7529 | 36C10B18F0278 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | CGI FEDERAL INC. | CGI FEDERAL INC. | 783318157.08 | 437980207.24 | AWARD - TO RE-OBLIGATE FUNDS USDA DE-OBLIGATED TO | 2018-04-25 | 2026-04-02 | 2018 | VA | |||
| CONT_AWD_80NM0018F0710_8000_80NM0018D0004_8000 | 80NM0018F0710 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 756784181.0 | 602132479.48 | NASA ISRO SYNTHETIC APERTURE RADAR (NISAR) MISSION 89-17620 | 2018-10-01 | 2028-09-30 | 2018 | CA | |||
| ASST_NON_S010A180013_091 | S010A180013 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | ILLINOIS STATE BOARD OF EDUCATION | ILLINOIS STATE BOARD OF EDUCATION | 678373061.0 | 190067046.29 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | IL | 84.010 | ||
| ASST_NON_H027A180024_091 | H027A180024 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | FLORIDA DEPARTMENT OF EDUCATION | FLORIDA DEPARTMENT OF EDUCATION | 674522024.0 | 93829084.58 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | FL | 84.027 | ||
| CONT_AWD_80GSFC18C0120_8000_-NONE-_-NONE- | 80GSFC18C0120 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DEFINITIVE CONTRACT | SCIENCE SYSTEMS AND APPLICATIONS, INC. | SCIENCE SYSTEMS AND APPLICATIONS, INC. | 670568775.49 | 618240277.43 | ELECTRICAL ENGINEERING SYSTEMS SERVICES THE PRINCIPAL PURPOSE OF THIS CONTRACT IS TO PROVIDE ELECTRICAL/ELECTRONIC ENGINEERING SUPPORT SERVICES AND RELATED WORK TO EED, ISTD, SED, MESA, RELATED ORGANIZATIONS AND OTHER NASA CENTERS AND LOCATIONS SPECIFIED IN TASK ORDERS, FOR THE STUDY, DESIGN, DEVELOPMENT, FABRICATION, INTEGRATION, TESTING, VERIFICATION, AND OPERATIONS OF SPACE FLIGHT, AIRBORNE, AND GROUND SYSTEM HARDWARE AND SOFTWARE, INCLUDING DEVELOPMENT AND VALIDATION OF NEW TECHNOLOGIES TO ENABLE FUTURE SPACE AND SCIENCE MISSIONS. | 2018-11-01 | 2025-05-08 | 2018 | MD | |||
| ASST_NON_S010A180038_091 | S010A180038 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | PENNSYLVANIA DEPT OF EDUATION | PENNSYLVANIA DEPT OF EDUATION | 650024682.0 | 82673267.27 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | PA | 84.010 | ||
| CONT_AWD_70CDCR18C00000003_7012_-NONE-_-NONE- | 70CDCR18C00000003 | Department of Homeland Security | U.S. Immigration and Customs Enforcement | contracts | DEFINITIVE CONTRACT | STG INTERNATIONAL, INC. | STG INTERNATIONAL, INC. | 641096352.82 | 262993625.35 | IGF::OT::IGF IHSC MEDICAL STAFFING SERVICES | 2018-02-20 | 2025-03-31 | 2018 | VA | |||
| CONT_AWD_36C79118K0255_3600_VA79113D0054_3600 | 36C79118K0255 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | TRIWEST HEALTHCARE ALLIANCE CORP | TRIWEST HEALTHCARE ALLIANCE CORP | 624957594.3 | EXPRESS REPORT: FOR PC3/CHOICE NON VA HEALTHCARE | 2017-10-01 | 2017-12-31 | 2018 | AZ | ||||
| ASST_NON_FR-AMT-0014-18_069 | FR-AMT-0014-18 | Department of Transportation | Federal Railroad Administration | grants | COOPERATIVE AGREEMENT (B) | NATIONAL RAILROAD PASSENGER CORPORATION | NATIONAL RAILROAD PASSENGER CORPORATION | 624259066.0 | 0.0 | FY2018 NORTHEAST CORRIDOR GRANT TO THE NATIONAL RAILROAD PASSENGER CORPORATION (AMTRAK) | 2017-10-01 | 2024-02-29 | 2018 | DC | 20.315 | ||
| ASST_NON_B-17-DM-12-0001_086 | B-17-DM-12-0001 | Department of Housing and Urban Development | Assistant Secretary for Community Planning and Development | grants | FORMULA GRANT (A) | FLORIDA DEPARTMENT OF COMMERCE | FLORIDA DEPARTMENT OF COMMERCE | 615922000.0 | 588404113.08 | COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII | 2018 | FL | 14.228 | ||||
| CONT_AWD_1332KP18CNEEJ0005_1330_-NONE-_-NONE- | 1332KP18CNEEJ0005 | Department of Commerce | National Oceanic and Atmospheric Administration | contracts | DEFINITIVE CONTRACT | RAYTHEON COMPANY | RAYTHEON COMPANY | 607132122.75 | 10247462.02 | IGF::OT::IGF ENGINEERING SERVICES AND DEVELOPMENT LEADING TO THE DELIVERY OF THE JPSS COMMON GROUND SYSTEM INSTRUMENT AND SUPPORT. THIS CONTRACT ACTION ABSORBS NASA'S CONTRACT ACTION NNG10XA03C. | 2010-09-22 | 2024-01-31 | 2018 | CO | |||
| ASST_NON_S938A180002_091 | S938A180002 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | DEPARTMENT OF EDUCATION OF PUERTO RICO | DEPARTMENT OF EDUCATION OF PUERTO RICO | 589170000.0 | 530220010.98 | ELEMENTARY AND SECONDARY EDUCATION HURRICANE RELIEF - IMMEDIATE AID TO RESTART SCHOOL OPERATIONS | 2018-04-26 | 2024-09-30 | 2018 | PR | 84.938 | ||
| CONT_AWD_80KSC018C0017_8000_-NONE-_-NONE- | 80KSC018C0017 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DEFINITIVE CONTRACT | AMENTUM SPACEPORT LLC | AMENTUM SPACEPORT LLC | 589090384.03 | 527527276.77 | BASE OPERATIONS AND SPACEPORT SERVICES (BOSS) CONTRACT | 2019-04-01 | 2026-03-21 | 2018 | FL | |||
| ASST_NON_S010A180035_091 | S010A180035 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | OHIO DEPARTMENT OF EDUCATION | OHIO DEPARTMENT OF EDUCATION | 556645944.0 | 169563142.67 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | OH | 84.010 | ||
| ASST_NON_4339DRPRP00000005_070 | 4339DRPRP00000005 | Department of Homeland Security | Federal Emergency Management Agency | grants | PROJECT GRANT (B) | GOVERNOR'S AUTHORIZED REPRESENTATIVE | GOVERNOR'S AUTHORIZED REPRESENTATIVE | 556469524.07 | 129869801.7 | GRANT TO LOCAL GOVERNMENT FOR REPAIR OR REPLACEMENT OF DISASTER DAMAGED FACILITIES | 2018-01-30 | 2022-09-30 | 2018 | PR | 97.039 | ||
| ASST_NON_S010A180010_091 | S010A180010 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | GEORGIA DEPT OF EDUCATION | GEORGIA DEPT OF EDUCATION | 532428728.59 | 137840910.36 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | GA | 84.010 | ||
| ASST_NON_H027A180072_091 | H027A180072 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | ILLINOIS STATE BOARD OF EDUCATION | ILLINOIS STATE BOARD OF EDUCATION | 530733888.0 | 136067149.27 | UNKNOWN TITLE | 2018-07-12 | 2019-09-30 | 2018 | IL | 84.027 | ||
| ASST_NON_NY01P00550118_086 | NY01P00550118 | Department of Housing and Urban Development | Assistant Secretary for Public and Indian Housing | grants | FORMULA GRANT (A) | NEW YORK CITY HOUSING AUTHORITY | NEW YORK CITY HOUSING AUTHORITY | 528246158.0 | 409399837.7 | PUBLIC HOUSING CAPITAL FUND | 2018-05-29 | 2023-11-28 | 2018 | NY | 14.872 | ||
| CONT_AWD_80AFRC18C0018_8000_-NONE-_-NONE- | 80AFRC18C0018 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DEFINITIVE CONTRACT | LOCKHEED MARTIN CORPORATION | LOCKHEED MARTIN CORPORATION | 518486416.19 | 382066485.44 | THE LOW BOOM FLIGHT DEMONSTRATOR (LBFD) CONTRACT IS FOR THE DESIGN, CONSTRUCTION, AND FLIGHT VALIDATION OF A RESEARCH AIRCRAFT THAT CREATES A SHAPED SONIC BOOM SIGNATURE WITH A CALCULATED LOUDNESS LEVEL OF 75 PLDB [PERCEIVED LEVEL (PL), DECIBELS (DB)] OR LESS DURING SUPERSONIC CRUISE (MACH = 1.4) FLIGHT. | 2018-04-02 | 2026-06-28 | 2018 | CA | |||
| ASST_NON_NY-2018-052_069 | NY-2018-052 | Department of Transportation | Federal Transit Administration | grants | PROJECT GRANT (B) | METROPOLITAN TRANSPORTATION AUTHORITY | METROPOLITAN TRANSPORTATION AUTHORITY | 503072497.0 | 372134808.0 | MTA NYCT CR SEC. 5324 FLOOD MITIGATION IN YARDS | 2027-06-30 | 2018 | NY | 20.527 | |||
| CONT_AWD_VA11818F2526_3600_NNG15SC25B_8000 | VA11818F2526 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | ALL POINTS LOGISTICS, LLC | ALL POINTS LOGISTICS, LLC | 491391043.0 | IGF::OT::IGF PURCHASE OF INTERSYSTEMS CACHE' AND HEALTHSHARE SOFTWARE IN SUPPORT OF VETERANS INFORMATION SYSTEM AND TECHNOLOGY ARCHITECTURE (VISTA) PLATFORM AS WELL AS VA'S ELECTRONIC HEALTH RECORD (EHR) DATABASE. | 2017-10-01 | 2022-09-30 | 2018 | NJ | ||||
| ASST_NON_4344DRCAP00000001_070 | 4344DRCAP00000001 | Department of Homeland Security | Federal Emergency Management Agency | grants | PROJECT GRANT (B) | OFFICE OF EMERGENCY SERVICES | OFFICE OF EMERGENCY SERVICES | 489778721.63 | 6579992.07 | GRANT TO LOCAL GOVERNMENT FOR REPAIR OR REPLACEMENT OF DISASTER DAMAGED FACILITIES | 2018-01-27 | 2026-09-30 | 2018 | CA | 97.036 | ||
| ASST_NON_S010A180022_091 | S010A180022 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | MICHIGAN DEPARTMENT OF EDUCATION | MICHIGAN DEPARTMENT OF EDUCATION | 488199487.0 | 206400024.48 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | MI | 84.010 | ||
| ASST_NON_4332DRTXP00000005_070 | 4332DRTXP00000005 | Department of Homeland Security | Federal Emergency Management Agency | grants | PROJECT GRANT (B) | TEXAS DIVISION OF EMERGENCY MANAGEMENT | TEXAS DIVISION OF EMERGENCY MANAGEMENT | 478470064.06 | 140202543.31 | GRANT TO LOCAL GOVERNMENT FOR REPAIR OR REPLACEMENT OF DISASTER DAMAGED FACILITIES | 2018-03-20 | 2020-09-30 | 2018 | TX | 97.039 | ||
| ASST_NON_H027A180111_091 | H027A180111 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | OHIO DEPARTMENT OF EDUCATION | OHIO DEPARTMENT OF EDUCATION | 457817083.0 | 74447073.2 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | OH | 84.027 | ||
| ASST_NON_H027A180093_091 | H027A180093 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | PENNSYLVANIA DEPT OF EDUATION | PENNSYLVANIA DEPT OF EDUATION | 446896819.0 | 39320428.32 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | PA | 84.027 | ||
| ASST_NON_S010A180033_091 | S010A180033 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | PUBLIC INSTRUCTION, NORTH CAROLINA DEPARTMENT OF | PUBLIC INSTRUCTION, NORTH CAROLINA DEPARTMENT OF | 438531009.15 | 54734144.18 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | NC | 84.010 | ||
| ASST_NON_H027A180110_091 | H027A180110 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | MICHIGAN DEPARTMENT OF EDUCATION | MICHIGAN DEPARTMENT OF EDUCATION | 418811813.0 | 82321479.54 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | MI | 84.027 | ||
| ASST_NON_DENA0003856_089 | DENA0003856 | Department of Energy | Department of Energy | grants | COOPERATIVE AGREEMENT (B) | UNIVERSITY OF ROCHESTER | UNIVERSITY OF ROCHESTER | 403748516.0 | 271012821.76 | UNIVERSITY OF ROCHESTER ''NATIONAL INERTIAL CONFINEMENT FUSION PROGRAM'' *NEW AWARD | 2018-10-01 | 2024-03-31 | 2018 | NY | 81.112 | ||
| CONT_AWD_36C79118K0233_3600_VA79113D0053_3600 | 36C79118K0233 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | HEALTH NET FEDERAL SERVICES, LLC | HEALTH NET FEDERAL SERVICES, LLC | 401444841.89 | EXPRESS REPORT: PCCC/CHOICE | 2018-01-01 | 2018-09-30 | 2018 | CA | ||||
| ASST_NON_4337DRFLP00000005_070 | 4337DRFLP00000005 | Department of Homeland Security | Federal Emergency Management Agency | grants | PROJECT GRANT (B) | STATE OF FLORIDA DIVISION OF EMERGENCY MANAGEMENT | STATE OF FLORIDA DIVISION OF EMERGENCY MANAGEMENT | 397815893.62 | 76445908.17 | GRANT TO LOCAL GOVERNMENT FOR REPAIR OR REPLACEMENT OF DISASTER DAMAGED FACILITIES | 2017-11-21 | 2020-09-30 | 2018 | FL | 97.039 | ||
| ASST_NON_2018V2GX0029_015 | 2018V2GX0029 | Department of Justice | Office of Justice Programs | grants | FORMULA GRANT (A) | OFFICE OF EMERGENCY SERVICES | OFFICE OF EMERGENCY SERVICES | 396642274.0 | 191204038.21 | OVC FY 18 VOCA ASSISTANCE FORMULA | 2017-10-01 | 2021-09-30 | 2018 | CA | 16.575 | ||
| ASST_NON_AA322131855A6_1601 | AA322131855A6 | Department of Labor | Employment and Training Administration | grants | FORMULA GRANT (A) | STATE OF CALIFORNIA EMPLOYMENT DEVELOPMENT DEPARTMENT | STATE OF CALIFORNIA EMPLOYMENT DEVELOPMENT DEPARTMENT | 396397321.0 | 5336514.59 | WIOA YOUTH/ADULT/DISLOCATED WORKERS FORMULA COMBINED | 2018-04-01 | 2021-06-30 | 2018 | CA | 17.258 | ||
| ASST_NON_S010A180052_091 | S010A180052 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | DEPARTMENT OF EDUCATION OF PUERTO RICO | DEPARTMENT OF EDUCATION OF PUERTO RICO | 396257109.0 | 243557702.12 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | PR | 84.010 | ||
| CONT_AWD_80NM0018F0652_8000_80NM0018D0004_8000 | 80NM0018F0652 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 387694154.96 | 350202636.46 | WIDE FIELD INFRARED SURVEY TELESCOPE (WFIRST) CORONAGRAPH THE CONTRACT IS THE SPONSORING AGREEMENT BETWEEN THE NATIONAL AERONAUTICS AND SPACE ADMINISTRATION (NASA) AND THE CALIFORNIA INSTITUTE OF TECHNOLOGY (CONTRACTOR), A PRIVATE NONPROFIT EDUCATIONAL INSTITUTION, WHICH ESTABLISHES THE RELATIONSHIP FOR THE OPERATION OF THE FEDERALLY FUNDED RESEARCH AND DEVELOPMENT CENTER (FFRDC) KNOWN AS THE JET PROPULSION LABORATORY. THE CONTRACTOR, JPL, IS REQUIRED TO PERFORM WORK THAT IS DESIGNATED IN TASK ORDERS ISSUED BY THE NASA MANAGEMENT OFFICE (NMO) CONTRACTING OFFICERS. NASA - SPONSORED WORK: JPL'S PRIMARY MISSION IS TO SUPPORT THE NASA SCIENCE MISSION DIRECTORATE (SMD) IN CARRYING OUT THE SPECIFIC OBJECTIVES IDENTIFIED IN THE SMD SCIENCE PLAN. THE FOUR BROAD SCIENTIFIC AREAS ARE: EARTH SCIENCE, PLANETARY SCIENCE, HELIOPHYSICS, AND ASTROPHYSICS. IN PERFORMANCE OF THIS CONTRACT, JPL SHALL: 1) SUPPLY A BROAD BASE OF SCIENTIFIC AND TECHNICAL CAPABILITIES RELEVANT TO NASA PROGRAM AND PROJECT RESPONSIBILITIES AND ASSIGNMENTS. 2) FOSTER ITS UNIQUE RELATIONSHIP WITH A TOP-TIER UNIVERSITY TO FACILITATE THE INVOLVEMENT OF SCIENTISTS, ENGINEERS, AND STUDENTS FROM THE UNIVERSITY AND RESEARCH COMMUNITIES IN NASA MISSION AND IN SUPPORTING OTHER GOVERNMENT AGENCIES. 3) SUPPORT NASA IN ENABLING PROGRAM AND INSTITUTIONAL CAPABILITIES. 4) DEVELOP SPACECRAFT AND INSTRUMENTS THAT ARE SENT TO VARIOUS DESTINATIONS WITH OUR SOLAR SYSTEM, INCLUDING EARTH ORBIT, PLANETS, PLANETARY SATELLITES, ASTEROIDS, AND COMETS. THESE MISSIONS MAY BE ORBITERS, LANDERS, OR ROVERS, AND TYPICALLY INCLUDE CUTTING-EDGE TECHNOLOGIES REQUIRED TO MEET SCIENTIFIC REQUIREMENTS. 5) PERFORM PROJECT TASKS INVOLVING: (I) AUTONOMOUS DEEP-SPACE, INNER-SPACE AND EARTH-ORBITING SPACECRAFT OR MAJOR SUBSYSTEMS, (II) EXPERIMENTS, INSTRUMENTS, OR OTHER DEVICES WHICH MAY BE CARRIED AS PAYLOAD ON SPACECRAFTS IN MISSIONS MANAGED BY OTHERS, AND/OR (III) GROUND-BASED SYSTEMS. 6) BEYOND ITS PRIMARY MISSION, JPL MAY PERFORM WORK FOR OTHER NASA MISSION DIRECTORATES OR OFFICES. … | 2018-10-01 | 2027-01-31 | 2018 | CA | |||
| ASST_NON_H027A180100_091 | H027A180100 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | EDUCATION, NEW JERSEY DEPARTMENT OF | EDUCATION, NEW JERSEY DEPARTMENT OF | 379450638.0 | 86481597.69 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | NJ | 84.027 | ||
| CONT_AWD_36C10B18N10040007_3600_VA11816D1004_3600 | 36C10B18N10040007 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | LEIDOS SMS INC | LEIDOS SMS INC | 372238646.36 | IGF::OT::IGF INFRASTRUCTURE OPERATIONS SERVICES SUPPORT | 2018-03-07 | 2021-12-31 | 2018 | TX | ||||
| CONT_AWD_70B04C18F00000071_7014_GS00Q09BGD0060_4735 | 70B04C18F00000071 | Department of Homeland Security | U.S. Customs and Border Protection | contracts | DELIVERY ORDER | SCIENCE APPLICATIONS INTERNATIONAL CORP | SCIENCE APPLICATIONS INTERNATIONAL CORP | 368704884.08 | 0.0 | REQUIREMENT FOR UNITED STATES CUSTOMS AND BORDER PROTECTION (CBP), OFFICE OF INFORMATION TECHNOLOGY (OIT), TARGETING AND ANALYSIS SYSTEMS PROGRAM DIRECTORATE (TASPD) TO PROVIDE THE FULL RANGE OF OPERATIONS AND MAINTENANCE SUPPORT FOR THE CBP TASPD SUITE OF COMPUTER AND SOFTWARE APPLICATIONS | 2018-03-14 | 2021-09-14 | 2018 | VA | |||
| ASST_NON_S010A180030_091 | S010A180030 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | EDUCATION, NEW JERSEY DEPARTMENT OF | EDUCATION, NEW JERSEY DEPARTMENT OF | 362318822.0 | 123032674.79 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | NJ | 84.010 | ||
| ASST_NON_H027A180073_091 | H027A180073 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | GEORGIA DEPT OF EDUCATION | GEORGIA DEPT OF EDUCATION | 360136871.41 | 72360338.31 | UNKNOWN TITLE | 2018-07-01 | 2021-09-30 | 2018 | GA | 84.027 | ||
| ASST_NON_S010A180003_091 | S010A180003 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | ARIZONA DEPARTMENT OF EDUCATION | ARIZONA DEPARTMENT OF EDUCATION | 359591534.0 | 77916386.39 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | AZ | 84.010 | ||
| ASST_NON_H027A180092_091 | H027A180092 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | PUBLIC INSTRUCTION, NORTH CAROLINA DEPARTMENT OF | PUBLIC INSTRUCTION, NORTH CAROLINA DEPARTMENT OF | 352250474.88 | 92081700.29 | UNKNOWN TITLE | 2018-07-01 | 2021-09-30 | 2018 | NC | 84.027 | ||
| ASST_NON_UI312841855A6_1601 | UI312841855A6 | Department of Labor | Employment and Training Administration | grants | FORMULA GRANT (A) | STATE OF CALIFORNIA EMPLOYMENT DEVELOPMENT DEPARTMENT | STATE OF CALIFORNIA EMPLOYMENT DEVELOPMENT DEPARTMENT | 342753582.0 | 285099494.17 | UNEMPLOYMENT INSURANCE | 2017-10-01 | 2020-12-31 | 2018 | CA | 17.225 | ||
| ASST_NON_S010A180018_091 | S010A180018 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | LA DEPT. OF ADMIN | LA DEPT. OF ADMIN | 337988465.24 | 93933480.22 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | LA | 84.010 | ||
| CONT_AWD_80MSFC18C0005_8000_-NONE-_-NONE- | 80MSFC18C0005 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DEFINITIVE CONTRACT | BASTION TECHNOLOGIES, INC. | BASTION TECHNOLOGIES, INC. | 337264554.23 | 271101133.46 | SAFETY AND MISSION ASSURANCE SERVICES TO SUPPORT MARSHALL SPACE FLIGHT CENTER, STENNIS SPACE CENTER, KENNEDY SPACE CENTER AND MICHOUD ASSEMBLY FACILITY | 2017-11-01 | 2025-12-31 | 2018 | AL | |||
| CONT_AWD_70RSAT18FR0000005_7001_70RSAT18D00000001_7001 | 70RSAT18FR0000005 | Department of Homeland Security | Office of Procurement Operations | contracts | DELIVERY ORDER | ASRC FEDERAL FIELD SERVICES, LLC | ASRC FEDERAL FIELD SERVICES, LLC | 334556218.42 | 134838895.8 | IGF::OT::IGF CENTER WIDE SUPPORT PROGRAM (CWSP) | 2018-01-15 | 2028-01-14 | 2018 | NY | |||
| ASST_NON_4382DRCAP00000001_070 | 4382DRCAP00000001 | Department of Homeland Security | Federal Emergency Management Agency | grants | PROJECT GRANT (B) | OFFICE OF EMERGENCY SERVICES | OFFICE OF EMERGENCY SERVICES | 333690789.47 | 2485306.01 | GRANT TO LOCAL GOVERNMENT FOR REPAIR OR REPLACEMENT OF DISASTER DAMAGED FACILITIES | 2018-09-26 | 2026-09-30 | 2018 | CA | 97.036 | ||
| ASST_NON_IL-2018-028_069 | IL-2018-028 | Department of Transportation | Federal Transit Administration | grants | FORMULA GRANT (A) | CHICAGO TRANSIT AUTHORITY | CHICAGO TRANSIT AUTHORITY | 317478347.0 | 105417933.0 | APPLICATION PURPOSE: THIS AWARD PROVIDES FOR THE PURCHASE OF BUSES THE PURCHASE OF NEW RAILCAR BUS AND RAIL REVENUE FLEET OVERHAUL ENGINEERING ASSESSMENTS AND DESIGN PLANS FOR BUS SYSTEM ELECTRIFICATION FOCUSING ON CTA GARAGES AND MAINTENANCE FACILITIES FULL DESIGN TARGETED RAIL STATIONS TO PLAN FOR FUTURE CONSTRUCTION FOCUS ON MAKING STATIONS.; ACTIVITIES PERFORMED: PURCHASE NEW BUSES AND RAIL CAR TO REPLACE OVERAGE REVENUE FLEET VEHICLES OVERHAUL REVENUE FLEET TO MAINTAIN OR EXTEND THE ASSET LIFE CYCLE COMPLETE BUS SYSTEM ENGINEERING ASSESSMENTS FOR TRANSITION TO FUTURE FULL ELECTRIFICATION OF THE SYSTEM COMPLETE 100% DESIGN FOR MAKING RAIL STATIONS FULLY ACCESSIBLE.; EXPECTED OUTCOMES: FUNDING WILL ALLOW THE CTA TO REPLACE OVERAGED BUSES AND RAILCARS TO PROVIDE MORE EFFICIENT AND RELIABLE SERVICE AND REDUCE MAINTENANCE COSTS EXTEND THE USEFUL LIFE OF SELECT BUSES MAINTAIN THE LIFE OF RAIL CAR FLEET COMPLETE ALL NECESSARY ENGINEERING PLANNING AND DEVELOPMENT THAT LEADS TO FACILITIES CONSTRUCTION/ MODIFICATION TO ELECTRIFY THE BUS SYSTEM DESIGN OF ACCESSIBILITY IMPROVEMENTS FOR TARGETED RAIL STATIONS TO PROCEED TO CONSTRUCTION.; INTENDED BENEFICIARIES: FUNDED PROJECTS WILL PROVIDE FAR-REACHING BENEFITS TO CTA CUSTOMERS INCLUDING IMPROVED SERVICE QUALITY SPEED SAFETY RELIABILITY MAKING THE NEXT PHASE OF RAIL STATIONS FULLY ACCESSIBLE AND PREPARING THE BUS SYSTEM FOR FUTURE CONVERSION TO FULL ELECTRIFICATION AND THE RUNNING OF ZERO-EMISSION REVENUE VEHICLES.; SUBRECIPIENT ACTIVITIES: NONE | 2018-09-14 | 2026-12-31 | 2018 | IL | 20.526 | ||
| ASST_NON_S010A180042_091 | S010A180042 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | DEPARTMENT OF EDUCATION TENNESSEE | DEPARTMENT OF EDUCATION TENNESSEE | 309747087.07 | 54554773.75 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | TN | 84.010 | ||
| CONT_AWD_80GSFC18C0083_8000_-NONE-_-NONE- | 80GSFC18C0083 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DEFINITIVE CONTRACT | BAE SYSTEMS SPACE & MISSION SYSTEMS INC. | BAE SYSTEMS SPACE & MISSION SYSTEMS INC. | 307899595.0 | 287621083.72 | THE WOMA REQUIREMENT WAS ISSUED AS A FULL AND OPEN COMPETITIVE PROCUREMENT TO DESIGN, ANALYZE, DEVELOP, FABRICATE, INTEGRATE, TEST, AND EVALUATE THE WIDE FIELD INSTRUMENT (WFI) OPTO-MECHANICAL ASSEMBLY (WOMA) FOR THE WIDE FIELD INFRARED SURVEY TELESCOPE (WFIRST) MISSION. IN ADDITION, IT DEFINES THE TASKS NECESSARY TO SUPPORT THE SUBSEQUENT INTEGRATION, TEST, EVALUATION, AND VALIDATION OF THE WFI. IT DEFINES THE POST-DELIVERY SUPPORT TO PAYLOAD AND OBSERVATORY INTEGRATION AND TEST, AND TO PRE-LAUNCH, LAUNCH AND COMMISSIONING ACTIVITIES AT THE MISSION OPERATIONS CENTER (MOC) AND TO SUPPLY AND MAINTAIN THE INSTRUMENT GROUND SUPPORT EQUIPMENT (GSE). | 2018-05-24 | 2027-01-31 | 2018 | CO | |||
| ASST_NON_H126A180005_091 | H126A180005 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | CA DEPT OF REHABILITATION | CA DEPT OF REHABILITATION | 303129769.0 | 195259.82 | UNKNOWN TITLE | 2017-10-01 | 2018-09-30 | 2018 | CA | 84.126 | ||
| ASST_NON_H027A180107_091 | H027A180107 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | COMMONWEALTH OF VIRGINIA STATE BOARD OF EDUCATION | COMMONWEALTH OF VIRGINIA STATE BOARD OF EDUCATION | 298099732.87 | 120547913.98 | UNKNOWN TITLE | 2018-07-01 | 2021-09-30 | 2018 | VA | 84.027 | ||
| ASST_NON_H027A180076_091 | H027A180076 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | MASSACHUSETTS DEPARTMENT OF ELEMENTARY & SECONDARY EDUCATION | MASSACHUSETTS DEPARTMENT OF ELEMENTARY & SECONDARY EDUCATION | 297929769.58 | 46089502.58 | UNKNOWN TITLE | 2018-07-01 | 2021-09-30 | 2018 | MA | 84.027 | ||
| CONT_AWD_80NM0018F0561_8000_80NM0018D0004_8000 | 80NM0018F0561 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 295606614.04 | 210743478.85 | SURFACE WATER AND OCEAN TOPOGRAPHY (SWOT) 83-16443 | 2018-10-01 | 2026-09-30 | 2018 | CA | |||
| CONT_AWD_80NM0018F0607_8000_80NM0018D0004_8000 | 80NM0018F0607 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 295007665.47 | 235947977.58 | MARS SCIENCE LABORATORY 67-8636 | 2018-10-01 | 2028-09-30 | 2018 | CA | |||
| ASST_NON_NJ-2018-009_069 | NJ-2018-009 | Department of Transportation | Federal Transit Administration | grants | FORMULA GRANT (A) | NEW JERSEY TRANSIT CORPORATION | NEW JERSEY TRANSIT CORPORATION | 291424070.0 | 49979828.0 | FY2018 SECTION 5307 URBANIZED AREA FORMULA GRANT | 2018-08-16 | 2035-04-01 | 2018 | NJ | 20.507 | ||
| CONT_AWD_1333BJ18F00151003_1344_DOC50PAPT1500003_1344 | 1333BJ18F00151003 | Department of Commerce | U.S. Patent and Trademark Office | contracts | DELIVERY ORDER | REED TECHNOLOGY AND INFORMATION SERVICES LLC | REED TECHNOLOGY AND INFORMATION SERVICES LLC | 286667428.65 | 0.0 | RTIS PAT PRTG 1/25/2018 - 3/09/18 FUNDING DELIVERY ORDER - TBD | 2018-01-25 | 2021-01-31 | 2018 | VA | |||
| ASST_NON_2018V2GX0040_015 | 2018V2GX0040 | Department of Justice | Office of Justice Programs | grants | FORMULA GRANT (A) | GOVERNOR, TEXAS OFFICE OF THE | GOVERNOR, TEXAS OFFICE OF THE | 284101321.0 | 155318338.92 | OVC FY 18 VOCA VICTIM ASSISTANCE FORMULA | 2017-10-01 | 2021-09-30 | 2018 | TX | 16.575 | ||
| ASST_NON_4353DRCAP00000001_070 | 4353DRCAP00000001 | Department of Homeland Security | Federal Emergency Management Agency | grants | PROJECT GRANT (B) | OFFICE OF EMERGENCY SERVICES | OFFICE OF EMERGENCY SERVICES | 277200063.1 | 803829.64 | GRANT TO LOCAL GOVERNMENT FOR REPAIR OR REPLACEMENT OF DISASTER DAMAGED FACILITIES | 2018-03-07 | 2026-09-30 | 2018 | CA | 97.036 | ||
| CONT_AWD_70B02C18C00000040_7014_-NONE-_-NONE- | 70B02C18C00000040 | Department of Homeland Security | U.S. Customs and Border Protection | contracts | DEFINITIVE CONTRACT | GENERAL ATOMICS AERONAUTICAL SYSTEMS, INC. | GENERAL ATOMICS AERONAUTICAL SYSTEMS, INC. | 272580354.67 | 34415164.5 | UAS OPERATIONAL AND MAINTENANCE SERVICES | 2018-04-19 | 2024-09-30 | 2018 | CA | |||
| ASST_NON_H027A180084_091 | H027A180084 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | DEPARTMENT OF EDUCATION INDIANA | DEPARTMENT OF EDUCATION INDIANA | 271331398.23 | 139212302.97 | UNKNOWN TITLE | 2018-07-01 | 2021-09-30 | 2018 | IN | 84.027 | ||
| ASST_NON_S010A180014_091 | S010A180014 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | DEPARTMENT OF EDUCATION INDIANA | DEPARTMENT OF EDUCATION INDIANA | 268364572.0 | 88841961.14 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | IN | 84.010 | ||
| CONT_AWD_80NM0018F0517_8000_80NM0018D0004_8000 | 80NM0018F0517 | National Aeronautics and Space Administration | National Aeronautics and Space Administration | contracts | DELIVERY ORDER | CALIFORNIA INSTITUTE OF TECHNOLOGY | CALIFORNIA INSTITUTE OF TECHNOLOGY | 267710378.35 | 256707523.39 | SPHEREX:AN ALL-SKY SPECTRAL SURVEY 71-700089 | 2018-10-01 | 2028-04-30 | 2018 | CA | |||
| ASST_NON_S010A180046_091 | S010A180046 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | COMMONWEALTH OF VIRGINIA STATE BOARD OF EDUCATION | COMMONWEALTH OF VIRGINIA STATE BOARD OF EDUCATION | 262865754.51 | 95891803.23 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | VA | 84.010 | ||
| ASST_NON_NY-2018-072_069 | NY-2018-072 | Department of Transportation | Federal Transit Administration | grants | FORMULA GRANT (A) | METROPOLITAN TRANSPORTATION AUTHORITY | METROPOLITAN TRANSPORTATION AUTHORITY | 260003000.0 | 142591393.0 | APPLICATION PURPOSE: THIS AWARD WILL ASSIST THE MTA TO INVEST CAPITAL FUNDING INTO ITS ASSETS/INFRASTRUCTURE MAINTAINED BY NEW YORK CITY TRANSIT LONG ISLAND RAIL ROAD AND METRO-NORTH PROJECTS.; ACTIVITIES PERFORMED: THIS APPLICATION SCOPE OF WORK INCLUDES INVESTMENTS IN CONSTRUCTION EQUIPMENT ADA AT VARIOUS STATIONS AND OTHER STATE OF GOOD REPAIR IMPROVEMENTS.; EXPECTED OUTCOMES: THIS APPLICATION WILL SUPPORT THE MTAS NEED TO REHABILITATE AND REPLACE ASSETS TO ACHIEVE A STATE OF GOOD REPAIR.; INTENDED BENEFICIARIES: THE MTA AND ITS RIDERSHIP.; SUBRECIPIENT ACTIVITIES: THE MTA DOES NOT HAVE SUBRECIPIENTS UNDER THIS AWARD. | 2018-09-17 | 2027-04-30 | 2018 | NY | 20.525 | ||
| ASST_NON_EMW-2018-SS-00013_070 | EMW-2018-SS-00013 | Department of Homeland Security | Federal Emergency Management Agency | grants | FORMULA GRANT (A) | NEW YORK STATE DIVISION OF HOMELAND SECURITY & EMERGENCY SERVICES | NEW YORK STATE DIVISION OF HOMELAND SECURITY & EMERGENCY SERVICES | 258170319.1 | 0.0 | HOMELAND SECURITY GRANT PROGRAM | 2018-09-01 | 2018 | NY | 97.067 | |||
| ASST_NON_S010A180001_091 | S010A180001 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | ALABAMA STATE DEPARTMENT OF EDUCATION | ALABAMA STATE DEPARTMENT OF EDUCATION | 251981545.0 | 46145515.07 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | AL | 84.010 | ||
| ASST_NON_H027A180052_091 | H027A180052 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | DEPARTMENT OF EDUCATION TENNESSEE | DEPARTMENT OF EDUCATION TENNESSEE | 249311747.0 | 51409344.42 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | TN | 84.027 | ||
| CONT_AWD_36C10B18F2957_3600_47QRAA18D001P_4732 | 36C10B18F2957 | Department of Veterans Affairs | Department of Veterans Affairs | contracts | DELIVERY ORDER | DELOITTE CONSULTING LLP | DELOITTE CONSULTING LLP | 247927420.69 | 81605320.27 | REQUIREMENT TO SUPPORT THE FINANCIAL MANAGEMENT BUSINESS TRANSFORMATION EFFORT TO TRANSFORM THE VA LEGACY FINANCIAL MANAGEMENT SYSTEM. | 2018-09-27 | 2023-10-31 | 2018 | VA | |||
| ASST_NON_H126A180092_091 | H126A180092 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | TEXAS WORKFORCE COMMISSION | TEXAS WORKFORCE COMMISSION | 246980770.9 | 5812349.92 | UNKNOWN TITLE | 2017-10-01 | 2019-09-30 | 2018 | TX | 84.126 | ||
| ASST_NON_S010A180040_091 | S010A180040 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | SOUTH CAROLINA DEPARTMENT OF EDUCATION | SOUTH CAROLINA DEPARTMENT OF EDUCATION | 243787781.0 | 56741037.47 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | SC | 84.010 | ||
| ASST_NON_S010A180025_091 | S010A180025 | Department of Education | Department of Education | grants | FORMULA GRANT (A) | ELEMENTARY & SECONDARY EDUCATION MISSOURI DEPARTMENT OF | ELEMENTARY & SECONDARY EDUCATION MISSOURI DEPARTMENT OF | 239573145.0 | 79746937.51 | UNKNOWN TITLE | 2018-07-01 | 2019-09-30 | 2018 | MO | 84.010 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE spending_awards (
generated_internal_id TEXT PRIMARY KEY,
award_id TEXT,
agency TEXT,
sub_agency TEXT,
award_category TEXT,
award_type TEXT,
recipient_name TEXT,
recipient_name_normalized TEXT,
award_amount REAL,
total_outlays REAL,
description TEXT,
start_date TEXT,
end_date TEXT,
fiscal_year INTEGER,
state_code TEXT,
cfda_number TEXT,
naics_code TEXT,
naics_description TEXT
);
CREATE INDEX idx_spending_agency ON spending_awards(agency);
CREATE INDEX idx_spending_category ON spending_awards(award_category);
CREATE INDEX idx_spending_fy ON spending_awards(fiscal_year);
CREATE INDEX idx_spending_recipient ON spending_awards(recipient_name);
CREATE INDEX idx_spending_recipient_norm ON spending_awards(recipient_name_normalized);
CREATE INDEX idx_spending_state ON spending_awards(state_code);