Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_6" and state = "NY" sorted by ell_int

View and edit SQL

year

grade

  • grade_6 · 33,145
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
942062 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_6 8.0 26.0 11.0   0.0     2.0     8.0   30.0 25.0     *       29     9   55 8 26 11   0     2     8   30 25         29   9   55
942119 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 08 2017   grade_6 4.0 13.0 7.0         1.0     4.0   19.0 10.0     *       20     6   29 4 13 7         1     4   19 10         20   6   29
942309 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 25.0 83.0 13.0   0.0     13.0     7.0   53.0 88.0     *       87     *   141 25 83 13   0     13     7   53 88         87       141
942423 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_6 0.0 77.0 4.0         1.0         43.0 39.0     *       74     *   82 0 77 4         1         43 39         74       82
942594 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 295.0 10.0 8.0         23.0     3.0   155.0 184.0     *       52     51   339 295 10 8         23     3   155 184         52   51   339
942651 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   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
942670 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2017   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
942765 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942784 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 101.0 12.0 12.0   1.0     2.0     7.0   59.0 76.0     *       90     17   135 101 12 12   1     2     7   59 76         90   17   135
942974 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_6 9.0 17.0 1.0   0.0     5.0     1.0   14.0 19.0     *       17     *   33 9 17 1   0     5     1   14 19         17       33
942993 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2017   grade_6 49.0 6.0 3.0         15.0     4.0   45.0 32.0     *       23     20   77 49 6 3         15     4   45 32         23   20   77
943012 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   grade_6 58.0 3.0 5.0   0.0     18.0     1.0   48.0 37.0     *       16     8   85 58 3 5   0     18     1   48 37         16   8   85
943050 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2017   grade_6 39.0 4.0 0.0   0.0     20.0     7.0   41.0 29.0     *       18     9   70 39 4 0   0     20     7   41 29         18   9   70
943088 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_6 38.0 6.0 3.0   1.0     13.0     2.0   29.0 34.0     *       13     8   63 38 6 3   1     13     2   29 34         13   8   63
943145 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_6 21.0 0.0 1.0         0.0     2.0   10.0 14.0     *       20     5   24 21 0 1         0     2   10 14         20   5   24
943164 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943297 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943316 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2017   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
943563 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2017   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
943601 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 44.0 0.0 1.0   1.0     0.0         28.0 18.0     *       29     6   46 44 0 1   1     0         28 18         29   6   46
943658 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
943981 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008404460 320700010162 JHS 162 LOLA RODRIGUEZ DE TIO public Regular School No Middle 06 08 2017   grade_6   32.0 103.0   0.0               77.0 58.0     *       127     59   135   32 103   0               77 58         127   59   135
944342 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No Other 06 12 2017   grade_6 0.0 11.0 46.0   0.0     1.0     0.0   28.0 30.0     *       55     17   58 0 11 46   0     1     0   28 30         55   17   58
944532 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_6 0.0 32.0 54.0   2.0     0.0     0.0   53.0 35.0     *       79     16   88 0 32 54   2     0     0   53 35         79   16   88
944589 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BGLIG-SHIRLEY RODRIGUEZ-REMENESKI CS charter Regular School Yes Elementary KG 08 2017   grade_6 0.0 13.0 37.0   0.0     1.0     1.0     52.0     *       41     5   52 0 13 37   0     1     1     52         41   5   52
944817 NY Bronx   school 3601131 320700861068   SOUTH BRONX EARLY COLLEGE AC 360113106555 320700861068 SOUTH BRONX EARLY COLLEGE ACADEMY CS charter Regular School Yes Middle 06 07 2017   grade_6 0.0 35.0 75.0   0.0               70.0 40.0     *       *     *   110 0 35 75   0               70 40                 110
945083 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008503740 320800010101 MS 101 EDWARD R BYRNE public Regular School No Middle 06 08 2017   grade_6 33.0 19.0 103.0   5.0     23.0     1.0   80.0 104.0     *       133     40   184 33 19 103   5     23     1   80 104         133   40   184
945330 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505122 320800010302 MS 302 LUISA DESSUS CRUZ public Regular School No Middle 06 08 2017   grade_6 4.0 38.0 114.0         1.0     1.0   93.0 65.0     *       *     52   158 4 38 114         1     1   93 65             52   158
945349 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505123 320800010304 PS 304 EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK 05 2017   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
945501 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506081 320800010424 HUNTS POINT SCHOOL (THE) public Regular School No Middle 06 08 2017   grade_6   27.0 62.0   0.0     1.0     0.0   54.0 36.0     *       *     39   90   27 62   0     1     0   54 36             39   90
945539 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506162 320800010467 MOTT HALL COMMUNITY SCHOOL public Regular School No Middle 06 08 2017   grade_6 11.0 20.0 66.0   0.0     3.0         58.0 42.0     *       92     30   100 11 20 66   0     3         58 42         92   30   100
945881 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506258 320800011537 BRONX ARENA HIGH SCHOOL public Regular School No High 09 12 2017   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
945976 NY Bronx   school 3600112 320800860872   GRAND CONCOURSE ACAD CHARTER 360011205672 320800860872 GRAND CONCOURSE ACAD CHARTER SCH charter Regular School Yes Elementary KG 07 2017   grade_6 2.0 22.0 40.0   2.0     2.0     0.0   37.0 31.0     *       59     9   68 2 22 40   2     2     0   37 31         59   9   68
945995 NY Bronx   school 3600165 320800860903   HYDE LEADERSHIP CHARTER SCHO 360016505889 320800860903 HYDE LEADERSHIP CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_6 0.0 33.0 40.0   0.0     0.0     0.0   37.0 36.0     *       62     16   73 0 33 40   0     0     0   37 36         62   16   73
946014 NY Bronx   school 3600986 320800860940   GIRLS PREP CHARTER-BRONX 360098606161 320800860940 GIRLS PREP CHARTER SCH-BRONX charter Regular School Yes Elementary PK 08 2017   grade_6 0.0 36.0 50.0   0.0     0.0     1.0   0.0 87.0     *       73     22   87 0 36 50   0     0     1   0 87         73   22   87
946071 NY Bronx   school 3601091 320800861030   ICAHN CHARTER SCHOOL 7 360109106389 320800861030 ICAHN CHARTER SCHOOL 7 charter Regular School Yes Elementary KG 05 2017   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
946432 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605192 320900010117 IS 117 JOSEPH H WADE public Regular School No Middle 06 08 2017   grade_6 0.0 36.0 140.0   1.0     1.0     0.0   89.0 89.0     *       163     *   178 0 36 140   1     1     0   89 89         163       178
946470 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_6   43.0 81.0   0.0     2.0     1.0   50.0 77.0     *       116     19   127   43 81   0     2     1   50 77         116   19   127
946508 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602528 320900010145 JHS 145 ARTURO TOSCANINI public Regular School No Middle 05 08 2017   grade_6 1.0 27.0 49.0         0.0         43.0 34.0     *       61     20   77 1 27 49         0         43 34         61   20   77
946679 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604876 320900010232 IS 232 public Regular School No Middle 06 08 2017   grade_6 0.0 35.0 100.0   1.0     0.0         59.0 77.0     *       *     *   136 0 35 100   1     0         59 77                 136
946793 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 2017   grade_6 2.0 36.0 62.0         1.0         57.0 44.0     *       78     30   101 2 36 62         1         57 44         78   30   101
946812 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605664 320900010323 BRONX WRITING ACADEMY public Regular School No Middle 06 08 2017   grade_6 6.0 55.0 81.0   2.0     0.0     1.0   66.0 79.0     *       *     35   145 6 55 81   2     0     1   66 79             35   145
947021 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606345 320900010568 YOUNG WOMEN'S LDSHP SCHOOL-BRONX public Regular School No Other 06 12 2017   grade_6 1.0 25.0 59.0   1.0     1.0     1.0     88.0     *       80     15   88 1 25 59   1     1     1     88         80   15   88
947059 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605670 320900011231 EAGLE ACADEMY FOR YOUNG MEN public Regular School No Other 06 12 2017   grade_6 0.0 42.0 24.0   1.0     1.0     1.0   69.0       *       65     21   69 0 42 24   1     1     1   69           65   21   69
947249 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_6   5.0 10.0   1.0     0.0         6.0 10.0     *       *     *   16   5 10   1     0         6 10                 16
947477 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_6 0.0 53.0 22.0   1.0     1.0     0.0   37.0 40.0     *       51     11   77 0 53 22   1     1     0   37 40         51   11   77
947553 NY Bronx   school 3601025 320900860962   METROPOLITAN LIGHTHOUSE CHAR 360102506233 320900860962 METROPOLITAN LIGHTHOUSE CHARTER SCH charter Regular School Yes Elementary KG 08 2017   grade_6 1.0 26.0 25.0   0.0     0.0     0.0   23.0 29.0     *       45     6   52 1 26 25   0     0     0   23 29         45   6   52
947610 NY Bronx   school 3601069 320900861029   ICAHN CHARTER SCHOOL 6 360106906355 320900861029 ICAHN CHARTER SCHOOL 6 charter Regular School Yes Elementary KG 06 2017   grade_6 0.0 25.0 17.0   0.0     0.0     0.0   13.0 29.0     *       36     6   42 0 25 17   0     0     0   13 29         36   6   42
947667 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 2017   grade_6 0.0 8.0 17.0   0.0     0.0         9.0 16.0     *       *     6   25 0 8 17   0     0         9 16             6   25
947857 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701304 321000010037 PS 37 MULTIPLE INTELLIGENCE SCHOOL public Regular School No Elementary KG 08 2017   grade_6 0.0 10.0 24.0   2.0     0.0     0.0   22.0 14.0     *       22     10   36 0 10 24   2     0     0   22 14         22   10   36
948009 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702316 321000010080 JHS 80 MOSHOLU PARKWAY (THE) public Regular School No Middle 06 08 2017   grade_6 11.0 28.0 139.0   2.0     21.0     0.0   119.0 82.0     *       *     54   201 11 28 139   2     21     0   119 82             54   201
948142 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702440 321000010118 JHS 118 WILLIAM W NILES public Regular School No Middle 06 08 2017   grade_6 7.0 77.0 213.0   1.0     61.0     1.0   179.0 181.0     *       337     77   360 7 77 213   1     61     1   179 181         337   77   360
948313 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705798 321000010244 NEW SCHOOL-LEADERSHIP & JOURNAL public Regular School No Middle 06 08 2017   grade_6 5.0 22.0 149.0   1.0     9.0     0.0   96.0 90.0     *       *     *   186 5 22 149   1     9     0   96 90                 186
948351 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703794 321000010254 IS 254 public Regular School No Middle 06 08 2017   grade_6 2.0 31.0 105.0   0.0     3.0     1.0   79.0 63.0     *       114     40   142 2 31 105   0     3     1   79 63         114   40   142
948465 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705569 321000010308 BRONX DANCE ACADEMY SCHOOL public Regular School No Middle 06 08 2017   grade_6 0.0 20.0 76.0         3.0     1.0   21.0 79.0     *       94     28   100 0 20 76         3     1   21 79         94   28   100
950004 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805801 321100010289 YOUNG SCHOLARS ACADEMY-BRONX public Regular School No Middle 06 08 2017   grade_6 1.0 73.0 28.0   3.0     4.0         57.0 52.0     *       101     44   109 1 73 28   3     4         57 52         101   44   109
950042 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806399 321100010355 BRONX ALLIANCE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 1.0 52.0 38.0   0.0     3.0         40.0 54.0     *       85     *   94 1 52 38   0     3         40 54         85       94
950099 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806107 321100010462 CORNERSTONE ACAD-SOCIAL ACTION-MS public Regular School No Middle 06 08 2017   grade_6 3.0 52.0 29.0   1.0     0.0         47.0 38.0     *       78     29   85 3 52 29   1     0         47 38         78   29   85
950156 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806559 321100010483 MATILDA AVENUE SCHOOL (THE) public Regular School No Elementary KG 05 2017   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
950213 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806249 321100010532 BAYCHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 0.0 64.0 34.0   0.0     2.0     0.0   53.0 47.0     *       84     22   100 0 64 34   0     2     0   53 47         84   22   100
950631 NY Bronx   school 3600113 321100860859   BRONX CHARTER SCH-EXCELLENCE 360011305688 321100860859 BRONX CHARTER SCH-EXCELLENCE charter Regular School Yes Elementary KG 08 2017   grade_6 0.0 43.0 27.0   0.0     19.0     0.0   43.0 46.0     *       62     8   89 0 43 27   0     19     0   43 46         62   8   89
950650 NY Bronx   school 3600943 321100860909   ICAHN CHARTER SCHOOL 2 360094305973 321100860909 ICAHN CHARTER SCHOOL 2 charter Regular School Yes Elementary KG 08 2017   grade_6 0.0 14.0 21.0   0.0     1.0     0.0   19.0 17.0     *       29     7   36 0 14 21   0     1     0   19 17         29   7   36
950669 NY Bronx   school 3600955 321100860917   ICAHN CHARTER SCHOOL 3 360095506027 321100860917 ICAHN CHARTER SCHOOL 3 charter Regular School Yes Elementary KG 08 2017   grade_6 0.0 21.0 11.0   0.0     0.0     0.0   16.0 16.0     *       31     6   32 0 21 11   0     0     0   16 16         31   6   32
950688 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2017   grade_6 1.0 15.0 14.0   0.0     1.0     0.0   18.0 13.0     *       21     *   31 1 15 14   0     1     0   18 13         21       31
950707 NY Bronx   school 3601005 321100860956   EQUALITY CHARTER SCHOOL 360100506110 321100860956 EQUALITY CHARTER SCHOOL charter Regular School Yes Other 06 11 2017   grade_6 4.0 55.0 25.0   0.0     4.0     0.0   41.0 47.0     *       38     21   88 4 55 25   0     4     0   41 47         38   21   88
950726 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 07 2017   grade_6 3.0 12.0 15.0         2.0     0.0   14.0 18.0     *       17     *   32 3 12 15         2     0   14 18         17       32
951011 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005166 321200010190 ESMT-IS 190 public Regular School No Middle 06 08 2017   grade_6 1.0 30.0 59.0   0.0     0.0         50.0 40.0     *       80     26   90 1 30 59   0     0         50 40         80   26   90
951315 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006002 321200010383 EMOLIOR ACADEMY public Regular School No Middle 06 08 2017   grade_6 2.0 17.0 58.0   3.0     1.0         45.0 36.0     *       74     *   81 2 17 58   3     1         45 36         74       81
951733 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_6 1.0 17.0 30.0   0.0     0.0     0.0   26.0 22.0     *       45     9   48 1 17 30   0     0     0   26 22         45   9   48
951828 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
952094 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001119 30501040003 HARPURSVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   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
952113 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
952132 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838004570 30601060004 F P DONNELLY SCHOOL public Regular School No Elementary KG 05 2017   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
952170 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2017   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
952208 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   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
952246 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 99.0 3.0 5.0   1.0     0.0     5.0   62.0 51.0     *       42     22   113 99 3 5   1     0     5   62 51         42   22   113
952303 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 151.0 5.0 3.0   3.0     1.0     5.0   87.0 81.0     *       63     40   168 151 5 3   3     1     5   87 81         63   40   168
952322 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001630 31101060006 MAINE-ENDWELL SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   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
952360 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   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
952455 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 199.0 28.0 22.0         9.0     29.0   136.0 151.0     *       158     41   287 199 28 22         9     29   136 151         158   41   287
952702 NY Broome   school 3629610 31601060000   VESTAL 362961003985 31601060041 VESTAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 198.0 6.0 14.0   0.0     24.0     6.0   127.0 121.0     *       64     36   248 198 6 14   0     24     6   127 121         64   36   248
952740 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
952778 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2017   grade_6 119.0 5.0 3.0         1.0     5.0   67.0 66.0     *       72     27   133 119 5 3         1     5   67 66         72   27   133
952854 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2017   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
952911 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   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
953082 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Elementary 04 08 2017   grade_6 126.0 18.0 3.0   1.0     3.0     15.0   92.0 74.0     *       107     27   166 126 18 3   1     3     15   92 74         107   27   166
953253 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2017   grade_6 3.0 1.0 2.0   0.0     0.0     1.0   5.0 2.0     *       *     7   7 3 1 2   0     0     1   5 2             7   7
953272 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   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
953291 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   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
953310 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA ELEMENTARY SCHOOL public Regular School No Elementary 04 07 2017   grade_6 48.0 1.0 6.0   31.0     1.0     2.0   51.0 38.0     *       67     8   89 48 1 6   31     1     2   51 38         67   8   89
953367 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   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
953386 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   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
953481 NY Cayuga   school 3603480 50100010000   AUBURN 360348000109 50100010008 WILLIAM H SEWARD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_6 58.0 3.0 3.0         2.0     3.0   31.0 38.0     *       27     5   69 58 3 3         2     3   31 38         27   5   69
953500 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   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
953652 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757004789 50701040007 SOUTHERN CAYUGA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_6 38.0   3.0   0.0     1.0     2.0   24.0 20.0     *       25     11   44 38   3   0     1     2   24 20         25   11   44
953747 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary 04 05 2017   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
953766 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003936 51901040003 CAYUGA ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2017   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
953785 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003937 51901040005 UNION SPRINGS HIGH SCHOOL public Regular School No High 09 12 2017   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
953880 NY Chautauqua   school 3611610 60301040000   FREWSBURG 361161000918 60301040002 ROBERT H JACKSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_6 60.0 0.0 0.0   1.0     2.0     0.0   35.0 28.0     *       25     7   63 60 0 0   1     2     0   35 28         25   7   63
953994 NY Chautauqua   school 3623070 60601040000   PINE VALLEY 362307003233 60601040002 PINE VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_6 38.0 0.0 2.0   0.0           3.0   21.0 22.0     *       24     6   43 38 0 2   0           3   21 22         24   6   43

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