Data source: Big Local News · About: Big Local

690 rows where grade = "grade_6", state = "CO" and year = 2020 sorted by ccd_school_lvl

View and edit SQL

year

  • 2020 · 690

grade

  • grade_6 · 690
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
1801021 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_6 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1799335 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_6 6 0 52   0 1     0   1   20 40                       60 6 0 52   0 1     0   1   20 40                 60
1799345 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_6 7 2 46   0 3     0   2   24 36                       60 7 2 46   0 3     0   2   24 36                 60
1799370 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_6 4 0 22   1 1     0   0   11 17                       28 4 0 22   1 1     0   0   11 17                 28
1799379 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_6 1 2 47   0 2     0   3   26 29                       55 1 2 47   0 2     0   3   26 29                 55
1799390 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   grade_6 16 1 39   2 1     1   0   28 32                       60 16 1 39   2 1     1   0   28 32                 60
1799399 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_6 4 0 52   1 1     0   1   29 30                       59 4 0 52   1 1     0   1   29 30                 59
1799408 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_6 8 3 44   0 1     0   0   30 26                       56 8 3 44   0 1     0   0   30 26                 56
1799451 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_6 10 0 48   0 0     0   1   27 32                       59 10 0 48   0 0     0   1   27 32                 59
1799622 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_6 48 1 8   1 10     1   8   30 47                       77 48 1 8   1 10     1   8   30 47                 77
1799769 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_6 59 1 17   0 1     0   6   50 34                       84 59 1 17   0 1     0   6   50 34                 84
1799780 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_6 11 0 90   0 1     0   2   54 50                       104 11 0 90   0 1     0   2   54 50                 104
1799797 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_6 62 0 7   0 4     0   3   35 41                       76 62 0 7   0 4     0   3   35 41                 76
1799924 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2020   grade_6 25 0 49   0 0     0   3   41 36                       77 25 0 49   0 0     0   3   41 36                 77
1799954 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2020   grade_6 92 1 44   0 2     0   1   70 70                       140 92 1 44   0 2     0   1   70 70                 140
1799969 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2020   grade_6 55 0 33   0 0     0   2   46 44                       90 55 0 33   0 0     0   2   46 44                 90
1799987 CO     school 802580 40   School District 27J 80258006325 4950 Landmark Academy at Reunion   Regular School Yes Elementary KG 08 2020   grade_6 52 2 30   1 2     0   2   36 53                       89 52 2 30   1 2     0   2   36 53                 89
1800150 CO     school 807230 70   Westminster Public Schools 80723001232 1622 Metropolitan Arts Academy   Regular School No Elementary PK 06 2020   grade_6 5 1 36   1 1     0   0   23 21                       44 5 1 36   1 1     0   0   23 21                 44
1800190 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2020   grade_6 21 1 46   1 5     0   2   39 37                       76 21 1 46   1 5     0   2   39 37                 76
1800201 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 06 2020   grade_6 12 1 60   0 0     1   1   37 38                       75 12 1 60   0 0     1   1   37 38                 75
1800226 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 06 2020   grade_6 5 0 18   0 0     0   1   14 10                       24 5 0 18   0 0     0   1   14 10                 24
1800271 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_6 2 0 30   0 0     0   0   15 17                       32 2 0 30   0 0     0   0   15 17                 32
1800334 CO     school 803780 120   Englewood 1 80378000486 1514 Charles Hay World School   Regular School No Elementary KG 06 2020   grade_6 15 2 6   0 0     0   2   15 10                       25 15 2 6   0 0     0   2   15 10                 25
1800342 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2020   grade_6 14 0 14   0 0     0   2   11 19                       30 14 0 14   0 0     0   2   11 19                 30
1800350 CO     school 803780 120   Englewood 1 80378000489 1652 Clayton Elementary School   Regular School No Elementary KG 06 2020   grade_6 17 2 30   0 1     0   3   28 25                       53 17 2 30   0 1     0   3   28 25                 53
1800372 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_6 4 0 16   0 0     0   1   10 11                       21 4 0 16   0 0     0   1   10 11                 21
1800487 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2020   grade_6 27 14 7   1 17     0   8   37 37                       74 27 14 7   1 17     0   8   37 37                 74
1800515 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2020   grade_6 25 3 6   0 16     0   2   27 25                       52 25 3 6   0 16     0   2   27 25                 52
1800645 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2020   grade_6 10 2 5   0 4     0   1   9 13                       22 10 2 5   0 4     0   1   9 13                 22
1800922 CO     school 805310 140   Littleton 6 80531001515 5229 Littleton Academy   Regular School Yes Elementary KG 08 2020   grade_6 35 1 2   0 6     0   5   23 26                       49 35 1 2   0 6     0   5   23 26                 49
1800932 CO     school 805310 140   Littleton 6 80531001626 5233 Littleton Prep Charter School   Regular School Yes Elementary PK 08 2020   grade_6 40 0 14   0 1     0   1   32 24                       56 40 0 14   0 1     0   1   32 24                 56
1801027 CO     school 802340 180   Adams-Arapahoe 28J 80234006771 122 Aurora Community School   Regular School Yes Elementary KG 06 2020   grade_6 4 13 20   0 0     0   2   22 17                       39 4 13 20   0 0     0   2   22 17                 39
1801035 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_6 5 20 65   0 1     0   6   50 47                       97 5 20 65   0 1     0   6   50 47                 97
1801049 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_6 9 19 21   0 0     1   4   32 22                       54 9 19 21   0 0     1   4   32 22                 54
1801076 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_6 11 22 26   0 1     0   4   36 28                       64 11 22 26   0 1     0   4   36 28                 64
1801090 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2020   grade_6 37 7 40   1 12     0   3   53 47                       100 37 7 40   1 12     0   3   53 47                 100
1801101 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2020   grade_6 1 8 31   0 2     0   1   20 23                       43 1 8 31   0 2     0   1   20 23                 43
1801125 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2020   grade_6 5 2 43   0 2     1   1   26 28                       54 5 2 43   0 2     1   1   26 28                 54
1801178 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2020   grade_6 11 17 63   1 0     4   7   57 46                       103 11 17 63   1 0     4   7   57 46                 103
1801204 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_6 2 28 59   0 2     0   5   46 50                       96 2 28 59   0 2     0   5   46 50                 96
1801297 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2020   grade_6 26 10 17   1 6     0   8   36 32                       68 26 10 17   1 6     0   8   36 32                 68
1801350 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_6 37 8 25   0 13     0   10   52 41                       93 37 8 25   0 13     0   10   52 41                 93
1801411 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 07 2020   grade_6 2 5 23   1 5     0   1   21 16                       37 2 5 23   1 5     0   1   21 16                 37
1801420 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_6 5 14 26   0 0     0   2   16 31                       47 5 14 26   0 0     0   2   16 31                 47
1801446 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_6 38 21 69   2 2     0   12   61 83                       144 38 21 69   2 2     0   12   61 83                 144
1801508 CO     school 802700 190   Byers 32J 80270000163 1168 Byers Elementary School   Regular School No Elementary PK 06 2020   grade_6 32 1 10   1 0     0   0   20 24                       44 32 1 10   1 0     0   0   20 24                 44
1801543 CO     school 802700 190   Byers 32J 80270006630 6241 Colorado Virtual Academy   Regular School Yes Elementary KG 06 2020   grade_6 40 5 11   2 3     0   0   29 32                       61 40 5 11   2 3     0   0   29 32                 61
1801582 CO     school 802190 220   Archuleta County 50 Jt 80219006717 6679 Pagosa Peak Open School   Regular School Yes Elementary KG 06 2020   grade_6 8 0 6   1 0     0   0   7 8                       15 8 0 6   1 0     0   0   7 8                 15
1801590 CO     school 807110 230   Walsh RE-1 80711001215 9222 Walsh Elementary School   Regular School No Elementary PK 06 2020   grade_6 10 0 2   0 0     0   1   5 8                       13 10 0 2   0 0     0   1   5 8                 13
1801639 CO     school 806990 260   Vilas RE-5 80699001206 9090 Vilas Elementary School   Regular School No Elementary PK 06 2020   grade_6 5 0 7   0 0     0   0   5 7                       12 5 0 7   0 0     0   0   5 7                 12
1801678 CO     school 805250 290   Las Animas RE-1 80525000866 1812 Las Animas Elementary School   Regular School No Elementary KG 06 2020   grade_6 17 0 12   0 0     0   1   18 12                       30 17 0 12   0 0     0   1   18 12                 30
1801704 CO     school 805580 310   McClave Re-2 80558000962 5666 McClave Elementary School   Regular School No Elementary PK 06 2020   grade_6 28 0 0   0 0     0   0   13 15                       28 28 0 0   0 0     0   0   13 15                 28
1801735 CO     school 805370 470   St Vrain Valley RE1J 80537006530 71 Aspen Ridge Preparatory School   Regular School Yes Elementary KG 08 2020   grade_6 33 1 5   0 3     0   2   24 20                       44 33 1 5   0 3     0   2   24 20                 44
1801795 CO     school 805370 470   St Vrain Valley RE1J 80537001887 1284 Carbon Valley Academy   Regular School Yes Elementary PK 08 2020   grade_6 8 0 5   0 0     0   1   9 5                       14 8 0 5   0 0     0   1   9 5                 14
1801855 CO     school 805370 470   St Vrain Valley RE1J 80537001890 2964 Flagstaff Charter Academy   Regular School Yes Elementary PK 08 2020   grade_6 79 2 13   1 4     1   1   50 51                       101 79 2 13   1 4     1   1   50 51                 101
1801867 CO     school 805370 470   St Vrain Valley RE1J 80537000901 3192 Thunder Valley PK-8   Regular School No Elementary PK 08 2020   grade_6 41 0 58   0 1     0   3   50 53                       103 41 0 58   0 1     0   3   50 53                 103
1801910 CO     school 805370 470   St Vrain Valley RE1J 80537006388 4333 Imagine Charter   Regular School Yes Elementary PK 08 2020   grade_6 40 0 15   0 3     0   1   28 31                       59 40 0 15   0 3     0   1   28 31                 59
1801984 CO     school 805370 470   St Vrain Valley RE1J 80537006594 6010 Timberline PK-8   Regular School No Elementary PK 08 2020   grade_6 10 0 93   2 0     0   2   59 48                       107 10 0 93   2 0     0   2   59 48                 107
1802044 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2020   grade_6 21 2 1   0 1     0   0   13 12                       25 21 2 1   0 1     0   0   13 12                 25
1802079 CO     school 805370 470   St Vrain Valley RE1J 80537006739 8055 Soaring Heights PK-8   Regular School No Elementary PK 08 2020   grade_6 127 0 25   0 2     0   5   88 71                       159 127 0 25   0 2     0   5   88 71                 159
1802117 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2020   grade_6 94 4 21   1 4     1   4   61 68                       129 94 4 21   1 4     1   4   61 68                 129
1802240 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2020   grade_6 117 0 11   0 4     1   12   84 61                       145 117 0 11   0 4     1   12   84 61                 145
1802251 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2020   grade_6 47 0 6   0 5     0   4   34 28                       62 47 0 6   0 5     0   4   34 28                 62
1802386 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_6 79 1 18   0 19     0   6   63 60                       123 79 1 18   0 19     0   6   63 60                 123
1802422 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2020   grade_6 28 0 4   0 0     0   4   18 18                       36 28 0 4   0 0     0   4   18 18                 36
1802567 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2020   grade_6 13 1 1   0 0     0   0   7 8                       15 13 1 1   0 0     0   0   7 8                 15
1802586 CO     school 803000 540   Clear Creek RE-1 80300001999 3385 Georgetown Community School   Regular School Yes Elementary PK 06 2020   grade_6 7 0 3   0 0     0   0   8 2                       10 7 0 3   0 0     0   0   8 2                 10
1802595 CO     school 803000 540   Clear Creek RE-1 80300000218 4212 Carlson Elementary School   Regular School No Elementary PK 06 2020   grade_6 24 0 6   1 0     0   1   13 19                       32 24 0 6   1 0     0   1   13 19                 32
1802609 CO     school 803000 540   Clear Creek RE-1 80300001332 4700 King-Murphy Elementary School   Regular School No Elementary PK 06 2020   grade_6 13 0 0   0 1     0   0   7 7                       14 13 0 0   0 1     0   0   7 7                 14
1802649 CO     school 806390 560   Sanford 6J 80639001113 7612 Sanford Elementary School   Regular School No Elementary PK 06 2020   grade_6 18 0 7   0 0     0   1   14 12                       26 18 0 7   0 0     0   1   14 12                 26
1802665 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2020   grade_6 2 0 8   0 0     0   0   7 3                       10 2 0 8   0 0     0   0   7 3                 10
1802712 CO     school 803210 770   Crowley County RE-1-J 80321001519 2054 Crowley County Elementary K-6   Regular School No Elementary KG 06 2020   grade_6 8 3 31   0 0     0   0   22 20                       42 8 3 31   0 0     0   0   22 20                 42
1802755 CO     school 803330 870   Delta County 50(J) 80333000295 1952 North Fork Montessori @ Crawford   Regular School No Elementary PK 06 2020   grade_6 15 0 1   0 0     0   0   10 6                       16 15 0 1   0 0     0   0   10 6                 16
1802805 CO     school 803330 870   Delta County 50(J) 80333000299 4124 Hotchkiss Elementary School   Regular School No Elementary PK 08 2020   grade_6 29 0 10   0 0     0   2   19 22                       41 29 0 10   0 0     0   2   19 22                 41
1802836 CO     school 803330 870   Delta County 50(J) 80333006667 6295 North Fork School of Integrated Studies   Regular School No Elementary KG 06 2020   grade_6 3 0 5   0 0     0   1   6 3                       9 3 0 5   0 0     0   1   6 3                 9
1802844 CO     school 803330 870   Delta County 50(J) 80333001337 6700 Paonia Elementary School   Regular School No Elementary PK 06 2020   grade_6 20 0 3   0 0     0   2   13 12                       25 20 0 3   0 0     0   2   13 12                 25
1802959 CO     school 803360 880   Denver County 1 80336000320 1106 Bryant Webster Dual Language ECE-8 School   Regular School No Elementary PK 08 2020   grade_6 1 0 56   0 0     0   1   31 27                       58 1 0 56   0 0     0   1   31 27                 58
1803103 CO     school 803360 880   Denver County 1 80336006453 2125 Denver Green School Southeast   Regular School No Elementary PK 08 2020   grade_6 29 15 20   0 0     1   5   37 33                       70 29 15 20   0 0     1   5   37 33                 70
1803114 CO     school 803360 880   Denver County 1 80336006482 2127 Denver Language School   Regular School Yes Elementary KG 08 2020   grade_6 43 4 25   0 4     0   12   42 46                       88 43 4 25   0 4     0   12   42 46                 88
1803144 CO     school 803360 880   Denver County 1 80336001522 2174 Denison Montessori School   Regular School No Elementary PK 06 2020   grade_6 8 0 22   0 1     0   0   18 13                       31 8 0 22   0 1     0   0   18 13                 31
1803335 CO     school 803360 880   Denver County 1 80336000351 3296 Garden Place Academy   Regular School No Elementary PK 06 2020   grade_6 0 1 4   0 0     0   0   4 1                       5 0 1 4   0 0     0   0   4 1                 5
1803380 CO     school 803360 880   Denver County 1 80336001738 3605 Grant Ranch ECE-8 School   Regular School No Elementary PK 08 2020   grade_6 15 0 40   0 2     0   2   36 23                       59 15 0 40   0 2     0   2   36 23                 59
1803403 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2020   grade_6 1 9 56   0 0     0   1   35 32                       67 1 9 56   0 0     0   1   35 32                 67
1803453 CO     school 803360 880   Denver County 1 80336001835 3987 Highline Academy Southeast   Regular School Yes Elementary KG 08 2020   grade_6 26 23 17   0 7     0   2   37 38                       75 26 23 17   0 7     0   2   37 38                 75
1803491 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2020   grade_6 1 16 72   0 0     0   0   40 49                       89 1 16 72   0 0     0   0   40 49                 89
1803625 CO     school 803360 880   Denver County 1 80336000375 5158 Lincoln Elementary School   Regular School No Elementary PK 06 2020   grade_6 2 1 1   0 0     0   0   2 2                       4 2 1 1   0 0     0   0   2 2                 4
1803689 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_6 2 10 52   0 0     6   1   34 37                       71 2 10 52   0 0     6   1   34 37                 71
1803741 CO     school 803360 880   Denver County 1 80336000385 6088 Dora Moore ECE-8 School   Regular School No Elementary PK 08 2020   grade_6 7 3 19   1 1     0   1   17 15                       32 7 3 19   1 1     0   1   17 15                 32
1803803 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   grade_6 4 0 18   0 0     0   0   12 10                       22 4 0 18   0 0     0   0   12 10                 22
1803812 CO     school 803360 880   Denver County 1 80336001636 6479 Odyssey School of Denver   Regular School Yes Elementary KG 08 2020   grade_6 10 4 8   0 0     0   3   13 12                       25 10 4 8   0 0     0   3   13 12                 25
1803822 CO     school 803360 880   Denver County 1 80336001838 6508 Omar D Blair Charter School   Regular School Yes Elementary KG 08 2020   grade_6 7 28 34   1 6     2   4   40 42                       82 7 28 34   1 6     2   4   40 42                 82
1803860 CO     school 803360 880   Denver County 1 80336001933 6970 Florida Pitt-Waller ECE-8 School   Regular School No Elementary PK 08 2020   grade_6 7 23 61   1 3     4   0   46 53                       99 7 23 61   1 3     4   0   46 53                 99
1803871 CO     school 803360 880   Denver County 1 80336006398 7045 Place Bridge Academy   Regular School No Elementary PK 08 2020   grade_6 16 37 43   0 23     0   2   61 60                       121 16 37 43   0 23     0   2   61 60                 121
1803968 CO     school 803360 880   Denver County 1 80336001524 7972 Slavens K-8 School   Regular School No Elementary KG 08 2020   grade_6 72 2 4   0 1     1   6   43 43                       86 72 2 4   0 1     1   6   43 43                 86
1804177 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2020   grade_6 2 6 12   0 0     0   2   14 8                       22 2 6 12   0 0     0   2   14 8                 22
1804188 CO     school 803360 880   Denver County 1 80336006332 9623 William (Bill) Roberts ECE-8 School   Regular School No Elementary PK 08 2020   grade_6 58 10 5   0 1     0   6   33 47                       80 58 10 5   0 1     0   6   33 47                 80
1804251 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_6 81 2 11   0 3     0   2   42 57                       99 81 2 11   0 3     0   2   42 57                 99
1804262 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2020   grade_6 35 0 19   0 11     0   5   30 40                       70 35 0 19   0 11     0   5   30 40                 70
1804284 CO     school 803450 900   Douglas County Re 1 80345006492 135 Ben Franklin Academy   Regular School Yes Elementary PK 08 2020   grade_6 85 1 12   1 1     0   4   55 49                       104 85 1 12   1 1     0   4   55 49                 104
1804299 CO     school 803450 900   Douglas County Re 1 80345001896 215 American Academy   Regular School Yes Elementary PK 08 2020   grade_6 186 1 21   1 33     0   17   137 122                       259 186 1 21   1 33     0   17   137 122                 259

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