Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 13,321
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
1799666 CO     school 806900 20   Adams 12 Five Star Schools 80690001183 5814 The International School at Thornton Middle   Regular School No Middle 06 08 2020   pk_12_total 125 47 785   5 17     2   13   543 451                       994 125 47 785   5 17     2   13   543 451                 994
1810686 CO     school 806120 2690   Pueblo City 60 80612001035 1402 Centennial High School   Regular School No High 09 12 2020   pk_12_total 293 26 631   4 17     3   20   480 514                       994 293 26 631   4 17     3   20   480 514                 994
1803797 CO     school 803360 880   Denver County 1 80336006660 6368 Northfield High School   Regular School No High 09 12 2020   pk_12_total 376 168 349   2 20     4   71   464 526                       990 376 168 349   2 20     4   71   464 526                 990
1799532 CO     school 806900 20   Adams 12 Five Star Schools 80690001305 1914 Cotton Creek Elementary School   Regular School No Elementary KG 05 2020   grade_3 63 1 22   0 5     0   8   53 46                       99 63 1 22   0 5     0   8   53 46                 99
1799929 CO     school 802580 40   School District 27J 80258006549 1013 Brantner Elementary School   Regular School No Elementary PK 05 2020   grade_1 62 2 29   0 5     0   1   49 50                       99 62 2 29   0 5     0   1   49 50                 99
1800326 CO     school 803780 120   Englewood 1 80378001310 206 Colorado's Finest High School of Choice   Alternative School No High 09 12 2020   grade_12 64 5 26   1 0     0   3   56 43                       99 64 5 26   1 0     0   3   56 43                 99
1800463 CO     school 802910 130   Cherry Creek 5 80291006301 1155 Buffalo Trail Elementary School   Regular School No Elementary PK 06 2020   grade_1 56 6 15   1 11     0   10   47 52                       99 56 6 15   1 11     0   10   47 52                 99
1800548 CO     school 802910 130   Cherry Creek 5 80291001404 1970 Creekside Elementary School   Regular School No Elementary PK 05 2020   grade_1 68 6 10   0 13     0   2   58 41                       99 68 6 10   0 13     0   2   58 41                 99
1800749 CO     school 802910 130   Cherry Creek 5 80291000200 7116 Ponderosa Elementary School   Regular School No Elementary PK 05 2020   grade_1 15 31 39   0 7     1   6   45 54                       99 15 31 39   0 7     1   6   45 54                 99
1801034 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_5 6 21 62   0 0     0   10   51 48                       99 6 21 62   0 0     0   10   51 48                 99
1801312 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_3 74 5 15   0 1     0   4   45 54                       99 74 5 15   0 1     0   4   45 54                 99
1801314 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_5 67 3 21   0 1     0   7   48 51                       99 67 3 21   0 1     0   7   48 51                 99
1801356 CO     school 802340 180   Adams-Arapahoe 28J 80234006677 7233 Rocky Mountain Prep: Fletcher   Regular School Yes Elementary PK 05 2020   grade_2 12 18 63   0 2     0   4   55 44                       99 12 18 63   0 2     0   4   55 44                 99
1801967 CO     school 805370 470   St Vrain Valley RE1J 80537000914 5726 Mead Elementary School   Regular School No Elementary PK 05 2020   grade_1 82 0 14   1 0     0   2   50 49                       99 82 0 14   1 0     0   2   50 49                 99
1801981 CO     school 805370 470   St Vrain Valley RE1J 80537006594 6010 Timberline PK-8   Regular School No Elementary PK 08 2020   grade_3 15 2 82   0 0     0   0   48 51                       99 15 2 82   0 0     0   0   48 51                 99
1802217 CO     school 802490 480   Boulder Valley Re 2 80249000110 1996 Crest View Elementary School   Regular School No Elementary KG 05 2020   grade_5 65 2 24   0 3     0   5   47 52                       99 65 2 24   0 3     0   5   47 52                 99
1802495 CO     school 802640 490   Buena Vista R-31 80264006767 137 The Grove, BVSD's Early Learning Program   Regular School No Prekindergarten PK PK 2020   pk_12_total 84 0 9   1 1     0   4   59 40                       99 84 0 9   1 1     0   4   59 40                 99
1802496 CO     school 802640 490   Buena Vista R-31 80264006767 137 The Grove, BVSD's Early Learning Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 84 0 9   1 1     0   4   59 40                       99 84 0 9   1 1     0   4   59 40                 99
1802500 CO     school 802640 490   Buena Vista R-31 80264000157 1130 Buena Vista High School   Regular School No High 09 12 2020   grade_9 76 1 15   0 1     0   6   46 53                       99 76 1 15   0 1     0   6   46 53                 99
1802528 CO     school 806330 500   Salida R-32 80633001107 4680 Salida Middle School   Regular School No Middle 05 08 2020   grade_5 74 2 15   3 0     0   5   49 50                       99 74 2 15   3 0     0   5   49 50                 99
1803785 CO     school 803360 880   Denver County 1 80336001869 6350 Bruce Randolph School   Regular School No High 06 12 2020   grade_10 1 2 93   0 0     0   3   39 60                       99 1 2 93   0 0     0   3   39 60                 99
1803806 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   pre_kindergarten 35 0 56   0 3     0   5   45 54                       99 35 0 56   0 3     0   5   45 54                 99
1803821 CO     school 803360 880   Denver County 1 80336001838 6508 Omar D Blair Charter School   Regular School Yes Elementary KG 08 2020   grade_5 5 49 27   0 9     4   5   46 53                       99 5 49 27   0 9     4   5   46 53                 99
1803860 CO     school 803360 880   Denver County 1 80336001933 6970 Florida Pitt-Waller ECE-8 School   Regular School No Elementary PK 08 2020   grade_6 7 23 61   1 3     4   0   46 53                       99 7 23 61   1 3     4   0   46 53                 99
1803861 CO     school 803360 880   Denver County 1 80336001933 6970 Florida Pitt-Waller ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 3 32 50   0 5     4   5   44 55                       99 3 32 50   0 5     4   5   44 55                 99
1803872 CO     school 803360 880   Denver County 1 80336006398 7045 Place Bridge Academy   Regular School No Elementary PK 08 2020   grade_7 7 29 43   0 19     0   1   60 39                       99 7 29 43   0 19     0   1   60 39                 99
1804251 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_6 81 2 11   0 3     0   2   42 57                       99 81 2 11   0 3     0   2   42 57                 99
1804322 CO     school 803450 900   Douglas County Re 1 80345006368 266 Gold Rush Elementary   Regular School No Elementary PK 05 2020   grade_5 80 1 11   0 4     0   3   48 51                       99 80 1 11   0 4     0   3   48 51                 99
1804517 CO     school 803450 900   Douglas County Re 1 80345006337 2952 Mammoth Heights Elementary   Regular School No Elementary PK 06 2020   grade_5 71 3 14   0 2     0   9   47 52                       99 71 3 14   0 2     0   9   47 52                 99
1804569 CO     school 803450 900   Douglas County Re 1 80345001875 3241 Frontier Valley Elementary School   Regular School No Elementary PK 05 2020   grade_5 79 0 14   0 1     0   5   59 40                       99 79 0 14   0 1     0   5   59 40                 99
1804757 CO     school 803450 900   Douglas County Re 1 80345001339 6406 Northridge Elementary School   Regular School No Elementary PK 06 2020   grade_4 65 3 12   0 12     0   7   44 55                       99 65 3 12   0 12     0   7   44 55                 99
1804794 CO     school 803450 900   Douglas County Re 1 80345000444 6940 Pine Lane Elementary   Regular School No Elementary PK 06 2020   grade_6 73 2 17   0 3     0   4   52 47                       99 73 2 17   0 3     0   4   52 47                 99
1805405 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 45 9 28   0 2     3   12   50 49                       99 45 9 28   0 2     3   12   50 49                 99
1805471 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   grade_2 46 4 34   0 2     3   10   44 55                       99 46 4 34   0 2     3   10   44 55                 99
1805556 CO     school 804080 1000   Fountain 8 80408001481 4474 Jordahl Elementary School   Regular School No Elementary KG 05 2020   grade_3 50 4 27   2 1     2   13   50 49                       99 50 4 27   2 1     2   13   50 49                 99
1805906 CO     school 803060 1010   Colorado Springs 11 80306001641 7705 Scott Elementary School   Regular School No Elementary PK 05 2020   grade_4 68 7 14   0 0     1   9   54 45                       99 68 7 14   0 0     1   9   54 45                 99
1805949 CO     school 803060 1010   Colorado Springs 11 80306000272 9404 West Middle School   Regular School No Middle 06 08 2020   grade_8 69 6 14   1 1     0   8   55 44                       99 69 6 14   1 1     0   8   55 44                 99
1806078 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_5 63 2 9   0 13     2   10   48 51                       99 63 2 9   0 13     2   10   48 51                 99
1806252 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2020   grade_1 65 3 15   0 2     0   14   49 50                       99 65 3 15   0 2     0   14   49 50                 99
1806427 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy   Regular School Yes Elementary PK 08 2020   grade_4 79 1 13   0 2     0   4   47 52                       99 79 1 13   0 2     0   4   47 52                 99
1806661 CO     school 803870 1110   District 49 80387001898 7339 Ridgeview Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 59 8 16   0 2     0   14   58 41                       99 59 8 16   0 2     0   14   58 41                 99
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
1806817 CO     school 803960 1150   Fremont RE-2 80396000514 3002 Florence Jr./Sr. High School   Regular School No High 07 12 2020   grade_9 78 1 16   1 0     0   3   56 43                       99 78 1 16   1 0     0   3   56 43                 99
1806929 CO     school 804260 1180   Roaring Fork RE-1 80426000590 7422 Roaring Fork High School   Regular School No High 09 12 2020   grade_9 49 0 50   0 0     0   0   59 40                       99 49 0 50   0 0     0   0   59 40                 99
1807519 CO     school 804800 1420   Jefferson County R-1 80480000721 2866 Fairmount Elementary School   Regular School No Elementary KG 05 2020   grade_3 87 0 2   0 5     0   5   60 39                       99 87 0 2   0 5     0   5   60 39                 99
1807920 CO     school 804800 1420   Jefferson County R-1 80480006311 6139 Mountain Phoenix Community School   Regular School Yes Elementary PK 08 2020   kindergarten_full_day 80 1 12   0 1     0   5   49 50                       99 80 1 12   0 1     0   5   49 50                 99
1809364 CO     school 806960 1580   Trinidad 1 80696001946 2944 Fisher's Peak Elementary School   Regular School No Elementary 02 05 2020   grade_5 24 0 71   2 0     0   2   52 47                       99 24 0 71   2 0     0   2   52 47                 99
1809880 CO     school 804350 2000   Mesa County Valley 51 80435000623 7236 R-5 High School   Alternative School No High 06 12 2020   grade_11 49 3 41   2 0     0   4   59 40                       99 49 3 41   2 0     0   4   59 40                 99
1811162 CO     school 806660 2770   Steamboat Springs RE-2 80666001749 6363 North Routt Charter School   Regular School Yes Elementary KG 08 2020   pk_12_total 93 0 2   1 1     0   2   50 49                       99 93 0 2   1 1     0   2   50 49                 99
1811334 CO     school 804860 2862   Julesburg Re-1 80486006387 4369 Destinations Career Academy of Colorado   Alternative School No High 06 12 2020   grade_8 46 7 35   0 3     1   7   53 46                       99 46 7 35   0 3     1   7   53 46                 99
1811578 CO     school 804200 3080   Weld County RE-1 80420000577 4854 North Valley Middle School   Regular School No Middle 06 08 2020   grade_8 38 0 56   3 0     0   2   50 49                       99 38 0 56   3 0     0   2   50 49                 99
1811660 CO     school 804920 3090   Weld County School District RE-3J 80492006743 5855 Meadow Ridge Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten 49 1 47   0 1     0   1   44 55                       99 49 1 47   0 1     0   1   44 55                 99
1811709 CO     school 807350 3100   Windsor RE-4 80735006650 9393 Windsor Charter Academy Early College High School   Regular School Yes High 09 12 2020   grade_10 80 0 9   1 6     0   3   46 53                       99 80 0 9   1 6     0   3   46 53                 99
1811844 CO     school 804410 3120   Greeley 6 80441001482 2222 Dos Rios Elementary School   Regular School No Elementary KG 05 2020   grade_5 23 2 70   0 1     1   2   46 53                       99 23 2 70   0 1     1   2   46 53                 99
1811963 CO     school 804410 3120   Greeley 6 80441000633 6774 Martinez Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 5 7 84   0 2     0   1   49 50                       99 5 7 84   0 2     0   1   49 50                 99
1812097 CO     school 802550 3146   Briggsdale RE-10 80255000143 1012 Briggsdale Undivided High School   Regular School No High 06 12 2020   pk_12_total 83 0 13   0 2     0   1   56 43                       99 83 0 13   0 2     0   1   56 43                 99
1812535 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_6 63 3 21   1 2     0   9   49 50                       99 63 3 21   1 2     0   9   49 50                 99
1806243 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2020   pk_12_total 625 42 187   1 49     8   77   484 505                       989 625 42 187   1 49     8   77   484 505                 989
1800508 CO     school 802910 130   Cherry Creek 5 80291000186 1570 Cherry Creek High School   Regular School No High 09 12 2020   grade_9 628 38 143   2 128     3   46   495 493                       988 628 38 143   2 128     3   46   495 493                 988
1810735 CO     school 806120 2690   Pueblo City 60 80612001040 2394 East High School   Regular School No High 09 12 2020   pk_12_total 190 24 744   7 3     4   14   527 459                       986 190 24 744   7 3     4   14   527 459                 986
1801320 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   pk_12_total 720 25 177   0 20     0   42   489 495                       984 720 25 177   0 20     0   42   489 495                 984
1800639 CO     school 802910 130   Cherry Creek 5 80291001328 4100 Horizon Middle School   Regular School No Middle 06 08 2020   pk_12_total 357 166 330   6 48     4   72   525 458                       983 357 166 330   6 48     4   72   525 458                 983
1799310 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2020   grade_12 10 3 83   0 1     0   1   49 49                       98 10 3 83   0 1     0   1   49 49                 98
1799475 CO     school 806900 20   Adams 12 Five Star Schools 80690001733 59 Meridian Elementary School   Regular School No Elementary KG 05 2020   grade_4 76 1 13   0 4     0   4   48 50                       98 76 1 13   0 4     0   4   48 50                 98
1799492 CO     school 806900 20   Adams 12 Five Star Schools 80690001619 301 Arapahoe Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_5 40 2 46   0 6     0   4   53 45                       98 40 2 46   0 6     0   4   53 45                 98
1799679 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   grade_3 60 0 22   1 7     0   8   62 36                       98 60 0 22   1 7     0   8   62 36                 98
1799714 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_1 72 0 9   1 8     0   8   52 46                       98 72 0 9   1 8     0   8   52 46                 98
1800008 CO     school 802580 40   School District 27J 80258000149 6395 Northeast Elementary School   Regular School No Elementary PK 06 2020   grade_1 31 1 63   0 2     0   1   56 42                       98 31 1 63   0 2     0   1   56 42                 98
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
1800452 CO     school 802910 130   Cherry Creek 5 80291001879 442 Aspen Crossing Elementary School   Regular School No Elementary PK 05 2020   grade_5 53 12 13   0 10     0   10   48 50                       98 53 12 13   0 10     0   10   48 50                 98
1800653 CO     school 802910 130   Cherry Creek 5 80291000196 4276 Independence Elementary School   Regular School No Elementary PK 05 2020   grade_4 37 19 27   1 0     1   13   51 47                       98 37 19 27   1 0     1   13   51 47                 98
1800700 CO     school 802910 130   Cherry Creek 5 80291006607 6225 Mountain Vista Elementary School   Regular School No Elementary PK 05 2020   grade_4 46 18 15   0 5     0   14   56 42                       98 46 18 15   0 5     0   14   56 42                 98
1800763 CO     school 802910 130   Cherry Creek 5 80291001880 7277 Red Hawk Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_4 45 14 19   1 8     1   10   61 37                       98 45 14 19   1 8     1   10   61 37                 98
1800842 CO     school 802910 130   Cherry Creek 5 80291000206 9200 Walnut Hills Community Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 44 2 14   0 29     0   9   53 45                       98 44 2 14   0 29     0   9   53 45                 98
1800845 CO     school 802910 130   Cherry Creek 5 80291000208 9624 Willow Creek Elementary School   Regular School No Elementary PK 05 2020   grade_3 64 1 9   0 12     0   12   53 45                       98 64 1 9   0 12     0   12   53 45                 98
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
1801059 CO     school 802340 180   Adams-Arapahoe 28J 80234000052 214 Altura Elementary School   Regular School No Elementary PK 05 2020   grade_5 7 5 83   1 0     0   2   52 46                       98 7 5 83   1 0     0   2   52 46                 98
1801398 CO     school 802340 180   Adams-Arapahoe 28J 80234000084 8356 William Smith High School   Regular School No High 09 12 2020   grade_12 22 12 58   1 1     1   3   51 47                       98 22 12 58   1 1     1   3   51 47                 98
1801402 CO     school 802340 180   Adams-Arapahoe 28J 80234001324 8858 Tollgate Elementary School of Expeditionary Learning   Regular School No Elementary KG 05 2020   grade_2 16 18 50   1 5     4   4   46 52                       98 16 18 50   1 5     4   4   46 52                 98
1801429 CO     school 802340 180   Adams-Arapahoe 28J 80234001294 9059 Vassar Elementary School   Regular School No Elementary PK 05 2020   grade_5 14 22 47   0 6     0   9   60 38                       98 14 22 47   0 6     0   9   60 38                 98
1802327 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2020   pk_12_total 27 2 59   0 0     0   10   70 28                       98 27 2 59   0 0     0   10   70 28                 98
1803024 CO     school 803360 880   Denver County 1 80336001862 1748 Colorado High School Charter   Alternative School Yes High 09 12 2020   grade_9 1 26 66   1 1     0   3   55 43                       98 1 26 66   1 1     0   3   55 43                 98
1803388 CO     school 803360 880   Denver County 1 80336006473 3639 Girls Athletic Leadership School Middle School   Regular School Yes Middle 06 08 2020   grade_8 59 5 24   1 3     0   6   0 98                       98 59 5 24   1 3     0   6   0 98                 98
1803870 CO     school 803360 880   Denver County 1 80336006398 7045 Place Bridge Academy   Regular School No Elementary PK 08 2020   grade_5 11 32 33   1 20     0   1   51 47                       98 11 32 33   1 20     0   1   51 47                 98
1804311 CO     school 803450 900   Douglas County Re 1 80345006392 265 Clear Sky Elementary   Regular School No Elementary PK 06 2020   grade_3 67 2 19   0 3     0   7   45 53                       98 67 2 19   0 3     0   7   45 53                 98
1804524 CO     school 803450 900   Douglas County Re 1 80345006309 2953 Stone Mountain Elementary   Regular School No Elementary PK 06 2020   grade_3 83 0 9   0 3     0   3   50 48                       98 83 0 9   0 3     0   3   50 48                 98
1804659 CO     school 803450 900   Douglas County Re 1 80345006493 5259 STEM School Highlands Ranch   Regular School Yes Other KG 12 2020   grade_3 49 1 14   1 28     0   5   53 45                       98 49 1 14   1 28     0   5   53 45                 98
1804756 CO     school 803450 900   Douglas County Re 1 80345001339 6406 Northridge Elementary School   Regular School No Elementary PK 06 2020   grade_3 58 1 13   0 15     0   11   52 46                       98 58 1 13   0 15     0   11   52 46                 98
1805012 CO     school 803540 910   Eagle County RE 50 80354001531 793 Berry Creek Middle School   Regular School No Middle 06 08 2020   grade_7 23 0 71   4 0     0   0   39 59                       98 23 0 71   4 0     0   0   39 59                 98
1805557 CO     school 804080 1000   Fountain 8 80408001481 4474 Jordahl Elementary School   Regular School No Elementary KG 05 2020   grade_4 54 7 26   0 0     1   10   52 46                       98 54 7 26   0 0     1   10   52 46                 98
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
1806131 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   grade_1 77 3 7   0 6     1   4   49 49                       98 77 3 7   0 6     1   4   49 49                 98
1806296 CO     school 801920 1040   Academy 20 80192006336 7247 Ranch Creek Elementary   Regular School No Elementary PK 05 2020   grade_2 64 3 18   0 2     1   10   46 52                       98 64 3 18   0 2     1   10   46 52                 98
1806311 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2020   grade_10 72 2 13   1 4     0   6   41 57                       98 72 2 13   1 4     0   6   41 57                 98
1806425 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy   Regular School Yes Elementary PK 08 2020   grade_2 80 2 9   0 1     0   6   59 39                       98 80 2 9   0 1     0   6   59 39                 98
1806576 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2020   grade_2 58 2 18   1 7     1   11   50 48                       98 58 2 18   1 7     1   11   50 48                 98
1806926 CO     school 804260 1180   Roaring Fork RE-1 80426000590 7422 Roaring Fork High School   Regular School No High 09 12 2020   grade_10 38 0 57   0 1     0   2   52 46                       98 38 0 57   0 1     0   2   52 46                 98
1807010 CO     school 804380 1220   Garfield 16 80438000630 3578 Bea Underwood Elementary School   Regular School No Elementary 02 05 2020   grade_4 54 0 40   0 0     0   4   58 40                       98 54 0 40   0 0     0   4   58 40                 98
1808259 CO     school 804800 1420   Jefferson County R-1 80480006722 8856 Three Creeks K-8   Regular School No Elementary KG 08 2020   grade_1 78 2 10   1 5     0   2   54 44                       98 78 2 10   1 5     0   2   54 44                 98
1808677 CO     school 802400 1530   Bayfield 10 Jt-R 80240006747 642 Bayfield Primary School   Regular School No Elementary PK 02 2020   kindergarten_full_day 77 0 15   2 0     0   4   46 52                       98 77 0 15   2 0     0   4   46 52                 98

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