Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_1 · 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
1555982 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1538844 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Other 01 10 2020   grade_1 3.0 22.0 35.0   0.0     0.0     2.0   33.0 29.0     17       57     *   62 3 22 35   0     0     2   33 29     17   57       62
1538863 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2020   grade_1 5.0 43.0 19.0         0.0     5.0   33.0 39.0     8       61     16   72 5 43 19         0     5   33 39     8   61   16   72
1542340 NY Erie   school 3610170 141201060000   EDEN 361017000790 141201060005 EDEN ELEMENTARY SCHOOL public Regular School No Other 01 11 2020   grade_1 1.0 0.0 0.0   0.0           0.0   1.0 0.0             0     *   1 1 0 0   0           0   1 0         0       1
1543005 NY Erie   school 3616440 141800010000   LACKAWANNA 361644005578 141800010011 MARTIN ROAD ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 3.0 0.0 0.0   0.0     0.0     0.0   2.0 1.0     0       *     *   3 3 0 0   0     0     0   2 1     0           3
1545456 NY Greene   school 3615060 190901040000   HUNTER TANNERSVL 361506001259 190901040001 HUNTER-TANNERSVILLE MIDDLE/HIGH SCH public Regular School No Other 01 12 2020   grade_1 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1561492 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2020   grade_1 0.0 0.0 0.0   0.0     0.0     1.0   1.0 0.0     0       *     *   1 0 0 0   0     0     1   1 0     0           1
1562214 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2020   grade_1 0.0 29.0 69.0   1.0     0.0     3.0   48.0 54.0     49       *     17   102 0 29 69   1     0     3   48 54     49       17   102
1562233 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2020   grade_1 0.0 19.0 52.0   0.0     3.0     0.0   32.0 42.0     42       45     *   74 0 19 52   0     3     0   32 42     42   45       74
1562252 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 2.0 15.0 56.0   1.0     0.0     1.0   40.0 35.0     35       50     *   75 2 15 56   1     0     1   40 35     35   50       75
1562271 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2020   grade_1 0.0 5.0 71.0   0.0     0.0     0.0   38.0 38.0     60       49     *   76 0 5 71   0     0     0   38 38     60   49       76
1562328 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No Elementary 01 05 2020   grade_1 1.0 13.0 60.0   0.0     1.0     0.0   45.0 30.0     43       40     *   75 1 13 60   0     1     0   45 30     43   40       75
1562366 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 1.0 2.0 66.0   0.0               41.0 28.0     44       38     *   69 1 2 66   0               41 28     44   38       69
1563601 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2020   grade_1 35.0 3.0 17.0         2.0     4.0   30.0 31.0     7       13     *   61 35 3 17         2     4   30 31     7   13       61
1563620 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2020   grade_1 71.0 1.0 16.0         7.0     1.0   47.0 49.0     6       13     *   96 71 1 16         7     1   47 49     6   13       96
1563639 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2020   grade_1 29.0 0.0 7.0         2.0     1.0   20.0 19.0     0       6     7   39 29 0 7         2     1   20 19     0   6   7   39
1563658 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2020   grade_1 56.0 4.0 20.0         5.0     2.0   47.0 40.0     7       15     14   87 56 4 20         5     2   47 40     7   15   14   87
1563677 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2020   grade_1 33.0 0.0 10.0         2.0     2.0   25.0 22.0     *       *     6   47 33 0 10         2     2   25 22             6   47
1563696 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2020   grade_1 55.0 0.0 16.0         4.0     1.0   33.0 43.0     8       13     *   76 55 0 16         4     1   33 43     8   13       76
1563905 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2020   grade_1 5.0 17.0 31.0   1.0     21.0     2.0   45.0 32.0     10       30     8   77 5 17 31   1     21     2   45 32     10   30   8   77
1564494 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001608 280220030002 MARION STREET SCHOOL public Regular School No Elementary 01 05 2020   grade_1 75.0 2.0 16.0   0.0     4.0     5.0   53.0 49.0     *       10     13   102 75 2 16   0     4     5   53 49         10   13   102
1564513 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2020   grade_1 30.0 2.0 6.0   0.0     3.0     4.0   24.0 21.0     *       *     7   45 30 2 6   0     3     4   24 21             7   45
1564532 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2020   grade_1 51.0 7.0 17.0   0.0     3.0     7.0   38.0 47.0     *       13     10   85 51 7 17   0     3     7   38 47         13   10   85
1565064 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 03 2020   grade_1 25.0 19.0 59.0         9.0     2.0   63.0 51.0     17       *     *   114 25 19 59         9     2   63 51     17           114
1565691 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2020   grade_1 3.0 29.0 104.0   2.0     0.0     0.0   70.0 68.0     74       125     14   138 3 29 104   2     0     0   70 68     74   125   14   138
1565710 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2020   grade_1 8.0 12.0 93.0   2.0     1.0     0.0   51.0 65.0     52       90     11   116 8 12 93   2     1     0   51 65     52   90   11   116
1565748 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2020   grade_1 3.0 23.0 68.0   0.0     0.0     0.0   45.0 49.0     46       85     *   94 3 23 68   0     0     0   45 49     46   85       94
1566280 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 17.0 2.0 13.0   0.0     87.0     4.0   72.0 51.0     17       20     18   123 17 2 13   0     87     4   72 51     17   20   18   123
1580815 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 42.0 3.0 17.0   0.0     2.0     3.0   24.0 43.0             13     *   67 42 3 17   0     2     3   24 43         13       67
1591322 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001495 490601060009 RENSSELAER PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 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
1593184 NY Richmond   school 3601213 353100861144   BRIDGE PREPARATORY CHARTER S 360121306694 353100861144 BRIDGE PREPARATORY CHARTER SCHOOL charter Regular School Yes Elementary 01 02 2020   grade_1 10.0 12.0 14.0   0.0     0.0     0.0   23.0 13.0             27     22   36 10 12 14   0     0     0   23 13         27   22   36
1598618 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2020   grade_1 10.0 66.0 127.0   0.0     2.0     11.0   104.0 112.0     38       174     27   216 10 66 127   0     2     11   104 112     38   174   27   216
1599625 NY Suffolk   school 3624840 580209020000   ROCKY POINT 362484003437 580209020002 ROCKY POINT HIGH SCHOOL public Regular School No Other 01 12 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1599701 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2020   grade_1 36.0 3.0 26.0         6.0     5.0   41.0 35.0     6       35     21   76 36 3 26         6     5   41 35     6   35   21   76
1599720 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2020   grade_1 22.0 3.0 15.0   0.0     4.0     2.0   20.0 26.0             19     *   46 22 3 15   0     4     2   20 26         19       46
1599739 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2020   grade_1 28.0 2.0 25.0         5.0     2.0   36.0 26.0     11       27     13   62 28 2 25         5     2   36 26     11   27   13   62
1599777 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No Elementary 01 05 2020   grade_1 29.0 2.0 10.0         1.0     1.0   16.0 27.0     *       17     *   43 29 2 10         1     1   16 27         17       43
1599872 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 42.0 4.0 22.0         2.0     4.0   35.0 39.0             26     17   74 42 4 22         2     4   35 39         26   17   74
1599910 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 94.0 6.0 38.0         9.0     6.0   79.0 74.0     6       60     27   153 94 6 38         9     6   79 74     6   60   27   153
1602855 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 1.0 4.0 83.0         0.0     1.0   45.0 44.0     49       81     *   89 1 4 83         0     1   45 44     49   81       89
1602874 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 0.0 12.0 131.0   1.0     0.0     1.0   61.0 84.0     81       137     12   145 0 12 131   1     0     1   61 84     81   137   12   145
1602893 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 5.0 9.0 135.0   0.0     3.0     0.0   71.0 81.0     74       143     12   152 5 9 135   0     3     0   71 81     74   143   12   152
1602912 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 3.0 16.0 183.0   0.0     1.0     0.0   100.0 103.0     94       197     18   203 3 16 183   0     1     0   100 103     94   197   18   203
1602969 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 2.0 12.0 120.0   0.0     1.0     0.0   70.0 65.0     54       122     21   135 2 12 120   0     1     0   70 65     54   122   21   135
1602988 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_1 3.0 8.0 154.0         2.0     0.0   80.0 87.0     79       150     14   167 3 8 154         2     0   80 87     79   150   14   167
1608669 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 2020   grade_1 63.0 4.0 106.0         9.0     14.0   95.0 101.0     51       98     10   196 63 4 106         9     14   95 101     51   98   10   196
1610702 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2020   grade_1 60.0 23.0 211.0         17.0     13.0   171.0 153.0     47       193     26   324 60 23 211         17     13   171 153     47   193   26   324
1536450 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1538787 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1542568 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000495 141501060001 HUTH ROAD SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1542587 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000496 141501060003 KAEGEBEIN SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1544601 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2020   grade_1 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
1546026 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_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1558167 NY Madison   school 3606390 250901060000   CANASTOTA 360639000422 250901060006 SOUTH SIDE ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2020   grade_1 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
1559307 NY Monroe   school 3614700 260901060000   HONEOYE FALLS-LIMA 361470001225 260901060002 MANOR INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1563962 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004228 280214030002 HEWLETT ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1563981 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004229 280214030003 OGDEN ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1564342 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000947 280218030004 STRATFORD AVENUE SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1564361 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000946 280218030005 STEWART SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1565007 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001322 280226030003 MICHAEL F STOKES SCHOOL public Regular School No Elementary 02 04 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1565862 NY Nassau   school 3625050 280403030000   ROSLYN 362505003467 280403030004 EAST HILLS ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1573823 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_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1578668 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1580378 NY Ontario   school 3611970 430700010000   GENEVA 361197000965 430700010002 NORTH STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1581518 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1581537 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001792 441201060002 CENTRAL VALLEY ELEMENTARY SCHOOL public Regular School No Elementary 02 07 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1581556 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001796 441201060003 NORTH MAIN STREET SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1586781 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_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1597763 NY Steuben   school 3614820 571800010000   HORNELL 361482001230 571800010002 BRYANT SCHOOL public Regular School No Elementary 02 04 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1600917 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000574 580402060002 LLOYD HARBOR SCHOOL public Regular School No Elementary 02 06 2020   grade_1 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
1600936 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000575 580402060003 WEST SIDE SCHOOL public Regular School No Elementary 02 06 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       *     0   0 0 0 0         0     0   0 0             0   0
1601696 NY Suffolk   school 3608130 580410030000   COMMACK 360813000591 580410030021 SAWMILL INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1602000 NY Suffolk   school 3615540 580502020000   ISLIP 361554001323 580502020002 COMMACK ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1602038 NY Suffolk   school 3615540 580502020000   ISLIP 361554001326 580502020005 MAUD S SHERWOOD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1604052 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No Other 02 09 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1604793 NY Tioga   school 3630270 600101060000   WAVERLY 363027004066 600101060002 ELM STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1608441 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000783 660301030001 ANNE HUTCHINSON SCHOOL public Regular School No Elementary 02 06 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1608460 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000786 660301030003 GREENVALE SCHOOL public Regular School No Elementary 02 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       *     0   0 0 0 0         0     0   0 0     0       0   0
1609125 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001045 660407060009 HIGHVIEW SCHOOL public Regular School No Elementary 02 03 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1609163 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1609220 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_1 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1610892 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1533391 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533714 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001376 31502060001 JOHNSON CITY ELEM/INTRMED SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1534265 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1535386 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1536013 NY Chemung   school 3610560 70600010000   ELMIRA 361056000818 70600010010 HENDY AVENUE SCHOOL public Regular School No Elementary 03 06 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1536032 NY Chemung   school 3610560 70600010000   ELMIRA 361056004387 70600010013 PARLEY COBURN SCHOOL public Regular School No Elementary 03 06 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1536089 NY Chemung   school 3610560 70600010000   ELMIRA 361056000825 70600010016 THOMAS K BEECHER SCHOOL public Regular School No Elementary 03 06 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1536165 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2020   grade_1 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1536507 NY Chenango   school 3612750 80601040000   GREENE 361275001051 80601040002 GREENE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
1536564 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001901976 81003040003 UNADILLA VALLEY SECONDARY SCHOOL public Regular School No Other 03 12 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1536602 NY Chenango   school 3621330 81200050000   NORWICH 362133003041 81200050001 PERRY BROWNE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1537210 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1537761 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 FE SMITH INTERMEDIATE SCHOOL public Regular School No Elementary 03 04 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1537894 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1538502 NY Dutchess   school 3609210 130502020000   DOVER 360921000706 130502020002 DOVER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1539072 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1539129 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No Elementary 03 05 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1539186 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000430 131602020001 HAGAN SCHOOL public Regular School No Elementary 03 05 2020   grade_1 0.0 0.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]);