Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_9", state = "NY" and year = 2017 sorted by district descending

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_9 · 4,722
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
977709 NY Monroe   school 3601080 260501861020   YOUNG WOMEN'S COLLEGE PRE 360108006316 260501861020 YOUNG WOMEN'S COLLEGE PREP CHARTER charter Regular School Yes Other 07 11 2017   grade_9 4.0 51.0 25.0         2.0     6.0     88.0     7       74     9   88 4 51 25         2     6     88     7   74   9   88
1031365 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 224.0 12.0 32.0   0.0     19.0     8.0   148.0 147.0     *       30     41   295 224 12 32   0     19     8   148 147         30   41   295
1031384 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
1031403 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2017   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
1031422 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2017   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
1031441 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2017   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
953332 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   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
953351 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Other 05 09 2017   grade_9 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 1 0 0   0     0     0   1 0                 1
953370 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   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
953389 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 192.0 3.0 2.0   0.0     0.0         94.0 103.0     *       98     33   197 192 3 2   0     0         94 103         98   33   197
976645 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
976664 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 07 12 2017   grade_9 55.0 0.0 0.0   0.0     1.0     2.0   31.0 27.0     *       *     7   58 55 0 0   0     1     2   31 27             7   58
1030434 NY Westchester   school 3631920 662300010000   YONKERS 363192000452 662300010001 ROBERT C DODSON SCHOOL public Regular School No Elementary PK 08 2017   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
1030453 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No Elementary PK 08 2017   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
1030472 NY Westchester   school 3631920 662300010000   YONKERS 363192001527 662300010004 MONTESSORI SCHOOL 31 public Regular School No Elementary PK 06 2017   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
1030491 NY Westchester   school 3631920 662300010000   YONKERS 363192004252 662300010005 SCHOOL 5 public Regular School No Elementary PK 08 2017   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
1030510 NY Westchester   school 3631920 662300010000   YONKERS 363192001920 662300010007 WILLIAM BOYCE THOMPSON SCHOOL public Regular School No Elementary PK 08 2017   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
1030529 NY Westchester   school 3631920 662300010000   YONKERS 363192004254 662300010008 PATRICIA A DICHIARO SCHOOL public Regular School No Elementary PK 08 2017   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
1030548 NY Westchester   school 3631920 662300010000   YONKERS 363192004255 662300010009 SCHOOL 9 public Regular School No Elementary PK 06 2017   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
1030567 NY Westchester   school 3631920 662300010000   YONKERS 363192004258 662300010013 SCHOOL 13 public Regular School No Elementary PK 08 2017   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
1030586 NY Westchester   school 3631920 662300010000   YONKERS 363192004259 662300010014 ROSMARIE ANN SIRAGUSA SCHOOL public Regular School No Elementary PK 06 2017   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
1030605 NY Westchester   school 3631920 662300010000   YONKERS 363192003452 662300010015 PAIDEIA SCHOOL 15 public Regular School No Elementary PK 08 2017   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
1030624 NY Westchester   school 3631920 662300010000   YONKERS 363192004260 662300010016 SCHOOL 16 public Regular School No Elementary PK 08 2017   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
1030643 NY Westchester   school 3631920 662300010000   YONKERS 363192004261 662300010017 SCHOOL 17 public Regular School No Elementary PK 06 2017   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
1030662 NY Westchester   school 3631920 662300010000   YONKERS 363192004262 662300010018 SCHOLASTIC ACAD FOR ACAD EXCELLENCE public Regular School No Elementary PK 08 2017   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
1030681 NY Westchester   school 3631920 662300010000   YONKERS 363192004263 662300010019 EUGENIO MARIA DE HOSTOS MICROSOCIETY public Regular School No Elementary PK 08 2017   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
1030700 NY Westchester   school 3631920 662300010000   YONKERS 363192004264 662300010021 SCHOOL 21 public Regular School No Elementary PK 06 2017   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
1030719 NY Westchester   school 3631920 662300010000   YONKERS 363192004265 662300010022 SCHOOL 22 public Regular School No Elementary PK 06 2017   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
1030738 NY Westchester   school 3631920 662300010000   YONKERS 363192004266 662300010023 SCHOOL 23 public Regular School No Elementary PK 08 2017   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
1030757 NY Westchester   school 3631920 662300010000   YONKERS 363192002802 662300010024 PAIDEIA SCHOOL 24 public Regular School No Elementary PK 06 2017   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
1030776 NY Westchester   school 3631920 662300010000   YONKERS 363192004267 662300010025 MUSEUM SCHOOL 25 public Regular School No Elementary PK 06 2017   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
1030795 NY Westchester   school 3631920 662300010000   YONKERS 363192004268 662300010026 CASIMIR PULASKI SCHOOL public Regular School No Elementary PK 08 2017   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
1030814 NY Westchester   school 3631920 662300010000   YONKERS 363192004269 662300010027 MONTESSORI SCHOOL 27 public Regular School No Elementary PK 06 2017   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
1030833 NY Westchester   school 3631920 662300010000   YONKERS 363192004270 662300010028 KAHLIL GIBRAN SCHOOL public Regular School No Elementary PK 08 2017   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
1030852 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No Elementary PK 08 2017   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
1030871 NY Westchester   school 3631920 662300010000   YONKERS 363192004272 662300010030 SCHOOL 30 public Regular School No Elementary PK 08 2017   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
1030890 NY Westchester   school 3631920 662300010000   YONKERS 363192004242 662300010033 ENRICO FERMI SCHOOL-PERF ARTS public Regular School No Elementary PK 08 2017   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
1030909 NY Westchester   school 3631920 662300010000   YONKERS 363192004249 662300010036 CROSS HILL ACADEMY public Regular School No Elementary PK 08 2017   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
1030928 NY Westchester   school 3631920 662300010000   YONKERS 363192004243 662300010037 GORTON HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 13.0 82.0 156.0         5.0     1.0   126.0 131.0     46       247     50   257 13 82 156         5     1   126 131     46   247   50   257
1030947 NY Westchester   school 3631920 662300010000   YONKERS 363192004245 662300010038 LINCOLN HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 30.0 49.0 202.0   0.0     9.0     2.0   133.0 159.0     34       264     60   292 30 49 202   0     9     2   133 159     34   264   60   292
1030966 NY Westchester   school 3631920 662300010000   YONKERS 363192004251 662300010040 SAUNDERS TRADES & TECH SR HIGH SCH public Regular School No High 09 12 2017   grade_9 62.0 41.0 160.0   0.0     10.0     9.0   157.0 125.0     10       226     46   282 62 41 160   0     10     9   157 125     10   226   46   282
1030985 NY Westchester   school 3631920 662300010000   YONKERS 363192004250 662300010043 ROOSEVELT HIGH SCHOOL - EARLY COLLEG public Regular School No High 09 12 2017   grade_9 23.0 58.0 151.0   1.0     6.0     2.0   134.0 107.0     66       194     35   241 23 58 151   1     6     2   134 107     66   194   35   241
1031004 NY Westchester   school 3631920 662300010000   YONKERS 363192004247 662300010044 YONKERS MONTESSORI ACADEMY public Regular School No Other PK 12 2017   grade_9 29.0 16.0 43.0   0.0     4.0     0.0   47.0 45.0     *       67     21   92 29 16 43   0     4     0   47 45         67   21   92
1031023 NY Westchester   school 3631920 662300010000   YONKERS 363192004853 662300010045 CEDAR PLACE ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2017   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
1031042 NY Westchester   school 3631920 662300010000   YONKERS 363192004248 662300010046 MLK JR HIGH TECH & COMPUTER MAGNE public Regular School No Elementary PK 08 2017   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
1031061 NY Westchester   school 3631920 662300010000   YONKERS 363192004539 662300010047 PEARLS HAWTHORNE SCHOOL public Regular School No Elementary PK 08 2017   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
1031080 NY Westchester   school 3631920 662300010000   YONKERS 363192004574 662300010048 YONKERS HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 61.0 36.0 127.0   0.0     46.0     6.0   90.0 186.0     26       *     *   276 61 36 127   0     46     6   90 186     26           276
1031099 NY Westchester   school 3631920 662300010000   YONKERS 363192000448 662300010050 RIVERSIDE HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 11.0 66.0 168.0   0.0     12.0     2.0   155.0 104.0     34       242     59   259 11 66 168   0     12     2   155 104     34   242   59   259
1031118 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No Middle 07 08 2017   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
1031137 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2017   grade_9 7.0 45.0 57.0   0.0     7.0     2.0   59.0 59.0     13       108     14   118 7 45 57   0     7     2   59 59     13   108   14   118
1031156 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No Elementary PK 06 2017   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
1031175 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 01 2017   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
1031574 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2017   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
1009990 NY Rensselaer   school 3631830 490804020000   WYNANTSKILL 363183004238 490804020002 GARDNER-DICKINSON SCHOOL public Regular School No Elementary KG 08 2017   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
1017400 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004234 580109020001 MARTIN LUTHER KING ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2017   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
1017419 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004237 580109020003 WYANDANCH MEMORIAL HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 0.0 83.0 84.0         0.0     0.0   89.0 78.0     56       138     37   167 0 83 84         0     0   89 78     56   138   37   167
1017438 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004235 580109020004 MILTON L OLIVE MIDDLE SCHOOL public Regular School No Middle 05 08 2017   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
1017457 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 01 2017   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
1002447 NY Otsego   school 3631740 472506040000   WORCESTER 363174004232 472506040001 WORCESTER SCHOOL public Regular School No Other PK 12 2017   grade_9 24.0 0.0 0.0               0.0   14.0 10.0             10     6   24 24 0 0               0   14 10         10   6   24
952743 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
952762 NY Broome   school 3602730 31701060000   WINDSOR 360273000047 31701060003 C R WEEKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
952781 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2017   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
952800 NY Broome   school 3602730 31701060000   WINDSOR 360273004430 31701060007 WINDSOR CENTRAL HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 117.0 2.0 3.0         1.0     0.0   59.0 64.0             52     16   123 117 2 3         1     0   59 64         52   16   123
964295 NY Greene   school 3631590 191401040000   WINDHAM ASHLAND 363159004225 191401040001 WINDHAM ASHLAND CENTRAL SCHOOL public Regular School No Other KG 12 2017   grade_9 19.0 0.0 1.0         0.0     0.0   13.0 7.0     0       *     *   20 19 0 1         0     0   13 7     0           20
995341 NY Niagara   school 3631560 401501060000   WILSON 363156004221 401501060002 WILSON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
995360 NY Niagara   school 3631560 401501060000   WILSON 363156004223 401501060003 WILSON HIGH SCHOOL public Regular School No Other 06 12 2017   grade_9 96.0 0.0 3.0   0.0     0.0     7.0   57.0 49.0     *       40     11   106 96 0 3   0     0     7   57 49         40   11   106
962832 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_9 19.0 0.0 0.0   1.0           1.0   8.0 13.0             15     9   21 19 0 0   1           1   8 13         15   9   21
958747 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004216 140203060001 MILL MIDDLE SCHOOL public Regular School No Middle 05 8 2017   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
958766 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004210 140203060002 DODGE ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   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
958785 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004214 140203060003 MAPLE EAST ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   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
958804 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004219 140203060004 WILLIAMSVILLE SOUTH HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 186.0 12.0 13.0   1.0     14.0     4.0   111.0 119.0     *       *     37   230 186 12 13   1     14     4   111 119             37   230
958823 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004212 140203060005 HEIM ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   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
958842 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004211 140203060007 FOREST ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   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
958861 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004215 140203060008 MAPLE WEST ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   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
958880 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004213 140203060009 HEIM MIDDLE SCHOOL public Regular School No Middle 05 8 2017   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
958899 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004218 140203060010 WILLIAMSVILLE NORTH HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 270.0 13.0 7.0   1.0     27.0     10.0   171.0 157.0     *       40     44   328 270 13 7   1     27     10   171 157         40   44   328
958918 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004209 140203060011 COUNTRY PARKWAY ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   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
958937 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004756 140203060012 CASEY MIDDLE SCHOOL public Regular School No Middle 05 8 2017   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
958956 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004217 140203060013 WILLIAMSVILLE EAST HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 183.0 4.0 8.0   1.0     47.0     11.0   121.0 133.0     *       30     *   254 183 4 8   1     47     11   121 133         30       254
958975 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147000457 140203060015 TRANSIT MIDDLE SCHOOL public Regular School No Middle 05 8 2017   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
1026501 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004204 651402040001 WILLIAMSON MIDDLE SCHOOL public Regular School No Middle 05 08 2017   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
1026520 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004206 651402040002 WILLIAMSON SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 60.0 4.0 9.0         1.0     1.0   38.0 37.0     *       40     16   75 60 4 9         1     1   38 37         40   16   75
1026539 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004205 651402040003 WILLIAMSON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
967373 NY Kings   school 3600145 331400860885   WILLIAMSBURG COLLEGIATE CHRT 360014505814 331400860885 WILLIAMSBURG COLLEGIATE CHRTR SCH charter Regular School Yes Middle 05 8 2017   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
967354 NY Kings   school 3600115 331400860865   WILLIAMSBURG CHARTER HIGH SCH 360011505705 331400860865 WILLIAMSBURG CHARTER HIGH SCHOOL charter Regular School Yes High 09 12 2017   grade_9 2.0 74.0 162.0   0.0     2.0     7.0   127.0 120.0     17       213     48   247 2 74 162   0     2     7   127 120     17   213   48   247
1018901 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004672 580232030002 WILLIAM FLOYD HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 336.0 102.0 161.0   3.0     25.0     8.0   307.0 328.0     25       355     72   635 336 102 161   3     25     8   307 328     25   355   72   635
1018920 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004673 580232030004 WILLIAM FLOYD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
1018939 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004674 580232030005 TANGIER SMITH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
1018958 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004675 580232030006 MORICHES ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
1018977 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004677 580232030008 JOHN S HOBART ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
1018996 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005579 580232030010 WILLIAM FLOYD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
1019015 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005743 580232030011 NATHANIEL WOODHULL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
1019034 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005744 580232030012 WILLIAM PACA MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
952344 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Elementary 04 08 2017   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
952363 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 77.0 1.0 2.0         0.0     2.0   46.0 36.0     *       49     *   82 77 1 2         0     2   46 36         49       82
952382 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY SCHOOL public Regular School No Elementary PK 03 2017   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
943547 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_9 14.0   0.0                   4.0 10.0             7     *   14 14   0                   4 10         7       14
996614 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004193 412902060002 MARCY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
996633 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004192 412902060003 HARTS HILL SCHOOL public Regular School No Elementary KG 05 2017   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
996652 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004191 412902060005 DEERFIELD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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

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