enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,679 ✖
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
2230207 2230207 MA Suffolk   school   35   Boston   350652               2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
735663 735663 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_4 162 6 0 1   3     0   0   81 91                       172 162 6 0 1   3     0   0   81 91                 172
737008 737008 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No 1 01 05 2015   grade_4 80 1 2 0   5     0   1   41 48                       89 80 1 2 0   5     0   1   41 48                 89
737019 737019 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2015   grade_4 60 5 4 1   12     0   2   41 43                       84 60 5 4 1   12     0   2   41 43                 84
737030 737030 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 01 05 2015   grade_4 39 9 6 1   4     0   0   28 31                       59 39 9 6 1   4     0   0   28 31                 59
737495 737495 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_4 10 11 92 0   1     0   1   63 52                       115 10 11 92 0   1     0   1   63 52                 115
737499 737499 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_4 8 9 88 2   3     0   3   57 56                       113 8 9 88 2   3     0   3   57 56                 113
737503 737503 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_4 12 5 124 0   2     0   0   75 68                       143 12 5 124 0   2     0   0   75 68                 143
737507 737507 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_4 13 7 122 1   5     0   0   75 73                       148 13 7 122 1   5     0   0   75 73                 148
737714 737714 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2015   grade_4 73 2 3 0   4     0   0   45 37                       82 73 2 3 0   4     0   0   45 37                 82
737742 737742 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2015   grade_4 39 9 12 0   1     0   5   30 36                       66 39 9 12 0   1     0   5   30 36                 66
737747 737747 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2015   grade_4 42 2 6 0   3     0   2   25 30                       55 42 2 6 0   3     0   2   25 30                 55
737752 737752 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No 1 01 05 2015   grade_4 47 5 1 0   1     0   0   31 23                       54 47 5 1 0   1     0   0   31 23                 54
737757 737757 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2015   grade_4 28 2 2 2   1     0   0   17 18                       35 28 2 2 2   1     0   0   17 18                 35
738895 738895 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 01 04 2015   grade_4 8 2 130 0   3     0   1   68 76                       144 8 2 130 0   3     0   1   68 76                 144
738927 738927 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2015   grade_4 4 7 132 0   1     0   1   72 73                       145 4 7 132 0   1     0   1   72 73                 145
738945 738945 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_4 3 0 95 0   0     0   0   57 41                       98 3 0 95 0   0     0   0   57 41                 98
738958 738958 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2015   grade_4 1 0 58 0   0     0   0   30 29                       59 1 0 58 0   0     0   0   30 29                 59
739012 739012 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_4 3 0 12 0   0     0   0   14 1                       15 3 0 12 0   0     0   0   14 1                 15
739317 739317 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_4 * * * *   *     *   *   3 *                       4                         3                   4
739420 739420 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2015   grade_4 8 5 25 1   10     0   6   29 26                       55 8 5 25 1   10     0   6   29 26                 55
739452 739452 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2015   grade_4 10 8 64 0   10     0   2   50 44                       94 10 8 64 0   10     0   2   50 44                 94
739481 739481 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_4 2 4 2 0   0     0   0   6 2                       8 2 4 2 0   0     0   0   6 2                 8
739506 739506 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2015   grade_4 3 5 48 1   5     0   3   36 29                       65 3 5 48 1   5     0   3   36 29                 65
739918 739918 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2015   grade_4 120 3 4 2   3     0   3   64 71                       135 120 3 4 2   3     0   3   64 71                 135
739923 739923 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2015   grade_4 96 4 4 1   2     0   5   50 62                       112 96 4 4 1   2     0   5   50 62                 112
740188 740188 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2015   grade_4 12 6 19 0   0     0   3   20 20                       40 12 6 19 0   0     0   3   20 20                 40
740697 740697 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2015   grade_4 21 11 16 0   3     0   0   27 24                       51 21 11 16 0   3     0   0   27 24                 51
740702 740702 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2015   grade_4 40 4 8 0   3     0   2   27 30                       57 40 4 8 0   3     0   2   27 30                 57
740707 740707 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2015   grade_4 57 7 2 0   8     0   2   41 35                       76 57 7 2 0   8     0   2   41 35                 76
740712 740712 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2015   grade_4 35 6 4 0   1     0   0   25 21                       46 35 6 4 0   1     0   0   25 21                 46
741289 741289 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No 1 01 04 2015   grade_4 40 2 3 0   1     0   0   26 20                       46 40 2 3 0   1     0   0   26 20                 46
741293 741293 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No 1 01 04 2015   grade_4 71 7 2 0   1     0   3   45 39                       84 71 7 2 0   1     0   3   45 39                 84
741556 741556 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2015   grade_4 104 5 10 1   71     0   6   107 90                       197 104 5 10 1   71     0   6   107 90                 197
741708 741708 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2015   grade_4 40 2 55 0   0     0   0   50 47                       97 40 2 55 0   0     0   0   50 47                 97
741715 741715 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2015   grade_4 35 1 33 0   3     0   0   37 35                       72 35 1 33 0   3     0   0   37 35                 72
742352 742352 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No 1 01 04 2015   grade_4 34 0 3 0   0     0   2   23 16                       39 34 0 3 0   0     0   2   23 16                 39
742816 742816 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2015   grade_4 28 0 13 1   0     0   0   23 19                       42 28 0 13 1   0     0   0   23 19                 42
742821 742821 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2015   grade_4 16 0 8 0   0     0   0   13 11                       24 16 0 8 0   0     0   0   13 11                 24
742826 742826 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2015   grade_4 40 0 3 0   1     0   1   25 20                       45 40 0 3 0   1     0   1   25 20                 45
932541 932541 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_4 169 4 8 0   0     0   2   98 85                       183 169 4 8 0   0     0   2   98 85                 183
933885 933885 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No 1 01 05 2016   grade_4 57 2 4 0   14     0   0   28 49                       77 57 2 4 0   14     0   0   28 49                 77
934355 934355 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2016   grade_4 21 9 116 0   1     0   2   76 73                       149 21 9 116 0   1     0   2   76 73                 149
934359 934359 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_4 7 5 96 1   0     0   0   63 46                       109 7 5 96 1   0     0   0   63 46                 109
934363 934363 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2016   grade_4 5 1 129 0   2     0   0   74 63                       137 5 1 129 0   2     0   0   74 63                 137
934367 934367 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2016   grade_4 14 8 149 0   2     0   0   93 80                       173 14 8 149 0   2     0   0   93 80                 173
934573 934573 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No 1 01 05 2016   grade_4 84 0 1 0   1     0   5   46 45                       91 84 0 1 0   1     0   5   46 45                 91
934599 934599 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No 1 01 05 2016   grade_4 32 3 13 0   3     0   2   28 25                       53 32 3 13 0   3     0   2   28 25                 53
934604 934604 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2016   grade_4 48 3 3 0   1     0   1   36 20                       56 48 3 3 0   1     0   1   36 20                 56
934609 934609 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No 1 01 05 2016   grade_4 41 4 5 0   1     0   3   22 32                       54 41 4 5 0   1     0   3   22 32                 54
934614 934614 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No 1 01 05 2016   grade_4 32 1 3 0   2     0   1   25 14                       39 32 1 3 0   2     0   1   25 14                 39
934970 934970 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_4 * * * *   *     *   *   2 1                       3                         2 1                 3
935452 935452 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_4 3 0 5 0   0     0   0   7 1                       8 3 0 5 0   0     0   0   7 1                 8
935461 935461 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 01 04 2016   grade_4 47 3 50 0   1     0   0   52 49                       101 47 3 50 0   1     0   0   52 49                 101
935472 935472 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_4 20 2 23 0   1     0   0   25 21                       46 20 2 23 0   1     0   0   25 21                 46
935775 935775 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2016   grade_4 4 2 126 0   1     0   0   62 71                       133 4 2 126 0   1     0   0   62 71                 133
935793 935793 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_4 6 1 105 0   0     0   0   65 47                       112 6 1 105 0   0     0   0   65 47                 112
935806 935806 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2016   grade_4 1 1 59 0   0     0   0   31 30                       61 1 1 59 0   0     0   0   31 30                 61
935861 935861 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_4 1 0 10 0   0     0   0   8 3                       11 1 0 10 0   0     0   0   8 3                 11
936268 936268 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No 1 01 05 2016   grade_4 9 7 29 0   4     0   9   35 23                       58 9 7 29 0   4     0   9   35 23                 58
936300 936300 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No 1 01 05 2016   grade_4 3 5 87 0   8     0   2   54 51                       105 3 5 87 0   8     0   2   54 51                 105
936354 936354 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No 1 01 05 2016   grade_4 5 7 53 0   4     0   4   43 30                       73 5 7 53 0   4     0   4   43 30                 73
936763 936763 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2016   grade_4 110 1 7 2   3     0   4   66 61                       127 110 1 7 2   3     0   4   66 61                 127
936768 936768 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No 1 01 05 2016   grade_4 109 3 2 2   2     0   5   70 53                       123 109 3 2 2   2     0   5   70 53                 123
937032 937032 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 John Hannigan   Regular School No 1 01 05 2016   grade_4 13 3 25 1   0     0   1   26 17                       43 13 3 25 1   0     0   1   26 17                 43
937526 937526 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No 1 01 05 2016   grade_4 31 3 11 0   2     0   2   24 25                       49 31 3 11 0   2     0   2   24 25                 49
937531 937531 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No 1 01 05 2016   grade_4 31 7 9 0   2     0   0   21 28                       49 31 7 9 0   2     0   0   21 28                 49
937536 937536 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No 1 01 05 2016   grade_4 49 5 4 0   10     0   0   36 32                       68 49 5 4 0   10     0   0   36 32                 68
937541 937541 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No 1 01 05 2016   grade_4 31 7 4 0   5     0   0   28 19                       47 31 7 4 0   5     0   0   28 19                 47
938116 938116 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Memorial Park   Regular School No 1 01 04 2016   grade_4 36 3 7 0   0     0   1   22 25                       47 36 3 7 0   0     0   1   22 25                 47
938120 938120 MA Plymouth   school 2510170 251   Rockland 251017001641 2510025 R Stewart Esten   Regular School No 1 01 04 2016   grade_4 53 5 8 0   1     0   4   33 38                       71 53 5 8 0   1     0   4   33 38                 71
938361 938361 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_4 91 10 15 1   95     0   7   113 106                       219 91 10 15 1   95     0   7   113 106                 219
938511 938511 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No 1 01 05 2016   grade_4 54 0 34 0   0     0   2   47 43                       90 54 0 34 0   0     0   2   47 43                 90
938519 938519 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No 1 01 05 2016   grade_4 32 0 41 1   2     0   1   37 40                       77 32 0 41 1   2     0   1   37 40                 77
939160 939160 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No 1 01 04 2016   grade_4 47 0 0 0   0     0   3   17 33                       50 47 0 0 0   0     0   3   17 33                 50
939621 939621 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2016   grade_4 15 4 15 0   1     0   1   18 18                       36 15 4 15 0   1     0   1   18 18                 36
939626 939626 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2016   grade_4 28 2 4 0   1     0   1   17 19                       36 28 2 4 0   1     0   1   17 19                 36
939631 939631 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2016   grade_4 43 0 3 0   1     0   3   25 25                       50 43 0 3 0   1     0   3   25 25                 50
1121952 1121952 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_4 130 2 7 1   2     0   1   73 70                       143 130 2 7 1   2     0   1   73 70                 143
1123135 1123135 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_4 5 6 4 0   0     0   1   14 2                       16 5 6 4 0   0     0   1   14 2                 16
1123528 1123528 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2017   grade_4 78 3 6 0   23     0   0   58 52                       110 78 3 6 0   23     0   0   58 52                 110
1124082 1124082 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_4 11 9 113 0   1     0   2   69 67                       136 11 9 113 0   1     0   2   69 67                 136
1124087 1124087 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_4 7 5 85 2   3     0   1   52 51                       103 7 5 85 2   3     0   1   52 51                 103
1124092 1124092 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   grade_4 7 1 121 0   1     0   2   66 66                       132 7 1 121 0   1     0   2   66 66                 132
1124097 1124097 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_4 10 6 149 0   1     0   4   77 93                       170 10 6 149 0   1     0   4   77 93                 170
1124339 1124339 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2017   grade_4 85 1 0 0   0     0   6   53 39                       92 85 1 0 0   0     0   6   53 39                 92
1124371 1124371 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2017   grade_4 40 8 17 1   2     0   4   39 33                       72 40 8 17 1   2     0   4   39 33                 72
1124377 1124377 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2017   grade_4 51 2 5 0   2     0   4   31 33                       64 51 2 5 0   2     0   4   31 33                 64
1124383 1124383 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2017   grade_4 47 5 7 0   1     0   5   27 38                       65 47 5 7 0   1     0   5   27 38                 65
1124389 1124389 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2017   grade_4 33 3 7 0   0     0   0   31 12                       43 33 3 7 0   0     0   0   31 12                 43
1125423 1125423 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_4 * * * *   *     *   *   4 1                       *                         4 1                  
1125432 1125432 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_4 68 7 40 0   2     0   2   55 64                       119 68 7 40 0   2     0   2   55 64                 119
1125446 1125446 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_4 31 1 22 0   2     0   1   34 23                       57 31 1 22 0   2     0   1   34 23                 57
1125804 1125804 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_4 5 0 113 0   0     0   0   56 62                       118 5 0 113 0   0     0   0   56 62                 118
1125826 1125826 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_4 3 0 99 0   0     0   2   56 48                       104 3 0 99 0   0     0   2   56 48                 104
1125842 1125842 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2017   grade_4 0 0 76 0   0     0   2   38 40                       78 0 0 76 0   0     0   2   38 40                 78
1125881 1125881 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_4 1 0 11 0   0     0   1   12 1                       13 1 0 11 0   0     0   1   12 1                 13
1126377 1126377 MA Essex   school 2507110 163   Lynn 250711001064 1630020 Brickett Elementary   Regular School No Elementary 01 05 2017   grade_4 5 5 31 0   14     0   1   20 36                       56 5 5 31 0   14     0   1   20 36                 56
1126414 1126414 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2017   grade_4 6 11 88 0   7     0   3   58 57                       115 6 11 88 0   7     0   3   58 57                 115
1126478 1126478 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2017   grade_4 5 8 73 0   5     0   3   48 46                       94 5 8 73 0   5     0   3   48 46                 94

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