names

15 rows where place_id = 585967

✎ 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
3587599 1863769 1863769 defendant Stansfeld Richard yeoman 585967 585967 Stansfeld, Richard, of Gelyngham, Norf, yeoman 0
3636540 1906223 1906223 defendant Stanfeld Richard yeoman 585967 585967 Stanfeld, Richard, of Gelyngham, Norf, yeoman 0
3745528 1940506 1940506 defendant Kyppyng Nicholas husbandman 585967 585967 Kyppyng, Nicholas, of Gelyngham, Norf, husbandman 0
3747437 1941113 1941113 defendant Kyppyng Nicholas husbandman 585967 585967 Kyppyng, Nicholas, of Gelyngham, Norf, husbandman 0
3754807 1943461 1943461 defendant Kyppyng Nicholas husbandman 585967 585967 Kyppyng, Nicholas, of Gelyngham, Norf, husbandman 0
3765724 1946945 1946945 defendant Kyppyng Nicholas husbandman 585967 585967 Kyppyng, Nicholas, of Gelyngham, Norf, husbandman 0
3783780 1952692 1952692 defendant Kyppyng Nicholas husbandman 585967 585967 Kyppyng, Nicholas, of Gelyngham, Norf, husbandman 0
3844543 1971833 1971833 defendant Mekylburgh John husbandman 585967 585967 Mekylburgh, John, of Gelyngham, Norf, husbandman 1
3849520 1973448 1973448 defendant Bryggys Elias husbandman 585967 585967 Bryggys, Elias, of Gelyngham, Norf, husbandman 1
3858620 1976368 1976368 defendant Newman Walter husbandman 585967 585967 Newman, Walter, of Gelyngham, Norf, husbandman 2
3886253 1985655 1985655 defendant Ayre William husbandman 585967 585967 Ayre, William, of Gelyngham, Norf, husbandman 1
4676152 2258155 2258155 defendant Bryd Thomas husbandman 585967 585967 Bryd, Thomas, of Gelyngham, Norf, husbandman 0
5002691 2357699 2357699 defendant Goodyene Thomas yeoman 585967 585967 Goodyene, Thomas, of Gelyngham, Norf, yeoman 0
5097809 2385785 2385785 defendant Boty Walter chaplain 585967 585967 Boty, Walter, of Gelyngham, Norf, chaplain 0
5479830 2498977 2498977 defendant Stannysfeld Richard yeoman 585967 585967 Stannysfeld, Richard, of Gelyngham, Norf, yeoman 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);