enrollments

Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_7", state = "NY" and year = 2019 sorted by ell_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 4,719 ✖

grade ✖

  • grade_7 · 4,719 ✖
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
2139482 2139482 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 58.0 4.0         1.0     0.0   25.0 38.0     *       51     0   63 0 58 4         1     0   25 38         51   0   63
2139653 2139653 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 300.0 10.0 13.0         31.0     6.0   207.0 153.0     *       53     44   360 300 10 13         31     6   207 153         53   44   360
2139748 2139748 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139824 2139824 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139843 2139843 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 92.0 19.0 8.0   0.0     1.0     10.0   62.0 68.0     *       90     25   130 92 19 8   0     1     10   62 68         90   25   130
2139995 2139995 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 09 2019   grade_7 140.0 14.0 14.0   0.0     16.0     18.0   100.0 102.0     *       70     30   202 140 14 14   0     16     18   100 102         70   30   202
2140033 2140033 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2019   grade_7 3.0 5.0 4.0   0.0     6.0     3.0   9.0 12.0     *       9     6   21 3 5 4   0     6     3   9 12         9   6   21
2140356 2140356 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2140375 2140375 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2140394 2140394 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 60.0 1.0 4.0         1.0     3.0   32.0 37.0     *       6     9   69 60 1 4         1     3   32 37         6   9   69
2140584 2140584 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 50.0 0.0 0.0   0.0     0.0         23.0 27.0     *       28     5   50 50 0 0   0     0         23 27         28   5   50
2140679 2140679 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 25.0 0.0 0.0   0.0           0.0   12.0 13.0     *       14     *   25 25 0 0   0           0   12 13         14       25
2140698 2140698 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2019   grade_7 80.0 2.0 1.0   0.0     1.0     1.0   41.0 44.0     *       43     15   85 80 2 1   0     1     1   41 44         43   15   85
2141401 2141401 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No High 06 12 2019   grade_7 0.0 14.0 36.0   0.0     0.0         25.0 25.0     *       *     10   50 0 14 36   0     0         25 25             10   50
2141572 2141572 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2019   grade_7 1.0 35.0 47.0   2.0     0.0     0.0   51.0 34.0     *       72     19   85 1 35 47   2     0     0   51 34         72   19   85
2141629 2141629 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BGLIG-SHIRLEY RODRIGUEZ-REMENESKI CS charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 13.0 30.0   0.0     1.0     0.0     44.0     *       38     7   44 0 13 30   0     1     0     44         38   7   44
2141667 2141667 NY Bronx   school 3600960 320700860925   MOTT HAVEN ACADEMY CHARTER S 360096006013 320700860925 MOTT HAVEN ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary PK 07 2019   grade_7 0.0 19.0 32.0   0.0     0.0     0.0   25.0 26.0     *       49     12   51 0 19 32   0     0     0   25 26         49   12   51
2141705 2141705 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 20.0 19.0   1.0     0.0     0.0   18.0 22.0     *       37     *   40 0 20 19   1     0     0   18 22         37       40
2141819 2141819 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 17.0 57.0   0.0     0.0     0.0   35.0 39.0     *       64     7   74 0 17 57   0     0     0   35 39         64   7   74
2142199 2142199 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2019   grade_7 34.0 16.0 111.0   2.0     27.0     0.0   85.0 105.0     *       152     53   190 34 16 111   2     27     0   85 105         152   53   190
2142503 2142503 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505657 320800010337 SCHOOL FOR INQUIRY & SOCIAL JUSTICE public Regular School No Middle 06 08 2019   grade_7 1.0 43.0 118.0   2.0     1.0     0.0   96.0 69.0     *       132     43   165 1 43 118   2     1     0   96 69         132   43   165
2143016 2143016 NY Bronx   school 3600112 320800860872   GRAND CONCOURSE ACAD CHARTER 360011205672 320800860872 GRAND CONCOURSE ACAD CHARTER SCH charter Regular School Yes Elementary KG 08 2019   grade_7 1.0 19.0 26.0   0.0     1.0     1.0   14.0 34.0     *       44     5   48 1 19 26   0     1     1   14 34         44   5   48
2143054 2143054 NY Bronx   school 3600986 320800860940   GIRLS PREP CHARTER-BRONX 360098606161 320800860940 GIRLS PREP CHARTER SCH-BRONX charter Regular School Yes Elementary PK 08 2019   grade_7 1.0 27.0 39.0   1.0     0.0     1.0   0.0 69.0     *       60     16   69 1 27 39   1     0     1   0 69         60   16   69
2143510 2143510 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2019   grade_7 2.0 41.0 69.0   1.0     2.0     1.0   50.0 66.0     *       110     23   116 2 41 69   1     2     1   50 66         110   23   116
2143833 2143833 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605664 320900010323 BRONX WRITING ACADEMY public Regular School No Middle 06 08 2019   grade_7 1.0 38.0 83.0   1.0     2.0     0.0   66.0 59.0     *       117     41   125 1 38 83   1     2     0   66 59         117   41   125
2143966 2143966 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606113 320900010454 SCIENCE AND TECHNOLOGY ACADEMY public Regular School No Middle 06 08 2019   grade_7 0.0 43.0 101.0         8.0     0.0   79.0 73.0     *       139     *   152 0 43 101         8     0   79 73         139       152
2144099 2144099 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605670 320900011231 EAGLE ACADEMY FOR YOUNG MEN public Regular School No High 06 12 2019   grade_7 0.0 46.0 36.0   0.0     0.0     1.0   83.0       *       65     27   83 0 46 36   0     0     1   83           65   27   83
2144270 2144270 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No High 06 12 2019   grade_7 2.0 9.0 12.0   1.0     0.0         20.0 4.0     *       23     5   24 2 9 12   1     0         20 4         23   5   24
2144498 2144498 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_7 1.0 43.0 19.0   1.0     0.0     0.0   28.0 36.0     *       56     9   64 1 43 19   1     0     0   28 36         56   9   64
2144555 2144555 NY Bronx   school 3600956 320900860913   BRONX ACADEMY OF PROMISE CHA 360095606025 320900860913 BRONX ACADEMY OF PROMISE CHARTER SCH charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 29.0 35.0   0.0     2.0     0.0   38.0 28.0     *       63     5   66 0 29 35   0     2     0   38 28         63   5   66
2144707 2144707 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 2019   grade_7 0.0 13.0 16.0                   13.0 16.0     *       28     8   29 0 13 16                   13 16         28   8   29
2144783 2144783 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 2019   grade_7   9.0 51.0   0.0     0.0     0.0   26.0 34.0     *       46     11   60   9 51   0     0     0   26 34         46   11   60
2144916 2144916 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702202 321000010045 THOMAS C GIORDANO MS 45 public Regular School No Middle 06 08 2019   grade_7 9.0 33.0 172.0   1.0     4.0     1.0   115.0 105.0     *       *     *   220 9 33 172   1     4     1   115 105                 220
2145239 2145239 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704310 321000010206 IS 206 ANN MERSEREAU public Regular School No Middle 06 08 2019   grade_7 0.0 8.0 57.0   0.0     1.0         33.0 33.0     *       64     27   66 0 8 57   0     1         33 33         64   27   66
2145296 2145296 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705796 321000010225 THEATRE ARTS PROD COMPANY SCHOOL public Regular School No High 06 12 2019   grade_7 1.0 17.0 45.0   0.0     3.0         26.0 40.0     *       54     *   66 1 17 45   0     3         26 40         54       66
2145543 2145543 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702939 321000010315 PS 315 LAB SCHOOL public Regular School No Elementary KG 08 2019   grade_7 0.0 5.0 24.0         0.0     0.0   11.0 18.0     *       29     6   29 0 5 24         0     0   11 18         29   6   29
2146170 2146170 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701922 321000011445 BRONX HIGH SCHOOL OF SCIENCE public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2146493 2146493 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802100 321100010019 PS 19 JUDITH K WEISS public Regular School No Elementary KG 08 2019   grade_7 31.0 6.0 24.0   0.0     2.0     0.0   32.0 31.0     *       36     10   63 31 6 24   0     2     0   32 31         36   10   63
2147082 2147082 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806399 321100010355 BRONX ALLIANCE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 0.0 66.0 29.0   0.0     3.0         53.0 45.0     *       *     24   98 0 66 29   0     3         53 45             24   98
2147139 2147139 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2019   grade_7 2.0 56.0 30.0   0.0           0.0   44.0 44.0     *       66     19   88 2 56 30   0           0   44 44         66   19   88
2147215 2147215 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 2019   grade_7 14.0 8.0 62.0   0.0     8.0     0.0   42.0 50.0     *       79     19   92 14 8 62   0     8     0   42 50         79   19   92
2147291 2147291 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806322 321100010566 PELHAM GARDENS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 4.0 88.0 46.0   5.0     6.0     1.0   83.0 67.0     *       *     42   150 4 88 46   5     6     1   83 67             42   150
2147671 2147671 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 34.0 36.0         20.0     0.0   50.0 40.0     *       76     14   90 0 34 36         20     0   50 40         76   14   90
2147766 2147766 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2019   grade_7 2.0 18.0 8.0   0.0     0.0     1.0   11.0 18.0     *       21     *   29 2 18 8   0     0     1   11 18         21       29
2148241 2148241 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 2019   grade_7 1.0 22.0 41.0   0.0     1.0     1.0   34.0 32.0     *       56     20   66 1 22 41   0     1     1   34 32         56   20   66
2148773 2148773 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2019   grade_7 0.0 16.0 23.0   0.0     1.0     4.0   22.0 22.0     *       40     *   44 0 16 23   0     1     4   22 22         40       44
2148811 2148811 NY Bronx   school 3601027 321200860965   DR R IZQUIERDO HEALTH/SCIENC 360102706234 321200860965 DR R IZQUIERDO HEALTH/SCIENCE CHARTE charter Regular School Yes High 06 12 2019   grade_7 2.0 20.0 83.0   0.0     0.0     1.0   46.0 60.0     *       99     31   106 2 20 83   0     0     1   46 60         99   31   106
2148849 2148849 NY Bronx   school 3601066 321200861026   CHILDREN'S AID COLLEGE PREP 360106606303 321200861026 CHILDREN'S AID COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 07 2019   grade_7 0.0 35.0 33.0   1.0     1.0     0.0   35.0 35.0     *       55     15   70 0 35 33   1     1     0   35 35         55   15   70
2148887 2148887 NY Bronx   school 3601161 321200861108   NY CENTER FOR AUTISM CS - BR 360116106615 321200861108 NY CENTER FOR AUTISM CS - BRONX charter Special Education School Yes Elementary KG KG 2019   grade_7 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
2148906 2148906 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2148925 2148925 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2148944 2148944 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 101.0 2.0 5.0   0.0     0.0     2.0   56.0 54.0     *       44     18   110 101 2 5   0     0     2   56 54         44   18   110
2149077 2149077 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000228 30200010015 EAST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 61.0 58.0 40.0   1.0     4.0     25.0   91.0 98.0     *       159     40   189 61 58 40   1     4     25   91 98         159   40   189
2149096 2149096 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 78.0 49.0 22.0   0.0     9.0     16.0   87.0 87.0     *       120     26   174 78 49 22   0     9     16   87 87         120   26   174
2149191 2149191 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149229 2149229 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 96.0 3.0 3.0   0.0     2.0     8.0   55.0 57.0     *       55     14   112 96 3 3   0     2     8   55 57         55   14   112
2149248 2149248 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149305 2149305 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149324 2149324 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 116.0 1.0 4.0   0.0     2.0     4.0   65.0 62.0     *       69     26   127 116 1 4   0     2     4   65 62         69   26   127
2149381 2149381 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 10 2019   grade_7 162.0 3.0 8.0   0.0     1.0     4.0   85.0 93.0     *       76     40   178 162 3 8   0     1     4   85 93         76   40   178
2149438 2149438 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2149514 2149514 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   grade_7 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
2149533 2149533 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 171.0 23.0 24.0   1.0     6.0     33.0   134.0 124.0     *       145     40   258 171 23 24   1     6     33   134 124         145   40   258
2149647 2149647 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001373 31502060005 JOHNSON CITY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 119.0 12.0 21.0         11.0     18.0   87.0 94.0     *       127     23   181 119 12 21         11     18   87 94         127   23   181
2149723 2149723 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149780 2149780 NY Broome   school 3629610 31601060000   VESTAL 362961003985 31601060041 VESTAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 190.0 10.0 8.0   0.0     31.0     8.0   132.0 115.0     *       66     22   247 190 10 8   0     31     8   132 115         66   22   247
2149818 2149818 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2149856 2149856 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   grade_7 116.0 2.0 4.0         2.0     6.0   58.0 72.0     *       72     24   130 116 2 4         2     6   58 72         72   24   130
2149932 2149932 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150046 2150046 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150122 2150122 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150160 2150160 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2019   grade_7 104.0 6.0 4.0   3.0     4.0     8.0   70.0 59.0     *       78     26   129 104 6 4   3     4     8   70 59         78   26   129
2150331 2150331 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2019   grade_7 3.0 2.0 1.0   1.0           2.0   8.0 1.0     *       *     9   9 3 2 1   1           2   8 1             9   9
2150350 2150350 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 08 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150369 2150369 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150388 2150388 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 07 2019   grade_7 47.0 1.0 5.0   55.0     0.0     1.0   56.0 53.0     *       64     *   109 47 1 5   55     0     1   56 53         64       109
2150407 2150407 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150426 2150426 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 175.0 0.0 4.0         0.0     2.0   85.0 96.0     *       105     41   181 175 0 4         0     2   85 96         105   41   181
2150445 2150445 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150464 2150464 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150578 2150578 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_7 250.0 11.0 26.0         5.0     30.0   165.0 157.0     *       175     46   322 250 11 26         5     30   165 157         175   46   322
2150597 2150597 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150635 2150635 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2150654 2150654 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150673 2150673 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004435 50401040002 CATO-MERIDIAN MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 54.0 1.0 1.0         1.0     4.0   28.0 33.0     *       27     *   61 54 1 1         1     4   28 33         27       61
2150711 2150711 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2019   grade_7 37.0 1.0 9.0   0.0           2.0   25.0 24.0     *       25     6   49 37 1 9   0           2   25 24         25   6   49
2150787 2150787 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
2150806 2150806 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 71.0   1.0   1.0     1.0     1.0   40.0 35.0     *       38     14   75 71   1   1     1     1   40 35         38   14   75
2150825 2150825 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150882 2150882 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150901 2150901 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003755 60201060006 SOUTHWESTERN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 102.0 2.0 8.0         4.0     5.0   65.0 56.0     *       49     18   121 102 2 8         4     5   65 56         49   18   121
2150939 2150939 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150958 2150958 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000917 60301040004 FREWSBURG JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   grade_7 54.0 0.0 2.0   0.0     0.0     2.0   26.0 32.0     *       27     11   58 54 0 2   0     0     2   26 32         27   11   58
2150977 2150977 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000453 60401040003 SINCLAIRVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2151053 2151053 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0 0 0 0   0           0   0 0         0   0   0
2151072 2151072 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003232 60601040003 PINE VALLEY CENTRAL JR-SR HIGH SCH public Regular School No High 07 12 2019   grade_7 41.0 1.0 1.0   1.0           0.0   30.0 14.0     *       28     12   44 41 1 1   1           0   30 14         28   12   44
2151262 2151262 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   grade_7 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2151319 2151319 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003666 61501040001 SILVER CREEK HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2151338 2151338 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 58.0 1.0 9.0   12.0           4.0   45.0 39.0     *       51     18   84 58 1 9   12           4   45 39         51   18   84
2151414 2151414 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2019   grade_7 35.0   0.0               0.0   13.0 22.0     *       19     6   35 35   0               0   13 22         19   6   35

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