Data source: Big Local News · About: Big Local

1,104 rows where grade = "grade_2", state = "CO" and year = 2020 sorted by school descending

View and edit SQL

year

  • 2020 · 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
1808724 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   grade_2 77 2 5   0 8     0   12   60 44                       104 77 2 5   0 8     0   12   60 44                 104
1799355 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_2 4 0 47   0 1     0   2   32 22                       54 4 0 47   0 1     0   2   32 22                 54
1801496 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   grade_2 10 18 43   0 4     0   6   36 45                       81 10 18 43   0 4     0   6   36 45                 81
1804224 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   grade_2 3 6 17   0 0     0   0   10 16                       26 3 6 17   0 0     0   0   10 16                 26
1812148 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 04 2020   grade_2 41 0 19   0 0     0   0   33 27                       60 41 0 19   0 0     0   0   33 27                 60
1804955 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_2 53 2 9   0 3     0   8   40 35                       75 53 2 9   0 3     0   8   40 35                 75
1808354 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_2 101 1 16   0 2     0   5   63 62                       125 101 1 16   0 2     0   5   63 62                 125
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
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
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
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
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
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
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
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
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
1811719 CO     school 807350 3100   Windsor RE-4 80735001815 9665 Windsor Charter Academy Elementary School   Regular School Yes Elementary KG 05 2020   grade_2 103 1 13   0 1     1   1   60 60                       120 103 1 13   0 1     1   1   60 60                 120
1805968 CO     school 803060 1010   Colorado Springs 11 80306000275 9660 Wilson Elementary School   Regular School No Elementary KG 05 2020   grade_2 23 5 30   0 1     0   5   29 35                       64 23 5 30   0 1     0   5   29 35                 64
1808408 CO     school 804800 1420   Jefferson County R-1 80480000805 9648 Wilmot Elementary School   Regular School No Elementary PK 05 2020   grade_2 41 1 1   0 0     0   0   18 25                       43 41 1 1   0 0     0   0   18 25                 43
1808400 CO     school 804800 1420   Jefferson County R-1 80480000804 9638 Wilmore Davis Elementary School   Regular School No Elementary PK 05 2020   grade_2 11 1 13   2 1     0   1   18 11                       29 11 1 13   2 1     0   1   18 11                 29
1803463 CO     school 803360 880   Denver County 1 80336006603 3991 Willow Elementary School   Regular School No Elementary PK 05 2020   grade_2 57 6 14   0 4     0   5   48 38                       86 57 6 14   0 4     0   5   48 38                 86
1800844 CO     school 802910 130   Cherry Creek 5 80291000208 9624 Willow Creek Elementary School   Regular School No Elementary PK 05 2020   grade_2 59 1 8   1 14     0   6   44 45                       89 59 1 8   1 14     0   6   44 45                 89
1804184 CO     school 803360 880   Denver County 1 80336006332 9623 William (Bill) Roberts ECE-8 School   Regular School No Elementary PK 08 2020   grade_2 88 8 6   0 2     0   6   54 56                       110 88 8 6   0 2     0   6   54 56                 110
1810616 CO     school 807320 2680   Wiley RE-13 Jt 80732001260 9604 Wiley Elementary School   Regular School No Elementary PK 05 2020   grade_2 13 0 5   0 0     0   0   8 10                       18 13 0 5   0 0     0   0   8 10                 18
1805394 CO     school 804530 980   Harrison 2 80453001370 9602 Wildflower Elementary School   Regular School No Elementary PK 05 2020   grade_2 20 12 34   0 2     0   4   40 32                       72 20 12 34   0 2     0   4   40 32                 72
1800992 CO     school 805310 140   Littleton 6 80531000893 9600 Wilder Elementary School   Regular School No Elementary PK 05 2020   grade_2 81 0 8   0 5     0   4   59 39                       98 81 0 8   0 5     0   4   59 39                 98
1804966 CO     school 803450 900   Douglas County Re 1 80345001639 9592 Wildcat Mountain Elementary School   Regular School No Elementary PK 05 2020   grade_2 60 0 13   0 3     0   10   50 36                       86 60 0 13   0 3     0   10   50 36                 86
1810296 CO     school 807290 2515   Wiggins RE-50(J) 80729001257 9576 Wiggins Elementary School   Regular School No Elementary PK 06 2020   grade_2 20 1 14   0 0     0   1   14 22                       36 20 1 14   0 0     0   1   14 22                 36
1805493 CO     school 806480 990   Widefield 3 80648001128 9562 Widefield Elementary School of the Arts   Regular School No Elementary KG 05 2020   grade_2 36 6 16   0 1     0   5   39 25                       64 36 6 16   0 1     0   5   39 25                 64
1802489 CO     school 802490 480   Boulder Valley Re 2 80249000139 9544 Whittier Elementary School   Regular School No Elementary KG 05 2020   grade_2 43 0 14   0 5     0   2   36 28                       64 43 0 14   0 5     0   2   36 28                 64
1804173 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2020   grade_2 1 12 10   0 1     0   1   8 17                       25 1 12 10   0 1     0   1   8 17                 25
1801488 CO     school 802340 180   Adams-Arapahoe 28J 80234000083 9514 Wheeling Elementary School   Regular School No Elementary PK 05 2020   grade_2 11 13 49   1 3     1   6   39 45                       84 11 13 49   1 3     1   6   39 45                 84
1799830 CO     school 806900 20   Adams 12 Five Star Schools 80690001195 9494 Westview Elementary School   Regular School No Elementary PK 05 2020   grade_2 33 1 29   1 3     0   4   33 38                       71 33 1 29   1 3     0   4   33 38                 71
1808387 CO     school 804800 1420   Jefferson County R-1 80480001451 9490 Westridge Elementary School   Regular School No Elementary PK 05 2020   grade_2 49 1 8   0 3     0   7   39 29                       68 49 1 8   0 3     0   7   39 29                 68
1808552 CO     school 805190 1510   Lake County R-1 80519000859 9486 Westpark Elementary School   Regular School No Elementary KG 02 2020   grade_2 26 0 40   0 0     0   0   36 30                       66 26 0 40   0 0     0   0   36 30                 66
1800267 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_2 6 0 28   0 0     0   3   16 21                       37 6 0 28   0 0     0   3   16 21                 37
1808336 CO     school 804800 1420   Jefferson County R-1 80480000801 9412 Westgate Elementary School   Regular School No Elementary PK 05 2020   grade_2 30 2 35   0 1     0   6   38 36                       74 30 2 35   0 1     0   6   38 36                 74
1799815 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_2 32 1 11   0 2     0   3   22 27                       49 32 1 11   0 2     0   3   22 27                 49
1804158 CO     school 803360 880   Denver County 1 80336001957 9425 Westerly Creek Elementary   Regular School No Elementary PK 05 2020   grade_2 84 5 16   1 4     0   6   64 52                       116 84 5 16   1 4     0   6   64 52                 116
1808370 CO     school 804800 1420   Jefferson County R-1 80480001549 9429 West Woods Elementary School   Regular School No Elementary KG 05 2020   grade_2 77 1 8   0 4     0   1   40 51                       91 77 1 8   0 4     0   1   40 51                 91
1800096 CO     school 802580 40   School District 27J 80258006326 9426 West Ridge Elementary   Regular School No Elementary PK 05 2020   grade_2 58 1 31   0 7     0   4   48 53                       101 58 1 31   0 7     0   4   48 53                 101
1812005 CO     school 804410 3120   Greeley 6 80441006504 9611 West Ridge Academy   Regular School Yes Elementary KG 08 2020   grade_2 37 2 10   0 1     0   0   25 25                       50 37 2 10   0 1     0   0   25 25                 50
1808345 CO     school 804800 1420   Jefferson County R-1 80480000800 9424 West Jefferson Elementary School   Regular School No Elementary PK 05 2020   grade_2 42 0 0   0 0     0   2   25 19                       44 42 0 0   0 0     0   2   25 19                 44
1807048 CO     school 805070 1340   West Grand 1-JT 80507000829 9422 West Grand Elementary and Middle School   Regular School No Elementary KG 08 2020   grade_2 23 0 6   0 0     0   1   18 12                       30 23 0 6   0 0     0   1   18 12                 30
1805952 CO     school 803060 1010   Colorado Springs 11 80306006416 9445 West Elementary School   Regular School No Elementary PK 05 2020   grade_2 17 1 9   0 0     1   4   15 17                       32 17 1 9   0 0     1   4   15 17                 32
1809091 CO     school 803990 1550   Poudre R-1 80399001440 9380 Werner Elementary School   Regular School No Elementary KG 05 2020   grade_2 76 1 8   0 2     0   4   44 47                       91 76 1 8   0 2     0   4   44 47                 91
1810277 CO     school 807140 2505   Weldon Valley RE-20(J) 80714001217 9352 Weldon Valley Elementary School   Regular School No Elementary PK 06 2020   grade_2 15 0 2   0 0     0   0   12 5                       17 15 0 2   0 0     0   0   12 5                 17
1808328 CO     school 804800 1420   Jefferson County R-1 80480000799 9342 Welchester Elementary School   Regular School No Elementary PK 05 2020   grade_2 29 3 10   1 0     0   1   26 18                       44 29 3 10   1 0     0   1   26 18                 44
1799366 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_2 9 0 29   1 1     0   0   18 22                       40 9 0 29   1 1     0   0   18 22                 40
1805576 CO     school 804080 1000   Fountain 8 80408006481 9610 Weikel Elementary School   Regular School No Elementary PK 05 2020   grade_2 61 12 11   2 3     1   8   56 42                       98 61 12 11   2 3     1   8   56 42                 98
1805482 CO     school 806480 990   Widefield 3 80648001127 9334 Webster Elementary School   Regular School No Elementary KG 05 2020   grade_2 34 12 28   2 1     0   6   52 31                       83 34 12 28   2 1     0   6   52 31                 83
1808320 CO     school 804800 1420   Jefferson County R-1 80480000798 9328 Weber Elementary School   Regular School No Elementary KG 05 2020   grade_2 41 0 13   0 0     0   5   34 25                       59 41 0 13   0 0     0   5   34 25                 59
1810338 CO     school 806270 2530   Rocky Ford R-2 80627001104 9264 Washington Primary School   Regular School No Elementary PK 02 2020   grade_2 13 0 51   1 0     1   0   39 27                       66 13 0 51   1 0     1   0   39 27                 66
1806806 CO     school 802790 1140   Canon City RE-1 80279000176 9248 Washington Elementary School   Regular School No Elementary KG 05 2020   grade_2 43 0 10   0 1     0   1   25 30                       55 43 0 10   0 1     0   1   25 30                 55
1810597 CO     school 805220 2660   Lamar Re-2 80522000865 9268 Washington Elementary School   Regular School No Elementary KG 02 2020   grade_2 34 0 59   0 1     0   3   58 39                       97 34 0 59   0 1     0   3   58 39                 97
1808303 CO     school 804800 1420   Jefferson County R-1 80480000796 9232 Warder Elementary School   Regular School No Elementary PK 05 2020   grade_2 35 0 13   0 0     0   0   26 22                       48 35 0 13   0 0     0   0   26 22                 48
1807000 CO     school 806240 1195   Garfield Re-2 80624001358 9231 Wamsley Elementary School   Regular School No Elementary PK 05 2020   grade_2 16 0 30   0 0     0   2   22 26                       48 16 0 30   0 0     0   2   22 26                 48
1801586 CO     school 807110 230   Walsh RE-1 80711001215 9222 Walsh Elementary School   Regular School No Elementary PK 06 2020   grade_2 15 0 4   0 0     0   0   12 7                       19 15 0 4   0 0     0   0   12 7                 19
1800836 CO     school 802910 130   Cherry Creek 5 80291000206 9200 Walnut Hills Community Elementary School   Regular School No Elementary PK 05 2020   grade_2 30 2 7   0 7     0   3   32 17                       49 30 2 7   0 7     0   3   32 17                 49
1808295 CO     school 804800 1420   Jefferson County R-1 80480000794 9154 Vivian Elementary School   Regular School No Elementary PK 05 2020   grade_2 9 0 10   1 2     1   1   8 16                       24 9 0 10   1 2     1   1   8 16                 24
1801442 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_2 39 12 51   0 7     0   14   67 56                       123 39 12 51   0 7     0   14   67 56                 123
1802782 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2020   grade_2 27 0 3   0 0     0   3   16 17                       33 27 0 3   0 0     0   3   16 17                 33
1801458 CO     school 802340 180   Adams-Arapahoe 28J 80234000081 9140 Virginia Court Elementary School   Regular School No Elementary PK 05 2020   grade_2 7 10 28   2 3     0   3   35 18                       53 7 10 28   2 3     0   3   35 18                 53
1811026 CO     school 806150 2700   Pueblo County 70 80615001084 9130 Vineland Elementary School   Regular School No Elementary PK 05 2020   grade_2 27 0 15   0 0     0   4   24 22                       46 27 0 15   0 0     0   4   24 22                 46
1800829 CO     school 802910 130   Cherry Creek 5 80291000204 9108 Village East Community Elementary School   Regular School No Elementary PK 05 2020   grade_2 27 39 48   0 9     0   6   64 65                       129 27 39 48   0 9     0   6   64 65                 129
1811021 CO     school 806150 2700   Pueblo County 70 80615006773 9084 Villa Bella Expeditionary School   Regular School Yes Elementary KG 05 2020   grade_2 19 0 29   0 0     0   2   23 27                       50 19 0 29   0 0     0   2   23 27                 50
1801635 CO     school 806990 260   Vilas RE-5 80699001206 9090 Vilas Elementary School   Regular School No Elementary PK 06 2020   grade_2 8 0 0   0 0     0   0   4 4                       8 8 0 0   0 0     0   0   4 4                 8
1805460 CO     school 806480 990   Widefield 3 80648001124 8122 Venetucci Elementary School   Regular School No Elementary KG 05 2020   grade_2 30 6 16   0 0     1   7   35 25                       60 30 6 16   0 0     1   7   35 25                 60
1801409 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 07 2020   grade_2 4 4 19   0 12     0   0   20 19                       39 4 4 19   0 12     0   0   20 19                 39
1801434 CO     school 802340 180   Adams-Arapahoe 28J 80234000080 9060 Vaughn Elementary School   Regular School No Elementary PK 05 2020   grade_2 4 4 37   2 4     1   3   33 22                       55 4 4 37   2 4     1   3   33 22                 55
1801426 CO     school 802340 180   Adams-Arapahoe 28J 80234001294 9059 Vassar Elementary School   Regular School No Elementary PK 05 2020   grade_2 15 14 24   2 4     3   12   43 31                       74 15 14 24   2 4     3   12   43 31                 74
1801416 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_2 8 12 26   0 1     0   1   24 24                       48 8 12 26   0 1     0   1   24 24                 48
1801469 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_2 10 34 24   0 0     0   3   30 41                       71 10 34 24   0 0     0   3   30 41                 71
1808287 CO     school 804800 1420   Jefferson County R-1 80480000793 9058 Vanderhoof Elementary School   Regular School No Elementary KG 05 2020   grade_2 52 0 11   0 3     0   0   36 30                       66 52 0 11   0 3     0   0   36 30                 66
1808278 CO     school 804800 1420   Jefferson County R-1 80480001056 9052 Van Arsdale Elementary School   Regular School No Elementary PK 05 2020   grade_2 43 0 9   0 0     0   1   28 25                       53 43 0 9   0 0     0   1   28 25                 53
1804138 CO     school 803360 880   Denver County 1 80336000421 9050 Valverde Elementary School   Regular School No Elementary PK 05 2020   grade_2 0 3 30   0 0     0   1   22 12                       34 0 3 30   0 0     0   1   22 12                 34
1802895 CO     school 803360 880   Denver County 1 80336000420 408 Valdez Elementary School   Regular School No Elementary PK 05 2020   grade_2 15 0 38   0 0     0   1   28 26                       54 15 0 38   0 0     0   1   28 26                 54
1806059 CO     school 805490 1030   Manitou Springs 14 80549000948 9010 Ute Pass Elementary School   Regular School No Elementary PK 06 2020   grade_2 11 0 3   0 1     0   1   7 9                       16 11 0 3   0 1     0   1   7 9                 16
1808270 CO     school 804800 1420   Jefferson County R-1 80480001450 9008 Ute Meadows Elementary School   Regular School No Elementary KG 05 2020   grade_2 52 0 7   0 2     0   2   33 30                       63 52 0 7   0 2     0   2   33 30                 63
1811424 CO     school 806810 3000   Summit RE-1 80681001564 8993 Upper Blue Elementary School   Regular School No Elementary PK 05 2020   grade_2 24 0 17   0 1     0   1   21 22                       43 24 0 17   0 1     0   1   21 22                 43
1811858 CO     school 804410 3120   Greeley 6 80441001696 2850 University Schools   Regular School Yes Other KG 12 2020   grade_2 69 0 39   0 0     0   4   57 55                       112 69 0 39   0 0     0   4   57 55                 112
1803849 CO     school 803360 880   Denver County 1 80336001576 6957 University Prep - Steele St.   Regular School Yes Elementary PK 05 2020   grade_2 4 10 37   1 0     0   4   27 29                       56 4 10 37   1 0     0   4   27 29                 56
1804116 CO     school 803360 880   Denver County 1 80336006517 8945 University Prep - Arapahoe St.   Regular School Yes Elementary KG 05 2020   grade_2 2 39 20   0 0     0   2   32 31                       63 2 39 20   0 0     0   2   32 31                 63
1804123 CO     school 803360 880   Denver County 1 80336000419 8970 University Park Elementary School   Regular School No Elementary KG 05 2020   grade_2 51 4 9   2 5     0   3   42 32                       74 51 4 9   2 5     0   3   42 32                 74
1802481 CO     school 802490 480   Boulder Valley Re 2 80249000135 8978 University Hill Elementary School   Regular School No Elementary PK 05 2020   grade_2 22 1 46   1 0     0   2   36 36                       72 22 1 46   1 0     0   2   36 36                 72
1811994 CO     school 804410 3120   Greeley 6 80441001615 8965 Union Colony Schools   Regular School Yes Other KG 12 2020   grade_2 21 5 44   0 3     2   2   34 43                       77 21 5 44   0 3     2   2   34 43                 77
1812058 CO     school 804020 3140   Weld Re-8 Schools 80402001366 8930 Twombly Elementary School   Regular School No Elementary PK 05 2020   grade_2 17 1 58   0 0     0   0   30 46                       76 17 1 58   0 0     0   0   30 46                 76
1808241 CO     school 804800 1420   Jefferson County R-1 80480006466 8793 Two Roads Charter School   Regular School Yes Other PK 12 2020   grade_2 27 0 6   0 0     0   0   14 19                       33 27 0 6   0 0     0   0   14 19                 33
1812517 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2020   grade_2 28 1 12   0 0     0   1   22 20                       42 28 1 12   0 0     0   1   22 20                 42
1802093 CO     school 805370 470   St Vrain Valley RE1J 80537001572 8927 Twin Peaks Charter Academy   Regular School Yes Other KG 12 2020   grade_2 30 0 21   0 5     0   1   31 26                       57 30 0 21   0 5     0   1   31 26                 57
1800954 CO     school 805310 140   Littleton 6 80531000891 5574 Twain Elementary School   Regular School No Elementary KG 05 2020   grade_2 37 1 5   0 4     0   4   37 14                       51 37 1 5   0 4     0   4   37 14                 51
1805811 CO     school 803060 1010   Colorado Springs 11 80306000252 5576 Twain Elementary School   Regular School No Elementary PK 05 2020   grade_2 28 9 28   0 0     0   3   31 37                       68 28 9 28   0 0     0   3   31 37                 68
1800084 CO     school 802580 40   School District 27J 80258006401 8820 Turnberry Elementary   Regular School No Elementary PK 05 2020   grade_2 46 3 43   1 3     0   2   53 45                       98 46 3 43   1 3     0   2   53 45                 98
1805387 CO     school 804530 980   Harrison 2 80453001443 8923 Turman Elementary School   Regular School No Elementary PK 05 2020   grade_2 14 4 24   0 2     0   2   27 19                       46 14 4 24   0 2     0   2   27 19                 46
1809300 CO     school 805400 1560   Thompson R2-J 80540000939 8918 Truscott Elementary School   Regular School No Elementary KG 05 2020   grade_2 12 0 24   0 1     0   0   22 15                       37 12 0 24   0 1     0   0   22 15                 37
1804108 CO     school 803360 880   Denver County 1 80336006389 8909 Trevista at Horace Mann   Regular School No Elementary PK 05 2020   grade_2 1 7 32   0 1     0   1   20 22                       42 1 7 32   0 1     0   1   20 22                 42
1804100 CO     school 803360 880   Denver County 1 80336000418 8888 Traylor Academy   Regular School No Elementary PK 05 2020   grade_2 8 4 44   2 1     0   2   34 27                       61 8 4 44   2 1     0   2   34 27                 61
1809065 CO     school 803990 1550   Poudre R-1 80399000606 9251 Traut Core Elementary School   Regular School No Elementary PK 05 2020   grade_2 57 0 4   1 5     0   8   41 34                       75 57 0 4   1 5     0   8   41 34                 75
1799447 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_2 9 0 18   0 0     0   0   16 11                       27 9 0 18   0 0     0   0   16 11                 27
1800821 CO     school 802910 130   Cherry Creek 5 80291001330 8887 Trails West Elementary School   Regular School No Elementary PK 05 2020   grade_2 53 2 9   0 2     0   3   44 25                       69 53 2 9   0 2     0   3   44 25                 69

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