enrollments

Data source: Big Local News · About: Big Local

979 rows where grade = "grade_1", state = "MA" and year = 2019 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 979 ✖

grade ✖

  • grade_1 · 979 ✖
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
2042765 2042765 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2043143 2043143 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2043505 2043505 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_1 1 2 3 0   0     0   0   5 1                       6.0 1 2 3 0   0     0   0   5 1                 6
2043434 2043434 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No Elementary PK 04 2019   grade_1 5 2 9 0   23     0   4   33 10                       43.0 5 2 9 0   23     0   4   33 10                 43
2045102 2045102 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Hedge   Regular School No Elementary KG 05 2019   grade_1 15 1 8 0   0     0   2   16 10                       26.0 15 1 8 0   0     0   2   16 10                 26
2045920 2045920 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   grade_1 3 5 31 0   0     0   0   29 10                       39.0 3 5 31 0   0     0   0   29 10                 39
2047036 2047036 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   grade_1 11 0 2 0   0     0   1   4 10                       14.0 11 0 2 0   0     0   1   4 10                 14
2048152 2048152 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2019   grade_1 17 0 0 0   0     0   3   10 10                       20.0 17 0 0 0   0     0   3   10 10                 20
2048281 2048281 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2019   grade_1 21 0 0 0   0     0   1   12 10                       22.0 21 0 0 0   0     0   1   12 10                 22
2048674 2048674 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2019   grade_1 25 0 2 0   0     0   1   18 10                       28.0 25 0 2 0   0     0   1   18 10                 28
2040009 2040009 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_1 123 9 25 1   36     0   10   100 104                       204.0 123 9 25 1   36     0   10   100 104                 204
2043900 2043900 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2019   grade_1 164 4 6 0   4     0   9   82 105                       187.0 164 4 6 0   4     0   9   82 105                 187
2043754 2043754 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   grade_1 183 7 9 1   20     0   14   128 106                       234.0 183 7 9 1   20     0   14   128 106                 234
2040316 2040316 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   grade_1 5 4 14 0   9     0   3   24 11                       35.0 5 4 14 0   9     0   3   24 11                 35
2040610 2040610 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2019   grade_1 12 4 4 0   0     0   3   12 11                       23.0 12 4 4 0   0     0   3   12 11                 23
2040682 2040682 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2019   grade_1 1 14 6 0   0     0   0   10 11                       21.0 1 14 6 0   0     0   0   10 11                 21
2040904 2040904 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_1 8 4 4 0   1     0   2   8 11                       19.0 8 4 4 0   1     0   2   8 11                 19
2046533 2046533 MA Middlesex   school 2512000 308   Waltham 251200002863 3080001 Waltham Public Schools Dual Language Program   Regular School No Elementary KG 02 2019   grade_1 8 1 29 0   0     0   0   27 11                       38.0 8 1 29 0   0     0   0   27 11                 38
2048233 2048233 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2019   grade_1 229 6 3 0   3     1   7   139 110                       249.0 229 6 3 0   3     1   7   139 110                 249
2042961 2042961 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2019   grade_1 144 2 6 0   62     0   12   111 115                       226.0 144 2 6 0   62     0   12   111 115                 226
2040129 2040129 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_1 121 13 8 0   50     0   19   92 119                       211.0 121 13 8 0   50     0   19   92 119                 211
2040328 2040328 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2019   grade_1 4 11 16 0   1     0   0   20 12                       32.0 4 11 16 0   1     0   0   20 12                 32
2040566 2040566 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2019   grade_1 3 14 4 0   0     0   0   9 12                       21.0 3 14 4 0   0     0   0   9 12                 21
2040689 2040689 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_1 20 4 3 0   0     0   0   15 12                       27.0 20 4 3 0   0     0   0   15 12                 27
2042650 2042650 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2019   grade_1 20 2 1 0   1     0   1   13 12                       25.0 20 2 1 0   1     0   1   13 12                 25
2042850 2042850 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   grade_1 24 1 3 0   0     0   0   16 12                       28.0 24 1 3 0   0     0   0   16 12                 28
2044383 2044383 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No Elementary KG 05 2019   grade_1 12 1 6 0   0     0   3   10 12                       22.0 12 1 6 0   0     0   3   10 12                 22
2045687 2045687 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_1 9 0 6 1   0     0   0   4 12                       16.0 9 0 6 1   0     0   0   4 12                 16
2047673 2047673 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_1 0 17 3 0   0     0   0   8 12                       20.0 0 17 3 0   0     0   0   8 12                 20
2048925 2048925 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2019   grade_1 28 0 2 0   0     0   0   18 12                       30.0 28 0 2 0   0     0   0   18 12                 30
2048954 2048954 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_1 24 0 3 0   0     0   0   15 12                       27.0 24 0 3 0   0     0   0   15 12                 27
2049023 2049023 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_1 22 0 2 1   0     0   5   18 12                       30.0 22 0 2 1   0     0   5   18 12                 30
2040292 2040292 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2019   grade_1 30 0 4 0   2     0   3   26 13                       39.0 30 0 4 0   2     0   3   26 13                 39
2040658 2040658 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2019   grade_1 4 7 8 0   1     0   2   9 13                       22.0 4 7 8 0   1     0   2   9 13                 22
2041753 2041753 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_1 30 0 0 0   0     0   1   18 13                       31.0 30 0 0 0   0     0   1   18 13                 31
2041836 2041836 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No Elementary PK 05 2019   grade_1 31 1 3 0   0     0   1   23 13                       36.0 31 1 3 0   0     0   1   23 13                 36
2042554 2042554 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2019   grade_1 23 0 2 0   0     0   0   12 13                       25.0 23 0 2 0   0     0   0   12 13                 25
2042711 2042711 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_1 21 0 1 0   0     0   0   9 13                       22.0 21 0 1 0   0     0   0   9 13                 22
2044923 2044923 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No Elementary KG 05 2019   grade_1 31 0 0 0   0     0   0   18 13                       31.0 31 0 0 0   0     0   0   18 13                 31
2048635 2048635 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2019   grade_1 22 0 1 0   0     0   1   11 13                       24.0 22 0 1 0   0     0   1   11 13                 24
2040814 2040814 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2019   grade_1 3 16 19 0   0     0   0   24 14                       38.0 3 16 19 0   0     0   0   24 14                 38
2040850 2040850 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2019   grade_1 10 6 7 0   5     0   3   17 14                       31.0 10 6 7 0   5     0   3   17 14                 31
2044390 2044390 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No Elementary PK 05 2019   grade_1 20 4 7 0   0     0   4   21 14                       35.0 20 4 7 0   0     0   4   21 14                 35
2044517 2044517 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 John Ward   Regular School No Elementary KG 05 2019   grade_1 31 0 2 0   3     0   3   25 14                       39.0 31 0 2 0   3     0   3   25 14                 39
2044719 2044719 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No Elementary KG 05 2019   grade_1 32 0 1 0   5     0   2   26 14                       40.0 32 0 1 0   5     0   2   26 14                 40
2046262 2046262 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2019   grade_1 22 0 2 0   1     0   3   14 14                       28.0 22 0 2 0   1     0   3   14 14                 28
2048485 2048485 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No Elementary KG 05 2019   grade_1 31 0 5 0   3     0   1   26 14                       40.0 31 0 5 0   3     0   1   26 14                 40
2048836 2048836 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2019   grade_1 21 0 0 0   0     0   2   9 14                       23.0 21 0 0 0   0     0   2   9 14                 23
2049350 2049350 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_1 13 7 2 0   1     0   1   10 14                       24.0 13 7 2 0   1     0   1   10 14                 24
2040742 2040742 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2019   grade_1 14 11 12 0   1     0   1   24 15                       39.0 14 11 12 0   1     0   1   24 15                 39
2040770 2040770 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2019   grade_1 3 15 14 1   1     0   4   23 15                       38.0 3 15 14 1   1     0   4   23 15                 38
2042083 2042083 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_1 28 3 11 1   0     0   0   28 15                       43.0 28 3 11 1   0     0   0   28 15                 43
2042495 2042495 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_1 23 1 1 0   1     0   2   13 15                       28.0 23 1 1 0   1     0   2   13 15                 28
2042915 2042915 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_1 3 0 36 0   1     0   0   25 15                       40.0 3 0 36 0   1     0   0   25 15                 40
2043618 2043618 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No Elementary KG 05 2019   grade_1 16 0 4 0   4     0   2   11 15                       26.0 16 0 4 0   4     0   2   11 15                 26
2044377 2044377 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2019   grade_1 21 4 12 0   0     0   0   22 15                       37.0 21 4 12 0   0     0   0   22 15                 37
2044707 2044707 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Marguerite E Peaslee   Regular School No Elementary KG 05 2019   grade_1 29 0 3 0   0     0   6   23 15                       38.0 29 0 3 0   0     0   6   23 15                 38
2044860 2044860 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2019   grade_1 11 1 13 1   1     0   3   15 15                       30.0 11 1 13 1   1     0   3   15 15                 30
2045193 2045193 MA Norfolk   school 2509870 243   Quincy 250987001560 2430040 Atherton Hough   Regular School No Elementary KG 05 2019   grade_1 19 2 1 0   14     0   2   23 15                       38.0 19 2 1 0   14     0   2   23 15                 38
2045928 2045928 MA Hampden   school 2511130 281   Springfield 251113001562 2810068 Glickman Elementary   Regular School No Elementary KG 05 2019   grade_1 9 8 26 1   0     0   3   32 15                       47.0 9 8 26 1   0     0   3   32 15                 47
2046022 2046022 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2019   grade_1 6 9 27 0   0     0   1   28 15                       43.0 6 9 27 0   0     0   1   28 15                 43
2046035 2046035 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No Elementary PK 05 2019   grade_1 4 3 25 0   0     0   2   19 15                       34.0 4 3 25 0   0     0   2   19 15                 34
2047259 2047259 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2019   grade_1 2 6 27 1   1     0   0   22 15                       37.0 2 6 27 1   1     0   0   22 15                 37
2047914 2047914 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_1 30 0 0 0   0     0   2   17 15                       32.0 30 0 0 0   0     0   2   17 15                 32
2048544 2048544 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2019   grade_1 16 0 4 0   0     0   2   7 15                       22.0 16 0 4 0   0     0   2   7 15                 22
2049059 2049059 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2019   grade_1 27 0 1 0   0     0   2   15 15                       30.0 27 0 1 0   0     0   2   15 15                 30
2040457 2040457 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No Elementary PK 05 2019   grade_1 1 20 8 0   6     0   2   21 16                       37.0 1 20 8 0   6     0   2   21 16                 37
2040576 2040576 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2019   grade_1 2 29 14 0   0     0   0   29 16                       45.0 2 29 14 0   0     0   0   29 16                 45
2040600 2040600 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2019   grade_1 7 26 10 2   1     0   2   32 16                       48.0 7 26 10 2   1     0   2   32 16                 48
2040763 2040763 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2019   grade_1 4 1 35 0   1     0   0   25 16                       41.0 4 1 35 0   1     0   0   25 16                 41
2042022 2042022 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2019   grade_1 25 1 4 1   1     0   2   18 16                       34.0 25 1 4 1   1     0   2   18 16                 34
2042976 2042976 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No Elementary PK 04 2019   grade_1 33 0 8 0   1     0   1   27 16                       43.0 33 0 8 0   1     0   1   27 16                 43
2043612 2043612 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lincoln-Thomson   Regular School No Elementary KG 05 2019   grade_1 12 2 21 0   3     0   1   23 16                       39.0 12 2 21 0   3     0   1   23 16                 39
2043720 2043720 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2019   grade_1 26 11 3 0   5     0   1   30 16                       46.0 26 11 3 0   5     0   1   30 16                 46
2044357 2044357 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2019   grade_1 12 4 11 0   0     0   6   17 16                       33.0 12 4 11 0   0     0   6   17 16                 33
2044688 2044688 MA Bristol   school 2508730 212   North Attleborough 250873001199 2120030 Community   Regular School No Elementary KG 05 2019   grade_1 28 5 5 0   2     0   2   26 16                       42.0 28 5 5 0   2     0   2   26 16                 42
2044963 2044963 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2019   grade_1 29 1 2 0   0     0   0   16 16                       32.0 29 1 2 0   0     0   0   16 16                 32
2045158 2045158 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2019   grade_1 32 0 1 0   0     0   0   17 16                       33.0 32 0 1 0   0     0   0   17 16                 33
2046198 2046198 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No Elementary KG 05 2019   grade_1 17 7 2 0   3     0   5   18 16                       34.0 17 7 2 0   3     0   5   18 16                 34
2046405 2046405 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_1 21 0 8 1   0     0   1   15 16                       31.0 21 0 8 1   0     0   1   15 16                 31
2048762 2048762 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No Elementary KG 04 2019   grade_1 33 1 2 0   0     0   1   21 16                       37.0 33 1 2 0   0     0   1   21 16                 37
2048871 2048871 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2019   grade_1 33 0 4 0   0     0   1   22 16                       38.0 33 0 4 0   0     0   1   22 16                 38
2040221 2040221 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_1 27 0 1 0   0     0   1   12 17                       29.0 27 0 1 0   0     0   1   12 17                 29
2040331 2040331 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2019   grade_1 1 21 12 1   1     0   0   19 17                       36.0 1 21 12 1   1     0   0   19 17                 36
2040481 2040481 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_1 8 14 20 0   0     0   2   27 17                       44.0 8 14 20 0   0     0   2   27 17                 44
2040797 2040797 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2019   grade_1 13 5 4 0   8     0   7   20 17                       37.0 13 5 4 0   8     0   7   20 17                 37
2041141 2041141 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2019   grade_1 33 1 5 0   1     0   3   26 17                       43.0 33 1 5 0   1     0   3   26 17                 43
2041504 2041504 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2019   grade_1 20 11 4 0   3     0   7   28 17                       45.0 20 11 4 0   3     0   7   28 17                 45
2041532 2041532 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2019   grade_1 7 23 10 0   5     0   2   30 17                       47.0 7 23 10 0   5     0   2   30 17                 47
2042561 2042561 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2019   grade_1 33 0 3 0   0     0   1   20 17                       37.0 33 0 3 0   0     0   1   20 17                 37
2044331 2044331 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary PK 05 2019   grade_1 10 6 21 0   1     0   4   25 17                       42.0 10 6 21 0   1     0   4   25 17                 42
2044565 2044565 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2019   grade_1 29 0 2 1   0     0   5   20 17                       37.0 29 0 2 1   0     0   5   20 17                 37
2044681 2044681 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 Roosevelt Avenue   Regular School No Elementary KG 05 2019   grade_1 32 0 1 0   2     0   0   18 17                       35.0 32 0 1 0   2     0   0   18 17                 35
2045287 2045287 MA Norfolk   school 2509930 244   Randolph 250993001593 2440040 Martin E Young Elementary   Regular School No Elementary KG 05 2019   grade_1 6 18 10 0   5     0   1   23 17                       40.0 6 18 10 0   5     0   1   23 17                 40
2045325 2045325 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Wood End Elementary School   Regular School No Elementary KG 05 2019   grade_1 34 3 1 0   1     0   3   25 17                       42.0 34 3 1 0   1     0   3   25 17                 42
2045528 2045528 MA Essex   school 2510500 262   Saugus 251050001680 2620040 Lynnhurst   Regular School No Elementary KG 05 2019   grade_1 34 0 6 0   3     0   0   26 17                       43.0 34 0 6 0   3     0   0   26 17                 43
2045773 2045773 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_1 13 8 16 0   3     0   1   24 17                       41.0 13 8 16 0   3     0   1   24 17                 41
2045922 2045922 MA Hampden   school 2511130 281   Springfield 251113001805 2810065 Glenwood   Regular School No Elementary KG 05 2019   grade_1 5 3 40 0   1     0   2   34 17                       51.0 5 3 40 0   1     0   2   34 17                 51
2046959 2046959 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No Elementary KG 05 2019   grade_1 36 0 2 0   6     0   2   29 17                       46.0 36 0 2 0   6     0   2   29 17                 46
2047116 2047116 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2019   grade_1 41 0 0 0   3     0   5   32 17                       49.0 41 0 0 0   3     0   5   32 17                 49

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