Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 389

grade

  • grade_9 · 389
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
1807413 CO     school 804800 1420   Jefferson County R-1 80480001542 1886 Conifer Senior High School   Regular School No High 09 12 2020   grade_9 188 0 23   2 1     1   12   118 109                       227 188 0 23   2 1     1   12   118 109                 227
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
1807429 CO     school 804800 1420   Jefferson County R-1 80480000964 2120 D'Evelyn Junior/Senior High School   Regular School No High 07 12 2020   grade_9 122 3 23   0 22     0   8   92 86                       178 122 3 23   0 22     0   8   92 86                 178
1807443 CO     school 804800 1420   Jefferson County R-1 80480006695 2189 Doral Academy of Colorado   Regular School Yes Other KG 09 2020   grade_9 4 1 0   0 0     0   0   1 4                       5 4 1 0   0 0     0   0   1 4                 5
1807515 CO     school 804800 1420   Jefferson County R-1 80480000719 2836 Evergreen High School   Regular School No High 09 12 2020   grade_9 265 2 10   0 3     0   12   165 127                       292 265 2 10   0 3     0   12   165 127                 292
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
1807615 CO     school 804800 1420   Jefferson County R-1 80480000736 3628 Green Mountain High School   Regular School No High 09 12 2020   grade_9 196 7 58   3 10     0   19   152 141                       293 196 7 58   3 10     0   19   152 141                 293
1807662 CO     school 804800 1420   Jefferson County R-1 80480001921 4404 Jefferson Academy   Regular School Yes Other KG 12 2020   grade_9 47 0 9   3 1     0   2   34 28                       62 47 0 9   3 1     0   2   34 28                 62
1807671 CO     school 804800 1420   Jefferson County R-1 80480006439 4408 Jeffco Virtual Academy   Alternative School No High 06 12 2020   grade_9 15 0 5   0 1     0   0   8 13                       21 15 0 5   0 1     0   0   8 13                 21
1807676 CO     school 804800 1420   Jefferson County R-1 80480001922 4410 Jefferson Academy High School   Regular School Yes High 09 12 2020   grade_9 71 3 15   1 7     1   9   59 48                       107 71 3 15   1 7     1   9   59 48                 107
1807683 CO     school 804800 1420   Jefferson County R-1 80480000739 4422 Jefferson Junior/Senior High School   Regular School No High 07 12 2020   grade_9 8 7 100   3 0     1   3   57 65                       122 8 7 100   3 0     1   3   57 65                 122
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
1807808 CO     school 804800 1420   Jefferson County R-1 80480001606 5415 Rocky Mountain Deaf School   Special Education School Yes Other PK 12 2020   grade_9 5 1 5   0 0     0   0   6 5                       11 5 1 5   0 0     0   0   6 5                 11
1807858 CO     school 804800 1420   Jefferson County R-1 80480000756 5892 Miller Special Education   Special Education School No Other PK 12 2020   grade_9 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1807926 CO     school 804800 1420   Jefferson County R-1 80480002014 6237 New America School   Alternative School Yes High 09 12 2020   grade_9 0 0 14   0 1     0   0   9 6                       15 0 0 14   0 1     0   0   9 6                 15
1807958 CO     school 804800 1420   Jefferson County R-1 80480000765 6541 Jefferson County Open Secondary   Regular School No High 07 12 2020   grade_9 42 1 5   0 2     0   2   32 20                       52 42 1 5   0 2     0   2   32 20                 52
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
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
1808097 CO     school 804800 1420   Jefferson County R-1 80480001036 7701 Collegiate Academy of Colorado   Regular School Yes Other KG 12 2020   grade_9 30 0 4   0 2     0   4   17 23                       40 30 0 4   0 2     0   4   17 23                 40
1808162 CO     school 804800 1420   Jefferson County R-1 80480006307 8036 Sobesky Academy   Special Education School No Other KG 12 2020   grade_9 11 0 5   0 0     0   0   14 2                       16 11 0 5   0 0     0   0   14 2                 16
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
1808248 CO     school 804800 1420   Jefferson County R-1 80480006466 8793 Two Roads Charter School   Regular School Yes Other PK 12 2020   grade_9 43 0 9   0 2     0   2   31 25                       56 43 0 9   0 2     0   2   31 25                 56
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
1808438 CO     school 803510 1430   Eads RE-1 80351000459 2336 Eads High School   Regular School No High 09 12 2020   grade_9 8 0 2   0 0     0   0   5 5                       10 8 0 2   0 0     0   0   5 5                 10
1808454 CO     school 806930 1440   Plainview RE-2 80693001199 7009 Plainview Junior-Senior High School   Regular School No High 06 12 2020   grade_9 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
1808467 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_9 6 0 1   0 0     0   0   4 3                       7 6 0 1   0 0     0   0   4 3                 7
1808482 CO     school 806510 1460   Hi-Plains R-23 80651001130 7746 Hi-Plains School District R-23   Regular School No Other PK 12 2020   grade_9 4 0 3   1 0     0   0   5 3                       8 4 0 3   1 0     0   0   5 3                 8
1808501 CO     school 806780 1480   Stratton R-4 80678001163 8354 Stratton Senior High School   Regular School No High 09 12 2020   grade_9 8 0 3   0 0     0   0   5 6                       11 8 0 3   0 0     0   0   5 6                 11
1808514 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2020   grade_9 6 0 3   0 0     0   0   4 5                       9 6 0 3   0 0     0   0   4 5                 9
1808533 CO     school 802670 1500   Burlington RE-6J 80267000162 1152 Burlington High School   Regular School No High 09 12 2020   grade_9 27 1 27   2 0     0   0   25 32                       57 27 1 27   2 0     0   0   25 32                 57
1808545 CO     school 805190 1510   Lake County R-1 80519000857 4904 Lake County High School   Regular School No High 07 12 2020   grade_9 19 0 55   0 0     0   4   42 36                       78 19 0 55   0 0     0   4   42 36                 78
1808576 CO     school 803480 1520   Durango 9-R 80348006696 1526 Colorado Connections Academy @ Durango   Regular School No Other KG 12 2020   grade_9 73 0 27   3 0     0   4   61 46                       107 73 0 27   3 0     0   4   61 46                 107
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
1808613 CO     school 803480 1520   Durango 9-R 80348006597 3571 Durango Big Picture High School   Alternative School No High 09 12 2020   grade_9 13 0 5   2 0     0   0   11 9                       20 13 0 5   2 0     0   0   11 9                 20
1808673 CO     school 802400 1530   Bayfield 10 Jt-R 80240000090 640 Bayfield High School   Regular School No High 09 12 2020   grade_9 78 0 19   2 2     0   7   54 54                       108 78 0 19   2 2     0   7   54 54                 108
1808693 CO     school 804770 1540   Ignacio 11 JT 80477000689 4258 Ignacio High School   Regular School No High 09 12 2020   grade_9 13 0 20   18 1     0   3   26 29                       55 13 0 20   18 1     0   3   26 29                 55
1808700 CO     school   1550   Poudre R-1   0 Not a school             2020   grade_9 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1808713 CO     school 803990 1550   Poudre R-1 80399001717 146 Ridgeview Classical Charter Schools   Regular School Yes Other KG 12 2020   grade_9 28 0 2   0 0     0   2   16 16                       32 28 0 2   0 0     0   2   16 16                 32
1808797 CO     school 803990 1550   Poudre R-1 80399006762 1917 Compass Community Collaborative School   Regular School Yes Secondary 06 11 2020   grade_9 24 0 2   0 1     0   2   15 14                       29 24 0 2   0 1     0   2   15 14                 29
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
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
1808828 CO     school 803990 1550   Poudre R-1 80399000517 3760 Centennial High School   Alternative School No High 09 12 2020   grade_9 0 0 2   0 0     0   0   0 2                       2 0 0 2   0 0     0   0   0 2                 2
1808892 CO     school 803990 1550   Poudre R-1 80399001608 5120 Liberty Common Charter School   Regular School Yes Other KG 12 2020   grade_9 80 1 2   1 7     0   6   48 49                       97 80 1 2   1 7     0   6   48 49                 97
1808975 CO     school 803990 1550   Poudre R-1 80399006334 7104 Polaris Expeditionary Learning School   Alternative School No Other KG 12 2020   grade_9 37 2 5   1 0     0   0   17 28                       45 37 2 5   1 0     0   0   17 28                 45
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
1808987 CO     school 803990 1550   Poudre R-1 80399001938 7127 Poudre Community Academy   Alternative School No High 06 12 2020   grade_9 14 1 8   3 1     0   1   14 14                       28 14 1 8   3 1     0   1   14 14                 28
1809004 CO     school 803990 1550   Poudre R-1 80399006431 7198 PSD Global Academy   Regular School No Other KG 12 2020   grade_9 18 0 3   0 0     0   1   10 12                       22 18 0 3   0 0     0   1   10 12                 22
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
1809113 CO     school 805400 1560   Thompson R2-J 80540000927 812 Berthoud High School   Regular School No High 09 12 2020   grade_9 159 0 27   0 1     0   2   101 88                       189 159 0 27   0 1     0   2   101 88                 189
1809209 CO     school 805400 1560   Thompson R2-J 80540006558 5121 LEAP School   Regular School No Other KG 12 2020   grade_9 7 0 0   0 0     0   1   4 4                       8 7 0 0   0 0     0   1   4 4                 8
1809230 CO     school 805400 1560   Thompson R2-J 80540006534 5235 Loveland Classical School   Regular School Yes Other KG 12 2020   grade_9 26 0 7   0 0     0   0   16 17                       33 26 0 7   0 0     0   0   16 17                 33
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
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
1809297 CO     school 805400 1560   Thompson R2-J 80540000938 8824 Thompson Valley High School   Regular School No High 09 12 2020   grade_9 173 3 64   1 6     3   5   128 127                       255 173 3 64   1 6     3   5   128 127                 255
1809317 CO     school 805400 1560   Thompson R2-J 80540000941 9260 Harold Ferguson High School   Alternative School No High 09 12 2020   grade_9 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1809334 CO     school 803810 1570   Estes Park R-3 80381006426 2788 Estes Park Options School   Alternative School No Other KG 12 2020   grade_9 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1809352 CO     school 803810 1570   Estes Park R-3 80381000500 2794 Estes Park High School   Regular School No High 09 12 2020   grade_9 67 0 29   2 2     0   1   62 39                       101 67 0 29   2 2     0   1   62 39                 101
1809369 CO     school 806960 1580   Trinidad 1 80696001205 8906 Trinidad High School   Regular School No High 09 12 2020   grade_9 21 0 47   0 0     0   3   35 36                       71 21 0 47   0 0     0   3   35 36                 71
1809385 CO     school 807260 1590   Primero Reorganized 2 80726001255 7164 Primero Junior-Senior High School   Regular School No High 06 12 2020   grade_9 4 0 3   1 0     0   0   6 2                       8 4 0 3   1 0     0   0   6 2                 8
1809398 CO     school 804650 1600   Hoehne Reorganized 3 80465000680 4048 Hoehne Schools   Regular School No Other PK 12 2020   grade_9 10 0 25   0 1     0   0   19 17                       36 10 0 25   0 1     0   0   19 17                 36
1809415 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_9 2 0 7   0 0     0   0   5 4                       9 2 0 7   0 0     0   0   5 4                 9
1801013 CO     school 803270 170   Deer Trail 26J 80327000288 2140 Deer Trail Junior-Senior High School   Regular School No High 06 12 2020   grade_9 12 0 4   0 0     0   0   9 7                       16 12 0 4   0 0     0   0   9 7                 16
1809428 CO     school 802520 1750   Branson Reorganized 82 80252001728 948 Branson School Online   Regular School No Other KG 12 2020   grade_9 29 0 13   0 0     1   1   16 28                       44 29 0 13   0 0     1   1   16 28                 44
1809442 CO     school 802520 1750   Branson Reorganized 82 80252000141 978 Branson School   Regular School No Other PK 12 2020   grade_9 8 0 1   0 0     0   0   2 7                       9 8 0 1   0 0     0   0   2 7                 9
1809458 CO     school 804980 1760   Kim Reorganized 88 80498000823 4694 Kim Undivided High School   Regular School No High 06 12 2020   grade_9 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1809471 CO     school 804740 1780   Genoa-Hugo C113 80474000686 4162 Genoa-Hugo School   Regular School No Other PK 12 2020   grade_9 8 0 1   0 0     0   0   4 5                       9 8 0 1   0 0     0   0   4 5                 9
1809488 CO     school 805280 1790   Limon RE-4J 80528000871 5136 Limon Junior-Senior High School   Regular School No High 06 12 2020   grade_9 27 0 4   1 0     0   0   13 19                       32 27 0 4   1 0     0   0   13 19                 32
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
1801171 CO     school 802340 180   Adams-Arapahoe 28J 80234006781 2654 Empower Community High School   Regular School Yes Secondary 09 09 2020   grade_9 17 24 61   3 0     1   14   62 58                       120 17 24 61   3 0     1   14   62 58                 120
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
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
1801267 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2020   grade_9 5 27 36   0 5     0   1   37 37                       74 5 27 36   0 5     0   1   37 37                 74
1801318 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_9 42 1 10   0 1     0   4   25 33                       58 42 1 10   0 1     0   4   25 33                 58
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
1801399 CO     school 802340 180   Adams-Arapahoe 28J 80234000084 8356 William Smith High School   Regular School No High 09 12 2020   grade_9 16 6 62   0 5     1   1   47 44                       91 16 6 62   0 5     1   1   47 44                 91
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
1801476 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_9 6 5 17   0 0     0   1   19 10                       29 6 5 17   0 0     0   1   19 10                 29
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
1809504 CO     school 804890 1810   Karval RE-23 80489000815 4506 Karval Junior-Senior High School   Regular School No High 07 12 2020   grade_9 5 0 0   0 0     0   0   2 3                       5 5 0 0   0 0     0   0   2 3                 5
1809524 CO     school 806690 1828   Valley RE-1 80669001147 1224 Caliche Junior-Senior High School   Regular School No High 07 12 2020   grade_9 22 0 3   0 0     0   3   10 18                       28 22 0 3   0 0     0   3   10 18                 28
1809539 CO     school 806690 1828   Valley RE-1 80669001155 8260 Sterling High School   Regular School No High 09 12 2020   grade_9 83 1 41   0 0     0   3   57 71                       128 83 1 41   0 0     0   3   57 71                 128
1809555 CO     school 803930 1850   Frenchman RE-3 80393000512 2988 Fleming High School   Regular School No High 07 12 2020   grade_9 19 0 1   0 0     0   0   13 7                       20 19 0 1   0 0     0   0   13 7                 20
1809570 CO     school 805640 1860   Buffalo RE-4J 80564000970 5806 Merino Junior Senior High School   Regular School No High 07 12 2020   grade_9 19 0 5   1 0     0   1   12 14                       26 19 0 5   1 0     0   1   12 14                 26
1809586 CO     school 806030 1870   Plateau RE-5 80603001023 6838 Peetz Junior-Senior High School   Regular School No High 07 12 2020   grade_9 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1801517 CO     school 802700 190   Byers 32J 80270000164 1176 Byers Junior-Senior High School   Regular School No High 07 12 2020   grade_9 31 1 10   0 0     0   0   23 19                       42 31 1 10   0 0     0   0   23 19                 42
1801522 CO     school 802700 190   Byers 32J 80270001944 1752 Colorado Virtual Academy High School   Regular School Yes High 09 12 2020   grade_9 34 7 25   0 1     0   0   34 33                       67 34 7 25   0 1     0   0   34 33                 67
1801527 CO     school 802700 190   Byers 32J 80270006605 2356 Astravo Academy High School   Regular School Yes High 09 12 2020   grade_9 35 2 4   0 0     0   0   19 22                       41 35 2 4   0 0     0   0   19 22                 41
1801536 CO     school 802700 190   Byers 32J 80270006548 3362 Astravo Online Academy High School   Regular School Yes High 09 12 2020   grade_9 68 7 37   0 1     0   0   46 67                       113 68 7 37   0 1     0   0   46 67                 113
1809599 CO     school 803240 1980   De Beque 49JT 80324000286 2126 De Beque PK-12 School District 49JT   Regular School No Other PK 12 2020   grade_9 14 0 0   0 0     0   0   7 7                       14 14 0 0   0 0     0   0   7 7                 14
1809622 CO     school 803030 1990   Plateau Valley 50 80303000220 7032 Plateau Valley High School   Regular School No High 09 12 2020   grade_9 20 0 3   0 2     0   0   10 15                       25 20 0 3   0 2     0   0   10 15                 25
1799486 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2020   grade_9 1 0 3   1 0     0   0   3 2                       5 1 0 3   1 0     0   0   3 2                 5
1799519 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_9 78 1 9   1 22     0   5   61 55                       116 78 1 9   1 22     0   5   61 55                 116
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
1799634 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2020   grade_9 2 0 16   0 0     0   0   12 6                       18 2 0 16   0 0     0   0   12 6                 18
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
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
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
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
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
1799734 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2020   grade_9 4 1 1   0 0     0   0   5 1                       6 4 1 1   0 0     0   0   5 1                 6

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