saturn

This dataset captures 2016 US presidential election results at the county level, covering all 3,141 counties across 51 state/territory abbreviations. The most striking pattern is the strong Republican lean in the median county: the median GOP vote share is 66.5% versus 28.6% for Democrats, though total votes are heavily right-skewed — a small number of large urban counties (max 2.65 million votes) dominate raw vote totals while most counties are small. The per-point difference column shows values ranging widely (e.g., 63% margins appear in the top values), suggesting many counties were not competitive at all. Texas leads with 254 counties, making state-level aggregation worth examining to see which states drive the most records and volume.

This column contains formatted numeric values (integers with comma thousand-separators) stored as text, representing some kind of difference or delta metric — likely a count differential. Despite being classified as text, all 3,141 values are single tokens with a mean length of 4.9 characters and 99.2% 'all-caps' rate (a quirk of how digit strings are scored by the profiler). The dominant value '37,410' appears 29 times — roughly 7× more frequent than any other value — which is a notable outlier in the frequency distribution and may warrant investigation for data entry repetition or a sentinel/default value.

This column stores percentage values representing a per-point differential (likely a margin or rate metric), encoded as strings with a '%' suffix rather than as numeric floats — all 3,141 values are single uppercase tokens between 5 and 6 characters long. The allcaps_rate of 1.0 is a classifier artifact from the '%' symbol, not actual uppercase text. Surprisingly, 18.7% of rows (586) are duplicates, with '15.17%' alone appearing 31 times, suggesting repeated measurements or grouped records sharing the same differential. The column should be numeric but was ingested as text.

This column contains US county (and equivalent) names, covering all 3,141 US counties/county-equivalents with zero nulls — a near-complete national roster. The 41.2% duplicate rate (1,293 duplicates across 1,848 unique values) is expected and not anomalous: common names like 'Washington County' appear 30 times and 'Jefferson County' 25 times because the same county name exists across multiple states. Notably, 'Alaska' appears 29 times as a bare state name rather than a borough/census area name, which may signal inconsistent formatting for Alaska's county-equivalents. The word 'parish' (64 occurrences) and 'city' (43 occurrences) confirm Louisiana parishes and independent cities are included alongside standard counties.

This column represents the total vote count for records in the dataset, with values ranging from 64 to 2,652,072. The distribution is severely right-skewed (skew = 8.89, kurtosis = 136.17): the median is only 11,144 while the mean is 43,637, indicating a long upper tail driven by 442 outliers (14.1% of rows) far above the IQR ceiling of ~29,799. The spread (std = 114,568) is more than 2.5× the mean, confirming that a small number of items attract disproportionately large vote counts.

This column represents Democratic vote counts at the county level (n=3141 matches the number of U.S. counties), recording raw votes received per county in an election. The distribution is extremely right-skewed (skew=11.65, kurtosis=224.36): the median is only 3,194 but the mean is 20,734 and the max reaches 1,893,770, reflecting the enormous disparity between rural and urban counties. Nearly 15% of rows (468) are flagged as outliers, driven by large metropolitan counties. The min of 4 votes is plausible for the least-populated counties.

This column records the raw count of Republican (GOP) votes per geographic unit, almost certainly at the U.S. county level given n=3141 (matching the ~3,143 U.S. counties). The distribution is extremely right-skewed (skew=5.78, kurtosis=51.78): the median is only 7,268 yet the mean is 20,645 and the max reaches 620,285, reflecting the massive population disparity between rural and urban/suburban counties. A notable 12.5% of rows (394) are flagged as outliers, corresponding to the largest-population counties that dwarf the typical small rural county.

This column is almost certainly a row index or sequential integer ID, running from 0 to 3140 with every value unique and no nulls. The distribution is perfectly uniform: mean equals median at 1570.0, skew is exactly 0.0, kurtosis is –1.2 (consistent with a flat/uniform distribution), and there are zero outliers. The single surprising note is that zero_rate is non-zero (one zero present), which is simply the first index value (0) rather than a missing-data signal.

This column contains US county-level FIPS codes, 5-digit numeric identifiers where the first 2 digits encode the state and the last 3 encode the county. The column is perfectly unique across all 3,141 rows with zero nulls — matching exactly the canonical count of US counties and county-equivalents, confirming this is a complete national county dataset. The near-zero skew (−0.08) and platykurtic distribution (kurtosis −1.10) indicate values are spread broadly and fairly uniformly across the numeric range, which is expected since FIPS codes are administratively assigned rather than naturally distributed. Despite being stored as numeric, FIPS codes are identifiers and must not be treated as continuous values.

This column almost certainly represents the Democratic party vote share (proportion) at the county level — the 3,141 rows match the number of U.S. counties exactly, and values are bounded between 0.031 and 0.928 with a mean of 0.318 and median of 0.286, consistent with Democratic vote shares skewing below 50% across most counties. The positive skew (0.942) reflects a long right tail of heavily Democratic urban counties pulling the mean above the median, while the bulk of counties are Republican-leaning. Near-uniqueness (3,112 of 3,141 values distinct) and zero null rate confirm clean, continuous proportional data with no structural issues.

This column represents the Republican (GOP) vote share as a proportion (0–1 scale), almost certainly at the U.S. county level given n=3141, which closely matches the total number of U.S. counties. The distribution is left-skewed (skew = -0.82) with a median of 0.665, indicating most counties lean Republican — a well-known feature of county-level electoral geography where rural counties are numerous and heavily GOP. The range (0.041 to 0.953) is plausible for partisan vote shares, and 63 outliers (2%) likely correspond to heavily urban or heavily rural counties at the extremes.

This column contains US state abbreviations covering all 51 values (50 states + DC), with zero nulls across 3,141 rows — consistent with a county-level dataset where n≈3,141 matches the known US county count. TX dominates with 254 rows (8.09% of records), aligning exactly with Texas's 254 counties, confirming county-level granularity. The entropy ratio of 0.93 indicates near-uniform distribution across states, which is expected given that state representation is proportional to county count rather than population.