subapplication_id stringlengths 20 20 | bric_fiscal_year int64 2.02k 2.03k | cancellation_group stringclasses 2
values | state stringlengths 2 2 | state_applicant stringlengths 28 68 | subapplicant stringlengths 14 68 | subapplicant_type stringclasses 4
values | city stringlengths 5 13 | project_title stringlengths 13 100 ⌀ | funding_category stringclasses 4
values | primary_activity stringclasses 6
values | primary_hazard stringclasses 3
values | lifeline stringclasses 3
values | nature_based stringclasses 2
values | small_impoverished float64 0 1 ⌀ | population_affected float64 2 100 ⌀ | benefit_cost_ratio float64 1.06 38.6 ⌀ | federal_share_lost float64 36.2M 116M | local_match float64 0 57.7M | total_project_cost float64 36.9M 116M | obligated float64 0 0 | paid float64 0 0 | fema_status stringclasses 1
value | selection_status stringclasses 1
value | submitted_to_fema stringlengths 24 24 | disaster_number float64 | ontology_oid stringlengths 19 72 ⌀ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EMF-2023-BR-004-0024 | 2,023 | Selected FY2020-2023, never obligated | CA | OFFICE OF EMERGENCY SERVICES | OFFICE OF EMERGENCY SERVICES | State Government | MATHER | 2023 BRIC Cal OES Management Costs | Management Costs | Management costs | null | null | null | null | null | null | 116,353,352 | 0 | 116,353,352 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-02-26T00:00:00.000Z | null | org:OFFICE OF EMERGENCY SERVICES |
EMS-2022-BR-006-0006 | 2,022 | Selected FY2020-2023, never obligated | OR | OREGON DEPARTMENT OF EMERGENCY MANAGEMENT | CITY OF GRANTS PASS | Local Government | GRANTS PASS | Grants Pass Water Treatment Plant Relocation BRIC | Competitive | Relocation | Flooding | Food, water, shelter | null | 0 | 81 | 1.87 | 87,255,237.75 | 29,085,079.25 | 116,340,317 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2023-01-13T00:00:00.000Z | null | org:CITY OF GRANTS PASS |
EMK-2025-BR-007-0001 | 2,025 | Submitted in the FY2024 round, never selected | NE | SANTEE SIOUX TRIBE OF NEBRASKA | SANTEE SIOUX TRIBE OF NEBRASKA | Indian Tribal Government | NIOBRARA | null | Competitive | Utility and infrastructure protection | Drought | Food, water, shelter | null | 1 | 100 | 1.33 | 51,457,957 | 9,129,000 | 60,586,957 | 0 | 0 | Submitted to FEMA | null | 2026-07-23T00:00:00.000Z | null | org:SANTEE SIOUX TRIBE OF NEBRASKA |
EMF-2022-BR-044-0019 | 2,022 | Selected FY2020-2023, never obligated | CA | OFFICE OF EMERGENCY SERVICES | CITY OF PACIFICA | Local Government | PACIFICA | BRIC 2022 City of Pacifica Beach Blvd. Infrastructure Resiliency Project | Competitive | Stabilization and restoration | Infrastructure failure | Safety and security | null | 0 | 100 | 1.69 | 50,000,000 | 34,044,133 | 84,044,133 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2023-01-13T00:00:00.000Z | null | org:CITY OF PACIFICA |
EMN-2023-BR-002-0010 | 2,023 | Selected FY2020-2023, never obligated | NY | NEW YORK STATE DIVISION OF HOMELAND SECURITY & EMERGENCY SERVICES | NYC DEPARTMENT OF ENVIRONMENTAL | Local Government | ELMHURST | NYCDEP Central Harlem Cloudburst Flood Mitigation Project | Competitive | Flood control | Flooding | Safety and security | null | 0 | 50 | 3.93 | 50,000,000 | 54,812,814.9 | 104,812,814.9 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-01-24T00:00:00.000Z | null | org:NYC DEPARTMENT OF ENVIRONMENTAL |
EMS-2021-BR-044-0008 | 2,021 | Selected FY2020-2023, never obligated | WA | MILITARY DEPARTMENT, WASHINGTON STATE | ABERDEEN, CITY OF | Local Government | ABERDEEN | North Shore Levee | Competitive | Flood control | Flooding | Safety and security | No | 0 | 45 | 1.7 | 50,000,000 | 26,633,682.71 | 76,633,682.71 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2022-01-12T00:00:00.000Z | null | null |
EMP-2022-BR-005-0008 | 2,022 | Selected FY2020-2023, never obligated | PA | PENNSYLVANIA EMERGENCY MANAGEMENT AGENCY | OFFICE OF THE DIRECTOR OF FINANCE | Local Government | PHILADELPHIA | Phila. PWD Northeast Effluent Pump Station Mitigation (Over Match) | Competitive | Utility and infrastructure protection | Infrastructure failure | Food, water, shelter | null | 0 | 49 | 1.41 | 50,000,000 | 54,885,040 | 104,885,040 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2022-11-16T00:00:00.000Z | null | org:CITY OF PHILADELPHIA #K3LGS8BABNH9 |
EMN-2023-BR-002-0022 | 2,023 | Selected FY2020-2023, never obligated | NY | NEW YORK STATE DIVISION OF HOMELAND SECURITY & EMERGENCY SERVICES | NYC DEPARTMENT OF ENVIRONMENTAL | Local Government | ELMHURST | FY23 - NYCDEP East Elmhurst Cloudburst Flood Mitigation Project | Competitive | Flood control | Flooding | Safety and security | null | 0 | 42 | 1.44 | 50,000,000 | 29,464,944.4 | 79,464,944.4 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-01-24T00:00:00.000Z | null | org:NYC DEPARTMENT OF ENVIRONMENTAL |
EMF-2022-BR-044-0012 | 2,022 | Selected FY2020-2023, never obligated | CA | OFFICE OF EMERGENCY SERVICES | CITY OF RIVERBANK | Local Government | RIVERBANK | BRIC 2022 City of Riverbank Recycled Water and Water Supply Resiliency Project | Competitive | Flood control | Drought | Food, water, shelter | null | 0 | 100 | 5.92 | 50,000,000 | 41,018,097 | 91,018,097 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2023-01-04T00:00:00.000Z | null | org:CITY OF RIVERBANK |
EMF-2022-BR-044-0014 | 2,022 | Selected FY2020-2023, never obligated | CA | OFFICE OF EMERGENCY SERVICES | CITY & COUNTY OF SAN FRANCISCO | Local Government | SAN FRANCISCO | BRIC 2022 Port of San Francisco Downtown Coastal Resilience Project | Competitive | Flood control | Flooding | Safety and security | null | 0 | 34 | 2.75 | 50,000,000 | 57,679,764.32 | 107,679,764.32 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2023-01-12T00:00:00.000Z | null | org:CITY AND COUNTY OF SAN FRANCISCO #G2ACFK8T2MJ6 |
EMB-2022-BR-012-0013 | 2,022 | Selected FY2020-2023, never obligated | MA | EMERGENCY MANAGEMENT AGENCY MASSACHUSETTS | CITY OF CHELSEA | Local Government | CHELSEA | Cities of Chelsea & Everett - Island End River Coastal Flood Resilience Project | Competitive | Flood control | Flooding | Food, water, shelter | null | 0 | 18 | 38.57 | 49,999,000 | 22,175,710 | 72,174,710 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2022-12-05T00:00:00.000Z | null | org:CITY OF CHELSEA #T39VNB2VPJV5 |
EMF-2023-BR-004-0016 | 2,023 | Selected FY2020-2023, never obligated | CA | OFFICE OF EMERGENCY SERVICES | ALAMEDA, CITY OF | Local Government | ALAMEDA | BRIC 2023: Oakland Alameda Flood Adaptation and Community Benefits Project | Competitive | Flood control | Flooding | Transportation | null | 1 | 30 | 1.41 | 49,959,900 | 5,551,100 | 55,551,100 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-02-21T00:00:00.000Z | null | org:ALAMEDA CITY OF |
EMF-2023-BR-004-0007 | 2,023 | Selected FY2020-2023, never obligated | CA | OFFICE OF EMERGENCY SERVICES | STATE OF CALIFORNIA DEPARTMENT OF WATER RESOURCES | State Government | SACRAMENTO | Community Disaster Resilience Zone BRIC 2023 DWR Sutter Bypass East Levee Project | Competitive | Flood control | Flooding | Safety and security | null | 1 | 100 | 1.27 | 49,716,113.4 | 5,524,012.6 | 55,480,126 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-02-16T00:00:00.000Z | null | org:STATE OF CALIFORNIA DEPARTMENT OF WATER RESOURCES |
EMT-2023-BR-012-0049 | 2,023 | Selected FY2020-2023, never obligated | LA | HOMELAND SECURITY & EMERGENCY | HOMELAND SECURITY & EMERGENCY | State Government | BATON ROUGE | FY23 BRIC SMC | Management Costs | Management costs | null | null | null | null | null | null | 48,814,006 | 0 | 48,814,006 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-03-05T00:00:00.000Z | null | org:HOMELAND SECURITY AND EMERGENCY |
EMP-2023-BR-003-0030 | 2,023 | Selected FY2020-2023, never obligated | PA | PENNSYLVANIA EMERGENCY MANAGEMENT AGENCY | OFFICE OF THE DIRECTOR OF FINANCE | Local Government | PHILADELPHIA | PWD South 42nd Street Combined Wastewater and Stormwater Pump Station Resilience Project – FY23 BRIC | Competitive | Utility and infrastructure protection | Infrastructure failure | Food, water, shelter | null | 0 | 100 | 1.5 | 48,415,350.75 | 16,138,450.25 | 66,813,184 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2023-12-15T00:00:00.000Z | null | org:CITY OF PHILADELPHIA #K3LGS8BABNH9 |
EMB-2022-BR-013-0004 | 2,022 | Selected FY2020-2023, never obligated | CT | EMERGENCY SERVICES AND PUBLIC PROTECTION, DEPARTMENT OF | DEPT OF ENERGY & ENVIRONMENTAL PROTECTION | State Government | HARTFORD | Resilient Bridgeport Coastal Flood Defense System | Competitive | Flood control | Flooding | Transportation | null | 0 | 2 | 6.97 | 47,583,267.76 | 15,861,089.26 | 63,444,357.02 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2023-01-26T00:00:00.000Z | null | org:DEPT OF ENERGY AND ENVIRONMENTAL PROTECTION |
EMC-2023-BR-001-0051 | 2,023 | Selected FY2020-2023, never obligated | IL | ILLINOIS EMERGENCY MANAGEMENT AGENCY AND OFFICE OF HOMELAND SECURITY | ILLINOIS EMERGENCY MANAGEMENT AGENCY AND OFFICE OF HOMELAND SECURITY | State Government | SPRINGFIELD | BRIC 23 - State Management Cost | Management Costs | Management costs | null | null | null | null | null | null | 46,979,799.9 | 0 | 46,979,799.9 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-02-09T00:00:00.000Z | null | org:ILLINOIS EMERGENCY MANAGEMENT AGENCY AND OFFICE OF HOMELAND SECURITY |
EMF-2022-BR-044-0018 | 2,022 | Selected FY2020-2023, never obligated | CA | OFFICE OF EMERGENCY SERVICES | INLAND EMPIRE UTILITIES AGENCY | Special Governmental District | CHINO | BRIC 2022 Inland Empire Recycled Water Intertie and Aquifer Storage Project | Competitive | Utility and infrastructure protection | Drought | Food, water, shelter | null | 0 | 20 | 12.38 | 46,330,320 | 22,750,000 | 69,080,320 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2023-01-17T00:00:00.000Z | null | org:INLAND EMPIRE UTILITIES AGENCY |
EMS-2024-BR-002-0016 | 2,024 | Submitted in the FY2024 round, never selected | WA | MILITARY DEPARTMENT, WASHINGTON STATE | PORT TOWNSEND PORT OF | Special Governmental District | PORT TOWNSEND | Port Townsend Sea Level Rise Project | Competitive | Flood control | Flooding | Safety and security | null | 0 | 100 | 1.16 | 40,325,492.25 | 13,441,830.75 | 54,017,323 | 0 | 0 | Submitted to FEMA | null | 2025-03-14T00:00:00.000Z | null | org:PORT TOWNSEND PORT OF |
EMF-2023-BR-012-0031 | 2,023 | Selected FY2020-2023, never obligated | AS | OFFICE OF DISASTER ASSISTANCE AND PETROLEUM MANAGEMENT | OFFICE OF DISASTER ASSISTANCE AND PETROLEUM MANAGEMENT | State Government | PAGO PAGO | State Management Costs | Management Costs | Management costs | null | null | null | null | null | null | 39,698,933.91 | 0 | 39,698,933.91 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-02-28T00:00:00.000Z | null | org:OFFICE OF DISASTER ASSISTANCE AND PETROLEUM MANAGEMENT |
EMF-2021-BR-089-0015 | 2,021 | Selected FY2020-2023, never obligated | CA | OFFICE OF EMERGENCY SERVICES | COUNTY OF KERN | Local Government | BAKERSFIELD | BRIC 2021 Kern County Willow Springs Water Bank Drought Mitigation Project | Competitive | Other | Drought | Food, water, shelter | Yes | 0 | 32 | 4.41 | 39,496,828 | 16,545,969 | 56,042,797 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2022-01-19T00:00:00.000Z | null | org:COUNTY OF KERN #LYM1ZJ6B7BM3 |
EMS-2024-BR-007-0003 | 2,024 | Submitted in the FY2024 round, never selected | WA | LUMMI INDIAN BUSINESS COUNCIL | LUMMI INDIAN BUSINESS COUNCIL | Indian Tribal Government | BELLINGHAM | Slater Road Elevation and Bridge Project | Tribal Set-Aside | Utility and infrastructure protection | Flooding | Transportation | null | 0 | 6 | 1.06 | 38,364,741.75 | 12,788,247.25 | 51,152,989 | 0 | 0 | Submitted to FEMA | null | 2025-04-16T00:00:00.000Z | null | org:LUMMI INDIAN BUSINESS COUNCIL #TP4UB9N6TSA5 |
EMT-2023-BR-012-0011 | 2,023 | Selected FY2020-2023, never obligated | LA | HOMELAND SECURITY & EMERGENCY | CITY OF CENTRAL | Local Government | BATON ROUGE | City of Central Combined Drainage Project BRIC FY 2023 | Competitive | Flood control | Flooding | Safety and security | null | 0 | 12 | 2.15 | 37,431,816.75 | 12,477,272.25 | 52,285,710 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2024-02-15T00:00:00.000Z | null | org:CITY OF CENTRAL |
EMT-2022-BR-016-0002 | 2,022 | Selected FY2020-2023, never obligated | TX | TEXAS DIVISION OF EMERGENCY MANAGEMENT | TEXAS DIVISION OF EMERGENCY MANAGEMENT | State Government | AUSTIN | BRIC 2022 TDEM State Management Costs Subapplication | Management costs | Management costs | null | null | null | 0 | null | null | 36,949,398.27 | 0 | 36,949,398.27 | 0 | 0 | Submitted to FEMA | Identified for Further Review | 2023-01-11T00:00:00.000Z | null | org:TEXAS DIVISION OF EMERGENCY MANAGEMENT |
EMS-2024-BR-002-0010 | 2,024 | Submitted in the FY2024 round, never selected | WA | MILITARY DEPARTMENT, WASHINGTON STATE | CITY OF OTHELLO | Local Government | OTHELLO | City of Othello Aquifer Storage & Recovery Project | Competitive | Utility and infrastructure protection | Drought | Food, water, shelter | null | 0 | 100 | 8.08 | 36,190,674.8 | 12,063,558.27 | 48,254,233.07 | 0 | 0 | Submitted to FEMA | null | 2025-04-16T00:00:00.000Z | null | org:CITY OF OTHELLO |
Cancelled BRIC Projects: free sample (Tensorust LLC)
522 BRIC projects FEMA selected but never obligated, worth $2.43B in federal share, plus 1,051 FY2024-round applications ($4.32B) left unselected when the program was ended.
Headline: On April 4, 2025 FEMA announced it was ending the Building Resilient Infrastructure and Communities (BRIC) program and that FY2020 to FY2023 applications not yet obligated would be cancelled.
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 1,573 rows and is sold by Tensorust LLC: https://tensorust.com/datasets/bric-cancelled-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 | Total project cost (USD) |
|---|---|---|
| KY | 89 | 162,272,983 |
| WA | 76 | 653,464,538 |
| IL | 66 | 281,023,538 |
| PA | 60 | 269,073,446 |
| LA | 60 | 663,152,254 |
| TX | 56 | 423,389,261 |
| CA | 52 | 1,417,085,944 |
| NH | 50 | 52,038,516 |
| MD | 48 | 207,525,490 |
| OR | 46 | 509,528,865 |
| WI | 46 | 247,930,694 |
| SC | 45 | 113,124,646 |
| TOTAL | 1,573 | 10,010,487,528 |
Full table: summary_by_state.csv.
What the full file has
- 1,573 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 BRIC subapplication nationwide in the FEMA HMA dataset that matches the cancelled state (all states and territories). Built Nov 6, 2026 from OpenFEMA files fetched Nov 6, 2026.
Columns in the full file
| column | meaning |
|---|
Get the full file
| tier | price | includes |
|---|---|---|
| Ledger file | $495 | The full ledger (CSV and Parquet): every cancelled subapplication with project, hazard, BCR, federal share lost and ontology ID. |
| Ledger with updates | $1,200 a year | The ledger plus monthly re-runs for 12 months as FEMA updates statuses, flagging any project that moves to obligated or reinstated. |
| Firm license | $3,500 a year | Unlimited internal use across a consulting or engineering firm, state-by-state cuts, and the matched organization records from the ontology. |
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/bric-cancelled-projects/. All datasets: https://tensorust.com/datasets/
Method and limits
Sources
- OpenFEMA HmaSubapplications v2 and HmaSubapplicationsFinancialTransactions v1 (fetched Nov 6, 2026)
- FEMA BRIC program end announcement, April 4, 2025
- Tensorust Ontology organizations
License
The sample and summary here are free to view, analyze and cite with attribution to "Tensorust LLC, https://tensorust.com/datasets/bric-cancelled-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