names

14 rows where place_id = 669451

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment

id ▼ case_id role surname forename occupation place_id raw_segment seq
3993269 2022335 2022335 defendant Sheyle Thomas yeoman 669451 669451 Sheyle, Thomas, of Dymock, Glos, yeoman 0
3996345 2023445 2023445 defendant Barston Florence gent 669451 669451 Barston, Florence, of Dymock, Glos, gent 0
3996347 2023446 2023446 defendant Wilse John yeoman 669451 669451 Wilse, John, of Dymock, Glos, yeoman 0
3996351 2023448 2023448 defendant Brodford or Bradforde Richard yeoman 669451 669451 Brodford or Bradforde, Richard, of Dymock, Glos, yeoman 0
4021518 2032424 2032424 defendant Waynman Thomas gent 669451 669451 Waynman, Thomas, of Dymock, Glos, gent 0
4033815 2036743 2036743 defendant Barston Florence gent 669451 669451 Barston, Florence, of Dymock, Glos, gent 0
4033817 2036744 2036744 defendant Barston Florence gent 669451 669451 Barston, Florence, of Dymock, Glos, gent 0
4050348 2042556 2042556 defendant Wylse Thomas yeoman 669451 669451 Wylse, Thomas, of Dymock, Glos, yeoman 0
4050351 2042557 2042557 defendant Wylse Thomas yeoman 669451 669451 Wylse, Thomas, of Dymock, Glos, yeoman 0
4166060 2083634 2083634 defendant Bastian Florence or Floris gent 669451 669451 Bastian, Florence or Floris, of Dymock, Glos, gent 0
4171553 2085516 2085516 defendant Watt Thomas yeoman 669451 669451 Watt, Thomas, of Dymock, Glos, yeoman 0
4171555 2085517 2085517 defendant Weale Thomas yeoman 669451 669451 Weale, Thomas, of Dymock, Glos, yeoman 0
4254414 2114468 2114468 defendant Sheyle Thomas yeoman 669451 669451 Sheyle, Thomas, of Dymock, Glos, yeoman 0
4312935 2134648 2134648 defendant Davys John yeoman 669451 669451 Davys, John, of Dymock, Glos, 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);