Datasets:

tensorust
/

caf-buildout-shortfall-sample

state stringlengths 2 2	fund stringclasses 5 values	study_area_code int64 105k 649k	holding_company stringlengths 15 63	carrier stringlengths 11 45	latest_filing_year int64 2.03k 2.03k	obligated_speed_tier stringclasses 3 values	milestone_percentage stringclasses 4 values	milestone_locations_required int64 324 37.5k	locations_deployed_cumulative int64 2 28.7k	shortfall_locations int64 322 20.5k	pct_of_milestone float64 0.01 0.86	support_disbursed_cumulative float64 9.65M 141M	full_obligation_est float64 463 62.5k	support_per_obligated_location float64 550 20.9k	support_at_shortfall float64 2.89M 16.9M	in_shortfall bool 1 class	hc_shortfall_locations int64 322 50.9k	hc_support_at_shortfall float64 2.97M 37.7M	hc_study_areas int64 1 24	hc_rdof_cafauc_money_at_risk float64 1.97M 20.6M ⌀	hc_withhold_2027_pace float64 0 12.2M ⌀	ontology_oid stringlengths 8 33 ⌀	source stringlengths 72 72
LA	RDOF	279,057	CONEXON CONNECT, LLC	Conexon Connect, LLC	2,025	Total 1 Gbps/500 Mbps	60%	30,953	10,487	20,466	0.3388	42,721,838.7	51,588	828.13	16,948,505	true	50,867	33,824,156	10	20,619,064	12,186,116	org:CONEXON CONNECT	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=279057
WI	ACAM	330,963	TELEPHONE AND DATA SYSTEMS, INC.	UTELCO, INC	2,025	Total 25 Mbps/3 Mbps	70%	20,658	17,253	3,405	0.8352	140,943,525	29,511	4,775.9	16,261,927	true	9,111	37,729,155	24	null	null	org:TELEPHONE AND DATA SYSTEMS	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=330963
PA	RDOF	170,176	WINDSTREAM HOLDINGS II, LLC	WINDSTREAM PA	2,025	Total 1 Gbps/500 Mbps	40%	21,534	10,867	10,667	0.5046	59,495,885.28	53,835	1,105.15	11,788,662	true	27,981	30,840,340	21	null	null	org:WINDSTREAM HOLDINGS II	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=170176
MI	ACAM	310,732	LICT CORPORATION	UPPER PENINSULA TEL	2,025	Total 25 Mbps/3 Mbps	70%	2,522	1,811	711	0.7181	58,809,314.16	3,603	16,322.97	11,605,629	true	711	11,605,629	8	null	null	org:LICT	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=310732
MI	ACAM	310,713	HIAWATHA COMMUNICATIONS, INC.	HIAWATHA TEL CO	2,025	Total 25 Mbps/3 Mbps	70%	2,669	2,102	567	0.7876	67,657,521.72	3,813	17,744.57	10,061,173	true	567	10,061,173	1	null	null	null	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=310713
VI	USVI Fixed	649,007	LIBERTY LATIN AMERICA LTD.	Broadband VI, LLC	2,025	Total 1 Gbps/500 Mbps	60%	27,623	17,907	9,716	0.6483	37,653,687.89	46,038	817.88	7,946,492	true	9,716	7,946,492	2	null	null	org:LIBERTY LATIN AMERICA	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=649007
IA	ACAM	351,291	SCHALLER TELEPHONE COMPANY	SCHALLER TEL CO	2,025	Total 25 Mbps/3 Mbps	70%	324	2	322	0.0062	9,653,512.56	463	20,856.35	6,715,746	true	322	6,715,746	1	null	null	org:SCHALLER TELEPHONE	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=351291
VA	CAF II Auc	199,024	RIVERSTREET MANAGEMENT SERVICES, LLC D/B/A RIVERSTREET NETWORKS	RIVERSTREET COMMUNICATIONS OF VIRGINIA, INC.	2,025	Total 1 Gbps/500 Mbps	100%	9,761	7,212	2,549	0.7389	20,137,686.78	9,761	2,063.08	5,258,781	true	7,502	9,310,378	8	10,633,809	1,928,937	null	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=199024
TN	ACAM	290,578	TELEPHONE AND DATA SYSTEMS, INC.	TELLICO TEL CO	2,025	Total 25 Mbps/3 Mbps	70%	9,622	8,278	1,344	0.8603	50,968,781.4	13,746	3,707.98	4,983,520	true	9,111	37,729,155	24	null	null	org:TELEPHONE AND DATA SYSTEMS	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=290578
AR	RDOF	401,691	WINDSTREAM HOLDINGS II, LLC	WINDSTREAM AR	2,025	Total 100 Mbps/20 Mbps	40%	7,667	3,551	4,116	0.4632	22,770,983.52	19,168	1,188	4,889,807	true	27,981	30,840,340	21	null	null	org:WINDSTREAM HOLDINGS II	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=401691
FL	RDOF	219,024	CONEXON CONNECT, LLC	Conexon Connect, LLC	2,025	Total 1 Gbps/500 Mbps	60%	37,488	28,700	8,788	0.7656	34,376,687.5	62,480	550.2	4,835,185	true	50,867	33,824,156	10	20,619,064	12,186,116	org:CONEXON CONNECT	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=219024
OK	ACAM	431,984	HILLIARY ACQUISITION CORP 2016 LLC	OKLAHOMA COMM SYSTEM	2,025	Total 25 Mbps/3 Mbps	70%	3,668	2,763	905	0.7533	27,830,874.6	5,240	5,311.24	4,806,668	true	1,038	7,468,845	3	null	null	null	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=431984
MO	ACAM II	421,882	CABLE ONE, INC.	FIDELITY TEL CO	2,025	Total 25 Mbps/3 Mbps	70%	5,163	3,694	1,469	0.7155	23,940,660.6	7,376	3,245.88	4,768,193	true	1,469	4,768,193	5	null	null	org:CABLE ONE	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=421882
NE	ACAM	371,524	AMERICAN BROADBAND HOLDING COMPANY	BLAIR TEL CO	2,025	Total 25 Mbps/3 Mbps	70%	1,583	1,221	362	0.7713	25,505,565.36	2,261	11,278.52	4,082,824	true	1,417	7,283,518	6	null	null	null	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=371524
AL	ACAM	250,314	TELEPHONE AND DATA SYSTEMS, INC.	PEOPLES TELEPHONE COMPANY, INC.	2,025	Total 25 Mbps/3 Mbps	70%	6,766	5,400	1,366	0.7981	28,665,798.24	9,666	2,965.72	4,051,173	true	9,111	37,729,155	24	null	null	org:TELEPHONE AND DATA SYSTEMS	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=250314
MD	RDOF	189,039	TALKIE COMMUNICATIONS, INC.	Talkie Communications, Inc.	2,025	Total 1 Gbps/500 Mbps	40%	12,474	5,912	6,562	0.4739	17,456,932.8	31,185	559.79	3,673,317	true	9,422	5,637,345	2	null	null	org:TALKIE COMMUNICATIONS	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=189039
AL	RDOF	250,302	WINDSTREAM HOLDINGS II, LLC	WINDSTREAM AL	2,025	Total 1 Gbps/500 Mbps	40%	4,077	926	3,151	0.2271	11,367,086.4	10,193	1,115.24	3,514,122	true	27,981	30,840,340	21	null	null	org:WINDSTREAM HOLDINGS II	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=250302
GA	RDOF	223,037	WINDSTREAM HOLDINGS II, LLC	WINDSTREAM GA COMM	2,025	Total 1 Gbps/500 Mbps	40%	19,279	16,414	2,865	0.8514	58,934,193.6	48,198	1,222.76	3,503,220	true	27,981	30,840,340	21	null	null	org:WINDSTREAM HOLDINGS II	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=223037
MI	ACAM	310,685	TELEPHONE AND DATA SYSTEMS, INC.	CHATHAM TEL CO - MI	2,025	Total 25 Mbps/3 Mbps	70%	3,478	2,816	662	0.8097	25,845,921.24	4,969	5,201.88	3,443,646	true	9,111	37,729,155	24	null	null	org:TELEPHONE AND DATA SYSTEMS	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=310685
AL	RDOF	259,050	POINT BROADBAND FIBER HOLDING, LLC	Point Broadband Fiber Holding, LLC	2,025	Total 1 Gbps/500 Mbps	60%	11,038	8,004	3,034	0.7251	20,831,796.14	18,397	1,132.37	3,435,604	true	4,756	5,204,631	7	3,871,420	0	org:POINT BROADBAND FIBER HOLDING	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=259050
ME	RDOF	105,111	CONSOLIDATED COMMUNICATIONS, LLC	NORTHERN NEW ENGLAND TELEPHONE OPERATIONS LLC	2,025	Total 1 Gbps/500 Mbps	60%	6,907	3,763	3,144	0.5448	12,426,870.72	11,512	1,079.5	3,393,955	true	3,492	3,606,581	14	1,968,329	964,229	org:CONSOLIDATED COMMUNICATIONS	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=105111
MS	ACAM	280,455	FAIL TELECOMMUNICATION CORPORATION	FULTON TEL CO	2,025	Total 25 Mbps/3 Mbps	70%	3,006	2,194	812	0.7299	15,699,930.6	4,294	3,656.01	2,968,676	true	812	2,968,676	2	null	null	null	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=280455
NV	CAF II Auc	559,005	COMMNET WIRELESS, LLC	COMMNET OF NEVADA, LLC	2,025	Total 25 Mbps/3 Mbps	100%	12,844	10,464	2,380	0.8147	15,779,890.59	12,844	1,228.58	2,924,022	true	2,951	3,720,731	7	5,695,565	0	org:COMMNET WIRELESS	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=559005
LA	ACAM II	270,425	AMERICAN BROADBAND HOLDING COMPANY	CAMERON TEL CO - LA	2,025	Total 25 Mbps/3 Mbps	70%	3,404	2,436	968	0.7156	14,551,246.08	4,863	2,992.32	2,896,570	true	1,417	7,283,518	6	null	null	null	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=270425
VA	RDOF	199,024	RIVERSTREET MANAGEMENT SERVICES, LLC D/B/A RIVERSTREET NETWORKS	RiverStreet Communications of Virginia, Inc.	2,025	Total 1 Gbps/500 Mbps	40%	9,212	4,803	4,409	0.5214	15,117,935.89	23,030	656.45	2,894,267	true	7,502	9,310,378	8	10,633,809	1,928,937	null	https://opendata.usac.org/resource/99nv-p7fk.json?study_area_code=199024

CAF Buildout Shortfall Register: free sample (Tensorust LLC)

Every USF high-cost study area's buildout milestone, the locations short, and the support tied to the shortfall.

Headline: 225 of 2,797 high-cost study areas reported fewer deployed locations than their latest milestone requires: 245,815 locations short, tied to $269.6M of support at each area's own support per obligated location.

This repository is a free teaser, not the dataset. It holds 25 example rows and a summary table with no names in it. The full file has 2,797 rows and is sold by Tensorust LLC: https://tensorust.com/datasets/caf-buildout-shortfall/.

Files here

file	what it is
`sample.csv`	25 rows of the full file (the same sample shown on tensorust.com)
`summary_by_state.csv`	row counts and totals by state across the full file, no entity names (groups with fewer than 3 rows are folded into "Other")

Summary by state (largest groups)

State	rows	Shortfall locations
IA	346	1,074
MN	152	1,352
TX	136	6,080
OK	114	2,838
IL	114	2,933
WI	111	4,607
MO	102	6,090
NY	88	2,621
MI	77	27,032
NE	74	410
OH	73	7,075
KS	73	99
TOTAL	2,797	245,815

Full table: summary_by_state.csv.

What the full file has

2,797 rows
Key fields: state, fund, study_area_code, holding_company, carrier, latest_filing_year, obligated_speed_tier, milestone_percentage, milestone_locations_required, locations_deployed_cumulative
Parquet and CSV, a README with sources, method and limits, and the build script
Free 25-row sample (no personal contact data)

Coverage: Every fund, study area and speed tier in USAC's milestone dataset, latest filing year per row (mostly the 2025 HUBB filing). USAC data fetched Nov 6 2026 (2025 filing year)

Columns in the full file

column	meaning
`state`	State
`fund`	High-cost fund
`study_area_code`	USAC study area code
`holding_company`	Holding company
`carrier`	Carrier
`latest_filing_year`	Latest HUBB filing year
`obligated_speed_tier`	Obligated speed tier
`milestone_percentage`	Milestone percent of total obligation
`milestone_locations_required`	Locations required at the milestone
`locations_deployed_cumulative`	Locations deployed, cumulative
`shortfall_locations`	Locations short of the milestone
`pct_of_milestone`	Deployed divided by required
`support_disbursed_cumulative`	Cumulative high-cost support disbursed for the study area and fund
`full_obligation_est`	Estimated total location obligation (milestone divided by milestone percent)
`support_per_obligated_location`	Cumulative support divided by the study area's total estimated obligation across speed tiers
`support_at_shortfall`	Support attributable to the shortfall
`in_shortfall`	True when short of the milestone
`hc_shortfall_locations`	Holding company total shortfall locations
`hc_support_at_shortfall`	Holding company total support at shortfall
`hc_study_areas`	Holding company study areas
`hc_rdof_cafauc_money_at_risk`	Holding company RDOF and CAF II Auction money at risk for the Dec 31 2026 milestone (Tensorust usf-high-cost-milestones build)
`hc_withhold_2027_pace`	Holding company support withheld in 2027 at the 2025 build pace (same build)
`ontology_oid`	Tensorust ontology organization id (name match)
`source`	USAC Open Data milestone record

Get the full file

tier	price	includes
Carrier fleet file	from $950	One holding company: every study area with required and deployed locations, shortfall, support received, support attributable to the shortfall and the USAC source link. $950 (under $50K at risk), $1,900 ($50K to $250K), $4,500 ($250K to $1M), $9,500 ($1M to $5M), $14,500 ($5M and up).
State register	$2,500	Every high-cost study area in one state across all funds (ACAM, ACAM II, CAF II, CAF II Auction, CAF-BLS, EACAM, RDOF, AK Plan, RBE), for PUC staff and state broadband offices.
Full market dataset	$25,000 a year	All 2,797 study-area milestone rows nationwide with holding-company roll-ups, refreshed after the March 1 2027 HUBB filing and as USAC posts payments. For carrier counsel, lenders, acquirers and state offices.

Email mattbusel@tensorust.com with the tier and a billing contact, and we will send a proper invoice (ACH or card). The file is delivered once the invoice is paid. Details and the live sample: https://tensorust.com/datasets/caf-buildout-shortfall/. All datasets: https://tensorust.com/datasets/

Method and limits

Take the latest filing per fund, study area and speed tier, compare cumulative deployed locations with the milestone requirement, divide cumulative support by the estimated total obligation, multiply by the shortfall, roll up per holding company, join to the ontology by normalized name.

Not an FCC recovery order or the exact recovery amount (the rule applies tiered withholding and multipliers, and carriers can still build before a final milestone), not a HUBB filing, no regulatory advice, no contact data. Locations deployed in 2026 are not reported until the March 1 2027 filing.

Sources

USAC Open Data: high-cost milestones (99nv-p7fk) and support disbursed (hghw-69cg), fetched Nov 6 2026
47 CFR 54.320(d) milestone compliance and support recovery
Tensorust usf-high-cost-milestones build (RDOF and CAF II Auction money at risk)

License

The sample and summary here are free to view, analyze and cite with attribution to "Tensorust LLC, https://tensorust.com/datasets/caf-buildout-shortfall/". The full dataset is licensed separately per tier. No resale or redistribution of Tensorust data without a written license.

Tensorust LLC, Tuckahoe NY. mattbusel@tensorust.com | https://tensorust.com

Downloads last month: 47

Number of rows:

Total file size:

17.4 kB