enrollments

Data source: Big Local News · About: Big Local

1,848 rows where grade = "sped_beyond_grade_12", state = "MA" and year = 2018 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 1,848 ✖

grade ✖

  • sped_beyond_grade_12 · 1,848 ✖
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
2228755 2228755 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228758 2228758 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228762 2228762 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228767 2228767 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228772 2228772 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2228936 2228936 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington: John A Bishop   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228943 2228943 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington: Brackett   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228950 2228950 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Arlington: Cyrus E Dallin   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228957 2228957 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Arlington: Hardy   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228959 2228959 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228966 2228966 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Arlington: Peirce   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228973 2228973 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Arlington: Thompson   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228980 2228980 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington: M Norcross Stratton   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228984 2228984 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228989 2228989 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231787 2231787 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Framingham: Juniper Hill School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231792 2231792 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 Framingham: King Elementary School   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231799 2231799 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Framingham: Brophy   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231806 2231806 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham: Charlotte A Dunning   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231813 2231813 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Framingham: Hemenway   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231820 2231820 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231827 2231827 MA Middlesex   school 2504980 100   Framingham 250498000731 1000039 Framingham: Potter Road   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231834 2231834 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Framingham: Mary E Stapleton Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231841 2231841 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham: Miriam F McCarthy School   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231848 2231848 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Framingham: Woodrow Wilson   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231852 2231852 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham: Cameron Middle School   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231856 2231856 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231860 2231860 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231865 2231865 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham: Framingham High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231867 2231867 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin: Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231874 2231874 MA Norfolk   school 2505010 101   Franklin 250501000868 1010010 Franklin: Jefferson Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231881 2231881 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin: Helen Keller Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231888 2231888 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin: J F Kennedy Memorial   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231895 2231895 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin: Oak Street Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231902 2231902 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Franklin: Parmenter   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231909 2231909 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin: Davis Thayer   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231913 2231913 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231917 2231917 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231921 2231921 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin: Horace Mann   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231926 2231926 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   sped_beyond_grade_12 8 0 0 0   0     0   0                             8.0 8 0 0 0   0     0   0                       8
2231930 2231930 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231934 2231934 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Gardner: Waterford Street   Regular School No Elementary PK 01 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231938 2231938 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231944 2231944 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2231949 2231949 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner: Gardner Academy for Learning and Technology   Alternative School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231951 2231951 MA Essex   school 2505220 105   Georgetown 250522000766 1050005 Georgetown: Perley Elementary   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231959 2231959 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231962 2231962 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown: Georgetown Middle School   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231967 2231967 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown: Georgetown High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231974 2231974 MA Essex   school 2505280 107   Gloucester 250528000770 1070010 Gloucester: Beeman Memorial   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231981 2231981 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester: East Gloucester Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231983 2231983 MA Essex   school 2505280 107   Gloucester 250528002574 1070025 Gloucester: Gloucester PreSchool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231990 2231990 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester: Plum Cove School   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231997 2231997 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester: Veterans Memorial   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232004 2232004 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester: West Parish   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232008 2232008 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232013 2232013 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester: Gloucester High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2232028 2232028 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232032 2232032 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 Grafton: South Grafton Elementary   Regular School No Elementary PK 01 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232036 2232036 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 Grafton: North Grafton Elementary   Regular School No Elementary PK 01 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232042 2232042 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232048 2232048 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232051 2232051 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton: Grafton Middle   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232056 2232056 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton: Grafton High School   Regular School No High 09 12 2018   sped_beyond_grade_12 11 0 0 0   1     0   1                             13.0 11 0 0 0   1     0   1                       13
2232060 2232060 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby: East Meadow   Regular School No Middle 04 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232066 2232066 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 Granby: West Street   Regular School No Elementary PK 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232073 2232073 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232075 2232075 MA Franklin   school 2505490 114   Greenfield 250549002128 1140005 Greenfield: The Academy of Early Learning at North Parish   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232081 2232081 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Greenfield: Federal Street School   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232087 2232087 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield: Discovery School at Four Corners   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232093 2232093 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Greenfield: Newton School   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232097 2232097 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield: Greenfield Middle   Regular School No Middle 05 07 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232103 2232103 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield: Greenfield High   Regular School No High 08 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232112 2232112 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232119 2232119 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2232127 2232127 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax: Halifax Elementary   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232134 2232134 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232141 2232141 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Hanover: Cedar Elementary   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232145 2232145 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover: Center Elementary   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232148 2232148 MA Plymouth   school 2505790 122   Hanover 250579000832 1220015 Hanover: Sylvester   Regular School No Elementary 03 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232153 2232153 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover: Hanover Middle   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232158 2232158 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover: Hanover High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2232166 2232166 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Harvard: Hildreth Elementary School   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232174 2232174 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232183 2232183 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232190 2232190 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield: Smith Academy   Regular School No High 07 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232194 2232194 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Haverhill: Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232200 2232200 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Haverhill: Bradford Elementary   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232202 2232202 MA Essex   school 2505970 128   Haverhill 250597000851 1280020 Haverhill: Crowell   Regular School No Elementary KG KG 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232207 2232207 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Haverhill: Golden Hill   Regular School No Elementary 01 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232209 2232209 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Haverhill: Greenleaf Kindergarten Center   Regular School No Elementary KG KG 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232219 2232219 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232224 2232224 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill: Haverhill Alternative School   Regular School No High 06 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232226 2232226 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Haverhill: Moody   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232231 2232231 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232237 2232237 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Haverhill: Pentucket Lake Elementary   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232245 2232245 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   sped_beyond_grade_12 6 0 1 0   1     0   0                             8.0 6 0 1 0   1     0   0                       8
2232251 2232251 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Haverhill: Tilton   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232255 2232255 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Haverhill: Walnut Square   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2232260 2232260 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0

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