Data source: Big Local News · About: Big Local

7,620 rows where grade = "grade_1" and state = "CO" sorted by school_state_id

View and edit SQL

year

grade

  • grade_1 · 7,620
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
1932681 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_1 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
712684 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_1 74 1 8   1 1     0   4   40 49                       89 74 1 8   1 1     0   4   40 49                 89
840316 CO     school   900   DOUGLAS COUNTY RE 1   11 ACADEMY CHARTER SCHOOL             2016   grade_1 65 3 7   0 1     0   2   33 45                       78 65 3 7   0 1     0   2   33 45                 78
1137950 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_1 73.0 0.0 7.0   0.0 2.0     0.0   3.0   36.0 49.0                       85.0 73 0 7   0 2     0   3   36 49                 85
1743218 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_1 71 1 5   1 1     0   6   47 38                       85 71 1 5   1 1     0   6   47 38                 85
1804246 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_1 63 3 4   0 1     0   1   43 29                       72 63 3 4   0 1     0   1   43 29                 72
1898596 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_1 68 2 9   0 2     0   6   41 46                       87 68 2 9   0 2     0   6   41 46                 87
1935933 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_1 66 1 9   0 2     0   5   33 50                       83 66 1 9   0 2     0   5   33 50                 83
712695 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 32 1 9   1 16     0   6   43 22                       65 32 1 9   1 16     0   6   43 22                 65
840327 CO     school   900   DOUGLAS COUNTY RE 1   12 ACRES GREEN ELEMENTARY SCHOOL             2016   grade_1 42 0 13   0 24     0   8   36 51                       87 42 0 13   0 24     0   8   36 51                 87
1137961 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 50.0 2.0 17.0   0.0 17.0     0.0   8.0   52.0 42.0                       94.0 50 2 17   0 17     0   8   52 42                 94
1743228 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_1 25 0 14   0 10     1   5   25 30                       55 25 0 14   0 10     1   5   25 30                 55
1804257 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2020   grade_1 37 0 11   1 15     0   4   38 30                       68 37 0 11   1 15     0   4   38 30                 68
1898607 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_1 30 2 10   1 24     1   5   37 36                       73 30 2 10   1 24     1   5   37 36                 73
1935944 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_1 30 0 16   1 11     0   4   34 28                       62 30 0 16   1 11     0   4   34 28                 62
707966 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 39 1 26   0 2     0   2   40 30                       70 39 1 26   0 2     0   2   40 30                 70
835631 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   14 GLACIER PEAK ELEMENTARY SCHOOL             2016   grade_1 38 0 29   1 4     1   5   49 29                       78 38 0 29   1 4     1   5   49 29                 78
1133354 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 42.0 1.0 34.0   1.0 4.0     0.0   3.0   36.0 49.0                       85.0 42 1 34   1 4     0   3   36 49                 85
1738402 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   grade_1 28 1 21   0 8     0   6   36 28                       64 28 1 21   0 8     0   6   36 28                 64
1799461 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   grade_1 41 0 23   0 4     0   2   34 36                       70 41 0 23   0 4     0   2   34 36                 70
1893834 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_1 35 1 34   0 2     0   3   39 36                       75 35 1 34   0 2     0   3   39 36                 75
1931106 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 36 0 37   1 4     0   1   40 39                       79 36 0 37   1 4     0   1   40 39                 79
720620 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_1 89 1 23   0 6     1   11   64 67                       131 89 1 23   0 6     1   11   64 67                 131
848188 CO     school   8001   CHARTER SCHOOL INSTITUTE   15 ACADEMY OF CHARTER SCHOOLS             2016   grade_1 93 1 27   0 7     0   12   81 59                       140 93 1 27   0 7     0   12   81 59                 140
1145756 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes 4.0 PK 12 2015   grade_1 98.0 2.0 30.0   0.0 6.0     0.0   5.0   70.0 71.0                       141.0 98 2 30   0 6     0   5   70 71                 141
1751080 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_1 83 1 36   0 12     0   13   74 71                       145 83 1 36   0 12     0   13   74 71                 145
1812195 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_1 85 1 29   0 13     0   8   63 73                       136 85 1 29   0 13     0   8   63 73                 136
1906568 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2018   grade_1 92 1 36   0 8     0   4   77 64                       141 92 1 36   0 8     0   4   77 64                 141
1943940 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_1 86 0 33   0 8     0   10   71 66                       137 86 0 33   0 8     0   10   71 66                 137
708890 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 58 3 10   1 14     0   8   45 49                       94 58 3 10   1 14     0   8   45 49                 94
836536 CO     school   130   CHERRY CREEK 5   16 FOX HOLLOW ELEMENTARY SCHOOL             2016   grade_1 73 5 12   0 10     0   6   49 57                       106 73 5 12   0 10     0   6   49 57                 106
1134261 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 62.0 4.0 7.0   0.0 12.0     0.0   7.0   48.0 44.0                       92.0 62 4 7   0 12     0   7   48 44                 92
1739348 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   grade_1 43 9 20   0 12     0   6   47 43                       90 43 9 20   0 12     0   6   47 43                 90
1800398 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2020   grade_1 57 8 9   0 13     0   5   50 42                       92 57 8 9   0 13     0   5   50 42                 92
1894778 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 63 3 13   0 19     0   4   52 50                       102 63 3 13   0 19     0   4   52 50                 102
1932074 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 57 9 10   0 14     0   9   48 51                       99 57 9 10   0 14     0   9   48 51                 99
714472 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 65 3 15   0 0     0   2   36 49                       85 65 3 15   0 0     0   2   36 49                 85
842087 CO     school   1040   ACADEMY 20   17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL             2016   grade_1 51 3 14   0 4     0   6   39 39                       78 51 3 14   0 4     0   6   39 39                 78
1139701 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 66.0 3.0 7.0   1.0 3.0     2.0   5.0   42.0 45.0                       87.0 66 3 7   1 3     2   5   42 45                 87
1744978 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   grade_1 40 0 12   1 2     0   4   32 27                       59 40 0 12   1 2     0   4   32 27                 59
1806067 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_1 41 1 8   0 0     0   5   31 24                       55 41 1 8   0 0     0   5   31 24                 55
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
1937764 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 48 1 7   0 4     0   5   33 32                       65 48 1 7   0 4     0   5   33 32                 65
714480 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 61 6 9   0 10     0   5   47 44                       91 61 6 9   0 10     0   5   47 44                 91
842095 CO     school   1040   ACADEMY 20   19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL             2016   grade_1 75 1 7   0 10     0   7   50 50                       100 75 1 7   0 10     0   7   50 50                 100
1139709 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 64.0 6.0 12.0   0.0 12.0     1.0   7.0   45.0 57.0                       102.0 64 6 12   0 12     1   7   45 57                 102
1744985 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   grade_1 40 2 6   0 9     0   8   31 34                       65 40 2 6   0 9     0   8   31 34                 65
1806074 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_1 45 3 7   1 11     1   9   36 41                       77 45 3 7   1 11     1   9   36 41                 77
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
1937772 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 49 2 16   1 11     1   9   46 43                       89 49 2 16   1 11     1   9   46 43                 89
719311 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 36 0 31   0 2     0   3   46 26                       72 36 0 31   0 2     0   3   46 26                 72
846880 CO     school   2700   PUEBLO COUNTY 70   26 DESERT SAGE ELEMENTARY SCHOOL             2016   grade_1 28 1 31   0 0     0   1   29 32                       61 28 1 31   0 0     0   1   29 32                 61
1144452 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 39.0 0.0 32.0   0.0 0.0     0.0   0.0   38.0 33.0                       71.0 39 0 32   0 0     0   0   38 33                 71
1749740 CO     school 806150 2700   Pueblo County 70 80615001718 26 Desert Sage Elementary School   Regular School No Elementary PK 05 2021   grade_1 32 0 21   0 0     0   2   27 28                       55 32 0 21   0 0     0   2   27 28                 55
1810869 CO     school 806150 2700   Pueblo County 70 80615001718 26 Desert Sage Elementary School   Regular School No Elementary PK 05 2020   grade_1 18 0 30   0 0     0   4   30 22                       52 18 0 30   0 0     0   4   30 22                 52
1905268 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 30 0 19   0 0     0   1   24 26                       50 30 0 19   0 0     0   1   24 26                 50
1942625 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 31 0 21   0 1     0   2   25 30                       55 31 0 21   0 1     0   2   25 30                 55
715519 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 38 0 15   0 2     0   0   29 26                       55 38 0 15   0 2     0   0   29 26                 55
843124 CO     school   1420   JEFFERSON COUNTY R-1   30 ADAMS ELEMENTARY SCHOOL             2016   grade_1 28 1 11   0 2     0   4   26 20                       46 28 1 11   0 2     0   4   26 20                 46
1140730 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 46.0 2.0 15.0   0.0 2.0     0.0   3.0   38.0 30.0                       68.0 46 2 15   0 2     0   3   38 30                 68
1746115 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1 26 3 13   0 1     0   3   24 22                       46 26 3 13   0 1     0   3   24 22                 46
1807200 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_1 33 1 16   0 3     0   2   27 28                       55 33 1 16   0 3     0   2   27 28                 55
1901437 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_1 41 0 19   0 2     0   2   34 30                       64 41 0 19   0 2     0   2   34 30                 64
1938856 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 30 1 15   1 3     0   4   31 23                       54 30 1 15   1 3     0   4   31 23                 54
720635 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_1 11 1 1   0 0     0   0   6 7                       13 11 1 1   0 0     0   0   6 7                 13
848203 CO     school   8001   CHARTER SCHOOL INSTITUTE   35 FRONTIER CHARTER ACADEMY             2016   grade_1 11 0 0   0 0     0   0   5 6                       11 11 0 0   0 0     0   0   5 6                 11
1145771 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_1 11.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 3.0                       11.0 11 0 0   0 0     0   0   8 3                 11
1906584 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2018   grade_1 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
1943956 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2019   grade_1 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
713410 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 20 0 48   0 0     0   4   45 27                       72 20 0 48   0 0     0   4   45 27                 72
841027 CO     school   910   EAGLE COUNTY RE 50   37 RED HILL ELEMENTARY SCHOOL             2016   grade_1 18 0 31   1 0     0   1   22 29                       51 18 0 31   1 0     0   1   22 29                 51
1138643 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 29.0 0.0 41.0   1.0 0.0     0.0   1.0   30.0 42.0                       72.0 29 0 41   1 0     0   1   30 42                 72
1743899 CO     school 803540 910   Eagle County RE 50 80354001721 37 Red Hill Elementary School   Regular School No Elementary PK 05 2021   grade_1 28 0 23   0 0     0   2   26 27                       53 28 0 23   0 0     0   2   26 27                 53
1804973 CO     school 803540 910   Eagle County RE 50 80354001721 37 Red Hill Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 0 28   0 0     0   1   23 18                       41 12 0 28   0 0     0   1   23 18                 41
1899320 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 16 0 34   0 0     0   4   31 23                       54 16 0 34   0 0     0   4   31 23                 54
1936688 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 29 1 32   0 0     0   1   34 29                       63 29 1 32   0 0     0   1   34 29                 63
713418 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 47 0 11   0 1     0   1   34 26                       60 47 0 11   0 1     0   1   34 26                 60
841036 CO     school   910   EAGLE COUNTY RE 50   38 BRUSH CREEK ELEMENTARY SCHOOL             2016   grade_1 45 0 6   1 0     0   0   25 27                       52 45 0 6   1 0     0   0   25 27                 52
1138651 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 50.0 0.0 10.0   0.0 1.0     0.0   1.0   34.0 28.0                       62.0 50 0 10   0 1     0   1   34 28                 62
1743907 CO     school 803540 910   Eagle County RE 50 80354001722 38 Brush Creek Elementary School   Regular School No Elementary PK 05 2021   grade_1 56 0 5   0 0     0   1   25 37                       62 56 0 5   0 0     0   1   25 37                 62
1804981 CO     school 803540 910   Eagle County RE 50 80354001722 38 Brush Creek Elementary School   Regular School No Elementary PK 05 2020   grade_1 48 0 11   0 0     0   2   31 30                       61 48 0 11   0 0     0   2   31 30                 61
1899328 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 47 0 8   0 0     0   5   37 23                       60 47 0 8   0 0     0   5   37 23                 60
1936697 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 55 0 14   0 0     0   1   43 27                       70 55 0 14   0 0     0   1   43 27                 70
718969 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_1 13 0 0   0 1     0   0   7 7                       14 13 0 0   0 1     0   0   7 7                 14
846532 CO     school   2640   ASPEN 1   42 ASPEN COMMUNITY CHARTER SCHOOL             2016   grade_1 13 0 1   0 0     0   1   8 7                       15 13 0 1   0 0     0   1   8 7                 15
1144101 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_1 13.0 0.0 2.0   0.0 0.0     0.0   0.0   8.0 7.0                       15.0 13 0 2   0 0     0   0   8 7                 15
1749397 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2021   grade_1 15 0 0   0 1     0   0   8 8                       16 15 0 0   0 1     0   0   8 8                 16
1810529 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_1 12 0 1   0 2     0   0   8 7                       15 12 0 1   0 2     0   0   8 7                 15
1904918 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_1 14 0 1   0 0     1   0   8 8                       16 14 0 1   0 0     1   0   8 8                 16
1942273 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_1 12 0 1   0 1     0   0   6 8                       14 12 0 1   0 1     0   0   6 8                 14
1138872 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0                       1.0 1 0 0   0 0     0   0   0 1                 1
1744117 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2021   grade_1 2 0 1   0 0     0   0   1 2                       3 2 0 1   0 0     0   0   1 2                 3
1805201 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_1 6 0 1   0 0     0   0   4 3                       7 6 0 1   0 0     0   0   4 3                 7
1936918 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 2 0 1   0 0     0   1   4 0                       4 2 0 1   0 0     0   1   4 0                 4
712663 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
840292 CO     school   890   DOLORES COUNTY RE NO.2   50 RICO ELEMENTARY SCHOOL             2016   grade_1 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
1137926 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_1 3.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 3.0                       3.0 3 0 0   0 0     0   0   0 3                 3
1898576 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_1 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
720206 CO     school 804410 3120   GREELEY 6 80441001988 52 HEIMAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 40 3 51   0 2     2   3   46 55                       101 40 3 51   0 2     2   3   46 55                 101
847774 CO     school   3120   GREELEY 6   52 HEIMAN ELEMENTARY SCHOOL             2016   grade_1 51 0 61   0 3     0   3   61 57                       118 51 0 61   0 3     0   3   61 57                 118

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