Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_8", state = "NY" and year = 2017 sorted by ccd_school_high_grade descending

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_8 · 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
981052 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413005610 280201030008 MARSHALL SCHOOL public Regular School No Elementary PK PK 2017   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       *     *   0 0 0 0   0     0         0 0                 0
994637 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Elementary PK PK 2017   grade_8 0.0 0.0     0.0           0.0   0.0 0.0             *     *   0 0 0     0           0   0 0                 0
995910 NY Oneida   school 3624900 411800010000   ROME 362490006446 411800010011 CLOUGH PREK CENTER public Regular School No Elementary PK PK 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     *   0 0 0 0         0     0   0 0                 0
997069 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121004565 420303060015 MAIN STREET ELEMENTARY SCHOOL public Regular School No Elementary PK PK 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             *     0   0 0 0 0   0     0     0   0 0             0   0
997088 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Elementary PK PK 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     *   0 0 0 0         0     0   0 0                 0
1015974 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK PK 2017   grade_8 0.0                       0.0 0.0             0     *   0 0                       0 0         0       0
1029559 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003183 661500010003 URIAH HILL SCHOOL public Regular School No Elementary PK PK 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
957739 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376004616 131500010007 SMITH EARLY LEARNING CENTER public Regular School No Elementary PK KG 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
980007 NY Monroe   school 3601153 261600861049   ROCHESTER PREP CHARTER SCHOO 360115306592 261600861049 ROCHESTER PREP CHARTER SCHOOL 3 charter Regular School Yes Elementary KG KG 2017   grade_8 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
981128 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413006370 280201030016 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary KG KG 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
982097 NY Nassau   school 3611550 280209030000   FREEPORT 361155004441 280209030004 COLUMBUS AVENUE SCHOOL public Regular School No Elementary KG KG 2017   grade_8 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
982496 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157002021 280211030016 SCHOOL 6-KINDERGARTEN CTR public Regular School No Elementary KG KG 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
983218 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001657 280220030001 KINDERGARTEN CENTER public Regular School No Elementary KG KG 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
985042 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001022 280407030009 EARLY CHILDHOOD CENTER public Regular School No Elementary PK KG 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1000432 NY Orange   school 3604758 441202020000   KIRYAS JOEL 360475804758 441202020001 KIRYAS JOEL VILLAGE SCHOOL public Regular School No Elementary PK KG 2017   grade_8 0.0                       0.0 0.0     0       0     0   0 0                       0 0     0   0   0   0
1012839 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781006098 500402060006 EAST RAMAPO EARLY CHLD CTR AT KAKIAT public Regular School No Elementary KG KG 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1018368 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920004843 580211060006 BICYCLE PATH KINDERGARTEN-PRE K public Regular School No Elementary PK KG 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1018539 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920004343 580211060018 UNITY DRIVE KINDERGARTEN-PRE K public Regular School No Elementary PK KG 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1021845 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687001061 580513030009 CENTRAL ISLIP EARLY CHLDHD CENTER public Regular School No Elementary PK KG 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1025778 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001256 641301060003 MARGARET MURPHY KINDERGARTEN CENTER public Regular School No Elementary PK KG 2017   grade_8 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
1027260 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003888 660401030001 JOHN PAULDING SCHOOL public Regular School No Elementary KG KG 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
960152 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY HIGH SCHOOL public Regular School No Other 09 9 2017   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
960171 NY Erie   school 3605850 140600010000   BUFFALO 360585006593 140600010141 LAFAYETTE INTERNATIONAL SCHOOL public Regular School No Other 09 9 2017   grade_8 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
964351 NY Hamilton   school 3616530 200601040000   LAKE PLEASANT 361653001461 200601040001 LAKE PLEASANT SCHOOL public Regular School No Other PK 9 2017   grade_8 7.0 0.0 0.0               0.0   3.0 4.0             0     0   7 7 0 0               0   3 4         0   0   7
966498 NY Kings   school 3601094 331300861056   UNITY PREP CHARTER SCH OF BR 360109406404 331300861056 UNITY PREP CHARTER SCH OF BROOKLYN charter Regular School Yes Other 06 9 2017   grade_8 2.0 74.0 23.0   1.0     2.0         57.0 45.0     9       85     24   102 2 74 23   1     2         57 45     9   85   24   102
958518 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001772 132201040001 MILLBROOK MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 76.0 0.0 7.0         1.0     3.0   44.0 43.0             28     21   87 76 0 7         1     3   44 43         28   21   87
958613 NY Erie   school 3602550 140101060000   ALDEN 360255000038 140101060005 ALDEN MIDDLE SCHOOL public Regular School No Elementary 04 8 2017   grade_8 130.0 1.0 0.0   0.0     1.0     0.0   73.0 59.0             36     19   132 130 1 0   0     1     0   73 59         36   19   132
958670 NY Erie   school 3602920 140201060000   AMHERST 360292004335 140201060001 AMHERST MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 152.0 34.0 15.0   0.0     17.0     8.0   115.0 111.0     6       59     21   226 152 34 15   0     17     8   115 111     6   59   21   226
958746 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004216 140203060001 MILL MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 173.0 12.0 11.0   0.0     15.0     12.0   107.0 116.0     *       46     20   223 173 12 11   0     15     12   107 116         46   20   223
958879 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004213 140203060009 HEIM MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 127.0 8.0 8.0   1.0     20.0     5.0   90.0 79.0     *       32     25   169 127 8 8   1     20     5   90 79         32   25   169
958936 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004756 140203060012 CASEY MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 137.0 10.0 10.0   0.0     21.0     7.0   85.0 100.0     *       28     18   185 137 10 10   0     21     7   85 100         28   18   185
958974 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147000457 140203060015 TRANSIT MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 183.0 3.0 8.0   2.0     40.0     11.0   118.0 129.0     *       20     19   247 183 3 8   2     40     11   118 129         20   19   247
959031 NY Erie   school 3628500 140207060000   SWEET HOME 362850003831 140207060005 SWEET HOME MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 154.0 54.0 14.0   0.0     10.0     3.0   132.0 103.0     5       118     30   235 154 54 14   0     10     3   132 103     5   118   30   235
959126 NY Erie   school 3609540 140301030000   EAST AURORA 360954000725 140301030004 EAST AURORA MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 149.0 1.0 6.0         2.0     1.0   88.0 71.0             18     14   159 149 1 6         2     1   88 71         18   14   159
959164 NY Erie   school 3605850 140600010000   BUFFALO 360585003478 140600010001 DISCOVERY SCHOOL public Regular School No Elementary PK 8 2017   grade_8 26.0 17.0 2.0   1.0     2.0     2.0   23.0 27.0     *       26     9   50 26 17 2   1     2     2   23 27         26   9   50
959183 NY Erie   school 3605850 140600010000   BUFFALO 360585000318 140600010003 D'YOUVILLE-PORTER CAMPUS public Regular School No Elementary PK 8 2017   grade_8 4.0 21.0 47.0   0.0     3.0     2.0   42.0 35.0     20       61     9   77 4 21 47   0     3     2   42 35     20   61   9   77
959202 NY Erie   school 3605850 140600010000   BUFFALO 360585000295 140600010006 BUFFALO ELEM SCH OF TECHNOLOGY public Regular School No Elementary PK 8 2017   grade_8 3.0 39.0 5.0   0.0     13.0     1.0   32.0 29.0     22       53     19   61 3 39 5   0     13     1   32 29     22   53   19   61
959240 NY Erie   school 3605850 140600010000   BUFFALO 360585000323 140600010018 DR A PANTOJA COMM SCH EXCLLNCE -#18 public Regular School No Elementary PK 8 2017   grade_8 9.0 29.0 13.0         10.0     1.0   28.0 34.0     22       52     14   62 9 29 13         10     1   28 34     22   52   14   62
959259 NY Erie   school 3605850 140600010000   BUFFALO 360585000324 140600010019 NATIVE AMERICAN MAGNET public Regular School No Elementary PK 8 2017   grade_8 5.0 25.0 7.0   9.0     10.0     2.0   26.0 32.0     9       47     14   58 5 25 7   9     10     2   26 32     9   47   14   58
959278 NY Erie   school 3605850 140600010000   BUFFALO 360585000329 140600010027 PS 27 HILLERY PARK ACADEMY public Regular School No Elementary PK 8 2017   grade_8 22.0 22.0 4.0   0.0     1.0     1.0   23.0 27.0     0       33     9   50 22 22 4   0     1     1   23 27     0   33   9   50
959297 NY Erie   school 3605850 140600010000   BUFFALO 360585000332 140600010031 HARRIET ROSS TUBMAN ACADEMY public Regular School No Elementary PK 8 2017   grade_8 4.0 25.0 1.0   0.0     2.0     0.0   13.0 19.0     5       30     *   32 4 25 1   0     2     0   13 19     5   30       32
959316 NY Erie   school 3605850 140600010000   BUFFALO 360585000300 140600010032 BUILD ACADEMY public Regular School No Elementary PK 8 2017   grade_8 0.0 35.0 5.0         3.0     2.0   24.0 21.0     *       38     13   45 0 35 5         3     2   24 21         38   13   45
959335 NY Erie   school 3605850 140600010000   BUFFALO 360585000333 140600010033 BILINGUAL CENTER public Regular School No Elementary PK 8 2017   grade_8 8.0 4.0 42.0         1.0     1.0   25.0 31.0     23       44     12   56 8 4 42         1     1   25 31     23   44   12   56
959354 NY Erie   school 3605850 140600010000   BUFFALO 360585000335 140600010037 MARVA J DANIEL FUTURES PREP SCHOOL public Regular School No Elementary PK 8 2017   grade_8 2.0 42.0 4.0   0.0     0.0     1.0   27.0 22.0     *       43     14   49 2 42 4   0     0     1   27 22         43   14   49
959392 NY Erie   school 3605850 140600010000   BUFFALO 360585000339 140600010043 LOVEJOY DISCOVERY SCHOOL #43 public Regular School No Elementary PK 8 2017   grade_8 36.0 15.0 12.0         2.0     0.0   39.0 26.0     *       57     20   65 36 15 12         2     0   39 26         57   20   65
959411 NY Erie   school 3605850 140600010000   BUFFALO 360585000341 140600010045 INTERNATIONAL SCHOOL public Regular School No Elementary PK 8 2017   grade_8 10.0 40.0 6.0   0.0     53.0     1.0   59.0 51.0     46       96     *   110 10 40 6   0     53     1   59 51     46   96       110
959430 NY Erie   school 3605850 140600010000   BUFFALO 360585000346 140600010053 COMMUNITY SCHOOL #53 public Regular School No Elementary PK 8 2017   grade_8 2.0 29.0 2.0         0.0     0.0   23.0 10.0     0       26     7   33 2 29 2         0     0   23 10     0   26   7   33
959487 NY Erie   school 3605850 140600010000   BUFFALO 360585000350 140600010059 PS 59 DR CHARLES DREW SCI MAGNET public Regular School No Elementary PK 8 2017   grade_8 9.0 77.0 8.0   1.0     7.0     1.0   61.0 42.0     9       83     30   103 9 77 8   1     7     1   61 42     9   83   30   103
959563 NY Erie   school 3605850 140600010000   BUFFALO 360585000357 140600010066 PS 66 NORTH PARK ACADEMY public Regular School No Middle 05 8 2017   grade_8 6.0 40.0 12.0   0.0     2.0     2.0   37.0 25.0     *       53     24   62 6 40 12   0     2     2   37 25         53   24   62
959582 NY Erie   school 3605850 140600010000   BUFFALO 360585000360 140600010069 PS 69 HOUGHTON ACADEMY public Regular School No Elementary PK 8 2017   grade_8 13.0 28.0 5.0   0.0     0.0     2.0   24.0 24.0     *       38     *   48 13 28 5   0     0     2   24 24         38       48
959601 NY Erie   school 3605850 140600010000   BUFFALO 360585000363 140600010072 LORRAINE ELEMENTARY SCHOOL public Regular School No Elementary PK 8 2017   grade_8 28.0 15.0 8.0   1.0     0.0     1.0   19.0 34.0     *       39     11   53 28 15 8   1     0     1   19 34         39   11   53
959620 NY Erie   school 3605850 140600010000   BUFFALO 360585000364 140600010074 PS 74 HAMLIN PARK ELEMENTARY SCHOOL public Regular School No Elementary PK 8 2017   grade_8 2.0 47.0 4.0   0.0     0.0     1.0   24.0 30.0     *       52     17   54 2 47 4   0     0     1   24 30         52   17   54
959639 NY Erie   school 3605850 140600010000   BUFFALO 360585000310 140600010076 HERMAN BADILLO COMMUNITY SCHOOL public Regular School No Elementary PK 8 2017   grade_8 6.0 13.0 63.0         2.0     1.0   39.0 46.0     33       75     13   85 6 13 63         2     1   39 46     33   75   13   85
959658 NY Erie   school 3605850 140600010000   BUFFALO 360585000368 140600010080 HIGHGATE HEIGHTS public Regular School No Elementary PK 8 2017   grade_8 1.0 43.0 2.0         1.0     1.0   27.0 21.0     *       41     9   48 1 43 2         1     1   27 21         41   9   48
959677 NY Erie   school 3605850 140600010000   BUFFALO 360585000369 140600010081 PS 81 public Regular School No Elementary PK 8 2017   grade_8 18.0 49.0 12.0   3.0     0.0     2.0   41.0 43.0     0       51     14   84 18 49 12   3     0     2   41 43     0   51   14   84
959734 NY Erie   school 3605850 140600010000   BUFFALO 360585004506 140600010093 SOUTHSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 8 2017   grade_8 57.0 23.0 17.0   3.0     6.0     2.0   65.0 43.0     8       84     22   108 57 23 17   3     6     2   65 43     8   84   22   108
959753 NY Erie   school 3605850 140600010000   BUFFALO 360585000302 140600010094 DR LYDIA T WRIGHT SCH OF EXCELLENCE public Regular School No Elementary PK 8 2017   grade_8 4.0 58.0 3.0   0.0     1.0     1.0   30.0 37.0     *       47     18   67 4 58 3   0     1     1   30 37         47   18   67
959962 NY Erie   school 3605850 140600010000   BUFFALO 360585000382 140600010118 WEST HERTEL ELEMENTARY SCHOOL public Regular School No Elementary PK 8 2017   grade_8 8.0 33.0 16.0   0.0     24.0     2.0   40.0 43.0     27       72     8   83 8 33 16   0     24     2   40 43     27   72   8   83
959981 NY Erie   school 3605850 140600010000   BUFFALO 360585000381 140600010119 WATERFRONT SCHOOL public Regular School No Elementary PK 8 2017   grade_8 12.0 43.0 20.0   1.0     21.0     2.0   43.0 56.0     20       90     28   99 12 43 20   1     21     2   43 56     20   90   28   99
960000 NY Erie   school 3605850 140600010000   BUFFALO 360585000316 140600010122 BENNETT PARK MONTESSORI SCHOOL public Regular School No Elementary PK 8 2017   grade_8 7.0 57.0 4.0   1.0     0.0     1.0   29.0 41.0     *       61     19   70 7 57 4   1     0     1   29 41         61   19   70
960057 NY Erie   school 3605850 140600010000   BUFFALO 360585003481 140600010129 GRABIARZ-CAMPUS SCHOOL #79 public Regular School No Elementary PK 8 2017   grade_8 10.0 18.0 6.0   0.0     3.0     1.0   17.0 21.0     *       33     6   38 10 18 6   0     3     1   17 21         33   6   38
960076 NY Erie   school 3605850 140600010000   BUFFALO 360585005858 140600010130 FRANK A SEDITA SCHOOL #30 public Regular School No Elementary PK 8 2017   grade_8 4.0 18.0 54.0   1.0     0.0     0.0   37.0 40.0     38       67     21   77 4 18 54   1     0     0   37 40     38   67   21   77
960190 NY Erie   school 3605850 140600010000   BUFFALO 360585005600 140600010197 HARVEY AUSTIN SCHOOL #97 public Regular School No Elementary PK 8 2017   grade_8 3.0 66.0 2.0         0.0     0.0   38.0 33.0     0       62     12   71 3 66 2         0     0   38 33     0   62   12   71
960266 NY Erie   school 3600035 140600860814   KING CENTER CHARTER SCHOOL 360003504336 140600860814 KING CENTER CHARTER SCHOOL charter Regular School Yes Elementary KG 8 2017   grade_8 0.0 21.0 0.0   1.0     0.0     0.0   14.0 8.0     *       21     *   22 0 21 0   1     0     0   14 8         21       22
960285 NY Erie   school 3600036 140600860817   SOUTH BUFFALO CHARTER SCHOOL 360003604337 140600860817 SOUTH BUFFALO CHARTER SCHOOL charter Regular School Yes Elementary KG 8 2017   grade_8 47.0 20.0 20.0   0.0     1.0     4.0   43.0 49.0     *       78     10   92 47 20 20   0     1     4   43 49         78   10   92
960323 NY Erie   school 3600071 140600860851   BUFFALO UNITED CHARTER SCH 360007105538 140600860851 BUFFALO UNITED CHARTER SCHOOL charter Regular School Yes Elementary KG 8 2017   grade_8 0.0 63.0 1.0   1.0     0.0         31.0 34.0     *       61     *   65 0 63 1   1     0         31 34         61       65
960342 NY Erie   school 3600073 140600860856   ENTERPRISE CHARTER SCHOOL 360007305551 140600860856 ENTERPRISE CHARTER SCHOOL charter Regular School Yes Elementary KG 8 2017   grade_8 0.0 25.0 13.0         1.0     0.0   15.0 24.0     *       34     11   39 0 25 13         1     0   15 24         34   11   39
960418 NY Erie   school 3600107 140600860874   WESTMINSTER COMM CHARTER SCH 360010705604 140600860874 WESTMINSTER COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 8 2017   grade_8 0.0 45.0 0.0         3.0     0.0   22.0 26.0     *       45     6   48 0 45 0         3     0   22 26         45   6   48
960437 NY Erie   school 3600160 140600860896   ELMWOOD VILLAGE CHARTER SCHO 360016005851 140600860896 ELMWOOD VILLAGE CHARTER SCHOOL charter Regular School Yes Elementary KG 8 2017   grade_8 9.0 5.0 3.0   1.0     0.0     1.0   13.0 6.0     0       *     *   19 9 5 3   1     0     1   13 6     0           19
960570 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 78.0 47.0 9.0   1.0     13.0     10.0   82.0 76.0     *       92     22   158 78 47 9   1     13     10   82 76         92   22   158
960646 NY Erie   school 3618600 140702030000   MARYVALE 361860001677 140702030005 MARYVALE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 113.0 20.0 7.0   0.0     6.0     7.0   68.0 85.0     *       78     17   153 113 20 7   0     6     7   68 85         78   17   153
960722 NY Erie   school 3607680 140703020000   CLEVELAND HILL 360768004583 140703020004 CLEVELAND HILL MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 54.0 25.0 7.0         1.0     13.0   48.0 52.0     0       61     15   100 54 25 7         1     13   48 52     0   61   15   100
960760 NY Erie   school 3609030 140707030000   DEPEW 360903000690 140707030004 DEPEW MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 123.0 1.0 7.0   1.0     6.0     4.0   75.0 67.0     *       *     15   142 123 1 7   1     6     4   75 67             15   142
960836 NY Erie   school 3627000 140709030000   SLOAN 362700002831 140709030003 JOHN F KENNEDY MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 91.0 6.0 3.0         2.0     4.0   51.0 55.0     *       61     14   106 91 6 3         2     4   51 55         61   14   106
960969 NY Erie   school 3607590 140801060000   CLARENCE 360759000542 140801060008 CLARENCE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 343.0 2.0 5.0   1.0     14.0     6.0   185.0 186.0     *       41     41   371 343 2 5   1     14     6   185 186         41   41   371
961045 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001065 141101060004 GRIFFITH INST MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 120.0 1.0 4.0   1.0     1.0     1.0   65.0 63.0     *       50     13   128 120 1 4   1     1     1   65 63         50   13   128
961102 NY Erie   school 3610170 141201060000   EDEN 361017000790 141201060005 EDEN ELEMENTARY SCHOOL public Regular School No Elementary KG 8 2017   grade_8 2.0 0.0 0.0   0.0     0.0     0.0   0.0 2.0             0     *   2 2 0 0   0     0     0   0 2         0       2
961178 NY Erie   school 3615360 141301060000   IROQUOIS 361536001293 141301060005 IROQUOIS MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 161.0 1.0 6.0   0.0     0.0     1.0   85.0 84.0     *       27     25   169 161 1 6   0     0     1   85 84         27   25   169
961311 NY Erie   school 3616560 141401060000   EVANS-BRANT 361656001468 141401060009 LAKE SHORE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 147.0 0.0 3.0   21.0     2.0     4.0   91.0 86.0             98     35   177 147 0 3   21     2     4   91 86         98   35   177
961387 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000493 141501060005 VERONICA E CONNOR MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 210.0 4.0 5.0   0.0     7.0     3.0   119.0 110.0     0       56     36   229 210 4 5   0     7     3   119 110     0   56   36   229
961501 NY Erie   school 3613350 141601060000   HAMBURG 361335001098 141601060006 HAMBURG MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 265.0 2.0 9.0   0.0     2.0     2.0   131.0 149.0     *       66     42   280 265 2 9   0     2     2   131 149         66   42   280
961615 NY Erie   school 3611670 141604060000   FRONTIER 361167000920 141604060007 FRONTIER MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 349.0 2.0 19.0   3.0     7.0     14.0   207.0 187.0     *       145     65   394 349 2 19   3     7     14   207 187         145   65   394
961691 NY Erie   school 3616440 141800010000   LACKAWANNA 361644002836 141800010005 LACKAWANNA MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 77.0 18.0 18.0   1.0     1.0     1.0   54.0 62.0     25       101     18   116 77 18 18   1     1     1   54 62     25   101   18   116
961862 NY Erie   school 3616680 141901060000   LANCASTER 361668001482 141901060007 LANCASTER MIDDLE SCHOOL public Regular School No Middle 07 8 2017   grade_8 432.0 7.0 11.0   4.0     10.0     9.0   214.0 259.0     *       107     65   473 432 7 11   4     10     9   214 259         107   65   473
961957 NY Erie   school 3602430 142101040000   AKRON 360243005012 142101040003 AKRON MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 93.0 0.0 1.0   15.0     1.0     3.0   45.0 68.0             34     6   113 93 0 1   15     1     3   45 68         34   6   113
961995 NY Erie   school 3620970 142201040000   NORTH COLLINS 362097002977 142201040002 NORTH COLLINS ELEMENTARY SCHOOL public Regular School No Elementary PK 8 2017   grade_8 3.0   0.0   0.0     0.0     0.0   2.0 1.0     *       0     0   3 3   0   0     0     0   2 1         0   0   3
962033 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190003111 142301060002 ORCHARD PARK MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 381.0 2.0 8.0   1.0     9.0     4.0   205.0 200.0     *       40     51   405 381 2 8   1     9     4   205 200         40   51   405
962242 NY Erie   school 3616230 142601030000   KENMORE 361623004392 142601030011 HERBERT HOOVER MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
962413 NY Erie   school 3630780 142801060000   WEST SENECA 363078004144 142801060005 EAST MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 179.0 9.0 6.0   1.0     3.0     6.0   94.0 110.0     0       89     19   204 179 9 6   1     3     6   94 110     0   89   19   204
962470 NY Erie   school 3630780 142801060000   WEST SENECA 363078004150 142801060011 WEST MIDDLE SCHOOL public Regular School No Elementary 04 8 2017   grade_8 270.0 10.0 11.0   0.0     2.0     10.0   156.0 147.0             129     44   303 270 10 11   0     2     10   156 147         129   44   303
962793 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003894 151501060007 TICONDEROGA MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 49.0 1.0           1.0         27.0 24.0             *     12   51 49 1           1         27 24             12   51
962983 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550006264 161201040005 SALMON RIVER MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 44.0   0.0   97.0           1.0   74.0 68.0             106     20   142 44   0   97           1   74 68         106   20   142
963040 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003534 161401060003 SARANAC LAKE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 80.0 0.0                 0.0   46.0 34.0             *     *   80 80 0                 0   46 34                 80
963135 NY Franklin   school 3618180 161501060000   MALONE 361818001638 161501060015 MALONE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 155.0 2.0 0.0   0.0     0.0         87.0 70.0             87     27   157 155 2 0   0     0         87 70         87   27   157
963230 NY Fulton   school 3631200 170301020000   WHEELERVILLE 363120004173 170301020001 WHEELERVILLE SCHOOL public Regular School No Elementary PK 8 2017   grade_8 15.0   1.0               0.0   6.0 10.0             7     *   16 15   1               0   6 10         7       16
963306 NY Fulton   school 3612270 170500010000   GLOVERSVILLE 361227000986 170500010008 GLOVERSVILLE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 177.0 9.0 7.0   0.0     0.0     3.0   98.0 98.0     *       120     40   196 177 9 7   0     0     3   98 98         120   40   196
963439 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001382 170600010007 KNOX JUNIOR HIGH SCHOOL public Regular School No Middle 07 8 2017   grade_8 112.0 1.0 4.0         2.0     2.0   63.0 58.0     *       60     *   121 112 1 4         2     2   63 58         60       121
963572 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000503206 171102040003 BROADALBIN-PERTH MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 125.0 4.0 3.0         0.0     2.0   67.0 67.0             59     18   134 125 4 3         0     2   67 67         59   18   134
963724 NY Genesee   school 3603990 180300010000   BATAVIA 360399000157 180300010005 BATAVIA MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_8 115.0 6.0 11.0         2.0     18.0   85.0 67.0     *       *     21   152 115 6 11         2     18   85 67             21   152
964047 NY Greene   school 3606160 190301040000   CAIRO-DURHAM 360616001568 190301040004 CAIRO-DURHAM MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_8 81.0 5.0 10.0   1.0           6.0   54.0 49.0     *       58     27   103 81 5 10   1           6   54 49         58   27   103

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