enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
744303 744303 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No 1 PK 04 2015   grade_1 9 0 1 0   0     0   0   5 5                       10 9 0 1 0   0     0   0   5 5                 10
744423 744423 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2015   grade_1 7 0 2 0   0     0   1   5 5                       10 7 0 2 0   0     0   1   5 5                 10
744897 744897 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2015   grade_1 8 0 0 0   1     0   1   8 2                       10 8 0 0 0   1     0   1   8 2                 10
736145 736145 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No 1 KG 05 2015   grade_1 82 4 5 0   9     0   0   53 47                       100 82 4 5 0   9     0   0   53 47                 100
737197 737197 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   grade_1 62 3 12 0   14     0   9   46 54                       100 62 3 12 0   14     0   9   46 54                 100
737474 737474 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2015   grade_1 80 1 2 2   11     0   4   58 42                       100 80 1 2 2   11     0   4   58 42                 100
738264 738264 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2015   grade_1 77 4 10 0   4     0   5   62 38                       100 77 4 10 0   4     0   5   62 38                 100
740313 740313 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Bowen   Regular School No 1 KG 05 2015   grade_1 58 7 3 0   31     0   1   51 49                       100 58 7 3 0   31     0   1   51 49                 100
743687 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
744281 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
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
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
741745 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
742457 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
744090 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
744475 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 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
745005 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
738053 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
738160 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
740774 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 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
737915 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
738240 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
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
740101 740101 MA Norfolk   school 2508370 199   Needham 250837001306 1990005 Broadmeadow   Regular School No 1 KG 05 2015   grade_1 83 2 5 0   9     0   4   48 55                       103 83 2 5 0   9     0   4   48 55                 103
742739 742739 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No 1 KG 02 2015   grade_1 84 0 3 0   12     0   4   47 56                       103 84 0 3 0   12     0   4   47 56                 103
742974 742974 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No 1 KG 02 2015   grade_1 91 0 8 0   1     0   3   44 59                       103 91 0 8 0   1     0   3   44 59                 103
735965 735965 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_1 69 18 7 0   3     1   6   46 58                       104 69 18 7 0   3     1   6   46 58                 104
736245 736245 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No 1 PK 05 2015   grade_1 9 20 70 0   3     0   2   58 46                       104 9 20 70 0   3     0   2   58 46                 104
737533 737533 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2015   grade_1 64 9 30 0   0     0   1   60 44                       104 64 9 30 0   0     0   1   60 44                 104
739503 739503 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2015   grade_1 10 9 73 0   7     0   5   51 53                       104 10 9 73 0   7     0   5   51 53                 104
739570 739570 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2015   grade_1 34 17 34 0   17     0   2   49 55                       104 34 17 34 0   17     0   2   49 55                 104
741765 741765 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No 1 PK 05 2015   grade_1 4 18 82 0   0     0   0   53 51                       104 4 18 82 0   0     0   0   53 51                 104
738671 738671 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No 1 PK 03 2015   grade_1 67 11 12 0   4     0   11   50 55                       105 67 11 12 0   4     0   11   50 55                 105
740801 740801 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Thomas Carroll   Regular School No 1 KG 05 2015   grade_1 85 2 12 0   1     0   5   52 53                       105 85 2 12 0   1     0   5   52 53                 105
741647 741647 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2015   grade_1 19 2 77 0   6     0   1   52 53                       105 19 2 77 0   6     0   1   52 53                 105
742803 742803 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 Philip G Coburn   Regular School No 1 KG 05 2015   grade_1 59 6 16 0   21     0   3   51 54                       105 59 6 16 0   21     0   3   51 54                 105
738432 738432 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2015   grade_1 91 2 4 1   4     0   4   63 43                       106 91 2 4 1   4     0   4   63 43                 106
742745 742745 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No 1 KG 02 2015   grade_1 69 1 0 0   29     0   7   51 55                       106 69 1 0 0   29     0   7   51 55                 106
744641 744641 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No 1 KG 04 2015   grade_1 96 1 2 0   2     0   5   57 49                       106 96 1 2 0   2     0   5   57 49                 106
736486 736486 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2015   grade_1 2 84 16 0   0     0   5   50 57                       107 2 84 16 0   0     0   5   50 57                 107
739084 739084 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No 1 KG 05 2015   grade_1 55 12 36 0   0     0   4   54 53                       107 55 12 36 0   0     0   4   54 53                 107
739430 739430 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No 1 KG 05 2015   grade_1 3 9 88 0   5     0   2   49 58                       107 3 9 88 0   5     0   2   49 58                 107
741697 741697 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No 1 PK 01 2015   grade_1 71 2 13 0   17     0   4   54 53                       107 71 2 13 0   17     0   4   54 53                 107
743117 743117 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_1 13 13 71 0   7     0   3   57 50                       107 13 13 71 0   7     0   3   57 50                 107
736472 736472 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No 1 PK 05 2015   grade_1 4 22 36 0   43     0   3   59 49                       108 4 22 36 0   43     0   3   59 49                 108
738276 738276 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_1 64 12 23 0   2     1   6   60 48                       108 64 12 23 0   2     1   6   60 48                 108
738359 738359 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   grade_1 73 6 23 0   0     0   6   63 45                       108 73 6 23 0   0     0   6   63 45                 108
738577 738577 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No 1 KG 04 2015   grade_1 55 3 40 1   4     0   5   61 47                       108 55 3 40 1   4     0   5   61 47                 108
741553 741553 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_1 55 2 10 0   39     0   2   46 62                       108 55 2 10 0   39     0   2   46 62                 108
743571 743571 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_1 24 31 38 0   8     0   7   56 52                       108 24 31 38 0   8     0   7   56 52                 108
744841 744841 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000202408 7670010 Lake Street   Regular School No 1 PK 01 2015   grade_1 90 3 10 0   1     0   4   56 52                       108 90 3 10 0   1     0   4   56 52                 108
740004 740004 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No 1 KG 05 2015   grade_1 84 14 6 0   2     0   3   62 47                       109 84 14 6 0   2     0   3   62 47                 109
742787 742787 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 01 2015   grade_1 100 0 1 0   0     0   8   57 52                       109 100 0 1 0   0     0   8   57 52                 109
744532 744532 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2015   grade_1 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
739882 739882 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2015   grade_1 60 4 35 0   8     0   3   55 55                       110 60 4 35 0   8     0   3   55 55                 110
736052 736052 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_1 72 2 3 0   23     0   11   64 47                       111 72 2 3 0   23     0   11   64 47                 111
737975 737975 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_1 34 12 59 1   2     0   3   59 52                       111 34 12 59 1   2     0   3   59 52                 111
739400 739400 MA Essex   school 2507110 163   Lynn 250711002658 1630005 Washington Elementary School   Regular School No 1 KG 05 2015   grade_1 2 15 84 0   5     0   5   63 48                       111 2 15 84 0   5     0   5   63 48                 111
739444 739444 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No 1 PK 05 2015   grade_1 4 14 81 0   5     0   7   63 48                       111 4 14 81 0   5     0   7   63 48                 111
739588 739588 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2015   grade_1 28 23 16 1   35     0   8   63 48                       111 28 23 16 1   35     0   8   63 48                 111
741003 741003 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No 1 PK 04 2015   grade_1 94 0 10 1   1     0   5   57 54                       111 94 0 10 1   1     0   5   57 54                 111
742215 742215 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 East Taunton Elementary   Regular School No 1 KG 04 2015   grade_1 91 11 6 0   0     0   3   61 50                       111 91 11 6 0   0     0   3   61 50                 111
744240 744240 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No 1 PK 01 2015   grade_1 92 4 10 0   1     0   4   52 59                       111 92 4 10 0   1     0   4   52 59                 111
744914 744914 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No 1 KG 02 2015   grade_1 95 0 6 0   4     0   6   57 54                       111 95 0 6 0   4     0   6   57 54                 111
737244 737244 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2015   grade_1 57 3 11 0   28     0   13   47 65                       112 57 3 11 0   28     0   13   47 65                 112
737966 737966 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_1 39 11 51 0   7     0   4   55 57                       112 39 11 51 0   7     0   4   55 57                 112
741726 741726 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2015   grade_1 91 0 12 0   2     0   7   68 44                       112 91 0 12 0   2     0   7   68 44                 112
741943 741943 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2015   grade_1 2 13 95 0   1     0   1   69 43                       112 2 13 95 0   1     0   1   69 43                 112
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
740661 740661 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No 1 KG 03 2015   grade_1 107 1 2 0   2     0   1   60 53                       113 107 1 2 0   2     0   1   60 53                 113
741059 741059 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2015   grade_1 44 14 12 0   35     1   7   67 46                       113 44 14 12 0   35     1   7   67 46                 113
741235 741235 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 William McKinley   Regular School No 1 KG 05 2015   grade_1 31 4 68 0   4     1   5   59 54                       113 31 4 68 0   4     1   5   59 54                 113
741803 741803 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No 1 PK 05 2015   grade_1 3 33 77 0   0     0   0   58 55                       113 3 33 77 0   0     0   0   58 55                 113
743616 743616 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_1 68 20 5 0   16     0   4   57 56                       113 68 20 5 0   16     0   4   57 56                 113
739794 739794 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No 1 PK 05 2015   grade_1 75 10 10 1   13     0   5   60 54                       114 75 10 10 1   13     0   5   60 54                 114
737085 737085 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No 1 KG 05 2015   grade_1 37 52 11 0   11     0   4   54 61                       115 37 52 11 0   11     0   4   54 61                 115
738040 738040 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_1 60 9 36 0   1     0   9   56 59                       115 60 9 36 0   1     0   9   56 59                 115
738081 738081 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2015   grade_1 67 9 24 0   6     0   9   58 57                       115 67 9 24 0   6     0   9   58 57                 115
741229 741229 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   grade_1 51 7 52 0   4     0   1   54 61                       115 51 7 52 0   4     0   1   54 61                 115
743867 743867 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_1 97 2 13 0   2     0   1   57 58                       115 97 2 13 0   2     0   1   57 58                 115
739449 739449 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2015   grade_1 10 12 80 0   9     0   5   56 60                       116 10 12 80 0   9     0   5   56 60                 116
740198 740198 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2015   grade_1 38 13 53 1   0     0   11   62 54                       116 38 13 53 1   0     0   11   62 54                 116
741854 741854 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No 1 PK 05 2015   grade_1 22 19 73 0   2     0   1   66 51                       117 22 19 73 0   2     0   1   66 51                 117
737444 737444 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2015   grade_1 113 1 2 0   0     0   2   59 59                       118 113 1 2 0   0     0   2   59 59                 118
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
739045 739045 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   grade_1 101 11 4 1   1     0   0   67 51                       118 101 11 4 1   1     0   0   67 51                 118
739072 739072 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2015   grade_1 61 8 42 1   5     0   1   66 52                       118 61 8 42 1   5     0   1   66 52                 118
744193 744193 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   grade_1 89 7 6 5   2     0   9   59 59                       118 89 7 6 5   2     0   9   59 59                 118
742736 742736 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No 1 KG 02 2015   grade_1 96 0 3 0   17     0   3   57 62                       119 96 0 3 0   17     0   3   57 62                 119
736175 736175 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No 1 KG 08 2015   grade_1 2 4 2 0   3     0   1   6 6                       12 2 4 2 0   3     0   1   6 6                 12
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
741270 741270 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_1 11 0 1 0   0     0   0   3 9                       12 11 0 1 0   0     0   0   3 9                 12
741579 741579 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_1 10 0 0 0   0     0   2   2 10                       12 10 0 0 0   0     0   2   2 10                 12
744136 744136 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_1 11 0 1 0   0     0   0   2 10                       12 11 0 1 0   0     0   0   2 10                 12
744151 744151 MA Berkshire   school 2503390 635   Central Berkshire 250339002545 6350010 Berkshire Trail Elementary   Regular School No 1 PK 05 2015   grade_1 12 0 0 0   0     0   0   5 7                       12 12 0 0 0   0     0   0   5 7                 12
738258 738258 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_1 30 3 82 0   2     0   3   60 60                       120 30 3 82 0   2     0   3   60 60                 120
739437 739437 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No 1 PK 05 2015   grade_1 6 9 83 0   20     0   2   62 58                       120 6 9 83 0   20     0   2   62 58                 120

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