SchoolDigger U.S. K-12 School Directory

Name: SchoolDigger U.S. K-12 School Directory
Creator: SchoolDigger
Published: 2025-12-03T00:53:20+08:00

Snowflake2025-12-03 更新2025-12-04 收录

教育信息

数据目录

数据链接：

https://app.snowflake.com/marketplace/listing/GZTYZ13NE7HJ5 数据链接链接失效反馈

官方服务：

资源简介：

From SchoolDigger, a leading K-12 school information website, access a complete directory of 136,000+ US schools covering all 50 states and Washington D.C. Includes public, private, charter, magnet, and virtual schools. Each record provides school name, full address with geocoded latitude/longitude, phone number, website, district, county, and grade levels served. Records include NCES school and district IDs for easy joining with other education datasets. School type flags identify charter, magnet, and virtual schools, while private school records include affiliation details. Ideal for market analysis, territory planning, and data enrichment. Updated monthly. Trial includes Colorado; purchase unlocks all states.

提供机构：

SchoolDigger

创建时间：

2025-12-03

原始信息汇总

SchoolDigger U.S. K-12 School Directory 数据集概述

数据集基本信息

数据集名称: SchoolDigger U.S. K-12 School Directory
数据提供商: SchoolDigger
数据量: 136,000+ 条记录
覆盖范围: 美国所有50个州和华盛顿特区
学校类型: 包括公立、私立、特许、磁校和虚拟学校
更新频率: 每月更新

数据内容描述

核心内容: 美国K-12学校完整目录
每条记录包含: 学校名称、完整地址（含地理编码的纬度/经度）、电话号码、网站、学区、县和服务的年级水平
标识符: 包含NCES学校和学区ID，便于与其他教育数据集连接
学校类型标识: 包含特许、磁校和虚拟学校的标识；私立学校记录包含附属关系详情

数据字典（SCHOOLLOOKUP表）

表描述: 学校目录列表，每栋学校建筑一条记录
主要列:
- FIPS_STATE (Varchar)
- FIPS_LEAID (Varchar)
- FIPS_SCHOOLID (Varchar)
- NCES_PRIVATESCHOOLID (Varchar)
- SCHOOLNAME (Varchar)
- ADDRESSSTREET (Varchar)
- ADDRESSCITY (Varchar)
- ADDRESSSTATE (Varchar)
- ADDRESSZIP (Varchar)
- ADDRESSZIP4 (Varchar)
- SCHOOLURL (Varchar)
- ADDRESSLATITUDE (Number)
- ADDRESSLONGITUDE (Number)
- DISTRICTNAME (Varchar)
- DISTRICTURL (Varchar)
- COUNTYNAME (Varchar)
- PHONE (Varchar)
- LOWGRADESERVED (Varchar)
- HIGHGRADESERVED (Varchar)
- LEVEL (Varchar)
- MAGNET (Varchar)
- CHARTER (Varchar)
- VIRTUAL (Varchar)
- ISPRIVATE (Boolean)
- PRIVATEAFFILIATIONDESCRIPTION (Varchar)
- SCHOOLDIGGERSCHOOLURL (Varchar)
- SCHOOLDIGGERDISTRICTURL (Varchar)

商业应用场景

联系数据增强

使用NCES ID作为匹配键，为现有学校记录添加当前联系信息
追加电话号码、学校网站和学区网站到客户或潜在客户数据库
通过每月更新保持CRM和营销系统最新

位置数据增强

为学校记录添加精确的地理数据
包含完整街道地址、城市、州、邮政编码、县和地理编码的纬度/经度坐标
适用于地图应用、配送路线优化、服务区域分配和邻近性分析

市场分析

分析全美50个州和华盛顿特区的K-12教育格局
按类型（公立、私立、特许、磁校、虚拟）、服务年级水平、地理区域或私立学校附属关系对学校进行细分
识别市场机会、确定总可寻址市场规模、规划区域扩张或支持销售团队的区域规划

使用示例

德克萨斯州特许高中

sql SELECT SchoolName, DistrictName, AddressCity, Phone, SchoolURL FROM marketplace.SchoolLookup WHERE AddressState = TX AND Charter = Y AND Level = High ORDER BY AddressCity, SchoolName;

具有联系和位置数据的私立学校

sql SELECT SchoolName, PrivateAffiliationDescription, AddressStreet, AddressCity, AddressState, AddressZip, AddressLatitude, AddressLongitude, Phone, SchoolURL FROM MARKETPLACE.SchoolLookup WHERE IsPrivate = TRUE and AddressCity <> ORDER BY AddressState, AddressCity, SchoolName;

丹佛市中心10英里内的学校

sql SELECT SchoolName, Level, AddressStreet, AddressCity, AddressZip, Phone, ROUND(HAVERSINE(39.7392, -104.9903, AddressLatitude, AddressLongitude), 2) AS DistanceMiles FROM MARKETPLACE.SchoolLookup WHERE AddressState = CO AND HAVERSINE(39.7392, -104.9903, AddressLatitude, AddressLongitude) <= 10 ORDER BY DistanceMiles, SchoolName;