Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_4 · 4,719
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int ▼ homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2139099 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_4 22.0 7.0 6.0         7.0     3.0   30.0 15.0     *       11     *   45 22 7 6         7     3   30 15         11       45
2139156 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 34.0 23.0 8.0   0.0     3.0     7.0   45.0 30.0     *       37     16   75 34 23 8   0     3     7   45 30         37   16   75
2139194 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_4 10.0 33.0 21.0   0.0     2.0     5.0   33.0 38.0     *       46     11   71 10 33 21   0     2     5   33 38         46   11   71
2139308 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 5.0 33.0 4.0         0.0     6.0   25.0 23.0     *       44     13   48 5 33 4         0     6   25 23         44   13   48
2139346 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   grade_4 3.0 28.0 12.0   0.0     1.0     5.0   23.0 26.0     *       46     *   49 3 28 12   0     1     5   23 26         46       49
2139403 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2019   grade_4 1.0 43.0 10.0         0.0     1.0   55.0 0.0     *       52     *   55 1 43 10         0     1   55 0         52       55
2139422 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2019   grade_4 3.0 27.0 15.0         5.0     0.0     50.0     *       45     0   50 3 27 15         5     0     50         45   0   50
2139460 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_4 1.0 48.0 5.0               0.0   25.0 29.0     *       50     *   54 1 48 5               0   25 29         50       54
2139631 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 70.0 0.0 1.0         6.0     1.0   37.0 41.0     *       14     10   78 70 0 1         6     1   37 41         14   10   78
2139688 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 66.0 0.0 5.0   0.0     5.0     0.0   38.0 38.0     *       16     10   76 66 0 5   0     5     0   38 38         16   10   76
2139745 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_4 40.0 0.0 8.0   0.0     0.0     8.0   30.0 26.0     *       26     5   56 40 0 8   0     0     8   30 26         26   5   56
2139821 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   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
2139840 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2139859 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2019   grade_4 39.0 3.0 4.0   0.0     4.0     6.0   30.0 26.0     *       34     11   56 39 3 4   0     4     6   30 26         34   11   56
2140030 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2019   grade_4 8.0 10.0 3.0   1.0     10.0     2.0   14.0 20.0     *       13     6   34 8 10 3   1     10     2   14 20         13   6   34
2140068 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2019   grade_4 57.0 5.0 4.0   0.0     19.0     2.0   49.0 38.0     *       16     5   87 57 5 4   0     19     2   49 38         16   5   87
2140087 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2019   grade_4 59.0 5.0 4.0   0.0     14.0     6.0   37.0 51.0     *       27     11   88 59 5 4   0     14     6   37 51         27   11   88
2140125 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2019   grade_4 37.0 3.0 4.0   1.0     3.0     2.0   23.0 27.0     *       8     8   50 37 3 4   1     3     2   23 27         8   8   50
2140144 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2019   grade_4 31.0 4.0 4.0   1.0     9.0     5.0   30.0 24.0     *       18     6   54 31 4 4   1     9     5   30 24         18   6   54
2140220 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 38.0 2.0 1.0         2.0     1.0   19.0 25.0     *       14     7   44 38 2 1         2     1   19 25         14   7   44
2140296 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 49.0 4.0 4.0         12.0     5.0   37.0 37.0     *       14     7   74 49 4 4         12     5   37 37         14   7   74
2140353 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 80.0 0.0 3.0         0.0     3.0   44.0 42.0     *       *     12   86 80 0 3         0     3   44 42             12   86
2140372 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   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
2140391 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2140410 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 45.0 18.0 12.0         4.0     16.0   50.0 45.0     *       69     14   95 45 18 12         4     16   50 45         69   14   95
2140581 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_4 49.0 1.0 2.0   0.0     0.0         24.0 28.0     *       33     6   52 49 1 2   0     0         24 28         33   6   52
2140676 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2019   grade_4 19.0 0.0 0.0   0.0           0.0   10.0 9.0     *       11     *   19 19 0 0   0           0   10 9         11       19
2140695 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2019   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
2140923 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2019   grade_4 0.0 21.0 49.0   0.0     0.0         32.0 38.0     *       69     21   70 0 21 49   0     0         32 38         69   21   70
2140999 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2019   grade_4 0.0 26.0 27.0   0.0     0.0     0.0   25.0 28.0     *       53     11   53 0 26 27   0     0     0   25 28         53   11   53
2141189 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406382 320700010359 CONCOURSE VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_4 1.0 20.0 37.0   0.0     3.0         25.0 36.0     *       57     18   61 1 20 37   0     3         25 36         57   18   61
2141626 NY Bronx   school 3600967 320700860915   BGLIG CHARTER SCHOOL 360096706008 320700860915 BGLIG-SHIRLEY RODRIGUEZ-REMENESKI CS charter Regular School Yes Elementary KG 08 2019   grade_4 0.0 14.0 30.0   1.0     0.0     0.0     45.0     *       41     7   45 0 14 30   1     0     0     45         41   7   45
2141702 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_4 0.0 25.0 29.0   0.0     0.0     1.0   29.0 26.0     *       52     5   55 0 25 29   0     0     1   29 26         52   5   55
2141740 NY Bronx   school 3601115 320700860994   BOYS PREP CHARTER SCHOOL OF 360111506454 320700860994 BOYS PREP CHARTER SCHOOL OF NY charter Regular School Yes Elementary PK 05 2019   grade_4 1.0 27.0 29.0   0.0     0.0     0.0   57.0 0.0     *       47     18   57 1 27 29   0     0     0   57 0         47   18   57
2141816 NY Bronx   school 3601070 320700861028   FAMILY LIFE ACADEMY CHARTER 360107006318 320700861028 FAMILY LIFE ACADEMY CHARTER SCH II charter Regular School Yes Elementary KG 08 2019   grade_4 0.0 9.0 43.0   0.0     0.0     0.0   23.0 29.0     *       48     11   52 0 9 43   0     0     0   23 29         48   11   52
2141835 NY Bronx   school 3601105 320700861035   SOUTH BRONX CLASSICAL II 360110506385 320700861035 SOUTH BRONX CLASSICAL CHARTER II charter Regular School Yes Elementary KG 06 2019   grade_4 0.0 27.0 33.0   0.0           0.0   33.0 27.0     *       55     11   60 0 27 33   0           0   33 27         55   11   60
2141892 NY Bronx   school 3601137 320700861080   STOREFRONT ACADEMY CHARTER S 360113706552 320700861080 STOREFRONT ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_4 1.0 18.0 18.0   0.0     1.0     0.0   17.0 21.0     *       35     *   38 1 18 18   0     1     0   17 21         35       38
2142082 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502285 320800010069 PS 69 JOURNEY PREP SCHOOL public Regular School No Elementary PK 05 2019   grade_4 0.0 16.0 77.0   0.0     3.0         43.0 53.0     *       88     25   96 0 16 77   0     3         43 53         88   25   96
2142120 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502295 320800010072 PS 72 DR WILLIAM DORNEY public Regular School No Elementary PK 05 2019   grade_4 2.0 22.0 78.0         2.0         51.0 53.0     *       91     35   104 2 22 78         2         51 53         91   35   104
2142158 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502354 320800010093 PS 93 ALBERT G OLIVER public Regular School No Elementary PK 05 2019   grade_4 0.0 31.0 14.0   1.0           0.0   17.0 29.0     *       30     12   46 0 31 14   1           0   17 29         30   12   46
2142443 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505123 320800010304 PS 304 EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK 05 2019   grade_4 20.0 4.0 51.0   1.0     15.0     0.0   47.0 44.0     *       61     23   91 20 4 51   1     15     0   47 44         61   23   91
2142557 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506506 320800010392 BRONX DELTA SCHOOL public Regular School No Elementary PK 04 2019   grade_4 6.0 3.0 20.0   0.0     4.0     0.0   20.0 13.0     *       *     *   33 6 3 20   0     4     0   20 13                 33
2142994 NY Bronx   school 3600063 320800860846   BRONX CHARTER SCHOOL-ARTS 360006304875 320800860846 BRONX CHARTER SCHOOL FOR THE ARTS charter Regular School Yes Elementary KG 06 2019   grade_4 0.0 14.0 37.0   0.0     0.0     0.0   24.0 27.0     *       44     14   51 0 14 37   0     0     0   24 27         44   14   51
2143013 NY Bronx   school 3600112 320800860872   GRAND CONCOURSE ACAD CHARTER 360011205672 320800860872 GRAND CONCOURSE ACAD CHARTER SCH charter Regular School Yes Elementary KG 08 2019   grade_4 1.0 17.0 37.0   0.0     4.0     1.0   30.0 30.0     *       49     8   60 1 17 37   0     4     1   30 30         49   8   60
2143051 NY Bronx   school 3600986 320800860940   GIRLS PREP CHARTER-BRONX 360098606161 320800860940 GIRLS PREP CHARTER SCH-BRONX charter Regular School Yes Elementary PK 08 2019   grade_4 3.0 29.0 55.0   0.0     0.0     2.0   0.0 89.0     *       85     15   89 3 29 55   0     0     2   0 89         85   15   89
2144495 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_4 0.0 53.0 31.0   1.0     0.0     0.0   41.0 44.0     *       66     7   85 0 53 31   1     0     0   41 44         66   7   85
2144533 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER charter Regular School Yes Elementary KG 05 2019   grade_4 1.0 9.0 38.0   0.0     0.0         16.0 32.0     *       39     *   48 1 9 38   0     0         16 32         39       48
2144590 NY Bronx   school 3601012 320900860980   SUCCESS ACADEMY -BRONX 2 360101206219 320900860980 SUCCESS ACADEMY CHARTER-BRONX 2 charter Regular School Yes Elementary KG 08 2019   grade_4 0.0 54.0 29.0   0.0     0.0     0.0   45.0 38.0     *       67     10   83 0 54 29   0     0     0   45 38         67   10   83
2144628 NY Bronx   school 3601069 320900861029   ICAHN CHARTER SCHOOL 6 360106906355 320900861029 ICAHN CHARTER SCHOOL 6 charter Regular School Yes Elementary KG 08 2019   grade_4 0.0 23.0 15.0   0.0     0.0     0.0   18.0 20.0     *       34     *   38 0 23 15   0     0     0   18 20         34       38
2144647 NY Bronx   school 3601129 320900861073   ROSALYN YALOW CHARTER SCHOOL 360112906566 320900861073 ROSALYN YALOW CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_4 0.0 13.0 41.0         0.0     1.0   16.0 39.0     *       52     12   55 0 13 41         0     1   16 39         52   12   55
2144780 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701748 321000010015 PS 15 INST FOR ENVIRON LRNG public Regular School No Elementary KG 08 2019   grade_4   3.0 39.0   0.0     1.0     2.0   16.0 29.0     *       *     8   45   3 39   0     1     2   16 29             8   45
2144837 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No Elementary KG 05 2019   grade_4 56.0 5.0 62.0   0.0     10.0     5.0   69.0 69.0     *       32     24   138 56 5 62   0     10     5   69 69         32   24   138
2144951 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700127 321000010051 PS 51 BRONX NEW SCHOOL public Regular School No Elementary PK 05 2019   grade_4 0.0 11.0 21.0   0.0     1.0         15.0 18.0     *       26     6   33 0 11 21   0     1         15 18         26   6   33
2145312 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704731 321000010226 PS 226 public Regular School No Elementary PK 05 2019   grade_4   19.0 42.0   0.0     0.0         33.0 28.0     *       61     11   61   19 42   0     0         33 28         61   11   61
2145540 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702939 321000010315 PS 315 LAB SCHOOL public Regular School No Elementary KG 08 2019   grade_4 0.0 2.0 21.0         1.0     0.0   14.0 10.0     *       24     7   24 0 2 21         1     0   14 10         24   7   24
2145597 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705993 321000010344 AMPARK NEIGHBORHOOD public Regular School No Elementary PK 05 2019   grade_4 7.0 8.0 40.0   1.0     2.0     2.0   34.0 26.0     *       34     21   60 7 8 40   1     2     2   34 26         34   21   60
2146167 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701922 321000011445 BRONX HIGH SCHOOL OF SCIENCE public Regular School No High 09 12 2019   grade_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
2146680 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802368 321100010097 PS 97 public Regular School No Elementary PK 05 2019   grade_4 16.0 35.0 34.0   2.0     16.0     0.0   53.0 50.0     *       80     25   103 16 35 34   2     16     0   53 50         80   25   103
2146794 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802419 321100010112 PS 112 BRONXWOOD public Regular School No Elementary PK 05 2019   grade_4 0.0 26.0 30.0                   28.0 28.0     *       55     21   56 0 26 30                   28 28         55   21   56
2146870 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802553 321100010153 PS 153 HELEN KELLER public Regular School No Elementary PK 05 2019   grade_4 5.0 55.0 34.0   2.0     19.0     0.0   56.0 59.0     *       72     13   115 5 55 34   2     19     0   56 59         72   13   115
2146927 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802613 321100010175 PS 175 CITY ISLAND public Regular School No Elementary KG 08 2019   grade_4 14.0 2.0 16.0   0.0     2.0     1.0   23.0 12.0     *       19     11   35 14 2 16   0     2     1   23 12         19   11   35
2147212 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008806217 321100010498 PS/MS 498 VAN NEST ACADEMY public Regular School No Elementary KG 08 2019   grade_4 8.0 6.0 47.0   0.0     3.0     0.0   37.0 27.0     *       46     12   64 8 6 47   0     3     0   37 27         46   12   64
2147649 NY Bronx   school 3600089 321100860855   BRONX CHARTER SCH BETTER LEA 360008905554 321100860855 BRONX CHARTER SCH BETTER LEARNING charter Regular School Yes Elementary PK 05 2019   grade_4 5.0 69.0 18.0   0.0     3.0     1.0   36.0 60.0     *       76     12   96 5 69 18   0     3     1   36 60         76   12   96
2147687 NY Bronx   school 3600943 321100860909   ICAHN CHARTER SCHOOL 2 360094305973 321100860909 ICAHN CHARTER SCHOOL 2 charter Regular School Yes Elementary KG 08 2019   grade_4 1.0 8.0 21.0   0.0     2.0     1.0   12.0 21.0     *       17     5   33 1 8 21   0     2     1   12 21         17   5   33
2147725 NY Bronx   school 3600995 321100860948   ICAHN CHARTER SCH 4 360099506103 321100860948 ICAHN CHARTER SCHOOL 4 charter Regular School Yes Elementary KG 08 2019   grade_4 0.0 23.0 9.0   0.0     0.0     2.0   18.0 16.0     *       20     *   34 0 23 9   0     0     2   18 16         20       34
2147763 NY Bronx   school 3601049 321100860982   ICAHN CHARTER SCHOOL 5 360104906265 321100860982 ICAHN CHARTER SCHOOL 5 charter Regular School Yes Elementary KG 08 2019   grade_4 5.0 20.0 8.0   0.0     2.0     0.0   18.0 17.0     *       24     *   35 5 20 8   0     2     0   18 17         24       35
2147877 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002059 321200010006 PS 6 WEST FARMS public Regular School No Elementary PK 05 2019   grade_4 0.0 16.0 59.0   0.0     0.0         41.0 34.0     *       73     24   75 0 16 59   0     0         41 34         73   24   75
2147972 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005509 321200010066 PS 66 SCHOOL OF HIGHER EXPECTATIONS public Regular School No Elementary PK 05 2019   grade_4 3.0 27.0 62.0   0.0     3.0         51.0 44.0     *       88     33   95 3 27 62   0     3         51 44         88   33   95
2148789 NY Bronx   school 3600161 321200860898   SOUTH BRONX CLASSICAL CHARTE 360016105893 321200860898 SOUTH BRONX CLASSICAL CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_4 1.0 18.0 30.0   0.0     1.0     0.0   18.0 32.0     *       45     *   50 1 18 30   0     1     0   18 32         45       50
2148884 NY Bronx   school 3601161 321200861108   NY CENTER FOR AUTISM CS - BR 360116106615 321200861108 NY CENTER FOR AUTISM CS - BRONX charter Special Education School Yes Elementary KG KG 2019   grade_4 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
2148903 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000512 30101060001 CHENANGO FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_4 86.0 1.0 1.0         2.0     6.0   52.0 44.0     *       49     9   96 86 1 1         2     6   52 44         49   9   96
2148922 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000513 30101060003 CHENANGO FORKS HIGH SCHOOL public Regular School No High 09 12 2019   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
2148941 NY Broome   school 3607260 30101060000   CHENANGO FORKS 360726000514 30101060004 CHENANGO FORKS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2149036 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000232 30200010012 THEODORE ROOSEVELT SCHOOL public Regular School No Elementary PK 05 2019   grade_4 12.0 21.0 10.0         1.0     11.0   24.0 31.0     *       45     9   55 12 21 10         1     11   24 31         45   9   55
2149093 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000234 30200010016 WEST MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2149188 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003821 30601060001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_4 65.0 0.0 1.0   0.0     1.0     4.0   34.0 37.0     *       33     8   71 65 0 1   0     1     4   34 37         33   8   71
2149226 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003824 30601060005 RICHARD T STANK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2149245 NY Broome   school 3628380 30601060000   SUSQUEHANNA VALLEY 362838003825 30601060006 SUSQUEHANNA VALLEY SENIOR HIGH SCH public Regular School No High 09 12 2019   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
2149283 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000518 30701060003 CHENANGO BRIDGE ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2019   grade_4 114.0 1.0 4.0   0.0     1.0     8.0   66.0 62.0     *       62     20   128 114 1 4   0     1     8   66 62         62   20   128
2149302 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   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
2149340 NY Broome   school 3618150 31101060000   MAINE ENDWELL 361815001627 31101060003 HOMER BRINK SCHOOL public Regular School No Elementary KG 05 2019   grade_4 112.0 2.0 3.0   0.0     5.0     3.0   59.0 66.0     *       50     18   125 112 2 3   0     5     3   59 66         50   18   125
2149435 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2149473 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000846 31501060001 CHARLES F JOHNSON JR ELEMENTARY SCH public Regular School No Elementary KG 05 2019   grade_4 37.0 12.0 13.0   0.0     0.0     11.0   33.0 40.0     *       64     6   73 37 12 13   0     0     11   33 40         64   6   73
2149511 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Regular School No Other 03 11 2019   grade_4 8.0 1.0 0.0               2.0   8.0 3.0     *       9     11   11 8 1 0               2   8 3         9   11   11
2149530 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000851 31501060009 JENNIE F SNAPP MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2149682 NY Broome   school 3629610 31601060000   VESTAL 362961003984 31601060021 AFRICAN ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 27.0 2.0 2.0         12.0     0.0   19.0 24.0     *       12     5   43 27 2 2         12     0   19 24         12   5   43
2149720 NY Broome   school 3629610 31601060000   VESTAL 362961003987 31601060023 GLENWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 49.0 1.0 1.0   1.0     1.0     0.0   29.0 24.0     *       11     7   53 49 1 1   1     1     0   29 24         11   7   53
2149758 NY Broome   school 3629610 31601060000   VESTAL 362961003990 31601060028 VESTAL HILLS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 31.0 2.0 1.0   0.0     10.0     4.0   26.0 22.0     *       22     8   48 31 2 1   0     10     4   26 22         22   8   48
2149815 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_4 37.0 2.0 3.0         1.0     0.0   22.0 21.0     *       21     *   43 37 2 3         1     0   22 21         21       43
2149853 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   grade_4 26.0 1.0 0.0         0.0     0.0   16.0 11.0     *       17     6   27 26 1 0         0     0   16 11         17   6   27
2149929 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2019   grade_4 69.0 0.0 2.0   0.0     0.0     7.0   37.0 41.0     *       31     *   78 69 0 2   0     0     7   37 41         31       78
2150043 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2019   grade_4 63.0 0.0 1.0   1.0     0.0     0.0   33.0 32.0     *       47     8   65 63 0 1   1     0     0   33 32         47   8   65
2150119 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003077 42400010004 EAST VIEW ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   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
2150157 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003081 42400010016 OLEAN INTERMEDIATE-MIDDLE SCHOOL public Regular School No Middle 03 07 2019   grade_4 115.0 5.0 2.0   0.0     6.0     14.0   71.0 71.0     *       84     20   142 115 5 2   0     6     14   71 71         84   20   142
2150328 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744006294 43011020002 RANDOLPH ACADEMY-HAMBURG CAMPUS public Regular School No Other KG 12 2019   grade_4 2.0 1.0 2.0   0.0           0.0   5.0 0.0     *       *     5   5 2 1 2   0           0   5 0             5   5
2150347 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003519 43200050002 SALAMANCA HIGH SCHOOL public Regular School No High 08 12 2019   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
2150366 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003518 43200050004 PROSPECT ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   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
2150385 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544003520 43200050005 SENECA INTERMEDIATE SCHOOL public Regular School No Middle 03 07 2019   grade_4 57.0 1.0 8.0   42.0     0.0     7.0   51.0 64.0     *       81     11   115 57 1 8   42     0     7   51 64         81   11   115
2150404 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_4 69.0 1.0 5.0   0.0     0.0     4.0   38.0 41.0     *       54     21   79 69 1 5   0     0     4   38 41         54   21   79
2150423 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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

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