names

28 rows where place_id = 593973

✎ 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
3614016 1872042 1872042 defendant Gallan John baker 593973 593973 Gallan, John, of Banbery, Oxon, baker 1
3615072 1872359 1872359 defendant Thorp John chapman 593973 593973 Thorp, John, of Banbery, Oxon, chapman 0
3618582 1873435 1873435 defendant Castell John yeoman 593973 593973 Castell, John, of Banbery, Oxon, yeoman 3
3891531 1987432 1987432 defendant Byngham William yeoman or merchant 593973 593973 Byngham, William, of Banbery, Oxon, yeoman or merchant 0
3946134 2005723 2005723 defendant Knight John mercer 593973 593973 Knight, John, of Banbery, Oxon, mercer 2
4033095 2036487 2036487 defendant Pentelyn or Bentley Edmund shoemaker 593973 593973 Pentelyn or Bentley, Edmund, of Banbery, Oxon, shoemaker 1
4033099 2036488 2036488 defendant Pentelyn or Bentley Edmund shoemaker 593973 593973 Pentelyn or Bentley, Edmund, of Banbery, Oxon, shoemaker 2
4068421 2049003 2049003 plaintiff Knyght Mathew haberdasher 593973 593973 Knyght, Mathew, of Banbery, Oxon, haberdasher 0
4117014 2066387 2066387 defendant Knyght John innholder 593973 593973 Knyght, John, of Banbery, Oxon, innholder 0
4180670 2088721 2088721 defendant Tompson George chapman 593973 593973 Tompson, George, of Banbery, Oxon, chapman 1
4308055 2132963 2132963 defendant Colchester Robert chapman 593973 593973 Colchester, Robert, of Banbery, Oxon, chapman 1
4344191 2145248 2145248 defendant Secoll Robert draper 593973 593973 Secoll, Robert, of Banbery, Oxon, or of Lamberd, draper 2
4368011 2153610 2153610 defendant Secoll Robert draper 593973 593973 Secoll, Robert, of Banbery, Oxon, draper 2
4821494 2302807 2302807 defendant Sadeler John sadler 593973 593973 Sadeler, John, of Banbery, Oxon, sadler 0
4879901 2320626 2320626 defendant Grene Lawrence yeoman 593973 593973 Grene, Lawrence, of Banbery, Oxon, yeoman 4
4899777 2326566 2326566 defendant Hawes Richard yeoman 593973 593973 Hawes, Richard, of Banbery, Oxon, yeoman 0
4927726 2335107 2335107 defendant Pyrry alias Waryn Robert   593973 593973 Pyrry alias Waryn, Robert, of Banbery, Oxon, executor fo 1
5109755 2389280 2389280 defendant Asshewell Thomas chapman 593973 593973 Asshewell, Thomas, of Banbery, Oxon, chapman 2
5109759 2389281 2389281 defendant Asshewell Thomas chapman 593973 593973 Asshewell, Thomas, of Banbery, Oxon, chapman 2
5227372 2423633 2423633 defendant George John chapman 593973 593973 George, John, of Banbery, Oxon, chapman 1
5230088 2424418 2424418 defendant Broun William chapman 593973 593973 Broun, William, of Banbery, Oxon, chapman 1
5230099 2424420 2424420 defendant Broun William chapman 593973 593973 Broun, William, of Banbery, of Oxon, chapman 1
5355389 2461760 2461760 defendant Seymer John husbandman 593973 593973 Seymer, John, of Banbery, Oxon, husbandman 0
5484065 2500170 2500170 defendant West John yeoman 593973 593973 West, John, of Banbery, Oxon, yeoman 1
5485868 2500666 2500666 defendant Yons or Yous John dyer 593973 593973 Yons or Yous, John, of Banbery, Oxon, dyer 0
5560191 2522942 2522942 defendant Broun Henry yeoman 593973 593973 Broun, Henry, of Banbery, Oxon, yeoman 5
5564577 2524238 2524238 defendant Spycer John vintner 593973 593973 Spycer, John, of Banbery, Oxon, vintner 4
5602432 2535655 2535655 defendant Spycer John chapman 593973 593973 Spycer, John, of Banbery, Oxon, chapman 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);