Data source: Big Local News · About: Big Local

7,616 rows where grade = "grade_4" and state = "CO" sorted by district_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
707844 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_4 5 1 34   0 0     0   1   13 28                       41 5 1 34   0 0     0   1   13 28                 41
707855 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_4 8 0 44   0 2     0   0   32 22                       54 8 0 44   0 2     0   0   32 22                 54
707869 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_4 8 1 43   0 2     0   2   27 29                       56 8 1 43   0 2     0   2   27 29                 56
707880 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_4 3 1 17   0 0     0   1   8 14                       22 3 1 17   0 0     0   1   8 14                 22
707889 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_4 8 1 39   0 2     0   3   23 30                       53 8 1 39   0 2     0   3   23 30                 53
707900 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_4 12 1 32   2 0     0   3   32 18                       50 12 1 32   2 0     0   3   32 18                 50
707909 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_4 4 1 37   1 0     0   3   25 21                       46 4 1 37   1 0     0   3   25 21                 46
707918 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_4 9 0 37   0 1     0   1   28 20                       48 9 0 37   0 1     0   1   28 20                 48
707934 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_4 65 4 25   0 2     2   9   55 52                       107 65 4 25   0 2     2   9   55 52                 107
707942 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_4 3 1 42   0 1     0   0   22 25                       47 3 1 42   0 1     0   0   22 25                 47
707959 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_4 5 0 37   0 0     0   2   21 23                       44 5 0 37   0 0     0   2   21 23                 44
835507 CO     school   10   MAPLETON 1   263 GLOBAL LEADERSHIP ACADEMY             2016   grade_4 1 2 26   0 0     0   0   16 13                       29 1 2 26   0 0     0   0   16 13                 29
835524 CO     school   10   MAPLETON 1   501 MONTEREY COMMUNITY SCHOOL             2016   grade_4 4 1 44   0 1     0   0   25 25                       50 4 1 44   0 1     0   0   25 25                 50
835535 CO     school   10   MAPLETON 1   502 MEADOW COMMUNITY SCHOOL             2016   grade_4 8 2 32   1 2     0   0   27 18                       45 8 2 32   1 2     0   0   27 18                 45
835549 CO     school   10   MAPLETON 1   503 YORK INTERNATIONAL             2016   grade_4 11 0 39   0 4     0   0   31 23                       54 11 0 39   0 4     0   0   31 23                 54
835560 CO     school   10   MAPLETON 1   504 WELBY COMMUNITY SCHOOL             2016   grade_4 4 1 18   0 0     0   0   11 12                       23 4 1 18   0 0     0   0   11 12                 23
835569 CO     school   10   MAPLETON 1   505 ACHIEVE ACADEMY             2016   grade_4 10 1 38   0 3     0   1   28 25                       53 10 1 38   0 3     0   1   28 25                 53
835580 CO     school   10   MAPLETON 1   506 EXPLORE ELEMENTARY             2016   grade_4 19 1 23   1 1     1   0   24 22                       46 19 1 23   1 1     1   0   24 22                 46
835589 CO     school   10   MAPLETON 1   507 ADVENTURE ELEMENTARY             2016   grade_4 3 0 39   0 0     0   0   21 21                       42 3 0 39   0 0     0   0   21 21                 42
835598 CO     school   10   MAPLETON 1   509 CLAYTON PARTNERSHIP SCHOOL             2016   grade_4 8 1 37   0 3     0   1   22 28                       50 8 1 37   0 3     0   1   22 28                 50
835611 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2016   grade_4 73 5 17   0 0     0   6   44 57                       101 73 5 17   0 0     0   6   44 57                 101
835624 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No 1.0 KG 08 2016   grade_4 4 0 44   1 0     0   1   28 22                       50 4 0 44   1 0     0   1   28 22                 50
1133230 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No 4.0 PK 12 2015   grade_4 1.0 1.0 27.0   0.0 0.0     0.0   0.0   13.0 16.0                       29.0 1 1 27   0 0     0   0   13 16                 29
1133247 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No 1.0 PK 08 2015   grade_4 3.0 0.0 40.0   0.0 1.0     0.0   0.0   23.0 21.0                       44.0 3 0 40   0 1     0   0   23 21                 44
1133258 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No 1.0 PK 08 2015   grade_4 8.0 1.0 31.0   0.0 0.0     0.0   2.0   18.0 24.0                       42.0 8 1 31   0 0     0   2   18 24                 42
1133272 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No 4.0 KG 12 2015   grade_4 8.0 1.0 38.0   1.0 4.0     0.0   2.0   25.0 29.0                       54.0 8 1 38   1 4     0   2   25 29                 54
1133283 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY MONTESSORI SCHOOL   Regular School No 1.0 PK 06 2015   grade_4 3.0 1.0 19.0   1.0 0.0     0.0   0.0   12.0 12.0                       24.0 3 1 19   1 0     0   0   12 12                 24
1133292 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No 1.0 PK 08 2015   grade_4 9.0 0.0 43.0   0.0 3.0     0.0   1.0   32.0 24.0                       56.0 9 0 43   0 3     0   1   32 24                 56
1133303 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_4 10.0 2.0 36.0   1.0 0.0     0.0   0.0   27.0 22.0                       49.0 10 2 36   1 0     0   0   27 22                 49
1133312 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_4 9.0 0.0 46.0   1.0 2.0     0.0   0.0   36.0 22.0                       58.0 9 0 46   1 2     0   0   36 22                 58
1133321 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No 1.0 KG 08 2015   grade_4 15.0 4.0 35.0   0.0 2.0     0.0   1.0   27.0 30.0                       57.0 15 4 35   0 2     0   1   27 30                 57
1133334 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No 4.0 KG 12 2015   grade_4 81.0 3.0 14.0   0.0 7.0     1.0   5.0   55.0 56.0                       111.0 81 3 14   0 7     1   5   55 56                 111
1133347 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No 1.0 KG 08 2015   grade_4 5.0 0.0 43.0   0.0 0.0     1.0   1.0   27.0 23.0                       50.0 5 0 43   0 0     1   1   27 23                 50
1738287 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2021   grade_4 8 1 33   0 2     0   1   21 24                       45 8 1 33   0 2     0   1   21 24                 45
1738300 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2021   grade_4 3 0 61   0 4     0   2   37 33                       70 3 0 61   0 4     0   2   37 33                 70
1738311 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2021   grade_4 13 0 37   0 0     0   0   23 27                       50 13 0 37   0 0     0   0   23 27                 50
1738320 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_4 4 0 31   0 1     0   1   20 17                       37 4 0 31   0 1     0   1   20 17                 37
1738330 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   grade_4 13 1 41   1 2     0   3   29 32                       61 13 1 41   1 2     0   3   29 32                 61
1738340 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   grade_4 8 0 40   0 0     0   2   23 27                       50 8 0 40   0 0     0   2   23 27                 50
1738349 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2021   grade_4 8 0 52   1 0     0   0   27 34                       61 8 0 52   1 0     0   0   27 34                 61
1738367 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_4 73 3 25   0 3     1   15   63 57                       120 73 3 25   0 3     1   15   63 57                 120
1738377 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_4 2 0 44   0 0     0   1   21 26                       47 2 0 44   0 0     0   1   21 26                 47
1738394 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_4 5 1 33   0 3     0   2   20 24                       44 5 1 33   0 3     0   2   20 24                 44
1799333 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_4 2 0 33   0 2     0   0   13 24                       37 2 0 33   0 2     0   0   13 24                 37
1799343 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_4 4 0 37   0 0     0   3   18 26                       44 4 0 37   0 0     0   3   18 26                 44
1799357 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_4 4 1 43   0 2     0   2   29 23                       52 4 1 43   0 2     0   2   29 23                 52
1799368 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_4 7 0 29   0 0     0   0   17 19                       36 7 0 29   0 0     0   0   17 19                 36
1799377 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_4 3 0 44   0 2     0   1   24 26                       50 3 0 44   0 2     0   1   24 26                 50
1799388 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   grade_4 19 0 28   0 0     0   2   28 21                       49 19 0 28   0 0     0   2   28 21                 49
1799397 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_4 7 0 34   2 0     0   1   28 16                       44 7 0 34   2 0     0   1   28 16                 44
1799406 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_4 5 1 47   0 2     0   1   31 25                       56 5 1 47   0 2     0   1   31 25                 56
1799424 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_4 45 4 23   2 1     0   7   36 46                       82 45 4 23   2 1     0   7   36 46                 82
1799432 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2020   grade_4 4 0 49   1 0     0   0   25 29                       54 4 0 49   1 0     0   0   25 29                 54
1799449 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_4 8 0 32   0 0     0   0   23 17                       40 8 0 32   0 0     0   0   23 17                 40
1893707 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2018   grade_4 6 1 41   0 1     0   1   22 28                       50 6 1 41   0 1     0   1   22 28                 50
1893718 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2018   grade_4 6 2 42   0 2     0   3   22 33                       55 6 2 42   0 2     0   3   22 33                 55
1893732 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2018   grade_4 5 1 53   0 2     0   0   33 28                       61 5 1 53   0 2     0   0   33 28                 61
1893743 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2018   grade_4 4 1 21   1 0     0   0   11 16                       27 4 1 21   1 0     0   0   11 16                 27
1893752 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2018   grade_4 3 2 46   0 2     0   0   25 28                       53 3 2 46   0 2     0   0   25 28                 53
1893763 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2018   grade_4 19 1 34   1 2     1   2   34 26                       60 19 1 34   1 2     1   2   34 26                 60
1893772 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2018   grade_4 3 0 41   0 1     0   0   24 21                       45 3 0 41   0 1     0   0   24 21                 45
1893781 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2018   grade_4 10 3 43   0 1     1   1   33 26                       59 10 3 43   0 1     1   1   33 26                 59
1893798 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2018   grade_4 69 4 17   0 1     0   7   57 41                       98 69 4 17   0 1     0   7   57 41                 98
1893806 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Middle 04 08 2018   grade_4 2 4 51   0 0     0   0   29 28                       57 2 4 51   0 0     0   0   29 28                 57
1893823 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2018   grade_4 7 0 39   0 0     0   1   27 20                       47 7 0 39   0 0     0   1   27 20                 47
1930980 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_4 6 2 44   0 0     0   0   26 26                       52 6 2 44   0 0     0   0   26 26                 52
1930990 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_4 9 1 36   0 1     0   1   28 20                       48 9 1 36   0 1     0   1   28 20                 48
1931004 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_4 5 1 50   0 1     0   2   29 30                       59 5 1 50   0 1     0   2   29 30                 59
1931015 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 2 0 20   0 0     0   1   10 13                       23 2 0 20   0 0     0   1   10 13                 23
1931024 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_4 7 0 43   1 1     0   1   28 25                       53 7 0 43   1 1     0   1   28 25                 53
1931035 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_4 11 2 37   0 0     1   0   25 26                       51 11 2 37   0 0     1   0   25 26                 51
1931044 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_4 5 1 39   0 0     0   1   20 26                       46 5 1 39   0 0     0   1   20 26                 46
1931053 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_4 3 3 41   0 4     0   3   27 27                       54 3 3 41   0 4     0   3   27 27                 54
1931071 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2019   grade_4 57 3 13   0 2     0   9   51 33                       84 57 3 13   0 2     0   9   51 33                 84
1931079 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Middle 04 08 2019   grade_4 1 0 50   1 0     0   0   34 18                       52 1 0 50   1 0     0   0   34 18                 52
1931096 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2019   grade_4 10 0 39   0 0     0   0   21 28                       49 10 0 39   0 0     0   0   21 28                 49
708783 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 65 1 119   2 2     0   2   92 99                       191 65 1 119   2 2     0   2   92 99                 191
836430 CO     school   100   ALAMOSA RE-11J   115 ALAMOSA ELEMENTARY SCHOOL             2016   grade_4 54 2 115   1 3     2   4   96 85                       181 54 2 115   1 3     2   4   96 85                 181
1134155 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 61.0 1.0 126.0   2.0 3.0     0.0   1.0   98.0 96.0                       194.0 61 1 126   2 3     0   1   98 96                 194
1739232 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   grade_4 31 0 107   0 0     2   5   83 62                       145 31 0 107   0 0     2   5   83 62                 145
1739246 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_4 7 2 30   5 0     0   1   18 27                       45 7 2 30   5 0     0   1   18 27                 45
1800291 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   grade_4 64 2 131   2 1     0   6   101 105                       206 64 2 131   2 1     0   6   101 105                 206
1894671 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_4 40 2 134   0 1     0   3   97 83                       180 40 2 134   0 1     0   3   97 83                 180
1931967 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 57 2 141   1 0     0   5   102 104                       206 57 2 141   1 0     0   5   102 104                 206
713936 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 33 15 15   2 2     2   4   37 36                       73 33 15 15   2 2     2   4   37 36                 73
713945 CO     school 804080 1000   FOUNTAIN 8 80408006330 3027 EAGLESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 57 11 28   4 2     2   15   61 58                       119 57 11 28   4 2     2   15   61 58                 119
713952 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 38 5 27   0 0     0   6   47 29                       76 38 5 27   0 0     0   6   47 29                 76
713963 CO     school 804080 1000   FOUNTAIN 8 80408000564 3108 MESA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 45 5 19   0 0     0   5   36 38                       74 45 5 19   0 0     0   5   36 38                 74
713975 CO     school 804080 1000   FOUNTAIN 8 80408001481 4474 JORDAHL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 56 3 26   1 1     2   7   59 37                       96 56 3 26   1 1     2   7   59 37                 96
713982 CO     school 804080 1000   FOUNTAIN 8 80408000856 6138 MOUNTAINSIDE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 29 8 13   0 0     0   5   29 26                       55 29 8 13   0 0     0   5   29 26                 55
713989 CO     school 804080 1000   FOUNTAIN 8 80408000565 6338 PATRIOT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 40 19 18   1 2     3   7   50 40                       90 40 19 18   1 2     3   7   50 40                 90
713996 CO     school 804080 1000   FOUNTAIN 8 80408006481 9610 WEIKEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 41 12 20   2 4     1   7   39 48                       87 41 12 20   2 4     1   7   39 48                 87
841551 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_4 20 6 10   0 0     0   6   24 18                       42 20 6 10   0 0     0   6   24 18                 42
841560 CO     school 804080 1000   FOUNTAIN 8 80408006330 3027 EAGLESIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 54 14 27   4 0     1   10   61 49                       110 54 14 27   4 0     1   10   61 49                 110
841567 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_4 33 3 25   1 0     1   10   41 32                       73 33 3 25   1 0     1   10   41 32                 73
841578 CO     school 804080 1000   FOUNTAIN 8 80408000564 3108 MESA ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_4 33 8 24   0 1     3   5   34 40                       74 33 8 24   0 1     3   5   34 40                 74
841590 CO     school 804080 1000   FOUNTAIN 8 80408001481 4474 JORDAHL ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_4 48 4 17   0 0     0   9   38 40                       78 48 4 17   0 0     0   9   38 40                 78
841597 CO     school 804080 1000   FOUNTAIN 8 80408000856 6138 MOUNTAINSIDE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_4 29 7 16   0 0     0   4   32 24                       56 29 7 16   0 0     0   4   32 24                 56
841604 CO     school 804080 1000   FOUNTAIN 8 80408000565 6338 PATRIOT ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_4 42 19 33   0 4     5   7   51 59                       110 42 19 33   0 4     5   7   51 59                 110
841611 CO     school 804080 1000   FOUNTAIN 8 80408006481 9610 WEIKEL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 48 6 21   0 0     1   6   45 37                       82 48 6 21   0 0     1   6   45 37                 82

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