names

7 rows where place_id = 664630

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3973614 2015342 2015342 defendant Dyn John yeoman 664630 664630 Dyn, John, of Carleton Fowerhoo, yeoman 2
4004647 2026438 2026438 defendant Dyn or Dyne John yeoman 664630 664630 Dyn or Dyne, John, of Carleton Fowerhoo, yeoman 0
4015064 2030076 2030076 defendant Dynne Thomas husbandman 664630 664630 Dynne, Thomas, of Carleton Fowerhoo, husbandman 15
4289344 2126250 2126250 defendant Block Thomas husbandman 664630 664630 Block, Thomas, of Carleton Fowerhoo, husbandman 0
4289345 2126250 2126250 defendant Block John laborer 664630 664630 Block, John, of Carleton Fowerhoo, laborer 1
4352998 2148278 2148278 defendant Ellys Thomas husbandman 664630 664630 Ellys, Thomas, of Carleton Fowerhoo, husbandman 2
4404339 2166021 2166021 defendant Ellye Thomas laborer 664630 664630 Ellye, Thomas, of Carleton Fowerhoo, laborer 2

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