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

year

grade

  • grade_2 · 7,525
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
710920 CO     school 802490 480   BOULDER VALLEY RE 2 80249001403 7592 ALICIA SANCHEZ INTERNATIONAL SCHOOL   Regular School No Elementary PK 05 2017   grade_2 17 0 30   0 0     0   0   27 20                       47 17 0 30   0 0     0   0   27 20                 47
838557 CO     school 802490 480   BOULDER VALLEY RE 2 80249001403 7592 ALICIA SANCHEZ INTERNATIONAL SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 16 0 38   1 3     0   2   32 28                       60 16 0 38   1 3     0   2   32 28                 60
1896814 CO     school 802490 480   BOULDER VALLEY RE 2 80249001403 7592 ALICIA SANCHEZ INTERNATIONAL SCHOOL   Regular School No Elementary PK 05 2018   grade_2 19 1 33   0 1     0   0   31 23                       54 19 1 33   0 1     0   0   31 23                 54
1934146 CO     school 802490 480   BOULDER VALLEY RE 2 80249001403 7592 ALICIA SANCHEZ INTERNATIONAL SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 2 35   0 3     0   1   31 28                       59 18 2 35   0 3     0   1   31 28                 59
715554 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 22 0 15   1 0     0   6   21 23                       44 22 0 15   1 0     0   6   21 23                 44
843159 CO     school   1420   JEFFERSON COUNTY R-1   148 ALLENDALE ELEMENTARY SCHOOL             2016   grade_2 16 0 14   0 0     0   1   14 17                       31 16 0 14   0 0     0   1   14 17                 31
1140763 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_2 23.0 0.0 10.0   0.0 0.0     0.0   1.0   16.0 18.0                       34.0 23 0 10   0 0     0   1   16 18                 34
1901472 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 12 0 12   0 0     0   1   18 7                       25 12 0 12   0 0     0   1   18 7                 25
1938888 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 12 2 9   0 0     0   0   11 12                       23 12 2 9   0 0     0   0   11 12                 23
1745384 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2021   grade_2 16 0 1   0 0     0   1   11 7                       18 16 0 1   0 0     0   1   11 7                 18
1806477 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2020   grade_2 14 0 6   0 0     0   4   11 13                       24 14 0 6   0 0     0   4   11 13                 24
1900763 CO     school 803870 1110   FALCON 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2018   grade_2 17 0 3   0 0     1   2   10 13                       23 17 0 3   0 0     1   2   10 13                 23
1938160 CO     school 803870 1110   DISTRICT 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2019   grade_2 10 0 2   0 0     0   0   8 4                       12 10 0 2   0 0     0   0   8 4                 12
710164 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001832 61 ALPINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 0 34   0 3     0   5   40 51                       91 49 0 34   0 3     0   5   40 51                 91
837802 CO     school   470   ST VRAIN VALLEY RE 1J   61 ALPINE ELEMENTARY SCHOOL             2016   grade_2 46 1 29   0 1     0   3   43 37                       80 46 1 29   0 1     0   3   43 37                 80
1135498 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001832 61 ALPINE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 43.0 3.0 36.0   1.0 0.0     1.0   3.0   43.0 44.0                       87.0 43 3 36   1 0     1   3   43 44                 87
1896075 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001832 61 ALPINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 43 3 28   0 4     0   8   52 34                       86 43 3 28   0 4     0   8   52 34                 86
1933388 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001832 61 ALPINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 1 21   0 0     0   1   32 31                       63 40 1 21   0 0     0   1   32 31                 63
708368 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 19 2 62   0 1     1   1   49 37                       86 19 2 62   0 1     1   1   49 37                 86
836026 CO     school   30   ADAMS COUNTY 14   186 ALSUP ELEMENTARY SCHOOL             2016   grade_2 13 2 77   1 0     0   1   43 51                       94 13 2 77   1 0     0   1   43 51                 94
1133741 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 7.0 1.0 74.0   0.0 0.0     1.0   5.0   43.0 45.0                       88.0 7 1 74   0 0     1   5   43 45                 88
1894239 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 9 0 76   1 0     0   3   52 37                       89 9 0 76   1 0     0   3   52 37                 89
1931529 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 14 0 64   0 0     0   1   36 43                       79 14 0 64   0 0     0   1   36 43                 79
719015 CO     school 805220 2660   LAMAR RE-2 80522000860 200 ALTA VISTA CHARTER SCHOOL   Regular School Yes Elementary KG 06 2017   grade_2 13 0 7   1 0     0   0   7 14                       21 13 0 7   1 0     0   0   7 14                 21
846577 CO     school   2660   LAMAR RE-2   200 ALTA VISTA CHARTER SCHOOL             2016   grade_2 15 0 4   0 0     0   0   12 7                       19 15 0 4   0 0     0   0   12 7                 19
1144147 CO     school 805220 2660   LAMAR RE-2 80522000860 200 ALTA VISTA CHARTER SCHOOL   Regular School Yes 1.0 KG 06 2015   grade_2 15.0 0.0 6.0   0.0 0.0     0.0   0.0   7.0 14.0                       21.0 15 0 6   0 0     0   0   7 14                 21
1904963 CO     school 805220 2660   LAMAR RE-2 80522000860 200 ALTA VISTA CHARTER SCHOOL   Regular School Yes Elementary KG 06 2018   grade_2 11 1 7   0 0     0   1   8 12                       20 11 1 7   0 0     0   1   8 12                 20
1942318 CO     school 805220 2660   LAMAR RE-2 80522000860 200 ALTA VISTA CHARTER SCHOOL   Regular School Yes Elementary KG 06 2019   grade_2 9 0 10   0 0     0   1   13 7                       20 9 0 10   0 0     0   1   13 7                 20
1932087 CO     school 802910 130   CHERRY CREEK 5 80291006750 102 ALTITUDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 61 7 19   2 7     0   6   49 53                       102 61 7 19   2 7     0   6   49 53                 102
709508 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 6 70   0 1     0   0   47 36                       83 6 6 70   0 1     0   0   47 36                 83
837154 CO     school   180   ADAMS-ARAPAHOE 28J   214 ALTURA ELEMENTARY SCHOOL             2016   grade_2 9 6 68   0 2     0   1   49 37                       86 9 6 68   0 2     0   1   49 37                 86
1134871 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 6.0 12.0 81.0   0.0 1.0     0.0   4.0   51.0 53.0                       104.0 6 12 81   0 1     0   4   51 53                 104
1895408 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 8 12 62   0 4     0   1   49 38                       87 8 12 62   0 4     0   1   49 38                 87
1932717 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 7 60   1 2     0   0   45 35                       80 10 7 60   1 2     0   0   45 35                 80
712721 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 154 1 18   0 29     0   10   115 97                       212 154 1 18   0 29     0   10   115 97                 212
840353 CO     school   900   DOUGLAS COUNTY RE 1   215 AMERICAN ACADEMY             2016   grade_2 170 1 18   0 20     0   9   115 103                       218 170 1 18   0 20     0   9   115 103                 218
1137987 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes 1.0 PK 08 2015   grade_2 162.0 4.0 20.0   1.0 26.0     0.0   10.0   101.0 122.0                       223.0 162 4 20   1 26     0   10   101 122                 223
1898633 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2018   grade_2 202 0 18   5 54     0   21   170 130                       300 202 0 18   5 54     0   21   170 130                 300
1935983 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 223 2 24   2 51     0   21   167 156                       323 223 2 24   2 51     0   21   167 156                 323
711351 CO     school 803360 880   DENVER COUNTY 1 80336000306 220 AMESSE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 4 15 52   0 1     0   2   35 39                       74 4 15 52   0 1     0   2   35 39                 74
838974 CO     school   880   DENVER COUNTY 1   220 AMESSE ELEMENTARY SCHOOL             2016   grade_2 4 18 63   1 0     1   2   45 44                       89 4 18 63   1 0     1   2   45 44                 89
1136657 CO     school 803360 880   DENVER COUNTY 1 80336000306 220 AMESSE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 5.0 12.0 68.0   0.0 0.0     1.0   3.0   52.0 37.0                       89.0 5 12 68   0 0     1   3   52 37                 89
1897242 CO     school 803360 880   DENVER COUNTY 1 80336000306 220 AMESSE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 1 7 49   1 0     0   2   35 25                       60 1 7 49   1 0     0   2   35 25                 60
716938 CO     school 803480 1520   DURANGO 9-R 80348001066 225 ANIMAS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 28 0 13   2 0     0   1   29 15                       44 28 0 13   2 0     0   1   29 15                 44
844533 CO     school   1520   DURANGO 9-R   225 ANIMAS VALLEY ELEMENTARY SCHOOL             2016   grade_2 29 0 12   2 0     0   5   26 22                       48 29 0 12   2 0     0   5   26 22                 48
1142115 CO     school 803480 1520   DURANGO 9-R 80348001066 225 ANIMAS VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 24.0 0.0 12.0   2.0 0.0     0.0   1.0   21.0 18.0                       39.0 24 0 12   2 0     0   1   21 18                 39
1902875 CO     school 803480 1520   DURANGO 9-R 80348001066 225 ANIMAS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 29 1 12   1 0     0   2   20 25                       45 29 1 12   1 0     0   2   20 25                 45
1940245 CO     school 803480 1520   DURANGO 9-R 80348001066 225 ANIMAS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 25 0 12   3 0     0   1   26 15                       41 25 0 12   3 0     0   1   26 15                 41
708907 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 67 12 22   0 7     0   4   60 52                       112 67 12 22   0 7     0   4   60 52                 112
836553 CO     school   130   CHERRY CREEK 5   242 ANTELOPE RIDGE ELEMENTARY SCHOOL             2016   grade_2 56 6 19   1 6     1   10   42 57                       99 56 6 19   1 6     1   10   42 57                 99
1134278 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 63.0 18.0 22.0   0.0 3.0     0.0   8.0   52.0 62.0                       114.0 63 18 22   0 3     0   8   52 62                 114
1894795 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 68 9 20   0 8     0   11   68 48                       116 68 9 20   0 8     0   11   68 48                 116
1932099 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 63 8 24   0 5     1   7   59 49                       108 63 8 24   0 5     1   7   59 49                 108
714510 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 44 0 6   1 2     0   1   24 30                       54 44 0 6   1 2     0   1   24 30                 54
842125 CO     school   1040   ACADEMY 20   249 ANTELOPE TRAILS ELEMENTARY SCHOOL             2016   grade_2 45 1 8   0 0     0   1   32 23                       55 45 1 8   0 0     0   1   32 23                 55
1139739 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 63.0 0.0 7.0   0.0 1.0     0.0   5.0   31.0 45.0                       76.0 63 0 7   0 1     0   5   31 45                 76
1900423 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 36 1 3   0 0     0   6   22 24                       46 36 1 3   0 0     0   6   22 24                 46
1937802 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 35 1 5   1 2     0   2   24 22                       46 35 1 5   1 2     0   2   24 22                 46
710186 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2017   grade_2 80 1 7   0 3     0   6   57 40                       97 80 1 7   0 3     0   6   57 40                 97
837823 CO     school   470   ST VRAIN VALLEY RE 1J   120 APEX HOME SCHOOL ENRICHMENT PROGRAM             2016   grade_2 75 1 6   0 2     0   3   46 41                       87 75 1 6   0 2     0   3   46 41                 87
1135518 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No 4.0 KG 12 2015   grade_2 56.0 0.0 9.0   0.0 1.0     0.0   0.0   31.0 35.0                       66.0 56 0 9   0 1     0   0   31 35                 66
1896098 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2018   grade_2 58 0 8   1 3     0   2   36 36                       72 58 0 8   1 3     0   2   36 36                 72
1933411 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2019   grade_2 60 0 14   0 2     0   2   44 34                       78 60 0 14   0 2     0   2   44 34                 78
718031 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000597 262 APPLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 53 0 12   0 1     0   4   33 37                       70 53 0 12   0 1     0   4   33 37                 70
845604 CO     school   2000   MESA COUNTY VALLEY 51   262 APPLETON ELEMENTARY SCHOOL             2016   grade_2 37 2 6   0 3     0   1   19 30                       49 37 2 6   0 3     0   1   19 30                 49
1143183 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000597 262 APPLETON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 53.0 0.0 9.0   0.0 2.0     0.0   6.0   36.0 34.0                       70.0 53 0 9   0 2     0   6   36 34                 70
1903979 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000597 262 APPLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 55 0 8   0 5     1   1   33 37                       70 55 0 8   0 5     1   1   33 37                 70
1941354 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000597 262 APPLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 45 1 12   1 1     1   2   30 33                       63 45 1 12   1 1     1   2   30 33                 63
713950 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 27 7 32   0 0     2   9   36 41                       77 27 7 32   0 0     2   9   36 41                 77
841565 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 37 7 34   1 0     0   6   42 43                       85 37 7 34   1 0     0   6   42 43                 85
1139169 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 37.0 3.0 24.0   1.0 0.0     1.0   6.0   42.0 30.0                       72.0 37 3 24   1 0     1   6   42 30                 72
1899862 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 29 3 24   1 0     0   6   27 36                       63 29 3 24   1 0     0   6   27 36                 63
1937239 CO     school 804080 1000   FOUNTAIN 8 80408000566 3102 ARAGON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 25 12 22   0 0     0   6   40 25                       65 25 12 22   0 0     0   6   40 25                 65
707996 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 48 2 43   0 4     0   5   53 49                       102 48 2 43   0 4     0   5   53 49                 102
835662 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   301 ARAPAHOE RIDGE ELEMENTARY SCHOOL             2016   grade_2 70 0 31   0 4     1   3   63 46                       109 70 0 31   0 4     1   3   63 46                 109
1133385 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 70.0 3.0 29.0   0.0 5.0     0.0   10.0   59.0 58.0                       117.0 70 3 29   0 5     0   10   59 58                 117
1893865 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 60 1 42   1 2     1   5   52 60                       112 60 1 42   1 2     1   5   52 60                 112
1931136 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 47 0 40   1 2     0   3   46 47                       93 47 0 40   1 2     0   3   46 47                 93
719925 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 1 0 5   0 0     0   0   4 2                       6 1 0 5   0 0     0   0   4 2                 6
847495 CO     school   3040   ARICKAREE R-2   304 ARICKAREE ELEMENTARY SCHOOL             2016   grade_2 5 0 3   0 0     0   0   3 5                       8 5 0 3   0 0     0   0   3 5                 8
1145066 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 4.0 0.0 3.0   0.0 0.0     2.0   0.0   2.0 7.0                       9.0 4 0 3   0 0     2   0   2 7                 9
1905870 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 1 0 2   0 0     0   0   3 0                       3 1 0 2   0 0     0   0   3 0                 3
1943245 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 0 3   0 0     0   0   4 5                       9 6 0 3   0 0     0   0   4 5                 9
709521 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 17 25 31   0 4     1   6   35 49                       84 17 25 31   0 4     1   6   35 49                 84
837167 CO     school   180   ADAMS-ARAPAHOE 28J   310 ARKANSAS ELEMENTARY SCHOOL             2016   grade_2 18 14 18   0 2     0   6   29 29                       58 18 14 18   0 2     0   6   29 29                 58
1134884 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 20.0 22.0 47.0   0.0 1.0     0.0   7.0   55.0 42.0                       97.0 20 22 47   0 1     0   7   55 42                 97
1895421 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 19 16 29   0 3     0   7   41 33                       74 19 16 29   0 3     0   7   41 33                 74
1932725 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 16 16   0 1     1   5   22 35                       57 18 16 16   0 1     1   5   22 35                 57
708921 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 12 31   1 2     1   9   45 60                       105 49 12 31   1 2     1   9   45 60                 105
836567 CO     school   130   CHERRY CREEK 5   348 ARROWHEAD ELEMENTARY SCHOOL             2016   grade_2 47 20 30   1 8     0   8   55 59                       114 47 20 30   1 8     0   8   55 59                 114
1134292 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 36.0 23.0 26.0   0.0 2.0     1.0   8.0   50.0 46.0                       96.0 36 23 26   0 2     1   8   50 46                 96
1894809 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 40 9 18   0 5     1   7   43 37                       80 40 9 18   0 5     1   7   43 37                 80
1932113 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 41 9 17   0 3     0   6   48 28                       76 41 9 17   0 3     0   6   48 28                 76
712758 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001757 354 ARROWWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 33 0 14   0 4     0   1   24 28                       52 33 0 14   0 4     0   1   24 28                 52
840390 CO     school   900   DOUGLAS COUNTY RE 1   354 ARROWWOOD ELEMENTARY SCHOOL             2016   grade_2 41 1 12   0 6     0   2   30 32                       62 41 1 12   0 6     0   2   30 32                 62
1138024 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001757 354 ARROWWOOD ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 43.0 0.0 6.0   0.0 2.0     0.0   1.0   29.0 23.0                       52.0 43 0 6   0 2     0   1   29 23                 52
1898670 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001757 354 ARROWWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 32 0 6   0 3     0   1   24 18                       42 32 0 6   0 3     0   1   24 18                 42
1936020 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001757 354 ARROWWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 25 1 6   0 1     1   3   18 19                       37 25 1 6   0 1     1   3   18 19                 37
715544 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006489 109 ARVADA K-8   Regular School No Elementary KG 08 2017   grade_2 15 2 27   0 0     0   2   21 25                       46 15 2 27   0 0     0   2   21 25                 46
843149 CO     school   1420   JEFFERSON COUNTY R-1   109 ARVADA K-8             2016   grade_2 20 4 23   0 1     0   4   23 29                       52 20 4 23   0 1     0   4   23 29                 52

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