Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2017 sorted by low_income descending

View and edit SQL

year

  • 2017 · 89,718
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
1003894 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801915 342400011610 AVIATION CAREER AND TECH HIGH SCHOOL public Career and Technical School No High 09 12 2017   pk_12_total 215.0 104.0 965.0   18.0     720.0     79.0   1692.0 409.0     56       998     266   2101 215 104 965   18     720     79   1692 409     56   998   266   2101
981094 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001153 280201030010 ALVERTA B GRAY SCHULTZ MIDDLE SCH public Regular School No Other 06 09 2017   pk_12_total 54.0 393.0 984.0   4.0     12.0     5.0   764.0 688.0     488       994     161   1452 54 393 984   4     12     5   764 688     488   994   161   1452
967699 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204474 331500010088 JHS 88 PETER ROUGET public Regular School No Middle 06 8 2017   pk_12_total 148.0 129.0 780.0   3.0     239.0     9.0   713.0 595.0     148       993     361   1308 148 129 780   3     239     9   713 595     148   993   361   1308
1030000 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003278 661904030008 PORT CHESTER SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 224.0 81.0 1104.0         24.0     3.0   759.0 677.0     255       990     151   1436 224 81 1104         24     3   759 677     255   990   151   1436
944307 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405187 320700011473 MOTT HAVEN VILLAGE PREP HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 2.0 26.0 73.0   1.0     1.0     0.0   58.0 45.0     18       99     37   103 2 26 73   1     1     0   58 45     18   99   37   103
944929 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502211 320800010048 PS 48 JOSEPH R DRAKE public Regular School No Elementary PK 05 2017   grade_4 0.0 34.0 79.0   1.0     2.0     0.0   59.0 57.0     23       99     41   116 0 34 79   1     2     0   59 57     23   99   41   116
945208 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502505 320800010138 PS 138 SAMUEL RANDALL public Regular School No Elementary PK 05 2017   grade_1 1.0 30.0 78.0   1.0     5.0     1.0   57.0 59.0     7       99     *   116 1 30 78   1     5     1   57 59     7   99       116
945446 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505982 320800010371 URBAN INSTITUTE OF MATHEMATICS public Regular School No Middle 06 08 2017   grade_8 23.0 22.0 65.0   1.0     3.0     0.0   67.0 47.0     5       99     22   114 23 22 65   1     3     0   67 47     5   99   22   114
945520 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506156 320800010448 SOUNDVIEW ACADEMY public Regular School No Middle 06 08 2017   grade_6 4.0 39.0 86.0   0.0     2.0         63.0 68.0     9       99     37   131 4 39 86   0     2         63 68     9   99   37   131
947043 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605669 320900011227 BRONX COLLEGIATE ACADEMY public Regular School No High 09 12 2017   grade_9 1.0 38.0 83.0         4.0     0.0   57.0 69.0     31       99     37   126 1 38 83         4     0   57 69     31   99   37   126
947837 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702155 321000010033 PS 33 TIMOTHY DWIGHT public Regular School No Elementary PK 05 2017   grade_5 2.0 9.0 127.0   3.0     1.0     0.0   71.0 71.0     54       99     39   142 2 9 127   3     1     0   71 71     54   99   39   142
947994 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706507 321000010077 BEDFORD PARK ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   kindergarten_full_day 7.0 6.0 76.0   5.0     12.0     0.0   56.0 50.0     31       99     17   106 7 6 76   5     12     0   56 50     31   99   17   106
948241 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700739 321000010209 PS 209 public Regular School No Elementary PK 02 2017   kindergarten_full_day 0.0 16.0 84.0         1.0         42.0 59.0     18       99     31   101 0 16 84         1         42 59     18   99   31   101
948387 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704695 321000010280 PS/MS 280 MOSHOLU PARKWAY public Regular School No Elementary KG 08 2017   grade_4 6.0 8.0 76.0   0.0     14.0         59.0 45.0     22       99     39   104 6 8 76   0     14         59 45     22   99   39   104
948800 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705674 321000011243 WEST BRONX ACAD FOR THE FUTURE public Regular School No Other 06 12 2017   grade_10 3.0 18.0 81.0   0.0     2.0         56.0 48.0     14       99     35   104 3 18 81   0     2         56 48     14   99   35   104
949380 NY Bronx   school 3601133 321000861064   CHARTER HIGH SCHOOL-LAW AND 360113306569 321000861064 CHARTER HIGH SCHOOL-LAW AND SOCIAL charter Regular School Yes Other 09 10 2017   grade_9 2.0 41.0 74.0   2.0     0.0     1.0   53.0 67.0     *       99     22   120 2 41 74   2     0     1   53 67         99   22   120
949545 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802323 321100010083 PS 83 DONALD HERTZ public Regular School No Elementary KG 08 2017   grade_3 63.0 17.0 103.0   1.0     16.0     0.0   103.0 97.0     38       99     44   200 63 17 103   1     16     0   103 97     38   99   44   200
950870 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005509 321200010066 PS 66 SCHOOL OF HIGHER EXPECTATIONS public Regular School No Elementary PK 05 2017   grade_1 2.0 34.0 82.0   0.0     0.0     0.0   62.0 56.0     24       99     23   118 2 34 82   0     0     0   62 56     24   99   23   118
950972 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002491 321200010134 PS 134 GEORGE F BRISTOW public Regular School No Elementary PK 05 2017   grade_5 2.0 52.0 44.0   1.0     1.0     0.0   41.0 59.0     16       99     17   100 2 52 44   1     1     0   41 59     16   99   17   100
951048 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003369 321200010196 PS 196 public Regular School No Elementary PK 05 2017   grade_5 3.0 30.0 100.0   6.0     0.0         73.0 66.0     *       99     33   139 3 30 100   6     0         73 66         99   33   139
951650 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009001327 321200011682 FANNIE LOU HAMER FREEDOM HS public Regular School No High 09 12 2017   grade_10 1.0 38.0 96.0   2.0     0.0         79.0 58.0     11       99     40   137 1 38 96   2     0         79 58     11   99   40   137
951669 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009001332 321200011684 WINGS ACADEMY public Regular School No High 09 12 2017   grade_10 1.0 56.0 51.0   0.0     0.0     2.0   67.0 43.0     6       99     25   110 1 56 51   0     0     2   67 43     6   99   25   110
953379 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 180.0 4.0 0.0   0.0     2.0         108.0 78.0     *       99     31   186 180 4 0   0     2         108 78         99   31   186
955045 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001236 70901060005 BIG FLATS SCHOOL public Regular School No Elementary PK 04 2017   pk_12_total 331.0 5.0 14.0         7.0     11.0   194.0 174.0     *       99     46   368 331 5 14         7     11   194 174         99   46   368
956308 NY Columbia   school 3614940 101300010000   HUDSON 361494001250 101300010002 JOHN L EDWARDS PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 67.0 21.0 17.0         13.0     18.0   74.0 62.0     21       99     20   136 67 21 17         13     18   74 62     21   99   20   136
957755 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003306 131500010009 MORSE YOUNG MAGNET SCHOOL public Regular School No Elementary KG 05 2017   grade_5 8.0 48.0 44.0   0.0     2.0     7.0   59.0 50.0     14       99     33   109 8 48 44   0     2     7   59 50     14   99   33   109
959732 NY Erie   school 3605850 140600010000   BUFFALO 360585004506 140600010093 SOUTHSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 8 2017   grade_6 53.0 31.0 11.0   2.0     11.0     8.0   54.0 62.0     17       99     33   116 53 31 11   2     11     8   54 62     17   99   33   116
959733 NY Erie   school 3605850 140600010000   BUFFALO 360585004506 140600010093 SOUTHSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 8 2017   grade_7 52.0 34.0 11.0   3.0     8.0     6.0   66.0 48.0     8       99     37   114 52 34 11   3     8     6   66 48     8   99   37   114
960015 NY Erie   school 3605850 140600010000   BUFFALO 360585001549 140600010126 STANLEY MAKOWSKI EARLY CHLDHD CTR public Regular School No Elementary PK 4 2017   grade_4 2.0 85.0 8.0   0.0     12.0     1.0   56.0 52.0     7       99     24   108 2 85 8   0     12     1   56 52     7   99   24   108
960287 NY Erie   school 3600036 140600860817   SOUTH BUFFALO CHARTER SCHOOL 360003604337 140600860817 SOUTH BUFFALO CHARTER SCHOOL charter Regular School Yes Elementary KG 8 2017   kindergarten_full_day 48.0 28.0 28.0   3.0     3.0     1.0   63.0 48.0     *       99     13   111 48 28 28   3     3     1   63 48         99   13   111
961861 NY Erie   school 3616680 141901060000   LANCASTER 361668001482 141901060007 LANCASTER MIDDLE SCHOOL public Regular School No Middle 07 8 2017   grade_7 420.0 3.0 5.0   1.0     11.0     5.0   233.0 212.0     *       99     61   445 420 3 5   1     11     5   233 212         99   61   445
962203 NY Erie   school 3616230 142601030000   KENMORE 361623001403 142601030003 BEN FRANKLIN MIDDLE SCHOOL public Regular School No Middle 05 7 2017   grade_7 172.0 17.0 10.0   1.0     1.0     4.0   108.0 97.0     *       99     53   205 172 17 10   1     1     4   108 97         99   53   205
962443 NY Erie   school 3630780 142801060000   WEST SENECA 363078004151 142801060010 WEST SENECA WEST SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_11 265.0 4.0 4.0   0.0     2.0     1.0   145.0 131.0             99     38   276 265 4 4   0     2     1   145 131         99   38   276
971281 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002572 331900010159 PS 159 ISAAC PITKIN public Regular School No Elementary KG 5 2017   grade_3 0.0 48.0 40.0   4.0     40.0     0.0   60.0 72.0     31       99     25   132 0 48 40   4     40     0   60 72     31   99   25   132
971283 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002572 331900010159 PS 159 ISAAC PITKIN public Regular School No Elementary KG 5 2017   grade_5 3.0 50.0 36.0   3.0     42.0     0.0   74.0 60.0     20       99     24   134 3 50 36   3     42     0   74 60     20   99   24   134
972368 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102391 332000010104 PS/IS 104 FORT HAMILTON SCH (THE) public Regular School No Elementary KG 8 2017   grade_7 81.0 3.0 49.0   1.0     29.0     3.0   83.0 83.0     16       99     25   166 81 3 49   1     29     3   83 83     16   99   25   166
972599 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102641 332000010186 PS 186 DR IRVING A GLADSTONE public Regular School No Elementary PK 5 2017   kindergarten_full_day 50.0 0.0 47.0   0.0     74.0     2.0   84.0 89.0     61       99     31   173 50 0 47   0     74     2   84 89     61   99   31   173
973290 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202619 332100010177 PS 177 MARLBORO (THE) public Regular School No Elementary PK 5 2017   grade_1 61.0 2.0 53.0   9.0     34.0     0.0   76.0 83.0     63       99     34   159 61 2 53   9     34     0   76 83     63   99   34   159
973296 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202619 332100010177 PS 177 MARLBORO (THE) public Regular School No Elementary PK 5 2017   grade_4 65.0 2.0 48.0   1.0     43.0     0.0   82.0 77.0     48       99     33   159 65 2 48   1     43     0   82 77     48   99   33   159
973446 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202734 332100010226 PS 226 ALFRED DE B MASON public Regular School No Elementary PK 8 2017   grade_2 38.0 0.0 38.0   1.0     31.0     1.0   54.0 55.0     31       99     19   109 38 0 38   1     31     1   54 55     31   99   19   109
973523 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202767 332100010253 PS 253 public Regular School No Elementary PK 5 2017   grade_3 32.0 2.0 50.0   1.0     51.0     1.0   63.0 74.0     29       99     23   137 32 2 50   1     51     1   63 74     29   99   23   137
973624 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015205823 332100011337 INTERNATIONAL HIGH SCH-LAFAYETTE public Regular School No High 09 12 2017   grade_9 27.0 5.0 29.0   0.0     40.0         62.0 39.0     91       99     *   101 27 5 29   0     40         62 39     91   99       101
974566 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015300829 332200011555 BROOKLYN COLLEGE ACADEMY public Regular School No High 09 12 2017   grade_12 13.0 100.0 14.0   2.0     14.0     4.0   55.0 92.0     *       99     7   147 13 100 14   2     14     4   55 92         99   7   147
975185 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105997 332300011643 BROOKLYN DEMOCRACY ACADEMY public Regular School No High 09 12 2017   pk_12_total 1.0 119.0 19.0   4.0     1.0         93.0 51.0     *       99     32   144 1 119 19   4     1         93 51         99   32   144
975373 NY Kings   school 3601002 332300860954   BROWNSVILLE ASCEND CHARTER 360100206167 332300860954 BROWNSVILLE ASCEND CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   kindergarten_full_day 0.0 99.0 9.0   1.0     1.0     0.0   45.0 65.0     *       99     14   110 0 99 9   1     1     0   45 65         99   14   110
975839 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009700827 333200011545 EBC HIGH SCHOOL-PUBLIC SERVICE public Regular School No High 09 12 2017   grade_12 0.0 11.0 94.0   2.0     1.0         62.0 46.0     *       99     25   108 0 11 94   2     1         62 46         99   25   108
978849 NY Monroe   school 3607530 261501060000   CHURCHVILLE CHILI 360753000536 261501060004 CHURCHVILLE-CHILI SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 251.0 22.0 12.0         8.0     14.0   154.0 153.0     *       99     48   307 251 22 12         8     14   154 153         99   48   307
978884 NY Monroe   school 3607530 261501060000   CHURCHVILLE CHILI 360753002002 261501060008 CHURCHVILLE-CHILI MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_6 239.0 27.0 22.0   0.0     1.0     12.0   168.0 133.0     *       99     *   301 239 27 22   0     1     12   168 133         99       301
978943 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003378 261600010003 SCHOOL 3-NATHANIEL ROCHESTER public Regular School No Elementary PK 08 2017   grade_8 15.0 75.0 10.0   0.0     5.0     1.0   53.0 53.0     8       99     14   106 15 75 10   0     5     1   53 53     8   99   14   106
981461 NY Nassau   school 3609840 280203030000   EAST MEADOW 360984000756 280203030011 EAST MEADOW HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 220.0 17.0 70.0   0.0     68.0     1.0   189.0 187.0     8       99     51   376 220 17 70   0     68     1   189 187     8   99   51   376
981645 NY Nassau   school 3617160 280205030000   LEVITTOWN 361716001522 280205030005 GARDINERS AVENUE SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 422.0 7.0 116.0   1.0     33.0     7.0   299.0 287.0             99     80   586 422 7 116   1     33     7   299 287         99   80   586
982652 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003972 280213020004 WILLOW ROAD SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 209.0 44.0 116.0         56.0     14.0   214.0 225.0     15       99     82   439 209 44 116         56     14   214 225     15   99   82   439
989764 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706108 310200011392 MANHATTAN BUSINESS ACADEMY public Regular School No High 09 12 2017   grade_10 5.0 30.0 68.0   0.0     9.0     3.0   58.0 57.0     *       99     25   115 5 30 68   0     9     3   58 57         99   25   115
989872 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701720 310200011407 INST FOR COLLABORATIVE EDUCATION public Regular School No Other 06 12 2017   pk_12_total 249.0 83.0 82.0   4.0     32.0     29.0   240.0 239.0     *       99     51   479 249 83 82   4     32     29   240 239         99   51   479
990259 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701299 310200011529 JACQUELINE KENNEDY-ONASSIS HIGH SCH public Regular School No High 09 12 2017   grade_11 3.0 29.0 87.0   4.0     7.0     0.0   47.0 83.0     6       99     30   130 3 29 87   4     7     0   47 83     6   99   30   130
990363 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705499 310200011543 NEW DESIGN HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 1.0 47.0 79.0   1.0     8.0     1.0   55.0 82.0     11       99     38   137 1 47 79   1     8     1   55 82     11   99   38   137
993051 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008105934 310500011369 URBAN ASSEMBLY FOR THE PERFORM ARTS public Regular School No High 09 12 2017   grade_10 0.0 55.0 52.0   0.0     0.0     4.0   31.0 80.0     *       99     25   111 0 55 52   0     0     4   31 80         99   25   111
993639 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302550 310600010153 PS 153 ADAM CLAYTON POWELL public Regular School No Elementary PK 05 2017   grade_1 4.0 25.0 87.0   1.0     1.0     0.0   57.0 61.0     38       99     18   118 4 25 87   1     1     0   57 61     38   99   18   118
993914 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305782 310600010322 MIDDLE SCHOOL 322 public Regular School No Middle 06 08 2017   grade_7 2.0 4.0 99.0   0.0     1.0         51.0 55.0     *       99     30   106 2 4 99   0     1         51 55         99   30   106
995547 NY Oneida   school 3606240 410601040000   CAMDEN 360624000404 410601040010 CAMDEN MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_6 163.0 0.0 4.0   0.0           0.0   94.0 73.0             99     27   167 163 0 4   0           0   94 73         99   27   167
996833 NY Onondaga   school 3630630 420101060000   WEST GENESEE 363063004119 420101060009 WEST GENESEE SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_11 351.0 15.0 5.0   3.0     7.0     2.0   186.0 197.0     *       99     42   383 351 15 5   3     7     2   186 197         99   42   383
998323 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003849 421800010003 CLARY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 16.0 86.0 9.0   3.0     0.0     6.0   62.0 58.0     *       99     27   120 16 86 9   3     0     6   62 58         99   27   120
998780 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859005977 421800010047 INSTITUTE OF TECH AT SYRACUSE CENTRA public Regular School No High 09 12 2017   grade_9 28.0 89.0 18.0   1.0     8.0     3.0   85.0 62.0     10       99     12   147 28 89 18   1     8     3   85 62     10   99   12   147
1001975 NY Oswego   school 3625650 461901040000   SANDY CREEK 362565004900 461901040003 SANDY CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 151.0 2.0 3.0         3.0     4.0   76.0 87.0             99     29   163 151 2 3         3     4   76 87         99   29   163
1002627 NY Putnam   school 3606570 480102060000   CARMEL 360657000438 480102060005 CARMEL HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 242.0 8.0 82.0   0.0     11.0     2.0   172.0 173.0     *       99     42   345 242 8 82   0     11     2   172 173         99   42   345
1002784 NY Putnam   school 3605310 480601060000   BREWSTER 360531003400 480601060002 C V STARR INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   grade_4 137.0 7.0 93.0   1.0     8.0     9.0   116.0 139.0     23       99     29   255 137 7 93   1     8     9   116 139     23   99   29   255
1003082 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802292 342400010071 PS 71 FOREST public Regular School No Elementary PK 05 2017   grade_1 45.0 2.0 69.0   0.0     5.0     1.0   63.0 59.0     26       99     16   122 45 2 69   0     5     1   63 59     26   99   16   122
1003653 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805829 342400011267 HIGH SCH OF APPLIED COMMUNICATIONS public Regular School No High 09 12 2017   grade_10 19.0 8.0 76.0   0.0     24.0     5.0   57.0 75.0     17       99     27   132 19 8 76   0     24     5   57 75     17   99   27   132
1003692 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806084 342400011296 PAN AMERICAN INTERNATIONAL HS public Regular School No High 09 12 2017   grade_11     111.0   0.0               54.0 57.0     102       99     *   111     111   0               54 57     102   99       111
1004093 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No Elementary PK 05 2017   grade_2 47.0 1.0 40.0   0.0     95.0     2.0   100.0 85.0     23       99     26   185 47 1 40   0     95     2   100 85     23   99   26   185
1004188 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202555 342500010154 PS 154 public Regular School No Elementary PK 05 2017   grade_2 12.0 11.0 24.0   2.0     69.0     1.0   57.0 62.0     42       99     18   119 12 11 24   2     69     1   57 62     42   99   18   119
1005103 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No Elementary PK 05 2017   grade_5 45.0 2.0 19.0   0.0     91.0     1.0   87.0 71.0     10       99     24   158 45 2 19   0     91     1   87 71     10   99   24   158
1006090 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305728 342700010253 PS 253 public Regular School No Elementary PK 05 2017   grade_4 2.0 43.0 58.0   1.0     1.0     0.0   61.0 44.0     *       99     29   105 2 43 58   1     1     0   61 44         99   29   105
1006755 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002222 342800010050 PS 50 TALFOURD LAWN ELEMENTARY SCH public Regular School No Elementary PK 06 2017   grade_4 1.0 30.0 35.0   8.0     28.0     1.0   51.0 52.0     11       99     24   103 1 30 35   8     28     1   51 52     11   99   24   103
1006951 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002448 342800010121 PS 121 public Regular School No Elementary PK 05 2017   kindergarten_full_day 1.0 21.0 14.0   10.0     72.0     1.0   65.0 54.0     7       99     *   119 1 21 14   10     72     1   65 54     7   99       119
1007232 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010006438 342800010287 EMERSON SCHOOL (THE) public Regular School No Middle 06 08 2017   grade_6 0.0 62.0 25.0   10.0     27.0     0.0   72.0 52.0     11       99     34   124 0 62 25   10     27     0   72 52     11   99   34   124
1007718 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102158 342900010034 PS 34 JOHN HARVARD public Regular School No Elementary PK 05 2017   grade_1 1.0 69.0 16.0   1.0     14.0     0.0   49.0 52.0     15       99     17   101 1 69 16   1     14     0   49 52     15   99   17   101
1008010 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102497 342900010136 PS 136 ROY WILKINS public Regular School No Elementary PK 05 2017   grade_5 1.0 92.0 7.0   3.0     2.0     0.0   53.0 52.0     5       99     18   105 1 92 7   3     2     0   53 52     5   99   18   105
1008537 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010101413 342900011498 HUMANITIES & ARTS MAGNET HS public Regular School No High 09 12 2017   grade_11 1.0 89.0 14.0   3.0     3.0         41.0 69.0     *       99     15   110 1 89 14   3     3         41 69         99   15   110
1011709 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302861 353100011600 RALPH R MCKEE CAREER-TECH HIGH SCH public Career and Technical School No High 09 12 2017   grade_10 32.0 49.0 63.0   0.0     5.0     0.0   122.0 27.0     5       99     51   149 32 49 63   0     5     0   122 27     5   99   51   149
1012207 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001146 500201060004 STONY POINT ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2017   grade_3 72.0 6.0 88.0   0.0     7.0     0.0   87.0 86.0     *       99     23   173 72 6 88   0     7     0   87 86         99   23   173
1014084 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000149 521301060001 BALLSTON SPA SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 304.0 9.0 5.0   0.0     3.0     2.0   177.0 146.0     *       99     54   323 304 9 5   0     3     2   177 146         99   54   323
1014509 NY Saratoga   school 3625770 521800010000   SARATOGA SPRINGS 362577000269 521800010015 MAPLE AVENUE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 420.0 7.0 11.0   0.0     15.0     21.0   227.0 247.0     *       99     41   474 420 7 11   0     15     21   227 247         99   41   474
1018315 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2017   pk_12_total 237.0 3.0 62.0         13.0     15.0   169.0 161.0             99     62   330 237 3 62         13     15   169 161         99   62   330
1018805 NY Suffolk   school 3622470 580224030000   PATCHOGUE-MEDFORD 362247003168 580224030007 SOUTH OCEAN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 70.0 5.0 72.0   0.0     6.0     5.0   77.0 81.0     16       99     *   158 70 5 72   0     6     5   77 81     16   99       158
1018947 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004675 580232030006 MORICHES ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 46.0 14.0 67.0   0.0     1.0     11.0   69.0 70.0     14       99     *   139 46 14 67   0     1     11   69 70     14   99       139
1018972 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004677 580232030008 JOHN S HOBART ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 58.0 16.0 51.0   1.0     5.0     10.0   77.0 64.0     14       99     13   141 58 16 51   1     5     10   77 64     14   99   13   141
1019075 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684005570 580233020002 CENTER MORICHES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 282.0 15.0 47.0   14.0     4.0         183.0 179.0     14       99     76   362 282 15 47   14     4         183 179     14   99   76   362
1020918 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000173 580505020004 BAYPORT-BLUE POINT HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 689.0 6.0 36.0   4.0     18.0     3.0   386.0 370.0             99     110   756 689 6 36   4     18     3   386 370         99   110   756
1024981 NY Ulster   school 3625800 621601060000   SAUGERTIES 362580003549 621601060007 SAUGERTIES SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 154.0 6.0 19.0   0.0     4.0     9.0   93.0 99.0     5       99     34   192 154 6 19   0     4     9   93 99     5   99   34   192
1025307 NY Warren   school 3616470 630701040000   LAKE GEORGE 361647001457 630701040002 LAKE GEORGE ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 321.0 5.0 4.0         11.0     4.0   172.0 173.0     *       99     39   345 321 5 4         11     4   172 173         99   39   345
1025725 NY Washington   school 3613830 641001040000   HARTFORD 361383006527 641001040002 FLOYD HARWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 184.0   6.0               8.0   111.0 87.0             99     48   198 184   6               8   111 87         99   48   198
1025793 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001255 641301060004 HUDSON FALLS INTERMEDIATE SCHOOL public Regular School No Elementary KG 05 2017   grade_4 147.0 0.0 13.0         1.0     6.0   83.0 84.0     *       99     30   167 147 0 13         1     6   83 84         99   30   167
1026024 NY Wayne   school 3620640 650101060000   NEWARK 362064002894 650101060005 NEWARK MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 126.0 10.0 20.0   0.0     1.0     11.0   91.0 77.0     *       99     19   168 126 10 20   0     1     11   91 77         99   19   168
1028423 NY Westchester   school 3608470 660804020000   MT PLEASANT-COTTAG 360847000652 660804020002 MT PLEASANT-COTTAGE SCHOOL public Special Education School No Other KG 12 2017   pk_12_total 5.0 67.0 35.0         1.0     2.0   51.0 59.0             99     78   110 5 67 35         1     2   51 59         99   78   110
1021659 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000248 580512030020 EAST MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 41.0 115.0 908.0   4.0     14.0     1.0   537.0 546.0     277       987     172   1083 41 115 908   4     14     1   537 546     277   987   172   1083
1011152 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302057 353100010051 IS 51 EDWIN MARKHAM public Regular School No Middle 06 08 2017   pk_12_total 336.0 307.0 552.0   4.0     81.0     13.0   648.0 645.0     106       986     398   1293 336 307 552   4     81     13   648 645     106   986   398   1293
993178 NY New York   school 3600108 310500860864   HARLEM CHILDREN'S ZONE PROMIS 360010805640 310500860864 HARLEM CHILDREN'S ZONE PROMISE charter Regular School Yes Other KG 12 2017   pk_12_total 8.0 940.0 163.0   13.0     4.0     10.0   528.0 610.0     39       985     190   1138 8 940 163   13     4     10   528 610     39   985   190   1138
972506 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102603 332000010170 RALPH A FABRIZIO SCHOOL public Regular School No Elementary KG 5 2017   pk_12_total 322.0 9.0 191.0   4.0     536.0     5.0   577.0 490.0     401       984     157   1067 322 9 191   4     536     5   577 490     401   984   157   1067
942454 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2017   grade_10 11.0 99.0 20.0   1.0     3.0     2.0     136.0     9       98     11   136 11 99 20   1     3     2     136     9   98   11   136

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