Corporation Profiles (US)

United States Large Corporation Information / Profiles Database

Data Structure

category [153]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ topcategory_id (100%)
varchar(255)
+ count (100%)
varchar(255)
+ url (100%)
city [25,726]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ url (100%)
bigint(20) unsigned
+ state_id (100%)
char(1)
+ letter (100%)
listing [302,366]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ state_id (98.7%)
bigint(20) unsigned
+ city_id (97.4%)
bigint(20) unsigned
+ subcategory_id (100%)
text
+ intro (100%)
varchar(255)
+ location (99.6%)
varchar(255)
+ address (66.6%)
varchar(255)
+ website (67%)
varchar(255)
+ phone (63.1%)
varchar(255)
+ fax (46%)
varchar(255)
+ revenue (41.1%)
varchar(255)
+ employee (36.2%)
text
+ description (67%)
text
+ important_people (23.9%)
state [50]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ url (100%)
subcategory [16,992]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ url (100%)
bigint(20) unsigned
+ category_id (100%)
smallint(6)
+ count (100%)
topcategory [24]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ url (100%)
mediumint(9)
+ count (100%)

Description

Over 300,000 distinct records of large United States companies and businesses (known corporations), mostly with online presence and success, categorized under states / cities as well as 3 levels of classifications (18,000 of different categories), with business name, introduction, detailed description, business address, website URL, phone number, fax number, annual revenue, total employees and the leading board (full names and positions). We recommend the US yellow pages database.

Data Profile

Size 490.12M
Tables 6
Last Commit 2016-08-25 22:19:23

Updates / Commits

Time Size Tables Columns Rows
2016-08-25 22:19:23 490.12M 6 43 345311

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
category 153 .001 0.153
city 25,726 .001 25.726
listing 302,366 .001 302.366
state 50 .001 0.05
subcategory 16,992 .001 16.992
topcategory 24 .001 0.024
Total Credits 345.311 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.