Data source: Big Local News · About: Big Local

4,741 rows where grade = "grade_6", state = "NY" and year = 2021 sorted by low_income_int

View and edit SQL

year

  • 2021 · 4,741

grade

  • grade_6 · 4,741
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
1433212 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2021   grade_6 1.0 1.0 2.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 1 1 2   0     0     0   4 0                 4
1433611 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 05 08 2021   grade_6 90.0 4.0 13.0         2.0     13.0   61.0 61.0     *       *     *   122 90 4 13         2     13   61 61                 122
1434010 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2021   grade_6 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 1 0 0   0     0     0   1 0     0           1
1434447 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 7.0   0.0                   3.0 4.0     *       *     0   7 7   0                   3 4             0   7
1434523 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 13.0 0.0 0.0   0.0           0.0   6.0 7.0             *     *   13 13 0 0   0           0   6 7                 13
1443795 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001373 31502060005 JOHNSON CITY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 82.0 22.0 19.0   0.0     16.0     16.0   78.0 77.0     14       *     *   155 82 22 19   0     16     16   78 77     14           155
1444042 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 16.0   0.0   0.0           0.0   8.0 8.0             *     5   16 16   0   0           0   8 8             5   16
1444308 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 04 07 2021   grade_6 101.0 5.0 3.0   0.0     7.0     13.0   63.0 66.0     *       *     22   129 101 5 3   0     7     13   63 66             22   129
1444479 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2021   grade_6 2.0 2.0 1.0   0.0     0.0     1.0   4.0 2.0             *     6   6 2 2 1   0     0     1   4 2             6   6
1444555 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_6         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1445144 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000451 60401040006 CASSADAGA VALLEY MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2021   grade_6 46.0 0.0 0.0         0.0     1.0   18.0 29.0             *     *   47 46 0 0         0     1   18 29                 47
1445220 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003232 60601040003 PINE VALLEY CENTRAL JR-SR HIGH SCH public Regular School No High 06 12 2021   grade_6 4.0 0.0 0.0   0.0           0.0   4.0 0.0     *       *     *   4 4 0 0   0           0   4 0                 4
1446341 NY Chemung   school 3614850 70901060000   HORSEHEADS 361485001244 70901060011 HORSEHEADS INTERMEDIATE SCHOOL public Regular School No Middle 05 06 2021   grade_6 234.0 2.0 13.0         15.0     25.0   161.0 128.0     *       *     39   289 234 2 13         15     25   161 128             39   289
1446569 NY Chenango   school 3612750 80601040000   GREENE 361275004686 80601040004 GREENE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 59.0   0.0   0.0     1.0         37.0 23.0             *     *   60 59   0   0     1         37 23                 60
1447253 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003262 91200010005 STAFFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 111.0 8.0 2.0   0.0     5.0     1.0   68.0 59.0             *     28   127 111 8 2   0     5     1   68 59             28   127
1447728 NY Cortland   school 3608460 110200010000   CORTLAND 360846000650 110200010009 RANDALL MIDDLE SCHOOL public Regular School No Middle 05 06 2021   grade_6 139.0 6.0 8.0         1.0     10.0   83.0 81.0             *     28   164 139 6 8         1     10   83 81             28   164
1449153 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 186.0 11.0 43.0         7.0     11.0   126.0 132.0     *       *     40   258 186 11 43         7     11   126 132             40   258
1449210 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000433 131602020004 ORVILLE A TODD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 47.0 5.0 19.0   0.0     12.0     4.0   43.0 44.0     *       *     *   87 47 5 19   0     12     4   43 44                 87
1449476 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988001118 132101060006 KINRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2021   grade_6 65.0 12.0 14.0   0.0     6.0     0.0   47.0 50.0     *       *     15   97 65 12 14   0     6     0   47 50             15   97
1450825 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2021   grade_6 1.0 0.0 0.0         0.0     0.0   1.0 0.0     0       *     0   1 1 0 0         0     0   1 0     0       0   1
1453371 NY Erie   school 3628740 142500010000   TONAWANDA 362874003902 142500010003 FLETCHER ELEMENTARY SCHOOL public Regular School No Middle 04 06 2021   grade_6 1.0 0.0 0.0         0.0     0.0   1.0 0.0     *       *     *   1 1 0 0         0     0   1 0                 1
1453732 NY Erie   school 3630780 142801060000   WEST SENECA 363078004142 142801060015 CLINTON ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_6 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 0 1 0   0     0     0   1 0                 1
1453903 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 5.0 0.0 0.0         0.0         4.0 1.0             *     *   5 5 0 0         0         4 1                 5
1454511 NY Fulton   school 3612270 170500010000   GLOVERSVILLE 361227000986 170500010008 GLOVERSVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 137.0 10.0 19.0   0.0     1.0     20.0   101.0 86.0     *       *     37   187 137 10 19   0     1     20   101 86             37   187
1454606 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001381 170600010006 JOHNSTOWN JUNIOR-SENIOR HS public Regular School No High 06 12 2021   grade_6 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     *       *     0   1 1 0 0   0     0     0   1 0             0   1
1455423 NY Hamilton   school 3616530 200601040000   LAKE PLEASANT 361653001461 200601040001 LAKE PLEASANT SCHOOL public Regular School No Elementary PK 08 2021   grade_6 11.0                   0.0   6.0 5.0             *     *   11 11                   0   6 5                 11
1455442 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 2.0 0.0 0.0               1.0   0.0 3.0     *       *     0   3 2 0 0               1   0 3             0   3
1455461 NY Hamilton   school 3630450 200901040000   WELLS 363045004096 200901040001 WELLS SCHOOL public Regular School No Other PK 12 2021   grade_6 6.0 0.0 0.0                   3.0 3.0             *     *   6 6 0 0                   3 3                 6
1461541 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602707 331800010211 IS 211 JOHN WILSON public Regular School No Middle 06 08 2021   grade_6 3.0 45.0 7.0   0.0     3.0     0.0   35.0 23.0     5       *     *   58 3 45 7   0     3     0   35 23     5           58
1467146 NY Kings   school 3601124 333200861045   ACHIEVEMENT FIRST NORTH BROOK 360112406457 333200861045 ACHIEVEMENT FIRST NORTH BROOKLYN PRE charter Regular School Yes Elementary KG 07 2021   grade_6 1.0 21.0 74.0   0.0     0.0     0.0   51.0 45.0     *       *     20   96 1 21 74   0     0     0   51 45             20   96
1467849 NY Madison   school 3606780 250201060000   CAZENOVIA 360678000467 250201060001 CAZENOVIA MIDDLE SCHOOL public Regular School No Middle 05 07 2021   grade_6 85.0   1.0         1.0     1.0   46.0 42.0     *       *     *   88 85   1         1     1   46 42                 88
1469065 NY Monroe   school 3615390 260803060000   WEST IRONDEQUOIT 361539001308 260803060004 ROGERS MIDDLE SCHOOL public Regular School No Middle 04 06 2021   grade_6 87.0 13.0 20.0   2.0     4.0     6.0   68.0 64.0     *       *     *   132 87 13 20   2     4     6   68 64                 132
1469445 NY Monroe   school 3614460 261101060000   HILTON 361446001200 261101060005 MERTON WILLIAMS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     0       *     *   1 1 0 0   0     0     0   0 1     0           1
1469559 NY Monroe   school 3622710 261201060000   PENFIELD 362271003191 261201060008 BAY TRAIL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 282.0 20.0 16.0         11.0     19.0   186.0 162.0     *       *     34   348 282 20 16         11     19   186 162             34   348
1469882 NY Monroe   school 3623160 261401060000   PITTSFORD 362316004490 261401060008 BARKER ROAD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 182.0 5.0 9.0   1.0     22.0     14.0   124.0 109.0             *     41   233 182 5 9   1     22     14   124 109             41   233
1469901 NY Monroe   school 3623160 261401060000   PITTSFORD 362316003243 261401060009 THORNELL ROAD SCHOOL public Regular School No Elementary KG 05 2021   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             *     0   0 0 0 0   0     0     0   0 0             0   0
1469939 NY Monroe   school 3623160 261401060000   PITTSFORD 362316005850 261401060011 CALKINS ROAD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 145.0 5.0 18.0         18.0     20.0   97.0 109.0     *       *     23   206 145 5 18         18     20   97 109             23   206
1472124 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   grade_6 0.0 7.0 39.0   0.0     1.0         21.0 26.0     *       *     0   47 0 7 39   0     1         21 26             0   47
1472371 NY Nassau   school 3629280 280202030000   UNIONDALE 362928003940 280202030008 LAWRENCE ROAD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 3.0 91.0 155.0         4.0     2.0   142.0 113.0     49       *     29   255 3 91 155         4     2   142 113     49       29   255
1472637 NY Nassau   school 3620940 280204020000   NORTH BELLMORE 362094002975 280204020004 PARK AVENUE SCHOOL public Regular School No Elementary KG 06 2021   grade_6 42.0 1.0 7.0   0.0     2.0     1.0   29.0 24.0     0       *     8   53 42 1 7   0     2     1   29 24     0       8   53
1473511 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003057 280211030007 SCHOOL 9E-BOARDMAN ELEM SCHOOL public Regular School No Elementary 01 06 2021   grade_6 25.0 1.0 6.0         5.0     2.0   23.0 16.0     0       *     *   39 25 1 6         5     2   23 16     0           39
1474138 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176001637 280218030001 HEMLOCK SCHOOL public Regular School No Elementary KG 01 2021   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     0   0 0 0 0         0     0   0 0             0   0
1474157 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000944 280218030002 HOMESTEAD SCHOOL public Regular School No Elementary KG 01 2021   grade_6 0.0   0.0         0.0     0.0   0.0 0.0     *       *     0   0 0   0         0     0   0 0             0   0
1474176 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000945 280218030003 LOCUST SCHOOL public Regular School No Elementary KG 01 2021   grade_6 0.0   0.0         0.0         0.0 0.0     0       *     0   0 0   0         0         0 0     0       0   0
1475772 NY Nassau   school 3625050 280403030000   ROSLYN 362505003470 280403030008 ROSLYN HIGH SCHOOL public Regular School No High 09 12 2021   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     0   0 0 0 0         0     0   0 0             0   0
1475962 NY Nassau   school 3620400 280405020000   NEW HYDE PARK 362040001885 280405020002 NEW HYDE PARK ROAD SCHOOL public Regular School No Elementary KG 06 2021   grade_6 17.0 1.0 10.0   0.0     29.0     2.0   30.0 29.0     *       *     8   59 17 1 10   0     29     2   30 29             8   59
1476000 NY Nassau   school 3620400 280405020000   NEW HYDE PARK 362040001884 280405020004 MANOR OAKS WILLIAM BOWIE SCHOOL public Regular School No Elementary PK 06 2021   grade_6 14.0 0.0 4.0   0.0     28.0     0.0   22.0 24.0     *       *     *   46 14 0 4   0     28     0   22 24                 46
1476247 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001016 280407030015 GREAT NECK NORTH HIGH SCHOOL public Regular School No High 09 12 2021   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       *     0   0 0 0 0         0     0   0 0     0       0   0
1476266 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 08 12 2021   grade_6 0.0   0.0         0.0         0.0 0.0             *     0   0 0   0         0         0 0             0   0
1476760 NY Nassau   school 3628560 280502060000   SYOSSET 362856003838 280502060011 H B THOMPSON MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 142.0 1.0 24.0   1.0     137.0     7.0   152.0 160.0     7       *     28   312 142 1 24   1     137     7   152 160     7       28   312
1477197 NY Nassau   school 3615810 280515030000   JERICHO 361581001369 280515030006 JERICHO MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 69.0 4.0 5.0         161.0     4.0   133.0 110.0     8       *     27   243 69 4 5         161     4   133 110     8       27   243
1477558 NY Nassau   school 3604740 280521030000   BETHPAGE 360474000220 280521030008 JOHN F KENNEDY MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 127.0 2.0 40.0         52.0     8.0   112.0 117.0     *       *     17   229 127 2 40         52     8   112 117             17   229
1477653 NY Nassau   school 3610980 280522030000   FARMINGDALE 361098000878 280522030008 HOWITT SCHOOL public Regular School No Middle 06 08 2021   grade_6 227.0 25.0 115.0   2.0     31.0     10.0   215.0 195.0     20       *     83   410 227 25 115   2     31     10   215 195     20       83   410
1477786 NY Nassau   school 3618630 280523030000   MASSAPEQUA 361863001682 280523030010 BERNER MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 470.0 2.0 23.0   0.0     10.0     7.0   251.0 261.0     *       *     60   512 470 2 23   0     10     7   251 261             60   512
1477862 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013503340 307500011035 PS 35 public Special Education School No Other 04 12 2021   grade_6 0.0 0.0 3.0   0.0     0.0     0.0   0.0 3.0     0       *     *   3 0 0 3   0     0     0   0 3     0           3
1477995 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502870 307500011751 MANHATTAN SCHOOL FOR CAREER DVLPMNT public Special Education School No High 07 12 2021   grade_6 0.0 0.0 2.0   0.0     0.0     0.0   1.0 1.0     *       *     *   2 0 0 2   0     0     0   1 1                 2
1478508 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500812 307500013372 PS 372 CHILDREN'S SCHOOL (THE) public Special Education School No Elementary PK 07 2021   grade_6 2.0 3.0 0.0   0.0     1.0     0.0   4.0 2.0     *       *     6   6 2 3 0   0     1     0   4 2             6   6
1478622 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013501926 307500013811 PS 811 CONNIE LEKAS SCHOOL public Special Education School No High 07 12 2021   grade_6 2.0 0.0 1.0   0.0     0.0     0.0   1.0 2.0     0       *     *   3 2 0 1   0     0     0   1 2     0           3
1478736 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502858 307500014224 PS 224 public Special Education School No Elementary PK 08 2021   grade_6 3.0 5.0 9.0   0.0     8.0     1.0   21.0 5.0     7       *     26   26 3 5 9   0     8     1   21 5     7       26   26
1482726 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007806115 310300011859 SPECIAL MUSIC SCHOOL public Regular School No Other KG 12 2021   grade_6 6.0 0.0 1.0   0.0     6.0     2.0   8.0 7.0     *       *     *   15 6 0 1   0     6     2   8 7                 15
1483657 NY New York   school 3600142 310400861061   NYC AUTISM CHARTER-EAST HARLE 360014205779 310400861061 NYC AUTISM CHARTER SCHOOL EAST HARLE charter Special Education School Yes Other 01 12 2021   grade_6 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 0 0 1   0     0     0   1 0                 1
1483809 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008102475 310500010129 PS 129 JOHN H FINLEY public Regular School No Elementary PK 08 2021   grade_6 0.0 1.0 0.0   0.0     0.0     0.0   0.0 1.0     0       *     0   1 0 1 0   0     0     0   0 1     0       0   1
1484455 NY New York   school 3601077 310500861015   NEIGHBORHOOD CHARTER SCHOOL 360107706308 310500861015 NEIGHBORHOOD CHARTER SCHOOL OF HARLE charter Regular School Yes Elementary KG 08 2021   grade_6 0.0 28.0 26.0         0.0     0.0   35.0 19.0     *       *     18   54 0 28 26         0     0   35 19             18   54
1484664 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302374 310600010098 PS 98 SHORAC KAPPOCK public Regular School No Elementary PK 06 2021   grade_6 0.0 0.0 1.0         0.0     0.0   1.0 0.0     0       *     *   1 0 0 1         0     0   1 0     0           1
1485709 NY Niagara   school 3617670 400400010000   LOCKPORT 361767001583 400400010009 EMMET BELKNAP INTERMEDIATE SCHOOL public Regular School No Middle 05 06 2021   grade_6 232.0 27.0 28.0   0.0     3.0     32.0   163.0 159.0     *       *     *   322 232 27 28   0     3     32   163 159                 322
1485823 NY Niagara   school 3620760 400601060000   NEWFANE 362076002921 400601060008 NEWFANE MIDDLE SCHOOL public Regular School No Middle 04 08 2021   grade_6 66.0 3.0 1.0   2.0     0.0     7.0   40.0 39.0             *     16   79 66 3 1   2     0     7   40 39             16   79
1485994 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082002937 400800010012 GERALDINE J MANN SCHOOL public Regular School No Elementary PK 06 2021   grade_6 23.0 1.0 2.0   0.0     3.0     4.0   17.0 16.0     *       *     *   33 23 1 2   0     3     4   17 16                 33
1486013 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082002926 400800010015 HENRY J KALFAS MAGNET SCHOOL public Regular School No Elementary PK 06 2021   grade_6 6.0 20.0 4.0   2.0     2.0     7.0   18.0 23.0     *       *     0   41 6 20 4   2     2     7   18 23             0   41
1486640 NY Oneida   school 3606240 410601040000   CAMDEN 360624000404 410601040010 CAMDEN MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_6 155.0 0.0 10.0   1.0     0.0     5.0   96.0 75.0     *       *     *   171 155 0 10   1     0     5   96 75                 171
1487267 NY Oneida   school 3614580 412201060000   HOLLAND PATENT 361458001211 412201060001 HOLLAND PATENT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 93.0                       54.0 39.0     *       *     11   93 93                       54 39             11   93
1488179 NY Onondaga   school 3609990 420401060000   EAST SYRACUSE MINOA 360999004718 420401060001 PARK HILL SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             *     *   0 0 0 0         0     0   0 0                 0
1489452 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003881 421800010006 VAN DUYN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_6 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 0 1 0   0     0     0   1 0                 1
1489585 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003859 421800010021 FRANKLIN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_6 0.0 1.0 0.0   0.0     0.0     1.0   2.0 0.0     0       *     *   2 0 1 0   0     0     1   2 0     0           2
1489623 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003873 421800010027 PORTER ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_6 1.0 1.0 0.0   0.0     0.0     0.0   2.0 0.0     0       *     0   2 1 1 0   0     0     0   2 0     0       0   2
1489756 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003869 421800010042 MCKINLEY-BRIGHTON ELEMENTARY public Regular School No Elementary PK 06 2021   grade_6 0.0 0.0 0.0   0.0     0.0     1.0   1.0 0.0     0       *     0   1 0 0 0   0     0     1   1 0     0       0   1
1489832 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003853 421800010052 DR WEEKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_6 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 1 0 0   0     0     0   1 0     0           1
1491200 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932001765 441000010010 MIDDLETOWN TWIN TOWERS MIDDLE SCH public Regular School No Middle 06 08 2021   grade_6 37.0 74.0 183.0   0.0     6.0     15.0   149.0 166.0     30       *     34   315 37 74 183   0     6     15   149 166     30       34   315
1491599 NY Orange   school 3619680 441301060000   VALLEY-MONTGMRY 361968001802 441301060006 VALLEY CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 184.0 31.0 94.0   1.0     5.0     18.0   170.0 163.0     *       *     65   333 184 31 94   1     5     18   170 163             65   333
1491941 NY Orange   school 3629190 441903020000   TUXEDO 362919003930 441903020001 GEORGE F BAKER HIGH SCH public Regular School No High 06 12 2021   grade_6 7.0 1.0 0.0         1.0     1.0   5.0 5.0     *       *     *   10 7 1 0         1     1   5 5                 10
1493100 NY Otsego   school 3610260 470501040000   EDMESTON 361026000797 470501040001 EDMESTON CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 26.0 0.0 1.0         0.0     0.0   14.0 13.0             *     *   27 26 0 1         0     0   14 13                 27
1493347 NY Otsego   school 3608250 471701040000   COOPERSTOWN 360825000607 471701040001 COOPERSTOWN ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_6 49.0 1.0 0.0         4.0     0.0   36.0 18.0             *     6   54 49 1 0         4     0   36 18             6   54
1493499 NY Putnam   school 3618120 480101060000   MAHOPAC 361812001625 480101060004 MAHOPAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 206.0 11.0 62.0   1.0     7.0     6.0   141.0 152.0     7       *     48   293 206 11 62   1     7     6   141 152     7       48   293
1493556 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Alternative School No Middle 06 08 2021   grade_6 1.0   0.0         0.0         1.0 0.0             *     *   1 1   0         0         1 0                 1
1493651 NY Putnam   school 3606570 480102060000   CARMEL 360657000439 480102060007 GEORGE FISCHER MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_6 162.0 4.0 77.0   1.0     4.0     11.0   133.0 126.0     9       *     40   259 162 4 77   1     4     11   133 126     9       40   259
1493727 NY Putnam   school 3611860 480404020000   GARRISON 361186000948 480404020001 GARRISON SCHOOL public Regular School No Elementary KG 08 2021   grade_6 22.0 1.0 4.0         0.0     2.0   14.0 15.0     *       *     *   29 22 1 4         0     2   14 15                 29
1493860 NY Putnam   school 3605310 480601060000   BREWSTER 360531000266 480601060005 HENRY H WELLS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 111.0 5.0 105.0   0.0     5.0     6.0   128.0 104.0     26       *     41   232 111 5 105   0     5     6   128 104     26       41   232
1497147 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302704 342700010210 JHS 210 ELIZABETH BLACKWELL public Regular School No Middle 06 08 2021   grade_6 17.0 18.0 329.0   8.0     134.0     7.0   266.0 247.0     102       *     120   513 17 18 329   8     134     7   266 247     102       120   513
1499769 NY Queens   school 3600055 342900860821   MERRICK ACADEMY-QUEENS PUBLIC 360005504777 342900860821 MERRICK ACADEMY-QUEENS PUBLIC CHARTE charter Regular School Yes Elementary KG 06 2021   grade_6 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     0       *     0   1 0 0 1   0     0     0   1 0     0       0   1
1500434 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2021   grade_6 0.0 1.0 4.0   1.0     0.0         4.0 2.0     6       *     *   6 0 1 4   1     0         4 2     6           6
1503474 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401003211 500201060001 WILLOW GROVE ELEMENTARY SCHOOL public Regular School No Middle 04 06 2021   grade_6 43.0 32.0 98.0   1.0     8.0     1.0   98.0 85.0     25       *     26   183 43 32 98   1     8     1   98 85     25       26   183
1503664 NY Rockland   school 3627450 500301060000   SOUTH ORANGETOWN 362745003739 500301060008 SOUTH ORANGETOWN MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 124.0 2.0 34.0         16.0     12.0   88.0 100.0     8       *     *   188 124 2 34         16     12   88 100     8           188
1503987 NY Rockland   school 3628320 500401060000   SUFFERN 362832003817 500401060011 SUFFERN MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 105.0 30.0 98.0   1.0     26.0     17.0   143.0 134.0     34       *     *   277 105 30 98   1     26     17   143 134     34           277
1504481 NY Saint Lawrence   school 3612360 511101060000   GOUVERNEUR 361236001000 511101060006 GOUVERNEUR ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       *     0   0 0 0 0   0     0     0   0 0             0   0
1504823 NY Saint Lawrence   school 3621660 512300010000   OGDENSBURG 362166004325 512300010009 OGDENSBURG FREE ACADEMY public Regular School No High 06 12 2021   grade_6 1.0 0.0 0.0         0.0     0.0   1.0 0.0             *     *   1 1 0 0         0     0   1 0                 1
1506704 NY Schoharie   school 3612120 540801040000   GILBOA CONESVILLE 361212000970 540801040001 GILBOA-CONESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 21.0 0.0 0.0         0.0     1.0   17.0 5.0             *     *   22 21 0 0         0     1   17 5                 22
1506932 NY Schuyler   school 3621630 550101040000   ODESSA MONTOUR 362163003067 550101040002 HOWARD A HANLON ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2021   grade_6 51.0 0.0 1.0   0.0           3.0   25.0 30.0             *     7   55 51 0 1   0           3   25 30             7   55
1507179 NY Seneca   school 3600014 561006060000   WATERLOO 360001401431 561006060003 WATERLOO MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 111.0 2.0 5.0         0.0     2.0   59.0 61.0     *       *     *   120 111 2 5         0     2   59 61                 120
1507616 NY Steuben   school 3614820 571800010000   HORNELL 361482001232 571800010001 HORNELL INTERMEDIATE SCHOOL public Regular School No Middle 04 06 2021   grade_6 84.0 4.0 9.0         2.0     6.0   52.0 53.0     6       *     *   105 84 4 9         2     6   52 53     6           105
1507844 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101042 573002040003 WAYLAND-COHOCTON MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_6 83.0 0.0 2.0         1.0     0.0   40.0 46.0             *     *   86 83 0 2         1     0   40 46                 86
1507863 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101445 573002040004 COHOCTON ELEMENTARY SCHOOL public Regular School No Prekindergarten PK PK 2021   grade_6 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]);