saturn

This dataset is a US county-level geographic reference file containing 3,234 county (and county-equivalent) records across 56 state FIPS codes, with spatial attributes, area measurements, and metropolitan area classifications. The most notable pattern is that roughly 41% of counties share a name with at least one other county — 'Washington' alone appears 31 times — reflecting the historic reuse of patriotic and presidential names across states. Two numeric columns, ALAND (land area) and AWATER (water area), show extreme right skew with over 11–14% outliers, meaning a small number of counties are vastly larger or wetter than the median, which warrants attention in any area-weighted analysis. Additionally, over 40% of counties have no CBSAFP code (no core-based statistical area assignment), indicating a large rural, non-metro population of counties that could easily be overlooked in urban-focused analyses.

COUNTYNS is a FIPS-style county National Standard (ANSI/GNIS) code — an 8-character, zero-padded numeric identifier assigned by the U.S. Geological Survey to uniquely identify counties. Every one of the 3,234 rows carries a distinct value (duplicate_rate 0.0, n_unique 3,234) with no nulls, and all values are exactly 8 characters long (len_min = len_max = 8), consistent with the fixed-width GNIS format. The perfect uniqueness and fixed length make this a reliable surrogate key for county-level joins to official geographic reference tables.

GEOID is a US Census geographic identifier column containing 5-digit FIPS county codes (e.g., '06091', '48327'), where the first two digits encode state and the last three encode county. Every value is exactly 5 characters long (len_min=5, len_max=5, len_mean=5.0), perfectly unique across all 3,234 rows with zero nulls or duplicates, confirming this is a primary key for county-level geographic records. The allcaps_rate of 1.0 is a classifier artifact — these are numeric strings, not alphabetic text. The vocab_size of 3,234 matching n_unique=3,234 means this dataset likely covers a near-complete set of US counties (there are ~3,243 counties/equivalents in the US).

INTPTLAT is the internal point latitude coordinate for geographic entities (a standard Census Bureau field name), stored as a fixed-width text string rather than a numeric type. Every one of the 3,234 rows is unique, all values are exactly 11 characters long (e.g. '+41.9158651'), and the duplicate rate is 0.0, confirming these are precise geographic identifiers. The surprising signal is that a coordinate stored as text with 'allcaps' and 'one_word' alerts was profiled as a string column — it should be numeric but the leading '+' sign likely forced text treatment.

INTPTLON is the internal point longitude field, a standard Census Bureau coordinate column storing the longitude of a representative point within each geographic entity. Every one of the 3,234 rows is unique, all values are exactly 12 characters long (mean, median, min, and max all equal 12), and the duplicate rate is 0.0 — consistent with precise decimal-degree coordinates stored as fixed-format strings. All values appear to be negative (Western Hemisphere), ranging roughly from -065 to -123 degrees, aligning with US continental and territory coverage.

This column contains names of U.S. counties or county-equivalent administrative divisions, dominated by patriotic/presidential surnames (Washington, Jefferson, Franklin, Lincoln, Jackson, Madison) and geographic terms (Union, Lake, Montgomery, Marion). The duplicate rate of 40.5% (1,311 out of 3,234 rows) is expected given that common county names repeat across states, but analysts should note this column alone cannot serve as a unique identifier. The vocabulary of 1,958 tokens across 3,234 rows and a median length of 7 characters confirms these are short, single-word labels in most cases (93.1% one-word rate).

NAMELSAD is a US Census Legal/Statistical Area Description field containing the full human-readable name of county-equivalent geographic units (e.g., 'Washington County', 'Jefferson Parish'). The word 'county' appears in 3,007 of 3,234 rows, with 'municipio' (78) and 'parish' (64) indicating Puerto Rico and Louisiana records respectively. The 39.1% duplicate rate (1,265 duplicates across 1,969 unique values) is fully expected — common county names like 'Washington County' (30 occurrences) repeat across different US states. The multi-word structure (mean 2.08 words) and short length (median 14 chars) are consistent with standardized geographic labels.

ALAND is a US Census land area field (measured in square metres), representing the land area of each geographic entity — likely counties or census tracts given n=3,234. The distribution is extremely right-skewed (skew=27.13, kurtosis=976.66): while the median is ~1.56 billion m², the max reaches 377 billion m², roughly 241× the median, indicating a small number of very large geographic units (e.g., western US counties). 362 values (11.2%) are flagged as outliers, consistent with the well-known size disparity between densely subdivided eastern counties and sprawling western ones.

AWATER is almost certainly a US Census TIGER/Line water area field, representing the total water surface area (in square meters) of a geographic unit such as a county or census tract. All 3,234 rows are unique and non-null, consistent with one record per geographic entity. The distribution is extremely right-skewed (skew 13.33, kurtosis 215.85): the median is ~19.5 million m² while the mean balloons to ~220 million m², and the maximum reaches ~26 billion m² — about 14× the mean — with 456 outliers (14.1% of rows) driven by large water-heavy units like coastal counties or Great Lakes-adjacent areas. Only 1 record has a zero value, which is plausible for fully land-locked units.

CBSAFP is a Core Based Statistical Area (CBSA) FIPS code, a U.S. Census geographic identifier linking records to metropolitan or micropolitan statistical areas. With 939 unique codes across 3,234 rows, the distribution is notably flat (entropy_ratio 0.94), meaning records are spread thinly across many areas rather than concentrated. The null rate of 40.75% is a significant concern — likely representing locations outside any defined CBSA (rural areas), which is a meaningful geographic signal rather than simple missingness. The most frequent value '41980' (San Jose-Sunnyvale-Santa Clara, CA) appears only 40 times (~2.1%), confirming no single area dominates.

CLASSFP is the FIPS functional classification code for geographic/administrative entities, almost certainly places in a US Census dataset. The distribution is severely imbalanced: 'H1' (incorporated places) accounts for 96.3% of the 3,234 rows, with the remaining four codes (C7, H6, H4, H5) collectively covering only 119 records. The entropy ratio of 0.128 confirms near-minimal informational content, meaning this column carries little discriminatory power as a feature in its current form.

FUNCSTAT is a U.S. Census functional status code, classifying geographic or administrative entities by their operational state (e.g., 'A' = active, 'F' = fictitious, 'C' = consolidated). The distribution is severely imbalanced: 'A' accounts for 96.35% of the 3,234 records, while the remaining 6 categories together cover only 118 rows — with 'G' appearing just once. Entropy ratio of 0.107 confirms near-minimal informational diversity. Minority classes may warrant special handling but will be extremely difficult to model as targets.

MTFCC is a MAF/TIGER Feature Class Code, a U.S. Census Bureau classification code for geographic features. Every single one of the 3,234 rows carries the identical value 'G4020' (which corresponds to a local road/street segment), with zero nulls and an entropy of 0.0 — this column is entirely constant across the dataset. It carries no discriminatory signal whatsoever.

This column classifies the geometric representation type of spatial features, distinguishing between 'Polygon' and 'MultiPolygon' geometries across 3,234 records. The severe class imbalance is the standout signal: 'Polygon' dominates at 98.36% (3,181 records), leaving 'MultiPolygon' as a rare minority at only 53 occurrences (1.64%). The near-zero entropy (0.121) confirms this column carries almost no information variance, which limits its predictive utility.

CSAFP is likely a Combined Statistical Area FIPS (or similar geographic area code), given the numeric-string values in the hundreds range and cardinality of 175 — consistent with a US metropolitan/micropolitan area classification code. The most alarming signal is a 61.16% null rate, meaning nearly two-thirds of the 3,234 rows carry no value, which likely indicates records that do not belong to any defined statistical area. The distribution is nearly flat across all 175 codes (entropy ratio 0.936, top value '490' appears only 3.8% of the time), suggesting no single area dominates.

COUNTYFP is a FIPS county code — a standardized 3-digit zero-padded numeric string used in US geographic identifiers. With 330 unique values across 3,234 rows and a high entropy ratio of 0.85, codes are broadly distributed with near-uniform frequency: the most common value ('003') appears only 50 times (~1.5% top_rate). The sequential odd-number pattern in top values (001, 003, 005, 007…) is characteristic of FIPS county numbering conventions, confirming this is a geographic lookup key rather than a raw feature.

LSAD (Legal/Statistical Area Description) is a Census Bureau code that classifies geographic entities by type — values like '06' (county), '13', '15', '25' are standard LSAD codes. The distribution is severely dominated by code '06', which accounts for 3,007 of 3,234 rows (92.98%), indicating this dataset is overwhelmingly composed of one entity type (most likely counties). With only 11 unique values and near-zero entropy ratio (0.156), this column carries very little discriminative information despite being semantically meaningful.

STATEFP is the U.S. Census Bureau FIPS state code, a two-digit numeric string identifying each U.S. state or territory. With exactly 56 unique values and 3,234 rows it likely represents one record per county or similar sub-state geographic unit. The top value '48' (Texas, 254 rows) alone accounts for 7.85% of all records — consistent with Texas having the most counties of any U.S. state — while values like '13' (Georgia, 159) and '51' (Virginia, 133) also rank high, reflecting those states' large county counts. The entropy ratio of 0.919 indicates a fairly even spread across states despite Texas's dominance.