names

16 rows where place_id = 598765

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3633964 1905432 1905432 defendant Champernon Philip esq 598765 598765 Champernon, Philip, of Modbury, Devon, esq 0
3726011 1934409 1934409 defendant Champernon Philip esq 598765 598765 Champernon, Philip, of Modbury, Devon, esq 1
3902482 1991060 1991060 defendant Strachelygh alias Screslegh Richard gent 598765 598765 Strachelygh alias Screslegh, Richard, of Modbury, Devon, gent 1
3921496 1997532 1997532 defendant Strecheley Richard gent 598765 598765 Strecheley, Richard, of Modbury, Devon, gent 0
3921498 1997533 1997533 defendant Stretcheley Richard gent 598765 598765 Stretcheley, Richard, of Modbury, Devon, gent 0
3939217 2003420 2003420 defendant Fortescu William yeoman 598765 598765 Fortescu, William, of Modbury, Devon, yeoman 0
3939264 2003437 2003437 defendant Fortescue William gent 598765 598765 Fortescue, William, of Modbury, Devon, gent 0
3942533 2004513 2004513 defendant Chanborne or Champernowne Arthur   598765 598765 Chanborne or Champernowne, Arthur, of Modbury, Devon, knight 1
4002313 2025607 2025607 defendant Shynner Anthony husbandman 598765 598765 Shynner, Anthony, of Modbury, Devon, husbandman 1
4011616 2028899 2028899 defendant Hill Oliver esq 598765 598765 Hill, Oliver, of Modbury, Devon, esq 3
4407973 2167232 2167232 defendant Hast Arthur gent 598765 598765 Hast, Arthur, of Modbury, Devon, gent 1
4728090 2274034 2274034 defendant Kynylyon John weaver 598765 598765 Kynylyon, John, of Modbury, Devon, weaver 0
4786812 2291932 2291932 defendant Scos William husbandman 598765 598765 Scos, William, of Modbury, Devon, husbandman 0
4810141 2299324 2299324 defendant Tylbotte John yeoman 598765 598765 Tylbotte, John, of Modbury, Devon, yeoman 0
5550093 2520064 2520064 defendant Coyte John husbandman 598765 598765 Coyte, John, of Modbury, Devon, husbandman 1
5550113 2520067 2520067 defendant Coyte John husbandman 598765 598765 Coyte, John, of Modbury, Devon, husbandman 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);