Data source: Big Local News · About: Big Local

4,752 rows where grade = "grade_7", state = "NY" and year = 2015 sorted by district_state_id

View and edit SQL

year

  • 2015 · 4,731

grade

  • grade_7 · 4,731
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
759477 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
759496 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759515 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 67.0 1.0 4.0         1.0     2.0   36.0 39.0             *     16   75 67 1 4         1     2   36 39             16   75
745493 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes 1.0 KG 04 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0               0     0   0 0 0 0         0     0   0           0   0   0
745512 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes 1.0 KG 04 2015   grade_7 0.0 0.0 0.0         0.0     0.0     0.0             0     0   0 0 0 0         0     0     0         0   0   0
745531 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes 2.0 05 08 2015   grade_7 4.0 59.0 3.0   0.0     1.0     0.0   25.0 42.0             52         67 4 59 3   0     1     0   25 42         52       67
745550 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745569 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2015   grade_7 6.0 58.0 1.0         1.0         34.0 32.0             59     *   66 6 58 1         1         34 32         59       66
745588 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes 3.0 09 12 2015   grade_7 0.0 0.0           0.0         0.0               0     0   0 0 0           0         0           0   0   0
745607 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2015   grade_7 0.0 0.0 0.0         0.0           0.0             0     0   0 0 0 0         0           0         0   0   0
745626 NY Albany   school 3601020 10100860976   BRIGHTER CHOICE CHARTER MIDD 360102006227 10100860976 BRIGHTER CHOICE CHARTER MIDDLE-BOYS charter Regular School Yes 2.0 05 08 2015   grade_7 2.0 41.0 4.0   1.0     1.0         49.0               49     *   49 2 41 4   1     1         49           49       49
745645 NY Albany   school 3601021 10100860977   BRIGHTER CHOICE CHARTER MIDD 360102106231 10100860977 BRIGHTER CHOICE CHARTER MIDDLE-GIRLS charter Regular School Yes 2.0 05 08 2015   grade_7 3.0 51.0 10.0         0.0     1.0     65.0             65     *   65 3 51 10         0     1     65         65       65
759534 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON JR/SR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_7 67.0 42.0 20.0         16.0     2.0   57.0 90.0             105     28   147 67 42 20         16     2   57 90         105   28   147
759553 NY Columbia   school 3614940 101300010000   HUDSON 361494001250 101300010002 JOHN L EDWARDS PRIMARY SCHOOL public Regular School No 1.0 PK 02 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759572 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH INTER SCHOOL public Regular School No 1.0 03 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
759591 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE PRIMARYSCHOOL public Regular School No 1.0 KG 03 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759610 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759629 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 134.0 4.0 5.0         4.0     0.0   70.0 77.0             41     34   147 134 4 5         4     0   70 77         41   34   147
759648 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521006267 101401040007 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No 1.0 03 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759667 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759686 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2015   grade_7 38.0 0.0 0.0         1.0     1.0   13.0 27.0             16     5   40 38 0 0         1     1   13 27         16   5   40
745664 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2015   grade_7 66.0 3.0     1.0     0.0     0.0   37.0 33.0             29     10   70 66 3     1     0     0   37 33         29   10   70
745683 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745702 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745721 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
745740 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
745759 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745778 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 354.0 12.0 9.0         24.0     0.0   205.0 194.0             45     49   399 354 12 9         24     0   205 194         45   49   399
745797 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745816 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745835 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745854 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No 1.0 PK 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745873 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No 1.0 PK 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745892 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No 2.0 06 08 2015   grade_7 104.0 9.0 4.0         1.0     3.0   69.0 52.0             49     21   121 104 9 4         1     3   69 52         49   21   121
745911 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745930 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
745949 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745968 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 124.0 6.0 3.0         1.0     3.0   59.0 78.0             88     18   137 124 6 3         1     3   59 78         88   18   137
745987 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746006 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No 1.0 PK 04 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746025 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746044 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746063 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746082 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746101 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746120 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No 2.0 05 08 2015   grade_7 142.0 18.0 18.0         17.0     9.0   110.0 94.0             *     25   204 142 18 18         17     9   110 94             25   204
746139 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No 2.0 05 08 2015   grade_7 113.0 10.0 8.0   0.0     15.0     8.0   71.0 83.0             41     25   154 113 10 8   0     15     8   71 83         41   25   154
746158 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No 1.0 KG 08 2015   grade_7 11.0 10.0 2.0         6.0     3.0   14.0 18.0             9     *   32 11 10 2         6     3   14 18         9       32
746177 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746196 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746215 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746234 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746253 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746272 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746291 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No 2.0 07 08 2015   grade_7 309.0 16.0 17.0         57.0     9.0   185.0 223.0             76     45   408 309 16 17         57     9   185 223         76   45   408
746310 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746329 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 26.0 3.0 3.0         0.0     0.0   17.0 15.0             21     7   32 26 3 3         0     0   17 15         21   7   32
746348 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746367 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746386 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746405 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746424 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746443 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 288.0 17.0 11.0   0.0     48.0     13.0   209.0 168.0             49     69   377 288 17 11   0     48     13   209 168         49   69   377
746462 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746481 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746500 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746519 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_7 88.0 3.0     0.0     4.0     1.0   42.0 54.0             *     11   96 88 3     0     4     1   42 54             11   96
759705 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2015   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
759724 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
759743 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No 2.0 05 08 2015   grade_7 39.0   0.0               1.0   24.0 16.0             25     8   40 39   0               1   24 16         25   8   40
759762 NY Cortland   school 3608460 110200010000   CORTLAND 360846000648 110200010003 FRANKLYN S BARRY SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759781 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
759800 NY Cortland   school 3608460 110200010000   CORTLAND 360846000645 110200010008 ALTON B PARKER SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759819 NY Cortland   school 3608460 110200010000   CORTLAND 360846000650 110200010009 RANDALL SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759838 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 F E SMITH SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759857 NY Cortland   school 3608460 110200010000   CORTLAND 360846000646 110200010011 CORTLAND JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_7 181.0 11.0 11.0   1.0     5.0     5.0   99.0 115.0             128     35   214 181 11 11   1     5     5   99 115         128   35   214
759876 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759895 NY Cortland   school 3618840 110304040000   MCGRAW 361884001711 110304040002 MCGRAW SECONDARY SCHOOL public Regular School No 4.0 06 12 2015   grade_7 38.0 0.0 1.0   0.0     1.0     1.0   20.0 21.0             24     9   41 38 0 1   0     1     1   20 21         24   9   41
759914 NY Cortland   school 3614640 110701060000   HOMER 361464001217 110701060001 HOMER SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759933 NY Cortland   school 3614640 110701060000   HOMER 361464001214 110701060002 HOMER ELEMENTARY SCHOOL public Regular School No 1.0 KG 02 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759952 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No 1.0 03 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
759971 NY Cortland   school 3614640 110701060000   HOMER 361464001218 110701060005 HARTNETT ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_7 0.0   0.0                   0.0 0.0             0     0   0 0   0                   0 0         0   0   0
759990 NY Cortland   school 3614640 110701060000   HOMER 361464003477 110701060006 HOMER JUNIOR HIGH SCHOOL public Regular School No 2.0 06 08 2015   grade_7 150.0 1.0 1.0         1.0     3.0   68.0 88.0             69     22   156 150 1 1         1     3   68 88         69   22   156
760009 NY Cortland   school 3618450 110901040000   MARATHON 361845001661 110901040001 MARATHON HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_7 53.0 1.0 2.0         1.0         26.0 31.0             33     *   57 53 1 2         1         26 31         33       57
760028 NY Cortland   school 3618450 110901040000   MARATHON 361845001660 110901040002 WILLIAM APPLEBY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
746538 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746557 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_7 47.0 20.0 12.0   0.0     4.0     3.0   36.0 50.0             61     12   86 47 20 12   0     4     3   36 50         61   12   86
760085 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 6.0 0.0 0.0         0.0     1.0   5.0 2.0             *     *   7 6 0 0         0     1   5 2                 7
760104 NY Delaware   school 3609240 120301040000   DOWNSVILLE 360924000709 120301040001 DOWNSVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 15.0 0.0 0.0         0.0         8.0 7.0             8     *   15 15 0 0         0         8 7         8       15
760123 NY Delaware   school 3607050 120401040000   CHARLOTTE VALLEY 360705000497 120401040001 CHARLOTTE VALLEY SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 18.0 0.0 0.0               0.0   6.0 12.0             12     *   18 18 0 0               0   6 12         12       18
760142 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000680 120501040001 DELAWARE ACADEMY ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
760161 NY Delaware   school 3608910 120501040000   DELAWARE ACADEMY-DELHI 360891000681 120501040002 DELAWARE ACADEMY HIGH SCHOOL public Regular School No 4.0 06 12 2015   grade_7 53.0 1.0 0.0   0.0     1.0     0.0   26.0 29.0             22     10   55 53 1 0   0     1     0   26 29         22   10   55
760180 NY Delaware   school 3611430 120701040000   FRANKLIN 361143000900 120701040001 FRANKLIN CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 13.0 0.0 0.0   0.0     0.0         7.0 6.0             6     *   13 13 0 0   0     0         7 6         6       13
760199 NY Delaware   school 3613560 120906040000   HANCOCK 361356001109 120906040001 HANCOCK ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2015   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
760218 NY Delaware   school 3613560 120906040000   HANCOCK 361356001110 120906040002 HANCOCK JUNIOR-SENIOR HS public Regular School No 4.0 05 12 2015   grade_7 25.0 1.0 1.0   1.0     0.0         19.0 9.0             21     *   28 25 1 1   1     0         19 9         21       28
760237 NY Delaware   school 3618510 121401040000   MARGARETVILLE 361851001667 121401040001 MARGARETVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 26.0 0.0 1.0   0.0     0.0     1.0   16.0 12.0             14     5   28 26 0 1   0     0     1   16 12         14   5   28
760256 NY Delaware   school 3625110 121502040000   ROXBURY 362511003473 121502040001 ROXBURY CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_7 17.0 1.0 2.0   0.0           0.0   9.0 11.0             11     *   20 17 1 2   0           0   9 11         11       20
760275 NY Delaware   school 3626850 121601060000   SIDNEY 362685003662 121601060002 SIDNEY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
760294 NY Delaware   school 3626850 121601060000   SIDNEY 362685003664 121601060005 SIDNEY MIDDLE SCHOOL public Regular School No 2.0 07 08 2015   grade_7 68.0 0.0 5.0         2.0     2.0   33.0 44.0             51     *   77 68 0 5         2     2   33 44         51       77
760313 NY Delaware   school 3626850 121601060000   SIDNEY 362685003663 121601060006 SIDNEY HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_7 0.0 0.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]);