names

36 rows where place_id = 622644

✎ 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
3748163 1941355 1941355 defendant Franke Percival chaplain 622644 622644 Franke, Percival, of Potter Newton, chaplain 0
4005676 2026803 2026803 defendant Bales Brian esq 622644 622644 Bales, Brian, of Potter Newton, esq 0
4023682 2033180 2033180 plaintiff Bayles Brian esq 622644 622644 Bayles, Brian, of Potter Newton, esq 0
4023688 2033181 2033181 plaintiff Bayles Brian esq 622644 622644 Bayles, Brian, of Potter Newton, esq 0
4055050 2044204 2044204 defendant Hardwycke Thomas esq 622644 622644 Hardwycke, Thomas, of Potter Newton, esq 0
4067574 2048720 2048720 defendant Marshall Thomas yeoman 622644 622644 Marshall, Thomas, of Potter Newton, yeoman 0
4071288 2050035 2050035 plaintiff Morres William tanner 622644 622644 Morres, William, of Potter Newton, tanner 0
4071290 2050036 2050036 plaintiff Morres William tanner 622644 622644 Morres, William, of Potter Newton, tanner 0
4071301 2050040 2050040 plaintiff Morris William tanner 622644 622644 Morris, William, of Potter Newton, tanner 0
4085652 2055140 2055140 defendant Hardwycke Anne widow 622644 622644 Hardwycke, Anne, of Potter Newton, widow 1
4089437 2056508 2056508 defendant Barnebye John gent 622644 622644 Barnebye, John, of Potter Newton, gent 0
4089440 2056509 2056509 defendant Barnebye John gent 622644 622644 Barnebye, John, of Potter Newton, gent 0
4096870 2059215 2059215 plaintiff Hardwicke Thomas (legal representative) 622644 622644 Hardwicke, Thomas, of Potter Newton, gent, administratrix of 0
4096873 2059216 2059216 plaintiff Hardwicke Thomas (legal representative) 622644 622644 Hardwicke, Thomas, of Potter Newton, gent, administratrix of 0
4104716 2061967 2061967 plaintiff Morrys alias Morhayse William yeoman 622644 622644 Morrys alias Morhayse, William, of Potter Newton, yeoman 0
4118840 2067022 2067022 defendant Morres William tanner 622644 622644 Morres, William, of Potter Newton, tanner 0
4126038 2069599 2069599 defendant Hardwick Thomas   622644 622644 Hardwick, Thomas, of Potter Newton, Yorks esq, administrators of 0
4126105 2069625 2069625 defendant Morris William tanner 622644 622644 Morris, William, of Potter Newton, tanner 0
4133592 2072348 2072348 defendant Marshall Thomas yeoman 622644 622644 Marshall, Thomas, of Potter Newton, yeoman 0
4146739 2077012 2077012 defendant Marshall Thomas yeoman 622644 622644 Marshall, Thomas, of Potter Newton, or of Scotehall, yeoman 0
4147802 2077371 2077371 defendant Harisonne William yeoman 622644 622644 Harisonne, William, of Potter Newton, yeoman 0
4147804 2077372 2077372 defendant Morres William yeoman 622644 622644 Morres, William, of Potter Newton, yeoman 0
4149278 2077873 2077873 defendant Morrys William tanner 622644 622644 Morrys, William, of Potter Newton, tanner 0
4157514 2080702 2080702 defendant Marshall Thomas yeoman 622644 622644 Marshall, Thomas, of Potter Newton, yeoman 0
4180058 2088504 2088504 defendant Morres William tanner 622644 622644 Morres, William, of Potter Newton, tanner 0
4187291 2091052 2091052 defendant Holmes Edward esq 622644 622644 Holmes, Edward, of Potter Newton, esq 0
4187292 2091052 2091052 defendant Holmes Anne widow 622644 622644 Anne his wife, formerly Anne Hardwicke, of Potter Newton, widow 1
4187295 2091053 2091053 defendant Holmes Anne widow 622644 622644 Anne his wife, formerly Anne Hardwicke, of Potter Newton, widow 1
4191102 2092451 2092451 defendant Holme Edward esq 622644 622644 Holme, Edward, of Potter Newton, esq 0
4262451 2117108 2117108 defendant Holmes Anne widow 622644 622644 Holmes, Anne, of Potter Newton, widow 0
4278750 2122504 2122504 defendant Hardwicke Brian gent 622644 622644 Hardwicke, Brian, of Potter Newton, gent 0
4309715 2133555 2133555 defendant Holmes Anne (legal representative) 622644 622644 Holmes, Anne, of Potter Newton, widow, executor of 0
4309716 2133555 2133555 defendant Hardwicke Brian   622644 622644 Hardwicke, Brian, of Potter Newton gent 1
4314429 2135159 2135159 defendant Hardwick Anne (legal representative) 622644 622644 Hardwick, Anne, of Potter Newton, widow, executor of 0
4314430 2135159 2135159 defendant Hardwick Brian esq 622644 622644 Hardwick, Brian, of Potter Newton, esq 1
4383441 2159172 2159172 defendant Hardwicke Brian gent 622644 622644 Hardwicke, Brian, of Potter Newton, gent 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);