Background

For a database work that I am doing, I continue to look for sample data.

Googled for test data.

Sample Data

Data Design Group, Inc

ConvertCSV.COM

Person

Keywords

1. URL
   • Generate Data
     • https://www.convertcsv.com/generate-test-data.htm
       Link
   • Keywords
     • Keyword
       Link
2. Columns
   • First Name
     • first
   • Last Name
     • last
   • Middle Initial
     • mi
   • Name
     • name
   • Birthday
     • birthday
     • date
   • Gender
     • M for Male
     • F for Female
   • Street
     • Street
   • Address
   • City
     • city
   • Province
     • Province ( Canadian Province )
   • State
     • State
   • Postal Code
     • Postal ( Canadian Postal )
   • Zip Code
     • Zip
       • 5 digit US zip code
     • zip9
       • 9 digit US zip code in 99999-9999 format
   • Phone Number
     • Phone
   • Email Address
     • email
   • Currency
     • dollar
   • Credit Card Number
     • ccnumber

Test Data

Preparation

Outline

1. Keyword
   • In the keywords, please enter which columns you will like to generate
     • i.e first, last, email, address, street, city state, zip, data
2. Name
   • Match keywords in the Names entry field
3. Output Format
   • Choices
     • CSV
     • JSON
     • HTML
4. Number of Records
   • Indicate Number of records to create
   • One can indicate any number between 1 and 100,000
5. Header for CSV
   • Please indicate header for CSV files
     • Single file header line that will contain the names of the columns

Source Code Control

GitLab

1. Snippet
   • Link
     https://gitlab.com/-/snippets/2505056
   • Files
     • Table DDL
       • SQL Server
         • convertcsv.person.sql
     • Table DML
       • SQL Server
         • convertcsv.person.data.add.sql
     • Data Files
       • person.csv