names

27 rows where place_id = 753385

✎ 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
4413130 2168975 2168975 defendant Aleyn Thomas   753385 753385 Aleyn, Thomas, of Fawy 0
4419131 2170850 2170850 defendant Aleyn John   753385 753385 Aleyn, John, of Fawy 0
4430691 2174358 2174358 plaintiff Aleyn John   753385 753385 Aleyn, John, of Fawy 0
4430692 2174358 2174358 defendant Markes John   753385 753385 Markes, John, of Fawy 0
4464558 2189584 2189584 plaintiff Waunder Alice   753385 753385 Waunder, Alice, of Fawy, formerly wife of John 0
4476554 2193331 2193331 defendant Tayllour John   753385 753385 Tayllour, John, of Fawy 0
4550543 2216110 2216110 plaintiff Dawe John   753385 753385 Dawe, John, of Fawy 0
4550545 2216111 2216111 plaintiff Dawe John   753385 753385 Dawe, John, of Fawy 0
4550547 2216112 2216112 plaintiff Dawe John   753385 753385 Dawe, John, of Fawy 0
4598515 2230771 2230771 defendant Conteryf John   753385 753385 Conteryf, John, of Fawy 0
4598517 2230772 2230772 defendant Conteryf John   753385 753385 Conteryf, John, of Fawy 0
4611699 2234720 2234720 defendant Stonard Henry (legal representative) 753385 753385 Stonard, Henry, of Fawy, executrix of 0
4824948 2303837 2303837 defendant Taillour Thomas   753385 753385 Taillour, Thomas, of Fawy 0
4848945 2311137 2311137 plaintiff Smyth Thomas   753385 753385 Smyth, Thomas, of Fawy 0
4953847 2343113 2343113 plaintiff Smyth Thomas   753385 753385 Smyth, Thomas, of Fawy 0
5043566 2369696 2369696 plaintiff Fynell John chaplain 753385 753385 Fynell, John, of Fawy, chaplain 1
5131582 2395718 2395718 defendant Hunkyn John husbandman 753385 753385 Hunkyn, John, of Fawy, junior, husbandman 2
5238930 2426977 2426977 defendant Treffry Thomas esq 753385 753385 Treffry, Thomas, of Fawy,esq 0
5238931 2426977 2426977 defendant Salter John merchant 753385 753385 Salter, John, of Fawy, merchant 1
5238932 2426977 2426977 defendant Horde William esq 753385 753385 Horde, William, of Fawy, esq 2
5249303 2429916 2429916 defendant Roche John tailor 753385 753385 Roche, John, of Fawy, tailor 1
5249304 2429916 2429916 defendant Dawe William mariner 753385 753385 Dawe, William, of Fawy, mariner 2
5249305 2429916 2429916 defendant Leyland John chapman 753385 753385 Leyland, John, of Fawy, chapman 3
5249306 2429916 2429916 defendant Bruer William mariner 753385 753385 Bruer, William, of Fawy, mariner 4
5265977 2435115 2435115 plaintiff Trefry Thomas   753385 753385 Trefry, Thomas, of Fawy 0
5378335 2468804 2468804 defendant Laury Thomas merchant 753385 753385 Laury, Thomas, of Fawy, merchant 0
5573770 2526895 2526895 plaintiff Poyle Robert (legal representative) 753385 753385 Poyle, Robert, of Fawy, executor 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);