enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1738523 1738523 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2021   grade_1 11 0 35   0 1     0   1   24 24                       48 11 0 35   0 1     0   1   24 24                 48
1738524 1738524 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2021   grade_2 7 0 38   0 1     0   2   23 25                       48 7 0 38   0 1     0   2   23 25                 48
1738525 1738525 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2021   grade_3 15 0 42   0 1     0   2   28 32                       60 15 0 42   0 1     0   2   28 32                 60
1738530 1738530 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2021   grade_1 34 0 31   0 1     0   4   32 38                       70 34 0 31   0 1     0   4   32 38                 70
1738531 1738531 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2021   grade_2 30 0 31   0 1     0   4   37 29                       66 30 0 31   0 1     0   4   37 29                 66
1738532 1738532 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2021   grade_3 21 0 39   0 4     0   5   38 31                       69 21 0 39   0 4     0   5   38 31                 69
1738533 1738533 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2021   grade_4 28 0 25   0 2     0   1   28 28                       56 28 0 25   0 2     0   1   28 28                 56
1738535 1738535 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 26 0 33   0 2     0   2   34 29                       63 26 0 33   0 2     0   2   34 29                 63
1738537 1738537 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 16 0 17   0 1     0   2   20 16                       36 16 0 17   0 1     0   2   20 16                 36
1738538 1738538 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_1 2 0 43   0 0     0   0   25 20                       45 2 0 43   0 0     0   0   25 20                 45
1738539 1738539 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_2 8 0 78   0 0     0   0   43 43                       86 8 0 78   0 0     0   0   43 43                 86
1738540 1738540 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_3 3 0 60   0 0     0   1   32 32                       64 3 0 60   0 0     0   1   32 32                 64
1738541 1738541 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_4 2 0 71   0 0     0   1   36 38                       74 2 0 71   0 0     0   1   36 38                 74
1738542 1738542 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   grade_5 2 0 75   0 0     0   1   37 41                       78 2 0 75   0 0     0   1   37 41                 78
1738543 1738543 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 7 0 58   0 0     0   0   32 33                       65 7 0 58   0 0     0   0   32 33                 65
1738565 1738565 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2021   grade_8 39 0 11   0 9     0   7   27 39                       66 39 0 11   0 9     0   7   27 39                 66
1738572 1738572 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2021   grade_10 2 0 21   0 0     0   0   12 11                       23 2 0 21   0 0     0   0   12 11                 23
1738590 1738590 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2021   grade_2 19 0 44   1 1     0   1   34 32                       66 19 0 44   1 1     0   1   34 32                 66
1738593 1738593 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2021   grade_5 16 0 39   0 0     0   5   30 30                       60 16 0 39   0 0     0   5   30 30                 60
1738602 1738602 CO     school 806900 20   Adams 12 Five Star Schools 80690001182 5706 McElwain Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 9 0 26   0 4     0   1   25 15                       40 9 0 26   0 4     0   1   25 15                 40
1738618 1738618 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2021   grade_1 57 0 18   0 1     0   6   40 42                       82 57 0 18   0 1     0   6   40 42                 82
1738619 1738619 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2021   grade_2 52 0 23   0 4     0   5   48 36                       84 52 0 23   0 4     0   5   48 36                 84
1738620 1738620 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2021   grade_3 53 0 22   0 2     0   7   47 37                       84 53 0 22   0 2     0   7   47 37                 84
1738621 1738621 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2021   grade_4 53 0 19   1 6     0   8   55 32                       87 53 0 19   1 6     0   8   55 32                 87
1738625 1738625 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 26 0 12   0 5     0   1   25 19                       44 26 0 12   0 5     0   1   25 19                 44
1738632 1738632 CO     school 806900 20   Adams 12 Five Star Schools 80690001184 6355 North Mor Elementary School   Regular School No Elementary PK 05 2021   grade_3 18 0 42   1 2     0   2   30 35                       65 18 0 42   1 2     0   2   30 35                 65
1738633 1738633 CO     school 806900 20   Adams 12 Five Star Schools 80690001184 6355 North Mor Elementary School   Regular School No Elementary PK 05 2021   grade_4 18 0 43   1 1     1   2   31 35                       66 18 0 43   1 1     1   2   31 35                 66
1738634 1738634 CO     school 806900 20   Adams 12 Five Star Schools 80690001184 6355 North Mor Elementary School   Regular School No Elementary PK 05 2021   grade_5 19 0 48   0 1     0   2   38 32                       70 19 0 48   0 1     0   2   38 32                 70
1738645 1738645 CO     school 806900 20   Adams 12 Five Star Schools 80690001185 6376 North Star Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 6 0 45   0 2     0   1   32 22                       54 6 0 45   0 2     0   1   32 22                 54
1738657 1738657 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2021   grade_11 80 0 17   0 2     0   7   49 57                       106 80 0 17   0 2     0   7   49 57                 106
1738659 1738659 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2021   grade_2 70 0 13   1 9     0   7   48 52                       100 70 0 13   1 9     0   7   48 52                 100
1738660 1738660 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2021   grade_3 69 0 13   0 13     1   4   45 55                       100 69 0 13   0 13     1   4   45 55                 100
1738662 1738662 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2021   grade_5 95 0 13   0 11     0   4   58 65                       123 95 0 13   0 11     0   4   58 65                 123
1738666 1738666 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2021   grade_9 94 0 27   0 6     0   13   71 69                       140 94 0 27   0 6     0   13   71 69                 140
1738667 1738667 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2021   kindergarten_full_day 56 0 7   0 14     0   9   45 41                       86 56 0 7   0 14     0   9   45 41                 86
1738670 1738670 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_11 12 0 6   0 0     0   0   10 8                       18 12 0 6   0 0     0   0   10 8                 18
1738672 1738672 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_6 5 0 2   0 0     0   0   7 0                       7 5 0 2   0 0     0   0   7 0                 7
1738673 1738673 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_7 4 0 3   0 0     0   0   6 1                       7 4 0 3   0 0     0   0   6 1                 7
1738675 1738675 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2021   grade_9 1 0 3   1 0     0   0   4 1                       5 1 0 3   1 0     0   0   4 1                 5
1738677 1738677 CO     school 806900 20   Adams 12 Five Star Schools 80690001945 7155 Prairie Hills Elementary School   Regular School No Elementary KG 05 2021   grade_1 57 0 9   1 5     0   5   40 37                       77 57 0 9   1 5     0   5   40 37                 77
1738680 1738680 CO     school 806900 20   Adams 12 Five Star Schools 80690001945 7155 Prairie Hills Elementary School   Regular School No Elementary KG 05 2021   grade_4 49 0 20   0 3     1   7   40 40                       80 49 0 20   0 3     1   7   40 40                 80
1738682 1738682 CO     school 806900 20   Adams 12 Five Star Schools 80690001945 7155 Prairie Hills Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 40 0 14   0 2     0   4   25 35                       60 40 0 14   0 2     0   4   25 35                 60
1738684 1738684 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2021   grade_1 62 0 12   0 10     0   6   51 39                       90 62 0 12   0 10     0   6   51 39                 90
1738685 1738685 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2021   grade_2 51 0 23   0 3     0   4   39 42                       81 51 0 23   0 3     0   4   39 42                 81
1738687 1738687 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2021   grade_4 56 0 25   0 13     0   1   49 46                       95 56 0 25   0 13     0   1   49 46                 95
1738691 1738691 CO     school 806900 20   Adams 12 Five Star Schools 80690006375 8211 The Studio School   Regular School No Elementary KG 05 2021   grade_1 21 0 21   0 1     0   3   13 33                       46 21 0 21   0 1     0   3   13 33                 46
1738692 1738692 CO     school 806900 20   Adams 12 Five Star Schools 80690006375 8211 The Studio School   Regular School No Elementary KG 05 2021   grade_2 24 0 20   0 1     0   3   16 32                       48 24 0 20   0 1     0   3   16 32                 48
1738702 1738702 CO     school 806900 20   Adams 12 Five Star Schools 80690006303 8225 Stellar Elementary School   Regular School No Elementary KG 05 2021   grade_5 30 0 41   0 5     0   6   42 40                       82 30 0 41   0 5     0   6   42 40                 82
1738707 1738707 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2021   grade_3 47 0 11   0 7     0   9   42 32                       74 47 0 11   0 7     0   9   42 32                 74
1738708 1738708 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2021   grade_4 55 0 14   0 3     0   4   41 35                       76 55 0 14   0 3     0   4   41 35                 76
1738709 1738709 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2021   grade_5 38 0 24   1 7     0   4   37 37                       74 38 0 24   1 7     0   4   37 37                 74
1738712 1738712 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2021   grade_8 41 0 26   0 4     0   2   44 29                       73 41 0 26   0 4     0   2   44 29                 73
1738713 1738713 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2021   kindergarten_full_day 43 0 15   0 3     1   4   40 26                       66 43 0 15   0 3     1   4   40 26                 66
1738716 1738716 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_1 18 0 65   0 0     0   2   50 35                       85 18 0 65   0 0     0   2   50 35                 85
1738717 1738717 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_2 13 0 61   0 1     0   1   40 36                       76 13 0 61   0 1     0   1   40 36                 76
1738718 1738718 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_3 14 0 66   1 0     0   2   51 32                       83 14 0 66   1 0     0   2   51 32                 83
1738720 1738720 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_5 14 0 69   0 0     0   0   42 41                       83 14 0 69   0 0     0   0   42 41                 83
1738721 1738721 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_6 19 0 93   0 1     0   3   57 59                       116 19 0 93   0 1     0   3   57 59                 116
1738722 1738722 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   grade_7 12 0 99   0 1     0   2   61 53                       114 12 0 99   0 1     0   2   61 53                 114
1738724 1738724 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2021   kindergarten_full_day 12 0 48   1 0     0   1   29 33                       62 12 0 48   1 0     0   1   29 33                 62
1738727 1738727 CO     school 806900 20   Adams 12 Five Star Schools 80690001190 8361 Stukey Elementary School   Regular School No Elementary KG 05 2021   grade_2 14 0 42   2 5     1   4   37 31                       68 14 0 42   2 5     1   4   37 31                 68
1738728 1738728 CO     school 806900 20   Adams 12 Five Star Schools 80690001190 8361 Stukey Elementary School   Regular School No Elementary KG 05 2021   grade_3 15 0 36   0 4     0   3   25 33                       58 15 0 36   0 4     0   3   25 33                 58
1738733 1738733 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2021   grade_1 49 0 5   0 5     1   7   34 33                       67 49 0 5   0 5     1   7   34 33                 67
1738734 1738734 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2021   grade_2 55 0 5   0 5     0   3   29 39                       68 55 0 5   0 5     0   3   29 39                 68
1738735 1738735 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2021   grade_3 66 0 9   0 4     1   1   45 36                       81 66 0 9   0 4     1   1   45 36                 81
1738736 1738736 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2021   grade_4 69 0 12   0 2     0   2   42 43                       85 69 0 12   0 2     0   2   42 43                 85
1738738 1738738 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2021   grade_6 62 0 9   0 1     0   6   42 36                       78 62 0 9   0 1     0   6   42 36                 78
1738739 1738739 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2021   grade_7 66 0 8   0 4     0   2   38 42                       80 66 0 8   0 4     0   2   38 42                 80
1738741 1738741 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2021   kindergarten_full_day 36 0 7   0 6     0   3   28 24                       52 36 0 7   0 6     0   3   28 24                 52
1738754 1738754 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2021   grade_11 10 0 5   0 2     0   1   13 5                       18 10 0 5   0 2     0   1   13 5                 18
1738755 1738755 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2021   grade_12 15 0 3   0 1     0   0   11 8                       19 15 0 3   0 1     0   0   11 8                 19
1738756 1738756 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2021   grade_2 30 0 6   0 3     0   1   20 20                       40 30 0 6   0 3     0   1   20 20                 40
1738758 1738758 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2021   grade_4 30 0 11   0 4     0   3   26 22                       48 30 0 11   0 4     0   3   26 22                 48
1738759 1738759 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2021   grade_5 34 0 9   0 5     0   2   31 19                       50 34 0 9   0 5     0   2   31 19                 50
1738763 1738763 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2021   grade_9 17 0 4   0 4     0   2   17 10                       27 17 0 4   0 4     0   2   17 10                 27
1738764 1738764 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2021   kindergarten_full_day 27 0 7   0 4     0   2   16 24                       40 27 0 7   0 4     0   2   16 24                 40
1738770 1738770 CO     school 806900 20   Adams 12 Five Star Schools 80690001195 9494 Westview Elementary School   Regular School No Elementary PK 05 2021   grade_1 22 0 35   0 1     0   4   31 31                       62 22 0 35   0 1     0   4   31 31                 62
1738771 1738771 CO     school 806900 20   Adams 12 Five Star Schools 80690001195 9494 Westview Elementary School   Regular School No Elementary PK 05 2021   grade_2 24 0 32   0 4     0   4   39 25                       64 24 0 32   0 4     0   4   39 25                 64
1738772 1738772 CO     school 806900 20   Adams 12 Five Star Schools 80690001195 9494 Westview Elementary School   Regular School No Elementary PK 05 2021   grade_3 28 0 31   1 3     0   4   33 34                       67 28 0 31   1 3     0   4   33 34                 67
1738778 1738778 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2021   grade_1 23 0 25   1 1     0   4   25 29                       54 23 0 25   1 1     0   4   25 29                 54
1738779 1738779 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2021   grade_2 23 0 33   1 5     0   5   33 34                       67 23 0 33   1 5     0   5   33 34                 67
1738780 1738780 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2021   grade_3 30 0 29   1 5     0   5   34 36                       70 30 0 29   1 5     0   5   34 36                 70
1738781 1738781 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2021   grade_4 39 0 27   1 1     1   5   39 35                       74 39 0 27   1 1     1   5   39 35                 74
1738782 1738782 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2021   grade_5 28 0 36   1 2     0   2   33 36                       69 28 0 36   1 2     0   2   33 36                 69
1738783 1738783 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 19 0 32   1 3     0   3   39 19                       58 19 0 32   1 3     0   3   39 19                 58
1738788 1738788 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_8 24 0 219   3 0     1   4   122 129                       251 24 0 219   3 0     1   4   122 129                 251
1738790 1738790 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_10 0 0 12   0 0     0   0   6 6                       12 0 0 12   0 0     0   0   6 6                 12
1738793 1738793 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
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
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
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
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
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
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
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

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