Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_7", state = "NY" and year = 2017 sorted by disability

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_7 · 4,722
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
942386 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_7 4.0 51.0 6.0   1.0     1.0     1.0   31.0 33.0             41         64 4 51 6   1     1     1   31 33         41       64
942405 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
989810 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   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
1000792 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_7 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1009228 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_7 7.0 1.0 27.0   0.0     10.0         25.0 20.0     45       44         45 7 1 27   0     10         25 20     45   44       45
1016258 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_7 0.0 0.0                     0.0 0.0             0         0 0 0                     0 0         0       0
1022718 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2017   grade_7 0.0   0.0         0.0         0.0 0.0     *                 0 0   0         0         0 0                 0
1028912 NY Westchester   school 3601051 660900861000   AMANI PUBLIC CHARTER SCHOOL 360105106291 660900861000 AMANI PUBLIC CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_7 3.0 80.0 7.0   2.0     1.0     1.0   54.0 40.0                       94 3 80 7   2     1     1   54 40                 94
942329 NY Albany   school 3602460 10100010000   ALBANY 360246006538 10100010046 WEST HILL MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_7 5.0 62.0 13.0         0.0     4.0   51.0 33.0             71     *   84 5 62 13         0     4   51 33         71       84
942956 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 122.0 12.0 6.0   1.0     11.0     6.0   73.0 85.0             42     *   158 122 12 6   1     11     6   73 85         42       158
942975 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_7 8.0 6.0 0.0   0.0     8.0     0.0   7.0 15.0     *       9     *   22 8 6 0   0     8     0   7 15         9       22
943488 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_7 21.0 0.0 0.0         0.0         10.0 11.0             12     *   21 21 0 0         0         10 11         12       21
943507 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 18.0 1.0 1.0               0.0   8.0 12.0             13     *   20 18 1 1               0   8 12         13       20
943621 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 23.0 0.0 0.0   0.0     0.0     1.0   16.0 8.0             17     *   24 23 0 0   0     0     1   16 8         17       24
944039 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2017   grade_7 1.0 34.0 89.0   1.0     0.0         77.0 48.0     27       *     *   125 1 34 89   1     0         77 48     27           125
945084 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2017   grade_7 34.0 13.0 85.0   2.0     19.0     0.0   80.0 73.0     *       *     *   153 34 13 85   2     19     0   80 73                 153
945160 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502463 320800010125 JHS 125 HENRY HUDSON public Regular School No Middle 06 08 2017   grade_7 12.0 12.0 65.0   2.0     19.0     0.0   61.0 49.0     *       *     *   110 12 12 65   2     19     0   61 49                 110
945502 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506081 320800010424 HUNTS POINT SCHOOL (THE) public Regular School No Middle 06 08 2017   grade_7   16.0 82.0   2.0     0.0     1.0   50.0 51.0     25       88     *   101   16 82   2     0     1   50 51     25   88       101
946509 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602528 320900010145 JHS 145 ARTURO TOSCANINI public Regular School No Middle 05 08 2017   grade_7 2.0 15.0 56.0         2.0         42.0 33.0     42       *     *   75 2 15 56         2         42 33     42           75
946604 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605790 320900010215 KAPPA public Regular School No Middle 05 08 2017   grade_7 0.0 37.0 31.0   1.0     10.0     0.0   37.0 42.0     15       58     *   79 0 37 31   1     10     0   37 42     15   58       79
946794 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 2017   grade_7 0.0 33.0 58.0         0.0         49.0 42.0     32       *     *   91 0 33 58         0         49 42     32           91
947060 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605670 320900011231 EAGLE ACADEMY FOR YOUNG MEN public Regular School No Other 06 12 2017   grade_7 0.0 29.0 25.0   1.0     1.0     1.0   57.0       *       52     *   57 0 29 25   1     1     1   57           52       57
947497 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 17.0 14.0   0.0     0.0         18.0 13.0     *       26     *   31 0 17 14   0     0         18 13         26       31
947573 NY Bronx   school 3601012 320900860980   SUCCESS ACADEMY -BRONX 2 360101206219 320900860980 SUCCESS ACADEMY CHARTER-BRONX 2 charter Regular School Yes Elementary KG 07 2017   grade_7 0.0 39.0 29.0   0.0     2.0     0.0   39.0 31.0     0       *     *   70 0 39 29   0     2     0   39 31     0           70
948504 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702939 321000010315 PS 315 LAB SCHOOL public Regular School No Elementary KG 08 2017   grade_7 0.0 3.0 28.0   1.0     0.0     0.0   21.0 11.0     5       30     *   32 0 3 28   1     0     0   21 11     5   30       32
948903 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No Other 06 12 2017   grade_7 0.0 0.0 51.0                   23.0 28.0     31       47     *   51 0 0 51                   23 28     31   47       51
948979 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706010 321000011397 ENGLISH LANGUAGE LEARNERS-INTER SUPP public Regular School No High 09 12 2017   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
949397 NY Bronx   school 3601138 321000861075   ATMOSPHERE ACADEMY PUBLIC CH 360113806563 321000861075 ATMOSPHERE ACADEMY PUBLIC CHARTER charter Regular School Yes Middle 06 07 2017   grade_7 3.0 27.0 87.0         2.0         54.0 65.0     12       100     *   119 3 27 87         2         54 65     12   100       119
950005 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805801 321100010289 YOUNG SCHOLARS ACADEMY-BRONX public Regular School No Middle 06 08 2017   grade_7 2.0 61.0 28.0   2.0     5.0         56.0 42.0     17       *     *   98 2 61 28   2     5         56 42     17           98
950024 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805953 321100010326 BRONX GREEN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 14.0 35.0 70.0   0.0     12.0     0.0   69.0 62.0     16       124     *   131 14 35 70   0     12     0   69 62     16   124       131
950214 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806249 321100010532 BAYCHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 1.0 71.0 24.0   3.0     0.0     1.0   58.0 42.0     *       84     *   100 1 71 24   3     0     1   58 42         84       100
950233 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806314 321100010556 BRONX PARK MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 14.0 24.0 71.0         14.0     0.0   64.0 59.0     20       114     *   123 14 24 71         14     0   64 59     20   114       123
950651 NY Bronx   school 3600943 321100860909   ICAHN CHARTER SCHOOL 2 360094305973 321100860909 ICAHN CHARTER SCHOOL 2 charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 13.0 18.0   0.0     2.0     0.0   13.0 20.0     0       20     *   33 0 13 18   0     2     0   13 20     0   20       33
950689 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 21.0 13.0   0.0     0.0     0.0   14.0 20.0     *       26     *   34 0 21 13   0     0     0   14 20         26       34
950727 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 07 2017   grade_7 1.0 21.0 8.0         0.0     0.0   12.0 18.0     *       20     *   30 1 21 8         0     0   12 18         20       30
951012 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005166 321200010190 ESMT-IS 190 public Regular School No Middle 06 08 2017   grade_7 1.0 15.0 62.0   2.0     1.0         35.0 46.0     9       70     *   81 1 15 62   2     1         35 46     9   70       81
951335 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006075 321200010384 ENTRADA ACADEMY public Regular School No Middle 06 08 2017   grade_7 2.0 7.0 57.0   1.0     1.0         35.0 33.0     38       *     *   68 2 7 57   1     1         35 33     38           68
951753 NY Bronx   school 3600161 321200860898   SOUTH BRONX CLASSICAL CHARTE 360016105893 321200860898 SOUTH BRONX CLASSICAL CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_7 0.0 15.0 22.0   0.0     2.0     0.0   18.0 21.0     0       34     *   39 0 15 22   0     2     0   18 21     0   34       39
952456 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 170.0 30.0 17.0         6.0     23.0   124.0 122.0     *       146     *   246 170 30 17         6     23   124 122         146       246
953178 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003298 42901040002 PORTVILLE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 72.0 0.0 0.0   0.0     1.0     0.0   35.0 38.0             34     *   73 72 0 0   0     1     0   35 38         34       73
953197 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 45.0 0.0 3.0   2.0     0.0     2.0   19.0 33.0             26     *   52 45 0 3   2     0     2   19 33         26       52
953311 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA ELEMENTARY SCHOOL public Regular School No Elementary 04 07 2017   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 1 0 0   0     0     0   0 1                 1
953596 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004435 50401040002 CATO-MERIDIAN MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 60.0 0.0 2.0   0.0     0.0     4.0   33.0 33.0             25     *   66 60 0 2   0     0     4   33 33         25       66
953938 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000451 60401040006 CASSADAGA VALLEY MIDDLE/HIGH SCHOOL public Regular School No Other 06 12 2017   grade_7 58.0 2.0 1.0   0.0     1.0     0.0   33.0 29.0             *     *   62 58 2 1   0     1     0   33 29                 62
954014 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003232 60601040003 PINE VALLEY CENTRAL JR-SR HIGH SCH public Regular School No High 07 12 2017   grade_7 45.0   0.0   0.0     0.0         25.0 20.0             26     *   45 45   0   0     0         25 20         26       45
954185 NY Chautauqua   school 3604530 61001040000   BEMUS POINT 360453000201 61001040005 MAPLE GROVE JUNIOR/SENIOR HIGH public Regular School No Other 06 12 2017   grade_7 56.0 0.0 1.0         1.0     0.0   32.0 26.0             *     *   58 56 0 1         1     0   32 26                 58
954356 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 34.0   2.0               0.0   18.0 18.0             19     *   36 34   2               0   18 18         19       36
954584 NY Chautauqua   school 3611520 62201060000   FREDONIA 361152000908 62201060002 FREDONIA MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 85.0 1.0 9.0         1.0     3.0   60.0 39.0     *       40     *   99 85 1 9         1     3   60 39         40       99
955097 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001242 70901060010 HORSEHEADS MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_7 300.0 5.0 7.0   2.0     9.0     9.0   162.0 170.0     *       *     *   332 300 5 7   2     9     9   162 170                 332
955230 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000123 80201040001 BAINBRIDGE-GUILFORD HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 47.0 0.0 0.0   0.0     0.0     1.0   32.0 16.0     *       20     *   48 47 0 0   0     0     1   32 16         20       48
955344 NY Chenango   school 3612750 80601040000   GREENE 361275004686 80601040004 GREENE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 62.0 1.0 1.0   0.0     1.0         31.0 34.0             *     *   65 62 1 1   0     1         31 34                 65
956123 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2017   grade_7 1.0 4.0 0.0                   5.0 0.0             *     *   5 1 4 0                   5 0                 5
956465 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_7 29.0 0.0 2.0         0.0     1.0   20.0 12.0             11     *   32 29 0 2         0     1   20 12         11       32
956845 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 5.0 0.0 1.0               0.0   3.0 3.0             *     *   6 5 0 1               0   3 3                 6
956883 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No Other PK 12 2017   grade_7 24.0 1.0 1.0         0.0     1.0   12.0 15.0             15     *   27 24 1 1         0     1   12 15         15       27
956921 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000681 120501040002 DELAWARE ACADEMY HIGH SCHOOL public Regular School No Other 06 12 2017   grade_7 51.0 1.0 0.0   1.0     0.0     2.0   25.0 30.0     *       22     *   55 51 1 0   1     0     2   25 30         22       55
956940 NY Delaware   school 3611430 120701040000   FRANKLIN 361143000900 120701040001 FRANKLIN CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 16.0 1.0 1.0   0.0     0.0     0.0   9.0 9.0             8     *   18 16 1 1   0     0     0   9 9         8       18
957092 NY Delaware   school 3628020 121701040000   STAMFORD 362802003796 121701040001 STAMFORD CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 17.0 0.0 3.0         0.0         12.0 8.0             8     *   20 17 0 3         0         12 8         8       20
957111 NY Delaware   school 3627330 121702040000   SOUTH KORTRIGHT 362733003730 121702040001 SOUTH KORTRIGHT CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 26.0 0.0 2.0         1.0     0.0   8.0 21.0             12     *   29 26 0 2         1     0   8 21         12       29
957529 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039005848 131101040007 EUGENE BROOKS MIDDLE SCHOOL public Regular School No Elementary 04 08 2017   grade_7 34.0 2.0 9.0         0.0     2.0   23.0 24.0     *       *     *   47 34 2 9         0     2   23 24                 47
958403 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_7 250.0 36.0 66.0         19.0     7.0   206.0 172.0     5       *     *   378 250 36 66         19     7   206 172     5           378
959277 NY Erie   school 3605850 140600010000   BUFFALO 360585000329 140600010027 PS 27 HILLERY PARK ACADEMY public Regular School No Elementary PK 8 2017   grade_7 19.0 17.0 11.0   0.0     0.0     4.0   26.0 25.0     0       41     *   51 19 17 11   0     0     4   26 25     0   41       51
959771 NY Erie   school 3605850 140600010000   BUFFALO 360585000297 140600010097 BUFFALO ACADEMY-VIS & PERF ARTS public Regular School No Other 05 12 2017   grade_7 11.0 36.0 10.0   1.0     1.0     3.0   12.0 50.0     0       40     *   62 11 36 10   1     1     3   12 50     0   40       62
960075 NY Erie   school 3605850 140600010000   BUFFALO 360585005858 140600010130 FRANK A SEDITA SCHOOL #30 public Regular School No Elementary PK 8 2017   grade_7 1.0 13.0 50.0   0.0     2.0     2.0   29.0 39.0     22       60     *   68 1 13 50   0     2     2   29 39     22   60       68
960094 NY Erie   school 3605850 140600010000   BUFFALO 360585005857 140600010132 MATH SCIENCE TECH PREP SCHOOL-SENECA public Regular School No Other 05 12 2017   grade_7 0.0 33.0 3.0   0.0     0.0     1.0   15.0 22.0     *       34     *   37 0 33 3   0     0     1   15 22         34       37
960246 NY Erie   school 3605850 140600010000   BUFFALO 360585006596 140600010309 NEWCOMER ACADEMY AT LAFAYETTE public Regular School No High 07 12 2017   grade_7 4.0 7.0 0.0         4.0     0.0   4.0 11.0     15       12     *   15 4 7 0         4     0   4 11     15   12       15
960436 NY Erie   school 3600160 140600860896   ELMWOOD VILLAGE CHARTER SCHO 360016005851 140600860896 ELMWOOD VILLAGE CHARTER SCHOOL charter Regular School Yes Elementary KG 8 2017   grade_7 10.0 8.0 3.0   0.0     1.0     1.0   11.0 12.0     0       14     *   23 10 8 3   0     1     1   11 12     0   14       23
961386 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000493 141501060005 VERONICA E CONNOR MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_7 221.0 6.0 11.0   1.0     9.0     9.0   125.0 132.0     *       60     *   257 221 6 11   1     9     9   125 132         60       257
961500 NY Erie   school 3613350 141601060000   HAMBURG 361335001098 141601060006 HAMBURG MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_7 285.0 1.0 7.0   1.0     4.0     8.0   157.0 149.0     *       71     *   306 285 1 7   1     4     8   157 149         71       306
962564 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 18.0 0.0           0.0         7.0 11.0     *       10     *   18 18 0           0         7 11         10       18
962583 NY Essex   school 3610440 150301040000   ELIZABETHTOWN 361044000804 150301040001 ELIZABETHTOWN-LEWIS CENTRAL SCHOOL public Regular School No Other KG 12 2017   grade_7 18.0 0.0     0.0     0.0         7.0 11.0             11     *   18 18 0     0     0         7 11         11       18
962602 NY Essex   school 3616140 150601040000   KEENE 361614001394 150601040001 KEENE CENTRAL SCHOOL public Regular School No Other KG 12 2017   grade_7 9.0 1.0 0.0   0.0     0.0     1.0   6.0 5.0             7     *   11 9 1 0   0     0     1   6 5         7       11
962621 NY Essex   school 3619530 150801040000   MINERVA 361953001782 150801040001 MINERVA CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 7.0 0.0 0.0         0.0     0.0   3.0 4.0             *     *   7 7 0 0         0     0   3 4                 7
962678 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 5.0   0.0         0.0         4.0 1.0             *     *   5 5   0         0         4 1                 5
962735 NY Essex   school 3626130 151401040000   SCHROON LAKE 362613003599 151401040001 SCHROON LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 12.0 0.0 0.0                   5.0 7.0     *       8     *   12 12 0 0                   5 7         8       12
962811 NY Essex   school 3631080 151601040000   WESTPORT 363108004170 151601040001 WESTPORT CENTRAL SCHOOL public Regular School No Other KG 12 2017   grade_7 15.0                   3.0   9.0 9.0     *       11     *   18 15                   3   9 9         11       18
962830 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 16.0 0.0 0.0   0.0           0.0   6.0 10.0             8     *   16 16 0 0   0           0   6 10         8       16
962906 NY Franklin   school 3607080 160801040000   CHATEAUGAY 360708000498 160801040002 CHATEAUGAY HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 37.0       0.0     1.0         16.0 22.0             13     *   38 37       0     1         16 22         13       38
963229 NY Fulton   school 3631200 170301020000   WHEELERVILLE 363120004173 170301020001 WHEELERVILLE SCHOOL public Regular School No Elementary PK 8 2017   grade_7 15.0   0.0               1.0   10.0 6.0             12     *   16 15   0               1   10 6         12       16
963628 NY Fulton   school 3601107 271201040000   OPPENHEIM-EPHRATAH-ST. JOHNSV 360110703789 271201040004 OPPENHEIM-EPHRATAH-ST JOHNSVILLE JS public Regular School No High 07 12 2017   grade_7 45.0 0.0 4.0   0.0     0.0         25.0 24.0             45     *   49 45 0 4   0     0         25 24         45       49
963666 NY Genesee   school 3602580 180202040000   ALEXANDER 360258000043 180202040003 ALEXANDER MIDDLE SCHOOL-HIGH SCHOOL public Regular School No Other 05 12 2017   grade_7 55.0 1.0 0.0         2.0     0.0   30.0 28.0             22     *   58 55 1 0         2     0   30 28         22       58
963818 NY Genesee   school 3610380 180901040000   ELBA 361038000802 180901040002 ELBA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 20.0 2.0 8.0   0.0               16.0 14.0     *       14     *   30 20 2 8   0               16 14         14       30
964312 NY Hamilton   school 3615270 200401040000   INDIAN LAKE 361527001285 200401040001 INDIAN LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 11.0 0.0 0.0         0.0         6.0 5.0             *     *   11 11 0 0         0         6 5                 11
964331 NY Hamilton   school 3615330 200501080000   INLET 361533001291 200501080001 INLET ELEMENTARY SCHOOL public Regular School No Elementary PK 6 2017   grade_7 0.0   0.0         0.0         0.0 0.0             0     *   0 0   0         0         0 0         0       0
964654 NY Herkimer   school 3623370 211103040000   POLAND 362337003269 211103040001 POLAND JUNIOR-SENIOR HIGH SCHOOL public Regular School No Other 05 12 2017   grade_7 38.0 0.0 1.0         0.0     1.0   16.0 24.0             20     *   40 38 0 1         0     1   16 24         20       40
964711 NY Herkimer   school 3628800 211901020000   TOWN OF WEBB 362880003908 211901020001 TOWN OF WEBB SCHOOL public Regular School No Other KG 12 2017   grade_7 17.0 0.0 0.0   0.0     0.0         7.0 10.0             10     *   17 17 0 0   0     0         7 10         10       17
965300 NY Jefferson   school 3617880 221301040000   LYME 361788001604 221301040001 LYME CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 27.0 0.0 1.0         1.0         12.0 17.0             11     *   29 27 0 1         1         12 17         11       29
965319 NY Jefferson   school 3616380 221401040000   LA FARGEVILLE 361638001446 221401040001 LA FARGEVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 30.0 2.0 1.0   0.0     0.0     0.0   14.0 19.0             13     *   33 30 2 1   0     0     0   14 19         13       33
965946 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105695 331300010301 SATELLITE EAST MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_7 3.0 20.0 4.0   1.0     6.0         15.0 19.0     *       33     *   34 3 20 4   1     6         15 19         33       34
966003 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105696 331300010313 DOCK STREET SCHOOL public Regular School No Middle 06 8 2017   grade_7 0.0 5.0 11.0         0.0     0.0   11.0 5.0     *       *     *   16 0 5 11         0     0   11 5                 16
968397 NY Kings   school 3600146 331500860878   HELLENIC CLASSICAL CHARTER 360014605815 331500860878 HELLENIC CLASSICAL CHARTER SCHOOL charter Regular School Yes Elementary PK 8 2017   grade_7 14.0 17.0 20.0   0.0     0.0     0.0   20.0 31.0     *       33     *   51 14 17 20   0     0     0   20 31         33       51
968625 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402163 331600010035 MS 35 STEPHEN DECATUR public Regular School No Middle 06 8 2017   grade_7   35.0 7.0   0.0     1.0     0.0   21.0 22.0     *       *     *   43   35 7   0     1     0   21 22                 43
968739 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009404053 331600010267 MS 267 MATH, SCIENCE & TECH public Regular School No Middle 06 8 2017   grade_7 0.0 25.0 13.0   1.0     2.0     0.0   24.0 17.0     *       *     *   41 0 25 13   1     2     0   24 17                 41
969442 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502760 331700010246 MS 246 WALT WHITMAN public Regular School No Middle 06 8 2017   grade_7 6.0 104.0 30.0   1.0     0.0         83.0 58.0     47       97     *   141 6 104 30   1     0         83 58     47   97       141
969518 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009504813 331700010340 IS 340 public Regular School No Middle 06 8 2017   grade_7 0.0 60.0 11.0   2.0     1.0     0.0   30.0 44.0     *       58     *   74 0 60 11   2     1     0   30 44         58       74
969689 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505870 331700010484 RONALD EDMONDS LEARNING CTR II public Regular School No Middle 06 8 2017   grade_7 0.0 32.0 5.0   1.0               23.0 15.0     *       *     *   38 0 32 5   1               23 15                 38
969746 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009506335 331700010722 NEW HEIGHTS MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_7 0.0 55.0 10.0   0.0     1.0         37.0 29.0     *       58     *   66 0 55 10   0     1         37 29         58       66
969803 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505916 331700011382 ACAD FOR COLLEGE PREP AND CAREER EXP public Regular School No Other 06 12 2017   grade_7 0.0 29.0 6.0   4.0     2.0     0.0   25.0 16.0     *       33     *   41 0 29 6   4     2     0   25 16         33       41
969898 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505709 331700011531 SCHOOL FOR HUMAN RIGHTS (THE) public Regular School No Other 06 12 2017   grade_7 0.0 11.0 2.0   0.0     1.0     0.0   7.0 7.0     *       12     *   14 0 11 2   0     1     0   7 7         12       14
969917 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505710 331700011533 SCHOOL FOR DEMOCRACY & LDRSHP public Regular School No Other 06 12 2017   grade_7 0.0 10.0 2.0   0.0     0.0         6.0 6.0     *       10     *   12 0 10 2   0     0         6 6         10       12

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