enrollments

Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2017 sorted by ell_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 89,618 ✖
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
942681 942681 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2017   grade_1 56.0 2.0 7.0   1.0     0.0     8.0   33.0 41.0     *       34     11   74 56 2 7   1     0     8   33 41         34   11   74
942685 942685 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2017   grade_2 41.0 2.0 9.0   0.0     0.0     9.0   33.0 28.0     *       29     10   61 41 2 9   0     0     9   33 28         29   10   61
942693 942693 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2017   kindergarten_full_day 51.0 3.0 8.0   0.0     1.0     6.0   31.0 38.0     *       29     6   69 51 3 8   0     1     6   31 38         29   6   69
942757 942757 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
942758 942758 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 105.0 16.0 7.0   0.0     0.0     5.0   73.0 60.0     *       91     20   133 105 16 7   0     0     5   73 60         91   20   133
942759 942759 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_11 83.0 16.0 9.0   1.0     0.0     7.0   49.0 67.0     *       74     13   116 83 16 9   1     0     7   49 67         74   13   116
942760 942760 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_12 102.0 8.0 5.0   0.0     0.0     0.0   60.0 55.0     *       67     13   115 102 8 5   0     0     0   60 55         67   13   115
942761 942761 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942762 942762 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942763 942763 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
942764 942764 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES 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
942765 942765 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942766 942766 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942767 942767 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942768 942768 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 121.0 14.0 8.0   1.0     3.0     5.0   68.0 84.0     *       94     23   152 121 14 8   1     3     5   68 84         94   23   152
942769 942769 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
942770 942770 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942771 942771 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 420.0 55.0 32.0   2.0     4.0     17.0   257.0 273.0     *       339     83   530 420 55 32   2     4     17   257 273         339   83   530
942772 942772 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942773 942773 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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     0   0 0         0   0   0
942774 942774 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   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
942775 942775 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   ungraded_secondary 9.0 1.0 3.0   0.0     1.0     0.0   7.0 7.0     *       13     14   14 9 1 3   0     1     0   7 7         13   14   14
942784 942784 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 101.0 12.0 12.0   1.0     2.0     7.0   59.0 76.0     *       90     17   135 101 12 12   1     2     7   59 76         90   17   135
942786 942786 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 116.0 7.0 12.0   0.0     4.0     8.0   91.0 56.0     *       100     30   147 116 7 12   0     4     8   91 56         100   30   147
942795 942795 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   grade_1 57.0 11.0 5.0         1.0     4.0   46.0 32.0     *       46     13   78 57 11 5         1     4   46 32         46   13   78
942800 942800 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   grade_3 56.0 7.0 7.0         1.0     2.0   38.0 35.0     *       52     9   73 56 7 7         1     2   38 35         52   9   73
942801 942801 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   grade_4 59.0 5.0 2.0         1.0     9.0   36.0 40.0     *       50     13   76 59 5 2         1     9   36 40         50   13   76
942802 942802 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   grade_5 52.0 7.0 1.0         0.0     3.0   26.0 37.0     *       31     15   63 52 7 1         0     3   26 37         31   15   63
942807 942807 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   kindergarten_full_day 49.0 5.0 9.0         2.0     4.0   42.0 27.0     *       27     13   69 49 5 9         2     4   42 27         27   13   69
942873 942873 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2017   grade_11 289.0 35.0 31.0   0.0     49.0     17.0   215.0 206.0     *       123     75   421 289 35 31   0     49     17   215 206         123   75   421
942874 942874 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2017   grade_12 274.0 25.0 24.0   0.0     32.0     16.0   187.0 184.0     *       82     56   371 274 25 24   0     32     16   187 184         82   56   371
942935 942935 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2017   grade_5 143.0 11.0 12.0   0.0     23.0     15.0   102.0 102.0     *       65     29   204 143 11 12   0     23     15   102 102         65   29   204
942946 942946 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2017   ungraded_secondary 2.0 3.0 0.0   0.0     3.0     2.0   9.0 1.0     *       6     10   10 2 3 0   0     3     2   9 1         6   10   10
942970 942970 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_2 9.0 7.0 3.0   1.0     12.0     3.0   14.0 21.0     *       11     *   35 9 7 3   1     12     3   14 21         11       35
942972 942972 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_4 8.0 4.0 2.0   1.0     15.0     1.0   16.0 15.0     *       *     *   31 8 4 2   1     15     1   16 15                 31
942974 942974 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_6 9.0 17.0 1.0   0.0     5.0     1.0   14.0 19.0     *       17     *   33 9 17 1   0     5     1   14 19         17       33
942975 942975 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_7 8.0 6.0 0.0   0.0     8.0     0.0   7.0 15.0     *       9     *   22 8 6 0   0     8     0   7 15         9       22
942976 942976 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   grade_8 11.0 2.0 1.0   0.0     0.0     4.0   11.0 7.0     *       7     *   18 11 2 1   0     0     4   11 7         7       18
942991 942991 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2017   grade_4 43.0 4.0 0.0         12.0     2.0   33.0 28.0     *       13     16   61 43 4 0         12     2   33 28         13   16   61
942992 942992 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2017   grade_5 41.0 3.0 9.0         14.0     7.0   36.0 38.0     *       20     19   74 41 3 9         14     7   36 38         20   19   74
942993 942993 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2017   grade_6 49.0 6.0 3.0         15.0     4.0   45.0 32.0     *       23     20   77 49 6 3         15     4   45 32         23   20   77
943008 943008 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   grade_2 50.0 4.0 4.0   0.0     16.0     2.0   42.0 34.0     *       *     *   76 50 4 4   0     16     2   42 34                 76
943010 943010 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   grade_4 45.0 2.0 7.0   1.0     19.0     5.0   43.0 36.0     *       13     7   79 45 2 7   1     19     5   43 36         13   7   79
943011 943011 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   grade_5 49.0 0.0 4.0   0.0     20.0     2.0   45.0 30.0     *       13     10   75 49 0 4   0     20     2   45 30         13   10   75
943012 943012 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   grade_6 58.0 3.0 5.0   0.0     18.0     1.0   48.0 37.0     *       16     8   85 58 3 5   0     18     1   48 37         16   8   85
943016 943016 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   kindergarten_full_day 38.0 1.0 4.0   0.0     15.0     1.0   32.0 27.0     *       *     6   59 38 1 4   0     15     1   32 27             6   59
943029 943029 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2017   grade_4 45.0 1.0 3.0         10.0     5.0   34.0 30.0     *       15     6   64 45 1 3         10     5   34 30         15   6   64
943030 943030 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2017   grade_5 39.0 3.0 4.0         14.0     7.0   39.0 28.0     *       19     5   67 39 3 4         14     7   39 28         19   5   67
943047 943047 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2017   grade_3 45.0 1.0 0.0   0.0     15.0     3.0   24.0 40.0     *       18     *   64 45 1 0   0     15     3   24 40         18       64
943048 943048 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2017   grade_4 55.0 1.0 1.0   0.0     8.0     2.0   32.0 35.0     *       16     *   67 55 1 1   0     8     2   32 35         16       67
943049 943049 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2017   grade_5 52.0 0.0 5.0   0.0     11.0     4.0   30.0 42.0     *       19     8   72 52 0 5   0     11     4   30 42         19   8   72
943050 943050 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2017   grade_6 39.0 4.0 0.0   0.0     20.0     7.0   41.0 29.0     *       18     9   70 39 4 0   0     20     7   41 29         18   9   70
943061 943061 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   grade_1 32.0 0.0 2.0   0.0     3.0     3.0   12.0 28.0     *       *     *   40 32 0 2   0     3     3   12 28                 40
943065 943065 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   grade_2 32.0 3.0 6.0   1.0     2.0     2.0   21.0 25.0     *       7     8   46 32 3 6   1     2     2   21 25         7   8   46
943066 943066 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   grade_3 41.0 0.0 2.0   0.0     3.0     1.0   26.0 21.0     *       *     *   47 41 0 2   0     3     1   26 21                 47
943073 943073 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   kindergarten_full_day 31.0 0.0 7.0   0.0     2.0     1.0   16.0 25.0     *       *     *   41 31 0 7   0     2     1   16 25                 41
943080 943080 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_1 46.0 3.0 4.0   0.0     4.0     1.0   35.0 23.0     *       13     10   58 46 3 4   0     4     1   35 23         13   10   58
943084 943084 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_2 32.0 2.0 4.0   0.0     2.0     3.0   29.0 14.0     *       15     10   43 32 2 4   0     2     3   29 14         15   10   43
943085 943085 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_3 25.0 3.0 1.0   1.0     10.0     3.0   22.0 21.0     *       *     *   43 25 3 1   1     10     3   22 21                 43
943086 943086 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_4 33.0 3.0 2.0   0.0     7.0     3.0   28.0 20.0     *       8     7   48 33 3 2   0     7     3   28 20         8   7   48
943088 943088 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   grade_6 38.0 6.0 3.0   1.0     13.0     2.0   29.0 34.0     *       13     8   63 38 6 3   1     13     2   29 34         13   8   63
943097 943097 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   ungraded_elementary 7.0 1.0 0.0   0.0     6.0     1.0   12.0 3.0     *       9     15   15 7 1 0   0     6     1   12 3         9   15   15
943108 943108 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   grade_7 326.0 20.0 21.0   2.0     45.0     13.0   229.0 198.0     *       81     60   427 326 20 21   2     45     13   229 198         81   60   427
943117 943117 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   ungraded_secondary 4.0 0.0 0.0   0.0     1.0     1.0   4.0 2.0     *       6     6   6 4 0 0   0     1     1   4 2         6   6   6
943121 943121 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2017   grade_12 317.0 31.0 20.0   0.0     71.0     6.0   216.0 229.0     *       91     36   445 317 31 20   0     71     6   216 229         91   36   445
943129 943129 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 341.0 30.0 26.0   1.0     72.0     13.0   215.0 268.0     *       96     55   483 341 30 26   1     72     13   215 268         96   55   483
943137 943137 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_1 21.0 2.0 0.0         1.0     0.0   7.0 17.0     *       17     *   24 21 2 0         1     0   7 17         17       24
943138 943138 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_10 17.0 0.0 0.0         0.0     2.0   6.0 13.0     *       11     *   19 17 0 0         0     2   6 13         11       19
943139 943139 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_11 9.0 0.0 1.0         0.0     3.0   4.0 9.0     *       8     *   13 9 0 1         0     3   4 9         8       13
943140 943140 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_12 14.0 1.0 0.0         0.0     3.0   11.0 7.0     *       8     *   18 14 1 0         0     3   11 7         8       18
943141 943141 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_2 16.0 0.0 0.0         0.0     0.0   6.0 10.0     *       8     *   16 16 0 0         0     0   6 10         8       16
943142 943142 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_3 26.0 1.0 1.0         0.0     0.0   15.0 13.0     *       23     5   28 26 1 1         0     0   15 13         23   5   28
943143 943143 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_4 23.0 1.0 3.0         1.0     1.0   11.0 18.0     *       22     *   29 23 1 3         1     1   11 18         22       29
943144 943144 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_5 17.0 1.0 3.0         1.0     4.0   13.0 13.0     *       19     9   26 17 1 3         1     4   13 13         19   9   26
943145 943145 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_6 21.0 0.0 1.0         0.0     2.0   10.0 14.0     *       20     5   24 21 0 1         0     2   10 14         20   5   24
943146 943146 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_7 22.0 1.0 0.0         1.0     2.0   13.0 13.0     *       16     5   26 22 1 0         1     2   13 13         16   5   26
943147 943147 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_8 21.0 3.0 1.0         0.0     1.0   10.0 16.0     *       22     6   26 21 3 1         0     1   10 16         22   6   26
943148 943148 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_9 27.0 3.0 2.0         0.0     0.0   15.0 17.0     *       22     9   32 27 3 2         0     0   15 17         22   9   32
943149 943149 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   kindergarten_full_day 26.0 1.0 1.0         0.0     1.0   17.0 12.0     *       20     *   29 26 1 1         0     1   17 12         20       29
943150 943150 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   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
943151 943151 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   pk_12_total 273.0 15.0 16.0         5.0     21.0   149.0 181.0     *       225     61   330 273 15 16         5     21   149 181         225   61   330
943152 943152 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_full_day 13.0 1.0 3.0         1.0     2.0   11.0 9.0     *       9     *   20 13 1 3         1     2   11 9         9       20
943153 943153 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   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         0   0   0
943154 943154 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   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
943155 943155 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   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
943156 943156 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 42.0 0.0 1.0         1.0     3.0   16.0 31.0     *       17     *   47 42 0 1         1     3   16 31         17       47
943157 943157 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943158 943158 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943159 943159 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943160 943160 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 40.0 1.0 1.0         1.0     1.0   22.0 22.0     *       14     9   44 40 1 1         1     1   22 22         14   9   44
943161 943161 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_3 28.0 1.0 1.0         0.0     1.0   18.0 13.0     *       8     *   31 28 1 1         0     1   18 13         8       31
943162 943162 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 48.0 2.0 3.0         1.0     2.0   31.0 25.0     *       21     5   56 48 2 3         1     2   31 25         21   5   56
943163 943163 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_5 43.0 1.0 1.0         1.0     1.0   28.0 19.0     *       13     5   47 43 1 1         1     1   28 19         13   5   47
943164 943164 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943165 943165 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943166 943166 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943167 943167 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943168 943168 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   kindergarten_full_day 45.0 0.0 2.0         2.0     2.0   25.0 26.0     *       10     7   51 45 0 2         2     2   25 26         10   7   51
943169 943169 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
943170 943170 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 254.0 5.0 9.0         9.0     10.0   146.0 141.0     *       89     43   287 254 5 9         9     10   146 141         89   43   287

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