Skip to content

Embed URL

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
-- using SQLite3
-- create the table
CREATE TABLE census_data (
image_ref TEXT,
line_number INT,
forenames TEXT,
surname TEXT,
relationship TEXT
);
-- load the Tucker data
INSERT INTO census_data VALUES (12345,1,"Richard","Tucker","farther");
INSERT INTO census_data VALUES (12345,2,"Sarah Ann","Tucker","mother");
INSERT INTO census_data VALUES (12345,3,"Elizabeth Hannah",NULL,"daughter");
INSERT INTO census_data VALUES (12345,4,"Ellen Lewis",NULL,"daughter");
-- load the Smith data
INSERT INTO census_data VALUES (67890,1,"Richard","Smith","farther");
INSERT INTO census_data VALUES (67890,2,"Sarah Ann","Smith","mother");
INSERT INTO census_data VALUES (67890,3,"Elizabeth Hannah",NULL,"daughter");
INSERT INTO census_data VALUES (67890,4,"Ellen Lewis",NULL,"daughter");
-- I'm almost 100% sure you can fill in the missing surnames in pure
-- SQL, it just escapes my miniscule grey cells at the moment :(
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.