names

18 rows where place_id = 621746

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3743314 1939781 1939781 defendant Broke Thomas weaver 621746 621746 Broke, Thomas, of Sampford Courtney, weaver 0
3839836 1970390 1970390 defendant Drewe John husbandman 621746 621746 Drewe, John, of Sampford Courtney, husbandman 0
3865049 1978511 1978511 defendant Whytbred John yeoman 621746 621746 Whytbred, John, of Sampford Courtney, yeoman 0
3936672 2002592 2002592 defendant Lowryng Richard husbandman 621746 621746 Lowryng, Richard, of Sampford Courtney, husbandman 0
3958904 2010197 2010197 defendant Tayler Robert husbandman 621746 621746 Tayler, Robert, of Sampford Courtney, husbandman 0
3958905 2010197 2010197 defendant Tayler Edmund husbandman 621746 621746 Tayler, Edmund, of Sampford Courtney, husbandman 1
3963157 2011714 2011714 defendant Bannycke Thomas husbandman 621746 621746 Bannycke, Thomas, of Sampford Courtney, husbandman 0
4029521 2035194 2035194 defendant Stabacke Richard smith 621746 621746 Stabacke, Richard, of Sampford Courtney, smith 0
4037340 2038018 2038018 defendant Prudham Mathew husbandman 621746 621746 Prudham, Mathew, of Sampford Courtney, husbandman 0
4038166 2038291 2038291 defendant Legg William husbandman 621746 621746 Legg, William, of Sampford Courtney, husbandman 0
4041688 2039510 2039510 defendant Slowman Thomas yeoman 621746 621746 Slowman, Thomas, of Sampford Courtney, yeoman 12
4116892 2066339 2066339 defendant Bannocke Thomas husbandman 621746 621746 Bannocke, Thomas, of Sampford Courtney, husbandman 0
4116893 2066339 2066339 defendant Bannocke Christopher husbandman 621746 621746 Bannocke, Christopher, of Sampford Courtney, husbandman 1
4213386 2100199 2100199 defendant Upcott Simon husbandman 621746 621746 Upcott, Simon, of Sampford Courtney, husbandman 0
4222054 2103204 2103204 defendant Segar Hugh husbandman 621746 621746 Segar, Hugh, of Sampford Courtney, husbandman 0
4240693 2109869 2109869 defendant Rapson John yeoman 621746 621746 Rapson, John, of Sampford Courtney, yeoman 0
4301991 2130821 2130821 defendant Upcott Richard husbandman 621746 621746 Upcott, Richard, of Sampford Courtney, husbandman 0
4306953 2132572 2132572 defendant Tickell Richard husbandman 621746 621746 Tickell, Richard, of Sampford Courtney, husbandman 3

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