Data source: Big Local News · About: Big Local

990 rows where grade = "grade_1", state = "MA" and year = 2015 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2015 · 890

grade

  • grade_1 · 890
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
737022 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No 1 KG 05 2015   grade_1 75 5 2 0   8     0   1   47 44                       91 75 5 2 0   8     0   1   47 44                 91
737060 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2015   grade_1 13 83 30 1   1     0   12   74 66                       140 13 83 30 1   1     0   12   74 66                 140
737066 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No 1 KG 05 2015   grade_1 37 64 15 0   2     0   3   63 58                       121 37 64 15 0   2     0   3   63 58                 121
737072 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2015   grade_1 24 62 78 5   1     0   10   94 86                       180 24 62 78 5   1     0   10   94 86                 180
737079 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No 1 KG 05 2015   grade_1 39 67 11 0   1     0   9   67 60                       127 39 67 11 0   1     0   9   67 60                 127
737085 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No 1 KG 05 2015   grade_1 37 52 11 0   11     0   4   54 61                       115 37 52 11 0   11     0   4   54 61                 115
737091 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_1 23 68 25 1   1     0   12   65 65                       130 23 68 25 1   1     0   12   65 65                 130
737100 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No 1 KG 05 2015   grade_1 52 54 10 0   7     1   10   77 57                       134 52 54 10 0   7     1   10   77 57                 134
737108 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2015   grade_1 13 54 10 0   0     0   5   43 39                       82 13 54 10 0   0     0   5   43 39                 82
737114 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2015   grade_1 23 71 16 2   9     0   7   59 69                       128 23 71 16 2   9     0   7   59 69                 128
737120 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_1 16 83 17 0   2     0   9   64 63                       127 16 83 17 0   2     0   9   64 63                 127
737135 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2015   grade_1 31 58 24 2   2     0   6   74 49                       123 31 58 24 2   2     0   6   74 49                 123
737188 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_1 40 4 10 0   35     0   3   49 43                       92 40 4 10 0   35     0   3   49 43                 92
737197 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   grade_1 62 3 12 0   14     0   9   46 54                       100 62 3 12 0   14     0   9   46 54                 100
737226 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2015   grade_1 41 6 5 0   29     1   4   51 35                       86 41 6 5 0   29     1   4   51 35                 86
737235 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2015   grade_1 33 5 8 0   15     0   2   39 24                       63 33 5 8 0   15     0   2   39 24                 63
737244 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2015   grade_1 57 3 11 0   28     0   13   47 65                       112 57 3 11 0   28     0   13   47 65                 112
737270 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No 1 KG 05 2015   grade_1 36 0 2 0   4     0   1   19 24                       43 36 0 2 0   4     0   1   19 24                 43
737276 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No 1 KG 05 2015   grade_1 52 6 1 0   13     0   2   34 40                       74 52 6 1 0   13     0   2   34 40                 74
737282 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No 1 KG 05 2015   grade_1 33 1 1 0   2     0   1   17 21                       38 33 1 1 0   2     0   1   17 21                 38
737288 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No 1 KG 05 2015   grade_1 53 7 5 2   18     0   0   42 43                       85 53 7 5 2   18     0   0   42 43                 85
737408 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No 1 KG 05 2015   grade_1 62 8 4 0   7     0   4   45 40                       85 62 8 4 0   7     0   4   45 40                 85
737414 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No 1 KG 05 2015   grade_1 44 4 0 0   7     0   4   34 25                       59 44 4 0 0   7     0   4   34 25                 59
737420 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   grade_1 68 6 1 0   12     2   5   48 46                       94 68 6 1 0   12     2   5   48 46                 94
737459 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No 1 KG 04 2015   grade_1 71 1 5 0   13     0   3   44 49                       93 71 1 5 0   13     0   3   44 49                 93
737464 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No 1 KG 04 2015   grade_1 62 1 3 0   18     0   1   41 44                       85 62 1 3 0   18     0   1   41 44                 85
737469 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No 1 KG 04 2015   grade_1 64 2 7 1   12     0   3   53 36                       89 64 2 7 1   12     0   3   53 36                 89
737474 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No 1 KG 04 2015   grade_1 80 1 2 2   11     0   4   58 42                       100 80 1 2 2   11     0   4   58 42                 100
737527 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No 1 KG 05 2015   grade_1 44 0 16 0   5     1   2   33 35                       68 44 0 16 0   5     1   2   33 35                 68
737533 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2015   grade_1 64 9 30 0   0     0   1   60 44                       104 64 9 30 0   0     0   1   60 44                 104
737543 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2015   grade_1 52 3 11 0   1     0   4   36 35                       71 52 3 11 0   1     0   4   36 35                 71
737555 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No 1 KG 05 2015   grade_1 17 1 5 0   0     0   0   12 11                       23 17 1 5 0   0     0   0   12 11                 23
737561 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No 1 KG 05 2015   grade_1 32 2 10 0   0     0   0   22 22                       44 32 2 10 0   0     0   0   22 22                 44
737567 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Selser   Regular School No 1 KG 05 2015   grade_1 31 0 42 1   1     0   0   43 32                       75 31 0 42 1   1     0   0   43 32                 75
737573 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No 1 KG 05 2015   grade_1 31 0 18 0   2     0   2   28 25                       53 31 0 18 0   2     0   2   28 25                 53
737579 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_1 10 2 66 0   0     0   1   49 30                       79 10 2 66 0   0     0   1   49 30                 79
737601 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_1 24 0 0 0   0     0   1   13 12                       25 24 0 0 0   0     0   1   13 12                 25
737671 MA Essex   school 2503990 71   Danvers 250399000532 710010 Highlands   Regular School No 1 KG 05 2015   grade_1 42 2 6 0   5     0   2   28 29                       57 42 2 6 0   5     0   2   28 29                 57
737677 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No 1 KG 05 2015   grade_1 48 1 6 0   0     0   3   34 24                       58 48 1 6 0   0     0   3   34 24                 58
737690 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No 1 KG 05 2015   grade_1 44 1 1 0   2     0   0   26 22                       48 44 1 1 0   2     0   0   26 22                 48
737696 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No 1 KG 05 2015   grade_1 51 1 1 0   2     0   1   34 22                       56 51 1 1 0   2     0   1   34 22                 56
737717 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2015   grade_1 55 0 3 0   0     0   3   24 37                       61 55 0 3 0   0     0   3   24 37                 61
737723 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No 1 KG 05 2015   grade_1 83 1 3 0   4     0   5   38 58                       96 83 1 3 0   4     0   5   38 58                 96
737789 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No 1 KG 05 2015   grade_1 49 2 4 0   8     0   3   35 31                       66 49 2 4 0   8     0   3   35 31                 66
737802 MA Middlesex   school 2504320 79   Dracut 250432000582 790030 Greenmont Avenue   Regular School No 1 KG 05 2015   grade_1 48 1 3 0   2     0   1   23 32                       55 48 1 3 0   2     0   1   23 32                 55
737808 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2015   grade_1 62 9 4 0   2     0   0   37 40                       77 62 9 4 0   2     0   0   37 40                 77
737814 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 George H. Englesby Elementary School   Regular School No 1 KG 05 2015   grade_1 64 4 11 0   2     0   1   46 36                       82 64 4 11 0   2     0   1   46 36                 82
737867 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No 1 KG 04 2015   grade_1 34 2 1 0   2     0   0   20 19                       39 34 2 1 0   2     0   0   20 19                 39
737878 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2015   grade_1 29 0 2 0   0     0   2   17 16                       33 29 0 2 0   0     0   2   17 16                 33
737951 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_1 14 10 60 0   2     0   3   48 41                       89 14 10 60 0   2     0   3   48 41                 89
737966 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_1 39 11 51 0   7     0   4   55 57                       112 39 11 51 0   7     0   4   55 57                 112
737975 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_1 34 12 59 1   2     0   3   59 52                       111 34 12 59 1   2     0   3   59 52                 111
737990 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_1 33 16 42 1   3     0   1   44 52                       96 33 16 42 1   3     0   1   44 52                 96
737999 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_1 26 14 53 0   2     0   3   45 53                       98 26 14 53 0   2     0   3   45 53                 98
738020 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No 1 KG 05 2015   grade_1 64 1 8 1   1     0   0   31 44                       75 64 1 8 1   1     0   0   31 44                 75
738040 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_1 60 9 36 0   1     0   9   56 59                       115 60 9 36 0   1     0   9   56 59                 115
738046 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2015   grade_1 67 15 43 1   8     0   16   72 78                       150 67 15 43 1   8     0   16   72 78                 150
738094 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No 1 KG 05 2015   grade_1 52 1 4 0   0     0   2   29 30                       59 52 1 4 0   0     0   2   29 30                 59
738100 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Samuel Watson   Regular School No 1 KG 05 2015   grade_1 29 3 13 1   2     0   8   31 25                       56 29 3 13 1   2     0   8   31 25                 56
738140 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_1 76 0 7 3   4     0   4   45 49                       94 76 0 7 3   4     0   4   45 49                 94
738145 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_1 62 0 6 1   0     0   4   39 34                       73 62 0 6 1   0     0   4   39 34                 73
738165 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_1 52 8 48 0   4     1   11   62 62                       124 52 8 48 0   4     1   11   62 62                 124
738220 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No 1 KG 04 2015   grade_1 70 3 2 0   3     0   3   34 47                       81 70 3 2 0   3     0   3   34 47                 81
738225 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No 1 KG 04 2015   grade_1 48 1 3 0   2     0   1   39 16                       55 48 1 3 0   2     0   1   39 16                 55
738240 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_1 34 8 51 0   10     0   0   51 52                       103 34 8 51 0   10     0   0   51 52                 103
738246 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2015   grade_1 64 5 12 0   13     0   3   44 53                       97 64 5 12 0   13     0   3   44 53                 97
738252 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   grade_1 67 3 8 0   10     0   5   48 45                       93 67 3 8 0   10     0   5   48 45                 93
738258 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_1 30 3 82 0   2     0   3   60 60                       120 30 3 82 0   2     0   3   60 60                 120
738264 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2015   grade_1 77 4 10 0   4     0   5   62 38                       100 77 4 10 0   4     0   5   62 38                 100
738270 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2015   grade_1 55 4 6 0   1     0   4   36 34                       70 55 4 6 0   1     0   4   36 34                 70
738276 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_1 64 12 23 0   2     1   6   60 48                       108 64 12 23 0   2     1   6   60 48                 108
738282 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2015   grade_1 54 12 22 0   3     0   3   44 50                       94 54 12 22 0   3     0   3   44 50                 94
738302 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2015   grade_1 45 2 0 0   8     1   0   27 29                       56 45 2 0 0   8     1   0   27 29                 56
738308 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_1 65 1 0 0   2     1   0   37 32                       69 65 1 0 0   2     1   0   37 32                 69
738314 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   grade_1 53 1 1 0   0     0   1   32 24                       56 53 1 1 0   0     0   1   32 24                 56
738320 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2015   grade_1 60 1 2 0   5     0   3   35 36                       71 60 1 2 0   5     0   3   35 36                 71
738326 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   grade_1 46 0 3 1   6     0   0   33 23                       56 46 0 3 1   6     0   0   33 23                 56
738332 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   grade_1 37 1 1 0   0     0   0   20 19                       39 37 1 1 0   0     0   0   20 19                 39
738388 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2015   grade_1 49 1 10 1   1     0   3   34 31                       65 49 1 10 1   1     0   3   34 31                 65
738394 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_1 34 0 3 0   0     0   3   21 19                       40 34 0 3 0   0     0   3   21 19                 40
738401 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_1 36 0 1 0   0     0   0   25 12                       37 36 0 1 0   0     0   0   25 12                 37
738407 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_1 33 0 4 0   0     1   1   17 22                       39 33 0 4 0   0     1   1   17 22                 39
738413 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_1 39 0 0 1   1     0   2   20 23                       43 39 0 0 1   1     0   2   20 23                 43
738466 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 03 2015   grade_1 57 0 1 0   0     0   0   32 26                       58 57 0 1 0   0     0   0   32 26                 58
738470 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 03 2015   grade_1 52 1 1 0   0     0   0   23 31                       54 52 1 1 0   0     0   0   23 31                 54
738478 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 03 2015   grade_1 47 0 14 0   0     0   0   31 30                       61 47 0 14 0   0     0   0   31 30                 61
738507 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_1 76 1 1 1   0     1   0   41 39                       80 76 1 1 1   0     1   0   41 39                 80
738527 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2015   grade_1 99 0 2 0   0     0   0   51 50                       101 99 0 2 0   0     0   0   51 50                 101
738570 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   grade_1 43 3 29 0   1     0   0   36 40                       76 43 3 29 0   1     0   0   36 40                 76
738577 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No 1 KG 04 2015   grade_1 55 3 40 1   4     0   5   61 47                       108 55 3 40 1   4     0   5   61 47                 108
738582 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No 1 KG 02 2015   grade_1 61 4 24 1   1     0   0   47 44                       91 61 4 24 1   1     0   0   47 44                 91
738598 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No 1 KG 04 2015   grade_1 44 7 30 0   5     1   1   49 39                       88 44 7 30 0   5     1   1   49 39                 88
738611 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 KG 04 2015   grade_1 55 3 78 0   3     0   4   82 61                       143 55 3 78 0   3     0   4   82 61                 143
738616 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2015   grade_1 34 1 11 0   1     0   2   14 35                       49 34 1 11 0   1     0   2   14 35                 49
738623 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_1 25 1 21 1   0     0   1   25 24                       49 25 1 21 1   0     0   1   25 24                 49
738644 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2015   grade_1 80 1 3 0   4     0   3   53 38                       91 80 1 3 0   4     0   3   53 38                 91
738650 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2015   grade_1 81 0 4 0   1     0   2   41 47                       88 81 0 4 0   1     0   2   41 47                 88
738656 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2015   grade_1 83 1 1 0   2     0   1   55 33                       88 83 1 1 0   2     0   1   55 33                 88
738710 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_1 20 0 34 0   2     0   2   33 25                       58 20 0 34 0   2     0   2   33 25                 58
738734 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_1 2 1 92 0   2     0   1   50 48                       98 2 1 92 0   2     0   1   50 48                 98

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