enrollments

Data source: Big Local News · About: Big Local

957 rows where grade = "grade_4", state = "MA" and year = 2017 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 957 ✖

grade ✖

  • grade_4 · 957 ✖
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
1123581 1123581 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_4 16 96 27 1   0     0   5   74 71                       145 16 96 27 1   0     0   5   74 71                 145
1131204 1131204 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_4 13 95 73 2   4     0   4   102 89                       191 13 95 73 2   4     0   4   102 89                 191
1122336 1122336 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2017   grade_4 137 9 9 0   27     0   0   100 82                       182 137 9 9 0   27     0   0   100 82                 182
1122352 1122352 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_4 161 9 4 0   6     1   1   102 80                       182 161 9 4 0   6     1   1   102 80                 182
1123065 1123065 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   grade_4 4 9 8 0   2     0   0   8 15                       23 4 9 8 0   2     0   0   8 15                 23
1123169 1123169 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_4 10 9 15 0   2     1   1   20 18                       38 10 9 15 0   2     1   1   20 18                 38
1124082 1124082 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_4 11 9 113 0   1     0   2   69 67                       136 11 9 113 0   1     0   2   69 67                 136
1124455 1124455 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2017   grade_4 63 9 8 0   4     0   1   46 39                       85 63 9 8 0   4     0   1   46 39                 85
1124740 1124740 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2017   grade_4 43 9 38 0   2     0   4   43 53                       96 43 9 38 0   2     0   4   43 53                 96
1125975 1125975 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2017   grade_4 57 9 44 0   2     0   3   54 61                       115 57 9 44 0   2     0   3   54 61                 115
1126080 1126080 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_4 38 9 6 0   0     0   6   29 30                       59 38 9 6 0   0     0   6   29 30                 59
1126245 1126245 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2017   grade_4 6 9 26 0   44     0   8   50 43                       93 6 9 26 0   44     0   8   50 43                 93
1126472 1126472 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Edward A Sisson   Regular School No Elementary KG 05 2017   grade_4 28 9 29 1   7     0   3   36 41                       77 28 9 29 1   7     0   3   36 41                 77
1127073 1127073 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2017   grade_4 78 9 0 0   5     0   2   45 49                       94 78 9 0 0   5     0   2   45 49                 94
1127256 1127256 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No Elementary KG 05 2017   grade_4 25 9 35 0   0     0   2   30 41                       71 25 9 35 0   0     0   2   30 41                 71
1127317 1127317 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary PK 05 2017   grade_4 23 9 41 0   0     0   1   35 39                       74 23 9 41 0   0     0   1   35 39                 74
1129267 1129267 MA Hampden   school 2511130 281   Springfield 251113001819 2810145 Mary O Pottenger   Regular School No Elementary KG 05 2017   grade_4 12 9 46 0   2     0   0   38 31                       69 12 9 46 0   2     0   0   38 31                 69
1129289 1129289 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Arthur T Talmadge   Regular School No Elementary KG 05 2017   grade_4 2 9 23 0   3     0   1   13 25                       38 2 9 23 0   3     0   1   13 25                 38
1129319 1129319 MA Hampden   school 2511130 281   Springfield 251113001837 2810190 White Street   Regular School No Elementary KG 05 2017   grade_4 5 9 56 0   2     0   0   38 34                       72 5 9 56 0   2     0   0   38 34                 72
1129722 1129722 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 North Street   Regular School No Elementary 03 04 2017   grade_4 112 9 2 0   5     0   2   74 56                       130 112 9 2 0   5     0   2   74 56                 130
1129930 1129930 MA Middlesex   school 2512000 308   Waltham 251200001970 3080060 James Fitzgerald Elementary School   Regular School No Elementary KG 05 2017   grade_4 43 9 30 0   5     0   3   41 49                       90 43 9 30 0   5     0   3   41 49                 90
1130876 1130876 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2017   grade_4 8 9 28 0   6     0   4   29 26                       55 8 9 28 0   6     0   4   29 26                 55
1130893 1130893 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   grade_4 7 9 25 0   1     0   3   20 25                       45 7 9 25 0   1     0   3   20 25                 45
1130935 1130935 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2017   grade_4 30 9 18 0   4     0   6   34 33                       67 30 9 18 0   4     0   6   34 33                 67
1130979 1130979 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2017   grade_4 23 9 9 0   5     0   3   16 33                       49 23 9 9 0   5     0   3   16 33                 49
1131105 1131105 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_4 10 9 19 0   0     0   4   18 24                       42 10 9 19 0   0     0   4   18 24                 42
1123618 1123618 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_4 21 83 14 0   1     0   2   55 66                       121 21 83 14 0   1     0   2   55 66                 121
1123638 1123638 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No Elementary KG 05 2017   grade_4 4 83 12 1   1     0   1   53 49                       102 4 83 12 1   1     0   1   53 49                 102
1122058 1122058 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_4 33 8 12 0   8     0   4   41 24                       65 33 8 12 0   8     0   4   41 24                 65
1122594 1122594 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_4 8 8 17 0   0     0   1   18 16                       34 8 8 17 0   0     0   1   18 16                 34
1122892 1122892 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   grade_4 7 8 10 0   0     0   1   13 13                       26 7 8 10 0   0     0   1   13 13                 26
1123842 1123842 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2017   grade_4 42 8 7 0   19     0   1   38 39                       77 42 8 7 0   19     0   1   38 39                 77
1123879 1123879 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2017   grade_4 21 8 6 0   3     0   3   20 21                       41 21 8 6 0   3     0   3   20 21                 41
1123887 1123887 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No Elementary PK 05 2017   grade_4 12 8 3 0   3     0   6   15 17                       32 12 8 3 0   3     0   6   15 17                 32
1124371 1124371 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_4 40 8 17 1   2     0   4   39 33                       72 40 8 17 1   2     0   4   39 33                 72
1124890 1124890 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2017   grade_4 38 8 69 0   8     1   9   67 66                       133 38 8 69 0   8     1   9   67 66                 133
1124982 1124982 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   grade_4 74 8 6 0   5     0   4   49 48                       97 74 8 6 0   5     0   4   49 48                 97
1125017 1125017 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_4 79 8 19 0   0     0   1   55 52                       107 79 8 19 0   0     0   1   55 52                 107
1126025 1126025 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2017   grade_4 56 8 2 0   40     0   9   57 58                       115 56 8 2 0   40     0   9   57 58                 115
1126217 1126217 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary KG 04 2017   grade_4 47 8 47 0   10     0   4   52 64                       116 47 8 47 0   10     0   4   52 64                 116
1126364 1126364 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   grade_4 13 8 19 0   2     0   3   19 26                       45 13 8 19 0   2     0   3   19 26                 45
1126421 1126421 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Hood   Regular School No Elementary KG 05 2017   grade_4 16 8 57 0   7     0   2   44 46                       90 16 8 57 0   7     0   2   44 46                 90
1126465 1126465 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No Elementary PK 05 2017   grade_4 27 8 11 0   5     0   7   38 20                       58 27 8 11 0   5     0   7   38 20                 58
1126478 1126478 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_4 5 8 73 0   5     0   3   48 46                       94 5 8 73 0   5     0   3   48 46                 94
1127008 1127008 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_4 192 8 100 13   4     0   14   175 156                       331 192 8 100 13   4     0   14   175 156                 331
1127271 1127271 MA Bristol   school 2508430 201   New Bedford 250843001332 2010050 John B Devalles   Regular School No Elementary KG 05 2017   grade_4 27 8 20 0   1     0   4   34 26                       60 27 8 20 0   1     0   4   34 26                 60
1127325 1127325 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2017   grade_4 11 8 23 0   0     1   1   25 19                       44 11 8 23 0   0     1   1   25 19                 44
1127639 1127639 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary PK 05 2017   grade_4 50 8 10 0   11     0   2   45 36                       81 50 8 10 0   11     0   2   45 36                 81
1129128 1129128 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary KG 05 2017   grade_4 1 8 47 0   0     0   0   31 25                       56 1 8 47 0   0     0   0   31 25                 56
1129260 1129260 MA Hampden   school 2511130 281   Springfield 251113001818 2810140 Mary M Lynch   Regular School No Elementary KG 05 2017   grade_4 1 8 27 0   0     0   0   15 21                       36 1 8 27 0   0     0   0   15 21                 36
1129494 1129494 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No Elementary KG 05 2017   grade_4 29 8 1 0   2     3   5   21 27                       48 29 8 1 0   2     3   5   21 27                 48
1130106 1130106 MA Norfolk   school 2512270 317   Wellesley 251227002503 3170045 Schofield   Regular School No Elementary KG 05 2017   grade_4 41 8 3 0   11     0   4   33 34                       67 41 8 3 0   11     0   4   33 34                 67
1130738 1130738 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2017   grade_4 16 8 35 0   4     0   2   29 36                       65 16 8 35 0   4     0   2   29 36                 65
1130970 1130970 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   grade_4 22 8 11 0   5     0   5   23 28                       51 22 8 11 0   5     0   5   23 28                 51
1131506 1131506 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes Elementary KG 05 2017   grade_4 60 8 20 0   6     0   0   47 47                       94 60 8 20 0   6     0   0   47 47                 94
1131909 1131909 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2017   grade_4 157 8 2 1   2     0   3   108 65                       173 157 8 2 1   2     0   3   108 65                 173
1133186 1133186 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 22 8 9 0   3     0   4   21 25                       46 22 8 9 0   3     0   4   21 25                 46
1133200 1133200 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 16 8 5 0   1     0   3   23 10                       33 16 8 5 0   1     0   3   23 10                 33
1131532 1131532 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_4 0 79 35 0   1     0   0   55 60                       115 0 79 35 0   1     0   0   55 60                 115
1122066 1122066 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_4 31 7 13 0   12     0   9   39 33                       72 31 7 13 0   12     0   9   39 33                 72
1122128 1122128 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_4 45 7 4 0   8     1   3   32 36                       68 45 7 4 0   8     1   3   32 36                 68
1122521 1122521 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 05 2017   grade_4 62 7 7 0   5     0   3   46 38                       84 62 7 7 0   5     0   3   46 38                 84
1122739 1122739 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_4 13 7 13 0   0     0   2   18 17                       35 13 7 13 0   0     0   2   18 17                 35
1122961 1122961 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_4 10 7 2 0   2     0   4   16 9                       25 10 7 2 0   2     0   4   16 9                 25
1123248 1123248 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_4 26 7 16 0   1     0   0   30 20                       50 26 7 16 0   1     0   0   30 20                 50
1123542 1123542 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2017   grade_4 26 7 7 1   13     0   2   32 24                       56 26 7 7 1   13     0   2   32 24                 56
1123988 1123988 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2017   grade_4 65 7 2 0   12     0   1   46 41                       87 65 7 2 0   12     0   1   46 41                 87
1124622 1124622 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_4 11 7 50 0   5     0   1   36 38                       74 11 7 50 0   5     0   1   36 38                 74
1124835 1124835 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   grade_4 40 7 1 1   1     0   4   29 25                       54 40 7 1 1   1     0   4   29 25                 54
1124968 1124968 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_4 33 7 47 0   4     0   3   45 49                       94 33 7 47 0   4     0   3   45 49                 94
1125432 1125432 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_4 68 7 40 0   2     0   2   55 64                       119 68 7 40 0   2     0   2   55 64                 119
1125954 1125954 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2017   grade_4 75 7 41 1   0     0   4   57 71                       128 75 7 41 1   0     0   4   57 71                 128
1126086 1126086 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_4 34 7 15 0   0     0   6   32 30                       62 34 7 15 0   0     0   6   32 30                 62
1126317 1126317 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2017   grade_4 159 7 13 2   0     0   5   107 79                       186 159 7 13 2   0     0   5   107 79                 186
1126457 1126457 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No Elementary KG 05 2017   grade_4 19 7 22 0   3     0   3   26 28                       54 19 7 22 0   3     0   3   26 28                 54
1126808 1126808 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No Elementary PK 05 2017   grade_4 53 7 3 0   1     0   3   42 25                       67 53 7 3 0   1     0   3   42 25                 67
1126824 1126824 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2017   grade_4 47 7 13 0   15     0   6   47 41                       88 47 7 13 0   15     0   6   47 41                 88
1128006 1128006 MA Essex   school 2509360 229   Peabody 250936001493 2290015 Center   Regular School No Elementary KG 05 2017   grade_4 55 7 6 0   0     0   4   41 31                       72 55 7 6 0   0     0   4   41 31                 72
1128667 1128667 MA Essex   school 2510380 258   Salem 251038001668 2580070 Witchcraft Heights   Regular School No Elementary KG 05 2017   grade_4 46 7 21 0   11     0   2   52 35                       87 46 7 21 0   11     0   2   52 35                 87
1129253 1129253 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No Elementary PK 05 2017   grade_4 16 7 30 0   3     0   0   28 28                       56 16 7 30 0   3     0   0   28 28                 56
1129651 1129651 MA Bristol   school 2511520 293   Taunton 251152001905 2930007 Edmund Hatch Bennett   Regular School No Elementary KG 04 2017   grade_4 51 7 8 0   0     0   0   35 31                       66 51 7 8 0   0     0   0   35 31                 66
1129657 1129657 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2017   grade_4 97 7 6 0   2     0   6   65 53                       118 97 7 6 0   2     0   6   65 53                 118
1129901 1129901 MA Middlesex   school 2512000 308   Waltham 251200001973 3080005 William F. Stanley Elementary School   Regular School No Elementary PK 05 2017   grade_4 26 7 30 0   4     0   2   41 28                       69 26 7 30 0   4     0   2   41 28                 69
1130030 1130030 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2017   grade_4 76 7 1 0   10     1   6   40 61                       101 76 7 1 0   10     1   6   40 61                 101
1130061 1130061 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2017   grade_4 88 7 42 1   6     0   12   75 81                       156 88 7 42 1   6     0   12   75 81                 156
1130798 1130798 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   grade_4 11 7 38 0   2     0   2   37 23                       60 11 7 38 0   2     0   2   37 23                 60
1130832 1130832 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary PK 06 2017   grade_4 13 7 45 0   1     0   1   42 25                       67 13 7 45 0   1     0   1   42 25                 67
1130884 1130884 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2017   grade_4 19 7 7 0   2     0   1   20 16                       36 19 7 7 0   2     0   1   20 16                 36
1130952 1130952 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No Elementary KG 06 2017   grade_4 20 7 26 0   6     0   3   27 35                       62 20 7 26 0   6     0   3   27 35                 62
1130987 1130987 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2017   grade_4 30 7 11 0   0     0   1   21 28                       49 30 7 11 0   0     0   1   21 28                 49
1132364 1132364 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   grade_4 108 7 9 0   0     1   0   64 61                       125 108 7 9 0   0     1   0   64 61                 125
1123595 1123595 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2017   grade_4 19 69 53 3   2     0   10   80 76                       156 19 69 53 3   2     0   10   80 76                 156
1122927 1122927 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No Elementary PK 05 2017   grade_4 0 64 21 0   0     0   0   41 44                       85 0 64 21 0   0     0   0   41 44                 85
1131330 1131330 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_4 20 63 34 0   2     0   0   57 62                       119 20 63 34 0   2     0   0   57 62                 119
1123604 1123604 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2017   grade_4 30 61 8 1   4     1   1   56 50                       106 30 61 8 1   4     1   1   56 50                 106
1123611 1123611 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2017   grade_4 30 60 14 0   4     0   9   57 60                       117 30 60 14 0   4     0   9   57 60                 117
1122050 1122050 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_4 14 6 10 0   11     0   3   23 21                       44 14 6 10 0   11     0   3   23 21                 44
1122191 1122191 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   grade_4 144 6 18 0   34     0   6   103 105                       208 144 6 18 0   34     0   6   103 105                 208
1122221 1122221 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2017   grade_4 48 6 14 0   10     0   3   34 47                       81 48 6 14 0   10     0   3   34 47                 81
1122418 1122418 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2017   grade_4 80 6 4 0   17     0   12   69 50                       119 80 6 4 0   17     0   12   69 50                 119

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