Data source: Big Local News · About: Big Local

90,098 rows where state = "NY" and year = 2020 sorted by disability_int

View and edit SQL

year

  • 2020 · 90,098
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
1523022 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2020   grade_3 26.0 8.0 6.0         1.0     7.0   32.0 16.0     *       13     *   48 26 8 6         1     7   32 16         13       48
1523023 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2020   grade_4 25.0 13.0 4.0         5.0     1.0   22.0 26.0     *       17     *   48 25 13 4         5     1   22 26         17       48
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
1523032 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 19.0 6.0 5.0         2.0     4.0   19.0 17.0     0       5     *   36 19 6 5         2     4   19 17     0   5       36
1523042 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_4 10.0 28.0 10.0   0.0     4.0     7.0   31.0 28.0     *       49     *   59 10 28 10   0     4     7   31 28         49       59
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
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
1523060 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   grade_3 13.0 10.0 27.0         4.0     6.0   33.0 27.0     16       46     *   60 13 10 27         4     6   33 27     16   46       60
1523061 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   grade_4 7.0 19.0 33.0         5.0     4.0   36.0 32.0     11       43     *   68 7 19 33         5     4   36 32     11   43       68
1523070 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 4.0 2.0 13.0         0.0     1.0   7.0 13.0     0       *     *   20 4 2 13         0     1   7 13     0           20
1523079 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_3 35.0 16.0 9.0   1.0     6.0     4.0   33.0 38.0     10       30     *   71 35 16 9   1     6     4   33 38     10   30       71
1523091 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 2.0 0.0   0.0     0.0     0.0   1.0 1.0     0       *     *   2 0 2 0   0     0     0   1 1     0           2
1523101 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2020   grade_6 6.0 29.0 12.0   0.0     7.0     3.0   30.0 27.0     *       29     *   57 6 29 12   0     7     3   30 27         29       57
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
1523120 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_6 22.0 15.0 7.0   0.0     3.0     0.0   20.0 27.0     *       25     *   47 22 15 7   0     3     0   20 27         25       47
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
1523135 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_2 1.0 23.0 9.0   0.0     13.0     8.0   32.0 22.0     6       32     *   54 1 23 9   0     13     8   32 22     6   32       54
1523136 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_3 9.0 29.0 7.0   0.0     19.0     3.0   35.0 32.0     11       44     *   67 9 29 7   0     19     3   35 32     11   44       67
1523139 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_6 9.0 33.0 8.0   0.0     13.0     5.0   30.0 38.0     *       47     *   68 9 33 8   0     13     5   30 38         47       68
1523211 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 1.0 31.0 9.0         1.0     1.0   22.0 21.0     *       38     *   43 1 31 9         1     1   22 21         38       43
1523224 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 0.0 2.0 1.0         1.0     0.0   4.0 0.0     0       *     *   4 0 2 1         1     0   4 0     0           4
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
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
1523250 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2020   grade_3 4.0 30.0 11.0   0.0     7.0     2.0   25.0 29.0     8       45     *   54 4 30 11   0     7     2   25 29     8   45       54
1523251 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2020   grade_4 3.0 35.0 10.0   1.0     4.0     5.0   27.0 31.0     *       50     *   58 3 35 10   1     4     5   27 31         50       58
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
1523291 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2020   grade_6 3.0 57.0 15.0   0.0     3.0     4.0   45.0 37.0     *       65     *   82 3 57 15   0     3     4   45 37         65       82
1523293 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2020   grade_8 17.0 112.0 24.0   0.0     5.0     9.0   74.0 93.0     19       145     *   167 17 112 24   0     5     9   74 93     19   145       167
1523325 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_2 5.0 29.0 8.0         3.0     7.0   52.0       7       50     *   52 5 29 8         3     7   52       7   50       52
1523327 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_4 4.0 31.0 9.0         5.0     4.0   53.0       *       52     *   53 4 31 9         5     4   53           52       53
1523328 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_5 1.0 34.0 8.0         0.0     1.0   44.0       *       42     *   44 1 34 8         0     1   44           42       44
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
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
1523345 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_3 1.0 35.0 9.0   0.0     5.0     1.0     51.0     7       43     *   51 1 35 9   0     5     1     51     7   43       51
1523346 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_4 1.0 37.0 11.0   0.0     0.0     4.0     53.0     *       43     *   53 1 37 11   0     0     4     53         43       53
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
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
1523364 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_3 1.0 83.0 9.0   0.0     2.0     5.0   43.0 57.0     *       77     *   100 1 83 9   0     2     5   43 57         77       100
1523366 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_5 0.0 86.0 7.0   0.0     0.0     0.0   44.0 49.0     0       77     *   93 0 86 7   0     0     0   44 49     0   77       93
1523368 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_7 1.0 74.0 7.0   1.0     0.0     0.0   41.0 42.0     0       59     *   83 1 74 7   1     0     0   41 42     0   59       83
1523369 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_8 2.0 49.0 7.0   0.0     0.0     2.0   19.0 41.0     0       39     *   60 2 49 7   0     0     2   19 41     0   39       60
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
1523379 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_10 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523380 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_11 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523381 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_12 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523382 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_2 1.0 57.0 16.0               6.0   39.0 41.0     *       72     *   80 1 57 16               6   39 41         72       80
1523383 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_3 0.0 48.0 13.0               4.0   32.0 33.0     *       59     *   65 0 48 13               4   32 33         59       65
1523384 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_4 2.0 47.0 11.0               2.0   31.0 31.0     *       51     *   62 2 47 11               2   31 31         51       62
1523385 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 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
1523386 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_6 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523387 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_7 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523388 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_8 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523389 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   grade_9 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
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
1523391 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   kindergarten_half_day 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523392 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   pk_12_total 8.0 269.0 63.0               23.0   173.0 190.0     11       321     *   363 8 269 63               23   173 190     11   321       363
1523393 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   pre_kindergarten_full_day 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523394 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   pre_kindergarten_half_day 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523395 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   ungraded_elementary 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523396 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   ungraded_secondary 0.0 0.0 0.0               0.0   0.0 0.0     0       0     *   0 0 0 0               0   0 0     0   0       0
1523401 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_2 0.0 67.0 7.0         0.0     2.0   27.0 49.0     *       71     *   76 0 67 7         0     2   27 49         71       76
1523403 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_4 0.0 69.0 3.0         0.0     1.0   28.0 45.0     0       60     *   73 0 69 3         0     1   28 45     0   60       73
1523405 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_6 0.0 62.0 6.0         1.0     0.0   32.0 37.0     *       61     *   69 0 62 6         1     0   32 37         61       69
1523406 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_7 0.0 69.0 8.0         0.0     0.0   40.0 37.0     0       67     *   77 0 69 8         0     0   40 37     0   67       77
1523407 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_8 0.0 51.0 4.0         1.0     0.0   18.0 38.0     *       54     *   56 0 51 4         1     0   18 38         54       56
1523409 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   kindergarten_full_day 0.0 67.0 3.0         0.0     3.0   34.0 39.0     0       67     *   73 0 67 3         0     3   34 39     0   67       73
1523417 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2020   grade_10 1.0 52.0 14.0   1.0     1.0     11.0   80.0               61     *   80 1 52 14   1     1     11   80           61       80
1523418 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2020   grade_11 3.0 41.0 18.0   0.0     1.0     7.0   70.0               43     *   70 3 41 18   0     1     7   70           43       70
1523419 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2020   grade_12 1.0 56.0 9.0   0.0     0.0     7.0   73.0               43     *   73 1 56 9   0     0     7   73           43       73
1523437 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2020   grade_11 12.0 43.0 11.0   1.0     5.0     5.0     77.0     10       69     *   77 12 43 11   1     5     5     77     10   69       77
1523438 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2020   grade_12 12.0 49.0 3.0   0.0     1.0     1.0     66.0     6       53     *   66 12 49 3   0     1     1     66     6   53       66
1523463 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_7 58.0 1.0 0.0   0.0     1.0     0.0   34.0 26.0             25     *   60 58 1 0   0     1     0   34 26         25       60
1523472 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2020   ungraded_secondary 2.0 0.0 0.0   0.0     0.0     0.0   2.0 0.0             *     *   2 2 0 0   0     0     0   2 0                 2
1523478 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   grade_3 40.0 0.0 3.0         1.0     2.0   23.0 23.0     *       20     *   46 40 0 3         1     2   23 23         20       46
1523479 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   grade_4 46.0 0.0 1.0         0.0     1.0   26.0 22.0     *       18     *   48 46 0 1         0     1   26 22         18       48
1523488 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   pre_kindergarten_full_day 34.0 0.0 1.0         0.0     1.0   17.0 19.0     *       15     *   36 34 0 1         0     1   17 19         15       36
1523497 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_3 37.0 0.0 1.0         1.0     5.0   14.0 30.0             *     *   44 37 0 1         1     5   14 30                 44
1523498 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_4 32.0 1.0 3.0         1.0     1.0   20.0 18.0             *     *   38 32 1 3         1     1   20 18                 38
1523504 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   kindergarten_full_day 25.0 1.0 2.0         1.0     4.0   18.0 15.0             *     *   33 25 1 2         1     4   18 15                 33
1523523 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   kindergarten_full_day 35.0 0.0 1.0   1.0     1.0     3.0   21.0 20.0     *       *     *   41 35 0 1   1     1     3   21 20                 41
1523528 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     1.0   2.0 0.0     0       *     *   2 1 0 0   0     0     1   2 0     0           2
1523585 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 2.0 0.0 0.0         0.0     0.0   1.0 1.0     0       *     *   2 2 0 0         0     0   1 1     0           2
1523586 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_secondary 3.0 0.0 0.0         0.0     0.0   2.0 1.0     0       *     *   3 3 0 0         0     0   2 1     0           3
1523660 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2020   pre_kindergarten_half_day 36.0 0.0 0.0         0.0     0.0   18.0 18.0             *     *   36 36 0 0         0     0   18 18                 36
1523661 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2020   ungraded_elementary 1.0 0.0 0.0         0.0     0.0   1.0 0.0             *     *   1 1 0 0         0     0   1 0                 1
1523701 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2020   grade_1 35.0 8.0 1.0   0.0     0.0     8.0   30.0 22.0             34     *   52 35 8 1   0     0     8   30 22         34       52
1523708 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2020   grade_5 43.0 8.0 2.0   0.0     1.0     4.0   31.0 27.0             41     *   58 43 8 2   0     1     4   31 27         41       58
1523725 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2020   grade_3 11.0 5.0 9.0         0.0     1.0   8.0 18.0             18     *   26 11 5 9         0     1   8 18         18       26
1523726 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2020   grade_4 14.0 1.0 2.0         0.0     2.0   10.0 9.0             14     *   19 14 1 2         0     2   10 9         14       19
1523775 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_elementary 2.0 0.0 1.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 2 0 1   0     0     0   2 1                 3
1523776 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2020   ungraded_secondary 3.0 0.0 0.0   0.0     0.0     1.0   2.0 2.0     *       *     *   4 3 0 0   0     0     1   2 2                 4
1523834 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_1 38.0 3.0 9.0   1.0     14.0     9.0   39.0 35.0     16       35     *   74 38 3 9   1     14     9   39 35     16   35       74
1523840 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_4 41.0 3.0 4.0   0.0     10.0     5.0   31.0 32.0     10       19     *   63 41 3 4   0     10     5   31 32     10   19       63
1523927 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2020   ungraded_elementary 2.0 0.0 0.0         2.0     0.0   3.0 1.0     0       *     *   4 2 0 0         2     0   3 1     0           4
1523928 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2020   ungraded_secondary 5.0 0.0 2.0         1.0     0.0   3.0 5.0     0       *     *   8 5 0 2         1     0   3 5     0           8
1523953 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2020   grade_3 8.0 11.0 0.0   0.0     19.0     0.0   23.0 15.0     5       10     *   38 8 11 0   0     19     0   23 15     5   10       38
1523956 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2020   grade_6 6.0 10.0 2.0   0.0     7.0     2.0   16.0 11.0     *       15     *   27 6 10 2   0     7     2   16 11         15       27
1523958 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2020   grade_8 2.0 6.0 4.0   0.0     4.0     2.0   6.0 12.0     *       8     *   18 2 6 4   0     4     2   6 12         8       18
1523965 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2020   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     0       *     *   1 1 0 0   0     0     0   0 1     0           1
1523991 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2020   grade_3 41.0 3.0 4.0   0.0     24.0     1.0   35.0 38.0     7       11     *   73 41 3 4   0     24     1   35 38     7   11       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]);