Data source: Big Local News · About: Big Local

1,108 rows where grade = "grade_5", state = "CO" and year = 2020 sorted by native_american_alaskan_native_int

View and edit SQL

year

  • 2020 · 1,108

grade

  • grade_5 · 1,108
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
1799334 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_5 3 1 42   0 1     0   0   24 23                       47 3 1 42   0 1     0   0   24 23                 47
1799344 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_5 6 1 35   0 1     0   0   20 23                       43 6 1 35   0 1     0   0   20 23                 43
1799358 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_5 3 1 52   0 1     0   2   30 29                       59 3 1 52   0 1     0   2   30 29                 59
1799369 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_5 1 0 24   0 1     0   1   11 16                       27 1 0 24   0 1     0   1   11 16                 27
1799389 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   grade_5 11 2 38   0 0     1   0   26 26                       52 11 2 38   0 0     1   0   26 26                 52
1799398 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_5 5 1 43   0 0     0   1   23 27                       50 5 1 43   0 0     0   1   23 27                 50
1799407 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_5 3 3 42   0 3     0   1   24 28                       52 3 3 42   0 3     0   1   24 28                 52
1799425 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_5 58 8 18   0 2     0   14   46 54                       100 58 8 18   0 2     0   14   46 54                 100
1799465 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   grade_5 35 2 34   0 9     0   5   47 38                       85 35 2 34   0 9     0   5   47 38                 85
1799492 CO     school 806900 20   Adams 12 Five Star Schools 80690001619 301 Arapahoe Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_5 40 2 46   0 6     0   4   53 45                       98 40 2 46   0 6     0   4   53 45                 98
1799500 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   grade_5 33 1 42   0 2     0   1   34 45                       79 33 1 42   0 2     0   1   34 45                 79
1799526 CO     school 806900 20   Adams 12 Five Star Schools 80690001174 1878 Coronado Hills Elementary School   Regular School No Elementary PK 05 2020   grade_5 12 4 89   0 0     0   0   59 46                       105 12 4 89   0 0     0   0   59 46                 105
1799541 CO     school 806900 20   Adams 12 Five Star Schools 80690001668 1937 Coyote Ridge Elementary School   Regular School No Elementary KG 05 2020   grade_5 60 0 8   0 6     0   7   46 35                       81 60 0 8   0 6     0   7   46 35                 81
1799548 CO     school 806900 20   Adams 12 Five Star Schools 80690001622 2361 Eagleview Elementary School   Regular School No Elementary KG 05 2020   grade_5 66 2 33   0 2     0   4   52 55                       107 66 2 33   0 2     0   4   52 55                 107
1799555 CO     school 806900 20   Adams 12 Five Star Schools 80690001175 2410 Tarver Elementary School   Regular School No Elementary PK 05 2020   grade_5 50 1 14   0 2     0   3   38 32                       70 50 1 14   0 2     0   3   38 32                 70
1799586 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2020   grade_5 11 3 60   0 1     0   2   43 34                       77 11 3 60   0 1     0   2   43 34                 77
1799601 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   grade_5 3 0 88   0 0     0   0   45 46                       91 3 0 88   0 0     0   0   45 46                 91
1799609 CO     school 806900 20   Adams 12 Five Star Schools 80690001177 4000 Hillcrest Elementary School   Regular School No Elementary KG 05 2020   grade_5 16 1 57   0 2     0   0   41 35                       76 16 1 57   0 2     0   0   41 35                 76
1799621 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_5 50 2 8   0 14     0   4   37 41                       78 50 2 8   0 14     0   4   37 41                 78
1799645 CO     school 806900 20   Adams 12 Five Star Schools 80690001306 5058 Leroy Drive Elementary School   Regular School No Elementary KG 05 2020   grade_5 26 4 42   0 3     0   3   38 40                       78 26 4 42   0 3     0   3   38 40                 78
1799660 CO     school 806900 20   Adams 12 Five Star Schools 80690001182 5706 McElwain Elementary School   Regular School No Elementary KG 05 2020   grade_5 9 5 52   0 4     0   3   35 38                       73 9 5 52   0 4     0   3   35 38                 73
1799693 CO     school 806900 20   Adams 12 Five Star Schools 80690001184 6355 North Mor Elementary School   Regular School No Elementary PK 05 2020   grade_5 18 1 48   0 4     0   0   35 36                       71 18 1 48   0 4     0   0   35 36                 71
1799721 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_5 92 1 13   0 8     0   11   70 55                       125 92 1 13   0 8     0   11   70 55                 125
1799740 CO     school 806900 20   Adams 12 Five Star Schools 80690001945 7155 Prairie Hills Elementary School   Regular School No Elementary KG 05 2020   grade_5 54 1 11   0 10     0   8   52 32                       84 54 1 11   0 10     0   8   52 32                 84
1799747 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2020   grade_5 65 1 22   0 6     2   4   48 52                       100 65 1 22   0 6     2   4   48 52                 100
1799761 CO     school 806900 20   Adams 12 Five Star Schools 80690006303 8225 Stellar Elementary School   Regular School No Elementary KG 05 2020   grade_5 35 0 50   0 6     0   4   53 42                       95 35 0 50   0 6     0   4   53 42                 95
1799768 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_5 54 1 18   0 3     0   7   55 28                       83 54 1 18   0 3     0   7   55 28                 83
1799779 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_5 15 0 51   0 1     0   0   28 39                       67 15 0 51   0 1     0   0   28 39                 67
1799789 CO     school 806900 20   Adams 12 Five Star Schools 80690001190 8361 Stukey Elementary School   Regular School No Elementary KG 05 2020   grade_5 15 1 46   0 2     0   3   41 26                       67 15 1 46   0 2     0   3   41 26                 67
1799796 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_5 56 0 5   0 2     0   5   35 33                       68 56 0 5   0 2     0   5   35 33                 68
1799833 CO     school 806900 20   Adams 12 Five Star Schools 80690001195 9494 Westview Elementary School   Regular School No Elementary PK 05 2020   grade_5 26 0 32   0 6     0   5   37 32                       69 26 0 32   0 6     0   5   37 32                 69
1799872 CO     school 801950 30   Adams County 14 80195000012 1426 Central Elementary School   Regular School No Elementary PK 05 2020   grade_5 6 4 56   0 0     0   0   35 31                       66 6 4 56   0 0     0   0   35 31                 66
1799900 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2020   grade_5 4 3 47   0 0     0   1   30 25                       55 4 3 47   0 0     0   1   30 25                 55
1799933 CO     school 802580 40   School District 27J 80258006549 1013 Brantner Elementary School   Regular School No Elementary PK 05 2020   grade_5 58 0 34   0 8     0   6   54 52                       106 58 0 34   0 8     0   6   54 52                 106
1799953 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2020   grade_5 78 1 48   0 1     0   5   69 64                       133 78 1 48   0 1     0   5   69 64                 133
1799968 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2020   grade_5 47 1 36   0 1     0   3   47 41                       88 47 1 36   0 1     0   3   47 41                 88
1799978 CO     school 802580 40   School District 27J 80258000146 3900 Henderson Elementary School   Regular School No Elementary PK 05 2020   grade_5 26 2 41   0 0     0   4   43 30                       73 26 2 41   0 0     0   4   43 30                 73
1799986 CO     school 802580 40   School District 27J 80258006325 4950 Landmark Academy at Reunion   Regular School Yes Elementary KG 08 2020   grade_5 50 3 23   0 7     0   2   46 39                       85 50 3 23   0 7     0   2   46 39                 85
1799996 CO     school 802580 40   School District 27J 80258001949 5615 Mary E Pennock Elementary School   Regular School No Elementary PK 05 2020   grade_5 35 1 64   0 1     0   1   52 50                       102 35 1 64   0 1     0   1   52 50                 102
1800012 CO     school 802580 40   School District 27J 80258000149 6395 Northeast Elementary School   Regular School No Elementary PK 06 2020   grade_5 25 0 66   0 2     0   3   53 43                       96 25 0 66   0 2     0   3   53 43                 96
1800053 CO     school 802580 40   School District 27J 80258001950 7714 Second Creek Elementary School   Regular School No Elementary PK 05 2020   grade_5 48 8 56   0 5     1   6   63 61                       124 48 8 56   0 5     1   6   63 61                 124
1800063 CO     school 802580 40   School District 27J 80258001822 8032 John W Thimmig Elementary School   Regular School No Elementary PK 05 2020   grade_5 54 2 53   0 7     0   4   62 58                       120 54 2 53   0 7     0   4   62 58                 120
1800071 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2020   grade_5 15 1 61   0 0     0   0   36 41                       77 15 1 61   0 0     0   0   36 41                 77
1800079 CO     school 802580 40   School District 27J 80258000151 8130 Southeast Elementary School   Regular School No Elementary PK 05 2020   grade_5 36 1 37   0 0     0   4   49 29                       78 36 1 37   0 0     0   4   49 29                 78
1800087 CO     school 802580 40   School District 27J 80258006401 8820 Turnberry Elementary   Regular School No Elementary PK 05 2020   grade_5 51 0 53   0 2     0   5   63 48                       111 51 0 53   0 2     0   5   63 48                 111
1800099 CO     school 802580 40   School District 27J 80258006326 9426 West Ridge Elementary   Regular School No Elementary PK 05 2020   grade_5 67 0 32   0 14     0   3   45 71                       116 67 0 32   0 14     0   3   45 71                 116
1800104 CO     school 802430 50   Bennett 29J 80243006789 562 Bennett Intermediate School   Regular School No Middle 04 06 2020   grade_5 49 2 23   0 0     0   8   49 33                       82 49 2 23   0 0     0   8   49 33                 82
1800130 CO     school 806750 60   Strasburg 31J 80675001159 8328 Strasburg Elementary School   Regular School No Elementary PK 05 2020   grade_5 51 1 15   0 0     0   1   36 32                       68 51 1 15   0 0     0   1   36 32                 68
1800158 CO     school 807230 70   Westminster Public Schools 80723001235 2876 Fairview Elementary School   Regular School No Elementary PK 05 2020   grade_5 9 1 52   0 2     0   1   30 35                       65 9 1 52   0 2     0   1   30 35                 65
1800166 CO     school 807230 70   Westminster Public Schools 80723001236 3144 Francis M. Day Elementary School   Regular School No Elementary PK 05 2020   grade_5 1 0 47   0 0     0   0   28 20                       48 1 0 47   0 0     0   0   28 20                 48
1800176 CO     school 807230 70   Westminster Public Schools 80723001238 3792 Harris Park Elementary School   Regular School No Elementary PK 05 2020   grade_5 6 3 29   0 1     0   2   17 24                       41 6 3 29   0 1     0   2   17 24                 41
1800200 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 06 2020   grade_5 6 1 84   0 2     0   3   45 51                       96 6 1 84   0 2     0   3   45 51                 96
1800225 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 06 2020   grade_5 7 0 26   0 5     0   1   21 18                       39 7 0 26   0 5     0   1   21 18                 39
1800246 CO     school 807230 70   Westminster Public Schools 80723001247 7952 Skyline Vista Elementary School   Regular School No Elementary PK 05 2020   grade_5 2 0 54   0 2     0   1   33 26                       59 2 0 54   0 2     0   1   33 26                 59
1800254 CO     school 807230 70   Westminster Public Schools 80723001248 8406 Sunset Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_5 5 0 46   0 1     0   1   25 28                       53 5 0 46   0 1     0   1   25 28                 53
1800262 CO     school 807230 70   Westminster Public Schools 80723001249 8798 Tennyson Knolls Elementary School   Regular School No Elementary PK 05 2020   grade_5 6 1 48   0 6     0   1   33 29                       62 6 1 48   0 6     0   1   33 29                 62
1800270 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_5 5 0 27   0 1     0   1   21 13                       34 5 0 27   0 1     0   1   21 13                 34
1800312 CO     school 806420 110   Sangre De Cristo Re-22J 80642001115 7626 Sangre de Cristo Elementary School   Regular School No Elementary PK 05 2020   grade_5 16 1 7   0 0     0   0   13 11                       24 16 1 7   0 0     0   0   13 11                 24
1800333 CO     school 803780 120   Englewood 1 80378000486 1514 Charles Hay World School   Regular School No Elementary KG 06 2020   grade_5 36 0 13   0 0     0   0   28 21                       49 36 0 13   0 0     0   0   28 21                 49
1800341 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2020   grade_5 18 2 12   0 0     0   0   17 15                       32 18 2 12   0 0     0   0   17 15                 32
1800349 CO     school 803780 120   Englewood 1 80378000489 1652 Clayton Elementary School   Regular School No Elementary KG 06 2020   grade_5 26 1 29   0 2     0   2   26 34                       60 26 1 29   0 2     0   2   26 34                 60
1800371 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_5 6 1 12   0 1     0   3   16 7                       23 6 1 12   0 1     0   3   16 7                 23
1800381 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2020   grade_5 15 4 75   0 3     0   4   48 53                       101 15 4 75   0 3     0   4   48 53                 101
1800414 CO     school 802910 130   Cherry Creek 5 80291006750 102 Altitude Elementary School   Regular School No Elementary PK 05 2020   grade_5 77 7 16   0 12     1   7   59 61                       120 77 7 16   0 12     1   7   59 61                 120
1800430 CO     school 802910 130   Cherry Creek 5 80291001670 242 Antelope Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_5 70 9 25   0 3     0   4   51 60                       111 70 9 25   0 3     0   4   51 60                 111
1800437 CO     school 802910 130   Cherry Creek 5 80291002032 243 Coyote Hills Elementary School   Regular School No Elementary PK 05 2020   grade_5 62 6 12   0 13     0   13   52 54                       106 62 6 12   0 13     0   13   52 54                 106
1800452 CO     school 802910 130   Cherry Creek 5 80291001879 442 Aspen Crossing Elementary School   Regular School No Elementary PK 05 2020   grade_5 53 12 13   0 10     0   10   48 50                       98 53 12 13   0 10     0   10   48 50                 98
1800460 CO     school 802910 130   Cherry Creek 5 80291000184 714 Belleview Elementary School   Regular School No Elementary PK 05 2020   grade_5 56 2 19   0 28     0   9   68 46                       114 56 2 19   0 28     0   9   68 46                 114
1800467 CO     school 802910 130   Cherry Creek 5 80291006301 1155 Buffalo Trail Elementary School   Regular School No Elementary PK 06 2020   grade_5 69 17 22   0 12     2   9   64 67                       131 69 17 22   0 12     2   9   64 67                 131
1800486 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2020   grade_5 32 11 11   0 14     0   5   32 41                       73 32 11 11   0 14     0   5   32 41                 73
1800514 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2020   grade_5 37 9 7   0 23     0   2   35 43                       78 37 9 7   0 23     0   2   35 43                 78
1800524 CO     school 802910 130   Cherry Creek 5 80291001273 1572 High Plains Elementary School   Regular School No Elementary PK 05 2020   grade_5 58 5 22   0 5     0   10   48 52                       100 58 5 22   0 5     0   10   48 52                 100
1800538 CO     school 802910 130   Cherry Creek 5 80291001297 1614 Cimarron Elementary School   Regular School No Elementary PK 05 2020   grade_5 27 18 28   0 3     0   10   47 39                       86 27 18 28   0 3     0   10   47 39                 86
1800552 CO     school 802910 130   Cherry Creek 5 80291001404 1970 Creekside Elementary School   Regular School No Elementary PK 05 2020   grade_5 81 8 13   0 17     0   7   61 65                       126 81 8 13   0 17     0   7   61 65                 126
1800560 CO     school 802910 130   Cherry Creek 5 80291001671 2094 Dakota Valley Elementary School   Regular School No Elementary PK 05 2020   grade_5 45 8 17   0 8     0   16   47 47                       94 45 8 17   0 8     0   16   47 47                 94
1800567 CO     school 802910 130   Cherry Creek 5 80291000190 2292 Dry Creek Elementary School   Regular School No Elementary PK 05 2020   grade_5 41 3 15   0 2     0   4   38 27                       65 41 3 15   0 2     0   4   38 27                 65
1800580 CO     school 802910 130   Cherry Creek 5 80291000191 2428 Eastridge Community Elementary School   Regular School No Elementary PK 05 2020   grade_5 28 29 35   0 3     0   9   57 47                       104 28 29 35   0 3     0   9   57 47                 104
1800605 CO     school 802910 130   Cherry Creek 5 80291000192 3648 Greenwood Elementary School   Regular School No Elementary PK 05 2020   grade_5 66 1 5   0 5     0   4   48 33                       81 66 1 5   0 5     0   4   48 33                 81
1800612 CO     school 802910 130   Cherry Creek 5 80291000193 3926 Heritage Elementary School   Regular School No Elementary PK 05 2020   grade_5 36 1 7   0 16     0   4   32 32                       64 36 1 7   0 16     0   4   32 32                 64
1800619 CO     school 802910 130   Cherry Creek 5 80291006182 3988 Highline Community Elementary School   Regular School No Elementary PK 05 2020   grade_5 11 20 63   0 2     3   5   50 54                       104 11 20 63   0 2     3   5   50 54                 104
1800644 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2020   grade_5 15 5 3   0 1     0   1   14 11                       25 15 5 3   0 1     0   1   14 11                 25
1800654 CO     school 802910 130   Cherry Creek 5 80291000196 4276 Independence Elementary School   Regular School No Elementary PK 05 2020   grade_5 29 19 20   0 2     1   14   38 47                       85 29 19 20   0 2     1   14   38 47                 85
1800661 CO     school 802910 130   Cherry Creek 5 80291001390 4280 Indian Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_5 45 6 16   0 11     1   12   50 41                       91 45 6 16   0 11     1   12   50 41                 91
1800671 CO     school 802910 130   Cherry Creek 5 80291006544 4448 Black Forest Hills Elementary School   Regular School No Elementary PK 05 2020   grade_5 75 7 13   0 5     0   6   60 46                       106 75 7 13   0 5     0   6   60 46                 106
1800693 CO     school 802910 130   Cherry Creek 5 80291000198 5934 Mission Viejo Elementary School   Regular School No Elementary PK 05 2020   grade_5 41 18 27   0 3     1   15   53 52                       105 41 18 27   0 3     1   15   53 52                 105
1800712 CO     school 802910 130   Cherry Creek 5 80291006563 6367 Options School   Alternative School No Other KG 12 2020   grade_5 46 4 5   0 1     0   5   33 28                       61 46 4 5   0 1     0   5   33 28                 61
1800730 CO     school 802910 130   Cherry Creek 5 80291006183 6820 Peakview Elementary School   Regular School No Elementary PK 05 2020   grade_5 53 7 19   0 5     0   7   42 49                       91 53 7 19   0 5     0   7   42 49                 91
1800764 CO     school 802910 130   Cherry Creek 5 80291001880 7277 Red Hawk Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_5 26 10 22   0 4     1   8   34 37                       71 26 10 22   0 4     1   8   34 37                 71
1800772 CO     school 802910 130   Cherry Creek 5 80291001514 7476 Rolling Hills Elementary School   Regular School No Elementary PK 05 2020   grade_5 55 6 13   0 5     0   7   52 34                       86 55 6 13   0 5     0   7   52 34                 86
1800796 CO     school 802910 130   Cherry Creek 5 80291001468 8380 Summit Elementary School   Regular School No Elementary PK 05 2020   grade_5 26 5 29   0 2     0   8   38 32                       70 26 5 29   0 2     0   8   38 32                 70
1800824 CO     school 802910 130   Cherry Creek 5 80291001330 8887 Trails West Elementary School   Regular School No Elementary PK 05 2020   grade_5 44 5 16   0 2     0   8   33 42                       75 44 5 16   0 2     0   8   33 42                 75
1800839 CO     school 802910 130   Cherry Creek 5 80291000206 9200 Walnut Hills Community Elementary School   Regular School No Elementary PK 05 2020   grade_5 32 0 7   0 3     0   5   22 25                       47 32 0 7   0 3     0   5   22 25                 47
1800859 CO     school 805310 140   Littleton 6 80531000878 752 Franklin Elementary School   Regular School No Elementary KG 05 2020   grade_5 87 0 9   0 4     1   4   59 46                       105 87 0 9   0 4     1   4   59 46                 105
1800866 CO     school 805310 140   Littleton 6 80531000874 1382 Centennial Academy of Fine Arts Education   Regular School No Elementary KG 05 2020   grade_5 40 1 38   0 2     0   3   47 37                       84 40 1 38   0 2     0   3   47 37                 84
1800900 CO     school 805310 140   Littleton 6 80531000882 3950 Highland Elementary School   Regular School No Elementary PK 05 2020   grade_5 30 1 8   0 0     0   3   19 23                       42 30 1 8   0 0     0   3   19 23                 42
1800921 CO     school 805310 140   Littleton 6 80531001515 5229 Littleton Academy   Regular School Yes Elementary KG 08 2020   grade_5 40 3 6   0 3     0   2   31 23                       54 40 3 6   0 3     0   2   31 23                 54
1800931 CO     school 805310 140   Littleton 6 80531001626 5233 Littleton Prep Charter School   Regular School Yes Elementary PK 08 2020   grade_5 45 2 14   0 2     0   6   37 32                       69 45 2 14   0 2     0   6   37 32                 69
1800942 CO     school 805310 140   Littleton 6 80531001300 5236 Lois Lenski Elementary School   Regular School No Elementary KG 05 2020   grade_5 96 1 6   0 3     0   6   56 56                       112 96 1 6   0 3     0   6   56 56                 112
1800949 CO     school 805310 140   Littleton 6 80531000883 5572 Hopkins Elementary School   Regular School No Elementary PK 05 2020   grade_5 37 1 9   0 0     0   4   22 29                       51 37 1 9   0 0     0   4   22 29                 51
1800957 CO     school 805310 140   Littleton 6 80531000891 5574 Twain Elementary School   Regular School No Elementary KG 05 2020   grade_5 34 0 6   0 1     0   6   27 20                       47 34 0 6   0 1     0   6   27 20                 47

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