names

23 rows where place_id = 602238

✎ 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
3649114 1910108 1910108 defendant Barker Robert yeoman 602238 602238 Barker, Robert, of Tadcaster, Yorks, yeoman 0
3654834 1911771 1911771 defendant Lacok John   602238 602238 Lacok, John, of Tadcaster, Yorks, inn holder 0
3674683 1918130 1918130 defendant Sedall Robert yeoman 602238 602238 Sedall, Robert, of Tadcaster, Yorks, yeoman 0
3701009 1926562 1926562 defendant Ratclyff William gent 602238 602238 Ratclyff, William, of Tadcaster, Yorks, or of Clements Inn, gent 11
3911652 1994220 1994220 defendant Denton Anter or Amar merchant 602238 602238 Denton, Anter or Amar, of Tadcaster, Yorks, merchant 0
3914729 1995271 1995271 defendant Donton Amory yeoman 602238 602238 Donton, Amory, of Tadcaster, Yorks, yeoman 4
4062359 2046825 2046825 defendant Foster Leonard gent 602238 602238 Foster, Leonard, of Tadcaster, Yorks, gent 2
4762057 2284116 2284116 defendant Normanvyle William   602238 602238 Normanvyle, William, of Tadcaster, Yorks, knight 0
4776167 2288542 2288542 defendant Soureby John laborer 602238 602238 Soureby, John, of Tadcaster, Yorks, laborer 3
4802262 2296897 2296897 defendant Rigton Richard walker 602238 602238 Rigton, Richard, of Tadcaster, Yorks, walker 1
5374058 2467488 2467488 defendant Bell John yeoman 602238 602238 Bell, John, of Tadcaster, Yorks, yeoman 1
5374094 2467495 2467495 defendant Bell John yeoman 602238 602238 Bell, John, of Tadcaster, Yorks, yeoman 1
5382170 2469958 2469958 defendant Bell John yeoman 602238 602238 Bell, John, of Tadcaster, Yorks, yeoman 0
5398068 2474516 2474516 defendant Borowedale Richard yeoman 602238 602238 Borowedale, Richard, of Tadcaster, Yorks, yeoman 0
5409506 2477807 2477807 defendant Stopper Richard yeoman 602238 602238 Stopper, Richard, of Tadcaster, Yorks, yeoman 4
5409513 2477808 2477808 defendant Stopper Richard yeoman 602238 602238 Stopper, Richard, of Tadcaster, Yorks, yeoman 4
5411215 2478314 2478314 defendant Borodale Richard yeoman 602238 602238 Borodale, Richard, of Tadcaster, Yorks, yeoman 0
5416866 2479964 2479964 defendant Bell John yeoman 602238 602238 Bell, John, of Tadcaster, Yorks, yeoman 0
5433849 2485092 2485092 defendant Bell John yeoman 602238 602238 Bell, John, of Tadcaster, Yorks, yeoman 0
5433899 2485100 2485100 defendant Bell John yeoman 602238 602238 Bell, John, of Tadcaster, Yorks, yeoman 0
5433935 2485105 2485105 defendant Bell John yeoman 602238 602238 Bell, John, of Tadcaster, Yorks, yeoman 0
5541429 2517432 2517432 defendant Forman Robert husbandman 602238 602238 Forman, Robert, of Tadcaster, Yorks, husbandman 4
5604272 2536199 2536199 defendant Whytehed John yeoman 602238 602238 Whytehed, John, of Tadcaster, Yorks, yeoman 0

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