Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_3 · 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
759378 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   grade_3 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
987032 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_3 0.0 2.0 5.0         0.0     0.0   7.0 0.0     *       5     7   7 0 2 5         0     0   7 0         5   7   7
1043671 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_3 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
1047585 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   grade_3 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
1456655 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_3 4.0 48.0 3.0   2.0     0.0     1.0   24.0 34.0     *       44     13   58 4 48 3   2     0     1   24 34         44   13   58
1555987 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   grade_3 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
2067905 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_3 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
2106342 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_3 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
760936 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No 1.0 01 05 2015   grade_3 3.0 42.0 20.0         0.0     3.0   35.0 33.0             60     *   68 3 42 20         0     3   35 33         60       68
764660 NY Erie   school 3613350 141601060000   HAMBURG 361335001098 141601060006 HAMBURG MIDDLE SCHOOL public Regular School No 1 01 8 2015   grade_3 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
767320 NY Greene   school 3606720 190401060000   CATSKILL 360672000459 190401060003 CATSKILL SENIOR HIGH SCHOOL public Regular School No 4 01 12 2015   grade_3 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
782938 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003415 261600010044 SCHOOL 44-LINCOLN PARK public Regular School No 1 01 06 2015   grade_3 3.0 32.0 3.0   0.0     1.0     0.0   15.0 24.0             37     *   39 3 32 3   0     1     0   15 24         37       39
783831 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_3 194.0 4.0 22.0         5.0     11.0   112.0 124.0             120     32   236 194 4 22         5     11   112 124         120   32   236
784515 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_3 2.0 49.0 91.0   0.0     0.0     1.0   81.0 62.0             120     12   143 2 49 91   0     0     1   81 62         120   12   143
784534 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_3 5.0 39.0 63.0   2.0     2.0     1.0   52.0 60.0             95     13   112 5 39 63   2     2     1   52 60         95   13   112
784553 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 6.0 25.0 63.0   0.0           2.0   59.0 37.0             61     7   96 6 25 63   0           2   59 37         61   7   96
784572 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_3 5.0 17.0 62.0   1.0     0.0         36.0 49.0             67     *   85 5 17 62   1     0         36 49         67       85
784629 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_3 2.0 18.0 58.0   0.0     0.0         37.0 41.0             65     15   78 2 18 58   0     0         37 41         65   15   78
784667 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 3.0 18.0 54.0   1.0     1.0     0.0   46.0 31.0             64     15   77 3 18 54   1     1     0   46 31         64   15   77
785883 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No 1 01 06 2015   grade_3 63.0 1.0 13.0         0.0     4.0   48.0 33.0             13     18   81 63 1 13         0     4   48 33         13   18   81
785902 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No 1 01 06 2015   grade_3 76.0 0.0 11.0         4.0     0.0   49.0 42.0             10     *   91 76 0 11         4     0   49 42         10       91
785921 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No 1 01 06 2015   grade_3 38.0 1.0 8.0         2.0     1.0   28.0 22.0             12     6   50 38 1 8         2     1   28 22         12   6   50
785940 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No 1 01 06 2015   grade_3 45.0 2.0 21.0   0.0     2.0     6.0   38.0 38.0             22     6   76 45 2 21   0     2     6   38 38         22   6   76
785959 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No 1 01 06 2015   grade_3 40.0 0.0 7.0         2.0     0.0   25.0 24.0             *     *   49 40 0 7         2     0   25 24                 49
785978 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No 1 01 06 2015   grade_3 50.0 0.0 8.0   0.0     2.0     1.0   29.0 32.0             9     13   61 50 0 8   0     2     1   29 32         9   13   61
786187 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No 1 01 06 2015   grade_3 22.0 28.0 37.0   0.0     17.0     9.0   56.0 57.0             31     14   113 22 28 37   0     17     9   56 57         31   14   113
786320 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 2 SCHOOL public Regular School No 1 01 04 2015   grade_3 18.0 21.0 65.0   0.0     1.0     4.0   60.0 49.0             91     21   109 18 21 65   0     1     4   60 49         91   21   109
786358 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001502 280215030005 5 SCHOOL public Regular School No 1 01 04 2015   grade_3 18.0 12.0 45.0   0.0     8.0     0.0   39.0 44.0             64     13   83 18 12 45   0     8     0   39 44         64   13   83
786814 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No 1 01 05 2015   grade_3 30.0 0.0 4.0         1.0         17.0 18.0             *     *   35 30 0 4         1         17 18                 35
786833 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No 1 01 05 2015   grade_3 49.0 2.0 21.0   3.0     3.0     2.0   37.0 43.0             15     *   80 49 2 21   3     3     2   37 43         15       80
787365 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No 1 01 05 2015   grade_3 8.0 11.0 32.0         4.0     4.0   36.0 23.0             35     13   59 8 11 32         4     4   36 23         35   13   59
787441 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No 1 01 05 2015   grade_3 22.0 7.0 36.0   0.0     6.0     3.0   43.0 31.0             36     11   74 22 7 36   0     6     3   43 31         36   11   74
787992 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No 1 01 02 2015   grade_3 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
788201 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No 1 01 05 2015   grade_3 93.0 2.0 0.0         10.0         53.0 52.0             7     11   105 93 2 0         10         53 52         7   11   105
789341 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322004381 280504060001 PASADENA ELEMENTARY SCHOOL public Regular School No 1 01 04 2015   grade_3 71.0 1.0 4.0         15.0     4.0   44.0 51.0             5     14   95 71 1 4         15     4   44 51         5   14   95
789360 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003254 280504060004 PARKWAY SCHOOL public Regular School No 1 01 04 2015   grade_3 68.0 0.0 4.0         18.0     1.0   57.0 34.0             *     *   91 68 0 4         18     1   57 34                 91
789417 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322003253 280504060012 OLD BETHPAGE SCHOOL public Regular School No 1 01 04 2015   grade_3 55.0 0.0 3.0         11.0     1.0   33.0 37.0             *     10   70 55 0 3         11     1   33 37             10   70
789455 NY Nassau   school 3623220 280504060000   PLAINVIEW 362322000508 280504060015 STRATFORD ROAD SCHOOL public Regular School No 1 01 04 2015   grade_3 55.0   5.0         17.0     3.0   47.0 33.0             10     11   80 55   5         17     3   47 33         10   11   80
796257 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_3 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
802432 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003852 421800010041 DELAWARE ACADEMY public Regular School No 1 01 05 2015   grade_3 8.0 24.0 39.0   0.0     1.0     6.0   42.0 36.0             74     23   78 8 24 39   0     1     6   42 36         74   23   78
803306 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 68.0 9.0 11.0         4.0     4.0   50.0 46.0             23     10   96 68 9 11         4     4   50 46         23   10   96
816093 NY Rockland   school 3621480 500304030000   NYACK 362148003049 500304030007 NYACK MIDDLE SCHOOL public Regular School No 1 01 08 2015   grade_3 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
816359 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003771 500402060002 GRANDVIEW ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_3 8.0 38.0 99.0   0.0     7.0     2.0   78.0 76.0             138     58   154 8 38 99   0     7     2   78 76         138   58   154
816416 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_3 6.0 42.0 116.0         6.0     0.0   91.0 79.0             158     61   170 6 42 116         6     0   91 79         158   61   170
818753 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003575 530600010003 ELMER AVENUE SCHOOL public Regular School No 1 01 06 2015   grade_3 8.0 17.0 8.0         2.0     2.0   17.0 20.0             36     0   37 8 17 8         2     2   17 20         36   0   37
818924 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003581 530600010018 JESSIE T ZOLLER SCHOOL public Regular School No 1 01 08 2015   grade_3 21.0 10.0 8.0         10.0     2.0   27.0 24.0             34     9   51 21 10 8         10     2   27 24         34   9   51
819038 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601005996 530600010031 FRANKLIN D ROOSEVELT ELEMENTARY SCH public Regular School No 1 01 06 2015   grade_3 7.0 8.0 3.0         3.0     1.0   12.0 10.0             21     6   22 7 8 3         3     1   12 10         21   6   22
820881 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_3 20.0 93.0 108.0   1.0     0.0     10.0   134.0 98.0             *     24   232 20 93 108   1     0     10   134 98             24   232
822002 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No 1 01 05 2015   grade_3 39.0 3.0 7.0         3.0     0.0   26.0 26.0             19     *   52 39 3 7         3     0   26 26         19       52
822021 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No 1 01 05 2015   grade_3 45.0 1.0 9.0         2.0     0.0   26.0 31.0             15     15   57 45 1 9         2     0   26 31         15   15   57
822040 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No 1 01 05 2015   grade_3 38.0 3.0 11.0         4.0     0.0   27.0 29.0             21     *   56 38 3 11         4     0   27 29         21       56
822059 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No 1 01 05 2015   grade_3 71.0 3.0 16.0         2.0     1.0   43.0 50.0             34     19   93 71 3 16         2     1   43 50         34   19   93
822097 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No 1 01 05 2015   grade_3 57.0 1.0 7.0         8.0     0.0   39.0 34.0             19     8   73 57 1 7         8     0   39 34         19   8   73
822192 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 55.0 3.0 10.0         6.0     1.0   35.0 40.0             20     *   75 55 3 10         6     1   35 40         20       75
822230 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No 1 01 06 2015   grade_3 124.0 8.0 27.0         16.0     3.0   93.0 85.0             77     24   178 124 8 27         16     3   93 85         77   24   178
825156 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000250 580512030003 HEMLOCK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 8.0 19.0 93.0   0.0     4.0     0.0   68.0 56.0             114     30   124 8 19 93   0     4     0   68 56         114   30   124
825175 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 1.0 10.0 108.0   0.0     2.0         64.0 57.0             109     18   121 1 10 108   0     2         64 57         109   18   121
825194 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 8.0 19.0 154.0         4.0     0.0   100.0 85.0             166     30   185 8 19 154         4     0   100 85         166   30   185
825213 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 8.0 11.0 139.0   0.0     4.0     0.0   93.0 69.0             150     15   162 8 11 139   0     4     0   93 69         150   15   162
825232 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 8.0 19.0 193.0   0.0     4.0     0.0   117.0 107.0             206     11   224 8 19 193   0     4     0   117 107         206   11   224
825251 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000256 580512030009 OAK PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 7.0 21.0 139.0   0.0     7.0     1.0   87.0 88.0             165     22   175 7 21 139   0     7     1   87 88         165   22   175
825289 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 5.0 15.0 128.0   0.0     2.0     0.0   78.0 72.0             135     9   150 5 15 128   0     2     0   78 72         135   9   150
825308 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 5.0 13.0 180.0   1.0     2.0     0.0   108.0 93.0             185     22   201 5 13 180   1     2     0   108 93         185   22   201
825441 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687004253 580513030001 CORDELLO AVENUE ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 17.0 26.0 85.0         1.0         71.0 58.0             109     6   129 17 26 85         1         71 58         109   6   129
825460 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000476 580513030002 FRANCIS J O'NEILL SCHOOL public Regular School No 1 01 05 2015   grade_3 27.0 24.0 107.0         6.0     0.0   87.0 77.0             130     26   164 27 24 107         6     0   87 77         130   26   164
825479 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000477 580513030003 MARGUERITE L MULVEY SCHOOL public Regular School No 1 01 05 2015   grade_3 20.0 14.0 102.0         2.0     1.0   70.0 69.0             124     20   139 20 14 102         2     1   70 69         124   20   139
825536 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No 1 01 05 2015   grade_3 24.0 32.0 78.0   1.0     0.0     0.0   67.0 68.0             101     17   135 24 32 78   1     0     0   67 68         101   17   135
826391 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No 1 01 08 2015   grade_3 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
826448 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No 1 01 04 2015   grade_3 4.0 1.0 0.0                   4.0 1.0                       5 4 1 0                   4 1                 5
831027 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No 1 01 02 2015   grade_3 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
832167 NY Westchester   school 3608470 660804020000   MT PLEASANT-COTTAG 360847000653 660804020003 EDENWALD SCHOOL public Special Education School No 4 01 12 2015   grade_3 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
833079 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No 1 01 02 2015   grade_3 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
962427 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_3 70.0 3.0 3.0   0.0     1.0     6.0   44.0 39.0             57     11   83 70 3 3   0     1     6   44 39         57   11   83
972098 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_3 0.0 1.0 0.0   0.0     0.0         0.0 1.0     0       0     0   1 0 1 0   0     0         0 1     0   0   0   1
982320 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_3 41.0 1.0 19.0         5.0     2.0   31.0 37.0     13       16     *   68 41 1 19         5     2   31 37     13   16       68
982339 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_3 84.0 3.0 13.0         3.0     5.0   65.0 43.0     *       16     19   108 84 3 13         3     5   65 43         16   19   108
982358 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2017   grade_3 37.0 2.0 7.0         0.0     3.0   28.0 21.0     *       12     7   49 37 2 7         0     3   28 21         12   7   49
982377 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2017   grade_3 56.0 0.0 23.0         6.0     2.0   38.0 49.0     8       11     *   87 56 0 23         6     2   38 49     8   11       87
982396 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2017   grade_3 47.0 0.0 3.0         1.0     3.0   22.0 32.0     *       *     *   54 47 0 3         1     3   22 32                 54
982415 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2017   grade_3 41.0 0.0 13.0   1.0     2.0     1.0   29.0 29.0     *       7     *   58 41 0 13   1     2     1   29 29         7       58
982624 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2017   grade_3 18.0 26.0 36.0   1.0     19.0     0.0   54.0 46.0     8       45     13   100 18 26 36   1     19     0   54 46     8   45   13   100
982757 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No Elementary 01 02 2017   grade_3 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
983232 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No Elementary 01 05 2017   grade_3 53.0 2.0 16.0   0.0     7.0     1.0   47.0 32.0     *       *     *   79 53 2 16   0     7     1   47 32                 79
983251 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2017   grade_3 27.0 1.0 7.0         2.0     0.0   22.0 15.0             *     *   37 27 1 7         2     0   22 15                 37
983270 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2017   grade_3 57.0 1.0 15.0   0.0     5.0     3.0   42.0 39.0     *       19     8   81 57 1 15   0     5     3   42 39         19   8   81
983802 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_3 11.0 18.0 24.0   0.0     6.0     4.0   34.0 29.0     *       30     12   63 11 18 24   0     6     4   34 29         30   12   63
983878 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No Elementary 01 05 2017   grade_3 28.0 13.0 36.0   0.0     7.0     4.0   40.0 48.0     17       46     14   88 28 13 36   0     7     4   40 48     17   46   14   88
984429 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_3 1.0 52.0 152.0         0.0         104.0 101.0     100       192     18   205 1 52 152         0         104 101     100   192   18   205
984448 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_3 3.0 12.0 98.0   0.0     4.0     1.0   59.0 59.0     40       98     8   118 3 12 98   0     4     1   59 59     40   98   8   118
984486 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2017   grade_3 4.0 26.0 73.0   0.0     3.0     1.0   48.0 59.0     42       82     *   107 4 26 73   0     3     1   48 59     42   82       107
984638 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No Elementary 01 05 2017   grade_3 70.0 2.0 6.0         15.0     0.0   47.0 46.0     *       *     6   93 70 2 6         15     0   47 46             6   93
992542 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_3 0.0 0.0 1.0         0.0     0.0   1.0 0.0     *       *     *   1 0 0 1         0     0   1 0                 1
999591 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_3 52.0 8.0 17.0         2.0     6.0   41.0 44.0             20     *   85 52 8 17         2     6   41 44         20       85
1015513 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000566 541102060002 COBLESKILL-RICHMONDVILLE HIGH SCHOOL public Regular School No Other 01 12 2017   grade_3 1.0 0.0 0.0         0.0     0.0   0.0 1.0     *       *     *   1 1 0 0         0     0   0 1                 1
1015532 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000277 541102060004 WILLIAM H GOLDING MIDDLE SCHOOL public Regular School No Elementary 01 08 2017   grade_3 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
1017223 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2017   grade_3 6.0 98.0 125.0   1.0     2.0     7.0   132.0 107.0     65       202     20   239 6 98 125   1     2     7   132 107     65   202   20   239
1018287 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No Elementary 01 05 2017   grade_3 46.0 5.0 20.0         5.0     2.0   38.0 40.0             33     24   78 46 5 20         5     2   38 40         33   24   78
1018306 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_3 50.0 1.0 8.0         5.0     5.0   37.0 32.0             24     16   69 50 1 8         5     5   37 32         24   16   69
1018325 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_3 34.0 2.0 11.0         3.0     2.0   24.0 28.0     *       23     11   52 34 2 11         3     2   24 28         23   11   52
1018344 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_3 46.0 1.0 20.0         5.0     1.0   34.0 39.0     13       25     6   73 46 1 20         5     1   34 39     13   25   6   73

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