names

19 rows where place_id = 588321

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592441 1865251 1865251 plaintiff Geffrey William, junior (legal representative) 588321 588321 Geffrey, William, junior, of Benyngton, Lincs, executor of 0
3592444 1865252 1865252 plaintiff Geffrey William (legal representative) 588321 588321 Geffrey, William, of Benyngton, Lincs, executor of 0
3594092 1865794 1865794 defendant Kyme or Kynne John yeoman 588321 588321 Kyme or Kynne, John, of Benyngton, Lincs, yeoman 1
3617176 1872996 1872996 defendant Ryve or Rybe William clerk 588321 588321 Ryve or Rybe, William, of Benyngton, Lincs, clerk 0
3635364 1905856 1905856 defendant Bell Robert weaver 588321 588321 Bell, Robert, of Benyngton, Lincs, weaver 0
3933274 2001424 2001424 defendant Derby William gent 588321 588321 Derby, William, of Benyngton, Lincs, gent 0
3933277 2001425 2001425 defendant Derby William gent 588321 588321 Derby, William, of Benyngton, Lincs, gent 0
3956874 2009475 2009475 defendant Gylbert Michael husbandman 588321 588321 Gylbert, Michael, of Benyngton, Lincs, husbandman 0
4342347 2144598 2144598 defendant Browne Richard yeoman 588321 588321 Browne, Richard, of Benyngton, Lincs, yeoman 0
4886490 2322638 2322638 defendant Smyth Richard husbandman 588321 588321 Smyth, Richard, of Benyngton, Lincs, husbandman 0
4939445 2338718 2338718 defendant Quadryng William gent 588321 588321 Quadryng, William, of Benyngton, Lincs, gent 4
4978576 2350543 2350543 defendant Derby William   588321 588321 Derby, William, of Benyngton, Lincs, knight 0
5100748 2386643 2386643 defendant Derby William   588321 588321 Derby, William, of Benyngton, Lincs, knight 0
5306148 2446828 2446828 defendant Rykke Robert   588321 588321 Rykke, Robert, of Benyngton, Lincs, mason 2
5462459 2493674 2493674 defendant Derby William gent 588321 588321 Derby, William, of Benyngton, Lincs, gent 0
5474120 2497239 2497239 defendant Derby William gent 588321 588321 Derby, William, of Benyngton, Lincs, gent 0
5514250 2509304 2509304 defendant Braunche William gent 588321 588321 Braunche, William, of Benyngton, Lincs, gent 1
5522679 2511919 2511919 defendant Screvener Thomas husbandman 588321 588321 Screvener, Thomas, of Benyngton, Lincs, husbandman 0
5545471 2518664 2518664 defendant Reyby George yeoman or merchant 588321 588321 Reyby, George, of Benyngton, Lincs, yeoman or merchant 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);