names

24 rows where place_id = 604295

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657534 1912617 1912617 defendant Denton John husbandman 604295 604295 Denton, John, of Leven, husbandman 0
3657535 1912617 1912617 defendant Alderson Richard husbandman 604295 604295 Alderson, Richard, of Leven, husbandman 1
4560140 2219116 2219116 defendant Clerk Edward   604295 604295 Clerk, Edward, of Leven 1
4611618 2234697 2234697 plaintiff Coke Hugh   604295 604295 Coke, Hugh, of Leven 0
4624073 2238506 2238506 defendant Day Stephen   604295 604295 Day, Stephen, of Leven 0
4634087 2241509 2241509 defendant Wartre John de   604295 604295 Wartre, John de, of Leven 3
4634088 2241509 2241509 defendant Robertson Thomas   604295 604295 Robertson, Thomas, of Leven 4
4634858 2241754 2241754 defendant Burdon William   604295 604295 Burdon, William, of Leven 4
4635799 2242038 2242038 defendant Beston John   604295 604295 Beston, John, of Leven 0
4661667 2249488 2249488 defendant Henryson John husbandman 604295 604295 Henryson, John, of Leven, husbandman 0
4681978 2259980 2259980 defendant Gray William yeoman 604295 604295 Gray, William, of Leven Water, yeoman 0
4681981 2259980 2259980 defendant Weddall Robert yeoman 604295 604295 Weddall, Robert, of Leven Water, yeoman 3
4686513 2261389 2261389 defendant Burdon William yeoman 604295 604295 Burdon, William, of Leven, yeoman 2
4686514 2261389 2261389 defendant Esyngton John yeoman 604295 604295 Esyngton, John, of Leven, yeoman 3
4695758 2264155 2264155 defendant Sadiler Joan widow 604295 604295 Sadiler, Joan, of Leven, widow 0
4764507 2284884 2284884 defendant Storme John clerk 604295 604295 Storme, John, of Leven, clerk 0
4811732 2299778 2299778 defendant Stalworthman William husbandman 604295 604295 Stalworthman, William, of Leven, husbandman 0
5168001 2406351 2406351 defendant Beverley Thomas fisherman 604295 604295 Beverley, Thomas, of Leven, fisherman 0
5168002 2406351 2406351 defendant Beverley William fisherman 604295 604295 Beverley, William, of Leven, fisherman 1
5183730 2410976 2410976 defendant Beverley Thomas fishmonger 604295 604295 Beverley, Thomas, of Leven, fishmonger 0
5183731 2410976 2410976 defendant Beverley William fishmonmonger 604295 604295 Beverley, William, of Leven, fishmonmonger 1
5234610 2425709 2425709 defendant Stevenson John clerk 604295 604295 Stevenson, John, of Leven, clerk 1
5234611 2425709 2425709 defendant Otryngham Robert husbandman 604295 604295 Otryngham, Robert, of Leven, husbandman 2
5234612 2425709 2425709 defendant Broune Hamon husbandman 604295 604295 Broune, Hamon, of Leven, husbandman 3

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