Data source: Big Local News · About: Big Local

4,741 rows where grade = "grade_7", state = "NY" and year = 2021 sorted by ell_int

View and edit SQL

year

  • 2021 · 4,741

grade

  • grade_7 · 4,741
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
1433213 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2021   grade_7 5.0 56.0 12.0   0.0     3.0     4.0   37.0 43.0     *       74     *   80 5 56 12   0     3     4   37 43         74       80
1433327 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 78.0 9.0   0.0     1.0     0.0   40.0 48.0     *       63     *   88 0 78 9   0     1     0   40 48         63       88
1433403 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1433460 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1433498 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 273.0 9.0 9.0         35.0     7.0   169.0 164.0     *       62     44   333 273 9 9         35     7   169 164         62   44   333
1433555 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1433612 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 05 08 2021   grade_7 117.0 10.0 13.0         2.0     5.0   75.0 72.0     *       62     32   147 117 10 13         2     5   75 72         62   32   147
1433650 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1433688 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 110.0 9.0 12.0   0.0     0.0     9.0   75.0 65.0     *       99     23   140 110 9 12   0     0     9   75 65         99   23   140
1433726 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1433821 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1433859 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 89.0 9.0 9.0         14.0     15.0   68.0 68.0     *       41     17   136 89 9 9         14     15   68 68         41   17   136
1433878 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2021   grade_7 5.0 14.0 3.0   0.0     6.0     2.0   18.0 12.0     *       15     *   30 5 14 3   0     6     2   18 12         15       30
1434201 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1434239 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 67.0 0.0 4.0         3.0     3.0   26.0 51.0     *       14     7   77 67 0 4         3     3   26 51         14   7   77
1434372 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2021   grade_7 26.0 0.0 0.0               2.0   10.0 18.0     *       10     5   28 26 0 0               2   10 18         10   5   28
1434429 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 39.0 1.0 2.0   1.0     1.0     0.0   23.0 21.0     *       26     5   44 39 1 2   1     1     0   23 21         26   5   44
1434448 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 4.0   1.0                   3.0 2.0     *       *     0   5 4   1                   3 2             0   5
1434486 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1434562 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1435246 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No High 06 12 2021   grade_7 1.0 14.0 50.0   0.0     1.0     0.0   38.0 28.0     *       56     18   66 1 14 50   0     1     0   38 28         56   18   66
1435379 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406714 320700011625 WALKABOUT BRONX HIGH SCHOOL public Regular School No Secondary 09 09 2021   grade_7   0.0 0.0                   0.0 0.0     *       0     0   0   0 0                   0 0         0   0   0
1435417 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_7 2.0 44.0 45.0   0.0     0.0     0.0   42.0 49.0     *       85     16   91 2 44 45   0     0     0   42 49         85   16   91
1435455 NY Bronx   school 3600144 320700860889   SOUTH BRONX CHARTER SCHOOL 360014405787 320700860889 SOUTH BRONX CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_7 2.0 4.0 29.0   0.0     0.0         12.0 23.0     *       *     *   35 2 4 29   0     0         12 23                 35
1435512 NY Bronx   school 3600960 320700860925   MOTT HAVEN ACADEMY CHARTER S 360096006013 320700860925 MOTT HAVEN ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2021   grade_7 0.0 11.0 36.0   1.0     0.0     0.0   20.0 28.0     *       46     11   48 0 11 36   1     0     0   20 28         46   11   48
1435588 NY Bronx   school 3601115 320700860994   BOYS PREP CHARTER SCHOOL OF 360111506454 320700860994 BOYS PREP CHARTER SCHOOL OF NY charter Regular School Yes Elementary PK 07 2021   grade_7 0.0 25.0 31.0   1.0     0.0     0.0   57.0 0.0     *       *     18   57 0 25 31   1     0     0   57 0             18   57
1435626 NY Bronx   school 3601108 320700861014   BRILLA COLLEGE PREP CHARTER 360110806384 320700861014 BRILLA COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 21.0 66.0   1.0     0.0     0.0   39.0 49.0     *       79     23   88 0 21 66   1     0     0   39 49         79   23   88
1435949 NY Bronx   school 3601197 320700861173   UNIVERSITY PREP CHARTER MIDD 360119706707 320700861173 UNIVERSITY PREP CHARTER MIDDLE SCHOO charter Regular School Yes Middle 05 07 2021   grade_7 1.0 52.0 55.0   3.0     0.0     1.0   56.0 56.0     *       105     25   112 1 52 55   3     0     1   56 56         105   25   112
1435987 NY Bronx   school 3601218 320700861181   ZETA CHARTER SCHOOL - NYC 3 360121806716 320700861181 ZETA CHARTER SCHOOL - BRONX 3 charter Regular School Yes Elementary KG KG 2021   grade_7 0.0 0.0 0.0   0.0               0.0 0.0     *       0     0   0 0 0 0   0               0 0         0   0   0
1436006 NY Bronx   school 3601219 320700861182   ZETA CHARTER SCHOOL - NYC 4 360121906717 320700861182 ZETA CHARTER SCHOOL - BRONX 2 charter Regular School Yes Elementary KG KG 2021   grade_7   0.0 0.0               0.0   0.0 0.0     *       0     0   0   0 0               0   0 0         0   0   0
1436215 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2021   grade_7 20.0 16.0 119.0   4.0     23.0     3.0   95.0 90.0     *       125     47   185 20 16 119   4     23     3   95 90         125   47   185
1436804 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505985 320800011367 ARCHIMEDES ACAD-MATH, SCI, TECH public Regular School No High 06 12 2021   grade_7 2.0 24.0 49.0   2.0     7.0         46.0 38.0     *       65     21   84 2 24 49   2     7         46 38         65   21   84
1437013 NY Bronx   school 3600063 320800860846   BRONX CHARTER SCHOOL-ARTS 360006304875 320800860846 BRONX CHARTER SCHOOL FOR THE ARTS charter Regular School Yes Elementary KG 08 2021   grade_7 1.0 36.0 62.0   2.0     2.0     1.0   49.0 55.0     *       97     20   104 1 36 62   2     2     1   49 55         97   20   104
1437032 NY Bronx   school 3600112 320800860872   GRAND CONCOURSE ACAD CHARTER 360011205672 320800860872 GRAND CONCOURSE ACAD CHARTER SCH charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 17.0 27.0   1.0     0.0     0.0   21.0 24.0     *       40     13   45 0 17 27   1     0     0   21 24         40   13   45
1437070 NY Bronx   school 3600986 320800860940   GIRLS PREP CHARTER-BRONX 360098606161 320800860940 GIRLS PREP CHARTER SCH-BRONX charter Regular School Yes Elementary PK 08 2021   grade_7 0.0 29.0 45.0   0.0     0.0     0.0   0.0 74.0     *       60     18   74 0 29 45   0     0     0   0 74         60   18   74
1438096 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606345 320900010568 YOUNG WOMEN'S LDSHP SCHOOL-BRONX public Regular School No High 06 12 2021   grade_7 1.0 24.0 53.0   0.0     2.0     1.0     81.0     *       69     14   81 1 24 53   0     2     1     81         69   14   81
1438305 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605865 320900011324 BRONX EARLY COL ACAD-TEACH/LEARN public Regular School No High 06 12 2021   grade_7 0.0 15.0 36.0   0.0     0.0     0.0   28.0 23.0     *       44     12   51 0 15 36   0     0     0   28 23         44   12   51
1438343 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No High 07 12 2021   grade_7 0.0 0.0 1.0   0.0     0.0         0.0 1.0     *       *     *   1 0 0 1   0     0         0 1                 1
1438647 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Other KG 12 2021   grade_7 0.0 18.0 35.0   1.0     0.0         27.0 27.0     *       49     7   54 0 18 35   1     0         27 27         49   7   54
1438780 NY Bronx   school 3601220 320900861174   WILDFLOWER NEW YORK CHARTER 360122006718 320900861174 WILDFLOWER NEW YORK CHARTER SCHOOL charter Regular School Yes Elementary PK 01 2021   grade_7   0.0 0.0                   0.0 0.0     *       0     *   0   0 0                   0 0         0       0
1438799 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 2021   grade_7 1.0 4.0 30.0                   16.0 19.0     *       35     11   35 1 4 30                   16 19         35   11   35
1439635 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702939 321000010315 PS 315 LAB SCHOOL public Regular School No Elementary KG 08 2021   grade_7 1.0 6.0 18.0   1.0     1.0     0.0   15.0 12.0     *       24     7   27 1 6 18   1     1     0   15 12         24   7   27
1439654 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 2021   grade_7 5.0 34.0 100.0   1.0     4.0     0.0   62.0 82.0     *       *     47   144 5 34 100   1     4     0   62 82             47   144
1440262 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701922 321000011445 BRONX HIGH SCHOOL OF SCIENCE public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1440661 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802100 321100010019 PS 19 JUDITH K WEISS public Regular School No Elementary PK 08 2021   grade_7 39.0 4.0 21.0   0.0     2.0     0.0   39.0 27.0     *       26     17   66 39 4 21   0     2     0   39 27         26   17   66
1441098 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802613 321100010175 PS 175 CITY ISLAND public Regular School No Elementary KG 08 2021   grade_7 6.0 4.0 12.0   0.0     2.0     1.0   13.0 12.0     *       14     7   25 6 4 12   0     2     1   13 12         14   7   25
1441307 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2021   grade_7 1.0 53.0 15.0   1.0     1.0     1.0   38.0 34.0     *       58     17   72 1 53 15   1     1     1   38 34         58   17   72
1441402 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806259 321100010529 ONE WORLD MS AT EDENWALD public Regular School No Middle 06 08 2021   grade_7 1.0 69.0 40.0   4.0     1.0         62.0 53.0     *       103     25   115 1 69 40   4     1         62 53         103   25   115
1441839 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 33.0 31.0   1.0     24.0     0.0   37.0 52.0     *       59     10   89 0 33 31   1     24     0   37 52         59   10   89
1441877 NY Bronx   school 3600955 321100860917   ICAHN CHARTER SCHOOL 3 360095506027 321100860917 ICAHN CHARTER SCHOOL 3 charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 15.0 10.0   0.0     1.0     0.0   15.0 11.0     *       18     *   26 0 15 10   0     1     0   15 11         18       26
1441934 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2021   grade_7 2.0 21.0 8.0   0.0     2.0     0.0   17.0 16.0     *       27     *   33 2 21 8   0     2     0   17 16         27       33
1442029 NY Bronx   school 3601223 321100861163   CAPITAL PREPARATORY BRONX CH 360122306721 321100861163 CAPITAL PREPARATORY BRONX CHARTER charter Regular School Yes Middle 06 07 2021   grade_7 1.0 45.0 7.0         1.0     7.0   26.0 35.0     *       33     7   61 1 45 7         1     7   26 35         33   7   61
1442675 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005689 321200011267 BRONX LATIN SCHOOL public Regular School No High 06 12 2021   grade_7 1.0 13.0 49.0   1.0     0.0     0.0   34.0 30.0     *       59     17   64 1 13 49   1     0     0   34 30         59   17   64
1442941 NY Bronx   school 3600161 321200860898   SOUTH BRONX CLASSICAL CHARTE 360016105893 321200860898 SOUTH BRONX CLASSICAL CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_7 0.0 18.0 21.0   0.0     0.0     0.0   16.0 23.0     *       34     *   39 0 18 21   0     0     0   16 23         34       39
1442998 NY Bronx   school 3601066 321200861026   CHILDREN'S AID COLLEGE PREP 360106606303 321200861026 CHILDREN'S AID COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 08 2021   grade_7 1.0 19.0 40.0   0.0     2.0     0.0   33.0 29.0     *       55     13   62 1 19 40   0     2     0   33 29         55   13   62
1443036 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2021   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1443055 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1443074 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1443093 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 92.0 0.0 3.0         1.0     6.0   62.0 40.0     *       41     16   102 92 0 3         1     6   62 40         41   16   102
1443112 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000224 30200010002 CALVIN COOLIDGE SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0 0 0 0   0           0   0 0         0   0   0
1443169 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000230 30200010011 MACARTHUR SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1443226 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000228 30200010015 EAST MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 63.0 56.0 30.0   1.0     5.0     22.0   91.0 86.0     *       147     41   177 63 56 30   1     5     22   91 86         147   41   177
1443245 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 77.0 49.0 21.0   0.0     7.0     24.0   81.0 97.0     *       131     36   178 77 49 21   0     7     24   81 97         131   36   178
1443378 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 91.0 1.0 5.0         2.0     4.0   52.0 51.0     *       57     17   103 91 1 5         2     4   52 51         57   17   103
1443397 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1443416 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000517 30701060001 CHENANGO VALLEY HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1443435 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1443454 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1443473 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 116.0 2.0 4.0   2.0     2.0     7.0   64.0 69.0     *       50     29   133 116 2 4   2     2     7   64 69         50   29   133
1443530 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 170.0 5.0 11.0   1.0     2.0     9.0   100.0 98.0     *       78     34   198 170 5 11   1     2     9   100 98         78   34   198
1443568 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 08 2021   grade_7 107.0 1.0 2.0   1.0     1.0     1.0   56.0 57.0     *       70     28   113 107 1 2   1     1     1   56 57         70   28   113
1443682 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 180.0 27.0 31.0         3.0     36.0   130.0 147.0     *       148     29   277 180 27 31         3     36   130 147         148   29   277
1443739 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000845 31501060014 ANN G MCGUINNESS ELEMENTARY public Regular School No Elementary KG 05 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1443929 NY Broome   school 3629610 31601060000   VESTAL 362961003985 31601060041 VESTAL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 182.0 10.0 16.0   0.0     34.0     14.0   127.0 129.0     *       93     26   256 182 10 16   0     34     14   127 129         93   26   256
1443967 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1443986 NY Broome   school 3602730 31701060000   WINDSOR 360273000047 31701060003 C R WEEKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1444005 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2021   grade_7 97.0 1.0 7.0   0.0     3.0     6.0   61.0 53.0     *       70     19   114 97 1 7   0     3     6   61 53         70   19   114
1444062 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500053 40302060001 ALLEGANY-LIMESTONE MIDDLE-HIGH public Regular School No High 06 12 2021   grade_7 71.0 0.0 0.0         1.0     5.0   38.0 39.0     *       33     *   77 71 0 0         1     5   38 39         33       77
1444081 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1444138 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 06 12 2021   grade_7 40.0   0.0   1.0     1.0     1.0   21.0 22.0     *       20     8   43 40   0   1     1     1   21 22         20   8   43
1444157 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1444195 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1444252 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003083 42400010002 WASHINGTON WEST ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1444271 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1444309 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 04 07 2021   grade_7 113.0 10.0 12.0   0.0     3.0     13.0   72.0 79.0     *       86     38   151 113 10 12   0     3     13   72 79         86   38   151
1444537 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 08 2021   grade_7 48.0 1.0 6.0   36.0     1.0     4.0   57.0 39.0     *       61     14   96 48 1 6   36     1     4   57 39         61   14   96
1444613 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1444632 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1444746 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2021   grade_7 267.0 16.0 13.0         3.0     39.0   180.0 158.0     *       195     51   338 267 16 13         3     39   180 158         195   51   338
1444784 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004095 50301040002 WEEDSPORT JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 64.0   2.0   0.0     0.0     1.0   29.0 38.0     *       15     *   67 64   2   0     0     1   29 38         15       67
1444803 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1444822 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1444841 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669000455 50401040003 CATO-MERIDIAN JUNIOR-SENIOR HS public Regular School No High 07 12 2021   grade_7 61.0 0.0 2.0   0.0     0.0     2.0   29.0 36.0     *       31     *   65 61 0 2   0     0     2   29 36         31       65
1444860 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2021   grade_7 42.0   3.0   2.0     2.0     2.0   31.0 20.0     *       22     12   51 42   3   2     2     2   31 20         22   12   51
1444936 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0   0.0               0.0   0.0 0.0     *       0     0   0 0   0               0   0 0         0   0   0
1444955 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2021   grade_7 69.0 0.0 1.0   0.0     0.0     1.0   30.0 41.0     *       29     16   71 69 0 1   0     0     1   30 41         29   16   71
1444974 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0         0 0 0 0         0     0   0 0         0       0
1445012 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925006575 51901040006 UNION SPRINGS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 62.0 2.0 5.0         0.0     1.0   39.0 31.0     *       34         70 62 2 5         0     1   39 31         34       70
1445031 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1445088 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_7 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0

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