names

14 rows where case_id = 2012510

✎ 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
3965386 2012510 2012510 plaintiff Bastard Francis gent   Bastard, Francis, gent 0
3965387 2012510 2012510 defendant Hallydaye Richard saddler 662555 662555 Hallydaye, Richard, of Downham Markett, Norf, saddler 0
3965388 2012510 2012510 defendant Motles John yeoman 662556 662556 Motles, John, of West Wynche, Norf, yeoman 1
3965389 2012510 2012510 defendant Wylcock Thomas yeoman 640775 640775 Wylcock, Thomas, of Kings Lenn, yeoman 2
3965390 2012510 2012510 defendant Wyllyamson George clerk 623999 623999 Wyllyamson, George, of Myddelton, Norf, clerk 3
3965391 2012510 2012510 defendant Tompson Richard husbandman 599252 599252 Tompson, Richard, of Myddelton, husbandman 4
3965392 2012510 2012510 defendant Reveley George merchant 640775 640775 Reveley, George, of Kings Lenn, merchant 5
3965393 2012510 2012510 defendant Spylman Michael gent 662558 662558 Spylman, Michael, of Whynborouche, Norf, gent 6
3965394 2012510 2012510 defendant Well John yeoman 662559 662559 Well, John, of Wygenhall Sy Mary Magdalene, Norf, yeoman 7
3965395 2012510 2012510 defendant Bonsant or Bonfant Robert, junior yeoman 662560 662560 Bonsant or Bonfant, Robert, junior, of Wormegaye, Norf, yeoman 8
3965396 2012510 2012510 defendant Pranke Thomas yeoman 662561 662561 Pranke, Thomas, of Marham, Norf, yeoman 9
3965397 2012510 2012510 defendant Kerrye John grocer 585869 585869 Kerrye, John, of London, grocer 10
3965398 2012510 2012510 defendant Fletche Martin yeoman 662562 662562 Fletche, Martin, of Uppwell, Norf, yeoman 11
3965399 2012510 2012510 defendant Fyssher Nicholas yeoman 662563 662563 Fyssher, Nicholas, of Uppwell, yeoman 12

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