names

21 rows where place_id = 612218

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692170 1923719 1923719 defendant Colpres Nicholas laborer 612218 612218 Colpres, Nicholas, of Stoke Cannon, laborer 0
3702154 1926931 1926931 defendant Carowe Robert laborer 612218 612218 Carowe, Robert, of Stoke Cannon, laborer 0
3919748 1996944 1996944 defendant Hoppyng John yeoman 612218 612218 Hoppyng, John, of Stoke Cannon, yeoman 0
3971171 2014472 2014472 defendant Courtney Philip Dvon, gent 612218 612218 Courtney Philip, of Stoke Cannon, Dvon, gent 0
3986557 2019933 2019933 defendant Palmer Thomas husbandman 612218 612218 Palmer, Thomas, of Stoke Cannon, husbandman 0
4071322 2050046 2050046 defendant Wylles William yeoman 612218 612218 Wylles, William, of Stoke Cannon, yeoman 0
4086216 2055345 2055345 defendant Warren Peter yeoman 612218 612218 Warren, Peter, of Stoke Cannon, yeoman 1
4108161 2063188 2063188 defendant Warren Mathew yeoman 612218 612218 Warren, Mathew, of Stoke Cannon, yeoman 0
4108162 2063188 2063188 defendant Palmer John yeoman 612218 612218 Palmer, John, of Stoke Cannon, yeoman 1
4108163 2063188 2063188 defendant Mortymer William husbandman 612218 612218 Mortymer, William, of Stoke Cannon, husbandman 2
4108197 2063197 2063197 defendant Warren Mathew husbandman 612218 612218 Warren, Mathew, of Stoke Cannon, husbandman 0
4108198 2063197 2063197 defendant Palmer John yeoman 612218 612218 Palmer, John, of Stoke Cannon, yeoman 1
4108199 2063197 2063197 defendant Mare Walter husbandman 612218 612218 Mare, Walter, of Stoke Cannon, husbandman 2
4108569 2063319 2063319 defendant Barret Richard merchant 612218 612218 Barret, Richard, of Stoke Cannon, or of Lyme Regis, merchant 0
4108586 2063326 2063326 defendant Edworthie Nicholas husbandman 612218 612218 Edworthie, Nicholas, of Stoke Cannon, husbandman 0
4122759 2068431 2068431 defendant Gregorie alias Wylcox John husbandman 612218 612218 Gregorie alias Wylcox, John, of Stoke Cannon, husbandman 1
4196958 2094487 2094487 defendant Warren William gent 612218 612218 Warren, William, of Stoke Cannon, gent 1
4264072 2117635 2117635 defendant Battyn Philippa widow 612218 612218 Battyn, Philippa, of Stoke Cannon, widow 1
4321829 2137720 2137720 defendant Courtney Philip gent 612218 612218 Courtney, Philip, of Stoke Cannon, gent 0
4367499 2153429 2153429 defendant Warren Mathew yeoman 612218 612218 Warren, Mathew, of Stoke Cannon, yeoman 2
4370898 2154648 2154648 defendant Eye Thomas husbandman 612218 612218 Eye, Thomas, of Stoke Cannon, 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);