names

19 rows where place_id = 610090

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3681872 1920434 1920434 defendant Payne Margaret widow 610090 610090 Payne, Margaret, of Shaftysbury, Dorset, widow 6
3721957 1933132 1933132 defendant Gawen Anne widow 610090 610090 Gawen, Anne, of Shaftysbury, Dorset, widow 0
3769996 1948274 1948274 defendant Gawen Anne widow 610090 610090 Gawen, Anne, of Shaftysbury, Dorset, widow 0
3828216 1966695 1966695 plaintiff Carpynter Richard innholder 610090 610090 Carpynter, Richard, of Shaftysbury, Dorset, innholder 0
3841646 1970970 1970970 defendant Nycholasson Nicholas hardwareman 610090 610090 Nycholasson, Nicholas, of Shaftysbury, Dorset, hardwareman 0
3841648 1970971 1970971 defendant Nycholaston Nicholas hardwareman 610090 610090 Nycholaston, Nicholas, of Shaftysbury, Dorset, hardwareman 0
3859352 1976620 1976620 defendant Lewys Hugh innholder 610090 610090 Lewys, Hugh, of Shaftysbury, Dorset, innholder 0
3859363 1976623 1976623 defendant Lewes Hugh innholder 610090 610090 Lewes, Hugh, of Shaftysbury, Dorset, innholder 1
3887905 1986204 1986204 defendant Arundell Thomas   610090 610090 Arundell, Thomas, of Shaftysbury, Dorset, knight 0
3906932 1992606 1992606 defendant Dowle Henry innholder 610090 610090 Dowle, Henry, of Shaftysbury, Dorset, innholder 4
3921722 1997608 1997608 defendant Bygkys William   610090 610090 Bygkys, William, of Shaftysbury, Dorset 0
4890822 2323877 2323877 defendant Bertholomewe John merchant 610090 610090 Bertholomewe, John, of Shaftysbury, Dorset, merchant 0
4961202 2345316 2345316 defendant Cary Stephen baker 610090 610090 Cary, Stephen, of Shaftysbury, Dorset, baker 0
5070437 2377650 2377650 defendant Shayle John chapman 610090 610090 Shayle, John, of Shaftysbury, Dorset, chapman 0
5216782 2420648 2420648 defendant Pole Thomas gent 610090 610090 Pole, Thomas, of Shaftysbury, Dorset, gent 0
5216785 2420649 2420649 defendant Barton Oliver   610090 610090 Barton, Oliver, of Shaftysbury, Dorset, gent, household of Earl of Wiltshire 1
5216787 2420650 2420650 defendant Pole Thomas gent 610090 610090 Pole, Thomas, of Shaftysbury, Dorset, gent 0
5308262 2447503 2447503 defendant Shoyle John mercer 610090 610090 Shoyle, John, of Shaftysbury, Dorset, mercer 0
5336805 2456072 2456072 defendant Gerard Robert yeoman 610090 610090 Gerard, Robert, of Shaftysbury, Dorset, yeoman 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);