Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_4" and state = "NY" sorted by hispanic

View and edit SQL

year

grade

  • grade_4 · 33,145
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
745585 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes 3.0 09 12 2015   grade_4 0.0 0.0           0.0         0.0               0     0   0 0 0           0         0           0   0   0
745661 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2015   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
746516 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   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
755370 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001119 30501040003 HARPURSVILLE JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2015   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
758619 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001906369 81003040006 UNADILLA VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_4 56.0 0.0     2.0     0.0     0.0   28.0 30.0             35     9   58 56 0     2     0     0   28 30         35   9   58
758885 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_4 28.0 1.0                 0.0   10.0 19.0             *     6   29 28 1                 0   10 19             6   29
759094 NY Clinton   school 3607170 90601020000   CHAZY 360717000507 90601020002 CHAZY CENTRAL RURAL JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2015   grade_4 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
759132 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No 4.0 06 12 2015   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
765801 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_4 12.0 0.0           1.0         9.0 4.0             7     *   13 12 0           1         9 4         7       13
765991 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No 3 09 12 2015   grade_4 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
766029 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003894 151501060007 TICONDEROGA MIDDLE SCHOOL public Regular School No 2 06 8 2015   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
766067 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_4 19.0       0.0           1.0   6.0 14.0             12     *   20 19       0           1   6 14         12       20
766143 NY Franklin   school 3607080 160801040000   CHATEAUGAY 360708000498 160801040002 CHATEAUGAY HIGH SCHOOL public Regular School No 3 07 12 2015   grade_4 0.0       0.0     0.0         0.0 0.0             0     0   0 0       0     0         0 0         0   0   0
766295 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No 1 KG 5 2015   grade_4 46.0                       18.0 28.0             22     *   46 46                       18 28         22       46
766409 NY Franklin   school 3605820 161601040000   BRUSHTON MOIRA 360582000294 161601040002 BRUSHTON-MOIRA HIGH SCHOOL public Regular School No 4 05 12 2015   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
766447 NY Franklin   school 3627990 161801040000   ST REGIS FALLS 362799003793 161801040001 ST REGIS FALLS CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_4 19.0       1.0     0.0     0.0   11.0 9.0             15     7   20 19       1     0     0   11 9         15   7   20
767245 NY Genesee   school 3608340 181302040000   PEMBROKE 360834000617 181302040003 PEMBROKE PRIMARY SCHOOL public Regular School No 1 KG 2 2015   grade_4 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
767568 NY Hamilton   school 3615270 200401040000   INDIAN LAKE 361527001285 200401040001 INDIAN LAKE CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_4 12.0 0.0           0.0     0.0   4.0 8.0             5     0   12 12 0           0     0   4 8         5   0   12
767606 NY Hamilton   school 3616530 200601040000   LAKE PLEASANT 361653001461 200601040001 LAKE PLEASANT SCHOOL public Regular School No 4 PK 9 2015   grade_4 12.0 0.0                     7.0 5.0             6     *   12 12 0                     7 5         6       12
767625 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_4 5.0             0.0         2.0 3.0             *     *   5 5             0         2 3                 5
767796 NY Herkimer   school 3617460 210800050000   LITTLE FALLS 361746001554 210800050001 BENTON HALL ACADEMY public Regular School No 1 PK 5 2015   grade_4 71.0 0.0                 1.0   29.0 43.0             47     9   72 71 0                 1   29 43         47   9   72
767853 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1 PK 4 2015   grade_4 67.0                       32.0 35.0             38     6   67 67                       32 35         38   6   67
767891 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2 05 8 2015   grade_4 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
768024 NY Herkimer   school 3630930 212001040000   MOUNT MARKHAM 363093004155 212001040005 MT MARKHAM MIDDLE SCHOOL public Regular School No 2 05 8 2015   grade_4 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
779709 NY Lewis   school 3627360 231101040000   SOUTH LEWIS 362736003734 231101040008 PORT LEYDEN ELEMENTARY SCHOOL public Regular School No 1 PK 04 2015   grade_4 31.0 0.0                 1.0   20.0 12.0             24     *   32 31 0                 1   20 12         24       32
780165 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No 4 06 12 2015   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
786625 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST SCHOOL public Regular School No 1 KG 01 2015   grade_4 0.0 0.0           0.0     0.0   0.0 0.0             *     0   0 0 0           0     0   0 0             0   0
799089 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504004187 410401060001 ADIRONDACK MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_4 0.0 0.0                     0.0 0.0             0     0   0 0 0                     0 0         0   0   0
799108 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000244 410401060002 WEST LEYDEN ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_4 26.0                       10.0 16.0             14     6   26 26                       10 16         14   6   26
799127 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000243 410401060003 FORESTPORT ELEMENTARY SCHOOL public Regular School No 1 PK 05 2015   grade_4 11.0                       7.0 4.0             *     *   11 11                       7 4                 11
799317 NY Oneida   school 3607770 411101060000   CLINTON 360777000557 411101060005 CLINTON SENIOR HIGH SCHOOL public Regular School No 3 09 12 2015   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
799773 NY Oneida   school 3630160 411902040000   WATERVILLE 363016004538 411902040003 WATERVILLE JR/SR HIGH SCHOOL public Regular School No 3 07 12 2015   grade_4 0.0             0.0     0.0   0.0 0.0             0     0   0 0             0     0   0 0         0   0   0
799925 NY Oneida   school 3614580 412201060000   HOLLAND PATENT 361458001208 412201060005 GENERAL WILLIAM FLOYD ELEM SCHOOL public Regular School No 1 PK 02 2015   grade_4 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
801255 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No 1 PK 08 2015   grade_4         12.0           0.0   7.0 5.0             10     *   12         12           0   7 5         10       12
804162 NY Orange   school 3604758 441202020000   KIRYAS JOEL 360475804758 441202020001 KIRYAS JOEL VILLAGE SCHOOL public Regular School No 1 PK KG 2015   grade_4 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
813586 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No 1 KG 01 2015   grade_4 0.0                       0.0 0.0                   *   0 0                       0 0                 0
816759 NY Saint Lawrence   school 3608100 510501040000   COLTON PIERREPONT 360810000576 510501040001 COLTON-PIERREPONT CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_4 23.0 0.0           0.0         9.0 14.0             12     *   23 23 0           0         9 14         12       23
816835 NY Saint Lawrence   school 3613440 511201040000   HAMMOND 361344004511 511201040001 HAMMOND CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_4 24.0 0.0     0.0               11.0 13.0             0     *   24 24 0     0               11 13         0       24
817101 NY Saint Lawrence   school 3621660 512300010000   OGDENSBURG 362166003069 512300010002 JOHN F KENNEDY SCHOOL public Regular School No 1 PK 06 2015   grade_4 92.0 2.0     0.0     1.0     0.0   46.0 49.0             53     21   95 92 2     0     1     0   46 49         53   21   95
817120 NY Saint Lawrence   school 3621660 512300010000   OGDENSBURG 362166003071 512300010004 MADILL SCHOOL public Regular School No 1 KG 06 2015   grade_4 37.0             0.0         18.0 19.0             22     0   37 37             0         18 19         22   0   37
817177 NY Saint Lawrence   school 3622440 512501040000   PARISHVL HOPKINTON 362244003157 512501040002 PARISHVILLE-HOPKINTON ELEM SCH public Regular School No 1 PK 06 2015   grade_4 31.0                       17.0 14.0             20     5   31 31                       17 14         20   5   31
817196 NY Saint Lawrence   school 3622440 512501040000   PARISHVL HOPKINTON 362244003158 512501040004 PARISHVILLE-HOPKINTON JR-SR HS public Regular School No 3 07 12 2015   grade_4 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
817595 NY Saratoga   school 3610230 520601080000   EDINBURG COMMON SD 361023000796 520601080001 EDINBURG COMMON SCHOOL public Regular School No 4 PK 11 2015   grade_4 8.0 0.0           0.0         5.0 3.0             *     0   8 8 0           0         5 3             0   8
819628 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY ELEMENTARY SCHOOL public Regular School No 1 PK PK 2015   grade_4 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
819913 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative Education School No 3 09 12 2015   grade_4 0.0 0.0                 0.0   0.0 0.0             0     *   0 0 0                 0   0 0         0       0
820141 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No 3 07 12 2015   grade_4 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
820160 NY Steuben   school 3613470 572901040000   HAMMONDSPORT 361347001104 572901040002 GLENN CURTISS MEMORIAL SCHOOL public Regular School No 1 PK 06 2015   grade_4 29.0             0.0     1.0   17.0 13.0             17     5   30 29             0     1   17 13         17   5   30
829584 NY Washington   school 3623970 641401040000   PUTNAM 362397003313 641401040001 PUTNAM CENTRAL SCHOOL public Regular School No 1 PK 06 2015   grade_4 4.0                       0.0 4.0             *     *   4 4                       0 4                 4
943428 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_4 16.0 1.0           0.0         9.0 8.0             11     *   17 16 1           0         9 8         11       17
955645 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_4 30.0 1.0                     17.0 14.0             18     *   31 30 1                     17 14         18       31
955892 NY Clinton   school 3621260 90901040000   NORTHRN ADIRONDACK 362126003024 90901040002 NORTHERN ADIRONDACK MID/HIGH SCH public Regular School No Other 06 12 2017   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
955930 NY Clinton   school 3622830 91101060000   PERU 362283003209 91101060005 PERU JR/SR HIGH SCHOOL public Regular School No High 07 12 2017   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
956557 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_4 19.0                   1.0   9.0 11.0             10     *   20 19                   1   9 11         10       20
962561 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_4 19.0 0.0           0.0         10.0 9.0     *       13     *   19 19 0           0         10 9         13       19
962580 NY Essex   school 3610440 150301040000   ELIZABETHTOWN 361044000804 150301040001 ELIZABETHTOWN-LEWIS CENTRAL SCHOOL public Regular School No Other KG 12 2017   grade_4 18.0 0.0     0.0     0.0         7.0 11.0             9     *   18 18 0     0     0         7 11         9       18
962751 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   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
962789 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003894 151501060007 TICONDEROGA MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_4 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
962808 NY Essex   school 3631080 151601040000   WESTPORT 363108004170 151601040001 WESTPORT CENTRAL SCHOOL public Regular School No Other KG 12 2017   grade_4 19.0                   0.0   9.0 10.0     *       11     *   19 19                   0   9 10         11       19
962903 NY Franklin   school 3607080 160801040000   CHATEAUGAY 360708000498 160801040002 CHATEAUGAY HIGH SCHOOL public Regular School No High 07 12 2017   grade_4 0.0       0.0     0.0         0.0 0.0             0     0   0 0       0     0         0 0         0   0   0
963036 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003534 161401060003 SARANAC LAKE MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_4 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
963055 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 5 2017   grade_4 27.0                       13.0 14.0             6     *   27 27                       13 14         6       27
963188 NY Franklin   school 3605820 161601040000   BRUSHTON MOIRA 360582000293 161601040003 BRUSHTON GRADE SCHOOL public Regular School No Elementary PK 6 2017   grade_4 62.0             1.0     0.0   35.0 28.0             41     13   63 62             1     0   35 28         41   13   63
963549 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500283 171102040002 LEARNING COMMUN-BROADALBIN-PERTH (TH public Regular School No Elementary PK 2 2017   grade_4 0.0 0.0           0.0         0.0 0.0     *       0     0   0 0 0           0         0 0         0   0   0
964366 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_4 5.0                       2.0 3.0             *     0   5 5                       2 3             0   5
964556 NY Herkimer   school 3617460 210800050000   LITTLE FALLS 361746001555 210800050005 LITTLE FALLS HIGH SCHOOL public Regular School No High 09 12 2017   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
964594 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 4 2017   grade_4 76.0                       35.0 41.0             42     15   76 76                       35 41         42   15   76
964632 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No Middle 05 8 2017   grade_4 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
964955 NY Jefferson   school 3602670 220202040000   ALEXANDRIA CSD 360267004333 220202040002 ALEXANDRIA CENTRAL HIGH SCHOOL public Regular School No High 07 12 2017   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
976203 NY Lewis   school 3627360 231101040000   SOUTH LEWIS 362736003734 231101040008 PORT LEYDEN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_4 24.0                   0.0   12.0 12.0             17     5   24 24                   0   12 12         17   5   24
976260 NY Lewis   school 3604200 231301040000   BEAVER RIVER 360420005992 231301040004 BEAVER RIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0     0.0               0.0 0.0             0     0   0 0 0     0               0 0         0   0   0
994633 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Elementary PK PK 2017   grade_4 0.0 0.0     0.0           0.0   0.0 0.0             *     *   0 0 0     0           0   0 0                 0
995393 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000244 410401060002 WEST LEYDEN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_4 24.0                   0.0   8.0 16.0             16     *   24 24                   0   8 16         16       24
995412 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000243 410401060003 FORESTPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_4 22.0                   0.0   10.0 12.0             15     *   22 22                   0   10 12         15       22
995830 NY Oneida   school 3624360 411701040000   REMSEN 362436003338 411701040002 REMSEN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_4 0.0             0.0     0.0   0.0 0.0             0     0   0 0             0     0   0 0         0   0   0
996058 NY Oneida   school 3630160 411902040000   WATERVILLE 363016004538 411902040003 WATERVILLE JR/SR HIGH SCHOOL public Regular School No High 07 12 2017   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
996210 NY Oneida   school 3614580 412201060000   HOLLAND PATENT 361458001208 412201060005 GENERAL WILLIAM FLOYD ELEM SCHOOL public Regular School No Elementary PK 02 2017   grade_4 0.0                       0.0 0.0     *       0     0   0 0                       0 0         0   0   0
997540 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Elementary PK 08 2017   grade_4         8.0           0.0   2.0 6.0             8     0   8         8           0   2 6         8   0   8
1000428 NY Orange   school 3604758 441202020000   KIRYAS JOEL 360475804758 441202020001 KIRYAS JOEL VILLAGE SCHOOL public Regular School No Elementary PK KG 2017   grade_4 0.0                       0.0 0.0     0       0     0   0 0                       0 0     0   0   0   0
1002556 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Alternative School No Middle 06 08 2017   grade_4 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
1009966 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2017   grade_4 0.0                   0.0   0.0 0.0     *             *   0 0                   0   0 0                 0
1013158 NY Saint Lawrence   school 3608100 510501040000   COLTON PIERREPONT 360810000576 510501040001 COLTON-PIERREPONT CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_4 20.0 0.0           0.0         10.0 10.0             8     *   20 20 0           0         10 10         8       20
1013234 NY Saint Lawrence   school 3613440 511201040000   HAMMOND 361344004511 511201040001 HAMMOND CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_4 19.0 1.0                     12.0 8.0             16     *   20 19 1                     12 8         16       20
1013424 NY Saint Lawrence   school 3619890 512101040000   MORRISTOWN 361989001817 512101040001 MORRISTOWN CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_4 35.0                   0.0   18.0 17.0             22     *   35 35                   0   18 17         22       35
1013576 NY Saint Lawrence   school 3622440 512501040000   PARISHVL HOPKINTON 362244003157 512501040002 PARISHVILLE-HOPKINTON ELEM SCH public Regular School No Elementary PK 06 2017   grade_4 34.0                       13.0 21.0             17     *   34 34                       13 21         17       34
1013595 NY Saint Lawrence   school 3622440 512501040000   PARISHVL HOPKINTON 362244003158 512501040004 PARISHVILLE-HOPKINTON JR-SR HS public Regular School No High 07 12 2017   grade_4 0.0       0.0               0.0 0.0             0     0   0 0       0               0 0         0   0   0
1013994 NY Saratoga   school 3610230 520601080000   EDINBURG COMMON SD 361023000796 520601080001 EDINBURG COMMON SCHOOL public Regular School No Elementary PK 06 2017   grade_4 12.0                   0.0   10.0 2.0             9     *   12 12                   0   10 2         9       12
1015970 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK PK 2017   grade_4 0.0                       0.0 0.0             0     *   0 0                       0 0         0       0
1016255 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_4 0.0 0.0                     0.0 0.0             0         0 0 0                     0 0         0       0
1016464 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_4 37.0 0.0                     19.0 18.0             24     9   37 37 0                     19 18         24   9   37
1016578 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101042 573002040003 WAYLAND-COHOCTON MIDDLE SCHOOL public Regular School No Middle 05 08 2017   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
1016597 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101445 573002040004 COHOCTON ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_4 22.0                   2.0   11.0 13.0             19     *   24 22                   2   11 13         19       24
1025831 NY Washington   school 3623970 641401040000   PUTNAM 362397003313 641401040001 PUTNAM CENTRAL SCHOOL public Regular School No Elementary PK 06 2017   grade_4 2.0                       2.0 0.0             *     *   2 2                       2 0                 2
1045515 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_4 41.0 0.0                     16.0 25.0             22     7   41 41 0                     16 25         22   7   41
1051747 NY Erie   school 3602430 142101040000   AKRON 360243005012 142101040003 AKRON MIDDLE SCHOOL public Regular School No 2.0 06 8 2016   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
1052412 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_4 21.0 0.0           0.0         9.0 12.0             9     *   21 21 0           0         9 12         9       21
1052431 NY Essex   school 3610440 150301040000   ELIZABETHTOWN 361044000804 150301040001 ELIZABETHTOWN-LEWIS CENTRAL SCHOOL public Regular School No 4.0 KG 12 2016   grade_4 13.0 0.0     0.0     1.0         9.0 5.0             6     *   14 13 0     0     1         9 5         6       14
1052564 NY Essex   school 3616500 151102040000   LAKE PLACID 361650001459 151102040002 LAKE PLACID ELEMENTARY SCHOOL public Regular School No 1.0 KG 5 2016   grade_4 44.0             0.0     3.0   32.0 15.0             20     13   47 44             0     3   32 15         20   13   47
1052602 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1052640 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003894 151501060007 TICONDEROGA MIDDLE SCHOOL public Regular School No 2.0 06 8 2016   grade_4 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
1052659 NY Essex   school 3631080 151601040000   WESTPORT 363108004170 151601040001 WESTPORT CENTRAL SCHOOL public Regular School No 4.0 KG 12 2016   grade_4 12.0                   0.0   5.0 7.0             6     *   12 12                   0   5 7         6       12

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