names

17 rows where place_id = 589282

✎ 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
3597097 1866715 1866715 defendant Stormorthe or Stormesworth Thomas yeoman 589282 589282 Stormorthe or Stormesworth, Thomas, of Chertesey, Surrey, yeoman 0
3639271 1907094 1907094 defendant Tukker John carpenter 589282 589282 Tukker, John, of Chertesey, Surrey, carpenter 1
3773781 1949515 1949515 defendant Stydolff Thomas esq 589282 589282 Stydolff, Thomas, of Chertesey, Surrey, esq 0
4980840 2351199 2351199 defendant FitzJohn Nicholas gent 589282 589282 FitzJohn, Nicholas, of Chertesey, Surrey, gent 0
5026519 2364637 2364637 defendant Nook Nicholas laborer 589282 589282 Nook, Nicholas, of Chertesey, Surrey, laborer 0
5026523 2364638 2364638 defendant Nook Nicholas laborer 589282 589282 Nook, Nicholas, of Chertesey, Surrey, laborer 0
5055606 2373252 2373252 defendant Broke Robert   589282 589282 Broke, Robert, of Chertesey, Surrey, "shonteman" 1
5055613 2373253 2373253 defendant Broke Robert   589282 589282 Broke, Robert, of Chertesey, Surrey, "shonteman" 1
5085804 2382243 2382243 defendant FitzJohn Henry gent 589282 589282 FitzJohn, Henry, of Chertesey, Surrey, gent 1
5214191 2419880 2419880 defendant Fyssher Thomas husbandman 589282 589282 Fyssher, Thomas, of Chertesey, Surrey, husbandman 0
5214193 2419881 2419881 defendant Fyssher Thomas husbandman 589282 589282 Fyssher, Thomas, of Chertesey, Surrey, husbandman 0
5229493 2424240 2424240 defendant Broke Robert yeoman 589282 589282 Broke, Robert, of Chertesey, Surrey, yeoman 2
5549726 2519955 2519955 defendant Abell John gent 589282 589282 Abell, John, of Chertesey, Surrey, gent 4
5551579 2520503 2520503 defendant Moryng Robert yeoman 589282 589282 Moryng, Robert, of Chertesey, Surrey, yeoman 1
5554606 2521380 2521380 defendant Moryng Robert yeoman 589282 589282 Moryng, Robert, of Chertesey, Surrey, yeoman 9
5554770 2521402 2521402 defendant Moryng Robert yeoman 589282 589282 Moryng, Robert, of Chertesey, Surrey, yeoman 0
5554806 2521405 2521405 defendant Moryng Robert yeoman 589282 589282 Moryng, Robert, of Chertesey, Surrey, yeoman 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);