names

17 rows where place_id = 781812

✎ 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
4674529 2257645 2257645 defendant Hygham Robert husbandman 781812 781812 Hygham, Robert, of Ippelpenne, husbandman 3
4674532 2257645 2257645 defendant Laucestall John   781812 781812 Laucestall, John, of Ippelpenne, mason 6
4674536 2257645 2257645 defendant Cole Roger   781812 781812 Cole, Roger, of Ippelpenne, milward 10
4674541 2257645 2257645 defendant More Thomas   781812 781812 More, Thomas, of Ippelpenne, holy water clerk 15
4699670 2265347 2265347 defendant Lancastell John   781812 781812 Lancastell, John, of Ippelpenne, mason 6
4699681 2265347 2265347 defendant More Thomas   781812 781812 More, Thomas, of Ippelpenne, holy water clerk 17
4699682 2265347 2265347 defendant More John   781812 781812 More, John, of Ippelpenne, holy water clerk 18
4699683 2265347 2265347 defendant Lucas John laborer 781812 781812 Lucas, John, of Ippelpenne, laborer 19
4699685 2265347 2265347 defendant Dollyng John   781812 781812 Dollyng, John, of Ippelpenne, mason 21
5078051 2379918 2379918 defendant Baurtour Peter husbandman 781812 781812 Baurtour, Peter, of Ippelpenne, husbandman 1
5334035 2455250 2455250 defendant Croppe John husbandman 781812 781812 Croppe, John, of Ippelpenne, husbandman 1
5334036 2455250 2455250 defendant Rowe Robert laborer 781812 781812 Rowe, Robert, of Ippelpenne, laborer 2
5334037 2455250 2455250 defendant Tayllour John laborer 781812 781812 Tayllour, John, of Ippelpenne, laborer 3
5334038 2455250 2455250 defendant atte Wyll Robert   781812 781812 atte Wyll, Robert, of Ippelpenne, "helyer" 4
5334039 2455250 2455250 defendant Cole John hooper 781812 781812 Cole, John, of Ippelpenne, hooper 5
5334040 2455250 2455250 defendant Cole Robert husbandman 781812 781812 Cole, Robert, of Ippelpenne, husbandman 6
5334041 2455250 2455250 defendant Bartour Peter husbandman 781812 781812 Bartour, Peter, of Ippelpenne, husbandman 7

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