enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
709487 709487 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_2 1 2 0   0 0     0   0   2 1                       3 1 2 0   0 0     0   0   2 1                 3
837132 837132 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_2 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1801018 1801018 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_2 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1932685 1932685 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_2 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
712685 712685 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 76 2 11   0 1     0   4   43 51                       94 76 2 11   0 1     0   4   43 51                 94
840317 840317 CO     school   900   DOUGLAS COUNTY RE 1   11 ACADEMY CHARTER SCHOOL             2016   grade_2 70 0 7   0 3     0   4   37 47                       84 70 0 7   0 3     0   4   37 47                 84
1137951 1137951 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_2 72.0 0.0 9.0   0.0 2.0     1.0   4.0   53.0 35.0                       88.0 72 0 9   0 2     1   4   53 35                 88
1743219 1743219 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_2 74 3 5   0 2     0   2   41 45                       86 74 3 5   0 2     0   2   41 45                 86
1804247 1804247 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_2 72 2 10   1 4     0   6   42 53                       95 72 2 10   1 4     0   6   42 53                 95
1898597 1898597 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_2 74 1 10   0 1     0   4   39 51                       90 74 1 10   0 1     0   4   39 51                 90
1935934 1935934 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 63 2 10   0 2     0   4   36 45                       81 63 2 10   0 2     0   4   36 45                 81
712696 712696 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 39 1 9   1 25     0   8   36 47                       83 39 1 9   1 25     0   8   36 47                 83
840328 840328 CO     school   900   DOUGLAS COUNTY RE 1   12 ACRES GREEN ELEMENTARY SCHOOL             2016   grade_2 49 1 19   0 23     0   11   58 45                       103 49 1 19   0 23     0   11   58 45                 103
1137962 1137962 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 55.0 3.0 14.0   0.0 15.0     0.0   7.0   55.0 39.0                       94.0 55 3 14   0 15     0   7   55 39                 94
1743229 1743229 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_2 31 0 10   1 11     0   4   33 24                       57 31 0 10   1 11     0   4   33 24                 57
1804258 1804258 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2020   grade_2 27 1 16   0 9     0   3   28 28                       56 27 1 16   0 9     0   3   28 28                 56
1898608 1898608 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 39 5 12   0 8     0   8   43 29                       72 39 5 12   0 8     0   8   43 29                 72
1935945 1935945 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 29 1 10   1 17     1   7   34 32                       66 29 1 10   1 17     1   7   34 32                 66
707967 707967 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 0 29   1 5     1   4   44 31                       75 35 0 29   1 5     1   4   44 31                 75
835632 835632 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   14 GLACIER PEAK ELEMENTARY SCHOOL             2016   grade_2 40 2 33   1 5     0   3   37 47                       84 40 2 33   1 5     0   3   37 47                 84
1133355 1133355 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 62.0 3.0 24.0   0.0 3.0     0.0   7.0   57.0 42.0                       99.0 62 3 24   0 3     0   7   57 42                 99
1738403 1738403 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   grade_2 34 0 28   0 3     0   2   35 32                       67 34 0 28   0 3     0   2   35 32                 67
1799462 1799462 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   grade_2 35 0 36   1 6     0   2   41 39                       80 35 0 36   1 6     0   2   41 39                 80
1893835 1893835 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 38 0 24   0 2     0   4   38 30                       68 38 0 24   0 2     0   4   38 30                 68
1931107 1931107 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 35 1 35   0 3     0   2   40 36                       76 35 1 35   0 3     0   2   40 36                 76
720624 720624 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_2 85 1 31   0 10     0   12   87 52                       139 85 1 31   0 10     0   12   87 52                 139
848192 848192 CO     school   8001   CHARTER SCHOOL INSTITUTE   15 ACADEMY OF CHARTER SCHOOLS             2016   grade_2 98 2 25   0 8     0   7   71 69                       140 98 2 25   0 8     0   7   71 69                 140
1145760 1145760 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes 4.0 PK 12 2015   grade_2 99.0 0.0 29.0   0.0 10.0     0.0   4.0   66.0 76.0                       142.0 99 0 29   0 10     0   4   66 76                 142
1751084 1751084 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_2 86 1 33   0 13     0   9   64 78                       142 86 1 33   0 13     0   9   64 78                 142
1812199 1812199 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_2 83 0 34   0 9     0   12   69 69                       138 83 0 34   0 9     0   12   69 69                 138
1906572 1906572 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2018   grade_2 82 1 23   0 6     1   11   64 60                       124 82 1 23   0 6     1   11   64 60                 124
1943944 1943944 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_2 92 1 37   0 6     0   4   75 65                       140 92 1 37   0 6     0   4   75 65                 140
708891 708891 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 69 8 12   1 11     0   5   49 57                       106 69 8 12   1 11     0   5   49 57                 106
836537 836537 CO     school   130   CHERRY CREEK 5   16 FOX HOLLOW ELEMENTARY SCHOOL             2016   grade_2 59 4 5   0 11     0   8   45 42                       87 59 4 5   0 11     0   8   45 42                 87
1134262 1134262 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 77.0 7.0 14.0   0.0 12.0     0.0   7.0   70.0 47.0                       117.0 77 7 14   0 12     0   7   70 47                 117
1739349 1739349 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   grade_2 52 8 7   0 11     0   2   42 38                       80 52 8 7   0 11     0   2   42 38                 80
1800399 1800399 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2020   grade_2 54 10 10   1 15     0   7   49 48                       97 54 10 10   1 15     0   7   49 48                 97
1894779 1894779 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 55 2 10   1 16     0   9   46 47                       93 55 2 10   1 16     0   9   46 47                 93
1932075 1932075 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 64 3 13   0 17     0   6   53 50                       103 64 3 13   0 17     0   6   53 50                 103
714473 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
842088 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
1139702 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
1744979 1744979 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   grade_2 41 1 8   0 1     0   4   29 26                       55 41 1 8   0 1     0   4   29 26                 55
1806068 1806068 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_2 48 1 7   0 4     0   7   33 34                       67 48 1 7   0 4     0   7   33 34                 67
1900386 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
1937765 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
714481 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
842096 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
1139710 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
1744986 1744986 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   grade_2 39 3 8   0 12     1   7   31 39                       70 39 3 8   0 12     1   7   31 39                 70
1806075 1806075 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_2 54 1 12   1 11     2   10   48 43                       91 54 1 12   1 11     2   10   48 43                 91
1900394 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
1937773 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
719312 719312 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 34 1 31   0 0     0   1   34 33                       67 34 1 31   0 0     0   1   34 33                 67
846881 846881 CO     school   2700   PUEBLO COUNTY 70   26 DESERT SAGE ELEMENTARY SCHOOL             2016   grade_2 42 0 38   0 0     0   0   44 36                       80 42 0 38   0 0     0   0   44 36                 80
1144453 1144453 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 34.0 1.0 33.0   0.0 1.0     0.0   1.0   31.0 39.0                       70.0 34 1 33   0 1     0   1   31 39                 70
1749741 1749741 CO     school 806150 2700   Pueblo County 70 80615001718 26 Desert Sage Elementary School   Regular School No Elementary PK 05 2021   grade_2 13 0 30   0 0     0   2   24 21                       45 13 0 30   0 0     0   2   24 21                 45
1810870 1810870 CO     school 806150 2700   Pueblo County 70 80615001718 26 Desert Sage Elementary School   Regular School No Elementary PK 05 2020   grade_2 36 0 19   0 1     0   2   32 26                       58 36 0 19   0 1     0   2   32 26                 58
1905269 1905269 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 31 0 29   0 3     0   8   40 31                       71 31 0 29   0 3     0   8   40 31                 71
1942626 1942626 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 29 0 19   0 0     0   2   22 28                       50 29 0 19   0 0     0   2   22 28                 50
715520 715520 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 29 0 9   0 2     0   4   27 17                       44 29 0 9   0 2     0   4   27 17                 44
843125 843125 CO     school   1420   JEFFERSON COUNTY R-1   30 ADAMS ELEMENTARY SCHOOL             2016   grade_2 41 0 12   0 4     0   3   30 30                       60 41 0 12   0 4     0   3   30 30                 60
1140731 1140731 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 40.0 1.0 8.0   0.0 6.0     0.0   3.0   25.0 33.0                       58.0 40 1 8   0 6     0   3   25 33                 58
1746116 1746116 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_2 27 1 16   0 3     0   3   25 25                       50 27 1 16   0 3     0   3   25 25                 50
1807201 1807201 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_2 25 2 12   1 4     0   5   28 21                       49 25 2 12   1 4     0   5   28 21                 49
1901438 1901438 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 42 0 15   0 2     0   0   31 28                       59 42 0 15   0 2     0   0   31 28                 59
1938857 1938857 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 4 16   0 2     0   2   34 30                       64 40 4 16   0 2     0   2   34 30                 64
720636 720636 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
848204 848204 CO     school   8001   CHARTER SCHOOL INSTITUTE   35 FRONTIER CHARTER ACADEMY             2016   grade_2 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
1145772 1145772 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_2 4.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 4.0                       5.0 4 0 1   0 0     0   0   1 4                 5
1906585 1906585 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2018   grade_2 2 1 0   0 0     0   0   2 1                       3 2 1 0   0 0     0   0   2 1                 3
1943957 1943957 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
713411 713411 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 20 0 30   1 0     0   1   24 28                       52 20 0 30   1 0     0   1   24 28                 52
841028 841028 CO     school   910   EAGLE COUNTY RE 50   37 RED HILL ELEMENTARY SCHOOL             2016   grade_2 29 0 37   1 0     0   1   28 40                       68 29 0 37   1 0     0   1   28 40                 68
1138644 1138644 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 25.0 0.0 34.0   0.0 0.0     0.0   1.0   35.0 25.0                       60.0 25 0 34   0 0     0   1   35 25                 60
1743900 1743900 CO     school 803540 910   Eagle County RE 50 80354001721 37 Red Hill Elementary School   Regular School No Elementary PK 05 2021   grade_2 13 0 32   0 0     0   1   27 19                       46 13 0 32   0 0     0   1   27 19                 46
1804974 1804974 CO     school 803540 910   Eagle County RE 50 80354001721 37 Red Hill Elementary School   Regular School No Elementary PK 05 2020   grade_2 24 1 36   0 0     0   1   34 28                       62 24 1 36   0 0     0   1   34 28                 62
1899321 1899321 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 23 0 51   0 0     0   2   46 30                       76 23 0 51   0 0     0   2   46 30                 76
1936689 1936689 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 17 0 34   0 0     0   3   31 23                       54 17 0 34   0 0     0   3   31 23                 54
713419 713419 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 0 8   1 0     0   0   28 30                       58 49 0 8   1 0     0   0   28 30                 58
841037 841037 CO     school   910   EAGLE COUNTY RE 50   38 BRUSH CREEK ELEMENTARY SCHOOL             2016   grade_2 54 0 10   0 1     0   0   36 29                       65 54 0 10   0 1     0   0   36 29                 65
1138652 1138652 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 57.0 1.0 11.0   1.0 0.0     0.0   1.0   40.0 31.0                       71.0 57 1 11   1 0     0   1   40 31                 71
1743908 1743908 CO     school 803540 910   Eagle County RE 50 80354001722 38 Brush Creek Elementary School   Regular School No Elementary PK 05 2021   grade_2 43 0 11   0 0     0   3   28 29                       57 43 0 11   0 0     0   3   28 29                 57
1804982 1804982 CO     school 803540 910   Eagle County RE 50 80354001722 38 Brush Creek Elementary School   Regular School No Elementary PK 05 2020   grade_2 54 0 11   0 0     0   1   39 27                       66 54 0 11   0 0     0   1   39 27                 66
1899329 1899329 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 47 0 10   0 1     0   1   33 26                       59 47 0 10   0 1     0   1   33 26                 59
1936698 1936698 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 42 0 7   0 0     0   6   34 21                       55 42 0 7   0 0     0   6   34 21                 55
718970 718970 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 14 0 1   0 0     0   1   8 8                       16 14 0 1   0 0     0   1   8 8                 16
846533 846533 CO     school   2640   ASPEN 1   42 ASPEN COMMUNITY CHARTER SCHOOL             2016   grade_2 13 0 2   0 0     0   0   8 7                       15 13 0 2   0 0     0   0   8 7                 15
1144102 1144102 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_2 14.0 0.0 0.0   1.0 0.0     0.0   0.0   7.0 8.0                       15.0 14 0 0   1 0     0   0   7 8                 15
1749398 1749398 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2021   grade_2 12 0 0   0 2     0   0   8 6                       14 12 0 0   0 2     0   0   8 6                 14
1810530 1810530 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_2 13 0 1   0 1     0   0   7 8                       15 13 0 1   0 1     0   0   7 8                 15
1904919 1904919 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_2 14 0 0   0 1     0   0   7 8                       15 14 0 0   0 1     0   0   7 8                 15
1942274 1942274 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 13 0 1   0 0     1   0   8 7                       15 13 0 1   0 0     1   0   8 7                 15
1138873 1138873 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 2.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 2.0                       3.0 2 0 1   0 0     0   0   1 2                 3
1744118 1744118 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2021   grade_2 8 0 2   0 0     0   0   6 4                       10 8 0 2   0 0     0   0   6 4                 10
1805202 1805202 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 0 1   0 0     0   0   4 0                       4 3 0 1   0 0     0   0   4 0                 4
1899552 1899552 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1936919 1936919 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 3 0 1   0 0     0   0   2 2                       4 3 0 1   0 0     0   0   2 2                 4
712664 712664 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
840293 840293 CO     school   890   DOLORES COUNTY RE NO.2   50 RICO ELEMENTARY SCHOOL             2016   grade_2 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3

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