Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_2", state = "NY" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_2 · 4,719
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
2152302 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No Elementary 01 06 2019   grade_2 50.0 0.0 0.0         0.0     4.0   21.0 33.0             38     *   54 50 0 0         0     4   21 33         38       54
2154696 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Other 01 09 2019   grade_2 4.0 31.0 26.0   0.0     1.0     8.0   46.0 24.0     14       56     15   70 4 31 26   0     1     8   46 24     14   56   15   70
2154715 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 07 2019   grade_2 2.0 26.0 21.0         2.0     8.0   31.0 28.0     5       42     11   59 2 26 21         2     8   31 28     5   42   11   59
2159560 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 54.0 9.0 3.0   0.0     0.0     3.0   35.0 34.0             43     12   69 54 9 3   0     0     3   35 34         43   12   69
2177952 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 05 2019   grade_2 0.0 35.0 76.0   0.0     0.0     1.0   54.0 58.0     42       95     *   112 0 35 76   0     0     1   54 58     42   95       112
2177971 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 05 2019   grade_2 1.0 33.0 65.0   1.0     1.0     1.0   52.0 50.0     49       86     10   102 1 33 65   1     1     1   52 50     49   86   10   102
2177990 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 0.0 19.0 56.0   0.0     0.0     0.0   32.0 43.0     31       62     *   75 0 19 56   0     0     0   32 43     31   62       75
2178009 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 05 2019   grade_2 2.0 18.0 67.0         0.0     0.0   52.0 35.0     42       68     9   87 2 18 67         0     0   52 35     42   68   9   87
2178066 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No Elementary 01 05 2019   grade_2 1.0 14.0 72.0   1.0     0.0     0.0   49.0 39.0     43       71     *   88 1 14 72   1     0     0   49 39     43   71       88
2178104 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 0.0 10.0 64.0   0.0     0.0         44.0 30.0     47       62     13   74 0 10 64   0     0         44 30     47   62   13   74
2178845 NY Nassau   school 3626400 280206030000   SEAFORD 362640003618 280206030005 SEAFORD MIDDLE SCHOOL public Regular School No Other 01 09 2019   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
2179339 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2019   grade_2 58.0 3.0 16.0         2.0     5.0   35.0 49.0     8       16     14   84 58 3 16         2     5   35 49     8   16   14   84
2179358 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2019   grade_2 56.0 0.0 15.0         1.0     2.0   33.0 41.0     5       16     *   74 56 0 15         1     2   33 41     5   16       74
2179396 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2019   grade_2 44.0 2.0 22.0         2.0     1.0   36.0 35.0     9       12     *   71 44 2 22         2     1   36 35     9   12       71
2179415 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2019   grade_2 35.0 0.0 15.0         2.0     1.0   29.0 24.0     *       5     *   53 35 0 15         2     1   29 24         5       53
2179434 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2019   grade_2 37.0 0.0 20.0         1.0     3.0   30.0 31.0     5       12     *   61 37 0 20         1     3   30 31     5   12       61
2179643 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2019   grade_2 18.0 18.0 35.0   1.0     17.0     6.0   46.0 49.0     *       30     8   95 18 18 35   1     17     6   46 49         30   8   95
2180251 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2019   grade_2 31.0 0.0 3.0   1.0     7.0         24.0 18.0             *     6   42 31 0 3   1     7         24 18             6   42
2180270 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2019   grade_2 57.0 1.0 22.0   0.0     7.0     2.0   44.0 45.0     5       12     9   89 57 1 22   0     7     2   44 45     5   12   9   89
2180802 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 03 2019   grade_2 28.0 14.0 55.0         8.0     6.0   56.0 55.0     14       57     18   111 28 14 55         8     6   56 55     14   57   18   111
2181429 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2019   grade_2 2.0 52.0 89.0         1.0     0.0   63.0 81.0     47       126     17   144 2 52 89         1     0   63 81     47   126   17   144
2181448 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2019   grade_2 7.0 13.0 73.0   1.0     1.0     0.0   39.0 56.0     31       80     7   95 7 13 73   1     1     0   39 56     31   80   7   95
2181486 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2019   grade_2 2.0 27.0 64.0   1.0     0.0     0.0   44.0 50.0     36       73     10   94 2 27 64   1     0     0   44 50     36   73   10   94
2181638 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No Elementary 01 05 2019   grade_2 67.0 0.0 7.0         10.0     1.0   41.0 44.0     *       9     9   85 67 0 7         10     1   41 44         9   9   85
2184355 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502826 307500013370 PS 370 public Special Education School No Other 01 11 2019   grade_2 2.0 2.0 1.0   0.0     0.0     1.0   6.0 0.0     0       5     6   6 2 2 1   0     0     1   6 0     0   5   6   6
2196553 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 51.0 10.0 11.0   1.0     4.0     4.0   32.0 49.0             16     *   81 51 10 11   1     4     4   32 49         16       81
2213387 NY Steuben   school 3614820 571800010000   HORNELL 361482001230 571800010002 BRYANT SCHOOL public Regular School No Elementary 01 03 2019   grade_2 103.0 5.0 2.0   1.0     0.0     8.0   63.0 56.0     *       73     *   119 103 5 2   1     0     8   63 56         73       119
2214242 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2019   grade_2 5.0 83.0 103.0   0.0     7.0     7.0   101.0 104.0     34       169     24   205 5 83 103   0     7     7   101 104     34   169   24   205
2215306 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No Elementary 01 05 2019   grade_2 31.0 0.0 10.0         3.0     6.0   26.0 24.0             19     *   50 31 0 10         3     6   26 24         19       50
2215325 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2019   grade_2 50.0 3.0 19.0         3.0     4.0   44.0 35.0     *       16     7   79 50 3 19         3     4   44 35         16   7   79
2215344 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2019   grade_2 26.0 2.0 15.0         1.0     4.0   21.0 27.0     0       15     5   48 26 2 15         1     4   21 27     0   15   5   48
2215363 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2019   grade_2 50.0 6.0 39.0         8.0     2.0   54.0 51.0     25       49     32   105 50 6 39         8     2   54 51     25   49   32   105
2215401 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No Elementary 01 05 2019   grade_2 26.0 1.0 10.0         3.0     1.0   15.0 26.0             12     6   41 26 1 10         3     1   15 26         12   6   41
2215477 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001747 580211060014 STAGECOACH SCHOOL public Regular School No Elementary 01 05 2019   grade_2 31.0 5.0 32.0         11.0     0.0   43.0 36.0     13       42     12   79 31 5 32         11     0   43 36     13   42   12   79
2215496 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 54.0 2.0 21.0         2.0     5.0   51.0 33.0             35     20   84 54 2 21         2     5   51 33         35   20   84
2215534 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 88.0 14.0 52.0   0.0     13.0     8.0   90.0 85.0     12       77     27   175 88 14 52   0     13     8   90 85     12   77   27   175
2218479 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 2.0 3.0 102.0         0.0     1.0   53.0 55.0     50       101     25   108 2 3 102         0     1   53 55     50   101   25   108
2218498 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 2.0 15.0 122.0   0.0     1.0     2.0   71.0 71.0     49       136     13   142 2 15 122   0     1     2   71 71     49   136   13   142
2218517 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 3.0 11.0 168.0   2.0     1.0     0.0   103.0 82.0     83       174     28   185 3 11 168   2     1     0   103 82     83   174   28   185
2218536 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 5.0 12.0 214.0   1.0     1.0     1.0   107.0 127.0     105       218     19   234 5 12 214   1     1     1   107 127     105   218   19   234
2218593 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 0.0 8.0 112.0   1.0     3.0     0.0   64.0 60.0     53       116     9   124 0 8 112   1     3     0   64 60     53   116   9   124
2218612 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 3.0 10.0 153.0   0.0     2.0     0.0   93.0 75.0     84       160     17   168 3 10 153   0     2     0   93 75     84   160   17   168
2219676 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No Middle 01 08 2019   grade_2 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     0       0     *   1 0 0 1   0     0     0   1 0     0   0       1
2224293 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 2019   grade_2 63.0 4.0 128.0         4.0     5.0   99.0 105.0     60       125     18   204 63 4 128         4     5   99 105     60   125   18   204
2225338 NY Westchester   school 3614070 660803020000   HAWTHORNE KNOLLS 361407001149 660803020001 HAWTHORNE CEDAR KNOLLS SR/JR HS public Special Education School No Other 01 12 2019   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
2226345 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2019   grade_2 76.0 29.0 241.0   1.0     14.0     20.0   209.0 172.0     44       234     41   381 76 29 241   1     14     20   209 172     44   234   41   381
2152416 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001901976 81003040003 UNADILLA VALLEY SECONDARY SCHOOL public Regular School No Other 02 12 2019   grade_2 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 1 0 0   0     0     0   1 0                 1
2154639 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2019   grade_2 38.0   5.0         1.0     4.0   24.0 24.0     *       19     9   48 38   5         1     4   24 24         19   9   48
2158211 NY Erie   school 3610170 141201060000   EDEN 361017000790 141201060005 EDEN ELEMENTARY SCHOOL public Regular School No Other 02 10 2019   grade_2 1.0 0.0 0.0   0.0           0.0   1.0 0.0             0     *   1 1 0 0   0           0   1 0         0       1
2158439 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000495 141501060001 HUTH ROAD SCHOOL public Regular School No Elementary 02 05 2019   grade_2 81.0 0.0 6.0   0.0     4.0     8.0   56.0 43.0     5       25     13   99 81 0 6   0     4     8   56 43     5   25   13   99
2158458 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000496 141501060003 KAEGEBEIN SCHOOL public Regular School No Elementary 02 05 2019   grade_2 80.0 1.0 2.0   0.0     2.0     2.0   50.0 37.0     *       *     *   87 80 1 2   0     2     2   50 37                 87
2158876 NY Erie   school 3616440 141800010000   LACKAWANNA 361644005578 141800010011 MARTIN ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 78.0 13.0 32.0   0.0     3.0     3.0   61.0 68.0     20       113     *   129 78 13 32   0     3     3   61 68     20   113       129
2160472 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2019   grade_2 121.0 1.0 4.0   1.0     0.0     2.0   65.0 64.0     *       67     12   129 121 1 4   1     0     2   65 64         67   12   129
2160757 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 117.0 21.0 12.0   1.0     2.0     0.0   85.0 68.0     *       106     17   153 117 21 12   1     2     0   85 68         106   17   153
2161916 NY Herkimer   school 3601087 212101040000   C-V AT ILION-MOHAWK CSD 360108701282 212101040006 BARRINGER ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2019   grade_2 125.0 3.0 6.0         1.0     0.0   71.0 64.0     *       93     *   135 125 3 6         1     0   71 64         93       135
2173905 NY Madison   school 3606390 250901060000   CANASTOTA 360639000422 250901060006 SOUTH SIDE ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2019   grade_2 94.0 0.0 3.0   0.0           4.0   49.0 52.0             58     15   101 94 0 3   0           4   49 52         58   15   101
2175045 NY Monroe   school 3614700 260901060000   HONEOYE FALLS-LIMA 361470001225 260901060002 MANOR INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2019   grade_2 130.0 1.0 5.0         1.0     1.0   72.0 66.0     *       35     9   138 130 1 5         1     1   72 66         35   9   138
2179700 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004228 280214030002 HEWLETT ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 68.0 8.0 21.0   0.0     13.0     1.0   57.0 54.0     6       22     20   111 68 8 21   0     13     1   57 54     6   22   20   111
2179719 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004229 280214030003 OGDEN ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 45.0 8.0 13.0         11.0     2.0   38.0 41.0     *       21     11   79 45 8 13         11     2   38 41         21   11   79
2180080 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000947 280218030004 STRATFORD AVENUE SCHOOL public Regular School No Elementary 02 05 2019   grade_2 126.0 0.0 12.0         8.0     5.0   74.0 77.0     *       *     32   151 126 0 12         8     5   74 77             32   151
2180099 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000946 280218030005 STEWART SCHOOL public Regular School No Elementary 02 05 2019   grade_2 132.0 3.0 4.0         10.0     0.0   80.0 69.0     *       8     23   149 132 3 4         10     0   80 69         8   23   149
2180745 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001322 280226030003 MICHAEL F STOKES SCHOOL public Regular School No Elementary 02 04 2019   grade_2 104.0 4.0 32.0   0.0     22.0     2.0   75.0 89.0     6       *     16   164 104 4 32   0     22     2   75 89     6       16   164
2181600 NY Nassau   school 3625050 280403030000   ROSLYN 362505003467 280403030004 EAST HILLS ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 69.0 7.0 8.0   1.0     27.0     2.0   59.0 55.0     *       25     12   114 69 7 8   1     27     2   59 55         25   12   114
2183747 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 02 12 2019   grade_2 1.0 0.0 2.0   0.0     0.0         2.0 1.0     0       *     *   3 1 0 2   0     0         2 1     0           3
2194387 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2019   grade_2 111.0 10.0 3.0   1.0     1.0     3.0   60.0 69.0     *       30     8   129 111 10 3   1     1     3   60 69         30   8   129
2195242 NY Onondaga   school 3626940 421601060000   SKANEATELES 362694003669 421601060004 STATE STREET INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2019   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
2196116 NY Ontario   school 3611970 430700010000   GENEVA 361197000965 430700010002 NORTH STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 62.0 19.0 57.0         5.0     19.0   83.0 79.0     13       117     25   162 62 19 57         5     19   83 79     13   117   25   162
2197256 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 86.0 19.0 74.0   0.0     10.0     13.0   101.0 101.0     5       60     41   202 86 19 74   0     10     13   101 101     5   60   41   202
2197275 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001792 441201060002 CENTRAL VALLEY ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 66.0 8.0 42.0   1.0     11.0     6.0   80.0 54.0     *       49     30   134 66 8 42   1     11     6   80 54         49   30   134
2197294 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001796 441201060003 NORTH MAIN STREET SCHOOL public Regular School No Elementary 02 05 2019   grade_2 53.0 8.0 58.0         4.0     3.0   60.0 66.0     10       56     15   126 53 8 58         4     3   60 66     10   56   15   126
2202500 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012304352 342700010056 PS 56 HARRY EICHLER public Regular School No Elementary 02 05 2019   grade_2 10.0 1.0 40.0   1.0     32.0     3.0   37.0 50.0     27       67     21   87 10 1 40   1     32     3   37 50     27   67   21   87
2212684 NY Schuyler   school 3621630 550101040000   ODESSA MONTOUR 362163003067 550101040002 HOWARD A HANLON ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2019   grade_2 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 1 0 0   0     0     0   1 0                 1
2216541 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000574 580402060002 LLOYD HARBOR SCHOOL public Regular School No Elementary 02 06 2019   grade_2 54.0 0.0 3.0   0.0     6.0     3.0   29.0 37.0     *       0     5   66 54 0 3   0     6     3   29 37         0   5   66
2216560 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000575 580402060003 WEST SIDE SCHOOL public Regular School No Elementary 02 06 2019   grade_2 49.0   2.0         2.0     1.0   23.0 31.0             *     *   54 49   2         2     1   23 31                 54
2217624 NY Suffolk   school 3615540 580502020000   ISLIP 361554001323 580502020002 COMMACK ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 69.0 5.0 42.0   0.0     6.0     4.0   60.0 66.0     14       41     15   126 69 5 42   0     6     4   60 66     14   41   15   126
2217662 NY Suffolk   school 3615540 580502020000   ISLIP 361554001326 580502020005 MAUD S SHERWOOD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 45.0 2.0 18.0         2.0     1.0   36.0 32.0     *       16     14   68 45 2 18         2     1   36 32         16   14   68
2220417 NY Tioga   school 3630270 600101060000   WAVERLY 363027004066 600101060002 ELM STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2019   grade_2 98.0 1.0 2.0         0.0     0.0   46.0 55.0             *     *   101 98 1 2         0     0   46 55                 101
2224065 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000783 660301030001 ANNE HUTCHINSON SCHOOL public Regular School No Elementary 02 07 2019   grade_2 56.0 0.0 11.0   0.0     14.0     8.0   45.0 44.0     11       *     13   89 56 0 11   0     14     8   45 44     11       13   89
2224084 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000786 660301030003 GREENVALE SCHOOL public Regular School No Elementary 02 05 2019   grade_2 81.0 3.0 10.0         27.0     3.0   66.0 58.0     13       *     9   124 81 3 10         27     3   66 58     13       9   124
2224749 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001045 660407060009 HIGHVIEW SCHOOL public Regular School No Elementary 02 03 2019   grade_2 17.0 43.0 54.0         7.0     1.0   67.0 55.0     12       74     *   122 17 43 54         7     1   67 55     12   74       122
2224787 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2019   grade_2 6.0 7.0 40.0         10.0     3.0   26.0 40.0     15       30     *   66 6 7 40         10     3   26 40     15   30       66
2226535 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2019   grade_2 8.0 47.0 174.0         1.0     13.0   136.0 107.0     81       208     29   243 8 47 174         1     13   136 107     81   208   29   243
2149281 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   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   0   0
2149509 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   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
2149604 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001376 31502060001 JOHNSON CITY ELEM/INTRMED SCHOOL public Regular School No Other 03 11 2019   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   0   0
2150155 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2019   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
2150383 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 07 2019   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
2151200 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000718 60800010010 DUNKIRK MIDDLE SCHOOL public Regular School No Middle 03 08 2019   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
2151257 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   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
2151865 NY Chemung   school 3610560 70600010000   ELMIRA 361056000818 70600010010 HENDY AVENUE SCHOOL public Regular School No Elementary 03 06 2019   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
2151884 NY Chemung   school 3610560 70600010000   ELMIRA 361056004387 70600010013 PARLEY COBURN SCHOOL public Regular School No Elementary 03 06 2019   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
2151941 NY Chemung   school 3610560 70600010000   ELMIRA 361056000825 70600010016 THOMAS K BEECHER SCHOOL public Regular School No Elementary 03 06 2019   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
2152017 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2019   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
2152359 NY Chenango   school 3612750 80601040000   GREENE 361275001051 80601040002 GREENE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   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
2152454 NY Chenango   school 3621330 81200050000   NORWICH 362133003041 81200050001 PERRY BROWNE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   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
2153043 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2019   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
2153765 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   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
2154354 NY Dutchess   school 3609210 130502020000   DOVER 360921000706 130502020002 DOVER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   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
2154924 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No Elementary 03 05 2019   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   0   0
2154981 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No Elementary 03 05 2019   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   0   0

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