names

14 rows where place_id = 621036

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3739080 1938433 1938433 plaintiff Paky William butcher 621036 621036 Paky, William, of Swynshed, Lincs, butcher 0
3827741 1966543 1966543 defendant Holond Thomas gent 621036 621036 Holond, Thomas, of Swynshed, Lincs, gent 1
3900114 1990261 1990261 plaintiff Browne William mercer 621036 621036 Browne, William, of Swynshed, Lincs, mercer 0
3952324 2007883 2007883 defendant Hollande Thomas esq 621036 621036 Hollande, Thomas, of Swynshed, Lincs, esq 0
3967851 2013386 2013386 defendant Prydgyan Henry yeoman 621036 621036 Prydgyan, Henry, of Swynshed, Lincs, yeoman 1
3976684 2016417 2016417 defendant Hartleye Thomas yeoman 621036 621036 Hartleye, Thomas, of Swynshed, Lincs, yeoman 14
4236402 2108303 2108303 defendant Clay Thomas yeoman 621036 621036 Clay, Thomas, of Swynshed, Lincs, yeoman 0
4256729 2115224 2115224 defendant Claye Thomas yeoman 621036 621036 Claye, Thomas, of Swynshed, Lincs, yeoman 0
4986568 2352910 2352910 defendant Algarkirk John   621036 621036 Algarkirk, John, of Swynshed, Lincs, abbot 0
5104793 2387839 2387839 defendant Wolmer Richard gent 621036 621036 Wolmer, Richard, of Swynshed, Lincs, gent 0
5104820 2387846 2387846 defendant Wolmer Richard gent 621036 621036 Wolmer, Richard, of Swynshed, Lincs, gent 1
5136646 2397240 2397240 defendant Wolmer Richard gent 621036 621036 Wolmer, Richard, of Swynshed, Lincs, gent 1
5490475 2502045 2502045 defendant Garrard Stephen husbandman 621036 621036 Garrard, Stephen, of Swynshed, Lincs, husbandman 0
5533461 2515017 2515017 defendant Terre Robert yeoman 621036 621036 Terre, Robert, of Swynshed, Lincs, 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);