Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by ccd_school_lvl

View and edit SQL

year

grade

  • grade_6 · 3,938
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
739907 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2015   grade_6 73 5 67 1   3     0   3   85 67                       152 73 5 67 1   3     0   3   85 67                 152
739942 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2015   grade_6 114 1 6 0   6     0   1   66 62                       128 114 1 6 0   6     0   1   66 62                 128
740046 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No 1 PK 06 2015   grade_6 26 0 1 0   4     0   0   20 11                       31 26 0 1 0   4     0   0   20 11                 31
740422 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2015   grade_6 123 3 0 0   0     0   9   71 64                       135 123 3 0 0   0     0   9   71 64                 135
740433 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_6 27 0 0 0   0     0   4   17 14                       31 27 0 0 0   0     0   4   17 14                 31
740441 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_6 20 1 2 0   1     0   1   15 10                       25 20 1 2 0   1     0   1   15 10                 25
740450 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_6 38 2 2 0   0     1   3   23 23                       46 38 2 2 0   0     1   3   23 23                 46
740622 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   grade_6 31 0 3 0   0     0   5   19 20                       39 31 0 3 0   0     0   5   19 20                 39
740736 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_6 40 3 8 1   1     0   3   28 28                       56 40 3 8 1   1     0   3   28 28                 56
740742 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No 1 03 06 2015   grade_6 65 2 12 0   3     0   3   43 42                       85 65 2 12 0   3     0   3   43 42                 85
740853 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2015   grade_6 13 0 1 0   1     0   2   9 8                       17 13 0 1 0   1     0   2   9 8                 17
740860 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2015   grade_6 102 3 2 0   0     0   0   56 51                       107 102 3 2 0   0     0   0   56 51                 107
740867 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2015   grade_6 61 0 0 0   1     0   1   36 27                       63 61 0 0 0   1     0   1   36 27                 63
740875 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2015   grade_6 85 0 1 0   1     0   1   48 40                       88 85 0 1 0   1     0   1   48 40                 88
740889 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   grade_6 15 0 0 0   0     0   0   7 8                       15 15 0 0 0   0     0   0   7 8                 15
741034 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   grade_6 36 0 0 0   0     0   0   22 14                       36 36 0 0 0   0     0   0   22 14                 36
741042 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_6 9 0 3 0   0     0   3   9 6                       15 9 0 3 0   0     0   3   9 6                 15
741275 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_6 8 1 1 0   0     0   0   1 9                       10 8 1 1 0   0     0   0   1 9                 10
741285 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No 1 PK 06 2015   grade_6 83 2 0 0   0     0   4   42 47                       89 83 2 0 0   0     0   4   42 47                 89
741329 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 0 0   0     0   0   4 10                       14 14 0 0 0   0     0   0   4 10                 14
741355 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No 1 KG 08 2015   grade_6 9 2 33 0   0     0   1   22 23                       45 9 2 33 0   0     0   1   22 23                 45
741370 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No 1 KG 08 2015   grade_6 24 0 9 0   0     0   4   16 21                       37 24 0 9 0   0     0   4   16 21                 37
741396 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   grade_6 62 1 0 0   5     0   0   39 29                       68 62 1 0 0   5     0   0   39 29                 68
741403 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   grade_6 83 1 1 1   1     0   0   44 43                       87 83 1 1 1   1     0   0   44 43                 87
741410 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   grade_6 75 0 1 2   2     0   1   40 41                       81 75 0 1 2   2     0   1   40 41                 81
741463 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No 1 KG 06 2015   grade_6 62 0 0 0   0     0   2   26 38                       64 62 0 0 0   0     0   2   26 38                 64
741470 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No 1 KG 06 2015   grade_6 51 2 1 0   0     0   0   35 19                       54 51 2 1 0   0     0   0   35 19                 54
741477 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No 1 KG 06 2015   grade_6 105 4 0 0   2     0   2   57 56                       113 105 4 0 0   2     0   2   57 56                 113
741485 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No 1 PK 06 2015   grade_6 64 1 0 0   0     0   1   36 30                       66 64 1 0 0   0     0   1   36 30                 66
741584 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 4 0   0     0   2   13 13                       26 20 0 4 0   0     0   2   13 13                 26
741615 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No 1 KG 06 2015   grade_6 30 1 5 0   2     0   1   20 19                       39 30 1 5 0   2     0   1   20 19                 39
741623 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   grade_6 14 7 28 0   6     0   2   27 30                       57 14 7 28 0   6     0   2   27 30                 57
741633 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2015   grade_6 19 8 8 0   1     0   1   24 13                       37 19 8 8 0   1     0   1   24 13                 37
741643 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   grade_6 22 3 18 0   3     0   0   23 23                       46 22 3 18 0   3     0   0   23 23                 46
741652 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2015   grade_6 14 5 40 0   3     0   0   37 25                       62 14 5 40 0   3     0   0   37 25                 62
741662 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2015   grade_6 15 5 9 0   1     0   2   15 17                       32 15 5 9 0   1     0   2   15 17                 32
741672 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2015   grade_6 16 5 27 0   5     0   0   29 24                       53 16 5 27 0   5     0   0   29 24                 53
741694 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No 1 PK 06 2015   grade_6 69 2 3 0   1     0   1   37 39                       76 69 2 3 0   1     0   1   37 39                 76
741849 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_6 7 9 6 0   1     0   3   13 13                       26 7 9 6 0   1     0   3   13 13                 26
742107 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   grade_6 121 0 7 0   1     0   2   63 68                       131 121 0 7 0   1     0   2   63 68                 131
742143 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No 1 PK 06 2015   grade_6 22 0 2 0   3     0   1   13 15                       28 22 0 2 0   3     0   1   13 15                 28
742285 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2015   grade_6 26 1 6 1   1     0   3   17 21                       38 26 1 6 1   1     0   3   17 21                 38
742369 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No 1 PK 06 2015   grade_6 20 0 1 0   0     0   0   5 16                       21 20 0 1 0   0     0   0   5 16                 21
742552 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_6 106 11 29 0   2     1   7   78 78                       156 106 11 29 0   2     1   7   78 78                 156
742764 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2015   grade_6 23 0 0 0   0     0   0   9 14                       23 23 0 0 0   0     0   0   9 14                 23
742933 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2015   grade_6 14 0 1 0   0     0   0   7 8                       15 14 0 1 0   0     0   0   7 8                 15
742941 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg Schools   Regular School No 1 PK 06 2015   grade_6 25 0 3 1   1     0   0   14 16                       30 25 0 3 1   1     0   0   14 16                 30
742949 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2015   grade_6 48 1 6 0   3     0   7   37 28                       65 48 1 6 0   3     0   7   37 28                 65
743107 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2015   grade_6 4 9 17 0   5     0   1   21 15                       36 4 9 17 0   5     0   1   21 15                 36
743114 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2015   grade_6 5 4 7 0   0     0   3   10 9                       19 5 4 7 0   0     0   3   10 9                 19
743122 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   grade_6 3 6 43 0   6     0   0   38 20                       58 3 6 43 0   6     0   0   38 20                 58
743129 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2015   grade_6 3 4 13 0   0     0   2   12 10                       22 3 4 13 0   0     0   2   12 10                 22
743137 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2015   grade_6 10 8 22 0   5     0   1   27 19                       46 10 8 22 0   5     0   1   27 19                 46
743144 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2015   grade_6 2 9 23 0   5     0   3   18 24                       42 2 9 23 0   5     0   3   18 24                 42
743152 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2015   grade_6 3 0 50 0   5     0   1   32 27                       59 3 0 50 0   5     0   1   32 27                 59
743160 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2015   grade_6 19 9 32 0   2     0   3   34 31                       65 19 9 32 0   2     0   3   34 31                 65
743168 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2015   grade_6 12 2 20 0   1     0   2   17 20                       37 12 2 20 0   1     0   2   17 20                 37
743176 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2015   grade_6 8 5 20 0   4     0   0   24 13                       37 8 5 20 0   4     0   0   24 13                 37
743183 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2015   grade_6 31 1 8 0   2     0   0   21 21                       42 31 1 8 0   2     0   0   21 21                 42
743191 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2015   grade_6 22 8 30 0   4     0   4   40 28                       68 22 8 30 0   4     0   4   40 28                 68
743199 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2015   grade_6 7 9 47 0   10     0   3   42 34                       76 7 9 47 0   10     0   3   42 34                 76
743207 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2015   grade_6 20 14 21 0   12     0   4   52 19                       71 20 14 21 0   12     0   4   52 19                 71
743215 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2015   grade_6 11 4 15 0   3     0   2   21 14                       35 11 4 15 0   3     0   2   21 14                 35
743222 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2015   grade_6 22 3 3 1   1     0   2   19 13                       32 22 3 3 1   1     0   2   19 13                 32
743230 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2015   grade_6 8 8 19 0   1     0   3   23 16                       39 8 8 19 0   1     0   3   23 16                 39
743237 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2015   grade_6 20 6 8 0   3     0   3   11 29                       40 20 6 8 0   3     0   3   11 29                 40
743245 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2015   grade_6 3 7 10 0   1     0   0   9 12                       21 3 7 10 0   1     0   0   9 12                 21
743252 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2015   grade_6 17 6 16 0   2     0   1   17 25                       42 17 6 16 0   2     0   1   17 25                 42
743260 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2015   grade_6 10 4 3 0   0     0   1   7 11                       18 10 4 3 0   0     0   1   7 11                 18
743267 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2015   grade_6 27 5 5 0   3     0   2   21 21                       42 27 5 5 0   3     0   2   21 21                 42
743274 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2015   grade_6 39 3 3 0   3     0   2   25 25                       50 39 3 3 0   3     0   2   25 25                 50
743282 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2015   grade_6 33 12 20 0   5     0   1   40 31                       71 33 12 20 0   5     0   1   40 31                 71
743290 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2015   grade_6 29 10 29 0   12     0   3   40 43                       83 29 10 29 0   12     0   3   40 43                 83
743297 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2015   grade_6 11 9 16 0   1     0   4   23 18                       41 11 9 16 0   1     0   4   23 18                 41
743305 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2015   grade_6 23 6 21 0   4     0   5   30 29                       59 23 6 21 0   4     0   5   30 29                 59
743313 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2015   grade_6 21 2 17 1   1     0   2   20 24                       44 21 2 17 1   1     0   2   20 24                 44
743320 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2015   grade_6 28 14 19 1   5     0   7   35 39                       74 28 14 19 1   5     0   7   35 39                 74
743327 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2015   grade_6 14 5 13 0   2     0   3   16 21                       37 14 5 13 0   2     0   3   16 21                 37
743334 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2015   grade_6 8 9 26 1   3     0   4   25 26                       51 8 9 26 1   3     0   4   25 26                 51
743342 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2015   grade_6 31 3 4 0   3     0   5   28 18                       46 31 3 4 0   3     0   5   28 18                 46
743350 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2015   grade_6 18 18 37 0   1     0   2   38 38                       76 18 18 37 0   1     0   2   38 38                 76
743475 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_6 0 29 9 0   0     0   0   16 22                       38 0 29 9 0   0     0   0   16 22                 38
743495 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_6 0 39 9 0   1     0   4   24 29                       53 0 39 9 0   1     0   4   24 29                 53
743557 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_6 3 19 10 0   1     0   2   19 16                       35 3 19 10 0   1     0   2   19 16                 35
743567 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_6 2 0 46 0   0     0   0   26 22                       48 2 0 46 0   0     0   0   26 22                 48
743589 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2015   grade_6 1 23 12 0   0     0   2   19 19                       38 1 23 12 0   0     0   2   19 19                 38
743599 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2015   grade_6 7 20 12 0   3     0   0   25 17                       42 7 20 12 0   3     0   0   25 17                 42
743634 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 31 0 1 0   15     0   3   31 19                       50 31 0 1 0   15     0   3   31 19                 50
743651 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 31 0 1 0   0     0   0   19 13                       32 31 0 1 0   0     0   0   19 13                 32
743664 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes 1 KG 08 2015   grade_6 4 5 63 0   0     0   1   37 36                       73 4 5 63 0   0     0   1   37 36                 73
743673 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   grade_6 1 0 55 0   0     0   0   26 30                       56 1 0 55 0   0     0   0   26 30                 56
743682 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes 1 KG 08 2015   grade_6 26 2 7 0   0     0   0   14 21                       35 26 2 7 0   0     0   0   14 21                 35
743692 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 07 2015   grade_6 4 23 34 0   19     0   2   38 44                       82 4 23 34 0   19     0   2   38 44                 82
743699 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 07 2015   grade_6 8 11 24 1   1     0   0   21 24                       45 8 11 24 1   1     0   0   21 24                 45
743798 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   grade_6 1 58 29 0   2     0   6   44 52                       96 1 58 29 0   2     0   6   44 52                 96
743805 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2015   grade_6 27 0 2 0   2     0   0   18 13                       31 27 0 2 0   2     0   0   18 13                 31
743833 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2015   grade_6 7 19 29 0   2     0   1   32 26                       58 7 19 29 0   2     0   1   32 26                 58
743928 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2015   grade_6 46 2 1 0   24     0   2   46 29                       75 46 2 1 0   24     0   2   46 29                 75
743936 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No 1 PK 06 2015   grade_6 50 2 3 0   12     0   6   34 39                       73 50 2 3 0   12     0   6   34 39                 73
743943 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No 1 KG 06 2015   grade_6 52 1 4 0   11     0   4   33 39                       72 52 1 4 0   11     0   4   33 39                 72

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