enrollments

Data source: Big Local News · About: Big Local

592 rows where grade = "grade_6", state = "MA" and year = 2021 sorted by ccd_school_lvl

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 592 ✖

grade ✖

  • grade_6 · 592 ✖
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
1672093 1672093 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_6 26 1 15 0   6     0   2   26 24 *                     50.0 26 1 15 0   6     0   2   26 24                 50
1672100 1672100 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_6 20 2 10 0   6     0   2   18 22 *                     40.0 20 2 10 0   6     0   2   18 22                 40
1672107 1672107 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_6 27 4 10 0   4     0   5   32 18 *                     50.0 27 4 10 0   4     0   5   32 18                 50
1672288 1672288 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_6 29 19 6 0   1     0   0   26 29 *                     55.0 29 19 6 0   1     0   0   26 29                 55
1672502 1672502 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_6 5 4 5 0   3     0   1   9 9 *                     18.0 5 4 5 0   3     0   1   9 9                 18
1672526 1672526 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_6 19 7 16 0   1     0   4   19 28 *                     47.0 19 7 16 0   1     0   4   19 28                 47
1672536 1672536 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston - Jackson Mann   Regular School No Elementary PK 08 2021   grade_6 8 10 27 0   9     0   1   33 22 *                     55.0 8 10 27 0   9     0   1   33 22                 55
1672561 1672561 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   grade_6 30 20 51 1   3     0   5   43 67 *                     110.0 30 20 51 1   3     0   5   43 67                 110
1672593 1672593 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston - Curtis Guild   Regular School No Elementary PK 06 2021   grade_6 3 0 33 0   0     0   0   16 20 *                     36.0 3 0 33 0   0     0   0   16 20                 36
1672601 1672601 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_6 4 0 8 0   0     0   0   7 5 *                     12.0 4 0 8 0   0     0   0   7 5                 12
1672623 1672623 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_6 12 17 16 0   0     0   1   23 23 *                     46.0 12 17 16 0   0     0   1   23 23                 46
1672633 1672633 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_6 8 0 88 0   0     0   1   44 53 *                     97.0 8 0 88 0   0     0   1   44 53                 97
1672643 1672643 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston - Edward Everett   Regular School No Elementary PK 06 2021   grade_6 1 16 18 0   5     0   3   16 27 *                     43.0 1 16 18 0   5     0   3   16 27                 43
1672651 1672651 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_6 59 6 22 1   10     0   7   47 58 *                     105.0 59 6 22 1   10     0   7   47 58                 105
1672668 1672668 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston - Franklin D Roosevelt   Regular School No Elementary PK 08 2021   grade_6 4 22 16 0   2     0   5   25 24 *                     49.0 4 22 16 0   2     0   5   25 24                 49
1672678 1672678 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston - George H Conley   Regular School No Elementary PK 06 2021   grade_6 1 10 10 0   1     0   2   13 11 *                     24.0 1 10 10 0   1     0   2   13 11                 24
1672700 1672700 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston - Hugh Roe O'Donnell   Regular School No Elementary PK 06 2021   grade_6 0 0 34 0   1     0   0   16 19 *                     35.0 0 0 34 0   1     0   0   16 19                 35
1672708 1672708 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_6 25 20 37 0   12     0   5   49 50 *                     99.0 25 20 37 0   12     0   5   49 50                 99
1672717 1672717 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_6 1 30 45 0   1     1   0   36 42 *                     78.0 1 30 45 0   1     1   0   36 42                 78
1672734 1672734 MA Suffolk   school 2502790 35   Boston 250279000257 350156 Boston - James Otis   Regular School No Elementary PK 06 2021   grade_6 9 3 25 0   3     0   0   27 13 *                     40.0 9 3 25 0   3     0   0   27 13                 40
1672773 1672773 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Boston - Joseph P Tynan   Regular School No Elementary PK 06 2021   grade_6 2 11 8 0   2     0   0   15 8 *                     23.0 2 11 8 0   2     0   0   15 8                 23
1672781 1672781 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_6 6 1 27 0   0     0   3   21 16 *                     37.0 6 1 27 0   0     0   3   21 16                 37
1672791 1672791 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_6 5 42 25 0   3     0   6   42 39 *                     81.0 5 42 25 0   3     0   6   42 39                 81
1672801 1672801 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston - Joseph P Manning   Regular School No Elementary PK 06 2021   grade_6 14 3 3 0   1     1   2   17 7 *                     24.0 14 3 3 0   1     1   2   17 7                 24
1672809 1672809 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_6 29 4 11 0   9     0   3   36 20 *                     56.0 29 4 11 0   9     0   3   36 20                 56
1672819 1672819 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Boston - Harvard-Kent   Regular School No Elementary PK 06 2021   grade_6 6 17 18 0   14     0   1   32 24 *                     56.0 6 17 18 0   14     0   1   32 24                 56
1672827 1672827 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Boston - Manassah E Bradley   Regular School No Elementary PK 06 2021   grade_6 6 1 16 0   3     0   1   13 14 *                     27.0 6 1 16 0   3     0   1   13 14                 27
1672842 1672842 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_6 1 17 29 0   0     0   1   20 28 *                     48.0 1 17 29 0   0     0   1   20 28                 48
1672852 1672852 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_6 3 7 4 0   1     0   2   10 7 *                     17.0 3 7 4 0   1     0   2   10 7                 17
1672867 1672867 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_6 10 24 23 1   74     0   7   78 61 *                     139.0 10 24 23 1   74     0   7   78 61                 139
1672877 1672877 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   grade_6 2 10 6 0   3     0   2   10 13 *                     23.0 2 10 6 0   3     0   2   10 13                 23
1672885 1672885 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_6 6 6 8 0   0     0   2   18 4 *                     22.0 6 6 8 0   0     0   2   18 4                 22
1672894 1672894 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_6 1 54 29 0   1     0   1   37 49 *                     86.0 1 54 29 0   1     0   1   37 49                 86
1672910 1672910 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_6 30 10 20 0   3     1   3   37 30 *                     67.0 30 10 20 0   3     1   3   37 30                 67
1672920 1672920 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston - Patrick J Kennedy   Regular School No Elementary PK 06 2021   grade_6 1 4 36 0   1     0   0   29 13 *                     42.0 1 4 36 0   1     0   0   29 13                 42
1672952 1672952 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_6 1 5 4 0   0     0   0   5 5 *                     10.0 1 5 4 0   0     0   0   5 5                 10
1672960 1672960 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_6 5 0 20 0   0     0   0   16 9 *                     25.0 5 0 20 0   0     0   0   16 9                 25
1672975 1672975 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_6 0 8 34 0   0     0   0   23 19 *                     42.0 0 8 34 0   0     0   0   23 19                 42
1672985 1672985 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_6 4 3 34 0   3     0   1   25 20 *                     45.0 4 3 34 0   3     0   1   25 20                 45
1672995 1672995 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston - Thomas J Kenny   Regular School No Elementary PK 06 2021   grade_6 4 27 12 0   7     0   0   28 22 *                     50.0 4 27 12 0   7     0   0   28 22                 50
1673003 1673003 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_6 32 11 14 0   4     0   2   32 31 *                     63.0 32 11 14 0   4     0   2   32 31                 63
1673013 1673013 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_6 1 6 14 0   2     1   1   12 13 *                     25.0 1 6 14 0   2     1   1   12 13                 25
1673039 1673039 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_6 1 16 18 0   0     0   0   25 10 *                     35.0 1 16 18 0   0     0   0   25 10                 35
1673056 1673056 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_6 7 13 38 1   10     0   1   36 34 *                     70.0 7 13 38 1   10     0   1   36 34                 70
1673066 1673066 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_6 0 35 18 0   2     0   3   31 27 *                     58.0 0 35 18 0   2     0   3   31 27                 58
1673082 1673082 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_6 3 76 29 1   2     0   1   54 58 *                     112.0 3 76 29 1   2     0   1   54 58                 112
1673092 1673092 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_6 0 36 30 1   0     0   2   43 26 *                     69.0 0 36 30 1   0     0   2   43 26                 69
1673102 1673102 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_6 5 5 5 0   0     0   1   10 6 *                     16.0 5 5 5 0   0     0   1   10 6                 16
1673254 1673254 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_6 3 1 60 0   1     0   0   35 30 *                     65.0 3 1 60 0   1     0   0   35 30                 65
1673275 1673275 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_6 0 2 34 0   0     0   1   16 21 *                     37.0 0 2 34 0   0     0   1   16 21                 37
1673315 1673315 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford - Spofford Pond   Regular School No Elementary 03 06 2021   grade_6 81 0 3 0   6     0   2   49 43 *                     92.0 81 0 3 0   6     0   2   49 43                 92
1673374 1673374 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_6 44 2 1 0   0     0   0   23 24 *                     47.0 44 2 1 0   0     0   0   23 24                 47
1673414 1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1673495 1673495 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_6 33 0 1 0   0     0   2   17 19 *                     36.0 33 0 1 0   0     0   2   17 19                 36
1673505 1673505 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline - Edith C Baker   Regular School No Elementary KG 08 2021   grade_6 40 6 5 0   28     0   7   44 42 *                     86.0 40 6 5 0   28     0   7   44 42                 86
1673515 1673515 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   grade_6 45 5 9 0   10     0   11   38 42 *                     80.0 45 5 9 0   10     0   11   38 42                 80
1673524 1673524 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   grade_6 41 3 4 0   8     0   12   37 31 *                     68.0 41 3 4 0   8     0   12   37 31                 68
1673534 1673534 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   grade_6 38 2 4 0   10     0   8   26 36 *                     62.0 38 2 4 0   10     0   8   26 36                 62
1673543 1673543 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline - Lawrence   Regular School No Elementary KG 08 2021   grade_6 29 4 7 0   16     0   5   29 32 *                     61.0 29 4 7 0   16     0   5   29 32                 61
1673552 1673552 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_6 31 7 6 0   15     0   4   25 38 *                     63.0 31 7 6 0   15     0   4   25 38                 63
1673561 1673561 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline - Pierce   Regular School No Elementary KG 08 2021   grade_6 44 1 13 0   24     0   11   46 46 *                     93.0 44 1 13 0   24     0   11   46 46                 93
1673571 1673571 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_6 34 4 8 0   7     0   2   26 29 *                     55.0 34 4 8 0   7     0   2   26 29                 55
1673626 1673626 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_6 10 2 21 0   1     0   5   21 18 *                     39.0 10 2 21 0   1     0   5   21 18                 39
1673750 1673750 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_6 43 0 3 0   9     0   11   34 32 *                     66.0 43 0 3 0   9     0   11   34 32                 66
1673816 1673816 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_6 1 0 37 0   0     0   1   16 23 *                     39.0 1 0 37 0   0     0   1   16 23                 39
1673916 1673916 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_6 20 0 0 0   0     0   0   11 9 *                     20.0 20 0 0 0   0     0   0   11 9                 20
1673979 1673979 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   grade_6 16 0 1 0   0     0   0   10 7 *                     17.0 16 0 1 0   0     0   0   10 7                 17
1674084 1674084 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield - Deerfield Elementary   Regular School No Elementary PK 06 2021   grade_6 40 0 5 0   0     0   4   23 26 *                     49.0 40 0 5 0   0     0   4   23 26                 49
1674160 1674160 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater - Gordon W. Mitchell School   Regular School No Elementary 03 06 2021   grade_6 128 8 7 1   0     0   5   76 73 *                     149.0 128 8 7 1   0     0   5   76 73                 149
1674245 1674245 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_6 32 3 14 4   1     0   1   26 29 *                     55.0 32 3 14 4   1     0   1   26 29                 55
1674255 1674255 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving - Erving Elementary   Regular School No Elementary PK 06 2021   grade_6 6 0 0 0   0     0   3   3 6 *                     9.0 6 0 0 0   0     0   3   3 6                 9
1674264 1674264 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett - Sumner G. Whittier School   Regular School No Elementary KG 08 2021   grade_6 10 10 56 0   2     0   0   38 40 *                     78.0 10 10 56 0   2     0   0   38 40                 78
1674279 1674279 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett - Madeline English School   Regular School No Elementary KG 08 2021   grade_6 22 8 50 0   4     0   0   44 40 *                     84.0 22 8 50 0   4     0   0   44 40                 84
1674288 1674288 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_6 19 16 75 0   4     0   2   58 58 *                     116.0 19 16 75 0   4     0   2   58 58                 116
1674307 1674307 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_6 37 12 57 0   12     0   3   67 54 *                     121.0 37 12 57 0   12     0   3   67 54                 121
1674316 1674316 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_6 17 18 73 0   1     0   3   55 57 *                     112.0 17 18 73 0   1     0   3   55 57                 112
1674379 1674379 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_6 30 12 24 0   8     0   8   39 43 *                     82.0 30 12 24 0   8     0   8   39 43                 82
1674389 1674389 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River - John J Doran   Regular School No Elementary PK 08 2021   grade_6 25 8 9 0   1     0   7   22 28 *                     50.0 25 8 9 0   1     0   7   22 28                 50
1674511 1674511 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg - McKay Arts Academy   Regular School No Elementary PK 08 2021   grade_6 27 5 32 0   7     0   6   33 44 *                     77.0 27 5 32 0   7     0   6   33 44                 77
1674530 1674530 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_6 * * * *   *     *   *   1 3 *                     4.0                         1 3                 4
1674703 1674703 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_6 75 2 2 0   1     0   2   42 40 *                     82.0 75 2 2 0   1     0   2   42 40                 82
1674774 1674774 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 114 0 10 0   13     0   6   74 69 *                     143.0 114 0 10 0   13     0   6   74 69                 143
1674779 1674779 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton - Millbury Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 98 0 15 0   29     0   1   76 67 *                     143.0 98 0 15 0   29     0   1   76 67                 143
1674793 1674793 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby - East Meadow   Regular School No Elementary PK 06 2021   grade_6 40 0 4 0   0     0   1   19 26 *                     45.0 40 0 4 0   0     0   1   19 26                 45
1674831 1674831 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley - Hadley Elementary   Regular School No Elementary PK 06 2021   grade_6 26 3 3 0   1     1   1   17 18 *                     35.0 26 3 3 0   1     1   1   17 18                 35
1674844 1674844 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_6 70 1 5 1   0     0   4   46 35 *                     81.0 70 1 5 1   0     0   4   46 35                 81
1674852 1674852 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_6 11 0 0 0   0     0   1   6 6 *                     12.0 11 0 0 0   0     0   1   6 6                 12
1674889 1674889 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield - Hatfield Elementary   Regular School No Elementary PK 06 2021   grade_6 34 0 3 0   0     0   0   21 16 *                     37.0 34 0 3 0   0     0   0   21 16                 37
1674912 1674912 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_6 113 6 40 0   3     0   5   90 77 *                     167.0 113 6 40 0   3     0   5   90 77                 167
1675019 1675019 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland - Holland Elementary   Regular School No Elementary PK 06 2021   grade_6 28 0 3 0   0     0   0   15 16 *                     31.0 28 0 3 0   0     0   0   15 16                 31
1675041 1675041 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke - Joseph Metcalf School   Regular School No Elementary PK 06 2021   grade_6 6 1 25 0   0     0   0   9 23 *                     32.0 6 1 25 0   0     0   0   9 23                 32
1675049 1675049 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_6 13 0 25 0   2     0   1   19 22 *                     41.0 13 0 25 0   2     0   1   19 22                 41
1675084 1675084 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke - Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2021   grade_6 8 2 41 0   1     0   0   27 25 *                     52.0 8 2 41 0   1     0   0   27 25                 52
1675117 1675117 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale - Memorial   Regular School No Elementary KG 06 2021   grade_6 67 0 8 0   1     0   1   38 39 *                     77.0 67 0 8 0   1     0   1   38 39                 77
1675204 1675204 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston - Kingston Intermediate   Regular School No Elementary 03 06 2021   grade_6 141 3 4 1   0     0   1   77 73 *                     150.0 141 3 4 1   0     0   1   77 73                 150
1675282 1675282 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence - Emily G Wetherbee   Regular School No Elementary KG 08 2021   grade_6 3 0 54 0   1     0   0   24 34 *                     58.0 3 0 54 0   1     0   0   24 34                 58
1675322 1675322 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee - Lee Elementary   Regular School No Elementary PK 06 2021   grade_6 36 1 9 0   2     0   2   32 18 *                     50.0 36 1 9 0   2     0   2   32 18                 50
1675409 1675409 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_6 23 0 0 0   0     0   0   16 7 *                     23.0 23 0 0 0   0     0   0   16 7                 23
1675469 1675469 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln - Lincoln School   Regular School No Elementary PK 08 2021   grade_6 37 7 7 0   2     0   4   31 26 *                     57.0 37 7 7 0   2     0   4   31 26                 57
1675533 1675533 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell - Rogers STEM Academy   Regular School No Elementary KG 08 2021   grade_6 27 11 45 0   22     0   6   53 58 *                     111.0 27 11 45 0   22     0   6   53 58                 111

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