enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
2229469 2229469 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston: Charles H Taylor   Regular School No Elementary PK 05 2018   grade_2 0 54 13 1   1     0   3   38 34                       72.0 0 54 13 1   1     0   3   38 34                 72
2229585 2229585 MA Suffolk   school 2502790 35   Boston 250279002569 350138 Boston: O W Holmes   Regular School No Elementary PK 05 2018   grade_2 0 31 15 0   2     0   8   36 20                       56.0 0 31 15 0   2     0   8   36 20                 56
2229666 2229666 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston: John Winthrop   Regular School No Elementary PK 05 2018   grade_2 0 24 13 0   2     0   2   18 23                       41.0 0 24 13 0   2     0   2   18 23                 41
2229723 2229723 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Boston: Harvard-Kent   Regular School No Elementary PK 05 2018   grade_2 0 20 23 0   16     0   3   42 20                       62.0 0 20 23 0   16     0   3   42 20                 62
2229784 2229784 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   grade_2 0 16 3 0   1     0   1   10 11                       21.0 0 16 3 0   1     0   1   10 11                 21
2229891 2229891 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_2 0 14 39 0   0     0   2   26 29                       55.0 0 14 39 0   0     0   2   26 29                 55
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
2229960 2229960 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_2 0 31 27 0   2     0   2   31 31                       62.0 0 31 27 0   2     0   2   31 31                 62
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
2235967 2235967 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 Springfield: William N. DeBerry   Regular School No Elementary KG 05 2018   grade_2 0 5 36 0   0     0   1   24 18                       42.0 0 5 36 0   0     0   1   24 18                 42
2237921 2237921 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School (District): Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2018   grade_2 0 26 18 0   0     0   0   17 27                       44.0 0 26 18 0   0     0   0   17 27                 44
2237987 2237987 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District): Bridge Boston Charter School   Regular School Yes Elementary PK 06 2018   grade_2 0 25 14 0   1     0   0   20 20                       40.0 0 25 14 0   1     0   0   20 20                 40
2238063 2238063 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District): Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 06 2018   grade_2 0 0 41 0   1     0   0   25 17                       42.0 0 0 41 0   1     0   0   25 17                 42
2238098 2238098 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_2 0 15 5 0   0     0   0   10 10                       20.0 0 15 5 0   0     0   0   10 10                 20
2238124 2238124 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_2 0 1 49 0   0     0   0   22 28                       50.0 0 1 49 0   0     0   0   22 28                 50
2238269 2238269 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School (District): KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2018   grade_2 0 53 21 0   0     0   0   38 36                       74.0 0 53 21 0   0     0   0   38 36                 74
2239956 2239956 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District): UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2018   grade_2 0 43 28 0   1     0   2   41 33                       74.0 0 43 28 0   1     0   2   41 33                 74
2229493 2229493 MA Suffolk   school 2502790 35   Boston 250279000220 350072 Boston: David A Ellis   Regular School No Elementary PK 05 2018   grade_2 1 26 39 1   0     0   1   34 34                       68.0 1 26 39 1   0     0   1   34 34                 68
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
2229747 2229747 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_2 1 19 36 1   0     0   2   31 28                       59.0 1 19 36 1   0     0   2   31 28                 59
2229802 2229802 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_2 1 58 32 1   2     0   4   46 52                       98.0 1 58 32 1   2     0   4   46 52                 98
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
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
2232433 2232433 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 Holyoke: H.B. Lawrence School   Regular School No Elementary KG 03 2018   grade_2 1 3 67 0   0     0   1   39 33                       72.0 1 3 67 0   0     0   1   39 33                 72
2232664 2232664 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_2 1 1 73 0   2     0   2   38 41                       79.0 1 1 73 0   2     0   2   38 41                 79
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
2233221 2233221 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Lynn: Wm P Connery   Regular School No Elementary PK 05 2018   grade_2 1 5 76 0   12     0   3   52 45                       97.0 1 5 76 0   12     0   3   52 45                 97
2233269 2233269 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn: William R Fallon   Regular School No Elementary KG 06 2018   grade_2 1 1 8 0   0     0   1   10 1                       11.0 1 1 8 0   0     0   1   10 1                 11
2238233 2238233 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   grade_2 1 0 83 0   0     0   0   36 48                       84.0 1 0 83 0   0     0   0   36 48                 84
2229569 2229569 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston: George H Conley   Regular School No Elementary PK 05 2018   grade_2 10 17 17 0   2     0   2   24 24                       48.0 10 17 17 0   2     0   2   24 24                 48
2229682 2229682 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston: Joseph J Hurley   Regular School No Elementary PK 08 2018   grade_2 10 5 33 0   0     0   1   28 21                       49.0 10 5 33 0   0     0   1   28 21                 49
2229704 2229704 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston: Joseph P Manning   Regular School No Elementary PK 05 2018   grade_2 10 5 7 0   1     0   1   13 11                       24.0 10 5 7 0   1     0   1   13 11                 24
2229971 2229971 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston: Winship Elementary   Regular School No Elementary PK 05 2018   grade_2 10 4 15 0   2     0   1   21 11                       32.0 10 4 15 0   2     0   1   21 11                 32
2229979 2229979 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston: Edison K-8   Regular School No Elementary PK 08 2018   grade_2 10 12 27 0   15     0   2   37 29                       66.0 10 12 27 0   15     0   2   37 29                 66
2232822 2232822 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett: Leverett Elementary   Regular School No Elementary PK 06 2018   grade_2 10 0 1 0   0     0   1   7 5                       12.0 10 0 1 0   0     0   1   7 5                 12
2233184 2233184 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Lynn: Aborn   Regular School No Elementary KG 05 2018   grade_2 10 4 12 0   3     0   7   18 18                       36.0 10 4 12 0   3     0   7   18 18                 36
2236136 2236136 MA Hampden   school 2511130 281   Springfield 251113001837 2810190 Springfield: White Street   Regular School No Elementary KG 05 2018   grade_2 10 22 41 0   3     0   1   41 36                       77.0 10 22 41 0   3     0   1   41 36                 77
2236750 2236750 MA Middlesex   school 2512000 308   Waltham 251200001969 3080065 Waltham: Henry Whittemore Elementary School   Regular School No Elementary KG 05 2018   grade_2 10 7 58 0   0     0   1   39 37                       76.0 10 7 58 0   0     0   1   39 37                 76
2237597 2237597 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Worcester: Canterbury   Regular School No Elementary PK 06 2018   grade_2 10 7 20 0   4     0   5   25 21                       46.0 10 7 20 0   4     0   5   25 21                 46
2237666 2237666 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Worcester: Goddard School/Science Technical   Regular School No Elementary PK 06 2018   grade_2 10 7 41 1   4     0   3   33 33                       66.0 10 7 41 1   4     0   3   33 33                 66
2238406 2238406 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter Public (District): Seven Hills Charter School   Regular School Yes Elementary KG 08 2018   grade_2 10 46 25 0   0     0   7   46 42                       88.0 10 46 25 0   0     0   7   46 42                 88
2238920 2238920 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_2 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2230305 2230305 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford: Harry Lee Cole   Regular School No Elementary PK 02 2018   grade_2 100 0 4 1   3     0   5   60 53                       113.0 100 0 4 1   3     0   5   60 53                 113
2234763 2234763 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Oxford: Clara Barton   Regular School No Elementary 02 04 2018   grade_2 100 3 14 0   1     0   8   66 60                       126.0 100 3 14 0   1     0   8   66 60                 126
2236341 2236341 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge: Burgess Elementary   Regular School No Elementary PK 06 2018   grade_2 100 1 7 0   0     0   3   67 44                       111.0 100 1 7 0   0     0   3   67 44                 111
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
2236586 2236586 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough: Tyngsborough Elementary   Regular School No Elementary PK 05 2018   grade_2 101 6 5 0   5     0   5   55 67                       122.0 101 6 5 0   5     0   5   55 67                 122
2239761 2239761 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Whitman-Hanson: Maquan Elementary   Regular School No Elementary PK 02 2018   grade_2 101 1 2 0   0     0   6   59 51                       110.0 101 1 2 0   0     0   6   59 51                 110
2233787 2233787 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough: Mary K. Goode Elementary School   Regular School No Elementary 01 05 2018   grade_2 102 3 2 0   0     0   3   58 52                       110.0 102 3 2 0   0     0   3   58 52                 110
2233820 2233820 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Milford: Brookside   Regular School No Elementary KG 02 2018   grade_2 102 6 47 1   5     0   6   85 82                       167.0 102 6 47 1   5     0   6   85 82                 167
2238706 2238706 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 Blackstone-Millville: John F Kennedy Elementary   Regular School No Elementary KG 02 2018   grade_2 102 2 8 0   1     0   6   74 45                       119.0 102 2 8 0   1     0   6   74 45                 119
2239545 2239545 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Southwick-Tolland-Granville Regional School District: Woodland School   Regular School No Elementary PK 02 2018   grade_2 102 2 3 0   0     0   1   58 50                       108.0 102 2 3 0   0     0   1   58 50                 108
2233155 2233155 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg: Lunenburg Primary School   Regular School No Elementary PK 02 2018   grade_2 103 3 8 0   5     0   4   63 60                       123.0 103 3 8 0   5     0   4   63 60                 123
2238877 2238877 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley-Charlton Reg: Dudley Elementary   Regular School No Elementary 02 04 2018   grade_2 103 5 16 0   0     0   3   64 63                       127.0 103 5 16 0   0     0   3   64 63                 127
2231035 2231035 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton: Clinton Elementary   Regular School No Elementary PK 03 2018   grade_2 104 5 30 0   3     0   3   73 72                       145.0 104 5 30 0   3     0   3   73 72                 145
2237382 2237382 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington: Shawsheen Elementary   Regular School No Elementary 01 03 2018   grade_2 107 3 5 0   5     0   3   62 61                       123.0 107 3 5 0   5     0   3   62 61                 123
2237472 2237472 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 Winthrop: William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2018   grade_2 107 1 25 0   0     0   3   63 73                       136.0 107 1 25 0   0     0   3   63 73                 136
2233840 2233840 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury: Elmwood Street   Regular School No Elementary PK 03 2018   grade_2 109 0 7 0   4     0   5   79 46                       125.0 109 0 7 0   4     0   5   79 46                 125
2229461 2229461 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Boston: Charles Sumner   Regular School No Elementary PK 05 2018   grade_2 11 18 55 0   1     0   5   41 49                       90.0 11 18 55 0   1     0   5   41 49                 90
2229765 2229765 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Boston: Mozart   Regular School No Elementary PK 05 2018   grade_2 11 8 6 0   1     0   2   19 9                       28.0 11 8 6 0   1     0   2   19 9                 28
2232363 2232363 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_2 11 1 17 0   0     0   2   17 14                       31.0 11 1 17 0   0     0   2   17 14                 31
2232609 2232609 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence: Robert Frost   Regular School No Elementary KG 04 2018   grade_2 11 3 97 0   2     0   1   59 55                       114.0 11 3 97 0   2     0   1   59 55                 114
2233060 2233060 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Lowell: Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2018   grade_2 11 6 25 0   40     0   4   49 37                       86.0 11 6 25 0   40     0   4   49 37                 86
2235820 2235820 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville: Winter Hill Community   Regular School No Elementary PK 08 2018   grade_2 11 6 19 0   1     0   3   24 15                       40.0 11 6 19 0   1     0   3   24 15                 40
2236070 2236070 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Springfield: Mary A. Dryden Veterans Memorial School   Regular School No Elementary PK 05 2018   grade_2 11 5 32 0   3     0   3   22 32                       54.0 11 5 32 0   3     0   3   22 32                 54
2237588 2237588 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Worcester: Burncoat Street   Regular School No Elementary KG 06 2018   grade_2 11 7 27 0   0     0   3   26 22                       48.0 11 7 27 0   0     0   3   26 22                 48
2237836 2237836 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_2 11 10 23 0   1     0   3   25 23                       48.0 11 10 23 0   1     0   3   25 23                 48
2232911 2232911 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Littleton: Shaker Lane Elementary   Regular School No Elementary PK 02 2018   grade_2 110 2 2 0   9     0   3   57 69                       126.0 110 2 2 0   9     0   3   57 69                 126
2236603 2236603 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge: Taft Early Learning Center   Regular School No Elementary PK 02 2018   grade_2 110 4 7 0   2     0   4   66 61                       127.0 110 4 7 0   2     0   4   66 61                 127
2237161 2237161 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport: Alice A Macomber   Regular School No Elementary PK 02 2018   grade_2 110 0 2 0   0     0   4   67 49                       116.0 110 0 2 0   0     0   4   67 49                 116
2238934 2238934 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Freetown-Lakeville: Assawompset Elementary School   Regular School No Elementary KG 03 2018   grade_2 110 5 0 0   2     0   6   55 68                       123.0 110 5 0 0   2     0   6   55 68                 123
2232144 2232144 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover: Center Elementary   Regular School No Elementary KG 02 2018   grade_2 111 0 2 0   2     0   1   51 65                       116.0 111 0 2 0   2     0   1   51 65                 116
2228761 2228761 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   grade_2 113 4 8 0   5     1   1   59 73                       132.0 113 4 8 0   5     1   1   59 73                 132
2236531 2236531 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 Tewksbury: L F Dewing   Regular School No Elementary PK 02 2018   grade_2 113 5 7 0   3     0   2   73 57                       130.0 113 5 7 0   3     0   2   73 57                 130
2230836 2230836 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver: Carver Elementary School   Regular School No Elementary PK 05 2018   grade_2 115 1 3 0   2     0   1   67 55                       122.0 115 1 3 0   2     0   1   67 55                 122
2235892 2235892 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 South Hadley: Mosier   Regular School No Elementary 02 04 2018   grade_2 115 1 18 0   2     0   2   78 60                       138.0 115 1 18 0   2     0   2   78 60                 138
2231927 2231927 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   grade_2 116 9 38 0   4     0   15   81 101                       182.0 116 9 38 0   4     0   15   81 101                 182
2229509 2229509 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   grade_2 12 16 12 0   0     0   5   25 20                       45.0 12 16 12 0   0     0   5   25 20                 45
2229558 2229558 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston: Franklin D Roosevelt   Regular School No Elementary PK 08 2018   grade_2 12 10 17 0   2     1   1   26 17                       43.0 12 10 17 0   2     1   1   26 17                 43
2229859 2229859 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston: Josiah Quincy   Regular School No Elementary PK 05 2018   grade_2 12 15 14 1   71     0   4   58 59                       117.0 12 15 14 1   71     0   4   58 59                 117
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
2232994 2232994 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell: Pyne Arts   Regular School No Elementary PK 08 2018   grade_2 12 2 23 0   9     0   2   27 21                       48.0 12 2 23 0   9     0   2   27 21                 48
2233005 2233005 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Lowell: Abraham Lincoln   Regular School No Elementary PK 04 2018   grade_2 12 6 24 1   29     0   3   45 30                       75.0 12 6 24 1   29     0   3   45 30                 75
2233019 2233019 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Lowell: Charles W Morey   Regular School No Elementary PK 04 2018   grade_2 12 6 8 1   63     0   2   46 46                       92.0 12 6 8 1   63     0   2   46 46                 92
2233249 2233249 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn: Ingalls   Regular School No Elementary KG 05 2018   grade_2 12 8 63 0   13     0   8   53 51                       104.0 12 8 63 0   13     0   8   53 51                 104
2236950 2236950 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet: Wellfleet Elementary   Regular School No Elementary PK 05 2018   grade_2 12 1 0 0   0     0   3   6 10                       16.0 12 1 0 0   0     0   3   6 10                 16
2237564 2237564 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Worcester: Belmont Street Community   Regular School No Elementary PK 06 2018   grade_2 12 19 39 0   3     0   3   38 38                       76.0 12 19 39 0   3     0   3   38 38                 76
2237641 2237641 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Worcester: Columbus Park   Regular School No Elementary PK 06 2018   grade_2 12 7 33 0   5     0   4   33 28                       61.0 12 7 33 0   5     0   4   33 28                 61
2238565 2238565 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_2 12 2 3 0   27     0   1   28 17                       45.0 12 2 3 0   27     0   1   28 17                 45
2239235 2239235 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail: Sanderson Academy   Regular School No Elementary PK 06 2018   grade_2 12 0 0 0   0     0   0   4 8                       12.0 12 0 0 0   0     0   0   4 8                 12

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