names

18 rows where place_id = 597724

✎ 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
3629606 1904114 1904114 defendant A Borough Thomas mercer 597724 597724 A Borough, Thomas, of Saltasshe, Cornw, mercer 1
3793996 1955986 1955986 defendant Bydwyll John yeoman 597724 597724 Bydwyll, John, of Saltasshe, Cornw, yeoman 0
3908495 1993139 1993139 defendant Ornage Richard merchant 597724 597724 Ornage, Richard, of Saltasshe, Cornw, merchant 0
3908836 1993249 1993249 defendant Orynge Richard merchant 597724 597724 Orynge, Richard, of Saltasshe, Cornw, merchant 0
3912341 1994459 1994459 defendant Serle William merchant 597724 597724 Serle, William, of Saltasshe, Cornw, merchant 0
3916059 1995758 1995758 defendant Saunder Edward merchant 597724 597724 Saunder, Edward, of Saltasshe, Cornw, merchant 2
3916065 1995759 1995759 defendant Sawnder Edward merchant 597724 597724 Sawnder, Edward, of Saltasshe, Cornw, merchant 2
4653697 2247083 2247083 defendant Watte Hillary shoemaker 597724 597724 Watte, Hillary, of Saltasshe, Cornw, shoemaker 1
4973469 2349009 2349009 plaintiff Loll Nicholas   597724 597724 Loll, Nicholas, of Saltasshe, Cornw 0
5031169 2365995 2365995 defendant Geffrey John mariner 597724 597724 Geffrey, John, of Saltasshe, Cornw, mariner 0
5063499 2375607 2375607 defendant Godyng Roger shipman or husbandman 597724 597724 Godyng, Roger, of Saltasshe, Cornw, shipman or husbandman 0
5408878 2477614 2477614 defendant Bealbery John mercer 597724 597724 Bealbery, John, of Saltasshe, Cornw, mercer 4
5421042 2481224 2481224 defendant Ude (illegible)   597724 597724 Ude, _, of Saltasshe, Cornw, vicar 0
5422219 2481593 2481593 defendant Bealbery John mercer 597724 597724 Bealbery, John, of Saltasshe, Cornw, mercer 4
5422225 2481594 2481594 defendant Bedylbery John mercer 597724 597724 Bedylbery, John, of Saltasshe, Cornw, mercer 4
5440568 2487085 2487085 defendant Ude Richard   597724 597724 Ude, Richard, of Saltasshe, Cornw, vicar 0
5569756 2525723 2525723 defendant Orenge Richard merchant 597724 597724 (Orenge, Richard, of Saltasshe, Cornw, merchant 4
5599828 2534833 2534833 defendant Clemmowe Martin merchant 597724 597724 Clemmowe, Martin, of Saltasshe, Cornw, merchant 1

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