enrollments

Data source: Big Local News · About: Big Local

13,286 rows where state = "CO" and year = 2021 sorted by asian

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 13,186 ✖
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
1738802 1738802 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2021   grade_1 7 0 42   0 0     0   2   27 24                       51 7 0 42   0 0     0   2   27 24                 51
1738803 1738803 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2021   grade_2 7 0 44   0 0     0   0   31 20                       51 7 0 44   0 0     0   0   31 20                 51
1738804 1738804 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2021   grade_3 4 0 48   0 0     1   0   31 22                       53 4 0 48   0 0     1   0   31 22                 53
1738805 1738805 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2021   grade_4 12 0 56   0 0     0   1   35 34                       69 12 0 56   0 0     0   1   35 34                 69
1738806 1738806 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2021   grade_5 7 0 69   1 0     0   3   41 39                       80 7 0 69   1 0     0   3   41 39                 80
1738807 1738807 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 9 1 49   0 0     0   2   31 30                       61 9 1 49   0 0     0   2   31 30                 61
1738808 1738808 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 46 1 308   1 0     1   8   196 169                       365 46 1 308   1 0     1   8   196 169                 365
1738810 1738810 CO     school 801950 30   Adams County 14 80195000012 1426 Central Elementary School   Regular School No Elementary KG 05 2021   grade_2 4 8 50   0 0     0   0   36 26                       62 4 8 50   0 0     0   0   36 26                 62
1738811 1738811 CO     school 801950 30   Adams County 14 80195000012 1426 Central Elementary School   Regular School No Elementary KG 05 2021   grade_3 9 6 53   1 0     1   0   42 28                       70 9 6 53   1 0     1   0   42 28                 70
1738812 1738812 CO     school 801950 30   Adams County 14 80195000012 1426 Central Elementary School   Regular School No Elementary KG 05 2021   grade_4 8 6 64   0 0     0   2   38 42                       80 8 6 64   0 0     0   2   38 42                 80
1738813 1738813 CO     school 801950 30   Adams County 14 80195000012 1426 Central Elementary School   Regular School No Elementary KG 05 2021   grade_5 8 6 65   0 0     0   1   48 32                       80 8 6 65   0 0     0   1   48 32                 80
1738814 1738814 CO     school 801950 30   Adams County 14 80195000012 1426 Central Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 3 4 47   0 0     0   0   28 26                       54 3 4 47   0 0     0   0   28 26                 54
1738816 1738816 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2021   grade_1 5 0 55   0 0     0   0   31 29                       60 5 0 55   0 0     0   0   31 29                 60
1738818 1738818 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2021   grade_3 4 1 61   0 0     0   0   39 27                       66 4 1 61   0 0     0   0   39 27                 66
1738819 1738819 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2021   grade_4 7 2 62   0 0     0   1   40 32                       72 7 2 62   0 0     0   1   40 32                 72
1738820 1738820 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2021   grade_5 12 1 73   1 0     0   1   43 45                       88 12 1 73   1 0     0   1   43 45                 88
1738821 1738821 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 7 0 48   0 0     0   0   29 26                       55 7 0 48   0 0     0   0   29 26                 55
1738823 1738823 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2021   grade_6 22 5 194   4 0     0   2   110 117                       227 22 5 194   4 0     0   2   110 117                 227
1738824 1738824 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2021   grade_7 26 2 212   1 0     0   1   128 114                       242 26 2 212   1 0     0   1   128 114                 242
1738827 1738827 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2021   grade_1 11 0 69   0 0     0   0   43 37                       80 11 0 69   0 0     0   0   43 37                 80
1738828 1738828 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2021   grade_2 6 0 54   0 0     0   0   28 32                       60 6 0 54   0 0     0   0   28 32                 60
1738829 1738829 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2021   grade_3 10 2 67   0 0     0   0   41 38                       79 10 2 67   0 0     0   0   41 38                 79
1738830 1738830 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2021   grade_4 7 0 64   0 0     0   1   40 32                       72 7 0 64   0 0     0   1   40 32                 72
1738831 1738831 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2021   grade_5 3 1 74   0 0     0   1   33 46                       79 3 1 74   0 0     0   1   33 46                 79
1738832 1738832 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 3 1 56   0 0     0   1   35 26                       61 3 1 56   0 0     0   1   35 26                 61
1738833 1738833 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 43 4 423   0 0     0   3   246 227                       473 43 4 423   0 0     0   3   246 227                 473
1738834 1738834 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 3 0 39   0 0     0   0   26 16                       42 3 0 39   0 0     0   0   26 16                 42
1738835 1738835 CO     school 801950 30   Adams County 14 80195000404 5880 Mildred L Sanville Preschool   Regular School No Prekindergarten PK PK 2021   pk_12_total 2 3 69   0 0     0   1   48 27                       75 2 3 69   0 0     0   1   48 27                 75
1738836 1738836 CO     school 801950 30   Adams County 14 80195000404 5880 Mildred L Sanville Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 2 3 69   0 0     0   1   48 27                       75 2 3 69   0 0     0   1   48 27                 75
1738837 1738837 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2021   grade_1 6 1 35   0 0     0   0   25 17                       42 6 1 35   0 0     0   0   25 17                 42
1738838 1738838 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2021   grade_2 7 0 36   0 0     0   0   24 19                       43 7 0 36   0 0     0   0   24 19                 43
1738839 1738839 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2021   grade_3 4 0 38   0 0     0   1   21 22                       43 4 0 38   0 0     0   1   21 22                 43
1738840 1738840 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2021   grade_4 2 2 48   0 0     0   1   26 27                       53 2 2 48   0 0     0   1   26 27                 53
1738841 1738841 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2021   grade_5 13 0 48   0 0     0   0   33 28                       61 13 0 48   0 0     0   0   33 28                 61
1738842 1738842 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 7 0 41   0 0     0   0   23 25                       48 7 0 41   0 0     0   0   23 25                 48
1738843 1738843 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 39 3 246   0 0     0   2   152 138                       290 39 3 246   0 0     0   2   152 138                 290
1738844 1738844 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2021   grade_1 2 2 33   0 0     0   0   21 16                       37 2 2 33   0 0     0   0   21 16                 37
1738845 1738845 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2021   grade_2 2 0 38   0 0     0   0   21 19                       40 2 0 38   0 0     0   0   21 19                 40
1738846 1738846 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2021   grade_3 3 0 44   0 0     0   0   24 23                       47 3 0 44   0 0     0   0   24 23                 47
1738847 1738847 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2021   grade_4 1 0 36   0 0     0   0   20 17                       37 1 0 36   0 0     0   0   20 17                 37
1738848 1738848 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2021   grade_5 2 2 34   0 0     0   0   23 15                       38 2 2 34   0 0     0   0   23 15                 38
1738849 1738849 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 2 0 36   0 0     0   0   18 20                       38 2 0 36   0 0     0   0   18 20                 38
1738850 1738850 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 15 5 327   0 0     0   1   192 156                       348 15 5 327   0 0     0   1   192 156                 348
1738851 1738851 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 3 1 106   0 0     0   1   65 46                       111 3 1 106   0 0     0   1   65 46                 111
1738852 1738852 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2021   grade_1 5 2 41   0 0     0   0   22 26                       48 5 2 41   0 0     0   0   22 26                 48
1738853 1738853 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2021   grade_2 2 2 41   0 0     0   1   25 21                       46 2 2 41   0 0     0   1   25 21                 46
1738855 1738855 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2021   grade_4 5 1 40   0 0     0   0   27 19                       46 5 1 40   0 0     0   0   27 19                 46
1738856 1738856 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2021   grade_5 5 1 51   0 0     0   1   43 15                       58 5 1 51   0 0     0   1   43 15                 58
1738857 1738857 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 7 3 42   0 0     0   1   27 26                       53 7 3 42   0 0     0   1   27 26                 53
1738859 1738859 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 7 0 32   0 0     0   2   20 21                       41 7 0 32   0 0     0   2   20 21                 41
1738860 1738860 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2021   grade_1 27 0 36   0 0     0   5   35 33                       68 27 0 36   0 0     0   5   35 33                 68
1738866 1738866 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2021   grade_7 20 1 47   0 0     0   1   33 36                       69 20 1 47   0 0     0   1   33 36                 69
1738867 1738867 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2021   grade_8 16 3 47   0 0     0   1   36 31                       67 16 3 47   0 0     0   1   36 31                 67
1738868 1738868 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2021   kindergarten_full_day 23 1 39   0 0     0   7   28 42                       70 23 1 39   0 0     0   7   28 42                 70
1738877 1738877 CO     school 802580 40   School District 27J 80258006549 1013 Brantner Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 17 0 8   0 0     0   1   14 12                       26 17 0 8   0 0     0   1   14 12                 26
1738878 1738878 CO     school 802580 40   School District 27J 80258000729 1021 Innovations & Options   Alternative School No High 06 12 2021   grade_10 5 0 11   0 0     0   2   8 10                       18 5 0 11   0 0     0   2   8 10                 18
1738879 1738879 CO     school 802580 40   School District 27J 80258000729 1021 Innovations & Options   Alternative School No High 06 12 2021   grade_11 15 0 30   0 0     0   0   25 20                       45 15 0 30   0 0     0   0   25 20                 45
1738880 1738880 CO     school 802580 40   School District 27J 80258000729 1021 Innovations & Options   Alternative School No High 06 12 2021   grade_12 52 2 95   2 0     0   4   94 61                       155 52 2 95   2 0     0   4   94 61                 155
1738881 1738881 CO     school 802580 40   School District 27J 80258000729 1021 Innovations & Options   Alternative School No High 06 12 2021   grade_9 1 0 6   0 0     0   0   4 3                       7 1 0 6   0 0     0   0   4 3                 7
1738882 1738882 CO     school 802580 40   School District 27J 80258000729 1021 Innovations & Options   Alternative School No High 06 12 2021   pk_12_total 73 2 142   2 0     0   6   131 94                       225 73 2 142   2 0     0   6   131 94                 225
1738888 1738888 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2021   grade_1 71 2 47   0 0     0   5   60 65                       125 71 2 47   0 0     0   5   60 65                 125
1738890 1738890 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2021   grade_3 79 1 47   1 0     0   3   71 60                       131 79 1 47   1 0     0   3   71 60                 131
1738895 1738895 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2021   grade_8 97 0 49   0 0     0   4   85 65                       150 97 0 49   0 0     0   4   85 65                 150
1738903 1738903 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2021   grade_1 45 0 36   0 0     0   3   42 42                       84 45 0 36   0 0     0   3   42 42                 84
1738907 1738907 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2021   grade_5 57 1 27   0 0     0   2   49 38                       87 57 1 27   0 0     0   2   49 38                 87
1738909 1738909 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2021   grade_7 47 0 34   0 0     0   2   41 42                       83 47 0 34   0 0     0   2   41 42                 83
1738910 1738910 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2021   grade_8 47 0 35   0 0     0   4   44 42                       86 47 0 35   0 0     0   4   44 42                 86
1738914 1738914 CO     school 802580 40   School District 27J 80258000146 3900 Henderson Elementary School   Regular School No Elementary PK 05 2021   grade_2 16 0 35   0 0     1   1   32 21                       53 16 0 35   0 0     1   1   32 21                 53
1738929 1738929 CO     school 802580 40   School District 27J 80258006325 4950 Landmark Academy at Reunion   Regular School Yes Elementary KG 08 2021   kindergarten_full_day 50 1 21   0 0     0   5   37 40                       77 50 1 21   0 0     0   5   37 40                 77
1738931 1738931 CO     school 802580 40   School District 27J 80258001949 5615 Mary E Pennock Elementary School   Regular School No Elementary PK 05 2021   grade_1 45 4 49   0 0     0   2   52 48                       100 45 4 49   0 0     0   2   52 48                 100
1738938 1738938 CO     school 802580 40   School District 27J 80258001949 5615 Mary E Pennock Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 19 0 23   2 0     0   3   26 21                       47 19 0 23   2 0     0   3   26 21                 47
1738939 1738939 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2021   grade_1 4 0 27   0 0     0   1   19 13                       32 4 0 27   0 0     0   1   19 13                 32
1738940 1738940 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2021   grade_2 5 0 24   0 0     0   0   16 13                       29 5 0 24   0 0     0   0   16 13                 29
1738941 1738941 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2021   grade_3 10 0 25   0 0     0   0   18 17                       35 10 0 25   0 0     0   0   18 17                 35
1738943 1738943 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2021   grade_5 5 1 31   1 0     0   0   22 16                       38 5 1 31   1 0     0   0   22 16                 38
1738944 1738944 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 4 0 26   0 0     0   0   17 13                       30 4 0 26   0 0     0   0   17 13                 30
1738951 1738951 CO     school 802580 40   School District 27J 80258000149 6395 Northeast Elementary School   Regular School No Elementary PK 06 2021   kindergarten_full_day 23 1 45   0 0     0   1   32 38                       70 23 1 45   0 0     0   1   32 38                 70
1739005 1739005 CO     school 802580 40   School District 27J 80258001822 8032 John W Thimmig Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 11 1 20   0 0     0   1   16 17                       33 11 1 20   0 0     0   1   16 17                 33
1739006 1739006 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2021   grade_1 10 0 42   0 0     0   2   26 28                       54 10 0 42   0 0     0   2   26 28                 54
1739007 1739007 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2021   grade_2 12 0 48   1 0     0   2   26 37                       63 12 0 48   1 0     0   2   26 37                 63
1739008 1739008 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2021   grade_3 9 0 57   0 0     0   2   42 26                       68 9 0 57   0 0     0   2   42 26                 68
1739010 1739010 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2021   grade_5 10 1 61   0 0     0   0   40 32                       72 10 1 61   0 0     0   0   40 32                 72
1739011 1739011 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 5 1 41   0 0     0   1   25 23                       48 5 1 41   0 0     0   1   25 23                 48
1739013 1739013 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 6 0 19   0 0     0   0   16 9                       25 6 0 19   0 0     0   0   16 9                 25
1739016 1739016 CO     school 802580 40   School District 27J 80258000151 8130 Southeast Elementary School   Regular School No Elementary PK 05 2021   grade_3 21 0 44   0 0     0   1   41 25                       66 21 0 44   0 0     0   1   41 25                 66
1739018 1739018 CO     school 802580 40   School District 27J 80258000151 8130 Southeast Elementary School   Regular School No Elementary PK 05 2021   grade_5 31 2 51   0 0     0   2   46 40                       86 31 2 51   0 0     0   2   46 40                 86
1739021 1739021 CO     school 802580 40   School District 27J 80258000151 8130 Southeast Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 9 0 31   0 0     0   1   22 19                       41 9 0 31   0 0     0   1   22 19                 41
1739031 1739031 CO     school 802580 40   School District 27J 80258000152 9230 Vikan Middle School   Regular School No Middle 06 08 2021   grade_7 59 4 164   0 0     0   5   150 82                       232 59 4 164   0 0     0   5   150 82                 232
1739043 1739043 CO     school 802430 50   Bennett 29J 80243006789 562 Bennett Intermediate School   Regular School No Middle 04 06 2021   grade_5 50 1 31   0 0     0   4   37 49                       86 50 1 31   0 0     0   4   37 49                 86
1739044 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
1739046 1739046 CO     school 802430 50   Bennett 29J 80243001751 763 Bennett Preschool   Regular School No Prekindergarten PK PK 2021   pk_12_total 29 0 13   0 0     0   1   21 22                       43 29 0 13   0 0     0   1   21 22                 43
1739047 1739047 CO     school 802430 50   Bennett 29J 80243001751 763 Bennett Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 29 0 13   0 0     0   1   21 22                       43 29 0 13   0 0     0   1   21 22                 43
1739048 1739048 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   grade_1 43 4 31   0 0     1   5   50 34                       84 43 4 31   0 0     1   5   50 34                 84
1739049 1739049 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   grade_2 40 1 25   0 0     1   3   37 33                       70 40 1 25   0 0     1   3   37 33                 70
1739050 1739050 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   grade_3 37 0 31   0 0     1   5   39 35                       74 37 0 31   0 0     1   5   39 35                 74
1739051 1739051 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   kindergarten_full_day 42 1 32   0 0     1   3   38 41                       79 42 1 32   0 0     1   3   38 41                 79
1739052 1739052 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2021   pk_12_total 162 6 119   0 0     4   16   164 143                       307 162 6 119   0 0     4   16   164 143                 307
1739053 1739053 CO     school 802430 50   Bennett 29J 80243000093 774 Bennett Middle School   Regular School No Middle 07 08 2021   grade_7 46 1 43   0 0     0   3   42 51                       93 46 1 43   0 0     0   3   42 51                 93
1739054 1739054 CO     school 802430 50   Bennett 29J 80243000093 774 Bennett Middle School   Regular School No Middle 07 08 2021   grade_8 53 2 35   1 0     0   7   52 46                       98 53 2 35   1 0     0   7   52 46                 98
1739055 1739055 CO     school 802430 50   Bennett 29J 80243000093 774 Bennett Middle School   Regular School No Middle 07 08 2021   pk_12_total 99 3 78   1 0     0   10   94 97                       191 99 3 78   1 0     0   10   94 97                 191

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