names

75 rows where place_id = 778173

✎ 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
4652318 2246678 2246678 plaintiff Ayleward Richard merchant 778173 778173 Ayleward, Richard, of St Botolph, merchant 0
4652320 2246679 2246679 plaintiff Ayleward Richard merchant 778173 778173 Ayleward, Richard, of St Botolph, merchant 0
4657502 2248240 2248240 plaintiff Cok John   778173 778173 Cok, John, of St Botolph 0
4660373 2249072 2249072 defendant Burthe or Burche William spicer 778173 778173 Burthe or Burche, William, of St Botolph, spicer 1
4660376 2249073 2249073 defendant Skelton John   778173 778173 Skelton, John, of St Botolph 0
4781015 2290069 2290069 plaintiff Castanhet Elias vintner 778173 778173 Castanhet, Elias, of St Botolph, vintner 0
4781018 2290069 2290069 defendant Galle William merchant 778173 778173 Galle, William, of St Botolph, merchant 1
4781279 2290158 2290158 plaintiff Chastenhet Elias vintner 778173 778173 Chastenhet, Elias, of St Botolph, vintner 0
4783187 2290756 2290756 defendant Benete William summoner 778173 778173 Benete, William, of St Botolph, summoner 1
4783896 2290980 2290980 plaintiff de Pynchebek Richard (legal representative) 778173 778173 de Pynchebek, Richard, of St Botolph, executors of 0
4783898 2290980 2290980 plaintiff Baker John   778173 778173 Baker, John, of St Botolph 2
4785299 2291419 2291419 defendant Wattys William draper 778173 778173 Wattys, William, of St Botolph, draper 0
4787469 2292152 2292152 plaintiff Gull John   778173 778173 Gull, John, of St Botolph 0
4787470 2292152 2292152 plaintiff de Spaldyng Thomas chaplain 778173 778173 de Spaldyng, Thomas, of St Botolph, chaplain 1
4790485 2293114 2293114 defendant Capmaker alias Watirman William dyer 778173 778173 Capmaker alias Watirman, William, of St Botolph, dyer 1
4790739 2293190 2293190 plaintiff Latoner Henry merchant 778173 778173 Latoner, Henry, of St Botolph, merchant 0
4792787 2293832 2293832 defendant Porter Henry mercer 778173 778173 Porter, Henry, of St Botolph, mercer 0
4794180 2294318 2294318 defendant Wryght John mercer 778173 778173 Wryght, John, of St Botolph, mercer 0
4794478 2294410 2294410 defendant Goldesburgh Severius   778173 778173 Goldesburgh, Severius, of St Botolph, bailiff 0
4860694 2314706 2314706 plaintiff Cok John (legal representative) 778173 778173 Cok, John, of St Botolph, executor of 0
4860695 2314706 2314706 plaintiff Hert John   778173 778173 Hert, John, of St Botolph 1
4861168 2314853 2314853 defendant Bower Thomas chapman 778173 778173 Bower, Thomas, of St Botolph, chapman 0
4871299 2317991 2317991 defendant Eston Henry merchant 778173 778173 Eston, Henry, of St Botolph, merchant 0
4875239 2319210 2319210 defendant Coke John merchant 778173 778173 Coke, John, of senior, St Botolph, merchant 0
4875240 2319210 2319210 defendant Coke John merchant 778173 778173 Coke, John, of junior, St Botolph, merchant 1
4878982 2320357 2320357 plaintiff Torkesey Thomas merchant 778173 778173 Torkesey, Thomas, of St Botolph, merchant 0
4878984 2320357 2320357 plaintiff Ardern Richard mercer 778173 778173 Ardern, Richard, of St Botolph, mercer 2
4878985 2320357 2320357 defendant Hunnyng John smith 778173 778173 Hunnyng, John, of St Botolph, smith 0
4878986 2320357 2320357 defendant Bole James spicer 778173 778173 Bole, James, of St Botolph, spicer 1
4878989 2320358 2320358 plaintiff Torkesey Thomas merchant 778173 778173 Torkesey, Thomas, of St Botolph, merchant 0
4878991 2320358 2320358 plaintiff Ardern Richard mercer 778173 778173 Ardern, Richard, of St Botolph, mercer 2
4878992 2320358 2320358 defendant Hunyng John smith 778173 778173 Hunyng, John, of St Botolph, smith 0
4878993 2320358 2320358 defendant Bole James spicer 778173 778173 Bole, James, of St Botolph, spicer 1
4881174 2321020 2321020 plaintiff Flete Thomas   778173 778173 Flete, Thomas, of St Botolph 2
4882111 2321306 2321306 plaintiff Baker John (legal representative) 778173 778173 Baker, John, of St Botolph, chaplain, executors of 0
4882112 2321306 2321306 plaintiff Willyngham Robert   778173 778173 (Willyngham, Robert, of St Botolph 1
4882113 2321306 2321306 plaintiff Rasyn Richard chaplain 778173 778173 Rasyn, Richard, of St Botolph, chaplain 2
4882114 2321306 2321306 plaintiff Burgh Thomas chaplain 778173 778173 Burgh, Thomas, of St Botolph, chaplain 3
4882766 2321530 2321530 plaintiff Wylyngham Robert   778173 778173 Wylyngham, Robert, of St Botolph 0
4882767 2321530 2321530 plaintiff Flete Thomas   778173 778173 Flete, Thomas, of St Botolph 1
4885303 2322292 2322292 defendant Ogeham John dyer 778173 778173 Ogeham, John, of St Botolph, dyer 0
4887819 2323019 2323019 defendant Chosill Thomas, junior gent 778173 778173 Chosill, Thomas, junior, of St Botolph, gent 0
4888233 2323128 2323128 defendant Scotte Walter husbandman 778173 778173 Scotte, Walter, of St Botolph, son of Scotte, William, of St Botolph, fisher, Richard son of Thomason, John, of Holbech, husbandman 1
4890414 2323768 2323768 plaintiff Ardern Richard mercer 778173 778173 Ardern, Richard, of St Botolph, mercer 0
4892099 2324271 2324271 defendant Chosell Thomas, junior gent 778173 778173 Chosell, Thomas, junior, of St Botolph, gent 0
4892100 2324271 2324271 defendant Daubere John pewterer 778173 778173 Daubere, John, of St Botolph, pewterer 1
4892121 2324276 2324276 plaintiff Wodethorp John merchant 778173 778173 Wodethorp, John, of St Botolph, merchant 0
4893196 2324587 2324587 defendant Warcope William chapman 778173 778173 Warcope, William, of St Botolph, chapman 1
4898937 2326310 2326310 plaintiff Goldyng John   778173 778173 Goldyng, John, of St Botolph 0
4900600 2326829 2326829 defendant Wawyn Richard butcher 778173 778173 Wawyn, Richard, of St Botolph, butcher 2
4900670 2326851 2326851 plaintiff Willyngham Robert   778173 778173 (Willyngham, Robert, of St Botolph, "vir disponsatus" 1
4900671 2326851 2326851 plaintiff Rasyn Richard chaplain 778173 778173 Rasyn, Richard, of St Botolph, chaplain 2
4900672 2326851 2326851 plaintiff Burgh Thomas chaplain 778173 778173 Burgh, Thomas, of St Botolph, chaplain 3
4933666 2336906 2336906 defendant Chosell Thomas, junior gent 778173 778173 Chosell, Thomas, junior, of St Botolph, gent 0
4934110 2337054 2337054 plaintiff Ardern Richard mercer 778173 778173 Ardern, Richard, of St Botolph, mercer 0
4934111 2337054 2337054 defendant Hunnyng John smith 778173 778173 Hunnyng, John, of St Botolph, smith 0
4935100 2337387 2337387 plaintiff Baxter John merchant 778173 778173 Baxter, John, of St Botolph, merchant 0
4940187 2338964 2338964 plaintiff Daweber John   778173 778173 Daweber, John, of St Botolph, pewterer, administrators of 0
4950137 2342009 2342009 plaintiff Stoyle John mercer 778173 778173 Stoyle, John, of St Botolph, mercer 1
4950139 2342009 2342009 defendant Belle William merchant 778173 778173 Belle, William, of St Botolph, merchant 1
4950141 2342010 2342010 plaintiff Stoyle John mercer 778173 778173 Stoyle, John, of St Botolph, mercer 1
4950143 2342010 2342010 defendant Belle William merchant 778173 778173 Belle, William, of St Botolph, merchant 1
4960194 2345021 2345021 plaintiff Barette Thomas chaplain 778173 778173 Barette, Thomas, of St Botolph, chaplain 0
4960828 2345199 2345199 defendant Hugon William merchant 778173 778173 Hugon, William, of St Botolph, merchant 0
4979883 2350938 2350938 defendant Wr- Richard chapman 778173 778173 Wr-, Richard, of St Botolph, chapman 0
5036179 2367437 2367437 plaintiff Upton William gent 778173 778173 Upton, William, of St Botolph, gent 0
5074552 2378892 2378892 plaintiff Wodethorp John merchant 778173 778173 Wodethorp, John, of St Botolph, merchant 0
5074555 2378893 2378893 plaintiff Wodethorp John merchant 778173 778173 Wodethorp, John, of St Botolph, merchant 0
5624298 2551546 2551546 defendant de Rasyn John merchant 778173 778173 de Rasyn, John, of St Botolph, merchant 0
5625765 2552001 2552001 plaintiff Martyn Frederic merchant 778173 778173 Martyn, Frederic, of St Botolph, merchant 0
5625766 2552001 2552001 plaintiff Glaston William draper 778173 778173 Glaston, William, of St Botolph, draper 1
5628729 2552955 2552955 defendant Pepir John vintner 778173 778173 Pepir, John, of St Botolph, vintner 0
5628730 2552955 2552955 defendant Tournour John vintner 778173 778173 Tournour, John, of St Botolph, vintner 1
5629691 2553277 2553277 defendant Aleyn Richard chaplain 778173 778173 Aleyn, Richard, of St Botolph, chaplain 0
5634631 2554829 2554829 defendant Skelton John spicer 778173 778173 Skelton, John, of St Botolph, spicer 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);