Data source: Big Local News · About: Big Local

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

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
1931103 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2019   grade_11 7 0 4   0 0     0   1   2 10                       12 7 0 4   0 0     0   1   2 10                 12
1931104 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2019   grade_12 19 2 19   0 2     1   0   12 31                       43 19 2 19   0 2     1   0   12 31                 43
1931105 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2019   pk_12_total 26 2 23   0 2     1   1   14 41                       55 26 2 23   0 2     1   1   14 41                 55
1931587 CO     school   40   SCHOOL DISTRICT 27J   6 COUNTY JAILS WITH DISTRICT RUN EDUCATION             2019   grade_9 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931588 CO     school   40   SCHOOL DISTRICT 27J   6 COUNTY JAILS WITH DISTRICT RUN EDUCATION             2019   pk_12_total 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931823 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2019   grade_12 2 0 0   1 0     0   0   2 1                       3 2 0 0   1 0     0   0   2 1                 3
1931824 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2019   pk_12_total 2 0 0   1 0     0   0   2 1                       3 2 0 0   1 0     0   0   2 1                 3
1932681 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_1 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1932682 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_10 1 0 0   0 0     0   1   1 1                       2 1 0 0   0 0     0   1   1 1                 2
1932683 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_11 1 1 0   0 0     0   0   1 1                       2 1 1 0   0 0     0   0   1 1                 2
1932684 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_12 0 1 1   0 0     0   0   1 1                       2 0 1 1   0 0     0   0   1 1                 2
1932685 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_2 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1932686 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_4 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1932687 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_5 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1932688 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_6 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1932689 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_7 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
1932690 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_8 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1932691 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_9 1 1 2   0 0     0   0   2 2                       4 1 1 2   0 0     0   0   2 2                 4
1932692 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   pk_12_total 6 3 7   0 2     0   2   12 8                       20 6 3 7   0 2     0   2   12 8                 20
1938400 CO     school   1140   CANON CITY RE-1   0 Not a school             2019   grade_11 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1938401 CO     school   1140   CANON CITY RE-1   0 Not a school             2019   grade_12 21 0 6   0 0     0   1   14 14                       28 21 0 6   0 0     0   1   14 14                 28
1938402 CO     school   1140   CANON CITY RE-1   0 Not a school             2019   pk_12_total 24 0 6   0 0     0   1   15 16                       31 24 0 6   0 0     0   1   15 16                 31
1938853 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2019   grade_11 2 0 0   0 0     0   1   3 0                       3 2 0 0   0 0     0   1   3 0                 3
1938854 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2019   grade_12 7 0 4   0 1     0   0   6 6                       12 7 0 4   0 1     0   0   6 6                 12
1938855 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2019   pk_12_total 9 0 4   0 1     0   1   9 6                       15 9 0 4   0 1     0   1   9 6                 15
1940242 CO     school   1520   DURANGO 9-R   0 Not a school             2019   grade_12 6 0 3   3 0     0   1   7 6                       13 6 0 3   3 0     0   1   7 6                 13
1940243 CO     school   1520   DURANGO 9-R   0 Not a school             2019   pk_12_total 6 0 3   3 0     0   1   7 6                       13 6 0 3   3 0     0   1   7 6                 13
1940383 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_10 1 0 1   0 0     0   1   2 1                       3 1 0 1   0 0     0   1   2 1                 3
1940384 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_11 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1940385 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_7 0 0 3   0 0     0   0   1 2                       3 0 0 3   0 0     0   0   1 2                 3
1940386 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_8 0 1 2   0 0     0   1   3 1                       4 0 1 2   0 0     0   1   3 1                 4
1940387 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_9 2 0 1   0 0     0   1   2 2                       4 2 0 1   0 0     0   1   2 2                 4
1940388 CO     school   1550   POUDRE R-1   0 Not a school             2019   pk_12_total 3 1 9   0 0     0   3   10 6                       16 3 1 9   0 0     0   3   10 6                 16
1942377 CO     school   2690   PUEBLO CITY 60   0 Not a school             2019   grade_12 9 1 17   2 0     0   0   20 9                       29 9 1 17   2 0     0   0   20 9                 29
1942378 CO     school   2690   PUEBLO CITY 60   0 Not a school             2019   pk_12_total 9 1 17   2 0     0   0   20 9                       29 9 1 17   2 0     0   0   20 9                 29
1944359 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_10 20 13 34   1 3     0   2   54 19                       73 20 13 34   1 3     0   2   54 19                 73
1944360 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_11 27 9 30   0 0     0   3   51 18                       69 27 9 30   0 0     0   3   51 18                 69
1944361 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_12 32 12 31   0 0     0   3   58 20                       78 32 12 31   0 0     0   3   58 20                 78
1944362 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_5 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1944363 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_6 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1944364 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_7 2 0 3   0 0     0   0   4 1                       5 2 0 3   0 0     0   0   4 1                 5
1944365 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_8 8 2 11   0 0     0   0   16 5                       21 8 2 11   0 0     0   0   16 5                 21
1944366 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_9 6 13 19   1 0     0   0   25 14                       39 6 13 19   1 0     0   0   25 14                 39
1944367 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   pk_12_total 97 49 129   2 3     0   8   211 77                       288 97 49 129   2 3     0   8   211 77                 288
1938668 CO     school 804380 1220   GARFIELD 16 80438001909 3585 GRAND VALLEY CENTER FOR FAMILY LEARNING   Regular School No Elementary PK 01 2019   grade_1 43 1 35   0 0     0   4   41 42                       83 43 1 35   0 0     0   4   41 42                 83
1938669 CO     school 804380 1220   GARFIELD 16 80438001909 3585 GRAND VALLEY CENTER FOR FAMILY LEARNING   Regular School No Elementary PK 01 2019   kindergarten_full_day 68 0 32   1 0     0   4   61 44                       105 68 0 32   1 0     0   4   61 44                 105
1938670 CO     school 804380 1220   GARFIELD 16 80438001909 3585 GRAND VALLEY CENTER FOR FAMILY LEARNING   Regular School No Elementary PK 01 2019   pk_12_total 179 1 102   1 1     0   9   147 146                       293 179 1 102   1 1     0   9   147 146                 293
1938671 CO     school 804380 1220   GARFIELD 16 80438001909 3585 GRAND VALLEY CENTER FOR FAMILY LEARNING   Regular School No Elementary PK 01 2019   pre_kindergarten 68 0 35   0 1     0   1   45 60                       105 68 0 35   0 1     0   1   45 60                 105
1941086 CO     school 806960 1580   TRINIDAD 1 80696001201 2481 ECKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 01 2019   grade_1 25 2 49   1 0     0   1   31 47                       78 25 2 49   1 0     0   1   31 47                 78
1941087 CO     school 806960 1580   TRINIDAD 1 80696001201 2481 ECKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 01 2019   kindergarten_full_day 62 0 4   0 0     0   0   39 27                       66 62 0 4   0 0     0   0   39 27                 66
1941088 CO     school 806960 1580   TRINIDAD 1 80696001201 2481 ECKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 01 2019   pk_12_total 87 2 53   1 0     0   1   70 74                       144 87 2 53   1 0     0   1   70 74                 144
1932051 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_1 8 3 62   1 2     0   2   37 41                       78 8 3 62   1 2     0   2   37 41                 78
1932052 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 10 1 56   1 0     0   4   43 29                       72 10 1 56   1 0     0   4   43 29                 72
1932053 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   kindergarten_full_day 16 2 48   2 3     0   4   27 48                       75 16 2 48   2 3     0   4   27 48                 75
1932054 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   pk_12_total 34 6 166   4 5     0   10   107 118                       225 34 6 166   4 5     0   10   107 118                 225
1936428 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   grade_1 61 0 14   1 1     0   3   49 31                       80 61 0 14   1 1     0   3   49 31                 80
1936429 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 73 0 8   3 4     0   5   48 45                       93 73 0 8   3 4     0   5   48 45                 93
1936430 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_full_day 38 0 4   0 0     0   5   24 23                       47 38 0 4   0 0     0   5   24 23                 47
1936431 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_half_day 31 0 5   0 0     0   2   20 18                       38 31 0 5   0 0     0   2   20 18                 38
1936432 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   pk_12_total 253 0 38   4 6     0   17   172 146                       318 253 0 38   4 6     0   17   172 146                 318
1936433 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   pre_kindergarten 50 0 7   0 1     0   2   31 29                       60 50 0 7   0 1     0   2   31 29                 60
1936528 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   grade_1 88 0 12   0 2     0   4   54 52                       106 88 0 12   0 2     0   4   54 52                 106
1936529 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 74 0 18   0 2     0   4   49 49                       98 74 0 18   0 2     0   4   49 49                 98
1936530 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_full_day 46 0 10   0 1     0   5   31 31                       62 46 0 10   0 1     0   5   31 31                 62
1936531 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_half_day 21 0 6   0 0     0   3   15 15                       30 21 0 6   0 0     0   3   15 15                 30
1936532 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   pk_12_total 282 1 53   0 5     0   24   190 175                       365 282 1 53   0 5     0   24   190 175                 365
1936533 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   pre_kindergarten 53 1 7   0 0     0   8   41 28                       69 53 1 7   0 0     0   8   41 28                 69
1938943 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_1 66 0 2   0 1     0   5   42 32                       74 66 0 2   0 1     0   5   42 32                 74
1938944 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 71 0 4   0 0     0   4   39 40                       79 71 0 4   0 0     0   4   39 40                 79
1938945 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_full_day 72 0 5   0 2     0   1   39 41                       80 72 0 5   0 2     0   1   39 41                 80
1938946 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_half_day 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1938947 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   pk_12_total 292 0 13   0 4     0   17   163 163                       326 292 0 13   0 4     0   17   163 163                 326
1938948 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   pre_kindergarten 78 0 2   0 1     0   7   39 49                       88 78 0 2   0 1     0   7   39 49                 88
1940238 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_1 24 0 34   0 0     0   0   31 27                       58 24 0 34   0 0     0   0   31 27                 58
1940239 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 27 1 37   0 0     0   3   41 27                       68 27 1 37   0 0     0   3   41 27                 68
1940240 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   kindergarten_full_day 29 0 46   0 0     0   0   35 40                       75 29 0 46   0 0     0   0   35 40                 75
1940241 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   pk_12_total 80 1 117   0 0     0   3   107 94                       201 80 1 117   0 0     0   3   107 94                 201
1940363 CO     school 802400 1530   BAYFIELD 10 JT-R 80240006747 642 BAYFIELD PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_1 85 0 18   3 0     0   4   51 59                       110 85 0 18   3 0     0   4   51 59                 110
1940364 CO     school 802400 1530   BAYFIELD 10 JT-R 80240006747 642 BAYFIELD PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 79 0 16   3 1     0   8   64 43                       107 79 0 16   3 1     0   8   64 43                 107
1940365 CO     school 802400 1530   BAYFIELD 10 JT-R 80240006747 642 BAYFIELD PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_full_day 83 0 19   2 0     0   3   57 50                       107 83 0 19   2 0     0   3   57 50                 107
1940366 CO     school 802400 1530   BAYFIELD 10 JT-R 80240006747 642 BAYFIELD PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   pk_12_total 247 0 53   8 1     0   15   172 152                       324 247 0 53   8 1     0   15   172 152                 324
1941234 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_1 96 5 35   2 2     0   4   86 58                       144 96 5 35   2 2     0   4   86 58                 144
1941235 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 85 2 53   1 0     0   3   79 65                       144 85 2 53   1 0     0   3   79 65                 144
1941236 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   kindergarten_full_day 108 5 46   1 0     0   4   78 86                       164 108 5 46   1 0     0   4   78 86                 164
1941237 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   pk_12_total 289 12 134   4 2     0   11   243 209                       452 289 12 134   4 2     0   11   243 209                 452
1941972 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_1 47 1 46   0 0     0   0   51 43                       94 47 1 46   0 0     0   0   51 43                 94
1941973 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 61 0 59   0 0     0   0   62 58                       120 61 0 59   0 0     0   0   62 58                 120
1941974 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_full_day 59 0 50   1 0     0   0   56 54                       110 59 0 50   1 0     0   0   56 54                 110
1941975 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   pk_12_total 208 1 192   1 1     0   0   210 193                       403 208 1 192   1 1     0   0   210 193                 403
1941976 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   pre_kindergarten 41 0 37   0 1     0   0   41 38                       79 41 0 37   0 1     0   0   41 38                 79
1942056 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2019   grade_1 30 0 73   0 1     1   0   47 58                       105 30 0 73   0 1     1   0   47 58                 105
1942057 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 35 1 81   1 1     1   0   52 68                       120 35 1 81   1 1     1   0   52 68                 120
1942058 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2019   kindergarten_full_day 31 0 69   1 2     1   1   56 49                       105 31 0 69   1 2     1   1   56 49                 105
1942059 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2019   pk_12_total 96 1 223   2 4     3   1   155 175                       330 96 1 223   2 4     3   1   155 175                 330
1942079 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_1 15 0 57   1 0     0   0   41 32                       73 15 0 57   1 0     0   0   41 32                 73
1942080 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 3 1 63   0 0     0   1   24 44                       68 3 1 63   0 0     0   1   24 44                 68
1942081 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   kindergarten_full_day 33 0 20   1 0     0   0   28 26                       54 33 0 20   1 0     0   0   28 26                 54
1942082 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   pk_12_total 51 1 140   2 0     0   1   93 102                       195 51 1 140   2 0     0   1   93 102                 195
1942340 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_1 37 2 70   0 1     0   5   68 47                       115 37 2 70   0 1     0   5   68 47                 115
1942341 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 22 0 48   0 0     0   0   38 32                       70 22 0 48   0 0     0   0   38 32                 70

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