enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by native_hawaiian_pacific_islander_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 3,938 ✖
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
736467 736467 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   grade_6 39 2 6 2   5     0   3   28 29                       57 39 2 6 2   5     0   3   28 29                 57
736505 736505 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_6 0 7 34 0   1     0   0   24 18                       42 0 7 34 0   1     0   0   24 18                 42
736555 736555 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_6 1 31 43 0   1     0   1   41 36                       77 1 31 43 0   1     0   1   41 36                 77
736561 736561 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_6 21 25 49 0   11     0   9   68 47                       115 21 25 49 0   11     0   9   68 47                 115
736571 736571 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_6 20 10 33 1   1     0   0   33 32                       65 20 10 33 1   1     0   0   33 32                 65
736636 736636 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_6 0 12 30 0   0     0   0   21 21                       42 0 12 30 0   0     0   0   21 21                 42
736646 736646 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2015   grade_6 6 8 25 0   4     0   1   31 13                       44 6 8 25 0   4     0   1   31 13                 44
736663 736663 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_6 28 11 13 1   2     0   1   35 21                       56 28 11 13 1   2     0   1   35 21                 56
736677 736677 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_6 2 14 11 0   0     0   1   22 6                       28 2 14 11 0   0     0   1   22 6                 28
736699 736699 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_6 1 34 16 0   0     0   0   22 29                       51 1 34 16 0   0     0   0   22 29                 51
736714 736714 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_6 21 20 38 1   26     0   3   56 53                       109 21 20 38 1   26     0   3   56 53                 109
736724 736724 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_6 1 20 13 0   1     0   5   20 20                       40 1 20 13 0   1     0   5   20 20                 40
736734 736734 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_6 0 15 9 0   2     0   0   13 13                       26 0 15 9 0   2     0   0   13 13                 26
736740 736740 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_6 1 77 26 1   5     0   0   57 53                       110 1 77 26 1   5     0   0   57 53                 110
736750 736750 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_6 2 22 27 0   0     0   1   34 18                       52 2 22 27 0   0     0   1   34 18                 52
736760 736760 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_6 4 4 10 0   0     0   0   13 5                       18 4 4 10 0   0     0   0   13 5                 18
736763 736763 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2015   grade_6 1 76 57 1   10     0   2   85 62                       147 1 76 57 1   10     0   2   85 62                 147
736776 736776 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_6 18 24 14 0   9     0   1   35 31                       66 18 24 14 0   9     0   1   35 31                 66
736782 736782 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2015   grade_6 15 13 86 0   7     0   0   69 52                       121 15 13 86 0   7     0   0   69 52                 121
736785 736785 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 06 08 2015   grade_6 23 31 47 1   7     0   4   61 52                       113 23 31 47 1   7     0   4   61 52                 113
736788 736788 MA Suffolk   school 2502790 35   Boston 250279000345 350470 Wm B Rogers Middle   Regular School No 2 06 08 2015   grade_6 2 39 32 0   0     0   0   41 32                       73 2 39 32 0   0     0   0   41 32                 73
736791 736791 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2015   grade_6 2 44 94 0   2     0   3   76 69                       145 2 44 94 0   2     0   3   76 69                 145
736919 736919 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_6 19 11 129 0   9     0   2   83 87                       170 19 11 129 0   9     0   2   83 87                 170
736922 736922 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_6 2 72 39 1   8     0   1   62 61                       123 2 72 39 1   8     0   1   62 61                 123
736947 736947 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2015   grade_6 4 1 34 0   0     0   0   19 20                       39 4 1 34 0   0     0   0   19 20                 39
736976 736976 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No 2 05 08 2015   grade_6 156 3 5 1   5     0   12   101 81                       182 156 3 5 1   5     0   12   101 81                 182
737032 737032 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No 2 06 08 2015   grade_6 194 16 6 0   37     0   3   138 118                       256 194 16 6 0   37     0   3   138 118                 256
737035 737035 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No 2 06 08 2015   grade_6 169 6 4 0   29     0   3   105 106                       211 169 6 4 0   29     0   3   105 106                 211
737058 737058 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2015   grade_6 33 0 1 0   1     0   0   19 16                       35 33 0 1 0   1     0   0   19 16                 35
737152 737152 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2015   grade_6 47 97 23 0   11     0   11   106 83                       189 47 97 23 0   11     0   11   106 83                 189
737158 737158 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2015   grade_6 65 63 15 0   2     0   6   72 79                       151 65 63 15 0   2     0   6   72 79                 151
737161 737161 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2015   grade_6 65 85 60 2   7     0   12   110 121                       231 65 85 60 2   7     0   12   110 121                 231
737184 737184 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 39 1 2 0   0     0   1   18 25                       43 39 1 2 0   0     0   1   18 25                 43
737202 737202 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   grade_6 52 5 11 0   6     0   8   44 38                       82 52 5 11 0   6     0   8   44 38                 82
737212 737212 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2015   grade_6 36 2 3 0   10     0   6   27 30                       57 36 2 3 0   10     0   6   27 30                 57
737222 737222 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2015   grade_6 40 1 4 0   9     0   1   23 32                       55 40 1 4 0   9     0   1   23 32                 55
737231 737231 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2015   grade_6 26 3 5 0   20     0   6   27 33                       60 26 3 5 0   20     0   6   27 33                 60
737240 737240 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2015   grade_6 31 4 9 0   14     0   5   37 26                       63 31 4 9 0   14     0   5   37 26                 63
737249 737249 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2015   grade_6 41 10 11 0   11     0   9   44 38                       82 41 10 11 0   11     0   9   44 38                 82
737259 737259 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2015   grade_6 30 2 6 0   11     0   6   27 28                       55 30 2 6 0   11     0   6   27 28                 55
737293 737293 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2015   grade_6 217 11 8 1   28     0   10   150 125                       275 217 11 8 1   28     0   10   150 125                 275
737316 737316 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   grade_6 10 2 9 0   0     0   4   7 18                       25 10 2 9 0   0     0   4   7 18                 25
737395 737395 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2015   grade_6 28 23 14 0   9     0   5   41 38                       79 28 23 14 0   9     0   5   41 38                 79
737398 737398 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2015   grade_6 38 23 5 2   16     0   8   59 33                       92 38 23 5 2   16     0   8   59 33                 92
737425 737425 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No 2 06 08 2015   grade_6 192 26 9 0   32     0   13   136 136                       272 192 26 9 0   32     0   13   136 136                 272
737439 737439 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   grade_6 59 1 0 0   7     0   5   39 33                       72 59 1 0 0   7     0   5   39 33                 72
737479 737479 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No 2 05 08 2015   grade_6 148 4 6 0   20     0   6   99 85                       184 148 4 6 0   20     0   6   99 85                 184
737483 737483 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_6 185 3 6 0   21     0   5   109 111                       220 185 3 6 0   21     0   5   109 111                 220
737509 737509 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_6 9 11 98 0   2     0   1   72 49                       121 9 11 98 0   2     0   1   72 49                 121
737513 737513 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_6 13 4 116 0   5     0   2   75 65                       140 13 4 116 0   5     0   2   75 65                 140
737517 737517 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_6 5 13 99 0   5     0   0   65 57                       122 5 13 99 0   5     0   0   65 57                 122
737584 737584 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_6 178 12 118 1   7     0   8   169 155                       324 178 12 118 1   7     0   8   169 155                 324
737587 737587 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Fairview Middle   Regular School No 2 06 08 2015   grade_6 125 5 60 1   11     0   9   104 107                       211 125 5 60 1   11     0   9   104 107                 211
737606 737606 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_6 17 0 1 0   0     0   0   7 11                       18 17 0 1 0   0     0   0   7 11                 18
737616 737616 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_6 101 9 27 0   2     0   3   72 70                       142 101 9 27 0   2     0   3   72 70                 142
737632 737632 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_6 136 6 1 0   5     0   0   75 73                       148 136 6 1 0   5     0   0   75 73                 148
737659 737659 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_6 196 12 10 0   14     0   8   120 120                       240 196 12 10 0   14     0   8   120 120                 240
737669 737669 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   grade_6 24 0 2 0   0     0   0   13 13                       26 24 0 2 0   0     0   0   13 13                 26
737701 737701 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2015   grade_6 247 4 18 0   6     0   7   140 142                       282 247 4 18 0   6     0   7   140 142                 282
737728 737728 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2015   grade_6 293 7 6 1   9     0   4   151 169                       320 293 7 6 1   9     0   4   151 169                 320
737759 737759 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2015   grade_6 178 14 24 1   4     0   9   119 111                       230 178 14 24 1   4     0   9   119 111                 230
737773 737773 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2015   grade_6 64 0 1 1   0     0   2   35 33                       68 64 0 1 1   0     0   2   35 33                 68
737819 737819 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No 2 06 08 2015   grade_6 260 17 22 0   14     0   4   165 152                       317 260 17 22 0   14     0   4   165 152                 317
737838 737838 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No 2 06 08 2015   grade_6 244 1 2 0   4     0   2   137 116                       253 244 1 2 0   4     0   2   137 116                 253
737852 737852 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2015   grade_6 173 3 0 1   3     0   5   85 100                       185 173 3 0 1   3     0   5   85 100                 185
737883 737883 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2015   grade_6 92 4 4 0   3     0   5   50 58                       108 92 4 4 0   3     0   5   50 58                 108
737924 737924 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2015   grade_6 253 17 11 1   8     0   9   146 153                       299 253 17 11 1   8     0   9   146 153                 299
737938 737938 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_6 34 1 2 2   0     0   0   17 22                       39 34 1 2 2   0     0   0   17 22                 39
737948 737948 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   1   6 8                       14 12 0 1 0   0     0   1   6 8                 14
737971 737971 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_6 36 14 27 0   4     0   4   44 41                       85 36 14 27 0   4     0   4   44 41                 85
737980 737980 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_6 45 14 38 1   13     0   3   58 56                       114 45 14 38 1   13     0   3   58 56                 114
737995 737995 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_6 32 22 28 0   8     0   3   42 51                       93 32 22 28 0   8     0   3   42 51                 93
738004 738004 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_6 30 26 39 0   1     0   2   50 48                       98 30 26 39 0   1     0   2   50 48                 98
738025 738025 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_6 124 2 8 2   5     0   2   77 66                       143 124 2 8 2   5     0   2   77 66                 143
738065 738065 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 06 2015   grade_6 40 7 16 0   6     0   5   31 43                       74 40 7 16 0   6     0   5   31 43                 74
738073 738073 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_6 29 2 21 0   3     0   4   32 27                       59 29 2 21 0   3     0   4   32 27                 59
738105 738105 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2015   grade_6 115 8 48 0   15     0   6   88 104                       192 115 8 48 0   15     0   6   88 104                 192
738111 738111 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2015   grade_6 166 10 44 0   7     0   7   116 118                       234 166 10 44 0   7     0   7   116 118                 234
738118 738118 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_6 2 2 4 0   0     0   1   8 *                       9 2 2 4 0   0     0   1   8                   9
738150 738150 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_6 242 10 8 4   6     0   20   141 149                       290 242 10 8 4   6     0   20   141 149                 290
738170 738170 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_6 58 13 76 0   7     0   16   70 100                       170 58 13 76 0   7     0   16   70 100                 170
738180 738180 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_6 33 7 65 0   3     0   13   63 58                       121 33 7 65 0   3     0   13   63 58                 121
738190 738190 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_6 38 6 41 0   3     0   6   43 51                       94 38 6 41 0   3     0   6   43 51                 94
738210 738210 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_6 6 0 0 0   0     0   0   1 5                       6 6 0 0 0   0     0   0   1 5                 6
738230 738230 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2015   grade_6 178 7 4 0   9     0   3   102 99                       201 178 7 4 0   9     0   3   102 99                 201
738287 738287 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2015   grade_6 115 12 39 0   2     0   6   89 85                       174 115 12 39 0   2     0   6   89 85                 174
738290 738290 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No 2 06 08 2015   grade_6 66 10 48 0   4     0   4   75 57                       132 66 10 48 0   4     0   4   75 57                 132
738293 738293 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_6 132 6 53 0   20     0   6   101 116                       217 132 6 53 0   20     0   6   101 116                 217
738337 738337 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2015   grade_6 139 2 1 0   7     0   1   76 74                       150 139 2 1 0   7     0   1   76 74                 150
738340 738340 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_6 143 4 4 1   6     0   4   90 72                       162 143 4 4 1   6     0   4   90 72                 162
738343 738343 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2015   grade_6 134 2 1 1   12     0   2   72 80                       152 134 2 1 1   12     0   2   72 80                 152
738361 738361 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_6 140 2 22 0   2     0   9   89 86                       175 140 2 22 0   2     0   9   89 86                 175
738380 738380 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_6 113 0 0 0   2     0   1   62 54                       116 113 0 0 0   2     0   1   62 54                 116
738437 738437 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_6 88 3 4 0   4     0   1   50 50                       100 88 3 4 0   4     0   1   50 50                 100
738442 738442 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_6 79 1 4 0   21     0   9   60 54                       114 79 1 4 0   21     0   9   60 54                 114
738452 738452 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No 2 04 06 2015   grade_6 52 1 5 0   3     0   0   35 26                       61 52 1 5 0   3     0   0   35 26                 61
738483 738483 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2015   grade_6 79 1 23 0   6     0   8   65 52                       117 79 1 23 0   6     0   8   65 52                 117
738498 738498 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_6 44 0 3 0   0     0   2   24 25                       49 44 0 3 0   0     0   2   24 25                 49
738512 738512 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_6 90 2 0 0   3     0   1   43 53                       96 90 2 0 0   3     0   1   43 53                 96
738519 738519 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6

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