Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_8", state = "NY" and year = 2020 sorted by ell

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_8 · 4,742
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
1523426 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0               0     0   0 0 0 0   0     0     0   0           0   0   0
1523464 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_8 65.0 0.0 4.0   0.0     0.0     0.0   38.0 31.0             32     12   69 65 0 4   0     0     0   38 31         32   12   69
1523502 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1523654 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1523692 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2020   grade_8 116.0 6.0 13.0         3.0     10.0   80.0 68.0             77     28   148 116 6 13         3     10   80 68         77   28   148
1523711 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1523730 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1523939 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_8 104.0 13.0 17.0         16.0     10.0   84.0 76.0             47     28   160 104 13 17         16     10   84 76         47   28   160
1524129 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   grade_8 15.0 2.0 1.0               4.0   8.0 14.0             16     9   22 15 2 1               4   8 14         16   9   22
1524300 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1524319 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 58.0 1.0 3.0         1.0     3.0   30.0 36.0             8     7   66 58 1 3         1     3   30 36         8   7   66
1524376 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1524395 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_8 35.0   3.0         1.0     2.0   20.0 21.0             *     6   41 35   3         1     2   20 21             6   41
1524414 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2020   grade_8 18.0 1.0 0.0         1.0     0.0   7.0 13.0             11     5   20 18 1 0         1     0   7 13         11   5   20
1524433 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_8 29.0 0.0 0.0   1.0     0.0     0.0   13.0 17.0             14     *   30 29 0 0   1     0     0   13 17         14       30
1524471 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2020   grade_8 23.0   1.0                   5.0 19.0             9     *   24 23   1                   5 19         9       24
1524490 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_8 27.0 0.0 0.0               0.0   12.0 15.0             15     *   27 27 0 0               0   12 15         15       27
1524509 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_8 53.0 0.0 0.0   0.0     0.0     1.0   28.0 26.0             32     6   54 53 0 0   0     0     1   28 26         32   6   54
1524547 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1524566 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1524585 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 52.0 1.0 1.0         0.0     0.0   25.0 29.0             33     9   54 52 1 1         0     0   25 29         33   9   54
1524604 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_8 21.0 0.0 0.0   0.0           0.0   9.0 12.0             12     *   21 21 0 0   0           0   9 12         12       21
1524642 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1524661 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No High 06 12 2020   grade_8 70.0 0.0 1.0               0.0   40.0 31.0             46     8   71 70 0 1               0   40 31         46   8   71
1524680 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0       0.0           0.0   0.0 0.0             0     0   0 0       0           0   0 0         0   0   0
1524699 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_8 0.0                       0.0 0.0                       0 0                       0 0                 0
1530361 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705190 321000011696 HS AMER STUDIES AT LEHMAN COLL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533059 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 98.0 1.0 5.0               2.0   56.0 50.0             41     16   106 98 1 5               2   56 50         41   16   106
1533078 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000224 30200010002 CALVIN COOLIDGE SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533116 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000233 30200010008 THOMAS JEFFERSON SCHOOL public Regular School No Elementary KG 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533135 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000230 30200010011 MACARTHUR SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1533249 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000229 30200010022 HORACE MANN SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1533268 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001120 30501040001 W A OLMSTED ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1533287 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001119 30501040003 HARPURSVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_8 43.0 1.0 1.0   0.0     0.0     5.0   31.0 19.0             37     7   50 43 1 1   0     0     5   31 19         37   7   50
1533306 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533325 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838004570 30601060004 F P DONNELLY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1533477 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001631 31101060004 MAINE MEMORIAL SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533572 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY SCHOOL public Regular School No Elementary PK 03 2020   grade_8 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
1533610 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071004314 31501060002 GEORGE F JOHNSON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533629 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No High 08 12 2020   grade_8 12.0 2.0 1.0               4.0   11.0 8.0             18     *   19 12 2 1               4   11 8         18       19
1533686 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000853 31501060013 THOMAS J WATSON SR ELEM SCHOOL public Regular School No Elementary KG 05 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1533857 NY Broome   school 3629610 31601060000   VESTAL 362961003989 31601060026 TIOGA HILLS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1533952 NY Broome   school 3602730 31701060000   WINDSOR 360273000047 31701060003 C R WEEKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1534009 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_8 10.0   0.0   0.0           1.0   5.0 6.0             *     *   11 10   0   0           1   5 6                 11
1534028 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500053 40302060001 ALLEGANY-LIMESTONE MIDDLE-HIGH public Regular School No High 06 12 2020   grade_8 83.0 0.0 2.0         1.0     3.0   50.0 39.0             37     12   89 83 0 2         1     3   50 39         37   12   89
1534066 NY Cattaraugus   school 3610530 40901040000   ELLICOTTVILLE 361053005577 40901040001 ELLICOTTVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534085 NY Cattaraugus   school 3610530 40901040000   ELLICOTTVILLE 361053004318 40901040002 ELLICOTTVILLE MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_8 50.0   0.0   3.0     0.0     1.0   25.0 29.0             17     6   54 50   0   3     0     1   25 29         17   6   54
1534142 NY Cattaraugus   school 3614490 41401040000   HINSDALE 361449001203 41401040001 HINSDALE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_8 31.0 0.0 1.0   0.0     0.0     3.0   17.0 18.0             16     7   35 31 0 1   0     0     3   17 18         16   7   35
1534180 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404324 42302040003 CATTARAUGUS-LITTLE VALLEY HS public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534199 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404857 42302040004 CATTARAUGUS-LITTLE VALLEY MIDDLE SCH public Regular School No Middle 05 08 2020   grade_8 58.0 2.0 2.0   0.0           3.0   30.0 35.0             37     11   65 58 2 2   0           3   30 35         37   11   65
1534256 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003082 42400010013 OLEAN SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 116.0 6.0 4.0   3.0     4.0     9.0   74.0 68.0             84     33   142 116 6 4   3     4     9   74 68         84   33   142
1534294 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239001005 42801060001 GOWANDA ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_8 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1534313 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239004858 42801060005 GOWANDA MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_8 47.0 0.0 2.0   13.0     1.0     11.0   38.0 36.0             *     13   74 47 0 2   13     1     11   38 36             13   74
1534332 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239001007 42801060006 GOWANDA HIGH SCHOOL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1534351 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003297 42901040001 PORTVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1534370 NY Cattaraugus   school 3623640 42901040000   PORTVILLE 362364003298 42901040002 PORTVILLE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 87.0 0.0 1.0         0.0     6.0   44.0 50.0             45     10   94 87 0 1         0     6   44 50         45   10   94
1534389 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003321 43001040002 RANDOLPH SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 65.0 0.0 0.0   0.0     0.0     3.0   30.0 38.0             36     7   68 65 0 0   0     0     3   30 38         36   7   68
1534408 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1534427 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No Other KG 12 2020   grade_8 7.0 0.0 1.0   0.0     0.0     0.0   6.0 2.0             *     8   8 7 0 1   0     0     0   6 2             8   8
1534446 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2020   grade_8 3.0 1.0 1.0   1.0           3.0   7.0 2.0             *     9   9 3 1 1   1           3   7 2             9   9
1534465 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 48.0 1.0 5.0   51.0           3.0   56.0 52.0             61     13   108 48 1 5   51           3   56 52         61   13   108
1534503 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 04 07 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534522 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2020   grade_8         0.0           0.0   0.0               *         0         0           0   0                   0
1534541 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534560 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_8 173.0 0.0 4.0         1.0     1.0   84.0 95.0             97     38   179 173 0 4         1     1   84 95         97   38   179
1534617 NY Cayuga   school 3603480 50100010000   AUBURN 360348000102 50100010002 CASEY PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1534636 NY Cayuga   school 3603480 50100010000   AUBURN 360348000104 50100010004 GENESEE STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534655 NY Cayuga   school 3603480 50100010000   AUBURN 360348000105 50100010005 HERMAN AVENUE ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1534674 NY Cayuga   school 3603480 50100010000   AUBURN 360348000107 50100010007 OWASCO ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1534750 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004095 50301040002 WEEDSPORT JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 63.0   0.0   0.0     1.0     5.0   31.0 38.0             18     9   69 63   0   0     1     5   31 38         18   9   69
1534883 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1534902 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003272 51101040004 PORT BYRON SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 58.0 1.0 5.0               1.0   35.0 30.0             29     10   65 58 1 5               1   35 30         29   10   65
1535092 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000917 60301040004 FREWSBURG JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_8 59.0 0.0 2.0   0.0     0.0     1.0   31.0 31.0             28     12   62 59 0 2   0     0     1   31 31         28   12   62
1535130 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000451 60401040006 CASSADAGA VALLEY MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_8 55.0 0.0 1.0   0.0     0.0     2.0   39.0 19.0             38     7   58 55 0 1   0     0     2   39 19         38   7   58
1535149 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801936 60503040001 CHAUTAUQUA LAKE SECONDARY SCHOOL public Regular School No High 07 12 2020   grade_8 57.0 1.0 0.0   0.0           0.0   22.0 36.0             33     9   58 57 1 0   0           0   22 36         33   9   58
1535168 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801938 60503040002 CHAUTAUQUA LAKE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1535187 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
1535206 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003232 60601040003 PINE VALLEY CENTRAL JR-SR HIGH SCH public Regular School No High 07 12 2020   grade_8 39.0 1.0 1.0   1.0           0.0   26.0 16.0             27     12   42 39 1 1   1           0   26 16         27   12   42
1535225 NY Chautauqua   school 3607890 60701040000   CLYMER 360789000562 60701040003 CLYMER CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_8 29.0 0.0 0.0         0.0     2.0   20.0 11.0             18     *   31 29 0 0         0     2   20 11         18       31
1535358 NY Chautauqua   school 3604530 61001040000   BEMUS POINT 360453000199 61001040001 BEMUS POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1535377 NY Chautauqua   school 3604530 61001040000   BEMUS POINT 360453000201 61001040005 MAPLE GROVE JUNIOR/SENIOR HIGH public Regular School No High 06 12 2020   grade_8 50.0 0.0 1.0         0.0     0.0   34.0 17.0             16     8   51 50 0 1         0     0   34 17         16   8   51
1535396 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_8 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1535415 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000869 61101040007 FALCONER MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_8 105.0 4.0 2.0   0.0     0.0     0.0   48.0 63.0             52     17   111 105 4 2   0     0     0   48 63         52   17   111
1535434 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000872 61101040009 PAUL B D TEMPLE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1535510 NY Chautauqua   school 3611250 61503040000   FORESTVILLE 361125000890 61503040002 FORESTVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1535529 NY Chautauqua   school 3611250 61503040000   FORESTVILLE 361125000889 61503040003 FORESTVILLE CENTRAL HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 32.0 2.0 4.0   0.0     0.0     2.0   23.0 17.0             22     11   40 32 2 4   0     0     2   23 17         22   11   40
1535605 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001346 61700010003 CLINTON V BUSH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1535700 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001352 61700010011 ABRAHAM LINCOLN ELEM SCHOOL public Regular School No Elementary PK 04 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1535890 NY Chautauqua   school 3626730 62601040000   SHERMAN 362673004940 62601040002 SHERMAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1535947 NY Chautauqua   school 3630990 62901040000   WESTFIELD 363099004164 62901040002 WESTFIELD HIGH SCHOOL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1536042 NY Chemung   school 3610560 70600010000   ELMIRA 361056004387 70600010013 PARLEY COBURN SCHOOL public Regular School No Elementary 03 06 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1536080 NY Chemung   school 3610560 70600010000   ELMIRA 361056000823 70600010015 RIVERSIDE ELEMENTARY public Regular School No Elementary PK 02 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1536175 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2020   grade_8 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1536346 NY Chemung   school 3610590 70902060000   ELMIRA HEIGHTS 361059000830 70902060002 THOMAS A EDISON HIGH SCHOOL public Regular School No High 09 12 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1536365 NY Chemung   school 3610590 70902060000   ELMIRA HEIGHTS 361059002828 70902060004 COHEN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_8 64.0 2.0 3.0               6.0   33.0 42.0             39     12   75 64 2 3               6   33 42         39   12   75
1536384 NY Chemung   school 3610590 70902060000   ELMIRA HEIGHTS 361059000828 70902060006 COHEN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1536422 NY Chenango   school 3602400 80101040000   AFTON 360240000011 80101040003 AFTON JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 06 12 2020   grade_8 45.0 1.0 2.0         0.0     0.0   27.0 21.0             21     6   48 45 1 2         0     0   27 21         21   6   48
1536441 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000123 80201040001 BAINBRIDGE-GUILFORD HIGH SCHOOL public Regular School No High 07 12 2020   grade_8 49.0 0.0 3.0   1.0     3.0     3.0   30.0 29.0             34     7   59 49 0 3   1     3     3   30 29         34   7   59
1536460 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2020   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1536479 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000125 80201040003 GUILFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2020   grade_8 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]);