Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_8", state = "NY" and year = 2019 sorted by ell_int

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_8 · 4,719
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int ▼ homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2139483 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_8 0.0 62.0 3.0         0.0     0.0   33.0 32.0     *       58     *   65 0 62 3         0     0   33 32         58       65
2139654 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 299.0 9.0 8.0         22.0     2.0   153.0 187.0     *       55     50   340 299 9 8         22     2   153 187         55   50   340
2139749 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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
2139825 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   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
2139844 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 99.0 13.0 10.0   2.0     2.0     9.0   61.0 74.0     *       88     23   135 99 13 10   2     2     9   61 74         88   23   135
2139996 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 09 2019   grade_8 127.0 22.0 16.0   1.0     20.0     20.0   94.0 112.0     *       89     33   206 127 22 16   1     20     20   94 112         89   33   206
2140167 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_8 276.0 29.0 22.0   1.0     97.0     21.0   235.0 211.0     *       116     57   446 276 29 22   1     97     21   235 211         116   57   446
2140357 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   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
2140376 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   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
2140395 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 89.0 0.0 3.0         2.0     3.0   49.0 48.0     *       12     12   97 89 0 3         2     3   49 48         12   12   97
2140585 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_8 41.0 0.0 2.0   1.0     0.0         17.0 27.0     *       24     *   44 41 0 2   1     0         17 27         24       44
2140680 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_8 26.0 0.0 0.0   0.0           0.0   19.0 7.0     *       15     *   26 26 0 0   0           0   19 7         15       26
2140699 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2019   grade_8 82.0 4.0 2.0   0.0     1.0     2.0   45.0 46.0     *       42     12   91 82 4 2   0     1     2   45 46         42   12   91
2141402 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No High 06 12 2019   grade_8 0.0 16.0 53.0   0.0     1.0         33.0 37.0     *       57     17   70 0 16 53   0     1         33 37         57   17   70
2141706 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_8 0.0 15.0 24.0   0.0     0.0     0.0   21.0 18.0     *       38     7   39 0 15 24   0     0     0   21 18         38   7   39
2142200 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2019   grade_8 30.0 20.0 95.0   5.0     21.0     1.0   73.0 99.0     *       107     38   172 30 20 95   5     21     1   73 99         107   38   172
2142257 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502456 320800010123 JHS 123 JAMES M KIERNAN public Regular School No Middle 06 08 2019   grade_8 1.0 30.0 87.0   2.0     7.0     0.0   68.0 59.0     *       *     *   127 1 30 87   2     7     0   68 59                 127
2142637 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506302 320800010562 BLUEPRINT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 19.0 35.0 121.0   6.0     53.0         123.0 111.0     *       204     44   234 19 35 121   6     53         123 111         204   44   234
2142789 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505985 320800011367 ARCHIMEDES ACAD-MATH, SCI, TECH public Regular School No High 06 12 2019   grade_8 0.0 37.0 55.0   0.0     11.0     1.0   55.0 49.0     *       76     22   104 0 37 55   0     11     1   55 49         76   22   104
2143017 NY Bronx   school 3600112 320800860872   GRAND CONCOURSE ACAD CHARTER 360011205672 320800860872 GRAND CONCOURSE ACAD CHARTER SCH charter Regular School Yes Elementary KG 08 2019   grade_8 0.0 20.0 29.0   2.0     2.0     0.0   27.0 26.0     *       38     *   53 0 20 29   2     2     0   27 26         38       53
2143036 NY Bronx   school 3600165 320800860903   HYDE LEADERSHIP CHARTER SCHO 360016505889 320800860903 HYDE LEADERSHIP CHARTER SCHOOL charter Regular School Yes Other KG 12 2019   grade_8 0.0 31.0 45.0   0.0     0.0     1.0   42.0 35.0     *       74     15   77 0 31 45   0     0     1   42 35         74   15   77
2143055 NY Bronx   school 3600986 320800860940   GIRLS PREP CHARTER-BRONX 360098606161 320800860940 GIRLS PREP CHARTER SCH-BRONX charter Regular School Yes Elementary PK 08 2019   grade_8 0.0 28.0 39.0   0.0     1.0     1.0   0.0 69.0     *       63     15   69 0 28 39   0     1     1   0 69         63   15   69
2143511 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2019   grade_8 0.0 41.0 73.0   0.0     1.0     1.0   48.0 68.0     *       107     15   116 0 41 73   0     1     1   48 68         107   15   116
2143853 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605666 320900010327 COMP MODEL SCH PROJECT MS 327 public Regular School No High 06 12 2019   grade_8 1.0 15.0 77.0   1.0     1.0     1.0   59.0 37.0     *       *     *   96 1 15 77   1     1     1   59 37                 96
2144100 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605670 320900011231 EAGLE ACADEMY FOR YOUNG MEN public Regular School No High 06 12 2019   grade_8 0.0 44.0 29.0   1.0     0.0     0.0   74.0       *       61     23   74 0 44 29   1     0     0   74           61   23   74
2144233 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605865 320900011324 BRONX EARLY COL ACAD-TEACH/LEARN public Regular School No High 06 12 2019   grade_8 0.0 25.0 72.0   0.0     1.0         52.0 46.0     *       89     14   98 0 25 72   0     1         52 46         89   14   98
2144499 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_8 0.0 45.0 17.0   0.0     1.0     0.0   31.0 32.0     *       56     8   63 0 45 17   0     1     0   31 32         56   8   63
2144575 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Other KG 10 2019   grade_8 1.0 22.0 31.0   0.0     0.0         18.0 36.0     *       53     7   54 1 22 31   0     0         18 36         53   7   54
2144632 NY Bronx   school 3601069 320900861029   ICAHN CHARTER SCHOOL 6 360106906355 320900861029 ICAHN CHARTER SCHOOL 6 charter Regular School Yes Elementary KG 08 2019   grade_8 0.0 21.0 16.0   0.0     0.0     0.0   10.0 27.0     *       29     *   37 0 21 16   0     0     0   10 27         29       37
2144708 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705137 321000010003 PS 3 RAUL JULIA MICRO SOCIETY public Regular School No Elementary PK 08 2019   grade_8 0.0 11.0 20.0                   12.0 19.0     *       29     7   31 0 11 20                   12 19         29   7   31
2144784 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701748 321000010015 PS 15 INST FOR ENVIRON LRNG public Regular School No Elementary KG 08 2019   grade_8   5.0 48.0   0.0     0.0     0.0   27.0 26.0     *       44     12   53   5 48   0     0     0   27 26         44   12   53
2144898 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701304 321000010037 PS 37 MULTIPLE INTELLIGENCE SCHOOL public Regular School No Elementary KG 08 2019   grade_8 0.0 12.0 32.0   2.0     0.0     0.0   24.0 22.0     *       36     12   46 0 12 32   2     0     0   24 22         36   12   46
2145183 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702440 321000010118 JHS 118 WILLIAM W NILES public Regular School No Middle 06 08 2019   grade_8 6.0 78.0 213.0   1.0     59.0     1.0   187.0 171.0     *       313     82   358 6 78 213   1     59     1   187 171         313   82   358
2145392 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703794 321000010254 IS 254 public Regular School No Middle 06 08 2019   grade_8 1.0 31.0 123.0   0.0     3.0     1.0   86.0 73.0     *       144     45   159 1 31 123   0     3     1   86 73         144   45   159
2146171 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701922 321000011445 BRONX HIGH SCHOOL OF SCIENCE public Regular School No High 09 12 2019   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
2146361 NY Bronx   school 3600968 321000860914   BRONX COMMUNITY CHARTER SCHO 360096806074 321000860914 BRONX COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_8 1.0 14.0 30.0         2.0     0.0   28.0 19.0     *       41     17   47 1 14 30         2     0   28 19         41   17   47
2146931 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802613 321100010175 PS 175 CITY ISLAND public Regular School No Elementary KG 08 2019   grade_8 33.0 5.0 14.0   0.0     1.0     0.0   25.0 28.0     *       19     8   53 33 5 14   0     1     0   25 28         19   8   53
2147045 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805800 321100010287 NORTH BRONX SCHOOL OF EMPOWERMENT public Regular School No Middle 06 08 2019   grade_8 4.0 124.0 57.0   2.0     8.0     0.0   102.0 93.0     *       175     60   195 4 124 57   2     8     0   102 93         175   60   195
2147140 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2019   grade_8 1.0 53.0 31.0   1.0           0.0   48.0 38.0     *       66     25   86 1 53 31   1           0   48 38         66   25   86
2147159 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806129 321100010468 PELHAM ACAD-ACADEMICS AND COMMUNITY public Regular School No Middle 06 08 2019   grade_8 19.0 14.0 52.0   0.0     12.0         48.0 49.0     *       *     *   97 19 14 52   0     12         48 49                 97
2147216 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806217 321100010498 PS/MS 498 VAN NEST ACADEMY public Regular School No Elementary KG 08 2019   grade_8 11.0 17.0 57.0   0.0     8.0     1.0   54.0 40.0     *       68     26   94 11 17 57   0     8     1   54 40         68   26   94
2147254 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806249 321100010532 BAYCHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 0.0 64.0 31.0   0.0     3.0     0.0   56.0 42.0     *       83     *   98 0 64 31   0     3     0   56 42         83       98
2147691 NY Bronx   school 3600943 321100860909   ICAHN CHARTER SCHOOL 2 360094305973 321100860909 ICAHN CHARTER SCHOOL 2 charter Regular School Yes Elementary KG 08 2019   grade_8 0.0 14.0 21.0   0.0     1.0     0.0   17.0 19.0     *       21     6   36 0 14 21   0     1     0   17 19         21   6   36
2147767 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2019   grade_8 2.0 10.0 14.0   0.0     4.0     0.0   12.0 18.0     *       20     *   30 2 10 14   0     4     0   12 18         20       30
2148204 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005169 321200010217 SCHOOL OF PERFORMING ARTS public Regular School No Middle 06 08 2019   grade_8 0.0 29.0 56.0   2.0     1.0     1.0   34.0 55.0     *       *     21   89 0 29 56   2     1     1   34 55             21   89
2148375 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006002 321200010383 EMOLIOR ACADEMY public Regular School No Middle 06 08 2019   grade_8 3.0 30.0 62.0   7.0     2.0     0.0   54.0 50.0     *       96     27   104 3 30 62   7     2     0   54 50         96   27   104
2148527 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005689 321200011267 BRONX LATIN SCHOOL public Regular School No High 06 12 2019   grade_8 2.0 16.0 66.0   1.0     1.0     0.0   46.0 40.0     *       82     23   86 2 16 66   1     1     0   46 40         82   23   86
2148888 NY Bronx   school 3601161 321200861108   NY CENTER FOR AUTISM CS - BR 360116106615 321200861108 NY CENTER FOR AUTISM CS - BRONX charter Special Education School Yes Elementary KG KG 2019   grade_8 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
2148907 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2148926 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2019   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
2148945 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 112.0 2.0 3.0   1.0     1.0     4.0   63.0 60.0     *       51     15   123 112 2 3   1     1     4   63 60         51   15   123
2149097 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 96.0 49.0 20.0   1.0     5.0     26.0   106.0 91.0     *       132     37   197 96 49 20   1     5     26   106 91         132   37   197
2149192 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2149230 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 88.0 4.0 3.0   1.0     0.0     1.0   55.0 42.0     *       49     16   97 88 4 3   1     0     1   55 42         49   16   97
2149249 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2019   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
2149306 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   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
2149325 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 103.0 3.0 5.0   1.0     1.0     3.0   61.0 55.0     *       44     19   116 103 3 5   1     1     3   61 55         44   19   116
2149382 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 10 2019   grade_8 163.0 7.0 5.0   3.0     2.0     4.0   94.0 90.0     *       66     31   184 163 7 5   3     2     4   94 90         66   31   184
2149439 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2149515 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   grade_8 12.0 0.0 1.0               2.0   7.0 8.0     *       13     *   15 12 0 1               2   7 8         13       15
2149534 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 197.0 27.0 22.0   0.0     8.0     26.0   137.0 143.0     *       145     42   280 197 27 22   0     8     26   137 143         145   42   280
2149648 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001373 31502060005 JOHNSON CITY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 101.0 40.0 14.0         13.0     12.0   91.0 89.0     *       126     19   180 101 40 14         13     12   91 89         126   19   180
2149724 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   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
2149819 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2149857 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   grade_8 116.0 5.0 3.0         1.0     5.0   64.0 66.0     *       71     22   130 116 5 3         1     5   64 66         71   22   130
2149933 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2019   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
2150047 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2019   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
2150123 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   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
2150161 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2019   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
2150332 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2019   grade_8 4.0 0.0 0.0   2.0           0.0   6.0 0.0     *       *     6   6 4 0 0   2           0   6 0             6   6
2150351 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 08 12 2019   grade_8 53.0 1.0 5.0   28.0     1.0     3.0   54.0 37.0     *       64     9   91 53 1 5   28     1     3   54 37         64   9   91
2150370 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   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
2150389 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 07 2019   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
2150408 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   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
2150427 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 155.0 0.0 4.0         0.0     0.0   77.0 82.0     *       81     27   159 155 0 4         0     0   77 82         81   27   159
2150446 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   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
2150465 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2150579 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_8 232.0 20.0 9.0         3.0     22.0   151.0 135.0     *       *     *   286 232 20 9         3     22   151 135                 286
2150598 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN HIGH SCHOOL public Regular School No High 09 12 2019   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
2150636 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150655 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   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
2150674 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004435 50401040002 CATO-MERIDIAN MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 53.0 0.0 1.0         0.0     4.0   27.0 31.0     *       26     *   58 53 0 1         0     4   27 31         26       58
2150712 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757003749 50701040005 SOUTHERN CAYUGA 7-12 SECONDARY SCH public Regular School No High 07 12 2019   grade_8 38.0 0.0 3.0   0.0           3.0   24.0 20.0     *       23     10   44 38 0 3   0           3   24 20         23   10   44
2150788 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2150807 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_8 69.0   2.0   0.0     0.0     0.0   34.0 37.0     *       43     14   71 69   2   0     0     0   34 37         43   14   71
2150826 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2150883 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2150902 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003755 60201060006 SOUTHWESTERN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 94.0 1.0 2.0         3.0     1.0   63.0 38.0     *       38     10   101 94 1 2         3     1   63 38         38   10   101
2150940 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150959 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000917 60301040004 FREWSBURG JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   grade_8 61.0 0.0 0.0   1.0     2.0     0.0   38.0 26.0     *       32     8   64 61 0 0   1     2     0   38 26         32   8   64
2150978 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000453 60401040003 SINCLAIRVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
2151054 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2151073 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003232 60601040003 PINE VALLEY CENTRAL JR-SR HIGH SCH public Regular School No High 07 12 2019   grade_8 38.0 0.0 4.0   1.0           3.0   22.0 24.0     *       30     11   46 38 0 4   1           3   22 24         30   11   46
2151263 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   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
2151320 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003666 61501040001 SILVER CREEK HIGH SCHOOL public Regular School No High 09 12 2019   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
2151339 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 61.0 0.0 4.0   10.0           7.0   40.0 42.0     *       47     *   82 61 0 4   10           7   40 42         47       82
2151415 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2019   grade_8 31.0   3.0               0.0   20.0 14.0     *       13     *   34 31   3               0   20 14         13       34
2151434 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003155 61601040003 PANAMA K-6 SCHOOL public Regular School No Elementary PK 06 2019   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
2151491 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563004390 61700010006 PERSELL MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 64.0 2.0 19.0   0.0     0.0     13.0   45.0 53.0     *       66     10   98 64 2 19   0     0     13   45 53         66   10   98
2151510 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001353 61700010007 MILTON J FLETCHER ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   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

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