names

110 rows where place_id = 586483

✎ 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
3588837 1864157 1864157 defendant Bernard Richard clothier 586483 586483 Bernard, Richard, of Wycombe, Bucks, clothier 0
3588843 1864159 1864159 defendant Bernard Richard clothier 586483 586483 Bernard, Richard, of Wycombe, Bucks, clothier 1
3694819 1924587 1924587 defendant Gerrard Thomas clothman 586483 586483 Gerrard, Thomas, of Wycombe, Bucks, clothman 0
3886000 1985569 1985569 defendant Ware William yeoman 586483 586483 Ware, William, of Wycombe, Bucks, yeoman 2
4016620 2030650 2030650 defendant Pymme Timothy gent 586483 586483 Pymme, Timothy, of Wycombe, Bucks, gent 2
4457141 2187244 2187244 defendant Bristowe John woder or woad dyer 586483 586483 Bristowe, John, of Wycombe, Bucks, woder or woad dyer 0
4651024 2246319 2246319 defendant Cotyngham Robert chapman 586483 586483 Cotyngham, Robert, of Wycombe, Bucks, chapman 2
4652981 2246865 2246865 defendant Wycombe Richard brasier 586483 586483 Wycombe, Richard, of Wycombe, Bucks, brasier 0
4652986 2246866 2246866 defendant Wycombe Richard brasier 586483 586483 Wycombe, Richard, of Wycombe, Bucks, brasier 0
4652991 2246867 2246867 defendant Wycombe Richard brasier 586483 586483 Wycombe, Richard, of Wycombe, Bucks, brasier 0
4665876 2250803 2250803 defendant Marchant John yeoman 586483 586483 Marchant, John, of Wycombe, Bucks, yeoman 0
4670440 2256439 2256439 defendant Bryan John gent 586483 586483 Bryan, John, of Wycombe, Bucks, gent 0
4670553 2256467 2256467 defendant Bryan John gent 586483 586483 Bryan, John, of Wycombe, Bucks, gent 0
4674712 2257702 2257702 defendant Cotyngham Robert chapman 586483 586483 Cotyngham, Robert, of Wycombe, Bucks, chapman 0
4674940 2257772 2257772 defendant Cotyngham Robert chapman 586483 586483 Cotyngham, Robert, of Wycombe, Bucks, chapman 3
4692359 2263128 2263128 defendant Pusey Thomas gent 586483 586483 Pusey, Thomas, of Wycombe, Bucks, gent 0
4693661 2263517 2263517 defendant Bryan John esq 586483 586483 Bryan, John, of Wycombe, Bucks, esq 1
4693974 2263623 2263623 defendant Northike William fisher 586483 586483 Northike, William, of Wycombe, Bucks, fisher 2
4693982 2263625 2263625 defendant Northoke William fishmonger 586483 586483 Northoke, William, of Wycombe, Bucks, fishmonger 2
4699939 2265413 2265413 defendant Sakevile Thomas   586483 586483 Sakevile, Thomas, of Wycombe, Bucks, knight 0
4699956 2265415 2265415 defendant Sakevile Thomas   586483 586483 Sakevile, Thomas, of Wycombe, Bucks, knight 0
4703783 2266562 2266562 defendant Cotyngham Robert tailor 586483 586483 Cotyngham, Robert, of Wycombe, Bucks, tailor 0
4704838 2266891 2266891 defendant Travayll John ostler 586483 586483 Travayll, John, of Wycombe, Bucks, ostler 2
4744561 2278932 2278932 defendant Hugan John chapman 586483 586483 Hugan, John, of Wycombe, Bucks, chapman 2
4757258 2282643 2282643 defendant Sperlyng Andrew gent 586483 586483 Sperlyng, Andrew, of Wycombe, Bucks, gent 0
4759402 2283283 2283283 defendant Norwyke William laborer 586483 586483 Norwyke, William, of Wycombe, Bucks, laborer 1
4762455 2284241 2284241 defendant Delle Stephen   586483 586483 Delle, Stephen, of Wycombe, Bucks, shoe maker 3
4762668 2284303 2284303 defendant Lovell John husbandman 586483 586483 Lovell, John, of Wycombe, Bucks, husbandman 0
4786292 2291755 2291755 defendant Lovell John husbandman 586483 586483 Lovell, John, of Wycombe, Bucks, husbandman 0
4805366 2297883 2297883 defendant Pusey Thomas gent 586483 586483 Pusey, Thomas, of Wycombe, Bucks, gent 0
4830463 2305560 2305560 plaintiff Blakpoll John husbandman 586483 586483 Blakpoll, John, of Wycombe, Bucks, husbandman 0
4844614 2309836 2309836 defendant Sparlyng Andrew gent 586483 586483 Sparlyng, Andrew, of Wycombe, Bucks, gent 3
4844619 2309837 2309837 defendant Sparlyng Andrew gent 586483 586483 Sparlyng, Andrew, of Wycombe, Bucks, gent 2
4844626 2309838 2309838 defendant Sparlyng Andrew gent 586483 586483 Sparlyng, Andrew, of Wycombe, Bucks, gent 3
4865284 2316114 2316114 defendant Cok Thomas draper 586483 586483 Cok, Thomas, of Wycombe, Bucks, draper 1
4866873 2316602 2316602 defendant Lovell John husbandman 586483 586483 Lovell, John, of Wycombe, Bucks, husbandman 2
4866879 2316603 2316603 defendant Lovell John husbandman 586483 586483 Lovell, John, of Wycombe, Bucks, husbandman 2
4867189 2316698 2316698 defendant Lovell John yeoman 586483 586483 Lovell, John, of Wycombe, Bucks, yeoman 0
4874862 2319079 2319079 defendant Clerk John chapman 586483 586483 Clerk, John, of Wycombe, Bucks, chapman 0
4886399 2322607 2322607 defendant Clerk Mary chapwoman 586483 586483 Clerk, Mary, of Wycombe, Bucks, chapwoman 0
4889000 2323351 2323351 defendant Clark Mary chapwoman 586483 586483 Clark, Mary, of Wycombe, Bucks, chapwoman 0
4892404 2324364 2324364 defendant Boure Alice widow 586483 586483 Boure, Alice, of Wycombe, Bucks, widow 1
4906724 2328689 2328689 defendant Marke Nicholas yeoman 586483 586483 Marke, Nicholas, of Wycombe, Bucks, yeoman 1
4907301 2328847 2328847 defendant Pusey Thomas gent 586483 586483 Pusey, Thomas, of Wycombe, Bucks, gent 1
4916776 2331752 2331752 defendant Shene Thomas weaver 586483 586483 Shene, Thomas, of Wycombe, Bucks, weaver 0
4916778 2331753 2331753 defendant Shene Thomas weaver 586483 586483 Shene, Thomas, of Wycombe, Bucks, weaver 0
4921013 2333083 2333083 defendant Heryng William ostler 586483 586483 Heryng, William, of Wycombe, Bucks, ostler 0
4921349 2333188 2333188 defendant Ponde William husbandman 586483 586483 Ponde, William, of Wycombe, Bucks, husbandman 0
4937522 2338111 2338111 defendant Payn Richard goldsmith 586483 586483 Payn, Richard, of Wycombe, Bucks, goldsmith 1
4955057 2343464 2343464 defendant Benford Hugh husbandman 586483 586483 Benford, Hugh, of Wycombe, Bucks, husbandman 0
4955060 2343465 2343465 defendant Benforde Hugh husbandman 586483 586483 Benforde, Hugh, of Wycombe, Bucks, husbandman 0
4959705 2344863 2344863 defendant Wodewyk John husbandman 586483 586483 Wodewyk, John, of Wycombe, Bucks, husbandman 3
4962679 2345744 2345744 defendant Eggewell William brasier 586483 586483 Eggewell, William, of Wycombe, Bucks, brasier 3
4971262 2348342 2348342 defendant Payn Richard goldsmith 586483 586483 Payn, Richard, of Wycombe, Bucks, goldsmith 2
4994199 2355140 2355140 defendant Sadeler John sadler 586483 586483 Sadeler, John, of Wycombe, Bucks, sadler 0
4994201 2355141 2355141 defendant Sadeler John sadler 586483 586483 Sadeler, John, of Wycombe, Bucks, sadler 0
5033781 2366761 2366761 defendant Cotyngham Robert husbandman 586483 586483 Cotyngham, Robert, of Wycombe, Bucks, husbandman 0
5040317 2368704 2368704 defendant Sharpe John glover 586483 586483 Sharpe, John, of Wycombe, Bucks, glover 0
5050288 2371710 2371710 plaintiff Thomasson David yeoman 586483 586483 Thomasson, David, of Wycombe, Bucks, yeoman 0
5051268 2371992 2371992 defendant Lambard William chapman 586483 586483 Lambard, William, of Wycombe, Bucks, chapman 4
5070681 2377728 2377728 defendant Arnold Robert chapman 586483 586483 Arnold, Robert, of Wycombe, Bucks, chapman 3
5070688 2377729 2377729 defendant Arnold Robert chapman 586483 586483 Arnold, Robert, of Wycombe, Bucks, chapman 3
5072577 2378286 2378286 plaintiff Thomasson David yeoman 586483 586483 Thomasson, David, of Wycombe, Bucks, yeoman 0
5076467 2379458 2379458 defendant Cotyngham Robert chapman 586483 586483 Cotyngham, Robert, of Wycombe, Bucks, chapman 0
5078273 2379988 2379988 defendant Hodyngton John ironmonger 586483 586483 Hodyngton, John, of Wycombe, Bucks, ironmonger 4
5080605 2380688 2380688 defendant Orchard Thomas, senior baker 586483 586483 Orchard, Thomas, senior, of Wycombe, Bucks, baker 0
5090377 2383566 2383566 defendant Cary Walter glover 586483 586483 Cary, Walter, of Wycombe, Bucks, glover 1
5090384 2383567 2383567 defendant Cotyngham Robert mercer 586483 586483 Cotyngham, Robert, of Wycombe, Bucks, mercer 2
5091784 2383980 2383980 defendant Okyngham John draper 586483 586483 Okyngham, John, of Wycombe, Bucks, draper 4
5091793 2383981 2383981 defendant Okyngham John draper 586483 586483 Okyngham, John, of Wycombe, Bucks, draper 4
5134169 2396488 2396488 defendant Hodyngton John husbandman 586483 586483 Hodyngton, John, of Wycombe, Bucks, husbandman 2
5157084 2403211 2403211 defendant Care Richard yeoman 586483 586483 Care, Richard, of Wycombe, Bucks, yeoman 3
5173140 2407854 2407854 defendant Care Richard yeoman 586483 586483 Care, Richard, of Wycombe, Bucks, yeoman 3
5178598 2409455 2409455 defendant Odmere John chapman 586483 586483 Odmere, John, of Wycombe, Bucks, chapman 1
5192964 2413669 2413669 defendant Care Richard   586483 586483 Care, Richard, of Wycombe, Bucks 3
5192969 2413670 2413670 defendant Care Richard yeoman 586483 586483 Care, Richard, of Wycombe, Bucks, yeoman 3
5194891 2414254 2414254 defendant Bollard John smith 586483 586483 Bollard, John, of Wycombe, Bucks, smith 1
5212365 2419359 2419359 defendant Odmere John chapman 586483 586483 Odmere, John, of Wycombe, Bucks, chapman 1
5214310 2419918 2419918 defendant Hobbys Thomas chapman 586483 586483 Hobbys, Thomas, of Wycombe, Bucks, chapman 2
5216385 2420528 2420528 defendant Hobbes Thomas chapman 586483 586483 Hobbes, Thomas, of Wycombe, Bucks, chapman 2
5219734 2421497 2421497 defendant Cotyngham Robert, senior chapman 586483 586483 Cotyngham, Robert, senior, of Wycombe, Bucks, chapman 2
5224786 2422919 2422919 plaintiff Redhode William chandler 586483 586483 Redhode, William, of Wycombe, Bucks, chandler 0
5225326 2423079 2423079 defendant Admar John mercer 586483 586483 Admar, John, of Wycombe, Bucks, mercer 0
5240570 2427455 2427455 defendant Poynet Thomas chapman 586483 586483 Poynet, Thomas, of Wycombe, Bucks, chapman 2
5262698 2434079 2434079 defendant Attewelle Nicholas yeoman 586483 586483 Attewelle, Nicholas, of Wycombe, Bucks, yeoman 1
5277822 2438598 2438598 defendant Broun Thomas chapman 586483 586483 Broun, Thomas, of Wycombe, Bucks, chapman 1
5290209 2442139 2442139 defendant Broun Thomas chapman 586483 586483 Broun, Thomas, of Wycombe, Bucks, chapman 0
5290211 2442140 2442140 defendant Broun Thomas chapman 586483 586483 Broun, Thomas, of Wycombe, Bucks, chapman 0
5290214 2442141 2442141 defendant Broun Thomas chapman 586483 586483 Broun, Thomas, of Wycombe, Bucks, chapman 0
5290216 2442142 2442142 defendant Broun Thomas chapman 586483 586483 Broun, Thomas, of Wycombe, Bucks, chapman 0
5292079 2442684 2442684 defendant Broun Thomas gent 586483 586483 Broun, Thomas, of Wycombe, Bucks, gent 0
5294547 2443381 2443381 defendant Broun Thomas yeoman 586483 586483 Broun, Thomas, of Wycombe, Bucks, yeoman 0
5323048 2451972 2451972 defendant Bontyng William chapman 586483 586483 Bontyng, William, of Wycombe, Bucks, chapman 0
5323050 2451973 2451973 defendant Bontyng William chapman 586483 586483 Bontyng, William, of Wycombe, Bucks, chapman 0
5323052 2451974 2451974 defendant Buntyng William chapman 586483 586483 Buntyng, William, of Wycombe, Bucks, chapman 0
5353143 2461061 2461061 defendant Power Robert   586483 586483 Power, Robert, of Wycombe, Bucks 1
5392703 2472979 2472979 defendant (illegible) Richard gent 586483 586483 _, Richard, of Wycombe, Bucks, gent 0
5405762 2476721 2476721 defendant Buntyng Richard gent 586483 586483 Buntyng, Richard, of Wycombe, Bucks, gent 0
5405790 2476727 2476727 defendant Clery Richard gent 586483 586483 Clery, Richard, of Wycombe, Bucks, gent 0
5416200 2479776 2479776 defendant Gome John tailor 586483 586483 Gome, John, of Wycombe, Bucks, tailor 0

Next page

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