# The Texas Water Damage Ledger — data dictionary This dictionary covers `tx-county-flood-record.csv` and `tx-county-claims-by-year.csv`. Compilation © Eldhurst LLC, licensed under [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/). The licence covers Eldhurst LLC's compilation only. The underlying FEMA, NOAA, EPA, and US Census federal records are public domain; Eldhurst LLC asserts no rights over those underlying records. Suppressed values are blank, never zero. A zero appears only when the county page publishes a measured zero. ### `county_name` - Measure: Published county name. - Units: text - Window: Not time-varying. - Suppression: None. - Source: US Census county dimension. ### `county_fips` - Measure: Five-digit county FIPS code; retain leading zeroes. - Units: identifier - Window: Not time-varying. - Suppression: None. - Source: US Census county dimension. ### `whole_record_as_of` - Measure: Last complete month represented by the whole NFIP record. - Units: YYYY-MM - Window: Whole NFIP record. - Suppression: Blank when the whole-record block is suppressed. - Source: FEMA NFIP Redacted Claims v2. ### `whole_record_window` - Measure: Registry label for the unbounded NFIP record. - Units: text - Window: First through last paid loss year. - Suppression: Blank when fewer than 50 paid claims. - Source: FEMA NFIP Redacted Claims v2. ### `whole_record_claims` - Measure: NFIP claims with a recorded building payment greater than zero. - Units: claims - Window: Whole NFIP record. - Suppression: Blank when fewer than 50 paid claims. - Source: FEMA NFIP Redacted Claims v2. ### `whole_record_total_paid_usd` - Measure: Sum of recorded NFIP building payments. - Units: nominal USD - Window: Whole NFIP record. - Suppression: Blank when fewer than 50 paid claims. - Source: FEMA NFIP Redacted Claims v2. ### `whole_record_nominal` - Measure: Whether the whole-record dollar total is nominal. - Units: boolean - Window: Whole NFIP record. - Suppression: Blank when the whole-record block is suppressed. - Source: Countyguard metric registry. ### `whole_record_dollar_note` - Measure: Inflation treatment for the whole-record dollar total. - Units: text - Window: Whole NFIP record. - Suppression: Blank when the whole-record block is suppressed. - Source: Countyguard metric registry. ### `whole_record_first_year` - Measure: First loss year with a paid NFIP building claim. - Units: year - Window: Whole NFIP record. - Suppression: Blank when fewer than 50 paid claims. - Source: FEMA NFIP Redacted Claims v2. ### `whole_record_last_year` - Measure: Last loss year with a paid NFIP building claim. - Units: year - Window: Whole NFIP record. - Suppression: Blank when fewer than 50 paid claims. - Source: FEMA NFIP Redacted Claims v2. ### `whole_record_peak_year` - Measure: Loss year holding the largest share of whole-record paid claims. - Units: year - Window: Whole NFIP record. - Suppression: Blank when the whole record is suppressed or peak share is below 15%. - Source: FEMA NFIP Redacted Claims v2. ### `whole_record_peak_share` - Measure: Largest single-year share of whole-record paid claims. - Units: proportion (0-1) - Window: Whole NFIP record. - Suppression: Blank when the whole record is suppressed or share is below 15%. - Source: FEMA NFIP Redacted Claims v2. ### `policies_context_as_of` - Measure: Snapshot date for the NFIP policy-stock comparison. - Units: date or vintage - Window: Snapshot. - Suppression: Blank with the policy-rate block. - Source: FEMA NFIP Redacted Policies v2. ### `policies_per_1000_homes` - Measure: NFIP policies in force per 1,000 ACS housing units. - Units: policies per 1,000 homes - Window: Policy snapshot divided by ACS housing stock. - Suppression: Blank below 10 policies, below 500 homes, or when unrankable. - Source: FEMA NFIP Redacted Policies v2 and US Census ACS 5-year. ### `policies_state_rank` - Measure: Competition rank among configured-state counties by policies per 1,000 homes; 1 is highest. - Units: rank - Window: Same snapshot/window as policies_per_1000_homes. - Suppression: Blank whenever the policy rate is suppressed. - Source: FEMA NFIP Redacted Policies v2 and US Census ACS 5-year. ### `policies_ranked_counties` - Measure: Number of real counties in the configured-state policy-rate ranking population. - Units: counties - Window: Same snapshot/window as policies_per_1000_homes. - Suppression: Blank whenever the policy rate is suppressed. - Source: FEMA NFIP Redacted Policies v2 and US Census ACS 5-year. ### `claims_context_as_of` - Measure: Last complete claims month for the mature-year comparison. - Units: YYYY-MM - Window: Claims comparison window. - Suppression: Blank with the claims-rate block. - Source: FEMA NFIP Redacted Claims v2. ### `paid_claims_per_1000_homes` - Measure: Paid NFIP building claims per 1,000 ACS housing units. - Units: claims per 1,000 homes - Window: Complete mature loss years shown in the paired window columns. - Suppression: Blank below the chart floor, below 500 homes, or when unrankable. - Source: FEMA NFIP Redacted Claims v2 and US Census ACS 5-year. ### `claims_state_rank` - Measure: Competition rank among configured-state counties by paid claims per 1,000 homes; 1 is highest. - Units: rank - Window: Claims window in this row. - Suppression: Blank whenever the claims rate is suppressed. - Source: FEMA NFIP Redacted Claims v2 and US Census ACS 5-year. ### `claims_ranked_counties` - Measure: Number of real counties in the configured-state claims-rate ranking population. - Units: counties - Window: Claims window in this row. - Suppression: Blank whenever the claims rate is suppressed. - Source: FEMA NFIP Redacted Claims v2 and US Census ACS 5-year. ### `claims_window_from_year` - Measure: First loss year in the normalized claims comparison. - Units: year - Window: Inclusive. - Suppression: Blank whenever the claims rate is suppressed. - Source: Countyguard metric registry. ### `claims_window_through_year` - Measure: Last mature loss year in the normalized claims comparison. - Units: year - Window: Inclusive; excludes still-developing loss years. - Suppression: Blank whenever the claims rate is suppressed. - Source: Countyguard metric registry. ### `source_names` - Measure: JSON array of source dataset names. - Units: text - Window: Sources supporting the county page and compilation. - Suppression: None. - Source: Countyguard source registry. ### `source_urls` - Measure: JSON array of public source URLs in source_names order. - Units: URLs - Window: Sources supporting the county page and compilation. - Suppression: None. - Source: Countyguard source registry. ### `source_as_of` - Measure: JSON object mapping source keys to coverage dates or snapshot vintages. - Units: dates/vintages - Window: Per-source. - Suppression: Empty string only when the source carries no date. - Source: Cube provenance registry. ### `year` - Measure: NFIP claim loss year. - Units: year - Window: One loss year per row. - Suppression: None. - Source: FEMA NFIP Redacted Claims v2. ### `claims` - Measure: NFIP claims with a recorded building payment in the loss year. - Units: claims - Window: The row's loss year. - Suppression: A published zero is 0; an absent county-year is represented by no row. - Source: FEMA NFIP Redacted Claims v2. ### `median_paid_usd` - Measure: Median recorded NFIP building payment for the loss year. - Units: nominal USD - Window: The row's loss year. - Suppression: Blank below 20 paid claims, for current YTD, or outside the recent table window. - Source: FEMA NFIP Redacted Claims v2. ### `provisional` - Measure: True when the complete loss year is still developing. - Units: boolean - Window: The row's loss year. - Suppression: Blank when false. - Source: FEMA NFIP Redacted Claims v2 and Countyguard maturity registry. ### `year_to_date` - Measure: True when the row is the partial current loss year. - Units: boolean - Window: Current loss year through the claims source as-of month. - Suppression: Blank when false. - Source: FEMA NFIP Redacted Claims v2.