2021_ccd_processing/import_ccd_districts.sql at main · Chalkbeat/2021_ccd_processing · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
drop table if exists ccd_directory cascade;

create table ccd_directory (
    SCHOOL_YEAR TEXT,
    FIPST TEXT,
    STATENAME TEXT,
    ST TEXT,
    LEA_NAME TEXT,
    STATE_AGENCY_NO TEXT,
    TEXT_UNION TEXT,
    ST_LEAID TEXT,
    LEAID TEXT,
    MSTREET1 TEXT,
    MSTREET2 TEXT,
    MSTREET3 TEXT,
    MCITY TEXT,
    MSTATE TEXT,
    MZIP TEXT,
    MZIP4 TEXT,
    LSTREET1 TEXT,
    LSTREET2 TEXT,
    LSTREET3 TEXT,
    LCITY TEXT,
    LSTATE TEXT,
    LZIP TEXT,
    LZIP4 TEXT,
    PHONE TEXT,
    WEBSITE TEXT,
    SY_STATUS TEXT,
    SY_STATUS_TEXT TEXT,
    UPDATED_STATUS TEXT,
    UPDATED_STATUS_TEXT TEXT,
    EFFECTIVE_DATE TEXT,
    LEA_TYPE TEXT,
    LEA_TYPE_TEXT TEXT,
    OUT_OF_STATE_FLAG TEXT,
    CHARTER_LEA TEXT,
    CHARTER_LEA_TEXT TEXT,
    NOGRADES TEXT,
    G_PK_OFFERED TEXT,
    G_KG_OFFERED TEXT,
    G_1_OFFERED TEXT,
    G_2_OFFERED TEXT,
    G_3_OFFERED TEXT,
    G_4_OFFERED TEXT,
    G_5_OFFERED TEXT,
    G_6_OFFERED TEXT,
    G_7_OFFERED TEXT,
    G_8_OFFERED TEXT,
    G_9_OFFERED TEXT,
    G_10_OFFERED TEXT,
    G_11_OFFERED TEXT,
    G_12_OFFERED TEXT,
    G_13_OFFERED TEXT,
    G_UG_OFFERED TEXT,
    G_AE_OFFERED TEXT,
    GSLO TEXT,
    GSHI TEXT,
    LEVEL TEXT,
    IGOFFERED TEXT,
    OPERATIONAL_SCHOOLS TEXT
);

\copy ccd_directory from 'data/districts.csv' csv header;