Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_2", state = "NY" and year = 2017 sorted by asian_pacific_islander

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_2 · 4,722
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
943464 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_2 30.0   0.0               0.0   17.0 13.0             19     *   30 30   0               0   17 13         19       30
943502 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 23.0 0.0 2.0               0.0   12.0 13.0             21     *   25 23 0 2               0   12 13         21       25
943540 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 17.0   0.0                   7.0 10.0             11     *   17 17   0                   7 10         11       17
943692 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2017   grade_2 54.0   0.0   1.0           0.0   23.0 32.0             44     8   55 54   0   1           0   23 32         44   8   55
943901 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
943977 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008404460 320700010162 JHS 162 LOLA RODRIGUEZ DE TIO public Regular School No Middle 06 08 2017   grade_2   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
944091 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
944148 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 1.0 5.0 33.0               0.0   17.0 22.0     23       39     12   39 1 5 33               0   17 22     23   39   12   39
944205 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405761 320700011321 CROTONA ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   grade_2 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
944452 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406352 320700011557 MOTT HAVEN COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
944775 NY Bronx   school 3601105 320700861035   SOUTH BRONX CLASSICAL II 360110506385 320700861035 SOUTH BRONX CLASSICAL CHARTER II charter Regular School Yes Elementary KG 04 2017   grade_2 0.0 28.0 37.0   0.0           0.0   35.0 30.0     5       58     10   65 0 28 37   0           0   35 30     5   58   10   65
944794 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes Middle 06 08 2017   grade_2 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
944813 NY Bronx   school 3601131 320700861068   SOUTH BRONX EARLY COLLEGE AC 360113106555 320700861068 SOUTH BRONX EARLY COLLEGE ACADEMY CS charter Regular School Yes Middle 06 07 2017   grade_2 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
944870 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Other 09 09 2017   grade_2   0.0 0.0               0.0   0.0 0.0     0       0     0   0   0 0               0   0 0     0   0   0   0
945041 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502354 320800010093 PS 93 ALBERT G OLIVER public Regular School No Elementary PK 05 2017   grade_2 0.0 30.0 17.0   1.0           0.0   23.0 25.0     *       31     13   48 0 30 17   1           0   23 25         31   13   48
945307 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505121 320800010301 MS 301 PAUL L DUNBAR public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
945402 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505656 320800010335 ACADEMY OF THE ARTS (THE) public Regular School No Elementary PK 05 2017   grade_2 1.0 16.0 33.0   0.0           0.0   24.0 26.0     7       48     16   50 1 16 33   0           0   24 26     7   48   16   50
946371 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602410 320900010109 PS 109 SEDGWICK public Regular School No Elementary PK 05 2017   grade_2 0.0 14.0 76.0   0.0               45.0 45.0     36       83     19   90 0 14 76   0               45 45     36   83   19   90
947226 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605882 320900011329 DREAMYARD PREPARATORY SCHOOL public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
947264 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_2   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
948157 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704353 321000010159 PS 159 LUIS MUNOZ MARIN BILING public Regular School No Elementary KG 05 2017   grade_2 1.0 4.0 45.0   0.0               22.0 28.0     8       40     7   50 1 4 45   0               22 28     8   40   7   50
948898 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No Other 06 12 2017   grade_2 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
950798 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002194 321200010044 PS 44 DAVID C FARRAGUT public Regular School No Elementary PK 05 2017   grade_2 0.0 16.0 21.0               0.0   18.0 19.0     6       36     12   37 0 16 21               0   18 19     6   36   12   37
950893 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002279 321200010067 PS 67 MOHEGAN SCHOOL public Regular School No Elementary PK 05 2017   grade_2 0.0 21.0 77.0   1.0               55.0 44.0     *       78     29   99 0 21 77   1               55 44         78   29   99
951349 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006474 321200010458 SAMARA COMMUNITY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 0.0 10.0 31.0               0.0   15.0 26.0     11       40     10   41 0 10 31               0   15 26     11   40   10   41
951501 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
951520 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006218 321200011446 ARTURO A SCHOMBURG SATTELLITE-BRONX public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
952071 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 45.0 0.0 0.0               1.0   32.0 14.0             34     8   46 45 0 0               1   32 14         34   8   46
952375 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY SCHOOL public Regular School No Elementary PK 03 2017   grade_2 91.0   2.0   1.0           1.0   46.0 49.0             55     15   95 91   2   1           1   46 49         55   15   95
952432 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Alternative School No Other 02 09 2017   grade_2 3.0 0.0 1.0               1.0   3.0 2.0             *     5   5 3 0 1               1   3 2             5   5
952812 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 16.0 0.0 0.0               0.0   6.0 10.0             5     7   16 16 0 0               0   6 10         5   7   16
953002 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404857 42302040004 CATTARAUGUS-LITTLE VALLEY MIDDLE SCH public Regular School No Middle 05 08 2017   grade_2 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
953097 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239001005 42801060001 GOWANDA ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_2 58.0 2.0 3.0   17.0           7.0   41.0 46.0             62     16   87 58 2 3   17           7   41 46         62   16   87
953154 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 59.0   2.0               3.0   25.0 39.0             32     *   64 59   2               3   25 39         32       64
953211 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 67.0 0.0 3.0   2.0           3.0   35.0 40.0             44     10   75 67 0 3   2           3   35 40         44   10   75
953230 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No Other KG 12 2017   grade_2 0.0 0.0 1.0   2.0           0.0   3.0 0.0             *     *   3 0 0 1   2           0   3 0                 3
953667 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 69.0 0.0 2.0               2.0   39.0 34.0             44     10   73 69 0 2               2   39 34         44   10   73
953971 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801938 60503040002 CHAUTAUQUA LAKE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 53.0 0.0 0.0   0.0           2.0   24.0 31.0             25     *   55 53 0 0   0           2   24 31         25       55
953990 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 39.0 0.0 1.0   0.0           3.0   23.0 20.0     *       29     6   43 39 0 1   0           3   23 20         29   6   43
954085 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000722 60800010005 SCHOOL 5 public Regular School No Elementary PK 05 2017   grade_2 15.0 2.0 22.0   0.0           3.0   23.0 19.0     12       34     *   42 15 2 22   0           3   23 19     12   34       42
954104 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000724 60800010007 SCHOOL 7 public Regular School No Elementary PK 05 2017   grade_2 23.0 3.0 24.0   0.0           1.0   25.0 26.0     6       35     11   51 23 3 24   0           1   25 26     6   35   11   51
954237 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000872 61101040009 PAUL B D TEMPLE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 80.0 0.0 1.0                   39.0 42.0             46     *   81 80 0 1                   39 42         46       81
954256 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003666 61501040001 SILVER CREEK HIGH SCHOOL public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
954275 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0 0 0 0   0           0   0 0         0   0   0
954313 NY Chautauqua   school 3611250 61503040000   FORESTVILLE 361125000890 61503040002 FORESTVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 23.0 0.0 2.0   1.0           3.0   19.0 10.0             20     *   29 23 0 2   1           3   19 10         20       29
954351 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2017   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
954370 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003155 61601040003 PANAMA K-6 SCHOOL public Regular School No Elementary PK 06 2017   grade_2 27.0   3.0               0.0   15.0 15.0             17     6   30 27   3               0   15 15         17   6   30
954617 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000288 62301040002 BROCTON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 30.0 1.0 6.0               2.0   18.0 21.0     *       25     12   39 30 1 6               2   18 21         25   12   39
954655 NY Chautauqua   school 3624660 62401040000   RIPLEY 362466004367 62401040001 RIPLEY CENTRAL SCHOOL public Regular School No Elementary PK 06 2017   grade_2 20.0   0.0   0.0               9.0 11.0     *       14     0   20 20   0   0               9 11         14   0   20
954693 NY Chautauqua   school 3626730 62601040000   SHERMAN 362673003650 62601040003 SHERMAN HIGH SCHOOL public Regular School No High 07 12 2017   grade_2 0.0 0.0 0.0   0.0               0.0 0.0             0     0   0 0 0 0   0               0 0         0   0   0
954788 NY Chemung   school 3610560 70600010000   ELMIRA 361056000817 70600010007 FASSETT ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 69.0 15.0 0.0   0.0           26.0   61.0 49.0             97     21   110 69 15 0   0           26   61 49         97   21   110
954826 NY Chemung   school 3610560 70600010000   ELMIRA 361056004387 70600010013 PARLEY COBURN SCHOOL public Regular School No Elementary 03 06 2017   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
954845 NY Chemung   school 3610560 70600010000   ELMIRA 361056000822 70600010014 PINE CITY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 85.0 4.0 1.0               5.0   47.0 48.0             56     11   95 85 4 1               5   47 48         56   11   95
954978 NY Chemung   school 3601128 70600861078   FINN ACADEMY-AN ELMIRA CHART 360112806541 70600861078 FINN ACADEMY-AN ELMIRA CHARTER SCHOO charter Regular School Yes Elementary KG 04 2017   grade_2 38.0 4.0 4.0   0.0           7.0   28.0 25.0             19     6   53 38 4 4   0           7   28 25         19   6   53
955282 NY Chenango   school 3612750 80601040000   GREENE 361275001546 80601040001 GREENE PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 59.0 1.0 0.0   0.0           0.0   32.0 28.0     *       28     *   60 59 1 0   0           0   32 28         28       60
955472 NY Chenango   school 3622100 81401040000   GRGETWN-SO OTSELIC 362210003132 81401040001 OTSELIC VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 23.0 0.0 1.0                   14.0 10.0     *       19     *   24 23 0 1                   14 10         19       24
955605 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No Elementary KG 06 2017   grade_2 51.0 0.0 0.0                   19.0 32.0             28     *   51 51 0 0                   19 32         28       51
955643 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_2 34.0 1.0                     17.0 18.0             17     6   35 34 1                     17 18         17   6   35
955814 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Other 06 09 2017   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956042 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 54.0   0.0               1.0   24.0 31.0             29     8   55 54   0               1   24 31         29   8   55
956099 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956118 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2017   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956137 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2017   grade_2 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
956479 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_2 53.0   0.0               2.0   19.0 36.0             40     8   55 53   0               2   19 36         40   8   55
956498 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956517 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956555 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_2 16.0                   0.0   6.0 10.0             8     *   16 16                   0   6 10         8       16
956574 NY Cortland   school 3608460 110200010000   CORTLAND 360846000645 110200010008 ALTON B PARKER SCHOOL public Regular School No Elementary KG 06 2017   grade_2 27.0 1.0 4.0               2.0   17.0 17.0             19     *   34 27 1 4               2   17 17         19       34
956612 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 F E SMITH SCHOOL public Regular School No Elementary KG 06 2017   grade_2 36.0 2.0 2.0               2.0   23.0 19.0             26     *   42 36 2 2               2   23 19         26       42
956650 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 38.0   0.0               2.0   20.0 20.0             *     *   40 38   0               2   20 20                 40
956707 NY Cortland   school 3614640 110701060000   HOMER 361464001214 110701060002 HOMER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 115.0   2.0               5.0   61.0 61.0     *       71     11   122 115   2               5   61 61         71   11   122
956783 NY Cortland   school 3618450 110901040000   MARATHON 361845001660 110901040002 WILLIAM APPLEBY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 54.0 1.0 0.0                   30.0 25.0     *       36     *   55 54 1 0                   30 25         36       55
956802 NY Delaware   school 3609060 31301040000   DEPOSIT 360906000693 31301040002 DEPOSIT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 34.0 1.0 1.0               1.0   21.0 16.0             27     5   37 34 1 1               1   21 16         27   5   37
956840 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 10.0 0.0 0.0               0.0   6.0 4.0             9     *   10 10 0 0               0   6 4         9       10
957011 NY Delaware   school 3625110 121502040000   ROXBURY 362511003473 121502040001 ROXBURY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 24.0 0.0 1.0   0.0           0.0   14.0 11.0             18     6   25 24 0 1   0           0   14 11         18   6   25
957638 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No Elementary PK 01 2017   grade_2 0.0   0.0               0.0   0.0 0.0     0       0     0   0 0   0               0   0 0     0   0   0   0
958493 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2017   grade_2 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
958588 NY Erie   school 3602550 140101060000   ALDEN 360255000041 140101060003 ALDEN PRIMARY AT TOWNLINE public Regular School No Elementary KG 2 2017   grade_2 115.0 0.0 2.0               2.0   65.0 54.0     *       *     13   119 115 0 2               2   65 54             13   119
960450 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_2   49.0 8.0   0.0           4.0   30.0 31.0     *       59     5   61   49 8   0           4   30 31         59   5   61
961001 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001062 141101060002 COLDEN ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 24.0   1.0   0.0           1.0   13.0 13.0             7     0   26 24   1   0           1   13 13         7   0   26
961286 NY Erie   school 3616560 141401060000   EVANS-BRANT 361656001462 141401060008 A J SCHMIDT ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 48.0 1.0 4.0   5.0           2.0   34.0 26.0             30     14   60 48 1 4   5           2   34 26         30   14   60
961970 NY Erie   school 3620970 142201040000   NORTH COLLINS 362097002978 142201040001 NORTH COLLINS JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_2 0.0 0.0 0.0   0.0               0.0 0.0             0     0   0 0 0 0   0               0 0         0   0   0
962160 NY Erie   school 3628740 142500010000   TONAWANDA 362874003905 142500010007 RIVERVIEW ELEMENTARY SCHOOL public Regular School No Elementary KG 3 2017   grade_2 63.0 4.0 7.0               1.0   35.0 40.0     *       37     *   75 63 4 7               1   35 40         37       75
962635 NY Essex   school 3619830 150901040000   MORIAH 361983001815 150901040004 MORIAH JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_2 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
962654 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 6 2017   grade_2 42.0 0.0 0.0               0.0   20.0 22.0             23     6   42 42 0 0               0   20 22         23   6   42
962730 NY Essex   school 3626130 151401040000   SCHROON LAKE 362613003599 151401040001 SCHROON LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 11.0 0.0 0.0                   4.0 7.0     *       9     *   11 11 0 0                   4 7         9       11
962806 NY Essex   school 3631080 151601040000   WESTPORT 363108004170 151601040001 WESTPORT CENTRAL SCHOOL public Regular School No Other KG 12 2017   grade_2 12.0                   0.0   6.0 6.0     *       7     *   12 12                   0   6 6         7       12
962825 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 15.0 0.0 0.0   0.0           0.0   6.0 9.0             7     *   15 15 0 0   0           0   6 9         7       15
962882 NY Franklin   school 3607080 160801040000   CHATEAUGAY 360708000499 160801040001 CHATEAUGAY ELEMENTARY SCHOOL public Regular School No Elementary PK 6 2017   grade_2 38.0   0.0                   20.0 18.0             17     *   38 38   0                   20 18         17       38
962920 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003525 161201040001 ST REGIS MOHAWK SCHOOL public Regular School No Elementary PK 5 2017   grade_2 0.0   0.0   52.0           4.0   21.0 35.0             49     *   56 0   0   52           4   21 35         49       56
962958 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003522 161201040003 SALMON RIVER ELEMENTARY SCHOOL public Regular School No Elementary PK 5 2017   grade_2 39.0   0.0   13.0           7.0   33.0 26.0             49     *   59 39   0   13           7   33 26         49       59
962977 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550006264 161201040005 SALMON RIVER MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_2 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
962996 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003533 161401060001 PETROVA ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 53.0 1.0 2.0   0.0           1.0   32.0 25.0             *     *   57 53 1 2   0           1   32 25                 57
963034 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003534 161401060003 SARANAC LAKE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_2 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
963053 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 5 2017   grade_2 19.0                       7.0 12.0             9     0   19 19                       7 12         9   0   19
963205 NY Franklin   school 3627990 161801040000   ST REGIS FALLS 362799003793 161801040001 ST REGIS FALLS CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 15.0   1.0   1.0           1.0   12.0 6.0             12     6   18 15   1   1           1   12 6         12   6   18
963224 NY Fulton   school 3631200 170301020000   WHEELERVILLE 363120004173 170301020001 WHEELERVILLE SCHOOL public Regular School No Elementary PK 8 2017   grade_2 16.0   0.0               1.0   6.0 11.0             10     0   17 16   0               1   6 11         10   0   17
963262 NY Fulton   school 3612270 170500010000   GLOVERSVILLE 361227000989 170500010006 MCNAB-MECO SCHOOL public Regular School No Elementary PK 5 2017   grade_2 34.0 2.0 3.0               5.0   23.0 21.0             32     *   44 34 2 3               5   23 21         32       44
963281 NY Fulton   school 3612270 170500010000   GLOVERSVILLE 361227000991 170500010007 PARK TERRACE SCHOOL public Regular School No Elementary PK 5 2017   grade_2 25.0 3.0 3.0               4.0   16.0 19.0             23     *   35 25 3 3               4   16 19         23       35
963794 NY Genesee   school 3610380 180901040000   ELBA 361038000801 180901040001 ELBA ELEMENTARY SCHOOL public Regular School No Elementary PK 6 2017   grade_2 20.0 0.0 8.0               0.0   16.0 12.0     6       16     6   28 20 0 8               0   16 12     6   16   6   28

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