assisted1

2 rows where Licensee = "HENRYS INC." and Zip Code = 48141

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Facility Name Address City State Zip Code Phone Number County Licensee State Facility Type 2 Literal State Facility Type 1 Literal Date Accessed License Number Capacity Ownership Type Latitude Longitude County FIPS Total County AL Need County Percent of Population 65 or Older County Median Age County Homeownership Rate County College Education or Higher Rate County Percent Black Population County Median Home Value of Owned Homes County Percent Hispanic Population County Percent of Population 85 or Older County Median Household Income County Unemployment Rate County Less Than High School Diploma Rate County Percent Whilte Population County Gender Ratio County Poverty Rate
18701 18701 Daly Afc 1049 JOHN DALY Inkster MI 48141 3137910939 Wayne HENRYS INC. SMALL GROUP ADULT FOSTER CARE & HOMES FOR THE AGED FACILITY 6/28/21 AS820071704 6.0   42.3039076 -83.3003246 26163.0 129408.0 15.05 38.0 62.02 23.93 38.75 113000.0 5.94 1.97 47301.0 13.8 13.52 53.13 93.0 22.31
21589 21589 Henrys Inc. Spring Arbor 30109 SPRING ARBOR Inkster MI 48141 3137910939 Wayne HENRYS INC. SMALL GROUP ADULT FOSTER CARE & HOMES FOR THE AGED FACILITY 6/28/21 AS820243816 6.0   42.2960903 -83.3371277 26163.0 129408.0 15.05 38.0 62.02 23.93 38.75 113000.0 5.94 1.97 47301.0 13.8 13.52 53.13 93.0 22.31

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE assisted1
("Facility Name" TEXT, "Address" TEXT, "City" TEXT, "State" TEXT, "Zip Code" TEXT, "Phone Number" TEXT, "County" TEXT, "Licensee" TEXT, "State Facility Type 2 Literal" TEXT, "State Facility Type 1 Literal" TEXT, "Date Accessed" TEXT, "License Number" TEXT, "Capacity" TEXT, "Email Address" TEXT, "Ownership Type" TEXT, "Latitude" TEXT, "Longitude" TEXT, "County FIPS" TEXT, "Total County AL Need" TEXT, "County Percent of Population 65 or Older" TEXT, "County Median Age" TEXT, "County Homeownership Rate" TEXT, "County College Education or Higher Rate" TEXT, "County Percent Black Population" TEXT, "County Median Home Value of Owned Homes" TEXT, "County Percent Hispanic Population" TEXT, "County Percent of Population 85 or Older" TEXT, "County Median Household Income" TEXT, "County Unemployment Rate" TEXT, "County Less Than High School Diploma Rate" TEXT, "County Percent Whilte Population" TEXT, "County Gender Ratio" TEXT, "County Poverty Rate" TEXT);