Data source: Big Local News · About: Big Local

13,413 rows where state = "CO" and year = 2019 sorted by school

View and edit SQL

year

  • 2019 · 13,413
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
1934995 CO     school 803360 880   DENVER COUNTY 1 80336006756 2994 5280 HIGH SCHOOL   Regular School Yes High 09 12 2019   grade_10 4 0 1   0 0     0   0   3 2                       5 4 0 1   0 0     0   0   3 2                 5
1934996 CO     school 803360 880   DENVER COUNTY 1 80336006756 2994 5280 HIGH SCHOOL   Regular School Yes High 09 12 2019   grade_11 5 0 1   0 0     0   0   4 2                       6 5 0 1   0 0     0   0   4 2                 6
1934997 CO     school 803360 880   DENVER COUNTY 1 80336006756 2994 5280 HIGH SCHOOL   Regular School Yes High 09 12 2019   grade_12 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1934998 CO     school 803360 880   DENVER COUNTY 1 80336006756 2994 5280 HIGH SCHOOL   Regular School Yes High 09 12 2019   grade_9 17 18 48   2 1     0   3   58 31                       89 17 18 48   2 1     0   3   58 31                 89
1934999 CO     school 803360 880   DENVER COUNTY 1 80336006756 2994 5280 HIGH SCHOOL   Regular School Yes High 09 12 2019   pk_12_total 26 18 51   2 1     0   3   66 35                       101 26 18 51   2 1     0   3   66 35                 101
1942660 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_10 14 0 16   1 0     0   1   22 10                       32 14 0 16   1 0     0   1   22 10                 32
1942661 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_11 18 0 11   0 0     0   0   10 19                       29 18 0 11   0 0     0   0   10 19                 29
1942662 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_12 26 0 26   0 0     0   3   33 22                       55 26 0 26   0 0     0   3   33 22                 55
1942663 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_2 2 0 1   0 0     0   1   2 2                       4 2 0 1   0 0     0   1   2 2                 4
1942664 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_3 1 0 1   0 0     0   0   0 2                       2 1 0 1   0 0     0   0   0 2                 2
1942665 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_4 2 1 0   0 0     0   0   1 2                       3 2 1 0   0 0     0   0   1 2                 3
1942666 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_5 1 0 2   0 0     0   0   1 2                       3 1 0 2   0 0     0   0   1 2                 3
1942667 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_6 7 0 3   0 0     0   0   8 2                       10 7 0 3   0 0     0   0   8 2                 10
1942668 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_7 2 0 11   0 0     0   1   6 8                       14 2 0 11   0 0     0   1   6 8                 14
1942669 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_8 16 0 3   0 0     0   3   13 9                       22 16 0 3   0 0     0   3   13 9                 22
1942670 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_9 8 0 9   0 0     0   2   13 6                       19 8 0 9   0 0     0   2   13 6                 19
1942671 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   pk_12_total 97 1 83   1 0     0   11   109 84                       193 97 1 83   1 0     0   11   109 84                 193
1934545 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_10 10 4 193   0 4     0   2   115 98                       213 10 4 193   0 4     0   2   115 98                 213
1934546 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_11 5 10 190   5 10     0   0   112 108                       220 5 10 190   5 10     0   0   112 108                 220
1934547 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_12 3 9 194   2 19     0   2   115 114                       229 3 9 194   2 19     0   2   115 114                 229
1934548 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 7 6 266   3 5     0   3   162 128                       290 7 6 266   3 5     0   3   162 128                 290
1934549 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   pk_12_total 25 29 843   10 38     0   7   504 448                       952 25 29 843   10 38     0   7   504 448                 952
1937222 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 62 16 16   1 0     1   15   53 58                       111 62 16 16   1 0     1   15   53 58                 111
1937223 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 33 12 18   1 2     0   12   44 34                       78 33 12 18   1 2     0   12   44 34                 78
1937224 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_3 36 12 13   3 1     3   7   41 34                       75 36 12 13   3 1     3   7   41 34                 75
1937225 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 27 8 17   1 0     4   2   36 23                       59 27 8 17   1 0     4   2   36 23                 59
1937226 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_5 24 9 13   1 0     5   6   28 30                       58 24 9 13   1 0     5   6   28 30                 58
1937227 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_full_day 55 9 41   1 1     1   11   64 55                       119 55 9 41   1 1     1   11   64 55                 119
1937228 CO     school 804080 1000   FOUNTAIN 8 80408000560 1334 ABRAMS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   pk_12_total 237 66 118   8 4     14   53   266 234                       500 237 66 118   8 4     14   53   266 234                 500
1935478 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   grade_1 19 0 40   2 0     0   0   30 31                       61 19 0 40   2 0     0   0   30 31                 61
1935479 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   grade_2 18 0 41   0 1     0   1   33 28                       61 18 0 41   0 1     0   1   33 28                 61
1935480 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   grade_3 19 2 21   0 1     0   2   28 17                       45 19 2 21   0 1     0   2   28 17                 45
1935481 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   grade_4 11 0 32   0 0     0   0   24 19                       43 11 0 32   0 0     0   0   24 19                 43
1935482 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   grade_5 11 1 27   0 1     0   0   17 23                       40 11 1 27   0 1     0   0   17 23                 40
1935483 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   grade_6 3 0 14   0 0     0   0   9 8                       17 3 0 14   0 0     0   0   9 8                 17
1935484 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   kindergarten_full_day 16 0 39   0 2     0   2   25 34                       59 16 0 39   0 2     0   2   25 34                 59
1935485 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   pk_12_total 132 3 271   2 7     0   7   210 212                       422 132 3 271   2 7     0   7   210 212                 422
1935486 CO     school 803360 880   DENVER COUNTY 1 80336001750 6397 ACADEMIA ANA MARIE SANDOVAL   Regular School No Elementary PK 06 2019   pre_kindergarten 35 0 57   0 2     0   2   44 52                       96 35 0 57   0 2     0   2   44 52                 96
1934561 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   grade_1 5 9 16   1 0     0   0   15 16                       31 5 9 16   1 0     0   0   15 16                 31
1934562 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   grade_2 3 4 9   0 0     0   1   6 11                       17 3 4 9   0 0     0   1   6 11                 17
1934563 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   grade_3 2 6 11   0 0     0   0   9 10                       19 2 6 11   0 0     0   0   9 10                 19
1934564 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   grade_4 5 4 8   0 0     0   1   13 5                       18 5 4 8   0 0     0   1   13 5                 18
1934565 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   grade_5 1 10 17   0 1     0   1   17 13                       30 1 10 17   0 1     0   1   17 13                 30
1934566 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   kindergarten_full_day 6 12 17   0 1     0   2   16 22                       38 6 12 17   0 1     0   2   16 22                 38
1934567 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   pk_12_total 30 63 95   1 2     0   6   91 106                       197 30 63 95   1 2     0   6   91 106                 197
1934568 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2019   pre_kindergarten 8 18 17   0 0     0   1   15 29                       44 8 18 17   0 0     0   1   15 29                 44
1935933 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_1 66 1 9   0 2     0   5   33 50                       83 66 1 9   0 2     0   5   33 50                 83
1935934 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 63 2 10   0 2     0   4   36 45                       81 63 2 10   0 2     0   4   36 45                 81
1935935 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_3 66 1 10   0 2     0   4   36 47                       83 66 1 10   0 2     0   4   36 47                 83
1935936 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_4 67 2 9   1 1     0   3   39 44                       83 67 2 9   1 1     0   3   39 44                 83
1935937 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_5 67 2 8   0 2     0   3   36 46                       82 67 2 8   0 2     0   3   36 46                 82
1935938 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_6 61 1 11   2 1     0   3   44 35                       79 61 1 11   2 1     0   3   44 35                 79
1935939 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_7 61 0 5   0 1     0   3   28 42                       70 61 0 5   0 1     0   3   28 42                 70
1935940 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_8 63 1 9   0 6     0   2   38 43                       81 63 1 9   0 6     0   2   38 43                 81
1935941 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   kindergarten_full_day 24 2 1   0 1     0   1   20 9                       29 24 2 1   0 1     0   1   20 9                 29
1935942 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   kindergarten_half_day 38 0 2   0 0     0   1   21 20                       41 38 0 2   0 0     0   1   21 20                 41
1935943 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   pk_12_total 576 12 74   3 18     0   29   331 381                       712 576 12 74   3 18     0   29   331 381                 712
1937764 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 48 1 7   0 4     0   5   33 32                       65 48 1 7   0 4     0   5   33 32                 65
1937765 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 60 2 7   0 3     0   8   34 46                       80 60 2 7   0 3     0   8   34 46                 80
1937766 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_3 60 2 7   0 0     0   3   31 41                       72 60 2 7   0 0     0   3   31 41                 72
1937767 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 46 1 7   0 3     0   12   34 35                       69 46 1 7   0 3     0   12   34 35                 69
1937768 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_5 75 1 5   1 4     1   10   47 50                       97 75 1 5   1 4     1   10   47 50                 97
1937769 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_full_day 27 1 5   0 0     0   4   21 16                       37 27 1 5   0 0     0   4   21 16                 37
1937770 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_half_day 10 0 5   0 0     0   1   8 8                       16 10 0 5   0 0     0   1   8 8                 16
1937771 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   pk_12_total 326 8 43   1 14     1   43   208 228                       436 326 8 43   1 14     1   43   208 228                 436
1937306 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_1 25 1 5   0 0     0   2   21 12                       33 25 1 5   0 0     0   2   21 12                 33
1937307 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 27 0 4   0 0     0   1   16 16                       32 27 0 4   0 0     0   1   16 16                 32
1937308 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_3 23 0 4   0 0     0   3   18 12                       30 23 0 4   0 0     0   3   18 12                 30
1937309 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_4 25 0 7   1 0     0   2   19 16                       35 25 0 7   1 0     0   2   19 16                 35
1937310 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_5 29 1 6   1 0     0   1   15 23                       38 29 1 6   1 0     0   1   15 23                 38
1937311 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_6 33 0 1   1 0     0   1   27 9                       36 33 0 1   1 0     0   1   27 9                 36
1937312 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_7 23 0 3   0 0     0   4   15 15                       30 23 0 3   0 0     0   4   15 15                 30
1937313 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   grade_8 25 0 4   0 0     0   3   18 14                       32 25 0 4   0 0     0   3   18 14                 32
1937314 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   kindergarten_full_day 11 0 3   0 1     0   2   7 10                       17 11 0 3   0 1     0   2   7 10                 17
1937315 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   kindergarten_half_day 14 0 1   0 0     0   1   6 10                       16 14 0 1   0 0     0   1   6 10                 16
1937316 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2019   pk_12_total 235 2 38   3 1     0   20   162 137                       299 235 2 38   3 1     0   20   162 137                 299
1930972 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_10 9 2 107   0 2     0   3   63 60                       123 9 2 107   0 2     0   3   63 60                 123
1930973 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_11 7 2 85   1 1     0   5   55 46                       101 7 2 85   1 1     0   5   55 46                 101
1930974 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_12 12 2 76   2 1     0   2   63 32                       95 12 2 76   2 1     0   2   63 32                 95
1930975 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 14 0 98   0 0     0   4   60 56                       116 14 0 98   0 0     0   4   60 56                 116
1930976 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   pk_12_total 42 6 366   3 4     0   14   241 194                       435 42 6 366   3 4     0   14   241 194                 435
1937772 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 49 2 16   1 11     1   9   46 43                       89 49 2 16   1 11     1   9   46 43                 89
1937773 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 62 4 12   0 15     0   10   48 55                       103 62 4 12   0 15     0   10   48 55                 103
1937774 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_3 55 5 11   0 11     0   6   44 44                       88 55 5 11   0 11     0   6   44 44                 88
1937775 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 56 3 7   0 15     1   10   43 49                       92 56 3 7   0 15     1   10   43 49                 92
1937776 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_5 65 2 13   0 13     0   4   42 55                       97 65 2 13   0 13     0   4   42 55                 97
1937777 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   kindergarten_full_day 31 3 6   1 12     1   6   26 34                       60 31 3 6   1 12     1   6   26 34                 60
1937778 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   kindergarten_half_day 14 0 1   0 1     0   2   9 9                       18 14 0 1   0 1     0   2   9 9                 18
1937779 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pk_12_total 332 19 66   2 78     3   47   258 289                       547 332 19 66   2 78     3   47   258 289                 547
1932693 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_1 8 25 35   0 2     0   8   31 47                       78 8 25 35   0 2     0   8   31 47                 78
1932694 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 11 24 35   1 2     0   6   37 42                       79 11 24 35   1 2     0   6   37 42                 79
1932695 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_3 9 30 53   2 0     0   3   55 42                       97 9 30 53   2 0     0   3   55 42                 97
1932696 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_4 6 27 53   0 0     0   9   52 43                       95 6 27 53   0 0     0   9   52 43                 95
1932697 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_5 7 26 50   0 2     0   9   44 50                       94 7 26 50   0 2     0   9   44 50                 94
1932698 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_6 10 16 59   1 1     0   6   36 57                       93 10 16 59   1 1     0   6   36 57                 93
1932699 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_7 8 13 44   0 0     0   5   39 31                       70 8 13 44   0 0     0   5   39 31                 70
1932700 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_8 1 3 13   0 0     0   1   6 12                       18 1 3 13   0 0     0   1   6 12                 18
1932701 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   kindergarten_full_day 12 23 37   0 0     0   4   38 38                       76 12 23 37   0 0     0   4   38 38                 76
1932702 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   pk_12_total 72 187 379   4 7     0   51   338 362                       700 72 187 379   4 7     0   51   338 362                 700
1943991 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_1 34 3 5   0 1     0   1   19 25                       44 34 3 5   0 1     0   1   19 25                 44

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