Data source: Big Local News · About: Big Local

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

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
708868 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 18 2 72   0 1     0   3   51 45                       96 18 2 72   0 1     0   3   51 45                 96
711993 CO     school 803360 880   DENVER COUNTY 1 80336006652 4500 KIPP MONTBELLO ELEMENTARY   Regular School Yes Elementary KG 02 2017   grade_2 3 22 52   0 3     0   3   41 42                       83 3 22 52   0 3     0   3   41 42                 83
712342 CO     school 803360 880   DENVER COUNTY 1 80336006646 7471 ROCKY MOUNTAIN PREP: SOUTHWEST   Regular School Yes Elementary PK 02 2017   grade_2 1 2 37   0 0     0   0   20 20                       40 1 2 37   0 0     0   0   20 20                 40
712347 CO     school 803360 880   DENVER COUNTY 1 80336006642 7496 ROOTS ELEMENTARY   Regular School Yes Elementary KG 02 2017   grade_2 4 29 7   0 0     0   2   18 24                       42 4 29 7   0 0     0   2   18 24                 42
713161 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 87 1 12   0 2     0   11   54 59                       113 87 1 12   0 2     0   11   54 59                 113
713260 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 88 0 21   0 1     0   3   66 47                       113 88 0 21   0 1     0   3   66 47                 113
715611 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 85 2 6   0 0     0   0   48 45                       93 85 2 6   0 0     0   0   48 45                 93
716930 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 13 0 55   0 0     0   0   34 34                       68 13 0 55   0 0     0   0   34 34                 68
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
718667 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 61 1 53   0 0     0   1   58 58                       116 61 1 53   0 0     0   1   58 58                 116
718751 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 24 0 71   1 0     1   2   54 45                       99 24 0 71   1 0     1   2   54 45                 99
718774 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 12 0 50   0 1     0   0   42 21                       63 12 0 50   0 1     0   0   42 21                 63
719038 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 29 0 72   1 0     0   2   62 42                       104 29 0 72   1 0     0   2   62 42                 104
719740 CO     school 806870 2830   TELLURIDE R-1 80687006699 8811 TELLURIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 56 0 13   0 0     0   3   43 29                       72 56 0 13   0 0     0   3   43 29                 72
720030 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 93 0 22   0 1     0   5   62 59                       121 93 0 22   0 1     0   5   62 59                 121
720133 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 87 2 20   1 2     0   3   51 64                       115 87 2 20   1 2     0   3   51 64                 115
707949 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   grade_2 2 0 49   1 0     0   1   30 23                       53 2 0 49   1 0     0   1   30 23                 53
711172 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321000283 2050 CROWLEY COUNTY PRIMARY   Regular School No Elementary KG 03 2017   grade_2 1 1 28   0 0     0   0   6 24                       30 1 1 28   0 0     0   0   6 24                 30
711922 CO     school 803360 880   DENVER COUNTY 1 80336006609 4049 HIGHLINE ACADEMY NORTHEAST   Regular School Yes Elementary PK 03 2017   grade_2 21 17 34   0 2     0   10   43 41                       84 21 17 34   0 2     0   10   43 41                 84
712327 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 03 2017   grade_2 3 1 1   0 0     0   0   2 3                       5 3 1 1   0 0     0   0   2 3                 5
712491 CO     school 803360 880   DENVER COUNTY 1 80336006627 8401 STRIVE PREP - RUBY HILL   Regular School Yes Elementary KG 03 2017   grade_2 1 1 91   0 1     1   0   40 55                       95 1 1 91   0 1     1   0   40 55                 95
715621 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD PRIMARY SCHOOL   Regular School No Elementary KG 03 2017   grade_2 100 0 5   0 2     0   5   58 54                       112 100 0 5   0 2     0   5   58 54                 112
719188 CO     school 806120 2690   PUEBLO CITY 60 80612006378 2620 FOUNTAIN INTERNATIONAL MAGNET SCHOOL   Regular School No Elementary PK 03 2017   grade_2 39 0 55   0 3     0   2   49 50                       99 39 0 55   0 3     0   2   49 50                 99
710011 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 49 0 58   3 0     0   1   64 47                       111 49 0 58   3 0     0   1   64 47                 111
710443 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 21 1 28   0 0     0   2   24 28                       52 21 1 28   0 0     0   2   24 28                 52
710995 CO     school 806330 500   SALIDA R-32 80633001108 5268 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 75 2 14   0 0     0   5   45 51                       96 75 2 14   0 0     0   5   45 51                 96
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
715217 CO     school 804260 1180   ROARING FORK RE-1 80426001540 2063 CRYSTAL RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 21 2 64   0 0     0   1   43 45                       88 21 2 64   0 0     0   1   43 45                 88
715262 CO     school 806240 1195   GARFIELD RE-2 80624006396 2573 ELK CREEK ELEMENTARY   Regular School No Elementary PK 04 2017   grade_2 26 0 21   0 0     0   0   23 24                       47 26 0 21   0 0     0   0   23 24                 47
715270 CO     school 806240 1195   GARFIELD RE-2 80624006436 3281 GRAHAM MESA ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 43 0 26   1 0     0   4   38 36                       74 43 0 26   1 0     0   4   38 36                 74
715278 CO     school 806240 1195   GARFIELD RE-2 80624001967 3967 HIGHLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 38 0 41   0 0     0   0   34 45                       79 38 0 41   0 0     0   0   34 45                 79
715286 CO     school 806240 1195   GARFIELD RE-2 80624001598 4510 KATHRYN SENOR ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 27 0 28   0 0     0   0   28 27                       55 27 0 28   0 0     0   0   28 27                 55
715309 CO     school 806240 1195   GARFIELD RE-2 80624001099 7890 CACTUS VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 52 1 29   0 0     0   0   42 40                       82 52 1 29   0 0     0   0   42 40                 82
715317 CO     school 806240 1195   GARFIELD RE-2 80624001358 9231 WAMSLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 31 0 27   0 1     0   1   28 32                       60 31 0 27   0 1     0   1   28 32                 60
716899 CO     school 802670 1500   BURLINGTON RE-6J 80267000160 1144 BURLINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 24 2 21   0 2     0   0   24 25                       49 24 2 21   0 2     0   0   24 25                 49
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
719509 CO     school 803300 2730   DEL NORTE C-7 80330000292 8960 UNDERWOOD ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 11 0 15   0 0     0   1   10 17                       27 11 0 15   0 0     0   1   10 17                 27
720562 CO     school 800016 3200   YUMA 1 80001601820 9795 KENNETH P MORRIS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 28 0 25   0 0     0   0   26 27                       53 28 0 25   0 0     0   0   26 27                 53
720573 CO     school 800017 3210   WRAY RD-2 80001701816 9725 WRAY ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 46 0 21   0 0     0   1   32 36                       68 46 0 21   0 0     0   1   32 36                 68
720837 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006602 5957 MONTESSORI DEL MUNDO CHARTER SCHOOL   Regular School Yes Elementary PK 04 2017   grade_2 4 1 32   0 0     0   1   19 19                       38 4 1 32   0 0     0   1   19 19                 38
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
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
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
708006 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 34 0 29   0 1     0   4   28 40                       68 34 0 29   0 1     0   4   28 40                 68
708032 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 0 88   0 0     0   1   57 41                       98 9 0 88   0 0     0   1   57 41                 98
708040 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 67 1 21   1 7     0   7   57 47                       104 67 1 21   1 7     0   7   57 47                 104
708048 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 77 0 3   0 7     0   6   52 41                       93 77 0 3   0 7     0   6   52 41                 93
708056 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001622 2361 EAGLEVIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 63 1 26   0 3     0   4   52 45                       97 63 1 26   0 3     0   4   52 45                 97
708064 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001175 2410 TARVER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 58 1 20   0 2     0   8   45 44                       89 58 1 20   0 2     0   8   45 44                 89
708073 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001290 2576 CHERRY DRIVE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 34 0 23   0 2     0   1   38 22                       60 34 0 23   0 2     0   1   38 22                 60
708080 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001401 2578 SKYVIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 1 42   1 0     0   0   46 33                       79 35 1 42   1 0     0   0   46 33                 79
708088 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001419 2580 HUNTERS GLEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 44 2 20   2 2     0   4   31 43                       74 44 2 20   2 2     0   4   31 43                 74
708097 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001460 2582 ROCKY MOUNTAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 10 1 52   0 2     0   3   40 28                       68 10 1 52   0 2     0   3   40 28                 68
708104 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001461 2584 RIVERDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 19 1 30   1 4     0   1   33 23                       56 19 1 30   1 4     0   1   33 23                 56
708112 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001176 2918 FEDERAL HEIGHTS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 8 1 81   0 0     0   0   42 48                       90 8 1 81   0 0     0   0   42 48                 90
708119 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001177 4000 HILLCREST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 19 2 54   0 7     0   0   43 39                       82 19 2 54   0 7     0   0   43 39                 82
708150 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001306 5058 LEROY DRIVE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 30 6 46   0 2     0   3   44 43                       87 30 6 46   0 2     0   3   44 43                 87
708158 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001181 5418 MALLEY DRIVE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 31 1 55   1 3     0   3   57 37                       94 31 1 55   1 3     0   3   57 37                 94
708166 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001182 5706 MC ELWAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 9 2 51   0 0     0   1   32 31                       63 9 2 51   0 0     0   1   32 31                 63
708188 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001362 6150 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 70 0 17   1 7     0   6   49 52                       101 70 0 17   1 7     0   6   49 52                 101
708201 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001184 6355 NORTH MOR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 21 3 45   0 3     0   3   39 36                       75 21 3 45   0 3     0   3   39 36                 75
708209 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001185 6376 NORTH STAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 4 62   1 0     1   3   38 39                       77 6 4 62   1 0     1   3   38 39                 77
708250 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001945 7155 PRAIRIE HILLS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 57 1 12   0 6     0   6   48 34                       82 57 1 12   0 6     0   6   48 34                 82
708258 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690002028 7795 SILVER CREEK ELEMENTARY   Regular School No Elementary KG 05 2017   grade_2 66 1 15   0 4     1   5   43 49                       92 66 1 15   0 4     1   5   43 49                 92
708266 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006375 8211 THE STUDIO SCHOOL   Regular School No Elementary KG 05 2017   grade_2 40 1 8   1 0     0   2   18 34                       52 40 1 8   1 0     0   2   18 34                 52
708273 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006303 8225 STELLAR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 50 1 38   1 3     0   8   55 46                       101 50 1 38   1 3     0   8   55 46                 101
708301 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001190 8361 STUKEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 28 2 41   1 3     0   2   50 27                       77 28 2 41   1 3     0   2   50 27                 77
708308 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001191 8842 THORNTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 15 0 41   1 2     0   0   27 32                       59 15 0 41   1 2     0   0   27 32                 59
708335 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001195 9494 WESTVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 32 0 34   0 7     0   4   50 27                       77 32 0 34   0 7     0   4   50 27                 77
708344 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001196 9682 WOODGLEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 37 3 37   1 1     0   1   48 32                       80 37 3 37   1 1     0   1   48 32                 80
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
708375 CO     school 801950 30   ADAMS COUNTY 14 80195000012 1426 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 10 2 62   2 0     0   0   37 39                       76 10 2 62   2 0     0   0   37 39                 76
708383 CO     school 801950 30   ADAMS COUNTY 14 80195000013 2308 DUPONT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 11 1 93   1 0     0   3   62 47                       109 11 1 93   1 0     0   3   62 47                 109
708394 CO     school 801950 30   ADAMS COUNTY 14 80195000016 4536 KEMP ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 10 1 69   2 0     0   1   44 39                       83 10 1 69   2 0     0   1   44 39                 83
708404 CO     school 801950 30   ADAMS COUNTY 14 80195000017 5982 MONACO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 13 2 54   0 0     0   0   39 30                       69 13 2 54   0 0     0   0   39 30                 69
708411 CO     school 801950 30   ADAMS COUNTY 14 80195000018 6534 HANSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 1 29   1 0     0   1   21 17                       38 6 1 29   1 0     0   1   21 17                 38
708419 CO     school 801950 30   ADAMS COUNTY 14 80195000019 7500 ROSE HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 18 1 52   1 0     0   3   43 32                       75 18 1 52   1 0     0   3   43 32                 75
708437 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006549 1013 BRANTNER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 48 0 15   0 4     0   6   33 40                       73 48 0 15   0 4     0   6   33 40                 73
708489 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000146 3900 HENDERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 34 1 47   0 0     0   2   42 42                       84 34 1 47   0 0     0   2   42 42                 84
708512 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001949 5615 MARY E PENNOCK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 29 2 40   0 0     0   2   34 39                       73 29 2 40   0 0     0   2   34 39                 73
708520 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000148 6294 NORTH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 7 1 40   0 0     0   0   25 23                       48 7 1 40   0 0     0   0   25 23                 48
708553 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001950 7714 SECOND CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 34 2 45   0 3     1   2   52 35                       87 34 2 45   0 3     1   2   52 35                 87
708564 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001822 8032 JOHN W THIMMIG ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 55 1 42   0 6     0   2   52 54                       106 55 1 42   0 6     0   2   52 54                 106
708573 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000150 8060 SOUTH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 14 0 55   0 0     0   0   30 39                       69 14 0 55   0 0     0   0   30 39                 69
708580 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000151 8130 SOUTHEAST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 33 1 46   0 0     0   2   52 30                       82 33 1 46   0 0     0   2   52 30                 82
708587 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006401 8820 TURNBERRY ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 72 3 56   1 3     1   9   70 75                       145 72 3 56   1 3     1   9   70 75                 145
708599 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006326 9426 WEST RIDGE ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 65 0 30   0 12     0   2   45 64                       109 65 0 30   0 12     0   2   45 64                 109
708610 CO     school 802430 50   BENNETT 29J 80243000091 770 BENNETT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 57 1 9   0 0     0   5   43 29                       72 57 1 9   0 0     0   5   43 29                 72
708630 CO     school 806750 60   STRASBURG 31J 80675001159 8328 STRASBURG ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 54 1 12   2 0     0   0   36 33                       69 54 1 12   2 0     0   0   36 33                 69
708649 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001232 1622 CLARA E. METZ ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 8 0 41   0 1     0   1   28 23                       51 8 0 41   0 1     0   1   28 23                 51
708656 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001235 2876 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 5 1 52   0 3     0   0   28 33                       61 5 1 52   0 3     0   0   28 33                 61
708664 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001236 3144 FRANCIS M. DAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 1 1 54   0 1     0   0   36 21                       57 1 1 54   0 1     0   0   36 21                 57
708674 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001238 3792 HARRIS PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 5 3 42   0 3     0   0   25 28                       53 5 3 42   0 3     0   0   25 28                 53
708696 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006373 4465 JOSEPHINE HODGKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 10 0 85   0 3     0   0   50 48                       98 10 0 85   0 3     0   0   50 48                 98
708708 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001242 5834 MESA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 17 0 33   0 4     0   3   30 27                       57 17 0 33   0 4     0   3   30 27                 57
708719 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001363 7810 FLYNN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 14 1 25   0 5     0   1   27 19                       46 14 1 25   0 5     0   1   27 19                 46
708731 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001246 7860 SHERRELWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 5 0 37   0 1     0   3   25 21                       46 5 0 37   0 1     0   3   25 21                 46
708739 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001247 7952 SKYLINE VISTA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 0 53   0 2     0   1   26 36                       62 6 0 53   0 2     0   1   26 36                 62
708747 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001248 8406 SUNSET RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 11 0 49   0 3     0   2   31 34                       65 11 0 49   0 3     0   2   31 34                 65

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