enrollments

Data source: Big Local News · About: Big Local

577 rows where grade = "grade_6", state = "MA" and year = 2017 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 577 ✖

grade ✖

  • grade_6 · 577 ✖
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
1122052 1122052 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_6 23 6 13 0   5     0   2   22 27                       49 23 6 13 0   5     0   2   22 27                 49
1122060 1122060 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_6 20 5 9 0   6     0   4   26 18                       44 20 5 9 0   6     0   4   26 18                 44
1122068 1122068 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_6 25 7 11 0   9     0   5   27 30                       57 25 7 11 0   9     0   5   27 30                 57
1122288 1122288 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2017   grade_6 32 15 6 0   1     0   5   26 33                       59 32 15 6 0   1     0   5   26 33                 59
1122354 1122354 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_6 183 2 6 0   6     1   7   109 96                       205 183 2 6 0   6     1   7   109 96                 205
1122382 1122382 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Elementary 04 07 2017   grade_6 154 3 7 0   5     0   1   86 84                       170 154 3 7 0   5     0   1   86 84                 170
1122567 1122567 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_6 6 1 5 0   3     0   2   8 9                       17 6 1 5 0   3     0   2   8 9                 17
1122596 1122596 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_6 13 11 19 0   2     0   1   25 21                       46 13 11 19 0   2     0   1   25 21                 46
1122607 1122607 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2017   grade_6 8 24 24 0   9     0   4   31 38                       69 8 24 24 0   9     0   4   31 38                 69
1122628 1122628 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_6 20 19 59 0   7     0   4   42 67                       109 20 19 59 0   7     0   4   42 67                 109
1122675 1122675 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1122700 1122700 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_6 9 9 24 0   1     0   3   21 25                       46 9 9 24 0   1     0   3   21 25                 46
1122711 1122711 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_6 14 1 86 0   1     0   1   45 58                       103 14 1 86 0   1     0   1   45 58                 103
1122730 1122730 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_6 24 5 13 0   3     0   3   26 22                       48 24 5 13 0   3     0   3   26 22                 48
1122749 1122749 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   grade_6 8 21 23 0   2     0   0   26 28                       54 8 21 23 0   2     0   0   26 28                 54
1122792 1122792 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_6 24 37 36 0   16     1   1   56 59                       115 24 37 36 0   16     1   1   56 59                 115
1122801 1122801 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_6 12 24 56 0   2     0   3   46 51                       97 12 24 56 0   2     0   3   46 51                 97
1122872 1122872 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_6 6 0 26 0   0     0   1   14 19                       33 6 0 26 0   0     0   1   14 19                 33
1122883 1122883 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2017   grade_6 6 42 27 0   6     2   2   49 36                       85 6 42 27 0   6     2   2   49 36                 85
1122902 1122902 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_6 33 7 8 0   9     0   0   31 26                       57 33 7 8 0   9     0   0   31 26                 57
1122945 1122945 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_6 0 4 22 0   0     0   0   14 12                       26 0 4 22 0   0     0   0   14 12                 26
1122971 1122971 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_6 32 28 23 0   65     0   2   74 76                       150 32 28 23 0   65     0   2   74 76                 150
1122990 1122990 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_6 15 3 3 0   1     0   0   10 12                       22 15 3 3 0   1     0   0   10 12                 22
1123001 1123001 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_6 3 44 51 0   2     1   3   57 47                       104 3 44 51 0   2     1   3   57 47                 104
1123008 1123008 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_6 39 23 48 0   9     2   2   76 47                       123 39 23 48 0   9     2   2   76 47                 123
1123019 1123019 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2017   grade_6 31 11 21 0   1     0   0   34 30                       64 31 11 21 0   1     0   0   34 30                 64
1123091 1123091 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_6 0 9 25 0   0     0   1   19 16                       35 0 9 25 0   0     0   1   19 16                 35
1123102 1123102 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2017   grade_6 9 8 24 0   6     1   1   28 21                       49 9 8 24 0   6     1   1   28 21                 49
1123121 1123121 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_6 32 8 14 1   1     1   4   31 30                       61 32 8 14 1   1     1   4   31 30                 61
1123160 1123160 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_6 1 24 12 0   0     0   0   19 18                       37 1 24 12 0   0     0   0   19 18                 37
1123179 1123179 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2017   grade_6 12 21 39 0   12     0   1   49 36                       85 12 21 39 0   12     0   1   49 36                 85
1123190 1123190 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_6 1 27 14 0   0     0   0   20 22                       42 1 27 14 0   0     0   0   20 22                 42
1123199 1123199 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_6 0 9 12 0   0     0   1   14 8                       22 0 9 12 0   0     0   1   14 8                 22
1123209 1123209 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_6 2 54 32 2   3     0   4   54 43                       97 2 54 32 2   3     0   4   54 43                 97
1123220 1123220 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_6 0 30 15 0   0     0   0   24 21                       45 0 30 15 0   0     0   0   24 21                 45
1123231 1123231 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_6 4 2 10 1   0     0   0   9 8                       17 4 2 10 1   0     0   0   9 8                 17
1123409 1123409 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_6 15 7 140 0   2     1   1   84 82                       166 15 7 140 0   2     1   1   84 82                 166
1123438 1123438 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_6 0 0 31 0   0     0   0   9 22                       31 0 0 31 0   0     0   0   9 22                 31
1123492 1123492 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_6 116 1 6 0   3     1   4   73 58                       131 116 1 6 0   3     1   4   73 58                 131
1123575 1123575 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   grade_6 32 2 0 0   0     0   0   18 16                       34 32 2 0 0   0     0   0   18 16                 34
1123620 1123620 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_6 19 66 12 0   0     1   10   47 61                       108 19 66 12 0   0     1   10   47 61                 108
1123720 1123720 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 44 0 3 0   0     0   1   22 26                       48 44 0 3 0   0     0   1   22 26                 48
1123732 1123732 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_6 36 9 5 0   16     0   8   36 38                       74 36 9 5 0   16     0   8   36 38                 74
1123742 1123742 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_6 44 6 9 0   6     0   12   44 33                       77 44 6 9 0   6     0   12   44 33                 77
1123753 1123753 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2017   grade_6 37 5 3 1   13     0   7   38 28                       66 37 5 3 1   13     0   7   38 28                 66
1123764 1123764 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2017   grade_6 44 4 4 0   12     0   1   34 31                       65 44 4 4 0   12     0   1   34 31                 65
1123774 1123774 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2017   grade_6 26 4 3 0   22     0   7   32 30                       62 26 4 3 0   22     0   7   32 30                 62
1123784 1123784 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2017   grade_6 27 5 9 0   4     0   6   19 32                       51 27 5 9 0   4     0   6   19 32                 51
1123794 1123794 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_6 47 4 13 0   18     0   6   38 50                       88 47 4 13 0   18     0   6   38 50                 88
1123805 1123805 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2017   grade_6 39 1 6 0   14     0   6   30 36                       66 39 1 6 0   14     0   6   30 36                 66
1123870 1123870 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_6 13 2 14 0   0     0   6   9 26                       35 13 2 14 0   0     0   6   9 26                 35
1124014 1124014 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_6 51 1 0 0   15     0   3   33 37                       70 51 1 0 0   15     0   3   33 37                 70
1124213 1124213 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_6 16 0 0 0   0     0   0   7 9                       16 16 0 0 0   0     0   0   7 9                 16
1124225 1124225 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_6 93 5 24 0   1     0   0   74 49                       123 93 5 24 0   1     0   0   74 49                 123
1124286 1124286 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_6 26 0 0 0   0     0   0   14 12                       26 26 0 0 0   0     0   0   14 12                 26
1124408 1124408 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2017   grade_6 57 0 2 0   1     0   0   30 30                       60 57 0 2 0   1     0   0   30 30                 60
1124500 1124500 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No Elementary 03 06 2017   grade_6 170 6 3 1   3     0   4   90 96                       187 170 6 3 1   3     0   4   90 96                 187
1124603 1124603 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_6 23 0 7 0   0     0   4   17 17                       34 23 0 7 0   0     0   4   17 17                 34
1124614 1124614 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 1 0   0     0   0   6 6                       12 11 0 1 0   0     0   0   6 6                 12
1124624 1124624 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_6 7 12 32 3   2     0   2   31 27                       58 7 12 32 3   2     0   2   31 27                 58
1124641 1124641 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_6 28 19 43 2   7     0   3   48 54                       102 28 19 43 2   7     0   3   48 54                 102
1124651 1124651 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_6 32 22 41 0   4     0   2   54 47                       101 32 22 41 0   4     0   2   54 47                 101
1124670 1124670 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_6 37 22 48 1   1     0   4   48 65                       113 37 22 48 1   1     0   4   48 65                 113
1124680 1124680 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_6 11 16 63 0   7     0   1   52 46                       98 11 16 63 0   7     0   1   52 46                 98
1124750 1124750 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_6 27 10 19 0   2     0   3   33 28                       61 27 10 19 0   2     0   3   33 28                 61
1124761 1124761 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_6 28 3 21 0   1     0   3   21 35                       56 28 3 21 0   1     0   3   21 35                 56
1124818 1124818 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_6 * * * *   *     *   *   5 *                       *                         5                    
1124904 1124904 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2017   grade_6 29 1 36 0   3     0   5   36 38                       74 29 1 36 0   3     0   5   36 38                 74
1124926 1124926 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1125129 1125129 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_6 107 2 0 0   1     0   1   61 50                       111 107 2 0 0   1     0   1   61 50                 111
1125212 1125212 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_6 106 1 4 0   10     0   2   49 74                       123 106 1 4 0   10     0   2   49 74                 123
1125218 1125218 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2017   grade_6 111 3 5 0   18     0   4   71 70                       141 111 3 5 0   18     0   4   71 70                 141
1125230 1125230 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary 04 06 2017   grade_6 51 0 5 0   0     0   1   36 21                       57 51 0 5 0   0     0   1   36 21                 57
1125266 1125266 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125282 1125282 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_6 96 1 24 0   1     0   7   66 63                       129 96 1 24 0   1     0   7   66 63                 129
1125298 1125298 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_6 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1125313 1125313 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2017   grade_6 82 0 3 0   1     0   0   51 35                       86 82 0 3 0   1     0   0   51 35                 86
1125369 1125369 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_6 27 0 4 0   0     0   0   17 14                       31 27 0 4 0   0     0   0   17 14                 31
1125448 1125448 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_6 106 1 99 0   4     1   2   98 115                       213 106 1 99 0   4     1   2   98 115                 213
1125503 1125503 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No Elementary 04 06 2017   grade_6 48 19 13 0   4     0   7   44 47                       91 48 19 13 0   4     0   7   44 47                 91
1125519 1125519 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_6 33 0 1 0   1     0   0   13 22                       35 33 0 1 0   1     0   0   13 22                 35
1125551 1125551 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_6 13 1 23 0   0     0   0   19 18                       37 13 1 23 0   0     0   0   19 18                 37
1125562 1125562 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_6 0 2 38 0   0     0   0   21 19                       40 0 2 38 0   0     0   0   21 19                 40
1125568 1125568 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_6 6 2 72 0   0     0   0   44 36                       80 6 2 72 0   0     0   0   44 36                 80
1125578 1125578 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_6 2 0 39 0   0     0   0   22 19                       41 2 0 39 0   0     0   0   22 19                 41
1125589 1125589 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   grade_6 10 1 39 0   0     0   1   23 28                       51 10 1 39 0   0     0   1   23 28                 51
1125599 1125599 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_6 9 3 50 0   0     0   1   27 36                       63 9 3 50 0   0     0   1   27 36                 63
1125610 1125610 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2017   grade_6 6 0 32 0   0     0   2   22 18                       40 6 0 32 0   0     0   2   22 18                 40
1125636 1125636 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2017   grade_6 69 0 2 0   7     1   4   48 35                       83 69 0 2 0   7     1   4   48 35                 83
1125744 1125744 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2017   grade_6 145 3 2 0   2     0   1   82 71                       153 145 3 2 0   2     0   1   82 71                 153
1125753 1125753 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_6 22 0 0 0   0     0   0   10 12                       22 22 0 0 0   0     0   0   10 12                 22
1125781 1125781 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_6 6 0 88 0   3     0   0   48 49                       97 6 0 88 0   3     0   0   48 49                 97
1125851 1125851 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_6 2 1 80 0   5     0   0   44 44                       88 2 1 80 0   5     0   0   44 44                 88
1125903 1125903 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2017   grade_6 49 1 4 0   0     0   6   25 35                       60 49 1 4 0   0     0   6   25 35                 60
1126010 1126010 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   2     0   1   8 6                       14 11 0 0 0   2     0   1   8 6                 14
1126082 1126082 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_6 45 8 5 0   1     0   2   30 31                       61 45 8 5 0   1     0   2   30 31                 61
1126088 1126088 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_6 30 9 10 0   1     0   3   22 31                       53 30 9 10 0   1     0   3   22 31                 53
1126181 1126181 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2017   grade_6 24 2 18 0   9     0   2   30 25                       55 24 2 18 0   9     0   2   30 25                 55
1126251 1126251 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_6 * * * *   *     *   *   4 *                       *                         4                    
1126261 1126261 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_6 9 4 21 0   19     0   1   22 32                       54 9 4 21 0   19     0   1   22 32                 54

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