enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_2", state = "MA" and year = 2018 sorted by multiracial

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 976 ✖

grade ✖

  • grade_2 · 976 ✖
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
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2230264 2230264 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_2 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2231639 2231639 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_2 * * * *   *     *   *   * *                       0.0                                             0
2232017 2232017 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2232130 2232130 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_2 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2235437 2235437 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_2 * * * *   *     *   *   1 3                       4.0                         1 3                 4
2237223 2237223 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2228795 2228795 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam: Benjamin J Phelps   Regular School No Elementary KG 04 2018   grade_2 63 0 1 0   1     0   0   38 27                       65.0 63 0 1 0   1     0   0   38 27                 65
2228854 2228854 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_2 25 5 11 0   10     0   0   29 22                       51.0 25 5 11 0   10     0   0   29 22                 51
2228870 2228870 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_2 29 9 14 0   6     0   0   31 27                       58.0 29 9 14 0   6     0   0   31 27                 58
2228908 2228908 MA Essex   school 2501950 9   Andover 250195000051 90025 Andover: West Elementary   Regular School No Elementary KG 05 2018   grade_2 72 1 7 0   17     0   0   47 50                       97.0 72 1 7 0   17     0   0   47 50                 97
2229178 2229178 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham: South Elementary   Regular School No Elementary KG 03 2018   grade_2 77 1 4 0   1     0   0   45 38                       83.0 77 1 4 0   1     0   0   45 38                 83
2229363 2229363 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   grade_2 2 30 15 0   4     1   0   27 25                       52.0 2 30 15 0   4     1   0   27 25                 52
2229387 2229387 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston: Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2018   grade_2 0 18 20 0   0     0   0   17 21                       38.0 0 18 20 0   0     0   0   17 21                 38
2229429 2229429 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Boston: Higginson   Regular School No Elementary PK 02 2018   grade_2 0 18 25 1   1     0   0   22 23                       45.0 0 18 25 1   1     0   0   22 23                 45
2229477 2229477 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston: Curtis Guild   Regular School No Elementary PK 05 2018   grade_2 9 1 31 0   0     0   0   20 21                       41.0 9 1 31 0   0     0   0   20 21                 41
2229531 2229531 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston: Edward Everett   Regular School No Elementary PK 05 2018   grade_2 2 20 10 0   7     0   0   22 17                       39.0 2 20 10 0   7     0   0   22 17                 39
2229593 2229593 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston: Hugh Roe O'Donnell   Regular School No Elementary PK 05 2018   grade_2 1 2 35 0   0     0   0   18 20                       38.0 1 2 35 0   0     0   0   18 20                 38
2229611 2229611 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   grade_2 1 19 36 0   1     0   0   25 32                       57.0 1 19 36 0   1     0   0   25 32                 57
2229622 2229622 MA Suffolk   school 2502790 35   Boston 250279000255 350154 Boston: James J Chittick   Regular School No Elementary PK 05 2018   grade_2 3 30 9 0   1     0   0   25 18                       43.0 3 30 9 0   1     0   0   25 18                 43
2229654 2229654 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston: John D Philbrick   Regular School No Elementary PK 05 2018   grade_2 4 13 5 0   0     0   0   13 9                       22.0 4 13 5 0   0     0   0   13 9                 22
2229792 2229792 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_2 15 10 4 0   1     0   0   14 16                       30.0 15 10 4 0   1     0   0   14 16                 30
2229831 2229831 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston: Patrick J Kennedy   Regular School No Elementary PK 05 2018   grade_2 5 0 44 0   1     0   0   33 17                       50.0 5 0 44 0   1     0   0   33 17                 50
2229875 2229875 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston: Samuel Adams   Regular School No Elementary PK 05 2018   grade_2 7 1 39 1   0     0   0   22 26                       48.0 7 1 39 1   0     0   0   22 26                 48
2229913 2229913 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston: Thomas J Kenny   Regular School No Elementary PK 05 2018   grade_2 9 20 11 0   6     0   0   25 21                       46.0 9 20 11 0   6     0   0   25 21                 46
2229952 2229952 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston: William E Russell   Regular School No Elementary PK 05 2018   grade_2 0 21 27 1   8     1   0   26 32                       58.0 0 21 27 1   8     1   0   26 32                 58
2230009 2230009 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_2 0 35 9 0   0     0   0   20 24                       44.0 0 35 9 0   0     0   0   20 24                 44
2230031 2230031 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_2 9 3 9 0   0     1   0   14 8                       22.0 9 3 9 0   0     1   0   14 8                 22
2230225 2230225 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_2 1 3 66 0   1     0   0   38 33                       71.0 1 3 66 0   1     0   0   38 33                 71
2230331 2230331 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Braintree: Highlands   Regular School No Elementary KG 05 2018   grade_2 69 4 2 1   9     0   0   49 36                       85.0 69 4 2 1   9     0   0   49 36                 85
2230358 2230358 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Braintree: Donald Ross   Regular School No Elementary KG 05 2018   grade_2 31 3 2 0   6     0   0   27 15                       42.0 31 3 2 0   6     0   0   27 15                 42
2230389 2230389 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_2 25 1 0 0   1     0   0   15 12                       27.0 25 1 0 0   1     0   0   15 12                 27
2230530 2230530 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_2 40 0 2 0   0     0   0   19 23                       42.0 40 0 2 0   0     0   0   19 23                 42
2230957 2230957 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Chicopee: Bowie   Regular School No Elementary KG 05 2018   grade_2 46 2 12 1   1     1   0   41 22                       63.0 46 2 12 1   1     1   0   41 22                 63
2230978 2230978 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Chicopee: Lambert-Lavoie   Regular School No Elementary KG 05 2018   grade_2 42 1 14 0   0     0   0   30 27                       57.0 42 1 14 0   0     0   0   30 27                 57
2230992 2230992 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Chicopee: Streiber Memorial School   Regular School No Elementary KG 05 2018   grade_2 32 3 8 0   0     0   0   23 20                       43.0 32 3 8 0   0     0   0   23 20                 43
2230999 2230999 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Chicopee: Gen John J Stefanik   Regular School No Elementary KG 05 2018   grade_2 13 8 51 0   0     0   0   32 40                       72.0 13 8 51 0   0     0   0   32 40                 72
2231057 2231057 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset: Joseph Osgood   Regular School No Elementary PK 02 2018   grade_2 101 4 0 0   3     0   0   57 51                       108.0 101 4 0 0   3     0   0   57 51                 108
2231121 2231121 MA Essex   school 2503990 71   Danvers 250399000536 710030 Danvers: Riverside   Regular School No Elementary PK 05 2018   grade_2 27 1 4 0   2     0   0   10 24                       34.0 27 1 4 0   2     0   0   10 24                 34
2231135 2231135 MA Essex   school 2503990 71   Danvers 250399000538 710045 Danvers: Willis E Thorpe   Regular School No Elementary KG 05 2018   grade_2 42 0 3 0   1     0   0   24 22                       46.0 42 0 3 0   1     0   0   24 22                 46
2231192 2231192 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham: Greenlodge   Regular School No Elementary 01 05 2018   grade_2 30 3 3 0   1     0   0   19 18                       37.0 30 3 3 0   1     0   0   19 18                 37
2231263 2231263 MA Middlesex   school 2504320 79   Dracut 250432000582 790030 Dracut: Greenmont Avenue   Regular School No Elementary KG 05 2018   grade_2 42 2 9 0   2     0   0   24 31                       55.0 42 2 9 0   2     0   0   24 31                 55
2231270 2231270 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Dracut: Brookside Elementary   Regular School No Elementary KG 05 2018   grade_2 51 5 9 0   7     0   0   39 33                       72.0 51 5 9 0   7     0   0   39 33                 72
2231329 2231329 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham: Eastham Elementary   Regular School No Elementary PK 05 2018   grade_2 22 2 1 0   1     0   0   10 16                       26.0 22 2 1 0   1     0   0   10 16                 26
2231437 2231437 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett: Sumner G. Whittier School   Regular School No Elementary KG 08 2018   grade_2 12 7 42 1   7     0   0   25 44                       69.0 12 7 42 1   7     0   0   25 44                 69
2231448 2231448 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Everett: Webster School   Regular School No Elementary PK 05 2018   grade_2 16 7 21 0   5     0   0   25 24                       49.0 16 7 21 0   5     0   0   25 24                 49
2231667 2231667 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth: Teaticket   Regular School No Elementary PK 04 2018   grade_2 43 6 5 0   0     0   0   21 33                       54.0 43 6 5 0   0     0   0   21 33                 54
2231750 2231750 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_2 8 0 0 0   0     0   0   4 4                       8.0 8 0 0 0   0     0   0   4 4                 8
2231766 2231766 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Foxborough: Vincent M Igo Elementary   Regular School No Elementary KG 04 2018   grade_2 57 1 4 0   4     0   0   30 36                       66.0 57 1 4 0   4     0   0   30 36                 66
2231877 2231877 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin: Helen Keller Elementary   Regular School No Elementary KG 05 2018   grade_2 65 3 1 0   4     1   0   41 33                       74.0 65 3 1 0   4     1   0   41 33                 74
2231905 2231905 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   grade_2 33 0 0 0   0     0   0   18 15                       33.0 33 0 0 0   0     0   0   18 15                 33
2231954 2231954 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_2 93 0 4 0   3     0   0   55 45                       100.0 93 0 4 0   3     0   0   55 45                 100
2232084 2232084 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield: Discovery School at Four Corners   Regular School No Elementary KG 04 2018   grade_2 42 0 5 0   0     0   0   27 20                       47.0 42 0 5 0   0     0   0   27 20                 47
2232138 2232138 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Hanover: Cedar Elementary   Regular School No Elementary PK 04 2018   grade_2 70 2 0 0   1     0   0   34 39                       73.0 70 2 0 0   1     0   0   34 39                 73
2232178 2232178 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_2 22 0 2 0   1     0   0   13 12                       25.0 22 0 2 0   1     0   0   13 12                 25
2232193 2232193 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Haverhill: Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2018   grade_2 25 0 10 0   0     0   0   20 15                       35.0 25 0 10 0   0     0   0   20 15                 35
2232212 2232212 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   grade_2 64 1 11 0   3     0   0   47 32                       79.0 64 1 11 0   3     0   0   47 32                 79
2232374 2232374 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke: Morgan Full Service Community School   Regular School No Elementary PK 08 2018   grade_2 1 2 44 0   1     0   0   27 21                       48.0 1 2 44 0   1     0   0   27 21                 48
2232556 2232556 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston: Kingston Elementary   Regular School No Elementary KG 02 2018   grade_2 161 0 4 1   0     0   0   88 78                       166.0 161 0 4 1   0     0   0   88 78                 166
2232566 2232566 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough: Lanesborough Elementary   Regular School No Elementary PK 06 2018   grade_2 18 1 0 0   0     0   0   6 13                       19.0 18 1 0 0   0     0   0   6 13                 19
2232588 2232588 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence: Community Day Arlington   Regular School No Elementary KG 04 2018   grade_2 3 3 120 0   0     0   0   67 59                       126.0 3 3 120 0   0     0   0   67 59                 126
2232619 2232619 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence: Gerard A. Guilmette   Regular School No Elementary 01 04 2018   grade_2 3 3 122 0   2     0   0   75 55                       130.0 3 3 122 0   2     0   0   75 55                 130
2232635 2232635 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_2 5 1 94 0   0     0   0   55 45                       100.0 5 1 94 0   0     0   0   55 45                 100
2232641 2232641 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence: Oliver Partnership School   Regular School No Elementary 01 05 2018   grade_2 4 0 77 0   0     0   0   36 45                       81.0 4 0 77 0   0     0   0   36 45                 81
2232695 2232695 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_2 1 0 5 0   0     0   0   5 1                       6.0 1 0 5 0   0     0   0   5 1                 6
2233046 2233046 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Lowell: Washington   Regular School No Elementary PK 04 2018   grade_2 7 3 11 0   19     0   0   14 26                       40.0 7 3 11 0   19     0   0   14 26                 40
2233538 2233538 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Marshfield: Martinson Elementary   Regular School No Elementary PK 05 2018   grade_2 45 0 1 0   2     0   0   19 29                       48.0 45 0 1 0   2     0   0   19 29                 48
2233689 2233689 MA Middlesex   school 2507620 178   Melrose 250762001190 1780017 Melrose: Herbert Clark Hoover   Regular School No Elementary KG 05 2018   grade_2 38 0 3 0   1     0   0   19 23                       42.0 38 0 3 0   1     0   0   19 23                 42
2233931 2233931 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant: Johnson   Regular School No Elementary PK 06 2018   grade_2 19 0 0 0   0     0   0   8 11                       19.0 19 0 0 0   0     0   0   8 11                 19
2234133 2234133 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 New Bedford: Carlos Pacheco   Regular School No Elementary KG 05 2018   grade_2 18 6 29 1   1     0   0   30 25                       55.0 18 6 29 1   1     0   0   30 25                 55
2234164 2234164 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 New Bedford: Thomas R Rodman   Regular School No Elementary KG 05 2018   grade_2 13 0 8 0   0     0   0   10 11                       21.0 13 0 8 0   0     0   0   10 11                 21
2234225 2234225 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Newburyport: Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2018   grade_2 126 2 10 0   0     0   0   73 65                       138.0 126 2 10 0   0     0   0   73 65                 138
2234321 2234321 MA Middlesex   school 2508610 207   Newton 250861001379 2070115 Newton: Underwood   Regular School No Elementary KG 05 2018   grade_2 27 0 3 0   10     0   0   20 20                       40.0 27 0 3 0   10     0   0   20 20                 40
2234600 2234600 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield: North Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_2 34 0 0 0   0     0   0   20 14                       34.0 34 0 0 0   0     0   0   20 14                 34
2234630 2234630 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 North Reading: J Turner Hood   Regular School No Elementary KG 05 2018   grade_2 49 1 1 0   3     0   0   23 31                       54.0 49 1 1 0   3     0   0   23 31                 54
2234711 2234711 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood: John P Oldham   Regular School No Elementary 01 05 2018   grade_2 38 7 3 0   5     0   0   23 30                       53.0 38 7 3 0   5     0   0   23 30                 53
2234805 2234805 MA Essex   school 2509360 229   Peabody 250936001501 2290005 Peabody: Captain Samuel Brown   Regular School No Elementary KG 05 2018   grade_2 50 1 8 0   1     0   0   33 27                       60.0 50 1 8 0   1     0   0   33 27                 60
2234842 2234842 MA Essex   school 2509360 229   Peabody 250936001506 2290027 Peabody: William A Welch Sr   Regular School No Elementary PK 05 2018   grade_2 40 2 17 0   0     0   0   36 23                       59.0 40 2 17 0   0     0   0   36 23                 59
2234858 2234858 MA Essex   school 2509360 229   Peabody 250936001505 2290045 Peabody: West Memorial   Regular School No Elementary PK 05 2018   grade_2 38 1 1 0   0     0   0   26 14                       40.0 38 1 1 0   0     0   0   26 14                 40
2234890 2234890 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Pembroke: Hobomock Elementary   Regular School No Elementary KG 06 2018   grade_2 68 0 0 0   1     0   0   37 32                       69.0 68 0 0 0   1     0   0   37 32                 69
2235006 2235006 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Plainville: Anna Ware Jackson   Regular School No Elementary PK 03 2018   grade_2 72 2 7 0   2     0   0   45 38                       83.0 72 2 7 0   2     0   0   45 38                 83
2235026 2235026 MA Plymouth   school 2509720 239   Plymouth 250972001540 2390011 Plymouth: Federal Furnace School   Regular School No Elementary KG 05 2018   grade_2 52 4 3 0   0     0   0   29 30                       59.0 52 4 3 0   0     0   0   29 30                 59
2235086 2235086 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton: Dennett Elementary   Regular School No Elementary KG 06 2018   grade_2 34 0 1 0   0     0   0   15 20                       35.0 34 0 1 0   0     0   0   15 20                 35
2235176 2235176 MA Norfolk   school 2509870 243   Quincy 250987002492 2430110 Quincy: Wollaston School   Regular School No Elementary KG 05 2018   grade_2 22 0 1 0   32     0   0   29 26                       55.0 22 0 1 0   32     0   0   29 26                 55
2235276 2235276 MA Middlesex   school 2509990 246   Reading 250999001608 2460017 Reading: J Warren Killam   Regular School No Elementary KG 05 2018   grade_2 68 4 2 0   7     0   0   50 31                       81.0 68 4 2 0   7     0   0   50 31                 81
2235283 2235283 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Reading: Wood End Elementary School   Regular School No Elementary KG 05 2018   grade_2 46 1 0 0   1     0   0   33 15                       48.0 46 1 0 0   1     0   0   33 15                 48
2235311 2235311 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Revere: Beachmont Veterans Memorial School   Regular School No Elementary PK 05 2018   grade_2 21 1 30 0   0     0   0   25 27                       52.0 21 1 30 0   0     0   0   25 27                 52
2235323 2235323 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Revere: Abraham Lincoln   Regular School No Elementary PK 05 2018   grade_2 42 8 45 0   1     0   0   53 43                       96.0 42 8 45 0   1     0   0   53 43                 96
2235330 2235330 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Revere: Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2018   grade_2 35 9 69 1   2     0   0   47 69                       116.0 35 9 69 1   2     0   0   47 69                 116
2235371 2235371 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_2 14 1 2 0   0     0   0   8 9                       17.0 14 1 2 0   0     0   0   8 9                 17
2235420 2235420 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport: Rockport Elementary   Regular School No Elementary PK 05 2018   grade_2 73 0 0 0   0     0   0   39 34                       73.0 73 0 0 0   0     0   0   39 34                 73
2235461 2235461 MA Essex   school 2510380 258   Salem 251038002559 2580025 Salem: Nathaniel Bowditch   Regular School No Elementary KG 08 2018   grade_2 7 3 32 0   1     0   0   24 19                       43.0 7 3 32 0   1     0   0   24 19                 43
2235478 2235478 MA Essex   school 2510380 258   Salem 251038000773 2580050 Salem: Saltonstall School   Regular School No Elementary KG 08 2018   grade_2 24 2 13 0   1     0   0   16 24                       40.0 24 2 13 0   1     0   0   16 24                 40
2235515 2235515 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich: Forestdale School   Regular School No Elementary PK 02 2018   grade_2 195 3 9 0   6     1   0   106 108                       214.0 195 3 9 0   6     1   0   106 108                 214
2235532 2235532 MA Essex   school 2510500 262   Saugus 251050001680 2620040 Saugus: Lynnhurst   Regular School No Elementary KG 05 2018   grade_2 26 3 7 0   8     0   0   23 21                       44.0 26 3 7 0   8     0   0   23 21                 44
2235547 2235547 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Saugus: Veterans Memorial   Regular School No Elementary PK 05 2018   grade_2 63 2 13 0   3     0   0   38 43                       81.0 63 2 13 0   3     0   0   38 43                 81
2235572 2235572 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy: Emma L Miller Elementary School   Regular School No Elementary PK 05 2018   grade_2 9 0 0 0   0     0   0   6 3                       9.0 9 0 0 0   0     0   0   6 3                 9
2235586 2235586 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Scituate: Hatherly Elementary   Regular School No Elementary KG 05 2018   grade_2 45 1 1 0   1     0   0   23 25                       48.0 45 1 1 0   1     0   0   23 25                 48
2235696 2235696 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Shrewsbury: Walter J Paton   Regular School No Elementary KG 04 2018   grade_2 54 0 9 1   14     0   0   43 35                       78.0 54 0 9 1   14     0   0   43 35                 78
2235722 2235722 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury: Shutesbury Elementary   Regular School No Elementary PK 06 2018   grade_2 9 0 1 0   0     0   0   7 3                       10.0 9 0 1 0   0     0   0   7 3                 10

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