Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_9", state = "NY" and year = 2019 sorted by asian_pacific_islander_int

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_9 · 4,719
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
2139104 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139123 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139142 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139161 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139180 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139199 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139218 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139237 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139256 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139275 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139313 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139332 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139351 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139370 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139389 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139408 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139427 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0     0.0     0       0     0   0 0 0 0         0     0     0     0   0   0   0
2139446 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139484 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139541 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2019   grade_9 53.0 0.0 1.0   0.0     0.0     1.0   31.0 24.0             24     11   55 53 0 1   0     0     1   31 24         24   11   55
2139560 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139579 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139598 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139617 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139636 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139655 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139693 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139731 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139750 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139769 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139788 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139807 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139845 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139864 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139883 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139902 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139921 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139959 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139978 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139997 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 09 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140016 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2140035 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140054 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140073 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140092 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140111 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140130 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140149 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140168 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140206 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2019   grade_9 19.0 2.0 0.0         0.0     0.0   11.0 10.0             8     *   21 19 2 0         0     0   11 10         8       21
2140225 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2140244 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2140263 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140301 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2140320 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140339 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2140358 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2140396 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2140415 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2140453 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2140472 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   grade_9 50.0 0.0 3.0         0.0     1.0   29.0 25.0             20     5   54 50 0 3         0     1   29 25         20   5   54
2140491 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2019   grade_9 23.0 1.0 0.0         0.0     0.0   16.0 8.0             13     7   24 23 1 0         0     0   16 8         13   7   24
2140510 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_9 23.0 0.0 0.0   1.0     0.0     1.0   16.0 9.0             19     5   25 23 0 0   1     0     1   16 9         19   5   25
2140548 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2019   grade_9 15.0   1.0         0.0         7.0 9.0             10     *   16 15   1         0         7 9         10       16
2140586 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_9 47.0 0.0 1.0   1.0     0.0         21.0 28.0     *       27     10   49 47 0 1   1     0         21 28         27   10   49
2140624 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 60.0 2.0 0.0         0.0     0.0   39.0 23.0             35     7   62 60 2 0         0     0   39 23         35   7   62
2140643 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2140662 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
2140700 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2019   grade_9 88.0 1.0 0.0   2.0     0.0     1.0   40.0 52.0     *       35     12   92 88 1 0   2     0     1   40 52         35   12   92
2140719 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2140795 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402043 320700010001 PS 1 COURTLANDT SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2140814 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402056 320700010005 PS 5 PORT MORRIS public Regular School No Elementary PK 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140833 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140852 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2140871 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No Elementary PK 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140890 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402143 320700010030 PS 30 WILTON public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140909 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402147 320700010031 PS/MS 31 WILLIAM LLOYD GARRISON public Regular School No Elementary PK 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2140928 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2140947 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140966 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140985 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2141004 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141023 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405533 320700010157 PS 157 GROVE HILL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141042 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 JUAN PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141061 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141080 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 LAB SCHOOL OF FIN & TECH: X223 public Regular School No High 06 12 2019   grade_9 1.0 22.0 73.0   1.0     0.0     0.0   53.0 44.0     *       90     15   97 1 22 73   1     0     0   53 44         90   15   97
2141099 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
2141118 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008403738 320700010277 PS 277 public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141137 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2019   grade_9   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
2141175 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405920 320700010343 ACADEMY OF APPLIED MATH AND TECH public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141194 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406382 320700010359 CONCOURSE VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2141232 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406613 320700010584 IS 584 public Regular School No Middle 06 08 2019   grade_9   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
2141251 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No High 06 12 2019   grade_9 2.0 20.0 73.0   0.0     0.0     0.0   45.0 50.0     10       90     22   95 2 20 73   0     0     0   45 50     10   90   22   95
2141308 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405988 320700011379 JILL CHAIFETZ TRANSFER HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 0.0 3.0 8.0   0.0     0.0     0.0   6.0 5.0     *       10     *   11 0 3 8   0     0     0   6 5         10       11
2141327 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406056 320700011381 BRONX HAVEN HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 0.0 10.0 10.0   0.0     0.0         13.0 7.0     *       14     8   20 0 10 10   0     0         13 7         14   8   20
2141422 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406253 320700011522 BRONX DESIGN-CONSTRUCTION ACADEMY public Career and Technical School No High 09 12 2019   grade_9 2.0 31.0 74.0   4.0     0.0     0.0   95.0 16.0     15       99     38   111 2 31 74   4     0     0   95 16     15   99   38   111
2141460 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405512 320700011548 CAREERS IN SPORTS HS public Regular School No High 09 12 2019   grade_9 1.0 55.0 105.0   0.0     0.0         131.0 30.0     26       150     53   161 1 55 105   0     0         131 30     26   150   53   161
2141479 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405504 320700011551 URBAN ASSEMBLY BRONX OF LETTERS public Regular School No High 06 12 2019   grade_9 2.0 32.0 54.0   1.0     0.0     0.0   42.0 47.0     9       79     23   89 2 32 54   1     0     0   42 47     9   79   23   89
2141517 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401909 320700011600 ALFRED E SMITH CAREER-TECH HIGH SCH public Career and Technical School No High 09 12 2019   grade_9 1.0 28.0 102.0   1.0     0.0     0.0   113.0 19.0     33       123     41   132 1 28 102   1     0     0   113 19     33   123   41   132
2141555 NY Bronx   school 3601074 320700860703   HEKETI COMMUNITY CHARTER SCH 360107406336 320700860703 HEKETI COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2019   grade_9 0.0 0.0 0.0   0.0     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]);