names

15 rows where place_id = 648336

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3901108 1990597 1990597 defendant Kempe Thomas smith 648336 648336 Kempe, Thomas, of Tharston, smith 0
3901114 1990598 1990598 defendant Kempe Thomas smith 648336 648336 Kempe, Thomas, of Tharston, smith 0
4105097 2062097 2062097 defendant Westgate John husbandman 648336 648336 Westgate, John, of Tharston, husbandman 1
4111452 2064343 2064343 defendant Kerison Nicholas husbandman 648336 648336 Kerison, Nicholas, of Tharston, husbandman 2
4140128 2074716 2074716 defendant Buttall Richard yeoman 648336 648336 Buttall, Richard, of Tharston, yeoman 0
4150145 2078185 2078185 defendant Buttall Richard yeoman 648336 648336 Buttall, Richard, of Tharston, yeoman 3
4212033 2099758 2099758 defendant Buttall Richard yeoman 648336 648336 Buttall, Richard, of Tharston, yeoman 0
4257743 2115560 2115560 defendant Westgate William yeoman 648336 648336 Westgate, William, of Tharston, yeoman 1
4277092 2121919 2121919 defendant Buttoll or Butteld Richard yeoman 648336 648336 Buttoll or Butteld, Richard, of Tharston, yeoman 2
4316696 2135958 2135958 defendant Cooke William, junior yeoman 648336 648336 Cooke, William, junior, of Tharston, yeoman 1
4321283 2137535 2137535 defendant Butteld Richard yeoman 648336 648336 Butteld, Richard, of Tharston, yeoman 1
4337854 2142986 2142986 defendant Buttell Richard yeoman 648336 648336 Buttell, Richard, of Tharston, yeoman 0
4382758 2158938 2158938 defendant Westgate William yeoman 648336 648336 Westgate, William, of Tharston, yeoman 0
4408154 2167297 2167297 defendant Butteld Richard yeoman 648336 648336 Butteld, Richard, of Tharston, yeoman 0
5052018 2372217 2372217 defendant Howelot Nicholas husbandman 648336 648336 Howelot, Nicholas, of Tharston, husbandman 1

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