names

16 rows where case_id = 2030073

✎ 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
4015007 2030073 2030073 plaintiff Skynner Richard gent, attorney of the bench   Skynner, Richard, gent, attorney of the bench 0
4015008 2030073 2030073 defendant Kyrke John tanner 616418 616418 Kyrke, John, of Hempnall, tanner 0
4015009 2030073 2030073 defendant Chapman Thomas clerk 585936 585936 Chapman, Thomas, of Norwich, clerk 1
4015010 2030073 2030073 defendant Nulman Robert yeoman 617790 617790 Nulman, Robert, of Brakenasshe, yeoman 2
4015011 2030073 2030073 defendant Hardey Robert yeoman 597883 597883 Hardey, Robert, of Hycham, yeoman 3
4015012 2030073 2030073 defendant Austen William yeoman 594689 594689 Austen, William, of Rakkey, yeoman 4
4015013 2030073 2030073 defendant Seman Robert husbandman 588833 588833 Seman, Robert, of Stratton, husbandman 5
4015014 2030073 2030073 defendant Bollande Robert husbandman 601716 601716 Bollande, Robert, of Antyngham, husbandman 6
4015015 2030073 2030073 defendant Creke William   587786 587786 Creke, William, of Rynglond, shepherd 7
4015016 2030073 2030073 defendant Caston Fabian draper 585936 585936 Caston, Fabian, of Norwich, draper 8
4015017 2030073 2030073 defendant Alexsander Thomas husbandman 662122 662122 Alexsander, Thomas, of Tasborowe, husbandman 9
4015018 2030073 2030073 defendant Howse Richard yeoman 665066 665066 Howse, Richard, of Aylysham Borrowe, yeoman 10
4015019 2030073 2030073 defendant Wynsdon Thomas gent 586365 586365 Wynsdon, Thomas, of Wymondham, gent 11
4015020 2030073 2030073 defendant Carman John husbandman 674652 674652 Carman, John, of Hockeryng, husbandman 12
4015021 2030073 2030073 defendant Howell Thomas cooper 585936 585936 Howell, Thomas, of Norwich, cooper 13
4015022 2030073 2030073 defendant Selbey John husbandman 627077 627077 Selbey, John, of Byllyngforth, husbandman 14

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