Data source: Big Local News · About: Big Local

967 rows where grade = "grade_3", state = "MA" and year = 2019 sorted by black

View and edit SQL

year

  • 2019 · 967

grade

  • grade_3 · 967
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
2042268 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_3 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042672 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_3 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2042767 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_3 * * * *   *     *   *   2 *                       2.0                         2                   2
2043451 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_3 * * * *   *     *   *   1 *                       1.0                         1                   1
2045458 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_3 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2048846 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   grade_3 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2039829 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_3 98 0 5 0   0     0   6   57 52                       109.0 98 0 5 0   0     0   6   57 52                 109
2039844 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Benjamin J Phelps   Regular School No Elementary KG 04 2019   grade_3 56 0 2 0   2     0   0   35 25                       60.0 56 0 2 0   2     0   0   35 25                 60
2039960 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2019   grade_3 52 0 1 0   15     2   5   37 38                       75.0 52 0 1 0   15     2   5   37 38                 75
2039966 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   grade_3 52 0 3 0   5     0   4   31 33                       64.0 52 0 3 0   5     0   4   31 33                 64
2040161 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   grade_3 80 0 4 0   1     0   0   47 38                       85.0 80 0 4 0   1     0   0   47 38                 85
2040165 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_3 51 0 1 0   2     0   3   30 27                       57.0 51 0 1 0   2     0   3   30 27                 57
2040213 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2019   grade_3 88 0 3 0   0     0   4   38 57                       95.0 88 0 3 0   0     0   4   38 57                 95
2040223 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2019   grade_3 28 0 2 0   0     0   3   20 13                       33.0 28 0 2 0   0     0   3   20 13                 33
2040230 MA Essex   school 2502640 30   Beverly 250264000167 300010 Centerville Elementary   Regular School No Elementary KG 04 2019   grade_3 46 0 14 0   0     0   3   31 32                       63.0 46 0 14 0   0     0   3   31 32                 63
2040235 MA Essex   school 2502640 30   Beverly 250264000168 300015 Cove Elementary   Regular School No Elementary KG 04 2019   grade_3 59 0 10 0   2     0   5   36 40                       76.0 59 0 10 0   2     0   5   36 40                 76
2040418 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_3 4 0 4 0   0     0   2   4 6                       10.0 4 0 4 0   0     0   2   4 6                 10
2040727 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2019   grade_3 5 0 44 0   1     0   0   32 18                       50.0 5 0 44 0   1     0   0   32 18                 50
2040906 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_3 7 0 11 0   0     1   0   12 7                       19.0 7 0 11 0   0     1   0   12 7                 19
2041143 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2019   grade_3 42 0 2 0   3     0   2   24 25                       49.0 42 0 2 0   3     0   2   24 25                 49
2041205 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   grade_3 29 0 1 0   1     0   0   18 13                       31.0 29 0 1 0   1     0   0   18 13                 31
2041329 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_3 42 0 2 0   0     0   0   21 23                       44.0 42 0 2 0   0     0   0   21 23                 44
2041368 MA Middlesex   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2019   grade_3 32 0 8 0   13     0   7   37 23                       60.0 32 0 8 0   13     0   7   37 23                 60
2041426 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No Elementary KG 05 2019   grade_3 50 0 5 1   8     0   6   30 40                       70.0 50 0 5 1   8     0   6   30 40                 70
2041585 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   grade_3 52 0 2 0   3     0   3   33 27                       60.0 52 0 2 0   3     0   3   33 27                 60
2041684 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2019   grade_3 38 0 26 0   1     0   2   37 30                       67.0 38 0 26 0   1     0   2   37 30                 67
2041755 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_3 17 0 1 0   0     0   1   5 14                       19.0 17 0 1 0   0     0   1   5 14                 19
2041818 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_3 22 0 0 0   0     0   1   11 12                       23.0 22 0 0 0   0     0   1   11 12                 23
2041850 MA Essex   school 2503990 71   Danvers 250399000538 710045 Willis E Thorpe   Regular School No Elementary KG 05 2019   grade_3 42 0 2 0   1     0   0   21 24                       45.0 42 0 2 0   1     0   0   21 24                 45
2041865 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2019   grade_3 66 0 4 0   0     0   2   36 36                       72.0 66 0 4 0   0     0   2   36 36                 72
2041921 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2019   grade_3 36 0 2 0   0     0   2   15 25                       40.0 36 0 2 0   0     0   2   15 25                 40
2041929 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2019   grade_3 92 0 8 0   1     0   3   50 54                       104.0 92 0 8 0   1     0   3   50 54                 104
2041968 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 George H. Englesby Elementary School   Regular School No Elementary KG 05 2019   grade_3 69 0 12 0   5     0   2   40 48                       88.0 69 0 12 0   5     0   2   40 48                 88
2042018 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Center School   Regular School No Elementary KG 04 2019   grade_3 33 0 6 0   1     0   1   25 16                       41.0 33 0 6 0   1     0   1   25 16                 41
2042024 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2019   grade_3 34 0 6 0   2     0   1   23 20                       43.0 34 0 6 0   2     0   1   23 20                 43
2042095 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   grade_3 18 0 1 0   0     0   1   11 9                       20.0 18 0 1 0   0     0   1   11 9                 20
2042365 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_3 7 0 0 0   0     0   0   3 4                       7.0 7 0 0 0   0     0   0   3 4                 7
2042479 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2019   grade_3 55 0 1 0   7     1   1   34 31                       65.0 55 0 1 0   7     1   1   34 31                 65
2042485 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No Elementary KG 05 2019   grade_3 41 0 1 0   2     0   1   28 17                       45.0 41 0 1 0   2     0   1   28 17                 45
2042497 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2019   grade_3 34 0 1 0   0     0   1   17 19                       36.0 34 0 1 0   0     0   1   17 19                 36
2042537 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_3 98 0 4 0   2     0   0   60 44                       104.0 98 0 4 0   2     0   0   60 44                 104
2042556 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No Elementary KG 05 2019   grade_3 35 0 3 0   0     0   3   21 20                       41.0 35 0 3 0   0     0   3   21 20                 41
2042563 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No Elementary KG 05 2019   grade_3 31 0 2 0   0     0   1   18 16                       34.0 31 0 2 0   0     0   1   18 16                 34
2042569 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2019   grade_3 24 0 11 0   0     0   2   18 19                       37.0 24 0 11 0   0     0   2   18 19                 37
2042575 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2019   grade_3 52 0 4 0   0     0   5   33 28                       61.0 52 0 4 0   0     0   5   33 28                 61
2042593 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_3 85 0 5 0   13     1   8   58 54                       112.0 85 0 5 0   13     1   8   58 54                 112
2042613 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2019   grade_3 45 0 7 1   1     0   2   31 25                       56.0 45 0 7 1   1     0   2   31 25                 56
2042632 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No Elementary KG 04 2019   grade_3 45 0 6 0   0     0   0   30 21                       51.0 45 0 6 0   0     0   0   30 21                 51
2042652 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2019   grade_3 26 0 5 0   1     1   2   21 14                       35.0 26 0 5 0   1     1   2   21 14                 35
2042684 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No Elementary 03 04 2019   grade_3 111 0 3 0   5     0   1   52 68                       120.0 111 0 3 0   5     0   1   52 68                 120
2042713 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_3 24 0 2 0   1     0   1   16 12                       28.0 24 0 2 0   1     0   1   16 12                 28
2042902 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_3 2 0 70 0   0     0   1   38 35                       73.0 2 0 70 0   0     0   1   38 35                 73
2042911 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 05 2019   grade_3 7 0 47 0   0     0   1   37 18                       55.0 7 0 47 0   0     0   1   37 18                 55
2042989 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No Elementary PK 04 2019   grade_3 62 0 13 0   5     0   2   34 48                       82.0 62 0 13 0   5     0   2   34 48                 82
2043003 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No Elementary PK 05 2019   grade_3 48 0 4 0   3     0   1   31 25                       56.0 48 0 4 0   3     0   1   31 25                 56
2043018 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No Elementary PK 05 2019   grade_3 55 0 5 0   0     0   2   31 31                       62.0 55 0 5 0   0     0   2   31 31                 62
2043040 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2019   grade_3 159 0 4 1   0     0   0   84 80                       164.0 159 0 4 1   0     0   0   84 80                 164
2043099 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_3 4 0 84 0   0     0   0   39 49                       88.0 4 0 84 0   0     0   0   39 49                 88
2043108 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary PK 04 2019   grade_3 7 0 126 0   2     0   1   68 68                       136.0 7 0 126 0   2     0   1   68 68                 136
2043112 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_3 2 0 76 0   0     0   0   48 30                       78.0 2 0 76 0   0     0   0   48 30                 78
2043118 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_3 1 0 71 0   0     0   2   34 40                       74.0 1 0 71 0   0     0   2   34 40                 74
2043157 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No Elementary PK 06 2019   grade_3 45 0 3 0   0     0   1   29 20                       49.0 45 0 3 0   0     0   1   29 20                 49
2043186 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No Elementary PK 05 2019   grade_3 44 0 3 0   3     0   5   29 26                       55.0 44 0 3 0   3     0   5   29 26                 55
2043245 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_3 13 0 1 0   0     0   1   10 5                       15.0 13 0 1 0   0     0   1   10 5                 15
2043614 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lincoln-Thomson   Regular School No Elementary KG 05 2019   grade_3 8 0 21 0   3     0   2   18 16                       34.0 8 0 21 0   3     0   2   18 16                 34
2043773 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 03 2019   grade_3 61 0 4 0   1     1   5   39 33                       72.0 61 0 4 0   1     1   5   39 33                 72
2043825 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No Elementary KG 05 2019   grade_3 40 0 0 0   0     0   1   26 15                       41.0 40 0 0 0   0     0   1   26 15                 41
2043831 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 South River   Regular School No Elementary KG 05 2019   grade_3 45 0 3 0   0     0   1   26 23                       49.0 45 0 3 0   0     0   1   26 23                 49
2043838 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No Elementary PK 05 2019   grade_3 51 0 2 1   1     1   2   26 32                       58.0 51 0 2 1   1     1   2   26 32                 58
2043845 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No Elementary PK 05 2019   grade_3 75 0 1 0   0     0   1   29 48                       77.0 75 0 1 0   0     0   1   29 48                 77
2043852 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No Elementary PK 05 2019   grade_3 42 0 3 0   2     0   1   18 30                       48.0 42 0 3 0   2     0   1   18 30                 48
2043888 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2019   grade_3 85 0 13 0   1     0   6   54 51                       105.0 85 0 13 0   1     0   6   54 51                 105
2043998 MA Middlesex   school 2507620 178   Melrose 250762001198 1780050 Winthrop   Regular School No Elementary KG 05 2019   grade_3 62 0 1 0   0     0   5   34 34                       68.0 62 0 1 0   0     0   5   34 34                 68
2044013 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_3 72 0 40 0   3     0   6   63 58                       121.0 72 0 40 0   3     0   6   63 58                 121
2044182 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_3 21 0 0 0   0     0   0   9 12                       21.0 21 0 0 0   0     0   0   9 12                 21
2044213 MA Middlesex   school 2508340 198   Natick 250834001298 1980031 Johnson   Regular School No Elementary KG 04 2019   grade_3 37 0 4 0   2     0   3   25 21                       46.0 37 0 4 0   2     0   3   25 21                 46
2044259 MA Norfolk   school 2508370 199   Needham 250837001317 1990040 William Mitchell   Regular School No Elementary KG 05 2019   grade_3 74 0 4 0   9     0   7   41 53                       94.0 74 0 4 0   9     0   7   41 53                 94
2044379 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2019   grade_3 15 0 10 0   0     0   1   13 13                       26.0 15 0 10 0   0     0   1   13 13                 26
2044476 MA Middlesex   school 2508610 207   Newton 250861001366 2070055 Franklin   Regular School No Elementary KG 05 2019   grade_3 41 0 8 0   9     0   3   31 30                       61.0 41 0 8 0   9     0   3   31 30                 61
2044494 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2019   grade_3 68 0 4 0   13     0   7   44 48                       92.0 68 0 4 0   13     0   7   44 48                 92
2044513 MA Middlesex   school 2508610 207   Newton 250861001379 2070115 Underwood   Regular School No Elementary KG 05 2019   grade_3 28 0 3 0   10     0   4   20 25                       45.0 28 0 3 0   10     0   4   20 25                 45
2044519 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 John Ward   Regular School No Elementary KG 05 2019   grade_3 37 0 2 0   8     0   4   26 25                       51.0 37 0 2 0   8     0   4   26 25                 51
2044555 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2019   grade_3 136 0 7 0   2     0   4   82 67                       149.0 136 0 7 0   2     0   4   82 67                 149
2044575 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary PK 06 2019   grade_3 29 0 3 0   0     0   1   15 18                       33.0 29 0 3 0   0     0   1   15 18                 33
2044598 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Bridge Street   Regular School No Elementary PK 05 2019   grade_3 16 0 10 0   2     0   2   15 15                       30.0 16 0 10 0   2     0   2   15 15                 30
2044642 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2019   grade_3 35 0 3 0   2     0   1   25 16                       41.0 35 0 3 0   2     0   1   25 16                 41
2044647 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_3 79 0 4 0   6     0   5   36 58                       94.0 79 0 4 0   6     0   5   36 58                 94
2044652 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2019   grade_3 47 0 10 0   3     0   3   32 31                       63.0 47 0 10 0   3     0   3   32 31                 63
2044703 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No Elementary KG 05 2019   grade_3 38 0 0 1   6     1   2   21 27                       48.0 38 0 0 1   6     1   2   21 27                 48
2044746 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_3 32 0 2 0   0     0   0   18 16                       34.0 32 0 2 0   0     0   0   18 16                 34
2044766 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No Elementary KG 05 2019   grade_3 60 0 6 0   5     0   6   47 30                       77.0 60 0 6 0   5     0   6   47 30                 77
2044791 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2019   grade_3 85 0 3 0   2     0   7   55 42                       97.0 85 0 3 0   2     0   7   55 42                 97
2044813 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No Elementary PK 05 2019   grade_3 78 0 2 0   4     0   2   45 41                       86.0 78 0 2 0   4     0   2   45 41                 86
2044868 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2019   grade_3 65 0 8 0   1     0   4   34 44                       78.0 65 0 8 0   1     0   4   34 44                 78
2044879 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2019   grade_3 30 0 5 0   1     0   2   17 21                       38.0 30 0 5 0   1     0   2   17 21                 38
2044965 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No Elementary PK 05 2019   grade_3 37 0 2 0   0     0   0   24 15                       39.0 37 0 2 0   0     0   0   24 15                 39
2044979 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2019   grade_3 13 0 4 0   0     0   1   8 10                       18.0 13 0 4 0   0     0   1   8 10                 18
2044986 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2019   grade_3 70 0 0 0   1     0   4   42 33                       75.0 70 0 0 0   1     0   4   42 33                 75
2044993 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2019   grade_3 71 0 0 0   1     0   0   40 32                       72.0 71 0 0 0   1     0   0   40 32                 72
2045015 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_3 12 0 0 0   0     0   1   10 3                       13.0 12 0 0 0   0     0   1   10 3                 13

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