# Dental office establishments by state and employment size

Select the 2023 CBP state bulk file, retain LFO '-' (all legal forms), the exact industry code and the 50 states plus District of Columbia. Do not add legal-form subgroups or industry children to their totals. Join state labels using Census FIPS codes preserved as two-character strings. Sum EST across the 51 rows. Divide each row's EST by that sum and multiply by 100 for geographic share. Sort by EST descending, then FIPS ascending to give ties a stable display order. For the under-20 count, add N<5, N5_9 and N10_19 only when all three are numeric. Otherwise retain a null result and the source N marker. Divide a known under-20 count by the same row's EST for its percentage. Round displayed percentages to two decimals; retain integer counts for reconciliation.

The observation year is 2023, not the preparation year of 2026. Counts represent employer establishments in the chosen industry, not unique companies or contacts. Nonemployer businesses are outside this extract's population. Employment-size categories describe local establishments rather than corporate parents. Geographic shares use only the 50 states and DC, excluding territories. A blank derived size value means unavailable, not zero. This is descriptive analysis, not a forecast, a prospect list or a claim about purchasing intent.

Source archive: https://www2.census.gov/programs-surveys/cbp/datasets/2023/cbp23st.zip

Reproduce from the retained 255 source rows: python3 tools/recompute_research_datasets.py --check

Input archive, extracted file and selected-row checksums are recorded in provenance.json and research-data/source.json. This analysis and prose were prepared with AI assistance. Independent review is pending; these are unpublished branch drafts. Owner: Verum/Rome. Recheck on the next data-vintage update or source correction; do not silently replace the 2023 baseline.