Sample data is randomly generated.
We use real first names and real last names and combine them randomly, so you may find your name there, but if so it is simply coincidence.
We also use real postcodes with their matching address_line_2 and town. If a postcode and a person's name match to a real person, that would be a big coincidence.
| Link to Download | Description |
|---|---|
| create_supporter.sql | SQL script to create the supporter table |
| supporter.csv | data file of sample supporter data |
| copy_supporter.sql | PostgreSQL copy command to load the supporter data from the .csv file to the table |
| create_donation.sql | SQL script to create the donation table |
| donation.csv | data file of sample donation data |
| copy_donation.sql | PostgreSQL copy command to load the donation data from the .csv file to the table |
| create_correspondence.sql | SQL script to create the correspondence table |
| correspondence.csv | data file of sample correspondence data |
| copy_correspondence.sql | PostgreSQL copy command to load the correspondence data from the .csv file to the table |
| joins.sql | PostgreSQL script to illustrate different types of join |