Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_2", state = "NY" and year = 2017 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_2 · 4,722
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
987031 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_2 2.0 9.0 19.0         4.0     0.0   25.0 9.0     *       26     34   34 2 9 19         4     0   25 9         26   34   34
962426 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_2 64.0 4.0 7.0   0.0     0.0     3.0   35.0 43.0             46     12   78 64 4 7   0     0     3   35 43         46   12   78
972097 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
982319 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_2 48.0 2.0 11.0         3.0     2.0   34.0 32.0     6       13     *   66 48 2 11         3     2   34 32     6   13       66
982338 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_2 65.0 3.0 25.0         3.0     2.0   49.0 49.0     *       11     11   98 65 3 25         3     2   49 49         11   11   98
982357 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2017   grade_2 32.0 2.0 5.0         3.0     1.0   23.0 20.0     *       7     *   43 32 2 5         3     1   23 20         7       43
982376 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2017   grade_2 56.0 2.0 34.0         2.0     4.0   57.0 41.0     16       22     12   98 56 2 34         2     4   57 41     16   22   12   98
982395 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2017   grade_2 25.0 0.0 3.0         4.0     1.0   19.0 14.0     0       *     *   33 25 0 3         4     1   19 14     0           33
982414 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2017   grade_2 47.0 0.0 10.0   0.0     3.0     2.0   33.0 29.0     *       7     12   62 47 0 10   0     3     2   33 29         7   12   62
982623 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2017   grade_2 20.0 18.0 45.0   2.0     16.0     8.0   58.0 51.0     7       30     15   109 20 18 45   2     16     8   58 51     7   30   15   109
982756 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No Elementary 01 02 2017   grade_2 24.0 39.0 134.0   4.0     9.0     2.0   110.0 102.0     60       189     29   212 24 39 134   4     9     2   110 102     60   189   29   212
983231 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No Elementary 01 05 2017   grade_2 65.0 7.0 13.0   1.0     4.0     3.0   51.0 42.0     *       12     16   93 65 7 13   1     4     3   51 42         12   16   93
983250 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2017   grade_2 23.0 3.0 3.0         0.0     0.0   14.0 15.0             *     *   29 23 3 3         0     0   14 15                 29
983269 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2017   grade_2 38.0 5.0 19.0   1.0     3.0     3.0   33.0 36.0     5       13     7   69 38 5 19   1     3     3   33 36     5   13   7   69
983801 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_2 20.0 12.0 24.0   0.0     5.0     6.0   41.0 26.0     7       39     14   67 20 12 24   0     5     6   41 26     7   39   14   67
983877 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No Elementary 01 05 2017   grade_2 18.0 9.0 28.0   0.0     4.0     4.0   39.0 24.0     17       38     10   63 18 9 28   0     4     4   39 24     17   38   10   63
984428 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_2 0.0 52.0 148.0         1.0         108.0 93.0     106       184     18   201 0 52 148         1         108 93     106   184   18   201
984447 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2017   grade_2 4.0 6.0 108.0   0.0     2.0     0.0   64.0 56.0     63       110     7   120 4 6 108   0     2     0   64 56     63   110   7   120
984485 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2017   grade_2 4.0 17.0 73.0   1.0     4.0     0.0   56.0 43.0     50       81     7   99 4 17 73   1     4     0   56 43     50   81   7   99
984637 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No Elementary 01 05 2017   grade_2 75.0 2.0 4.0         13.0     1.0   37.0 58.0     *       7     8   95 75 2 4         13     1   37 58         7   8   95
992541 NY New York   school 3600142 310400861061   NY CTR FOR AUTISM CHARTER SC 360014205779 310400861061 NY CENTER FOR AUTISM CHARTER SCHOOL charter Special Education School Yes Elementary 01 03 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
999590 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 54.0 6.0 23.0         3.0     4.0   40.0 50.0             17     10   90 54 6 23         3     4   40 50         17   10   90
1015512 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000566 541102060002 COBLESKILL-RICHMONDVILLE HIGH SCHOOL public Regular School No Other 01 12 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1015531 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000277 541102060004 WILLIAM H GOLDING MIDDLE SCHOOL public Regular School No Elementary 01 08 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1017222 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2017   grade_2 5.0 75.0 127.0   1.0     4.0     7.0   113.0 106.0     57       195     26   219 5 75 127   1     4     7   113 106     57   195   26   219
1018286 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No Elementary 01 05 2017   grade_2 35.0 2.0 9.0         0.0     2.0   21.0 27.0             16     *   48 35 2 9         0     2   21 27         16       48
1018305 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_2 51.0 1.0 13.0         2.0     3.0   38.0 32.0             21     15   70 51 1 13         2     3   38 32         21   15   70
1018324 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_2 47.0 1.0 16.0         1.0     4.0   35.0 34.0     *       28     8   69 47 1 16         1     4   35 34         28   8   69
1018343 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2017   grade_2 38.0 2.0 21.0         3.0     0.0   33.0 31.0     10       *     12   64 38 2 21         3     0   33 31     10       12   64
1018381 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No Elementary 01 05 2017   grade_2 41.0 0.0 11.0         2.0     2.0   26.0 30.0             17     *   56 41 0 11         2     2   26 30         17       56
1018457 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001747 580211060014 STAGECOACH SCHOOL public Regular School No Elementary 01 05 2017   grade_2 50.0 1.0 28.0         7.0     4.0   57.0 33.0     19       41     24   90 50 1 28         7     4   57 33     19   41   24   90
1018476 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 71.0 1.0 10.0         5.0     3.0   37.0 53.0     *       31     14   90 71 1 10         5     3   37 53         31   14   90
1018514 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 71.0 8.0 55.0         8.0     13.0   81.0 74.0     20       71     12   155 71 8 55         8     13   81 74     20   71   12   155
1021440 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 1.0 15.0 138.0         3.0         95.0 62.0     79       148     38   157 1 15 138         3         95 62     79   148   38   157
1021459 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 2.0 7.0 126.0         1.0     1.0   59.0 78.0     78       131     6   137 2 7 126         1     1   59 78     78   131   6   137
1021478 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 5.0 16.0 174.0   1.0     2.0     3.0   96.0 105.0     89       190     32   201 5 16 174   1     2     3   96 105     89   190   32   201
1021497 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 2.0 12.0 194.0   0.0     1.0     4.0   98.0 115.0     92       202     22   213 2 12 194   0     1     4   98 115     92   202   22   213
1021554 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 1.0 7.0 118.0   1.0     2.0     1.0   63.0 67.0     66       *     17   130 1 7 118   1     2     1   63 67     66       17   130
1021573 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 5.0 11.0 182.0   1.0     3.0     2.0   105.0 99.0     91       194     23   204 5 11 182   1     3     2   105 99     91   194   23   204
1021706 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687004253 580513030001 CORDELLO AVENUE ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 1.0 11.0 105.0         1.0         65.0 53.0     68       105     7   118 1 11 105         1         65 53     68   105   7   118
1021725 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000476 580513030002 FRANCIS J O'NEILL SCHOOL public Regular School No Elementary 01 05 2017   grade_2 8.0 32.0 115.0         3.0     0.0   82.0 76.0     43       129     29   158 8 32 115         3     0   82 76     43   129   29   158
1021744 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000477 580513030003 MARGUERITE L MULVEY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 2.0 23.0 98.0         0.0     0.0   74.0 49.0     64       111     24   123 2 23 98         0     0   74 49     64   111   24   123
1021801 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No Elementary 01 05 2017   grade_2 13.0 33.0 142.0   0.0     7.0     0.0   91.0 104.0     76       147     28   195 13 33 142   0     7     0   91 104     76   147   28   195
1027273 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 2017   grade_2 63.0 6.0 117.0         7.0     5.0   98.0 100.0     38       110     13   198 63 6 117         7     5   98 100     38   110   13   198
1029344 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2017   grade_2 76.0 33.0 245.0         11.0     17.0   204.0 178.0     92       251     29   382 76 33 245         11     17   204 178     92   251   29   382
952432 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Alternative School No Other 02 09 2017   grade_2 3.0 0.0 1.0               1.0   3.0 2.0             *     5   5 3 0 1               1   3 2             5   5
955244 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No Elementary 02 07 2017   grade_2 53.0 0.0 0.0   0.0     0.0     3.0   31.0 25.0     *       33     *   56 53 0 0   0     0     3   31 25         33       56
957600 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2017   grade_2 42.0   7.0         0.0     6.0   25.0 30.0     *       29     *   55 42   7         0     6   25 30         29       55
957904 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No Elementary 02 05 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
958322 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988001118 132101060006 KINRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2017   grade_2 1.0 0.0 0.0         0.0     1.0   2.0 0.0             *     *   2 1 0 0         0     1   2 0                 2
961324 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000495 141501060001 HUTH ROAD SCHOOL public Regular School No Elementary 02 5 2017   grade_2 104.0 2.0 4.0   1.0     2.0     8.0   59.0 62.0     *       29     5   121 104 2 4   1     2     8   59 62         29   5   121
961343 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000496 141501060003 KAEGEBEIN SCHOOL public Regular School No Elementary 02 5 2017   grade_2 92.0 1.0 5.0   0.0     6.0     6.0   53.0 57.0     12       38     *   110 92 1 5   0     6     6   53 57     12   38       110
963357 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 3 2017   grade_2 103.0 0.0 5.0         1.0     1.0   54.0 56.0             63     6   110 103 0 5         1     1   54 56         63   6   110
963680 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 02 5 2017   grade_2 146.0 8.0 13.0   0.0     0.0     17.0   89.0 95.0     *       115     13   184 146 8 13   0     0     17   89 95         115   13   184
964839 NY Herkimer   school 3601087 212101040000   C-V AT ILION-MOHAWK CSD 360108701282 212101040006 BARRINGER ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 4 2017   grade_2 145.0 2.0 2.0         0.0     1.0   76.0 74.0     *       93     *   150 145 2 2         0     1   76 74         93       150
976923 NY Madison   school 3606390 250901060000   CANASTOTA 360639000422 250901060006 SOUTH SIDE ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2017   grade_2 99.0 3.0 3.0   1.0     1.0     4.0   54.0 57.0     *       71     17   111 99 3 3   1     1     4   54 57         71   17   111
978063 NY Monroe   school 3614700 260901060000   HONEOYE FALLS-LIMA 361470001225 260901060002 MANOR INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2017   grade_2 130.0 0.0 2.0         0.0     2.0   74.0 60.0     *       *     9   134 130 0 2         0     2   74 60             9   134
982680 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004228 280214030002 HEWLETT ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 66.0 6.0 24.0   0.0     8.0     1.0   59.0 46.0     11       26     *   105 66 6 24   0     8     1   59 46     11   26       105
982699 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004229 280214030003 OGDEN ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 54.0 7.0 23.0         8.0     1.0   58.0 35.0     9       27     8   93 54 7 23         8     1   58 35     9   27   8   93
983079 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000947 280218030004 STRATFORD AVENUE SCHOOL public Regular School No Elementary 02 05 2017   grade_2 109.0   7.0         2.0     11.0   58.0 71.0     *       *     14   129 109   7         2     11   58 71             14   129
983098 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000946 280218030005 STEWART SCHOOL public Regular School No Elementary 02 05 2017   grade_2 117.0 1.0 7.0         8.0     2.0   62.0 73.0     0       *     *   135 117 1 7         8     2   62 73     0           135
983744 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001322 280226030003 MICHAEL F STOKES SCHOOL public Regular School No Elementary 02 04 2017   grade_2 85.0 3.0 27.0   2.0     16.0     0.0   77.0 56.0     7       *     14   133 85 3 27   2     16     0   77 56     7       14   133
984599 NY Nassau   school 3625050 280403030000   ROSLYN 362505003467 280403030004 EAST HILLS ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 90.0 11.0 15.0   0.0     20.0     2.0   63.0 75.0     13       28     10   138 90 11 15   0     20     2   63 75     13   28   10   138
997424 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2017   grade_2 94.0 4.0 5.0   1.0     3.0     9.0   53.0 63.0     *       32     *   116 94 4 5   1     3     9   53 63         32       116
1000293 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 111.0 16.0 59.0   0.0     11.0     4.0   100.0 101.0     9       *     39   201 111 16 59   0     11     4   100 101     9       39   201
1000312 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001792 441201060002 CENTRAL VALLEY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 82.0 10.0 43.0   0.0     12.0     1.0   74.0 74.0     *       *     12   148 82 10 43   0     12     1   74 74             12   148
1000331 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001796 441201060003 NORTH MAIN STREET SCHOOL public Regular School No Elementary 02 05 2017   grade_2 64.0 4.0 45.0         7.0     2.0   66.0 56.0     7       44     14   122 64 4 45         7     2   66 56     7   44   14   122
1005537 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012304352 342700010056 PS 56 HARRY EICHLER public Regular School No Elementary 02 05 2017   grade_2 17.0 6.0 45.0   5.0     34.0     1.0   56.0 52.0     33       90     20   108 17 6 45   5     34     1   56 52     33   90   20   108
1009945 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001495 490601060009 RENSSELAER PARK ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 0.0 0.0 1.0         0.0     0.0   0.0 1.0     0       *     *   1 0 0 1         0     0   0 1     0           1
1016348 NY Steuben   school 3614820 571800010000   HORNELL 361482001230 571800010002 BRYANT SCHOOL public Regular School No Other 02 11 2017   grade_2 99.0 2.0 3.0         1.0     6.0   56.0 55.0     6       79     18   111 99 2 3         1     6   56 55     6   79   18   111
1017241 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000066 580106030003 PARK AVENUE SCHOOL public Regular School No Elementary 02 06 2017   grade_2 0.0 2.0 4.0   0.0     0.0     0.0   5.0 1.0     *       6     6   6 0 2 4   0     0     0   5 1         6   6   6
1017393 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004234 580109020001 MARTIN LUTHER KING ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2017   grade_2 0.0 107.0 105.0         1.0     3.0   104.0 112.0     76       192     29   216 0 107 105         1     3   104 112     76   192   29   216
1019502 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000574 580402060002 LLOYD HARBOR SCHOOL public Regular School No Elementary 02 06 2017   grade_2 48.0 1.0 5.0         5.0     3.0   34.0 28.0     *       *     *   62 48 1 5         5     3   34 28                 62
1019521 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000575 580402060003 WEST SIDE SCHOOL public Regular School No Elementary 02 06 2017   grade_2 34.0 0.0 4.0         3.0     1.0   23.0 19.0     *       *     *   42 34 0 4         3     1   23 19                 42
1020585 NY Suffolk   school 3615540 580502020000   ISLIP 361554001323 580502020002 COMMACK ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 59.0 2.0 33.0   0.0     6.0     2.0   54.0 48.0     14       42     7   102 59 2 33   0     6     2   54 48     14   42   7   102
1020623 NY Suffolk   school 3615540 580502020000   ISLIP 361554001326 580502020005 MAUD S SHERWOOD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2017   grade_2 60.0 8.0 8.0   1.0     0.0     3.0   46.0 34.0     *       25     *   80 60 8 8   1     0     3   46 34         25       80
1023378 NY Tioga   school 3630270 600101060000   WAVERLY 363027004066 600101060002 ELM STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2017   grade_2 102.0 1.0 0.0               0.0   48.0 55.0             *     *   103 102 1 0               0   48 55                 103
1027045 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000783 660301030001 ANNE HUTCHINSON SCHOOL public Regular School No Elementary 02 05 2017   grade_2 75.0 2.0 14.0   1.0     13.0     4.0   52.0 57.0     12       *     15   109 75 2 14   1     13     4   52 57     12       15   109
1027064 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000786 660301030003 GREENVALE SCHOOL public Regular School No Elementary 02 05 2017   grade_2 82.0 2.0 19.0         25.0     5.0   69.0 64.0     15       *     12   133 82 2 19         25     5   69 64     15       12   133
1027786 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2017   grade_2 4.0 10.0 35.0         13.0     1.0   32.0 31.0     23       38     6   63 4 10 35         13     1   32 31     23   38   6   63
1029534 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2017   grade_2 18.0 48.0 187.0   0.0     4.0     12.0   150.0 119.0     95       232     36   269 18 48 187   0     4     12   150 119     95   232   36   269
952204 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952527 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001376 31502060001 JOHNSON CITY ELEM/INTRMED SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
954142 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000718 60800010010 DUNKIRK MIDDLE SCHOOL public Regular School No Elementary 03 08 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
954199 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
954807 NY Chemung   school 3610560 70600010000   ELMIRA 361056000818 70600010010 HENDY AVENUE SCHOOL public Regular School No Elementary 03 06 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
954826 NY Chemung   school 3610560 70600010000   ELMIRA 361056004387 70600010013 PARLEY COBURN SCHOOL public Regular School No Elementary 03 06 2017   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
954883 NY Chemung   school 3610560 70600010000   ELMIRA 361056000825 70600010016 THOMAS K BEECHER SCHOOL public Regular School No Elementary 03 06 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
954959 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
955301 NY Chenango   school 3612750 80601040000   GREENE 361275001051 80601040002 GREENE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0   0.0   0.0     0.0         0.0 0.0     *       0     0   0 0   0   0     0         0 0         0   0   0
955358 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001901976 81003040003 UNADILLA VALLEY SECONDARY SCHOOL public Regular School No Other 03 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
955396 NY Chenango   school 3621330 81200050000   NORWICH 362133003041 81200050001 PERRY BROWNE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
955985 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
956327 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH INTER SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
956726 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957315 NY Dutchess   school 3609210 130502020000   DOVER 360921000706 130502020002 DOVER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957961 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
958018 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000430 131602020001 HAGAN SCHOOL public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
958132 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000225 131701060006 MILL ROAD-INTERMEDIATE GRADES public Regular School No Elementary 03 05 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
958531 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001770 132201040002 ALDEN PLACE ELEMENTARY SCHOOL public Regular School No Elementary 03 5 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0

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