Data source: Big Local News · About: Big Local

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

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
2153195 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative 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
2155513 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative 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
2157071 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL AT 4 public Alternative 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
2163512 NY Kings   school 3601065 331300861006   URBAN DOVE TEAM CHARTER SCH 360106506342 331300861006 URBAN DOVE TEAM CHARTER SCHOOL charter Alternative School Yes 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
2165545 NY Kings   school 3601061 331500861016   NEW DAWN CHARTER HIGH SCHOOL 360106106343 331500861016 NEW DAWN CHARTER HIGH SCHOOL charter Alternative 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   0   0   0
2182151 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative 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
2187737 NY New York   school 3600053 310200860819   JOHN V LINDSAY WILDCAT ACAD 360005304411 310200860819 JOHN V LINDSAY WILDCAT ACAD CHARTER charter Alternative 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   0   0   0
2199460 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Alternative School No Middle 06 08 2019   grade_2 0.0   0.0                   0.0 0.0             *     0   0 0   0                   0 0             0   0
2213292 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2019   grade_2 0.0 0.0                     0.0 0.0             0     *   0 0 0                     0 0         0       0
2221139 NY Tompkins   school 3615570 610600010000   ITHACA 361557001328 610600010019 LEHMAN ALTERNATIVE COMM SCHOOL public Alternative 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
2225851 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010000365 660900010025 NELSON R MANDELA/DR HOSEA ZOLLICOFF public Alternative 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
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
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
2141510 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401909 320700011600 ALFRED E SMITH CAREER-TECH HIGH SCH 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
2142954 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506348 320800011559 SCHOOL FOR TOURISM AND HOSPITALITY 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
2145861 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706396 321000011264 BRONX ACAD FOR SOFTWARE ENGINEERING 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
2146222 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 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
2146279 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706364 321000011565 HIGH SCHOOL FOR ENERGY AND TECHNOLOG 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
2147400 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805684 321100011275 HIGH SCHOOL-COMPUTERS & TECHNOLOGY 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
2156786 NY Erie   school 3605850 140600010000   BUFFALO 360585000315 140600010098 MCKINLEY VOC 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
2156805 NY Erie   school 3605850 140600010000   BUFFALO 360585000301 140600010101 BURGARD 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
2163341 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101955 331300011605 GEORGE WESTINGHOUSE CAREER/TECH HS 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
2163398 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009106164 331300011674 CITY POLYTECHNIC 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
2164272 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905703 331400011558 WILLAMSBURG HS-ARCH & DESIGN 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
2164329 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011901913 331400011610 AUTOMOTIVE 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
2166818 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009506273 331700011122 PATHWAYS TECH EARLY COLLEGE HIGH SCH 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
2167084 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009501937 331700011600 CLARA BARTON 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
2167122 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009506200 331700011751 ACADEMY FOR HEALTH CAREERS 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
2167806 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009606059 331800011617 HS FOR INNOVATION -ADVERTISING/MEDIA 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
2168870 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012001941 331900011615 TRANSIT TECH CAREER AND TECH EDU 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
2168889 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006046 331900011618 ACADEMY OF INNOVATIVE TECHNOLOGY 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
2168946 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002889 331900011660 W H MAXWELL CAREER AND TECH HS 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
2168984 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006484 331900011764 URBAN ASSEMBLY-COLLABORATIVE HEALTHC 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
2170713 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202888 332100011620 WILLIAM E GRADY CAREER AND TECH 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
2186502 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706372 310200011135 URBAN ASSEMBLY-EMERGENCY MANAGEMENT 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
2186521 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706373 310200011139 STEPHEN T MATHER BLDG ARTS-CRAFTSMAN 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
2186559 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706466 310200011280 MANHATTAN EARLY COLLEGE SCH-ADVERTIS 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
2186578 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706463 310200011282 URBAN ASSEMBLY MAKER 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
2186597 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705622 310200011288 FOOD AND FINANCE 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
2186844 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706126 310200011393 BUSINESS OF SPORTS 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
2187262 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706251 310200011507 URBAN ASSEMBLY GATEWAY SCHOOL-TECH 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
2187357 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706309 310200011533 UNION SQUARE ACAD FOR HEALTH SCIENCE 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
2187471 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706363 310200011546 ACADEMY FOR SOFTWARE ENGINEERING 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
2187509 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705560 310200011551 URBAN ASSEMBLY NY HARBOR 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
2187642 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701949 310200011600 HIGH SCH OF FASHION INDUSTRIES (THE) 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
2187680 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701934 310200011615 CHELSEA CAREER AND TECH ED HS 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
2187699 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701911 310200011630 ART AND DESIGN 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
2188440 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007806148 310300011402 URBAN ASSEMBLY FOR GREEN CAREERS 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
2189960 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008106380 310500011157 URBAN ASSEMBLY-GLOBAL COMMERCE 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
2191043 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008306490 310600011211 INWOOD EARLY COLLEGE FOR HEALTH-INFO 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
2200752 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802860 342400011600 QUEENS TECHNICAL 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
2200771 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801915 342400011610 AVIATION CAREER AND TECH ED HS 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
2202272 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009906468 342600011315 BUSINESS TECHNOLOGY EARLY COLLEGE HS 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
2203564 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305899 342700011650 HS FOR CON, TRADES, ENGINEER AND ARC 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
2204552 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002881 342800011620 THOMAS A EDISON CAREER-TECH HS 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
2205369 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106440 342900011243 INSTITUTE FOR HEALTH PROFESIONS 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
2205483 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106508 342900011313 BENJAMIN FRANKLIN HS-FINANCE-INFO 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
2206395 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206443 343000011258 ENERGY TECH 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
2206433 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206070 343000011301 ACAD FOR CAREERS IN TELEVISION-FILM 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
2208732 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302861 353100011600 RALPH R MCKEE CAREER-TECH HIGH SCH 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
2139097 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_2 27.0 8.0 6.0         2.0     7.0   34.0 16.0     *       15     *   50 27 8 6         2     7   34 16         15       50
2139116 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 11.0 27.0 14.0   0.0     7.0     2.0   35.0 26.0     10       47     16   61 11 27 14   0     7     2   35 26     10   47   16   61
2139135 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 13.0 13.0 25.0         5.0     5.0   35.0 26.0     14       47     *   61 13 13 25         5     5   35 26     14   47       61
2139154 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 37.0 11.0 13.0   1.0     6.0     3.0   31.0 40.0     10       28     8   71 37 11 13   1     6     3   31 40     10   28   8   71
2139173 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2019   grade_2 6.0 22.0 7.0         1.0     3.0   21.0 18.0     7       34     0   39 6 22 7         1     3   21 18     7   34   0   39
2139192 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_2 15.0 39.0 11.0   0.0     4.0     6.0   35.0 40.0     *       50     10   75 15 39 11   0     4     6   35 40         50   10   75
2139211 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 22.0 8.0 6.0         5.0     0.0   22.0 19.0     5       19     9   41 22 8 6         5     0   22 19     5   19   9   41
2139230 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2019   grade_2 6.0 28.0 5.0   0.0     19.0     5.0   37.0 26.0     8       44     9   63 6 28 5   0     19     5   37 26     8   44   9   63
2139249 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_2 4.0 27.0 16.0   1.0     6.0     6.0   40.0 20.0     8       57     9   60 4 27 16   1     6     6   40 20     8   57   9   60
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
2139306 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 1.0 28.0 10.0         0.0     3.0   24.0 18.0     0       37     8   42 1 28 10         0     3   24 18     0   37   8   42
2139325 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2019   grade_2 3.0 21.0 10.0   0.0     3.0     6.0   28.0 15.0     10       35     15   43 3 21 10   0     3     6   28 15     10   35   15   43
2139344 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   grade_2 2.0 29.0 15.0   0.0     6.0     0.0   25.0 27.0     10       47     0   52 2 29 15   0     6     0   25 27     10   47   0   52
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
2139401 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2019   grade_2 1.0 39.0 14.0         3.0     4.0   61.0 0.0     *       57     *   61 1 39 14         3     4   61 0         57       61
2139420 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2019   grade_2 1.0 32.0 15.0         4.0     2.0     54.0     *       49     *   54 1 32 15         4     2     54         49       54
2139439 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2019   grade_2 1.0 80.0 9.0   0.0     2.0     5.0   61.0 36.0     *       71     *   97 1 80 9   0     2     5   61 36         71       97
2139458 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_2 1.0 48.0 15.0               5.0   34.0 35.0     *       59     *   69 1 48 15               5   34 35         59       69
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
2139553 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2019   grade_2 40.0 0.0 2.0         1.0     1.0   25.0 19.0             18     6   44 40 0 2         1     1   25 19         18   6   44
2139572 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 36.0 1.0 1.0         1.0     5.0   15.0 29.0             6     *   44 36 1 1         1     5   15 29         6       44
2139591 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 44.0 2.0 4.0         8.0     4.0   29.0 33.0     5       *     9   62 44 2 4         8     4   29 33     5       9   62
2139610 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 32.0 1.0 0.0         3.0     5.0   26.0 15.0             *     12   41 32 1 0         3     5   26 15             12   41
2139629 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 67.0 1.0 3.0         5.0     6.0   45.0 37.0     *       14     11   82 67 1 3         5     6   45 37         14   11   82
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
2139686 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 62.0 0.0 2.0   1.0     3.0     5.0   42.0 31.0     0       14     16   73 62 0 2   1     3     5   42 31     0   14   16   73
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
2139724 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2019   grade_2 60.0 1.0 4.0         1.0     2.0   29.0 39.0             31     18   68 60 1 4         1     2   29 39         31   18   68
2139743 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_2 47.0 2.0 7.0   0.0     1.0     6.0   27.0 36.0     *       29     10   63 47 2 7   0     1     6   27 36         29   10   63
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
2139781 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2019   grade_2 52.0 4.0 10.0         0.0     5.0   38.0 33.0             46     10   71 52 4 10         0     5   38 33         46   10   71
2139800 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2019   grade_2 18.0 5.0 7.0         2.0     3.0   15.0 20.0             24     10   35 18 5 7         2     3   15 20         24   10   35
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

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