Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by total

View and edit SQL

grade

year

  • 2015 · 9,441
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
742664 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_7 91 3 0 0   1     0   5   47 53                       100 91 3 0 0   1     0   5   47 53                 100
742666 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_9 90 2 1 0   3     1   3   40 60                       100 90 2 1 0   3     1   3   40 60                 100
742740 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No 1 KG 02 2015   grade_2 66 2 2 0   27     0   3   56 44                       100 66 2 2 0   27     0   3   56 44                 100
742804 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 Philip G Coburn   Regular School No 1 KG 05 2015   grade_2 59 4 16 0   13     0   8   54 46                       100 59 4 16 0   13     0   8   54 46                 100
743119 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_3 7 11 70 0   9     0   3   48 52                       100 7 11 70 0   9     0   3   48 52                 100
743522 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_6 80 3 6 0   8     0   3   52 48                       100 80 3 6 0   8     0   3   52 48                 100
743523 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_7 83 3 3 1   6     0   4   52 48                       100 83 3 3 1   6     0   4   52 48                 100
743524 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_8 86 5 2 0   3     0   4   47 53                       100 86 5 2 0   3     0   4   47 53                 100
743526 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_10 78 3 8 1   7     0   3   46 54                       100 78 3 8 1   7     0   3   46 54                 100
743570 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   kindergarten 20 23 48 0   6     0   3   55 45                       100 20 23 48 0   6     0   3   55 45                 100
743638 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_6 45 29 20 1   4     0   1   49 51                       100 45 29 20 1   4     0   1   49 51                 100
743687 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 07 2015   grade_1 3 23 50 0   20     0   4   52 48                       100 3 23 50 0   20     0   4   52 48                 100
743688 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 07 2015   grade_2 2 25 49 0   20     0   4   52 48                       100 2 25 49 0   20     0   4   52 48                 100
743772 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes 1 KG 05 2015   grade_2 66 9 20 0   5     0   0   52 48                       100 66 9 20 0   5     0   0   52 48                 100
743871 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_5 85 4 7 0   2     0   2   49 51                       100 85 4 7 0   2     0   2   49 51                 100
743872 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_6 86 3 4 0   4     0   3   49 51                       100 86 3 4 0   4     0   3   49 51                 100
743873 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_7 80 5 8 0   1     0   6   36 64                       100 80 5 8 0   1     0   6   36 64                 100
743874 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_8 86 3 5 0   3     0   3   44 56                       100 86 3 5 0   3     0   3   44 56                 100
744073 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_5 88 0 8 1   1     0   2   38 62                       100 88 0 8 1   1     0   2   38 62                 100
744281 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No 1 KG 03 2015   grade_1 97 1 1 0   1     0   0   53 47                       100 97 1 1 0   1     0   0   53 47                 100
744573 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett Regional High   Regular School No 3 09 12 2015   grade_9 92 0 3 0   0     0   5   49 51                       100 92 0 3 0   0     0   5   49 51                 100
735675 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_1 101 0 0 0   0     0   0   58 43                       101 101 0 0 0   0     0   0   58 43                 101
736053 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_2 73 3 3 0   14     0   8   56 45                       101 73 3 3 0   14     0   8   56 45                 101
736122 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No 1 KG 05 2015   grade_2 79 1 5 0   12     0   4   51 50                       101 79 1 5 0   12     0   4   51 50                 101
737199 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   grade_3 55 4 14 0   15     0   13   45 56                       101 55 4 14 0   15     0   13   45 56                 101
737461 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No 1 KG 04 2015   grade_3 81 1 4 0   13     1   1   57 44                       101 81 1 4 0   13     1   1   57 44                 101
737784 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_9 99 0 2 0   0     0   0   52 49                       101 99 0 2 0   0     0   0   52 49                 101
738089 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No 1 PK 05 2015   grade_2 71 3 16 0   3     0   8   50 51                       101 71 3 16 0   3     0   8   50 51                 101
738279 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_4 60 16 17 0   3     0   5   64 37                       101 60 16 17 0   3     0   5   64 37                 101
738311 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_4 93 0 1 0   6     0   1   60 41                       101 93 0 1 0   6     0   1   60 41                 101
738434 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_3 84 0 4 1   7     2   3   56 45                       101 84 0 4 1   7     2   3   56 45                 101
738527 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2015   grade_1 99 0 2 0   0     0   0   51 50                       101 99 0 2 0   0     0   0   51 50                 101
738659 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2015   grade_4 97 1 0 0   2     0   1   62 39                       101 97 1 0 0   2     0   1   62 39                 101
738949 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_8 2 0 97 1   0     0   1   54 47                       101 2 0 97 1   0     0   1   54 47                 101
738980 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2015   grade_10 12 3 86 0   0     0   0   52 49                       101 12 3 86 0   0     0   0   52 49                 101
738998 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2015   grade_11 1 0 100 0   0     0   0   45 56                       101 1 0 100 0   0     0   0   45 56                 101
739125 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2015   grade_4 44 10 2 1   43     0   1   53 48                       101 44 10 2 1   43     0   1   53 48                 101
739137 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2015   grade_4 48 3 3 0   39     0   8   36 65                       101 48 3 3 0   39     0   8   36 65                 101
739783 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No 1 PK 05 2015   grade_4 73 10 9 0   6     0   3   53 48                       101 73 10 9 0   6     0   3   53 48                 101
739980 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No 1 PK 04 2015   grade_3 84 0 7 0   4     0   6   59 42                       101 84 0 7 0   4     0   6   59 42                 101
739985 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_8 95 2 2 1   1     0   0   42 59                       101 95 2 2 1   1     0   0   42 59                 101
740234 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No 1 PK 05 2015   grade_4 75 4 10 0   1     0   11   48 53                       101 75 4 10 0   1     0   11   48 53                 101
740685 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   grade_4 98 0 0 0   2     0   1   46 55                       101 98 0 0 0   2     0   1   46 55                 101
741072 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2015   grade_3 39 12 7 0   41     0   2   59 42                       101 39 12 7 0   41     0   2   59 42                 101
741745 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2015   grade_1 16 11 71 0   1     0   2   45 56                       101 16 11 71 0   1     0   2   45 56                 101
741948 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_6 19 29 49 1   0     1   2   59 42                       101 19 29 49 1   0     1   2   59 42                 101
741950 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_8 31 27 34 0   2     0   7   52 49                       101 31 27 34 0   2     0   7   52 49                 101
742155 MA Worcester   school 2511400 290   Sutton 251140001414 2900510 Sutton High School   Regular School No 3 09 12 2015   grade_10 95 0 2 0   0     0   4   59 42                       101 95 0 2 0   0     0   4   59 42                 101
742330 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No 3 09 12 2015   grade_12 91 1 5 0   2     0   2   57 44                       101 91 1 5 0   2     0   2   57 44                 101
742457 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No 1 PK 03 2015   grade_1 91 1 4 0   1     0   4   61 40                       101 91 1 4 0   1     0   4   61 40                 101
742621 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No 1 KG 03 2015   grade_3 61 2 2 0   34     0   2   46 55                       101 61 2 2 0   34     0   2   46 55                 101
742667 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_10 96 4 0 0   1     0   0   48 53                       101 96 4 0 0   1     0   0   48 53                 101
742912 MA Norfolk   school 2512840 336   Weymouth 251284002120 3360105 Thomas W. Hamilton Primary School   Regular School No 1 KG 04 2015   grade_3 80 6 10 0   4     0   1   54 47                       101 80 6 10 0   4     0   1   54 47                 101
744090 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No 1 KG 03 2015   grade_1 84 3 7 0   2     0   5   49 52                       101 84 3 7 0   2     0   5   49 52                 101
744457 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2015   grade_9 101 0 0 0   0     0   0   49 52                       101 101 0 0 0   0     0   0   49 52                 101
744475 MA Worcester   school 2507680 710   Mendon-Upton 250768001277 7100001 Memorial School   Regular School No 1 PK 04 2015   grade_1 86 0 6 0   5     0   4   59 42                       101 86 0 6 0   5     0   4   59 42                 101
744502 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2015   grade_1 79 6 6 1   1     0   8   47 54                       101 79 6 6 1   1     0   8   47 54                 101
744587 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No 1 PK 05 2015   grade_2 81 0 6 1   12     0   1   56 45                       101 81 0 6 1   12     0   1   56 45                 101
744598 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_6 96 1 2 0   1     0   1   45 56                       101 96 1 2 0   1     0   1   45 56                 101
744640 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No 1 KG 04 2015   kindergarten 93 0 3 0   1     0   4   58 43                       101 93 0 3 0   1     0   4   58 43                 101
744766 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2015   grade_10 89 1 4 1   1     0   5   52 49                       101 89 1 4 1   1     0   5   52 49                 101
745005 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2015   grade_1 97 0 2 0   0     0   2   57 44                       101 97 0 2 0   0     0   2   57 44                 101
737166 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_11 231 627 106 3   26     0   23   530 486                       1016 231 627 106 3   26     0   23   530 486                 1016
736246 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No 1 PK 05 2015   grade_2 10 25 63 0   2     0   2   46 56                       102 10 25 63 0   2     0   2   46 56                 102
736860 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_9 13 41 43 1   2     0   2   36 66                       102 13 41 43 1   2     0   2   36 66                 102
736899 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2015   grade_9 3 75 22 0   1     0   1   62 40                       102 3 75 22 0   1     0   1   62 40                 102
737967 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_2 49 16 33 0   3     0   1   53 49                       102 49 16 33 0   3     0   1   53 49                 102
738053 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2015   grade_1 51 6 38 0   1     0   6   59 43                       102 51 6 38 0   1     0   6   59 43                 102
738141 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_2 81 4 7 0   3     0   7   52 50                       102 81 4 7 0   3     0   7   52 50                 102
738160 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_1 31 7 54 0   4     0   6   53 49                       102 31 7 54 0   4     0   6   53 49                 102
738550 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_9 84 2 1 0   12     0   3   56 46                       102 84 2 1 0   12     0   3   56 46                 102
738614 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 KG 04 2015   grade_4 36 3 56 1   3     2   1   54 48                       102 36 3 56 1   3     2   1   54 48                 102
739080 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Southeast School   Regular School No 1 KG 05 2015   grade_3 47 4 42 0   6     0   3   57 45                       102 47 4 42 0   6     0   3   57 45                 102
739600 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2015   grade_3 29 19 28 0   23     0   3   47 55                       102 29 19 28 0   23     0   3   47 55                 102
739999 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Cunningham School   Regular School No 1 KG 05 2015   grade_2 82 8 6 0   4     0   2   63 39                       102 82 8 6 0   4     0   2   63 39                 102
740031 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_6 101 1 0 0   0     0   0   48 54                       102 101 1 0 0   0     0   0   48 54                 102
740774 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No 1 PK 04 2015   grade_1 83 1 10 0   1     0   7   60 42                       102 83 1 10 0   1     0   7   60 42                 102
740961 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No 1 PK 03 2015   grade_1 81 3 11 1   3     0   3   53 49                       102 81 3 11 1   3     0   3   53 49                 102
741530 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No 1 KG 05 2015   grade_5 59 1 3 0   33     0   6   56 46                       102 59 1 3 0   33     0   6   56 46                 102
741856 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No 1 PK 05 2015   grade_3 18 19 60 0   2     0   3   66 36                       102 18 19 60 0   2     0   3   66 36                 102
741951 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_9 36 19 37 0   2     0   8   54 48                       102 36 19 37 0   2     0   8   54 48                 102
742460 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2015   grade_4 89 2 5 0   1     0   5   49 53                       102 89 2 5 0   1     0   5   49 53                 102
742620 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No 1 KG 03 2015   grade_2 54 1 1 0   46     0   0   61 41                       102 54 1 1 0   46     0   0   61 41                 102
742662 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2015   grade_5 98 0 3 0   1     0   0   57 45                       102 98 0 3 0   1     0   0   57 45                 102
742800 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 Cowing Early Childhood   Regular School No 1 PK PK 2015   pre_kindergarten 62 6 25 0   4     0   5   61 41                       102 62 6 25 0   4     0   5   61 41                 102
743419 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_8 15 9 71 0   6     0   1   52 50                       102 15 9 71 0   6     0   1   52 50                 102
743478 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_11 8 57 30 1   1     0   5   50 52                       102 8 57 30 1   1     0   5   50 52                 102
744041 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No 3 09 12 2015   grade_9 93 2 5 0   2     0   0   50 52                       102 93 2 5 0   2     0   0   50 52                 102
744500 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2015   kindergarten 79 2 8 2   1     0   10   50 52                       102 79 2 8 2   1     0   10   50 52                 102
745160 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 06 2015   grade_3 1 45 46 0   4     1   5   48 54                       102 1 45 46 0   4     1   5   48 54                 102
737424 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   grade_5 71 10 5 0   15     0   2   51 52                       103 71 10 5 0   15     0   2   51 52                 103
737557 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_3 62 5 27 0   3     0   6   55 48                       103 62 5 27 0   3     0   6   55 48                 103
737779 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_4 90 0 7 0   4     0   2   50 53                       103 90 0 7 0   4     0   2   50 53                 103
737787 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No 3 09 12 2015   grade_12 101 0 1 0   1     0   0   49 54                       103 101 0 1 0   1     0   0   49 54                 103
737915 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No 1 PK 02 2015   grade_1 91 3 2 0   2     0   5   51 52                       103 91 3 2 0   2     0   5   51 52                 103
738054 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2015   grade_2 49 5 40 1   2     0   6   52 51                       103 49 5 40 1   2     0   6   52 51                 103
738240 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_1 34 8 51 0   10     0   0   51 52                       103 34 8 51 0   10     0   0   51 52                 103
738251 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   kindergarten 75 2 15 0   7     0   4   54 49                       103 75 2 15 0   7     0   4   54 49                 103
738253 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   grade_2 71 11 11 0   6     0   4   51 52                       103 71 11 11 0   6     0   4   51 52                 103
738530 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No 1 03 04 2015   grade_4 99 0 2 0   2     0   0   54 49                       103 99 0 2 0   2     0   0   54 49                 103

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