Data source: Big Local News · About: Big Local

694 rows where grade = "grade_6", state = "CO" and year = 2021 sorted by ccd_school_lvl

View and edit SQL

year

  • 2021 · 694

grade

  • grade_6 · 694
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
1739973 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_6 1 0 1   0 0     0   2   3 1                       4 1 0 1   0 0     0   2   3 1                 4
1738289 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2021   grade_6 4 1 38   0 1     0   0   23 21                       44 4 1 38   0 1     0   0   23 21                 44
1738313 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2021   grade_6 3 0 35   0 1     0   1   19 21                       40 3 0 35   0 1     0   1   19 21                 40
1738322 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_6 9 0 43   0 1     0   2   32 23                       55 9 0 43   0 1     0   2   32 23                 55
1738332 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   grade_6 25 3 81   0 0     2   1   49 63                       112 25 3 81   0 0     2   1   49 63                 112
1738342 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   grade_6 8 1 40   0 0     0   1   22 28                       50 8 1 40   0 0     0   1   22 28                 50
1738351 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2021   grade_6 5 3 55   0 4     0   0   31 36                       67 5 3 55   0 4     0   0   31 36                 67
1738396 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_6 7 0 44   1 0     0   0   26 26                       52 7 0 44   1 0     0   0   26 26                 52
1738563 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2021   grade_6 50 2 8   0 9     0   3   34 38                       72 50 2 8   0 9     0   3   34 38                 72
1738710 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2021   grade_6 52 1 19   0 3     0   7   55 27                       82 52 1 19   0 3     0   7   55 27                 82
1738721 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_6 19 0 93   0 1     0   3   57 59                       116 19 0 93   0 1     0   3   57 59                 116
1738738 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2021   grade_6 62 0 9   0 1     0   6   42 36                       78 62 0 9   0 1     0   6   42 36                 78
1738865 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2021   grade_6 20 2 42   0 1     0   1   34 32                       66 20 2 42   0 1     0   1   34 32                 66
1738893 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2021   grade_6 83 2 54   0 1     0   7   75 72                       147 83 2 54   0 1     0   7   75 72                 147
1738908 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2021   grade_6 45 1 36   0 1     0   3   48 38                       86 45 1 36   0 1     0   3   48 38                 86
1738926 CO     school 802580 40   School District 27J 80258006325 4950 Landmark Academy at Reunion   Regular School Yes Elementary KG 08 2021   grade_6 46 3 30   0 6     0   2   49 38                       87 46 3 30   0 6     0   2   49 38                 87
1739089 CO     school 807230 70   Westminster Public Schools 80723001232 1622 Metropolitan Arts Academy   Regular School No Elementary PK 07 2021   grade_6 9 1 30   0 1     0   0   17 24                       41 9 1 30   0 1     0   0   17 24                 41
1739121 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2021   grade_6 23 0 35   1 1     0   2   41 21                       62 23 0 35   1 1     0   2   41 21                 62
1739132 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 07 2021   grade_6 3 1 72   0 2     0   0   37 41                       78 3 1 72   0 2     0   0   37 41                 78
1739142 CO     school 807230 70   Westminster Public Schools 80723001241 5388 Colorado Sports Leadership Academy   Regular School No Elementary KG 08 2021   grade_6 8 0 40   0 0     0   1   28 21                       49 8 0 40   0 0     0   1   28 21                 49
1739164 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 07 2021   grade_6 5 0 21   0 3     0   0   17 12                       29 5 0 21   0 3     0   0   17 12                 29
1739186 CO     school 807230 70   Westminster Public Schools 80723001247 7952 Skyline Vista Elementary School   Regular School No Elementary PK 06 2021   grade_6 2 0 43   0 2     0   1   27 21                       48 2 0 43   0 2     0   1   27 21                 48
1739203 CO     school 807230 70   Westminster Public Schools 80723001249 8798 Tennyson Knolls Preparatory School   Regular School No Elementary PK 08 2021   grade_6 4 0 37   0 5     0   1   21 26                       47 4 0 37   0 5     0   1   21 26                 47
1739214 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2021   grade_6 6 0 25   0 1     0   1   19 14                       33 6 0 25   0 1     0   1   19 14                 33
1739284 CO     school 803780 120   Englewood 1 80378000486 1514 Charles Hay World School   Regular School No Elementary KG 06 2021   grade_6 21 0 10   0 0     0   0   19 12                       31 21 0 10   0 0     0   0   19 12                 31
1739292 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2021   grade_6 17 2 8   0 0     0   1   12 16                       28 17 2 8   0 0     0   1   12 16                 28
1739300 CO     school 803780 120   Englewood 1 80378000489 1652 Clayton Elementary School   Regular School No Elementary KG 06 2021   grade_6 18 1 27   0 1     0   1   23 25                       48 18 1 27   0 1     0   1   23 25                 48
1739322 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2021   grade_6 5 1 16   0 1     0   3   16 10                       26 5 1 16   0 1     0   3   16 10                 26
1739440 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2021   grade_6 32 13 12   0 18     0   5   40 40                       80 32 13 12   0 18     0   5   40 40                 80
1739468 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2021   grade_6 37 7 9   0 23     0   2   34 44                       78 37 7 9   0 23     0   2   34 44                 78
1739598 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2021   grade_6 15 5 3   0 1     0   1   14 11                       25 15 5 3   0 1     0   1   14 11                 25
1739876 CO     school 805310 140   Littleton 6 80531001515 5229 Littleton Academy   Regular School Yes Elementary KG 08 2021   grade_6 43 3 6   0 1     0   2   31 24                       55 43 3 6   0 1     0   2   31 24                 55
1739886 CO     school 805310 140   Littleton 6 80531001626 5233 Littleton Prep Charter School   Regular School Yes Elementary PK 08 2021   grade_6 38 2 12   0 2     0   5   31 28                       59 38 2 12   0 2     0   5   31 28                 59
1739983 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_6 6 25 90   0 1     0   11   70 63                       133 6 25 90   0 1     0   11   70 63                 133
1739998 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2021   grade_6 14 13 13   1 0     0   1   21 21                       42 14 13 13   1 0     0   1   21 21                 42
1740025 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_6 12 19 30   0 0     0   1   31 31                       62 12 19 30   0 0     0   1   31 31                 62
1740039 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2021   grade_6 32 10 23   1 15     0   4   47 38                       85 32 10 23   1 15     0   4   47 38                 85
1740050 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2021   grade_6 4 3 32   1 1     0   1   16 26                       42 4 3 32   1 1     0   1   16 26                 42
1740074 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2021   grade_6 3 6 51   0 0     0   6   34 32                       66 3 6 51   0 0     0   6   34 32                 66
1740089 CO     school 802340 180   Adams-Arapahoe 28J 80234006803 1851 Harmony Ridge P-8   Regular School No Elementary PK 08 2021   grade_6 9 6 43   0 0     0   1   32 27                       59 9 6 43   0 0     0   1   32 27                 59
1740139 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2021   grade_6 12 15 69   0 3     1   4   58 46                       104 12 15 69   0 3     1   4   58 46                 104
1740165 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2021   grade_6 3 24 59   0 1     2   7   53 43                       96 3 24 59   0 1     2   7   53 43                 96
1740258 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2021   grade_6 31 9 21   0 2     0   5   35 33                       68 31 9 21   0 2     0   5   35 33                 68
1740311 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2021   grade_6 42 13 20   0 11     1   4   37 54                       91 42 13 20   0 11     1   4   37 54                 91
1740373 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 08 2021   grade_6 0 5 27   0 5     1   0   20 18                       38 0 5 27   0 5     1   0   20 18                 38
1740383 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2021   grade_6 2 6 24   0 0     0   1   11 22                       33 2 6 24   0 0     0   1   11 22                 33
1740409 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2021   grade_6 33 8 34   0 5     0   13   51 42                       93 33 8 34   0 5     0   13   51 42                 93
1740471 CO     school 802700 190   Byers 32J 80270000163 1168 Byers Elementary School   Regular School No Elementary PK 06 2021   grade_6 21 0 7   1 0     0   0   19 10                       29 21 0 7   1 0     0   0   19 10                 29
1740506 CO     school 802700 190   Byers 32J 80270006630 6241 Colorado Virtual Academy   Regular School Yes Elementary KG 06 2021   grade_6 63 1 14   1 3     0   0   41 41                       82 63 1 14   1 3     0   0   41 41                 82
1740550 CO     school 802190 220   Archuleta County 50 Jt 80219006717 6679 Pagosa Peak Open School   Regular School Yes Elementary KG 07 2021   grade_6 5 0 2   0 0     0   0   2 5                       7 5 0 2   0 0     0   0   2 5                 7
1740559 CO     school 807110 230   Walsh RE-1 80711001215 9222 Walsh Elementary School   Regular School No Elementary PK 06 2021   grade_6 10 0 2   0 0     0   1   5 8                       13 10 0 2   0 0     0   1   5 8                 13
1740608 CO     school 806990 260   Vilas RE-5 80699001206 9090 Vilas Elementary School   Regular School No Elementary PK 06 2021   grade_6 9 1 5   0 0     0   0   8 7                       15 9 1 5   0 0     0   0   8 7                 15
1740648 CO     school 805250 290   Las Animas RE-1 80525000866 1812 Las Animas Elementary School   Regular School No Elementary KG 06 2021   grade_6 16 0 19   1 0     0   1   17 20                       37 16 0 19   1 0     0   1   17 20                 37
1740674 CO     school 805580 310   McClave Re-2 80558000962 5666 McClave Elementary School   Regular School No Elementary PK 06 2021   grade_6 24 0 0   0 0     0   0   16 8                       24 24 0 0   0 0     0   0   16 8                 24
1740705 CO     school 805370 470   St Vrain Valley RE1J 80537006530 71 Aspen Ridge Preparatory School   Regular School Yes Elementary KG 08 2021   grade_6 52 0 6   0 4     0   2   37 27                       64 52 0 6   0 4     0   2   37 27                 64
1740764 CO     school 805370 470   St Vrain Valley RE1J 80537001887 1284 Carbon Valley Academy   Regular School Yes Elementary PK 08 2021   grade_6 6 0 7   0 0     1   0   11 3                       14 6 0 7   0 0     1   0   11 3                 14
1740823 CO     school 805370 470   St Vrain Valley RE1J 80537001890 2964 Flagstaff Charter Academy   Regular School Yes Elementary PK 08 2021   grade_6 72 0 17   0 6     0   3   48 50                       98 72 0 17   0 6     0   3   48 50                 98
1740835 CO     school 805370 470   St Vrain Valley RE1J 80537000901 3192 Thunder Valley PK-8   Regular School No Elementary PK 08 2021   grade_6 38 0 56   0 3     1   3   57 44                       101 38 0 56   0 3     1   3   57 44                 101
1740878 CO     school 805370 470   St Vrain Valley RE1J 80537006388 4333 Firestone Charter Academy   Regular School Yes Elementary PK 08 2021   grade_6 38 0 7   0 2     0   2   20 29                       49 38 0 7   0 2     0   2   20 29                 49
1740952 CO     school 805370 470   St Vrain Valley RE1J 80537006594 6010 Timberline PK-8   Regular School No Elementary PK 08 2021   grade_6 13 0 81   2 1     0   2   51 48                       99 13 0 81   2 1     0   2   51 48                 99
1741012 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2021   grade_6 11 0 1   0 0     0   0   8 4                       12 11 0 1   0 0     0   0   8 4                 12
1741046 CO     school 805370 470   St Vrain Valley RE1J 80537006739 8055 Soaring Heights PK-8   Regular School No Elementary PK 08 2021   grade_6 114 1 22   1 5     0   10   73 80                       153 114 1 22   1 5     0   10   73 80                 153
1741083 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2021   grade_6 82 2 17   0 11     0   6   59 59                       118 82 2 17   0 11     0   6   59 59                 118
1741211 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2021   grade_6 92 1 9   1 6     0   11   61 59                       120 92 1 9   1 6     0   11   61 59                 120
1741222 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2021   grade_6 51 0 8   0 3     0   4   37 29                       66 51 0 8   0 3     0   4   37 29                 66
1741358 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2021   grade_6 84 1 6   0 10     1   5   52 55                       107 84 1 6   0 10     1   5   52 55                 107
1741394 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_6 35 0 1   0 0     0   3   20 19                       39 35 0 1   0 0     0   3   20 19                 39
1741539 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_6 12 0 1   0 0     0   0   7 6                       13 12 0 1   0 0     0   0   7 6                 13
1741558 CO     school 803000 540   Clear Creek RE-1 80300001999 3385 Georgetown Community School   Regular School Yes Elementary PK 06 2021   grade_6 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
1741567 CO     school 803000 540   Clear Creek RE-1 80300000218 4212 Carlson Elementary School   Regular School No Elementary PK 06 2021   grade_6 17 0 1   1 1     0   2   10 12                       22 17 0 1   1 1     0   2   10 12                 22
1741581 CO     school 803000 540   Clear Creek RE-1 80300001332 4700 King-Murphy Elementary School   Regular School No Elementary PK 06 2021   grade_6 4 0 2   0 0     0   1   2 5                       7 4 0 2   0 0     0   1   2 5                 7
1741623 CO     school 806390 560   Sanford 6J 80639001113 7612 Sanford Elementary School   Regular School No Elementary PK 06 2021   grade_6 16 0 14   0 0     0   0   18 12                       30 16 0 14   0 0     0   0   18 12                 30
1741639 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2021   grade_6 0 0 9   0 0     0   0   6 3                       9 0 0 9   0 0     0   0   6 3                 9
1741686 CO     school 803210 770   Crowley County RE-1-J 80321001519 2054 Crowley County Elementary K-6   Regular School No Elementary KG 06 2021   grade_6 7 1 23   0 0     0   0   10 21                       31 7 1 23   0 0     0   0   10 21                 31
1741729 CO     school 803330 870   Delta County 50(J) 80333000295 1952 North Fork Montessori @ Crawford   Regular School No Elementary PK 06 2021   grade_6 9 0 4   0 0     0   1   6 8                       14 9 0 4   0 0     0   1   6 8                 14
1741778 CO     school 803330 870   Delta County 50(J) 80333000299 4124 Hotchkiss Elementary School   Regular School No Elementary PK 08 2021   grade_6 18 0 5   1 0     0   0   14 10                       24 18 0 5   1 0     0   0   14 10                 24
1741809 CO     school 803330 870   Delta County 50(J) 80333006667 6295 North Fork School of Integrated Studies   Regular School No Elementary KG 06 2021   grade_6 5 0 0   1 0     0   0   4 2                       6 5 0 0   1 0     0   0   4 2                 6
1741817 CO     school 803330 870   Delta County 50(J) 80333001337 6700 Paonia Elementary School   Regular School No Elementary PK 06 2021   grade_6 20 1 4   0 0     0   1   9 17                       26 20 1 4   0 0     0   1   9 17                 26
1741935 CO     school 803360 880   Denver County 1 80336000320 1106 Bryant Webster Dual Language ECE-8 School   Regular School No Elementary PK 08 2021   grade_6 1 0 54   0 0     0   1   31 25                       56 1 0 54   0 0     0   1   31 25                 56
1742080 CO     school 803360 880   Denver County 1 80336006453 2125 Denver Green School Southeast   Regular School No Elementary KG 08 2021   grade_6 18 14 24   0 5     0   5   34 32                       66 18 14 24   0 5     0   5   34 32                 66
1742090 CO     school 803360 880   Denver County 1 80336006482 2127 Denver Language School   Regular School Yes Elementary KG 08 2021   grade_6 32 5 13   0 2     0   6   25 33                       58 32 5 13   0 2     0   6   25 33                 58
1742120 CO     school 803360 880   Denver County 1 80336001522 2174 Denison Montessori School   Regular School No Elementary PK 06 2021   grade_6 3 1 18   2 3     0   0   17 10                       27 3 1 18   2 3     0   0   17 10                 27
1742314 CO     school 803360 880   Denver County 1 80336000351 3296 Garden Place Academy   Regular School No Elementary PK 06 2021   grade_6 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1742359 CO     school 803360 880   Denver County 1 80336001738 3605 Grant Ranch ECE-8 School   Regular School No Elementary PK 08 2021   grade_6 12 0 25   0 3     0   2   24 18                       42 12 0 25   0 3     0   2   24 18                 42
1742382 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2021   grade_6 3 7 65   2 2     0   0   38 41                       79 3 7 65   2 2     0   0   38 41                 79
1742432 CO     school 803360 880   Denver County 1 80336001835 3987 Highline Academy Southeast   Regular School Yes Elementary KG 08 2021   grade_6 28 14 20   0 1     0   3   34 32                       66 28 14 20   0 1     0   3   34 32                 66
1742470 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2021   grade_6 0 12 66   0 0     2   0   42 38                       80 0 12 66   0 0     2   0   42 38                 80
1742606 CO     school 803360 880   Denver County 1 80336000375 5158 Lincoln Elementary School   Regular School No Elementary PK 06 2021   grade_6 6 0 3   0 0     0   1   8 2                       10 6 0 3   0 0     0   1   8 2                 10
1742670 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2021   grade_6 0 5 59   0 0     4   0   39 29                       68 0 5 59   0 0     4   0   39 29                 68
1742722 CO     school 803360 880   Denver County 1 80336000385 6088 Dora Moore ECE-8 School   Regular School No Elementary PK 08 2021   grade_6 4 8 14   1 0     0   1   19 9                       28 4 8 14   1 0     0   1   19 9                 28
1742784 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2021   grade_6 5 0 20   0 0     0   1   16 10                       26 5 0 20   0 0     0   1   16 10                 26
1742793 CO     school 803360 880   Denver County 1 80336001636 6479 Odyssey School of Denver   Regular School Yes Elementary KG 08 2021   grade_6 10 4 8   0 2     0   2   13 13                       26 10 4 8   0 2     0   2   13 13                 26
1742803 CO     school 803360 880   Denver County 1 80336001838 6508 Omar D Blair Charter School   Regular School Yes Elementary KG 08 2021   grade_6 1 48 33   0 8     3   8   54 47                       101 1 48 33   0 8     3   8   54 47                 101
1742841 CO     school 803360 880   Denver County 1 80336001933 6970 Florida Pitt-Waller ECE-8 School   Regular School No Elementary PK 08 2021   grade_6 5 28 45   1 5     3   7   40 54                       94 5 28 45   1 5     3   7   40 54                 94
1742852 CO     school 803360 880   Denver County 1 80336006398 7045 Place Bridge Academy   Regular School No Elementary PK 08 2021   grade_6 12 37 37   1 16     0   2   55 50                       105 12 37 37   1 16     0   2   55 50                 105
1742949 CO     school 803360 880   Denver County 1 80336001524 7972 Slavens K-8 School   Regular School No Elementary KG 08 2021   grade_6 71 2 6   0 1     0   8   44 44                       88 71 2 6   0 1     0   8   44 44                 88
1743147 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2021   grade_6 0 13 8   0 0     0   1   10 12                       22 0 13 8   0 0     0   1   10 12                 22
1743158 CO     school 803360 880   Denver County 1 80336006332 9623 William (Bill) Roberts ECE-8 School   Regular School No Elementary PK 08 2021   grade_6 55 4 16   0 2     0   3   42 38                       80 55 4 16   0 2     0   3   42 38                 80
1743223 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_6 66 0 11   0 2     0   4   33 50                       83 66 0 11   0 2     0   4   33 50                 83
1743233 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_6 23 0 16   0 5     0   6   23 27                       50 23 0 16   0 5     0   6   23 27                 50

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