Data source: Big Local News · About: Big Local

13,307 rows where state = "CO" and year = 2018 sorted by district_nces_id descending

View and edit SQL

year

  • 2018 · 13,307
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
1893680 CO     school   10   MAPLETON 1   0 Not a school             2018   grade_12 6 0 13   1 1     0   0   13 8                       21 6 0 13   1 1     0   0   13 8                 21
1893681 CO     school   10   MAPLETON 1   0 Not a school             2018   pk_12_total 6 0 13   1 1     0   0   13 8                       21 6 0 13   1 1     0   0   13 8                 21
1893830 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2018   grade_10 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1893831 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2018   grade_11 4 0 5   0 2     0   0   2 9                       11 4 0 5   0 2     0   0   2 9                 11
1893832 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2018   grade_12 17 2 18   0 0     0   1   18 20                       38 17 2 18   0 0     0   1   18 20                 38
1893833 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2018   pk_12_total 22 2 23   0 2     0   1   20 30                       50 22 2 23   0 2     0   1   20 30                 50
1894368 CO     school   40   SCHOOL DISTRICT 27J   4892 BRIGHTON HEAD START - ADAMS COUNTY HEAD START             2018   pk_12_total 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1894369 CO     school   40   SCHOOL DISTRICT 27J   4892 BRIGHTON HEAD START - ADAMS COUNTY HEAD START             2018   pre_kindergarten 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1894528 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2018   grade_12 2 0 1   0 1     0   0   3 1                       4 2 0 1   0 1     0   0   3 1                 4
1894529 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2018   pk_12_total 2 0 1   0 1     0   0   3 1                       4 2 0 1   0 1     0   0   3 1                 4
1895375 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_10 1 0 1   1 0     0   0   0 3                       3 1 0 1   1 0     0   0   0 3                 3
1895376 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_11 1 0 2   0 0     0   0   2 1                       3 1 0 2   0 0     0   0   2 1                 3
1895377 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_12 1 2 1   0 0     0   0   2 2                       4 1 2 1   0 0     0   0   2 2                 4
1895378 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_3 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1895379 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_4 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1895380 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_5 1 0 0   0 1     0   0   1 1                       2 1 0 0   0 1     0   0   1 1                 2
1895381 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_6 0 0 1   1 0     0   0   2 0                       2 0 0 1   1 0     0   0   2 0                 2
1895382 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_7 3 0 1   0 0     0   0   3 1                       4 3 0 1   0 0     0   0   3 1                 4
1895383 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_8 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
1895384 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_9 0 1 0   0 0     0   1   1 1                       2 0 1 0   0 0     0   1   1 1                 2
1895385 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   pk_12_total 11 3 8   2 1     0   1   15 11                       26 11 3 8   2 1     0   1   15 11                 26
1901435 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2018   grade_12 8 1 5   0 0     0   1   9 6                       15 8 1 5   0 0     0   1   9 6                 15
1901436 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2018   pk_12_total 8 1 5   0 0     0   1   9 6                       15 8 1 5   0 0     0   1   9 6                 15
1902871 CO     school   1520   DURANGO 9-R   0 Not a school             2018   grade_11 6 0 2   1 0     0   2   4 7                       11 6 0 2   1 0     0   2   4 7                 11
1902872 CO     school   1520   DURANGO 9-R   0 Not a school             2018   grade_12 8 0 6   4 0     0   0   10 8                       18 8 0 6   4 0     0   0   10 8                 18
1902873 CO     school   1520   DURANGO 9-R   0 Not a school             2018   pk_12_total 14 0 8   5 0     0   2   14 15                       29 14 0 8   5 0     0   2   14 15                 29
1903011 CO     school   1550   POUDRE R-1   0 Not a school             2018   grade_10 2 0 1   0 0     0   0   1 2                       3 2 0 1   0 0     0   0   1 2                 3
1903012 CO     school   1550   POUDRE R-1   0 Not a school             2018   grade_11 2 0 3   0 0     0   0   5 0                       5 2 0 3   0 0     0   0   5 0                 5
1903013 CO     school   1550   POUDRE R-1   0 Not a school             2018   grade_12 1 0 2   0 0     0   1   3 1                       4 1 0 2   0 0     0   1   3 1                 4
1903014 CO     school   1550   POUDRE R-1   0 Not a school             2018   grade_7 1 0 0   0 0     0   1   2 0                       2 1 0 0   0 0     0   1   2 0                 2
1903015 CO     school   1550   POUDRE R-1   0 Not a school             2018   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1903016 CO     school   1550   POUDRE R-1   0 Not a school             2018   pk_12_total 6 0 7   0 0     0   2   12 3                       15 6 0 7   0 0     0   2   12 3                 15
1903855 CO     school   1828   VALLEY RE-1   6 COUNTY JAILS WITH DISTRICT RUN EDUCATION             2018   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1903856 CO     school   1828   VALLEY RE-1   6 COUNTY JAILS WITH DISTRICT RUN EDUCATION             2018   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1903857 CO     school   1828   VALLEY RE-1   6 COUNTY JAILS WITH DISTRICT RUN EDUCATION             2018   pk_12_total 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1904616 CO     school   2405   FORT MORGAN RE-3   0 Not a school             2018   grade_10 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1904617 CO     school   2405   FORT MORGAN RE-3   0 Not a school             2018   grade_11 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
1904618 CO     school   2405   FORT MORGAN RE-3   0 Not a school             2018   grade_12 0 1 2   0 0     0   0   2 1                       3 0 1 2   0 0     0   0   2 1                 3
1904619 CO     school   2405   FORT MORGAN RE-3   0 Not a school             2018   pk_12_total 1 1 4   0 0     0   0   4 2                       6 1 1 4   0 0     0   0   4 2                 6
1904677 CO     school   2515   WIGGINS RE-50(J)   0 Not a school             2018   grade_11 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1904678 CO     school   2515   WIGGINS RE-50(J)   0 Not a school             2018   pk_12_total 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1905022 CO     school   2690   PUEBLO CITY 60   0 Not a school             2018   grade_12 3 2 3   0 1     0   1   6 4                       10 3 2 3   0 1     0   1   6 4                 10
1905023 CO     school   2690   PUEBLO CITY 60   0 Not a school             2018   pk_12_total 3 2 3   0 1     0   1   6 4                       10 3 2 3   0 1     0   1   6 4                 10
1905970 CO     school   3085   EATON RE-2   0 Not a school             2018   grade_8 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1905971 CO     school   3085   EATON RE-2   0 Not a school             2018   pk_12_total 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1906980 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_10 14 9 28   0 0     0   0   39 12                       51 14 9 28   0 0     0   0   39 12                 51
1906981 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_11 37 3 23   1 0     0   2   53 13                       66 37 3 23   1 0     0   2   53 13                 66
1906982 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_12 16 7 27   0 0     0   3   45 8                       53 16 7 27   0 0     0   3   45 8                 53
1906983 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_6 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1906984 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_7 1 1 4   0 0     0   1   7 0                       7 1 1 4   0 0     0   1   7 0                 7
1906985 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_8 5 1 6   0 0     0   0   10 2                       12 5 1 6   0 0     0   0   10 2                 12
1906986 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_9 14 6 24   0 0     0   1   36 9                       45 14 6 24   0 0     0   1   36 9                 45
1906934 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No High 06 12 2018   grade_10 4 0 4   0 0     0   0   2 6                       8 4 0 4   0 0     0   0   2 6                 8
1906935 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No High 06 12 2018   grade_11 10 0 2   1 0     0   0   7 6                       13 10 0 2   1 0     0   0   7 6                 13
1906936 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No High 06 12 2018   grade_12 11 0 4   0 0     0   2   7 10                       17 11 0 4   0 0     0   2   7 10                 17
1906937 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No High 06 12 2018   grade_6 4 0 4   0 0     0   0   3 5                       8 4 0 4   0 0     0   0   3 5                 8
1906938 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No High 06 12 2018   grade_7 3 0 1   0 0     0   0   2 2                       4 3 0 1   0 0     0   0   2 2                 4
1906939 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No High 06 12 2018   grade_8 3 0 2   0 0     0   0   2 3                       5 3 0 2   0 0     0   0   2 3                 5
1906940 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No High 06 12 2018   grade_9 5 0 0   0 0     1   0   5 1                       6 5 0 0   0 0     1   0   5 1                 6
1906941 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No High 06 12 2018   pk_12_total 40 0 17   1 0     1   2   28 33                       61 40 0 17   1 0     1   2   28 33                 61
1906929 CO     school 899200 9035   CENTENNIAL BOCES 89920006526 1607 CENTENNIAL BOCES HIGH SCHOOL   Alternative School No High 11 12 2018   grade_12 62 1 63   1 0     1   1   74 55                       129 62 1 63   1 0     1   1   74 55                 129
1906930 CO     school 899200 9035   CENTENNIAL BOCES 89920006526 1607 CENTENNIAL BOCES HIGH SCHOOL   Alternative School No High 11 12 2018   pk_12_total 62 1 63   1 0     1   1   74 55                       129 62 1 63   1 0     1   1   74 55                 129
1906931 CO     school 899200 9035   CENTENNIAL BOCES 89920006560 3997 INNOVATIVE CONNECTIONS HIGH SCHOOL   Career and Technical School No High 10 12 2018   grade_11 10 0 11   3 0     0   0   13 11                       24 10 0 11   3 0     0   0   13 11                 24
1906932 CO     school 899200 9035   CENTENNIAL BOCES 89920006560 3997 INNOVATIVE CONNECTIONS HIGH SCHOOL   Career and Technical School No High 10 12 2018   grade_12 10 0 7   0 0     0   0   7 10                       17 10 0 7   0 0     0   0   7 10                 17
1906933 CO     school 899200 9035   CENTENNIAL BOCES 89920006560 3997 INNOVATIVE CONNECTIONS HIGH SCHOOL   Career and Technical School No High 10 12 2018   pk_12_total 20 0 18   3 0     0   0   20 21                       41 20 0 18   3 0     0   0   20 21                 41
1905917 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 9 0 0   0 0     0   0   7 2                       9 9 0 0   0 0     0   0   7 2                 9
1905918 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 5 1 2   0 0     0   0   4 4                       8 5 1 2   0 0     0   0   4 4                 8
1905919 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_3 11 1 0   0 0     0   0   7 5                       12 11 1 0   0 0     0   0   7 5                 12
1905920 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 4 0 0   0 0     0   0   0 4                       4 4 0 0   0 0     0   0   0 4                 4
1905921 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_5 8 1 1   0 0     0   0   3 7                       10 8 1 1   0 0     0   0   3 7                 10
1905922 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   kindergarten_full_day 7 0 0   0 0     0   0   4 3                       7 7 0 0   0 0     0   0   4 3                 7
1905923 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 58 3 4   0 0     0   0   30 35                       65 58 3 4   0 0     0   0   30 35                 65
1905924 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pre_kindergarten 14 0 1   0 0     0   0   5 10                       15 14 0 1   0 0     0   0   5 10                 15
1905925 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_10 5 0 0   0 0     0   0   2 3                       5 5 0 0   0 0     0   0   2 3                 5
1905926 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_11 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1905927 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_12 10 0 0   0 0     0   0   7 3                       10 10 0 0   0 0     0   0   7 3                 10
1905928 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_6 6 0 0   0 0     0   0   3 3                       6 6 0 0   0 0     0   0   3 3                 6
1905929 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_7 4 0 3   0 0     0   0   3 4                       7 4 0 3   0 0     0   0   3 4                 7
1905930 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_8 5 0 1   0 0     0   0   3 3                       6 5 0 1   0 0     0   0   3 3                 6
1905931 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_9 3 0 1   0 0     0   0   1 3                       4 3 0 1   0 0     0   0   1 3                 4
1905932 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   pk_12_total 36 0 5   0 0     0   0   20 21                       41 36 0 5   0 0     0   0   20 21                 41
1905820 CO     school 807380 3020   WOODLAND PARK RE-2 80738000643 8379 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 41 0 14   0 2     0   0   23 34                       57 41 0 14   0 2     0   0   23 34                 57
1905821 CO     school 807380 3020   WOODLAND PARK RE-2 80738000643 8379 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 57 0 2   0 1     0   2   31 31                       62 57 0 2   0 1     0   2   31 31                 62
1905822 CO     school 807380 3020   WOODLAND PARK RE-2 80738000643 8379 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_3 43 0 9   0 0     0   1   36 17                       53 43 0 9   0 0     0   1   36 17                 53
1905823 CO     school 807380 3020   WOODLAND PARK RE-2 80738000643 8379 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 35 0 3   0 1     0   1   19 21                       40 35 0 3   0 1     0   1   19 21                 40
1905824 CO     school 807380 3020   WOODLAND PARK RE-2 80738000643 8379 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_5 52 0 8   0 0     0   4   33 31                       64 52 0 8   0 0     0   4   33 31                 64
1905825 CO     school 807380 3020   WOODLAND PARK RE-2 80738000643 8379 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   kindergarten_full_day 39 0 5   0 0     0   0   25 19                       44 39 0 5   0 0     0   0   25 19                 44
1905826 CO     school 807380 3020   WOODLAND PARK RE-2 80738000643 8379 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 298 0 48   0 4     0   9   186 173                       359 298 0 48   0 4     0   9   186 173                 359
1905827 CO     school 807380 3020   WOODLAND PARK RE-2 80738000643 8379 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pre_kindergarten 31 0 7   0 0     0   1   19 20                       39 31 0 7   0 0     0   1   19 20                 39
1905828 CO     school 807380 3020   WOODLAND PARK RE-2 80738001266 9692 GATEWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_1 48 0 5   1 3     0   1   28 30                       58 48 0 5   1 3     0   1   28 30                 58
1905829 CO     school 807380 3020   WOODLAND PARK RE-2 80738001266 9692 GATEWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 37 1 7   2 2     0   7   31 25                       56 37 1 7   2 2     0   7   31 25                 56
1905830 CO     school 807380 3020   WOODLAND PARK RE-2 80738001266 9692 GATEWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_3 42 0 2   1 0     0   0   27 18                       45 42 0 2   1 0     0   0   27 18                 45
1905831 CO     school 807380 3020   WOODLAND PARK RE-2 80738001266 9692 GATEWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_4 58 0 7   0 2     0   1   37 31                       68 58 0 7   0 2     0   1   37 31                 68
1905832 CO     school 807380 3020   WOODLAND PARK RE-2 80738001266 9692 GATEWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_5 39 2 6   0 2     0   4   25 28                       53 39 2 6   0 2     0   4   25 28                 53
1905833 CO     school 807380 3020   WOODLAND PARK RE-2 80738001266 9692 GATEWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   kindergarten_full_day 43 0 11   1 1     0   4   34 26                       60 43 0 11   1 1     0   4   34 26                 60
1905834 CO     school 807380 3020   WOODLAND PARK RE-2 80738001266 9692 GATEWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pk_12_total 297 3 41   5 10     0   17   199 174                       373 297 3 41   5 10     0   17   199 174                 373
1905835 CO     school 807380 3020   WOODLAND PARK RE-2 80738001266 9692 GATEWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   pre_kindergarten 30 0 3   0 0     0   0   17 16                       33 30 0 3   0 0     0   0   17 16                 33
1905836 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_6 159 4 20   1 0     0   7   97 94                       191 159 4 20   1 0     0   7   97 94                 191
1905837 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 164 3 19   1 1     0   7   103 92                       195 164 3 19   1 1     0   7   103 92                 195
1905838 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_8 165 0 25   2 0     0   9   116 85                       201 165 0 25   2 0     0   9   116 85                 201

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