Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by white 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
762037 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004212 140203060005 HEIM ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   grade_2 99.0 5.0 3.0   1.0     21.0     5.0   56.0 78.0             23     10   134 99 5 3   1     21     5   56 78         23   10   134
817764 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000153 521301060006 WOOD ROAD ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 99.0 1.0 2.0         0.0     1.0   57.0 46.0             44     21   103 99 1 2         0     1   57 46         44   21   103
818619 NY Schenectady   school 3625980 530501060000   SCHALMONT 362598003567 530501060003 JEFFERSON ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 99.0 1.0 8.0   0.0     3.0     5.0   62.0 54.0             40     *   116 99 1 8   0     3     5   62 54         40       116
952261 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001627 31101060003 HOMER BRINK SCHOOL public Regular School No Elementary KG 05 2017   grade_2 99.0 5.0 1.0   0.0     4.0     3.0   57.0 55.0     0       42     14   112 99 5 1   0     4     3   57 55     0   42   14   112
958778 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004214 140203060003 MAPLE EAST ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   grade_2 99.0 2.0 2.0   0.0     16.0     3.0   70.0 52.0     7       13     *   122 99 2 2   0     16     3   70 52     7   13       122
962103 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190003109 142301060007 ELLICOTT ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 99.0 0.0 2.0   0.0     2.0     1.0   51.0 53.0     *       13     19   104 99 0 2   0     2     1   51 53         13   19   104
976923 NY Madison   school 3606390 250901060000   CANASTOTA 360639000422 250901060006 SOUTH SIDE ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2017   grade_2 99.0 3.0 3.0   1.0     1.0     4.0   54.0 57.0     *       71     17   111 99 3 3   1     1     4   54 57         71   17   111
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
1016348 NY Steuben   school 3614820 571800010000   HORNELL 361482001230 571800010002 BRYANT SCHOOL public Regular School No Other 02 11 2017   grade_2 99.0 2.0 3.0         1.0     6.0   56.0 55.0     6       79     18   111 99 2 3         1     6   56 55     6   79   18   111
1066432 NY Livingston   school 3617640 240801060000   LIVONIA 361764001577 240801060001 LIVONIA ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 99.0 1.0 3.0         1.0     5.0   65.0 44.0             47     7   109 99 1 3         1     5   65 44         47   7   109
1066736 NY Madison   school 3606780 250201060000   CAZENOVIA 360678000465 250201060006 BURTON STREET ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 99.0 0.0 2.0   0.0     1.0     1.0   58.0 45.0             25     8   103 99 0 2   0     1     1   58 45         25   8   103
1076502 NY Nassau   school 3610980 280522030000   FARMINGDALE 361098000881 280522030006 WOODWARD PARKWAY ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 99.0 3.0 28.0   0.0     6.0     0.0   78.0 58.0             36     27   136 99 3 28   0     6     0   78 58         36   27   136
1108669 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No 1.0 01 06 2016   grade_2 99.0 7.0 62.0         10.0     8.0   101.0 85.0             72     39   186 99 7 62         10     8   101 85         72   39   186
1108707 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001751 580212060001 C E WALTERS SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 99.0 28.0 36.0   0.0     4.0     8.0   85.0 90.0             95     32   175 99 28 36   0     4     8   85 90         95   32   175
1108726 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001752 580212060002 CORAM ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 99.0 33.0 54.0   0.0     14.0     17.0   108.0 109.0             113     32   217 99 33 54   0     14     17   108 109         113   32   217
1453348 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190003109 142301060007 ELLICOTT ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_2 99.0   2.0         0.0     6.0   56.0 51.0             7     15   107 99   2         0     6   56 51         7   15   107
1456217 NY Jefferson   school 3611910 220401040000   GENERAL BROWN 361191000959 220401040003 DEXTER ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2021   grade_2 99.0 3.0 4.0         1.0     2.0   51.0 58.0     *             23   109 99 3 4         1     2   51 58             23   109
1542724 NY Erie   school 3613350 141601060000   HAMBURG 361335001100 141601060004 UNION PLEASANT AVENUE ELEMENTARY SCH public Regular School No Elementary KG 05 2020   grade_2 99.0 0.0 2.0         0.0     3.0   54.0 50.0             24     21   104 99 0 2         0     3   54 50         24   21   104
1544795 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500283 171102040002 LEARNING COMMUN-BROADALBIN-PERTH (TH public Regular School No Elementary PK 02 2020   grade_2 99.0 0.0 3.0         1.0     1.0   56.0 48.0     *       40     8   104 99 0 3         1     1   56 48         40   8   104
2065491 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000247 131701060008 MILL ROAD-PRIMARY GRADES public Regular School No Elementary PK 02 2018   grade_2 99.0 2.0 17.0   0.0     0.0     3.0   68.0 53.0     *       39     29   121 99 2 17   0     0     3   68 53         39   29   121
2104802 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2018   grade_2 99.0 6.0 9.0   1.0     4.0     6.0   60.0 65.0     *       33     13   125 99 6 9   1     4     6   60 65         33   13   125
2129274 NY Suffolk   school 3626840 580601040000   SHOREHAM-WADING R 362684003656 580601040002 MILLER AVENUE SCHOOL public Regular School No Elementary KG 02 2018   grade_2 99.0 1.0 14.0         4.0     3.0   67.0 54.0     *       10     25   121 99 1 14         4     3   67 54         10   25   121
2149452 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY SCHOOL public Regular School No Elementary PK 03 2019   grade_2 99.0 0.0 0.0               1.0   57.0 43.0             57     *   100 99 0 0               1   57 43         57       100
2173069 NY Lewis   school 3617820 230901040000   LOWVILLE 361782001602 230901040001 LOWVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 99.0 0.0 2.0   0.0     0.0     4.0   55.0 50.0     *       60     14   105 99 0 2   0     0     4   55 50         60   14   105
2217738 NY Suffolk   school 3609720 580503030000   EAST ISLIP 360972000753 580503030004 TIMBER POINT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 99.0 2.0 22.0         1.0     7.0   66.0 65.0     *       23     29   131 99 2 22         1     7   66 65         23   29   131
782196 NY Monroe   school 3623160 261401060000   PITTSFORD 362316004744 261401060005 MENDON CENTER ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 98.0 3.0 6.0         18.0     9.0   75.0 59.0             *     14   134 98 3 6         18     9   75 59             14   134
794698 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802677 310300010199 PS 199 JESSIE ISADOR STRAUS public Regular School No 1 KG 05 2015   grade_2 98.0 4.0 14.0   0.0     19.0     10.0   75.0 70.0             7     31   145 98 4 14   0     19     10   75 70         7   31   145
800607 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002995 420303060002 KARL W SAILE BEAR ROAD ELEM SCHOOL public Regular School No 1 KG 04 2015   grade_2 98.0 6.0 5.0   0.0     3.0     9.0   65.0 56.0             47     21   121 98 6 5   0     3     9   65 56         47   21   121
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
981787 NY Nassau   school 3626400 280206030000   SEAFORD 362640003617 280206030003 SEAFORD HARBOR SCHOOL public Regular School No Elementary KG 05 2017   grade_2 98.0 0.0 2.0         4.0     1.0   51.0 54.0     *       13     16   105 98 0 2         4     1   51 54         13   16   105
1013973 NY Saratoga   school 3608370 520401040000   CORINTH 360837002644 520401040009 CORINTH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 98.0   4.0         1.0     2.0   55.0 50.0             62     21   105 98   4         1     2   55 50         62   21   105
1028147 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001645 660701030002 CHATSWORTH AVENUE SCHOOL public Regular School No Elementary PK 05 2017   grade_2 98.0 2.0 8.0   0.0     2.0     5.0   57.0 58.0     5       6     7   115 98 2 8   0     2     5   57 58     5   6   7   115
1087921 NY Onondaga   school 3618330 421001060000   FAYETTVLLE-MANLIUS 361833001654 421001060008 ENDERS ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 98.0 0.0 4.0   0.0     16.0     5.0   57.0 66.0             8     7   123 98 0 4   0     16     5   57 66         8   7   123
1118340 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001645 660701030002 CHATSWORTH AVENUE SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 98.0 1.0 10.0         2.0     5.0   61.0 55.0             *     5   116 98 1 10         2     5   61 55             5   116
1452702 NY Erie   school 3613350 141601060000   HAMBURG 361335001100 141601060004 UNION PLEASANT AVENUE ELEMENTARY SCH public Regular School No Elementary KG 05 2021   grade_2 98.0 1.0 5.0         0.0     1.0   49.0 56.0             30     27   105 98 1 5         0     1   49 56         30   27   105
1469384 NY Monroe   school 3614460 261101060000   HILTON 361446001197 261101060001 VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_2 98.0 5.0 14.0   1.0     0.0     4.0   70.0 52.0     *       44     8   122 98 5 14   1     0     4   70 52         44   8   122
1519430 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001649 660701030004 MURRAY AVENUE SCHOOL public Regular School No Other KG 09 2021   grade_2 98.0 1.0 9.0   0.0     3.0     8.0   59.0 60.0     *       *     14   119 98 1 9   0     3     8   59 60             14   119
1542838 NY Erie   school 3611670 141604060000   FRONTIER 361167000926 141604060006 PINEHURST ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 98.0 0.0 3.0   0.0     0.0     3.0   50.0 54.0             14     11   104 98 0 3   0     0     3   50 54         14   11   104
2069196 NY Erie   school 3616680 141901060000   LANCASTER 361668001485 141901060004 COMO PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 98.0 0.0 3.0   1.0     0.0     2.0   58.0 46.0             35     14   104 98 0 3   1     0     2   58 46         35   14   104
2105220 NY Onondaga   school 3618330 421001060000   FAYETTVLLE-MANLIUS 361833001654 421001060008 ENDERS ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_2 98.0 5.0 7.0   1.0     16.0     6.0   71.0 62.0     *       8     10   133 98 5 7   1     16     6   71 62         8   10   133
2121446 NY Saratoga   school 3618900 521200050000   MECHANICVILLE 361890001712 521200050001 MECHANICVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 98.0 0.0 1.0         3.0     4.0   57.0 49.0     *       51     19   106 98 0 1         3     4   57 49         51   19   106
2220417 NY Tioga   school 3630270 600101060000   WAVERLY 363027004066 600101060002 ELM STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2019   grade_2 98.0 1.0 2.0         0.0     0.0   46.0 55.0             *     *   101 98 1 2         0     0   46 55                 101
756641 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2015   grade_2 97.0 2.0 2.0         0.0     0.0   55.0 46.0             56     21   101 97 2 2         0     0   55 46         56   21   101
761923 NY Erie   school 3602920 140201060000   AMHERST 360292004378 140201060005 SMALLWOOD DRIVE SCHOOL public Regular School No 1 KG 5 2015   grade_2 97.0 2.0 4.0   0.0     3.0     4.0   60.0 50.0             11     8   110 97 2 4   0     3     4   60 50         11   8   110
765780 NY Erie   school 3630780 142801060000   WEST SENECA 363078004754 142801060018 WEST ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   grade_2 97.0 0.0 3.0   0.0     0.0     1.0   57.0 44.0             29     11   101 97 0 3   0     0     1   57 44         29   11   101
770948 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202139 331500010029 PS 29 JOHN M HARRIGAN public Regular School No 1 PK 5 2015   grade_2 97.0 6.0 20.0         6.0     10.0   65.0 74.0             17     18   139 97 6 20         6     10   65 74         17   18   139
790119 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863001683 280523030001 BIRCH LANE ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   grade_2 97.0 0.0 4.0   1.0     3.0     0.0   48.0 57.0             6     6   105 97 0 4   1     3     0   48 57         6   6   105
819569 NY Seneca   school 3600014 561006060000   WATERLOO 360001401442 561006060004 SKOI-YASE SCHOOL public Regular School No 1 PK 02 2015   grade_2 97.0 5.0 4.0         1.0     2.0   55.0 54.0             58     7   109 97 5 4         1     2   55 54         58   7   109
824034 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003727 580413030003 OAKWOOD PRIMARY CENTER public Regular School No 1 KG 02 2015   grade_2 97.0 16.0 109.0   1.0     19.0     5.0   129.0 118.0             136     22   247 97 16 109   1     19     5   129 118         136   22   247
954560 NY Chautauqua   school 3611520 62201060000   FREDONIA 361152000906 62201060001 FREDONIA ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_2 97.0 0.0 24.0         2.0     4.0   69.0 58.0     6       60     19   127 97 0 24         2     4   69 58     6   60   19   127
961590 NY Erie   school 3611670 141604060000   FRONTIER 361167000926 141604060006 PINEHURST ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 97.0 0.0 0.0   0.0     1.0     0.0   64.0 34.0             15     10   98 97 0 0   0     1     0   64 34         15   10   98
961780 NY Erie   school 3616680 141901060000   LANCASTER 361668001481 141901060001 JOHN A SCIOLE ELEMENTARY SCHOOL public Regular School No Elementary KG 3 2017   grade_2 97.0 1.0 2.0   1.0     1.0     2.0   55.0 49.0     0       24     11   104 97 1 2   1     1     2   55 49     0   24   11   104
1001072 NY Orleans   school 3602520 450101060000   ALBION 360252000035 450101060002 RONALD L SODOMA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 97.0 24.0 14.0   0.0     2.0     0.0   64.0 73.0     6       82     9   137 97 24 14   0     2     0   64 73     6   82   9   137
1014999 NY Schenectady   school 3625980 530501060000   SCHALMONT 362598003567 530501060003 JEFFERSON ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   grade_2 97.0 3.0 8.0   0.0     4.0     8.0   66.0 54.0     *       50     13   120 97 3 8   0     4     8   66 54         50   13   120
1043233 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2016   grade_2 97.0 0.0 3.0         1.0     2.0   47.0 56.0             61     18   103 97 0 3         1     2   47 56         61   18   103
1048648 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004212 140203060005 HEIM ELEMENTARY SCHOOL public Regular School No 1.0 KG 4 2016   grade_2 97.0 1.0 9.0   0.0     14.0     7.0   67.0 61.0             19     11   128 97 1 9   0     14     7   67 61         19   11   128
1067116 NY Madison   school 3607470 251601060000   CHITTENANGO 360747000529 251601060002 BOLIVAR ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 97.0 0.0 2.0         1.0     5.0   52.0 53.0             32     11   105 97 0 2         1     5   52 53         32   11   105
1110341 NY Suffolk   school 3608130 580410030000   COMMACK 360813000587 580410030008 NORTH RIDGE SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 97.0 1.0 10.0         6.0     1.0   62.0 53.0             12     *   115 97 1 10         6     1   62 53         12       115
1453044 NY Erie   school 3616680 141901060000   LANCASTER 361668001485 141901060004 COMO PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 97.0 1.0 2.0   0.0     0.0     2.0   53.0 49.0     *       28     17   102 97 1 2   0     0     2   53 49         28   17   102
1453519 NY Erie   school 3616230 142601030000   KENMORE 361623004396 142601030020 THOMAS A EDISON ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 97.0 3.0 6.0   0.0     2.0     9.0   56.0 61.0     *       49     12   117 97 3 6   0     2     9   56 61         49   12   117
1507916 NY Suffolk   school 3603720 580101030000   BABYLON 360372000120 580101030003 BABYLON ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 97.0 1.0 21.0         2.0     4.0   66.0 59.0     8       *     11   125 97 1 21         2     4   66 59     8       11   125
1543085 NY Erie   school 3616680 141901060000   LANCASTER 361668001486 141901060005 COURT STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 97.0 0.0 3.0   0.0     3.0     2.0   54.0 51.0     *       14     17   105 97 0 3   0     3     2   54 51         14   17   105
1543275 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190003113 142301060001 WINDOM ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 97.0 3.0 1.0         0.0     5.0   52.0 54.0             25     13   106 97 3 1         0     5   52 54         25   13   106
1559482 NY Monroe   school 3614460 261101060000   HILTON 361446001197 261101060001 VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_2 97.0 4.0 9.0   0.0     0.0     2.0   52.0 60.0             58     11   112 97 4 9   0     0     2   52 60         58   11   112
1565866 NY Nassau   school 3625050 280403030000   ROSLYN 362505003467 280403030004 EAST HILLS ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_2 97.0 6.0 19.0   0.0     22.0     2.0   67.0 79.0     13       28     10   146 97 6 19   0     22     2   67 79     13   28   10   146
1580610 NY Ontario   school 3622890 431301060000   PHELPS-CLIFTON SPR 362289003215 431301060001 MIDLAKES PRIMARY SCHOOL public Regular School No Elementary KG 02 2020   grade_2 97.0 0.0 11.0               2.0   57.0 53.0     *       60     15   110 97 0 11               2   57 53         60   15   110
1597330 NY Seneca   school 3600014 561006060000   WATERLOO 360001401442 561006060004 SKOI-YASE SCHOOL public Regular School No Elementary PK 02 2020   grade_2 97.0 4.0 8.0         1.0     8.0   57.0 61.0     *       74     9   118 97 4 8         1     8   57 61         74   9   118
2069177 NY Erie   school 3616680 141901060000   LANCASTER 361668001481 141901060001 JOHN A SCIOLE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 97.0 1.0 3.0   0.0     2.0     5.0   52.0 56.0     *       38     13   108 97 1 3   0     2     5   52 56         38   13   108
2083864 NY Livingston   school 3608790 241001060000   DANSVILLE 360879000666 241001060004 DANSVILLE PRIMARY SCHOOL public Regular School No Elementary PK 02 2018   grade_2 97.0 0.0 0.0               5.0   51.0 51.0             65     14   102 97 0 0               5   51 51         65   14   102
2098399 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802677 310300010199 PS 199 JESSIE ISADOR STRAUS public Regular School No Elementary KG 05 2018   grade_2 97.0 11.0 9.0   1.0     20.0     13.0   70.0 81.0     6       11     29   151 97 11 9   1     20     13   70 81     6   11   29   151
2108450 NY Orleans   school 3602520 450101060000   ALBION 360252000035 450101060002 RONALD L SODOMA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 97.0 14.0 12.0   1.0     1.0         64.0 61.0     5       75     16   125 97 14 12   1     1         64 61     5   75   16   125
2123308 NY Seneca   school 3600014 561006060000   WATERLOO 360001401442 561006060004 SKOI-YASE SCHOOL public Regular School No Elementary PK 02 2018   grade_2 97.0 8.0 4.0         1.0     0.0   55.0 55.0     *       66     14   110 97 8 4         1     0   55 55         66   14   110
2150440 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_2 97.0 1.0 2.0         1.0     3.0   62.0 42.0     *       54     29   104 97 1 2         1     3   62 42         54   29   104
2153404 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 97.0 2.0 17.0   0.0     2.0     7.0   57.0 68.0     11       59     23   125 97 2 17   0     2     7   57 68     11   59   23   125
2175425 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000858 261301060001 BROOKS HILL SCHOOL public Regular School No Elementary KG 05 2019   grade_2 97.0 3.0 2.0         6.0     6.0   52.0 62.0     15       31     8   114 97 3 2         6     6   52 62     15   31   8   114
2193893 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002999 420303060004 LAKESHORE ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_2 97.0 2.0 9.0   2.0     2.0     1.0   61.0 52.0             46     28   113 97 2 9   2     2     1   61 52         46   28   113
2208200 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302233 353100010053 BARBARA ESSELBORN SCHOOL (THE) public Regular School No Elementary PK 05 2019   grade_2 97.0 1.0 19.0   0.0     15.0     4.0   82.0 54.0     8       65     35   136 97 1 19   0     15     4   82 54     8   65   35   136
2219790 NY Suffolk   school 3600125 580912060000   ESTPRT-S MANOR CSD 360012503736 580912060003 SOUTH STREET SCHOOL public Regular School No Elementary KG 02 2019   grade_2 97.0 5.0 10.0         1.0     3.0   60.0 56.0     8       37     22   116 97 5 10         1     3   60 56     8   37   22   116
2224426 NY Westchester   school 3615450 660402020000   IRVINGTON 361545004903 660402020004 DOWS LANE (K-3) SCHOOL public Regular School No Elementary KG 03 2019   grade_2 97.0 3.0 16.0   0.0     17.0     8.0   82.0 59.0     *       11     19   141 97 3 16   0     17     8   82 59         11   19   141
779935 NY Livingston   school 3617640 240801060000   LIVONIA 361764001577 240801060001 LIVONIA ELEMENTARY SCHOOL public Regular School No 1 PK 05 2015   grade_2 96.0 1.0 2.0         0.0     4.0   54.0 49.0             44     9   103 96 1 2         0     4   54 49         44   9   103
780239 NY Madison   school 3606780 250201060000   CAZENOVIA 360678000465 250201060006 BURTON STREET ELEMENTARY SCHOOL public Regular School No 1 KG 04 2015   grade_2 96.0 0.0 0.0   1.0     1.0     3.0   55.0 46.0             25     10   101 96 0 0   1     1     3   55 46         25   10   101
800626 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002996 420303060003 CICERO ELEMENTARY SCHOOL public Regular School No 1 KG 04 2015   grade_2 96.0 1.0 4.0   0.0     3.0     3.0   59.0 48.0             26     21   107 96 1 4   0     3     3   59 48         26   21   107
814857 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302239 353100010055 PS 55 HENRY M BOEHM public Regular School No 1 PK 05 2015   grade_2 96.0 2.0 8.0   0.0     3.0     1.0   49.0 61.0             45     26   110 96 2 8   0     3     1   49 61         45   26   110
833762 NY Westchester   school 3624630 661905020000   BLIND BROOK-RYE 362463003351 661905020001 BRUNO M PONTERIO RIDGE STREET SCHOO public Regular School No 1 KG 07 2015   grade_2 96.0 0.0 4.0         6.0     2.0   56.0 52.0             0     8   108 96 0 4         6     2   56 52         0   8   108
978310 NY Monroe   school 3614460 261101060000   HILTON 361446004592 261101060006 NORTHWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_2 96.0 5.0 4.0   0.0     1.0     6.0   61.0 51.0     *       24     7   112 96 5 4   0     1     6   61 51         24   7   112
986537 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863001683 280523030001 BIRCH LANE ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_2 96.0 0.0 7.0   0.0     1.0     0.0   58.0 46.0             8     20   104 96 0 7   0     1     0   58 46         8   20   104
996892 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002995 420303060002 KARL W SAILE BEAR ROAD ELEM SCHOOL public Regular School No Elementary KG 04 2017   grade_2 96.0 8.0 8.0   1.0     2.0     12.0   53.0 74.0             53     17   127 96 8 8   1     2     12   53 74         53   17   127
1078611 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702184 310200010041 PS 41 GREENWICH VILLAGE public Regular School No 1.0 PK 08 2016   grade_2 96.0 2.0 13.0   0.0     7.0     13.0   60.0 71.0             *     21   131 96 2 13   0     7     13   60 71             21   131
1091569 NY Oswego   school 3613590 460701040000   HANNIBAL 361359001112 460701040003 FAIRLEY SCHOOL public Regular School No 1.0 PK 04 2016   grade_2 96.0 0.0 2.0   0.0     0.0     0.0   52.0 46.0             70     10   98 96 0 2   0     0     0   52 46         70   10   98
1112374 NY Suffolk   school 3627060 580801060000   SMITHTOWN 362706003689 580801060007 ST JAMES ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 96.0 1.0 12.0         6.0     2.0   61.0 56.0             20     24   117 96 1 12         6     2   61 56         20   24   117
1463741 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102679 332000010200 PS 200 BENSON SCHOOL public Regular School No Elementary PK 05 2021   grade_2 96.0 1.0 61.0   0.0     73.0     0.0   111.0 120.0     63       200     41   231 96 1 61   0     73     0   111 120     63   200   41   231
1488517 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2021   grade_2 96.0 1.0 9.0   0.0     1.0     12.0   56.0 63.0     7       31     8   119 96 1 9   0     1     12   56 63     7   31   8   119
1572193 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802335 310300010087 PS 87 WILLIAM SHERMAN public Regular School No Elementary PK 05 2020   grade_2 96.0 1.0 21.0   0.0     16.0     5.0   71.0 68.0     *       *     30   139 96 1 21   0     16     5   71 68             30   139
2117342 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001496 490601060008 TURNPIKE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2018   grade_2 96.0 30.0 21.0   0.0     4.0     16.0   87.0 80.0     *       133     25   167 96 30 21   0     4     16   87 80         133   25   167
2118349 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302165 353100010036 PS 36 J C DRUMGOOLE public Regular School No Elementary PK 05 2018   grade_2 96.0 0.0 18.0   1.0     8.0     0.0   52.0 71.0     *       43     30   123 96 0 18   1     8     0   52 71         43   30   123
2151295 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000872 61101040009 PAUL B D TEMPLE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   grade_2 96.0 1.0 4.0               0.0   49.0 52.0             58     13   101 96 1 4               0   49 52         58   13   101
2169573 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102679 332000010200 PS 200 BENSON SCHOOL public Regular School No Elementary PK 05 2019   grade_2 96.0 1.0 58.0   3.0     71.0     1.0   117.0 113.0     52       188     *   230 96 1 58   3     71     1   117 113     52   188       230
2192069 NY Niagara   school 3621240 400900010000   NORTH TONAWANDA 362124003014 400900010008 OHIO ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 96.0 1.0 3.0         2.0     3.0   46.0 59.0     8       40     10   105 96 1 3         2     3   46 59     8   40   10   105
2219828 NY Suffolk   school 3600125 580912060000   ESTPRT-S MANOR CSD 360012506504 580912060005 TUTTLE AVENUE SCHOOL public Regular School No Elementary KG 02 2019   grade_2 96.0   11.0         1.0     2.0   43.0 67.0     *       17     10   110 96   11         1     2   43 67         17   10   110
764507 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000496 141501060003 KAEGEBEIN SCHOOL public Regular School No 1 02 5 2015   grade_2 95.0 2.0 3.0         3.0     3.0   62.0 44.0             34     11   106 95 2 3         3     3   62 44         34   11   106

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