Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2017 sorted by low_income_int

View and edit SQL

year

  • 2017 · 89,718
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
942104 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   kindergarten_full_day 38.0 9.0 7.0   1.0     7.0     5.0   26.0 41.0     5       *     8   67 38 9 7   1     7     5   26 41     5       8   67
942109 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 2.0 2.0 0.0   0.0     1.0     1.0   2.0 4.0     0       *     6   6 2 2 0   0     1     1   2 4     0       6   6
942289 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2017   grade_5 9.0 32.0 7.0   0.0     2.0     1.0   24.0 27.0     8       *     0   51 9 32 7   0     2     1   24 27     8       0   51
942299 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     1.0   0.0 1.0     0       *     *   1 0 0 0   0     0     1   0 1     0           1
942318 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 2.0 0.0   0.0     1.0     0.0   2.0 1.0     *       *     *   3 0 2 0   0     1     0   2 1                 3
942319 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_secondary 0.0 6.0 1.0   0.0     1.0     0.0   7.0 1.0     *       *     *   8 0 6 1   0     1     0   7 1                 8
942475 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_12 59.0 1.0 1.0   0.0     0.0         36.0 25.0             *     8   61 59 1 1   0     0         36 25             8   61
942490 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   ungraded_secondary 3.0 0.0 0.0   0.0     0.0         1.0 2.0             *     *   3 3 0 0   0     0         1 2                 3
942510 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 30.0 2.0 3.0         1.0     1.0   21.0 16.0             *     *   37 30 2 3         1     1   21 16                 37
942514 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 41.0 1.0 0.0         1.0     5.0   28.0 20.0             *     10   48 41 1 0         1     5   28 20             10   48
942548 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 52.0 0.0 2.0         4.0     2.0   36.0 24.0             *     11   60 52 0 2         4     2   36 24             11   60
942554 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 50.0 1.0 0.0         1.0     0.0   23.0 29.0             *     8   52 50 1 0         1     0   23 29             8   52
942565 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0 1.0 0.0         0.0     0.0   1.0 0.0             *     *   1 0 1 0         0     0   1 0                 1
942603 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 3.0 1.0 0.0         1.0     0.0   5.0 0.0     0       *     *   5 3 1 0         1     0   5 0     0           5
942604 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_secondary 4.0 0.0 0.0         0.0     0.0   3.0 1.0     0       *     *   4 4 0 0         0     0   3 1     0           4
942646 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   grade_12 116.0 6.0 4.0         2.0     1.0   70.0 59.0     *       *     16   129 116 6 4         2     1   70 59             16   129
942661 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   ungraded_secondary 2.0 0.0 1.0         0.0     0.0   3.0 0.0     *       *     *   3 2 0 1         0     0   3 0                 3
942738 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2017   grade_1 15.0 0.0 1.0         0.0     2.0   9.0 9.0             *     *   18 15 0 1         0     2   9 9                 18
942755 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 3.0 0.0 0.0         0.0     1.0   2.0 2.0             *     *   4 3 0 0         0     1   2 2                 4
942793 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 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
942794 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_secondary 7.0 0.0 0.0   0.0     0.0     0.0   4.0 3.0     0       *     *   7 7 0 0   0     0     0   4 3     0           7
942902 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   kindergarten_full_day 45.0 6.0 2.0         6.0     6.0   34.0 31.0             *     17   65 45 6 2         6     6   34 31             17   65
942907 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   ungraded_elementary 2.0 0.0 1.0         0.0     0.0   0.0 3.0             *     *   3 2 0 1         0     0   0 3                 3
942971 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_3 8.0 2.0 0.0   0.0     10.0     3.0   9.0 14.0     5       *     *   23 8 2 0   0     10     3   9 14     5           23
942972 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_4 8.0 4.0 2.0   1.0     15.0     1.0   16.0 15.0     *       *     *   31 8 4 2   1     15     1   16 15                 31
943008 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   grade_2 50.0 4.0 4.0   0.0     16.0     2.0   42.0 34.0     *       *     *   76 50 4 4   0     16     2   42 34                 76
943016 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   kindergarten_full_day 38.0 1.0 4.0   0.0     15.0     1.0   32.0 27.0     *       *     6   59 38 1 4   0     15     1   32 27             6   59
943061 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   grade_1 32.0 0.0 2.0   0.0     3.0     3.0   12.0 28.0     *       *     *   40 32 0 2   0     3     3   12 28                 40
943066 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   grade_3 41.0 0.0 2.0   0.0     3.0     1.0   26.0 21.0     *       *     *   47 41 0 2   0     3     1   26 21                 47
943067 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   grade_4 36.0 2.0 4.0   2.0     6.0     3.0   26.0 27.0     0       *     5   53 36 2 4   2     6     3   26 27     0       5   53
943073 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   kindergarten_full_day 31.0 0.0 7.0   0.0     2.0     1.0   16.0 25.0     *       *     *   41 31 0 7   0     2     1   16 25                 41
943085 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_3 25.0 3.0 1.0   1.0     10.0     3.0   22.0 21.0     *       *     *   43 25 3 1   1     10     3   22 21                 43
943098 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   ungraded_secondary 5.0 0.0 0.0   0.0     0.0     0.0   4.0 1.0     0       *     *   5 5 0 0   0     0     0   4 1     0           5
943268 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 11.0 0.0 1.0   0.0     1.0     0.0   8.0 5.0     0       *     *   13 11 0 1   0     1     0   8 5     0           13
943269 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_secondary 2.0 0.0 0.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 2 0 0   0     0     0   2 0     0           2
943276 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 38.0 0.0 1.0         2.0     3.0   27.0 17.0     0       *     5   44 38 0 1         2     3   27 17     0       5   44
943282 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   kindergarten_full_day 57.0 1.0 1.0         14.0     1.0   43.0 31.0     5       *     *   74 57 1 1         14     1   43 31     5           74
943311 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2017   grade_12 89.0 1.0 2.0   0.0     4.0     0.0   52.0 44.0     *       *     12   96 89 1 2   0     4     0   52 44             12   96
943319 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 88.0 2.0 0.0   0.0     4.0     1.0   42.0 53.0     *       *     13   95 88 2 0   0     4     1   42 53             13   95
943352 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4 33.0 17.0 10.0         7.0     12.0   46.0 33.0     5       *     10   79 33 17 10         7     12   46 33     5       10   79
943363 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   ungraded_elementary 1.0 0.0 0.0         1.0     0.0   2.0 0.0     *       *     *   2 1 0 0         1     0   2 0                 2
943367 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_11 47.0 14.0 6.0   1.0     10.0     5.0   40.0 43.0     7       *     11   83 47 14 6   1     10     5   40 43     7       11   83
943383 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   ungraded_secondary 2.0 1.0 0.0   0.0     0.0     1.0   2.0 2.0     0       *     *   4 2 1 0   0     0     1   2 2     0           4
943399 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 14.0 1.0 2.0         0.0     1.0   12.0 6.0             *     *   18 14 1 2         0     1   12 6                 18
943401 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   ungraded_elementary 1.0 0.0 0.0         0.0     0.0   0.0 1.0             *     *   1 1 0 0         0     0   0 1                 1
943438 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_half_day 21.0 0.0           0.0         11.0 10.0             *     *   21 21 0           0         11 10                 21
943439 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 2.0 0.0           0.0         1.0 1.0             *     *   2 2 0           0         1 1                 2
943461 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_10 20.0   0.0               0.0   15.0 5.0             *     *   20 20   0               0   15 5                 20
943478 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 1.0   0.0               0.0   0.0 1.0             *     *   1 1   0               0   0 1                 1
943482 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_12 10.0 0.0 0.0         0.0         1.0 9.0             *     0   10 10 0 0         0         1 9             0   10
943496 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 4.0 0.0 0.0         0.0         2.0 2.0             *     *   4 4 0 0         0         2 2                 4
943514 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_half_day 17.0 0.0 0.0               1.0   14.0 4.0             *     *   18 17 0 0               1   14 4                 18
943516 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 1.0 0.0 0.0               0.0   1.0 0.0             *     *   1 1 0 0               0   1 0                 1
943534 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 3.0 0.0 0.0   0.0     0.0         2.0 1.0             *     *   3 3 0 0   0     0         2 1                 3
943535 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 4.0 0.0 0.0   0.0     0.0         4.0 0.0             *     *   4 4 0 0   0     0         4 0                 4
943553 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 1.0   0.0                   0.0 1.0             *     *   1 1   0                   0 1                 1
943554 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 4.0   0.0                   2.0 2.0             *     *   4 4   0                   2 2                 4
943615 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_12 17.0 1.0 0.0   1.0     1.0     0.0   7.0 13.0             *     *   20 17 1 0   1     1     0   7 13                 20
943629 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 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
943665 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 53.0 1.0 0.0   0.0     0.0     0.0   32.0 22.0     *       *     *   54 53 1 0   0     0     0   32 22                 54
943667 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 2.0 1.0 0.0   0.0     0.0     0.0   3.0 0.0     *       *     *   3 2 1 0   0     0     0   3 0                 3
943670 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No Other 06 12 2017   grade_10 48.0 0.0 2.0   0.0     0.0     1.0   25.0 26.0             *     6   51 48 0 2   0     0     1   25 26             6   51
943687 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No Other 06 12 2017   ungraded_secondary 3.0 0.0 0.0   0.0     0.0     0.0   2.0 1.0             *     *   3 3 0 0   0     0     0   2 1                 3
943722 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402043 320700010001 PS 1 COURTLANDT SCHOOL public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 2.0 9.0 23.0   0.0     0.0     0.0   20.0 14.0     0       *     *   34 2 9 23   0     0     0   20 14     0           34
943724 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402043 320700010001 PS 1 COURTLANDT SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   2.0 1.0     0       *     *   3 0 1 2   0     0     0   2 1     0           3
943743 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402056 320700010005 PS 5 PORT MORRIS public Regular School No Elementary PK 08 2017   ungraded_elementary 0.0 3.0 1.0   0.0     0.0     0.0   3.0 1.0     *       *     *   4 0 3 1   0     0     0   3 1                 4
943744 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402056 320700010005 PS 5 PORT MORRIS public Regular School No Elementary PK 08 2017   ungraded_secondary 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
943760 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 4.0 10.0 19.0   0.0     0.0     1.0   18.0 16.0     0       *     *   34 4 10 19   0     0     1   18 16     0           34
943762 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 0 1 2   0     0     0   2 1                 3
943779 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 0.0 3.0 26.0   0.0     0.0     0.0   11.0 18.0     0       *     *   29 0 3 26   0     0     0   11 18     0           29
943781 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 3.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 0 0 3   0     0     0   2 1                 3
943798 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 0.0 9.0 20.0   0.0     0.0     0.0   19.0 10.0     0       *     *   29 0 9 20   0     0     0   19 10     0           29
943800 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No Elementary PK 08 2017   ungraded_elementary 0.0 2.0 1.0   0.0     0.0     0.0   2.0 1.0     0       *     *   3 0 2 1   0     0     0   2 1     0           3
943801 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No Elementary PK 08 2017   ungraded_secondary 0.0 0.0 1.0   0.0     0.0     0.0   0.0 1.0     0       *     *   1 0 0 1   0     0     0   0 1     0           1
943817 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402143 320700010030 PS 30 WILTON public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 1.0 13.0 31.0   0.0     0.0     0.0   17.0 28.0     0       *     *   45 1 13 31   0     0     0   17 28     0           45
943819 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402143 320700010030 PS 30 WILTON public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 2.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 0 0 2   0     0     0   2 0     0           2
943836 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 2017   pre_kindergarten_full_day 2.0 16.0 33.0   1.0     1.0     0.0   29.0 24.0     0       *     *   53 2 16 33   1     1     0   29 24     0           53
943838 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 2017   ungraded_elementary 0.0 2.0 1.0   0.0     0.0     0.0   2.0 1.0     0       *     *   3 0 2 1   0     0     0   2 1     0           3
943839 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 2017   ungraded_secondary 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 0 1 0   0     0     0   1 0     0           1
943855 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 2.0 6.0 24.0   0.0     0.0         12.0 20.0     0       *     *   32 2 6 24   0     0         12 20     0           32
943857 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2017   ungraded_elementary 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
943893 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 0.0 15.0 20.0   0.0     1.0     0.0   16.0 20.0     0       *     *   36 0 15 20   0     1     0   16 20     0           36
943895 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 0 0 1   0     0     0   1 0     0           1
943905 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2017   grade_6 1.0 24.0 40.0                   35.0 30.0     16       *     *   65 1 24 40                   35 30     16           65
943914 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 1.0                   0.0 1.0     0       *     *   1 0 0 1                   0 1     0           1
943915 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2017   ungraded_secondary 0.0 1.0 0.0                   1.0 0.0     0       *     *   1 0 1 0                   1 0     0           1
943931 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 1.0 10.0 23.0   0.0     1.0     0.0   15.0 20.0     0       *     *   35 1 10 23   0     1     0   15 20     0           35
943933 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   3.0 0.0     *       *     *   3 0 1 2   0     0     0   3 0                 3
943969 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 1.0 8.0 39.0   0.0     1.0     0.0   23.0 26.0     0       *     *   49 1 8 39   0     1     0   23 26     0           49
943971 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 3.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 0 0 3   0     0     0   2 1                 3
943990 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008404460 320700010162 JHS 162 LOLA RODRIGUEZ DE TIO public Regular School No Middle 06 08 2017   ungraded_elementary   0.0 1.0   0.0               1.0 0.0     *       *     *   1   0 1   0               1 0                 1
943991 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008404460 320700010162 JHS 162 LOLA RODRIGUEZ DE TIO public Regular School No Middle 06 08 2017   ungraded_secondary   1.0 4.0   0.0               2.0 3.0     *       *     *   5   1 4   0               2 3                 5
944007 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 0.0 5.0 31.0   0.0     0.0     0.0   16.0 20.0     0       *     *   36 0 5 31   0     0     0   16 20     0           36
944009 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2017   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 0 0 1   0     0     0   1 0     0           1
944014 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 MS 223 LAB SCHOOL OF FIN & TECH public Regular School No Other 06 12 2017   grade_12 0.0 20.0 70.0   0.0     0.0     0.0   51.0 39.0     *       *     20   90 0 20 70   0     0     0   51 39             20   90
944028 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 MS 223 LAB SCHOOL OF FIN & TECH public Regular School No Other 06 12 2017   ungraded_elementary 0.0 0.0 2.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 0 0 2   0     0     0   2 0     0           2
944039 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2017   grade_7 1.0 34.0 89.0   1.0     0.0         77.0 48.0     27       *     *   125 1 34 89   1     0         77 48     27           125
944048 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2017   ungraded_secondary 0.0 1.0 2.0   0.0     0.0         1.0 2.0     0       *     *   3 0 1 2   0     0         1 2     0           3
944077 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2017   grade_7 2.0 27.0 57.0   2.0     0.0         49.0 39.0     7       *     29   88 2 27 57   2     0         49 39     7       29   88
944086 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2017   ungraded_secondary 0.0 1.0 0.0   0.0     0.0         1.0 0.0     0       *     *   1 0 1 0   0     0         1 0     0           1

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