names

25 rows where place_id = 770751

✎ 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
4552590 2216762 2216762 defendant Potton William   770751 770751 Potton, William, of Yakesle, vicar 0
4570967 2222486 2222486 defendant Keteryng William   770751 770751 Keteryng, William, of Yakesle 0
4575455 2223834 2223834 defendant Chesterton William   770751 770751 Chesterton, William, of Yakesle, parson 0
4583910 2226384 2226384 defendant Pyfynche Thomas   770751 770751 Pyfynche, Thomas, of Yakesle 0
4593615 2229277 2229277 plaintiff Peek John   770751 770751 Peek, John, of Yakesle 0
4593620 2229278 2229278 plaintiff Peek John   770751 770751 Peek, John, of Yakesle 0
4603640 2232324 2232324 plaintiff Wrenne John   770751 770751 Wrenne, John, of Yakesle 0
4608891 2233882 2233882 defendant Breustere Thomas   770751 770751 Breustere, Thomas, of Yakesle 5
4608892 2233882 2233882 defendant Stoke Henry   770751 770751 Stoke, Henry, of Yakesle 6
4613462 2235225 2235225 defendant Stokes Henry   770751 770751 Stokes, Henry, of Yakesle 0
4650762 2246245 2246245 defendant Barker John   770751 770751 Barker, John, of Yakesle 0
4662357 2249702 2249702 defendant Barker John husbandman 770751 770751 Barker, John, of Yakesle, husbandman 0
4695305 2264013 2264013 defendant Ovyre John yeoman 770751 770751 Ovyre, John, of Yakesle, yeoman 0
4698774 2265098 2265098 defendant Bryan John fishmonger 770751 770751 Bryan, John, of Yakesle, fishmonger 2
4698777 2265099 2265099 defendant Gery John husbandman 770751 770751 Gery, John, of Yakesle, husbandman 1
4698778 2265099 2265099 defendant Bryan John fishmonger 770751 770751 Bryan, John, of Yakesle, fishmonger 2
4792246 2293662 2293662 defendant Clement William husbandman 770751 770751 Clement, William, of Yakesle, husbandman 0
4916878 2331781 2331781 defendant Dyker John husbandman 770751 770751 Dyker, John, of Yakesle, husbandman 1
4979970 2350964 2350964 defendant Bailly William yeoman 770751 770751 Bailly, William, of Yakesle, yeoman 1
5073719 2378626 2378626 defendant Bailly William husbandman 770751 770751 Bailly, William, of Yakesle, husbandman 0
5073720 2378626 2378626 defendant Dekyn Henry husbandman 770751 770751 Dekyn, Henry, of Yakesle, husbandman 1
5310498 2448176 2448176 defendant Beteryche Robert husbandman 770751 770751 Beteryche, Robert, of Yakesle, husbandman 0
5310499 2448176 2448176 defendant Petite John husbandman 770751 770751 Petite, John, of Yakesle, husbandman 1
5310500 2448176 2448176 defendant Sexteyn John yeoman 770751 770751 Sexteyn, John, of Yakesle, yeoman 2
5430884 2484179 2484179 defendant Columbyn William husbandman 770751 770751 Columbyn, William, of Yakesle, husbandman 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);