names

17 rows where place_id = 686451

✎ 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
4066889 2048455 2048455 defendant Sherrington Nicholas tailor 686451 686451 Sherrington, Nicholas, of Pinchbeck, tailor 0
4080530 2053351 2053351 plaintiff Warryner Roger yeoman 686451 686451 Warryner, Roger, of Pinchbeck, yeoman 0
4080535 2053352 2053352 plaintiff Warryner Roger yeoman 686451 686451 Warryner, Roger, of Pinchbeck, yeoman 0
4087087 2055675 2055675 defendant Huddilston John gent 686451 686451 Huddilston, John, of Pinchbeck, gent 0
4171980 2085661 2085661 defendant Ingram Hugh laborer 686451 686451 Ingram, Hugh, of Pinchbeck, laborer 2
4171981 2085661 2085661 defendant Walker Richard laborer 686451 686451 Walker, Richard, of Pinchbeck, laborer 3
4236022 2108171 2108171 defendant Mason Anthony yeoman 686451 686451 Mason, Anthony, of Pinchbeck, yeoman 2
4273612 2120725 2120725 defendant Hull Hugh husbandman or yeoman 686451 686451 Hull, Hugh, of Pinchbeck, husbandman or yeoman 0
4277376 2122009 2122009 defendant Reade Richard yeoman 686451 686451 Reade, Richard, of Pinchbeck, yeoman 1
4280301 2123012 2123012 defendant Braynsby Robert carpenter 686451 686451 Braynsby, Robert, of Pinchbeck, carpenter 1
4280306 2123014 2123014 defendant Tompson Joel yeoman 686451 686451 Tompson, Joel, of Pinchbeck, yeoman 1
4308694 2133191 2133191 defendant Tompson Joel yeoman 686451 686451 Tompson, Joel, of Pinchbeck, yeoman 0
4326223 2139136 2139136 defendant Hynman or Inman Roland yeoman 686451 686451 togehter with Hynman or Inman, Roland, of Pinchbeck, yeoman 1
4344081 2145208 2145208 defendant Jenkinson Henry husbandman 686451 686451 Jenkinson, Henry, of Pinchbeck, husbandman 0
4365977 2152870 2152870 defendant Hodge John yeoman 686451 686451 Hodge, John, of Pinchbeck, yeoman 2
4368567 2153805 2153805 defendant Worshippe John tailor 686451 686451 Worshippe, John, of Pinchbeck, tailor 3
4374660 2156000 2156000 defendant Bate Geoffrey husbandman 686451 686451 (Bate, Geoffrey, of Pinchbeck, 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);