Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_2", state = "NY" and year = 2017 sorted by disability_int descending

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_2 · 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
942381 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_2 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
942400 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_2 1.0 76.0 6.0   0.0     0.0         45.0 38.0     *       73         83 1 76 6   0     0         45 38         73       83
989805 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_2 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
1000787 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_2 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1009223 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_2 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
1016253 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_2 0.0 0.0                     0.0 0.0             0         0 0 0                     0 0         0       0
1022713 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2017   grade_2 0.0   1.0         0.0         1.0 0.0     *                 1 0   1         0         1 0                 1
1028907 NY Westchester   school 3601051 660900861000   AMANI PUBLIC CHARTER SCHOOL 360105106291 660900861000 AMANI PUBLIC CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_2 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
1002972 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary KG 05 2017   grade_2 1.0 3.0 303.0   0.0     25.0     0.0   183.0 149.0     253       253     72   332 1 3 303   0     25     0   183 149     253   253   72   332
1011028 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302196 353100010044 PS 44 THOMAS C BROWN public Regular School No Elementary PK 05 2017   grade_2 2.0 55.0 80.0   0.0     2.0     10.0   80.0 69.0     12       144     64   149 2 55 80   0     2     10   80 69     12   144   64   149
960013 NY Erie   school 3605850 140600010000   BUFFALO 360585001549 140600010126 STANLEY MAKOWSKI EARLY CHLDHD CTR public Regular School No Elementary PK 4 2017   grade_2 11.0 131.0 21.0   1.0     12.0     5.0   96.0 85.0     22       172     63   181 11 131 21   1     12     5   96 85     22   172   63   181
1003447 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2017   grade_2 58.0 4.0 90.0   1.0     83.0     4.0   136.0 104.0     24       151     61   240 58 4 90   1     83     4   136 104     24   151   61   240
948062 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No Elementary PK 06 2017   grade_2 2.0 14.0 251.0   2.0     8.0     0.0   137.0 140.0     101       225     58   277 2 14 251   2     8     0   137 140     101   225   58   277
1011009 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302189 353100010042 PS 42 ELTINGVILLE public Regular School No Elementary PK 05 2017   grade_2 130.0 3.0 22.0   0.0     17.0     0.0   98.0 74.0     5       64     55   172 130 3 22   0     17     0   98 74     5   64   55   172
1003200 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2017   grade_2 6.0 0.0 251.0   2.0     68.0     0.0   177.0 150.0     163       181     53   327 6 0 251   2     68     0   177 150     163   181   53   327
1003371 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802521 342400010143 PS 143 LOUIS ARMSTRONG public Regular School No Elementary KG 05 2017   grade_2 0.0 9.0 228.0   0.0     9.0     0.0   120.0 126.0     183       227     53   246 0 9 228   0     9     0   120 126     183   227   53   246
1011503 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306362 353100010078 PS 78 public Regular School No Elementary PK 05 2017   grade_2 8.0 59.0 76.0   3.0     4.0     1.0   81.0 70.0     *       143     53   151 8 59 76   3     4     1   81 70         143   53   151
1002934 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2017   grade_2 3.0 14.0 236.0   0.0     15.0     0.0   142.0 126.0     90       185     52   268 3 14 236   0     15     0   142 126     90   185   52   268
944946 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502264 320800010062 PS 62 INOCENSIO CASANOVA public Regular School No Elementary PK 05 2017   grade_2 6.0 20.0 97.0   0.0     1.0     0.0   75.0 49.0     19       123     48   124 6 20 97   0     1     0   75 49     19   123   48   124
947701 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702063 321000010008 PS 8 ISSAC VARIAN public Regular School No Elementary KG 05 2017   grade_2 14.0 14.0 141.0   0.0     11.0     0.0   95.0 85.0     56       154     47   180 14 14 141   0     11     0   95 85     56   154   47   180
948100 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702357 321000010094 PS 94 KINGS COLLEGE SCHOOL public Regular School No Elementary KG 05 2017   grade_2 7.0 27.0 162.0   6.0     12.0     4.0   113.0 105.0     75       206     47   218 7 27 162   6     12     4   113 105     75   206   47   218
972344 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102385 332000010102 PS 102 BAYVIEW (THE) public Regular School No Elementary KG 5 2017   grade_2 136.0 2.0 68.0   7.0     37.0     5.0   128.0 127.0     49       154     47   255 136 2 68   7     37     5   128 127     49   154   47   255
972876 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105908 332000010503 PS 503 SCHOOL OF DISCOVERY (THE) public Regular School No Elementary PK 5 2017   grade_2 10.0 1.0 136.0   0.0     44.0     0.0   92.0 99.0     128       186     46   191 10 1 136   0     44     0   92 99     128   186   46   191
987772 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500957 307500015373 PS 373 public Special Education School No Elementary PK 08 2017   grade_2 14.0 13.0 15.0   0.0     1.0     3.0   35.0 11.0     *       33     46   46 14 13 15   0     1     3   35 11         33   46   46
1010705 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302113 353100010022 PS 22 GRANITEVILLE public Regular School No Elementary PK 05 2017   grade_2 21.0 36.0 97.0   2.0     19.0     3.0   89.0 89.0     35       152     46   178 21 36 97   2     19     3   89 89     35   152   46   178
986974 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504468 307500012186 PS 186 WALTER J DAMROSCH SCHOOL public Special Education School No Other KG 12 2017   grade_2 1.0 19.0 24.0   1.0     0.0     1.0   39.0 7.0     5       39     45   46 1 19 24   1     0     1   39 7     5   39   45   46
1002953 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No Elementary KG 05 2017   grade_2 2.0 0.0 208.0   2.0     11.0     0.0   118.0 105.0     140       155     44   223 2 0 208   2     11     0   118 105     140   155   44   223
944927 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_2 2.0 27.0 97.0   1.0     2.0     1.0   74.0 56.0     32       113     43   130 2 27 97   1     2     1   74 56     32   113   43   130
946314 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602288 320900010070 PS 70 MAX SCHOENFELD public Regular School No Elementary KG 05 2017   grade_2 4.0 55.0 147.0   0.0     0.0     0.0   106.0 100.0     71       204     43   206 4 55 147   0     0     0   106 100     71   204   43   206
949544 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_2 68.0 19.0 94.0   2.0     14.0     1.0   102.0 96.0     36       91     43   198 68 19 94   2     14     1   102 96     36   91   43   198
967841 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204811 331500010146 BROOKLYN NEW SCHOOL public Regular School No Elementary PK 5 2017   grade_2 37.0 21.0 30.0   1.0     5.0     14.0   61.0 47.0     *       35     43   108 37 21 30   1     5     14   61 47         35   43   108
1018590 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001755 580212060003 RIDGE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   grade_2 105.0 26.0 24.0   0.0     4.0     5.0   75.0 89.0     *       79     43   164 105 26 24   0     4     5   75 89         79   43   164
949639 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2017   grade_2 7.0 115.0 77.0   10.0     4.0     1.0   110.0 104.0     38       181     42   214 7 115 77   10     4     1   110 104     38   181   42   214
971223 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002406 331900010108 PS 108 SAL ABBRACCIAMENTO public Regular School No Elementary PK 5 2017   grade_2 2.0 16.0 127.0   2.0     10.0     0.0   79.0 78.0     26       111     42   157 2 16 127   2     10     0   79 78     26   111   42   157
1005765 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302395 342700010105 PS 105 BAY SCHOOL (THE) public Regular School No Elementary PK 08 2017   grade_2 2.0 70.0 33.0   1.0     2.0     0.0   56.0 52.0     5       91     42   108 2 70 33   1     2     0   56 52     5   91   42   108
944984 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502293 320800010071 PS 71 ROSE E SCALA public Regular School No Elementary PK 08 2017   grade_2 35.0 9.0 144.0   2.0     10.0     2.0   109.0 93.0     29       161     41   202 35 9 144   2     10     2   109 93     29   161   41   202
946713 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606391 320900010274 NEW AMERICAN ACAD-R CLEMENTE STATE public Regular School No Elementary PK 05 2017   grade_2 2.0 42.0 85.0   1.0     0.0     0.0   72.0 58.0     41       120     41   130 2 42 85   1     0     0   72 58     41   120   41   130
951197 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005807 321200010300 SCHOOL OF SCIENCE & APPLIED LRNG public Regular School No Elementary PK 05 2017   grade_2 3.0 36.0 67.0   0.0     0.0         47.0 59.0     20       94     41   106 3 36 67   0     0         47 59     20   94   41   106
974206 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302727 332200010222 PS 222 KATHERINE R SNYDER public Regular School No Elementary PK 5 2017   grade_2 74.0 16.0 29.0   0.0     37.0     4.0   77.0 83.0     13       79     41   160 74 16 29   0     37     4   77 83     13   79   41   160
948176 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702691 321000010205 PS 205 FIORELLO LAGUARDIA public Regular School No Elementary KG 05 2017   grade_2 11.0 23.0 150.0   0.0     6.0     1.0   88.0 103.0     56       156     40   191 11 23 150   0     6     1   88 103     56   156   40   191
991990 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902418 310400010112 PS 112 JOSE CELSO BARBOSA public Regular School No Elementary PK 02 2017   grade_2 2.0 23.0 67.0   2.0     3.0     1.0   64.0 34.0     33       72     40   98 2 23 67   2     3     1   64 34     33   72   40   98
1011313 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302257 353100010060 PS 60 ALICE AUSTEN public Regular School No Elementary PK 05 2017   grade_2 84.0 6.0 25.0   0.0     19.0     3.0   71.0 66.0     8       83     40   137 84 6 25   0     19     3   71 66     8   83   40   137
946181 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602133 320900010028 PS 28 MOUNT HOPE public Regular School No Elementary PK 05 2017   grade_2 2.0 20.0 112.0         1.0     0.0   79.0 56.0     48       128     39   135 2 20 112         1     0   79 56     48   128   39   135
947891 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702204 321000010046 PS 46 EDGAR ALLEN POE public Regular School No Elementary KG 05 2017   grade_2 3.0 12.0 141.0   0.0     3.0     1.0   79.0 81.0     73       136     39   160 3 12 141   0     3     1   79 81     73   136   39   160
949658 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802394 321100010105 PS 105 SEN ABRAHAM BERNSTEIN public Regular School No Elementary KG 05 2017   grade_2 21.0 24.0 128.0   2.0     15.0     3.0   83.0 110.0     59       177     39   193 21 24 128   2     15     3   83 110     59   177   39   193
959481 NY Erie   school 3605850 140600010000   BUFFALO 360585000350 140600010059 PS 59 DR CHARLES DREW SCI MAGNET public Regular School No Elementary PK 8 2017   grade_2 8.0 54.0 16.0   0.0     9.0     7.0   53.0 41.0     18       87     39   94 8 54 16   0     9     7   53 41     18   87   39   94
1000293 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 111.0 16.0 59.0   0.0     11.0     4.0   100.0 101.0     9       *     39   201 111 16 59   0     11     4   100 101     9       39   201
1005594 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302268 342700010063 PS 63 OLD SOUTH public Regular School No Elementary PK 05 2017   grade_2 19.0 18.0 101.0   7.0     69.0     1.0   103.0 112.0     47       190     39   215 19 18 101   7     69     1   103 112     47   190   39   215
1020072 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001450 580406060001 WASHINGTON DRIVE PRIM SCH public Regular School No Elementary KG 02 2017   grade_2 136.0 10.0 38.0         8.0     9.0   111.0 90.0     13       40     39   201 136 10 38         8     9   111 90     13   40   39   201
993453 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302135 310600010028 PS 28 WRIGHT BROTHERS public Regular School No Elementary PK 05 2017   grade_2 7.0 18.0 91.0   1.0     0.0     1.0   65.0 53.0     *       93     38   118 7 18 91   1     0     1   65 53         93   38   118
1002915 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No Elementary KG 05 2017   grade_2 7.0 22.0 177.0   1.0     78.0     2.0   149.0 138.0     127       157     38   287 7 22 177   1     78     2   149 138     127   157   38   287
1021440 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 1.0 15.0 138.0         3.0         95.0 62.0     79       148     38   157 1 15 138         3         95 62     79   148   38   157
945003 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502295 320800010072 PS 72 DR WILLIAM DORNEY public Regular School No Elementary PK 05 2017   grade_2 2.0 20.0 91.0   0.0     2.0         54.0 61.0     *       90     37   115 2 20 91   0     2         54 61         90   37   115
947815 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702150 321000010032 PS 32 BELMONT public Regular School No Elementary PK 05 2017   grade_2 3.0 32.0 107.0   0.0     2.0     0.0   64.0 80.0     26       143     37   144 3 32 107   0     2     0   64 80     26   143   37   144
967518 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202072 331500010010 MAGNET SCH OF MATH, SCI, DESIGN public Regular School No Elementary PK 5 2017   grade_2 81.0 13.0 52.0   0.0     6.0     12.0   87.0 77.0     11       35     37   164 81 13 52   0     6     12   87 77     11   35   37   164
973370 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202708 332100010212 PS 212 LADY DEBORAH MOODY public Regular School No Elementary PK 5 2017   grade_2 15.0 13.0 48.0   0.0     38.0     1.0   62.0 53.0     26       102     37   115 15 13 48   0     38     1   62 53     26   102   37   115
990793 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802303 310300010075 PS 75 EMILY DICKINSON public Regular School No Elementary KG 05 2017   grade_2 23.0 24.0 61.0   0.0     3.0     2.0   62.0 51.0     19       76     37   113 23 24 61   0     3     2   62 51     19   76   37   113
999020 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No Elementary PK 05 2017   grade_2 205.0 2.0 13.0   0.0     4.0     12.0   124.0 112.0     6       103     37   236 205 2 13   0     4     12   124 112     6   103   37   236
1002991 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805244 342400010028 PS 28 THOMAS EMANUEL EARLY CHILD CTR public Regular School No Elementary PK 02 2017   grade_2 0.0   141.0   1.0     15.0     1.0   73.0 85.0     96       114     37   158 0   141   1     15     1   73 85     96   114   37   158
1003390 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802551 342400010153 PS 153 MASPETH ELEMENTARY public Regular School No Elementary PK 06 2017   grade_2 84.0 3.0 73.0   1.0     18.0     1.0   91.0 89.0     14       124     37   180 84 3 73   1     18     1   91 89     14   124   37   180
1010876 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302149 353100010032 PS 32 GIFFORD SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_2 71.0 2.0 13.0   1.0     7.0     2.0   45.0 51.0     5       37     37   96 71 2 13   1     7     2   45 51     5   37   37   96
1011427 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302286 353100010069 PS 69 DANIEL D TOMPKINS public Regular School No Elementary PK 05 2017   grade_2 71.0 1.0 32.0   1.0     17.0     1.0   75.0 48.0     15       70     37   123 71 1 32   1     17     1   75 48     15   70   37   123
1017773 NY Suffolk   school 3625350 580205060000   SACHEM 362535003503 580205060004 LYNWOOD AVENUE SCHOOL public Regular School No Elementary KG 05 2017   grade_2 80.0 2.0 31.0   0.0     9.0     2.0   68.0 56.0     18       52     37   124 80 2 31   0     9     2   68 56     18   52   37   124
945098 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502401 320800010107 PS 107 public Regular School No Elementary PK 05 2017   grade_2 4.0 30.0 62.0   0.0     0.0     0.0   48.0 48.0     10       96     36   96 4 30 62   0     0     0   48 48     10   96   36   96
951026 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003353 321200010195 PS 195 public Regular School No Elementary PK 05 2017   grade_2 2.0 21.0 127.0   5.0     6.0     0.0   81.0 80.0     57       139     36   161 2 21 127   5     6     0   81 80     57   139   36   161
967499 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202041 331500010001 PS 1 BERGEN (THE) public Regular School No Elementary PK 5 2017   grade_2 6.0 0.0 182.0   0.0     18.0     0.0   97.0 109.0     111       139     36   206 6 0 182   0     18     0   97 109     111   139   36   206
987487 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502070 307500014009 PS 9 public Special Education School No Other KG 10 2017   grade_2 1.0 18.0 16.0   0.0     1.0     0.0   32.0 4.0     7       20     36   36 1 18 16   0     1     0   32 4     7   20   36   36
1003523 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806060 342400010307 PIONEER ACADEMY public Regular School No Elementary PK 05 2017   grade_2 4.0 0.0 142.0   2.0     1.0     0.0   84.0 65.0     76       *     36   149 4 0 142   2     1     0   84 65     76       36   149
1005727 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302379 342700010100 PS 100 GLEN MORRIS public Regular School No Elementary PK 05 2017   grade_2 8.0 11.0 30.0   35.0     54.0     2.0   71.0 69.0     15       72     36   140 8 11 30   35     54     2   71 69     15   72   36   140
1005803 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302405 342700010108 PS 108 CAPT VINCENT G FOWLER public Regular School No Elementary PK 05 2017   grade_2 12.0 7.0 125.0         103.0     0.0   135.0 112.0     25       208     36   247 12 7 125         103     0   135 112     25   208   36   247
1010591 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302082 353100010013 PS 13 M L LINDEMEYER public Regular School No Elementary PK 05 2017   grade_2 20.0 22.0 62.0   0.0     31.0     4.0   58.0 81.0     34       72     36   139 20 22 62   0     31     4   58 81     34   72   36   139
1012757 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003771 500402060002 GRANDVIEW ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2017   grade_2 8.0 42.0 103.0         4.0     1.0   99.0 59.0     75       145     36   158 8 42 103         4     1   99 59     75   145   36   158
1017792 NY Suffolk   school 3625350 580205060000   SACHEM 362535003505 580205060005 NOKOMIS SCHOOL public Regular School No Elementary KG 05 2017   grade_2 87.0 2.0 17.0   3.0     1.0     6.0   73.0 43.0             39     36   116 87 2 17   3     1     6   73 43         39   36   116
1025373 NY Warren   school 3624030 630902030000   QUEENSBURY 362403003316 630902030001 QUEENSBURY ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2017   grade_2 234.0 1.0 3.0         3.0     6.0   125.0 122.0     *       101     36   247 234 1 3         3     6   125 122         101   36   247
1029534 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2017   grade_2 18.0 48.0 187.0   0.0     4.0     12.0   150.0 119.0     95       232     36   269 18 48 187   0     4     12   150 119     95   232   36   269
946561 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604459 320900010199 PS 199 SHAKESPEARE SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_2 3.0 41.0 92.0   1.0     2.0         73.0 66.0     47       139     35   139 3 41 92   1     2         73 66     47   139   35   139
946618 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603742 320900010218 PS/IS 218 R H DUAL LANG MAGNET public Regular School No Elementary KG 08 2017   grade_2 1.0 3.0 119.0   2.0     3.0     1.0   70.0 59.0     54       105     35   129 1 3 119   2     3     1   70 59     54   105   35   129
947758 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702179 321000010020 PS/MS 20 PO GEORGE J WERDAN III public Regular School No Elementary PK 08 2017   grade_2 10.0 13.0 88.0   4.0     7.0     0.0   71.0 51.0     33       117     35   122 10 13 88   4     7     0   71 51     33   117   35   122
950988 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002541 321200010150 PS 150 CHARLES JAMES FOX public Regular School No Elementary PK 05 2017   grade_2 3.0 22.0 119.0   0.0     0.0     1.0   75.0 70.0     38       136     35   145 3 22 119   0     0     1   75 70     38   136   35   145
951045 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003369 321200010196 PS 196 public Regular School No Elementary PK 05 2017   grade_2 2.0 31.0 129.0   7.0     2.0         94.0 77.0     77       133     35   171 2 31 129   7     2         94 77     77   133   35   171
967784 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202481 331500010130 PS 130 PARKSIDE (THE) public Regular School No Elementary PK 5 2017   grade_2 58.0 4.0 31.0   2.0     23.0     5.0   65.0 58.0     30       48     35   123 58 4 31   2     23     5   65 58     30   48   35   123
972515 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102618 332000010176 PS 176 OVINGTON public Regular School No Elementary KG 5 2017   grade_2 23.0 2.0 31.0         157.0     3.0   103.0 113.0     76       205     35   216 23 2 31         157     3   103 113     76   205   35   216
972591 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   grade_2 52.0 1.0 65.0   2.0     72.0     1.0   108.0 85.0     82       112     35   193 52 1 65   2     72     1   108 85     82   112   35   193
973218 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202382 332100010101 PS 101 VERRAZANO (THE) public Regular School No Elementary PK 5 2017   grade_2 33.0 2.0 37.0   1.0     78.0     1.0   89.0 63.0     43       86     35   152 33 2 37   1     78     1   89 63     43   86   35   152
979393 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003414 261600010043 SCHOOL 43-THEODORE ROOSEVELT public Regular School No Elementary PK 06 2017   grade_2 13.0 56.0 17.0   0.0     5.0         51.0 40.0     8       87     35   91 13 56 17   0     5         51 40     8   87   35   91
999533 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No Elementary KG 04 2017   grade_2 272.0 6.0 23.0   1.0     9.0     10.0   158.0 163.0     *       71     35   321 272 6 23   1     9     10   158 163         71   35   321
1002896 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2017   grade_2 1.0 1.0 82.0   0.0     128.0         119.0 93.0     77       186     35   212 1 1 82   0     128         119 93     77   186   35   212
1010439 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302052 353100010004 PS 4 MAURICE WOLLIN public Regular School No Elementary PK 05 2017   grade_2 83.0 3.0 18.0   1.0     13.0     1.0   63.0 56.0     10       50     35   119 83 3 18   1     13     1   63 56     10   50   35   119
1010933 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302165 353100010036 PS 36 J C DRUMGOOLE public Regular School No Elementary PK 05 2017   grade_2 99.0 1.0 17.0   0.0     6.0     4.0   66.0 61.0     5       43     35   127 99 1 17   0     6     4   66 61     5   43   35   127
948043 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705139 321000010085 PS 85 GREAT EXPECTATIONS public Regular School No Elementary PK 05 2017   grade_2 1.0 40.0 104.0   1.0     1.0     0.0   71.0 76.0     52       142     34   147 1 40 104   1     1     0   71 76     52   142   34   147
948119 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702361 321000010095 PS 95 SHEILA MENCHER public Regular School No Elementary PK 08 2017   grade_2 7.0 27.0 109.0   2.0     6.0     1.0   84.0 68.0     32       113     34   152 7 27 109   2     6     1   84 68     32   113   34   152
967974 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202818 331500010321 PS 321 WILLIAM PENN public Regular School No Elementary PK 5 2017   grade_2 198.0 5.0 20.0   1.0     11.0     16.0   126.0 125.0     6       17     34   251 198 5 20   1     11     16   126 125     6   17   34   251
970387 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602429 331800010115 PS 115 DANIEL MUCATEL SCHOOL public Regular School No Elementary PK 5 2017   grade_2 4.0 118.0 14.0   1.0     9.0     1.0   70.0 77.0     7       68     34   147 4 118 14   1     9     1   70 77     7   68   34   147
971337 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002684 331900010202 PS 202 ERNEST S JENKYNS public Regular School No Elementary PK 5 2017   grade_2 3.0 58.0 31.0   0.0     2.0     1.0   55.0 40.0     11       88     34   95 3 58 31   0     2     1   55 40     11   88   34   95
972439 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102575 332000010160 PS 160 WILLIAM T SAMPSON public Regular School No Elementary PK 5 2017   grade_2 15.0 0.0 18.0   0.0     243.0     0.0   152.0 124.0     229       147     34   276 15 0 18   0     243     0   152 124     229   147   34   276
972800 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102761 332000010247 PS 247 public Regular School No Elementary PK 5 2017   grade_2 48.0 0.0 20.0   0.0     89.0         82.0 75.0     49       85     34   157 48 0 20   0     89         82 75     49   85   34   157
974187 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No Elementary PK 5 2017   grade_2 42.0 18.0 46.0         88.0     5.0   102.0 97.0     75       130     34   199 42 18 46         88     5   102 97     75   130   34   199
977170 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000274 260101060001 COUNCIL ROCK PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 172.0 10.0 15.0         29.0     25.0   134.0 117.0     14       26     34   251 172 10 15         29     25   134 117     14   26   34   251
987031 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_2 2.0 9.0 19.0         4.0     0.0   25.0 9.0     *       26     34   34 2 9 19         4     0   25 9         26   34   34
1002877 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No Elementary PK 03 2017   grade_2 2.0 0.0 85.0   0.0     160.0     0.0   130.0 117.0     153       212     34   247 2 0 85   0     160     0   130 117     153   212   34   247

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