names

36 rows where place_id = 588108

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593392 1865566 1865566 defendant Porter John merchant 588108 588108 Porter, John, of Mynhed, Soms, merchant 0
3593394 1865567 1865567 defendant Porter John merchant 588108 588108 Porter, John, of Mynhed, Soms, merchant 0
3717374 1931718 1931718 defendant Peers John yeoman 588108 588108 Peers, John, of Mynhed, Soms, yeoman 0
3718285 1932003 1932003 defendant Soly Walter gent 588108 588108 (Soly, Walter, of Mynhed, Soms, gent 1
3724908 1934077 1934077 defendant Bray John husbandman 588108 588108 Bray, John, of Mynhed, Soms, husbandman 0
3733954 1936868 1936868 defendant Soly Walter gent 588108 588108 (Soly, Walter, of Mynhed, Soms, gent 1
3762479 1945908 1945908 defendant Foscombe William merchant 588108 588108 Foscombe, William, of Mynhed, Soms, merchant 0
3768294 1947725 1947725 defendant Soly Walter yeoman 588108 588108 Soly, Walter, of Mynhed, Soms, yeoman 0
3772178 1948987 1948987 plaintiff Tyddys Richard (legal representative) 588108 588108 Tyddys, Richard, of Mynhed, Soms, merchant, executrix of 0
3783244 1952513 1952513 defendant Soole Walter gent 588108 588108 Soole, Walter, of Mynhed, Soms, gent 0
3881237 1983993 1983993 defendant Seely Walter gent 588108 588108 Seely, Walter, of Mynhed, Soms, gent 0
3955220 2008890 2008890 defendant Dowdyng John merchant 588108 588108 Dowdyng, John, of Mynhed, Soms, merchant 2
3986325 2019848 2019848 defendant Cruse John clothier 588108 588108 Cruse, John, of Mynhed, Soms, clothier 0
4001972 2025484 2025484 defendant Fugars James yeoman 588108 588108 Fugars, James, of Mynhed, Soms, yeoman 0
4007564 2027489 2027489 defendant Wythers William clothier 588108 588108 Wythers, William, of Mynhed, Soms, clothier 0
4032588 2036305 2036305 defendant Crasman Richard yeoman 588108 588108 Crasman, Richard, of Mynhed, Soms, yeoman 0
4032590 2036305 2036305 defendant Horlocke John yeoman 588108 588108 Horlocke, John, of Mynhed, Soms, yeoman 2
4032592 2036306 2036306 defendant Crasman Richard yeoman 588108 588108 Crasman, Richard, of Mynhed, Soms, yeoman 0
4032594 2036306 2036306 defendant Horlocke John yeoman 588108 588108 Horlocke, John, of Mynhed, Soms, yeoman 2
4040575 2039124 2039124 defendant Dennell William yeoman 588108 588108 Dennell, William, of Mynhed, Soms, yeoman 0
4190783 2092339 2092339 defendant Kent John merchant 588108 588108 Kent, John, of Mynhed, Soms, merchant 0
4190824 2092354 2092354 defendant Cruse John clothier 588108 588108 Cruse, John, of Mynhed, Soms, clothier 0
4359038 2150395 2150395 defendant Quircke James merchant 588108 588108 Quircke, James, of Mynhed, Soms, merchant 0
4383859 2159305 2159305 defendant Quircke James merchant 588108 588108 Quircke, James, of Mynhed, Soms, merchant 0
4823685 2303499 2303499 defendant Spencer Edmund husbandman 588108 588108 Spencer, Edmund, of Mynhed, Soms, husbandman 0
4925991 2334559 2334559 defendant Godryngton Geoffrey clerk 588108 588108 Godryngton, Geoffrey, of Mynhed, Soms, clerk 0
4951933 2342553 2342553 defendant Bratton Thomas gent 588108 588108 Bratton, Thomas, of Mynhed, Soms, gent 0
5042184 2369269 2369269 defendant Symond John merchant 588108 588108 Symond, John, of Mynhed, Soms, merchant 1
5392065 2472810 2472810 defendant Hargate John mariner 588108 588108 Hargate, John, of Mynhed, Soms, mariner 0
5392075 2472814 2472814 defendant Hargate John mariner 588108 588108 Hargate, John, of Mynhed, Soms, mariner 0
5405086 2476532 2476532 defendant Hargate John mariner 588108 588108 Hargate, John, of Mynhed, Soms, mariner 0
5405092 2476535 2476535 defendant Hargate John mariner 588108 588108 Hargate, John, of Mynhed, Soms, mariner 0
5482599 2499735 2499735 defendant Palmer John yeoman 588108 588108 Palmer, John, of Mynhed, Soms, yeoman 0
5492395 2502641 2502641 defendant Holme John yeoman 588108 588108 Holme, John, of Mynhed, Soms, yeoman 0
5492397 2502642 2502642 defendant Holme John yeoman 588108 588108 Holme, John, of Mynhed, Soms, yeoman 0
5548144 2519487 2519487 defendant Bourgh Robert mariner 588108 588108 Bourgh, Robert, of Mynhed, Soms, mariner 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);