names

24 rows where place_id = 821240

✎ 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
4914256 2330972 2330972 defendant Stabyll John yeoman 821240 821240 Stabyll, John, of Tempil Soureby, yeoman 0
4939636 2338781 2338781 defendant Soureby Richard   821240 821240 Soureby, Richard, of Tempil Soureby 0
4939637 2338781 2338781 defendant Stable John   821240 821240 Stable, John, of Tempil Soureby 1
4965384 2346569 2346569 defendant Burcy John smith 821240 821240 Burcy, John, of Tempil Soureby, smith 0
4965385 2346569 2346569 defendant Cartemale Thomas husbandman 821240 821240 Cartemale, Thomas, of Tempil Soureby, husbandman 1
4965386 2346569 2346569 defendant Stabyll John yeoman 821240 821240 Stabyll, John, of Tempil Soureby, yeoman 2
4965387 2346569 2346569 defendant Meburn Thomas yeoman 821240 821240 Meburn, Thomas, of Tempil Soureby, yeoman 3
4965388 2346569 2346569 defendant Wilson John yeoman 821240 821240 Wilson, John, of Tempil Soureby, yeoman 4
4965389 2346569 2346569 defendant Jonson William husbandman 821240 821240 Jonson, William, of Tempil Soureby, husbandman 5
4965390 2346569 2346569 defendant Soureby Richard tailor 821240 821240 Soureby, Richard, of Tempil Soureby, tailor 6
4965391 2346569 2346569 defendant Soureby William yeoman 821240 821240 Soureby, William, of Tempil Soureby, yeoman 7
4965392 2346569 2346569 defendant Soureby Thomas   821240 821240 Soureby, Thomas, of Tempil Soureby, wright 8
4965393 2346569 2346569 defendant Soureby John yeoman 821240 821240 Soureby, John, of Tempil Soureby, yeoman 9
4965394 2346569 2346569 defendant Hall Richard   821240 821240 Hall, Richard, of Tempil Soureby, franklin 10
4965395 2346569 2346569 defendant Gayll William husbandman 821240 821240 Gayll, William, of Tempil Soureby, husbandman 11
4965402 2346571 2346571 defendant Burcy John smith 821240 821240 Burcy, John, of Tempil Soureby, smith 0
4965403 2346571 2346571 defendant Gayll William yeoman 821240 821240 Gayll, William, of Tempil Soureby, yeoman 1
4965404 2346571 2346571 defendant Blamyre Richard yeoman 821240 821240 Blamyre, Richard, of Tempil Soureby, yeoman 2
4965405 2346571 2346571 defendant Hertley William smith 821240 821240 Hertley, William, of Tempil Soureby, smith 3
4965406 2346571 2346571 defendant Cartmale Thomas husbandman 821240 821240 Cartmale, Thomas, of Tempil Soureby, husbandman 4
4965407 2346571 2346571 defendant Stabill John yeoman 821240 821240 Stabill, John, of Tempil Soureby, yeoman 5
4965408 2346571 2346571 defendant Wilson John yeoman 821240 821240 Wilson, John, of Tempil Soureby, yeoman 6
4965409 2346571 2346571 defendant Jonson William yeoman 821240 821240 Jonson, William, of Tempil Soureby, yeoman 7
4965410 2346571 2346571 defendant Soureby Richard yeoman 821240 821240 Soureby, Richard, of Tempil Soureby, yeoman 8

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