names

71 rows where place_id = 609540

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3678918 1919475 1919475 defendant Caryar William smith 609540 609540 Caryar, William, of Fayreford, smith 3
4299872 2130044 2130044 defendant Betterton Edmund (legal representative) 609540 609540 Betterton, Edmund, of Fayreford, innholder, executor of 0
4299873 2130044 2130044 defendant Betterton John yeoman 609540 609540 Betterton, John, of Fayreford, yeoman 1
4309616 2133523 2133523 defendant Fant John tanner 609540 609540 Fant, John, of Fayreford, tanner 0
4309618 2133523 2133523 defendant Arden Virgil mercer 609540 609540 Arden, Virgil, of Fayreford, mercer 2
4320608 2137300 2137300 defendant Betterton Alexander yeoman 609540 609540 Betterton, Alexander, of Fayreford, yeoman 0
4320609 2137300 2137300 defendant Betterton Christopher yeoman 609540 609540 Betterton, Christopher, of Fayreford, yeoman 1
4320610 2137300 2137300 defendant Fant John yeoman 609540 609540 Fant, John, of Fayreford, yeoman 2
4320622 2137303 2137303 defendant Tracye John   609540 609540 Tracye, John, of Fayreford, knight 0
4364783 2152458 2152458 defendant Ferrys Walter yeoman 609540 609540 Ferrys, Walter, of Fayreford, warrener, or of Marston Meysie, Wilts, yeoman 0
4364784 2152458 2152458 defendant Cull John husbandman 609540 609540 Cull, John, of Fayreford, husbandman 1
4367815 2153540 2153540 defendant Collis John husbandman 609540 609540 Collis, John, of Fayreford, husbandman 0
4442783 2182699 2182699 defendant atte Welle John   609540 609540 atte Welle, John, of Fayreford 1
4442785 2182699 2182699 defendant Gille Thomas   609540 609540 Gille, Thomas, of Fayreford 3
4573480 2223232 2223232 defendant Wattes Thomas   609540 609540 Wattes, Thomas, of Fayreford 0
4617622 2236520 2236520 defendant Forbour Thomas   609540 609540 Forbour, Thomas, of Fayreford 0
4617624 2236521 2236521 defendant Kynny John   609540 609540 Kynny, John, of Fayreford 0
4631226 2240665 2240665 plaintiff Tame John   609540 609540 Tame, John, of Fayreford 0
4634126 2241516 2241516 defendant Taskere John   609540 609540 Taskere, John, of Fayreford 2
4662938 2249871 2249871 defendant Hayle Richard cordwainer 609540 609540 Hayle, Richard, of Fayreford, cordwainer 3
4671715 2256799 2256799 defendant Elmes William chaplain 609540 609540 (Elmes, William, of Fayreford, chaplain 1
4672783 2257128 2257128 defendant Hayle Richard shoemaker 609540 609540 Hayle, Richard, of Fayreford, shoemaker 0
4672858 2257153 2257153 plaintiff Cook William   609540 609540 Cook, William, of Fayreford 0
4688284 2261904 2261904 defendant Lambard Thomas butcher 609540 609540 Lambard, Thomas, of Fayreford, butcher 0
4722622 2272392 2272392 plaintiff Compton Wiliam   609540 609540 Compton, Wiliam, of Fayreford 0
4749832 2280425 2280425 defendant Baron Thomas husbandman 609540 609540 Baron, Thomas, of Fayreford, husbandman 0
4750202 2280535 2280535 defendant Barton Thomas husbandman 609540 609540 Barton, Thomas, of Fayreford, husbandman 0
4750203 2280535 2280535 defendant Fourbour Thomas shoemaker 609540 609540 Fourbour, Thomas, of Fayreford, shoemaker 1
4752461 2281182 2281182 plaintiff Tannere William   609540 609540 Tannere, William, of Fayreford, on his own account 0
4765291 2285127 2285127 defendant Baron Thomas husbandman 609540 609540 Baron, Thomas, of Fayreford, husbandman 0
4777840 2289059 2289059 defendant Hayle Richard cordwainer 609540 609540 Hayle, Richard, of Fayreford, cordwainer 3
4789466 2292772 2292772 defendant Baron Thomas husbandman 609540 609540 Baron, Thomas, of Fayreford, husbandman 0
4800461 2296327 2296327 defendant Tame John woolmonger 609540 609540 Tame, John, of Fayreford, woolmonger 0
4803389 2297251 2297251 defendant Baret William glvoer 609540 609540 Baret, William, of Fayreford, glvoer 2
4803390 2297251 2297251 defendant Baker Thomas glover 609540 609540 Baker, Thomas, of Fayreford, glover 3
4823477 2303431 2303431 defendant Sefger John   609540 609540 Sefger, John, of Fayreford, seve maker 2
4824320 2303670 2303670 defendant Pavy Thomas husbandman 609540 609540 Pavy, Thomas, of Fayreford, husbandman 1
4831796 2305964 2305964 defendant Pavy Thomas husbandman 609540 609540 Pavy, Thomas, of Fayreford, husbandman 0
4858221 2313942 2313942 defendant Pavy Thomas husbandman 609540 609540 Pavy, Thomas, of Fayreford, husbandman 0
4938116 2338301 2338301 defendant Wattes Thomas husbandman 609540 609540 Wattes, Thomas, of Fayreford, husbandman 1
4952435 2342687 2342687 defendant Tyler Thomas tiler 609540 609540 Tyler, Thomas, of Fayreford, tiler 1
4955441 2343588 2343588 defendant Baroun Thomas husbandman 609540 609540 Baroun, Thomas, of Fayreford, husbandman 0
4955443 2343589 2343589 defendant Baroun Thomas husbandman 609540 609540 Baroun, Thomas, of Fayreford, husbandman 0
4969801 2347914 2347914 defendant Tame John gent 609540 609540 Tame, John, of Fayreford, gent 1
4974268 2349267 2349267 defendant Martyn John   609540 609540 Martyn, John, of Fayreford, millward 1
4974372 2349299 2349299 defendant Martyn John   609540 609540 Martyn, John, of Fayreford, millward 2
4980997 2351248 2351248 defendant Tame John husbandman 609540 609540 Tame, John, of Fayreford, husbandman 0
4987349 2353166 2353166 plaintiff Whithed Richard   609540 609540 Whithed, Richard, of Fayreford, vicar 1
4988191 2353439 2353439 defendant Martyn John miller 609540 609540 Martyn, John, of Fayreford, miller 4
4988192 2353439 2353439 defendant Tayllour John chaplain 609540 609540 Tayllour, John, of Fayreford, chaplain 5
4988193 2353439 2353439 defendant Penne Abel laborer 609540 609540 Penne, Abel, of Fayreford, laborer 6
4988194 2353439 2353439 defendant Lecchelawe Thomas   609540 609540 Lecchelawe, Thomas, of Fayreford, parish clerk 7
5012109 2360391 2360391 defendant Tame John yeoman 609540 609540 Tame, John, of Fayreford, yeoman 0
5026313 2364586 2364586 defendant Tame John gent 609540 609540 Tame, John, of Fayreford, gent 0
5042383 2369331 2369331 defendant Sclater Roger slater 609540 609540 Sclater, Roger, of Fayreford, slater 0
5043723 2369746 2369746 defendant Tame John gent 609540 609540 Tame, John, of Fayreford, gent 0
5056140 2373412 2373412 defendant Galpyn Richard (legal representative) 609540 609540 Galpyn, Richard, of Fayreford, husbandman, executor of 1
5056141 2373412 2373412 defendant Galpyn Thomas husbandman 609540 609540 Galpyn, Thomas, of Fayreford, husbandman 2
5064467 2375911 2375911 defendant Tame John, senior gent 609540 609540 Tame, John, senior, of Fayreford, gent 4
5064471 2375913 2375913 defendant Tame John gent 609540 609540 Tame, John, of Fayreford, gent 0
5071486 2377968 2377968 defendant Sclater Roger slater 609540 609540 Sclater, Roger, of Fayreford, slater 0
5071553 2377988 2377988 defendant Tame John husbandman 609540 609540 Tame, John, of Fayreford, husbandman 0
5073993 2378708 2378708 defendant Tame John gent 609540 609540 Tame, John, of Fayreford, gent 0
5134182 2396491 2396491 defendant Burgeys William husbandman 609540 609540 Burgeys, William, of Fayreford, husbandman 0
5260666 2433461 2433461 defendant Taylour Lewis tailor 609540 609540 Taylour, Lewis, of Fayreford, tailor 2
5266179 2435173 2435173 defendant Boteler John yeoman 609540 609540 Boteler, John, of Fayreford, yeoman 0
5266181 2435174 2435174 defendant Boteler John yeoman 609540 609540 Boteler, John, of Fayreford, yeoman 0
5275879 2438016 2438016 plaintiff Tame John   609540 609540 Tame, John, of Fayreford 0
5370582 2466387 2466387 defendant Hurdylston William yeoman 609540 609540 Hurdylston, William, of Fayreford, yeoman 2
5516571 2510013 2510013 plaintiff Tame John esq 609540 609540 Tame, John, of Fayreford, esq 0
5615648 2548683 2548683 defendant Martyn Nicholas   609540 609540 Martyn, Nicholas, of Fayreford 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);