Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_7", state = "NY" and year = 2018 sorted by low_income

View and edit SQL

year

  • 2018 · 4,722

grade

  • grade_7 · 4,722
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income ▼ free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2051056 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_7 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2102014 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2018   grade_7 0.0   0.0   0.0               0.0 0.0                   *   0 0   0   0               0 0                 0
2109899 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Special Education School No Middle 06 08 2018   grade_7 2.0                       0.0 2.0                   *   2 2                       0 2                 2
2117385 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2018   grade_7 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2126733 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Other PK 10 2018   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
2126809 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2018   grade_7 25.0 1.0 4.0         0.0     0.0   17.0 13.0     *             5   30 25 1 4         0     0   17 13             5   30
2126961 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801001044 580402060005 GOOSEHILL PRIMARY CENTER public Regular School No Elementary KG 01 2018   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     *             0   0 0   0         0     0   0 0             0   0
2129260 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2018   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
2129944 NY Suffolk   school 3624060 580903020000   QUOGUE 362406003319 580903020001 QUOGUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2130096 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2018   grade_7 0.0   0.0                   0.0 0.0                       0 0   0                   0 0                 0
2130267 NY Suffolk   school 3611100 581004020000   FISHERS ISLAND 361110000884 581004020001 FISHERS ISLAND SCHOOL public Regular School No Other PK 12 2018   grade_7 5.0 0.0 0.0               0.0   1.0 4.0                   0   5 5 0 0               0   1 4             0   5
2130400 NY Suffolk   school 3620520 581015080000   NEW SUFFOLK 362052001905 581015080001 NEW SUFFOLK SCHOOL public Regular School No Elementary PK 06 2018   grade_7 0.0   0.0                   0.0 0.0     *                 0 0   0                   0 0                 0
2137430 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003560 662001030001 EDGEWOOD SCHOOL public Regular School No Elementary KG 05 2018   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
2137449 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003561 662001030002 FOX MEADOW SCHOOL public Regular School No Elementary KG 05 2018   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
2137468 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003562 662001030003 GREENACRES SCHOOL public Regular School No Elementary KG 05 2018   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
2137487 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003563 662001030004 HEATHCOTE SCHOOL public Regular School No Elementary KG 05 2018   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
2137506 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003564 662001030005 QUAKER RIDGE SCHOOL public Regular School No Elementary KG 05 2018   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
2137525 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003566 662001030010 SCARSDALE SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   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
2137544 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 248.0 6.0 22.0         82.0     22.0   199.0 181.0     *             37   380 248 6 22         82     22   199 181             37   380
2052177 NY Bronx   school 3601131 320700861068   SOUTH BRONX EARLY COLLEGE AC 360113106555 320700861068 SOUTH BRONX EARLY COLLEGE ACADEMY CS charter Regular School Yes Middle 06 08 2018   grade_7 0.0 31.0 75.0   0.0     0.0         69.0 37.0     *       *     33   106 0 31 75   0     0         69 37             33   106
2052880 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506081 320800010424 HUNTS POINT SCHOOL (THE) public Regular School No Middle 06 08 2018   grade_7 0.0 28.0 68.0   0.0     1.0     1.0   59.0 39.0     27       *     35   98 0 28 68   0     1     1   59 39     27       35   98
2054020 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602737 320900010229 IS 229 ROLAND PATTERSON public Regular School No Middle 06 08 2018   grade_7   36.0 39.0   1.0     0.0         40.0 36.0     *       *     29   76   36 39   1     0         40 36             29   76
2054039 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 public Regular School No Middle 06 08 2018   grade_7 0.0 34.0 109.0         1.0     0.0   65.0 79.0     *       *     *   144 0 34 109         1     0   65 79                 144
2054115 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603764 320900010303 IS 303 LEADERSHIP & COMM SERVICE public Regular School No Middle 06 08 2018   grade_7 0.0 25.0 70.0   2.0     1.0     1.0   49.0 50.0     17       *     *   99 0 25 70   2     1     1   49 50     17           99
2055559 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704310 321000010206 IS 206 ANN MERSEREAU public Regular School No Middle 06 08 2018   grade_7 1.0 6.0 51.0   2.0     2.0         36.0 26.0     23       *     *   62 1 6 51   2     2         36 26     23           62
2056053 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703812 321000010391 ANGELO PATRI MIDDLE SCHOOL (THE) public Regular School No Middle 06 08 2018   grade_7 1.0 33.0 120.0   0.0     5.0         98.0 61.0     63       *     50   159 1 33 120   0     5         98 61     63       50   159
2056680 NY Bronx   school 3600968 321000860914   BRONX COMMUNITY CHARTER SCHO 360096806074 321000860914 BRONX COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_7 2.0 14.0 30.0         2.0     0.0   26.0 22.0     6       *     16   48 2 14 30         2     0   26 22     6       16   48
2057383 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806399 321100010355 BRONX ALLIANCE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 1.0 62.0 31.0   0.0     3.0     0.0   48.0 49.0     10       *     *   97 1 62 31   0     3     0   48 49     10           97
2057440 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2018   grade_7 1.0 51.0 33.0   1.0               49.0 37.0     0       *     28   86 1 51 33   1               49 37     0       28   86
2057459 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806129 321100010468 PELHAM ACAD-ACADEMICS AND COMMUNITY public Regular School No Middle 06 08 2018   grade_7 22.0 12.0 57.0   0.0     10.0         50.0 51.0     *       *     19   101 22 12 57   0     10         50 51             19   101
2057535 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806259 321100010529 ONE WORLD MS AT EDENWALD public Regular School No Middle 06 08 2018   grade_7 3.0 58.0 40.0   7.0     3.0         63.0 48.0     6       *     33   111 3 58 40   7     3         63 48     6       33   111
2058010 NY Bronx   school 3600955 321100860917   ICAHN CHARTER SCHOOL 3 360095506027 321100860917 ICAHN CHARTER SCHOOL 3 charter Regular School Yes Elementary KG 08 2018   grade_7 0.0 20.0 10.0   0.0     0.0     0.0   16.0 14.0     *       *     6   30 0 20 10   0     0     0   16 14             6   30
2060176 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 17.0 1.0 0.0               1.0   10.0 9.0             *     *   19 17 1 0               1   10 9                 19
2060423 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003082 42400010013 OLEAN SENIOR HIGH SCHOOL public Regular School No High 08 12 2018   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 1 0 0   0     0     0   1 0                 1
2060442 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 04 07 2018   grade_7 129.0 15.0 3.0   1.0     3.0     10.0   85.0 76.0             *     23   161 129 15 3   1     3     10   85 76             23   161
2060594 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No Other KG 12 2018   grade_7 3.0 1.0 1.0   0.0     0.0     1.0   4.0 2.0             *     *   6 3 1 1   0     0     1   4 2                 6
2060613 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2018   grade_7 4.0 0.0 1.0   2.0     0.0     0.0   7.0 0.0     *       *     7   7 4 0 1   2     0     0   7 0             7   7
2061620 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_7 61.0 0.0 4.0   11.0           5.0   39.0 42.0     *       *     *   81 61 0 4   11           5   39 42                 81
2062247 NY Chemung   school 3610560 70600010000   ELMIRA 361056000811 70600010019 BROADWAY ACADEMY public Regular School No Middle 07 07 2018   grade_7 335.0 69.0 17.0         2.0     30.0   226.0 227.0             *     *   453 335 69 17         2     30   226 227                 453
2063463 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_7 1.0 1.0 0.0                   2.0               *     *   2 1 1 0                   2                   2
2064204 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 7.0 0.0 0.0               0.0   1.0 6.0             *     *   7 7 0 0               0   1 6                 7
2064337 NY Delaware   school 3613560 120906040000   HANCOCK 361356001110 120906040002 HANCOCK JUNIOR-SENIOR HS public Regular School No High 05 12 2018   grade_7 13.0 1.0 1.0   0.0               9.0 6.0             *     *   15 13 1 1   0               9 6                 15
2064888 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039005848 131101040007 EUGENE BROOKS MIDDLE SCHOOL public Regular School No Middle 04 08 2018   grade_7 49.0 2.0 2.0         1.0     3.0   32.0 25.0     0       *     12   57 49 2 2         1     3   32 25     0       12   57
2064945 NY Dutchess   school 3622530 131201040000   PAWLING 362253003255 131201040003 PAWLING MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_7 82.0 1.0 14.0         2.0     1.0   47.0 53.0     *       *     17   100 82 1 14         2     1   47 53             17   100
2066712 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2018   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
2067415 NY Erie   school 3605850 140600010000   BUFFALO 360585005857 140600010132 MATH SCIENCE TECH PREP SCHOOL-SENECA public Regular School No High 05 12 2018   grade_7 2.0 30.0 1.0   0.0     2.0     1.0   17.0 19.0     *       *     *   36 2 30 1   0     2     1   17 19                 36
2068783 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000493 141501060005 VERONICA E CONNOR MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 183.0 3.0 9.0   0.0     5.0     8.0   107.0 101.0     *       *     35   208 183 3 9   0     5     8   107 101             35   208
2068897 NY Erie   school 3613350 141601060000   HAMBURG 361335001098 141601060006 HAMBURG MIDDLE SCHOOL public Regular School No Middle 06 09 2018   grade_7 229.0 1.0 5.0   2.0     3.0     9.0   126.0 123.0             *     34   249 229 1 5   2     3     9   126 123             34   249
2069999 NY Essex   school 3616140 150601040000   KEENE 361614001394 150601040001 KEENE CENTRAL SCHOOL public Regular School No Other KG 12 2018   grade_7 9.0 0.0 0.0   0.0     0.0     1.0   3.0 7.0             *     0   10 9 0 0   0     0     1   3 7             0   10
2070075 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 6.0   0.0         0.0         1.0 5.0             *     0   6 6   0         0         1 5             0   6
2070094 NY Essex   school 3616500 151102040000   LAKE PLACID 361650001460 151102040001 LAKE PLACID JUNIOR-SENIOR HIGH SCH public Regular School No High 06 12 2018   grade_7 45.0 0.0 0.0         0.0     0.0   21.0 24.0             *     *   45 45 0 0         0     0   21 24                 45
2071101 NY Genesee   school 3606090 180701040000   BYRON BERGEN 360609000394 180701040001 BYRON-BERGEN JR/SR HIGH SCHOOL public Regular School No High 07 12 2018   grade_7 58.0 2.0 4.0         2.0     0.0   26.0 40.0             *     7   66 58 2 4         2     0   26 40             7   66
2071671 NY Hamilton   school 3615330 200501080000   INLET 361533001291 200501080001 INLET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_7 0.0   0.0         0.0         0.0 0.0             *     *   0 0   0         0         0 0                 0
2071690 NY Hamilton   school 3616530 200601040000   LAKE PLEASANT 361653001461 200601040001 LAKE PLEASANT SCHOOL public Regular School No Other PK 09 2018   grade_7 9.0 0.0 1.0               0.0   4.0 6.0             *     *   10 9 0 1               0   4 6                 10
2071709 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 7.0                       4.0 3.0             *     *   7 7                       4 3                 7
2071747 NY Herkimer   school 3630600 210302040000   WEST CANADA VALLEY 363060004109 210302040003 WEST CANADA VALLEY JUNIOR-SENIOR HS public Regular School No High 07 12 2018   grade_7 48.0 0.0 1.0               2.0   24.0 27.0     *       *     10   51 48 0 1               2   24 27             10   51
2071823 NY Herkimer   school 3611400 210402060000   FRANKFORT-SCHUYLER 361140005755 210402060005 FRANKFORT-SCHUYLER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 71.0 0.0 0.0         0.0     0.0   33.0 38.0     *       *     10   71 71 0 0         0     0   33 38             10   71
2072032 NY Herkimer   school 3622200 211701040000   VAN HORNSVILLE 362220003142 211701040001 OWEN D YOUNG CENTRAL SCHOOL public Regular School No Other KG 12 2018   grade_7 10.0 0.0 0.0               0.0   8.0 2.0     *       *     *   10 10 0 0               0   8 2                 10
2072051 NY Herkimer   school 3628800 211901020000   TOWN OF WEBB 362880003908 211901020001 TOWN OF WEBB SCHOOL public Regular School No Other KG 12 2018   grade_7 17.0 1.0 0.0   0.0     1.0         10.0 9.0             *     *   19 17 1 0   0     1         10 9                 19
2072260 NY Jefferson   school 3602340 220101040000   SOUTH JEFFERSON 360234005605 220101040006 CLARKE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 118.0 0.0 2.0   0.0     1.0     1.0   64.0 58.0     *       *     *   122 118 0 2   0     1     1   64 58                 122
2073191 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102781 331300010265 DR SUSAN S MCKINNEY SEC SCH-ARTS public Regular School No High 06 12 2018   grade_7 1.0 21.0 6.0   2.0     2.0     0.0   17.0 15.0     *       *     14   32 1 21 6   2     2     0   17 15             14   32
2073210 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009104483 331300010266 MS 266 PARK PLACE COMMUNITY MS public Regular School No Middle 06 08 2018   grade_7 1.0 30.0 4.0   0.0     3.0     1.0   24.0 15.0     *       *     *   39 1 30 4   0     3     1   24 15                 39
2073381 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009106205 331300010691 FORT GREEN PREPARATORY ACADEMY public Regular School No Middle 06 08 2018   grade_7 0.0 36.0 19.0   1.0     2.0     1.0   31.0 28.0     *       *     *   59 0 36 19   1     2     1   31 28                 59
2074141 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902467 331400010126 JOHN ERICSSON MIDDLE SCHOOL 126 public Regular School No Middle 06 08 2018   grade_7 13.0 20.0 74.0   0.0     0.0         62.0 45.0     11       *     *   107 13 20 74   0     0         62 45     11           107
2074388 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905702 331400010582 MS 582 public Regular School No Middle 06 08 2018   grade_7 1.0 22.0 51.0   0.0     2.0     1.0   42.0 35.0     10       *     *   77 1 22 51   0     2     1   42 35     10           77
2075737 NY Kings   school 3600949 331500860927   PAVE ACADEMY CHARTER SCHOOL 360094906082 331500860927 PAVE ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_7 2.0 22.0 23.0   1.0     0.0         21.0 27.0     *       *     13   48 2 22 23   1     0         21 27             13   48
2076060 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009404053 331600010267 MS 267 MATH, SCIENCE & TECH public Regular School No Middle 06 08 2018   grade_7 0.0 63.0 17.0   6.0     1.0     0.0   41.0 46.0     *       *     32   87 0 63 17   6     1     0   41 46             32   87
2076421 NY Kings   school 3601048 331600860975   EMBER CHARTER SCHOOL 360104806255 331600860975 EMBER CHARTER SCHOOL charter Regular School Yes Elementary KG 07 2018   grade_7 1.0 24.0 5.0         1.0     0.0   15.0 16.0     0       *     *   31 1 24 5         1     0   15 16     0           31
2076877 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505820 331700010354 SCHOOL OF INTEGRATED LRNING (THE) public Regular School No Middle 06 08 2018   grade_7   45.0 13.0   2.0     1.0         28.0 33.0     *       *     *   61   45 13   2     1         28 33                 61
2077200 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505709 331700011531 SCHOOL FOR HUMAN RIGHTS (THE) public Regular School No High 07 12 2018   grade_7 0.0 21.0 1.0   0.0     0.0     0.0   14.0 8.0     0       *     *   22 0 21 1   0     0     0   14 8     0           22
2077485 NY Kings   school 3600994 331700860950   EXPLORE EMPOWER CHARTER 360099406151 331700860950 EXPLORE EMPOWER CHARTER SCH charter Regular School Yes Elementary KG 08 2018   grade_7 0.0 51.0 2.0   1.0     0.0     0.0   30.0 24.0     *       *     18   54 0 51 2   1     0     0   30 24             18   54
2077922 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009606155 331800010366 SCIENCE & MEDICINE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 3.0 104.0 8.0   2.0     0.0         70.0 47.0     *       *     30   117 3 104 8   2     0         70 47             30   117
2078948 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006419 331900010662 LIBERTY AVENUE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 2.0 26.0 118.0   3.0     4.0         87.0 66.0     *       *     40   153 2 26 118   3     4         87 66             40   153
2079024 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006483 331900010760 HIGHLAND PARK COMMUNITY SCHOOL public Regular School No Middle 06 08 2018   grade_7 2.0 19.0 72.0   2.0     3.0     1.0   58.0 41.0     12       *     *   99 2 19 72   2     3     1   58 41     12           99
2081532 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302755 332200010240 ANDRIES HUDDE SCHOOL public Regular School No Middle 06 08 2018   grade_7 16.0 133.0 41.0   2.0     37.0     1.0   119.0 111.0     32       *     43   230 16 133 41   2     37     1   119 111     32       43   230
2083888 NY Livingston   school 3621450 241101040000   DALTON-NUNDA 362145003293 241101040001 DALTON-NUNDA INTERMEDIATE SCHOOL public Regular School No Middle 04 07 2018   grade_7 0.0   1.0               0.0   1.0 0.0     *       *     *   1 0   1               0   1 0                 1
2084762 NY Monroe   school 3612630 260501060000   GREECE 361263001039 260501060008 OLYMPIA HIGH SCHOOL public Regular School No High 06 12 2018   grade_7 66.0 27.0 29.0   0.0     4.0     6.0   56.0 76.0     6       *     22   132 66 27 29   0     4     6   56 76     6       22   132
2085180 NY Monroe   school 3615390 260803060000   WEST IRONDEQUOIT 361539001301 260803060002 DAKE JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_7 184.0 33.0 26.0         11.0     14.0   125.0 143.0     *       *     *   268 184 33 26         11     14   125 143                 268
2085598 NY Monroe   school 3614460 261101060000   HILTON 361446001200 261101060005 MERTON WILLIAMS MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_7 292.0 9.0 19.0   1.0     6.0     8.0   164.0 171.0     *       *     36   335 292 9 19   1     6     8   164 171             36   335
2086054 NY Monroe   school 3623160 261401060000   PITTSFORD 362316003243 261401060009 THORNELL ROAD SCHOOL public Regular School No Elementary KG 05 2018   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
2088372 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413005610 280201030008 MARSHALL SCHOOL public Regular School No Prekindergarten PK PK 2018   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
2089018 NY Nassau   school 3617160 280205030000   LEVITTOWN 361716001532 280205030010 WISDOM LANE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 151.0 1.0 51.0   0.0     34.0     6.0   127.0 116.0     *       *     24   243 151 1 51   0     34     6   127 116             24   243
2089151 NY Nassau   school 3626400 280206030000   SEAFORD 362640003618 280206030005 SEAFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 157.0 2.0 11.0         2.0     1.0   85.0 88.0     0       *     27   173 157 2 11         2     1   85 88     0       27   173
2089759 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004528 280211030009 SCHOOL 9M-OCEANSIDE MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_7 290.0 11.0 63.0         10.0     13.0   217.0 170.0     11       *     54   387 290 11 63         10     13   217 170     11       54   387
2090044 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004230 280214030006 WOODMERE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 164.0 15.0 35.0   1.0     24.0     6.0   137.0 108.0     *       *     28   245 164 15 35   1     24     6   137 108             28   245
2090348 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK SCHOOL public Regular School No Elementary KG 01 2018   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
2091545 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001722 280253070002 GRAND AVENUE MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_7 359.0 15.0 46.0   2.0     29.0     8.0   229.0 230.0     *       *     73   459 359 15 46   2     29     8   229 230             73   459
2092286 NY Nassau   school 3618270 280406030000   MANHASSET 361827000112 280406030005 MANHASSET MIDDLE SCHOOL public Regular School No Middle 07 08 2018   grade_7 167.0 7.0 23.0         50.0     1.0   135.0 113.0     *       *     33   248 167 7 23         50     1   135 113             33   248
2092666 NY Nassau   school 3619500 280410030000   MINEOLA 361950001781 280410030007 MINEOLA MIDDLE SCHOOL public Regular School No Middle 05 07 2018   grade_7 116.0 6.0 48.0         32.0     4.0   98.0 108.0     15       *     22   206 116 6 48         32     4   98 108     15       22   206
2093730 NY Nassau   school 3604740 280521030000   BETHPAGE 360474000220 280521030008 JOHN F KENNEDY MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 162.0   34.0         16.0     2.0   115.0 99.0     *       *     35   214 162   34         16     2   115 99             35   214
2093825 NY Nassau   school 3610980 280522030000   FARMINGDALE 361098000878 280522030008 HOWITT SCHOOL public Regular School No Middle 06 08 2018   grade_7 281.0 31.0 87.0   1.0     27.0     7.0   244.0 190.0     22       *     84   434 281 31 87   1     27     7   244 190     22       84   434
2094034 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 01 12 2018   grade_7 0.0 0.0 0.0   1.0     1.0     0.0   0.0 2.0     0       *     *   2 0 0 0   1     1     0   0 2     0           2
2094072 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504596 307500011094 PS 94 public Special Education School No Elementary KG 08 2018   grade_7 0.0 1.0 0.0   0.0     1.0     0.0   2.0 0.0     0       *     *   2 0 1 0   0     1     0   2 0     0           2
2094091 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504780 307500011138 PS 138 public Special Education School No Other KG 12 2018   grade_7 0.0 2.0 2.0   0.0     0.0     0.0   4.0 0.0     0       *     *   4 0 2 2   0     0     0   4 0     0           4
2094129 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502733 307500011226 PS 226 public Special Education School No Other PK 12 2018   grade_7 0.0 0.0 2.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 0 0 2   0     0     0   2 0     0           2
2094205 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504560 307500012010 PS 10 public Special Education School No Elementary PK 08 2018   grade_7 1.0 1.0 2.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 1 1 2   0     0     0   4 0                 4
2094319 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504469 307500012188 PS 188 public Special Education School No Other PK 12 2018   grade_7 0.0 2.0 0.0   0.0     0.0     0.0   1.0 1.0     0       *     *   2 0 2 0   0     0     0   1 1     0           2
2094490 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504605 307500013053 PS 53 public Special Education School No Other KG 12 2018   grade_7 0.0 1.0 2.0   0.0     1.0     0.0   2.0 2.0     *       *     *   4 0 1 2   0     1     0   2 2                 4
2094509 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502311 307500013077 PS 77 public Special Education School No Other KG 12 2018   grade_7 0.0 2.0 1.0   0.0     0.0         3.0 0.0     0       *     *   3 0 2 1   0     0         3 0     0           3
2094547 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504477 307500013141 PS 141 public Special Education School No Other PK 09 2018   grade_7 0.0 0.0 1.0   0.0     0.0         1.0 0.0     0       *     *   1 0 0 1   0     0         1 0     0           1

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