names

17 rows where case_id = 2082725

✎ 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
4163396 2082725 2082725 plaintiff Talbot George Earl of Shrewsbury   Talbot, George, Earl of Shrewsbury 0
4163397 2082725 2082725 defendant Watson Robert clerk 653372 653372 Watson, Robert, of Kynnersley, clerk 0
4163398 2082725 2082725 defendant Chorlton Robert yeoman 706544 706544 Chorlton, Robert, of Tern, yeoman 1
4163399 2082725 2082725 defendant Caresenall Thomas husbandman 653372 653372 Caresenall, Thomas, of Kynnersley, husbandman 2
4163400 2082725 2082725 defendant Harper alias Hynson John husbandman 653372 653372 Harper alias Hynson, John, of Kynnersley, husbandman 3
4163401 2082725 2082725 defendant Harper Roger husbandman 653372 653372 Harper, Roger, of Kynnersley, husbandman 4
4163402 2082725 2082725 defendant Symons Richard husbandman 653372 653372 Symons, Richard, of Kynnersley, husbandman 5
4163403 2082725 2082725 defendant Symons John husbandman 653372 653372 Symons, John, of Kynnersley, husbandman 6
4163404 2082725 2082725 defendant Bell John husbandman 653372 653372 Bell, John, of Kynnersley, husbandman 7
4163405 2082725 2082725 defendant Bell William husbandman 653372 653372 Bell, William, of Kynnersley, husbandman 8
4163406 2082725 2082725 defendant Hooper John husbandman 653372 653372 Hooper, John, of Kynnersley, husbandman 9
4163407 2082725 2082725 defendant Gravener Reginald husbandman 653372 653372 Gravener, Reginald, of Kynnersley, husbandman 10
4163408 2082725 2082725 defendant Hooper William husbandman 653372 653372 Hooper, William, of Kynnersley, husbandman 11
4163409 2082725 2082725 defendant trustram William husbandman 653372 653372 trustram, William, of Kynnersley, husbandman 12
4163410 2082725 2082725 defendant Leeche John, senior husbandman 653372 653372 Leeche, John, senior, of Kynnersley, husbandman 13
4163411 2082725 2082725 defendant Leeche John, junior husbandman 653372 653372 Leeche, John, junior, of Kynnersley, husbandman 14
4163412 2082725 2082725 defendant Watson John husbandman 653372 653372 Watson, John, of Kynnersley, husbandman 15

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