names

30 rows where place_id = 645951

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3814627 1962484 1962484 defendant Beremon John clerk 645951 645951 Beremon, John, of Cornwall, Oxon, clerk 2
3888295 1986348 1986348 defendant Lylle Thomas yeoman 645951 645951 Lylle, Thomas, of Oxon, yeoman 0
3971810 2014701 2014701 plaintiff Fernesy Edmund (legal representative) 645951 645951 Fernesy, Edmund, of Oxon, tailor, executors of 0
4029024 2035025 2035025 plaintiff Croker Gerrard gent 645951 645951 Croker, Gerrard, of Oxon, gent 0
4055860 2044478 2044478 defendant Preddye Thomas gent 645951 645951 Preddye, Thomas, of Fuller, Oxon, gent 4
4055870 2044481 2044481 defendant Preddye Thomas gent 645951 645951 Preddye, Thomas, of Fuller, Oxon, gent 4
4067179 2048560 2048560 defendant Marchall John (legal representative) 645951 645951 Marchall, John, of Oxon, yeoman, executors of 0
4073631 2050860 2050860 defendant Stocke William   645951 645951 Stocke, William, of Oxon, gent, Bachelor of Theology, Principal of Gloucester College 0
4220770 2102761 2102761 defendant Samon Edward gent 645951 645951 Samon, Edward, of Oxon, gent 0
4336390 2142462 2142462 defendant Page John blacksmith 645951 645951 Page, John, of Oxon , blacksmith 4
4484905 2195976 2195976 defendant Lekenore Robert esq 645951 645951 Lekenore, Robert, of Oxon, esq 1
4528962 2209339 2209339 plaintiff Merston John   645951 645951 Merston, John, of Oxon 0
4652235 2246646 2246646 defendant Nasshe Richard spicer 645951 645951 Nasshe, Richard, of Oxon, spicer 0
4731138 2274938 2274938 plaintiff Milton John tailor 645951 645951 Milton, John, of Oxon, tailor 0
4860536 2314651 2314651 defendant Attilbrigge John (legal representative) 645951 645951 Attilbrigge, John, of Oxon, executor of 0
4866547 2316499 2316499 defendant Draper Maud widow 645951 645951 Draper, Maud, of Oxon, widow 0
4876425 2319587 2319587 plaintiff Skyrmote William gent 645951 645951 Skyrmote, William, of Oxon, gent 0
4881309 2321056 2321056 defendant Ardern William gent 645951 645951 Ardern, William, of Oxon, gent 0
4882712 2321508 2321508 defendant Herberfeld Thomas butcher 645951 645951 Herberfeld, Thomas, of Oxon, butcher 0
4886892 2322752 2322752 plaintiff Quatremayn Richard   645951 645951 Quatremayn, Richard, of Oxon, esq, sheriff of Berks 0
4907158 2328802 2328802 plaintiff Walkstede Richard   645951 645951 Walkstede, Richard, of Oxon, knight 0
4945178 2340472 2340472 defendant Tynby William husbandman 645951 645951 Tynby, William, of Oxon, husbandman 4
4945731 2340652 2340652 defendant Sandewyche Walter clerk 645951 645951 Sandewyche, Walter, of Oxon, clerk 0
5008350 2359331 2359331 defendant Dagfyle Thomas gent 645951 645951 Dagfyle, Thomas, of Oxon, gent 0
5014401 2361074 2361074 plaintiff Bekyngham William esq 645951 645951 Bekyngham, William, of Oxon, esq 0
5023392 2363749 2363749 defendant Fetyplace Thomas (legal representative) 645951 645951 Fetyplace, Thomas, of Oxon, esq, executrix of 0
5131108 2395589 2395589 defendant Bathe Henry yeoman 645951 645951 Bathe, Henry, of Oxon, yeoman 0
5374305 2467568 2467568 defendant Coley Michael clerk 645951 645951 Coley, Michael, of Oxon, clerk 0
5404919 2476483 2476483 defendant Gurdeler Thomas tailor 645951 645951 Gurdeler, Thomas, of Oxon, tailor 0
5636573 2555384 2555384 defendant Mayster Thomas glover 645951 645951 Mayster, Thomas, of Oxon, glover 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);