enrollments

Data source: Big Local News · About: Big Local

986 rows where grade = "grade_1", state = "MA" and year = 2017 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 986 ✖

grade ✖

  • grade_1 · 986 ✖
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
1125187 1125187 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_1 * * * *   *     *   *   * *                       *                                              
1125261 1125261 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_1 * * * *   *     *   *   * *                       *                                              
1126446 1126446 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_1 * * * *   *     *   *   4 *                       *                         4                    
1132702 1132702 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   grade_1 6 0 1 0   0     0   0   5 *                       7 6 0 1 0   0     0   0   5                   7
1125316 1125316 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_1 * * * *   *     *   *   3 1                       *                         3 1                  
1128749 1128749 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_1 * * * *   *     *   *   2 1                       *                         2 1                  
1128900 1128900 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_1 6 0 0 0   0     0   0   5 1                       6 6 0 0 0   0     0   0   5 1                 6
1122839 1122839 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_1 7 9 4 0   1     0   1   12 10                       22 7 9 4 0   1     0   1   12 10                 22
1122958 1122958 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_1 13 7 4 0   1     0   1   16 10                       26 13 7 4 0   1     0   1   16 10                 26
1128051 1128051 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_1 15 0 5 0   0     0   1   11 10                       21 15 0 5 0   0     0   1   11 10                 21
1131374 1131374 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_1 18 0 1 0   0     0   1   10 10                       20 18 0 1 0   0     0   1   10 10                 20
1131806 1131806 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2017   grade_1 22 0 0 0   0     0   0   12 10                       22 22 0 0 0   0     0   0   12 10                 22
1132271 1132271 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   grade_1 14 0 1 0   0     0   0   5 10                       15 14 0 1 0   0     0   0   5 10                 15
1132583 1132583 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_1 19 0 0 0   0     0   1   10 10                       20 19 0 0 0   0     0   1   10 10                 20
1133197 1133197 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_1 15 3 3 1   1     0   4   17 10                       27 15 3 3 1   1     0   4   17 10                 27
1129971 1129971 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_1 156 10 15 2   2     0   30   115 100                       215 156 10 15 2   2     0   30   115 100                 215
1122332 1122332 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_1 123 11 15 0   35     0   16   99 101                       200 123 11 15 0   35     0   16   99 101                 200
1124480 1124480 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2017   grade_1 183 2 7 0   2     0   6   99 101                       200 183 2 7 0   2     0   6   99 101                 200
1125104 1125104 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   grade_1 118 6 35 1   4     0   17   80 101                       181 118 6 35 1   4     0   17   80 101                 181
1126601 1126601 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_1 182 4 21 0   24     0   14   143 102                       245 182 4 21 0   24     0   14   143 102                 245
1131900 1131900 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   grade_1 179 9 7 0   2     0   8   103 102                       205 179 9 7 0   2     0   8   103 102                 205
1128692 1128692 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   grade_1 199 3 8 0   5     1   0   107 109                       216 199 3 8 0   5     1   0   107 109                 216
1122889 1122889 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   grade_1 11 3 6 0   1     0   2   12 11                       23 11 3 6 0   1     0   2   12 11                 23
1123166 1123166 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_1 9 5 15 0   3     0   1   22 11                       33 9 5 15 0   3     0   1   22 11                 33
1124155 1124155 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_1 17 0 4 0   0     0   1   11 11                       22 17 0 4 0   0     0   1   11 11                 22
1125364 1125364 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_1 18 0 2 0   1     0   0   10 11                       21 18 0 2 0   1     0   0   10 11                 21
1130134 1130134 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_1 13 1 1 0   0     0   3   7 11                       18 13 1 1 0   0     0   3   7 11                 18
1130408 1130408 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No Elementary KG 05 2017   grade_1 22 0 2 0   3     0   3   19 11                       30 22 0 2 0   3     0   3   19 11                 30
1131266 1131266 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_1 0 17 5 0   0     0   0   11 11                       22 0 17 5 0   0     0   0   11 11                 22
1132300 1132300 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Essex Elementary   Regular School No Elementary KG 05 2017   grade_1 27 0 0 0   0     0   1   17 11                       28 27 0 0 0   0     0   1   17 11                 28
1132394 1132394 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_1 18 1 0 0   0     0   0   8 11                       19 18 1 0 0   0     0   0   8 11                 19
1132510 1132510 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No Elementary KG 04 2017   grade_1 35 0 0 0   0     0   0   24 11                       35 35 0 0 0   0     0   0   24 11                 35
1125648 1125648 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No Elementary KG 01 2017   grade_1 166 0 6 1   42     0   11   108 118                       226 166 0 6 1   42     0   11   108 118                 226
1122859 1122859 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   grade_1 10 9 7 0   3     0   2   19 12                       31 10 9 7 0   3     0   2   19 12                 31
1123570 1123570 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   grade_1 27 1 0 0   1     0   0   17 12                       29 27 1 0 0   1     0   0   17 12                 29
1127113 1127113 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_1 23 0 0 0   0     0   0   11 12                       23 23 0 0 0   0     0   0   11 12                 23
1132599 1132599 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2017   grade_1 24 0 0 0   0     0   0   12 12                       24 24 0 0 0   0     0   0   12 12                 24
1132622 1132622 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_1 24 0 3 0   0     0   1   16 12                       28 24 0 3 0   0     0   1   16 12                 28
1132746 1132746 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_1 24 0 2 0   0     0   1   15 12                       27 24 0 2 0   0     0   1   15 12                 27
1122916 1122916 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2017   grade_1 13 1 19 0   2     0   1   23 13                       36 13 1 19 0   2     0   1   23 13                 36
1124943 1124943 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2017   grade_1 32 2 0 2   2     0   0   25 13                       38 32 2 0 2   2     0   0   25 13                 38
1127345 1127345 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2017   grade_1 15 0 11 0   0     0   1   14 13                       27 15 0 11 0   0     0   1   14 13                 27
1127619 1127619 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No Elementary KG 05 2017   grade_1 21 1 4 0   2     0   2   17 13                       30 21 1 4 0   2     0   2   17 13                 30
1128461 1128461 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2017   grade_1 42 1 0 0   1     0   0   31 13                       44 42 1 0 0   1     0   0   31 13                 44
1131879 1131879 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Millville Elementary   Regular School No Elementary PK 05 2017   grade_1 35 0 3 0   0     0   1   26 13                       39 35 0 3 0   0     0   1   26 13                 39
1122559 1122559 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2017   grade_1 7 5 13 0   6     0   1   18 14                       32 7 5 13 0   6     0   1   18 14                 32
1122573 1122573 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2017   grade_1 1 7 20 0   0     0   3   17 14                       31 1 7 20 0   0     0   3   17 14                 31
1122591 1122591 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_1 8 3 6 0   0     0   3   6 14                       20 8 3 6 0   0     0   3   6 14                 20
1122985 1122985 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_1 17 6 1 0   3     0   2   15 14                       29 17 6 1 0   3     0   2   15 14                 29
1124208 1124208 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_1 17 0 0 0   0     0   1   4 14                       18 17 0 0 0   0     0   1   4 14                 18
1125748 1125748 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_1 19 1 0 0   0     0   0   6 14                       20 19 1 0 0   0     0   0   6 14                 20
1127238 1127238 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2017   grade_1 17 3 9 1   1     0   5   22 14                       36 17 3 9 1   1     0   5   22 14                 36
1128035 1128035 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2017   grade_1 35 1 0 0   0     0   0   22 14                       36 35 1 0 0   0     0   0   22 14                 36
1128138 1128138 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No Elementary KG 05 2017   grade_1 32 3 5 0   0     0   2   28 14                       42 32 3 5 0   0     0   2   28 14                 42
1128197 1128197 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Hedge   Regular School No Elementary KG 05 2017   grade_1 23 0 0 0   3     0   3   15 14                       29 23 0 0 0   3     0   3   15 14                 29
1129740 1129740 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_1 17 1 11 0   0     0   4   19 14                       33 17 1 11 0   0     0   4   19 14                 33
1129844 1129844 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   grade_1 21 0 0 1   0     0   0   8 14                       22 21 0 0 1   0     0   0   8 14                 22
1130096 1130096 MA Norfolk   school 2512270 317   Wellesley 251227002022 3170025 Hunnewell   Regular School No Elementary KG 05 2017   grade_1 29 4 2 0   3     0   2   26 14                       40 29 4 2 0   3     0   2   26 14                 40
1130384 1130384 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2017   grade_1 27 1 4 0   1     0   0   19 14                       33 27 1 4 0   1     0   0   19 14                 33
1131744 1131744 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_1 27 0 0 0   1     0   0   14 14                       28 27 0 0 0   1     0   0   14 14                 28
1132639 1132639 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   grade_1 21 0 2 0   0     0   1   10 14                       24 21 0 2 0   0     0   1   10 14                 24
1122444 1122444 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_1 28 0 2 1   0     0   2   18 15                       33 28 0 2 1   0     0   2   18 15                 33
1123539 1123539 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2017   grade_1 31 1 1 1   6     0   0   25 15                       40 31 1 1 1   6     0   0   25 15                 40
1125075 1125075 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   grade_1 32 0 0 0   0     0   0   17 15                       32 32 0 0 0   0     0   0   17 15                 32
1125293 1125293 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_1 27 0 5 0   0     1   2   20 15                       35 27 0 5 0   0     1   2   20 15                 35
1125546 1125546 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_1 13 2 17 0   1     0   2   20 15                       35 13 2 17 0   1     0   2   20 15                 35
1126454 1126454 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No Elementary KG 05 2017   grade_1 16 1 26 0   3     0   1   32 15                       47 16 1 26 0   3     0   1   32 15                 47
1127581 1127581 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_1 22 2 2 0   0     0   1   12 15                       27 22 2 2 0   0     0   1   12 15                 27
1127650 1127650 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary KG 05 2017   grade_1 36 0 2 0   2     0   2   27 15                       42 36 0 2 0   2     0   2   27 15                 42
1127778 1127778 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_1 35 0 0 0   0     0   0   20 15                       35 35 0 0 0   0     0   0   20 15                 35
1128115 1128115 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   grade_1 22 0 3 0   0     0   3   13 15                       28 22 0 3 0   0     0   3   13 15                 28
1129475 1129475 MA Norfolk   school 2511250 285   Stoughton 251125001858 2850010 Helen Hansen Elementary   Regular School No Elementary KG 05 2017   grade_1 22 5 4 0   2     0   2   20 15                       35 22 5 4 0   2     0   2   20 15                 35
1130803 1130803 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_1 3 5 15 0   2     0   1   11 15                       26 3 5 15 0   2     0   1   11 15                 26
1131727 1131727 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_1 11 2 3 0   24     0   0   25 15                       40 11 2 3 0   24     0   0   25 15                 40
1122613 1122613 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 02 2017   grade_1 2 28 7 0   3     0   2   26 16                       42 2 28 7 0   3     0   2   26 16                 42
1122736 1122736 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_1 20 5 13 0   0     0   3   25 16                       41 20 5 13 0   0     0   3   25 16                 41
1122950 1122950 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary KG 05 2017   grade_1 5 12 14 0   0     0   2   17 16                       33 5 12 14 0   0     0   2   17 16                 33
1123062 1123062 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   grade_1 8 13 6 0   3     0   2   16 16                       32 8 13 6 0   3     0   2   16 16                 32
1123078 1123078 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2017   grade_1 2 19 12 1   0     0   0   18 16                       34 2 19 12 1   0     0   0   18 16                 34
1123108 1123108 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2017   grade_1 10 17 9 0   6     0   0   26 16                       42 10 17 9 0   6     0   0   26 16                 42
1124511 1124511 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   grade_1 24 1 3 0   0     0   1   13 16                       29 24 1 3 0   0     0   1   13 16                 29
1124531 1124531 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No Elementary KG 04 2017   grade_1 27 0 6 0   0     0   5   22 16                       38 27 0 6 0   0     0   5   22 16                 38
1126686 1126686 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2017   grade_1 39 0 0 0   0     0   2   25 16                       41 39 0 0 0   0     0   2   25 16                 41
1127571 1127571 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_1 30 1 3 0   0     0   1   19 16                       35 30 1 3 0   0     0   1   19 16                 35
1128131 1128131 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2017   grade_1 31 6 10 1   0     0   4   36 16                       52 31 6 10 1   0     0   4   36 16                 52
1129173 1129173 MA Hampden   school 2511130 281   Springfield 251113001805 2810065 Glenwood   Regular School No Elementary KG 05 2017   grade_1 5 4 26 0   1     0   0   20 16                       36 5 4 26 0   1     0   0   20 16                 36
1129446 1129446 MA Middlesex   school 2511220 284   Stoneham 251122001851 2840005 Colonial Park   Regular School No Elementary PK 04 2017   grade_1 41 0 1 0   1     0   0   27 16                       43 41 0 1 0   1     0   0   27 16                 43
1130415 1130415 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Downey   Regular School No Elementary KG 05 2017   grade_1 31 0 2 0   8     0   1   26 16                       42 31 0 2 0   8     0   1   26 16                 42
1130915 1130915 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   grade_1 24 5 3 0   4     0   1   21 16                       37 24 5 3 0   4     0   1   21 16                 37
1132561 1132561 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2017   grade_1 34 0 1 0   0     0   1   20 16                       36 34 0 1 0   0     0   1   20 16                 36
1132706 1132706 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2017   grade_1 27 0 7 0   0     0   1   19 16                       35 27 0 7 0   0     0   1   19 16                 35
1132826 1132826 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_1 33 0 1 4   0     0   1   23 16                       39 33 0 1 4   0     0   1   23 16                 39
1133183 1133183 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_1 18 6 6 0   0     0   2   16 16                       32 18 6 6 0   0     0   2   16 16                 32
1122532 1122532 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2017   grade_1 28 2 2 0   1     0   1   17 17                       34 28 2 2 0   1     0   1   17 17                 34
1122807 1122807 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No Elementary PK 05 2017   grade_1 3 29 12 0   1     0   0   28 17                       45 3 29 12 0   1     0   0   28 17                 45
1122897 1122897 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_1 25 8 8 0   1     0   5   30 17                       47 25 8 8 0   1     0   5   30 17                 47
1124386 1124386 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_1 25 3 4 0   1     0   1   17 17                       34 25 3 4 0   1     0   1   17 17                 34
1124518 1124518 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2017   grade_1 37 0 5 0   0     0   0   25 17                       42 37 0 5 0   0     0   0   25 17                 42
1125156 1125156 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   grade_1 31 1 2 0   1     0   2   20 17                       37 31 1 2 0   1     0   2   20 17                 37
1126432 1126432 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lincoln-Thomson   Regular School No Elementary KG 05 2017   grade_1 9 0 18 0   2     0   1   13 17                       30 9 0 18 0   2     0   1   13 17                 30

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