Data source: Big Local News · About: Big Local

92,494 rows where state = "CO" sorted by district

View and edit SQL

grade

year

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
1139901 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 43.0 3.0 10.0   0.0 3.0     0.0   7.0   33.0 33.0                       66.0 43 3 10   0 3     0   7   33 33                 66
1139902 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_5 56.0 1.0 9.0   0.0 1.0     0.0   3.0   37.0 33.0                       70.0 56 1 9   0 1     0   3   37 33                 70
1139903 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   kindergarten_full_day 19.0 0.0 5.0   0.0 0.0     0.0   1.0   14.0 11.0                       25.0 19 0 5   0 0     0   1   14 11                 25
1139904 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   kindergarten_half_day 21.0 0.0 4.0   0.0 0.0     0.0   3.0   18.0 10.0                       28.0 21 0 4   0 0     0   3   18 10                 28
1139905 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   pk_12_total 253.0 4.0 61.0   0.0 7.0     0.0   26.0   186.0 165.0                       351.0 253 4 61   0 7     0   26   186 165                 351
1139906 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes 3.0 07 12 2015   grade_10 79.0 2.0 6.0   0.0 2.0     0.0   6.0   46.0 49.0                       95.0 79 2 6   0 2     0   6   46 49                 95
1139907 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes 3.0 07 12 2015   grade_11 83.0 2.0 6.0   0.0 1.0     0.0   6.0   51.0 47.0                       98.0 83 2 6   0 1     0   6   51 47                 98
1139908 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes 3.0 07 12 2015   grade_12 87.0 1.0 5.0   0.0 2.0     0.0   6.0   39.0 62.0                       101.0 87 1 5   0 2     0   6   39 62                 101
1139909 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes 3.0 07 12 2015   grade_7 39.0 2.0 7.0   0.0 0.0     1.0   4.0   26.0 27.0                       53.0 39 2 7   0 0     1   4   26 27                 53
1139910 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes 3.0 07 12 2015   grade_8 53.0 0.0 6.0   0.0 2.0     0.0   1.0   30.0 32.0                       62.0 53 0 6   0 2     0   1   30 32                 62
1139911 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes 3.0 07 12 2015   grade_9 73.0 1.0 5.0   0.0 2.0     0.0   7.0   40.0 48.0                       88.0 73 1 5   0 2     0   7   40 48                 88
1139912 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes 3.0 07 12 2015   pk_12_total 414.0 8.0 35.0   0.0 9.0     1.0   30.0   232.0 265.0                       497.0 414 8 35   0 9     1   30   232 265                 497
1139913 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 52.0 0.0 6.0   1.0 4.0     0.0   6.0   36.0 33.0                       69.0 52 0 6   1 4     0   6   36 33                 69
1139914 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 42.0 0.0 7.0   0.0 0.0     0.0   4.0   21.0 32.0                       53.0 42 0 7   0 0     0   4   21 32                 53
1139915 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 55.0 1.0 10.0   0.0 6.0     0.0   5.0   38.0 39.0                       77.0 55 1 10   0 6     0   5   38 39                 77
1139916 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 45.0 1.0 16.0   1.0 3.0     0.0   2.0   35.0 33.0                       68.0 45 1 16   1 3     0   2   35 33                 68
1139917 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 65.0 5.0 7.0   0.0 2.0     0.0   7.0   47.0 39.0                       86.0 65 5 7   0 2     0   7   47 39                 86
1139918 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten_full_day 18.0 2.0 1.0   0.0 0.0     0.0   4.0   17.0 8.0                       25.0 18 2 1   0 0     0   4   17 8                 25
1139919 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten_half_day 28.0 2.0 2.0   0.0 7.0     0.0   4.0   23.0 20.0                       43.0 28 2 2   0 7     0   4   23 20                 43
1139920 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   pk_12_total 323.0 14.0 53.0   2.0 23.0     0.0   32.0   234.0 213.0                       447.0 323 14 53   2 23     0   32   234 213                 447
1139921 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2015   pre_kindergarten 18.0 3.0 4.0   0.0 1.0     0.0   0.0   17.0 9.0                       26.0 18 3 4   0 1     0   0   17 9                 26
1139922 CO     school 801920 1040   ACADEMY 20 80192001462 8851 TIMBERVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 263.0 14.0 58.0   2.0 5.0     0.0   14.0   189.0 167.0                       356.0 263 14 58   2 5     0   14   189 167                 356
1139923 CO     school 801920 1040   ACADEMY 20 80192001462 8851 TIMBERVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 232.0 17.0 44.0   3.0 4.0     1.0   23.0   167.0 157.0                       324.0 232 17 44   3 4     1   23   167 157                 324
1139924 CO     school 801920 1040   ACADEMY 20 80192001462 8851 TIMBERVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 270.0 14.0 40.0   2.0 6.0     0.0   26.0   182.0 176.0                       358.0 270 14 40   2 6     0   26   182 176                 358
1139925 CO     school 801920 1040   ACADEMY 20 80192001462 8851 TIMBERVIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   pk_12_total 765.0 45.0 142.0   7.0 15.0     1.0   63.0   538.0 500.0                       1038.0 765 45 142   7 15     1   63   538 500                 1038
1139926 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 38.0 0.0 5.0   0.0 4.0     0.0   3.0   28.0 22.0                       50.0 38 0 5   0 4     0   3   28 22                 50
1139927 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 48.0 1.0 3.0   0.0 1.0     0.0   6.0   26.0 33.0                       59.0 48 1 3   0 1     0   6   26 33                 59
1139928 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_3 47.0 0.0 4.0   0.0 3.0     0.0   6.0   26.0 34.0                       60.0 47 0 4   0 3     0   6   26 34                 60
1139929 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 33.0 0.0 7.0   0.0 3.0     0.0   1.0   21.0 23.0                       44.0 33 0 7   0 3     0   1   21 23                 44
1139930 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_5 46.0 0.0 7.0   0.0 1.0     0.0   3.0   31.0 26.0                       57.0 46 0 7   0 1     0   3   31 26                 57
1139931 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten_full_day 31.0 0.0 5.0   1.0 2.0     2.0   2.0   25.0 18.0                       43.0 31 0 5   1 2     2   2   25 18                 43
1139932 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   kindergarten_half_day 6.0 0.0 5.0   0.0 0.0     0.0   0.0   10.0 1.0                       11.0 6 0 5   0 0     0   0   10 1                 11
1139933 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   pk_12_total 268.0 1.0 41.0   1.0 15.0     2.0   22.0   181.0 169.0                       350.0 268 1 41   1 15     2   22   181 169                 350
1139934 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   pre_kindergarten 19.0 0.0 5.0   0.0 1.0     0.0   1.0   14.0 12.0                       26.0 19 0 5   0 1     0   1   14 12                 26
1900385 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 69 3 12   0 3     0   10   42 55                       97 69 3 12   0 3     0   10   42 55                 97
1900386 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 68 2 15   0 0     0   5   41 49                       90 68 2 15   0 0     0   5   41 49                 90
1900387 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_3 67 2 10   0 3     0   13   46 49                       95 67 2 10   0 3     0   13   46 49                 95
1900388 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_4 74 3 6   1 5     2   8   47 52                       99 74 3 6   1 5     2   8   47 52                 99
1900389 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_5 78 3 17   1 0     0   8   46 61                       107 78 3 17   1 0     0   8   46 61                 107
1900390 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   kindergarten_full_day 35 1 8   0 4     0   2   28 22                       50 35 1 8   0 4     0   2   28 22                 50
1900391 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   kindergarten_half_day 18 0 2   0 0     0   1   11 10                       21 18 0 2   0 0     0   1   11 10                 21
1900392 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   pk_12_total 409 14 70   2 15     2   47   261 298                       559 409 14 70   2 15     2   47   261 298                 559
1900393 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 59 4 10   0 15     0   8   48 48                       96 59 4 10   0 15     0   8   48 48                 96
1900394 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 58 6 13   0 10     0   6   49 44                       93 58 6 13   0 10     0   6   49 44                 93
1900395 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_3 69 3 10   0 15     0   9   53 53                       106 69 3 10   0 15     0   9   53 53                 106
1900396 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 68 4 15   0 12     0   5   46 58                       104 68 4 15   0 12     0   5   46 58                 104
1900397 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_5 66 4 11   0 14     1   8   54 50                       104 66 4 11   0 14     1   8   54 50                 104
1900398 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   kindergarten_full_day 43 1 6   0 14     0   6   40 30                       70 43 1 6   0 14     0   6   40 30                 70
1900399 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   kindergarten_half_day 11 0 5   0 0     0   1   13 4                       17 11 0 5   0 0     0   1   13 4                 17
1900400 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 374 22 70   0 80     1   43   303 287                       590 374 22 70   0 80     1   43   303 287                 590
1900401 CO     school 801920 1040   ACADEMY 20 80192000001 74 CHALLENGER MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_6 212 15 39   2 23     0   21   172 140                       312 212 15 39   2 23     0   21   172 140                 312
1900402 CO     school 801920 1040   ACADEMY 20 80192000001 74 CHALLENGER MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 213 7 26   1 19     0   17   146 137                       283 213 7 26   1 19     0   17   146 137                 283
1900403 CO     school 801920 1040   ACADEMY 20 80192000001 74 CHALLENGER MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_8 230 5 38   2 20     2   21   159 159                       318 230 5 38   2 20     2   21   159 159                 318
1900404 CO     school 801920 1040   ACADEMY 20 80192000001 74 CHALLENGER MIDDLE SCHOOL   Regular School No Middle 06 08 2018   pk_12_total 655 27 103   5 62     2   59   477 436                       913 655 27 103   5 62     2   59   477 436                 913
1900405 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No High 09 12 2018   grade_10 251 14 40   2 14     0   24   167 178                       345 251 14 40   2 14     0   24   167 178                 345
1900406 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No High 09 12 2018   grade_11 242 8 39   1 7     2   24   153 170                       323 242 8 39   1 7     2   24   153 170                 323
1900407 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No High 09 12 2018   grade_12 241 8 47   5 9     0   29   181 158                       339 241 8 47   5 9     0   29   181 158                 339
1900408 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 261 13 50   1 7     1   22   174 181                       355 261 13 50   1 7     1   22   174 181                 355
1900409 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No High 09 12 2018   pk_12_total 995 43 176   9 37     3   99   675 687                       1362 995 43 176   9 37     3   99   675 687                 1362
1900410 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2018   grade_10 32 2 3   0 1     0   2   22 18                       40 32 2 3   0 1     0   2   22 18                 40
1900411 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2018   grade_11 36 2 1   0 0     0   1   24 16                       40 36 2 1   0 0     0   1   24 16                 40
1900412 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2018   grade_12 9 0 1   0 1     0   0   4 7                       11 9 0 1   0 1     0   0   4 7                 11
1900413 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2018   grade_9 28 2 3   0 0     0   0   15 18                       33 28 2 3   0 0     0   0   15 18                 33
1900414 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2018   pk_12_total 105 6 8   0 2     0   3   65 59                       124 105 6 8   0 2     0   3   65 59                 124
1900415 CO     school 801920 1040   ACADEMY 20 80192000858 209 ASPEN VALLEY CAMPUS   Alternative School No High 07 12 2018   grade_10 16 0 2   1 1     0   1   12 9                       21 16 0 2   1 1     0   1   12 9                 21
1900416 CO     school 801920 1040   ACADEMY 20 80192000858 209 ASPEN VALLEY CAMPUS   Alternative School No High 07 12 2018   grade_11 20 0 1   0 0     1   2   11 13                       24 20 0 1   0 0     1   2   11 13                 24
1900417 CO     school 801920 1040   ACADEMY 20 80192000858 209 ASPEN VALLEY CAMPUS   Alternative School No High 07 12 2018   grade_12 15 1 10   0 0     1   1   13 15                       28 15 1 10   0 0     1   1   13 15                 28
1900418 CO     school 801920 1040   ACADEMY 20 80192000858 209 ASPEN VALLEY CAMPUS   Alternative School No High 07 12 2018   grade_7 10 1 2   0 0     0   0   13 0                       13 10 1 2   0 0     0   0   13 0                 13
1900419 CO     school 801920 1040   ACADEMY 20 80192000858 209 ASPEN VALLEY CAMPUS   Alternative School No High 07 12 2018   grade_8 21 1 3   0 1     0   2   16 12                       28 21 1 3   0 1     0   2   16 12                 28
1900420 CO     school 801920 1040   ACADEMY 20 80192000858 209 ASPEN VALLEY CAMPUS   Alternative School No High 07 12 2018   grade_9 12 0 3   0 1     0   0   6 10                       16 12 0 3   0 1     0   0   6 10                 16
1900421 CO     school 801920 1040   ACADEMY 20 80192000858 209 ASPEN VALLEY CAMPUS   Alternative School No High 07 12 2018   pk_12_total 94 3 21   1 3     2   6   71 59                       130 94 3 21   1 3     2   6   71 59                 130
1900422 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 36 2 7   1 2     0   3   28 23                       51 36 2 7   1 2     0   3   28 23                 51
1900423 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 36 1 3   0 0     0   6   22 24                       46 36 1 3   0 0     0   6   22 24                 46
1900424 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_3 40 1 9   1 2     0   3   27 29                       56 40 1 9   1 2     0   3   27 29                 56
1900425 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 48 1 11   0 0     0   1   35 26                       61 48 1 11   0 0     0   1   35 26                 61
1900426 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_5 49 0 5   0 0     0   3   20 37                       57 49 0 5   0 0     0   3   20 37                 57
1900427 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   kindergarten_full_day 36 1 5   0 3     0   1   27 19                       46 36 1 5   0 3     0   1   27 19                 46
1900428 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   kindergarten_half_day 16 0 2   0 0     0   2   12 8                       20 16 0 2   0 0     0   2   12 8                 20
1900429 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 276 7 46   3 11     0   21   188 176                       364 276 7 46   3 11     0   21   188 176                 364
1900430 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pre_kindergarten 15 1 4   1 4     0   2   17 10                       27 15 1 4   1 4     0   2   17 10                 27
1900431 CO     school 801920 1040   ACADEMY 20 80192006619 1033 BRIARGATE PRESCHOOL   Regular School No Prekindergarten PK PK 2018   pk_12_total 78 8 24   0 16     0   9   75 60                       135 78 8 24   0 16     0   9   75 60                 135
1900432 CO     school 801920 1040   ACADEMY 20 80192006619 1033 BRIARGATE PRESCHOOL   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 78 8 24   0 16     0   9   75 60                       135 78 8 24   0 16     0   9   75 60                 135
1900433 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 123 3 13   2 13     0   15   91 78                       169 123 3 13   2 13     0   15   91 78                 169
1900434 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 120 2 20   0 8     0   13   81 82                       163 120 2 20   0 8     0   13   81 82                 163
1900435 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_3 115 5 18   0 8     1   18   83 82                       165 115 5 18   0 8     1   18   83 82                 165
1900436 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_4 134 4 19   2 17     0   17   99 94                       193 134 4 19   2 17     0   17   99 94                 193
1900437 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_5 130 5 16   0 15     0   10   98 78                       176 130 5 16   0 15     0   10   98 78                 176
1900438 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   kindergarten_full_day 105 1 10   0 3     0   6   58 67                       125 105 1 10   0 3     0   6   58 67                 125
1900439 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   kindergarten_half_day 10 0 3   0 1     0   3   10 7                       17 10 0 3   0 1     0   3   10 7                 17
1900440 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   pk_12_total 737 20 99   4 65     1   82   520 488                       1008 737 20 99   4 65     1   82   520 488                 1008
1900441 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2018   grade_1 288 5 23   2 10     0   18   171 175                       346 288 5 23   2 10     0   18   171 175                 346
1900442 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2018   grade_2 268 5 36   1 6     0   21   162 175                       337 268 5 36   1 6     0   21   162 175                 337
1900443 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2018   grade_3 264 4 23   1 9     0   16   159 158                       317 264 4 23   1 9     0   16   159 158                 317
1900444 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2018   grade_4 228 9 31   0 7     1   18   144 150                       294 228 9 31   0 7     1   18   144 150                 294
1900445 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2018   grade_5 237 6 28   3 13     1   11   166 133                       299 237 6 28   3 13     1   11   166 133                 299
1900446 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2018   grade_6 208 7 27   0 5     1   6   120 134                       254 208 7 27   0 5     1   6   120 134                 254
1900447 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2018   kindergarten_half_day 304 6 32   2 8     1   15   194 174                       368 304 6 32   2 8     1   15   194 174                 368
1900448 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2018   pk_12_total 1797 42 200   9 58     4   105   1116 1099                       2215 1797 42 200   9 58     4   105   1116 1099                 2215
1900449 CO     school 801920 1040   ACADEMY 20 80192001931 1629 THE CLASSICAL ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 07 08 2018   grade_7 177 5 13   1 8     0   6   108 102                       210 177 5 13   1 8     0   6   108 102                 210
1900450 CO     school 801920 1040   ACADEMY 20 80192001931 1629 THE CLASSICAL ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 07 08 2018   grade_8 192 1 21   1 7     2   10   111 123                       234 192 1 21   1 7     2   10   111 123                 234

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