names

175 rows where place_id = 780231

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4667006 2255413 2255413 defendant Bouke John clerk 780231 780231 Bouke, John, of Oxford, Oxon, clerk 2
4667010 2255414 2255414 defendant Bouke John clerk 780231 780231 Bouke, John, of Oxford, Oxon, clerk 2
4668600 2255889 2255889 defendant Chaundeler Richard courrier 780231 780231 Chaundeler, Richard, of Oxford, Oxon, courrier 0
4671966 2256876 2256876 defendant Cook Clarence   780231 780231 Cook, Clarence, of Oxford, Oxon, cook 1
4675771 2258030 2258030 defendant Cooke William fuller 780231 780231 Cooke, William, of Oxford, Oxon, fuller 0
4681262 2259763 2259763 defendant Brampton John clerk 780231 780231 Brampton, John, of Oxford, Oxon, clerk 0
4682906 2260270 2260270 defendant Dauntesey Walter gent 780231 780231 Dauntesey, Walter, of Oxford, Oxon, gent 0
4686143 2261261 2261261 defendant Daundesey Walter gent 780231 780231 Daundesey, Walter, of Oxford, Oxon, gent 0
4690690 2262636 2262636 defendant Taylour Henry tailor 780231 780231 Taylour, Henry, of Oxford, Oxon, tailor 4
4690759 2262650 2262650 defendant Martyll John clerk 780231 780231 Martyll, John, of Oxford, Oxon, clerk 0
4690911 2262687 2262687 defendant Barton William clerk 780231 780231 Barton, William, of Oxford, Oxon, clerk 0
4692528 2263176 2263176 defendant Gibbes Thomas husbandman 780231 780231 Gibbes, Thomas, of Oxford, Oxon, husbandman 0
4693807 2263565 2263565 defendant Lugardyn Walter   780231 780231 Lugardyn, Walter, of Oxford, Oxon, scholar 0
4695282 2264006 2264006 defendant Brampton John clerk 780231 780231 Brampton, John, of Oxford, Oxon, clerk 0
4695629 2264113 2264113 defendant Percy Thomas   780231 780231 Percy, Thomas, of Oxford, Oxon, clerk, alias of Middlesex, knight 2
4696102 2264263 2264263 defendant Wodeward John mercer 780231 780231 Wodeward, John, of Oxford, Oxon, mercer 2
4696356 2264340 2264340 defendant Chaundeler Richard carrier 780231 780231 Chaundeler, Richard, of Oxford, Oxon, carrier 0
4700181 2265477 2265477 defendant Percy Thomas   780231 780231 Percy, Thomas, of Oxford, Oxon, clerk alias of Middlesex, knight 1
4702673 2266238 2266238 defendant Eyre William dyer 780231 780231 Eyre, William, of Oxford, Oxon, dyer 0
4702693 2266241 2266241 defendant Eyre William dyer 780231 780231 Eyre, William, of Oxford, Oxon, dyer 0
4705642 2267139 2267139 defendant Chamberleyn Edward brewer 780231 780231 Chamberleyn, Edward, of Oxford, Oxon, brewer 0
4706447 2267398 2267398 defendant Dyer William dyer 780231 780231 Dyer, William, of Oxford, Oxon, dyer 0
4708680 2268089 2268089 defendant Halyngbury John   780231 780231 Halyngbury, John, of Oxford, Oxon, brass worker 0
4708685 2268090 2268090 defendant Benet Hugh butcher 780231 780231 Benet, Hugh, of Oxford, Oxon, butcher 0
4709024 2268190 2268190 defendant Wolvercote Thomas draper 780231 780231 Wolvercote, Thomas, of Oxford, Oxon, draper 0
4710991 2268794 2268794 defendant Eseby John chaplain 780231 780231 Eseby, John, of Oxford, Oxon, chaplain 1
4721892 2272179 2272179 defendant Northwode Robert husbandman 780231 780231 Northwode, Robert, of Oxford, Oxon, husbandman 1
4724824 2273060 2273060 defendant Gybbes Thomas gent 780231 780231 Gybbes, Thomas, of Oxford, Oxon, gent 1
4724827 2273061 2273061 defendant Gybbes Thomas gent 780231 780231 Gybbes, Thomas, of Oxford, Oxon, gent 0
4725290 2273200 2273200 defendant Gibbes Thomas esq 780231 780231 Gibbes, Thomas, of Oxford, Oxon, esq 0
4727644 2273887 2273887 defendant Brampton William chapman 780231 780231 Brampton, William, of Oxford, Oxon, chapman 0
4727865 2273957 2273957 defendant Pannall Thomas   780231 780231 Pannall, Thomas, of Oxford, Oxon, bow maker, son of John Pannall, bow maker of York 0
4730218 2274654 2274654 defendant Kyngesmylle William husbandman 780231 780231 Kyngesmylle, William, of Oxford, Oxon, husbandman 0
4736987 2276696 2276696 defendant Kyngesmylle William scrivener 780231 780231 Kyngesmylle, William, of Oxford, Oxon, scrivener 1
4744812 2279002 2279002 defendant Gibbes Thomas gent 780231 780231 Gibbes, Thomas, of Oxford, Oxon, gent 0
4746635 2279506 2279506 defendant Brampton John clerk 780231 780231 Brampton, John, of Oxford, Oxon, clerk 3
4750525 2280637 2280637 defendant Colet Walter draper 780231 780231 Colet, Walter, of Oxford, Oxon, draper 0
4750773 2280708 2280708 defendant Perys John clerk 780231 780231 Perys, John, of Oxford, Oxon, clerk 0
4751074 2280797 2280797 defendant Shakull John ostiler 780231 780231 Shakull, John, of Oxford, Oxon, ostiler 1
4752206 2281118 2281118 defendant Northwode Robert chapman 780231 780231 Northwode, Robert, of Oxford, Oxon, chapman 0
4752220 2281122 2281122 defendant Bowet Henry clerk 780231 780231 Bowet, Henry, of Oxford, Oxon, clerk 2
4752703 2281250 2281250 defendant Lodelowe Julia widow 780231 780231 Lodelowe, Julia, of Oxford, Oxon, widow 1
4753716 2281535 2281535 defendant Wethik Richard draper 780231 780231 Wethik, Richard, of Oxford, Oxon, draper 0
4753720 2281536 2281536 defendant Wethik Richard draper 780231 780231 Wethik, Richard, of Oxford, Oxon, draper 0
4753733 2281541 2281541 defendant Hid John dyer 780231 780231 Hid, John, of Oxford, Oxon, dyer 0
4753735 2281542 2281542 defendant Hyd John dyer 780231 780231 Hyd, John, of Oxford, Oxon, dyer 0
4753737 2281543 2281543 defendant Hyd John dyer 780231 780231 Hyd, John, of Oxford, Oxon, dyer 0
4757068 2282579 2282579 defendant Hertepole John   780231 780231 Hertepole, John, of Oxford, Oxon, husbandman, formerly of London 0
4757459 2282709 2282709 defendant Wylde Thomas goldsmith 780231 780231 Wylde, Thomas, of Oxford, Oxon, goldsmith 0
4757461 2282710 2282710 defendant Benet Hugh   780231 780231 Benet, Hugh, of Oxford, Oxon, sergeant 0
4758306 2282974 2282974 defendant Milton John tailor 780231 780231 Milton, John, of Oxford, Oxon, tailor 0
4759646 2283365 2283365 defendant Weston John   780231 780231 Weston, John, of Oxford, Oxon, manciple 0
4759883 2283426 2283426 defendant Holcote Elias clerk 780231 780231 Holcote, Elias, of Oxford, Oxon, clerk 1
4765226 2285107 2285107 defendant Coventre Thomas gent 780231 780231 Coventre, Thomas, of Oxford, Oxon, gent 0
4766453 2285500 2285500 defendant Swan Thomas gent 780231 780231 Swan, Thomas, of Oxford, Oxon, gent 0
4774125 2287893 2287893 defendant Swan Thomas gent 780231 780231 Swan, Thomas, of Oxford, Oxon, gent 0
4775033 2288187 2288187 defendant Wolvercote Thomas draper 780231 780231 Wolvercote, Thomas, of Oxford, Oxon, draper 0
4804990 2297766 2297766 defendant Trebelvile William clerk 780231 780231 Trebelvile, William, of Oxford, Oxon, clerk 0
4804994 2297767 2297767 defendant Trebelvyle William clerk 780231 780231 Trebelvyle, William, of Oxford, Oxon, clerk 0
4824010 2303585 2303585 defendant Ludlowe John gent 780231 780231 Ludlowe, John, of Oxford, Oxon, gent 0
4825296 2303953 2303953 defendant Tymberden John skinner 780231 780231 Tymberden, John, of Oxford, Oxon, skinner 2
4828573 2304978 2304978 defendant Hore Richard clerk 780231 780231 Hore, Richard, of Oxford, Oxon, clerk 0
4832049 2306055 2306055 defendant Hanbury John brewer 780231 780231 Hanbury, John, of Oxford, Oxon, brewer 0
4835380 2307062 2307062 defendant Hyde John dyer 780231 780231 Hyde, John, of Oxford, Oxon, dyer 0
4842835 2309299 2309299 defendant Braywell Stephen   780231 780231 Braywell, Stephen, of Oxford, Oxon, notary 0
4845579 2310128 2310128 defendant Bradle John vintner 780231 780231 Bradle, John, of Oxford, Oxon, vintner 0
4848107 2310877 2310877 defendant Quarham John   780231 780231 Quarham, John, of Oxford, Oxon 1
4851614 2311939 2311939 defendant Hore Richard clerk 780231 780231 Hore, Richard, of Oxford, Oxon, clerk 0
4851967 2312048 2312048 defendant Fenton William clerk 780231 780231 Fenton, William, of Oxford, Oxon, clerk 0
4852035 2312068 2312068 defendant Michell John skinner 780231 780231 Michell, John, of Oxford, Oxon, skinner 0
4852144 2312100 2312100 defendant Coventry Thomas gent 780231 780231 Coventry, Thomas, of Oxford, Oxon, gent 0
4852153 2312103 2312103 defendant Coventry Thomas gent 780231 780231 Coventry, Thomas, of Oxford, Oxon, gent 0
4852156 2312104 2312104 defendant Coventry Thomas gent 780231 780231 Coventry, Thomas, of Oxford, Oxon, gent 0
4908489 2329209 2329209 defendant Herbert John   780231 780231 Herbert, John, of Oxford, Oxon, bow maker 1
4909306 2329453 2329453 defendant Sandewych Walter clerk 780231 780231 Sandewych, Walter, of Oxford, Oxon, clerk 2
4916201 2331570 2331570 defendant Polton Philip clerk 780231 780231 Polton, Philip, of Oxford, Oxon, clerk 0
4917809 2332083 2332083 defendant Broune Thomas   780231 780231 Broune, Thomas, of Oxford, Oxon, cook 1
4917847 2332094 2332094 defendant Asshebury John butcher 780231 780231 Asshebury, John, of Oxford, Oxon, butcher 0
4919130 2332496 2332496 plaintiff Herlerfeld Cecilia widow 780231 780231 Herlerfeld, Cecilia, of Oxford, Oxon, widow 0
4929099 2335522 2335522 defendant de Orell William clerk 780231 780231 de Orell, William, of Oxford, Oxon, clerk 0
4930556 2335961 2335961 defendant Estbury John (legal representative) 780231 780231 Estbury, John, of Oxford, Oxon, executrix of 0
4930559 2335962 2335962 defendant Estbury John (legal representative) 780231 780231 Estbury, John, of Oxford, Oxon, executrix of 0
4932051 2336416 2336416 defendant Hyde John dyer 780231 780231 Hyde, John, of Oxford, Oxon, dyer 0
4932273 2336496 2336496 defendant Hyde John dyer 780231 780231 Hyde, John, of Oxford, Oxon, dyer 0
4986570 2352911 2352911 defendant Alyn John smith 780231 780231 Alyn, John, of Oxford, Oxon, smith 0
4988634 2353557 2353557 defendant Abell Richard slater 780231 780231 Abell, Richard, of Oxford, Oxon, slater 0
4990399 2354040 2354040 defendant Beverley Robert clerk 780231 780231 Beverley, Robert, of Oxford, Oxon, clerk 1
4992514 2354646 2354646 defendant Budde Walter clerk 780231 780231 Budde, Walter, of Oxford, Oxon, clerk 0
4994431 2355209 2355209 defendant Hayle William chapman 780231 780231 Hayle, William, of Oxford, Oxon, chapman 2
4995612 2355526 2355526 defendant Austell John clerk 780231 780231 Austell, John, of Oxford, Oxon, clerk 0
4995839 2355602 2355602 defendant Whitby Thomas merchant 780231 780231 Whitby, Thomas, of Oxford, Oxon, merchant 0
4999600 2356754 2356754 defendant Holcote Ellis clerk 780231 780231 Holcote, Ellis, of Oxford, Oxon, clerk 2
5000597 2357043 2357043 defendant Taillour William tailor 780231 780231 Taillour, William, of Oxford, Oxon, tailor 3
5000602 2357044 2357044 defendant Taillour William tailor 780231 780231 Taillour, William, of Oxford, Oxon, tailor 3
5003861 2358020 2358020 defendant Buntyng John chapman 780231 780231 Buntyng, John, of Oxford, Oxon, chapman 0
5003865 2358021 2358021 defendant Buntyng John chapman 780231 780231 Buntyng, John, of Oxford, Oxon, chapman 0
5006125 2358679 2358679 defendant Swyffte Richard glasier 780231 780231 Swyffte, Richard, of Oxford, Oxon, glasier 3
5006134 2358682 2358682 defendant Aston John clerk 780231 780231 Aston, John, of Oxford, Oxon, clerk 1
5009506 2359658 2359658 defendant Throp William   780231 780231 Throp, William, of Oxford, Oxon, bekr 0
5009942 2359781 2359781 defendant Bradele John vintner 780231 780231 Bradele, John, of Oxford, Oxon, vintner 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);