Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2018 sorted by ccd_school_lvl

View and edit SQL

year

  • 2018 · 575

grade

  • grade_6 · 575
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
2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2228858 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_6 29 5 17 0   5     0   9   29 36                       65.0 29 5 17 0   5     0   9   29 36                 65
2228866 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_6 25 9 13 0   0     0   3   24 26                       50.0 25 9 13 0   0     0   3   24 26                 50
2228874 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_6 27 11 12 1   4     0   4   29 30                       59.0 27 11 12 1   4     0   4   29 30                 59
2229094 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_6 32 17 4 1   2     0   3   33 26                       59.0 32 17 4 1   2     0   3   33 26                 59
2229376 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   grade_6 3 3 7 0   2     0   2   12 5                       17.0 3 3 7 0   2     0   2   12 5                 17
2229405 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_6 20 8 15 0   1     0   2   20 26                       46.0 20 8 15 0   1     0   2   20 26                 46
2229416 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston: Jackson Mann   Regular School No Elementary PK 08 2018   grade_6 4 25 28 0   6     0   4   37 30                       67.0 4 25 28 0   6     0   4   37 30                 67
2229442 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   grade_6 16 25 64 0   3     0   3   52 59                       111.0 16 25 64 0   3     0   3   52 59                 111
2229513 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   grade_6 9 15 20 0   1     0   3   21 27                       48.0 9 15 20 0   1     0   3   21 27                 48
2229524 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_6 6 3 88 0   0     0   1   47 51                       98.0 6 3 88 0   0     0   1   47 51                 98
2229543 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_6 24 7 11 0   5     0   1   22 26                       48.0 24 7 11 0   5     0   1   22 26                 48
2229562 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston: Franklin D Roosevelt   Regular School No Elementary PK 08 2018   grade_6 10 23 19 0   1     0   2   23 32                       55.0 10 23 19 0   1     0   2   23 32                 55
2229605 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_6 25 39 44 0   9     0   4   66 55                       121.0 25 39 44 0   9     0   4   66 55                 121
2229615 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   grade_6 0 20 49 0   2     0   1   36 36                       72.0 0 20 49 0   2     0   1   36 36                 72
2229686 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston: Joseph J Hurley   Regular School No Elementary PK 08 2018   grade_6 8 0 20 0   0     0   2   15 15                       30.0 8 0 20 0   0     0   2   15 15                 30
2229697 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_6 4 39 20 0   10     0   6   46 33                       79.0 4 39 20 0   10     0   6   46 33                 79
2229716 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   grade_6 24 1 16 0   2     0   1   23 21                       44.0 24 1 16 0   2     0   1   23 21                 44
2229751 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_6 0 15 23 0   1     0   1   20 20                       40.0 0 15 23 0   1     0   1   20 20                 40
2229777 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston: Richard J Murphy   Regular School No Elementary PK 08 2018   grade_6 22 18 40 0   61     0   5   70 76                       146.0 22 18 40 0   61     0   5   70 76                 146
2229796 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_6 14 5 4 0   0     0   0   14 9                       23.0 14 5 4 0   0     0   0   14 9                 23
2229806 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_6 1 45 41 1   2     0   2   45 47                       92.0 1 45 41 1   2     0   2   45 47                 92
2229824 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston: Lyndon   Regular School No Elementary PK 08 2018   grade_6 23 8 24 0   1     0   3   30 29                       59.0 23 8 24 0   1     0   3   30 29                 59
2229895 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_6 1 13 25 0   0     0   1   26 14                       40.0 1 13 25 0   0     0   1   26 14                 40
2229906 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston: Gardner Pilot Academy   Regular School No Elementary PK 08 2018   grade_6 6 6 30 0   3     0   2   24 23                       47.0 6 6 30 0   3     0   2   24 23                 47
2229925 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston: Warren-Prescott   Regular School No Elementary PK 08 2018   grade_6 27 12 25 0   5     0   2   35 36                       71.0 27 12 25 0   5     0   2   35 36                 71
2229964 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_6 4 19 16 0   0     0   6   21 24                       45.0 4 19 16 0   0     0   6   21 24                 45
2229983 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston: Edison K-8   Regular School No Elementary PK 08 2018   grade_6 16 14 39 1   13     0   2   48 37                       85.0 16 14 39 1   13     0   2   48 37                 85
2229994 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   grade_6 1 22 18 0   1     0   4   18 28                       46.0 1 22 18 0   1     0   4   18 28                 46
2230002 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_6 0 20 21 0   0     0   4   22 23                       45.0 0 20 21 0   0     0   4   22 23                 45
2230013 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_6 2 72 27 2   0     0   5   54 54                       108.0 2 72 27 2   0     0   5   54 54                 108
2230024 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston: Young Achievers   Alternative School No Elementary PK 08 2018   grade_6 1 24 23 0   0     0   0   27 21                       48.0 1 24 23 0   0     0   0   27 21                 48
2230035 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_6 1 6 11 0   0     0   1   9 10                       19.0 1 6 11 0   0     0   1   9 10                 19
2230229 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_6 16 5 177 0   6     0   1   104 101                       205.0 16 5 177 0   6     0   1   104 101                 205
2230258 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_6 1 1 23 0   0     0   0   7 18                       25.0 1 1 23 0   0     0   0   7 18                 25
2230310 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_6 98 0 3 0   4     0   1   42 64                       106.0 98 0 3 0   4     0   1   42 64                 106
2230393 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_6 43 0 0 0   1     0   0   20 24                       44.0 43 0 0 0   1     0   0   20 24                 44
2230438 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_6 20 69 17 0   0     1   6   56 57                       113.0 20 69 17 0   0     1   6   56 57                 113
2230534 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 39 0 1 0   0     0   1   23 18                       41.0 39 0 1 0   0     0   1   23 18                 41
2230546 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_6 35 4 12 0   25     0   9   54 31                       85.0 35 4 12 0   25     0   9   54 31                 85
2230556 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_6 47 5 14 0   18     0   10   41 53                       94.0 47 5 14 0   18     0   10   41 53                 94
2230567 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   grade_6 34 6 9 0   13     0   13   39 36                       75.0 34 6 9 0   13     0   13   39 36                 75
2230578 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline: Heath   Regular School No Elementary PK 08 2018   grade_6 34 2 5 0   10     0   4   33 22                       55.0 34 2 5 0   10     0   4   33 22                 55
2230588 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline: Lawrence   Regular School No Elementary KG 08 2018   grade_6 36 5 13 0   13     0   8   38 37                       75.0 36 5 13 0   13     0   8   38 37                 75
2230598 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   grade_6 28 7 11 0   11     0   3   28 32                       60.0 28 7 11 0   11     0   3   28 32                 60
2230608 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_6 42 6 13 0   12     0   3   43 33                       76.0 42 6 13 0   12     0   3   43 33                 76
2230619 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline: John D Runkle   Regular School No Elementary PK 08 2018   grade_6 38 2 8 0   8     0   9   36 29                       65.0 38 2 8 0   8     0   9   36 29                 65
2230685 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_6 13 0 20 0   1     0   2   11 25                       36.0 13 0 20 0   1     0   2   11 25                 36
2230829 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_6 51 0 3 0   5     0   11   39 31                       70.0 51 0 3 0   5     0   11   39 31                 70
2231028 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_6 18 0 0 0   0     0   2   10 10                       20.0 18 0 0 0   0     0   2   10 10                 20
2231102 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_6 22 0 0 0   0     0   1   14 9                       23.0 22 0 0 0   0     0   1   14 9                 23
2231225 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield: Deerfield Elementary   Regular School No Elementary PK 06 2018   grade_6 47 0 3 0   1     0   5   31 25                       56.0 47 0 3 0   1     0   5   31 25                 56
2231317 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater: Gordon W Mitchell   Regular School No Elementary 03 06 2018   grade_6 159 4 7 1   1     0   5   99 78                       177.0 159 4 7 1   1     0   5   99 78                 177
2231420 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_6 30 2 4 0   0     0   1   17 20                       37.0 30 2 4 0   0     0   1   17 20                 37
2231431 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 1 0   0     0   2   11 8                       19.0 16 0 1 0   0     0   2   11 8                 19
2231441 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett: Sumner G. Whittier School   Regular School No Elementary KG 08 2018   grade_6 13 5 35 1   4     0   2   31 29                       60.0 13 5 35 1   4     0   2   31 29                 60
2231459 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_6 46 11 53 2   6     1   2   61 60                       121.0 46 11 53 2   6     1   2   61 60                 121
2231469 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett: George Keverian School   Regular School No Elementary KG 08 2018   grade_6 34 19 59 1   12     0   1   66 60                       126.0 34 19 59 1   12     0   1   66 60                 126
2231488 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett: Lafayette School   Regular School No Elementary KG 08 2018   grade_6 25 22 53 1   6     0   6   48 65                       113.0 25 22 53 1   6     0   6   48 65                 113
2231497 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_6 15 23 72 0   3     0   0   54 59                       113.0 15 23 72 0   3     0   0   54 59                 113
2231569 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River: Henry Lord Community School   Regular School No Elementary PK 08 2018   grade_6 22 8 25 0   2     0   5   35 27                       62.0 22 8 25 0   2     0   5   35 27                 62
2231580 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   grade_6 28 4 6 1   2     0   6   24 23                       47.0 28 4 6 1   2     0   6   24 23                 47
2231732 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg: McKay Arts Academy   Regular School No Elementary PK 08 2018   grade_6 29 2 35 0   4     0   1   41 30                       71.0 29 2 35 0   4     0   1   41 30                 71
2231754 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_6 8 0 0 0   0     0   0   2 6                       8.0 8 0 0 0   0     0   0   2 6                 8
2231958 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_6 95 2 2 0   0     0   0   53 46                       99.0 95 2 2 0   0     0   0   53 46                 99
2232041 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 89 1 6 2   7     2   3   63 47                       110.0 89 1 6 2   7     2   3   63 47                 110
2232047 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 93 3 8 0   22     0   3   67 62                       129.0 93 3 8 0   22     0   3   67 62                 129
2232111 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_6 40 1 3 0   1     3   3   27 24                       51.0 40 1 3 0   1     3   3   27 24                 51
2232126 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax: Halifax Elementary   Regular School No Elementary KG 06 2018   grade_6 68 2 2 0   2     1   2   45 32                       77.0 68 2 2 0   2     1   2   45 32                 77
2232133 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   8 2                       10.0 10 0 0 0   0     0   0   8 2                 10
2232182 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_6 30 1 1 0   0     0   0   17 15                       32.0 30 1 1 0   0     0   0   17 15                 32
2232216 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   grade_6 151 9 33 0   3     1   2   105 94                       199.0 151 9 33 0   3     1   2   105 94                 199
2232334 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland: Holland Elementary   Regular School No Elementary PK 06 2018   grade_6 34 2 0 0   0     0   0   17 19                       36.0 34 2 0 0   0     0   0   17 19                 36
2232367 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_6 18 0 36 0   0     0   0   29 25                       54.0 18 0 36 0   0     0   0   29 25                 54
2232378 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke: Morgan Full Service Community School   Regular School No Elementary PK 08 2018   grade_6 1 1 36 0   0     0   1   16 23                       39.0 1 1 36 0   0     0   1   16 23                 39
2232395 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_6 1 1 54 0   0     0   0   31 25                       56.0 1 1 54 0   0     0   0   31 25                 56
2232406 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke: E N White Elementary   Regular School No Elementary PK 08 2018   grade_6 4 2 37 0   0     0   0   24 19                       43.0 4 2 37 0   0     0   0   24 19                 43
2232416 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke: Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2018   grade_6 13 5 44 0   0     0   0   31 31                       62.0 13 5 44 0   0     0   0   31 31                 62
2232427 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke: Maurice A Donahue Elementary   Regular School No Elementary PK 08 2018   grade_6 5 2 36 0   1     0   0   15 29                       44.0 5 2 36 0   1     0   0   15 29                 44
2232453 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale: Memorial   Regular School No Elementary KG 06 2018   grade_6 80 2 5 1   2     0   0   51 39                       90.0 80 2 5 1   2     0   0   51 39                 90
2232561 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston: Kingston Intermediate   Regular School No Elementary 03 06 2018   grade_6 125 2 3 1   1     0   2   66 68                       134.0 125 2 3 1   1     0   2   66 68                 134
2232570 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_6 31 0 0 0   0     0   1   13 19                       32.0 31 0 0 0   0     0   1   13 19                 32
2232668 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_6 0 1 71 0   2     0   0   35 39                       74.0 0 1 71 0   2     0   0   35 39                 74
2232719 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee: Lee Elementary   Regular School No Elementary PK 06 2018   grade_6 44 1 3 0   2     0   1   28 23                       51.0 44 1 3 0   2     0   1   28 23                 51
2232826 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   grade_6 12 0 2 0   0     0   3   10 7                       17.0 12 0 2 0   0     0   3   10 7                 17
2232898 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln: Lincoln School   Regular School No Elementary PK 08 2018   grade_6 47 4 7 1   4     0   5   36 32                       68.0 47 4 7 1   4     0   5   36 32                 68
2232975 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell: Rogers STEM Academy   Regular School No Elementary PK 06 2018   grade_6 22 2 16 0   12     0   1   35 18                       53.0 22 2 16 0   12     0   1   35 18                 53
2232998 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell: Pyne Arts   Regular School No Elementary PK 08 2018   grade_6 27 2 25 0   5     0   2   30 31                       61.0 27 2 25 0   5     0   2   30 31                 61
2233079 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell: Bartlett Community Partnership   Regular School No Elementary PK 08 2018   grade_6 11 8 17 0   23     0   2   26 35                       61.0 11 8 17 0   23     0   2   26 35                 61
2233368 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_6 28 17 12 0   44     1   1   56 47                       103.0 28 17 12 0   44     1   1   56 47                 103
2233378 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden: Ferryway   Regular School No Elementary KG 08 2018   grade_6 20 15 32 0   14     0   7   42 46                       88.0 20 15 32 0   14     0   7   42 46                 88
2233388 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden: Forestdale   Regular School No Elementary KG 08 2018   grade_6 27 13 15 0   7     0   2   36 28                       64.0 27 13 15 0   7     0   2   36 28                 64
2233398 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden: Linden   Regular School No Elementary KG 08 2018   grade_6 44 19 14 1   21     0   3   55 47                       102.0 44 19 14 1   21     0   3   55 47                 102
2233410 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden: Salemwood   Regular School No Elementary KG 08 2018   grade_6 29 32 46 0   30     0   1   63 75                       138.0 29 32 46 0   30     0   1   63 75                 138
2233474 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Marion: Sippican   Regular School No Elementary PK 06 2018   grade_6 52 1 5 0   1     0   2   28 33                       61.0 52 1 5 0   1     0   2   28 33                 61
2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
2233738 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen: Marsh Grammar School   Regular School No Elementary PK 08 2018   grade_6 80 0 43 0   6     0   7   68 68                       136.0 80 0 43 0   6     0   7   68 68                 136
2233749 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen: Comprehensive Grammar School   Regular School No Elementary PK 08 2018   grade_6 68 2 36 0   7     0   5   56 62                       118.0 68 2 36 0   7     0   5   56 62                 118
2233760 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen: Tenney Grammar School   Regular School No Elementary PK 08 2018   grade_6 59 0 78 0   4     0   10   84 67                       151.0 59 0 78 0   4     0   10   84 67                 151
2233771 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen: Donald P Timony Grammar   Regular School No Elementary PK 08 2018   grade_6 68 2 68 0   3     0   9   70 80                       150.0 68 2 68 0   3     0   9   70 80                 150

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