Data source: Big Local News · About: Big Local

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

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
1931976 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_10 0 0 8   0 0     0   0   6 2                       8 0 0 8   0 0     0   0   6 2                 8
1931977 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_11 0 0 5   0 0     0   0   4 1                       5 0 0 5   0 0     0   0   4 1                 5
1932072 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No High 06 12 2019   grade_9 0 0 6   0 0     0   0   3 3                       6 0 0 6   0 0     0   0   3 3                 6
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
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
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
1932758 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_2 0 4 32   0 4     0   1   19 22                       41 0 4 32   0 4     0   1   19 22                 41
1932831 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000061 2618 ELKHART ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pre_kindergarten 0 0 22   1 3     0   1   14 13                       27 0 0 22   1 3     0   1   14 13                 27
1932846 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 0 2 3   0 0     0   1   5 1                       6 0 2 3   0 0     0   1   5 1                 6
1932847 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   grade_3 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1932850 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_full_day 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
1932935 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000070 5361 LYN KNOLL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 0 14 23   1 1     0   2   26 15                       41 0 14 23   1 1     0   2   26 15                 41
1932987 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000075 6728 PARIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 0 7 34   0 2     0   1   21 23                       44 0 7 34   0 2     0   1   21 23                 44
1932990 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000075 6728 PARIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_5 0 9 38   1 1     4   4   30 27                       57 0 9 38   1 1     4   4   30 27                 57
1933054 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000078 7932 SIXTH AVENUE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pre_kindergarten 0 6 19   0 1     0   5   12 19                       31 0 6 19   0 1     0   5   12 19                 31
1933155 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000083 9514 WHEELING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pre_kindergarten 0 7 19   0 2     0   2   16 14                       30 0 7 19   0 2     0   2   16 14                 30
1933194 CO     school 802700 190   BYERS 32J 80270006751 2801 ELEVATE ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2019   grade_1 0 0 23   0 0     0   0   12 11                       23 0 0 23   0 0     0   0   12 11                 23
1933198 CO     school 802700 190   BYERS 32J 80270006751 2801 ELEVATE ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2019   grade_5 0 0 30   1 0     0   0   21 10                       31 0 0 30   1 0     0   0   21 10                 31
1933269 CO     school 806090 240   PRITCHETT RE-3 80609001026 7174 PRITCHETT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1933303 CO     school 806990 260   VILAS RE-5 80699001206 9090 VILAS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1933703 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001374 6498 OLDE COLUMBINE HIGH SCHOOL   Alternative School No High 09 12 2019   grade_10 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1933799 CO     school 802490 480   BOULDER VALLEY RE 2 80249001219 125 ARAPAHOE RIDGE HIGH SCHOOL   Alternative School No High 09 12 2019   grade_9 0 0 8   0 0     0   1   5 4                       9 0 0 8   0 0     0   1   5 4                 9
1933842 CO     school 802490 480   BOULDER VALLEY RE 2 80249006463 930 BOULDER UNIVERSAL   Regular School No Other KG 12 2019   grade_3 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1934213 CO     school 806330 500   SALIDA R-32 80633006413 4085 HORIZONS EXPLORATORY ACADEMY   Alternative School No High 09 12 2019   grade_9 0 0 1   1 0     0   0   0 2                       2 0 0 1   1 0     0   0   0 2                 2
1934327 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative School No Other KG 12 2019   grade_8 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1934347 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000033 248 GUADALUPE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 0 0 12   0 0     0   0   5 7                       12 0 0 12   0 0     0   0   5 7                 12
1934351 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000033 248 GUADALUPE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_6 0 0 9   0 0     0   0   4 5                       9 0 0 9   0 0     0   0   4 5                 9
1934356 CO     school 802130 580   SOUTH CONEJOS RE-10 80213001464 250 ANTONITO MIDDLE SCHOOL   Regular School No Middle 07 08 2019   grade_8 0 0 10   0 0     0   0   4 6                       10 0 0 10   0 0     0   0   4 6                 10
1934358 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000035 252 ANTONITO HIGH SCHOOL   Regular School No High 09 12 2019   grade_10 0 0 11   0 0     0   0   8 3                       11 0 0 11   0 0     0   0   8 3                 11
1934359 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000035 252 ANTONITO HIGH SCHOOL   Regular School No High 09 12 2019   grade_11 0 0 11   0 0     0   0   3 8                       11 0 0 11   0 0     0   0   3 8                 11
1934360 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000035 252 ANTONITO HIGH SCHOOL   Regular School No High 09 12 2019   grade_12 0 0 8   0 0     0   0   5 3                       8 0 0 8   0 0     0   0   5 3                 8
1934367 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2019   grade_2 0 0 18   0 0     0   0   12 6                       18 0 0 18   0 0     0   0   12 6                 18
1934369 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2019   grade_4 0 0 14   0 0     0   0   6 8                       14 0 0 14   0 0     0   0   6 8                 14
1934370 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2019   grade_5 0 0 15   0 0     0   0   5 10                       15 0 0 15   0 0     0   0   5 10                 15
1934373 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2019   grade_8 0 0 12   0 0     0   0   6 6                       12 0 0 12   0 0     0   0   6 6                 12
1934374 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2019   grade_9 0 0 13   0 0     0   0   8 5                       13 0 0 13   0 0     0   0   8 5                 13
1934382 CO     school 804140 740   SIERRA GRANDE R-30 80414000572 7880 SIERRA GRANDE K-12 SCHOOL   Regular School No Other PK 12 2019   grade_2 0 0 17   0 0     0   1   11 7                       18 0 0 17   0 0     0   1   11 7                 18
1934553 CO     school 803360 880   DENVER COUNTY 1 80336001724 40 RIDGE VIEW ACADEMY CHARTER SCHOOL   Alternative School Yes High 07 12 2019   grade_8 0 1 2   0 0     0   0   3 0                       3 0 1 2   0 0     0   0   3 0                 3
1934650 CO     school 803360 880   DENVER COUNTY 1 80336000320 1106 BRYANT WEBSTER DUAL LANGUAGE ECE-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_7 0 0 57   1 0     0   0   30 28                       58 0 0 57   1 0     0   0   30 28                 58
1934705 CO     school 803360 880   DENVER COUNTY 1 80336006735 1561 COLORADO HIGH SCHOOL CHARTER - GES   Alternative School Yes High 09 12 2019   grade_10 0 3 43   1 0     0   1   30 18                       48 0 3 43   1 0     0   1   30 18                 48
1934706 CO     school 803360 880   DENVER COUNTY 1 80336006735 1561 COLORADO HIGH SCHOOL CHARTER - GES   Alternative School Yes High 09 12 2019   grade_11 0 4 29   1 0     0   0   21 13                       34 0 4 29   1 0     0   0   21 13                 34
1934761 CO     school 803360 880   DENVER COUNTY 1 80336000332 1928 COWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 0 3 39   0 1     1   0   17 27                       44 0 3 39   0 1     1   0   17 27                 44
1934770 CO     school 803360 880   DENVER COUNTY 1 80336006645 1939 COMPASS ACADEMY   Regular School Yes Middle 06 08 2019   grade_7 0 4 106   1 1     0   0   58 54                       112 0 4 106   1 1     0   0   58 54                 112
1934943 CO     school 803360 880   DENVER COUNTY 1 80336000337 2364 EAGLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 0 3 54   1 1     0   1   32 28                       60 0 3 54   1 1     0   1   32 28                 60
1934987 CO     school 803360 880   DENVER COUNTY 1 80336000347 2880 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 0 13 20   0 1     0   0   15 19                       34 0 13 20   0 1     0   0   15 19                 34
1934988 CO     school 803360 880   DENVER COUNTY 1 80336000347 2880 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_5 0 11 23   1 1     0   0   15 21                       36 0 11 23   1 1     0   0   15 21                 36
1934992 CO     school 803360 880   DENVER COUNTY 1 80336006685 2919 SANDRA TODD-WILLIAMS ACADEMY   Regular School No Elementary PK KG 2019   kindergarten_full_day 0 1 1   0 0     0   0   2 0                       2 0 1 1   0 0     0   0   2 0                 2
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
1935003 CO     school 803360 880   DENVER COUNTY 1 80336001575 3000 FLORENCE CRITTENTON HIGH SCHOOL   Alternative School No High 09 12 2019   grade_9 0 3 22   1 0     0   1   0 27                       27 0 3 22   1 0     0   1   0 27                 27
1935016 CO     school 803360 880   DENVER COUNTY 1 80336000351 3296 GARDEN PLACE ACADEMY   Regular School No Elementary PK 06 2019   grade_4 0 1 45   0 0     0   1   25 22                       47 0 1 45   0 0     0   1   25 22                 47
1935018 CO     school 803360 880   DENVER COUNTY 1 80336000351 3296 GARDEN PLACE ACADEMY   Regular School No Elementary PK 06 2019   grade_6 0 1 2   0 0     0   0   2 1                       3 0 1 2   0 0     0   0   2 1                 3
1935043 CO     school 803360 880   DENVER COUNTY 1 80336000355 3512 GOLDRICK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_3 0 1 46   0 0     0   1   26 22                       48 0 1 46   0 0     0   1   26 22                 48
1935087 CO     school 803360 880   DENVER COUNTY 1 80336001739 3647 MARIE L. GREENWOOD ACADEMY   Regular School No Elementary KG 08 2019   grade_7 0 7 66   1 0     0   0   31 43                       74 0 7 66   1 0     0   0   31 43                 74
1935123 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 INTERNATIONAL ACADEMY OF DENVER AT HARRINGTON   Regular School No Elementary PK 05 2019   grade_1 0 8 24   1 0     0   0   9 24                       33 0 8 24   1 0     0   0   9 24                 33
1935125 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 INTERNATIONAL ACADEMY OF DENVER AT HARRINGTON   Regular School No Elementary PK 05 2019   grade_3 0 10 15   0 0     0   1   8 18                       26 0 10 15   0 0     0   1   8 18                 26
1935169 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_1 0 13 51   1 0     2   2   34 35                       69 0 13 51   1 0     2   2   34 35                 69
1935170 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_2 0 16 50   0 1     3   2   36 36                       72 0 16 50   0 1     3   2   36 36                 72
1935253 CO     school 803360 880   DENVER COUNTY 1 80336006448 4730 KIPP DENVER COLLEGIATE HIGH SCHOOL   Regular School Yes High 09 12 2019   grade_11 0 2 109   0 1     0   0   61 51                       112 0 2 109   0 1     0   0   61 51                 112
1935257 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2019   grade_5 0 0 82   0 0     0   0   45 37                       82 0 0 82   0 0     0   0   45 37                 82
1935258 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2019   grade_6 0 2 110   0 1     0   0   58 55                       113 0 2 110   0 1     0   0   58 55                 113
1935259 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2019   grade_7 0 2 111   0 0     0   0   45 68                       113 0 2 111   0 0     0   0   45 68                 113
1935260 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2019   grade_8 0 2 110   0 1     0   1   63 51                       114 0 2 110   0 1     0   1   63 51                 114
1935261 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2019   pk_12_total 0 6 413   0 2     0   1   211 211                       422 0 6 413   0 2     0   1   211 211                 422
1935272 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT ACADEMY   Regular School No Elementary PK 05 2019   grade_3 0 23 1   0 0     0   1   10 15                       25 0 23 1   0 0     0   1   10 15                 25
1935273 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT ACADEMY   Regular School No Elementary PK 05 2019   grade_4 0 24 2   0 0     0   2   15 13                       28 0 24 2   0 0     0   2   15 13                 28
1935274 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT ACADEMY   Regular School No Elementary PK 05 2019   grade_5 0 18 5   0 0     0   2   13 12                       25 0 18 5   0 0     0   2   13 12                 25
1935275 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT ACADEMY   Regular School No Elementary PK 05 2019   kindergarten_full_day 0 25 4   0 0     0   2   11 20                       31 0 25 4   0 0     0   2   11 20                 31
1935292 CO     school 803360 880   DENVER COUNTY 1 80336006748 4850 KIPP SUNSHINE PEAK ELEMENTARY   Regular School Yes Elementary PK KG 2019   kindergarten_full_day 0 0 22   1 0     0   0   10 13                       23 0 0 22   1 0     0   0   10 13                 23
1935297 CO     school 803360 880   DENVER COUNTY 1 80336006669 5044 LEGACY OPTIONS HIGH SCHOOL   Alternative School No High 09 12 2019   grade_12 0 6 11   0 0     0   1   11 7                       18 0 6 11   0 0     0   1   11 7                 18
1935342 CO     school 803360 880   DENVER COUNTY 1 80336006445 5608 MATHEMATICS AND SCIENCE LEADERSHIP ACADEMY   Regular School No Elementary KG 05 2019   grade_1 0 0 20   0 1     0   0   12 9                       21 0 0 20   0 1     0   0   12 9                 21
1935343 CO     school 803360 880   DENVER COUNTY 1 80336006445 5608 MATHEMATICS AND SCIENCE LEADERSHIP ACADEMY   Regular School No Elementary KG 05 2019   grade_2 0 2 21   0 0     0   0   8 15                       23 0 2 21   0 0     0   0   8 15                 23
1935345 CO     school 803360 880   DENVER COUNTY 1 80336006445 5608 MATHEMATICS AND SCIENCE LEADERSHIP ACADEMY   Regular School No Elementary KG 05 2019   grade_4 0 2 38   0 0     0   0   19 21                       40 0 2 38   0 0     0   0   19 21                 40
1935347 CO     school 803360 880   DENVER COUNTY 1 80336006445 5608 MATHEMATICS AND SCIENCE LEADERSHIP ACADEMY   Regular School No Elementary KG 05 2019   kindergarten_full_day 0 3 28   0 0     0   0   9 22                       31 0 3 28   0 0     0   0   9 22                 31
1935361 CO     school 803360 880   DENVER COUNTY 1 80336001635 5644 MAXWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   kindergarten_full_day 0 19 68   0 1     0   2   47 43                       90 0 19 68   0 1     0   2   47 43                 90
1935369 CO     school 803360 880   DENVER COUNTY 1 80336001276 5685 MCGLONE ACADEMY   Regular School No Elementary PK 08 2019   grade_6 0 4 57   0 0     1   2   33 31                       64 0 4 57   0 0     1   2   33 31                 64
1935370 CO     school 803360 880   DENVER COUNTY 1 80336001276 5685 MCGLONE ACADEMY   Regular School No Elementary PK 08 2019   grade_7 0 11 48   1 0     6   1   40 27                       67 0 11 48   1 0     6   1   40 27                 67
1935454 CO     school 803360 880   DENVER COUNTY 1 80336000388 6254 NEWLON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pre_kindergarten 0 1 27   0 0     0   2   17 13                       30 0 1 27   0 0     0   2   17 13                 30
1935455 CO     school 803360 880   DENVER COUNTY 1 80336006569 6308 NORTH HIGH SCHOOL ENGAGEMENT CENTER   Alternative School No High 09 12 2019   grade_10 0 2 32   0 1     0   0   29 6                       35 0 2 32   0 1     0   0   29 6                 35
1935456 CO     school 803360 880   DENVER COUNTY 1 80336006569 6308 NORTH HIGH SCHOOL ENGAGEMENT CENTER   Alternative School No High 09 12 2019   grade_11 0 1 34   0 0     1   1   18 19                       37 0 1 34   0 0     1   1   18 19                 37
1935458 CO     school 803360 880   DENVER COUNTY 1 80336006569 6308 NORTH HIGH SCHOOL ENGAGEMENT CENTER   Alternative School No High 09 12 2019   grade_9 0 0 6   1 0     0   0   3 4                       7 0 0 6   1 0     0   0   3 4                 7
1935467 CO     school 803360 880   DENVER COUNTY 1 80336001869 6350 BRUCE RANDOLPH SCHOOL   Regular School No High 06 12 2019   grade_12 0 6 67   0 0     0   0   34 39                       73 0 6 67   0 0     0   0   34 39                 73
1935471 CO     school 803360 880   DENVER COUNTY 1 80336001869 6350 BRUCE RANDOLPH SCHOOL   Regular School No High 06 12 2019   grade_9 0 3 108   1 1     0   4   55 62                       117 0 3 108   1 1     0   4   55 62                 117
1935557 CO     school 803360 880   DENVER COUNTY 1 80336001795 7163 PREP ACADEMY   Alternative School No High 06 12 2019   grade_10 0 5 7   0 0     0   0   7 5                       12 0 5 7   0 0     0   0   7 5                 12
1935560 CO     school 803360 880   DENVER COUNTY 1 80336001795 7163 PREP ACADEMY   Alternative School No High 06 12 2019   grade_6 0 2 2   0 0     0   0   2 2                       4 0 2 2   0 0     0   0   2 2                 4
1935561 CO     school 803360 880   DENVER COUNTY 1 80336001795 7163 PREP ACADEMY   Alternative School No High 06 12 2019   grade_7 0 3 4   0 0     0   0   5 2                       7 0 3 4   0 0     0   0   5 2                 7
1935566 CO     school 803360 880   DENVER COUNTY 1 80336006591 7188 MONTBELLO CAREER AND TECHNICAL HIGH SCHOOL   Alternative School No High 09 12 2019   grade_11 0 5 32   3 0     2   4   28 18                       46 0 5 32   3 0     2   4   28 18                 46
1935587 CO     school 803360 880   DENVER COUNTY 1 80336006590 7246 RESPECT ACADEMY   Alternative School No High 09 12 2019   grade_10 0 1 2   0 0     0   0   3 0                       3 0 1 2   0 0     0   0   3 0                 3
1935589 CO     school 803360 880   DENVER COUNTY 1 80336006590 7246 RESPECT ACADEMY   Alternative School No High 09 12 2019   grade_12 0 6 54   3 0     0   1   43 21                       64 0 6 54   3 0     0   1   43 21                 64
1935590 CO     school 803360 880   DENVER COUNTY 1 80336006590 7246 RESPECT ACADEMY   Alternative School No High 09 12 2019   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1935627 CO     school 803360 880   DENVER COUNTY 1 80336000400 7694 CHARLES M. SCHENCK (CMS) COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 0 1 47   0 1     0   0   28 21                       49 0 1 47   0 1     0   0   28 21                 49
1935628 CO     school 803360 880   DENVER COUNTY 1 80336000400 7694 CHARLES M. SCHENCK (CMS) COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   grade_3 0 1 54   0 1     0   0   25 31                       56 0 1 54   0 1     0   0   25 31                 56
1935629 CO     school 803360 880   DENVER COUNTY 1 80336000400 7694 CHARLES M. SCHENCK (CMS) COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 0 1 41   1 4     0   1   24 24                       48 0 1 41   1 4     0   1   24 24                 48
1935630 CO     school 803360 880   DENVER COUNTY 1 80336000400 7694 CHARLES M. SCHENCK (CMS) COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   grade_5 0 2 53   0 1     0   0   33 23                       56 0 2 53   0 1     0   0   33 23                 56
1935631 CO     school 803360 880   DENVER COUNTY 1 80336000400 7694 CHARLES M. SCHENCK (CMS) COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_full_day 0 1 45   0 2     0   1   22 27                       49 0 1 45   0 2     0   1   22 27                 49
1935633 CO     school 803360 880   DENVER COUNTY 1 80336000401 7698 SCHMITT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 0 6 26   0 3     0   0   20 15                       35 0 6 26   0 3     0   0   20 15                 35
1935637 CO     school 803360 880   DENVER COUNTY 1 80336000401 7698 SCHMITT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_5 0 8 37   1 4     0   0   23 27                       50 0 8 37   1 4     0   0   23 27                 50
1935695 CO     school 803360 880   DENVER COUNTY 1 80336001839 8132 EARLY COLLEGE OF DENVER   Regular School Yes High 09 12 2019   grade_10 0 0 12   0 0     0   0   4 8                       12 0 0 12   0 0     0   0   4 8                 12

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