enrollments

Data source: Big Local News · About: Big Local

975 rows where grade = "grade_1", state = "MA" and year = 2020 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 875 ✖

grade ✖

  • grade_1 · 875 ✖
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
1366184 1366184 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2020   grade_1 18 39 13 0   2     1   4   36 41 *                     77.0 18 39 13 0   2     1   4   36 41                 77
1366190 1366190 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Gilmore Elementary School   Regular School No Elementary KG 05 2020   grade_1 1 55 9 0   0     0   1   27 39 *                     66.0 1 55 9 0   0     0   1   27 39                 66
1366196 1366196 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_1 25 67 12 0   6     0   6   64 52 *                     116.0 25 67 12 0   6     0   6   64 52                 116
1366202 1366202 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   grade_1 7 96 18 0   0     0   1   69 53 *                     122.0 7 96 18 0   0     0   1   69 53                 122
1366211 1366211 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_1 20 45 13 0   3     0   4   46 39 *                     85.0 20 45 13 0   3     0   4   46 39                 85
1366267 1366267 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_1 35 4 4 0   30     0   5   32 46 *                     78.0 35 4 4 0   30     0   5   32 46                 78
1366286 1366286 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary KG 08 2020   grade_1 31 3 3 0   15     0   10   29 33 *                     62.0 31 3 3 0   15     0   10   29 33                 62
1366305 1366305 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2020   grade_1 39 4 7 0   30     0   5   40 45 *                     85.0 39 4 7 0   30     0   5   40 45                 85
1366314 1366314 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_1 22 4 8 0   19     0   4   29 28 *                     57.0 22 4 8 0   19     0   4   29 28                 57
1366323 1366323 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_1 46 4 4 0   31     0   10   50 45 *                     95.0 46 4 4 0   31     0   10   50 45                 95
1366348 1366348 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No Elementary KG 05 2020   grade_1 64 4 6 0   17     0   1   41 51 *                     92.0 64 4 6 0   17     0   1   41 51                 92
1366354 1366354 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No Elementary KG 05 2020   grade_1 44 2 5 0   13     0   3   38 29 *                     67.0 44 2 5 0   13     0   3   38 29                 67
1366360 1366360 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2020   grade_1 46 1 2 0   6     0   3   30 28 *                     58.0 46 1 2 0   6     0   3   30 28                 58
1366366 1366366 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2020   grade_1 42 12 5 0   15     0   5   40 39 *                     79.0 42 12 5 0   15     0   5   40 39                 79
1366486 1366486 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No Elementary KG 05 2020   grade_1 42 11 5 0   10     0   6   39 35 *                     74.0 42 11 5 0   10     0   6   39 35                 74
1366492 1366492 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_1 62 4 2 0   9     0   9   43 43 *                     86.0 62 4 2 0   9     0   9   43 43                 86
1366498 1366498 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2020   grade_1 60 3 4 0   7     0   8   44 38 *                     82.0 60 3 4 0   7     0   8   44 38                 82
1366538 1366538 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2020   grade_1 75 2 7 0   20     0   3   58 49 *                     107.0 75 2 7 0   20     0   3   58 49                 107
1366543 1366543 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No Elementary KG 04 2020   grade_1 64 0 6 1   19     0   4   54 40 *                     94.0 64 0 6 1   19     0   4   54 40                 94
1366548 1366548 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2020   grade_1 62 5 8 0   22     0   4   44 57 *                     101.0 62 5 8 0   22     0   4   44 57                 101
1366553 1366553 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   grade_1 65 1 11 0   11     0   3   41 50 *                     91.0 65 1 11 0   11     0   3   41 50                 91
1366612 1366612 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2020   grade_1 29 2 24 0   1     0   4   36 24 *                     60.0 29 2 24 0   1     0   4   36 24                 60
1366618 1366618 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2020   grade_1 38 8 27 0   2     0   1   35 41 *                     76.0 38 8 27 0   2     0   1   35 41                 76
1366621 1366621 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary KG 05 2020   grade_1 18 6 43 0   3     0   4   40 34 *                     74.0 18 6 43 0   3     0   4   40 34                 74
1366627 1366627 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2020   grade_1 34 1 13 0   3     0   0   25 26 *                     51.0 34 1 13 0   3     0   0   25 26                 51
1366639 1366639 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2020   grade_1 18 0 2 0   0     0   0   6 14 *                     20.0 18 0 2 0   0     0   0   6 14                 20
1366645 1366645 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No Elementary KG 05 2020   grade_1 30 4 6 0   1     0   2   28 15 *                     43.0 30 4 6 0   1     0   2   28 15                 43
1366651 1366651 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Fairview Elementary   Regular School No Elementary KG 05 2020   grade_1 36 6 39 0   2     0   1   46 38 *                     84.0 36 6 39 0   2     0   1   46 38                 84
1366657 1366657 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No Elementary KG 05 2020   grade_1 31 3 5 0   1     0   2   27 15 *                     42.0 31 3 5 0   1     0   2   27 15                 42
1366663 1366663 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No Elementary KG 05 2020   grade_1 10 0 31 0   1     0   2   29 15 *                     44.0 10 0 31 0   1     0   2   29 15                 44
1366683 1366683 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_1 20 0 2 0   0     0   0   13 9 *                     22.0 20 0 2 0   0     0   0   13 9                 22
1366753 1366753 MA Essex   school 2503990 71   Danvers 250399000532 710010 Highlands   Regular School No Elementary KG 05 2020   grade_1 51 3 8 0   1     0   1   29 35 *                     64.0 51 3 8 0   1     0   1   29 35                 64
1366759 1366759 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No Elementary KG 05 2020   grade_1 43 1 9 0   0     0   1   23 31 *                     54.0 43 1 9 0   0     0   1   23 31                 54
1366772 1366772 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No Elementary KG 05 2020   grade_1 48 3 6 0   0     0   2   24 35 *                     59.0 48 3 6 0   0     0   2   24 35                 59
1366778 1366778 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No Elementary KG 05 2020   grade_1 43 0 2 0   1     0   0   22 24 *                     46.0 43 0 2 0   1     0   0   22 24                 46
1366806 1366806 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2020   grade_1 105 1 9 0   1     0   7   67 56 *                     123.0 105 1 9 0   1     0   7   67 56                 123
1366885 1366885 MA Middlesex   school 2504320 79   Dracut 250432000582 790030 Greenmont Avenue   Regular School No Elementary KG 05 2020   grade_1 33 2 6 0   2     0   0   25 18 *                     43.0 33 2 6 0   2     0   0   25 18                 43
1366891 1366891 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2020   grade_1 62 12 15 0   6     0   0   41 54 *                     95.0 62 12 15 0   6     0   0   41 54                 95
1366897 1366897 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 George H. Englesby Elementary School   Regular School No Elementary KG 05 2020   grade_1 71 1 13 0   5     0   2   48 44 *                     92.0 71 1 13 0   5     0   2   48 44                 92
1366945 1366945 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2020   grade_1 33 0 5 0   1     0   1   21 19 *                     40.0 33 0 5 0   1     0   1   21 19                 40
1366956 1366956 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No Elementary KG 04 2020   grade_1 29 0 7 0   0     0   1   17 20 *                     37.0 29 0 7 0   0     0   1   17 20                 37
1367030 1367030 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2020   grade_1 5 4 49 1   1     0   1   31 30 *                     61.0 5 4 49 1   1     0   1   31 30                 61
1367046 1367046 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_1 21 15 35 0   4     0   1   36 40 *                     76.0 21 15 35 0   4     0   1   36 40                 76
1367055 1367055 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_1 8 14 49 0   4     0   1   40 36 *                     76.0 8 14 49 0   4     0   1   40 36                 76
1367063 1367063 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_1 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1367071 1367071 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_1 13 20 51 0   9     0   0   52 41 *                     93.0 13 20 51 0   9     0   0   52 41                 93
1367080 1367080 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_1 8 13 86 0   2     0   0   48 61 *                     109.0 8 13 86 0   2     0   0   48 61                 109
1367122 1367122 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2020   grade_1 49 12 40 0   2     0   16   57 62 *                     119.0 49 12 40 0   2     0   16   57 62                 119
1367176 1367176 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No Elementary KG 05 2020   grade_1 30 3 9 0   2     0   6   19 31 *                     50.0 30 3 9 0   2     0   6   19 31                 50
1367182 1367182 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Samuel Watson   Regular School No Elementary KG 05 2020   grade_1 23 5 15 0   1     0   6   20 30 *                     50.0 23 5 15 0   1     0   6   20 30                 50
1367226 1367226 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   grade_1 70 5 9 1   2     0   5   35 57 *                     92.0 70 5 9 1   2     0   5   35 57                 92
1367231 1367231 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   grade_1 50 2 5 0   0     1   4   27 35 *                     62.0 50 2 5 0   0     1   4   27 35                 62
1367306 1367306 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No Elementary KG 04 2020   grade_1 44 5 4 0   6     1   5   39 26 *                     65.0 44 5 4 0   6     1   5   39 26                 65
1367311 1367311 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No Elementary KG 04 2020   grade_1 30 0 7 0   2     0   2   23 18 *                     41.0 30 0 7 0   2     0   2   23 18                 41
1367326 1367326 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 05 2020   grade_1 46 3 11 0   10     0   7   37 40 *                     77.0 46 3 11 0   10     0   7   37 40                 77
1367332 1367332 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2020   grade_1 26 6 42 1   6     0   6   43 44 *                     87.0 26 6 42 1   6     0   6   43 44                 87
1367338 1367338 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2020   grade_1 57 10 21 0   3     0   5   48 48 *                     96.0 57 10 21 0   3     0   5   48 48                 96
1367344 1367344 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_1 59 4 12 0   10     0   12   52 45 *                     97.0 59 4 12 0   10     0   12   52 45                 97
1367350 1367350 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_1 15 4 97 0   0     0   6   51 71 *                     122.0 15 4 97 0   0     0   6   51 71                 122
1367356 1367356 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No Elementary KG 05 2020   grade_1 68 6 12 0   1     0   4   52 39 *                     91.0 68 6 12 0   1     0   4   52 39                 91
1367362 1367362 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2020   grade_1 31 3 21 0   4     0   6   38 27 *                     65.0 31 3 21 0   4     0   6   38 27                 65
1367368 1367368 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2020   grade_1 37 9 34 0   1     0   5   44 42 *                     86.0 37 9 34 0   1     0   5   44 42                 86
1367374 1367374 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_1 53 16 19 1   0     0   2   47 44 *                     91.0 53 16 19 1   0     0   2   47 44                 91
1367394 1367394 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No Elementary KG 05 2020   grade_1 52 1 2 0   2     1   1   29 30 *                     59.0 52 1 2 0   2     1   1   29 30                 59
1367400 1367400 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No Elementary KG 05 2020   grade_1 44 2 2 0   1     0   0   27 22 *                     49.0 44 2 2 0   1     0   0   27 22                 49
1367406 1367406 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_1 49 1 1 0   1     2   0   31 23 *                     54.0 49 1 1 0   1     2   0   31 23                 54
1367412 1367412 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2020   grade_1 48 0 4 0   2     0   5   30 29 *                     59.0 48 0 4 0   2     0   5   30 29                 59
1367418 1367418 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2020   grade_1 41 3 6 0   1     0   0   26 25 *                     51.0 41 3 6 0   1     0   0   26 25                 51
1367424 1367424 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_1 43 2 3 0   3     2   0   23 30 *                     53.0 43 2 3 0   3     2   0   23 30                 53
1367463 1367463 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_1 106 0 0 0   0     0   5   56 55 *                     111.0 106 0 0 0   0     0   5   56 55                 111
1367476 1367476 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No Elementary KG 05 2020   grade_1 42 2 11 0   0     0   3   31 27 *                     58.0 42 2 11 0   0     0   3   31 27                 58
1367482 1367482 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2020   grade_1 29 0 4 0   1     0   0   18 16 *                     34.0 29 0 4 0   1     0   0   18 16                 34
1367489 1367489 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2020   grade_1 36 0 0 0   0     0   2   21 17 *                     38.0 36 0 0 0   0     0   2   21 17                 38
1367495 1367495 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2020   grade_1 15 1 7 0   1     0   3   18 9 *                     27.0 15 1 7 0   1     0   3   18 9                 27
1367501 1367501 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2020   grade_1 46 0 5 0   0     0   4   23 32 *                     55.0 46 0 5 0   0     0   4   23 32                 55
1367552 1367552 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No Elementary KG 04 2020   grade_1 28 1 14 0   3     0   0   20 26 *                     46.0 28 1 14 0   3     0   0   20 26                 46
1367557 1367557 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2020   grade_1 38 0 2 0   2     0   3   19 26 *                     45.0 38 0 2 0   2     0   3   19 26                 45
1367562 1367562 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No Elementary KG 04 2020   grade_1 28 4 13 0   1     0   3   29 20 *                     49.0 28 4 13 0   1     0   3   29 20                 49
1367589 1367589 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2020   grade_1 78 0 4 0   0     0   1   47 36 *                     83.0 78 0 4 0   0     0   1   47 36                 83
1367645 1367645 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2020   grade_1 50 3 52 0   2     0   5   62 50 *                     112.0 50 3 52 0   2     0   5   62 50                 112
1367650 1367650 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2020   grade_1 51 1 39 0   3     0   1   47 48 *                     95.0 51 1 39 0   3     0   1   47 48                 95
1367655 1367655 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_1 59 6 21 0   0     0   4   46 44 *                     90.0 59 6 21 0   0     0   4   46 44                 90
1367672 1367672 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2020   grade_1 38 7 44 0   1     0   4   45 49 *                     94.0 38 7 44 0   1     0   4   45 49                 94
1367677 1367677 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Silver Hill Elementary School   Regular School No Elementary KG 05 2020   grade_1 33 4 30 1   2     0   2   38 34 *                     72.0 33 4 30 1   2     0   2   38 34                 72
1367694 1367694 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary KG 03 2020   grade_1 48 6 65 0   0     0   2   63 58 *                     121.0 48 6 65 0   0     0   2   63 58                 121
1367698 1367698 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2020   grade_1 30 3 14 0   0     0   1   24 24 *                     48.0 30 3 14 0   0     0   1   24 24                 48
1367727 1367727 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No Elementary KG 05 2020   grade_1 79 1 3 0   2     0   3   46 42 *                     88.0 79 1 3 0   2     0   3   46 42                 88
1367733 1367733 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No Elementary KG 05 2020   grade_1 53 2 4 1   2     0   2   35 29 *                     64.0 53 2 4 1   2     0   2   35 29                 64
1367739 1367739 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No Elementary KG 05 2020   grade_1 76 1 2 0   5     0   0   46 38 *                     84.0 76 1 2 0   5     0   0   46 38                 84
1367853 1367853 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2020   grade_1 4 4 50 0   0     0   1   32 27 *                     59.0 4 4 50 0   0     0   1   32 27                 59
1367867 1367867 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2020   grade_1 52 0 6 0   2     0   3   33 30 *                     63.0 52 0 6 0   2     0   3   33 30                 63
1367881 1367881 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2020   grade_1 181 0 17 0   79     0   18   146 149 *                     295.0 181 0 17 0   79     0   18   146 149                 295
1367901 1367901 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No Elementary KG 04 2020   grade_1 51 0 8 0   0     0   4   33 30 *                     63.0 51 0 8 0   0     0   4   33 30                 63
1367934 1367934 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary KG 05 2020   grade_1 54 0 3 0   0     0   3   27 33 *                     60.0 54 0 3 0   0     0   3   27 33                 60
1367954 1367954 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2020   grade_1 144 0 1 0   0     0   3   74 74 *                     148.0 144 0 1 0   0     0   3   74 74                 148
1367971 1367971 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_1 5 1 114 0   0     0   0   61 58 1                     120.0 5 1 114 0   0     0   0   61 58 1               120
1367988 1367988 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2020   grade_1 5 3 102 0   6     0   1   59 56 *                     117.0 5 3 102 0   6     0   1   59 56                 117
1368022 1368022 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2020   grade_1 3 1 129 0   0     0   0   80 52 *                     133.0 3 1 129 0   0     0   0   80 52                 133
1368032 1368032 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_1 1 0 60 0   1     0   0   34 28 *                     62.0 1 0 60 0   1     0   0   34 28                 62
1368058 1368058 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_1 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2

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