Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by ell 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
1493951 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2021   grade_2 2.0 2.0 173.0   0.0     11.0     3.0   91.0 100.0     99       147     40   191 2 2 173   0     11     3   91 100     99   147   40   191
2136874 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2018   grade_2 25.0 39.0 184.0         4.0     9.0   146.0 115.0     98       218     25   261 25 39 184         4     9   146 115     98   218   25   261
1458744 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 05 2021   grade_2 4.0 1.0 39.0   1.0     146.0     1.0   104.0 88.0     97       190     *   192 4 1 39   1     146     1   104 88     97   190       192
1594233 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 9.0 36.0 110.0   1.0     7.0     0.0   82.0 81.0     97       149     13   163 9 36 110   1     7     0   82 81     97   149   13   163
1598850 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 02 2020   grade_2 5.0 77.0 120.0         0.0     0.0   104.0 98.0     97       194     34   202 5 77 120         0     0   104 98     97   194   34   202
2110255 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No Elementary KG 05 2018   grade_2 10.0 26.0 135.0   3.0     75.0     2.0   124.0 127.0     97       *     42   251 10 26 135   3     75     2   124 127     97       42   251
2110331 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 2018   grade_2 1.0   151.0   0.0     13.0     1.0   83.0 83.0     97       143     47   166 1   151   0     13     1   83 83     97   143   47   166
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
1463475 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No Elementary KG 05 2021   grade_2 4.0 0.0 8.0   1.0     182.0         109.0 86.0     96       174     26   195 4 0 8   1     182         109 86     96   174   26   195
1584182 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 2020   grade_2 2.0   140.0         7.0     1.0   78.0 72.0     96       129     32   150 2   140         7     1   78 72     96   129   32   150
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
1493970 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 2021   grade_2 1.0 0.0 157.0   0.0     6.0     0.0   93.0 71.0     95       143     31   164 1 0 157   0     6     0   93 71     95   143   31   164
1548899 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 05 2020   grade_2 2.0 0.0 54.0   0.0     167.0     0.0   113.0 110.0     95       220     21   223 2 0 54   0     167     0   113 110     95   220   21   223
1553592 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No Elementary KG 05 2020   grade_2 5.0 1.0 7.0   0.0     253.0         149.0 117.0     95       230     20   266 5 1 7   0     253         149 117     95   230   20   266
2124771 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004234 580109020001 MARTIN LUTHER KING ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2018   grade_2 3.0 89.0 118.0         0.0     1.0   101.0 110.0     95       206     23   211 3 89 118         0     1   101 110     95   206   23   211
2169307 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No Elementary KG 05 2019   grade_2 6.0 1.0 13.0   0.0     211.0         117.0 114.0     95       207     21   231 6 1 13   0     211         117 114     95   207   21   231
972325 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105227 332000010069 PS 69 VINCENT D GRIPPO SCHOOL public Regular School No Elementary KG 5 2017   grade_2 6.0 1.0 4.0         128.0     1.0   65.0 75.0     94       139     10   140 6 1 4         128     1   65 75     94   139   10   140
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
1004131 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202444 342500010120 PS 120 public Regular School No Elementary PK 05 2017   grade_2 1.0 1.0 24.0   0.0     135.0     0.0   73.0 88.0     93       71     19   161 1 1 24   0     135     0   73 88     93   71   19   161
2128875 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 5.0 9.0 192.0   0.0     3.0     3.0   97.0 115.0     93       188     38   212 5 9 192   0     3     3   97 115     93   188   38   212
2209777 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003770 500402060001 FLEETWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 4.0 28.0 131.0   1.0     2.0         89.0 77.0     93       149     7   166 4 28 131   1     2         89 77     93   149   7   166
1021497 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 2.0 12.0 194.0   0.0     1.0     4.0   98.0 115.0     92       202     22   213 2 12 194   0     1     4   98 115     92   202   22   213
1029344 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2017   grade_2 76.0 33.0 245.0         11.0     17.0   204.0 178.0     92       251     29   382 76 33 245         11     17   204 178     92   251   29   382
1512780 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_2 3.0 13.0 174.0   0.0     1.0     0.0   91.0 100.0     92       177     12   191 3 13 174   0     1     0   91 100     92   177   12   191
1594176 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003771 500402060002 GRANDVIEW ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 7.0 32.0 128.0   1.0     5.0     0.0   80.0 93.0     92       155     *   173 7 32 128   1     5     0   80 93     92   155       173
2110274 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2018   grade_2 10.0 7.0 239.0   1.0     13.0     0.0   136.0 134.0     92       239     56   270 10 7 239   1     13     0   136 134     92   239   56   270
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
1021573 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 5.0 11.0 182.0   1.0     3.0     2.0   105.0 99.0     91       194     23   204 5 11 182   1     3     2   105 99     91   194   23   204
2214470 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 02 2019   grade_2 2.0 95.0 121.0         1.0     0.0   104.0 115.0     91       210     28   219 2 95 121         1     0   104 115     91   210   28   219
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
1003998 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2017   grade_2 8.0 2.0 58.0   1.0     78.0     1.0   65.0 83.0     90       133     19   148 8 2 58   1     78     1   65 83     90   133   19   148
1463969 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105908 332000010503 PS 503 SCHOOL OF DISCOVERY (THE) public Regular School No Elementary KG 05 2021   grade_2 12.0 0.0 104.0   0.0     23.0     1.0   67.0 73.0     90       131     31   140 12 0 104   0     23     1   67 73     90   131   31   140
943027 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2017   grade_2 52.0 3.0 6.0         11.0     6.0   32.0 46.0     9       24     6   78 52 3 6         11     6   32 46     9   24   6   78
946580 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604808 320900010204 PS 204 MORRIS HEIGHTS public Regular School No Elementary PK 05 2017   grade_2 1.0 23.0 72.0   0.0     0.0     0.0   50.0 46.0     9       75     20   96 1 23 72   0     0     0   50 46     9   75   20   96
947796 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No Elementary KG 05 2017   grade_2 69.0 5.0 78.0   1.0     16.0     6.0   96.0 79.0     9       42     29   175 69 5 78   1     16     6   96 79     9   42   29   175
949430 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802100 321100010019 PS 19 JUDITH K WEISS public Regular School No Elementary KG 08 2017   grade_2 39.0 3.0 19.0   2.0     1.0     0.0   31.0 33.0     9       30     9   64 39 3 19   2     1     0   31 33     9   30   9   64
954389 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001345 61700010001 CARLYLE C RING ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_2 56.0 3.0 15.0   1.0     0.0     12.0   36.0 51.0     9       64     14   87 56 3 15   1     0     12   36 51     9   64   14   87
958151 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000247 131701060008 MILL ROAD-PRIMARY GRADES public Regular School No Elementary PK 02 2017   grade_2 98.0 1.0 14.0   0.0     2.0     1.0   55.0 61.0     9       35     *   116 98 1 14   0     2     1   55 61     9   35       116
962521 NY Erie   school 3630780 142801060000   WEST SENECA 363078004147 142801060017 NORTHWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 4 2017   grade_2 66.0 9.0 4.0   0.0     7.0     3.0   49.0 40.0     9       *     *   89 66 9 4   0     7     3   49 40     9           89
966606 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902095 331400010017 PS 17 HENRY D WOODWORTH public Regular School No Elementary PK 5 2017   grade_2 5.0 1.0 40.0   0.0     1.0     0.0   23.0 24.0     9       26     19   47 5 1 40   0     1     0   23 24     9   26   19   47
966834 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902533 331400010147 PS 147 ISSAC REMSEN public Regular School No Elementary PK 5 2017   grade_2 2.0 10.0 31.0         1.0     0.0   21.0 23.0     9       40     8   44 2 10 31         1     0   21 23     9   40   8   44
966872 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902668 331400010196 PS 196 TEN EYCK public Regular School No Elementary PK 5 2017   grade_2 1.0 9.0 51.0   0.0     0.0     0.0   31.0 30.0     9       56     18   61 1 9 51   0     0     0   31 30     9   56   18   61
967936 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202778 331500010261 PS 261 PHILIP LIVINGSTON public Regular School No Elementary PK 5 2017   grade_2 52.0 33.0 25.0   0.0     4.0     3.0   61.0 56.0     9       42     28   117 52 33 25   0     4     3   61 56     9   42   28   117
968411 NY Kings   school 3600949 331500860927   PAVE ACADEMY CHARTER SCHOOL 360094906082 331500860927 PAVE ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary PK 8 2017   grade_2 1.0 28.0 24.0   0.0     2.0         26.0 29.0     9       40     15   55 1 28 24   0     2         26 29     9   40   15   55
973560 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202797 332100010288 PS 288 SHIRLEY TANYHILL (THE) public Regular School No Elementary PK 8 2017   grade_2 6.0 47.0 30.0   0.0     3.0     0.0   48.0 38.0     9       69     22   86 6 47 30   0     3     0   48 38     9   69   22   86
977379 NY Monroe   school 3612630 260501060000   GREECE 361263001038 260501060002 LONGRIDGE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 74.0 15.0 28.0   0.0     6.0     12.0   72.0 63.0     9       *     17   135 74 15 28   0     6     12   72 63     9       17   135
977759 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969000745 260801060005 IVAN L GREEN PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 62.0 19.0 37.0         3.0     9.0   70.0 60.0     9       86     8   130 62 19 37         3     9   70 60     9   86   8   130
980647 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000074 270100010018 WILLIAM B TECLER ARTS IN EDUCATION public Regular School No Elementary PK 05 2017   grade_2 33.0 0.0 39.0   0.0     1.0     7.0   46.0 34.0     9       62     19   80 33 0 39   0     1     7   46 34     9   62   19   80
981369 NY Nassau   school 3609840 280203030000   EAST MEADOW 360984000758 280203030003 MCVEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 61.0 5.0 24.0         19.0     2.0   51.0 60.0     9       31     *   111 61 5 24         19     2   51 60     9   31       111
982015 NY Nassau   school 3600030 280208860024   ROOSEVELT CHILDREN'S ACAD CHA 360003004379 280208860024 ROOSEVELT CHILDREN'S ACAD CHARTER SC charter Regular School Yes Elementary KG 08 2017   grade_2 5.0 57.0 16.0         0.0     0.0   40.0 38.0     9       61     7   78 5 57 16         0     0   40 38     9   61   7   78
982699 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004229 280214030003 OGDEN ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 54.0 7.0 23.0         8.0     1.0   58.0 35.0     9       27     8   93 54 7 23         8     1   58 35     9   27   8   93
982851 NY Nassau   school 3610620 280216020000   ELMONT 361062000831 280216020001 ALDEN TERRACE SCHOOL public Regular School No Elementary PK 06 2017   grade_2 2.0 27.0 17.0   1.0     10.0     3.0   26.0 34.0     9       40     11   60 2 27 17   1     10     3   26 34     9   40   11   60
982870 NY Nassau   school 3610620 280216020000   ELMONT 361062000832 280216020002 CLARA H CARLSON SCHOOL public Regular School No Elementary PK 06 2017   grade_2 1.0 45.0 48.0   0.0     23.0     2.0   62.0 57.0     9       90     8   119 1 45 48   0     23     2   62 57     9   90   8   119
983003 NY Nassau   school 3611460 280217020000   FRANKLIN SQUARE 361146000903 280217020004 WASHINGTON STREET SCHOOL public Regular School No Elementary PK 07 2017   grade_2 76.0 3.0 26.0   0.0     10.0     4.0   64.0 55.0     9       27     15   119 76 3 26   0     10     4   64 55     9   27   15   119
988741 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702414 310200010111 PS 111 ADOLPH S OCHS public Regular School No Elementary PK 05 2017   grade_2 12.0 3.0 19.0   0.0     11.0     3.0   24.0 24.0     9       22     *   48 12 3 19   0     11     3   24 24     9   22       48
991762 NY New York   school 3601097 310300861034   HARLEM HEBREW LANGUAGE ACADE 360109706377 310300861034 HARLEM HEBREW LANGUAGE ACADEMY charter Regular School Yes Elementary KG 04 2017   grade_2 29.0 27.0 24.0   0.0     2.0     1.0   47.0 36.0     9       45     25   83 29 27 24   0     2     1   47 36     9   45   25   83
994023 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305989 310600010368 HAMILTON HEIGHTS SCHOOL public Regular School No Elementary KG 05 2017   grade_2 4.0 8.0 23.0   0.0     0.0     1.0   23.0 13.0     9       28     7   36 4 8 23   0     0     1   23 13     9   28   7   36
997481 NY Onondaga   school 3627150 420702030000   SOLVAY 362715003698 420702030001 SOLVAY ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_2 71.0 7.0 6.0   0.0           7.0   53.0 38.0     9       68     11   91 71 7 6   0           7   53 38     9   68   11   91
998735 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003869 421800010042 MCKINLEY-BRIGHTON ELEMENTARY public Regular School No Elementary PK 05 2017   grade_2 10.0 71.0 6.0   1.0     1.0     9.0   54.0 44.0     9       92     21   98 10 71 6   1     1     9   54 44     9   92   21   98
999875 NY Orange   school 3623010 440401060000   PINE BUSH 362301003223 440401060006 CIRCLEVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 54.0 5.0 8.0   0.0     3.0     2.0   41.0 31.0     9       34     8   72 54 5 8   0     3     2   41 31     9   34   8   72
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
1000673 NY Orange   school 3620700 441600010000   NEWBURGH 362070002909 441600010010 NEW WINDSOR SCHOOL public Regular School No Elementary KG 05 2017   grade_2 19.0 16.0 43.0   0.0     4.0     4.0   44.0 42.0     9       63     12   86 19 16 43   0     4     4   44 42     9   63   12   86
1005233 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902709 342600010213 PS 213 CARL ULLMAN SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_2 4.0 6.0 10.0         46.0     1.0   34.0 33.0     9       *     9   67 4 6 10         46     1   34 33     9       9   67
1005632 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302516 342700010065 PS 65 RAYMOND YORK ELEM SCH (THE) public Regular School No Elementary KG 05 2017   grade_2 5.0 1.0 41.0   9.0     26.0     0.0   34.0 48.0     9       47     11   82 5 1 41   9     26     0   34 48     9   47   11   82
1006069 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302743 342700010232 PS 232 LINDENWOOD public Regular School No Elementary KG 08 2017   grade_2 33.0 5.0 49.0   0.0     12.0     3.0   45.0 57.0     9       59     23   102 33 5 49   0     12     3   45 57     9   59   23   102
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
1007969 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102493 342900010134 PS 134 HOLLIS public Regular School No Elementary PK 05 2017   grade_2 2.0 44.0 5.0   0.0     2.0     0.0   26.0 27.0     9       41     *   53 2 44 5   0     2     0   26 27     9   41       53
1011199 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302234 353100010054 PS 54 CHARLES W LENG public Regular School No Elementary PK 05 2017   grade_2 38.0 7.0 18.0   0.0     38.0     1.0   43.0 59.0     9       54     28   102 38 7 18   0     38     1   43 59     9   54   28   102
1018609 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001756 580212060004 WEST MIDDLE ISLAND SCHOOL public Regular School No Elementary KG 04 2017   grade_2 86.0 22.0 41.0   0.0     7.0     7.0   90.0 73.0     9       80     24   163 86 22 41   0     7     7   90 73     9   80   24   163
1019996 NY Suffolk   school 3613290 580405060000   HALF HOLLOW HILLS 361329001089 580405060012 PAUMANOK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 37.0 12.0 11.0         17.0     8.0   43.0 42.0     9       18     26   85 37 12 11         17     8   43 42     9   18   26   85
1024328 NY Ulster   school 3616290 620600010000   KINGSTON 361629001432 620600010012 GEORGE WASHINGTON SCHOOL public Regular School No Elementary PK 04 2017   grade_2 22.0 11.0 27.0         1.0     7.0   25.0 43.0     9       56     13   68 22 11 27         1     7   25 43     9   56   13   68
1029743 NY Westchester   school 3625260 661800010000   RYE 362526003489 661800010001 MIDLAND SCHOOL public Regular School No Elementary KG 05 2017   grade_2 79.0 1.0 9.0   0.0     11.0     1.0   46.0 55.0     9       *     *   101 79 1 9   0     11     1   46 55     9           101
1030446 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No Elementary PK 08 2017   grade_2 12.0 8.0 26.0   0.0     3.0     0.0   30.0 19.0     9       34     *   49 12 8 26   0     3     0   30 19     9   34       49
1030465 NY Westchester   school 3631920 662300010000   YONKERS 363192001527 662300010004 MONTESSORI SCHOOL 31 public Regular School No Elementary PK 06 2017   grade_2 10.0 9.0 24.0   0.0     7.0     1.0   26.0 25.0     9       28     14   51 10 9 24   0     7     1   26 25     9   28   14   51
1030541 NY Westchester   school 3631920 662300010000   YONKERS 363192004255 662300010009 SCHOOL 9 public Regular School No Elementary PK 06 2017   grade_2 4.0 11.0 27.0   1.0     2.0     0.0   27.0 18.0     9       44     *   45 4 11 27   1     2     0   27 18     9   44       45
1031035 NY Westchester   school 3631920 662300010000   YONKERS 363192004248 662300010046 MLK JR HIGH TECH & COMPUTER MAGNE public Regular School No Elementary PK 08 2017   grade_2 4.0 25.0 27.0   0.0     1.0     2.0   33.0 26.0     9       52     5   59 4 25 27   0     1     2   33 26     9   52   5   59
1433075 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_2 11.0 32.0 14.0   0.0     3.0     8.0   38.0 30.0     9       60     20   68 11 32 14   0     3     8   38 30     9   60   20   68
1433759 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 34.0 2.0 10.0   1.0     7.0     9.0   32.0 31.0     9       24     *   63 34 2 10   1     7     9   32 31     9   24       63
1434880 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 JUAN PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2021   grade_2 0.0 11.0 44.0   1.0     0.0     2.0   34.0 24.0     9       54     12   58 0 11 44   1     0     2   34 24     9   54   12   58
1436362 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502530 320800010146 PS 146 EDWARD COLLINS public Regular School No Elementary PK 05 2021   grade_2 1.0 19.0 27.0   0.0     0.0     1.0   29.0 19.0     9       46     15   48 1 19 27   0     0     1   29 19     9   46   15   48
1436666 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506614 320800010583 PS 583 public Regular School No Elementary PK 03 2021   grade_2 1.0 2.0 22.0   1.0     26.0     0.0   22.0 30.0     9       45     *   52 1 2 22   1     26     0   22 30     9   45       52
1437198 NY Bronx   school 3601198 320800861143   BOLD CHARTER SCHOOL 360119806695 320800861143 BOLD CHARTER SCHOOL charter Regular School Yes Elementary KG 02 2021   grade_2 1.0 19.0 37.0   1.0     2.0     1.0   32.0 29.0     9       57     10   61 1 19 37   1     2     1   32 29     9   57   10   61
1437236 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605191 320900010004 PS/MS 4 CROTONA PARK WEST public Regular School No Elementary PK 08 2021   grade_2 0.0 13.0 23.0   1.0     1.0     1.0   25.0 14.0     9       39     10   39 0 13 23   1     1     1   25 14     9   39   10   39
1437255 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602073 320900010011 PS 11 HIGHBRIDGE public Regular School No Elementary PK 05 2021   grade_2 1.0 18.0 41.0   0.0     1.0         27.0 34.0     9       56     12   61 1 18 41   0     1         27 34     9   56   12   61
1438699 NY Bronx   school 3601069 320900861029   ICAHN CHARTER SCHOOL 6 360106906355 320900861029 ICAHN CHARTER SCHOOL 6 charter Regular School Yes Elementary KG 08 2021   grade_2 1.0 21.0 16.0   0.0     1.0     0.0   16.0 23.0     9       34     *   39 1 21 16   0     1     0   16 23     9   34       39
1438794 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705137 321000010003 PS 3 RAUL JULIA MICRO SOCIETY public Regular School No Elementary PK 08 2021   grade_2 0.0 8.0 24.0                   14.0 18.0     9       32     13   32 0 8 24                   14 18     9   32   13   32
1439155 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702318 321000010081 PS 81 ROBERT J CHRISTEN public Regular School No Elementary KG 05 2021   grade_2 29.0 15.0 58.0   3.0     6.0     5.0   67.0 49.0     9       43     24   116 29 15 58   3     6     5   67 49     9   43   24   116
1439763 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706057 321000010382 ELEM SCHOOL FOR MATH, SCIENCE, TECH public Regular School No Elementary KG 05 2021   grade_2   6.0 36.0   1.0     1.0         27.0 17.0     9       43     12   44   6 36   1     1         27 17     9   43   12   44
1441378 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806217 321100010498 PS/MS 498 VAN NEST ACADEMY public Regular School No Elementary KG 08 2021   grade_2 9.0 9.0 37.0   1.0     5.0     2.0   31.0 32.0     9       48     12   63 9 9 37   1     5     2   31 32     9   48   12   63
1441834 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes Elementary KG 08 2021   grade_2 1.0 30.0 26.0   0.0     31.0     0.0   48.0 40.0     9       66     8   88 1 30 26   0     31     0   48 40     9   66   8   88
1442556 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006133 321200010463 URBAN SCHOLARS COMMUNITY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 0.0 26.0 32.0   0.0     2.0     2.0   32.0 30.0     9       58     18   62 0 26 32   0     2     2   32 30     9   58   18   62
1442613 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006630 321200010595 PS 595 public Regular School No Elementary PK 04 2021   grade_2 0.0 10.0 27.0   0.0               17.0 20.0     9       34     11   37 0 10 27   0               17 20     9   34   11   37
1442898 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003847 321200011691 BRONX LITTLE SCHOOL public Regular School No Elementary PK 05 2021   grade_2 0.0 5.0 31.0   0.0     8.0     0.0   21.0 23.0     9       40     12   44 0 5 31   0     8     0   21 23     9   40   12   44
1445254 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000720 60800010003 SCHOOL 3 public Regular School No Elementary KG 05 2021   grade_2 8.0 2.0 30.0   0.0           2.0   17.0 25.0     9       39     8   42 8 2 30   0           2   17 25     9   39   8   42
1445311 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000724 60800010007 SCHOOL 7 public Regular School No Elementary KG 05 2021   grade_2 10.0 0.0 23.0         0.0     0.0   14.0 19.0     9       21     0   33 10 0 23         0     0   14 19     9   21   0   33
1449605 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004020 132101060013 MYERS CORNERS SCHOOL public Regular School No Elementary KG 06 2021   grade_2 85.0 4.0 23.0         7.0     4.0   61.0 62.0     9       40     22   123 85 4 23         7     4   61 62     9   40   22   123
1450004 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004215 140203060008 MAPLE WEST ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 91.0 8.0 5.0         12.0     3.0   64.0 55.0     9       30     12   119 91 8 5         12     3   64 55     9   30   12   119
1453405 NY Erie   school 3628740 142500010000   TONAWANDA 362874003905 142500010007 RIVERVIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2021   grade_2 54.0 2.0 7.0         2.0     4.0   39.0 30.0     9       42     *   69 54 2 7         2     4   39 30     9   42       69
1457737 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902144 331400010031 PS 31 SAMUEL F DUPONT public Regular School No Elementary PK 05 2021   grade_2 26.0 3.0 32.0   1.0     14.0     0.0   40.0 36.0     9       55     14   76 26 3 32   1     14     0   40 36     9   55   14   76
1457965 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902764 331400010250 PS 250 GEORGE H LINDSAY public Regular School No Elementary PK 05 2021   grade_2 1.0 5.0 29.0         16.0     0.0   21.0 30.0     9       45     *   51 1 5 29         16     0   21 30     9   45       51

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