Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2018 · 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
2064052 NY Cortland   school 3614640 110701060000   HOMER 361464001217 110701060001 HOMER SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   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
2064071 NY Cortland   school 3614640 110701060000   HOMER 361464001214 110701060002 HOMER ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2018   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
2064090 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2018   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
2064109 NY Cortland   school 3614640 110701060000   HOMER 361464003477 110701060006 HOMER JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2018   grade_7 166.0 0.0 3.0               2.0   92.0 79.0     *       71     *   171 166 0 3               2   92 79         71       171
2064128 NY Cortland   school 3618450 110901040000   MARATHON 361845001661 110901040001 MARATHON HIGH SCHOOL public Regular School No High 07 12 2018   grade_7 44.0 1.0 2.0         0.0         28.0 19.0     *       31     16   47 44 1 2         0         28 19         31   16   47
2064147 NY Cortland   school 3618450 110901040000   MARATHON 361845001660 110901040002 WILLIAM APPLEBY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_7 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
2050695 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2050714 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_7 37.0 20.0 14.0   0.0     7.0     10.0   56.0 32.0     7       69     *   88 37 20 14   0     7     10   56 32     7   69       88
2064204 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 7.0 0.0 0.0               0.0   1.0 6.0             *     *   7 7 0 0               0   1 6                 7
2064223 NY Delaware   school 3609240 120301040000   DOWNSVILLE 360924000709 120301040001 DOWNSVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 13.0 1.0 0.0         0.0         7.0 7.0             9     *   14 13 1 0         0         7 7         9       14
2064242 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No Other PK 12 2018   grade_7 26.0 0.0 1.0         0.0     0.0   13.0 14.0             18     5   27 26 0 1         0     0   13 14         18   5   27
2064261 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000680 120501040001 DELAWARE ACADEMY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   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
2064280 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000681 120501040002 DELAWARE ACADEMY HIGH SCHOOL public Regular School No High 06 12 2018   grade_7 54.0 0.0 1.0   1.0     1.0     1.0   33.0 25.0             17     6   58 54 0 1   1     1     1   33 25         17   6   58
2064299 NY Delaware   school 3611430 120701040000   FRANKLIN 361143000900 120701040001 FRANKLIN CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 16.0 0.0 0.0   0.0     0.0     0.0   9.0 7.0             6     *   16 16 0 0   0     0     0   9 7         6       16
2064318 NY Delaware   school 3613560 120906040000   HANCOCK 361356001109 120906040001 HANCOCK ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   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
2064337 NY Delaware   school 3613560 120906040000   HANCOCK 361356001110 120906040002 HANCOCK JUNIOR-SENIOR HS public Regular School No High 05 12 2018   grade_7 13.0 1.0 1.0   0.0               9.0 6.0             *     *   15 13 1 1   0               9 6                 15
2064356 NY Delaware   school 3618510 121401040000   MARGARETVILLE 361851001667 121401040001 MARGARETVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 17.0 0.0 8.0   0.0     0.0     2.0   13.0 14.0     5       18     *   27 17 0 8   0     0     2   13 14     5   18       27
2064375 NY Delaware   school 3625110 121502040000   ROXBURY 362511003473 121502040001 ROXBURY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 20.0 1.0 2.0   0.0           0.0   9.0 14.0             14     9   23 20 1 2   0           0   9 14         14   9   23
2064394 NY Delaware   school 3626850 121601060000   SIDNEY 362685003662 121601060002 SIDNEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   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
2064413 NY Delaware   school 3626850 121601060000   SIDNEY 362685003664 121601060005 SIDNEY MIDDLE SCHOOL public Regular School No Elementary KG 08 2018   grade_7 64.0   5.0         1.0     1.0   36.0 35.0     *       38     6   71 64   5         1     1   36 35         38   6   71
2064432 NY Delaware   school 3626850 121601060000   SIDNEY 362685003663 121601060006 SIDNEY HIGH SCHOOL public Regular School No High 09 12 2018   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
2064451 NY Delaware   school 3628020 121701040000   STAMFORD 362802003796 121701040001 STAMFORD CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 21.0 1.0 0.0         0.0         9.0 13.0             15     *   22 21 1 0         0         9 13         15       22
2064470 NY Delaware   school 3627330 121702040000   SOUTH KORTRIGHT 362733003730 121702040001 SOUTH KORTRIGHT CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_7 26.0 1.0 0.0         0.0     1.0   17.0 11.0             13     *   28 26 1 0         0     1   17 11         13       28
2064489 NY Delaware   school 3629820 121901040000   WALTON 362982004005 121901040001 TOWNSEND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   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
2064508 NY Delaware   school 3629820 121901040000   WALTON 362982004006 121901040002 WALTON HIGH SCHOOL public Regular School No High 09 12 2018   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
2064527 NY Delaware   school 3629820 121901040000   WALTON 362982004791 121901040003 WALTON MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 66.0 0.0 2.0         0.0     0.0   36.0 32.0     *       35     8   68 66 0 2         0     0   36 32         35   8   68
2064546 NY Dutchess   school 3604140 130200010000   BEACON 360414000179 130200010001 J V FORRESTAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   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
2064565 NY Dutchess   school 3604140 130200010000   BEACON 360414000182 130200010002 SOUTH AVENUE SCHOOL public Regular School No Elementary PK 05 2018   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
2064584 NY Dutchess   school 3604140 130200010000   BEACON 360414000178 130200010003 GLENHAM SCHOOL public Regular School No Elementary PK 05 2018   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
2064603 NY Dutchess   school 3604140 130200010000   BEACON 360414000180 130200010004 ROMBOUT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 100.0 31.0 63.0         8.0     15.0   107.0 110.0     *       102     *   217 100 31 63         8     15   107 110         102       217
2064622 NY Dutchess   school 3604140 130200010000   BEACON 360414000177 130200010005 BEACON HIGH SCHOOL public Regular School No High 09 12 2018   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
2064641 NY Dutchess   school 3604140 130200010000   BEACON 360414000181 130200010006 SARGENT SCHOOL public Regular School No Elementary PK 05 2018   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
2064660 NY Dutchess   school 3609210 130502020000   DOVER 360921000708 130502020001 WINGDALE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2018   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
2064679 NY Dutchess   school 3609210 130502020000   DOVER 360921000706 130502020002 DOVER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2018   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
2064698 NY Dutchess   school 3609210 130502020000   DOVER 360921000707 130502020003 DOVER HIGH SCHOOL public Regular School No High 09 12 2018   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
2064717 NY Dutchess   school 3609210 130502020000   DOVER 360921004332 130502020004 DOVER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 78.0 5.0 24.0         3.0     1.0   47.0 64.0     7       59     15   111 78 5 24         3     1   47 64     7   59   15   111
2064736 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001272 130801060002 NETHERWOOD SCHOOL public Regular School No Elementary KG 05 2018   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
2064755 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001274 130801060003 RALPH R SMITH SCHOOL public Regular School No Elementary KG 05 2018   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
2064774 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001276 130801060005 VIOLET AVENUE SCHOOL public Regular School No Elementary KG 05 2018   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
2064793 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001270 130801060006 HAVILAND MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 167.0 37.0 42.0   2.0     8.0     14.0   135.0 135.0     7       146     49   270 167 37 42   2     8     14   135 135     7   146   49   270
2064812 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001269 130801060007 FRANKLIN D ROOSEVELT SENIOR HS public Regular School No High 09 12 2018   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
2064831 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001273 130801060008 NORTH PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   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
2064850 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039004093 131101040004 WEBUTUCK HIGH SCHOOL public Regular School No High 09 12 2018   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
2064869 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039004971 131101040006 WEBUTUCK ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2018   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
2064888 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039005848 131101040007 EUGENE BROOKS MIDDLE SCHOOL public Regular School No Middle 04 08 2018   grade_7 49.0 2.0 2.0         1.0     3.0   32.0 25.0     0       *     12   57 49 2 2         1     3   32 25     0       12   57
2064907 NY Dutchess   school 3622530 131201040000   PAWLING 362253003172 131201040001 PAWLING ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   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
2064926 NY Dutchess   school 3622530 131201040000   PAWLING 362253003173 131201040002 PAWLING HIGH SCHOOL public Regular School No High 09 12 2018   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
2064945 NY Dutchess   school 3622530 131201040000   PAWLING 362253003255 131201040003 PAWLING MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_7 82.0 1.0 14.0         2.0     1.0   47.0 53.0     *       *     17   100 82 1 14         2     1   47 53             17   100
2064964 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2018   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
2064983 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003231 131301040002 STISSING MOUNTAIN JR/SR HIGH SCHOOL public Regular School No High 06 12 2018   grade_7 68.0 0.0 7.0   1.0     0.0     1.0   39.0 38.0     *       31     17   77 68 0 7   1     0     1   39 38         31   17   77
2065002 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No Elementary PK 01 2018   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
2065021 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Elementary KG 05 2018   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
2065040 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   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
2065059 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003304 131500010006 G W KRIEGER SCHOOL public Regular School No Elementary KG 05 2018   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
2065078 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376004616 131500010007 SMITH EARLY LEARNING CENTER public Regular School No Elementary PK KG 2018   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
2065097 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003306 131500010009 MORSE YOUNG MAGNET SCHOOL public Regular School No Elementary KG 06 2018   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
2065116 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003307 131500010010 POUGHKEEPSIE HIGH SCHOOL public Regular School No High 09 12 2018   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
2065135 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003308 131500010011 POUGHKEEPSIE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 24.0 169.0 99.0   1.0     3.0     15.0   145.0 166.0     25       268     60   311 24 169 99   1     3     15   145 166     25   268   60   311
2065154 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000086 131601060001 ARTHUR S MAY SCHOOL public Regular School No Elementary KG 05 2018   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
2065173 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000089 131601060002 BEEKMAN SCHOOL public Regular School No Elementary KG 05 2018   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
2065192 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000093 131601060004 OVERLOOK PRIMARY SCHOOL public Regular School No Elementary KG 03 2018   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
2065211 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000095 131601060005 TRAVER ROAD PRIMARY SCHOOL public Regular School No Elementary KG 02 2018   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
2065230 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000088 131601060008 ARLINGTON HIGH SCHOOL public Regular School No High 09 12 2018   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
2065249 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No Elementary 03 05 2018   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
2065268 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000092 131601060011 NOXON ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   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
2065287 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003266 131601060012 LAGRANGE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 182.0 38.0 73.0   0.0     9.0     6.0   161.0 147.0     17       121     54   308 182 38 73   0     9     6   161 147     17   121   54   308
2065306 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No Elementary 03 05 2018   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
2065325 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005596 131601060014 VAIL FARM ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   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
2065344 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 263.0 15.0 43.0         8.0     13.0   155.0 187.0     *       67     66   342 263 15 43         8     13   155 187         67   66   342
2065363 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000430 131602020001 HAGAN SCHOOL public Regular School No Elementary 03 05 2018   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
2065382 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000432 131602020003 NASSAU SCHOOL public Regular School No Elementary KG 02 2018   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
2065401 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000433 131602020004 ORVILLE A TODD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 69.0 16.0 21.0         14.0     1.0   63.0 58.0     *       33     20   121 69 16 21         14     1   63 58         33   20   121
2065420 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000434 131602020005 SPACKENKILL HIGH SCHOOL public Regular School No High 09 12 2018   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
2065439 NY Dutchess   school 3624240 131701060000   RED HOOK 362424003334 131701060002 RED HOOK SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   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
2065458 NY Dutchess   school 3624240 131701060000   RED HOOK 362424003333 131701060004 LINDEN AVENUE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 116.0 5.0 7.0   1.0     8.0     0.0   71.0 66.0     *       45     20   137 116 5 7   1     8     0   71 66         45   20   137
2065477 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000225 131701060006 MILL ROAD-INTERMEDIATE GRADES public Regular School No Elementary 03 05 2018   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
2065496 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000247 131701060008 MILL ROAD-PRIMARY GRADES public Regular School No Elementary PK 02 2018   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
2065515 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003345 131801040001 RHINEBECK SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   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
2065534 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003344 131801040002 CHANCELLOR LIVINGSTON ELEMENTARY SCH public Regular School No Elementary KG 05 2018   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
2065553 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003343 131801040003 BULKELEY MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 70.0 3.0 10.0         1.0     3.0   47.0 40.0     *       28     10   87 70 3 10         1     3   47 40         28   10   87
2065572 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004013 132101060001 BRINCKERHOFF ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   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
2065591 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004014 132101060002 FISHKILL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   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
2065610 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004015 132101060003 FISHKILL PLAINS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   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
2065629 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004016 132101060004 GAYHEAD SCHOOL public Regular School No Elementary KG 06 2018   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
2065648 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004017 132101060005 JAMES S EVANS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   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
2065667 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988001118 132101060006 KINRY ROAD ELEMENTARY SCHOOL public Regular School No Middle 04 06 2018   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
2065686 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004025 132101060007 VASSAR ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   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
2065705 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004023 132101060008 SHEAFE ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   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
2065724 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004024 132101060009 VAN WYCK JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_7 351.0 29.0 54.0         19.0     4.0   227.0 230.0             86     69   457 351 29 54         19     4   227 230         86   69   457
2065743 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_7 245.0 19.0 92.0         25.0     8.0   202.0 187.0     9       142     73   389 245 19 92         25     8   202 187     9   142   73   389
2065762 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004022 132101060011 ROY C KETCHAM SENIOR HIGH SCH public Regular School No High 09 12 2018   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
2065781 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004021 132101060012 OAK GROVE ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   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
2065800 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004020 132101060013 MYERS CORNERS SCHOOL public Regular School No Elementary KG 06 2018   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
2065819 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004018 132101060015 JOHN JAY SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   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
2065838 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2018   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
2065857 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001772 132201040001 MILLBROOK MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 59.0 3.0 9.0               4.0   38.0 37.0     *       26     13   75 59 3 9               4   38 37         26   13   75
2065876 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001770 132201040002 ALDEN PLACE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2018   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
2065895 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001771 132201040003 ELM DRIVE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2018   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
2065914 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938005859 132201040005 MILLBROOK HIGH SCHOOL public Regular School No High 09 12 2018   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
2065933 NY Erie   school 3602550 140101060000   ALDEN 360255000041 140101060003 ALDEN PRIMARY AT TOWNLINE public Regular School No Elementary KG 02 2018   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

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