enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2016 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
932622 932622 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2016   grade_6 29 2 6 0   11     0   0   23 25                       48 29 2 6 0   11     0   0   23 25                 48
932629 932629 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_6 35 5 11 0   7     1   2   28 33                       61 35 5 11 0   7     1   2   28 33                 61
932636 932636 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_6 40 6 10 0   4     0   3   30 33                       63 40 6 10 0   4     0   3   30 33                 63
932817 932817 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2016   grade_6 43 10 2 0   3     0   5   37 26                       63 43 10 2 0   3     0   5   37 26                 63
933049 933049 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No 1 KG 08 2016   grade_6 9 1 5 0   3     0   0   14 4                       18 9 1 5 0   3     0   0   14 4                 18
933073 933073 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_6 11 11 24 0   2     0   5   30 23                       53 11 11 24 0   2     0   5   30 23                 53
933083 933083 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_6 10 27 27 0   9     0   2   43 32                       75 10 27 27 0   9     0   2   43 32                 75
933100 933100 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2016   grade_6 15 18 62 0   3     1   4   52 51                       103 15 18 62 0   3     1   4   52 51                 103
933160 933160 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   grade_6 13 15 15 0   1     0   3   23 24                       47 13 15 15 0   1     0   3   23 24                 47
933169 933169 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   grade_6 4 2 81 0   0     0   1   42 46                       88 4 2 81 0   0     0   1   42 46                 88
933186 933186 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2016   grade_6 25 7 11 0   3     0   1   19 28                       47 25 7 11 0   3     0   1   19 28                 47
933203 933203 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2016   grade_6 9 17 21 0   0     0   3   27 23                       50 9 17 21 0   0     0   3   27 23                 50
933241 933241 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 06 2016   grade_6 25 35 32 0   6     1   8   49 58                       107 25 35 32 0   6     1   8   49 58                 107
933248 933248 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 07 2016   grade_6 5 20 48 0   3     0   0   33 43                       76 5 20 48 0   3     0   0   33 43                 76
933309 933309 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2016   grade_6 9 0 24 0   0     0   1   16 18                       34 9 0 24 0   0     0   1   16 18                 34
933319 933319 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2016   grade_6 3 55 17 0   10     0   1   46 40                       86 3 55 17 0   10     0   1   46 40                 86
933336 933336 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2016   grade_6 34 8 9 0   4     0   2   31 26                       57 34 8 9 0   4     0   2   31 26                 57
933374 933374 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   grade_6 0 8 19 0   0     0   1   16 12                       28 0 8 19 0   0     0   1   16 12                 28
933397 933397 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2016   grade_6 23 28 24 1   69     1   3   72 77                       149 23 28 24 1   69     1   3   72 77                 149
933414 933414 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_6 14 7 4 0   1     0   0   19 7                       26 14 7 4 0   1     0   0   19 7                 26
933424 933424 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   grade_6 0 45 42 1   1     0   4   44 49                       93 0 45 42 1   1     0   4   44 49                 93
933430 933430 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_6 26 35 60 0   3     0   4   74 54                       128 26 35 60 0   3     0   4   74 54                 128
933440 933440 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2016   grade_6 22 5 23 1   2     0   2   22 33                       55 22 5 23 1   2     0   2   22 33                 55
933504 933504 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_6 0 14 16 0   0     0   0   12 18                       30 0 14 16 0   0     0   0   12 18                 30
933514 933514 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2016   grade_6 5 8 27 0   5     0   0   20 25                       45 5 8 27 0   5     0   0   20 25                 45
933531 933531 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2016   grade_6 25 7 17 0   4     0   2   34 21                       55 25 7 17 0   4     0   2   34 21                 55
933566 933566 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_6 0 20 14 0   0     1   3   19 19                       38 0 20 14 0   0     1   3   19 19                 38
933582 933582 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   grade_6 24 12 51 1   12     0   4   51 53                       104 24 12 51 1   12     0   4   51 53                 104
933592 933592 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   grade_6 1 19 7 0   0     0   0   14 13                       27 1 19 7 0   0     0   0   14 13                 27
933601 933601 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2016   grade_6 0 24 20 0   0     0   3   25 22                       47 0 24 20 0   0     0   3   25 22                 47
933609 933609 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_6 1 68 28 2   2     0   1   57 45                       102 1 68 28 2   2     0   1   57 45                 102
933619 933619 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_6 1 20 21 0   0     0   0   25 17                       42 1 20 21 0   0     0   0   25 17                 42
933629 933629 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_6 9 4 6 0   0     0   3   12 10                       22 9 4 6 0   0     0   3   12 10                 22
933782 933782 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_6 20 9 132 1   6     0   2   86 84                       170 20 9 132 1   6     0   2   86 84                 170
933808 933808 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   grade_6 1 0 32 0   0     0   0   12 21                       33 1 0 32 0   0     0   0   12 21                 33
933855 933855 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_6 100 1 1 0   5     0   2   55 54                       109 100 1 1 0   5     0   2   55 54                 109
933925 933925 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_6 39 0 0 0   0     0   0   17 22                       39 39 0 0 0   0     0   0   17 22                 39
933963 933963 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_6 15 73 13 2   0     0   2   52 53                       105 15 73 13 2   0     0   2   52 53                 105
934044 934044 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 44 0 1 0   0     0   2   25 22                       47 44 0 1 0   0     0   2   25 22                 47
934053 934053 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_6 52 3 11 0   19     1   11   49 48                       97 52 3 11 0   19     1   11   49 48                 97
934062 934062 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_6 45 4 11 0   12     0   5   45 32                       77 45 4 11 0   12     0   5   45 32                 77
934072 934072 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   grade_6 42 5 4 0   6     0   12   39 30                       69 42 5 4 0   6     0   12   39 30                 69
934082 934082 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2016   grade_6 41 4 5 0   8     0   4   29 33                       62 41 4 5 0   8     0   4   29 33                 62
934091 934091 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2016   grade_6 45 8 7 0   22     0   3   43 42                       85 45 8 7 0   22     0   3   43 42                 85
934100 934100 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_6 35 5 12 0   9     0   5   35 31                       66 35 5 12 0   9     0   5   35 31                 66
934109 934109 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2016   grade_6 48 2 10 0   21     0   4   39 46                       85 48 2 10 0   21     0   4   39 46                 85
934119 934119 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_6 39 0 9 0   8     0   13   39 30                       69 39 0 9 0   8     0   13   39 30                 69
934176 934176 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2016   grade_6 8 1 11 0   1     0   4   13 12                       25 8 1 11 0   1     0   4   13 12                 25
934299 934299 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_6 53 2 4 0   8     0   8   41 34                       75 53 2 4 0   8     0   8   41 34                 75
934466 934466 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_6 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
934528 934528 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_6 26 0 0 0   0     0   0   17 9                       26 26 0 0 0   0     0   0   17 9                 26
934630 934630 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2016   grade_6 57 1 0 0   0     0   1   27 32                       59 57 1 0 0   0     0   1   27 32                 59
934706 934706 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2016   grade_6 185 2 1 1   0     0   1   87 103                       190 185 2 1 1   0     0   1   87 103                 190
934790 934790 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_6 26 0 4 0   0     0   0   21 9                       30 26 0 4 0   0     0   0   21 9                 30
934800 934800 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2016   grade_6 19 0 1 0   0     0   1   8 13                       21 19 0 1 0   0     0   1   8 13                 21
934808 934808 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_6 14 9 38 0   4     0   1   31 35                       66 14 9 38 0   4     0   1   31 35                 66
934823 934823 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2016   grade_6 41 13 27 0   2     0   3   44 42                       86 41 13 27 0   2     0   3   44 42                 86
934832 934832 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_6 29 20 40 1   9     0   1   56 44                       100 29 20 40 1   9     0   1   56 44                 100
934847 934847 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2016   grade_6 44 29 38 0   5     0   3   55 64                       119 44 29 38 0   5     0   3   55 64                 119
934856 934856 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_6 14 20 64 2   1     0   0   48 53                       101 14 20 64 2   1     0   0   48 53                 101
934917 934917 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_6 34 1 24 0   5     0   6   34 36                       70 34 1 24 0   5     0   6   34 36                 70
934926 934926 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2016   grade_6 35 2 15 0   0     0   2   29 25                       54 35 2 15 0   0     0   2   29 25                 54
934971 934971 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_6 2 4 1 0   0     0   1   7 1                       8 2 4 1 0   0     0   1   7 1                 8
935044 935044 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_6 22 3 40 0   5     0   6   34 42                       76 22 3 40 0   5     0   6   34 42                 76
935064 935064 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_6 9 0 0 0   0     0   0   5 4                       9 9 0 0 0   0     0   0   5 4                 9
935231 935231 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
935289 935289 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2016   grade_6 94 2 3 0   11     0   4   57 57                       114 94 2 3 0   11     0   4   57 57                 114
935294 935294 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_6 123 0 6 0   23     0   4   73 83                       156 123 0 6 0   23     0   4   73 83                 156
935349 935349 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_6 36 2 2 1   0     1   3   26 19                       45 36 2 2 1   0     1   3   26 19                 45
935362 935362 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2016   grade_6 62 0 0 0   1     0   1   38 26                       64 62 0 0 0   1     0   1   38 26                 64
935369 935369 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 2                       4                         2 2                 4
935411 935411 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_6 39 0 0 0   1     0   2   17 25                       42 39 0 0 0   1     0   2   17 25                 42
935474 935474 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_6 105 5 93 0   4     0   1   100 108                       208 105 5 93 0   4     0   1   100 108                 208
935536 935536 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2016   grade_6 26 0 1 0   0     0   0   13 14                       27 26 0 1 0   0     0   0   13 14                 27
935561 935561 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2016   grade_6 17 0 38 0   0     0   1   31 25                       56 17 0 38 0   0     0   1   31 25                 56
935571 935571 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   grade_6 1 1 33 0   0     0   0   13 22                       35 1 1 33 0   0     0   0   13 22                 35
935585 935585 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   grade_6 1 1 59 0   0     0   0   39 22                       61 1 1 59 0   0     0   0   39 22                 61
935595 935595 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_6 10 2 45 0   0     0   1   25 33                       58 10 2 45 0   0     0   1   25 33                 58
935604 935604 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2016   grade_6 9 1 49 0   0     0   2   31 30                       61 9 1 49 0   0     0   2   31 30                 61
935614 935614 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 PK 08 2016   grade_6 5 3 52 0   1     0   0   38 23                       61 5 3 52 0   1     0   0   38 23                 61
935637 935637 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   grade_6 90 2 5 0   0     0   1   47 51                       98 90 2 5 0   0     0   1   47 51                 98
935727 935727 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2016   grade_6 163 5 2 0   2     0   1   98 75                       173 163 5 2 0   2     0   1   98 75                 173
935735 935735 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2016   grade_6 29 0 0 0   0     0   0   12 17                       29 29 0 0 0   0     0   0   12 17                 29
935756 935756 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_6 4 2 72 0   0     0   0   42 36                       78 4 2 72 0   0     0   0   42 36                 78
935814 935814 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_6 7 0 70 0   3     0   0   39 41                       80 7 0 70 0   3     0   0   39 41                 80
935882 935882 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2016   grade_6 37 0 4 0   1     0   2   24 20                       44 37 0 4 0   1     0   2   24 20                 44
935965 935965 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_6 11 0 0 0   0     0   4   6 9                       15 11 0 0 0   0     0   4   6 9                 15
936025 936025 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2016   grade_6 44 10 4 0   4     0   5   34 33                       67 44 10 4 0   4     0   5   34 33                 67
936106 936106 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No 1 PK 08 2016   grade_6 36 2 10 0   4     0   2   30 24                       54 36 2 10 0   4     0   2   30 24                 54
936166 936166 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_6 * * * *   *     *   *   3 *                       3                         3                   3
936175 936175 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2016   grade_6 9 6 19 0   22     0   0   28 28                       56 9 6 19 0   22     0   0   28 28                 56
936331 936331 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_6 5 2 3 0   0     0   0   9 1                       10 5 2 3 0   0     0   0   9 1                 10
936411 936411 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2016   grade_6 25 17 13 0   38     0   2   41 54                       95 25 17 13 0   38     0   2   41 54                 95
936420 936420 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_6 20 30 21 1   22     0   2   41 55                       96 20 30 21 1   22     0   2   41 55                 96
936429 936429 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No 1 KG 08 2016   grade_6 24 12 14 0   6     0   2   25 33                       58 24 12 14 0   6     0   2   25 33                 58
936438 936438 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2016   grade_6 29 22 20 0   21     0   1   49 44                       93 29 22 20 0   21     0   1   49 44                 93
936448 936448 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2016   grade_6 27 40 42 1   24     0   5   74 65                       139 27 40 42 1   24     0   5   74 65                 139
936500 936500 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No 1 PK 06 2016   grade_6 71 3 3 0   0     0   1   43 35                       78 71 3 3 0   0     0   1   43 35                 78
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
936722 936722 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2016   grade_6 98 1 27 0   2     0   2   68 62                       130 98 1 27 0   2     0   2   68 62                 130

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