enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA"

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
736502 736502 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_3 1 19 38 0   1     0   1   29 31                       60 1 19 38 0   1     0   1   29 31                 60
736503 736503 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_4 0 12 35 0   0     0   1   24 24                       48 0 12 35 0   0     0   1   24 24                 48
736504 736504 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_5 0 8 20 0   0     0   1   15 14                       29 0 8 20 0   0     0   1   15 14                 29
736505 736505 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_6 0 7 34 0   1     0   0   24 18                       42 0 7 34 0   1     0   0   24 18                 42
736506 736506 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_7 0 7 16 0   0     0   0   9 14                       23 0 7 16 0   0     0   0   9 14                 23
736507 736507 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_8 0 4 21 0   0     0   1   11 15                       26 0 4 21 0   0     0   1   11 15                 26
736508 736508 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   kindergarten 6 18 12 0   0     0   3   20 19                       39 6 18 12 0   0     0   3   20 19                 39
736509 736509 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_1 7 17 18 0   0     0   0   20 22                       42 7 17 18 0   0     0   0   20 22                 42
736510 736510 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_2 4 19 18 1   3     0   0   16 29                       45 4 19 18 1   3     0   0   16 29                 45
736511 736511 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_3 5 33 16 1   3     0   4   27 35                       62 5 33 16 1   3     0   4   27 35                 62
736512 736512 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_4 1 12 12 0   0     0   1   11 15                       26 1 12 12 0   0     0   1   11 15                 26
736513 736513 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_5 5 9 6 0   2     0   1   16 7                       23 5 9 6 0   2     0   1   16 7                 23
736514 736514 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   kindergarten 14 4 4 0   1     0   1   13 11                       24 14 4 4 0   1     0   1   13 11                 24
736515 736515 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   pre_kindergarten 13 7 4 0   1     0   0   17 8                       25 13 7 4 0   1     0   0   17 8                 25
736516 736516 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   grade_1 10 5 6 0   0     0   2   9 14                       23 10 5 6 0   0     0   2   9 14                 23
736517 736517 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   grade_2 11 5 2 0   2     0   2   13 9                       22 11 5 2 0   2     0   2   13 9                 22
736518 736518 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   grade_3 3 6 10 0   2     0   1   8 14                       22 3 6 10 0   2     0   1   8 14                 22
736519 736519 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   grade_4 5 13 7 0   0     0   0   13 12                       25 5 13 7 0   0     0   0   13 12                 25
736520 736520 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2015   grade_5 2 7 10 0   2     0   0   10 11                       21 2 7 10 0   2     0   0   10 11                 21
736521 736521 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   kindergarten 10 13 13 1   22     0   3   32 30                       62 10 13 13 1   22     0   3   32 30                 62
736522 736522 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   pre_kindergarten 13 8 4 0   11     0   0   25 11                       36 13 8 4 0   11     0   0   25 11                 36
736523 736523 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_1 22 9 15 0   20     0   1   38 29                       67 22 9 15 0   20     0   1   38 29                 67
736524 736524 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_2 15 5 22 0   32     1   1   45 31                       76 15 5 22 0   32     1   1   45 31                 76
736525 736525 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_3 22 13 16 1   29     0   2   38 45                       83 22 13 16 1   29     0   2   38 45                 83
736526 736526 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_4 37 23 21 0   49     0   2   68 64                       132 37 23 21 0   49     0   2   68 64                 132
736527 736527 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_5 20 20 17 0   56     1   0   53 61                       114 20 20 17 0   56     1   0   53 61                 114
736528 736528 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_6 29 29 21 0   55     1   7   83 59                       142 29 29 21 0   55     1   7   83 59                 142
736529 736529 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_7 15 30 11 1   20     0   2   37 42                       79 15 30 11 1   20     0   2   37 42                 79
736530 736530 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_8 15 28 16 0   30     0   2   56 35                       91 15 28 16 0   30     0   2   56 35                 91
736531 736531 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   kindergarten 2 9 6 0   1     0   2   5 15                       20 2 9 6 0   1     0   2   5 15                 20
736532 736532 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   pre_kindergarten 0 10 8 0   0     0   0   8 10                       18 0 10 8 0   0     0   0   8 10                 18
736533 736533 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_1 1 14 7 0   0     0   2   15 9                       24 1 14 7 0   0     0   2   15 9                 24
736534 736534 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_2 0 9 11 0   0     0   2   10 12                       22 0 9 11 0   0     0   2   10 12                 22
736535 736535 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_3 1 27 19 1   0     0   0   24 24                       48 1 27 19 1   0     0   0   24 24                 48
736536 736536 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_4 0 16 6 0   0     0   0   10 12                       22 0 16 6 0   0     0   0   10 12                 22
736537 736537 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_5 1 12 6 0   0     0   3   9 13                       22 1 12 6 0   0     0   3   9 13                 22
736538 736538 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   kindergarten 14 6 5 0   2     0   1   17 11                       28 14 6 5 0   2     0   1   17 11                 28
736539 736539 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   pre_kindergarten 11 1 1 0   2     0   0   9 6                       15 11 1 1 0   2     0   0   9 6                 15
736540 736540 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_1 13 3 4 0   2     0   0   15 7                       22 13 3 4 0   2     0   0   15 7                 22
736541 736541 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_2 16 4 6 0   1     0   0   11 16                       27 16 4 6 0   1     0   0   11 16                 27
736542 736542 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_3 16 5 6 0   1     0   0   18 10                       28 16 5 6 0   1     0   0   18 10                 28
736543 736543 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_4 18 10 3 0   1     0   0   15 17                       32 18 10 3 0   1     0   0   15 17                 32
736544 736544 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_5 11 7 4 0   1     0   0   17 6                       23 11 7 4 0   1     0   0   17 6                 23
736545 736545 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_6 16 1 4 0   1     1   2   19 6                       25 16 1 4 0   1     1   2   19 6                 25
736546 736546 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_7 7 4 6 0   0     0   0   7 10                       17 7 4 6 0   0     0   0   7 10                 17
736547 736547 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_8 13 11 7 0   1     0   0   18 14                       32 13 11 7 0   1     0   0   18 14                 32
736548 736548 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   kindergarten 3 35 38 0   1     0   0   33 44                       77 3 35 38 0   1     0   0   33 44                 77
736549 736549 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   pre_kindergarten 1 32 14 0   2     0   2   30 21                       51 1 32 14 0   2     0   2   30 21                 51
736550 736550 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_1 1 30 49 0   2     0   1   42 41                       83 1 30 49 0   2     0   1   42 41                 83
736551 736551 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_2 3 40 56 0   1     0   0   55 45                       100 3 40 56 0   1     0   0   55 45                 100
736552 736552 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_3 1 39 47 1   0     0   2   45 45                       90 1 39 47 1   0     0   2   45 45                 90
736553 736553 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_4 2 44 45 0   0     1   3   47 48                       95 2 44 45 0   0     1   3   47 48                 95
736554 736554 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_5 0 51 39 1   1     0   5   50 47                       97 0 51 39 1   1     0   5   50 47                 97
736555 736555 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_6 1 31 43 0   1     0   1   41 36                       77 1 31 43 0   1     0   1   41 36                 77
736556 736556 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_7 1 33 43 0   1     1   2   27 54                       81 1 33 43 0   1     1   2   27 54                 81
736557 736557 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_8 0 41 43 0   0     2   0   39 47                       86 0 41 43 0   0     2   0   39 47                 86
736558 736558 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_3 26 22 33 0   5     0   3   52 37                       89 26 22 33 0   5     0   3   52 37                 89
736559 736559 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_4 41 21 44 0   6     1   2   63 52                       115 41 21 44 0   6     1   2   63 52                 115
736560 736560 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_5 26 27 44 0   3     0   4   55 49                       104 26 27 44 0   3     0   4   55 49                 104
736561 736561 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_6 21 25 49 0   11     0   9   68 47                       115 21 25 49 0   11     0   9   68 47                 115
736562 736562 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_7 7 31 48 0   2     0   2   56 34                       90 7 31 48 0   2     0   2   56 34                 90
736563 736563 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_8 7 45 46 0   0     0   0   56 42                       98 7 45 46 0   0     0   0   56 42                 98
736564 736564 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   kindergarten 27 1 14 0   0     0   0   24 18                       42 27 1 14 0   0     0   0   24 18                 42
736565 736565 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   pre_kindergarten 54 1 6 0   0     0   4   37 28                       65 54 1 6 0   0     0   4   37 28                 65
736566 736566 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_1 42 4 34 0   1     0   0   47 34                       81 42 4 34 0   1     0   0   47 34                 81
736567 736567 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_2 30 1 29 0   1     0   1   31 31                       62 30 1 29 0   1     0   1   31 31                 62
736568 736568 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_3 26 4 29 0   0     0   2   34 27                       61 26 4 29 0   0     0   2   34 27                 61
736569 736569 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_4 29 7 30 0   1     0   0   35 32                       67 29 7 30 0   1     0   0   35 32                 67
736570 736570 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_5 20 2 19 1   1     0   1   21 23                       44 20 2 19 1   1     0   1   21 23                 44
736571 736571 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_6 20 10 33 1   1     0   0   33 32                       65 20 10 33 1   1     0   0   33 32                 65
736572 736572 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_7 8 5 17 0   0     0   1   14 17                       31 8 5 17 0   0     0   1   14 17                 31
736573 736573 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_8 7 5 20 0   0     0   0   17 15                       32 7 5 20 0   0     0   0   17 15                 32
736574 736574 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   kindergarten 1 2 38 0   1     0   0   18 24                       42 1 2 38 0   1     0   0   18 24                 42
736575 736575 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   pre_kindergarten 2 1 26 0   1     0   0   17 13                       30 2 1 26 0   1     0   0   17 13                 30
736576 736576 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   grade_1 7 2 61 0   1     1   1   41 32                       73 7 2 61 0   1     1   1   41 32                 73
736577 736577 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   grade_2 6 2 55 0   1     0   0   30 34                       64 6 2 55 0   1     0   0   30 34                 64
736578 736578 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   grade_3 5 0 35 0   1     0   1   21 21                       42 5 0 35 0   1     0   1   21 21                 42
736579 736579 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   grade_4 3 1 30 0   0     0   0   18 16                       34 3 1 30 0   0     0   0   18 16                 34
736580 736580 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No 1 PK 05 2015   grade_5 1 2 18 0   0     0   1   12 10                       22 1 2 18 0   0     0   1   12 10                 22
736581 736581 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   kindergarten 16 13 13 0   4     0   0   20 26                       46 16 13 13 0   4     0   0   20 26                 46
736582 736582 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   pre_kindergarten 16 6 5 0   5     0   1   16 17                       33 16 6 5 0   5     0   1   16 17                 33
736583 736583 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_1 12 4 8 0   1     0   1   14 12                       26 12 4 8 0   1     0   1   14 12                 26
736584 736584 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_2 24 9 14 0   2     0   0   29 20                       49 24 9 14 0   2     0   0   29 20                 49
736585 736585 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_3 20 17 9 0   2     0   1   21 28                       49 20 17 9 0   2     0   1   21 28                 49
736586 736586 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_4 7 9 5 0   2     0   0   14 9                       23 7 9 5 0   2     0   0   14 9                 23
736587 736587 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   kindergarten 2 13 35 0   8     0   2   20 40                       60 2 13 35 0   8     0   2   20 40                 60
736588 736588 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   pre_kindergarten 1 11 23 0   5     0   0   21 19                       40 1 11 23 0   5     0   0   21 19                 40
736589 736589 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   grade_1 5 36 39 1   6     0   2   52 37                       89 5 36 39 1   6     0   2   52 37                 89
736590 736590 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   grade_2 3 12 64 0   6     1   4   53 37                       90 3 12 64 0   6     1   4   53 37                 90
736591 736591 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   grade_3 3 17 61 0   5     0   0   43 43                       86 3 17 61 0   5     0   0   43 43                 86
736592 736592 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   grade_4 4 32 45 0   4     0   2   40 47                       87 4 32 45 0   4     0   2   40 47                 87
736593 736593 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2015   grade_5 3 18 43 0   8     0   0   32 40                       72 3 18 43 0   8     0   0   32 40                 72
736594 736594 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   kindergarten 9 11 11 0   2     0   1   20 14                       34 9 11 11 0   2     0   1   20 14                 34
736595 736595 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   pre_kindergarten 6 6 8 0   0     0   0   9 11                       20 6 6 8 0   0     0   0   9 11                 20
736596 736596 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   grade_1 10 12 18 0   2     0   2   20 24                       44 10 12 18 0   2     0   2   20 24                 44
736597 736597 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   grade_2 10 13 17 0   2     0   2   20 24                       44 10 13 17 0   2     0   2   20 24                 44
736598 736598 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   grade_3 5 16 21 1   2     0   2   23 24                       47 5 16 21 1   2     0   2   23 24                 47
736599 736599 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   grade_4 9 25 19 0   2     0   2   27 30                       57 9 25 19 0   2     0   2   27 30                 57
736600 736600 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2015   grade_5 13 11 18 0   2     0   2   19 27                       46 13 11 18 0   2     0   2   19 27                 46
736601 736601 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No 1 PK 05 2015   kindergarten 15 21 14 0   62     0   2   48 66                       114 15 21 14 0   62     0   2   48 66                 114

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