enrollments

Data source: Big Local News · About: Big Local

894 rows where grade = "grade_5", state = "MA" and year = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 794 ✖

grade ✖

  • grade_5 · 794 ✖
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
1123136 1123136 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_5 2 4 10 0   0     0   0   12 4                       16 2 4 10 0   0     0   0   12 4                 16
1123151 1123151 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2017   grade_5 0 7 19 0   3     0   2   14 17                       31 0 7 19 0   3     0   2   14 17                 31
1123159 1123159 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_5 0 26 17 0   0     0   4   23 24                       47 0 26 17 0   0     0   4   23 24                 47
1123170 1123170 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_5 5 6 12 0   2     0   2   16 11                       27 5 6 12 0   2     0   2   16 11                 27
1123178 1123178 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2017   grade_5 13 18 36 0   14     0   1   44 38                       82 13 18 36 0   14     0   1   44 38                 82
1123189 1123189 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_5 2 20 15 0   1     0   5   17 26                       43 2 20 15 0   1     0   5   17 26                 43
1123198 1123198 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_5 0 23 13 0   0     0   3   22 17                       39 0 23 13 0   0     0   3   22 17                 39
1123208 1123208 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_5 1 17 8 0   0     0   1   12 15                       27 1 17 8 0   0     0   1   12 15                 27
1123219 1123219 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_5 2 25 20 0   0     0   0   25 22                       47 2 25 20 0   0     0   0   25 22                 47
1123230 1123230 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_5 1 7 10 0   0     0   1   9 10                       19 1 7 10 0   0     0   1   9 10                 19
1123245 1123245 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2017   grade_5 2 6 58 0   0     0   0   30 36                       66 2 6 58 0   0     0   0   30 36                 66
1123249 1123249 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_5 7 18 9 0   3     0   1   20 18                       38 7 18 9 0   3     0   1   20 18                 38
1123408 1123408 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_5 4 4 63 0   0     0   1   40 32                       72 4 4 63 0   0     0   1   40 32                 72
1123437 1123437 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_5 1 1 26 0   0     0   0   9 19                       28 1 1 26 0   0     0   0   9 19                 28
1123474 1123474 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_5 147 2 10 1   1     0   2   83 80                       163 147 2 10 1   1     0   2   83 80                 163
1123491 1123491 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_5 98 0 3 0   4     0   1   46 60                       106 98 0 3 0   4     0   1   46 60                 106
1123500 1123500 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_5 48 2 2 0   2     0   0   27 27                       54 48 2 2 0   2     0   0   27 27                 54
1123507 1123507 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2017   grade_5 66 5 3 1   8     0   0   48 35                       83 66 5 3 1   8     0   0   48 35                 83
1123516 1123516 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2017   grade_5 64 2 3 0   8     0   0   38 39                       77 64 2 3 0   8     0   0   38 39                 77
1123523 1123523 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2017   grade_5 50 2 4 0   14     0   1   34 37                       71 50 2 4 0   14     0   1   34 37                 71
1123529 1123529 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_5 55 2 4 0   14     0   0   29 46                       75 55 2 4 0   14     0   0   29 46                 75
1123536 1123536 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2017   grade_5 49 2 5 0   14     0   0   37 33                       70 49 2 5 0   14     0   0   37 33                 70
1123543 1123543 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2017   grade_5 37 3 2 1   8     0   0   34 17                       51 37 3 2 1   8     0   0   34 17                 51
1123566 1123566 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2017   grade_5 65 4 6 0   0     0   2   38 39                       77 65 4 6 0   0     0   2   38 39                 77
1123574 1123574 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   grade_5 42 1 0 0   1     0   0   20 24                       44 42 1 0 0   1     0   0   20 24                 44
1123582 1123582 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_5 10 84 29 1   1     0   6   63 68                       131 10 84 29 1   1     0   6   63 68                 131
1123589 1123589 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2017   grade_5 42 55 14 0   3     0   7   65 56                       121 42 55 14 0   3     0   7   65 56                 121
1123596 1123596 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2017   grade_5 23 69 66 0   0     0   6   81 83                       164 23 69 66 0   0     0   6   81 83                 164
1123605 1123605 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2017   grade_5 34 53 14 0   2     0   2   55 50                       105 34 53 14 0   2     0   2   55 50                 105
1123612 1123612 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2017   grade_5 28 44 14 0   6     0   4   51 45                       96 28 44 14 0   6     0   4   51 45                 96
1123619 1123619 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_5 23 73 19 0   0     1   9   67 58                       125 23 73 19 0   0     1   9   67 58                 125
1123629 1123629 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2017   grade_5 34 50 17 0   3     1   4   64 45                       109 34 50 17 0   3     1   4   64 45                 109
1123639 1123639 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No Elementary KG 05 2017   grade_5 6 75 13 0   0     0   2   51 45                       96 6 75 13 0   0     0   2   51 45                 96
1123646 1123646 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2017   grade_5 55 81 26 2   12     0   12   100 88                       188 55 81 26 2   12     0   12   100 88                 188
1123653 1123653 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2017   grade_5 4 117 10 1   1     0   2   77 58                       135 4 117 10 1   1     0   2   77 58                 135
1123665 1123665 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   grade_5 25 58 20 2   3     0   4   58 54                       112 25 58 20 2   3     0   4   58 54                 112
1123667 1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1123719 1123719 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_5 40 0 1 0   0     0   1   24 18                       42 40 0 1 0   0     0   1   24 18                 42
1123731 1123731 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_5 40 3 9 0   20     0   8   52 28                       80 40 3 9 0   20     0   8   52 28                 80
1123741 1123741 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_5 48 4 15 0   16     0   9   41 51                       92 48 4 15 0   16     0   9   41 51                 92
1123752 1123752 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2017   grade_5 30 5 8 0   11     0   14   32 36                       68 30 5 8 0   11     0   14   32 36                 68
1123763 1123763 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2017   grade_5 35 2 3 0   10     0   3   32 21                       53 35 2 3 0   10     0   3   32 21                 53
1123773 1123773 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2017   grade_5 37 3 12 0   18     0   9   40 39                       79 37 3 12 0   18     0   9   40 39                 79
1123783 1123783 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2017   grade_5 30 8 9 0   14     0   2   31 32                       63 30 8 9 0   14     0   2   31 32                 63
1123793 1123793 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_5 43 6 12 0   19     0   3   49 34                       83 43 6 12 0   19     0   3   49 34                 83
1123804 1123804 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2017   grade_5 39 3 8 0   8     0   8   34 32                       66 39 3 8 0   8     0   8   34 32                 66
1123822 1123822 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No Elementary KG 05 2017   grade_5 45 2 2 0   8     0   0   31 26                       57 45 2 2 0   8     0   0   31 26                 57
1123829 1123829 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No Elementary KG 05 2017   grade_5 43 4 3 1   8     0   1   33 27                       60 43 4 3 1   8     0   1   33 27                 60
1123836 1123836 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2017   grade_5 27 2 3 0   8     0   0   18 22                       40 27 2 3 0   8     0   0   18 22                 40
1123843 1123843 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2017   grade_5 60 8 4 0   14     0   1   41 46                       87 60 8 4 0   14     0   1   41 46                 87
1123861 1123861 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2017   grade_5 13 15 4 0   4     0   1   12 25                       37 13 15 4 0   4     0   1   12 25                 37
1123869 1123869 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_5 13 0 18 0   1     0   2   10 24                       34 13 0 18 0   1     0   2   10 24                 34
1123880 1123880 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2017   grade_5 16 8 8 0   1     0   2   16 19                       35 16 8 8 0   1     0   2   16 19                 35
1123888 1123888 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No Elementary PK 05 2017   grade_5 11 8 1 0   4     0   4   11 17                       28 11 8 1 0   4     0   4   11 17                 28
1123896 1123896 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2017   grade_5 7 9 6 0   8     0   1   12 19                       31 7 9 6 0   8     0   1   12 19                 31
1123904 1123904 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_5 21 9 7 0   0     0   7   23 21                       44 21 9 7 0   0     0   7   23 21                 44
1123912 1123912 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2017   grade_5 11 7 3 0   1     0   1   13 10                       23 11 7 3 0   1     0   1   13 10                 23
1123920 1123920 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2017   grade_5 11 15 5 1   4     0   5   28 13                       41 11 15 5 1   4     0   5   28 13                 41
1123928 1123928 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2017   grade_5 20 10 4 0   4     0   7   23 22                       45 20 10 4 0   4     0   7   23 22                 45
1123936 1123936 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2017   grade_5 9 4 3 0   4     0   1   8 13                       21 9 4 3 0   4     0   1   8 13                 21
1123944 1123944 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2017   grade_5 25 10 5 0   7     0   3   21 29                       50 25 10 5 0   7     0   3   21 29                 50
1123952 1123952 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2017   grade_5 2 10 6 0   1     0   1   11 9                       20 2 10 6 0   1     0   1   11 9                 20
1123982 1123982 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No Elementary KG 05 2017   grade_5 58 10 8 0   7     0   3   37 49                       86 58 10 8 0   7     0   3   37 49                 86
1123989 1123989 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2017   grade_5 66 5 3 0   6     0   4   45 39                       84 66 5 3 0   6     0   4   45 39                 84
1123996 1123996 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2017   grade_5 42 13 1 0   8     0   6   35 35                       70 42 13 1 0   8     0   6   35 35                 70
1124013 1124013 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_5 51 0 4 0   4     0   11   37 33                       70 51 0 4 0   4     0   11   37 33                 70
1124024 1124024 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2017   grade_5 121 1 1 0   0     0   3   78 48                       126 121 1 1 0   0     0   3   78 48                 126
1124060 1124060 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_5 124 3 13 0   26     0   4   82 88                       170 124 3 13 0   26     0   4   82 88                 170
1124065 1124065 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_5 162 9 11 0   32     2   2   118 100                       218 162 9 11 0   32     2   2   118 100                 218
1124099 1124099 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_5 14 10 132 0   1     0   2   92 67                       159 14 10 132 0   1     0   2   92 67                 159
1124104 1124104 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_5 11 2 138 1   1     0   0   84 69                       153 11 2 138 1   1     0   0   84 69                 153
1124109 1124109 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_5 9 6 135 0   3     0   1   70 84                       154 9 6 135 0   3     0   1   70 84                 154
1124126 1124126 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2017   grade_5 43 1 25 0   1     0   2   43 29                       72 43 1 25 0   1     0   2   43 29                 72
1124138 1124138 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary PK 05 2017   grade_5 23 4 34 0   0     0   0   21 40                       61 23 4 34 0   0     0   0   21 40                 61
1124145 1124145 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2017   grade_5 41 2 14 0   0     0   3   28 32                       60 41 2 14 0   0     0   3   28 32                 60
1124159 1124159 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_5 68 3 33 0   1     0   5   61 49                       110 68 3 33 0   1     0   5   61 49                 110
1124166 1124166 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No Elementary KG 05 2017   grade_5 37 1 10 0   2     0   2   23 29                       52 37 1 10 0   2     0   2   23 29                 52
1124173 1124173 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Fairview Elementary   Regular School No Elementary KG 05 2017   grade_5 35 2 31 0   3     0   2   31 42                       73 35 2 31 0   3     0   2   31 42                 73
1124180 1124180 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No Elementary KG 05 2017   grade_5 28 3 8 0   2     0   3   22 22                       44 28 3 8 0   2     0   3   22 22                 44
1124187 1124187 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No Elementary KG 05 2017   grade_5 9 2 43 0   0     0   4   31 27                       58 9 2 43 0   0     0   4   31 27                 58
1124212 1124212 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_5 18 0 0 0   0     0   0   10 8                       18 18 0 0 0   0     0   0   10 8                 18
1124224 1124224 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_5 104 2 37 0   2     0   0   77 68                       145 104 2 37 0   2     0   0   77 68                 145
1124237 1124237 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2017   grade_5 113 3 1 0   3     0   0   67 53                       120 113 3 1 0   3     0   0   67 53                 120
1124258 1124258 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   grade_5 46 6 7 1   4     0   7   29 42                       71 46 6 7 1   4     0   7   29 42                 71
1124266 1124266 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No Elementary PK 05 2017   grade_5 63 5 6 0   3     0   9   44 42                       86 63 5 6 0   3     0   9   44 42                 86
1124273 1124273 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No Elementary PK 05 2017   grade_5 61 1 7 0   5     0   1   37 38                       75 61 1 7 0   5     0   1   37 38                 75
1124285 1124285 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_5 23 0 0 0   0     0   1   14 10                       24 23 0 0 0   0     0   1   14 10                 24
1124293 1124293 MA Essex   school 2503990 71   Danvers 250399000532 710010 Highlands   Regular School No Elementary KG 05 2017   grade_5 47 2 3 0   3     0   5   31 29                       60 47 2 3 0   3     0   5   31 29                 60
1124300 1124300 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No Elementary KG 05 2017   grade_5 45 2 4 0   0     0   1   23 29                       52 45 2 4 0   0     0   1   23 29                 52
1124308 1124308 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No Elementary PK 05 2017   grade_5 31 1 3 0   1     0   2   18 20                       38 31 1 3 0   1     0   2   18 20                 38
1124315 1124315 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No Elementary KG 05 2017   grade_5 54 0 5 0   4     0   0   37 26                       63 54 0 5 0   4     0   0   37 26                 63
1124322 1124322 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No Elementary KG 05 2017   grade_5 55 0 5 1   2     0   0   35 28                       63 55 0 5 1   2     0   0   35 28                 63
1124340 1124340 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_5 89 0 2 0   1     0   5   48 49                       97 89 0 2 0   1     0   5   48 49                 97
1124347 1124347 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary KG 05 2017   grade_5 67 3 3 0   0     0   4   41 36                       77 67 3 3 0   0     0   4   41 36                 77
1124354 1124354 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_5 110 1 4 0   0     0   9   78 46                       124 110 1 4 0   0     0   9   78 46                 124
1124372 1124372 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_5 32 4 14 0   3     0   2   31 24                       55 32 4 14 0   3     0   2   31 24                 55
1124378 1124378 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_5 50 3 3 0   1     0   1   37 21                       58 50 3 3 0   1     0   1   37 21                 58
1124384 1124384 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_5 39 4 5 0   1     0   3   22 30                       52 39 4 5 0   1     0   3   22 30                 52
1124390 1124390 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_5 31 1 5 0   2     0   1   25 15                       40 31 1 5 0   2     0   1   25 15                 40
1124407 1124407 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2017   grade_5 49 0 3 0   2     0   5   33 26                       59 49 0 3 0   2     0   5   33 26                 59

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