This database was primarily created for testing purposes.
The SQLite database contains the following columns:
"id" INTEGER,
"first_name" TEXT UNIQUE,
"last_name" TEXT UNIQUE,
"gender" TEXT,
"job_title" TEXT,
"street" TEXT UNIQUE,
"city" TEXT,
"state" TEXT,
"zip" TEXT,
"company" TEXT UNIQUE,
"phone" TEXT UNIQUE,
Columns
first_name
andlast_name
are sorted by popularity
The
street
address column does not represent an actual physical location rather, it is the result of the concatenation of randomly pulled plausible house number and randomly pulled plausible street name.
Columns
city
,state
andzip
are pulled together randomly from United States ZIP Codes database
- First Name and Gender - Popular Baby Names - US Social Security
- Last Name - United States Census Bureau
- Job Title - Bureau of Labor Statistics of the USA
- Street - OpenAddresses
- City, State and Zip - United States Postal Service
- Company and Phone - Faker NPM library