names

23 rows where place_id = 586378

✎ 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
3588558 1864064 1864064 defendant Drake John mercer 586378 586378 Drake, John, of Tavestoke, mercer 1
3626635 1903180 1903180 defendant Sargent John clerk 586378 586378 Sargent, John, of Tavestoke, clerk 0
4651560 2246488 2246488 defendant Godyer William   586378 586378 Godyer, William, of Tavestoke, bailiff 5
4796197 2294959 2294959 defendant Webber John smith 586378 586378 Webber, John, of Tavestoke, smith 10
4894697 2325013 2325013 defendant Conche or Couche Thomas   586378 586378 Conche or Couche, Thomas, of Tavestoke 0
4897577 2325903 2325903 defendant Draper Joan widow 586378 586378 Draper, Joan, of Tavestoke, widow 5
4930414 2335913 2335913 plaintiff Toke Stephen   586378 586378 Toke, Stephen, of Tavestoke, on his own account 0
4946219 2340803 2340803 plaintiff John Richard merchant 586378 586378 John, Richard, of Tavestoke, merchant 0
4962839 2345799 2345799 defendant Mason John mercer 586378 586378 Mason, John, of Tavestoke, mercer 0
5059240 2374329 2374329 defendant Umfray John tucker 586378 586378 Umfray, John, of Tavestoke, tucker 0
5059241 2374329 2374329 defendant Umfray Thomas miller 586378 586378 Umfray, Thomas, of Tavestoke, miller 1
5092917 2384312 2384312 defendant Droune John husbandman 586378 586378 Droune, John, of Tavestoke, husbandman 0
5127704 2394586 2394586 defendant (illegible) Richard husbandman 586378 586378 --, Richard, of Tavestoke, husbandman 1
5129913 2395238 2395238 defendant Ouger John yeoman 586378 586378 Ouger, John, of Tavestoke, yeoman 0
5139279 2397977 2397977 defendant Lybbe William (legal representative) 586378 586378 Lybbe, William, of Tavestoke, executrix of 3
5155472 2402759 2402759 defendant Soper William husbandman 586378 586378 Soper, William, of Tavestoke, husbandman 0
5155473 2402759 2402759 defendant Fee Michael tanner 586378 586378 Fee, Michael, of Tavestoke, tanner 1
5155474 2402759 2402759 defendant Lybbe Thomas tanner 586378 586378 Lybbe, Thomas, of Tavestoke, tanner 2
5172100 2407558 2407558 defendant Fee Michael tanner 586378 586378 Fee, Michael, of Tavestoke, tanner 1
5191166 2413157 2413157 defendant Soper William husbandman 586378 586378 Soper, William, of Tavestoke, husbandman 0
5191167 2413157 2413157 defendant Fee Michael tanner 586378 586378 Fee, Michael, of Tavestoke, tanner 1
5247186 2429334 2429334 defendant Assheford William mercer 586378 586378 Assheford, William, of Tavestoke, mercer 2
5526061 2512732 2512732 defendant Palmer William gent 586378 586378 Palmer, William, of Tavestoke, gent 2

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