names

15 rows where place_id = 796907

✎ 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
4753281 2281408 2281408 defendant Bogeys Thomas husbandman 796907 796907 Bogeys, Thomas, of Illey Combusta, husbandman 1
4773012 2287532 2287532 defendant Harecorth John husbandman 796907 796907 Harecorth, John, of Illey Combusta, husbandman 1
4773018 2287533 2287533 defendant Harecorth John husbandman 796907 796907 Harecorth, John, of Illey Combusta, husbandman 1
4802008 2296814 2296814 defendant Barkere John barker 796907 796907 Barkere, John, of Illey Combusta, barker 0
4997363 2356061 2356061 defendant Metevayn Richard husbandman 796907 796907 Metevayn, Richard, of Illey Combusta, husbandman 1
5141944 2398764 2398764 defendant Venyour John clerk 796907 796907 Venyour, John, of Illey Combusta, clerk 3
5141953 2398765 2398765 defendant Venyour John clerk 796907 796907 Venyour, John, of Illey Combusta, clerk 4
5163036 2404915 2404915 defendant Venyour John clerk 796907 796907 Venyour, John, of Illey Combusta, clerk 2
5249487 2429961 2429961 defendant Cabawe John yeoman 796907 796907 Cabawe, John, of Illey Combusta, yeoman 0
5268795 2435988 2435988 defendant Judy Thomas tanner 796907 796907 Judy, Thomas, of Illey Combusta, tanner 0
5269736 2436258 2436258 defendant Herward John yeoman 796907 796907 Herward, John, of Illey Combusta, yeoman 1
5299716 2444885 2444885 defendant Cabawe John husbandman 796907 796907 Cabawe, John, of Illey Combusta, husbandman 1
5300695 2445172 2445172 defendant Cokeyn John husbandman 796907 796907 Cokeyn, John, of Illey Combusta, husbandman 0
5300696 2445172 2445172 defendant Dyche Walter yeoman 796907 796907 Dyche, Walter, of Illey Combusta, yeoman 1
5309082 2447752 2447752 defendant Comayen William mercer 796907 796907 Comayen, William, of Illey Combusta, mercer 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);