Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2018 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2018 · 89,718
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
2067900 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_1 1.0 48.0 7.0               0.0   33.0 23.0     *       55     7   56 1 48 7               0   33 23         55   7   56
2067901 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_10 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067902 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_11 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067903 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_12 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067904 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   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
2067905 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_3 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067906 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_4 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067907 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_5 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067908 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           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
2067909 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   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
2067910 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_8 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067911 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_9 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067912 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   kindergarten_full_day 6.0 78.0 14.0               1.0   48.0 51.0     *       96     11   99 6 78 14               1   48 51         96   11   99
2067913 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   kindergarten_half_day 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067914 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   pk_12_total 7.0 126.0 21.0               1.0   81.0 74.0     7       151     18   155 7 126 21               1   81 74     7   151   18   155
2067915 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   pre_kindergarten_full_day 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067916 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   pre_kindergarten_half_day 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067917 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   ungraded_elementary 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2067918 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   ungraded_secondary 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2106337 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_1 4.0 29.0 9.0         7.0     1.0   26.0 24.0     5       41     5   50 4 29 9         7     1   26 24     5   41   5   50
2106338 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106339 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_11 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106340 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106341 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_2 3.0 28.0 7.0         3.0     4.0   22.0 23.0     *       39     *   45 3 28 7         3     4   22 23         39       45
2106342 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_3 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106343 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106344 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106345 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           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
2106346 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   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
2106347 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106348 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106349 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   kindergarten_full_day 4.0 41.0 9.0         2.0     10.0   36.0 30.0     *       54     *   66 4 41 9         2     10   36 30         54       66
2106350 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106351 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   pk_12_total 11.0 98.0 25.0         12.0     15.0   84.0 77.0     13       134     13   161 11 98 25         12     15   84 77     13   134   13   161
2106352 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   pre_kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106353 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106354 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2106355 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065031 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_1 1.0 32.0 20.0         1.0     6.0   32.0 28.0     *       34     11   60 1 32 20         1     6   32 28         34   11   60
2065032 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065033 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_11 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065034 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065035 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_2 2.0 40.0 15.0         1.0     10.0   39.0 29.0     7       50     6   68 2 40 15         1     10   39 29     7   50   6   68
2065036 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_3 3.0 33.0 20.0         1.0     2.0   28.0 31.0     5       43     12   59 3 33 20         1     2   28 31     5   43   12   59
2065037 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_4 7.0 35.0 23.0         1.0     13.0   42.0 37.0     7       66     15   79 7 35 23         1     13   42 37     7   66   15   79
2065038 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_5 4.0 22.0 22.0         0.0     7.0   29.0 26.0     *       44     7   55 4 22 22         0     7   29 26         44   7   55
2065039 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 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
2065040 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   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
2065041 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065042 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065043 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065044 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065045 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   pk_12_total 17.0 162.0 100.0         4.0     38.0   170.0 151.0     24       237     51   321 17 162 100         4     38   170 151     24   237   51   321
2065046 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   pre_kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065047 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065048 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2065049 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003305 131500010003 GOV GEORGE CLINTON SCHOOL public Regular School No Elementary 01 05 2018   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2069819 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_1 58.0 5.0 4.0   0.0     0.0     1.0   32.0 36.0             41     10   68 58 5 4   0     0     1   32 36         41   10   68
2069820 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069821 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069822 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069823 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 66.0 2.0 7.0   1.0     0.0     7.0   46.0 37.0             53     13   83 66 2 7   1     0     7   46 37         53   13   83
2069824 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_3 60.0 4.0 6.0   0.0     0.0     3.0   30.0 43.0             45     *   73 60 4 6   0     0     3   30 43         45       73
2069825 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_4 71.0 3.0 4.0   0.0     1.0     6.0   44.0 41.0             55     18   85 71 3 4   0     1     6   44 41         55   18   85
2069826 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_5 51.0 2.0 1.0   1.0     1.0     3.0   30.0 29.0             38     10   59 51 2 1   1     1     3   30 29         38   10   59
2069827 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 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
2069828 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   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
2069829 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069830 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069831 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069832 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069833 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   pk_12_total 307.0 16.0 22.0   2.0     2.0     20.0   183.0 186.0             232     60   369 307 16 22   2     2     20   183 186         232   60   369
2069834 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069835 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2069836 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0             0     *   1 1 0 0   0     0     0   1 0         0       1
2069837 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   ungraded_secondary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2070731 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_1 1.0 0.0 0.0         0.0     0.0   1.0 0.0     0       *     *   1 1 0 0         0     0   1 0     0           1
2070732 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070733 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_11 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070734 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070735 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_2 83.0 1.0 3.0         2.0     0.0   44.0 45.0     *       *     *   89 83 1 3         2     0   44 45                 89
2070736 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_3 101.0 0.0 7.0         1.0     2.0   57.0 54.0     *       64     9   111 101 0 7         1     2   57 54         64   9   111
2070737 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070738 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070739 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 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
2070740 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   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
2070741 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070742 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070743 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070744 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070745 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   pk_12_total 187.0 1.0 10.0         3.0     2.0   103.0 100.0     5       119     19   203 187 1 10         3     2   103 100     5   119   19   203
2070746 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   pre_kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070747 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2070748 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   ungraded_elementary 2.0 0.0 0.0         0.0     0.0   1.0 1.0     0       *     *   2 2 0 0         0     0   1 1     0           2
2070749 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001379 170600010001 GLEBE STREET ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2018   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2071016 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2018   grade_1 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 1 0 0   0     0     0   1 0     0           1
2071017 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2018   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2071018 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2018   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2071019 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2018   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2071020 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 109.0 13.0 14.0   0.0     1.0     21.0   87.0 71.0     *       108     11   158 109 13 14   0     1     21   87 71         108   11   158

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