Data source: Big Local News · About: Big Local

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

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
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
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
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
711327 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 6 8 229   1 16     0   2   135 127                       262 6 8 229   1 16     0   2   135 127                 262
711328 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 6 7 262   3 18     0   1   172 125                       297 6 7 262   3 18     0   1   172 125                 297
711329 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 8 8 259   1 15     0   1   143 149                       292 8 8 259   1 15     0   1   143 149                 292
711330 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 11 10 276   3 6     0   2   182 126                       308 11 10 276   3 6     0   2   182 126                 308
711331 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2017   pk_12_total 31 33 1026   8 55     0   6   632 527                       1159 31 33 1026   8 55     0   6   632 527                 1159
712684 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_1 74 1 8   1 1     0   4   40 49                       89 74 1 8   1 1     0   4   40 49                 89
712685 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 76 2 11   0 1     0   4   43 51                       94 76 2 11   0 1     0   4   43 51                 94
712686 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_3 83 0 9   0 4     0   4   49 51                       100 83 0 9   0 4     0   4   49 51                 100
712687 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_4 72 2 13   1 1     0   3   54 38                       92 72 2 13   1 1     0   3   54 38                 92
712688 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_5 84 1 6   0 1     0   3   41 54                       95 84 1 6   0 1     0   3   41 54                 95
712689 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_6 75 2 9   0 5     0   1   47 45                       92 75 2 9   0 5     0   1   47 45                 92
712690 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 63 0 10   0 0     0   2   37 38                       75 63 0 10   0 0     0   2   37 38                 75
712691 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_8 53 0 9   1 2     0   2   30 37                       67 53 0 9   1 2     0   2   30 37                 67
712692 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   kindergarten_full_day 33 2 4   0 1     0   3   24 19                       43 33 2 4   0 1     0   3   24 19                 43
712693 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   kindergarten_half_day 43 0 5   0 0     0   1   25 24                       49 43 0 5   0 0     0   1   25 24                 49
712694 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   pk_12_total 656 10 84   3 16     0   27   390 406                       796 656 10 84   3 16     0   27   390 406                 796
712695 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 32 1 9   1 16     0   6   43 22                       65 32 1 9   1 16     0   6   43 22                 65
712696 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 39 1 9   1 25     0   8   36 47                       83 39 1 9   1 25     0   8   36 47                 83
712697 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_3 42 2 21   0 23     0   10   50 48                       98 42 2 21   0 23     0   10   50 48                 98
712698 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_4 50 2 10   0 22     0   8   50 42                       92 50 2 10   0 22     0   8   50 42                 92
712699 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_5 52 4 16   0 18     0   9   47 52                       99 52 4 16   0 18     0   9   47 52                 99
712700 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_6 51 2 13   0 13     0   8   37 50                       87 51 2 13   0 13     0   8   37 50                 87
712701 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   kindergarten_full_day 16 1 8   1 11     1   5   26 17                       43 16 1 8   1 11     1   5   26 17                 43
712702 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   kindergarten_half_day 26 0 4   0 14     0   0   25 19                       44 26 0 4   0 14     0   0   25 19                 44
712703 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   pk_12_total 330 13 98   4 165     2   57   345 324                       669 330 13 98   4 165     2   57   345 324                 669
712704 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   pre_kindergarten 22 0 8   1 23     1   3   31 27                       58 22 0 8   1 23     1   3   31 27                 58
707966 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 39 1 26   0 2     0   2   40 30                       70 39 1 26   0 2     0   2   40 30                 70
707967 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 0 29   1 5     1   4   44 31                       75 35 0 29   1 5     1   4   44 31                 75
707968 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 45 4 30   1 2     0   5   45 42                       87 45 4 30   1 2     0   5   45 42                 87
707969 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 58 3 28   0 2     0   5   61 35                       96 58 3 28   0 2     0   5   61 35                 96
707970 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 45 0 41   0 0     0   1   42 45                       87 45 0 41   0 0     0   1   42 45                 87
707971 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 15 0 9   0 0     0   2   14 12                       26 15 0 9   0 0     0   2   14 12                 26
707972 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 19 1 26   0 1     0   1   25 23                       48 19 1 26   0 1     0   1   25 23                 48
707973 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 256 9 189   2 12     1   20   271 218                       489 256 9 189   2 12     1   20   271 218                 489
720620 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_1 89 1 23   0 6     1   11   64 67                       131 89 1 23   0 6     1   11   64 67                 131
720621 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_10 81 2 45   2 14     0   2   74 72                       146 81 2 45   2 14     0   2   74 72                 146
720622 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_11 83 2 46   0 8     0   4   71 72                       143 83 2 46   0 8     0   4   71 72                 143
720623 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_12 65 1 29   2 12     0   5   60 54                       114 65 1 29   2 12     0   5   60 54                 114
720624 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_2 85 1 31   0 10     0   12   87 52                       139 85 1 31   0 10     0   12   87 52                 139
720625 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_3 100 1 29   0 7     0   7   73 71                       144 100 1 29   0 7     0   7   73 71                 144
720626 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_4 103 0 31   0 10     0   4   72 76                       148 103 0 31   0 10     0   4   72 76                 148
720627 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_5 92 2 35   1 9     0   6   65 80                       145 92 2 35   1 9     0   6   65 80                 145
720628 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_6 88 1 36   1 17     1   2   76 70                       146 88 1 36   1 17     1   2   76 70                 146
720629 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_7 89 0 40   1 12     0   6   66 82                       148 89 0 40   1 12     0   6   66 82                 148
720630 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_8 82 0 50   0 13     0   4   70 79                       149 82 0 50   0 13     0   4   70 79                 149
720631 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_9 66 1 60   0 13     0   2   71 71                       142 66 1 60   0 13     0   2   71 71                 142
720632 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   kindergarten_full_day 71 1 21   0 8     0   8   59 50                       109 71 1 21   0 8     0   8   59 50                 109
720633 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   kindergarten_half_day 18 0 7   0 1     0   0   14 12                       26 18 0 7   0 1     0   0   14 12                 26
720634 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   pk_12_total 1112 13 483   7 140     2   73   922 908                       1830 1112 13 483   7 140     2   73   922 908                 1830
708890 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 58 3 10   1 14     0   8   45 49                       94 58 3 10   1 14     0   8   45 49                 94
708891 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 69 8 12   1 11     0   5   49 57                       106 69 8 12   1 11     0   5   49 57                 106
708892 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 60 4 9   0 12     0   8   50 43                       93 60 4 9   0 12     0   8   50 43                 93
708893 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 75 6 15   1 18     0   7   67 55                       122 75 6 15   1 18     0   7   67 55                 122
708894 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 74 3 15   0 15     0   4   51 60                       111 74 3 15   0 15     0   4   51 60                 111
708895 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 59 3 9   0 19     0   5   54 41                       95 59 3 9   0 19     0   5   54 41                 95
708896 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 440 30 81   3 105     0   41   362 338                       700 440 30 81   3 105     0   41   362 338                 700
708897 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 45 3 11   0 16     0   4   46 33                       79 45 3 11   0 16     0   4   46 33                 79
714472 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 65 3 15   0 0     0   2   36 49                       85 65 3 15   0 0     0   2   36 49                 85
714473 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 57 5 14   0 3     0   8   38 49                       87 57 5 14   0 3     0   8   38 49                 87
714474 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 81 3 6   1 4     2   6   47 56                       103 81 3 6   1 4     2   6   47 56                 103
714475 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 78 2 19   1 0     0   6   51 55                       106 78 2 19   1 0     0   6   51 55                 106
714476 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 87 5 5   0 4     0   5   51 55                       106 87 5 5   0 4     0   5   51 55                 106
714477 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 37 2 4   0 2     0   6   30 21                       51 37 2 4   0 2     0   6   30 21                 51
714478 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 25 0 7   0 1     0   3   10 26                       36 25 0 7   0 1     0   3   10 26                 36
714479 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 430 20 70   2 14     2   36   263 311                       574 430 20 70   2 14     2   36   263 311                 574
708898 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 222 32 62   5 41     0   25   209 178                       387 222 32 62   5 41     0   25   209 178                 387
708899 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 225 43 47   3 41     1   25   207 178                       385 225 43 47   3 41     1   25   207 178                 385

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]);