Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_2", state = "NY" and year = 2019 sorted by asian_pacific_islander

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_2 · 4,719
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
2139458 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_2 1.0 48.0 15.0               5.0   34.0 35.0     *       59     *   69 1 48 15               5   34 35         59       69
2140522 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2019   grade_2 17.0 0.0 0.0   0.0           0.0   9.0 8.0             12     *   17 17 0 0   0           0   9 8         12       17
2140560 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_2 22.0 0.0 0.0               1.0   9.0 14.0             18     *   23 22 0 0               1   9 14         18       23
2140598 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_2 14.0 0.0 1.0                   7.0 8.0             7     *   15 14 0 1                   7 8         7       15
2140674 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_2 22.0 0.0 1.0   0.0           0.0   12.0 11.0     *       17     *   23 22 0 1   0           0   12 11         17       23
2140731 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No High 06 12 2019   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
2140750 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 56.0 0.0 0.0   0.0           1.0   35.0 22.0             37     *   57 56 0 0   0           1   35 22         37       57
2140769 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_2 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2141149 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2019   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
2141206 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 0.0 6.0 25.0               1.0   16.0 16.0     18       32     14   32 0 6 25               1   16 16     18   32   14   32
2141339 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405180 320700011427 COMMUNITY SCHOOL-SOCIAL JUSTICE public Regular School No High 09 12 2019   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
2141491 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406352 320700011557 MOTT HAVEN COMMUNITY HIGH SCHOOL public Regular School No High 10 12 2019   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
2141757 NY Bronx   school 3601044 320700861005   NYC MONTESSORI CHARTER SCHOO 360104406248 320700861005 NYC MONTESSORI CHARTER SCHOOL charter Regular School Yes Elementary PK 05 2019   grade_2 1.0 21.0 32.0   0.0           2.0   26.0 30.0     16       51     16   56 1 21 32   0           2   26 30     16   51   16   56
2141833 NY Bronx   school 3601105 320700861035   SOUTH BRONX CLASSICAL II 360110506385 320700861035 SOUTH BRONX CLASSICAL CHARTER II charter Regular School Yes Elementary KG 06 2019   grade_2 1.0 36.0 27.0   0.0           1.0   28.0 37.0     10       58     7   65 1 36 27   0           1   28 37     10   58   7   65
2141852 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes Middle 06 10 2019   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
2141909 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141966 NY Bronx   school 3601187 320700861139   URBAN DOVE TEAM CHARTER SCHO 360118706628 320700861139 URBAN DOVE TEAM CHARTER SCHOOL II charter Regular School Yes High 09 12 2019   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
2142156 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502354 320800010093 PS 93 ALBERT G OLIVER public Regular School No Elementary PK 05 2019   grade_2 1.0 17.0 22.0   1.0           0.0   19.0 22.0     *       29     9   41 1 17 22   1           0   19 22         29   9   41
2142346 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502530 320800010146 PS 146 EDWARD COLLINS public Regular School No Elementary PK 05 2019   grade_2 2.0 22.0 37.0   0.0           0.0   33.0 28.0     11       59     14   61 2 22 37   0           0   33 28     11   59   14   61
2142403 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505121 320800010301 MS 301 PAUL L DUNBAR public Regular School No Middle 06 08 2019   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
2143296 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602238 320900010055 PS 55 BENJAMIN FRANKLIN public Regular School No Elementary PK 05 2019   grade_2 0.0 39.0 43.0                   38.0 44.0     10       82     18   82 0 39 43                   38 44     10   82   18   82
2143372 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602298 320900010073 PS 73 BRONX public Regular School No Elementary PK 05 2019   grade_2 2.0 12.0 64.0   0.0           0.0   38.0 40.0     20       75     16   78 2 12 64   0           0   38 40     20   75   16   78
2143410 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602410 320900010109 PS 109 SEDGWICK public Regular School No Elementary PK 05 2019   grade_2 0.0 18.0 82.0   1.0               53.0 48.0     25       92     30   101 0 18 82   1               53 48     25   92   30   101
2143695 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 public Regular School No Middle 06 08 2019   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
2143733 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606391 320900010274 NEW AMERICAN ACAD-R CLEMENTE STATE public Regular School No Elementary PK 05 2019   grade_2 0.0 50.0 60.0   1.0           0.0   54.0 57.0     20       109     35   111 0 50 60   1           0   54 57     20   109   35   111
2144037 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606629 320900010593 SOUTH BRONX INTERNATIONAL MS public Regular School No Middle 06 06 2019   grade_2   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
2144151 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605793 320900011252 MOTT HALL BRONX HIGH SCHOOL public Regular School No High 09 12 2019   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
2144284 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2019   grade_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
2144683 NY Bronx   school 3601156 320900861122   SOUTH BRONX CLASSICAL CHARTE 360115606620 320900861122 SOUTH BRONX CLASSICAL CHARTER SCH IV charter Regular School Yes Elementary KG 02 2019   grade_2 0.0 19.0 17.0   1.0           0.0   24.0 13.0     *       35     *   37 0 19 17   1           0   24 13         35       37
2144702 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705137 321000010003 PS 3 RAUL JULIA MICRO SOCIETY public Regular School No Elementary PK 08 2019   grade_2 0.0 13.0 19.0                   14.0 18.0     7       32     7   32 0 13 19                   14 18     7   32   7   32
2145196 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 2019   grade_2 0.0 7.0 33.0   1.0           0.0   14.0 27.0     15       39     7   41 0 7 33   1           0   14 27     15   39   7   41
2146792 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802419 321100010112 PS 112 BRONXWOOD public Regular School No Elementary PK 05 2019   grade_2 2.0 20.0 22.0                   23.0 21.0     *       42     10   44 2 20 22                   23 21         42   10   44
2147134 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2019   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
2148160 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009001309 321200010212 PS 212 public Regular School No Elementary PK 05 2019   grade_2 0.0 10.0 18.0   0.0           0.0   12.0 16.0     8       28     5   28 0 10 18   0           0   12 16     8   28   5   28
2148293 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006401 321200010314 FAIRMONT NEIGHBORHOOD SCHOOL public Regular School No Elementary PK 05 2019   grade_2 0.0 12.0 25.0                   16.0 21.0     *       37     13   37 0 12 25                   16 21         37   13   37
2148464 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006630 321200010595 PS 595 public Regular School No Elementary PK 02 2019   grade_2 2.0 10.0 34.0                   20.0 26.0     11       42     13   46 2 10 34                   20 26     11   42   13   46
2148559 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2019   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
2148578 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006218 321200011446 ARTURO A SCHOMBURG SATTELLITE-BRONX public Regular School No High 10 12 2019   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
2148882 NY Bronx   school 3601161 321200861108   NY CENTER FOR AUTISM CS - BR 360116106615 321200861108 NY CENTER FOR AUTISM CS - BRONX charter Special Education School Yes Elementary KG KG 2019   grade_2 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
2149452 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY SCHOOL public Regular School No Elementary PK 03 2019   grade_2 99.0 0.0 0.0               1.0   57.0 43.0             57     *   100 99 0 0               1   57 43         57       100
2149509 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   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
2150079 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404857 42302040004 CATTARAUGUS-LITTLE VALLEY MIDDLE SCH public Regular School No Middle 05 08 2019   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
2150174 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239001005 42801060001 GOWANDA ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_2 68.0 1.0 3.0   20.0           5.0   43.0 54.0             68     23   97 68 1 3   20           5   43 54         68   23   97
2150231 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 69.0 1.0 1.0   0.0           6.0   33.0 44.0             34     *   77 69 1 1   0           6   33 44         34       77
2150288 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 50.0 1.0 0.0   6.0           1.0   34.0 24.0             32     *   58 50 1 0   6           1   34 24         32       58
2150326 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2019   grade_2 4.0 1.0 1.0   0.0           0.0   4.0 2.0     *       *     5   6 4 1 1   0           0   4 2             5   6
2150706 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2019   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
2150744 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 52.0 1.0 1.0               1.0   27.0 28.0             23     6   55 52 1 1               1   27 28         23   6   55
2150782 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 66.0 0.0 0.0               0.0   24.0 42.0     *       37     8   66 66 0 0               0   24 42         37   8   66
2151010 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801936 60503040001 CHAUTAUQUA LAKE SECONDARY SCHOOL public Regular School No High 07 12 2019   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
2151048 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 27.0 0.0 5.0   0.0           0.0   19.0 13.0     *       21     5   32 27 0 5   0           0   19 13         21   5   32
2151067 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003232 60601040003 PINE VALLEY CENTRAL JR-SR HIGH SCH public Regular School No High 07 12 2019   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
2151105 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000720 60800010003 SCHOOL 3 public Regular School No Elementary KG 05 2019   grade_2 4.0 2.0 38.0   0.0           1.0   24.0 21.0     14       42     *   45 4 2 38   0           1   24 21     14   42       45
2151143 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000722 60800010005 SCHOOL 5 public Regular School No Elementary KG 05 2019   grade_2 6.0 1.0 14.0               2.0   9.0 14.0     *       18     *   23 6 1 14               2   9 14         18       23
2151200 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000718 60800010010 DUNKIRK MIDDLE SCHOOL public Regular School No Middle 03 08 2019   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
2151295 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000872 61101040009 PAUL B D TEMPLE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   grade_2 96.0 1.0 4.0               0.0   49.0 52.0             58     13   101 96 1 4               0   49 52         58   13   101
2151333 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2151371 NY Chautauqua   school 3611250 61503040000   FORESTVILLE 361125000890 61503040002 FORESTVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 26.0   3.0   0.0           2.0   16.0 15.0             22     0   31 26   3   0           2   16 15         22   0   31
2151409 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2019   grade_2 0.0   0.0               0.0   0.0 0.0     *       0     0   0 0   0               0   0 0         0   0   0
2151428 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003155 61601040003 PANAMA K-6 SCHOOL public Regular School No Elementary PK 06 2019   grade_2 37.0 1.0 1.0   1.0           0.0   26.0 14.0     *       24     8   40 37 1 1   1           0   26 14         24   8   40
2151466 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001346 61700010003 CLINTON V BUSH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_2 40.0 2.0 15.0               4.0   33.0 28.0             52     9   61 40 2 15               4   33 28         52   9   61
2151542 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001351 61700010010 THOMAS JEFFERSON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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
2151675 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000288 62301040002 BROCTON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 29.0 0.0 3.0   0.0           0.0   16.0 16.0     0       21     *   32 29 0 3   0           0   16 16     0   21       32
2151713 NY Chautauqua   school 3624660 62401040000   RIPLEY 362466004367 62401040001 RIPLEY CENTRAL SCHOOL public Regular School No Elementary PK 06 2019   grade_2 11.0 0.0 0.0                   6.0 5.0     *       9     *   11 11 0 0                   6 5         9       11
2151732 NY Chautauqua   school 3626730 62601040000   SHERMAN 362673004940 62601040002 SHERMAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 21.0 0.0 0.0                   16.0 5.0             15     *   21 21 0 0                   16 5         15       21
2151751 NY Chautauqua   school 3626730 62601040000   SHERMAN 362673003650 62601040003 SHERMAN HIGH SCHOOL public Regular School No High 07 12 2019   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
2151827 NY Chemung   school 3610560 70600010000   ELMIRA 361056000816 70600010006 DIVEN SCHOOL public Regular School No Elementary PK 02 2019   grade_2 80.0 19.0 4.0               25.0   61.0 67.0     *       94     20   128 80 19 4               25   61 67         94   20   128
2151846 NY Chemung   school 3610560 70600010000   ELMIRA 361056000817 70600010007 FASSETT ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   grade_2 66.0 13.0 4.0   0.0           15.0   43.0 55.0     *       81     18   98 66 13 4   0           15   43 55         81   18   98
2151903 NY Chemung   school 3610560 70600010000   ELMIRA 361056000822 70600010014 PINE CITY SCHOOL public Regular School No Elementary PK 02 2019   grade_2 81.0 2.0 0.0               14.0   45.0 52.0     *       53     8   97 81 2 0               14   45 52         53   8   97
2152017 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2019   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
2152226 NY Chemung   school 3610590 70902060000   ELMIRA HEIGHTS 361059000828 70902060006 COHEN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 71.0 1.0 2.0               7.0   42.0 39.0             49     *   81 71 1 2               7   42 39         49       81
2152340 NY Chenango   school 3612750 80601040000   GREENE 361275001546 80601040001 GREENE PRIMARY SCHOOL public Regular School No Elementary PK 02 2019   grade_2 74.0 2.0 0.0                   38.0 38.0             42     5   76 74 2 0                   38 38         42   5   76
2152530 NY Chenango   school 3622100 81401040000   GRGETWN-SO OTSELIC 362210003132 81401040001 OTSELIC VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_2 16.0 0.0 0.0                   8.0 8.0     *       11     *   16 16 0 0                   8 8         11       16
2152568 NY Chenango   school 3622260 81501040000   OXFORD 362226003143 81501040002 OXFORD ACADEMY HIGH SCHOOL public Regular School No High 09 12 2019   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
2152663 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 55.0 1.0 0.0                   27.0 29.0             42     8   56 55 1 0                   27 29         42   8   56
2152701 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 22.0 1.0                 0.0   14.0 9.0             18     5   23 22 1                 0   14 9         18   5   23
2152720 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153100 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 49.0   0.0               1.0   23.0 27.0             22     5   50 49   0               1   23 27         22   5   50
2153157 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2153176 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153195 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153461 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 33.0 0.0 0.0               3.0   14.0 22.0             22     8   36 33 0 0               3   14 22         22   8   36
2153480 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   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
2153499 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_2 28.0 0.0 0.0               0.0   11.0 17.0             19     *   28 28 0 0               0   11 17         19       28
2153518 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No High 09 12 2019   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
2153537 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_2 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153575 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_2 13.0 0.0 0.0               0.0   8.0 5.0             7     *   13 13 0 0               0   8 5         7       13
2153594 NY Cortland   school 3608460 110200010000   CORTLAND 360846000645 110200010008 ALTON B PARKER SCHOOL public Regular School No Elementary KG 06 2019   grade_2 34.0 1.0 1.0               3.0   14.0 25.0             25     5   39 34 1 1               3   14 25         25   5   39
2153689 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 34.0   0.0               0.0   19.0 15.0             25     6   34 34   0               0   19 15         25   6   34
2153841 NY Delaware   school 3609060 31301040000   DEPOSIT 360906000693 31301040002 DEPOSIT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 30.0 0.0 0.0               1.0   18.0 13.0             25     6   31 30 0 0               1   18 13         25   6   31
2153860 NY Delaware   school 3609060 31301040000   DEPOSIT 360906000694 31301040003 DEPOSIT MIDDLE-SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   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
2153879 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_2 5.0 0.0 1.0               0.0   3.0 3.0             *     *   6 5 0 1               0   3 3                 6
2154050 NY Delaware   school 3625110 121502040000   ROXBURY 362511003473 121502040001 ROXBURY CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_2 18.0 1.0 0.0               0.0   9.0 10.0             12     *   19 18 1 0               0   9 10         12       19
2154544 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039004971 131101040006 WEBUTUCK ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   grade_2 27.0 0.0 3.0               1.0   20.0 11.0     *       *     5   31 27 0 3               1   20 11             5   31
2154677 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No Elementary PK 01 2019   grade_2 0.0   0.0               0.0   0.0 0.0     *       0     0   0 0   0               0   0 0         0   0   0
2154848 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000089 131601060002 BEEKMAN SCHOOL public Regular School No Elementary KG 05 2019   grade_2 49.0 2.0 6.0               0.0   22.0 35.0             5     7   57 49 2 6               0   22 35         5   7   57
2155513 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2019   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
2157299 NY Erie   school 3605850 140600010000   BUFFALO 360585006633 140600010315 NORTH PARK COMMUNITY SCHOOL #50 public Regular School No Elementary PK KG 2019   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
2157641 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 01 2019   grade_2 0.0 0.0 0.0               0.0   0.0 0.0             0         0 0 0 0               0   0 0         0       0
2158116 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001062 141101060002 COLDEN ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_2 26.0   2.0               1.0   13.0 16.0             10     *   29 26   2               1   13 16         10       29

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