disaster_number int64 1.6k 4.49k | declaration_title stringclasses 5
values | declaration_date stringdate 2005-08-29 00:00:00 2020-03-25 00:00:00 | incident_type stringclasses 3
values | state stringclasses 6
values | county stringclasses 4
values | applicant_id_gm int64 6.8k 248k | applicant_id stringlengths 12 12 | applicant_name stringlengths 19 58 | applicant_type stringclasses 5
values | is_pnp bool 2
classes | pw_number int64 1 100k | project_id_gm int64 49.8k 903k | project_title stringlengths 15 109 | damage_category_code stringclasses 6
values | damage_category stringclasses 7
values | project_size stringclasses 1
value | project_status stringclasses 1
value | process_step stringclasses 7
values | project_amount float64 811M 10.5B | federal_share_obligated float64 730M 2.89B | total_obligated float64 730M 2.89B | mitigation_amount float64 0 730M | first_obligation_date stringdate 2013-04-30 00:00:00 2025-01-17 00:00:00 | last_obligation_date stringdate 2014-09-18 00:00:00 2026-11-03 00:00:00 | days_since_first_obligation int64 658 4.94k | ontology_oid stringclasses 4
values |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4,339 | HURRICANE MARIA | 2017-09-20 | Hurricane | PR | Statewide | 6,801 | 000-UA2QU-00 | PR Electric Power Authority | State Government | false | 10,710 | 673,691 | FAASt [Equipment and Materials] (E&M) | F | Utilities | Large | Eligible | Pending QA Review | 3,206,944,731.28 | 2,886,250,258.16 | 2,886,250,258.16 | 0 | 2022-06-09 | 2026-05-13 | 1,611 | org:PR ELECTRIC POWER AUTHORITY |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 10,437 | 000-UGNOL-00 | V.I. Waste Management Authority / St Thomas | U.S. Territory or Possession | false | 100,216 | 88,322 | TMUGN09 - St. Thomas Wastewater System | F | Utilities | Large | Eligible | Pending EHP Review | 2,188,655,954.66 | 2,144,882,835.57 | 2,144,882,835.57 | 0 | 2025-01-17 | 2025-01-17 | 658 | null |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 10,362 | 000-UET63-01 | V.I. Department of Public Works / St Croix | U.S. Territory or Possession | false | 1,425 | 708,286 | XMUET95 - GM708286 -St. Croix Island-Wide Unified Road Paving Project | C | Roads and Bridges | Large | Eligible | Pending EHP Review | 1,791,528,677 | 1,755,698,103.46 | 1,755,698,103.46 | 0 | 2024-10-03 | 2024-10-03 | 764 | null |
4,339 | HURRICANE MARIA | 2017-09-20 | Hurricane | PR | Statewide | 6,801 | 000-UA2QU-00 | PR Electric Power Authority | State Government | false | 6,099 | 136,271 | MEPA078 Puerto Rico Electrical Power Authority Island Wide FAASt Project | F | Utilities | Large | Eligible | Obligated | 10,510,983,791.54 | 1,710,463,198.05 | 1,710,463,198.05 | 0 | 2020-09-23 | 2026-11-03 | 2,235 | org:PR ELECTRIC POWER AUTHORITY |
4,339 | HURRICANE MARIA | 2017-09-20 | Hurricane | PR | Statewide | 7,029 | 000-UK5O0-00 | PR Aqueduct and Sewer Authority | State Government | false | 7,382 | 144,184 | MAAA200 Puerto Rico Aqueduct and Sewer Authority (PRASA) Island Wide FAASt Project | F | Utilities | Large | Eligible | Pending Award | 4,069,698,951.41 | 1,403,320,503.82 | 1,403,320,503.82 | 0 | 2021-01-08 | 2026-10-08 | 2,128 | null |
1,603 | HURRICANE KATRINA | 2005-08-29 | Hurricane | LA | Orleans Parish | 248,464 | 071-55000-00 | New Orleans, City of | City or Township Government | false | 21,032 | 903,339 | (PW# 21032) ROADWAY, STORM WATER AND SANITARY SEWER COLLECTION, WATER DISTRIBUTION, & ADA RAMP INFRASTRUCTURE | C | Roads and Bridges | Large | Eligible | Obligated | 1,399,420,109.37 | 1,399,420,109.37 | 1,413,449,295.96 | 0 | 2016-07-20 | 2016-07-20 | 3,761 | null |
4,485 | COVID-19 PANDEMIC | 2020-03-25 | Biological | TX | Statewide | 21,947 | 000-U007C-00 | Texas Division of Emergency Management | State Government | false | 40 | 143,522 | COVID-19 Emergency Protective Measures | B | Emergency Protective Measures | Large | Eligible | Pending Project Closeout Final Review | 1,313,498,213.48 | 1,313,498,213.48 | 1,313,498,213.48 | 0 | 2020-09-29 | 2021-03-31 | 2,229 | org:TEXAS DIVISION OF EMERGENCY MANAGEMENT |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 10,404 | 000-UR8I4-01 | V.I. Water and Power Authority / St Croix | U.S. Territory or Possession | false | 1,424 | 166,438 | XMWPF03- St. Croix Island-Wide Potable Water Distribution System | F | Utilities | Large | Eligible | Pending EHP Review | 1,281,284,792.85 | 1,255,659,097 | 1,255,659,097 | 0 | 2024-10-03 | 2024-10-03 | 764 | null |
4,085 | HURRICANE SANDY | 2012-10-30 | Hurricane | NY | Nassau County | 243,233 | 000-UUMIZ-00 | Long Island Power Authority | State Government | false | 367 | 885,124 | (PW# 367) UUMIZ01 Overhead Power Distribution Lines | F | Utilities | Large | Eligible | Obligated | 1,409,702,766 | 1,243,648,431.4 | 1,243,648,431.4 | 729,695,000 | 2013-04-30 | 2021-09-23 | 4,938 | org:LONG ISLAND POWER AUTHORITY |
4,407 | WILDFIRES | 2018-11-12 | Wildfire | CA | Statewide | 10,857 | 000-UUJ4B-00 | California Department of Resources, Recycling and Recovery | State Government | false | 174 | 76,595 | Butte County (Camp Fire) MT54032 | A | Debris Removal | Large | Eligible | Obligated | 1,317,607,353.48 | 1,185,846,618.14 | 1,185,846,618.14 | 0 | 2020-01-08 | 2025-04-26 | 2,494 | null |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 10,403 | 000-UR8I4-00 | V.I. Water and Power Authority / St Thomas | U.S. Territory or Possession | false | 100,340 | 705,454 | TMUR807 - St. Thomas/St. John Island-Wide Potable Water Distribution System | F | Utilities | Large | Eligible | Pending EHP Review | 1,083,115,833.13 | 1,061,453,516.47 | 1,061,453,516.47 | 0 | 2025-01-17 | 2025-01-17 | 658 | null |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 10,405 | 000-UET63-00 | V.I. Department of Public Works / St Thomas | U.S. Territory or Possession | false | 100,341 | 723,270 | GM723270-TMUET95 -St. Thomas Island-Wide Unified Road Paving Project | C | Roads and Bridges | Large | Eligible | Pending EHP Review | 1,078,328,147 | 1,056,761,584.06 | 1,056,761,584.06 | 0 | 2025-01-17 | 2025-01-17 | 658 | null |
4,339 | HURRICANE MARIA | 2017-09-20 | Hurricane | PR | Statewide | 6,801 | 000-UA2QU-00 | PR Electric Power Authority | State Government | false | 9,510 | 335,168 | FAASt A&E PREPA | F | Utilities | Large | Eligible | Obligated | 1,133,563,562.43 | 1,020,207,206.19 | 1,020,207,206.19 | 0 | 2021-10-06 | 2025-04-28 | 1,857 | org:PR ELECTRIC POWER AUTHORITY |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 10,436 | 000-U4D6C-00 | Schneider Regional Medical Center / St Thomas | U.S. Territory or Possession | false | 1,407 | 101,314 | TMU4D07 - GM101314 - Roy Lester Schneider Hospital | E | Buildings and Equipment | Large | Eligible | Obligated | 1,031,963,414.38 | 1,011,324,146.09 | 1,011,324,146.09 | 0 | 2024-02-12 | 2024-02-28 | 998 | null |
4,339 | HURRICANE MARIA | 2017-09-20 | Hurricane | PR | Statewide | 6,845 | 000-UC4ZA-00 | Central Recovery and Reconstruccion Office (COR3) | U.S. Territory or Possession | false | 662 | 49,982 | MCRO001 SECTION 324 MANAGEMENT COSTS (PW00662) | Z | Direct Administrative Costs | Large | Eligible | Obligated | 1,001,882,554.2 | 1,001,882,554.2 | 1,001,882,554.2 | 0 | 2018-07-26 | 2026-02-27 | 3,025 | null |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 10,372 | 000-UGNOL-01 | V.I. Waste Management Authority / St Croix | U.S. Territory or Possession | false | 1,404 | 84,994 | XMUGN07 STX Pump Station Repairs and Waste Water Treatment Plant | F | Utilities | Large | Eligible | Pending EHP Review | 1,009,946,362.43 | 989,747,435.18 | 989,747,435.18 | 0 | 2024-07-19 | 2024-07-19 | 840 | null |
4,085 | HURRICANE SANDY | 2012-10-30 | Hurricane | NY | New York County | 243,367 | 061-U7SWM-00 | New York University | Nonprofit with 501C3 IRS Status | true | 4,005 | 885,726 | (PW# 4005) NYULM22 - PAAP Campuswide Repair Capped Grant | E | Buildings and Equipment | Large | Eligible | Obligated | 1,091,635,574.56 | 979,427,192.45 | 979,427,192.45 | 589,720,118 | 2014-08-21 | 2018-11-08 | 4,460 | null |
4,480 | COVID-19 PANDEMIC | 2020-03-20 | Biological | NY | New York County | 23,013 | 061-51000-41 | City of New York - Management and Budget | City or Township Government | false | 1 | 134,894 | **Project CLOSED** DOB Review Complete - NYC Health and Hospitals--COVID 19 Response Activities (100% FS) | B | Emergency Protective Measures | Large | Eligible | Pending Closeout Award | 1,190,565,519.21 | 932,815,649.28 | 932,815,649.28 | 0 | 2020-07-22 | 2025-11-25 | 2,298 | null |
4,339 | HURRICANE MARIA | 2017-09-20 | Hurricane | PR | Statewide | 6,801 | 000-UA2QU-00 | PR Electric Power Authority | State Government | false | 251 | 49,797 | 251E-AEE002-TRANSMISSION-COBRA CONTRACT | B | Emergency Protective Measures | Large | Eligible | Obligated | 945,429,800 | 923,373,121.77 | 923,373,121.77 | 0 | 2017-12-29 | 2023-03-28 | 3,234 | org:PR ELECTRIC POWER AUTHORITY |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 10,373 | 000-UAAZ9-01 | Governor Juan F. Luis Hospital / ST Croix | U.S. Territory or Possession | false | 1,378 | 90,822 | XMUAA21 - GM90822 - Replacement of GJFLH building | E | Buildings and Equipment | Large | Eligible | Obligated | 927,190,469.06 | 908,646,659.68 | 908,646,659.68 | 0 | 2023-05-25 | 2024-07-19 | 1,261 | null |
4,340 | HURRICANE MARIA | 2017-09-20 | Hurricane | VI | Statewide | 54,388 | 000-U8TG9-00 | Virgin Islands Territorial Emergency Management Agency | U.S. Territory or Possession | false | 1,249 | 176,714 | TMU8T01 - Management Costs | Z | Management Costs | Large | Eligible | Obligated | 1,400,409,890.42 | 900,409,890.42 | 900,409,890.42 | 0 | 2022-01-25 | 2026-10-06 | 1,746 | null |
4,085 | HURRICANE SANDY | 2012-10-30 | Hurricane | NY | null | 244,032 | 061-51000-41 | NEW YORK / MANAGMENT AND BUDGET, OFFICE OF | City or Township Government | false | 4,539 | 887,917 | (PW# 4539) 510HH04 - Coney Island Hospital - I PAAP (HHC) | E | Buildings and Equipment | Large | Eligible | Obligated | 922,743,641 | 830,469,276.9 | 830,469,276.9 | 189,027,586 | 2015-07-09 | 2015-07-09 | 4,138 | null |
4,339 | HURRICANE MARIA | 2017-09-20 | Hurricane | PR | Statewide | 7,043 | 000-ULGE2-00 | PR Department of Education | State Government | false | 6,059 | 137,274 | PRDE FEMA Accelerated Award Strategy (FAASt) Project | E | Buildings and Equipment | Large | Eligible | Obligated | 2,294,678,676.06 | 827,471,045.15 | 827,471,045.15 | 0 | 2020-09-23 | 2026-10-13 | 2,235 | org:PR DEPARTMENT OF EDUCATION |
4,339 | HURRICANE MARIA | 2017-09-20 | Hurricane | PR | Statewide | 6,801 | 000-UA2QU-00 | PR Electric Power Authority | State Government | false | 11,583 | 714,654 | FAASt [Advanced Metering Infrastructure (AMI)] (Telecommunications) | F | Utilities | Large | Eligible | Obligated | 876,270,176 | 788,643,158.4 | 788,643,158.4 | 544,207,595 | 2023-12-07 | 2024-04-30 | 1,065 | org:PR ELECTRIC POWER AUTHORITY |
4,085 | HURRICANE SANDY | 2012-10-30 | Hurricane | NY | Nassau County | 243,577 | 059-99059-01 | Nassau County Public Works | County Government | false | 3,714 | 886,396 | (PW# 3714) NAS0008 - Wastewater Facilities PAAP | F | Utilities | Large | Eligible | Pending Insurance Completion | 810,708,377 | 729,637,539.3 | 729,637,539.3 | 383,250,138 | 2014-09-18 | 2014-09-18 | 4,432 | null |
FEMA Public Assistance Open Projects: free sample (Tensorust LLC)
15,529 large FEMA Public Assistance projects that are obligated or in process but not closed out, carrying $115.9B in federal share; 7,928 were first obligated more than five years ago.
Headline: Large Public Assistance projects are paid on actual cost and must be closed out project by project, so every open one is unfinished work: construction, documentation, cost reconciliation or closeout review.
This repository is a free teaser, not the dataset. It holds 25 example rows and a summary table with no names in it. The full file has 15,529 rows and is sold by Tensorust LLC: https://tensorust.com/datasets/fema-pa-large-projects/.
Files here
| file | what it is |
|---|---|
sample.csv |
25 rows of the full file (the same sample shown on tensorust.com) |
summary_by_state.csv |
row counts and totals by state across the full file, no entity names (groups with fewer than 3 rows are folded into "Other") |
Summary by state (largest groups)
| State | rows | Project amount (USD) |
|---|---|---|
| PR | 6,668 | 51,243,796,618 |
| LA | 1,266 | 10,280,030,481 |
| FL | 1,242 | 7,628,228,897 |
| CA | 903 | 9,490,413,235 |
| TX | 668 | 6,416,617,735 |
| NC | 647 | 2,996,136,069 |
| NY | 574 | 16,980,725,454 |
| VI | 507 | 21,964,136,806 |
| KY | 375 | 764,416,234 |
| SC | 245 | 735,627,131 |
| TN | 192 | 1,222,768,973 |
| NM | 187 | 949,603,561 |
| TOTAL | 15,529 | 142,457,346,986 |
Full table: summary_by_state.csv.
What the full file has
- 15,529 rows
- Parquet and CSV, a README with sources, method and limits, and the build script
- Free 25-row sample (no personal contact data)
Coverage: Every large PA project nationwide not marked closed out, all disasters in the dataset. OpenFEMA data refreshed 2026-11-06; built 2026-11-06.
Columns in the full file
| column | meaning |
|---|
Get the full file
| tier | price | includes |
|---|---|---|
| Project file | $595 | Every open large PA project nationwide (CSV and Parquet). |
| State or region feed | $1,800 a year | Monthly refresh for 12 months with new obligations, step changes and newly opened projects flagged. |
| Firm license | $4,800 a year | Monthly national feed, applicant rollups and internal redistribution across a disaster recovery or engineering firm. |
Email mattbusel@tensorust.com with the tier and a billing contact, and we will send a proper invoice (ACH or card). The file is delivered once the invoice is paid. Details and the live sample: https://tensorust.com/datasets/fema-pa-large-projects/. All datasets: https://tensorust.com/datasets/
Method and limits
Sources
- OpenFEMA PublicAssistanceFundedProjectsDetails v2 (last refresh 2026-11-06)
- OpenFEMA PublicAssistanceApplicantsProgramDeliveries v1 (applicant names and types)
- OpenFEMA DisasterDeclarationsSummaries v2
License
The sample and summary here are free to view, analyze and cite with attribution to "Tensorust LLC, https://tensorust.com/datasets/fema-pa-large-projects/". The full dataset is licensed separately per tier. No resale or redistribution of Tensorust data without a written license.
Tensorust LLC, Tuckahoe NY. mattbusel@tensorust.com | https://tensorust.com
- Downloads last month
- 41