names

19 rows where place_id = 606352

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664900 1914968 1914968 defendant Unketyll Thomas yeoman 606352 606352 Unketyll, Thomas, of Hawe, yeoman 0
3715419 1931108 1931108 defendant Haryson William husbandman 606352 606352 Haryson, William, of Hawe, husbandman 2
3775580 1950108 1950108 defendant Bolt Thomas, junior husbandman 606352 606352 Bolt, Thomas, junior, of Hawe, husbandman 0
3824526 1965541 1965541 defendant Horne Roger boatman 606352 606352 Horne, Roger, of Hawe, boatman 0
3918890 1996640 1996640 defendant Robyns Richard husbandman 606352 606352 Robyns, Richard, of Hawe, husbandman 1
4541869 2213349 2213349 defendant Fouler Thomas   606352 606352 Fouler, Thomas, of Hawe 0
4616211 2236072 2236072 defendant Worthyngton John de   606352 606352 Worthyngton, John de, of Hawe, brother of William Worthyngton, of Craweschawe 1
4616212 2236072 2236072 defendant Bradschawe Thomas   606352 606352 Bradschawe, Thomas, of Hawe 2
4742453 2278292 2278292 defendant Cook William husbandman 606352 606352 Cook, William, of Hawe, husbandman 0
4772909 2287498 2287498 defendant White John husbandman 606352 606352 White, John, of Hawe, husbandman 2
4798174 2295623 2295623 defendant Whyte John husbandman 606352 606352 Whyte, John, of Hawe, husbandman 2
4816604 2301284 2301284 defendant Cook William yeoman 606352 606352 Cook, William, of Hawe, yeoman 1
4915020 2331203 2331203 defendant Cook William husbandman 606352 606352 Cook, William, of Hawe, husbandman 1
4940387 2339015 2339015 defendant Cook William husbandman 606352 606352 Cook, William, of Hawe, husbandman 2
5389861 2472162 2472162 defendant Chaumber John tailor 606352 606352 Chaumber, John, of Hawe, tailor 1
5402666 2475837 2475837 defendant Chaumbur John tailor 606352 606352 Chaumbur, John, of Hawe, tailor 1
5465315 2494532 2494532 defendant Sloghtour John husbandman 606352 606352 Sloghtour, John, of Hawe, husbandman 0
5476806 2498065 2498065 defendant Sloghtour John husbandman 606352 606352 Sloghtour, John, of Hawe, husbandman 0
5560320 2522979 2522979 defendant Kent Thomas cooper 606352 606352 Kent, Thomas, of Hawe, cooper 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);