Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_4", state = "NY" and year = 2017 sorted by white

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_4 · 4,722
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
943979 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008404460 320700010162 JHS 162 LOLA RODRIGUEZ DE TIO public Regular School No Middle 06 08 2017   grade_4   0.0 0.0   0.0               0.0 0.0     0       0     0   0   0 0   0               0 0     0   0   0   0
944834 NY Bronx   school 3601125 320700861070   FAMILY LIFE ACADEMY CHARTER 360112506479 320700861070 FAMILY LIFE ACADEMY CHARTER SCH III charter Regular School Yes Elementary KG 03 2017   grade_4   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
944872 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Other 09 09 2017   grade_4   0.0 0.0               0.0   0.0 0.0     0       0     0   0   0 0               0   0 0     0   0   0   0
945499 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506081 320800010424 HUNTS POINT SCHOOL (THE) public Regular School No Middle 06 08 2017   grade_4   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
946354 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602338 320900010088 PS 88 S SILVERSTEIN LITTLE SPARROW public Regular School No Elementary PK 03 2017   grade_4   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
946468 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605663 320900010128 MOTT HALL III public Regular School No Middle 06 08 2017   grade_4   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
947247 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606395 320900011350 NEW DIRECTIONS SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_4   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
947266 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605981 320900011365 ACADEMY FOR LANGUAGE AND TECHNOLOGY public Regular School No High 09 12 2017   grade_4   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
950762 NY Bronx   school 3601142 321100861103   BRONX CHARTER SCHOOL FOR EXC 360114206578 321100861103 BRONX CHARTER SCH FOR EXCELLENCE 2 charter Regular School Yes Elementary KG 01 2017   grade_4   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
951503 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006030 321200011388 PAN AMERICAN INTERNATIONAL HS-MONROE public Regular School No High 09 12 2017   grade_4     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
960452 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 4 2017   grade_4   50.0 5.0   0.0           3.0   21.0 37.0     *       57     5   58   50 5   0           3   21 37         57   5   58
966228 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105563 331300011553 BROOKLYN ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   grade_4   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
968622 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402163 331600010035 MS 35 STEPHEN DECATUR public Regular School No Middle 06 8 2017   grade_4   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
968698 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402758 331600010243 PS 243 WEEKSVILLE SCHOOL (THE) public Regular School No Elementary PK 5 2017   grade_4   30.0 9.0   1.0     1.0     0.0   26.0 15.0     *       38     16   41   30 9   1     1     0   26 15         38   16   41
968812 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009405518 331600010393 FREDERICK DOUGLASS ACADEMY IV public Regular School No High 09 12 2017   grade_4   0.0 0.0               0.0   0.0 0.0             0     0   0   0 0               0   0 0         0   0   0
968964 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009406408 331600011669 RESEARCH AND SERVICE HIGH SCHOOL public Regular School No High 09 12 2017   grade_4   0.0 0.0         0.0         0.0 0.0     *       0     0   0   0 0         0         0 0         0   0   0
969382 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502656 331700010191 PS 191 PAUL ROBESON public Regular School No Elementary PK 5 2017   grade_4   25.0 2.0   0.0     1.0     1.0   14.0 15.0     0       29     10   29   25 2   0     1     1   14 15     0   29   10   29
969553 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505819 331700010353 ELIJAH STROUD MIDDLE SCHOOL public Regular School No Middle 06 8 2017   grade_4   0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0   0 0   0     0     0   0 0     0   0   0   0
970047 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505762 331700011568 BROWNSVILLE ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   grade_4   0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0   0 0   0     0         0 0         0   0   0
970218 NY Kings   school 3601058 331700861027   EXPLORE EXCEED CHARTER SCHOO 360105806354 331700861027 EXPLORE EXCEED CHARTER SCHOOL charter Regular School Yes Elementary KG 7 2017   grade_4   49.0 12.0   1.0     2.0     0.0   37.0 27.0     *       50     20   64   49 12   1     2     0   37 27         50   20   64
970275 NY Kings   school 3601095 331700861041   SUCCESS ACAD-CROWN HEIGHTS 360109506413 331700861041 SUCCESS ACAD CHARTER SCH-CROWN HGTS charter Regular School Yes Elementary KG 4 2017   grade_4   53.0 5.0   0.0     0.0     2.0   26.0 34.0     0       45     *   60   53 5   0     0     2   26 34     0   45       60
971206 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012003000 331900010089 PS 89 CYPRESS HILLS public Regular School No Elementary PK 8 2017   grade_4   1.0 45.0   1.0     2.0     0.0   19.0 30.0     21       45     11   49   1 45   1     2     0   19 30     21   45   11   49
972175 NY Kings   school 3601031 331900860973   IMAGINE ME LEADERSHIP CHARTE 360103106238 331900860973 IMAGINE ME LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary KG 5 2017   grade_4   33.0 4.0               0.0   37.0       *       34     *   37   33 4               0   37           34       37
972232 NY Kings   school 3601145 331900861065   COLLEGIATE ACADEMY-MATH-PERS 360114506574 331900861065 COLLEGIATE ACADEMY-MATH-PERSONAL AWA charter Regular School Yes Middle 06 6 2017   grade_4   0.0 0.0               0.0   0.0 0.0     *       0     0   0   0 0               0   0 0         0   0   0
975063 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012105724 332300010522 MOTT HALL IV public Regular School No Middle 06 08 2017   grade_4   0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0   0 0   0     0         0 0     0   0   0   0
975291 NY Kings   school 3601032 332300860936   OCEAN HILL COLLEGIATE CHA 360103206229 332300860936 OCEAN HILL COLLEGIATE CHARTER SCH charter Regular School Yes Middle 05 08 2017   grade_4   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
981922 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003460 280208030002 CENTENNIAL AVENUE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4   53.0 36.0                   54.0 35.0     21       61     17   89   53 36                   54 35     21   61   17   89
981941 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003464 280208030003 ULYSSES BYAS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4   34.0 36.0                   41.0 29.0     8       47     12   70   34 36                   41 29     8   47   12   70
981960 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003465 280208030004 WASHINGTON ROSE SCHOOL public Regular School No Elementary PK 06 2017   grade_4   48.0 54.0                   54.0 48.0     35       66     10   102   48 54                   54 48     35   66   10   102
981979 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499003463 280208030005 ROOSEVELT HIGH SCHOOL public Regular School No High 09 12 2017   grade_4   0.0 0.0                   0.0 0.0     0       0     0   0   0 0                   0 0     0   0   0   0
981998 NY Nassau   school 3624990 280208030000   ROOSEVELT 362499005611 280208030009 ROOSEVELT MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_4   0.0 0.0               0.0   0.0 0.0     0       0     0   0   0 0               0   0 0     0   0   0   0
990339 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705500 310200011542 MANHATTAN BRIDGES HIGH SCHOOL public Regular School No High 09 12 2017   grade_4   0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0   0 0         0     0   0 0     0   0   0   0
991403 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007806145 310300011404 INNOVATION DIPLOMA PLUS public Regular School No High 09 12 2017   grade_4   0.0 0.0   0.0     0.0         0.0 0.0             0     0   0   0 0   0     0         0 0         0   0   0
992182 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007906096 310400010406 GLOBAL TECHNOLOGY PREPARATORY public Regular School No Middle 06 08 2017   grade_4   0.0 0.0         0.0         0.0 0.0     0       0     0   0   0 0         0         0 0     0   0   0   0
992562 NY New York   school 3601144 310400861081   CAPITAL PREP (CP) HARLEM CHA 360114406597 310400861081 CAPITAL PREP (CP) HARLEM CHARTER charter Regular School Yes Middle 06 07 2017   grade_4   0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0   0 0   0     0     0   0 0         0   0   0
993987 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305871 310600010349 HARBOR HEIGHTS public Regular School No Middle 06 08 2017   grade_4     0.0               0.0   0.0 0.0     0       0     *   0     0               0   0 0     0   0       0
994272 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 2017   grade_4     0.0                   0.0 0.0     0       0     0   0     0                   0 0     0   0   0   0
994728 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002954 400701060003 TUSCARORA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4     0.0   11.0           1.0   5.0 7.0             9     0   12     0   11           1   5 7         9   0   12
997540 NY Onondaga   school 3616410 420807040000   LAFAYETTE 361641001449 420807040002 ONONDAGA NATION SCHOOL public Regular School No Elementary PK 08 2017   grade_4         8.0           0.0   2.0 6.0             8     0   8         8           0   2 6         8   0   8
1003696 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806084 342400011296 PAN AMERICAN INTERNATIONAL HS public Regular School No High 09 12 2017   grade_4     0.0   0.0               0.0 0.0     0       0     0   0     0   0               0 0     0   0   0   0
1008066 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102563 342900010156 PS 156 LAURELTON public Regular School No Elementary PK 05 2017   grade_4   46.0 2.0   1.0     1.0     0.0   25.0 25.0     *       38     *   50   46 2   1     1     0   25 25         38       50
1008332 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106550 342900010360 PS 360 public Regular School No Elementary PK 05 2017   grade_4   0.0 0.0         0.0         0.0 0.0             0     0   0   0 0         0         0 0         0   0   0
1027864 NY Westchester   school 3612400 660410020000   GREENBURGH-GRAHAM 361240006299 660410020003 ZICCOLELLA MIDDLE SCHOOL public Special Education School No Other 06 09 2017   grade_4   0.0 0.0                   0.0 0.0             0     0   0   0 0                   0 0         0   0   0
942212 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
942231 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
942307 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
942326 NY Albany   school 3602460 10100010000   ALBANY 360246006538 10100010046 WEST HILL MIDDLE SCHOOL public Regular School No Middle 07 08 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
942345 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2017   grade_4 0.0 34.0 7.0         1.0     1.0   43.0       0       41     *   43 0 34 7         1     1   43       0   41       43
942364 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2017   grade_4 0.0 36.0 7.0         2.0     1.0   0.0 46.0     0       39     *   46 0 36 7         2     1   0 46     0   39       46
942383 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942421 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_4 0.0 68.0 3.0         0.0         38.0 33.0     0       57     *   71 0 68 3         0         38 33     0   57       71
942440 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0               0     0   0 0 0 0   0     0     0   0           0   0   0
942459 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0     0.0     0       0     0   0 0 0 0   0     0     0     0     0   0   0   0
942478 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
942592 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
942611 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
942649 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
942706 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
942763 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
942782 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
942877 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
942934 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
942953 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
943105 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
943124 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
943219 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
943257 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
943314 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
943333 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
943371 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
943409 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   grade_4 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
943561 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
943599 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
943637 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No Other 06 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
943675 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No Other 06 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
943770 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2017   grade_4 0.0 0.0 63.0   0.0     1.0     0.0   36.0 28.0     15       63     22   64 0 0 63   0     1     0   36 28     15   63   22   64
943789 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No Elementary PK 08 2017   grade_4 0.0 23.0 52.0   0.0     1.0     0.0   36.0 40.0     14       69     17   76 0 23 52   0     1     0   36 40     14   69   17   76
943846 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2017   grade_4 0.0 20.0 53.0   0.0     1.0         35.0 39.0     *       73     16   74 0 20 53   0     1         35 39         73   16   74
943865 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2017   grade_4 0.0 21.0 60.0   0.0     0.0     1.0   49.0 33.0     *       81     30   82 0 21 60   0     0     1   49 33         81   30   82
943884 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2017   grade_4 0.0 15.0 50.0   0.0     0.0     1.0   30.0 36.0     9       66     20   66 0 15 50   0     0     1   30 36     9   66   20   66
943903 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
943922 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2017   grade_4 0.0 22.0 35.0   1.0     0.0     0.0   33.0 25.0     7       57     15   58 0 22 35   1     0     0   33 25     7   57   15   58
943941 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405533 320700010157 PS 157 GROVE HILL public Regular School No Elementary PK 05 2017   grade_4 0.0 30.0 70.0   0.0     0.0     0.0   37.0 63.0     16       94     33   100 0 30 70   0     0     0   37 63     16   94   33   100
943960 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2017   grade_4 0.0 16.0 54.0   1.0     1.0     1.0   44.0 29.0     14       68     26   73 0 16 54   1     1     1   44 29     14   68   26   73
943998 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2017   grade_4 0.0 6.0 51.0   0.0     1.0     0.0   29.0 29.0     16       54     15   58 0 6 51   0     1     0   29 29     16   54   15   58
944017 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405521 320700010223 MS 223 LAB SCHOOL OF FIN & TECH public Regular School No Other 06 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944036 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405520 320700010224 PS/IS 224 public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
944074 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405785 320700010296 SO BRONX ACADEMY-APPLIED MEDIA public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
944093 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405786 320700010298 ACADEMY OF PUBLIC RELATIONS public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
944112 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 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
944150 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_4 0.0 5.0 29.0               0.0   22.0 12.0     15       32     18   34 0 5 29               0   22 12     15   32   18   34
944169 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405650 320700011221 SOUTH BRONX PREPARATORY public Regular School No Other 06 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944188 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944207 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405761 320700011321 CROTONA ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   grade_4 0.0 0.0 0.0                   0.0 0.0     0       0     0   0 0 0 0                   0 0     0   0   0   0
944226 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405873 320700011334 INTERNATIONAL COMMUNITY HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944245 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405988 320700011379 JILL CHAIFETZ TRANSFER HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0     0   0 0 0 0   0     0         0 0     0   0   0   0
944264 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406056 320700011381 BRONX HAVEN HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
944283 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405180 320700011427 COMMUNITY SCHOOL-SOCIAL JUSTICE public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944302 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 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
944321 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008400749 320700011495 UNIVERSITY HEIGHTS SECONDARY SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     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]);