Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_9 · 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
835479 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   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
1031745 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   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
1121938 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1523009 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1613107 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 10 2020   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
2139085 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE 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           0   0 0         0   0   0
2228746 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_9 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
835460 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3 07 12 2015   grade_9 51.0 0.0 1.0   0.0     0.0     0.0   34.0 18.0             34     15   52 51 0 1   0     0     0   34 18         34   15   52
1031726 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_9 50.0 1.0 1.0         0.0     1.0   26.0 27.0             31     10   53 50 1 1         0     1   26 27         31   10   53
1121919 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_9 63.0 0.0 2.0   0.0     0.0     1.0   40.0 26.0             30     12   66 63 0 2   0     0     1   40 26         30   12   66
1522990 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_9 38.0 0.0 1.0   1.0     0.0     2.0   27.0 15.0             21     11   42 38 0 1   1     0     2   27 15         21   11   42
1613088 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_9 46.0 0.0 1.0   0.0     0.0     4.0   27.0 24.0             39     14   51 46 0 1   0     0     4   27 24         39   14   51
2139066 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_9 57.0 1.0 2.0         0.0     1.0   31.0 30.0             45     21   61 57 1 2         0     1   31 30         45   21   61
2228727 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_9 44.0 0.0 0.0   0.0     1.0     2.0   22.0 25.0             31     9   47 44 0 0   0     1     2   22 25         31   9   47
835441 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No 1 PK 05 2015   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
1031707 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
1121900 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   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
1522971 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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
1613069 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
2139047 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 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
2228708 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   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
835422 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No 2 06 08 2015   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
1031688 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
1121881 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   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
1522952 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1613050 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
2139028 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 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
2228689 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
835403 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No 3 09 12 2015   grade_9 130.0 1.0 7.0   1.0     1.0     2.0   82.0 60.0             88     20   142 130 1 7   1     1     2   82 60         88   20   142
1031669 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2017   grade_9 101.0 0.0 9.0   0.0     1.0     2.0   51.0 62.0     0       69     25   113 101 0 9   0     1     2   51 62     0   69   25   113
1121862 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No 3.0 09 12 2016   grade_9 116.0 2.0 5.0   0.0     3.0     3.0   77.0 52.0             71     20   129 116 2 5   0     3     3   77 52         71   20   129
1522933 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2021   grade_9 100.0 1.0 2.0   0.0     0.0     3.0   51.0 55.0             51     9   106 100 1 2   0     0     3   51 55         51   9   106
1613031 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2020   grade_9 92.0   8.0   0.0     1.0     4.0   59.0 46.0     *       48     9   105 92   8   0     1     4   59 46         48   9   105
2139009 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_9 110.0 0.0 3.0   0.0     1.0     4.0   57.0 61.0     *       67     17   118 110 0 3   0     1     4   57 61         67   17   118
2228670 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2019   grade_9 100.0 0.0 7.0   1.0     1.0     4.0   57.0 56.0     *       73     19   113 100 0 7   1     1     4   57 56         73   19   113
1522914 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
835384 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No 4 06 12 2015   grade_9 68.0   0.0   0.0     0.0     0.0   35.0 33.0             27     5   68 68   0   0     0     0   35 33         27   5   68
1031650 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No Other 06 12 2017   grade_9 62.0   1.0   0.0     1.0     0.0   28.0 36.0     0       32     5   64 62   1   0     1     0   28 36     0   32   5   64
1121843 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No 4.0 06 12 2016   grade_9 83.0   2.0   0.0     2.0     3.0   45.0 45.0             33     *   90 83   2   0     2     3   45 45         33       90
1522895 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 56.0 0.0 0.0         1.0     2.0   32.0 27.0     *       *     *   59 56 0 0         1     2   32 27                 59
1613012 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2020   grade_9 52.0 1.0 2.0         0.0     2.0   29.0 28.0     *       30     7   57 52 1 2         0     2   29 28         30   7   57
2138990 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2018   grade_9 73.0   0.0         2.0     0.0   33.0 42.0     *       39     14   75 73   0         2     0   33 42         39   14   75
2228651 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_9 69.0 1.0 0.0         1.0     0.0   28.0 43.0     *       30     10   71 69 1 0         1     0   28 43         30   10   71
835365 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   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
1031631 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
1121824 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   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
1522876 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1612993 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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   0   0
2138971 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 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   0   0
2228632 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   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
835346 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No 4 06 12 2015   grade_9 63.0   1.0         0.0     0.0   31.0 33.0             36     10   64 63   1         0     0   31 33         36   10   64
1031612 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   grade_9 58.0   0.0         1.0     2.0   31.0 30.0     *       33     9   61 58   0         1     2   31 30         33   9   61
1121805 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_9 66.0   1.0         0.0     2.0   35.0 34.0             31     8   69 66   1         0     2   35 34         31   8   69
1522857 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_9 49.0 0.0 6.0         0.0     2.0   32.0 25.0     *       25     6   57 49 0 6         0     2   32 25         25   6   57
1612974 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_9 52.0 0.0 5.0         1.0     3.0   24.0 37.0     0       32     10   61 52 0 5         1     3   24 37     0   32   10   61
2138952 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_9 66.0   4.0         0.0     1.0   35.0 36.0     *       41     12   71 66   4         0     1   35 36         41   12   71
2228613 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_9 56.0 0.0 4.0         3.0     0.0   31.0 32.0     *       32     *   63 56 0 4         3     0   31 32         32       63
835327 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   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
1031593 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
1121786 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1522838 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1612955 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   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
2138933 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY 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 0     0   0   0   0
2228594 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
835308 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No 1 KG 08 2015   grade_9 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1031574 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2017   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
1121767 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No 1.0 KG 08 2016   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
1522819 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   grade_9 0.0       0.0               0.0 0.0             0     0   0 0       0               0 0         0   0   0
1612936 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2020   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
2138914 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 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
2228575 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2019   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
835289 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No 2 05 08 2015   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
1031555 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Elementary 03 08 2017   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
1121748 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1522800 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2021   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
1612917 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
2138895 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 04 08 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
2228556 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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
835270 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No 1 PK 04 2015   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
1031536 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   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
1121729 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2016   grade_9 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1522781 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_9 0.0 0.0 0.0                   0.0 0.0     *       0     0   0 0 0 0                   0 0         0   0   0
1612898 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
2138876 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
2228537 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   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
835251 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No 3 09 12 2015   grade_9 71.0 0.0 0.0         2.0     1.0   30.0 44.0             30     8   74 71 0 0         2     1   30 44         30   8   74
1031517 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 75.0 0.0 4.0         0.0     0.0   48.0 31.0     *       35     11   79 75 0 4         0     0   48 31         35   11   79
1121710 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_9 61.0 0.0 2.0         0.0     1.0   33.0 31.0             28     8   64 61 0 2         0     1   33 31         28   8   64
1522762 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 76.0 1.0 2.0   1.0     0.0     0.0   38.0 42.0     *       30     10   80 76 1 2   1     0     0   38 42         30   10   80
1612879 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 66.0 0.0 0.0         1.0     1.0   25.0 43.0     *       28     10   68 66 0 0         1     1   25 43         28   10   68
2138857 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_9 61.0   1.0         1.0         35.0 28.0     *       31     9   63 61   1         1         35 28         31   9   63
2228518 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 66.0 3.0 2.0         1.0         39.0 33.0     *       29     11   72 66 3 2         1         39 33         29   11   72
835232 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No 2 05 08 2015   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
1031498 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2017   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
1121691 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No 2.0 05 08 2016   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
1522743 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2021   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
1612860 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2020   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
2138838 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 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
2228499 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2019   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
835213 NY Wyoming   school 3603420 670201060000   ATTICA 360342000100 670201060003 SHELDON ELEMENTARY SCHOOL public Regular School No 1 KG 04 2015   grade_9 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]);