names

18 rows where case_id = 2016493

✎ 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
3976914 2016493 2016493 plaintiff Lakyn Miles gent   Lakyn, Miles, gent 0
3976915 2016493 2016493 defendant Wyseman Robert gent 601003 601003 Wyseman, Robert, of Grenewiche, Kent, gent 0
3976916 2016493 2016493 defendant Paynter John clothier 586470 586470 Paynter, John, of Colchester, clothier 1
3976917 2016493 2016493 defendant Broke Henry clerk 637278 637278 Broke, Henry, of Parva Bromley, clerk 2
3976918 2016493 2016493 defendant Andrewes John mariner 611390 611390 Andrewes, John, of Harwiche, mariner 3
3976919 2016493 2016493 defendant Harte Robert mariner 611390 611390 Harte, Robert, of Harwiche, mariner 4
3976920 2016493 2016493 defendant Symnell William chandler 586470 586470 Symnell, William, of Colchester, chandler 5
3976921 2016493 2016493 defendant Halsnoth William baker 586470 586470 Halsnoth, William, of Colchester, baker 6
3976922 2016493 2016493 defendant Halsoth Robert yeoman 609750 609750 Halsoth, Robert, of Wodham Water, yeoman 7
3976923 2016493 2016493 defendant Horspytt Edward husbandman 665442 665442 Horspytt, Edward, of Salcott Verley, husbandman 8
3976924 2016493 2016493 defendant Milles Jerome bowyer 586470 586470 Milles, Jerome, of Colchester, bowyer 9
3976925 2016493 2016493 defendant Turner Thomas clothier 586470 586470 Turner, Thomas, of Colchester, clothier 10
3976926 2016493 2016493 defendant Wade Thomas clerk 665443 665443 Wade, Thomas, of Fratynge, clerk 11
3976927 2016493 2016493 defendant Cole William clothier 695684 695684 Cole, William, of Est Bergholte, Suff, clothier 12
3976928 2016493 2016493 defendant Fryer Nicholas clothier 658136 658136 Fryer, Nicholas, of Est Bergholte, clothier 13
3976929 2016493 2016493 defendant Williams alias Foteman Francis yeoman 586134 586134 Williams alias Foteman, Francis, of Ipswich, yeoman 14
3976930 2016493 2016493 defendant Abbs John merchant 591643 591643 Abbs, John, of Naylond, Suff, merchant 15
3976931 2016493 2016493 defendant Barwicke John clothier 591076 591076 Barwicke, John, of Est Bergholt, clothier 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);