Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2018 · 89,718
Link rowid ▲ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2139092 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_secondary 1.0 0.0 0.0   0.0           0.0   1.0 0.0             *     *   1 1 0 0   0           0   1 0                 1
2139091 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   ungraded_elementary 4.0 0.0 0.0   0.0           0.0   2.0 2.0             *     *   4 4 0 0   0           0   2 2                 4
2139090 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pre_kindergarten_half_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139089 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pre_kindergarten_full_day 33.0 0.0 1.0   0.0           0.0   19.0 15.0             23     8   34 33 0 1   0           0   19 15         23   8   34
2139088 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pk_12_total 347.0 1.0 14.0   1.0           10.0   200.0 173.0             252     78   373 347 1 14   1           10   200 173         252   78   373
2139087 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_half_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139086 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 48.0 0.0 2.0   0.0           4.0   23.0 31.0             37     9   54 48 0 2   0           4   23 31         37   9   54
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
2139084 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_8 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           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
2139082 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_6 30.0 0.0 1.0   1.0           2.0   20.0 14.0             *     6   34 30 0 1   1           2   20 14             6   34
2139081 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_5 41.0 0.0 3.0   0.0           0.0   26.0 18.0             31     9   44 41 0 3   0           0   26 18         31   9   44
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
2139079 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_3 61.0 0.0 1.0   0.0           0.0   37.0 25.0             41     14   62 61 0 1   0           0   37 25         41   14   62
2139078 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_2 32.0 0.0 3.0   0.0           1.0   20.0 16.0             24     6   36 32 0 3   0           1   20 16         24   6   36
2139077 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_12 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139076 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_11 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139075 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_10 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2139074 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 54.0 0.0 0.0   0.0           3.0   28.0 29.0             41     10   57 54 0 0   0           3   28 29         41   10   57
2139073 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   ungraded_secondary 1.0 0.0 0.0         0.0     0.0   0.0 1.0             *     *   1 1 0 0         0     0   0 1                 1
2139072 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139071 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139070 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   pre_kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139069 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   pk_12_total 286.0 2.0 5.0         1.0     2.0   158.0 138.0             185     69   296 286 2 5         1     2   158 138         185   69   296
2139068 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139067 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
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
2139065 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_8 43.0 1.0 0.0         1.0     0.0   22.0 23.0             28     9   45 43 1 0         1     0   22 23         28   9   45
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
2139063 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139062 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
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
2139060 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_3 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139059 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139058 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_12 42.0 0.0 1.0         0.0     0.0   24.0 19.0             27     *   43 42 0 1         0     0   24 19         27       43
2139057 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_11 51.0 0.0 2.0         0.0     0.0   34.0 19.0             24     12   53 51 0 2         0     0   34 19         24   12   53
2139056 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_10 46.0 0.0 0.0         0.0     0.0   21.0 25.0             *     12   46 46 0 0         0     0   21 25             12   46
2139055 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2139054 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139053 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   ungraded_elementary 0.0 0.0 1.0         0.0     0.0   0.0 1.0     0       *     *   1 0 0 1         0     0   0 1     0           1
2139052 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139051 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pre_kindergarten_full_day 29.0 0.0 0.0         0.0     0.0   14.0 15.0     0       *     *   29 29 0 0         0     0   14 15     0           29
2139050 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 595.0 1.0 21.0         4.0     11.0   329.0 303.0     8       394     99   632 595 1 21         4     11   329 303     8   394   99   632
2139049 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139048 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 93.0 1.0 3.0         0.0     1.0   43.0 55.0     *       64     *   98 93 1 3         0     1   43 55         64       98
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
2139046 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
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
2139044 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139043 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_5 76.0 0.0 6.0         0.0     2.0   42.0 42.0     *       47     15   84 76 0 6         0     2   42 42         47   15   84
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
2139041 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_3 117.0 0.0 3.0         1.0     2.0   62.0 61.0     *       76     24   123 117 0 3         1     2   62 61         76   24   123
2139040 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 92.0 0.0 2.0         0.0     1.0   55.0 40.0     0       65     15   95 92 0 2         0     1   55 40     0   65   15   95
2139039 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139038 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_11 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139037 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2139036 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 105.0 0.0 3.0         0.0     0.0   60.0 48.0     0       68     16   108 105 0 3         0     0   60 48     0   68   16   108
2139035 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   ungraded_secondary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139034 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   ungraded_elementary 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
2139033 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139032 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139031 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   pk_12_total 273.0 1.0 12.0   1.0     2.0     11.0   153.0 147.0             164     40   300 273 1 12   1     2     11   153 147         164   40   300
2139030 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139029 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
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
2139027 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 94.0 0.0 6.0   1.0     1.0     4.0   53.0 53.0             66     17   106 94 0 6   1     1     4   53 53         66   17   106
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
2139025 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_6 96.0 1.0 2.0   0.0     0.0     3.0   50.0 52.0             57     15   102 96 1 2   0     0     3   50 52         57   15   102
2139024 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   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
2139022 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_3 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139021 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139020 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139019 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139018 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139017 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139016 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   ungraded_secondary 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       0     *   1 1 0 0   0     0     0   0 1         0       1
2139015 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139014 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139013 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139012 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   pk_12_total 408.0 2.0 18.0   1.0     6.0     9.0   216.0 228.0     *       251     59   444 408 2 18   1     6     9   216 228         251   59   444
2139011 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139010 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
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
2139008 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         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
2139006 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139005 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         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
2139003 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_3 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139002 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139001 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_12 99.0 1.0 7.0   1.0     1.0     1.0   57.0 53.0     *       64     *   110 99 1 7   1     1     1   57 53         64       110
2139000 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_11 101.0 1.0 1.0   0.0     3.0     3.0   55.0 54.0     *       57     11   109 101 1 1   0     3     3   55 54         57   11   109
2138999 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_10 97.0 0.0 7.0   0.0     1.0     1.0   47.0 59.0     *       63     21   106 97 0 7   0     1     1   47 59         63   21   106
2138998 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2138997 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2018   ungraded_secondary 2.0   0.0         0.0     0.0   1.0 1.0     0       *     *   2 2   0         0     0   1 1     0           2
2138996 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2018   ungraded_elementary 0.0   0.0         0.0     0.0   0.0 0.0     0       0     0   0 0   0         0     0   0 0     0   0   0   0
2138995 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2018   pre_kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0     0       0     0   0 0   0         0     0   0 0     0   0   0   0
2138994 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2018   pre_kindergarten_full_day 0.0   0.0         0.0     0.0   0.0 0.0     0       0     0   0 0   0         0     0   0 0     0   0   0   0
2138993 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2018   pk_12_total 466.0   5.0         9.0     9.0   235.0 254.0     5       225     59   489 466   5         9     9   235 254     5   225   59   489

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