names

66 rows where place_id = 591057

✎ 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
3603168 1868655 1868655 defendant Hernden James innholder 591057 591057 Hernden, James, of Crambroke, innholder 0
3606517 1869710 1869710 defendant Jury Richard   591057 591057 Jury, Richard, of Crambroke, mason 1
3608808 1870415 1870415 defendant Holstokke Robert clothier 591057 591057 Holstokke, Robert, of Crambroke, clothier 1
3608809 1870415 1870415 defendant Carkeregge John yeoman 591057 591057 Carkeregge, John, of Crambroke, yeoman 2
3622017 1874427 1874427 defendant Rychard Thomas butcher 591057 591057 Rychard, Thomas, of Crambroke, butcher 3
3627650 1903506 1903506 defendant Lorker William wheeler 591057 591057 Lorker, William, of Crambroke, wheeler 0
3675117 1918247 1918247 defendant Bassok John fuller 591057 591057 Bassok, John, of Crambroke, fuller 0
3691803 1923597 1923597 defendant Grene William (legal representative) 591057 591057 Grene, William, of Crambroke, clothier, executrix of 1
3726277 1934487 1934487 defendant Chetynden Richard clothier 591057 591057 Chetynden, Richard, of Crambroke, clothier 1
3726278 1934487 1934487 defendant Post John clothier 591057 591057 Post, John, of Crambroke, clothier 2
3726279 1934487 1934487 defendant Bysshopp John clothier 591057 591057 Bysshopp, John, of Crambroke, clothier 3
3822964 1965090 1965090 defendant Taylor Richard clothier 591057 591057 Taylor, Richard, of Crambroke, clothier 1
3847494 1972781 1972781 plaintiff Henley Gervase, senior (legal representative) 591057 591057 Henley, Gervase, senior, of Crambroke, executor of 0
3852109 1974256 1974256 defendant Carkerege Lawrence brewer 591057 591057 Carkerege, Lawrence, of Crambroke, brewer 0
3904659 1991813 1991813 defendant Colyour Roger yeoman 591057 591057 Colyour, Roger, of Crambroke, yeoman 2
3946017 2005683 2005683 defendant Rayner Robert yeoman 591057 591057 Rayner, Robert, of Crambroke, yeoman 1
3953722 2008376 2008376 defendant Curtoppe Richard clothier 591057 591057 Curtoppe, Richard, of Crambroke, clothier 1
3958424 2010018 2010018 defendant Cocheman Stphen clothier 591057 591057 Cocheman, Stphen, of Crambroke, clothier 0
3958425 2010018 2010018 defendant Bygg Richard yeoman 591057 591057 Bygg, Richard, of Crambroke, yeoman 1
3958534 2010054 2010054 defendant Bysshop John clothier 591057 591057 Bysshop, John, of Crambroke, clothier 0
3958536 2010054 2010054 defendant Philip Thomas sherman 591057 591057 Philip, Thomas, of Crambroke, sherman 2
3958538 2010055 2010055 defendant Mansell Thomas yeoman 591057 591057 Mansell, Thomas, of Crambroke, yeoman 0
3959293 2010329 2010329 defendant Warren Peter yeoman 591057 591057 Warren, Peter, of Crambroke, yeoman 0
3959294 2010329 2010329 defendant Freman John yeoman 591057 591057 Freman, John, of Crambroke, yeoman 1
3960922 2010918 2010918 defendant Smersall John yeoman 591057 591057 Smersall, John, of Crambroke, yeoman 0
3962085 2011320 2011320 defendant Foster Robert yeoman 591057 591057 Foster, Robert, of Crambroke, yeoman 0
3963049 2011674 2011674 defendant Wynter Edmund gent 591057 591057 Wynter, Edmund, of Crambroke, or of Chartham, Kent, gent 0
3986610 2019949 2019949 defendant Davye Stephen mercer 591057 591057 Davye, Stephen, of Crambroke, mercer 1
3991344 2021658 2021658 defendant Scotcheford James clothier 591057 591057 Scotcheford, James, of Crambroke, clothier 0
3995372 2023088 2023088 plaintiff Cowcheman Richard clothier 591057 591057 Cowcheman, Richard, of Crambroke, clothier 0
4012515 2029197 2029197 defendant Wyllyams Richard   591057 591057 Wyllyams, Richard, of Crambroke, pack carrier 1
4013338 2029504 2029504 defendant Page William chapman 591057 591057 Page, William, of Crambroke, chapman 1
4028730 2034925 2034925 plaintiff Cowcheman John clothier 591057 591057 Cowcheman, John, of Crambroke, clothier 0
4050745 2042703 2042703 plaintiff Weller John clothier 591057 591057 Weller, John, of Crambroke, clothier 0
4050747 2042704 2042704 plaintiff Weller John clothier 591057 591057 Weller, John, of Crambroke, clothier 0
4083941 2054533 2054533 defendant Baker John esq 591057 591057 Baker, John, of Crambroke, esq 0
4160825 2081860 2081860 defendant Owed or Wood Hugh clothier 591057 591057 Owed or Wood, Hugh, of Crambroke, clothier 2
4394713 2162818 2162818 defendant Ratcliffe John yeoman 591057 591057 Ratcliffe, John, of Crambroke, yeoman 0
5324587 2452432 2452432 defendant Adcokke Robert dyer 591057 591057 Adcokke, Robert, of Crambroke, dyer 1
5329144 2453794 2453794 defendant Saynden William clothmaker 591057 591057 Saynden, William, of Crambroke, clothmaker 0
5329146 2453794 2453794 defendant Saynden John clothmaker 591057 591057 Saynden, John, of Crambroke, clothmaker 2
5329148 2453795 2453795 defendant Saynden William clothmaker 591057 591057 Saynden, William, of Crambroke, clothmaker 0
5329150 2453795 2453795 defendant Seynden John clothmaker 591057 591057 Seynden, John, of Crambroke, clothmaker 2
5329152 2453796 2453796 defendant Senden John clothmaker 591057 591057 Senden, John, of Crambroke, clothmaker 0
5329153 2453796 2453796 defendant Sendenne William clothmaker 591057 591057 Sendenne, William, of Crambroke, clothmaker 1
5350381 2460242 2460242 defendant Bassokke Ralph fuller 591057 591057 Bassokke, Ralph, of Crambroke, fuller 0
5357709 2462479 2462479 defendant Seyndon John, senior dyer 591057 591057 Seyndon, John, senior, of Crambroke, dyer 0
5357713 2462480 2462480 defendant Carkeregge Stephen dyer 591057 591057 Carkeregge, Stephen, of Crambroke, dyer 1
5362410 2463898 2463898 defendant Adcok Stephen clothmaker 591057 591057 Adcok, Stephen, of Crambroke, clothmaker 2
5478919 2498716 2498716 defendant Mapelesden John yeoman 591057 591057 Mapelesden, John, of Crambroke, yeoman 1
5513129 2508960 2508960 defendant Hamond John yeoman 591057 591057 Hamond, John, of Crambroke, yeoman 4
5514621 2509419 2509419 defendant Lynch Ralph clothmaker 591057 591057 Lynch, Ralph, of Crambroke, clothmaker 2
5547021 2519134 2519134 plaintiff Warde Robert clerk 591057 591057 Warde, Robert, of Crambroke, clerk 0
5549568 2519921 2519921 defendant Nasche William yeoman 591057 591057 Nasche, William, of Crambroke, yeoman 1
5560524 2523037 2523037 defendant Stace Peter clothman 591057 591057 Stace, Peter, of Crambroke, clothman 0
5562035 2523496 2523496 defendant Fayrwey Robert clothman 591057 591057 Fayrwey, Robert, of Crambroke, clothman 3
5563798 2524020 2524020 defendant Remyngton Robert weaver 591057 591057 Remyngton, Robert, of Crambroke, weaver 1
5563799 2524020 2524020 defendant Bratyll Thomas weaver 591057 591057 Bratyll, Thomas, of Crambroke, weaver 2
5563800 2524020 2524020 defendant Dens Richard weaver 591057 591057 Dens, Richard, of Crambroke, weaver 3
5569882 2525766 2525766 defendant Jaket Robert, senior carpenter 591057 591057 Jaket, Robert, senior, of Crambroke, carpenter 0
5569883 2525766 2525766 defendant Jaket Robert, junior carpenter 591057 591057 Jaket, Robert, junior, of Crambroke, carpenter 1
5573543 2526824 2526824 defendant Benet William butcher 591057 591057 Benet, William, of Crambroke, butcher 2
5576979 2527844 2527844 defendant Symond Richard smith 591057 591057 Symond, Richard, of Crambroke, smith 4
5584630 2530263 2530263 defendant Spencer William   591057 591057 Spencer, William, of Crambroke, clothmaker, administrators of 1
5584632 2530263 2530263 defendant Davy John clothmaker 591057 591057 Davy, John, of Crambroke, clothmaker 3
5588582 2531434 2531434 defendant Spencer William (legal representative) 591057 591057 Spencer, William, of Crambroke, clothmaker, executrix of 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);