Data source: Big Local News · About: Big Local

1,104 rows where grade = "grade_2", state = "CO" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2019 · 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
1932685 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_2 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1934756 CO     school 803360 880   DENVER COUNTY 1 80336000331 1908 CORY ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 65 0 12   0 2     0   6   39 46                       85 65 0 12   0 2     0   6   39 46                 85
1934774 CO     school 803360 880   DENVER COUNTY 1 80336001767 2027 POLARIS ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 32 4 7   0 1     0   5   26 23                       49 32 4 7   0 1     0   5   26 23                 49
1935023 CO     school 803360 880   DENVER COUNTY 1 80336001864 3340 LENA ARCHULETA ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 5 8 75   0 1     0   2   50 41                       91 5 8 75   0 1     0   2   50 41                 91
1941978 CO     school 804050 2405   FORT MORGAN RE-3 80405006698 1009 BAKER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 13 1 41   0 1     0   0   29 27                       56 13 1 41   0 1     0   0   29 27                 56
1941984 CO     school 804050 2405   FORT MORGAN RE-3 80405000556 1850 COLUMBINE ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 31 3 52   0 3     0   1   42 48                       90 31 3 52   0 3     0   1   42 48                 90
1941999 CO     school 804050 2405   FORT MORGAN RE-3 80405000558 3620 GREEN ACRES ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 25 2 43   1 0     0   2   35 38                       73 25 2 43   1 0     0   2   35 38                 73
1942010 CO     school 804050 2405   FORT MORGAN RE-3 80405006298 6954 PIONEER ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 14 6 45   1 0     0   0   33 33                       66 14 6 45   1 0     0   0   33 33                 66
1942844 CO     school 805760 2740   MONTE VISTA C-8 80576000985 6036 BILL METZ ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2019   grade_2 9 0 51   1 0     0   0   34 27                       61 9 0 51   1 0     0   0   34 27                 61
1938160 CO     school 803870 1110   DISTRICT 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2019   grade_2 10 0 2   0 0     0   0   8 4                       12 10 0 2   0 0     0   0   8 4                 12
1938663 CO     school 804380 1220   GARFIELD 16 80438000630 3578 BEA UNDERWOOD ELEMENTARY SCHOOL   Regular School No Elementary 02 05 2019   grade_2 49 0 31   0 0     0   3   49 34                       83 49 0 31   0 0     0   3   49 34                 83
1941089 CO     school 806960 1580   TRINIDAD 1 80696001946 2944 FISHER'S PEAK ELEMENTARY SCHOOL   Regular School No Elementary 02 05 2019   grade_2 15 1 48   0 0     0   2   35 31                       66 15 1 48   0 0     0   2   35 31                 66
1930978 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_2 7 1 31   0 3     0   0   17 25                       42 7 1 31   0 3     0   0   17 25                 42
1931002 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_2 5 0 48   0 2     0   2   32 25                       57 5 0 48   0 2     0   2   32 25                 57
1931051 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_2 7 0 43   0 1     0   0   24 27                       51 7 0 43   0 1     0   0   24 27                 51
1931069 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2019   grade_2 50 3 16   1 1     1   5   47 30                       77 50 3 16   1 1     1   5   47 30                 77
1931094 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2019   grade_2 7 1 33   0 0     0   2   17 26                       43 7 1 33   0 0     0   2   17 26                 43
1931107 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 35 1 35   0 3     0   2   40 36                       76 35 1 35   0 3     0   2   40 36                 76
1931119 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 81 0 13   0 9     0   7   61 49                       110 81 0 13   0 9     0   7   61 49                 110
1931161 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_2 58 0 11   0 25     0   6   49 51                       100 58 0 11   0 25     0   6   49 51                 100
1931181 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 65 1 19   0 5     0   8   54 44                       98 65 1 19   0 5     0   8   54 44                 98
1931189 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 48 0 4   0 6     0   3   26 35                       61 48 0 4   0 6     0   3   26 35                 61
1931197 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001622 2361 EAGLEVIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 56 0 30   0 8     0   5   63 36                       99 56 0 30   0 8     0   5   63 36                 99
1931223 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001401 2578 SKYVIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 48 0 34   1 4     0   1   49 39                       88 48 0 34   1 4     0   1   49 39                 88
1931240 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001460 2582 ROCKY MOUNTAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 17 5 54   1 1     0   4   42 40                       82 17 5 54   1 1     0   4   42 40                 82
1931264 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001177 4000 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 10 2 49   0 6     0   6   44 29                       73 10 2 49   0 6     0   6   44 29                 73
1931276 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001178 4172 HULSTROM OPTIONS K-8 SCHOOL   Regular School No Elementary KG 08 2019   grade_2 52 1 3   0 13     0   4   38 35                       73 52 1 3   0 13     0   4   38 35                 73
1931300 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001306 5058 LEROY DRIVE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 23 3 40   0 3     1   2   40 32                       72 23 3 40   0 3     1   2   40 32                 72
1931316 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001182 5706 MC ELWAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 13 4 59   0 4     0   2   38 44                       82 13 4 59   0 4     0   2   38 44                 82
1931378 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 12 2019   grade_2 79 1 4   0 8     0   8   47 53                       100 79 1 4   0 8     0   8   47 53                 100
1931398 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001945 7155 PRAIRIE HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 62 1 17   0 1     1   2   41 43                       84 62 1 17   0 1     1   2   41 43                 84
1931406 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690002028 7795 SILVER CREEK ELEMENTARY   Regular School No Elementary KG 05 2019   grade_2 63 0 23   0 16     0   2   51 53                       104 63 0 23   0 16     0   2   51 53                 104
1931414 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006375 8211 THE STUDIO SCHOOL   Regular School No Elementary KG 05 2019   grade_2 36 1 10   1 1     0   5   20 34                       54 36 1 10   1 1     0   5   20 34                 54
1931421 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006303 8225 STELLAR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 43 2 48   1 4     0   5   44 59                       103 43 2 48   1 4     0   5   44 59                 103
1931429 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006468 8275 STEM LAB   Regular School No Elementary KG 08 2019   grade_2 41 1 3   0 2     0   3   28 22                       50 41 1 3   0 2     0   3   28 22                 50
1931439 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006561 8310 STEM LAUNCH   Regular School No Elementary KG 08 2019   grade_2 14 2 25   0 2     0   3   24 22                       46 14 2 25   0 2     0   3   24 22                 46
1931449 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001190 8361 STUKEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 18 3 45   0 3     0   1   33 37                       70 18 3 45   0 3     0   1   33 37                 70
1931479 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes Other KG 12 2019   grade_2 24 1 9   0 1     0   3   19 19                       38 24 1 9   0 1     0   3   19 19                 38
1931529 CO     school 801950 30   ADAMS COUNTY 14 80195000011 186 ALSUP ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 14 0 64   0 0     0   1   36 43                       79 14 0 64   0 0     0   1   36 43                 79
1931544 CO     school 801950 30   ADAMS COUNTY 14 80195000013 2308 DUPONT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 7 0 67   0 0     0   1   40 35                       75 7 0 67   0 0     0   1   40 35                 75
1931565 CO     school 801950 30   ADAMS COUNTY 14 80195000017 5982 MONACO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 5 2 51   0 0     0   1   27 32                       59 5 2 51   0 0     0   1   27 32                 59
1931590 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 23 1 45   0 2     0   2   47 26                       73 23 1 45   0 2     0   2   47 26                 73
1931641 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006465 2945 FOUNDATIONS ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 69 0 19   1 1     0   3   45 48                       93 69 0 19   1 1     0   3   45 48                 93
1931660 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006325 4950 LANDMARK ACADEMY AT REUNION   Regular School Yes Elementary KG 08 2019   grade_2 55 4 21   2 3     1   1   43 44                       87 55 4 21   2 3     1   1   43 44                 87
1931787 CO     school 802430 50   BENNETT 29J 80243000091 770 BENNETT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 43 0 20   0 0     0   4   37 30                       67 43 0 20   0 0     0   4   37 30                 67
1931865 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006567 4334 COLORADO STEM ACADEMY   Regular School No Elementary KG 08 2019   grade_2 14 0 20   0 2     0   0   21 15                       36 14 0 20   0 2     0   0   21 15                 36
1931965 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 48 2 141   4 0     2   6   111 92                       203 48 2 141   4 0     2   6   111 92                 203
1932006 CO     school 803780 120   ENGLEWOOD 1 80378000486 1514 CHARLES HAY WORLD SCHOOL   Regular School No Elementary KG 06 2019   grade_2 23 0 14   0 0     0   7   29 15                       44 23 0 14   0 0     0   7   29 15                 44
1932014 CO     school 803780 120   ENGLEWOOD 1 80378000488 1556 CHERRELYN ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 17 1 8   0 2     0   2   16 14                       30 17 1 8   0 2     0   2   16 14                 30
1932022 CO     school 803780 120   ENGLEWOOD 1 80378000489 1652 CLAYTON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 22 1 28   0 1     0   3   31 24                       55 22 1 28   0 1     0   3   31 24                 55
1932044 CO     school 803780 120   ENGLEWOOD 1 80378000497 9620 WM E BISHOP ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 14 3 21   1 1     0   2   19 23                       42 14 3 21   1 1     0   2   19 23                 42
1932052 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 10 1 56   1 0     0   4   43 29                       72 10 1 56   1 0     0   4   43 29                 72
1932178 CO     school 802910 130   CHERRY CREEK 5 80291001152 1571 CHERRY CREEK CHARTER ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 39 6 4   0 22     1   6   32 46                       78 39 6 4   0 22     1   6   32 46                 78
1932308 CO     school 802910 130   CHERRY CREEK 5 80291006676 4189 HERITAGE HEIGHTS ACADEMY   Regular School Yes Elementary KG 07 2019   grade_2 21 6 7   0 13     0   2   24 25                       49 21 6 7   0 13     0   2   24 25                 49
1932373 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2019   grade_2 38 1 11   0 0     0   5   28 27                       55 38 1 11   0 0     0   5   28 27                 55
1932521 CO     school 805310 140   LITTLETON 6 80531000878 752 FRANKLIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 87 0 17   0 2     0   6   57 55                       112 87 0 17   0 2     0   6   57 55                 112
1932528 CO     school 805310 140   LITTLETON 6 80531000874 1382 CENTENNIAL ACADEMY OF FINE ARTS EDUCATION   Regular School No Elementary KG 05 2019   grade_2 58 0 25   0 1     0   6   49 41                       90 58 0 25   0 1     0   6   49 41                 90
1932535 CO     school 805310 140   LITTLETON 6 80531000875 2382 EAST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 8 0 23   0 3     0   1   13 22                       35 8 0 23   0 3     0   1   13 22                 35
1932546 CO     school 805310 140   LITTLETON 6 80531000877 2926 FIELD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 17 5 20   1 0     0   1   24 20                       44 17 5 20   1 0     0   1   24 20                 44
1932583 CO     school 805310 140   LITTLETON 6 80531001515 5229 LITTLETON ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 43 1 5   0 3     0   1   26 27                       53 43 1 5   0 3     0   1   26 27                 53
1932604 CO     school 805310 140   LITTLETON 6 80531001300 5236 LOIS LENSKI ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 83 1 4   0 2     0   5   47 48                       95 83 1 4   0 2     0   5   47 48                 95
1932619 CO     school 805310 140   LITTLETON 6 80531000891 5574 TWAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 35 1 2   0 2     0   3   27 16                       43 35 1 2   0 2     0   3   27 16                 43
1932636 CO     school 805310 140   LITTLETON 6 80531000888 7518 RUNYON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 72 1 11   0 0     0   1   40 45                       85 72 1 11   0 0     0   1   40 45                 85
1932643 CO     school 805310 140   LITTLETON 6 80531000889 7606 SANDBURG ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 66 0 4   0 4     0   6   46 34                       80 66 0 4   0 4     0   6   46 34                 80
1932694 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 11 24 35   1 2     0   6   37 42                       79 11 24 35   1 2     0   6   37 42                 79
1932733 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 11 16 17   2 2     0   3   26 25                       51 11 16 17   2 2     0   3   26 25                 51
1932846 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 0 2 3   0 0     0   1   5 1                       6 0 2 3   0 0     0   1   5 1                 6
1932866 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2019   grade_2 20 21 70   0 5     1   12   58 71                       129 20 21 70   0 5     1   12   58 71                 129
1932915 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000069 4973 LAREDO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 9 7 45   0 2     0   1   32 32                       64 9 7 45   0 2     0   1   32 32                 64
1932925 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2019   grade_2 10 40 24   0 0     0   1   36 39                       75 10 40 24   0 0     0   1   36 39                 75
1932976 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2019   grade_2 80 6 14   0 2     0   2   49 55                       104 80 6 14   0 2     0   2   49 55                 104
1933011 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2019   grade_2 24 11 10   0 7     0   3   25 30                       55 24 11 10   0 7     0   3   25 30                 55
1933065 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Elementary KG 05 2019   grade_2 14 19 46   0 2     2   6   45 44                       89 14 19 46   0 2     2   6   45 44                 89
1933077 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes Elementary KG 08 2019   grade_2 7 17 25   0 2     0   2   24 29                       53 7 17 25   0 2     0   2   24 29                 53
1933130 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2019   grade_2 13 32 21   0 4     0   0   32 38                       70 13 32 21   0 4     0   0   32 38                 70
1933195 CO     school 802700 190   BYERS 32J 80270006751 2801 ELEVATE ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2019   grade_2 1 0 22   0 0     0   0   12 11                       23 1 0 22   0 0     0   0   12 11                 23
1933207 CO     school 802700 190   BYERS 32J 80270006630 6241 COLORADO DIGITAL ACADEMY - ELEMENTARY   Regular School Yes Elementary KG 06 2019   grade_2 44 6 7   1 0     0   5   35 28                       63 44 6 7   1 0     0   5   35 28                 63
1933229 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2019   grade_2 65 3 40   7 1     0   2   64 54                       118 65 3 40   7 1     0   2   64 54                 118
1933246 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219006717 6679 PAGOSA PEAK OPEN SCHOOL   Regular School Yes Elementary KG 05 2019   grade_2 7 0 0   0 1     0   1   5 4                       9 7 0 0   0 1     0   1   5 4                 9
1933338 CO     school 805250 290   LAS ANIMAS RE-1 80525000866 1812 LAS ANIMAS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 19 0 9   3 0     0   0   12 19                       31 19 0 9   3 0     0   0   12 19                 31
1933397 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006530 71 ASPEN RIDGE PREPARATORY SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 45 0 6   0 6     0   0   28 29                       57 45 0 6   0 6     0   0   28 29                 57
1933411 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2019   grade_2 60 0 14   0 2     0   2   44 34                       78 60 0 14   0 2     0   2   44 34                 78
1933781 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001572 8927 TWIN PEAKS CHARTER ACADEMY   Regular School Yes Other KG 12 2019   grade_2 31 2 28   0 3     0   1   30 35                       65 31 2 28   0 3     0   1   30 35                 65
1933813 CO     school 802490 480   BOULDER VALLEY RE 2 80249000099 652 BEAR CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 56 0 5   0 7     0   3   41 30                       71 56 0 5   0 7     0   3   41 30                 71
1933828 CO     school 802490 480   BOULDER VALLEY RE 2 80249001630 919 BOULDER COMMUNITY SCHOOL/INTEGRATED STUDIES   Regular School No Elementary KG 05 2019   grade_2 44 0 2   0 1     0   5   27 25                       52 44 0 2   0 1     0   5   27 25                 52
1933881 CO     school 802490 480   BOULDER VALLEY RE 2 80249001376 1725 COAL CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 54 0 7   0 4     0   5   31 39                       70 54 0 7   0 4     0   5   31 39                 70
1933904 CO     school 802490 480   BOULDER VALLEY RE 2 80249000110 1996 CREST VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 63 1 23   0 5     0   6   55 43                       98 63 1 23   0 5     0   6   55 43                 98
1933919 CO     school 802490 480   BOULDER VALLEY RE 2 80249000112 2552 EISENHOWER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 54 0 10   0 2     0   6   36 36                       72 54 0 10   0 2     0   6   36 36                 72
1933969 CO     school 802490 480   BOULDER VALLEY RE 2 80249000115 2970 FLATIRONS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 25 0 1   0 0     0   1   17 10                       27 25 0 1   0 0     0   1   17 10                 27
1933976 CO     school 802490 480   BOULDER VALLEY RE 2 80249000116 3022 FOOTHILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 58 0 11   0 2     0   5   37 39                       76 58 0 11   0 2     0   5   37 39                 76
1933983 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1933997 CO     school 802490 480   BOULDER VALLEY RE 2 80249001243 3940 HIGH PEAKS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 37 0 1   0 4     0   6   27 21                       48 37 0 1   0 4     0   6   27 21                 48
1934004 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 2 0 1   0 0     0   1   1 3                       4 2 0 1   0 0     0   1   1 3                 4
1934037 CO     school 802490 480   BOULDER VALLEY RE 2 80249000124 5302 LOUISVILLE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 73 1 12   0 2     0   7   48 47                       95 73 1 12   0 2     0   7   48 47                 95
1934058 CO     school 802490 480   BOULDER VALLEY RE 2 80249000129 5838 MESA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 34 0 3   0 0     0   1   17 21                       38 34 0 3   0 0     0   1   17 21                 38
1934106 CO     school 802490 480   BOULDER VALLEY RE 2 80249006199 6642 HORIZONS K-8 SCHOOL   Alternative School Yes Elementary KG 08 2019   grade_2 33 0 4   0 0     0   3   18 22                       40 33 0 4   0 0     0   3   18 22                 40
1934119 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_2 52 0 6   1 7     0   6   33 39                       72 52 0 6   1 7     0   6   33 39                 72
1934162 CO     school 802490 480   BOULDER VALLEY RE 2 80249001518 8418 SUPERIOR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 66 0 6   0 10     0   6   46 42                       88 66 0 6   0 10     0   6   46 42                 88
1934177 CO     school 802490 480   BOULDER VALLEY RE 2 80249000139 9544 WHITTIER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 31 0 14   0 5     0   6   29 27                       56 31 0 14   0 5     0   6   29 27                 56
1934221 CO     school 806330 500   SALIDA R-32 80633001108 5268 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2019   grade_2 64 2 18   0 1     0   4   45 44                       89 64 2 18   0 1     0   4   45 44                 89

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