Data source: Big Local News · About: Big Local

33,145 rows where grade = "kindergarten_full_day" and state = "NY" sorted by district_state_id

View and edit SQL

year

grade

  • kindergarten_full_day · 33,145
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
759366 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No 3.0 07 12 2015   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
759385 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956126 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2017   kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956145 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2017   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
1045996 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education 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
1046015 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education 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
1537355 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1537374 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2020   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
2063466 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2018   kindergarten_full_day 0.0 0.0 0.0                   0.0               0     0   0 0 0 0                   0           0   0   0
2063485 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Special Education School No High 07 12 2018   kindergarten_full_day 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
2153184 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153203 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
759404 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No 3.0 07 12 2015   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
759423 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 83.0 1.0 8.0   0.0     0.0     6.0   50.0 48.0             64     5   98 83 1 8   0     0     6   50 48         64   5   98
956164 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2017   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
956183 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   kindergarten_full_day 83.0 1.0 7.0   0.0     1.0     10.0   49.0 53.0     *       72     *   102 83 1 7   0     1     10   49 53         72       102
1046034 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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
1046053 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 65.0 2.0 7.0   0.0     1.0     6.0   51.0 30.0             58     *   81 65 2 7   0     1     6   51 30         58       81
1447371 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH 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   0   0   0
1447390 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_full_day 68.0 2.0 5.0         0.0     3.0   42.0 36.0     *       33     5   78 68 2 5         0     3   42 36         33   5   78
1537393 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   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
1537412 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   kindergarten_full_day 61.0 4.0 6.0   0.0     0.0     10.0   34.0 47.0     *       14     *   81 61 4 6   0     0     10   34 47         14       81
2063504 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2018   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2063523 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 59.0 3.0 11.0   0.0     0.0     8.0   44.0 37.0     *       48     6   81 59 3 11   0     0     8   44 37         48   6   81
2153222 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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
2153241 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 51.0 1.0 7.0   0.0     0.0     4.0   34.0 29.0     *       40     *   63 51 1 7   0     0     4   34 29         40       63
759442 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 31.0 0.0 3.0         1.0     1.0   19.0 17.0             10     *   36 31 0 3         1     1   19 17         10       36
759461 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   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
956202 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   kindergarten_full_day 35.0 0.0 3.0         0.0     4.0   20.0 22.0     0       22     9   42 35 0 3         0     4   20 22     0   22   9   42
956221 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   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
1046072 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 31.0 0.0 5.0         0.0     0.0   20.0 16.0             18     *   36 31 0 5         0     0   20 16         18       36
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
1447409 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_full_day 29.0 0.0 2.0         1.0     3.0   16.0 19.0     0       11     *   35 29 0 2         1     3   16 19     0   11       35
1447428 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN 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
1537431 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   kindergarten_full_day 21.0 1.0 0.0         1.0     0.0   9.0 14.0     *       12     *   23 21 1 0         1     0   9 14         12       23
1537450 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   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
2063542 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 27.0 0.0 6.0         0.0     2.0   18.0 17.0     *       16     *   35 27 0 6         0     2   18 17         16       35
2063561 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   kindergarten_full_day 0.0   0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0   0   0     0     0   0 0         0   0   0
2153260 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 33.0   4.0         0.0     1.0   19.0 19.0     0       15     *   38 33   4         0     1   19 19     0   15       38
2153279 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   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
745211 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   kindergarten_full_day 29.0 7.0 4.0   0.0     2.0     2.0   26.0 18.0             6     7   44 29 7 4   0     2     2   26 18         6   7   44
745230 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   kindergarten_full_day 17.0 23.0 20.0         5.0     5.0   36.0 34.0             43     6   70 17 23 20         5     5   36 34         43   6   70
745249 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2015   kindergarten_full_day 10.0 14.0 34.0   0.0     9.0     5.0   39.0 33.0             51     9   72 10 14 34   0     9     5   39 33         51   9   72
745268 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   kindergarten_full_day 50.0 21.0 9.0   0.0     2.0     8.0   51.0 39.0             32     18   90 50 21 9   0     2     8   51 39         32   18   90
745287 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2015   kindergarten_full_day 6.0 34.0 7.0   0.0     0.0     3.0   26.0 24.0             36     *   50 6 34 7   0     0     3   26 24         36       50
745306 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No 1.0 PK 06 2015   kindergarten_full_day 14.0 30.0 14.0   1.0     2.0     3.0   32.0 32.0             27     8   64 14 30 14   1     2     3   32 32         27   8   64
745325 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 28.0 6.0 6.0   0.0     5.0     2.0   27.0 20.0             14     *   47 28 6 6   0     5     2   27 20         14       47
745344 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No 1.0 PK 06 2015   kindergarten_full_day 9.0 32.0 10.0   0.0     15.0     6.0   40.0 32.0             43     0   72 9 32 10   0     15     6   40 32         43   0   72
745363 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 4.0 41.0 16.0   0.0     6.0     6.0   48.0 25.0             57     5   73 4 41 16   0     6     6   48 25         57   5   73
745382 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   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
745401 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No 3.0 09 12 2015   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
745420 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   kindergarten_full_day 4.0 51.0 13.0   0.0     2.0     6.0   37.0 39.0             62     13   76 4 51 13   0     2     6   37 39         62   13   76
745439 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No 1.0 PK 05 2015   kindergarten_full_day 3.0 21.0 5.0         2.0     2.0   18.0 15.0             24     7   33 3 21 5         2     2   18 15         24   7   33
745458 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No 1.0 PK 05 2015   kindergarten_full_day 4.0 55.0 18.0         2.0     4.0   54.0 29.0             71     11   83 4 55 18         2     4   54 29         71   11   83
745477 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   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
942047 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2017   kindergarten_full_day 27.0 7.0 4.0   0.0     3.0     5.0   28.0 18.0     *       9     0   46 27 7 4   0     3     5   28 18         9   0   46
942066 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   kindergarten_full_day 20.0 20.0 15.0   0.0     7.0     4.0   38.0 28.0     8       32     9   66 20 20 15   0     7     4   38 28     8   32   9   66
942085 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2017   kindergarten_full_day 15.0 15.0 26.0   0.0     7.0     2.0   35.0 30.0     16       31     *   65 15 15 26   0     7     2   35 30     16   31       65
942104 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   kindergarten_full_day 38.0 9.0 7.0   1.0     7.0     5.0   26.0 41.0     5       *     8   67 38 9 7   1     7     5   26 41     5       8   67
942123 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 08 2017   kindergarten_full_day 1.0 22.0 9.0         1.0     4.0   22.0 15.0     *       18     0   37 1 22 9         1     4   22 15         18   0   37
942142 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary KG 06 2017   kindergarten_full_day 14.0 41.0 10.0   1.0     5.0     4.0   31.0 44.0     *       28     11   75 14 41 10   1     5     4   31 44         28   11   75
942161 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   kindergarten_full_day 29.0 10.0 1.0   0.0     7.0     0.0   24.0 23.0     9       11     8   47 29 10 1   0     7     0   24 23     9   11   8   47
942180 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2017   kindergarten_full_day 8.0 27.0 2.0   0.0     18.0     7.0   33.0 29.0     7       35     *   62 8 27 2   0     18     7   33 29     7   35       62
942199 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   kindergarten_full_day 4.0 40.0 15.0   0.0     5.0     7.0   46.0 25.0     7       46     15   71 4 40 15   0     5     7   46 25     7   46   15   71
942218 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
942237 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2017   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
942256 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   kindergarten_full_day 2.0 37.0 12.0   0.0     0.0     4.0   30.0 25.0     *       40     9   55 2 37 12   0     0     4   30 25         40   9   55
942275 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2017   kindergarten_full_day 3.0 22.0 9.0   1.0     3.0     7.0   27.0 18.0     7       33     18   45 3 22 9   1     3     7   27 18     7   33   18   45
942294 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2017   kindergarten_full_day 4.0 33.0 12.0   0.0     5.0     6.0   33.0 27.0     7       42     *   60 4 33 12   0     5     6   33 27     7   42       60
942313 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
942332 NY Albany   school 3602460 10100010000   ALBANY 360246006538 10100010046 WEST HILL MIDDLE SCHOOL public Regular School No Middle 07 08 2017   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
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
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
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
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
1031841 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   kindergarten_full_day 0.0 27.0 6.0   0.0     0.0     4.0   16.0 21.0             24     *   37 0 27 6   0     0     4   16 21         24       37
1031860 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No 1.0 PK 06 2016   kindergarten_full_day 17.0 25.0 6.0   0.0     8.0     7.0   36.0 27.0             31     *   63 17 25 6   0     8     7   36 27         31       63
1031879 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 30.0 9.0 3.0   0.0     7.0     2.0   30.0 21.0             18     7   51 30 9 3   0     7     2   30 21         18   7   51
1031898 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No 1.0 PK 06 2016   kindergarten_full_day 12.0 15.0 15.0   1.0     24.0     3.0   38.0 32.0             42     *   70 12 15 15   1     24     3   38 32         42       70
1031917 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 8.0 37.0 16.0   0.0     8.0     7.0   47.0 29.0             60     11   76 8 37 16   0     8     7   47 29         60   11   76
1031936 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No 2.0 06 08 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
1031955 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY 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         0   0   0
1031974 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 1.0 44.0 14.0   0.0     0.0     4.0   34.0 29.0             46     *   63 1 44 14   0     0     4   34 29         46       63
1031993 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No 1.0 PK 05 2016   kindergarten_full_day 4.0 23.0 9.0   0.0     2.0     3.0   26.0 15.0             25     17   41 4 23 9   0     2     3   26 15         25   17   41
1032012 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No 1.0 PK 05 2016   kindergarten_full_day 5.0 44.0 11.0   0.0     3.0     11.0   38.0 36.0             50     *   74 5 44 11   0     3     11   38 36         50       74
1032031 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No 2.0 06 08 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
1032050 NY Albany   school 3602460 10100010000   ALBANY 360246006538 10100010046 WEST HILL MIDDLE SCHOOL public Regular School No 2.0 06 08 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
1432950 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 24.0 10.0 6.0         6.0     4.0   29.0 21.0     0       16     *   50 24 10 6         6     4   29 21     0   16       50
1432969 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 8.0 29.0 12.0         5.0     5.0   33.0 26.0     5       34     12   59 8 29 12         5     5   33 26     5   34   12   59
1432988 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 10.0 10.0 25.0   0.0     4.0     4.0   27.0 26.0     15       33     0   53 10 10 25   0     4     4   27 26     15   33   0   53
1433007 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 26.0 20.0 7.0   0.0     10.0     6.0   41.0 28.0     *       *     *   69 26 20 7   0     10     6   41 28                 69
1433026 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2021   kindergarten_full_day 12.0 21.0 8.0   0.0     4.0     11.0   28.0 28.0     *       21     9   56 12 21 8   0     4     11   28 28         21   9   56
1433045 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_full_day 16.0 11.0 5.0   0.0     4.0     2.0   16.0 22.0     5       19     6   38 16 11 5   0     4     2   16 22     5   19   6   38
1433064 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2021   kindergarten_full_day 3.0 11.0 7.0   0.0     10.0     3.0   21.0 13.0     *       27     8   34 3 11 7   0     10     3   21 13         27   8   34
1433083 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   kindergarten_full_day 4.0 39.0 9.0   0.0     5.0     5.0   38.0 24.0     *       44     12   62 4 39 9   0     5     5   38 24         44   12   62
1433102 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT 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 0     0   0   0   0
1433121 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY 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 0     0   0   0   0
1433140 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 2.0 24.0 8.0         3.0     2.0   19.0 20.0     *       *     *   39 2 24 8         3     2   19 20                 39
1433159 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2021   kindergarten_full_day 5.0 15.0 6.0         9.0     3.0   21.0 17.0     10       34     0   38 5 15 6         9     3   21 17     10   34   0   38
1433178 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2021   kindergarten_full_day 3.0 17.0 10.0   0.0     3.0     4.0   20.0 17.0     8       29     *   37 3 17 10   0     3     4   20 17     8   29       37

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