Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_7", state = "NY" and year = 2020 sorted by disability

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_7 · 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
1524698 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_7 0.0                       0.0 0.0                       0 0                       0 0                 0
1534521 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2020   grade_7         0.0           0.0   0.0               *         0         0           0   0                   0
1541779 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 02 2020   grade_7 0.0 0.0 0.0               0.0   0.0 0.0             0         0 0 0 0               0   0 0         0       0
1544325 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2020   grade_7 0.0                       0.0 0.0             0         0 0                       0 0         0       0
1559107 NY Monroe   school 3615390 260803060000   WEST IRONDEQUOIT 361539001298 260803060001 BRIARWOOD SCHOOL public Regular School No Elementary KG 03 2020   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
1561083 NY Monroe   school 3601040 261600860705   TRUE NORTH ROCHESTER-WEST 360104006243 261600860705 TRUE NORTH ROCHESTER PREP-WEST CAMP charter Regular School Yes Elementary KG 08 2020   grade_7 5.0 63.0 20.0         0.0     3.0   43.0 48.0     *       76         91 5 63 20         0     3   43 48         76       91
1571115 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2020   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
1576967 NY Oneida   school 3620610 411504020000   NEW YORK MILLS 362061002891 411504020001 NY MILLS JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 36.0 2.0 3.0         0.0     1.0   19.0 23.0                       42 36 2 3         0     1   19 23                 42
1576986 NY Oneida   school 3620610 411504020000   NEW YORK MILLS 362061001416 411504020003 NY MILLS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   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
1605543 NY Tompkins   school 3600990 610600860944   NEW ROOTS CHARTER SCHOOL 360099006102 610600860944 NEW ROOTS CHARTER SCHOOL charter Regular School Yes High 09 12 2020   grade_7 0.0 0.0           0.0     0.0   0.0 0.0             0         0 0 0           0     0   0 0         0       0
1523368 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_7 1.0 74.0 7.0   1.0     0.0     0.0   41.0 42.0     0       59     *   83 1 74 7   1     0     0   41 42     0   59       83
1523387 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523406 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_7 0.0 69.0 8.0         0.0     0.0   40.0 37.0     0       67     *   77 0 69 8         0     0   40 37     0   67       77
1523463 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_7 58.0 1.0 0.0   0.0     1.0     0.0   34.0 26.0             25     *   60 58 1 0   0     1     0   34 26         25       60
1524090 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2020   grade_7 271.0 14.0 25.0   3.0     83.0     23.0   219.0 200.0     16       *     *   419 271 14 25   3     83     23   219 200     16           419
1524128 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_7 18.0 1.0 1.0               1.0   8.0 13.0             11     *   21 18 1 1               1   8 13         11       21
1524413 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2020   grade_7 17.0 1.0 1.0         0.0     0.0   12.0 7.0             11     *   19 17 1 1         0     0   12 7         11       19
1524470 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_7 12.0   1.0                   4.0 9.0             6     *   13 12   1                   4 9         6       13
1524489 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 16.0 0.0 1.0               3.0   12.0 8.0             17     *   20 16 0 1               3   12 8         17       20
1524603 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 23.0 0.0 0.0   0.0           0.0   9.0 14.0             14     *   23 23 0 0   0           0   9 14         14       23
1526275 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502456 320800010123 JHS 123 JAMES M KIERNAN public Regular School No Middle 06 08 2020   grade_7 2.0 27.0 117.0   3.0     4.0         69.0 84.0     *       140     *   153 2 27 117   3     4         69 84         140       153
1526446 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505122 320800010302 MS 302 LUISA DESSUS CRUZ public Regular School No Middle 06 08 2020   grade_7 1.0 24.0 112.0   1.0     1.0     0.0   75.0 64.0     20       *     *   139 1 24 112   1     1     0   75 64     20           139
1526522 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_7 4.0 26.0 126.0   4.0     4.0     1.0   72.0 93.0     19       135     *   165 4 26 126   4     4     1   72 93     19   135       165
1526655 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 16.0 19.0 114.0   5.0     55.0     1.0   94.0 116.0     41       194     *   210 16 19 114   5     55     1   94 116     41   194       210
1527111 NY Bronx   school 3601091 320800861030   ICAHN CHARTER SCHOOL 7 360109106389 320800861030 ICAHN CHARTER SCHOOL 7 charter Regular School Yes Elementary KG 08 2020   grade_7 1.0 22.0 8.0   0.0     2.0     1.0   18.0 16.0     0       22     *   34 1 22 8   0     2     1   18 16     0   22       34
1527890 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_7 0.0 15.0 67.0   2.0     0.0         53.0 31.0     37       *     *   84 0 15 67   2     0         53 31     37           84
1527909 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605664 320900010323 BRONX WRITING ACADEMY public Regular School No Middle 06 08 2020   grade_7 3.0 28.0 73.0   1.0     3.0     0.0   51.0 57.0     33       *     *   108 3 28 73   1     3     0   51 57     33           108
1527928 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605666 320900010327 COMP MODEL SCH PROJECT MS 327 public Regular School No High 06 12 2020   grade_7 0.0 19.0 82.0         0.0     0.0   45.0 56.0     9       94     *   101 0 19 82         0     0   45 56     9   94       101
1527985 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606394 320900010361 HIGHBRIDGE GREEN SCHOOL (THE) public Regular School No Middle 06 08 2020   grade_7 3.0 25.0 88.0               0.0   56.0 60.0     *       *     *   116 3 25 88               0   56 60                 116
1528118 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606629 320900010593 SOUTH BRONX INTERNATIONAL MS public Regular School No Middle 06 07 2020   grade_7 0.0 7.0 53.0                   26.0 34.0     55       55     *   60 0 7 53                   26 34     55   55       60
1528593 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2020   grade_7   16.0 16.0   0.0     0.0         15.0 17.0     0       29     *   32   16 16   0     0         15 17     0   29       32
1528707 NY Bronx   school 3601069 320900861029   ICAHN CHARTER SCHOOL 6 360106906355 320900861029 ICAHN CHARTER SCHOOL 6 charter Regular School Yes Elementary KG 08 2020   grade_7 0.0 18.0 17.0   0.0     3.0     0.0   14.0 24.0     0       32     *   38 0 18 17   0     3     0   14 24     0   32       38
1529619 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_7 0.0 1.0 29.0   0.0     0.0     0.0   16.0 14.0     0       28     *   30 0 1 29   0     0     0   16 14     0   28       30
1529847 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706141 321000010447 CRESTON ACADEMY public Regular School No Middle 06 08 2020   grade_7 0.0 17.0 130.0   2.0     1.0         67.0 83.0     *       143     *   150 0 17 130   2     1         67 83         143       150
1530018 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_7     52.0                   33.0 19.0     45       49     *   52     52                   33 19     45   49       52
1530094 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706010 321000011397 ENGLISH LANGUAGE LEARNERS-INTER SUPP public Regular School No High 09 12 2020   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
1530626 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802100 321100010019 PS 19 JUDITH K WEISS public Regular School No Elementary KG 08 2020   grade_7 30.0 8.0 18.0   1.0     1.0     1.0   28.0 31.0     *       31     *   59 30 8 18   1     1     1   28 31         31       59
1531386 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806249 321100010532 BAYCHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 2.0 56.0 33.0   3.0     1.0     2.0   51.0 46.0     *       84     *   97 2 56 33   3     1     2   51 46         84       97
1531424 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806322 321100010566 PELHAM GARDENS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 9.0 71.0 53.0   3.0     9.0     0.0   77.0 68.0     11       118     *   145 9 71 53   3     9     0   77 68     11   118       145
1531823 NY Bronx   school 3600943 321100860909   ICAHN CHARTER SCHOOL 2 360094305973 321100860909 ICAHN CHARTER SCHOOL 2 charter Regular School Yes Elementary KG 08 2020   grade_7 0.0 7.0 26.0   0.0     0.0     0.0   12.0 21.0     0       19     *   33 0 7 26   0     0     0   12 21     0   19       33
1531842 NY Bronx   school 3600955 321100860917   ICAHN CHARTER SCHOOL 3 360095506027 321100860917 ICAHN CHARTER SCHOOL 3 charter Regular School Yes Elementary KG 08 2020   grade_7 1.0 16.0 9.0   1.0     2.0     1.0   12.0 18.0     0       21     *   30 1 16 9   1     2     1   12 18     0   21       30
1531861 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2020   grade_7 1.0 23.0 10.0   0.0     1.0     0.0   18.0 17.0     0       22     *   35 1 23 10   0     1     0   18 17     0   22       35
1531899 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2020   grade_7 1.0 14.0 11.0   0.0     4.0     0.0   13.0 17.0     *       21     *   30 1 14 11   0     4     0   13 17         21       30
1532355 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005690 321200010273 FREDERICK DOUGLASS ACAD V MIDDLE SCH public Regular School No Middle 06 08 2020   grade_7 1.0 14.0 42.0   1.0     1.0     0.0   25.0 34.0     14       58     *   59 1 14 42   1     1     0   25 34     14   58       59
1532887 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2020   grade_7 0.0 17.0 20.0   0.0     0.0     0.0   22.0 15.0     *       31     *   37 0 17 20   0     0     0   22 15         31       37
1532906 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_7 2.0 11.0 13.0   1.0     2.0     1.0   16.0 14.0     0       22     *   30 2 11 13   1     2     1   16 14     0   22       30
1533495 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 142.0 5.0 5.0   1.0     2.0     12.0   79.0 88.0     *       78     *   167 142 5 5   1     2     12   79 88         78       167
1534008 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 18.0   0.0   0.0           0.0   8.0 10.0             10     *   18 18   0   0           0   8 10         10       18
1534141 NY Cattaraugus   school 3614490 41401040000   HINSDALE 361449001203 41401040001 HINSDALE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 29.0 0.0 0.0   0.0     0.0     1.0   11.0 19.0             18     *   30 29 0 0   0     0     1   11 19         18       30
1534255 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003082 42400010013 OLEAN SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 1 0 0   0     0     0   1 0                 1
1534312 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239004858 42801060005 GOWANDA MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 52.0 0.0 2.0   25.0     0.0     6.0   47.0 38.0             47     *   85 52 0 2   25     0     6   47 38         47       85
1534369 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003298 42901040002 PORTVILLE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 82.0 0.0 1.0         0.0     6.0   49.0 40.0             45     *   89 82 0 1         0     6   49 40         45       89
1534464 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 1.0 0.0 0.0   0.0           0.0   1.0 0.0             *     *   1 1 0 0   0           0   1 0                 1
1535148 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801936 60503040001 CHAUTAUQUA LAKE SECONDARY SCHOOL public Regular School No High 07 12 2020   grade_7 62.0 1.0 0.0   0.0           1.0   34.0 30.0             34     *   64 62 1 0   0           1   34 30         34       64
1535224 NY Chautauqua   school 3607890 60701040000   CLYMER 360789000562 60701040003 CLYMER CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 24.0 0.0 0.0         0.0     2.0   18.0 8.0             11     *   26 24 0 0         0     2   18 8         11       26
1535414 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000869 61101040007 FALCONER MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_7 70.0 1.0 1.0   1.0     1.0     0.0   42.0 32.0             35     *   74 70 1 1   1     1     0   42 32         35       74
1535528 NY Chautauqua   school 3611250 61503040000   FORESTVILLE 361125000889 61503040003 FORESTVILLE CENTRAL HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 28.0 1.0 1.0   0.0     0.0     3.0   10.0 23.0             16     *   33 28 1 1   0     0     3   10 23         16       33
1535908 NY Chautauqua   school 3626730 62601040000   SHERMAN 362673003650 62601040003 SHERMAN HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 29.0 1.0 0.0   0.0           0.0   19.0 11.0     0       16     *   30 29 1 0   0           0   19 11     0   16       30
1536117 NY Chemung   school 3610560 70600010000   ELMIRA 361056000811 70600010019 BROADWAY ACADEMY public Regular School No Middle 07 07 2020   grade_7 310.0 65.0 12.0   1.0     1.0     68.0   239.0 218.0     *       *     *   457 310 65 12   1     1     68   239 218                 457
1536307 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001242 70901060010 HORSEHEADS MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 279.0 2.0 17.0         11.0     16.0   168.0 157.0     *       105     *   325 279 2 17         11     16   168 157         105       325
1536421 NY Chenango   school 3602400 80101040000   AFTON 360240000011 80101040003 AFTON JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 06 12 2020   grade_7 30.0 1.0 1.0         0.0     0.0   15.0 17.0             19     *   32 30 1 1         0     0   15 17         19       32
1536554 NY Chenango   school 3612750 80601040000   GREENE 361275004686 80601040004 GREENE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 71.0   4.0   1.0     1.0         32.0 45.0             50     *   77 71   4   1     1         32 45         50       77
1536687 NY Chenango   school 3622100 81401040000   GRGETWN-SO OTSELIC 362210003132 81401040001 OTSELIC VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 19.0 0.0 0.0                   9.0 10.0     0       10     *   19 19 0 0                   9 10     0   10       19
1537352 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   grade_7 0.0 2.0 0.0                   1.0 1.0             *     *   2 0 2 0                   1 1                 2
1537656 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_7 23.0 0.0 2.0         1.0     1.0   11.0 16.0             16     *   27 23 0 2         1     1   11 16         16       27
1537941 NY Cortland   school 3601188 110701861172   TRUXTON ACADEMY CHARTER SCHO 360118806703 110701861172 TRUXTON ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 02 2020   grade_7 0.0   0.0               0.0   0.0 0.0     *       0     *   0 0   0               0   0 0         0       0
1538055 NY Delaware   school 3609240 120301040000   DOWNSVILLE 360924000709 120301040001 DOWNSVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 16.0 0.0 1.0         0.0         10.0 7.0             11     *   17 16 0 1         0         10 7         11       17
1538074 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No Other PK 12 2020   grade_7 28.0 0.0 0.0         0.0     2.0   11.0 19.0             20     *   30 28 0 0         0     2   11 19         20       30
1538131 NY Delaware   school 3611430 120701040000   FRANKLIN 361143000900 120701040001 FRANKLIN CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 21.0 0.0 0.0   1.0     0.0     0.0   8.0 14.0             15     *   22 21 0 0   1     0     0   8 14         15       22
1538169 NY Delaware   school 3613560 120906040000   HANCOCK 361356001110 120906040002 HANCOCK JUNIOR-SENIOR HS public Regular School No High 05 12 2020   grade_7 17.0 1.0 3.0         0.0         10.0 11.0             14     *   21 17 1 3         0         10 11         14       21
1538245 NY Delaware   school 3626850 121601060000   SIDNEY 362685003664 121601060005 SIDNEY MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 74.0 1.0 8.0               5.0   48.0 40.0     *       *     *   88 74 1 8               5   48 40                 88
1538283 NY Delaware   school 3628020 121701040000   STAMFORD 362802003796 121701040001 STAMFORD CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 18.0 1.0 0.0   0.0     1.0         6.0 14.0             13     *   20 18 1 0   0     1         6 14         13       20
1538302 NY Delaware   school 3627330 121702040000   SOUTH KORTRIGHT 362733003730 121702040001 SOUTH KORTRIGHT CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 25.0 1.0 1.0         0.0     0.0   13.0 14.0             14     *   27 25 1 1         0     0   13 14         14       27
1538549 NY Dutchess   school 3609210 130502020000   DOVER 360921004332 130502020004 DOVER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 62.0 3.0 31.0         2.0     4.0   55.0 47.0     6       64     *   102 62 3 31         2     4   55 47     6   64       102
1540525 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Secondary 11 11 2020   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     0       *     *   0 0 0 0         0         0 0     0           0
1540715 NY Erie   school 3605850 140600010000   BUFFALO 360585000357 140600010066 PS 66 NORTH PARK MIDDLE ACADEMY public Regular School No Middle 07 08 2020   grade_7 1.0 20.0 1.0         1.0     1.0   12.0 12.0     *       21     *   24 1 20 1         1     1   12 12         21       24
1541209 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2020   grade_7 2.0 3.0 2.0   0.0           0.0   3.0 4.0     *       *     *   7 2 3 2   0           0   3 4                 7
1541323 NY Erie   school 3605850 140600010000   BUFFALO 360585006596 140600010309 NEWCOMER ACADEMY AT LAFAYETTE public Regular School No High 09 12 2020   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
1541570 NY Erie   school 3600073 140600860856   ENTERPRISE CHARTER SCHOOL 360007305551 140600860856 ENTERPRISE CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_7 0.0 25.0 13.0   1.0     1.0     3.0   14.0 29.0     *       42     *   43 0 25 13   1     1     3   14 29         42       43
1542938 NY Erie   school 3614550 141701040000   HOLLAND 361455006651 141701040004 HOLLAND MIDDLE SCHOOL public Regular School No Middle 03 08 2020   grade_7 63.0 1.0 3.0   0.0           1.0   30.0 38.0             26     *   68 63 1 3   0           1   30 38         26       68
1543033 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2020   grade_7 46.0 16.0 8.0   0.0     2.0     0.0   32.0 40.0     8       58     *   72 46 16 8   0     2     0   32 40     8   58       72
1543850 NY Essex   school 3616140 150601040000   KEENE 361614001394 150601040001 KEENE CENTRAL SCHOOL public Regular School No Other KG 12 2020   grade_7 11.0 0.0 1.0   0.0           0.0   7.0 5.0             *     *   12 11 0 1   0           0   7 5                 12
1543869 NY Essex   school 3619530 150801040000   MINERVA 361953001782 150801040001 MINERVA CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 9.0   1.0         0.0     0.0   3.0 7.0             6     *   10 9   1         0     0   3 7         6       10
1543926 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 4.0   0.0         0.0         1.0 3.0             *     *   4 4   0         0         1 3                 4
1543945 NY Essex   school 3616500 151102040000   LAKE PLACID 361650001460 151102040001 LAKE PLACID JUNIOR-SENIOR HIGH SCH public Regular School No High 06 12 2020   grade_7 38.0 1.0 0.0         0.0     1.0   23.0 17.0             21     *   40 38 1 0         0     1   23 17         21       40
1543983 NY Essex   school 3626130 151401040000   SCHROON LAKE 362613003599 151401040001 SCHROON LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 19.0 0.0 1.0                   13.0 7.0             12     *   20 19 0 1                   13 7         12       20
1544097 NY Essex   school 3601189 151801040000   BOQUET VALLEY CSD 360118904170 151801040002 LAKE VIEW CAMPUS public Regular School No Elementary KG 08 2020   grade_7 30.0 0.0           0.0         15.0 15.0             14     *   30 30 0           0         15 15         14       30
1544686 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001382 170600010007 KNOX JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2020   grade_7 113.0 0.0 5.0         1.0     1.0   58.0 62.0             66     *   120 113 0 5         1     1   58 62         66       120
1544743 NY Fulton   school 3621300 170901040000   NORTHVILLE 362130003038 170901040001 NORTHVILLE HIGH SCHOOL public Regular School No High 06 12 2020   grade_7 33.0 0.0 2.0         1.0     2.0   16.0 22.0     *       17     *   38 33 0 2         1     2   16 22         17       38
1545028 NY Genesee   school 3610380 180901040000   ELBA 361038000802 180901040002 ELBA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 23.0 0.0 3.0   0.0               13.0 13.0     *       9     *   26 23 0 3   0               13 13         9       26
1545123 NY Genesee   school 3622500 181201040000   PAVILION 362250003171 181201040001 PAVILION JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2020   grade_7 46.0 0.0 1.0         0.0         27.0 20.0     *       20     *   47 46 0 1         0         27 20         20       47
1545465 NY Greene   school 3615060 190901040000   HUNTER TANNERSVL 361506001259 190901040001 HUNTER-TANNERSVILLE MIDDLE/HIGH SCH public Regular School No Other 01 12 2020   grade_7 20.0   3.0         1.0     2.0   12.0 14.0             14     *   26 20   3         1     2   12 14         14       26
1545503 NY Greene   school 3631590 191401040000   WINDHAM ASHLAND 363159004225 191401040001 WINDHAM ASHLAND CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 20.0 1.0 1.0         1.0     0.0   10.0 13.0     0       13     *   23 20 1 1         1     0   10 13     0   13       23
1545522 NY Hamilton   school 3615270 200401040000   INDIAN LAKE 361527001285 200401040001 INDIAN LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 4.0 1.0 0.0         0.0     0.0   3.0 2.0             *     *   5 4 1 0         0     0   3 2                 5
1545541 NY Hamilton   school 3616530 200601040000   LAKE PLEASANT 361653001461 200601040001 LAKE PLEASANT SCHOOL public Regular School No Elementary PK 08 2020   grade_7 8.0                   1.0   3.0 6.0             *     *   9 8                   1   3 6                 9
1545560 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 5.0 0.0 0.0                   2.0 3.0     *       *     *   5 5 0 0                   2 3                 5
1545579 NY Hamilton   school 3630450 200901040000   WELLS 363045004096 200901040001 WELLS SCHOOL public Regular School No Other PK 12 2020   grade_7 8.0 1.0 0.0                   5.0 4.0             *     *   9 8 1 0                   5 4                 9
1545883 NY Herkimer   school 3622200 211701040000   VAN HORNSVILLE 362220003142 211701040001 OWEN D YOUNG CENTRAL SCHOOL public Regular School No Other KG 12 2020   grade_7 18.0   0.0               0.0   9.0 9.0             12     *   18 18   0               0   9 9         12       18
1545902 NY Herkimer   school 3628800 211901020000   TOWN OF WEBB 362880003908 211901020001 TOWN OF WEBB SCHOOL public Regular School No Other PK 12 2020   grade_7 17.0 1.0 0.0         0.0     0.0   11.0 7.0             8     *   18 17 1 0         0     0   11 7         8       18
1546491 NY Jefferson   school 3617880 221301040000   LYME 361788001604 221301040001 LYME CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 21.0 0.0 0.0         0.0     1.0   11.0 11.0     *       10     *   22 21 0 0         0     1   11 11         10       22

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