enrollments

Data source: Big Local News · About: Big Local

988 rows where grade = "grade_1", state = "MA" and year = 2016 sorted by asian_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 988 ✖

grade ✖

  • grade_1 · 988 ✖
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
935365 935365 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_1 * * * *   *     *   *   2 3                       5                         2 3                 5
935451 935451 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_1 * * * *   *     *   *   3 1                       4                         3 1                 4
936244 936244 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No 1 PK 05 2016   grade_1 * * * *   *     *   *   2 1                       3                         2 1                 3
938515 938515 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No 1 PK 02 2016   grade_1 * * * *   *     *   *   1 2                       3                         1 2                 3
932553 932553 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No 1 PK 04 2016   grade_1 97 0 4 0   0     0   0   43 58                       101 97 0 4 0   0     0   0   43 58                 101
932812 932812 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2016   grade_1 33 14 6 0   0     0   0   21 32                       53 33 14 6 0   0     0   0   21 32                 53
932827 932827 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2016   grade_1 56 1 3 0   0     0   4   32 32                       64 56 1 3 0   0     0   4   32 32                 64
932839 932839 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2016   grade_1 102 4 4 1   0     0   3   51 63                       114 102 4 4 1   0     0   3   51 63                 114
932935 932935 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No 1 PK 04 2016   grade_1 84 0 1 0   0     0   2   47 40                       87 84 0 1 0   0     0   2   47 40                 87
932945 932945 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No 1 PK 05 2016   grade_1 21 0 2 0   0     0   0   17 6                       23 21 0 2 0   0     0   0   17 6                 23
932964 932964 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No 1 KG 05 2016   grade_1 62 1 7 0   0     0   3   30 43                       73 62 1 7 0   0     0   3   30 43                 73
932970 932970 MA Essex   school 2502640 30   Beverly 250264000173 300040 North Beverly Elementary   Regular School No 1 KG 05 2016   grade_1 49 2 10 1   0     0   0   33 29                       62 49 2 10 1   0     0   0   33 29                 62
933020 933020 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No 1 KG 05 2016   grade_1 25 1 2 0   0     0   3   11 20                       31 25 1 2 0   0     0   3   11 20                 31
933057 933057 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No 1 PK 03 2016   grade_1 1 21 14 1   0     0   1   25 13                       38 1 21 14 1   0     0   1   25 13                 38
933068 933068 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   grade_1 11 4 7 1   0     0   0   11 12                       23 11 4 7 1   0     0   0   11 12                 23
933091 933091 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2016   grade_1 1 21 29 1   0     1   1   32 22                       54 1 21 29 1   0     1   1   32 22                 54
933135 933135 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No 1 PK 05 2016   grade_1 4 0 10 0   0     0   2   8 8                       16 4 0 10 0   0     0   2   8 8                 16
933142 933142 MA Suffolk   school 2502790 35   Boston 250279000220 350072 David A Ellis   Regular School No 1 PK 05 2016   grade_1 4 27 42 0   0     0   3   42 34                       76 4 27 42 0   0     0   3   42 34                 76
933155 933155 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   grade_1 14 16 10 0   0     1   1   22 20                       42 14 16 10 0   0     1   1   22 20                 42
933164 933164 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   grade_1 3 1 68 0   0     0   0   37 35                       72 3 1 68 0   0     0   0   37 35                 72
933191 933191 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2016   grade_1 16 6 14 0   0     0   6   17 25                       42 16 6 14 0   0     0   6   17 25                 42
933229 933229 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Hugh Roe O'Donnell   Regular School No 1 PK 05 2016   grade_1 3 0 42 0   0     0   2   23 24                       47 3 0 42 0   0     0   2   23 24                 47
933252 933252 MA Suffolk   school 2502790 35   Boston 250279000255 350154 James J Chittick   Regular School No 1 PK 05 2016   grade_1 0 30 11 0   0     0   4   23 22                       45 0 30 11 0   0     0   4   23 22                 45
933266 933266 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No 1 PK 05 2016   grade_1 5 12 44 0   0     0   0   26 35                       61 5 12 44 0   0     0   0   26 35                 61
933290 933290 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2016   grade_1 0 24 24 0   0     1   1   25 25                       50 0 24 24 0   0     1   1   25 25                 50
933304 933304 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2016   grade_1 8 3 31 0   0     0   2   26 18                       44 8 3 31 0   0     0   2   26 18                 44
933324 933324 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2016   grade_1 13 5 3 0   0     1   1   15 8                       23 13 5 3 0   0     1   1   15 8                 23
933355 933355 MA Suffolk   school 2502790 35   Boston 250279000290 350226 Mattahunt   Regular School No 1 PK 05 2016   grade_1 4 79 30 0   0     0   2   58 57                       115 4 79 30 0   0     0   2   58 57                 115
933485 933485 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No 1 PK 05 2016   grade_1 9 1 43 0   0     0   0   25 28                       53 9 1 43 0   0     0   0   25 28                 53
933492 933492 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2016   grade_1 3 18 13 0   0     1   1   20 16                       36 3 18 13 0   0     1   1   20 16                 36
933499 933499 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_1 2 8 36 0   0     1   0   23 24                       47 2 8 36 0   0     1   0   23 24                 47
933536 933536 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No 1 PK 05 2016   grade_1 3 22 13 1   0     1   4   21 23                       44 3 22 13 1   0     1   4   21 23                 44
933561 933561 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_1 6 40 20 0   0     0   3   37 32                       69 6 40 20 0   0     0   3   37 32                 69
933606 933606 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_1 1 33 8 0   0     0   1   15 28                       43 1 33 8 0   0     0   1   15 28                 43
933614 933614 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_1 0 22 26 0   0     0   3   31 20                       51 0 22 26 0   0     0   3   31 20                 51
933624 933624 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2016   grade_1 9 8 5 0   0     0   2   11 13                       24 9 8 5 0   0     0   2   11 13                 24
933637 933637 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No 1 PK 05 2016   grade_1 1 17 60 0   0     0   1   40 39                       79 1 17 60 0   0     0   1   40 39                 79
933803 933803 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2016   grade_1 2 4 43 0   0     0   1   24 26                       50 2 4 43 0   0     0   1   24 26                 50
933813 933813 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_1 1 6 3 0   0     0   0   8 2                       10 1 6 3 0   0     0   0   8 2                 10
933831 933831 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_1 72 2 7 1   0     0   2   52 32                       84 72 2 7 1   0     0   2   52 32                 84
933920 933920 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No 1 PK 06 2016   grade_1 35 2 0 0   0     0   0   19 18                       37 35 2 0 0   0     0   0   19 18                 37
933927 933927 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_1 17 98 30 2   0     0   15   90 72                       162 17 98 30 2   0     0   15   90 72                 162
933939 933939 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2016   grade_1 12 50 78 1   0     0   4   78 67                       145 12 50 78 1   0     0   4   78 67                 145
933975 933975 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Huntington   Regular School No 1 KG 05 2016   grade_1 10 63 13 0   0     0   7   54 39                       93 10 63 13 0   0     0   7   54 39                 93
933987 933987 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 05 2016   grade_1 13 105 14 0   0     0   5   65 72                       137 13 105 14 0   0     0   5   65 72                 137
934039 934039 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No 1 PK 06 2016   grade_1 38 0 2 0   0     0   2   21 21                       42 38 0 2 0   0     0   2   21 21                 42
934304 934304 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No 1 PK 05 2016   grade_1 114 1 1 0   0     0   0   48 68                       116 114 1 1 0   0     0   0   48 68                 116
934393 934393 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2016   grade_1 49 6 39 0   0     0   0   52 42                       94 49 6 39 0   0     0   0   52 42                 94
934397 934397 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No 1 PK 05 2016   grade_1 19 3 44 0   0     0   3   34 35                       69 19 3 44 0   0     0   3   34 35                 69
934403 934403 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No 1 KG 05 2016   grade_1 43 5 7 0   0     0   1   27 29                       56 43 5 7 0   0     0   1   27 29                 56
934461 934461 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_1 16 0 1 0   0     0   0   10 7                       17 16 0 1 0   0     0   0   10 7                 17
934523 934523 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No 1 PK 06 2016   grade_1 14 0 1 0   0     0   0   10 5                       15 14 0 1 0   0     0   0   10 5                 15
934601 934601 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No 1 01 05 2016   grade_1 45 1 2 0   0     0   4   27 25                       52 45 1 2 0   0     0   4   27 25                 52
934625 934625 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No 1 PK 06 2016   grade_1 44 0 4 0   0     0   4   26 26                       52 44 0 4 0   0     0   4   26 26                 52
934701 934701 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No 1 PK 02 2016   grade_1 131 4 2 1   0     1   5   77 67                       144 131 4 2 1   0     1   5   77 67                 144
934715 934715 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_1 23 0 1 1   0     0   1   10 16                       26 23 0 1 1   0     0   1   10 16                 26
934727 934727 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Maple   Regular School No 1 PK 04 2016   grade_1 40 1 1 0   0     0   1   25 18                       43 40 1 1 0   0     0   1   25 18                 43
934785 934785 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2016   grade_1 30 1 6 3   0     0   4   20 24                       44 30 1 6 3   0     0   4   20 24                 44
934795 934795 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No 1 PK 06 2016   grade_1 5 0 0 0   0     0   3   3 5                       8 5 0 0 0   0     0   3   3 5                 8
934851 934851 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_1 24 18 54 0   0     1   2   49 50                       99 24 18 54 0   0     1   2   49 50                 99
935059 935059 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_1 7 0 0 0   0     0   0   2 5                       7 7 0 0 0   0     0   0   2 5                 7
935136 935136 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_1 73 11 22 0   0     0   2   52 56                       108 73 11 22 0   0     0   2   52 56                 108
935186 935186 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No 1 KG 05 2016   grade_1 41 0 0 0   0     0   0   21 20                       41 41 0 0 0   0     0   0   21 20                 41
935210 935210 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   grade_1 137 7 26 1   0     0   26   106 91                       197 137 7 26 1   0     0   26   106 91                 197
935245 935245 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2016   grade_1 34 0 4 0   0     0   1   24 15                       39 34 0 4 0   0     0   1   24 15                 39
935252 935252 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Plum Cove School   Regular School No 1 KG 05 2016   grade_1 34 0 0 0   0     1   0   17 18                       35 34 0 0 0   0     1   0   17 18                 35
935258 935258 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2016   grade_1 26 0 4 0   0     0   0   12 18                       30 26 0 4 0   0     0   0   12 18                 30
935306 935306 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2016   grade_1 44 0 1 1   0     0   2   16 32                       48 44 0 1 1   0     0   2   16 32                 48
935317 935317 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 04 2016   grade_1 36 1 8 0   0     0   4   20 29                       49 36 1 8 0   0     0   4   20 29                 49
935322 935322 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 04 2016   grade_1 39 0 4 0   0     0   0   16 27                       43 39 0 4 0   0     0   0   16 27                 43
935328 935328 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 04 2016   grade_1 30 0 11 0   0     0   1   21 21                       42 30 0 11 0   0     0   1   21 21                 42
935344 935344 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_1 27 1 2 0   0     1   0   15 16                       31 27 1 2 0   0     1   0   15 16                 31
935357 935357 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2016   grade_1 68 1 1 1   0     0   1   39 33                       72 68 1 1 1   0     0   1   39 33                 72
935406 935406 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_1 29 0 2 0   0     0   0   17 14                       31 29 0 2 0   0     0   0   17 14                 31
935431 935431 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No 1 KG 02 2016   grade_1 57 3 26 1   0     0   3   42 48                       90 57 3 26 1   0     0   3   42 48                 90
935469 935469 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_1 23 2 25 0   0     0   3   31 22                       53 23 2 25 0   0     0   3   31 22                 53
935484 935484 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2016   grade_1 70 0 1 0   0     0   2   40 33                       73 70 0 1 0   0     0   2   40 33                 73
935490 935490 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2016   grade_1 54 0 2 0   0     0   1   28 29                       57 54 0 2 0   0     0   1   28 29                 57
935531 935531 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2016   grade_1 28 1 1 1   0     0   0   19 12                       31 28 1 1 1   0     0   0   19 12                 31
935554 935554 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK 01 2016   grade_1 9 1 16 0   0     0   0   10 16                       26 9 1 16 0   0     0   0   10 16                 26
935566 935566 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   grade_1 1 0 39 0   0     0   0   23 17                       40 1 0 39 0   0     0   0   23 17                 40
935580 935580 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   grade_1 2 1 65 0   0     0   1   44 25                       69 2 1 65 0   0     0   1   44 25                 69
935590 935590 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_1 8 1 38 0   0     0   1   20 28                       48 8 1 38 0   0     0   1   20 28                 48
935599 935599 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2016   grade_1 10 2 47 0   0     0   0   27 32                       59 10 2 47 0   0     0   0   27 32                 59
935609 935609 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 PK 08 2016   grade_1 7 2 51 0   0     0   0   37 23                       60 7 2 51 0   0     0   0   37 23                 60
935618 935618 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2016   grade_1 3 1 66 0   0     0   0   39 31                       70 3 1 66 0   0     0   0   39 31                 70
935632 935632 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   grade_1 60 1 3 0   0     0   2   37 29                       66 60 1 3 0   0     0   2   37 29                 66
935708 935708 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No 1 PK 05 2016   grade_1 43 1 3 0   0     0   4   22 29                       51 43 1 3 0   0     0   4   22 29                 51
935722 935722 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No 1 KG 02 2016   grade_1 140 3 3 1   0     0   0   74 73                       147 140 3 3 1   0     0   0   74 73                 147
935730 935730 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2016   grade_1 15 1 1 0   0     0   0   7 10                       17 15 1 1 0   0     0   0   7 10                 17
935747 935747 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   grade_1 2 0 126 0   0     0   0   64 64                       128 2 0 126 0   0     0   0   64 64                 128
935785 935785 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   grade_1 4 0 92 0   0     0   0   53 43                       96 4 0 92 0   0     0   0   53 43                 96
935803 935803 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No 1 01 05 2016   grade_1 0 1 76 0   0     0   0   41 36                       77 0 1 76 0   0     0   0   41 36                 77
935809 935809 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_1 5 0 69 0   0     0   0   32 42                       74 5 0 69 0   0     0   0   32 42                 74
935858 935858 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_1 1 0 8 0   0     0   0   6 3                       9 1 0 8 0   0     0   0   6 3                 9
936229 936229 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2016   grade_1 96 0 10 0   0     1   8   53 62                       115 96 0 10 0   0     1   8   53 62                 115
936321 936321 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2016   grade_1 23 1 2 0   0     0   2   14 14                       28 23 1 2 0   0     0   2   14 14                 28
936326 936326 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_1 2 0 3 0   0     0   1   5 1                       6 2 0 3 0   0     0   1   5 1                 6
936483 936483 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No 1 PK 03 2016   grade_1 74 0 3 0   0     0   2   47 32                       79 74 0 3 0   0     0   2   47 32                 79
936527 936527 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2016   grade_1 43 0 0 0   0     0   1   27 17                       44 43 0 0 0   0     0   1   27 17                 44

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