Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_6 · 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
2139196 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_6 8.0 43.0 12.0   0.0     5.0     5.0   29.0 44.0     *       47     *   73 8 43 12   0     5     5   29 44         47       73
2139386 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   grade_6 16.0 99.0 31.0         7.0     12.0   76.0 89.0     *       146     16   165 16 99 31         7     12   76 89         146   16   165
2139652 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 279.0 10.0 5.0         26.0     8.0   163.0 165.0     *       46     42   328 279 10 5         26     8   163 165         46   42   328
2139747 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139823 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139842 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 102.0 13.0 7.0   0.0     1.0     13.0   73.0 63.0     *       131     22   136 102 13 7   0     1     13   73 63         131   22   136
2140032 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2019   grade_6 9.0 9.0 2.0   1.0     12.0     1.0   17.0 17.0     *       11     6   34 9 9 2   1     12     1   17 17         11   6   34
2140108 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2019   grade_6 56.0 0.0 1.0   0.0     15.0     5.0   38.0 39.0     *       20     6   77 56 0 1   0     15     5   38 39         20   6   77
2140127 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2019   grade_6 39.0 2.0 4.0   1.0     5.0     3.0   23.0 31.0     *       9     5   54 39 2 4   1     5     3   23 31         9   5   54
2140146 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2019   grade_6 39.0 3.0 2.0   0.0     8.0     3.0   29.0 26.0     *       10     *   55 39 3 2   0     8     3   29 26         10       55
2140355 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2140374 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2140393 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 100.0 1.0 3.0         2.0     1.0   56.0 51.0     *       14     14   107 100 1 3         2     1   56 51         14   14   107
2140583 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_6 42.0 0.0 2.0   0.0     0.0         28.0 16.0     *       28     7   44 42 0 2   0     0         28 16         28   7   44
2140678 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_6 27.0 0.0 0.0   0.0           0.0   12.0 15.0     *       20     *   27 27 0 0   0           0   12 15         20       27
2140697 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2019   grade_6 85.0 2.0 4.0   0.0     0.0     1.0   41.0 51.0     *       51     12   92 85 2 4   0     0     1   41 51         51   12   92
2141400 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_6 0.0 13.0 46.0   1.0     1.0         36.0 25.0     *       52     10   61 0 13 46   1     1         36 25         52   10   61
2141571 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2019   grade_6 2.0 34.0 45.0   0.0     0.0     2.0   39.0 44.0     *       74     20   83 2 34 45   0     0     2   39 44         74   20   83
2141609 NY Bronx   school 3600144 320700860889   SOUTH BRONX CHARTER SCHOOL 360014405787 320700860889 SOUTH BRONX CHARTER SCHOOL charter Regular School Yes Elementary KG 06 2019   grade_6 0.0 3.0 39.0   0.0     0.0         20.0 22.0     *       39     0   42 0 3 39   0     0         20 22         39   0   42
2141666 NY Bronx   school 3600960 320700860925   MOTT HAVEN ACADEMY CHARTER S 360096006013 320700860925 MOTT HAVEN ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary PK 07 2019   grade_6 0.0 19.0 36.0   0.0     0.0     0.0   22.0 33.0     *       52     11   55 0 19 36   0     0     0   22 33         52   11   55
2141704 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_6 0.0 30.0 27.0   0.0     1.0     1.0   32.0 27.0     *       57     10   59 0 30 27   0     1     1   32 27         57   10   59
2142198 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_6 21.0 19.0 103.0   1.0     36.0     1.0   80.0 101.0     *       138     43   181 21 19 103   1     36     1   80 101         138   43   181
2142407 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505121 320800010301 MS 301 PAUL L DUNBAR public Regular School No Middle 06 08 2019   grade_6 4.0 24.0 34.0   3.0               32.0 33.0     *       *     *   65 4 24 34   3               32 33                 65
2142578 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506081 320800010424 HUNTS POINT SCHOOL (THE) public Regular School No Middle 06 08 2019   grade_6 1.0 26.0 64.0         1.0     1.0   50.0 43.0     *       *     *   93 1 26 64         1     1   50 43                 93
2143015 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_6 1.0 25.0 36.0   0.0     1.0     0.0   31.0 32.0     *       56     9   63 1 25 36   0     1     0   31 32         56   9   63
2143053 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_6 0.0 27.0 48.0   0.0     0.0     0.0   0.0 75.0     *       66     16   75 0 27 48   0     0     0   0 75         66   16   75
2143129 NY Bronx   school 3601131 320800861068   SOUTH BRONX EARLY COLLEGE AC 360113106555 320800861068 SOUTH BRONX EARLY COLLEGE ACADEMY CS charter Regular School Yes Middle 06 08 2019   grade_6 0.0 33.0 79.0         0.0         56.0 56.0     *       102     36   112 0 33 79         0         56 56         102   36   112
2143205 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604461 320900010022 JHS 22 JORDAN L MOTT public Regular School No Middle 06 08 2019   grade_6 3.0 32.0 97.0   0.0     2.0     0.0   67.0 67.0     *       *     37   134 3 32 97   0     2     0   67 67             37   134
2143661 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603747 320900010219 IS 219 NEW VENTURE SCHOOL public Regular School No Middle 06 08 2019   grade_6 1.0 47.0 66.0   0.0     0.0     1.0   67.0 48.0     *       112     46   115 1 47 66   0     0     1   67 48         112   46   115
2143699 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 public Regular School No Middle 06 08 2019   grade_6 1.0 43.0 121.0               1.0   89.0 77.0     *       162     41   166 1 43 121               1   89 77         162   41   166
2143813 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008603767 320900010313 IS 313 SCHOOL OF LEADERSHIP DEV public Regular School No Middle 06 08 2019   grade_6 0.0 13.0 64.0   2.0     0.0     1.0   46.0 34.0     *       76     20   80 0 13 64   2     0     1   46 34         76   20   80
2143870 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605667 320900010328 NEW MILLENNIUM BUSINESS ACAD MS public Regular School No Middle 06 08 2019   grade_6 2.0 36.0 77.0         2.0     0.0   63.0 54.0     *       110     33   117 2 36 77         2     0   63 54         110   33   117
2144022 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606345 320900010568 YOUNG WOMEN'S LDSHP SCHOOL-BRONX public Regular School No High 06 12 2019   grade_6 3.0 24.0 58.0   1.0     0.0     0.0     86.0     *       74     18   86 3 24 58   1     0     0     86         74   18   86
2144060 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606642 320900010594 MS 594 public Regular School No Middle 06 08 2019   grade_6 1.0 18.0 54.0   2.0     1.0         40.0 36.0     *       74     23   76 1 18 54   2     1         40 36         74   23   76
2144098 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_6 0.0 37.0 37.0   2.0     0.0     0.0   76.0       *       62     25   76 0 37 37   2     0     0   76           62   25   76
2144497 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_6 0.0 48.0 22.0   1.0     0.0     0.0   36.0 35.0     *       61     13   71 0 48 22   1     0     0   36 35         61   13   71
2144782 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_6   4.0 53.0   0.0     2.0     0.0   24.0 35.0     *       45     14   59   4 53   0     2     0   24 35         45   14   59
2145048 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702316 321000010080 JHS 80 MOSHOLU PARKWAY (THE) public Regular School No Middle 06 08 2019   grade_6 5.0 30.0 146.0   1.0     19.0     1.0   105.0 97.0     *       *     59   202 5 30 146   1     19     1   105 97             59   202
2145352 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705798 321000010244 NEW SCHOOL-LEADERSHIP & JOURNAL public Regular School No Middle 06 08 2019   grade_6 4.0 11.0 168.0   1.0     4.0     2.0   98.0 92.0     *       184     43   190 4 11 168   1     4     2   98 92         184   43   190
2145542 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702939 321000010315 PS 315 LAB SCHOOL public Regular School No Elementary KG 08 2019   grade_6 0.0 1.0 26.0         0.0     0.0   15.0 12.0     *       21     *   27 0 1 26         0     0   15 12         21       27
2145637 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706297 321000010363 ACAD-PERSONAL LDSHP AND EXCELLENCE public Regular School No Middle 06 08 2019   grade_6 5.0 22.0 134.0   1.0     4.0     1.0   92.0 75.0     *       *     56   167 5 22 134   1     4     1   92 75             56   167
2145713 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703811 321000010390 MS 390 public Regular School No Middle 06 08 2019   grade_6 2.0 24.0 138.0   1.0     3.0         75.0 93.0     *       *     *   168 2 24 138   1     3         75 93                 168
2145770 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706141 321000010447 CRESTON ACADEMY public Regular School No Middle 06 08 2019   grade_6 0.0 16.0 114.0   2.0     1.0         62.0 71.0     *       *     *   133 0 16 114   2     1         62 71                 133
2146169 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_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2146359 NY Bronx   school 3600968 321000860914   BRONX COMMUNITY CHARTER SCHO 360096806074 321000860914 BRONX COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_6 3.0 11.0 37.0         1.0     0.0   22.0 30.0     *       44     10   52 3 11 37         1     0   22 30         44   10   52
2147062 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805953 321100010326 BRONX GREEN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 19.0 30.0 82.0   2.0     7.0     2.0   65.0 77.0     *       130     30   142 19 30 82   2     7     2   65 77         130   30   142
2147081 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806399 321100010355 BRONX ALLIANCE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 1.0 56.0 35.0   1.0     2.0         43.0 52.0     *       88     27   95 1 56 35   1     2         43 52         88   27   95
2147138 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_6 1.0 52.0 32.0   1.0           2.0   43.0 45.0     *       69     21   88 1 52 32   1           2   43 45         69   21   88
2147214 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_6 20.0 8.0 56.0   0.0     4.0     1.0   47.0 42.0     *       72     22   89 20 8 56   0     4     1   47 42         72   22   89
2147252 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806249 321100010532 BAYCHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 2.0 45.0 33.0   3.0     1.0     2.0   44.0 42.0     *       *     20   86 2 45 33   3     1     2   44 42             20   86
2147271 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806314 321100010556 BRONX PARK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 14.0 32.0 93.0   1.0     6.0     1.0   75.0 72.0     *       135     30   147 14 32 93   1     6     1   75 72         135   30   147
2147746 NY Bronx   school 3601005 321100860956   EQUALITY CHARTER SCHOOL 360100506110 321100860956 EQUALITY CHARTER SCHOOL charter Regular School Yes High 06 12 2019   grade_6 1.0 56.0 21.0   0.0     2.0     1.0   41.0 40.0     *       66     26   81 1 56 21   0     2     1   41 40         66   26   81
2147765 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2019   grade_6 2.0 15.0 12.0   0.0     4.0     0.0   13.0 20.0     *       18     *   33 2 15 12   0     4     0   13 20         18       33
2148012 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002373 321200010098 JHS 98 HERMAN RIDDER public Regular School No Middle 06 08 2019   grade_6 0.0 13.0 46.0   2.0     1.0     1.0   35.0 28.0     *       *     *   63 0 13 46   2     1     1   35 28                 63
2148772 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2019   grade_6 0.0 19.0 25.0   1.0     0.0     0.0   22.0 23.0     *       41     *   45 0 19 25   1     0     0   22 23         41       45
2148791 NY Bronx   school 3600161 321200860898   SOUTH BRONX CLASSICAL CHARTE 360016105893 321200860898 SOUTH BRONX CLASSICAL CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_6 2.0 13.0 17.0   1.0     2.0     1.0   20.0 16.0     *       33     *   36 2 13 17   1     2     1   20 16         33       36
2148848 NY Bronx   school 3601066 321200861026   CHILDREN'S AID COLLEGE PREP 360106606303 321200861026 CHILDREN'S AID COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 07 2019   grade_6 1.0 34.0 34.0   2.0     0.0     1.0   35.0 37.0     *       *     20   72 1 34 34   2     0     1   35 37             20   72
2148886 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_6 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
2148905 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2148924 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2148943 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 116.0 1.0 0.0   0.0     0.0     3.0   68.0 52.0     *       52     16   120 116 1 0   0     0     3   68 52         52   16   120
2149095 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 104.0 47.0 30.0   1.0     7.0     23.0   116.0 96.0     *       154     36   212 104 47 30   1     7     23   116 96         154   36   212
2149190 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149228 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 93.0 2.0 3.0   1.0     0.0     3.0   54.0 48.0     *       54     7   102 93 2 3   1     0     3   54 48         54   7   102
2149247 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149304 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149323 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 128.0 1.0 5.0   1.0     4.0     9.0   72.0 76.0     *       71     24   148 128 1 5   1     4     9   72 76         71   24   148
2149380 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 10 2019   grade_6 143.0 4.0 5.0   1.0     2.0     13.0   79.0 89.0     *       80     31   168 143 4 5   1     2     13   79 89         80   31   168
2149437 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2149513 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   grade_6 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
2149532 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 182.0 21.0 26.0   0.0     5.0     29.0   115.0 148.0     *       179     34   263 182 21 26   0     5     29   115 148         179   34   263
2149722 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2149779 NY Broome   school 3629610 31601060000   VESTAL 362961003985 31601060041 VESTAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 189.0 4.0 10.0   1.0     31.0     11.0   132.0 114.0     *       73     36   246 189 4 10   1     31     11   132 114         73   36   246
2149817 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2149855 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   grade_6 112.0 6.0 2.0         0.0     6.0   65.0 61.0     *       73     18   126 112 6 2         0     6   65 61         73   18   126
2149931 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150045 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150121 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150159 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2019   grade_6 103.0 8.0 5.0   2.0     4.0     15.0   77.0 60.0     *       83     25   137 103 8 5   2     4     15   77 60         83   25   137
2150330 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2019   grade_6 3.0 0.0 3.0   0.0           1.0   7.0 0.0     *       *     7   7 3 0 3   0           1   7 0             7   7
2150349 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 08 12 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150368 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150387 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 07 2019   grade_6 47.0 0.0 10.0   29.0     0.0     3.0   45.0 44.0     *       66     12   89 47 0 10   29     0     3   45 44         66   12   89
2150406 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150425 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_6 175.0 2.0 5.0         1.0     0.0   93.0 90.0     *       114     37   183 175 2 5         1     0   93 90         114   37   183
2150444 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150463 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150558 NY Cayuga   school 3603480 50100010000   AUBURN 360348000109 50100010008 WILLIAM H SEWARD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_6 42.0 4.0 4.0   0.0     1.0     5.0   24.0 32.0     *       22     *   56 42 4 4   0     1     5   24 32         22       56
2150577 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150596 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN HIGH SCHOOL public Regular School No High 09 12 2019   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2150634 NY Cayuga   school 3630420 50301040000   WEEDSPORT 363042004094 50301040003 WEEDSPORT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_6 48.0   7.0   0.0     0.0     2.0   32.0 25.0     *       20     10   57 48   7   0     0     2   32 25         20   10   57
2150653 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004434 50401040001 CATO-MERIDIAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150672 NY Cayuga   school 3606690 50401040000   CATO MERIDIAN 360669004435 50401040002 CATO-MERIDIAN MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_6 68.0 0.0 0.0         0.0     2.0   39.0 31.0     *       30     10   70 68 0 0         0     2   39 31         30   10   70
2150786 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001812 51301040001 MILLARD FILLMORE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0               0.0   0.0 0.0     *       0     0   0 0 0 0               0   0 0         0   0   0
2150805 NY Cayuga   school 3619800 51301040000   MORAVIA 361980001813 51301040003 MORAVIA JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_6 74.0   2.0   0.0     0.0     2.0   42.0 36.0     *       47     12   78 74   2   0     0     2   42 36         47   12   78
2150824 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150881 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003756 60201060003 SOUTHWESTERN SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2150900 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766003755 60201060006 SOUTHWESTERN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 89.0 0.0 2.0         2.0     3.0   53.0 43.0     *       44     12   96 89 0 2         2     3   53 43         44   12   96
2150938 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_6 71.0 2.0 0.0         1.0     1.0   35.0 40.0     *       31     13   75 71 2 0         1     1   35 40         31   13   75
2150957 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000917 60301040004 FREWSBURG JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   grade_6 0.0 0.0 0.0   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]);