names

33 rows where place_id = 595248

✎ 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
3619628 1873709 1873709 defendant Man William tanner 595248 595248 Man, William, of Sundryssh, tanner 0
4439193 2181538 2181538 defendant Boouche Thomas   595248 595248 Boouche, Thomas, of Sundryssh 0
4579571 2225095 2225095 defendant Brice William   595248 595248 Brice, William, of Sundryssh 0
4658755 2248611 2248611 defendant Mody Robert   595248 595248 Mody, Robert, of Sundryssh, servant 2
4658756 2248611 2248611 defendant Chelescombe Alan husbandman 595248 595248 together with Chelescombe, Alan, of Sundryssh, husbandman 3
4658757 2248611 2248611 defendant Chelescombe Thomas husbandman 595248 595248 Chelescombe, Thomas, of Sundryssh, husbandman 4
4658758 2248611 2248611 defendant Duraunt John butcher 595248 595248 Duraunt, John, of Sundryssh, butcher 5
4658759 2248611 2248611 defendant Alfey John chapman 595248 595248 Alfey, John, of Sundryssh, chapman 6
4658761 2248612 2248612 defendant Chelescombe Alan husbandman 595248 595248 Chelescombe, Alan, of Sundryssh, husbandman 0
4658762 2248612 2248612 defendant Chelescombe Thomas husbandman 595248 595248 Chelescombe, Thomas, of Sundryssh, husbandman 1
4658765 2248612 2248612 defendant Mody Robert   595248 595248 Mody, Robert, of Sundryssh, servant 4
4658766 2248612 2248612 defendant Duraunt John butcher 595248 595248 Duraunt, John, of Sundryssh, butcher 5
4658767 2248612 2248612 defendant Alfey John chapman 595248 595248 Alfey, John, of Sundryssh, chapman 6
4834963 2306939 2306939 defendant Taillour John carpenter 595248 595248 Taillour, John, of Sundryssh, carpenter 1
4841145 2308766 2308766 defendant Corche Peter miller 595248 595248 Corche, Peter, of Sundryssh, miller 0
5052429 2372324 2372324 defendant Hole William esq 595248 595248 Hole, William, of Sundryssh, esq 0
5052433 2372325 2372325 defendant Isle William esq 595248 595248 Isle, William, of Sundryssh, esq 0
5058168 2374000 2374000 defendant Morecok William husbandman 595248 595248 Morecok, William, of Sundryssh, husbandman 4
5058187 2374003 2374003 defendant Morco William tanner 595248 595248 together with Morco, William, of Sundryssh, tanner 3
5068359 2377038 2377038 defendant Thorne Richard yeoman 595248 595248 Thorne, Richard, of Sundryssh, yeoman 2
5106893 2388444 2388444 defendant Chedyngstone Hugh husbandman 595248 595248 Chedyngstone, Hugh, of Sundryssh, husbandman 1
5117182 2391454 2391454 defendant Barnard John butcher 595248 595248 Barnard, John, of Sundryssh, butcher 0
5147260 2400341 2400341 defendant Chedyngstone Hugh husbandman 595248 595248 Chedyngstone, Hugh, of Sundryssh, husbandman 0
5167028 2406090 2406090 defendant Chedyngstone Hugh husbandman 595248 595248 Chedyngstone, Hugh, of Sundryssh, husbandman 0
5190700 2413029 2413029 defendant Morecok Thomas laborer 595248 595248 Morecok, Thomas, of Sundryssh, laborer 0
5281951 2439797 2439797 defendant Bernard John yeoman 595248 595248 Bernard, John, of Sundryssh, yeoman 0
5281953 2439797 2439797 defendant Gascoigne Nicholas esq 595248 595248 Gascoigne, Nicholas,of Sundryssh, esq 2
5358473 2462703 2462703 defendant Isle John esq 595248 595248 Isle, John, of Sundryssh, esq 0
5358477 2462705 2462705 defendant Isley John esq 595248 595248 Isley, John, of Sundryssh, esq 0
5394162 2473391 2473391 defendant Symson Robert laborer 595248 595248 Symson, Robert, of Sundryssh, laborer 0
5407306 2477153 2477153 defendant Symson Robert laborer 595248 595248 Symson, Robert, of Sundryssh, laborer 0
5420543 2481068 2481068 defendant Symson Robert   595248 595248 Symson, Robert, of sundryssh 0
5451951 2490466 2490466 defendant Stabyll William husbandman 595248 595248 Stabyll, William, of Sundryssh, husbandman 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);