enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
942424 942424 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_7 1.0 58.0 3.0         1.0         34.0 29.0     *       53     0   63 1 58 3         1         34 29         53   0   63
942595 942595 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 316.0 7.0 12.0         24.0     1.0   167.0 193.0     *       54     41   360 316 7 12         24     1   167 193         54   41   360
942652 942652 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS 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
942671 942671 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER 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
942766 942766 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES 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
942975 942975 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_7 8.0 6.0 0.0   0.0     8.0     0.0   7.0 15.0     *       9     *   22 8 6 0   0     8     0   7 15         9       22
943108 943108 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_7 326.0 20.0 21.0   2.0     45.0     13.0   229.0 198.0     *       81     60   427 326 20 21   2     45     13   229 198         81   60   427
943146 943146 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_7 22.0 1.0 0.0         1.0     2.0   13.0 13.0     *       16     5   26 22 1 0         1     2   13 13         16   5   26
943165 943165 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 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
943260 943260 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 292.0 10.0 8.0   0.0     60.0     18.0   190.0 198.0     *       66     57   388 292 10 8   0     60     18   190 198         66   57   388
943298 943298 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 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
943317 943317 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON 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
943374 943374 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 52.0 17.0 11.0   0.0     6.0     5.0   56.0 35.0     *       62     13   91 52 17 11   0     6     5   56 35         62   13   91
943564 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
943602 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
943659 943659 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE 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         0   0   0
944020 944020 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 MS 223 LAB SCHOOL OF FIN & TECH public Regular School No Other 06 12 2017   grade_7 1.0 22.0 78.0   1.0     0.0     0.0   58.0 44.0     *       94     27   102 1 22 78   1     0     0   58 44         94   27   102
944096 944096 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2017   grade_7 1.0 13.0 57.0               0.0   43.0 28.0     *       *     15   71 1 13 57               0   43 28             15   71
944533 944533 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_7 1.0 42.0 36.0   0.0     0.0     0.0   41.0 38.0     *       69     10   79 1 42 36   0     0     0   41 38         69   10   79
944590 944590 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BGLIG-SHIRLEY RODRIGUEZ-REMENESKI CS charter Regular School Yes Elementary KG 08 2017   grade_7 1.0 11.0 35.0   0.0     0.0     0.0     47.0     *       38     8   47 1 11 35   0     0     0     47         38   8   47
944989 944989 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_7 45.0 8.0 109.0   2.0     20.0     1.0   92.0 93.0     *       138     38   185 45 8 109   2     20     1   92 93         138   38   185
945084 945084 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_7 34.0 13.0 85.0   2.0     19.0     0.0   80.0 73.0     *       *     *   153 34 13 85   2     19     0   80 73                 153
945141 945141 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502456 320800010123 JHS 123 JAMES M KIERNAN public Regular School No Middle 06 08 2017   grade_7 0.0 21.0 61.0   0.0     2.0         35.0 49.0     *       69     33   84 0 21 61   0     2         35 49         69   33   84
945160 945160 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502463 320800010125 JHS 125 HENRY HUDSON public Regular School No Middle 06 08 2017   grade_7 12.0 12.0 65.0   2.0     19.0     0.0   61.0 49.0     *       *     *   110 12 12 65   2     19     0   61 49                 110
945312 945312 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505121 320800010301 MS 301 PAUL L DUNBAR public Regular School No Middle 06 08 2017   grade_7 3.0 25.0 46.0                   37.0 37.0     *       60     23   74 3 25 46                   37 37         60   23   74
945350 945350 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_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
945559 945559 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 4.0 13.0 47.0   2.0     24.0         46.0 44.0     *       *     20   90 4 13 47   2     24         46 44             20   90
945749 945749 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_7 2.0 6.0 35.0   1.0     5.0         23.0 26.0     *       37     14   49 2 6 35   1     5         23 26         37   14   49
945882 945882 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_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
946015 946015 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_7 0.0 38.0 60.0   1.0     0.0     0.0   0.0 99.0     *       81     20   99 0 38 60   1     0     0   0 99         81   20   99
946072 946072 NY Bronx   school 3601091 320800861030   ICAHN CHARTER SCHOOL 7 360109106389 320800861030 ICAHN CHARTER SCHOOL 7 charter Regular School Yes Elementary KG 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   0
946471 946471 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_7   59.0 61.0   1.0     1.0     0.0   52.0 70.0     *       112     21   122   59 61   1     1     0   52 70         112   21   122
946642 946642 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603747 320900010219 IS 219 NEW VENTURE SCHOOL public Regular School No Middle 06 08 2017   grade_7 1.0 40.0 59.0   1.0     0.0         53.0 48.0     *       91     29   101 1 40 59   1     0         53 48         91   29   101
946889 946889 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603780 320900010339 IS 339 public Regular School No Middle 06 08 2017   grade_7 2.0 43.0 103.0   0.0     1.0         94.0 55.0     *       139     39   149 2 43 103   0     1         94 55         139   39   149
947060 947060 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605670 320900011231 EAGLE ACADEMY FOR YOUNG MEN public Regular School No Other 06 12 2017   grade_7 0.0 29.0 25.0   1.0     1.0     1.0   57.0       *       52     *   57 0 29 25   1     1     1   57           52       57
947364 947364 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602961 320900011505 BRONX SCHOOL FOR LAW, GOV, JUSTICE public Regular School No Other 06 12 2017   grade_7 0.0 32.0 57.0   0.0     0.0     0.0   44.0 45.0     *       *     22   89 0 32 57   0     0     0   44 45             22   89
947478 947478 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 48.0 25.0   0.0     0.0     0.0   39.0 34.0     *       50     13   73 0 48 25   0     0     0   39 34         50   13   73
947497 947497 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 17.0 14.0   0.0     0.0         18.0 13.0     *       26     *   31 0 17 14   0     0         18 13         26       31
947516 947516 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_7 0.0 13.0 38.0   0.0     0.0     0.0   25.0 26.0     *       44     7   51 0 13 38   0     0     0   25 26         44   7   51
947554 947554 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Elementary KG 08 2017   grade_7 1.0 20.0 31.0   1.0     0.0     0.0   23.0 30.0     *       45     11   53 1 20 31   1     0     0   23 30         45   11   53
947592 947592 NY Bronx   school 3601071 320900861004   MOTT HALL CHARTER SCHOOL 360107106328 320900861004 MOTT HALL CHARTER SCHOOL charter Regular School Yes Middle 06 08 2017   grade_7 0.0 36.0 67.0   2.0     1.0         60.0 46.0     *       102     25   106 0 36 67   2     1         60 46         102   25   106
947668 947668 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705137 321000010003 PS 3 RAUL JULIA MICRO SOCIETY public Regular School No Elementary PK 08 2017   grade_7 0.0 12.0 24.0   0.0     2.0         25.0 13.0     *       35     12   38 0 12 24   0     2         25 13         35   12   38
947744 947744 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_7 0.0 5.0 54.0   0.0     1.0     0.0   30.0 30.0     *       37     14   60 0 5 54   0     1     0   30 30         37   14   60
948257 948257 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_7 2.0 17.0 35.0   1.0     1.0     1.0   18.0 39.0     *       39     12   57 2 17 35   1     1     1   18 39         39   12   57
948295 948295 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705797 321000010228 JONAS BRONCK ACADEMY public Regular School No Middle 06 08 2017   grade_7 2.0 12.0 67.0   1.0     5.0     2.0   41.0 48.0     *       80     14   89 2 12 67   1     5     2   41 48         80   14   89
948390 948390 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704695 321000010280 PS/MS 280 MOSHOLU PARKWAY public Regular School No Elementary KG 08 2017   grade_7 11.0 10.0 66.0   1.0     14.0         61.0 41.0     *       91     29   102 11 10 66   1     14         61 41         91   29   102
948523 948523 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705675 321000010331 BRONX SCHOOL OF YOUNG LEADERS (THE) public Regular School No Middle 06 08 2017   grade_7 1.0 17.0 93.0         1.0         52.0 60.0     *       86     24   112 1 17 93         1         52 60         86   24   112
948694 948694 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703812 321000010391 ANGELO PATRI MIDDLE SCHOOL (THE) public Regular School No Middle 06 08 2017   grade_7 2.0 35.0 136.0   2.0     3.0         94.0 84.0     *       149     58   178 2 35 136   2     3         94 84         149   58   178
949321 949321 NY Bronx   school 3600968 321000860914   BRONX COMMUNITY CHARTER SCHO 360096806074 321000860914 BRONX COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 07 2017   grade_7 3.0 11.0 35.0         1.0     0.0   24.0 26.0     *       *     7   50 3 11 35         1     0   24 26             7   50
949435 949435 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_7 27.0 1.0 18.0   0.0     2.0     0.0   24.0 24.0     *       26     12   48 27 1 18   0     2     0   24 24         26   12   48
949929 949929 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_7 8.0 174.0 96.0   3.0     12.0     1.0   147.0 147.0     *       228     71   294 8 174 96   3     12     1   147 147         228   71   294
950043 950043 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806399 321100010355 BRONX ALLIANCE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 3.0 73.0 39.0   1.0     6.0         69.0 53.0     *       98     29   122 3 73 39   1     6         69 53         98   29   122
950100 950100 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_7 4.0 64.0 24.0   1.0     0.0         49.0 44.0     *       74     24   93 4 64 24   1     0         49 44         74   24   93
950119 950119 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806129 321100010468 PELHAM ACAD-ACADEMICS AND COMMUNITY public Regular School No Middle 06 08 2017   grade_7 13.0 14.0 64.0   1.0     4.0         51.0 45.0     *       *     16   96 13 14 64   1     4         51 45             16   96
950157 950157 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_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
950214 950214 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806249 321100010532 BAYCHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 1.0 71.0 24.0   3.0     0.0     1.0   58.0 42.0     *       84     *   100 1 71 24   3     0     1   58 42         84       100
950632 950632 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 42.0 32.0   1.0     16.0     0.0   44.0 47.0     *       73     9   91 0 42 32   1     16     0   44 47         73   9   91
950689 950689 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 21.0 13.0   0.0     0.0     0.0   14.0 20.0     *       26     *   34 0 21 13   0     0     0   14 20         26       34
950727 950727 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 07 2017   grade_7 1.0 21.0 8.0         0.0     0.0   12.0 18.0     *       20     *   30 1 21 8         0     0   12 18         20       30
951164 951164 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005690 321200010273 FREDERICK DOUGLASS ACAD V MIDDLE SCH public Regular School No Middle 06 08 2017   grade_7 1.0 24.0 55.0   1.0     1.0         42.0 40.0     *       71     22   82 1 24 55   1     1         42 40         71   22   82
951278 951278 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005692 321200010341 ACCION ACADEMY public Regular School No Middle 06 08 2017   grade_7 1.0 10.0 39.0         2.0         31.0 21.0     *       44     18   52 1 10 39         2         31 21         44   18   52
951734 951734 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_7 0.0 16.0 29.0   0.0     1.0     0.0   23.0 23.0     *       40     13   46 0 16 29   0     1     0   23 23         40   13   46
951829 951829 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS 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         0   0   0
952095 952095 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001119 30501040003 HARPURSVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_7 65.0 1.0 0.0   2.0     1.0     0.0   35.0 34.0     *       46     13   69 65 1 0   2     1     0   35 34         46   13   69
952114 952114 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary KG 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
952133 952133 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838004570 30601060004 F P DONNELLY SCHOOL public Regular School No Elementary KG 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   0
952171 952171 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH 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
952209 952209 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 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   0
952247 952247 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 109.0 1.0 2.0   0.0     1.0     3.0   67.0 49.0     *       50     21   116 109 1 2   0     1     3   67 49         50   21   116
952304 952304 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 182.0 6.0 2.0   0.0     4.0     3.0   101.0 96.0     *       89     30   197 182 6 2   0     4     3   101 96         89   30   197
952323 952323 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001630 31101060006 MAINE-ENDWELL SENIOR 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
952361 952361 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR 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
952456 952456 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 170.0 30.0 17.0         6.0     23.0   124.0 122.0     *       146     *   246 170 30 17         6     23   124 122         146       246
952570 952570 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001373 31502060005 JOHNSON CITY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 107.0 32.0 14.0         9.0     16.0   82.0 96.0     *       132     26   178 107 32 14         9     16   82 96         132   26   178
952741 952741 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL 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
952779 952779 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2017   grade_7 115.0 3.0 3.0         1.0     2.0   67.0 57.0     *       62     18   124 115 3 3         1     2   67 57         62   18   124
952855 952855 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY 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         0   0   0
952912 952912 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_7 49.0 0.0 1.0         0.0     0.0   22.0 28.0     *       26     8   50 49 0 1         0     0   22 28         26   8   50
953083 953083 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Elementary 04 08 2017   grade_7 141.0 12.0 0.0   0.0     4.0     9.0   80.0 86.0     *       *     27   166 141 12 0   0     4     9   80 86             27   166
953254 953254 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2017   grade_7 3.0 1.0 0.0   1.0     0.0     0.0   4.0 1.0     *       0     5   5 3 1 0   1     0     0   4 1         0   5   5
953273 953273 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 51.0 2.0 3.0   37.0     1.0     2.0   43.0 53.0     *       70     11   96 51 2 3   37     1     2   43 53         70   11   96
953292 953292 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
953311 953311 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA ELEMENTARY SCHOOL public Regular School No Elementary 04 07 2017   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 1 0 0   0     0     0   0 1                 1
953368 953368 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
953387 953387 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR 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
953501 953501 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_7 241.0 20.0 13.0   1.0     1.0     26.0   153.0 149.0     *       298     38   302 241 20 13   1     1     26   153 149         298   38   302
953634 953634 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2017   grade_7 46.0 0.0 6.0   0.0     0.0     3.0   31.0 24.0     *       28     10   55 46 0 6   0     0     3   31 24         28   10   55
953748 953748 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY 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
953767 953767 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003936 51901040003 CAYUGA ELEMENTARY SCHOOL public Regular School No Elementary PK 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
953786 953786 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003937 51901040005 UNION SPRINGS 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
953881 953881 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON 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 0         0   0   0
953995 953995 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY 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   0
954166 954166 NY Chautauqua   school 3604530 61001040000   BEMUS POINT 360453000199 61001040001 BEMUS POINT 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
954280 954280 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 63.0 1.0 6.0   9.0           8.0   35.0 52.0     *       58     24   87 63 1 6   9           8   35 52         58   24   87
954451 954451 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001353 61700010007 MILTON J FLETCHER ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
954508 954508 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001352 61700010011 ABRAHAM LINCOLN ELEM SCHOOL public Regular School No Elementary PK 04 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
954527 954527 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001356 61700010012 GEORGE WASHINGTON MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 68.0 6.0 22.0   0.0     0.0     23.0   63.0 56.0     *       90     17   119 68 6 22   0     0     23   63 56         90   17   119
954584 954584 NY Chautauqua   school 3611520 62201060000   FREDONIA 361152000908 62201060002 FREDONIA MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 85.0 1.0 9.0         1.0     3.0   60.0 39.0     *       40     *   99 85 1 9         1     3   60 39         40       99
954622 954622 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000288 62301040002 BROCTON 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
954641 954641 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000289 62301040003 BROCTON MIDDLE HIGH SCHOOL public Regular School No Other 06 12 2017   grade_7 43.0   1.0   0.0     0.0     1.0   22.0 23.0     *       27     9   45 43   1   0     0     1   22 23         27   9   45

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