Data source: Big Local News · About: Big Local

7,625 rows where grade = "grade_2" and state = "CO" sorted by district

View and edit SQL

year

grade

  • grade_2 · 7,625
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
714473 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 57 5 14   0 3     0   8   38 49                       87 57 5 14   0 3     0   8   38 49                 87
714481 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 73 2 7   0 12     0   9   51 52                       103 73 2 7   0 12     0   9   51 52                 103
714510 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 44 0 6   1 2     0   1   24 30                       54 44 0 6   1 2     0   1   24 30                 54
714521 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 104 9 20   0 5     0   15   75 78                       153 104 9 20   0 5     0   15   75 78                 153
714529 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2017   grade_2 275 3 23   1 9     0   15   166 160                       326 275 3 23   1 9     0   15   166 160                 326
714545 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2017   grade_2 5 0 1   0 0     0   2   5 3                       8 5 0 1   0 0     0   2   5 3                 8
714559 CO     school 801920 1040   ACADEMY 20 80192006631 1929 DISCOVERY CANYON CAMPUS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 55 6 2   0 2     1   4   39 31                       70 55 6 2   0 2     1   4   39 31                 70
714573 CO     school 801920 1040   ACADEMY 20 80192000003 2248 DOUGLASS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 4 12   0 1     0   9   36 25                       61 35 4 12   0 1     0   9   36 25                 61
714585 CO     school 801920 1040   ACADEMY 20 80192000004 2524 EDITH WOLFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 40 0 4   0 1     0   3   29 19                       48 40 0 4   0 1     0   3   29 19                 48
714594 CO     school 801920 1040   ACADEMY 20 80192001496 2800 EXPLORER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 59 0 12   1 0     0   4   47 29                       76 59 0 12   1 0     0   4   47 29                 76
714603 CO     school 801920 1040   ACADEMY 20 80192001319 3104 FOOTHILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 50 0 15   0 1     0   6   41 31                       72 50 0 15   0 1     0   6   41 31                 72
714611 CO     school 801920 1040   ACADEMY 20 80192001387 3238 FRONTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 39 1 8   0 1     0   8   30 27                       57 39 1 8   0 1     0   8   30 27                 57
714620 CO     school 801920 1040   ACADEMY 20 80192001320 3985 HIGH PLAINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 27 6 14   1 2     0   4   29 25                       54 27 6 14   1 2     0   4   29 25                 54
714638 CO     school 801920 1040   ACADEMY 20 80192000005 6158 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 77 4 15   0 4     0   7   51 56                       107 77 4 15   0 4     0   7   51 56                 107
714651 CO     school 801920 1040   ACADEMY 20 80192001430 6960 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 2 19   0 2     0   7   32 33                       65 35 2 19   0 2     0   7   32 33                 65
714659 CO     school 801920 1040   ACADEMY 20 80192000531 7159 PRAIRIE HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 37 1 15   1 1     0   9   35 29                       64 37 1 15   1 1     0   9   35 29                 64
714672 CO     school 801920 1040   ACADEMY 20 80192006336 7247 RANCH CREEK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 74 5 13   0 6     0   3   43 58                       101 74 5 13   0 6     0   3   43 58                 101
714681 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 43 1 11   0 0     0   4   32 27                       59 43 1 11   0 0     0   4   32 27                 59
714696 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 56 4 6   0 5     0   7   44 34                       78 56 4 6   0 5     0   7   44 34                 78
714709 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 1 12   1 2     0   4   43 26                       69 49 1 12   1 2     0   4   43 26                 69
842088 CO     school   1040   ACADEMY 20   17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL             2016   grade_2 73 3 6   1 3     2   5   45 48                       93 73 3 6   1 3     2   5   45 48                 93
842096 CO     school   1040   ACADEMY 20   19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL             2016   grade_2 68 7 13   0 11     1   8   51 57                       108 68 7 13   0 11     1   8   51 57                 108
842125 CO     school   1040   ACADEMY 20   249 ANTELOPE TRAILS ELEMENTARY SCHOOL             2016   grade_2 45 1 8   0 0     0   1   32 23                       55 45 1 8   0 0     0   1   32 23                 55
842136 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 106 3 15   1 14     0   14   74 79                       153 106 3 15   1 14     0   14   74 79                 153
842144 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes 1.0 KG 06 2016   grade_2 255 8 32   1 8     1   18   161 162                       323 255 8 32   1 8     1   18   161 162                 323
842160 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No 1.0 KG 08 2016   grade_2 12 0 5   0 0     0   0   6 11                       17 12 0 5   0 0     0   0   6 11                 17
842174 CO     school 801920 1040   ACADEMY 20 80192006631 1929 DISCOVERY CANYON CAMPUS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 56 3 9   0 5     0   5   36 42                       78 56 3 9   0 5     0   5   36 42                 78
842188 CO     school 801920 1040   ACADEMY 20 80192000003 2248 DOUGLASS VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 22 7 10   1 1     2   6   17 32                       49 22 7 10   1 1     2   6   17 32                 49
842200 CO     school 801920 1040   ACADEMY 20 80192000004 2524 EDITH WOLFORD ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 36 2 8   0 0     0   2   28 20                       48 36 2 8   0 0     0   2   28 20                 48
842209 CO     school 801920 1040   ACADEMY 20 80192001496 2800 EXPLORER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 53 1 13   1 1     0   5   40 34                       74 53 1 13   1 1     0   5   40 34                 74
842218 CO     school 801920 1040   ACADEMY 20 80192001319 3104 FOOTHILLS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 52 2 9   0 2     0   8   33 40                       73 52 2 9   0 2     0   8   33 40                 73
842226 CO     school 801920 1040   ACADEMY 20 80192001387 3238 FRONTIER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 42 2 15   0 0     1   4   34 30                       64 42 2 15   0 0     1   4   34 30                 64
842235 CO     school 801920 1040   ACADEMY 20 80192001320 3985 HIGH PLAINS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 27 2 10   0 3     0   4   26 20                       46 27 2 10   0 3     0   4   26 20                 46
842253 CO     school 801920 1040   ACADEMY 20 80192000005 6158 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 71 3 11   0 2     0   6   46 47                       93 71 3 11   0 2     0   6   46 47                 93
842266 CO     school 801920 1040   ACADEMY 20 80192001430 6960 PIONEER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 41 0 14   0 3     0   5   39 24                       63 41 0 14   0 3     0   5   39 24                 63
842274 CO     school 801920 1040   ACADEMY 20 80192000531 7159 PRAIRIE HILLS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 56 1 11   1 0     0   4   36 37                       73 56 1 11   1 0     0   4   36 37                 73
842287 CO     school 801920 1040   ACADEMY 20 80192006336 7247 RANCH CREEK ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_2 60 0 11   1 4     0   7   38 45                       83 60 0 11   1 4     0   7   38 45                 83
842296 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 38 1 12   0 0     0   2   33 20                       53 38 1 12   0 0     0   2   33 20                 53
842311 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 55 0 11   1 5     0   8   42 38                       80 55 0 11   1 5     0   8   42 38                 80
842324 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 46 1 6   0 4     0   5   34 28                       62 46 1 6   0 4     0   5   34 28                 62
1139702 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 70.0 4.0 16.0   1.0 0.0     0.0   7.0   48.0 50.0                       98.0 70 4 16   1 0     0   7   48 50                 98
1139710 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 61.0 4.0 17.0   0.0 14.0     1.0   10.0   52.0 55.0                       107.0 61 4 17   0 14     1   10   52 55                 107
1139739 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 63.0 0.0 7.0   0.0 1.0     0.0   5.0   31.0 45.0                       76.0 63 0 7   0 1     0   5   31 45                 76
1139750 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 103.0 3.0 14.0   0.0 10.0     0.0   9.0   71.0 68.0                       139.0 103 3 14   0 10     0   9   71 68                 139
1139758 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes 1.0 KG 06 2015   grade_2 265.0 7.0 33.0   2.0 15.0     1.0   11.0   178.0 156.0                       334.0 265 7 33   2 15     1   11   178 156                 334
1139778 CO     school 801920 1040   ACADEMY 20 80192006631 1929 DISCOVERY CANYON CAMPUS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 66.0 2.0 6.0   0.0 2.0     0.0   5.0   46.0 35.0                       81.0 66 2 6   0 2     0   5   46 35                 81
1139792 CO     school 801920 1040   ACADEMY 20 80192000003 2248 DOUGLASS VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 30.0 5.0 16.0   1.0 0.0     0.0   6.0   27.0 31.0                       58.0 30 5 16   1 0     0   6   27 31                 58
1139804 CO     school 801920 1040   ACADEMY 20 80192000004 2524 EDITH WOLFORD ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 35.0 0.0 11.0   0.0 1.0     0.0   5.0   20.0 32.0                       52.0 35 0 11   0 1     0   5   20 32                 52
1139813 CO     school 801920 1040   ACADEMY 20 80192001496 2800 EXPLORER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 59.0 1.0 8.0   1.0 1.0     0.0   8.0   43.0 35.0                       78.0 59 1 8   1 1     0   8   43 35                 78
1139822 CO     school 801920 1040   ACADEMY 20 80192001319 3104 FOOTHILLS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 53.0 0.0 14.0   0.0 0.0     0.0   3.0   30.0 40.0                       70.0 53 0 14   0 0     0   3   30 40                 70
1139830 CO     school 801920 1040   ACADEMY 20 80192001387 3238 FRONTIER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 50.0 2.0 15.0   1.0 4.0     1.0   4.0   44.0 33.0                       77.0 50 2 15   1 4     1   4   44 33                 77
1139839 CO     school 801920 1040   ACADEMY 20 80192001320 3985 HIGH PLAINS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 27.0 2.0 14.0   0.0 3.0     0.0   4.0   21.0 29.0                       50.0 27 2 14   0 3     0   4   21 29                 50
1139856 CO     school 801920 1040   ACADEMY 20 80192000005 6158 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 60.0 1.0 7.0   0.0 4.0     0.0   7.0   43.0 36.0                       79.0 60 1 7   0 4     0   7   43 36                 79
1139869 CO     school 801920 1040   ACADEMY 20 80192001430 6960 PIONEER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 41.0 5.0 16.0   0.0 2.0     1.0   4.0   38.0 31.0                       69.0 41 5 16   0 2     1   4   38 31                 69
1139877 CO     school 801920 1040   ACADEMY 20 80192000531 7159 PRAIRIE HILLS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 58.0 3.0 15.0   0.0 0.0     1.0   4.0   33.0 48.0                       81.0 58 3 15   0 0     1   4   33 48                 81
1139890 CO     school 801920 1040   ACADEMY 20 80192006336 7247 RANCH CREEK ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_2 62.0 2.0 8.0   0.0 0.0     0.0   5.0   46.0 31.0                       77.0 62 2 8   0 0     0   5   46 31                 77
1139899 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 46.0 0.0 7.0   0.0 1.0     0.0   4.0   32.0 26.0                       58.0 46 0 7   0 1     0   4   32 26                 58
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
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
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
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
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
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
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
1900458 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2018   grade_2 4 0 2   0 0     0   0   3 3                       6 4 0 2   0 0     0   0   3 3                 6
1900472 CO     school 801920 1040   ACADEMY 20 80192006631 1929 DISCOVERY CANYON CAMPUS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 63 0 8   0 2     0   7   43 37                       80 63 0 8   0 2     0   7   43 37                 80
1900486 CO     school 801920 1040   ACADEMY 20 80192000003 2248 DOUGLASS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 35 2 13   0 1     1   9   28 33                       61 35 2 13   0 1     1   9   28 33                 61
1900498 CO     school 801920 1040   ACADEMY 20 80192000004 2524 EDITH WOLFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 33 0 9   0 0     0   2   22 22                       44 33 0 9   0 0     0   2   22 22                 44
1900507 CO     school 801920 1040   ACADEMY 20 80192001496 2800 EXPLORER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 55 1 10   0 0     0   6   34 38                       72 55 1 10   0 0     0   6   34 38                 72
1900516 CO     school 801920 1040   ACADEMY 20 80192001319 3104 FOOTHILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 48 3 19   0 0     0   10   35 45                       80 48 3 19   0 0     0   10   35 45                 80
1900524 CO     school 801920 1040   ACADEMY 20 80192001387 3238 FRONTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 34 0 13   0 2     0   5   22 32                       54 34 0 13   0 2     0   5   22 32                 54
1900533 CO     school 801920 1040   ACADEMY 20 80192001320 3985 HIGH PLAINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 24 2 15   1 4     0   3   25 24                       49 24 2 15   1 4     0   3   25 24                 49
1900551 CO     school 801920 1040   ACADEMY 20 80192000005 6158 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 82 1 8   1 5     2   7   60 46                       106 82 1 8   1 5     2   7   60 46                 106
1900564 CO     school 801920 1040   ACADEMY 20 80192001430 6960 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 44 7 14   0 0     0   6   32 39                       71 44 7 14   0 0     0   6   32 39                 71
1900572 CO     school 801920 1040   ACADEMY 20 80192000531 7159 PRAIRIE HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 39 2 11   0 1     0   4   32 25                       57 39 2 11   0 1     0   4   32 25                 57
1900585 CO     school 801920 1040   ACADEMY 20 80192006336 7247 RANCH CREEK ELEMENTARY   Regular School No Elementary PK 05 2018   grade_2 61 2 15   0 2     0   11   46 45                       91 61 2 15   0 2     0   11   46 45                 91
1900594 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 44 4 11   0 2     0   3   27 37                       64 44 4 11   0 2     0   3   27 37                 64
1900609 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 43 4 12   0 7     0   3   35 34                       69 43 4 12   0 7     0   3   35 34                 69
1900622 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 63 2 11   0 1     0   4   38 43                       81 63 2 11   0 1     0   4   38 43                 81
1937765 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 60 2 7   0 3     0   8   34 46                       80 60 2 7   0 3     0   8   34 46                 80
1937773 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 62 4 12   0 15     0   10   48 55                       103 62 4 12   0 15     0   10   48 55                 103
1937802 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 35 1 5   1 2     0   2   24 22                       46 35 1 5   1 2     0   2   24 22                 46
1937813 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 133 3 19   2 9     0   16   91 91                       182 133 3 19   2 9     0   16   91 91                 182
1937821 CO     school 801920 1040   ACADEMY 20 80192001592 1627 THE CLASSICAL ACADEMY CHARTER   Regular School Yes Elementary KG 06 2019   grade_2 271 5 21   2 11     0   16   158 168                       326 271 5 21   2 11     0   16   158 168                 326
1937837 CO     school 801920 1040   ACADEMY 20 80192006478 1901 JOURNEY K8   Regular School No Elementary KG 08 2019   grade_2 10 0 3   0 0     0   0   5 8                       13 10 0 3   0 0     0   0   5 8                 13
1937851 CO     school 801920 1040   ACADEMY 20 80192006631 1929 DISCOVERY CANYON CAMPUS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 52 3 10   0 6     0   4   47 28                       75 52 3 10   0 6     0   4   47 28                 75
1937865 CO     school 801920 1040   ACADEMY 20 80192000003 2248 DOUGLASS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 37 5 8   0 2     1   3   24 32                       56 37 5 8   0 2     1   3   24 32                 56
1937877 CO     school 801920 1040   ACADEMY 20 80192000004 2524 EDITH WOLFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 2 7   0 0     0   0   33 16                       49 40 2 7   0 0     0   0   33 16                 49
1937886 CO     school 801920 1040   ACADEMY 20 80192001496 2800 EXPLORER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 57 1 14   0 0     1   5   48 30                       78 57 1 14   0 0     1   5   48 30                 78
1937895 CO     school 801920 1040   ACADEMY 20 80192001319 3104 FOOTHILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 47 0 24   0 1     0   8   37 43                       80 47 0 24   0 1     0   8   37 43                 80
1937903 CO     school 801920 1040   ACADEMY 20 80192001387 3238 FRONTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 44 1 12   2 1     0   7   36 31                       67 44 1 12   2 1     0   7   36 31                 67
1937912 CO     school 801920 1040   ACADEMY 20 80192001320 3985 HIGH PLAINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 26 3 16   0 3     2   2   24 28                       52 26 3 16   0 3     2   2   24 28                 52
1937930 CO     school 801920 1040   ACADEMY 20 80192000005 6158 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 65 2 20   0 9     1   8   60 45                       105 65 2 20   0 9     1   8   60 45                 105
1937938 CO     school 801920 1040   ACADEMY 20 80192006745 6242 NEW SUMMIT CHARTER ACADEMY   Regular School Yes Elementary KG 06 2019   grade_2 40 1 8   0 3     0   6   37 21                       58 40 1 8   0 3     0   6   37 21                 58
1937947 CO     school 801920 1040   ACADEMY 20 80192006758 6247 LEGACY PEAK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 41 5 6   0 4     0   4   29 31                       60 41 5 6   0 4     0   4   29 31                 60
1937961 CO     school 801920 1040   ACADEMY 20 80192001430 6960 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 39 4 14   1 5     0   2   35 30                       65 39 4 14   1 5     0   2   35 30                 65
1937969 CO     school 801920 1040   ACADEMY 20 80192000531 7159 PRAIRIE HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 50 2 21   1 0     0   6   39 41                       80 50 2 21   1 0     0   6   39 41                 80
1937982 CO     school 801920 1040   ACADEMY 20 80192006336 7247 RANCH CREEK ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 65 2 17   0 3     0   7   45 49                       94 65 2 17   0 3     0   7   45 49                 94
1937991 CO     school 801920 1040   ACADEMY 20 80192000007 7460 ROCKRIMMON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 43 1 5   0 0     0   3   18 34                       52 43 1 5   0 0     0   3   18 34                 52
1938006 CO     school 801920 1040   ACADEMY 20 80192001842 8813 THE DA VINCI ACADEMY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 44 2 6   0 12     0   6   34 36                       70 44 2 6   0 12     0   6   34 36                 70

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