enrollments

Data source: Big Local News · About: Big Local

13,321 rows where state = "CO" and year = 2020 sorted by black_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 13,321 ✖
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
1799315 1799315 CO     school 805550 10   Mapleton 1 80555001858 212 Mapleton Early College High School   Regular School No High 09 12 2020   grade_10 17 0 45   1 1     0   1   28 37                       65 17 0 45   1 1     0   1   28 37                 65
1799316 1799316 CO     school 805550 10   Mapleton 1 80555001858 212 Mapleton Early College High School   Regular School No High 09 12 2020   grade_11 9 0 50   0 4     0   1   32 32                       64 9 0 50   0 4     0   1   32 32                 64
1799318 1799318 CO     school 805550 10   Mapleton 1 80555001858 212 Mapleton Early College High School   Regular School No High 09 12 2020   grade_9 7 0 64   1 2     0   1   26 49                       75 7 0 64   1 2     0   1   26 49                 75
1799320 1799320 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2020   grade_10 4 0 67   0 0     0   1   40 32                       72 4 0 67   0 0     0   1   40 32                 72
1799322 1799322 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2020   grade_12 1 0 48   0 1     0   1   26 25                       51 1 0 48   0 1     0   1   26 25                 51
1799325 1799325 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   grade_10 15 0 106   0 0     0   3   63 61                       124 15 0 106   0 0     0   3   63 61                 124
1799330 1799330 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_1 6 0 28   0 0     0   1   17 18                       35 6 0 28   0 0     0   1   17 18                 35
1799331 1799331 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_2 8 0 25   0 0     0   0   16 17                       33 8 0 25   0 0     0   0   16 17                 33
1799333 1799333 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_4 2 0 33   0 2     0   0   13 24                       37 2 0 33   0 2     0   0   13 24                 37
1799335 1799335 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_6 6 0 52   0 1     0   1   20 40                       60 6 0 52   0 1     0   1   20 40                 60
1799336 1799336 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_7 4 0 35   0 1     0   1   22 19                       41 4 0 35   0 1     0   1   22 19                 41
1799337 1799337 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_8 3 0 49   0 2     0   0   24 30                       54 3 0 49   0 2     0   0   24 30                 54
1799338 1799338 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   kindergarten_full_day 4 0 20   0 0     0   0   10 14                       24 4 0 20   0 0     0   0   10 14                 24
1799340 1799340 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_1 10 0 37   0 4     0   1   29 23                       52 10 0 37   0 4     0   1   29 23                 52
1799343 1799343 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_4 4 0 37   0 0     0   3   18 26                       44 4 0 37   0 0     0   3   18 26                 44
1799346 1799346 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_7 9 0 46   0 2     0   0   36 21                       57 9 0 46   0 2     0   0   36 21                 57
1799350 1799350 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   pre_kindergarten 8 0 47   0 4     0   1   27 33                       60 8 0 47   0 4     0   1   27 33                 60
1799354 1799354 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_12 3 0 63   0 2     0   3   33 38                       71 3 0 63   0 2     0   3   33 38                 71
1799355 1799355 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_2 4 0 47   0 1     0   2   32 22                       54 4 0 47   0 1     0   2   32 22                 54
1799356 1799356 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_3 4 0 47   0 1     0   2   30 24                       54 4 0 47   0 1     0   2   30 24                 54
1799363 1799363 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   kindergarten_full_day 3 0 33   0 1     0   1   22 16                       38 3 0 33   0 1     0   1   22 16                 38
1799366 1799366 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_2 9 0 29   1 1     0   0   18 22                       40 9 0 29   1 1     0   0   18 22                 40
1799367 1799367 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_3 11 0 27   0 1     0   0   20 19                       39 11 0 27   0 1     0   0   20 19                 39
1799368 1799368 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_4 7 0 29   0 0     0   0   17 19                       36 7 0 29   0 0     0   0   17 19                 36
1799369 1799369 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_5 1 0 24   0 1     0   1   11 16                       27 1 0 24   0 1     0   1   11 16                 27
1799370 1799370 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_6 4 0 22   1 1     0   0   11 17                       28 4 0 22   1 1     0   0   11 17                 28
1799371 1799371 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   kindergarten_full_day 14 0 43   0 1     0   1   27 32                       59 14 0 43   0 1     0   1   27 32                 59
1799374 1799374 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_1 3 0 25   0 2     0   1   13 18                       31 3 0 25   0 2     0   1   13 18                 31
1799376 1799376 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_3 8 0 36   0 2     0   0   21 25                       46 8 0 36   0 2     0   0   21 25                 46
1799377 1799377 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_4 3 0 44   0 2     0   1   24 26                       50 3 0 44   0 2     0   1   24 26                 50
1799378 1799378 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_5 9 0 38   1 1     0   2   26 25                       51 9 0 38   1 1     0   2   26 25                 51
1799380 1799380 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_7 5 0 51   1 1     0   3   31 30                       61 5 0 51   1 1     0   3   31 30                 61
1799385 1799385 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   grade_1 16 0 27   0 0     0   1   27 17                       44 16 0 27   0 0     0   1   27 17                 44
1799388 1799388 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   grade_4 19 0 28   0 0     0   2   28 21                       49 19 0 28   0 0     0   2   28 21                 49
1799391 1799391 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   kindergarten_full_day 17 0 36   0 1     0   1   29 26                       55 17 0 36   0 1     0   1   29 26                 55
1799394 1799394 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_1 9 0 40   0 1     0   0   32 18                       50 9 0 40   0 1     0   0   32 18                 50
1799396 1799396 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_3 8 0 47   0 0     0   3   28 30                       58 8 0 47   0 0     0   3   28 30                 58
1799397 1799397 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_4 7 0 34   2 0     0   1   28 16                       44 7 0 34   2 0     0   1   28 16                 44
1799399 1799399 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_6 4 0 52   1 1     0   1   29 30                       59 4 0 52   1 1     0   1   29 30                 59
1799400 1799400 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   kindergarten_full_day 2 0 55   0 1     1   0   31 28                       59 2 0 55   0 1     1   0   31 28                 59
1799405 1799405 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_3 6 0 46   0 1     0   0   23 30                       53 6 0 46   0 1     0   0   23 30                 53
1799409 1799409 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_7 9 0 47   0 2     0   0   31 27                       58 9 0 47   0 2     0   0   31 27                 58
1799413 1799413 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2020   grade_10 8 0 22   1 1     0   6   19 19                       38 8 0 22   1 1     0   6   19 19                 38
1799414 1799414 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2020   grade_11 4 0 24   0 0     0   0   16 12                       28 4 0 24   0 0     0   0   16 12                 28
1799415 1799415 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2020   grade_12 10 0 25   0 0     0   3   14 24                       38 10 0 25   0 0     0   3   14 24                 38
1799416 1799416 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2020   grade_9 8 0 23   0 0     0   1   17 15                       32 8 0 23   0 0     0   1   17 15                 32
1799417 1799417 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2020   pk_12_total 30 0 94   1 1     0   10   66 70                       136 30 0 94   1 1     0   10   66 70                 136
1799432 1799432 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2020   grade_4 4 0 49   1 0     0   0   25 29                       54 4 0 49   1 0     0   0   25 29                 54
1799434 1799434 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2020   grade_6 4 0 53   0 0     0   1   27 31                       58 4 0 53   0 0     0   1   27 31                 58
1799438 1799438 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2020   grade_1 2 0 40   0 2     0   1   25 20                       45 2 0 40   0 2     0   1   25 20                 45
1799440 1799440 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2020   grade_3 3 0 44   0 0     0   2   26 23                       49 3 0 44   0 0     0   2   26 23                 49
1799441 1799441 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2020   kindergarten_full_day 10 0 45   0 2     0   1   27 31                       58 10 0 45   0 2     0   1   27 31                 58
1799446 1799446 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_1 8 0 34   0 0     0   0   21 21                       42 8 0 34   0 0     0   0   21 21                 42
1799447 1799447 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_2 9 0 18   0 0     0   0   16 11                       27 9 0 18   0 0     0   0   16 11                 27
1799449 1799449 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_4 8 0 32   0 0     0   0   23 17                       40 8 0 32   0 0     0   0   23 17                 40
1799450 1799450 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_5 14 0 44   1 0     0   0   28 31                       59 14 0 44   1 0     0   0   28 31                 59
1799451 1799451 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_6 10 0 48   0 0     0   1   27 32                       59 10 0 48   0 0     0   1   27 32                 59
1799452 1799452 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_7 2 0 58   0 0     0   1   27 34                       61 2 0 58   0 0     0   1   27 34                 61
1799454 1799454 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   kindergarten_full_day 15 0 17   0 1     0   3   16 20                       36 15 0 17   0 1     0   3   16 20                 36
1799456 1799456 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   pre_kindergarten 21 0 29   1 4     0   1   31 25                       56 21 0 29   1 4     0   1   31 25                 56
1799457 1799457 CO     school   20   Adams 12 Five Star Schools   0 Not a school             2020   grade_10 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1799458 1799458 CO     school   20   Adams 12 Five Star Schools   0 Not a school             2020   grade_11 5 0 5   1 0     0   0   4 7                       11 5 0 5   1 0     0   0   4 7                 11
1799459 1799459 CO     school   20   Adams 12 Five Star Schools   0 Not a school             2020   grade_12 27 0 17   0 2     0   1   17 30                       47 27 0 17   0 2     0   1   17 30                 47
1799460 1799460 CO     school   20   Adams 12 Five Star Schools   0 Not a school             2020   pk_12_total 33 0 22   1 2     0   1   22 37                       59 33 0 22   1 2     0   1   22 37                 59
1799461 1799461 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   grade_1 41 0 23   0 4     0   2   34 36                       70 41 0 23   0 4     0   2   34 36                 70
1799462 1799462 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   grade_2 35 0 36   1 6     0   2   41 39                       80 35 0 36   1 6     0   2   41 39                 80
1799473 1799473 CO     school 806900 20   Adams 12 Five Star Schools 80690001733 59 Meridian Elementary School   Regular School No Elementary KG 05 2020   grade_2 65 0 12   0 8     1   6   48 44                       92 65 0 12   0 8     1   6   48 44                 92
1799474 1799474 CO     school 806900 20   Adams 12 Five Star Schools 80690001733 59 Meridian Elementary School   Regular School No Elementary KG 05 2020   grade_3 75 0 14   0 8     0   9   58 48                       106 75 0 14   0 8     0   9   58 48                 106
1799484 1799484 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2020   grade_7 3 0 8   0 0     0   1   10 2                       12 3 0 8   0 0     0   1   10 2                 12
1799486 1799486 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2020   grade_9 1 0 3   1 0     0   0   3 2                       5 1 0 3   1 0     0   0   3 2                 5
1799490 1799490 CO     school 806900 20   Adams 12 Five Star Schools 80690001619 301 Arapahoe Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_3 37 0 38   0 3     0   3   39 42                       81 37 0 38   0 3     0   3   39 42                 81
1799495 1799495 CO     school 806900 20   Adams 12 Five Star Schools 80690001619 301 Arapahoe Ridge Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 27 0 15   0 12     0   0   31 23                       54 27 0 15   0 12     0   0   31 23                 54
1799496 1799496 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   grade_1 25 0 45   0 2     0   1   36 37                       73 25 0 45   0 2     0   1   36 37                 73
1799498 1799498 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   grade_3 26 0 38   0 2     0   0   28 38                       66 26 0 38   0 2     0   0   28 38                 66
1799499 1799499 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   grade_4 24 0 28   1 1     0   2   20 36                       56 24 0 28   1 1     0   2   20 36                 56
1799501 1799501 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 30 0 41   1 2     0   2   35 41                       76 30 0 41   1 2     0   2   35 41                 76
1799503 1799503 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 27 0 40   1 4     0   2   45 29                       74 27 0 40   1 4     0   2   45 29                 74
1799512 1799512 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_2 55 0 12   0 22     0   11   47 53                       100 55 0 12   0 22     0   11   47 53                 100
1799513 1799513 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_3 58 0 11   0 26     0   5   49 51                       100 58 0 11   0 26     0   5   49 51                 100
1799514 1799514 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_4 68 0 11   0 16     0   5   51 49                       100 68 0 11   0 16     0   5   51 49                 100
1799515 1799515 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_5 57 0 12   1 22     0   8   52 48                       100 57 0 12   1 22     0   8   52 48                 100
1799518 1799518 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_8 88 0 16   1 23     0   6   54 80                       134 88 0 16   1 23     0   6   54 80                 134
1799524 1799524 CO     school 806900 20   Adams 12 Five Star Schools 80690001174 1878 Coronado Hills Elementary School   Regular School No Elementary PK 05 2020   grade_3 8 0 68   0 1     0   2   42 37                       79 8 0 68   0 1     0   2   42 37                 79
1799534 1799534 CO     school 806900 20   Adams 12 Five Star Schools 80690001305 1914 Cotton Creek Elementary School   Regular School No Elementary KG 05 2020   grade_5 58 0 17   1 7     0   4   52 35                       87 58 0 17   1 7     0   4   52 35                 87
1799538 1799538 CO     school 806900 20   Adams 12 Five Star Schools 80690001668 1937 Coyote Ridge Elementary School   Regular School No Elementary KG 05 2020   grade_2 52 0 10   0 8     1   2   37 36                       73 52 0 10   0 8     1   2   37 36                 73
1799539 1799539 CO     school 806900 20   Adams 12 Five Star Schools 80690001668 1937 Coyote Ridge Elementary School   Regular School No Elementary KG 05 2020   grade_3 52 0 9   0 5     0   4   36 34                       70 52 0 9   0 5     0   4   36 34                 70
1799540 1799540 CO     school 806900 20   Adams 12 Five Star Schools 80690001668 1937 Coyote Ridge Elementary School   Regular School No Elementary KG 05 2020   grade_4 66 0 3   0 3     0   2   32 42                       74 66 0 3   0 3     0   2   32 42                 74
1799541 1799541 CO     school 806900 20   Adams 12 Five Star Schools 80690001668 1937 Coyote Ridge Elementary School   Regular School No Elementary KG 05 2020   grade_5 60 0 8   0 6     0   7   46 35                       81 60 0 8   0 6     0   7   46 35                 81
1799549 1799549 CO     school 806900 20   Adams 12 Five Star Schools 80690001622 2361 Eagleview Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 50 0 15   0 7     0   1   41 32                       73 50 0 15   0 7     0   1   41 32                 73
1799551 1799551 CO     school 806900 20   Adams 12 Five Star Schools 80690001175 2410 Tarver Elementary School   Regular School No Elementary PK 05 2020   grade_1 40 0 19   0 3     0   1   28 35                       63 40 0 19   0 3     0   1   28 35                 63
1799554 1799554 CO     school 806900 20   Adams 12 Five Star Schools 80690001175 2410 Tarver Elementary School   Regular School No Elementary PK 05 2020   grade_4 40 0 23   0 3     0   4   36 34                       70 40 0 23   0 3     0   4   36 34                 70
1799556 1799556 CO     school 806900 20   Adams 12 Five Star Schools 80690001175 2410 Tarver Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 42 0 17   0 3     0   3   34 31                       65 42 0 17   0 3     0   3   34 31                 65
1799558 1799558 CO     school 806900 20   Adams 12 Five Star Schools 80690001175 2410 Tarver Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 16 0 28   0 4     0   6   28 26                       54 16 0 28   0 4     0   6   28 26                 54
1799559 1799559 CO     school 806900 20   Adams 12 Five Star Schools 80690001290 2576 Cherry Drive Elementary School   Regular School No Elementary PK 05 2020   grade_1 19 0 24   0 2     0   0   19 26                       45 19 0 24   0 2     0   0   19 26                 45
1799560 1799560 CO     school 806900 20   Adams 12 Five Star Schools 80690001290 2576 Cherry Drive Elementary School   Regular School No Elementary PK 05 2020   grade_2 30 0 23   0 1     0   1   28 27                       55 30 0 23   0 1     0   1   28 27                 55
1799561 1799561 CO     school 806900 20   Adams 12 Five Star Schools 80690001290 2576 Cherry Drive Elementary School   Regular School No Elementary PK 05 2020   grade_3 25 0 22   0 0     0   0   28 19                       47 25 0 22   0 0     0   0   28 19                 47
1799563 1799563 CO     school 806900 20   Adams 12 Five Star Schools 80690001290 2576 Cherry Drive Elementary School   Regular School No Elementary PK 05 2020   grade_5 27 0 19   1 4     0   0   30 21                       51 27 0 19   1 4     0   0   30 21                 51
1799564 1799564 CO     school 806900 20   Adams 12 Five Star Schools 80690001290 2576 Cherry Drive Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 25 0 17   0 4     0   3   26 23                       49 25 0 17   0 4     0   3   26 23                 49
1799569 1799569 CO     school 806900 20   Adams 12 Five Star Schools 80690001401 2578 Skyview Elementary School   Regular School No Elementary KG 05 2020   grade_3 46 0 32   1 3     0   1   47 36                       83 46 0 32   1 3     0   1   47 36                 83
1799571 1799571 CO     school 806900 20   Adams 12 Five Star Schools 80690001401 2578 Skyview Elementary School   Regular School No Elementary KG 05 2020   grade_5 31 0 39   1 2     0   0   42 31                       73 31 0 39   1 2     0   0   42 31                 73

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