names

20 rows where place_id = 590100

✎ 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
3599918 1867629 1867629 defendant Haukyn John yeoman 590100 590100 Haukyn, John, of Tavystok, Devon, yeoman 2
3599923 1867630 1867630 defendant Haukyn or Hankyn John husbandman 590100 590100 Haukyn or Hankyn, John, of Tavystok, Devon, husbandman 3
3689145 1922768 1922768 defendant Honychurche William gent 590100 590100 Honychurche, William, of Tavystok, Devon, gent 0
3689147 1922769 1922769 defendant Honychurche William gent 590100 590100 Honychurche, William, of Tavystok, Devon, gent 0
4737885 2276954 2276954 defendant Honychyrch Robert yeoman 590100 590100 Honychyrch, Robert, of Tavystok, Devon, yeoman 0
4753804 2281563 2281563 defendant Persones Walter gent 590100 590100 Persones, Walter, of Tavystok, Devon, gent 1
4768970 2286273 2286273 defendant Gilkyn John gent 590100 590100 Gilkyn, John, of Tavystok, Devon, gent 0
4870872 2317865 2317865 defendant Tayll William tailor 590100 590100 Tayll, William, of Tavystok, Devon, tailor 1
4896371 2325530 2325530 plaintiff Cadelye or Cadligh John merchant 590100 590100 Cadelye or Cadligh, John, of Tavystok, Devon, merchant 0
4907443 2328889 2328889 plaintiff Cadeley or Cadligh John merchant 590100 590100 Cadeley or Cadligh, John, of Tavystok, Devon, merchant 0
4957788 2344301 2344301 defendant Lyer William hosier 590100 590100 Lyer, William, of Tavystok, Devon, hosier 0
5055933 2373341 2373341 defendant Assheford William chapman 590100 590100 Assheford, William, of Tavystok, Devon, chapman 0
5105903 2388168 2388168 defendant Aysshford William yeoman 590100 590100 Aysshford, William, of Tavystok, Devon, yeoman 0
5117306 2391495 2391495 defendant Fresshpond William merchant 590100 590100 Fresshpond, William, of Tavystok, Devon, merchant 1
5117384 2391517 2391517 defendant Assheford William chapman 590100 590100 Assheford, William, of Tavystok, Devon, chapman 0
5152610 2401905 2401905 defendant Huston Thomas (legal representative) 590100 590100 Huston, Thomas, of Tavystok, Devon, executors of 0
5185474 2411499 2411499 defendant Assheford William mercer 590100 590100 Assheford, William, of Tavystok, Devon, mercer 0
5246946 2429271 2429271 defendant Bryuyn Edmund mercer 590100 590100 Bryuyn, Edmund, of Tavystok, Devon, mercer 0
5508046 2507410 2507410 defendant Wever Benedict yeoman 590100 590100 Wever, Benedict, of Tavystok, Devon, yeoman 0
5564242 2524150 2524150 defendant Tankret William gent 590100 590100 Tankret, William, of Tavystok, Devon, gent 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);