Data source: Big Local News · About: Big Local

1,916 rows where grade = "pk_12_total", state = "CO" and year = 2020 sorted by ccd_charter_school

View and edit SQL

year

  • 2020 · 1,916

grade

  • pk_12_total · 1,916
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
1799307 CO     school   10   Mapleton 1   0 Not a school             2020   pk_12_total 8 1 8   1 0     0   0   14 4                       18 8 1 8   1 0     0   0   14 4                 18
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
1800144 CO     school   70   Westminster Public Schools   0 Not a school             2020   pk_12_total 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1801024 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   pk_12_total 4 2 9   0 2     0   2   12 7                       19 4 2 9   0 2     0   2   12 7                 19
1805584 CO     school   1010   Colorado Springs 11   0 Not a school             2020   pk_12_total 9 0 3   0 0     0   2   6 8                       14 9 0 3   0 0     0   2   6 8                 14
1806751 CO     school   1140   Canon City RE-1   0 Not a school             2020   pk_12_total 9 0 5   0 0     0   1   2 13                       15 9 0 5   0 0     0   1   2 13                 15
1807199 CO     school   1420   Jefferson County R-1   0 Not a school             2020   pk_12_total 9 0 4   2 0     0   1   11 5                       16 9 0 4   2 0     0   1   11 5                 16
1808556 CO     school   1520   Durango 9-R   0 Not a school             2020   pk_12_total 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1808701 CO     school   1550   Poudre R-1   0 Not a school             2020   pk_12_total 15 0 7   1 0     0   4   21 6                       27 15 0 7   1 0     0   4   21 6                 27
1809632 CO     school   2000   Mesa County Valley 51   355 The Learning Tree             2020   pk_12_total 12 0 6   0 0     0   1   9 10                       19 12 0 6   0 0     0   1   9 10                 19
1809634 CO     school   2000   Mesa County Valley 51   356 Razz Ma Tazz             2020   pk_12_total 19 0 7   0 0     0   1   13 14                       27 19 0 7   0 0     0   1   13 14                 27
1809636 CO     school   2000   Mesa County Valley 51   357 Crossroads Academy Preschool             2020   pk_12_total 4 0 2   0 0     0   0   4 2                       6 4 0 2   0 0     0   0   4 2                 6
1810633 CO     school   2690   Pueblo City 60   0 Not a school             2020   pk_12_total 14 3 23   1 0     0   0   18 23                       41 14 3 23   1 0     0   0   18 23                 41
1812626 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   pk_12_total 79 39 119   3 8     0   13   219 42                       261 79 39 119   3 8     0   13   219 42                 261
1799314 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2020   pk_12_total 119 17 529   11 8     1   17   336 366                       702 119 17 529   11 8     1   17   336 366                 702
1799319 CO     school 805550 10   Mapleton 1 80555001858 212 Mapleton Early College High School   Regular School No High 09 12 2020   pk_12_total 50 1 199   2 10     1   3   116 150                       266 50 1 199   2 10     1   3   116 150                 266
1799324 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2020   pk_12_total 8 2 247   0 4     0   5   138 128                       266 8 2 247   0 4     0   5   138 128                 266
1799329 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   pk_12_total 44 5 397   1 5     0   15   260 207                       467 44 5 397   1 5     0   15   260 207                 467
1799339 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   pk_12_total 41 2 317   0 10     0   3   163 210                       373 41 2 317   0 10     0   3   163 210                 373
1799349 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   pk_12_total 76 9 390   1 17     0   10   260 243                       503 76 9 390   1 17     0   10   260 243                 503
1799364 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   pk_12_total 61 11 678   1 25     0   17   405 388                       793 61 11 678   1 25     0   17   405 388                 793
1799372 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   pk_12_total 67 3 303   3 8     0   3   172 215                       387 67 3 303   3 8     0   3   172 215                 387
1799383 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   pk_12_total 58 10 428   2 14     0   14   257 269                       526 58 10 428   2 14     0   14   257 269                 526
1799392 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   pk_12_total 116 6 280   3 4     3   13   230 195                       425 116 6 280   3 4     3   13   230 195                 425
1799401 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   pk_12_total 44 3 365   3 4     1   8   212 216                       428 44 3 365   3 4     1   8   212 216                 428
1799412 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   pk_12_total 62 13 372   0 19     0   8   237 237                       474 62 13 372   0 19     0   8   237 237                 474
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
1799431 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   pk_12_total 1432 102 528   17 27     8   160   1049 1225                       2274 1432 102 528   17 27     8   160   1049 1225                 2274
1799437 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2020   pk_12_total 16 4 254   2 2     0   2   144 136                       280 16 4 254   2 2     0   2   144 136                 280
1799442 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2020   pk_12_total 41 4 229   0 5     0   10   146 143                       289 41 4 229   0 5     0   10   146 143                 289
1799445 CO     school 805550 10   Mapleton 1 80555006433 6315 North Valley School for Young Adults   Alternative School No High 09 12 2020   pk_12_total 13 1 49   0 0     0   1   41 23                       64 13 1 49   0 0     0   1   41 23                 64
1799455 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   pk_12_total 104 2 353   2 8     0   9   236 242                       478 104 2 353   2 8     0   9   236 242                 478
1799467 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 209 5 174   1 34     0   21   240 204                       444 209 5 174   1 34     0   21   240 204                 444
1799471 CO     school 806900 20   Adams 12 Five Star Schools 80690001726 57 Rocky Top Middle School   Regular School No Middle 06 08 2020   pk_12_total 734 16 231   6 76     2   55   562 558                       1120 734 16 231   6 76     2   55   562 558                 1120
1799478 CO     school 806900 20   Adams 12 Five Star Schools 80690001733 59 Meridian Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 433 6 86   2 39     3   40   336 273                       609 433 6 86   2 39     3   40   336 273                 609
1799479 CO     school 806900 20   Adams 12 Five Star Schools 80690006435 70 Adams12 Five Star Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total 52 3 135   0 15     0   2   121 86                       207 52 3 135   0 15     0   2   121 86                 207
1799487 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2020   pk_12_total 121 9 235   7 8     1   2   232 151                       383 121 9 235   7 8     1   2   232 151                 383
1799494 CO     school 806900 20   Adams 12 Five Star Schools 80690001619 301 Arapahoe Ridge Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 273 8 233   2 38     2   19   305 270                       575 273 8 233   2 38     2   19   305 270                 575
1799502 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 194 2 276   3 13     0   9   244 253                       497 194 2 276   3 13     0   9   244 253                 497
1799507 CO     school 806900 20   Adams 12 Five Star Schools 80690001620 1480 Century Middle School   Regular School No Middle 06 08 2020   pk_12_total 515 19 300   7 50     0   27   475 443                       918 515 19 300   7 50     0   27   475 443                 918
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
1799536 CO     school 806900 20   Adams 12 Five Star Schools 80690001305 1914 Cotton Creek Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 375 8 110   4 32     0   27   288 268                       556 375 8 110   4 32     0   27   288 268                 556
1799543 CO     school 806900 20   Adams 12 Five Star Schools 80690001668 1937 Coyote Ridge Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 320 2 51   0 27     1   27   208 220                       428 320 2 51   0 27     1   27   208 220                 428
1799550 CO     school 806900 20   Adams 12 Five Star Schools 80690001622 2361 Eagleview Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 338 10 146   1 42     2   22   296 265                       561 338 10 146   1 42     2   22   296 265                 561
1799557 CO     school 806900 20   Adams 12 Five Star Schools 80690001175 2410 Tarver Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 279 4 146   2 21     0   23   243 232                       475 279 4 146   2 21     0   23   243 232                 475
1799565 CO     school 806900 20   Adams 12 Five Star Schools 80690001290 2576 Cherry Drive Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 186 2 160   1 17     0   9   211 164                       375 186 2 160   1 17     0   9   211 164                 375
1799573 CO     school 806900 20   Adams 12 Five Star Schools 80690001401 2578 Skyview Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 198 4 203   2 16     0   8   231 200                       431 198 4 203   2 16     0   8   231 200                 431
1799580 CO     school 806900 20   Adams 12 Five Star Schools 80690001419 2580 Hunters Glen Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 251 17 169   3 16     1   14   232 239                       471 251 17 169   3 16     1   14   232 239                 471
1799588 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 78 11 277   3 5     0   12   202 184                       386 78 11 277   3 5     0   12   202 184                 386
1799595 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 205 4 218   3 15     0   15   256 204                       460 205 4 218   3 15     0   15   256 204                 460
1799603 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 28 0 468   0 4     0   2   246 256                       502 28 0 468   0 4     0   2   246 256                 502
1799611 CO     school 806900 20   Adams 12 Five Star Schools 80690001177 4000 Hillcrest Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 74 14 317   0 19     0   9   237 196                       433 74 14 317   0 19     0   9   237 196                 433
1799616 CO     school 806900 20   Adams 12 Five Star Schools 80690001491 4108 Horizon High School   Regular School No High 09 12 2020   pk_12_total 1250 45 569   6 131     2   56   1016 1043                       2059 1250 45 569   6 131     2   56   1016 1043                 2059
1799626 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   pk_12_total 412 14 84   3 108     1   56   333 345                       678 412 14 84   3 108     1   56   333 345                 678
1799630 CO     school 806900 20   Adams 12 Five Star Schools 80690001179 4187 Silver Hills Middle School   Regular School No Middle 06 08 2020   pk_12_total 375 19 614   7 44     1   28   541 547                       1088 375 19 614   7 44     1   28   541 547                 1088
1799640 CO     school 806900 20   Adams 12 Five Star Schools 80690001784 5043 Legacy High School   Regular School No High 09 12 2020   pk_12_total 1595 31 536   8 197     3   75   1284 1161                       2445 1595 31 536   8 197     3   75   1284 1161                 2445
1799647 CO     school 806900 20   Adams 12 Five Star Schools 80690001306 5058 Leroy Drive Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 117 15 230   1 13     1   16   215 178                       393 117 15 230   1 13     1   16   215 178                 393
1799654 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 154 6 260   2 7     0   15   238 206                       444 154 6 260   2 7     0   15   238 206                 444
1799662 CO     school 806900 20   Adams 12 Five Star Schools 80690001182 5706 McElwain Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 65 18 298   3 39     1   7   211 220                       431 65 18 298   3 39     1   7   211 220                 431
1799666 CO     school 806900 20   Adams 12 Five Star Schools 80690001183 5814 The International School at Thornton Middle   Regular School No Middle 06 08 2020   pk_12_total 125 47 785   5 17     2   13   543 451                       994 125 47 785   5 17     2   13   543 451                 994
1799671 CO     school 806900 20   Adams 12 Five Star Schools 80690001192 5816 Thornton High School   Regular School No High 09 12 2020   pk_12_total 318 61 1115   16 77     1   20   821 787                       1608 318 61 1115   16 77     1   20   821 787                 1608
1799676 CO     school 806900 20   Adams 12 Five Star Schools 80690001996 6060 Mountain Range High School   Regular School No High 09 12 2020   pk_12_total 982 37 720   14 84     7   48   929 963                       1892 982 37 720   14 84     7   48   929 963                 1892
1799683 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 389 0 136   2 34     0   37   326 272                       598 389 0 136   2 34     0   37   326 272                 598
1799688 CO     school 806900 20   Adams 12 Five Star Schools 80690001186 6342 Shadow Ridge Middle School   Regular School No Middle 06 08 2020   pk_12_total 426 7 367   2 38     1   25   464 402                       866 426 7 367   2 38     1   25   464 402                 866
1799695 CO     school 806900 20   Adams 12 Five Star Schools 80690001184 6355 North Mor Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 110 10 298   0 17     1   15   235 216                       451 110 10 298   0 17     1   15   235 216                 451
1799703 CO     school 806900 20   Adams 12 Five Star Schools 80690001185 6376 North Star Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 47 22 326   2 7     3   11   209 209                       418 47 22 326   2 7     3   11   209 209                 418
1799708 CO     school 806900 20   Adams 12 Five Star Schools 80690001187 6398 Northglenn Middle School   Regular School No Middle 06 08 2020   pk_12_total 189 16 617   3 14     0   17   479 377                       856 189 16 617   3 14     0   17   479 377                 856
1799713 CO     school 806900 20   Adams 12 Five Star Schools 80690001188 6402 Northglenn High School   Regular School No High 09 12 2020   pk_12_total 524 43 1373   13 87     1   23   1095 969                       2064 524 43 1373   13 87     1   23   1095 969                 2064
1799735 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2020   pk_12_total 98 7 188   3 4     0   4   191 113                       304 98 7 188   3 4     0   4   191 113                 304
1799742 CO     school 806900 20   Adams 12 Five Star Schools 80690001945 7155 Prairie Hills Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 349 5 79   2 35     1   24   261 234                       495 349 5 79   2 35     1   24   261 234                 495
1799749 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2020   pk_12_total 408 5 123   1 42     2   24   320 285                       605 408 5 123   1 42     2   24   320 285                 605
1799756 CO     school 806900 20   Adams 12 Five Star Schools 80690006375 8211 The Studio School   Regular School No Elementary KG 05 2020   pk_12_total 151 6 92   3 4     0   21   102 175                       277 151 6 92   3 4     0   21   102 175                 277
1799763 CO     school 806900 20   Adams 12 Five Star Schools 80690006303 8225 Stellar Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 199 9 247   6 25     0   27   250 263                       513 199 9 247   6 25     0   27   250 263                 513
1799773 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   pk_12_total 471 9 155   2 40     0   40   398 319                       717 471 9 155   2 40     0   40   398 319                 717
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
1799791 CO     school 806900 20   Adams 12 Five Star Schools 80690001190 8361 Stukey Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 96 10 250   6 17     1   12   210 182                       392 96 10 250   6 17     1   12   210 182                 392
1799801 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   pk_12_total 581 5 67   1 56     3   34   396 351                       747 581 5 67   1 56     3   34   396 351                 747
1799809 CO     school 806900 20   Adams 12 Five Star Schools 80690001191 8842 Thornton Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 86 13 296   3 8     0   7   220 193                       413 86 13 296   3 8     0   7   220 193                 413
1799828 CO     school 806900 20   Adams 12 Five Star Schools 80690001194 9444 Westlake Middle School   Regular School No Middle 06 08 2020   pk_12_total 718 12 271   10 46     4   40   570 531                       1101 718 12 271   10 46     4   40   570 531                 1101
1799835 CO     school 806900 20   Adams 12 Five Star Schools 80690001195 9494 Westview Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 169 12 217   3 20     0   23   238 206                       444 169 12 217   3 20     0   23   238 206                 444
1799843 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 214 5 215   7 20     1   20   245 237                       482 214 5 215   7 20     1   20   245 237                 482
1799848 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2020   pk_12_total 68 9 675   8 1     1   11   397 376                       773 68 9 675   8 1     1   11   397 376                 773
1799853 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2020   pk_12_total 33 5 211   2 0     0   2   137 116                       253 33 5 211   2 0     0   2   137 116                 253
1799858 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2020   pk_12_total 140 33 1514   7 6     3   18   870 851                       1721 140 33 1514   7 6     3   18   870 851                 1721
1799859 CO     school 801950 30   Adams County 14 80195001947 124 Stars Early Learning Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 11 0 76   1 0     0   2   45 45                       90 11 0 76   1 0     0   2   45 45                 90
1799867 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 56 4 344   2 0     2   7   223 192                       415 56 4 344   2 0     2   7   223 192                 415
1799874 CO     school 801950 30   Adams County 14 80195000012 1426 Central Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 46 35 351   1 1     1   7   244 198                       442 46 35 351   1 1     1   7   244 198                 442
1799881 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 44 7 416   3 2     0   5   254 223                       477 44 7 416   3 2     0   5   254 223                 477
1799885 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2020   pk_12_total 79 16 692   3 1     1   2   428 366                       794 79 16 692   3 1     1   2   428 366                 794
1799892 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 49 8 440   1 0     0   3   248 253                       501 49 8 440   1 0     0   3   248 253                 501
1799894 CO     school 801950 30   Adams County 14 80195000404 5880 Mildred L Sanville Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total 2 3 76   0 0     0   2   43 40                       83 2 3 76   0 0     0   2   43 40                 83
1799902 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 34 7 244   0 0     0   2   156 131                       287 34 7 244   0 0     0   2   156 131                 287
1799909 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 19 5 366   2 0     0   3   204 191                       395 19 5 366   2 0     0   3   204 191                 395
1799917 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 43 4 324   2 2     0   4   219 160                       379 43 4 324   2 2     0   4   219 160                 379
1799935 CO     school 802580 40   School District 27J 80258006549 1013 Brantner Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 413 7 195   2 50     0   26   344 349                       693 413 7 195   2 50     0   26   344 349                 693
1799943 CO     school 802580 40   School District 27J 80258000729 1021 Innovations & Options   Alternative School No High 06 12 2020   pk_12_total 107 4 168   2 3     0   9   175 118                       293 107 4 168   2 3     0   9   175 118                 293
1799948 CO     school 802580 40   School District 27J 80258000144 1022 Brighton High School   Regular School No High 09 12 2020   pk_12_total 754 16 962   9 16     5   54   921 895                       1816 754 16 962   9 16     5   54   921 895                 1816
1799980 CO     school 802580 40   School District 27J 80258000146 3900 Henderson Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 138 7 195   1 6     2   13   200 162                       362 138 7 195   1 6     2   13   200 162                 362
1799998 CO     school 802580 40   School District 27J 80258001949 5615 Mary E Pennock Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 261 12 348   1 5     2   14   322 321                       643 261 12 348   1 5     2   14   322 321                 643
1800006 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 54 2 225   4 2     0   2   156 133                       289 54 2 225   4 2     0   2   156 133                 289

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