names

22 rows where place_id = 674657

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4015050 2030076 2030076 defendant Cooke John clerk 674657 674657 Cooke, John, of Strumpshawe, clerk 1
4076645 2051942 2051942 defendant Wakefyld George husbandman 674657 674657 Wakefyld, George, of Strumpshawe, husbandman 8
4079023 2052796 2052796 defendant Sharpes alias Ketteryngson Thomas husbandman 674657 674657 Sharpes alias Ketteryngson, Thomas, of Strumpshawe, husbandman 1
4126792 2069872 2069872 defendant Sharplus alias Katterinson Thomas husbandman 674657 674657 Sharplus alias Katterinson, Thomas, of Strumpshawe, husbandman 0
4143499 2075885 2075885 defendant Howard Henry husbandman 674657 674657 Howard, Henry, of Strumpshawe, husbandman 0
4150143 2078185 2078185 defendant Sherples alias Ketteringson Thomas husbandman 674657 674657 Sherples alias Ketteringson, Thomas, of Strumpshawe, husbandman 1
4160802 2081855 2081855 defendant Sharples Thomas husbandman 674657 674657 Sharples, Thomas, of Strumpshawe, husbandman 0
4177322 2087540 2087540 defendant Goodwyne John husbandman 674657 674657 Goodwyne, John, of Strumpshawe, husbandman 3
4182930 2089510 2089510 defendant Gamblyn John husbandman 674657 674657 Gamblyn, John, of Strumpshawe, husbandman 2
4191848 2092706 2092706 defendant Howard Henry yeoman 674657 674657 Howard, Henry, of Strumpshawe, yeoman 0
4250885 2113276 2113276 defendant Jackson Thomas clerk 674657 674657 Jackson, Thomas, of Strumpshawe, clerk 0
4259351 2116104 2116104 defendant Sharpples alias Katrinson Thomas husbandman 674657 674657 Sharpples alias Katrinson, Thomas, of Strumpshawe, husbandman 1
4339918 2143733 2143733 defendant Buntinge George thatcher 674657 674657 Buntinge, George, of Strumpshawe, thatcher 1
4759695 2283380 2283380 defendant Rysyng Edmund yeoman 674657 674657 Rysyng, Edmund, of Strumpshawe, yeoman 1
4759769 2283393 2283393 defendant Rysyng Edmund yeoman 674657 674657 Rysyng, Edmund, of Strumpshawe, yeoman 1
4888120 2323090 2323090 defendant Eche John husbandman 674657 674657 Eche, John, of Strumpshawe, husbandman 0
5101624 2386898 2386898 defendant Dallyng William husbandman 674657 674657 Dallyng, William, of Strumpshawe, husbandman 0
5263627 2434374 2434374 defendant Risyng William husbandman 674657 674657 Risyng, William, of Strumpshawe, husbandman 0
5263629 2434375 2434375 defendant Rysyng William husbandman 674657 674657 Rysyng, William, of Strumpshawe, husbandman 0
5395136 2473675 2473675 defendant Goeryche Richard husbandman 674657 674657 Goeryche, Richard, of Strumpshawe, husbandman 7
5401872 2475600 2475600 defendant Goderyche Richard husbandman 674657 674657 Goderyche, Richard, of Strumpshawe, husbandman 7
5414806 2479364 2479364 defendant Goderyche Richard husbandman 674657 674657 Goderyche, Richard, of Strumpshawe, husbandman 6

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);