names

42 rows where place_id = 606636

✎ 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
3665972 1915291 1915291 defendant Goodhewe Richard husbandman 606636 606636 Goodhewe, Richard, of Farnyngham, husbandman 0
3665973 1915291 1915291 defendant Goodhewe Julia widow 606636 606636 Goodhewe, Julia, of Farnyngham, widow 1
3665976 1915292 1915292 defendant Goodhewe Richard husbandman 606636 606636 Goodhewe, Richard, of Farnyngham, husbandman 1
3665977 1915292 1915292 defendant Goodhewe Julia widow 606636 606636 Goodhewe, Julia, of Farnyngham, widow 2
3666581 1915486 1915486 plaintiff Ussher alias Phillip William skinner 606636 606636 Ussher alias Phillip, William, of Farnyngham, skinner 0
3666583 1915487 1915487 plaintiff Ussher alias Phillip William skinner 606636 606636 Ussher alias Phillip, William, of Farnyngham, skinner 0
3666584 1915487 1915487 defendant Wryxham John   606636 606636 Wryxham, John, of Farnyngham, vicar 0
3673184 1917626 1917626 defendant Taillour Richard innholder 606636 606636 Taillour, Richard, of Farnyngham, innholder 1
3681007 1920138 1920138 plaintiff Sebyll Thomas (legal representative) 606636 606636 Sebyll, Thomas, of Farnyngham, gent, executrix of 0
3682994 1920795 1920795 defendant Sybyll Nicholas gent 606636 606636 Sybyll, Nicholas, of Farnyngham, gent 0
3688163 1922448 1922448 defendant Taylor John clothier 606636 606636 Taylor, John, of Farnyngham, clothier 0
3694446 1924468 1924468 defendant Tayllour John clothmaker 606636 606636 Tayllour, John, of Farnyngham, clothmaker 0
3707798 1928737 1928737 defendant Tayler John yeoman 606636 606636 Tayler, John, of Farnyngham, yeoman 3
3707801 1928738 1928738 defendant Jetour Walter clothier 606636 606636 Jetour, Walter, of Farnyngham, clothier 1
3732950 1936528 1936528 defendant Taylour Nicholas yeoman 606636 606636 Taylour, Nicholas, of Farnyngham, yeoman 1
3734176 1936929 1936929 defendant Hodsole Nicholas innholder 606636 606636 Hodsole, Nicholas, of Farnyngham, innholder 3
3754295 1943295 1943295 defendant Notte Richard smith 606636 606636 Notte, Richard, of Farnyngham, smith 0
3754333 1943311 1943311 defendant Nott Richard smith 606636 606636 Nott, Richard, of Farnyngham, smith 0
3754339 1943314 1943314 defendant Taylour John yeoman 606636 606636 Taylour, John, of Farnyngham, yeoman 0
3755644 1943721 1943721 defendant Wales Richard husbandman 606636 606636 Wales, Richard, of Farnyngham, husbandman 0
3763300 1946153 1946153 defendant Wales Richard husbandman 606636 606636 Wales, Richard, of Farnyngham, husbandman 0
3767332 1947427 1947427 defendant Walys Richard husbandman 606636 606636 Walys, Richard, of Farnyngham, husbandman 2
3791472 1955168 1955168 defendant Overey John innholder 606636 606636 Overey, John, of Farnyngham, innholder 0
3799193 1957658 1957658 defendant Stone John tailor 606636 606636 Stone, John, of Farnyngham, tailor 1
3801284 1958326 1958326 defendant Barry John laborer 606636 606636 Barry, John, of Farnyngham, laborer 1
3802809 1958775 1958775 defendant Hamlyn Richard husbandman 606636 606636 Hamlyn, Richard, of Farnyngham, husbandman 0
3803517 1959006 1959006 defendant Gybson alias Tayler John yeoman 606636 606636 Gybson alias Tayler, John, of Farnyngham, yeoman 0
3820905 1964434 1964434 defendant Gybson John yeoman 606636 606636 Gybson, John, of Farnyngham, yeoman 0
3842433 1971168 1971168 defendant Goodewe Richard husbandman 606636 606636 Goodewe, Richard, of Farnyngham, husbandman 0
3848764 1973198 1973198 defendant Notte Richard smith 606636 606636 Notte, Richard, of Farnyngham, smith 2
3864419 1978296 1978296 defendant Andrewe John husbandman 606636 606636 Andrewe, John, of Farnyngham, husbandman 0
3864420 1978296 1978296 defendant Geter Richard husbandman 606636 606636 Geter, Richard, of Farnyngham, husbandman 1
3864421 1978296 1978296 defendant Hambyn Richard husbandman 606636 606636 Hambyn, Richard, of Farnyngham, husbandman 2
3923523 1998176 1998176 defendant Blakman William husbandman 606636 606636 Blakman, William, of Farnyngham, husbandman 0
4082560 2054066 2054066 defendant Nott John yeoman 606636 606636 Nott, John, of Farnyngham, or of Canterbury, yeoman 1
4172278 2085769 2085769 defendant Lease John husbandman 606636 606636 Lease, John, of Farnyngham, husbandman 2
4172279 2085769 2085769 defendant Best Joan widow 606636 606636 Best, Joan, of Farnyngham, widow 3
4333187 2141387 2141387 defendant Caryer Elias blacksmith 606636 606636 Caryer, Elias, of Farnyngham, blacksmith 0
4382646 2158902 2158902 defendant Best John innholder 606636 606636 Best, John, of Farnyngham, innholder 0
4656470 2247920 2247920 defendant Jolyf John cooper 606636 606636 Jolyf, John, of Farnyngham, cooper 0
5372831 2467105 2467105 defendant Crosse William husbandman 606636 606636 Crosse, William, of Farnyngham, husbandman 0
5454559 2491278 2491278 defendant Crosse John husbandman 606636 606636 Crosse, John, of Farnyngham, husbandman 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);