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,045
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
1433197 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS 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
1433216 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE 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
1433235 NY Albany   school 3602460 10100010000   ALBANY 360246006700 10100010051 NORTH ALBANY ACADEMY MIDDLE SCHOOL public Regular School No Middle 06 07 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
1523029 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 21.0 12.0 7.0         4.0     7.0   29.0 22.0     *       15     6   51 21 12 7         4     7   29 22         15   6   51
1523048 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 19.0 34.0 11.0   0.0     1.0     8.0   42.0 31.0     8       40     17   73 19 34 11   0     1     8   42 31     8   40   17   73
1523067 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 6.0 12.0 28.0         3.0     9.0   30.0 28.0     17       *     0   58 6 12 28         3     9   30 28     17       0   58
1523086 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 33.0 15.0 10.0   0.0     12.0     8.0   39.0 39.0     5       *     14   78 33 15 10   0     12     8   39 39     5       14   78
1523105 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2020   kindergarten_full_day 11.0 22.0 14.0   0.0     7.0     6.0   28.0 32.0     5       32     *   60 11 22 14   0     7     6   28 32     5   32       60
1523124 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   kindergarten_full_day 20.0 7.0 5.0   0.0     6.0     4.0   24.0 18.0     6       9     *   42 20 7 5   0     6     4   24 18     6   9       42
1523143 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2020   kindergarten_full_day 16.0 25.0 8.0   0.0     8.0     6.0   30.0 33.0     *       35     8   63 16 25 8   0     8     6   30 33         35   8   63
1523162 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   kindergarten_full_day 4.0 37.0 15.0   1.0     6.0     3.0   28.0 38.0     7       53     20   66 4 37 15   1     6     3   28 38     7   53   20   66
1523181 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 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
1523200 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 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
1523219 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 1.0 33.0 11.0         1.0     4.0   25.0 25.0     0       *     11   50 1 33 11         1     4   25 25     0       11   50
1523238 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2020   kindergarten_full_day 1.0 16.0 10.0         5.0     5.0   15.0 22.0     5       30     *   37 1 16 10         5     5   15 22     5   30       37
1523257 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2020   kindergarten_full_day 5.0 31.0 12.0   0.0     2.0     3.0   23.0 30.0     7       35     8   53 5 31 12   0     2     3   23 30     7   35   8   53
1523276 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 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
1523295 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 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
1523314 NY Albany   school 3602460 10100010000   ALBANY 360246006700 10100010051 NORTH ALBANY ACADEMY MIDDLE SCHOOL public Regular School No Middle 06 08 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
2049387 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 25.0 8.0 7.0   0.0     4.0     6.0   27.0 23.0     6       17     *   50 25 8 7   0     4     6   27 23     6   17       50
2049406 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 15.0 20.0 10.0   0.0     6.0     10.0   29.0 32.0     *       *     9   61 15 20 10   0     6     10   29 32             9   61
2049425 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 6.0 20.0 36.0   0.0     11.0     3.0   40.0 36.0     20       54     8   76 6 20 36   0     11     3   40 36     20   54   8   76
2049444 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 43.0 13.0 14.0   0.0     11.0     9.0   42.0 48.0     6       36     7   90 43 13 14   0     11     9   42 48     6   36   7   90
2049463 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   kindergarten_full_day 0.0 24.0 5.0         3.0     4.0   17.0 19.0     *       *     0   36 0 24 5         3     4   17 19             0   36
2049482 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2018   kindergarten_full_day 7.0 36.0 11.0   0.0     7.0     4.0   25.0 40.0     *       31     6   65 7 36 11   0     7     4   25 40         31   6   65
2049501 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 23.0 9.0 3.0   0.0     6.0     6.0   28.0 19.0     7       13     5   47 23 9 3   0     6     6   28 19     7   13   5   47
2049520 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2018   kindergarten_full_day 5.0 25.0 11.0   0.0     11.0     10.0   32.0 30.0     *       45     10   62 5 25 11   0     11     10   32 30         45   10   62
2049539 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   kindergarten_full_day 10.0 34.0 19.0   0.0     10.0     7.0   39.0 41.0     12       65     19   80 10 34 19   0     10     7   39 41     12   65   19   80
2049558 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049577 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2018   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049596 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 3.0 36.0 10.0   0.0     0.0     4.0   31.0 22.0     *       47     *   53 3 36 10   0     0     4   31 22         47       53
2049615 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2018   kindergarten_full_day 1.0 17.0 7.0   0.0     8.0     7.0   19.0 21.0     7       36     *   40 1 17 7   0     8     7   19 21     7   36       40
2049634 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2018   kindergarten_full_day 7.0 33.0 17.0   0.0     6.0     7.0   39.0 31.0     11       56     15   70 7 33 17   0     6     7   39 31     11   56   15   70
2049653 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049672 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2018   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139105 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   kindergarten_full_day 15.0 11.0 3.0         5.0     10.0   22.0 22.0     *       14     8   44 15 11 3         5     10   22 22         14   8   44
2139124 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   kindergarten_full_day 11.0 28.0 11.0   1.0     3.0     7.0   34.0 27.0     10       43     8   61 11 28 11   1     3     7   34 27     10   43   8   61
2139143 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2019   kindergarten_full_day 13.0 16.0 22.0         8.0     5.0   29.0 35.0     20       46     *   64 13 16 22         8     5   29 35     20   46       64
2139162 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   kindergarten_full_day 33.0 12.0 8.0   0.0     15.0     4.0   43.0 29.0     14       *     14   72 33 12 8   0     15     4   43 29     14       14   72
2139181 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2019   kindergarten_full_day 0.0 26.0 2.0         3.0     0.0   18.0 13.0     *       25     *   31 0 26 2         3     0   18 13         25       31
2139200 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   kindergarten_full_day 11.0 29.0 12.0   0.0     3.0     8.0   30.0 33.0     *       35     7   63 11 29 12   0     3     8   30 33         35   7   63
2139219 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 17.0 5.0 7.0         7.0     2.0   19.0 19.0     7       10     6   38 17 5 7         7     2   19 19     7   10   6   38
2139238 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2019   kindergarten_full_day 8.0 28.0 8.0   1.0     13.0     7.0   38.0 27.0     *       50     9   65 8 28 8   1     13     7   38 27         50   9   65
2139257 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   kindergarten_full_day 6.0 24.0 18.0   0.0     2.0     7.0   32.0 25.0     6       51     8   57 6 24 18   0     2     7   32 25     6   51   8   57
2139276 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 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
2139295 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 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
2139314 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 1.0 23.0 14.0         1.0     5.0   28.0 16.0     *       36     *   44 1 23 14         1     5   28 16         36       44
2139333 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2019   kindergarten_full_day 4.0 20.0 6.0   0.0     5.0     4.0   16.0 23.0     9       36     *   39 4 20 6   0     5     4   16 23     9   36       39
2139352 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   kindergarten_full_day 6.0 23.0 14.0   1.0     2.0     3.0   21.0 28.0     6       47     11   49 6 23 14   1     2     3   21 28     6   47   11   49
2139371 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 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
2139390 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 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
759480 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   kindergarten_full_day 61.0 1.0 2.0   0.0     0.0     4.0   36.0 32.0             27     9   68 61 1 2   0     0     4   36 32         27   9   68
759499 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM 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
759518 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM 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
956240 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   kindergarten_full_day 64.0 0.0 3.0   0.0     0.0     1.0   33.0 35.0     *       26     12   68 64 0 3   0     0     1   33 35         26   12   68
956259 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM 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
956278 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM 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
1046110 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   kindergarten_full_day 62.0 0.0 4.0   1.0     1.0     5.0   47.0 26.0             34     11   73 62 0 4   1     1     5   47 26         34   11   73
1046129 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM 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
1046148 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM 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
1447447 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 51.0 0.0 1.0   0.0     1.0     2.0   26.0 29.0     0       24     6   55 51 0 1   0     1     2   26 29     0   24   6   55
1447466 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM 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
1447485 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM 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
1537469 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   kindergarten_full_day 53.0 1.0 6.0   0.0           2.0   29.0 33.0     *       23     7   62 53 1 6   0           2   29 33         23   7   62
1537488 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 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
1537507 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 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
2063580 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   kindergarten_full_day 75.0 0.0 5.0   0.0     0.0     2.0   41.0 41.0     *       43     14   82 75 0 5   0     0     2   41 41         43   14   82
2063599 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2018   kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063618 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2018   kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2153298 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   kindergarten_full_day 60.0 0.0 2.0   0.0     0.0     3.0   27.0 38.0     *       23     5   65 60 0 2   0     0     3   27 38         23   5   65
2153317 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 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
2153336 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 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
745496 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes 1.0 KG 04 2015   kindergarten_full_day 1.0 47.0 10.0         1.0     1.0   60.0               60     *   60 1 47 10         1     1   60           60       60
942351 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2017   kindergarten_full_day 1.0 35.0 10.0         1.0     1.0   48.0       *       40     *   48 1 35 10         1     1   48           40       48
1032069 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes 1.0 KG 04 2016   kindergarten_full_day 5.0 45.0 0.0         3.0     0.0   53.0               43     0   53 5 45 0         3     0   53           43   0   53
1433254 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2021   kindergarten_full_day 1.0 11.0 6.0         3.0     1.0   22.0       *       17     0   22 1 11 6         3     1   22           17   0   22
1523333 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2020   kindergarten_full_day 3.0 28.0 7.0         1.0     4.0   43.0       *       39     *   43 3 28 7         1     4   43           39       43
2049691 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2018   kindergarten_full_day 2.0 32.0 7.0         0.0     8.0   49.0       *       48     *   49 2 32 7         0     8   49           48       49
2139409 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2019   kindergarten_full_day 2.0 24.0 10.0         4.0     4.0   43.0 1.0     *       41     *   44 2 24 10         4     4   43 1         41       44
745515 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes 1.0 KG 04 2015   kindergarten_full_day 1.0 42.0 13.0         4.0     1.0     61.0             61     0   61 1 42 13         4     1     61         61   0   61
942370 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2017   kindergarten_full_day 1.0 37.0 10.0         1.0     7.0   0.0 56.0     *       49     *   56 1 37 10         1     7   0 56         49       56
1032088 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes 1.0 KG 04 2016   kindergarten_full_day 0.0 37.0 12.0         2.0     11.0   0.0 62.0             46     *   62 0 37 12         2     11   0 62         46       62
1433273 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2021   kindergarten_full_day 1.0 20.0 6.0   0.0     6.0     1.0     34.0     *       25     0   34 1 20 6   0     6     1     34         25   0   34
1523352 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2020   kindergarten_full_day 1.0 43.0 2.0   0.0     10.0     4.0     60.0     8       50     *   60 1 43 2   0     10     4     60     8   50       60
2049710 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2018   kindergarten_full_day 1.0 52.0 5.0         3.0     4.0     65.0     8       62     *   65 1 52 5         3     4     65     8   62       65
2139428 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2019   kindergarten_full_day 4.0 35.0 14.0         4.0     0.0     57.0     6       53     *   57 4 35 14         4     0     57     6   53       57
745534 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes 2.0 05 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
942389 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   kindergarten_full_day 3.0 69.0 12.0   0.0     4.0     3.0   41.0 50.0             0         91 3 69 12   0     4     3   41 50         0       91
1032107 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes 2.0 05 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
1433292 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   kindergarten_full_day 2.0 76.0 9.0   0.0     1.0     4.0   52.0 40.0     0       64     0   92 2 76 9   0     1     4   52 40     0   64   0   92
1523371 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   kindergarten_full_day 2.0 77.0 16.0   1.0     0.0     4.0   46.0 54.0     *       75     5   100 2 77 16   1     0     4   46 54         75   5   100
2049729 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2018   kindergarten_full_day 1.0 73.0 9.0   0.0     3.0     4.0   53.0 37.0             76     *   90 1 73 9   0     3     4   53 37         76       90
2139447 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2019   kindergarten_full_day 0.0 72.0 23.0   0.0     2.0     5.0   72.0 30.0     10       78     *   102 0 72 23   0     2     5   72 30     10   78       102
745553 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2015   kindergarten_full_day 1.0 54.0 18.0   0.0     1.0     7.0   44.0 37.0             77     *   81 1 54 18   0     1     7   44 37         77       81
942408 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   kindergarten_full_day 0.0 47.0 13.0   0.0     0.0         35.0 25.0     *       51         60 0 47 13   0     0         35 25         51       60
1032126 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   kindergarten_full_day 0.0 72.0 10.0   1.0     1.0         45.0 39.0             77     *   84 0 72 10   1     1         45 39         77       84
1433311 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2021   kindergarten_full_day 4.0 39.0 6.0   1.0           5.0   29.0 26.0     *       50     *   55 4 39 6   1           5   29 26         50       55
1523390 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   kindergarten_full_day 2.0 50.0 9.0               7.0   32.0 36.0     0       59     *   68 2 50 9               7   32 36     0   59       68
2049748 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2018   kindergarten_full_day 1.0 48.0 13.0         0.0     4.0   30.0 36.0     *       59         66 1 48 13         0     4   30 36         59       66
2139466 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   kindergarten_full_day 3.0 57.0 14.0               4.0   35.0 43.0     *       65     0   78 3 57 14               4   35 43         65   0   78

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