Data source: Big Local News · About: Big Local

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

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
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
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
1800105 CO     school 802430 50   Bennett 29J 80243006789 562 Bennett Intermediate School   Regular School No Middle 04 06 2020   grade_6 59 0 31   0 0     0   3   47 46                       93 59 0 31   0 0     0   3   47 46                 93
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
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
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
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
1801040 CO     school 802340 180   Adams-Arapahoe 28J 80234006787 127 Aurora Science & Tech Middle School   Regular School Yes Middle 06 06 2020   grade_6 17 21 110   0 4     2   12   93 73                       166 17 21 110   0 4     2   12   93 73                 166
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
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
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
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
1803153 CO     school 803360 880   Denver County 1 80336006790 2176 Denver Green School Northfield   Regular School No Middle 06 06 2020   grade_6 55 30 34   0 3     0   16   77 61                       138 55 30 34   0 3     0   16   77 61                 138
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
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
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
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
1804314 CO     school 803450 900   Douglas County Re 1 80345006392 265 Clear Sky Elementary   Regular School No Elementary PK 06 2020   grade_6 84 1 18   0 4     0   8   55 60                       115 84 1 18   0 4     0   8   55 60                 115
1804335 CO     school 803450 900   Douglas County Re 1 80345001757 354 Arrowwood Elementary School   Regular School No Elementary PK 06 2020   grade_6 36 0 11   0 2     0   1   23 27                       50 36 0 11   0 2     0   1   23 27                 50
1804344 CO     school 803450 900   Douglas County Re 1 80345006159 651 Bear Canyon Elementary School   Regular School No Elementary PK 06 2020   grade_6 58 2 8   0 1     0   4   29 44                       73 58 2 8   0 1     0   4   29 44                 73
1804364 CO     school 803450 900   Douglas County Re 1 80345000437 1362 Castle Rock Elementary School   Regular School No Elementary PK 06 2020   grade_6 36 0 6   2 2     0   4   27 23                       50 36 0 6   2 2     0   4   27 23                 50
1804410 CO     school 803450 900   Douglas County Re 1 80345000439 1578 Cherry Valley Elementary School   Regular School No Elementary KG 06 2020   grade_6 8 0 0   0 0     0   0   4 4                       8 8 0 0   0 0     0   0   4 4                 8
1804439 CO     school 803450 900   Douglas County Re 1 80345001897 1899 Copper Mesa Elementary School   Regular School No Elementary PK 06 2020   grade_6 60 1 10   0 5     0   10   44 42                       86 60 1 10   0 5     0   10   44 42                 86
1804448 CO     school 803450 900   Douglas County Re 1 80345001526 1925 Cougar Run Elementary School   Regular School No Elementary KG 06 2020   grade_6 45 2 7   1 0     0   2   24 33                       57 45 2 7   1 0     0   2   24 33                 57
1804457 CO     school 803450 900   Douglas County Re 1 80345001250 1934 Coyote Creek Elementary School   Regular School No Elementary PK 06 2020   grade_6 49 2 11   1 1     0   3   33 34                       67 49 2 11   1 1     0   3   33 34                 67
1804477 CO     school 803450 900   Douglas County Re 1 80345001475 2232 Rock Ridge Elementary School   Regular School No Elementary PK 06 2020   grade_6 46 3 17   0 0     0   7   41 32                       73 46 3 17   0 0     0   7   41 32                 73
1804486 CO     school 803450 900   Douglas County Re 1 80345001497 2233 Cherokee Trail Elementary School   Regular School No Elementary PK 06 2020   grade_6 48 0 15   1 1     0   5   38 32                       70 48 0 15   1 1     0   5   38 32                 70
1804496 CO     school 803450 900   Douglas County Re 1 80345001476 2234 Eagle Ridge Elementary School   Regular School No Elementary PK 06 2020   grade_6 53 4 14   0 6     0   4   43 38                       81 53 4 14   0 6     0   4   43 38                 81
1804509 CO     school 803450 900   Douglas County Re 1 80345001736 2656 Eldorado Elementary School   Regular School No Elementary PK 06 2020   grade_6 35 1 4   0 3     0   2   23 22                       45 35 1 4   0 3     0   2   23 22                 45
1804518 CO     school 803450 900   Douglas County Re 1 80345006337 2952 Mammoth Heights Elementary   Regular School No Elementary PK 06 2020   grade_6 58 3 12   0 0     0   3   32 44                       76 58 3 12   0 0     0   3   32 44                 76
1804527 CO     school 803450 900   Douglas County Re 1 80345006309 2953 Stone Mountain Elementary   Regular School No Elementary PK 06 2020   grade_6 88 0 5   0 2     0   7   52 50                       102 88 0 5   0 2     0   7   52 50                 102
1804534 CO     school 803450 900   Douglas County Re 1 80345006299 2954 Roxborough Intermediate   Regular School No Elementary 03 06 2020   grade_6 84 0 14   2 0     0   2   53 49                       102 84 0 14   2 0     0   2   53 49                 102
1804541 CO     school 803450 900   Douglas County Re 1 80345001959 2965 Flagstone Elementary School   Regular School No Elementary PK 06 2020   grade_6 60 1 6   0 1     1   1   42 28                       70 60 1 6   0 1     1   1   42 28                 70
1804551 CO     school 803450 900   Douglas County Re 1 80345001275 3138 Fox Creek Elementary School   Regular School No Elementary PK 06 2020   grade_6 66 1 6   0 2     0   2   41 36                       77 66 1 6   0 2     0   2   41 36                 77
1804579 CO     school 803450 900   Douglas County Re 1 80345006656 3327 Global Village Academy - Douglas County   Regular School Yes Elementary PK 06 2020   grade_6 8 0 4   0 1     0   1   6 8                       14 8 0 4   0 1     0   1   6 8                 14
1804598 CO     school 803450 900   Douglas County Re 1 80345001740 3928 Heritage Elementary School   Regular School No Elementary PK 06 2020   grade_6 57 1 11   0 4     0   3   35 41                       76 57 1 11   0 4     0   3   35 41                 76
1804631 CO     school 803450 900   Douglas County Re 1 80345000441 4980 Larkspur Elementary School   Regular School No Elementary KG 06 2020   grade_6 28 0 1   0 1     0   3   14 19                       33 28 0 1   0 1     0   3   14 19                 33
1804678 CO     school 803450 900   Douglas County Re 1 80345006472 5607 Sage Canyon Elementary   Regular School No Elementary PK 06 2020   grade_6 88 1 8   0 0     0   6   64 39                       103 88 1 8   0 0     0   6   64 39                 103
1804687 CO     school 803450 900   Douglas County Re 1 80345001785 5745 Meadow View Elementary School   Regular School No Elementary PK 06 2020   grade_6 59 2 14   0 2     0   6   46 37                       83 59 2 14   0 2     0   6   46 37                 83
1804697 CO     school 803450 900   Douglas County Re 1 80345006341 5843 Lone Tree Elementary   Regular School No Elementary PK 06 2020   grade_6 43 3 5   0 1     0   1   25 28                       53 43 3 5   0 1     0   1   25 28                 53
1804759 CO     school 803450 900   Douglas County Re 1 80345001339 6406 Northridge Elementary School   Regular School No Elementary PK 06 2020   grade_6 68 0 9   0 5     0   4   53 33                       86 68 0 9   0 5     0   4   53 33                 86
1804784 CO     school 803450 900   Douglas County Re 1 80345001279 6938 Pine Grove Elementary School   Regular School No Elementary PK 06 2020   grade_6 51 5 5   1 2     0   5   29 40                       69 51 5 5   1 2     0   5   29 40                 69
1804794 CO     school 803450 900   Douglas County Re 1 80345000444 6940 Pine Lane Elementary   Regular School No Elementary PK 06 2020   grade_6 73 2 17   0 3     0   4   52 47                       99 73 2 17   0 3     0   4   52 47                 99
1804834 CO     school 803450 900   Douglas County Re 1 80345001809 7134 Prairie Crossing Elementary School   Regular School No Elementary PK 06 2020   grade_6 56 1 12   1 5     0   5   49 31                       80 56 1 12   1 5     0   5   49 31                 80
1804862 CO     school 803450 900   Douglas County Re 1 80345001288 7319 Renaissance Expedition Learn Outward Bound School   Regular School No Elementary KG 06 2020   grade_6 47 1 7   0 0     0   6   36 25                       61 47 1 7   0 0     0   6   36 25                 61
1804879 CO     school 803450 900   Douglas County Re 1 80345001680 7562 Saddle Ranch Elementary School   Regular School No Elementary PK 06 2020   grade_6 54 0 8   0 2     0   4   31 37                       68 54 0 8   0 2     0   4   31 37                 68
1804889 CO     school 803450 900   Douglas County Re 1 80345001407 7610 Sand Creek Elementary School   Regular School No Elementary PK 06 2020   grade_6 34 1 11   1 0     0   4   26 25                       51 34 1 11   1 0     0   4   26 25                 51
1804899 CO     school 803450 900   Douglas County Re 1 80345000446 7718 Sedalia Elementary School   Regular School No Elementary PK 06 2020   grade_6 21 3 10   0 0     0   0   17 17                       34 21 3 10   0 0     0   0   17 17                 34
1804908 CO     school 803450 900   Douglas County Re 1 80345001840 8106 Soaring Hawk Elementary School   Regular School No Elementary PK 06 2020   grade_6 60 0 11   0 2     0   2   36 39                       75 60 0 11   0 2     0   2   36 39                 75
1804918 CO     school 803450 900   Douglas County Re 1 80345000447 8126 South Ridge Elementary An IB World School   Regular School No Elementary PK 06 2020   grade_6 55 2 25   0 1     0   6   44 45                       89 55 2 25   0 1     0   6   44 45                 89
1804928 CO     school 803450 900   Douglas County Re 1 80345000044 8382 Summit View Elementary School   Regular School No Elementary PK 06 2020   grade_6 65 0 6   0 4     0   9   47 37                       84 65 0 6   0 4     0   9   47 37                 84
1804950 CO     school 803450 900   Douglas County Re 1 80345001585 8897 Trailblazer Elementary School   Regular School No Elementary PK 06 2020   grade_6 52 1 5   0 3     0   1   28 34                       62 52 1 5   0 3     0   1   28 34                 62
1805357 CO     school 804530 980   Harrison 2 80453001533 7611 Sand Creek International Elementary School   Regular School No Elementary PK 06 2020   grade_6 9 10 32   0 0     0   5   23 33                       56 9 10 32   0 0     0   5   23 33                 56
1805732 CO     school 803060 1010   Colorado Springs 11 80306001318 3470 Globe Charter School   Regular School Yes Elementary KG 06 2020   grade_6 9 0 4   0 0     0   2   8 7                       15 9 0 4   0 0     0   2   8 7                 15
1805979 CO     school 802940 1020   Cheyenne Mountain 12 80294001326 1582 The Vanguard School (Elementary)   Regular School Yes Elementary KG 06 2020   grade_6 58 2 28   0 11     1   9   49 60                       109 58 2 28   0 11     1   9   49 60                 109
1805988 CO     school 802940 1020   Cheyenne Mountain 12 80294001391 1586 Cheyenne Mountain Elementary School   Regular School No Elementary KG 06 2020   grade_6 39 1 4   0 3     0   3   20 30                       50 39 1 4   0 3     0   3   20 30                 50
1806004 CO     school 802940 1020   Cheyenne Mountain 12 80294000212 1592 Broadmoor Elementary School   Regular School No Elementary KG 06 2020   grade_6 38 0 4   0 3     1   3   22 27                       49 38 0 4   0 3     1   3   22 27                 49
1806014 CO     school 802940 1020   Cheyenne Mountain 12 80294000210 1604 Skyway Park Elementary School   Regular School No Elementary KG 06 2020   grade_6 27 1 14   0 0     0   3   22 23                       45 27 1 14   0 0     0   3   22 23                 45
1806022 CO     school 802940 1020   Cheyenne Mountain 12 80294001591 3482 Gold Camp Elementary School   Regular School No Elementary KG 06 2020   grade_6 58 2 10   0 3     0   2   34 41                       75 58 2 10   0 3     0   2   34 41                 75
1806030 CO     school 802940 1020   Cheyenne Mountain 12 80294001535 6953 Pinon Valley Elementary School   Regular School No Elementary KG 06 2020   grade_6 36 0 4   0 4     0   3   27 20                       47 36 0 4   0 4     0   3   27 20                 47
1806063 CO     school 805490 1030   Manitou Springs 14 80549000948 9010 Ute Pass Elementary School   Regular School No Elementary PK 06 2020   grade_6 16 0 4   0 0     0   2   12 10                       22 16 0 4   0 0     0   2   12 10                 22
1806144 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_6 207 8 29   0 8     1   17   131 139                       270 207 8 29   0 8     1   17   131 139                 270
1806371 CO     school 806060 1060   Peyton 23 Jt 80606001024 6898 Peyton Elementary School   Regular School No Elementary PK 06 2020   grade_6 39 2 7   0 0     0   2   25 25                       50 39 2 7   0 0     0   2   25 25                 50
1806409 CO     school 805820 1080   Lewis-Palmer 38 80582001371 3539 Bear Creek Elementary School   Regular School No Elementary PK 06 2020   grade_6 130 6 16   1 2     0   11   98 68                       166 130 6 16   1 2     0   11   98 68                 166
1806419 CO     school 805820 1080   Lewis-Palmer 38 80582001489 4686 Ray E Kilmer Elementary School   Regular School No Elementary PK 06 2020   grade_6 47 0 8   0 1     0   2   36 22                       58 47 0 8   0 1     0   2   36 22                 58
1806441 CO     school 805820 1080   Lewis-Palmer 38 80582001004 5096 Lewis-Palmer Elementary School   Regular School No Elementary PK 06 2020   grade_6 62 0 4   0 1     0   2   37 32                       69 62 0 4   0 1     0   2   37 32                 69
1806464 CO     school 805820 1080   Lewis-Palmer 38 80582001397 6682 Palmer Lake Elementary School   Regular School No Elementary PK 06 2020   grade_6 45 0 6   0 2     0   5   37 21                       58 45 0 6   0 2     0   5   37 21                 58
1806474 CO     school 805820 1080   Lewis-Palmer 38 80582001810 7165 Prairie Winds Elementary School   Regular School No Elementary PK 06 2020   grade_6 43 0 10   0 1     0   3   25 32                       57 43 0 10   0 1     0   3   25 32                 57
1806824 CO     school 803960 1150   Fremont RE-2 80396000515 3224 Fremont Elementary School   Regular School No Elementary PK 06 2020   grade_6 61 2 12   0 0     0   4   45 34                       79 61 2 12   0 0     0   4   45 34                 79
1806833 CO     school 803960 1150   Fremont RE-2 80396000516 6858 Penrose Elementary School   Regular School No Elementary PK 06 2020   grade_6 31 0 7   0 0     0   3   23 18                       41 31 0 7   0 0     0   3   23 18                 41
1807382 CO     school 804800 1420   Jefferson County R-1 80480001649 1869 Compass Montessori - Wheat Ridge Charter School   Regular School Yes Elementary PK 06 2020   grade_6 19 0 6   0 0     0   4   14 15                       29 19 0 6   0 0     0   4   14 15                 29
1807474 CO     school 804800 1420   Jefferson County R-1 80480000716 2496 Edgewater Elementary School   Regular School No Elementary PK 06 2020   grade_6 5 1 57   1 0     0   1   36 29                       65 5 1 57   1 0     0   1   36 29                 65
1807647 CO     school 804800 1420   Jefferson County R-1 80480000975 4402 Jefferson Academy Elementary   Regular School Yes Elementary KG 06 2020   grade_6 89 1 13   0 5     0   4   50 62                       112 89 1 13   0 5     0   4   50 62                 112
1807742 CO     school 804800 1420   Jefferson County R-1 80480000748 5004 Lasley Elementary School   Regular School No Elementary KG 06 2020   grade_6 16 0 50   5 5     0   0   40 36                       76 16 0 50   5 5     0   0   40 36                 76
1807794 CO     school 804800 1420   Jefferson County R-1 80480000752 5354 Lumberg Elementary School   Regular School No Elementary PK 06 2020   grade_6 10 3 46   0 0     0   3   39 23                       62 10 3 46   0 0     0   3   39 23                 62
1807875 CO     school 804800 1420   Jefferson County R-1 80480000758 5972 Molholm Elementary School   Regular School No Elementary PK 06 2020   grade_6 5 2 36   1 2     0   1   27 20                       47 5 2 36   1 2     0   1   27 20                 47
1807949 CO     school 804800 1420   Jefferson County R-1 80480006256 6539 Jefferson County Open Elementary School   Regular School No Elementary PK 06 2020   grade_6 26 0 9   0 0     0   5   19 21                       40 26 0 9   0 0     0   5   19 21                 40
1807982 CO     school 804800 1420   Jefferson County R-1 80480000770 6808 Patterson International School   Regular School No Elementary PK 06 2020   grade_6 14 0 25   0 7     0   1   28 19                       47 14 0 25   0 7     0   1   28 19                 47
1808067 CO     school 804800 1420   Jefferson County R-1 80480006724 7468 Rose Stein International Elementary   Regular School No Elementary PK 06 2020   grade_6 5 0 36   1 0     0   2   24 20                       44 5 0 36   1 0     0   2   24 20                 44
1808169 CO     school 804800 1420   Jefferson County R-1 80480000783 8090 Deane Elementary School   Regular School No Elementary KG 06 2020   grade_6 9 1 52   0 2     0   5   40 29                       69 9 1 52   0 2     0   5   40 29                 69

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