names

16 rows where place_id = 616952

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3717009 1931606 1931606 defendant Wodecok John yeoman 616952 616952 Wodecok, John, of St Tue, yeoman 0
3717010 1931606 1931606 defendant Martyn William yeoman 616952 616952 Martyn, William, of St Tue, yeoman 1
3732709 1936461 1936461 defendant Martyn William yeoman 616952 616952 Martyn, William, of St Tue, yeoman 0
3732714 1936462 1936462 defendant Woodcok Johnm yeoman 616952 616952 Woodcok, Johnm, of St Tue, yeoman 0
4043821 2040241 2040241 defendant Cossyn Margaret widow 616952 616952 Cossyn, Margaret, of St Tue, widow 2
4049118 2042130 2042130 defendant Evyns or Evan David husbandman 616952 616952 Evyns or Evan, David, of St Tue, husbandman 0
4049119 2042130 2042130 defendant Bottres William husbandman 616952 616952 Bottres, William, of St Tue, husbandman 1
4079302 2052899 2052899 defendant Rondell alias Ownter John, senior husbandman 616952 616952 Rondell alias Ownter, John, senior, of St Tue, husbandman 0
4079303 2052899 2052899 defendant Rondell alias Ownter John, junior husbandman 616952 616952 Rondell alias Ownter, John, junior, of St Tue, husbandman 1
4079304 2052899 2052899 defendant Roundell alias Ownter Jerome husbandman 616952 616952 Roundell alias Ownter, Jerome, of St Tue, husbandman 2
4139320 2074429 2074429 defendant Menhewes John yeoman 616952 616952 Menhewes, John, of St Tue, yeoman 0
4183369 2089666 2089666 defendant Kympthorne Nicholas husbandman 616952 616952 Kympthorne, Nicholas, of St Tue, husbandman 3
4183382 2089669 2089669 defendant Kempthorne Nicholas husbandman 616952 616952 Kempthorne, Nicholas, of St Tue, husbandman 3
4185276 2090358 2090358 defendant Crofte William husbandman 616952 616952 Crofte, William, of St Tue, husbandman 0
4398826 2164188 2164188 defendant Mewdon Anthony yeoman 616952 616952 Mewdon, Anthony, of St Tue, yeoman 1
5536152 2515798 2515798 defendant Lawharn Vincent husbandman 616952 616952 Lawharn, Vincent, of St Tue, husbandman 0

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