names

78 rows where place_id = 595971

✎ 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
3622605 1874600 1874600 defendant Horner Richard baker 595971 595971 Horner, Richard, of Est Depyng, baker 0
3666437 1915454 1915454 defendant Cole John butcher 595971 595971 Cole, John, of East Depyng, butcher 0
3678066 1919184 1919184 defendant Tygh John husbandman 595971 595971 Tygh, John, of Est Depyng, husbandman 0
3697408 1925407 1925407 defendant Lyon alias Taylor William yeoman 595971 595971 Lyon alias Taylor, William, of Est Depyng, yeoman 0
3697410 1925408 1925408 defendant Lyon alias Taylor William yeoman 595971 595971 Lyon alias Taylor, William, of Est Depyng, yeoman 0
3745299 1940437 1940437 defendant Mapleton Robert yeoman 595971 595971 Mapleton, Robert, of Est Depyng, yeoman 0
3745300 1940437 1940437 defendant Sumpter William husbandman 595971 595971 Sumpter, William, of Est Depyng, husbandman 1
3745301 1940437 1940437 defendant Thakker Robert husbandman 595971 595971 Thakker, Robert, of Est Depyng, husbandman 2
3745302 1940437 1940437 defendant Pavy John husbandman 595971 595971 Pavy, John, of Est Depyng, husbandman 3
3745303 1940437 1940437 defendant Harrellode Robert husbandman 595971 595971 Harrellode, Robert, of Est Depyng, husbandman 4
3746880 1940941 1940941 defendant Mapleton Robert yeoman 595971 595971 Mapleton, Robert, of Est Depyng, yeoman 0
3752370 1942665 1942665 defendant Mapleton Robert yeoman 595971 595971 Mapleton, Robert, of Est Depyng, yeoman 0
3752371 1942665 1942665 defendant Harrewode Robert husbandman 595971 595971 Harrewode, Robert, of Est Depyng, husbandman 1
3752372 1942665 1942665 defendant Sumpter William husbandman 595971 595971 Sumpter, William, of Est Depyng, husbandman 2
3752373 1942665 1942665 defendant Thakker Robert husbandman 595971 595971 Thakker, Robert, of Est Depyng, husbandman 3
3752374 1942665 1942665 defendant Pavy John husbandman 595971 595971 Pavy, John, of Est Depyng, husbandman 4
4500547 2200792 2200792 defendant Bocher John   595971 595971 Bocher, John, of East Depyng 0
4522838 2207482 2207482 defendant Fayreman John dyer 595971 595971 Fayreman, John, of East Depyng, dyer 2
4523629 2207716 2207716 defendant Chapman Gilbert   595971 595971 Chapman, Gilbert, of East Depyng 0
4580718 2225449 2225449 defendant Barowe Thomas (legal representative) 595971 595971 Barowe, Thomas, of East Depyng, executors of 0
4602973 2232145 2232145 plaintiff Whittylbury Richard (legal representative) 595971 595971 Whittylbury, Richard, of East Depyng, parson of the church of St Guthlack, executor of 0
4604448 2232560 2232560 plaintiff Wyttilbury Richard (legal representative) 595971 595971 Wyttilbury, Richard, of East Depyng, parson of the church of St Guthlac, executor of 0
4680292 2259451 2259451 plaintiff Mustum John chaplain 595971 595971 Mustum, John, of East Depyng, chaplain 3
4728870 2274267 2274267 defendant Walger John husbandman 595971 595971 Walger, John, of East Depyng, husbandman 0
4746862 2279584 2279584 defendant Adam Robert sheerman 595971 595971 Adam, Robert, of East Depyng, sheerman 0
4746869 2279584 2279584 defendant Bedell William butcher 595971 595971 Bedell, William, of East Depyng, butcher 7
4786132 2291702 2291702 defendant Samwell John husbandman 595971 595971 Samwell, John, of Est Depyng, husbandman 0
4800696 2296400 2296400 defendant Hywe John butcher 595971 595971 Hywe, John, of Est Depyng, butcher 0
4816461 2301238 2301238 defendant Gowdelokke Robert chaplain 595971 595971 Gowdelokke, Robert, of East Depyng, chaplain 0
4831029 2305734 2305734 defendant Gudwyn John butcher 595971 595971 Gudwyn, John, of East Depyng, butcher 0
4841544 2308887 2308887 defendant Baunwell John husbandman 595971 595971 Baunwell, John, of East Depyng, husbandman 0
4843393 2309449 2309449 defendant Bank Robert   595971 595971 Bank, Robert, of East Depyng, vestment maker 0
4846456 2310398 2310398 defendant Bank Robert   595971 595971 Bank, Robert, of East Depyng, vestment maker 0
4858042 2313883 2313883 defendant Adenet John yeoman 595971 595971 Adenet, John, of Est Depyng, yeoman 4
4870989 2317902 2317902 defendant Floure Roger husbandman 595971 595971 Floure, Roger, of Est Depyng, husbandman 0
4884685 2322122 2322122 defendant Baldewyn Ralph baker 595971 595971 Baldewyn, Ralph, of Est Depyng, baker 0
4897481 2325873 2325873 defendant Pollard Nicholas husbandman 595971 595971 Pollard, Nicholas, of Est Depyng, husbandman 1
4910250 2329721 2329721 plaintiff Ruston John   595971 595971 Ruston, John, of East Depyng 3
4922691 2333509 2333509 defendant Lytster John dyer 595971 595971 Lytster, John, of East Depyng, dyer 0
4927783 2335126 2335126 defendant Dewe Richard husbandman 595971 595971 Dewe, Richard, of East Depyng, husbandman 3
4929008 2335499 2335499 defendant Brendell Stephen yeoman 595971 595971 Brendell, Stephen, of East Depyng, yeoman 2
4937186 2337998 2337998 defendant Lytster John dyer 595971 595971 Lytster, John, of Est Depyng, dyer 0
4939893 2338864 2338864 defendant Watson John yeoman 595971 595971 Watson, John, of Est Depyng, yeoman 1
4945395 2340539 2340539 defendant Wake Thomas esq 595971 595971 Wake, Thomas, of Est Depyng, esq 0
5016147 2361606 2361606 defendant Ive John husbandman 595971 595971 Ive, John, of Est Depyng, or of Langtoft, husbandman 0
5021124 2363074 2363074 defendant Body William fisher 595971 595971 Body, William, of Est Depyng, fisher 0
5092818 2384279 2384279 defendant Cokeney William fisher 595971 595971 together with Cokeney, William, of Est Depyng, fisher 1
5105792 2388140 2388140 defendant Grene John fisher 595971 595971 Grene, John, of Est Depyng, fisher 1
5112871 2390160 2390160 defendant Bere Robert   595971 595971 Bere, Robert, of Est Depyng, "fenherd" 7
5133694 2396349 2396349 defendant Morton Richard   595971 595971 Morton, Richard, of East Depyng, knight 0
5133696 2396350 2396350 defendant Morton Richard   595971 595971 Morton, Richard, of East Depyng, knight 0
5214528 2419978 2419978 defendant Gryndyll John yeoman 595971 595971 Gryndyll, John, of Est Depyng, yeoman 2
5230893 2424643 2424643 defendant Gryndell John yeoman 595971 595971 Gryndell, John, of Est Depyng, yeoman 2
5236254 2426191 2426191 defendant Tymyng William barker 595971 595971 Tymyng, William, of Est Depyng, barker 0
5236379 2426232 2426232 defendant Tymyng William barker 595971 595971 Tymyng, William, of Est Depyng, barker 0
5238963 2426986 2426986 defendant Gryndell John yeoman 595971 595971 (Gryndell, John, of Est Depyng, yeoman 1
5297335 2444217 2444217 defendant Wylkyns Richard butcher 595971 595971 Wylkyns, Richard, of East Depyng, butcher 0
5303383 2446007 2446007 defendant Lyster Thomas   595971 595971 Lyster, Thomas, of East Depyng, barber, administrators of 0
5303385 2446007 2446007 defendant Edward alias Kyrton John husbandman 595971 595971 Edward alias Kyrton, John, of East Depyng, husbandman 2
5319084 2450801 2450801 defendant Wylkyns alias Bocher Ricard yeoman 595971 595971 Wylkyns alias Bocher, Ricard, of Est Depyng, yeoman 0
5327040 2453164 2453164 defendant Hakeworth William yeoman 595971 595971 Hakeworth, William, of Est Depyng, yeoman 1
5365049 2464739 2464739 defendant Osse John   595971 595971 Osse, John, of East Depyng, shoe maker 0
5412016 2478549 2478549 defendant Bee William husbandman 595971 595971 Bee, William, of East Depyng, husbandman 0
5417211 2480059 2480059 defendant Bocher Richard butcher 595971 595971 Bocher, Richard, of East Depyng, butcher 0
5426550 2482886 2482886 defendant Bee William husbandman 595971 595971 Bee, William, of East Depyng, husbandman 0
5434366 2485217 2485217 defendant Bocher Richard   595971 595971 Bocher, Richard, of East Depyng 0
5450252 2489959 2489959 defendant Wymerke William draper 595971 595971 Wymerke, William, of East Depyng, draper 1
5450253 2489959 2489959 defendant (illegible) Thomas husbandman 595971 595971 _, Thomas, of East Depyng, husbandman 2
5462413 2493659 2493659 defendant Tego Stephen draper 595971 595971 Tego, Stephen, of East Depyng, draper 0
5462414 2493659 2493659 defendant Wymerke William husbandman 595971 595971 Wymerke, William, of East Depyng, husbandman 1
5462415 2493659 2493659 defendant Payne Thomas husbandman 595971 595971 Payne, Thomas, of East Depyng, husbandman 2
5473936 2497178 2497178 defendant Tege Stephen draper 595971 595971 Tege, Stephen, of East Depyng, draper 0
5473937 2497178 2497178 defendant Wymerke William husbandman 595971 595971 Wymerke, William, of East Depyng, husbandman 1
5473938 2497178 2497178 defendant Payn Thomas husbandman 595971 595971 Payn, Thomas, of East Depyng, husbandman 2
5513790 2509169 2509169 defendant Draghton John yeoman 595971 595971 Draghton, John, of Est Depyng, yeoman 1
5615492 2548632 2548632 plaintiff Godelak William   595971 595971 Godelak, William, of East Depyng 0
5615494 2548633 2548633 plaintiff Godelok William   595971 595971 Godelok, William, of Est Depyng 0
5626828 2552362 2552362 defendant Ives John   595971 595971 Ives, John, of Est Depyng, neat driver 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);