names

74 rows where place_id = 590727

✎ 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
3602106 1868323 1868323 defendant Basse Isabel widow 590727 590727 Basse, Isabel, of Chepyng Wycombe, Bucks, widow 1
3628971 1903936 1903936 defendant Wylcokk Walter gent 590727 590727 Wylcokk, Walter, of Chepyng Wycombe, Bucks, gent 1
3636977 1906361 1906361 defendant Gerrard Thomas clothier 590727 590727 Gerrard, Thomas, of Chepyng Wycombe, Bucks, clothier 0
3640612 1907505 1907505 plaintiff Asshebroke Robert   590727 590727 Asshebroke, Robert, of Chepyng Wycombe, Bucks 0
3642552 1908114 1908114 plaintiff Chalfount William   590727 590727 Chalfount, William, of Chepyng Wycombe, Bucks, learned man 0
3654371 1911629 1911629 plaintiff Astbroke Robert   590727 590727 Astbroke, Robert, of Chepyng Wycombe, Bucks, 0
3654374 1911630 1911630 plaintiff Astbrooke Robert   590727 590727 Astbrooke, Robert, of Chepyng Wycombe, Bucks, 0
3671738 1917147 1917147 defendant Clerke Thomas husbandman 590727 590727 Clerke, Thomas, of Chepyng Wycombe, Bucks, husbandman 0
3672872 1917527 1917527 defendant Hamond Thomas glover 590727 590727 Hamond, Thomas, of Chepyng Wycombe, Bucks, glover 1
3674074 1917932 1917932 defendant Gerard Thomas gent 590727 590727 Gerard, Thomas, of Chepyng Wycombe, Bucks, gent 1
3739212 1938483 1938483 defendant Paytefere Robert clothman 590727 590727 Paytefere, Robert, of Chepyng Wycombe, Bucks, clothman 0
3755262 1943599 1943599 defendant Frankleyn Hugh yeoman 590727 590727 Frankleyn, Hugh, of Chepyng Wycombe, Bucks, yeoman 0
3794325 1956101 1956101 defendant Balborough Thomas brewer 590727 590727 Balborough, Thomas, of Chepyng Wycombe, bucks, brewer 2
3794329 1956102 1956102 defendant Balborough Thomas brewer 590727 590727 Balborough, Thomas, of Chepyng Wycombe, Bucks, brewer 2
3800289 1958012 1958012 defendant Flye Joan widow 590727 590727 Flye, Joan, of Chepyng Wycombe, Bucks, widow 0
3805516 1959665 1959665 defendant Wyllysburn John gent 590727 590727 Wyllysburn, John, of Chepyng Wycombe, Bucks, gent 0
3805552 1959677 1959677 defendant Kelyng John husbandman 590727 590727 Kelyng, John, of Chepyng Wycombe, Bucks, husbandman 0
3814460 1962437 1962437 defendant Asshebroke William butcher 590727 590727 Asshebroke, William, of Chepyng Wycombe, Bucks, butcher 0
3875226 1981953 1981953 plaintiff Elys alias Wytnall Simon   590727 590727 Elys alias Wytnall, Simon, of Chepyng Wycombe, Bucks 0
3884147 1984964 1984964 defendant Cely Giles shoemaker 590727 590727 (Cely, Giles, of Chepyng Wycombe, Bucks, shoemaker 1
3912402 1994478 1994478 plaintiff Adlam Thomas glover 590727 590727 Adlam, Thomas, of Chepyng Wycombe, Bucks, glover 0
3912404 1994479 1994479 plaintiff Adlam Thomas glover 590727 590727 Adlam, Thomas, of Chepyng Wycombe, Bucks, glover 0
3981411 2018118 2018118 defendant Darrell John yeoman 590727 590727 Darrell, John, of Chepyng Wycombe, Bucks, yeoman 0
3989409 2020951 2020951 defendant Carye Edward gent 590727 590727 Carye, Edward, of Chepyng Wycombe, Bucks, gent 0
3996550 2023525 2023525 plaintiff Deane John (legal representative) 590727 590727 Deane, John, of Chepyng Wycombe, Bucks, gent, executors of 0
4788951 2292598 2292598 defendant Hochedes Thomas husbandman 590727 590727 Hochedes, Thomas, of Chepyng Wycombe, Bucks, husbandman 0
4891485 2324071 2324071 defendant Hode John husbandman 590727 590727 Hode, John, of Chepyng Wycombe, Bucks, husbandman 0
5012859 2360593 2360593 defendant Gomme John tailor 590727 590727 Gomme, John, of Chepyng Wycombe, Bucks, tailor 0
5244334 2428526 2428526 defendant Michell Robert husbandman 590727 590727 Michell, Robert, of Chepyng Wycombe, Bucks, husbandman 1
5249223 2429893 2429893 defendant Echenden Joan widow 590727 590727 Echenden, Joan, of Chepyng Wycombe, Bucks, widow 3
5261413 2433677 2433677 defendant Ascote John carpenter 590727 590727 Ascote, John, of Chepyng Wycombe, Bucks, carpenter 0
5267874 2435717 2435717 defendant Broun Thomas chapman 590727 590727 Broun, Thomas, of Chepyng Wycombe, Bucks, chapman 1
5267881 2435718 2435718 defendant Kymber Richard chapman 590727 590727 Kymber, Richard, of Chepyng Wycombe, Bucks, chapman 2
5270324 2436423 2436423 defendant Buntyng William ostler 590727 590727 Buntyng, William, of Chepyng Wycombe, Bucks, ostler 2
5275700 2437958 2437958 defendant Odymere John chapman 590727 590727 Odymere, John, of Chepyng Wycombe, Bucks, chapman 2
5275712 2437960 2437960 defendant Pusey John husbandman 590727 590727 Pusey, John, of Chepyng Wycombe, Bucks, husbandman 4
5294447 2443356 2443356 defendant Hertell John yeoman 590727 590727 Hertell, John, of Chepyng Wycombe, Bucks, yeoman 0
5313533 2449075 2449075 defendant Cary Richard gent 590727 590727 Cary, Richard, of Chepyng Wycombe, Bucks, gent 0
5347905 2459487 2459487 defendant Wellesborn Thomas gent 590727 590727 Wellesborn, Thomas, of Chepyng Wycombe, Bucks, gent 0
5355667 2461848 2461848 defendant Cray William gent 590727 590727 Cray, William, of Chepyng Wycombe, Bucks, gent 2
5372865 2467109 2467109 defendant Petynere John husbandman 590727 590727 Petynere, John, of Chepyng Wycombe, Bucks, husbandman 1
5375320 2467869 2467869 defendant Iver Robert barber 590727 590727 Iver, Robert, of Chepyng Wycombe, Bucks, barber 0
5375322 2467870 2467870 defendant Iver Robert barber 590727 590727 Iver, Robert, of Chepyng Wycombe, Bucks, barber 0
5380168 2469375 2469375 defendant Bayly John dyer 590727 590727 Bayly, John, of Chepyng Wycombe, Bucks, dyer 2
5381865 2469869 2469869 defendant Bruntyng Margery widow 590727 590727 Bruntyng, Margery, of Chepyng Wycombe, Bucks, widow 0
5384311 2470599 2470599 defendant Bayly John dyer 590727 590727 Bayly, John, of Chepyng Wycombe, Bucks, dyer 1
5385207 2470845 2470845 defendant Gorton Henry tailor 590727 590727 Gorton, Henry, of Chepyng Wycombe, Bucks, tailor 1
5388783 2471851 2471851 defendant Bernard William fisher 590727 590727 Bernard, William, of Chepyng Wycombe, Bucks, fisher 0
5388970 2471900 2471900 defendant Wellesborn Thomas gent 590727 590727 Wellesborn, Thomas, of Chepyng Wycombe, Bucks, gent 3
5397299 2474310 2474310 defendant Gorton Henry tailor 590727 590727 Gorton, Henry, of Chepyng Wycombe, Bucks, tailor 1
5400830 2475303 2475303 defendant Broun Thomas chapman 590727 590727 Broun, Thomas, of Chepyng Wycombe, Bucks, chapman 0
5401305 2475434 2475434 defendant Wellesborn Thomas gent 590727 590727 Wellesborn, Thomas, of Chepyng Wycombe, Bucks, gent 2
5401433 2475476 2475476 defendant Barnard William fisher 590727 590727 Barnard, William, of Chepyng Wycombe, Bucks, fisher 0
5401649 2475535 2475535 defendant Wollesbourn Thomas gent 590727 590727 Wollesbourn, Thomas, of Chepyng Wycombe, Bucks, gent 2
5413645 2479004 2479004 defendant Baydon Thomas fisher 590727 590727 Baydon, Thomas, of Chepyng Wycombe, Bucks, fisher 0
5413875 2479076 2479076 defendant Broun Thomas chapman 590727 590727 Broun, Thomas, of Chepyng Wycombe, Bucks, chapman 0
5414428 2479253 2479253 defendant Barnard William fisher 590727 590727 Barnard, William, of Chepyng wycombe, Bucks, fisher 0
5422969 2481822 2481822 defendant Bayly John dyer 590727 590727 Bayly, John, of Chepyng Wycombe, Bucks, dyer 2
5428455 2483436 2483436 defendant Cary William gent 590727 590727 Cary, William, of Chepyng Wycombe, Bucks, gent 3
5429326 2483703 2483703 defendant Broun Thomas chapman 590727 590727 Broun, Thomas, of Chepyng Wycombe, Bucks, chapman 0
5429329 2483704 2483704 defendant Broun Thomas chapman 590727 590727 Broun, Thomas, of Chepyng Wycombe, Bucks, chapman 0
5442405 2487649 2487649 defendant Bayly John   590727 590727 Bayly, John, of Chepyng Wycombe, Bucks 0
5442432 2487653 2487653 defendant Bayly John dyer 590727 590727 Bayly, John, of Chepyng Wycombe, Bucks, dyer 2
5445793 2488628 2488628 defendant Cary William gent 590727 590727 Cary, William, of Chepyng Wycombe, Bucks, gent 1
5458521 2492441 2492441 defendant Cary William gent 590727 590727 Cary, William, of Chepyng Wycombe, Bucks, gent 1
5458546 2492448 2492448 defendant Cary William gent 590727 590727 Cary, William, of Chepyng Wycombe, Bucks, gent 1
5459010 2492587 2492587 defendant Broun Thomas chapman 590727 590727 Broun, Thomas, of Chepyng Wycombe, Bucks, chapman 0
5519261 2510871 2510871 defendant Radcleff Hugh husbandman 590727 590727 Radcleff, Hugh, of Chepyng Wycombe, Bucks, husbandman 0
5543259 2518010 2518010 defendant True Richard clothier 590727 590727 True, Richard, of Chepyng Wycombe, Bucks, clothier 2
5543265 2518011 2518011 defendant True Richard clothier 590727 590727 True, Richard, of Chepyng Wycombe, Bucks, clothier 2
5579831 2528772 2528772 defendant Buttell Robert yeoman 590727 590727 Buttell, Robert, of Chepyng Wycombe, Bucks, yeoman 0
5595397 2533510 2533510 defendant Botull Robert yeoman 590727 590727 Botull, Robert, of Chepyng Wycombe, Bucks, yeoman 0
5601174 2535257 2535257 defendant Tye Geoffrey mercer 590727 590727 Tye, Geoffrey, of Chepyng Wycombe, Bucks, mercer 0
5601351 2535315 2535315 plaintiff Kylhoge John   590727 590727 Kylhoge, John, of Chepyng Wycombe, Bucks 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);