Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_7" and state = "NY" sorted by rowid descending

View and edit SQL

year

grade

  • grade_7 · 33,045
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
2226844 NY Westchester   school 3625290 661901030000   RYE NECK 362529003494 661901030001 F E BELLOWS ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   grade_7 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
2226825 NY Westchester   school 3625260 661800010000   RYE 362526003493 661800010005 RYE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 232.0 4.0 14.0   0.0     18.0     3.0   157.0 114.0     *       8     *   271 232 4 14   0     18     3   157 114         8       271
2226806 NY Westchester   school 3625260 661800010000   RYE 362526003492 661800010004 RYE HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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   0   0   0
2226787 NY Westchester   school 3625260 661800010000   RYE 362526003491 661800010003 OSBORN SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2226768 NY Westchester   school 3625260 661800010000   RYE 362526003490 661800010002 MILTON SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2226749 NY Westchester   school 3625260 661800010000   RYE 362526003489 661800010001 MIDLAND SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2226730 NY Westchester   school 3622680 661601030000   PELHAM 362268003187 661601030006 PELHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 160.0 23.0 38.0         13.0     15.0   137.0 112.0     *       29     29   249 160 23 38         13     15   137 112         29   29   249
2226711 NY Westchester   school 3622680 661601030000   PELHAM 362268003188 661601030005 PELHAM MEMORIAL HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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   0   0   0
2226692 NY Westchester   school 3622680 661601030000   PELHAM 362268003190 661601030004 SIWANOY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2226673 NY Westchester   school 3622680 661601030000   PELHAM 362268003189 661601030003 PROSPECT HILL SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2226654 NY Westchester   school 3622680 661601030000   PELHAM 362268003186 661601030002 HUTCHINSON SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2226635 NY Westchester   school 3622680 661601030000   PELHAM 362268003185 661601030001 COLONIAL SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2226616 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265004366 661500010010 PEEKSKILL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 13.0 47.0 171.0   1.0     0.0     11.0   124.0 119.0     56       208     49   243 13 47 171   1     0     11   124 119     56   208   49   243
2226597 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003181 661500010009 PEEKSKILL HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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
2226578 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003184 661500010004 WOODSIDE SCHOOL public Regular School No Elementary KG 02 2019   grade_7 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
2226559 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No Prekindergarten PK PK 2019   grade_7 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
2226540 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2019   grade_7 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
2226521 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003179 661500010001 HILLCREST SCHOOL public Regular School No Elementary 03 05 2019   grade_7 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
2226502 NY Westchester   school 3605340 661402020000   BRIARCLIFF MANOR 360534002762 661402020004 BRIARCLIFF MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 89.0 0.0 12.0         16.0     5.0   69.0 53.0             *     8   122 89 0 12         16     5   69 53             8   122
2226483 NY Westchester   school 3605340 661402020000   BRIARCLIFF MANOR 360534000268 661402020002 BRIARCLIFF HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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
2226464 NY Westchester   school 3605340 661402020000   BRIARCLIFF MANOR 360534000270 661402020001 TODD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2226445 NY Westchester   school 3622020 661401030000   OSSINING 362202003121 661401030007 OSSINING HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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   0   0   0
2226426 NY Westchester   school 3622020 661401030000   OSSINING 362202003118 661401030006 ANNE M DORNER MIDDLE SCHOOL public Regular School No Middle 06 09 2019   grade_7 71.0 33.0 226.0         14.0     11.0   187.0 168.0     24       221     45   355 71 33 226         14     11   187 168     24   221   45   355
2226407 NY Westchester   school 3622020 661401030000   OSSINING 362202004852 661401030005 ROOSEVELT SCHOOL public Regular School No Middle 04 06 2019   grade_7 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
2226388 NY Westchester   school 3622020 661401030000   OSSINING 362202003122 661401030003 PARK SCHOOL public Regular School No Elementary PK 01 2019   grade_7 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
2226369 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No Elementary 03 05 2019   grade_7 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
2226350 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2019   grade_7 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   0   0   0
2226331 NY Westchester   school 3621180 661301040000   NORTH SALEM 362118002991 661301040003 NORTH SALEM MIDDLE/ HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 73.0 2.0 14.0         3.0     2.0   40.0 54.0     *       17     18   94 73 2 14         3     2   40 54         17   18   94
2226312 NY Westchester   school 3621180 661301040000   NORTH SALEM 362118002992 661301040002 PEQUENAKONCK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2226293 NY Westchester   school 3606060 661201060000   BYRAM HILLS 360606000391 661201060007 H C CRITTENDEN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 139.0 0.0 12.0   0.0     12.0     4.0   85.0 82.0     *       *     15   167 139 0 12   0     12     4   85 82             15   167
2226274 NY Westchester   school 3606060 661201060000   BYRAM HILLS 360606000389 661201060006 BYRAM HILLS HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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
2226255 NY Westchester   school 3606060 661201060000   BYRAM HILLS 360606000392 661201060005 WAMPUS SCHOOL public Regular School No Elementary 03 05 2019   grade_7 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   0
2226236 NY Westchester   school 3606060 661201060000   BYRAM HILLS 360606000390 661201060002 COMAN HILL SCHOOL public Regular School No Elementary KG 02 2019   grade_7 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
2226217 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001900 661100010016 NEW ROCHELLE HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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   0   0   0
2226198 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001897 661100010014 ISAAC E YOUNG MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 50.0 67.0 250.0         18.0         188.0 197.0     64       292     56   385 50 67 250         18         188 197     64   292   56   385
2226179 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001892 661100010013 ALBERT LEONARD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 155.0 114.0 90.0   2.0     22.0     4.0   207.0 180.0     14       130     52   387 155 114 90   2     22     4   207 180     14   130   52   387
2226160 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001894 661100010011 DANIEL WEBSTER ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2226141 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004400 661100010009 WILLIAM B WARD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2226122 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004399 661100010008 TRINITY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2226103 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001898 661100010004 JEFFERSON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2226084 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001895 661100010003 GEORGE M DAVIS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2226065 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001893 661100010002 COLUMBUS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2226046 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001896 661100010001 HENRY BARNARD SCHOOL public Regular School No Elementary PK 02 2019   grade_7 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   0   0   0
2226027 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699005571 661004060006 SEVEN BRIDGES MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 123.0 1.0 8.0         22.0     5.0   82.0 77.0     *       7     14   159 123 1 8         22     5   82 77         7   14   159
2226008 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000491 661004060005 WESTORCHARD SCHOOL public Regular School No Elementary KG 04 2019   grade_7 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
2225989 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000488 661004060004 HORACE GREELEY HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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
2225970 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000490 661004060003 ROBERT E BELL SCHOOL public Regular School No Middle 05 08 2019   grade_7 105.0 2.0 18.0         15.0     6.0   69.0 77.0     *       12     19   146 105 2 18         15     6   69 77         12   19   146
2225951 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000489 661004060002 ROARING BROOK SCHOOL public Regular School No Elementary KG 04 2019   grade_7 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
2225932 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000487 661004060001 DOUGLAS G GRAFFLIN SCHOOL public Regular School No Elementary KG 04 2019   grade_7 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
2225913 NY Westchester   school 3601051 660900861000   AMANI PUBLIC CHARTER SCHOOL 360105106291 660900861000 AMANI PUBLIC CHARTER SCHOOL charter Regular School Yes Middle 05 08 2019   grade_7 1.0 79.0 9.0   0.0     0.0     0.0   54.0 35.0     0       68     *   89 1 79 9   0     0     0   54 35     0   68       89
2225894 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010006668 660900010027 MOUNT VERNON STEAM ACADEMY public Regular School No Secondary 08 10 2019   grade_7 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   0   0   0
2225875 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010005949 660900010026 NELLIE THORNTON -PERFORMING ARTS public Regular School No High 06 12 2019   grade_7 0.0 57.0 17.0   0.0     0.0     0.0   18.0 56.0     *       53     7   74 0 57 17   0     0     0   18 56         53   7   74
2225856 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010000365 660900010025 NELSON R MANDELA/DR HOSEA ZOLLICOFF public Alternative School No High 09 12 2019   grade_7 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
2225837 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010004345 660900010023 BENJAMIN TURNER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 8.0 122.0 29.0               1.0   94.0 66.0     16       142     69   160 8 122 29               1   94 66     16   142   69   160
2225818 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001845 660900010014 GRIMES SCHOOL public Regular School No Elementary KG 07 2019   grade_7 1.0 23.0 6.0         0.0     0.0   12.0 18.0     5       22     *   30 1 23 6         0     0   12 18     5   22       30
2225799 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001839 660900010013 MT VERNON HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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   0   0   0
2225780 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001844 660900010011 TRAPHAGEN SCHOOL public Regular School No Elementary PK 06 2019   grade_7 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   0   0   0
2225761 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001833 660900010010 GRAHAM SCHOOL public Regular School No Elementary PK 08 2019   grade_7 0.0 23.0 2.0   0.0     1.0     0.0   10.0 16.0     *       19     *   26 0 23 2   0     1     0   10 16         19       26
2225742 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001842 660900010009 PENNINGTON SCHOOL public Regular School No Elementary PK 08 2019   grade_7 5.0 36.0 4.0   0.0     1.0     1.0   27.0 20.0     0       29     5   47 5 36 4   0     1     1   27 20     0   29   5   47
2225723 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001841 660900010008 CECIL H PARKER SCHOOL public Regular School No Elementary PK 07 2019   grade_7 0.0 16.0 3.0   0.0     0.0     0.0   11.0 8.0     *       18     *   19 0 16 3   0     0     0   11 8         18       19
2225704 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001838 660900010007 REBECCA TURNER ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 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
2225685 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001837 660900010006 LINCOLN SCHOOL public Regular School No Elementary KG 07 2019   grade_7 8.0 38.0 33.0   0.0     0.0     0.0   43.0 36.0     *       70     *   79 8 38 33   0     0     0   43 36         70       79
2225666 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001836 660900010005 HOLMES SCHOOL public Regular School No Elementary PK 07 2019   grade_7 1.0 31.0 6.0         0.0     0.0   22.0 16.0     *       32     *   38 1 31 6         0     0   22 16         32       38
2225647 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001835 660900010004 HAMILTON SCHOOL public Regular School No Elementary KG 06 2019   grade_7 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
2225628 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001843 660900010002 EDWARD WILLIAMS SCHOOL public Regular School No Elementary PK 06 2019   grade_7 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
2225609 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001832 660900010001 COLUMBUS SCHOOL AT THE FRANKO BLDG public Regular School No Elementary PK 07 2019   grade_7 5.0 25.0 31.0         2.0     1.0   31.0 33.0     *       58     5   64 5 25 31         2     1   31 33         58   5   64
2225590 NY Westchester   school 3623310 660809030000   PLEASANTVILLE 362331004745 660809030004 PLEASANTVILLE MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 105.0 2.0 20.0         7.0     7.0   74.0 67.0     *       19     26   141 105 2 20         7     7   74 67         19   26   141
2225571 NY Westchester   school 3623310 660809030000   PLEASANTVILLE 362331003265 660809030003 PLEASANTVILLE HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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   0   0   0
2225552 NY Westchester   school 3623310 660809030000   PLEASANTVILLE 362331003264 660809030002 BEDFORD ROAD SCHOOL public Regular School No Elementary KG 04 2019   grade_7 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   0   0   0
2225533 NY Westchester   school 3620170 660806020000   MT PLSNT-BLYTHEDLE 362017001851 660806020001 BLYTHEDALE SCHOOL public Special Education School No Other PK 12 2019   grade_7 0.0 1.0 3.0         0.0     0.0   3.0 1.0             *     *   4 0 1 3         0     0   3 1                 4
2225514 NY Westchester   school 3629400 660805030000   VALHALLA 362940001521 660805030005 VALHALLA MIDDLE SCHOOL public Regular School No Middle 06 09 2019   grade_7 60.0 12.0 26.0   0.0     5.0     3.0   56.0 50.0     *       13     *   106 60 12 26   0     5     3   56 50         13       106
2225495 NY Westchester   school 3629400 660805030000   VALHALLA 362940004537 660805030004 VALHALLA HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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   0   0   0
2225476 NY Westchester   school 3629400 660805030000   VALHALLA 362940004536 660805030003 VIRGINIA ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2019   grade_7 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   0   0   0
2225457 NY Westchester   school 3629400 660805030000   VALHALLA 362940004572 660805030001 KENSICO SCHOOL public Regular School No Elementary 03 05 2019   grade_7 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   0   0   0
2225438 NY Westchester   school 3608470 660804020000   MT PLEASANT-COTTAG 360847000653 660804020003 EDENWALD SCHOOL public Special Education School No High 06 12 2019   grade_7 0.0 0.0 2.0                   2.0 0.0     *       *     *   2 0 0 2                   2 0                 2
2225419 NY Westchester   school 3608470 660804020000   MT PLEASANT-COTTAG 360847000652 660804020002 MT PLEASANT-COTTAGE SCHOOL public Special Education School No Other KG 12 2019   grade_7 1.0 6.0 3.0         0.0     1.0   4.0 7.0     *       11     6   11 1 6 3         0     1   4 7         11   6   11
2225400 NY Westchester   school 3614070 660803020000   HAWTHORNE KNOLLS 361407001519 660803020004 GELLER HOUSE SCHOOL public Special Education School No Other 03 11 2019   grade_7   2.0 1.0                   1.0 2.0             *     *   3   2 1                   1 2                 3
2225381 NY Westchester   school 3614070 660803020000   HAWTHORNE KNOLLS 361407001517 660803020003 LINDEN HILL SCHOOL public Special Education School No High 05 12 2019   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
2225362 NY Westchester   school 3614070 660803020000   HAWTHORNE KNOLLS 361407001515 660803020002 LITTLE SCHOOL public Special Education School No Elementary KG 08 2019   grade_7 2.0 7.0 8.0               1.0   14.0 4.0             *     18   18 2 7 8               1   14 4             18   18
2225343 NY Westchester   school 3614070 660803020000   HAWTHORNE KNOLLS 361407001149 660803020001 HAWTHORNE CEDAR KNOLLS SR/JR HS public Special Education School No Other 01 12 2019   grade_7 1.0 1.0 2.0               0.0   1.0 3.0     *       *     *   4 1 1 2               0   1 3                 4
2225324 NY Westchester   school 3623340 660802040000   POCANTICO HILLS 362334003267 660802040001 POCANTICO HILLS CENTRAL SCHOOL public Regular School No Elementary PK 08 2019   grade_7 10.0 3.0 5.0   0.0     6.0     0.0   13.0 11.0     0       *     *   24 10 3 5   0     6     0   13 11     0           24
2225305 NY Westchester   school 3620160 660801060000   MT PLEASANT CENT 362016001850 660801060007 WESTLAKE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 101.0 1.0 16.0         7.0     1.0   70.0 56.0     *       9     20   126 101 1 16         7     1   70 56         9   20   126
2225286 NY Westchester   school 3620160 660801060000   MT PLEASANT CENT 362016001849 660801060006 WESTLAKE HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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
2225267 NY Westchester   school 3620160 660801060000   MT PLEASANT CENT 362016001846 660801060005 COLUMBUS ELEMENTARY SCHOOL public Regular School No Elementary 03 07 2019   grade_7 0.0 0.0 0.0         1.0     0.0   1.0 0.0     0       0     *   1 0 0 0         1     0   1 0     0   0       1
2225248 NY Westchester   school 3620160 660801060000   MT PLEASANT CENT 362016001847 660801060003 HAWTHORNE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2019   grade_7 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
2225229 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001648 660701030006 MAMARONECK HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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   0   0   0
2225210 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001646 660701030005 HOMMOCKS SCHOOL public Regular School No Middle 06 08 2019   grade_7 301.0 11.0 84.0   1.0     11.0     21.0   219.0 210.0     15       70     58   429 301 11 84   1     11     21   219 210     15   70   58   429
2225191 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001649 660701030004 MURRAY AVENUE SCHOOL public Regular School No Elementary KG 07 2019   grade_7 1.0 0.0 0.0         0.0     0.0   1.0 0.0     0       0     *   1 1 0 0         0     0   1 0     0   0       1
2225172 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001647 660701030003 MAMARONECK AVENUE SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2225153 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001645 660701030002 CHATSWORTH AVENUE SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2225134 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001644 660701030001 CENTRAL SCHOOL public Regular School No Elementary PK 05 2019   grade_7 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
2225115 NY Westchester   school 3613740 660501060000   HARRISON 361374001123 660501060009 LOUIS M KLEIN MIDDLE SCHOOL public Regular School No Middle 06 11 2019   grade_7 203.0 7.0 45.0   1.0     32.0     6.0   142.0 152.0     22       60     40   294 203 7 45   1     32     6   142 152     22   60   40   294
2225096 NY Westchester   school 3613740 660501060000   HARRISON 361374001126 660501060008 SAMUEL J PRESTON SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2225077 NY Westchester   school 3613740 660501060000   HARRISON 361374001125 660501060005 PURCHASE SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2225058 NY Westchester   school 3613740 660501060000   HARRISON 361374001122 660501060004 HARRISON HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 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
2225039 NY Westchester   school 3613740 660501060000   HARRISON 361374001124 660501060003 PARSONS MEMORIAL SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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
2225020 NY Westchester   school 3613740 660501060000   HARRISON 361374001121 660501060002 HARRISON AVENUE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 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   0   0   0
2225001 NY Westchester   school 3627980 660412020000   GREENBRG-NO CASTLE 362798006356 660412020004 KAPLAN CAREER ACADEMY public Special Education School No High 07 12 2019   grade_7 3.0 2.0 2.0   0.0     0.0     0.0   5.0 2.0             *     7   7 3 2 2   0     0     0   5 2             7   7
2224982 NY Westchester   school 3627980 660412020000   GREENBRG-NO CASTLE 362798005843 660412020003 CLARK ACADEMY public Special Education School No High 07 12 2019   grade_7 1.0 0.0 0.0         0.0     0.0   1.0 0.0             0     *   1 1 0 0         0     0   1 0         0       1
2224963 NY Westchester   school 3627980 660412020000   GREENBRG-NO CASTLE 362798004904 660412020002 REACH ACADEMY (THE) public Special Education School No High 07 12 2019   grade_7 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0

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