Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by multiracial_int descending

View and edit SQL

grade

year

  • 2015 · 9,541
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
737264 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_9 288 37 50 0   70     0   49   259 235                       494 288 37 50 0   70     0   49   259 235                 494
737267 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_12 281 28 45 0   78     0   41   232 241                       473 281 28 45 0   78     0   41   232 241                 473
737164 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_9 206 707 159 6   31     2   35   624 522                       1146 206 707 159 6   31     2   35   624 522                 1146
737265 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_10 280 41 46 0   78     0   33   222 256                       478 280 41 46 0   78     0   33   222 256                 478
740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
740278 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_12 183 71 105 1   10     4   32   200 206                       406 183 71 105 1   10     4   32   200 206                 406
741994 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_9 78 135 293 0   27     0   32   293 272                       565 78 135 293 0   27     0   32   293 272                 565
740277 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_11 226 61 151 6   2     6   31   271 212                       483 226 61 151 6   2     6   31   271 212                 483
740410 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_10 333 21 50 0   64     0   30   227 271                       498 333 21 50 0   64     0   30   227 271                 498
737266 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_11 257 37 48 0   60     0   29   218 213                       431 257 37 48 0   60     0   29   218 213                 431
742470 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   kindergarten 175 19 11 3   2     0   28   129 109                       238 175 19 11 3   2     0   28   129 109                 238
743365 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2015   grade_7 241 52 143 0   24     0   28   267 221                       488 241 52 143 0   24     0   28   267 221                 488
736061 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2015   grade_10 213 14 8 0   42     0   27   132 172                       304 213 14 8 0   42     0   27   132 172                 304
740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
742248 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_8 448 75 73 1   16     3   27   346 297                       643 448 75 73 1   16     3   27   346 297                 643
740412 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_12 324 28 31 1   47     0   26   233 224                       457 324 28 31 1   47     0   26   233 224                 457
743366 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2015   grade_8 229 54 108 0   26     0   26   213 230                       443 229 54 108 0   26     0   26   213 230                 443
743967 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_9 294 7 13 2   115     0   26   229 228                       457 294 7 13 2   115     0   26   229 228                 457
737165 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_10 220 623 140 4   27     3   25   503 539                       1042 220 623 140 4   27     3   25   503 539                 1042
739163 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_9 317 18 25 1   169     0   25   295 260                       555 317 18 25 1   169     0   25   295 260                 555
742478 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_7 152 19 13 3   3     0   25   110 105                       215 152 19 13 3   3     0   25   110 105                 215
742603 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2015   grade_6 320 14 21 0   43     0   25   227 196                       423 320 14 21 0   43     0   25   227 196                 423
735968 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2015   grade_4 302 22 35 1   4     1   24   184 205                       389 302 22 35 1   4     1   24   184 205                 389
740266 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_6 128 48 95 2   4     2   24   159 144                       303 128 48 95 2   4     2   24   159 144                 303
735851 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2015   grade_8 266 18 21 0   41     0   23   169 200                       369 266 18 21 0   41     0   23   169 200                 369
737077 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No 1 KG KG 2015   kindergarten 52 123 32 3   3     0   23   129 107                       236 52 123 32 3   3     0   23   129 107                 236
737166 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_11 231 627 106 3   26     0   23   530 486                       1016 231 627 106 3   26     0   23   530 486                 1016
739165 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_11 301 27 19 0   161     0   23   270 261                       531 301 27 19 0   161     0   23   270 261                 531
739522 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_9 93 52 313 0   25     0   23   293 213                       506 93 52 313 0   25     0   23   293 213                 506
740411 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_11 367 32 45 0   51     0   23   258 260                       518 367 32 45 0   51     0   23   258 260                 518
740415 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_10 281 26 33 0   91     0   23   227 227                       454 281 26 33 0   91     0   23   227 227                 454
742471 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   grade_1 169 20 8 6   2     0   23   101 127                       228 169 20 8 6   2     0   23   101 127                 228
743993 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   grade_9 150 15 32 0   24     0   23   139 105                       244 150 15 32 0   24     0   23   139 105                 244
745065 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 366 55 107 2   3     0   23   247 309                       556 366 55 107 2   3     0   23   247 309                 556
736056 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_5 240 9 14 0   54     0   22   165 174                       339 240 9 14 0   54     0   22   165 174                 339
738357 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   kindergarten 149 7 25 1   0     0   22   113 91                       204 149 7 25 1   0     0   22   113 91                 204
739607 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_10 123 98 94 1   102     1   22   223 218                       441 123 98 94 1   102     1   22   223 218                 441
740404 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No 2 06 08 2015   grade_7 220 20 32 0   49     0   22   175 168                       343 220 20 32 0   49     0   22   175 168                 343
742479 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_8 142 13 9 1   2     0   22   108 81                       189 142 13 9 1   2     0   22   108 81                 189
742755 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No 3 09 12 2015   grade_11 314 0 4 0   71     0   22   211 200                       411 314 0 4 0   71     0   22   211 200                 411
742919 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_5 389 36 30 0   18     1   22   262 234                       496 389 36 30 0   18     1   22   262 234                 496
745084 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_12 257 1 39 0   5     0   22   170 154                       324 257 1 39 0   5     0   22   170 154                 324
736057 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_6 229 12 12 0   57     0   21   164 167                       331 229 12 12 0   57     0   21   164 167                 331
740416 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_11 303 22 32 1   81     0   21   242 218                       460 303 22 32 1   81     0   21   242 218                 460
742489 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No 3 09 12 2015   grade_9 102 12 15 2   2     0   21   78 76                       154 102 12 15 2   2     0   21   78 76                 154
743996 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   grade_12 152 27 43 0   20     0   21   138 125                       263 152 27 43 0   20     0   21   138 125                 263
735972 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_8 316 22 13 4   21     2   20   197 201                       398 316 22 13 4   21     2   20   197 201                 398
738150 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_6 242 10 8 4   6     0   20   141 149                       290 242 10 8 4   6     0   20   141 149                 290
738352 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 03 05 2015   grade_4 120 1 28 0   2     0   20   84 87                       171 120 1 28 0   2     0   20   84 87                 171
738353 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 03 05 2015   grade_5 140 6 24 1   3     0   20   111 83                       194 140 6 24 1   3     0   20   111 83                 194
739708 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 28 0 5 0   0     0   20   31 22                       53 28 0 5 0   0     0   20   31 22                 53
741997 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_12 90 102 211 0   48     0   20   239 232                       471 90 102 211 0   48     0   20   239 232                 471
742135 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No 2 06 08 2015   grade_8 297 12 9 0   18     1   20   184 173                       357 297 12 9 0   18     1   20   184 173                 357
742605 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2015   grade_8 276 19 17 0   40     0   20   167 205                       372 276 19 17 0   40     0   20   167 205                 372
742606 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No 3 09 12 2015   grade_9 286 31 20 0   51     1   20   198 211                       409 286 31 20 0   51     1   20   198 211                 409
743372 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2015   grade_8 100 71 145 3   54     0   20   202 191                       393 100 71 145 3   54     0   20   202 191                 393
743992 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No 2 07 08 2015   grade_8 142 14 38 1   25     0   20   125 115                       240 142 14 38 1   25     0   20   125 115                 240
743994 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   grade_10 147 23 22 0   24     0   20   120 116                       236 147 23 22 0   24     0   20   120 116                 236
745069 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 250 17 156 4   89     0   20   268 268                       536 250 17 156 4   89     0   20   268 268                 536
745082 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 299 2 56 0   2     0   20   208 171                       379 299 2 56 0   2     0   20   208 171                 379
735875 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No 1 PK PK 2015   pre_kindergarten 137 3 23 0   12     0   19   121 73                       194 137 3 23 0   12     0   19   121 73                 194
735910 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_11 324 26 56 3   23     1   19   241 211                       452 324 26 56 3   23     1   19   241 211                 452
738123 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_9 376 59 148 1   36     2   19   344 297                       641 376 59 148 1   36     2   19   344 297                 641
739164 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_10 280 23 18 1   177     0   19   251 267                       518 280 23 18 1   177     0   19   251 267                 518
740409 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_9 368 25 44 0   81     2   19   275 264                       539 368 25 44 0   81     2   19   275 264                 539
741017 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No 2 06 08 2015   grade_6 269 7 11 1   5     0   19   150 162                       312 269 7 11 1   5     0   19   150 162                 312
742476 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No 2 05 08 2015   grade_5 151 16 7 2   1     0   19   96 100                       196 151 16 7 2   1     0   19   96 100                 196
742492 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No 3 09 12 2015   grade_12 85 7 8 0   0     0   19   55 64                       119 85 7 8 0   0     0   19   55 64                 119
742754 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No 3 09 12 2015   grade_10 305 4 4 0   73     0   19   201 204                       405 305 4 4 0   73     0   19   201 204                 405
745056 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 311 2 23 1   7     0   19   228 135                       363 311 2 23 1   7     0   19   228 135                 363
735908 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_9 310 30 48 3   22     2   18   224 209                       433 310 30 48 3   22     2   18   224 209                 433
735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
736063 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2015   grade_12 191 14 9 0   47     0   18   134 145                       279 191 14 9 0   47     0   18   134 145                 279
736404 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No 1 PK 05 2015   grade_1 1 66 51 1   4     0   18   79 62                       141 1 66 51 1   4     0   18   79 62                 141
737401 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_9 185 172 64 4   56     0   18   270 229                       499 185 172 64 4   56     0   18   270 229                 499
738149 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_5 236 8 14 3   6     0   18   156 129                       285 236 8 14 3   6     0   18   156 129                 285
738151 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2015   grade_7 247 14 9 1   7     0   18   152 144                       296 247 14 9 1   7     0   18   152 144                 296
738153 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_9 186 8 10 1   6     1   18   114 116                       230 186 8 10 1   6     1   18   114 116                 230
739518 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2015   grade_10 80 51 220 0   37     1   18   222 185                       407 80 51 220 0   37     1   18   222 185                 407
740098 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2015   grade_11 316 8 12 0   26     0   18   188 192                       380 316 8 12 0   26     0   18   188 192                 380
740133 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No 2 06 06 2015   grade_6 370 7 18 0   34     0   18   225 222                       447 370 7 18 0   34     0   18   225 222                 447
740414 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_9 299 16 24 0   87     0   18   212 232                       444 299 16 24 0   87     0   18   212 232                 444
741995 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_10 78 139 263 0   32     0   18   278 252                       530 78 139 263 0   32     0   18   278 252                 530
742029 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2015   grade_9 38 81 194 0   6     0   18   147 190                       337 38 81 194 0   6     0   18   147 190                 337
742251 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_11 320 48 52 3   4     2   18   213 234                       447 320 48 52 3   4     2   18   213 234                 447
742252 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_12 269 39 39 0   4     1   18   206 164                       370 269 39 39 0   4     1   18   206 164                 370
742632 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2015   grade_5 184 2 23 0   77     0   18   152 152                       304 184 2 23 0   77     0   18   152 152                 304
742883 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 07 08 2015   grade_8 411 22 25 1   15     0   18   270 222                       492 411 22 25 1   15     0   18   270 222                 492
743966 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2015   grade_8 284 4 16 0   157     0   18   260 219                       479 284 4 16 0   157     0   18   260 219                 479
743991 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No 2 07 08 2015   grade_7 138 11 31 1   21     1   18   110 111                       221 138 11 31 1   21     1   18   110 111                 221
743995 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   grade_11 151 16 27 0   21     0   18   126 107                       233 151 16 27 0   21     0   18   126 107                 233
744113 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No 1 PK 03 2015   grade_2 211 8 10 0   4     0   18   120 131                       251 211 8 10 0   4     0   18   120 131                 251
744200 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_8 169 19 21 2   8     0   18   111 126                       237 169 19 21 2   8     0   18   111 126                 237
745064 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 373 48 125 0   4     0   18   295 273                       568 373 48 125 0   4     0   18   295 273                 568
735969 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2015   grade_5 299 29 29 2   7     0   17   186 197                       383 299 29 29 2   7     0   17   186 197                 383
736060 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No 3 09 12 2015   grade_9 244 16 9 0   53     2   17   172 169                       341 244 16 9 0   53     2   17   172 169                 341
736874 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_7 202 29 55 0   103     0   17   183 223                       406 202 29 55 0   103     0   17   183 223                 406
737106 MA Plymouth   school 2503090 44   Brockton 250309000221 440050 Gilmore School Early Childhood Center   Regular School No 1 PK KG 2015   pre_kindergarten 95 87 39 1   7     0   17   158 88                       246 95 87 39 1   7     0   17   158 88                 246
737167 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_12 219 572 101 4   25     0   17   445 493                       938 219 572 101 4   25     0   17   445 493                 938
738041 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_2 63 9 32 0   6     0   17   63 64                       127 63 9 32 0   6     0   17   63 64                 127

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