Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_8" and state = "NY" sorted by ell_int

View and edit SQL

year

grade

  • grade_8 · 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
942596 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 311.0 7.0 15.0         24.0     5.0   174.0 188.0     *       40     31   362 311 7 15         24     5   174 188         40   31   362
942653 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 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
942672 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 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
942767 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 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
942786 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 116.0 7.0 12.0   0.0     4.0     8.0   91.0 56.0     *       100     30   147 116 7 12   0     4     8   91 56         100   30   147
942976 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_8 11.0 2.0 1.0   0.0     0.0     4.0   11.0 7.0     *       7     *   18 11 2 1   0     0     4   11 7         7       18
943147 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_8 21.0 3.0 1.0         0.0     1.0   10.0 16.0     *       22     6   26 21 3 1         0     1   10 16         22   6   26
943166 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
943261 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 314.0 17.0 20.0   1.0     42.0     7.0   199.0 202.0     *       74     65   401 314 17 20   1     42     7   199 202         74   65   401
943299 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
943318 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 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
943565 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 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
943603 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 64.0 0.0 0.0   0.0     1.0         39.0 26.0     *       37     10   65 64 0 0   0     1         39 26         37   10   65
943660 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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
944173 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No Other 06 12 2017   grade_8 3.0 21.0 66.0   2.0     0.0     0.0   48.0 44.0     *       92     26   92 3 21 66   2     0     0   48 44         92   26   92
944344 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No Other 06 12 2017   grade_8 2.0 9.0 57.0   1.0     0.0     0.0   35.0 34.0     *       57     13   69 2 9 57   1     0     0   35 34         57   13   69
944667 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2017   grade_8 0.0 24.0 23.0   0.0     0.0     0.0   26.0 21.0     *       46     *   47 0 24 23   0     0     0   26 21         46       47
944990 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502293 320800010071 PS 71 ROSE E SCALA public Regular School No Elementary PK 08 2017   grade_8 48.0 12.0 121.0   1.0     12.0     0.0   96.0 98.0     *       152     46   194 48 12 121   1     12     0   96 98         152   46   194
945085 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2017   grade_8 29.0 19.0 87.0   0.0     25.0     2.0   79.0 83.0     *       107     37   162 29 19 87   0     25     2   79 83         107   37   162
945351 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505123 320800010304 PS 304 EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK 05 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
945427 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505657 320800010337 SCHOOL FOR INQUIRY & SOCIAL JUSTICE public Regular School No Middle 06 08 2017   grade_8 1.0 47.0 121.0   2.0     13.0         94.0 90.0     *       131     *   184 1 47 121   2     13         94 90         131       184
945731 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505985 320800011367 ARCHIMEDES ACAD-MATH, SCI, TECH public Regular School No Other 06 12 2017   grade_8 1.0 29.0 45.0   1.0     7.0     0.0   37.0 46.0     *       67     19   83 1 29 45   1     7     0   37 46         67   19   83
945750 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505984 320800011376 ANTONIA PANTOJA PREP ACADEMY public Regular School No Other 06 12 2017   grade_8 1.0 20.0 38.0   1.0     2.0         32.0 30.0     *       42     16   62 1 20 38   1     2         32 30         42   16   62
945883 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506258 320800011537 BRONX ARENA HIGH SCHOOL public Regular School No High 09 12 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
946016 NY Bronx   school 3600986 320800860940   GIRLS PREP CHARTER-BRONX 360098606161 320800860940 GIRLS PREP CHARTER SCH-BRONX charter Regular School Yes Elementary PK 08 2017   grade_8 0.0 36.0 56.0   0.0     0.0     1.0   0.0 93.0     *       80     17   93 0 36 56   0     0     1   0 93         80   17   93
946073 NY Bronx   school 3601091 320800861030   ICAHN CHARTER SCHOOL 7 360109106389 320800861030 ICAHN CHARTER SCHOOL 7 charter Regular School Yes Elementary KG 05 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
946605 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605790 320900010215 KAPPA public Regular School No Middle 05 08 2017   grade_8 0.0 27.0 31.0   0.0     3.0     0.0   30.0 31.0     *       *     16   61 0 27 31   0     3     0   30 31             16   61
946757 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603764 320900010303 IS 303 LEADERSHIP & COMM SERVICE public Regular School No Middle 06 08 2017   grade_8 0.0 23.0 57.0   0.0     0.0         37.0 43.0     *       *     *   80 0 23 57   0     0         37 43                 80
946871 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605667 320900010328 NEW MILLENNIUM BUSINESS ACAD MS public Regular School No Middle 06 08 2017   grade_8 0.0 16.0 37.0   1.0     1.0         31.0 24.0     *       *     *   55 0 16 37   1     1         31 24                 55
946909 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606394 320900010361 HIGHBRIDGE GREEN SCHOOL (THE) public Regular School No Middle 06 08 2017   grade_8 1.0 30.0 92.0   0.0     1.0         65.0 59.0     *       *     39   124 1 30 92   0     1         65 59             39   124
947023 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606345 320900010568 YOUNG WOMEN'S LDSHP SCHOOL-BRONX public Regular School No Other 06 12 2017   grade_8 0.0 25.0 49.0   1.0     3.0     0.0     78.0     *       61     16   78 0 25 49   1     3     0     78         61   16   78
947346 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605177 320900011413 BRONX HIGH SCHOOL FOR MEDICAL SCIE public Regular School No Other 06 12 2017   grade_8 0.0 19.0 22.0   0.0     3.0     0.0   19.0 25.0     *       36     *   44 0 19 22   0     3     0   19 25         36       44
947479 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_8 1.0 46.0 25.0   0.0     0.0     0.0   21.0 51.0     *       42     7   72 1 46 25   0     0     0   21 51         42   7   72
947517 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER I 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER I charter Regular School Yes Elementary KG 08 2017   grade_8 0.0 7.0 37.0   0.0     0.0     0.0   17.0 27.0     *       *     *   44 0 7 37   0     0     0   17 27                 44
947555 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Elementary KG 08 2017   grade_8 1.0 23.0 30.0   0.0     0.0     0.0   27.0 27.0     *       50     5   54 1 23 30   0     0     0   27 27         50   5   54
947593 NY Bronx   school 3601071 320900861004   MOTT HALL CHARTER SCHOOL 360107106328 320900861004 MOTT HALL CHARTER SCHOOL charter Regular School Yes Middle 06 08 2017   grade_8 1.0 31.0 45.0   2.0     0.0         34.0 45.0     *       72     10   79 1 31 45   2     0         34 45         72   10   79
947745 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701748 321000010015 PS 15 INST FOR ENVIRON LRNG public Regular School No Elementary KG 08 2017   grade_8 0.0 10.0 55.0   0.0     1.0     0.0   40.0 26.0     *       47     22   66 0 10 55   0     1     0   40 26         47   22   66
947764 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702179 321000010020 PS/MS 20 PO GEORGE J WERDAN III public Regular School No Elementary PK 08 2017   grade_8 10.0 4.0 59.0   0.0     8.0     0.0   45.0 36.0     *       75     20   81 10 4 59   0     8     0   45 36         75   20   81
947878 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702202 321000010045 THOMAS C GIORDANO MS 45 public Regular School No Middle 06 08 2017   grade_8 7.0 41.0 177.0   0.0     2.0     0.0   117.0 110.0     *       *     *   227 7 41 177   0     2     0   117 110                 227
948125 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702361 321000010095 PS 95 SHEILA MENCHER public Regular School No Elementary PK 08 2017   grade_8 4.0 28.0 112.0   0.0     9.0     2.0   83.0 72.0     *       97     31   155 4 28 112   0     9     2   83 72         97   31   155
948201 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704310 321000010206 IS 206 ANN MERSEREAU public Regular School No Middle 05 08 2017   grade_8 2.0 12.0 60.0   0.0     0.0         41.0 33.0     *       53     26   74 2 12 60   0     0         41 33         53   26   74
948258 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705796 321000010225 THEATRE ARTS PROD COMPANY SCHOOL public Regular School No Other 06 12 2017   grade_8 4.0 22.0 39.0   0.0     1.0     0.0   17.0 49.0     *       50     12   66 4 22 39   0     1     0   17 49         50   12   66
948296 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705797 321000010228 JONAS BRONCK ACADEMY public Regular School No Middle 06 08 2017   grade_8 1.0 17.0 69.0   0.0     2.0     0.0   45.0 44.0     *       79     24   89 1 17 69   0     2     0   45 44         79   24   89
948372 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700183 321000010279 PS 279 CAPT MANUEL RIVERA JR public Regular School No Elementary KG 08 2017   grade_8 0.0 23.0 93.0   0.0     4.0     0.0   63.0 57.0     *       115     22   120 0 23 93   0     4     0   63 57         115   22   120
948467 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705569 321000010308 BRONX DANCE ACADEMY SCHOOL public Regular School No Middle 06 08 2017   grade_8 0.0 20.0 68.0         3.0     1.0   20.0 72.0     *       79     16   92 0 20 68         3     1   20 72         79   16   92
948505 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702939 321000010315 PS 315 LAB SCHOOL public Regular School No Elementary KG 08 2017   grade_8 0.0 3.0 21.0   1.0     0.0     0.0   12.0 13.0     *       25     *   25 0 3 21   1     0     0   12 13         25       25
948733 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706141 321000010447 CRESTON ACADEMY public Regular School No Middle 06 08 2017   grade_8 0.0 20.0 135.0   0.0     5.0         83.0 77.0     *       143     37   160 0 20 135   0     5         83 77         143   37   160
948809 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705674 321000011243 WEST BRONX ACAD FOR THE FUTURE public Regular School No Other 06 12 2017   grade_8 2.0 22.0 64.0   1.0     1.0         48.0 42.0     *       83     25   90 2 22 64   1     1         48 42         83   25   90
949151 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706142 321000011459 EAST FORDHAM ACADEMY-ARTS public Regular School No Middle 06 08 2017   grade_8 0.0 19.0 82.0   0.0     2.0         54.0 49.0     *       94     27   103 0 19 82   0     2         54 49         94   27   103
949360 NY Bronx   school 3601068 321000861032   TECH INTERNATIONAL CHARTER S 360106806358 321000861032 TECH INTERNATIONAL CHARTER SCHOOL charter Regular School Yes Middle 06 08 2017   grade_8 4.0 17.0 67.0   0.0     4.0         53.0 39.0     *       *     *   92 4 17 67   0     4         53 39                 92
949436 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802100 321100010019 PS 19 JUDITH K WEISS public Regular School No Elementary KG 08 2017   grade_8 29.0 6.0 13.0   0.0     8.0     0.0   25.0 31.0     *       37     10   56 29 6 13   0     8     0   25 31         37   10   56
949797 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802524 321100010144 JHS 144 MICHELANGELO public Regular School No Middle 06 08 2017   grade_8 3.0 102.0 49.0   1.0     3.0         79.0 79.0     *       92     41   158 3 102 49   1     3         79 79         92   41   158
949873 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802613 321100010175 PS 175 CITY ISLAND public Regular School No Elementary KG 08 2017   grade_8 18.0 4.0 15.0   0.0     4.0     0.0   20.0 21.0     *       15     8   41 18 4 15   0     4     0   20 21         15   8   41
949911 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802628 321100010180 MS 180 DR DANIEL HALE WILLIAMS public Regular School No Middle 06 08 2017   grade_8 9.0 186.0 77.0   2.0     12.0     1.0   135.0 152.0     *       222     54   287 9 186 77   2     12     1   135 152         222   54   287
949930 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008801989 321100010181 IS 181 PABLO CASALS public Regular School No Middle 06 08 2017   grade_8 7.0 165.0 69.0   4.0     10.0     0.0   132.0 123.0     *       197     71   255 7 165 69   4     10     0   132 123         197   71   255
949987 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805800 321100010287 NORTH BRONX SCHOOL OF EMPOWERMENT public Regular School No Middle 06 08 2017   grade_8 1.0 50.0 30.0   7.0     5.0         46.0 47.0     *       82     *   93 1 50 30   7     5         46 47         82       93
950101 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2017   grade_8 0.0 59.0 25.0   1.0     2.0         39.0 48.0     *       *     *   87 0 59 25   1     2         39 48                 87
950158 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806559 321100010483 MATILDA AVENUE SCHOOL (THE) public Regular School No Elementary KG 05 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
950177 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806217 321100010498 PS/MS 498 VAN NEST ACADEMY public Regular School No Elementary KG 08 2017   grade_8 17.0 7.0 63.0   0.0     7.0     1.0   45.0 50.0     *       75     18   95 17 7 63   0     7     1   45 50         75   18   95
950633 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes Elementary KG 08 2017   grade_8 1.0 33.0 29.0   0.0     26.0     0.0   48.0 41.0     *       65     8   89 1 33 29   0     26     0   48 41         65   8   89
950690 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2017   grade_8 0.0 19.0 8.0   0.0     0.0     0.0   10.0 17.0     *       20     *   27 0 19 8   0     0     0   10 17         20       27
950709 NY Bronx   school 3601005 321100860956   EQUALITY CHARTER SCHOOL 360100506110 321100860956 EQUALITY CHARTER SCHOOL charter Regular School Yes Other 06 11 2017   grade_8 1.0 71.0 17.0   0.0     1.0     0.0   45.0 45.0     *       42     28   90 1 71 17   0     1     0   45 45         42   28   90
950728 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 07 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
951260 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009004878 321200010318 IS 318 MATH, SCIENCE & TECH THRO ART public Regular School No Middle 06 08 2017   grade_8 1.0 27.0 66.0         0.0     0.0   50.0 44.0     *       90     *   94 1 27 66         0     0   50 44         90       94
951279 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005692 321200010341 ACCION ACADEMY public Regular School No Middle 06 08 2017   grade_8 0.0 10.0 23.0         1.0         14.0 20.0     *       29     9   34 0 10 23         1         14 20         29   9   34
951735 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_8 1.0 13.0 28.0   0.0     1.0     0.0   22.0 21.0     *       39     9   43 1 13 28   0     1     0   22 21         39   9   43
951830 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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
952001 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000228 30200010015 EAST MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 75.0 39.0 22.0         6.0     18.0   84.0 76.0     *       135     30   160 75 39 22         6     18   84 76         135   30   160
952096 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001119 30501040003 HARPURSVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_8 62.0 2.0 1.0   0.0     0.0     1.0   44.0 22.0     *       41     12   66 62 2 1   0     0     1   44 22         41   12   66
952115 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
952134 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838004570 30601060004 F P DONNELLY SCHOOL public Regular School No Elementary KG 05 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
952172 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 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
952210 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 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
952248 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 120.0 1.0 2.0   0.0     4.0     2.0   75.0 54.0     *       49     29   129 120 1 2   0     4     2   75 54         49   29   129
952305 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 172.0 7.0 5.0   0.0     2.0     4.0   76.0 114.0     *       68     28   190 172 7 5   0     2     4   76 114         68   28   190
952324 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001630 31101060006 MAINE-ENDWELL SENIOR HIGH SCHOOL public Regular School No High 09 12 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
952362 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 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
952457 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 203.0 25.0 30.0         6.0     18.0   154.0 128.0     *       *     40   282 203 25 30         6     18   154 128             40   282
952571 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001373 31502060005 JOHNSON CITY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 124.0 31.0 21.0         14.0     15.0   94.0 111.0     *       140     28   205 124 31 21         14     15   94 111         140   28   205
952704 NY Broome   school 3629610 31601060000   VESTAL 362961003985 31601060041 VESTAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 213.0 9.0 11.0   1.0     26.0     5.0   121.0 144.0     *       67     28   265 213 9 11   1     26     5   121 144         67   28   265
952742 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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
952780 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2017   grade_8 98.0 4.0 4.0         4.0     0.0   56.0 54.0     *       63     13   110 98 4 4         4     0   56 54         63   13   110
952856 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 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
952913 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_8 45.0 0.0 1.0         1.0     0.0   27.0 20.0     *       30     6   47 45 0 1         1     0   27 20         30   6   47
953084 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Elementary 04 08 2017   grade_8 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     *       0     *   1 1 0 0   0     0     0   1 0         0       1
953255 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2017   grade_8 3.0 2.0 1.0   0.0     0.0     0.0   6.0 0.0     *       *     6   6 3 2 1   0     0     0   6 0             6   6
953274 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_8 41.0 2.0 1.0   33.0     0.0     4.0   48.0 33.0     *       57     8   81 41 2 1   33     0     4   48 33         57   8   81
953293 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
953312 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA ELEMENTARY SCHOOL public Regular School No Elementary 04 07 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
953369 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
953388 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 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
953502 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_8 227.0 16.0 9.0   0.0     2.0     20.0   142.0 132.0     *       143     34   274 227 16 9   0     2     20   142 132         143   34   274
953635 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2017   grade_8 37.0 0.0 4.0   0.0     0.0     1.0   26.0 16.0     *       18     8   42 37 0 4   0     0     1   26 16         18   8   42
953749 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary 04 05 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
953768 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003936 51901040003 CAYUGA ELEMENTARY SCHOOL public Regular School No Elementary PK 03 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
953787 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003937 51901040005 UNION SPRINGS HIGH SCHOOL public Regular School No High 09 12 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
953882 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
953996 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
954167 NY Chautauqua   school 3604530 61001040000   BEMUS POINT 360453000199 61001040001 BEMUS POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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
954281 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 46.0 1.0 7.0   6.0           1.0   27.0 34.0     *       *     *   61 46 1 7   6           1   27 34                 61

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