names

12 rows where case_id = 2015729

✎ 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
3974724 2015729 2015729 plaintiff Higg Thomas     Higg, Thomas 0
3974725 2015729 2015729 defendant ap Knello Rice ap Owen yeoman 658991 658991 ap Knello, Rice ap Owen, of Berewe, Montgomery, yeoman 0
3974726 2015729 2015729 defendant Barbor William whitawer 660335 660335 Barbor, William, of Brydgenorth, whitawer 1
3974727 2015729 2015729 defendant Clune Thomas gent 664910 664910 Clune, Thomas, of Clune, gent 2
3974728 2015729 2015729 defendant Benwyn Howell yeoman 664910 664910 Benwyn, Howell, of Clune, yeoman 3
3974729 2015729 2015729 defendant Yonge Thomas gent 590688 590688 Yonge, Thomas, of More, gent 4
3974730 2015729 2015729 defendant Lucas Hugh gent 664910 664910 Lucas, Hugh, of Clune, gent 5
3974731 2015729 2015729 defendant ap Madock Robert ap Richard yeoman 633389 633389 ap Madock, Robert ap Richard, of Frankton, yeoman 6
3974732 2015729 2015729 defendant Lyethe Thomas yeoman 619872 619872 Lyethe, Thomas, of Rednall, yeoman 7
3974733 2015729 2015729 defendant Bratt Ellen widow 664080 664080 Bratt, Ellen, of Buttington, Montgomery, widow 8
3974734 2015729 2015729 defendant Gabett John clothworker 585869 585869 Gabett, John, of London, clothworker 9
3974735 2015729 2015729 defendant Whittingeslowe Richard weaver 664911 664911 Whittingeslowe, Richard, of Cleburye Mortimer, weaver 10

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