Data source: Big Local News · About: Big Local

1,082 rows where grade = "grade_2", state = "CO" and year = 2017 sorted by school_state_id

View and edit SQL

year

  • 2017 · 1,082

grade

  • grade_2 · 1,082
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
709487 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_2 1 2 0   0 0     0   0   2 1                       3 1 2 0   0 0     0   0   2 1                 3
712685 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 76 2 11   0 1     0   4   43 51                       94 76 2 11   0 1     0   4   43 51                 94
712696 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 39 1 9   1 25     0   8   36 47                       83 39 1 9   1 25     0   8   36 47                 83
707967 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 0 29   1 5     1   4   44 31                       75 35 0 29   1 5     1   4   44 31                 75
720624 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_2 85 1 31   0 10     0   12   87 52                       139 85 1 31   0 10     0   12   87 52                 139
708891 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 69 8 12   1 11     0   5   49 57                       106 69 8 12   1 11     0   5   49 57                 106
714473 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 57 5 14   0 3     0   8   38 49                       87 57 5 14   0 3     0   8   38 49                 87
714481 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 73 2 7   0 12     0   9   51 52                       103 73 2 7   0 12     0   9   51 52                 103
719312 CO     school 806150 2700   PUEBLO COUNTY 70 80615001718 26 DESERT SAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 34 1 31   0 0     0   1   34 33                       67 34 1 31   0 0     0   1   34 33                 67
715520 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 29 0 9   0 2     0   4   27 17                       44 29 0 9   0 2     0   4   27 17                 44
720636 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
713411 CO     school 803540 910   EAGLE COUNTY RE 50 80354001721 37 RED HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 20 0 30   1 0     0   1   24 28                       52 20 0 30   1 0     0   1   24 28                 52
713419 CO     school 803540 910   EAGLE COUNTY RE 50 80354001722 38 BRUSH CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 0 8   1 0     0   0   28 30                       58 49 0 8   1 0     0   0   28 30                 58
718970 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 14 0 1   0 0     0   1   8 8                       16 14 0 1   0 0     0   1   8 8                 16
712664 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
720207 CO     school 804410 3120   GREELEY 6 80441001988 52 HEIMAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 50 2 62   0 2     0   3   61 58                       119 50 2 62   0 2     0   3   61 58                 119
720214 CO     school 804410 3120   GREELEY 6 80441001989 53 WINOGRAD K-8 ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2017   grade_2 28 0 53   1 0     0   1   45 38                       83 28 0 53   1 0     0   1   45 38                 83
720224 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2017   grade_2 14 10 105   0 0     0   1   72 58                       130 14 10 105   0 0     0   1   72 58                 130
720098 CO     school 807350 3100   WINDSOR RE-4 80735001987 55 GRANDVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 57 0 5   0 0     0   2   28 36                       64 57 0 5   0 0     0   2   28 36                 64
718795 CO     school 804110 2540   FOWLER R-4J 80411001981 56 FOWLER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 24 0 10   0 0     0   2   17 19                       36 24 0 10   0 0     0   2   17 19                 36
717805 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 1 0 6   0 0     0   0   4 3                       7 1 0 6   0 0     0   0   4 3                 7
707979 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 94 2 15   1 5     1   4   72 50                       122 94 2 15   1 5     1   4   72 50                 122
710156 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001830 60 LEGACY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 71 2 22   1 3     0   1   59 41                       100 71 2 22   1 3     0   1   59 41                 100
710164 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001832 61 ALPINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 0 34   0 3     0   5   40 51                       91 49 0 34   0 3     0   5   40 51                 91
715458 CO     school 807080 1390   HUERFANO RE-1 80708001845 63 PEAKVIEW SCHOOL   Regular School No Elementary PK 08 2017   grade_2 12 0 20   1 1     0   0   17 17                       34 12 0 20   1 1     0   0   17 17                 34
710173 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006530 71 ASPEN RIDGE PREPARATORY SCHOOL   Regular School Yes Elementary KG 07 2017   grade_2 72 1 4   0 6     0   1   47 37                       84 72 1 4   0 6     0   1   47 37                 84
719909 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_2 26 0 8   0 0     0   0   19 15                       34 26 0 8   0 0     0   0   19 15                 34
711343 CO     school 803360 880   DENVER COUNTY 1 80336006592 99 ACADEMY 360   Regular School Yes Elementary PK 05 2017   grade_2 7 6 10   0 0     1   0   13 11                       24 7 6 10   0 0     1   0   13 11                 24
715544 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006489 109 ARVADA K-8   Regular School No Elementary KG 08 2017   grade_2 15 2 27   0 0     0   2   21 25                       46 15 2 27   0 0     0   2   21 25                 46
708781 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 52 4 135   2 0     0   5   100 98                       198 52 4 135   2 0     0   5   100 98                 198
710186 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2017   grade_2 80 1 7   0 3     0   6   57 40                       97 80 1 7   0 3     0   6   57 40                 97
712706 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006492 135 BEN FRANKLIN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 77 2 10   0 5     0   10   56 48                       104 77 2 10   0 5     0   10   56 48                 104
717076 CO     school 803990 1550   POUDRE R-1 80399001717 146 RIDGEVIEW CLASSICAL CHARTER SCHOOLS   Regular School Yes Other KG 12 2017   grade_2 49 0 8   0 1     0   4   30 32                       62 49 0 8   0 1     0   4   30 32                 62
715554 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000692 148 ALLENDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 22 0 15   1 0     0   6   21 23                       44 22 0 15   1 0     0   6   21 23                 44
708368 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 19 2 62   0 1     1   1   49 37                       86 19 2 62   0 1     1   1   49 37                 86
719015 CO     school 805220 2660   LAMAR RE-2 80522000860 200 ALTA VISTA CHARTER SCHOOL   Regular School Yes Elementary KG 06 2017   grade_2 13 0 7   1 0     0   0   7 14                       21 13 0 7   1 0     0   0   7 14                 21
709497 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 16 21 19   1 1     0   4   29 33                       62 16 21 19   1 1     0   4   29 33                 62
709508 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 6 70   0 1     0   0   47 36                       83 6 6 70   0 1     0   0   47 36                 83
712721 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 154 1 18   0 29     0   10   115 97                       212 154 1 18   0 29     0   10   115 97                 212
711351 CO     school 803360 880   DENVER COUNTY 1 80336000306 220 AMESSE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 4 15 52   0 1     0   2   35 39                       74 4 15 52   0 1     0   2   35 39                 74
716938 CO     school 803480 1520   DURANGO 9-R 80348001066 225 ANIMAS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 28 0 13   2 0     0   1   29 15                       44 28 0 13   2 0     0   1   29 15                 44
708907 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 67 12 22   0 7     0   4   60 52                       112 67 12 22   0 7     0   4   60 52                 112
708914 CO     school 802910 130   CHERRY CREEK 5 80291002032 243 COYOTE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 66 7 13   0 13     1   7   54 53                       107 66 7 13   0 13     1   7   54 53                 107
711126 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000033 248 GUADALUPE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 1 0 20   0 0     0   0   14 7                       21 1 0 20   0 0     0   0   14 7                 21
714510 CO     school 801920 1040   ACADEMY 20 80192000123 249 ANTELOPE TRAILS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 44 0 6   1 2     0   1   24 30                       54 44 0 6   1 2     0   1   24 30                 54
718031 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000597 262 APPLETON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 53 0 12   0 1     0   4   33 37                       70 53 0 12   0 1     0   4   33 37                 70
712736 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006392 265 CLEAR SKY ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 86 2 21   0 1     0   6   62 54                       116 86 2 21   0 1     0   6   62 54                 116
712746 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006368 266 GOLD RUSH ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 75 1 7   0 2     0   7   49 43                       92 75 1 7   0 2     0   7   49 43                 92
707996 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 48 2 43   0 4     0   5   53 49                       102 48 2 43   0 4     0   5   53 49                 102
719925 CO     school 802220 3040   ARICKAREE R-2 80222000041 304 ARICKAREE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 1 0 5   0 0     0   0   4 2                       6 1 0 5   0 0     0   0   4 2                 6
709521 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 17 25 31   0 4     1   6   35 49                       84 17 25 31   0 4     1   6   35 49                 84
708921 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 12 31   1 2     1   9   45 60                       105 49 12 31   1 2     1   9   45 60                 105
712758 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001757 354 ARROWWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 33 0 14   0 4     0   1   24 28                       52 33 0 14   0 4     0   1   24 28                 52
718043 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435002030 362 RIM ROCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 94 0 13   0 1     0   3   55 56                       111 94 0 13   0 1     0   3   55 56                 111
718052 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435001992 363 PEAR PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 59 0 25   0 0     0   2   47 39                       86 59 0 25   0 0     0   2   47 39                 86
711359 CO     school 803360 880   DENVER COUNTY 1 80336000307 388 ASBURY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 39 4 13   0 0     0   0   26 30                       56 39 4 13   0 0     0   0   26 30                 56
711366 CO     school 803360 880   DENVER COUNTY 1 80336000420 408 VALDEZ ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 14 0 33   0 0     0   0   22 25                       47 14 0 33   0 0     0   0   22 25                 47
711374 CO     school 803360 880   DENVER COUNTY 1 80336000309 418 ASHLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 4 16 26   2 1     0   2   30 21                       51 4 16 26   2 1     0   2   30 21                 51
718980 CO     school 802280 2640   ASPEN 1 80228000045 428 ASPEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 99 0 12   0 2     1   1   56 59                       115 99 0 12   0 2     1   1   56 59                 115
715180 CO     school 804260 1180   ROARING FORK RE-1 80426001505 429 CARBONDALE COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 13 0 3   0 0     0   0   8 8                       16 13 0 3   0 0     0   0   8 8                 16
710558 CO     school 802490 480   BOULDER VALLEY RE 2 80249001758 441 ASPEN CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_2 56 0 8   0 5     0   5   36 38                       74 56 0 8   0 5     0   5   36 38                 74
708929 CO     school 802910 130   CHERRY CREEK 5 80291001879 442 ASPEN CROSSING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 55 8 14   0 7     0   4   35 53                       88 55 8 14   0 7     0   4   35 53                 88
714010 CO     school 803060 1010   COLORADO SPRINGS 11 80306000222 452 AUDUBON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 33 2 16   0 0     0   2   23 30                       53 33 2 16   0 0     0   2   23 30                 53
709529 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 20 27 30   0 0     0   3   43 37                       80 20 27 30   0 0     0   3   43 37                 80
709543 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2017   grade_2 35 8 16   0 14     0   4   39 38                       77 35 8 16   0 14     0   4   39 38                 77
713436 CO     school 803540 910   EAGLE COUNTY RE 50 80354001530 471 AVON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 5 2 39   1 0     0   1   27 21                       48 5 2 39   1 0     0   1   27 21                 48
719320 CO     school 806150 2700   PUEBLO COUNTY 70 80615001069 472 AVONDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 15 0 17   0 0     0   2   20 14                       34 15 0 17   0 0     0   2   20 14                 34
717087 CO     school 803990 1550   POUDRE R-1 80399001727 477 ZACH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 84 2 7   0 9     0   10   68 44                       112 84 2 7   0 9     0   10   68 44                 112
717095 CO     school 803990 1550   POUDRE R-1 80399001973 490 BACON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 66 0 10   0 1     0   3   40 40                       80 66 0 10   0 1     0   3   40 40                 80
715573 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006643 491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL   Regular School Yes Elementary PK 05 2017   grade_2 35 1 16   0 0     0   2   31 23                       54 35 1 16   0 0     0   2   31 23                 54
717104 CO     school 803990 1550   POUDRE R-1 80399006380 498 BETHKE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 76 0 4   0 2     1   1   42 42                       84 76 0 4   0 2     1   1   42 42                 84
707842 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_2 3 0 45   0 0     0   0   25 23                       48 3 0 45   0 0     0   0   25 23                 48
707853 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_2 9 1 39   0 2     0   0   27 24                       51 9 1 39   0 2     0   0   27 24                 51
707867 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_2 6 1 44   0 2     0   1   27 27                       54 6 1 44   0 2     0   1   27 27                 54
707878 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 5 0 20   0 0     0   1   11 15                       26 5 0 20   0 0     0   1   11 15                 26
707887 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_2 12 1 42   0 1     0   0   28 28                       56 12 1 42   0 1     0   0   28 28                 56
707898 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 11 1 30   0 0     1   1   24 20                       44 11 1 30   0 0     1   1   24 20                 44
707907 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 5 1 41   0 0     0   1   26 22                       48 5 1 41   0 0     0   1   26 22                 48
707916 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_2 12 3 30   0 3     0   2   25 25                       50 12 3 30   0 3     0   2   25 25                 50
717911 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 112 3 41   0 0     0   3   70 89                       159 112 3 41   0 0     0   3   70 89                 159
714018 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2017   grade_2 29 0 5   1 0     0   3   20 18                       38 29 0 5   1 0     0   3   20 18                 38
711382 CO     school 803360 880   DENVER COUNTY 1 80336000311 520 BARNUM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 4 2 68   0 0     0   0   37 37                       74 4 2 68   0 0     0   0   37 37                 74
714852 CO     school 803870 1110   FALCON 49 80387002027 555 BANNING LEWIS RANCH ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 49 3 16   0 0     2   15   42 43                       85 49 3 16   0 0     2   15   42 43                 85
715190 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 45 0 63   0 2     0   1   55 56                       111 45 0 63   0 2     0   1   55 56                 111
718426 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309001093 609 BATTLE ROCK CHARTER SCHOOL   Regular School Yes Elementary KG 06 2017   grade_2 5 0 2   2 0     0   0   4 5                       9 5 0 2   2 0     0   0   4 5                 9
717112 CO     school 803990 1550   POUDRE R-1 80399000519 612 BAUDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 59 1 12   0 1     1   0   34 40                       74 59 1 12   0 1     1   0   34 40                 74
717034 CO     school 802400 1530   BAYFIELD 10 JT-R 80240000088 632 BAYFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 97 1 14   1 1     0   6   68 52                       120 97 1 14   1 1     0   6   68 52                 120
711390 CO     school 803360 880   DENVER COUNTY 1 80336000313 650 BEACH COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 1 1 30   0 0     0   0   18 14                       32 1 1 30   0 0     0   0   18 14                 32
712768 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006159 651 BEAR CANYON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 65 2 12   0 3     0   4   52 34                       86 65 2 12   0 3     0   4   52 34                 86
710570 CO     school 802490 480   BOULDER VALLEY RE 2 80249000099 652 BEAR CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 50 0 4   0 5     0   7   35 31                       66 50 0 4   0 5     0   7   35 31                 66
720651 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002018 653 STONE CREEK SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 23 0 13   0 1     0   2   19 20                       39 23 0 13   0 1     0   2   19 20                 39
720661 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001926 654 THE PINNACLE CHARTER SCHOOL ELEMENTARY   Regular School Yes Elementary KG 05 2017   grade_2 27 0 119   1 9     0   1   83 74                       157 27 0 119   1 9     0   1   83 74                 157
720668 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002033 655 HIGH POINT ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 20 25 26   1 1     0   3   42 34                       76 20 25 26   1 1     0   3   42 34                 76
720679 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 T.R. PAUL ACADEMY OF ARTS & KNOWLEDGE   Regular School Yes Elementary KG 05 2017   grade_2 17 0 9   0 1     0   2   18 11                       29 17 0 9   0 1     0   2   18 11                 29
715582 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000696 660 BEAR CREEK K-8 SCHOOL   Regular School No Elementary KG 08 2017   grade_2 64 3 48   0 7     0   5   74 53                       127 64 3 48   0 7     0   5   74 53                 127
717121 CO     school 803990 1550   POUDRE R-1 80399000520 678 BEATTIE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 33 0 10   1 0     0   2   23 23                       46 33 0 10   1 0     0   2   23 23                 46
708427 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 36 3 36   0 0     0   3   33 45                       78 36 3 36   0 0     0   3   33 45                 78
708937 CO     school 802910 130   CHERRY CREEK 5 80291000184 714 BELLEVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 51 2 13   0 35     0   7   57 51                       108 51 2 13   0 35     0   7   57 51                 108
715602 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000699 724 BELMAR ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 28 2 14   0 1     0   1   20 26                       46 28 2 14   0 1     0   1   20 26                 46
719078 CO     school 806120 2690   PUEBLO CITY 60 80612001029 738 BELMONT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 12 3 65   0 2     0   0   43 39                       82 12 3 65   0 2     0   0   43 39                 82

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