Data source: Big Local News · About: Big Local

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

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
1504213 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003769 500402060016 ELMWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_4 3.0 34.0 125.0         9.0     1.0   91.0 81.0     98       154     *   172 3 34 125         9     1   91 81     98   154       172
2120403 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003768 500402060023 ELDORADO ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2018   grade_4 3.0 38.0 115.0         4.0     1.0   87.0 74.0     98       151     20   161 3 38 115         4     1   87 74     98   151   20   161
967710 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 5 2017   grade_4 7.0 2.0 105.0   0.0     133.0     0.0   114.0 133.0     97       241     26   247 7 2 105   0     133     0   114 133     97   241   26   247
1493896 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No Elementary PK 05 2021   grade_4 8.0 0.0 69.0   0.0     121.0     0.0   103.0 95.0     95       179     27   198 8 0 69   0     121     0   103 95     95   179   27   198
1512763 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_4 1.0 8.0 189.0   1.0     1.0     0.0   106.0 94.0     95       182     40   200 1 8 189   1     1     0   106 94     95   182   40   200
2091751 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2018   grade_4 1.0 53.0 145.0         0.0         104.0 95.0     95       179     11   199 1 53 145         0         104 95     95   179   11   199
1458917 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 05 2021   grade_4 8.0 1.0 58.0   0.0     142.0     0.0   106.0 103.0     94       194     47   209 8 1 58   0     142     0   106 103     94   194   47   209
2199842 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2019   grade_4 2.0 10.0 259.0   0.0     14.0     0.0   152.0 133.0     94       238     62   285 2 10 259   0     14     0   152 133     94   238   62   285
1504270 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003768 500402060023 ELDORADO ELEMENTARY SCHOOL public Regular School No Middle 04 06 2021   grade_4 5.0 34.0 134.0   1.0     0.0     0.0   99.0 75.0     93       156     13   174 5 34 134   1     0     0   99 75     93   156   13   174
1594387 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003775 500402060019 LIME KILN ELEMENTARY SCHOOL public Regular School No Middle 04 06 2020   grade_4 4.0 45.0 120.0         5.0     4.0   102.0 76.0     93       167     31   178 4 45 120         5     4   102 76     93   167   31   178
1002936 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2017   grade_4 3.0 10.0 272.0   4.0     23.0     0.0   159.0 153.0     92       212     52   312 3 10 272   4     23     0   159 153     92   212   52   312
1594349 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003769 500402060016 ELMWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_4 5.0 35.0 123.0         5.0     2.0   82.0 88.0     90       158     5   170 5 35 123         5     2   82 88     90   158   5   170
2164920 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 05 2019   grade_4 11.0 2.0 88.0   1.0     130.0     2.0   104.0 130.0     90       215     39   234 11 2 88   1     130     2   104 130     90   215   39   234
943884 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2017   grade_4 0.0 15.0 50.0   0.0     0.0     1.0   30.0 36.0     9       66     20   66 0 15 50   0     0     1   30 36     9   66   20   66
945100 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502401 320800010107 PS 107 public Regular School No Elementary PK 05 2017   grade_4 3.0 31.0 51.0   1.0     1.0     0.0   46.0 41.0     9       87     25   87 3 31 51   1     1     0   46 41     9   87   25   87
945993 NY Bronx   school 3600165 320800860903   HYDE LEADERSHIP CHARTER SCHO 360016505889 320800860903 HYDE LEADERSHIP CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_4 1.0 23.0 48.0   0.0     0.0     0.0   43.0 29.0     9       65     20   72 1 23 48   0     0     0   43 29     9   65   20   72
948026 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702318 321000010081 PS 81 ROBERT J CHRISTEN public Regular School No Elementary KG 05 2017   grade_4 29.0 9.0 64.0   0.0     9.0     1.0   52.0 60.0     9       61     17   112 29 9 64   0     9     1   52 60     9   61   17   112
949717 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802417 321100010111 PS 111 SETON FALLS public Regular School No Elementary PK 05 2017   grade_4 1.0 58.0 33.0   3.0     1.0     2.0   51.0 47.0     9       86     31   98 1 58 33   3     1     2   51 47     9   86   31   98
950971 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002491 321200010134 PS 134 GEORGE F BRISTOW public Regular School No Elementary PK 05 2017   grade_4 0.0 49.0 53.0   0.0     1.0     0.0   55.0 48.0     9       98     35   103 0 49 53   0     1     0   55 48     9   98   35   103
960623 NY Erie   school 3618600 140702030000   MARYVALE 361860004443 140702030004 MARYVALE INTERMEDIATE SCHOOL public Regular School No Elementary 03 5 2017   grade_4 126.0 16.0 7.0   0.0     8.0     11.0   77.0 91.0     9       89     30   168 126 16 7   0     8     11   77 91     9   89   30   168
961763 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2017   grade_4 48.0 20.0 7.0         1.0     0.0   36.0 40.0     9       63     *   76 48 20 7         1     0   36 40     9   63       76
962295 NY Erie   school 3616230 142601030000   KENMORE 361623001402 142601030023 BEN FRANKLIN ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   grade_4 72.0 16.0 13.0   1.0     2.0     8.0   68.0 44.0     9       65     37   112 72 16 13   1     2     8   68 44     9   65   37   112
967520 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202072 331500010010 MAGNET SCH OF MATH, SCI, DESIGN public Regular School No Elementary PK 5 2017   grade_4 65.0 10.0 51.0   0.0     7.0     7.0   78.0 62.0     9       35     40   140 65 10 51   0     7     7   78 62     9   35   40   140
967672 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202251 331500010058 PS 58 CARROLL (THE) public Regular School No Elementary PK 5 2017   grade_4 95.0 5.0 19.0   1.0     7.0     15.0   78.0 64.0     9       16     25   142 95 5 19   1     7     15   78 64     9   16   25   142
969116 NY Kings   school 3601029 331600860971   BEDFORD STUY NEW BEGINNINGS 360102906236 331600860971 BEDFORD STUY NEW BEGINNINGS CHARTER charter Regular School Yes Elementary KG 8 2017   grade_4 2.0 49.0 28.0   1.0     0.0     0.0   33.0 47.0     9       74     13   80 2 49 28   1     0     0   33 47     9   74   13   80
975557 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702543 333200010151 PS 151 LYNDON B JOHNSON public Regular School No Elementary PK 05 2017   grade_4 1.0 9.0 37.0         0.0     0.0   25.0 22.0     9       43     14   47 1 9 37         0     0   25 22     9   43   14   47
977229 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000273 260101060010 FRENCH ROAD ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_4 183.0 21.0 15.0         25.0     19.0   135.0 128.0     9       *     37   263 183 21 15         25     19   135 128     9       37   263
977571 NY Monroe   school 3612630 260501060000   GREECE 361263001029 260501060015 CRAIG HILL ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_4 74.0 21.0 24.0         5.0     5.0   64.0 65.0     9       74     22   129 74 21 24         5     5   64 65     9   74   22   129
979300 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003405 261600010034 SCHOOL 34-DR LOUIS A CERULLI public Regular School No Elementary PK 06 2017   grade_4 14.0 43.0 17.0   0.0     4.0     0.0   37.0 41.0     9       74     14   78 14 43 17   0     4     0   37 41     9   74   14   78
981371 NY Nassau   school 3609840 280203030000   EAST MEADOW 360984000758 280203030003 MCVEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 79.0 2.0 31.0         18.0     0.0   72.0 58.0     9       42     13   130 79 2 31         18     0   72 58     9   42   13   130
982872 NY Nassau   school 3610620 280216020000   ELMONT 361062000832 280216020002 CLARA H CARLSON SCHOOL public Regular School No Elementary PK 06 2017   grade_4 6.0 49.0 43.0   0.0     29.0     1.0   60.0 68.0     9       85     12   128 6 49 43   0     29     1   60 68     9   85   12   128
983993 NY Nassau   school 3629490 280230020000   VALLEY STR HEMP 30 362949003979 280230020003 SHAW AVENUE SCHOOL public Regular School No Elementary KG 06 2017   grade_4 3.0 53.0 36.0   0.0     29.0     2.0   69.0 54.0     9       50     12   123 3 53 36   0     29     2   69 54     9   50   12   123
985000 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001019 280407030007 JOHN F KENNEDY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 62.0 0.0 19.0         12.0     1.0   56.0 38.0     9       29     20   94 62 0 19         12     1   56 38     9   29   20   94
985209 NY Nassau   school 3614280 280409030000   HERRICKS 361428001178 280409030004 SEARINGTOWN SCHOOL public Regular School No Elementary KG 06 2017   grade_4 20.0 1.0 6.0         52.0     1.0   46.0 34.0     9       12     16   80 20 1 6         52     1   46 34     9   12   16   80
991916 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007905530 310400010083 PS 83 LUIS MUNOZ RIVERA public Regular School No Elementary PK 05 2017   grade_4 6.0 15.0 48.0   0.0     14.0         37.0 46.0     9       75     21   83 6 15 48   0     14         37 46     9   75   21   83
993683 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008304872 310600010178 PROFESSOR JUAN BOSCH PS public Regular School No Elementary KG 05 2017   grade_4 4.0 1.0 59.0         1.0     0.0   34.0 31.0     9       52     21   65 4 1 59         1     0   34 31     9   52   21   65
994861 NY Niagara   school 3620820 400800010000   NIAGARA FALLS 362082002937 400800010012 GERALDINE J MANN SCHOOL public Regular School No Elementary PK 06 2017   grade_4 32.0 7.0 5.0   0.0     4.0     8.0   32.0 24.0     9       39     10   56 32 7 5   0     4     8   32 24     9   39   10   56
996248 NY Oneida   school 3629370 412300010000   UTICA 362937003946 412300010003 ALBANY ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_4 41.0 13.0 23.0         10.0     3.0   46.0 44.0     9       72     7   90 41 13 23         10     3   46 44     9   72   7   90
996875 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002994 420303060001 ALLEN ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   grade_4 60.0 0.0 3.0   0.0     5.0     5.0   41.0 32.0     9       29     5   73 60 0 3   0     5     5   41 32     9   29   5   73
998110 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001569 421501060012 MORGAN ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_4 53.0 6.0 5.0   0.0     4.0     4.0   38.0 34.0     9       24     17   72 53 6 5   0     4     4   38 34     9   24   17   72
1000010 NY Orange   school 3612330 440601040000   GOSHEN 361233000996 440601040005 GOSHEN INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   grade_4 148.0 6.0 55.0         8.0     3.0   116.0 104.0     9       63     34   220 148 6 55         8     3   116 104     9   63   34   220
1005273 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902726 342600010221 PS 221 NORTH HILLS SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_4 17.0 5.0 12.0   0.0     73.0     0.0   52.0 55.0     9       56     20   107 17 5 12   0     73     0   52 55     9   56   20   107
1007895 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102432 342900010116 PS/IS 116 WILLIAM C HUGHLEY public Regular School No Elementary PK 08 2017   grade_4 3.0 62.0 29.0   1.0     4.0     0.0   50.0 49.0     9       64     26   99 3 62 29   1     4     0   50 49     9   64   26   99
1009035 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202544 343000010151 PS 151 MARY D CARTER public Regular School No Elementary PK 05 2017   grade_4 6.0 17.0 34.0   0.0     14.0         27.0 44.0     9       65     20   71 6 17 34   0     14         27 44     9   65   20   71
1009586 NY Queens   school 3600957 343000860932   VOICE CHARTER SCHOOL OF NEW 360095706068 343000860932 VOICE CHARTER SCHOOL OF NEW YORK charter Regular School Yes Elementary KG 08 2017   grade_4 8.0 5.0 51.0   1.0     17.0     1.0   42.0 41.0     9       66     13   83 8 5 51   1     17     1   42 41     9   66   13   83
1011163 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302229 353100010052 PS 52 JOHN C THOMPSON public Regular School No Elementary PK 05 2017   grade_4 41.0 1.0 16.0   0.0     9.0     0.0   32.0 35.0     9       43     20   67 41 1 16   0     9     0   32 35     9   43   20   67
1011201 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302234 353100010054 PS 54 CHARLES W LENG public Regular School No Elementary PK 05 2017   grade_4 37.0 6.0 41.0   1.0     31.0     1.0   52.0 65.0     9       69     34   117 37 6 41   1     31     1   52 65     9   69   34   117
1011429 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302286 353100010069 PS 69 DANIEL D TOMPKINS public Regular School No Elementary PK 05 2017   grade_4 97.0 5.0 34.0   0.0     29.0     1.0   97.0 69.0     9       89     36   166 97 5 34   0     29     1   97 69     9   89   36   166
1018212 NY Suffolk   school 3624840 580209020000   ROCKY POINT 362484003435 580209020001 JOSEPH A EDGAR INTERMEDIATE SCH public Regular School No Elementary 03 05 2017   grade_4 208.0 4.0 24.0   2.0     4.0     4.0   120.0 126.0     9       83     41   246 208 4 24   2     4     4   120 126     9   83   41   246
1018611 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001756 580212060004 WEST MIDDLE ISLAND SCHOOL public Regular School No Elementary KG 04 2017   grade_4 78.0 31.0 48.0   3.0     4.0     12.0   96.0 80.0     9       87     29   176 78 31 48   3     4     12   96 80     9   87   29   176
1018725 NY Suffolk   school 3622470 580224030000   PATCHOGUE-MEDFORD 362247003160 580224030003 BAY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 19.0 3.0 27.0         0.0     1.0   29.0 21.0     9       39     *   50 19 3 27         0     1   29 21     9   39       50
1019086 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 91.0 3.0 24.0   2.0     2.0         58.0 64.0     9       43     26   122 91 3 24   2     2         58 64     9   43   26   122
1020131 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001117 580406060009 THOMAS J LAHEY ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2017   grade_4 192.0 7.0 32.0   0.0     13.0     12.0   127.0 129.0     9       36     47   256 192 7 32   0     13     12   127 129     9   36   47   256
1022221 NY Suffolk   school 3627060 580801060000   SMITHTOWN 362706003686 580801060008 SMITHTOWN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 56.0 0.0 15.0         3.0     2.0   31.0 45.0     9       11     12   76 56 0 15         3     2   31 45     9   11   12   76
1027066 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000786 660301030003 GREENVALE SCHOOL public Regular School No Elementary 02 05 2017   grade_4 101.0 3.0 10.0         25.0     11.0   81.0 69.0     9       *     23   150 101 3 10         25     11   81 69     9       23   150
1028643 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001835 660900010004 HAMILTON SCHOOL public Regular School No Elementary KG 06 2017   grade_4 0.0 45.0 29.0   0.0     0.0     1.0   36.0 39.0     9       62     17   75 0 45 29   0     0     1   36 39     9   62   17   75
1028681 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010001837 660900010006 LINCOLN SCHOOL public Regular School No Elementary KG 06 2017   grade_4 14.0 56.0 33.0         6.0     0.0   53.0 56.0     9       79     17   109 14 56 33         6     0   53 56     9   79   17   109
1029137 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004400 661100010009 WILLIAM B WARD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 71.0 40.0 57.0   0.0     7.0     0.0   99.0 76.0     9       59     31   175 71 40 57   0     7     0   99 76     9   59   31   175
1030733 NY Westchester   school 3631920 662300010000   YONKERS 363192004266 662300010023 SCHOOL 23 public Regular School No Elementary PK 08 2017   grade_4 9.0 22.0 44.0   0.0     2.0     1.0   34.0 44.0     9       66     13   78 9 22 44   0     2     1   34 44     9   66   13   78
1433058 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2021   grade_4 8.0 24.0 7.0   0.0     14.0     3.0   33.0 23.0     9       42     0   56 8 24 7   0     14     3   33 23     9   42   0   56
1433761 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_4 50.0 3.0 9.0   0.0     9.0     6.0   44.0 33.0     9       20     5   77 50 3 9   0     9     6   44 33     9   20   5   77
1433799 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_4 38.0 5.0 5.0         7.0     5.0   29.0 31.0     9       27     11   60 38 5 5         7     5   29 31     9   27   11   60
1433951 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2021   grade_4 51.0 1.0 4.0   0.0     20.0     1.0   42.0 35.0     9       24     7   77 51 1 4   0     20     1   42 35     9   24   7   77
1435547 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_4 0.0 33.0 33.0   0.0     0.0     0.0   37.0 29.0     9       61     7   66 0 33 33   0     0     0   37 29     9   61   7   66
1437333 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602188 320900010042 PS 42 CLAREMONT public Regular School No Elementary PK 05 2021   grade_4 0.0 24.0 33.0               1.0   29.0 29.0     9       57     22   58 0 24 33               1   29 29     9   57   22   58
1438872 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 2021   grade_4   5.0 38.0   1.0     2.0     0.0   20.0 26.0     9       35     12   46   5 38   1     2     0   20 26     9   35   12   46
1440696 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802185 321100010041 PS 41 GUN HILL ROAD public Regular School No Elementary KG 05 2021   grade_4 3.0 56.0 72.0   2.0     3.0     0.0   73.0 63.0     9       132     30   136 3 56 72   2     3     0   73 63     9   132   30   136
1440829 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802364 321100010096 PS 96 RICHARD RODGERS public Regular School No Elementary PK 05 2021   grade_4 6.0 30.0 102.0   1.0     2.0     1.0   71.0 71.0     9       120     39   142 6 30 102   1     2     1   71 71     9   120   39   142
1442900 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003847 321200011691 BRONX LITTLE SCHOOL public Regular School No Elementary PK 05 2021   grade_4 0.0 9.0 26.0   1.0     8.0     0.0   24.0 20.0     9       41     8   44 0 9 26   1     8     0   24 20     9   41   8   44
1449873 NY Erie   school 3602920 140201060000   AMHERST 360292004289 140201060006 WINDERMERE BLVD SCHOOL public Regular School No Elementary PK 05 2021   grade_4 43.0 20.0 6.0   1.0     8.0     9.0   36.0 51.0     9       34     *   87 43 20 6   1     8     9   36 51     9   34       87
1459468 NY Kings   school 3600949 331500860927   PAVE ACADEMY CHARTER SCHOOL 360094906082 331500860927 PAVE ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_4 3.0 19.0 36.0   0.0     0.0     0.0   29.0 29.0     9       51     14   58 3 19 36   0     0     0   29 29     9   51   14   58
1468588 NY Monroe   school 3612630 260501060000   GREECE 361263004770 260501060007 WEST RIDGE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 12.0 20.0 16.0         5.0     2.0   24.0 31.0     9       48     12   55 12 20 16         5     2   24 31     9   48   12   55
1471552 NY Monroe   school 3630360 261901060000   WEBSTER 363036004084 261901060013 KLEM ROAD SOUTH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_4 66.0 1.0 14.0   0.0     6.0     3.0   45.0 45.0     9       33     10   90 66 1 14   0     6     3   45 45     9   33   10   90
1472236 NY Nassau   school 3600997 280201860934   ACADEMY CHARTER SCHOOL 360099706131 280201860934 ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_4 1.0 69.0 52.0   5.0     0.0     0.0   52.0 75.0     9       113     6   127 1 69 52   5     0     0   52 75     9   113   6   127
1473490 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003062 280211030005 SCHOOL 5 public Regular School No Elementary 01 06 2021   grade_4 45.0 2.0 21.0         2.0     1.0   33.0 38.0     9       13     7   71 45 2 21         2     1   33 38     9   13   7   71
1476283 NY Nassau   school 3614280 280409030000   HERRICKS 361428001174 280409030001 CENTER STREET SCHOOL public Regular School No Elementary KG 05 2021   grade_4 27.0 0.0 2.0         52.0     1.0   43.0 39.0     9       8     8   82 27 0 2         52     1   43 39     9   8   8   82
1478335 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504605 307500013053 PS 53 public Special Education School No Other KG 12 2021   grade_4 1.0 6.0 18.0   0.0     4.0     3.0   25.0 7.0     9       27     32   32 1 6 18   0     4     3   25 7     9   27   32   32
1483617 NY New York   school 3601042 310400860995   EAST HARLEM SCHOLARS ACADEMY 360104206252 310400860995 EAST HARLEM SCHOLARS ACAD CHARTER charter Regular School Yes Other PK 10 2021   grade_4 2.0 14.0 40.0   1.0     3.0     0.0   24.0 36.0     9       46     14   60 2 14 40   1     3     0   24 36     9   46   14   60
1484966 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305642 310600010278 PAULA HEDBAVNY SCHOOL public Regular School No Elementary KG 08 2021   grade_4 5.0 3.0 43.0         1.0     0.0   25.0 27.0     9       39     14   52 5 3 43         1     0   25 27     9   39   14   52
1485118 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305990 310600010366 WASHINGTON HEIGHTS ACADEMY public Regular School No Elementary PK 08 2021   grade_4 0.0 0.0 60.0         0.0     0.0   26.0 34.0     9       55     18   60 0 0 60         0     0   26 34     9   55   18   60
1489146 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752001559 421501060009 CHESTNUT HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_4 42.0 4.0 3.0   1.0     7.0     6.0   33.0 30.0     9       40     17   63 42 4 3   1     7     6   33 30     9   40   17   63
1490020 NY Onondaga   school 3601181 421800861124   SYRACUSE ACADEMY OF SCI-CITI 360118106661 421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter Regular School Yes Elementary KG 05 2021   grade_4 5.0 34.0 9.0   0.0     11.0     4.0   33.0 30.0     9       44     5   63 5 34 9   0     11     4   33 30     9   44   5   63
1494029 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802215 342400010049 PS 49 DOROTHY BONAWIT KOLE public Regular School No Elementary KG 08 2021   grade_4 59.0 1.0 36.0   1.0     30.0     0.0   56.0 71.0     9       51     23   127 59 1 36   1     30     0   56 71     9   51   23   127
1495492 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202703 342500010209 PS 209 CLEARVIEW GARDENS public Regular School No Elementary PK 05 2021   grade_4 26.0 1.0 19.0         51.0     2.0   48.0 51.0     9       38     19   99 26 1 19         51     2   48 51     9   38   19   99
1496765 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302516 342700010065 PS 65 RAYMOND YORK ELEMENTARY public Regular School No Elementary PK 05 2021   grade_4 1.0 2.0 28.0   0.0     26.0     0.0   22.0 35.0     9       40     14   57 1 2 28   0     26     0   22 35     9   40   14   57
1496822 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302365 342700010096 PS 96 public Regular School No Elementary PK 05 2021   grade_4 2.0 12.0 6.0   6.0     18.0     0.0   19.0 25.0     9       36     *   44 2 12 6   6     18     0   19 25     9   36       44
1496879 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302392 342700010104 PS 104 BAYS WATER (THE) public Regular School No Elementary PK 05 2021   grade_4 0.0 42.0 56.0   0.0     3.0     1.0   64.0 38.0     9       89     31   102 0 42 56   0     3     1   64 38     9   89   31   102
1499121 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102438 342900010118 PS 118 LORRAINE HANSBERRY public Regular School No Elementary PK 05 2021   grade_4 4.0 45.0 10.0   2.0     7.0     2.0   32.0 38.0     9       51     13   70 4 45 10   2     7     2   32 38     9   51   13   70
1500299 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202606 343000010171 PS 171 PETER G VAN ALST public Regular School No Elementary PK 05 2021   grade_4 4.0 19.0 26.0   0.0     6.0     0.0   28.0 27.0     9       47     23   55 4 19 26   0     6     0   28 27     9   47   23   55
1501914 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302110 353100010021 PS 21 MARGARET EMERY-ELM PARK public Regular School No Elementary PK 05 2021   grade_4 4.0 19.0 30.0   0.0     1.0     1.0   27.0 28.0     9       45     27   55 4 19 30   0     1     1   27 28     9   45   27   55
1502104 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302149 353100010032 PS 32 GIFFORD SCHOOL (THE) public Regular School No Elementary PK 05 2021   grade_4 69.0 0.0 23.0         13.0     1.0   61.0 45.0     9       32     31   106 69 0 23         13     1   61 45     9   32   31   106
1502313 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302214 353100010048 PS 48 WILLIAM G WILCOX public Regular School No Elementary PK 08 2021   grade_4 56.0 3.0 26.0   0.0     29.0     2.0   50.0 66.0     9       50     23   116 56 3 26   0     29     2   50 66     9   50   23   116
1502731 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306362 353100010078 PS 78 public Regular School No Elementary PK 05 2021   grade_4 0.0 59.0 56.0   1.0     5.0     0.0   65.0 56.0     9       117     55   121 0 59 56   1     5     0   65 56     9   117   55   121
1506436 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003578 530600010009 HAMILTON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 9.0 11.0 20.0         7.0     5.0   24.0 28.0     9       46     13   52 9 11 20         7     5   24 28     9   46   13   52
1509172 NY Suffolk   school 3625350 580205060000   SACHEM 362535003504 580205060014 MERRIMAC SCHOOL public Regular School No Elementary PK 05 2021   grade_4 61.0 6.0 29.0   0.0     8.0     3.0   54.0 53.0     9       42     63   107 61 6 29   0     8     3   54 53     9   42   63   107
1512269 NY Suffolk   school 3613980 580506030000   HAUPPAUGE 361398001133 580506030004 BRETTON WOODS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_4 61.0 3.0 24.0   0.0     14.0     3.0   54.0 51.0     9       23     14   105 61 3 24   0     14     3   54 51     9   23   14   105
1514055 NY Suffolk   school 3600125 580912060000   ESTPRT-S MANOR CSD 360012504330 580912060004 DAYTON AVENUE SCHOOL public Regular School No Elementary 03 06 2021   grade_4 90.0 4.0 13.0         2.0     2.0   57.0 54.0     9       28     23   111 90 4 13         2     2   57 54     9   28   23   111
1517741 NY Wayne   school 3627120 651201060000   SODUS 362712004902 651201060004 SODUS INTERMEDIATE SCHOOL public Regular School No Middle 04 06 2021   grade_4 40.0 6.0 20.0         1.0     10.0   40.0 37.0     9       *     11   77 40 6 20         1     10   40 37     9       11   77
1519508 NY Westchester   school 3620160 660801060000   MT PLEASANT CENT 362016001846 660801060005 COLUMBUS ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2021   grade_4 108.0 0.0 31.0         6.0     4.0   77.0 72.0     9       14     27   149 108 0 31         6     4   77 72     9   14   27   149
1520325 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001895 661100010003 GEORGE M DAVIS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_4 41.0 20.0 27.0   1.0     14.0     3.0   52.0 54.0     9       40     26   106 41 20 27   1     14     3   52 54     9   40   26   106

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