Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_5" and state = "NY" sorted by school_state_id

View and edit SQL

year

grade

  • grade_5 · 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
745206 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   grade_5 22.0 11.0 4.0   0.0     6.0     2.0   16.0 29.0             11     *   45 22 11 4   0     6     2   16 29         11       45
942042 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2017   grade_5 22.0 10.0 10.0   0.0     2.0     2.0   14.0 32.0     *       8     *   46 22 10 10   0     2     2   14 32         8       46
1031760 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_5 25.0 12.0 1.0   0.0     5.0     1.0   14.0 30.0             12     *   44 25 12 1   0     5     1   14 30         12       44
1432945 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2021   grade_5 20.0 11.0 5.0         5.0     1.0   16.0 26.0     *       18     *   42 20 11 5         5     1   16 26         18       42
1523024 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2020   grade_5 23.0 9.0 5.0         5.0     3.0   27.0 18.0     0       12     *   45 23 9 5         5     3   27 18     0   12       45
2049382 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   grade_5 28.0 7.0 5.0   1.0     3.0     2.0   25.0 21.0     *       15     *   46 28 7 5   1     3     2   25 21         15       46
2139100 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_5 28.0 5.0 6.0         1.0     3.0   23.0 20.0     *       20     *   43 28 5 6         1     3   23 20         20       43
745225 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_5 8.0 24.0 7.0         1.0     4.0   26.0 18.0             31     8   44 8 24 7         1     4   26 18         31   8   44
942061 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_5 6.0 22.0 9.0   0.0     5.0     6.0   24.0 24.0     7       30     *   48 6 22 9   0     5     6   24 24     7   30       48
1031779 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 8.0 22.0 8.0   0.0     3.0     8.0   27.0 22.0             31     10   49 8 22 8   0     3     8   27 22         31   10   49
1432964 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_5 9.0 26.0 10.0         3.0     7.0   30.0 25.0     *       42     *   55 9 26 10         3     7   30 25         42       55
1523043 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_5 9.0 21.0 17.0   0.0     6.0     4.0   30.0 27.0     9       39     *   57 9 21 17   0     6     4   30 27     9   39       57
2049401 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_5 15.0 26.0 11.0   1.0     5.0     9.0   22.0 45.0     7       47     *   67 15 26 11   1     5     9   22 45     7   47       67
2139119 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_5 11.0 22.0 16.0   0.0     2.0     8.0   32.0 27.0     *       45     6   59 11 22 16   0     2     8   32 27         45   6   59
745244 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2015   grade_5 12.0 19.0 16.0   0.0     6.0     2.0   25.0 30.0             45     *   55 12 19 16   0     6     2   25 30         45       55
942080 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2017   grade_5 12.0 19.0 25.0   0.0     12.0     4.0   36.0 36.0     16       45     *   72 12 19 25   0     12     4   36 36     16   45       72
1031798 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_5 9.0 37.0 17.0   1.0     8.0     3.0   37.0 38.0             54     5   75 9 37 17   1     8     3   37 38         54   5   75
1432983 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2021   grade_5 9.0 21.0 33.0   0.0     6.0     4.0   42.0 31.0     12       52     *   73 9 21 33   0     6     4   42 31     12   52       73
1523062 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   grade_5 7.0 17.0 33.0         7.0     3.0   42.0 25.0     17       48     8   67 7 17 33         7     3   42 25     17   48   8   67
2049420 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   grade_5 8.0 22.0 28.0   0.0     8.0     1.0   35.0 32.0     19       54     10   67 8 22 28   0     8     1   35 32     19   54   10   67
2139138 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2019   grade_5 7.0 20.0 27.0         13.0     4.0   31.0 40.0     14       57     *   71 7 20 27         13     4   31 40     14   57       71
745263 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_5 41.0 21.0 7.0   0.0     10.0     7.0   47.0 39.0             23     10   86 41 21 7   0     10     7   47 39         23   10   86
942099 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_5 31.0 19.0 8.0   0.0     3.0     4.0   41.0 24.0     *       23     8   65 31 19 8   0     3     4   41 24         23   8   65
1031817 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_5 42.0 21.0 5.0   0.0     4.0     6.0   38.0 40.0             18     *   78 42 21 5   0     4     6   38 40         18       78
1433002 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_5 29.0 17.0 13.0   0.0     2.0     7.0   38.0 30.0     *       35     16   68 29 17 13   0     2     7   38 30         35   16   68
1523081 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_5 38.0 36.0 12.0   0.0     4.0     5.0   59.0 36.0     5       49     35   95 38 36 12   0     4     5   59 36     5   49   35   95
2049439 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_5 33.0 16.0 18.0   1.0     13.0     8.0   50.0 39.0     8       40     13   89 33 16 18   1     13     8   50 39     8   40   13   89
2139157 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_5 44.0 19.0 9.0   1.0     9.0     5.0   46.0 41.0     6       34     14   87 44 19 9   1     9     5   46 41     6   34   14   87
745282 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2015   grade_5 1.0 11.0 7.0   0.0     0.0     0.0   9.0 10.0             15     0   19 1 11 7   0     0     0   9 10         15   0   19
942118 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 08 2017   grade_5 5.0 31.0 4.0         2.0     1.0   20.0 23.0     5       34     *   43 5 31 4         2     1   20 23     5   34       43
1031836 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_5 3.0 14.0 8.0   0.0     1.0     3.0   19.0 10.0             21     *   29 3 14 8   0     1     3   19 10         21       29
2049458 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   grade_5 8.0 23.0 5.0         2.0     2.0   17.0 23.0     9       35     *   40 8 23 5         2     2   17 23     9   35       40
2139176 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2019   grade_5 3.0 33.0 7.0         4.0     6.0   35.0 18.0     9       48     25   53 3 33 7         4     6   35 18     9   48   25   53
745301 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No 1.0 PK 06 2015   grade_5 7.0 36.0 5.0   0.0     7.0     1.0   23.0 33.0             26     7   56 7 36 5   0     7     1   23 33         26   7   56
942137 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary KG 06 2017   grade_5 14.0 34.0 12.0   0.0     6.0     4.0   34.0 36.0     *       28     *   70 14 34 12   0     6     4   34 36         28       70
1031855 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No 1.0 PK 06 2016   grade_5 16.0 47.0 10.0   0.0     6.0     1.0   36.0 44.0             37     12   80 16 47 10   0     6     1   36 44         37   12   80
1433021 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2021   grade_5 8.0 27.0 11.0   0.0     3.0     12.0   36.0 25.0     *       36     9   61 8 27 11   0     3     12   36 25         36   9   61
1523100 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2020   grade_5 11.0 32.0 22.0   0.0     3.0     5.0   33.0 40.0     *       46     12   73 11 32 22   0     3     5   33 40         46   12   73
2049477 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2018   grade_5 9.0 45.0 15.0   0.0     5.0     6.0   34.0 46.0     5       51     17   80 9 45 15   0     5     6   34 46     5   51   17   80
2139195 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_5 8.0 29.0 12.0   0.0     9.0     2.0   34.0 26.0     *       35     *   60 8 29 12   0     9     2   34 26         35       60
745320 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_5 10.0 19.0 3.0   0.0     5.0     0.0   23.0 14.0             19     *   37 10 19 3   0     5     0   23 14         19       37
942156 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_5 21.0 7.0 5.0   0.0     3.0     5.0   19.0 22.0     *       20     *   41 21 7 5   0     3     5   19 22         20       41
1031874 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 18.0 22.0 7.0   1.0     2.0     4.0   30.0 24.0             39     16   54 18 22 7   1     2     4   30 24         39   16   54
1433040 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_5 22.0 14.0 4.0   1.0     2.0     2.0   25.0 20.0     *       23     14   45 22 14 4   1     2     2   25 20         23   14   45
1523119 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_5 11.0 25.0 9.0   0.0     4.0     3.0   34.0 18.0     *       29     14   52 11 25 9   0     4     3   34 18         29   14   52
2049496 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_5 25.0 15.0 8.0   1.0     4.0     3.0   34.0 22.0     *       34     12   56 25 15 8   1     4     3   34 22         34   12   56
2139214 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_5 20.0 14.0 5.0         3.0     2.0   19.0 25.0     *       26     6   44 20 14 5         3     2   19 25         26   6   44
745339 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   grade_5 12.0 39.0 7.0   0.0     10.0     2.0   34.0 36.0             50     10   70 12 39 7   0     10     2   34 36         50   10   70
942175 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2017   grade_5 6.0 40.0 17.0   0.0     16.0     4.0   53.0 30.0     7       61     18   83 6 40 17   0     16     4   53 30     7   61   18   83
1031893 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   grade_5 3.0 38.0 11.0   0.0     10.0     1.0   39.0 24.0             42     *   63 3 38 11   0     10     1   39 24         42       63
1433059 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2021   grade_5 8.0 21.0 10.0   1.0     25.0     1.0   38.0 28.0     12       48     10   66 8 21 10   1     25     1   38 28     12   48   10   66
1523138 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_5 7.0 29.0 13.0   0.0     10.0     7.0   35.0 31.0     11       40     10   66 7 29 13   0     10     7   35 31     11   40   10   66
2049515 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_5 5.0 24.0 11.0   1.0     16.0     7.0   31.0 33.0     10       49     0   64 5 24 11   1     16     7   31 33     10   49   0   64
2139233 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_5 8.0 25.0 7.0   0.0     14.0     3.0   31.0 26.0     9       41     *   57 8 25 7   0     14     3   31 26     9   41       57
745358 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_5 6.0 34.0 14.0   1.0     8.0     0.0   35.0 28.0             54     6   63 6 34 14   1     8     0   35 28         54   6   63
942194 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_5 7.0 34.0 9.0   0.0     5.0     4.0   26.0 33.0     9       51     9   59 7 34 9   0     5     4   26 33     9   51   9   59
1031912 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 4.0 40.0 18.0   0.0     7.0     2.0   34.0 37.0             61     8   71 4 40 18   0     7     2   34 37         61   8   71
1433078 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_5 4.0 44.0 22.0   1.0     8.0     3.0   48.0 34.0     7       74     15   82 4 44 22   1     8     3   48 34     7   74   15   82
1523157 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_5 4.0 48.0 21.0   0.0     3.0     6.0   48.0 34.0     5       65     14   82 4 48 21   0     3     6   48 34     5   65   14   82
2049534 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_5 4.0 34.0 18.0   1.0     8.0     3.0   39.0 29.0     14       63     17   68 4 34 18   1     8     3   39 29     14   63   17   68
2139252 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_5 7.0 50.0 20.0   0.0     6.0     3.0   43.0 43.0     15       84     24   86 7 50 20   0     6     3   43 43     15   84   24   86
745377 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
942213 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1031931 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1433097 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523176 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049553 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139271 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
745396 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
942232 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2017   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1031950 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1433116 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2021   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1523195 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2020   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2049572 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2018   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2139290 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2019   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
745415 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_5 1.0 29.0 8.0   0.0     1.0     0.0   16.0 23.0             38     *   39 1 29 8   0     1     0   16 23         38       39
942251 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_5 0.0 41.0 5.0   0.0     0.0     3.0   23.0 26.0     *       44     *   49 0 41 5   0     0     3   23 26         44       49
1031969 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 4.0 41.0 9.0   0.0     0.0     1.0   27.0 28.0             48     *   55 4 41 9   0     0     1   27 28         48       55
1433135 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_5 3.0 38.0 7.0         3.0     4.0   31.0 24.0     7       49     10   55 3 38 7         3     4   31 24     7   49   10   55
1523214 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_5 4.0 38.0 8.0         0.0     5.0   27.0 28.0     *       50     17   55 4 38 8         0     5   27 28         50   17   55
2049591 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_5 2.0 33.0 12.0   0.0     0.0     4.0   31.0 20.0     *       46     13   51 2 33 12   0     0     4   31 20         46   13   51
2139309 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_5 1.0 31.0 11.0         1.0     2.0   33.0 13.0     *       44     13   46 1 31 11         1     2   33 13         44   13   46
745434 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No 1.0 PK 05 2015   grade_5 5.0 17.0 8.0         2.0     2.0   17.0 17.0             29     6   34 5 17 8         2     2   17 17         29   6   34
942270 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2017   grade_5 5.0 26.0 8.0   0.0     3.0     5.0   21.0 26.0     7       40     8   47 5 26 8   0     3     5   21 26     7   40   8   47
1031988 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No 1.0 PK 05 2016   grade_5 2.0 28.0 6.0   1.0     4.0     1.0   16.0 26.0             27     8   42 2 28 6   1     4     1   16 26         27   8   42
1433154 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2021   grade_5 5.0 30.0 9.0         6.0     5.0   29.0 26.0     11       48     11   55 5 30 9         6     5   29 26     11   48   11   55
1523233 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2020   grade_5 6.0 26.0 5.0         6.0     5.0   20.0 28.0     14       44     *   48 6 26 5         6     5   20 28     14   44       48
2049610 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2018   grade_5 4.0 26.0 6.0   0.0     1.0     6.0   22.0 21.0     6       36     *   43 4 26 6   0     1     6   22 21     6   36       43
2139328 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2019   grade_5 4.0 21.0 11.0   1.0     1.0     8.0   26.0 20.0     6       43     11   46 4 21 11   1     1     8   26 20     6   43   11   46
745453 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No 1.0 PK 05 2015   grade_5 1.0 22.0 8.0         0.0     1.0   18.0 14.0             31     *   32 1 22 8         0     1   18 14         31       32
942289 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2017   grade_5 9.0 32.0 7.0   0.0     2.0     1.0   24.0 27.0     8       *     0   51 9 32 7   0     2     1   24 27     8       0   51
1032007 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No 1.0 PK 05 2016   grade_5 3.0 53.0 8.0   0.0     5.0     5.0   33.0 41.0             61     *   74 3 53 8   0     5     5   33 41         61       74
1433173 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2021   grade_5 1.0 41.0 9.0   1.0     5.0     3.0   26.0 34.0     *       56     7   60 1 41 9   1     5     3   26 34         56   7   60
1523252 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2020   grade_5 2.0 31.0 8.0   0.0     3.0     5.0   23.0 26.0     *       37     *   49 2 31 8   0     3     5   23 26         37       49
2049629 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2018   grade_5 4.0 30.0 11.0   1.0     4.0     5.0   22.0 33.0     8       48     8   55 4 30 11   1     4     5   22 33     8   48   8   55
2139347 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   grade_5 6.0 30.0 10.0   0.0     2.0     3.0   23.0 28.0     5       47     *   51 6 30 10   0     2     3   23 28     5   47       51
745472 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
942308 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1032026 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1433192 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);