Data source: Big Local News · About: Big Local

536 rows where grade = "pre_kindergarten", state = "MA" and year = 2020 sorted by unknown_race

View and edit SQL

year

  • 2020 · 436

grade

  • pre_kindergarten · 436
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
1366128 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 27 0 6 0   0     0   1   21 13 *                     34.0 27 0 6 0   0     0   1   21 13                 34
1366135 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 32 0 1 0   0     0   0   15 18 *                     33.0 32 0 1 0   0     0   0   15 18                 33
1366143 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2020   pre_kindergarten 11 57 13 0   1     0   5   47 40 *                     87.0 11 57 13 0   1     0   5   47 40                 87
1366161 MA Plymouth   school 2503090 44   Brockton 250309002792 440008 Barrett Russell Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 45 131 44 1   2     1   13   133 104 *                     237.0 45 131 44 1   2     1   13   133 104                 237
1366256 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 20 0 1 0   0     0   2   12 11 *                     23.0 20 0 1 0   0     0   2   12 11                 23
1366263 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline Early Education Program at Beacon   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 23 1 2 0   15     0   7   28 20 *                     48.0 23 1 2 0   15     0   7   28 20                 48
1366264 MA Norfolk   school 2503150 46   Brookline 250315002793 460002 Brookline Early Education Program at Putterham   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 30 2 5 0   15     0   4   29 27 *                     56.0 30 2 5 0   15     0   4   29 27                 56
1366265 MA Norfolk   school 2503150 46   Brookline 250315002904 460003 Brookline Early Education Program at Clark Road   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 8 1 2 0   5     0   1   9 8 *                     17.0 8 1 2 0   5     0   1   9 8                 17
1366276 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   pre_kindergarten 10 2 4 0   10     0   5   11 20 *                     31.0 10 2 4 0   10     0   5   11 20                 31
1366295 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2020   pre_kindergarten 18 0 0 0   5     0   4   11 16 *                     27.0 18 0 0 0   5     0   4   11 16                 27
1366332 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   pre_kindergarten 6 0 2 0   4     0   4   8 8 *                     16.0 6 0 2 0   4     0   4   8 8                 16
1366341 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 The Lynch Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 22 9 5 0   11     0   10   33 24 *                     57.0 22 9 5 0   11     0   10   33 24                 57
1366375 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2020   pre_kindergarten 56 8 8 0   30     0   1   61 42 *                     103.0 56 8 8 0   30     0   1   61 42                 103
1366381 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2020   pre_kindergarten 24 3 4 0   2     0   3   19 17 *                     36.0 24 3 4 0   2     0   3   19 17                 36
1366388 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   pre_kindergarten 10 1 15 0   2     0   2   13 17 *                     30.0 10 1 15 0   2     0   2   13 17                 30
1366398 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2020   pre_kindergarten 25 9 6 0   8     0   6   29 23 *                     54.0 25 9 6 0   8     0   6   29 23                 54
1366405 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No Elementary PK 05 2020   pre_kindergarten 15 3 4 0   2     0   3   13 14 *                     27.0 15 3 4 0   2     0   3   13 14                 27
1366412 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2020   pre_kindergarten 6 3 3 0   13     0   7   13 19 *                     32.0 6 3 3 0   13     0   7   13 19                 32
1366419 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2020   pre_kindergarten 20 3 2 0   7     0   6   25 13 *                     38.0 20 3 2 0   7     0   6   25 13                 38
1366426 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2020   pre_kindergarten 14 11 5 0   23     0   6   29 30 *                     59.0 14 11 5 0   23     0   6   29 30                 59
1366433 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2020   pre_kindergarten 33 8 12 0   12     0   3   34 34 *                     68.0 33 8 12 0   12     0   3   34 34                 68
1366440 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2020   pre_kindergarten 13 11 5 0   10     0   7   24 22 *                     46.0 13 11 5 0   10     0   7   24 22                 46
1366447 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2020   pre_kindergarten 50 17 7 0   10     0   6   45 45 *                     90.0 50 17 7 0   10     0   6   45 45                 90
1366454 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2020   pre_kindergarten 21 5 5 0   6     0   4   23 18 *                     41.0 21 5 5 0   6     0   4   23 18                 41
1366461 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2020   pre_kindergarten 8 20 11 0   8     0   3   24 26 *                     50.0 8 20 11 0   8     0   3   24 26                 50
1366484 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 48 13 10 0   13     0   3   54 33 *                     87.0 48 13 10 0   13     0   3   54 33                 87
1366512 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   pre_kindergarten 8 0 0 0   3     1   2   11 3 *                     14.0 8 0 0 0   3     1   2   11 3                 14
1366522 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 62 1 0 0   1     0   0   37 27 *                     64.0 62 1 0 0   1     0   0   37 27                 64
1366536 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Community Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 95 8 15 1   39     0   8   104 62 *                     166.0 95 8 15 1   39     0   8   104 62                 166
1366570 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   pre_kindergarten 27 18 239 0   0     0   6   151 139 *                     290.0 27 18 239 0   0     0   6   151 139                 290
1366610 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Szetela Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 141 8 76 0   10     0   14   152 97 *                     249.0 141 8 76 0   10     0   14   152 97                 249
1366692 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 61 2 31 0   1     0   3   54 44 *                     98.0 61 2 31 0   1     0   3   54 44                 98
1366701 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2020   pre_kindergarten 10 1 4 0   0     0   1   9 7 *                     16.0 10 1 4 0   0     0   1   9 7                 16
1366710 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2020   pre_kindergarten 22 0 1 0   0     0   1   13 11 *                     24.0 22 0 1 0   0     0   1   13 11                 24
1366721 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2020   pre_kindergarten 7 0 0 0   0     0   0   2 5 *                     7.0 7 0 0 0   0     0   0   2 5                 7
1366728 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No Elementary PK 05 2020   pre_kindergarten 6 0 3 0   0     0   1   6 4 *                     10.0 6 0 3 0   0     0   1   6 4                 10
1366735 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Willard   Regular School No Elementary PK 05 2020   pre_kindergarten 8 0 0 0   1     0   0   4 5 *                     9.0 8 0 0 0   1     0   0   4 5                 9
1366745 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2020   pre_kindergarten 15 0 1 0   0     0   0   12 4 *                     16.0 15 0 1 0   0     0   0   12 4                 16
1366765 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No Elementary PK 05 2020   pre_kindergarten 94 4 8 0   1     0   1   59 49 *                     108.0 94 4 8 0   1     0   1   59 49                 108
1366792 MA Bristol   school 2504020 72   Dartmouth 250402002698 720005 Andrew B. Cushman School   Regular School No Elementary PK KG 2020   pre_kindergarten 64 1 4 0   1     0   7   53 24 *                     77.0 64 1 4 0   1     0   7   53 24                 77
1366799 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 George H Potter   Regular School No Elementary PK 05 2020   pre_kindergarten 15 0 0 0   0     0   0   11 4 *                     15.0 15 0 0 0   0     0   0   11 4                 15
1366819 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten 96 8 12 0   2     0   11   70 59 *                     129.0 96 8 12 0   2     0   11   70 59                 129
1366849 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 32 0 2 0   0     0   6   27 13 *                     40.0 32 0 2 0   0     0   6   27 13                 40
1366857 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2020   pre_kindergarten 54 1 3 0   1     0   0   24 35 *                     59.0 54 1 3 0   1     0   0   24 35                 59
1366871 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No Elementary PK 05 2020   pre_kindergarten 6 0 0 0   1     0   2   7 2 *                     9.0 6 0 0 0   1     0   2   7 2                 9
1366878 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 34 8 5 0   6     0   0   30 23 *                     53.0 34 8 5 0   6     0   0   30 23                 53
1366913 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 58 1 2 0   0     0   5   40 26 *                     66.0 58 1 2 0   0     0   5   40 26                 66
1366924 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2020   pre_kindergarten 99 4 5 0   3     0   3   56 58 *                     114.0 99 4 5 0   3     0   3   56 58                 114
1366938 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 21 4 1 0   0     0   3   13 16 *                     29.0 21 4 1 0   0     0   3   13 16                 29
1366950 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No Elementary PK 04 2020   pre_kindergarten 45 1 6 0   0     0   3   28 27 *                     55.0 45 1 6 0   0     0   3   28 27                 55
1366973 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   pre_kindergarten 30 4 9 0   1     0   4   29 19 *                     48.0 30 4 9 0   1     0   4   29 19                 48
1366987 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2020   pre_kindergarten 13 1 2 0   2     0   0   12 6 *                     18.0 13 1 2 0   2     0   0   12 6                 18
1366991 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 30 4 2 0   3     0   4   26 17 *                     43.0 30 4 2 0   3     0   4   26 17                 43
1366995 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2020   pre_kindergarten 10 0 0 0   2     0   0   7 5 *                     12.0 10 0 0 0   2     0   0   7 5                 12
1367010 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten 2 0 3 1   0     0   0   2 4 *                     6.0 2 0 3 1   0     0   0   2 4                 6
1367020 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 21 0 2 0   0     0   4   19 8 *                     27.0 21 0 2 0   0     0   4   19 8                 27
1367027 MA Middlesex   school 2504770 93   Everett 250477002900 930001 Webster Extension   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 40 37 108 0   23     0   3   103 108 *                     211.0 40 37 108 0   23     0   3   103 108                 211
1367028 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 26 23 67 0   10     0   1   65 62 *                     127.0 26 23 67 0   10     0   1   65 62                 127
1367039 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No Elementary PK 05 2020   pre_kindergarten 0 2 4 0   1     0   0   5 2 *                     7.0 0 2 4 0   1     0   0   5 2                 7
1367093 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No Elementary PK 05 2020   pre_kindergarten 20 0 1 0   1     0   1   13 10 *                     23.0 20 0 1 0   1     0   1   13 10                 23
1367100 MA Bristol   school 2504800 94   Fairhaven 250480000645 940030 Leroy Wood   Regular School No Elementary PK 05 2020   pre_kindergarten 20 1 1 0   0     0   0   13 9 *                     22.0 20 1 1 0   0     0   0   13 9                 22
1367115 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 48 4 24 0   0     0   6   48 34 *                     82.0 48 4 24 0   0     0   6   48 34                 82
1367128 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 15 0 12 0   0     0   5   15 17 *                     32.0 15 0 12 0   0     0   5   15 17                 32
1367135 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 22 2 11 0   0     0   4   28 11 *                     39.0 22 2 11 0   0     0   4   28 11                 39
1367142 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   pre_kindergarten 21 2 10 0   2     0   3   29 9 *                     38.0 21 2 10 0   2     0   3   29 9                 38
1367152 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   pre_kindergarten 13 0 2 0   3     0   2   10 10 *                     20.0 13 0 2 0   3     0   2   10 10                 20
1367162 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2020   pre_kindergarten 22 3 11 0   3     0   2   26 15 *                     41.0 22 3 11 0   3     0   2   26 15                 41
1367169 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary PK 05 2020   pre_kindergarten 8 0 4 0   0     0   3   8 7 *                     15.0 8 0 4 0   0     0   3   8 7                 15
1367214 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 74 5 7 1   2     0   1   52 38 *                     90.0 74 5 7 1   2     0   1   52 38                 90
1367220 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   pre_kindergarten 14 1 7 0   0     0   3   17 8 *                     25.0 14 1 7 0   0     0   3   17 8                 25
1367245 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 16 2 31 0   3     0   2   32 22 *                     54.0 16 2 31 0   3     0   2   32 22                 54
1367251 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 16 0 10 0   1     0   3   22 8 *                     30.0 16 0 10 0   1     0   3   22 8                 30
1367261 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 4 3 22 0   1     0   4   18 16 *                     34.0 4 3 22 0   1     0   4   18 16                 34
1367271 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2020   pre_kindergarten 8 3 8 0   1     0   2   15 7 *                     22.0 8 3 8 0   1     0   2   15 7                 22
1367280 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2020   pre_kindergarten 6 0 20 0   1     0   3   18 12 *                     30.0 6 0 20 0   1     0   3   18 12                 30
1367291 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   pre_kindergarten 22 0 0 0   0     0   0   15 7 *                     22.0 22 0 0 0   0     0   0   15 7                 22
1367300 MA Norfolk   school 2504950 99   Foxborough 250495000710 990015 Mabelle M Burrell   Regular School No Elementary PK 04 2020   pre_kindergarten 61 7 6 1   8     0   2   48 37 *                     85.0 61 7 6 1   8     0   2   48 37                 85
1367324 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 176 18 75 1   30     1   8   197 112 *                     309.0 176 18 75 1   30     1   8   197 112                 309
1367392 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 87 2 1 0   10     6   5   67 44 *                     111.0 87 2 1 0   10     6   5   67 44                 111
1367447 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   pre_kindergarten 46 4 17 0   4     0   4   40 35 *                     75.0 46 4 17 0   4     0   4   40 35                 75
1367461 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 77 0 0 0   1     0   7   45 40 *                     85.0 77 0 0 0   1     0   7   45 40                 85
1367487 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester PreSchool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 97 2 6 0   5     0   6   71 45 *                     116.0 97 2 6 0   5     0   6   71 45                 116
1367515 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 47 3 6 0   14     0   0   40 30 *                     70.0 47 3 6 0   14     0   0   40 30                 70
1367518 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 32 0 2 0   12     0   1   27 20 *                     47.0 32 0 2 0   12     0   1   27 20                 47
1367537 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2020   pre_kindergarten 25 0 5 1   2     0   4   24 13 *                     37.0 25 0 5 1   2     0   4   24 13                 37
1367550 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 93 2 20 0   1     0   5   69 52 *                     121.0 93 2 20 0   1     0   5   69 52                 121
1367575 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 29 0 4 0   2     0   0   18 17 *                     35.0 29 0 4 0   2     0   0   18 17                 35
1367596 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 6 1 0 0   1     0   0   4 4 *                     8.0 6 1 0 0   1     0   0   4 4                 8
1367603 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 75 1 1 0   3     0   0   42 38 *                     80.0 75 1 1 0   3     0   0   42 38                 80
1367617 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 11 0 3 0   2     0   1   11 6 *                     17.0 11 0 3 0   2     0   1   11 6                 17
1367631 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 17 0 0 0   0     0   0   10 7 *                     17.0 17 0 0 0   0     0   0   10 7                 17
1367666 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 114 22 65 1   5     0   0   128 79 *                     207.0 114 22 65 1   5     0   0   128 79                 207
1367720 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 63 1 3 0   2     0   1   42 28 *                     70.0 63 1 3 0   2     0   1   42 28                 70
1367753 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2020   pre_kindergarten 23 10 7 1   0     0   1   22 20 *                     42.0 23 10 7 1   0     0   1   22 20                 42
1367768 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 34 0 2 0   1     0   1   16 22 *                     38.0 34 0 2 0   1     0   1   16 22                 38
1367779 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 85 2 1 1   12     0   4   68 37 *                     105.0 85 2 1 1   12     0   4   68 37                 105
1367790 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No Elementary PK 05 2020   pre_kindergarten 8 0 26 0   0     0   2   21 15 *                     36.0 8 0 26 0   0     0   2   21 15                 36
1367797 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten 9 1 15 0   1     0   0   12 14 *                     26.0 9 1 15 0   1     0   0   12 14                 26
1367807 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 04 2020   pre_kindergarten 9 4 100 0   1     0   6   69 51 *                     120.0 9 4 100 0   1     0   6   69 51                 120
1367818 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2020   pre_kindergarten 2 1 23 0   0     0   0   16 10 *                     26.0 2 1 23 0   0     0   0   16 10                 26

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