Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_5", state = "NY" and year = 2020 sorted by white

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_5 · 4,742
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
1525152 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406613 320700010584 IS 584 public Regular School No Middle 06 08 2020   grade_5   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
1525475 NY Bronx   school 3601074 320700860703   HEKETI COMMUNITY CHARTER SCH 360107406336 320700860703 HEKETI COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2020   grade_5   11.0 29.0   1.0           0.0   20.0 21.0     6       33     6   41   11 29   1           0   20 21     6   33   6   41
1525608 NY Bronx   school 3600959 320700860926   NYC CHARTER HS - AECI 360095906073 320700860926 NYC CHARTER HS - AECI charter Regular School Yes High 09 12 2020   grade_5   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1525798 NY Bronx   school 3601125 320700861070   FAMILY LIFE ACADEMY CHARTER 360112506479 320700861070 FAMILY LIFE ACADEMY CHARTER SCH III charter Regular School Yes Elementary KG 04 2020   grade_5   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1528211 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605791 320900011250 EXIMIUS COLLEGE PREP ACADEMY public Regular School No High 09 12 2020   grade_5   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1528268 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605861 320900011263 VALIDUS PREP ACADEMY public Regular School No High 09 12 2020   grade_5   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
1528363 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2020   grade_5     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1528591 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2020   grade_5   20.0 13.0   1.0     1.0         14.0 21.0     *       29     6   35   20 13   1     1         14 21         29   6   35
1528762 NY Bronx   school 3601156 320900861122   SOUTH BRONX CLASSICAL CHARTE 360115606620 320900861122 SOUTH BRONX CLASSICAL CHARTER SCH IV charter Regular School Yes Elementary KG 03 2020   grade_5   0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0   0 0   0           0   0 0     0   0   0   0
1528857 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 2020   grade_5   2.0 43.0   0.0     1.0     2.0   16.0 32.0     *       39     9   48   2 43   0     1     2   16 32         39   9   48
1529750 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 2020   grade_5   14.0 33.0   0.0     0.0         18.0 29.0     12       46     11   47   14 33   0     0         18 29     12   46   11   47
1529997 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705760 321000011319 PULSE HIGH SCHOOL public Regular School No High 09 12 2020   grade_5   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
1530016 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705938 321000011342 INTERNATIONAL SCHOOL FOR LIBERAL ART public Regular School No High 06 12 2020   grade_5     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1530282 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706247 321000011524 CROTONA INTERNATIONAL HIGH SCHOOL public Career and Technical School No High 09 12 2020   grade_5   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
1530453 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 2020   grade_5   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
1530510 NY Bronx   school 3601200 321000861121   BRONX CHARTER SCH FOR EXCELL 360120006675 321000861121 BRONX CHARTER SCH FOR EXCELLENCE 5 charter Regular School Yes Elementary KG 01 2020   grade_5   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
1530567 NY Bronx   school 3601202 321000861150   KIPP BRONX CHARTER SCHOOL II 360120206676 321000861150 KIPP BRONX CHARTER SCHOOL II charter Regular School Yes Elementary KG 01 2020   grade_5   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
1531954 NY Bronx   school 3601157 321100861115   BRONX CHARTER SCH FOR EXCELL 360115706601 321100861115 BRONX CHARTER SCH FOR EXCELLENCE 3 charter Regular School Yes Elementary KG 03 2020   grade_5   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
1531973 NY Bronx   school 3601180 321100861120   BRONX CHARTER SCH FOR EXCELLE 360118006636 321100861120 BRONX CHARTER SCH FOR EXCELLENCE 4 charter Regular School Yes Elementary KG 02 2020   grade_5   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
1532676 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2020   grade_5   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
1534519 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2020   grade_5         0.0           0.0   0.0               *         0         0           0   0                   0
1551524 NY Kings   school 3601207 331700861164   LEFFERTS GARDENS ASCEND CHART 360120706673 331700861164 LEFFERTS GARDENS ASCEND CHARTER charter Regular School Yes Elementary KG 01 2020   grade_5   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
1552398 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012003000 331900010089 PS 89 CYPRESS HILLS public Regular School No Elementary PK 08 2020   grade_5   0.0 41.0   0.0     0.0     0.0   23.0 18.0     20       37     9   41   0 41   0     0     0   23 18     20   37   9   41
1553120 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012005931 331900011583 MULTICULTURAL HIGH SCHOOL public Regular School No High 09 12 2020   grade_5   0.0 0.0                   0.0 0.0     0       0     *   0   0 0                   0 0     0   0       0
1553329 NY Kings   school 3600989 331900860958   BROOKLYN SCHOLARS CHARTER 360098906097 331900860958 BROOKLYN SCHOLARS CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_5   46.0 25.0   1.0     4.0     0.0   45.0 31.0     *       69     8   76   46 25   1     4     0   45 31         69   8   76
1553462 NY Kings   school 3601210 331900861132   EAST BROOKLYN ASCEND CHARTER 360121006682 331900861132 EAST BROOKLYN ASCEND CHARTER charter Regular School Yes Elementary KG KG 2020   grade_5   0.0 0.0         0.0     0.0   0.0 0.0             0     0   0   0 0         0     0   0 0         0   0   0
1556160 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102794 332300010284 GREGORY JOCKO JACKSON-SPORTS-ARTS public Regular School No Elementary PK 05 2020   grade_5   29.0 17.0   1.0     0.0         20.0 27.0     5       47     13   47   29 17   1     0         20 27     5   47   13   47
1556464 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105997 332300011643 BROOKLYN DEMOCRACY ACADEMY public Regular School No High 09 12 2020   grade_5   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
1557053 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009705725 333200010564 BUSHWICK COMMUNITY HS public Regular School No High 09 12 2020   grade_5   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
1562601 NY Nassau   school 3601169 280202861142   ACADEMY CHARTER SCHOOL-UNION 360116906639 280202861142 ACADEMY CHARTER SCHOOL-UNIONDALE charter Regular School Yes Elementary KG 03 2020   grade_5   0.0 0.0   0.0           0.0   0.0 0.0     0       0     0   0   0 0   0           0   0 0     0   0   0   0
1563209 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_5   52.0 35.0         0.0     1.0   40.0 48.0     23       73     15   88   52 35         0     1   40 48     23   73   15   88
1563247 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No Elementary PK 06 2020   grade_5   60.0 49.0         0.0     0.0   56.0 53.0     30       82     14   109   60 49         0     0   56 53     30   82   14   109
1563285 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_5   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
1563304 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 2020   grade_5   39.0 19.0         0.0     0.0   30.0 28.0     6       53     6   58   39 19         0     0   30 28     6   53   6   58
1572937 NY New York   school 3600061 310300860804   SISULU-WALKER CHARTER SCHOOL 360006104438 310300860804 SISULU-WALKER CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2020   grade_5   21.0 4.0   1.0     1.0     2.0   17.0 12.0     *       25     7   29   21 4   1     1     2   17 12         25   7   29
1573488 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007906016 310400010377 RENAISSANCE SCHOOL OF THE ARTS public Regular School No Middle 06 08 2020   grade_5   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
1574647 NY New York   school 3601191 310500861149   HARLEM VILLAGE ACADEMY WEST 360119106671 310500861149 HARLEM VILLAGE ACADEMY WEST 2 CS charter Regular School Yes Elementary KG 01 2020   grade_5   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
1575255 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No Middle 06 08 2020   grade_5     0.0               0.0   0.0 0.0     0       0     *   0     0               0   0 0     0   0       0
1575540 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 2020   grade_5     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
1576015 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_5     0.0   14.0           3.0   6.0 11.0             8     0   17     0   14           3   6 11         8   0   17
1578789 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Other PK 11 2020   grade_5     0.0   19.0     0.0         10.0 9.0             19     5   19     0   19     0         10 9         19   5   19
1588004 NY Queens   school 3601211 342700861147   NEW DAWN CHARTER HS II 360121106692 342700861147 NEW DAWN CHARTER HS II charter Regular School Yes Secondary 09 09 2020   grade_5   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
1588992 NY Queens   school 3601034 342800860969   ROCHDALE EARLY ADVANTAGE CHA 360103406224 342800860969 ROCHDALE EARLY ADVANTAGE CHARTER SCH charter Regular School Yes Elementary PK 06 2020   grade_5   40.0 4.0   0.0     1.0     0.0   21.0 24.0     *       29     7   45   40 4   0     1     0   21 24         29   7   45
1589106 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102169 342900010037 CYNTHIA JENKINS SCHOOL public Regular School No Elementary PK 05 2020   grade_5   62.0 7.0   0.0     2.0         40.0 31.0     5       56     17   71   62 7   0     2         40 31     5   56   17   71
1589657 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106550 342900010360 PS 360 public Regular School No Elementary PK 04 2020   grade_5   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
1609246 NY Westchester   school 3612400 660410020000   GREENBURGH-GRAHAM 361240006299 660410020003 ZICCOLELLA MIDDLE SCHOOL public Special Education School No Middle 06 09 2020   grade_5   0.0 0.0                   0.0 0.0             *     *   0   0 0                   0 0                 0
1609284 NY Westchester   school 3610140 660411020000   GREENBURGH 11 361014000454 660411020003 GREENBURGH ELEVEN MIDDLE SCHOOL public Special Education School No Secondary 07 10 2020   grade_5   0.0 0.0               0.0   0.0               0     0   0   0 0               0   0           0   0   0
1609778 NY Westchester   school 3614070 660803020000   HAWTHORNE KNOLLS 361407001519 660803020004 GELLER HOUSE SCHOOL public Special Education School No Other 04 12 2020   grade_5   1.0 0.0   0.0               1.0 0.0             *     *   1   1 0   0               1 0                 1
1523176 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523195 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523271 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523290 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523309 NY Albany   school 3602460 10100010000   ALBANY 360246006700 10100010051 NORTH ALBANY ACADEMY MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1523366 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_5 0.0 86.0 7.0   0.0     0.0     0.0   44.0 49.0     0       77     *   93 0 86 7   0     0     0   44 49     0   77       93
1523385 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_5 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523404 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_5 0.0 64.0 5.0         1.0     1.0   32.0 39.0     0       64     0   71 0 64 5         1     1   32 39     0   64   0   71
1523423 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0               0     0   0 0 0 0   0     0     0   0           0   0   0
1523442 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0     0.0     0       0     0   0 0 0 0   0     0     0     0     0   0   0   0
1523461 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1523575 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1523594 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1523632 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1523689 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1523746 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1523765 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1523803 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1523822 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523841 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523860 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523879 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1523898 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1524107 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1524202 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1524240 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1524297 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1524316 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1524354 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1524392 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   grade_5 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1524544 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1524582 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1524620 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No High 06 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1524658 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No High 06 12 2020   grade_5 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1524696 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2020   grade_5 0.0                       0.0 0.0                       0 0                       0 0                 0
1524715 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402043 320700010001 PS 1 COURTLANDT SCHOOL public Regular School No Elementary PK 05 2020   grade_5 0.0 22.0 76.0         0.0     0.0   48.0 50.0     19       95     24   98 0 22 76         0     0   48 50     19   95   24   98
1524772 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2020   grade_5 0.0 6.0 61.0         1.0     0.0   41.0 27.0     *       62     21   68 0 6 61         1     0   41 27         62   21   68
1524848 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2020   grade_5 0.0 20.0 56.0   0.0     0.0     0.0   36.0 40.0     9       74     25   76 0 20 56   0     0     0   36 40     9   74   25   76
1524886 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2020   grade_5 0.0 18.0 39.0   0.0     2.0     0.0   26.0 33.0     9       57     19   59 0 18 39   0     2     0   26 33     9   57   19   59
1524905 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
1524924 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2020   grade_5 0.0 23.0 29.0   0.0     0.0     0.0   22.0 30.0     *       52     12   52 0 23 29   0     0     0   22 30         52   12   52
1524962 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 JUAN PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2020   grade_5 0.0 18.0 45.0   0.0     0.0     1.0   35.0 29.0     8       62     24   64 0 18 45   0     0     1   35 29     8   62   24   64
1524981 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2020   grade_5 0.0 4.0 41.0         0.0     1.0   21.0 25.0     10       42     12   46 0 4 41         0     1   21 25     10   42   12   46
1525000 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 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1525019 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1525038 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008403738 320700010277 PS 277 public Regular School No Elementary PK 05 2020   grade_5 0.0 17.0 46.0   0.0     0.0     0.0   37.0 26.0     7       57     21   63 0 17 46   0     0     0   37 26     7   57   21   63
1525057 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
1525076 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0               0.0 0.0     0       0     0   0 0 0 0   0               0 0     0   0   0   0
1525095 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 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1525133 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_5 0.0 4.0 24.0               0.0   12.0 16.0     *       26     10   28 0 4 24               0   12 16         26   10   28
1525171 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No High 06 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1525190 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Career and Technical School No High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     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]);