Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_4 · 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
835474 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_4 51.0 0.0 1.0   0.0     0.0     0.0   31.0 21.0             40     10   52 51 0 1   0     0     0   31 21         40   10   52
1031740 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 11 2017   grade_4 46.0 0.0 3.0   0.0           0.0   26.0 23.0             34     9   49 46 0 3   0           0   26 23         34   9   49
1121933 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 30.0 0.0 1.0   1.0     0.0     1.0   21.0 12.0             18     5   33 30 0 1   1     0     1   21 12         18   5   33
1523004 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_4 55.0 0.0 0.0               3.0   29.0 29.0             37     8   58 55 0 0               3   29 29         37   8   58
1613102 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Other PK 10 2020   grade_4 27.0 0.0 4.0               1.0   19.0 13.0             18     *   32 27 0 4               1   19 13         18       32
2139080 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 43.0 1.0 3.0   0.0           0.0   24.0 23.0             33     11   47 43 1 3   0           0   24 23         33   11   47
2228741 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 60.0   5.0               2.0   38.0 29.0             42     14   67 60   5               2   38 29         42   14   67
835455 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3 07 12 2015   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031721 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   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
1121914 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1522985 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1613083 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139061 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 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
2228722 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835436 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No 1 PK 05 2015   grade_4 72.0 0.0 5.0         1.0     3.0   42.0 39.0             39     *   81 72 0 5         1     3   42 39         39       81
1031702 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_4 81.0 0.0 6.0         0.0     2.0   42.0 47.0     *       52     16   89 81 0 6         0     2   42 47         52   16   89
1121895 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_4 92.0 1.0 2.0         1.0     3.0   45.0 54.0             53     22   99 92 1 2         1     3   45 54         53   22   99
1522966 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 96.0 0.0 2.0         0.0     0.0   45.0 53.0     0       57     13   98 96 0 2         0     0   45 53     0   57   13   98
1613064 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_4 93.0 0.0 2.0         0.0     1.0   53.0 43.0     0       59     15   96 93 0 2         0     1   53 43     0   59   15   96
2139042 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_4 83.0 0.0 3.0         3.0     5.0   53.0 41.0     *       60     14   94 83 0 3         3     5   53 41         60   14   94
2228703 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_4 112.0   2.0         1.0     2.0   61.0 56.0     *       66     18   117 112   2         1     2   61 56         66   18   117
835417 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No 2 06 08 2015   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
1031683 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
1121876 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   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
1522947 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1613045 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
2139023 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2228684 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
835398 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No 3 09 12 2015   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031664 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1121857 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No 3.0 09 12 2016   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1522928 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2021   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1613026 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2020   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
2139004 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY 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         0   0   0
2228665 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2019   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1522909 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
835379 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No 4 06 12 2015   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
1031645 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No Other 06 12 2017   grade_4 0.0   0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0   0   0     0     0   0 0     0   0   0   0
1121838 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No 4.0 06 12 2016   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
1522890 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1613007 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2020   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
2138985 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 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
2228646 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   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
835360 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_4 66.0   1.0   1.0     0.0     2.0   34.0 36.0             36     11   70 66   1   1     0     2   34 36         36   11   70
1031626 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 58.0   2.0   0.0     0.0     1.0   31.0 30.0     0       33     *   61 58   2   0     0     1   31 30     0   33       61
1121819 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_4 61.0   1.0   0.0     1.0     2.0   34.0 31.0             32     12   65 61   1   0     1     2   34 31         32   12   65
1522871 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 54.0 1.0 4.0   1.0     2.0     3.0   27.0 38.0     *       35     11   65 54 1 4   1     2     3   27 38         35   11   65
1612988 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_4 66.0 0.0 2.0   0.0     0.0     0.0   38.0 30.0     0       40     8   68 66 0 2   0     0     0   38 30     0   40   8   68
2138966 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_4 41.0 1.0 2.0   0.0     2.0     2.0   22.0 26.0     *       27     *   48 41 1 2   0     2     2   22 26         27       48
2228627 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_4 62.0 2.0 2.0   0.0     0.0     4.0   37.0 33.0     *       32     7   70 62 2 2   0     0     4   37 33         32   7   70
835341 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No 4 06 12 2015   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
1031607 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   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
1121800 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   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
1522852 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1612969 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2138947 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 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
2228608 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   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
835322 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_4 53.0 0.0 2.0         1.0     2.0   24.0 34.0             27     8   58 53 0 2         1     2   24 34         27   8   58
1031588 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_4 65.0 0.0 3.0         0.0     2.0   33.0 37.0     *       37     9   70 65 0 3         0     2   33 37         37   9   70
1121781 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 49.0 0.0 4.0         0.0     3.0   29.0 27.0             30     5   56 49 0 4         0     3   29 27         30   5   56
1522833 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_4 58.0 0.0 2.0         0.0     0.0   30.0 30.0     *       27     10   60 58 0 2         0     0   30 30         27   10   60
1612950 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_4 52.0 0.0 8.0         0.0     3.0   34.0 29.0     *       33     7   63 52 0 8         0     3   34 29         33   7   63
2138928 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 41.0   4.0         1.0     0.0   21.0 25.0     *       26     6   46 41   4         1     0   21 25         26   6   46
2228589 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 60.0 0.0 0.0         0.0     2.0   29.0 33.0     0       33     7   62 60 0 0         0     2   29 33     0   33   7   62
835303 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No 1 KG 08 2015   grade_4 10.0 0.0 0.0                   7.0 3.0             *     *   10 10 0 0                   7 3                 10
1031569 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2017   grade_4 10.0 0.0 0.0   0.0               5.0 5.0             6     0   10 10 0 0   0               5 5         6   0   10
1121762 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No 1.0 KG 08 2016   grade_4 12.0 0.0 0.0   0.0               4.0 8.0             7     0   12 12 0 0   0               4 8         7   0   12
1522814 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   grade_4 15.0       0.0               8.0 7.0             6     *   15 15       0               8 7         6       15
1612931 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2020   grade_4 14.0 0.0 0.0   0.0               10.0 4.0             8     *   14 14 0 0   0               10 4         8       14
2138909 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2018   grade_4 15.0 0.0 0.0   0.0               7.0 8.0             11     *   15 15 0 0   0               7 8         11       15
2228570 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2019   grade_4 11.0 1.0 0.0   0.0               7.0 5.0             6     *   12 11 1 0   0               7 5         6       12
835284 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No 2 05 08 2015   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
1031550 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Elementary 03 08 2017   grade_4 3.0 0.0 0.0         0.0         3.0 0.0     *       *     *   3 3 0 0         0         3 0                 3
1121743 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1522795 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1612912 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
2138890 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 04 08 2018   grade_4 2.0 0.0 0.0         0.0         1.0 1.0     *       *     *   2 2 0 0         0         1 1                 2
2228551 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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
835265 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No 1 PK 04 2015   grade_4 62.0   0.0         1.0     2.0   25.0 40.0             22     7   65 62   0         1     2   25 40         22   7   65
1031531 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_4 62.0 0.0 0.0         0.0     0.0   35.0 27.0     *       31     9   62 62 0 0         0     0   35 27         31   9   62
1121724 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2016   grade_4 63.0   1.0               2.0   30.0 36.0             27     *   66 63   1               2   30 36         27       66
1522776 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_4 71.0 1.0 1.0                   37.0 36.0     *       32     8   73 71 1 1                   37 36         32   8   73
1612893 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_4 59.0 0.0 3.0   1.0     1.0         34.0 30.0     *       31     7   64 59 0 3   1     1         34 30         31   7   64
2138871 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_4 64.0 0.0 2.0         0.0     0.0   33.0 33.0     *       27     *   66 64 0 2         0     0   33 33         27       66
2228532 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_4 71.0 1.0 3.0         0.0     2.0   39.0 38.0     *       42     15   77 71 1 3         0     2   39 38         42   15   77
835246 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No 3 09 12 2015   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
1031512 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   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
1121705 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1522757 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1612874 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
2138852 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH 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
2228513 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
835227 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No 2 05 08 2015   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
1031493 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2017   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
1121686 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No 2.0 05 08 2016   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
1522738 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2021   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1612855 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2020   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
2138833 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 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
2228494 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2019   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
835208 NY Wyoming   school 3603420 670201060000   ATTICA 360342000100 670201060003 SHELDON ELEMENTARY SCHOOL public Regular School No 1 KG 04 2015   grade_4 21.0   1.0               2.0   13.0 11.0             12     6   24 21   1               2   13 11         12   6   24

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