Data source: Big Local News · About: Big Local

4,741 rows where grade = "grade_7", state = "NY" and year = 2021 sorted by district_state_id

View and edit SQL

year

  • 2021 · 4,641

grade

  • grade_7 · 4,641
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
1447957 NY Cortland   school 3618450 110901040000   MARATHON 361845001660 110901040002 WILLIAM APPLEBY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1434258 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1434277 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2021   grade_7 31.0 15.0 23.0         11.0     16.0   49.0 47.0     7       74     12   96 31 15 23         11     16   49 47     7   74   12   96
1448014 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other KG 12 2021   grade_7 2.0 0.0 0.0                   1.0 1.0                       2 2 0 0                   1 1                 2
1448033 NY Delaware   school 3609240 120301040000   DOWNSVILLE 360924000709 120301040001 DOWNSVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 19.0 1.0 1.0         1.0     0.0   9.0 13.0             8     *   22 19 1 1         1     0   9 13         8       22
1448052 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No Other PK 12 2021   grade_7 26.0 0.0 2.0               1.0   15.0 14.0             19     5   29 26 0 2               1   15 14         19   5   29
1448071 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000680 120501040001 DELAWARE ACADEMY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   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
1448090 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000681 120501040002 DELAWARE ACADEMY HIGH SCHOOL public Regular School No High 06 12 2021   grade_7 41.0 0.0 0.0         1.0     0.0   20.0 22.0             18     8   42 41 0 0         1     0   20 22         18   8   42
1448109 NY Delaware   school 3611430 120701040000   FRANKLIN 361143000900 120701040001 FRANKLIN CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 14.0 1.0 0.0   0.0     0.0     2.0   11.0 6.0             8     5   17 14 1 0   0     0     2   11 6         8   5   17
1448128 NY Delaware   school 3613560 120906040000   HANCOCK 361356001109 120906040001 HANCOCK ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   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
1448147 NY Delaware   school 3613560 120906040000   HANCOCK 361356001110 120906040002 HANCOCK JUNIOR-SENIOR HS public Regular School No High 05 12 2021   grade_7 18.0 1.0 4.0   0.0     1.0         13.0 11.0             12     *   24 18 1 4   0     1         13 11         12       24
1448166 NY Delaware   school 3618510 121401040000   MARGARETVILLE 361851001667 121401040001 MARGARETVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 19.0 0.0 5.0   0.0     1.0     1.0   15.0 11.0     *       16     7   26 19 0 5   0     1     1   15 11         16   7   26
1448185 NY Delaware   school 3625110 121502040000   ROXBURY 362511003473 121502040001 ROXBURY CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 19.0 1.0 0.0               0.0   7.0 13.0             9     5   20 19 1 0               0   7 13         9   5   20
1448204 NY Delaware   school 3626850 121601060000   SIDNEY 362685003662 121601060002 SIDNEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1448223 NY Delaware   school 3626850 121601060000   SIDNEY 362685003664 121601060005 SIDNEY MIDDLE SCHOOL public Regular School No Middle 07 08 2021   grade_7 77.0 0.0 6.0         1.0     8.0   48.0 44.0     *       52     17   92 77 0 6         1     8   48 44         52   17   92
1448242 NY Delaware   school 3626850 121601060000   SIDNEY 362685003663 121601060006 SIDNEY HIGH SCHOOL public Regular School No High 09 12 2021   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
1448261 NY Delaware   school 3628020 121701040000   STAMFORD 362802003796 121701040001 STAMFORD CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 25.0 1.0 1.0   0.0     0.0     0.0   13.0 14.0             14     7   27 25 1 1   0     0     0   13 14         14   7   27
1448280 NY Delaware   school 3627330 121702040000   SOUTH KORTRIGHT 362733003730 121702040001 SOUTH KORTRIGHT CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 22.0 0.0 0.0         0.0     0.0   14.0 8.0     *             *   22 22 0 0         0     0   14 8                 22
1448299 NY Delaware   school 3629820 121901040000   WALTON 362982004005 121901040001 TOWNSEND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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
1448318 NY Delaware   school 3629820 121901040000   WALTON 362982004006 121901040002 WALTON HIGH SCHOOL public Regular School No High 09 12 2021   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
1448337 NY Delaware   school 3629820 121901040000   WALTON 362982004791 121901040003 WALTON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 73.0 1.0 4.0         1.0         41.0 38.0             41     15   79 73 1 4         1         41 38         41   15   79
1448356 NY Dutchess   school 3604140 130200010000   BEACON 360414000179 130200010001 J V FORRESTAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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
1448375 NY Dutchess   school 3604140 130200010000   BEACON 360414000182 130200010002 SOUTH AVENUE SCHOOL public Regular School No Elementary KG 05 2021   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
1448394 NY Dutchess   school 3604140 130200010000   BEACON 360414000178 130200010003 GLENHAM SCHOOL public Regular School No Elementary PK 05 2021   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
1448413 NY Dutchess   school 3604140 130200010000   BEACON 360414000180 130200010004 ROMBOUT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 89.0 34.0 53.0         7.0     15.0   112.0 86.0     *       103     33   198 89 34 53         7     15   112 86         103   33   198
1448432 NY Dutchess   school 3604140 130200010000   BEACON 360414000177 130200010005 BEACON HIGH SCHOOL public Regular School No High 09 12 2021   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
1448451 NY Dutchess   school 3604140 130200010000   BEACON 360414000181 130200010006 SARGENT SCHOOL public Regular School No Elementary PK 05 2021   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
1448470 NY Dutchess   school 3609210 130502020000   DOVER 360921000708 130502020001 WINGDALE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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
1448489 NY Dutchess   school 3609210 130502020000   DOVER 360921000706 130502020002 DOVER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2021   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
1448508 NY Dutchess   school 3609210 130502020000   DOVER 360921000707 130502020003 DOVER HIGH SCHOOL public Regular School No High 09 12 2021   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
1448527 NY Dutchess   school 3609210 130502020000   DOVER 360921004332 130502020004 DOVER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 84.0 4.0 41.0         1.0     7.0   63.0 74.0     *       83     26   137 84 4 41         1     7   63 74         83   26   137
1448546 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001272 130801060002 NETHERWOOD SCHOOL public Regular School No Elementary KG 05 2021   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
1448565 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001274 130801060003 RALPH R SMITH SCHOOL public Regular School No Elementary KG 05 2021   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
1448584 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001276 130801060005 VIOLET AVENUE SCHOOL public Regular School No Elementary KG 05 2021   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
1448603 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001270 130801060006 HAVILAND MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 159.0 30.0 49.0   2.0     0.0     12.0   137.0 115.0     *       *     51   252 159 30 49   2     0     12   137 115             51   252
1448622 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001269 130801060007 FRANKLIN D ROOSEVELT SENIOR HS public Regular School No High 09 12 2021   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
1448641 NY Dutchess   school 3615180 130801060000   HYDE PARK 361518001273 130801060008 NORTH PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   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
1448660 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039004093 131101040004 WEBUTUCK HIGH SCHOOL public Regular School No High 09 12 2021   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
1448679 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039004971 131101040006 WEBUTUCK ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   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
1448698 NY Dutchess   school 3630390 131101040000   NORTHEAST 363039005848 131101040007 EUGENE BROOKS MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 41.0 2.0 12.0               0.0   28.0 27.0     5       26     9   55 41 2 12               0   28 27     5   26   9   55
1448717 NY Dutchess   school 3622530 131201040000   PAWLING 362253003172 131201040001 PAWLING ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   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
1448736 NY Dutchess   school 3622530 131201040000   PAWLING 362253003173 131201040002 PAWLING HIGH SCHOOL public Regular School No High 09 12 2021   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
1448755 NY Dutchess   school 3622530 131201040000   PAWLING 362253003255 131201040003 PAWLING MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 64.0 2.0 20.0         1.0     1.0   53.0 35.0     *       29     11   88 64 2 20         1     1   53 35         29   11   88
1448774 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003230 131301040001 SEYMOUR SMITH INTERMEDIATE LRN CTR public Regular School No Elementary 02 05 2021   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
1448793 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304003231 131301040002 STISSING MOUNTAIN JR/SR HIGH SCHOOL public Regular School No High 06 12 2021   grade_7 73.0 0.0 10.0   0.0     0.0     5.0   43.0 45.0     *       39     13   88 73 0 10   0     0     5   43 45         39   13   88
1448812 NY Dutchess   school 3623040 131301040000   PINE PLAINS 362304004530 131301040003 COLD SPRING EARLY LEARNING CTR public Regular School No Elementary PK 01 2021   grade_7 0.0   0.0               0.0   0.0 0.0     *       0     0   0 0   0               0   0 0         0   0   0
1448831 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003302 131500010001 WARRING MAGNET ACAD OF SCI & TECH public Regular School No Elementary 01 07 2021   grade_7 0.0 1.0 0.0         0.0     0.0   0.0 1.0     0       0     0   1 0 1 0         0     0   0 1     0   0   0   1
1448850 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2021   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
1448869 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003304 131500010006 G W KRIEGER SCHOOL public Regular School No Elementary 01 05 2021   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
1448888 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376004616 131500010007 SMITH EARLY LEARNING CENTER public Regular School No Elementary PK KG 2021   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
1448907 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003306 131500010009 MORSE YOUNG MAGNET SCHOOL public Regular School No Elementary KG 06 2021   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
1448926 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003307 131500010010 POUGHKEEPSIE HIGH SCHOOL public Regular School No High 09 12 2021   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
1448945 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003308 131500010011 POUGHKEEPSIE MIDDLE SCHOOL public Regular School No Middle 06 10 2021   grade_7 23.0 125.0 121.0   0.0     2.0     33.0   163.0 141.0     32       221     54   304 23 125 121   0     2     33   163 141     32   221   54   304
1448964 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000086 131601060001 ARTHUR S MAY SCHOOL public Regular School No Elementary KG 05 2021   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
1448983 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000089 131601060002 BEEKMAN SCHOOL public Regular School No Elementary KG 05 2021   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
1449002 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000093 131601060004 OVERLOOK PRIMARY SCHOOL public Regular School No Elementary KG 02 2021   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
1449021 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000095 131601060005 TRAVER ROAD PRIMARY SCHOOL public Regular School No Elementary KG 02 2021   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
1449040 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000088 131601060008 ARLINGTON HIGH SCHOOL public Regular School No High 09 12 2021   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
1449059 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No Elementary 03 05 2021   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
1449078 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000092 131601060011 NOXON ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   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
1449097 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003266 131601060012 LAGRANGE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 157.0 41.0 55.0   1.0     10.0     22.0   155.0 131.0     8       107     49   286 157 41 55   1     10     22   155 131     8   107   49   286
1449116 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No Elementary 03 05 2021   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
1449135 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005596 131601060014 VAIL FARM ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   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
1449154 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 201.0 15.0 48.0         5.0     11.0   148.0 132.0     *       53     46   280 201 15 48         5     11   148 132         53   46   280
1449173 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000430 131602020001 HAGAN SCHOOL public Regular School No Elementary 03 05 2021   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
1449192 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000432 131602020003 NASSAU SCHOOL public Regular School No Elementary KG 02 2021   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
1449211 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000433 131602020004 ORVILLE A TODD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 65.0 15.0 16.0   1.0     14.0     8.0   58.0 61.0     *       27     11   119 65 15 16   1     14     8   58 61         27   11   119
1449230 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000434 131602020005 SPACKENKILL HIGH SCHOOL public Regular School No High 09 12 2021   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
1449249 NY Dutchess   school 3624240 131701060000   RED HOOK 362424003334 131701060002 RED HOOK SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1449268 NY Dutchess   school 3624240 131701060000   RED HOOK 362424003333 131701060004 LINDEN AVENUE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 112.0 1.0 4.0         2.0     2.0   54.0 67.0     *       24     11   121 112 1 4         2     2   54 67         24   11   121
1449287 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000225 131701060006 MILL ROAD-INTERMEDIATE GRADES public Regular School No Elementary 03 05 2021   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
1449306 NY Dutchess   school 3624240 131701060000   RED HOOK 362424000247 131701060008 MILL ROAD-PRIMARY GRADES public Regular School No Elementary PK 02 2021   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
1449325 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003345 131801040001 RHINEBECK SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1449344 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003344 131801040002 CHANCELLOR LIVINGSTON ELEMENTARY SCH public Regular School No Elementary KG 05 2021   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
1449363 NY Dutchess   school 3624480 131801040000   RHINEBECK 362448003343 131801040003 BULKELEY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 57.0 1.0 6.0   0.0     3.0     7.0   38.0 36.0     *       *     *   74 57 1 6   0     3     7   38 36                 74
1449382 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004013 132101060001 BRINCKERHOFF ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   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
1449401 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004014 132101060002 FISHKILL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   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
1449420 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004015 132101060003 FISHKILL PLAINS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   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
1449439 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004016 132101060004 GAYHEAD SCHOOL public Regular School No Elementary KG 06 2021   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
1449458 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004017 132101060005 JAMES S EVANS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   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
1449477 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988001118 132101060006 KINRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2021   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
1449496 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004025 132101060007 VASSAR ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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
1449515 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004023 132101060008 SHEAFE ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   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
1449534 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004024 132101060009 VAN WYCK JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2021   grade_7 316.0 17.0 63.0         17.0     6.0   219.0 200.0             87     *   419 316 17 63         17     6   219 200         87       419
1449553 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004026 132101060010 WAPPINGERS JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2021   grade_7 214.0 32.0 110.0         16.0     21.0   198.0 195.0     17       171     66   393 214 32 110         16     21   198 195     17   171   66   393
1449572 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004022 132101060011 ROY C KETCHAM SENIOR HIGH SCH public Regular School No High 09 12 2021   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
1449591 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004021 132101060012 OAK GROVE ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   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
1449610 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004020 132101060013 MYERS CORNERS SCHOOL public Regular School No Elementary KG 06 2021   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
1449629 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004018 132101060015 JOHN JAY SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1449648 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449667 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001772 132201040001 MILLBROOK MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 39.0 2.0 20.0         0.0     3.0   28.0 36.0     *       23     *   64 39 2 20         0     3   28 36         23       64
1449686 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001770 132201040002 ALDEN PLACE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2021   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
1449705 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001771 132201040003 ELM DRIVE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   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
1449724 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938005859 132201040005 MILLBROOK HIGH SCHOOL public Regular School No High 09 12 2021   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
1449743 NY Erie   school 3602550 140101060000   ALDEN 360255000041 140101060003 ALDEN PRIMARY AT TOWNLINE public Regular School No Elementary KG 02 2021   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
1449762 NY Erie   school 3602550 140101060000   ALDEN 360255000038 140101060005 ALDEN MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 98.0 3.0 2.0   1.0     2.0     1.0   49.0 58.0             31     8   107 98 3 2   1     2     1   49 58         31   8   107
1449781 NY Erie   school 3602550 140101060000   ALDEN 360255000039 140101060006 ALDEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1449800 NY Erie   school 3602550 140101060000   ALDEN 360255006572 140101060007 ALDEN INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2021   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
1449819 NY Erie   school 3602920 140201060000   AMHERST 360292004335 140201060001 AMHERST MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 164.0 41.0 19.0   1.0     19.0     6.0   122.0 128.0     12       79     29   250 164 41 19   1     19     6   122 128     12   79   29   250
1449838 NY Erie   school 3602920 140201060000   AMHERST 360292000061 140201060002 AMHERST CENTRAL HIGH SCHOOL public Regular School No High 09 12 2021   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

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