Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_4 · 4,719
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ▼ ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2152304 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No Elementary 01 06 2019   grade_4 53.0 0.0 1.0         0.0     4.0   31.0 27.0             38     12   58 53 0 1         0     4   31 27         38   12   58
2154698 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Other 01 09 2019   grade_4 4.0 41.0 30.0   0.0     0.0     2.0   41.0 36.0     12       65     21   77 4 41 30   0     0     2   41 36     12   65   21   77
2154717 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 07 2019   grade_4 2.0 32.0 13.0         0.0     1.0   21.0 27.0     *       *     8   48 2 32 13         0     1   21 27             8   48
2159562 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 57.0 3.0 5.0   0.0     0.0     2.0   27.0 40.0             40     7   67 57 3 5   0     0     2   27 40         40   7   67
2177954 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 05 2019   grade_4 3.0 30.0 83.0   0.0     0.0     0.0   55.0 61.0     *       93     5   116 3 30 83   0     0     0   55 61         93   5   116
2177973 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 05 2019   grade_4 5.0 50.0 73.0   2.0     2.0     0.0   65.0 67.0     47       114     19   132 5 50 73   2     2     0   65 67     47   114   19   132
2177992 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 3.0 21.0 55.0   0.0     0.0     1.0   38.0 42.0     26       63     8   80 3 21 55   0     0     1   38 42     26   63   8   80
2178011 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 05 2019   grade_4 0.0 16.0 56.0         1.0     2.0   34.0 41.0     35       62     9   75 0 16 56         1     2   34 41     35   62   9   75
2178068 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No Elementary 01 05 2019   grade_4 6.0 23.0 89.0   0.0     1.0     0.0   72.0 47.0     44       99     19   119 6 23 89   0     1     0   72 47     44   99   19   119
2178106 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004772 280201030011 FRONT STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 1.0 11.0 60.0   1.0     0.0         37.0 36.0     28       65     7   73 1 11 60   1     0         37 36     28   65   7   73
2178847 NY Nassau   school 3626400 280206030000   SEAFORD 362640003618 280206030005 SEAFORD MIDDLE SCHOOL public Regular School No Other 01 09 2019   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2179341 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2019   grade_4 50.0 4.0 9.0         2.0     3.0   37.0 31.0     *       14     *   68 50 4 9         2     3   37 31         14       68
2179360 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2019   grade_4 60.0 4.0 27.0         3.0     2.0   50.0 46.0     *       23     15   96 60 4 27         3     2   50 46         23   15   96
2179398 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2019   grade_4 58.0 2.0 32.0         1.0     5.0   54.0 44.0     9       26     10   98 58 2 32         1     5   54 44     9   26   10   98
2179417 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2019   grade_4 28.0 0.0 3.0         5.0     1.0   21.0 16.0     0       *     *   37 28 0 3         5     1   21 16     0           37
2179436 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003064 280211030008 SCHOOL 8 public Regular School No Elementary 01 06 2019   grade_4 51.0 0.0 16.0         4.0     1.0   39.0 33.0     6       11     14   72 51 0 16         4     1   39 33     6   11   14   72
2179645 NY Nassau   school 3629430 280213020000   VALLEY STR HEMP 13 362943003971 280213020003 WHEELER AVENUE SCHOOL public Regular School No Elementary 01 06 2019   grade_4 19.0 19.0 46.0   2.0     21.0     7.0   64.0 50.0     *       36     16   114 19 19 46   2     21     7   64 50         36   16   114
2180253 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001609 280220030003 WAVERLY PARK SCHOOL public Regular School No Elementary 01 05 2019   grade_4 23.0 4.0 2.0   0.0     1.0         16.0 14.0             *     6   30 23 4 2   0     1         16 14             6   30
2180272 NY Nassau   school 3617910 280220030000   LYNBROOK 361791001610 280220030004 WEST END SCHOOL public Regular School No Elementary 01 05 2019   grade_4 37.0 4.0 21.0   2.0     3.0     3.0   36.0 34.0     *       14     12   70 37 4 21   2     3     3   36 34         14   12   70
2180804 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004121 280227030002 CORNWELL AVENUE SCHOOL public Regular School No Elementary 01 03 2019   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2181431 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2019   grade_4 0.0 50.0 124.0         1.0     0.0   88.0 87.0     68       163     10   175 0 50 124         1     0   88 87     68   163   10   175
2181450 NY Nassau   school 3630960 280401030000   WESTBURY 363096004157 280401030002 DREXEL AVENUE SCHOOL public Regular School No Elementary 01 05 2019   grade_4 2.0 7.0 108.0   0.0     1.0     0.0   69.0 49.0     36       109     12   118 2 7 108   0     1     0   69 49     36   109   12   118
2181488 NY Nassau   school 3630960 280401030000   WESTBURY 363096004160 280401030005 POWELLS LANE SCHOOL public Regular School No Elementary 01 05 2019   grade_4 3.0 22.0 71.0   1.0     3.0     0.0   57.0 43.0     40       85     13   100 3 22 71   1     3     0   57 43     40   85   13   100
2181640 NY Nassau   school 3625050 280403030000   ROSLYN 362505003469 280403030007 HARBOR HILL SCHOOL public Regular School No Elementary 01 05 2019   grade_4 77.0 0.0 6.0         22.0     1.0   46.0 60.0     5       13     10   106 77 0 6         22     1   46 60     5   13   10   106
2184357 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502826 307500013370 PS 370 public Special Education School No Other 01 11 2019   grade_4 2.0 8.0 4.0   0.0     0.0     1.0   14.0 1.0     *       15     15   15 2 8 4   0     0     1   14 1         15   15   15
2196555 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004036 440102060001 LITTLE BRITAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 51.0 13.0 21.0   0.0     1.0     3.0   39.0 50.0             15     6   89 51 13 21   0     1     3   39 50         15   6   89
2213389 NY Steuben   school 3614820 571800010000   HORNELL 361482001230 571800010002 BRYANT SCHOOL public Regular School No Elementary 01 03 2019   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2214244 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2019   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2215308 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001738 580211060002 HAWKINS PATH SCHOOL public Regular School No Elementary 01 05 2019   grade_4 37.0 4.0 7.0         2.0     5.0   29.0 26.0             22     15   55 37 4 7         2     5   29 26         22   15   55
2215327 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001739 580211060003 HOLBROOK ROAD SCHOOL public Regular School No Elementary 01 05 2019   grade_4 56.0 0.0 13.0         2.0     3.0   35.0 39.0     0       22     17   74 56 0 13         2     3   35 39     0   22   17   74
2215346 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001743 580211060004 NORTH COLEMAN ROAD SCHOOL public Regular School No Elementary 01 05 2019   grade_4 38.0 0.0 16.0         3.0     5.0   31.0 31.0     0       28     *   62 38 0 16         3     5   31 31     0   28       62
2215365 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001744 580211060005 OXHEAD ROAD SCHOOL public Regular School No Elementary 01 05 2019   grade_4 35.0 6.0 19.0         2.0     0.0   30.0 32.0     11       *     *   62 35 6 19         2     0   30 32     11           62
2215403 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001749 580211060007 EUGENE AUER MEMORIAL SCHOOL public Regular School No Elementary 01 05 2019   grade_4 46.0 2.0 11.0         1.0     1.0   34.0 27.0             18     *   61 46 2 11         1     1   34 27         18       61
2215479 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001747 580211060014 STAGECOACH SCHOOL public Regular School No Elementary 01 05 2019   grade_4 54.0 4.0 36.0         6.0     4.0   63.0 41.0     14       52     34   104 54 4 36         6     4   63 41     14   52   34   104
2215498 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001740 580211060015 JERICHO ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 64.0 1.0 15.0         6.0     1.0   38.0 49.0             34     20   87 64 1 15         6     1   38 49         34   20   87
2215536 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 64.0 8.0 49.0   0.0     10.0     9.0   74.0 66.0     13       64     17   140 64 8 49   0     10     9   74 66     13   64   17   140
2218481 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 3.0 11.0 110.0         3.0     0.0   80.0 47.0     50       122     29   127 3 11 110         3     0   80 47     50   122   29   127
2218500 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 2.0 10.0 134.0   0.0     0.0     2.0   66.0 82.0     60       142     11   148 2 10 134   0     0     2   66 82     60   142   11   148
2218519 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 3.0 12.0 165.0   0.0     3.0     3.0   92.0 94.0     72       177     31   186 3 12 165   0     3     3   92 94     72   177   31   186
2218538 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 1.0 18.0 199.0   1.0     2.0     0.0   114.0 107.0     82       214     30   221 1 18 199   1     2     0   114 107     82   214   30   221
2218595 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000259 580512030012 SOUTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 1.0 5.0 119.0   1.0     1.0     0.0   56.0 71.0     55       114     7   127 1 5 119   1     1     0   56 71     55   114   7   127
2218614 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_4 3.0 8.0 160.0   0.0     4.0     1.0   90.0 86.0     64       169     22   176 3 8 160   0     4     1   90 86     64   169   22   176
2219678 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003744 580906030002 SOUTHAMPTON INTERMEDIATE SCHOOL public Regular School No Middle 01 08 2019   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2224295 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 2019   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2225340 NY Westchester   school 3614070 660803020000   HAWTHORNE KNOLLS 361407001149 660803020001 HAWTHORNE CEDAR KNOLLS SR/JR HS public Special Education School No Other 01 12 2019   grade_4 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
2226347 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2019   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2152418 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001901976 81003040003 UNADILLA VALLEY SECONDARY SCHOOL public Regular School No Other 02 12 2019   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2154641 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2019   grade_4 43.0   9.0         0.0     6.0   23.0 35.0     *       28     11   58 43   9         0     6   23 35         28   11   58
2158213 NY Erie   school 3610170 141201060000   EDEN 361017000790 141201060005 EDEN ELEMENTARY SCHOOL public Regular School No Other 02 10 2019   grade_4 93.0 1.0 1.0   0.0           3.0   54.0 44.0             32     20   98 93 1 1   0           3   54 44         32   20   98
2158441 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000495 141501060001 HUTH ROAD SCHOOL public Regular School No Elementary 02 05 2019   grade_4 104.0 3.0 5.0   1.0     2.0     12.0   60.0 67.0     *       33     9   127 104 3 5   1     2     12   60 67         33   9   127
2158460 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000496 141501060003 KAEGEBEIN SCHOOL public Regular School No Elementary 02 05 2019   grade_4 89.0 3.0 5.0   0.0     4.0     3.0   47.0 57.0     *       34     12   104 89 3 5   0     4     3   47 57         34   12   104
2158878 NY Erie   school 3616440 141800010000   LACKAWANNA 361644005578 141800010011 MARTIN ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 87.0 24.0 27.0   1.0     5.0     5.0   72.0 77.0     35       123     29   149 87 24 27   1     5     5   72 77     35   123   29   149
2160474 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2019   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2160759 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 138.0 21.0 18.0   1.0     1.0     2.0   84.0 97.0     *       110     20   181 138 21 18   1     1     2   84 97         110   20   181
2161918 NY Herkimer   school 3601087 212101040000   C-V AT ILION-MOHAWK CSD 360108701282 212101040006 BARRINGER ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2019   grade_4 136.0 4.0 1.0         0.0     5.0   70.0 76.0     *       *     34   146 136 4 1         0     5   70 76             34   146
2173907 NY Madison   school 3606390 250901060000   CANASTOTA 360639000422 250901060006 SOUTH SIDE ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2019   grade_4 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2175047 NY Monroe   school 3614700 260901060000   HONEOYE FALLS-LIMA 361470001225 260901060002 MANOR INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2019   grade_4 132.0 2.0 2.0         0.0     2.0   75.0 63.0     *       32     14   138 132 2 2         0     2   75 63         32   14   138
2179702 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004228 280214030002 HEWLETT ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 69.0 8.0 25.0   0.0     8.0     1.0   63.0 48.0     *       26     18   111 69 8 25   0     8     1   63 48         26   18   111
2179721 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004229 280214030003 OGDEN ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 54.0 9.0 23.0         10.0     1.0   60.0 37.0     *       28     11   97 54 9 23         10     1   60 37         28   11   97
2180082 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000947 280218030004 STRATFORD AVENUE SCHOOL public Regular School No Elementary 02 05 2019   grade_4 113.0 0.0 7.0         3.0     11.0   63.0 71.0     *       *     15   134 113 0 7         3     11   63 71             15   134
2180101 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000946 280218030005 STEWART SCHOOL public Regular School No Elementary 02 05 2019   grade_4 122.0 1.0 11.0         6.0     2.0   62.0 80.0     *       5     *   142 122 1 11         6     2   62 80         5       142
2180747 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001322 280226030003 MICHAEL F STOKES SCHOOL public Regular School No Elementary 02 04 2019   grade_4 85.0 3.0 31.0   3.0     17.0     0.0   78.0 61.0     *       40     12   139 85 3 31   3     17     0   78 61         40   12   139
2181602 NY Nassau   school 3625050 280403030000   ROSLYN 362505003467 280403030004 EAST HILLS ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 90.0 11.0 14.0   0.0     28.0     1.0   65.0 79.0     8       29     15   144 90 11 14   0     28     1   65 79     8   29   15   144
2183749 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 02 12 2019   grade_4 0.0 1.0 0.0   0.0     0.0         1.0 0.0     0       *     *   1 0 1 0   0     0         1 0     0           1
2194389 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2019   grade_4 97.0 4.0 2.0   1.0     3.0     9.0   52.0 64.0     *       34     12   116 97 4 2   1     3     9   52 64         34   12   116
2195244 NY Onondaga   school 3626940 421601060000   SKANEATELES 362694003669 421601060004 STATE STREET INTERMEDIATE SCHOOL public Regular School No Elementary 02 05 2019   grade_4 85.0   1.0         1.0     1.0   39.0 49.0             18     *   88 85   1         1     1   39 49         18       88
2196118 NY Ontario   school 3611970 430700010000   GENEVA 361197000965 430700010002 NORTH STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 62.0 13.0 49.0         2.0     21.0   82.0 65.0     26       104     25   147 62 13 49         2     21   82 65     26   104   25   147
2197258 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 106.0 19.0 77.0   1.0     9.0     5.0   111.0 106.0     9       63     43   217 106 19 77   1     9     5   111 106     9   63   43   217
2197277 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001792 441201060002 CENTRAL VALLEY ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 64.0 11.0 48.0   0.0     13.0     2.0   64.0 74.0     6       44     *   138 64 11 48   0     13     2   64 74     6   44       138
2197296 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001796 441201060003 NORTH MAIN STREET SCHOOL public Regular School No Elementary 02 05 2019   grade_4 71.0 7.0 46.0         6.0     2.0   75.0 57.0     11       48     20   132 71 7 46         6     2   75 57     11   48   20   132
2202502 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012304352 342700010056 PS 56 HARRY EICHLER public Regular School No Elementary 02 05 2019   grade_4 13.0 5.0 33.0   4.0     33.0     1.0   40.0 49.0     18       78     19   89 13 5 33   4     33     1   40 49     18   78   19   89
2212686 NY Schuyler   school 3621630 550101040000   ODESSA MONTOUR 362163003067 550101040002 HOWARD A HANLON ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2019   grade_4 47.0 0.0 0.0   0.0     0.0     3.0   23.0 27.0     *       29     *   50 47 0 0   0     0     3   23 27         29       50
2216543 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000574 580402060002 LLOYD HARBOR SCHOOL public Regular School No Elementary 02 06 2019   grade_4 57.0 0.0 4.0   1.0     6.0     3.0   42.0 29.0     *       *     13   71 57 0 4   1     6     3   42 29             13   71
2216562 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000575 580402060003 WEST SIDE SCHOOL public Regular School No Elementary 02 06 2019   grade_4 37.0   5.0         4.0     1.0   25.0 22.0             *     6   47 37   5         4     1   25 22             6   47
2217626 NY Suffolk   school 3615540 580502020000   ISLIP 361554001323 580502020002 COMMACK ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 56.0 9.0 40.0   0.0     6.0     2.0   57.0 56.0     11       43     14   113 56 9 40   0     6     2   57 56     11   43   14   113
2217664 NY Suffolk   school 3615540 580502020000   ISLIP 361554001326 580502020005 MAUD S SHERWOOD ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_4 60.0 5.0 9.0         0.0     3.0   43.0 34.0     *       21     13   77 60 5 9         0     3   43 34         21   13   77
2220419 NY Tioga   school 3630270 600101060000   WAVERLY 363027004066 600101060002 ELM STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2019   grade_4 106.0 1.0 0.0         1.0     1.0   49.0 60.0             65     11   109 106 1 0         1     1   49 60         65   11   109
2224067 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000783 660301030001 ANNE HUTCHINSON SCHOOL public Regular School No Elementary 02 07 2019   grade_4 76.0 3.0 17.0   1.0     11.0     3.0   56.0 55.0     10       *     18   111 76 3 17   1     11     3   56 55     10       18   111
2224086 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000786 660301030003 GREENVALE SCHOOL public Regular School No Elementary 02 05 2019   grade_4 82.0 2.0 17.0         22.0     6.0   64.0 65.0     *       *     9   129 82 2 17         22     6   64 65             9   129
2224751 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001045 660407060009 HIGHVIEW SCHOOL public Regular School No Elementary 02 03 2019   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2224789 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2019   grade_4 4.0 10.0 34.0         9.0     2.0   29.0 30.0     15       36     *   59 4 10 34         9     2   29 30     15   36       59
2226537 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2019   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2149283 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   grade_4 114.0 1.0 4.0   0.0     1.0     8.0   66.0 62.0     *       62     20   128 114 1 4   0     1     8   66 62         62   20   128
2149511 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   grade_4 8.0 1.0 0.0               2.0   8.0 3.0     *       9     11   11 8 1 0               2   8 3         9   11   11
2149606 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001376 31502060001 JOHNSON CITY ELEM/INTRMED SCHOOL public Regular School No Other 03 11 2019   grade_4 86.0 25.0 20.0   0.0     15.0     17.0   88.0 75.0     16       113     25   163 86 25 20   0     15     17   88 75     16   113   25   163
2150157 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2019   grade_4 115.0 5.0 2.0   0.0     6.0     14.0   71.0 71.0     *       84     20   142 115 5 2   0     6     14   71 71         84   20   142
2150385 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 07 2019   grade_4 57.0 1.0 8.0   42.0     0.0     7.0   51.0 64.0     *       81     11   115 57 1 8   42     0     7   51 64         81   11   115
2151202 NY Chautauqua   school 3609420 60800010000   DUNKIRK 360942000718 60800010010 DUNKIRK MIDDLE SCHOOL public Regular School No Middle 03 08 2019   grade_4 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
2151259 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   grade_4 79.0   0.0   0.0     0.0     0.0   39.0 40.0     *       *     *   79 79   0   0     0     0   39 40                 79
2151867 NY Chemung   school 3610560 70600010000   ELMIRA 361056000818 70600010010 HENDY AVENUE SCHOOL public Regular School No Elementary 03 06 2019   grade_4 76.0 22.0 4.0   0.0     2.0     17.0   64.0 57.0     *       86     16   121 76 22 4   0     2     17   64 57         86   16   121
2151886 NY Chemung   school 3610560 70600010000   ELMIRA 361056004387 70600010013 PARLEY COBURN SCHOOL public Regular School No Elementary 03 06 2019   grade_4 84.0 17.0 1.0         1.0     17.0   64.0 56.0             93     19   120 84 17 1         1     17   64 56         93   19   120
2151943 NY Chemung   school 3610560 70600010000   ELMIRA 361056000825 70600010016 THOMAS K BEECHER SCHOOL public Regular School No Elementary 03 06 2019   grade_4 62.0 15.0 0.0   0.0     0.0     17.0   51.0 43.0     *       77     23   94 62 15 0   0     0     17   51 43         77   23   94
2152019 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2019   grade_4 88.0 5.0 2.0               10.0   49.0 56.0     *       54     13   105 88 5 2               10   49 56         54   13   105
2152361 NY Chenango   school 3612750 80601040000   GREENE 361275001051 80601040002 GREENE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   grade_4 64.0 0.0 0.0         1.0         33.0 32.0     *       33     *   65 64 0 0         1         33 32         33       65
2152456 NY Chenango   school 3621330 81200050000   NORWICH 362133003041 81200050001 PERRY BROWNE INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   grade_4 108.0 0.0 4.0         1.0     4.0   70.0 47.0     0       88     18   117 108 0 4         1     4   70 47     0   88   18   117
2153045 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003261 91200010004 OAK STREET SCHOOL public Regular School No Elementary 03 05 2019   grade_4 61.0 5.0 2.0         6.0     1.0   40.0 35.0             33     18   75 61 5 2         6     1   40 35         33   18   75
2153767 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   grade_4 131.0   2.0         3.0     6.0   71.0 71.0     *       79     14   142 131   2         3     6   71 71         79   14   142
2154356 NY Dutchess   school 3609210 130502020000   DOVER 360921000706 130502020002 DOVER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   grade_4 48.0 1.0 33.0         2.0     5.0   53.0 36.0     10       *     13   89 48 1 33         2     5   53 36     10       13   89
2154926 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No Elementary 03 05 2019   grade_4 102.0 3.0 26.0   1.0     2.0     8.0   72.0 70.0     *       45     30   142 102 3 26   1     2     8   72 70         45   30   142
2154983 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No Elementary 03 05 2019   grade_4 69.0 9.0 24.0   0.0     9.0     8.0   52.0 67.0     10       *     11   119 69 9 24   0     9     8   52 67     10       11   119

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