Data source: Big Local News · About: Big Local

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

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
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
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
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
1802859 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   pk_12_total 29 39 858   12 28     0   5   526 445                       971 29 39 858   12 28     0   5   526 445                 971
1804256 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 602 11 78   3 17     0   34   347 398                       745 602 11 78   3 17     0   34   347 398                 745
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
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
1812208 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   pk_12_total 1100 15 531   1 143     1   95   937 949                       1886 1100 15 531   1 143     1   95   937 949                 1886
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
1806073 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 301 8 58   1 10     0   37   199 216                       415 301 8 58   1 10     0   37   199 216                 415
1800409 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2020   pk_12_total 558 97 195   4 119     2   81   545 511                       1056 558 97 195   4 119     2   81   545 511                 1056
1806081 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 315 17 60   3 67     5   54   250 271                       521 315 17 60   3 67     5   54   250 271                 521
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
1810868 CO     school 806150 2700   Pueblo County 70 80615001714 25 Sky View Middle School   Regular School No Middle 06 08 2020   pk_12_total 394 1 225   2 3     0   38   354 309                       663 394 1 225   2 3     0   38   354 309                 663
1810875 CO     school 806150 2700   Pueblo County 70 80615001718 26 Desert Sage Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 209 1 169   0 5     0   21   222 183                       405 209 1 169   0 5     0   21   222 183                 405
1807207 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 225 14 97   1 25     0   19   208 173                       381 225 14 97   1 25     0   19   208 173                 381
1807213 CO     school 804800 1420   Jefferson County R-1 80480006163 33 McLain Community High School   Alternative School No High 07 12 2020   pk_12_total 251 5 114   2 2     1   17   247 145                       392 251 5 114   2 2     1   17   247 145                 392
1804979 CO     school 803540 910   Eagle County RE 50 80354001721 37 Red Hill Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 119 2 225   2 0     0   7   194 161                       355 119 2 225   2 0     0   7   194 161                 355
1804987 CO     school 803540 910   Eagle County RE 50 80354001722 38 Brush Creek Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 315 0 60   1 1     0   12   206 183                       389 315 0 60   1 1     0   12   206 183                 389
1804992 CO     school 803540 910   Eagle County RE 50 80354001723 39 Gypsum Creek Middle School   Regular School No Middle 06 08 2020   pk_12_total 95 0 275   3 2     0   3   199 179                       378 95 0 275   3 2     0   3   199 179                 378
1802865 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2020   pk_12_total 35 20 47   1 0     2   4   109 0                       109 35 20 47   1 0     2   4   109 0                 109
1810538 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 121 0 6   1 5     1   1   67 68                       135 121 0 6   1 5     1   1   67 68                 135
1805207 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 27 0 5   0 0     0   0   19 13                       32 27 0 5   0 0     0   0   19 13                 32
1805214 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   pk_12_total 11 0 1   0 0     0   0   6 6                       12 11 0 1   0 0     0   0   6 6                 12
1811257 CO     school 802850 2810   Center 26 JT 80285002008 51 The Academic Recovery Center of San Luis Valley   Alternative School No High 09 12 2020   pk_12_total 0 0 4   1 0     0   0   4 1                       5 0 0 4   1 0     0   0   4 1                 5
1811783 CO     school 804410 3120   Greeley 6 80441001988 52 Heiman Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 265 10 394   3 15     2   19   381 327                       708 265 10 394   3 15     2   19   381 327                 708
1811793 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   pk_12_total 211 3 434   0 4     0   18   345 325                       670 211 3 434   0 4     0   18   345 325                 670
1811803 CO     school 804410 3120   Greeley 6 80441001990 54 Bella Romero Academy of Applied Technology   Regular School No Elementary KG 08 2020   pk_12_total 127 88 909   2 12     3   6   633 514                       1147 127 88 909   2 12     3   6   633 514                 1147
1811672 CO     school 807350 3100   Windsor RE-4 80735001987 55 Grandview Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 515 6 67   2 5     1   18   324 290                       614 515 6 67   2 5     1   18   324 290                 614
1810364 CO     school 804110 2540   Fowler R-4J 80411001981 56 Fowler Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 136 4 48   0 0     0   6   100 94                       194 136 4 48   0 0     0   6   100 94                 194
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
1809407 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 34 0 32   0 0     0   3   36 33                       69 34 0 32   0 0     0   3   36 33                 69
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
1801721 CO     school 805370 470   St Vrain Valley RE1J 80537001830 60 Legacy Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 379 3 110   3 13     1   19   284 244                       528 379 3 110   3 13     1   19   284 244                 528
1801728 CO     school 805370 470   St Vrain Valley RE1J 80537001832 61 Alpine Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 251 9 183   1 13     0   18   271 204                       475 251 9 183   1 13     0   18   271 204                 475
1807149 CO     school 807080 1390   Huerfano Re-1 80708001845 63 Peakview School   Regular School No Elementary PK 08 2020   pk_12_total 102 4 196   7 4     2   0   179 136                       315 102 4 196   7 4     2   0   179 136                 315
1806944 CO     school 806240 1195   Garfield Re-2 80624001906 65 Coal Ridge High School   Regular School No High 09 12 2020   pk_12_total 274 3 272   0 3     0   11   279 284                       563 274 3 272   0 3     0   11   279 284                 563
1809416 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   pk_12_total 19 0 32   0 0     0   1   29 23                       52 19 0 32   0 0     0   1   29 23                 52
1802870 CO     school 803360 880   Denver County 1 80336001894 67 Academy of Urban Learning   Alternative School Yes High 09 12 2020   pk_12_total 7 7 116   2 0     0   3   80 55                       135 7 7 116   2 0     0   3   80 55                 135
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
1801740 CO     school 805370 470   St Vrain Valley RE1J 80537006530 71 Aspen Ridge Preparatory School   Regular School Yes Elementary KG 08 2020   pk_12_total 346 2 42   0 30     0   19   220 219                       439 346 2 42   0 30     0   19   220 219                 439
1806085 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   pk_12_total 501 18 84   3 55     2   57   378 342                       720 501 18 84   3 55     2   57   378 342                 720
1812214 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2020   pk_12_total 160 0 34   6 2     1   5   106 102                       208 160 0 34   6 2     1   5   106 102                 208
1806090 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   pk_12_total 1005 46 190   4 56     1   101   715 688                       1403 1005 46 190   4 56     1   101   715 688                 1403
1804278 CO     school 803450 900   Douglas County Re 1 80345006760 79 Ascent Classical Academy   Regular School Yes Other KG 11 2020   pk_12_total 443 6 52   2 22     0   19   269 275                       544 443 6 52   2 22     0   19   269 275                 544
1811489 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   pk_12_total 208 0 57   2 1     0   16   148 136                       284 208 0 57   2 1     0   16   148 136                 284
1811495 CO     school 802040 3030   Akron R-1 80204000025 90 Akron High School   Regular School No High 09 12 2020   pk_12_total 67 1 14   0 2     0   3   48 39                       87 67 1 14   0 2     0   3   48 39                 87
1802877 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   pk_12_total 35 63 101   1 1     1   6   92 116                       208 35 63 101   1 1     1   6   92 116                 208
1806481 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2020   pk_12_total 77 5 23   1 0     1   14   56 65                       121 77 5 23   1 0     1   14   56 65                 121
1800416 CO     school 802910 130   Cherry Creek 5 80291006750 102 Altitude Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 500 36 112   7 67     3   54   397 382                       779 500 36 112   7 67     3   54   397 382                 779
1807220 CO     school 804800 1420   Jefferson County R-1 80480000691 108 Alameda International Junior/Senior High School   Regular School No High 07 12 2020   pk_12_total 143 9 871   9 57     1   27   593 524                       1117 143 9 871   9 57     1   27   593 524                 1117
1807230 CO     school 804800 1420   Jefferson County R-1 80480006489 109 Arvada K-8   Regular School No Elementary KG 08 2020   pk_12_total 204 27 380   8 8     3   22   345 307                       652 204 27 380   8 8     3   22   345 307                 652
1806095 CO     school 801920 1040   Academy 20 80192006434 110 Village High School   Regular School No High 09 12 2020   pk_12_total 179 4 22   0 2     0   7   113 101                       214 179 4 22   0 2     0   7   113 101                 214
1800287 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2020   pk_12_total 141 5 353   4 6     3   7   261 258                       519 141 5 353   4 6     3   7   261 258                 519
1800294 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 328 14 750   14 2     5   29   603 539                       1142 328 14 750   14 2     5   29   603 539                 1142
1800299 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2020   pk_12_total 186 4 385   10 8     1   6   290 310                       600 186 4 385   10 8     1   6   290 310                 600
1801754 CO     school 805370 470   St Vrain Valley RE1J 80537006539 120 Apex Home School Enrichment Program   Regular School No Other KG 12 2020   pk_12_total 660 6 85   4 15     0   34   414 390                       804 660 6 85   4 15     0   34   414 390                 804
1801029 CO     school 802340 180   Adams-Arapahoe 28J 80234006771 122 Aurora Community School   Regular School Yes Elementary KG 06 2020   pk_12_total 13 36 41   0 0     0   14   46 58                       104 13 36 41   0 0     0   14   46 58                 104
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
1802111 CO     school 802490 480   Boulder Valley Re 2 80249001219 125 Arapahoe Ridge High School   Alternative School No High 09 12 2020   pk_12_total 50 2 89   3 3     0   3   92 58                       150 50 2 89   3 3     0   3   92 58                 150
1801039 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   pk_12_total 60 179 459   4 5     3   48   376 382                       758 60 179 459   4 5     3   48   376 382                 758
1801041 CO     school 802340 180   Adams-Arapahoe 28J 80234006787 127 Aurora Science & Tech Middle School   Regular School Yes Middle 06 06 2020   pk_12_total 17 21 110   0 4     2   12   93 73                       166 17 21 110   0 4     2   12   93 73                 166
1804289 CO     school 803450 900   Douglas County Re 1 80345006492 135 Ben Franklin Academy   Regular School Yes Elementary PK 08 2020   pk_12_total 718 11 99   5 53     1   43   475 455                       930 718 11 99   5 53     1   43   475 455                 930
1801042 CO     school 802340 180   Adams-Arapahoe 28J 80234006625 136 APS Early Beginnings - A Zoom Site   Regular School No Prekindergarten PK PK 2020   pk_12_total 0 7 24   0 0     0   4   17 18                       35 0 7 24   0 0     0   4   17 18                 35
1802495 CO     school 802640 490   Buena Vista R-31 80264006767 137 The Grove, BVSD's Early Learning Program   Regular School No Prekindergarten PK PK 2020   pk_12_total 84 0 9   1 1     0   4   59 40                       99 84 0 9   1 1     0   4   59 40                 99
1800421 CO     school 802910 130   Cherry Creek 5 80291001878 141 Sky Vista Middle School   Regular School No Middle 06 08 2020   pk_12_total 437 140 190   2 76     0   84   498 431                       929 437 140 190   2 76     0   84   498 431                 929
1808715 CO     school 803990 1550   Poudre R-1 80399001717 146 Ridgeview Classical Charter Schools   Regular School Yes Other KG 12 2020   pk_12_total 550 6 67   2 28     3   34   316 374                       690 550 6 67   2 28     3   34   316 374                 690
1807237 CO     school 804800 1420   Jefferson County R-1 80480000692 148 Allendale Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 97 7 59   1 0     0   4   97 71                       168 97 7 59   1 0     0   4   97 71                 168
1812218 CO     school 800020 8001   Charter School Institute 80002006777 149 Colorado Early Colleges Fort Collins West   Regular School Yes Middle 06 08 2020   pk_12_total 27 0 7   0 0     0   1   18 17                       35 27 0 7   0 0     0   1   18 17                 35
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
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
1800425 CO     school 802910 130   Cherry Creek 5 80291006770 188 Colorado Skies Academy   Regular School Yes Middle 06 08 2020   pk_12_total 85 10 13   1 4     0   5   81 37                       118 85 10 13   1 4     0   5   81 37                 118
1810580 CO     school 805220 2660   Lamar Re-2 80522000860 200 Alta Vista Charter School   Regular School Yes Elementary KG 06 2020   pk_12_total 77 1 50   1 0     0   3   59 73                       132 77 1 50   1 0     0   3   59 73                 132
1804293 CO     school 803450 900   Douglas County Re 1 80345006218 201 Daniel C Oakes High School--Castle Rock   Alternative School No High 09 12 2020   pk_12_total 119 2 27   2 1     0   7   91 67                       158 119 2 27   2 1     0   7   91 67                 158
1805511 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2020   pk_12_total 36 7 29   1 0     3   8   50 34                       84 36 7 29   1 0     3   8   50 34                 84
1804997 CO     school 803540 910   Eagle County RE 50 80354001756 205 Red Canyon High School   Alternative School No High 09 12 2020   pk_12_total 68 2 111   2 0     0   6   121 68                       189 68 2 111   2 0     0   6   121 68                 189
1800328 CO     school 803780 120   Englewood 1 80378001310 206 Colorado's Finest High School of Choice   Alternative School No High 09 12 2020   pk_12_total 183 6 101   1 0     0   8   166 133                       299 183 6 101   1 0     0   8   166 133                 299
1806102 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   pk_12_total 114 6 30   2 2     0   5   97 62                       159 114 6 30   2 2     0   5   97 62                 159
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
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
1801053 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   pk_12_total 100 132 168   4 5     5   31   231 214                       445 100 132 168   4 5     5   31   231 214                 445
1801061 CO     school 802340 180   Adams-Arapahoe 28J 80234000052 214 Altura Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 33 38 412   3 18     1   16   272 249                       521 33 38 412   3 18     1   16   272 249                 521
1804304 CO     school 803450 900   Douglas County Re 1 80345001896 215 American Academy   Regular School Yes Elementary PK 08 2020   pk_12_total 1757 15 173   12 406     0   172   1295 1240                       2535 1757 15 173   12 406     0   172   1295 1240                 2535
1802885 CO     school 803360 880   Denver County 1 80336000306 220 John H. Amesse Elementary   Regular School No Elementary PK 05 2020   pk_12_total 16 62 355   0 2     2   5   240 202                       442 16 62 355   0 2     2   5   240 202                 442
1808563 CO     school 803480 1520   Durango 9-R 80348001066 225 Animas Valley Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 166 2 56   17 0     0   7   139 109                       248 166 2 56   17 0     0   7   139 109                 248
1801758 CO     school 805370 470   St Vrain Valley RE1J 80537001886 226 Altona Middle School   Regular School No Middle 06 08 2020   pk_12_total 582 13 136   2 64     0   33   425 405                       830 582 13 136   2 64     0   33   425 405                 830
1800432 CO     school 802910 130   Cherry Creek 5 80291001670 242 Antelope Ridge Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 386 48 136   3 40     2   40   336 319                       655 386 48 136   3 40     2   40   336 319                 655
1800439 CO     school 802910 130   Cherry Creek 5 80291002032 243 Coyote Hills Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 365 30 70   0 47     0   53   285 280                       565 365 30 70   0 47     0   53   285 280                 565
1802667 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2020   pk_12_total 9 0 75   0 0     0   0   46 38                       84 9 0 75   0 0     0   0   46 38                 84
1806109 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 255 11 36   3 14     0   18   177 160                       337 255 11 36   3 14     0   18   177 160                 337
1802671 CO     school 802130 580   South Conejos RE-10 80213001464 250 Antonito Middle School   Regular School No Middle 07 08 2020   pk_12_total 1 0 19   0 0     0   0   7 13                       20 1 0 19   0 0     0   0   7 13                 20

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