names

21 rows where place_id = 658334

✎ 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
3921196 1997442 1997442 plaintiff Parker Thomas (legal representative) 658334 658334 Parker, Thomas, of North Molton, Devon, executor of 0
3947962 2006350 2006350 defendant Clotworthie Thomas gent 658334 658334 Clotworthie, Thomas, of North Molton, Devon, gent 0
4008429 2027781 2027781 defendant Toker William husbandman 658334 658334 Toker, William, of North Molton, Devon, husbandman 0
4070810 2049855 2049855 defendant Tocker William yeoman 658334 658334 Tocker, William, of North Molton, Devon, yeoman 1
4093365 2057944 2057944 defendant Parker John esq 658334 658334 Parker, John, of North Molton, Devon, esq 0
4137637 2073814 2073814 defendant Shatticke Richard yeoman 658334 658334 Shatticke, Richard, of North Molton, Devon, yeoman 1
4139349 2074438 2074438 defendant Courtney Thomas gent 658334 658334 Courtney, Thomas, of North Molton, Devon, gent 0
4164122 2082976 2082976 defendant Courteney Thomas gent 658334 658334 Courteney, Thomas, of North Molton, Devon, gent 0
4195066 2093838 2093838 defendant Pryor Henry husbandman 658334 658334 Pryor, Henry, of North Molton, Devon, husbandman 0
4205804 2097577 2097577 defendant Kerbye John weaver 658334 658334 Kerbye, John, of North Molton, Devon, weaver 1
4360900 2151069 2151069 defendant Courtney Thomas gent 658334 658334 Courtney, Thomas, of North Molton, Devon, gent 0
4380791 2158244 2158244 defendant Courtney Thomas gent 658334 658334 Courtney, Thomas, of North Molton, Devon, gent 0
4812518 2300030 2300030 defendant Beef John gent 658334 658334 Beef, John, of North Molton, Devon, gent 1
4987214 2353124 2353124 defendant Squyer Thomas collier 658334 658334 Squyer, Thomas, of North Molton, Devon, collier 1
5088496 2383013 2383013 defendant Fader Walter esq 658334 658334 Fader, Walter, of North Molton, Devon, esq 1
5119473 2392125 2392125 defendant de St Maur Thomas   658334 658334 de St Maur, Thomas, of North Molton, Devon, knight 0
5119490 2392130 2392130 defendant de St Maur Thomas   658334 658334 de St Maur, Thomas, of North Molton, Devon, knight 0
5119492 2392131 2392131 defendant de St Maure Thomas   658334 658334 de St Maure, Thomas, of North Molton, Devon, knight 0
5218137 2421039 2421039 defendant Seyntmare Thomas   658334 658334 Seyntmare, Thomas, of North Molton, Devon, knight 4
5489906 2501867 2501867 defendant Harper Nicholas clerk 658334 658334 Harper, Nicholas, of North Molton, Devon, clerk 1
5504810 2506425 2506425 defendant Harper Nicholas clerk 658334 658334 Harper, Nicholas, of North Molton, Devon, clerk 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);