Data source: Big Local News · About: Big Local

7,620 rows where grade = "grade_1" and state = "CO" sorted by black_int descending

View and edit SQL

year

grade

  • grade_1 · 7,620
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
1739781 CO     school 802910 130   Cherry Creek 5 80291000204 9108 Village East Community Elementary School   Regular School No Elementary PK 05 2021   grade_1 16 56 32   1 7     0   11   63 60                       123 16 56 32   1 7     0   11   63 60                 123
1134657 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 28.0 50.0 36.0   1.0 6.0     0.0   16.0   79.0 58.0                       137.0 28 50 36   1 6     0   16   79 58                 137
1895187 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 27 49 36   0 4     0   12   69 59                       128 27 49 36   0 4     0   12   69 59                 128
1742872 CO     school 803360 880   Denver County 1 80336006545 7241 Rocky Mountain Prep: Creekside   Regular School Yes Elementary PK 05 2021   grade_1 10 48 25   1 1     1   2   42 46                       88 10 48 25   1 1     1   2   42 46                 88
709660 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2017   grade_1 28 47 87   0 7     0   9   83 95                       178 28 47 87   0 7     0   9   83 95                 178
837305 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes 1.0 KG 08 2016   grade_1 18 47 92   1 2     1   17   96 82                       178 18 47 92   1 2     1   17   96 82                 178
1137572 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No 1.0 PK 08 2015   grade_1 15.0 46.0 33.0   1.0 46.0     1.0   3.0   64.0 81.0                       145.0 15 46 33   1 46     1   3   64 81                 145
836942 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 21 44 45   1 5     0   8   58 66                       124 21 44 45   1 5     0   8   58 66                 124
839875 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_1 11 44 33   0 8     0   1   46 51                       97 11 44 33   0 8     0   1   46 51                 97
1137307 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No 1.0 PK 05 2015   grade_1 2.0 44.0 11.0   0.0 0.0     0.0   2.0   29.0 30.0                       59.0 2 44 11   0 0     0   2   29 30                 59
1135011 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes 1.0 KG 08 2015   grade_1 33.0 43.0 91.0   0.0 6.0     0.0   19.0   81.0 111.0                       192.0 33 43 91   0 6     0   19   81 111                 192
1137519 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2015   grade_1 10.0 43.0 34.0   0.0 8.0     1.0   2.0   50.0 48.0                       98.0 10 43 34   0 8     1   2   50 48                 98
1138280 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006577 3863 HOPE ONLINE LEARNING ACADEMY ELEMENTARY   Regular School Yes 1.0 KG 05 2015   grade_1 38.0 43.0 200.0   1.0 1.0     1.0   4.0   140.0 148.0                       288.0 38 43 200   1 1     1   4   140 148                 288
1935571 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP: CREEKSIDE   Regular School Yes Elementary PK 05 2019   grade_1 15 43 32   0 3     0   4   51 46                       97 15 43 32   0 3     0   4   51 46                 97
712293 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No Elementary PK 08 2017   grade_1 18 41 23   0 26     1   2   51 60                       111 18 41 23   0 26     1   2   51 60                 111
836867 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 30 41 38   1 5     1   12   63 65                       128 30 41 38   1 5     1   12   63 65                 128
1134583 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 41.0 41.0 34.0   0.0 4.0     0.0   9.0   71.0 58.0                       129.0 41 41 34   0 4     0   9   71 58                 129
1800828 CO     school 802910 130   Cherry Creek 5 80291000204 9108 Village East Community Elementary School   Regular School No Elementary PK 05 2020   grade_1 32 41 39   2 5     1   10   74 56                       130 32 41 39   2 5     1   10   74 56                 130
1932493 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 34 41 45   0 7     0   8   61 74                       135 34 41 45   0 7     0   8   61 74                 135
1801071 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_1 10 40 17   0 3     1   4   44 31                       75 10 40 17   0 3     1   4   44 31                 75
1800576 CO     school 802910 130   Cherry Creek 5 80291000191 2428 Eastridge Community Elementary School   Regular School No Elementary PK 05 2020   grade_1 34 39 40   0 3     0   8   70 54                       124 34 39 40   0 3     0   8   70 54                 124
1803891 CO     school 803360 880   Denver County 1 80336006545 7241 Rocky Mountain Prep: Creekside   Regular School Yes Elementary PK 05 2020   grade_1 11 39 31   0 8     0   3   52 40                       92 11 39 31   0 8     0   3   52 40                 92
709296 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 19 38 54   1 13     0   15   79 61                       140 19 38 54   1 13     0   15   79 61                 140
836698 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 42 37 38   0 8     0   10   66 69                       135 42 37 38   0 8     0   10   66 69                 135
1801465 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_1 12 37 18   0 3     0   4   41 33                       74 12 37 18   0 3     0   4   41 33                 74
1803589 CO     school 803360 880   Denver County 1 80336000372 4782 Hallett Academy   Regular School No Elementary PK 05 2020   grade_1 1 37 6   0 0     0   4   26 22                       48 1 37 6   0 0     0   4   26 22                 48
1894938 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 26 37 29   1 5     0   10   67 41                       108 26 37 29   1 5     0   10   67 41                 108
1932242 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 24 37 26   0 6     0   7   56 44                       100 24 37 26   0 6     0   7   56 44                 100
709050 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 43 36 33   1 7     0   12   71 61                       132 43 36 33   1 7     0   12   71 61                 132
1134421 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 46.0 36.0 30.0   0.0 14.0     0.0   15.0   71.0 70.0                       141.0 46 36 30   0 14     0   15   71 70                 141
1740217 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_1 13 36 22   0 1     0   0   30 42                       72 13 36 22   0 1     0   0   30 42                 72
1898157 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2018   grade_1 6 35 20   1 6     1   8   41 36                       77 6 35 20   1 6     1   8   41 36                 77
709222 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 30 34 30   0 5     1   18   65 53                       118 30 34 30   0 5     1   18   65 53                 118
709912 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2017   grade_1 21 34 20   0 4     0   2   44 37                       81 21 34 20   0 4     0   2   44 37                 81
839928 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No 1.0 PK 08 2016   grade_1 9 34 28   0 34     0   1   56 50                       106 9 34 28   0 34     0   1   56 50                 106
1135204 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No 1.0 KG 05 2015   grade_1 14.0 34.0 59.0   1.0 5.0     2.0   10.0   65.0 60.0                       125.0 14 34 59   1 5     2   10   65 60                 125
1742798 CO     school 803360 880   Denver County 1 80336001838 6508 Omar D Blair Charter School   Regular School Yes Elementary KG 08 2021   grade_1 10 34 27   0 8     1   0   43 37                       80 10 34 27   0 8     1   0   43 37                 80
1803728 CO     school 803360 880   Denver County 1 80336000384 6002 Montclair School of Academics and Enrichment   Regular School No Elementary PK 05 2020   grade_1 12 34 15   0 4     0   1   43 23                       66 12 34 15   0 4     0   1   43 23                 66
1895819 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2018   grade_1 20 34 20   0 5     0   0   32 47                       79 20 34 20   0 5     0   0   32 47                 79
1743085 CO     school 803360 880   Denver County 1 80336006517 8945 University Prep - Arapahoe St.   Regular School Yes Elementary KG 05 2021   grade_1 6 33 21   0 0     0   1   34 27                       61 6 33 21   0 0     0   1   34 27                 61
1801256 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2020   grade_1 14 33 25   1 0     0   1   30 44                       74 14 33 25   1 0     0   1   30 44                 74
1935802 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREP - ARAPAHOE ST.   Regular School Yes Elementary KG 05 2019   grade_1 3 33 18   1 0     0   3   24 34                       58 3 33 18   1 0     0   3   24 34                 58
712540 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREP - ARAPAHOE ST.   Regular School Yes Elementary KG 05 2017   grade_1 6 32 25   0 0     0   1   33 31                       64 6 32 25   0 0     0   1   33 31                 64
1740428 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2021   grade_1 12 32 18   0 1     0   4   39 28                       67 12 32 18   0 1     0   4   39 28                 67
1898231 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP: CREEKSIDE   Regular School Yes Elementary PK 05 2018   grade_1 18 32 33   0 6     0   8   49 48                       97 18 32 33   0 6     0   8   49 48                 97
1932865 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2019   grade_1 15 32 55   0 2     0   6   53 57                       110 15 32 55   0 2     0   6   53 57                 110
839788 CO     school 803360 880   DENVER COUNTY 1 80336000384 6002 MONTCLAIR ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 10 31 25   1 1     0   1   40 29                       69 10 31 25   1 1     0   1   40 29                 69
1137561 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No 1.0 PK 08 2015   grade_1 9.0 31.0 57.0   1.0 2.0     2.0   3.0   51.0 54.0                       105.0 9 31 57   1 2     2   3   51 54                 105
1742569 CO     school 803360 880   Denver County 1 80336000372 4782 Hallett Academy   Regular School No Elementary PK 05 2021   grade_1 1 31 10   0 0     0   0   24 18                       42 1 31 10   0 0     0   0   24 18                 42
1800749 CO     school 802910 130   Cherry Creek 5 80291000200 7116 Ponderosa Elementary School   Regular School No Elementary PK 05 2020   grade_1 15 31 39   0 7     1   6   45 54                       99 15 31 39   0 7     1   6   45 54                 99
1895111 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 25 31 32   0 5     0   19   57 55                       112 25 31 32   0 5     0   19   57 55                 112
1898069 CO     school 803360 880   DENVER COUNTY 1 80336000384 6002 MONTCLAIR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 8 31 20   2 1     0   7   39 30                       69 8 31 20   2 1     0   7   39 30                 69
1898457 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREP - ARAPAHOE ST.   Regular School Yes Elementary KG 05 2018   grade_1 2 31 20   0 1     0   6   30 30                       60 2 31 20   0 1     0   6   30 30                 60
839658 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No 1.0 PK 05 2016   grade_1 1 30 7   0 0     0   3   21 20                       41 1 30 7   0 0     0   3   21 20                 41
839979 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes 1.0 KG 01 2016   grade_1 2 30 8   0 0     0   1   25 16                       41 2 30 8   0 0     0   1   25 16                 41
1137145 CO     school 803360 880   DENVER COUNTY 1 80336001776 3641 GREEN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 11.0 30.0 63.0   0.0 2.0     2.0   4.0   55.0 57.0                       112.0 11 30 63   0 2     2   4   55 57                 112
1895617 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2018   grade_1 10 30 16   0 0     0   1   28 29                       57 10 30 16   0 0     0   1   28 29                 57
1933126 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2019   grade_1 12 30 25   0 0     0   4   29 42                       71 12 30 25   0 0     0   4   29 42                 71
709716 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2017   grade_1 18 29 21   0 2     0   0   37 33                       70 18 29 21   0 2     0   0   37 33                 70
712243 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_1 6 29 28   0 8     0   6   39 38                       77 6 29 28   0 8     0   6   39 38                 77
712346 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes Elementary KG 02 2017   grade_1 6 29 15   0 0     0   3   25 28                       53 6 29 15   0 0     0   3   25 28                 53
837361 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes 4.0 KG 12 2016   grade_1 9 29 14   0 1     0   1   29 25                       54 9 29 14   0 1     0   1   29 25                 54
1137803 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREPARATORY SCHOOL   Regular School Yes 1.0 KG 04 2015   grade_1 6.0 29.0 31.0   0.0 0.0     0.0   0.0   37.0 29.0                       66.0 6 29 31   0 0     0   0   37 29                 66
1145804 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002033 655 HIGH POINT ACADEMY   Regular School Yes 1.0 PK 08 2015   grade_1 19.0 29.0 28.0   1.0 3.0     0.0   5.0   40.0 45.0                       85.0 19 29 28   1 3     0   5   40 45                 85
1739978 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_1 5 29 60   1 1     0   6   58 44                       102 5 29 60   1 1     0   6   58 44                 102
1742836 CO     school 803360 880   Denver County 1 80336001933 6970 Florida Pitt-Waller ECE-8 School   Regular School No Elementary PK 08 2021   grade_1 4 29 35   0 5     3   1   40 37                       77 4 29 35   0 5     3   1   40 37                 77
1898206 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No Elementary PK 08 2018   grade_1 22 29 27   0 30     1   4   56 57                       113 22 29 27   0 30     1   4   56 57                 113
1932415 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 22 29 43   1 8     0   8   66 45                       111 22 29 43   1 8     0   8   66 45                 111
1932921 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2019   grade_1 15 29 18   1 3     0   2   32 36                       68 15 29 18   1 3     0   2   32 36                 68
1742530 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   grade_1 4 28 46   0 2     0   5   41 44                       85 4 28 46   0 2     0   5   41 44                 85
1935497 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_1 5 28 18   0 5     1   3   38 22                       60 5 28 18   0 5     1   3   38 22                 60
712027 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No Elementary PK 05 2017   grade_1 0 27 2   0 1     0   5   20 15                       35 0 27 2   0 1     0   5   20 15                 35
837174 CO     school   180   ADAMS-ARAPAHOE 28J   458 AURORA ACADEMY CHARTER SCHOOL             2016   grade_1 24 27 28   0 0     0   2   45 36                       81 24 27 28   0 0     0   2   45 36                 81
837330 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000066 4426 JEWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 13 27 36   0 3     0   4   44 39                       83 13 27 36   0 3     0   4   44 39                 83
1137597 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP   Regular School Yes 1.0 PK 03 2015   grade_1 14.0 27.0 32.0   0.0 5.0     1.0   6.0   38.0 47.0                       85.0 14 27 32   0 5     1   6   38 47                 85
1739529 CO     school 802910 130   Cherry Creek 5 80291000191 2428 Eastridge Community Elementary School   Regular School No Elementary PK 05 2021   grade_1 25 27 24   1 6     0   12   48 47                       95 25 27 24   1 6     0   12   48 47                 95
1801487 CO     school 802340 180   Adams-Arapahoe 28J 80234000083 9514 Wheeling Elementary School   Regular School No Elementary PK 05 2020   grade_1 6 27 38   0 2     0   2   42 33                       75 6 27 38   0 2     0   2   42 33                 75
1803470 CO     school 803360 880   Denver County 1 80336006609 4049 Highline Academy Northeast   Regular School Yes Elementary PK 05 2020   grade_1 14 27 27   0 7     0   8   39 44                       83 14 27 27   0 7     0   8   39 44                 83
1804115 CO     school 803360 880   Denver County 1 80336006517 8945 University Prep - Arapahoe St.   Regular School Yes Elementary KG 05 2020   grade_1 5 27 15   0 0     0   5   28 24                       52 5 27 15   0 0     0   5   28 24                 52
1935313 CO     school 803360 880   DENVER COUNTY 1 80336001867 5342 LOWRY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 28 27 18   2 2     0   9   44 42                       86 28 27 18   2 2     0   9   44 42                 86
709496 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2017   grade_1 18 26 28   0 1     0   7   43 37                       80 18 26 28   0 1     0   7   43 37                 80
712282 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_1 6 26 40   1 3     2   3   38 43                       81 6 26 40   1 3     2   3   38 43                 81
712318 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP: CREEKSIDE   Regular School Yes Elementary PK 05 2017   grade_1 15 26 35   0 5     0   8   43 46                       89 15 26 35   0 5     0   8   43 46                 89
837346 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000068 4970 LANSING ELEMENTARY COMMUNITY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 8 26 33   0 1     0   3   41 30                       71 8 26 33   0 1     0   3   41 30                 71
839477 CO     school 803360 880   DENVER COUNTY 1 80336001776 3641 GREEN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 13 26 58   1 3     1   7   53 56                       109 13 26 58   1 3     1   7   53 56                 109
839954 CO     school 803360 880   DENVER COUNTY 1 80336006545 7241 ROCKY MOUNTAIN PREP CREEKSIDE   Regular School Yes 1.0 PK 04 2016   grade_1 14 26 31   0 10     0   3   36 48                       84 14 26 31   0 10     0   3   36 48                 84
840167 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREPARATORY SCHOOL   Regular School Yes 1.0 KG 05 2016   grade_1 5 26 30   0 1     0   4   36 30                       66 5 26 30   0 1     0   4   36 30                 66
1134931 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001388 1470 CENTURY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 9.0 26.0 21.0   0.0 0.0     0.0   7.0   35.0 28.0                       63.0 9 26 21   0 0     0   7   35 28                 63
1135036 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000066 4426 JEWELL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 13.0 26.0 35.0   0.0 3.0     0.0   10.0   48.0 39.0                       87.0 13 26 35   0 3     0   10   48 39                 87
1135179 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001432 7865 SIDE CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 26.0 26.0 37.0   1.0 9.0     0.0   10.0   56.0 53.0                       109.0 26 26 37   1 9     0   10   56 53                 109
1137410 CO     school 803360 880   DENVER COUNTY 1 80336000378 5716 MC MEEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 28.0 26.0 29.0   1.0 9.0     0.0   9.0   44.0 58.0                       102.0 28 26 29   1 9     0   9   44 58                 102
1137616 CO     school 803360 880   DENVER COUNTY 1 80336000399 7578 SAMUELS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_1 17.0 26.0 58.0   0.0 12.0     0.0   2.0   57.0 58.0                       115.0 17 26 58   0 12     0   2   57 58                 115
1742369 CO     school 803360 880   Denver County 1 80336001776 3641 Green Valley Elementary School   Regular School No Elementary PK 05 2021   grade_1 3 26 63   1 10     2   3   60 48                       108 3 26 63   1 10     2   3   60 48                 108
1803550 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2020   grade_1 10 26 49   0 4     2   6   45 52                       97 10 26 49   0 4     2   6   45 52                 97
1899595 CO     school 804530 980   HARRISON 2 80453000663 1383 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 13 26 47   2 1     2   9   39 61                       100 13 26 47   2 1     2   9   39 61                 100
1935153 CO     school 803360 880   DENVER COUNTY 1 80336006609 4049 HIGHLINE ACADEMY NORTHEAST   Regular School Yes Elementary PK 05 2019   grade_1 13 26 35   0 7     0   3   45 39                       84 13 26 35   0 7     0   3   45 39                 84
709934 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000083 9514 WHEELING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 9 25 44   0 3     0   4   47 38                       85 9 25 44   0 3     0   4   47 38                 85
712133 CO     school 803360 880   DENVER COUNTY 1 80336000378 5716 MC MEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 26 25 38   0 4     0   4   50 47                       97 26 25 38   0 4     0   4   50 47                 97
837142 CO     school   180   ADAMS-ARAPAHOE 28J   213 AXL ACADEMY             2016   grade_1 19 25 21   2 1     0   5   32 41                       73 19 25 21   2 1     0   5   32 41                 73
837320 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001323 4270 IOWA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 12 25 36   0 3     0   6   37 45                       82 12 25 36   0 3     0   6   37 45                 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]);