Data source: Big Local News · About: Big Local

13,207 rows where state = "CO" and year = 2017 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2017 · 13,207
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▼ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
707817 CO     school   10   MAPLETON 1   0 Not a school             2017   grade_12 5 0 10   0 0     0   0   10 5                       15 5 0 10   0 0     0   0   10 5                 15
707818 CO     school   10   MAPLETON 1   0 Not a school             2017   pk_12_total 5 0 10   0 0     0   0   10 5                       15 5 0 10   0 0     0   0   10 5                 15
708497 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   grade_3 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
708498 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   grade_4 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
708499 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   pk_12_total 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
708646 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2017   grade_12 1 0 3   0 0     0   0   1 3                       4 1 0 3   0 0     0   0   1 3                 4
708647 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2017   pk_12_total 1 0 3   0 0     0   0   1 3                       4 1 0 3   0 0     0   0   1 3                 4
709484 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_10 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
709485 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_11 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
709486 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_12 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
709487 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_2 1 2 0   0 0     0   0   2 1                       3 1 2 0   0 0     0   0   2 1                 3
709488 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_3 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
709489 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_4 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
709490 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_5 0 0 0   0 0     0   1   0 1                       1 0 0 0   0 0     0   1   0 1                 1
709491 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
709492 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_8 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
709493 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   pk_12_total 7 3 4   0 0     0   2   9 7                       16 7 3 4   0 0     0   2   9 7                 16
711230 CO     school   870   DELTA COUNTY 50(J)   1980 GREAT BEGINNINGS             2017   pk_12_total 12 0 5   0 0     0   1   8 10                       18 12 0 5   0 0     0   1   8 10                 18
711231 CO     school   870   DELTA COUNTY 50(J)   1980 GREAT BEGINNINGS             2017   pre_kindergarten 12 0 5   0 0     0   1   8 10                       18 12 0 5   0 0     0   1   8 10                 18
711295 CO     school   870   DELTA COUNTY 50(J)   4234 LITTLE SPROUTS             2017   pk_12_total 24 0 5   0 0     0   2   16 15                       31 24 0 5   0 0     0   2   16 15                 31
711296 CO     school   870   DELTA COUNTY 50(J)   4234 LITTLE SPROUTS             2017   pre_kindergarten 24 0 5   0 0     0   2   16 15                       31 24 0 5   0 0     0   2   16 15                 31
715516 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   grade_11 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
715517 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   grade_12 9 0 0   0 0     0   0   4 5                       9 9 0 0   0 0     0   0   4 5                 9
715518 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   pk_12_total 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
716933 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_10 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
716934 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_11 1 0 0   1 0     0   0   1 1                       2 1 0 0   1 0     0   0   1 1                 2
716935 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_12 11 0 7   4 1     0   1   19 5                       24 11 0 7   4 1     0   1   19 5                 24
716936 CO     school   1520   DURANGO 9-R   0 Not a school             2017   pk_12_total 12 0 8   5 1     0   1   20 7                       27 12 0 8   5 1     0   1   20 7                 27
717066 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_10 2 0 2   0 0     0   0   3 1                       4 2 0 2   0 0     0   0   3 1                 4
717067 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_11 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
717068 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_12 1 0 2   0 0     0   0   2 1                       3 1 0 2   0 0     0   0   2 1                 3
717069 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
717070 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
717071 CO     school   1550   POUDRE R-1   0 Not a school             2017   pk_12_total 6 0 5   0 0     0   0   8 3                       11 6 0 5   0 0     0   0   8 3                 11
719075 CO     school   2690   PUEBLO CITY 60   0 Not a school             2017   grade_12 12 2 26   0 1     0   1   19 23                       42 12 2 26   0 1     0   1   19 23                 42
719076 CO     school   2690   PUEBLO CITY 60   0 Not a school             2017   pk_12_total 12 2 26   0 1     0   1   19 23                       42 12 2 26   0 1     0   1   19 23                 42
719496 CO     school   2730   DEL NORTE C-7   0 Not a school             2017   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
719497 CO     school   2730   DEL NORTE C-7   0 Not a school             2017   pk_12_total 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
720095 CO     school   3100   WINDSOR RE-4   0 Not a school             2017   grade_11 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
720096 CO     school   3100   WINDSOR RE-4   0 Not a school             2017   pk_12_total 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
721016 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_10 12 3 22   0 0     0   2   31 8                       39 12 3 22   0 0     0   2   31 8                 39
721017 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_11 18 8 22   0 1     0   3   36 16                       52 18 8 22   0 1     0   3   36 16                 52
721018 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_12 14 9 20   1 0     0   0   31 13                       44 14 9 20   1 0     0   0   31 13                 44
721019 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
721020 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_7 1 1 3   0 0     0   0   4 1                       5 1 1 3   0 0     0   0   4 1                 5
721021 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_8 6 2 8   0 0     0   0   13 3                       16 6 2 8   0 0     0   0   13 3                 16
721022 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_9 10 6 19   1 0     0   0   29 7                       36 10 6 19   1 0     0   0   29 7                 36
721023 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   pk_12_total 61 29 95   2 1     0   5   145 48                       193 61 29 95   2 1     0   5   145 48                 193
715329 CO     school 804380 1220   GARFIELD 16 80438001909 3585 GRAND VALLEY CENTER FOR FAMILY LEARNING   Regular School No Elementary PK 01 2017   grade_1 48 0 30   0 0     0   5   47 36                       83 48 0 30   0 0     0   5   47 36                 83
715330 CO     school 804380 1220   GARFIELD 16 80438001909 3585 GRAND VALLEY CENTER FOR FAMILY LEARNING   Regular School No Elementary PK 01 2017   kindergarten_full_day 60 0 28   3 1     0   2   47 47                       94 60 0 28   3 1     0   2   47 47                 94
715331 CO     school 804380 1220   GARFIELD 16 80438001909 3585 GRAND VALLEY CENTER FOR FAMILY LEARNING   Regular School No Elementary PK 01 2017   pk_12_total 161 2 85   3 1     0   13   137 128                       265 161 2 85   3 1     0   13   137 128                 265
715332 CO     school 804380 1220   GARFIELD 16 80438001909 3585 GRAND VALLEY CENTER FOR FAMILY LEARNING   Regular School No Elementary PK 01 2017   pre_kindergarten 53 2 27   0 0     0   6   43 45                       88 53 2 27   0 0     0   6   43 45                 88
717761 CO     school 806960 1580   TRINIDAD 1 80696001201 2481 ECKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 01 2017   grade_1 9 1 67   0 0     0   0   45 32                       77 9 1 67   0 0     0   0   45 32                 77
717762 CO     school 806960 1580   TRINIDAD 1 80696001201 2481 ECKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 01 2017   kindergarten_full_day 10 0 55   0 0     0   2   34 33                       67 10 0 55   0 0     0   2   34 33                 67
717763 CO     school 806960 1580   TRINIDAD 1 80696001201 2481 ECKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 01 2017   pk_12_total 19 1 122   0 0     0   2   79 65                       144 19 1 122   0 0     0   2   79 65                 144
708867 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_1 12 2 75   0 0     0   1   48 42                       90 12 2 75   0 0     0   1   48 42                 90
708868 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 18 2 72   0 1     0   3   51 45                       96 18 2 72   0 1     0   3   51 45                 96
708869 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   kindergarten_full_day 16 2 76   1 1     0   3   52 47                       99 16 2 76   1 1     0   3   52 47                 99
708870 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   pk_12_total 46 6 223   1 2     0   7   151 134                       285 46 6 223   1 2     0   7   151 134                 285
711992 CO     school 803360 880   DENVER COUNTY 1 80336006652 4500 KIPP MONTBELLO ELEMENTARY   Regular School Yes Elementary KG 02 2017   grade_1 4 19 50   0 2     4   2   41 40                       81 4 19 50   0 2     4   2   41 40                 81
711993 CO     school 803360 880   DENVER COUNTY 1 80336006652 4500 KIPP MONTBELLO ELEMENTARY   Regular School Yes Elementary KG 02 2017   grade_2 3 22 52   0 3     0   3   41 42                       83 3 22 52   0 3     0   3   41 42                 83
711994 CO     school 803360 880   DENVER COUNTY 1 80336006652 4500 KIPP MONTBELLO ELEMENTARY   Regular School Yes Elementary KG 02 2017   kindergarten_full_day 10 19 46   0 4     0   2   47 34                       81 10 19 46   0 4     0   2   47 34                 81
711995 CO     school 803360 880   DENVER COUNTY 1 80336006652 4500 KIPP MONTBELLO ELEMENTARY   Regular School Yes Elementary KG 02 2017   pk_12_total 17 60 148   0 9     4   7   129 116                       245 17 60 148   0 9     4   7   129 116                 245
712341 CO     school 803360 880   DENVER COUNTY 1 80336006646 7471 ROCKY MOUNTAIN PREP: SOUTHWEST   Regular School Yes Elementary PK 02 2017   grade_1 1 2 56   1 0     0   0   27 33                       60 1 2 56   1 0     0   0   27 33                 60
712342 CO     school 803360 880   DENVER COUNTY 1 80336006646 7471 ROCKY MOUNTAIN PREP: SOUTHWEST   Regular School Yes Elementary PK 02 2017   grade_2 1 2 37   0 0     0   0   20 20                       40 1 2 37   0 0     0   0   20 20                 40
712343 CO     school 803360 880   DENVER COUNTY 1 80336006646 7471 ROCKY MOUNTAIN PREP: SOUTHWEST   Regular School Yes Elementary PK 02 2017   kindergarten_full_day 6 0 61   0 5     0   0   42 30                       72 6 0 61   0 5     0   0   42 30                 72
712344 CO     school 803360 880   DENVER COUNTY 1 80336006646 7471 ROCKY MOUNTAIN PREP: SOUTHWEST   Regular School Yes Elementary PK 02 2017   pk_12_total 11 7 177   2 6     1   0   108 96                       204 11 7 177   2 6     1   0   108 96                 204
712345 CO     school 803360 880   DENVER COUNTY 1 80336006646 7471 ROCKY MOUNTAIN PREP: SOUTHWEST   Regular School Yes Elementary PK 02 2017   pre_kindergarten 3 3 23   1 1     1   0   19 13                       32 3 3 23   1 1     1   0   19 13                 32
712346 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes Elementary KG 02 2017   grade_1 6 29 15   0 0     0   3   25 28                       53 6 29 15   0 0     0   3   25 28                 53
712347 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes Elementary KG 02 2017   grade_2 4 29 7   0 0     0   2   18 24                       42 4 29 7   0 0     0   2   18 24                 42
712348 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes Elementary KG 02 2017   kindergarten_full_day 12 34 9   1 0     0   5   37 24                       61 12 34 9   1 0     0   5   37 24                 61
712349 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes Elementary KG 02 2017   pk_12_total 22 92 31   1 0     0   10   80 76                       156 22 92 31   1 0     0   10   80 76                 156
713160 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_1 82 0 12   0 0     0   7   46 55                       101 82 0 12   0 0     0   7   46 55                 101
713161 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 87 1 12   0 2     0   11   54 59                       113 87 1 12   0 2     0   11   54 59                 113
713162 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_full_day 48 0 8   1 2     0   8   40 27                       67 48 0 8   1 2     0   8   40 27                 67
713163 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_half_day 32 0 4   0 2     0   3   21 20                       41 32 0 4   0 2     0   3   21 20                 41
713164 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   pk_12_total 302 1 42   1 7     0   35   199 189                       388 302 1 42   1 7     0   35   199 189                 388
713165 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   pre_kindergarten 53 0 6   0 1     0   6   38 28                       66 53 0 6   0 1     0   6   38 28                 66
713259 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_1 85 0 12   0 1     0   6   47 57                       104 85 0 12   0 1     0   6   47 57                 104
713260 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 88 0 21   0 1     0   3   66 47                       113 88 0 21   0 1     0   3   66 47                 113
713261 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_full_day 54 0 8   0 0     0   2   30 34                       64 54 0 8   0 0     0   2   30 34                 64
713262 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_half_day 31 0 7   1 1     0   2   22 20                       42 31 0 7   1 1     0   2   22 20                 42
713263 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   pk_12_total 313 0 49   1 3     0   16   201 181                       382 313 0 49   1 3     0   16   201 181                 382
713264 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   pre_kindergarten 55 0 1   0 0     0   3   36 23                       59 55 0 1   0 0     0   3   36 23                 59
715610 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_1 77 1 8   1 2     0   0   46 43                       89 77 1 8   1 2     0   0   46 43                 89
715611 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 85 2 6   0 0     0   0   48 45                       93 85 2 6   0 0     0   0   48 45                 93
715612 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_full_day 55 0 1   1 0     0   1   31 27                       58 55 0 1   1 0     0   1   31 27                 58
715613 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_half_day 8 0 0   0 0     0   0   2 6                       8 8 0 0   0 0     0   0   2 6                 8
715614 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   pk_12_total 300 3 20   3 2     0   3   167 164                       331 300 3 20   3 2     0   3   167 164                 331
715615 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   pre_kindergarten 75 0 5   1 0     0   2   40 43                       83 75 0 5   1 0     0   2   40 43                 83
716929 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_1 21 0 48   1 0     0   0   33 37                       70 21 0 48   1 0     0   0   33 37                 70
716930 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 13 0 55   0 0     0   0   34 34                       68 13 0 55   0 0     0   0   34 34                 68
716931 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   kindergarten_full_day 27 0 39   0 0     0   1   37 30                       67 27 0 39   0 0     0   1   37 30                 67
716932 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   pk_12_total 61 0 142   1 0     0   1   104 101                       205 61 0 142   1 0     0   1   104 101                 205
717910 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_1 108 4 44   0 1     0   4   88 73                       161 108 4 44   0 1     0   4   88 73                 161
717911 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 112 3 41   0 0     0   3   70 89                       159 112 3 41   0 0     0   3   70 89                 159
717912 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   kindergarten_full_day 99 0 47   0 0     0   1   84 63                       147 99 0 47   0 0     0   1   84 63                 147
717913 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   pk_12_total 319 7 132   0 1     0   8   242 225                       467 319 7 132   0 1     0   8   242 225                 467
718666 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_1 62 0 48   0 0     0   0   60 50                       110 62 0 48   0 0     0   0   60 50                 110
718667 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 61 1 53   0 0     0   1   58 58                       116 61 1 53   0 0     0   1   58 58                 116

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);