names

31 rows where place_id = 611292

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3687763 1922339 1922339 defendant Bocher alias Adams John chapman 611292 611292 Bocher alias Adams, John, of North Tawton, Devon, chapman 1
3687784 1922344 1922344 defendant Bocher alias Adams John chapman 611292 611292 Bocher alias Adams, John, of North Tawton, Devon, chapman 2
3761690 1945666 1945666 defendant Wode Alexander esq 611292 611292 Wode, Alexander, of North Tawton, Devon, esq 1
3822453 1964921 1964921 defendant Wode Alexander esq 611292 611292 Wode, Alexander, of North Tawton, Devon, esq 0
3916057 1995758 1995758 defendant Fletcher John yeoman 611292 611292 Fletcher, John, of North Tawton, Devon, yeoman 0
3916063 1995759 1995759 defendant Fletcher John yeoman 611292 611292 Fletcher, John, of North Tawton, Devon, yeoman 0
3975522 2016004 2016004 defendant Haywood Robert clothier 611292 611292 Haywood, Robert, of North Tawton, Devon, clothier 0
3989360 2020936 2020936 defendant Sadler Martin esq 611292 611292 Sadler, Martin, of North Tawton, Devon, esq 0
3989623 2021033 2021033 defendant Slader Mark esq 611292 611292 Slader, Mark, of North Tawton, Devon, esq 0
3994207 2022683 2022683 defendant Slader Mark esq 611292 611292 Slader, Mark, of North Tawton, Devon, esq 0
3994716 2022862 2022862 defendant Slayther Mark esq 611292 611292 Slayther, Mark, of North Tawton, Devon, esq 0
3996301 2023427 2023427 defendant Wollacott John husbandman 611292 611292 Wollacott, John, of North Tawton, Devon, husbandman 0
4008649 2027855 2027855 defendant Slader Mark esq 611292 611292 Slader, Mark, of North Tawton, Devon, esq 0
4009855 2028301 2028301 defendant Slader Mark esq 611292 611292 Slader, Mark, of North Tawton, Devon, esq 1
4021591 2032450 2032450 defendant Marten Humphrey yeoman 611292 611292 Marten, Humphrey, of North Tawton, Devon, yeoman 0
4058842 2045557 2045557 defendant Lovyes Thomas gent 611292 611292 Lovyes, Thomas, of North Tawton, Devon, gent 0
4060991 2046339 2046339 defendant Slader Mark esq 611292 611292 Slader, Mark, of North Tawton, Devon, esq 0
4088138 2056049 2056049 defendant Slader Mark esq 611292 611292 Slader, Mark, of North Tawton, Devon, esq 1
4095005 2058542 2058542 defendant Slader Hanibal gent 611292 611292 Slader, Hanibal, of North Tawton, Devon, gent 0
4095007 2058543 2058543 defendant Slader Hannibal gent 611292 611292 Slader, Hannibal, of North Tawton, Devon, gent 0
4095086 2058571 2058571 defendant Colcotte John yeoman 611292 611292 Colcotte, John, of North Tawton, Devon, yeoman 0
4097654 2059489 2059489 defendant Slader Mark esq 611292 611292 Slader, Mark, of North Tawton, Devon, esq 0
4104020 2061712 2061712 defendant Woode John gent 611292 611292 Woode, John, of North Tawton, Devon, gent 0
4113430 2065077 2065077 defendant Wollcotte John yeoman 611292 611292 Wollcotte, John, of North Tawton, Devon, yeoman 0
4113721 2065191 2065191 defendant Slader Hambak gent 611292 611292 Slader, Hambak, of North Tawton, Devon, gent 0
4198666 2095088 2095088 defendant Slader Mark esq 611292 611292 Slader, Mark, of North Tawton, Devon, esq 0
4214800 2100681 2100681 defendant Lovyes or Louyes Lewis gent 611292 611292 (Lovyes or Louyes, Lewis, of North Tawton, Devon, gent 4
4301367 2130597 2130597 defendant Week William gent 611292 611292 Week, William, of North Tawton, Devon, gent 0
4324659 2138639 2138639 defendant Wykes William gent 611292 611292 Wykes, William, of North Tawton, Devon, gent 1
4331487 2140828 2140828 defendant Haywood John yeoman 611292 611292 Haywood, John, of North Tawton, Devon, yeoman 0
4403396 2165701 2165701 defendant Bower Giles yeoman 611292 611292 Bower, Giles, of North Tawton, Devon, yeoman 3

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);