Data source: Big Local News · About: Big Local

13,286 rows where state = "CO" and year = 2021 sorted by asian

View and edit SQL

year

  • 2021 · 13,286
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
1738260 CO     school   10   Mapleton 1   0 Not a school             2021   grade_12 3 0 3   0 0     0   0   5 1                       6 3 0 3   0 0     0   0   5 1                 6
1738261 CO     school   10   Mapleton 1   0 Not a school             2021   pk_12_total 3 0 3   0 0     0   0   5 1                       6 3 0 3   0 0     0   0   5 1                 6
1738263 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2021   grade_11 19 0 67   2 0     0   0   43 45                       88 19 0 67   2 0     0   0   43 45                 88
1738266 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2021   grade_8 17 3 77   2 0     0   3   46 56                       102 17 3 77   2 0     0   3   46 56                 102
1738275 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2021   grade_11 3 1 62   0 0     0   0   38 28                       66 3 1 62   0 0     0   0   38 28                 66
1738276 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2021   grade_12 0 1 35   0 0     0   1   13 24                       37 0 1 35   0 0     0   1   13 24                 37
1738277 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2021   grade_9 8 1 78   0 0     0   0   48 39                       87 8 1 78   0 0     0   0   48 39                 87
1738280 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2021   grade_11 13 0 84   0 0     0   2   54 45                       99 13 0 84   0 0     0   2   54 45                 99
1738288 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2021   grade_5 3 0 37   0 0     0   3   17 26                       43 3 0 37   0 0     0   3   17 26                 43
1738311 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2021   grade_4 13 0 37   0 0     0   0   23 27                       50 13 0 37   0 0     0   0   23 27                 50
1738312 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2021   grade_5 5 0 33   0 0     0   0   17 21                       38 5 0 33   0 0     0   0   17 21                 38
1738316 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2021   pre_kindergarten 10 0 38   0 0     0   0   25 23                       48 10 0 38   0 0     0   0   25 23                 48
1738317 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_1 5 1 33   0 0     0   1   22 18                       40 5 1 33   0 0     0   1   22 18                 40
1738319 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_3 5 1 39   0 0     0   2   15 32                       47 5 1 39   0 0     0   2   15 32                 47
1738325 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   kindergarten_full_day 4 1 33   0 0     0   1   21 18                       39 4 1 33   0 0     0   1   21 18                 39
1738329 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   grade_3 11 1 41   0 0     1   4   37 21                       58 11 1 41   0 0     1   4   37 21                 58
1738331 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   grade_5 14 0 37   0 0     0   2   31 22                       53 14 0 37   0 0     0   2   31 22                 53
1738332 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   grade_6 25 3 81   0 0     2   1   49 63                       112 25 3 81   0 0     2   1   49 63                 112
1738336 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   pre_kindergarten 14 2 40   0 0     0   1   34 23                       57 14 2 40   0 0     0   1   34 23                 57
1738338 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   grade_2 6 0 39   0 0     0   0   31 14                       45 6 0 39   0 0     0   0   31 14                 45
1738339 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   grade_3 11 1 33   0 0     0   0   21 24                       45 11 1 33   0 0     0   0   21 24                 45
1738340 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   grade_4 8 0 40   0 0     0   2   23 27                       50 8 0 40   0 0     0   2   23 27                 50
1738341 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   grade_5 9 0 38   1 0     0   1   29 20                       49 9 0 38   1 0     0   1   29 20                 49
1738342 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   grade_6 8 1 40   0 0     0   1   22 28                       50 8 1 40   0 0     0   1   22 28                 50
1738343 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   kindergarten_full_day 6 0 48   0 0     0   5   26 33                       59 6 0 48   0 0     0   5   26 33                 59
1738345 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 2 0 28   0 0     0   0   15 15                       30 2 0 28   0 0     0   0   15 15                 30
1738346 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2021   grade_1 10 3 43   0 0     0   1   29 28                       57 10 3 43   0 0     0   1   29 28                 57
1738349 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2021   grade_4 8 0 52   1 0     0   0   27 34                       61 8 0 52   1 0     0   0   27 34                 61
1738354 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2021   kindergarten_full_day 7 0 44   0 0     0   0   25 26                       51 7 0 44   0 0     0   0   25 26                 51
1738356 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2021   grade_10 10 0 27   0 0     0   1   21 17                       38 10 0 27   0 0     0   1   21 17                 38
1738357 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2021   grade_11 8 0 17   1 0     0   7   16 17                       33 8 0 17   1 0     0   7   16 17                 33
1738358 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2021   grade_12 3 0 20   0 0     0   0   12 11                       23 3 0 20   0 0     0   0   12 11                 23
1738359 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2021   grade_9 5 0 14   0 0     0   0   10 9                       19 5 0 14   0 0     0   0   10 9                 19
1738360 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2021   pk_12_total 26 0 78   1 0     0   8   59 54                       113 26 0 78   1 0     0   8   59 54                 113
1738361 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_1 65 4 25   1 0     0   10   59 46                       105 65 4 25   1 0     0   10   59 46                 105
1738366 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_3 72 7 32   1 0     0   2   73 41                       114 72 7 32   1 0     0   2   73 41                 114
1738377 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_4 2 0 44   0 0     0   1   21 26                       47 2 0 44   0 0     0   1   21 26                 47
1738378 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_5 2 0 51   1 0     0   0   27 27                       54 2 0 51   1 0     0   0   27 27                 54
1738379 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_6 2 2 54   1 0     0   2   34 27                       61 2 2 54   1 0     0   2   34 27                 61
1738380 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_7 4 0 64   0 0     0   1   35 34                       69 4 0 64   0 0     0   1   35 34                 69
1738385 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   grade_3 2 1 45   0 0     0   1   25 24                       49 2 1 45   0 0     0   1   25 24                 49
1738386 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   kindergarten_full_day 3 0 45   0 0     0   1   25 24                       49 3 0 45   0 0     0   1   25 24                 49
1738389 CO     school 805550 10   Mapleton 1 80555006433 6315 North Valley School for Young Adults   Alternative School No High 09 12 2021   grade_12 15 1 58   1 0     0   2   42 35                       77 15 1 58   1 0     0   2   42 35                 77
1738390 CO     school 805550 10   Mapleton 1 80555006433 6315 North Valley School for Young Adults   Alternative School No High 09 12 2021   pk_12_total 15 1 58   1 0     0   2   42 35                       77 15 1 58   1 0     0   2   42 35                 77
1738392 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_2 8 0 43   0 0     0   0   22 29                       51 8 0 43   0 0     0   0   22 29                 51
1738393 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_3 8 0 25   0 0     0   0   17 16                       33 8 0 25   0 0     0   0   17 16                 33
1738395 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_5 8 0 35   0 0     0   0   22 21                       43 8 0 35   0 0     0   0   22 21                 43
1738396 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_6 7 0 44   1 0     0   0   26 26                       52 7 0 44   1 0     0   0   26 26                 52
1738397 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_7 7 0 57   0 0     0   1   33 32                       65 7 0 57   0 0     0   1   33 32                 65
1738398 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_8 2 0 57   0 0     0   1   27 33                       60 2 0 57   0 0     0   1   27 33                 60
1738399 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   kindergarten_full_day 12 0 31   1 0     0   1   27 18                       45 12 0 31   1 0     0   1   27 18                 45
1738425 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2021   grade_7 2 0 2   0 0     0   0   3 1                       4 2 0 2   0 0     0   0   3 1                 4
1738426 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2021   grade_8 8 0 16   0 0     0   1   18 7                       25 8 0 16   0 0     0   1   18 7                 25
1738427 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2021   grade_9 0 0 1   0 0     1   0   1 1                       2 0 0 1   0 0     1   0   1 1                 2
1738439 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2021   grade_3 24 1 38   0 0     0   1   37 27                       64 24 1 38   0 0     0   1   37 27                 64
1738442 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 16 1 29   0 0     0   2   27 21                       48 16 1 29   0 0     0   2   27 21                 48
1738468 CO     school 806900 20   Adams 12 Five Star Schools 80690001174 1878 Coronado Hills Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 11 0 60   0 0     0   1   40 32                       72 11 0 60   0 0     0   1   40 32                 72
1738505 CO     school 806900 20   Adams 12 Five Star Schools 80690001290 2576 Cherry Drive Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 17 0 26   0 0     0   2   22 23                       45 17 0 26   0 0     0   2   22 23                 45
1738527 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2021   grade_5 17 3 39   1 0     0   1   32 29                       61 17 3 39   1 0     0   1   32 29                 61
1738538 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_1 2 0 43   0 0     0   0   25 20                       45 2 0 43   0 0     0   0   25 20                 45
1738539 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_2 8 0 78   0 0     0   0   43 43                       86 8 0 78   0 0     0   0   43 43                 86
1738540 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_3 3 0 60   0 0     0   1   32 32                       64 3 0 60   0 0     0   1   32 32                 64
1738541 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_4 2 0 71   0 0     0   1   36 38                       74 2 0 71   0 0     0   1   36 38                 74
1738542 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_5 2 0 75   0 0     0   1   37 41                       78 2 0 75   0 0     0   1   37 41                 78
1738543 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 7 0 58   0 0     0   0   32 33                       65 7 0 58   0 0     0   0   32 33                 65
1738572 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2021   grade_10 2 0 21   0 0     0   0   12 11                       23 2 0 21   0 0     0   0   12 11                 23
1738573 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2021   grade_11 3 1 51   0 0     0   0   32 23                       55 3 1 51   0 0     0   0   32 23                 55
1738574 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2021   grade_12 6 2 165   0 0     0   1   86 88                       174 6 2 165   0 0     0   1   86 88                 174
1738575 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2021   grade_9 1 1 6   0 0     0   0   1 7                       8 1 1 6   0 0     0   0   1 7                 8
1738576 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2021   pk_12_total 12 4 243   0 0     0   1   131 129                       260 12 4 243   0 0     0   1   131 129                 260
1738592 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2021   grade_4 22 1 45   0 0     0   0   46 22                       68 22 1 45   0 0     0   0   46 22                 68
1738593 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2021   grade_5 16 0 39   0 0     0   5   30 30                       60 16 0 39   0 0     0   5   30 30                 60
1738594 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 15 2 28   0 0     0   3   25 23                       48 15 2 28   0 0     0   3   25 23                 48
1738637 CO     school 806900 20   Adams 12 Five Star Schools 80690001184 6355 North Mor Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 9 1 25   0 0     0   2   19 18                       37 9 1 25   0 0     0   2   19 18                 37
1738641 CO     school 806900 20   Adams 12 Five Star Schools 80690001185 6376 North Star Elementary School   Regular School No Elementary PK 05 2021   grade_4 5 4 46   1 0     0   2   22 36                       58 5 4 46   1 0     0   2   22 36                 58
1738669 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_10 4 1 3   0 0     0   1   8 1                       9 4 1 3   0 0     0   1   8 1                 9
1738670 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_11 12 0 6   0 0     0   0   10 8                       18 12 0 6   0 0     0   0   10 8                 18
1738672 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_6 5 0 2   0 0     0   0   7 0                       7 5 0 2   0 0     0   0   7 0                 7
1738673 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_7 4 0 3   0 0     0   0   6 1                       7 4 0 3   0 0     0   0   6 1                 7
1738674 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_8 1 1 1   0 0     0   1   4 0                       4 1 1 1   0 0     0   1   4 0                 4
1738675 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_9 1 0 3   1 0     0   0   4 1                       5 1 0 3   1 0     0   0   4 1                 5
1738694 CO     school 806900 20   Adams 12 Five Star Schools 80690006375 8211 The Studio School   Regular School No Elementary KG 05 2021   grade_4 23 1 13   1 0     0   4   20 22                       42 23 1 13   1 0     0   4   20 22                 42
1738716 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_1 18 0 65   0 0     0   2   50 35                       85 18 0 65   0 0     0   2   50 35                 85
1738718 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_3 14 0 66   1 0     0   2   51 32                       83 14 0 66   1 0     0   2   51 32                 83
1738720 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_5 14 0 69   0 0     0   0   42 41                       83 14 0 69   0 0     0   0   42 41                 83
1738724 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   kindergarten_full_day 12 0 48   1 0     0   1   29 33                       62 12 0 48   1 0     0   1   29 33                 62
1738747 CO     school 806900 20   Adams 12 Five Star Schools 80690001191 8842 Thornton Elementary School   Regular School No Elementary PK 05 2021   grade_4 9 3 39   0 0     0   1   30 22                       52 9 3 39   0 0     0   1   30 22                 52
1738749 CO     school 806900 20   Adams 12 Five Star Schools 80690001191 8842 Thornton Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 6 1 29   0 0     0   2   16 22                       38 6 1 29   0 0     0   2   16 22                 38
1738751 CO     school 806900 20   Adams 12 Five Star Schools 80690001191 8842 Thornton Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 8 1 27   0 0     0   0   24 12                       36 8 1 27   0 0     0   0   24 12                 36
1738773 CO     school 806900 20   Adams 12 Five Star Schools 80690001195 9494 Westview Elementary School   Regular School No Elementary PK 05 2021   grade_4 20 2 31   0 0     0   4   33 24                       57 20 2 31   0 0     0   4   33 24                 57
1738786 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_6 17 6 194   2 0     1   2   123 99                       222 17 6 194   2 0     1   2   123 99                 222
1738787 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_7 22 3 216   1 0     0   3   134 111                       245 22 3 216   1 0     0   3   134 111                 245
1738788 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_8 24 0 219   3 0     1   4   122 129                       251 24 0 219   3 0     1   4   122 129                 251
1738789 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   pk_12_total 63 9 629   6 0     2   9   379 339                       718 63 9 629   6 0     2   9   379 339                 718
1738790 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_10 0 0 12   0 0     0   0   6 6                       12 0 0 12   0 0     0   0   6 6                 12
1738791 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_11 9 1 48   1 0     0   1   30 30                       60 9 1 48   1 0     0   1   30 30                 60
1738792 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_12 12 1 89   0 0     0   1   64 39                       103 12 1 89   0 0     0   1   64 39                 103
1738793 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1738794 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   pk_12_total 21 2 150   1 0     0   2   101 75                       176 21 2 150   1 0     0   2   101 75                 176
1738797 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2021   grade_12 21 3 293   1 0     0   3   152 169                       321 21 3 293   1 0     0   3   152 169                 321

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