Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_1 · 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
1433185 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1433204 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2021   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1433223 NY Albany   school 3602460 10100010000   ALBANY 360246006700 10100010051 NORTH ALBANY ACADEMY MIDDLE SCHOOL public Regular School No Middle 06 07 2021   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1523017 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2020   grade_1 22.0 10.0 5.0         5.0     10.0   25.0 27.0     *       18     11   52 22 10 5         5     10   25 27         18   11   52
1523036 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_1 14.0 28.0 12.0   1.0     2.0     7.0   34.0 30.0     8       45     6   64 14 28 12   1     2     7   34 30     8   45   6   64
1523055 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   grade_1 16.0 16.0 20.0         9.0     5.0   32.0 34.0     26       49     *   66 16 16 20         9     5   32 34     26   49       66
1523074 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_1 29.0 18.0 8.0   0.0     12.0     5.0   45.0 27.0     7       27     16   72 29 18 8   0     12     5   45 27     7   27   16   72
1523093 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2020   grade_1 10.0 26.0 10.0   2.0     4.0     11.0   31.0 32.0     *       30     10   63 10 26 10   2     4     11   31 32         30   10   63
1523112 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_1 17.0 5.0 7.0   0.0     7.0     1.0   18.0 19.0     7       15     7   37 17 5 7   0     7     1   18 19     7   15   7   37
1523131 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2020   grade_1 10.0 24.0 2.0   0.0     15.0     6.0   33.0 24.0     9       40     7   57 10 24 2   0     15     6   33 24     9   40   7   57
1523150 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_1 7.0 35.0 10.0   0.0     2.0     8.0   34.0 28.0     *       53     22   62 7 35 10   0     2     8   34 28         53   22   62
1523169 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523188 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523207 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_1 1.0 31.0 11.0         4.0     3.0   33.0 17.0     *       37     5   50 1 31 11         4     3   33 17         37   5   50
1523226 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2020   grade_1 1.0 16.0 12.0         6.0     2.0   19.0 18.0     10       34     0   37 1 16 12         6     2   19 18     10   34   0   37
1523245 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2020   grade_1 3.0 34.0 14.0   1.0     1.0     2.0   24.0 31.0     *       47     14   55 3 34 14   1     1     2   24 31         47   14   55
1523264 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523283 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2020   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523302 NY Albany   school 3602460 10100010000   ALBANY 360246006700 10100010051 NORTH ALBANY ACADEMY MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2049375 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   grade_1 26.0 8.0 5.0   0.0     2.0     7.0   31.0 17.0     *       14     *   48 26 8 5   0     2     7   31 17         14       48
2049394 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 16.0 27.0 12.0   0.0     7.0     4.0   43.0 23.0     13       50     15   66 16 27 12   0     7     4   43 23     13   50   15   66
2049413 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 13.0 11.0 22.0   1.0     7.0     3.0   29.0 28.0     17       43     0   57 13 11 22   1     7     3   29 28     17   43   0   57
2049432 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 36.0 9.0 10.0   1.0     7.0     3.0   29.0 37.0     5       *     7   66 36 9 10   1     7     3   29 37     5       7   66
2049451 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   grade_1 6.0 23.0 7.0         1.0     3.0   25.0 15.0     6       36     0   40 6 23 7         1     3   25 15     6   36   0   40
2049470 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2018   grade_1 15.0 37.0 12.0   0.0     5.0     4.0   37.0 36.0     *       45     10   73 15 37 12   0     5     4   37 36         45   10   73
2049489 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 27.0 10.0 3.0   0.0     6.0     0.0   25.0 21.0     9       18     8   46 27 10 3   0     6     0   25 21     9   18   8   46
2049508 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2018   grade_1 6.0 25.0 5.0   0.0     20.0     6.0   35.0 27.0     9       45     *   62 6 25 5   0     20     6   35 27     9   45       62
2049527 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 7.0 30.0 17.0   0.0     6.0     6.0   41.0 25.0     9       60     9   66 7 30 17   0     6     6   41 25     9   60   9   66
2049546 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049565 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049584 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 1.0 34.0 13.0   1.0     0.0     3.0   26.0 26.0     *       48     *   52 1 34 13   1     0     3   26 26         48       52
2049603 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2018   grade_1 4.0 22.0 9.0   1.0     2.0     6.0   26.0 18.0     7       40     12   44 4 22 9   1     2     6   26 18     7   40   12   44
2049622 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2018   grade_1 4.0 32.0 11.0   0.0     6.0     5.0   32.0 26.0     8       50     *   58 4 32 11   0     6     5   32 26     8   50       58
2049641 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049660 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139093 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_1 26.0 10.0 6.0         4.0     6.0   30.0 22.0     *       20     5   52 26 10 6         4     6   30 22         20   5   52
2139112 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_1 11.0 23.0 10.0   0.0     5.0     7.0   26.0 30.0     *       38     8   56 11 23 10   0     5     7   26 30         38   8   56
2139131 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2019   grade_1 8.0 14.0 38.0         10.0     3.0   39.0 34.0     26       58     10   73 8 14 38         10     3   39 34     26   58   10   73
2139150 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 35.0 13.0 15.0   0.0     11.0     8.0   36.0 46.0     *       36     *   82 35 13 15   0     11     8   36 46         36       82
2139169 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2019   grade_1 3.0 17.0 4.0         2.0     4.0   16.0 14.0     *       27     *   30 3 17 4         2     4   16 14         27       30
2139188 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_1 4.0 42.0 13.0   0.0     7.0     7.0   31.0 42.0     *       49     9   73 4 42 13   0     7     7   31 42         49   9   73
2139207 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 20.0 10.0 5.0         2.0     5.0   23.0 19.0     *       16     *   42 20 10 5         2     5   23 19         16       42
2139226 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2019   grade_1 2.0 20.0 13.0   0.0     11.0     9.0   30.0 25.0     *       41     *   55 2 20 13   0     11     9   30 25         41       55
2139245 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_1 6.0 37.0 21.0   0.0     10.0     6.0   36.0 44.0     8       73     18   80 6 37 21   0     10     6   36 44     8   73   18   80
2139264 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139283 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2019   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139302 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 1.0 26.0 11.0         1.0     2.0   23.0 18.0     *       37     *   41 1 26 11         1     2   23 18         37       41
2139321 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2019   grade_1 2.0 15.0 7.0   0.0     8.0     4.0   15.0 21.0     7       35     0   36 2 15 7   0     8     4   15 21     7   35   0   36
2139340 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   grade_1 4.0 35.0 9.0   0.0     3.0     8.0   32.0 27.0     *       55     17   59 4 35 9   0     3     8   32 27         55   17   59
2139359 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139378 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
759468 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 83.0 1.0 8.0   0.0     0.0     4.0   54.0 42.0             54     19   96 83 1 8   0     0     4   54 42         54   19   96
759487 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
759506 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
956228 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_1 59.0 0.0 5.0   1.0     1.0     4.0   45.0 25.0     *       36     16   70 59 0 5   1     1     4   45 25         36   16   70
956247 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
956266 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1046098 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_1 58.0 1.0 2.0   0.0     0.0     6.0   34.0 33.0             30     12   67 58 1 2   0     0     6   34 33         30   12   67
1046117 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1046136 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447435 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_1 40.0 1.0 7.0   0.0     0.0     2.0   25.0 25.0     *       20     6   50 40 1 7   0     0     2   25 25         20   6   50
1447454 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2021   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447473 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1537457 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_1 59.0 0.0 2.0   0.0           3.0   32.0 32.0     *       24     6   64 59 0 2   0           3   32 32         24   6   64
1537476 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1537495 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2063568 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_1 62.0 1.0 4.0   0.0     0.0     2.0   32.0 37.0     *       28     11   69 62 1 4   0     0     2   32 37         28   11   69
2063587 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063606 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2153286 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_1 73.0 0.0 6.0   0.0     0.0     3.0   41.0 41.0     *       50     14   82 73 0 6   0     0     3   41 41         50   14   82
2153305 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2019   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2153324 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
745484 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   grade_1 1.0 52.0 7.0         0.0     0.0   60.0               60     *   60 1 52 7         0     0   60           60       60
942339 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2017   grade_1 4.0 44.0 7.0         4.0     0.0   59.0       *       54     0   59 4 44 7         4     0   59           54   0   59
1032057 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   grade_1 2.0 47.0 10.0         0.0     1.0   60.0               47     *   60 2 47 10         0     1   60           47       60
1433242 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2021   grade_1 2.0 28.0 5.0         2.0     3.0   40.0       *       35     *   40 2 28 5         2     3   40           35       40
1523321 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2020   grade_1 2.0 32.0 10.0         5.0     3.0   52.0       6       51     6   52 2 32 10         5     3   52       6   51   6   52
2049679 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2018   grade_1 0.0 42.0 15.0         2.0     3.0   62.0       *       57     *   62 0 42 15         2     3   62           57       62
2139397 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2019   grade_1 6.0 36.0 7.0         3.0     7.0   59.0 0.0     7       56     7   59 6 36 7         3     7   59 0     7   56   7   59
745503 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   grade_1 3.0 44.0 11.0         1.0     0.0     59.0             59     0   59 3 44 11         1     0     59         59   0   59
942358 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2017   grade_1 1.0 42.0 12.0         1.0     7.0   0.0 63.0     *       56     0   63 1 42 12         1     7   0 63         56   0   63
1032076 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   grade_1 0.0 42.0 13.0         4.0     3.0   1.0 61.0             48     *   62 0 42 13         4     3   1 61         48       62
1433261 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2021   grade_1 2.0 32.0 3.0   0.0     9.0     4.0     50.0     9       42     *   50 2 32 3   0     9     4     50     9   42       50
1523340 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2020   grade_1 2.0 39.0 16.0   0.0     5.0     0.0     62.0     5       57     *   62 2 39 16   0     5     0     62     5   57       62
2049698 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2018   grade_1 1.0 36.0 11.0         2.0     6.0     56.0     *       49     *   56 1 36 11         2     6     56         49       56
2139416 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2019   grade_1 1.0 48.0 5.0         3.0     6.0     63.0     8       58     0   63 1 48 5         3     6     63     8   58   0   63
745522 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   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942377 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   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
1032095 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   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1433280 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   grade_1 1.0 84.0 17.0   1.0     0.0     5.0   53.0 55.0     0       84     5   108 1 84 17   1     0     5   53 55     0   84   5   108
1523359 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   grade_1 0.0 78.0 20.0   0.0     2.0     4.0   55.0 49.0     9       80     *   104 0 78 20   0     2     4   55 49     9   80       104
2049717 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   grade_1 5.0 77.0 9.0   0.0     4.0     4.0   40.0 59.0             86     *   99 5 77 9   0     4     4   40 59         86       99
2139435 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   grade_1 2.0 78.0 10.0   0.0     1.0     7.0   76.0 22.0     *       71     5   98 2 78 10   0     1     7   76 22         71   5   98
745541 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2015   grade_1 1.0 56.0 18.0   0.0     0.0     4.0   36.0 43.0             75     *   79 1 56 18   0     0     4   36 43         75       79
942396 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_1 0.0 72.0 9.0   1.0     0.0         44.0 38.0     *       76         82 0 72 9   1     0         44 38         76       82
1032114 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_1 1.0 72.0 6.0   0.0     0.0         43.0 36.0             71     *   79 1 72 6   0     0         43 36         71       79
1433299 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2021   grade_1 3.0 65.0 9.0   0.0           6.0   33.0 50.0     0       69     *   83 3 65 9   0           6   33 50     0   69       83
1523378 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_1 3.0 67.0 14.0               4.0   39.0 49.0     *       80     *   88 3 67 14               4   39 49         80       88
2049736 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2018   grade_1 1.0 54.0 17.0         0.0     4.0   41.0 35.0     *       68         76 1 54 17         0     4   41 35         68       76
2139454 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_1 3.0 49.0 13.0               8.0   33.0 40.0     *       59     *   73 3 49 13               8   33 40         59       73

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