Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_1 · 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
942035 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2017   grade_1 26.0 11.0 3.0   0.0     4.0     3.0   21.0 26.0     *       15     0   47 26 11 3   0     4     3   21 26         15   0   47
942092 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_1 42.0 19.0 13.0   0.0     5.0     5.0   48.0 36.0     *       30     15   84 42 19 13   0     5     5   48 36         30   15   84
942244 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_1 2.0 33.0 7.0   0.0     3.0     2.0   24.0 23.0     *       34     0   47 2 33 7   0     3     2   24 23         34   0   47
942339 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2017   grade_1 4.0 44.0 7.0         4.0     0.0   59.0       *       54     0   59 4 44 7         4     0   59           54   0   59
942358 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2017   grade_1 1.0 42.0 12.0         1.0     7.0   0.0 63.0     *       56     0   63 1 42 12         1     7   0 63         56   0   63
942396 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_1 0.0 72.0 9.0   1.0     0.0         44.0 38.0     *       76         82 0 72 9   1     0         44 38         76       82
942529 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 52.0 0.0 2.0         4.0     1.0   26.0 33.0     *       8     12   59 52 0 2         4     1   26 33         8   12   59
942567 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 53.0 5.0 3.0         6.0     4.0   45.0 26.0     *       10     *   71 53 5 3         6     4   45 26         10       71
942643 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
942662 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2017   grade_1 57.0 4.0 2.0         0.0     2.0   30.0 35.0     *       23     5   65 57 4 2         0     2   30 35         23   5   65
942681 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2017   grade_1 56.0 2.0 7.0   1.0     0.0     8.0   33.0 41.0     *       34     11   74 56 2 7   1     0     8   33 41         34   11   74
942757 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
942795 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   grade_1 57.0 11.0 5.0         1.0     4.0   46.0 32.0     *       46     13   78 57 11 5         1     4   46 32         46   13   78
943061 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   grade_1 32.0 0.0 2.0   0.0     3.0     3.0   12.0 28.0     *       *     *   40 32 0 2   0     3     3   12 28                 40
943080 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_1 46.0 3.0 4.0   0.0     4.0     1.0   35.0 23.0     *       13     10   58 46 3 4   0     4     1   35 23         13   10   58
943137 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_1 21.0 2.0 0.0         1.0     0.0   7.0 17.0     *       17     *   24 21 2 0         1     0   7 17         17       24
943156 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 42.0 0.0 1.0         1.0     3.0   16.0 31.0     *       17     *   47 42 0 1         1     3   16 31         17       47
943232 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 54.0 0.0 4.0   0.0     4.0     2.0   31.0 33.0     *       11     8   64 54 0 4   0     4     2   31 33         11   8   64
943270 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 50.0 1.0 2.0         8.0     1.0   26.0 36.0     *       7     *   62 50 1 2         8     1   26 36         7       62
943289 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 77.0 0.0 1.0         1.0     2.0   40.0 41.0     *       9     10   81 77 0 1         1     2   40 41         9   10   81
943308 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
943346 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_1 51.0 7.0 20.0         10.0     18.0   58.0 48.0     *       77     13   106 51 7 20         10     18   58 48         77   13   106
943555 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
943593 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
943650 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_1 78.0 1.0 0.0   0.0     0.0     0.0   38.0 41.0     *       49     9   79 78 1 0   0     0     0   38 41         49   9   79
944657 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2017   grade_1 0.0 24.0 32.0   1.0     0.0     0.0   26.0 31.0     *       55     10   57 0 24 32   1     0     0   26 31         55   10   57
944676 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_1 0.0 51.0 35.0   0.0     3.0     0.0   51.0 38.0     *       80     11   89 0 51 35   0     3     0   51 38         80   11   89
944771 NY Bronx   school 3601105 320700861035   SOUTH BRONX CLASSICAL II 360110506385 320700861035 SOUTH BRONX CLASSICAL CHARTER II charter Regular School Yes Elementary KG 04 2017   grade_1 2.0 25.0 29.0   0.0           2.0   32.0 26.0     *       49     *   58 2 25 29   0           2   32 26         49       58
945037 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502354 320800010093 PS 93 ALBERT G OLIVER public Regular School No Elementary PK 05 2017   grade_1 1.0 26.0 17.0   0.0           0.0   23.0 21.0     *       28     15   44 1 26 17   0           0   23 21         28   15   44
945284 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502632 320800010182 PS 182 public Regular School No Elementary PK 05 2017   grade_1 5.0 47.0 96.0   0.0     9.0     2.0   68.0 91.0     *       141     32   159 5 47 96   0     9     2   68 91         141   32   159
945341 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_1 16.0 5.0 48.0   0.0     4.0     3.0   46.0 30.0     *       53     16   76 16 5 48   0     4     3   46 30         53   16   76
945474 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506506 320800010392 BRONX DELTA SCHOOL public Regular School No Elementary PK 05 2017   grade_1 9.0 3.0 36.0         2.0     0.0   26.0 24.0     *       40     *   50 9 3 36         2     0   26 24         40       50
945873 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_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
946006 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_1 1.0 30.0 41.0   1.0     0.0     1.0   0.0 74.0     *       71     10   74 1 30 41   1     0     1   0 74         71   10   74
946063 NY Bronx   school 3601091 320800861030   ICAHN CHARTER SCHOOL 7 360109106389 320800861030 ICAHN CHARTER SCHOOL 7 charter Regular School Yes Elementary KG 05 2017   grade_1 3.0 14.0 19.0   0.0     2.0     1.0   14.0 25.0     *       25     *   39 3 14 19   0     2     1   14 25         25       39
946120 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605191 320900010004 PS/MS 4 CROTONA PARK WEST public Regular School No Elementary PK 08 2017   grade_1 1.0 34.0 24.0   0.0     0.0         29.0 30.0     *       56     9   59 1 34 24   0     0         29 30         56   9   59
946177 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602133 320900010028 PS 28 MOUNT HOPE public Regular School No Elementary PK 05 2017   grade_1 1.0 19.0 72.0         0.0     0.0   53.0 39.0     *       90     *   92 1 19 72         0     0   53 39         90       92
946310 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602288 320900010070 PS 70 MAX SCHOENFELD public Regular School No Elementary KG 05 2017   grade_1 1.0 69.0 143.0   1.0     1.0     0.0   118.0 97.0     *       205     48   215 1 69 143   1     1     0   118 97         205   48   215
947488 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2017   grade_1 0.0 17.0 25.0   0.0     0.0         23.0 19.0     *       39     5   42 0 17 25   0     0         23 19         39   5   42
947621 NY Bronx   school 3601129 320900861073   ROSALYN YALOW CHARTER SCHOOL 360112906566 320900861073 ROSALYN YALOW CHARTER SCHOOL charter Regular School Yes Elementary KG 02 2017   grade_1 1.0 34.0 74.0   1.0     0.0     0.0   57.0 53.0     *       103     11   110 1 34 74   1     0     0   57 53         103   11   110
947792 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_1 65.0 17.0 66.0   1.0     18.0     9.0   99.0 77.0     *       47     *   176 65 17 66   1     18     9   99 77         47       176
947830 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702155 321000010033 PS 33 TIMOTHY DWIGHT public Regular School No Elementary PK 05 2017   grade_1 1.0 23.0 124.0   1.0     3.0     1.0   79.0 74.0     *       119     37   153 1 23 124   1     3     1   79 74         119   37   153
948476 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702210 321000010310 PS 310 MARBLE HILL public Regular School No Elementary PK 05 2017   grade_1 3.0 11.0 98.0   0.0     0.0     1.0   46.0 67.0     *       110     23   113 3 11 98   0     0     1   46 67         110   23   113
948552 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705993 321000010344 AMPARK NEIGHBORHOOD public Regular School No Elementary KG 05 2017   grade_1 10.0 8.0 40.0   1.0     4.0     2.0   34.0 31.0     *       30     19   65 10 8 40   1     4     2   34 31         30   19   65
949426 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802100 321100010019 PS 19 JUDITH K WEISS public Regular School No Elementary KG 08 2017   grade_1 40.0 6.0 8.0   0.0     1.0     2.0   28.0 29.0     *       29     6   57 40 6 8   0     1     2   28 29         29   6   57
949483 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802282 321100010068 PS 68 public Regular School No Elementary PK 05 2017   grade_1 3.0 85.0 24.0   1.0     2.0     0.0   56.0 59.0     *       68     28   115 3 85 24   1     2     0   56 59         68   28   115
949521 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802312 321100010078 PS 78 ANNE HUTCHINSON public Regular School No Elementary PK 05 2017   grade_1 1.0 88.0 29.0   3.0     2.0     1.0   67.0 57.0     *       113     24   124 1 88 29   3     2     1   67 57         113   24   124
949559 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802336 321100010087 PS 87 public Regular School No Elementary KG 05 2017   grade_1 0.0 71.0 15.0   2.0     4.0     2.0   51.0 43.0     *       85     16   94 0 71 15   2     4     2   51 43         85   16   94
949730 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802419 321100010112 PS 112 BRONXWOOD public Regular School No Elementary PK 05 2017   grade_1 2.0 33.0 24.0         0.0     0.0   27.0 32.0     *       58     13   59 2 33 24         0     0   27 32         58   13   59
949806 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_1 5.0 60.0 26.0   0.0     13.0     1.0   50.0 55.0     *       70     10   105 5 60 26   0     13     1   50 55         70   10   105
949844 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806144 321100010169 BAYCHESTER ACADEMY public Regular School No Elementary PK 05 2017   grade_1 1.0 44.0 11.0   1.0     1.0     0.0   32.0 26.0     *       52     9   58 1 44 11   1     1     0   32 26         52   9   58
949863 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_1 18.0 3.0 18.0   0.0     1.0     1.0   18.0 23.0     *       21     9   41 18 3 18   0     1     1   18 23         21   9   41
949882 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_1 1.0 45.0 26.0   0.0     1.0     0.0   38.0 35.0     *       59     17   73 1 45 26   0     1     0   38 35         59   17   73
949939 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_1 1.0 29.0 25.0   1.0     1.0     2.0   35.0 24.0     *       57     10   59 1 29 25   1     1     2   35 24         57   10   59
950091 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_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
950148 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_1 4.0 16.0 10.0   1.0     0.0     1.0   23.0 9.0     *       29     *   32 4 16 10   1     0     1   23 9         29       32
950604 NY Bronx   school 3600089 321100860855   BRONX CHARTER SCH BETTER LEA 360008905554 321100860855 BRONX CHARTER SCH BETTER LEARNING charter Regular School Yes Elementary PK 05 2017   grade_1 2.0 89.0 9.0   0.0     1.0     0.0   46.0 55.0     *       85     *   101 2 89 9   0     1     0   46 55         85       101
950661 NY Bronx   school 3600955 321100860917   ICAHN CHARTER SCHOOL 3 360095506027 321100860917 ICAHN CHARTER SCHOOL 3 charter Regular School Yes Elementary KG 08 2017   grade_1 2.0 20.0 13.0   0.0     4.0     0.0   21.0 18.0     *       35     *   39 2 20 13   0     4     0   21 18         35       39
950680 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2017   grade_1 1.0 20.0 18.0   0.0     2.0     0.0   16.0 25.0     *       35     *   41 1 20 18   0     2     0   16 25         35       41
950718 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 07 2017   grade_1 1.0 23.0 12.0         0.0     0.0   23.0 13.0     *       23     *   36 1 23 12         0     0   23 13         23       36
950737 NY Bronx   school 3601127 321100861076   BRONX CHARTER SCHOOL-BETTER 360112706551 321100861076 BRONX CHARTER-BETTER LEARNING II charter Regular School Yes Elementary KG 01 2017   grade_1 0.0 60.0 11.0         1.0         34.0 38.0     *       56     8   72 0 60 11         1         34 38         56   8   72
950775 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002059 321200010006 PS 6 WEST FARMS public Regular School No Elementary PK 05 2017   grade_1 2.0 20.0 78.0         2.0     1.0   47.0 56.0     *       100     21   103 2 20 78         2     1   47 56         100   21   103
950851 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002260 321200010061 PS 61 FRANCISCO OLLER public Regular School No Elementary PK 05 2017   grade_1 0.0 3.0 36.0   0.0     0.0         20.0 19.0     *       39     10   39 0 3 36   0     0         20 19         39   10   39
950908 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002350 321200010092 PS 92 public Regular School No Elementary PK 05 2017   grade_1 2.0 17.0 42.0   1.0     0.0     0.0   29.0 33.0     *       56     9   62 2 17 42   1     0     0   29 33         56   9   62
951060 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002706 321200010211 PS 211 public Regular School No Elementary PK 08 2017   grade_1 0.0 9.0 44.0         0.0     1.0   25.0 29.0     *       50     10   54 0 9 44         0     1   25 29         50   10   54
951801 NY Bronx   school 3601066 321200861026   CHILDREN'S AID COLLEGE PREP 360106606303 321200861026 CHILDREN'S AID COLLEGE PREP CHARTER charter Regular School Yes Elementary KG 05 2017   grade_1 1.0 32.0 28.0   1.0     1.0     0.0   30.0 33.0     *       *     13   63 1 32 28   1     1     0   30 33             13   63
951820 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_1 97.0 0.0 1.0   0.0     0.0     1.0   50.0 49.0     *       41     *   99 97 0 1   0     0     1   50 49         41       99
951972 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000235 30200010014 WOODROW WILSON SCHOOL public Regular School No Elementary KG 05 2017   grade_1 39.0 15.0 9.0         0.0     12.0   38.0 37.0     *       70     15   75 39 15 9         0     12   38 37         70   15   75
952086 NY Broome   school 3613710 30501040000   HARPURSVILLE 361371001119 30501040003 HARPURSVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952105 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 55.0 2.0 0.0         0.0     3.0   30.0 30.0     *       30     *   60 55 2 0         0     3   30 30         30       60
952124 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838004570 30601060004 F P DONNELLY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 46.0 0.0 0.0   0.0     0.0     1.0   21.0 26.0     *       28     *   47 46 0 0   0     0     1   21 26         28       47
952162 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952200 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952219 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_1 100.0 1.0 4.0   0.0     1.0     9.0   62.0 53.0     *       54     9   115 100 1 4   0     1     9   62 53         54   9   115
952238 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729004924 30701060005 CHENANGO VALLEY MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952257 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001627 31101060003 HOMER BRINK SCHOOL public Regular School No Elementary KG 05 2017   grade_1 72.0 6.0 6.0   0.0     0.0     10.0   50.0 44.0     *       41     6   94 72 6 6   0     0     10   50 44         41   6   94
952295 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001629 31101060005 MAINE-ENDWELL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952314 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001630 31101060006 MAINE-ENDWELL SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
952352 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
952390 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000846 31501060001 CHARLES F JOHNSON JR ELEMENTARY SCH public Regular School No Elementary KG 05 2017   grade_1 37.0 16.0 9.0   1.0     2.0     9.0   38.0 36.0     *       65     7   74 37 16 9   1     2     9   38 36         65   7   74
952675 NY Broome   school 3629610 31601060000   VESTAL 362961003990 31601060028 VESTAL HILLS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 32.0 1.0 2.0         11.0     2.0   20.0 28.0     *       8     *   48 32 1 2         11     2   20 28         8       48
952732 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_1 37.0 0.0 1.0         0.0     1.0   19.0 20.0     *       21     *   39 37 0 1         0     1   19 20         21       39
952770 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2017   grade_1 24.0 0.0 1.0         0.0     0.0   10.0 15.0     *       12     *   25 24 0 1         0     0   10 15         12       25
952846 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2017   grade_1 78.0 1.0 1.0   1.0     0.0     5.0   43.0 43.0     *       38     10   86 78 1 1   1     0     5   43 43         38   10   86
952903 NY Cattaraugus   school 3611490 41101040000   FRANKLINVILLE 361149000905 41101040002 FRANKLINVILLE JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
953036 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2017   grade_1 77.0 1.0 4.0   0.0     3.0     6.0   47.0 44.0     *       59     15   91 77 1 4   0     3     6   47 44         59   15   91
953074 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Elementary 04 08 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
953245 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     1.0   0.0 1.0     *       *     *   1 0 0 0   0     0     1   0 1                 1
953264 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
953283 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_1 54.0 3.0 8.0   28.0     0.0     8.0   61.0 40.0     *       71     15   101 54 3 8   28     0     8   61 40         71   15   101
953302 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA ELEMENTARY SCHOOL public Regular School No Elementary 04 07 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
953359 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_1 75.0 1.0 0.0         0.0     0.0   38.0 38.0     *       50     12   76 75 1 0         0     0   38 38         50   12   76
953378 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
953473 NY Cayuga   school 3603480 50100010000   AUBURN 360348000109 50100010008 WILLIAM H SEWARD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_1 53.0 3.0 1.0         3.0     8.0   41.0 27.0     *       35     7   68 53 3 1         3     8   41 27         35   7   68
953492 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
953644 NY Cayuga   school 3627570 50701040000   SOUTHERN CAYUGA 362757004789 50701040007 SOUTHERN CAYUGA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_1 45.0   7.0   0.0     0.0     1.0   28.0 25.0     *       25     *   53 45   7   0     0     1   28 25         25       53
953739 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary 04 05 2017   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
953758 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003936 51901040003 CAYUGA ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2017   grade_1 54.0 0.0 2.0         1.0     2.0   35.0 24.0     *       23     5   59 54 0 2         1     2   35 24         23   5   59
953777 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003937 51901040005 UNION SPRINGS HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
953853 NY Chautauqua   school 3627660 60201060000   SOUTHWESTERN 362766004936 60201060007 SOUTHWESTERN ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_1 85.0 0.0 7.0   1.0     2.0     5.0   45.0 55.0     *       47     *   100 85 0 7   1     2     5   45 55         47       100

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