Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_7", state = "NY" and year = 2017 sorted by district_state_id

View and edit SQL

year

  • 2017 · 4,622

grade

  • grade_7 · 4,622
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
956712 NY Cortland   school 3614640 110701060000   HOMER 361464001214 110701060002 HOMER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_7 0.0   0.0               0.0   0.0 0.0     *       0     0   0 0   0               0   0 0         0   0   0
956731 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
956750 NY Cortland   school 3614640 110701060000   HOMER 361464003477 110701060006 HOMER JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2017   grade_7 158.0 2.0 0.0   1.0     1.0     2.0   100.0 64.0     *       77     26   164 158 2 0   1     1     2   100 64         77   26   164
956769 NY Cortland   school 3618450 110901040000   MARATHON 361845001661 110901040001 MARATHON HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 53.0 1.0 1.0         0.0         26.0 29.0             37     20   55 53 1 1         0         26 29         37   20   55
956788 NY Cortland   school 3618450 110901040000   MARATHON 361845001660 110901040002 WILLIAM APPLEBY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_7 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
943355 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
943374 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 52.0 17.0 11.0   0.0     6.0     5.0   56.0 35.0     *       62     13   91 52 17 11   0     6     5   56 35         62   13   91
956845 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 5.0 0.0 1.0               0.0   3.0 3.0             *     *   6 5 0 1               0   3 3                 6
956864 NY Delaware   school 3609240 120301040000   DOWNSVILLE 360924000709 120301040001 DOWNSVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 15.0 2.0 0.0         0.0         8.0 9.0             11     5   17 15 2 0         0         8 9         11   5   17
956883 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No Other PK 12 2017   grade_7 24.0 1.0 1.0         0.0     1.0   12.0 15.0             15     *   27 24 1 1         0     1   12 15         15       27
956902 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000680 120501040001 DELAWARE ACADEMY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
956921 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000681 120501040002 DELAWARE ACADEMY HIGH SCHOOL public Regular School No Other 06 12 2017   grade_7 51.0 1.0 0.0   1.0     0.0     2.0   25.0 30.0     *       22     *   55 51 1 0   1     0     2   25 30         22       55
956940 NY Delaware   school 3611430 120701040000   FRANKLIN 361143000900 120701040001 FRANKLIN CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 16.0 1.0 1.0   0.0     0.0     0.0   9.0 9.0             8     *   18 16 1 1   0     0     0   9 9         8       18
956959 NY Delaware   school 3613560 120906040000   HANCOCK 361356001109 120906040001 HANCOCK ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
956978 NY Delaware   school 3613560 120906040000   HANCOCK 361356001110 120906040002 HANCOCK JUNIOR-SENIOR HS public Regular School No Other 05 12 2017   grade_7 22.0 0.0 1.0   0.0     0.0         15.0 8.0             15     5   23 22 0 1   0     0         15 8         15   5   23
956997 NY Delaware   school 3618510 121401040000   MARGARETVILLE 361851001667 121401040001 MARGARETVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 19.0 0.0 10.0   1.0     1.0     1.0   14.0 18.0     *       22     7   32 19 0 10   1     1     1   14 18         22   7   32
957016 NY Delaware   school 3625110 121502040000   ROXBURY 362511003473 121502040001 ROXBURY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 27.0 1.0 2.0   0.0           0.0   10.0 20.0             17     7   30 27 1 2   0           0   10 20         17   7   30
957035 NY Delaware   school 3626850 121601060000   SIDNEY 362685003662 121601060002 SIDNEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957054 NY Delaware   school 3626850 121601060000   SIDNEY 362685003664 121601060005 SIDNEY MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_7 60.0 0.0 4.0         2.0     7.0   38.0 35.0     *       *     8   73 60 0 4         2     7   38 35             8   73
957073 NY Delaware   school 3626850 121601060000   SIDNEY 362685003663 121601060006 SIDNEY HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
957092 NY Delaware   school 3628020 121701040000   STAMFORD 362802003796 121701040001 STAMFORD CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 17.0 0.0 3.0         0.0         12.0 8.0             8     *   20 17 0 3         0         12 8         8       20
957111 NY Delaware   school 3627330 121702040000   SOUTH KORTRIGHT 362733003730 121702040001 SOUTH KORTRIGHT CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_7 26.0 0.0 2.0         1.0     0.0   8.0 21.0             12     *   29 26 0 2         1     0   8 21         12       29
957130 NY Delaware   school 3629820 121901040000   WALTON 362982004005 121901040001 TOWNSEND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
957149 NY Delaware   school 3629820 121901040000   WALTON 362982004006 121901040002 WALTON HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0   0.0         0.0         0.0 0.0     *       0     0   0 0   0         0         0 0         0   0   0
957168 NY Delaware   school 3629820 121901040000   WALTON 362982004791 121901040003 WALTON MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 64.0 1.0 5.0         1.0     1.0   38.0 34.0     *       41     16   72 64 1 5         1     1   38 34         41   16   72
957187 NY Dutchess   school 3604140 130200010000   BEACON 360414000179 130200010001 J V FORRESTAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957206 NY Dutchess   school 3604140 130200010000   BEACON 360414000182 130200010002 SOUTH AVENUE SCHOOL public Regular School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957225 NY Dutchess   school 3604140 130200010000   BEACON 360414000178 130200010003 GLENHAM SCHOOL public Regular School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957244 NY Dutchess   school 3604140 130200010000   BEACON 360414000180 130200010004 ROMBOUT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 112.0 31.0 57.0         6.0     15.0   118.0 103.0     *       114     45   221 112 31 57         6     15   118 103         114   45   221
957263 NY Dutchess   school 3604140 130200010000   BEACON 360414000177 130200010005 BEACON HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957282 NY Dutchess   school 3604140 130200010000   BEACON 360414000181 130200010006 SARGENT SCHOOL public Regular School No Elementary PK 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957301 NY Dutchess   school 3609210 130502020000   DOVER 360921000708 130502020001 WINGDALE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957320 NY Dutchess   school 3609210 130502020000   DOVER 360921000706 130502020002 DOVER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957339 NY Dutchess   school 3609210 130502020000   DOVER 360921000707 130502020003 DOVER HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957358 NY Dutchess   school 3609210 130502020000   DOVER 360921004332 130502020004 DOVER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 74.0 6.0 16.0         5.0     3.0   53.0 51.0     *       58     16   104 74 6 16         5     3   53 51         58   16   104
957377 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001272 130801060002 NETHERWOOD SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
957396 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001274 130801060003 RALPH R SMITH SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
957415 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001276 130801060005 VIOLET AVENUE SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957434 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001270 130801060006 HAVILAND MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 196.0 31.0 39.0         7.0     11.0   148.0 136.0     6       134     42   284 196 31 39         7     11   148 136     6   134   42   284
957453 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001269 130801060007 FRANKLIN D ROOSEVELT SENIOR HS public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957472 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001273 130801060008 NORTH PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957491 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039004093 131101040004 WEBUTUCK HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
957510 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039004971 131101040006 WEBUTUCK ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957529 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039005848 131101040007 EUGENE BROOKS MIDDLE SCHOOL public Regular School No Elementary 04 08 2017   grade_7 34.0 2.0 9.0         0.0     2.0   23.0 24.0     *       *     *   47 34 2 9         0     2   23 24                 47
957548 NY Dutchess   school 3622530 131201040000   PAWLING 362253003172 131201040001 PAWLING ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957567 NY Dutchess   school 3622530 131201040000   PAWLING 362253003173 131201040002 PAWLING HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957586 NY Dutchess   school 3622530 131201040000   PAWLING 362253003255 131201040003 PAWLING MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_7 79.0 2.0 14.0         0.0     1.0   49.0 47.0     *       29     13   96 79 2 14         0     1   49 47         29   13   96
957605 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2017   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     0       0     0   0 0   0         0     0   0 0     0   0   0   0
957624 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003231 131301040002 STISSING MOUNTAIN HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
957643 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No Elementary PK 01 2017   grade_7 0.0   0.0               0.0   0.0 0.0     0       0     0   0 0   0               0   0 0     0   0   0   0
957662 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004975 131301040004 STISSING MOUNTAIN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 52.0 1.0 10.0   0.0     0.0     3.0   31.0 35.0     *       25     8   66 52 1 10   0     0     3   31 35         25   8   66
957681 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957700 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957719 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003304 131500010006 G W KRIEGER SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957738 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376004616 131500010007 SMITH EARLY LEARNING CENTER public Regular School No Elementary PK KG 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957757 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003306 131500010009 MORSE YOUNG MAGNET SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957776 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003307 131500010010 POUGHKEEPSIE HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957795 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003308 131500010011 POUGHKEEPSIE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 25.0 161.0 94.0   0.0     3.0     12.0   166.0 129.0     39       *     55   295 25 161 94   0     3     12   166 129     39       55   295
957814 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000086 131601060001 ARTHUR S MAY SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957833 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000089 131601060002 BEEKMAN SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
957852 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000093 131601060004 OVERLOOK PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957871 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000095 131601060005 TRAVER ROAD PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957890 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000088 131601060008 ARLINGTON HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957909 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No Elementary 02 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957928 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000092 131601060011 NOXON ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
957947 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003266 131601060012 LAGRANGE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 185.0 35.0 47.0         16.0     8.0   151.0 140.0     10       *     45   291 185 35 47         16     8   151 140     10       45   291
957966 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No Elementary 03 05 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
957985 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005596 131601060014 VAIL FARM ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
958004 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 296.0 15.0 34.0         19.0     14.0   187.0 191.0     *       60     46   378 296 15 34         19     14   187 191         60   46   378
958023 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000430 131602020001 HAGAN SCHOOL public Regular School No Elementary 03 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
958042 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000432 131602020003 NASSAU SCHOOL public Regular School No Elementary KG 02 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
958061 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000433 131602020004 ORVILLE A TODD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 69.0 8.0 14.0         10.0     8.0   55.0 54.0             25     18   109 69 8 14         10     8   55 54         25   18   109
958080 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000434 131602020005 SPACKENKILL HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
958099 NY Dutchess   school 3624240 131701060000   RED HOOK 362424003334 131701060002 RED HOOK SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
958118 NY Dutchess   school 3624240 131701060000   RED HOOK 362424003333 131701060004 LINDEN AVENUE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 140.0 3.0 10.0   0.0     2.0     0.0   72.0 83.0     *       35     15   155 140 3 10   0     2     0   72 83         35   15   155
958137 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000225 131701060006 MILL ROAD-INTERMEDIATE GRADES public Regular School No Elementary 03 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
958156 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000247 131701060008 MILL ROAD-PRIMARY GRADES public Regular School No Elementary PK 02 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
958175 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003345 131801040001 RHINEBECK SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
958194 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003344 131801040002 CHANCELLOR LIVINGSTON ELEMENTARY SCH public Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
958213 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003343 131801040003 BULKELEY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 64.0 0.0 5.0   0.0     1.0     0.0   33.0 37.0     *       7     10   70 64 0 5   0     1     0   33 37         7   10   70
958232 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004013 132101060001 BRINCKERHOFF ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
958251 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004014 132101060002 FISHKILL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
958270 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004015 132101060003 FISHKILL PLAINS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
958289 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004016 132101060004 GAYHEAD SCHOOL public Regular School No Elementary KG 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
958308 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004017 132101060005 JAMES S EVANS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
958327 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988001118 132101060006 KINRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
958346 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004025 132101060007 VASSAR ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
958365 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004023 132101060008 SHEAFE ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
958384 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004024 132101060009 VAN WYCK JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_7 353.0 21.0 61.0   0.0     23.0     8.0   246.0 220.0     *       *     69   466 353 21 61   0     23     8   246 220             69   466
958403 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_7 250.0 36.0 66.0         19.0     7.0   206.0 172.0     5       *     *   378 250 36 66         19     7   206 172     5           378
958422 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004022 132101060011 ROY C KETCHAM SENIOR HIGH SCH public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
958441 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004021 132101060012 OAK GROVE ELEMENTARY SCHOOL public Regular School No Elementary KG 6 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
958460 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004020 132101060013 MYERS CORNERS SCHOOL public Regular School No Elementary KG 6 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
958479 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004018 132101060015 JOHN JAY SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
958498 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2017   grade_7 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
958517 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001772 132201040001 MILLBROOK MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_7 74.0 1.0 5.0         0.0     4.0   39.0 45.0             21     15   84 74 1 5         0     4   39 45         21   15   84
958536 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001770 132201040002 ALDEN PLACE ELEMENTARY SCHOOL public Regular School No Elementary 03 5 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
958555 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001771 132201040003 ELM DRIVE ELEMENTARY SCHOOL public Regular School No Elementary KG 2 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
958574 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938005859 132201040005 MILLBROOK HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
958593 NY Erie   school 3602550 140101060000   ALDEN 360255000041 140101060003 ALDEN PRIMARY AT TOWNLINE public Regular School No Elementary KG 2 2017   grade_7 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);