Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2018 · 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
2067904 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2106341 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_2 3.0 28.0 7.0         3.0     4.0   22.0 23.0     *       39     *   45 3 28 7         3     4   22 23         39       45
2065035 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_2 2.0 40.0 15.0         1.0     10.0   39.0 29.0     7       50     6   68 2 40 15         1     10   39 29     7   50   6   68
2069823 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 66.0 2.0 7.0   1.0     0.0     7.0   46.0 37.0             53     13   83 66 2 7   1     0     7   46 37         53   13   83
2070735 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_2 83.0 1.0 3.0         2.0     0.0   44.0 45.0     *       *     *   89 83 1 3         2     0   44 45                 89
2071020 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 109.0 13.0 14.0   0.0     1.0     21.0   87.0 71.0     *       108     11   158 109 13 14   0     1     21   87 71         108   11   158
2088272 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No Elementary 01 05 2018   grade_2 1.0 52.0 93.0   1.0     0.0     1.0   74.0 74.0     49       137     8   148 1 52 93   1     0     1   74 74     49   137   8   148
2088291 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 05 2018   grade_2 4.0 46.0 65.0   0.0     2.0     0.0   66.0 51.0     42       106     15   117 4 46 65   0     2     0   66 51     42   106   15   117
2088310 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 2.0 31.0 71.0   2.0     1.0     0.0   55.0 52.0     48       101     11   107 2 31 71   2     1     0   55 52     48   101   11   107
2088329 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 05 2018   grade_2 4.0 12.0 81.0   0.0           0.0   51.0 46.0     49       91     16   97 4 12 81   0           0   51 46     49   91   16   97
2088386 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No Elementary 01 05 2018   grade_2 2.0 23.0 78.0   0.0           1.0   60.0 44.0     51       95     9   104 2 23 78   0           1   60 44     51   95   9   104
2088424 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 1.0 7.0 71.0   0.0     0.0         45.0 34.0     46       76     *   79 1 7 71   0     0         45 34     46   76       79
2089640 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2018   grade_2 53.0 1.0 13.0         2.0     2.0   29.0 42.0     7       15     *   71 53 1 13         2     2   29 42     7   15       71
2089659 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2018   grade_2 67.0 3.0 11.0         4.0     3.0   52.0 36.0     *       8     5   88 67 3 11         4     3   52 36         8   5   88
2089678 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2018   grade_2 39.0 0.0 5.0         3.0     0.0   26.0 21.0     *       6     6   47 39 0 5         3     0   26 21         6   6   47
2089697 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2018   grade_2 51.0 1.0 21.0         6.0     1.0   44.0 36.0     10       18     *   80 51 1 21         6     1   44 36     10   18       80
2089716 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2018   grade_2 49.0 0.0 9.0         1.0     0.0   41.0 18.0     *       8     15   59 49 0 9         1     0   41 18         8   15   59
2089735 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2018   grade_2 51.0 1.0 17.0         0.0     2.0   44.0 27.0     *       10     7   71 51 1 17         0     2   44 27         10   7   71
2089944 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2018   grade_2 6.0 18.0 30.0   0.0     19.0     3.0   30.0 46.0     7       30     *   76 6 18 30   0     19     3   30 46     7   30       76
2090077 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No Elementary 01 02 2018   grade_2 20.0 31.0 92.0   1.0     7.0     2.0   78.0 75.0     51       133     19   153 20 31 92   1     7     2   78 75     51   133   19   153
2090552 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No Elementary 01 05 2018   grade_2 54.0 6.0 10.0         3.0     1.0   38.0 36.0     *       12     12   74 54 6 10         3     1   38 36         12   12   74
2090571 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2018   grade_2 29.0 1.0 8.0   0.0     1.0     1.0   18.0 22.0             *     5   40 29 1 8   0     1     1   18 22             5   40
2090590 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2018   grade_2 54.0 2.0 19.0   0.0     5.0     5.0   45.0 40.0     *       12     14   85 54 2 19   0     5     5   45 40         12   14   85
2091122 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 05 2018   grade_2 12.0 9.0 24.0         7.0     2.0   29.0 25.0     6       27     9   54 12 9 24         7     2   29 25     6   27   9   54
2091198 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No Elementary 01 05 2018   grade_2 10.0 12.0 26.0   0.0     4.0     2.0   24.0 30.0     *       24     *   54 10 12 26   0     4     2   24 30         24       54
2091749 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2018   grade_2 0.0 42.0 108.0         1.0         77.0 74.0     73       130     17   151 0 42 108         1         77 74     73   130   17   151
2091768 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2018   grade_2 3.0 6.0 94.0   1.0     3.0     0.0   45.0 62.0     42       90     6   107 3 6 94   1     3     0   45 62     42   90   6   107
2091806 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2018   grade_2 2.0 39.0 78.0   0.0     2.0     1.0   61.0 61.0     52       104     *   122 2 39 78   0     2     1   61 61     52   104       122
2094029 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 01 12 2018   grade_2 0.0 3.0 0.0   0.0     0.0     1.0   2.0 2.0     0       *     *   4 0 3 0   0     0     1   2 2     0           4
2099919 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 01 2018   grade_2 0.0 0.0 1.0         0.0     0.0   1.0 0.0     *       *     *   1 0 0 1         0     0   1 0                 1
2105942 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003872 421800010025 HUGHES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106968 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 60.0 8.0 17.0   0.0     1.0     5.0   44.0 47.0             22     7   91 60 8 17   0     1     5   44 47         22   7   91
2124467 NY Suffolk   school 3608310 580105030000   COPIAGUE 360831000611 580105030001 DEAUVILLE GARDENS EAST ELEMENTARY public Regular School No Elementary 01 05 2018   grade_2 15.0 16.0 47.0   1.0     0.0     1.0   33.0 47.0     5       60     *   80 15 16 47   1     0     1   33 47     5   60       80
2124562 NY Suffolk   school 3608310 580105030000   COPIAGUE 360831006333 580105030007 DEAUVILLE GARDENS WEST ELEMENTARY public Regular School No Elementary 01 05 2018   grade_2 15.0 14.0 38.0         0.0     1.0   34.0 34.0     *       48     11   68 15 14 38         0     1   34 34         48   11   68
2124600 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_2 13.0 77.0 135.0   1.0     2.0     9.0   124.0 113.0     60       193     25   237 13 77 135   1     2     9   124 113     60   193   25   237
2125664 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No Elementary 01 05 2018   grade_2 35.0 6.0 16.0         5.0     0.0   30.0 32.0             29     11   62 35 6 16         5     0   30 32         29   11   62
2125683 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2018   grade_2 47.0 0.0 12.0         2.0     5.0   40.0 26.0     *       17     12   66 47 0 12         2     5   40 26         17   12   66
2125702 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2018   grade_2 47.0 4.0 20.0         0.0     4.0   38.0 37.0     *       30     26   75 47 4 20         0     4   38 37         30   26   75
2125721 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2018   grade_2 54.0 1.0 35.0         2.0     4.0   49.0 47.0     18       41     17   96 54 1 35         2     4   49 47     18   41   17   96
2125759 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No Elementary 01 05 2018   grade_2 32.0 1.0 9.0         2.0     2.0   24.0 22.0             13     5   46 32 1 9         2     2   24 22         13   5   46
2125835 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001747 580211060014 STAGECOACH SCHOOL public Regular School No Elementary 01 05 2018   grade_2 34.0 0.0 26.0         7.0     4.0   27.0 44.0     10       35     7   71 34 0 26         7     4   27 44     10   35   7   71
2125854 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 46.0 1.0 9.0         8.0     2.0   40.0 26.0             20     *   66 46 1 9         8     2   40 26         20       66
2125892 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 102.0 15.0 48.0         13.0     6.0   87.0 97.0     12       78     12   184 102 15 48         13     6   87 97     12   78   12   184
2128837 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 3.0 7.0 145.0         0.0     0.0   88.0 67.0     72       150     37   155 3 7 145         0     0   88 67     72   150   37   155
2128856 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 1.0 11.0 131.0   0.0     2.0     1.0   72.0 74.0     63       139     7   146 1 11 131   0     2     1   72 74     63   139   7   146
2128875 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 5.0 9.0 192.0   0.0     3.0     3.0   97.0 115.0     93       188     38   212 5 9 192   0     3     3   97 115     93   188   38   212
2128894 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 2.0 15.0 174.0   0.0     1.0     1.0   93.0 100.0     68       182     18   193 2 15 174   0     1     1   93 100     68   182   18   193
2128951 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 2.0 11.0 124.0   0.0     0.0     0.0   67.0 70.0     52       125     9   137 2 11 124   0     0     0   67 70     52   125   9   137
2128970 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 3.0 10.0 165.0   0.0     0.0     1.0   91.0 88.0     75       167     19   179 3 10 165   0     0     1   91 88     75   167   19   179
2129103 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687004253 580513030001 CORDELLO AVENUE ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 0.0 10.0 115.0         1.0     0.0   73.0 53.0     71       113     9   126 0 10 115         1     0   73 53     71   113   9   126
2129122 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000476 580513030002 FRANCIS J O'NEILL SCHOOL public Regular School No Elementary 01 05 2018   grade_2 6.0 26.0 102.0         4.0     0.0   71.0 67.0     39       *     19   138 6 26 102         4     0   71 67     39       19   138
2129141 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000477 580513030003 MARGUERITE L MULVEY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 3.0 14.0 106.0         0.0         64.0 59.0     74       *     18   123 3 14 106         0         64 59     74       18   123
2129198 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No Elementary 01 05 2018   grade_2 9.0 26.0 121.0         4.0     0.0   86.0 74.0     63       133     27   160 9 26 121         4     0   86 74     63   133   27   160
2133188 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001252 641301060005 HUDSON FALLS PRIMARY SCHOOL public Regular School No Elementary 01 03 2018   grade_2 149.0 4.0 8.0   1.0     1.0     12.0   92.0 83.0     *       105     39   175 149 4 8   1     1     12   92 83         105   39   175
2134632 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 2018   grade_2 70.0 4.0 122.0         8.0     4.0   106.0 102.0     46       120     24   208 70 4 122         8     4   106 102     46   120   24   208
2136684 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2018   grade_2 69.0 29.0 208.0   0.0     14.0     14.0   171.0 163.0     55       211     23   334 69 29 208   0     14     14   171 163     55   211   23   334
2062584 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2018   grade_2 47.0 1.0 1.0   0.0     0.0     3.0   28.0 24.0     *       30     5   52 47 1 1   0     0     3   28 24         30   5   52
2063667 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH INTER SCHOOL public Regular School No Elementary 02 05 2018   grade_2 66.0 25.0 25.0         10.0     24.0   74.0 76.0     *       107     17   150 66 25 25         10     24   74 76         107   17   150
2064959 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2018   grade_2 56.0   10.0         1.0     5.0   35.0 37.0     6       35     10   72 56   10         1     5   35 37     6   35   10   72
2068493 NY Erie   school 3610170 141201060000   EDEN 361017000790 141201060005 EDEN ELEMENTARY SCHOOL public Regular School No Other 02 09 2018   grade_2 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0             0     *   1 1 0 0   0     0     0   1 0         0       1
2068721 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000495 141501060001 HUTH ROAD SCHOOL public Regular School No Elementary 02 05 2018   grade_2 74.0 1.0 4.0   0.0     4.0     5.0   54.0 34.0     *       24     *   88 74 1 4   0     4     5   54 34         24       88
2068740 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000496 141501060003 KAEGEBEIN SCHOOL public Regular School No Elementary 02 05 2018   grade_2 82.0 0.0 6.0   0.0     8.0     8.0   53.0 51.0     *       *     *   104 82 0 6   0     8     8   53 51                 104
2071533 NY Greene   school 3612870 190701040000   GREENVILLE 361287003484 190701040001 GREENVILLE MIDDLE SCHOOL public Regular School No Middle 02 08 2018   grade_2 1.0 0.0 0.0         0.0     0.0   0.0 1.0     *       *     *   1 1 0 0         0     0   0 1                 1
2072179 NY Herkimer   school 3601087 212101040000   C-V AT ILION-MOHAWK CSD 360108701282 212101040006 BARRINGER ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2018   grade_2 189.0 0.0 4.0         1.0     7.0   95.0 106.0     *       131     25   201 189 0 4         1     7   95 106         131   25   201
2084225 NY Madison   school 3606390 250901060000   CANASTOTA 360639000422 250901060006 SOUTH SIDE ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2018   grade_2 75.0 1.0 2.0   1.0     0.0     5.0   41.0 43.0     *       60     10   84 75 1 2   1     0     5   41 43         60   10   84
2085365 NY Monroe   school 3614700 260901060000   HONEOYE FALLS-LIMA 361470001225 260901060002 MANOR INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2018   grade_2 139.0 2.0 3.0         1.0     7.0   77.0 75.0     *       34     9   152 139 2 3         1     7   77 75         34   9   152
2090001 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004228 280214030002 HEWLETT ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 77.0 5.0 14.0   0.0     10.0     7.0   63.0 50.0     *       *     21   113 77 5 14   0     10     7   63 50             21   113
2090020 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004229 280214030003 OGDEN ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 56.0 7.0 8.0         10.0     2.0   39.0 44.0     8       16     11   83 56 7 8         10     2   39 44     8   16   11   83
2090400 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000947 280218030004 STRATFORD AVENUE SCHOOL public Regular School No Elementary 02 05 2018   grade_2 128.0 1.0 5.0         5.0     5.0   70.0 74.0             *     16   144 128 1 5         5     5   70 74             16   144
2090419 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000946 280218030005 STEWART SCHOOL public Regular School No Elementary 02 05 2018   grade_2 128.0 1.0 3.0         14.0     2.0   74.0 74.0     *       5     25   148 128 1 3         14     2   74 74         5   25   148
2091065 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001322 280226030003 MICHAEL F STOKES SCHOOL public Regular School No Elementary 02 04 2018   grade_2 94.0 1.0 38.0   1.0     11.0     1.0   73.0 73.0     *       *     14   146 94 1 38   1     11     1   73 73             14   146
2091920 NY Nassau   school 3625050 280403030000   ROSLYN 362505003467 280403030004 EAST HILLS ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 69.0 6.0 15.0   0.0     29.0     3.0   60.0 62.0     13       22     9   122 69 6 15   0     29     3   60 62     13   22   9   122
2095017 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502843 307500014811 PS Q811 public Special Education School No Other 02 12 2018   grade_2 0.0 0.0 2.0   0.0     0.0     0.0   1.0 1.0     *       *     *   2 0 0 2   0     0     0   1 1                 2
2104802 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2018   grade_2 99.0 6.0 9.0   1.0     4.0     6.0   60.0 65.0     *       33     13   125 99 6 9   1     4     6   60 65         33   13   125
2107671 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 109.0 14.0 54.0   0.0     18.0     11.0   103.0 103.0     *       54     41   206 109 14 54   0     18     11   103 103         54   41   206
2107690 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001792 441201060002 CENTRAL VALLEY ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 60.0 7.0 45.0   0.0     17.0     3.0   65.0 67.0     *       42     22   132 60 7 45   0     17     3   65 67         42   22   132
2107709 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001796 441201060003 NORTH MAIN STREET SCHOOL public Regular School No Elementary 02 05 2018   grade_2 54.0 6.0 31.0         6.0     5.0   55.0 47.0     9       44     11   102 54 6 31         6     5   55 47     9   44   11   102
2112915 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012304352 342700010056 PS 56 HARRY EICHLER public Regular School No Elementary 02 05 2018   grade_2 8.0 2.0 42.0   5.0     39.0     1.0   48.0 49.0     28       80     13   97 8 2 42   5     39     1   48 49     28   80   13   97
2117361 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001495 490601060009 RENSSELAER PARK ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2123745 NY Steuben   school 3614820 571800010000   HORNELL 361482001230 571800010002 BRYANT SCHOOL public Regular School No Elementary 02 03 2018   grade_2 107.0 5.0 3.0         0.0     5.0   54.0 66.0     *       78     20   120 107 5 3         0     5   54 66         78   20   120
2124771 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004234 580109020001 MARTIN LUTHER KING ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2018   grade_2 3.0 89.0 118.0         0.0     1.0   101.0 110.0     95       206     23   211 3 89 118         0     1   101 110     95   206   23   211
2126899 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000574 580402060002 LLOYD HARBOR SCHOOL public Regular School No Elementary 02 06 2018   grade_2 57.0 1.0 2.0   0.0     5.0     5.0   38.0 32.0     *       *     5   70 57 1 2   0     5     5   38 32             5   70
2126918 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000575 580402060003 WEST SIDE SCHOOL public Regular School No Elementary 02 06 2018   grade_2 34.0   2.0         3.0     0.0   21.0 18.0     *       *     *   39 34   2         3     0   21 18                 39
2127982 NY Suffolk   school 3615540 580502020000   ISLIP 361554001323 580502020002 COMMACK ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 60.0 3.0 42.0   0.0     10.0     6.0   63.0 58.0     17       54     *   121 60 3 42   0     10     6   63 58     17   54       121
2128020 NY Suffolk   school 3615540 580502020000   ISLIP 361554001326 580502020005 MAUD S SHERWOOD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 51.0 3.0 19.0   0.0     1.0     1.0   42.0 33.0     8       27     22   75 51 3 19   0     1     1   42 33     8   27   22   75
2130756 NY Tioga   school 3630270 600101060000   WAVERLY 363027004066 600101060002 ELM STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2018   grade_2 82.0 0.0 2.0         1.0     5.0   50.0 40.0             *     *   90 82 0 2         1     5   50 40                 90
2134404 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000783 660301030001 ANNE HUTCHINSON SCHOOL public Regular School No Elementary 02 05 2018   grade_2 67.0 1.0 13.0   0.0     20.0     4.0   59.0 46.0     11       *     15   105 67 1 13   0     20     4   59 46     11       15   105
2134423 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000786 660301030003 GREENVALE SCHOOL public Regular School No Elementary 02 05 2018   grade_2 93.0 2.0 11.0         32.0     6.0   63.0 81.0     14       *     16   144 93 2 11         32     6   63 81     14       16   144
2135088 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001045 660407060009 HIGHVIEW SCHOOL public Regular School No Elementary 02 03 2018   grade_2 18.0 49.0 62.0         8.0     1.0   75.0 63.0     15       83     25   138 18 49 62         8     1   75 63     15   83   25   138
2135126 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2018   grade_2 4.0 15.0 43.0         9.0     1.0   36.0 36.0     19       38     13   72 4 15 43         9     1   36 36     19   38   13   72
2136703 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No Elementary 02 05 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2136874 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2018   grade_2 25.0 39.0 184.0         4.0     9.0   146.0 115.0     98       218     25   261 25 39 184         4     9   146 115     98   218   25   261
2059563 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2059886 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001376 31502060001 JOHNSON CITY ELEM/INTRMED SCHOOL public Regular School No Other 03 10 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2061482 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000718 60800010010 DUNKIRK MIDDLE SCHOOL public Regular School No Middle 03 08 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2061539 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2062147 NY Chemung   school 3610560 70600010000   ELMIRA 361056000818 70600010010 HENDY AVENUE SCHOOL public Regular School No Elementary 03 06 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2062166 NY Chemung   school 3610560 70600010000   ELMIRA 361056004387 70600010013 PARLEY COBURN SCHOOL public Regular School No Elementary 03 06 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2062223 NY Chemung   school 3610560 70600010000   ELMIRA 361056000825 70600010016 THOMAS K BEECHER SCHOOL public Regular School No Elementary 03 06 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2062299 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   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]);