Data source: Big Local News · About: Big Local

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

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
2042081 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten * * * *   *     *   *   3 2                       5.0                         3 2                 5
2043503 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   pre_kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2043633 MA Essex   school 2507110 163   Lynn 250711001066 1630090 Capt William G Shoemaker   Regular School No Elementary PK 05 2019   pre_kindergarten * * * *   *     *   *   4 1                       5.0                         4 1                 5
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
2048842 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   pre_kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040400 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   pre_kindergarten 0 13 3 0   0     0   1   10 7                       17.0 0 13 3 0   0     0   1   10 7                 17
2040421 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No Elementary PK 05 2019   pre_kindergarten 0 19 27 0   0     0   1   22 25                       47.0 0 19 27 0   0     0   1   22 25                 47
2040503 MA Suffolk   school 2502790 35   Boston 250279002569 350138 O W Holmes   Regular School No Elementary PK 05 2019   pre_kindergarten 0 14 8 0   1     0   2   15 10                       25.0 0 14 8 0   1     0   2   15 10                 25
2040574 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No Elementary PK 05 2019   pre_kindergarten 0 21 12 1   0     0   1   16 19                       35.0 0 21 12 1   0     0   1   16 19                 35
2040865 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   pre_kindergarten 0 32 23 0   0     0   1   35 21                       56.0 0 32 23 0   0     0   1   35 21                 56
2043059 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No Elementary PK KG 2019   pre_kindergarten 0 0 54 0   0     0   0   26 27                       54.0 0 0 54 0   0     0   0   26 27                 54
2043076 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2019   pre_kindergarten 0 0 87 0   0     0   0   58 29                       87.0 0 0 87 0   0     0   0   58 29                 87
2047584 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   pre_kindergarten 0 21 3 0   0     0   0   11 13                       24.0 0 21 3 0   0     0   0   11 13                 24
2047695 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   pre_kindergarten 0 0 20 0   0     0   0   7 13                       20.0 0 0 20 0   0     0   0   7 13                 20
2040360 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2019   pre_kindergarten 1 24 8 0   0     0   0   18 15                       33.0 1 24 8 0   0     0   0   18 15                 33
2040445 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   pre_kindergarten 1 0 21 0   0     0   0   8 14                       22.0 1 0 21 0   0     0   0   8 14                 22
2040557 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2019   pre_kindergarten 1 28 19 0   2     1   0   29 22                       51.0 1 28 19 0   2     1   0   29 22                 51
2040646 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   pre_kindergarten 1 4 7 0   1     0   0   6 7                       13.0 1 4 7 0   1     0   0   6 7                 13
2040656 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2019   pre_kindergarten 1 2 2 0   0     0   1   3 3                       6.0 1 2 2 0   0     0   1   3 3                 6
2040680 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2019   pre_kindergarten 1 11 7 0   0     0   0   11 8                       19.0 1 11 7 0   0     0   0   11 8                 19
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
2047509 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   pre_kindergarten 1 24 13 0   0     0   1   21 18                       39.0 1 24 13 0   0     0   1   21 18                 39
2047569 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   pre_kindergarten 1 24 10 0   1     1   1   26 12                       38.0 1 24 10 0   1     1   1   26 12                 38
2047640 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 07 2019   pre_kindergarten 1 0 38 0   0     0   2   15 26                       41.0 1 0 38 0   0     0   2   15 26                 41
2047671 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   pre_kindergarten 1 11 7 0   0     0   1   11 9                       20.0 1 11 7 0   0     0   1   11 9                 20
2047685 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   pre_kindergarten 1 24 22 0   2     0   2   19 32                       51.0 1 24 22 0   2     0   2   19 32                 51
2047814 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2019   pre_kindergarten 1 10 16 0   9     0   4   18 21                       40.0 1 10 16 0   9     0   4   18 21                 40
2047857 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   pre_kindergarten 1 22 26 1   0     1   1   20 32                       52.0 1 22 26 1   0     1   1   20 32                 52
2049285 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   pre_kindergarten 1 28 25 1   0     1   0   22 34                       56.0 1 28 25 1   0     1   0   22 34                 56
2040340 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   pre_kindergarten 10 3 6 0   0     0   4   9 14                       23.0 10 3 6 0   0     0   4   9 14                 23
2040435 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   pre_kindergarten 10 11 5 0   0     0   1   12 15                       27.0 10 11 5 0   0     0   1   12 15                 27
2041209 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   pre_kindergarten 10 48 3 0   0     0   4   38 27                       65.0 10 48 3 0   0     0   4   38 27                 65
2041868 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary PK 05 2019   pre_kindergarten 10 0 0 0   0     0   1   7 4                       11.0 10 0 0 0   0     0   1   7 4                 11
2043933 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2019   pre_kindergarten 10 0 1 0   3     0   0   6 8                       14.0 10 0 1 0   3     0   0   6 8                 14
2044158 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2019   pre_kindergarten 10 1 0 0   3     0   0   11 3                       14.0 10 1 0 0   3     0   0   11 3                 14
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
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
2048803 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2019   pre_kindergarten 10 0 0 0   0     0   0   7 3                       10.0 10 0 0 0   0     0   0   7 3                 10
2042559 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester PreSchool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 103 5 6 0   2     0   7   71 52                       123.0 103 5 6 0   2     0   7   71 52                 123
2042623 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 104 2 11 0   1     0   3   64 57                       121.0 104 2 11 0   1     0   3   64 57                 121
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
2045715 MA Middlesex   school 2510890 274   Somerville 251089002561 2740005 Capuano Early Childhood Center   Regular School No Elementary PK KG 2019   pre_kindergarten 108 15 68 0   21     0   26   139 99                       238.0 108 15 68 0   21     0   26   139 99                 238
2045677 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 109 9 11 1   106     0   6   126 116                       242.0 109 9 11 1   106     0   6   126 116                 242
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
2041354 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   pre_kindergarten 11 0 0 0   2     0   4   8 9                       17.0 11 0 0 0   2     0   4   8 9                 17
2041530 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2019   pre_kindergarten 11 24 9 1   9     0   2   28 28                       56.0 11 24 9 1   9     0   2   28 28                 56
2041581 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   pre_kindergarten 11 0 1 0   0     0   2   8 6                       14.0 11 0 1 0   0     0   2   8 6                 14
2042066 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2019   pre_kindergarten 11 0 0 0   0     0   0   3 8                       11.0 11 0 0 0   0     0   0   3 8                 11
2043360 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2019   pre_kindergarten 11 0 8 0   9     0   2   19 11                       30.0 11 0 8 0   9     0   2   19 11                 30
2044283 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2019   pre_kindergarten 11 5 14 0   0     0   1   17 14                       31.0 11 5 14 0   0     0   1   17 14                 31
2044322 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 Irwin M. Jacobs Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 11 7 24 0   0     0   1   25 18                       43.0 11 7 24 0   0     0   1   25 18                 43
2045031 MA Middlesex   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 11 2 4 0   1     0   3   13 8                       21.0 11 2 4 0   1     0   3   13 8                 21
2045038 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No Elementary PK 05 2019   pre_kindergarten 11 1 5 0   0     0   2   8 11                       19.0 11 1 5 0   0     0   2   8 11                 19
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
2048421 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 11 0 1 0   0     0   0   5 7                       12.0 11 0 1 0   0     0   0   5 7                 12
2048231 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2019   pre_kindergarten 111 7 3 0   7     0   7   79 56                       135.0 111 7 3 0   7     0   7   79 56                 135
2048906 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake Regional High   Regular School No High 09 12 2019   pre_kindergarten 111 0 0 0   0     0   0   65 46                       111.0 111 0 0 0   0     0   0   65 46                 111
2043737 MA Middlesex   school 2507170 165   Malden 250717002046 1650049 Malden Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 112 50 25 0   115     0   17   194 125                       319.0 112 50 25 0   115     0   17   194 125                 319
2041994 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2019   pre_kindergarten 115 4 6 1   1     0   4   57 74                       131.0 115 4 6 1   1     0   4   57 74                 131
2040393 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2019   pre_kindergarten 12 10 33 0   0     0   3   30 28                       58.0 12 10 33 0   0     0   3   30 28                 58
2040472 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2019   pre_kindergarten 12 6 4 0   1     0   0   10 13                       23.0 12 6 4 0   1     0   0   10 13                 23
2040795 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2019   pre_kindergarten 12 5 4 0   3     0   3   13 14                       27.0 12 5 4 0   3     0   3   13 14                 27
2041474 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No Elementary PK 05 2019   pre_kindergarten 12 4 1 0   4     0   2   12 11                       23.0 12 4 1 0   4     0   2   12 11                 23
2042008 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 12 2 0 0   0     0   1   7 8                       15.0 12 2 0 0   0     0   1   7 8                 15
2042165 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No Elementary PK 05 2019   pre_kindergarten 12 0 2 0   0     0   0   7 7                       14.0 12 0 2 0   0     0   0   7 7                 14
2042320 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 12 0 11 0   2     0   3   21 7                       28.0 12 0 11 0   2     0   3   21 7                 28
2042340 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2019   pre_kindergarten 12 0 8 0   2     0   1   14 9                       23.0 12 0 8 0   2     0   1   14 9                 23
2043386 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2019   pre_kindergarten 12 1 8 0   2     0   1   12 12                       24.0 12 1 8 0   2     0   1   12 12                 24
2043444 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2019   pre_kindergarten 12 2 20 0   15     0   0   23 26                       49.0 12 2 20 0   15     0   0   23 26                 49
2043587 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2019   pre_kindergarten 12 4 61 0   4     0   2   54 29                       83.0 12 4 61 0   4     0   2   54 29                 83
2044355 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No Elementary PK 05 2019   pre_kindergarten 12 4 9 0   1     0   2   10 18                       28.0 12 4 9 0   1     0   2   10 18                 28
2045454 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 12 0 1 0   0     0   1   9 5                       14.0 12 0 1 0   0     0   1   9 5                 14
2045761 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2019   pre_kindergarten 12 3 1 0   0     0   2   10 8                       18.0 12 3 1 0   0     0   2   10 8                 18
2045771 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   pre_kindergarten 12 2 3 0   1     0   0   11 7                       18.0 12 2 3 0   1     0   0   11 7                 18
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
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
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
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
2048298 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2019   pre_kindergarten 12 5 4 0   0     0   0   11 10                       21.0 12 5 4 0   0     0   0   11 10                 21
2044509 MA Middlesex   school 2508610 207   Newton 250861001657 2070108 Newton Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 120 9 12 0   55     0   16   126 86                       212.0 120 9 12 0   55     0   16   126 86                 212
2044088 MA Worcester   school 2507860 185   Milford 250786001650 1850075 Shining Star Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 121 2 33 0   4     0   1   87 73                       161.0 121 2 33 0   4     0   1   87 73                 161
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
2040326 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2019   pre_kindergarten 13 12 16 0   4     0   1   26 20                       46.0 13 12 16 0   4     0   1   26 20                 46
2040479 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   pre_kindergarten 13 17 10 0   1     0   1   20 22                       42.0 13 17 10 0   1     0   1   20 22                 42
2040747 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   pre_kindergarten 13 15 8 0   32     0   7   40 35                       75.0 13 15 8 0   32     0   7   40 35                 75
2044039 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2019   pre_kindergarten 13 4 19 0   3     0   3   25 17                       42.0 13 4 19 0   3     0   3   25 17                 42
2044329 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No Elementary PK 05 2019   pre_kindergarten 13 7 23 0   4     0   3   28 22                       50.0 13 7 23 0   4     0   3   28 22                 50
2045273 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 J F Kennedy Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 13 37 14 0   14     0   4   57 25                       82.0 13 37 14 0   14     0   4   57 25                 82
2045742 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   pre_kindergarten 13 0 2 0   3     0   0   11 7                       18.0 13 0 2 0   3     0   0   11 7                 18
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
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
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
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
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
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
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
2048510 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   pre_kindergarten 13 1 0 0   0     0   0   9 5                       14.0 13 1 0 0   0     0   0   9 5                 14
2040303 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   pre_kindergarten 130 15 10 0   19     0   8   106 76                       182.0 130 15 10 0   19     0   8   106 76                 182
2039835 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 131 3 12 0   13     0   3   79 83                       162.0 131 3 12 0   13     0   3   79 83                 162
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

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