enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2230206 2230206 MA Suffolk   school   35   Boston   350652               2018   grade_3 * * * *   *     *   *   * *                       0.0                                             0
735662 735662 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_3 168 0 5 0   1     0   0   90 84                       174 168 0 5 0   1     0   0   90 84                 174
735999 735999 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_3 163 1 11 0   1     0   1   77 100                       177 163 1 11 0   1     0   1   77 100                 177
737007 737007 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No 1 01 05 2015   grade_3 64 2 3 0   4     0   0   35 38                       73 64 2 3 0   4     0   0   35 38                 73
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
737029 737029 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 01 05 2015   grade_3 38 3 4 0   7     0   0   34 18                       52 38 3 4 0   7     0   0   34 18                 52
737494 737494 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_3 23 11 109 0   1     0   1   72 73                       145 23 11 109 0   1     0   1   72 73                 145
737498 737498 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_3 7 5 98 1   0     0   0   62 49                       111 7 5 98 1   0     0   0   62 49                 111
737502 737502 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_3 5 1 137 0   2     0   0   81 64                       145 5 1 137 0   2     0   0   81 64                 145
737506 737506 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_3 15 13 138 0   2     0   0   92 76                       168 15 13 138 0   2     0   0   92 76                 168
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
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
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
738894 738894 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 01 04 2015   grade_3 9 4 114 0   8     0   1   69 67                       136 9 4 114 0   8     0   1   69 67                 136
738926 738926 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2015   grade_3 3 0 124 0   1     0   0   59 69                       128 3 0 124 0   1     0   0   59 69                 128
738944 738944 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_3 6 0 101 0   0     0   0   62 45                       107 6 0 101 0   0     0   0   62 45                 107
738957 738957 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_3 1 0 71 0   0     0   0   34 38                       72 1 0 71 0   0     0   0   34 38                 72
739011 739011 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_3 1 0 9 0   0     0   0   8 2                       10 1 0 9 0   0     0   0   8 2                 10
739419 739419 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2015   grade_3 8 7 24 0   4     0   12   33 22                       55 8 7 24 0   4     0   12   33 22                 55
739451 739451 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2015   grade_3 7 8 87 0   11     0   2   60 55                       115 7 8 87 0   11     0   2   60 55                 115
739480 739480 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_3 4 1 3 0   0     0   1   8 1                       9 4 1 3 0   0     0   1   8 1                 9
739505 739505 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2015   grade_3 4 6 48 0   5     0   3   39 27                       66 4 6 48 0   5     0   3   39 27                 66
739917 739917 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2015   grade_3 115 1 6 2   3     0   4   66 65                       131 115 1 6 2   3     0   4   66 65                 131
739922 739922 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2015   grade_3 111 1 3 2   3     0   5   68 57                       125 111 1 3 2   3     0   5   68 57                 125
740187 740187 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2015   grade_3 17 4 27 0   0     0   1   29 20                       49 17 4 27 0   0     0   1   29 20                 49
740696 740696 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2015   grade_3 34 5 13 0   1     0   3   28 28                       56 34 5 13 0   1     0   3   28 28                 56
740701 740701 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2015   grade_3 34 6 7 0   3     0   1   20 31                       51 34 6 7 0   3     0   1   20 31                 51
740706 740706 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2015   grade_3 47 4 4 0   12     0   0   38 29                       67 47 4 4 0   12     0   0   38 29                 67
740711 740711 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2015   grade_3 31 8 2 0   4     0   0   26 19                       45 31 8 2 0   4     0   0   26 19                 45
741288 741288 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No 1 01 04 2015   grade_3 32 3 7 0   0     0   1   21 22                       43 32 3 7 0   0     0   1   21 22                 43
741292 741292 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No 1 01 04 2015   grade_3 48 7 10 0   1     0   4   30 40                       70 48 7 10 0   1     0   4   30 40                 70
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
741707 741707 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2015   grade_3 71 0 10 0   0     0   1   45 37                       82 71 0 10 0   0     0   1   45 37                 82
741714 741714 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2015   grade_3 59 0 20 0   2     0   0   39 42                       81 59 0 20 0   2     0   0   39 42                 81
742351 742351 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No 1 01 04 2015   grade_3 44 0 0 0   0     0   4   16 32                       48 44 0 0 0   0     0   4   16 32                 48
742658 742658 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No 1 01 03 2015   grade_3 72 2 2 1   1     0   3   38 43                       81 72 2 2 1   1     0   3   38 43                 81
742815 742815 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2015   grade_3 20 2 16 0   1     0   1   17 23                       40 20 2 16 0   1     0   1   17 23                 40
742820 742820 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2015   grade_3 26 2 4 0   0     0   0   14 18                       32 26 2 4 0   0     0   0   14 18                 32
742825 742825 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2015   grade_3 40 0 4 0   1     0   3   25 23                       48 40 0 4 0   1     0   3   25 23                 48
742956 742956 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No 1 01 03 2015   grade_3 128 1 4 0   5     0   7   83 62                       145 128 1 4 0   5     0   7   83 62                 145
742959 742959 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No 1 01 03 2015   grade_3 118 1 3 1   3     0   3   61 68                       129 118 1 3 1   3     0   3   61 68                 129
932540 932540 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_3 135 1 5 0   1     0   3   77 68                       145 135 1 5 0   1     0   3   77 68                 145
932873 932873 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2016   grade_3 160 7 4 0   6     1   1   101 78                       179 160 7 4 0   6     1   1   101 78                 179
933884 933884 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2016   grade_3 77 4 5 0   25     0   0   58 53                       111 77 4 5 0   25     0   0   58 53                 111
934354 934354 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2016   grade_3 13 11 124 0   1     0   3   79 73                       152 13 11 124 0   1     0   3   79 73                 152
934358 934358 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_3 8 7 91 2   3     0   1   57 55                       112 8 7 91 2   3     0   1   57 55                 112
934362 934362 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2016   grade_3 7 3 120 0   1     0   1   65 67                       132 7 3 120 0   1     0   1   65 67                 132
934366 934366 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2016   grade_3 14 6 139 1   1     0   3   76 88                       164 14 6 139 1   1     0   3   76 88                 164
934572 934572 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2016   grade_3 87 1 0 0   0     0   5   55 38                       93 87 1 0 0   0     0   5   55 38                 93
934598 934598 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2016   grade_3 41 6 16 1   2     0   6   39 33                       72 41 6 16 1   2     0   6   39 33                 72
934603 934603 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2016   grade_3 54 2 5 0   2     0   4   31 36                       67 54 2 5 0   2     0   4   31 36                 67
934608 934608 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No 1 01 05 2016   grade_3 49 6 5 0   1     0   5   28 38                       66 49 6 5 0   1     0   5   28 38                 66
934613 934613 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2016   grade_3 30 2 6 0   0     0   0   26 12                       38 30 2 6 0   0     0   0   26 12                 38
935460 935460 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 01 04 2016   grade_3 81 5 33 1   1     0   3   57 67                       124 81 5 33 1   1     0   3   57 67                 124
935471 935471 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_3 35 2 15 1   2     0   0   35 20                       55 35 2 15 1   2     0   0   35 20                 55
935774 935774 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2016   grade_3 5 1 116 0   0     0   0   57 65                       122 5 1 116 0   0     0   0   57 65                 122
935792 935792 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_3 2 0 97 0   0     0   1   57 43                       100 2 0 97 0   0     0   1   57 43                 100
935805 935805 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2016   grade_3 0 1 75 0   0     0   1   35 42                       77 0 1 75 0   0     0   1   35 42                 77
935860 935860 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_3 4 0 11 0   0     0   1   14 2                       16 4 0 11 0   0     0   1   14 2                 16
936267 936267 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2016   grade_3 6 6 30 0   13     0   3   20 38                       58 6 6 30 0   13     0   3   20 38                 58
936299 936299 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2016   grade_3 6 12 87 0   6     0   3   56 58                       114 6 12 87 0   6     0   3   56 58                 114
936353 936353 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2016   grade_3 4 6 74 0   5     0   4   44 49                       93 4 6 74 0   5     0   4   44 49                 93
936762 936762 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2016   grade_3 105 2 7 1   0     0   6   63 58                       121 105 2 7 1   0     0   6   63 58                 121
936767 936767 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2016   grade_3 109 6 3 1   2     0   2   62 61                       123 109 6 3 1   2     0   2   62 61                 123
937031 937031 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2016   grade_3 13 6 26 0   0     0   1   19 27                       46 13 6 26 0   0     0   1   19 27                 46
937525 937525 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2016   grade_3 39 4 16 0   4     0   3   36 30                       66 39 4 16 0   4     0   3   36 30                 66
937530 937530 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2016   grade_3 32 6 3 0   3     0   0   27 17                       44 32 6 3 0   3     0   0   27 17                 44
937535 937535 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2016   grade_3 47 7 2 0   8     1   1   27 39                       66 47 7 2 0   8     1   1   27 39                 66
937540 937540 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2016   grade_3 26 4 1 0   2     0   1   17 17                       34 26 4 1 0   2     0   1   17 17                 34
938115 938115 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No 1 01 04 2016   grade_3 35 2 5 0   1     0   5   25 23                       48 35 2 5 0   1     0   5   25 23                 48
938119 938119 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No 1 01 04 2016   grade_3 56 4 10 0   1     0   2   43 30                       73 56 4 10 0   1     0   2   43 30                 73
938360 938360 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_3 75 4 19 0   82     0   7   92 95                       187 75 4 19 0   82     0   7   92 95                 187
938510 938510 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2016   grade_3 53 2 41 0   1     0   0   53 44                       97 53 2 41 0   1     0   0   53 44                 97
938518 938518 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2016   grade_3 32 0 42 0   3     0   5   42 40                       82 32 0 42 0   3     0   5   42 40                 82
939159 939159 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No 1 01 04 2016   grade_3 37 0 2 0   0     0   2   21 20                       41 37 0 2 0   0     0   2   21 20                 41
939464 939464 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No 1 01 03 2016   grade_3 78 0 5 0   1     0   5   43 46                       89 78 0 5 0   1     0   5   43 46                 89
939620 939620 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2016   grade_3 34 4 17 0   3     0   3   33 28                       61 34 4 17 0   3     0   3   33 28                 61
939625 939625 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2016   grade_3 20 1 10 0   0     0   2   14 19                       33 20 1 10 0   0     0   2   14 19                 33
939630 939630 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2016   grade_3 39 0 4 0   0     0   2   22 23                       45 39 0 4 0   0     0   2   22 23                 45
939761 939761 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No 1 01 03 2016   grade_3 122 1 3 0   5     0   4   65 70                       135 122 1 3 0   5     0   4   65 70                 135
939764 939764 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No 1 01 03 2016   grade_3 97 0 10 0   6     0   2   58 57                       115 97 0 10 0   6     0   2   58 57                 115
1121951 1121951 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_3 127 5 11 1   3     0   1   77 71                       148 127 5 11 1   3     0   1   77 71                 148
1122358 1122358 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2017   grade_3 169 2 7 1   2     0   3   94 90                       184 169 2 7 1   2     0   3   94 90                 184
1123134 1123134 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_3 2 7 4 0   0     0   0   10 3                       13 2 7 4 0   0     0   0   10 3                 13
1123527 1123527 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_3 54 2 6 0   24     1   1   45 43                       88 54 2 6 0   24     1   1   45 43                 88
1124081 1124081 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_3 13 10 125 0   1     1   0   78 72                       150 13 10 125 0   1     1   0   78 72                 150
1124086 1124086 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_3 14 12 113 1   2     0   1   76 67                       143 14 12 113 1   2     0   1   76 67                 143
1124091 1124091 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   grade_3 3 3 141 0   1     0   2   71 79                       150 3 3 141 0   1     0   2   71 79                 150
1124096 1124096 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_3 8 5 158 0   2     0   3   104 72                       176 8 5 158 0   2     0   3   104 72                 176
1124338 1124338 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_3 71 1 7 0   0     0   1   37 43                       80 71 1 7 0   0     0   1   37 43                 80
1124370 1124370 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_3 42 6 17 0   2     0   5   38 34                       72 42 6 17 0   2     0   5   38 34                 72
1124376 1124376 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_3 56 2 5 0   1     0   2   36 30                       66 56 2 5 0   1     0   2   36 30                 66
1124382 1124382 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_3 40 2 4 0   0     0   1   32 15                       47 40 2 4 0   0     0   1   32 15                 47
1124388 1124388 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_3 29 2 1 0   0     0   3   17 18                       35 29 2 1 0   0     0   3   17 18                 35
1125431 1125431 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_3 54 4 75 0   4     0   2   75 64                       139 54 4 75 0   4     0   2   75 64                 139
1125445 1125445 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_3 21 0 30 0   3     0   2   32 24                       56 21 0 30 0   3     0   2   32 24                 56
1125803 1125803 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_3 2 2 131 0   2     0   2   77 62                       139 2 2 131 0   2     0   2   77 62                 139

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