Data source: Big Local News · About: Big Local

1,091 rows where grade = "grade_2", state = "CO" and year = 2018 sorted by school_state_id

View and edit SQL

year

  • 2018 · 1,091

grade

  • grade_2 · 1,091
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
1898597 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_2 74 1 10   0 1     0   4   39 51                       90 74 1 10   0 1     0   4   39 51                 90
1898608 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 39 5 12   0 8     0   8   43 29                       72 39 5 12   0 8     0   8   43 29                 72
1893835 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 38 0 24   0 2     0   4   38 30                       68 38 0 24   0 2     0   4   38 30                 68
1906572 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2018   grade_2 82 1 23   0 6     1   11   64 60                       124 82 1 23   0 6     1   11   64 60                 124
1894779 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 55 2 10   1 16     0   9   46 47                       93 55 2 10   1 16     0   9   46 47                 93
1900386 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 68 2 15   0 0     0   5   41 49                       90 68 2 15   0 0     0   5   41 49                 90
1900394 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 58 6 13   0 10     0   6   49 44                       93 58 6 13   0 10     0   6   49 44                 93
1905269 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 31 0 29   0 3     0   8   40 31                       71 31 0 29   0 3     0   8   40 31                 71
1901438 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 42 0 15   0 2     0   0   31 28                       59 42 0 15   0 2     0   0   31 28                 59
1906585 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2018   grade_2 2 1 0   0 0     0   0   2 1                       3 2 1 0   0 0     0   0   2 1                 3
1899321 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 23 0 51   0 0     0   2   46 30                       76 23 0 51   0 0     0   2   46 30                 76
1899329 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 47 0 10   0 1     0   1   33 26                       59 47 0 10   0 1     0   1   33 26                 59
1904919 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2018   grade_2 14 0 0   0 1     0   0   7 8                       15 14 0 0   0 1     0   0   7 8                 15
1899552 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1906150 CO     school 804410 3120   GREELEY 6 80441001988 52 HEIMAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 45 1 52   0 4     2   1   46 59                       105 45 1 52   0 4     2   1   46 59                 105
1906158 CO     school 804410 3120   GREELEY 6 80441001989 53 WINOGRAD K-8 ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2018   grade_2 24 1 36   0 3     0   3   36 31                       67 24 1 36   0 3     0   3   36 31                 67
1906168 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2018   grade_2 13 7 84   1 1     0   2   61 47                       108 13 7 84   1 1     0   2   61 47                 108
1906041 CO     school 807350 3100   WINDSOR RE-4 80735001987 55 GRANDVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 57 2 10   0 0     0   2   39 32                       71 57 2 10   0 0     0   2   39 32                 71
1904745 CO     school 804110 2540   FOWLER R-4J 80411001981 56 FOWLER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2018   grade_2 24 1 9   0 0     0   1   16 19                       35 24 1 9   0 0     0   1   16 19                 35
1903750 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 5 0 5   0 0     0   0   4 6                       10 5 0 5   0 0     0   0   4 6                 10
1893847 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 100 5 13   0 3     0   4   63 62                       125 100 5 13   0 3     0   4   63 62                 125
1896067 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001830 60 LEGACY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 104 0 15   1 1     0   1   58 64                       122 104 0 15   1 1     0   1   58 64                 122
1896075 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001832 61 ALPINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 43 3 28   0 4     0   8   52 34                       86 43 3 28   0 4     0   8   52 34                 86
1901378 CO     school 807080 1390   HUERFANO RE-1 80708001845 63 PEAKVIEW SCHOOL   Regular School No Elementary PK 08 2018   grade_2 16 1 17   3 0     0   0   17 20                       37 16 1 17   3 0     0   0   17 20                 37
1896084 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006530 71 ASPEN RIDGE PREPARATORY SCHOOL   Regular School Yes Elementary KG 08 2018   grade_2 48 1 6   0 8     0   2   27 38                       65 48 1 6   0 8     0   2   27 38                 65
1905854 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2018   grade_2 25 0 6   0 0     0   2   20 13                       33 25 0 6   0 0     0   2   20 13                 33
1897234 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2018   grade_2 3 7 15   0 0     0   0   13 12                       25 3 7 15   0 0     0   0   13 12                 25
1900763 CO     school 803870 1110   FALCON 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2018   grade_2 17 0 3   0 0     1   2   10 13                       23 17 0 3   0 0     1   2   10 13                 23
1901462 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006489 109 ARVADA K-8   Regular School No Elementary KG 08 2018   grade_2 14 1 24   0 0     0   1   19 21                       40 14 1 24   0 0     0   1   19 21                 40
1894669 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 64 1 132   2 1     0   6   99 107                       206 64 1 132   2 1     0   6   99 107                 206
1896098 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2018   grade_2 58 0 8   1 3     0   2   36 36                       72 58 0 8   1 3     0   2   36 36                 72
1895387 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2018   grade_2 10 23 34   1 1     0   5   47 27                       74 10 23 34   1 1     0   5   47 27                 74
1898618 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006492 135 BEN FRANKLIN ACADEMY   Regular School Yes Elementary PK 08 2018   grade_2 87 0 9   0 6     0   2   50 54                       104 87 0 9   0 6     0   2   50 54                 104
1903021 CO     school 803990 1550   POUDRE R-1 80399001717 146 RIDGEVIEW CLASSICAL CHARTER SCHOOLS   Regular School Yes Other KG 12 2018   grade_2 47 1 7   0 2     0   5   38 24                       62 47 1 7   0 2     0   5   38 24                 62
1901472 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 12 0 12   0 0     0   1   18 7                       25 12 0 12   0 0     0   1   18 7                 25
1894239 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 9 0 76   1 0     0   3   52 37                       89 9 0 76   1 0     0   3   52 37                 89
1904963 CO     school 805220 2660   LAMAR RE-2 80522000860 200 ALTA VISTA CHARTER SCHOOL   Regular School Yes Elementary KG 06 2018   grade_2 11 1 7   0 0     0   1   8 12                       20 11 1 7   0 0     0   1   8 12                 20
1895397 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2018   grade_2 10 16 26   0 0     0   4   30 26                       56 10 16 26   0 0     0   4   30 26                 56
1895408 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 8 12 62   0 4     0   1   49 38                       87 8 12 62   0 4     0   1   49 38                 87
1898633 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2018   grade_2 202 0 18   5 54     0   21   170 130                       300 202 0 18   5 54     0   21   170 130                 300
1897242 CO     school 803360 880   DENVER COUNTY 1 80336000306 220 AMESSE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 1 7 49   1 0     0   2   35 25                       60 1 7 49   1 0     0   2   35 25                 60
1902875 CO     school 803480 1520   DURANGO 9-R 80348001066 225 ANIMAS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 29 1 12   1 0     0   2   20 25                       45 29 1 12   1 0     0   2   20 25                 45
1894795 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 68 9 20   0 8     0   11   68 48                       116 68 9 20   0 8     0   11   68 48                 116
1894802 CO     school 802910 130   CHERRY CREEK 5 80291002032 243 COYOTE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 67 4 17   0 11     0   7   52 54                       106 67 4 17   0 11     0   7   52 54                 106
1897016 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000033 248 GUADALUPE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2018   grade_2 3 0 13   0 0     0   0   7 9                       16 3 0 13   0 0     0   0   7 9                 16
1900423 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 36 1 3   0 0     0   6   22 24                       46 36 1 3   0 0     0   6   22 24                 46
1903979 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000597 262 APPLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 55 0 8   0 5     1   1   33 37                       70 55 0 8   0 5     1   1   33 37                 70
1898648 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006392 265 CLEAR SKY ELEMENTARY   Regular School No Elementary PK 06 2018   grade_2 73 1 25   0 1     0   2   55 47                       102 73 1 25   0 1     0   2   55 47                 102
1898658 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006368 266 GOLD RUSH ELEMENTARY   Regular School No Elementary PK 05 2018   grade_2 82 2 14   1 7     0   4   51 59                       110 82 2 14   1 7     0   4   51 59                 110
1893865 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 60 1 42   1 2     1   5   52 60                       112 60 1 42   1 2     1   5   52 60                 112
1905870 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 1 0 2   0 0     0   0   3 0                       3 1 0 2   0 0     0   0   3 0                 3
1895421 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 19 16 29   0 3     0   7   41 33                       74 19 16 29   0 3     0   7   41 33                 74
1894809 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 40 9 18   0 5     1   7   43 37                       80 40 9 18   0 5     1   7   43 37                 80
1898670 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001757 354 ARROWWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 32 0 6   0 3     0   1   24 18                       42 32 0 6   0 3     0   1   24 18                 42
1903991 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435002030 362 RIM ROCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 75 0 15   0 4     0   1   48 47                       95 75 0 15   0 4     0   1   48 47                 95
1904000 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435001992 363 PEAR PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 42 1 21   0 0     0   3   29 38                       67 42 1 21   0 0     0   3   29 38                 67
1897250 CO     school 803360 880   DENVER COUNTY 1 80336000307 388 ASBURY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 39 1 15   0 2     0   5   43 19                       62 39 1 15   0 2     0   5   43 19                 62
1897257 CO     school 803360 880   DENVER COUNTY 1 80336000420 408 VALDEZ ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 15 0 37   0 0     0   2   24 30                       54 15 0 37   0 0     0   2   24 30                 54
1897265 CO     school 803360 880   DENVER COUNTY 1 80336000309 418 ASHLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 4 23 37   0 1     0   4   32 37                       69 4 23 37   0 1     0   4   32 37                 69
1904929 CO     school 802280 2640   ASPEN 1 80228000045 428 ASPEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2018   grade_2 70 0 11   0 1     0   1   38 45                       83 70 0 11   0 1     0   1   38 45                 83
1901088 CO     school 804260 1180   ROARING FORK RE-1 80426001505 429 CARBONDALE COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2018   grade_2 11 1 1   0 0     0   1   5 9                       14 11 1 1   0 0     0   1   5 9                 14
1896464 CO     school 802490 480   BOULDER VALLEY RE 2 80249001758 441 ASPEN CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2018   grade_2 54 0 11   0 5     0   3   34 39                       73 54 0 11   0 5     0   3   34 39                 73
1894817 CO     school 802910 130   CHERRY CREEK 5 80291001879 442 ASPEN CROSSING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 50 12 14   1 6     0   8   42 49                       91 50 12 14   1 6     0   8   42 49                 91
1899922 CO     school 803060 1010   COLORADO SPRINGS 11 80306000222 452 AUDUBON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 35 0 17   0 0     0   4   33 23                       56 35 0 17   0 0     0   4   33 23                 56
1895429 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2018   grade_2 7 21 20   0 1     0   6   26 29                       55 7 21 20   0 1     0   6   26 29                 55
1895443 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2018   grade_2 33 3 20   0 12     1   3   38 34                       72 33 3 20   0 12     1   3   38 34                 72
1899347 CO     school 803540 910   EAGLE COUNTY RE 50 80354001530 471 AVON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 8 0 39   0 0     0   1   18 30                       48 8 0 39   0 0     0   1   18 30                 48
1905277 CO     school 806150 2700   PUEBLO COUNTY 70 80615001069 472 AVONDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 7 0 22   0 0     0   1   14 16                       30 7 0 22   0 0     0   1   14 16                 30
1903032 CO     school 803990 1550   POUDRE R-1 80399001727 477 ZACH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 63 1 5   0 6     0   6   41 40                       81 63 1 5   0 6     0   6   41 40                 81
1903040 CO     school 803990 1550   POUDRE R-1 80399001973 490 BACON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 59 1 11   0 2     0   0   39 34                       73 59 1 11   0 2     0   0   39 34                 73
1901491 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006643 491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL   Regular School Yes Elementary PK 05 2018   grade_2 46 3 14   0 2     0   5   32 38                       70 46 3 14   0 2     0   5   32 38                 70
1903049 CO     school 803990 1550   POUDRE R-1 80399006380 498 BETHKE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 87 0 8   0 4     0   4   56 47                       103 87 0 8   0 4     0   4   56 47                 103
1893705 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2018   grade_2 5 2 33   0 2     0   0   15 27                       42 5 2 33   0 2     0   0   15 27                 42
1893716 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2018   grade_2 9 1 36   1 0     0   1   28 20                       48 9 1 36   1 0     0   1   28 20                 48
1893730 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2018   grade_2 6 0 44   0 1     0   2   23 30                       53 6 0 44   0 1     0   2   23 30                 53
1893741 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 6 0 21   0 1     0   0   16 12                       28 6 0 21   0 1     0   0   16 12                 28
1893750 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2018   grade_2 4 0 45   0 2     0   1   26 26                       52 4 0 45   0 2     0   1   26 26                 52
1893761 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2018   grade_2 14 1 27   1 0     0   1   27 17                       44 14 1 27   1 0     0   1   27 17                 44
1893770 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2018   grade_2 5 1 36   1 1     0   2   27 19                       46 5 1 36   1 1     0   2   27 19                 46
1893779 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2018   grade_2 4 0 37   0 2     0   2   20 25                       45 4 0 37   0 2     0   2   20 25                 45
1903859 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2018   grade_2 95 4 41   0 0     1   4   86 59                       145 95 4 41   0 0     1   4   86 59                 145
1899930 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2018   grade_2 27 0 6   0 0     0   3   15 21                       36 27 0 6   0 0     0   3   15 21                 36
1897273 CO     school 803360 880   DENVER COUNTY 1 80336000311 520 BARNUM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 5 4 77   0 0     0   0   46 40                       86 5 4 77   0 0     0   0   46 40                 86
1900769 CO     school 803870 1110   FALCON 49 80387002027 555 BANNING LEWIS RANCH ACADEMY   Regular School Yes Other KG 09 2018   grade_2 76 4 33   1 4     0   16   70 64                       134 76 4 33   1 4     0   16   70 64                 134
1901098 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2018   grade_2 41 0 60   0 1     0   3   53 52                       105 41 0 60   0 1     0   3   53 52                 105
1904377 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309001093 609 BATTLE ROCK CHARTER SCHOOL   Regular School Yes Elementary KG 06 2018   grade_2 3 0 2   1 0     0   0   3 3                       6 3 0 2   1 0     0   0   3 3                 6
1903057 CO     school 803990 1550   POUDRE R-1 80399000519 612 BAUDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 46 5 17   2 1     1   1   42 31                       73 46 5 17   2 1     1   1   42 31                 73
1902979 CO     school 802400 1530   BAYFIELD 10 JT-R 80240000088 632 BAYFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 66 1 15   1 0     0   3   46 40                       86 66 1 15   1 0     0   3   46 40                 86
1897281 CO     school 803360 880   DENVER COUNTY 1 80336000313 650 BEACH COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 2 0 29   0 0     0   0   13 18                       31 2 0 29   0 0     0   0   13 18                 31
1898680 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006159 651 BEAR CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 49 0 5   1 1     0   4   28 32                       60 49 0 5   1 1     0   4   28 32                 60
1896475 CO     school 802490 480   BOULDER VALLEY RE 2 80249000099 652 BEAR CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 58 0 3   0 9     0   4   36 38                       74 58 0 3   0 9     0   4   36 38                 74
1906600 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002018 653 STONE CREEK SCHOOL   Regular School Yes Elementary KG 08 2018   grade_2 25 0 6   0 0     0   0   21 10                       31 25 0 6   0 0     0   0   21 10                 31
1906610 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001926 654 THE PINNACLE CHARTER SCHOOL ELEMENTARY   Regular School Yes Elementary KG 05 2018   grade_2 26 0 122   0 4     0   2   72 82                       154 26 0 122   0 4     0   2   72 82                 154
1906617 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002033 655 HIGH POINT ACADEMY   Regular School Yes Elementary PK 08 2018   grade_2 24 20 33   1 2     0   0   39 41                       80 24 20 33   1 2     0   0   39 41                 80
1906628 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 T.R. PAUL ACADEMY OF ARTS & KNOWLEDGE   Regular School Yes Elementary KG 05 2018   grade_2 30 1 7   0 0     0   4   19 23                       42 30 1 7   0 0     0   4   19 23                 42
1901500 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000696 660 BEAR CREEK K-8 SCHOOL   Regular School No Elementary KG 08 2018   grade_2 58 3 40   1 6     1   5   56 58                       114 58 3 40   1 6     1   5   56 58                 114
1903066 CO     school 803990 1550   POUDRE R-1 80399000520 678 BEATTIE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 36 0 6   0 4     0   3   23 26                       49 36 0 6   0 4     0   3   23 26                 49
1894298 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2018   grade_2 30 2 40   0 2     0   6   36 44                       80 30 2 40   0 2     0   6   36 44                 80
1894825 CO     school 802910 130   CHERRY CREEK 5 80291000184 714 BELLEVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 54 4 11   0 27     0   7   53 50                       103 54 4 11   0 27     0   7   53 50                 103
1901520 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000699 724 BELMAR ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2018   grade_2 21 3 22   0 3     0   3   22 30                       52 21 3 22   0 3     0   3   22 30                 52

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