Data source: Big Local News · About: Big Local

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

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
759377 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
987031 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_2 2.0 9.0 19.0         4.0     0.0   25.0 9.0     *       26     34   34 2 9 19         4     0   25 9         26   34   34
1043670 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1047584 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1456654 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_2 0.0 40.0 0.0   0.0     0.0     0.0   21.0 19.0     0       33     6   40 0 40 0   0     0     0   21 19     0   33   6   40
1555986 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2067904 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2106341 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_2 3.0 28.0 7.0         3.0     4.0   22.0 23.0     *       39     *   45 3 28 7         3     4   22 23         39       45
760935 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No 1.0 01 05 2015   grade_2 5.0 31.0 22.0         0.0     5.0   35.0 28.0             *     *   63 5 31 22         0     5   35 28                 63
764659 NY Erie   school 3613350 141601060000   HAMBURG 361335001098 141601060006 HAMBURG MIDDLE SCHOOL public Regular School No 1 01 8 2015   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
767319 NY Greene   school 3606720 190401060000   CATSKILL 360672000459 190401060003 CATSKILL SENIOR HIGH SCHOOL public Regular School No 4 01 12 2015   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
782937 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003415 261600010044 SCHOOL 44-LINCOLN PARK public Regular School No 1 01 06 2015   grade_2 3.0 37.0 2.0   0.0     1.0     0.0   20.0 23.0             40     11   43 3 37 2   0     1     0   20 23         40   11   43
783830 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_2 222.0 6.0 15.0         4.0     16.0   132.0 131.0             *     *   263 222 6 15         4     16   132 131                 263
784514 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_2 5.0 54.0 109.0   1.0     1.0     0.0   95.0 75.0             129     30   170 5 54 109   1     1     0   95 75         129   30   170
784533 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_2 10.0 41.0 66.0   0.0     0.0     0.0   58.0 59.0             96     7   117 10 41 66   0     0     0   58 59         96   7   117
784552 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 4.0 19.0 51.0   0.0           2.0   41.0 35.0             62     5   76 4 19 51   0           2   41 35         62   5   76
784571 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_2 3.0 12.0 76.0   0.0     1.0         46.0 46.0             67     *   92 3 12 76   0     1         46 46         67       92
784628 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_2 8.0 9.0 75.0   1.0     1.0         54.0 40.0             87     6   94 8 9 75   1     1         54 40         87   6   94
784666 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 5.0 17.0 59.0   2.0     0.0     0.0   50.0 33.0             67     6   83 5 17 59   2     0     0   50 33         67   6   83
785882 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No 1 01 06 2015   grade_2 43.0 0.0 16.0         0.0     1.0   32.0 28.0             14     *   60 43 0 16         0     1   32 28         14       60
785901 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No 1 01 06 2015   grade_2 53.0 1.0 10.0         2.0     1.0   38.0 29.0             9     *   67 53 1 10         2     1   38 29         9       67
785920 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No 1 01 06 2015   grade_2 37.0 1.0 12.0         6.0     3.0   28.0 31.0             *     6   59 37 1 12         6     3   28 31             6   59
785939 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No 1 01 06 2015   grade_2 59.0 2.0 23.0   0.0     2.0     4.0   47.0 43.0             25     18   90 59 2 23   0     2     4   47 43         25   18   90
785958 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No 1 01 06 2015   grade_2 45.0 1.0 3.0         2.0     0.0   25.0 26.0             *     *   51 45 1 3         2     0   25 26                 51
785977 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No 1 01 06 2015   grade_2 66.0 2.0 14.0   0.0     2.0     1.0   41.0 44.0             9     7   85 66 2 14   0     2     1   41 44         9   7   85
786186 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No 1 01 06 2015   grade_2 14.0 20.0 29.0   0.0     14.0     3.0   34.0 46.0             20     *   80 14 20 29   0     14     3   34 46         20       80
786319 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 2 SCHOOL public Regular School No 1 01 04 2015   grade_2 14.0 25.0 59.0   5.0     2.0     1.0   58.0 48.0             95     13   106 14 25 59   5     2     1   58 48         95   13   106
786357 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001502 280215030005 5 SCHOOL public Regular School No 1 01 04 2015   grade_2 18.0 16.0 41.0   0.0     7.0     0.0   42.0 40.0             *     15   82 18 16 41   0     7     0   42 40             15   82
786813 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No 1 01 05 2015   grade_2 45.0 0.0 5.0         1.0         24.0 27.0             6     *   51 45 0 5         1         24 27         6       51
786832 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No 1 01 05 2015   grade_2 52.0 1.0 17.0   2.0     1.0     3.0   42.0 34.0             12     8   76 52 1 17   2     1     3   42 34         12   8   76
787364 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No 1 01 05 2015   grade_2 17.0 15.0 21.0         5.0     1.0   28.0 31.0             23     7   59 17 15 21         5     1   28 31         23   7   59
787440 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No 1 01 05 2015   grade_2 19.0 10.0 24.0   2.0     3.0     3.0   31.0 30.0             38     10   61 19 10 24   2     3     3   31 30         38   10   61
787991 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No 1 01 02 2015   grade_2 8.0 90.0 344.0         2.0     1.0   235.0 210.0             420     40   445 8 90 344         2     1   235 210         420   40   445
788200 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No 1 01 05 2015   grade_2 77.0 1.0 3.0         10.0         42.0 49.0             *     *   91 77 1 3         10         42 49                 91
789340 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322004381 280504060001 PASADENA ELEMENTARY SCHOOL public Regular School No 1 01 04 2015   grade_2 55.0 1.0 3.0         21.0     1.0   45.0 36.0             5     9   81 55 1 3         21     1   45 36         5   9   81
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
789416 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003253 280504060012 OLD BETHPAGE SCHOOL public Regular School No 1 01 04 2015   grade_2 74.0 0.0 4.0         15.0     2.0   46.0 49.0             *     12   95 74 0 4         15     2   46 49             12   95
789454 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322000508 280504060015 STRATFORD ROAD SCHOOL public Regular School No 1 01 04 2015   grade_2 78.0   8.0         28.0     1.0   62.0 53.0             10     12   115 78   8         28     1   62 53         10   12   115
796256 NY New York   school 3600142 310400861061   NY CTR FOR AUTISM CHARTER SC 360014205779 310400861061 NY CENTER FOR AUTISM CHARTER SCHOOL charter Special Education School Yes 1 01 01 2015   grade_2 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
802431 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003852 421800010041 DELAWARE ACADEMY public Regular School No 1 01 05 2015   grade_2 5.0 29.0 33.0   1.0     0.0     11.0   37.0 42.0             70     19   79 5 29 33   1     0     11   37 42         70   19   79
803305 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 57.0 8.0 20.0         1.0     4.0   53.0 37.0             25     10   90 57 8 20         1     4   53 37         25   10   90
816092 NY Rockland   school 3621480 500304030000   NYACK 362148003049 500304030007 NYACK MIDDLE SCHOOL public Regular School No 1 01 08 2015   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
816358 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003771 500402060002 GRANDVIEW ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_2 9.0 38.0 102.0   1.0     1.0     1.0   75.0 77.0             140     34   152 9 38 102   1     1     1   75 77         140   34   152
816415 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_2 13.0 51.0 120.0         8.0     1.0   94.0 99.0             181     29   193 13 51 120         8     1   94 99         181   29   193
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
818923 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003581 530600010018 JESSIE T ZOLLER SCHOOL public Regular School No 1 01 08 2015   grade_2 23.0 9.0 11.0         5.0     9.0   30.0 27.0             40     9   57 23 9 11         5     9   30 27         40   9   57
819037 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601005996 530600010031 FRANKLIN D ROOSEVELT ELEMENTARY SCH public Regular School No 1 01 06 2015   grade_2 13.0 14.0 7.0         4.0     3.0   20.0 21.0             38     16   41 13 14 7         4     3   20 21         38   16   41
820880 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_2 17.0 80.0 148.0   2.0     1.0     7.0   129.0 126.0             206     22   255 17 80 148   2     1     7   129 126         206   22   255
822001 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No 1 01 05 2015   grade_2 32.0 1.0 6.0         1.0     3.0   24.0 19.0             19     10   43 32 1 6         1     3   24 19         19   10   43
822020 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No 1 01 05 2015   grade_2 58.0 0.0 12.0         5.0     3.0   37.0 41.0             21     21   78 58 0 12         5     3   37 41         21   21   78
822039 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No 1 01 05 2015   grade_2 52.0 1.0 18.0         7.0     2.0   42.0 38.0             24     13   80 52 1 18         7     2   42 38         24   13   80
822058 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No 1 01 05 2015   grade_2 42.0 3.0 30.0         2.0     1.0   34.0 44.0             34     6   78 42 3 30         2     1   34 44         34   6   78
822096 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No 1 01 05 2015   grade_2 56.0 3.0 11.0         4.0     0.0   40.0 34.0             16     11   74 56 3 11         4     0   40 34         16   11   74
822191 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 71.0 2.0 13.0         4.0     4.0   45.0 49.0             38     18   94 71 2 13         4     4   45 49         38   18   94
822229 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No 1 01 06 2015   grade_2 115.0 2.0 35.0         11.0     9.0   78.0 94.0             *     *   172 115 2 35         11     9   78 94                 172
825155 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000250 580512030003 HEMLOCK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 5.0 20.0 88.0   0.0     5.0     1.0   62.0 57.0             98     18   119 5 20 88   0     5     1   62 57         98   18   119
825174 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 6.0 6.0 137.0   1.0     1.0         80.0 71.0             143     37   151 6 6 137   1     1         80 71         143   37   151
825193 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 3.0 15.0 112.0         4.0     0.0   77.0 57.0             120     11   134 3 15 112         4     0   77 57         120   11   134
825212 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 4.0 21.0 158.0   1.0     4.0     2.0   101.0 89.0             175     26   190 4 21 158   1     4     2   101 89         175   26   190
825231 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 5.0 18.0 185.0   0.0     2.0     3.0   116.0 97.0             202     13   213 5 18 185   0     2     3   116 97         202   13   213
825250 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000256 580512030009 OAK PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 4.0 21.0 122.0   0.0     4.0     0.0   77.0 74.0             133     8   151 4 21 122   0     4     0   77 74         133   8   151
825288 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 3.0 12.0 128.0   0.0     2.0     1.0   67.0 79.0             130     7   146 3 12 128   0     2     1   67 79         130   7   146
825307 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 3.0 12.0 168.0   1.0     1.0     1.0   85.0 101.0             172     14   186 3 12 168   1     1     1   85 101         172   14   186
825440 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687004253 580513030001 CORDELLO AVENUE ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 1.0 21.0 116.0         2.0         70.0 70.0             116     7   140 1 21 116         2         70 70         116   7   140
825459 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000476 580513030002 FRANCIS J O'NEILL SCHOOL public Regular School No 1 01 05 2015   grade_2 7.0 22.0 114.0         2.0     1.0   79.0 67.0             114     15   146 7 22 114         2     1   79 67         114   15   146
825478 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000477 580513030003 MARGUERITE L MULVEY SCHOOL public Regular School No 1 01 05 2015   grade_2 7.0 27.0 103.0         0.0     0.0   74.0 63.0             118     9   137 7 27 103         0     0   74 63         118   9   137
825535 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No 1 01 05 2015   grade_2 5.0 31.0 116.0   0.0     7.0     2.0   80.0 81.0             129     18   161 5 31 116   0     7     2   80 81         129   18   161
826390 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No 1 01 08 2015   grade_2 0.0 0.0 1.0   0.0     0.0         1.0 0.0             0     *   1 0 0 1   0     0         1 0         0       1
826447 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No 1 01 04 2015   grade_2 1.0 0.0 0.0                   0.0 1.0                       1 1 0 0                   0 1                 1
831026 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No 1 01 02 2015   grade_2 56.0 7.0 134.0   0.0     3.0     7.0   98.0 109.0             *     *   207 56 7 134   0     3     7   98 109                 207
832166 NY Westchester   school 3608470 660804020000   MT PLEASANT-COTTAG 360847000653 660804020003 EDENWALD SCHOOL public Special Education School No 4 01 12 2015   grade_2 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
833078 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No 1 01 02 2015   grade_2 87.0 32.0 217.0         23.0     22.0   194.0 187.0             236     21   381 87 32 217         23     22   194 187         236   21   381
962426 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_2 64.0 4.0 7.0   0.0     0.0     3.0   35.0 43.0             46     12   78 64 4 7   0     0     3   35 43         46   12   78
972097 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
982319 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_2 48.0 2.0 11.0         3.0     2.0   34.0 32.0     6       13     *   66 48 2 11         3     2   34 32     6   13       66
982338 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_2 65.0 3.0 25.0         3.0     2.0   49.0 49.0     *       11     11   98 65 3 25         3     2   49 49         11   11   98
982357 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2017   grade_2 32.0 2.0 5.0         3.0     1.0   23.0 20.0     *       7     *   43 32 2 5         3     1   23 20         7       43
982376 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2017   grade_2 56.0 2.0 34.0         2.0     4.0   57.0 41.0     16       22     12   98 56 2 34         2     4   57 41     16   22   12   98
982395 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2017   grade_2 25.0 0.0 3.0         4.0     1.0   19.0 14.0     0       *     *   33 25 0 3         4     1   19 14     0           33
982414 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2017   grade_2 47.0 0.0 10.0   0.0     3.0     2.0   33.0 29.0     *       7     12   62 47 0 10   0     3     2   33 29         7   12   62
982623 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2017   grade_2 20.0 18.0 45.0   2.0     16.0     8.0   58.0 51.0     7       30     15   109 20 18 45   2     16     8   58 51     7   30   15   109
982756 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No Elementary 01 02 2017   grade_2 24.0 39.0 134.0   4.0     9.0     2.0   110.0 102.0     60       189     29   212 24 39 134   4     9     2   110 102     60   189   29   212
983231 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No Elementary 01 05 2017   grade_2 65.0 7.0 13.0   1.0     4.0     3.0   51.0 42.0     *       12     16   93 65 7 13   1     4     3   51 42         12   16   93
983250 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2017   grade_2 23.0 3.0 3.0         0.0     0.0   14.0 15.0             *     *   29 23 3 3         0     0   14 15                 29
983269 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2017   grade_2 38.0 5.0 19.0   1.0     3.0     3.0   33.0 36.0     5       13     7   69 38 5 19   1     3     3   33 36     5   13   7   69
983801 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_2 20.0 12.0 24.0   0.0     5.0     6.0   41.0 26.0     7       39     14   67 20 12 24   0     5     6   41 26     7   39   14   67
983877 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No Elementary 01 05 2017   grade_2 18.0 9.0 28.0   0.0     4.0     4.0   39.0 24.0     17       38     10   63 18 9 28   0     4     4   39 24     17   38   10   63
984428 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_2 0.0 52.0 148.0         1.0         108.0 93.0     106       184     18   201 0 52 148         1         108 93     106   184   18   201
984447 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_2 4.0 6.0 108.0   0.0     2.0     0.0   64.0 56.0     63       110     7   120 4 6 108   0     2     0   64 56     63   110   7   120
984485 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2017   grade_2 4.0 17.0 73.0   1.0     4.0     0.0   56.0 43.0     50       81     7   99 4 17 73   1     4     0   56 43     50   81   7   99
984637 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No Elementary 01 05 2017   grade_2 75.0 2.0 4.0         13.0     1.0   37.0 58.0     *       7     8   95 75 2 4         13     1   37 58         7   8   95
992541 NY New York   school 3600142 310400861061   NY CTR FOR AUTISM CHARTER SC 360014205779 310400861061 NY CENTER FOR AUTISM CHARTER SCHOOL charter Special Education School Yes Elementary 01 03 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
999590 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 54.0 6.0 23.0         3.0     4.0   40.0 50.0             17     10   90 54 6 23         3     4   40 50         17   10   90
1015512 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000566 541102060002 COBLESKILL-RICHMONDVILLE HIGH SCHOOL public Regular School No Other 01 12 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1015531 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000277 541102060004 WILLIAM H GOLDING MIDDLE SCHOOL public Regular School No Elementary 01 08 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1017222 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2017   grade_2 5.0 75.0 127.0   1.0     4.0     7.0   113.0 106.0     57       195     26   219 5 75 127   1     4     7   113 106     57   195   26   219
1018286 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No Elementary 01 05 2017   grade_2 35.0 2.0 9.0         0.0     2.0   21.0 27.0             16     *   48 35 2 9         0     2   21 27         16       48
1018305 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_2 51.0 1.0 13.0         2.0     3.0   38.0 32.0             21     15   70 51 1 13         2     3   38 32         21   15   70
1018324 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_2 47.0 1.0 16.0         1.0     4.0   35.0 34.0     *       28     8   69 47 1 16         1     4   35 34         28   8   69
1018343 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_2 38.0 2.0 21.0         3.0     0.0   33.0 31.0     10       *     12   64 38 2 21         3     0   33 31     10       12   64

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