names

38 rows where place_id = 621929

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3744331 1940127 1940127 defendant Muse William carpenter 621929 621929 Muse, William, of Thurleby, carpenter 0
3985234 2019476 2019476 defendant Peper Richard gent 621929 621929 Peper, Richard, of Thurleby, gent 0
4240241 2109708 2109708 defendant Pople Christopher husbandman 621929 621929 Pople, Christopher, of Thurleby, husbandman 1
4352329 2148051 2148051 defendant Barton Thomas yeoman 621929 621929 Barton, Thomas, of Thurleby, yeoman 0
4368169 2153667 2153667 defendant Litler Robert gent 621929 621929 Litler, Robert, of Thurleby, gent 0
4368170 2153667 2153667 defendant Litler Raphael gent 621929 621929 Litler, Raphael, of Thurleby, gent 1
4381343 2158439 2158439 defendant Lawson Thomas butcher 621929 621929 Lawson, Thomas, of Thurleby, butcher 0
4439960 2181780 2181780 defendant Maweior Nicholas   621929 621929 Maweior, Nicholas, of Thurleby 0
4472803 2192165 2192165 defendant Brutton William de   621929 621929 with Brutton, William de, of Thurleby 1
4472804 2192165 2192165 defendant Cole Richard   621929 621929 Cole, Richard, of Thurleby 2
4489161 2197327 2197327 plaintiff Teffyn John   621929 621929 Teffyn, John, of Thurleby 0
4496271 2199506 2199506 plaintiff Cole Richard   621929 621929 Cole, Richard, of Thurleby, son of Geoffrey 0
4496273 2199507 2199507 plaintiff Cole Richard   621929 621929 Cole, Richard, of Thurleby, son of Geoffrey 0
4510782 2203830 2203830 defendant Cole Richard   621929 621929 Cole, Richard, of Thurleby 0
4540562 2212948 2212948 defendant Cole Richard   621929 621929 Cole, Richard, of Thurleby 0
4544499 2214195 2214195 defendant Gold or Cole Richard   621929 621929 Gold or Cole, Richard, of Thurleby 0
4553747 2217093 2217093 defendant Trenchepayn John   621929 621929 Trenchepayn, John, of Thurleby 4
4573809 2223325 2223325 defendant Cole Richard   621929 621929 Cole, Richard, of Thurleby 0
4589773 2228166 2228166 plaintiff Louseby Walter   621929 621929 Louseby, Walter, of Thurleby, vicar 0
4694900 2263893 2263893 defendant Pye John husbandman 621929 621929 Pye, John, of Thurleby, husbandman 3
4701058 2265737 2265737 plaintiff Byllyng John   621929 621929 Byllyng, John, of Thurleby 1
4756836 2282503 2282503 plaintiff Billyng John   621929 621929 Billyng, John, of Thurleby 0
4780675 2289954 2289954 plaintiff Byllyng John   621929 621929 Byllyng, John, of Thurleby 0
4791030 2293288 2293288 defendant Dyke Roger husbandman 621929 621929 Dyke, Roger, of Thurleby, husbandman 0
4791033 2293288 2293288 defendant Fissher John husbandman 621929 621929 Fissher, John, of Thurleby, husbandman 3
4895563 2325282 2325282 defendant Ward John gent 621929 621929 Ward, John, of Thurleby, gent 0
4943476 2339929 2339929 defendant Elred Robert barker 621929 621929 Elred, Robert, of Thurleby, barker 0
4976406 2349906 2349906 defendant Warde John gent 621929 621929 Warde, John, of Thurleby, gent 0
4995813 2355593 2355593 defendant Rede Henry husbandman 621929 621929 Rede, Henry, of Thurleby, husbandman 1
5063109 2375503 2375503 defendant Neweman Henry (legal representative) 621929 621929 Neweman, Henry, of Thurleby, executors of 0
5063111 2375503 2375503 defendant Fletham Thomas clerk 621929 621929 Fletham, Thomas, of Thurleby, clerk 2
5063112 2375503 2375503 defendant Elred Robert husbandman 621929 621929 Elred, Robert, of Thurleby, husbandman 3
5063114 2375503 2375503 defendant Armestrong William butcher 621929 621929 Armestrong, William, of Thurleby, butcher 5
5222044 2422151 2422151 defendant Neuman Henry   621929 621929 Neuman, Henry, of Thurleby, franklin, administrators of 1
5222046 2422151 2422151 defendant Elred Robert barker 621929 621929 Elred, Robert,of Thurleby, barker 3
5303384 2446007 2446007 defendant Underwode Richard clerk 621929 621929 (Underwode, Richard, of Thurleby, clerk 1
5438367 2486409 2486409 defendant Blodeles William husbandman 621929 621929 (Blodeles, William, of Thurleby, husbandman 3
5635217 2554987 2554987 defendant Warde John   621929 621929 Warde, John, of Thurleby 2

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);