Data source: Big Local News · About: Big Local

7,616 rows where grade = "grade_4" and state = "CO" sorted by school_state_id

View and edit SQL

year

grade

  • grade_4 · 7,616
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
709489 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_4 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
837133 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_4 1 0 1   0 0     0   1   2 1                       3 1 0 1   0 0     0   1   2 1                 3
1134849 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2015   grade_4 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0                       1.0 0 0 1   0 0     0   0   1 0                 1
1739972 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_4 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1895379 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_4 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1932686 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_4 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
712687 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_4 72 2 13   1 1     0   3   54 38                       92 72 2 13   1 1     0   3   54 38                 92
840319 CO     school   900   DOUGLAS COUNTY RE 1   11 ACADEMY CHARTER SCHOOL             2016   grade_4 74 0 7   0 1     0   2   36 48                       84 74 0 7   0 1     0   2   36 48                 84
1137953 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_4 73.0 0.0 8.0   0.0 2.0     0.0   1.0   42.0 42.0                       84.0 73 0 8   0 2     0   1   42 42                 84
1743221 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_4 64 0 8   1 2     0   5   37 43                       80 64 0 8   1 2     0   5   37 43                 80
1804249 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_4 69 1 9   0 2     0   4   36 49                       85 69 1 9   0 2     0   4   36 49                 85
1898599 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_4 78 0 10   1 2     0   3   46 48                       94 78 0 10   1 2     0   3   46 48                 94
1935936 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_4 67 2 9   1 1     0   3   39 44                       83 67 2 9   1 1     0   3   39 44                 83
712698 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_4 50 2 10   0 22     0   8   50 42                       92 50 2 10   0 22     0   8   50 42                 92
840330 CO     school   900   DOUGLAS COUNTY RE 1   12 ACRES GREEN ELEMENTARY SCHOOL             2016   grade_4 54 6 18   0 13     0   7   48 50                       98 54 6 18   0 13     0   7   48 50                 98
1137964 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 65.0 0.0 10.0   0.0 13.0     0.0   8.0   44.0 52.0                       96.0 65 0 10   0 13     0   8   44 52                 96
1743231 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_4 28 0 15   1 4     1   6   26 29                       55 28 0 15   1 4     1   6   26 29                 55
1804260 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2020   grade_4 26 0 10   0 10     0   6   27 25                       52 26 0 10   0 10     0   6   27 25                 52
1898610 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_4 43 0 15   1 21     0   10   45 45                       90 43 0 15   1 21     0   10   45 45                 90
1935947 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 33 0 17   0 12     0   8   36 34                       70 33 0 17   0 12     0   8   36 34                 70
707969 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 58 3 28   0 2     0   5   61 35                       96 58 3 28   0 2     0   5   61 35                 96
835634 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   14 GLACIER PEAK ELEMENTARY SCHOOL             2016   grade_4 51 0 37   0 0     0   0   44 44                       88 51 0 37   0 0     0   0   44 44                 88
1133357 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 51.0 2.0 30.0   0.0 5.0     1.0   4.0   47.0 46.0                       93.0 51 2 30   0 5     1   4   47 46                 93
1738405 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   grade_4 32 2 33   0 3     0   2   37 35                       72 32 2 33   0 3     0   2   37 35                 72
1799464 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   grade_4 36 1 22   0 3     0   4   39 27                       66 36 1 22   0 3     0   4   39 27                 66
1893837 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_4 41 2 31   1 3     0   4   40 42                       82 41 2 31   1 3     0   4   40 42                 82
1931109 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 34 1 33   1 8     0   4   47 34                       81 34 1 33   1 8     0   4   47 34                 81
720626 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_4 103 0 31   0 10     0   4   72 76                       148 103 0 31   0 10     0   4   72 76                 148
848194 CO     school   8001   CHARTER SCHOOL INSTITUTE   15 ACADEMY OF CHARTER SCHOOLS             2016   grade_4 93 2 35   1 9     0   6   68 78                       146 93 2 35   1 9     0   6   68 78                 146
1145762 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes 4.0 PK 12 2015   grade_4 95.0 3.0 31.0   1.0 10.0     1.0   4.0   71.0 74.0                       145.0 95 3 31   1 10     1   4   71 74                 145
1751086 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_4 88 2 42   0 9     0   3   85 59                       144 88 2 42   0 9     0   3   85 59                 144
1812201 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_4 88 0 36   0 8     1   12   68 77                       145 88 0 36   0 8     1   12   68 77                 145
1906574 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2018   grade_4 98 1 33   0 8     0   7   74 73                       147 98 1 33   0 8     0   7   74 73                 147
1943946 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_4 84 1 37   0 10     0   13   85 60                       145 84 1 37   0 10     0   13   85 60                 145
708893 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 75 6 15   1 18     0   7   67 55                       122 75 6 15   1 18     0   7   67 55                 122
836539 CO     school   130   CHERRY CREEK 5   16 FOX HOLLOW ELEMENTARY SCHOOL             2016   grade_4 77 2 15   0 15     0   4   48 65                       113 77 2 15   0 15     0   4   48 65                 113
1134264 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 76.0 6.0 12.0   2.0 23.0     0.0   7.0   62.0 64.0                       126.0 76 6 12   2 23     0   7   62 64                 126
1739351 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   grade_4 50 1 16   0 12     0   6   38 47                       85 50 1 16   0 12     0   6   38 47                 85
1800401 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2020   grade_4 54 6 15   1 15     0   10   47 54                       101 54 6 15   1 15     0   10   47 54                 101
1894781 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 61 3 9   0 15     0   6   52 42                       94 61 3 9   0 15     0   6   52 42                 94
1932077 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 73 9 16   2 13     0   2   56 59                       115 73 9 16   2 13     0   2   56 59                 115
714475 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 78 2 19   1 0     0   6   51 55                       106 78 2 19   1 0     0   6   51 55                 106
842090 CO     school   1040   ACADEMY 20   17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL             2016   grade_4 82 4 5   0 4     0   5   53 47                       100 82 4 5   0 4     0   5   53 47                 100
1139704 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 74.0 3.0 23.0   1.0 7.0     1.0   5.0   56.0 58.0                       114.0 74 3 23   1 7     1   5   56 58                 114
1744981 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   grade_4 48 2 9   0 3     0   8   32 38                       70 48 2 9   0 3     0   8   32 38                 70
1806070 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_4 60 2 7   0 0     0   3   33 39                       72 60 2 7   0 0     0   3   33 39                 72
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
1937767 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 46 1 7   0 3     0   12   34 35                       69 46 1 7   0 3     0   12   34 35                 69
714483 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 59 5 15   0 14     1   8   48 54                       102 59 5 15   0 14     1   8   48 54                 102
842098 CO     school   1040   ACADEMY 20   19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL             2016   grade_4 57 7 14   0 11     0   5   34 60                       94 57 7 14   0 11     0   5   34 60                 94
1139712 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 63.0 4.0 7.0   0.0 11.0     1.0   4.0   41.0 49.0                       90.0 63 4 7   0 11     1   4   41 49                 90
1744988 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   grade_4 51 3 7   0 11     0   9   36 45                       81 51 3 7   0 11     0   9   36 45                 81
1806077 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_4 51 2 10   0 13     0   7   37 46                       83 51 2 10   0 13     0   7   37 46                 83
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
1937775 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 56 3 7   0 15     1   10   43 49                       92 56 3 7   0 15     1   10   43 49                 92
719314 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 31 1 36   0 0     0   2   34 36                       70 31 1 36   0 0     0   2   34 36                 70
846883 CO     school   2700   PUEBLO COUNTY 70   26 DESERT SAGE ELEMENTARY SCHOOL             2016   grade_4 28 0 23   0 2     0   2   38 17                       55 28 0 23   0 2     0   2   38 17                 55
1144455 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 27.0 0.0 23.0   0.0 1.0     0.0   3.0   29.0 25.0                       54.0 27 0 23   0 1     0   3   29 25                 54
1749743 CO     school 806150 2700   Pueblo County 70 80615001718 26 Desert Sage Elementary School   Regular School No Elementary PK 05 2021   grade_4 31 0 19   0 0     0   1   25 26                       51 31 0 19   0 0     0   1   25 26                 51
1810872 CO     school 806150 2700   Pueblo County 70 80615001718 26 Desert Sage Elementary School   Regular School No Elementary PK 05 2020   grade_4 40 0 30   0 3     0   4   42 35                       77 40 0 30   0 3     0   4   42 35                 77
1905271 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 42 1 33   1 0     0   1   41 37                       78 42 1 33   1 0     0   1   41 37                 78
1942628 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 38 1 33   0 0     0   3   37 38                       75 38 1 33   0 0     0   3   37 38                 75
715522 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_4 41 0 10   0 6     0   4   28 33                       61 41 0 10   0 6     0   4   28 33                 61
843127 CO     school   1420   JEFFERSON COUNTY R-1   30 ADAMS ELEMENTARY SCHOOL             2016   grade_4 40 1 13   0 2     0   3   33 26                       59 40 1 13   0 2     0   3   33 26                 59
1140733 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 55.0 0.0 10.0   0.0 3.0     0.0   2.0   35.0 35.0                       70.0 55 0 10   0 3     0   2   35 35                 70
1746118 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_4 34 2 16   0 2     0   2   30 26                       56 34 2 16   0 2     0   2   30 26                 56
1807203 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_4 33 1 20   0 4     0   2   31 29                       60 33 1 20   0 4     0   2   31 29                 60
1901440 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_4 37 1 11   0 4     0   1   29 25                       54 37 1 11   0 4     0   1   29 25                 54
1938859 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 27 1 10   0 3     0   4   24 21                       45 27 1 10   0 3     0   4   24 21                 45
720638 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_4 8 0 1   0 0     0   0   3 6                       9 8 0 1   0 0     0   0   3 6                 9
848206 CO     school   8001   CHARTER SCHOOL INSTITUTE   35 FRONTIER CHARTER ACADEMY             2016   grade_4 3 0 2   0 0     0   0   2 3                       5 3 0 2   0 0     0   0   2 3                 5
1145774 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_4 4.0 0.0 0.0   0.0 0.0     0.0   0.0   4.0 0.0                       4.0 4 0 0   0 0     0   0   4 0                 4
1906587 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2018   grade_4 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
1943959 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2019   grade_4 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
713413 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 27 0 38   1 0     0   2   37 31                       68 27 0 38   1 0     0   2   37 31                 68
841030 CO     school   910   EAGLE COUNTY RE 50   37 RED HILL ELEMENTARY SCHOOL             2016   grade_4 19 0 32   0 0     0   1   30 22                       52 19 0 32   0 0     0   1   30 22                 52
1138646 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 25.0 0.0 29.0   0.0 0.0     0.0   1.0   29.0 26.0                       55.0 25 0 29   0 0     0   1   29 26                 55
1743902 CO     school 803540 910   Eagle County RE 50 80354001721 37 Red Hill Elementary School   Regular School No Elementary PK 05 2021   grade_4 15 0 36   0 0     0   2   29 24                       53 15 0 36   0 0     0   2   29 24                 53
1804976 CO     school 803540 910   Eagle County RE 50 80354001721 37 Red Hill Elementary School   Regular School No Elementary PK 05 2020   grade_4 20 0 51   1 0     0   1   44 29                       73 20 0 51   1 0     0   1   44 29                 73
1899323 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 23 0 40   1 0     0   0   28 36                       64 23 0 40   1 0     0   0   28 36                 64
1936691 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 14 1 31   1 0     0   1   23 25                       48 14 1 31   1 0     0   1   23 25                 48
713421 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 64 1 13   1 0     0   2   42 39                       81 64 1 13   1 0     0   2   42 39                 81
841039 CO     school   910   EAGLE COUNTY RE 50   38 BRUSH CREEK ELEMENTARY SCHOOL             2016   grade_4 67 0 10   0 0     0   1   39 39                       78 67 0 10   0 0     0   1   39 39                 78
1138654 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_4 51.0 0.0 8.0   0.0 0.0     0.0   1.0   30.0 30.0                       60.0 51 0 8   0 0     0   1   30 30                 60
1743910 CO     school 803540 910   Eagle County RE 50 80354001722 38 Brush Creek Elementary School   Regular School No Elementary PK 05 2021   grade_4 43 0 8   0 0     0   6   34 23                       57 43 0 8   0 0     0   6   34 23                 57
1804984 CO     school 803540 910   Eagle County RE 50 80354001722 38 Brush Creek Elementary School   Regular School No Elementary PK 05 2020   grade_4 52 0 8   0 1     0   2   37 26                       63 52 0 8   0 1     0   2   37 26                 63
1899331 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 52 0 10   0 1     0   1   36 28                       64 52 0 10   0 1     0   1   36 28                 64
1936700 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 51 0 7   1 0     0   0   26 33                       59 51 0 7   1 0     0   0   26 33                 59
718972 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_4 15 0 0   1 0     0   0   7 9                       16 15 0 0   1 0     0   0   7 9                 16
846535 CO     school   2640   ASPEN 1   42 ASPEN COMMUNITY CHARTER SCHOOL             2016   grade_4 15 0 0   0 0     0   0   8 7                       15 15 0 0   0 0     0   0   8 7                 15
1144104 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2015   grade_4 17.0 0.0 1.0   0.0 0.0     0.0   0.0   8.0 10.0                       18.0 17 0 1   0 0     0   0   8 10                 18
1749400 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2021   grade_4 13 0 1   0 0     1   0   7 8                       15 13 0 1   0 0     1   0   7 8                 15
1810532 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_4 14 0 0   0 1     0   0   8 7                       15 14 0 0   0 1     0   0   8 7                 15
1904921 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_4 13 0 2   0 0     0   0   8 7                       15 13 0 2   0 0     0   0   8 7                 15
1942276 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_4 14 0 1   0 0     0   1   8 8                       16 14 0 1   0 0     0   1   8 8                 16
713640 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1138875 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 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
1744120 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2021   grade_4 6 0 1   0 0     0   0   4 3                       7 6 0 1   0 0     0   0   4 3                 7
1805204 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_4 6 0 1   0 0     0   0   5 2                       7 6 0 1   0 0     0   0   5 2                 7
1899554 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_4 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1

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