names

26 rows where place_id = 701855

✎ 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
4140236 2074752 2074752 defendant Lluwellen Genry yeoman 701855 701855 Lluwellen, Genry, of Langeby, yeoman 1
4152143 2078859 2078859 defendant Wylym Philip John yeoman 701855 701855 Wylym, Philip John, of Langeby, yeoman 4
4213864 2100369 2100369 defendant Morgan Philip Lewis yeoman 701855 701855 Morgan, Philip Lewis, of Langeby, yeoman 0
4218416 2101942 2101942 defendant ap John John yeoman 701855 701855 ap John, John, of Langeby, yeoman 1
4220985 2102835 2102835 defendant Yghan William John yeoman 701855 701855 Yghan, William John, of Langeby, yeoman 2
4220993 2102837 2102837 defendant Willym David John   701855 701855 Willym, David John, of Langeby 1
4223166 2103591 2103591 defendant Willams John clerk 701855 701855 Willams, John, of Langeby, clerk 0
4274842 2121147 2121147 defendant David Edward Thomas yeoman 701855 701855 David, Edward Thomas, of Langeby, yeoman 0
4274846 2121149 2121149 defendant Williams John clerk 701855 701855 Williams, John, of Langeby, clerk 0
4275838 2121498 2121498 defendant Williams John clerk 701855 701855 Williams, John, of Langeby, clerk 0
4278867 2122544 2122544 defendant Lennard Philip yeoman 701855 701855 Lennard, Philip, of Langeby, yeoman 0
4278868 2122544 2122544 defendant Lennard John yeoman 701855 701855 Lennard, John, of Langeby, yeoman 1
4278968 2122576 2122576 defendant Mirick John yeoman 701855 701855 Mirick, John, of Langeby, yeoman 2
4279973 2122907 2122907 defendant Edwardes Griffin yeoman 701855 701855 Edwardes, Griffin, of Langeby, yeoman 0
4281425 2123409 2123409 defendant ap John John yeoman 701855 701855 ap John, John, of Langeby, yeoman 0
4366544 2153083 2153083 defendant Lenard Philip yeoman 701855 701855 Lenard, Philip, of Langeby, yeoman 0
4367488 2153426 2153426 defendant Williams Richard gent 701855 701855 Williams, Richard, of Langeby, gent 0
4367489 2153426 2153426 defendant Thomas Morgan yeoman 701855 701855 Thomas, Morgan, of Langeby, yeoman 1
4367490 2153426 2153426 defendant Jevan John ap John yeoman 701855 701855 Jevan, John ap John, of Langeby, yeoman 2
4370113 2154371 2154371 defendant Llewellyn Philip yeoman 701855 701855 Llewellyn, Philip, of Langeby, yeoman 0
4370114 2154371 2154371 defendant Thomas William David yeoman 701855 701855 Thomas, William David, of Langeby, yeoman 1
4370115 2154371 2154371 defendant Gillam Philip Thomas yeoman 701855 701855 Gillam, Philip Thomas, of Langeby, yeoman 2
4370247 2154419 2154419 defendant Philip Jenkin yeoman 701855 701855 Philip, Jenkin, of Langeby, yeoman 0
4374805 2156044 2156044 defendant Williams John clerk 701855 701855 Williams, John, of Langeby, clerk 0
4380093 2157983 2157983 defendant Morris Jenkin yeoman 701855 701855 Morris, Jenkin, of Langeby, yeoman 0
4711776 2269008 2269008 defendant Stokke Richard weaver 701855 701855 Stokke, Richard, of Langeby, weaver 1

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