names

18 rows where place_id = 646119

✎ 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
3889129 1986599 1986599 defendant Pyke John clerk 646119 646119 Pyke, John, of Tymworth, clerk 4
3990824 2021477 2021477 defendant Playforde John husbandman 646119 646119 Playforde, John, of Tymworth, husbandman 1
4028052 2034683 2034683 defendant Chapman John husbandman 646119 646119 Chapman, John, of Tymworth, husbandman 3
4825468 2304010 2304010 defendant Reder John husbandman 646119 646119 Reder, John, of Tymworth, husbandman 0
4982868 2351788 2351788 plaintiff Tymworth John gent 646119 646119 Tymworth, John, of Tymworth, gent 0
4982871 2351789 2351789 plaintiff Tymworth John gent 646119 646119 Tymworth, John, of Tymworth, gent 0
5262604 2434048 2434048 defendant Hegge Thomas husbandman 646119 646119 Hegge, Thomas, of Tymworth, husbandman 0
5262605 2434048 2434048 defendant Myles Thomas husbandman 646119 646119 Myles, Thomas, of Tymworth, husbandman 1
5262606 2434048 2434048 defendant Bole William husbandman 646119 646119 Bole, William, of Tymworth, husbandman 2
5266585 2435300 2435300 defendant Coket John woolman 646119 646119 Coket, John, of Tymworth, woolman 0
5266586 2435300 2435300 defendant Dannoll Simon laborer 646119 646119 Dannoll, Simon, of Tymworth, laborer 1
5359114 2462889 2462889 defendant Curteys John   646119 646119 Curteys, John, of Tymworth, shepherd 4
5380766 2469553 2469553 plaintiff Coket John   646119 646119 Coket, John, of Tymworth 0
5382739 2470127 2470127 plaintiff Spicer Richard singleman 646119 646119 Spicer, Richard, of Tymworth, singleman 0
5406334 2476882 2476882 plaintiff Spicer Richard   646119 646119 Spicer, Richard, of Tymworth, single man 0
5406336 2476883 2476883 plaintiff Spicer Richard   646119 646119 Spicer, Richard, of Tymworth, single man 0
5419409 2480721 2480721 plaintiff Spicer Richard singleman 646119 646119 Spicer, Richard, of Tymworth, singleman 0
5555778 2521679 2521679 defendant Onyon John husbandman 646119 646119 Onyon, John, of Tymworth, husbandman 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);