Data source: Big Local News · About: Big Local

529 rows where grade = "pre_kindergarten", state = "MA" and year = 2019 sorted by school_nces_id descending

View and edit SQL

year

  • 2019 · 529

grade

  • pre_kindergarten · 529
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
2048387 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 25 0 0 0   0     0   0   15 10                       25.0 25 0 0 0   0     0   0   15 10                 25
2047497 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2019   pre_kindergarten 81 3 2 0   1     0   4   44 47                       91.0 81 3 2 0   1     0   4   44 47                 91
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
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
2047249 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2019   pre_kindergarten 3 7 12 0   0     0   1   16 7                       23.0 3 7 12 0   0     0   1   16 7                 23
2047317 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2019   pre_kindergarten 10 6 18 0   5     0   2   24 17                       41.0 10 6 18 0   5     0   2   24 17                 41
2047241 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2019   pre_kindergarten 6 0 5 0   1     0   0   5 7                       12.0 6 0 5 0   1     0   0   5 7                 12
2047437 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2019   pre_kindergarten 8 16 26 0   4     0   1   30 25                       55.0 8 16 26 0   4     0   1   30 25                 55
2047429 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2019   pre_kindergarten 27 6 10 1   4     0   3   27 24                       51.0 27 6 10 1   4     0   3   27 24                 51
2047407 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2019   pre_kindergarten 14 7 3 0   1     0   0   12 13                       25.0 14 7 3 0   1     0   0   12 13                 25
2047399 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2019   pre_kindergarten 12 7 4 0   4     0   0   18 9                       27.0 12 7 4 0   4     0   0   18 9                 27
2047391 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2019   pre_kindergarten 13 15 19 0   9     0   5   31 30                       61.0 13 15 19 0   9     0   5   31 30                 61
2047376 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2019   pre_kindergarten 7 8 9 0   2     0   3   17 12                       29.0 7 8 9 0   2     0   3   17 12                 29
2047368 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2019   pre_kindergarten 33 13 22 0   3     0   2   39 34                       73.0 33 13 22 0   3     0   2   39 34                 73
2047360 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary PK 06 2019   pre_kindergarten 19 8 15 0   1     0   5   29 19                       48.0 19 8 15 0   1     0   5   29 19                 48
2047295 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2019   pre_kindergarten 15 8 24 1   12     0   7   48 19                       67.0 15 8 24 1   12     0   7   48 19                 67
2047287 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2019   pre_kindergarten 2 3 13 0   5     0   0   13 10                       23.0 2 3 13 0   5     0   0   13 10                 23
2047265 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2019   pre_kindergarten 6 4 1 0   2     0   0   10 3                       13.0 6 4 1 0   2     0   0   10 3                 13
2047257 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2019   pre_kindergarten 11 17 18 0   3     0   2   27 24                       51.0 11 17 18 0   3     0   2   27 24                 51
2047226 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2019   pre_kindergarten 3 6 24 0   8     0   0   16 25                       41.0 3 6 24 0   8     0   0   16 25                 41
2047197 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2019   pre_kindergarten 13 11 13 0   11     0   2   35 15                       50.0 13 11 13 0   11     0   2   35 15                 50
2047167 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No Elementary PK 05 2019   pre_kindergarten 81 14 13 0   13     0   2   70 53                       123.0 81 14 13 0   13     0   2   70 53                 123
2047160 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Clyde Reeves   Regular School No Elementary PK 05 2019   pre_kindergarten 29 1 1 0   1     0   3   16 19                       35.0 29 1 1 0   1     0   3   16 19                 35
2047128 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2019   pre_kindergarten 36 1 4 0   1     0   0   22 20                       42.0 36 1 4 0   1     0   0   22 20                 42
2047102 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Vinson-Owen Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 17 0 2 0   1     0   3   10 13                       23.0 17 0 2 0   1     0   3   10 13                 23
2047095 MA Middlesex   school 2513110 344   Winchester 251311002166 3440020 Lynch Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 29 0 1 0   15     0   3   31 17                       48.0 29 0 1 0   15     0   3   31 17                 48
2047071 MA Worcester   school 2513080 343   Winchendon 251308002648 3430010 Winchendon PreSchool Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 69 1 4 0   0     0   4   39 39                       78.0 69 1 4 0   0     0   4   39 39                 78
2047052 MA Middlesex   school 2513050 342   Wilmington 251305002157 3420015 Wildwood   Regular School No Elementary PK KG 2019   pre_kindergarten 37 0 1 0   2     0   3   31 12                       43.0 37 0 1 0   2     0   3   31 12                 43
2047050 MA Middlesex   school 2513050 342   Wilmington 251305000802 3420005 Boutwell   Regular School No Elementary PK KG 2019   pre_kindergarten 33 0 0 0   3     0   1   21 16                       37.0 33 0 0 0   3     0   1   21 16                 37
2047042 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   pre_kindergarten 12 0 1 0   0     0   0   6 7                       13.0 12 0 1 0   0     0   0   6 7                 13
2049140 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   pre_kindergarten 91 4 4 0   0     0   5   59 45                       104.0 91 4 4 0   0     0   5   59 45                 104
2047034 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 16 1 1 0   1     0   0   12 7                       19.0 16 1 1 0   1     0   0   12 7                 19
2046984 MA Norfolk   school 2512840 336   Weymouth 251284000371 3360003 Johnson Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 136 10 12 0   23     0   13   105 89                       194.0 136 10 12 0   23     0   13   105 89                 194
2046976 MA Norfolk   school 2512810 335   Westwood 251281002115 3350050 Westwood Integrated Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 29 1 1 0   7     0   3   28 13                       41.0 29 1 1 0   7     0   3   28 13                 41
2046895 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   pre_kindergarten 46 0 2 0   0     0   0   30 18                       48.0 46 0 2 0   0     0   0   30 18                 48
2046883 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2019   pre_kindergarten 16 0 4 0   2     0   0   14 8                       22.0 16 0 4 0   2     0   0   14 8                 22
2046876 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No Elementary PK 03 2019   pre_kindergarten 15 1 1 0   4     0   2   9 14                       23.0 15 1 1 0   4     0   2   9 14                 23
2046868 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten 8 0 0 0   0     0   0   7 1                       8.0 8 0 0 0   0     0   0   7 1                 8
2046844 MA Middlesex   school 2512660 326   Westford 251266001572 3260013 Millennium Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 59 2 3 1   42     0   9   67 49                       116.0 59 2 3 1   42     0   9   67 49                 116
2046794 MA Hampden   school 2512630 325   Westfield 251263002452 3250003 Fort Meadow Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 131 3 36 0   10     0   3   92 91                       183.0 131 3 36 0   10     0   3   92 91                 183
2046752 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2019   pre_kindergarten 33 3 11 1   78     0   1   73 54                       127.0 33 3 11 1   78     0   1   73 54                 127
2046403 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2046909 MA Hampden   school 2512510 332   West Springfield 251251002757 3320001 Cowing Early Childhood   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 58 9 28 0   18     0   3   74 42                       116.0 58 9 28 0   18     0   3   74 42                 116
2046783 MA Plymouth   school 2512420 323   West Bridgewater 251242001663 3230005 Spring Street School   Regular School No Elementary PK KG 2019   pre_kindergarten 55 1 4 0   0     0   7   39 28                       67.0 55 1 4 0   0     0   7   39 28                 67
2046766 MA Worcester   school 2512390 322   West Boylston 251239002034 3220005 Major Edwards Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 17 2 2 0   2     0   1   15 9                       24.0 17 2 2 0   2     0   1   15 9                 24
2046737 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 13 0 0 0   0     0   1   10 4                       14.0 13 0 0 0   0     0   1   10 4                 14
2046686 MA Norfolk   school 2512270 317   Wellesley 251227002893 3170001 Preschool at Wellesley Schools   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 55 2 11 0   25     0   7   56 44                       100.0 55 2 11 0   25     0   7   56 44                 100
2046671 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 38 0 9 0   1     0   3   22 29                       51.0 38 0 9 0   1     0   3   22 29                 51
2046631 MA Middlesex   school 2512180 314   Watertown 251218002002 3140025 James Russell Lowell   Regular School No Elementary PK 05 2019   pre_kindergarten 13 0 1 0   0     0   0   9 5                       14.0 13 0 1 0   0     0   0   9 5                 14
2046624 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2019   pre_kindergarten 56 6 14 0   10     1   8   59 36                       95.0 56 6 14 0   10     1   8   59 36                 95
2046617 MA Middlesex   school 2512180 314   Watertown 251218001998 3140015 Cunniff   Regular School No Elementary PK 05 2019   pre_kindergarten 13 0 1 0   1     0   0   8 7                       15.0 13 0 1 0   1     0   0   8 7                 15
2049102 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 22 0 2 0   0     0   0   13 11                       24.0 22 0 2 0   0     0   0   13 11                 24
2049094 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 31 0 2 0   0     0   3   21 15                       36.0 31 0 2 0   0     0   3   21 15                 36
2046599 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   pre_kindergarten 61 7 6 0   1     0   6   41 40                       81.0 61 7 6 0   1     0   6   41 40                 81
2046584 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2019   pre_kindergarten 62 2 0 0   1     0   0   32 33                       65.0 62 2 0 0   1     0   0   32 33                 65
2046548 MA Middlesex   school 2512000 308   Waltham 251200001974 3080040 Northeast Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 29 11 15 0   10     0   1   38 28                       66.0 29 11 15 0   10     0   1   38 28                 66
2046535 MA Middlesex   school 2512000 308   Waltham 251200001973 3080005 William F. Stanley Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 37 4 13 0   13     0   2   36 33                       69.0 37 4 13 0   13     0   2   36 33                 69
2046496 MA Norfolk   school 2511970 307   Walpole 251197002620 3070002 Daniel Feeney Preschool Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 2 2 0   5     0   4   33 31                       64.0 51 2 2 0   5     0   4   33 31                 64
2046488 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 15 2 0 0   0     0   0   12 5                       17.0 15 2 0 0   0     0   0   12 5                 17
2046459 MA Middlesex   school 2511910 305   Wakefield 251191002826 3050001 Early Childhood Center at the Doyle School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 109 3 15 0   8     2   5   85 57                       142.0 109 3 15 0   8     2   5   85 57                 142
2049031 MA Worcester   school 2511880 775   Wachusett 251188002730 7750001 Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 128 5 13 0   4     0   4   94 60                       154.0 128 5 13 0   4     0   4   94 60                 154
2046442 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No Elementary PK 03 2019   pre_kindergarten 80 0 8 0   1     0   1   51 39                       90.0 80 0 8 0   1     0   1   51 39                 90
2046428 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 47 0 1 0   5     0   3   29 27                       56.0 47 0 1 0   5     0   3   29 27                 56
2048985 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 44 2 3 0   1     0   0   24 26                       50.0 44 2 3 0   1     0   0   24 26                 50
2049001 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2019   pre_kindergarten 27 0 0 0   1     0   0   14 14                       28.0 27 0 0 0   1     0   0   14 14                 28
2048993 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 38 1 1 0   1     0   2   19 24                       43.0 38 1 1 0   1     0   2   19 24                 43
2046421 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2019   pre_kindergarten 12 1 1 0   0     0   5   12 7                       19.0 12 1 1 0   0     0   5   12 7                 19
2046416 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No Elementary PK 03 2019   pre_kindergarten 39 0 3 0   0     0   0   22 20                       42.0 39 0 3 0   0     0   0   22 20                 42
2046383 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2019   pre_kindergarten 139 7 8 0   13     0   6   91 82                       173.0 139 7 8 0   13     0   6   91 82                 173
2046344 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten 24 6 5 0   2     0   0   26 11                       37.0 24 6 5 0   2     0   0   26 11                 37
2046328 MA Bristol   school 2511520 293   Taunton 251152000133 2930005 Edward F. Leddy Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 189 35 41 0   8     0   9   171 111                       282.0 189 35 41 0   8     0   9   171 111                 282
2046313 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No Elementary PK 02 2019   pre_kindergarten 55 0 2 0   1     0   1   33 26                       59.0 55 0 2 0   1     0   1   33 26                 59
2046297 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2019   pre_kindergarten 44 3 6 1   4     0   2   36 24                       60.0 44 3 6 1   4     0   2   36 24                 60
2046268 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2019   pre_kindergarten 26 0 0 0   0     0   0   10 16                       26.0 26 0 0 0   0     0   0   10 16                 26
2046260 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 16 0 2 0   4     0   1   17 6                       23.0 16 0 2 0   4     0   1   17 6                 23
2046250 MA Middlesex   school 2511340 288   Sudbury 251134001877 2880030 Peter Noyes   Regular School No Elementary PK 05 2019   pre_kindergarten 34 5 1 0   6     0   2   29 19                       48.0 34 5 1 0   6     0   2   29 19                 48
2046224 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 60 0 5 0   5     0   6   41 35                       76.0 60 0 5 0   5     0   6   41 35                 76
2046203 MA Norfolk   school 2511250 285   Stoughton 251125001866 2850020 Richard L. Wilkins Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 12 7 6 0   0     0   3   13 15                       28.0 12 7 6 0   0     0   3   13 15                 28
2046190 MA Norfolk   school 2511250 285   Stoughton 251125001860 2850012 Edwin A Jones Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 47 21 13 0   4     1   5   43 48                       91.0 47 21 13 0   4     1   5   43 48                 91
2046165 MA Middlesex   school 2511220 284   Stoneham 251122001855 2840025 Robin Hood   Regular School No Elementary PK 04 2019   pre_kindergarten 33 3 3 0   6     0   4   22 27                       49.0 33 3 3 0   6     0   4   22 27                 49
2046159 MA Middlesex   school 2511220 284   Stoneham 251122001851 2840005 Colonial Park   Regular School No Elementary PK 04 2019   pre_kindergarten 39 0 5 0   5     0   1   29 21                       50.0 39 0 5 0   5     0   1   29 21                 50
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
2046040 MA Hampden   school 2511130 281   Springfield 251113001836 2810185 Washington   Regular School No Elementary PK 05 2019   pre_kindergarten 7 4 24 0   10     0   1   29 17                       46.0 7 4 24 0   10     0   1   29 17                 46
2046033 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No Elementary PK 05 2019   pre_kindergarten 9 5 15 1   2     0   3   23 12                       35.0 9 5 15 1   2     0   3   23 12                 35
2045859 MA Hampden   school 2511130 281   Springfield 251113001833 2810015 Thomas M Balliet   Regular School No Elementary PK 05 2019   pre_kindergarten 10 17 28 0   0     0   4   34 25                       59.0 10 17 28 0   0     0   4   34 25                 59
2046014 MA Hampden   school 2511130 281   Springfield 251113001830 2810160 Sumner Avenue   Regular School No Elementary PK 05 2019   pre_kindergarten 3 11 51 0   6     0   1   41 31                       72.0 3 11 51 0   6     0   1   41 31                 72
2046053 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   pre_kindergarten 7 15 80 1   1     0   6   43 67                       110.0 7 15 80 1   1     0   6   43 67                 110
2045988 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No Elementary PK 05 2019   pre_kindergarten 14 6 22 0   3     0   2   26 21                       47.0 14 6 22 0   3     0   2   26 21                 47
2046001 MA Hampden   school 2511130 281   Springfield 251113001819 2810145 Mary O Pottenger   Regular School No Elementary PK 05 2019   pre_kindergarten 3 3 10 0   2     0   0   11 7                       18.0 3 3 10 0   2     0   0   11 7                 18
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
2045969 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No Elementary PK 05 2019   pre_kindergarten 2 6 19 0   0     0   2   14 15                       29.0 2 6 19 0   0     0   2   14 15                 29
2045962 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 13 15 61 1   5     0   0   53 42                       95.0 13 15 61 1   5     0   0   53 42                 95
2045952 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   pre_kindergarten 20 13 47 0   0     0   2   38 44                       82.0 20 13 47 0   0     0   2   38 44                 82
2045939 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No Elementary PK 05 2019   pre_kindergarten 14 4 28 1   4     0   3   30 24                       54.0 14 4 28 1   4     0   3   30 24                 54
2045886 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No Elementary PK 05 2019   pre_kindergarten 2 11 34 0   0     0   0   28 19                       47.0 2 11 34 0   0     0   0   28 19                 47
2045879 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary PK 05 2019   pre_kindergarten 1 1 21 0   0     0   0   15 8                       23.0 1 1 21 0   0     0   0   15 8                 23
2045852 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No Elementary PK 05 2019   pre_kindergarten 20 19 166 1   2     0   1   119 90                       209.0 20 19 166 1   2     0   1   119 90                 209
2045872 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No Elementary PK 05 2019   pre_kindergarten 4 10 45 0   0     0   0   34 25                       59.0 4 10 45 0   0     0   0   34 25                 59
2045911 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2019   pre_kindergarten 9 28 80 0   0     0   3   66 54                       120.0 9 28 80 0   0     0   3   66 54                 120
2048916 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2019   pre_kindergarten 9 0 1 0   0     0   1   5 6                       11.0 9 0 1 0   0     0   1   5 6                 11

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