enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
735915 735915 MA Worcester   school 2502220 17   Auburn 250222000102 170005 Julia Bancroft   Regular School No 1 03 05 2015   grade_3 77 3 8 0   6     0   4   52 46                       98 77 3 8 0   6     0   4   52 46                 98
735916 735916 MA Worcester   school 2502220 17   Auburn 250222000102 170005 Julia Bancroft   Regular School No 1 03 05 2015   grade_4 91 0 7 0   7     0   3   63 45                       108 91 0 7 0   7     0   3   63 45                 108
735917 735917 MA Worcester   school 2502220 17   Auburn 250222000102 170005 Julia Bancroft   Regular School No 1 03 05 2015   grade_5 86 1 2 0   1     0   5   47 48                       95 86 1 2 0   1     0   5   47 48                 95
735918 735918 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No 1 KG 02 2015   kindergarten 65 2 7 0   3     0   2   38 41                       79 65 2 7 0   3     0   2   38 41                 79
735919 735919 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No 1 KG 02 2015   grade_1 85 2 1 0   0     0   4   41 51                       92 85 2 1 0   0     0   4   41 51                 92
735920 735920 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No 1 KG 02 2015   grade_2 66 1 7 0   2     0   5   52 29                       81 66 1 7 0   2     0   5   52 29                 81
735921 735921 MA Worcester   school 2502220 17   Auburn 250222000104 170015 Pakachoag   Regular School No 1 03 05 2015   grade_3 70 0 5 0   1     0   2   46 32                       78 70 0 5 0   1     0   2   46 32                 78
735922 735922 MA Worcester   school 2502220 17   Auburn 250222000104 170015 Pakachoag   Regular School No 1 03 05 2015   grade_4 76 2 4 0   2     0   1   47 38                       85 76 2 4 0   2     0   1   47 38                 85
735923 735923 MA Worcester   school 2502220 17   Auburn 250222000104 170015 Pakachoag   Regular School No 1 03 05 2015   grade_5 80 1 6 0   4     0   5   46 50                       96 80 1 6 0   4     0   5   46 50                 96
735924 735924 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   kindergarten 71 0 5 1   3     0   1   43 38                       81 71 0 5 1   3     0   1   43 38                 81
735925 735925 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   grade_1 68 2 4 0   4     0   2   34 46                       80 68 2 4 0   4     0   2   34 46                 80
735926 735926 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   grade_2 79 0 9 0   5     0   3   45 51                       96 79 0 9 0   5     0   3   45 51                 96
735927 735927 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_6 173 1 4 1   9     0   3   90 101                       191 173 1 4 1   9     0   3   90 101                 191
735928 735928 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_7 164 4 10 1   6     0   11   106 90                       196 164 4 10 1   6     0   11   106 90                 196
735929 735929 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2015   grade_8 174 4 11 0   12     0   4   109 96                       205 174 4 11 0   12     0   4   109 96                 205
735930 735930 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   pre_kindergarten 40 1 2 0   4     0   3   28 22                       50 40 1 2 0   4     0   3   28 22                 50
735931 735931 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_9 146 5 12 0   5     0   3   73 98                       171 146 5 12 0   5     0   3   73 98                 171
735932 735932 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_10 139 1 7 2   5     0   3   68 89                       157 139 1 7 2   5     0   3   68 89                 157
735933 735933 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_11 140 3 11 0   4     0   4   66 96                       162 140 3 11 0   4     0   4   66 96                 162
735934 735934 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_12 146 1 8 1   1     0   5   77 85                       162 146 1 8 1   1     0   5   77 85                 162
735935 735935 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   SP 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
736074 736074 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   kindergarten 18 0 2 0   0     0   0   14 6                       20 18 0 2 0   0     0   0   14 6                 20
736075 736075 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   pre_kindergarten 17 1 2 0   0     0   2   16 6                       22 17 1 2 0   0     0   2   16 6                 22
736076 736076 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_1 23 0 2 0   1     0   0   15 11                       26 23 0 2 0   1     0   0   15 11                 26
736077 736077 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_2 25 0 1 0   0     0   1   13 14                       27 25 0 1 0   0     0   1   13 14                 27
736078 736078 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_3 31 0 0 0   2     0   3   23 13                       36 31 0 0 0   2     0   3   23 13                 36
736079 736079 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_4 25 0 1 0   0     0   0   15 11                       26 25 0 1 0   0     0   0   15 11                 26
736080 736080 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_5 28 0 0 0   0     0   1   19 10                       29 28 0 0 0   0     0   1   19 10                 29
736991 736991 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   kindergarten 29 1 1 0   4     0   1   15 21                       36 29 1 1 0   4     0   1   15 21                 36
736992 736992 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 5 0 0 0   3     0   0   2 6                       8 5 0 0 0   3     0   0   2 6                 8
736993 736993 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   grade_1 34 0 1 0   1     0   1   19 18                       37 34 0 1 0   1     0   1   19 18                 37
736994 736994 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   grade_2 42 2 0 0   3     0   2   22 27                       49 42 2 0 0   3     0   2   22 27                 49
736995 736995 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   grade_3 50 2 2 0   1     0   0   28 27                       55 50 2 2 0   1     0   0   28 27                 55
736996 736996 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   grade_4 49 1 1 0   2     0   0   29 24                       53 49 1 1 0   2     0   0   29 24                 53
736997 736997 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   grade_5 54 1 2 0   2     0   0   31 28                       59 54 1 2 0   2     0   0   31 28                 59
737177 737177 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   kindergarten 36 0 4 0   0     0   2   22 20                       42 36 0 4 0   0     0   2   22 20                 42
737178 737178 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 32 0 1 0   0     0   1   17 17                       34 32 0 1 0   0     0   1   17 17                 34
737179 737179 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_1 31 0 4 0   0     0   2   15 22                       37 31 0 4 0   0     0   2   15 22                 37
737180 737180 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_2 32 0 3 0   0     0   4   21 18                       39 32 0 3 0   0     0   4   21 18                 39
737181 737181 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_3 39 0 1 0   0     0   1   24 17                       41 39 0 1 0   0     0   1   24 17                 41
737182 737182 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_4 44 0 4 0   0     0   2   25 25                       50 44 0 4 0   0     0   2   25 25                 50
737183 737183 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_5 44 0 1 0   0     0   2   25 22                       47 44 0 1 0   0     0   2   25 22                 47
737184 737184 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 39 1 2 0   0     0   1   18 25                       43 39 1 2 0   0     0   1   18 25                 43
737609 737609 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2015   kindergarten 112 5 33 0   1     0   2   83 70                       153 112 5 33 0   1     0   2   83 70                 153
737610 737610 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2015   pre_kindergarten 72 2 18 0   3     0   0   49 46                       95 72 2 18 0   3     0   0   49 46                 95
737611 737611 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2015   grade_1 148 5 32 0   3     0   4   109 83                       192 148 5 32 0   3     0   4   109 83                 192
737612 737612 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2015   grade_2 118 8 30 0   2     0   3   89 72                       161 118 8 30 0   2     0   3   89 72                 161
737613 737613 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2015   grade_3 112 2 35 0   1     0   0   77 73                       150 112 2 35 0   1     0   0   77 73                 150
737614 737614 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_4 101 3 24 0   0     0   1   69 60                       129 101 3 24 0   0     0   1   69 60                 129
737615 737615 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_5 86 3 25 0   3     0   4   64 57                       121 86 3 25 0   3     0   4   64 57                 121
737616 737616 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_6 101 9 27 0   2     0   3   72 70                       142 101 9 27 0   2     0   3   72 70                 142
737617 737617 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_7 87 7 31 1   1     0   2   73 56                       129 87 7 31 1   1     0   2   73 56                 129
737618 737618 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_8 97 4 31 0   4     0   0   61 75                       136 97 4 31 0   4     0   0   61 75                 136
737619 737619 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   pre_kindergarten 16 1 9 0   0     0   1   11 16                       27 16 1 9 0   0     0   1   11 16                 27
737620 737620 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   grade_9 69 4 42 1   1     0   3   56 64                       120 69 4 42 1   1     0   3   56 64                 120
737621 737621 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   grade_10 69 5 31 0   4     0   2   67 44                       111 69 5 31 0   4     0   2   67 44                 111
737622 737622 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   grade_11 61 6 29 0   3     0   0   48 51                       99 61 6 29 0   3     0   0   48 51                 99
737623 737623 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   grade_12 65 7 23 0   3     0   1   61 38                       99 65 7 23 0   3     0   1   61 38                 99
737624 737624 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             2                                             2
737774 737774 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   kindergarten 84 0 0 0   2     0   1   46 41                       87 84 0 0 0   2     0   1   46 41                 87
737775 737775 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   pre_kindergarten 64 0 2 0   0     0   1   31 36                       67 64 0 2 0   0     0   1   31 36                 67
737776 737776 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   grade_1 78 0 0 0   1     0   3   44 38                       82 78 0 0 0   1     0   3   44 38                 82
737777 737777 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_2 99 1 2 1   4     0   3   46 64                       110 99 1 2 1   4     0   3   46 64                 110
737778 737778 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_3 122 1 4 0   2     0   5   80 54                       134 122 1 4 0   2     0   5   80 54                 134
737779 737779 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_4 90 0 7 0   4     0   2   50 53                       103 90 0 7 0   4     0   2   50 53                 103
737780 737780 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_5 124 1 3 0   3     1   2   72 62                       134 124 1 3 0   3     1   2   72 62                 134
737781 737781 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_6 129 2 2 0   0     1   2   67 69                       136 129 2 2 0   0     1   2   67 69                 136
737782 737782 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_7 140 0 2 0   3     1   4   65 85                       150 140 0 2 0   3     1   4   65 85                 150
737783 737783 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_8 131 0 1 0   0     0   0   70 62                       132 131 0 1 0   0     0   0   70 62                 132
737784 737784 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_9 99 0 2 0   0     0   0   52 49                       101 99 0 2 0   0     0   0   52 49                 101
737785 737785 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_10 105 1 3 0   1     0   1   48 63                       111 105 1 3 0   1     0   1   48 63                 111
737786 737786 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_11 91 0 2 0   0     0   1   49 45                       94 91 0 2 0   0     0   1   49 45                 94
737787 737787 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_12 101 0 1 0   1     0   0   49 54                       103 101 0 1 0   1     0   0   49 54                 103
738158 738158 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   kindergarten 37 2 58 0   1     0   10   59 49                       108 37 2 58 0   1     0   10   59 49                 108
738159 738159 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 46 6 44 0   5     0   4   60 45                       105 46 6 44 0   5     0   4   60 45                 105
738160 738160 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_1 31 7 54 0   4     0   6   53 49                       102 31 7 54 0   4     0   6   53 49                 102
738161 738161 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_2 31 3 49 0   2     0   12   44 53                       97 31 3 49 0   2     0   12   44 53                 97
738162 738162 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_3 22 1 57 1   1     0   7   52 37                       89 22 1 57 1   1     0   7   52 37                 89
738163 738163 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_4 31 6 51 0   4     0   8   50 50                       100 31 6 51 0   4     0   8   50 50                 100
738164 738164 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   kindergarten 50 5 53 0   6     0   13   63 64                       127 50 5 53 0   6     0   13   63 64                 127
738165 738165 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_1 52 8 48 0   4     1   11   62 62                       124 52 8 48 0   4     1   11   62 62                 124
738166 738166 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_2 48 3 58 0   6     0   11   60 66                       126 48 3 58 0   6     0   11   60 66                 126
738167 738167 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_3 61 10 54 0   4     0   10   71 68                       139 61 10 54 0   4     0   10   71 68                 139
738168 738168 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_4 54 7 63 0   7     0   8   79 60                       139 54 7 63 0   7     0   8   79 60                 139
738169 738169 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_5 44 7 92 0   9     0   12   80 84                       164 44 7 92 0   9     0   12   80 84                 164
738170 738170 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_6 58 13 76 0   7     0   16   70 100                       170 58 13 76 0   7     0   16   70 100                 170
738171 738171 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_7 39 13 74 0   14     0   8   68 80                       148 39 13 74 0   14     0   8   68 80                 148
738172 738172 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_8 58 12 74 0   10     0   11   81 84                       165 58 12 74 0   10     0   11   81 84                 165
738173 738173 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   kindergarten 44 3 58 0   7     0   14   60 66                       126 44 3 58 0   7     0   14   60 66                 126
738174 738174 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 11 3 12 0   1     0   3   20 10                       30 11 3 12 0   1     0   3   20 10                 30
738175 738175 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_1 41 5 67 0   6     0   11   59 71                       130 41 5 67 0   6     0   11   59 71                 130
738176 738176 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_2 44 4 55 0   9     1   8   58 63                       121 44 4 55 0   9     1   8   58 63                 121
738177 738177 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_3 37 7 54 0   12     0   9   61 58                       119 37 7 54 0   12     0   9   61 58                 119
738178 738178 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_4 42 5 69 0   8     0   5   59 70                       129 42 5 69 0   8     0   5   59 70                 129
738179 738179 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_5 44 4 52 0   7     0   15   71 51                       122 44 4 52 0   7     0   15   71 51                 122
738180 738180 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_6 33 7 65 0   3     0   13   63 58                       121 33 7 65 0   3     0   13   63 58                 121
738181 738181 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_7 44 7 47 0   6     0   8   66 46                       112 44 7 47 0   6     0   8   66 46                 112
738182 738182 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_8 31 11 53 0   7     0   10   50 62                       112 31 11 53 0   7     0   10   50 62                 112
738183 738183 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   kindergarten 26 3 30 0   7     0   10   33 43                       76 26 3 30 0   7     0   10   33 43                 76
738184 738184 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   pre_kindergarten 4 2 5 0   0     0   0   6 5                       11 4 2 5 0   0     0   0   6 5                 11

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