names

13 rows where place_id = 611325

✎ 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
3687884 1922374 1922374 defendant Crave John husbandman 611325 611325 Crave, John, of Antony, husbandman 0
3687890 1922374 1922374 defendant War John smith 611325 611325 War, John, of Antony, smith 6
3692448 1923817 1923817 defendant Carewe John esq 611325 611325 Carewe, John, of Antony, esq 0
3703067 1927234 1927234 defendant Tome Isabel widow 611325 611325 Tome, Isabel, of Antony, widow 0
3703068 1927234 1927234 defendant Mellowe Joan spinster 611325 611325 Mellowe, Joan, of Antony, spinster 1
3732550 1936410 1936410 defendant Come Isabel widow 611325 611325 Come, Isabel, of Antony, widow 0
3732551 1936410 1936410 defendant Mellowe Joan spinster 611325 611325 Mellowe, Joan, of Antony, spinster 1
3915230 1995455 1995455 defendant Fletcher John smith 611325 611325 Fletcher, John, of Antony, smith 0
3915232 1995456 1995456 defendant Fletcher John smith 611325 611325 Fletcher, John, of Antony, smith 0
4017969 2031143 2031143 defendant Byrte John husbandman 611325 611325 Byrte, John, of Antony, husbandman 0
4017970 2031143 2031143 defendant Byrte Thomasine widow 611325 611325 Thomasine his wife, alias Thomasine Hamett, of Antony, widow 1
4189654 2091877 2091877 defendant Hooper Geoffrey husbandman 611325 611325 Hooper, Geoffrey, of Antony, husbandman 1
5520894 2511356 2511356 plaintiff Carewe John esq 611325 611325 Carewe, John, of Antony, esq 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);