enrollments

Data source: Big Local News · About: Big Local

6,787 rows where grade = "grade_3" and state = "MA"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_3 · 6,587 ✖
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
737581 737581 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2015   grade_3 11 4 43 0   0     0   3   32 29                       61 11 4 43 0   0     0   3   32 29                 61
737603 737603 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_3 16 0 0 0   0     0   0   8 8                       16 16 0 0 0   0     0   0   8 8                 16
737613 737613 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2015   grade_3 112 2 35 0   1     0   0   77 73                       150 112 2 35 0   1     0   0   77 73                 150
737625 737625 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No 1 03 05 2015   grade_3 109 3 2 0   3     0   0   66 51                       117 109 3 2 0   3     0   0   66 51                 117
737643 737643 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2015   grade_3 48 6 6 1   5     0   7   29 44                       73 48 6 6 1   5     0   7   29 44                 73
737650 737650 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No 1 PK 05 2015   grade_3 65 5 4 0   4     0   10   43 45                       88 65 5 4 0   4     0   10   43 45                 88
737656 737656 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No 1 PK 05 2015   grade_3 65 2 8 0   4     0   1   40 40                       80 65 2 8 0   4     0   1   40 40                 80
737666 737666 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   grade_3 22 0 0 0   1     0   1   13 11                       24 22 0 0 0   1     0   1   13 11                 24
737673 737673 MA Essex   school 2503990 71   Danvers 250399000532 710010 Highlands   Regular School No 1 KG 05 2015   grade_3 51 1 4 1   4     0   4   30 35                       65 51 1 4 1   4     0   4   30 35                 65
737679 737679 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No 1 KG 05 2015   grade_3 46 2 3 0   0     0   2   24 29                       53 46 2 3 0   0     0   2   24 29                 53
737686 737686 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No 1 PK 05 2015   grade_3 30 2 1 0   0     0   1   14 20                       34 30 2 1 0   0     0   1   14 20                 34
737692 737692 MA Essex   school 2503990 71   Danvers 250399000534 710032 Ivan G Smith   Regular School No 1 KG 05 2015   grade_3 56 1 5 0   4     0   0   41 25                       66 56 1 5 0   4     0   0   41 25                 66
737698 737698 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No 1 KG 05 2015   grade_3 58 0 5 0   2     0   0   36 29                       65 58 0 5 0   2     0   0   36 29                 65
737713 737713 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2015   grade_3 80 0 3 0   2     0   4   45 44                       89 80 0 3 0   2     0   4   45 44                 89
737719 737719 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No 1 KG 05 2015   grade_3 63 3 2 0   2     0   1   37 34                       71 63 3 2 0   2     0   1   37 34                 71
737725 737725 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No 1 KG 05 2015   grade_3 98 2 4 0   4     0   2   64 46                       110 98 2 4 0   4     0   2   64 46                 110
737741 737741 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2015   grade_3 35 4 11 0   3     0   3   31 25                       56 35 4 11 0   3     0   3   31 25                 56
737746 737746 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2015   grade_3 49 1 3 0   1     0   1   33 22                       55 49 1 3 0   1     0   1   33 22                 55
737751 737751 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No 1 01 05 2015   grade_3 45 5 6 0   1     0   2   27 32                       59 45 5 6 0   1     0   2   27 32                 59
737756 737756 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2015   grade_3 31 0 1 0   2     0   0   20 14                       34 31 0 1 0   2     0   0   20 14                 34
737770 737770 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2015   grade_3 51 0 3 0   2     0   4   33 27                       60 51 0 3 0   2     0   4   33 27                 60
737778 737778 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2015   grade_3 122 1 4 0   2     0   5   80 54                       134 122 1 4 0   2     0   5   80 54                 134
737791 737791 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No 1 KG 05 2015   grade_3 66 1 5 0   6     0   3   48 33                       81 66 1 5 0   6     0   3   48 33                 81
737798 737798 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No 1 PK 05 2015   grade_3 76 3 5 0   4     0   1   47 42                       89 76 3 5 0   4     0   1   47 42                 89
737804 737804 MA Middlesex   school 2504320 79   Dracut 250432000582 790030 Greenmont Avenue   Regular School No 1 KG 05 2015   grade_3 34 3 1 0   3     0   1   18 24                       42 34 3 1 0   3     0   1   18 24                 42
737810 737810 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2015   grade_3 62 5 5 1   7     0   0   32 48                       80 62 5 5 1   7     0   0   32 48                 80
737816 737816 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 George H. Englesby Elementary School   Regular School No 1 KG 05 2015   grade_3 62 0 6 0   8     0   2   43 35                       78 62 0 6 0   8     0   2   43 35                 78
737831 737831 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No 1 03 05 2015   grade_3 204 1 3 0   6     0   10   111 113                       224 204 1 3 0   6     0   10   111 113                 224
737849 737849 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2015   grade_3 148 2 4 0   1     0   6   86 75                       161 148 2 4 0   1     0   6   86 75                 161
737863 737863 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_3 20 2 0 0   1     0   0   13 10                       23 20 2 0 0   1     0   0   13 10                 23
737869 737869 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No 1 KG 04 2015   grade_3 41 0 2 0   1     0   0   20 24                       44 41 0 2 0   1     0   0   20 24                 44
737875 737875 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No 1 PK 04 2015   grade_3 33 0 3 0   5     0   0   17 24                       41 33 0 3 0   5     0   0   17 24                 41
737880 737880 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Neil A Pepin   Regular School No 1 KG 04 2015   grade_3 19 0 2 0   0     0   1   8 14                       22 19 0 2 0   0     0   1   8 14                 22
737891 737891 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No 1 03 05 2015   grade_3 76 2 4 0   2     0   0   40 44                       84 76 2 4 0   2     0   0   40 44                 84
737898 737898 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No 1 03 05 2015   grade_3 86 1 5 0   1     0   2   50 45                       95 86 1 5 0   1     0   2   50 45                 95
737921 737921 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson - Olmsted School   Regular School No 1 03 05 2015   grade_3 240 10 8 0   10     0   4   140 132                       272 240 10 8 0   10     0   4   140 132                 272
737935 737935 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_3 33 3 5 0   0     0   0   19 22                       41 33 3 5 0   0     0   0   19 22                 41
737945 737945 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   grade_3 18 0 1 0   0     0   2   12 9                       21 18 0 1 0   0     0   2   12 9                 21
737953 737953 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_3 17 7 44 2   6     0   3   35 44                       79 17 7 44 2   6     0   3   35 44                 79
737963 737963 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No 1 PK 04 2015   grade_3 10 5 16 0   1     0   2   13 21                       34 10 5 16 0   1     0   2   13 21                 34
737968 737968 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_3 52 10 38 2   8     1   3   59 55                       114 52 10 38 2   8     1   3   59 55                 114
737977 737977 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_3 33 18 51 0   10     0   1   61 52                       113 33 18 51 0   10     0   1   61 52                 113
737992 737992 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_3 27 21 40 1   6     0   5   46 54                       100 27 21 40 1   6     0   5   46 54                 100
738001 738001 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_3 17 18 54 0   1     0   3   46 47                       93 17 18 54 0   1     0   3   46 47                 93
738016 738016 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No 1 PK 05 2015   grade_3 58 0 1 0   1     0   1   33 28                       61 58 0 1 0   1     0   1   33 28                 61
738022 738022 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No 1 KG 05 2015   grade_3 72 1 6 0   3     0   4   46 40                       86 72 1 6 0   3     0   4   46 40                 86
738036 738036 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2015   grade_3 75 7 22 0   7     0   14   62 63                       125 75 7 22 0   7     0   14   62 63                 125
738042 738042 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   grade_3 60 9 20 0   4     0   11   54 50                       104 60 9 20 0   4     0   11   54 50                 104
738048 738048 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2015   grade_3 68 10 37 0   8     0   16   77 62                       139 68 10 37 0   8     0   16   77 62                 139
738055 738055 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2015   grade_3 34 5 31 0   4     0   4   44 34                       78 34 5 31 0   4     0   4   44 34                 78
738062 738062 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 06 2015   grade_3 23 6 17 0   5     0   4   34 21                       55 23 6 17 0   5     0   4   34 21                 55
738070 738070 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_3 31 6 13 1   3     0   7   35 26                       61 31 6 13 1   3     0   7   35 26                 61
738076 738076 MA Bristol   school 2504830 95   Fall River 250483000276 950055 ACESE   Alternative Education School No 1 03 05 2015   grade_3 * * * *   *     *   *   1 *                       2                         1                   2
738083 738083 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2015   grade_3 79 8 19 0   11     0   9   71 55                       126 79 8 19 0   11     0   9   71 55                 126
738090 738090 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No 1 PK 05 2015   grade_3 54 6 9 0   8     0   4   46 35                       81 54 6 9 0   8     0   4   46 35                 81
738096 738096 MA Bristol   school 2504830 95   Fall River 250483000665 950140 James Tansey   Regular School No 1 KG 05 2015   grade_3 40 1 5 0   0     0   4   24 26                       50 40 1 5 0   0     0   4   24 26                 50
738102 738102 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Samuel Watson   Regular School No 1 KG 05 2015   grade_3 18 3 9 0   1     0   5   14 22                       36 18 3 9 0   1     0   5   14 22                 36
738131 738131 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   grade_3 43 2 0 1   0     0   1   27 20                       47 43 2 0 1   0     0   1   27 20                 47
738137 738137 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_3 51 3 6 1   0     0   4   36 29                       65 51 3 6 1   0     0   4   36 29                 65
738142 738142 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_3 65 8 11 0   4     0   6   42 52                       94 65 8 11 0   4     0   6   42 52                 94
738147 738147 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_3 55 4 3 1   0     0   5   31 37                       68 55 4 3 1   0     0   5   31 37                 68
738162 738162 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_3 22 1 57 1   1     0   7   52 37                       89 22 1 57 1   1     0   7   52 37                 89
738167 738167 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   grade_3 61 10 54 0   4     0   10   71 68                       139 61 10 54 0   4     0   10   71 68                 139
738177 738177 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   grade_3 37 7 54 0   12     0   9   61 58                       119 37 7 54 0   12     0   9   61 58                 119
738187 738187 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_3 19 2 27 0   5     0   4   34 23                       57 19 2 27 0   5     0   4   34 23                 57
738207 738207 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_3 8 0 0 0   0     1   0   3 6                       9 8 0 0 0   0     1   0   3 6                 9
738217 738217 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2015   grade_3 44 1 2 0   1     0   0   27 21                       48 44 1 2 0   1     0   0   27 21                 48
738222 738222 MA Norfolk   school 2504950 99   Foxborough 250495000724 990020 Vincent M Igo Elementary   Regular School No 1 KG 04 2015   grade_3 74 8 3 0   4     0   1   51 39                       90 74 8 3 0   4     0   1   51 39                 90
738227 738227 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No 1 KG 04 2015   grade_3 52 2 3 0   1     0   1   26 33                       59 52 2 3 0   1     0   1   26 33                 59
738242 738242 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_3 30 9 48 0   2     0   4   54 39                       93 30 9 48 0   2     0   4   54 39                 93
738248 738248 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2015   grade_3 61 4 6 0   10     0   4   51 34                       85 61 4 6 0   10     0   4   51 34                 85
738254 738254 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   grade_3 75 0 3 0   10     0   2   47 43                       90 75 0 3 0   10     0   2   47 43                 90
738260 738260 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_3 24 1 87 0   0     0   1   52 61                       113 24 1 87 0   0     0   1   52 61                 113
738266 738266 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2015   grade_3 74 1 5 0   4     0   2   46 40                       86 74 1 5 0   4     0   2   46 40                 86
738272 738272 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2015   grade_3 58 3 16 0   7     0   6   49 41                       90 58 3 16 0   7     0   6   49 41                 90
738278 738278 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_3 62 10 23 0   2     0   7   53 51                       104 62 10 23 0   2     0   7   53 51                 104
738284 738284 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2015   grade_3 61 8 8 0   1     0   3   44 37                       81 61 8 8 0   1     0   3   44 37                 81
738304 738304 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2015   grade_3 54 1 1 0   3     0   1   33 27                       60 54 1 1 0   3     0   1   33 27                 60
738310 738310 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_3 57 1 0 0   1     1   1   30 31                       61 57 1 0 0   1     1   1   30 31                 61
738316 738316 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   grade_3 64 2 0 0   6     0   2   35 39                       74 64 2 0 0   6     0   2   35 39                 74
738322 738322 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2015   grade_3 75 2 3 0   3     0   1   42 42                       84 75 2 3 0   3     0   1   42 42                 84
738328 738328 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   grade_3 76 2 4 0   4     0   3   44 45                       89 76 2 4 0   4     0   3   44 45                 89
738334 738334 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   grade_3 60 1 1 0   1     1   2   33 33                       66 60 1 1 0   1     1   2   33 33                 66
738351 738351 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 03 05 2015   grade_3 115 4 14 0   1     0   10   74 70                       144 115 4 14 0   1     0   10   74 70                 144
738356 738356 MA Worcester   school 2505130 103   Gardner 250513002470 1030015 Helen Mae Sauter Elementary   Regular School No 1 01 03 2015   grade_3 46 1 12 0   2     0   7   34 34                       68 46 1 12 0   2     0   7   34 34                 68
738377 738377 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 02 05 2015   grade_3 93 0 2 0   1     0   0   53 43                       96 93 0 2 0   1     0   0   53 43                 96
738390 738390 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2015   grade_3 41 2 6 0   4     0   2   33 22                       55 41 2 6 0   4     0   2   33 22                 55
738396 738396 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_3 42 1 1 0   0     0   1   20 25                       45 42 1 1 0   0     0   1   20 25                 45
738403 738403 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_3 33 0 1 0   0     0   0   17 17                       34 33 0 1 0   0     0   0   17 17                 34
738409 738409 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_3 43 1 1 0   0     0   0   21 24                       45 43 1 1 0   0     0   0   21 24                 45
738415 738415 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_3 55 3 4 0   0     0   0   33 29                       62 55 3 4 0   0     0   0   33 29                 62
738434 738434 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_3 84 0 4 1   7     2   3   56 45                       101 84 0 4 1   7     2   3   56 45                 101
738439 738439 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_3 96 3 7 0   24     0   5   72 63                       135 96 3 7 0   24     0   5   72 63                 135
738457 738457 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2015   grade_3 62 0 5 0   1     0   1   34 35                       69 62 0 5 0   1     0   1   34 35                 69
738468 738468 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 03 2015   grade_3 39 0 3 0   2     0   1   24 21                       45 39 0 3 0   2     0   1   24 21                 45
738472 738472 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 03 2015   grade_3 55 0 4 0   0     0   0   34 25                       59 55 0 4 0   0     0   0   34 25                 59
738480 738480 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 03 2015   grade_3 40 1 7 0   2     0   0   21 29                       50 40 1 7 0   2     0   0   21 29                 50
738495 738495 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_3 42 2 3 0   1     3   4   28 27                       55 42 2 3 0   1     3   4   28 27                 55
738509 738509 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_3 64 1 1 0   2     0   1   41 28                       69 64 1 1 0   2     0   1   41 28                 69
738517 738517 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_3 * * * *   *     *   *   2 2                       4                         2 2                 4

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