names

18 rows where case_id = 2488828

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5446428 2488828 2488828 plaintiff Grenehyll John     Grenehyll, John 0
5446429 2488828 2488828 defendant Blood_ of London clerk   Blood_, of London, clerk 0
5446430 2488828 2488828 defendant Huntbache Thomas husbandman 888405 888405 Huntbache, Thomas, of Todyngton, Worcs, husbandman 1
5446431 2488828 2488828 defendant Scoyte Thomas husbandman 646705 646705 Scoyte, Thomas, of Dyxton, husbandman 2
5446432 2488828 2488828 defendant Scoyt Robert husbandman 646705 646705 Scoyt, Robert, of Dyxton, husbandman 3
5446433 2488828 2488828 defendant Whytyng John husbandman 646705 646705 Whytyng, John, of Dyxton, husbandman 4
5446434 2488828 2488828 defendant K_ John husbandman 598218 598218 K_, John, of Stanley, husbandman 5
5446435 2488828 2488828 defendant Fyscher John husbandman 586395 586395 Fyscher, John, of Alderton, husbandman 6
5446436 2488828 2488828 defendant Heyn John husbandman 586395 586395 Heyn, John, of Alderton, husbandman 7
5446437 2488828 2488828 defendant Wykys William husbandman 586395 586395 Wykys, William, of Alderton, husbandman 8
5446438 2488828 2488828 defendant Carpenter Robert husbandman 586395 586395 Carpenter, Robert, of Alderton, husbandman 9
5446439 2488828 2488828 defendant Hyggene John husbandman 586395 586395 Hyggene, John, of Alderton, husbandman 10
5446440 2488828 2488828 defendant Taunton John, senior husbandman 586395 586395 Taunton, John, senior, of Alderton, husbandman 11
5446441 2488828 2488828 defendant Tawuden John, junior husbandman 586395 586395 Tawuden, John, junior, of Alderton, husbandman 12
5446442 2488828 2488828 defendant Crese Thomas husbandman 586395 586395 Crese, Thomas, of Alderton, husbandman 13
5446443 2488828 2488828 defendant Reve Thomas husbandman 753475 753475 Reve, Thomas, of _, husbandman 14
5446444 2488828 2488828 defendant Mason Thomas   596691 596691 Mason, Thomas, of Stanley St Leonard 15
5446445 2488828 2488828 defendant Creese John, senior husbandman 586395 586395 Creese, John, senior, of Alderton, husbandman 16

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