enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 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
2039897 2039897 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_6 13 6 7 0   4     0   2   17 15                       32.0 13 6 7 0   4     0   2   17 15                 32
2039904 2039904 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_6 35 3 14 0   9     0   6   43 24                       67.0 35 3 14 0   9     0   6   43 24                 67
2039911 2039911 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_6 30 3 10 0   13     0   11   39 28                       67.0 30 3 10 0   13     0   11   39 28                 67
2040093 2040093 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2019   grade_6 33 15 6 0   4     0   6   28 36                       64.0 33 15 6 0   4     0   6   28 36                 64
2040323 2040323 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_6 4 4 6 0   1     0   1   8 8                       16.0 4 4 6 0   1     0   1   8 8                 16
2040347 2040347 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_6 17 13 19 0   0     0   2   29 22                       51.0 17 13 19 0   0     0   2   29 22                 51
2040357 2040357 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2019   grade_6 5 23 25 0   11     0   2   36 30                       66.0 5 23 25 0   11     0   2   36 30                 66
2040380 2040380 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_6 20 25 78 0   3     0   5   64 67                       131.0 20 25 78 0   3     0   5   64 67                 131
2040420 2040420 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2040442 2040442 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_6 17 19 24 0   1     1   4   29 37                       66.0 17 19 24 0   1     1   4   29 37                 66
2040452 2040452 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_6 10 2 88 0   1     0   0   53 48                       101.0 10 2 88 0   1     0   0   53 48                 101
2040469 2040469 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_6 41 9 22 0   8     0   1   40 41                       81.0 41 9 22 0   8     0   1   40 41                 81
2040486 2040486 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_6 7 19 23 0   1     0   2   28 24                       52.0 7 19 23 0   1     0   2   28 24                 52
2040524 2040524 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_6 24 37 33 1   6     0   1   44 58                       102.0 24 37 33 1   6     0   1   44 58                 102
2040533 2040533 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_6 7 20 60 0   2     0   2   35 56                       91.0 7 20 60 0   2     0   2   35 56                 91
2040595 2040595 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_6 6 2 28 0   0     0   0   19 17                       36.0 6 2 28 0   0     0   0   19 17                 36
2040605 2040605 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_6 7 43 27 0   9     0   5   40 51                       91.0 7 43 27 0   9     0   5   40 51                 91
2040622 2040622 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_6 25 9 12 0   8     0   6   23 37                       60.0 25 9 12 0   8     0   6   23 37                 60
2040653 2040653 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_6 1 10 39 0   0     0   0   17 33                       50.0 1 10 39 0   0     0   0   17 33                 50
2040677 2040677 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2019   grade_6 15 24 34 0   68     1   4   83 63                       146.0 15 24 34 0   68     1   4   83 63                 146
2040694 2040694 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_6 10 8 3 1   2     0   1   13 12                       25.0 10 8 3 1   2     0   1   13 12                 25
2040704 2040704 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_6 3 52 49 0   1     1   0   50 56                       106.0 3 52 49 0   1     1   0   50 56                 106
2040720 2040720 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   grade_6 30 5 22 0   1     0   1   29 30                       59.0 30 5 22 0   1     0   1   29 30                 59
2040782 2040782 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_6 2 8 20 0   0     0   1   17 14                       31.0 2 8 20 0   0     0   1   17 14                 31
2040792 2040792 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_6 10 9 25 0   1     0   3   24 24                       48.0 10 9 25 0   1     0   3   24 24                 48
2040809 2040809 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_6 29 9 14 0   4     0   5   27 34                       61.0 29 9 14 0   4     0   5   27 34                 61
2040845 2040845 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_6 1 27 12 0   1     2   1   28 16                       44.0 1 27 12 0   1     2   1   28 16                 44
2040862 2040862 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   grade_6 8 12 44 0   11     0   1   41 35                       76.0 8 12 44 0   11     0   1   41 35                 76
2040872 2040872 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_6 0 28 16 0   1     0   2   20 27                       47.0 0 28 16 0   1     0   2   20 27                 47
2040889 2040889 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_6 3 55 37 0   0     0   1   56 40                       96.0 3 55 37 0   0     0   1   56 40                 96
2040899 2040899 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_6 0 17 26 0   0     0   0   25 18                       43.0 0 17 26 0   0     0   0   25 18                 43
2040909 2040909 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_6 4 3 12 0   0     0   2   12 9                       21.0 4 3 12 0   0     0   2   12 9                 21
2041065 2041065 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2019   grade_6 13 2 174 0   2     0   1   92 100                       192.0 13 2 174 0   2     0   1   92 100                 192
2041092 2041092 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_6 3 0 35 0   0     0   0   19 19                       38.0 3 0 35 0   0     0   0   19 19                 38
2041138 2041138 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_6 94 1 0 0   5     0   0   48 52                       100.0 94 1 0 0   5     0   0   48 52                 100
2041208 2041208 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_6 38 1 1 0   1     0   0   21 20                       41.0 38 1 1 0   1     0   0   21 20                 41
2041247 2041247 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_6 18 86 17 1   2     0   7   63 68                       131.0 18 86 17 1   2     0   7   63 68                 131
2041332 2041332 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 39 0 2 0   0     0   4   20 25                       45.0 39 0 2 0   0     0   4   20 25                 45
2041341 2041341 MA Middlesex   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2019   grade_6 59 4 9 0   22     0   8   52 50                       102.0 59 4 9 0   22     0   8   52 50                 102
2041351 2041351 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_6 57 5 19 0   7     0   9   52 45                       97.0 57 5 19 0   7     0   9   52 45                 97
2041361 2041361 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   grade_6 41 3 11 0   8     0   10   31 42                       73.0 41 3 11 0   8     0   10   31 42                 73
2041371 2041371 MA Middlesex   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2019   grade_6 44 2 8 0   9     0   5   29 39                       68.0 44 2 8 0   9     0   5   29 39                 68
2041380 2041380 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2019   grade_6 40 5 6 0   21     0   5   45 32                       77.0 40 5 6 0   21     0   5   45 32                 77
2041389 2041389 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2019   grade_6 52 10 9 0   10     0   4   32 53                       85.0 52 10 9 0   10     0   4   32 53                 85
2041398 2041398 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   grade_6 52 3 8 0   20     0   7   45 45                       90.0 52 3 8 0   20     0   7   45 45                 90
2041408 2041408 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2019   grade_6 50 2 6 0   7     0   8   36 37                       73.0 50 2 6 0   7     0   8   36 37                 73
2041464 2041464 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_6 17 0 23 0   0     0   5   23 22                       45.0 17 0 23 0   0     0   5   23 22                 45
2041588 2041588 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   grade_6 50 0 1 0   5     0   8   36 28                       64.0 50 0 1 0   5     0   8   36 28                 64
2041758 2041758 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_6 21 0 0 0   0     0   2   12 11                       23.0 21 0 0 0   0     0   2   12 11                 23
2041821 2041821 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_6 19 0 1 0   0     0   0   9 11                       20.0 19 0 1 0   0     0   0   9 11                 20
2041924 2041924 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2019   grade_6 52 0 2 0   0     0   2   33 23                       56.0 52 0 2 0   0     0   2   33 23                 56
2042001 2042001 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W. Mitchell School   Regular School No Elementary 03 06 2019   grade_6 150 7 2 1   0     1   6   101 66                       167.0 150 7 2 1   0     1   6   101 66                 167
2042088 2042088 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_6 25 1 6 2   1     0   2   20 17                       37.0 25 1 6 2   1     0   2   20 17                 37
2042098 2042098 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   grade_6 17 0 0 0   0     0   3   8 12                       20.0 17 0 0 0   0     0   3   8 12                 20
2042107 2042107 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_6 11 5 57 0   4     0   1   44 34                       78.0 11 5 57 0   4     0   1   44 34                 78
2042123 2042123 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_6 37 14 43 0   4     0   0   52 46                       98.0 37 14 43 0   4     0   0   52 46                 98
2042132 2042132 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_6 32 24 61 0   8     0   2   61 66                       127.0 32 24 61 0   8     0   2   61 66                 127
2042148 2042148 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_6 37 20 67 1   2     0   4   65 66                       131.0 37 20 67 1   2     0   4   65 66                 131
2042157 2042157 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_6 18 19 65 0   3     0   4   50 59                       109.0 18 19 65 0   3     0   4   50 59                 109
2042221 2042221 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_6 26 5 37 0   5     0   10   39 44                       83.0 26 5 37 0   5     0   10   39 44                 83
2042231 2042231 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_6 23 2 23 0   0     0   5   27 26                       53.0 23 2 23 0   0     0   5   27 26                 53
2042347 2042347 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2019   grade_6 22 4 31 0   5     0   10   34 38                       72.0 22 4 31 0   5     0   10   34 38                 72
2042368 2042368 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_6 12 1 0 0   0     0   0   7 6                       13.0 12 1 0 0   0     0   0   7 6                 13
2042540 2042540 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_6 89 1 1 0   2     1   0   40 54                       94.0 89 1 1 0   2     1   0   40 54                 94
2042596 2042596 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_6 94 1 7 0   14     0   4   69 51                       120.0 94 1 7 0   14     0   4   69 51                 120
2042601 2042601 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_6 116 4 9 0   12     0   6   81 66                       147.0 116 4 9 0   12     0   6   81 66                 147
2042616 2042616 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2019   grade_6 47 0 4 0   1     0   0   31 21                       52.0 47 0 4 0   1     0   0   31 21                 52
2042655 2042655 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2019   grade_6 34 2 6 0   2     0   1   25 20                       45.0 34 2 6 0   2     0   1   25 20                 45
2042669 2042669 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_6 84 1 1 0   0     0   1   42 45                       87.0 84 1 1 0   0     0   1   42 45                 87
2042674 2042674 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2042716 2042716 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_6 38 0 1 0   0     0   1   22 18                       40.0 38 0 1 0   0     0   1   22 18                 40
2042743 2042743 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_6 115 10 29 0   4     0   3   83 78                       161.0 115 10 29 0   4     0   3   83 78                 161
2042855 2042855 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   grade_6 30 0 2 0   0     0   0   16 16                       32.0 30 0 2 0   0     0   0   16 16                 32
2042884 2042884 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_6 17 3 27 0   1     0   0   27 21                       48.0 17 3 27 0   1     0   0   27 21                 48
2042904 2042904 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_6 5 0 44 0   0     0   0   24 25                       49.0 5 0 44 0   0     0   0   24 25                 49
2042920 2042920 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_6 11 2 53 0   3     0   0   36 33                       69.0 11 2 53 0   3     0   0   36 33                 69
2042930 2042930 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_6 6 0 40 0   0     0   0   22 24                       46.0 6 0 40 0   0     0   0   22 24                 46
2042952 2042952 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2019   grade_6 69 3 7 0   0     0   2   44 37                       81.0 69 3 7 0   0     0   2   44 37                 81
2043043 2043043 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2019   grade_6 140 3 9 1   0     0   2   79 76                       155.0 140 3 9 1   0     0   2   79 76                 155
2043121 2043121 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_6 6 0 73 0   1     0   1   37 44                       81.0 6 0 73 0   1     0   1   37 44                 81
2043160 2043160 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2019   grade_6 30 0 4 0   3     0   2   11 28                       39.0 30 0 4 0   3     0   2   11 28                 39
2043248 2043248 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_6 12 0 3 0   0     0   2   8 9                       17.0 12 0 3 0   0     0   2   8 9                 17
2043308 2043308 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2019   grade_6 33 8 3 0   3     0   6   26 27                       53.0 33 8 3 0   3     0   6   26 27                 53
2043372 2043372 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 07 2019   grade_6 23 18 45 0   24     0   3   59 54                       113.0 23 18 45 0   24     0   3   59 54                 113
2043393 2043393 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2019   grade_6 24 3 20 0   2     0   3   18 34                       52.0 24 3 20 0   2     0   3   18 34                 52
2043463 2043463 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_6 12 5 19 0   15     0   1   30 22                       52.0 12 5 19 0   15     0   1   30 22                 52
2043707 2043707 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_6 31 12 17 0   40     0   3   55 48                       103.0 31 12 17 0   40     0   3   55 48                 103
2043716 2043716 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_6 30 24 42 0   20     0   10   68 58                       126.0 30 24 42 0   20     0   10   68 58                 126
2043725 2043725 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2019   grade_6 27 12 23 0   5     0   3   23 47                       70.0 27 12 23 0   5     0   3   23 47                 70
2043734 2043734 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_6 40 19 14 0   27     0   6   54 52                       106.0 40 19 14 0   27     0   6   54 52                 106
2043744 2043744 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2019   grade_6 21 29 45 0   28     0   6   56 73                       129.0 21 29 45 0   28     0   6   56 73                 129
2043796 2043796 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No Elementary PK 06 2019   grade_6 65 3 1 0   2     0   5   43 33                       76.0 65 3 1 0   2     0   5   43 33                 76
2043871 2043871 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_6 106 4 5 9   4     0   12   68 72                       140.0 106 4 5 9   4     0   12   68 72                 140
2044016 2044016 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_6 95 2 27 0   3     0   9   69 67                       136.0 95 2 27 0   3     0   9   69 67                 136
2044026 2044026 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   grade_6 64 1 53 0   4     0   5   56 71                       127.0 64 1 53 0   4     0   5   56 71                 127
2044036 2044036 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2019   grade_6 58 4 101 0   7     0   10   100 80                       180.0 58 4 101 0   7     0   10   100 80                 180
2044046 2044046 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2019   grade_6 61 1 69 1   7     0   8   79 68                       147.0 61 1 69 1   7     0   8   79 68                 147
2044081 2044081 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2019   grade_6 75 0 2 0   5     0   2   51 33                       84.0 75 0 2 0   5     0   2   51 33                 84
2044185 2044185 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_6 23 0 0 0   0     0   0   9 14                       23.0 23 0 0 0   0     0   0   9 14                 23
2044558 2044558 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2019   grade_6 97 2 7 0   6     0   5   56 61                       117.0 97 2 7 0   6     0   5   56 61                 117

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