Data source: Big Local News · About: Big Local

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

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
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
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
1739044 CO     school 802430 50   Bennett 29J 80243006789 562 Bennett Intermediate School   Regular School No Middle 04 06 2021   grade_6 51 3 33   0 0     0   9   56 40                       96 51 3 33   0 0     0   9   56 40                 96
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
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
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
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
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
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
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
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
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
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
1743272 CO     school 803450 900   Douglas County Re 1 80345006392 265 Clear Sky Elementary   Regular School No Elementary PK 06 2021   grade_6 81 2 17   0 2     0   7   56 53                       109 81 2 17   0 2     0   7   56 53                 109
1743293 CO     school 803450 900   Douglas County Re 1 80345001757 354 Arrowwood Elementary School   Regular School No Elementary PK 06 2021   grade_6 26 0 16   0 7     0   1   24 26                       50 26 0 16   0 7     0   1   24 26                 50
1743302 CO     school 803450 900   Douglas County Re 1 80345006159 651 Bear Canyon Elementary School   Regular School No Elementary PK 06 2021   grade_6 49 0 9   1 4     0   4   43 24                       67 49 0 9   1 4     0   4   43 24                 67
1743321 CO     school 803450 900   Douglas County Re 1 80345000437 1362 Castle Rock Elementary School   Regular School No Elementary PK 06 2021   grade_6 37 0 14   2 1     0   3   31 26                       57 37 0 14   2 1     0   3   31 26                 57
1743366 CO     school 803450 900   Douglas County Re 1 80345000439 1578 Cherry Valley Elementary School   Regular School No Elementary KG 06 2021   grade_6 4 0 0   0 0     0   0   0 4                       4 4 0 0   0 0     0   0   0 4                 4
1743395 CO     school 803450 900   Douglas County Re 1 80345001897 1899 Copper Mesa Elementary School   Regular School No Elementary PK 06 2021   grade_6 45 2 7   0 3     0   5   35 27                       62 45 2 7   0 3     0   5   35 27                 62
1743404 CO     school 803450 900   Douglas County Re 1 80345001526 1925 Cougar Run Elementary School   Regular School No Elementary KG 06 2021   grade_6 52 2 14   0 1     0   5   40 34                       74 52 2 14   0 1     0   5   40 34                 74
1743412 CO     school 803450 900   Douglas County Re 1 80345001250 1934 Coyote Creek Elementary School   Regular School No Elementary PK 06 2021   grade_6 41 3 11   0 1     0   2   35 23                       58 41 3 11   0 1     0   2   35 23                 58
1743432 CO     school 803450 900   Douglas County Re 1 80345001475 2232 Rock Ridge Elementary School   Regular School No Elementary PK 06 2021   grade_6 57 0 14   0 1     0   4   36 40                       76 57 0 14   0 1     0   4   36 40                 76
1743441 CO     school 803450 900   Douglas County Re 1 80345001497 2233 Cherokee Trail Elementary School   Regular School No Elementary PK 06 2021   grade_6 47 2 9   1 1     0   1   30 31                       61 47 2 9   1 1     0   1   30 31                 61
1743450 CO     school 803450 900   Douglas County Re 1 80345001476 2234 Eagle Ridge Elementary School   Regular School No Elementary PK 06 2021   grade_6 57 2 21   1 3     0   7   51 40                       91 57 2 21   1 3     0   7   51 40                 91
1743463 CO     school 803450 900   Douglas County Re 1 80345001736 2656 Eldorado Elementary School   Regular School No Elementary PK 06 2021   grade_6 43 1 8   0 3     1   3   30 29                       59 43 1 8   0 3     1   3   30 29                 59
1743472 CO     school 803450 900   Douglas County Re 1 80345006337 2952 Mammoth Heights Elementary   Regular School No Elementary PK 06 2021   grade_6 67 3 14   1 2     0   6   43 50                       93 67 3 14   1 2     0   6   43 50                 93
1743481 CO     school 803450 900   Douglas County Re 1 80345006309 2953 Stone Mountain Elementary   Regular School No Elementary PK 06 2021   grade_6 79 2 12   0 3     0   6   62 40                       102 79 2 12   0 3     0   6   62 40                 102
1743488 CO     school 803450 900   Douglas County Re 1 80345006299 2954 Roxborough Intermediate   Regular School No Elementary 03 06 2021   grade_6 62 0 13   0 0     0   3   53 25                       78 62 0 13   0 0     0   3   53 25                 78
1743495 CO     school 803450 900   Douglas County Re 1 80345001959 2965 Flagstone Elementary School   Regular School No Elementary PK 06 2021   grade_6 44 1 11   0 1     0   5   27 35                       62 44 1 11   0 1     0   5   27 35                 62
1743504 CO     school 803450 900   Douglas County Re 1 80345001275 3138 Fox Creek Elementary School   Regular School No Elementary PK 06 2021   grade_6 41 1 6   0 2     0   4   25 29                       54 41 1 6   0 2     0   4   25 29                 54
1743540 CO     school 803450 900   Douglas County Re 1 80345001740 3928 Heritage Elementary School   Regular School No Elementary PK 06 2021   grade_6 57 0 9   0 3     0   3   38 34                       72 57 0 9   0 3     0   3   38 34                 72
1743572 CO     school 803450 900   Douglas County Re 1 80345000441 4980 Larkspur Elementary School   Regular School No Elementary KG 06 2021   grade_6 30 0 2   0 0     0   1   24 9                       33 30 0 2   0 0     0   1   24 9                 33
1743625 CO     school 803450 900   Douglas County Re 1 80345001785 5745 Meadow View Elementary School   Regular School No Elementary PK 06 2021   grade_6 51 1 10   0 0     0   4   36 30                       66 51 1 10   0 0     0   4   36 30                 66
1743634 CO     school 803450 900   Douglas County Re 1 80345006341 5843 Lone Tree Elementary   Regular School No Elementary PK 06 2021   grade_6 32 0 2   0 1     0   1   21 15                       36 32 0 2   0 1     0   1   21 15                 36
1743695 CO     school 803450 900   Douglas County Re 1 80345001339 6406 Northridge Elementary School   Regular School No Elementary PK 06 2021   grade_6 67 3 15   0 11     0   7   43 60                       103 67 3 15   0 11     0   7   43 60                 103
1743720 CO     school 803450 900   Douglas County Re 1 80345001279 6938 Pine Grove Elementary School   Regular School No Elementary PK 06 2021   grade_6 59 1 7   1 2     0   4   35 39                       74 59 1 7   1 2     0   4   35 39                 74
1743729 CO     school 803450 900   Douglas County Re 1 80345000444 6940 Pine Lane Elementary   Regular School No Elementary PK 06 2021   grade_6 65 3 18   0 5     0   7   52 46                       98 65 3 18   0 5     0   7   52 46                 98
1743767 CO     school 803450 900   Douglas County Re 1 80345001809 7134 Prairie Crossing Elementary School   Regular School No Elementary KG 06 2021   grade_6 68 2 12   0 5     0   2   46 43                       89 68 2 12   0 5     0   2   46 43                 89
1743794 CO     school 803450 900   Douglas County Re 1 80345001288 7319 Renaissance Expedition Learn Outward Bound School   Regular School No Elementary KG 06 2021   grade_6 41 2 4   0 2     0   3   22 30                       52 41 2 4   0 2     0   3   22 30                 52
1743811 CO     school 803450 900   Douglas County Re 1 80345001680 7562 Saddle Ranch Elementary School   Regular School No Elementary PK 06 2021   grade_6 56 0 8   1 2     0   4   29 42                       71 56 0 8   1 2     0   4   29 42                 71
1743820 CO     school 803450 900   Douglas County Re 1 80345001407 7610 Sand Creek Elementary School   Regular School No Elementary PK 06 2021   grade_6 39 1 10   1 2     0   5   31 27                       58 39 1 10   1 2     0   5   31 27                 58
1743829 CO     school 803450 900   Douglas County Re 1 80345000446 7718 Sedalia Elementary School   Regular School No Elementary PK 06 2021   grade_6 11 1 14   0 0     0   4   7 23                       30 11 1 14   0 0     0   4   7 23                 30
1743838 CO     school 803450 900   Douglas County Re 1 80345001840 8106 Soaring Hawk Elementary School   Regular School No Elementary PK 06 2021   grade_6 67 1 7   0 2     0   4   39 42                       81 67 1 7   0 2     0   4   39 42                 81
1743854 CO     school 803450 900   Douglas County Re 1 80345000044 8382 Summit View Elementary School   Regular School No Elementary PK 06 2021   grade_6 55 0 10   0 1     0   4   31 39                       70 55 0 10   0 1     0   4   31 39                 70
1743876 CO     school 803450 900   Douglas County Re 1 80345001585 8897 Trailblazer Elementary School   Regular School No Elementary PK 06 2021   grade_6 48 0 9   0 3     0   2   29 33                       62 48 0 9   0 3     0   2   29 33                 62
1744648 CO     school 803060 1010   Colorado Springs 11 80306001318 3470 Globe Charter School   Regular School Yes Elementary KG 06 2021   grade_6 9 1 1   0 1     0   2   8 6                       14 9 1 1   0 1     0   2   8 6                 14
1744890 CO     school 802940 1020   Cheyenne Mountain 12 80294001326 1582 The Vanguard School (Elementary)   Regular School Yes Elementary KG 06 2021   grade_6 76 6 35   0 9     1   11   69 69                       138 76 6 35   0 9     1   11   69 69                 138
1744899 CO     school 802940 1020   Cheyenne Mountain 12 80294001391 1586 Cheyenne Mountain Elementary School   Regular School No Elementary KG 06 2021   grade_6 37 2 8   0 1     0   2   24 26                       50 37 2 8   0 1     0   2   24 26                 50
1744915 CO     school 802940 1020   Cheyenne Mountain 12 80294000212 1592 Broadmoor Elementary School   Regular School No Elementary KG 06 2021   grade_6 41 1 5   0 1     1   3   30 22                       52 41 1 5   0 1     1   3   30 22                 52
1744925 CO     school 802940 1020   Cheyenne Mountain 12 80294000210 1604 Skyway Park Elementary School   Regular School No Elementary KG 06 2021   grade_6 32 0 11   0 1     0   8   28 24                       52 32 0 11   0 1     0   8   28 24                 52
1744933 CO     school 802940 1020   Cheyenne Mountain 12 80294001591 3482 Gold Camp Elementary School   Regular School No Elementary KG 06 2021   grade_6 62 1 10   0 0     0   5   43 35                       78 62 1 10   0 0     0   5   43 35                 78
1744941 CO     school 802940 1020   Cheyenne Mountain 12 80294001535 6953 Pinon Valley Elementary School   Regular School No Elementary KG 06 2021   grade_6 23 0 12   0 2     0   2   22 17                       39 23 0 12   0 2     0   2   22 17                 39
1744974 CO     school 805490 1030   Manitou Springs 14 80549000948 9010 Ute Pass Elementary School   Regular School No Elementary PK 06 2021   grade_6 37 2 2   0 0     0   0   18 23                       41 37 2 2   0 0     0   0   18 23                 41
1745053 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2021   grade_6 218 5 23   1 7     0   14   132 136                       268 218 5 23   1 7     0   14   132 136                 268
1745276 CO     school 806060 1060   Peyton 23 Jt 80606001024 6898 Peyton Elementary School   Regular School No Elementary PK 06 2021   grade_6 36 2 4   0 0     0   4   24 22                       46 36 2 4   0 0     0   4   24 22                 46
1745324 CO     school 805820 1080   Lewis-Palmer 38 80582001371 3539 Bear Creek Elementary School   Regular School No Elementary PK 06 2021   grade_6 100 1 16   2 1     0   12   75 57                       132 100 1 16   2 1     0   12   75 57                 132
1745334 CO     school 805820 1080   Lewis-Palmer 38 80582001489 4686 Ray E Kilmer Elementary School   Regular School No Elementary PK 06 2021   grade_6 48 0 7   0 0     0   4   35 24                       59 48 0 7   0 0     0   4   35 24                 59
1745349 CO     school 805820 1080   Lewis-Palmer 38 80582001004 5096 Lewis-Palmer Elementary School   Regular School No Elementary PK 06 2021   grade_6 61 0 7   0 5     0   7   40 40                       80 61 0 7   0 5     0   7   40 40                 80
1745371 CO     school 805820 1080   Lewis-Palmer 38 80582001397 6682 Palmer Lake Elementary School   Regular School No Elementary PK 06 2021   grade_6 35 1 10   0 0     0   1   26 21                       47 35 1 10   0 0     0   1   26 21                 47
1745380 CO     school 805820 1080   Lewis-Palmer 38 80582001810 7165 Prairie Winds Elementary School   Regular School No Elementary PK 06 2021   grade_6 42 1 7   0 1     0   3   26 28                       54 42 1 7   0 1     0   3   26 28                 54
1745737 CO     school 803960 1150   Fremont RE-2 80396000515 3224 Fremont Elementary School   Regular School No Elementary PK 06 2021   grade_6 41 1 15   0 0     0   6   24 39                       63 41 1 15   0 0     0   6   24 39                 63
1745746 CO     school 803960 1150   Fremont RE-2 80396000516 6858 Penrose Elementary School   Regular School No Elementary PK 06 2021   grade_6 27 0 4   0 0     0   0   16 15                       31 27 0 4   0 0     0   0   16 15                 31
1746291 CO     school 804800 1420   Jefferson County R-1 80480001649 1869 Compass Montessori - Wheat Ridge Charter School   Regular School Yes Elementary PK 06 2021   grade_6 24 0 1   0 0     0   3   15 13                       28 24 0 1   0 0     0   3   15 13                 28
1746385 CO     school 804800 1420   Jefferson County R-1 80480000716 2496 Edgewater Elementary School   Regular School No Elementary PK 06 2021   grade_6 2 4 35   0 0     0   1   16 26                       42 2 4 35   0 0     0   1   16 26                 42
1746530 CO     school 804800 1420   Jefferson County R-1 80480006723 3691 Great Work Montessori   Regular School Yes Elementary PK 06 2021   grade_6 6 0 4   0 0     0   0   3 7                       10 6 0 4   0 0     0   0   3 7                 10
1746556 CO     school 804800 1420   Jefferson County R-1 80480000975 4402 Jefferson Academy Elementary   Regular School Yes Elementary KG 06 2021   grade_6 75 2 15   0 7     0   11   57 53                       110 75 2 15   0 7     0   11   57 53                 110
1746652 CO     school 804800 1420   Jefferson County R-1 80480000748 5004 Lasley Elementary School   Regular School No Elementary KG 06 2021   grade_6 11 1 45   0 4     0   2   31 32                       63 11 1 45   0 4     0   2   31 32                 63
1746702 CO     school 804800 1420   Jefferson County R-1 80480000752 5354 Lumberg Elementary School   Regular School No Elementary PK 06 2021   grade_6 6 1 53   0 0     1   3   28 36                       64 6 1 53   0 0     1   3   28 36                 64
1746779 CO     school 804800 1420   Jefferson County R-1 80480000758 5972 Molholm Elementary School   Regular School No Elementary PK 06 2021   grade_6 2 2 38   0 0     0   1   27 16                       43 2 2 38   0 0     0   1   27 16                 43
1746852 CO     school 804800 1420   Jefferson County R-1 80480006256 6539 Jefferson County Open Elementary School   Regular School No Elementary PK 06 2021   grade_6 28 0 9   0 1     0   1   23 16                       39 28 0 9   0 1     0   1   23 16                 39
1746883 CO     school 804800 1420   Jefferson County R-1 80480000770 6808 Patterson International School   Regular School No Elementary PK 06 2021   grade_6 10 0 20   1 1     0   1   15 18                       33 10 0 20   1 1     0   1   15 18                 33
1746963 CO     school 804800 1420   Jefferson County R-1 80480006724 7468 Rose Stein International Elementary   Regular School No Elementary PK 06 2021   grade_6 3 2 16   0 0     0   2   11 12                       23 3 2 16   0 0     0   2   11 12                 23
1747060 CO     school 804800 1420   Jefferson County R-1 80480000783 8090 Deane Elementary School   Regular School No Elementary KG 06 2021   grade_6 8 4 58   0 1     0   3   40 34                       74 8 4 58   0 1     0   3   40 34                 74
1747088 CO     school 804800 1420   Jefferson County R-1 80480000785 8248 Emory Elementary School   Regular School No Elementary KG 06 2021   grade_6 11 1 52   0 0     0   2   25 41                       66 11 1 52   0 0     0   2   25 41                 66
1747268 CO     school 804800 1420   Jefferson County R-1 80480000710 9432 Dennison Elementary School   Regular School No Elementary KG 06 2021   grade_6 63 2 7   0 10     2   5   52 37                       89 63 2 7   0 10     2   5   52 37                 89
1747426 CO     school 805190 1510   Lake County R-1 80519000855 4901 Lake County Intermediate School   Regular School No Elementary 03 06 2021   grade_6 14 0 52   0 0     0   1   32 35                       67 14 0 52   0 0     0   1   32 35                 67
1747701 CO     school 803990 1550   Poudre R-1 80399006613 3242 Fort Collins Montessori School   Regular School Yes Elementary PK 06 2021   grade_6 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1748354 CO     school 804890 1810   Karval RE-23 80489000814 4502 Karval Elementary School   Regular School No Elementary PK 06 2021   grade_6 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1748374 CO     school 806690 1828   Valley RE-1 80669001361 1220 Caliche Elementary School   Regular School No Elementary PK 06 2021   grade_6 13 0 0   0 0     0   1   8 6                       14 13 0 0   0 0     0   1   8 6                 14
1748405 CO     school 803930 1850   Frenchman RE-3 80393000511 2980 Fleming Elementary School   Regular School No Elementary PK 06 2021   grade_6 15 0 0   0 0     0   0   7 8                       15 15 0 0   0 0     0   0   7 8                 15
1748421 CO     school 805640 1860   Buffalo RE-4J 80564000969 5802 Merino Elementary School   Regular School No Elementary KG 06 2021   grade_6 23 0 2   0 1     0   0   16 10                       26 23 0 2   0 1     0   0   16 10                 26
1748436 CO     school 806030 1870   Plateau RE-5 80603001022 6834 Peetz Elementary School   Regular School No Elementary PK 06 2021   grade_6 9 0 1   0 0     0   0   4 6                       10 9 0 1   0 0     0   0   4 6                 10
1748470 CO     school 803030 1990   Plateau Valley 50 80303000219 7024 Plateau Valley Elementary School   Regular School No Elementary PK 06 2021   grade_6 12 0 2   1 0     0   1   8 8                       16 12 0 2   1 0     0   1   8 8                 16

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