names

21 rows where place_id = 770804

✎ 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
4446628 2183862 2183862 defendant Sisteford William   770804 770804 Sisteford, William, of Norton Bavent, parson 0
4446630 2183863 2183863 defendant Cisteford William   770804 770804 Cisteford, William, of Norton Bavent, formerly parson of the church 0
4571514 2222669 2222669 defendant Hascombe John   770804 770804 Hascombe, John, of Norton Bavent 0
4587066 2227363 2227363 defendant Dygge Simon   770804 770804 Dygge, Simon, of Norton Bavent 1
4597839 2230578 2230578 defendant Fysshere Geoffrey (legal representative) 770804 770804 Fysshere, Geoffrey, of Norton Bavent, administrator of 1
4720642 2271789 2271789 defendant Hugonys Thomas fuller 770804 770804 Hugonys, Thomas, of Norton Bavent, fuller 0
4720643 2271789 2271789 defendant Touker John fuller 770804 770804 Touker, John, of Norton Bavent, fuller 1
4746992 2279623 2279623 defendant Taillour John husbandman 770804 770804 Taillour, John, of Norton Bavent, husbandman 0
4831457 2305870 2305870 defendant Merywedyr Thomas fuller 770804 770804 Merywedyr, Thomas, of Norton Bavent, fuller 1
4881958 2321255 2321255 defendant Taillour John weaver 770804 770804 Taillour, John, of Norton Bavent, weaver 0
4898343 2326138 2326138 defendant Blysset Richard husbandman 770804 770804 Blysset, Richard, of Norton Bavent, husbandman 0
4963850 2346100 2346100 defendant Styll John husbandman 770804 770804 Styll, John, of Norton Bavent, husbandman 0
5014485 2361099 2361099 plaintiff Benet alias Taillour Thomas   770804 770804 Benet alias Taillour, Thomas, of Norton Bavent 0
5152291 2401802 2401802 defendant Elyot Robert   770804 770804 Elyot, Robert, of Norton Bavent, vicar 2
5170130 2406994 2406994 defendant Elyot Robert   770804 770804 Elyot, Robert, of Norton Bavent, vicar 2
5187548 2412078 2412078 defendant Elyot Robert   770804 770804 Elyot, Robert, of Norton Bavent, vicar 2
5187553 2412079 2412079 defendant Elyot Robert   770804 770804 Elyot, Robert, of Norton Bavent, vicar 2
5330346 2454152 2454152 plaintiff Benet Thomas draper 770804 770804 Benet, Thomas, of Norton Bavent, draper 0
5347406 2459353 2459353 plaintiff Benette alias Tayllour John, senior clothier 770804 770804 Benette alias Tayllour, John, senior, of Norton Bavent, clothier 0
5443674 2488029 2488029 defendant Grenefeld John   770804 770804 Grenefeld, John, of Norton Bavent 1
5613959 2548136 2548136 defendant Shefford William   770804 770804 Shefford, William, of Norton Bavent, parson 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);