Data source: Big Local News · About: Big Local

3,382 rows where grade = "grade_9" and state = "CO" sorted by district

View and edit SQL

year

grade

  • grade_9 · 3,282
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
1133736 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 58.0 14.0 454.0   5.0 1.0     0.0   4.0   269.0 267.0                       536.0 58 14 454   5 1     0   4   269 267                 536
1894229 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2018   grade_9 1 1 7   0 0     0   0   5 4                       9 1 1 7   0 0     0   0   5 4                 9
1894234 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 59 9 476   4 1     0   5   287 267                       554 59 9 476   4 1     0   5   287 267                 554
1931519 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2019   grade_9 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1931524 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 49 10 452   4 3     1   5   286 238                       524 49 10 452   4 3     1   5   286 238                 524
709518 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006476 219 APS ONLINE SCHOOL   Regular School No High 09 12 2017   grade_9 3 2 8   0 0     0   1   4 10                       14 3 2 8   0 0     0   1   4 10                 14
709567 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000056 1458 AURORA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 19 100 347   4 55     4   21   279 271                       550 19 100 347   4 55     4   21   279 271                 550
709658 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000063 3354 GATEWAY HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 35 103 228   1 13     3   13   223 173                       396 35 103 228   1 13     3   13   223 173                 396
709673 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000064 4024 HINKLEY HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 49 83 365   2 18     2   12   277 254                       531 49 83 365   2 18     2   12   277 254                 531
709727 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2017   grade_9 12 33 23   0 3     0   0   36 35                       71 12 33 23   0 3     0   0   36 35                 71
709778 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2017   grade_9 48 0 2   0 3     0   0   27 26                       53 48 0 2   0 3     0   0   27 26                 53
709820 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001389 7250 RANGEVIEW HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 153 117 222   1 30     2   36   294 267                       561 153 117 222   1 30     2   36   294 267                 561
709853 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000084 8356 WILLIAM SMITH HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 19 10 44   0 1     1   2   40 37                       77 19 10 44   0 1     1   2   40 37                 77
709902 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006451 9125 VISTA PEAK 9-12 PREPARATORY   Regular School No High 09 12 2017   grade_9 95 54 185   4 12     2   21   185 188                       373 95 54 185   4 12     2   21   185 188                 373
709923 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2017   grade_9 10 10 19   0 1     0   1   22 19                       41 10 10 19   0 1     0   1   22 19                 41
709932 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No Other 06 12 2017   grade_9 5 10 67   0 20     0   2   53 51                       104 5 10 67   0 20     0   2   53 51                 104
837138 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_9 1 0 2   0 0     0   1   3 1                       4 1 0 2   0 0     0   1   3 1                 4
837164 CO     school   180   ADAMS-ARAPAHOE 28J   219 APS ONLINE SCHOOL             2016   grade_9 1 1 5   0 0     0   1   3 5                       8 1 1 5   0 0     0   1   3 5                 8
837212 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000056 1458 AURORA CENTRAL HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 25 71 374   3 47     3   11   300 234                       534 25 71 374   3 47     3   11   300 234                 534
837303 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000063 3354 GATEWAY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 54 99 205   6 10     3   18   207 188                       395 54 99 205   6 10     3   18   207 188                 395
837318 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000064 4024 HINKLEY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 44 74 347   2 20     5   23   258 257                       515 44 74 347   2 20     5   23   258 257                 515
837372 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes 4.0 KG 12 2016   grade_9 19 21 30   0 3     0   0   29 44                       73 19 21 30   0 3     0   0   29 44                 73
837423 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No 4.0 KG 12 2016   grade_9 37 0 1   0 1     1   2   24 18                       42 37 0 1   0 1     1   2   24 18                 42
837463 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001389 7250 RANGEVIEW HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 136 123 204   5 34     2   30   262 272                       534 136 123 204   5 34     2   30   262 272                 534
837496 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000084 8356 WILLIAM SMITH HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 11 10 55   0 1     0   3   38 42                       80 11 10 55   0 1     0   3   38 42                 80
837545 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006451 9125 VISTA PEAK 9-12 PREPARATORY   Regular School No 3.0 09 12 2016   grade_9 86 58 147   3 16     4   15   160 169                       329 86 58 147   3 16     4   15   160 169                 329
837565 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes 4.0 KG 11 2016   grade_9 8 16 28   2 0     0   2   29 27                       56 8 16 28   2 0     0   2   29 27                 56
837574 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No 4.0 06 12 2016   grade_9 10 8 82   2 11     0   0   48 65                       113 10 8 82   2 11     0   0   48 65                 113
1134854 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2015   grade_9 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0                       1.0 0 1 0   0 0     0   0   0 1                 1
1134881 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006476 219 APS ONLINE SCHOOL   Regular School No 3.0 09 12 2015   grade_9 2.0 3.0 10.0   0.0 1.0     0.0   0.0   3.0 13.0                       16.0 2 3 10   0 1     0   0   3 13                 16
1134929 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000056 1458 AURORA CENTRAL HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 26.0 94.0 418.0   7.0 27.0     3.0   17.0   331.0 261.0                       592.0 26 94 418   7 27     3   17   331 261                 592
1135009 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000063 3354 GATEWAY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 68.0 116.0 230.0   4.0 13.0     1.0   18.0   243.0 207.0                       450.0 68 116 230   4 13     1   18   243 207                 450
1135024 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000064 4024 HINKLEY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 41.0 84.0 367.0   3.0 17.0     5.0   9.0   263.0 263.0                       526.0 41 84 367   3 17     5   9   263 263                 526
1135078 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes 4.0 KG 12 2015   grade_9 17.0 25.0 29.0   1.0 1.0     0.0   0.0   35.0 38.0                       73.0 17 25 29   1 1     0   0   35 38                 73
1135129 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No 4.0 KG 12 2015   grade_9 30.0 0.0 7.0   0.0 0.0     0.0   1.0   21.0 17.0                       38.0 30 0 7   0 0     0   1   21 17                 38
1135169 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001389 7250 RANGEVIEW HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 149.0 141.0 210.0   6.0 25.0     4.0   34.0   299.0 270.0                       569.0 149 141 210   6 25     4   34   299 270                 569
1135202 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000084 8356 WILLIAM SMITH HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 17.0 5.0 49.0   1.0 3.0     0.0   4.0   39.0 40.0                       79.0 17 5 49   1 3     0   4   39 40                 79
1135251 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006451 9125 VISTA PEAK 9-12 PREPARATORY   Regular School No 3.0 09 12 2015   grade_9 95.0 46.0 132.0   3.0 13.0     2.0   21.0   162.0 150.0                       312.0 95 46 132   3 13     2   21   162 150                 312
1135270 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes 4.0 KG 10 2015   grade_9 9.0 6.0 25.0   0.0 0.0     1.0   0.0   16.0 25.0                       41.0 9 6 25   0 0     1   0   16 25                 41
1135279 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No 4.0 06 12 2015   grade_9 1.0 8.0 80.0   1.0 20.0     0.0   1.0   51.0 60.0                       111.0 1 8 80   1 20     0   1   51 60                 111
1895384 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_9 0 1 0   0 0     0   1   1 1                       2 0 1 0   0 0     0   1   1 1                 2
1895418 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006476 219 APS ONLINE SCHOOL   Regular School No High 09 12 2018   grade_9 0 1 3   0 0     1   0   3 2                       5 0 1 3   0 0     1   0   3 2                 5
1895467 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000056 1458 AURORA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 21 70 334   5 28     4   1   237 226                       463 21 70 334   5 28     4   1   237 226                 463
1895559 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000063 3354 GATEWAY HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 58 70 241   3 11     2   16   203 198                       401 58 70 241   3 11     2   16   203 198                 401
1895574 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000064 4024 HINKLEY HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 37 64 395   4 23     4   13   272 268                       540 37 64 395   4 23     4   13   272 268                 540
1895628 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2018   grade_9 13 21 32   1 2     0   2   35 36                       71 13 21 32   1 2     0   2   35 36                 71
1895679 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2018   grade_9 31 0 9   0 0     0   2   26 16                       42 31 0 9   0 0     0   2   26 16                 42
1895724 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001389 7250 RANGEVIEW HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 144 99 237   3 33     4   14   282 252                       534 144 99 237   3 33     4   14   282 252                 534
1895757 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000084 8356 WILLIAM SMITH HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 14 10 59   1 1     0   2   43 44                       87 14 10 59   1 1     0   2   43 44                 87
1895809 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006451 9125 VISTA PEAK 9-12 PREPARATORY   Regular School No High 09 12 2018   grade_9 95 60 191   2 22     2   33   203 202                       405 95 60 191   2 22     2   33   203 202                 405
1895830 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2018   grade_9 7 9 18   0 0     0   0   16 18                       34 7 9 18   0 0     0   0   16 18                 34
1895839 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No High 06 12 2018   grade_9 3 9 79   0 17     0   2   41 69                       110 3 9 79   0 17     0   2   41 69                 110
1932691 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_9 1 1 2   0 0     0   0   2 2                       4 1 1 2   0 0     0   0   2 2                 4
1932771 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000056 1458 AURORA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 28 73 319   3 25     10   14   280 192                       472 28 73 319   3 25     10   14   280 192                 472
1932863 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000063 3354 GATEWAY HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 44 69 193   2 12     3   19   179 163                       342 44 69 193   2 12     3   19   179 163                 342
1932878 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000064 4024 HINKLEY HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 28 68 391   5 15     10   9   271 255                       526 28 68 391   5 15     10   9   271 255                 526
1932932 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2019   grade_9 9 21 27   0 0     0   0   31 26                       57 9 21 27   0 0     0   0   31 26                 57
1932983 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2019   grade_9 52 0 7   0 2     0   1   35 27                       62 52 0 7   0 2     0   1   35 27                 62
1933029 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001389 7250 RANGEVIEW HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 131 127 248   7 26     2   37   303 275                       578 131 127 248   7 26     2   37   303 275                 578
1933062 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000084 8356 WILLIAM SMITH HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 13 13 60   0 2     0   2   45 45                       90 13 13 60   0 2     0   2   45 45                 90
1933116 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006451 9125 VISTA PEAK 9-12 PREPARATORY   Regular School No High 09 12 2019   grade_9 82 63 160   6 14     0   22   190 157                       347 82 63 160   6 14     0   22   190 157                 347
1933137 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2019   grade_9 5 6 23   1 0     1   1   17 20                       37 5 6 23   1 0     1   1   17 20                 37
1933146 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No High 06 12 2019   grade_9 6 11 94   1 15     0   1   59 69                       128 6 11 94   1 15     0   1   59 69                 128
1936930 CO     school 801980 960   AGATE 300 80198000021 48 AGATE JUNIOR SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_9 5 0 0   0 0     0   0   0 5                       5 5 0 0   0 0     0   0   0 5                 5
717818 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_9 3 0 5   0 0     0   0   6 2                       8 3 0 5   0 0     0   0   6 2                 8
845390 CO     school   1620   AGUILAR REORGANIZED 6   66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL             2016   grade_9 3 0 5   0 0     0   0   4 4                       8 3 0 5   0 0     0   0   4 4                 8
1142968 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_9 4.0 0.0 8.0   0.0 0.0     0.0   0.0   6.0 6.0                       12.0 4 0 8   0 0     0   0   6 6                 12
1903763 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2018   grade_9 1 0 5   0 0     0   0   3 3                       6 1 0 5   0 0     0   0   3 3                 6
1941143 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_9 2 0 3   0 0     0   0   2 3                       5 2 0 3   0 0     0   0   2 3                 5
719922 CO     school 802040 3030   AKRON R-1 80204000025 90 AKRON HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 12 0 2   0 0     0   1   7 8                       15 12 0 2   0 0     0   1   7 8                 15
847492 CO     school   3030   AKRON R-1   90 AKRON HIGH SCHOOL             2016   grade_9 28 0 9   0 1     0   0   22 16                       38 28 0 9   0 1     0   0   22 16                 38
1145063 CO     school 802040 3030   AKRON R-1 80204000025 90 AKRON HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 24.0 0.0 1.0   0.0 1.0     0.0   0.0   14.0 12.0                       26.0 24 0 1   0 1     0   0   14 12                 26
1905867 CO     school 802040 3030   AKRON R-1 80204000025 90 AKRON HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 17 0 4   0 0     0   2   12 11                       23 17 0 4   0 0     0   2   12 11                 23
1943242 CO     school 802040 3030   AKRON R-1 80204000025 90 AKRON HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 23 0 4   0 1     0   0   15 13                       28 23 0 4   0 1     0   0   15 13                 28
708790 CO     school 802070 100   ALAMOSA RE-11J 80207000027 118 ALAMOSA HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 58 4 112   2 2     1   4   88 95                       183 58 4 112   2 2     1   4   88 95                 183
708798 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_9 1 1 18   0 0     0   0   14 6                       20 1 1 18   0 0     0   0   14 6                 20
836437 CO     school   100   ALAMOSA RE-11J   118 ALAMOSA HIGH SCHOOL             2016   grade_9 66 1 116   1 2     2   3   96 95                       191 66 1 116   1 2     2   3   96 95                 191
836444 CO     school   100   ALAMOSA RE-11J   368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE             2016   grade_9 2 1 11   0 0     0   0   10 4                       14 2 1 11   0 0     0   0   10 4                 14
1134162 CO     school 802070 100   ALAMOSA RE-11J 80207000027 118 ALAMOSA HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 52.0 1.0 115.0   2.0 2.0     0.0   1.0   90.0 83.0                       173.0 52 1 115   2 2     0   1   90 83                 173
1134169 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative Education School No 4.0 06 12 2015   grade_9 0.0 0.0 12.0   0.0 0.0     0.0   0.0   5.0 7.0                       12.0 0 0 12   0 0     0   0   5 7                 12
1894678 CO     school 802070 100   ALAMOSA RE-11J 80207000027 118 ALAMOSA HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 44 2 117   6 2     0   5   100 76                       176 44 2 117   6 2     0   5   100 76                 176
1894686 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2018   grade_9 2 3 21   0 0     0   1   17 10                       27 2 3 21   0 0     0   1   17 10                 27
1931974 CO     school 802070 100   ALAMOSA RE-11J 80207000027 118 ALAMOSA HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 63 1 120   3 3     1   4   104 91                       195 63 1 120   3 3     1   4   104 91                 195
1931982 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_9 2 0 10   1 0     0   0   7 6                       13 2 0 10   1 0     0   0   7 6                 13
710025 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000039 6658 PAGOSA SPRINGS HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 84 1 5   34 3     1   2   61 69                       130 84 1 5   34 3     1   2   61 69                 130
837668 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000039 6658 PAGOSA SPRINGS HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_9 82 2 11   9 0     1   3   52 56                       108 82 2 11   9 0     1   3   52 56                 108
1135363 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000039 6658 PAGOSA SPRINGS HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 82.0 0.0 22.0   3.0 2.0     0.0   0.0   61.0 48.0                       109.0 82 0 22   3 2     0   0   61 48                 109
1895932 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000039 6658 PAGOSA SPRINGS HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 101 0 35   7 1     0   6   68 82                       150 101 0 35   7 1     0   6   68 82                 150
1933243 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000039 6658 PAGOSA SPRINGS HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 111 1 28   17 1     0   4   85 77                       162 111 1 28   17 1     0   4   85 77                 162
719938 CO     school 802220 3040   ARICKAREE R-2 80222000042 308 ARICKAREE UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_9 9 0 2   0 0     0   0   8 3                       11 9 0 2   0 0     0   0   8 3                 11
847508 CO     school   3040   ARICKAREE R-2   308 ARICKAREE UNDIVIDED HIGH SCHOOL             2016   grade_9 8 0 4   0 0     0   0   9 3                       12 8 0 4   0 0     0   0   9 3                 12
1145079 CO     school 802220 3040   ARICKAREE R-2 80222000042 308 ARICKAREE UNDIVIDED HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_9 2.0 0.0 2.0   0.0 0.0     0.0   0.0   0.0 4.0                       4.0 2 0 2   0 0     0   0   0 4                 4
1905883 CO     school 802220 3040   ARICKAREE R-2 80222000042 308 ARICKAREE UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_9 3 0 1   0 0     0   0   3 1                       4 3 0 1   0 0     0   0   3 1                 4
1943258 CO     school 802220 3040   ARICKAREE R-2 80222000042 308 ARICKAREE UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2019   grade_9 8 0 3   0 0     0   0   8 3                       11 8 0 3   0 0     0   0   8 3                 11
716847 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2017   grade_9 10 0 1   0 0     0   0   6 5                       11 10 0 1   0 0     0   0   6 5                 11
844443 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No 4.0 PK 12 2016   grade_9 9 0 1   0 0     0   0   6 4                       10 9 0 1   0 0     0   0   6 4                 10
1142028 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No 4.0 PK 12 2015   grade_9 10.0 0.0 1.0   0.0 0.0     0.0   0.0   6.0 5.0                       11.0 10 0 1   0 0     0   0   6 5                 11
1902783 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2018   grade_9 17 0 1   0 0     0   0   6 12                       18 17 0 1   0 0     0   0   6 12                 18
1940153 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2019   grade_9 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
718994 CO     school 802280 2640   ASPEN 1 80228000047 432 ASPEN HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 131 1 19   0 3     0   0   82 72                       154 131 1 19   0 3     0   0   82 72                 154

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