Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 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
759382 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
987036 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   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
1043675 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_7 54.0 1.0 0.0         1.0     0.0   27.0 29.0             22     10   56 54 1 0         1     0   27 29         22   10   56
1047589 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1456659 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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
1555991 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   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
2067909 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           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
2106346 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           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
746785 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 68.0 1.0 2.0         1.0     1.0   43.0 30.0             34     13   73 68 1 2         1     1   43 30         34   13   73
943602 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 61.0 2.0 4.0   0.0     0.0         39.0 28.0     *       44     9   67 61 2 4   0     0         39 28         44   9   67
1033320 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   grade_7 62.0 0.0 0.0         1.0     0.0   39.0 24.0             32     *   63 62 0 0         1     0   39 24         32       63
1434505 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 62.0 2.0 2.0   0.0     0.0         31.0 35.0             37     17   66 62 2 2   0     0         31 35         37   17   66
1524584 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 54.0 0.0 1.0         1.0     1.0   29.0 28.0             34     9   57 54 0 1         1     1   29 28         34   9   57
2050942 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 47.0 0.0 2.0   1.0               32.0 18.0     *       31     7   50 47 0 2   1               32 18         31   7   50
2140660 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 53.0 1.0 1.0         0.0         26.0 29.0             35     8   55 53 1 1         0         26 29         35   8   55
746766 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   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
943583 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
1033301 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   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
1434486 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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
1524565 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
2050923 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 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
2140641 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD 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
746747 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2015   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
943564 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2017   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
1033282 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1434467 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2021   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
1524546 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2020   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
2050904 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD 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
2140622 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD 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
835078 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3 09 12 2015   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
1031363 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2017   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
1121556 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1522608 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2021   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
1612725 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2020   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
2138703 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN 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
2228364 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN 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
835154 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No 1 KG 03 2015   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
1031439 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2017   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
1121632 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No 1.0 KG 03 2016   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
1522684 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2021   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
1612801 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2020   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
2138779 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC 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     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228440 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 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
835097 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 219.0 9.0 27.0         18.0     8.0   142.0 139.0             20     39   281 219 9 27         18     8   142 139         20   39   281
1031382 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 197.0 10.0 36.0   1.0     12.0     14.0   138.0 132.0     5       29     50   270 197 10 36   1     12     14   138 132     5   29   50   270
1121575 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 179.0 9.0 24.0   0.0     21.0     4.0   126.0 111.0             *     *   237 179 9 24   0     21     4   126 111                 237
1522627 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 194.0 8.0 41.0         18.0     5.0   147.0 119.0     *       37     47   266 194 8 41         18     5   147 119         37   47   266
1612744 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 205.0 9.0 45.0   1.0     22.0     7.0   144.0 145.0     *       32     42   289 205 9 45   1     22     7   144 145         32   42   289
2138722 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 206.0 7.0 46.0   1.0     14.0     5.0   153.0 126.0     *       30     43   279 206 7 46   1     14     5   153 126         30   43   279
2228383 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 171.0 8.0 49.0   0.0     23.0     8.0   127.0 132.0     5       *     39   259 171 8 49   0     23     8   127 132     5       39   259
835135 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No 2 04 05 2015   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
1031420 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2017   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
1121613 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No 2.0 04 05 2016   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
1522665 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2021   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
1612782 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2020   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
2138760 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 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
2228421 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 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
835116 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No 1 KG 03 2015   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
1031401 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2017   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
1121594 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No 1.0 KG 03 2016   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
1522646 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2021   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
1612763 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2020   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
2138741 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE 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     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228402 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary PK 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
780168 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No 4 06 12 2015   grade_7 56.0 0.0           1.0     1.0   33.0 25.0             22     10   58 56 0           1     1   33 25         22   10   58
976662 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 56.0 0.0 0.0   0.0     0.0     3.0   33.0 26.0     *       27     *   59 56 0 0   0     0     3   33 26         27       59
1066665 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 50.0 0.0 2.0   0.0     0.0     3.0   32.0 23.0             25     12   55 50 0 2   0     0     3   32 23         25   12   55
1467812 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2021   grade_7 42.0   1.0         1.0     0.0   24.0 20.0     *       21     10   44 42   1         1     0   24 20         21   10   44
1557910 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_7 54.0   1.0         0.0     1.0   25.0 31.0     *       25     13   56 54   1         0     1   25 31         25   13   56
2083964 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 07 12 2018   grade_7 55.0 0.0 0.0         0.0     0.0   26.0 29.0             26     14   55 55 0 0         0     0   26 29         26   14   55
2173644 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 07 12 2019   grade_7 58.0   1.0         0.0     2.0   34.0 27.0     *       28     12   61 58   1         0     2   34 27         28   12   61
780149 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   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
976643 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
1066646 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   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
1467793 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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
1557891 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
2083945 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary KG 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     0   0   0   0
2173625 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY 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
1031173 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 01 2017   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
1121366 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No 1.0 PK 01 2016   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
1522418 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 02 2021   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
1612535 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 02 2020   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
2138513 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 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   0 0         0   0   0
2228174 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY 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
834888 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No 1 PK 06 2015   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
1031154 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No Elementary PK 06 2017   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
1121347 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No 1.0 PK 06 2016   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
1522399 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No Elementary PK 06 2021   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
1612516 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No Elementary PK 06 2020   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
2138494 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY 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     0   0   0   0
2228155 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY 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
834869 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No 3 07 12 2015   grade_7 5.0 40.0 59.0         5.0     1.0   53.0 57.0             102     11   110 5 40 59         5     1   53 57         102   11   110
1031135 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2017   grade_7 10.0 55.0 89.0   1.0     7.0     2.0   95.0 69.0     26       154     37   164 10 55 89   1     7     2   95 69     26   154   37   164
1121328 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No 3.0 07 12 2016   grade_7 8.0 55.0 80.0         5.0     2.0   74.0 76.0             137     33   150 8 55 80         5     2   74 76         137   33   150
1522380 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2021   grade_7 5.0 37.0 90.0   0.0     6.0     4.0   71.0 71.0     19       126     20   142 5 37 90   0     6     4   71 71     19   126   20   142
1612497 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2020   grade_7 12.0 42.0 107.0   2.0     5.0     3.0   84.0 87.0     31       158     32   171 12 42 107   2     5     3   84 87     31   158   32   171
2138475 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2018   grade_7 18.0 40.0 78.0         5.0     3.0   70.0 74.0     20       133     28   144 18 40 78         5     3   70 74     20   133   28   144
2228136 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2019   grade_7 18.0 41.0 98.0   0.0     10.0     3.0   99.0 71.0     23       161     38   170 18 41 98   0     10     3   99 71     23   161   38   170
834850 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No 2 07 08 2015   grade_7 42.0 76.0 141.0   0.0     14.0     4.0   133.0 144.0             239     59   277 42 76 141   0     14     4   133 144         239   59   277
1031116 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_7 26.0 50.0 148.0   0.0     20.0     0.0   123.0 121.0     20       *     49   244 26 50 148   0     20     0   123 121     20       49   244

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