names

24 rows where place_id = 762163

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4485237 2196087 2196087 defendant Julyan Thomas   762163 762163 Julyan, Thomas, of Wendovere 0
4487172 2196713 2196713 defendant Barbour John   762163 762163 Barbour, John, of Wendovere 1
4499966 2200629 2200629 plaintiff Hogges John   762163 762163 Hogges, John, of Wendovere, on his own account 0
4499967 2200629 2200629 defendant Barbour John   762163 762163 Barbour, John, of Wendovere 0
4521291 2207003 2207003 defendant Gerveys John   762163 762163 Gerveys, John, of Wendovere 1
4549404 2215758 2215758 defendant Attekyn Richard   762163 762163 Attekyn, Richard, of Wendovere 1
4552494 2216737 2216737 defendant Gerveys Robert   762163 762163 Gerveys, Robert, of Wendovere 0
4552495 2216737 2216737 defendant Fowkes William   762163 762163 Fowkes, William, of Wendovere 1
4552775 2216816 2216816 defendant Gerveys John   762163 762163 Gerveys, John, of Wendovere 0
4691396 2262833 2262833 defendant Adekyn Richard husbandman 762163 762163 Adekyn, Richard, of Wendovere, husbandman 1
4778239 2289177 2289177 plaintiff Bedeforde Agnes   762163 762163 Bedeforde, Agnes, of Wendovere 0
4867898 2316929 2316929 defendant Lee John yeoman 762163 762163 Lee, John, of Wendovere, yeoman 0
4869331 2317375 2317375 defendant Hautreve Richard gent 762163 762163 Hautreve, Richard, of Wendovere, gent 0
4878482 2320213 2320213 defendant Poynat Thomas husbandman 762163 762163 Poynat, Thomas, of Wendovere, husbandman 0
4902598 2327432 2327432 defendant Hautreve Richard gent 762163 762163 Hautreve, Richard, of Wendovere, gent 0
4973085 2348883 2348883 plaintiff Lechegame Nicholas fletcher 762163 762163 Lechegame, Nicholas, of Wendovere, fletcher 0
4973087 2348884 2348884 plaintiff Lechegame Nicholas fletcher 762163 762163 Lechegame, Nicholas, of Wendovere, fletcher 0
5047393 2370840 2370840 defendant Stephenes John fuller 762163 762163 Stephenes, John, of Wendovere, fuller 0
5047394 2370840 2370840 defendant Stepehenes William fuller 762163 762163 Stepehenes, William, of Wendovere, fuller 1
5110701 2389535 2389535 plaintiff Horewode John   762163 762163 Horewode, John, of Wendovere 1
5110704 2389536 2389536 plaintiff Horewode John   762163 762163 Horewode, John, of Wendovere 1
5221222 2421905 2421905 defendant Smyth Thomas smith 762163 762163 Smyth, Thomas, of Wendovere, smith 2
5221224 2421905 2421905 defendant Agas John roper 762163 762163 Agas, John, of Wendovere, roper 4
5625441 2551901 2551901 defendant May Richard baker 762163 762163 May, Richard, of Wendovere, baker 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);