US Photographers and Videographers

Phone numbers, addresses of US photographers & videographers

Data Structure

city [25,295]
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_photography [3,226,411]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ photography_id (100%)
photography [83,477]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(30)
+ zip_code (100%)
varchar(50)
+ phone (99.9%)
varchar(255)
+ address (100%)
text
+ description (1.3%)
state [48]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
char(4)
+ abbreviation (100%)
varchar(255)
+ slug (100%)

Description

There are a total of 83,477 professional wedding photographers, digital videography studios or special event video makers in this database, each record of which consists of phone numbers, addresses, detailed descriptions and zip codes across 48 states at 25,295 cities in the United States. There are 83,403 unique phone numbers in table photography.

Data Profile

Size 359.28M
Tables 4
Last Commit 2016-09-05 04:38:55

Updates / Commits

Time Size Tables Columns Rows
2016-09-05 04:38:55 359.28M 4 23 3335231

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 25,295 .001 25.295
city_to_photography 3,226,411 .001 3226.411
photography 83,477 .001 83.477
state 48 .001 0.048
Total Credits 3335.231 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.