names

52 rows where place_id = 650258

✎ 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
3911055 1994026 1994026 defendant Burton Robert husbandman 650258 650258 Burton, Robert, of Wyvelescombe, husbandman 0
3920242 1997107 1997107 defendant Yaye Richard husbandman 650258 650258 Yaye, Richard, of Wyvelescombe, husbandman 0
3920244 1997107 1997107 defendant Marsche Thomas husbandman 650258 650258 Marsche, Thomas, of Wyvelescombe, husbandman 2
3920246 1997107 1997107 defendant Howell John husbandman 650258 650258 Howell, John, of Wyvelescombe, husbandman 4
3984924 2019365 2019365 plaintiff Tolmer Robert husbandman 650258 650258 Tolmer, Robert, of Wyvelescombe, husbandman 0
4122224 2068253 2068253 defendant Hawkyns alias Torre Andrew butcher 650258 650258 Hawkyns alias Torre, Andrew, of Wyvelescombe, butcher 1
4163472 2082749 2082749 defendant Bennett John yeoman 650258 650258 Bennett, John, of Wyvelescombe, yeoman 0
4168896 2084613 2084613 defendant Yendall John husbandman 650258 650258 Yendall, John, of Wyvelescombe, husbandman 0
4258976 2115972 2115972 defendant Pryst William smith 650258 650258 Pryst, William, of Wyvelescombe, smith 0
4275552 2121389 2121389 defendant Storye Robert yeoman 650258 650258 Storye, Robert, of Wyvelescombe, yeoman 0
4291082 2126876 2126876 defendant Oldys Roger mercer 650258 650258 Oldys, Roger, of Wyvelescombe, mercer 0
4299784 2130009 2130009 defendant Oldys Roger mercer 650258 650258 Oldys, Roger, of Wyvelescombe, mercer 0
4302558 2131013 2131013 defendant Presse Christiana widow 650258 650258 Presse, Christiana, of Wyvelescombe, widow 0
4302559 2131013 2131013 defendant Presse Mathew   650258 650258 Presse, Mathew, of Wyvelescombe, linen draper 1
4309250 2133388 2133388 defendant Hoyell George husbandman 650258 650258 Hoyell, George, of Wyvelescombe, husbandman 0
4311723 2134242 2134242 defendant Storye Robert yeoman 650258 650258 Storye, Robert, of Wyvelescombe, yeoman 0
4313123 2134706 2134706 defendant Upham Edward yeoman 650258 650258 Upham, Edward, of Wyvelescombe, yeoman 2
4313124 2134706 2134706 defendant Upham Roger yeoman 650258 650258 Upham, Roger, of Wyvelescombe, yeoman 3
4362888 2151787 2151787 defendant Wulcott John weaver 650258 650258 Wulcott, John, of Wyvelescombe, weaver 0
4493165 2198565 2198565 defendant Pole John   650258 650258 Pole, John, of Wyvelescombe 5
4496169 2199478 2199478 defendant Glover William   650258 650258 Glover, William, of Wyvelescombe 0
4516291 2205506 2205506 defendant More William   650258 650258 More, William, of Wyvelescombe 1
4516305 2205510 2205510 defendant Tanner John   650258 650258 Tanner, John, of Wyvelescombe 1
4562989 2219992 2219992 defendant Northam John   650258 650258 together with Northam, John, of Wyvelescombe 1
4617178 2236381 2236381 defendant Glover William   650258 650258 Glover, William, of Wyvelescombe 5
4620587 2237426 2237426 defendant Morys John   650258 650258 Morys, John, of Wyvelescombe 0
4624638 2238688 2238688 defendant Touker John   650258 650258 Touker, John, of Wyvelescombe 1
4624644 2238689 2238689 defendant Touker John   650258 650258 Touker, John, of Wyvelescombe 1
4672963 2257184 2257184 defendant Perseman Ralph stocer 650258 650258 Perseman, Ralph, of Wyvelescombe, stocer 0
4691076 2262733 2262733 plaintiff Wreyntemore Richard (legal representative) 650258 650258 Wreyntemore, Richard, of Wyvelescombe, executors of 0
4691085 2262734 2262734 plaintiff Wreyntemore Richard (legal representative) 650258 650258 Wreyntemore, Richard, of Wyvelescombe, executors of 0
4701303 2265806 2265806 defendant Cater Nicholas yeoman 650258 650258 Cater, Nicholas, of Wyvelescombe, yeoman 0
4731860 2275151 2275151 defendant Tanner John husbandman 650258 650258 Tanner, John, of Wyvelescombe, husbandman 0
4867928 2316938 2316938 defendant North William husbandman 650258 650258 North, William, of Wyvelescombe, husbandman 4
4872346 2318314 2318314 defendant Dennyng Thomas husbandman 650258 650258 Dennyng, Thomas, of Wyvelescombe, husbandman 0
4872347 2318314 2318314 defendant Paulyn Roger weaver 650258 650258 Paulyn, Roger, of Wyvelescombe, weaver 1
4872349 2318314 2318314 defendant Valentyn Thomas husbandman 650258 650258 Valentyn, Thomas, of Wyvelescombe, husbandman 3
4872351 2318314 2318314 defendant Reveson John husbandman 650258 650258 Reveson, John, of Wyvelescombe, husbandman 5
4946191 2340792 2340792 defendant Bocher William husbandman 650258 650258 Bocher, William, of Wyvelescombe, husbandman 0
4946192 2340792 2340792 defendant Swengle John husbandman 650258 650258 Swengle, John, of Wyvelescombe, husbandman 1
4946194 2340793 2340793 defendant Bocher William husbandman 650258 650258 Bocher, William, of Wyvelescombe, husbandman 0
4946195 2340793 2340793 defendant Swengle John husbandman 650258 650258 Swengle, John, of Wyvelescombe, husbandman 1
4962749 2345767 2345767 plaintiff Brytte Richard   650258 650258 Brytte, Richard, of Wyvelescombe 0
5058942 2374241 2374241 defendant Dounyng Thomas yeoman 650258 650258 Dounyng, Thomas, of Wyvelescombe, yeoman 2
5058947 2374242 2374242 defendant Dennyng Thomas yeoman 650258 650258 Dennyng, Thomas, of Wyvelescombe, yeoman 1
5138260 2397699 2397699 defendant Soyton Thomas laborer 650258 650258 Soyton, Thomas, of Wyvelescombe, laborer 2
5194926 2414265 2414265 defendant Toryton Thomas laborer 650258 650258 Toryton, Thomas, of Wyvelescombe, laborer 2
5197408 2414985 2414985 defendant Yae Richard yeoman 650258 650258 (Yae, Richard, of Wyvelescombe, yeoman 3
5220115 2421593 2421593 defendant Herele Thomas tucker 650258 650258 Herele, Thomas, of Wyvelescombe, tucker 0
5286069 2440933 2440933 defendant Dynevell Robert husbandman 650258 650258 Dynevell, Robert, of Wyvelescombe, husbandman 5
5318097 2450501 2450501 defendant Croke Thomas yeoman 650258 650258 Croke, Thomas, of Wyvelescombe, yeoman 0
5633111 2554359 2554359 defendant Breton John tailor 650258 650258 Breton, John, of Wyvelescombe, tailor 5

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