names

39 rows where place_id = 610287

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3682842 1920741 1920741 defendant Carvanell John mercer 610287 610287 Carvanell, John, of Tavystoke, Devon, mercer 0
3751391 1942350 1942350 defendant Myddewell alias Medewell Michael dyer 610287 610287 Myddewell alias Medewell, Michael, of Tavystoke, Devon, dyer 0
3760835 1945391 1945391 defendant Hawkyns John chapman 610287 610287 Hawkyns, John, of Tavystoke, Devon, chapman 1
3800384 1958037 1958037 defendant Foster Ralph yeoman 610287 610287 Foster, Ralph, of Tavystoke, Devon, yeoman 0
3838442 1969944 1969944 defendant Williams John merchant 610287 610287 Williams, John, of Tavystoke, Devon, merchant 2
3865058 1978515 1978515 plaintiff Mayow Richard mercer 610287 610287 Mayow, Richard, of Tavystoke, Devon, mercer 0
3883165 1984631 1984631 defendant Amydes John esq 610287 610287 Amydes, John, of Tavystoke, Devon, esq 0
3924490 1998505 1998505 defendant Frankelyn John butcher 610287 610287 Frankelyn, John, of Tavystoke, Devon, butcher 0
3928723 1999943 1999943 plaintiff Brabone Richard   610287 610287 Brabone, Richard, of Tavystoke, Devon 0
4083872 2054505 2054505 defendant Twygge Richard yeoman 610287 610287 Twygge, Richard, of tavystoke, Devon, yeoman 0
4083876 2054506 2054506 defendant Twygge Richard yeoman 610287 610287 Twygge, Richard, of Tavystoke, Devon, yeoman 0
4726683 2273616 2273616 defendant Julkyn John gent 610287 610287 Julkyn, John, of Tavystoke, Devon, gent 0
4749400 2280305 2280305 defendant Gilkyn John husbandman 610287 610287 Gilkyn, John, of Tavystoke, Devon, husbandman 1
4749403 2280306 2280306 defendant Gilkyn John husbandman 610287 610287 Gilkyn, John, of Tavystoke, Devon, husbandman 1
4789800 2292877 2292877 defendant Thankrede John painter 610287 610287 Thankrede, John, of Tavystoke, Devon, painter 0
4793441 2294056 2294056 defendant Lye John cordwainer 610287 610287 Lye, John, of Tavystoke, Devon, cordwainer 1
4805984 2298082 2298082 defendant Julkyn John gent 610287 610287 Julkyn, John, of Tavystoke, Devon, gent 0
4813826 2300435 2300435 defendant Snowedon William   610287 610287 Snowedon, William, of Tavystoke, Devon, mason 0
4819780 2302258 2302258 defendant Julkyn John   610287 610287 Julkyn, John, of Tavystoke, Devon, law apprentice 4
4840208 2308486 2308486 defendant Shypyn Richard butcher 610287 610287 Shypyn, Richard, of Tavystoke, Devon, butcher 3
4907363 2328865 2328865 defendant Snowedon William husbandman 610287 610287 Snowedon, William, of Tavystoke, Devon, husbandman 4
4917348 2331937 2331937 defendant Mede Thomas   610287 610287 Mede, Thomas, of Tavystoke, Devon, abbot 0
4920981 2333074 2333074 defendant Cadele John chapman 610287 610287 Cadele, John, of Tavystoke, Devon, chapman 1
4974593 2349367 2349367 defendant Mason John chapman 610287 610287 Mason, John, of Tavystoke, Devon, chapman 0
5088933 2383138 2383138 defendant Penhale William chaplain 610287 610287 Penhale, William, of Tavystoke, Devon, chaplain 5
5123923 2393450 2393450 defendant Julkyn John (legal representative) 610287 610287 Julkyn, John, of Tavystoke, Devon, executrix of 3
5123931 2393451 2393451 defendant Julkyn John (legal representative) 610287 610287 Julkyn, John, of Tavystoke, Devon, executrix of 3
5123934 2393451 2393451 defendant Helyer William plumber 610287 610287 (Helyer, William, of Tavystoke, Devon, plumber 6
5185476 2411500 2411500 defendant Tayll John baker 610287 610287 Tayll, John, of Tavystoke, Devon, baker 0
5224821 2422930 2422930 defendant Fressheponde John merchant 610287 610287 Fressheponde, John, of Tavystoke, Devon, merchant 1
5224824 2422931 2422931 defendant Ayssheford William mercer 610287 610287 Ayssheford, William, of Tavystoke, Devon, mercer 1
5229250 2424164 2424164 defendant Pensoun John gent 610287 610287 Pensoun, John, of Tavystoke, Devon, gent 0
5292174 2442706 2442706 defendant Assheford William mercer 610287 610287 Assheford, William, of Tavystoke, Devon, mercer 0
5292438 2442785 2442785 defendant Assheford William chapman 610287 610287 Assheford, William, of Tavystoke, Devon, chapman 0
5292468 2442795 2442795 defendant Assheford William mercer 610287 610287 Assheford, William, of Tavystoke, Devon, mercer 0
5400641 2475244 2475244 defendant Haukyn John tailor 610287 610287 Haukyn, John, of Tavystoke, Devon, tailor 3
5413604 2478993 2478993 defendant Haukyn John tailor 610287 610287 Haukyn, John, of Tavystoke, Devon, tailor 3
5428928 2483568 2483568 defendant Hawkyn John tailor 610287 610287 Hawkyn, John, of Tavystoke, Devon, tailor 1
5503267 2505931 2505931 defendant Drake John chapman 610287 610287 Drake, John, of Tavystoke, Devon, chapman 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);