enrollments

Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2020 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 572 ✖

grade ✖

  • grade_6 · 572 ✖
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
1364870 1364870 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_6 29 3 20 0   6     0   3   34 27 *                     61.0 29 3 20 0   6     0   3   34 27                 61
1364877 1364877 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_6 26 6 11 0   5     0   2   18 32 *                     50.0 26 6 11 0   5     0   2   18 32                 50
1364884 1364884 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_6 32 6 8 0   5     0   6   29 28 *                     57.0 32 6 8 0   5     0   6   29 28                 57
1365064 1365064 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   grade_6 31 14 3 1   4     0   5   34 24 *                     58.0 31 14 3 1   4     0   5   34 24                 58
1365280 1365280 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_6 5 5 3 0   3     0   1   9 8 *                     17.0 5 5 3 0   3     0   1   9 8                 17
1365304 1365304 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_6 18 12 12 0   5     0   1   23 25 *                     48.0 18 12 12 0   5     0   1   23 25                 48
1365314 1365314 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2020   grade_6 13 14 23 0   10     0   0   37 23 *                     60.0 13 14 23 0   10     0   0   37 23                 60
1365338 1365338 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_6 18 22 72 0   1     0   4   71 46 *                     117.0 18 22 72 0   1     0   4   71 46                 117
1365399 1365399 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2020   grade_6 13 13 16 0   1     0   3   26 20 *                     46.0 13 13 16 0   1     0   3   26 20                 46
1365409 1365409 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_6 11 2 88 0   1     0   1   53 50 *                     103.0 11 2 88 0   1     0   1   53 50                 103
1365426 1365426 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2020   grade_6 37 8 16 0   14     0   4   43 36 *                     79.0 37 8 16 0   14     0   4   43 36                 79
1365443 1365443 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_6 2 28 22 0   1     0   2   24 31 *                     55.0 2 28 22 0   1     0   2   24 31                 55
1365481 1365481 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_6 12 33 40 0   13     1   5   46 58 *                     104.0 12 33 40 0   13     1   5   46 58                 104
1365490 1365490 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2020   grade_6 8 29 74 0   3     0   3   55 62 *                     117.0 8 29 74 0   3     0   3   55 62                 117
1365552 1365552 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_6 7 2 23 0   0     0   0   16 16 *                     32.0 7 2 23 0   0     0   0   16 16                 32
1365562 1365562 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_6 4 41 33 0   7     0   11   42 54 *                     96.0 4 41 33 0   7     0   11   42 54                 96
1365579 1365579 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_6 38 12 20 0   7     1   3   43 38 *                     81.0 38 12 20 0   7     1   3   43 38                 81
1365610 1365610 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_6 1 19 29 0   3     0   0   32 20 *                     52.0 1 19 29 0   3     0   0   32 20                 52
1365634 1365634 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_6 16 19 31 0   80     0   6   94 58 *                     152.0 16 19 31 0   80     0   6   94 58                 152
1365651 1365651 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_6 13 6 5 0   0     0   0   14 10 *                     24.0 13 6 5 0   0     0   0   14 10                 24
1365661 1365661 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_6 2 36 50 1   1     1   3   42 52 *                     94.0 2 36 50 1   1     1   3   42 52                 94
1365677 1365677 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2020   grade_6 44 7 30 0   3     0   4   48 40 *                     88.0 44 7 30 0   3     0   4   48 40                 88
1365739 1365739 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_6 0 8 36 0   0     0   0   23 21 *                     44.0 0 8 36 0   0     0   0   23 21                 44
1365749 1365749 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_6 8 3 29 0   2     0   2   22 22 *                     44.0 8 3 29 0   2     0   2   22 22                 44
1365766 1365766 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_6 37 5 15 0   4     0   1   37 25 *                     62.0 37 5 15 0   4     0   1   37 25                 62
1365802 1365802 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_6 0 21 14 0   0     0   1   17 19 *                     36.0 0 21 14 0   0     0   1   17 19                 36
1365819 1365819 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2020   grade_6 14 15 19 2   7     0   2   32 27 *                     59.0 14 15 19 2   7     0   2   32 27                 59
1365829 1365829 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_6 1 34 15 0   1     0   1   24 28 *                     52.0 1 34 15 0   1     0   1   24 28                 52
1365845 1365845 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_6 1 70 23 1   2     0   2   54 45 *                     99.0 1 70 23 1   2     0   2   54 45                 99
1365855 1365855 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_6 1 45 26 0   0     0   2   38 36 *                     74.0 1 45 26 0   0     0   2   38 36                 74
1365865 1365865 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_6 5 6 8 0   0     0   1   17 3 *                     20.0 5 6 8 0   0     0   1   17 3                 20
1366017 1366017 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_6 20 7 150 0   8     0   4   95 94 *                     189.0 20 7 150 0   8     0   4   95 94                 189
1366039 1366039 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_6 1 0 30 0   0     0   1   13 19 *                     32.0 1 0 30 0   0     0   1   13 19                 32
1366079 1366079 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2020   grade_6 90 1 3 0   6     0   7   56 51 *                     107.0 90 1 3 0   6     0   7   56 51                 107
1366141 1366141 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2020   grade_6 37 3 1 0   0     0   1   16 26 *                     42.0 37 3 1 0   0     0   1   16 26                 42
1366180 1366180 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_6 17 79 22 1   0     0   8   61 66 *                     127.0 17 79 22 1   0     0   8   61 66                 127
1366262 1366262 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 34 0 1 0   0     0   2   16 21 *                     37.0 34 0 1 0   0     0   2   16 21                 37
1366272 1366272 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_6 32 3 5 0   20     0   4   34 30 *                     64.0 32 3 5 0   20     0   4   34 30                 64
1366282 1366282 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_6 64 1 14 0   13     0   10   53 48 *                     102.0 64 1 14 0   13     0   10   53 48                 102
1366291 1366291 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary KG 08 2020   grade_6 42 2 1 0   15     0   4   36 28 *                     64.0 42 2 1 0   15     0   4   36 28                 64
1366301 1366301 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2020   grade_6 31 2 12 0   7     0   2   28 26 *                     54.0 31 2 12 0   7     0   2   28 26                 54
1366310 1366310 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2020   grade_6 29 5 7 0   15     1   5   37 25 *                     62.0 29 5 7 0   15     1   5   37 25                 62
1366319 1366319 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_6 34 7 5 0   14     0   3   36 27 *                     63.0 34 7 5 0   14     0   3   36 27                 63
1366328 1366328 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_6 58 3 11 0   19     0   12   47 56 *                     103.0 58 3 11 0   19     0   12   47 56                 103
1366338 1366338 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   grade_6 41 1 11 0   9     0   8   30 40 *                     70.0 41 1 11 0   9     0   8   30 40                 70
1366394 1366394 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   grade_6 12 4 20 0   2     0   4   22 20 *                     42.0 12 4 20 0   2     0   4   22 20                 42
1366518 1366518 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_6 60 0 2 0   9     0   6   40 37 *                     77.0 60 0 2 0   9     0   6   40 37                 77
1366585 1366585 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_6 0 0 32 0   0     0   0   11 21 *                     32.0 0 0 32 0   0     0   0   11 21                 32
1366688 1366688 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_6 33 0 0 0   0     0   1   14 20 *                     34.0 33 0 0 0   0     0   1   14 20                 34
1366751 1366751 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2020   grade_6 14 1 1 0   0     0   0   10 6 *                     16.0 14 1 1 0   0     0   0   10 6                 16
1366855 1366855 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2020   grade_6 47 1 5 0   1     0   6   31 29 *                     60.0 47 1 5 0   1     0   6   31 29                 60
1366930 1366930 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W. Mitchell School   Regular School No Elementary 03 06 2020   grade_6 154 7 6 1   2     0   7   104 73 *                     177.0 154 7 6 1   2     0   7   104 73                 177
1367016 1367016 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_6 26 3 9 1   0     0   2   17 24 *                     41.0 26 3 9 1   0     0   2   17 24                 41
1367026 1367026 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2020   grade_6 14 1 0 0   0     0   3   12 6 *                     18.0 14 1 0 0   0     0   3   12 6                 18
1367035 1367035 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2020   grade_6 8 8 63 0   5     0   2   40 46 *                     86.0 8 8 63 0   5     0   2   40 46                 86
1367051 1367051 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_6 33 7 46 0   6     0   2   48 46 *                     94.0 33 7 46 0   6     0   2   48 46                 94
1367060 1367060 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_6 19 3 83 0   2     0   2   60 49 *                     109.0 19 3 83 0   2     0   2   60 49                 109
1367076 1367076 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_6 33 21 65 0   11     0   1   64 67 *                     131.0 33 21 65 0   11     0   1   64 67                 131
1367085 1367085 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_6 12 16 69 0   3     0   1   49 52 *                     101.0 12 16 69 0   3     0   1   49 52                 101
1367148 1367148 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_6 35 6 29 0   4     0   13   55 32 *                     87.0 35 6 29 0   4     0   13   55 32                 87
1367158 1367158 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_6 25 4 18 0   1     0   3   28 23 *                     51.0 25 4 18 0   1     0   3   28 23                 51
1367277 1367277 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2020   grade_6 16 6 44 0   1     0   4   32 39 *                     71.0 16 6 44 0   1     0   4   32 39                 71
1367296 1367296 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_6 14 0 0 0   0     0   0   9 5 *                     14.0 14 0 0 0   0     0   0   9 5                 14
1367468 1367468 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_6 112 1 1 0   0     1   1   59 57 *                     116.0 112 1 1 0   0     1   1   59 57                 116
1367524 1367524 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_6 83 2 8 1   6     0   4   65 39 *                     104.0 83 2 8 1   6     0   4   65 39                 104
1367529 1367529 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_6 108 2 10 0   20     0   1   68 73 *                     141.0 108 2 10 0   20     0   1   68 73                 141
1367543 1367543 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2020   grade_6 42 0 5 0   1     0   1   31 18 *                     49.0 42 0 5 0   1     0   1   31 18                 49
1367581 1367581 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2020   grade_6 35 1 7 0   2     1   2   20 28 *                     48.0 35 1 7 0   2     1   2   20 28                 48
1367594 1367594 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2020   grade_6 76 1 2 1   0     0   3   39 44 *                     83.0 76 1 2 1   0     0   3   39 44                 83
1367601 1367601 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1367637 1367637 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2020   grade_6 34 1 3 0   0     0   0   17 21 *                     38.0 34 1 3 0   0     0   0   17 21                 38
1367660 1367660 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_6 114 12 43 1   3     0   1   90 84 *                     174.0 114 12 43 1   3     0   1   90 84                 174
1367774 1367774 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2020   grade_6 20 0 1 0   1     0   0   11 11 *                     22.0 20 0 1 0   1     0   0   11 11                 22
1367803 1367803 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   grade_6 13 1 27 0   0     0   2   25 18 *                     43.0 13 1 27 0   0     0   2   25 18                 43
1367839 1367839 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_6 3 1 58 0   0     0   1   36 27 *                     63.0 3 1 58 0   0     0   1   36 27                 63
1367849 1367849 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2020   grade_6 4 1 40 0   0     0   0   22 23 *                     45.0 4 1 40 0   0     0   0   22 23                 45
1367872 1367872 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2020   grade_6 71 1 10 0   1     1   2   45 41 *                     86.0 71 1 10 0   1     1   2   45 41                 86
1367959 1367959 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2020   grade_6 140 1 6 1   3     0   0   75 75 *                     151.0 140 1 6 1   3     0   0   75 75                 151
1368037 1368037 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_6 5 1 72 0   0     0   0   36 42 *                     78.0 5 1 72 0   0     0   0   36 42                 78
1368076 1368076 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2020   grade_6 29 0 5 0   3     0   1   15 22 *                     38.0 29 0 5 0   3     0   1   15 22                 38
1368164 1368164 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 2 0   0     0   0   9 6 *                     15.0 13 0 2 0   0     0   0   9 6                 15
1368224 1368224 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2020   grade_6 40 6 4 0   5     0   3   26 32 *                     58.0 40 6 4 0   5     0   3   26 32                 58
1368288 1368288 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   grade_6 24 13 45 0   25     0   3   59 51 *                     110.0 24 13 45 0   25     0   3   59 51                 110
1368310 1368310 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2020   grade_6 19 2 29 0   8     0   2   38 22 *                     60.0 19 2 29 0   8     0   2   38 22                 60
1368378 1368378 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2020   grade_6 10 1 22 0   19     0   4   26 30 *                     56.0 10 1 22 0   19     0   4   26 30                 56
1368641 1368641 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_6 28 15 13 0   32     0   2   38 52 *                     90.0 28 15 13 0   32     0   2   38 52                 90
1368650 1368650 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_6 23 14 40 0   16     0   4   49 48 *                     97.0 23 14 40 0   16     0   4   49 48                 97
1368659 1368659 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2020   grade_6 28 11 21 0   8     0   4   40 32 *                     72.0 28 11 21 0   8     0   4   40 32                 72
1368668 1368668 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2020   grade_6 30 19 18 1   15     0   8   50 41 *                     91.0 30 19 18 1   15     0   8   50 41                 91
1368678 1368678 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2020   grade_6 29 22 53 0   19     0   4   72 55 *                     127.0 29 22 53 0   19     0   4   72 55                 127
1368706 1368706 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_6 167 4 15 0   3     0   8   95 102 *                     197.0 167 4 15 0   3     0   8   95 102                 197
1368726 1368726 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2020   grade_6 56 2 0 0   1     0   3   29 33 *                     62.0 56 2 0 0   1     0   3   29 33                 62
1368800 1368800 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_6 97 6 4 8   2     0   6   63 60 *                     123.0 97 6 4 8   2     0   6   63 60                 123
1368945 1368945 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_6 78 1 42 0   4     0   4   65 64 *                     129.0 78 1 42 0   4     0   4   65 64                 129
1368955 1368955 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_6 72 5 48 0   7     0   7   75 64 *                     139.0 72 5 48 0   7     0   7   75 64                 139
1368965 1368965 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2020   grade_6 51 3 75 0   3     0   9   84 57 *                     141.0 51 3 75 0   3     0   9   84 57                 141
1368975 1368975 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2020   grade_6 60 8 77 0   8     0   5   86 72 *                     158.0 60 8 77 0   8     0   5   86 72                 158
1369010 1369010 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2020   grade_6 84 1 10 0   5     0   8   51 57 *                     108.0 84 1 10 0   5     0   8   51 57                 108
1369099 1369099 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Granite Valley School   Regular School No Elementary 01 06 2020   grade_6 65 1 4 0   1     0   2   35 38 *                     73.0 65 1 4 0   1     0   2   35 38                 73
1369114 1369114 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2020   grade_6 15 0 0 0   0     0   0   6 9 *                     15.0 15 0 0 0   0     0   0   6 9                 15

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