names

36 rows where place_id = 596858

✎ 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
3626408 1903116 1903116 defendant Sperk John husbandman 596858 596858 Sperk, John, of Exmyster, husbandman 2
3654102 1911546 1911546 defendant Eston Robert husbandman 596858 596858 Eston, Robert, of Exmyster, husbandman 0
3668528 1916115 1916115 defendant Ewyn John clerk 596858 596858 Ewyn, John, of Exmyster, clerk 0
3668530 1916115 1916115 defendant Ewyn Thomas laborer 596858 596858 Ewyn, Thomas, of Exmyster, laborer 2
3677119 1918885 1918885 defendant Smart John husbandman 596858 596858 Smart, John, of Exmyster, husbandman 0
3688366 1922516 1922516 defendant Dyer John husbandman 596858 596858 Dyer, John, of Exmyster, husbandman 5
3701357 1926668 1926668 defendant Combe John husbandman 596858 596858 Combe, John, of Exmyster, husbandman 0
3747139 1941022 1941022 defendant Stephyn Richard husbandman 596858 596858 Stephyn, Richard, of Exmyster, husbandman 0
3747140 1941022 1941022 defendant Passe John husbandman 596858 596858 Passe, John, of Exmyster, husbandman 1
3810777 1961273 1961273 defendant Howe Richard husbandman 596858 596858 Howe, Richard, of Exmyster, husbandman 0
3818141 1963587 1963587 defendant Stephyns Richard husbandman 596858 596858 Stephyns, Richard, of Exmyster, husbandman 0
3834615 1968761 1968761 defendant Hamlyn Robert yeoman 596858 596858 Hamlyn, Robert, of Exmyster, yeoman 0
3935977 2002350 2002350 defendant Geyle Robert husbandman 596858 596858 Geyle, Robert, of Exmyster, husbandman 0
3973092 2015159 2015159 defendant Woodward Mathew husbandman 596858 596858 Woodward, Mathew, of Exmyster, husbandman 1
3997205 2023770 2023770 defendant Bonde John husbandman 596858 596858 Bonde, John, of Exmyster, husbandman 1
4090927 2057046 2057046 defendant Jaxe Simon husbandman 596858 596858 Jaxe, Simon, of Exmyster, husbandman 0
4090928 2057046 2057046 defendant Jaxe William laborer 596858 596858 Jaxe, William, of Exmyster, laborer 1
4936378 2337769 2337769 defendant Verder Geoffrey husbandman 596858 596858 Verder, Geoffrey, of Exmyster, husbandman 4
4936379 2337769 2337769 defendant Piers John laborer 596858 596858 Piers, John, of Exmyster, laborer 5
4978863 2350634 2350634 defendant Budde John husbandman 596858 596858 Budde, John, of Exmyster, husbandman 4
5016039 2361575 2361575 defendant Oke John   596858 596858 Oke, John, of Exmyster, bailiff 3
5021514 2363194 2363194 defendant Oke John   596858 596858 Oke, John, of Exmyster, bailiff 3
5032161 2366281 2366281 defendant Michell Richard husbandman 596858 596858 Michell, Richard, of Exmyster, husbandman 0
5033155 2366580 2366580 defendant Colyford John chaplain 596858 596858 Colyford, John, of Exmyster, chaplain 3
5064921 2376040 2376040 defendant Michell Richard husbandman 596858 596858 Michell, Richard, of Exmyster, husbandman 0
5064922 2376040 2376040 defendant Michell John laborer 596858 596858 Michell, John, of Exmyster, laborer 1
5069553 2377391 2377391 defendant Michell Richard husbandman 596858 596858 Michell, Richard, of Exmyster, husbandman 0
5089351 2383251 2383251 defendant Michell John laborer 596858 596858 Michell, John, of Exmyster, laborer 0
5089352 2383251 2383251 defendant Michell Richard husbandman 596858 596858 together with Michell, Richard, of Exmyster, husbandman 1
5089354 2383252 2383252 defendant Michell Richard husbandman 596858 596858 Michell, Richard, of Exmyster, husbandman 0
5089355 2383252 2383252 defendant Michell John laborer 596858 596858 together with Michell, John, of Exmyster, laborer 1
5094068 2384663 2384663 defendant Michell Richard husbandman 596858 596858 Michell, Richard, of Exmyster, husbandman 0
5260111 2433284 2433284 defendant Verdour Geoffrey husbandman 596858 596858 Verdour, Geoffrey, of Exmyster, husbandman 4
5563435 2523906 2523906 defendant Jakys John laborer 596858 596858 Jakys, John, of Exmyster, laborer 1
5563436 2523906 2523906 defendant Erle Thomas husbandman 596858 596858 Erle, Thomas, of Exmyster, husbandman 2
5563437 2523906 2523906 defendant Combe John laborer 596858 596858 Combe, John, of Exmyster, laborer 3

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