Data source: Big Local News · About: Big Local

92,494 rows where state = "CO" sorted by district_nces_id

View and edit SQL

grade

year

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
1751378 CO     school 800020 8001   Charter School Institute 80002006661 6266 New Legacy Charter School   Alternative School Yes High 09 12 2021   pk_12_total 6 12 71   1 0     1   0   22 69                       91 6 12 71   1 0     1   0   22 69                 91
1751379 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_1 20 3 99   1 2     0   1   54 72                       126 20 3 99   1 2     0   1   54 72                 126
1751380 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_10 11 0 127   2 7     0   3   74 76                       150 11 0 127   2 7     0   3   74 76                 150
1751381 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_11 20 4 117   0 6     0   1   66 82                       148 20 4 117   0 6     0   1   66 82                 148
1751382 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_12 22 0 103   0 6     0   0   58 73                       131 22 0 103   0 6     0   0   58 73                 131
1751383 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_2 30 2 100   1 7     0   0   63 77                       140 30 2 100   1 7     0   0   63 77                 140
1751384 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_3 26 0 155   1 5     0   4   87 104                       191 26 0 155   1 5     0   4   87 104                 191
1751385 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_4 21 3 129   0 4     1   2   89 71                       160 21 3 129   0 4     1   2   89 71                 160
1751386 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_5 24 1 153   1 5     0   2   91 95                       186 24 1 153   1 5     0   2   91 95                 186
1751387 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_6 20 2 156   1 9     0   1   108 81                       189 20 2 156   1 9     0   1   108 81                 189
1751388 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_7 15 2 161   0 2     0   5   85 100                       185 15 2 161   0 2     0   5   85 100                 185
1751389 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_8 20 0 160   0 6     0   4   85 105                       190 20 0 160   0 6     0   4   85 105                 190
1751390 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_9 18 4 147   0 6     0   1   91 85                       176 18 4 147   0 6     0   1   91 85                 176
1751391 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   kindergarten_full_day 28 3 96   1 6     0   1   64 71                       135 28 3 96   1 6     0   1   64 71                 135
1751392 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   pk_12_total 275 24 1703   8 71     1   25   1015 1092                       2107 275 24 1703   8 71     1   25   1015 1092                 2107
1751393 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_1 2 0 17   0 0     0   0   6 13                       19 2 0 17   0 0     0   0   6 13                 19
1751394 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_2 2 1 25   0 0     0   0   15 13                       28 2 1 25   0 0     0   0   15 13                 28
1751395 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_3 0 1 22   0 0     0   0   12 11                       23 0 1 22   0 0     0   0   12 11                 23
1751396 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_4 0 0 24   0 0     0   0   12 12                       24 0 0 24   0 0     0   0   12 12                 24
1751397 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_5 2 1 37   0 0     0   0   14 26                       40 2 1 37   0 0     0   0   14 26                 40
1751398 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_6 2 0 28   0 0     0   0   18 12                       30 2 0 28   0 0     0   0   18 12                 30
1751399 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_7 1 0 38   0 0     0   0   20 19                       39 1 0 38   0 0     0   0   20 19                 39
1751400 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_8 0 0 40   0 0     0   0   19 21                       40 0 0 40   0 0     0   0   19 21                 40
1751401 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   kindergarten_full_day 2 2 15   0 0     0   0   12 7                       19 2 2 15   0 0     0   0   12 7                 19
1751402 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   pk_12_total 11 5 246   0 0     0   0   128 134                       262 11 5 246   0 0     0   0   128 134                 262
1751403 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_1 29 0 13   0 2     0   1   22 23                       45 29 0 13   0 2     0   1   22 23                 45
1751404 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_2 35 0 8   0 1     0   0   18 26                       44 35 0 8   0 1     0   0   18 26                 44
1751405 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_3 24 0 12   0 0     0   1   20 17                       37 24 0 12   0 0     0   1   20 17                 37
1751406 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_4 25 0 8   0 0     0   0   14 19                       33 25 0 8   0 0     0   0   14 19                 33
1751407 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_5 28 0 10   0 0     0   1   16 23                       39 28 0 10   0 0     0   1   16 23                 39
1751408 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_6 19 0 9   0 0     0   2   13 17                       30 19 0 9   0 0     0   2   13 17                 30
1751409 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_7 11 0 6   0 0     1   0   9 9                       18 11 0 6   0 0     1   0   9 9                 18
1751410 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_8 19 0 3   0 0     0   0   14 8                       22 19 0 3   0 0     0   0   14 8                 22
1751411 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   kindergarten_full_day 22 0 20   1 0     0   2   20 25                       45 22 0 20   1 0     0   2   20 25                 45
1751412 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   pk_12_total 212 0 89   1 3     1   7   146 167                       313 212 0 89   1 3     1   7   146 167                 313
1751413 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_1 10 0 1   0 0     0   0   5 6                       11 10 0 1   0 0     0   0   5 6                 11
1751414 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_2 7 0 2   0 0     0   0   3 6                       9 7 0 2   0 0     0   0   3 6                 9
1751415 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_3 9 0 1   0 0     0   0   4 6                       10 9 0 1   0 0     0   0   4 6                 10
1751416 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_4 10 1 0   0 0     0   0   2 9                       11 10 1 0   0 0     0   0   2 9                 11
1751417 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_5 8 0 2   0 0     0   1   2 9                       11 8 0 2   0 0     0   1   2 9                 11
1751418 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_6 7 0 0   0 0     0   0   2 5                       7 7 0 0   0 0     0   0   2 5                 7
1751419 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_7 7 1 0   0 0     0   0   5 3                       8 7 1 0   0 0     0   0   5 3                 8
1751420 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_8 10 0 0   0 0     0   0   5 5                       10 10 0 0   0 0     0   0   5 5                 10
1751421 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   kindergarten_full_day 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
1751422 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 78 2 6   0 0     0   1   32 55                       87 78 2 6   0 0     0   1   32 55                 87
1751423 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_1 22 0 16   0 0     0   1   17 22                       39 22 0 16   0 0     0   1   17 22                 39
1751424 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_2 28 0 13   0 1     0   1   23 20                       43 28 0 13   0 1     0   1   23 20                 43
1751425 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_3 28 1 14   0 0     0   1   25 19                       44 28 1 14   0 0     0   1   25 19                 44
1751426 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_4 24 0 13   0 1     0   1   19 20                       39 24 0 13   0 1     0   1   19 20                 39
1751427 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_5 27 0 14   1 0     0   0   26 16                       42 27 0 14   1 0     0   0   26 16                 42
1751428 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_6 31 1 15   0 1     0   1   26 23                       49 31 1 15   0 1     0   1   26 23                 49
1751429 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_7 25 0 12   0 1     0   0   20 18                       38 25 0 12   0 1     0   0   20 18                 38
1751430 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_8 25 0 14   0 1     0   1   22 19                       41 25 0 14   0 1     0   1   22 19                 41
1751431 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   kindergarten_full_day 24 1 10   2 0     0   0   17 20                       37 24 1 10   2 0     0   0   17 20                 37
1751432 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1751433 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   pk_12_total 235 3 121   3 5     0   6   196 177                       373 235 3 121   3 5     0   6   196 177                 373
1751434 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_1 34 1 11   0 1     0   7   29 25                       54 34 1 11   0 1     0   7   29 25                 54
1751435 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_10 50 0 10   0 2     0   5   36 31                       67 50 0 10   0 2     0   5   36 31                 67
1751436 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_11 34 0 9   0 3     0   3   22 27                       49 34 0 9   0 3     0   3   22 27                 49
1751437 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_12 39 1 16   0 0     0   3   30 29                       59 39 1 16   0 0     0   3   30 29                 59
1751438 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_2 35 0 15   1 0     0   5   26 30                       56 35 0 15   1 0     0   5   26 30                 56
1751439 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_3 37 1 15   0 0     0   3   27 29                       56 37 1 15   0 0     0   3   27 29                 56
1751440 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_4 35 1 16   0 2     0   2   24 32                       56 35 1 16   0 2     0   2   24 32                 56
1751441 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_5 51 1 18   0 1     0   9   33 47                       80 51 1 18   0 1     0   9   33 47                 80
1751442 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_6 66 0 19   1 2     0   9   50 47                       97 66 0 19   1 2     0   9   50 47                 97
1751443 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_7 55 2 19   1 3     0   11   46 45                       91 55 2 19   1 3     0   11   46 45                 91
1751444 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_8 60 2 22   0 4     0   7   48 47                       95 60 2 22   0 4     0   7   48 47                 95
1751445 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_9 56 1 16   0 1     0   3   37 40                       77 56 1 16   0 1     0   3   37 40                 77
1751446 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   kindergarten_full_day 43 0 12   0 2     0   4   31 30                       61 43 0 12   0 2     0   4   31 30                 61
1751447 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   kindergarten_half_day 10 0 4   0 0     0   0   10 4                       14 10 0 4   0 0     0   0   10 4                 14
1751448 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   pk_12_total 605 10 202   3 21     0   71   449 463                       912 605 10 202   3 21     0   71   449 463                 912
1751449 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2021   grade_10 1 0 39   0 0     0   0   18 22                       40 1 0 39   0 0     0   0   18 22                 40
1751450 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2021   grade_11 0 0 17   0 0     0   0   6 11                       17 0 0 17   0 0     0   0   6 11                 17
1751451 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2021   grade_12 2 0 24   0 0     0   0   14 12                       26 2 0 24   0 0     0   0   14 12                 26
1751452 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2021   grade_9 2 0 38   0 0     0   0   14 26                       40 2 0 38   0 0     0   0   14 26                 40
1751453 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2021   pk_12_total 5 0 118   0 0     0   0   52 71                       123 5 0 118   0 0     0   0   52 71                 123
1751454 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2021   grade_6 2 1 61   0 0     0   0   31 33                       64 2 1 61   0 0     0   0   31 33                 64
1751455 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2021   grade_7 3 1 60   0 0     0   1   27 38                       65 3 1 60   0 0     0   1   27 38                 65
1751456 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2021   grade_8 5 1 63   0 0     0   0   33 36                       69 5 1 63   0 0     0   0   33 36                 69
1751457 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2021   pk_12_total 10 3 184   0 0     0   1   91 107                       198 10 3 184   0 0     0   1   91 107                 198
1812195 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_1 85 1 29   0 13     0   8   63 73                       136 85 1 29   0 13     0   8   63 73                 136
1812196 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_10 79 0 52   1 10     0   4   72 74                       146 79 0 52   1 10     0   4   72 74                 146
1812197 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_11 75 2 46   0 14     0   6   65 78                       143 75 2 46   0 14     0   6   65 78                 143
1812198 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_12 62 1 58   0 11     0   2   71 63                       134 62 1 58   0 11     0   2   71 63                 134
1812199 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_2 83 0 34   0 9     0   12   69 69                       138 83 0 34   0 9     0   12   69 69                 138
1812200 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_3 87 2 39   0 9     0   3   77 63                       140 87 2 39   0 9     0   3   77 63                 140
1812201 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_4 88 0 36   0 8     1   12   68 77                       145 88 0 36   0 8     1   12   68 77                 145
1812202 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_5 84 2 35   0 9     0   14   84 60                       144 84 2 35   0 9     0   14   84 60                 144
1812203 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_6 97 1 36   0 9     0   4   73 74                       147 97 1 36   0 9     0   4   73 74                 147
1812204 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_7 91 1 36   0 11     0   6   67 78                       145 91 1 36   0 11     0   6   67 78                 145
1812205 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_8 86 1 45   0 9     0   5   64 82                       146 86 1 45   0 9     0   5   64 82                 146
1812206 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_9 76 2 48   0 15     0   3   73 71                       144 76 2 48   0 15     0   3   73 71                 144
1812207 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   kindergarten_full_day 82 1 29   0 10     0   12   70 64                       134 82 1 29   0 10     0   12   70 64                 134
1812208 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   pk_12_total 1100 15 531   1 143     1   95   937 949                       1886 1100 15 531   1 143     1   95   937 949                 1886
1812209 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   pre_kindergarten 25 1 8   0 6     0   4   21 23                       44 25 1 8   0 6     0   4   21 23                 44
1812210 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2020   grade_10 38 0 11   0 0     0   2   26 25                       51 38 0 11   0 0     0   2   26 25                 51
1812211 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2020   grade_11 45 0 10   2 2     1   1   36 25                       61 45 0 10   2 2     1   1   36 25                 61
1812212 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2020   grade_12 48 0 9   3 0     0   1   26 35                       61 48 0 9   3 0     0   1   26 35                 61
1812213 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2020   grade_9 29 0 4   1 0     0   1   18 17                       35 29 0 4   1 0     0   1   18 17                 35
1812214 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2020   pk_12_total 160 0 34   6 2     1   5   106 102                       208 160 0 34   6 2     1   5   106 102                 208

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