schools

Data license: 公开数据聚合，仅限查询与展示，不对外再分发分项明细 · Data source: EduKB 教育数据知识引擎

203,431 rows sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: level, first_seen (date), updated_at (date)

Next page

CREATE TABLE schools(
        code        TEXT PRIMARY KEY,
        name        TEXT NOT NULL,
        level       TEXT,              -- 幼儿园/小学/初中/高中/中职/其他（按名称推断，见 level_inferred）
        level_inferred INTEGER DEFAULT 1,
        province    TEXT,
        province_code TEXT,
        city        TEXT,
        county      TEXT,
        source      TEXT DEFAULT 'csh.moe.edu.cn',
        first_seen  TEXT,
        updated_at  TEXT
    );
CREATE INDEX idx_schools_name ON schools(name);
CREATE INDEX idx_schools_prov ON schools(province_code);
CREATE INDEX idx_schools_level ON schools(level);