Data source: Big Local News · About: Big Local

3,669 rows where grade = "pre_kindergarten" and state = "MA"

View and edit SQL

year

grade

  • pre_kindergarten · 3,569
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
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
737178 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 32 0 1 0   0     0   1   17 17                       34 32 0 1 0   0     0   1   17 17                 34
737185 MA Norfolk   school 2503150 46   Brookline 250315002776 460001 Brookline Early Education Program at Beacon   Regular School No 1 PK PK 2015   pre_kindergarten 32 3 8 0   13     0   6   34 28                       62 32 3 8 0   13     0   6   34 28                 62
737186 MA Suffolk   school 2503150 46   Brookline 250315002793 460002 Brookline Early Education Program at Putterham   Regular School No 1 PK PK 2015   pre_kindergarten 41 3 4 0   10     0   6   38 26                       64 41 3 4 0   10     0   6   38 26                 64
737206 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2015   pre_kindergarten 13 1 0 0   1     0   1   9 7                       16 13 1 0 0   1     0   1   9 7                 16
737216 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2015   pre_kindergarten 18 1 1 0   7     0   4   15 16                       31 18 1 1 0   7     0   4   15 16                 31
737253 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2015   pre_kindergarten 5 0 3 0   4     1   1   7 7                       14 5 0 3 0   4     1   1   7 7                 14
737262 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 The Lynch Center   Regular School No 1 PK PK 2015   pre_kindergarten 28 5 3 0   14     0   13   31 32                       63 28 5 3 0   14     0   13   31 32                 63
737263 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   pre_kindergarten 7 1 2 0   3     0   1   7 7                       14 7 1 2 0   3     0   1   7 7                 14
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
737303 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2015   pre_kindergarten 24 16 4 0   7     0   3   31 23                       54 24 16 4 0   7     0   3   31 23                 54
737310 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   pre_kindergarten 11 2 10 0   4     0   1   13 15                       28 11 2 10 0   4     0   1   13 15                 28
737320 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2015   pre_kindergarten 27 15 5 0   5     0   2   31 23                       54 27 15 5 0   5     0   2   31 23                 54
737327 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2015   pre_kindergarten 14 9 2 0   2     0   1   13 15                       28 14 9 2 0   2     0   1   13 15                 28
737334 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2015   pre_kindergarten 10 8 5 0   11     0   5   17 22                       39 10 8 5 0   11     0   5   17 22                 39
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
737348 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No 1 PK 05 2015   pre_kindergarten 17 5 9 0   6     0   2   20 19                       39 17 5 9 0   6     0   2   20 19                 39
737355 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2015   pre_kindergarten 27 10 5 0   6     0   4   30 22                       52 27 10 5 0   6     0   4   30 22                 52
737362 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No 1 PK 05 2015   pre_kindergarten 20 12 1 0   11     0   2   20 26                       46 20 12 1 0   11     0   2   20 26                 46
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
737376 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2015   pre_kindergarten 12 7 1 0   11     0   4   21 14                       35 12 7 1 0   11     0   4   21 14                 35
737383 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2015   pre_kindergarten 8 32 7 0   6     0   1   23 31                       54 8 32 7 0   6     0   1   23 31                 54
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
737433 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   pre_kindergarten 12 0 0 0   0     0   0   4 8                       12 12 0 0 0   0     0   0   4 8                 12
737443 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2015   pre_kindergarten 41 0 0 0   0     0   0   29 12                       41 41 0 0 0   0     0   0   29 12                 41
737457 MA Middlesex   school 2503510 56   Chelmsford 250351002640 560001 Community Education Center   Regular School No 1 PK PK 2015   pre_kindergarten 93 3 12 0   25     0   0   81 52                       133 93 3 12 0   25     0   0   81 52                 133
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
737525 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Szetela Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 196 3 49 0   4     0   2   140 114                       254 196 3 49 0   4     0   2   140 114                 254
737536 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2015   pre_kindergarten 11 1 14 0   0     1   1   15 13                       28 11 1 14 0   0     1   1   15 13                 28
737610 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2015   pre_kindergarten 72 2 18 0   3     0   0   49 46                       95 72 2 18 0   3     0   0   49 46                 95
737619 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2015   pre_kindergarten 16 1 9 0   0     0   1   11 16                       27 16 1 9 0   0     0   1   11 16                 27
737629 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No 1 PK 02 2015   pre_kindergarten 38 0 0 0   0     0   0   23 15                       38 38 0 0 0   0     0   0   23 15                 38
737640 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2015   pre_kindergarten * * * *   *     *   *   3 2                       5                         3 2                 5
737647 MA Middlesex   school 2503840 67   Concord 250384000525 670020 Thoreau   Regular School No 1 PK 05 2015   pre_kindergarten 4 0 0 0   1     0   1   4 2                       6 4 0 0 0   1     0   1   4 2                 6
737663 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2015   pre_kindergarten 13 0 0 0   0     0   1   11 3                       14 13 0 0 0   0     0   1   11 3                 14
737683 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No 1 PK 05 2015   pre_kindergarten 41 3 6 0   2     0   3   39 16                       55 41 3 6 0   2     0   3   39 16                 55
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
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
737767 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 25 0 0 0   0     0   2   14 13                       27 25 0 0 0   0     0   2   14 13                 27
737775 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No 1 PK 01 2015   pre_kindergarten 64 0 2 0   0     0   1   31 36                       67 64 0 2 0   0     0   1   31 36                 67
737795 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 31 5 3 0   1     0   0   28 12                       40 31 5 3 0   1     0   0   28 12                 40
737835 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2015   pre_kindergarten 64 0 1 0   3     0   1   42 27                       69 64 0 1 0   3     0   1   42 27                 69
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
737860 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 7 1 0 0   0     0   0   3 5                       8 7 1 0 0   0     0   0   3 5                 8
737872 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No 1 PK 04 2015   pre_kindergarten 26 0 1 0   1     0   0   16 12                       28 26 0 1 0   1     0   0   16 12                 28
737895 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2015   pre_kindergarten 38 0 1 0   4     0   1   29 15                       44 38 0 1 0   4     0   1   29 15                 44
737910 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No 1 PK 02 2015   pre_kindergarten 18 1 0 0   0     0   0   9 10                       19 18 1 0 0   0     0   0   9 10                 19
737914 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No 1 PK 02 2015   pre_kindergarten 27 2 1 0   1     0   2   23 10                       33 27 2 1 0   1     0   2   23 10                 33
737918 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No 1 PK 02 2015   pre_kindergarten 15 0 0 0   2     0   0   9 8                       17 15 0 0 0   2     0   0   9 8                 17
737932 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   pre_kindergarten * * * *   *     *   *   2 2                       4                         2 2                 4
737942 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 15 0 2 0   0     0   3   11 9                       20 15 0 2 0   0     0   3   11 9                 20
737949 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No 1 PK PK 2015   pre_kindergarten 52 35 79 0   20     0   5   91 100                       191 52 35 79 0   20     0   5   91 100                 191
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
738013 MA Bristol   school 2504800 94   Fairhaven 250480000640 940010 East Fairhaven   Regular School No 1 PK 05 2015   pre_kindergarten 42 1 3 0   0     0   3   24 25                       49 42 1 3 0   0     0   3   24 25                 49
738033 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2015   pre_kindergarten 45 3 6 0   1     0   5   39 21                       60 45 3 6 0   1     0   5   39 21                 60
738052 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2015   pre_kindergarten 6 0 2 0   0     0   1   5 4                       9 6 0 2 0   0     0   1   5 4                 9
738059 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 06 2015   pre_kindergarten 16 2 9 0   1     0   1   18 11                       29 16 2 9 0   1     0   1   18 11                 29
738067 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   pre_kindergarten 10 3 4 0   0     0   3   18 2                       20 10 3 4 0   0     0   3   18 2                 20
738080 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2015   pre_kindergarten 16 1 6 0   0     0   2   12 13                       25 16 1 6 0   0     0   2   12 13                 25
738087 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No 1 PK 05 2015   pre_kindergarten 14 0 4 0   1     0   1   15 5                       20 14 0 4 0   1     0   1   15 5                 20
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
738134 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   pre_kindergarten 8 1 1 0   0     0   2   9 3                       12 8 1 1 0   0     0   2   9 3                 12
738159 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 46 6 44 0   5     0   4   60 45                       105 46 6 44 0   5     0   4   60 45                 105
738174 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 11 3 12 0   1     0   3   20 10                       30 11 3 12 0   1     0   3   20 10                 30
738184 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   pre_kindergarten 4 2 5 0   0     0   0   6 5                       11 4 2 5 0   0     0   0   6 5                 11
738193 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2015   pre_kindergarten 4 3 10 0   2     0   1   12 8                       20 4 3 10 0   2     0   1   12 8                 20
738204 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   pre_kindergarten 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
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
738237 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No 1 PK PK 2015   pre_kindergarten 87 12 34 0   11     0   9   93 60                       153 87 12 34 0   11     0   9   93 60                 153
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
738358 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   pre_kindergarten 63 3 6 0   0     0   3   40 35                       75 63 3 6 0   0     0   3   40 35                 75
738374 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Perley Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 83 0 2 0   4     0   1   44 46                       90 83 0 2 0   4     0   1   44 46                 90
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
738428 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 36 0 3 0   11     0   5   26 29                       55 36 0 3 0   11     0   5   26 29                 55
738431 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2015   pre_kindergarten 44 0 3 0   4     0   1   32 20                       52 44 0 3 0   4     0   1   32 20                 52
738454 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2015   pre_kindergarten 18 0 3 0   0     0   1   14 8                       22 18 0 3 0   0     0   1   14 8                 22
738464 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 The Academy of Early Learning at North Parish   Regular School No 1 PK PK 2015   pre_kindergarten 95 0 10 0   0     0   0   53 52                       105 95 0 10 0   0     0   0   53 52                 105
738492 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 31 1 3 0   0     1   2   21 17                       38 31 1 3 0   0     1   2   21 17                 38
738514 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 10 0 0 0   0     0   0   7 3                       10 10 0 0 0   0     0   0   7 3                 10
738521 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 49 0 1 0   0     0   1   38 13                       51 49 0 1 0   0     0   1   38 13                 51
738541 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Hildreth Elementary School   Regular School No 1 PK 05 2015   pre_kindergarten 4 2 0 0   2     0   0   4 4                       8 4 2 0 0   2     0   0   4 4                 8
738555 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 17 0 0 0   0     0   0   12 5                       17 17 0 0 0   0     0   0   12 5                 17
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
738637 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   pre_kindergarten 69 0 1 0   0     0   0   47 23                       70 69 0 1 0   0     0   0   47 23                 70
738670 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No 1 PK 03 2015   pre_kindergarten 45 4 2 0   4     1   3   42 17                       59 45 4 2 0   4     1   3   42 17                 59
738685 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 37 0 0 0   0     0   0   23 14                       37 37 0 0 0   0     0   0   23 14                 37
738696 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2015   pre_kindergarten 67 0 6 0   7     0   1   50 31                       81 67 0 6 0   7     0   1   50 31                 81
738708 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK KG 2015   pre_kindergarten 56 8 128 0   3     0   6   122 79                       201 56 8 128 0   3     0   6   122 79                 201
738719 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   pre_kindergarten 0 1 19 0   0     0   0   10 10                       20 0 1 19 0   0     0   0   10 10                 20
738781 MA Worcester   school 2506300 138   Hopedale 250630002041 1380003 Park Street School   Regular School No 1 PK PK 2015   pre_kindergarten 80 0 3 0   0     0   7   49 41                       90 80 0 3 0   0     0   7   49 41                 90
738795 MA Middlesex   school 2506330 139   Hopkinton 250633002043 1390003 Hopkinton Pre-School   Regular School No 1 PK PK 2015   pre_kindergarten 47 0 0 0   2     0   0   21 28                       49 47 0 0 0   2     0   0   21 28                 49
738811 MA Middlesex   school 2506390 141   Hudson 250639000924 1410007 Mulready Elementary   Regular School No 1 PK 04 2015   pre_kindergarten 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
738822 MA Middlesex   school 2506390 141   Hudson 250639000922 1410030 C A Farley   Regular School No 1 PK 04 2015   pre_kindergarten 9 0 1 0   1     0   1   6 6                       12 9 0 1 0   1     0   1   6 6                 12
738830 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No 3 08 12 2015   pre_kindergarten 75 0 5 0   3     0   5   39 49                       88 75 0 5 0   3     0   5   39 49                 88
738837 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Lillian M Jacobs   Regular School No 1 PK 05 2015   pre_kindergarten 44 1 0 0   0     0   0   28 17                       45 44 1 0 0   0     0   0   28 17                 45
738851 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Paul F Doyon Memorial   Regular School No 1 PK 05 2015   pre_kindergarten 24 0 0 0   1     0   0   16 9                       25 24 0 0 0   1     0   0   16 9                 25
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
738880 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   pre_kindergarten 21 0 0 0   0     0   1   6 16                       22 21 0 0 0   0     0   1   6 16                 22
738888 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No 1 PK KG 2015   pre_kindergarten 16 1 76 0   0     0   0   49 44                       93 16 1 76 0   0     0   0   49 44                 93
738891 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No 1 PK KG 2015   pre_kindergarten 19 4 180 0   6     0   0   119 90                       209 19 4 180 0   6     0   0   119 90                 209

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