enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 3,938 ✖
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
743260 743260 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_6 10 4 3 0   0     0   1   7 11                       18 10 4 3 0   0     0   1   7 11                 18
743267 743267 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2015   grade_6 27 5 5 0   3     0   2   21 21                       42 27 5 5 0   3     0   2   21 21                 42
743274 743274 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2015   grade_6 39 3 3 0   3     0   2   25 25                       50 39 3 3 0   3     0   2   25 25                 50
743282 743282 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2015   grade_6 33 12 20 0   5     0   1   40 31                       71 33 12 20 0   5     0   1   40 31                 71
743290 743290 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2015   grade_6 29 10 29 0   12     0   3   40 43                       83 29 10 29 0   12     0   3   40 43                 83
743297 743297 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   grade_6 11 9 16 0   1     0   4   23 18                       41 11 9 16 0   1     0   4   23 18                 41
743305 743305 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   grade_6 23 6 21 0   4     0   5   30 29                       59 23 6 21 0   4     0   5   30 29                 59
743313 743313 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2015   grade_6 21 2 17 1   1     0   2   20 24                       44 21 2 17 1   1     0   2   20 24                 44
743320 743320 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2015   grade_6 28 14 19 1   5     0   7   35 39                       74 28 14 19 1   5     0   7   35 39                 74
743327 743327 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2015   grade_6 14 5 13 0   2     0   3   16 21                       37 14 5 13 0   2     0   3   16 21                 37
743334 743334 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   grade_6 8 9 26 1   3     0   4   25 26                       51 8 9 26 1   3     0   4   25 26                 51
743342 743342 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2015   grade_6 31 3 4 0   3     0   5   28 18                       46 31 3 4 0   3     0   5   28 18                 46
743350 743350 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2015   grade_6 18 18 37 0   1     0   2   38 38                       76 18 18 37 0   1     0   2   38 38                 76
743400 743400 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No 2 04 06 2015   grade_6 143 3 4 0   7     0   4   78 83                       161 143 3 4 0   7     0   4   78 83                 161
743475 743475 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_6 0 29 9 0   0     0   0   16 22                       38 0 29 9 0   0     0   0   16 22                 38
743798 743798 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   grade_6 1 58 29 0   2     0   6   44 52                       96 1 58 29 0   2     0   6   44 52                 96
743928 743928 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2015   grade_6 46 2 1 0   24     0   2   46 29                       75 46 2 1 0   24     0   2   46 29                 75
743936 743936 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No 1 PK 06 2015   grade_6 50 2 3 0   12     0   6   34 39                       73 50 2 3 0   12     0   6   34 39                 73
743943 743943 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No 1 KG 06 2015   grade_6 52 1 4 0   11     0   4   33 39                       72 52 1 4 0   11     0   4   33 39                 72
743950 743950 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2015   grade_6 45 2 1 0   17     0   7   41 31                       72 45 2 1 0   17     0   7   41 31                 72
743957 743957 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No 1 KG 06 2015   grade_6 37 4 0 0   30     0   1   44 28                       72 37 4 0 0   30     0   1   44 28                 72
743964 743964 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2015   grade_6 29 1 0 0   40     0   2   37 35                       72 29 1 0 0   40     0   2   37 35                 72
744036 744036 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2015   grade_6 16 0 0 0   1     0   0   10 7                       17 16 0 0 0   1     0   0   10 7                 17
744122 744122 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No 2 04 06 2015   grade_6 228 9 4 0   3     0   8   123 129                       252 228 9 4 0   3     0   8   123 129                 252
744141 744141 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
744274 744274 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_6 16 1 0 0   0     0   1   11 7                       18 16 1 0 0   0     0   1   11 7                 18
744316 744316 MA Hampshire   school 2505160 672   Gateway 250516002666 6720410 Gateway Regional Middle School   Regular School No 2 05 06 2015   grade_6 74 0 6 0   0     0   1   45 36                       81 74 0 6 0   0     0   1   45 36                 81
744348 744348 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No 1 KG 06 2015   grade_6 16 1 0 0   0     0   0   4 13                       17 16 1 0 0   0     0   0   4 13                 17
744428 744428 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2015   grade_6 18 0 0 1   0     0   0   8 11                       19 18 0 0 1   0     0   0   8 11                 19
744529 744529 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No 1 PK 06 2015   grade_6 12 0 0 0   0     0   2   9 5                       14 12 0 0 0   0     0   2   9 5                 14
744537 744537 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   14 7                       21 20 0 1 0   0     0   0   14 7                 21
744544 744544 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2015   grade_6 12 0 1 0   0     0   0   8 5                       13 12 0 1 0   0     0   0   8 5                 13
744551 744551 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No 1 KG 06 2015   grade_6 23 0 1 0   0     0   0   12 12                       24 23 0 1 0   0     0   0   12 12                 24
744619 744619 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No 1 PK 06 2015   grade_6 19 0 1 0   0     0   2   9 13                       22 19 0 1 0   0     0   2   9 13                 22
744668 744668 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Elmer S Bagnall   Regular School No 1 PK 06 2015   grade_6 80 1 0 0   3     0   1   49 36                       85 80 1 0 0   3     0   1   49 36                 85
744672 744672 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No 1 03 06 2015   grade_6 86 1 1 0   0     0   4   41 51                       92 86 1 1 0   0     0   4   41 51                 92
744680 744680 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No 1 PK 06 2015   grade_6 72 1 1 0   4     0   0   39 39                       78 72 1 1 0   4     0   0   39 39                 78
744699 744699 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 3 0   1     0   1   26 13                       39 34 0 3 0   1     0   1   26 13                 39
744713 744713 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No 1 PK 06 2015   grade_6 21 0 2 0   0     0   0   12 11                       23 21 0 2 0   0     0   0   12 11                 23
744719 744719 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2015   grade_6 10 0 0 0   0     0   0   2 8                       10 10 0 0 0   0     0   0   2 8                 10
744732 744732 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2015   grade_6 29 0 0 0   0     0   1   22 8                       30 29 0 0 0   0     0   1   22 8                 30
744739 744739 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2015   grade_6 58 0 3 0   0     0   0   27 34                       61 58 0 3 0   0     0   0   27 34                 61
744747 744747 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_6 46 0 1 0   0     0   0   21 26                       47 46 0 1 0   0     0   0   21 26                 47
744754 744754 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2015   grade_6 54 0 0 0   1     0   1   21 35                       56 54 0 0 0   1     0   1   21 35                 56
744801 744801 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2015   grade_6 38 2 3 0   0     0   5   25 23                       48 38 2 3 0   0     0   5   25 23                 48
744838 744838 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 KG 06 2015   grade_6 24 1 3 0   0     0   0   14 14                       28 24 1 3 0   0     0   0   14 14                 28
744872 744872 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No 1 PK 06 2015   grade_6 58 0 4 1   1     0   1   32 33                       65 58 0 4 1   1     0   1   32 33                 65
744880 744880 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2015   grade_6 66 0 3 1   1     0   0   40 31                       71 66 0 3 1   1     0   0   40 31                 71
744888 744888 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No 1 PK 06 2015   grade_6 72 0 2 0   0     0   0   39 35                       74 72 0 2 0   0     0   0   39 35                 74
744982 744982 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2015   grade_6 76 0 5 0   0     0   1   37 45                       82 76 0 5 0   0     0   1   37 45                 82
744990 744990 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 49 0 0 0   0     0   0   28 21                       49 49 0 0 0   0     0   0   28 21                 49
745163 745163 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 06 2015   grade_6 0 28 20 0   0     0   2   26 24                       50 0 28 20 0   0     0   2   26 24                 50
745172 745172 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 06 2015   grade_6 60 17 21 1   0     0   4   58 45                       103 60 17 21 1   0     0   4   58 45                 103
932543 932543 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_6 149 1 7 0   0     0   4   86 75                       161 149 1 7 0   0     0   4   86 75                 161
932622 932622 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2016   grade_6 29 2 6 0   11     0   0   23 25                       48 29 2 6 0   11     0   0   23 25                 48
932629 932629 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_6 35 5 11 0   7     1   2   28 33                       61 35 5 11 0   7     1   2   28 33                 61
932636 932636 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_6 40 6 10 0   4     0   3   30 33                       63 40 6 10 0   4     0   3   30 33                 63
932817 932817 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2016   grade_6 43 10 2 0   3     0   5   37 26                       63 43 10 2 0   3     0   5   37 26                 63
932870 932870 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2016   grade_6 173 2 5 0   2     1   4   96 91                       187 173 2 5 0   2     1   4   96 91                 187
933241 933241 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No 1 PK 06 2016   grade_6 25 35 32 0   6     1   8   49 58                       107 25 35 32 0   6     1   8   49 58                 107
933855 933855 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_6 100 1 1 0   5     0   2   55 54                       109 100 1 1 0   5     0   2   55 54                 109
933925 933925 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_6 39 0 0 0   0     0   0   17 22                       39 39 0 0 0   0     0   0   17 22                 39
934044 934044 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 44 0 1 0   0     0   2   25 22                       47 44 0 1 0   0     0   2   25 22                 47
934528 934528 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_6 26 0 0 0   0     0   0   17 9                       26 26 0 0 0   0     0   0   17 9                 26
934630 934630 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2016   grade_6 57 1 0 0   0     0   1   27 32                       59 57 1 0 0   0     0   1   27 32                 59
934706 934706 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2016   grade_6 185 2 1 1   0     0   1   87 103                       190 185 2 1 1   0     0   1   87 103                 190
934800 934800 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2016   grade_6 19 0 1 0   0     0   1   8 13                       21 19 0 1 0   0     0   1   8 13                 21
935004 935004 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2016   grade_6 239 13 16 3   6     0   19   160 136                       296 239 13 16 3   6     0   19   160 136                 296
935231 935231 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
935278 935278 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 05 06 2016   grade_6 * * * *   *     *   *   * *                       1                                             1
935289 935289 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2016   grade_6 94 2 3 0   11     0   4   57 57                       114 94 2 3 0   11     0   4   57 57                 114
935294 935294 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_6 123 0 6 0   23     0   4   73 83                       156 123 0 6 0   23     0   4   73 83                 156
935303 935303 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No 2 04 06 2016   grade_6 72 0 4 0   1     0   0   40 37                       77 72 0 4 0   1     0   0   40 37                 77
935349 935349 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_6 36 2 2 1   0     1   3   26 19                       45 36 2 2 1   0     1   3   26 19                 45
935362 935362 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2016   grade_6 62 0 0 0   1     0   1   38 26                       64 62 0 0 0   1     0   1   38 26                 64
935369 935369 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 2                       4                         2 2                 4
935411 935411 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_6 39 0 0 0   1     0   2   17 25                       42 39 0 0 0   1     0   2   17 25                 42
935522 935522 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2016   grade_6 77 23 9 0   4     0   10   62 61                       123 77 23 9 0   4     0   10   62 61                 123
935536 935536 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2016   grade_6 26 0 1 0   0     0   0   13 14                       27 26 0 1 0   0     0   0   13 14                 27
935637 935637 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   grade_6 90 2 5 0   0     0   1   47 51                       98 90 2 5 0   0     0   1   47 51                 98
935727 935727 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2016   grade_6 163 5 2 0   2     0   1   98 75                       173 163 5 2 0   2     0   1   98 75                 173
935735 935735 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2016   grade_6 29 0 0 0   0     0   0   12 17                       29 29 0 0 0   0     0   0   12 17                 29
935882 935882 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2016   grade_6 37 0 4 0   1     0   2   24 20                       44 37 0 4 0   1     0   2   24 20                 44
935965 935965 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   grade_6 11 0 0 0   0     0   4   6 9                       15 11 0 0 0   0     0   4   6 9                 15
936331 936331 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_6 5 2 3 0   0     0   0   9 1                       10 5 2 3 0   0     0   0   9 1                 10
936480 936480 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No 2 04 06 2016   grade_6 207 5 13 0   2     0   5   116 116                       232 207 5 13 0   2     0   5   116 116                 232
936500 936500 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No 1 PK 06 2016   grade_6 71 3 3 0   0     0   1   43 35                       78 71 3 3 0   0     0   1   43 35                 78
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
936586 936586 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No 2 04 06 2016   grade_6 76 1 2 0   2     0   3   40 44                       84 76 1 2 0   2     0   3   40 44                 84
936786 936786 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2016   grade_6 90 0 5 0   3     0   3   45 56                       101 90 0 5 0   3     0   3   45 56                 101
936814 936814 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No 2 04 06 2016   grade_6 114 3 11 0   5     0   5   67 71                       138 114 3 11 0   5     0   5   67 71                 138
936892 936892 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2016   grade_6 22 0 1 0   1     0   0   9 15                       24 22 0 1 0   1     0   0   9 15                 24
936978 936978 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No 2 06 06 2016   grade_6 360 11 13 2   39     0   26   218 233                       451 360 11 13 2   39     0   26   218 233                 451
937257 937257 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2016   grade_6 125 0 3 0   2     0   2   64 68                       132 125 0 3 0   2     0   2   64 68                 132
937451 937451 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 47 0 6 0   0     0   1   25 29                       54 47 0 6 0   0     0   1   25 29                 54
937570 937570 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No 1 03 06 2016   grade_6 79 2 4 0   1     0   7   37 56                       93 79 2 4 0   1     0   7   37 56                 93
937681 937681 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2016   grade_6 9 0 2 0   1     0   1   7 6                       13 9 0 2 0   1     0   1   7 6                 13
937688 937688 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2016   grade_6 82 0 0 0   1     0   1   39 45                       84 82 0 0 0   1     0   1   39 45                 84
937695 937695 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2016   grade_6 69 0 0 0   2     0   0   32 39                       71 69 0 0 0   2     0   0   32 39                 71
937703 937703 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2016   grade_6 93 0 3 0   1     0   2   48 51                       99 93 0 3 0   1     0   2   48 51                 99

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