Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_2", state = "NY" and year = 2019 sorted by white

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_2 · 4,719
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white ▼ black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2141130 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2019   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
2141225 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406613 320700010584 IS 584 public Regular School No Middle 06 08 2019   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
2141681 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2019   grade_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
2141871 NY Bronx   school 3601125 320700861070   FAMILY LIFE ACADEMY CHARTER 360112506479 320700861070 FAMILY LIFE ACADEMY CHARTER SCH III charter Regular School Yes Elementary KG 04 2019   grade_2   21.0 29.0   0.0     1.0     0.0   17.0 34.0     8       45     6   51   21 29   0     1     0   17 34     8   45   6   51
2143676 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602737 320900010229 IS 229 ROLAND PATTERSON public Regular School No Middle 06 08 2019   grade_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
2144037 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606629 320900010593 SOUTH BRONX INTERNATIONAL MS public Regular School No Middle 06 06 2019   grade_2   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
2144132 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605791 320900011250 EXIMIUS COLLEGE PREP ACADEMY public Regular School No High 09 12 2019   grade_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
2144284 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2019   grade_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
2144512 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2019   grade_2   20.0 22.0   0.0     0.0         23.0 19.0     6       35     *   42   20 22   0     0         23 19     6   35       42
2144778 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701748 321000010015 PS 15 INST FOR ENVIRON LRNG public Regular School No Elementary KG 08 2019   grade_2   5.0 44.0   1.0     2.0     0.0   21.0 31.0     12       43     *   52   5 44   1     2     0   21 31     12   43       52
2145310 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704731 321000010226 PS 226 public Regular School No Elementary PK 05 2019   grade_2   20.0 51.0   1.0     1.0         33.0 40.0     23       71     16   73   20 51   1     1         33 40     23   71   16   73
2145671 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706057 321000010382 ELEM SCHOOL FOR MATH, SCIENCE, TECH public Regular School No Elementary KG 05 2019   grade_2   11.0 32.0   1.0     0.0         24.0 20.0     18       44     *   44   11 32   1     0         24 20     18   44       44
2145918 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705760 321000011319 PULSE HIGH SCHOOL public Regular School No High 09 12 2019   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
2145937 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2019   grade_2   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
2146393 NY Bronx   school 3601133 321000861064   CHARTER HIGH SCHOOL-LAW AND 360113306569 321000861064 CHARTER HIGH SCHOOL-LAW AND SOCIAL charter Regular School Yes High 09 12 2019   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
2147837 NY Bronx   school 3601180 321100861120   BRONX CHARTER SCH FOR EXCELLE 360118006636 321100861120 BRONX CHARTER SCH FOR EXCELLENCE 4 charter Regular School Yes Elementary KG 01 2019   grade_2   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
2148559 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2019   grade_2   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
2163303 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105563 331300011553 BROOKLYN ACADEMY HIGH SCHOOL public Regular School No High 10 12 2019   grade_2   0.0 0.0         0.0         0.0 0.0     *       0     0   0   0 0         0         0 0         0   0   0
2163645 NY Kings   school 3601186 331300861110   EDMUND W GORDON BROOKLYN LAB 360118606645 331300861110 EDMUND W GORDON BROOKLYN LABORATORY charter Regular School Yes Middle 06 06 2019   grade_2   0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0   0 0         0     0   0 0         0   0   0
2165184 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009206659 331500010896 SCHOOL OF CREATIVITY-INNOVATION public Regular School No Elementary KG KG 2019   grade_2     0.0         0.0     0.0   0.0 0.0     0       0     *   0     0         0     0   0 0     0   0       0
2165925 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009406662 331600010898 PS 898 public Regular School No Middle 06 06 2019   grade_2   0.0 0.0   0.0               0.0 0.0     *       0     0   0   0 0   0               0 0         0   0   0
2167274 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 05 07 2019   grade_2   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
2168129 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012003000 331900010089 PS 89 CYPRESS HILLS public Regular School No Elementary PK 08 2019   grade_2   1.0 45.0   1.0     0.0     0.0   23.0 24.0     27       45     12   47   1 45   1     0     0   23 24     27   45   12   47
2168699 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006666 331900010907 MS 907 public Regular School No Middle 06 06 2019   grade_2   0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0   0 0         0     0   0 0         0   0   0
2168851 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012005931 331900011583 MULTICULTURAL HIGH SCHOOL public Regular School No High 09 12 2019   grade_2   0.0 0.0                   0.0 0.0     0       0     *   0   0 0                   0 0     0   0       0
2169136 NY Kings   school 3601145 331900861065   COLLEGIATE ACADEMY-MATH-PERS 360114506574 331900861065 COLLEGIATE ACADEMY-MATH-PERSONAL AWA charter Regular School Yes Middle 06 08 2019   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0   0 0   0     0         0 0         0   0   0
2171853 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102794 332300010284 GREGORY JOCKO JACKSON-SPORTS-ARTS public Regular School No Elementary PK 05 2019   grade_2   26.0 12.0   0.0     0.0         20.0 18.0     *       37     8   38   26 12   0     0         20 18         37   8   38
2172005 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105722 332300010514 FREDERICK DOUGLASS ACADEMY VII public Regular School No High 09 12 2019   grade_2   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
2178332 NY Nassau   school 3601169 280202861142   ACADEMY CHARTER SCHOOL-UNION 360116906639 280202861142 ACADEMY CHARTER SCHOOL-UNIONDALE charter Regular School Yes Elementary KG 02 2019   grade_2   24.0 23.0   2.0           1.0   26.0 24.0     6       36     *   50   24 23   2           1   26 24     6   36       50
2178940 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2   28.0 46.0                   34.0 40.0     26       62     19   74   28 46                   34 40     26   62   19   74
2178978 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No Elementary PK 06 2019   grade_2   32.0 65.0         0.0     1.0   45.0 53.0     37       81     9   98   32 65         0     1   45 53     37   81   9   98
2178997 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003463 280208030005 ROOSEVELT HIGH SCHOOL public Regular School No High 09 12 2019   grade_2   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
2179016 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No Middle 07 08 2019   grade_2   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
2179035 NY Nassau   school 3600030 280208860024   ROOSEVELT CHILDREN'S ACAD CHA 360003004379 280208860024 ROOSEVELT CHILDREN'S ACAD CHARTER SC charter Regular School Yes Elementary KG 08 2019   grade_2   52.0 16.0         0.0     0.0   32.0 36.0     10       64     *   68   52 16         0     0   32 36     10   64       68
2188687 NY New York   school 3600061 310300860804   SISULU-WALKER CHARTER SCHOOL 360006104438 310300860804 SISULU-WALKER CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2019   grade_2   32.0 7.0   0.0     0.0     1.0   23.0 17.0     *       38     11   40   32 7   0     0     1   23 17         38   11   40
2189409 NY New York   school 3600047 310400860812   HARBOR SCI & ARTS CHARTER SCH 360004704413 310400860812 HARBOR SCI & ARTS CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_2   23.0 10.0         0.0     0.0   21.0 12.0     *       27     5   33   23 10         0     0   21 12         27   5   33
2189884 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008105780 310500010318 THURGOOD MARSHALL ACADEMY LOWER SCH public Regular School No Elementary KG 05 2019   grade_2   28.0 6.0         0.0     0.0   13.0 21.0     *       27     12   34   28 6         0     0   13 21         27   12   34
2190378 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008301675 310600010004 PS 4 DUKE ELLINGTON public Regular School No Elementary PK 05 2019   grade_2   3.0 60.0   1.0     3.0         42.0 25.0     26       60     17   67   3 60   1     3         42 25     26   60   17   67
2190777 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302872 310600010210 PS/IS 210 21ST CENTURY ACADEMY public Regular School No Elementary PK 08 2019   grade_2   2.0 42.0         1.0         19.0 26.0     17       40     12   45   2 42         1         19 26     17   40   12   45
2190948 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No Middle 06 08 2019   grade_2     0.0                   0.0 0.0     0       0     *   0     0                   0 0     0   0       0
2191233 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008301265 310600011552 GREGORIO LUPERON HS-SCI & MATH public Regular School No High 09 12 2019   grade_2     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
2191708 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2     0.0   13.0           1.0   7.0 7.0             12     *   14     0   13           1   7 7         12       14
2194501 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Elementary PK 08 2019   grade_2         16.0     0.0         8.0 8.0             10     *   16         16     0         8 8         10       16
2204685 NY Queens   school 3601034 342800860969   ROCHDALE EARLY ADVANTAGE CHA 360103406224 342800860969 ROCHDALE EARLY ADVANTAGE CHARTER SCH charter Regular School Yes Elementary PK 05 2019   grade_2   48.0 1.0   1.0     0.0     0.0   24.0 26.0     *       36     7   50   48 1   1     0     0   24 26         36   7   50
2205350 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106550 342900010360 PS 360 public Regular School No Elementary PK 03 2019   grade_2   46.0 3.0   0.0     0.0         24.0 25.0             27     8   49   46 3   0     0         24 25         27   8   49
2225395 NY Westchester   school 3614070 660803020000   HAWTHORNE KNOLLS 361407001519 660803020004 GELLER HOUSE SCHOOL public Special Education School No Other 03 11 2019   grade_2   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
2139268 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139287 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139363 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139382 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139477 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_2 0.0 73.0 3.0         0.0     2.0   29.0 49.0     *       73     0   78 0 73 3         0     2   29 49         73   0   78
2139496 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0               0     0   0 0 0 0   0     0     0   0           0   0   0
2139515 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0     0.0     0       0     0   0 0 0 0   0     0     0     0     0   0   0   0
2139534 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139648 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139667 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139705 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139762 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139819 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139838 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139933 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139990 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 09 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140009 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2140161 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140180 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140275 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140313 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140370 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2140389 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2140427 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2140465 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2140617 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2140655 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
2140693 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2140731 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No High 06 12 2019   grade_2 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
2140769 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2019   grade_2 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
2140788 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402043 320700010001 PS 1 COURTLANDT SCHOOL public Regular School No Elementary PK 05 2019   grade_2 0.0 17.0 67.0         0.0     0.0   44.0 40.0     29       82     30   84 0 17 67         0     0   44 40     29   82   30   84
2140921 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2019   grade_2 0.0 11.0 47.0   0.0     0.0         31.0 27.0     11       56     15   58 0 11 47   0     0         31 27     11   56   15   58
2140978 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2140997 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2019   grade_2 0.0 20.0 29.0   0.0     0.0     0.0   26.0 23.0     *       49     16   49 0 20 29   0     0     0   26 23         49   16   49
2141016 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405533 320700010157 PS 157 GROVE HILL public Regular School No Elementary PK 05 2019   grade_2 0.0 39.0 63.0   1.0     0.0     0.0   60.0 43.0     7       100     21   103 0 39 63   1     0     0   60 43     7   100   21   103
2141073 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 LAB SCHOOL OF FIN & TECH: X223 public Regular School No High 06 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141092 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
2141149 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
2141168 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405920 320700010343 ACADEMY OF APPLIED MATH AND TECH public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141206 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 0.0 6.0 25.0               1.0   16.0 16.0     18       32     14   32 0 6 25               1   16 16     18   32   14   32
2141244 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No High 06 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141263 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141282 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405873 320700011334 INTERNATIONAL COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141301 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405988 320700011379 JILL CHAIFETZ TRANSFER HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141320 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406056 320700011381 BRONX HAVEN HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2141339 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405180 320700011427 COMMUNITY SCHOOL-SOCIAL JUSTICE public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0 0 0 0   0           0   0 0     0   0   0   0
2141358 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405187 320700011473 MOTT HAVEN VILLAGE PREP HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141377 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400749 320700011495 UNIVERSITY HEIGHTS SECONDARY SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141396 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400757 320700011500 HOSTOS-LINCOLN ACADEMY OF SCIENCE public Regular School No High 06 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2141415 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406253 320700011522 BRONX DESIGN-CONSTRUCTION ACADEMY public Career and Technical School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141434 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405189 320700011527 BRONX LEADERSHIP ACAD II HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141453 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405512 320700011548 CAREERS IN SPORTS HS public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
2141472 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405504 320700011551 URBAN ASSEMBLY BRONX OF LETTERS public Regular School No High 06 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2141491 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406352 320700011557 MOTT HAVEN COMMUNITY HIGH SCHOOL public Regular School No High 10 12 2019   grade_2 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);