enrollments

Data source: Big Local News · About: Big Local

89,661 rows where state = "NY" and year = 2019 sorted by ell_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 89,661 ✖
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
2139093 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
2139097 2139097 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_2 27.0 8.0 6.0         2.0     7.0   34.0 16.0     *       15     *   50 27 8 6         2     7   34 16         15       50
2139098 2139098 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_3 23.0 10.0 5.0         3.0     2.0   21.0 22.0     *       14     *   43 23 10 5         3     2   21 22         14       43
2139099 2139099 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_4 22.0 7.0 6.0         7.0     3.0   30.0 15.0     *       11     *   45 22 7 6         7     3   30 15         11       45
2139100 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
2139105 2139105 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   kindergarten_full_day 15.0 11.0 3.0         5.0     10.0   22.0 22.0     *       14     8   44 15 11 3         5     10   22 22         14   8   44
2139112 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
2139119 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
2139150 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
2139155 2139155 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_3 30.0 21.0 13.0   0.0     3.0     10.0   41.0 36.0     *       39     12   77 30 21 13   0     3     10   41 36         39   12   77
2139156 2139156 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 34.0 23.0 8.0   0.0     3.0     7.0   45.0 30.0     *       37     16   75 34 23 8   0     3     7   45 30         37   16   75
2139169 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
2139181 2139181 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2019   kindergarten_full_day 0.0 26.0 2.0         3.0     0.0   18.0 13.0     *       25     *   31 0 26 2         3     0   18 13         25       31
2139188 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
2139192 2139192 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_2 15.0 39.0 11.0   0.0     4.0     6.0   35.0 40.0     *       50     10   75 15 39 11   0     4     6   35 40         50   10   75
2139193 2139193 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_3 8.0 25.0 7.0   1.0     5.0     14.0   36.0 24.0     *       38     6   60 8 25 7   1     5     14   36 24         38   6   60
2139194 2139194 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_4 10.0 33.0 21.0   0.0     2.0     5.0   33.0 38.0     *       46     11   71 10 33 21   0     2     5   33 38         46   11   71
2139195 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
2139196 2139196 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_6 8.0 43.0 12.0   0.0     5.0     5.0   29.0 44.0     *       47     *   73 8 43 12   0     5     5   29 44         47       73
2139200 2139200 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   kindergarten_full_day 11.0 29.0 12.0   0.0     3.0     8.0   30.0 33.0     *       35     7   63 11 29 12   0     3     8   30 33         35   7   63
2139205 2139205 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   ungraded_elementary 1.0 16.0 7.0   0.0     0.0     1.0   15.0 10.0     *       23     25   25 1 16 7   0     0     1   15 10         23   25   25
2139207 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
2139212 2139212 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_3 25.0 13.0 5.0         3.0     0.0   28.0 18.0     *       15     5   46 25 13 5         3     0   28 18         15   5   46
2139214 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
2139226 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
2139238 2139238 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2019   kindergarten_full_day 8.0 28.0 8.0   1.0     13.0     7.0   38.0 27.0     *       50     9   65 8 28 8   1     13     7   38 27         50   9   65
2139302 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
2139307 2139307 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_3 2.0 40.0 6.0         2.0     3.0   32.0 21.0     *       45     8   53 2 40 6         2     3   32 21         45   8   53
2139308 2139308 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 5.0 33.0 4.0         0.0     6.0   25.0 23.0     *       44     13   48 5 33 4         0     6   25 23         44   13   48
2139309 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
2139314 2139314 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 1.0 23.0 14.0         1.0     5.0   28.0 16.0     *       36     *   44 1 23 14         1     5   28 16         36       44
2139340 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
2139346 2139346 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   grade_4 3.0 28.0 12.0   0.0     1.0     5.0   23.0 26.0     *       46     *   49 3 28 12   0     1     5   23 26         46       49
2139386 2139386 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   grade_6 16.0 99.0 31.0         7.0     12.0   76.0 89.0     *       146     16   165 16 99 31         7     12   76 89         146   16   165
2139396 2139396 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   ungraded_secondary 3.0 16.0 4.0         2.0     0.0   17.0 8.0     *       25     25   25 3 16 4         2     0   17 8         25   25   25
2139401 2139401 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_2 1.0 39.0 14.0         3.0     4.0   61.0 0.0     *       57     *   61 1 39 14         3     4   61 0         57       61
2139403 2139403 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_4 1.0 43.0 10.0         0.0     1.0   55.0 0.0     *       52     *   55 1 43 10         0     1   55 0         52       55
2139409 2139409 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2019   kindergarten_full_day 2.0 24.0 10.0         4.0     4.0   43.0 1.0     *       41     *   44 2 24 10         4     4   43 1         41       44
2139420 2139420 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_2 1.0 32.0 15.0         4.0     2.0     54.0     *       49     *   54 1 32 15         4     2     54         49       54
2139421 2139421 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_3 1.0 37.0 13.0         1.0     6.0     58.0     *       51     *   58 1 37 13         1     6     58         51       58
2139422 2139422 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_4 3.0 27.0 15.0         5.0     0.0     50.0     *       45     0   50 3 27 15         5     0     50         45   0   50
2139435 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
2139439 2139439 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_2 1.0 80.0 9.0   0.0     2.0     5.0   61.0 36.0     *       71     *   97 1 80 9   0     2     5   61 36         71       97
2139454 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
2139458 2139458 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_2 1.0 48.0 15.0               5.0   34.0 35.0     *       59     *   69 1 48 15               5   34 35         59       69
2139459 2139459 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_3 1.0 47.0 8.0               3.0   23.0 36.0     *       49     *   59 1 47 8               3   23 36         49       59
2139460 2139460 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_4 1.0 48.0 5.0               0.0   25.0 29.0     *       50     *   54 1 48 5               0   25 29         50       54
2139466 2139466 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   kindergarten_full_day 3.0 57.0 14.0               4.0   35.0 43.0     *       65     0   78 3 57 14               4   35 43         65   0   78
2139473 2139473 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_1 0.0 64.0 9.0         0.0     1.0   27.0 47.0     *       69     *   74 0 64 9         0     1   27 47         69       74
2139477 2139477 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_2 0.0 73.0 3.0         0.0     2.0   29.0 49.0     *       73     0   78 0 73 3         0     2   29 49         73   0   78
2139478 2139478 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_3 0.0 72.0 3.0         0.0     0.0   29.0 46.0     *       64     *   75 0 72 3         0     0   29 46         64       75
2139480 2139480 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_5 0.0 75.0 3.0         1.0     0.0   45.0 34.0     *       71     *   79 0 75 3         1     0   45 34         71       79
2139482 2139482 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 58.0 4.0         1.0     0.0   25.0 38.0     *       51     0   63 0 58 4         1     0   25 38         51   0   63
2139483 2139483 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_8 0.0 62.0 3.0         0.0     0.0   33.0 32.0     *       58     *   65 0 62 3         0     0   33 32         58       65
2139587 2139587 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 45.0 2.0 1.0         3.0     4.0   23.0 32.0     *       5     8   55 45 2 1         3     4   23 32         5   8   55
2139592 2139592 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_3 48.0 4.0 3.0         4.0     1.0   25.0 35.0     *       12     13   60 48 4 3         4     1   25 35         12   13   60
2139599 2139599 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   kindergarten_full_day 42.0 3.0 0.0         7.0     4.0   27.0 29.0     *       12     *   56 42 3 0         7     4   27 29         12       56
2139625 2139625 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 53.0 0.0 1.0         7.0     6.0   33.0 34.0     *       *     6   67 53 0 1         7     6   33 34             6   67
2139629 2139629 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 67.0 1.0 3.0         5.0     6.0   45.0 37.0     *       14     11   82 67 1 3         5     6   45 37         14   11   82
2139630 2139630 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_3 54.0 1.0 2.0         5.0     3.0   43.0 22.0     *       8     9   65 54 1 2         5     3   43 22         8   9   65
2139631 2139631 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 70.0 0.0 1.0         6.0     1.0   37.0 41.0     *       14     10   78 70 0 1         6     1   37 41         14   10   78
2139632 2139632 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_5 73.0 1.0 5.0         9.0     1.0   42.0 47.0     *       16     10   89 73 1 5         9     1   42 47         16   10   89
2139637 2139637 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   kindergarten_full_day 77.0 1.0 4.0         2.0     4.0   50.0 38.0     *       *     13   88 77 1 4         2     4   50 38             13   88
2139652 2139652 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 279.0 10.0 5.0         26.0     8.0   163.0 165.0     *       46     42   328 279 10 5         26     8   163 165         46   42   328
2139653 2139653 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 300.0 10.0 13.0         31.0     6.0   207.0 153.0     *       53     44   360 300 10 13         31     6   207 153         53   44   360
2139654 2139654 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 299.0 9.0 8.0         22.0     2.0   153.0 187.0     *       55     50   340 299 9 8         22     2   153 187         55   50   340
2139664 2139664 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_10 309.0 7.0 17.0         25.0     7.0   166.0 199.0     *       49     19   365 309 7 17         25     7   166 199         49   19   365
2139665 2139665 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_11 337.0 12.0 20.0         25.0     4.0   193.0 205.0     *       46     26   398 337 12 20         25     4   193 205         46   26   398
2139666 2139666 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_12 334.0 12.0 11.0         28.0     5.0   188.0 202.0     *       37     19   390 334 12 11         28     5   188 202         37   19   390
2139674 2139674 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 330.0 7.0 13.0         28.0     8.0   172.0 214.0     *       56     33   386 330 7 13         28     8   172 214         56   33   386
2139682 2139682 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 52.0 2.0 2.0   0.0     6.0     2.0   32.0 32.0     *       7     14   64 52 2 2   0     6     2   32 32         7   14   64
2139688 2139688 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 66.0 0.0 5.0   0.0     5.0     0.0   38.0 38.0     *       16     10   76 66 0 5   0     5     0   38 38         16   10   76
2139703 2139703 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2019   grade_11 85.0 5.0 8.0         2.0     1.0   54.0 47.0     *       33     16   101 85 5 8         2     1   54 47         33   16   101
2139704 2139704 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2019   grade_12 129.0 9.0 10.0         1.0     3.0   60.0 92.0     *       60     26   152 129 9 10         1     3   60 92         60   26   152
2139712 2139712 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2019   grade_9 127.0 10.0 14.0         1.0     7.0   97.0 62.0     *       88     34   159 127 10 14         1     7   97 62         88   34   159
2139739 2139739 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_1 61.0 4.0 8.0   0.0     0.0     5.0   45.0 33.0     *       52     16   78 61 4 8   0     0     5   45 33         52   16   78
2139740 2139740 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139741 2139741 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139742 2139742 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139743 2139743 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_2 47.0 2.0 7.0   0.0     1.0     6.0   27.0 36.0     *       29     10   63 47 2 7   0     1     6   27 36         29   10   63
2139744 2139744 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_3 64.0 4.0 9.0   1.0     0.0     7.0   36.0 49.0     *       46     16   85 64 4 9   1     0     7   36 49         46   16   85
2139745 2139745 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_4 40.0 0.0 8.0   0.0     0.0     8.0   30.0 26.0     *       26     5   56 40 0 8   0     0     8   30 26         26   5   56
2139746 2139746 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_5 62.0 8.0 10.0   0.0     1.0     3.0   38.0 46.0     *       40     19   84 62 8 10   0     1     3   38 46         40   19   84
2139747 2139747 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139748 2139748 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139749 2139749 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139750 2139750 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139751 2139751 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   kindergarten_full_day 56.0 2.0 5.0   0.0     0.0     3.0   36.0 30.0     *       31     11   66 56 2 5   0     0     3   36 30         31   11   66
2139752 2139752 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139753 2139753 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 361.0 21.0 50.0   1.0     2.0     33.0   233.0 235.0     *       239     84   468 361 21 50   1     2     33   233 235         239   84   468
2139754 2139754 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139755 2139755 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   pre_kindergarten_half_day 31.0 1.0 3.0   0.0     0.0     1.0   21.0 15.0     *       15     7   36 31 1 3   0     0     1   21 15         15   7   36
2139756 2139756 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139757 2139757 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   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     0   0 0         0   0   0
2139815 2139815 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES 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
2139816 2139816 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_10 102.0 13.0 6.0   0.0     7.0     8.0   80.0 56.0     *       98     22   136 102 13 6   0     7     8   80 56         98   22   136
2139817 2139817 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_11 103.0 11.0 8.0   1.0     1.0     5.0   54.0 75.0     *       77     14   129 103 11 8   1     1     5   54 75         77   14   129
2139818 2139818 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_12 90.0 14.0 8.0   0.0     0.0     3.0   59.0 56.0     *       74     17   115 90 14 8   0     0     3   59 56         74   17   115
2139819 2139819 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2139820 2139820 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_3 0.0 0.0 0.0   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]);