Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by asian_pacific_islander

View and edit SQL

year

grade

  • grade_2 · 33,145
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
745925 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 12.0 2.0 2.0               1.0   10.0 7.0             14     *   17 12 2 2               1   10 7         14       17
746647 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 26.0   0.0               0.0   9.0 17.0             11     *   26 26   0               0   9 17         11       26
746685 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 24.0   1.0               3.0   16.0 12.0             25     5   28 24   1               3   16 12         25   5   28
746723 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 14.0   1.0                   6.0 9.0             12     *   15 14   1                   6 9         12       15
746875 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No 4.0 06 12 2015   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
746894 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 56.0 0.0 1.0   0.0           0.0   26.0 31.0             33     8   57 56 0 1   0           0   26 31         33   8   57
747122 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No 1.0 PK 05 2015   grade_2 0.0 25.0 43.0   2.0               40.0 30.0             64     16   70 0 25 43   2               40 30         64   16   70
747217 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405119 320700010203 MS 203 public Regular School No 4.0 08 08 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
747255 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No 2.0 06 08 2015   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
747369 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_2 0.0 3.0 40.0                   24.0 19.0             42     24   43 0 3 40                   24 19         42   24   43
747388 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406020 320700010385 PERFORMANCE SCHOOL public Regular School No 2.0 04 05 2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
747540 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405187 320700011473 MOTT HAVEN VILLAGE PREP HIGH SCHOOL public Regular School No 3.0 09 12 2015   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
747749 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402866 320700011655 SAMUEL GOMPERS CAREER/TECH ED HS public Vocational Education School No 3.0 09 12 2015   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
747787 NY Bronx   school 3601074 320700860703   HEKETI COMMUNITY CHARTER SCH 360107406336 320700860703 HEKETI COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 03 2015   grade_2 0.0 21.0 33.0   0.0           0.0   20.0 34.0             46     14   54 0 21 33   0           0   20 34         46   14   54
747920 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes 3.0 09 12 2015   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
748015 NY Bronx   school 3601108 320700861014   BRILLA COLLEGE PREP CHARTER 360110806384 320700861014 BRILLA COLLEGE PREP CHARTER charter Regular School Yes 1.0 KG 02 2015   grade_2 1.0 29.0 44.0               0.0   42.0 32.0             57     14   74 1 29 44               0   42 32         57   14   74
748053 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes 1.0 KG 03 2015   grade_2   24.0 52.0                   36.0 40.0             76     8   76   24 52                   36 40         76   8   76
748072 NY Bronx   school 3601105 320700861035   SOUTH BRONX CLASSICAL II 360110506385 320700861035 SOUTH BRONX CLASSICAL CHARTER II charter Regular School Yes 1.0 KG 02 2015   grade_2 0.0 13.0 17.0               0.0   15.0 15.0             21     *   30 0 13 17               0   15 15         21       30
748091 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes 2.0 06 06 2015   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
748281 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502354 320800010093 PS 93 ALBERT G OLIVER public Regular School No 1.0 PK 05 2015   grade_2 2.0 36.0 17.0   1.0           0.0   35.0 21.0             36     24   56 2 36 17   1           0   35 21         36   24   56
748889 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505660 320800011295 GATEWAY SCHOOL-ENVIR AND TECH public Regular School No 3.0 09 12 2015   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
749136 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502968 320800011530 BANANA KELLY HIGH SCHOOL public Regular School No 3.0 09 12 2015   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
749231 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502011 320800011650 JANE ADDAMS HS FOR ACADEMIC CAREERS public Vocational Education School No 3.0 09 12 2015   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
749345 NY Bronx   school 3601096 320800861044   SUCCESS ACAD CHARTER SCH-BR 3 360109606390 320800861044 SUCCESS ACAD CHARTER SCH-BRONX 3 charter Regular School Yes 1.0 KG 02 2015   grade_2 1.0 52.0 53.0   2.0           2.0   59.0 51.0             85     9   110 1 52 53   2           2   59 51         85   9   110
749934 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602737 320900010229 IS 229 ROLAND PATTERSON public Regular School No 2.0 06 08 2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
749972 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 public Regular School No 2.0 06 08 2015   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
750048 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603764 320900010303 IS 303 LEADERSHIP & COMM SERVICE public Regular School No 2.0 06 08 2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
750067 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606393 320900010311 LUCERO ELEMENTARY SCHOOL public Regular School No 1.0 KG 03 2015   grade_2 0.0 5.0 50.0   0.0               31.0 24.0             55     18   55 0 5 50   0               31 24         55   18   55
750295 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606312 320900010555 MOUNT EDEN CHILDREN'S ACADEMY public Regular School No 1.0 PK 03 2015   grade_2 0.0 16.0 46.0                   32.0 30.0             59     12   62 0 16 46                   32 30         59   12   62
750466 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605795 320900011276 LEADERSHIP INSTITUTE public Regular School No 3.0 09 12 2015   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
750561 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No 3.0 09 12 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
750808 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes 1.0 KG 08 2015   grade_2 0.0 18.0 20.0                   15.0 23.0             36     *   38 0 18 20                   15 23         36       38
750827 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER I 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER I charter Regular School Yes 1.0 KG 08 2015   grade_2 0.0 11.0 41.0   0.0           0.0   23.0 29.0             48     *   52 0 11 41   0           0   23 29         48       52
751454 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704353 321000010159 PS 159 LUIS MUNOZ MARIN BILING public Regular School No 1.0 KG 05 2015   grade_2 1.0 1.0 22.0               0.0   9.0 15.0             21     7   24 1 1 22               0   9 15         21   7   24
751530 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700739 321000010209 PS 209 public Regular School No 1.0 PK 02 2015   grade_2 1.0 8.0 55.0                   35.0 29.0             64     23   64 1 8 55                   35 29         64   23   64
751929 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706057 321000010382 ELEM SCHOOL FOR MATH, SCIENCE, TECH public Regular School No 1.0 KG 05 2015   grade_2   10.0 32.0   0.0               25.0 17.0             41     7   42   10 32   0               25 17         41   7   42
752005 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703820 321000010396 PS 396 public Regular School No 1.0 PK 05 2015   grade_2 2.0 12.0 44.0                   31.0 27.0             49     16   58 2 12 44                   31 27         49   16   58
752195 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No 4.0 06 12 2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
753012 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802419 321100010112 PS 112 BRONXWOOD public Regular School No 1.0 PK 05 2015   grade_2 0.0 18.0 31.0                   27.0 22.0             49     13   49 0 18 31                   27 22         49   13   49
754076 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002219 321200010050 PS 50 CLARA BARTON public Regular School No 2.0 04 05 2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
754133 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005509 321200010066 PS 66 SCHOOL OF HIGHER EXPECTATIONS public Regular School No 1.0 PK 05 2015   grade_2 2.0 26.0 86.0   0.0               56.0 58.0             92     30   114 2 26 86   0               56 58         92   30   114
754475 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006401 321200010314 FAIRMONT NEIGHBORHOOD SCHOOL public Regular School No 1.0 PK 03 2015   grade_2 2.0 18.0 32.0   0.0           1.0   28.0 25.0             50     13   53 2 18 32   0           1   28 25         50   13   53
754513 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009004878 321200010318 IS 318 MATH, SCIENCE & TECH THRO ART public Regular School No 2.0 06 08 2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
754608 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006474 321200010458 SAMARA COMMUNITY SCHOOL public Regular School No 1.0 PK KG 2015   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
754779 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No 3.0 09 12 2015   grade_2     0.0                   0.0 0.0             0     0   0     0                   0 0         0   0   0
756071 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 19.0 0.0 0.0               0.0   10.0 9.0             12     *   19 19 0 0               0   10 9         12       19
756242 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No 1.0 PK 04 2015   grade_2 62.0 2.0 2.0   2.0           1.0   41.0 28.0             45     7   69 62 2 2   2           1   41 28         45   7   69
756280 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404857 42302040004 CATTARAUGUS-LITTLE VALLEY MIDDLE SCH public Regular School No 2.0 05 07 2015   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
756508 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No 4.0 KG 12 2015   grade_2 2.0 0.0 0.0   0.0           0.0   2.0 0.0             *     *   2 2 0 0   0           0   2 0                 2
756527 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No 4.0 KG 12 2015   grade_2 2.0 2.0 1.0   0.0           0.0   5.0 0.0             0     5   5 2 2 1   0           0   5 0         0   5   5
756546 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA JUNIOR/SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   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
756945 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 58.0 0.0 1.0               1.0   36.0 24.0             28     7   60 58 0 1               1   36 24         28   7   60
757249 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 43.0   2.0   0.0           0.0   18.0 27.0             29     5   45 43   2   0           0   18 27         29   5   45
757325 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000721 60800010004 SCHOOL 4 public Regular School No 1.0 PK 05 2015   grade_2 11.0 2.0 23.0               5.0   23.0 18.0             33     8   41 11 2 23               5   23 18         33   8   41
757344 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000722 60800010005 SCHOOL 5 public Regular School No 1.0 PK 05 2015   grade_2 9.0 1.0 9.0   0.0           1.0   9.0 11.0             15     *   20 9 1 9   0           1   9 11         15       20
757363 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000724 60800010007 SCHOOL 7 public Regular School No 1.0 PK 05 2015   grade_2 20.0 1.0 18.0   0.0           2.0   24.0 17.0             32     6   41 20 1 18   0           2   24 17         32   6   41
757458 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No 1.0 03 05 2015   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
757515 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003666 61501040001 SILVER CREEK HIGH SCHOOL public Regular School No 3.0 09 12 2015   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
757534 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   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
757591 NY Chautauqua   school 3611250 61503040000   FORESTVILLE 361125000889 61503040003 FORESTVILLE CENTRAL HIGH SCHOOL public Regular School No 3.0 07 12 2015   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
757610 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
757629 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003155 61601040003 PANAMA K-6 SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 34.0   0.0               2.0   24.0 12.0             20     *   36 34   0               2   24 12         20       36
757876 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000288 62301040002 BROCTON ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_2 44.0 0.0 8.0   0.0           4.0   28.0 28.0             45     12   56 44 0 8   0           4   28 28         45   12   56
757914 NY Chautauqua   school 3624660 62401040000   RIPLEY 362466004367 62401040001 RIPLEY CENTRAL SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 17.0 0.0 0.0                   9.0 8.0             9     *   17 17 0 0                   9 8         9       17
757952 NY Chautauqua   school 3626730 62601040000   SHERMAN 362673003650 62601040003 SHERMAN HIGH SCHOOL public Regular School No 3.0 07 12 2015   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
757990 NY Chautauqua   school 3630990 62901040000   WESTFIELD 363099004164 62901040002 WESTFIELD HIGH SCHOOL public Regular School No 3.0 09 12 2015   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
758047 NY Chemung   school 3610560 70600010000   ELMIRA 361056000817 70600010007 FASSETT ELEMENTARY SCHOOL public Regular School No 1.0 PK 02 2015   grade_2 64.0 31.0 8.0               27.0   71.0 59.0             115     11   130 64 31 8               27   71 59         115   11   130
758104 NY Chemung   school 3610560 70600010000   ELMIRA 361056000822 70600010014 PINE CITY SCHOOL public Regular School No 1.0 PK 02 2015   grade_2 116.0 4.0 2.0   1.0           6.0   73.0 56.0             68     16   129 116 4 2   1           6   73 56         68   16   129
758712 NY Chenango   school 3622100 81401040000   GRGETWN-SO OTSELIC 362210003132 81401040001 OTSELIC VALLEY CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 24.0 0.0 1.0   0.0               17.0 8.0             12     *   25 24 0 1   0               17 8         12       25
758731 NY Chenango   school 3622260 81501040000   OXFORD 362226003144 81501040001 OXFORD ACADEMY MIDDLE SCHOOL public Regular School No 2.0 05 08 2015   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
758750 NY Chenango   school 3622260 81501040000   OXFORD 362226003143 81501040002 OXFORD ACADEMY HIGH SCHOOL public Regular School No 3.0 09 12 2015   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
758769 NY Chenango   school 3622260 81501040000   OXFORD 362226003145 81501040003 OXFORD ACADEMY PRIMARY SCHOOL public Regular School No 1.0 PK 04 2015   grade_2 48.0 0.0 1.0   0.0               27.0 22.0             33     *   49 48 0 1   0               27 22         33       49
758883 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_2 28.0 1.0                 1.0   17.0 13.0             16     *   30 28 1                 1   17 13         16       30
758921 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_2 57.0 1.0 1.0   1.0               34.0 26.0             37     8   60 57 1 1   1               34 26         37   8   60
759035 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003020 90501040006 MOOERS ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 69.0   0.0                   36.0 33.0             45     10   69 69   0                   36 33         45   10   69
759301 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 59.0 0.0 0.0               0.0   33.0 26.0             32     5   59 59 0 0               0   33 26         32   5   59
759358 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No 3.0 07 12 2015   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
759377 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
759700 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2015   grade_2 50.0   1.0               0.0   22.0 29.0             27     *   51 50   1               0   22 29         27       51
759719 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
759738 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No 2.0 05 08 2015   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
759776 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_2 18.0   0.0               1.0   11.0 8.0             6     *   19 18   0               1   11 8         6       19
759966 NY Cortland   school 3614640 110701060000   HOMER 361464001218 110701060005 HARTNETT ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_2 13.0   0.0                   6.0 7.0             6     0   13 13   0                   6 7         6   0   13
760023 NY Cortland   school 3618450 110901040000   MARATHON 361845001660 110901040002 WILLIAM APPLEBY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 54.0 2.0 2.0                   27.0 31.0             35     11   58 54 2 2                   27 31         35   11   58
760042 NY Delaware   school 3609060 31301040000   DEPOSIT 360906000693 31301040002 DEPOSIT ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_2 39.0 1.0 1.0   0.0               22.0 19.0             27     *   41 39 1 1   0               22 19         27       41
760118 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 35.0 0.0 0.0               2.0   13.0 24.0             30     *   37 35 0 0               2   13 24         30       37
760251 NY Delaware   school 3625110 121502040000   ROXBURY 362511003473 121502040001 ROXBURY CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_2 27.0 0.0 1.0   0.0           0.0   12.0 16.0             16     8   28 27 0 1   0           0   12 16         16   8   28
760840 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No 1.0 03 05 2015   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
760878 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No 1.0 KG 02 2015   grade_2 51.0   6.0               7.0   34.0 30.0             19     6   64 51   6               7   34 30         19   6   64
760897 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004975 131301040004 STISSING MOUNTAIN MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   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
762854 NY Erie   school 3605850 140600010000   BUFFALO 360585000364 140600010074 PS 74 HAMLIN PARK ELEMENTARY SCHOOL public Regular School No 1 PK 8 2015   grade_2 3.0 42.0 2.0               2.0   24.0 25.0             44     10   49 3 42 2               2   24 25         44   10   49
763652 NY Erie   school 3601022 140600860961   HEALTH SCIENCES CHARTER SCHO 360102206239 140600860961 HEALTH SCIENCES CHARTER SCHOOL charter Regular School Yes 3 09 12 2015   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
763747 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723006246 140701060008 PINE HILL EDUCATION CENTER public Alternative Education School No 4 KG 12 2015   grade_2 1.0 1.0 0.0   0.0           1.0   3.0 0.0             *     *   3 1 1 0   0           1   3 0                 3
764165 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001062 141101060002 COLDEN ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   grade_2 35.0   0.0   1.0               22.0 14.0             9     *   36 35   0   1               22 14         9       36
764298 NY Erie   school 3615360 141301060000   IROQUOIS 361536001295 141301060003 MARILLA PRIMARY SCHOOL public Regular School No 1 KG 4 2015   grade_2 36.0 0.0 0.0   0.0           0.0   22.0 14.0             8     *   36 36 0 0   0           0   22 14         8       36
765096 NY Erie   school 3602430 142101040000   AKRON 360243000013 142101040002 AKRON HIGH SCHOOL public Regular School No 3 09 12 2015   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
765134 NY Erie   school 3620970 142201040000   NORTH COLLINS 362097002978 142201040001 NORTH COLLINS JUNIOR-SENIOR HS public Regular School No 3 07 12 2015   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
765875 NY Essex   school 3619830 150901040000   MORIAH 361983001815 150901040004 MORIAH JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3 07 12 2015   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
766065 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_2 14.0       0.0           1.0   13.0 2.0             11     *   15 14       0           1   13 2         11       15
766160 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003525 161201040001 ST REGIS MOHAWK SCHOOL public Regular School No 1 PK 5 2015   grade_2 3.0   0.0   52.0           0.0   25.0 30.0             49     7   55 3   0   52           0   25 30         49   7   55

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