enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1132658 1132658 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2017   grade_9 171 0 7 0   3     0   7   90 98                       188 171 0 7 0   3     0   7   90 98                 188
1132659 1132659 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2017   grade_10 142 2 8 0   1     0   5   75 83                       158 142 2 8 0   1     0   5   75 83                 158
1132660 1132660 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2017   grade_11 152 0 10 0   1     0   3   78 88                       166 152 0 10 0   1     0   3   78 88                 166
1132661 1132661 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2017   grade_12 148 2 7 0   1     0   6   90 74                       164 148 2 7 0   1     0   6   90 74                 164
1132662 1132662 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132655 1132655 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   grade_7 190 0 12 0   1     0   5   106 102                       208 190 0 12 0   1     0   5   106 102                 208
1132656 1132656 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   grade_8 198 1 7 0   1     0   9   103 113                       216 198 1 7 0   1     0   9   103 113                 216
1132657 1132657 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132621 1132621 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   kindergarten 18 0 1 0   0     0   0   12 7                       19 18 0 1 0   0     0   0   12 7                 19
1132622 1132622 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_1 24 0 3 0   0     0   1   16 12                       28 24 0 3 0   0     0   1   16 12                 28
1132623 1132623 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_2 21 0 2 1   0     0   0   11 13                       24 21 0 2 1   0     0   0   11 13                 24
1132624 1132624 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_3 31 0 3 0   0     0   0   21 13                       34 31 0 3 0   0     0   0   21 13                 34
1132625 1132625 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_4 28 1 3 0   0     0   0   19 13                       32 28 1 3 0   0     0   0   19 13                 32
1132626 1132626 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_5 26 0 2 0   0     0   0   10 18                       28 26 0 2 0   0     0   0   10 18                 28
1132627 1132627 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_6 26 0 2 0   0     0   1   17 12                       29 26 0 2 0   0     0   1   17 12                 29
1132628 1132628 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132629 1132629 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   kindergarten 44 1 0 0   1     0   0   24 22                       46 44 1 0 0   1     0   0   24 22                 46
1132630 1132630 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_1 38 0 1 0   0     0   0   20 19                       39 38 0 1 0   0     0   0   20 19                 39
1132631 1132631 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_2 44 0 1 0   0     0   0   18 27                       45 44 0 1 0   0     0   0   18 27                 45
1132632 1132632 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_3 49 0 1 0   0     0   0   21 29                       50 49 0 1 0   0     0   0   21 29                 50
1132633 1132633 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_4 39 1 0 0   1     0   1   19 23                       42 39 1 0 0   1     0   1   19 23                 42
1132634 1132634 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_5 45 0 1 0   0     0   0   27 19                       46 45 0 1 0   0     0   0   27 19                 46
1132635 1132635 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_6 47 0 1 0   0     0   0   15 33                       48 47 0 1 0   0     0   0   15 33                 48
1132636 1132636 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132637 1132637 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   kindergarten 19 0 0 0   0     0   0   8 11                       19 19 0 0 0   0     0   0   8 11                 19
1132638 1132638 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   pre_kindergarten 58 0 6 0   0     0   1   38 27                       65 58 0 6 0   0     0   1   38 27                 65
1132639 1132639 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   grade_1 21 0 2 0   0     0   1   10 14                       24 21 0 2 0   0     0   1   10 14                 24
1132640 1132640 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132641 1132641 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_2 28 0 0 0   0     0   0   8 20                       28 28 0 0 0   0     0   0   8 20                 28
1132642 1132642 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_3 23 0 3 0   0     0   0   14 12                       26 23 0 3 0   0     0   0   14 12                 26
1132643 1132643 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_4 29 0 0 0   0     0   0   12 17                       29 29 0 0 0   0     0   0   12 17                 29
1132644 1132644 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_5 28 0 0 0   0     0   1   12 17                       29 28 0 0 0   0     0   1   12 17                 29
1132645 1132645 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_6 34 0 1 0   1     0   1   22 15                       37 34 0 1 0   1     0   1   22 15                 37
1132646 1132646 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132647 1132647 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   kindergarten 37 0 2 0   0     0   0   20 19                       39 37 0 2 0   0     0   0   20 19                 39
1132648 1132648 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_1 47 0 3 0   2     0   2   27 27                       54 47 0 3 0   2     0   2   27 27                 54
1132649 1132649 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_2 52 0 3 0   1     0   2   30 28                       58 52 0 3 0   1     0   2   30 28                 58
1132650 1132650 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_3 51 0 4 0   1     1   0   34 23                       57 51 0 4 0   1     1   0   34 23                 57
1132651 1132651 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_4 39 0 3 0   0     0   1   21 22                       43 39 0 3 0   0     0   1   21 22                 43
1132652 1132652 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_5 57 0 2 0   1     0   1   30 31                       61 57 0 2 0   1     0   1   30 31                 61
1132653 1132653 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_6 50 0 2 0   0     0   4   25 31                       56 50 0 2 0   0     0   4   25 31                 56
1132654 1132654 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132663 1132663 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   grade_11 6 1 0 0   0     0   0   * 5                       7 6 1 0 0   0     0   0     5                 7
1132664 1132664 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   grade_12 5 1 0 0   0     0   0   * 4                       6 5 1 0 0   0     0   0     4                 6
1132665 1132665 MA Worcester   school 2500001 753   Quabbin 250000102797 7530515 IB School of Quabbin   Regular School No High 11 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132759 1132759 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_5 90 2 13 0   0     0   7   67 45                       112 90 2 13 0   0     0   7   67 45                 112
1132760 1132760 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_6 87 1 9 0   1     0   0   57 41                       98 87 1 9 0   1     0   0   57 41                 98
1132761 1132761 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_7 82 0 10 0   1     0   4   52 45                       97 82 0 10 0   1     0   4   52 45                 97
1132762 1132762 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_8 94 1 8 1   0     0   3   51 56                       107 94 1 8 1   0     0   3   51 56                 107
1132763 1132763 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132744 1132744 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
1132745 1132745 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 40 1 3 0   0     0   2   24 22                       46 40 1 3 0   0     0   2   24 22                 46
1132746 1132746 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_1 24 0 2 0   0     0   1   15 12                       27 24 0 2 0   0     0   1   15 12                 27
1132747 1132747 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_2 16 0 1 1   0     0   2   10 10                       20 16 0 1 1   0     0   2   10 10                 20
1132748 1132748 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_3 29 1 1 0   0     0   1   16 16                       32 29 1 1 0   0     0   1   16 16                 32
1132749 1132749 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_4 19 0 2 0   0     0   2   12 11                       23 19 0 2 0   0     0   2   12 11                 23
1132750 1132750 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_5 17 0 1 0   0     0   0   11 7                       18 17 0 1 0   0     0   0   11 7                 18
1132751 1132751 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 25 0 3 0   1     0   2   18 13                       31 25 0 3 0   1     0   2   18 13                 31
1132752 1132752 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132764 1132764 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_9 58 1 9 0   2     0   2   47 25                       72 58 1 9 0   2     0   2   47 25                 72
1132765 1132765 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_10 80 1 5 0   0     0   4   48 42                       90 80 1 5 0   0     0   4   48 42                 90
1132766 1132766 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_11 55 2 7 0   2     0   6   31 41                       72 55 2 7 0   2     0   6   31 41                 72
1132767 1132767 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   grade_12 90 0 7 0   0     0   5   57 45                       102 90 0 7 0   0     0   5   57 45                 102
1132768 1132768 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132753 1132753 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   kindergarten 49 1 7 0   0     0   3   34 26                       60 49 1 7 0   0     0   3   34 26                 60
1132754 1132754 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_1 63 0 8 0   0     0   3   30 44                       74 63 0 8 0   0     0   3   30 44                 74
1132755 1132755 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_2 89 1 8 0   1     0   2   52 49                       101 89 1 8 0   1     0   2   52 49                 101
1132756 1132756 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_3 81 0 10 0   2     0   3   46 50                       96 81 0 10 0   2     0   3   46 50                 96
1132757 1132757 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_4 85 2 5 0   3     0   4   50 49                       99 85 2 5 0   3     0   4   50 49                 99
1132758 1132758 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132737 1132737 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_7 119 3 3 0   0     0   1   62 64                       126 119 3 3 0   0     0   1   62 64                 126
1132738 1132738 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_8 109 2 9 0   1     0   1   63 59                       122 109 2 9 0   1     0   1   63 59                 122
1132739 1132739 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_9 109 1 2 0   1     0   1   63 51                       114 109 1 2 0   1     0   1   63 51                 114
1132740 1132740 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_10 113 3 8 0   0     0   1   61 64                       125 113 3 8 0   0     0   1   61 64                 125
1132741 1132741 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_11 119 1 4 0   1     0   3   68 60                       128 119 1 4 0   1     0   3   68 60                 128
1132742 1132742 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_12 113 4 2 0   0     0   1   55 65                       120 113 4 2 0   0     0   1   55 65                 120
1132743 1132743 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132720 1132720 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   kindergarten 72 2 7 0   1     0   3   45 40                       85 72 2 7 0   1     0   3   45 40                 85
1132721 1132721 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   pre_kindergarten 52 0 9 0   0     0   1   34 28                       62 52 0 9 0   0     0   1   34 28                 62
1132722 1132722 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   grade_1 88 2 4 0   0     0   0   51 43                       94 88 2 4 0   0     0   0   51 43                 94
1132723 1132723 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   grade_2 85 1 6 0   1     0   4   47 50                       97 85 1 6 0   1     0   4   47 50                 97
1132724 1132724 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132732 1132732 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_3 76 3 11 0   1     0   0   42 49                       91 76 3 11 0   1     0   0   42 49                 91
1132733 1132733 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_4 95 1 3 0   1     0   3   50 53                       103 95 1 3 0   1     0   3   50 53                 103
1132734 1132734 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_5 87 2 6 0   1     0   3   50 49                       99 87 2 6 0   1     0   3   50 49                 99
1132735 1132735 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_6 90 3 3 0   2     0   1   49 50                       99 90 3 3 0   2     0   1   49 50                 99
1132736 1132736 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132725 1132725 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   kindergarten 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
1132726 1132726 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_1 13 0 0 0   0     0   1   8 6                       14 13 0 0 0   0     0   1   8 6                 14
1132727 1132727 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_3 18 0 0 0   0     0   2   9 11                       20 18 0 0 0   0     0   2   9 11                 20
1132728 1132728 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_4 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
1132729 1132729 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_5 9 0 1 0   0     0   1   4 7                       11 9 0 1 0   0     0   1   4 7                 11
1132730 1132730 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_6 12 0 0 0   0     0   0   5 7                       12 12 0 0 0   0     0   0   5 7                 12
1132731 1132731 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131934 1131934 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   kindergarten 21 0 0 1   0     0   0   11 11                       22 21 0 0 1   0     0   0   11 11                 22
1131935 1131935 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 13 1 1 0   0     0   0   8 7                       15 13 1 1 0   0     0   0   8 7                 15
1131936 1131936 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_1 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
1131937 1131937 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_2 17 0 1 1   0     0   0   11 8                       19 17 0 1 1   0     0   0   11 8                 19
1131938 1131938 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_4 19 0 0 0   0     0   0   13 6                       19 19 0 0 0   0     0   0   13 6                 19
1131939 1131939 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_5 19 0 0 0   0     0   0   6 13                       19 19 0 0 0   0     0   0   6 13                 19

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