enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2040934 2040934 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_6 23 17 99 0   9     0   1   79 70                       149.0 23 17 99 0   9     0   1   79 70                 149
2041746 2041746 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2019   grade_11 109 5 99 0   7     0   2   117 105                       222.0 109 5 99 0   7     0   2   117 105                 222
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2046115 2046115 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_8 11 16 99 0   1     0   3   66 64                       130.0 11 16 99 0   1     0   3   66 64                 130
2047196 2047196 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 311 107 99 4   9     0   21   261 290                       551.0 311 107 99 4   9     0   21   261 290                 551
2041006 2041006 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_10 98 72 98 1   84     1   8   156 206                       362.0 98 72 98 1   84     1   8   156 206                 362
2047931 2047931 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_6 3 133 98 1   3     0   1   121 118                       239.0 3 133 98 1   3     0   1   121 118                 239
2040954 2040954 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_11 12 68 97 1   21     0   4   125 78                       203.0 12 68 97 1   21     0   4   125 78                 203
2041659 2041659 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_5 5 9 97 0   3     0   3   68 49                       117.0 5 9 97 0   3     0   3   68 49                 117
2042100 2042100 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 44 36 97 0   13     0   4   114 80                       194.0 44 36 97 0   13     0   4   114 80                 194
2043230 2043230 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No High 09 12 2019   grade_10 151 29 97 0   9     0   9   137 158                       295.0 151 29 97 0   9     0   9   137 158                 295
2044403 2044403 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_8 119 40 97 1   2     1   14   131 143                       274.0 119 40 97 1   2     1   14   131 143                 274
2045817 2045817 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2019   grade_1 62 4 97 0   0     0   2   77 88                       165.0 62 4 97 0   0     0   2   77 88                 165
2046102 2046102 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_8 3 16 97 0   0     0   0   51 65                       116.0 3 16 97 0   0     0   0   51 65                 116
2047930 2047930 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_5 4 120 97 1   0     1   0   115 108                       223.0 4 120 97 1   0     1   0   115 108                 223
2040974 2040974 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2019   grade_9 3 63 96 1   1     0   1   110 55                       165.0 3 63 96 1   1     0   1   110 55                 165
2043095 2043095 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_4 3 0 96 0   0     0   0   54 45                       99.0 3 0 96 0   0     0   0   54 45                 99
2044089 2044089 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_3 191 13 96 2   10     0   14   169 157                       326.0 191 13 96 2   10     0   14   169 157                 326
2046375 2046375 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_9 334 86 96 1   10     0   22   271 278                       549.0 334 86 96 1   10     0   22   271 278                 549
2047627 2047627 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_7 4 20 96 0   1     0   1   60 62                       122.0 4 20 96 0   1     0   1   60 62                 122
2042793 2042793 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_7 109 10 95 1   3     0   1   124 95                       219.0 109 10 95 1   3     0   1   124 95                 219
2043078 2043078 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2019   grade_1 1 2 95 0   1     0   0   55 44                       99.0 1 2 95 0   1     0   0   55 44                 99
2043237 2043237 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2019   grade_9 104 20 95 0   9     0   7   167 68                       235.0 104 20 95 0   9     0   7   167 68                 235
2044091 2044091 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_5 190 11 95 8   11     0   14   178 151                       329.0 190 11 95 8   11     0   14   178 151                 329
2047932 2047932 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_7 1 134 95 1   4     1   2   134 104                       238.0 1 134 95 1   4     1   2   134 104                 238
2049193 2049193 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2019   grade_9 92 8 95 5   2     0   7   128 81                       209.0 92 8 95 5   2     0   7   128 81                 209
2041742 2041742 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_7 123 12 94 0   5     0   10   137 107                       244.0 123 12 94 0   5     0   10   137 107                 244
2045497 2045497 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2019   grade_7 95 18 94 0   8     0   10   117 108                       225.0 95 18 94 0   8     0   10   117 108                 225
2046072 2046072 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2019   grade_8 22 56 94 2   6     0   1   103 78                       181.0 22 56 94 2   6     0   1   103 78                 181
2049216 2049216 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2019   grade_12 171 11 94 0   8     0   5   145 144                       289.0 171 11 94 0   8     0   5   145 144                 289
2042420 2042420 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   kindergarten 17 5 93 0   0     0   6   53 68                       121.0 17 5 93 0   0     0   6   53 68                 121
2042421 2042421 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_1 19 3 93 0   1     0   4   49 71                       120.0 19 3 93 0   1     0   4   49 71                 120
2043044 2043044 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No Elementary PK KG 2019   pre_kindergarten 7 2 93 0   1     0   0   60 43                       103.0 7 2 93 0   1     0   0   60 43                 103
2043054 2043054 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   kindergarten 5 0 93 0   0     0   0   54 44                       98.0 5 0 93 0   0     0   0   54 44                 98
2043094 2043094 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_3 4 1 93 0   0     0   0   51 47                       98.0 4 1 93 0   0     0   0   51 47                 98
2043097 2043097 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_1 2 1 93 0   0     0   0   47 49                       96.0 2 1 93 0   0     0   0   47 49                 96
2044090 2044090 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_4 199 13 93 9   3     1   18   179 157                       336.0 199 13 93 9   3     1   18   179 157                 336
2044096 2044096 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_10 185 13 93 7   5     0   11   163 151                       314.0 185 13 93 7   5     0   11   163 151                 314
2045368 2045368 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2019   grade_5 31 7 93 0   2     0   4   74 63                       137.0 31 7 93 0   2     0   4   74 63                 137
2046578 2046578 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2019   grade_8 81 19 93 0   6     0   5   102 102                       204.0 81 19 93 0   6     0   5   102 102                 204
2047621 2047621 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   kindergarten 10 14 93 0   2     2   1   52 70                       122.0 10 14 93 0   2     2   1   52 70                 122
2042328 2042328 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_7 52 9 92 0   13     0   7   79 94                       173.0 52 9 92 0   13     0   7   79 94                 173
2042338 2042338 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2019   grade_7 35 12 92 0   7     0   10   87 69                       156.0 35 12 92 0   7     0   10   87 69                 156
2046101 2046101 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_7 7 17 92 0   0     0   0   55 61                       116.0 7 17 92 0   0     0   0   55 61                 116
2043130 2043130 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_9 32 14 912 0   9     0   2   543 420                       969.0 32 14 912 0   9     0   2   543 420                 969
2043063 2043063 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_5 2 1 91 0   2     0   0   47 49                       96.0 2 1 91 0   2     0   0   47 49                 96
2043072 2043072 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2019   grade_1 8 0 91 0   6     0   1   55 51                       106.0 8 0 91 0   6     0   1   55 51                 106
2043093 2043093 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_2 4 0 91 0   0     0   0   42 53                       95.0 4 0 91 0   0     0   0   42 53                 95
2043596 2043596 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2019   grade_3 6 7 91 1   9     0   2   62 54                       116.0 6 7 91 1   9     0   2   62 54                 116
2045496 2045496 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2019   grade_6 101 16 91 0   6     0   9   122 101                       223.0 101 16 91 0   6     0   9   122 101                 223
2046070 2046070 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2019   grade_6 30 51 91 0   4     0   7   93 90                       183.0 30 51 91 0   4     0   7   93 90                 183
2047933 2047933 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_8 4 153 91 0   1     1   0   119 131                       250.0 4 153 91 0   1     1   0   119 131                 250
2040453 2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
2041642 2041642 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_1 3 9 90 0   3     0   1   53 53                       106.0 3 9 90 0   3     0   1   53 53                 106
2043100 2043100 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_4 6 0 90 0   1     0   0   56 41                       97.0 6 0 90 0   1     0   0   56 41                 97
2045501 2045501 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2019   grade_11 101 24 90 0   5     0   7   119 108                       227.0 101 24 90 0   5     0   7   119 108                 227
2045914 2045914 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2019   grade_2 6 22 90 0   0     0   2   60 60                       120.0 6 22 90 0   0     0   2   60 60                 120
2047469 2047469 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2019   grade_12 71 50 90 1   18     0   14   130 114                       244.0 71 50 90 1   18     0   14   130 114                 244
2047628 2047628 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_8 8 19 90 0   2     0   3   70 52                       122.0 8 19 90 0   2     0   3   70 52                 122
2049186 2049186 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2019   grade_11 386 49 90 1   4     0   21   293 258                       551.0 386 49 90 1   4     0   21   293 258                 551
2039810 2039810 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 71 9 9 0   1     0   0   45 45                       90.0 71 9 9 0   1     0   0   45 45                 90
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2039823 2039823 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_12 90 4 9 0   3     1   0   48 59                       107.0 90 4 9 0   3     1   0   48 59                 107
2039839 2039839 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2019   grade_3 36 1 9 0   0     0   2   23 25                       48.0 36 1 9 0   0     0   2   23 25                 48
2039847 2039847 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No Elementary KG 04 2019   grade_1 53 4 9 0   3     0   2   37 34                       71.0 53 4 9 0   3     0   2   37 34                 71
2039878 2039878 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_6 132 3 9 0   2     1   4   71 80                       151.0 132 3 9 0   2     1   4   71 80                 151
2039890 2039890 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 18 7 9 0   11     0   3   29 19                       48.0 18 7 9 0   11     0   3   29 19                 48
2039893 2039893 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_2 19 3 9 0   5     0   7   23 20                       43.0 19 3 9 0   5     0   7   23 20                 43
2039899 2039899 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_1 14 2 9 0   5     0   3   12 21                       33.0 14 2 9 0   5     0   3   12 21                 33
2039912 2039912 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   kindergarten 62 0 9 0   6     0   9   41 45                       86.0 62 0 9 0   6     0   9   41 45                 86
2039946 2039946 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_6 124 4 9 0   27     0   7   95 76                       171.0 124 4 9 0   27     0   7   95 76                 171
2039988 2039988 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   kindergarten 53 3 9 0   11     0   13   50 39                       89.0 53 3 9 0   11     0   13   50 39                 89
2040037 2040037 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2019   kindergarten 64 4 9 0   5     0   7   42 47                       89.0 64 4 9 0   5     0   7   42 47                 89
2040067 2040067 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   kindergarten 70 0 9 0   6     0   5   52 38                       90.0 70 0 9 0   6     0   5   52 38                 90
2040082 2040082 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_10 158 3 9 1   8     0   5   83 101                       184.0 158 3 9 1   8     0   5   83 101                 184
2040130 2040130 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_2 126 13 9 0   34     0   15   100 97                       197.0 126 13 9 0   34     0   15   100 97                 197
2040154 2040154 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_11 153 2 9 0   2     0   1   88 79                       167.0 153 2 9 0   2     0   1   88 79                 167
2040173 2040173 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_11 126 1 9 1   4     0   3   66 78                       144.0 126 1 9 1   4     0   3   66 78                 144
2040229 2040229 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 04 2019   grade_2 51 6 9 0   1     0   1   34 34                       68.0 51 6 9 0   1     0   1   34 34                 68
2040249 2040249 MA Essex   school 2502640 30   Beverly 250264000175 300055 Ayers/Ryal Side School   Regular School No Elementary KG 04 2019   grade_2 56 2 9 0   2     0   3   35 37                       72.0 56 2 9 0   2     0   3   35 37                 72
2040279 2040279 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2019   kindergarten 50 3 9 0   11     0   5   45 33                       78.0 50 3 9 0   11     0   5   45 33                 78
2040280 2040280 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2019   grade_1 56 6 9 0   13     0   3   41 46                       87.0 56 6 9 0   13     0   3   41 46                 87
2040304 2040304 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   grade_9 242 20 9 1   26     0   6   159 145                       304.0 242 20 9 1   26     0   6   159 145                 304
2040341 2040341 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   kindergarten 9 2 9 0   0     0   2   15 7                       22.0 9 2 9 0   0     0   2   15 7                 22
2040415 2040415 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   kindergarten 5 0 9 0   0     0   1   5 10                       15.0 5 0 9 0   0     0   1   5 10                 15
2040456 2040456 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2019   kindergarten 4 20 9 0   9     0   1   22 21                       43.0 4 20 9 0   9     0   1   22 21                 43
2040491 2040491 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2019   grade_1 3 6 9 0   0     0   1   13 6                       19.0 3 6 9 0   0     0   1   13 6                 19
2040540 2040540 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2019   grade_3 2 27 9 0   1     0   0   22 17                       39.0 2 27 9 0   1     0   0   22 17                 39
2040584 2040584 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2019   grade_2 5 10 9 0   3     0   4   20 11                       31.0 5 10 9 0   3     0   4   20 11                 31
2040624 2040624 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_8 12 7 9 0   0     0   0   11 17                       28.0 12 7 9 0   0     0   0   11 17                 28
2040639 2040639 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2019   pre_kindergarten 6 18 9 1   25     0   3   26 36                       62.0 6 18 9 1   25     0   3   26 36                 62
2040660 2040660 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2019   grade_3 4 14 9 0   0     0   2   13 16                       29.0 4 14 9 0   0     0   2   13 16                 29
2040686 2040686 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2019   grade_5 0 10 9 0   1     0   3   7 16                       23.0 0 10 9 0   1     0   3   7 16                 23
2040713 2040713 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   pre_kindergarten 43 3 9 0   5     0   6   34 32                       66.0 43 3 9 0   5     0   6   34 32                 66
2040758 2040758 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2019   grade_3 6 11 9 0   2     0   1   15 14                       29.0 6 11 9 0   2     0   1   15 14                 29
2040798 2040798 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2019   grade_2 8 9 9 0   7     0   3   19 17                       36.0 8 9 9 0   7     0   3   19 17                 36
2040817 2040817 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2019   grade_4 2 12 9 0   1     1   1   10 16                       26.0 2 12 9 0   1     1   1   10 16                 26
2040830 2040830 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   sped_beyond_grade_12 1 15 9 0   2     0   2                             29.0 1 15 9 0   2     0   2                       29
2040885 2040885 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_2 2 27 9 0   0     0   3   16 25                       41.0 2 27 9 0   0     0   3   16 25                 41
2040886 2040886 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_3 0 36 9 0   1     0   1   20 27                       47.0 0 36 9 0   1     0   1   20 27                 47

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