names

20 rows where place_id = 610637

✎ 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
3684490 1921283 1921283 defendant Blakenalle Thomas yeoman 610637 610637 Blakenalle, Thomas, of Waterbeche, yeoman 0
3696351 1925079 1925079 defendant Rokyn Lancelot yeoman 610637 610637 Rokyn, Lancelot, of Waterbeche, yeoman 1
3830777 1967509 1967509 defendant Sargeant Richard husbandman 610637 610637 Sargeant, Richard, of Waterbeche, husbandman 0
3855927 1975479 1975479 defendant Brenens or Brevens Baldwin gent 610637 610637 Brenens or Brevens, Baldwin, of Waterbeche, gent 1
3889547 1986736 1986736 defendant Pakman John husbandman 610637 610637 Pakman, John, of Waterbeche, husbandman 0
4184491 2090084 2090084 defendant Gotobed William husbandman 610637 610637 Gotobed, William, of Waterbeche, husbandman 2
4198786 2095136 2095136 defendant Gotobedd William husbandman 610637 610637 Gotobedd, William, of Waterbeche, husbandman 2
4273121 2120571 2120571 defendant Gallyon Arthur laborer 610637 610637 Gallyon, Arthur, of Waterbeche, laborer 2
4332693 2141218 2141218 defendant Pecke John yeoman 610637 610637 Pecke, John, of Waterbeche, yeoman 1
4495354 2199227 2199227 defendant Daubere or Danbere John   610637 610637 Daubere or Danbere, John, of Waterbeche 1
4811338 2299656 2299656 plaintiff Fyde William   610637 610637 Fyde, William, of Waterbeche 0
4884801 2322146 2322146 defendant Pepyr Alice   610637 610637 Pepyr, Alice, of Waterbeche, servant 0
4934047 2337028 2337028 defendant Fyde William husbandman 610637 610637 Fyde, William, of Waterbeche, husbandman 0
4955261 2343532 2343532 defendant Michell John husbandman 610637 610637 Michell, John, of Waterbeche, husbandman 0
4992779 2354723 2354723 defendant Michell John husbandman 610637 610637 Michell, John, of Waterbeche, husbandman 0
5098892 2386108 2386108 defendant Abell John husbandman 610637 610637 Abell, John, of Waterbeche, husbandman 1
5098893 2386108 2386108 defendant Theccher Thomas husbandman 610637 610637 Theccher, Thomas, of Waterbeche, husbandman 2
5488370 2501416 2501416 defendant Smyth Thomas husbandman 610637 610637 Smyth, Thomas, of Waterbeche, husbandman 0
5488371 2501416 2501416 defendant Smyth John laborer 610637 610637 Smyth, John, of Waterbeche, laborer 1
5548899 2519720 2519720 defendant Malte John husbandman 610637 610637 Malte, John, of Waterbeche, husbandman 2

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