names

31 rows where place_id = 588706

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595320 1866167 1866167 defendant Bele William yeoman 588706 588706 Bele, William, of Martok, yeoman 1
3620560 1874006 1874006 defendant Waleys John husbandman 588706 588706 Waleys, John, of Martok, husbandman 0
3621414 1874238 1874238 defendant Prest John yeoman 588706 588706 Prest, John, of Martok, yeoman 0
3643850 1908505 1908505 defendant Acourte Robert husbandman 588706 588706 Acourte, Robert, of Martok, husbandman 0
3667495 1915775 1915775 defendant Carter John carpenter 588706 588706 Carter, John, of Martok, carpenter 0
3668823 1916184 1916184 defendant Canon John husbandman 588706 588706 Canon, John, of Martok, husbandman 0
3735955 1937482 1937482 defendant Burnell Andrew smith 588706 588706 Burnell, Andrew, of Martok, smith 2
3755447 1943657 1943657 defendant Rowe Richard smith 588706 588706 Rowe, Richard, of Martok, smith 0
3756753 1944085 1944085 defendant Cole John yeoman 588706 588706 Cole, John, of Martok, yeoman 1
3785055 1953109 1953109 defendant Nurse Stephen clerk 588706 588706 Nurse, Stephen, of Martok, clerk 0
3785056 1953109 1953109 defendant Meker Thomas husbandman 588706 588706 Meker, Thomas, of Martok, husbandman 1
3847719 1972858 1972858 defendant Typp Richard husbandman 588706 588706 Typp, Richard, of Martok, husbandman 0
3859585 1976698 1976698 defendant Wittecombe William gent 588706 588706 Wittecombe, William, of Martok, gent 0
3875422 1982026 1982026 defendant Bursey John husbandman 588706 588706 Bursey, John, of Martok, husbandman 0
3875423 1982026 1982026 defendant Dyer Robert husbandman 588706 588706 Dyer, Robert, of Martok, husbandman 1
4606511 2233147 2233147 defendant Horn Thomas   588706 588706 Horn, Thomas, of Martok 1
4693525 2263476 2263476 defendant Bone Richard fishmonger 588706 588706 Bone, Richard, of Martok, fishmonger 2
4761510 2283943 2283943 defendant Lymburgh John dyer 588706 588706 Lymburgh, John, of Martok, dyer 2
5047598 2370900 2370900 defendant Dannot Thomas gent 588706 588706 Dannot, Thomas, of Martok, gent 0
5135494 2396894 2396894 defendant Barnard John   588706 588706 Barnard, John, of Martok, parson 0
5243537 2428304 2428304 defendant Daunce Thomas gent 588706 588706 Daunce, Thomas, of Martok, gent 0
5322767 2451886 2451886 defendant Prest John husbandman 588706 588706 Prest, John, of Martok, husbandman 0
5322769 2451887 2451887 defendant Prest John yeoman 588706 588706 Prest, John, of Martok, yeoman 0
5496889 2504000 2504000 plaintiff Larder Thomas (legal representative) 588706 588706 Larder, Thomas, of Martok, executors of 0
5544423 2518367 2518367 defendant Waleys John husbandman 588706 588706 Waleys, John, of Martok, husbandman 0
5566335 2524747 2524747 defendant Otys Thomas butcher 588706 588706 Otys, Thomas, of Martok, butcher 0
5587218 2531029 2531029 defendant Key Founce courser 588706 588706 Key, Founce, of Martok, courser 3
5606535 2536933 2536933 plaintiff Trapnell Robert (legal representative) 588706 588706 Trapnell, Robert, of Martok, tucker, executors of 0
5606537 2536933 2536933 defendant Patewyn Thomas husbandman 588706 588706 Patewyn, Thomas, of Martok, husbandman 0
5607388 2537207 2537207 defendant Wytcombe John gent 588706 588706 Wytcombe, John, of Martok, gent 0
5610250 2546919 2546919 defendant Jory John butcher 588706 588706 Jory, John, of Martok, butcher 3

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