names

27 rows where place_id = 594901

✎ 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
3618058 1873271 1873271 defendant Broun Robert   594901 594901 Broun, Robert, of Thwayte 1
3633338 1905242 1905242 defendant Tyler John husbandman 594901 594901 Tyler, John, of Thwayte, husbandman 2
3635100 1905777 1905777 defendant Bacon William yeoman 594901 594901 Bacon, William, of Thwayte, yeoman 0
3635102 1905777 1905777 defendant Heydon Henry esq 594901 594901 Heydon, Henry, of Thwayte, esq 2
3649922 1910341 1910341 plaintiff Reve Edward gent 594901 594901 Reve, Edward, of Thwayte, gent 0
3649924 1910342 1910342 plaintiff Reve Edward gent 594901 594901 Reve, Edward, of Thwayte, gent 0
3714518 1930837 1930837 defendant Stragy Richard laborer 594901 594901 Stragy, Richard, of Thwayte, laborer 2
3864930 1978474 1978474 defendant Heydon Henry (legal representative) 594901 594901 Heydon, Henry, of Thwayte, esq, executrix of 1
3864931 1978474 1978474 defendant Heydon Margaret widow 594901 594901 Heydon, Margaret, of Thwayte, widow 2
3904246 1991665 1991665 defendant Cryche Henry gent 594901 594901 Cryche, Henry, of Thwayte, gent 0
4055713 2044430 2044430 defendant Reve Thomas gent 594901 594901 Reve, Thomas, of Thwayte, gent 0
4088366 2056133 2056133 defendant Margett Robert sawyer 594901 594901 Margett, Robert, of Thwayte, sawyer 0
4187354 2091079 2091079 defendant Goslyn Robert husbandman 594901 594901 Goslyn, Robert, of Thwayte, husbandman 0
4187355 2091079 2091079 defendant Goslyn John husbandman 594901 594901 Goslyn, John, of Thwayte, husbandman 1
4216078 2101118 2101118 defendant Westoe Robert clerk 594901 594901 Westoe, Robert, of Thwayte, clerk 0
4221290 2102945 2102945 defendant Mathew William husbandman 594901 594901 Mathew, William, of Thwayte, husbandman 0
4281834 2123551 2123551 defendant Morgayne John husbandman 594901 594901 Morgayne, John, of Thwayte, or of Hosfoud , husbandman 1
4323711 2138344 2138344 defendant Blomefeild Barnaby husbandman 594901 594901 Blomefeild, Barnaby, of Thwayte, husbandman 0
4351876 2147895 2147895 defendant Bettes Thomas husbandman 594901 594901 Bettes, Thomas, of Thwayte, husbandman 1
4901453 2327060 2327060 defendant Walsshman Lewis husbandman 594901 594901 Walsshman, Lewis, of Thwayte, husbandman 1
5092330 2384135 2384135 defendant Wolfe Richard gent 594901 594901 Wolfe, Richard, of Thwayte, gent 0
5214704 2420029 2420029 defendant Qwyntyn Roger husbandman 594901 594901 Qwyntyn, Roger, of Thwayte, husbandman 1
5418667 2480506 2480506 defendant Turnour William skinner 594901 594901 Turnour, William, of Thwayte, skinner 1
5436688 2485900 2485900 defendant Turnour William skinner 594901 594901 Turnour, William, of Thwayte, skinner 1
5436737 2485915 2485915 defendant Turnour William skinner 594901 594901 Turnour, William, of Thwayte, skinner 1
5436740 2485916 2485916 defendant Turnour William skinner 594901 594901 Turnour, William, of Thwayte, skinner 1
5595660 2533565 2533565 plaintiff Broun Richard (legal representative) 594901 594901 Broun, Richard, of Thwayte, gent, executors of 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);