names

46 rows where place_id = 658571

✎ 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
3948969 2006708 2006708 plaintiff Dowghtey John fishmonger 658571 658571 Dowghtey, John, of Lonon, fishmonger 0
3949724 2006981 2006981 plaintiff Farmer Richard clothworker 658571 658571 Farmer, Richard, of Lonon, clothworker 0
3967799 2013367 2013367 defendant Savylle William esq 658571 658571 Savylle, William, of Lonon, gent, or of Pellom, Lincs, esq 0
3977248 2016613 2016613 defendant Grigston Thomas carpenter 658571 658571 Grigston, Thomas, of Lonon, carpenter 0
4030379 2035518 2035518 defendant Ognall Richard gent 658571 658571 Ognall, Richard, of Lonon, or of Pen, Bucks, gent 0
4047380 2041519 2041519 defendant Osbaston Sebastian gent 658571 658571 Osbaston, Sebastian, of Lonon, or of Warwick, gent 0
4047383 2041520 2041520 defendant Osbaston Sebastian gent 658571 658571 Osbaston, Sebastian, of Lonon, or of Warwick, gent 0
4101211 2060742 2060742 defendant Duke John tanner 658571 658571 Duke, John, of Lonon, or of Dunnington, Berks, tanner 1
4106941 2062776 2062776 defendant Powrnall John yeoman 658571 658571 Powrnall, John, of Lonon, or of Church Bedfount, Middx, yeoman 1
4114032 2065301 2065301 defendant Horne William yeoman 658571 658571 Horne, William, of Lonon, or of Gaunt, Stanelack, Oxon, yeoman 0
4120431 2067583 2067583 defendant Gardyner Christopher gent 658571 658571 Gardyner, Christopher, of Lonon, or of Inner Temple, gent 1
4125096 2069265 2069265 defendant Turtell Roger tailor 658571 658571 Turtell, Roger, of Lonon, or of Holborne, Middx, tailor 1
4167369 2084086 2084086 defendant Scare Walter carpenter 658571 658571 Scare, Walter, of Lonon, or of Kent, carpenter 0
4169724 2084900 2084900 defendant Poynt Nicholas   658571 658571 Poynt, Nicholas, of Lonon, knight 1
4205282 2097396 2097396 defendant Hylpe John gent 658571 658571 Hylpe, John, of Lonon, or of Inner Temple, gent 3
4223263 2103628 2103628 defendant Paynell William yeoman 658571 658571 Paynell, William, of Lonon, or of Upper Woodhall, Yorks, yeoman 0
4268578 2119088 2119088 defendant Higham Clement   658571 658571 Higham, Clement, of Lonon, or of Barrowe, Suff, knight 0
4383152 2159082 2159082 defendant verch Ithell Agnes widow 658571 658571 verch Ithell, Agnes, of Lonon, or of Quermesfild, Flint, widow 0
4384304 2159444 2159444 defendant Harrington Richard   658571 658571 Harrington, Richard, of Lonon, or of Sterkote, Hallifax, Yorks woolman 2
4388942 2160934 2160934 defendant Scott Henry butcher 658571 658571 Scott, Henry, of Lonon, butcher 0
4401282 2165024 2165024 defendant Baker John merchant 658571 658571 Baker, John, of Lonon, or of Exeter, merchant 0
5060669 2374771 2374771 plaintiff Fyssher Robert draper 658571 658571 Fyssher,Robert, of Lonon, draper 0
5075402 2379138 2379138 plaintiff Garstank Robert grocer 658571 658571 Garstank, Robert, of Lonon, grocer 2
5076079 2379345 2379345 plaintiff Auntronus William (legal representative) 658571 658571 Auntronus, William, of Lonon, tailor, executor of 0
5078344 2380016 2380016 plaintiff Brittell Thomas mercer 658571 658571 Brittell, Thomas, of Lonon, mercer 0
5088177 2382915 2382915 defendant Frebarne John lighterman 658571 658571 Frebarne, John, of Lonon, lighterman 0
5088178 2382915 2382915 defendant Davy Edward lighterman 658571 658571 Davy, Edward, of Lonon, lighterman 1
5088179 2382915 2382915 defendant Bryan John lighterman 658571 658571 Bryan, John, of Lonon, lighterman 2
5088181 2382915 2382915 defendant Chamberleyn Richard lighterman 658571 658571 Chamberleyn, Richard, of Lonon, lighterman 4
5088182 2382915 2382915 defendant Vannost Henry lighterman 658571 658571 Vannost, Henry, of Lonon, lighterman 5
5088183 2382915 2382915 defendant Gilford William lighterman 658571 658571 Gilford, William, of Lonon, lighterman 6
5095263 2385033 2385033 plaintiff Shayle Thomas (legal representative) 658571 658571 Shayle, Thomas, of Lonon, fishmonger, executrix of 0
5105050 2387909 2387909 defendant Moungomery Thomas esq 658571 658571 Moungomery, Thomas, of Lonon, esq 1
5107307 2388566 2388566 plaintiff Derby John draper 658571 658571 Derby, John, of Lonon, draper 0
5199275 2415541 2415541 plaintiff Warter Christopher skinner 658571 658571 Warter, Christopher, of Lonon, skinner 0
5211763 2419185 2419185 defendant Robyns John chaplain 658571 658571 Robyns, John, of Lonon, chaplain 0
5216081 2420431 2420431 defendant Lynton John gent 658571 658571 Lynton, John, of Lonon, gent 1
5226865 2423521 2423521 defendant Bastard Thomas   658571 658571 Bastard, Thomas, of Lonon, servant 1
5234970 2425809 2425809 defendant Neweton Richard gent 658571 658571 Neweton, Richard, of Lonon, gent 0
5254314 2431478 2431478 plaintiff Busshebury Richard grocer 658571 658571 Busshebury, Richard, of Lonon, grocer 0
5278170 2438710 2438710 defendant Bolt John clothmaker 658571 658571 Bolt, John, of Lonon, clothmaker 0
5288723 2441719 2441719 plaintiff Lyghtwode William draper 658571 658571 Lyghtwode, William,of Lonon, draper 0
5318384 2450594 2450594 plaintiff Godard John (legal representative) 658571 658571 Godard, John, of Lonon, brewer, executors of 0
5324758 2452480 2452480 defendant Vivyan Richard gent 658571 658571 Vivyan, Richard, of Lonon, gent 0
5329037 2453763 2453763 defendant Aldewyn Roger courser 658571 658571 Aldewyn, Roger, of Lonon, courser 2
5342168 2457743 2457743 defendant Hervy John clerk 658571 658571 Hervy, John, of Lonon, clerk 2

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