names

22 rows where place_id = 598424

✎ 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
3632394 1904950 1904950 defendant Wryght alias Crabbe William husbandman 598424 598424 Wryght alias Crabbe, William, of Hakford juxta Refham, husbandman 3
3913549 1994871 1994871 plaintiff Blofeld John   598424 598424 Blofeld, John, of Hakford juxta Refham 0
3919200 1996748 1996748 defendant Blofeld John yeoman 598424 598424 Blofeld, John, of Hakford juxta Refham, yeoman 0
5015826 2361517 2361517 defendant Aylward John husbandman 598424 598424 Aylward, John, of Hakford juxta Refham, husbandman 0
5037834 2367943 2367943 defendant Flaxman Thomas husbandman 598424 598424 Flaxman, Thomas, of Hakford juxta Refham, husbandman 1
5056249 2373443 2373443 defendant Filbek Thomas yeoman 598424 598424 Filbek, Thomas, of Hakford juxta Refham, yeoman 5
5279394 2439056 2439056 defendant Vynne Thomas carpenter 598424 598424 Vynne, Thomas, of Hakford juxta Refham, carpenter 11
5289214 2441848 2441848 defendant Cady Richard husbandman 598424 598424 Cady, Richard, of Hakford juxta Refham, husbandman 0
5342959 2457988 2457988 defendant Spycer Robert husbandman 598424 598424 Spycer, Robert, of Hakford juxta Refham, husbandman 2
5349877 2460096 2460096 defendant Cley- Thomas smith 598424 598424 Cley-, Thomas, of Hakford juxta Refham, smith 2
5349883 2460097 2460097 defendant Cleye Thomas smith 598424 598424 Cleye, Thomas, of Hakford juxta Refham, smith 2
5351111 2460453 2460453 defendant Smyth Robert smith 598424 598424 Smyth, Robert, of Hakford juxta Refham, smith 0
5361341 2463567 2463567 defendant Smyth Robert smith 598424 598424 Smyth, Robert, of Hakford juxta Refham, smith 4
5478392 2498566 2498566 defendant Stowe Thomas thatcher 598424 598424 Stowe, Thomas, of Hakford juxta Refham, thatcher 2
5485010 2500436 2500436 defendant Vynnys or Wynnys Richard husbandman or carpenter 598424 598424 Vynnys or Wynnys, Richard, of Hakford juxta Refham, husbandman or carpenter 2
5485024 2500439 2500439 defendant Wynnes or Vynnes Richard carpenter 598424 598424 Wynnes or Vynnes, Richard, of Hakford juxta Refham, carpenter 2
5485026 2500440 2500440 defendant Burman Nicholas husbandman 598424 598424 Burman, Nicholas, of Hakford juxta Refham, husbandman 0
5485027 2500440 2500440 defendant Clete Thomas husbandman 598424 598424 Clete, Thomas, of Hakford juxta Refham, husbandman 1
5495711 2503611 2503611 defendant Stowe Thomas thatcher 598424 598424 Stowe, Thomas, of Hakford juxta Refham, thatcher 4
5498575 2504517 2504517 defendant Burman Nicholas husbandman 598424 598424 Burman, Nicholas, of Hakford juxta Refham, husbandman 2
5498582 2504519 2504519 defendant Crabbe William yeoman 598424 598424 Crabbe, William, of Hakford juxta Refham, yeoman 0
5500876 2505205 2505205 defendant Wynne Richard husbandman 598424 598424 Wynne, Richard, of Hakford juxta Refham, husbandman 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);