Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2016 · 90,093
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
1046084 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 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
1046085 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1046086 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 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
1046087 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 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
1046088 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 50.0 0.0 4.0         0.0     3.0   27.0 30.0             26     6   57 50 0 4         0     3   27 30         26   6   57
1046089 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_8 40.0 0.0 4.0         1.0     2.0   24.0 23.0             23     11   47 40 0 4         1     2   24 23         23   11   47
1046090 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_9 40.0 0.0 3.0         0.0     3.0   24.0 22.0             19     8   46 40 0 3         0     3   24 22         19   8   46
1046091 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 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
1046092 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 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
1046093 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   pk_12_total 224.0 1.0 16.0         1.0     11.0   129.0 124.0             103     40   253 224 1 16         1     11   129 124         103   40   253
1046094 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 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
1046095 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 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
1046096 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 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
1046097 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   ungraded_secondary 4.0 0.0 0.0         0.0     0.0   3.0 1.0             *     *   4 4 0 0         0     0   3 1                 4
1031753 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 32.0 9.0 4.0   0.0     4.0     2.0   31.0 20.0             12     7   51 32 9 4   0     4     2   31 20         12   7   51
1031754 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031755 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031756 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031757 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 30.0 7.0 4.0   0.0     1.0     3.0   18.0 27.0             19     *   45 30 7 4   0     1     3   18 27         19       45
1031758 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_3 29.0 8.0 5.0   1.0     3.0     3.0   26.0 23.0             15     0   49 29 8 5   1     3     3   26 23         15   0   49
1031759 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_4 22.0 9.0 9.0   0.0     2.0     3.0   13.0 32.0             9     0   45 22 9 9   0     2     3   13 32         9   0   45
1031760 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_5 25.0 12.0 1.0   0.0     5.0     1.0   14.0 30.0             12     *   44 25 12 1   0     5     1   14 30         12       44
1031761 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031762 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031763 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031764 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031765 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   kindergarten_full_day 28.0 12.0 3.0   0.0     2.0     3.0   23.0 25.0             14     *   48 28 12 3   0     2     3   23 25         14       48
1031766 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031767 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   pk_12_total 188.0 71.0 31.0   1.0     20.0     19.0   152.0 178.0             96     26   330 188 71 31   1     20     19   152 178         96   26   330
1031768 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   pre_kindergarten_full_day 20.0 8.0 3.0   0.0     1.0     4.0   19.0 17.0             6     *   36 20 8 3   0     1     4   19 17         6       36
1031769 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031770 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   ungraded_elementary 2.0 6.0 2.0   0.0     2.0     0.0   8.0 4.0             9     12   12 2 6 2   0     2     0   8 4         9   12   12
1031771 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 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
1031772 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_1 14.0 30.0 22.0   0.0     6.0     5.0   34.0 43.0             54     6   77 14 30 22   0     6     5   34 43         54   6   77
1031773 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031774 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031775 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031776 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 14.0 30.0 19.0   0.0     8.0     5.0   46.0 30.0             56     10   76 14 30 19   0     8     5   46 30         56   10   76
1031777 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_3 16.0 26.0 11.0   0.0     5.0     7.0   26.0 39.0             44     6   65 16 26 11   0     5     7   26 39         44   6   65
1031778 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 6.0 24.0 11.0   0.0     5.0     5.0   20.0 31.0             40     *   51 6 24 11   0     5     5   20 31         40       51
1031779 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 8.0 22.0 8.0   0.0     3.0     8.0   27.0 22.0             31     10   49 8 22 8   0     3     8   27 22         31   10   49
1031780 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_6 9.0 26.0 7.0   0.0     1.0     5.0   27.0 21.0             31     7   48 9 26 7   0     1     5   27 21         31   7   48
1031781 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031782 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031783 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031784 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 7.0 30.0 16.0   1.0     10.0     8.0   40.0 32.0             34     *   72 7 30 16   1     10     8   40 32         34       72
1031785 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031786 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pk_12_total 74.0 188.0 94.0   1.0     38.0     43.0   220.0 218.0             290     48   438 74 188 94   1     38     43   220 218         290   48   438
1031787 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031788 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031789 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031790 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 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
1031791 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 9.0 19.0 32.0   0.0     10.0     5.0   37.0 38.0             57     7   75 9 19 32   0     10     5   37 38         57   7   75
1031792 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031793 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031794 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031795 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 10.0 25.0 29.0   1.0     15.0     4.0   38.0 46.0             57     11   84 10 25 29   1     15     4   38 46         57   11   84
1031796 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_3 8.0 23.0 32.0   0.0     9.0     3.0   39.0 36.0             57     8   75 8 23 32   0     9     3   39 36         57   8   75
1031797 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_4 11.0 21.0 28.0   0.0     11.0     2.0   37.0 36.0             51     7   73 11 21 28   0     11     2   37 36         51   7   73
1031798 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_5 9.0 37.0 17.0   1.0     8.0     3.0   37.0 38.0             54     5   75 9 37 17   1     8     3   37 38         54   5   75
1031799 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031800 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031801 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031802 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031803 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   kindergarten_full_day 8.0 15.0 26.0   1.0     7.0     7.0   28.0 36.0             32     *   64 8 15 26   1     7     7   28 36         32       64
1031804 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031805 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   pk_12_total 61.0 141.0 175.0   3.0     60.0     24.0   224.0 240.0             313     43   464 61 141 175   3     60     24   224 240         313   43   464
1031806 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   pre_kindergarten_full_day 6.0 0.0 11.0   0.0     0.0     0.0   7.0 10.0             *     *   17 6 0 11   0     0     0   7 10                 17
1031807 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031808 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   ungraded_elementary 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 0 1 0   0     0     0   1 0                 1
1031809 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 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
1031810 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 52.0 24.0 8.0   0.0     3.0     9.0   57.0 39.0             42     16   96 52 24 8   0     3     9   57 39         42   16   96
1031811 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031812 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031813 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031814 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 50.0 16.0 11.0   0.0     8.0     4.0   51.0 38.0             21     11   89 50 16 11   0     8     4   51 38         21   11   89
1031815 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_3 42.0 15.0 16.0   1.0     7.0     10.0   57.0 34.0             22     14   91 42 15 16   1     7     10   57 34         22   14   91
1031816 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_4 32.0 19.0 11.0   0.0     3.0     7.0   44.0 28.0             29     10   72 32 19 11   0     3     7   44 28         29   10   72
1031817 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_5 42.0 21.0 5.0   0.0     4.0     6.0   38.0 40.0             18     *   78 42 21 5   0     4     6   38 40         18       78
1031818 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031819 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031820 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031821 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031822 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   kindergarten_full_day 39.0 22.0 9.0   0.0     5.0     4.0   43.0 36.0             *     11   79 39 22 9   0     5     4   43 36             11   79
1031823 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031824 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   pk_12_total 258.0 118.0 60.0   1.0     30.0     41.0   290.0 218.0             152     73   508 258 118 60   1     30     41   290 218         152   73   508
1031825 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031826 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031827 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   ungraded_elementary 1.0 1.0 0.0   0.0     0.0     1.0   0.0 3.0             *     *   3 1 1 0   0     0     1   0 3                 3
1031828 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 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
1031829 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_1 5.0 32.0 8.0   0.0     0.0     1.0   23.0 23.0             34     *   46 5 32 8   0     0     1   23 23         34       46
1031830 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 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
1031831 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 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
1031832 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 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
1031833 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_2 0.0 29.0 6.0   0.0     2.0     6.0   21.0 22.0             35     *   43 0 29 6   0     2     6   21 22         35       43
1031834 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_3 3.0 29.0 7.0   0.0     2.0     5.0   22.0 24.0             41     *   46 3 29 7   0     2     5   22 24         41       46
1031835 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_4 0.0 27.0 2.0   0.0     1.0     1.0   16.0 15.0             25     *   31 0 27 2   0     1     1   16 15         25       31
1031836 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_5 3.0 14.0 8.0   0.0     1.0     3.0   19.0 10.0             21     *   29 3 14 8   0     1     3   19 10         21       29
1031837 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_6 1.0 20.0 9.0   0.0     1.0     0.0   18.0 13.0             25     9   31 1 20 9   0     1     0   18 13         25   9   31
1031838 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_7 1.0 38.0 9.0   1.0     1.0     2.0   26.0 26.0             39     *   52 1 38 9   1     1     2   26 26         39       52

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