Data source: Big Local News · About: Big Local

90,079 rows where state = "NY" and year = 2021 sorted by rowid descending

View and edit SQL

year

  • 2021 · 89,979
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
1522916 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1522915 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
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
1522913 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 61.0 1.0 4.0         0.0     3.0   32.0 37.0             39     8   69 61 1 4         0     3   32 37         39   8   69
1522912 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 42.0 1.0 3.0         1.0     2.0   26.0 23.0             29     5   49 42 1 3         1     2   26 23         29   5   49
1522911 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 61.0 1.0 3.0         0.0     4.0   34.0 35.0             34     6   69 61 1 3         0     4   34 35         34   6   69
1522910 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
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
1522908 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1522907 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1522906 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1522905 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1522904 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1522903 NY Wyoming   school 3629940 671501040000   WARSAW 362994006730 671501040004 WARSAW MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1522902 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   ungraded_secondary 2.0 0.0 0.0         0.0     0.0   1.0 1.0     *       *     *   2 2 0 0         0     0   1 1                 2
1522901 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522900 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522899 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522898 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 247.0 2.0 2.0         4.0     6.0   121.0 140.0     *       116     42   261 247 2 2         4     6   121 140         116   42   261
1522897 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522896 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
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
1522894 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522893 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1522892 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522891 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
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
1522889 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522888 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522887 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_12 68.0 0.0 0.0         2.0     1.0   31.0 40.0     *       33     10   71 68 0 0         2     1   31 40         33   10   71
1522886 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_11 70.0 1.0 1.0         1.0     1.0   29.0 45.0     *       28     11   74 70 1 1         1     1   29 45         28   11   74
1522885 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   grade_10 51.0 1.0 1.0         0.0     2.0   28.0 27.0     *       27     10   55 51 1 1         0     2   28 27         27   10   55
1522884 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1522883 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522882 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522881 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_half_day 25.0 0.0 0.0   0.0     0.0     0.0   13.0 12.0     0       8     *   25 25 0 0   0     0     0   13 12     0   8       25
1522880 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522879 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 350.0 2.0 17.0   1.0     3.0     10.0   195.0 188.0     6       191     39   383 350 2 17   1     3     10   195 188     6   191   39   383
1522878 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522877 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 69.0 0.0 2.0   0.0     0.0     4.0   39.0 36.0     *       30     9   75 69 0 2   0     0     4   39 36         30   9   75
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
1522875 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522874 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1522873 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522872 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_5 60.0 0.0 2.0   0.0     0.0     0.0   37.0 25.0     0       39     5   62 60 0 2   0     0     0   37 25     0   39   5   62
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
1522870 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_3 50.0 1.0 4.0   0.0     0.0     2.0   29.0 28.0     0       29     5   57 50 1 4   0     0     2   29 28     0   29   5   57
1522869 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 47.0 0.0 0.0   0.0     0.0     0.0   28.0 19.0     0       20     *   47 47 0 0   0     0     0   28 19     0   20       47
1522868 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522867 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522866 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   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   0   0
1522865 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_1 45.0 0.0 5.0   0.0     1.0     1.0   22.0 30.0     *       30     *   52 45 0 5   0     1     1   22 30         30       52
1522864 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   ungraded_secondary 1.0 0.0 1.0         0.0     0.0   1.0 1.0     *       *     *   2 1 0 1         0     0   1 1                 2
1522863 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
1522862 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
1522861 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
1522860 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   pk_12_total 315.0 2.0 28.0         5.0     8.0   172.0 186.0     7       176     44   358 315 2 28         5     8   172 186     7   176   44   358
1522859 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
1522858 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
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
1522856 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_8 63.0 1.0 3.0         0.0     2.0   30.0 39.0     0       37     8   69 63 1 3         0     2   30 39     0   37   8   69
1522855 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_7 40.0 0.0 6.0         1.0     0.0   22.0 25.0     *       28     6   47 40 0 6         1     0   22 25         28   6   47
1522854 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
1522853 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
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
1522851 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
1522850 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
1522849 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_12 63.0 1.0 4.0         0.0     1.0   34.0 35.0     0       29     6   69 63 1 4         0     1   34 35     0   29   6   69
1522848 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_11 45.0 0.0 3.0         3.0     0.0   28.0 23.0     *       *     *   51 45 0 3         3     0   28 23                 51
1522847 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   grade_10 54.0 0.0 5.0         1.0     3.0   25.0 38.0     0       33     12   63 54 0 5         1     3   25 38     0   33   12   63
1522846 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2021   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
1522845 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1522844 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1522843 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pre_kindergarten_half_day 34.0 0.0 1.0         0.0     0.0   10.0 25.0     0       6     *   35 34 0 1         0     0   10 25     0   6       35
1522842 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1522841 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   pk_12_total 402.0 5.0 17.0         6.0     5.0   221.0 214.0     8       194     53   435 402 5 17         6     5   221 214     8   194   53   435
1522840 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1522839 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_full_day 46.0 4.0 1.0         2.0     0.0   32.0 21.0     *       23     9   53 46 4 1         2     0   32 21         23   9   53
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
1522837 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1522836 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1522835 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_6 60.0 0.0 1.0         0.0     2.0   28.0 35.0     0       30     7   63 60 0 1         0     2   28 35     0   30   7   63
1522834 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_5 50.0 0.0 6.0         0.0     3.0   32.0 27.0     *       31     *   59 50 0 6         0     3   32 27         31       59
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
1522832 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_3 51.0 0.0 2.0         1.0     0.0   30.0 24.0     *       24     *   54 51 0 2         1     0   30 24         24       54
1522831 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_2 49.0 0.0 2.0         1.0     0.0   28.0 24.0     0       24     8   52 49 0 2         1     0   28 24     0   24   8   52
1522830 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1522829 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1522828 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   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
1522827 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_1 54.0 1.0 2.0         2.0     0.0   31.0 28.0     *       29     10   59 54 1 2         2     0   31 28         29   10   59
1522826 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   ungraded_secondary 0.0       0.0               0.0 0.0             0     0   0 0       0               0 0         0   0   0
1522825 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   ungraded_elementary 0.0       0.0               0.0 0.0             0     0   0 0       0               0 0         0   0   0
1522824 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   pre_kindergarten_half_day 0.0       0.0               0.0 0.0             0     0   0 0       0               0 0         0   0   0
1522823 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   pre_kindergarten_full_day 0.0       0.0               0.0 0.0             0     0   0 0       0               0 0         0   0   0
1522822 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   pk_12_total 120.0       1.0               65.0 56.0             52     15   121 120       1               65 56         52   15   121
1522821 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   kindergarten_half_day 0.0       0.0               0.0 0.0             0     0   0 0       0               0 0         0   0   0
1522820 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   kindergarten_full_day 11.0       0.0               3.0 8.0             *     0   11 11       0               3 8             0   11
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
1522818 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   grade_8 13.0       0.0               7.0 6.0             6     *   13 13       0               7 6         6       13
1522817 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2021   grade_7 14.0       0.0               6.0 8.0             7     *   14 14       0               6 8         7       14

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