names

14 rows where place_id = 610330

✎ 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
3683052 1920813 1920813 defendant Fennall John, junior gent 610330 610330 Fennall, John, junior, of Asheley, gent 0
3710698 1929666 1929666 defendant Heyns William yeoman 610330 610330 Heyns, William, of Asheley, yeoman 1
3736198 1937565 1937565 defendant Brenner Joan widow 610330 610330 Brenner, Joan, of Asheley, widow 0
3736199 1937565 1937565 defendant Brenner Thomas husbandman 610330 610330 Brenner, Thomas, of Asheley, husbandman 1
3737068 1937835 1937835 defendant Lancaster George gent 610330 610330 Lancaster, George, of Asheley, gent 0
4005828 2026854 2026854 plaintiff Lam or Lamme John husbandman 610330 610330 Lam or Lamme, John, of Asheley, husbandman 0
4005861 2026866 2026866 plaintiff Lamme John   610330 610330 Lamme, John, of Asheley 0
4005873 2026870 2026870 defendant Edmond John yeoman 610330 610330 Edmond, John, of Asheley, yeoman 0
4005874 2026870 2026870 defendant Clarke James alias John husbandman 610330 610330 Clarke, James alias John, of Asheley, husbandman 1
4019201 2031604 2031604 defendant Edmond John husbandman 610330 610330 Edmond, John, of Asheley, husbandman 0
4222430 2103337 2103337 defendant Laurence Richard yeoman 610330 610330 Laurence, Richard, of Asheley, yeoman 0
4234375 2107561 2107561 defendant Goodman Thomas yeoman 610330 610330 Goodman, Thomas, of Asheley, yeoman 0
4253129 2114044 2114044 defendant Goodman Thomas yeoman 610330 610330 Goodman, Thomas, of Asheley, yeoman 0
4288424 2125907 2125907 defendant Bate John yeoman 610330 610330 Bate, John, of Asheley, yeoman 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);