# State

A first-level administrative division of a country, with its ISO code.

Source table: States in Core Record Types (`schema:AdministrativeArea`). A State is a state, province or region: the first-level division of a country, whatever that country calls it. The catalog holds the 50 US states, D.C., five US territories and the 27 Brazilian federative units.

## Rules and relationships

Enter Name and Abbreviation (the part after the country in the ISO 3166-2 code), link one [Country](/systems/core/country) and link Additional Type to a Place Kind term in [Classification Term](/systems/core/classification-term), such as State, District or Territory. Cities lists the cities in the state. Address 2 is the live link to addresses; Address, Companies - OLD and Compliance Global are legacy text columns whose descriptions still promise links. The primary field is ID, an auto number.

## Lifecycle and checks

Active marks a state available for current operations. Record health is the share of four fields that are filled; Health check names the missing ones. V3 · Reference status and V3 · Next action give the next fix; V3 · City count counts linked cities. The two step views (Step 2: Entities · V1 and Step 3: Changelog Information · V1) have no filters and no Step 1.

## Source fields

Names, types, options and links are those configured in Core Record Types. The meaning is the first line of each field description in Airtable. Options describe configuration; they do not prove a rule is enforced elsewhere.

### Recorded values

| Field | Type | Meaning | Options, link or calculation |
| --- | --- | --- | --- |
| Companies - OLD | Text | Links the companies legally formed in this state. | Entered value. |
| Compliance Global | Text | Links the compliance requirements whose jurisdiction is this state. | Entered value. |
| Name | Text | Stores the plain-language name of the state, province, or region. | Entered value. |
| Abbreviation | Text | Stores the official short code of the state, the part after the country in its ISO 3166-2 code. | Entered value. |
| Active | Checkbox | Stores whether this state is available for current operations. | Entered value. |
| Address | Text | No description in Airtable. | Entered value. |

### Links

| Field | Type | Meaning | Options, link or calculation |
| --- | --- | --- | --- |
| Country | Linked records | Links the country this state is in. | → [Country](/systems/core/country) · one record |
| Cities | Linked records | Links every city in this state. | → [City](/systems/core/city) · several records |
| Additional Type | Linked records | Links the term that says what kind of division this row is. | → [Classification Term](/systems/core/classification-term) · several records |
| Address 2 | Linked records | No description in Airtable. | → [Address](/systems/core/address) · several records |
| Tags | Linked records | Links optional labels from the shared Core Tags catalog. | → [Tag](/systems/core/tag) · several records |

### Calculated

| Field | Type | Meaning | Options, link or calculation |
| --- | --- | --- | --- |
| Country Name [CT] | Lookup | Shows the linked country's name so the state reads on its own. | Lookup of Name through Country |
| V3 · City count | Formula | Counts the cities linked to this state. | Formula below. |
| V3 · Reference status | Formula | Shows whether this state row is complete enough to be used. | Formula below. |
| V3 · Next action | Formula | Shows the next thing to fix on this state row. | Formula below. |
| Record health | Formula | Shows how complete this state's core data is, as the share of four key fields that are filled. | Formula below. |
| Health check | Formula | Says in words what is missing from this state's core data, or shows ✅ when nothing is. | Formula below. |

### Generated by Airtable

| Field | Type | Meaning | Options, link or calculation |
| --- | --- | --- | --- |
| ID | Auto number | Shows the running number Airtable gave this state when the row was created. | Airtable system value. |
| Created By | Created by | Shows who created this row in Airtable. | Airtable system value. |
| Created | Created time | Shows when this row was created in Airtable. | Airtable system value. |
| Last Modified By | Last modified by | Shows who last changed any value in this row. | Airtable system value. |
| Last Modified | Last modified time | Shows when any value in this row last changed. | Airtable system value. |

## Current formulas

Field IDs are rendered as current field names.

### V3 · City count

```text
COUNTA({Cities})
```

### V3 · Reference status

```text
IF({Name} = "", "Needs state name", IF({Abbreviation} = "", "Needs abbreviation", IF({Country} = "", "Needs country", IF({Active}, "Ready", "Inactive"))))
```

### V3 · Next action

```text
IF({Name} = "", "Enter state name", IF({Abbreviation} = "", "Enter abbreviation", IF({Country} = "", "Link country", IF(NOT({Active}), "Review inactive state", IF({V3 · City count} = 0, "Review city coverage", "Ready")))))
```

### Record health

```text
SUM(
IF({Name},1,0),
IF({Abbreviation},1,0),
IF(COUNTA({Country})>0,1,0),
IF(COUNTA({Additional Type})>0,1,0)
)/4
```

### Health check

```text
IF(
  AND(
    {Name},
    {Abbreviation},
    COUNTA({Country})>0,
    COUNTA({Additional Type})>0
  ),
  "✅",
  "Missing: " & REGEX_REPLACE(
    CONCATENATE(
      IF({Name}, "", "Name, "),
      IF({Abbreviation}, "", "Abbreviation, "),
      IF(COUNTA({Country})>0, "", "Country, "),
      IF(COUNTA({Additional Type})>0, "", "Additional Type, ")
    ),
    ", $", ""
  )
)
```

## Example (fictitious)

Texas has Abbreviation TX, Country United States, Additional Type State and Active checked. V3 · Reference status reads Ready; V3 · Next action asks to review city coverage until a city is linked.

## Use by other systems

No other system mirrors this table.

[Correct shared records](/systems/core/maintain-shared-records) · [All entities](/systems/core/entities)