Home Data Employment Job Boards + Employment

US 966,580 Jobs Database: Address, Phone, Company w/ Description, Requirement, Snapshot

Data	709.98M (+ 0B)
Tables	10 (+ 0)
Columns	45 (+ 0)
Table Rows	4,569,280 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2019-01-23 09:46:38 (+ 44 d)

This is a database of 966,580 jobs with title, address, phone number, company profile and job number in each of the United States. There are 341,074 description records, 115,848 requirement records and 13,938 snapshot records of these jobs in the database. The whole America jobs database consists of 10 tables.

Data Samples

Main (Desktop) / JSON / Excel / CSV (Download)

Database APIs

http://n3.datasn.io/data/api/v1/n3_chennan/career_resource/ (By Table)

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
category_1	26	title	100%
category_2	583	title	100%
		category_1_id	100%
		category_1	100%
category_2_x_job	967,344	category_2_id	100%
category_2_x_job	967,344	job_id	100%
job	966,580	title	99.7%
		address	11.3%
		phone	2.41%
		company_profile	11.22%
		job_no	9.34%
job_description	341,074	title	100%
job_requirement	115,848	title	100%
job_snapshot	13,938	title	100%
job_x_job_description	1,224,978	job_id	100%
job_x_job_description	1,224,978	job_description_id	100%
job_x_job_requirement	468,896	job_id	100%
job_x_job_requirement	468,896	job_requirement_id	100%
job_x_job_snapshot	470,013	job_id	100%
job_x_job_snapshot	470,013	job_snapshot_id	100%

Notes:

Meta columns id and ts are not shown here, but included in columns total.
Some statistical or memo columns are not shown here, but included in columns total.
Non-empty percentage indicates the percent of values that are non-empty for that particular column.

Media Sets

No media sets.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2019-01-23 (+ 44 d)	709.98M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	709.98M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	709.98M (+ 342.84M)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11 (+ 38 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-03-03 (+ 35 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-01-27 (+ 29 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-12-29 (+ 20 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-12-08 (+ 9 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-11-28 (+ 19 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-11-09 (+ 10 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-10-29 (+ 19 d)	367.14M (+ 0B)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-10-09 (+ 31 d)	367.14M (+ 20M)	10 (+ 0)	45 (+ 0)	4,569,280 (+ 1,473,772)	0B (+ 0B)	0 (+ 0)
2017-09-08	347.14M	10	45	3,095,508	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Request Access

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to generate API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Make and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.