enrollments

Data source: Big Local News · About: Big Local

953 rows where grade = "grade_4", state = "MA" and year = 2015 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 953 ✖

grade ✖

  • grade_4 · 953 ✖
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
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
735810 735810 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2015   grade_4 60 4 3 0   5     0   0   37 35                       72 60 4 3 0   5     0   0   37 35                 72
735816 735816 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2015   grade_4 65 2 6 0   7     0   8   43 45                       88 65 2 6 0   7     0   8   43 45                 88
735822 735822 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2015   grade_4 69 3 8 0   5     0   4   36 53                       89 69 3 8 0   5     0   4   36 53                 89
735828 735828 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2015   grade_4 33 0 1 0   9     0   3   23 23                       46 33 0 1 0   9     0   3   23 23                 46
735835 735835 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No 1 KG 05 2015   grade_4 29 5 1 0   5     0   3   20 23                       43 29 5 1 0   5     0   3   20 23                 43
735841 735841 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No 1 KG 05 2015   grade_4 33 5 2 0   8     0   7   18 37                       55 33 5 2 0   8     0   7   18 37                 55
735847 735847 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2015   grade_4 43 3 4 0   12     0   4   34 32                       66 43 3 4 0   12     0   4   34 32                 66
738243 738243 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2015   grade_4 17 3 51 0   7     0   4   35 47                       82 17 3 51 0   7     0   4   35 47                 82
738249 738249 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2015   grade_4 46 5 4 0   17     0   3   44 31                       75 46 5 4 0   17     0   3   44 31                 75
738255 738255 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2015   grade_4 73 3 5 0   6     0   2   43 46                       89 73 3 5 0   6     0   2   43 46                 89
738261 738261 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2015   grade_4 28 6 72 0   1     0   2   53 56                       109 28 6 72 0   1     0   2   53 56                 109
738267 738267 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Potter Road   Regular School No 1 KG 05 2015   grade_4 73 1 5 0   1     0   4   40 44                       84 73 1 5 0   1     0   4   40 44                 84
738273 738273 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No 1 KG 05 2015   grade_4 50 7 8 0   4     0   4   47 26                       73 50 7 8 0   4     0   4   47 26                 73
738279 738279 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_4 60 16 17 0   3     0   5   64 37                       101 60 16 17 0   3     0   5   64 37                 101
738285 738285 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2015   grade_4 68 7 14 0   0     0   2   46 45                       91 68 7 14 0   0     0   2   46 45                 91
738305 738305 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Jefferson Elementary   Regular School No 1 KG 05 2015   grade_4 60 1 1 0   4     0   1   36 31                       67 60 1 1 0   4     0   1   36 31                 67
738311 738311 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_4 93 0 1 0   6     0   1   60 41                       101 93 0 1 0   6     0   1   60 41                 101
738317 738317 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No 1 KG 05 2015   grade_4 66 0 3 0   10     0   2   35 46                       81 66 0 3 0   10     0   2   35 46                 81
738323 738323 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Oak Street Elementary   Regular School No 1 KG 05 2015   grade_4 60 0 1 0   2     0   3   26 40                       66 60 0 1 0   2     0   3   26 40                 66
738329 738329 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No 1 KG 05 2015   grade_4 60 2 2 0   4     0   0   33 35                       68 60 2 2 0   4     0   0   33 35                 68
738335 738335 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2015   grade_4 47 0 3 0   2     0   0   26 26                       52 47 0 3 0   2     0   0   26 26                 52
738352 738352 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 03 05 2015   grade_4 120 1 28 0   2     0   20   84 87                       171 120 1 28 0   2     0   20   84 87                 171
738378 738378 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 02 05 2015   grade_4 100 1 2 0   2     0   2   60 47                       107 100 1 2 0   2     0   2   60 47                 107
738391 738391 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Beeman Memorial   Regular School No 1 KG 05 2015   grade_4 39 1 5 0   1     0   7   33 20                       53 39 1 5 0   1     0   7   33 20                 53
738397 738397 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   grade_4 45 0 2 0   0     0   2   31 18                       49 45 0 2 0   0     0   2   31 18                 49
738404 738404 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2015   grade_4 28 1 0 0   1     0   1   17 14                       31 28 1 0 0   1     0   1   17 14                 31
738410 738410 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   grade_4 33 1 8 0   2     0   1   26 19                       45 33 1 8 0   2     0   1   26 19                 45
738416 738416 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No 1 KG 05 2015   grade_4 42 2 2 2   0     0   1   26 23                       49 42 2 2 2   0     0   1   26 23                 49
738425 738425 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 04 05 2015   grade_4 * * * *   *     *   *   * *                       1                                             1
738435 738435 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_4 104 1 2 0   9     0   2   51 67                       118 104 1 2 0   9     0   2   51 67                 118
738440 738440 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_4 111 1 2 0   25     0   6   71 74                       145 111 1 2 0   25     0   6   71 74                 145
738450 738450 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No 2 04 06 2015   grade_4 58 0 4 0   0     0   1   41 22                       63 58 0 4 0   0     0   1   41 22                 63
738473 738473 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No 2 04 07 2015   grade_4 * * * *   *     *   *   1 *                       1                         1                   1
738481 738481 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2015   grade_4 113 1 27 0   1     0   2   71 73                       144 113 1 27 0   1     0   2   71 73                 144
738496 738496 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_4 35 0 0 1   1     4   1   22 20                       42 35 0 0 1   1     4   1   22 20                 42
738510 738510 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_4 87 0 0 0   0     1   0   53 35                       88 87 0 0 0   0     1   0   53 35                 88
738525 738525 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No 1 PK 04 2015   grade_4 63 0 0 0   2     0   0   33 32                       65 63 0 0 0   2     0   0   33 32                 65
738530 738530 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Sylvester   Regular School No 1 03 04 2015   grade_4 99 0 2 0   2     0   0   54 49                       103 99 0 2 0   2     0   0   54 49                 103
738545 738545 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No 1 PK 05 2015   grade_4 51 4 1 0   10     0   5   41 30                       71 51 4 1 0   10     0   5   41 30                 71
738559 738559 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_4 31 0 4 0   0     0   0   19 16                       35 31 0 4 0   0     0   0   19 16                 35
738573 738573 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   grade_4 107 2 17 0   4     0   2   68 64                       132 107 2 17 0   4     0   2   68 64                 132
738580 738580 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No 1 KG 04 2015   grade_4 56 1 36 0   3     0   2   49 49                       98 56 1 36 0   3     0   2   49 49                 98
738601 738601 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No 1 KG 04 2015   grade_4 80 3 31 0   2     1   0   54 63                       117 80 3 31 0   2     1   0   54 63                 117
738602 738602 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_4 * * * *   *     *   *   3 1                       4                         3 1                 4
738614 738614 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 KG 04 2015   grade_4 36 3 56 1   3     2   1   54 48                       102 36 3 56 1   3     2   1   54 48                 102
738626 738626 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_4 13 0 19 0   0     0   0   11 21                       32 13 0 19 0   0     0   0   11 21                 32
738641 738641 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   grade_4 89 0 0 0   5     0   2   52 44                       96 89 0 0 0   5     0   2   52 44                 96
738647 738647 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2015   grade_4 71 1 2 0   3     0   6   40 43                       83 71 1 2 0   3     0   6   40 43                 83
738653 738653 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2015   grade_4 68 0 4 0   4     0   2   40 38                       78 68 0 4 0   4     0   2   40 38                 78
738659 738659 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2015   grade_4 97 1 0 0   2     0   1   62 39                       101 97 1 0 0   2     0   1   62 39                 101
738674 738674 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2015   grade_4 51 17 10 0   3     0   5   43 43                       86 51 17 10 0   3     0   5   43 43                 86
738689 738689 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   grade_4 31 1 0 0   1     0   0   13 20                       33 31 1 0 0   1     0   0   13 20                 33
738693 738693 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No 1 03 05 2015   grade_4 166 2 13 1   11     0   6   104 95                       199 166 2 13 1   11     0   6   104 95                 199
738713 738713 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_4 12 3 28 0   1     0   0   22 22                       44 12 3 28 0   1     0   0   22 22                 44
738723 738723 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_4 0 3 31 0   0     0   0   13 21                       34 0 3 31 0   0     0   0   13 21                 34
738728 738728 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_4 6 2 54 0   0     0   0   40 22                       62 6 2 54 0   0     0   0   40 22                 62
738737 738737 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_4 2 1 47 0   0     0   0   29 21                       50 2 1 47 0   0     0   0   29 21                 50
738746 738746 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_4 8 0 39 0   0     0   1   19 29                       48 8 0 39 0   0     0   1   19 29                 48
738755 738755 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_4 13 1 50 0   0     0   1   33 32                       65 13 1 50 0   0     0   1   33 32                 65
738764 738764 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_4 8 3 47 1   0     0   0   32 27                       59 8 3 47 1   0     0   0   32 27                 59
738786 738786 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   grade_4 77 0 2 0   7     1   3   53 37                       90 77 0 2 0   7     1   3   53 37                 90
738800 738800 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No 2 04 05 2015   grade_4 229 2 6 0   31     0   6   135 139                       274 229 2 6 0   31     0   6   135 139                 274
735861 735861 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No 1 03 05 2015   grade_4 130 6 16 0   25     0   6   93 90                       183 130 6 16 0   25     0   6   93 90                 183
738815 738815 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2015   grade_4 57 1 2 0   0     0   1   32 29                       61 57 1 2 0   0     0   1   32 29                 61
738820 738820 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2015   grade_4 53 1 5 0   2     0   2   38 25                       63 53 1 5 0   2     0   2   38 25                 63
738826 738826 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2015   grade_4 87 3 3 0   1     0   4   48 50                       98 87 3 3 0   1     0   4   48 50                 98
738841 738841 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2015   grade_4 68 0 0 0   0     0   0   41 27                       68 68 0 0 0   0     0   0   41 27                 68
738855 738855 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2015   grade_4 61 1 2 0   0     0   2   27 39                       66 61 1 2 0   0     0   2   27 39                 66
738862 738862 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No 1 PK 05 2015   grade_4 55 0 5 0   1     0   8   37 32                       69 55 0 5 0   1     0   8   37 32                 69
738876 738876 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2015   grade_4 154 2 2 0   2     0   0   82 78                       160 154 2 2 0   2     0   0   82 78                 160
738884 738884 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_4 18 0 0 0   0     0   1   9 10                       19 18 0 0 0   0     0   1   9 10                 19
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
738901 738901 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_4 1 2 123 0   0     0   0   67 59                       126 1 2 123 0   0     0   0   67 59                 126
738905 738905 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_4 9 1 84 0   4     0   0   47 51                       98 9 1 84 0   4     0   0   47 51                 98
738919 738919 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2015   grade_4 4 3 104 0   2     0   1   71 43                       114 4 3 104 0   2     0   1   71 43                 114
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
738940 738940 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   grade_4 1 1 97 0   0     0   0   47 52                       99 1 1 97 0   0     0   0   47 52                 99
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
738954 738954 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2015   grade_4 8 1 130 0   0     0   0   74 65                       139 8 1 130 0   0     0   0   74 65                 139
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
738964 738964 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   grade_4 2 1 79 0   3     0   0   42 43                       85 2 1 79 0   3     0   0   42 43                 85
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
739031 739031 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_4 43 1 1 0   2     0   3   23 27                       50 43 1 1 0   2     0   3   23 27                 50
739041 739041 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No 1 03 05 2015   grade_4 93 5 8 0   2     0   2   47 63                       110 93 5 8 0   2     0   2   47 63                 110
739059 739059 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   grade_4 52 0 2 0   0     0   0   29 25                       54 52 0 2 0   0     0   0   29 25                 54
739075 739075 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2015   grade_4 78 6 26 0   2     0   2   55 59                       114 78 6 26 0   2     0   2   55 59                 114
739081 739081 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Southeast School   Regular School No 1 KG 05 2015   grade_4 43 5 32 0   9     0   7   51 45                       96 43 5 32 0   9     0   7   51 45                 96
739087 739087 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No 1 KG 05 2015   grade_4 62 19 32 0   3     0   4   65 55                       120 62 19 32 0   3     0   4   65 55                 120
739093 739093 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No 1 KG 05 2015   grade_4 70 3 28 0   2     0   2   57 48                       105 70 3 28 0   2     0   2   57 48                 105
739117 739117 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   grade_4 14 0 0 0   2     0   1   10 7                       17 14 0 0 0   2     0   1   10 7                 17
739125 739125 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2015   grade_4 44 10 2 1   43     0   1   53 48                       101 44 10 2 1   43     0   1   53 48                 101
739131 739131 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2015   grade_4 43 6 2 0   37     0   4   52 40                       92 43 6 2 0   37     0   4   52 40                 92
739137 739137 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2015   grade_4 48 3 3 0   39     0   8   36 65                       101 48 3 3 0   39     0   8   36 65                 101
739143 739143 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No 1 KG 05 2015   grade_4 60 1 1 0   26     0   9   46 51                       97 60 1 1 0   26     0   9   46 51                 97
739149 739149 MA Middlesex   school 2506840 155   Lexington 250684000998 1550030 Harrington   Regular School No 1 KG 05 2015   grade_4 37 2 4 0   34     0   4   45 36                       81 37 2 4 0   34     0   4   45 36                 81
739155 739155 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Maria Hastings   Regular School No 1 KG 05 2015   grade_4 45 1 2 0   29     0   3   50 30                       80 45 1 2 0   29     0   3   50 30                 80
739177 739177 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2015   grade_4 42 6 7 1   2     0   2   29 31                       60 42 6 7 1   2     0   2   29 31                 60
739182 739182 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2015   grade_4 30 6 7 0   5     0   6   24 30                       54 30 6 7 0   5     0   6   24 30                 54
739192 739192 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No 1 03 05 2015   grade_4 117 1 2 0   3     0   3   66 60                       126 117 1 2 0   3     0   3   66 60                 126

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