Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_2", state = "NY" and year = 2020 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_2 · 4,742
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
1555986 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   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
1538848 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Other 01 10 2020   grade_2 5.0 33.0 28.0   0.0     0.0     9.0   46.0 29.0     9       58     12   75 5 33 28   0     0     9   46 29     9   58   12   75
1538867 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2020   grade_2 2.0 34.0 21.0         1.0     8.0   39.0 27.0     5       55     12   66 2 34 21         1     8   39 27     5   55   12   66
1542344 NY Erie   school 3610170 141201060000   EDEN 361017000790 141201060005 EDEN ELEMENTARY SCHOOL public Regular School No Other 01 11 2020   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
1543009 NY Erie   school 3616440 141800010000   LACKAWANNA 361644005578 141800010011 MARTIN ROAD ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 85.0 16.0 21.0   0.0     7.0     10.0   79.0 60.0     35       127     23   139 85 16 21   0     7     10   79 60     35   127   23   139
1545460 NY Greene   school 3615060 190901040000   HUNTER TANNERSVL 361506001259 190901040001 HUNTER-TANNERSVILLE MIDDLE/HIGH SCH public Regular School No Other 01 12 2020   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
1561496 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2020   grade_2 196.0 12.0 25.0   1.0     4.0     14.0   136.0 116.0     *       127     *   252 196 12 25   1     4     14   136 116         127       252
1562218 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2020   grade_2 0.0 29.0 88.0   0.0     1.0     0.0   71.0 47.0     68       81     15   118 0 29 88   0     1     0   71 47     68   81   15   118
1562237 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2020   grade_2 1.0 27.0 67.0   0.0     0.0     1.0   53.0 43.0     52       70     12   96 1 27 67   0     0     1   53 43     52   70   12   96
1562256 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 0.0 13.0 62.0   1.0     1.0     2.0   43.0 36.0     36       56     *   79 0 13 62   1     1     2   43 36     36   56       79
1562275 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2020   grade_2 0.0 9.0 58.0   0.0     0.0     0.0   31.0 36.0     *       49     9   67 0 9 58   0     0     0   31 36         49   9   67
1562332 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No Elementary 01 05 2020   grade_2 0.0 10.0 80.0   0.0     0.0     2.0   45.0 47.0     57       61     *   92 0 10 80   0     0     2   45 47     57   61       92
1562370 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 1.0 8.0 51.0   1.0               41.0 20.0     44       43     12   61 1 8 51   1               41 20     44   43   12   61
1563605 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2020   grade_2 49.0 2.0 11.0         0.0     2.0   43.0 21.0     6       14     13   64 49 2 11         0     2   43 21     6   14   13   64
1563624 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2020   grade_2 54.0 0.0 12.0         3.0     1.0   42.0 28.0     5       9     *   70 54 0 12         3     1   42 28     5   9       70
1563643 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2020   grade_2 35.0 0.0 12.0         2.0     4.0   27.0 26.0     *       9     6   53 35 0 12         2     4   27 26         9   6   53
1563662 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2020   grade_2 45.0 0.0 18.0         4.0     0.0   28.0 39.0     10       15     *   67 45 0 18         4     0   28 39     10   15       67
1563681 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2020   grade_2 38.0 1.0 3.0         3.0     0.0   17.0 28.0     *       5     *   45 38 1 3         3     0   17 28         5       45
1563700 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2020   grade_2 43.0 3.0 17.0         3.0     1.0   34.0 33.0     7       11     *   67 43 3 17         3     1   34 33     7   11       67
1563909 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2020   grade_2 12.0 13.0 33.0   0.0     21.0     3.0   47.0 35.0     10       30     9   82 12 13 33   0     21     3   47 35     10   30   9   82
1564498 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No Elementary 01 05 2020   grade_2 56.0 2.0 16.0   1.0     10.0     4.0   41.0 48.0     *       5     14   89 56 2 16   1     10     4   41 48         5   14   89
1564517 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2020   grade_2 27.0 2.0 4.0   0.0     0.0     1.0   15.0 19.0     *       *     *   34 27 2 4   0     0     1   15 19                 34
1564536 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2020   grade_2 43.0 2.0 20.0   0.0     10.0     2.0   31.0 46.0     *       15     8   77 43 2 20   0     10     2   31 46         15   8   77
1565068 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 03 2020   grade_2 22.0 24.0 63.0         11.0     5.0   47.0 78.0     23       74     19   125 22 24 63         11     5   47 78     23   74   19   125
1565695 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2020   grade_2 6.0 39.0 92.0   0.0     2.0     0.0   75.0 64.0     65       121     18   139 6 39 92   0     2     0   75 64     65   121   18   139
1565714 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2020   grade_2 2.0 12.0 85.0   0.0     1.0     1.0   46.0 55.0     37       78     9   101 2 12 85   0     1     1   46 55     37   78   9   101
1565752 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2020   grade_2 3.0 30.0 65.0   3.0     2.0     0.0   51.0 52.0     31       80     *   103 3 30 65   3     2     0   51 52     31   80       103
1566284 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 15.0 2.0 8.0   0.0     95.0     5.0   68.0 57.0     13       20     8   125 15 2 8   0     95     5   68 57     13   20   8   125
1580819 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 64.0 2.0 20.0   0.0     1.0     4.0   48.0 43.0             24     6   91 64 2 20   0     1     4   48 43         24   6   91
1591326 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001495 490601060009 RENSSELAER PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 2.0 2.0 1.0   0.0     0.0     2.0   4.0 3.0     0       *     *   7 2 2 1   0     0     2   4 3     0           7
1593188 NY Richmond   school 3601213 353100861144   BRIDGE PREPARATORY CHARTER S 360121306694 353100861144 BRIDGE PREPARATORY CHARTER SCHOOL charter Regular School Yes Elementary 01 02 2020   grade_2 17.0 11.0 20.0   1.0     1.0     1.0   28.0 23.0             31     35   51 17 11 20   1     1     1   28 23         31   35   51
1598622 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2020   grade_2 6.0 77.0 138.0   3.0     1.0     10.0   133.0 102.0     55       203     23   235 6 77 138   3     1     10   133 102     55   203   23   235
1599629 NY Suffolk   school 3624840 580209020000   ROCKY POINT 362484003437 580209020002 ROCKY POINT HIGH SCHOOL public Regular School No Other 01 12 2020   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
1599705 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2020   grade_2 38.0 1.0 12.0         5.0     4.0   38.0 22.0     *       19     22   60 38 1 12         5     4   38 22         19   22   60
1599724 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2020   grade_2 26.0 1.0 15.0   0.0     4.0     1.0   23.0 24.0             21     *   47 26 1 15   0     4     1   23 24         21       47
1599743 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2020   grade_2 35.0 5.0 29.0         10.0     4.0   45.0 38.0     17       32     15   83 35 5 29         10     4   45 38     17   32   15   83
1599781 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No Elementary 01 05 2020   grade_2 32.0 0.0 8.0         3.0     1.0   22.0 22.0     *       13     9   44 32 0 8         3     1   22 22         13   9   44
1599876 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 41.0 4.0 19.0         4.0     4.0   34.0 38.0             28     22   72 41 4 19         4     4   34 38         28   22   72
1599914 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 85.0 9.0 54.0         12.0     6.0   77.0 89.0     11       72     28   166 85 9 54         12     6   77 89     11   72   28   166
1602859 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 3.0 8.0 116.0         0.0     2.0   76.0 53.0     64       124     *   129 3 8 116         0     2   76 53     64   124       129
1602878 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 5.0 11.0 130.0   0.0     0.0     1.0   79.0 68.0     62       140     10   147 5 11 130   0     0     1   79 68     62   140   10   147
1602897 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 3.0 10.0 163.0   2.0     2.0     1.0   82.0 99.0     81       172     27   181 3 10 163   2     2     1   82 99     81   172   27   181
1602916 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 2.0 7.0 201.0   0.0     1.0     1.0   99.0 113.0     102       204     30   212 2 7 201   0     1     1   99 113     102   204   30   212
1602973 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 1.0 10.0 124.0   2.0     1.0     1.0   72.0 67.0     58       129     19   139 1 10 124   2     1     1   72 67     58   129   19   139
1602992 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 5.0 10.0 137.0         1.0     2.0   69.0 86.0     74       145     23   155 5 10 137         1     2   69 86     74   145   23   155
1608673 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 2020   grade_2 57.0 7.0 123.0         6.0     9.0   116.0 86.0     49       110     23   202 57 7 123         6     9   116 86     49   110   23   202
1610706 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2020   grade_2 73.0 24.0 237.0         11.0     8.0   176.0 177.0     59       223     28   353 73 24 237         11     8   176 177     59   223   28   353
1536454 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2020   grade_2 55.0 1.0 3.0         1.0     1.0   33.0 28.0             39     9   61 55 1 3         1     1   33 28         39   9   61
1538791 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2020   grade_2 45.0 0.0 8.0         0.0     9.0   35.0 27.0     *       29     7   62 45 0 8         0     9   35 27         29   7   62
1542572 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000495 141501060001 HUTH ROAD SCHOOL public Regular School No Elementary 02 05 2020   grade_2 95.0 2.0 4.0   0.0     2.0     9.0   51.0 61.0     *       21     12   112 95 2 4   0     2     9   51 61         21   12   112
1542591 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000496 141501060003 KAEGEBEIN SCHOOL public Regular School No Elementary 02 05 2020   grade_2 92.0 0.0 2.0   1.0     2.0     5.0   55.0 47.0     *       29     *   102 92 0 2   1     2     5   55 47         29       102
1544605 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2020   grade_2 87.0   10.0   0.0     5.0     6.0   56.0 52.0     *       55     9   108 87   10   0     5     6   56 52         55   9   108
1546030 NY Herkimer   school 3601087 212101040000   C-V AT ILION-MOHAWK CSD 360108701282 212101040006 BARRINGER ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2020   grade_2 154.0 2.0 3.0         2.0     11.0   77.0 95.0     *       107     24   172 154 2 3         2     11   77 95         107   24   172
1558171 NY Madison   school 3606390 250901060000   CANASTOTA 360639000422 250901060006 SOUTH SIDE ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2020   grade_2 87.0   5.0         1.0     3.0   45.0 51.0     *       55     14   96 87   5         1     3   45 51         55   14   96
1559311 NY Monroe   school 3614700 260901060000   HONEOYE FALLS-LIMA 361470001225 260901060002 MANOR INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2020   grade_2 144.0 1.0 5.0         1.0     8.0   81.0 78.0     *       31     *   159 144 1 5         1     8   81 78         31       159
1563966 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004228 280214030002 HEWLETT ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_2 53.0 10.0 18.0   0.0     5.0     2.0   39.0 49.0     *       24     *   88 53 10 18   0     5     2   39 49         24       88
1563985 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004229 280214030003 OGDEN ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_2 45.0 9.0 20.0   1.0     9.0     0.0   38.0 46.0     15       33     *   84 45 9 20   1     9     0   38 46     15   33       84
1564346 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000947 280218030004 STRATFORD AVENUE SCHOOL public Regular School No Elementary 02 05 2020   grade_2 138.0 1.0 11.0         9.0     5.0   87.0 77.0     *       *     20   164 138 1 11         9     5   87 77             20   164
1564365 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000946 280218030005 STEWART SCHOOL public Regular School No Elementary 02 05 2020   grade_2 140.0 1.0 24.0         18.0     5.0   98.0 90.0     *       8     40   188 140 1 24         18     5   98 90         8   40   188
1565011 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001322 280226030003 MICHAEL F STOKES SCHOOL public Regular School No Elementary 02 04 2020   grade_2 90.0 2.0 29.0   1.0     28.0     3.0   78.0 75.0     *       *     19   153 90 2 29   1     28     3   78 75             19   153
1565866 NY Nassau   school 3625050 280403030000   ROSLYN 362505003467 280403030004 EAST HILLS ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_2 97.0 6.0 19.0   0.0     22.0     2.0   67.0 79.0     13       28     10   146 97 6 19   0     22     2   67 79     13   28   10   146
1573827 NY New York   school 3600142 310400861061   NYC AUTISM CHARTER-EAST HARLE 360014205779 310400861061 NYC AUTISM CHARTER SCHOOL EAST HARLE charter Special Education School Yes Other 02 12 2020   grade_2 0.0 2.0 2.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 0 2 2   0     0     0   4 0                 4
1578672 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2020   grade_2 117.0 5.0 7.0   0.0     2.0     7.0   66.0 72.0     *       31     15   138 117 5 7   0     2     7   66 72         31   15   138
1580382 NY Ontario   school 3611970 430700010000   GENEVA 361197000965 430700010002 NORTH STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_2 60.0 13.0 51.0         4.0     25.0   66.0 87.0     23       113     16   153 60 13 51         4     25   66 87     23   113   16   153
1581522 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_2 81.0 24.0 70.0   1.0     14.0     10.0   98.0 102.0     14       81     38   200 81 24 70   1     14     10   98 102     14   81   38   200
1581541 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001792 441201060002 CENTRAL VALLEY ELEMENTARY SCHOOL public Regular School No Elementary 02 07 2020   grade_2 38.0 14.0 41.0   0.0     8.0     5.0   61.0 45.0     6       39     12   106 38 14 41   0     8     5   61 45     6   39   12   106
1581560 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001796 441201060003 NORTH MAIN STREET SCHOOL public Regular School No Elementary 02 05 2020   grade_2 49.0 6.0 50.0         7.0     6.0   55.0 63.0     17       53     13   118 49 6 50         7     6   55 63     17   53   13   118
1586785 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012304352 342700010056 PS 56 HARRY EICHLER public Regular School No Elementary 02 05 2020   grade_2 18.0 3.0 58.0   4.0     26.0     2.0   59.0 52.0     35       90     21   111 18 3 58   4     26     2   59 52     35   90   21   111
1597767 NY Steuben   school 3614820 571800010000   HORNELL 361482001230 571800010002 BRYANT SCHOOL public Regular School No Elementary 02 04 2020   grade_2 106.0 4.0 4.0         4.0     6.0   59.0 65.0     *       74     *   124 106 4 4         4     6   59 65         74       124
1600921 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000574 580402060002 LLOYD HARBOR SCHOOL public Regular School No Elementary 02 06 2020   grade_2 67.0   3.0   0.0     2.0     5.0   32.0 45.0     *       *     6   77 67   3   0     2     5   32 45             6   77
1600940 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000575 580402060003 WEST SIDE SCHOOL public Regular School No Elementary 02 06 2020   grade_2 32.0 0.0 0.0         4.0     1.0   17.0 20.0     *       *     *   37 32 0 0         4     1   17 20                 37
1601700 NY Suffolk   school 3608130 580410030000   COMMACK 360813000591 580410030021 SAWMILL INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2020   grade_2 1.0 1.0 0.0   0.0     0.0     0.0   1.0 1.0     0       0     *   2 1 1 0   0     0     0   1 1     0   0       2
1602004 NY Suffolk   school 3615540 580502020000   ISLIP 361554001323 580502020002 COMMACK ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_2 44.0 7.0 25.0         8.0     5.0   48.0 41.0     15       37     *   89 44 7 25         8     5   48 41     15   37       89
1602042 NY Suffolk   school 3615540 580502020000   ISLIP 361554001326 580502020005 MAUD S SHERWOOD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_2 46.0 3.0 14.0         2.0     3.0   31.0 37.0     *       15     17   68 46 3 14         2     3   31 37         15   17   68
1604056 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No Other 02 09 2020   grade_2 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     0       0     *   1 1 0 0   0     0     0   0 1     0   0       1
1604797 NY Tioga   school 3630270 600101060000   WAVERLY 363027004066 600101060002 ELM STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2020   grade_2 111.0 1.0 1.0   1.0     2.0     2.0   53.0 65.0     *       79     24   118 111 1 1   1     2     2   53 65         79   24   118
1608445 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000783 660301030001 ANNE HUTCHINSON SCHOOL public Regular School No Elementary 02 06 2020   grade_2 69.0 3.0 23.0   0.0     17.0     4.0   57.0 59.0     15       *     15   116 69 3 23   0     17     4   57 59     15       15   116
1608464 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000786 660301030003 GREENVALE SCHOOL public Regular School No Elementary 02 05 2020   grade_2 92.0 1.0 12.0         29.0     6.0   75.0 65.0     12       *     16   140 92 1 12         29     6   75 65     12       16   140
1609129 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001045 660407060009 HIGHVIEW SCHOOL public Regular School No Elementary 02 03 2020   grade_2 21.0 33.0 54.0   1.0     9.0     4.0   71.0 51.0     10       60     14   122 21 33 54   1     9     4   71 51     10   60   14   122
1609167 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2020   grade_2 2.0 14.0 41.0         5.0     1.0   32.0 31.0     11       37     *   63 2 14 41         5     1   32 31     11   37       63
1609224 NY Westchester   school 3612400 660410020000   GREENBURGH-GRAHAM 361240004295 660410020002 MARTIN LUTHER KING JR HIGH SCHOOL public Special Education School No Other 02 12 2020   grade_2 0.0 0.0 1.0                   1.0 0.0             *     *   1 0 0 1                   1 0                 1
1610896 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2020   grade_2 26.0 29.0 209.0         3.0     11.0   144.0 134.0     113       214     29   278 26 29 209         3     11   144 134     113   214   29   278
1533395 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   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
1533718 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001376 31502060001 JOHNSON CITY ELEM/INTRMED SCHOOL public Regular School No Elementary 03 05 2020   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
1534269 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2020   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
1535390 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1536017 NY Chemung   school 3610560 70600010000   ELMIRA 361056000818 70600010010 HENDY AVENUE SCHOOL public Regular School No Elementary 03 06 2020   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
1536036 NY Chemung   school 3610560 70600010000   ELMIRA 361056004387 70600010013 PARLEY COBURN SCHOOL public Regular School No Elementary 03 06 2020   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
1536093 NY Chemung   school 3610560 70600010000   ELMIRA 361056000825 70600010016 THOMAS K BEECHER SCHOOL public Regular School No Elementary 03 06 2020   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
1536169 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2020   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
1536511 NY Chenango   school 3612750 80601040000   GREENE 361275001051 80601040002 GREENE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   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
1536568 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001901976 81003040003 UNADILLA VALLEY SECONDARY SCHOOL public Regular School No Other 03 12 2020   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
1536606 NY Chenango   school 3621330 81200050000   NORWICH 362133003041 81200050001 PERRY BROWNE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   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
1537214 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2020   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
1537765 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 FE SMITH INTERMEDIATE SCHOOL public Regular School No Elementary 03 04 2020   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
1537898 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   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
1538506 NY Dutchess   school 3609210 130502020000   DOVER 360921000706 130502020002 DOVER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   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
1539076 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No Elementary 03 05 2020   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
1539133 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No Elementary 03 05 2020   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
1539190 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000430 131602020001 HAGAN SCHOOL public Regular School No Elementary 03 05 2020   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]);