enrollments

Data source: Big Local News · About: Big Local

887 rows where grade = "grade_5", state = "MA" and year = 2016 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 887 ✖

grade ✖

  • grade_5 · 887 ✖
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
933991 933991 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 05 2016   grade_5 9 95 16 1   5     0   5   70 61                       131 9 95 16 1   5     0   5   70 61                 131
933382 933382 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2016   grade_5 1 9 8 0   1     0   0   8 11                       19 1 9 8 0   1     0   0   8 11                 19
933389 933389 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   grade_5 4 9 5 0   4     0   0   12 10                       22 4 9 5 0   4     0   0   12 10                 22
933413 933413 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_5 15 9 6 0   1     0   0   16 15                       31 15 9 6 0   1     0   0   16 15                 31
933503 933503 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_5 0 9 27 0   1     0   0   17 20                       37 0 9 27 0   1     0   0   17 20                 37
933892 933892 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No 1 KG 05 2016   grade_5 48 9 0 0   8     0   2   35 32                       67 48 9 0 0   8     0   2   35 32                 67
933898 933898 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 KG 05 2016   grade_5 39 9 6 1   4     0   0   28 31                       59 39 9 6 1   4     0   0   28 31                 59
934052 934052 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_5 34 9 5 0   22     0   7   40 37                       77 34 9 5 0   22     0   7   40 37                 77
934185 934185 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2016   grade_5 20 9 5 0   3     0   2   16 23                       39 20 9 5 0   3     0   2   16 23                 39
934206 934206 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2016   grade_5 15 9 5 0   3     0   1   15 18                       33 15 9 5 0   3     0   1   15 18                 33
934890 934890 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   grade_5 86 9 26 0   4     0   7   74 58                       132 86 9 26 0   4     0   7   74 58                 132
934909 934909 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2016   grade_5 39 9 40 0   4     0   1   55 38                       93 39 9 40 0   4     0   1   55 38                 93
936796 936796 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_5 234 9 87 4   8     0   11   174 179                       353 234 9 87 4   8     0   11   174 179                 353
936936 936936 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No 2 05 08 2016   grade_5 181 9 15 0   13     0   20   122 116                       238 181 9 15 0   13     0   20   122 116                 238
937052 937052 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2016   grade_5 55 9 22 1   1     0   12   50 50                       100 55 9 22 1   1     0   12   50 50                 100
937059 937059 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2016   grade_5 18 9 21 1   0     0   1   29 21                       50 18 9 21 1   0     0   1   29 21                 50
937542 937542 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2016   grade_5 36 9 4 0   0     0   1   28 22                       50 36 9 4 0   0     0   1   28 22                 50
937729 937729 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No 1 KG 05 2016   grade_5 64 9 12 0   2     0   8   49 46                       95 64 9 12 0   2     0   8   49 46                 95
937949 937949 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No 2 05 08 2016   grade_5 45 9 9 0   19     0   2   45 39                       84 45 9 9 0   19     0   2   45 39                 84
938126 938126 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No 2 05 08 2016   grade_5 139 9 11 0   2     0   5   93 73                       166 139 9 11 0   2     0   5   93 73                 166
938600 938600 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No 1 KG 05 2016   grade_5 6 9 39 0   0     0   0   29 25                       54 6 9 39 0   0     0   0   29 25                 54
938606 938606 MA Hampden   school 2511130 281   Springfield 251113001807 2810050 Hiram L Dorman   Regular School No 1 KG 05 2016   grade_5 6 9 28 0   1     0   0   21 23                       44 6 9 28 0   1     0   0   21 23                 44
938654 938654 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2016   grade_5 11 9 14 0   0     0   1   15 20                       35 11 9 14 0   0     0   1   15 20                 35
938670 938670 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No 1 KG 05 2016   grade_5 4 9 38 0   5     0   0   25 31                       56 4 9 38 0   5     0   0   25 31                 56
938701 938701 MA Hampden   school 2511130 281   Springfield 251113001819 2810145 Mary O Pottenger   Regular School No 1 KG 05 2016   grade_5 13 9 44 0   3     0   0   35 34                       69 13 9 44 0   3     0   0   35 34                 69
938726 938726 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2016   grade_5 9 9 22 0   2     0   1   22 21                       43 9 9 22 0   2     0   1   22 21                 43
939161 939161 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No 2 05 08 2016   grade_5 211 9 20 0   7     0   6   141 112                       253 211 9 20 0   7     0   6   141 112                 253
940068 940068 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   grade_5 9 9 18 0   1     0   4   22 19                       41 9 9 18 0   1     0   4   22 19                 41
940082 940082 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2016   grade_5 40 9 10 0   2     0   2   31 32                       63 40 9 10 0   2     0   2   31 32                 63
933962 933962 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_5 17 86 11 0   0     1   10   59 66                       125 17 86 11 0   0     1   10   59 66                 125
932542 932542 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_5 157 8 3 0   2     0   3   83 90                       173 157 8 3 0   2     0   3   83 90                 173
932857 932857 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2016   grade_5 126 8 13 3   26     0   4   91 89                       180 126 8 13 3   26     0   4   91 89                 180
933513 933513 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   grade_5 7 8 23 0   2     1   1   24 18                       42 7 8 23 0   2     1   1   24 18                 42
933530 933530 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2016   grade_5 31 8 12 1   1     1   5   29 30                       59 31 8 12 1   1     1   5   29 30                 59
934199 934199 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2016   grade_5 8 8 4 0   6     0   3   11 18                       29 8 8 4 0   6     0   3   11 18                 29
934248 934248 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2016   grade_5 7 8 9 0   3     1   1   13 16                       29 7 8 9 0   3     1   1   13 16                 29
934368 934368 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2016   grade_5 9 8 95 2   2     0   2   64 54                       118 9 8 95 2   2     0   2   64 54                 118
935972 935972 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   grade_5 47 8 2 0   45     0   1   50 53                       103 47 8 2 0   45     0   1   50 53                 103
936024 936024 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2016   grade_5 43 8 7 1   1     0   1   30 31                       61 43 8 7 1   1     0   1   30 31                 61
936029 936029 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2016   grade_5 32 8 9 0   2     0   8   27 32                       59 32 8 9 0   2     0   8   27 32                 59
936178 936178 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2016   grade_5 40 8 34 0   34     0   6   70 52                       122 40 8 34 0   34     0   6   70 52                 122
937021 937021 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No 1 KG 05 2016   grade_5 17 8 19 0   0     0   0   23 21                       44 17 8 19 0   0     0   0   23 21                 44
937927 937927 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Snug Harbor Community School   Regular School No 1 PK 05 2016   grade_5 23 8 2 0   18     1   1   32 21                       53 23 8 2 0   18     1   1   32 21                 53
938548 938548 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No 1 KG 05 2016   grade_5 3 8 9 0   0     0   0   17 3                       20 3 8 9 0   0     0   0   17 3                 20
938581 938581 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   grade_5 0 8 33 0   0     0   0   10 31                       41 0 8 33 0   0     0   0   10 31                 41
938876 938876 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Helen Hansen Elementary   Regular School No 1 KG 05 2016   grade_5 27 8 9 0   2     0   0   19 27                       46 27 8 9 0   2     0   0   19 27                 46
939930 939930 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   grade_5 4 8 61 0   8     0   0   49 32                       81 4 8 61 0   8     0   0   49 32                 81
939999 939999 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2016   grade_5 16 8 28 1   4     0   3   26 34                       60 16 8 28 1   4     0   3   26 34                 60
940955 940955 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No 2 04 06 2016   grade_5 227 8 4 0   4     0   10   137 116                       253 227 8 4 0   4     0   10   137 116                 253
941975 941975 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Lowell Collegiate Charter School   Regular School Yes 1 KG 05 2016   grade_5 17 8 19 0   13     0   2   28 31                       59 17 8 19 0   13     0   2   28 31                 59
933931 933931 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_5 7 76 34 0   0     0   10   65 62                       127 7 76 34 0   0     0   10   65 62                 127
933979 933979 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_5 3 70 12 0   0     1   3   46 43                       89 3 70 12 0   0     1   3   46 43                 89
932582 932582 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_5 254 7 24 0   14     0   7   160 146                       306 254 7 24 0   14     0   7   160 146                 306
932772 932772 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_5 112 7 14 0   8     0   13   82 72                       154 112 7 14 0   8     0   13   82 72                 154
934272 934272 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No 1 KG 05 2016   grade_5 57 7 1 0   7     1   2   34 41                       75 57 7 1 0   7     1   2   34 41                 75
934372 934372 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2016   grade_5 7 7 136 1   1     0   2   91 63                       154 7 7 136 1   1     0   2   91 63                 154
934419 934419 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2016   grade_5 68 7 27 0   1     0   5   61 47                       108 68 7 27 0   1     0   5   61 47                 108
934747 934747 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No 1 03 05 2016   grade_5 86 7 6 0   6     0   0   58 47                       105 86 7 6 0   6     0   0   58 47                 105
934925 934925 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2016   grade_5 37 7 22 0   1     0   4   28 43                       71 37 7 22 0   1     0   4   28 43                 71
935140 935140 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_5 73 7 12 0   0     0   2   45 49                       94 73 7 12 0   0     0   2   45 49                 94
935424 935424 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2016   grade_5 109 7 25 0   3     0   2   79 67                       146 109 7 25 0   3     0   2   79 67                 146
935978 935978 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2016   grade_5 44 7 3 0   36     0   4   50 44                       94 44 7 3 0   36     0   4   50 44                 94
936355 936355 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2016   grade_5 4 7 45 1   4     0   2   35 28                       63 4 7 45 1   4     0   2   35 28                 63
936842 936842 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No 1 PK 05 2016   grade_5 96 7 3 0   5     0   1   59 53                       112 96 7 3 0   5     0   1   59 53                 112
937066 937066 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2016   grade_5 12 7 15 0   0     0   2   17 19                       36 12 7 15 0   0     0   2   17 19                 36
937723 937723 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No 1 KG 05 2016   grade_5 37 7 4 0   1     0   6   25 30                       55 37 7 4 0   1     0   6   25 30                 55
937750 937750 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No 1 PK 05 2016   grade_5 26 7 2 0   1     0   5   17 24                       41 26 7 2 0   1     0   5   17 24                 41
938080 938080 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No 1 PK 05 2016   grade_5 26 7 57 0   10     1   2   51 52                       103 26 7 57 0   10     1   2   51 52                 103
938435 938435 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2016   grade_5 22 7 7 0   1     0   1   21 17                       38 22 7 7 0   1     0   1   21 17                 38
938689 938689 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No 1 PK 05 2016   grade_5 6 7 19 0   5     0   0   16 21                       37 6 7 19 0   5     0   0   16 21                 37
939399 939399 MA Norfolk   school 2512270 317   Wellesley 251227002503 3170045 Schofield   Regular School No 1 KG 05 2016   grade_5 38 7 2 0   5     0   3   28 27                       55 38 7 2 0   5     0   3   28 27                 55
939991 939991 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2016   grade_5 39 7 7 0   0     0   5   22 36                       58 39 7 7 0   0     0   5   22 36                 58
940023 940023 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   grade_5 13 7 21 0   1     0   0   25 17                       42 13 7 21 0   1     0   0   25 17                 42
940233 940233 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 06 2016   grade_5 12 7 18 0   0     0   3   19 21                       40 12 7 18 0   0     0   3   19 21                 40
940723 940723 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_5 51 7 23 0   1     0   6   50 38                       88 51 7 23 0   1     0   6   50 38                 88
940626 940626 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_5 0 68 18 0   0     0   1   48 39                       87 0 68 18 0   0     0   1   48 39                 87
933937 933937 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2016   grade_5 36 65 25 2   3     0   9   81 59                       140 36 65 25 2   3     0   9   81 59                 140
933950 933950 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2016   grade_5 39 61 8 0   1     0   3   61 51                       112 39 61 8 0   1     0   3   61 51                 112
940671 940671 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_5 7 61 17 0   3     0   5   45 48                       93 7 61 17 0   3     0   5   45 48                 93
934000 934000 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2016   grade_5 31 60 17 0   1     0   7   62 54                       116 31 60 17 0   1     0   7   62 54                 116
932621 932621 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2016   grade_5 27 6 11 0   9     0   2   30 25                       55 27 6 11 0   9     0   2   30 25                 55
932635 932635 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_5 28 6 9 0   9     0   6   28 30                       58 28 6 9 0   9     0   6   28 30                 58
932712 932712 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2016   grade_5 25 6 1 0   3     0   4   19 20                       39 25 6 1 0   3     0   4   19 20                 39
932738 932738 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No 1 03 05 2016   grade_5 138 6 16 2   29     0   6   102 95                       197 138 6 16 2   29     0   6   102 95                 197
933328 933328 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2016   grade_5 11 6 7 0   1     0   1   18 8                       26 11 6 7 0   1     0   1   18 8                 26
933373 933373 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   grade_5 2 6 26 0   0     0   0   16 18                       34 2 6 26 0   0     0   0   16 18                 34
933641 933641 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   grade_5 3 6 61 0   1     0   0   34 37                       71 3 6 61 0   1     0   0   34 37                 71
934061 934061 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_5 54 6 8 0   7     0   13   50 38                       88 54 6 8 0   7     0   13   50 38                 88
934071 934071 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   grade_5 40 6 3 0   14     0   9   42 30                       72 40 6 3 0   14     0   9   42 30                 72
934376 934376 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2016   grade_5 10 6 110 0   3     0   0   63 66                       129 10 6 110 0   3     0   0   63 66                 129
934475 934475 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_5 101 6 24 0   1     0   0   75 57                       132 101 6 24 0   1     0   0   75 57                 132
934504 934504 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2016   grade_5 58 6 2 0   4     0   1   38 33                       71 58 6 2 0   4     0   1   38 33                 71
934670 934670 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2016   grade_5 55 6 8 0   10     0   0   47 32                       79 55 6 8 0   10     0   0   47 32                 79
935116 935116 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2016   grade_5 29 6 71 0   1     0   2   51 58                       109 29 6 71 0   1     0   2   51 58                 109
935891 935891 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No 1 03 05 2016   grade_5 96 6 12 0   2     0   4   53 67                       120 96 6 12 0   2     0   4   53 67                 120
935924 935924 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2016   grade_5 79 6 29 0   2     0   2   62 56                       118 79 6 29 0   2     0   2   62 56                 118
936174 936174 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2016   grade_5 10 6 23 0   16     0   2   23 34                       57 10 6 23 0   16     0   2   23 34                 57
936182 936182 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2016   grade_5 48 6 34 0   78     0   5   91 80                       171 48 6 34 0   78     0   5   91 80                 171
936203 936203 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2016   grade_5 11 6 53 0   76     0   9   82 73                       155 11 6 53 0   76     0   9   82 73                 155
936276 936276 MA Essex   school 2507110 163   Lynn 250711001077 1630030 Julia F Callahan   Regular School No 1 PK 05 2016   grade_5 22 6 32 0   10     0   4   40 34                       74 22 6 32 0   10     0   4   40 34                 74

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