names

20 rows where case_id = 2091439

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4188450 2091439 2091439 plaintiff Wallenger James principal of Thavis Inn   Wallenger, James, principal of Thavis Inn 0
4188451 2091439 2091439 defendant Okley Edward gent 585869 585869 Okley, Edward, of London, gent 0
4188452 2091439 2091439 defendant Hermer Richard gent 585869 585869 Hermer, Richard, of London, gent 1
4188453 2091439 2091439 defendant Olyver Robert gent 711352 711352 Olyver, Robert, of Lawrance Lydyard, Soms, gent 2
4188454 2091439 2091439 defendant Ledington John gent 585869 585869 Ledington, John, of London, gent 3
4188455 2091439 2091439 defendant Snowem Edward Beds, gent 908295 908295 Snowem Edward, of Bushemeade, Beds, gent 4
4188456 2091439 2091439 defendant Yonge Edward gent 711353 711353 Yonge, Edward, of Bushton, Cheshire, gent 5
4188457 2091439 2091439 defendant Brooke Peyning gent 688929 688929 Brooke, Peyning, of Norton, Cheshire, gent 6
4188458 2091439 2091439 defendant Andrewes Thomas gent 585869 585869 Andrewes, Thomas, of London, gent 7
4188459 2091439 2091439 defendant Leake Edmund gent 711354 711354 Leake, Edmund, of Edmington, Middx, gent 8
4188460 2091439 2091439 defendant Mallett Michael gent 585869 585869 Mallett, Michael, of London, gent 9
4188461 2091439 2091439 defendant Parker Michael gent 585869 585869 Parker, Michael, of London, gent 10
4188462 2091439 2091439 defendant Dale Peter gent 585869 585869 Dale, Peter, of London, gent 11
4188463 2091439 2091439 defendant Parker Thomas gent 585869 585869 Parker, Thomas, of London, gent 12
4188464 2091439 2091439 defendant Udall Henry gent 585869 585869 Udall, Henry, of London, gent 13
4188465 2091439 2091439 defendant Serles Francis gent 585869 585869 Serles, Francis, of London, gent 14
4188466 2091439 2091439 defendant Hynton Richard Hants, gent 706463 706463 Hynton Richard, of Barton Stacye, Hants, gent 15
4188467 2091439 2091439 defendant Kent Giles gent 585869 585869 Kent, Giles, of London, gent 16
4188468 2091439 2091439 defendant Denyce Thomas gent 585869 585869 Denyce, Thomas, of London, gent 17
4188469 2091439 2091439 defendant Skullerd John gent 587702 587702 Skullerd, John, of Andever, Hants, gent 18

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