Data source: Big Local News · About: Big Local

1,104 rows where grade = "grade_2", state = "CO" and year = 2019 sorted by white

View and edit SQL

year

  • 2019 · 1,104

grade

  • grade_2 · 1,104
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
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
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
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
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
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
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
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
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
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
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
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
1935795 CO     school 803360 880   DENVER COUNTY 1 80336006389 8909 TREVISTA AT HORACE MANN   Regular School No Elementary PK 05 2019   grade_2 0 11 34   0 1     0   0   20 26                       46 0 11 34   0 1     0   0   20 26                 46
1939523 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No Other PK 12 2019   grade_2 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1939835 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No Other KG 12 2019   grade_2 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1931572 CO     school 801950 30   ADAMS COUNTY 14 80195000018 6534 HANSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 0 33   0 0     0   0   20 14                       34 1 0 33   0 0     0   0   20 14                 34
1931842 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001236 3144 FRANCIS M. DAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 1 47   0 1     0   1   30 21                       51 1 1 47   0 1     0   1   30 21                 51
1932853 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000062 3272 FULTON ACADEMY OF EXCELLENCE   Regular School No Elementary PK 05 2019   grade_2 1 9 48   0 5     1   3   35 32                       67 1 9 48   0 5     1   3   35 32                 67
1932907 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000068 4970 LANSING ELEMENTARY COMMUNITY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 14 25   0 3     0   2   27 18                       45 1 14 25   0 3     0   2   27 18                 45
1933195 CO     school 802700 190   BYERS 32J 80270006751 2801 ELEVATE ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2019   grade_2 1 0 22   0 0     0   0   12 11                       23 1 0 22   0 0     0   0   12 11                 23
1934881 CO     school 803360 880   DENVER COUNTY 1 80336006521 2205 DCIS AT FORD   Regular School No Elementary PK 05 2019   grade_2 1 8 57   0 1     0   1   32 36                       68 1 8 57   0 1     0   1   32 36                 68
1934941 CO     school 803360 880   DENVER COUNTY 1 80336000337 2364 EAGLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 4 45   1 1     0   0   28 24                       52 1 4 45   1 1     0   0   28 24                 52
1935006 CO     school 803360 880   DENVER COUNTY 1 80336000349 3032 FORCE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 0 51   0 0     0   0   28 24                       52 1 0 51   0 0     0   0   28 24                 52
1935124 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 INTERNATIONAL ACADEMY OF DENVER AT HARRINGTON   Regular School No Elementary PK 05 2019   grade_2 1 3 19   1 0     1   0   13 12                       25 1 3 19   1 0     1   0   13 12                 25
1935271 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT ACADEMY   Regular School No Elementary PK 05 2019   grade_2 1 17 3   0 0     0   1   10 12                       22 1 17 3   0 0     0   1   10 12                 22
1935755 CO     school 803360 880   DENVER COUNTY 1 80336000414 8422 SWANSEA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 3 63   0 0     0   0   33 34                       67 1 3 63   0 0     0   0   33 34                 67
1935853 CO     school 803360 880   DENVER COUNTY 1 80336000424 9496 CASTRO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 1 0 52   0 5     0   0   32 26                       58 1 0 52   0 5     0   0   32 26                 58
1935911 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes Elementary KG 05 2019   grade_2 1 5 29   0 0     0   1   23 13                       36 1 5 29   0 0     0   1   23 13                 36
1936097 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000439 1578 CHERRY VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1940127 CO     school 806930 1440   PLAINVIEW RE-2 80693001198 6992 PLAINVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1941173 CO     school 804980 1760   KIM REORGANIZED 88 80498000822 4690 KIM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1942197 CO     school 803840 2610   PARK COUNTY RE-2 80384001695 3681 GUFFEY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1942302 CO     school 804290 2650   GRANADA RE-1 80429000592 3542 GRANADA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 1 0 16   0 0     0   0   3 14                       17 1 0 16   0 0     0   0   3 14                 17
1944129 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001780 4277 INDIAN PEAKS CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1944194 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006602 5957 MONTESSORI DEL MUNDO CHARTER SCHOOL   Regular School Yes Elementary PK 06 2019   grade_2 1 5 40   0 0     0   0   23 23                       46 1 5 40   0 0     0   0   23 23                 46
1944227 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006320 7278 RICARDO FLORES MAGON ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 1 0 21   0 0     0   0   11 11                       22 1 0 21   0 0     0   0   11 11                 22
1930988 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_2 10 1 41   0 3     0   0   26 29                       55 10 1 41   0 3     0   0   26 29                 55
1931264 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001177 4000 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 10 2 49   0 6     0   6   44 29                       73 10 2 49   0 6     0   6   44 29                 73
1931747 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000150 8060 SOUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 1 51   0 1     0   1   30 34                       64 10 1 51   0 1     0   1   30 34                 64
1931899 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001363 7810 JOHN E. FLYNN A MARZANO ACADEMY   Regular School No Elementary PK 05 2019   grade_2 10 0 36   0 2     0   1   24 25                       49 10 0 36   0 2     0   1   24 25                 49
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
1932282 CO     school 802910 130   CHERRY CREEK 5 80291006182 3988 HIGHLINE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 14 37   1 3     2   2   40 29                       69 10 14 37   1 3     2   2   40 29                 69
1932717 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 7 60   1 2     0   0   45 35                       80 10 7 60   1 2     0   0   45 35                 80
1932925 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2019   grade_2 10 40 24   0 0     0   1   36 39                       75 10 40 24   0 0     0   1   36 39                 75
1934269 CO     school 803000 540   CLEAR CREEK RE-1 80300001999 3385 GEORGETOWN COMMUNITY SCHOOL   Regular School Yes Elementary PK 06 2019   grade_2 10 0 0   0 0     0   1   10 1                       11 10 0 0   0 0     0   1   10 1                 11
1935547 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No Elementary PK 08 2019   grade_2 10 24 22   0 26     1   2   41 44                       85 10 24 22   0 26     1   2   41 44                 85
1937063 CO     school 804530 980   HARRISON 2 80453000670 6936 PIKES PEAK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 9 21   0 0     0   4   19 25                       44 10 9 21   0 0     0   4   19 25                 44
1937580 CO     school 803060 1010   COLORADO SPRINGS 11 80306000262 7482 ROOSEVELT CHARTER ACADEMY   Regular School Yes Elementary KG 05 2019   grade_2 10 6 87   0 1     0   11   54 61                       115 10 6 87   0 1     0   11   54 61                 115
1937837 CO     school 801920 1040   ACADEMY 20 80192006478 1901 JOURNEY K8   Regular School No Elementary KG 08 2019   grade_2 10 0 3   0 0     0   0   5 8                       13 10 0 3   0 0     0   0   5 8                 13
1938160 CO     school 803870 1110   DISTRICT 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2019   grade_2 10 0 2   0 0     0   0   8 4                       12 10 0 2   0 0     0   0   8 4                 12
1938540 CO     school 804260 1180   ROARING FORK RE-1 80426001540 2063 CRYSTAL RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_2 10 0 44   0 1     0   0   20 35                       55 10 0 44   0 1     0   0   20 35                 55
1938842 CO     school 807050 1410   NORTH PARK R-1 80705001209 6358 NORTH PARK SCHOOL   Regular School No Other PK 12 2019   grade_2 10 0 2   0 0     0   0   7 5                       12 10 0 2   0 0     0   0   7 5                 12
1939385 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000744 4802 KULLERSTRAND ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 10 1 12   1 0     0   4   16 12                       28 10 1 12   1 0     0   4   16 12                 28
1940110 CO     school 803510 1430   EADS RE-1 80351000458 2328 EADS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 0 2   0 0     0   3   9 6                       15 10 0 2   0 0     0   3   9 6                 15
1940146 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2019   grade_2 10 0 1   0 0     0   0   0 11                       11 10 0 1   0 0     0   0   0 11                 11
1941270 CO     school 803930 1850   FRENCHMAN RE-3 80393000511 2980 FLEMING ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 10 0 1   0 0     0   0   6 5                       11 10 0 1   0 0     0   0   6 5                 11
1941301 CO     school 806030 1870   PLATEAU RE-5 80603001022 6834 PEETZ ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
1941750 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309006622 2036 CHILDREN'S KIVA MONTESSORI SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 10 0 4   4 0     0   0   10 8                       18 10 0 4   4 0     0   0   10 8                 18
1942353 CO     school 804680 2670   HOLLY RE-3 80468000682 7794 HOLLY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 10 0 13   0 0     0   0   10 13                       23 10 0 13   0 0     0   0   10 13                 23
1942538 CO     school 806120 2690   PUEBLO CITY 60 80612001057 5916 MINNEQUA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 1 40   1 0     0   0   31 21                       52 10 1 40   1 0     0   0   31 21                 52
1942590 CO     school 806120 2690   PUEBLO CITY 60 80612001062 8030 HEROES ACADEMY PREK-5   Regular School No Elementary PK 05 2019   grade_2 10 0 18   0 0     0   3   16 15                       31 10 0 18   0 0     0   3   16 15                 31
1942963 CO     school 806300 2790   MOUNTAIN VALLEY RE 1 80630001415 6146 MOUNTAIN VALLEY SCHOOL   Regular School No Other PK 12 2019   grade_2 10 0 0   0 0     0   0   5 5                       10 10 0 0   0 0     0   0   5 5                 10
1943086 CO     school 804860 2862   JULESBURG RE-1 80486000811 4488 JULESBURG ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 10 0 6   0 1     0   0   7 10                       17 10 0 6   0 1     0   0   7 10                 17
1943363 CO     school 803600 3085   EATON RE-2 80360000477 3286 GALETON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 10 0 6   0 0     0   1   6 11                       17 10 0 6   0 0     0   1   6 11                 17
1943540 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2019   grade_2 10 10 80   0 1     0   0   61 40                       101 10 10 80   0 1     0   0   61 40                 101
1944248 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 10 1 0   0 0     0   0   3 8                       11 10 1 0   0 0     0   0   3 8                 11
1940037 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 101 2 16   0 4     0   6   63 66                       129 101 2 16   0 4     0   6   63 66                 129
1943510 CO     school 804830 3110   JOHNSTOWN-MILLIKEN RE-5J 80483001911 6963 PIONEER RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 102 1 8   1 1     2   3   59 59                       118 102 1 8   1 1     2   3   59 59                 118
1938954 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD K8 SOUTH   Regular School No Elementary KG 03 2019   grade_2 106 0 4   0 0     0   3   64 49                       113 106 0 4   0 0     0   3   64 49                 113
1943574 CO     school 804410 3120   GREELEY 6 80441001614 1875 FRONTIER CHARTER ACADEMY   Regular School Yes Other KG 12 2019   grade_2 106 2 30   0 0     1   8   72 75                       147 106 2 30   0 0     1   8   72 75                 147
1943463 CO     school 807350 3100   WINDSOR RE-4 80735001815 9665 WINDSOR CHARTER ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2019   grade_2 107 0 13   0 0     0   2   67 55                       122 107 0 13   0 0     0   2   67 55                 122
1931468 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001191 8842 THORNTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 2 40   0 0     0   1   23 31                       54 11 2 40   0 0     0   1   23 31                 54
1931875 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006373 4465 JOSEPHINE HODGKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 0 61   0 4     0   1   42 35                       77 11 0 61   0 4     0   1   42 35                 77
1932666 CO     school 803270 170   DEER TRAIL 26J 80327000287 2136 DEER TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 0 5   0 0     0   1   11 6                       17 11 0 5   0 0     0   1   11 6                 17
1932694 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 11 24 35   1 2     0   6   37 42                       79 11 24 35   1 2     0   6   37 42                 79
1932733 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 11 16 17   2 2     0   3   26 25                       51 11 16 17   2 2     0   3   26 25                 51
1933119 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 12 46   0 0     0   5   34 40                       74 11 12 46   0 0     0   5   34 40                 74
1935074 CO     school 803360 880   DENVER COUNTY 1 80336001776 3641 GREEN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 19 51   1 9     1   7   49 50                       99 11 19 51   1 9     1   7   49 50                 99
1935580 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 05 2019   grade_2 11 4 2   0 1     0   0   12 6                       18 11 4 2   0 1     0   0   12 6                 18
1938796 CO     school 807080 1390   HUERFANO RE-1 80708001845 63 PEAKVIEW SCHOOL   Regular School No Elementary PK 08 2019   grade_2 11 1 18   0 2     0   0   20 12                       32 11 1 18   0 2     0   0   20 12                 32
1939406 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000748 5004 LASLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 11 0 37   0 4     0   2   30 24                       54 11 0 37   0 4     0   2   30 24                 54
1939680 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000773 6848 PEAK EXPEDITIONARY - PENNINGTON   Regular School No Elementary PK 05 2019   grade_2 11 0 14   0 1     0   0   11 15                       26 11 0 14   0 1     0   0   11 15                 26
1939976 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000794 9154 VIVIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 2 11   0 2     0   1   17 10                       27 11 2 11   0 2     0   1   17 10                 27
1940256 CO     school 803480 1520   DURANGO 9-R 80348006696 1526 COLORADO CONNECTIONS ACADEMY @ DURANGO   Regular School No Other KG 12 2019   grade_2 11 1 8   0 0     0   1   10 11                       21 11 1 8   0 0     0   1   10 11                 21
1940689 CO     school 803990 1550   POUDRE R-1 80399006431 7198 PSD GLOBAL ACADEMY   Regular School No Other KG 12 2019   grade_2 11 0 0   0 1     0   2   10 4                       14 11 0 0   0 1     0   2   10 4                 14
1941776 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000838 5436 MANAUGH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 11 0 9   25 0     0   0   29 16                       45 11 0 9   25 0     0   0   29 16                 45
1942362 CO     school 807320 2680   WILEY RE-13 JT 80732001260 9604 WILEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 1 4   0 0     0   0   8 8                       16 11 1 4   0 0     0   0   8 8                 16
1942463 CO     school 806120 2690   PUEBLO CITY 60 80612001038 1828 COLUMBIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 3 30   1 0     0   0   23 22                       45 11 3 30   1 0     0   0   23 22                 45
1942642 CO     school 806150 2700   PUEBLO COUNTY 70 80615001071 852 BEULAH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 11 0 6   0 0     0   1   15 3                       18 11 0 6   0 0     0   1   15 3                 18
1943830 CO     school 802550 3146   BRIGGSDALE RE-10 80255000142 1008 BRIGGSDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 0 1   0 0     0   0   5 7                       12 11 0 1   0 0     0   0   5 7                 12
1943449 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 110 3 21   0 3     0   1   73 65                       138 110 3 21   0 3     0   1   73 65                 138
1931033 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_2 12 1 32   1 1     0   4   24 27                       51 12 1 32   1 1     0   4   24 27                 51
1934829 CO     school 803360 880   DENVER COUNTY 1 80336001522 2174 DENISON MONTESSORI SCHOOL   Regular School No Elementary PK 06 2019   grade_2 12 0 27   0 6     0   0   25 20                       45 12 0 27   0 6     0   0   25 20                 45
1937089 CO     school 804530 980   HARRISON 2 80453000671 8337 STRATMOOR HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 12 5 14   1 0     0   5   19 18                       37 12 5 14   1 0     0   5   19 18                 37
1937103 CO     school 804530 980   HARRISON 2 80453001443 8923 TURMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 12 2 16   0 2     0   4   14 22                       36 12 2 16   0 2     0   4   14 22                 36
1938503 CO     school 804260 1180   ROARING FORK RE-1 80426001505 429 CARBONDALE COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 12 0 3   0 0     0   0   8 7                       15 12 0 3   0 0     0   0   8 7                 15
1938823 CO     school 805160 1400   LA VETA RE-2 80516000853 4860 LA VETA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 12 0 5   0 0     0   0   9 8                       17 12 0 5   0 0     0   0   9 8                 17
1938888 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 12 2 9   0 0     0   0   11 12                       23 12 2 9   0 0     0   0   11 12                 23
1939874 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000785 8248 EMORY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 12 1 51   1 1     0   1   37 30                       67 12 1 51   1 1     0   1   37 30                 67
1940903 CO     school 805400 1560   THOMPSON R2-J 80540001301 5018 LAURENE EDMONDSON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 12 1 8   0 0     1   1   13 10                       23 12 1 8   0 0     1   1   13 10                 23
1941031 CO     school 805400 1560   THOMPSON R2-J 80540000940 9055 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 12 0 5   0 0     0   2   10 9                       19 12 0 5   0 0     0   2   10 9                 19

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