Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_4" and state = "NY" sorted by native_american_alaskan_native 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
754059 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002209 321200010047 PS 47 JOHN RANDOLPH public Regular School No 1.0 KG 05 2015   grade_4 5.0 33.0 119.0   9.0     19.0     0.0   88.0 97.0             176     32   185 5 33 119   9     19     0   88 97         176   32   185
801293 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No 1 PK 06 2015   grade_4 35.0   1.0   9.0     0.0     2.0   17.0 30.0             19     8   47 35   1   9     0     2   17 30         19   8   47
810736 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010004734 342800010161 PS 161 ARTHUR ASHE SCHOOL public Regular School No 1 PK 05 2015   grade_4 4.0 4.0 20.0   9.0     59.0     0.0   56.0 40.0             87     18   96 4 4 20   9     59     0   56 40         87   18   96
949413 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802092 321100010016 PS 16 WAKEFIELD public Regular School No Elementary PK 05 2017   grade_4 1.0 38.0 18.0   9.0     3.0     0.0   36.0 33.0     *       66     23   69 1 38 18   9     3     0   36 33         66   23   69
969648 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502833 331700010398 PS 398 WALTER WEAVER public Regular School No Elementary PK 5 2017   grade_4 0.0 30.0 6.0   9.0     0.0     0.0   22.0 23.0     6       42     17   45 0 30 6   9     0     0   22 23     6   42   17   45
1005691 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302365 342700010096 PS 96 public Regular School No Elementary PK 05 2017   grade_4 1.0 8.0 7.0   9.0     13.0     0.0   25.0 13.0     *       28     *   38 1 8 7   9     13     0   25 13         28       38
1006869 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002333 342800010086 PS 86 public Regular School No Elementary PK 06 2017   grade_4 10.0 10.0 66.0   9.0     71.0     0.0   73.0 93.0     44       83     38   166 10 10 66   9     71     0   73 93     44   83   38   166
1084807 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4     0.0   9.0           2.0   6.0 5.0             10     *   11     0   9           2   6 5         10       11
1092958 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No 1.0 KG 05 2016   grade_4 5.0 0.0 88.0   9.0     107.0         103.0 106.0             191     *   209 5 0 88   9     107         103 106         191       209
1095694 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302516 342700010065 PS 65 RAYMOND YORK ELEM SCH (THE) public Regular School No 1.0 KG 05 2016   grade_4 3.0 10.0 23.0   9.0     38.0     0.0   44.0 39.0             46     13   83 3 10 23   9     38     0   44 39         46   13   83
1445503 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003665 61501040003 SILVER CREEK ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 51.0 0.0 12.0   9.0     0.0     11.0   38.0 45.0     *       48     14   83 51 0 12   9     0     11   38 45         48   14   83
1453160 NY Erie   school 3602430 142101040000   AKRON 360243000012 142101040001 AKRON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 66.0 0.0 0.0   9.0     0.0     8.0   34.0 49.0     *       31     10   83 66 0 0   9     0     8   34 49         31   10   83
1499064 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No Elementary KG 05 2021   grade_4 3.0 22.0 117.0   9.0     94.0     0.0   126.0 119.0     77       179     *   245 3 22 117   9     94     0   126 119     77   179       245
1586806 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302259 342700010060 PS 60 WOODHAVEN public Regular School No Elementary PK 05 2020   grade_4 9.0 5.0 134.0   9.0     22.0     1.0   92.0 88.0     29       151     33   180 9 5 134   9     22     1   92 88     29   151   33   180
1589029 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No Elementary PK 05 2020   grade_4 6.0 27.0 40.0   9.0     75.0     3.0   88.0 72.0     15       124     26   160 6 27 40   9     75     3   88 72     15   124   26   160
1589067 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102162 342900010035 PS 35 NATHANIEL WOODHULL public Regular School No Elementary PK 05 2020   grade_4 4.0 47.0 37.0   9.0     31.0     1.0   68.0 61.0     22       109     24   129 4 47 37   9     31     1   68 61     22   109   24   129
2115159 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102162 342900010035 PS 35 NATHANIEL WOODHULL public Regular School No Elementary PK 05 2018   grade_4 5.0 30.0 28.0   9.0     26.0     1.0   51.0 48.0     19       87     17   99 5 30 28   9     26     1   51 48     19   87   17   99
2151354 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003665 61501040003 SILVER CREEK ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 56.0 0.0 2.0   9.0     1.0     3.0   33.0 38.0     *       42     16   71 56 0 2   9     1     3   33 38         42   16   71
2159049 NY Erie   school 3602430 142101040000   AKRON 360243000012 142101040001 AKRON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_4 76.0 2.0 3.0   9.0     0.0     6.0   45.0 51.0     *       51     10   96 76 2 3   9     0     6   45 51         51   10   96
2203775 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002222 342800010050 PS 50 TALFOURD LAWN ELEMENTARY public Regular School No Elementary PK 05 2019   grade_4 2.0 32.0 56.0   9.0     24.0         60.0 63.0     18       112     25   123 2 32 56   9     24         60 63     18   112   25   123
2203946 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002437 342800010117 PS 117 J KELD/BRIARWOOD SCHOOL public Regular School No Elementary PK 05 2019   grade_4 21.0 23.0 63.0   9.0     51.0     4.0   92.0 79.0     23       115     36   171 21 23 63   9     51     4   92 79     23   115   36   171
773059 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502833 331700010398 PS 398 WALTER WEAVER public Regular School No 1 PK 5 2015   grade_4 0.0 39.0 14.0   8.0     0.0         32.0 29.0             58     13   61 0 39 14   8     0         32 29         58   13   61
774617 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002275 331900010065 PS 65 public Regular School No 1 KG 5 2015   grade_4 0.0 20.0 99.0   8.0     1.0     0.0   66.0 62.0             86     17   128 0 20 99   8     1     0   66 62         86   17   128
795783 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902694 310400010206 PS 206 JOSE CELSO BARBOSA public Regular School No 1 03 08 2015   grade_4 6.0 21.0 49.0   8.0     4.0     0.0   51.0 37.0             62     40   88 6 21 49   8     4     0   51 37         62   40   88
811838 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010105545 342900010268 PS/IS 268 public Regular School No 1 KG 08 2015   grade_4 0.0 19.0 14.0   8.0     25.0     0.0   33.0 33.0             55     8   66 0 19 14   8     25     0   33 33         55   8   66
947760 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702179 321000010020 PS/MS 20 PO GEORGE J WERDAN III public Regular School No Elementary PK 08 2017   grade_4 11.0 12.0 89.0   8.0     19.0     0.0   57.0 82.0     30       128     42   139 11 12 89   8     19     0   57 82     30   128   42   139
997540 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Elementary PK 08 2017   grade_4         8.0           0.0   2.0 6.0             8     0   8         8           0   2 6         8   0   8
1005577 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302265 342700010062 PS 62 CHESTER PARK SCHOOL public Regular School No Elementary PK 05 2017   grade_4 5.0 4.0 41.0   8.0     111.0     1.0   92.0 78.0     22       88     19   170 5 4 41   8     111     1   92 78     22   88   19   170
1006755 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002222 342800010050 PS 50 TALFOURD LAWN ELEMENTARY SCH public Regular School No Elementary PK 06 2017   grade_4 1.0 30.0 35.0   8.0     28.0     1.0   51.0 52.0     11       99     24   103 1 30 35   8     28     1   51 52     11   99   24   103
1096815 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002241 342800010055 PS 55 MAURE public Regular School No 1.0 PK 05 2016   grade_4 2.0 11.0 16.0   8.0     43.0     1.0   32.0 49.0             66     16   81 2 11 16   8     43     1   32 49         66   16   81
1097005 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002510 342800010140 PS 140 EDWARD K ELLINGTON public Regular School No 1.0 PK 05 2016   grade_4 2.0 61.0 9.0   8.0     3.0     0.0   45.0 38.0             75     19   83 2 61 9   8     3     0   45 38         75   19   83
1510369 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_4 62.0 3.0 20.0   8.0     1.0         45.0 49.0     6       35     16   94 62 3 20   8     1         45 49     6   35   16   94
1555266 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302660 332200010193 PS 193 GIL HODGES public Regular School No Elementary PK 05 2020   grade_4 22.0 50.0 10.0   8.0     24.0     3.0   61.0 56.0     18       80     30   117 22 50 10   8     24     3   61 56     18   80   30   117
1576014 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_4     0.0   8.0           3.0   7.0 4.0             5     *   11     0   8           3   7 4         5       11
1586882 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302516 342700010065 PS 65 RAYMOND YORK ELEMENTARY public Regular School No Elementary PK 05 2020   grade_4 1.0 3.0 37.0   8.0     30.0     0.0   44.0 35.0     5       62     16   79 1 3 37   8     30     0   44 35     5   62   16   79
1587281 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302728 342700010223 PS 223 LYNDON B JOHNSON public Regular School No Elementary PK 05 2020   grade_4 2.0 45.0 13.0   8.0     13.0     0.0   47.0 34.0     *       66     21   81 2 45 13   8     13     0   47 34         66   21   81
1589409 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102617 342900010176 PS 176 CAMBRIA HEIGHTS public Regular School No Elementary PK 05 2020   grade_4 1.0 83.0 3.0   8.0     5.0     1.0   50.0 51.0     *       64     15   101 1 83 3   8     5     1   50 51         64   15   101
1594748 NY Saint Lawrence   school 3618660 512001060000   MASSENA 361866001691 512001060001 JEFFERSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_4 36.0 0.0 0.0   8.0           0.0   20.0 24.0     *       35     11   44 36 0 0   8           0   20 24         35   11   44
2104918 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Other PK 09 2018   grade_4     0.0   8.0     0.0     0.0   6.0 2.0             7     *   8     0   8     0     0   6 2         7       8
2112936 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302259 342700010060 PS 60 WOODHAVEN public Regular School No Elementary PK 05 2018   grade_4 8.0 1.0 146.0   8.0     34.0     3.0   112.0 88.0     32       171     49   200 8 1 146   8     34     3   112 88     32   171   49   200
2113221 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302454 342700010123 PS 123 public Regular School No Elementary PK 05 2018   grade_4 2.0 59.0 18.0   8.0     14.0     0.0   51.0 50.0     5       85     26   101 2 59 18   8     14     0   51 50     5   85   26   101
2130017 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003743 580906030001 SOUTHAMPTON ELEMENTARY SCHOOL public Regular School No Elementary PK 07 2018   grade_4 36.0 0.0 35.0   8.0     0.0     3.0   37.0 45.0     22       37     9   82 36 0 35   8     0     3   37 45     22   37   9   82
2146699 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2019   grade_4 6.0 95.0 82.0   8.0     6.0     0.0   107.0 90.0     37       174     46   197 6 95 82   8     6     0   107 90     37   174   46   197
2158403 NY Erie   school 3616560 141401060000   EVANS-BRANT 361656001462 141401060008 A J SCHMIDT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 46.0   4.0   8.0     1.0     0.0   32.0 27.0             27     12   59 46   4   8     1     0   32 27         27   12   59
2202654 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302365 342700010096 PS 96 public Regular School No Elementary PK 05 2019   grade_4 1.0 9.0 8.0   8.0     17.0     0.0   25.0 18.0     5       34     10   43 1 9 8   8     17     0   25 18     5   34   10   43
2202825 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302460 342700010124 PS 124 OSMOND A CHURCH public Regular School No Elementary KG 08 2019   grade_4 1.0 30.0 23.0   8.0     61.0     0.0   65.0 58.0     *       82     17   123 1 30 23   8     61     0   65 58         82   17   123
2203794 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002236 342800010054 PS 54 HILLSIDE public Regular School No Elementary KG 05 2019   grade_4 2.0 5.0 55.0   8.0     34.0     1.0   54.0 51.0     31       81     21   105 2 5 55   8     34     1   54 51     31   81   21   105
2204079 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010004734 342800010161 PS 161 ARTHUR ASHE SCHOOL public Regular School No Elementary PK 05 2019   grade_4 3.0 5.0 11.0   8.0     63.0     1.0   49.0 42.0     8       75     16   91 3 5 11   8     63     1   49 42     8   75   16   91
2216125 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 73.0 4.0 21.0   8.0     1.0     1.0   54.0 54.0     8       25     21   108 73 4 21   8     1     1   54 54     8   25   21   108
752919 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No 1.0 KG 05 2015   grade_4 5.0 81.0 65.0   7.0     6.0     0.0   93.0 71.0             141     42   164 5 81 65   7     6     0   93 71         141   42   164
764452 NY Erie   school 3616560 141401060000   EVANS-BRANT 361656001462 141401060008 A J SCHMIDT ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   grade_4 44.0 0.0 1.0   7.0     1.0     2.0   29.0 26.0             32     6   55 44 0 1   7     1     2   29 26         32   6   55
810717 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002574 342800010160 PS 160 WALTER FRANCIS BISHOP public Regular School No 1 PK 05 2015   grade_4 0.0 63.0 23.0   7.0     11.0     1.0   52.0 53.0             89     34   105 0 63 23   7     11     1   52 53         89   34   105
982036 NY Nassau   school 3611550 280209030000   FREEPORT 361155000909 280209030001 ARCHER STREET SCHOOL public Regular School No Elementary KG 04 2017   grade_4 7.0 31.0 84.0   7.0     1.0     1.0   64.0 67.0     26       108     17   131 7 31 84   7     1     1   64 67     26   108   17   131
997578 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No Elementary PK 06 2017   grade_4 33.0 0.0 1.0   7.0     0.0     0.0   15.0 26.0             17     *   41 33 0 1   7     0     0   15 26         17       41
997939 NY Onondaga   school 3621810 421201040000   ONONDAGA 362181003100 421201040002 WHEELER ELEMENTARY SCHOOL public Regular School No Elementary 03 06 2017   grade_4 47.0 9.0 2.0   7.0     1.0     1.0   34.0 33.0     *       35     15   67 47 9 2   7     1     1   34 33         35   15   67
1007705 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No Elementary KG 05 2017   grade_4 7.0 25.0 45.0   7.0     79.0     3.0   91.0 75.0     16       134     19   166 7 25 45   7     79     3   91 75     16   134   19   166
1007743 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102162 342900010035 PS 35 NATHANIEL WOODHULL public Regular School No Elementary PK 05 2017   grade_4 2.0 52.0 35.0   7.0     34.0     1.0   63.0 68.0     19       116     26   131 2 52 35   7     34     1   63 68     19   116   26   131
1039378 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802336 321100010087 PS 87 public Regular School No 1.0 KG 05 2016   grade_4 2.0 85.0 15.0   7.0     7.0     1.0   62.0 55.0             101     29   117 2 85 15   7     7     1   62 55         101   29   117
1040898 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003369 321200010196 PS 196 public Regular School No 1.0 PK 05 2016   grade_4 2.0 25.0 109.0   7.0     0.0     0.0   73.0 70.0             110     32   143 2 25 109   7     0     0   73 70         110   32   143
1063261 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202552 332100010153 PS 153 HOMECREST public Regular School No 1.0 PK 5 2016   grade_4 32.0 4.0 22.0   7.0     14.0     0.0   37.0 42.0             49     23   79 32 4 22   7     14     0   37 42         49   23   79
1098221 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010105545 342900010268 PS/IS 268 public Regular School No 1.0 KG 08 2016   grade_4 0.0 18.0 8.0   7.0     11.0     2.0   23.0 23.0             34     8   46 0 18 8   7     11     2   23 23         34   8   46
1444439 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_4 57.0 1.0 1.0   7.0           0.0   38.0 28.0             29     10   66 57 1 1   7           0   38 28         29   10   66
1488671 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No Elementary PK 06 2021   grade_4 30.0 0.0 1.0   7.0     0.0     1.0   24.0 15.0             15     *   39 30 0 1   7     0     1   24 15         15       39
1498266 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010004734 342800010161 PS 161 ARTHUR ASHE SCHOOL public Regular School No Elementary PK 05 2021   grade_4 2.0 4.0 11.0   7.0     65.0     1.0   44.0 46.0     13       75     10   90 2 4 11   7     65     1   44 46     13   75   10   90
1498912 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No Elementary PK 05 2021   grade_4 5.0 17.0 43.0   7.0     76.0     4.0   72.0 80.0     34       108     20   152 5 17 43   7     76     4   72 80     34   108   20   152
1556178 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102805 332300010298 PS 298 DR BETTY SHABAZZ public Regular School No Elementary PK 05 2020   grade_4 0.0 23.0 4.0   7.0     0.0     0.0   16.0 18.0     *       *     9   34 0 23 4   7     0     0   16 18             9   34
1578826 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No Elementary PK 06 2020   grade_4 37.0 1.0 0.0   7.0     0.0     1.0   24.0 22.0             18     *   46 37 1 0   7     0     1   24 22         18       46
1588193 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002333 342800010086 PS 86 public Regular School No Elementary PK 05 2020   grade_4 4.0 4.0 44.0   7.0     53.0     1.0   62.0 51.0     36       100     19   113 4 4 44   7     53     1   62 51     36   100   19   113
1604039 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003743 580906030001 SOUTHAMPTON ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_4 34.0 1.0 52.0   7.0     2.0     1.0   47.0 50.0     31       57     16   97 34 1 52   7     2     1   47 50     31   57   16   97
2076950 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502833 331700010398 PS 398 WALTER WEAVER public Regular School No Elementary PK 05 2018   grade_4 0.0 35.0 5.0   7.0     0.0     0.0   25.0 22.0     8       46     15   47 0 35 5   7     0     0   25 22     8   46   15   47
2104956 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No Elementary PK 06 2018   grade_4 41.0 0.0 2.0   7.0     0.0     2.0   27.0 25.0             27     *   52 41 0 2   7     0     2   27 25         27       52
2112955 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302265 342700010062 PS 62 CHESTER PARK SCHOOL public Regular School No Elementary PK 05 2018   grade_4 3.0 8.0 30.0   7.0     88.0     0.0   68.0 68.0     20       106     23   136 3 8 30   7     88     0   68 68     20   106   23   136
2114456 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002574 342800010160 PS 160 WALTER FRANCIS BISHOP public Regular School No Elementary PK 05 2018   grade_4 0.0 52.0 24.0   7.0     19.0     0.0   53.0 49.0     5       84     32   102 0 52 24   7     19     0   53 49     5   84   32   102
2194541 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No Elementary PK 06 2019   grade_4 43.0 2.0 1.0   7.0     1.0     3.0   28.0 29.0             26     10   57 43 2 1   7     1     3   28 29         26   10   57
810622 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002448 342800010121 PS 121 public Regular School No 1 PK 05 2015   grade_4 1.0 23.0 13.0   65.0     42.0     0.0   77.0 67.0             127     25   144 1 23 13   65     42     0   77 67         127   25   144
766162 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003525 161201040001 ST REGIS MOHAWK SCHOOL public Regular School No 1 PK 5 2015   grade_4 1.0   0.0   60.0           0.0   27.0 34.0             55     10   61 1   0   60           0   27 34         55   10   61
809748 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302728 342700010223 PS 223 LYNDON B JOHNSON public Regular School No 1 PK 05 2015   grade_4 1.0 63.0 16.0   6.0     1.0     3.0   45.0 45.0             78     17   90 1 63 16   6     1     3   45 45         78   17   90
810793 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010004611 342800010182 PS 182 SAMANTHA SMITH public Regular School No 1 KG 05 2015   grade_4 3.0 33.0 113.0   6.0     62.0     4.0   126.0 95.0             206     47   221 3 33 113   6     62     4   126 95         206   47   221
822801 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_4 89.0 4.0 12.0   6.0     3.0         51.0 63.0             30     20   114 89 4 12   6     3         51 63         30   20   114
945119 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502441 320800010119 EMMETT W BASSETT SCHOOL public Regular School No Elementary PK 05 2017   grade_4 9.0 16.0 95.0   6.0     52.0     0.0   84.0 94.0     53       126     28   178 9 16 95   6     52     0   84 94     53   126   28   178
949641 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2017   grade_4 2.0 118.0 94.0   6.0     4.0     1.0   97.0 128.0     34       197     48   225 2 118 94   6     4     1   97 128     34   197   48   225
950819 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002209 321200010047 PS 47 JOHN RANDOLPH public Regular School No Elementary KG 05 2017   grade_4 3.0 30.0 142.0   6.0     20.0     1.0   93.0 109.0     50       191     30   202 3 30 142   6     20     1   93 109     50   191   30   202
953213 NY Cattaraugus   school 3624090 43001040000   RANDOLPH 362409003320 43001040003 G N CHAPMAN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4 55.0 0.0 1.0   6.0           2.0   32.0 32.0             41     12   64 55 0 1   6           2   32 32         41   12   64
959255 NY Erie   school 3605850 140600010000   BUFFALO 360585000324 140600010019 NATIVE AMERICAN MAGNET public Regular School No Elementary PK 8 2017   grade_4 8.0 22.0 11.0   6.0     13.0     0.0   30.0 30.0     24       51     17   60 8 22 11   6     13     0   30 30     24   51   17   60
982169 NY Nassau   school 3611550 280209030000   FREEPORT 361155001636 280209030009 NEW VISIONS ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   grade_4 13.0 22.0 71.0   6.0     6.0     1.0   64.0 55.0     25       79     17   119 13 22 71   6     6     1   64 55     25   79   17   119
982796 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001502 280215030005 LAWRENCE ELEMENTARY SCHOOL-BROADWAY public Regular School No Elementary 03 05 2017   grade_4 30.0 34.0 101.0   6.0     9.0     0.0   97.0 83.0     *       147     23   180 30 34 101   6     9     0   97 83         147   23   180
1006926 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002437 342800010117 PS 117 J KELD/BRIARWOOD SCHOOL public Regular School No Elementary PK 05 2017   grade_4 29.0 19.0 62.0   6.0     59.0     4.0   83.0 96.0     17       80     36   179 29 19 62   6     59     4   83 96     17   80   36   179
1013329 NY Saint Lawrence   school 3618660 512001060000   MASSENA 361866001691 512001060001 JEFFERSON ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4 57.0 3.0 1.0   6.0     2.0     0.0   33.0 36.0             53     14   69 57 3 1   6     2     0   33 36         53   14   69
1039777 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805558 321100010194 PS/MS 194 public Regular School No 1.0 KG 08 2016   grade_4 4.0 13.0 90.0   6.0     54.0     0.0   98.0 69.0             112     29   167 4 13 90   6     54     0   98 69         112   29   167
1059632 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502833 331700010398 PS 398 WALTER WEAVER public Regular School No 1.0 PK 5 2016   grade_4 0.0 39.0 7.0   6.0     0.0         25.0 27.0             44     21   52 0 39 7   6     0         25 27         44   21   52
1064021 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302660 332200010193 PS 193 GIL HODGES public Regular School No 1.0 PK 5 2016   grade_4 28.0 78.0 20.0   6.0     20.0     2.0   85.0 69.0             121     28   154 28 78 20   6     20     2   85 69         121   28   154
1081729 NY New York   school 3600169 310300860897   SUCCESS ACAD-HARLEM 1 360016905862 310300860897 SUCCESS ACADEMY CHARTER-HARLEM 1 charter Regular School Yes 4.0 PK 10 2016   grade_4 1.0 79.0 26.0   6.0     1.0     1.0   60.0 54.0             86     21   114 1 79 26   6     1     1   60 54         86   21   114
1095618 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302259 342700010060 PS 60 WOODHAVEN public Regular School No 1.0 PK 05 2016   grade_4 12.0 8.0 145.0   6.0     25.0     3.0   97.0 102.0             171     30   199 12 8 145   6     25     3   97 102         171   30   199
1095922 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302460 342700010124 PS 124 OSMOND A CHURCH public Regular School No 1.0 KG 08 2016   grade_4 4.0 25.0 39.0   6.0     87.0     0.0   91.0 70.0             79     18   161 4 25 39   6     87     0   91 70         79   18   161
1096093 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302728 342700010223 PS 223 LYNDON B JOHNSON public Regular School No 1.0 PK 05 2016   grade_4 2.0 69.0 12.0   6.0     5.0     0.0   53.0 41.0             86     25   94 2 69 12   6     5     0   53 41         86   25   94
1097708 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No 1.0 KG 05 2016   grade_4 10.0 24.0 42.0   6.0     83.0     0.0   80.0 85.0             136     23   165 10 24 42   6     83     0   80 85         136   23   165
1097746 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102162 342900010035 PS 35 NATHANIEL WOODHULL public Regular School No 1.0 PK 05 2016   grade_4 5.0 36.0 31.0   6.0     31.0     0.0   52.0 57.0             91     19   109 5 36 31   6     31     0   52 57         91   19   109
1103389 NY Saint Lawrence   school 3618660 512001060000   MASSENA 361866001691 512001060001 JEFFERSON ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 49.0 0.0 0.0   6.0     0.0     0.0   25.0 30.0             40     13   55 49 0 0   6     0     0   25 30         40   13   55
1103427 NY Saint Lawrence   school 3618660 512001060000   MASSENA 361866001696 512001060005 NIGHTENGALE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 55.0 4.0 0.0   6.0     0.0     0.0   32.0 33.0             32     13   65 55 4 0   6     0     0   32 33         32   13   65
1109241 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_4 99.0 7.0 14.0   6.0     1.0         65.0 62.0             27     22   127 99 7 14   6     1         65 62         27   22   127

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