enrollments

Data source: Big Local News · About: Big Local

6,787 rows where grade = "grade_3" and state = "MA" sorted by asian descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_3 · 6,787 ✖
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
741555 741555 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_3 94 9 12 1   93     0   8   112 105                       217 94 9 12 1   93     0   8   112 105                 217
1128870 1128870 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2017   grade_3 96 1 11 1   93     0   7   100 109                       209 96 1 11 1   93     0   7   100 109                 209
2235691 2235691 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury: Floral Street School   Regular School No Elementary 01 04 2018   grade_3 71 7 11 2   93     0   8   103 89                       192.0 71 7 11 2   93     0   8   103 89                 192
1675128 1675128 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton - Elmwood   Regular School No Elementary 02 03 2021   grade_3 150 2 14 0   90     0   16   138 134 *                     272.0 150 2 14 0   90     0   16   138 134                 272
735789 735789 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No 1 PK 05 2015   grade_3 100 4 7 0   9     0   5   65 60                       125 100 4 7 0   9     0   5   65 60                 125
735884 735884 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2015   grade_3 61 7 15 0   9     0   6   50 48                       98 61 7 15 0   9     0   6   50 48                 98
736043 736043 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_3 45 2 8 0   9     0   7   33 38                       71 45 2 8 0   9     0   7   33 38                 71
736054 736054 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_3 94 4 8 0   9     0   6   69 52                       121 94 4 8 0   9     0   6   69 52                 121
737013 737013 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No 1 KG 05 2015   grade_3 49 1 4 0   9     0   1   33 31                       64 49 1 4 0   9     0   1   33 31                 64
737018 737018 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2015   grade_3 56 2 2 0   9     0   1   26 44                       70 56 2 2 0   9     0   1   26 44                 70
737278 737278 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No 1 KG 05 2015   grade_3 49 5 2 1   9     0   1   34 33                       67 49 5 2 1   9     0   1   34 33                 67
738692 738692 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No 1 03 05 2015   grade_3 194 2 13 0   9     0   2   106 114                       220 194 2 13 0   9     0   2   106 114                 220
738918 738918 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2015   grade_3 12 3 93 0   9     0   1   52 66                       118 12 3 93 0   9     0   1   52 66                 118
739272 739272 MA Middlesex   school 2507020 160   Lowell 250702000068 1600027 Moody Elementary   Regular School No 1 PK 04 2015   grade_3 29 6 17 0   9     0   0   31 30                       61 29 6 17 0   9     0   0   31 30                 61
739426 739426 MA Essex   school 2507110 163   Lynn 250711001077 1630030 Julia F Callahan   Regular School No 1 PK 05 2015   grade_3 16 17 42 0   9     0   3   52 35                       87 16 17 42 0   9     0   3   52 35                 87
739432 739432 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No 1 KG 05 2015   grade_3 4 15 79 0   9     0   3   61 49                       110 4 15 79 0   9     0   3   61 49                 110
739671 739671 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No 1 KG 04 2015   grade_3 72 6 44 0   9     0   6   64 73                       137 72 6 44 0   9     0   6   64 73                 137
740327 740327 MA Middlesex   school 2508610 207   Newton 250861001360 2070025 Cabot   Regular School No 1 KG 05 2015   grade_3 50 3 6 0   9     0   2   32 38                       70 50 3 6 0   9     0   2   32 38                 70
742576 742576 MA Norfolk   school 2512270 317   Wellesley 251227002023 3170020 John D Hardy   Regular School No 1 KG 05 2015   grade_3 43 4 4 0   9     0   0   21 39                       60 43 4 4 0   9     0   0   21 39                 60
742776 742776 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No 1 PK 03 2015   grade_3 61 6 3 0   9     0   0   43 36                       79 61 6 3 0   9     0   0   43 36                 79
742859 742859 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Martha Jones   Regular School No 1 KG 05 2015   grade_3 43 0 2 0   9     0   1   28 27                       55 43 0 2 0   9     0   1   28 27                 55
743104 743104 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   grade_3 5 18 32 2   9     0   3   33 36                       69 5 18 32 2   9     0   3   33 36                 69
743119 743119 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_3 7 11 70 0   9     0   3   48 52                       100 7 11 70 0   9     0   3   48 52                 100
743173 743173 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   grade_3 8 5 26 0   9     0   3   28 23                       51 8 5 26 0   9     0   3   28 23                 51
743287 743287 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2015   grade_3 37 14 45 0   9     0   3   41 67                       108 37 14 45 0   9     0   3   41 67                 108
743631 743631 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_3 36 1 2 1   9     0   1   22 28                       50 36 1 2 1   9     0   1   22 28                 50
744595 744595 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_3 50 0 1 0   9     0   1   32 29                       61 50 0 1 0   9     0   1   32 29                 61
933983 933983 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_3 19 73 18 1   9     0   4   68 56                       124 19 73 18 1   9     0   4   68 56                 124
934138 934138 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No 1 KG 05 2016   grade_3 50 3 1 0   9     0   6   34 35                       69 50 3 1 0   9     0   6   34 35                 69
934321 934321 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No 1 KG 04 2016   grade_3 69 0 5 0   9     0   3   51 35                       86 69 0 5 0   9     0   3   51 35                 86
935031 935031 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2016   grade_3 38 6 60 0   9     1   9   62 61                       123 38 6 60 0   9     1   9   62 61                 123
935041 935041 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_3 20 2 28 0   9     0   13   36 36                       72 20 2 28 0   9     0   13   36 36                 72
936390 936390 MA Essex   school 2507140 164   Lynnfield 250714001089 1640010 Huckleberry Hill   Regular School No 1 KG 04 2016   grade_3 64 1 3 0   9     0   2   38 41                       79 64 1 3 0   9     0   2   38 41                 79
936840 936840 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No 1 PK 05 2016   grade_3 84 1 1 0   9     0   0   50 45                       95 84 1 1 0   9     0   0   50 45                 95
937329 937329 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No 1 PK 05 2016   grade_3 49 5 11 0   9     0   3   40 37                       77 49 5 11 0   9     0   3   40 37                 77
937405 937405 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Lincoln Street   Regular School No 1 KG 05 2016   grade_3 40 0 0 1   9     0   1   26 25                       51 40 0 0 1   9     0   1   26 25                 51
937545 937545 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No 1 KG 05 2016   grade_3 36 3 3 0   9     0   1   21 31                       52 36 3 3 0   9     0   1   21 31                 52
938443 938443 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2016   grade_3 33 3 46 0   9     0   2   51 42                       93 33 3 46 0   9     0   2   51 42                 93
939116 939116 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No 1 PK 05 2016   grade_3 93 6 6 0   9     0   1   60 55                       115 93 6 6 0   9     0   1   60 55                 115
939312 939312 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No 1 PK 05 2016   grade_3 71 4 7 2   9     0   4   53 44                       97 71 4 7 2   9     0   4   53 44                 97
939344 939344 MA Middlesex   school 2512210 315   Wayland 251221000153 3150020 Loker School   Regular School No 1 KG 05 2016   grade_3 33 4 2 0   9     0   2   24 26                       50 33 4 2 0   9     0   2   24 26                 50
939895 939895 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No 1 KG 05 2016   grade_3 13 2 6 1   9     0   1   15 17                       32 13 2 6 1   9     0   1   15 17                 32
939950 939950 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2016   grade_3 10 10 46 0   9     0   3   37 41                       78 10 10 46 0   9     0   3   37 41                 78
940669 940669 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_3 13 48 18 2   9     1   1   46 46                       92 13 48 18 2   9     1   1   46 46                 92
1122604 1122604 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2017   grade_3 7 32 36 0   9     0   0   42 42                       84 7 32 36 0   9     0   0   42 42                 84
1123627 1123627 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2017   grade_3 40 52 7 1   9     0   6   66 49                       115 40 52 7 1   9     0   6   66 49                 115
1123827 1123827 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No Elementary KG 05 2017   grade_3 43 6 1 0   9     0   3   30 32                       62 43 6 1 0   9     0   3   30 32                 62
1123894 1123894 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2017   grade_3 13 12 3 0   9     0   7   22 22                       44 13 12 3 0   9     0   7   22 22                 44
1124057 1124057 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2017   grade_3 93 2 4 2   9     0   3   70 43                       113 93 2 4 2   9     0   3   70 43                 113
1125960 1125960 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2017   grade_3 47 10 43 0   9     0   6   57 58                       115 47 10 43 0   9     0   6   57 58                 115
1126178 1126178 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2017   grade_3 17 3 21 0   9     0   3   32 21                       53 17 3 21 0   9     0   3   32 21                 53
1126672 1126672 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No Elementary KG 04 2017   grade_3 62 4 83 0   9     0   2   85 75                       160 62 4 83 0   9     0   2   85 75                 160
1127200 1127200 MA Norfolk   school 2508370 199   Needham 250837001313 1990035 Hillside Elementary   Regular School No Elementary KG 05 2017   grade_3 58 5 9 0   9     0   6   40 47                       87 58 5 9 0   9     0   6   40 47                 87
1127421 1127421 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   grade_3 54 2 4 0   9     0   2   34 37                       71 54 2 4 0   9     0   2   34 37                 71
1127477 1127477 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2017   grade_3 77 0 3 0   9     0   4   52 41                       93 77 0 3 0   9     0   4   52 41                 93
1127638 1127638 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary PK 05 2017   grade_3 40 6 13 0   9     0   4   36 36                       72 40 6 13 0   9     0   4   36 36                 72
1127750 1127750 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No Elementary PK 05 2017   grade_3 26 1 6 0   9     0   1   19 24                       43 26 1 6 0   9     0   1   19 24                 43
1129915 1129915 MA Middlesex   school 2512000 308   Waltham 251200001974 3080040 Northeast Elementary School   Regular School No Elementary PK 05 2017   grade_3 29 11 20 1   9     0   3   45 28                       73 29 11 20 1   9     0   3   45 28                 73
1130029 1130029 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2017   grade_3 55 6 10 0   9     0   7   45 42                       87 55 6 10 0   9     0   7   45 42                 87
1130499 1130499 MA Norfolk   school 2512840 336   Weymouth 251284002120 3360105 Thomas W. Hamilton Primary School   Regular School No Elementary KG 04 2017   grade_3 52 3 10 1   9     0   2   35 42                       77 52 3 10 1   9     0   2   35 42                 77
1130840 1130840 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2017   grade_3 14 10 35 0   9     0   2   41 29                       70 14 10 35 0   9     0   2   41 29                 70
1131304 1131304 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_3 22 44 46 0   9     0   7   63 65                       128 22 44 46 0   9     0   7   63 65                 128
1364888 1364888 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_3 67 1 6 0   9     0   7   54 36 *                     90.0 67 1 6 0   9     0   7   54 36                 90
1364907 1364907 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2020   grade_3 70 0 2 0   9     0   0   43 38 *                     81.0 70 0 2 0   9     0   0   43 38                 81
1365311 1365311 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2020   grade_3 6 18 28 1   9     0   0   30 32 *                     62.0 6 18 28 1   9     0   0   30 32                 62
1365586 1365586 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2020   grade_3 9 12 17 0   9     0   1   26 22 *                     48.0 9 12 17 0   9     0   1   26 22                 48
1365879 1365879 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_3 15 23 17 0   9     0   4   41 27 *                     68.0 15 23 17 0   9     0   4   41 27                 68
1366555 1366555 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   grade_3 71 4 5 0   9     0   2   43 48 *                     91.0 71 4 5 0   9     0   2   43 48                 91
1368301 1368301 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No Elementary PK 04 2020   grade_3 28 6 40 0   9     0   3   42 44 *                     86.0 28 6 40 0   9     0   3   42 44                 86
1368340 1368340 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary PK 04 2020   grade_3 42 0 32 0   9     1   2   35 51 *                     86.0 42 0 32 0   9     1   2   35 51                 86
1368532 1368532 MA Essex   school 2507110 163   Lynn 250711001074 1630055 Hood   Regular School No Elementary PK 05 2020   grade_3 14 5 58 0   9     0   1   50 37 *                     87.0 14 5 58 0   9     0   1   50 37                 87
1369195 1369195 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Newman Elementary   Regular School No Elementary PK 05 2020   grade_3 77 1 2 0   9     0   8   52 45 *                     97.0 77 1 2 0   9     0   8   52 45                 97
1369574 1369574 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2020   grade_3 65 2 7 0   9     0   3   52 34 *                     86.0 65 2 7 0   9     0   3   52 34                 86
1369592 1369592 MA Bristol   school 2508730 212   North Attleborough 250873001401 2120007 Amvet Boulevard   Regular School No Elementary KG 05 2020   grade_3 45 4 4 0   9     0   2   32 32 *                     64.0 45 4 4 0   9     0   2   32 32                 64
1369648 1369648 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No Elementary KG 05 2020   grade_3 32 0 2 0   9     0   1   23 21 *                     44.0 32 0 2 0   9     0   1   23 21                 44
1371886 1371886 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No Elementary KG 05 2020   grade_3 21 0 1 0   9     0   1   17 15 *                     32.0 21 0 1 0   9     0   1   17 15                 32
1371945 1371945 MA Norfolk   school 2512840 336   Weymouth 251284002120 3360105 Thomas W. Hamilton Primary School   Regular School No Elementary KG 04 2020   grade_3 39 3 11 0   9     0   7   38 31 *                     69.0 39 3 11 0   9     0   7   38 31                 69
1372084 1372084 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Linscott-Rumford   Regular School No Elementary KG 05 2020   grade_3 20 3 2 0   9     0   1   18 17 *                     35.0 20 3 2 0   9     0   1   18 17                 35
1672156 1672156 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_3 36 3 0 0   9     0   7   31 24 *                     55.0 36 3 0 0   9     0   7   31 24                 55
1672806 1672806 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_3 30 2 5 0   9     0   2   28 20 *                     48.0 30 2 5 0   9     0   2   28 20                 48
1673589 1673589 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Burlington - Memorial   Regular School No Elementary KG 05 2021   grade_3 39 4 8 0   9     0   3   27 36 *                     63.0 39 4 8 0   9     0   3   27 36                 63
1673595 1673595 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Burlington - Pine Glen Elementary   Regular School No Elementary KG 05 2021   grade_3 30 1 1 0   9     0   4   25 20 *                     45.0 30 1 1 0   9     0   4   25 20                 45
1674396 1674396 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   grade_3 53 12 27 0   9     0   6   52 55 *                     107.0 53 12 27 0   9     0   6   52 55                 107
1674630 1674630 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin - Jefferson Elementary   Regular School No Elementary KG 05 2021   grade_3 54 1 3 0   9     1   1   39 30 *                     69.0 54 1 3 0   9     1   1   39 30                 69
1674872 1674872 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Harvard - Hildreth Elementary School   Regular School No Elementary PK 05 2021   grade_3 58 2 4 0   9     0   5   40 38 *                     78.0 58 2 4 0   9     0   5   40 38                 78
1675866 1675866 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Lynnfield - Summer Street   Regular School No Elementary KG 04 2021   grade_3 79 3 5 0   9     0   1   52 45 *                     97.0 79 3 5 0   9     0   1   52 45                 97
1675991 1675991 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Marlborough - Charles Jaworek School   Regular School No Elementary KG 05 2021   grade_3 39 5 46 0   9     0   0   53 46 *                     99.0 39 5 46 0   9     0   0   53 46                 99
1676394 1676394 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Natick - Lilja Elementary   Regular School No Elementary KG 04 2021   grade_3 65 2 7 0   9     0   3   42 44 *                     86.0 65 2 7 0   9     0   3   42 44                 86
1676435 1676435 MA Norfolk   school 2508370 199   Needham 250837001317 1990040 Needham - William Mitchell   Regular School No Elementary KG 05 2021   grade_3 53 4 3 0   9     0   2   41 30 *                     71.0 53 4 3 0   9     0   2   41 30                 71
1676664 1676664 MA Middlesex   school 2508610 207   Newton 250861001367 2070075 Newton - Horace Mann   Regular School No Elementary KG 05 2021   grade_3 36 4 5 0   9     0   6   28 32 *                     60.0 36 4 5 0   9     0   6   28 32                 60
1676877 1676877 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Northborough - Lincoln Street   Regular School No Elementary KG 05 2021   grade_3 39 0 3 1   9     0   3   29 26 *                     55.0 39 0 3 1   9     0   3   29 26                 55
1678566 1678566 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 Tewksbury - North Street   Regular School No Elementary 03 04 2021   grade_3 98 6 6 0   9     0   1   57 63 *                     120.0 98 6 6 0   9     0   1   57 63                 120
2039894 2039894 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_3 25 7 12 0   9     0   0   29 24                       53.0 25 7 12 0   9     0   0   29 24                 53
2039901 2039901 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_3 20 4 7 0   9     0   1   20 21                       41.0 20 4 7 0   9     0   1   20 21                 41
2039915 2039915 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_3 79 2 7 0   9     0   6   57 46                       103.0 79 2 7 0   9     0   6   57 46                 103
2039997 2039997 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2019   grade_3 47 4 6 0   9     0   7   32 41                       73.0 47 4 6 0   9     0   7   32 41                 73
2041432 2041432 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2019   grade_3 41 2 5 0   9     0   2   29 30                       59.0 41 2 5 0   9     0   2   29 30                 59
2041513 2041513 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2019   grade_3 25 10 1 0   9     0   3   18 30                       48.0 25 10 1 0   9     0   3   18 30                 48
2041527 2041527 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   grade_3 27 12 7 0   9     0   3   35 23                       58.0 27 12 7 0   9     0   3   35 23                 58
2041564 2041564 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2019   grade_3 62 7 5 0   9     0   4   42 45                       87.0 62 7 5 0   9     0   4   42 45                 87

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