Data source: Big Local News · About: Big Local

90,079 rows where state = "NY" and year = 2021 sorted by low_income_int

View and edit SQL

year

  • 2021 · 90,079
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
1433007 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 26.0 20.0 7.0   0.0     10.0     6.0   41.0 28.0     *       *     *   69 26 20 7   0     10     6   41 28                 69
1433012 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 0.0 2.0 0.0   0.0     0.0     0.0   1.0 1.0     0       *     *   2 0 2 0   0     0     0   1 1     0           2
1433031 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2021   ungraded_elementary 1.0 10.0 3.0   0.0     1.0     2.0   9.0 8.0     *       *     17   17 1 10 3   0     1     2   9 8             17   17
1433032 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2021   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
1433140 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 2.0 24.0 8.0         3.0     2.0   19.0 20.0     *       *     *   39 2 24 8         3     2   19 20                 39
1433145 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 0.0 1.0 0.0         1.0     0.0   2.0 0.0     0       *     *   2 0 1 0         1     0   2 0     0           2
1433212 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2021   grade_6 1.0 1.0 2.0   0.0     0.0     0.0   4.0 0.0     *       *     *   4 1 1 2   0     0     0   4 0                 4
1433221 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2021   ungraded_elementary 0.0 6.0 0.0   0.0     0.0     0.0   4.0 2.0     *       *     6   6 0 6 0   0     0     0   4 2             6   6
1433377 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2021   grade_11 44.0 0.0 1.0   0.0     1.0     1.0   23.0 24.0             *     *   47 44 0 1   0     1     1   23 24                 47
1433393 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2021   ungraded_secondary 2.0 0.0 0.0   0.0     0.0     0.0   2.0 0.0             *     *   2 2 0 0   0     0     0   2 0                 2
1433394 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2021   grade_1 39.0 0.0 1.0         0.0     3.0   20.0 23.0     *       *     7   43 39 0 1         0     3   20 23             7   43
1433409 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2021   pre_kindergarten_full_day 22.0 0.0 2.0         0.0     2.0   17.0 9.0     *       *     *   26 22 0 2         0     2   17 9                 26
1433417 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_2 33.0 2.0 2.0         0.0     1.0   19.0 19.0             *     5   38 33 2 2         0     1   19 19             5   38
1433425 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   kindergarten_full_day 32.0 0.0 1.0         1.0     3.0   22.0 15.0             *     11   37 32 0 1         1     3   22 15             11   37
1433437 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_3 49.0 1.0 1.0   0.0     5.0     4.0   25.0 35.0     0       *     12   60 49 1 1   0     5     4   25 35     0       12   60
1433449 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   ungraded_elementary 0.0 0.0 0.0   0.0     1.0     1.0   1.0 1.0     0       *     *   2 0 0 0   0     1     1   1 1     0           2
1433455 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_2 41.0 2.0 1.0         2.0     11.0   35.0 22.0     *       *     17   57 41 2 1         2     11   35 22             17   57
1433457 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_4 26.0 0.0 0.0         4.0     5.0   20.0 15.0     *       *     *   35 26 0 0         4     5   20 15                 35
1433463 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   kindergarten_full_day 50.0 0.0 3.0         2.0     4.0   36.0 23.0     *       *     *   59 50 0 3         2     4   36 23                 59
1433468 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   ungraded_elementary 0.0 0.0 0.0         0.0     1.0   1.0 0.0     *       *     *   1 0 0 0         0     1   1 0                 1
1433475 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_3 55.0 2.0 2.0         6.0     6.0   37.0 34.0     *       *     *   71 55 2 2         6     6   37 34                 71
1433482 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   kindergarten_full_day 49.0 2.0 2.0         2.0     6.0   26.0 35.0     *       *     *   61 49 2 2         2     6   26 35                 61
1433499 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 278.0 11.0 5.0         30.0     8.0   165.0 167.0     5       *     39   332 278 11 5         30     8   165 167     5       39   332
1433506 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_elementary 1.0 0.0 0.0         0.0     0.0   1.0 0.0     0       *     *   1 1 0 0         0     0   1 0     0           1
1433507 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1433571 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2021   grade_4 44.0 0.0 5.0         1.0     2.0   25.0 27.0             *     9   52 44 0 5         1     2   25 27             9   52
1433581 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_half_day 27.0 0.0 2.0         0.0     2.0   17.0 14.0             *     *   31 27 0 2         0     2   17 14                 31
1433611 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 05 08 2021   grade_6 90.0 4.0 13.0         2.0     13.0   61.0 61.0     *       *     *   122 90 4 13         2     13   61 61                 122
1433620 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 05 08 2021   ungraded_elementary 1.0 0.0 0.0         0.0     0.0   1.0 0.0     *       *     *   1 1 0 0         0     0   1 0                 1
1433646 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary PK 05 2021   grade_3 10.0 2.0 1.0         1.0     2.0   10.0 6.0     *       *     6   16 10 2 1         1     2   10 6             6   16
1433658 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 1.0 0.0 0.0         0.0     1.0   2.0 0.0     *       *     *   2 1 0 0         0     1   2 0                 2
1433696 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_elementary 0.0 1.0 1.0   0.0     0.0     0.0   1.0 1.0     0       *     *   2 0 1 1   0     0     0   1 1     0           2
1433697 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_secondary 2.0 0.0 1.0   0.0     0.0     1.0   3.0 1.0     0       *     *   4 2 0 1   0     0     1   3 1     0           4
1433729 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2021   kindergarten_full_day 30.0 11.0 6.0         6.0     6.0   33.0 26.0     *       *     13   59 30 11 6         6     6   33 26             13   59
1433733 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2021   pre_kindergarten_half_day 27.0 4.0 6.0         6.0     2.0   22.0 23.0     *       *     *   45 27 4 6         6     2   22 23                 45
1433748 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   kindergarten_full_day 51.0 3.0 5.0         5.0     3.0   27.0 40.0     *       *     11   67 51 3 5         5     3   27 40             11   67
1433752 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   pre_kindergarten_half_day 42.0 2.0 2.0         7.0     4.0   27.0 30.0     0       *     *   57 42 2 2         7     4   27 30     0           57
1433753 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   ungraded_elementary 2.0 0.0 0.0         0.0     0.0   2.0 0.0     0       *     *   2 2 0 0         0     0   2 0     0           2
1433805 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   kindergarten_full_day 33.0 8.0 5.0         7.0     2.0   26.0 29.0     6       *     10   55 33 8 5         7     2   26 29     6       10   55
1433810 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   ungraded_elementary 2.0 1.0 1.0         0.0     0.0   4.0 0.0     0       *     *   4 2 1 1         0     0   4 0     0           4
1433848 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2021   ungraded_elementary 6.0 0.0 4.0         5.0     0.0   7.0 8.0     0       *     15   15 6 0 4         5     0   7 8     0       15   15
1433849 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2021   ungraded_secondary 3.0 0.0 2.0         1.0     0.0   2.0 4.0     0       *     6   6 3 0 2         1     0   2 4     0       6   6
1433876 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2021   grade_5 3.0 8.0 1.0   0.0     5.0     2.0   11.0 8.0     *       *     *   19 3 8 1   0     5     2   11 8                 19
1433881 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2021   kindergarten_full_day 10.0 11.0 1.0   0.0     13.0     3.0   18.0 20.0     0       *     *   38 10 11 1   0     13     3   18 20     0           38
1433886 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2021   ungraded_elementary 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
1433964 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2021   grade_1 25.0 0.0 3.0   0.0     5.0     5.0   25.0 13.0     *       *     *   38 25 0 3   0     5     5   25 13                 38
1433970 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2021   grade_4 34.0 0.0 6.0   0.0     4.0     4.0   19.0 29.0     *       *     *   48 34 0 6   0     4     4   19 29                 48
1433971 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2021   grade_5 37.0 0.0 4.0   0.0     5.0     2.0   17.0 31.0     *       *     6   48 37 0 4   0     5     2   17 31             6   48
1434010 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2021   grade_6 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 1 0 0   0     0     0   1 0     0           1
1434020 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2021   ungraded_secondary 2.0 1.0 0.0   0.0     1.0     0.0   3.0 1.0     0       *     *   4 2 1 0   0     1     0   3 1     0           4
1434109 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   kindergarten_full_day 42.0 7.0 10.0   1.0     21.0     3.0   42.0 42.0     18       *     6   84 42 7 10   1     21     3   42 42     18       6   84
1434114 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   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
1434135 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_1 51.0 0.0 5.0   1.0     13.0     0.0   31.0 39.0     8       *     *   70 51 0 5   1     13     0   31 39     8           70
1434147 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   kindergarten_full_day 54.0 1.0 4.0   0.0     3.0     3.0   35.0 30.0     *       *     10   65 54 1 4   0     3     3   35 30             10   65
1434171 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_elementary 2.0 1.0 0.0   1.0     0.0     0.0   3.0 1.0     0       *     *   4 2 1 0   1     0     0   3 1     0           4
1434172 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_secondary 10.0 0.0 0.0   0.0     2.0     1.0   8.0 5.0     0       *     *   13 10 0 0   0     2     1   8 5     0           13
1434179 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_4 65.0 2.0 2.0   0.0     16.0     1.0   49.0 37.0     *       *     7   86 65 2 2   0     16     1   49 37             7   86
1434185 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   kindergarten_full_day 61.0 1.0 5.0   1.0     8.0     4.0   36.0 44.0     6       *     8   80 61 1 5   1     8     4   36 44     6       8   80
1434196 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_2 78.0 1.0 5.0         3.0     5.0   50.0 42.0     *       *     7   92 78 1 5         3     5   50 42             7   92
1434209 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   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
1434293 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_4 32.0 0.0 1.0         0.0     0.0   15.0 18.0             *     10   33 32 0 1         0     0   15 18             10   33
1434302 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pre_kindergarten_full_day 15.0 0.0 1.0         1.0     0.0   7.0 10.0             *     *   17 15 0 1         1     0   7 10                 17
1434307 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2021   grade_10 39.0   2.0         2.0     2.0   27.0 18.0             *     5   45 39   2         2     2   27 18             5   45
1434324 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2021   ungraded_secondary 2.0   0.0         1.0     0.0   0.0 3.0             *     *   3 2   0         1     0   0 3                 3
1434328 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2021   grade_12 18.0 0.0 0.0         0.0     0.0   8.0 10.0             *     *   18 18 0 0         0     0   8 10                 18
1434341 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2021   pre_kindergarten_half_day 6.0 0.0 0.0         0.0     1.0   7.0 0.0             *     0   7 6 0 0         0     1   7 0             0   7
1434343 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2021   ungraded_secondary 2.0 0.0 0.0         0.0     0.0   2.0 0.0             *     *   2 2 0 0         0     0   2 0                 2
1434382 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2021   grade_1 11.0   1.0         0.0         6.0 6.0             *     0   12 11   1         0         6 6             0   12
1434383 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2021   grade_10 8.0   0.0         0.0         6.0 2.0             *     *   8 8   0         0         6 2                 8
1434386 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2021   grade_2 12.0   1.0         0.0         7.0 6.0             *     *   13 12   1         0         7 6                 13
1434387 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2021   grade_3 10.0   1.0         0.0         6.0 5.0             *     *   11 10   1         0         6 5                 11
1434388 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2021   grade_4 8.0   0.0         0.0         5.0 3.0             *     *   8 8   0         0         5 3                 8
1434391 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2021   grade_7 11.0   0.0         0.0         6.0 5.0             *     0   11 11   0         0         6 5             0   11
1434400 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2021   ungraded_secondary 4.0   0.0         0.0         2.0 2.0             *     *   4 4   0         0         2 2                 4
1434403 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_11 14.0 0.0 0.0               0.0   7.0 7.0             *     *   14 14 0 0               0   7 7                 14
1434417 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2021   pre_kindergarten_half_day 6.0 0.0 0.0               1.0   2.0 5.0             *     *   7 6 0 0               1   2 5                 7
1434437 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2021   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 1 0 0   0     0     0   0 1                 1
1434438 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2021   ungraded_secondary 5.0 0.0 0.0   0.0     0.0     0.0   4.0 1.0     *       *     5   5 5 0 0   0     0     0   4 1             5   5
1434443 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_2 12.0   0.0                   7.0 5.0     *       *     0   12 12   0                   7 5             0   12
1434447 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 7.0   0.0                   3.0 4.0     *       *     0   7 7   0                   3 4             0   7
1434448 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_7 4.0   1.0                   3.0 2.0     *       *     0   5 4   1                   3 2             0   5
1434449 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_8 8.0   1.0                   5.0 4.0     *       *     0   9 8   1                   5 4             0   9
1434450 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_9 6.0   0.0                   3.0 3.0     *       *     0   6 6   0                   3 3             0   6
1434523 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2021   grade_6 13.0 0.0 0.0   0.0           0.0   6.0 7.0             *     *   13 13 0 0   0           0   6 7                 13
1434530 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2021   pre_kindergarten_full_day 16.0 0.0 0.0   0.0           1.0   7.0 10.0             *     *   17 16 0 0   0           1   7 10                 17
1434551 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2021   ungraded_elementary 3.0 1.0 0.0   0.0     0.0     0.0   2.0 2.0             *     *   4 3 1 0   0     0     0   2 2                 4
1434552 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2021   ungraded_secondary 11.0 0.0 0.0   0.0     0.0     0.0   7.0 4.0             *     11   11 11 0 0   0     0     0   7 4             11   11
1434568 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_full_day 53.0 0.0 1.0         0.0     0.0   26.0 28.0     *       *     *   54 53 0 1         0     0   26 28                 54
1434570 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 1.0 0.0 0.0         0.0     0.0   1.0 0.0     *       *     *   1 1 0 0         0     0   1 0                 1
1434603 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 48.0 1.0                 0.0   23.0 26.0             *     *   49 48 1                 0   23 26                 49
1434606 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_full_day 23.0 0.0                 1.0   8.0 16.0             *     *   24 23 0                 1   8 16                 24
1434701 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_full_day 0.0 5.0 40.0   0.0     0.0     0.0   16.0 29.0     0       *     *   45 0 5 40   0     0     0   16 29     0           45
1434703 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0     *       *     *   1 0 0 1   0     0     0   1 0                 1
1434796 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2021   pre_kindergarten_full_day 1.0 19.0 62.0   1.0     0.0     0.0   44.0 39.0     0       *     *   83 1 19 62   1     0     0   44 39     0           83
1434798 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2021   ungraded_elementary 1.0 0.0 1.0   0.0     0.0     0.0   2.0 0.0     0       *     *   2 1 0 1   0     0     0   2 0     0           2
1435106 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Career and Technical School No High 08 12 2021   grade_11 0.0 39.0 68.0   1.0     2.0     0.0   42.0 68.0     14       *     31   110 0 39 68   1     2     0   42 68     14       31   110
1435114 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Career and Technical School No High 08 12 2021   grade_8 0.0 0.0 1.0   0.0     0.0     0.0   0.0 1.0     0       *     0   1 0 0 1   0     0     0   0 1     0       0   1
1435411 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_12 0.0 29.0 31.0   0.0     1.0     0.0   37.0 24.0     0       *     9   61 0 29 31   0     1     0   37 24     0       9   61
1435425 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   ungraded_elementary 0.0 1.0 1.0   0.0     0.0     0.0   0.0 2.0     *       *     *   2 0 1 1   0     0     0   0 2                 2
1435439 NY Bronx   school 3600110 320700860852   BRONX CHARTER SCH-CHILDREN 360011005651 320700860852 BRONX CHARTER SCHOOL FOR CHILDREN charter Regular School Yes Elementary KG 06 2021   kindergarten_full_day 0.0 18.0 27.0   0.0     0.0     2.0   27.0 20.0     *       *     9   47 0 18 27   0     0     2   27 20             9   47

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