names

22 rows where place_id = 591402

✎ 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
3604294 1869006 1869006 defendant Franke William yeoman 591402 591402 Franke, William, of Wandelesworth, yeoman 1
3609228 1870548 1870548 defendant Franke William yeoman 591402 591402 Franke, William, of Wandelesworth, yeoman 0
3665442 1915140 1915140 defendant Morgan John brewer 591402 591402 Morgan, John, of Wandelesworth, brewer 0
3748612 1941498 1941498 defendant Atherton Matthew gent 591402 591402 Atherton, Matthew, of Wandelesworth, gent 0
3772905 1949225 1949225 plaintiff Welyfed or Welysed William yeoman 591402 591402 Welyfed or Welysed, William, of Wandelesworth, yeoman 0
4573862 2223344 2223344 defendant Clyer or Olyer Thomas   591402 591402 Clyer or Olyer, Thomas, of Wandelesworth 1
4633819 2241431 2241431 defendant Dull Richard   591402 591402 Dull, Richard, of Wandelesworth 0
5280338 2439330 2439330 defendant Lacy John husbandman 591402 591402 Lacy, John, of Wandelesworth, husbandman 0
5378871 2468979 2468979 defendant Albone John clerk 591402 591402 Albone, John, of Wandelesworth, clerk 0
5390255 2472277 2472277 defendant Latyn John huabandman 591402 591402 Latyn, John, of Wandelesworth, huabandman 1
5439959 2486894 2486894 defendant Barnard John gent 591402 591402 Barnard, John, of Wandelesworth, gent 0
5439961 2486895 2486895 defendant Barnard John gent 591402 591402 Barnard, John, of Wandelesworth, gent 0
5439963 2486896 2486896 defendant Barnard John gent 591402 591402 Barnard, John, of Wandelesworth, gent 0
5554961 2521453 2521453 defendant Boone Henry husbandman 591402 591402 Boone, Henry, of Wandelesworth, husbandman 2
5554962 2521453 2521453 defendant Bonyngton alias Bovyngton John husbandman 591402 591402 Bonyngton alias Bovyngton, John, of Wandelesworth, husbandman 3
5591440 2532296 2532296 defendant Frank William brewer 591402 591402 Frank, William, of Wandelesworth, brewer 0
5633252 2554405 2554405 defendant Felix John barber 591402 591402 Felix, John, of Wandelesworth, barber 0
5633255 2554405 2554405 defendant Bocher Richard butcher 591402 591402 Bocher, Richard, of Wandelesworth, butcher 3
5633259 2554406 2554406 defendant Bocher Richard butcher 591402 591402 Bocher, Richard, of Wandelesworth, butcher 2
5633260 2554406 2554406 defendant Felix John barber 591402 591402 together with Felix, John, of Wandelesworth, barber 3
5633339 2554420 2554420 defendant Bocher Richard butcher 591402 591402 Bocher, Richard, of Wandelesworth, butcher 2
5633340 2554420 2554420 defendant Felix John barber 591402 591402 Felix, John, of Wandelesworth, barber 3

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