Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_6", state = "NY" and year = 2020 sorted by ell_int

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_6 · 4,742
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
1523101 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2020   grade_6 6.0 29.0 12.0   0.0     7.0     3.0   30.0 27.0     *       29     *   57 6 29 12   0     7     3   30 27         29       57
1523120 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_6 22.0 15.0 7.0   0.0     3.0     0.0   20.0 27.0     *       25     *   47 22 15 7   0     3     0   20 27         25       47
1523139 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2020   grade_6 9.0 33.0 8.0   0.0     13.0     5.0   30.0 38.0     *       47     *   68 9 33 8   0     13     5   30 38         47       68
1523291 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2020   grade_6 3.0 57.0 15.0   0.0     3.0     4.0   45.0 37.0     *       65     *   82 3 57 15   0     3     4   45 37         65       82
1523405 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_6 0.0 62.0 6.0         1.0     0.0   32.0 37.0     *       61     *   69 0 62 6         1     0   32 37         61       69
1523481 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   grade_6 57.0 0.0 0.0         0.0     2.0   30.0 29.0     *       21     9   59 57 0 0         0     2   30 29         21   9   59
1523538 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1523576 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 281.0 10.0 9.0         32.0     5.0   172.0 165.0     *       59     50   337 281 10 9         32     5   172 165         59   50   337
1523747 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1523766 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 115.0 10.0 8.0   0.0     1.0     8.0   77.0 65.0     *       132     23   142 115 10 8   0     1     8   77 65         132   23   142
1523804 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1523880 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1523899 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1523918 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_6 124.0 11.0 19.0         24.0     10.0   89.0 99.0     *       87     34   188 124 11 19         24     10   89 99         87   34   188
1523956 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2020   grade_6 6.0 10.0 2.0   0.0     7.0     2.0   16.0 11.0     *       15     *   27 6 10 2   0     7     2   16 11         15       27
1523975 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2020   grade_6 44.0 6.0 3.0   0.0     19.0     8.0   41.0 39.0     *       19     11   80 44 6 3   0     19     8   41 39         19   11   80
1523994 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2020   grade_6 48.0 5.0 4.0   0.0     25.0     1.0   37.0 46.0     *       14     9   83 48 5 4   0     25     1   37 46         14   9   83
1524013 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2020   grade_6 48.0 5.0 5.0   0.0     13.0     8.0   37.0 42.0     *       21     7   79 48 5 5   0     13     8   37 42         21   7   79
1524032 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2020   grade_6 50.0 3.0 2.0   0.0     23.0     5.0   37.0 46.0     *       26     *   83 50 3 2   0     23     5   37 46         26       83
1524051 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2020   grade_6 39.0 0.0 4.0   0.0     6.0     2.0   28.0 23.0     *       *     *   51 39 0 4   0     6     2   28 23                 51
1524070 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2020   grade_6 23.0 7.0 2.0   1.0     14.0     3.0   23.0 27.0     *       *     *   50 23 7 2   1     14     3   23 27                 50
1524279 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1524450 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_6 29.0 0.0 0.0               2.0   12.0 19.0     *       23     6   31 29 0 0               2   12 19         23   6   31
1524526 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_6 7.0 0.0 0.0                   3.0 4.0     *       5     0   7 7 0 0                   3 4         5   0   7
1524621 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2020   grade_6 85.0 0.0 3.0   0.0     1.0     1.0   38.0 52.0     *       49     14   90 85 0 3   0     1     1   38 52         49   14   90
1525324 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No High 06 12 2020   grade_6 1.0 15.0 52.0   0.0     1.0         40.0 29.0     *       62     20   69 1 15 52   0     1         40 29         62   20   69
1525495 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2020   grade_6 1.0 41.0 45.0   0.0     0.0     0.0   40.0 47.0     *       80     15   87 1 41 45   0     0     0   40 47         80   15   87
1525533 NY Bronx   school 3600144 320700860889   SOUTH BRONX CHARTER SCHOOL 360014405787 320700860889 SOUTH BRONX CHARTER SCHOOL charter Regular School Yes Elementary KG 07 2020   grade_6 2.0 5.0 30.0   0.0     0.0         12.0 25.0     *       32     *   37 2 5 30   0     0         12 25         32       37
1525590 NY Bronx   school 3600960 320700860925   MOTT HAVEN ACADEMY CHARTER S 360096006013 320700860925 MOTT HAVEN ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2020   grade_6 0.0 13.0 36.0   1.0     1.0     0.0   20.0 31.0     *       48     11   51 0 13 36   1     1     0   20 31         48   11   51
1525666 NY Bronx   school 3601115 320700860994   BOYS PREP CHARTER SCHOOL OF 360111506454 320700860994 BOYS PREP CHARTER SCHOOL OF NY charter Regular School Yes Elementary PK 06 2020   grade_6 0.0 24.0 30.0   1.0     0.0     0.0   55.0 0.0     *       48     19   55 0 24 30   1     0     0   55 0         48   19   55
1525704 NY Bronx   school 3601108 320700861014   BRILLA COLLEGE PREP CHARTER 360110806384 320700861014 BRILLA COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 07 2020   grade_6 1.0 21.0 62.0   0.0     0.0     0.0   37.0 47.0     *       84     21   84 1 21 62   0     0     0   37 47         84   21   84
1526008 NY Bronx   school 3601197 320700861173   UNIVERSITY PREP CHARTER MIDD 360119706707 320700861173 UNIVERSITY PREP CHARTER MIDDLE SCHOO charter Regular School Yes Middle 05 06 2020   grade_6 1.0 46.0 48.0   1.0     0.0     1.0   45.0 52.0     *       91     18   97 1 46 48   1     0     1   45 52         91   18   97
1526521 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505657 320800010337 SCHOOL FOR INQUIRY & SOCIAL JUSTICE public Regular School No Middle 06 08 2020   grade_6 2.0 30.0 118.0   1.0     3.0     1.0   92.0 63.0     *       *     37   155 2 30 118   1     3     1   92 63             37   155
1526597 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506081 320800010424 HUNTS POINT SCHOOL (THE) public Regular School No Middle 06 08 2020   grade_6 1.0 19.0 68.0         0.0         51.0 37.0     *       *     32   88 1 19 68         0         51 37             32   88
1526806 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505985 320800011367 ARCHIMEDES ACAD-MATH, SCI, TECH public Regular School No High 06 12 2020   grade_6 2.0 24.0 50.0   2.0     7.0     0.0   47.0 38.0     *       67     21   85 2 24 50   2     7     0   47 38         67   21   85
1526825 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505984 320800011376 ANTONIA PANTOJA PREP ACADEMY public Regular School No High 06 12 2020   grade_6 1.0 8.0 43.0   0.0     1.0         26.0 27.0     *       50     17   53 1 8 43   0     1         26 27         50   17   53
1526844 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505983 320800011377 BRONX COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2020   grade_6 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
1527034 NY Bronx   school 3600112 320800860872   GRAND CONCOURSE ACAD CHARTER 360011205672 320800860872 GRAND CONCOURSE ACAD CHARTER SCH charter Regular School Yes Elementary KG 08 2020   grade_6 0.0 20.0 29.0   1.0     0.0     0.0   22.0 28.0     *       45     13   50 0 20 29   1     0     0   22 28         45   13   50
1527072 NY Bronx   school 3600986 320800860940   GIRLS PREP CHARTER-BRONX 360098606161 320800860940 GIRLS PREP CHARTER SCH-BRONX charter Regular School Yes Elementary PK 08 2020   grade_6 0.0 27.0 49.0   0.0     0.0     0.0   0.0 76.0     *       67     19   76 0 27 49   0     0     0   0 76         67   19   76
1527243 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605191 320900010004 PS/MS 4 CROTONA PARK WEST public Regular School No Elementary PK 08 2020   grade_6 0.0 15.0 20.0         1.0     0.0   15.0 21.0     *       34     13   36 0 15 20         1     0   15 21         34   13   36
1527889 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603767 320900010313 IS 313 SCHOOL OF LEADERSHIP DEV public Regular School No Middle 06 08 2020   grade_6 1.0 25.0 62.0   0.0     1.0         54.0 35.0     *       82     25   89 1 25 62   0     1         54 35         82   25   89
1527946 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605667 320900010328 NEW MILLENNIUM BRONX ACAD ARTS public Regular School No Middle 06 08 2020   grade_6 1.0 35.0 67.0         1.0         51.0 53.0     *       97     30   104 1 35 67         1         51 53         97   30   104
1527965 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603780 320900010339 IS 339 public Regular School No Middle 06 08 2020   grade_6 1.0 39.0 75.0   0.0     0.0         59.0 56.0     *       108     33   115 1 39 75   0     0         59 56         108   33   115
1528098 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 2020   grade_6 1.0 25.0 60.0   0.0     2.0     1.0     89.0     *       78     18   89 1 25 60   0     2     1     89         78   18   89
1528592 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2020   grade_6   17.0 19.0   0.0     0.0         16.0 20.0     *       28     *   36   17 19   0     0         16 20         28       36
1528649 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Other KG 11 2020   grade_6 0.0 17.0 34.0   1.0     0.0         24.0 28.0     *       51     6   52 0 17 34   1     0         24 28         51   6   52
1528782 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 2020   grade_6 0.0 7.0 31.0         0.0         16.0 22.0     *       38     11   38 0 7 31         0         16 22         38   11   38
1529257 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702440 321000010118 JHS 118 WILLIAM W NILES public Regular School No Middle 06 08 2020   grade_6 18.0 66.0 192.0   8.0     45.0     0.0   172.0 157.0     *       *     *   329 18 66 192   8     45     0   172 157                 329
1529409 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705797 321000010228 JONAS BRONCK ACADEMY public Regular School No Middle 06 08 2020   grade_6 5.0 14.0 65.0   1.0     5.0     0.0   45.0 45.0     *       80     19   90 5 14 65   1     5     0   45 45         80   19   90
1529428 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705798 321000010244 NEW SCHOOL-LEADERSHIP & JOURNAL public Regular School No Middle 06 08 2020   grade_6 3.0 14.0 170.0   0.0     6.0     1.0   99.0 95.0     *       *     *   194 3 14 170   0     6     1   99 95                 194
1529466 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703794 321000010254 IS 254 public Regular School No Middle 06 08 2020   grade_6 0.0 18.0 105.0   1.0     4.0         67.0 61.0     *       115     43   128 0 18 105   1     4         67 61         115   43   128
1529580 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705569 321000010308 BRONX DANCE ACADEMY SCHOOL public Regular School No Middle 06 08 2020   grade_6 3.0 19.0 69.0         1.0         17.0 75.0     *       82     26   92 3 19 69         1         17 75         82   26   92
1529618 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702939 321000010315 PS 315 LAB SCHOOL public Regular School No Elementary KG 08 2020   grade_6 1.0 6.0 19.0   1.0     1.0     0.0   15.0 13.0     *       27     7   28 1 6 19   1     1     0   15 13         27   7   28
1529713 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706297 321000010363 ACAD-PERSONAL LDSHP AND EXCELLENCE public Regular School No Middle 06 08 2020   grade_6 7.0 37.0 205.0   4.0     6.0     0.0   148.0 111.0     *       240     68   259 7 37 205   4     6     0   148 111         240   68   259
1530017 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2020   grade_6     27.0                   12.0 15.0     *       *     7   27     27                   12 15             7   27
1530245 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701922 321000011445 BRONX HIGH SCHOOL OF SCIENCE public Regular School No High 09 12 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1530549 NY Bronx   school 3601176 321000861135   KIPP FREEDOM CHARTER SCHOOL 360117606647 321000861135 KIPP FREEDOM CHARTER SCHOOL charter Regular School Yes Middle 05 06 2020   grade_6 1.0 31.0 57.0   0.0     2.0     0.0   43.0 48.0     *       88     18   91 1 31 57   0     2     0   43 48         88   18   91
1530986 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802524 321100010144 JHS 144 MICHELANGELO public Regular School No Middle 06 08 2020   grade_6 2.0 67.0 46.0   2.0     7.0         69.0 55.0     *       *     31   124 2 67 46   2     7         69 55             31   124
1531062 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802613 321100010175 PS 175 CITY ISLAND public Regular School No Elementary KG 08 2020   grade_6 7.0 7.0 14.0   0.0     2.0     0.0   15.0 15.0     *       19     8   30 7 7 14   0     2     0   15 15         19   8   30
1531100 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802628 321100010180 MS 180 DR DANIEL HALE WILLIAMS public Regular School No Middle 06 08 2020   grade_6 6.0 232.0 66.0   5.0     18.0     2.0   164.0 165.0     *       256     62   329 6 232 66   5     18     2   164 165         256   62   329
1531195 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805953 321100010326 BRONX GREEN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 18.0 31.0 74.0   2.0     5.0     2.0   75.0 57.0     *       *     *   132 18 31 74   2     5     2   75 57                 132
1531214 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806399 321100010355 BRONX ALLIANCE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 3.0 74.0 32.0   0.0     1.0         57.0 53.0     *       91     30   110 3 74 32   0     1         57 53         91   30   110
1531271 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2020   grade_6 1.0 57.0 18.0   1.0     1.0     1.0   41.0 38.0     *       *     *   79 1 57 18   1     1     1   41 38                 79
1531366 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806259 321100010529 ONE WORLD MS AT EDENWALD public Regular School No Middle 06 08 2020   grade_6 1.0 67.0 38.0   4.0     1.0         60.0 51.0     *       95     24   111 1 67 38   4     1         60 51         95   24   111
1531803 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes Elementary KG 08 2020   grade_6 0.0 33.0 33.0   0.0     19.0         36.0 49.0     *       64     9   85 0 33 33   0     19         36 49         64   9   85
1531841 NY Bronx   school 3600955 321100860917   ICAHN CHARTER SCHOOL 3 360095506027 321100860917 ICAHN CHARTER SCHOOL 3 charter Regular School Yes Elementary KG 08 2020   grade_6 0.0 16.0 11.0   0.0     1.0     0.0   15.0 13.0     *       21     *   28 0 16 11   0     1     0   15 13         21       28
1531898 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2020   grade_6 2.0 22.0 9.0   0.0     2.0     0.0   18.0 17.0     *       29     *   35 2 22 9   0     2     0   18 17         29       35
1532126 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002373 321200010098 JHS 98 HERMAN RIDDER public Regular School No Middle 06 08 2020   grade_6 1.0 16.0 42.0   1.0     1.0     0.0   31.0 30.0     *       *     *   61 1 16 42   1     1     0   31 30                 61
1532316 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005169 321200010217 SCHOOL OF PERFORMING ARTS public Regular School No Middle 06 08 2020   grade_6 2.0 34.0 65.0   0.0     4.0     0.0   48.0 57.0     *       103     41   105 2 34 65   0     4     0   48 57         103   41   105
1532487 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006002 321200010383 EMOLIOR ACADEMY public Regular School No Middle 06 08 2020   grade_6 1.0 35.0 68.0   1.0     10.0         62.0 53.0     *       104     32   115 1 35 68   1     10         62 53         104   32   115
1532886 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2020   grade_6 0.0 12.0 28.0   0.0     1.0     0.0   17.0 24.0     *       36     *   41 0 12 28   0     1     0   17 24         36       41
1532905 NY Bronx   school 3600161 321200860898   SOUTH BRONX CLASSICAL CHARTE 360016105893 321200860898 SOUTH BRONX CLASSICAL CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_6 1.0 17.0 20.0   0.0     0.0     0.0   18.0 20.0     *       34     *   38 1 17 20   0     0     0   18 20         34       38
1532962 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 2020   grade_6 2.0 18.0 44.0   0.0     2.0     0.0   37.0 29.0     *       59     12   66 2 18 44   0     2     0   37 29         59   12   66
1533000 NY Bronx   school 3601161 321200861108   NYC AUTISM CHARTER-BRONX 360116106615 321200861108 NYC AUTISM CHARTER SCHOOL BRONX charter Special Education School Yes Ungraded UG UG 2020   grade_6 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1533019 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1533038 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533209 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 77.0 44.0 22.0   0.0     7.0     26.0   80.0 96.0     *       128     37   176 77 44 22   0     7     26   80 96         128   37   176
1533342 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 103.0 2.0 3.0   0.0     2.0     4.0   58.0 56.0     *       60     16   114 103 2 3   0     2     4   58 56         60   16   114
1533361 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533380 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000517 30701060001 CHENANGO VALLEY HIGH SCHOOL public Regular School No High 09 12 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533399 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533418 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1533437 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 116.0 3.0 2.0   2.0     2.0     6.0   63.0 68.0     *       51     29   131 116 3 2   2     2     6   63 68         51   29   131
1533494 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 173.0 6.0 11.0   1.0     2.0     8.0   99.0 102.0     *       84     34   201 173 6 11   1     2     8   99 102         84   34   201
1533532 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 08 2020   grade_6 108.0 1.0 2.0   1.0     1.0     1.0   59.0 55.0     *       71     26   114 108 1 2   1     1     1   59 55         71   26   114
1533551 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1533646 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 175.0 31.0 28.0   0.0     4.0     39.0   131.0 146.0     *       188     32   277 175 31 28   0     4     39   131 146         188   32   277
1533703 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000845 31501060014 ANN G MCGUINNESS ELEMENTARY public Regular School No Elementary KG 05 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533836 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1533893 NY Broome   school 3629610 31601060000   VESTAL 362961003985 31601060041 VESTAL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_6 185.0 10.0 14.0   0.0     36.0     16.0   127.0 134.0     *       104     35   261 185 10 14   0     36     16   127 134         104   35   261
1533931 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1533969 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2020   grade_6 99.0 1.0 8.0         3.0     6.0   60.0 57.0     *       74     19   117 99 1 8         3     6   60 57         74   19   117
1533988 NY Broome   school 3602730 31701060000   WINDSOR 360273004430 31701060007 WINDSOR CENTRAL HIGH SCHOOL public Regular School No High 09 12 2020   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1534045 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534102 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534121 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000904 41101040003 FRANKLINVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_6 43.0   0.0   1.0     1.0     1.0   22.0 24.0     *       27     6   46 43   0   1     1     1   22 24         27   6   46
1534159 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534216 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003083 42400010002 WASHINGTON WEST ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534235 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534273 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2020   grade_6 110.0 5.0 11.0   0.0     3.0     14.0   69.0 74.0     *       81     36   143 110 5 11   0     3     14   69 74         81   36   143

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