Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_2 · 4,722
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▼ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
987031 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_2 2.0 9.0 19.0         4.0     0.0   25.0 9.0     *       26     34   34 2 9 19         4     0   25 9         26   34   34
950741 NY Bronx   school 3601127 321100861076   BRONX CHARTER SCHOOL-BETTER 360112706551 321100861076 BRONX CHARTER-BETTER LEARNING II charter Regular School Yes Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
950760 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
955263 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000125 80201040003 GUILFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
957638 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No Elementary PK 01 2017   grade_2 0.0   0.0               0.0   0.0 0.0     0       0     0   0 0   0               0   0 0     0   0   0   0
976011 NY Kings   school 3601146 333200861096   SUCCESS ACADEMY CHARTER SCH- 360114606580 333200861096 SUCCESS ACADEMY CHARTER SCH-NYC 10 charter Regular School Yes Elementary KG 01 2017   grade_2 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
976866 NY Madison   school 3606390 250901060000   CANASTOTA 360639000420 250901060003 PETERBORO STREET ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
980229 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000287 261801060002 GINTHER ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
982661 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004226 280214030001 FRANKLIN EARLY CHILDHOOD CENTER public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
982775 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001501 280215030004 LAWRENCE EARLY CHILDHOOD-#4 SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
983022 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       *     0   0 0 0 0         0     0   0 0             0   0
983041 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
983060 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
983763 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001321 280226030004 J FRED SPARKE SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
984618 NY Nassau   school 3625050 280403030000   ROSLYN 362505003471 280403030006 ROSLYN HTS ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
994384 NY New York   school 3601149 310600861074   AMBER CHARTER SCHOOL II 360114906588 310600861074 AMBER CHARTER SCHOOL II charter Regular School Yes Elementary KG 01 2017   grade_2 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
997443 NY Onondaga   school 3607320 420701060000   WESTHILL 360732004582 420701060003 WALBERTA PARK PRIMARY SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
999571 NY Ontario   school 3629640 431701060000   VICTOR 362964005334 431701060005 VICTOR EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1000350 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965004198 441201060005 SMITH CLOVE ELEMENTARY SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1000407 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965004823 441201060011 SAPPHIRE ELEMENTARY SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1005499 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012301790 342700010051 PS 51 public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1006658 NY Queens   school 3601151 342700861090   SUCCESS ACADEMY CHARTER SCHO 360115106581 342700861090 SUCCESS ACADEMY CHARTER SCHOOL-NYC 4 charter Regular School Yes Elementary KG 01 2017   grade_2 0.0 0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0 0 0 0   0           0   0 0         0   0   0
1006677 NY Queens   school 3601141 342700861099   SUCCESS ACADEMY CHARTER SCH- 360114106598 342700861099 SUCCESS ACADEMY CHARTER SCH-NYC 13 charter Regular School Yes Elementary KG 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1009964 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1016386 NY Steuben   school 3614820 571800010000   HORNELL 361482004299 571800010007 NORTH HORNELL SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1017203 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000064 580106030001 NORTHEAST SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1017450 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
1019559 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801001044 580402060005 GOOSEHILL PRIMARY CENTER public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       *     0   0 0 0 0         0     0   0 0             0   0
1020642 NY Suffolk   school 3615540 580502020000   ISLIP 361554000331 580502020006 WING ELEMENTARY SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1021402 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528004432 580512030002 EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1021535 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000257 580512030010 PINE PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1027083 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008004767 660301030004 WAVERLY EARLY CHLDHD CENTER public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       *     0   0 0 0 0         0     0   0 0     0       0   0
1027653 NY Westchester   school 3612720 660407060000   GREENBURGH 361272001046 660407060001 LEE F JACKSON SCHOOL public Regular School No Elementary KG 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1027767 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000839 660409020001 CARL L DIXSON ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1029382 NY Westchester   school 3622020 661401030000   OSSINING 362202003122 661401030003 PARK SCHOOL public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1031168 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 01 2017   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
944851 NY Bronx   school 3601137 320700861080   STOREFRONT ACADEMY CHARTER S 360113706552 320700861080 STOREFRONT ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 02 2017   grade_2 0.0 18.0 24.0   1.0     1.0         27.0 17.0     6       34     11   44 0 18 24   1     1         27 17     6   34   11   44
946542 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008600728 320900010170 PS 170 public Regular School No Elementary KG 02 2017   grade_2 1.0 15.0 69.0   2.0     2.0         55.0 34.0     26       61     14   89 1 15 69   2     2         55 34     26   61   14   89
947625 NY Bronx   school 3601129 320900861073   ROSALYN YALOW CHARTER SCHOOL 360112906566 320900861073 ROSALYN YALOW CHARTER SCHOOL charter Regular School Yes Elementary KG 02 2017   grade_2 0.0 26.0 58.0   0.0     0.0     1.0   32.0 53.0     13       84     16   85 0 26 58   0     0     1   32 53     13   84   16   85
947644 NY Bronx   school 3601132 320900861084   SOUTH BRONX CLASSICAL CHARTE 360113206570 320900861084 SOUTH BRONX CLASSICAL CHARTER III charter Regular School Yes Elementary KG 02 2017   grade_2 3.0 29.0 32.0   1.0     2.0     1.0   42.0 26.0     10       59     9   68 3 29 32   1     2     1   42 26     10   59   9   68
948214 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704693 321000010207 PS 207 public Regular School No Elementary PK 02 2017   grade_2 5.0 10.0 107.0   1.0     2.0         60.0 65.0     56       88     18   125 5 10 107   1     2         60 65     56   88   18   125
948233 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700739 321000010209 PS 209 public Regular School No Elementary PK 02 2017   grade_2 0.0 9.0 61.0         0.0         32.0 38.0     30       63     *   70 0 9 61         0         32 38     30   63       70
952223 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 109.0 1.0 3.0   0.0     1.0     8.0   63.0 59.0     *       58     10   122 109 1 3   0     1     8   63 59         58   10   122
952546 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001374 31502060003 JOHNSON CITY ELEM/PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 94.0 20.0 18.0   1.0     13.0     19.0   85.0 80.0     13       *     11   165 94 20 18   1     13     19   85 80     13       11   165
954237 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000872 61101040009 PAUL B D TEMPLE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 80.0 0.0 1.0                   39.0 42.0             46     *   81 80 0 1                   39 42         46       81
954769 NY Chemung   school 3610560 70600010000   ELMIRA 361056000816 70600010006 DIVEN SCHOOL public Regular School No Elementary PK 02 2017   grade_2 78.0 21.0 4.0         2.0     19.0   63.0 61.0     *       97     18   124 78 21 4         2     19   63 61         97   18   124
954788 NY Chemung   school 3610560 70600010000   ELMIRA 361056000817 70600010007 FASSETT ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 69.0 15.0 0.0   0.0           26.0   61.0 49.0             97     21   110 69 15 0   0           26   61 49         97   21   110
954845 NY Chemung   school 3610560 70600010000   ELMIRA 361056000822 70600010014 PINE CITY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 85.0 4.0 1.0               5.0   47.0 48.0             56     11   95 85 4 1               5   47 48         56   11   95
954864 NY Chemung   school 3610560 70600010000   ELMIRA 361056000823 70600010015 RIVERSIDE ELEMENTARY public Regular School No Elementary PK 02 2017   grade_2 90.0 21.0 2.0   1.0     1.0     22.0   72.0 65.0     *       111     16   137 90 21 2   1     1     22   72 65         111   16   137
955282 NY Chenango   school 3612750 80601040000   GREENE 361275001546 80601040001 GREENE PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 59.0 1.0 0.0   0.0           0.0   32.0 28.0     *       28     *   60 59 1 0   0           0   32 28         28       60
955415 NY Chenango   school 3621330 81200050000   NORWICH 362133003042 81200050002 STANFORD J GIBSON PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 121.0 2.0 2.0         0.0     5.0   82.0 48.0     *       *     28   130 121 2 2         0     5   82 48             28   130
955947 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_2 56.0 6.0 1.0         6.0     0.0   39.0 30.0     *       39     19   69 56 6 1         6     0   39 30         39   19   69
956308 NY Columbia   school 3614940 101300010000   HUDSON 361494001250 101300010002 JOHN L EDWARDS PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 67.0 21.0 17.0         13.0     18.0   74.0 62.0     21       99     20   136 67 21 17         13     18   74 62     21   99   20   136
956707 NY Cortland   school 3614640 110701060000   HOMER 361464001214 110701060002 HOMER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 115.0   2.0               5.0   61.0 61.0     *       71     11   122 115   2               5   61 61         71   11   122
957296 NY Dutchess   school 3609210 130502020000   DOVER 360921000708 130502020001 WINGDALE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 52.0 1.0 26.0         1.0     4.0   50.0 34.0     8       49     10   84 52 1 26         1     4   50 34     8   49   10   84
957847 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000093 131601060004 OVERLOOK PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 69.0 8.0 16.0         9.0     9.0   48.0 63.0     11       42     14   111 69 8 16         9     9   48 63     11   42   14   111
957866 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000095 131601060005 TRAVER ROAD PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 101.0 4.0 19.0   1.0     3.0     10.0   70.0 68.0     *       52     24   138 101 4 19   1     3     10   70 68         52   24   138
958037 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000432 131602020003 NASSAU SCHOOL public Regular School No Elementary KG 02 2017   grade_2 38.0 6.0 13.0         12.0     4.0   35.0 38.0     *       20     *   73 38 6 13         12     4   35 38         20       73
958151 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000247 131701060008 MILL ROAD-PRIMARY GRADES public Regular School No Elementary PK 02 2017   grade_2 98.0 1.0 14.0   0.0     2.0     1.0   55.0 61.0     9       35     *   116 98 1 14   0     2     1   55 61     9   35       116
977170 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000274 260101060001 COUNCIL ROCK PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 172.0 10.0 15.0         29.0     25.0   134.0 117.0     14       26     34   251 172 10 15         29     25   134 117     14   26   34   251
977360 NY Monroe   school 3612630 260501060000   GREECE 361263001024 260501060001 AUTUMN LANE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 60.0 21.0 20.0         3.0     10.0   59.0 55.0     12       63     *   114 60 21 20         3     10   59 55     12   63       114
977417 NY Monroe   school 3612630 260501060000   GREECE 361263001030 260501060006 ENGLISH VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 68.0 22.0 22.0   0.0     3.0     9.0   55.0 69.0     6       85     *   124 68 22 22   0     3     9   55 69     6   85       124
977588 NY Monroe   school 3612630 260501060000   GREECE 361263001034 260501060016 HOLMES ROAD ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 76.0 18.0 14.0   0.0     3.0     11.0   57.0 65.0     *       65     13   122 76 18 14   0     3     11   57 65         65   13   122
977759 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969000745 260801060005 IVAN L GREEN PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 62.0 19.0 37.0         3.0     9.0   70.0 60.0     9       86     8   130 62 19 37         3     9   70 60     9   86   8   130
977816 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969004717 260801060011 HELENDALE ROAD PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 51.0 29.0 31.0         1.0     11.0   60.0 63.0     7       76     6   123 51 29 31         1     11   60 63     7   76   6   123
978576 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000859 261301060010 DUDLEY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 158.0 6.0 12.0   0.0     4.0     8.0   97.0 91.0     *       49     25   188 158 6 12   0     4     8   97 91         49   25   188
979545 NY Monroe   school 3624750 261600010000   ROCHESTER 362475001628 261600010057 SCHOOL 57-EARLY CHLDHD SCHOOL public Regular School No Elementary PK 02 2017   grade_2 3.0 37.0 9.0         1.0         24.0 26.0     *       46     *   50 3 37 9         1         24 26         46       50
980837 NY Nassau   school 3612180 280100010000   GLEN COVE 361218000973 280100010001 DEASY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 30.0 11.0 95.0         4.0     4.0   71.0 73.0     44       100     29   144 30 11 95         4     4   71 73     44   100   29   144
980875 NY Nassau   school 3612180 280100010000   GLEN COVE 361218000975 280100010004 GRIBBIN SCHOOL public Regular School No Elementary KG 02 2017   grade_2 35.0 7.0 89.0         4.0     3.0   71.0 67.0     45       97     17   138 35 7 89         4     3   71 67     45   97   17   138
981901 NY Nassau   school 3604410 280207020000   BELLMORE 360441002841 280207020004 REINHARD EARLY CHILDHOOD CENTER public Regular School No Elementary PK 02 2017   grade_2 114.0 3.0 21.0   0.0     10.0     2.0   76.0 74.0     *       11     15   150 114 3 21   0     10     2   76 74         11   15   150
982528 NY Nassau   school 3618210 280212030000   MALVERNE 361821001642 280212030002 MAURICE W DOWNING PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 28.0 55.0 21.0         9.0     4.0   59.0 58.0     *       48     11   117 28 55 21         9     4   59 58         48   11   117
982756 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No Elementary 01 02 2017   grade_2 24.0 39.0 134.0   4.0     9.0     2.0   110.0 102.0     60       189     29   212 24 39 134   4     9     2   110 102     60   189   29   212
983820 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004867 280227030003 CHESTNUT STREET SCHOOL public Regular School No Elementary KG 02 2017   grade_2 0.0 0.0 1.0         0.0     0.0   1.0 0.0     0       0     *   1 0 0 1         0     0   1 0     0   0       1
984466 NY Nassau   school 3630960 280401030000   WESTBURY 363096002842 280401030003 DRYDEN STREET SCHOOL public Regular School No Elementary PK 02 2017   grade_2 0.0 0.0 1.0   0.0     0.0         1.0 0.0     *       *     0   1 0 0 1   0     0         1 0             0   1
985264 NY Nassau   school 3619500 280410030000   MINEOLA 361950001777 280410030002 HAMPTON STREET SCHOOL public Regular School No Elementary PK 02 2017   grade_2 40.0 4.0 44.0         9.0     10.0   48.0 59.0     28       46     9   107 40 4 44         9     10   48 59     28   46   9   107
985302 NY Nassau   school 3619500 280410030000   MINEOLA 361950001779 280410030004 MEADOW DRIVE SCHOOL public Regular School No Elementary PK 02 2017   grade_2 65.0 1.0 24.0         11.0     1.0   56.0 46.0     12       20     15   102 65 1 24         11     1   56 46     12   20   15   102
985359 NY Nassau   school 3606540 280411030000   CARLE PLACE 360654000436 280411030001 CHERRY LANE SCHOOL public Regular School No Elementary KG 02 2017   grade_2 73.0 2.0 16.0         5.0     0.0   43.0 53.0     5       12     *   96 73 2 16         5     0   43 53     5   12       96
985929 NY Nassau   school 3622290 280506060000   OYSTER BAY 362229003148 280506060003 THEODORE ROOSEVELT SCHOOL public Regular School No Elementary PK 02 2017   grade_2 76.0 5.0 20.0         8.0     4.0   62.0 51.0     15       20     19   113 76 5 20         8     4   62 51     15   20   19   113
990983 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802640 310300010185 PS 185 EARLY CHLDHD DISCOVERY public Regular School No Elementary PK 02 2017   grade_2 0.0 29.0 14.0         0.0     1.0   23.0 21.0     *       43     16   44 0 29 14         0     1   23 21         43   16   44
991990 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902418 310400010112 PS 112 JOSE CELSO BARBOSA public Regular School No Elementary PK 02 2017   grade_2 2.0 23.0 67.0   2.0     3.0     1.0   64.0 34.0     33       72     40   98 2 23 67   2     3     1   64 34     33   72   40   98
995201 NY Niagara   school 3628050 401001060000   STARPOINT 362805004790 401001060003 FRICANO PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 181.0 2.0 3.0         1.0     6.0   83.0 110.0     0       48     22   193 181 2 3         1     6   83 110     0   48   22   193
996208 NY Oneida   school 3614580 412201060000   HOLLAND PATENT 361458001208 412201060005 GENERAL WILLIAM FLOYD ELEM SCHOOL public Regular School No Elementary PK 02 2017   grade_2 94.0                       56.0 38.0     *       47     *   94 94                       56 38         47       94
997918 NY Onondaga   school 3621810 421201040000   ONONDAGA 362181003099 421201040001 ROCKWELL ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 43.0 5.0 1.0   3.0           3.0   25.0 30.0     *       25     7   55 43 5 1   3           3   25 30         25   7   55
998260 NY Onondaga   school 3626940 421601060000   SKANEATELES 362694003670 421601060003 WATERMAN ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 77.0 1.0 1.0         2.0     2.0   39.0 44.0     *       14     *   83 77 1 1         2     2   39 44         14       83
998925 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859006481 421800010072 DELAWARE PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 8.0 22.0 44.0   1.0           4.0   45.0 34.0     23       73     13   79 8 22 44   1           4   45 34     23   73   13   79
999134 NY Ontario   school 3611970 430700010000   GENEVA 361197000966 430700010001 WEST STREET ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 69.0 15.0 49.0         3.0     20.0   85.0 71.0     24       *     23   156 69 15 49         3     20   85 71     24       23   156
999267 NY Ontario   school 3612300 430901060000   GORHAM-MIDDLESEX 361230000994 430901060007 MIDDLESEX VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 82.0   1.0         1.0     0.0   32.0 52.0             39     7   84 82   1         1     0   32 52         39   7   84
999381 NY Ontario   school 3622890 431301060000   PHELPS-CLIFTON SPR 362289003215 431301060001 MIDLAKES PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 89.0 1.0 12.0         1.0     5.0   56.0 52.0     5       54     12   108 89 1 12         1     5   56 52     5   54   12   108
999970 NY Orange   school 3612330 440601040000   GOSHEN 361233000998 440601040003 SCOTCHTOWN AVENUE SCHOOL public Regular School No Elementary KG 02 2017   grade_2 121.0 9.0 48.0   0.0     6.0     6.0   90.0 100.0     *       63     26   190 121 9 48   0     6     6   90 100         63   26   190
1000027 NY Orange   school 3614430 440901040000   HIGHLAND FALLS 361443004821 440901040001 FORT MONTGOMERY ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 37.0 4.0 13.0         0.0     2.0   29.0 27.0     5       30     8   56 37 4 13         0     2   29 27     5   30   8   56
1000217 NY Orange   school 3619560 441101040000   MINISINK VALLEY 361956001783 441101040002 MINISINK VALLEY ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 102.0 7.0 29.0         1.0         70.0 69.0     *       41     21   139 102 7 29         1         70 69         41   21   139
1001585 NY Oswego   school 3606900 460801060000   CENTRAL SQUARE 360690000484 460801060006 MILLARD HAWK PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 95.0   3.0               1.0   44.0 55.0     *       53     14   99 95   3               1   44 55         53   14   99
1002269 NY Otsego   school 3629240 471601040000   OTEGO-UNADILLA 362924003932 471601040002 OTEGO ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 67.0 0.0 4.0         2.0     2.0   35.0 40.0     *       47     8   75 67 0 4         2     2   35 40         47   8   75
1002820 NY Putnam   school 3605310 480601060000   BREWSTER 360531000267 480601060004 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 118.0 2.0 85.0   0.0     5.0     5.0   121.0 94.0     28       78     16   215 118 2 85   0     5     5   121 94     28   78   16   215
1002991 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805244 342400010028 PS 28 THOMAS EMANUEL EARLY CHILD CTR public Regular School No Elementary PK 02 2017   grade_2 0.0   141.0   1.0     15.0     1.0   73.0 85.0     96       114     37   158 0   141   1     15     1   73 85     96   114   37   158
1007646 NY Queens   school 3601152 342800860824   GROWING UP GREEN II 360115206577 342800860824 GROWING UP GREEN CHARTER SCHOOL II charter Regular School Yes Elementary PK 02 2017   grade_2 1.0 32.0 18.0   1.0     7.0     0.0   30.0 29.0     *       49     *   59 1 32 18   1     7     0   30 29         49       59
1009147 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010205288 343000010222 PS 222-FF CHRISTOPHER A SANTORA public Regular School No Elementary PK 02 2017   grade_2 6.0 1.0 62.0   1.0     16.0     1.0   48.0 39.0     28       71     9   87 6 1 62   1     16     1   48 39     28   71   9   87
1009166 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010204893 343000010228 PS 228 EARLY CHILDHOOD MAGNET public Regular School No Elementary PK 02 2017   grade_2 5.0 3.0 71.0   0.0     7.0     0.0   48.0 38.0     39       78     16   86 5 3 71   0     7     0   48 38     39   78   16   86
1009926 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001496 490601060008 TURNPIKE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 100.0 27.0 28.0         3.0     18.0   98.0 78.0     11       137     28   176 100 27 28         3     18   98 78     11   137   28   176
1012111 NY Rockland   school 3620190 500108030000   NANUET 362019001852 500108030002 GEORGE W MILLER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 71.0 9.0 49.0         22.0     3.0   74.0 80.0     16       56     15   154 71 9 49         22     3   74 80     16   56   15   154

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