names

33 rows where place_id = 807925

✎ 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
4823117 2303317 2303317 defendant Merton Thomas merchant 807925 807925 Merton, Thomas, of Saltayssh, merchant 0
4823119 2303318 2303318 defendant Merton Thomas merchant 807925 807925 Merton, Thomas, of Saltayssh, merchant 0
4868834 2317227 2317227 defendant Whitcherche John, junior merchant 807925 807925 Whitcherche, John, junior, of Saltayssh, merchant 0
4868836 2317228 2317228 defendant Whitchirche John, junior merchant 807925 807925 Whitchirche, John, junior, of Saltayssh, merchant 0
5061634 2375071 2375071 defendant Quarell Roger tailor 807925 807925 Quarell, Roger, of Saltayssh, tailor 2
5061635 2375071 2375071 defendant Webbe Henry butcher 807925 807925 Webbe, Henry, of Saltayssh, butcher 3
5084733 2381946 2381946 defendant Walter William merchant 807925 807925 Walter, William, of Saltayssh, merchant 0
5084734 2381946 2381946 defendant Slugge John merchant 807925 807925 Slugge, John, of Saltayssh, merchant 1
5084736 2381946 2381946 defendant Amys Nicholas mariner 807925 807925 Amys, Nicholas, of Saltayssh, mariner 3
5084737 2381946 2381946 defendant Rondell or Roudell Robert mariner 807925 807925 Rondell or Roudell, Robert, of Saltayssh, mariner 4
5084738 2381946 2381946 defendant Smyth William smith 807925 807925 Smyth, William, of Saltayssh, smith 5
5084739 2381946 2381946 defendant Fleccher Robert fletcher 807925 807925 Fleccher, Robert, of Saltayssh, fletcher 6
5084740 2381946 2381946 defendant Walter Gregory yeoman 807925 807925 Walter, Gregory, of Saltayssh, yeoman 7
5084741 2381946 2381946 defendant Gogga John mariner 807925 807925 Gogga, John, of Saltayssh, mariner 8
5084742 2381946 2381946 defendant Wandre Nicholas mariner 807925 807925 Wandre, Nicholas, of Saltayssh, mariner 9
5084743 2381946 2381946 defendant Webbe Henry mariner 807925 807925 Webbe, Henry, of Saltayssh, mariner 10
5084744 2381946 2381946 defendant Webbe John mariner 807925 807925 Webbe, John, of Saltayssh, mariner 11
5084745 2381946 2381946 defendant Connar John mariner 807925 807925 Connar, John, of Saltayssh, mariner 12
5084746 2381946 2381946 defendant Feyre William yeoman 807925 807925 Feyre, William, of Saltayssh, yeoman 13
5084747 2381946 2381946 defendant Slugge Richard mariner 807925 807925 Slugge, Richard, of Saltayssh, mariner 14
5084748 2381946 2381946 defendant Eston John mariner 807925 807925 Eston, John, of Saltayssh, mariner 15
5089473 2383292 2383292 plaintiff Loll Nicholas merchant 807925 807925 Loll, Nicholas, of Saltayssh, merchant 0
5123489 2393322 2393322 defendant Eston John skinner 807925 807925 Eston, John, of Saltayssh, skinner 0
5128890 2394935 2394935 defendant Fyssher Henry mariner 807925 807925 Fyssher, Henry, of Saltayssh, mariner 2
5148066 2400581 2400581 defendant Fyssher Henry mariner 807925 807925 Fyssher, Henry, of Saltayssh, mariner 0
5148069 2400581 2400581 defendant Slugge Richard merchant 807925 807925 Slugge, Richard, of Saltayssh, merchant 3
5148071 2400582 2400582 defendant Walter Gregory merchant 807925 807925 Walter, Gregory, of Saltayssh, merchant 0
5203688 2416830 2416830 defendant Fyssher Henry mariner 807925 807925 Fyssher, Henry, of Saltayssh, mariner 0
5203691 2416830 2416830 defendant Slugge Richard merchant 807925 807925 Slugge, Richard, of Saltayssh, merchant 3
5225081 2423004 2423004 defendant Hoygge Henry gent 807925 807925 Hoygge, Henry, of Saltayssh, gent 0
5225082 2423004 2423004 defendant Webbe William, junior husbandman 807925 807925 Webbe, William, junior, of Saltayssh, husbandman 1
5225083 2423004 2423004 defendant Coke William husbandman 807925 807925 Coke, William, of Saltayssh, husbandman 2
5323929 2452238 2452238 defendant Stephyn Roger mariner 807925 807925 (Stephyn, Roger, of Saltayssh, mariner 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);