names

67 rows where place_id = 588240

✎ 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
3593817 1865706 1865706 defendant Botyld Thomas husbandman 588240 588240 Botyld, Thomas, of Waketon, husbandman 3
3599140 1867367 1867367 defendant Botyld Thomas husbandman 588240 588240 Botyld, Thomas, of Waketon, husbandman 0
3607704 1870063 1870063 defendant Norman William yeoman 588240 588240 Norman, William, of Waketon, yeoman 1
3607705 1870063 1870063 defendant Dannok Nicholas husbandman 588240 588240 Dannok, Nicholas, of Waketon, husbandman 2
3785279 1953183 1953183 defendant Danok Nicholas yeoman 588240 588240 Danok, Nicholas, of Waketon, yeoman 1
3858234 1976231 1976231 defendant Davys Thomas husbandman 588240 588240 Davys, Thomas, of Waketon, husbandman 0
3881620 1984113 1984113 defendant Kene Alice   588240 588240 Kene, Alice, of Waketon, widow of Kene, Richard 0
3904030 1991590 1991590 defendant Ponyard John husbandman 588240 588240 Ponyard, John, of Waketon, husbandman 0
4595190 2229748 2229748 defendant Dennok Simon   588240 588240 Dennok, Simon, of Waketon 9
4654648 2247333 2247333 defendant Mannyng Edmund laborer 588240 588240 Mannyng, Edmund, of Waketon, laborer 1
4654649 2247333 2247333 defendant Mannyng Alexander husbandman 588240 588240 Mannyng, Alexander, of Waketon, husbandman 2
4665017 2250539 2250539 defendant Dennok Simon husbandman 588240 588240 Dennok, Simon, of Waketon, husbandman 0
4724904 2273081 2273081 defendant Dannok Simon   588240 588240 Dannok, Simon, of Waketon, bailiff 2
4732421 2275314 2275314 defendant Dannok Simon smith 588240 588240 Dannok, Simon, of Waketon, smith 0
4732423 2275314 2275314 defendant Norman William smith 588240 588240 Norman, William, of Waketon, smith 2
4732424 2275314 2275314 defendant Drake John laborer 588240 588240 Drake, John, of Waketon, laborer 3
4744865 2279015 2279015 defendant Dannok Simon   588240 588240 Dannok, Simon, of Waketon, bailiff 4
4759777 2283394 2283394 defendant Dannok Simon   588240 588240 Dannok, Simon, of Waketon, bailiff 3
4804354 2297548 2297548 defendant Parmenter Thomas yeoman 588240 588240 Parmenter, Thomas, of Waketon, yeoman 0
4818921 2302003 2302003 plaintiff Parmonter Thomas   588240 588240 Parmonter, Thomas, of Waketon 0
4856146 2313293 2313293 defendant Parmenter John yeoman 588240 588240 Parmenter, John, of Waketon, yeoman 0
4856147 2313293 2313293 defendant Parmenter Thomas   588240 588240 Parmenter, Thomas, of Waketon, yeoman, his brother 1
4993092 2354817 2354817 defendant Drake Thomas yeoman 588240 588240 Drake, Thomas, of Waketon, single man, yeoman 0
5030102 2365675 2365675 defendant Drake Nicholas yeoman 588240 588240 Drake, Nicholas, of Waketon, yeoman 2
5050209 2371683 2371683 defendant Drake Thomas gent 588240 588240 Drake, Thomas, of Waketon, gent 1
5057151 2373719 2373719 defendant Drake Nicholas yeoman 588240 588240 Drake, Nicholas, of Waketon, yeoman 1
5059495 2374410 2374410 plaintiff Elyot John clerk 588240 588240 Elyot, John, of Waketon, clerk 0
5064065 2375786 2375786 defendant Mannyng Robert husbandman 588240 588240 Mannyng, Robert, of Waketon, husbandman 0
5067938 2376908 2376908 defendant Elyot John clerk 588240 588240 Elyot, John, of Waketon, clerk 0
5074239 2378783 2378783 defendant Batyld John yeoman 588240 588240 Batyld, John, of Waketon, yeoman 0
5077432 2379749 2379749 defendant Drake Nicholas yeoman 588240 588240 Drake, Nicholas, of Waketon, yeoman 0
5120805 2392515 2392515 defendant Florence William yeoman 588240 588240 Florence, William, of Waketon, yeoman 4
5144757 2399621 2399621 defendant Drake Nicholas yeoman 588240 588240 Drake, Nicholas, of Waketon, yeoman 1
5165462 2405643 2405643 defendant Drake Nicholas yeoman 588240 588240 Drake, Nicholas, of Waketon, yeoman 1
5182362 2410596 2410596 defendant Drake Nicholas yeoman 588240 588240 Drake, Nicholas, of Waketon, yeoman 0
5182363 2410596 2410596 defendant Drake Walter husbandman 588240 588240 Drake, Walter, of Waketon, husbandman 1
5182366 2410597 2410597 defendant Drake Walter husbandman 588240 588240 Drake, Walter, of Waketon, husbandman 1
5184155 2411105 2411105 defendant Goldsmyth William husbandman 588240 588240 Goldsmyth, William, of Waketon, husbandman 0
5192533 2413549 2413549 defendant Drake Nichoals yeoman 588240 588240 Drake, Nichoals, of Waketon, yeoman 0
5199997 2415754 2415754 defendant Drake Nicholas yeoman 588240 588240 Drake, Nicholas, of Waketon, yeoman 0
5277863 2438613 2438613 defendant Drake Thomas husbandman 588240 588240 Drake, Thomas, of Waketon, husbandman 0
5287183 2441270 2441270 defendant Bellamy Robert clerk 588240 588240 Bellamy, Robert, of Waketon, clerk 1
5296316 2443913 2443913 defendant Whitefote Robert husbandman 588240 588240 Whitefote, Robert, of Waketon, husbandman 0
5318113 2450507 2450507 defendant Drake Thomas husbandman 588240 588240 Drake, Thomas, of Waketon, husbandman 0
5320708 2451288 2451288 defendant Stevenson John gent 588240 588240 Stevenson, John, of Waketon, gent 1
5320714 2451289 2451289 defendant Stevenson John gent 588240 588240 Stevenson, John, of Waketon, gent 1
5325216 2452632 2452632 plaintiff Sarys Nicholas   588240 588240 Sarys, Nicholas, of Waketon 0
5325220 2452633 2452633 plaintiff Sarys Nicholas   588240 588240 Sarys, Nicholas, of Waketon 0
5325224 2452634 2452634 plaintiff Sarys Nicholas   588240 588240 Sarys, Nicholas, of Waketon 0
5331815 2454595 2454595 defendant Botild Thomas   588240 588240 Botild, Thomas, of Waketon 0
5331816 2454595 2454595 defendant Saers Nicholas yeoman 588240 588240 Saers, Nicholas, of Waketon, yeoman 1
5354996 2461632 2461632 defendant Botyld Robert husbandman 588240 588240 Botyld, Robert, of Waketon, husbandman 0
5376248 2468165 2468165 plaintiff Sarys Nicholas   588240 588240 Sarys, Nicholas, of Waketon 0
5378056 2468715 2468715 defendant Botyldy Thomas husbandman 588240 588240 Botyldy, Thomas, of Waketon, husbandman 0
5391875 2472753 2472753 plaintiff Randolf John   588240 588240 Randolf, John, of Waketon 0
5392861 2473032 2473032 defendant Boteld Thomas yeoman 588240 588240 Boteld, Thomas, of Waketon, yeoman 0
5405980 2476784 2476784 defendant Boteld Thomas yyeoman 588240 588240 Boteld, Thomas, of waketon,yyeoman 0
5405984 2476785 2476785 defendant Botell Thomas yeoman 588240 588240 Botell, Thomas, of Waketon, yeoman 0
5419007 2480612 2480612 defendant Boteld Thomas yeoman 588240 588240 Boteld, Thomas, of Waketon, yeoman 0
5428306 2483392 2483392 defendant Botyld Thomas yeoman 588240 588240 Botyld, Thomas, of Waketon, yeoman 0
5458446 2492419 2492419 defendant Botyld Thomas yeoman 588240 588240 Botyld, Thomas, of Waketon, yeoman 0
5505661 2506691 2506691 defendant Goode Thomas husbandman 588240 588240 Goode, Thomas, of Waketon, husbandman 0
5505662 2506691 2506691 defendant Ambeler John husbandman 588240 588240 Ambeler, John, of Waketon, husbandman 1
5514290 2509321 2509321 plaintiff Randold John   588240 588240 Randold, John, of Waketon, administrators of 0
5522589 2511889 2511889 defendant Norman alias Labile William yeoman 588240 588240 Norman alias Labile, William, of Waketon, yeoman 0
5568340 2525285 2525285 defendant Meer William husbandman 588240 588240 Meer, William, of Waketon, husbandman 0
5609345 2537822 2537822 plaintiff Randolf John   588240 588240 Randolf, John, of Waketon 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);