enrollments

Data source: Big Local News · About: Big Local

577 rows where grade = "grade_6", state = "MA" and year = 2017 sorted by female_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 577 ✖

grade ✖

  • grade_6 · 577 ✖
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
1124818 1124818 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_6 * * * *   *     *   *   5 *                       *                         5                    
1125192 1125192 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125266 1125266 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1126251 1126251 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_6 * * * *   *     *   *   4 *                       *                         4                    
1126451 1126451 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_6 3 3 3 0   0     0   0   7 *                       9 3 3 3 0   0     0   0   7                   9
1129008 1129008 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1131923 1131923 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1123137 1123137 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_6 3 7 5 1   0     0   0   15 1                       16 3 7 5 1   0     0   0   15 1                 16
1125424 1125424 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_6 * * * *   *     *   *   4 1                       *                         4 1                  
1126511 1126511 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1129357 1129357 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2017   grade_6 1 7 9 0   0     0   0   16 1                       17 1 7 9 0   0     0   0   16 1                 17
1130462 1130462 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1122675 1122675 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1124926 1124926 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1125883 1125883 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_6 2 0 13 0   0     0   0   13 2                       15 2 0 13 0   0     0   0   13 2                 15
1129369 1129369 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2017   grade_6 0 1 6 0   0     0   0   4 3                       7 0 1 6 0   0     0   0   4 3                 7
1132002 1132002 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_6 * * * *   *     *   *   1 3                       *                         1 3                  
1132595 1132595 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   grade_6 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1123447 1123447 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_6 0 3 3 0   0     0   0   2 4                       6 0 3 3 0   0     0   0   2 4                 6
1132414 1132414 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   0     0   0   7 4                       11 11 0 0 0   0     0   0   7 4                 11
1128056 1128056 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_6 16 0 0 0   1     0   1   13 5                       18 16 0 0 0   1     0   1   13 5                 18
1128278 1128278 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_6 6 3 4 0   0     0   1   9 5                       14 6 3 4 0   0     0   1   9 5                 14
1131076 1131076 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_6 8 0 0 0   0     0   0   3 5                       8 8 0 0 0   0     0   0   3 5                 8
1132276 1132276 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   grade_6 7 0 0 1   0     0   0   3 5                       8 7 0 0 1   0     0   0   3 5                 8
1124614 1124614 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 1 0   0     0   0   6 6                       12 11 0 1 0   0     0   0   6 6                 12
1126010 1126010 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   2     0   1   8 6                       14 11 0 0 0   2     0   1   8 6                 14
1127118 1127118 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_6 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
1129766 1129766 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_6 8 0 1 0   0     0   0   3 6                       9 8 0 1 0   0     0   0   3 6                 9
1130523 1130523 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   14 6                       20 19 0 1 0   0     0   0   14 6                 20
1128905 1128905 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_6 10 0 1 0   0     0   2   6 7                       13 10 0 1 0   0     0   2   6 7                 13
1130748 1130748 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_6 6 2 7 0   0     0   1   9 7                       16 6 2 7 0   0     0   1   9 7                 16
1130808 1130808 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_6 2 11 15 0   0     0   0   21 7                       28 2 11 15 0   0     0   0   21 7                 28
1132180 1132180 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2017   grade_6 12 3 0 0   0     0   1   9 7                       16 12 3 0 0   0     0   1   9 7                 16
1132399 1132399 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_6 10 0 0 0   0     0   0   3 7                       10 10 0 0 0   0     0   0   3 7                 10
1132730 1132730 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_6 12 0 0 0   0     0   0   5 7                       12 12 0 0 0   0     0   0   5 7                 12
1123199 1123199 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_6 0 9 12 0   0     0   1   14 8                       22 0 9 12 0   0     0   1   14 8                 22
1123231 1123231 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_6 4 2 10 1   0     0   0   9 8                       17 4 2 10 1   0     0   0   9 8                 17
1128097 1128097 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   grade_6 16 0 0 0   0     0   1   9 8                       17 16 0 0 0   0     0   1   9 8                 17
1128554 1128554 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_6 15 0 0 0   0     0   1   8 8                       16 15 0 0 0   0     0   1   8 8                 16
1131455 1131455 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_6 11 1 0 0   0     0   2   6 8                       14 11 1 0 0   0     0   2   6 8                 14
1132093 1132093 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   0     0   0   3 8                       11 11 0 0 0   0     0   0   3 8                 11
1122567 1122567 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_6 6 1 5 0   3     0   2   8 9                       17 6 1 5 0   3     0   2   8 9                 17
1124213 1124213 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_6 16 0 0 0   0     0   0   7 9                       16 16 0 0 0   0     0   0   7 9                 16
1127576 1127576 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_6 18 0 3 0   0     0   4   16 9                       25 18 0 3 0   0     0   4   16 9                 25
1130532 1130532 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_6 25 0 0 0   0     0   0   16 9                       25 25 0 0 0   0     0   0   16 9                 25
1131271 1131271 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_6 0 17 3 0   0     0   0   11 9                       20 0 17 3 0   0     0   0   11 9                 20
1131297 1131297 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_6 1 0 18 0   1     0   0   11 9                       20 1 0 18 0   1     0   0   11 9                 20
1131940 1131940 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   11 9                       20 19 0 1 0   0     0   0   11 9                 20
1132612 1132612 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_6 11 0 0 0   0     0   0   2 9                       11 11 0 0 0   0     0   0   2 9                 11
1129745 1129745 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_6 20 0 9 0   0     0   0   19 10                       29 20 0 9 0   0     0   0   19 10                 29
1130317 1130317 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_6 16 0 1 0   0     0   0   6 11                       17 16 0 1 0   0     0   0   6 11                 17
1131379 1131379 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_6 26 0 2 0   0     0   3   20 11                       31 26 0 2 0   0     0   3   20 11                 31
1122945 1122945 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_6 0 4 22 0   0     0   0   14 12                       26 0 4 22 0   0     0   0   14 12                 26
1122990 1122990 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_6 15 3 3 0   1     0   0   10 12                       22 15 3 3 0   1     0   0   10 12                 22
1124286 1124286 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_6 26 0 0 0   0     0   0   14 12                       26 26 0 0 0   0     0   0   14 12                 26
1125753 1125753 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_6 22 0 0 0   0     0   0   10 12                       22 22 0 0 0   0     0   0   10 12                 22
1129849 1129849 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   grade_6 18 0 0 1   0     0   1   8 12                       20 18 0 0 1   0     0   1   8 12                 20
1130886 1130886 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2017   grade_6 16 4 6 0   2     0   1   17 12                       29 16 4 6 0   2     0   1   17 12                 29
1131811 1131811 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2017   grade_6 20 1 0 0   0     0   0   9 12                       21 20 1 0 0   0     0   0   9 12                 21
1132494 1132494 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2017   grade_6 21 0 1 0   2     0   0   12 12                       24 21 0 1 0   2     0   0   12 12                 24
1132627 1132627 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_6 26 0 2 0   0     0   1   17 12                       29 26 0 2 0   0     0   1   17 12                 29
1132751 1132751 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 25 0 3 0   1     0   2   18 13                       31 25 0 3 0   1     0   2   18 13                 31
1125369 1125369 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_6 27 0 4 0   0     0   0   17 14                       31 27 0 4 0   0     0   0   17 14                 31
1127783 1127783 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 39 1 2 0   0     0   3   31 14                       45 39 1 2 0   0     0   3   31 14                 45
1130765 1130765 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   grade_6 8 6 15 0   2     0   1   18 14                       32 8 6 15 0   2     0   1   18 14                 32
1130861 1130861 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   grade_6 9 4 14 0   1     0   0   14 14                       28 9 4 14 0   1     0   0   14 14                 28
1130920 1130920 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   grade_6 15 0 5 0   6     0   4   16 14                       30 15 0 5 0   6     0   4   16 14                 30
1132588 1132588 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_6 21 0 0 0   0     0   6   13 14                       27 21 0 0 0   0     0   6   13 14                 27
1130895 1130895 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   grade_6 2 5 16 0   2     0   1   11 15                       26 2 5 16 0   2     0   1   11 15                 26
1132604 1132604 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2017   grade_6 34 0 1 0   0     0   0   20 15                       35 34 0 1 0   0     0   0   20 15                 35
1132645 1132645 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_6 34 0 1 0   1     0   1   22 15                       37 34 0 1 0   1     0   1   22 15                 37
1123091 1123091 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_6 0 9 25 0   0     0   1   19 16                       35 0 9 25 0   0     0   1   19 16                 35
1123575 1123575 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   grade_6 32 2 0 0   0     0   0   18 16                       34 32 2 0 0   0     0   0   18 16                 34
1128993 1128993 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   grade_6 17 4 9 0   3     0   2   19 16                       35 17 4 9 0   3     0   2   19 16                 35
1130981 1130981 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2017   grade_6 19 11 18 0   2     0   1   35 16                       51 19 11 18 0   2     0   1   35 16                 51
1131180 1131180 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_6 1 21 8 1   1     0   1   17 16                       33 1 21 8 1   1     0   1   17 16                 33
1124603 1124603 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_6 23 0 7 0   0     0   4   17 17                       34 23 0 7 0   0     0   4   17 17                 34
1127567 1127567 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_6 33 3 0 0   0     0   1   20 17                       37 33 3 0 0   0     0   1   20 17                 37
1128950 1128950 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_6 11 7 12 0   6     0   1   20 17                       37 11 7 12 0   6     0   1   20 17                 37
1129215 1129215 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_6 8 8 14 0   0     0   2   15 17                       32 8 8 14 0   0     0   2   15 17                 32
1131006 1131006 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2017   grade_6 25 2 4 0   2     0   2   18 17                       35 25 2 4 0   2     0   2   18 17                 35
1132390 1132390 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2017   grade_6 24 0 1 0   0     0   0   8 17                       25 24 0 1 0   0     0   0   8 17                 25
1122060 1122060 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_6 20 5 9 0   6     0   4   26 18                       44 20 5 9 0   6     0   4   26 18                 44
1123160 1123160 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_6 1 24 12 0   0     0   0   19 18                       37 1 24 12 0   0     0   0   19 18                 37
1125551 1125551 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_6 13 1 23 0   0     0   0   19 18                       37 13 1 23 0   0     0   0   19 18                 37
1125610 1125610 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2017   grade_6 6 0 32 0   0     0   2   22 18                       40 6 0 32 0   0     0   2   22 18                 40
1131360 1131360 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   grade_6 24 2 3 0   18     0   1   30 18                       48 24 2 3 0   18     0   1   30 18                 48
1131415 1131415 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2017   grade_6 24 1 6 0   0     0   2   15 18                       33 24 1 6 0   0     0   2   15 18                 33
1122872 1122872 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_6 6 0 26 0   0     0   1   14 19                       33 6 0 26 0   0     0   1   14 19                 33
1125562 1125562 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_6 0 2 38 0   0     0   0   21 19                       40 0 2 38 0   0     0   0   21 19                 40
1125578 1125578 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_6 2 0 39 0   0     0   0   22 19                       41 2 0 39 0   0     0   0   22 19                 41
1129570 1129570 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2017   grade_6 29 2 3 0   1     0   5   21 19                       40 29 2 3 0   1     0   5   21 19                 40
1130817 1130817 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   grade_6 6 6 23 0   4     0   3   23 19                       42 6 6 23 0   4     0   3   23 19                 42
1130869 1130869 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2017   grade_6 21 3 5 0   5     0   0   15 19                       34 21 3 5 0   5     0   0   15 19                 34
1125298 1125298 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_6 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1128659 1128659 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2017   grade_6 25 1 10 0   0     0   2   18 20                       38 25 1 10 0   0     0   2   18 20                 38
1131445 1131445 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   grade_6 43 3 2 1   1     0   0   30 20                       50 43 3 2 1   1     0   0   30 20                 50
1131542 1131542 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_6 27 1 1 0   0     0   1   10 20                       30 27 1 1 0   0     0   1   10 20                 30
1122596 1122596 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_6 13 11 19 0   2     0   1   25 21                       46 13 11 19 0   2     0   1   25 21                 46
1123102 1123102 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2017   grade_6 9 8 24 0   6     1   1   28 21                       49 9 8 24 0   6     1   1   28 21                 49

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