Data source: Big Local News · About: Big Local

90,193 rows where state = "NY" and year = 2016 sorted by school_nces_id

View and edit SQL

year

  • 2016 · 90,193
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
1054458 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054459 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_10 78.0 0.0 1.0         0.0         41.0 38.0             51     14   79 78 0 1         0         41 38         51   14   79
1054460 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_11 75.0 2.0 0.0         0.0         43.0 34.0             55     9   77 75 2 0         0         43 34         55   9   77
1054461 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_12 61.0 0.0 0.0         1.0         31.0 31.0             36     13   62 61 0 0         1         31 31         36   13   62
1054462 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054463 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054464 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN 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
1054465 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054466 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054467 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1054468 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054469 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_9 69.0 0.0 0.0         0.0         29.0 40.0             43     14   69 69 0 0         0         29 40         43   14   69
1054470 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054471 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054472 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   pk_12_total 283.0 2.0 1.0         1.0         144.0 143.0             185     50   287 283 2 1         1         144 143         185   50   287
1054473 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054474 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054475 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054476 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1054439 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_1 52.0                       22.0 30.0             35     0   52 52                       22 30         35   0   52
1054440 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_10 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054441 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_11 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054442 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_12 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054443 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_2 65.0                       29.0 36.0             49     7   65 65                       29 36         49   7   65
1054444 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_3 72.0                       32.0 40.0             38     12   72 72                       32 40         38   12   72
1054445 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_4 59.0                       25.0 34.0             38     6   59 59                       25 34         38   6   59
1054446 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_5 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054447 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_6 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054448 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_7 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054449 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_8 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054450 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   grade_9 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054451 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   kindergarten_full_day 56.0                       25.0 31.0             35     *   56 56                       25 31         35       56
1054452 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   kindergarten_half_day 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054453 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   pk_12_total 338.0                       154.0 184.0             215     31   338 338                       154 184         215   31   338
1054454 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   pre_kindergarten_full_day 34.0                       21.0 13.0             20     *   34 34                       21 13         20       34
1054455 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   pre_kindergarten_half_day 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054456 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   ungraded_elementary 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054457 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 4 2016   ungraded_secondary 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1054477 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_1 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054478 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_10 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054479 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_11 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054480 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_12 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054481 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_2 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054482 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_3 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054483 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_4 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054484 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_5 67.0             0.0         31.0 36.0             40     *   67 67             0         31 36         40       67
1054485 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_6 62.0             1.0         36.0 27.0             36     10   63 62             1         36 27         36   10   63
1054486 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_7 78.0             0.0         35.0 43.0             51     9   78 78             0         35 43         51   9   78
1054487 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_8 65.0             0.0         31.0 34.0             43     13   65 65             0         31 34         43   13   65
1054488 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_9 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054489 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   kindergarten_full_day 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054490 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   kindergarten_half_day 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054491 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   pk_12_total 273.0             1.0         134.0 140.0             170     40   274 273             1         134 140         170   40   274
1054492 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   pre_kindergarten_full_day 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054493 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   pre_kindergarten_half_day 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1054494 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   ungraded_elementary 1.0             0.0         1.0 0.0             0     *   1 1             0         1 0         0       1
1054495 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   ungraded_secondary 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
1085846 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085847 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_10 76.0 1.0 1.0   1.0     1.0     4.0   44.0 40.0             25     *   84 76 1 1   1     1     4   44 40         25       84
1085848 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_11 71.0 1.0 3.0   0.0     0.0     3.0   42.0 36.0             29     9   78 71 1 3   0     0     3   42 36         29   9   78
1085849 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_12 69.0 0.0 2.0   0.0     1.0     5.0   34.0 43.0             24     5   77 69 0 2   0     1     5   34 43         24   5   77
1085850 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085851 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085852 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY 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         0   0   0
1085853 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085854 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085855 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1085856 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085857 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_9 64.0 1.0 0.0   0.0     1.0     2.0   30.0 38.0             28     *   68 64 1 0   0     1     2   30 38         28       68
1085858 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085859 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085860 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   pk_12_total 280.0 3.0 6.0   1.0     3.0     14.0   150.0 157.0             106     23   307 280 3 6   1     3     14   150 157         106   23   307
1085861 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085862 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085863 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085864 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1085827 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_1 103.0   1.0         0.0     1.0   54.0 51.0             48     *   105 103   1         0     1   54 51         48       105
1085828 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085829 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085830 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085831 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 59.0   2.0         1.0     1.0   32.0 31.0             37     6   63 59   2         1     1   32 31         37   6   63
1085832 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_3 70.0   3.0         0.0     3.0   40.0 36.0             38     14   76 70   3         0     3   40 36         38   14   76
1085833 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_4 72.0   2.0         1.0     3.0   40.0 38.0             28     17   78 72   2         1     3   40 38         28   17   78
1085834 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085835 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085836 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_7 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1085837 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085838 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_9 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1085839 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   kindergarten_full_day 73.0   1.0         0.0     6.0   39.0 41.0             37     *   80 73   1         0     6   39 41         37       80
1085840 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085841 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   pk_12_total 377.0   9.0         2.0     14.0   205.0 197.0             188     44   402 377   9         2     14   205 197         188   44   402
1085842 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085843 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085844 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085845 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   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
1085865 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1085866 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1085867 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1085868 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1085869 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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

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