enrollments

Data source: Big Local News · About: Big Local

990 rows where grade = "grade_1", state = "MA" and year = 2015 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 990 ✖

grade ✖

  • grade_1 · 990 ✖
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
736673 736673 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_1 * * * *   *     *   *   2 3                       5                         2 3                 5
737738 737738 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK 01 2015   grade_1 * * * *   *     *   *   2 1                       3                         2 1                 3
738515 738515 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   1 4                       5                         1 4                 5
739009 739009 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_1 * * * *   *     *   *   4 1                       5                         4 1                 5
739315 739315 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_1 * * * *   *     *   *   2 *                       2                         2                   2
739478 739478 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_1 * * * *   *     *   *   3 1                       4                         3 1                 4
741325 741325 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   2 3                       5                         2 3                 5
744540 744540 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   1 1                       2                         1 1                 2
744702 744702 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   1 4                       5                         1 4                 5
744716 744716 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   2 1                       3                         2 1                 3
744793 744793 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No 1 KG 01 2015   grade_1 * * * *   *     *   *   * 2                       5                           2                 5
735675 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
735685 735685 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No 1 KG 04 2015   grade_1 44 0 7 0   1     0   3   25 30                       55 44 0 7 0   1     0   3   25 30                 55
735690 735690 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No 1 KG 04 2015   grade_1 81 0 6 0   3     0   4   46 48                       94 81 0 6 0   3     0   4   46 48                 94
735695 735695 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Robinson Park   Regular School No 1 KG 04 2015   grade_1 60 0 8 0   3     0   2   32 41                       73 60 0 8 0   3     0   2   32 41                 73
735774 735774 MA Essex   school 2501950 9   Andover 250195000048 90010 Henry C Sanborn Elementary   Regular School No 1 KG 05 2015   grade_1 34 0 0 1   11     0   2   31 17                       48 34 0 0 1   11     0   2   31 17                 48
735832 735832 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2015   grade_1 37 0 5 0   2     0   0   27 17                       44 37 0 5 0   2     0   0   27 17                 44
735871 735871 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2015   grade_1 50 0 17 0   4     0   7   36 42                       78 50 0 17 0   4     0   7   36 42                 78
735997 735997 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_1 161 0 5 0   2     0   3   84 87                       171 161 0 5 0   2     0   3   84 87                 171
736008 736008 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_1 55 0 2 0   2     0   3   29 33                       62 55 0 2 0   2     0   3   29 33                 62
736041 736041 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_1 41 0 0 0   19     0   8   36 32                       68 41 0 0 0   19     0   8   36 32                 68
736066 736066 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2015   grade_1 94 0 0 0   0     0   1   50 45                       95 94 0 0 0   0     0   1   50 45                 95
736076 736076 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2015   grade_1 23 0 2 0   1     0   0   15 11                       26 23 0 2 0   1     0   0   15 11                 26
736133 736133 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 John F Kennedy   Regular School No 1 KG 05 2015   grade_1 53 0 0 0   2     0   0   30 25                       55 53 0 0 0   2     0   0   30 25                 55
736151 736151 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No 1 KG 05 2015   grade_1 26 0 1 0   3     0   3   23 10                       33 26 0 1 0   3     0   3   23 10                 33
736259 736259 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No 1 PK 05 2015   grade_1 18 0 44 0   1     0   0   29 34                       63 18 0 44 0   1     0   0   29 34                 63
736266 736266 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 04 2015   grade_1 7 0 8 0   0     0   1   7 9                       16 7 0 8 0   0     0   1   7 9                 16
736966 736966 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   grade_1 68 0 1 1   1     0   0   36 35                       71 68 0 1 1   1     0   0   36 35                 71
736993 736993 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No 1 PK 05 2015   grade_1 34 0 1 0   1     0   1   19 18                       37 34 0 1 0   1     0   1   19 18                 37
737011 737011 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No 1 KG 05 2015   grade_1 52 0 3 1   9     0   3   42 26                       68 52 0 3 1   9     0   3   42 26                 68
737046 737046 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   grade_1 75 0 3 0   1     0   4   45 38                       83 75 0 3 0   1     0   4   45 38                 83
737179 737179 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   grade_1 31 0 4 0   0     0   2   15 22                       37 31 0 4 0   0     0   2   15 22                 37
737270 737270 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No 1 KG 05 2015   grade_1 36 0 2 0   4     0   1   19 24                       43 36 0 2 0   4     0   1   19 24                 43
737434 737434 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   grade_1 58 0 1 0   7     0   4   40 30                       70 58 0 1 0   7     0   4   40 30                 70
737527 737527 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_1 44 0 16 0   5     1   2   33 35                       68 44 0 16 0   5     1   2   33 35                 68
737567 737567 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   grade_1 31 0 42 1   1     0   0   43 32                       75 31 0 42 1   1     0   0   43 32                 75
737573 737573 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No 1 KG 05 2015   grade_1 31 0 18 0   2     0   2   28 25                       53 31 0 18 0   2     0   2   28 25                 53
737601 737601 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_1 24 0 0 0   0     0   1   13 12                       25 24 0 0 0   0     0   1   13 12                 25
737664 737664 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   grade_1 17 0 1 0   0     0   0   10 8                       18 17 0 1 0   0     0   0   10 8                 18
737711 737711 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2015   grade_1 60 0 4 0   0     0   1   34 31                       65 60 0 4 0   0     0   1   34 31                 65
737717 737717 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2015   grade_1 55 0 3 0   0     0   3   24 37                       61 55 0 3 0   0     0   3   24 37                 61
737776 737776 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   grade_1 78 0 0 0   1     0   3   44 38                       82 78 0 0 0   1     0   3   44 38                 82
737873 737873 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No 1 PK 04 2015   grade_1 33 0 4 0   1     0   0   24 14                       38 33 0 4 0   1     0   0   24 14                 38
737878 737878 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2015   grade_1 29 0 2 0   0     0   2   17 16                       33 29 0 2 0   0     0   2   17 16                 33
737919 737919 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No 1 PK 02 2015   grade_1 45 0 5 0   2     0   1   31 22                       53 45 0 5 0   2     0   1   31 22                 53
737933 737933 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_1 29 0 10 1   0     0   2   17 25                       42 29 0 10 1   0     0   2   17 25                 42
737943 737943 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_1 14 0 0 0   0     0   2   10 6                       16 14 0 0 0   0     0   2   10 6                 16
738014 738014 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No 1 PK 05 2015   grade_1 50 0 5 0   3     0   6   36 28                       64 50 0 5 0   3     0   6   36 28                 64
738140 738140 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_1 76 0 7 3   4     0   4   45 49                       94 76 0 7 3   4     0   4   45 49                 94
738145 738145 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_1 62 0 6 1   0     0   4   39 34                       73 62 0 6 1   0     0   4   39 34                 73
738205 738205 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_1 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
738215 738215 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2015   grade_1 53 0 1 0   3     1   0   26 32                       58 53 0 1 0   3     1   0   26 32                 58
738326 738326 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   grade_1 46 0 3 1   6     0   0   33 23                       56 46 0 3 1   6     0   0   33 23                 56
738375 738375 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   grade_1 113 0 2 0   0     1   2   64 54                       118 113 0 2 0   0     1   2   64 54                 118
738394 738394 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_1 34 0 3 0   0     0   3   21 19                       40 34 0 3 0   0     0   3   21 19                 40
738401 738401 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_1 36 0 1 0   0     0   0   25 12                       37 36 0 1 0   0     0   0   25 12                 37
738407 738407 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_1 33 0 4 0   0     1   1   17 22                       39 33 0 4 0   0     1   1   17 22                 39
738413 738413 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_1 39 0 0 1   1     0   2   20 23                       43 39 0 0 1   1     0   2   20 23                 43
738429 738429 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2015   grade_1 95 0 8 0   24     0   1   66 62                       128 95 0 8 0   24     0   1   66 62                 128
738455 738455 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2015   grade_1 40 0 4 0   2     0   2   26 22                       48 40 0 4 0   2     0   2   26 22                 48
738466 738466 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 03 2015   grade_1 57 0 1 0   0     0   0   32 26                       58 57 0 1 0   0     0   0   32 26                 58
738478 738478 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 03 2015   grade_1 47 0 14 0   0     0   0   31 30                       61 47 0 14 0   0     0   0   31 30                 61
738493 738493 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_1 37 0 3 0   1     1   1   20 23                       43 37 0 3 0   1     1   1   20 23                 43
738527 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
738556 738556 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_1 34 0 2 0   0     0   0   17 19                       36 34 0 2 0   0     0   0   17 19                 36
738638 738638 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   grade_1 88 0 0 0   0     0   1   54 35                       89 88 0 0 0   0     0   1   54 35                 89
738650 738650 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2015   grade_1 81 0 4 0   1     0   2   41 47                       88 81 0 4 0   1     0   2   41 47                 88
738686 738686 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   grade_1 16 0 0 0   1     0   0   10 7                       17 16 0 0 0   1     0   0   10 7                 17
738710 738710 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_1 20 0 34 0   2     0   2   33 25                       58 20 0 34 0   2     0   2   33 25                 58
738783 738783 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_1 82 0 4 0   0     1   0   52 35                       87 82 0 4 0   0     1   0   52 35                 87
738812 738812 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2015   grade_1 49 0 5 0   0     0   3   28 29                       57 49 0 5 0   0     0   3   28 29                 57
738817 738817 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2015   grade_1 48 0 3 0   3     0   2   23 33                       56 48 0 3 0   3     0   2   23 33                 56
738823 738823 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2015   grade_1 102 0 6 0   3     0   2   58 55                       113 102 0 6 0   3     0   2   58 55                 113
738852 738852 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2015   grade_1 63 0 1 0   0     0   1   36 29                       65 63 0 1 0   0     0   1   36 29                 65
738881 738881 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_1 27 0 0 0   1     0   1   19 10                       29 27 0 0 0   1     0   1   19 10                 29
738898 738898 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_1 6 0 132 0   0     0   0   71 67                       138 6 0 132 0   0     0   0   71 67                 138
738937 738937 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_1 3 0 100 0   0     0   0   53 50                       103 3 0 100 0   0     0   0   53 50                 103
738955 738955 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_1 2 0 71 0   0     0   0   36 37                       73 2 0 71 0   0     0   0   36 37                 73
739028 739028 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_1 37 0 5 0   2     0   1   20 25                       45 37 0 5 0   2     0   1   20 25                 45
739056 739056 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   grade_1 42 0 2 0   2     0   2   28 20                       48 42 0 2 0   2     0   2   28 20                 48
739114 739114 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_1 13 0 2 0   0     0   0   9 6                       15 13 0 2 0   0     0   0   9 6                 15
739140 739140 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No 1 KG 05 2015   grade_1 56 0 2 0   20     0   10   42 46                       88 56 0 2 0   20     0   10   42 46                 88
739202 739202 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2015   grade_1 72 0 5 0   14     2   4   43 54                       97 72 0 5 0   14     2   4   43 54                 97
739218 739218 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Wolf Swamp Road   Regular School No 1 KG 05 2015   grade_1 39 0 4 0   8     0   2   32 21                       53 39 0 4 0   8     0   2   32 21                 53
739382 739382 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2015   grade_1 108 0 6 1   1     0   6   67 55                       122 108 0 6 1   1     0   6   67 55                 122
739473 739473 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2015   grade_1 19 0 1 1   0     0   1   10 12                       22 19 0 1 1   0     0   1   10 12                 22
739633 739633 MA Essex   school 2507260 168   Marblehead 250726001120 1680015 Elbridge Gerry   Regular School No 1 KG 01 2015   grade_1 67 0 6 0   2     0   1   39 37                       76 67 0 6 0   2     0   1   39 37                 76
739651 739651 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No 1 PK 06 2015   grade_1 50 0 0 0   1     0   3   26 28                       54 50 0 0 0   1     0   3   26 28                 54
739683 739683 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2015   grade_1 32 0 0 0   0     0   1   23 10                       33 32 0 0 0   0     0   1   23 10                 33
739689 739689 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No 1 KG 05 2015   grade_1 49 0 2 0   0     0   2   30 23                       53 49 0 2 0   0     0   2   30 23                 53
739696 739696 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2015   grade_1 46 0 1 1   1     0   0   26 23                       49 46 0 1 1   1     0   0   26 23                 49
739702 739702 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2015   grade_1 61 0 3 0   1     0   0   30 35                       65 61 0 3 0   1     0   0   30 35                 65
739709 739709 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No 1 PK 05 2015   grade_1 59 0 7 1   2     0   0   34 35                       69 59 0 7 1   2     0   0   34 35                 69
739737 739737 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No 1 PK 03 2015   grade_1 55 0 1 0   2     0   1   34 25                       59 55 0 1 0   2     0   1   34 25                 59
739846 739846 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No 1 KG 05 2015   grade_1 37 0 0 0   1     0   2   19 21                       40 37 0 0 0   1     0   2   19 21                 40
739915 739915 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2015   grade_1 103 0 2 0   0     0   16   53 68                       121 103 0 2 0   0     0   16   53 68                 121
739963 739963 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No 1 PK 03 2015   grade_1 102 0 14 0   3     0   7   61 65                       126 102 0 14 0   3     0   7   61 65                 126
739978 739978 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No 1 PK 04 2015   grade_1 71 0 6 0   2     0   1   39 41                       80 71 0 6 0   2     0   1   39 41                 80
740041 740041 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_1 12 0 0 0   0     0   0   6 6                       12 12 0 0 0   0     0   0   6 6                 12
740119 740119 MA Norfolk   school 2508370 199   Needham 250837001317 1990040 William Mitchell   Regular School No 1 KG 05 2015   grade_1 64 0 4 0   6     0   1   34 41                       75 64 0 4 0   6     0   1   34 41                 75

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