Data source: Big Local News · About: Big Local

989 rows where grade = "grade_1", state = "MA" and year = 2018 sorted by white

View and edit SQL

year

  • 2018 · 989

grade

  • grade_1 · 989
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
2229998 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2231638 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2232016 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2232238 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2233065 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2233130 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell: Lowell Day School on Broadway   Special Education School No Elementary PK 06 2018   grade_1 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2237222 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2229422 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Boston: Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2018   grade_1 0 36 9 0   0     0   3   21 27                       48.0 0 36 9 0   0     0   3   21 27                 48
2229492 MA Suffolk   school 2502790 35   Boston 250279000220 350072 Boston: David A Ellis   Regular School No Elementary PK 05 2018   grade_1 0 38 42 0   0     0   3   41 42                       83.0 0 38 42 0   0     0   3   41 42                 83
2229830 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston: Patrick J Kennedy   Regular School No Elementary PK 05 2018   grade_1 0 2 36 0   1     0   0   19 20                       39.0 0 2 36 0   1     0   0   19 20                 39
2229890 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_1 0 7 34 0   0     0   2   21 22                       43.0 0 7 34 0   0     0   2   21 22                 43
2230019 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston: Young Achievers   Alternative School No Elementary PK 08 2018   grade_1 0 28 32 0   0     0   1   29 32                       61.0 0 28 32 0   0     0   1   29 32                 61
2232373 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke: Morgan Full Service Community School   Regular School No Elementary PK 08 2018   grade_1 0 0 40 0   1     0   1   19 23                       42.0 0 0 40 0   1     0   1   19 23                 42
2233268 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn: William R Fallon   Regular School No Elementary KG 06 2018   grade_1 0 0 5 0   0     0   1   5 1                       6.0 0 0 5 0   0     0   1   5 1                 6
2237715 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester: Lincoln Street   Regular School No Elementary KG 06 2018   grade_1 0 7 17 1   1     0   0   15 11                       26.0 0 7 17 1   1     0   0   15 11                 26
2237920 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School (District): Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2018   grade_1 0 29 14 0   0     0   0   22 21                       43.0 0 29 14 0   0     0   0   22 21                 43
2237986 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District): Bridge Boston Charter School   Regular School Yes Elementary PK 06 2018   grade_1 0 33 7 0   0     0   0   14 26                       40.0 0 33 7 0   0     0   0   14 26                 40
2238016 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District): Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 06 2018   grade_1 0 0 42 0   0     0   0   14 28                       42.0 0 0 42 0   0     0   0   14 28                 42
2238097 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_1 0 16 4 0   0     0   0   7 13                       20.0 0 16 4 0   0     0   0   7 13                 20
2238232 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   grade_1 0 0 83 0   0     0   0   35 48                       83.0 0 0 83 0   0     0   0   35 48                 83
2238462 MA Hampden   school 2500089 492   Martin Luther King Jr. Charter School of Excellence (District) 250008902127 4920005 Martin Luther King Jr. Charter School of Excellence (District): Martin Luther King Jr. Charter School of Excellence   Regular School Yes Elementary KG 05 2018   grade_1 0 14 38 0   2     0   5   29 30                       59.0 0 14 38 0   2     0   5   29 30                 59
2229371 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   grade_1 1 6 6 0   2     0   0   8 7                       15.0 1 6 6 0   2     0   0   8 7                 15
2229396 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Boston: Haynes Early Education Center   Regular School No Elementary PK 01 2018   grade_1 1 40 29 0   2     0   6   41 37                       78.0 1 40 29 0   2     0   6   41 37                 78
2229428 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Boston: Higginson   Regular School No Elementary PK 02 2018   grade_1 1 15 24 0   0     0   2   23 19                       42.0 1 15 24 0   0     0   2   23 19                 42
2229468 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston: Charles H Taylor   Regular School No Elementary PK 05 2018   grade_1 1 56 26 1   0     0   1   44 41                       85.0 1 56 26 1   0     0   1   44 41                 85
2229530 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston: Edward Everett   Regular School No Elementary PK 05 2018   grade_1 1 11 12 1   9     0   4   25 13                       38.0 1 11 12 1   9     0   4   25 13                 38
2229584 MA Suffolk   school 2502790 35   Boston 250279002569 350138 Boston: O W Holmes   Regular School No Elementary PK 05 2018   grade_1 1 30 20 0   0     0   2   25 28                       53.0 1 30 20 0   0     0   2   25 28                 53
2229746 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston: Maurice J Tobin   Regular School No Elementary PK 08 2018   grade_1 1 15 35 0   0     1   1   25 28                       53.0 1 15 35 0   0     1   1   25 28                 53
2229801 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_1 1 44 40 1   2     1   3   46 46                       92.0 1 44 40 1   2     1   3   46 46                 92
2229937 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_1 1 1 4 0   0     0   1   6 1                       7.0 1 1 4 0   0     0   1   6 1                 7
2229951 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston: William E Russell   Regular School No Elementary PK 05 2018   grade_1 1 17 35 1   3     0   3   32 28                       60.0 1 17 35 1   3     0   3   32 28                 60
2229959 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_1 1 37 18 0   0     0   1   24 33                       57.0 1 37 18 0   0     0   1   24 33                 57
2230045 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Boston: Blackstone   Regular School No Elementary PK 05 2018   grade_1 1 17 59 0   3     0   2   43 39                       82.0 1 17 59 0   3     0   2   43 39                 82
2232390 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_1 1 0 61 0   0     0   0   33 29                       62.0 1 0 61 0   0     0   0   33 29                 62
2232587 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence: Community Day Arlington   Regular School No Elementary KG 04 2018   grade_1 1 2 110 0   0     0   3   54 62                       116.0 1 2 110 0   0     0   3   54 62                 116
2232615 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 Lawrence: James F Hennessey   Regular School No Elementary PK 02 2018   grade_1 1 2 76 0   1     0   0   38 42                       80.0 1 2 76 0   1     0   0   38 42                 80
2232634 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_1 1 0 90 0   0     0   1   45 47                       92.0 1 0 90 0   0     0   1   45 47                 92
2232663 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_1 1 0 76 0   1     0   1   41 38                       79.0 1 0 76 0   1     0   1   41 38                 79
2235937 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Springfield: Milton Bradley School   Regular School No Elementary PK 05 2018   grade_1 1 15 75 0   0     0   0   43 48                       91.0 1 15 75 0   0     0   0   43 48                 91
2235944 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Springfield: Brightwood   Regular School No Elementary KG 05 2018   grade_1 1 14 29 0   0     0   0   24 20                       44.0 1 14 29 0   0     0   0   24 20                 44
2238003 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District): Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2018   grade_1 1 40 5 0   0     0   2   23 25                       48.0 1 40 5 0   0     0   2   23 25                 48
2238062 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District): Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 06 2018   grade_1 1 1 41 0   0     0   0   21 22                       43.0 1 1 41 0   0     0   0   21 22                 43
2238253 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public (District): Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2018   grade_1 1 21 53 0   15     0   4   35 59                       94.0 1 21 53 0   15     0   4   35 59                 94
2238362 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   grade_1 1 79 56 0   1     0   4   62 79                       141.0 1 79 56 0   1     0   4   62 79                 141
2229382 MA Suffolk   school 2502790 35   Boston 250279002514 350006 Boston: ELC - West Zone   Regular School No Elementary PK 01 2018   grade_1 10 10 11 1   1     0   1   19 15                       34.0 10 10 11 1   1     0   1   19 15                 34
2229629 MA Suffolk   school 2502790 35   Boston 250279000257 350156 Boston: James Otis   Regular School No Elementary PK 05 2018   grade_1 10 4 43 0   0     0   2   30 29                       59.0 10 4 43 0   0     0   2   30 29                 59
2231426 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving: Erving Elementary   Regular School No Elementary PK 06 2018   grade_1 10 0 0 0   0     0   3   8 5                       13.0 10 0 0 0   0     0   3   8 5                 13
2232608 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence: Robert Frost   Regular School No Elementary KG 04 2018   grade_1 10 3 110 0   3     0   1   60 67                       127.0 10 3 110 0   3     0   1   60 67                 127
2233255 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lynn: Lincoln-Thomson   Regular School No Elementary KG 05 2018   grade_1 10 7 23 0   6     0   0   27 19                       46.0 10 7 23 0   6     0   0   27 19                 46
2233295 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn: Tracy   Regular School No Elementary 01 05 2018   grade_1 10 9 66 0   6     0   4   48 47                       95.0 10 9 66 0   6     0   4   48 47                 95
2234102 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 New Bedford: Irwin M. Jacobs Elementary School   Regular School No Elementary PK 05 2018   grade_1 10 7 28 0   0     0   0   22 23                       45.0 10 7 28 0   0     0   0   22 23                 45
2235214 MA Norfolk   school 2509930 244   Randolph 250993001592 2440015 Randolph: Margaret L Donovan   Regular School No Elementary KG 05 2018   grade_1 10 32 10 0   11     0   6   38 31                       69.0 10 32 10 0   11     0   6   38 31                 69
2235681 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Shrewsbury: Beal School   Regular School No Elementary KG 01 2018   grade_1 10 1 2 0   38     0   4   31 24                       55.0 10 1 2 0   38     0   4   31 24                 55
2235999 MA Hampden   school 2511130 281   Springfield 251113001562 2810068 Springfield: Glickman Elementary   Regular School No Elementary KG 05 2018   grade_1 10 15 36 0   1     0   1   31 32                       63.0 10 15 36 0   1     0   1   31 32                 63
2236069 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Springfield: Mary A. Dryden Veterans Memorial School   Regular School No Elementary PK 05 2018   grade_1 10 8 29 0   4     0   0   33 18                       51.0 10 8 29 0   4     0   0   33 18                 51
2237596 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Worcester: Canterbury   Regular School No Elementary PK 06 2018   grade_1 10 7 31 0   11     0   1   33 27                       60.0 10 7 31 0   11     0   1   33 27                 60
2238958 MA Hampshire   school 2505160 672   Gateway 250516000757 6720059 Gateway: Chester Elementary   Regular School No Elementary PK 05 2018   grade_1 10 0 1 1   0     0   0   7 5                       12.0 10 0 1 1   0     0   0   7 5                 12
2235053 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth: South Elementary   Regular School No Elementary KG 05 2018   grade_1 100 1 2 1   0     0   8   67 45                       112.0 100 1 2 1   0     0   8   67 45                 112
2238933 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Freetown-Lakeville: Assawompset Elementary School   Regular School No Elementary KG 03 2018   grade_1 100 1 2 0   0     0   3   55 51                       106.0 100 1 2 0   0     0   3   55 51                 106
2236340 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge: Burgess Elementary   Regular School No Elementary PK 06 2018   grade_1 101 0 3 0   3     0   2   58 51                       109.0 101 0 3 0   3     0   2   58 51                 109
2232910 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Littleton: Shaker Lane Elementary   Regular School No Elementary PK 02 2018   grade_1 102 0 0 0   8     0   3   58 55                       113.0 102 0 0 0   8     0   3   58 55                 113
2233154 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg: Lunenburg Primary School   Regular School No Elementary PK 02 2018   grade_1 102 2 9 0   4     0   3   62 58                       120.0 102 2 9 0   4     0   3   62 58                 120
2234516 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 North Attleborough: Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2018   grade_1 103 3 5 0   4     0   3   67 51                       118.0 103 3 5 0   4     0   3   67 51                 118
2233786 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough: Mary K. Goode Elementary School   Regular School No Elementary 01 05 2018   grade_1 105 3 1 0   1     0   3   62 51                       113.0 105 3 1 0   1     0   3   62 51                 113
2237905 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   grade_1 105 2 9 0   3     0   3   64 58                       122.0 105 2 9 0   3     0   3   64 58                 122
2239653 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Wachusett: Naquag Elementary School   Regular School No Elementary KG 02 2018   grade_1 105 2 6 0   0     0   2   58 57                       115.0 105 2 6 0   0     0   2   58 57                 115
2231056 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset: Joseph Osgood   Regular School No Elementary PK 02 2018   grade_1 109 2 2 0   2     0   4   63 56                       119.0 109 2 2 0   2     0   4   63 56                 119
2229400 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_1 11 6 6 0   1     0   0   13 11                       24.0 11 6 6 0   1     0   0   13 11                 24
2229858 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston: Josiah Quincy   Regular School No Elementary PK 05 2018   grade_1 11 13 13 0   80     0   3   61 59                       120.0 11 13 13 0   80     0   3   61 59                 120
2230410 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton: Manthala George Jr. School   Regular School No Elementary KG 05 2018   grade_1 11 59 79 0   2     0   7   77 81                       158.0 11 59 79 0   2     0   7   77 81                 158
2234110 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 New Bedford: Ellen R Hathaway   Regular School No Elementary PK 05 2018   grade_1 11 9 18 1   0     0   1   21 19                       40.0 11 9 18 1   0     0   1   21 19                 40
2234132 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 New Bedford: Carlos Pacheco   Regular School No Elementary KG 05 2018   grade_1 11 14 30 0   0     0   3   29 29                       58.0 11 14 30 0   0     0   3   29 29                 58
2235436 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_1 11 0 1 0   0     0   1   8 5                       13.0 11 0 1 0   0     0   1   8 5                 13
2236120 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Springfield: Warner   Regular School No Elementary PK 05 2018   grade_1 11 9 17 0   0     0   2   19 20                       39.0 11 9 17 0   0     0   2   19 20                 39
2236709 MA Middlesex   school 2512000 308   Waltham 251200002863 3080001 Waltham: Waltham Public Schools Dual Language Program   Regular School No Elementary KG 01 2018   grade_1 11 1 25 0   2     0   1   21 19                       40.0 11 1 25 0   2     0   1   21 19                 40
2237563 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Worcester: Belmont Street Community   Regular School No Elementary PK 06 2018   grade_1 11 16 35 0   8     0   5   43 32                       75.0 11 16 35 0   8     0   5   43 32                 75
2237817 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester: Union Hill School   Regular School No Elementary KG 06 2018   grade_1 11 8 37 0   1     0   4   31 30                       61.0 11 8 37 0   1     0   4   31 30                 61
2237835 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_1 11 13 35 0   3     0   4   34 32                       66.0 11 13 35 0   3     0   4   34 32                 66
2238148 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   grade_1 11 16 7 0   2     0   4   15 25                       40.0 11 16 7 0   2     0   4   15 25                 40
2239225 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail: Colrain Central   Regular School No Elementary PK 06 2018   grade_1 11 0 1 0   0     0   1   5 8                       13.0 11 0 1 0   0     0   1   5 8                 13
2234769 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Oxford: Alfred M Chaffee   Regular School No Elementary PK 01 2018   grade_1 113 4 12 0   1     0   8   75 63                       138.0 113 4 12 0   1     0   8   75 63                 138
2236534 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Tewksbury: Heath-Brook   Regular School No Elementary KG 02 2018   grade_1 114 2 6 0   6     0   0   69 59                       128.0 114 2 6 0   6     0   0   69 59                 128
2237377 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington: Woburn Street   Regular School No Elementary 01 03 2018   grade_1 114 6 3 1   3     0   5   71 61                       132.0 114 6 3 1   3     0   5   71 61                 132
2236786 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham: John William Decas   Regular School No Elementary KG 02 2018   grade_1 116 12 12 1   1     0   17   69 90                       159.0 116 12 12 1   1     0   17   69 90                 159
2232143 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover: Center Elementary   Regular School No Elementary KG 02 2018   grade_1 117 1 3 0   1     0   1   66 57                       123.0 117 1 3 0   1     0   1   66 57                 123
2236602 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge: Taft Early Learning Center   Regular School No Elementary PK 02 2018   grade_1 117 0 5 0   0     0   3   68 57                       125.0 117 0 5 0   0     0   3   68 57                 125
2235890 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 South Hadley: Plains Elementary   Regular School No Elementary PK 01 2018   grade_1 118 1 16 0   5     0   4   68 76                       144.0 118 1 16 0   5     0   4   68 76                 144
2234380 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 Norfolk: H Olive Day   Regular School No Elementary PK 02 2018   grade_1 119 1 1 0   5     0   7   70 63                       133.0 119 1 1 0   5     0   7   70 63                 133
2229460 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Boston: Charles Sumner   Regular School No Elementary PK 05 2018   grade_1 12 15 50 0   0     0   8   47 38                       85.0 12 15 50 0   0     0   8   47 38                 85
2231454 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_1 12 7 58 0   9     0   0   40 46                       86.0 12 7 58 0   9     0   0   40 46                 86
2232362 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_1 12 2 23 0   2     0   1   25 15                       40.0 12 2 23 0   2     0   1   25 15                 40
2232411 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke: Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2018   grade_1 12 0 54 0   1     0   0   35 32                       67.0 12 0 54 0   1     0   0   35 32                 67
2234094 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 New Bedford: Alfred J Gomes   Regular School No Elementary PK 05 2018   grade_1 12 14 74 0   2     0   2   51 53                       104.0 12 14 74 0   2     0   2   51 53                 104
2236098 MA Hampden   school 2511130 281   Springfield 251113001830 2810160 Springfield: Sumner Avenue   Regular School No Elementary PK 05 2018   grade_1 12 13 53 0   2     0   6   46 40                       86.0 12 13 53 0   2     0   6   46 40                 86
2237640 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Worcester: Columbus Park   Regular School No Elementary PK 06 2018   grade_1 12 10 37 1   3     0   1   32 32                       64.0 12 10 37 1   3     0   1   32 32                 64
2237731 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester: Francis J McGrath Elementary   Regular School No Elementary KG 06 2018   grade_1 12 7 13 0   1     0   3   20 16                       36.0 12 7 13 0   1     0   3   20 16                 36
2234585 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge: Northbridge Elementary   Regular School No Elementary PK 01 2018   grade_1 121 0 13 1   4     0   9   75 73                       148.0 121 0 13 1   4     0   9   75 73                 148
2234224 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Newburyport: Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2018   grade_1 123 1 6 0   4     0   3   68 69                       137.0 123 1 6 0   4     0   3   68 69                 137
2237471 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 Winthrop: William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2018   grade_1 126 1 19 0   2     0   3   74 77                       151.0 126 1 19 0   2     0   3   74 77                 151

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