names

13 rows where case_id = 2555379

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5636543 2555379 2555379 plaintiff Wyke William, senior     Wyke, William, senior 0
5636544 2555379 2555379 defendant Oxenham Richard yeoman 592653 592653 Oxenham, Richard, of South Tauton, yeoman 0
5636545 2555379 2555379 defendant Oxenham Thomas tucker 592653 592653 Oxenham, Thomas, of South Tauton, tucker 1
5636546 2555379 2555379 defendant Oxenham William   592653 592653 Oxenham, William, of South Tauton, holy water clerk 2
5636547 2555379 2555379 defendant Oxenham John   592653 592653 Oxenham, John, of South Tauton, groom 3
5636548 2555379 2555379 defendant Mylleford William gent 592653 592653 Mylleford, William, of South Tauton, gent 4
5636549 2555379 2555379 defendant Leveton Geoffrey husbandman 592653 592653 Leveton, Geoffrey, of South Tauton, husbandman 5
5636550 2555379 2555379 defendant Batteshill John husbandman 592653 592653 Batteshill, John, of South Tauton, husbandman 6
5636551 2555379 2555379 defendant Aderscote William butcher 592653 592653 Aderscote, William, of South Tauton, butcher 7
5636552 2555379 2555379 defendant Selyman Thomas tailor 592653 592653 Selyman, Thomas, of South Tauton, tailor 8
5636553 2555379 2555379 defendant Trendelbeare John husbandman 592653 592653 Trendelbeare, John, of South Tauton, husbandman 9
5636554 2555379 2555379 defendant Wilman John husbandman 592653 592653 Wilman, John, of South Tauton, husbandman 10
5636555 2555379 2555379 defendant Wouston or Wonston John laborer 592653 592653 Wouston or Wonston, John, of South Tauton, laborer 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);