Data source: Big Local News · About: Big Local

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

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
2051047 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_1 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051048 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_10 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051049 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_11 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051050 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_12 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051051 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_2 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051052 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_3 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051053 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_4 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051054 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_5 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051055 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_6 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051056 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_7 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051057 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_8 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051058 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_9 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051059 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   kindergarten_full_day 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051060 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   kindergarten_half_day 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051061 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   pk_12_total 26.0                   1.0   21.0 6.0                   *   27 26                   1   21 6                 27
2051062 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   pre_kindergarten_full_day 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051063 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   pre_kindergarten_half_day 26.0                   1.0   21.0 6.0                   *   27 26                   1   21 6                 27
2051064 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   ungraded_elementary 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2051065 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   ungraded_secondary 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2062979 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_1 21.0 2.0                 0.0   13.0 10.0             17     *   23 21 2                 0   13 10         17       23
2062980 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_10 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2062981 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_11 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2062982 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_12 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2062983 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_2 31.0 1.0                 0.0   18.0 14.0             *     6   32 31 1                 0   18 14             6   32
2062984 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_3 34.0 1.0                 0.0   18.0 17.0             16     7   35 34 1                 0   18 17         16   7   35
2062985 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_4 36.0 0.0                 1.0   17.0 20.0             21     *   37 36 0                 1   17 20         21       37
2062986 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_5 33.0 2.0                 0.0   21.0 14.0             21     5   35 33 2                 0   21 14         21   5   35
2062987 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_6 38.0 0.0                 0.0   14.0 24.0             19     5   38 38 0                 0   14 24         19   5   38
2062988 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2062989 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_8 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2062990 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_9 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2062991 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   kindergarten_full_day 28.0 0.0                 0.0   13.0 15.0             17     *   28 28 0                 0   13 15         17       28
2062992 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 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
2062993 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   pk_12_total 222.0 6.0                 1.0   115.0 114.0             126     31   229 222 6                 1   115 114         126   31   229
2062994 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 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
2062995 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 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
2062996 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   ungraded_elementary 1.0 0.0                 0.0   1.0 0.0             *     *   1 1 0                 0   1 0                 1
2062997 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   ungraded_secondary 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063891 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_1 12.0 0.0                 0.0   8.0 4.0             7     *   12 12 0                 0   8 4         7       12
2063892 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_10 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063893 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_11 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063894 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_12 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063895 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_2 17.0 0.0                 1.0   10.0 8.0             8     *   18 17 0                 1   10 8         8       18
2063896 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_3 15.0 0.0                 0.0   6.0 9.0             *     *   15 15 0                 0   6 9                 15
2063897 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_4 22.0 0.0                 2.0   16.0 8.0             13     *   24 22 0                 2   16 8         13       24
2063898 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_5 18.0 0.0                 2.0   9.0 11.0             10     *   20 18 0                 2   9 11         10       20
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
2063900 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063901 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_8 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063902 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_9 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063903 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   kindergarten_full_day 13.0 1.0                 1.0   8.0 7.0             11     *   15 13 1                 1   8 7         11       15
2063904 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 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
2063905 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   pk_12_total 109.0 1.0                 6.0   63.0 53.0             56     12   116 109 1                 6   63 53         56   12   116
2063906 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 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
2063907 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 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
2063908 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   ungraded_elementary 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2063909 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   ungraded_secondary 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
2070047 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 54.0 0.0                 0.0   23.0 31.0     *       35     10   54 54 0                 0   23 31         35   10   54
2070048 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_10 0.0 0.0                 0.0   0.0 0.0     *       0     0   0 0 0                 0   0 0         0   0   0
2070049 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_11 0.0 0.0                 0.0   0.0 0.0     *       0     0   0 0 0                 0   0 0         0   0   0
2070050 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_12 0.0 0.0                 0.0   0.0 0.0     *       0     0   0 0 0                 0   0 0         0   0   0
2070051 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 44.0 0.0                 0.0   26.0 18.0     *       28     10   44 44 0                 0   26 18         28   10   44
2070052 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_3 42.0 0.0                 0.0   21.0 21.0     *       20     14   42 42 0                 0   21 21         20   14   42
2070053 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 46.0 1.0                 0.0   27.0 20.0     *       30     15   47 46 1                 0   27 20         30   15   47
2070054 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_5 57.0 1.0                 0.0   31.0 27.0     *       26     14   58 57 1                 0   31 27         26   14   58
2070055 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 66.0 0.0                 1.0   36.0 31.0     *       35     13   67 66 0                 1   36 31         35   13   67
2070056 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_7 0.0 0.0                 0.0   0.0 0.0     *       0     0   0 0 0                 0   0 0         0   0   0
2070057 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_8 0.0 0.0                 0.0   0.0 0.0     *       0     0   0 0 0                 0   0 0         0   0   0
2070058 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_9 0.0 0.0                 0.0   0.0 0.0     *       0     0   0 0 0                 0   0 0         0   0   0
2070059 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 51.0 0.0                 0.0   24.0 27.0     *       27     7   51 51 0                 0   24 27         27   7   51
2070060 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
2070061 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pk_12_total 397.0 2.0                 1.0   208.0 192.0     *       219     91   400 397 2                 1   208 192         219   91   400
2070062 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pre_kindergarten_full_day 36.0 0.0                 0.0   19.0 17.0     *       *     *   36 36 0                 0   19 17                 36
2070063 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 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
2070064 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_elementary 1.0 0.0                 0.0   1.0 0.0     *       *     *   1 1 0                 0   1 0                 1
2070065 NY Essex   school 3619830 150901040000   MORIAH 361983001814 150901040007 MORIAH ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_secondary 0.0 0.0                 0.0   0.0 0.0     *       0     0   0 0 0                 0   0 0         0   0   0
2070142 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0     0.0     0.0     0.0   0.0 0.0             0     0   0 0 0     0     0     0   0 0         0   0   0
2070143 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_10 51.0 1.0     0.0     0.0     0.0   26.0 26.0             25     10   52 51 1     0     0     0   26 26         25   10   52
2070144 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_11 64.0 0.0     1.0     1.0     0.0   43.0 23.0             17     8   66 64 0     1     1     0   43 23         17   8   66
2070145 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_12 65.0 0.0     0.0     3.0     1.0   37.0 32.0             21     8   69 65 0     0     3     1   37 32         21   8   69
2070146 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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   0
2070147 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070148 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070149 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070150 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA 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
2070151 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070152 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070153 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_9 59.0 1.0     0.0     1.0     0.0   34.0 27.0             23     15   61 59 1     0     1     0   34 27         23   15   61
2070154 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070155 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070156 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 247.0 2.0     1.0     5.0     1.0   145.0 111.0             94     49   256 247 2     1     5     1   145 111         94   49   256
2070157 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070158 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070159 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 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
2070160 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003895 151501060001 TICONDEROGA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   ungraded_secondary 8.0 0.0     0.0     0.0     0.0   5.0 3.0             8     8   8 8 0     0     0     0   5 3         8   8   8
2070161 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003893 151501060003 TICONDEROGA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 41.0 0.0     0.0     0.0     0.0   23.0 18.0             29     9   41 41 0     0     0     0   23 18         29   9   41
2070162 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003893 151501060003 TICONDEROGA ELEMENTARY SCHOOL public Regular School No Elementary PK 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
2070163 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003893 151501060003 TICONDEROGA ELEMENTARY SCHOOL public Regular School No Elementary PK 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
2070164 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003893 151501060003 TICONDEROGA ELEMENTARY SCHOOL public Regular School No Elementary PK 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
2070165 NY Essex   school 3628680 151501060000   TICONDEROGA 362868003893 151501060003 TICONDEROGA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 51.0 0.0     0.0     0.0     1.0   23.0 29.0             26     6   52 51 0     0     0     1   23 29         26   6   52

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