enrollments

Data source: Big Local News · About: Big Local

989 rows where grade = "grade_1", state = "MA" and year = 2018 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 989 ✖

grade ✖

  • grade_1 · 989 ✖
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
2229998 2229998 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2230204 2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2231638 2231638 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2232016 2232016 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2232238 2232238 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2233065 2233065 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2233130 2233130 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell: Lowell Day School on Broadway   Special Education School No Elementary PK 06 2018   grade_1 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2237222 2237222 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2228775 2228775 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_1 72 0 5 1   0     0   3   39 42                       81.0 72 0 5 1   0     0   3   39 42                 81
2228877 2228877 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover: Bancroft Elementary   Regular School No Elementary KG 05 2018   grade_1 60 0 4 0   7     0   7   48 30                       78.0 60 0 4 0   7     0   7   48 30                 78
2228900 2228900 MA Essex   school 2501950 9   Andover 250195000050 90020 Andover: South Elementary   Regular School No Elementary KG 05 2018   grade_1 70 0 1 0   7     0   1   44 35                       79.0 70 0 1 0   7     0   1   44 35                 79
2228945 2228945 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   grade_1 67 0 1 0   21     0   1   49 41                       90.0 67 0 1 0   21     0   1   49 41                 90
2229177 2229177 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham: South Elementary   Regular School No Elementary KG 03 2018   grade_1 76 0 3 0   1     0   0   43 37                       80.0 76 0 3 0   1     0   0   43 37                 80
2229204 2229204 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Belmont: Winn Brook   Regular School No Elementary KG 04 2018   grade_1 58 0 2 0   27     0   9   53 43                       96.0 58 0 2 0   27     0   9   53 43                 96
2229210 2229210 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Belmont: Mary Lee Burbank   Regular School No Elementary KG 04 2018   grade_1 50 0 0 0   13     1   8   38 34                       72.0 50 0 0 0   13     1   8   38 34                 72
2229240 2229240 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   grade_1 87 0 1 0   0     0   1   48 41                       89.0 87 0 1 0   0     0   1   48 41                 89
2229252 2229252 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_1 25 0 1 0   1     0   1   17 11                       28.0 25 0 1 0   1     0   1   17 11                 28
2229275 2229275 MA Essex   school 2502640 30   Beverly 250264000169 300033 Beverly: Hannah Elementary   Regular School No Elementary KG 05 2018   grade_1 37 0 11 0   0     0   7   26 29                       55.0 37 0 11 0   0     0   7   26 29                 55
2229282 2229282 MA Essex   school 2502640 30   Beverly 250264000173 300040 Beverly: North Beverly Elementary   Regular School No Elementary KG 05 2018   grade_1 39 0 10 0   1     0   3   30 23                       53.0 39 0 10 0   1     0   3   30 23                 53
2229312 2229312 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica: Frederick J Dutile   Regular School No Elementary KG 05 2018   grade_1 41 0 2 0   2     0   0   19 26                       45.0 41 0 2 0   2     0   0   19 26                 45
2229319 2229319 MA Middlesex   school 2502670 31   Billerica 250267000181 310012 Billerica: John F Kennedy   Regular School No Elementary KG 05 2018   grade_1 39 0 1 0   2     0   1   22 21                       43.0 39 0 1 0   2     0   1   22 21                 43
2229484 2229484 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston: Dante Alighieri Montessori School   Regular School No Elementary PK 05 2018   grade_1 6 0 7 0   0     0   0   6 7                       13.0 6 0 7 0   0     0   0   6 7                 13
2229592 2229592 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston: Hugh Roe O'Donnell   Regular School No Elementary PK 05 2018   grade_1 2 0 29 0   2     0   0   18 15                       33.0 2 0 29 0   2     0   0   18 15                 33
2229703 2229703 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston: Joseph P Manning   Regular School No Elementary PK 05 2018   grade_1 6 0 9 0   2     0   3   7 13                       20.0 6 0 9 0   2     0   3   7 13                 20
2230224 2230224 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_1 7 0 66 0   1     0   1   46 29                       75.0 7 0 66 0   1     0   1   46 29                 75
2230253 2230253 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_1 5 0 44 0   1     0   0   21 29                       50.0 5 0 44 0   1     0   0   21 29                 50
2230287 2230287 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Bourne: Peebles Elementary School   Regular School No Elementary KG 04 2018   grade_1 48 0 6 0   3     0   1   32 26                       58.0 48 0 6 0   3     0   1   32 26                 58
2230304 2230304 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford: Harry Lee Cole   Regular School No Elementary PK 02 2018   grade_1 76 0 3 0   5     0   8   49 43                       92.0 76 0 3 0   5     0   8   49 43                 92
2230314 2230314 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston: Boylston Elementary   Regular School No Elementary PK 05 2018   grade_1 26 0 2 1   2     0   2   17 16                       33.0 26 0 2 1   2     0   2   17 16                 33
2230388 2230388 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_1 33 0 1 0   1     0   0   17 18                       35.0 33 0 1 0   1     0   0   17 18                 35
2230529 2230529 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_1 35 0 1 1   0     0   1   23 15                       38.0 35 0 1 1   0     0   1   23 15                 38
2230824 2230824 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_1 39 0 5 0   9     0   4   33 24                       57.0 39 0 5 0   9     0   4   33 24                 57
2230970 2230970 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee: Litwin   Regular School No Elementary KG 05 2018   grade_1 22 0 5 0   0     0   0   14 13                       27.0 22 0 5 0   0     0   0   14 13                 27
2230991 2230991 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Chicopee: Streiber Memorial School   Regular School No Elementary KG 05 2018   grade_1 33 0 15 0   1     1   3   21 32                       53.0 33 0 15 0   1     1   3   21 32                 53
2231023 2231023 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_1 16 0 0 0   0     0   0   7 9                       16.0 16 0 0 0   0     0   0   7 9                 16
2231077 2231077 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Concord: Thoreau   Regular School No Elementary PK 05 2018   grade_1 58 0 4 0   4     0   6   36 36                       72.0 58 0 4 0   4     0   6   36 36                 72
2231097 2231097 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway: Conway Grammar   Regular School No Elementary PK 06 2018   grade_1 15 0 2 0   0     0   0   11 6                       17.0 15 0 2 0   0     0   0   11 6                 17
2231120 2231120 MA Essex   school 2503990 71   Danvers 250399000536 710030 Danvers: Riverside   Regular School No Elementary PK 05 2018   grade_1 35 0 4 1   2     0   2   21 23                       44.0 35 0 4 1   2     0   2   21 23                 44
2231127 2231127 MA Essex   school 2503990 71   Danvers 250399000534 710032 Danvers: Ivan G Smith   Regular School No Elementary KG 05 2018   grade_1 39 0 4 0   1     1   1   17 29                       46.0 39 0 4 0   1     1   1   17 29                 46
2231160 2231160 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 Dartmouth: George H Potter   Regular School No Elementary PK 05 2018   grade_1 59 0 2 0   0     0   1   30 32                       62.0 59 0 2 0   0     0   1   30 32                 62
2231229 2231229 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas: Douglas Primary School   Regular School No Elementary PK 01 2018   grade_1 73 0 2 0   0     0   3   42 36                       78.0 73 0 2 0   0     0   3   42 36                 78
2231297 2231297 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury: Chandler Elementary   Regular School No Elementary PK 02 2018   grade_1 171 0 4 0   2     0   5   89 93                       182.0 171 0 4 0   2     0   5   89 93                 182
2231335 2231335 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Easthampton: Center School   Regular School No Elementary KG 04 2018   grade_1 32 0 6 1   0     0   4   21 22                       43.0 32 0 6 1   0     0   4   21 22                 43
2231348 2231348 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton: Neil A Pepin   Regular School No Elementary KG 04 2018   grade_1 29 0 5 0   3     0   4   25 16                       41.0 29 0 5 0   3     0   4   25 16                 41
2231415 2231415 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_1 28 0 7 1   0     0   2   16 22                       38.0 28 0 7 1   0     0   2   16 22                 38
2231426 2231426 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_1 10 0 0 0   0     0   3   8 5                       13.0 10 0 0 0   0     0   3   8 5                 13
2231508 2231508 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 Fairhaven: East Fairhaven   Regular School No Elementary PK 05 2018   grade_1 62 0 3 0   0     0   3   33 35                       68.0 62 0 3 0   0     0   3   33 35                 68
2231749 2231749 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_1 7 0 0 0   0     0   0   3 4                       7.0 7 0 0 0   0     0   0   3 4                 7
2231869 2231869 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   grade_1 35 0 1 0   0     1   1   22 16                       38.0 35 0 1 0   0     1   1   22 16                 38
2231883 2231883 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   grade_1 50 0 4 1   2     3   2   31 31                       62.0 50 0 4 1   2     3   2   31 31                 62
2231890 2231890 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   grade_1 52 0 3 0   3     0   3   33 28                       61.0 52 0 3 0   3     0   3   33 28                 61
2231904 2231904 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   grade_1 41 0 1 0   2     0   0   22 22                       44.0 41 0 1 0   2     0   0   22 22                 44
2231953 2231953 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_1 87 0 2 0   0     0   3   45 47                       92.0 87 0 2 0   0     0   3   45 47                 92
2231969 2231969 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Gloucester: Beeman Memorial   Regular School No Elementary KG 05 2018   grade_1 56 0 7 0   0     0   1   32 32                       64.0 56 0 7 0   0     0   1   32 32                 64
2231976 2231976 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester: East Gloucester Elementary   Regular School No Elementary KG 05 2018   grade_1 22 0 1 0   0     0   1   12 12                       24.0 22 0 1 0   0     0   1   12 12                 24
2232031 2232031 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 Grafton: South Grafton Elementary   Regular School No Elementary PK 01 2018   grade_1 93 0 7 0   21     0   7   75 53                       128.0 93 0 7 0   21     0   7   75 53                 128
2232063 2232063 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 Granby: West Street   Regular School No Elementary PK 03 2018   grade_1 34 0 6 1   1     0   3   21 24                       45.0 34 0 6 1   1     0   3   21 24                 45
2232137 2232137 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Hanover: Cedar Elementary   Regular School No Elementary PK 04 2018   grade_1 71 0 3 0   1     0   0   43 32                       75.0 71 0 3 0   1     0   0   43 32                 75
2232177 2232177 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_1 27 0 2 0   0     0   1   17 12                       30.0 27 0 2 0   0     0   1   17 12                 30
2232192 2232192 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Haverhill: Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2018   grade_1 6 0 18 0   0     0   2   14 12                       26.0 6 0 18 0   0     0   2   14 12                 26
2232275 2232275 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 Hingham: East Elementary School   Regular School No Elementary PK 05 2018   grade_1 67 0 1 0   0     0   0   35 33                       68.0 67 0 1 0   0     0   0   35 33                 68
2232282 2232282 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Hingham: Wm L Foster Elementary   Regular School No Elementary KG 05 2018   grade_1 75 0 4 0   1     0   5   49 36                       85.0 75 0 4 0   1     0   5   49 36                 85
2232329 2232329 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland: Holland Elementary   Regular School No Elementary PK 06 2018   grade_1 30 0 0 0   2     0   0   17 15                       32.0 30 0 0 0   2     0   0   17 15                 32
2232373 2232373 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke: Morgan Full Service Community School   Regular School No Elementary PK 08 2018   grade_1 0 0 40 0   1     0   1   19 23                       42.0 0 0 40 0   1     0   1   19 23                 42
2232390 2232390 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_1 1 0 61 0   0     0   0   33 29                       62.0 1 0 61 0   0     0   0   33 29                 62
2232401 2232401 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke: E N White Elementary   Regular School No Elementary PK 08 2018   grade_1 9 0 55 0   0     0   2   32 34                       66.0 9 0 55 0   0     0   2   32 34                 66
2232411 2232411 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke: Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2018   grade_1 12 0 54 0   1     0   0   35 32                       67.0 12 0 54 0   1     0   0   35 32                 67
2232448 2232448 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale: Memorial   Regular School No Elementary KG 06 2018   grade_1 64 0 6 0   0     0   4   44 30                       74.0 64 0 6 0   0     0   4   44 30                 74
2232484 2232484 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Hudson: Mulready Elementary   Regular School No Elementary PK 04 2018   grade_1 38 0 7 0   0     0   2   19 28                       47.0 38 0 7 0   0     0   2   19 28                 47
2232539 2232539 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Ipswich: Winthrop   Regular School No Elementary PK 05 2018   grade_1 42 0 3 0   0     0   5   26 24                       50.0 42 0 3 0   0     0   5   26 24                 50
2232580 2232580 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence: South Lawrence East Elementary School   Regular School No Elementary 01 05 2018   grade_1 8 0 144 0   2     0   1   87 68                       155.0 8 0 144 0   2     0   1   87 68                 155
2232634 2232634 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_1 1 0 90 0   0     0   1   45 47                       92.0 1 0 90 0   0     0   1   45 47                 92
2232656 2232656 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence: John K Tarbox   Regular School No Elementary 01 05 2018   grade_1 2 0 60 0   0     0   1   30 33                       63.0 2 0 60 0   0     0   1   30 33                 63
2232663 2232663 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_1 1 0 76 0   1     0   1   41 38                       79.0 1 0 76 0   1     0   1   41 38                 79
2232714 2232714 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee: Lee Elementary   Regular School No Elementary PK 06 2018   grade_1 35 0 7 0   1     0   1   21 23                       44.0 35 0 7 0   1     0   1   21 23                 44
2232821 2232821 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   grade_1 14 0 0 0   0     0   3   11 6                       17.0 14 0 0 0   0     0   3   11 6                 17
2232866 2232866 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Lexington: Maria Hastings   Regular School No Elementary KG 05 2018   grade_1 29 0 3 0   49     0   8   50 39                       89.0 29 0 3 0   49     0   8   50 39                 89
2232910 2232910 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Littleton: Shaker Lane Elementary   Regular School No Elementary PK 02 2018   grade_1 102 0 0 0   8     0   3   58 55                       113.0 102 0 0 0   8     0   3   58 55                 113
2232927 2232927 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Longmeadow: Blueberry Hill   Regular School No Elementary KG 05 2018   grade_1 52 0 4 0   10     0   5   39 32                       71.0 52 0 4 0   10     0   5   39 32                 71
2233262 2233262 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn: Lynn Woods   Regular School No Elementary KG 05 2018   grade_1 14 0 5 0   2     0   5   12 14                       26.0 14 0 5 0   2     0   5   12 14                 26
2233268 2233268 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn: William R Fallon   Regular School No Elementary KG 06 2018   grade_1 0 0 5 0   0     0   1   5 1                       6.0 0 0 5 0   0     0   1   5 1                 6
2233455 2233455 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Marblehead: Glover   Regular School No Elementary PK 03 2018   grade_1 90 0 3 0   1     0   2   49 47                       96.0 90 0 3 0   1     0   2   49 47                 96
2233469 2233469 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Marion: Sippican   Regular School No Elementary PK 06 2018   grade_1 56 0 2 1   0     0   2   36 25                       61.0 56 0 2 1   0     0   2   36 25                 61
2233507 2233507 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield: Eames Way School   Regular School No Elementary KG 05 2018   grade_1 43 0 0 0   0     0   0   26 17                       43.0 43 0 0 0   0     0   0   26 17                 43
2233514 2233514 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 Marshfield: South River   Regular School No Elementary KG 05 2018   grade_1 57 0 2 0   0     0   4   41 22                       63.0 57 0 2 0   0     0   4   41 22                 63
2233522 2233522 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield: Daniel Webster   Regular School No Elementary PK 05 2018   grade_1 47 0 4 0   2     1   0   25 29                       54.0 47 0 4 0   2     1   0   25 29                 54
2233529 2233529 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Marshfield: Gov Edward Winslow   Regular School No Elementary KG 05 2018   grade_1 64 0 2 0   1     0   1   43 25                       68.0 64 0 2 0   1     0   1   43 25                 68
2233537 2233537 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Marshfield: Martinson Elementary   Regular School No Elementary PK 05 2018   grade_1 61 0 5 0   1     0   3   41 29                       70.0 61 0 5 0   1     0   3   41 29                 70
2233572 2233572 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Mattapoisett: Center   Regular School No Elementary PK 03 2018   grade_1 43 0 0 0   0     0   3   19 27                       46.0 43 0 0 0   0     0   3   19 27                 46
2233733 2233733 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen: Marsh Grammar School   Regular School No Elementary PK 08 2018   grade_1 85 0 46 0   5     1   8   74 71                       145.0 85 0 46 0   5     1   8   74 71                 145
2233805 2233805 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Middleton: Fuller Meadow   Regular School No Elementary KG 02 2018   grade_1 73 0 4 1   3     0   3   40 44                       84.0 73 0 4 1   3     0   3   40 44                 84
2233856 2233856 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Millis: Clyde F Brown   Regular School No Elementary PK 04 2018   grade_1 68 0 8 0   0     0   6   38 44                       82.0 68 0 8 0   0     0   6   38 44                 82
2233913 2233913 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Monson: Quarry Hill Community School   Regular School No Elementary PK 04 2018   grade_1 67 0 2 0   0     0   2   44 27                       71.0 67 0 2 0   0     0   2   44 27                 71
2233930 2233930 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_1 19 0 0 0   0     0   0   8 11                       19.0 19 0 0 0   0     0   0   8 11                 19
2233962 2233962 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Natick: Brown   Regular School No Elementary KG 04 2018   grade_1 72 0 9 0   29     0   6   59 57                       116.0 72 0 9 0   29     0   6   59 57                 116
2234262 2234262 MA Middlesex   school 2508610 207   Newton 250861001360 2070025 Newton: Cabot   Regular School No Elementary KG 05 2018   grade_1 41 0 2 0   9     0   5   31 26                       57.0 41 0 2 0   9     0   5   31 26                 57
2234394 2234394 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams: Greylock   Regular School No Elementary PK 06 2018   grade_1 28 0 4 0   1     0   4   25 12                       37.0 28 0 4 0   1     0   4   25 12                 37
2234419 2234419 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Northampton: Bridge Street   Regular School No Elementary PK 05 2018   grade_1 29 0 12 0   0     0   7   27 21                       48.0 29 0 12 0   0     0   7   27 21                 48
2234434 2234434 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Northampton: Leeds   Regular School No Elementary PK 05 2018   grade_1 34 0 3 0   0     0   3   26 14                       40.0 34 0 3 0   0     0   3   26 14                 40
2234465 2234465 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover: Franklin   Regular School No Elementary KG 05 2018   grade_1 50 0 5 0   14     0   3   43 29                       72.0 50 0 5 0   14     0   3   43 29                 72

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