names

27 rows where place_id = 674135

✎ 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
4012797 2029299 2029299 defendant Cootes William husbandman 674135 674135 Cootes, William, of Ulcebye, husbandman 1
4077153 2052113 2052113 plaintiff Smythe Thomas husbandman 674135 674135 Smythe, Thomas, of Ulcebye, husbandman 0
4088989 2056360 2056360 defendant Coppledicke Humphrey gent 674135 674135 Coppledicke, Humphrey, of Ulcebye, gent 0
4103733 2061605 2061605 defendant Appleyard Thomas   674135 674135 Appleyard, Thomas, of Ulcebye, Lincs gent 0
4104524 2061900 2061900 defendant Apleyarde Thomas yeoman 674135 674135 Apleyarde, Thomas, of Ulcebye, yeoman 0
4173924 2086337 2086337 defendant Whitehead William gent 674135 674135 Whitehead, William, of Ulcebye, or of North Warnemouth, Durham, gent 0
4177525 2087617 2087617 defendant Hanserte John gent 674135 674135 Hanserte, John, of Ulcebye, gent 0
4228106 2105310 2105310 defendant Apleyard William yeoman 674135 674135 Apleyard, William, of Ulcebye, yeoman 0
4228728 2105533 2105533 defendant Apleyard William gent 674135 674135 Apleyard, William, of Ulcebye, gent 0
4231799 2106619 2106619 defendant Empringham Leonard husbandman 674135 674135 Empringham, Leonard, of Ulcebye, husbandman 0
4231800 2106619 2106619 defendant Drewrye Richard, senior   674135 674135 Drewrye, Richard, senior, of Ulcebye husbandman 1
4231802 2106620 2106620 defendant Mylson Stephen husbandman 674135 674135 Mylson, Stephen, of Ulcebye, husbandman 0
4231803 2106620 2106620 defendant Empringham Leonard husbandman 674135 674135 Empringham, Leonard, of Ulcebye, husbandman 1
4233332 2107171 2107171 defendant Apleyard William yeoman 674135 674135 Apleyard, William, of Ulcebye, yeoman 0
4237119 2108565 2108565 defendant Wyndle Thomas yeoman 674135 674135 Wyndle, Thomas, of Ulcebye, or of Tetnaye, yeoman 0
4237249 2108615 2108615 defendant Apleyard William gent 674135 674135 Apleyard, William, of Ulcebye, gent 0
4276365 2121677 2121677 defendant Windle Thomas yeoman 674135 674135 Windle, Thomas, of Ulcebye, yeoman 2
4292996 2127555 2127555 defendant Wyndle Thomas yeoman 674135 674135 Wyndle, Thomas, of Ulcebye, yeoman 0
4295177 2128359 2128359 defendant Milson William laborer 674135 674135 Milson, William, of Ulcebye, laborer 0
4297040 2129038 2129038 defendant Lyghton Robert husbandman 674135 674135 Lyghton, Robert, of Ulcebye, husbandman 2
4297986 2129383 2129383 defendant Appleyearde William gent 674135 674135 Appleyearde, William, of Ulcebye, gent 0
4357716 2149933 2149933 defendant Reynold Thomas laborer 674135 674135 Reynold, Thomas, of Ulcebye, laborer 0
4365163 2152597 2152597 defendant Winshipp Michael husbandman 674135 674135 Winshipp, Michael, of Ulcebye, husbandman 0
4365164 2152597 2152597 defendant Bird Richard yeoman 674135 674135 Bird, Richard, of Ulcebye, yeoman 1
4365165 2152597 2152597 defendant Wilson Thomas yeoman 674135 674135 Wilson, Thomas, of Ulcebye, yeoman 2
4365333 2152665 2152665 defendant Cloughe Christpher yeoman 674135 674135 Cloughe, Christpher, of Ulcebye, yeoman 3
4371106 2154726 2154726 defendant Cotes Henry husbandman 674135 674135 Cotes, Henry, of Ulcebye, 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);