names

25 rows where place_id = 602640

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651060 1910697 1910697 defendant A Dene William tiler 602640 602640 A Dene, William, of Grenewich, Kent, tiler 3
3658452 1912895 1912895 defendant Coken alias Cokken Henry esq 602640 602640 Coken alias Cokken, Henry, of Grenewich, Kent, esq 1
3660568 1913566 1913566 defendant Parker Henry gent 602640 602640 Parker, Henry, of Grenewich, Kent, gent 1
3664409 1914818 1914818 defendant Tolley Christopher yeoman 602640 602640 Tolley, Christopher, of Grenewich, Kent, & of the King's hospice, yeoman 2
3666515 1915467 1915467 defendant Bene William grocer 602640 602640 Bene, William, of Grenewich, Kent, grocer 0
3668792 1916176 1916176 defendant Boleyn Edward   602640 602640 Boleyn, Edward, of Grenewich, Kent, knight 0
3688606 1922595 1922595 defendant Symonde William gent 602640 602640 Symonde, William, of Grenewich, Kent, gent 0
3692917 1923985 1923985 defendant Lambe John carpenter 602640 602640 Lambe, John, of Grenewich, Kent, carpenter 0
3751122 1942276 1942276 defendant Becka Elias   602640 602640 Becka, Elias, of Grenewich, Kent 0
3829488 1967110 1967110 defendant Dawbeney Anthony gent 602640 602640 Dawbeney, Anthony, of Grenewich, Kent, gent 0
3994711 2022860 2022860 defendant Husse Lawrence gent 602640 602640 Husse, Lawrence, of Grenewich, Kent, gent 0
4004998 2026569 2026569 defendant Hynde alias Bowrdeman Henry yeoman 602640 602640 (Hynde alias Bowrdeman, Henry, of Grenewich, Kent, yeoman 1
4168704 2084541 2084541 defendant Benbowe John gent 602640 602640 Benbowe, John, of Grenewich, Kent, gent 3
4195584 2094004 2094004 defendant Elam Thomas gent 602640 602640 Elam, Thomas, of Grenewich, Kent, gent 0
4242655 2110535 2110535 defendant Bramyard Thomas yeoman 602640 602640 Bramyard, Thomas, of Grenewich, Kent, yeoman 1
4252510 2113831 2113831 defendant Bramyard Thomas yeoman 602640 602640 Bramyard, Thomas, of Grenewich, Kent, yeoman 1
4329162 2140065 2140065 defendant Churchman Nicholas potter 602640 602640 Churchman, Nicholas, of Grenewich, Kent, potter 3
4356575 2149531 2149531 defendant Stafforde Edward   602640 602640 Stafforde, Edward, of Grenewich, Kent, or of Chebsey, Staffs, knight 0
4387806 2160558 2160558 defendant Chappell John husbandman 602640 602640 Chappell, John, of Grenewich, Kent, husbandman 2
4411142 2168314 2168314 defendant Stafford Edward   602640 602640 Stafford, Edward, of Grenewich, Kent, or of Chebsey, Staffs, knight 0
5235202 2425874 2425874 defendant Overston Thomas clerk 602640 602640 Overston, Thomas, of Grenewich, Kent, clerk 0
5240297 2427373 2427373 defendant Overston Thomas gent 602640 602640 Overston, Thomas, of Grenewich, Kent, gent 0
5485794 2500647 2500647 defendant Wylson Robert yeoman of the crown 602640 602640 Wylson, Robert, of Grenewich, Kent, gent, yeoman of the crown, Edw IV 1
5542176 2517683 2517683 defendant Passage John yeoman 602640 602640 Passage, John, of Grenewich, Kent, yeoman 3
5597341 2534074 2534074 defendant Lyonell John pinner 602640 602640 Lyonell, John, of Grenewich, Kent, pinner 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);