enrollments

Data source: Big Local News · About: Big Local

953 rows where grade = "grade_4", state = "MA" and year = 2015 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 953 ✖

grade ✖

  • grade_4 · 953 ✖
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
738077 738077 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_4 * * * *   *     *   *   4 *                       4                         4                   4
738208 738208 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_4 * * * *   *     *   *   2 2                       4                         2 2                 4
738425 738425 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 04 05 2015   grade_4 * * * *   *     *   *   * *                       1                                             1
738473 738473 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No 2 04 07 2015   grade_4 * * * *   *     *   *   1 *                       1                         1                   1
738602 738602 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_4 * * * *   *     *   *   3 1                       4                         3 1                 4
739317 739317 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_4 * * * *   *     *   *   3 *                       4                         3                   4
739398 739398 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No 1 PK 05 2015   grade_4 * * * *   *     *   *   3 1                       4                         3 1                 4
741455 741455 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2015   grade_4 * * * *   *     *   *   1 2                       3                         1 2                 3
736269 736269 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 04 2015   grade_4 0 0 6 0   0     0   0   2 4                       6 0 0 6 0   0     0   0   2 4                 6
736311 736311 MA Suffolk   school 2502790 35   Boston 250279000229 350094 Elihu Greenwood Leadership Academy   Regular School No 1 KG 05 2015   grade_4 0 32 20 0   0     0   1   27 26                       53 0 32 20 0   0     0   1   27 26                 53
736328 736328 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2015   grade_4 0 11 15 0   0     1   2   13 16                       29 0 11 15 0   0     1   2   13 16                 29
736386 736386 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2015   grade_4 0 22 15 0   0     0   2   18 21                       39 0 22 15 0   0     0   2   18 21                 39
736407 736407 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No 1 PK 05 2015   grade_4 0 38 57 0   1     0   13   50 59                       109 0 38 57 0   1     0   13   50 59                 109
736503 736503 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_4 0 12 35 0   0     0   1   24 24                       48 0 12 35 0   0     0   1   24 24                 48
736536 736536 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_4 0 16 6 0   0     0   0   10 12                       22 0 16 6 0   0     0   0   10 12                 22
736634 736634 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_4 0 11 34 0   1     0   0   24 22                       46 0 11 34 0   1     0   0   24 22                 46
736738 736738 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_4 0 16 7 1   1     0   0   11 14                       25 0 16 7 1   1     0   0   11 14                 25
736748 736748 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_4 0 27 27 0   0     0   0   26 28                       54 0 27 27 0   0     0   0   26 28                 54
736917 736917 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_4 0 4 22 0   0     0   0   10 16                       26 0 4 22 0   0     0   0   10 16                 26
736955 736955 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_4 0 3 4 0   0     0   0   3 4                       7 0 3 4 0   0     0   0   3 4                 7
738723 738723 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_4 0 3 31 0   0     0   0   13 21                       34 0 3 31 0   0     0   0   13 21                 34
743473 743473 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_4 0 31 9 1   1     0   2   20 24                       44 0 31 9 1   1     0   2   20 24                 44
743671 743671 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   grade_4 0 0 56 0   0     0   0   26 30                       56 0 0 56 0   0     0   0   26 30                 56
743765 743765 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_4 0 26 14 0   1     0   0   24 17                       41 0 26 14 0   1     0   0   24 17                 41
743796 743796 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   grade_4 0 85 25 0   0     0   3   65 48                       113 0 85 25 0   0     0   3   65 48                 113
743880 743880 MA Hampden   school 2500089 492   Martin Luther King Jr. Charter School of Excellence (District) 250008902127 4920005 Martin Luther King Jr. Charter School of Excellence   Regular School Yes 1 KG 05 2015   grade_4 0 29 27 1   0     0   3   38 22                       60 0 29 27 1   0     0   3   38 22                 60
736255 736255 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2015   grade_4 1 66 8 0   3     0   0   49 29                       78 1 66 8 0   3     0   0   49 29                 78
736275 736275 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2015   grade_4 1 16 39 0   0     0   0   27 29                       56 1 16 39 0   0     0   0   27 29                 56
736489 736489 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2015   grade_4 1 56 24 0   0     0   1   54 28                       82 1 56 24 0   0     0   1   54 28                 82
736512 736512 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_4 1 12 12 0   0     0   1   11 15                       26 1 12 12 0   0     0   1   11 15                 26
736627 736627 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2015   grade_4 1 17 13 0   1     0   3   16 19                       35 1 17 13 0   1     0   3   16 19                 35
736671 736671 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2015   grade_4 1 28 20 0   2     0   0   28 23                       51 1 28 20 0   2     0   0   28 23                 51
736697 736697 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 06 2015   grade_4 1 32 15 0   0     0   2   28 22                       50 1 32 15 0   0     0   2   28 22                 50
736722 736722 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_4 1 34 15 0   0     0   0   28 22                       50 1 34 15 0   0     0   0   28 22                 50
736732 736732 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_4 1 28 18 0   0     0   2   25 24                       49 1 28 18 0   0     0   2   25 24                 49
736945 736945 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2015   grade_4 1 0 43 0   0     0   1   18 27                       45 1 0 43 0   0     0   1   18 27                 45
738901 738901 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_4 1 2 123 0   0     0   0   67 59                       126 1 2 123 0   0     0   0   67 59                 126
738940 738940 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_4 1 1 97 0   0     0   0   47 52                       99 1 1 97 0   0     0   0   47 52                 99
738958 738958 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_4 1 0 58 0   0     0   0   30 29                       59 1 0 58 0   0     0   0   30 29                 59
741741 741741 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No 1 KG 05 2015   grade_4 1 7 8 0   0     0   0   12 4                       16 1 7 8 0   0     0   0   12 4                 16
743565 743565 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_4 1 0 20 0   1     0   0   11 11                       22 1 0 20 0   1     0   0   11 11                 22
745161 745161 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 06 2015   grade_4 1 43 24 0   1     0   5   33 41                       74 1 43 24 0   1     0   5   33 41                 74
737373 737373 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No 1 PK 05 2015   grade_4 10 6 3 0   7     0   3   15 14                       29 10 6 3 0   7     0   3   15 14                 29
737495 737495 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_4 10 11 92 0   1     0   1   63 52                       115 10 11 92 0   1     0   1   63 52                 115
739302 739302 MA Middlesex   school 2507020 160   Lowell 250702001051 1600055 Washington   Regular School No 1 PK 04 2015   grade_4 10 4 6 0   10     0   4   16 18                       34 10 4 6 0   10     0   4   16 18                 34
739452 739452 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2015   grade_4 10 8 64 0   10     0   2   50 44                       94 10 8 64 0   10     0   2   50 44                 94
740194 740194 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No 1 KG 05 2015   grade_4 10 3 26 0   0     0   3   24 18                       42 10 3 26 0   0     0   3   24 18                 42
741660 741660 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2015   grade_4 10 6 6 0   2     0   0   13 11                       24 10 6 6 0   2     0   0   13 11                 24
742442 742442 MA Middlesex   school 2512000 308   Waltham 251200001969 3080065 Henry Whittemore Elementary School   Regular School No 1 KG 05 2015   grade_4 10 4 43 0   0     0   2   31 28                       59 10 4 43 0   0     0   2   31 28                 59
743105 743105 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   grade_4 10 20 36 0   7     0   3   28 48                       76 10 20 36 0   7     0   3   28 48                 76
743174 743174 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   grade_4 10 7 31 0   5     0   5   33 25                       58 10 7 31 0   5     0   5   33 25                 58
743228 743228 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   grade_4 10 18 29 0   3     0   3   28 35                       63 10 18 29 0   3     0   3   28 35                 63
743332 743332 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   grade_4 10 12 42 0   4     0   6   36 38                       74 10 12 42 0   4     0   6   36 38                 74
744818 744818 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_4 10 0 0 0   1     0   0   4 7                       11 10 0 0 0   1     0   0   4 7                 11
738378 738378 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 02 05 2015   grade_4 100 1 2 0   2     0   2   60 47                       107 100 1 2 0   2     0   2   60 47                 107
739981 739981 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No 1 PK 04 2015   grade_4 100 1 7 0   3     0   3   60 54                       114 100 1 7 0   3     0   3   60 54                 114
741698 741698 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Margaret A Neary   Regular School No 2 04 05 2015   grade_4 100 1 3 0   22     0   2   69 59                       128 100 1 3 0   22     0   2   69 59                 128
737614 737614 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_4 101 3 24 0   0     0   1   69 60                       129 101 3 24 0   0     0   1   69 60                 129
738143 738143 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_4 101 4 3 0   0     0   5   58 55                       113 101 4 3 0   0     0   5   58 55                 113
744332 744332 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No 1 KG 04 2015   grade_4 102 1 4 0   10     0   3   67 53                       120 102 1 4 0   10     0   3   67 53                 120
740420 740420 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2015   grade_4 103 3 6 0   1     0   2   62 53                       115 103 3 6 0   1     0   2   62 53                 115
738435 738435 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_4 104 1 2 0   9     0   2   51 67                       118 104 1 2 0   9     0   2   51 67                 118
741556 741556 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_4 104 5 10 1   71     0   6   107 90                       197 104 5 10 1   71     0   6   107 90                 197
744644 744644 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No 1 KG 04 2015   grade_4 104 0 6 0   3     0   2   60 55                       115 104 0 6 0   3     0   2   60 55                 115
742550 742550 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_4 105 5 37 0   2     0   8   65 92                       157 105 5 37 0   2     0   8   65 92                 157
736988 736988 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_4 107 1 4 0   1     1   4   68 50                       118 107 1 4 0   1     1   4   68 50                 118
738573 738573 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   grade_4 107 2 17 0   4     0   2   68 64                       132 107 2 17 0   4     0   2   68 64                 132
739728 739728 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_4 107 4 3 12   6     0   4   58 78                       136 107 4 3 12   6     0   4   58 78                 136
740777 740777 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No 1 PK 04 2015   grade_4 107 2 10 0   0     0   9   78 50                       128 107 2 10 0   0     0   9   78 50                 128
742105 742105 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_4 107 0 6 0   1     0   11   64 61                       125 107 0 6 0   1     0   11   64 61                 125
742790 742790 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 02 05 2015   grade_4 107 3 1 0   1     0   5   57 60                       117 107 3 1 0   1     0   5   57 60                 117
739875 739875 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_4 108 3 30 0   3     0   4   72 76                       148 108 3 30 0   3     0   4   72 76                 148
737726 737726 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No 1 KG 05 2015   grade_4 109 2 5 0   4     0   8   78 50                       128 109 2 5 0   4     0   8   78 50                 128
736335 736335 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2015   grade_4 11 20 17 0   0     1   0   27 22                       49 11 20 17 0   0     1   0   27 22                 49
739464 739464 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No 1 KG 05 2015   grade_4 11 7 81 0   13     0   4   59 57                       116 11 7 81 0   13     0   4   59 57                 116
740940 740940 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No 1 PK 05 2015   grade_4 11 13 10 0   2     0   9   16 29                       45 11 13 10 0   2     0   9   16 29                 45
741882 741882 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No 1 PK 05 2015   grade_4 11 9 24 0   6     0   1   24 27                       51 11 9 24 0   6     0   1   24 27                 51
741894 741894 MA Hampden   school 2511130 281   Springfield 251113001819 2810145 Mary O Pottenger   Regular School No 1 KG 05 2015   grade_4 11 7 51 0   3     0   2   37 37                       74 11 7 51 0   3     0   2   37 37                 74
741919 741919 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No 1 KG 05 2015   grade_4 11 8 22 0   2     0   1   21 23                       44 11 8 22 0   2     0   1   21 23                 44
743718 743718 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_4 11 2 3 0   1     0   0   5 12                       17 11 2 3 0   1     0   0   5 12                 17
744791 744791 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2015   grade_4 11 0 0 1   0     0   1   9 4                       13 11 0 0 1   0     0   1   9 4                 13
744900 744900 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2015   grade_4 11 0 0 1   0     0   0   8 4                       12 11 0 0 1   0     0   0   8 4                 12
738440 738440 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_4 111 1 2 0   25     0   6   71 74                       145 111 1 2 0   25     0   6   71 74                 145
735678 735678 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2015   grade_4 113 0 0 0   0     0   0   59 54                       113 113 0 0 0   0     0   0   59 54                 113
738481 738481 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2015   grade_4 113 1 27 0   1     0   2   71 73                       144 113 1 27 0   1     0   2   71 73                 144
742770 742770 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No 2 04 05 2015   grade_4 115 12 6 1   18     0   10   93 69                       162 115 12 6 1   18     0   10   93 69                 162
741729 741729 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No 1 02 04 2015   grade_4 116 2 20 0   1     0   8   66 81                       147 116 2 20 0   1     0   8   66 81                 147
739192 739192 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2015   grade_4 117 1 2 0   3     0   3   66 60                       126 117 1 2 0   3     0   3   66 60                 126
742149 742149 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No 1 03 05 2015   grade_4 119 1 2 0   4     0   6   71 61                       132 119 1 2 0   4     0   6   71 61                 132
744958 744958 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No 1 03 05 2015   grade_4 119 0 5 0   5     0   9   82 56                       138 119 0 5 0   5     0   9   82 56                 138
736287 736287 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 07 2015   grade_4 12 15 19 0   1     0   2   24 25                       49 12 15 19 0   1     0   2   24 25                 49
736431 736431 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No 1 PK 05 2015   grade_4 12 15 13 0   3     0   0   28 15                       43 12 15 13 0   3     0   0   28 15                 43
737503 737503 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_4 12 5 124 0   2     0   0   75 68                       143 12 5 124 0   2     0   0   75 68                 143
738713 738713 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_4 12 3 28 0   1     0   0   22 22                       44 12 3 28 0   1     0   0   22 22                 44
740188 740188 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2015   grade_4 12 6 19 0   0     0   3   20 20                       40 12 6 19 0   0     0   3   20 20                 40
741141 741141 MA Norfolk   school 2509930 244   Randolph 250993001592 2440015 Margaret L Donovan   Regular School No 1 KG 05 2015   grade_4 12 30 6 1   10     0   5   41 23                       64 12 30 6 1   10     0   5   41 23                 64
741273 741273 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_4 12 0 0 0   0     0   1   6 7                       13 12 0 0 0   0     0   1   6 7                 13
741582 741582 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_4 12 0 0 0   0     0   2   7 7                       14 12 0 0 0   0     0   2   7 7                 14
741821 741821 MA Hampden   school 2511130 281   Springfield 251113001562 2810068 Glickman Elementary   Regular School No 1 KG 05 2015   grade_4 12 15 22 0   2     0   1   25 27                       52 12 15 22 0   2     0   1   25 27                 52
738352 738352 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 03 05 2015   grade_4 120 1 28 0   2     0   20   84 87                       171 120 1 28 0   2     0   20   84 87                 171

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