enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 13,321 ✖
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
1803313 1803313 CO     school 803360 880   Denver County 1 80336006756 2994 5280 High School   Regular School Yes High 09 12 2020   grade_10 12 8 13   1 2     0   1   21 16                       37 12 8 13   1 2     0   1   21 16                 37
1803314 1803314 CO     school 803360 880   Denver County 1 80336006756 2994 5280 High School   Regular School Yes High 09 12 2020   grade_11 7 0 1   0 0     0   0   3 5                       8 7 0 1   0 0     0   0   3 5                 8
1803315 1803315 CO     school 803360 880   Denver County 1 80336006756 2994 5280 High School   Regular School Yes High 09 12 2020   grade_9 10 3 35   0 0     0   2   31 19                       50 10 3 35   0 0     0   2   31 19                 50
1803316 1803316 CO     school 803360 880   Denver County 1 80336006756 2994 5280 High School   Regular School Yes High 09 12 2020   pk_12_total 29 11 49   1 2     0   3   55 40                       95 29 11 49   1 2     0   3   55 40                 95
1810904 1810904 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_10 21 0 10   0 0     0   1   21 11                       32 21 0 10   0 0     0   1   21 11                 32
1810905 1810905 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_11 20 0 20   1 0     0   3   30 14                       44 20 0 20   1 0     0   3   30 14                 44
1810906 1810906 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_12 28 1 20   0 0     0   3   23 29                       52 28 1 20   0 0     0   3   23 29                 52
1810907 1810907 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_2 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
1810908 1810908 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_3 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
1810909 1810909 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_4 2 0 1   0 0     0   0   1 2                       3 2 0 1   0 0     0   0   1 2                 3
1810910 1810910 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_5 4 0 1   0 0     0   0   0 5                       5 4 0 1   0 0     0   0   0 5                 5
1810911 1810911 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_6 6 0 7   0 0     0   1   8 6                       14 6 0 7   0 0     0   1   8 6                 14
1810912 1810912 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_7 14 0 6   0 0     0   2   16 6                       22 14 0 6   0 0     0   2   16 6                 22
1810913 1810913 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_8 7 1 10   0 0     0   4   10 12                       22 7 1 10   0 0     0   4   10 12                 22
1810914 1810914 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_9 11 0 7   0 0     0   3   13 8                       21 11 0 7   0 0     0   3   13 8                 21
1810915 1810915 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   pk_12_total 115 2 82   1 0     0   18   123 95                       218 115 2 82   1 0     0   18   123 95                 218
1801665 1801665 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_10 74 7 161   1 1     0   2   116 130                       246 74 7 161   1 1     0   2   116 130                 246
1801666 1801666 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_11 118 15 235   0 0     2   3   178 195                       373 118 15 235   0 0     2   3   178 195                 373
1801667 1801667 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_12 148 27 420   2 1     3   7   319 289                       608 148 27 420   2 1     3   7   319 289                 608
1801668 1801668 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_6 20 5 34   1 0     0   1   39 22                       61 20 5 34   1 0     0   1   39 22                 61
1801669 1801669 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_7 27 4 76   0 0     0   2   48 61                       109 27 4 76   0 0     0   2   48 61                 109
1801670 1801670 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_8 69 6 130   1 1     0   3   102 108                       210 69 6 130   1 1     0   3   102 108                 210
1801671 1801671 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   grade_9 62 6 117   1 0     0   3   95 94                       189 62 6 117   1 0     0   3   95 94                 189
1801672 1801672 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2020   pk_12_total 518 70 1173   6 3     5   21   897 899                       1796 518 70 1173   6 3     5   21   897 899                 1796
1806477 1806477 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2020   grade_2 14 0 6   0 0     0   4   11 13                       24 14 0 6   0 0     0   4   11 13                 24
1806478 1806478 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2020   grade_3 17 1 4   0 0     0   2   12 12                       24 17 1 4   0 0     0   2   12 12                 24
1806479 1806479 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2020   grade_4 30 2 7   0 0     1   4   21 23                       44 30 2 7   0 0     1   4   21 23                 44
1806480 1806480 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2020   grade_5 16 2 6   1 0     0   4   12 17                       29 16 2 6   1 0     0   4   12 17                 29
1806481 1806481 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2020   pk_12_total 77 5 23   1 0     1   14   56 65                       121 77 5 23   1 0     1   14   56 65                 121
1801042 1801042 CO     school 802340 180   Adams-Arapahoe 28J 80234006625 136 APS Early Beginnings - A Zoom Site   Regular School No Prekindergarten PK PK 2020   pk_12_total 0 7 24   0 0     0   4   17 18                       35 0 7 24   0 0     0   4   17 18                 35
1801043 1801043 CO     school 802340 180   Adams-Arapahoe 28J 80234006625 136 APS Early Beginnings - A Zoom Site   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 0 7 24   0 0     0   4   17 18                       35 0 7 24   0 0     0   4   17 18                 35
1801044 1801044 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_1 14 13 11   1 1     0   5   20 25                       45 14 13 11   1 1     0   5   20 25                 45
1801045 1801045 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_2 9 7 20   0 0     2   4   23 19                       42 9 7 20   0 0     2   4   23 19                 42
1801046 1801046 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_3 9 21 17   1 1     0   0   26 23                       49 9 21 17   1 1     0   0   26 23                 49
1801047 1801047 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_4 10 15 21   0 0     0   6   28 24                       52 10 15 21   0 0     0   6   28 24                 52
1801048 1801048 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_5 14 14 14   0 0     0   1   18 25                       43 14 14 14   0 0     0   1   18 25                 43
1801049 1801049 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_6 9 19 21   0 0     1   4   32 22                       54 9 19 21   0 0     1   4   32 22                 54
1801050 1801050 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_7 9 14 22   0 1     1   6   31 22                       53 9 14 22   0 1     1   6   31 22                 53
1801051 1801051 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_8 11 13 21   1 2     0   3   23 28                       51 11 13 21   1 2     0   3   23 28                 51
1801052 1801052 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   kindergarten_full_day 9 11 13   1 0     1   2   21 16                       37 9 11 13   1 0     1   2   21 16                 37
1801053 1801053 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   pk_12_total 100 132 168   4 5     5   31   231 214                       445 100 132 168   4 5     5   31   231 214                 445
1801054 1801054 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   pre_kindergarten 6 5 8   0 0     0   0   9 10                       19 6 5 8   0 0     0   0   9 10                 19
1802855 1802855 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   grade_10 6 3 225   2 4     0   2   125 117                       242 6 3 225   2 4     0   2   125 117                 242
1802856 1802856 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   grade_11 10 4 165   1 5     0   1   99 87                       186 10 4 165   1 5     0   1   99 87                 186
1802857 1802857 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   grade_12 4 12 166   5 12     0   0   100 99                       199 4 12 166   5 12     0   0   100 99                 199
1802858 1802858 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   grade_9 9 20 302   4 7     0   2   202 142                       344 9 20 302   4 7     0   2   202 142                 344
1802859 1802859 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   pk_12_total 29 39 858   12 28     0   5   526 445                       971 29 39 858   12 28     0   5   526 445                 971
1805516 1805516 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   grade_1 35 10 35   1 2     2   9   46 48                       94 35 10 35   1 2     2   9   46 48                 94
1805517 1805517 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   grade_2 48 20 24   3 0     0   9   50 54                       104 48 20 24   3 0     0   9   50 54                 104
1805518 1805518 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   grade_3 21 14 15   2 1     1   9   32 31                       63 21 14 15   2 1     1   9   32 31                 63
1805519 1805519 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   grade_4 28 8 10   1 1     1   4   31 22                       53 28 8 10   1 1     1   4   31 22                 53
1805520 1805520 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   grade_5 20 9 10   1 0     2   4   26 20                       46 20 9 10   1 0     2   4   26 20                 46
1805521 1805521 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 49 19 25   1 1     3   9   58 49                       107 49 19 25   1 1     3   9   58 49                 107
1805522 1805522 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 201 80 119   9 5     9   44   243 224                       467 201 80 119   9 5     9   44   243 224                 467
1803798 1803798 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   grade_1 16 0 34   0 2     0   2   24 30                       54 16 0 34   0 2     0   2   24 30                 54
1803799 1803799 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   grade_2 18 0 35   2 0     0   0   26 29                       55 18 0 35   2 0     0   0   26 29                 55
1803800 1803800 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   grade_3 18 0 38   0 1     0   1   31 27                       58 18 0 38   0 1     0   1   31 27                 58
1803801 1803801 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   grade_4 17 1 16   0 1     0   2   23 14                       37 17 1 16   0 1     0   2   23 14                 37
1803802 1803802 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   grade_5 11 0 27   0 0     0   2   20 20                       40 11 0 27   0 0     0   2   20 20                 40
1803803 1803803 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   grade_6 4 0 18   0 0     0   0   12 10                       22 4 0 18   0 0     0   0   12 10                 22
1803804 1803804 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   kindergarten_full_day 21 0 35   0 2     0   0   23 35                       58 21 0 35   0 2     0   0   23 35                 58
1803805 1803805 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   pk_12_total 140 1 259   2 9     0   12   204 219                       423 140 1 259   2 9     0   12   204 219                 423
1803806 1803806 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   pre_kindergarten 35 0 56   0 3     0   5   45 54                       99 35 0 56   0 3     0   5   45 54                 99
1802871 1802871 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   grade_1 8 10 15   0 1     1   1   20 16                       36 8 10 15   0 1     1   1   20 16                 36
1802872 1802872 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   grade_2 5 9 14   1 0     0   1   16 14                       30 5 9 14   1 0     0   1   16 14                 30
1802873 1802873 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   grade_3 3 3 7   0 0     0   1   6 8                       14 3 3 7   0 0     0   1   6 8                 14
1802874 1802874 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   grade_4 1 3 13   0 0     0   0   8 9                       17 1 3 13   0 0     0   0   8 9                 17
1802875 1802875 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   grade_5 5 5 7   0 0     0   1   12 6                       18 5 5 7   0 0     0   1   12 6                 18
1802876 1802876 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   kindergarten_full_day 5 15 17   0 0     0   1   13 25                       38 5 15 17   0 0     0   1   13 25                 38
1802877 1802877 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   pk_12_total 35 63 101   1 1     1   6   92 116                       208 35 63 101   1 1     1   6   92 116                 208
1802878 1802878 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   pre_kindergarten 8 18 28   0 0     0   1   17 38                       55 8 18 28   0 0     0   1   17 38                 55
1804246 1804246 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_1 63 3 4   0 1     0   1   43 29                       72 63 3 4   0 1     0   1   43 29                 72
1804247 1804247 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_2 72 2 10   1 4     0   6   42 53                       95 72 2 10   1 4     0   6   42 53                 95
1804248 1804248 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_3 63 1 10   0 2     0   4   35 45                       80 63 1 10   0 2     0   4   35 45                 80
1804249 1804249 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_4 69 1 9   0 2     0   4   36 49                       85 69 1 9   0 2     0   4   36 49                 85
1804250 1804250 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_5 61 0 10   0 2     0   5   34 44                       78 61 0 10   0 2     0   5   34 44                 78
1804251 1804251 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_6 81 2 11   0 3     0   2   42 57                       99 81 2 11   0 3     0   2   42 57                 99
1804252 1804252 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_7 64 1 10   2 3     0   3   48 35                       83 64 1 10   2 3     0   3   48 35                 83
1804253 1804253 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_8 49 1 7   0 0     0   3   18 42                       60 49 1 7   0 0     0   3   18 42                 60
1804254 1804254 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   kindergarten_full_day 56 0 5   0 0     0   5   37 29                       66 56 0 5   0 0     0   5   37 29                 66
1804255 1804255 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   kindergarten_half_day 24 0 2   0 0     0   1   12 15                       27 24 0 2   0 0     0   1   12 15                 27
1804256 1804256 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   pk_12_total 602 11 78   3 17     0   34   347 398                       745 602 11 78   3 17     0   34   347 398                 745
1806067 1806067 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_1 41 1 8   0 0     0   5   31 24                       55 41 1 8   0 0     0   5   31 24                 55
1806068 1806068 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_2 48 1 7   0 4     0   7   33 34                       67 48 1 7   0 4     0   7   33 34                 67
1806069 1806069 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_3 61 2 8   0 3     0   9   35 48                       83 61 2 8   0 3     0   9   35 48                 83
1806070 1806070 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_4 60 2 7   0 0     0   3   33 39                       72 60 2 7   0 0     0   3   33 39                 72
1806071 1806071 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_5 52 1 10   0 2     0   10   38 37                       75 52 1 10   0 2     0   10   38 37                 75
1806072 1806072 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 39 1 18   1 1     0   3   29 34                       63 39 1 18   1 1     0   3   29 34                 63
1806073 1806073 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 301 8 58   1 10     0   37   199 216                       415 301 8 58   1 10     0   37   199 216                 415
1799325 1799325 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   grade_10 15 0 106   0 0     0   3   63 61                       124 15 0 106   0 0     0   3   63 61                 124
1799326 1799326 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   grade_11 7 2 96   0 2     0   3   58 52                       110 7 2 96   0 2     0   3   58 52                 110
1799327 1799327 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   grade_12 11 1 77   1 1     0   5   51 45                       96 11 1 77   1 1     0   5   51 45                 96
1799328 1799328 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   grade_9 11 2 118   0 2     0   4   88 49                       137 11 2 118   0 2     0   4   88 49                 137
1799329 1799329 CO     school 805550 10   Mapleton 1 80555001872 309 Academy High School   Regular School No High 09 12 2020   pk_12_total 44 5 397   1 5     0   15   260 207                       467 44 5 397   1 5     0   15   260 207                 467
1806074 1806074 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_1 45 3 7   1 11     1   9   36 41                       77 45 3 7   1 11     1   9   36 41                 77
1806075 1806075 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_2 54 1 12   1 11     2   10   48 43                       91 54 1 12   1 11     2   10   48 43                 91
1806076 1806076 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_3 59 5 14   0 13     0   10   47 54                       101 59 5 14   0 13     0   10   47 54                 101
1806077 1806077 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_4 51 2 10   0 13     0   7   37 46                       83 51 2 10   0 13     0   7   37 46                 83
1806078 1806078 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_5 63 2 9   0 13     2   10   48 51                       99 63 2 9   0 13     2   10   48 51                 99
1806079 1806079 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 42 4 8   1 6     0   8   34 35                       69 42 4 8   1 6     0   8   34 35                 69

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