names

59 rows where place_id = 595151

✎ 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
3619144 1873591 1873591 defendant Hyll William husbandman 595151 595151 Hyll, William, of Felton, husbandman 0
3638312 1906800 1906800 defendant Hoskyn Richard husbandman 595151 595151 Hoskyn, Richard, of Felton, husbandman 0
3755702 1943743 1943743 defendant Crompe John laborer 595151 595151 Crompe, John, of Felton, laborer 0
3811880 1961619 1961619 defendant Lacy Robert esq 595151 595151 Lacy, Robert, of Felton, esq 0
3834011 1968578 1968578 defendant Mason James husbandman 595151 595151 Mason, James, of Felton, husbandman 3
3839288 1970217 1970217 defendant Hoskyns Richard husbandman 595151 595151 Hoskyns, Richard, of Felton, husbandman 0
3847137 1972657 1972657 defendant Ballard Thomas carpenter 595151 595151 Ballard, Thomas, of Felton, carpenter 0
3854309 1974985 1974985 defendant Hart Thomas husbandman 595151 595151 Hart, Thomas, of Felton, husbandman 0
3950210 2007158 2007158 plaintiff Frary Christopher husbandman 595151 595151 Frary, Christopher, of Felton, husbandman 0
3952576 2007970 2007970 defendant Felton Robert yeoman 595151 595151 Felton, Robert, of Felton, yeoman 1
3971332 2014531 2014531 defendant Byll Richard yeoman 595151 595151 Byll, Richard, of Felton, yeoman 1
3971333 2014531 2014531 defendant ap Edward John Griggith yeoman 595151 595151 ap Edward, John Griggith, of Felton, yeoman 2
3971334 2014531 2014531 defendant ap Richard John yeoman 595151 595151 ap Richard, John, of Felton, yeoman 3
3995002 2022958 2022958 defendant Burghyll William gent 595151 595151 Burghyll, William, of Felton, gent 0
3995004 2022958 2022958 defendant Pytt Anne widow 595151 595151 Pytt, Anne, of Felton, widow 2
4039310 2038689 2038689 defendant Lysley Robert gent 595151 595151 Lysley, Robert, of Felton, gent 0
4039311 2038689 2038689 defendant Lysley John yeoman 595151 595151 Lysley, John, of Felton, yeoman 1
4039318 2038690 2038690 defendant Lysley Robert gent 595151 595151 Lysley, Robert, of Felton, gent 0
4039319 2038690 2038690 defendant Lysley John yeoman 595151 595151 Lysley, John, of Felton, yeoman 1
4053489 2043624 2043624 defendant Gitten Roger yeoman 595151 595151 Gitten, Roger, of Felton Butler, yeoman 1
4061937 2046668 2046668 defendant Moore John tailor 595151 595151 Moore, John, of Felton, tailor 0
4065101 2047805 2047805 defendant Huddye Simon gent 595151 595151 Huddye, Simon, of Felton, gent 0
4066932 2048470 2048470 defendant ap Richard John husbandman 595151 595151 ap Richard, John, of Felton, husbandman 0
4083149 2054262 2054262 defendant Moore John tailor 595151 595151 Moore, John, of Felton, tailor 2
4088274 2056101 2056101 defendant Lockwood William husbandman 595151 595151 Lockwood, William, of Felton, husbandman 3
4093198 2057884 2057884 defendant More John tailor 595151 595151 More, John, of Felton, tailor 0
4116419 2066162 2066162 defendant More John tailor 595151 595151 More, John, of Felton, tailor 0
4160438 2081726 2081726 defendant Wylde John husbandman 595151 595151 Wylde, John, of Felton Butler, husbandman 6
4294558 2128140 2128140 defendant Prigge John   595151 595151 Prigge, John, of Felton, Glos yeoman 0
4331912 2140968 2140968 defendant White James yeoman 595151 595151 White, James, of Felton, yeoman 0
4427223 2173343 2173343 plaintiff Rofe Thomas   595151 595151 Rofe, Thomas, of Felton 0
4428172 2173642 2173642 defendant Morpath John de   595151 595151 Morpath, John de, of Felton 2
4452080 2185639 2185639 plaintiff Iford John   595151 595151 Iford, John, of Felton 0
4452083 2185639 2185639 defendant Hore Robert   595151 595151 Hore, Robert, of Felton 2
4452086 2185639 2185639 defendant Williames John   595151 595151 Williames, John, of Felton 5
4528607 2209227 2209227 defendant Thorp John de   595151 595151 Thorp, John de, of Felton 0
4587548 2227509 2227509 defendant atte Welle Thomas   595151 595151 atte Welle, Thomas, of Felton 0
4587549 2227509 2227509 defendant Coke Robert   595151 595151 Coke, Robert, of Felton 1
4649964 2246007 2246007 defendant Orchard John   595151 595151 Orchard, John, of Felton 3
4679259 2259121 2259121 defendant Lucas Hugh clerk 595151 595151 Lucas, Hugh, of Felton, clerk 0
4690448 2262574 2262574 defendant Salesbury Lawrence weaver 595151 595151 Salesbury, Lawrence, of Felton, weaver 0
4759045 2283181 2283181 defendant Felton Robert yeoman 595151 595151 Felton, Robert, of Felton, yeoman 1
4782069 2290392 2290392 defendant Bokelond Thomas husbandman 595151 595151 Bokelond, Thomas, of Felton, husbandman 0
4832188 2306098 2306098 defendant Bussh Nicholas laborer 595151 595151 Bussh, Nicholas, of Felton, laborer 1
4840113 2308454 2308454 defendant Brome Thomas farmer 595151 595151 Brome, Thomas, of Felton, farmer 1
4857733 2313797 2313797 defendant Hasand Thomas yeoman 595151 595151 Hasand, Thomas, of Felton, yeoman 0
4934881 2337311 2337311 defendant Forster Adam yeoman 595151 595151 Forster, Adam, of Felton, yeoman 0
5006317 2358744 2358744 defendant Taillour Roger   595151 595151 Taillour, Roger, of Felton, vicar 0
5008556 2359397 2359397 defendant Taillour John husbandman 595151 595151 Taillour, John, of Felton Boteler, husbandman 2
5014518 2361109 2361109 plaintiff Benette Thomas, junior husbandman 595151 595151 Benette, Thomas, junior, of Felton, husbandman 0
5067073 2376676 2376676 defendant Hygons John husbandman 595151 595151 Hygons, John, of Felton, husbandman 0
5067074 2376676 2376676 defendant Fissher Agnes widow 595151 595151 Fissher, Agnes, of Felton, widow 1
5126222 2394153 2394153 defendant Rylbury Robert   595151 595151 Rylbury, Robert, of Felton 0
5531270 2514296 2514296 defendant Holder John husbandman 595151 595151 Holder, John, of Felton, husbandman 2
5543209 2517994 2517994 defendant Aldham John yeoman 595151 595151 Aldham, John, of Felton, yeoman 0
5543214 2517996 2517996 defendant Aldam John yeoman 595151 595151 Aldam, John, of Felton, yeoman 1
5578726 2528407 2528407 defendant Hoell alias Playne Geoffrey carpenter 595151 595151 Hoell alias Playne, Geoffrey, of Felton, carpenter 0
5597980 2534269 2534269 defendant Masser John husbandman 595151 595151 Masser, John, of Felton, husbandman 0
5606179 2536822 2536822 defendant Hoskyn Richard husbandman 595151 595151 Hoskyn, Richard, of Felton, husbandman 3

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