Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_9 · 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
2139674 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 330.0 7.0 13.0         28.0     8.0   172.0 214.0     *       56     33   386 330 7 13         28     8   172 214         56   33   386
2139712 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2019   grade_9 127.0 10.0 14.0         1.0     7.0   97.0 62.0     *       88     34   159 127 10 14         1     7   97 62         88   34   159
2139750 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139826 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 104.0 18.0 10.0   0.0     3.0     9.0   78.0 66.0     *       104     32   144 104 18 10   0     3     9   78 66         104   32   144
2139845 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139940 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 264.0 38.0 24.0   0.0     36.0     25.0   183.0 204.0     *       153     50   387 264 38 24   0     36     25   183 204         153   50   387
2140282 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 305.0 13.0 5.0   0.0     55.0     20.0   197.0 201.0     *       78     63   398 305 13 5   0     55     20   197 201         78   63   398
2140358 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2140377 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 79.0 0.0 3.0   1.0     4.0     1.0   46.0 42.0     *       13     7   88 79 0 3   1     4     1   46 42         13   7   88
2140396 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2140434 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_9 51.0 32.0 14.0   0.0     5.0     8.0   66.0 44.0     *       69     18   110 51 32 14   0     5     8   66 44         69   18   110
2140586 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_9 47.0 0.0 1.0   1.0     0.0         21.0 28.0     *       27     10   49 47 0 1   1     0         21 28         27   10   49
2140681 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_9 24.0 0.0 0.0   0.0           1.0   17.0 8.0     *       16     *   25 24 0 0   0           1   17 8         16       25
2140700 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2019   grade_9 88.0 1.0 0.0   2.0     0.0     1.0   40.0 52.0     *       35     12   92 88 1 0   2     0     1   40 52         35   12   92
2141080 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 LAB SCHOOL OF FIN & TECH: X223 public Regular School No High 06 12 2019   grade_9 1.0 22.0 73.0   1.0     0.0     0.0   53.0 44.0     *       90     15   97 1 22 73   1     0     0   53 44         90   15   97
2141308 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405988 320700011379 JILL CHAIFETZ TRANSFER HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 0.0 3.0 8.0   0.0     0.0     0.0   6.0 5.0     *       10     *   11 0 3 8   0     0     0   6 5         10       11
2141327 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406056 320700011381 BRONX HAVEN HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 0.0 10.0 10.0   0.0     0.0         13.0 7.0     *       14     8   20 0 10 10   0     0         13 7         14   8   20
2141384 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400749 320700011495 UNIVERSITY HEIGHTS SECONDARY SCHOOL public Regular School No High 09 12 2019   grade_9 1.0 29.0 83.0   2.0     6.0     3.0   46.0 78.0     *       105     26   124 1 29 83   2     6     3   46 78         105   26   124
2141574 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2019   grade_9 1.0 35.0 39.0   0.0     0.0     0.0   39.0 36.0     *       59     *   75 1 35 39   0     0     0   39 36         59       75
2142714 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505659 320800011293 RENAISSANCE HIGH SCHOOL-MTA public Regular School No High 09 12 2019   grade_9 9.0 32.0 83.0   1.0     2.0         52.0 75.0     *       99     42   127 9 32 83   1     2         52 75         99   42   127
2142771 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506388 320800011349 BRONX RIVER HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 5.0 35.0 68.0   4.0     4.0         68.0 48.0     *       89     32   116 5 35 68   4     4         68 48         89   32   116
2142809 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505984 320800011376 ANTONIA PANTOJA PREP ACADEMY public Regular School No High 06 12 2019   grade_9 1.0 5.0 36.0   2.0     6.0         28.0 22.0     *       *     17   50 1 5 36   2     6         28 22             17   50
2142828 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505983 320800011377 BRONX COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 0.0 21.0 51.0         0.0         47.0 25.0     *       60     13   72 0 21 51         0         47 25         60   13   72
2142885 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505186 320800011452 GOTHAM COLLABORATIVE HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 3.0 29.0 60.0   2.0     6.0         65.0 35.0     *       *     *   100 3 29 60   2     6         65 35                 100
2142923 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506258 320800011537 BRONX ARENA HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 1.0 13.0 15.0   1.0     0.0     0.0   16.0 14.0     *       29     *   30 1 13 15   1     0     0   16 14         29       30
2144234 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_9 0.0 20.0 58.0   0.0     3.0         43.0 38.0     *       72     14   81 0 20 58   0     3         43 38         72   14   81
2144329 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605175 320900011404 SCHOOL FOR EXCELLENCE public Regular School No High 09 12 2019   grade_9 1.0 29.0 30.0   1.0     0.0         29.0 32.0     *       *     20   61 1 29 30   1     0         29 32             20   61
2144386 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602961 320900011505 BRONX SCHOOL FOR LAW, GOV, JUSTICE public Regular School No High 06 12 2019   grade_9 0.0 33.0 86.0   0.0     1.0     1.0   53.0 68.0     *       111     34   121 0 33 86   0     1     1   53 68         111   34   121
2144424 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008600795 320900011525 BRONX LEADERSHIP ACAD HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 0.0 39.0 80.0   3.0     2.0     0.0   67.0 57.0     *       112     35   124 0 39 80   3     2     0   67 57         112   35   124
2144576 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Other KG 10 2019   grade_9 0.0 12.0 45.0   1.0     0.0         31.0 27.0     *       55     14   58 0 12 45   1     0         31 27         55   14   58
2145906 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705678 321000011284 BRONX SCHOOL OF LAW & FINANCE public Regular School No High 09 12 2019   grade_9 5.0 28.0 63.0   0.0     0.0     1.0   50.0 47.0     *       89     25   97 5 28 63   0     0     1   50 47         89   25   97
2145925 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705760 321000011319 PULSE HIGH SCHOOL public Regular School No High 09 12 2019   grade_9   2.0 15.0   2.0     0.0         6.0 13.0     *       18     *   19   2 15   2     0         6 13         18       19
2146001 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705943 321000011374 KNOWLEDGE, POWER PREP ACAD INTER HS public Regular School No High 09 12 2019   grade_9 3.0 32.0 83.0   0.0     2.0     1.0   47.0 74.0     *       105     33   121 3 32 83   0     2     1   47 74         105   33   121
2146172 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_9 170.0 19.0 58.0   9.0     473.0     32.0   444.0 317.0     *       289     18   761 170 19 58   9     473     32   444 317         289   18   761
2146248 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705496 321000011546 BRONX THEATRE HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 2.0 40.0 64.0   1.0     2.0     2.0   35.0 76.0     *       93     27   111 2 40 64   1     2     2   35 76         93   27   111
2146381 NY Bronx   school 3601047 321000860999   NEW VISIONS-HS FOR MATH 360104706254 321000860999 NEW VISIONS CHARTER HS-ADV MATH/SCIE charter Regular School Yes High 09 12 2019   grade_9 2.0 46.0 67.0   2.0     6.0     5.0   64.0 64.0     *       98     21   128 2 46 67   2     6     5   64 64         98   21   128
2147331 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805680 321100011249 BRONX HEALTH SCIENCES HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 5.0 63.0 43.0   4.0     5.0         54.0 66.0     *       94     27   120 5 63 43   4     5         54 66         94   27   120
2147388 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805810 321100011270 ACAD-SCHOLARSHIP & ENTREPRENEURSHIP public Regular School No High 09 12 2019   grade_9 0.0 65.0 39.0   2.0     0.0     0.0   59.0 47.0     *       86     27   106 0 65 39   2     0     0   59 47         86   27   106
2147597 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805541 321100011542 PELHAM PREPARATORY ACADEMY public Regular School No High 09 12 2019   grade_9 10.0 40.0 72.0   1.0     14.0     3.0   75.0 65.0     *       101     34   140 10 40 72   1     14     3   75 65         101   34   140
2147616 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805543 321100011544 HIGH SCHOOL FOR CONTEMPORARY ARTS public Regular School No High 09 12 2019   grade_9 3.0 27.0 35.0   1.0     0.0     0.0   31.0 35.0     *       *     23   66 3 27 35   1     0     0   31 35             23   66
2147768 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2148509 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005792 321200011251 EXPLORATIONS ACADEMY HS public Regular School No High 09 12 2019   grade_9 0.0 19.0 56.0   2.0     0.0         53.0 24.0     *       68     26   77 0 19 56   2     0         53 24         68   26   77
2148604 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006160 321200011478 CINEMA SCHOOL (THE) public Regular School No High 09 12 2019   grade_9 5.0 17.0 69.0   4.0     1.0         47.0 49.0     *       74     20   96 5 17 69   4     1         47 49         74   20   96
2148775 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2019   grade_9 0.0 26.0 43.0   2.0     1.0     0.0   33.0 39.0     *       67     19   72 0 26 43   2     1     0   33 39         67   19   72
2148889 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_9 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
2148908 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2148927 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 102.0 2.0 4.0   0.0     0.0     3.0   65.0 46.0     *       38     17   111 102 2 4   0     0     3   65 46         38   17   111
2148946 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149098 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149193 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149231 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149250 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2019   grade_9 83.0 1.0 4.0   0.0     1.0     3.0   47.0 45.0     *       35     15   92 83 1 4   0     1     3   47 45         35   15   92
2149307 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149402 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001630 31101060006 MAINE-ENDWELL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 182.0 7.0 3.0   0.0     6.0     1.0   102.0 97.0     *       91     24   199 182 7 3   0     6     1   102 97         91   24   199
2149440 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 90.0 1.0 3.0         1.0     1.0   49.0 47.0     *       55     *   96 90 1 3         1     1   49 47         55       96
2149516 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   grade_9 11.0 2.0 0.0               0.0   6.0 7.0     *       12     *   13 11 2 0               0   6 7         12       13
2149535 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149554 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000854 31501060012 UNION-ENDICOTT HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 160.0 24.0 18.0   0.0     6.0     27.0   111.0 124.0     *       131     28   235 160 24 18   0     6     27   111 124         131   28   235
2149725 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149801 NY Broome   school 3629610 31601060000   VESTAL 362961003992 31601060051 VESTAL SENIOR HIGH SCHOOL public Regular School No High 08 12 2019   grade_9 235.0 5.0 6.0   1.0     31.0     6.0   136.0 148.0     *       80     31   284 235 5 6   1     31     6   136 148         80   31   284
2149820 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2149858 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2149934 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150048 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150124 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150162 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150333 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2019   grade_9 6.0 1.0 1.0   1.0           0.0   7.0 2.0     *       0     8   9 6 1 1   1           0   7 2         0   8   9
2150352 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 08 12 2019   grade_9 51.0 1.0 5.0   33.0     1.0     5.0   44.0 52.0     *       67     16   96 51 1 5   33     1     5   44 52         67   16   96
2150371 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150390 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 07 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150409 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150428 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150447 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150466 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 168.0 1.0 3.0   2.0     4.0     0.0   88.0 90.0     *       87     36   178 168 1 3   2     4     0   88 90         87   36   178
2150580 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150599 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 241.0 20.0 17.0   1.0     2.0     33.0   161.0 153.0     *       152     47   314 241 20 17   1     2     33   161 153         152   47   314
2150637 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2150656 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150675 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004435 50401040002 CATO-MERIDIAN MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150789 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
2150808 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_9 65.0   2.0   0.0     0.0     3.0   35.0 35.0     *       38     9   70 65   2   0     0     3   35 35         38   9   70
2150827 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150846 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003937 51901040005 UNION SPRINGS HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 44.0 1.0 4.0         1.0     0.0   28.0 22.0     *       22     5   50 44 1 4         1     0   28 22         22   5   50
2150884 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 85.0 0.0 8.0         2.0     4.0   60.0 39.0     *       35     19   99 85 0 8         2     4   60 39         35   19   99
2150903 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003755 60201060006 SOUTHWESTERN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150941 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150960 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000917 60301040004 FREWSBURG JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   grade_9 65.0 0.0 1.0   0.0     0.0     1.0   32.0 35.0     *       31     8   67 65 0 1   0     0     1   32 35         31   8   67
2150979 NY Chautauqua   school 3606660 60401040000   CASSADAGA VALLEY 360666000453 60401040003 SINCLAIRVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2151055 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0 0 0 0   0           0   0 0         0   0   0
2151074 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_9 40.0 0.0 0.0   0.0           0.0   20.0 20.0     *       24     *   40 40 0 0   0           0   20 20         24       40
2151264 NY Chautauqua   school 3610920 61101040000   FALCONER 361092000870 61101040001 HARVEY C FENNER ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   grade_9 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2151321 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003666 61501040001 SILVER CREEK HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 59.0 1.0 3.0   7.0     0.0     7.0   28.0 49.0     *       51     19   77 59 1 3   7     0     7   28 49         51   19   77
2151340 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688005588 61501040002 SILVER CREEK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0 0 0 0   0           0   0 0         0   0   0
2151416 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003156 61601040001 PANAMA HIGH SCHOOL public Regular School No High 07 12 2019   grade_9 31.0   1.0               0.0   15.0 17.0     *       16     6   32 31   1               0   15 17         16   6   32
2151435 NY Chautauqua   school 3622410 61601040000   PANAMA 362241003155 61601040003 PANAMA K-6 SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0     *       0     0   0 0 0 0   0           0   0 0         0   0   0
2151492 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563004390 61700010006 PERSELL MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2151511 NY Chautauqua   school 3615630 61700010000   JAMESTOWN 361563001353 61700010007 MILTON J FLETCHER ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2151663 NY Chautauqua   school 3611520 62201060000   FREDONIA 361152000907 62201060003 FREDONIA HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 83.0 1.0 12.0         1.0     4.0   60.0 41.0     *       41     14   101 83 1 12         1     4   60 41         41   14   101
2151701 NY Chautauqua   school 3605610 62301040000   BROCTON 360561000289 62301040003 BROCTON MIDDLE HIGH SCHOOL public Regular School No High 06 12 2019   grade_9 44.0   4.0   0.0     0.0     1.0   26.0 23.0     *       29     9   49 44   4   0     0     1   26 23         29   9   49
2151720 NY Chautauqua   school 3624660 62401040000   RIPLEY 362466004367 62401040001 RIPLEY CENTRAL SCHOOL public Regular School No Elementary PK 06 2019   grade_9 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]);