names

22 rows where place_id = 612117

✎ 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
3691659 1923551 1923551 defendant Sounde John husbandman 612117 612117 Sounde, John, of Ewelme, husbandman 0
3999835 2024705 2024705 defendant Marmyon John gent 612117 612117 Marmyon, John, of Ewelme, gent 0
3999842 2024708 2024708 defendant Marmyon John gent 612117 612117 Marmyon, John, of Ewelme, gent 0
4008905 2027948 2027948 defendant Marmyon Edmund gent 612117 612117 Marmyon, Edmund, of Ewelme, gent 1
4219148 2102193 2102193 defendant Forde Thomas gent 612117 612117 Forde, Thomas, of Ewelme, gent 0
4493808 2198757 2198757 plaintiff Beek William   612117 612117 Beek, William, of Ewelme, on his own account 0
4753476 2281465 2281465 defendant Boteler William (legal representative) 612117 612117 Boteler, William, of Ewelme, executors of 0
4926619 2334744 2334744 defendant Pierus John husbandman 612117 612117 Pierus, John, of Ewelme, husbandman 2
5015848 2361526 2361526 defendant Howet Thomas husbandman 612117 612117 (Howet, Thomas, of Ewelme, husbandman 1
5039275 2368390 2368390 defendant Crede John chaplain 612117 612117 Crede, John, of Ewelme, chaplain 1
5039278 2368391 2368391 defendant Crede John chaplain 612117 612117 Crede, John, of Ewelme, chaplain 1
5114374 2390599 2390599 defendant Grevyle Richard weaver 612117 612117 Grevyle, Richard, of Ewelme, weaver 2
5186880 2411905 2411905 defendant Forde Thomas husbandman 612117 612117 Forde, Thomas, of Ewelme, husbandman 0
5354415 2461449 2461449 defendant Lewyne Richard husbandman 612117 612117 Lewyne, Richard, of Ewelme, husbandman 2
5566377 2524757 2524757 plaintiff Lucy Thomas   612117 612117 Lucy, Thomas, of Ewelme 2
5566381 2524758 2524758 plaintiff Lucy Thomas   612117 612117 Lucy, Thomas, of Ewelme 2
5566385 2524759 2524759 plaintiff Lucy Thomas   612117 612117 Lucy, Thomas, of Ewelme 2
5566391 2524760 2524760 plaintiff Lucy Thomas   612117 612117 Lucy, Thomas, of Ewelme 2
5569226 2525555 2525555 defendant Hedyngdon John yeoman 612117 612117 Hedyngdon, John, of Ewelme, yeoman 0
5569230 2525556 2525556 defendant Hedyngton John miller 612117 612117 Hedyngton, John, of Ewelme, miller 0
5569231 2525556 2525556 defendant Rede John miller 612117 612117 Rede, John, of Ewelme, miller 1
5634639 2554831 2554831 defendant Deyere John husbandman 612117 612117 Deyere, John, of Ewelme, husbandman 1

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