enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
719349 719349 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1144490 1144490 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No 4.0 KG 12 2015   grade_2 0.0 0.0 1.0   0.0 0.0     0.0   1.0   2.0 0.0                       2.0 0 0 1   0 0     0   1   2 0                 2
1942663 1942663 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_2 2 0 1   0 0     0   1   2 2                       4 2 0 1   0 0     0   1   2 2                 4
1749779 1749779 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2021   grade_2 1 0 1   0 0     0   0   0 2                       2 1 0 1   0 0     0   0   0 2                 2
1810907 1810907 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_2 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
713934 713934 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 16 24   0 2     1   7   43 42                       85 35 16 24   0 2     1   7   43 42                 85
841549 841549 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 31 10 22   0 0     5   9   42 35                       77 31 10 22   0 0     5   9   42 35                 77
1139155 1139155 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 40.0 20.0 21.0   3.0 0.0     0.0   7.0   52.0 39.0                       91.0 40 20 21   3 0     0   7   52 39                 91
1899846 1899846 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 43 8 18   3 0     3   10   44 41                       85 43 8 18   3 0     3   10   44 41                 85
1937223 1937223 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 33 12 18   1 2     0   12   44 34                       78 33 12 18   1 2     0   12   44 34                 78
712225 712225 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2017   grade_2 15 0 34   0 0     0   1   25 25                       50 15 0 34   0 0     0   1   25 25                 50
839857 839857 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No 1.0 PK 06 2016   grade_2 24 0 28   0 1     0   0   27 26                       53 24 0 28   0 1     0   0   27 26                 53
1137501 1137501 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No 1.0 PK 06 2015   grade_2 20.0 0.0 36.0   0.0 1.0     0.0   0.0   29.0 28.0                       57.0 20 0 36   0 1     0   0   29 28                 57
1898139 1898139 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2018   grade_2 19 2 26   0 1     0   2   30 20                       50 19 2 26   0 1     0   2   30 20                 50
1935479 1935479 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   grade_2 18 0 41   0 1     0   1   33 28                       61 18 0 41   0 1     0   1   33 28                 61
711343 711343 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2017   grade_2 7 6 10   0 0     1   0   13 11                       24 7 6 10   0 0     1   0   13 11                 24
838967 838967 CO     school   880   DENVER COUNTY 1   99 ACADEMY 360             2016   grade_2 2 12 14   0 2     0   3   14 19                       33 2 12 14   0 2     0   3   14 19                 33
1136652 1136652 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes 1.0 KG 03 2015   grade_2 4.0 12.0 13.0   0.0 1.0     0.0   2.0   16.0 16.0                       32.0 4 12 13   0 1     0   2   16 16                 32
1897234 1897234 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2018   grade_2 3 7 15   0 0     0   0   13 12                       25 3 7 15   0 0     0   0   13 12                 25
1934562 1934562 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   grade_2 3 4 9   0 0     0   1   6 11                       17 3 4 9   0 0     0   1   6 11                 17
714545 714545 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2017   grade_2 5 0 1   0 0     0   2   5 3                       8 5 0 1   0 0     0   2   5 3                 8
842160 842160 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No 1.0 KG 08 2016   grade_2 12 0 5   0 0     0   0   6 11                       17 12 0 5   0 0     0   0   6 11                 17
1900458 1900458 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2018   grade_2 4 0 2   0 0     0   0   3 3                       6 4 0 2   0 0     0   0   3 3                 6
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
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
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
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
714018 714018 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2017   grade_2 29 0 5   1 0     0   3   20 18                       38 29 0 5   1 0     0   3   20 18                 38
841633 841633 CO     school   1010   COLORADO SPRINGS 11   517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING             2016   grade_2 28 0 4   1 1     0   3   15 22                       37 28 0 4   1 1     0   3   15 22                 37
1139240 1139240 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes 1.0 KG 08 2015   grade_2 33.0 0.0 1.0   0.0 0.0     0.0   0.0   23.0 11.0                       34.0 33 0 1   0 0     0   0   23 11                 34
1899930 1899930 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2018   grade_2 27 0 6   0 0     0   3   15 21                       36 27 0 6   0 0     0   3   15 21                 36
1937307 1937307 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 27 0 4   0 0     0   1   16 16                       32 27 0 4   0 0     0   1   16 16                 32
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
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
1895387 1895387 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2018   grade_2 10 23 34   1 1     0   5   47 27                       74 10 23 34   1 1     0   5   47 27                 74
1932694 1932694 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 11 24 35   1 2     0   6   37 42                       79 11 24 35   1 2     0   6   37 42                 79
1943992 1943992 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_2 28 1 1   0 0     1   1   14 18                       32 28 1 1   0 0     1   1   14 18                 32
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
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
707887 707887 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_2 12 1 42   0 1     0   0   28 28                       56 12 1 42   0 1     0   0   28 28                 56
835567 835567 CO     school   10   MAPLETON 1   505 ACHIEVE ACADEMY             2016   grade_2 3 0 42   1 1     0   0   23 24                       47 3 0 42   1 1     0   0   23 24                 47
1133290 1133290 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No 1.0 PK 08 2015   grade_2 12.0 0.0 43.0   0.0 4.0     0.0   2.0   23.0 38.0                       61.0 12 0 43   0 4     0   2   23 38                 61
1893750 1893750 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2018   grade_2 4 0 45   0 2     0   1   26 26                       52 4 0 45   0 2     0   1   26 26                 52
1931022 1931022 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_2 9 1 35   0 1     0   0   23 23                       46 9 1 35   0 1     0   0   23 23                 46
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
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
714155 714155 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 23 15 25   0 0     0   3   36 30                       66 23 15 25   0 0     0   3   36 30                 66
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
1900069 1900069 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 19 14 24   0 0     0   9   34 32                       66 19 14 24   0 0     0   9   34 32                 66
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
1937447 1937447 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 21 18 29   0 0     1   4   38 35                       73 21 18 29   0 0     1   4   38 35                 73
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
1140857 1140857 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes 4.0 KG 12 2015   grade_2 8.0 0.0 5.0   0.0 0.0     0.0   0.0   9.0 4.0                       13.0 8 0 5   0 0     0   0   9 4                 13
715573 715573 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006643 491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL   Regular School Yes Elementary PK 05 2017   grade_2 35 1 16   0 0     0   2   31 23                       54 35 1 16   0 0     0   2   31 23                 54
843177 843177 CO     school   1420   JEFFERSON COUNTY R-1   491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL             2016   grade_2 18 1 7   0 0     0   0   7 19                       26 18 1 7   0 0     0   0   7 19                 26
1901491 1901491 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006643 491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL   Regular School Yes Elementary PK 05 2018   grade_2 46 3 14   0 2     0   5   32 38                       70 46 3 14   0 2     0   5   32 38                 70
1938906 1938906 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006643 491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL   Regular School Yes Elementary PK 05 2019   grade_2 54 0 17   0 1     0   2   34 40                       74 54 0 17   0 1     0   2   34 40                 74
707907 707907 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 5 1 41   0 0     0   1   26 22                       48 5 1 41   0 0     0   1   26 22                 48
835587 835587 CO     school   10   MAPLETON 1   507 ADVENTURE ELEMENTARY             2016   grade_2 4 0 38   0 0     0   2   21 23                       44 4 0 38   0 0     0   2   21 23                 44
1133310 1133310 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_2 13.0 0.0 43.0   1.0 0.0     0.0   1.0   28.0 30.0                       58.0 13 0 43   1 0     0   1   28 30                 58
1893770 1893770 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2018   grade_2 5 1 36   1 1     0   2   27 19                       46 5 1 36   1 1     0   2   27 19                 46
1931042 1931042 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_2 6 0 39   0 1     0   2   27 21                       48 6 0 39   0 1     0   2   27 21                 48
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
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
717805 717805 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 1 0 6   0 0     0   0   4 3                       7 1 0 6   0 0     0   0   4 3                 7
845377 845377 CO     school   1620   AGUILAR REORGANIZED 6   58 AGUILAR ELEMENTARY SCHOOL             2016   grade_2 5 0 5   0 0     0   0   8 2                       10 5 0 5   0 0     0   0   8 2                 10
1142955 1142955 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 6.0 0.0 1.0   0.0 0.0     0.0   0.0   5.0 2.0                       7.0 6 0 1   0 0     0   0   5 2                 7
1903750 1903750 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 5 0 5   0 0     0   0   4 6                       10 5 0 5   0 0     0   0   4 6                 10
1941130 1941130 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 0 4   0 0     0   0   5 5                       10 6 0 4   0 0     0   0   5 5                 10
719909 719909 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_2 26 0 8   0 0     0   0   19 15                       34 26 0 8   0 0     0   0   19 15                 34
847479 847479 CO     school   3030   AKRON R-1   86 AKRON ELEMENTARY SCHOOL             2016   grade_2 13 0 6   0 0     0   1   12 8                       20 13 0 6   0 0     0   1   12 8                 20
1145050 1145050 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2015   grade_2 18.0 1.0 6.0   0.0 0.0     0.0   1.0   19.0 7.0                       26.0 18 1 6   0 0     0   1   19 7                 26
1905854 1905854 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2018   grade_2 25 0 6   0 0     0   2   20 13                       33 25 0 6   0 0     0   2   20 13                 33
1943229 1943229 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2019   grade_2 24 0 8   2 0     0   1   20 15                       35 24 0 8   2 0     0   1   20 15                 35
708781 708781 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 52 4 135   2 0     0   5   100 98                       198 52 4 135   2 0     0   5   100 98                 198
836428 836428 CO     school   100   ALAMOSA RE-11J   115 ALAMOSA ELEMENTARY SCHOOL             2016   grade_2 41 2 129   2 1     0   1   97 79                       176 41 2 129   2 1     0   1   97 79                 176
1134153 1134153 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 50.0 0.0 116.0   2.0 2.0     0.0   4.0   88.0 86.0                       174.0 50 0 116   2 2     0   4   88 86                 174
1894669 1894669 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 64 1 132   2 1     0   6   99 107                       206 64 1 132   2 1     0   6   99 107                 206
1931965 1931965 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 48 2 141   4 0     2   6   111 92                       203 48 2 141   4 0     2   6   111 92                 203
708868 708868 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 18 2 72   0 1     0   3   51 45                       96 18 2 72   0 1     0   3   51 45                 96
1894756 1894756 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2018   grade_2 11 2 70   0 0     0   1   45 39                       84 11 2 70   0 0     0   1   45 39                 84
1932052 1932052 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 10 1 56   1 0     0   4   43 29                       72 10 1 56   1 0     0   4   43 29                 72

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