enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1125188 1125188 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1125262 1125262 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_2 * * * *   *     *   *   * *                       *                                              
1124814 1124814 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1126247 1126247 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_2 * * * *   *     *   *   1 *                       *                         1                    
1126349 1126349 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_2 * * * *   *     *   *   1 1                       *                         1 1                  
1124282 1124282 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_2 14 0 1 0   0     0   0   10 5                       15 14 0 1 0   0     0   0   10 5                 15
1125294 1125294 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_2 23 1 1 0   0     1   0   10 16                       26 23 1 1 0   0     1   0   10 16                 26
1130519 1130519 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_2 15 0 0 0   0     0   1   10 6                       16 15 0 0 0   0     0   1   10 6                 16
1132272 1132272 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   grade_2 15 0 1 0   0     0   1   10 7                       17 15 0 1 0   0     0   1   10 7                 17
1132395 1132395 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_2 19 0 0 0   0     0   0   10 9                       19 19 0 0 0   0     0   0   10 9                 19
1132584 1132584 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_2 20 0 0 0   0     0   2   10 12                       22 20 0 0 0   0     0   2   10 12                 22
1132747 1132747 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_2 16 0 1 1   0     0   2   10 10                       20 16 0 1 1   0     0   2   10 10                 20
1126783 1126783 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2017   grade_2 148 2 14 3   5     0   2   102 72                       174 148 2 14 3   5     0   2   102 72                 174
1122333 1122333 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_2 137 14 10 0   35     0   10   103 103                       206 137 14 10 0   35     0   10   103 103                 206
1125098 1125098 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_2 129 6 30 1   0     0   24   103 87                       190 129 6 30 1   0     0   24   103 87                 190
1122188 1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
1125528 1125528 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2017   grade_2 174 3 9 0   24     0   9   106 113                       219 174 3 9 0   24     0   9   106 113                 219
1124085 1124085 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_2 19 15 162 0   1     0   3   107 93                       200 19 15 162 0   1     0   3   107 93                 200
1124553 1124553 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2017   grade_2 144 4 19 0   10     0   5   109 73                       182 144 4 19 0   10     0   5   109 73                 182
1122592 1122592 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_2 11 4 9 0   0     0   0   11 13                       24 11 4 9 0   0     0   0   11 13                 24
1122959 1122959 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_2 12 4 2 0   3     0   1   11 11                       22 12 4 2 0   3     0   1   11 11                 22
1124209 1124209 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_2 18 0 1 0   0     0   0   11 8                       19 18 0 1 0   0     0   0   11 8                 19
1128265 1128265 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   grade_2 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
1130744 1130744 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_2 11 0 8 0   2     0   1   11 11                       22 11 0 8 0   2     0   1   11 11                 22
1131267 1131267 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_2 0 19 1 0   0     0   1   11 10                       21 0 19 1 0   0     0   1   11 10                 21
1131375 1131375 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_2 17 0 1 0   0     0   3   11 10                       21 17 0 1 0   0     0   3   11 10                 21
1131937 1131937 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_2 17 0 1 1   0     0   0   11 8                       19 17 0 1 1   0     0   0   11 8                 19
1132426 1132426 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary PK 04 2017   grade_2 14 0 2 0   0     0   1   11 6                       17 14 0 2 0   0     0   1   11 6                 17
1132623 1132623 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_2 21 0 2 1   0     0   0   11 13                       24 21 0 2 1   0     0   0   11 13                 24
1131901 1131901 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   grade_2 178 16 8 0   2     0   9   114 99                       213 178 16 8 0   2     0   9   114 99                 213
1129972 1129972 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_2 161 17 14 2   3     0   23   118 102                       220 161 17 14 2   3     0   23   118 102                 220
1126602 1126602 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_2 195 10 3 1   15     0   9   119 114                       233 195 10 3 1   15     0   9   119 114                 233
1123497 1123497 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_2 32 0 1 0   2     0   1   12 24                       36 32 0 1 0   2     0   1   12 24                 36
1125164 1125164 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_2 24 0 4 0   0     0   0   12 16                       28 24 0 4 0   0     0   0   12 16                 28
1130213 1130213 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   grade_2 14 1 7 0   3     0   0   12 13                       25 14 1 7 0   3     0   0   12 13                 25
1130385 1130385 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2017   grade_2 21 2 7 0   0     0   0   12 18                       30 21 2 7 0   0     0   0   12 18                 30
1130804 1130804 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_2 8 7 11 0   1     0   1   12 16                       28 8 7 11 0   1     0   1   12 16                 28
1131945 1131945 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_2 18 0 0 0   0     0   1   12 7                       19 18 0 0 0   0     0   1   12 7                 19
1122533 1122533 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2017   grade_2 25 1 2 0   0     0   3   13 18                       31 25 1 2 0   0     0   3   13 18                 31
1125542 1125542 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 02 2017   grade_2 10 1 22 0   0     0   0   13 20                       33 10 1 22 0   0     0   0   13 20                 33
1127339 1127339 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No Elementary PK 05 2017   grade_2 5 7 18 0   0     0   3   13 20                       33 5 7 18 0   0     0   3   13 20                 33
1128733 1128733 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No Elementary KG 05 2017   grade_2 21 2 3 0   1     0   2   13 16                       29 21 2 3 0   1     0   2   13 16                 29
1131745 1131745 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_2 26 6 0 0   0     0   1   13 20                       33 26 6 0 0   0     0   1   13 20                 33
1125650 1125650 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2017   grade_2 195 2 7 1   36     1   8   136 114                       250 195 2 7 1   36     1   8   136 114                 250
1122445 1122445 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_2 20 0 0 0   0     0   0   14 6                       20 20 0 0 0   0     0   0   14 6                 20
1127360 1127360 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No Elementary KG 05 2017   grade_2 30 4 9 0   0     0   4   14 33                       47 30 4 9 0   0     0   4   14 33                 47
1130676 1130676 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Linscott-Rumford   Regular School No Elementary KG 05 2017   grade_2 21 3 4 0   9     0   0   14 23                       37 21 3 4 0   9     0   0   14 23                 37
1130706 1130706 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_2 28 0 4 0   3     0   1   14 22                       36 28 0 4 0   3     0   1   14 22                 36
1122756 1122756 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2017   grade_2 4 8 13 0   1     0   1   15 12                       27 4 8 13 0   1     0   1   15 12                 27
1122951 1122951 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary KG 05 2017   grade_2 3 15 14 1   2     0   2   15 22                       37 3 15 14 1   2     0   2   15 22                 37
1123167 1123167 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_2 13 6 12 0   7     0   3   15 26                       41 13 6 12 0   7     0   3   15 26                 41
1124387 1124387 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_2 18 3 9 0   1     0   0   15 16                       31 18 3 9 0   1     0   0   15 16                 31
1125235 1125235 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No Elementary PK 03 2017   grade_2 40 0 1 1   0     0   2   15 29                       44 40 0 1 1   0     0   2   15 29                 44
1127247 1127247 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No Elementary PK 05 2017   grade_2 29 3 9 0   0     0   5   15 31                       46 29 3 9 0   0     0   5   15 31                 46
1128712 1128712 MA Essex   school 2510500 262   Saugus 251050001680 2620040 Lynnhurst   Regular School No Elementary KG 05 2017   grade_2 26 1 8 0   3     1   0   15 24                       39 26 1 8 0   3     1   0   15 24                 39
1130669 1130669 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Daniel P Hurld   Regular School No Elementary KG 05 2017   grade_2 32 0 0 0   2     0   1   15 20                       35 32 0 0 0   2     0   1   15 20                 35
1130916 1130916 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   grade_2 24 0 2 0   3     0   2   15 16                       31 24 0 2 0   3     0   2   15 16                 31
1122737 1122737 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_2 16 7 12 0   0     0   6   16 25                       41 16 7 12 0   0     0   6   16 25                 41
1123206 1123206 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_2 1 32 11 1   0     0   1   16 30                       46 1 32 11 1   0     0   1   16 30                 46
1124156 1124156 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_2 21 0 7 0   0     0   2   16 14                       30 21 0 7 0   0     0   2   16 14                 30
1125515 1125515 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_2 26 0 3 0   0     0   0   16 13                       29 26 0 3 0   0     0   0   16 13                 29
1126440 1126440 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No Elementary KG 05 2017   grade_2 26 1 5 0   0     0   2   16 18                       34 26 1 5 0   0     0   2   16 18                 34
1127572 1127572 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_2 23 1 2 0   1     0   4   16 15                       31 23 1 2 0   1     0   4   16 15                 31
1128191 1128191 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Cold Spring   Regular School No Elementary KG 05 2017   grade_2 27 1 5 0   2     0   2   16 21                       37 27 1 5 0   2     0   2   16 21                 37
1129229 1129229 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No Elementary KG 05 2017   grade_2 0 11 31 0   3     0   0   16 29                       45 0 11 31 0   3     0   0   16 29                 45
1129492 1129492 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No Elementary KG 05 2017   grade_2 18 14 2 1   4     1   2   16 26                       42 18 14 2 1   4     1   2   16 26                 42
1129592 1129592 MA Essex   school 2511430 291   Swampscott 251143001883 2910005 Clarke   Regular School No Elementary KG 04 2017   grade_2 30 0 6 0   4     0   1   16 25                       41 30 0 6 0   4     0   1   16 25                 41
1132827 1132827 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_2 30 1 4 1   0     0   2   16 22                       38 30 1 4 1   0     0   2   16 22                 38
1133198 1133198 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_2 16 3 5 0   1     0   6   16 15                       31 16 3 5 0   1     0   6   16 15                 31
1123833 1123833 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2017   grade_2 26 1 5 0   5     0   2   17 22                       39 26 1 5 0   5     0   2   17 22                 39
1124944 1124944 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2017   grade_2 35 2 2 0   2     0   1   17 25                       42 35 2 2 0   2     0   1   17 25                 42
1125157 1125157 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2017   grade_2 34 0 0 0   0     0   0   17 17                       34 34 0 0 0   0     0   0   17 17                 34
1125249 1125249 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No Elementary KG 04 2017   grade_2 29 2 7 0   1     0   2   17 24                       41 29 2 7 0   1     0   2   17 24                 41
1125276 1125276 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2017   grade_2 26 3 8 0   0     0   3   17 23                       40 26 3 8 0   0     0   3   17 23                 40
1128938 1128938 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No Elementary KG 05 2017   grade_2 25 0 3 0   4     0   7   17 22                       39 25 0 3 0   4     0   7   17 22                 39
1129302 1129302 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No Elementary PK 05 2017   grade_2 3 8 27 0   1     0   0   17 22                       39 3 8 27 0   1     0   0   17 22                 39
1129741 1129741 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_2 23 0 5 0   0     0   3   17 14                       31 23 0 5 0   0     0   3   17 14                 31
1130248 1130248 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No Elementary KG 05 2017   grade_2 31 0 2 0   0     0   0   17 16                       33 31 0 2 0   0     0   0   17 16                 33
1130474 1130474 MA Norfolk   school 2512840 336   Weymouth 251284000509 3360060 Thomas V Nash   Regular School No Elementary KG 04 2017   grade_2 32 1 1 0   5     0   2   17 24                       41 32 1 1 0   5     0   2   17 24                 41
1130891 1130891 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   grade_2 5 9 20 1   1     0   4   17 23                       40 5 9 20 1   1     0   4   17 23                 40
1131096 1131096 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   grade_2 0 32 11 0   0     0   1   17 27                       44 0 32 11 0   0     0   1   17 27                 44
1131233 1131233 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_2 2 0 40 0   0     0   0   17 25                       42 2 0 40 0   0     0   0   17 25                 42
1122890 1122890 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   grade_2 14 5 5 0   0     1   2   18 9                       27 14 5 5 0   0     1   2   18 9                 27
1122917 1122917 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2017   grade_2 15 0 19 0   4     0   1   18 21                       39 15 0 19 0   4     0   1   18 21                 39
1123128 1123128 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2017   grade_2 4 17 13 0   1     1   1   18 19                       37 4 17 13 0   1     1   1   18 19                 37
1123933 1123933 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2017   grade_2 7 9 7 0   11     0   6   18 22                       40 7 9 7 0   11     0   6   18 22                 40
1123949 1123949 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2017   grade_2 7 12 7 0   6     0   2   18 16                       34 7 12 7 0   6     0   2   18 16                 34
1125255 1125255 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2017   grade_2 39 0 6 0   0     0   0   18 27                       45 39 0 6 0   0     0   0   18 27                 45
1126006 1126006 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_2 22 1 0 0   1     0   0   18 6                       24 22 1 0 0   1     0   0   18 6                 24
1127916 1127916 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2017   grade_2 31 1 8 2   0     0   5   18 29                       47 31 1 8 2   0     0   5   18 29                 47
1128631 1128631 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No Elementary KG 05 2017   grade_2 25 2 10 0   0     0   2   18 21                       39 25 2 10 0   0     0   2   18 21                 39
1128655 1128655 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2017   grade_2 20 2 10 0   3     0   1   18 18                       36 20 2 10 0   3     0   1   18 18                 36
1130416 1130416 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Downey   Regular School No Elementary KG 05 2017   grade_2 28 1 3 0   3     0   1   18 18                       36 28 1 3 0   3     0   1   18 18                 36
1130761 1130761 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_2 8 6 20 0   0     0   0   18 16                       34 8 6 20 0   0     0   0   18 16                 34
1130865 1130865 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2017   grade_2 20 6 6 0   6     0   3   18 23                       41 20 6 6 0   6     0   3   18 23                 41
1131538 1131538 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_2 30 0 0 0   3     0   1   18 16                       34 30 0 0 0   3     0   1   18 16                 34
1132631 1132631 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_2 44 0 1 0   0     0   0   18 27                       45 44 0 1 0   0     0   0   18 27                 45
1133184 1133184 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_2 28 4 8 0   0     0   0   18 22                       40 28 4 8 0   0     0   0   18 22                 40
1122156 1122156 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_2 27 3 6 0   7     0   1   19 25                       44 27 3 6 0   7     0   1   19 25                 44
1123063 1123063 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   grade_2 13 15 5 1   2     0   1   19 18                       37 13 15 5 1   2     0   1   19 18                 37

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