names

12 rows where place_id = 758367

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4453282 2186036 2186036 defendant Barton John   758367 758367 Barton, John, of Landmote 0
4743241 2278551 2278551 defendant Brawath Richard yeoman 758367 758367 Brawath, Richard, of Landmote, yeoman 0
4862005 2315131 2315131 defendant Coweden John yeoman 758367 758367 Coweden, John, of Landmote, yeoman 1
4961822 2345496 2345496 defendant Wyghtman William husbandman 758367 758367 Wyghtman, William, of Landmote, husbandman 11
4961823 2345496 2345496 defendant Wyghtman John husbandman 758367 758367 Wyghtman, John, of Landmote, husbandman 12
4988391 2353499 2353499 defendant Grene Thomas gent 758367 758367 Grene, Thomas, of Landmote, gent 0
4988394 2353499 2353499 defendant Wightman John husbandman 758367 758367 Wightman, John, of Landmote, husbandman 3
4988413 2353501 2353501 defendant Wyghtman John husbandman 758367 758367 Wyghtman, John, of Landmote, husbandman 0
4988429 2353501 2353501 defendant Grene Thomas gent 758367 758367 together with Grene, Thomas, of Landmote, gent 16
5015546 2361435 2361435 defendant Grene Thomas gent 758367 758367 Grene, Thomas, of Landmote, gent 0
5015547 2361435 2361435 defendant Wightman John yeoman 758367 758367 Wightman, John, of Landmote, yeoman 1
5037464 2367828 2367828 defendant Wightman John husbandman 758367 758367 Wightman, John, of Landmote, husbandman 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);