names

13 rows where case_id = 1871542

✎ 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
3612496 1871542 1871542 plaintiff Hautmount Robert     Hautmount, Robert 0
3612497 1871542 1871542 defendant Baker John brewer 586117 586117 Baker, John, of Coventry, brewer 0
3612498 1871542 1871542 defendant Tayllour David yeoman 608879 608879 Tayllour, David, of St Mary Matselon, Algate, yeoman 1
3612499 1871542 1871542 defendant Sextem John   648255 648255 Sextem, John, of London, London 2
3612500 1871542 1871542 defendant Carewey John tailor 586034 586034 Carewey, John, of St Albans, Herts, tailor 3
3612501 1871542 1871542 defendant Morefyn Robert yeoman 585869 585869 Morefyn, Robert, of London, yeoman 4
3612502 1871542 1871542 defendant Morton William skinner 585869 585869 Morton, William, of London, skinner 5
3612503 1871542 1871542 defendant Walyngford Simon yeoman 586033 586033 Walyngford, Simon, of Westminster, yeoman 6
3612504 1871542 1871542 defendant Albon William cordwainer 592125 592125 Albon, William, of Colbroke, Bucks, cordwainer 7
3612505 1871542 1871542 defendant Seymour Walter cordwainer 587237 587237 Seymour, Walter, of Colbroke, cordwainer 8
3612506 1871542 1871542 defendant Johnson Margaret spinster 585869 585869 Johnson, Margaret, of London, spinster 9
3612507 1871542 1871542 defendant Moreton Margaret spinster 585869 585869 Moreton, Margaret, of London, spinster 10
3612508 1871542 1871542 defendant Bone Thomas husbandman 588052 588052 Bone, Thomas, of Kyngeston on Thames, Surrey, husbandman 11

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