Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 13,221
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
1808359 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_7 45 0 9   0 1     0   1   31 25                       56 45 0 9   0 1     0   1   31 25                 56
1808360 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_8 36 0 5   0 0     0   5   25 21                       46 36 0 5   0 0     0   5   25 21                 46
1808361 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   kindergarten_full_day 89 2 18   0 1     0   3   51 62                       113 89 2 18   0 1     0   3   51 62                 113
1808362 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   kindergarten_half_day 6 0 0   0 0     0   0   3 3                       6 6 0 0   0 0     0   0   3 3                 6
1808363 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   pk_12_total 759 8 117   0 14     0   33   464 467                       931 759 8 117   0 14     0   33   464 467                 931
1808364 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   pre_kindergarten 20 0 4   0 0     0   0   7 17                       24 20 0 4   0 0     0   0   7 17                 24
1806331 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   grade_1 52 1 10   1 2     0   8   33 41                       74 52 1 10   1 2     0   8   33 41                 74
1806332 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   grade_2 50 3 6   1 1     0   2   37 26                       63 50 3 6   1 1     0   2   37 26                 63
1806333 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   grade_3 59 1 11   0 3     0   4   38 40                       78 59 1 11   0 3     0   4   38 40                 78
1806334 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   grade_4 64 4 10   0 0     0   7   40 45                       85 64 4 10   0 0     0   7   40 45                 85
1806335 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   grade_5 59 2 15   1 1     0   1   47 32                       79 59 2 15   1 1     0   1   47 32                 79
1806336 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 47 3 8   1 3     0   6   32 36                       68 47 3 8   1 3     0   6   32 36                 68
1806337 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day 6 0 0   0 0     0   0   5 1                       6 6 0 0   0 0     0   0   5 1                 6
1806338 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 355 15 62   4 11     0   32   248 231                       479 355 15 62   4 11     0   32   248 231                 479
1806339 CO     school 801920 1040   Academy 20 80192000008 9714 Woodmen-Roberts Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 18 1 2   0 1     0   4   16 10                       26 18 1 2   0 1     0   4   16 10                 26
1806704 CO     school 803870 1110   District 49 80387001686 9706 Woodmen Hills Elementary School   Regular School No Elementary PK 05 2020   grade_1 69 4 16   2 1     0   5   47 50                       97 69 4 16   2 1     0   5   47 50                 97
1806705 CO     school 803870 1110   District 49 80387001686 9706 Woodmen Hills Elementary School   Regular School No Elementary PK 05 2020   grade_2 59 3 15   0 1     0   5   42 41                       83 59 3 15   0 1     0   5   42 41                 83
1806706 CO     school 803870 1110   District 49 80387001686 9706 Woodmen Hills Elementary School   Regular School No Elementary PK 05 2020   grade_3 69 3 15   1 1     0   10   54 45                       99 69 3 15   1 1     0   10   54 45                 99
1806707 CO     school 803870 1110   District 49 80387001686 9706 Woodmen Hills Elementary School   Regular School No Elementary PK 05 2020   grade_4 77 3 14   0 0     0   11   57 48                       105 77 3 14   0 0     0   11   57 48                 105
1806708 CO     school 803870 1110   District 49 80387001686 9706 Woodmen Hills Elementary School   Regular School No Elementary PK 05 2020   grade_5 53 7 23   1 3     1   9   48 49                       97 53 7 23   1 3     1   9   48 49                 97
1806709 CO     school 803870 1110   District 49 80387001686 9706 Woodmen Hills Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 55 4 13   1 1     0   10   39 45                       84 55 4 13   1 1     0   10   39 45                 84
1806710 CO     school 803870 1110   District 49 80387001686 9706 Woodmen Hills Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 415 24 105   7 7     1   56   321 294                       615 415 24 105   7 7     1   56   321 294                 615
1806711 CO     school 803870 1110   District 49 80387001686 9706 Woodmen Hills Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 33 0 9   2 0     0   6   34 16                       50 33 0 9   2 0     0   6   34 16                 50
1811552 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_10 7 0 0   0 0     0   0   2 5                       7 7 0 0   0 0     0   0   2 5                 7
1811553 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_11 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1811554 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_12 5 0 0   0 0     0   0   2 3                       5 5 0 0   0 0     0   0   2 3                 5
1811555 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_6 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3
1811556 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_7 7 0 1   0 0     0   0   3 5                       8 7 0 1   0 0     0   0   3 5                 8
1811557 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_8 9 0 0   0 0     0   0   5 4                       9 9 0 0   0 0     0   0   5 4                 9
1811558 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_9 4 0 2   0 0     0   0   4 2                       6 4 0 2   0 0     0   0   4 2                 6
1811559 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   pk_12_total 37 0 4   0 0     0   0   18 23                       41 37 0 4   0 0     0   0   18 23                 41
1811544 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   grade_1 5 0 0   0 0     0   0   2 3                       5 5 0 0   0 0     0   0   2 3                 5
1811545 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   grade_2 6 0 0   0 0     0   0   3 3                       6 6 0 0   0 0     0   0   3 3                 6
1811546 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   grade_3 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
1811547 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   grade_4 3 0 1   0 0     0   0   2 2                       4 3 0 1   0 0     0   0   2 2                 4
1811548 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   grade_5 12 0 1   0 0     0   0   8 5                       13 12 0 1   0 0     0   0   8 5                 13
1811549 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 6 0 0   0 0     0   0   0 6                       6 6 0 0   0 0     0   0   0 6                 6
1811550 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 41 0 3   0 0     0   0   21 23                       44 41 0 3   0 0     0   0   21 23                 44
1811551 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 4 0 1   0 0     0   0   3 2                       5 4 0 1   0 0     0   0   3 2                 5
1811463 CO     school 807380 3020   Woodland Park Re-2 80738001268 9694 Woodland Park Middle School   Regular School No Middle 06 08 2020   grade_6 133 2 19   0 0     0   6   93 67                       160 133 2 19   0 0     0   6   93 67                 160
1811464 CO     school 807380 3020   Woodland Park Re-2 80738001268 9694 Woodland Park Middle School   Regular School No Middle 06 08 2020   grade_7 159 1 21   0 0     0   11   104 88                       192 159 1 21   0 0     0   11   104 88                 192
1811465 CO     school 807380 3020   Woodland Park Re-2 80738001268 9694 Woodland Park Middle School   Regular School No Middle 06 08 2020   grade_8 147 3 21   1 0     0   5   91 86                       177 147 3 21   1 0     0   5   91 86                 177
1811466 CO     school 807380 3020   Woodland Park Re-2 80738001268 9694 Woodland Park Middle School   Regular School No Middle 06 08 2020   pk_12_total 439 6 61   1 0     0   22   288 241                       529 439 6 61   1 0     0   22   288 241                 529
1811467 CO     school 807380 3020   Woodland Park Re-2 80738001267 9696 Woodland Park High School   Regular School No High 09 12 2020   grade_10 140 0 25   0 2     0   6   97 76                       173 140 0 25   0 2     0   6   97 76                 173
1811468 CO     school 807380 3020   Woodland Park Re-2 80738001267 9696 Woodland Park High School   Regular School No High 09 12 2020   grade_11 161 0 20   0 1     0   16   93 105                       198 161 0 20   0 1     0   16   93 105                 198
1811469 CO     school 807380 3020   Woodland Park Re-2 80738001267 9696 Woodland Park High School   Regular School No High 09 12 2020   grade_12 136 1 21   0 1     1   6   94 72                       166 136 1 21   0 1     1   6   94 72                 166
1811470 CO     school 807380 3020   Woodland Park Re-2 80738001267 9696 Woodland Park High School   Regular School No High 09 12 2020   grade_9 136 1 17   2 2     0   4   89 73                       162 136 1 17   2 2     0   4   89 73                 162
1811471 CO     school 807380 3020   Woodland Park Re-2 80738001267 9696 Woodland Park High School   Regular School No High 09 12 2020   pk_12_total 573 2 83   2 6     1   32   373 326                       699 573 2 83   2 6     1   32   373 326                 699
1799837 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_1 25 0 32   1 5     0   3   30 36                       66 25 0 32   1 5     0   3   30 36                 66
1799838 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_2 29 0 24   1 5     0   5   29 35                       64 29 0 24   1 5     0   5   29 35                 64
1799839 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_3 40 0 27   1 1     1   5   38 37                       75 40 0 27   1 1     1   5   38 37                 75
1799840 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_4 28 0 36   1 2     0   1   36 32                       68 28 0 36   1 2     0   1   36 32                 68
1799841 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_5 33 3 40   2 2     0   1   46 35                       81 33 3 40   2 2     0   1   46 35                 81
1799842 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 27 0 24   1 1     0   3   25 31                       56 27 0 24   1 1     0   3   25 31                 56
1799843 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 214 5 215   7 20     1   20   245 237                       482 214 5 215   7 20     1   20   245 237                 482
1799844 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 32 2 32   0 4     0   2   41 31                       72 32 2 32   0 4     0   2   41 31                 72
1800367 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_1 8 2 9   1 0     0   3   13 10                       23 8 2 9   1 0     0   3   13 10                 23
1800368 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_2 11 2 16   0 0     0   0   17 12                       29 11 2 16   0 0     0   0   17 12                 29
1800369 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_3 12 4 19   0 1     0   3   20 19                       39 12 4 19   0 1     0   3   20 19                 39
1800370 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_4 6 1 26   0 0     0   3   22 14                       36 6 1 26   0 0     0   3   22 14                 36
1800371 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_5 6 1 12   0 1     0   3   16 7                       23 6 1 12   0 1     0   3   16 7                 23
1800372 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_6 4 0 16   0 0     0   1   10 11                       21 4 0 16   0 0     0   1   10 11                 21
1800373 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   kindergarten_full_day 14 0 17   0 1     0   2   18 16                       34 14 0 17   0 1     0   2   18 16                 34
1800374 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   pk_12_total 61 10 115   1 3     0   15   116 89                       205 61 10 115   1 3     0   15   116 89                 205
1808415 CO     school 804800 1420   Jefferson County R-1 80480001350 9678 Witt Elementary School   Regular School No Elementary PK 05 2020   grade_1 35 0 7   1 1     0   0   23 21                       44 35 0 7   1 1     0   0   23 21                 44
1808416 CO     school 804800 1420   Jefferson County R-1 80480001350 9678 Witt Elementary School   Regular School No Elementary PK 05 2020   grade_2 38 0 4   0 0     0   4   30 16                       46 38 0 4   0 0     0   4   30 16                 46
1808417 CO     school 804800 1420   Jefferson County R-1 80480001350 9678 Witt Elementary School   Regular School No Elementary PK 05 2020   grade_3 21 0 7   0 1     0   2   13 18                       31 21 0 7   0 1     0   2   13 18                 31
1808418 CO     school 804800 1420   Jefferson County R-1 80480001350 9678 Witt Elementary School   Regular School No Elementary PK 05 2020   grade_4 24 0 10   0 0     0   3   19 18                       37 24 0 10   0 0     0   3   19 18                 37
1808419 CO     school 804800 1420   Jefferson County R-1 80480001350 9678 Witt Elementary School   Regular School No Elementary PK 05 2020   grade_5 25 1 12   1 0     0   6   22 23                       45 25 1 12   1 0     0   6   22 23                 45
1808420 CO     school 804800 1420   Jefferson County R-1 80480001350 9678 Witt Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 29 0 12   0 1     0   5   32 15                       47 29 0 12   0 1     0   5   32 15                 47
1808421 CO     school 804800 1420   Jefferson County R-1 80480001350 9678 Witt Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 201 4 63   3 5     0   21   162 135                       297 201 4 63   3 5     0   21   162 135                 297
1808422 CO     school 804800 1420   Jefferson County R-1 80480001350 9678 Witt Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 29 3 11   1 2     0   1   23 24                       47 29 3 11   1 2     0   1   23 24                 47
1809319 CO     school 805400 1560   Thompson R2-J 80540000942 9674 Winona Elementary School   Regular School No Elementary KG 05 2020   grade_1 31 1 24   3 0     0   5   31 33                       64 31 1 24   3 0     0   5   31 33                 64
1809320 CO     school 805400 1560   Thompson R2-J 80540000942 9674 Winona Elementary School   Regular School No Elementary KG 05 2020   grade_2 27 1 19   2 0     0   6   32 23                       55 27 1 19   2 0     0   6   32 23                 55
1809321 CO     school 805400 1560   Thompson R2-J 80540000942 9674 Winona Elementary School   Regular School No Elementary KG 05 2020   grade_3 27 2 11   0 0     0   4   22 22                       44 27 2 11   0 0     0   4   22 22                 44
1809322 CO     school 805400 1560   Thompson R2-J 80540000942 9674 Winona Elementary School   Regular School No Elementary KG 05 2020   grade_4 30 0 12   2 1     0   0   20 25                       45 30 0 12   2 1     0   0   20 25                 45
1809323 CO     school 805400 1560   Thompson R2-J 80540000942 9674 Winona Elementary School   Regular School No Elementary KG 05 2020   grade_5 30 1 23   2 0     0   5   30 31                       61 30 1 23   2 0     0   5   30 31                 61
1809324 CO     school 805400 1560   Thompson R2-J 80540000942 9674 Winona Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 25 2 22   2 2     0   5   36 22                       58 25 2 22   2 2     0   5   36 22                 58
1809325 CO     school 805400 1560   Thompson R2-J 80540000942 9674 Winona Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 170 7 111   11 3     0   25   171 156                       327 170 7 111   11 3     0   25   171 156                 327
1811784 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_1 21 1 48   0 1     0   1   37 35                       72 21 1 48   0 1     0   1   37 35                 72
1811785 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_2 26 1 46   0 0     0   1   39 35                       74 26 1 46   0 0     0   1   39 35                 74
1811786 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_3 25 0 48   0 0     0   1   37 37                       74 25 0 48   0 0     0   1   37 37                 74
1811787 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_4 18 1 43   0 1     0   6   38 31                       69 18 1 43   0 1     0   6   38 31                 69
1811788 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_5 23 0 66   0 0     0   2   50 41                       91 23 0 66   0 0     0   2   50 41                 91
1811789 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_6 29 0 55   0 1     0   4   55 34                       89 29 0 55   0 1     0   4   55 34                 89
1811790 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_7 28 0 40   0 0     0   0   27 41                       68 28 0 40   0 0     0   0   27 41                 68
1811791 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_8 17 0 42   0 1     0   0   24 36                       60 17 0 42   0 1     0   0   24 36                 60
1811792 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   kindergarten_full_day 24 0 46   0 0     0   3   38 35                       73 24 0 46   0 0     0   3   38 35                 73
1811793 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   pk_12_total 211 3 434   0 4     0   18   345 325                       670 211 3 434   0 4     0   18   345 325                 670
1809939 CO     school 804350 2000   Mesa County Valley 51 80435001347 9673 Wingate Elementary School   Regular School No Elementary PK 05 2020   grade_1 57 0 8   0 1     0   5   32 39                       71 57 0 8   0 1     0   5   32 39                 71
1809940 CO     school 804350 2000   Mesa County Valley 51 80435001347 9673 Wingate Elementary School   Regular School No Elementary PK 05 2020   grade_2 65 1 4   0 0     0   2   37 35                       72 65 1 4   0 0     0   2   37 35                 72
1809941 CO     school 804350 2000   Mesa County Valley 51 80435001347 9673 Wingate Elementary School   Regular School No Elementary PK 05 2020   grade_3 54 1 8   0 0     0   3   34 32                       66 54 1 8   0 0     0   3   34 32                 66
1809942 CO     school 804350 2000   Mesa County Valley 51 80435001347 9673 Wingate Elementary School   Regular School No Elementary PK 05 2020   grade_4 78 0 10   0 0     0   2   50 40                       90 78 0 10   0 0     0   2   50 40                 90
1809943 CO     school 804350 2000   Mesa County Valley 51 80435001347 9673 Wingate Elementary School   Regular School No Elementary PK 05 2020   grade_5 59 0 5   1 0     0   1   32 34                       66 59 0 5   1 0     0   1   32 34                 66
1809944 CO     school 804350 2000   Mesa County Valley 51 80435001347 9673 Wingate Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 53 1 7   0 1     0   2   40 24                       64 53 1 7   0 1     0   2   40 24                 64
1809945 CO     school 804350 2000   Mesa County Valley 51 80435001347 9673 Wingate Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 383 3 44   1 2     1   18   236 216                       452 383 3 44   1 2     1   18   236 216                 452
1809946 CO     school 804350 2000   Mesa County Valley 51 80435001347 9673 Wingate Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 17 0 2   0 0     1   3   11 12                       23 17 0 2   0 0     1   3   11 12                 23
1811726 CO     school 807350 3100   Windsor RE-4 80735001265 9670 Windsor Middle School   Regular School No Middle 06 08 2020   grade_6 207 1 35   0 0     0   6   134 115                       249 207 1 35   0 0     0   6   134 115                 249
1811727 CO     school 807350 3100   Windsor RE-4 80735001265 9670 Windsor Middle School   Regular School No Middle 06 08 2020   grade_7 189 2 35   0 1     0   4   113 118                       231 189 2 35   0 1     0   4   113 118                 231
1811728 CO     school 807350 3100   Windsor RE-4 80735001265 9670 Windsor Middle School   Regular School No Middle 06 08 2020   grade_8 211 1 29   0 4     0   8   151 102                       253 211 1 29   0 4     0   8   151 102                 253

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