Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_1 · 33,145
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native ▲ asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
757549 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003665 61501040003 SILVER CREEK ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 50.0 0.0 8.0   9.0     1.0     8.0   36.0 40.0             55     9   76 50 0 8   9     1     8   36 40         55   9   76
773053 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_1 1.0 40.0 6.0   9.0     1.0         33.0 24.0             56     *   57 1 40 6   9     1         33 24         56       57
795359 NY New York   school 3600169 310300860897   SUCCESS ACAD-HARLEM 1 360016905862 310300860897 SUCCESS ACADEMY CHARTER-HARLEM 1 charter Regular School Yes 4 KG 09 2015   grade_1 3.0 74.0 21.0   9.0     4.0     0.0   55.0 56.0             100     8   111 3 74 21   9     4     0   55 56         100   8   111
809248 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302259 342700010060 PS 60 WOODHAVEN public Regular School No 1 PK 05 2015   grade_1 9.0 1.0 156.0   9.0     28.0     7.0   114.0 96.0             182     44   210 9 1 156   9     28     7   114 96         182   44   210
809552 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302460 342700010124 PS 124 OSMOND A CHURCH public Regular School No 1 KG 08 2015   grade_1 1.0 25.0 27.0   9.0     76.0     0.0   72.0 66.0             79     17   138 1 25 27   9     76     0   72 66         79   17   138
811357 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102162 342900010035 PS 35 NATHANIEL WOODHULL public Regular School No 1 PK 05 2015   grade_1 5.0 44.0 20.0   9.0     24.0     0.0   59.0 43.0             95     26   102 5 44 20   9     24     0   59 43         95   26   102
973290 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202619 332100010177 PS 177 MARLBORO (THE) public Regular School No Elementary PK 5 2017   grade_1 61.0 2.0 53.0   9.0     34.0     0.0   76.0 83.0     63       99     34   159 61 2 53   9     34     0   76 83     63   99   34   159
994722 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_1     0.0   9.0           1.0   7.0 3.0             7     *   10     0   9           1   7 3         7       10
997572 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No Elementary PK 06 2017   grade_1 43.0 0.0 1.0   9.0     0.0     1.0   25.0 29.0             26     *   54 43 0 1   9     0     1   25 29         26       54
1006312 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305883 342700010333 GOLDIE MAPLE ACADEMY public Regular School No Elementary PK 08 2017   grade_1 2.0 36.0 6.0   9.0     3.0     0.0   29.0 27.0             47     6   56 2 36 6   9     3     0   29 27         47   6   56
1007034 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002574 342800010160 PS 160 WALTER FRANCIS BISHOP public Regular School No Elementary PK 06 2017   grade_1 2.0 63.0 24.0   9.0     13.0     2.0   66.0 47.0     10       93     28   113 2 63 24   9     13     2   66 47     10   93   28   113
1008079 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102617 342900010176 PS 176 CAMBRIA HEIGHTS public Regular School No Elementary PK 05 2017   grade_1 1.0 69.0 6.0   9.0     3.0     1.0   39.0 50.0     *       67     6   89 1 69 6   9     3     1   39 50         67   6   89
1095650 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302268 342700010063 PS 63 OLD SOUTH public Regular School No 1.0 PK 05 2016   grade_1 16.0 15.0 96.0   9.0     66.0     1.0   96.0 107.0             171     34   203 16 15 96   9     66     1   96 107         171   34   203
1095859 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302405 342700010108 PS 108 CAPT VINCENT G FOWLER public Regular School No 1.0 PK 05 2016   grade_1 10.0 8.0 103.0   9.0     97.0     0.0   129.0 98.0             189     45   227 10 8 103   9     97     0   129 98         189   45   227
1096771 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002222 342800010050 PS 50 TALFOURD LAWN ELEMENTARY SCH public Regular School No 1.0 PK 05 2016   grade_1 3.0 43.0 55.0   9.0     25.0     0.0   71.0 64.0             116     26   135 3 43 55   9     25     0   71 64         116   26   135
1096790 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002236 342800010054 PS 54 HILLSIDE public Regular School No 1.0 KG 05 2016   grade_1 2.0 11.0 54.0   9.0     35.0     1.0   59.0 53.0             62     17   112 2 11 54   9     35     1   59 53         62   17   112
1097075 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010004734 342800010161 PS 161 ARTHUR ASHE SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 1.0 6.0 18.0   9.0     67.0     2.0   63.0 40.0             89     18   103 1 6 18   9     67     2   63 40         89   18   103
1109235 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_1 73.0 3.0 19.0   9.0     1.0         52.0 53.0             33     15   105 73 3 19   9     1         52 53         33   15   105
1544221 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003522 161201040003 SALMON RIVER ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_1 35.0   2.0   9.0           7.0   29.0 24.0             40     6   53 35   2   9           7   29 24         40   6   53
1555260 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_1 22.0 28.0 15.0   9.0     14.0     4.0   46.0 46.0     22       74     21   92 22 28 15   9     14     4   46 46     22   74   21   92
1587104 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302460 342700010124 PS 124 OSMOND A CHURCH public Regular School No Elementary KG 08 2020   grade_1 3.0 13.0 21.0   9.0     38.0     3.0   46.0 41.0     11       57     *   87 3 13 21   9     38     3   46 41     11   57       87
1589023 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_1 8.0 20.0 32.0   9.0     74.0     2.0   82.0 63.0     23       109     18   145 8 20 32   9     74     2   82 63     23   109   18   145
1604033 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003743 580906030001 SOUTHAMPTON ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_1 25.0 2.0 34.0   9.0     0.0     1.0   45.0 26.0     *       46     11   71 25 2 34   9     0     1   45 26         46   11   71
2059863 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000845 31501060014 ANN G MCGUINNESS ELEMENTARY public Regular School No Elementary KG 05 2018   grade_1 45.0 2.0 3.0   9.0     0.0     5.0   22.0 42.0             35     *   64 45 2 3   9     0     5   22 42         35       64
2069306 NY Erie   school 3602430 142101040000   AKRON 360243000012 142101040001 AKRON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_1 67.0 0.0 0.0   9.0     0.0     8.0   38.0 46.0     *       *     11   84 67 0 0   9     0     8   38 46             11   84
2114469 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010004734 342800010161 PS 161 ARTHUR ASHE SCHOOL public Regular School No Elementary PK 05 2018   grade_1 3.0 9.0 14.0   9.0     80.0     2.0   58.0 59.0     26       96     10   117 3 9 14   9     80     2   58 59     26   96   10   117
2115115 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No Elementary KG 05 2018   grade_1 7.0 22.0 40.0   9.0     84.0     4.0   87.0 79.0     42       136     21   166 7 22 40   9     84     4   87 79     42   136   21   166
2115153 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_1 1.0 44.0 33.0   9.0     33.0     1.0   58.0 63.0     14       107     16   121 1 44 33   9     33     1   58 63     14   107   16   121
2204054 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002574 342800010160 PS 160 WALTER FRANCIS BISHOP public Regular School No Elementary PK 05 2019   grade_1 3.0 32.0 16.0   9.0     9.0     6.0   35.0 40.0     8       64     12   75 3 32 16   9     9     6   35 40     8   64   12   75
810445 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002236 342800010054 PS 54 HILLSIDE public Regular School No 1 KG 05 2015   grade_1 2.0 3.0 63.0   8.0     34.0     0.0   61.0 49.0             67     *   110 2 3 63   8     34     0   61 49         67       110
810654 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002510 342800010140 PS 140 EDWARD K ELLINGTON public Regular School No 1 PK 05 2015   grade_1 0.0 60.0 14.0   8.0     4.0         47.0 39.0             79     17   86 0 60 14   8     4         47 39         79   17   86
974031 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302660 332200010193 PS 193 GIL HODGES public Regular School No Elementary PK 5 2017   grade_1 33.0 63.0 9.0   8.0     26.0     3.0   72.0 70.0     34       103     37   142 33 63 9   8     26     3   72 70     34   103   37   142
1007053 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010004734 342800010161 PS 161 ARTHUR ASHE SCHOOL public Regular School No Elementary PK 06 2017   grade_1 2.0 9.0 24.0   8.0     83.0     2.0   61.0 67.0     25       114     14   128 2 9 24   8     83     2   61 67     25   114   14   128
1022633 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003743 580906030001 SOUTHAMPTON ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_1 38.0 5.0 46.0   8.0     1.0     0.0   51.0 47.0     30       60     17   98 38 5 46   8     1     0   51 47     30   60   17   98
1044160 NY Chautauqua   school 3626880 61501040000   SILVER CREEK 362688003665 61501040003 SILVER CREEK ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 56.0 0.0 1.0   8.0     1.0     7.0   37.0 36.0             44     11   73 56 0 1   8     1     7   37 36         44   11   73
1095916 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_1 2.0 24.0 20.0   8.0     56.0     0.0   62.0 48.0             *     14   110 2 24 20   8     56     0   62 48             14   110
1096087 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_1 2.0 61.0 19.0   8.0     13.0     3.0   60.0 46.0             95     19   106 2 61 19   8     13     3   60 46         95   19   106
1096372 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305883 342700010333 GOLDIE MAPLE ACADEMY public Regular School No 1.0 PK 08 2016   grade_1 1.0 52.0 10.0   8.0     5.0     1.0   48.0 29.0             60     11   77 1 52 10   8     5     1   48 29         60   11   77
1096942 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002437 342800010117 PS 117 J KELD/BRIARWOOD SCHOOL public Regular School No 1.0 PK 06 2016   grade_1 27.0 18.0 71.0   8.0     56.0     3.0   101.0 82.0             66     25   183 27 18 71   8     56     3   101 82         66   25   183
1465181 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302660 332200010193 PS 193 GIL HODGES public Regular School No Elementary PK 05 2021   grade_1 33.0 35.0 16.0   8.0     11.0     5.0   55.0 53.0     25       76     17   108 33 35 16   8     11     5   55 53     25   76   17   108
1497158 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302728 342700010223 PS 223 LYNDON B JOHNSON public Regular School No Elementary PK 05 2021   grade_1 0.0 38.0 14.0   8.0     7.0     2.0   43.0 26.0     5       63     18   69 0 38 14   8     7     2   43 26     5   63   18   69
1498260 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_1 1.0 1.0 7.0   8.0     72.0     1.0   46.0 44.0     15       75     13   90 1 1 7   8     72     1   46 44     15   75   13   90
1526247 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502441 320800010119 DR EMMETT W BASSETT SCHOOL (THE) public Regular School No Elementary PK 05 2020   grade_1 5.0 9.0 58.0   8.0     29.0     1.0   55.0 55.0     34       97     15   110 5 9 58   8     29     1   55 55     34   97   15   110
1578820 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No Elementary PK 06 2020   grade_1 26.0 1.0 0.0   8.0     0.0     0.0   15.0 20.0             14     *   35 26 1 0   8     0     0   15 20         14       35
1587275 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_1 1.0 43.0 18.0   8.0     13.0     0.0   48.0 35.0     6       69     *   83 1 43 18   8     13     0   48 35     6   69       83
1600499 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_1 63.0 4.0 23.0   8.0     0.0     0.0   55.0 43.0     8       35     24   98 63 4 23   8     0     0   55 43     8   35   24   98
2058172 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002209 321200010047 PS 47 JOHN RANDOLPH public Regular School No Elementary KG 05 2018   grade_1 5.0 29.0 109.0   8.0     24.0     1.0   80.0 96.0     38       173     33   176 5 29 109   8     24     1   80 96     38   173   33   176
2112968 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302268 342700010063 PS 63 OLD SOUTH public Regular School No Elementary PK 05 2018   grade_1 11.0 7.0 93.0   8.0     63.0     3.0   88.0 97.0     24       160     31   185 11 7 93   8     63     3   88 97     24   160   31   185
2126477 NY Suffolk   school 3606840 580233020000   CENTER MORICHES 360684000469 580233020003 CLAYTON HUEY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_1 62.0 3.0 12.0   8.0     0.0         39.0 46.0     6       29     10   85 62 3 12   8     0         39 46     6   29   10   85
2142228 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502441 320800010119 DR EMMETT W BASSETT SCHOOL (THE) public Regular School No Elementary PK 05 2019   grade_1 15.0 8.0 59.0   8.0     23.0     0.0   51.0 62.0     46       98     *   113 15 8 59   8     23     0   51 62     46   98       113
2193870 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002996 420303060003 CICERO ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_1 86.0 0.0 3.0   8.0     5.0     3.0   57.0 48.0     *       29     22   105 86 0 3   8     5     3   57 48         29   22   105
2202553 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302268 342700010063 PS 63 OLD SOUTH public Regular School No Elementary PK 05 2019   grade_1 10.0 12.0 61.0   8.0     64.0     3.0   92.0 66.0     *       126     23   158 10 12 61   8     64     3   92 66         126   23   158
2202648 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302365 342700010096 PS 96 public Regular School No Elementary PK 05 2019   grade_1 0.0 7.0 8.0   8.0     12.0     1.0   17.0 19.0     7       32     *   36 0 7 8   8     12     1   17 19     7   32       36
2202800 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302454 342700010123 PS 123 public Regular School No Elementary PK 05 2019   grade_1 4.0 53.0 14.0   8.0     3.0     0.0   39.0 43.0     *       69     13   82 4 53 14   8     3     0   39 43         69   13   82
1586971 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302379 342700010100 PS 100 GLEN MORRIS public Regular School No Elementary PK 05 2020   grade_1 2.0 6.0 28.0   72.0     32.0     6.0   74.0 72.0     10       91     27   146 2 6 28   72     32     6   74 72     10   91   27   146
772730 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502631 331700010181 PS 181 public Regular School No 1 PK 8 2015   grade_1 5.0 90.0 10.0   7.0     0.0     1.0   63.0 50.0             92     23   113 5 90 10   7     0     1   63 50         92   23   113
778240 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102501 332300010137 PS/IS 137 RACHAEL JEAN MITCHELL public Regular School No 1 PK 08 2015   grade_1 0.0 19.0 6.0   7.0     1.0     0.0   16.0 17.0             27     5   33 0 19 6   7     1     0   16 17         27   5   33
809267 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302265 342700010062 PS 62 CHESTER PARK SCHOOL public Regular School No 1 PK 05 2015   grade_1 2.0 8.0 42.0   7.0     97.0     1.0   86.0 71.0             90     24   157 2 8 42   7     97     1   86 71         90   24   157
826367 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003743 580906030001 SOUTHAMPTON ELEMENTARY SCHOOL public Regular School No 1 PK 04 2015   grade_1 36.0 2.0 36.0   7.0     0.0         41.0 40.0             *     10   81 36 2 36   7     0         41 40             10   81
962954 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003522 161201040003 SALMON RIVER ELEMENTARY SCHOOL public Regular School No Elementary PK 5 2017   grade_1 34.0   4.0   7.0           5.0   23.0 27.0             38     *   50 34   4   7           5   23 27         38       50
969129 NY Kings   school 3601048 331600860975   EMBER CHARTER SCHOOL 360104806255 331600860975 EMBER CHARTER SCHOOL charter Regular School Yes Elementary KG 6 2017   grade_1 0.0 45.0 9.0   7.0     0.0     1.0   29.0 33.0     0       55     11   62 0 45 9   7     0     1   29 33     0   55   11   62
973271 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202552 332100010153 PS 153 HOMECREST public Regular School No Elementary PK 5 2017   grade_1 20.0 1.0 24.0   7.0     16.0     1.0   31.0 38.0     19       39     11   69 20 1 24   7     16     1   31 38     19   39   11   69
1005837 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302454 342700010123 PS 123 public Regular School No Elementary PK 05 2017   grade_1 3.0 67.0 21.0   7.0     10.0     2.0   59.0 51.0     *       102     19   110 3 67 21   7     10     2   59 51         102   19   110
1007927 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102483 342900010131 PS 131 ABIGAIL ADAMS public Regular School No Elementary KG 05 2017   grade_1 8.0 8.0 16.0   7.0     94.0     1.0   76.0 58.0     23       110     27   134 8 8 16   7     94     1   76 58     23   110   27   134
1040892 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003369 321200010196 PS 196 public Regular School No 1.0 PK 05 2016   grade_1 0.0 32.0 125.0   7.0     1.0     0.0   88.0 77.0             133     33   165 0 32 125   7     1     0   88 77         133   33   165
1049081 NY Erie   school 3605850 140600010000   BUFFALO 360585000324 140600010019 NATIVE AMERICAN MAGNET public Regular School No 1.0 PK 8 2016   grade_1 2.0 17.0 5.0   7.0     13.0     3.0   28.0 19.0             42     10   47 2 17 5   7     13     3   28 19         42   10   47
1051076 NY Erie   school 3616560 141401060000   EVANS-BRANT 361656001462 141401060008 A J SCHMIDT ELEMENTARY SCHOOL public Regular School No 1.0 KG 5 2016   grade_1 50.0 0.0 4.0   7.0     0.0     2.0   33.0 30.0             18     11   63 50 0 4   7     0     2   33 30         18   11   63
1062324 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102385 332000010102 PS 102 BAYVIEW (THE) public Regular School No 1.0 KG 5 2016   grade_1 140.0 2.0 69.0   7.0     39.0     5.0   133.0 129.0             161     51   262 140 2 69   7     39     5   133 129         161   51   262
1095688 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_1 6.0 1.0 39.0   7.0     26.0     0.0   33.0 46.0             46     *   79 6 1 39   7     26     0   33 46         46       79
1095726 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302345 342700010090 PS 90 HORACE MANN public Regular School No 1.0 PK 05 2016   grade_1 8.0 8.0 73.0   7.0     46.0     3.0   74.0 71.0             127     27   145 8 8 73   7     46     3   74 71         127   27   145
1098082 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102617 342900010176 PS 176 CAMBRIA HEIGHTS public Regular School No 1.0 PK 05 2016   grade_1 0.0 76.0 4.0   7.0     6.0     1.0   43.0 51.0             75     *   94 0 76 4   7     6     1   43 51         75       94
1437650 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604459 320900010199 PS 199 SHAKESPEARE SCHOOL (THE) public Regular School No Elementary PK 05 2021   grade_1 0.0 17.0 60.0   7.0     0.0     1.0   45.0 40.0     *       84     11   85 0 17 60   7     0     1   45 40         84   11   85
1478747 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504781 307500014233 PS 233 public Special Education School No Other KG 12 2021   grade_1 3.0 21.0 18.0   7.0     6.0     5.0   50.0 10.0     6       40     60   60 3 21 18   7     6     5   50 10     6   40   60   60
1496626 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012301790 342700010051 PS 51 public Regular School No Elementary PK 01 2021   grade_1 13.0 5.0 34.0   7.0     27.0     2.0   48.0 40.0     23       65     12   88 13 5 34   7     27     2   48 40     23   65   12   88
1498241 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002574 342800010160 PS 160 WALTER FRANCIS BISHOP public Regular School No Elementary PK 05 2021   grade_1 1.0 37.0 24.0   7.0     15.0     3.0   35.0 52.0     15       73     10   87 1 37 24   7     15     3   35 52     15   73   10   87
1498944 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102162 342900010035 PS 35 NATHANIEL WOODHULL public Regular School No Elementary PK 05 2021   grade_1 4.0 28.0 25.0   7.0     28.0     3.0   54.0 41.0     13       75     14   95 4 28 25   7     28     3   54 41     13   75   14   95
1513897 NY Suffolk   school 3627540 580906030000   SOUTHAMPTON 362754003743 580906030001 SOUTHAMPTON ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_1 29.0 1.0 43.0   7.0     3.0     1.0   43.0 41.0     33       52     10   84 29 1 43   7     3     1   43 41     33   52   10   84
1562404 NY Nassau   school 3600997 280201860934   ACADEMY CHARTER SCHOOL 360099706131 280201860934 ACADEMY CHARTER SCHOOL charter Regular School Yes Other PK 12 2020   grade_1 2.0 68.0 149.0   7.0     1.0     3.0   117.0 113.0     81       215     6   230 2 68 149   7     1     3   117 113     81   215   6   230
1578782 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Other PK 11 2020   grade_1     0.0   7.0     1.0         7.0 1.0             7     *   8     0   7     1         7 1         7       8
1587598 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012306606 342700010377 PS 377 public Regular School No Elementary PK 02 2020   grade_1 7.0 5.0 35.0   7.0     12.0     0.0   40.0 26.0     7       45     12   66 7 5 35   7     12     0   40 26     7   45   12   66
1588244 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 2020   grade_1 18.0 14.0 50.0   7.0     45.0     4.0   86.0 52.0     24       84     32   138 18 14 50   7     45     4   86 52     24   84   32   138
1589061 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_1 8.0 38.0 28.0   7.0     34.0     3.0   63.0 55.0     19       101     19   118 8 38 28   7     34     3   63 55     19   101   19   118
2070351 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003522 161201040003 SALMON RIVER ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 28.0   2.0   7.0           2.0   20.0 19.0             31     *   39 28   2   7           2   20 19         31       39
2104950 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001447 420807040004 C GRANT GRIMSHAW SCHOOL public Regular School No Elementary PK 06 2018   grade_1 38.0 0.0 1.0   7.0     0.0     1.0   28.0 19.0             26     10   47 38 0 1   7     0     1   28 19         26   10   47
2113025 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302278 342700010066 PS 66 JACQUELINE KENNEDY-ONASSIS public Regular School No Elementary PK 05 2018   grade_1 8.0 4.0 41.0   7.0     7.0     1.0   36.0 32.0     35       60     16   68 8 4 41   7     7     1   36 32     35   60   16   68
2202515 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302259 342700010060 PS 60 WOODHAVEN public Regular School No Elementary PK 05 2019   grade_1 3.0 11.0 105.0   7.0     27.0     0.0   80.0 73.0     32       122     26   153 3 11 105   7     27     0   80 73     32   122   26   153
2203864 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002322 342800010082 PS 82 HAMMOND public Regular School No Elementary KG 05 2019   grade_1 2.0 10.0 76.0   7.0     14.0     1.0   60.0 50.0     31       100     22   110 2 10 76   7     14     1   60 50     31   100   22   110
2202686 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302379 342700010100 PS 100 GLEN MORRIS public Regular School No Elementary PK 05 2019   grade_1 4.0 6.0 34.0   68.0     37.0     2.0   60.0 91.0     17       92     22   151 4 6 34   68     37     2   60 91     17   92   22   151
2160050 NY Franklin   school 3625500 161201040000   SALMON RIVER 362550003525 161201040001 ST REGIS MOHAWK SCHOOL public Regular School No Elementary PK 05 2019   grade_1 2.0   1.0   63.0           3.0   35.0 34.0             60     7   69 2   1   63           3   35 34         60   7   69
746947 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No 1.0 PK 05 2015   grade_1 2.0 18.0 59.0   6.0     3.0     1.0   51.0 38.0             82     22   89 2 18 59   6     3     1   51 38         82   22   89
754053 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_1 5.0 34.0 133.0   6.0     20.0     0.0   103.0 95.0             192     30   198 5 34 133   6     20     0   103 95         192   30   198
809191 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012301790 342700010051 PS 51 public Regular School No 1 PK 01 2015   grade_1 12.0 4.0 40.0   6.0     39.0     3.0   53.0 51.0             84     13   104 12 4 40   6     39     3   53 51         84   13   104
809742 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_1 0.0 65.0 19.0   6.0     6.0     1.0   56.0 41.0             89     26   97 0 65 19   6     6     1   56 41         89   26   97
950832 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002245 321200010057 PS 57 CRESCENT public Regular School No Elementary PK 05 2017   grade_1 2.0 22.0 70.0   6.0     0.0     0.0   45.0 55.0     14       86     24   100 2 22 70   6     0     0   45 55     14   86   24   100
974886 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102805 332300010298 PS 298 DR BETTY SHABAZZ public Regular School No Elementary PK 05 2017   grade_1 1.0 23.0 8.0   6.0     1.0     0.0   21.0 18.0     5       39     11   39 1 23 8   6     1     0   21 18     5   39   11   39
1007699 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_1 10.0 24.0 52.0   6.0     83.0     7.0   99.0 83.0     46       145     22   182 10 24 52   6     83     7   99 83     46   145   22   182
1007737 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_1 2.0 41.0 31.0   6.0     27.0     0.0   52.0 55.0     19       91     19   107 2 41 31   6     27     0   52 55     19   91   19   107
1009599 NY Queens   school 3600987 343000860952   GROWING UP GREEN CHARTER 360098706124 343000860952 GROWING UP GREEN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_1 29.0 6.0 36.0   6.0     10.0     6.0   45.0 48.0     10       39     20   93 29 6 36   6     10     6   45 48     10   39   20   93
1037909 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702357 321000010094 PS 94 KINGS COLLEGE SCHOOL public Regular School No 1.0 KG 05 2016   grade_1 5.0 23.0 156.0   6.0     13.0     2.0   99.0 106.0             194     36   205 5 23 156   6     13     2   99 106         194   36   205
1039220 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802092 321100010016 PS 16 WAKEFIELD public Regular School No 1.0 PK 05 2016   grade_1 1.0 39.0 19.0   6.0     2.0     1.0   33.0 35.0             63     18   68 1 39 19   6     2     1   33 35         63   18   68

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