Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_6", state = "NY" and year = 2018 sorted by district_state_id

View and edit SQL

year

  • 2018 · 4,722

grade

  • grade_6 · 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
2063462 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   grade_6 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063481 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   grade_6 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
2063500 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2063519 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 90.0 2.0 14.0   0.0     0.0     5.0   62.0 49.0     *       74     23   111 90 2 14   0     0     5   62 49         74   23   111
2063538 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 56.0 1.0 7.0         0.0     2.0   41.0 25.0     *       30     14   66 56 1 7         0     2   41 25         30   14   66
2063557 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_6 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2049383 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049402 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049421 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049440 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049459 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2049478 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2018   grade_6 13.0 33.0 11.0   0.0     6.0     4.0   31.0 36.0     5       34     *   67 13 33 11   0     6     4   31 36     5   34       67
2049497 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 16.0 7.0 7.0   0.0     5.0     5.0   21.0 19.0     *       24     6   40 16 7 7   0     5     5   21 19         24   6   40
2049516 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2018   grade_6 6.0 26.0 17.0   0.0     15.0     2.0   40.0 26.0     6       52     0   66 6 26 17   0     15     2   40 26     6   52   0   66
2049535 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 9.0 43.0 8.0   0.0     5.0     5.0   34.0 36.0     9       65     8   70 9 43 8   0     5     5   34 36     9   65   8   70
2049554 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 35.0 45.0 31.0   0.0     13.0     8.0   75.0 57.0     15       *     *   132 35 45 31   0     13     8   75 57     15           132
2049573 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049592 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049611 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049630 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049649 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 28.0 47.0 23.0   0.0     6.0     7.0   47.0 64.0     9       69     28   111 28 47 23   0     6     7   47 64     9   69   28   111
2049668 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2018   grade_6 20.0 132.0 24.0   0.0     8.0     12.0   90.0 106.0     24       176     5   196 20 132 24   0     8     12   90 106     24   176   5   196
2063576 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2063595 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063614 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 69.0 1.0 5.0         3.0     5.0   44.0 39.0     *       40     11   83 69 1 5         3     5   44 39         40   11   83
2049687 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0       0       0     0   0 0 0 0         0     0   0       0   0   0   0
2049706 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0     0.0     0       0     *   0 0 0 0         0     0     0     0   0       0
2049725 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2018   grade_6 3.0 83.0 8.0   0.0     3.0     1.0   39.0 59.0             89     *   98 3 83 8   0     3     1   39 59         89       98
2049744 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0         0 0 0 0         0     0   0 0     0   0       0
2049763 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_6 0.0 72.0 5.0         1.0     0.0   38.0 40.0     *       70     0   78 0 72 5         1     0   38 40         70   0   78
2049782 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0               0     0   0 0 0 0         0     0   0           0   0   0
2049801 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0     0.0     0       0     0   0 0 0 0   0     0     0     0     0   0   0   0
2063633 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2063652 NY Columbia   school 3614940 101300010000   HUDSON 361494001250 101300010002 JOHN L EDWARDS PRIMARY SCHOOL public Regular School No Elementary PK 01 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063671 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH INTER SCHOOL public Regular School No Elementary 02 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063690 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2018   grade_6 53.0 26.0 21.0   0.0     19.0     14.0   67.0 66.0     18       98     23   133 53 26 21   0     19     14   67 66     18   98   23   133
2063709 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE PRIMARYSCHOOL public Regular School No Elementary KG 03 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2063728 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063747 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 126.0 3.0 3.0         2.0     4.0   81.0 57.0     *       53     23   138 126 3 3         2     4   81 57         53   23   138
2063766 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521006267 101401040007 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary 04 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063785 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 31.0 1.0 1.0               0.0   15.0 18.0             15     *   33 31 1 1               0   15 18         15       33
2063804 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2049820 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2049839 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary KG 06 2018   grade_6 63.0 0.0 2.0         0.0     0.0   36.0 29.0             30     10   65 63 0 2         0     0   36 29         30   10   65
2049858 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2049877 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2049896 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2049915 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2049934 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 300.0 7.0 11.0         32.0     5.0   202.0 153.0     *       50     50   355 300 7 11         32     5   202 153         50   50   355
2049953 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2049972 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2049991 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2050010 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050029 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050048 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2018   grade_6 113.0 8.0 11.0         4.0     9.0   86.0 59.0             70     29   145 113 8 11         4     9   86 59         70   29   145
2050067 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050086 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050105 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050124 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 98.0 19.0 7.0   0.0     1.0     12.0   66.0 71.0     *       135     22   137 98 19 7   0     1     12   66 71         135   22   137
2050143 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050162 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050181 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050200 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2050219 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050238 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050257 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050276 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_6 143.0 16.0 12.0   0.0     19.0     18.0   101.0 107.0     *       79     29   208 143 16 12   0     19     18   101 107         79   29   208
2050295 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_6 112.0 11.0 14.0         14.0     7.0   88.0 70.0     *       54     29   158 112 11 14         14     7   88 70         54   29   158
2050314 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2018   grade_6 6.0 4.0 5.0   0.0     5.0     3.0   11.0 12.0     0       9     *   23 6 4 5   0     5     3   11 12     0   9       23
2050333 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2018   grade_6 44.0 6.0 9.0   0.0     16.0     6.0   42.0 39.0     7       26     20   81 44 6 9   0     16     6   42 39     7   26   20   81
2050352 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2018   grade_6 50.0 1.0 5.0   0.0     18.0     2.0   46.0 30.0     *       14     12   76 50 1 5   0     18     2   46 30         14   12   76
2050371 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2018   grade_6 38.0 3.0 4.0   0.0     16.0     5.0   37.0 29.0     *       22     *   66 38 3 4   0     16     5   37 29         22       66
2050390 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2018   grade_6 50.0 0.0 5.0   0.0     12.0     6.0   31.0 42.0     *       18     8   73 50 0 5   0     12     6   31 42         18   8   73
2050409 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2018   grade_6 29.0 0.0 0.0   0.0     2.0     4.0   18.0 17.0     0       *     *   35 29 0 0   0     2     4   18 17     0           35
2050428 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2018   grade_6 43.0 2.0 5.0   0.0     4.0     4.0   30.0 28.0     0       13     12   58 43 2 5   0     4     4   30 28     0   13   12   58
2050447 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050466 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050485 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   grade_6 17.0 1.0 2.0         1.0     4.0   12.0 13.0             19     9   25 17 1 2         1     4   12 13         19   9   25
2050504 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2050523 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2050542 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050561 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2050580 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2050599 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 272.0 16.0 11.0   1.0     48.0     11.0   175.0 184.0     8       70     49   359 272 16 11   1     48     11   175 184     8   70   49   359
2050618 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2050637 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2050656 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2050675 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 60.0 1.0 3.0   0.0     0.0     3.0   32.0 35.0             8     9   67 60 1 3   0     0     3   32 35         8   9   67
2063823 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_6 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2063842 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2063861 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_6 39.0   0.0               0.0   12.0 27.0             25     7   39 39   0               0   12 27         25   7   39
2063880 NY Cortland   school 3608460 110200010000   CORTLAND 360846000648 110200010003 FRANKLYN S BARRY SCHOOL public Regular School No Elementary KG 06 2018   grade_6 53.0 2.0 1.0         0.0     1.0   28.0 29.0             41     8   57 53 2 1         0     1   28 29         41   8   57
2063899 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_6 12.0 0.0                 0.0   6.0 6.0             *     0   12 12 0                 0   6 6             0   12
2063918 NY Cortland   school 3608460 110200010000   CORTLAND 360846000645 110200010008 ALTON B PARKER SCHOOL public Regular School No Elementary KG 06 2018   grade_6 26.0 0.0 3.0               0.0   14.0 15.0             20     *   29 26 0 3               0   14 15         20       29
2063937 NY Cortland   school 3608460 110200010000   CORTLAND 360846000650 110200010009 RANDALL SCHOOL public Regular School No Elementary KG 06 2018   grade_6 26.0 1.0 4.0         0.0     6.0   23.0 14.0     0       27     6   37 26 1 4         0     6   23 14     0   27   6   37
2063956 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 F E SMITH SCHOOL public Regular School No Elementary KG 06 2018   grade_6 25.0 1.0 1.0               2.0   12.0 17.0             16     *   29 25 1 1               2   12 17         16       29
2063975 NY Cortland   school 3608460 110200010000   CORTLAND 360846000646 110200010011 CORTLAND HIGH SCHOOL public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2063994 NY Cortland   school 3608460 110200010000   CORTLAND 360846006612 110200010012 CORTLAND JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2064013 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0   0.0               0.0   0.0 0.0     *       0     0   0 0   0               0   0 0         0   0   0
2064032 NY Cortland   school 3618840 110304040000   MCGRAW 361884001711 110304040002 MCGRAW SECONDARY SCHOOL public Regular School No High 06 12 2018   grade_6 38.0 0.0 1.0         0.0     0.0   19.0 20.0     *       26     8   39 38 0 1         0     0   19 20         26   8   39

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