Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1804668 CO     school 803450 900   Douglas County Re 1 80345006372 5405 eDCSD   Regular School No Other KG 12 2020   grade_10 6 0 1   0 0     0   0   1 6                       7 6 0 1   0 0     0   0   1 6                 7
1804669 CO     school 803450 900   Douglas County Re 1 80345006372 5405 eDCSD   Regular School No Other KG 12 2020   grade_11 8 0 1   0 0     0   2   1 10                       11 8 0 1   0 0     0   2   1 10                 11
1804670 CO     school 803450 900   Douglas County Re 1 80345006372 5405 eDCSD   Regular School No Other KG 12 2020   grade_12 12 0 1   0 0     0   0   2 11                       13 12 0 1   0 0     0   0   2 11                 13
1804671 CO     school 803450 900   Douglas County Re 1 80345006372 5405 eDCSD   Regular School No Other KG 12 2020   grade_9 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
1804672 CO     school 803450 900   Douglas County Re 1 80345006372 5405 eDCSD   Regular School No Other KG 12 2020   pk_12_total 30 0 3   0 0     0   2   6 29                       35 30 0 3   0 0     0   2   6 29                 35
1808723 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   grade_1 64 2 9   0 11     0   7   50 43                       93 64 2 9   0 11     0   7   50 43                 93
1808724 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   grade_2 77 2 5   0 8     0   12   60 44                       104 77 2 5   0 8     0   12   60 44                 104
1808725 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   grade_3 74 0 3   0 10     0   3   46 44                       90 74 0 3   0 10     0   3   46 44                 90
1808726 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   grade_4 68 2 3   0 6     0   8   45 42                       87 68 2 3   0 6     0   8   45 42                 87
1808727 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   grade_5 93 2 8   0 9     0   13   73 52                       125 93 2 8   0 9     0   13   73 52                 125
1808728 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 46 1 5   0 6     0   5   30 33                       63 46 1 5   0 6     0   5   30 33                 63
1808729 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 422 9 33   0 50     0   48   304 258                       562 422 9 33   0 50     0   48   304 258                 562
1812131 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   grade_5 28 0 30   0 0     0   0   30 28                       58 28 0 30   0 0     0   0   30 28                 58
1812132 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   grade_6 25 0 43   0 0     0   0   31 37                       68 25 0 43   0 0     0   0   31 37                 68
1812133 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   grade_7 37 0 34   0 0     0   0   34 37                       71 37 0 34   0 0     0   0   34 37                 71
1812134 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   grade_8 33 0 38   0 0     0   0   32 39                       71 33 0 38   0 0     0   0   32 39                 71
1812135 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   pk_12_total 123 0 145   0 0     0   0   127 141                       268 123 0 145   0 0     0   0   127 141                 268
1812142 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2020   grade_10 26 0 32   0 1     0   0   28 31                       59 26 0 32   0 1     0   0   28 31                 59
1812143 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2020   grade_11 41 1 34   0 0     0   0   38 38                       76 41 1 34   0 0     0   0   38 38                 76
1812144 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2020   grade_12 17 0 29   0 0     0   0   23 23                       46 17 0 29   0 0     0   0   23 23                 46
1812145 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2020   grade_9 30 0 39   0 0     0   1   36 34                       70 30 0 39   0 0     0   1   36 34                 70
1812146 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2020   pk_12_total 114 1 134   0 1     0   1   125 126                       251 114 1 134   0 1     0   1   125 126                 251
1799351 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_1 8 1 46   0 3     0   0   29 29                       58 8 1 46   0 3     0   0   29 29                 58
1799352 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_10 5 1 72   0 2     0   0   36 44                       80 5 1 72   0 2     0   0   36 44                 80
1799353 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_11 4 1 58   0 2     0   4   31 38                       69 4 1 58   0 2     0   4   31 38                 69
1799354 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_12 3 0 63   0 2     0   3   33 38                       71 3 0 63   0 2     0   3   33 38                 71
1799355 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_2 4 0 47   0 1     0   2   32 22                       54 4 0 47   0 1     0   2   32 22                 54
1799356 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_3 4 0 47   0 1     0   2   30 24                       54 4 0 47   0 1     0   2   30 24                 54
1799357 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_4 4 1 43   0 2     0   2   29 23                       52 4 1 43   0 2     0   2   29 23                 52
1799358 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_5 3 1 52   0 1     0   2   30 29                       59 3 1 52   0 1     0   2   30 29                 59
1799359 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_6 6 2 50   0 2     0   0   32 28                       60 6 2 50   0 2     0   0   32 28                 60
1799360 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_7 5 1 50   0 1     0   1   28 30                       58 5 1 50   0 1     0   1   28 30                 58
1799361 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_8 7 1 48   0 2     0   0   31 27                       58 7 1 48   0 2     0   0   31 27                 58
1799362 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_9 5 2 69   1 5     0   0   42 40                       82 5 2 69   1 5     0   0   42 40                 82
1799363 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   kindergarten_full_day 3 0 33   0 1     0   1   22 16                       38 3 0 33   0 1     0   1   22 16                 38
1799364 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   pk_12_total 61 11 678   1 25     0   17   405 388                       793 61 11 678   1 25     0   17   405 388                 793
1812615 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   grade_10 18 0 10   1 0     0   0   12 17                       29 18 0 10   1 0     0   0   12 17                 29
1812616 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   grade_11 24 0 20   0 0     1   1   24 22                       46 24 0 20   0 0     1   1   24 22                 46
1812617 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   grade_12 34 0 46   3 0     0   0   41 42                       83 34 0 46   3 0     0   0   41 42                 83
1812618 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   grade_9 4 1 5   0 0     0   0   4 6                       10 4 1 5   0 0     0   0   4 6                 10
1812619 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   pk_12_total 80 1 81   4 0     1   1   81 87                       168 80 1 81   4 0     1   1   81 87                 168
1811186 CO     school 806660 2770   Steamboat Springs RE-2 80666001924 9757 Yampa Valley High School   Alternative School No High 09 12 2020   grade_10 4 0 1   0 0     0   0   2 3                       5 4 0 1   0 0     0   0   2 3                 5
1811187 CO     school 806660 2770   Steamboat Springs RE-2 80666001924 9757 Yampa Valley High School   Alternative School No High 09 12 2020   grade_11 8 0 3   0 0     0   0   5 6                       11 8 0 3   0 0     0   0   5 6                 11
1811188 CO     school 806660 2770   Steamboat Springs RE-2 80666001924 9757 Yampa Valley High School   Alternative School No High 09 12 2020   grade_12 8 0 1   0 0     0   0   5 4                       9 8 0 1   0 0     0   0   5 4                 9
1811189 CO     school 806660 2770   Steamboat Springs RE-2 80666001924 9757 Yampa Valley High School   Alternative School No High 09 12 2020   grade_9 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1811190 CO     school 806660 2770   Steamboat Springs RE-2 80666001924 9757 Yampa Valley High School   Alternative School No High 09 12 2020   pk_12_total 22 0 5   0 0     0   0   13 14                       27 22 0 5   0 0     0   0   13 14                 27
1801495 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 12 27   1 4     0   10   35 31                       66 12 12 27   1 4     0   10   35 31                 66
1801496 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   grade_2 10 18 43   0 4     0   6   36 45                       81 10 18 43   0 4     0   6   36 45                 81
1801497 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   grade_3 20 14 35   0 3     0   8   43 37                       80 20 14 35   0 3     0   8   43 37                 80
1801498 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   grade_4 5 15 43   0 0     1   8   38 34                       72 5 15 43   0 0     1   8   38 34                 72
1801499 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   grade_5 16 14 34   1 1     0   7   33 40                       73 16 14 34   1 1     0   7   33 40                 73
1801500 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 15 11 36   1 4     0   3   42 28                       70 15 11 36   1 4     0   3   42 28                 70
1801501 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 87 87 232   3 16     1   43   243 226                       469 87 87 232   3 16     1   43   243 226                 469
1801502 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 9 3 14   0 0     0   1   16 11                       27 9 3 14   0 0     0   1   16 11                 27
1804223 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   grade_1 3 10 11   0 0     0   0   10 14                       24 3 10 11   0 0     0   0   10 14                 24
1804224 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   grade_2 3 6 17   0 0     0   0   10 16                       26 3 6 17   0 0     0   0   10 16                 26
1804225 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   grade_3 1 7 27   0 0     0   1   20 16                       36 1 7 27   0 0     0   1   20 16                 36
1804226 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   grade_4 3 8 19   0 0     0   1   18 13                       31 3 8 19   0 0     0   1   18 13                 31
1804227 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   grade_5 0 4 24   0 0     0   0   17 11                       28 0 4 24   0 0     0   0   17 11                 28
1804228 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   kindergarten_full_day 7 5 21   0 0     0   0   15 18                       33 7 5 21   0 0     0   0   15 18                 33
1804229 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   pk_12_total 17 40 119   0 0     0   2   90 88                       178 17 40 119   0 0     0   2   90 88                 178
1812159 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray High School   Regular School No High 09 12 2020   grade_10 40 0 17   0 0     0   0   25 32                       57 40 0 17   0 0     0   0   25 32                 57
1812160 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray High School   Regular School No High 09 12 2020   grade_11 36 0 17   0 0     0   2   30 25                       55 36 0 17   0 0     0   2   30 25                 55
1812161 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray High School   Regular School No High 09 12 2020   grade_12 23 0 13   0 0     0   1   23 14                       37 23 0 13   0 0     0   1   23 14                 37
1812162 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray High School   Regular School No High 09 12 2020   grade_9 35 0 13   1 0     0   1   27 23                       50 35 0 13   1 0     0   1   27 23                 50
1812163 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray High School   Regular School No High 09 12 2020   pk_12_total 134 0 60   1 0     0   4   105 94                       199 134 0 60   1 0     0   4   105 94                 199
1812147 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 04 2020   grade_1 38 0 9   0 0     0   0   26 21                       47 38 0 9   0 0     0   0   26 21                 47
1812148 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 04 2020   grade_2 41 0 19   0 0     0   0   33 27                       60 41 0 19   0 0     0   0   33 27                 60
1812149 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 04 2020   grade_3 36 0 25   0 0     0   0   25 36                       61 36 0 25   0 0     0   0   25 36                 61
1812150 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 04 2020   grade_4 42 0 16   0 0     0   0   36 22                       58 42 0 16   0 0     0   0   36 22                 58
1812151 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 04 2020   kindergarten_full_day 39 0 16   0 0     0   2   27 30                       57 39 0 16   0 0     0   2   27 30                 57
1812152 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 04 2020   pk_12_total 224 0 108   0 0     0   3   174 161                       335 224 0 108   0 0     0   3   174 161                 335
1812153 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 28 0 23   0 0     0   1   27 25                       52 28 0 23   0 0     0   1   27 25                 52
1804954 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_1 55 1 16   0 2     0   7   46 35                       81 55 1 16   0 2     0   7   46 35                 81
1804955 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_2 53 2 9   0 3     0   8   40 35                       75 53 2 9   0 3     0   8   40 35                 75
1804956 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_3 60 1 13   0 4     0   4   39 43                       82 60 1 13   0 4     0   4   39 43                 82
1804957 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_4 56 1 15   0 3     0   8   40 43                       83 56 1 15   0 3     0   8   40 43                 83
1804958 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_5 55 2 12   0 5     0   4   40 38                       78 55 2 12   0 5     0   4   40 38                 78
1804959 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_6 40 0 5   0 3     0   5   24 29                       53 40 0 5   0 3     0   5   24 29                 53
1804960 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_7 36 0 9   0 2     0   3   20 30                       50 36 0 9   0 2     0   3   20 30                 50
1804961 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_8 32 0 5   0 0     0   2   14 25                       39 32 0 5   0 0     0   2   14 25                 39
1804962 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   kindergarten_full_day 49 3 11   0 2     1   7   41 32                       73 49 3 11   0 2     1   7   41 32                 73
1804963 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   kindergarten_half_day 4 0 1   0 0     0   0   3 2                       5 4 0 1   0 0     0   0   3 2                 5
1804964 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   pk_12_total 440 10 96   0 24     1   48   307 312                       619 440 10 96   0 24     1   48   307 312                 619
1805099 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_10 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1805100 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_11 2 0 3   0 1     0   0   2 4                       6 2 0 3   0 1     0   0   2 4                 6
1805101 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_12 4 0 6   0 0     0   0   7 3                       10 4 0 6   0 0     0   0   7 3                 10
1805102 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_4 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1805103 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_5 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1805104 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_6 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
1805105 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_7 4 0 0   0 0     0   0   1 3                       4 4 0 0   0 0     0   0   1 3                 4
1805106 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_8 4 0 1   0 0     0   0   2 3                       5 4 0 1   0 0     0   0   2 3                 5
1805107 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_9 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1805108 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   pk_12_total 21 0 10   0 1     0   0   14 18                       32 21 0 10   0 1     0   0   14 18                 32
1808353 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_1 100 2 14   0 2     0   3   72 49                       121 100 2 14   0 2     0   3   72 49                 121
1808354 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_2 101 1 16   0 2     0   5   63 62                       125 101 1 16   0 2     0   5   63 62                 125
1808355 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_3 106 2 9   0 3     0   3   55 68                       123 106 2 9   0 3     0   3   55 68                 123
1808356 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_4 78 0 19   0 2     0   6   55 50                       105 78 0 19   0 2     0   6   55 50                 105
1808357 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_5 93 1 11   0 2     0   1   48 60                       108 93 1 11   0 2     0   1   48 60                 108
1808358 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_6 85 0 12   0 1     0   6   54 50                       104 85 0 12   0 1     0   6   54 50                 104

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