Data source: Big Local News · About: Big Local

592 rows where grade = "grade_6", state = "MA" and year = 2021 sorted by disability

View and edit SQL

year

  • 2021 · 492

grade

  • grade_6 · 492
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
1673543 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline - Lawrence   Regular School No Elementary KG 08 2021   grade_6 29 4 7 0   16     0   5   29 32 *                     61.0 29 4 7 0   16     0   5   29 32                 61
1673552 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_6 31 7 6 0   15     0   4   25 38 *                     63.0 31 7 6 0   15     0   4   25 38                 63
1673561 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline - Pierce   Regular School No Elementary KG 08 2021   grade_6 44 1 13 0   24     0   11   46 46 *                     93.0 44 1 13 0   24     0   11   46 46                 93
1673571 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_6 34 4 8 0   7     0   2   26 29 *                     55.0 34 4 8 0   7     0   2   26 29                 55
1673604 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington - Marshall Simonds Middle   Regular School No Middle 06 08 2021   grade_6 170 15 12 0   51     0   8   138 118 *                     256.0 170 15 12 0   51     0   8   138 118                 256
1673626 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_6 10 2 21 0   1     0   5   21 18 *                     39.0 10 2 21 0   1     0   5   21 18                 39
1673699 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge - Cambridge Street Upper School   Regular School No Middle 06 08 2021   grade_6 49 20 14 0   13     0   11   63 44 *                     107.0 49 20 14 0   13     0   11   63 44                 107
1673702 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge - Putnam Avenue Upper School   Regular School No Middle 06 08 2021   grade_6 21 32 8 1   14     0   12   47 41 *                     88.0 21 32 8 1   14     0   12   47 41                 88
1673705 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Cambridge - Rindge Avenue Upper School   Regular School No Middle 06 08 2021   grade_6 47 18 12 0   7     0   6   54 36 *                     90.0 47 18 12 0   7     0   6   54 36                 90
1673708 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge - Vassal Lane Upper School   Regular School No Middle 06 08 2021   grade_6 36 23 12 0   19     0   10   51 49 *                     100.0 36 23 12 0   19     0   10   51 49                 100
1673735 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton - Wm H Galvin Middle   Regular School No Middle 06 08 2021   grade_6 146 26 16 0   34     3   17   117 125 *                     242.0 146 26 16 0   34     3   17   117 125                 242
1673750 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_6 43 0 3 0   9     0   11   34 32 *                     66.0 43 0 3 0   9     0   11   34 32                 66
1673760 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_6 105 4 2 1   1     0   1   51 63 *                     114.0 105 4 2 1   1     0   1   51 63                 114
1673789 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford - Col Moses Parker School   Regular School No Middle 05 08 2021   grade_6 130 13 15 0   22     0   7   100 87 *                     187.0 130 13 15 0   22     0   7   100 87                 187
1673793 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_6 129 5 17 0   28     1   16   99 97 *                     196.0 129 5 17 0   28     1   16   99 97                 196
1673816 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_6 1 0 37 0   0     0   1   16 23 *                     39.0 1 0 37 0   0     0   1   16 23                 39
1673822 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_6 7 6 117 0   1     0   2   64 69 *                     133.0 7 6 117 0   1     0   2   64 69                 133
1673826 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea - Clark Avenue School   Regular School No Middle 05 08 2021   grade_6 13 6 155 0   1     0   2   92 85 *                     177.0 13 6 155 0   1     0   2   92 85                 177
1673830 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_6 10 8 99 0   0     0   6   66 57 *                     123.0 10 8 99 0   0     0   6   66 57                 123
1673896 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee - Bellamy Middle   Regular School No Middle 06 08 2021   grade_6 129 12 115 0   2     0   9   134 132 *                     267.0 129 12 115 0   2     0   9   134 132                 267
1673899 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee - Dupont Middle   Regular School No Middle 06 08 2021   grade_6 124 12 103 0   5     0   9   136 117 *                     253.0 124 12 103 0   5     0   9   136 117                 253
1673916 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_6 20 0 0 0   0     0   0   11 9 *                     20.0 20 0 0 0   0     0   0   11 9                 20
1673926 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton - Clinton Middle School   Regular School No Middle 05 08 2021   grade_6 67 5 57 0   0     0   4   69 64 *                     133.0 67 5 57 0   0     0   4   69 64                 133
1673941 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_6 105 5 0 0   3     0   6   58 61 *                     119.0 105 5 0 0   3     0   6   58 61                 119
1673969 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_6 159 9 15 0   11     0   21   114 101 *                     215.0 159 9 15 0   11     0   21   114 101                 215
1673979 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   grade_6 16 0 1 0   0     0   0   10 7 *                     17.0 16 0 1 0   0     0   0   10 7                 17
1674012 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers - Holten Richmond Middle School   Regular School No Middle 06 08 2021   grade_6 233 1 29 0   8     0   2   141 132 *                     273.0 233 1 29 0   8     0   2   141 132                 273
1674040 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth - Dartmouth Middle   Regular School No Middle 06 08 2021   grade_6 241 4 16 0   3     0   20   148 136 *                     284.0 241 4 16 0   3     0   20   148 136                 284
1674069 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham - Dedham Middle School   Regular School No Middle 06 08 2021   grade_6 135 19 32 0   7     0   10   100 103 *                     203.0 135 19 32 0   7     0   10   100 103                 203
1674084 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield - Deerfield Elementary   Regular School No Elementary PK 06 2021   grade_6 40 0 5 0   0     0   4   23 26 *                     49.0 40 0 5 0   0     0   4   23 26                 49
1674092 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas - Douglas Middle School   Regular School No Middle 06 08 2021   grade_6 82 1 4 0   0     0   2   47 42 *                     89.0 82 1 4 0   0     0   2   47 42                 89
1674131 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Dracut - Justus C. Richardson Middle School   Regular School No Middle 06 08 2021   grade_6 207 23 42 0   14     0   8   170 123 *                     294.0 207 23 42 0   14     0   8   170 123                 294
1674146 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury - Duxbury Middle   Regular School No Middle 06 08 2021   grade_6 171 1 4 0   3     0   15   101 93 *                     194.0 171 1 4 0   3     0   15   101 93                 194
1674160 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater - Gordon W. Mitchell School   Regular School No Elementary 03 06 2021   grade_6 128 8 7 1   0     0   5   76 73 *                     149.0 128 8 7 1   0     0   5   76 73                 149
1674191 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton - White Brook Middle School   Regular School No Middle 05 08 2021   grade_6 85 1 18 0   3     0   3   54 56 *                     110.0 85 1 18 0   3     0   3   54 56                 110
1674209 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 East Longmeadow - Birchland Park   Regular School No Middle 06 08 2021   grade_6 137 11 27 1   9     0   8   118 75 *                     193.0 137 11 27 1   9     0   8   118 75                 193
1674230 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton - Easton Middle School   Regular School No Middle 06 08 2021   grade_6 224 29 22 0   7     1   11   150 144 *                     294.0 224 29 22 0   7     1   11   150 144                 294
1674245 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_6 32 3 14 4   1     0   1   26 29 *                     55.0 32 3 14 4   1     0   1   26 29                 55
1674255 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving - Erving Elementary   Regular School No Elementary PK 06 2021   grade_6 6 0 0 0   0     0   3   3 6 *                     9.0 6 0 0 0   0     0   3   3 6                 9
1674264 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett - Sumner G. Whittier School   Regular School No Elementary KG 08 2021   grade_6 10 10 56 0   2     0   0   38 40 *                     78.0 10 10 56 0   2     0   0   38 40                 78
1674279 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett - Madeline English School   Regular School No Elementary KG 08 2021   grade_6 22 8 50 0   4     0   0   44 40 *                     84.0 22 8 50 0   4     0   0   44 40                 84
1674288 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_6 19 16 75 0   4     0   2   58 58 *                     116.0 19 16 75 0   4     0   2   58 58                 116
1674294 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_6 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1674307 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_6 37 12 57 0   12     0   3   67 54 *                     121.0 37 12 57 0   12     0   3   67 54                 121
1674316 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_6 17 18 73 0   1     0   3   55 57 *                     112.0 17 18 73 0   1     0   3   55 57                 112
1674337 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_6 133 4 9 3   2     0   9   78 82 *                     160.0 133 4 9 3   2     0   9   78 82                 160
1674379 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_6 30 12 24 0   8     0   8   39 43 *                     82.0 30 12 24 0   8     0   8   39 43                 82
1674389 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_6 25 8 9 0   1     0   7   22 28 *                     50.0 25 8 9 0   1     0   7   22 28                 50
1674418 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River - Talbot Innovation School   Regular School No Middle 06 08 2021   grade_6 70 14 71 1   6     0   22   84 100 *                     184.0 70 14 71 1   6     0   22   84 100                 184
1674421 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River - Morton Middle   Regular School No Middle 06 08 2021   grade_6 136 15 57 0   3     0   14   125 100 *                     225.0 136 15 57 0   3     0   14   125 100                 225
1674424 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River - Matthew J Kuss Middle   Regular School No Middle 06 08 2021   grade_6 121 22 59 0   9     0   26   124 113 *                     237.0 121 22 59 0   9     0   26   124 113                 237
1674430 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_6 3 1 1 0   0     0   1   4 2 *                     6.0 3 1 1 0   0     0   1   4 2                 6
1674470 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth - Morse Pond School   Regular School No Middle 05 06 2021   grade_6 207 14 12 1   4     0   10   120 128 *                     248.0 207 14 12 1   4     0   10   120 128                 248
1674491 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg - Memorial Middle School   Regular School No Middle 05 08 2021   grade_6 54 11 84 0   5     0   16   76 94 *                     170.0 54 11 84 0   5     0   16   76 94                 170
1674501 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg - Arthur M Longsjo Middle School   Regular School No Middle 05 08 2021   grade_6 32 10 108 0   7     0   12   81 88 *                     169.0 32 10 108 0   7     0   12   81 88                 169
1674511 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg - McKay Arts Academy   Regular School No Elementary PK 08 2021   grade_6 27 5 32 0   7     0   6   33 44 *                     77.0 27 5 32 0   7     0   6   33 44                 77
1674530 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_6 * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
1674550 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_6 132 8 12 1   12     0   8   89 84 *                     173.0 132 8 12 1   12     0   8   89 84                 173
1674613 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham - Cameron Middle School   Regular School No Middle 06 08 2021   grade_6 121 10 36 0   4     0   8   94 85 *                     179.0 121 10 36 0   4     0   8   94 85                 179
1674616 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham - Fuller Middle   Regular School No Middle 06 08 2021   grade_6 65 13 100 0   3     0   8   102 87 *                     189.0 65 13 100 0   3     0   8   102 87                 189
1674619 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_6 126 16 91 0   20     0   3   120 136 *                     256.0 126 16 91 0   20     0   3   120 136                 256
1674663 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin - Annie Sullivan Middle School   Regular School No Middle 06 08 2021   grade_6 83 0 3 0   4     1   1   50 42 *                     92.0 83 0 3 0   4     1   1   50 42                 92
1674666 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_6 112 2 8 0   14     1   1   78 60 *                     138.0 112 2 8 0   14     1   1   78 60                 138
1674669 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_6 101 1 8 0   4     2   2   54 64 *                     118.0 101 1 8 0   4     2   2   54 64                 118
1674684 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_6 119 4 39 1   1     0   27   109 82 *                     191.0 119 4 39 1   1     0   27   109 82                 191
1674703 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_6 75 2 2 0   1     0   2   42 40 *                     82.0 75 2 2 0   1     0   2   42 40                 82
1674741 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester - Ralph B O'Maley Middle   Regular School No Middle 06 08 2021   grade_6 170 1 27 1   5     0   2   112 94 *                     206.0 170 1 27 1   5     0   2   112 94                 206
1674756 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1674774 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 114 0 10 0   13     0   6   74 69 *                     143.0 114 0 10 0   13     0   6   74 69                 143
1674779 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton - Millbury Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 98 0 15 0   29     0   1   76 67 *                     143.0 98 0 15 0   29     0   1   76 67                 143
1674793 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby - East Meadow   Regular School No Elementary PK 06 2021   grade_6 40 0 4 0   0     0   1   19 26 *                     45.0 40 0 4 0   0     0   1   19 26                 45
1674817 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield - Greenfield Middle   Regular School No Middle 05 07 2021   grade_6 79 4 29 0   1     0   6   53 66 *                     119.0 79 4 29 0   1     0   6   53 66                 119
1674831 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley - Hadley Elementary   Regular School No Elementary PK 06 2021   grade_6 26 3 3 0   1     1   1   17 18 *                     35.0 26 3 3 0   1     1   1   17 18                 35
1674844 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_6 70 1 5 1   0     0   4   46 35 *                     81.0 70 1 5 1   0     0   4   46 35                 81
1674852 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_6 11 0 0 0   0     0   1   6 6 *                     12.0 11 0 0 0   0     0   1   6 6                 12
1674860 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_6 193 6 7 0   3     0   3   106 106 *                     212.0 193 6 7 0   3     0   3   106 106                 212
1674875 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard - Bromfield   Regular School No High 06 12 2021   grade_6 61 1 2 0   9     0   4   39 38 *                     77.0 61 1 2 0   9     0   4   39 38                 77
1674889 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield - Hatfield Elementary   Regular School No Elementary PK 06 2021   grade_6 34 0 3 0   0     0   0   21 16 *                     37.0 34 0 3 0   0     0   0   21 16                 37
1674912 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_6 113 6 40 0   3     0   5   90 77 *                     167.0 113 6 40 0   3     0   5   90 77                 167
1674922 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill - Dr Paul Nettle   Regular School No Middle 05 08 2021   grade_6 72 8 93 0   6     0   6   103 82 *                     185.0 72 8 93 0   6     0   6   103 82                 185
1674936 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill - TEACH   Regular School No Other 02 11 2021   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1674946 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_6 69 2 38 1   1     0   1   63 49 *                     112.0 69 2 38 1   1     0   1   63 49                 112
1674950 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_6 95 12 108 0   7     0   12   131 103 *                     234.0 95 12 108 0   7     0   12   131 103                 234
1674989 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_6 265 9 13 0   3     0   8   144 153 *                     298.0 265 9 13 0   3     0   8   144 153                 298
1675004 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   grade_6 49 21 10 0   4     0   5   48 41 *                     89.0 49 21 10 0   4     0   5   48 41                 89
1675019 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland - Holland Elementary   Regular School No Elementary PK 06 2021   grade_6 28 0 3 0   0     0   0   15 16 *                     31.0 28 0 3 0   0     0   0   15 16                 31
1675027 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston - Robert H. Adams Middle School   Regular School No Middle 06 08 2021   grade_6 174 3 12 0   29     0   9   113 114 *                     227.0 174 3 12 0   29     0   9   113 114                 227
1675041 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke - Joseph Metcalf School   Regular School No Elementary PK 06 2021   grade_6 6 1 25 0   0     0   0   9 23 *                     32.0 6 1 25 0   0     0   0   9 23                 32
1675049 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_6 13 0 25 0   2     0   1   19 22 *                     41.0 13 0 25 0   2     0   1   19 22                 41
1675060 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke - William R. Peck School   Regular School No Middle 04 08 2021   grade_6 3 2 41 0   0     0   2   21 27 *                     48.0 3 2 41 0   0     0   2   21 27                 48
1675084 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke - Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2021   grade_6 8 2 41 0   1     0   0   27 25 *                     52.0 8 2 41 0   1     0   0   27 25                 52
1675101 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_6 3 5 90 0   1     0   1   61 39 *                     100.0 3 5 90 0   1     0   1   61 39                 100
1675103 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke - Holyoke STEM Academy   Regular School No Middle 06 08 2021   grade_6 13 2 80 0   0     0   0   51 44 *                     95.0 13 2 80 0   0     0   0   51 44                 95
1675117 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale - Memorial   Regular School No Elementary KG 06 2021   grade_6 67 0 8 0   1     0   1   38 39 *                     77.0 67 0 8 0   1     0   1   38 39                 77
1675131 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton - Hopkinton Middle School   Regular School No Middle 06 08 2021   grade_6 210 3 8 2   66     0   14   161 142 *                     303.0 210 3 8 2   66     0   14   161 142                 303
1675157 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson - David J. Quinn Middle School   Regular School No Middle 05 07 2021   grade_6 124 7 29 0   2     0   1   75 88 *                     163.0 124 7 29 0   2     0   1   75 88                 163
1675171 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull - Memorial Middle   Regular School No Middle 06 08 2021   grade_6 57 0 1 0   1     0   2   29 32 *                     61.0 57 0 1 0   1     0   2   29 32                 61
1675191 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_6 97 1 5 0   4     0   6   53 60 *                     113.0 97 1 5 0   4     0   6   53 60                 113
1675204 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston - Kingston Intermediate   Regular School No Elementary 03 06 2021   grade_6 141 3 4 1   0     0   1   77 73 *                     150.0 141 3 4 1   0     0   1   77 73                 150
1675225 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_6 4 0 81 0   1     0   0   34 52 *                     86.0 4 0 81 0   1     0   0   34 52                 86

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