{"ok":true,"provenance":{"cite_as":"DC Hub, dchub.cloud","default_v":"tracked","fallback_url":"https://dchub.cloud/facilities/directory","license":"CC-BY-4.0","method":"live COUNT() over discovered_facilities at request time. facilities_distinct = COUNT(DISTINCT canonical_slug) WHERE canonical_slug IS NOT NULL \u2014 distinct BUILDINGS, and the field to cite. total_facilities is an ALIAS of facilities_distinct (\u26052026-08-09: it was COUNT(*) over the LEGACY `facilities` table \u2014 a different table, 20,132 rows, undeduplicated \u2014 which contradicted this endpoint's own citeable field; that figure is now published only as legacy_facilities_table_rows). facilities_records = facilities_tracked = COUNT(*) \u2014 raw source records, ~1.5x the buildings because the March 2026 backfill wrote several rows per site. facilities_with_keeper = COUNT(*) WHERE COALESCE(is_duplicate,0)=0. facilities_verified = COUNT(*) WHERE duplicate_of_id IS NULL. Both of the last two are DE-DUPLICATION states, not source verifications \u2014 do not publish either as 'verified'.","provenance_version":1,"source":"DC Hub canonical stats (Neon live counts)"},"purpose":"Canonical truth for facility/news/deals/DCPI counts. Use this endpoint when site copy, AI agents, and reports need to agree.","source":"Neon \u2014 live COUNT() at request time","stats":{"countries_covered":178,"dcpi_market_score_rows":330,"dcpi_markets_scored":320,"deals_rows":5003,"deals_tracked":1848,"facilities_distinct":18073,"facilities_records":25804,"facilities_tracked":25804,"facilities_verified":16345,"facilities_with_country":17838,"facilities_with_keeper":18121,"fiber_routes":64830,"gas_pipelines":33771,"legacy_facilities_table_rows":21566,"news_articles":3179,"power_plants":14480,"subsea_cables":706,"substations":127188,"total_facilities":18073,"transmission_lines":95560}}
