names

18 rows where case_id = 2373558

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5056634 2373558 2373558 plaintiff Chamberleyn Walter     Chamberleyn, Walter 0
5056635 2373558 2373558 defendant Smyth Stephen yeoman 841154 841154 Smyth, Stephen, of Wateryngbery, Kent, yeoman 0
5056636 2373558 2373558 defendant Odyerne Thomas yeoman 613518 613518 Odyerne, Thomas, of Wateryngbery, yeoman 1
5056637 2373558 2373558 defendant Kebell John smith 613518 613518 Kebell, John, of Wateryngbery, smith 2
5056638 2373558 2373558 defendant Smyth Nicholas butcher 613518 613518 Smyth, Nicholas, of Wateryngbery, butcher 3
5056639 2373558 2373558 defendant Wardeyn Robert husbandman 613518 613518 Wardeyn, Robert, of Wateryngbery, husbandman 4
5056640 2373558 2373558 defendant Taillour John husbandman 591523 591523 Taillour, John, of Merworth, Kent, husbandman 5
5056641 2373558 2373558 defendant Colier Robert husbandman 600263 600263 Colier, Robert, of Merworth, husbandman 6
5056642 2373558 2373558 defendant Taillour Thomas husbandman 600263 600263 Taillour, Thomas, of Merworth, husbandman 7
5056643 2373558 2373558 defendant Payn Henry yeoman 600263 600263 Payn, Henry, of Merworth, yeoman 8
5056644 2373558 2373558 defendant Sexteyn John stainer 594459 594459 Sexteyn, John, of West Mallyng, Kent, stainer 9
5056645 2373558 2373558 defendant Brigges Richard West Mallyng, butcher   Brigges, Richard, West Mallyng, butcher 10
5056646 2373558 2373558 defendant Hexstaple John West Mallyng, butcher   Hexstaple, John, West Mallyng, butcher 11
5056647 2373558 2373558 defendant Serche John West Mallyng, husbandman   Serche, John, West Mallyng, husbandman 12
5056648 2373558 2373558 defendant Dowene William West Mallyng, yeoman   Dowene, William, West Mallyng, yeoman 13
5056649 2373558 2373558 defendant Bertelot John West Mallyng, tanner   Bertelot, John, West Mallyng, tanner 14
5056650 2373558 2373558 defendant William Johon West Mallyng, husbandman   William, Johon, West Mallyng, husbandman 15
5056651 2373558 2373558 defendant Peyntour William West Mallyng, husbandman   Peyntour, William, West Mallyng, husbandman 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);