Data source: Big Local News · About: Big Local

489 rows where grade = "grade_9", state = "CO" and year = 2020 sorted by total_int descending

View and edit SQL

year

  • 2020 · 489

grade

  • grade_9 · 489
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 ▲
1800508 CO     school 802910 130   Cherry Creek 5 80291000186 1570 Cherry Creek High School   Regular School No High 09 12 2020   grade_9 628 38 143   2 128     3   46   495 493                       988 628 38 143   2 128     3   46   495 493                 988
1800574 CO     school 802910 130   Cherry Creek 5 80291006156 2357 Eaglecrest High School   Regular School No High 09 12 2020   grade_9 378 112 178   7 65     2   54   413 383                       796 378 112 178   7 65     2   54   413 383                 796
1800599 CO     school 802910 130   Cherry Creek 5 80291001625 3589 Grandview High School   Regular School No High 09 12 2020   grade_9 436 69 108   7 102     3   57   401 381                       782 436 69 108   7 102     3   57   401 381                 782
1803269 CO     school 803360 880   Denver County 1 80336000338 2398 East High School   Regular School No High 09 12 2020   grade_9 361 122 155   5 25     2   40   346 364                       710 361 122 155   5 25     2   40   346 364                 710
1800495 CO     school 802910 130   Cherry Creek 5 80291001951 1551 Cherokee Trail High School   Regular School No High 09 12 2020   grade_9 416 75 100   4 59     1   38   355 338                       693 416 75 100   4 59     1   38   355 338                 693
1800280 CO     school 807230 70   Westminster Public Schools 80723001254 9466 Westminster High School   Regular School No High 09 12 2020   grade_9 85 11 505   3 24     2   9   334 305                       639 85 11 505   3 24     2   9   334 305                 639
1799639 CO     school 806900 20   Adams 12 Five Star Schools 80690001784 5043 Legacy High School   Regular School No High 09 12 2020   grade_9 412 9 137   3 37     0   36   335 299                       634 412 9 137   3 37     0   36   335 299                 634
1804734 CO     school 803450 900   Douglas County Re 1 80345001748 6165 Mountain Vista High School   Regular School No High 09 12 2020   grade_9 464 3 80   1 44     3   29   319 305                       624 464 3 80   1 44     3   29   319 305                 624
1799712 CO     school 806900 20   Adams 12 Five Star Schools 80690001188 6402 Northglenn High School   Regular School No High 09 12 2020   grade_9 134 8 439   4 14     0   10   310 299                       609 134 8 439   4 14     0   10   310 299                 609
1800790 CO     school 802910 130   Cherry Creek 5 80291000203 8020 Smoky Hill High School   Regular School No High 09 12 2020   grade_9 259 99 132   6 33     5   51   317 268                       585 259 99 132   6 33     5   51   317 268                 585
1804868 CO     school 803450 900   Douglas County Re 1 80345001961 7435 Rock Canyon High School   Regular School No High 09 12 2020   grade_9 437 8 61   3 59     1   13   299 283                       582 437 8 61   3 59     1   13   299 283                 582
1804371 CO     school 803450 900   Douglas County Re 1 80345001918 1367 Castle View High School   Regular School No High 09 12 2020   grade_9 419 3 97   3 18     1   20   285 276                       561 419 3 97   3 18     1   20   285 276                 561
1805552 CO     school 804080 1000   Fountain 8 80408000562 3110 Fountain-Fort Carson High School   Regular School No High 09 12 2020   grade_9 244 65 167   6 5     16   58   287 274                       561 244 65 167   6 5     16   58   287 274                 561
1804615 CO     school 803450 900   Douglas County Re 1 80345006400 4271 Legend High School   Regular School No High 09 12 2020   grade_9 429 3 76   2 18     1   27   269 287                       556 429 3 76   2 18     1   27   269 287                 556
1799615 CO     school 806900 20   Adams 12 Five Star Schools 80690001491 4108 Horizon High School   Regular School No High 09 12 2020   grade_9 332 10 150   3 33     1   25   268 286                       554 332 10 150   3 33     1   25   268 286                 554
1800724 CO     school 802910 130   Cherry Creek 5 80291001272 6625 Overland High School   Regular School No High 09 12 2020   grade_9 119 144 219   2 27     3   35   292 257                       549 119 144 219   2 27     3   35   292 257                 549
1804376 CO     school 803450 900   Douglas County Re 1 80345001578 1503 Chaparral High School   Regular School No High 09 12 2020   grade_9 392 14 90   2 20     2   27   278 269                       547 392 14 90   2 20     2   27   278 269                 547
1809035 CO     school 803990 1550   Poudre R-1 80399000545 7470 Rocky Mountain High School   Regular School No High 09 12 2020   grade_9 391 7 105   3 11     0   28   283 262                       545 391 7 105   3 11     0   28   283 262                 545
1802148 CO     school 802490 480   Boulder Valley Re 2 80249000101 924 Boulder High School   Regular School No High 09 12 2020   grade_9 350 4 140   1 12     0   33   254 286                       540 350 4 140   1 12     0   33   254 286                 540
1802268 CO     school 802490 480   Boulder Valley Re 2 80249000114 2892 Fairview High School   Regular School No High 09 12 2020   grade_9 387 9 49   2 50     0   41   284 254                       538 387 9 49   2 50     0   41   284 254                 538
1808814 CO     school 803990 1550   Poudre R-1 80399001848 3105 Fossil Ridge High School   Regular School No High 09 12 2020   grade_9 432 3 46   0 31     0   26   291 247                       538 432 3 46   0 31     0   26   291 247                 538
1804935 CO     school 803450 900   Douglas County Re 1 80345001529 8847 Thunderridge High School   Regular School No High 09 12 2020   grade_9 408 2 74   4 23     1   25   288 249                       537 408 2 74   4 23     1   25   288 249                 537
1801366 CO     school 802340 180   Adams-Arapahoe 28J 80234001389 7250 Rangeview High School   Regular School No High 09 12 2020   grade_9 126 89 240   0 30     3   47   271 264                       535 126 89 240   0 30     3   47   271 264                 535
1799947 CO     school 802580 40   School District 27J 80258000144 1022 Brighton High School   Regular School No High 09 12 2020   grade_9 213 3 294   1 2     1   17   271 260                       531 213 3 294   1 2     1   17   271 260                 531
1804000 CO     school 803360 880   Denver County 1 80336000408 8086 South High School   Regular School No High 09 12 2020   grade_9 254 61 151   7 35     1   18   251 276                       527 254 61 151   7 35     1   18   251 276                 527
1807735 CO     school 804800 1420   Jefferson County R-1 80480000747 4942 Lakewood High School   Regular School No High 09 12 2020   grade_9 265 7 203   2 25     1   21   250 274                       524 265 7 203   2 25     1   21   250 274                 524
1801212 CO     school 802340 180   Adams-Arapahoe 28J 80234000064 4024 Hinkley High School   Regular School No High 09 12 2020   grade_9 23 68 376   2 23     6   13   270 241                       511 23 68 376   2 23     6   13   270 241                 511
1799857 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2020   grade_9 47 11 437   2 2     1   7   263 244                       507 47 11 437   2 2     1   7   263 244                 507
1800853 CO     school 805310 140   Littleton 6 80531000873 298 Arapahoe High School   Regular School No High 09 12 2020   grade_9 400 8 45   5 15     0   31   242 262                       504 400 8 45   5 15     0   31   242 262                 504
1807247 CO     school 804800 1420   Jefferson County R-1 80480000695 378 Arvada West High School   Regular School No High 09 12 2020   grade_9 351 2 102   4 12     1   24   266 230                       496 351 2 102   4 12     1   24   266 230                 496
1808981 CO     school 803990 1550   Poudre R-1 80399000541 7124 Poudre High School   Regular School No High 09 12 2020   grade_9 337 2 125   5 8     0   15   237 255                       492 337 2 125   5 8     0   15   237 255                 492
1808809 CO     school 803990 1550   Poudre R-1 80399000528 3046 Fort Collins High School   Regular School No High 09 12 2020   grade_9 320 10 131   2 9     0   19   237 254                       491 320 10 131   2 9     0   19   237 254                 491
1809673 CO     school 804350 2000   Mesa County Valley 51 80435000600 1450 Central High School   Regular School No High 09 12 2020   grade_9 276 1 178   4 2     2   27   238 252                       490 276 1 178   4 2     2   27   238 252                 490
1799675 CO     school 806900 20   Adams 12 Five Star Schools 80690001996 6060 Mountain Range High School   Regular School No High 09 12 2020   grade_9 231 8 201   5 18     1   17   238 243                       481 231 8 201   5 18     1   17   238 243                 481
1805684 CO     school 803060 1010   Colorado Springs 11 80306000268 2202 Doherty High School   Regular School No High 09 12 2020   grade_9 263 31 126   4 13     3   39   231 248                       479 263 31 126   4 13     3   39   231 248                 479
1809639 CO     school 804350 2000   Mesa County Valley 51 80435002020 361 Fruita 8/9 School   Regular School No Secondary 08 09 2020   grade_9 395 0 54   3 4     1   20   245 232                       477 395 0 54   3 4     1   20   245 232                 477
1807343 CO     school 804800 1420   Jefferson County R-1 80480001383 1522 Chatfield High School   Regular School No High 09 12 2020   grade_9 388 1 56   1 10     1   19   241 235                       476 388 1 56   1 10     1   19   241 235                 476
1808042 CO     school 804800 1420   Jefferson County R-1 80480001797 7239 Ralston Valley Senior High School   Regular School No High 09 12 2020   grade_9 363 0 65   3 15     1   20   245 222                       467 363 0 65   3 15     1   20   245 222                 467
1804470 CO     school 803450 900   Douglas County Re 1 80345000440 2230 Douglas County High School   Regular School No High 09 12 2020   grade_9 338 4 80   1 14     2   25   223 241                       464 338 4 80   1 14     2   25   223 241                 464
1811891 CO     school 804410 3120   Greeley 6 80441000640 3614 Greeley West High School   Regular School No High 09 12 2020   grade_9 90 9 338   0 15     0   8   244 216                       460 90 9 338   0 15     0   8   244 216                 460
1801110 CO     school 802340 180   Adams-Arapahoe 28J 80234000056 1458 Aurora Central High School   Regular School No High 09 12 2020   grade_9 18 69 310   8 19     8   15   235 212                       447 18 69 310   8 19     8   15   235 212                 447
1800894 CO     school 805310 140   Littleton 6 80531000881 3930 Heritage High School   Regular School No High 09 12 2020   grade_9 337 4 71   3 12     1   12   224 216                       440 337 4 71   3 12     1   12   224 216                 440
1800027 CO     school 802580 40   School District 27J 80258002003 7129 Prairie View High School   Regular School No High 09 12 2020   grade_9 161 21 237   2 12     0   6   224 215                       439 161 21 237   2 12     0   6   224 215                 439
1807375 CO     school 804800 1420   Jefferson County R-1 80480000707 1864 Columbine High School   Regular School No High 09 12 2020   grade_9 304 11 88   5 11     2   16   233 204                       437 304 11 88   5 11     2   16   233 204                 437
1811886 CO     school 804410 3120   Greeley 6 80441000641 3610 Greeley Central High School   Regular School No High 09 12 2020   grade_9 82 20 315   4 8     1   3   234 199                       433 82 20 315   4 8     1   3   234 199                 433
1803348 CO     school 803360 880   Denver County 1 80336000352 3378 George Washington High School   Regular School No High 09 12 2020   grade_9 143 116 126   2 17     2   26   225 207                       432 143 116 126   2 17     2   26   225 207                 432
1804097 CO     school 803360 880   Denver County 1 80336000417 8822 Thomas Jefferson High School   Regular School No High 09 12 2020   grade_9 127 75 171   3 20     1   24   245 176                       421 127 75 171   3 20     1   24   245 176                 421
1806238 CO     school 801920 1040   Academy 20 80192001429 5126 Liberty High School   Regular School No High 09 12 2020   grade_9 279 14 77   3 13     2   32   192 228                       420 279 14 77   3 13     2   32   192 228                 420
1806702 CO     school 803870 1110   District 49 80387006408 8791 Vista Ridge High School   Regular School No High 09 12 2020   grade_9 233 36 82   2 17     5   43   221 197                       418 233 36 82   2 17     5   43   221 197                 418
1802379 CO     school 802490 480   Boulder Valley Re 2 80249001632 5999 Monarch High School   Regular School No High 09 12 2020   grade_9 314 5 46   0 25     0   26   201 215                       416 314 5 46   0 25     0   26   201 215                 416
1805863 CO     school 803060 1010   Colorado Springs 11 80306000257 6680 Palmer High School   Regular School No High 09 12 2020   grade_9 189 47 140   6 1     2   28   206 207                       413 189 47 140   6 1     2   28   206 207                 413
1807272 CO     school 804800 1420   Jefferson County R-1 80480000697 664 Bear Creek High School   Regular School No High 09 12 2020   grade_9 184 4 175   6 28     1   14   222 190                       412 184 4 175   6 28     1   14   222 190                 412
1802171 CO     school 802490 480   Boulder Valley Re 2 80249000103 1070 Broomfield High School   Regular School No High 09 12 2020   grade_9 286 11 76   1 17     0   15   181 225                       406 286 11 76   1 17     0   15   181 225                 406
1803783 CO     school 803360 880   Denver County 1 80336000389 6314 North High School   Regular School No High 09 12 2020   grade_9 89 14 280   5 10     1   7   203 203                       406 89 14 280   5 10     1   7   203 203                 406
1804605 CO     school 803450 900   Douglas County Re 1 80345001437 3980 Highlands Ranch High School   Regular School No High 09 12 2020   grade_9 289 11 55   3 24     0   23   210 195                       405 289 11 55   3 24     0   23   210 195                 405
1799670 CO     school 806900 20   Adams 12 Five Star Schools 80690001192 5816 Thornton High School   Regular School No High 09 12 2020   grade_9 75 15 292   4 12     1   5   202 202                       404 75 15 292   4 12     1   5   202 202                 404
1802072 CO     school 805370 470   St Vrain Valley RE1J 80537001284 7954 Skyline High School   Regular School No High 09 12 2020   grade_9 148 2 239   3 2     3   6   222 181                       403 148 2 239   3 2     3   6   222 181                 403
1801840 CO     school 805370 470   St Vrain Valley RE1J 80537001889 2761 Erie High School   Regular School No High 09 12 2020   grade_9 322 4 50   1 14     0   11   203 199                       402 322 4 50   1 14     0   11   203 199                 402
1809241 CO     school 805400 1560   Thompson R2-J 80540000935 5316 Loveland High School   Regular School No High 09 12 2020   grade_9 284 2 94   2 7     0   11   205 195                       400 284 2 94   2 7     0   11   205 195                 400
1806569 CO     school 803870 1110   District 49 80387006393 3475 GOAL Academy   Alternative School Yes High 09 12 2020   grade_9 161 7 201   6 1     2   20   196 202                       398 161 7 201   6 1     2   20   196 202                 398
1805674 CO     school 803060 1010   Colorado Springs 11 80306000228 1870 Coronado High School   Regular School No High 09 12 2020   grade_9 244 25 98   5 1     0   20   207 186                       393 244 25 98   5 1     0   20   207 186                 393
1802184 CO     school 802490 480   Boulder Valley Re 2 80249000107 1380 Centaurus High School   Regular School No High 09 12 2020   grade_9 222 2 140   0 8     0   19   222 169                       391 222 2 140   0 8     0   19   222 169                 391
1807422 CO     school 804800 1420   Jefferson County R-1 80480001543 2093 Dakota Ridge Senior High School   Regular School No High 09 12 2020   grade_9 270 4 70   2 25     0   11   192 190                       382 270 4 70   2 25     0   11   192 190                 382
1801197 CO     school 802340 180   Adams-Arapahoe 28J 80234000063 3354 Gateway High School   Regular School No High 09 12 2020   grade_9 37 72 227   3 15     6   21   212 169                       381 37 72 227   3 15     6   21   212 169                 381
1807588 CO     school 804800 1420   Jefferson County R-1 80480000733 3502 Golden High School   Regular School No High 09 12 2020   grade_9 311 1 48   0 8     2   9   208 171                       379 311 1 48   0 8     2   9   208 171                 379
1806293 CO     school 801920 1040   Academy 20 80192001321 7240 Rampart High School   Regular School No High 09 12 2020   grade_9 219 10 80   1 21     6   37   191 183                       374 219 10 80   1 21     6   37   191 183                 374
1810133 CO     school 805790 2180   Montrose County RE-1J 80579000992 6058 Montrose High School   Regular School No High 09 12 2020   grade_9 195 4 157   2 3     1   7   170 199                       369 195 4 157   2 3     1   7   170 199                 369
1805450 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2020   grade_9 184 32 102   2 6     4   36   187 179                       366 184 32 102   2 6     4   36   187 179                 366
1806089 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_9 263 15 49   1 18     0   20   189 177                       366 263 15 49   1 18     0   20   189 177                 366
1803796 CO     school 803360 880   Denver County 1 80336006660 6368 Northfield High School   Regular School No High 09 12 2020   grade_9 132 68 126   1 8     1   24   171 189                       360 132 68 126   1 8     1   24   171 189                 360
1809766 CO     school 804350 2000   Mesa County Valley 51 80435000612 3570 Grand Junction High School   Regular School No High 09 12 2020   grade_9 236 0 103   1 2     0   18   193 167                       360 236 0 103   1 2     0   18   193 167                 360
1810966 CO     school 806150 2700   Pueblo County 70 80615001613 7214 Pueblo West High School   Regular School No High 09 12 2020   grade_9 188 1 134   2 6     1   26   170 188                       358 188 1 134   2 6     1   26   170 188                 358
1808592 CO     school 803480 1520   Durango 9-R 80348000448 2318 Durango High School   Regular School No High 09 12 2020   grade_9 254 1 67   14 8     1   11   181 175                       356 254 1 67   14 8     1   11   181 175                 356
1801455 CO     school 802340 180   Adams-Arapahoe 28J 80234006451 9125 Vista Peak 9-12 Preparatory   Regular School No High 09 12 2020   grade_9 62 56 183   3 24     0   27   185 170                       355 62 56 183   3 24     0   27   185 170                 355
1806273 CO     school 801920 1040   Academy 20 80192001645 6937 Pine Creek High School   Regular School No High 09 12 2020   grade_9 247 7 51   1 22     0   27   183 172                       355 247 7 51   1 22     0   27   183 172                 355
1804827 CO     school 803450 900   Douglas County Re 1 80345001341 7118 Ponderosa High School   Regular School No High 09 12 2020   grade_9 288 0 43   2 6     0   12   189 162                       351 288 0 43   2 6     0   12   189 162                 351
1802062 CO     school 805370 470   St Vrain Valley RE1J 80537001814 7789 Silver Creek High School   Regular School No High 09 12 2020   grade_9 260 2 46   1 25     1   9   171 173                       344 260 2 46   1 25     1   9   171 173                 344
1802858 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   grade_9 9 20 302   4 7     0   2   202 142                       344 9 20 302   4 7     0   2   202 142                 344
1809870 CO     school 804350 2000   Mesa County Valley 51 80435000620 6666 Palisade High School   Regular School No High 09 12 2020   grade_9 220 2 102   6 2     0   11   177 166                       343 220 2 102   6 2     0   11   177 166                 343
1801879 CO     school 805370 470   St Vrain Valley RE1J 80537000902 3196 Frederick Senior High School   Regular School No High 09 12 2020   grade_9 193 2 126   2 5     2   10   180 160                       340 193 2 126   2 5     2   10   180 160                 340
1811956 CO     school 804410 3120   Greeley 6 80441001788 6364 Northridge High School   Regular School No High 09 12 2020   grade_9 70 5 250   0 1     1   9   175 161                       336 70 5 250   0 1     1   9   175 161                 336
1808014 CO     school 804800 1420   Jefferson County R-1 80480000775 7114 Pomona High School   Regular School No High 09 12 2020   grade_9 179 5 127   2 7     1   11   187 145                       332 179 5 127   2 7     1   11   187 145                 332
1800043 CO     school 802580 40   School District 27J 80258006738 7340 Riverdale Ridge High School   Regular School No Secondary 09 11 2020   grade_9 160 8 129   2 17     0   15   161 170                       331 160 8 129   2 17     0   15   161 170                 331
1808182 CO     school 804800 1420   Jefferson County R-1 80480001487 8209 Standley Lake High School   Regular School No High 09 12 2020   grade_9 222 3 65   2 21     0   15   177 151                       328 222 3 65   2 21     0   15   177 151                 328
1805997 CO     school 802940 1020   Cheyenne Mountain 12 80294000211 1590 Cheyenne Mountain High School   Regular School No High 09 12 2020   grade_9 235 6 50   1 10     0   24   164 162                       326 235 6 50   1 10     0   24   164 162                 326
1810949 CO     school 806150 2700   Pueblo County 70 80615001079 7208 Pueblo County High School   Regular School No High 09 12 2020   grade_9 159 4 143   0 4     0   14   165 159                       324 159 4 143   0 4     0   14   165 159                 324
1805503 CO     school 806480 990   Widefield 3 80648001129 9566 Widefield High School   Regular School No High 09 12 2020   grade_9 159 30 85   2 6     6   32   161 159                       320 159 30 85   2 6     6   32   161 159                 320
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
1803527 CO     school 803360 880   Denver County 1 80336000367 4444 John F Kennedy High School   Regular School No High 09 12 2020   grade_9 37 11 248   5 14     0   3   166 152                       318 37 11 248   5 14     0   3   166 152                 318
1806564 CO     school 803870 1110   District 49 80387000507 2908 Falcon High School   Regular School No High 09 12 2020   grade_9 214 13 65   2 4     1   16   156 159                       315 214 13 65   2 4     1   16   156 159                 315
1799429 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_9 202 10 78   4 2     2   14   156 156                       312 202 10 78   4 2     2   14   156 156                 312
1806457 CO     school 805820 1080   Lewis-Palmer 38 80582006369 6678 Palmer Ridge High School   Regular School No High 09 12 2020   grade_9 247 4 31   0 10     1   17   170 140                       310 247 4 31   0 10     1   17   170 140                 310
1805274 CO     school 804530 980   Harrison 2 80453000667 3806 Harrison High School   Regular School No High 09 12 2020   grade_9 63 55 159   2 6     2   16   165 138                       303 63 55 159   2 6     2   16   165 138                 303
1808397 CO     school 804800 1420   Jefferson County R-1 80480000803 9510 Wheat Ridge High School   Regular School No High 09 12 2020   grade_9 165 2 118   1 3     0   13   157 145                       302 165 2 118   1 3     0   13   157 145                 302
1801927 CO     school 805370 470   St Vrain Valley RE1J 80537000909 5282 Longmont High School   Regular School No High 09 12 2020   grade_9 178 3 111   1 3     0   5   152 149                       301 178 3 111   1 3     0   5   152 149                 301
1801965 CO     school 805370 470   St Vrain Valley RE1J 80537006423 5722 Mead High School   Regular School No High 09 12 2020   grade_9 224 1 62   0 8     1   4   152 148                       300 224 1 62   0 8     1   4   152 148                 300
1806759 CO     school 802790 1140   Canon City RE-1 80279000172 1266 Canon City High School   Regular School No High 09 12 2020   grade_9 229 0 47   4 4     0   12   140 156                       296 229 0 47   4 4     0   12   140 156                 296
1809259 CO     school 805400 1560   Thompson R2-J 80540001786 6163 Mountain View High School   Regular School No High 09 12 2020   grade_9 188 7 85   2 2     0   11   149 146                       295 188 7 85   2 2     0   11   149 146                 295
1802008 CO     school 805370 470   St Vrain Valley RE1J 80537000918 6276 Niwot High School   Regular School No High 09 12 2020   grade_9 175 4 85   1 19     0   9   133 160                       293 175 4 85   1 19     0   9   133 160                 293
1803660 CO     school 803360 880   Denver County 1 80336001406 5605 Dr. Martin Luther King Jr. Early College   Regular School No High 06 12 2020   grade_9 10 90 162   1 12     9   9   161 132                       293 10 90 162   1 12     9   9   161 132                 293

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