State

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 and link Additional Type to a Place Kind term in 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 · one record
Cities	Linked records	Links every city in this state.	→ City · several records
Additional Type	Linked records	Links the term that says what kind of division this row is.	→ Classification Term · several records
Address 2	Linked records	No description in Airtable.	→ Address · several records
Tags	Linked records	Links optional labels from the shared Core Tags catalog.	→ 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

COUNTA({Cities})

V3 · Reference status

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

V3 · Next action

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

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

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 · All entities