Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by asian_pacific_islander descending

View and edit SQL

year

grade

  • grade_2 · 33,145
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
1064171 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No 1.0 PK 5 2016   grade_2 29.0 20.0 37.0   0.0     99.0     6.0   99.0 92.0             134     23   191 29 20 37   0     99     6   99 92         134   23   191
1078497 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702047 310200010002 PS 2 MEYER LONDON public Regular School No 1.0 PK 05 2016   grade_2 0.0 0.0 8.0   0.0     99.0         58.0 49.0             104     *   107 0 0 8   0     99         58 49         104       107
2204951 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102483 342900010131 PS 131 ABIGAIL ADAMS public Regular School No Elementary KG 05 2019   grade_2 13.0 6.0 12.0   1.0     99.0     1.0   65.0 67.0     20       123     16   132 13 6 12   1     99     1   65 67     20   123   16   132
809423 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302379 342700010100 PS 100 GLEN MORRIS public Regular School No 1 KG 05 2015   grade_2 4.0 16.0 30.0   13.0     98.0     0.0   83.0 78.0             91     33   161 4 16 30   13     98     0   83 78         91   33   161
1555416 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No Elementary PK 05 2020   grade_2 27.0 8.0 27.0   2.0     98.0     3.0   93.0 72.0     42       127     19   165 27 8 27   2     98     3   93 72     42   127   19   165
2111357 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2018   grade_2 3.0 2.0 43.0   0.0     98.0     1.0   74.0 73.0     92       136     11   147 3 2 43   0     98     1   74 73     92   136   11   147
972686 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102689 332000010204 PS 204 VINCE LOMBARDI public Regular School No Elementary PK 5 2017   grade_2 53.0 1.0 35.0   1.0     97.0     1.0   103.0 85.0     40       145     32   188 53 1 35   1     97     1   103 85     40   145   32   188
1062670 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102689 332000010204 PS 204 VINCE LOMBARDI public Regular School No 1.0 PK 5 2016   grade_2 59.0 0.0 37.0   1.0     97.0     0.0   92.0 102.0             157     29   194 59 0 37   1     97     0   92 102         157   29   194
1570084 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No Elementary PK 05 2020   grade_2 3.0 0.0 2.0         97.0     3.0   54.0 51.0     45       55     17   105 3 0 2         97     3   54 51     45   55   17   105
2112554 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902687 342600010203 PS 203 OAKLAND GARDENS public Regular School No Elementary PK 05 2018   grade_2 18.0 2.0 19.0         97.0     5.0   67.0 74.0     26       62     17   141 18 2 19         97     5   67 74     26   62   17   141
2115347 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102483 342900010131 PS 131 ABIGAIL ADAMS public Regular School No Elementary KG 05 2018   grade_2 8.0 9.0 14.0   5.0     97.0     1.0   75.0 59.0     22       125     27   134 8 9 14   5     97     1   75 59     22   125   27   134
2204875 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No Elementary KG 05 2019   grade_2 2.0 20.0 107.0   8.0     97.0     1.0   118.0 117.0     66       170     25   235 2 20 107   8     97     1   118 117     66   170   25   235
777655 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No 1 PK 5 2015   grade_2 41.0 23.0 41.0   0.0     96.0     4.0   107.0 98.0             137     27   205 41 23 41   0     96     4   107 98         137   27   205
808796 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOW public Regular School No 1 PK 05 2015   grade_2 45.0 2.0 19.0   0.0     96.0     2.0   83.0 81.0             111     21   164 45 2 19   0     96     2   83 81         111   21   164
1062518 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102625 332000010179 PS 179 KENSINGTON public Regular School No 1.0 PK 5 2016   grade_2 22.0 3.0 37.0   2.0     96.0     0.0   83.0 77.0             129     33   160 22 3 37   2     96     0   83 77         129   33   160
1493913 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2021   grade_2 8.0 0.0 69.0   0.0     96.0     3.0   99.0 77.0     74       157     27   176 8 0 69   0     96     3   99 77     74   157   27   176
808131 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202711 342500010214 PS 214 CADWALLADER COLDEN public Regular School No 1 PK 05 2015   grade_2 8.0 4.0 27.0         95.0     2.0   81.0 55.0             98     15   136 8 4 27         95     2   81 55         98   15   136
811475 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No 1 KG 05 2015   grade_2 3.0 26.0 122.0   15.0     95.0     1.0   128.0 134.0             182     37   262 3 26 122   15     95     1   128 134         182   37   262
1003257 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802386 342400010102 PS 102 BAYVIEW public Regular School No Elementary PK 08 2017   grade_2 12.0 4.0 37.0   2.0     95.0     1.0   77.0 74.0     30       124     25   151 12 4 37   2     95     1   77 74     30   124   25   151
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
1495281 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202586 342500010163 PS 163 FLUSHING HEIGHTS public Regular School No Elementary PK 05 2021   grade_2 1.0 2.0 21.0   1.0     95.0     2.0   66.0 56.0     66       104     *   122 1 2 21   1     95     2   66 56     66   104       122
1566284 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 15.0 2.0 8.0   0.0     95.0     5.0   68.0 57.0     13       20     8   125 15 2 8   0     95     5   68 57     13   20   8   125
2200904 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2019   grade_2 4.0 0.0 50.0   2.0     95.0     2.0   84.0 69.0     94       140     22   153 4 0 50   2     95     2   84 69     94   140   22   153
1078820 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No 1.0 PK 05 2016   grade_2 0.0 0.0 5.0         94.0     0.0   52.0 47.0             53     16   99 0 0 5         94     0   52 47         53   16   99
2079741 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102603 332000010170 RALPH A FABRIZIO SCHOOL public Regular School No Elementary KG 05 2018   grade_2 41.0 0.0 18.0   0.0     94.0     0.0   80.0 73.0     55       *     *   153 41 0 18   0     94     0   80 73     55           153
2185856 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702480 310200010130 PS 130 HERNANDO DE SOTO public Regular School No Elementary PK 05 2019   grade_2 6.0 0.0 9.0   0.0     94.0     6.0   60.0 55.0     30       57     *   115 6 0 9   0     94     6   60 55     30   57       115
1007855 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No Elementary KG 05 2017   grade_2 1.0 30.0 100.0   11.0     93.0     1.0   115.0 121.0     66       126     24   236 1 30 100   11     93     1   115 121     66   126   24   236
1094875 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902099 342600010018 PS 18 WINCHESTER public Regular School No 1.0 PK 05 2016   grade_2 11.0 13.0 9.0   0.0     93.0     1.0   62.0 65.0             67     19   127 11 13 9   0     93     1   62 65         67   19   127
771290 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202740 331500010230 PS 230 DORIS L COHEN public Regular School No 1 PK 5 2015   grade_2 40.0 5.0 68.0         92.0     1.0   110.0 96.0             135     42   206 40 5 68         92     1   110 96         135   42   206
776325 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015106199 332000010310 SCHOOL FOR FUTURE LEADERS (THE) public Regular School No 1 KG 5 2015   grade_2 6.0 1.0 5.0         92.0         51.0 53.0             101     14   104 6 1 5         92         51 53         101   14   104
1093317 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802386 342400010102 PS 102 BAYVIEW public Regular School No 1.0 PK 08 2016   grade_2 4.0 12.0 49.0   0.0     92.0     0.0   81.0 76.0             136     32   157 4 12 49   0     92     0   81 76         136   32   157
1094267 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202586 342500010163 PS 163 FLUSHING HEIGHTS public Regular School No 1.0 PK 05 2016   grade_2 1.0 1.0 19.0         92.0     1.0   60.0 54.0             94     23   114 1 1 19         92     1   60 54         94   23   114
1555378 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary KG 08 2020   grade_2 67.0 0.0 11.0   1.0     92.0     5.0   81.0 95.0     63       113     26   176 67 0 11   1     92     5   81 95     63   113   26   176
1586329 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No Elementary PK 05 2020   grade_2 29.0 0.0 17.0   1.0     92.0     2.0   79.0 62.0     12       89     26   141 29 0 17   1     92     2   79 62     12   89   26   141
2092338 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 24.0 2.0 12.0         92.0     4.0   72.0 62.0     12       24     12   134 24 2 12         92     4   72 62     12   24   12   134
2111452 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No Elementary PK 05 2018   grade_2 44.0 1.0 33.0   0.0     92.0     1.0   95.0 76.0     16       95     26   171 44 1 33   0     92     1   95 76     16   95   26   171
2199802 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2019   grade_2 10.0 0.0 86.0   0.0     92.0     1.0   102.0 87.0     53       166     36   189 10 0 86   0     92     1   102 87     53   166   36   189
1004511 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012206032 342500010244 ACTIVE LEARNING ELEMENTARY SCH (THE) public Regular School No Elementary PK 03 2017   grade_2 3.0 3.0 7.0   0.0     91.0     1.0   55.0 50.0     71       85     10   105 3 3 7   0     91     1   55 50     71   85   10   105
1006943 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002448 342800010121 PS 121 public Regular School No Elementary PK 05 2017   grade_2 3.0 32.0 21.0   27.0     91.0     0.0   87.0 87.0     9       141     23   174 3 32 21   27     91     0   87 87     9   141   23   174
1078630 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702187 310200010042 PS 42 BENJAMIN ALTMAN public Regular School No 1.0 PK 05 2016   grade_2 2.0 0.0 2.0         91.0     0.0   55.0 40.0             57     17   95 2 0 2         91     0   55 40         57   17   95
1094058 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No 1.0 PK 05 2016   grade_2 3.0 0.0 40.0   0.0     91.0     2.0   67.0 69.0             115     16   136 3 0 40   0     91     2   67 69         115   16   136
1095160 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No 1.0 PK 05 2016   grade_2 38.0 2.0 18.0   1.0     91.0     4.0   88.0 66.0             82     22   154 38 2 18   1     91     4   88 66         82   22   154
2182018 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 23.0 2.0 20.0   0.0     91.0     8.0   80.0 64.0     13       32     17   144 23 2 20   0     91     8   80 64     13   32   17   144
808758 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902580 342600010162 PS 162 JOHN GOLDEN public Regular School No 1 KG 05 2015   grade_2 19.0 2.0 16.0   0.0     90.0     1.0   67.0 61.0             79     23   128 19 2 16   0     90     1   67 61         79   23   128
1094571 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012206032 342500010244 ACTIVE LEARNING ELEMENTARY SCH (THE) public Regular School No 1.0 PK 03 2016   grade_2 1.0 2.0 6.0   0.0     90.0     2.0   52.0 49.0             81     12   101 1 2 6   0     90     2   52 49         81   12   101
1495585 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012206032 342500010244 ACTIVE LEARNING ELEMENTARY SCH (THE) public Regular School No Elementary PK 03 2021   grade_2 1.0 1.0 3.0   0.0     90.0     4.0   52.0 47.0     62       79     11   99 1 1 3   0     90     4   52 47     62   79   11   99
1496079 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902428 342600010115 JAMES J AMBROSE SCHOOL (THE) public Regular School No Elementary PK 05 2021   grade_2 7.0 6.0 14.0   2.0     90.0     5.0   71.0 53.0     10       54     15   124 7 6 14   2     90     5   71 53     10   54   15   124
1584638 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2020   grade_2 40.0 6.0 86.0   0.0     90.0     0.0   124.0 98.0     20       153     47   222 40 6 86   0     90     0   124 98     20   153   47   222
1586215 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902428 342600010115 JAMES J AMBROSE SCHOOL (THE) public Regular School No Elementary PK 05 2020   grade_2 6.0 6.0 21.0   1.0     90.0     5.0   67.0 62.0     7       45     19   129 6 6 21   1     90     5   67 62     7   45   19   129
2110236 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2018   grade_2 7.0 0.0 95.0   2.0     90.0     0.0   100.0 94.0     77       177     28   194 7 0 95   2     90     0   100 94     77   177   28   194
2112459 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No Elementary PK 05 2018   grade_2 39.0 3.0 19.0   0.0     90.0     4.0   77.0 78.0     20       89     33   155 39 3 19   0     90     4   77 78     20   89   33   155
2201930 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902428 342600010115 JAMES J AMBROSE SCHOOL (THE) public Regular School No Elementary PK 05 2019   grade_2 8.0 6.0 14.0   4.0     90.0     4.0   66.0 60.0     8       57     *   126 8 6 14   4     90     4   66 60     8   57       126
745260 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_2 44.0 14.0 14.0   2.0     9.0     10.0   60.0 33.0             24     17   93 44 14 14   2     9     10   60 33         24   17   93
745298 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No 1.0 PK 06 2015   grade_2 10.0 33.0 10.0   0.0     9.0     4.0   26.0 40.0             28     *   66 10 33 10   0     9     4   26 40         28       66
745754 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 67.0 0.0 1.0         9.0     0.0   40.0 37.0             6     8   77 67 0 1         9     0   40 37         6   8   77
749687 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602276 320900010114 PS 114 LUIS LORENS TORRES SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 1.0 33.0 95.0   1.0     9.0     0.0   74.0 65.0             138     24   139 1 33 95   1     9     0   74 65         138   24   139
751416 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702361 321000010095 PS 95 SHEILA MENCHER public Regular School No 1.0 PK 08 2015   grade_2 4.0 30.0 108.0   0.0     9.0     4.0   68.0 87.0             114     26   155 4 30 108   0     9     4   68 87         114   26   155
755862 NY Broome   school 3629610 31601060000   VESTAL 362961003984 31601060021 AFRICAN ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 29.0 2.0 3.0         9.0     2.0   26.0 19.0             12     10   45 29 2 3         9     2   26 19         12   10   45
762968 NY Erie   school 3605850 140600010000   BUFFALO 360585004506 140600010093 SOUTHSIDE ELEMENTARY SCHOOL public Regular School No 1 PK 8 2015   grade_2 70.0 26.0 21.0   1.0     9.0     9.0   88.0 48.0             124     34   136 70 26 21   1     9     9   88 48         124   34   136
771233 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202557 331500010154 WINDSOR TERRACE SCHOOL (THE) public Regular School No 1 KG 5 2015   grade_2 65.0 2.0 12.0   1.0     9.0     1.0   48.0 42.0             16     17   90 65 2 12   1     9     1   48 42         16   17   90
774577 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012004351 331900010007 PS 7 ABRAHAM LINCOLN public Regular School No 1 PK 5 2015   grade_2 4.0 18.0 117.0   4.0     9.0     0.0   74.0 78.0             139     23   152 4 18 117   4     9     0   74 78         139   23   152
777560 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302669 332200010197 PS 197 KINGS HIGHWAY ACADEMY (THE) public Regular School No 1 PK 5 2015   grade_2 46.0 18.0 10.0   3.0     9.0     0.0   41.0 45.0             51     20   86 46 18 10   3     9     0   41 45         51   20   86
783640 NY Monroe   school 3625170 261701060000   RUSH HENRIETTA 362517003486 261701060004 MONICA B LEARY ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 74.0 14.0 6.0         9.0     9.0   50.0 62.0             26     7   112 74 14 6         9     9   50 62         26   7   112
785236 NY Nassau   school 3617160 280205030000   LEVITTOWN 361716001531 280205030009 SUMMIT LANE SCHOOL public Regular School No 1 KG 05 2015   grade_2 37.0 0.0 23.0         9.0     1.0   34.0 36.0             25     14   70 37 0 23         9     1   34 36         25   14   70
786509 NY Nassau   school 3610620 280216020000   ELMONT 361062000836 280216020007 STEWART MANOR SCHOOL public Regular School No 1 PK 06 2015   grade_2 16.0 9.0 8.0         9.0     2.0   23.0 21.0             17     7   44 16 9 8         9     2   23 21         17   7   44
786661 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000946 280218030005 STEWART SCHOOL public Regular School No 1 02 05 2015   grade_2 138.0 1.0 5.0         9.0     2.0   84.0 71.0             0     23   155 138 1 5         9     2   84 71         0   23   155
788257 NY Nassau   school 3623580 280404030000   PORT WASHINGTON 362358003290 280404030002 GUGGENHEIM ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 55.0 0.0 30.0         9.0     5.0   56.0 43.0             23     14   99 55 0 30         9     5   56 43         23   14   99
789359 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003254 280504060004 PARKWAY SCHOOL public Regular School No 1 01 04 2015   grade_2 75.0 0.0 5.0         9.0     0.0   37.0 52.0             *     8   89 75 0 5         9     0   37 52             8   89
791392 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007602101 310100010019 PS 19 ASHER LEVY public Regular School No 1 PK 05 2015   grade_2 3.0 6.0 21.0   0.0     9.0     0.0   21.0 18.0             29     11   39 3 6 21   0     9     0   21 18         29   11   39
792247 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702253 310200010059 PS 59 BEEKMAN HILL INTERNATIONAL public Regular School No 1 KG 05 2015   grade_2 77.0 2.0 13.0   1.0     9.0     8.0   54.0 56.0             11     15   110 77 2 13   1     9     8   54 56         11   15   110
792323 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702414 310200010111 PS 111 ADOLPH S OCHS public Regular School No 1 PK 08 2015   grade_2 5.0 6.0 22.0   1.0     9.0     0.0   27.0 16.0             *     14   43 5 6 22   1     9     0   27 16             14   43
792817 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706334 310200010343 PECK SLIP SCHOOL (THE) public Regular School No 1 KG 02 2015   grade_2 25.0 4.0 4.0         9.0     6.0   30.0 18.0             6     10   48 25 4 4         9     6   30 18         6   10   48
792855 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706130 310200010397 SPRUCE STREET SCHOOL public Regular School No 1 PK 05 2015   grade_2 28.0 1.0 6.0   2.0     9.0     7.0   31.0 22.0             6     11   53 28 1 6   2     9     7   31 22         6   11   53
794432 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802068 310300010009 PS 9 SARAH ANDERSON public Regular School No 1 PK 05 2015   grade_2 61.0 7.0 25.0   0.0     9.0     2.0   42.0 62.0             25     18   104 61 7 25   0     9     2   42 62         25   18   104
800018 NY Oneida   school 3629370 412300010000   UTICA 362937003950 412300010009 HUGH R JONES ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   grade_2 23.0 7.0 13.0         9.0     5.0   32.0 25.0             45     7   57 23 7 13         9     5   32 25         45   7   57
806649 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No 1 KG 05 2015   grade_2 0.0 1.0 230.0   1.0     9.0         134.0 107.0             *     46   241 0 1 230   1     9         134 107             46   241
806763 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802284 342400010068 PS 68 CAMBRIDGE public Regular School No 1 PK 05 2015   grade_2 11.0 5.0 106.0   0.0     9.0     1.0   78.0 54.0             88     31   132 11 5 106   0     9     1   78 54         88   31   132
808093 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202683 342500010201 PS 201 DISCOVERY SCHOOL (THE) public Regular School No 1 PK 05 2015   grade_2 3.0 40.0 22.0   2.0     9.0         40.0 36.0             55     21   76 3 40 22   2     9         40 36         55   21   76
808663 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902372 342600010098 PS 98 DOUGLASTON SCHOOL (THE) public Regular School No 1 KG 05 2015   grade_2 17.0 1.0 9.0   1.0     9.0     1.0   16.0 22.0             13     *   38 17 1 9   1     9     1   16 22         13       38
808815 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902622 342600010178 PS/IS 178 HOLLISWOOD public Regular School No 1 PK 08 2015   grade_2 40.0 3.0 3.0   1.0     9.0     1.0   31.0 26.0             28     *   57 40 3 3   1     9     1   31 26         28       57
809537 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302454 342700010123 PS 123 public Regular School No 1 PK 05 2015   grade_2 1.0 61.0 25.0   13.0     9.0         58.0 51.0             103     23   109 1 61 25   13     9         58 51         103   23   109
814287 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302102 353100010019 PS 19 CURTIS SCHOOL (THE) public Regular School No 1 PK 05 2015   grade_2 9.0 11.0 77.0   1.0     9.0     3.0   62.0 48.0             80     22   110 9 11 77   1     9     3   62 48         80   22   110
818467 NY Schenectady   school 3620880 530301060000   NISKAYUNA 362088000276 530301060001 BIRCHWOOD ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 26.0 2.0 3.0         9.0     3.0   19.0 24.0             *     5   43 26 2 3         9     3   19 24             5   43
818752 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003575 530600010003 ELMER AVENUE SCHOOL public Regular School No 1 01 06 2015   grade_2 17.0 19.0 13.0         9.0     5.0   28.0 35.0             52     *   63 17 19 13         9     5   28 35         52       63
823806 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001450 580406060001 WASHINGTON DRIVE PRIM SCH public Regular School No 1 KG 02 2015   grade_2 180.0 5.0 22.0   0.0     9.0     11.0   109.0 118.0             23     48   227 180 5 22   0     9     11   109 118         23   48   227
831539 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No 1 02 06 2015   grade_2 4.0 14.0 45.0   1.0     9.0     2.0   39.0 36.0             43     5   75 4 14 45   1     9     2   39 36         43   5   75
832869 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004400 661100010009 WILLIAM B WARD ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 72.0 33.0 49.0         9.0     0.0   88.0 75.0             *     21   163 72 33 49         9     0   88 75             21   163
835111 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No 1 KG 03 2015   grade_2 94.0 4.0 19.0         9.0     2.0   68.0 60.0             12     13   128 94 4 19         9     2   68 60         12   13   128
835149 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No 1 KG 03 2015   grade_2 90.0 1.0 16.0         9.0     4.0   56.0 64.0             9     18   120 90 1 16         9     4   56 64         9   18   120
942533 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 46.0 2.0 3.0         9.0     0.0   29.0 31.0     *       10     9   60 46 2 3         9     0   29 31         10   9   60
942989 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2017   grade_2 62.0 1.0 2.0         9.0     4.0   38.0 40.0     6       23     13   78 62 1 2         9     4   38 40     6   23   13   78
952679 NY Broome   school 3629610 31601060000   VESTAL 362961003990 31601060028 VESTAL HILLS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 34.0 3.0 1.0         9.0     4.0   29.0 22.0     *       18     *   51 34 3 1         9     4   29 22         18       51
957847 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000093 131601060004 OVERLOOK PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 69.0 8.0 16.0         9.0     9.0   48.0 63.0     11       42     14   111 69 8 16         9     9   48 63     11   42   14   111
958835 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004211 140203060007 FOREST ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   grade_2 79.0 7.0 6.0   0.0     9.0     7.0   65.0 43.0     *       23     8   108 79 7 6   0     9     7   65 43         23   8   108
959082 NY Erie   school 3628500 140207060000   SWEET HOME 362850003828 140207060008 HERITAGE HTS ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 43.0 2.0 6.0   0.0     9.0     0.0   33.0 27.0     20       38     5   60 43 2 6   0     9     0   33 27     20   38   5   60
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
967898 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202607 331500010172 PS 172 BEACON SCHOOL OF EXCELLENCE public Regular School No Elementary PK 5 2017   grade_2 9.0 5.0 67.0   0.0     9.0     0.0   39.0 51.0     35       77     33   90 9 5 67   0     9     0   39 51     35   77   33   90
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
973484 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202753 332100010238 PS 238 ANNE SULLIVAN public Regular School No Elementary PK 8 2017   grade_2 4.0 1.0 33.0   0.0     9.0     0.0   24.0 23.0     23       32     9   47 4 1 33   0     9     0   24 23     23   32   9   47
973864 NY Kings   school 3601122 332100861075   SUCCESS ACADEMY CS - BENSONHU 360112206469 332100861075 SUCCESS ACADEMY CS - BENSONHURST charter Regular School Yes Elementary KG 3 2017   grade_2 50.0 11.0 23.0         9.0     0.0   48.0 45.0     11       41     14   93 50 11 23         9     0   48 45     11   41   14   93

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