names

68 rows where place_id = 591135

✎ 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
3603434 1868740 1868740 defendant Hylson John husbandman 591135 591135 Hylson, John, of Dokkyng, husbandman 3
3605146 1869273 1869273 defendant Owton Robert husbandman 591135 591135 Owton, Robert, of Dokkyng, husbandman 0
3676050 1918543 1918543 defendant Hypgame John husbandman 591135 591135 Hypgame, John, of Dokkyng, husbandman 4
3707186 1928538 1928538 defendant Aleyn Edmund, senior husbandman 591135 591135 Aleyn, Edmund, senior, of Dokkyng, husbandman 0
3707187 1928538 1928538 defendant Aleyn Edmund, junior husbandman 591135 591135 Aleyn, Edmund, junior, of Dokkyng, husbandman 1
3736016 1937506 1937506 defendant Barker William husbandman 591135 591135 Barker, William, of Dokkyng, husbandman 0
3783684 1952659 1952659 defendant Aleyn Edmund husbandman 591135 591135 Aleyn, Edmund, of Dokkyng, husbandman 0
3867905 1979497 1979497 defendant Crasshe John   591135 591135 Crasshe, John, of Dokkyng, shepherd 2
3880807 1983849 1983849 defendant Crashehill Robert husbandman 591135 591135 Crashehill, Robert, of Dokkyng, husbandman 1
3891174 1987313 1987313 defendant Oghton Roger   591135 591135 Oghton, Roger, of Dokkyng 2
3907972 1992957 1992957 defendant Crabshell Robert yeoman 591135 591135 Crabshell, Robert, of Dokkyng, yeoman 2
3912510 1994514 1994514 defendant Wandham John husbandman 591135 591135 Wandham, John, of Dokkyng, husbandman 0
3920596 1997236 1997236 defendant Lamberd William miller 591135 591135 Lamberd, William, of Dokkyng, miller 1
3920599 1997237 1997237 defendant Lamberd William miller 591135 591135 Lamberd, William, of Dokkyng, miller 1
3920602 1997238 1997238 defendant Lamberd William miller 591135 591135 Lamberd, William, of Dokkyng, miller 1
4518037 2206017 2206017 defendant Willy Robert   591135 591135 Willy, Robert, of Dokkyng, son of Nicholas 2
4597071 2230327 2230327 defendant Wyseman Walter   591135 591135 Wyseman, Walter, of Dokkyng 1
4599366 2231020 2231020 defendant Willy John   591135 591135 Willy, John, of Dokkyng 4
4639082 2242949 2242949 defendant Langham Thomas   591135 591135 Langham, Thomas, of Dokkyng 3
4644970 2244600 2244600 defendant Hunte Thomas   591135 591135 Hunte, Thomas, of Dokkyng 2
4733627 2275696 2275696 plaintiff Reyner Richard   591135 591135 Reyner, Richard, of Dokkyng, vicar 0
4746753 2279547 2279547 defendant Meyr John yeoman 591135 591135 Meyr, John, of Dokkyng, yeoman 1
4822587 2303141 2303141 plaintiff Smyth William   591135 591135 Smyth, William, of Dokkyng 1
4851934 2312040 2312040 defendant Laus of Lans William husbandman 591135 591135 Laus of Lans, William, of Dokkyng, husbandman 0
4851935 2312040 2312040 defendant Ruste John husbandman 591135 591135 Ruste, John, of Dokkyng, husbandman 1
4881138 2321009 2321009 defendant Ruste John husbandman 591135 591135 Ruste, John, of Dokkyng, husbandman 0
4881144 2321010 2321010 defendant Ruste John husbandman 591135 591135 Ruste, John, of Dokkyng, husbandman 1
4882918 2321577 2321577 plaintiff Hildesson Walter   591135 591135 Hildesson, Walter, of Dokkyng 0
4923637 2333829 2333829 defendant Smyth Geoffrey smith 591135 591135 Smyth, Geoffrey, of Dokkyng, smith 0
5080355 2380617 2380617 defendant Ferrour alias Smyth William husbandman 591135 591135 Ferrour alias Smyth, William, of Dokkyng, husbandman 0
5096722 2385479 2385479 plaintiff Stowe Robert (legal representative) 591135 591135 Stowe, Robert, of Dokkyng, executors of 0
5104466 2387734 2387734 defendant Goldyng Thomas yeoman 591135 591135 Goldyng, Thomas, of Dokkyng, yeoman 0
5115274 2390894 2390894 defendant Ferrour John yeoman 591135 591135 Ferrour, John, of Dokkyng, yeoman 0
5120795 2392513 2392513 plaintiff Stowe Robert (legal representative) 591135 591135 Stowe, Robert, of Dokkyng, yeoman, executors of 0
5233047 2425246 2425246 defendant Bocher John husbandman 591135 591135 Bocher, John, of Dokkyng, husbandman 0
5264465 2434642 2434642 defendant Breklys Bartholomew yeoman 591135 591135 Breklys, Bartholomew, of Dokkyng, yeoman 1
5264468 2434643 2434643 defendant Breklys Bartholomew yeoman 591135 591135 Breklys, Bartholomew, of Dokkyng, yeoman 1
5270513 2436475 2436475 defendant Warner John yeoman 591135 591135 Warner, John, of Dokkyng, yeoman 3
5286714 2441122 2441122 defendant Lacy Thomas husbandman 591135 591135 Lacy, Thomas, of Dokkyng, husbandman 0
5287804 2441456 2441456 defendant Ferrour John eoman 591135 591135 Ferrour, John, of Dokkyng, eoman 0
5290369 2442187 2442187 defendant Lacy Thomas yeoman 591135 591135 Lacy, Thomas, of Dokkyng, yeoman 0
5302081 2445579 2445579 defendant Warner John yeoman 591135 591135 Warner, John, of Dokkyng, yeoman 4
5303182 2445944 2445944 defendant Warner John husbandman 591135 591135 Warner, John, of Dokkyng, husbandman 1
5312812 2448861 2448861 defendant Drapur Robert clerk 591135 591135 Drapur, Robert, of Dokkyng, clerk 0
5317973 2450467 2450467 defendant Warner John, senior yeoman 591135 591135 Warner, John, senior, of Dokkyng, yeoman 0
5326038 2452880 2452880 defendant Overton John, senior husbandman 591135 591135 Overton, John, senior, of Dokkyng, husbandman 0
5347687 2459430 2459430 defendant Warner John husbandman 591135 591135 Warner, John, of Dokkyng, husbandman 6
5353396 2461141 2461141 defendant Langham John clerk 591135 591135 Langham, John, of Dokkyng, clerk 0
5353397 2461141 2461141 defendant Outlawe William husbandman 591135 591135 Outlawe, William, of Dokkyng, husbandman 1
5353398 2461141 2461141 defendant Glasewryght Robert husbandman 591135 591135 Glasewryght, Robert, of Dokkyng, husbandman 2
5354002 2461314 2461314 defendant Langham John clerk 591135 591135 Langham, John, of Dokkyng, clerk 0
5354003 2461314 2461314 defendant Outlawe William husbandman 591135 591135 Outlawe, William, of Dokkyng, husbandman 1
5354004 2461314 2461314 defendant Glasewryght Robert husbandman 591135 591135 Glasewryght, Robert, of Dokkyng, husbandman 2
5355930 2461934 2461934 defendant Warner John, senior husbandman or yeoman 591135 591135 Warner, John, senior, of Dokkyng, husbandman or yeoman 0
5355932 2461935 2461935 defendant Warner John, senior husbandman or yeoman 591135 591135 Warner, John, senior, of Dokkyng, husbandman or yeoman 0
5355934 2461936 2461936 defendant Warner John, senior husbandman or yeoman 591135 591135 Warner, John, senior, of Dokkyng, husbandman or yeoman 0
5365824 2464965 2464965 defendant Wra Thomas yeoman 591135 591135 Wra, Thomas, of Dokkyng, yeoman 0
5376815 2468342 2468342 defendant Meyer John husbandman 591135 591135 Meyer, John, of Dokkyng, husbandman 0
5394199 2473402 2473402 defendant Ferour John yeoman 591135 591135 Ferour, John, of Dokkyng, yeoman 1
5399845 2475047 2475047 defendant Ferrour John yeoman 591135 591135 Ferrour, John, of Dokkyng, yeoman 1
5446242 2488765 2488765 defendant Houghton Robert husbandman 591135 591135 Houghton, Robert, of Dokkyng, husbandman 3
5503493 2506004 2506004 defendant Ferrour John, senior yeoman 591135 591135 Ferrour, John, senior, of Dokkyng, yeoman 0
5503859 2506123 2506123 defendant Whyttacre John husbandman 591135 591135 Whyttacre, John, of Dokkyng, husbandman 0
5558250 2522362 2522362 defendant Pye Robert weaver 591135 591135 Pye, Robert, of Dokkyng, weaver 0
5561075 2523211 2523211 defendant Cure Nicholas clerk 591135 591135 Cure, Nicholas, of Dokkyng, clerk 0
5594411 2533229 2533229 defendant Mund Thomas husbandman 591135 591135 Mund, Thomas, of Dokkyng, husbandman 1
5604692 2536331 2536331 defendant Mussewyght John husbandman 591135 591135 Mussewyght, John, of Dokkyng, husbandman 2
5625825 2552024 2552024 defendant Kay John husbandman 591135 591135 Kay, John, of Dokkyng, husbandman 4

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