names

17 rows where place_id = 758874

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4457571 2187379 2187379 defendant Emmeson John   758874 758874 Emmeson, John, of Burgh in the Merssh 0
4806582 2298271 2298271 defendant Smyth John husbandman 758874 758874 Smyth, John, of Burgh in the Merssh, husbandman 2
5037090 2367717 2367717 defendant Bedemaker William husbandman 758874 758874 Bedemaker, William, of Burgh in the Merssh, husbandman 1
5049136 2371376 2371376 defendant Coweton Wiliam husbandman 758874 758874 Coweton, Wiliam, of Burgh in the Merssh, husbandman 0
5049260 2371410 2371410 defendant Carter John husbandman 758874 758874 Carter, John, of Burgh in the Merssh, husbandman 0
5088806 2383104 2383104 defendant Neudyke Richard husbandman 758874 758874 Neudyke, Richard, of Burgh in the Merssh, husbandman 0
5088807 2383104 2383104 defendant Clare John husbandman 758874 758874 Clare, John, of Burgh in the Merssh, husbandman 1
5129412 2395089 2395089 defendant Clap John husbandman 758874 758874 Clap, John, of Burgh in the Merssh, husbandman 6
5232494 2425083 2425083 plaintiff Bryg Thomas (legal representative) 758874 758874 Bryg, Thomas, of Burgh in the Merssh, executor of 0
5232496 2425083 2425083 defendant Walton William laborer 758874 758874 Walton, William, of Burgh in the Merssh, laborer 0
5232497 2425083 2425083 defendant Hall Robert yeoman 758874 758874 Hall, Robert, of Burgh in the Merssh, yeoman 1
5235280 2425896 2425896 defendant Carter John, junior husbandman 758874 758874 Carter, John, junior, of Burgh in the Merssh, husbandman 0
5238717 2426920 2426920 defendant Arnowe William husbandman 758874 758874 Arnowe, William, of Burgh in the Merssh, husbandman 5
5244317 2428522 2428522 defendant Saunder William butcher 758874 758874 Saunder, William, of Burgh in the Merssh, butcher 1
5247455 2429412 2429412 defendant Jolyff Thomas   758874 758874 Jolyff, Thomas, of Burgh in the Merssh, "lyster" 1
5248179 2429601 2429601 defendant Berythe Thomas husbandman 758874 758874 Berythe, Thomas, of Burgh in the Merssh, husbandman 2
5419408 2480720 2480720 defendant Jolyff Thomas dyer 758874 758874 Jolyff, Thomas, of Burgh in the Merssh, dyer 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);