Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_4 · 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
759379 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   grade_4 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
987033 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_4 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
1043672 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_4 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
1047586 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   grade_4 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
1456656 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_4 0.0 55.0 6.0   1.0     2.0     0.0   36.0 28.0     *       52     15   64 0 55 6   1     2     0   36 28         52   15   64
1555988 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   grade_4 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
2067906 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_4 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
2106343 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_4 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
760937 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No 1.0 01 05 2015   grade_4 6.0 42.0 27.0         0.0     4.0   34.0 45.0             68     13   79 6 42 27         0     4   34 45         68   13   79
764661 NY Erie   school 3613350 141601060000   HAMBURG 361335001098 141601060006 HAMBURG MIDDLE SCHOOL public Regular School No 1 01 8 2015   grade_4 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0             0     *   1 0 0 1   0     0     0   1 0         0       1
767321 NY Greene   school 3606720 190401060000   CATSKILL 360672000459 190401060003 CATSKILL SENIOR HIGH SCHOOL public Regular School No 4 01 12 2015   grade_4 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
782939 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003415 261600010044 SCHOOL 44-LINCOLN PARK public Regular School No 1 01 06 2015   grade_4 1.0 30.0 0.0   1.0     2.0     0.0   17.0 17.0             *     *   34 1 30 0   1     2     0   17 17                 34
783832 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_4 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
784516 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_4 17.0 49.0 73.0   3.0     0.0     1.0   88.0 55.0             107     8   143 17 49 73   3     0     1   88 55         107   8   143
784535 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_4 7.0 34.0 43.0   0.0     2.0     0.0   39.0 47.0             79     *   86 7 34 43   0     2     0   39 47         79       86
784554 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 9.0 26.0 30.0   0.0           0.0   38.0 27.0             59     6   65 9 26 30   0           0   38 27         59   6   65
784573 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_4 16.0 27.0 64.0   0.0     1.0         52.0 56.0             92     22   108 16 27 64   0     1         52 56         92   22   108
784630 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_4 5.0 20.0 85.0   1.0     1.0         65.0 47.0             100     18   112 5 20 85   1     1         65 47         100   18   112
784668 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 3.0 10.0 52.0   0.0     0.0     0.0   31.0 34.0             49     *   65 3 10 52   0     0     0   31 34         49       65
785884 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No 1 01 06 2015   grade_4 48.0 0.0 1.0         1.0     0.0   29.0 21.0             5     6   50 48 0 1         1     0   29 21         5   6   50
785903 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No 1 01 06 2015   grade_4 51.0 4.0 7.0         2.0     3.0   34.0 33.0             16     8   67 51 4 7         2     3   34 33         16   8   67
785922 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No 1 01 06 2015   grade_4 35.0 0.0 6.0         2.0     3.0   24.0 22.0             9     *   46 35 0 6         2     3   24 22         9       46
785941 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No 1 01 06 2015   grade_4 65.0 1.0 22.0   0.0     5.0     1.0   61.0 33.0             13     25   94 65 1 22   0     5     1   61 33         13   25   94
785960 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No 1 01 06 2015   grade_4 50.0 0.0 5.0         0.0     2.0   32.0 25.0             *     6   57 50 0 5         0     2   32 25             6   57
785979 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No 1 01 06 2015   grade_4 57.0 0.0 9.0   0.0     0.0     3.0   38.0 31.0             12     *   69 57 0 9   0     0     3   38 31         12       69
786188 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No 1 01 06 2015   grade_4 18.0 26.0 27.0   1.0     17.0     0.0   45.0 44.0             26     *   89 18 26 27   1     17     0   45 44         26       89
786321 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 2 SCHOOL public Regular School No 1 01 04 2015   grade_4 19.0 28.0 50.0   0.0     3.0     3.0   52.0 51.0             84     15   103 19 28 50   0     3     3   52 51         84   15   103
786359 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001502 280215030005 5 SCHOOL public Regular School No 1 01 04 2015   grade_4 22.0 21.0 51.0   0.0     4.0     0.0   49.0 49.0             71     17   98 22 21 51   0     4     0   49 49         71   17   98
786815 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No 1 01 05 2015   grade_4 40.0 0.0 4.0         0.0         25.0 19.0             *     *   44 40 0 4         0         25 19                 44
786834 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No 1 01 05 2015   grade_4 56.0 1.0 19.0   0.0     6.0     1.0   47.0 36.0             12     *   83 56 1 19   0     6     1   47 36         12       83
787366 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No 1 01 05 2015   grade_4 13.0 23.0 18.0         8.0     2.0   39.0 25.0             31     9   64 13 23 18         8     2   39 25         31   9   64
787442 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No 1 01 05 2015   grade_4 25.0 9.0 28.0   0.0     1.0     6.0   29.0 40.0             31     *   69 25 9 28   0     1     6   29 40         31       69
787993 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No 1 01 02 2015   grade_4 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
788202 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No 1 01 05 2015   grade_4 83.0 1.0 6.0         13.0         50.0 53.0             10     14   103 83 1 6         13         50 53         10   14   103
789342 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322004381 280504060001 PASADENA ELEMENTARY SCHOOL public Regular School No 1 01 04 2015   grade_4 60.0 0.0 8.0         20.0     0.0   46.0 42.0             7     10   88 60 0 8         20     0   46 42         7   10   88
789361 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003254 280504060004 PARKWAY SCHOOL public Regular School No 1 01 04 2015   grade_4 67.0 0.0 5.0         16.0     1.0   39.0 50.0             *     9   89 67 0 5         16     1   39 50             9   89
789418 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003253 280504060012 OLD BETHPAGE SCHOOL public Regular School No 1 01 04 2015   grade_4 87.0 0.0 3.0         5.0     0.0   54.0 41.0             *     11   95 87 0 3         5     0   54 41             11   95
789456 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322000508 280504060015 STRATFORD ROAD SCHOOL public Regular School No 1 01 04 2015   grade_4 60.0   12.0         30.0     3.0   49.0 56.0             12     13   105 60   12         30     3   49 56         12   13   105
796258 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_4 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
802433 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003852 421800010041 DELAWARE ACADEMY public Regular School No 1 01 05 2015   grade_4 4.0 24.0 28.0   0.0     0.0     2.0   33.0 25.0             54     17   58 4 24 28   0     0     2   33 25         54   17   58
803307 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 75.0 5.0 18.0         2.0     2.0   47.0 55.0             30     *   102 75 5 18         2     2   47 55         30       102
816094 NY Rockland   school 3621480 500304030000   NYACK 362148003049 500304030007 NYACK MIDDLE SCHOOL public Regular School No 1 01 08 2015   grade_4 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
816360 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003771 500402060002 GRANDVIEW ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_4 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
816417 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_4 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
818754 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003575 530600010003 ELMER AVENUE SCHOOL public Regular School No 1 01 06 2015   grade_4 12.0 32.0 13.0         6.0     4.0   38.0 29.0             58     16   67 12 32 13         6     4   38 29         58   16   67
818925 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003581 530600010018 JESSIE T ZOLLER SCHOOL public Regular School No 1 01 08 2015   grade_4 26.0 19.0 14.0         7.0     1.0   39.0 28.0             51     20   67 26 19 14         7     1   39 28         51   20   67
819039 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601005996 530600010031 FRANKLIN D ROOSEVELT ELEMENTARY SCH public Regular School No 1 01 06 2015   grade_4 2.0 10.0 1.0         3.0     0.0   10.0 6.0             *     0   16 2 10 1         3     0   10 6             0   16
820882 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_4 1.0 0.0 0.0   0.0     0.0     1.0   2.0 0.0             *     0   2 1 0 0   0     0     1   2 0             0   2
822003 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No 1 01 05 2015   grade_4 45.0 3.0 16.0         3.0     1.0   39.0 29.0             20     13   68 45 3 16         3     1   39 29         20   13   68
822022 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No 1 01 05 2015   grade_4 64.0 4.0 8.0         3.0     1.0   43.0 37.0             31     19   80 64 4 8         3     1   43 37         31   19   80
822041 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No 1 01 05 2015   grade_4 45.0 0.0 13.0         9.0     1.0   41.0 27.0             24     14   68 45 0 13         9     1   41 27         24   14   68
822060 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No 1 01 05 2015   grade_4 55.0 3.0 15.0         4.0     1.0   38.0 40.0             34     15   78 55 3 15         4     1   38 40         34   15   78
822098 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No 1 01 05 2015   grade_4 55.0 1.0 9.0         1.0     0.0   42.0 24.0             16     5   66 55 1 9         1     0   42 24         16   5   66
822193 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 73.0 6.0 9.0         4.0     0.0   50.0 42.0             43     18   92 73 6 9         4     0   50 42         43   18   92
822231 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No 1 01 06 2015   grade_4 123.0 18.0 31.0         15.0     6.0   99.0 94.0             69     17   193 123 18 31         15     6   99 94         69   17   193
825157 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000250 580512030003 HEMLOCK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 8.0 17.0 93.0   0.0     2.0     1.0   68.0 53.0             109     20   121 8 17 93   0     2     1   68 53         109   20   121
825176 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 4.0 9.0 97.0   1.0     1.0         64.0 48.0             106     24   112 4 9 97   1     1         64 48         106   24   112
825195 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 4.0 11.0 115.0         2.0     0.0   62.0 70.0             121     20   132 4 11 115         2     0   62 70         121   20   132
825214 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 4.0 14.0 135.0   0.0     3.0     0.0   74.0 82.0             147     26   156 4 14 135   0     3     0   74 82         147   26   156
825233 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 13.0 16.0 166.0   0.0     5.0     1.0   100.0 101.0             184     21   201 13 16 166   0     5     1   100 101         184   21   201
825252 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000256 580512030009 OAK PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 5.0 19.0 128.0   0.0     4.0     1.0   80.0 77.0             143     33   157 5 19 128   0     4     1   80 77         143   33   157
825290 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 3.0 7.0 102.0   0.0     2.0     0.0   51.0 63.0             102     7   114 3 7 102   0     2     0   51 63         102   7   114
825309 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 6.0 19.0 158.0   0.0     3.0     1.0   93.0 94.0             176     9   187 6 19 158   0     3     1   93 94         176   9   187
825442 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687004253 580513030001 CORDELLO AVENUE ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 12.0 26.0 81.0         1.0         54.0 66.0             102     13   120 12 26 81         1         54 66         102   13   120
825461 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000476 580513030002 FRANCIS J O'NEILL SCHOOL public Regular School No 1 01 05 2015   grade_4 12.0 31.0 87.0         1.0     0.0   70.0 61.0             116     18   131 12 31 87         1     0   70 61         116   18   131
825480 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000477 580513030003 MARGUERITE L MULVEY SCHOOL public Regular School No 1 01 05 2015   grade_4 19.0 18.0 92.0         1.0     0.0   70.0 60.0             115     17   130 19 18 92         1     0   70 60         115   17   130
825537 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No 1 01 05 2015   grade_4 17.0 36.0 95.0   0.0     6.0     0.0   70.0 84.0             124     16   154 17 36 95   0     6     0   70 84         124   16   154
826392 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No 1 01 08 2015   grade_4 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
826449 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No 1 01 04 2015   grade_4 2.0 0.0 1.0                   1.0 2.0                       3 2 0 1                   1 2                 3
831028 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No 1 01 02 2015   grade_4 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
832168 NY Westchester   school 3608470 660804020000   MT PLEASANT-COTTAG 360847000653 660804020003 EDENWALD SCHOOL public Special Education School No 4 01 12 2015   grade_4 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
833080 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No 1 01 02 2015   grade_4 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
962428 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_4 53.0 1.0 1.0   1.0     1.0     2.0   31.0 28.0             36     10   59 53 1 1   1     1     2   31 28         36   10   59
972099 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_4 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
982321 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_4 44.0 0.0 13.0         0.0     1.0   30.0 28.0     *       13     *   58 44 0 13         0     1   30 28         13       58
982340 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_4 50.0 1.0 11.0         3.0     2.0   36.0 31.0     0       5     *   67 50 1 11         3     2   36 31     0   5       67
982359 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2017   grade_4 31.0 0.0 14.0         3.0     3.0   23.0 28.0     *       5     0   51 31 0 14         3     3   23 28         5   0   51
982378 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2017   grade_4 58.0 3.0 23.0         2.0     3.0   45.0 44.0     6       23     18   89 58 3 23         2     3   45 44     6   23   18   89
982397 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2017   grade_4 45.0 1.0 5.0         3.0     0.0   28.0 26.0     0       *     0   54 45 1 5         3     0   28 26     0       0   54
982416 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2017   grade_4 70.0 2.0 19.0   0.0     2.0     1.0   44.0 50.0     5       14     10   94 70 2 19   0     2     1   44 50     5   14   10   94
982625 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2017   grade_4 14.0 27.0 22.0   0.0     19.0     4.0   39.0 47.0     *       22     8   86 14 27 22   0     19     4   39 47         22   8   86
982758 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No Elementary 01 02 2017   grade_4 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   0   0
983233 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No Elementary 01 05 2017   grade_4 64.0 5.0 12.0   0.0     3.0     3.0   45.0 42.0     *       13     18   87 64 5 12   0     3     3   45 42         13   18   87
983252 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2017   grade_4 45.0 0.0 7.0         3.0     0.0   24.0 31.0             6     *   55 45 0 7         3     0   24 31         6       55
983271 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2017   grade_4 49.0 5.0 15.0   2.0     1.0     3.0   41.0 34.0     *       10     15   75 49 5 15   2     1     3   41 34         10   15   75
983803 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_4 19.0 15.0 27.0   0.0     5.0     1.0   29.0 38.0     *       27     11   67 19 15 27   0     5     1   29 38         27   11   67
983879 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No Elementary 01 05 2017   grade_4 19.0 6.0 25.0   2.0     3.0     3.0   29.0 29.0     *       37     13   58 19 6 25   2     3     3   29 29         37   13   58
984430 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_4 3.0 57.0 113.0         1.0         100.0 74.0     80       151     12   174 3 57 113         1         100 74     80   151   12   174
984449 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_4 3.0 7.0 117.0   0.0     1.0     1.0   70.0 59.0     46       117     19   129 3 7 117   0     1     1   70 59     46   117   19   129
984487 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2017   grade_4 0.0 29.0 84.0   0.0     0.0     0.0   54.0 59.0     43       95     6   113 0 29 84   0     0     0   54 59     43   95   6   113
984639 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No Elementary 01 05 2017   grade_4 82.0 1.0 3.0         13.0     1.0   43.0 57.0     *       *     9   100 82 1 3         13     1   43 57             9   100
992543 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_4 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
999592 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_4 58.0 8.0 22.0         2.0     3.0   50.0 43.0             23     10   93 58 8 22         2     3   50 43         23   10   93
1015514 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000566 541102060002 COBLESKILL-RICHMONDVILLE HIGH SCHOOL public Regular School No Other 01 12 2017   grade_4 2.0 0.0 0.0         0.0     0.0   2.0 0.0     *       *     *   2 2 0 0         0     0   2 0                 2
1015533 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000277 541102060004 WILLIAM H GOLDING MIDDLE SCHOOL public Regular School No Elementary 01 08 2017   grade_4 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
1017224 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2017   grade_4 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   0   0
1018288 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No Elementary 01 05 2017   grade_4 30.0 1.0 8.0         3.0     3.0   22.0 23.0             20     6   45 30 1 8         3     3   22 23         20   6   45
1018307 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_4 46.0 0.0 16.0         2.0     2.0   28.0 38.0             17     11   66 46 0 16         2     2   28 38         17   11   66
1018326 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_4 56.0 1.0 17.0         4.0     3.0   44.0 37.0     *       24     17   81 56 1 17         4     3   44 37         24   17   81
1018345 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_4 34.0 3.0 29.0         3.0     2.0   33.0 38.0     12       30     8   71 34 3 29         3     2   33 38     12   30   8   71

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