Data source: Big Local News · About: Big Local

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

View and edit SQL

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
2139387 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   grade_7 17.0 113.0 20.0         7.0     12.0   74.0 95.0     20       159     *   169 17 113 20         7     12   74 95     20   159       169
2139444 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2019   grade_7 3.0 59.0 8.0   0.0     2.0     1.0   23.0 50.0     0       52     *   73 3 59 8   0     2     1   23 50     0   52       73
2140508 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 33.0 1.0 0.0   1.0     0.0     0.0   17.0 18.0             20     *   35 33 1 0   1     0     0   17 18         20       35
2140527 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2019   grade_7 17.0 0.0 0.0   0.0           1.0   10.0 8.0             10     *   18 17 0 0   0           1   10 8         10       18
2140546 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2019   grade_7 22.0   1.0         0.0         3.0 20.0             10     *   23 22   1         0         3 20         10       23
2140565 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 24.0 0.0 0.0               0.0   9.0 15.0             13     *   24 24 0 0               0   9 15         13       24
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
2140774 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_7 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2141097 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2019   grade_7 4.0 24.0 68.0         0.0         53.0 43.0     22       *     *   96 4 24 68         0         53 43     22           96
2141135 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2019   grade_7   25.0 36.0   1.0     3.0         34.0 31.0     10       *     *   65   25 36   1     3         34 31     10           65
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
2142598 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506156 320800010448 SOUNDVIEW ACADEMY public Regular School No Middle 06 08 2019   grade_7 0.0 39.0 78.0   2.0     5.0         66.0 58.0     8       *     *   124 0 39 78   2     5         66 58     8           124
2143130 NY Bronx   school 3601131 320800861068   SOUTH BRONX EARLY COLLEGE AC 360113106555 320800861068 SOUTH BRONX EARLY COLLEGE ACADEMY CS charter Regular School Yes Middle 06 08 2019   grade_7 2.0 43.0 69.0         1.0         71.0 44.0     11       103     *   115 2 43 69         1         71 44     11   103       115
2143472 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605192 320900010117 IS 117 JOSEPH H WADE public Regular School No Middle 06 08 2019   grade_7 2.0 20.0 126.0   1.0     2.0         87.0 64.0     68       *     *   151 2 20 126   1     2         87 64     68           151
2143681 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602737 320900010229 IS 229 ROLAND PATTERSON public Regular School No Middle 06 08 2019   grade_7   33.0 48.0   1.0     0.0     0.0   39.0 43.0     14       76     *   82   33 48   1     0     0   39 43     14   76       82
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
2144061 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606642 320900010594 MS 594 public Regular School No Middle 06 08 2019   grade_7 1.0 23.0 48.0   0.0     0.0         36.0 36.0     22       68     *   72 1 23 48   0     0         36 36     22   68       72
2144517 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2019   grade_7   16.0 15.0   0.0     0.0         12.0 19.0     0       22     *   31   16 15   0     0         12 19     0   22       31
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
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
2146018 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706010 321000011397 ENGLISH LANGUAGE LEARNERS-INTER SUPP 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
2146436 NY Bronx   school 3601138 321000861075   ATMOSPHERE ACADEMY PUBLIC CH 360113806563 321000861075 ATMOSPHERE ACADEMY PUBLIC CHARTER charter Regular School Yes Middle 06 08 2019   grade_7 2.0 24.0 122.0   0.0     3.0     1.0   76.0 76.0     15       142     *   152 2 24 122   0     3     1   76 76     15   142       152
2146835 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802469 321100010127 JHS 127 CASTLE HILL (THE) public Regular School No Middle 06 08 2019   grade_7 5.0 54.0 95.0   5.0     78.0     2.0   117.0 122.0     29       *     *   239 5 54 95   5     78     2   117 122     29           239
2146930 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802613 321100010175 PS 175 CITY ISLAND public Regular School No Elementary KG 08 2019   grade_7 8.0 1.0 14.0   0.0     3.0     1.0   13.0 14.0     0       17     *   27 8 1 14   0     3     1   13 14     0   17       27
2147044 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805800 321100010287 NORTH BRONX SCHOOL OF EMPOWERMENT public Regular School No Middle 06 08 2019   grade_7 3.0 99.0 67.0   1.0     9.0     0.0   106.0 73.0     26       *     *   179 3 99 67   1     9     0   106 73     26           179
2147063 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805953 321100010326 BRONX GREEN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 22.0 22.0 75.0   1.0     4.0     0.0   68.0 56.0     30       *     *   124 22 22 75   1     4     0   68 56     30           124
2147234 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806259 321100010529 ONE WORLD MS AT EDENWALD public Regular School No Middle 06 08 2019   grade_7 0.0 67.0 37.0   3.0     2.0         64.0 45.0     7       *     *   109 0 67 37   3     2         64 45     7           109
2147272 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806314 321100010556 BRONX PARK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 20.0 23.0 67.0   0.0     11.0     0.0   66.0 55.0     26       *     *   121 20 23 67   0     11     0   66 55     26           121
2147709 NY Bronx   school 3600955 321100860917   ICAHN CHARTER SCHOOL 3 360095506027 321100860917 ICAHN CHARTER SCHOOL 3 charter Regular School Yes Elementary KG 08 2019   grade_7 2.0 23.0 5.0   1.0     1.0     0.0   18.0 14.0     0       27     *   32 2 23 5   1     1     0   18 14     0   27       32
2147728 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 22.0 9.0   1.0     1.0     3.0   19.0 17.0     0       21     *   36 0 22 9   1     1     3   19 17     0   21       36
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
2148089 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005166 321200010190 ESMT-IS 190 public Regular School No Middle 06 08 2019   grade_7 0.0 18.0 67.0   2.0     2.0     1.0   43.0 47.0     12       *     *   90 0 18 67   2     2     1   43 47     12           90
2148317 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005691 321200010316 KAPPA III public Regular School No Middle 06 08 2019   grade_7 1.0 32.0 89.0   2.0     3.0     0.0   73.0 54.0     12       119     *   127 1 32 89   2     3     0   73 54     12   119       127
2148374 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006002 321200010383 EMOLIOR ACADEMY public Regular School No Middle 06 08 2019   grade_7 4.0 22.0 70.0   1.0     3.0     0.0   54.0 46.0     20       *     *   100 4 22 70   1     3     0   54 46     20           100
2148545 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005679 321200011271 EAST BRONX ACADEMY FOR THE FUTURE public Regular School No High 06 12 2019   grade_7 0.0 27.0 65.0   1.0     4.0     0.0   48.0 49.0     19       93     *   97 0 27 65   1     4     0   48 49     19   93       97
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
2148792 NY Bronx   school 3600161 321200860898   SOUTH BRONX CLASSICAL CHARTE 360016105893 321200860898 SOUTH BRONX CLASSICAL CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_7 1.0 11.0 18.0   0.0     0.0     0.0   14.0 16.0     0       26     *   30 1 11 18   0     0     0   14 16     0   26       30
2149894 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 16.0 0.0 0.0         0.0     0.0   9.0 7.0             9     *   16 16 0 0         0     0   9 7         9       16
2149989 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   grade_7 40.0 0.0 1.0   0.0     1.0     0.0   23.0 19.0             22     *   42 40 0 1   0     1     0   23 19         22       42
2150141 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003082 42400010013 OLEAN SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 5.0 0.0 0.0   0.0     0.0     0.0   3.0 2.0             *     *   5 5 0 0   0     0     0   3 2                 5
2150312 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No Other KG 12 2019   grade_7 3.0 0.0 0.0   0.0     0.0     0.0   3.0 0.0             *     *   3 3 0 0   0     0     0   3 0                 3
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
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
2151091 NY Chautauqua   school 3607890 60701040000   CLYMER 360789000562 60701040003 CLYMER CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 34.0 0.0 0.0         0.0     2.0   24.0 12.0             20     *   36 34 0 0         0     2   24 12         20       36
2151965 NY Chemung   school 3610560 70600010000   ELMIRA 361056000811 70600010019 BROADWAY ACADEMY public Regular School No Middle 07 07 2019   grade_7 312.0 56.0 10.0         4.0     55.0   215.0 222.0     *       *     *   437 312 56 10         4     55   215 222                 437
2152155 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001242 70901060010 HORSEHEADS MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_7 240.0 3.0 13.0         10.0     16.0   144.0 138.0     *       110     *   282 240 3 13         10     16   144 138         110       282
2152877 NY Clinton   school 3621250 90501040000   NORTHEASTRN CLNTON 362125003018 90501040007 NORTHEASTERN CLINTON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 73.0   3.0   0.0     2.0     0.0   32.0 46.0             *     *   78 73   3   0     2     0   32 46                 78
2153162 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 96.0 1.0 1.0               4.0   49.0 53.0             *     *   102 96 1 1               4   49 53                 102
2153181 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_7 1.0 0.0 1.0                   2.0 0.0             *     *   2 1 0 1                   2 0                 2
2153485 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   grade_7 33.0 1.0 1.0               0.0   16.0 19.0             16     *   35 33 1 1               0   16 19         16       35
2153675 NY Cortland   school 3608460 110200010000   CORTLAND 360846006612 110200010012 CORTLAND JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_7 144.0 4.0 10.0         0.0     9.0   86.0 81.0             157     *   167 144 4 10         0     9   86 81         157       167
2153865 NY Delaware   school 3609060 31301040000   DEPOSIT 360906000694 31301040003 DEPOSIT MIDDLE-SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 27.0 1.0 0.0   0.0               14.0 14.0             *     *   28 27 1 0   0               14 14                 28
2153884 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 6.0 1.0 0.0               0.0   1.0 6.0             5     *   7 6 1 0               0   1 6         5       7
2153903 NY Delaware   school 3609240 120301040000   DOWNSVILLE 360924000709 120301040001 DOWNSVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 17.0 0.0 2.0         0.0         7.0 12.0             12     *   19 17 0 2         0         7 12         12       19
2153960 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000681 120501040002 DELAWARE ACADEMY HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 52.0 1.0 0.0   0.0     0.0     4.0   27.0 30.0     *       27     *   57 52 1 0   0     0     4   27 30         27       57
2154131 NY Delaware   school 3628020 121701040000   STAMFORD 362802003796 121701040001 STAMFORD CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 20.0 2.0 0.0   0.0     0.0         9.0 13.0     *       14     *   22 20 2 0   0     0         9 13         14       22
2154150 NY Delaware   school 3627330 121702040000   SOUTH KORTRIGHT 362733003730 121702040001 SOUTH KORTRIGHT CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 23.0 1.0 0.0         0.0     0.0   9.0 15.0             13     *   24 23 1 0         0     0   9 15         13       24
2154207 NY Delaware   school 3629820 121901040000   WALTON 362982004791 121901040003 WALTON MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 61.0 0.0 3.0         1.0         24.0 41.0     *       30     *   65 61 0 3         1         24 41         30       65
2155404 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004024 132101060009 VAN WYCK JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_7 338.0 25.0 62.0         13.0     5.0   222.0 221.0             97     *   443 338 25 62         13     5   222 221         97       443
2156316 NY Erie   school 3605850 140600010000   BUFFALO 360585000332 140600010031 HARRIET ROSS TUBMAN ACADEMY public Regular School No Elementary PK 08 2019   grade_7 3.0 22.0 1.0   0.0     4.0     0.0   20.0 10.0     11       29     *   30 3 22 1   0     4     0   20 10     11   29       30
2156373 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 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
2156658 NY Erie   school 3605850 140600010000   BUFFALO 360585000368 140600010080 HIGHGATE HEIGHTS public Regular School No Elementary PK 08 2019   grade_7 0.0 40.0 2.0         1.0     1.0   15.0 29.0     *       44     *   44 0 40 2         1     1   15 29         44       44
2157076 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL AT 4 public Alternative School No High 07 12 2019   grade_7 2.0 2.0 3.0   0.0     0.0     0.0   5.0 2.0     *       7     *   7 2 2 3   0     0     0   5 2         7       7
2157190 NY Erie   school 3605850 140600010000   BUFFALO 360585006596 140600010309 NEWCOMER ACADEMY AT LAFAYETTE 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
2157418 NY Erie   school 3600073 140600860856   ENTERPRISE CHARTER SCHOOL 360007305551 140600860856 ENTERPRISE CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 23.0 19.0         1.0     1.0   21.0 23.0     *       44     *   44 0 23 19         1     1   21 23         44       44
2159717 NY Essex   school 3610440 150301040000   ELIZABETHTOWN 361044000804 150301040001 ELIZABETHTOWN-LEWIS CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 12.0 0.0 0.0         1.0         10.0 3.0             6     *   13 12 0 0         1         10 3         6       13
2159736 NY Essex   school 3616140 150601040000   KEENE 361614001394 150601040001 KEENE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 14.0 0.0 0.0   0.0           1.0   5.0 10.0             8     *   15 14 0 0   0           1   5 10         8       15
2159869 NY Essex   school 3626130 151401040000   SCHROON LAKE 362613003599 151401040001 SCHROON LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 16.0 0.0 0.0                   8.0 8.0     *       11     *   16 16 0 0                   8 8         11       16
2159926 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003894 151501060007 TICONDEROGA MIDDLE SCHOOL public Regular School No Middle 06 09 2019   grade_7 59.0 0.0     0.0     0.0         34.0 25.0             *     *   59 59 0     0     0         34 25                 59
2159945 NY Essex   school 3631080 151601040000   WESTPORT 363108004170 151601040001 WESTPORT CENTRAL SCHOOL public Regular School No Other KG 12 2019   grade_7 12.0                   0.0   6.0 6.0             5     *   12 12                   0   6 6         5       12
2160173 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003534 161401060003 SARANAC LAKE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 87.0   0.0               1.0   45.0 43.0             *     *   88 87   0               1   45 43                 88
2160344 NY Franklin   school 3627990 161801040000   ST REGIS FALLS 362799003793 161801040001 ST REGIS FALLS CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 15.0 0.0 0.0   0.0           1.0   6.0 10.0     *       10     *   16 15 0 0   0           1   6 10         10       16
2160363 NY Fulton   school 3631200 170301020000   WHEELERVILLE 363120004173 170301020001 WHEELERVILLE SCHOOL public Regular School No Elementary PK 08 2019   grade_7 12.0   0.0         0.0     0.0   9.0 3.0             8     *   12 12   0         0     0   9 3         8       12
2160743 NY Genesee   school 3602580 180202040000   ALEXANDER 360258000043 180202040003 ALEXANDER MIDDLE SCHOOL-HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 64.0 1.0 0.0         2.0     1.0   28.0 40.0             25     *   68 64 1 0         2     1   28 40         25       68
2160895 NY Genesee   school 3610380 180901040000   ELBA 361038000802 180901040002 ELBA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_7 27.0 0.0 8.0   0.0               21.0 14.0     5       13     *   35 27 0 8   0               21 14     5   13       35
2161256 NY Greene   school 3608490 190501040000   COXSACKIE ATHENS 360849004765 190501040004 COXSACKIE-ATHENS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 86.0 2.0 12.0   0.0     0.0     1.0   48.0 53.0     *       37     *   101 86 2 12   0     0     1   48 53         37       101
2161389 NY Hamilton   school 3615270 200401040000   INDIAN LAKE 361527001285 200401040001 INDIAN LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 5.0 0.0 0.0         0.0     0.0   2.0 3.0             *     *   5 5 0 0         0     0   2 3                 5
2161446 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 5.0                       3.0 2.0             *     *   5 5                       3 2                 5
2161465 NY Hamilton   school 3630450 200901040000   WELLS 363045004096 200901040001 WELLS SCHOOL public Regular School No Other PK 12 2019   grade_7 11.0 0.0 0.0                   7.0 4.0             *     *   11 11 0 0                   7 4                 11
2161731 NY Herkimer   school 3623370 211103040000   POLAND 362337003269 211103040001 POLAND JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 35.0 0.0 0.0         0.0     2.0   22.0 15.0             19     *   37 35 0 0         0     2   22 15         19       37
2161769 NY Herkimer   school 3622200 211701040000   VAN HORNSVILLE 362220003142 211701040001 OWEN D YOUNG CENTRAL SCHOOL public Regular School No Other KG 12 2019   grade_7 12.0   0.0               0.0   4.0 8.0             9     *   12 12   0               0   4 8         9       12
2161788 NY Herkimer   school 3628800 211901020000   TOWN OF WEBB 362880003908 211901020001 TOWN OF WEBB SCHOOL public Regular School No Other KG 12 2019   grade_7 20.0 0.0 0.0   0.0     0.0         12.0 8.0             7     *   20 20 0 0   0     0         12 8         7       20
2162377 NY Jefferson   school 3617880 221301040000   LYME 361788001604 221301040001 LYME CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_7 21.0 0.0 1.0         0.0     0.0   9.0 13.0             10     *   22 21 0 1         0     0   9 13         10       22
2162643 NY Jefferson   school 3606630 222201060000   CARTHAGE 360663000445 222201060011 CARTHAGE MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 184.0 7.0 25.0   0.0     7.0     18.0   117.0 124.0     *       123     *   241 184 7 25   0     7     18   117 124         123       241
2162871 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009104523 331300010113 MS 113 RONALD EDMONDS LEARNING CTR public Regular School No Middle 06 08 2019   grade_7 1.0 73.0 26.0   2.0     7.0     2.0   59.0 52.0     9       101     *   111 1 73 26   2     7     2   59 52     9   101       111
2164106 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905701 331400010577 CONSELYEA PREPARATORY SCHOOL public Regular School No Middle 06 08 2019   grade_7 52.0 8.0 91.0   0.0     2.0     0.0   71.0 82.0     5       85     *   153 52 8 91   0     2     0   71 82     5   85       153
2164695 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202226 331500010051 MS 51 WILLIAM ALEXANDER public Regular School No Middle 06 08 2019   grade_7 187.0 24.0 73.0   1.0     75.0     14.0   157.0 217.0     8       127     *   374 187 24 73   1     75     14   157 217     8   127       374
2165189 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009206659 331500010896 SCHOOL OF CREATIVITY-INNOVATION public Regular School No 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
2166177 NY Kings   school 3601048 331600860975   EMBER CHARTER SCHOOL 360104806255 331600860975 EMBER CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 39.0 6.0   0.0     0.0     0.0   18.0 27.0     0       32     *   45 0 39 6   0     0     0   18 27     0   32       45
2166196 NY Kings   school 3601059 331600861003   LAUNCH EXPEDITIONARY LRNING 360105906349 331600861003 LAUNCH EXPEDITIONARY LRNING CHARTER charter Regular School Yes Middle 06 08 2019   grade_7 1.0 81.0 13.0   2.0     0.0     1.0   47.0 51.0     *       *     *   98 1 81 13   2     0     1   47 51                 98
2166291 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502262 331700010061 MS 61 DR GLADSTONE H ATWELL public Regular School No Middle 06 08 2019   grade_7 1.0 163.0 18.0   2.0     5.0     0.0   97.0 92.0     11       *     *   189 1 163 18   2     5     0   97 92     11           189
2166405 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502649 331700010189 PS 189 BILINGUAL CENTER (THE) public Regular School No Elementary KG 08 2019   grade_7 1.0 91.0 26.0   0.0     2.0     0.0   63.0 57.0     21       104     *   120 1 91 26   0     2     0   63 57     21   104       120
2166481 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502760 331700010246 MS 246 WALT WHITMAN public Regular School No Middle 06 08 2019   grade_7 7.0 107.0 22.0   2.0     0.0     0.0   65.0 73.0     38       116     *   138 7 107 22   2     0     0   65 73     38   116       138
2166557 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009504813 331700010340 IS 340 public Regular School No Middle 06 08 2019   grade_7 1.0 46.0 7.0   1.0     0.0     0.0   28.0 27.0     *       *     *   55 1 46 7   1     0     0   28 27                 55
2166576 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505818 331700010352 EBBETS FIELD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 3.0 25.0 9.0         4.0     1.0   24.0 18.0     11       40     *   42 3 25 9         4     1   24 18     11   40       42
2166595 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505819 331700010353 ELIJAH STROUD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 3.0 37.0 12.0   1.0     4.0         32.0 25.0     7       *     *   57 3 37 12   1     4         32 25     7           57
2167241 NY Kings   school 3601089 331700861040   SUCCESS ACAD-PROSPECT HGTS 360108906412 331700861040 SUCCESS ACAD CHARTER SCH-PROSPECT charter Regular School Yes Elementary KG 07 2019   grade_7 1.0 8.0 11.0   0.0     0.0     0.0   6.0 14.0     0       12     *   20 1 8 11   0     0     0   6 14     0   12       20
2167279 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 05 07 2019   grade_7   59.0 5.0   1.0     1.0     4.0   29.0 41.0     *       50     *   70   59 5   1     1     4   29 41         50       70
2167336 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602283 331800010068 IS 68 ISAAC BILDERSEE public Regular School No Middle 06 08 2019   grade_7 7.0 66.0 6.0   0.0     5.0     0.0   52.0 32.0     16       *     *   84 7 66 6   0     5     0   52 32     16           84
2167602 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602795 331800010285 IS 285 MEYER LEVIN public Regular School No Middle 06 08 2019   grade_7 3.0 214.0 9.0   1.0     3.0     1.0   98.0 133.0     9       178     *   231 3 214 9   1     3     1   98 133     9   178       231

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