Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 13,186
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
1750183 CO     school 806870 2830   Telluride R-1 80687006699 8811 Telluride Elementary School   Regular School No Elementary PK 02 2021   grade_1 43 1 8   0 0     0   0   28 24                       52 43 1 8   0 0     0   0   28 24                 52
1750184 CO     school 806870 2830   Telluride R-1 80687006699 8811 Telluride Elementary School   Regular School No Elementary PK 02 2021   grade_2 40 0 15   1 0     0   0   29 27                       56 40 0 15   1 0     0   0   29 27                 56
1750185 CO     school 806870 2830   Telluride R-1 80687006699 8811 Telluride Elementary School   Regular School No Elementary PK 02 2021   kindergarten_full_day 38 0 23   1 1     0   0   32 31                       63 38 0 23   1 1     0   0   32 31                 63
1750186 CO     school 806870 2830   Telluride R-1 80687006699 8811 Telluride Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 121 1 46   2 1     0   0   89 82                       171 121 1 46   2 1     0   0   89 82                 171
1750474 CO     school 803600 3085   Eaton RE-2 80360000474 2448 Eaton Elementary School   Regular School No Elementary PK 02 2021   grade_1 97 0 30   0 0     0   2   65 64                       129 97 0 30   0 0     0   2   65 64                 129
1750475 CO     school 803600 3085   Eaton RE-2 80360000474 2448 Eaton Elementary School   Regular School No Elementary PK 02 2021   grade_2 94 0 30   2 2     0   0   61 67                       128 94 0 30   2 2     0   0   61 67                 128
1750476 CO     school 803600 3085   Eaton RE-2 80360000474 2448 Eaton Elementary School   Regular School No Elementary PK 02 2021   kindergarten_full_day 95 0 39   0 0     0   4   67 71                       138 95 0 39   0 0     0   4   67 71                 138
1750477 CO     school 803600 3085   Eaton RE-2 80360000474 2448 Eaton Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 286 0 99   2 2     0   6   193 202                       395 286 0 99   2 2     0   6   193 202                 395
1750529 CO     school 804920 3090   Weld County School District RE-3J 80492006743 5855 Meadow Ridge Elementary School   Regular School No Elementary PK 02 2021   grade_1 51 1 53   0 0     0   2   64 43                       107 51 1 53   0 0     0   2   64 43                 107
1750530 CO     school 804920 3090   Weld County School District RE-3J 80492006743 5855 Meadow Ridge Elementary School   Regular School No Elementary PK 02 2021   grade_2 44 0 65   1 2     0   3   62 53                       115 44 0 65   1 2     0   3   62 53                 115
1750531 CO     school 804920 3090   Weld County School District RE-3J 80492006743 5855 Meadow Ridge Elementary School   Regular School No Elementary PK 02 2021   kindergarten_full_day 32 1 56   0 1     0   1   37 54                       91 32 1 56   0 1     0   1   37 54                 91
1750532 CO     school 804920 3090   Weld County School District RE-3J 80492006743 5855 Meadow Ridge Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 176 5 208   1 3     0   6   207 192                       399 176 5 208   1 3     0   6   207 192                 399
1750533 CO     school 804920 3090   Weld County School District RE-3J 80492006743 5855 Meadow Ridge Elementary School   Regular School No Elementary PK 02 2021   pre_kindergarten 49 3 34   0 0     0   0   44 42                       86 49 3 34   0 0     0   0   44 42                 86
1750576 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2021   grade_1 109 2 20   0 1     1   4   81 56                       137 109 2 20   0 1     1   4   81 56                 137
1750577 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2021   grade_2 92 0 34   0 1     0   2   50 79                       129 92 0 34   0 1     0   2   50 79                 129
1750578 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2021   kindergarten_full_day 69 0 20   0 0     0   4   41 52                       93 69 0 20   0 0     0   4   41 52                 93
1750579 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2021   kindergarten_half_day 12 0 3   0 0     0   1   11 5                       16 12 0 3   0 0     0   1   11 5                 16
1750580 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2021   pk_12_total 321 2 81   0 2     1   11   208 210                       418 321 2 81   0 2     1   11   208 210                 418
1750581 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2021   pre_kindergarten 39 0 4   0 0     0   0   25 18                       43 39 0 4   0 0     0   0   25 18                 43
1738383 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   grade_1 6 0 47   0 2     0   1   26 30                       56 6 0 47   0 2     0   1   26 30                 56
1738384 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   grade_2 2 0 41   0 1     0   0   25 19                       44 2 0 41   0 1     0   0   25 19                 44
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
1738387 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   pk_12_total 28 3 225   0 4     0   9   139 130                       269 28 3 225   0 4     0   9   139 130                 269
1738388 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   pre_kindergarten 15 2 47   0 1     0   6   38 33                       71 15 2 47   0 1     0   6   38 33                 71
1739048 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   grade_1 43 4 31   0 0     1   5   50 34                       84 43 4 31   0 0     1   5   50 34                 84
1739049 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   grade_2 40 1 25   0 0     1   3   37 33                       70 40 1 25   0 0     1   3   37 33                 70
1739050 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   grade_3 37 0 31   0 0     1   5   39 35                       74 37 0 31   0 0     1   5   39 35                 74
1739051 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   kindergarten_full_day 42 1 32   0 0     1   3   38 41                       79 42 1 32   0 0     1   3   38 41                 79
1739052 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   pk_12_total 162 6 119   0 0     4   16   164 143                       307 162 6 119   0 0     4   16   164 143                 307
1749614 CO     school 806120 2690   Pueblo City 60 80612006378 2620 Fountain International Magnet School   Regular School No Elementary PK 03 2021   grade_1 35 2 50   0 2     0   2   42 49                       91 35 2 50   0 2     0   2   42 49                 91
1749615 CO     school 806120 2690   Pueblo City 60 80612006378 2620 Fountain International Magnet School   Regular School No Elementary PK 03 2021   grade_2 26 0 52   0 3     1   6   42 46                       88 26 0 52   0 3     1   6   42 46                 88
1749616 CO     school 806120 2690   Pueblo City 60 80612006378 2620 Fountain International Magnet School   Regular School No Elementary PK 03 2021   grade_3 32 1 41   0 2     1   6   40 43                       83 32 1 41   0 2     1   6   40 43                 83
1749617 CO     school 806120 2690   Pueblo City 60 80612006378 2620 Fountain International Magnet School   Regular School No Elementary PK 03 2021   kindergarten_full_day 25 0 44   0 2     0   7   38 40                       78 25 0 44   0 2     0   7   38 40                 78
1749618 CO     school 806120 2690   Pueblo City 60 80612006378 2620 Fountain International Magnet School   Regular School No Elementary PK 03 2021   pk_12_total 118 3 187   0 9     2   21   162 178                       340 118 3 187   0 9     2   21   162 178                 340
1740528 CO     school 802190 220   Archuleta County 50 Jt 80219000038 6652 Pagosa Springs Elementary School   Regular School No Elementary KG 04 2021   grade_1 67 0 29   5 1     0   3   45 60                       105 67 0 29   5 1     0   3   45 60                 105
1740529 CO     school 802190 220   Archuleta County 50 Jt 80219000038 6652 Pagosa Springs Elementary School   Regular School No Elementary KG 04 2021   grade_2 52 0 37   10 0     0   0   52 47                       99 52 0 37   10 0     0   0   52 47                 99
1740530 CO     school 802190 220   Archuleta County 50 Jt 80219000038 6652 Pagosa Springs Elementary School   Regular School No Elementary KG 04 2021   grade_3 45 0 39   11 1     0   2   48 50                       98 45 0 39   11 1     0   2   48 50                 98
1740531 CO     school 802190 220   Archuleta County 50 Jt 80219000038 6652 Pagosa Springs Elementary School   Regular School No Elementary KG 04 2021   grade_4 67 1 37   11 1     0   2   63 56                       119 67 1 37   11 1     0   2   63 56                 119
1740532 CO     school 802190 220   Archuleta County 50 Jt 80219000038 6652 Pagosa Springs Elementary School   Regular School No Elementary KG 04 2021   kindergarten_full_day 43 0 29   3 0     0   2   46 31                       77 43 0 29   3 0     0   2   46 31                 77
1740533 CO     school 802190 220   Archuleta County 50 Jt 80219000038 6652 Pagosa Springs Elementary School   Regular School No Elementary KG 04 2021   kindergarten_half_day 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
1740534 CO     school 802190 220   Archuleta County 50 Jt 80219000038 6652 Pagosa Springs Elementary School   Regular School No Elementary KG 04 2021   pk_12_total 276 1 171   40 3     0   9   254 246                       500 276 1 171   40 3     0   9   254 246                 500
1740958 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2021   grade_1 22 0 28   0 0     0   1   25 26                       51 22 0 28   0 0     0   1   25 26                 51
1740959 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2021   grade_2 18 1 17   0 1     0   2   23 16                       39 18 1 17   0 1     0   2   23 16                 39
1740960 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2021   grade_3 14 0 28   0 0     0   1   23 20                       43 14 0 28   0 0     0   1   23 20                 43
1740961 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2021   grade_4 16 0 29   1 0     0   2   25 23                       48 16 0 29   1 0     0   2   25 23                 48
1740962 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2021   kindergarten_full_day 25 0 28   0 1     0   1   35 20                       55 25 0 28   0 1     0   1   35 20                 55
1740963 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 111 1 158   1 5     0   9   161 124                       285 111 1 158   1 5     0   9   161 124                 285
1740964 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten 16 0 28   0 3     0   2   30 19                       49 16 0 28   0 3     0   2   30 19                 49
1741505 CO     school 806330 500   Salida R-32 80633001108 5268 Longfellow Elementary School   Regular School No Elementary KG 04 2021   grade_1 74 1 11   2 0     0   0   41 47                       88 74 1 11   2 0     0   0   41 47                 88
1741506 CO     school 806330 500   Salida R-32 80633001108 5268 Longfellow Elementary School   Regular School No Elementary KG 04 2021   grade_2 60 1 12   1 1     0   5   46 34                       80 60 1 12   1 1     0   5   46 34                 80
1741507 CO     school 806330 500   Salida R-32 80633001108 5268 Longfellow Elementary School   Regular School No Elementary KG 04 2021   grade_3 70 0 8   0 0     0   3   41 40                       81 70 0 8   0 0     0   3   41 40                 81
1741508 CO     school 806330 500   Salida R-32 80633001108 5268 Longfellow Elementary School   Regular School No Elementary KG 04 2021   grade_4 66 1 19   0 1     0   6   48 45                       93 66 1 19   0 1     0   6   48 45                 93
1741509 CO     school 806330 500   Salida R-32 80633001108 5268 Longfellow Elementary School   Regular School No Elementary KG 04 2021   kindergarten_full_day 63 0 9   0 0     0   4   41 35                       76 63 0 9   0 0     0   4   41 35                 76
1741510 CO     school 806330 500   Salida R-32 80633001108 5268 Longfellow Elementary School   Regular School No Elementary KG 04 2021   pk_12_total 333 3 59   3 2     0   18   217 201                       418 333 3 59   3 2     0   18   217 201                 418
1742530 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   grade_1 4 28 46   0 2     0   5   41 44                       85 4 28 46   0 2     0   5   41 44                 85
1742531 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   grade_2 11 32 54   0 5     4   7   52 61                       113 11 32 54   0 5     4   7   52 61                 113
1742532 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   grade_3 2 18 53   0 5     2   5   38 47                       85 2 18 53   0 5     2   5   38 47                 85
1742533 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   grade_4 5 25 48   0 3     0   4   47 38                       85 5 25 48   0 3     0   4   47 38                 85
1742534 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   kindergarten_full_day 2 22 55   0 4     0   1   41 43                       84 2 22 55   0 4     0   1   41 43                 84
1742535 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   pk_12_total 30 138 281   0 20     6   23   243 255                       498 30 138 281   0 20     6   23   243 255                 498
1742536 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   pre_kindergarten 6 13 25   0 1     0   1   24 22                       46 6 13 25   0 1     0   1   24 22                 46
1745776 CO     school 804260 1180   Roaring Fork RE-1 80426000582 560 Basalt Elementary School   Regular School No Elementary PK 04 2021   grade_1 42 0 49   0 0     0   1   48 44                       92 42 0 49   0 0     0   1   48 44                 92
1745777 CO     school 804260 1180   Roaring Fork RE-1 80426000582 560 Basalt Elementary School   Regular School No Elementary PK 04 2021   grade_2 28 0 53   0 0     0   0   41 40                       81 28 0 53   0 0     0   0   41 40                 81
1745778 CO     school 804260 1180   Roaring Fork RE-1 80426000582 560 Basalt Elementary School   Regular School No Elementary PK 04 2021   grade_3 24 1 60   0 1     0   1   44 43                       87 24 1 60   0 1     0   1   44 43                 87
1745779 CO     school 804260 1180   Roaring Fork RE-1 80426000582 560 Basalt Elementary School   Regular School No Elementary PK 04 2021   grade_4 41 0 68   1 1     0   0   59 52                       111 41 0 68   1 1     0   0   59 52                 111
1745780 CO     school 804260 1180   Roaring Fork RE-1 80426000582 560 Basalt Elementary School   Regular School No Elementary PK 04 2021   kindergarten_full_day 33 0 48   0 1     0   3   46 39                       85 33 0 48   0 1     0   3   46 39                 85
1745781 CO     school 804260 1180   Roaring Fork RE-1 80426000582 560 Basalt Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 174 1 315   1 3     0   5   265 234                       499 174 1 315   1 3     0   5   265 234                 499
1745782 CO     school 804260 1180   Roaring Fork RE-1 80426000582 560 Basalt Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten 6 0 37   0 0     0   0   27 16                       43 6 0 37   0 0     0   0   27 16                 43
1745803 CO     school 804260 1180   Roaring Fork RE-1 80426001540 2063 Crystal River Elementary School   Regular School No Elementary PK 04 2021   grade_1 21 0 39   0 0     0   0   27 33                       60 21 0 39   0 0     0   0   27 33                 60
1745804 CO     school 804260 1180   Roaring Fork RE-1 80426001540 2063 Crystal River Elementary School   Regular School No Elementary PK 04 2021   grade_2 25 0 41   0 1     0   2   35 34                       69 25 0 41   0 1     0   2   35 34                 69
1745805 CO     school 804260 1180   Roaring Fork RE-1 80426001540 2063 Crystal River Elementary School   Regular School No Elementary PK 04 2021   grade_3 18 1 47   2 0     0   0   39 29                       68 18 1 47   2 0     0   0   39 29                 68
1745806 CO     school 804260 1180   Roaring Fork RE-1 80426001540 2063 Crystal River Elementary School   Regular School No Elementary PK 04 2021   grade_4 11 0 45   0 1     0   1   19 39                       58 11 0 45   0 1     0   1   19 39                 58
1745807 CO     school 804260 1180   Roaring Fork RE-1 80426001540 2063 Crystal River Elementary School   Regular School No Elementary PK 04 2021   kindergarten_full_day 17 0 33   0 0     0   0   29 21                       50 17 0 33   0 0     0   0   29 21                 50
1745808 CO     school 804260 1180   Roaring Fork RE-1 80426001540 2063 Crystal River Elementary School   Regular School No Elementary PK 04 2021   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1745809 CO     school 804260 1180   Roaring Fork RE-1 80426001540 2063 Crystal River Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 103 1 219   2 2     0   3   164 166                       330 103 1 219   2 2     0   3   164 166                 330
1745810 CO     school 804260 1180   Roaring Fork RE-1 80426001540 2063 Crystal River Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten 10 0 14   0 0     0   0   14 10                       24 10 0 14   0 0     0   0   14 10                 24
1746208 CO     school 804800 1420   Jefferson County R-1 80480006164 950 Bradford K8 South   Regular School No Elementary KG 04 2021   grade_1 74 0 4   0 1     0   7   46 40                       86 74 0 4   0 1     0   7   46 40                 86
1746209 CO     school 804800 1420   Jefferson County R-1 80480006164 950 Bradford K8 South   Regular School No Elementary KG 04 2021   grade_2 79 0 2   0 1     0   3   43 42                       85 79 0 2   0 1     0   3   43 42                 85
1746210 CO     school 804800 1420   Jefferson County R-1 80480006164 950 Bradford K8 South   Regular School No Elementary KG 04 2021   grade_3 69 0 5   0 1     0   4   32 47                       79 69 0 5   0 1     0   4   32 47                 79
1746211 CO     school 804800 1420   Jefferson County R-1 80480006164 950 Bradford K8 South   Regular School No Elementary KG 04 2021   grade_4 100 0 5   0 0     0   4   60 49                       109 100 0 5   0 0     0   4   60 49                 109
1746212 CO     school 804800 1420   Jefferson County R-1 80480006164 950 Bradford K8 South   Regular School No Elementary KG 04 2021   kindergarten_full_day 65 2 5   0 2     0   5   36 43                       79 65 2 5   0 2     0   5   36 43                 79
1746213 CO     school 804800 1420   Jefferson County R-1 80480006164 950 Bradford K8 South   Regular School No Elementary KG 04 2021   pk_12_total 387 2 21   0 5     0   23   217 221                       438 387 2 21   0 5     0   23   217 221                 438
1747402 CO     school 802670 1500   Burlington RE-6J 80267000160 1144 Burlington Elementary School   Regular School No Elementary PK 04 2021   grade_1 30 0 18   0 0     0   0   25 23                       48 30 0 18   0 0     0   0   25 23                 48
1747403 CO     school 802670 1500   Burlington RE-6J 80267000160 1144 Burlington Elementary School   Regular School No Elementary PK 04 2021   grade_2 35 0 21   0 0     0   1   31 26                       57 35 0 21   0 0     0   1   31 26                 57
1747404 CO     school 802670 1500   Burlington RE-6J 80267000160 1144 Burlington Elementary School   Regular School No Elementary PK 04 2021   grade_3 24 1 19   0 1     0   0   19 26                       45 24 1 19   0 1     0   0   19 26                 45
1747405 CO     school 802670 1500   Burlington RE-6J 80267000160 1144 Burlington Elementary School   Regular School No Elementary PK 04 2021   grade_4 33 0 23   2 0     0   0   19 39                       58 33 0 23   2 0     0   0   19 39                 58
1747406 CO     school 802670 1500   Burlington RE-6J 80267000160 1144 Burlington Elementary School   Regular School No Elementary PK 04 2021   kindergarten_full_day 31 1 20   0 0     0   0   28 24                       52 31 1 20   0 0     0   0   28 24                 52
1747407 CO     school 802670 1500   Burlington RE-6J 80267000160 1144 Burlington Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 196 3 129   3 1     0   1   161 172                       333 196 3 129   3 1     0   1   161 172                 333
1747408 CO     school 802670 1500   Burlington RE-6J 80267000160 1144 Burlington Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten 43 1 28   1 0     0   0   39 34                       73 43 1 28   1 0     0   0   39 34                 73
1749407 CO     school 802280 2640   Aspen 1 80228000045 428 Aspen Elementary School   Regular School No Elementary PK 04 2021   grade_1 76 1 11   0 0     1   0   42 47                       89 76 1 11   0 0     1   0   42 47                 89
1749408 CO     school 802280 2640   Aspen 1 80228000045 428 Aspen Elementary School   Regular School No Elementary PK 04 2021   grade_2 50 0 18   0 1     0   2   37 34                       71 50 0 18   0 1     0   2   37 34                 71
1749409 CO     school 802280 2640   Aspen 1 80228000045 428 Aspen Elementary School   Regular School No Elementary PK 04 2021   grade_3 83 0 15   0 1     0   1   52 48                       100 83 0 15   0 1     0   1   52 48                 100
1749410 CO     school 802280 2640   Aspen 1 80228000045 428 Aspen Elementary School   Regular School No Elementary PK 04 2021   grade_4 88 0 13   1 1     0   1   41 63                       104 88 0 13   1 1     0   1   41 63                 104
1749411 CO     school 802280 2640   Aspen 1 80228000045 428 Aspen Elementary School   Regular School No Elementary PK 04 2021   kindergarten_full_day 62 0 14   0 1     1   0   41 37                       78 62 0 14   0 1     1   0   41 37                 78
1749412 CO     school 802280 2640   Aspen 1 80228000045 428 Aspen Elementary School   Regular School No Elementary PK 04 2021   pk_12_total 359 1 71   1 4     2   4   213 229                       442 359 1 71   1 4     2   4   213 229                 442
1751022 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   grade_1 29 0 28   0 0     0   0   29 28                       57 29 0 28   0 0     0   0   29 28                 57
1751023 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   grade_2 28 0 36   0 0     0   0   35 29                       64 28 0 36   0 0     0   0   35 29                 64
1751024 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   grade_3 23 0 36   0 0     0   0   29 30                       59 23 0 36   0 0     0   0   29 30                 59
1751025 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   grade_4 26 0 39   0 0     0   0   26 39                       65 26 0 39   0 0     0   0   26 39                 65

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