names

26 rows where place_id = 586581

✎ 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
3589092 1864236 1864236 defendant Conesby Robert yeoman 586581 586581 Conesby, Robert, of Waltham St Lawrence, yeoman 0
3681610 1920341 1920341 defendant Smyth Richard husbandman 586581 586581 Smyth, Richard, of Waltham St Lawrence, husbandman 0
3686012 1921784 1921784 defendant Bolde John butcher 586581 586581 Bolde, John, of Waltham St Lawrence, butcher 3
3686079 1921805 1921805 defendant Atkyns William husbandman 586581 586581 (Atkyns, William, of Waltham St Lawrence, husbandman 5
3691970 1923651 1923651 defendant Bold John butcher 586581 586581 Bold, John, of Waltham St Lawrence, butcher 0
3691972 1923652 1923652 defendant Smewyn John husbandman 586581 586581 Smewyn, John, of Waltham St Lawrence, husbandman 0
3694093 1924357 1924357 defendant Foster John yeoman 586581 586581 Foster, John, of Waltham St Lawrence, yeoman 1
3780014 1951474 1951474 defendant Newbery Ralph husbandman 586581 586581 Newbery, Ralph, of Waltham St Lawrence, husbandman 0
3831095 1967610 1967610 defendant Honye alias Hune Thomas husbandman 586581 586581 Honye alias Hune, Thomas, of Waltham St Lawrence, husbandman 0
3831096 1967610 1967610 defendant Honye alias Hune James husbandman 586581 586581 Honye alias Hune, James, of Waltham St Lawrence, husbandman 1
3831097 1967610 1967610 defendant Smewen John husbandman 586581 586581 Smewen, John, of Waltham St Lawrence, husbandman 2
3867966 1979520 1979520 defendant Grove Richard husbandman 586581 586581 Grove, Richard, of Waltham St Lawrence, husbandman 2
3881806 1984167 1984167 defendant Grove Richard husbandman 586581 586581 Grove, Richard, of Waltham St Lawrence, husbandman 2
4846666 2310467 2310467 defendant Farendon John yeoman 586581 586581 Farendon, John, of Waltham St Lawrence, yeoman 1
4846671 2310468 2310468 defendant Farendon John yeoman 586581 586581 Farendon, John, of Waltham St Lawrence, yeoman 1
4872723 2318419 2318419 defendant Kyngston John husbandman 586581 586581 Kyngston, John, of Waltham St Lawrence, husbandman 1
4874333 2318916 2318916 defendant Farendon John yeoman 586581 586581 Farendon, John, of Waltham St Lawrence, yeoman 0
5117810 2391639 2391639 defendant Suomnere or Sumonere Richard husbandman 586581 586581 Suomnere or Sumonere, Richard, of Waltham St Lawrence, husbandman 2
5317684 2450378 2450378 defendant More Thomas, senior gent 586581 586581 More, Thomas, senior, of Waltham St Lawrence, gent 0
5317685 2450378 2450378 defendant More Thomas, junior gent 586581 586581 More, Thomas, junior, of Waltham St Lawrence, gent 1
5327368 2453257 2453257 defendant More Thomas, junior gent 586581 586581 More, Thomas, junior, of Waltham St Lawrence, gent 0
5327369 2453257 2453257 defendant More Thomas, senior gent 586581 586581 together with More, Thomas, senior, of Waltham St Lawrence, gent 1
5327371 2453258 2453258 defendant More Thomas, senior gent 586581 586581 More, Thomas, senior, of Waltham St Lawrence, gent 0
5363665 2464290 2464290 defendant Medwyn Agnes widow 586581 586581 Medwyn, Agnes, of Waltham St Lawrence, widow 1
5627642 2552617 2552617 defendant Corbet John shoemaker 586581 586581 Corbet, John, of Waltham St Lawrence, shoemaker 0
5633324 2554415 2554415 defendant Corbet John shoemaker 586581 586581 Corbet, John, of Waltham St Lawrence, shoemaker 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);