Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1804606 CO     school 803450 900   Douglas County Re 1 80345001437 3980 Highlands Ranch High School   Regular School No High 09 12 2020   pk_12_total 1193 36 260   6 98     3   84   891 789                       1680 1193 36 260   6 98     3   84   891 789                 1680
1804936 CO     school 803450 900   Douglas County Re 1 80345001529 8847 Thunderridge High School   Regular School No High 09 12 2020   pk_12_total 1560 17 243   7 97     4   114   1036 1006                       2042 1560 17 243   7 97     4   114   1036 1006                 2042
1802063 CO     school 805370 470   St Vrain Valley RE1J 80537001814 7789 Silver Creek High School   Regular School No High 09 12 2020   pk_12_total 1021 12 177   2 95     1   41   658 691                       1349 1021 12 177   2 95     1   41   658 691                 1349
1804264 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2020   pk_12_total 242 2 112   3 93     2   39   242 251                       493 242 2 112   3 93     2   39   242 251                 493
1800404 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 375 46 96   4 91     0   45   341 316                       657 375 46 96   4 91     0   45   341 316                 657
1800596 CO     school 802910 130   Cherry Creek 5 80291001625 3589 Grandview High School   Regular School No High 09 12 2020   grade_10 431 60 110   6 91     4   45   393 354                       747 431 60 110   6 91     4   45   393 354                 747
1799465 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   grade_5 35 2 34   0 9     0   5   47 38                       85 35 2 34   0 9     0   5   47 38                 85
1799476 CO     school 806900 20   Adams 12 Five Star Schools 80690001733 59 Meridian Elementary School   Regular School No Elementary KG 05 2020   grade_5 78 2 19   1 9     2   6   72 45                       117 78 2 19   1 9     2   6   72 45                 117
1799489 CO     school 806900 20   Adams 12 Five Star Schools 80690001619 301 Arapahoe Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_2 32 1 36   0 9     0   1   48 31                       79 32 1 36   0 9     0   1   48 31                 79
1799528 CO     school 806900 20   Adams 12 Five Star Schools 80690001174 1878 Coronado Hills Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 81 13 466   2 9     0   7   314 264                       578 81 13 466   2 9     0   7   314 264                 578
1799546 CO     school 806900 20   Adams 12 Five Star Schools 80690001622 2361 Eagleview Elementary School   Regular School No Elementary KG 05 2020   grade_3 50 1 27   1 9     0   5   57 36                       93 50 1 27   1 9     0   5   57 36                 93
1799547 CO     school 806900 20   Adams 12 Five Star Schools 80690001622 2361 Eagleview Elementary School   Regular School No Elementary KG 05 2020   grade_4 54 1 21   0 9     2   2   50 39                       89 54 1 21   0 9     2   2   50 39                 89
1799623 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_7 42 0 10   0 9     0   9   29 41                       70 42 0 10   0 9     0   9   29 41                 70
1799716 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_11 77 1 6   1 9     0   3   50 47                       97 77 1 6   1 9     0   3   50 47                 97
1799724 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_8 90 0 21   1 9     0   9   57 73                       130 90 0 21   1 9     0   9   57 73                 130
1799725 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_9 88 1 17   1 9     0   7   60 63                       123 88 1 17   1 9     0   7   60 63                 123
1799748 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2020   kindergarten_full_day 71 0 7   0 9     0   2   48 41                       89 71 0 7   0 9     0   2   48 41                 89
1799784 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   pk_12_total 148 6 614   3 9     0   11   425 366                       791 148 6 614   3 9     0   11   425 366                 791
1799932 CO     school 802580 40   School District 27J 80258006549 1013 Brantner Elementary School   Regular School No Elementary PK 05 2020   grade_4 57 2 31   0 9     0   3   52 50                       102 57 2 31   0 9     0   3   52 50                 102
1799958 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 730 8 395   3 9     2   34   600 581                       1181 730 8 395   3 9     2   34   600 581                 1181
1799963 CO     school 802580 40   School District 27J 80258006474 2399 Eagle Ridge Academy   Regular School Yes High 09 12 2020   pk_12_total 254 10 235   0 9     1   13   251 271                       522 254 10 235   0 9     1   13   251 271                 522
1800021 CO     school 802580 40   School District 27J 80258006420 6702 Otho E Stuart Middle School   Regular School No Middle 06 08 2020   grade_7 105 20 115   0 9     0   17   141 125                       266 105 20 115   0 9     0   17   141 125                 266
1800088 CO     school 802580 40   School District 27J 80258006401 8820 Turnberry Elementary   Regular School No Elementary PK 05 2020   kindergarten_full_day 43 5 56   0 9     0   1   64 50                       114 43 5 56   0 9     0   1   64 50                 114
1800098 CO     school 802580 40   School District 27J 80258006326 9426 West Ridge Elementary   Regular School No Elementary PK 05 2020   grade_4 76 0 27   0 9     0   3   57 58                       115 76 0 27   0 9     0   3   57 58                 115
1800102 CO     school 802580 40   School District 27J 80258006326 9426 West Ridge Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 22 1 19   0 9     0   1   28 24                       52 22 1 19   0 9     0   1   28 24                 52
1800152 CO     school 807230 70   Westminster Public Schools 80723001232 1622 Metropolitan Arts Academy   Regular School No Elementary PK 06 2020   pk_12_total 46 5 261   2 9     2   7   167 165                       332 46 5 261   2 9     2   7   167 165                 332
1800259 CO     school 807230 70   Westminster Public Schools 80723001249 8798 Tennyson Knolls Elementary School   Regular School No Elementary PK 05 2020   grade_2 8 0 41   1 9     0   0   31 28                       59 8 0 41   1 9     0   0   31 28                 59
1800365 CO     school 803780 120   Englewood 1 80378000029 5318 Englewood Early Childhood Education Center at Maddox   Regular School No Prekindergarten PK PK 2020   pk_12_total 114 7 90   0 9     0   10   117 113                       230 114 7 90   0 9     0   10   117 113                 230
1800366 CO     school 803780 120   Englewood 1 80378000029 5318 Englewood Early Childhood Education Center at Maddox   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 114 7 90   0 9     0   10   117 113                       230 114 7 90   0 9     0   10   117 113                 230
1800405 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 38 4 10   0 9     0   4   35 30                       65 38 4 10   0 9     0   4   35 30                 65
1800429 CO     school 802910 130   Cherry Creek 5 80291001670 242 Antelope Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_4 61 11 27   0 9     0   10   66 52                       118 61 11 27   0 9     0   10   66 52                 118
1800464 CO     school 802910 130   Cherry Creek 5 80291006301 1155 Buffalo Trail Elementary School   Regular School No Elementary PK 06 2020   grade_2 51 10 19   0 9     0   14   56 47                       103 51 10 19   0 9     0   14   56 47                 103
1800559 CO     school 802910 130   Cherry Creek 5 80291001671 2094 Dakota Valley Elementary School   Regular School No Elementary PK 05 2020   grade_4 57 5 25   2 9     0   8   51 55                       106 57 5 25   2 9     0   8   51 55                 106
1800610 CO     school 802910 130   Cherry Creek 5 80291000193 3926 Heritage Elementary School   Regular School No Elementary PK 05 2020   grade_3 38 1 8   0 9     1   1   26 32                       58 38 1 8   0 9     1   1   26 32                 58
1800697 CO     school 802910 130   Cherry Creek 5 80291006607 6225 Mountain Vista Elementary School   Regular School No Elementary PK 05 2020   grade_1 61 17 16   1 9     0   10   62 52                       114 61 17 16   1 9     0   10   62 52                 114
1800719 CO     school 802910 130   Cherry Creek 5 80291006617 6475 Outback Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total 33 12 22   0 9     0   3   41 38                       79 33 12 22   0 9     0   3   41 38                 79
1800720 CO     school 802910 130   Cherry Creek 5 80291006617 6475 Outback Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 33 12 22   0 9     0   3   41 38                       79 33 12 22   0 9     0   3   41 38                 79
1800738 CO     school 802910 130   Cherry Creek 5 80291006452 6955 Pine Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_5 95 4 19   1 9     0   10   71 67                       138 95 4 19   1 9     0   10   71 67                 138
1800750 CO     school 802910 130   Cherry Creek 5 80291000200 7116 Ponderosa Elementary School   Regular School No Elementary PK 05 2020   grade_2 22 31 38   2 9     0   5   60 47                       107 22 31 38   2 9     0   5   60 47                 107
1800829 CO     school 802910 130   Cherry Creek 5 80291000204 9108 Village East Community Elementary School   Regular School No Elementary PK 05 2020   grade_2 27 39 48   0 9     0   6   64 65                       129 27 39 48   0 9     0   6   64 65                 129
1800915 CO     school 805310 140   Littleton 6 80531000884 5224 Littleton High School   Regular School No High 09 12 2020   grade_9 189 9 93   0 9     1   17   154 164                       318 189 9 93   0 9     1   17   154 164                 318
1800968 CO     school 805310 140   Littleton 6 80531000887 6814 Peabody Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 305 4 38   0 9     1   22   206 173                       379 305 4 38   0 9     1   22   206 173                 379
1800982 CO     school 805310 140   Littleton 6 80531000889 7606 Sandburg Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 394 0 21   2 9     0   15   235 206                       441 394 0 21   2 9     0   15   235 206                 441
1801142 CO     school 802340 180   Adams-Arapahoe 28J 80234000058 1948 Crawford Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 3 4 18   0 9     0   1   19 16                       35 3 4 18   0 9     0   1   19 16                 35
1801234 CO     school 802340 180   Adams-Arapahoe 28J 80234000067 4646 Kenton Elementary School   Regular School No Elementary PK 05 2020   grade_3 4 8 61   0 9     0   4   50 36                       86 4 8 61   0 9     0   4   50 36                 86
1801349 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_5 35 6 6   0 9     1   3   24 36                       60 35 6 6   0 9     1   3   24 36                 60
1801353 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   kindergarten_full_day 21 5 7   0 9     0   8   18 32                       50 21 5 7   0 9     0   8   18 32                 50
1801376 CO     school 802340 180   Adams-Arapahoe 28J 80234001432 7865 Side Creek Elementary School   Regular School No Elementary PK 05 2020   grade_1 16 18 19   1 9     1   9   38 35                       73 16 18 19   1 9     1   9   38 35                 73
1801394 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2020   grade_8 16 49 186   4 9     4   16   156 128                       284 16 49 186   4 9     4   16   156 128                 284
1801485 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2020   grade_9 5 11 102   0 9     0   3   58 72                       130 5 11 102   0 9     0   3   58 72                 130
1801769 CO     school 805370 470   St Vrain Valley RE1J 80537006381 878 Blue Mountain Elementary   Regular School No Elementary PK 05 2020   grade_3 85 0 4   0 9     0   6   58 46                       104 85 0 4   0 9     0   6   58 46                 104
1801770 CO     school 805370 470   St Vrain Valley RE1J 80537006381 878 Blue Mountain Elementary   Regular School No Elementary PK 05 2020   grade_4 87 1 10   0 9     0   9   68 48                       116 87 1 10   0 9     0   9   68 48                 116
1801853 CO     school 805370 470   St Vrain Valley RE1J 80537001890 2964 Flagstaff Charter Academy   Regular School Yes Elementary PK 08 2020   grade_4 72 1 16   0 9     0   5   44 59                       103 72 1 16   0 9     0   5   44 59                 103
1801903 CO     school 805370 470   St Vrain Valley RE1J 80537000904 4278 Indian Peaks Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 30 0 270   0 9     2   0   168 143                       311 30 0 270   0 9     2   0   168 143                 311
1801935 CO     school 805370 470   St Vrain Valley RE1J 80537000907 5284 Longmont Estates Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 255 4 83   2 9     0   5   187 171                       358 255 4 83   2 9     0   5   187 171                 358
1801963 CO     school 805370 470   St Vrain Valley RE1J 80537006423 5722 Mead High School   Regular School No High 09 12 2020   grade_11 210 2 70   0 9     1   2   144 150                       294 210 2 70   0 9     1   2   144 150                 294
1802088 CO     school 805370 470   St Vrain Valley RE1J 80537001891 8903 Trail Ridge Middle School   Regular School No Middle 06 08 2020   pk_12_total 243 9 392   4 9     2   21   375 305                       680 243 9 392   4 9     2   21   375 305                 680
1802118 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2020   grade_7 103 3 18   1 9     0   4   85 53                       138 103 3 18   1 9     0   4   85 53                 138
1802175 CO     school 802490 480   Boulder Valley Re 2 80249000104 1136 Manhattan Middle School of the Arts and Academics   Regular School No Middle 06 08 2020   grade_8 120 0 46   1 9     1   10   89 98                       187 120 0 46   1 9     1   10   89 98                 187
1802179 CO     school 802490 480   Boulder Valley Re 2 80249000106 1352 Casey Middle School   Regular School No Middle 06 08 2020   grade_8 132 0 96   1 9     0   10   122 126                       248 132 0 96   1 9     0   10   122 126                 248
1802187 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2020   grade_7 135 1 44   1 9     0   10   107 93                       200 135 1 44   1 9     0   10   107 93                 200
1802188 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2020   grade_8 151 0 47   1 9     0   13   116 105                       221 151 0 47   1 9     0   13   116 105                 221
1802304 CO     school 802490 480   Boulder Valley Re 2 80249000118 3882 Heatherwood Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 242 5 25   0 9     0   13   164 130                       294 242 5 25   0 9     0   13   164 130                 294
1802306 CO     school 802490 480   Boulder Valley Re 2 80249001243 3940 High Peaks Elementary School   Regular School No Elementary KG 05 2020   grade_1 27 2 3   0 9     0   7   22 26                       48 27 2 3   0 9     0   7   22 26                 48
1802334 CO     school 802490 480   Boulder Valley Re 2 80249000120 4792 Kohl Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 267 5 71   0 9     2   30   193 191                       384 267 5 71   0 9     2   30   193 191                 384
1802375 CO     school 802490 480   Boulder Valley Re 2 80249000129 5838 Mesa Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 222 0 15   1 9     0   14   118 143                       261 222 0 15   1 9     0   14   118 143                 261
1802384 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_4 34 1 10   0 9     0   5   33 26                       59 34 1 10   0 9     0   5   33 26                 59
1802385 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_5 48 1 4   0 9     0   3   28 37                       65 48 1 4   0 9     0   3   28 37                 65
1802432 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2020   grade_3 56 0 6   0 9     0   7   36 42                       78 56 0 6   0 9     0   7   36 42                 78
1802433 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2020   grade_4 62 0 3   0 9     0   5   39 40                       79 62 0 3   0 9     0   5   39 40                 79
1802434 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2020   grade_5 56 1 10   0 9     0   2   44 34                       78 56 1 10   0 9     0   2   44 34                 78
1802467 CO     school 802490 480   Boulder Valley Re 2 80249000134 8135 Southern Hills Middle School   Regular School No Middle 06 08 2020   grade_8 160 1 10   0 9     0   12   97 95                       192 160 1 10   0 9     0   12   97 95                 192
1802474 CO     school 802490 480   Boulder Valley Re 2 80249001518 8418 Superior Elementary School   Regular School No Elementary KG 05 2020   grade_2 52 0 4   0 9     0   4   33 36                       69 52 0 4   0 9     0   4   33 36                 69
1802940 CO     school 803360 880   Denver County 1 80336000318 1056 Bromwell Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 243 10 39   1 9     0   30   170 162                       332 243 10 39   1 9     0   30   170 162                 332
1802950 CO     school 803360 880   Denver County 1 80336006682 1077 Bear Valley International School   Regular School No Middle 06 08 2020   grade_6 15 3 119   1 9     0   5   85 67                       152 15 3 119   1 9     0   5   85 67                 152
1803390 CO     school 803360 880   Denver County 1 80336001776 3641 Green Valley Elementary School   Regular School No Elementary PK 05 2020   grade_1 13 22 43   1 9     1   3   56 36                       92 13 22 43   1 9     1   3   56 36                 92
1803395 CO     school 803360 880   Denver County 1 80336001776 3641 Green Valley Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 7 19 60   1 9     3   4   56 47                       103 7 19 60   1 9     3   4   56 47                 103
1803397 CO     school 803360 880   Denver County 1 80336001776 3641 Green Valley Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 7 11 41   1 9     0   2   33 38                       71 7 11 41   1 9     0   2   33 38                 71
1803472 CO     school 803360 880   Denver County 1 80336006609 4049 Highline Academy Northeast   Regular School Yes Elementary PK 05 2020   grade_3 14 26 30   0 9     0   5   47 37                       84 14 26 30   0 9     0   5   47 37                 84
1803502 CO     school 803360 880   Denver County 1 80336006570 4213 Isabella Bird Community School   Regular School No Elementary PK 05 2020   kindergarten_full_day 42 9 9   2 9     0   7   40 38                       78 42 9 9   2 9     0   7   40 38                 78
1803512 CO     school 803360 880   Denver County 1 80336006554 4381 DSST: College View Middle School   Regular School Yes Middle 06 08 2020   grade_6 5 3 139   1 9     0   2   80 79                       159 5 3 139   1 9     0   2   80 79                 159
1803570 CO     school 803360 880   Denver County 1 80336006686 4513 Kepner Beacon Middle School   Regular School No Middle 06 08 2020   pk_12_total 22 22 341   3 9     0   1   210 188                       398 22 22 341   3 9     0   1   210 188                 398
1803648 CO     school 803360 880   Denver County 1 80336001380 5578 Marrama Elementary School   Regular School No Elementary PK 05 2020   grade_3 6 19 46   0 9     0   2   37 45                       82 6 19 46   0 9     0   2   37 45                 82
1803658 CO     school 803360 880   Denver County 1 80336001406 5605 Dr. Martin Luther King Jr. Early College   Regular School No High 06 12 2020   grade_7 6 39 95   0 9     0   4   77 76                       153 6 39 95   0 9     0   4   77 76                 153
1803722 CO     school 803360 880   Denver County 1 80336006562 5897 McAuliffe International School   Regular School No Middle 06 08 2020   grade_8 340 63 63   3 9     1   44   289 234                       523 340 63 63   3 9     1   44   289 234                 523
1803745 CO     school 803360 880   Denver County 1 80336000385 6088 Dora Moore ECE-8 School   Regular School No Elementary PK 08 2020   pk_12_total 103 63 144   6 9     1   26   171 181                       352 103 63 144   6 9     1   26   171 181                 352
1803805 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   pk_12_total 140 1 259   2 9     0   12   204 219                       423 140 1 259   2 9     0   12   204 219                 423
1803821 CO     school 803360 880   Denver County 1 80336001838 6508 Omar D Blair Charter School   Regular School Yes Elementary KG 08 2020   grade_5 5 49 27   0 9     4   5   46 53                       99 5 49 27   0 9     4   5   46 53                 99
1803831 CO     school 803360 880   Denver County 1 80336001955 6509 Denver Online High School   Regular School No High 09 12 2020   pk_12_total 139 21 98   2 9     1   17   115 172                       287 139 21 98   2 9     1   17   115 172                 287
1804088 CO     school 803360 880   Denver County 1 80336000415 8776 Teller Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 374 49 54   2 9     2   39   279 250                       529 374 49 54   2 9     2   39   279 250                 529
1804258 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2020   grade_2 27 1 16   0 9     0   3   28 28                       56 27 1 16   0 9     0   3   28 28                 56
1804259 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2020   grade_3 35 1 14   1 9     0   6   31 35                       66 35 1 14   1 9     0   6   31 35                 66
1804328 CO     school 803450 900   Douglas County Re 1 80345006371 267 Mesa Middle School   Regular School No Middle 07 08 2020   grade_8 305 2 69   2 9     2   35   215 209                       424 305 2 69   2 9     2   35   215 209                 424
1804369 CO     school 803450 900   Douglas County Re 1 80345001918 1367 Castle View High School   Regular School No High 09 12 2020   grade_11 429 8 85   4 9     0   24   295 264                       559 429 8 85   4 9     0   24   295 264                 559
1804465 CO     school 803450 900   Douglas County Re 1 80345000438 2226 Castle Rock Middle School   Regular School No Middle 07 08 2020   grade_8 326 5 75   1 9     0   21   241 196                       437 326 5 75   1 9     0   21   241 196                 437
1804642 CO     school 803450 900   Douglas County Re 1 80345001960 5045 Legacy Point Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 48 0 5   0 9     0   1   36 27                       63 48 0 5   0 9     0   1   36 27                 63
1804760 CO     school 803450 900   Douglas County Re 1 80345001339 6406 Northridge Elementary School   Regular School No Elementary PK 06 2020   kindergarten_full_day 45 0 8   0 9     0   2   44 20                       64 45 0 8   0 9     0   2   44 20                 64
1804808 CO     school 803450 900   Douglas County Re 1 80345001584 7047 Platte River Charter Academy   Regular School Yes Elementary KG 08 2020   grade_1 42 1 3   0 9     0   3   30 28                       58 42 1 3   0 9     0   3   30 28                 58
1804831 CO     school 803450 900   Douglas County Re 1 80345001809 7134 Prairie Crossing Elementary School   Regular School No Elementary PK 06 2020   grade_3 70 0 12   0 9     0   6   51 46                       97 70 0 12   0 9     0   6   51 46                 97
1804852 CO     school 803450 900   Douglas County Re 1 80345001900 7297 Redstone Elementary School   Regular School No Elementary PK 06 2020   grade_4 69 2 10   0 9     0   3   52 41                       93 69 2 10   0 9     0   3   52 41                 93

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