names

13 rows where case_id = 1958678

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3802495 1958678 1958678 plaintiff Payne John     Payne, John 0
3802496 1958678 1958678 defendant Soham John yeoman 589533 589533 Soham, John, of Beteley, yeoman 0
3802497 1958678 1958678 defendant Holles John   586156 586156 Holles, John, of Magna Cressyngham, shepherd 1
3802498 1958678 1958678 defendant Stonham John husbandman 621918 621918 Stonham, John, of Barton Bendiche, husbandman 2
3802499 1958678 1958678 defendant Goldsmyth Thomas husbandman 587329 587329 Goldsmyth, Thomas, of Wellys juxta Mare, husbandman 3
3802500 1958678 1958678 defendant Burne John husbandman 607216 607216 Burne, John, of Olton, husbandman 4
3802501 1958678 1958678 defendant Lawrans Roger butcher 591188 591188 Lawrans, Roger, of Magna Massyngham, butcher 5
3802502 1958678 1958678 defendant Bayly William bucher 592429 592429 Bayly, William, of West Bradenham, bucher 6
3802503 1958678 1958678 defendant Larwod Thomas husbandman 631744 631744 Larwod, Thomas, of Shipdame, husbandman 7
3802504 1958678 1958678 defendant Baxster John of Bishops Lenn merchant   Baxster, John of Bishops Lenn, merchant 8
3802505 1958678 1958678 defendant Smalepece John clothmaker 586470 586470 Smalepece, John, of Colchester, clothmaker 9
3802506 1958678 1958678 defendant Bovysdyke William barber 615916 615916 Bovysdyke, William, of Brandon Ferey, Suff, barber 10
3802507 1958678 1958678 defendant Mabbys Geoffrey yeoman 589532 589532 Mabbys, Geoffrey, of Fakenham, yeoman 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);