Data source: Big Local News · About: Big Local

3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by native_american descending

View and edit SQL

year

grade

  • pre_kindergarten · 3,669
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
1679385 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester - Head Start   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 155 106 22 9   14     0   13   157 162 *                     319.0 155 106 22 9   14     0   13   157 162                 319
739722 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   pre_kindergarten 68 4 6 5   3     0   6   51 41                       92 68 4 6 5   3     0   6   51 41                 92
936566 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   pre_kindergarten 61 7 4 5   1     1   2   46 35                       81 61 7 4 5   1     1   2   46 35                 81
2044077 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2019   pre_kindergarten 72 0 0 5   2     0   0   38 41                       79.0 72 0 0 5   2     0   0   38 41                 79
1128888 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten 109 5 22 4   83     0   9   122 110                       232 109 5 22 4   83     0   9   122 110                 232
2047196 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 311 107 99 4   9     0   21   261 290                       551.0 311 107 99 4   9     0   21   261 290                 551
933973 MA Plymouth   school 2503090 44   Brockton 250309000221 440050 Gilmore School Early Childhood Center   Regular School No 1 PK KG 2016   pre_kindergarten 85 122 33 3   3     0   15   161 100                       261 85 122 33 3   3     0   15   161 100                 261
938374 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No 1 PK PK 2016   pre_kindergarten 116 4 18 3   89     0   9   124 115                       239 116 4 18 3   89     0   9   124 115                 239
939908 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No 1 PK PK 2016   pre_kindergarten 105 108 332 3   19     1   3   294 277                       571 105 108 332 3   19     1   3   294 277                 571
940276 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 04 2016   pre_kindergarten 0 25 11 3   0     0   0   17 22                       39 0 25 11 3   0     0   0   17 22                 39
1126732 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   pre_kindergarten 23 1 1 3   0     0   2   22 8                       30 23 1 1 3   0     0   2   22 8                 30
1131684 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Carol Huebner Early Childhood Program   Regular School No Elementary PK PK 2017   pre_kindergarten 45 5 3 3   39     0   2   58 39                       97 45 5 3 3   39     0   2   58 39                 97
1365318 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten 0 29 12 3   1     0   1   25 21 *                     46.0 0 29 12 3   1     0   1   25 21                 46
1369006 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2020   pre_kindergarten 66 1 3 3   2     0   0   42 33 *                     75.0 66 1 3 3   2     0   0   42 33                 75
1370979 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2020   pre_kindergarten 7 22 72 3   0     0   3   53 54 *                     107.0 7 22 72 3   0     0   3   53 54                 107
1372123 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 253 86 23 3   13     0   15   191 202 *                     393.0 253 86 23 3   13     0   15   191 202                 393
2042749 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 106 21 64 3   4     2   0   126 74                       200.0 106 21 64 3   4     2   0   126 74                 200
2043862 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   pre_kindergarten 65 3 8 3   2     1   12   55 39                       94.0 65 3 8 3   2     1   12   55 39                 94
2045174 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 15 11 3   88     1   8   107 70                       177.0 51 15 11 3   88     1   8   107 70                 177
2045918 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   pre_kindergarten 24 35 85 3   4     0   4   86 69                       155.0 24 35 85 3   4     0   4   86 69                 155
2048303 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2019   pre_kindergarten 40 9 9 3   0     0   0   39 22                       61.0 40 9 9 3   0     0   0   39 22                 61
736485 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2015   pre_kindergarten 7 62 23 2   1     0   2   60 37                       97 7 62 23 2   1     0   2   60 37                 97
737297 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No 3 09 12 2015   pre_kindergarten 75 6 12 2   28     0   5   82 46                       128 75 6 12 2   28     0   5   82 46                 128
737710 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No 1 PK KG 2015   pre_kindergarten 53 3 1 2   2     0   1   38 24                       62 53 3 1 2   2     0   1   38 24                 62
737960 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No 1 PK 04 2015   pre_kindergarten 108 52 105 2   19     0   5   173 118                       291 108 52 105 2   19     0   5   173 118                 291
738128 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 72 4 4 2   1     0   7   50 40                       90 72 4 4 2   1     0   7   50 40                 90
738214 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No 1 PK 04 2015   pre_kindergarten 68 0 4 2   6     0   2   51 31                       82 68 0 4 2   6     0   2   51 31                 82
739188 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No 1 PK 02 2015   pre_kindergarten 49 8 3 2   4     1   0   32 35                       67 49 8 3 2   4     1   0   32 35                 67
739533 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   pre_kindergarten 12 4 19 2   5     0   1   24 19                       43 12 4 19 2   5     0   1   24 19                 43
739657 MA Middlesex   school 2507320 170   Marlborough 250732001368 1700006 Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 103 7 29 2   12     0   10   99 64                       163 103 7 29 2   12     0   10   99 64                 163
741569 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No 1 PK PK 2015   pre_kindergarten 113 5 13 2   90     0   11   126 108                       234 113 5 13 2   90     0   11   126 108                 234
933038 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2016   pre_kindergarten 7 26 14 2   11     0   1   31 30                       61 7 26 14 2   11     0   1   31 30                 61
933221 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No 1 PK 05 2016   pre_kindergarten 1 17 6 2   3     1   2   20 12                       32 1 17 6 2   3     1   2   20 12                 32
933289 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2016   pre_kindergarten 2 15 7 2   1     1   0   12 16                       28 2 15 7 2   1     1   0   12 16                 28
934595 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK KG 2016   pre_kindergarten 80 4 16 2   1     0   9   63 49                       112 80 4 16 2   1     0   9   63 49                 112
934767 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No 1 PK 02 2016   pre_kindergarten 24 3 1 2   2     0   3   22 13                       35 24 3 1 2   2     0   3   22 13                 35
935250 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Milton L Fuller Elementary   Regular School No 1 PK PK 2016   pre_kindergarten 78 4 1 2   2     1   2   52 38                       90 78 4 1 2   2     1   2   52 38                 90
935283 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2016   pre_kindergarten 43 0 4 2   12     0   4   35 30                       65 43 0 4 2   12     0   4   35 30                 65
939280 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No 1 03 04 2016   pre_kindergarten 48 5 4 2   0     0   9   34 34                       68 48 5 4 2   0     0   9   34 34                 68
941825 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2016   pre_kindergarten 95 2 3 2   3     0   3   74 34                       108 95 2 3 2   3     0   3   74 34                 108
1123204 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   pre_kindergarten 0 28 12 2   0     0   2   24 20                       44 0 28 12 2   0     0   2   24 20                 44
1124034 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Community Education Center   Regular School No Elementary PK PK 2017   pre_kindergarten 84 5 12 2   27     0   6   78 58                       136 84 5 12 2   27     0   6   78 58                 136
1124524 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2017   pre_kindergarten 31 1 4 2   3     0   2   25 18                       43 31 1 4 2   3     0   2   25 18                 43
1127707 MA Bristol   school 2508730 212   North Attleborough 250873001409 2120020 North Attleborough Early Learning Center   Regular School No Elementary PK PK 2017   pre_kindergarten 95 6 4 2   18     1   10   77 59                       136 95 6 4 2   18     1   10   77 59                 136
1130731 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Elementary PK PK 2017   pre_kindergarten 98 103 330 2   18     2   7   280 280                       560 98 103 330 2   18     2   7   280 280                 560
1131158 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   pre_kindergarten 1 23 12 2   1     0   0   17 22                       39 1 23 12 2   1     0   0   17 22                 39
1131986 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   pre_kindergarten 52 6 12 2   3     0   1   50 26                       76 52 6 12 2   3     0   1   50 26                 76
1369972 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No Elementary PK 05 2020   pre_kindergarten 37 6 16 2   0     0   9   45 25 *                     70.0 37 6 16 2   0     0   9   45 25                 70
1370602 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 104 9 11 2   97     0   7   131 99 *                     230.0 104 9 11 2   97     0   7   131 99                 230
1371679 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2020   pre_kindergarten 28 1 15 2   79     0   3   70 58 *                     128.0 28 1 15 2   79     0   3   70 58                 128
1676042 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   pre_kindergarten 44 2 3 2   0     0   3   21 33 *                     54.0 44 2 3 2   0     0   3   21 33                 54
1676148 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Melrose - Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten 87 9 6 2   6     0   8   66 52 *                     118.0 87 9 6 2   6     0   8   66 52                 118
1680501 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth - Ezra H Baker Innovation School   Regular School No Elementary PK 03 2021   pre_kindergarten 23 1 2 2   3     0   1   20 12 *                     32.0 23 1 2 2   3     0   1   20 12                 32
2040915 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2019   pre_kindergarten 14 20 37 2   1     0   5   38 41                       79.0 14 20 37 2   1     0   5   38 41                 79
2041201 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 35 0 2 2   0     0   0   18 21                       39.0 35 0 2 2   0     0   0   18 21                 39
2042833 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2019   pre_kindergarten 23 11 6 2   1     0   5   31 17                       48.0 23 11 6 2   1     0   5   31 17                 48
2045848 MA Hampden   school 2511130 281   Springfield 251113002853 2810001 Early Childhood Education Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 15 26 103 2   4     0   5   105 50                       155.0 15 26 103 2   4     0   5   105 50                 155
2047490 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   pre_kindergarten 13 0 1 2   0     0   1   10 7                       17.0 13 0 1 2   0     0   1   10 7                 17
2229103 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 85 11 26 2   1     0   10   75 60                       135.0 85 11 26 2   1     0   10   75 60                 135
2229800 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   pre_kindergarten 2 27 22 2   0     0   0   27 26                       53.0 2 27 22 2   0     0   0   27 26                 53
2229881 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston: Samuel W Mason   Regular School No Elementary PK 05 2018   pre_kindergarten 1 12 6 2   2     0   3   14 12                       26.0 1 12 6 2   2     0   3   14 12                 26
2233553 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   pre_kindergarten 50 1 8 2   0     0   13   46 28                       74.0 50 1 8 2   0     0   13   46 28                 74
2235221 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 Randolph: J F Kennedy Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 8 37 8 2   8     2   5   42 28                       70.0 8 37 8 2   8     2   5   42 28                 70
2235709 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Shrewsbury: Parker Road Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 101 8 19 2   95     0   10   118 117                       235.0 101 8 19 2   95     0   10   118 117                 235
735956 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   pre_kindergarten 59 16 10 1   2     0   5   65 28                       93 59 16 10 1   2     0   5   65 28                 93
736051 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   pre_kindergarten 47 0 2 1   9     0   4   38 25                       63 47 0 2 1   9     0   4   38 25                 63
736169 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No 1 PK 01 2015   pre_kindergarten 4 32 12 1   8     1   0   31 27                       58 4 32 12 1   8     1   0   31 27                 58
736478 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No 1 PK 05 2015   pre_kindergarten 19 2 18 1   2     0   1   27 16                       43 19 2 18 1   2     0   1   27 16                 43
736492 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No 1 PK 05 2015   pre_kindergarten 5 26 5 1   19     0   3   28 31                       59 5 26 5 1   19     0   3   28 31                 59
736499 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   pre_kindergarten 0 3 9 1   0     0   0   7 6                       13 0 3 9 1   0     0   0   7 6                 13
736965 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   pre_kindergarten 46 0 3 1   0     0   1   31 20                       51 46 0 3 1   0     0   1   31 20                 51
737038 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No 3 09 12 2015   pre_kindergarten 81 9 1 1   11     0   3   61 45                       106 81 9 1 1   11     0   3   61 45                 106
737106 MA Plymouth   school 2503090 44   Brockton 250309000221 440050 Gilmore School Early Childhood Center   Regular School No 1 PK KG 2015   pre_kindergarten 95 87 39 1   7     0   17   158 88                       246 95 87 39 1   7     0   17   158 88                 246
737341 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2015   pre_kindergarten 13 4 4 1   6     0   1   15 14                       29 13 4 4 1   6     0   1   15 14                 29
737369 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No 1 PK 05 2015   pre_kindergarten 28 21 10 1   13     0   12   46 39                       85 28 21 10 1   13     0   12   46 39                 85
737406 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Rodman Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 59 11 2 1   5     0   5   40 43                       83 59 11 2 1   5     0   5   40 43                 83
737491 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2015   pre_kindergarten 24 13 215 1   2     0   1   138 118                       256 24 13 215 1   2     0   1   138 118                 256
737737 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK 01 2015   pre_kindergarten 77 6 14 1   4     0   7   62 47                       109 77 6 14 1   4     0   7   62 47                 109
737846 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No 1 PK 02 2015   pre_kindergarten 87 2 2 1   0     0   3   53 42                       95 87 2 2 1   0     0   3   53 42                 95
738300 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No 1 PK PK 2015   pre_kindergarten 110 2 4 1   10     5   4   84 52                       136 110 2 4 1   10     5   4   84 52                 136
738399 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Milton L Fuller Elementary   Regular School No 1 PK PK 2015   pre_kindergarten 80 1 1 1   1     3   1   56 32                       88 80 1 1 1   1     3   1   56 32                 88
738592 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No 1 PK PK 2015   pre_kindergarten 110 4 55 1   3     0   7   104 76                       180 110 4 55 1   3     0   7   104 76                 180
738858 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No 1 PK 05 2015   pre_kindergarten 14 0 6 1   1     0   0   12 10                       22 14 0 6 1   1     0   0   12 10                 22
739044 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   pre_kindergarten 65 0 2 1   1     0   0   44 25                       69 65 0 2 1   1     0   0   44 25                 69
739381 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2015   pre_kindergarten 36 2 3 1   0     0   0   31 11                       42 36 2 3 1   0     0   0   31 11                 42
739443 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No 1 PK 05 2015   pre_kindergarten 15 9 49 1   9     0   4   45 42                       87 15 9 49 1   9     0   4   45 42                 87
739772 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 John J McGlynn Elementary School   Regular School No 1 PK 05 2015   pre_kindergarten 6 5 2 1   3     0   1   8 10                       18 6 5 2 1   3     0   1   8 10                 18
740166 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   pre_kindergarten 38 8 12 1   0     0   6   41 24                       65 38 8 12 1   0     0   6   41 24                 65
740372 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 118 6 21 1   39     1   15   129 72                       201 118 6 21 1   39     1   15   129 72                 201
740869 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 57 0 0 1   0     0   1   35 24                       59 57 0 0 1   0     0   1   35 24                 59
741002 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 46 0 2 1   0     0   1   26 24                       50 46 0 2 1   0     0   1   26 24                 50
741228 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No 1 PK 05 2015   pre_kindergarten 49 2 25 1   4     0   0   39 42                       81 49 2 25 1   4     0   0   39 42                 81
741390 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   pre_kindergarten 57 0 0 1   2     0   1   38 23                       61 57 0 0 1   2     0   1   38 23                 61
741578 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 14 0 1 1   1     0   3   8 12                       20 14 0 1 1   1     0   3   8 12                 20
741751 MA Hampden   school 2511130 281   Springfield 251113001833 2810015 Thomas M Balliet   Regular School No 1 PK 05 2015   pre_kindergarten 6 9 26 1   1     0   0   24 19                       43 6 9 26 1   1     0   0   24 19                 43
742407 MA Middlesex   school 2512000 308   Waltham 251200001973 3080005 William F. Stanley Elementary School   Regular School No 1 PK 05 2015   pre_kindergarten 34 4 15 1   1     0   3   37 21                       58 34 4 15 1   1     0   3   37 21                 58
742876 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Johnson Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 181 12 11 1   17     0   3   124 101                       225 181 12 11 1   17     0   3   124 101                 225
743170 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   pre_kindergarten 15 14 30 1   2     0   7   31 38                       69 15 14 30 1   2     0   7   31 38                 69
743193 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2015   pre_kindergarten 6 2 25 1   6     0   3   26 17                       43 6 2 25 1   6     0   3   26 17                 43
744188 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No 1 PK 03 2015   pre_kindergarten 42 3 7 1   1     0   0   34 20                       54 42 3 7 1   1     0   0   34 20                 54

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