names

47 rows where place_id = 590689

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602000 1868286 1868286 defendant Thomkyn William husbandman 590689 590689 Thomkyn, William, of Mousehole, husbandman 0
3797534 1957122 1957122 defendant Newell Richard fisher 590689 590689 Newell, Richard, of Mousehole, fisher 0
4572194 2222852 2222852 defendant Kellegh John   590689 590689 Kellegh, John, of Mousehole 6
4572195 2222852 2222852 defendant Tyek John   590689 590689 Tyek, John, of Mousehole 7
4572196 2222852 2222852 defendant Rawe John   590689 590689 Rawe, John, of Mousehole 8
4614839 2235646 2235646 defendant Chygergweyn Henry   590689 590689 Chygergweyn, Henry, of Mousehole 3
4614840 2235646 2235646 defendant Ande Joan   590689 590689 Ande, Joan, of Mousehole 4
4623326 2238267 2238267 defendant Power John   590689 590689 Power, John, of Mousehole 1
4653374 2246992 2246992 defendant Trewythelek Richard merchant 590689 590689 Trewythelek, Richard, of Mousehole, merchant 2
4714698 2269926 2269926 plaintiff Treweef John   590689 590689 Treweef, John, of Mousehole 0
4714701 2269927 2269927 plaintiff Trewoef John   590689 590689 Trewoef, John, of Mousehole 0
4754733 2281863 2281863 defendant Jackeraulyn Thomas yeoman 590689 590689 (Jackeraulyn, Thomas, of Mousehole, yeoman 3
5008419 2359353 2359353 defendant Trewyffe Richard gent 590689 590689 Trewyffe, Richard, of Mousehole, gent 1
5125004 2393789 2393789 defendant Trewyf Richard gent 590689 590689 Trewyf, Richard, of Mousehole, gent 0
5125005 2393789 2393789 defendant Trewyf Alexander yeoman 590689 590689 with Trewyf, Alexander, of Mousehole, yeoman 1
5125008 2393789 2393789 defendant Dove Benedict smith 590689 590689 Dove, Benedict, of Mousehole, smith 4
5125009 2393789 2393789 defendant Corser John shoemaker 590689 590689 Corser, John, of Mousehole, shoemaker 5
5125012 2393790 2393790 defendant Trewys Alexander yeoman 590689 590689 Trewys, Alexander, of Mousehole, yeoman 0
5125013 2393790 2393790 defendant Bosanguyth Ralph   590689 590689 Bosanguyth, Ralph, of Mousehole, franklin 1
5125016 2393790 2393790 defendant Corser John   590689 590689 Corser, John, of Mousehole, shoe maker 4
5125017 2393790 2393790 defendant Bene-- Henry fisher 590689 590689 Bene--, Henry, of Mousehole, fisher 5
5125018 2393790 2393790 defendant Treweyss Richard gent 590689 590689 Treweyss, Richard, of Mousehole, gent 6
5178268 2409347 2409347 defendant Trewoyff Richard gent 590689 590689 together with Trewoyff, Richard, of Mousehole, gent 1
5178272 2409347 2409347 defendant Corser John shoemaker 590689 590689 Corser, John, of Mousehole, shoemaker 5
5201376 2416159 2416159 defendant Trewyf Alexander yeoman 590689 590689 together with Trewyf, Alexander, of Mousehole, yeoman 1
5201377 2416159 2416159 defendant Besanguyth Ralph   590689 590689 Besanguyth, Ralph, of Mousehole, franklin 2
5201378 2416159 2416159 defendant Dowe Benedict smith 590689 590689 Dowe, Benedict, of Mousehole, smith 3
5201379 2416159 2416159 defendant Corser John shoemaker 590689 590689 Corser, John, of Mousehole, shoemaker 4
5201380 2416159 2416159 defendant Benet Henry fishmonger 590689 590689 Benet, Henry, of Mousehole, fishmonger 5
5201381 2416159 2416159 defendant Trewoyff Richard gent 590689 590689 Trewoyff, Richard, of Mousehole, gent 6
5319344 2450879 2450879 defendant Kembra Benedict fisher 590689 590689 Kembra, Benedict, of Mousehole, fisher 4
5319345 2450879 2450879 defendant Bossancoyde Henry yeoman 590689 590689 Bossancoyde, Henry, of Mousehole, yeoman 5
5319346 2450879 2450879 defendant Bossancoyde William yeoman 590689 590689 Bossancoyde, William, of Mousehole, yeoman 6
5320682 2451280 2451280 defendant Kembra Benedict fisher 590689 590689 Kembra, Benedict, of Mousehole, fisher 4
5320683 2451280 2451280 defendant Bossancoyde Henry yeoman 590689 590689 Bossancoyde, Henry, of Mousehole, yeoman 5
5320684 2451280 2451280 defendant Bossancoyde William yeoman 590689 590689 Bossancoyde, William, of Mousehole, yeoman 6
5326105 2452900 2452900 defendant Kembra Benedict fisher 590689 590689 Kembra, Benedict, of Mousehole, fisher 4
5326106 2452900 2452900 defendant Bossancoyde Henry yeoman 590689 590689 Bossancoyde, Henry, of Mousehole, yeoman 5
5326107 2452900 2452900 defendant Bossancoyde William yeoman 590689 590689 Bossancoyde, William, of Mousehole, yeoman 6
5354022 2461321 2461321 defendant Caunt Richard smith 590689 590689 Caunt, Richard, of Mousehole, smith 0
5354023 2461321 2461321 defendant Caunt Thomas smith 590689 590689 Caunt, Thomas, of Mousehole, smith 1
5362043 2463794 2463794 defendant Rodmowe Thomas fisher 590689 590689 Rodmowe, Thomas, of Mousehole, fisher 1
5456725 2491935 2491935 defendant Vyghan Thomas mariner 590689 590689 Vyghan, Thomas, of Mousehole, mariner 1
5456727 2491935 2491935 defendant John Benedict mariner 590689 590689 John, Benedict, of Mousehole, mariner 3
5462807 2493785 2493785 defendant Cokke Michael shoemaker 590689 590689 Cokke, Michael, of Mousehole, shoemaker 0
5612823 2547769 2547769 plaintiff Clerc John   590689 590689 Clerc, John, of Mousehole 0
5634145 2554665 2554665 defendant Markowe John miller 590689 590689 Markowe, John, of Mousehole, miller 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);