enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by hispanic descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,679 ✖
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
1125826 1125826 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_4 3 0 99 0   0     0   2   56 48                       104 3 0 99 0   0     0   2   56 48                 104
2232637 2232637 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_4 2 0 99 0   0     0   0   51 50                       101.0 2 0 99 0   0     0   0   51 50                 101
738940 738940 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_4 1 1 97 0   0     0   0   47 52                       99 1 1 97 0   0     0   0   47 52                 99
934359 934359 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_4 7 5 96 1   0     0   0   63 46                       109 7 5 96 1   0     0   0   63 46                 109
1676267 1676267 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford - Woodland   Regular School No Elementary 03 05 2021   grade_4 198 14 96 3   3     1   9   164 160 *                     324.0 198 14 96 3   3     1   9   164 160                 324
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
738945 738945 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_4 3 0 95 0   0     0   0   57 41                       98 3 0 95 0   0     0   0   57 41                 98
935767 935767 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2016   grade_4 15 3 95 0   7     0   1   56 65                       121 15 3 95 0   7     0   1   56 65                 121
2233215 2233215 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Lynn: Cobbet Elementary   Regular School No Elementary KG 05 2018   grade_4 2 7 95 0   5     0   4   51 62                       113.0 2 7 95 0   5     0   4   51 62                 113
1368016 1368016 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_4 5 0 93 0   0     0   0   50 48 *                     98.0 5 0 93 0   0     0   0   50 48                 98
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
2233825 2233825 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_4 185 9 93 8   9     0   11   164 151                       315.0 185 9 93 8   9     0   11   164 151                 315
737495 737495 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_4 10 11 92 0   1     0   1   63 52                       115 10 11 92 0   1     0   1   63 52                 115
1129327 1129327 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2017   grade_4 0 10 92 0   0     0   0   45 57                       102 0 10 92 0   0     0   0   45 57                 102
1368011 1368011 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_4 4 1 92 0   0     0   1   49 49 *                     98.0 4 1 92 0   0     0   1   49 49                 98
1368526 1368526 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_4 6 7 91 1   9     0   2   60 56 *                     116.0 6 7 91 1   9     0   2   60 56                 116
1675256 1675256 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_4 1 0 91 0   0     0   0   46 46 *                     92.0 1 0 91 0   0     0   0   46 46                 92
1678099 1678099 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Springfield - Rebecca M Johnson   Regular School No Elementary PK 05 2021   grade_4 3 30 91 0   1     0   1   66 60 *                     126.0 3 30 91 0   1     0   1   66 60                 126
1673814 1673814 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_4 2 6 90 0   0     0   0   47 51 *                     98.0 2 6 90 0   0     0   0   47 51                 98
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
735747 735747 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_4 21 4 9 0   7     0   4   25 20                       45 21 4 9 0   7     0   4   25 20                 45
736092 736092 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No 1 PK 05 2015   grade_4 44 3 9 0   2     0   2   28 32                       60 44 3 9 0   2     0   2   28 32                 60
737387 737387 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2015   grade_4 7 9 9 0   3     1   1   15 15                       30 7 9 9 0   3     1   1   15 15                 30
737811 737811 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2015   grade_4 53 9 9 0   6     0   0   45 32                       77 53 9 9 0   6     0   0   45 32                 77
739783 739783 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No 1 PK 05 2015   grade_4 73 10 9 0   6     0   3   53 48                       101 73 10 9 0   6     0   3   53 48                 101
739966 739966 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No 2 04 06 2015   grade_4 126 2 9 0   1     0   3   57 84                       141 126 2 9 0   1     0   3   57 84                 141
740129 740129 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No 1 PK 05 2015   grade_4 71 2 9 0   5     0   2   41 48                       89 71 2 9 0   5     0   2   41 48                 89
740734 740734 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_4 31 2 9 2   0     0   6   24 26                       50 31 2 9 2   0     0   6   24 26                 50
741062 741062 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_4 46 7 9 0   20     0   2   40 44                       84 46 7 9 0   20     0   2   40 44                 84
742064 742064 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Helen Hansen Elementary   Regular School No 1 KG 05 2015   grade_4 29 8 9 0   3     0   0   19 30                       49 29 8 9 0   3     0   0   19 30                 49
742071 742071 MA Norfolk   school 2511250 285   Stoughton 251125001862 2850014 Joseph R Dawe Jr Elementary   Regular School No 1 KG 05 2015   grade_4 22 17 9 0   6     0   2   26 30                       56 22 17 9 0   6     0   2   26 30                 56
742811 742811 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No 1 KG 05 2015   grade_4 84 6 9 0   6     0   2   53 54                       107 84 6 9 0   6     0   2   53 54                 107
743235 743235 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2015   grade_4 14 3 9 0   3     0   1   17 13                       30 14 3 9 0   3     0   1   17 13                 30
743311 743311 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2015   grade_4 37 5 9 0   1     0   6   24 34                       58 37 5 9 0   1     0   6   24 34                 58
743473 743473 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_4 0 31 9 1   1     0   2   20 24                       44 0 31 9 1   1     0   2   20 24                 44
744072 744072 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No 1 PK 04 2015   grade_4 75 2 9 0   3     0   4   40 53                       93 75 2 9 0   3     0   4   40 53                 93
932603 932603 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No 1 PK 04 2016   grade_4 87 3 9 0   4     1   0   55 49                       104 87 3 9 0   4     1   0   55 49                 104
932647 932647 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No 1 KG 05 2016   grade_4 60 5 9 1   25     0   3   55 48                       103 60 5 9 1   25     0   3   55 48                 103
932771 932771 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No 1 KG 04 2016   grade_4 64 5 9 1   1     0   3   43 40                       83 64 5 9 1   1     0   3   43 40                 83
933184 933184 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2016   grade_4 21 10 9 0   1     0   1   21 21                       42 21 10 9 0   1     0   1   21 21                 42
933481 933481 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No 1 PK 05 2016   grade_4 7 4 9 0   0     0   0   11 9                       20 7 4 9 0   0     0   0   11 9                 20
933543 933543 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_4 1 5 9 0   0     0   0   12 3                       15 1 5 9 0   0     0   0   12 3                 15
933607 933607 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_4 0 15 9 0   0     0   1   13 12                       25 0 15 9 0   0     0   1   13 12                 25
933642 933642 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_4 17 18 9 0   2     0   1   20 27                       47 17 18 9 0   2     0   1   20 27                 47
933936 933936 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2016   grade_4 37 56 9 0   3     1   7   60 53                       113 37 56 9 0   3     1   7   60 53                 113
934089 934089 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2016   grade_4 37 2 9 0   15     0   9   35 37                       72 37 2 9 0   15     0   9   35 37                 72
934117 934117 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_4 41 3 9 0   9     0   7   38 31                       69 41 3 9 0   9     0   7   38 31                 69
934271 934271 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No 1 KG 05 2016   grade_4 57 13 9 1   7     0   3   40 50                       90 57 13 9 1   7     0   3   40 50                 90
935520 935520 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2016   grade_4 67 15 9 0   3     0   10   50 54                       104 67 15 9 0   3     0   10   50 54                 104
936343 936343 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No 1 PK 05 2016   grade_4 15 6 9 0   1     0   3   22 12                       34 15 6 9 0   1     0   3   22 12                 34
936634 936634 MA Middlesex   school 2507560 176   Medford 250756002057 1760140 Christopher Columbus   Regular School No 1 PK 05 2016   grade_4 43 21 9 0   4     0   3   40 40                       80 43 21 9 0   4     0   3   40 40                 80
936827 936827 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No 1 PK 04 2016   grade_4 81 1 9 0   6     0   6   58 45                       103 81 1 9 0   6     0   6   58 45                 103
936853 936853 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No 1 KG 05 2016   grade_4 82 8 9 0   6     0   3   65 43                       108 82 8 9 0   6     0   3   65 43                 108
937065 937065 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2016   grade_4 15 8 9 0   0     0   2   20 14                       34 15 8 9 0   0     0   2   20 14                 34
937072 937072 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No 1 PK 05 2016   grade_4 76 10 9 0   2     0   8   66 39                       105 76 10 9 0   2     0   8   66 39                 105
937158 937158 MA Middlesex   school 2508610 207   Newton 250861001359 2070020 C C Burr   Regular School No 1 KG 05 2016   grade_4 43 0 9 0   12     0   4   37 31                       68 43 0 9 0   12     0   4   37 31                 68
937493 937493 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No 2 04 05 2016   grade_4 147 3 9 1   5     0   11   79 97                       176 147 3 9 1   5     0   11   79 97                 176
937531 937531 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2016   grade_4 31 7 9 0   2     0   0   21 28                       49 31 7 9 0   2     0   0   21 28                 49
937619 937619 MA Essex   school 2509360 229   Peabody 250936001501 2290005 Captain Samuel Brown   Regular School No 1 KG 05 2016   grade_4 54 2 9 0   2     0   3   43 27                       70 54 2 9 0   2     0   3   43 27                 70
937891 937891 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2016   grade_4 35 11 9 1   24     1   2   40 43                       83 35 11 9 1   24     1   2   40 43                 83
938167 938167 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No 1 KG 05 2016   grade_4 22 2 9 0   0     0   3   25 11                       36 22 2 9 0   0     0   3   25 11                 36
938434 938434 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2016   grade_4 40 3 9 0   5     0   2   34 25                       59 40 3 9 0   5     0   2   34 25                 59
938982 938982 MA Essex   school 2511430 291   Swampscott 251143001886 2910020 Stanley   Regular School No 1 KG 04 2016   grade_4 47 1 9 0   1     0   1   31 28                       59 47 1 9 0   1     0   1   31 28                 59
939511 939511 MA Hampden   school 2512630 325   Westfield 251263002071 3250040 Southampton Road   Regular School No 1 KG 05 2016   grade_4 71 0 9 0   3     0   4   40 47                       87 71 0 9 0   3     0   4   40 47                 87
939616 939616 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No 1 KG 05 2016   grade_4 73 3 9 0   3     0   3   52 39                       91 73 3 9 0   3     0   3   52 39                 91
939714 939714 MA Norfolk   school 2512840 336   Weymouth 251284002116 3360085 Ralph Talbot   Regular School No 1 KG 04 2016   grade_4 25 2 9 0   6     1   0   28 15                       43 25 2 9 0   6     1   0   28 15                 43
940029 940029 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2016   grade_4 19 5 9 0   7     0   1   16 25                       41 19 5 9 0   7     0   1   16 25                 41
940120 940120 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   grade_4 27 7 9 0   1     0   2   23 23                       46 27 7 9 0   1     0   2   23 23                 46
940280 940280 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 04 2016   grade_4 0 23 9 0   1     0   1   14 20                       34 0 23 9 0   1     0   1   14 20                 34
940579 940579 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_4 62 31 9 0   28     0   6   59 77                       136 62 31 9 0   28     0   6   59 77                 136
940858 940858 MA Worcester   school 2502160 615   Athol-Royalston 250216000078 6150016 Pleasant Street   Regular School No 1 PK 04 2016   grade_4 38 5 9 0   0     0   1   28 25                       53 38 5 9 0   0     0   1   28 25                 53
1122104 1122104 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_4 74 2 9 1   19     0   7   68 44                       112 74 2 9 1   19     0   7   68 44                 112
1122336 1122336 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2017   grade_4 137 9 9 0   27     0   0   100 82                       182 137 9 9 0   27     0   0   100 82                 182
1122842 1122842 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_4 5 10 9 0   0     1   0   15 10                       25 5 10 9 0   0     1   0   15 10                 25
1122862 1122862 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   grade_4 9 21 9 0   5     0   1   20 25                       45 9 21 9 0   5     0   1   20 25                 45
1123751 1123751 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2017   grade_4 37 4 9 0   9     0   11   29 41                       70 37 4 9 0   9     0   11   29 41                 70
1124547 1124547 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2017   grade_4 61 3 9 0   3     0   4   37 43                       80 61 3 9 0   3     0   4   37 43                 80
1126966 1126966 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2017   grade_4 111 2 9 1   1     0   6   66 64                       130 111 2 9 1   1     0   6   66 64                 130
1127369 1127369 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 Betsey B Winslow   Regular School No Elementary KG 05 2017   grade_4 34 2 9 0   5     0   8   25 33                       58 34 2 9 0   5     0   8   25 33                 58
1128134 1128134 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2017   grade_4 44 11 9 0   0     0   7   41 30                       71 44 11 9 0   0     0   7   41 30                 71
1128302 1128302 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2017   grade_4 43 12 9 0   27     1   4   58 38                       96 43 12 9 0   27     1   4   58 38                 96
1128633 1128633 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No Elementary KG 05 2017   grade_4 19 0 9 0   0     0   4   13 19                       32 19 0 9 0   0     0   4   13 19                 32
1128991 1128991 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   grade_4 19 6 9 0   2     0   1   18 19                       37 19 6 9 0   2     0   1   18 19                 37
1129691 1129691 MA Bristol   school 2511520 293   Taunton 251152001908 2930057 H H Galligan   Regular School No Elementary KG 04 2017   grade_4 39 10 9 0   1     0   1   29 31                       60 39 10 9 0   1     0   1   29 31                 60
1130173 1130173 MA Worcester   school 2512390 322   West Boylston 251239002034 3220005 Major Edwards Elementary   Regular School No Elementary PK 05 2017   grade_4 53 1 9 0   0     0   4   27 40                       67 53 1 9 0   0     0   4   27 40                 67
1130867 1130867 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2017   grade_4 14 4 9 0   3     0   2   15 17                       32 14 4 9 0   3     0   2   15 17                 32
1130910 1130910 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   grade_4 7 10 9 0   2     0   2   19 11                       30 7 10 9 0   2     0   2   19 11                 30
1130926 1130926 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary KG 06 2017   grade_4 36 4 9 0   8     0   2   31 28                       59 36 4 9 0   8     0   2   31 28                 59
1130979 1130979 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2017   grade_4 23 9 9 0   5     0   3   16 33                       49 23 9 9 0   5     0   3   16 33                 49
1131320 1131320 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Elementary PK 08 2017   grade_4 9 22 9 0   0     0   4   24 20                       44 9 22 9 0   0     0   4   24 20                 44
1131706 1131706 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_4 51 1 9 0   9     0   2   35 37                       72 51 1 9 0   9     0   2   35 37                 72
1132188 1132188 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2017   grade_4 34 0 9 1   0     0   7   21 30                       51 34 0 9 1   0     0   7   21 30                 51
1132364 1132364 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   grade_4 108 7 9 0   0     1   0   64 61                       125 108 7 9 0   0     1   0   64 61                 125
1132952 1132952 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2017   grade_4 78 1 9 0   2     0   3   42 51                       93 78 1 9 0   2     0   3   42 51                 93
1133186 1133186 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 22 8 9 0   3     0   4   21 25                       46 22 8 9 0   3     0   4   21 25                 46
1365232 1365232 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 04 2020   grade_4 80 11 9 0   12     0   3   59 56 *                     115.0 80 11 9 0   12     0   3   59 56                 115
1365247 1365247 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 04 2020   grade_4 64 5 9 1   14     0   6   54 45 *                     99.0 64 5 9 1   14     0   6   54 45                 99
1365465 1365465 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2020   grade_4 1 26 9 0   2     0   5   32 11 *                     43.0 1 26 9 0   2     0   5   32 11                 43
1365498 1365498 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2020   grade_4 1 31 9 0   0     0   0   25 16 *                     41.0 1 31 9 0   0     0   0   25 16                 41
1365716 1365716 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2020   grade_4 3 5 9 0   2     0   1   12 8 *                     20.0 3 5 9 0   2     0   1   12 8                 20

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