Funeral Homes in US

Addresses, phone numbers, services of funeral homes in US

Data Structure

city [12,455]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)
city_to_funeral_home [66,013]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ funeral_home_id (100%)
funeral_home [19,101]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ streetaddress (99.9%)
varchar(255)
+ city (100%)
bigint(20) unsigned
+ city_id (99.2%)
varchar(255)
+ state (100%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (100%)
varchar(255)
+ phone (100%)
varchar(255)
+ warranty (3.3%)
varchar(255)
+ contact (4.8%)
varchar(255)
+ business_description (4.4%)
varchar(255)
+ senior_discount (2.8%)
varchar(255)
+ excluded_service (0.8%)
varchar(255)
+ service (100%)
varchar(255)
+ website (4.5%)
varchar(255)
+ service_area (3.9%)
varchar(255)
+ office_hour (3.5%)
varchar(255)
+ licensed (100%)
varchar(255)
+ city_served (5.6%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

This database comes with 19,101 funeral homes across 12,455 cities in 51 states of the United States. There are location city, state, street address, zip code, phone number, warranty, contact, business description, senior discount, services, website URL, service area, office hours, licensed and city served in table funeral home.

Data Profile

Size 23.52M
Tables 4
Last Commit 2016-09-02 03:30:32

Updates / Commits

Time Size Tables Columns Rows
2016-09-02 03:30:32 23.52M 4 36 97620

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 12,455 .001 12.455
city_to_funeral_home 66,013 .001 66.013
funeral_home 19,101 .001 19.101
state 51 .001 0.051
Total Credits 97.62 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.