Data source: Big Local News · About: Big Local

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

View and edit SQL

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
709661 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2017   grade_2 18 46 89   2 3     1   15   87 87                       174 18 46 89   2 3     1   15   87 87                 174
712244 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 9 46 33   0 10     2   4   48 56                       104 9 46 33   0 10     2   4   48 56                 104
1137308 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No 1.0 PK 05 2015   grade_2 0.0 44.0 11.0   0.0 0.0     0.0   1.0   29.0 27.0                       56.0 0 44 11   0 0     0   1   29 27                 56
1740021 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_2 7 44 17   0 3     0   4   43 32                       75 7 44 17   0 3     0   4   43 32                 75
839929 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No 1.0 PK 08 2016   grade_2 10 43 32   0 31     0   2   55 63                       118 10 43 32   0 31     0   2   55 63                 118
1742873 CO     school 803360 880   Denver County 1 80336006545 7241 Rocky Mountain Prep: Creekside   Regular School Yes Elementary PK 05 2021   grade_2 7 43 25   0 7     0   1   49 34                       83 7 43 25   0 7     0   1   49 34                 83
1932494 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 24 43 35   1 3     1   7   66 48                       114 24 43 35   1 3     1   7   66 48                 114
1134422 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 29.0 42.0 38.0   1.0 9.0     1.0   7.0   57.0 70.0                       127.0 29 42 38   1 9     1   7   57 70                 127
1134658 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 23.0 42.0 35.0   1.0 12.0     0.0   11.0   69.0 55.0                       124.0 23 42 35   1 12     0   11   69 55                 124
836943 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 35 41 32   0 5     0   14   73 54                       127 35 41 32   0 5     0   14   73 54                 127
837306 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes 1.0 KG 08 2016   grade_2 26 41 79   0 5     0   14   71 94                       165 26 41 79   0 5     0   14   71 94                 165
839876 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_2 8 41 37   0 6     1   3   52 44                       96 8 41 37   0 6     1   3   52 44                 96
1137146 CO     school 803360 880   DENVER COUNTY 1 80336001776 3641 GREEN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 9.0 40.0 52.0   2.0 2.0     0.0   6.0   62.0 49.0                       111.0 9 40 52   2 2     0   6   62 49                 111
1137520 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2015   grade_2 17.0 40.0 29.0   0.0 8.0     0.0   5.0   51.0 48.0                       99.0 17 40 29   0 8     0   5   51 48                 99
1739530 CO     school 802910 130   Cherry Creek 5 80291000191 2428 Eastridge Community Elementary School   Regular School No Elementary PK 05 2021   grade_2 34 40 37   0 6     0   7   73 51                       124 34 40 37   0 6     0   7   73 51                 124
1740432 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2021   grade_2 13 40 20   0 2     0   2   40 37                       77 13 40 20   0 2     0   2   40 37                 77
1803892 CO     school 803360 880   Denver County 1 80336006545 7241 Rocky Mountain Prep: Creekside   Regular School Yes Elementary PK 05 2020   grade_2 15 40 31   0 1     1   2   49 41                       90 15 40 31   0 1     1   2   49 41                 90
1895188 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 25 40 59   1 9     0   12   78 68                       146 25 40 59   1 9     0   12   78 68                 146
1932925 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2019   grade_2 10 40 24   0 0     0   1   36 39                       75 10 40 24   0 0     0   1   36 39                 75
709051 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 34 39 38   0 5     0   8   63 61                       124 34 39 38   0 5     0   8   63 61                 124
839659 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No 1.0 PK 05 2016   grade_2 0 39 7   0 0     0   1   24 23                       47 0 39 7   0 0     0   1   24 23                 47
1135205 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No 1.0 KG 05 2015   grade_2 14.0 39.0 55.0   1.0 5.0     3.0   8.0   69.0 56.0                       125.0 14 39 55   1 5     3   8   69 56                 125
1137562 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No 1.0 PK 08 2015   grade_2 6.0 39.0 59.0   1.0 9.0     1.0   5.0   57.0 63.0                       120.0 6 39 59   1 9     1   5   57 63                 120
1800829 CO     school 802910 130   Cherry Creek 5 80291000204 9108 Village East Community Elementary School   Regular School No Elementary PK 05 2020   grade_2 27 39 48   0 9     0   6   64 65                       129 27 39 48   0 9     0   6   64 65                 129
1804116 CO     school 803360 880   Denver County 1 80336006517 8945 University Prep - Arapahoe St.   Regular School Yes Elementary KG 05 2020   grade_2 2 39 20   0 0     0   2   32 31                       63 2 39 20   0 0     0   2   32 31                 63
1932243 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 39 30   1 3     1   12   61 43                       104 18 39 30   1 3     1   12   61 43                 104
709223 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 29 38 41   1 5     0   15   64 65                       129 29 38 41   1 5     0   15   64 65                 129
836868 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 38 38 38   0 5     0   8   64 63                       127 38 38 38   0 5     0   8   64 63                 127
1135012 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes 1.0 KG 08 2015   grade_2 33.0 38.0 80.0   0.0 7.0     1.0   17.0   86.0 90.0                       176.0 33 38 80   0 7     1   17   86 90                 176
1137573 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No 1.0 PK 08 2015   grade_2 8.0 38.0 42.0   0.0 27.0     1.0   1.0   70.0 47.0                       117.0 8 38 42   0 27     1   1   70 47                 117
1895823 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2018   grade_2 17 38 22   0 3     0   1   42 39                       81 17 38 22   0 3     0   1   42 39                 81
712294 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No Elementary PK 08 2017   grade_2 17 37 30   0 25     0   3   58 54                       112 17 37 30   0 25     0   3   58 54                 112
1742570 CO     school 803360 880   Denver County 1 80336000372 4782 Hallett Academy   Regular School No Elementary PK 05 2021   grade_2 0 37 4   0 0     0   4   23 22                       45 0 37 4   0 0     0   4   23 22                 45
709720 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2017   grade_2 5 36 24   0 1     0   2   37 31                       68 5 36 24   0 1     0   2   37 31                 68
1134584 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 32.0 36.0 35.0   1.0 7.0     1.0   7.0   70.0 49.0                       119.0 32 36 35   1 7     1   7   70 49                 119
1138281 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006577 3863 HOPE ONLINE LEARNING ACADEMY ELEMENTARY   Regular School Yes 1.0 KG 05 2015   grade_2 26.0 36.0 188.0   0.0 3.0     0.0   3.0   134.0 122.0                       256.0 26 36 188   0 3     0   3   134 122                 256
1894939 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 43 36 35   0 5     0   13   70 62                       132 43 36 35   0 5     0   13   70 62                 132
1895562 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2018   grade_2 17 36 79   0 5     0   10   70 77                       147 17 36 79   0 5     0   10   70 77                 147
709297 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 17 35 49   2 5     0   8   57 59                       116 17 35 49   2 5     0   8   57 59                 116
1137358 CO     school 803360 880   DENVER COUNTY 1 80336001380 5578 MARRAMA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 5.0 35.0 57.0   0.0 6.0     1.0   5.0   53.0 56.0                       109.0 5 35 57   0 6     1   5   53 56                 109
1935803 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREP - ARAPAHOE ST.   Regular School Yes Elementary KG 05 2019   grade_2 2 35 16   0 1     0   3   33 24                       57 2 35 16   0 1     0   3   33 24                 57
1800577 CO     school 802910 130   Cherry Creek 5 80291000191 2428 Eastridge Community Elementary School   Regular School No Elementary PK 05 2020   grade_2 24 34 33   0 6     0   9   60 46                       106 24 34 33   0 6     0   9   60 46                 106
1801469 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_2 10 34 24   0 0     0   3   30 41                       71 10 34 24   0 0     0   3   30 41                 71
1740221 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_2 10 33 27   1 1     0   1   28 45                       73 10 33 27   1 1     0   1   28 45                 73
1935498 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 7 33 21   1 9     1   7   39 40                       79 7 33 21   1 9     1   7   39 40                 79
1739782 CO     school 802910 130   Cherry Creek 5 80291000204 9108 Village East Community Elementary School   Regular School No Elementary PK 05 2021   grade_2 30 32 34   2 5     0   8   61 50                       111 30 32 34   2 5     0   8   61 50                 111
1742450 CO     school 803360 880   Denver County 1 80336006609 4049 Highline Academy Northeast   Regular School Yes Elementary PK 05 2021   grade_2 9 32 30   0 7     0   8   43 43                       86 9 32 30   0 7     0   8   43 43                 86
1742531 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   grade_2 11 32 54   0 5     4   7   52 61                       113 11 32 54   0 5     4   7   52 61                 113
1801200 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_2 14 32 49   0 1     0   4   49 51                       100 14 32 49   0 1     0   4   49 51                 100
1801260 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2020   grade_2 16 32 21   0 3     0   3   33 42                       75 16 32 21   0 3     0   3   33 42                 75
1895621 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2018   grade_2 8 32 27   0 2     0   0   40 29                       69 8 32 27   0 2     0   0   40 29                 69
1898232 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP: CREEKSIDE   Regular School Yes Elementary PK 05 2018   grade_2 11 32 36   0 5     0   4   41 47                       88 11 32 36   0 5     0   4   41 47                 88
1933130 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2019   grade_2 13 32 21   0 4     0   0   32 38                       70 13 32 21   0 4     0   0   32 38                 70
712158 CO     school 803360 880   DENVER COUNTY 1 80336000384 6002 MONTCLAIR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 31 21   3 1     0   5   43 27                       70 9 31 21   3 1     0   5   43 27                 70
836699 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 41 31 29   0 10     0   16   66 61                       127 41 31 29   0 10     0   16   66 61                 127
1135188 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000078 7932 SIXTH AVENUE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 16.0 31.0 68.0   0.0 1.0     0.0   6.0   69.0 53.0                       122.0 16 31 68   0 1     0   6   69 53                 122
1137598 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP   Regular School Yes 1.0 PK 03 2015   grade_2 14.0 31.0 35.0   0.0 3.0     0.0   3.0   39.0 47.0                       86.0 14 31 35   0 3     0   3   39 47                 86
1800750 CO     school 802910 130   Cherry Creek 5 80291000200 7116 Ponderosa Elementary School   Regular School No Elementary PK 05 2020   grade_2 22 31 38   2 9     0   5   60 47                       107 22 31 38   2 9     0   5   60 47                 107
1803818 CO     school 803360 880   Denver County 1 80336001838 6508 Omar D Blair Charter School   Regular School Yes Elementary KG 08 2020   grade_2 3 31 20   1 6     2   2   37 28                       65 3 31 20   1 6     2   2   37 28                 65
1898458 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREP - ARAPAHOE ST.   Regular School Yes Elementary KG 05 2018   grade_2 4 31 19   0 0     0   3   29 28                       57 4 31 19   0 0     0   3   29 28                 57
839918 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 7 30 49   1 2     3   3   43 52                       95 7 30 49   1 2     3   3   43 52                 95
839955 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP CREEKSIDE   Regular School Yes 1.0 PK 04 2016   grade_2 11 30 32   0 4     0   3   38 42                       80 11 30 32   0 4     0   3   38 42                 80
1751137 CO     school 800020 8001   Charter School Institute 80002002033 655 High Point Academy   Regular School Yes Elementary PK 08 2021   grade_2 14 30 31   1 2     0   0   32 46                       78 14 30 31   1 2     0   0   32 46                 78
1751501 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2021   grade_2 199 30 106   1 1     3   42   188 194                       382 199 30 106   1 1     3   42   188 194                 382
1803634 CO     school 803360 880   Denver County 1 80336001867 5342 Lowry Elementary School   Regular School No Elementary PK 05 2020   grade_2 28 30 17   2 2     1   4   43 41                       84 28 30 17   2 2     1   4   43 41                 84
1898158 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2018   grade_2 5 30 37   0 7     0   5   46 38                       84 5 30 37   0 7     0   5   46 38                 84
1898196 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No Elementary PK 08 2018   grade_2 5 30 34   2 3     2   2   33 45                       78 5 30 34   2 3     2   2   33 45                 78
1898207 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No Elementary PK 08 2018   grade_2 14 30 26   0 28     1   1   45 55                       100 14 30 26   0 28     1   1   45 55                 100
1935409 CO     school 803360 880   DENVER COUNTY 1 80336000384 6002 MONTCLAIR SCHOOL OF ACADEMICS AND ENRICHMENT   Regular School No Elementary PK 05 2019   grade_2 14 30 16   1 1     0   7   39 30                       69 14 30 16   1 1     0   7   39 30                 69
712347 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes Elementary KG 02 2017   grade_2 4 29 7   0 0     0   2   18 24                       42 4 29 7   0 0     0   2   18 24                 42
839764 CO     school 803360 880   DENVER COUNTY 1 80336000378 5716 MC MEEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 25 29 38   1 8     0   7   48 60                       108 25 29 38   1 8     0   7   48 60                 108
1742710 CO     school 803360 880   Denver County 1 80336000384 6002 Montclair School of Academics and Enrichment   Regular School No Elementary PK 05 2021   grade_2 11 29 12   0 1     0   2   33 22                       55 11 29 12   0 1     0   2   33 22                 55
1803471 CO     school 803360 880   Denver County 1 80336006609 4049 Highline Academy Northeast   Regular School Yes Elementary PK 05 2020   grade_2 14 29 33   0 7     0   3   44 42                       86 14 29 33   0 7     0   3   44 42                 86
709676 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001323 4270 IOWA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 28 44   0 2     1   8   40 49                       89 6 28 44   0 2     1   8   40 49                 89
712283 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_2 4 28 46   0 7     1   4   41 49                       90 4 28 46   0 7     1   4   41 49                 90
712541 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREP - ARAPAHOE ST.   Regular School Yes Elementary KG 05 2017   grade_2 5 28 27   0 0     0   3   33 30                       63 5 28 27   0 0     0   3   33 30                 63
837175 CO     school   180   ADAMS-ARAPAHOE 28J   458 AURORA ACADEMY CHARTER SCHOOL             2016   grade_2 20 28 27   0 1     0   4   48 32                       80 20 28 27   0 1     0   4   48 32                 80
848237 CO     school   8001   CHARTER SCHOOL INSTITUTE   655 HIGH POINT ACADEMY             2016   grade_2 19 28 27   1 4     0   3   38 44                       82 19 28 27   1 4     0   3   38 44                 82
1137411 CO     school 803360 880   DENVER COUNTY 1 80336000378 5716 MC MEEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 26.0 28.0 40.0   0.0 5.0     0.0   7.0   58.0 48.0                       106.0 26 28 40   0 5     0   7   58 48                 106
1743086 CO     school 803360 880   Denver County 1 80336006517 8945 University Prep - Arapahoe St.   Regular School Yes Elementary KG 05 2021   grade_2 5 28 15   0 1     0   7   35 21                       56 5 28 15   0 1     0   7   35 21                 56
1898046 CO     school 803360 880   DENVER COUNTY 1 80336000378 5716 MC MEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 31 28 41   1 3     0   4   62 46                       108 31 28 41   1 3     0   4   62 46                 108
1932416 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 26 28 28   0 3     0   17   55 47                       102 26 28 28   0 3     0   17   55 47                 102
1935572 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP: CREEKSIDE   Regular School Yes Elementary PK 05 2019   grade_2 17 28 34   0 3     0   8   48 42                       90 17 28 34   0 3     0   8   48 42                 90
709529 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 20 27 30   0 0     0   3   43 37                       80 20 27 30   0 0     0   3   43 37                 80
712028 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No Elementary PK 05 2017   grade_2 1 26 6   0 0     0   4   20 17                       37 1 26 6   0 0     0   4   20 17                 37
837499 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No 1.0 KG 05 2016   grade_2 12 26 47   1 6     2   7   50 51                       101 12 26 47   1 6     2   7   50 51                 101
1137435 CO     school 803360 880   DENVER COUNTY 1 80336000384 6002 MONTCLAIR ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 19.0 26.0 18.0   0.0 0.0     0.0   3.0   40.0 26.0                       66.0 19 26 18   0 0     0   3   40 26                 66
1895842 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000083 9514 WHEELING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 8 26 46   0 5     0   5   47 43                       90 8 26 46   0 5     0   5   47 43                 90
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
709831 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001432 7865 SIDE CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 25 25 38   0 6     0   8   39 63                       102 25 25 38   0 6     0   8   39 63                 102
712319 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP: CREEKSIDE   Regular School Yes Elementary PK 05 2017   grade_2 19 25 37   0 7     0   1   35 54                       89 19 25 37   0 7     0   1   35 54                 89
713022 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006577 3863 HOPE ONLINE LEARNING ACADEMY ELEMENTARY   Regular School Yes Elementary KG 05 2017   grade_2 36 25 149   0 0     0   3   100 113                       213 36 25 149   0 0     0   3   100 113                 213
720668 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002033 655 HIGH POINT ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 20 25 26   1 1     0   3   42 34                       76 20 25 26   1 1     0   3   42 34                 76
837331 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000066 4426 JEWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 13 25 34   0 4     0   10   42 44                       86 13 25 34   0 4     0   10   42 44                 86
837577 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000083 9514 WHEELING ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 10 25 47   0 5     1   5   48 45                       93 10 25 47   0 5     1   5   48 45                 93
840168 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREPARATORY SCHOOL   Regular School Yes 1.0 KG 05 2016   grade_2 3 25 33   0 0     0   0   34 27                       61 3 25 33   0 0     0   0   34 27                 61
1134892 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2015   grade_2 24.0 25.0 26.0   0.0 2.0     0.0   4.0   46.0 35.0                       81.0 24 25 26   0 2     0   4   46 35                 81
1135027 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001323 4270 IOWA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 16.0 25.0 34.0   1.0 2.0     1.0   1.0   36.0 44.0                       80.0 16 25 34   1 2     1   1   36 44                 80
1135053 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000068 4970 LANSING ELEMENTARY COMMUNITY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 3.0 25.0 31.0   1.0 1.0     1.0   4.0   27.0 39.0                       66.0 3 25 31   1 1     1   4   27 39                 66
1135071 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes 4.0 KG 12 2015   grade_2 7.0 25.0 21.0   1.0 2.0     0.0   1.0   25.0 32.0                       57.0 7 25 21   1 2     0   1   25 32                 57

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