enrollments

Data source: Big Local News · About: Big Local

13,321 rows where state = "CO" and year = 2020 sorted by black_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 13,221 ✖
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
1799582 1799582 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2020   grade_1 8 0 42   0 1     0   2   27 26                       53 8 0 42   0 1     0   2   27 26                 53
1799583 1799583 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2020   grade_2 19 0 45   0 1     0   1   28 38                       66 19 0 45   0 1     0   1   28 38                 66
1799587 1799587 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 12 0 31   1 1     0   2   26 21                       47 12 0 31   1 1     0   2   26 21                 47
1799589 1799589 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2020   grade_1 33 0 33   2 1     0   2   39 32                       71 33 0 33   2 1     0   2   39 32                 71
1799590 1799590 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2020   grade_2 26 0 36   0 4     0   2   39 29                       68 26 0 36   0 4     0   2   39 29                 68
1799594 1799594 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 32 0 32   0 1     0   4   32 37                       69 32 0 32   0 1     0   4   32 37                 69
1799596 1799596 CO     school 806900 20   Adams 12 Five Star Schools 80690001461 2584 Riverdale Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 32 0 28   0 3     0   2   42 23                       65 32 0 28   0 3     0   2   42 23                 65
1799597 1799597 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   grade_1 8 0 79   0 0     0   0   47 40                       87 8 0 79   0 0     0   0   47 40                 87
1799598 1799598 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 0 64   0 0     0   1   33 35                       68 3 0 64   0 0     0   1   33 35                 68
1799599 1799599 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   grade_3 4 0 70   0 0     0   1   36 39                       75 4 0 70   0 0     0   1   36 39                 75
1799600 1799600 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   grade_4 2 0 72   0 0     0   0   32 42                       74 2 0 72   0 0     0   0   32 42                 74
1799601 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
1799602 1799602 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 3 0 50   0 0     0   0   27 26                       53 3 0 50   0 0     0   0   27 26                 53
1799603 1799603 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 28 0 468   0 4     0   2   246 256                       502 28 0 468   0 4     0   2   246 256                 502
1799604 1799604 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 5 0 45   0 4     0   0   26 28                       54 5 0 45   0 4     0   0   26 28                 54
1799623 1799623 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_7 42 0 10   0 9     0   9   29 41                       70 42 0 10   0 9     0   9   29 41                 70
1799632 1799632 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2020   grade_11 3 0 91   0 0     0   1   46 49                       95 3 0 91   0 0     0   1   46 49                 95
1799634 1799634 CO     school 806900 20   Adams 12 Five Star Schools 80690006480 4699 New America School - Thornton   Alternative School Yes High 09 12 2020   grade_9 2 0 16   0 0     0   0   12 6                       18 2 0 16   0 0     0   0   12 6                 18
1799646 1799646 CO     school 806900 20   Adams 12 Five Star Schools 80690001306 5058 Leroy Drive Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 16 0 43   0 4     1   3   44 23                       67 16 0 43   0 4     1   3   44 23                 67
1799649 1799649 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2020   grade_2 29 0 44   0 2     0   1   32 44                       76 29 0 44   0 2     0   1   32 44                 76
1799651 1799651 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2020   grade_4 16 0 35   0 0     0   4   27 28                       55 16 0 35   0 0     0   4   27 28                 55
1799655 1799655 CO     school 806900 20   Adams 12 Five Star Schools 80690001181 5418 Malley Drive Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 18 0 27   0 1     0   3   26 23                       49 18 0 27   0 1     0   3   26 23                 49
1799661 1799661 CO     school 806900 20   Adams 12 Five Star Schools 80690001182 5706 McElwain Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 12 0 49   1 13     0   3   43 35                       78 12 0 49   1 13     0   3   43 35                 78
1799677 1799677 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   grade_1 55 0 24   0 4     0   6   46 43                       89 55 0 24   0 4     0   6   46 43                 89
1799678 1799678 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   grade_2 63 0 20   0 3     0   7   54 39                       93 63 0 20   0 3     0   7   54 39                 93
1799679 1799679 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   grade_3 60 0 22   1 7     0   8   62 36                       98 60 0 22   1 7     0   8   62 36                 98
1799680 1799680 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   grade_4 61 0 25   0 5     0   5   48 48                       96 61 0 25   0 5     0   5   48 48                 96
1799681 1799681 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   grade_5 63 0 18   1 8     0   3   50 43                       93 63 0 18   1 8     0   3   50 43                 93
1799682 1799682 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 65 0 16   0 2     0   6   42 47                       89 65 0 16   0 2     0   6   42 47                 89
1799683 1799683 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 389 0 136   2 34     0   37   326 272                       598 389 0 136   2 34     0   37   326 272                 598
1799684 1799684 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 22 0 11   0 5     0   2   24 16                       40 22 0 11   0 5     0   2   24 16                 40
1799687 1799687 CO     school 806900 20   Adams 12 Five Star Schools 80690001186 6342 Shadow Ridge Middle School   Regular School No Middle 06 08 2020   grade_8 150 0 130   1 11     1   4   167 130                       297 150 0 130   1 11     1   4   167 130                 297
1799691 1799691 CO     school 806900 20   Adams 12 Five Star Schools 80690001184 6355 North Mor Elementary School   Regular School No Elementary PK 05 2020   grade_3 20 0 38   0 3     1   1   31 32                       63 20 0 38   0 3     1   1   31 32                 63
1799704 1799704 CO     school 806900 20   Adams 12 Five Star Schools 80690001185 6376 North Star Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 8 0 42   0 2     0   1   31 22                       53 8 0 42   0 2     0   1   31 22                 53
1799714 1799714 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_1 72 0 9   1 8     0   8   52 46                       98 72 0 9   1 8     0   8   52 46                 98
1799715 1799715 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_10 86 0 14   0 4     0   5   49 60                       109 86 0 14   0 4     0   5   49 60                 109
1799717 1799717 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_12 62 0 9   0 4     0   0   40 35                       75 62 0 9   0 4     0   0   40 35                 75
1799718 1799718 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_2 72 0 11   0 12     1   4   45 55                       100 72 0 11   0 12     1   4   45 55                 100
1799720 1799720 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_4 79 0 8   0 10     0   3   50 50                       100 79 0 8   0 10     0   3   50 50                 100
1799723 1799723 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_7 109 0 7   0 13     0   1   53 77                       130 109 0 7   0 13     0   1   53 77                 130
1799724 1799724 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_8 90 0 21   1 9     0   9   57 73                       130 90 0 21   1 9     0   9   57 73                 130
1799728 1799728 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2020   grade_10 3 0 2   0 0     0   0   3 2                       5 3 0 2   0 0     0   0   3 2                 5
1799731 1799731 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2020   grade_6 4 0 2   0 0     0   0   5 1                       6 4 0 2   0 0     0   0   5 1                 6
1799733 1799733 CO     school 806900 20   Adams 12 Five Star Schools 80690006550 6956 Pathways Future Center   Alternative School No Other KG 12 2020   grade_8 0 0 2   1 0     0   0   2 1                       3 0 0 2   1 0     0   0   2 1                 3
1799737 1799737 CO     school 806900 20   Adams 12 Five Star Schools 80690001945 7155 Prairie Hills Elementary School   Regular School No Elementary KG 05 2020   grade_2 47 0 13   1 8     0   1   38 32                       70 47 0 13   1 8     0   1   38 32                 70
1799741 1799741 CO     school 806900 20   Adams 12 Five Star Schools 80690001945 7155 Prairie Hills Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 63 0 9   0 6     0   4   39 43                       82 63 0 9   0 6     0   4   39 43                 82
1799743 1799743 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2020   grade_1 64 0 20   0 4     0   5   47 46                       93 64 0 20   0 4     0   5   47 46                 93
1799745 1799745 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2020   grade_3 64 0 23   0 14     0   2   51 52                       103 64 0 23   0 14     0   2   51 52                 103
1799748 1799748 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2020   kindergarten_full_day 71 0 7   0 9     0   2   48 41                       89 71 0 7   0 9     0   2   48 41                 89
1799755 1799755 CO     school 806900 20   Adams 12 Five Star Schools 80690006375 8211 The Studio School   Regular School No Elementary KG 05 2020   kindergarten_full_day 22 0 21   0 0     0   3   16 30                       46 22 0 21   0 0     0   3   16 30                 46
1799760 1799760 CO     school 806900 20   Adams 12 Five Star Schools 80690006303 8225 Stellar Elementary School   Regular School No Elementary KG 05 2020   grade_4 36 0 40   0 5     0   5   43 43                       86 36 0 40   0 5     0   5   43 43                 86
1799761 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
1799767 1799767 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_4 44 0 23   1 7     0   3   38 40                       78 44 0 23   1 7     0   3   38 40                 78
1799770 1799770 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_7 46 0 24   0 2     0   1   43 30                       73 46 0 24   0 2     0   1   43 30                 73
1799771 1799771 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_8 40 0 8   0 3     0   3   29 25                       54 40 0 8   0 3     0   3   29 25                 54
1799775 1799775 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_1 12 0 52   0 1     0   2   39 28                       67 12 0 52   0 1     0   2   39 28                 67
1799778 1799778 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_4 11 0 59   0 0     0   0   34 36                       70 11 0 59   0 0     0   0   34 36                 70
1799779 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
1799780 1799780 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_6 11 0 90   0 1     0   2   54 50                       104 11 0 90   0 1     0   2   54 50                 104
1799782 1799782 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_8 27 0 97   1 2     0   0   75 52                       127 27 0 97   1 2     0   0   75 52                 127
1799785 1799785 CO     school 806900 20   Adams 12 Five Star Schools 80690001190 8361 Stukey Elementary School   Regular School No Elementary KG 05 2020   grade_1 17 0 47   2 3     1   2   43 29                       72 17 0 47   2 3     1   2   43 29                 72
1799793 1799793 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_2 61 0 6   0 3     1   1   37 35                       72 61 0 6   0 3     1   1   37 35                 72
1799794 1799794 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_3 62 0 10   0 3     0   3   35 43                       78 62 0 10   0 3     0   3   35 43                 78
1799796 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
1799797 1799797 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_6 62 0 7   0 4     0   3   35 41                       76 62 0 7   0 4     0   3   35 41                 76
1799799 1799799 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_8 56 0 7   0 1     0   5   37 32                       69 56 0 7   0 1     0   5   37 32                 69
1799800 1799800 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   kindergarten_full_day 54 0 5   0 6     1   6   38 34                       72 54 0 5   0 6     1   6   38 34                 72
1799802 1799802 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   pre_kindergarten 50 0 7   1 24     0   5   57 30                       87 50 0 7   1 24     0   5   57 30                 87
1799811 1799811 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_1 39 0 9   0 2     0   1   24 27                       51 39 0 9   0 2     0   1   24 27                 51
1799812 1799812 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_10 10 0 5   0 3     0   2   15 5                       20 10 0 5   0 3     0   2   15 5                 20
1799813 1799813 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_11 18 0 3   0 1     0   1   13 10                       23 18 0 3   0 1     0   1   13 10                 23
1799814 1799814 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_12 13 0 3   0 1     0   0   9 8                       17 13 0 3   0 1     0   0   9 8                 17
1799816 1799816 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_3 25 0 11   0 1     0   3   21 19                       40 25 0 11   0 1     0   3   21 19                 40
1799817 1799817 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_4 35 0 10   0 6     0   2   29 24                       53 35 0 10   0 6     0   2   29 24                 53
1799823 1799823 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   kindergarten_full_day 38 0 9   0 4     0   1   21 31                       52 38 0 9   0 4     0   1   21 31                 52
1799829 1799829 CO     school 806900 20   Adams 12 Five Star Schools 80690001195 9494 Westview Elementary School   Regular School No Elementary PK 05 2020   grade_1 27 0 31   1 5     0   3   34 33                       67 27 0 31   1 5     0   3   34 33                 67
1799833 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
1799837 1799837 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_1 25 0 32   1 5     0   3   30 36                       66 25 0 32   1 5     0   3   30 36                 66
1799838 1799838 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_2 29 0 24   1 5     0   5   29 35                       64 29 0 24   1 5     0   5   29 35                 64
1799839 1799839 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_3 40 0 27   1 1     1   5   38 37                       75 40 0 27   1 1     1   5   38 37                 75
1799840 1799840 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_4 28 0 36   1 2     0   1   36 32                       68 28 0 36   1 2     0   1   36 32                 68
1799842 1799842 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 27 0 24   1 1     0   3   25 31                       56 27 0 24   1 1     0   3   25 31                 56
1799852 1799852 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2020   grade_9 0 0 5   0 0     0   0   3 2                       5 0 0 5   0 0     0   0   3 2                 5
1799859 1799859 CO     school 801950 30   Adams County 14 80195001947 124 Stars Early Learning Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 11 0 76   1 0     0   2   45 45                       90 11 0 76   1 0     0   2   45 45                 90
1799860 1799860 CO     school 801950 30   Adams County 14 80195001947 124 Stars Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 11 0 76   1 0     0   2   45 45                       90 11 0 76   1 0     0   2   45 45                 90
1799861 1799861 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2020   grade_1 10 0 54   0 0     0   0   37 27                       64 10 0 54   0 0     0   0   37 27                 64
1799864 1799864 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2020   grade_4 8 0 71   1 0     0   2   44 38                       82 8 0 71   1 0     0   2   44 38                 82
1799866 1799866 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 8 0 45   0 0     0   2   29 26                       55 8 0 45   0 0     0   2   29 26                 55
1799877 1799877 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2020   grade_3 7 0 66   0 0     0   1   44 30                       74 7 0 66   0 0     0   1   44 30                 74
1799880 1799880 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 5 0 57   0 0     0   0   32 30                       62 5 0 57   0 0     0   0   32 30                 62
1799886 1799886 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2020   grade_1 7 0 61   0 0     0   0   31 37                       68 7 0 61   0 0     0   0   31 37                 68
1799890 1799890 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2020   grade_5 7 0 64   1 0     0   0   38 34                       72 7 0 64   1 0     0   0   38 34                 72
1799896 1799896 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2020   grade_1 4 0 35   0 0     0   0   22 17                       39 4 0 35   0 0     0   0   22 17                 39
1799899 1799899 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2020   grade_4 10 0 48   0 0     0   0   32 26                       58 10 0 48   0 0     0   0   32 26                 58
1799901 1799901 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 6 0 31   0 0     0   0   24 13                       37 6 0 31   0 0     0   0   24 13                 37
1799904 1799904 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 0 41   0 0     0   0   25 19                       44 3 0 41   0 0     0   0   25 19                 44
1799905 1799905 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2020   grade_3 1 0 33   0 0     0   0   17 17                       34 1 0 33   0 0     0   0   17 17                 34
1799910 1799910 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 11 0 159   0 0     0   1   86 85                       171 11 0 159   0 0     0   1   86 85                 171
1799913 1799913 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2020   grade_3 5 0 41   0 0     0   0   25 21                       46 5 0 41   0 0     0   0   25 21                 46
1799914 1799914 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2020   grade_4 6 0 49   0 0     0   0   42 13                       55 6 0 49   0 0     0   0   42 13                 55

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