Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_7" and state = "NY" sorted by school_state_id descending

View and edit SQL

year

grade

  • grade_7 · 33,145
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
835477 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031743 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   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
1121936 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1523007 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1613105 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 10 2020   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
2139083 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE 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           0   0 0         0   0   0
2228744 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
835458 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3 07 12 2015   grade_7 51.0 1.0 0.0   0.0     0.0     1.0   26.0 27.0             31     13   53 51 1 0   0     0     1   26 27         31   13   53
1031724 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 41.0 2.0 0.0         1.0     0.0   18.0 26.0             26     *   44 41 2 0         1     0   18 26         26       44
1121917 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 57.0 1.0 2.0   0.0     0.0     0.0   32.0 28.0             43     18   60 57 1 2   0     0     0   32 28         43   18   60
1522988 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 44.0 1.0 2.0   0.0     0.0     1.0   26.0 22.0             30     12   48 44 1 2   0     0     1   26 22         30   12   48
1613086 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 41.0 0.0 5.0   0.0     0.0     1.0   27.0 20.0             33     10   47 41 0 5   0     0     1   27 20         33   10   47
2139064 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_7 46.0 0.0 0.0         0.0     1.0   26.0 21.0             37     8   47 46 0 0         0     1   26 21         37   8   47
2228725 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_7 34.0 0.0 1.0   1.0     0.0     2.0   21.0 17.0             21     *   38 34 0 1   1     0     2   21 17         21       38
835439 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No 1 PK 05 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1031705 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
1121898 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   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
1522969 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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
1613067 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
2139045 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 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
2228706 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
835420 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_7 92.0 0.0 5.0         0.0     2.0   41.0 58.0             52     22   99 92 0 5         0     2   41 58         52   22   99
1031686 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 96.0   9.0         2.0     4.0   56.0 55.0     *       71     20   111 96   9         2     4   56 55         71   20   111
1121879 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 109.0   3.0         2.0     3.0   57.0 60.0             64     14   117 109   3         2     3   57 60         64   14   117
1522950 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 87.0   5.0         3.0     5.0   55.0 45.0     *       57     13   100 87   5         3     5   55 45         57   13   100
1613048 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 88.0 0.0 4.0         1.0     2.0   39.0 56.0     *       41     *   95 88 0 4         1     2   39 56         41       95
2139026 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 82.0 0.0 4.0   0.0     1.0     4.0   50.0 41.0             *     *   91 82 0 4   0     1     4   50 41                 91
2228687 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 91.0 1.0 2.0         0.0     3.0   46.0 51.0     *       53     10   97 91 1 2         0     3   46 51         53   10   97
835401 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No 3 09 12 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031667 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2017   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   0   0
1121860 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No 3.0 09 12 2016   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
1522931 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2021   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
1613029 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2020   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
2139007 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY 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         0   0   0
2228668 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2019   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
1522912 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 42.0 1.0 3.0         1.0     2.0   26.0 23.0             29     5   49 42 1 3         1     2   26 23         29   5   49
835382 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No 4 06 12 2015   grade_7 63.0   2.0   0.0     1.0     0.0   30.0 36.0             33     8   66 63   2   0     1     0   30 36         33   8   66
1031648 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No Other 06 12 2017   grade_7 67.0   0.0   0.0     2.0     1.0   31.0 39.0     *       34     9   70 67   0   0     2     1   31 39         34   9   70
1121841 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No 4.0 06 12 2016   grade_7 68.0   0.0   0.0     1.0     1.0   34.0 36.0             31     10   70 68   0   0     1     1   34 36         31   10   70
1522893 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1613010 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2020   grade_7 62.0 1.0 5.0         0.0     3.0   32.0 39.0     *       41     8   71 62 1 5         0     3   32 39         41   8   71
2138988 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2018   grade_7 62.0   1.0         0.0     3.0   30.0 36.0     0       33     10   66 62   1         0     3   30 36     0   33   10   66
2228649 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 63.0 0.0 1.0         0.0     3.0   36.0 31.0     *       32     11   67 63 0 1         0     3   36 31         32   11   67
835363 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_7 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
1031629 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
1121822 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   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
1522874 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1612991 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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   0   0
2138969 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 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   0   0
2228630 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 1 0 0   0     0     0   0 1                 1
835344 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No 4 06 12 2015   grade_7 53.0   0.0         1.0     2.0   28.0 28.0             28     8   56 53   0         1     2   28 28         28   8   56
1031610 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_7 52.0   2.0         3.0     1.0   25.0 33.0     *       34     *   58 52   2         3     1   25 33         34       58
1121803 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 69.0   3.0         0.0     1.0   38.0 35.0             40     11   73 69   3         0     1   38 35         40   11   73
1522855 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 40.0 0.0 6.0         1.0     0.0   22.0 25.0     *       28     6   47 40 0 6         1     0   22 25         28   6   47
1612972 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 62.0 1.0 4.0         0.0     2.0   30.0 39.0     *       36     9   69 62 1 4         0     2   30 39         36   9   69
2138950 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_7 54.0   3.0         1.0     4.0   23.0 39.0     *       35     11   62 54   3         1     4   23 39         35   11   62
2228611 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_7 54.0 0.0 5.0         0.0     2.0   33.0 28.0     *       29     8   61 54 0 5         0     2   33 28         29   8   61
835325 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1031591 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
1121784 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1522836 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1612953 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   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
2138931 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY 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 0     0   0   0   0
2228592 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
835306 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No 1 KG 08 2015   grade_7 15.0 0.0 0.0                   11.0 4.0             7     *   15 15 0 0                   11 4         7       15
1031572 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2017   grade_7 13.0 0.0 1.0   0.0               7.0 7.0             5     *   14 13 0 1   0               7 7         5       14
1121765 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No 1.0 KG 08 2016   grade_7 12.0 1.0 0.0   0.0               6.0 7.0             6     *   13 12 1 0   0               6 7         6       13
1522817 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   grade_7 14.0       0.0               6.0 8.0             7     *   14 14       0               6 8         7       14
1612934 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2020   grade_7 12.0 0.0 0.0   0.0               6.0 6.0             6     *   12 12 0 0   0               6 6         6       12
2138912 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2018   grade_7 9.0 0.0 0.0   0.0               5.0 4.0             6     *   9 9 0 0   0               5 4         6       9
2228573 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2019   grade_7 13.0 0.0 0.0   0.0               6.0 7.0             8     *   13 13 0 0   0               6 7         8       13
835287 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No 2 05 08 2015   grade_7 70.0 0.0 4.0         0.0     0.0   47.0 27.0             28     11   74 70 0 4         0     0   47 27         28   11   74
1031553 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Elementary 03 08 2017   grade_7 69.0 2.0 3.0         1.0         42.0 33.0     *       38     8   75 69 2 3         1         42 33         38   8   75
1121746 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_7 56.0 0.0 1.0         1.0     0.0   32.0 26.0             28     9   58 56 0 1         1     0   32 26         28   9   58
1522798 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 71.0 0.0 2.0   1.0     0.0     0.0   37.0 37.0     *       26     9   74 71 0 2   1     0     0   37 37         26   9   74
1612915 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 60.0 0.0 0.0   0.0           0.0   32.0 28.0     *       31     10   60 60 0 0   0           0   32 28         31   10   60
2138893 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 04 08 2018   grade_7 65.0 1.0 1.0         1.0         25.0 43.0     *       33     10   68 65 1 1         1         25 43         33   10   68
2228554 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 65.0 1.0 0.0         0.0     0.0   30.0 36.0     *       *     7   66 65 1 0         0     0   30 36             7   66
835268 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No 1 PK 04 2015   grade_7 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1031534 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   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
1121727 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2016   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1522779 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_7 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
1612896 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
2138874 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
2228535 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   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
835249 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No 3 09 12 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1031515 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   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
1121708 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1522760 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1612877 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
2138855 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH 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
2228516 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
835230 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No 2 05 08 2015   grade_7 113.0   4.0   0.0     1.0     0.0   53.0 65.0             45     19   118 113   4   0     1     0   53 65         45   19   118
1031496 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2017   grade_7 97.0   3.0         0.0     1.0   53.0 48.0     *       38     19   101 97   3         0     1   53 48         38   19   101
1121689 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No 2.0 05 08 2016   grade_7 107.0 0.0 0.0         2.0     1.0   60.0 50.0             39     16   110 107 0 0         2     1   60 50         39   16   110
1522741 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2021   grade_7 68.0 1.0 3.0   0.0     1.0     1.0   39.0 35.0             34     13   74 68 1 3   0     1     1   39 35         34   13   74
1612858 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2020   grade_7 85.0 1.0 6.0   0.0     0.0         34.0 58.0     *       43     19   92 85 1 6   0     0         34 58         43   19   92
2138836 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2018   grade_7 98.0 0.0 2.0               2.0   63.0 39.0     *       41     16   102 98 0 2               2   63 39         41   16   102
2228497 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2019   grade_7 89.0 0.0 3.0               2.0   44.0 50.0             34     23   94 89 0 3               2   44 50         34   23   94
835211 NY Wyoming   school 3603420 670201060000   ATTICA 360342000100 670201060003 SHELDON ELEMENTARY SCHOOL public Regular School No 1 KG 04 2015   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0

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