Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_4 · 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
942041 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2017   grade_4 27.0 7.0 5.0   1.0     2.0     3.0   24.0 21.0     *       12     *   45 27 7 5   1     2     3   24 21         12       45
942155 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4 24.0 13.0 8.0   1.0     3.0     5.0   30.0 24.0     *       26     9   54 24 13 8   1     3     5   30 24         26   9   54
942250 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4 5.0 30.0 7.0   0.0     1.0     4.0   29.0 18.0     *       41     13   47 5 30 7   0     1     4   29 18         41   13   47
942402 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_4 1.0 62.0 6.0   0.0     0.0         31.0 38.0     *       57         69 1 62 6   0     0         31 38         57       69
942535 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 43.0 0.0 0.0         7.0     0.0   24.0 26.0     *       6     *   50 43 0 0         7     0   24 26         6       50
942649 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
942668 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2017   grade_4 55.0 0.0 10.0         0.0     4.0   33.0 36.0     *       30     14   69 55 0 10         0     4   33 36         30   14   69
942763 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
942801 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   grade_4 59.0 5.0 2.0         1.0     9.0   36.0 40.0     *       50     13   76 59 5 2         1     9   36 40         50   13   76
942972 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_4 8.0 4.0 2.0   1.0     15.0     1.0   16.0 15.0     *       *     *   31 8 4 2   1     15     1   16 15                 31
942991 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2017   grade_4 43.0 4.0 0.0         12.0     2.0   33.0 28.0     *       13     16   61 43 4 0         12     2   33 28         13   16   61
943010 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   grade_4 45.0 2.0 7.0   1.0     19.0     5.0   43.0 36.0     *       13     7   79 45 2 7   1     19     5   43 36         13   7   79
943029 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2017   grade_4 45.0 1.0 3.0         10.0     5.0   34.0 30.0     *       15     6   64 45 1 3         10     5   34 30         15   6   64
943048 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2017   grade_4 55.0 1.0 1.0   0.0     8.0     2.0   32.0 35.0     *       16     *   67 55 1 1   0     8     2   32 35         16       67
943086 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_4 33.0 3.0 2.0   0.0     7.0     3.0   28.0 20.0     *       8     7   48 33 3 2   0     7     3   28 20         8   7   48
943143 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_4 23.0 1.0 3.0         1.0     1.0   11.0 18.0     *       22     *   29 23 1 3         1     1   11 18         22       29
943162 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 48.0 2.0 3.0         1.0     2.0   31.0 25.0     *       21     5   56 48 2 3         1     2   31 25         21   5   56
943181 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 64.0 3.0 4.0         13.0     3.0   38.0 49.0     *       17     14   87 64 3 4         13     3   38 49         17   14   87
943238 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 53.0 1.0 4.0   0.0     5.0     4.0   33.0 34.0     *       11     9   67 53 1 4   0     5     4   33 34         11   9   67
943295 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 101.0 1.0 3.0         1.0     2.0   59.0 49.0     *       13     13   108 101 1 3         1     2   59 49         13   13   108
943314 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
943561 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
943599 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
943656 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_4 77.0 1.0 4.0   0.0     0.0     0.0   37.0 45.0     *       57     9   82 77 1 4   0     0     0   37 45         57   9   82
943846 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2017   grade_4 0.0 20.0 53.0   0.0     1.0         35.0 39.0     *       73     16   74 0 20 53   0     1         35 39         73   16   74
943865 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2017   grade_4 0.0 21.0 60.0   0.0     0.0     1.0   49.0 33.0     *       81     30   82 0 21 60   0     0     1   49 33         81   30   82
944131 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406382 320700010359 CONCOURSE VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_4 1.0 15.0 23.0   0.0     0.0     0.0   21.0 18.0     *       38     9   39 1 15 23   0     0     0   21 18         38   9   39
944530 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_4 2.0 36.0 48.0   0.0     0.0     2.0   45.0 43.0     *       83     21   88 2 36 48   0     0     2   45 43         83   21   88
944587 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BGLIG-SHIRLEY RODRIGUEZ-REMENESKI CS charter Regular School Yes Elementary KG 08 2017   grade_4 0.0 10.0 35.0   1.0     0.0     1.0     47.0     *       38     10   47 0 10 35   1     0     1     47         38   10   47
944625 NY Bronx   school 3600960 320700860925   MOTT HAVEN ACADEMY CHARTER S 360096006013 320700860925 MOTT HAVEN ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary PK 05 2017   grade_4 0.0 14.0 36.0   0.0     0.0     0.0   20.0 30.0     *       50     12   50 0 14 36   0     0     0   20 30         50   12   50
944663 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2017   grade_4 0.0 24.0 28.0   0.0     1.0     1.0   24.0 30.0     *       51     7   54 0 24 28   0     1     1   24 30         51   7   54
944682 NY Bronx   school 3601011 320700860981   SUCCESS ACADEMY-BRONX 1 360101106211 320700860981 SUCCESS ACADEMY CHARTER-BRONX 1 charter Regular School Yes Elementary KG 07 2017   grade_4 1.0 42.0 39.0   2.0     1.0     1.0   48.0 38.0     *       75     9   86 1 42 39   2     1     1   48 38         75   9   86
944758 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes Elementary KG 05 2017   grade_4 0.0 20.0 44.0         1.0     0.0   28.0 37.0     *       59     7   65 0 20 44         1     0   28 37         59   7   65
944891 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502085 320800010014 PS 14 SENATOR JOHN CALANDRA public Regular School No Elementary KG 05 2017   grade_4 19.0 5.0 63.0   0.0     6.0     1.0   45.0 49.0     *       55     20   94 19 5 63   0     6     1   45 49         55   20   94
945024 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502302 320800010075 PS 75 SCHOOL OF RESEARCH-DISCOVERY public Regular School No Elementary PK 05 2017   grade_4 3.0 23.0 63.0   0.0     1.0     0.0   50.0 40.0     *       68     23   90 3 23 63   0     1     0   50 40         68   23   90
945252 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502530 320800010146 PS 146 EDWARD COLLINS public Regular School No Elementary PK 05 2017   grade_4 0.0 22.0 27.0   0.0     0.0     0.0   23.0 26.0     *       46     15   49 0 22 27   0     0     0   23 26         46   15   49
945290 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502632 320800010182 PS 182 public Regular School No Elementary PK 05 2017   grade_4 1.0 44.0 108.0   0.0     15.0     0.0   86.0 82.0     *       141     42   168 1 44 108   0     15     0   86 82         141   42   168
945347 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_4 21.0 5.0 53.0   0.0     6.0     1.0   41.0 45.0     *       63     19   86 21 5 53   0     6     1   41 45         63   19   86
945404 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505656 320800010335 ACADEMY OF THE ARTS (THE) public Regular School No Elementary PK 05 2017   grade_4 0.0 7.0 19.0   0.0           0.0   14.0 12.0     *       23     10   26 0 7 19   0           0   14 12         23   10   26
945879 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_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
945955 NY Bronx   school 3600063 320800860846   BRONX CHARTER SCHOOL-ARTS 360006304875 320800860846 BRONX CHARTER SCHOOL FOR THE ARTS charter Regular School Yes Elementary KG 06 2017   grade_4 1.0 14.0 36.0   2.0     1.0     0.0   21.0 33.0     *       38     6   54 1 14 36   2     1     0   21 33         38   6   54
945974 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_4 1.0 19.0 31.0   0.0     3.0     0.0   24.0 30.0     *       50     8   54 1 19 31   0     3     0   24 30         50   8   54
946012 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_4 0.0 25.0 51.0   0.0     0.0     0.0   0.0 76.0     *       61     11   76 0 25 51   0     0     0   0 76         61   11   76
946069 NY Bronx   school 3601091 320800861030   ICAHN CHARTER SCHOOL 7 360109106389 320800861030 ICAHN CHARTER SCHOOL 7 charter Regular School Yes Elementary KG 05 2017   grade_4 1.0 15.0 11.0   0.0     1.0     0.0   16.0 12.0     *       19     0   28 1 15 11   0     1     0   16 12         19   0   28
946696 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602751 320900010236 PS 236 LANGSTON HUGHES public Regular School No Elementary PK 05 2017   grade_4 1.0 6.0 18.0   0.0     0.0     0.0   9.0 16.0     *       24     12   25 1 6 18   0     0     0   9 16         24   12   25
947475 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_4 0.0 52.0 25.0   0.0     0.0     0.0   34.0 43.0     *       50     12   77 0 52 25   0     0     0   34 43         50   12   77
947494 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2017   grade_4 0.0 16.0 17.0   0.0     0.0         13.0 20.0     *       31     *   33 0 16 17   0     0         13 20         31       33
947570 NY Bronx   school 3601012 320900860980   SUCCESS ACADEMY -BRONX 2 360101206219 320900860980 SUCCESS ACADEMY CHARTER-BRONX 2 charter Regular School Yes Elementary KG 07 2017   grade_4 2.0 70.0 28.0   1.0     0.0     0.0   57.0 44.0     *       70     21   101 2 70 28   1     0     0   57 44         70   21   101
947665 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_4 1.0 13.0 23.0   0.0     0.0         17.0 20.0     *       37     11   37 1 13 23   0     0         17 20         37   11   37
947779 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700130 321000010023 PS 23 NEW CHILDREN'S SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_4 1.0 30.0 53.0   0.0     0.0     0.0   52.0 32.0     *       74     24   84 1 30 53   0     0     0   52 32         74   24   84
947798 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No Elementary KG 05 2017   grade_4 63.0 10.0 62.0   1.0     13.0     6.0   75.0 80.0     *       45     26   155 63 10 62   1     13     6   75 80         45   26   155
947912 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700127 321000010051 PS 51 BRONX NEW SCHOOL public Regular School No Elementary PK 05 2017   grade_4 1.0 14.0 13.0   0.0     1.0         18.0 11.0     *       25     5   29 1 14 13   0     1         18 11         25   5   29
948064 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No Elementary PK 06 2017   grade_4 4.0 17.0 180.0   0.0     7.0     0.0   96.0 112.0     *       158     53   208 4 17 180   0     7     0   96 112         158   53   208
948159 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704353 321000010159 PS 159 LUIS MUNOZ MARIN BILING public Regular School No Elementary KG 05 2017   grade_4 1.0 0.0 20.0   0.0               10.0 11.0     *       17     *   21 1 0 20   0               10 11         17       21
948558 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705993 321000010344 AMPARK NEIGHBORHOOD public Regular School No Elementary KG 05 2017   grade_4 12.0 14.0 46.0   0.0     5.0     1.0   40.0 38.0     *       39     10   78 12 14 46   0     5     1   40 38         39   10   78
948577 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703805 321000010360 PS 360 public Regular School No Elementary PK 05 2017   grade_4 2.0 8.0 55.0         0.0     0.0   35.0 30.0     *       57     15   65 2 8 55         0     0   35 30         57   15   65
948634 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706057 321000010382 ELEM SCHOOL FOR MATH, SCIENCE, TECH public Regular School No Elementary PK 05 2017   grade_4 1.0 8.0 30.0   0.0     0.0         19.0 20.0     *       *     *   39 1 8 30   0     0         19 20                 39
948653 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706015 321000010386 SCHOOL FOR ENVIRONMENTAL CITIZENSHIP public Regular School No Elementary PK 05 2017   grade_4 0.0 9.0 58.0   0.0     2.0         37.0 32.0     *       69     11   69 0 9 58   0     2         37 32         69   11   69
949413 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802092 321100010016 PS 16 WAKEFIELD public Regular School No Elementary PK 05 2017   grade_4 1.0 38.0 18.0   9.0     3.0     0.0   36.0 33.0     *       66     23   69 1 38 18   9     3     0   36 33         66   23   69
949451 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802111 321100010021 PS 21 PHILIP H SHERIDAN public Regular School No Elementary KG 05 2017   grade_4 0.0 78.0 29.0   1.0     1.0     1.0   67.0 43.0     *       90     28   110 0 78 29   1     1     1   67 43         90   28   110
949489 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802282 321100010068 PS 68 public Regular School No Elementary PK 05 2017   grade_4 1.0 93.0 25.0   1.0     2.0     1.0   59.0 64.0     *       69     26   123 1 93 25   1     2     1   59 64         69   26   123
949565 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802336 321100010087 PS 87 public Regular School No Elementary KG 05 2017   grade_4 1.0 69.0 16.0   4.0     10.0     4.0   60.0 44.0     *       88     26   104 1 69 16   4     10     4   60 44         88   26   104
949736 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802419 321100010112 PS 112 BRONXWOOD public Regular School No Elementary PK 05 2017   grade_4 0.0 22.0 30.0         1.0     0.0   28.0 25.0     *       51     11   53 0 22 30         1     0   28 25         51   11   53
949812 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802553 321100010153 PS 153 HELEN KELLER public Regular School No Elementary PK 05 2017   grade_4 8.0 65.0 36.0   4.0     9.0     2.0   64.0 60.0     *       80     17   124 8 65 36   4     9     2   64 60         80   17   124
949831 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802573 321100010160 PS 160 WALT DISNEY public Regular School No Elementary PK 05 2017   grade_4 2.0 33.0 13.0   0.0     4.0     2.0   26.0 28.0     *       40     16   54 2 33 13   0     4     2   26 28         40   16   54
949850 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806144 321100010169 BAYCHESTER ACADEMY public Regular School No Elementary PK 05 2017   grade_4 0.0 47.0 14.0   2.0     0.0     3.0   24.0 42.0     *       54     19   66 0 47 14   2     0     3   24 42         54   19   66
949869 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802613 321100010175 PS 175 CITY ISLAND public Regular School No Elementary KG 08 2017   grade_4 23.0 4.0 16.0   1.0     1.0     1.0   18.0 28.0     *       22     8   46 23 4 16   1     1     1   18 28         22   8   46
949888 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008800158 321100010178 PS 178 DR SELMAN WAKSMAN public Regular School No Elementary KG 05 2017   grade_4 1.0 55.0 30.0   1.0     1.0     2.0   41.0 49.0     *       64     28   90 1 55 30   1     1     2   41 49         64   28   90
949945 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805971 321100010189 CORNERSTONE ACAD FOR SOCIAL ACTION public Regular School No Elementary PK 05 2017   grade_4 3.0 23.0 25.0   1.0     0.0     1.0   28.0 25.0     *       47     14   53 3 23 25   1     0     1   28 25         47   14   53
950097 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_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
950154 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_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
950173 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 2017   grade_4 11.0 6.0 40.0   0.0     4.0     0.0   32.0 29.0     *       51     13   61 11 6 40   0     4     0   32 29         51   13   61
950667 NY Bronx   school 3600955 321100860917   ICAHN CHARTER SCHOOL 3 360095506027 321100860917 ICAHN CHARTER SCHOOL 3 charter Regular School Yes Elementary KG 08 2017   grade_4 1.0 20.0 13.0   1.0     2.0     1.0   17.0 21.0     *       36     6   38 1 20 13   1     2     1   17 21         36   6   38
950686 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2017   grade_4 1.0 22.0 11.0   0.0     0.0     0.0   15.0 19.0     *       21     *   34 1 22 11   0     0     0   15 19         21       34
950724 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 07 2017   grade_4 2.0 17.0 13.0         4.0     0.0   14.0 22.0     *       22     *   36 2 17 13         4     0   14 22         22       36
950895 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002279 321200010067 PS 67 MOHEGAN SCHOOL public Regular School No Elementary PK 05 2017   grade_4 0.0 16.0 63.0   1.0               42.0 38.0     *       72     20   80 0 16 63   1               42 38         72   20   80
951731 NY Bronx   school 3600111 321200860870   BRONX LIGHTHOUSE CHARTER SCH 360011105662 321200860870 BRONX LIGHTHOUSE CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_4 0.0 22.0 25.0   0.0     0.0     0.0   20.0 27.0     *       41     *   47 0 22 25   0     0     0   20 27         41       47
951750 NY Bronx   school 3600161 321200860898   SOUTH BRONX CLASSICAL CHARTE 360016105893 321200860898 SOUTH BRONX CLASSICAL CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_4 2.0 20.0 22.0   1.0     1.0     1.0   20.0 27.0     *       42     *   47 2 20 22   1     1     1   20 27         42       47
951826 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_4 119.0 2.0 1.0   0.0     0.0     2.0   69.0 55.0     *       64     17   124 119 2 1   0     0     2   69 55         64   17   124
952092 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001119 30501040003 HARPURSVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952111 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 53.0 1.0 1.0         0.0     3.0   28.0 30.0     *       32     *   58 53 1 1         0     3   28 30         32       58
952130 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838004570 30601060004 F P DONNELLY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 37.0 0.0 0.0   1.0     0.0     0.0   22.0 16.0     *       20     *   38 37 0 0   1     0     0   22 16         20       38
952168 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952206 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_4 126.0 1.0 3.0   1.0     2.0     9.0   71.0 71.0     *       69     24   142 126 1 3   1     2     9   71 71         69   24   142
952244 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952263 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001627 31101060003 HOMER BRINK SCHOOL public Regular School No Elementary KG 05 2017   grade_4 96.0 2.0 4.0   1.0     3.0     7.0   55.0 58.0     *       46     15   113 96 2 4   1     3     7   55 58         46   15   113
952301 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952320 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001630 31101060006 MAINE-ENDWELL SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952358 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
952396 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000846 31501060001 CHARLES F JOHNSON JR ELEMENTARY SCH public Regular School No Elementary KG 05 2017   grade_4 36.0 11.0 9.0   0.0     3.0     6.0   26.0 39.0     *       52     6   65 36 11 9   0     3     6   26 39         52   6   65
952529 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001376 31502060001 JOHNSON CITY ELEM/INTRMED SCHOOL public Regular School No Elementary 03 05 2017   grade_4 119.0 24.0 29.0         14.0     17.0   78.0 125.0     *       150     21   203 119 24 29         14     17   78 125         150   21   203
952605 NY Broome   school 3629610 31601060000   VESTAL 362961003984 31601060021 AFRICAN ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 25.0 0.0 4.0         10.0     1.0   22.0 18.0     *       *     7   40 25 0 4         10     1   22 18             7   40
952681 NY Broome   school 3629610 31601060000   VESTAL 362961003990 31601060028 VESTAL HILLS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 39.0 1.0 0.0         12.0     3.0   31.0 24.0     *       11     *   55 39 1 0         12     3   31 24         11       55
952738 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_4 42.0 4.0 0.0         0.0     3.0   27.0 22.0     *       26     *   49 42 4 0         0     3   27 22         26       49
952776 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2017   grade_4 34.0 1.0 1.0         0.0     1.0   18.0 19.0     *       22     6   37 34 1 1         0     1   18 19         22   6   37
952852 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2017   grade_4 74.0 1.0 0.0   0.0     1.0     1.0   33.0 44.0     *       26     7   77 74 1 0   0     1     1   33 44         26   7   77
952909 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
953080 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Elementary 04 08 2017   grade_4 116.0 7.0 6.0   1.0     3.0     19.0   90.0 62.0     *       111     *   152 116 7 6   1     3     19   90 62         111       152
953251 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2017   grade_4 3.0 0.0 2.0   0.0     0.0     0.0   5.0 0.0     *       *     5   5 3 0 2   0     0     0   5 0             5   5
953270 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_4 0.0 0.0 0.0   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]);