enrollments

Data source: Big Local News · About: Big Local

894 rows where grade = "grade_5", state = "MA" and year = 2017 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 894 ✖

grade ✖

  • grade_5 · 894 ✖
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
1124817 1124817 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_5 3 0 1 0   0     0   2   6 *                       6 3 0 1 0   0     0   2   6                   6
1125191 1125191 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1125265 1125265 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_5 * * * *   *     *   *   * *                       *                                              
1126250 1126250 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_5 * * * *   *     *   *   2 *                       *                         2                    
1126450 1126450 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_5 2 1 6 0   0     0   1   10 *                       10 2 1 6 0   0     0   1   10                   10
1122674 1122674 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_5 * * * *   *     *   *   3 1                       *                         3 1                  
1123667 1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1124657 1124657 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_5 1 2 3 0   0     0   0   5 1                       6 1 2 3 0   0     0   0   5 1                 6
1126351 1126351 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1122893 1122893 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   grade_5 8 4 8 0   1     0   3   14 10                       24 8 4 8 0   1     0   3   14 10                 24
1123230 1123230 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_5 1 7 10 0   0     0   1   9 10                       19 1 7 10 0   0     0   1   9 10                 19
1123912 1123912 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2017   grade_5 11 7 3 0   1     0   1   13 10                       23 11 7 3 0   1     0   1   13 10                 23
1124285 1124285 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_5 23 0 0 0   0     0   1   14 10                       24 23 0 0 0   0     0   1   14 10                 24
1124613 1124613 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_5 19 0 1 0   0     0   2   12 10                       22 19 0 1 0   0     0   2   12 10                 22
1128941 1128941 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No Elementary KG 05 2017   grade_5 24 0 3 0   2     0   2   21 10                       31 24 0 3 0   2     0   2   21 10                 31
1129765 1129765 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_5 15 0 2 0   0     0   1   8 10                       18 15 0 2 0   0     0   1   8 10                 18
1131378 1131378 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_5 17 0 3 0   0     0   3   13 10                       23 17 0 3 0   0     0   3   13 10                 23
1131810 1131810 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2017   grade_5 19 0 4 0   0     0   0   13 10                       23 19 0 4 0   0     0   0   13 10                 23
1131948 1131948 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_5 17 0 0 0   0     0   1   8 10                       18 17 0 0 0   0     0   1   8 10                 18
1132131 1132131 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2017   grade_5 16 1 2 0   0     0   0   9 10                       19 16 1 2 0   0     0   0   9 10                 19
1124065 1124065 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_5 162 9 11 0   32     2   2   118 100                       218 162 9 11 0   32     2   2   118 100                 218
1129683 1129683 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2017   grade_5 156 31 18 1   2     0   13   121 100                       221 156 31 18 1   2     0   13   121 100                 221
1131912 1131912 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Elementary 04 06 2017   grade_5 215 8 6 0   1     0   13   142 101                       243 215 8 6 0   1     0   13   142 101                 243
1126629 1126629 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 04 06 2017   grade_5 171 11 17 2   3     0   8   108 104                       212 171 11 17 2   3     0   8   108 104                 212
1132164 1132164 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2017   grade_5 183 2 1 1   9     1   4   97 104                       201 183 2 1 1   9     1   4   97 104                 201
1131555 1131555 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_5 3 137 93 0   6     1   4   139 105                       244 3 137 93 0   6     1   4   139 105                 244
1125106 1125106 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   grade_5 152 6 28 0   3     0   19   102 106                       208 152 6 28 0   3     0   19   102 106                 208
1122989 1122989 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_5 12 6 4 0   1     0   0   12 11                       23 12 6 4 0   1     0   0   12 11                 23
1123170 1123170 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_5 5 6 12 0   2     0   2   16 11                       27 5 6 12 0   2     0   2   16 11                 27
1128055 1128055 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_5 15 1 1 0   0     0   1   7 11                       18 15 1 1 0   0     0   1   7 11                 18
1131270 1131270 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_5 0 16 3 0   0     0   0   8 11                       19 0 16 3 0   0     0   0   8 11                 19
1131454 1131454 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_5 15 2 0 0   0     0   1   7 11                       18 15 2 0 0   0     0   1   7 11                 18
1131883 1131883 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Millville Elementary   Regular School No Elementary PK 05 2017   grade_5 28 0 2 0   0     0   0   19 11                       30 28 0 2 0   0     0   0   19 11                 30
1132398 1132398 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_5 15 0 2 0   0     0   0   6 11                       17 15 0 2 0   0     0   0   6 11                 17
1122353 1122353 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_5 167 4 13 0   2     0   5   81 110                       191 167 4 13 0   2     0   5   81 110                 191
1125654 1125654 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No Elementary 04 05 2017   grade_5 182 3 5 1   25     0   10   115 111                       226 182 3 5 1   25     0   10   115 111                 226
1125523 1125523 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2017   grade_5 196 2 10 1   13     0   3   113 112                       225 196 2 10 1   13     0   3   113 112                 225
1126290 1126290 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2017   grade_5 66 13 88 0   33     0   6   89 117                       206 66 13 88 0   33     0   6   89 117                 206
1127172 1127172 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_5 211 4 5 0   17     0   15   133 119                       252 211 4 5 0   17     0   15   133 119                 252
1129724 1129724 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 John F. Ryan   Regular School No Middle 05 06 2017   grade_5 237 8 4 1   8     1   2   142 119                       261 237 8 4 1   8     1   2   142 119                 261
1122448 1122448 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_5 30 0 1 0   1     0   4   24 12                       36 30 0 1 0   1     0   4   24 12                 36
1122740 1122740 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_5 4 9 9 0   0     0   1   11 12                       23 4 9 9 0   0     0   1   11 12                 23
1122759 1122759 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2017   grade_5 0 17 11 0   1     0   1   18 12                       30 0 17 11 0   1     0   1   18 12                 30
1122767 1122767 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2017   grade_5 1 16 8 0   1     0   2   16 12                       28 1 16 8 0   1     0   2   16 12                 28
1122843 1122843 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_5 1 8 10 0   0     0   0   7 12                       19 1 8 10 0   0     0   0   7 12                 19
1123029 1123029 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2017   grade_5 2 0 20 0   1     0   0   11 12                       23 2 0 20 0   1     0   0   11 12                 23
1128634 1128634 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No Elementary KG 05 2017   grade_5 23 2 9 0   0     0   4   26 12                       38 23 2 9 0   0     0   4   26 12                 38
1128904 1128904 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_5 17 0 0 0   0     0   1   6 12                       18 17 0 0 0   0     0   1   6 12                 18
1130522 1130522 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_5 18 0 1 0   0     0   1   8 12                       20 18 0 1 0   0     0   1   8 12                 20
1130531 1130531 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_5 27 0 0 0   0     0   0   15 12                       27 27 0 0 0   0     0   0   15 12                 27
1124476 1124476 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2017   grade_5 220 0 3 0   5     0   11   118 121                       239 220 0 3 0   5     0   11   118 121                 239
1125685 1125685 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2017   grade_5 198 0 20 0   7     0   4   108 121                       229 198 0 20 0   7     0   4   108 121                 229
1129832 1129832 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_5 205 7 16 0   9     0   7   123 121                       244 205 7 16 0   9     0   7   123 121                 244
1122003 1122003 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_5 243 8 16 0   12     0   11   162 128                       290 243 8 16 0   12     0   11   162 128                 290
1131997 1131997 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2017   grade_5 170 18 30 6   5     0   13   113 129                       242 170 18 30 6   5     0   13   113 129                 242
1122666 1122666 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2017   grade_5 4 0 34 0   0     0   0   25 13                       38 4 0 34 0   0     0   0   25 13                 38
1122962 1122962 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_5 3 8 7 0   2     0   2   9 13                       22 3 8 7 0   2     0   2   9 13                 22
1123074 1123074 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2017   grade_5 4 1 23 0   0     0   0   15 13                       28 4 1 23 0   0     0   0   15 13                 28
1123082 1123082 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2017   grade_5 0 14 7 0   0     0   2   10 13                       23 0 14 7 0   0     0   2   10 13                 23
1123920 1123920 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2017   grade_5 11 15 5 1   4     0   5   28 13                       41 11 15 5 1   4     0   5   28 13                 41
1123936 1123936 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2017   grade_5 9 4 3 0   4     0   1   8 13                       21 9 4 3 0   4     0   1   8 13                 21
1126436 1126436 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lincoln-Thomson   Regular School No Elementary KG 05 2017   grade_5 6 0 16 0   9     0   3   21 13                       34 6 0 16 0   9     0   3   21 13                 34
1127326 1127326 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2017   grade_5 11 7 9 0   0     0   3   17 13                       30 11 7 9 0   0     0   3   17 13                 30
1128015 1128015 MA Essex   school 2509360 229   Peabody 250936001821 2290016 John E. McCarthy   Regular School No Elementary PK 05 2017   grade_5 31 0 3 0   2     0   1   24 13                       37 31 0 3 0   2     0   1   24 13                 37
1128039 1128039 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2017   grade_5 28 0 0 0   1     0   0   16 13                       29 28 0 0 0   1     0   0   16 13                 29
1130251 1130251 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No Elementary KG 05 2017   grade_5 22 0 3 0   0     0   1   13 13                       26 22 0 3 0   0     0   1   13 13                 26
1130716 1130716 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No Elementary KG 05 2017   grade_5 17 5 5 0   6     0   0   20 13                       33 17 5 5 0   6     0   0   20 13                 33
1130807 1130807 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_5 4 3 17 0   1     0   3   15 13                       28 4 3 17 0   1     0   3   15 13                 28
1131939 1131939 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_5 19 0 0 0   0     0   0   6 13                       19 19 0 0 0   0     0   0   6 13                 19
1132493 1132493 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2017   grade_5 18 0 2 0   0     0   1   8 13                       21 18 0 2 0   0     0   1   8 13                 21
1132587 1132587 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_5 26 1 0 0   0     0   2   16 13                       29 26 1 0 0   0     0   2   16 13                 29
1132830 1132830 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_5 30 1 0 0   0     0   4   22 13                       35 30 1 0 0   0     0   4   22 13                 35
1128697 1128697 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_5 231 0 4 0   2     0   1   108 130                       238 231 0 4 0   2     0   1   108 130                 238
1132107 1132107 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No Elementary 03 05 2017   grade_5 245 2 3 1   0     0   3   122 132                       254 245 2 3 1   0     0   3   122 132                 254
1124585 1124585 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson Olmsted School   Regular School No Elementary 03 05 2017   grade_5 249 11 10 0   10     0   4   151 133                       284 249 11 10 0   10     0   4   151 133                 284
1129697 1129697 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2017   grade_5 201 22 28 0   4     2   12   135 134                       269 201 22 28 0   4     2   12   135 134                 269
1124856 1124856 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2017   grade_5 216 20 16 2   3     1   15   138 135                       273 216 20 16 2   3     1   15   138 135                 273
1124515 1124515 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   grade_5 24 3 0 0   1     0   0   14 14                       28 24 3 0 0   1     0   0   14 14                 28
1125368 1125368 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_5 29 1 0 0   0     0   0   16 14                       30 29 1 0 0   0     0   0   16 14                 30
1126458 1126458 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No Elementary KG 05 2017   grade_5 13 4 18 0   1     0   2   24 14                       38 13 4 18 0   1     0   2   24 14                 38
1126466 1126466 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No Elementary PK 05 2017   grade_5 14 5 8 0   0     0   4   17 14                       31 14 5 8 0   0     0   4   17 14                 31
1127363 1127363 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No Elementary KG 05 2017   grade_5 23 2 6 0   0     0   0   17 14                       31 23 2 6 0   0     0   0   17 14                 31
1128553 1128553 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_5 24 1 1 0   0     0   1   13 14                       27 24 1 1 0   0     0   1   13 14                 27
1128992 1128992 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   grade_5 14 8 6 0   1     0   1   16 14                       30 14 8 6 0   1     0   1   16 14                 30
1129305 1129305 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No Elementary PK 05 2017   grade_5 6 5 25 0   0     0   0   22 14                       36 6 5 25 0   0     0   0   22 14                 36
1130672 1130672 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Daniel P Hurld   Regular School No Elementary KG 05 2017   grade_5 29 3 2 0   0     0   0   20 14                       34 29 3 2 0   0     0   0   20 14                 34
1130911 1130911 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   grade_5 11 5 14 1   0     0   0   17 14                       31 11 5 14 1   0     0   0   17 14                 31
1131236 1131236 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 05 2017   grade_5 1 0 31 0   0     0   0   18 14                       32 1 0 31 0   0     0   0   18 14                 32
1126606 1126606 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No Elementary 03 05 2017   grade_5 240 15 13 0   21     0   8   155 142                       297 240 15 13 0   21     0   8   155 142                 297
1130157 1130157 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No Elementary 04 06 2017   grade_5 178 3 19 0   91     1   10   153 149                       302 178 3 19 0   91     1   10   153 149                 302
1122901 1122901 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_5 24 2 11 0   1     0   1   24 15                       39 24 2 11 0   1     0   1   24 15                 39
1123208 1123208 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_5 1 17 8 0   0     0   1   12 15                       27 1 17 8 0   0     0   1   12 15                 27
1124390 1124390 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_5 31 1 5 0   2     0   1   25 15                       40 31 1 5 0   2     0   1   25 15                 40
1127349 1127349 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2017   grade_5 24 3 11 0   1     0   0   24 15                       39 24 3 11 0   1     0   0   24 15                 39
1127516 1127516 MA Middlesex   school 2508610 207   Newton 250861001382 2070125 Williams   Regular School No Elementary KG 05 2017   grade_5 25 0 5 0   9     0   0   24 15                       39 25 0 5 0   9     0   0   24 15                 39
1128268 1128268 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   grade_5 31 0 0 0   1     0   0   17 15                       32 31 0 0 0   1     0   0   17 15                 32
1129254 1129254 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No Elementary PK 05 2017   grade_5 5 8 21 0   0     0   1   20 15                       35 5 8 21 0   0     0   1   20 15                 35
1129261 1129261 MA Hampden   school 2511130 281   Springfield 251113001818 2810140 Mary M Lynch   Regular School No Elementary KG 05 2017   grade_5 6 5 23 0   0     0   0   19 15                       34 6 5 23 0   0     0   0   19 15                 34
1127009 1127009 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_5 217 6 82 8   10     0   10   182 151                       333 217 6 82 8   10     0   10   182 151                 333
1122683 1122683 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2017   grade_5 2 13 29 0   0     0   0   28 16                       44 2 13 29 0   0     0   0   28 16                 44

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