names

48 rows where place_id = 596613

✎ 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
3625505 1875516 1875516 defendant Wylson John pinner 596613 596613 Wylson, John, of Suthwark, pinner 4
3625902 1902955 1902955 defendant Adhams Christopher yeoman 596613 596613 Adhams, Christopher, of Suthwark, yeoman 0
3664928 1914976 1914976 defendant Huskyn Peter   596613 596613 Huskyn, Peter, of Suthwark, surgeon 0
3664929 1914976 1914976 defendant Johnson Isabrardus   596613 596613 Johnson, Isabrardus, of Suthwark, shoe maker 1
3679839 1919759 1919759 defendant Coddyng John butcher 596613 596613 Coddyng, John, of Suthwark, butcher 0
3680343 1919929 1919929 defendant Haryson John baker 596613 596613 Haryson, John, of Suthwark, baker 0
3684349 1921237 1921237 defendant Raynbot John hatmaker 596613 596613 Raynbot, John, of Suthwark, hatmaker 2
3687188 1922169 1922169 defendant Burwell John gent 596613 596613 Burwell, John, of Suthwark, gent 0
3687190 1922170 1922170 defendant Burwell John gent 596613 596613 Burwell, John, of Suthwark, gent 0
3735272 1937267 1937267 defendant Hobbard John vintner 596613 596613 Hobbard, John, of Suthwark, vintner 0
3735274 1937267 1937267 defendant Bedyll Helen widow 596613 596613 Bedyll, Helen, of Suthwark, widow 2
3753987 1943198 1943198 defendant Myles Thomas yeoman 596613 596613 Myles, Thomas, of Suthwark, yeoman 0
3790819 1954954 1954954 defendant Bysshopp Thomas leather seller 596613 596613 Bysshopp, Thomas, of Suthwark, leather seller 0
3795017 1956306 1956306 defendant Grene Thomas yeoman 596613 596613 Grene, Thomas, of Suthwark, yeoman 1
3795018 1956306 1956306 defendant Wyseman Nicholas whitawer 596613 596613 Wyseman, Nicholas, of Suthwark, whitawer 2
3795019 1956306 1956306 defendant Harford John   596613 596613 Harford, John, of Suthwark, fell monger 3
3795020 1956306 1956306 defendant Kendall Thomas   596613 596613 Kendall, Thomas, of Suthwark, fell monger 4
3795021 1956306 1956306 defendant Lamberd Martin smith 596613 596613 Lamberd, Martin, of Suthwark, smith 5
3817217 1963300 1963300 defendant Stanbank Thomas baker 596613 596613 Stanbank, Thomas, of Suthwark, baker 0
3836531 1969330 1969330 defendant Borowe John yeoman 596613 596613 Borowe, John, of Suthwark, yeoman 0
3840843 1970707 1970707 defendant Muschean William butcher 596613 596613 Muschean, William, of Suthwark, butcher 0
3840844 1970707 1970707 defendant Warde Thomas butcher 596613 596613 Warde, Thomas, of Suthwark, butcher 1
3840845 1970707 1970707 defendant Hardyng John currier 596613 596613 Hardyng, John, of Suthwark, currier 2
3852167 1974275 1974275 defendant Markes Alexander baker 596613 596613 Markes, Alexander, of Suthwark, baker 1
3852168 1974275 1974275 defendant Lynne John currier 596613 596613 Lynne, John, of Suthwark, currier 2
3853589 1974749 1974749 defendant Allen John butcher 596613 596613 Allen, John, of Suthwark, butcher 0
3853591 1974749 1974749 defendant Tayllour Thomas tailor 596613 596613 Tayllour, Thomas, of Suthwark, tailor 2
3853592 1974749 1974749 defendant Cooke William carpenter 596613 596613 Cooke, William, of Suthwark, carpenter 3
3869414 1980010 1980010 defendant Hylton Roger vintner 596613 596613 Hylton, Roger, of Suthwark, vintner 0
3874633 1981735 1981735 defendant Copewood Ralph skinner 596613 596613 (Copewood, Ralph, of Suthwark, skinner 1
3874634 1981735 1981735 defendant Kellet Margaret widow 596613 596613 Kellet, Margaret, of Suthwark, widow 2
3902894 1991199 1991199 defendant Ewstas John yeoman 596613 596613 Ewstas, John, of Suthwark, yeoman 0
3906819 1992570 1992570 defendant Abraham Walter brewer 596613 596613 Abraham, Walter, of Suthwark, brewer 2
5102455 2387120 2387120 defendant Unwyn John   596613 596613 Unwyn, John, of Suthwark, sandyour or saudyour or soldier 3
5297697 2444331 2444331 defendant Bocher Roger butcher 596613 596613 Bocher, Roger, of Suthwark, butcher 3
5397409 2474344 2474344 defendant Hopton alias Upton Richard chaplain 596613 596613 Hopton alias Upton, Richard, of Suthwark, chaplain 0
5490358 2502009 2502009 defendant Borough John tanner 596613 596613 Borough, John, of Suthwark, tanner 0
5532724 2514786 2514786 plaintiff Vansorn Frederick goldsmith 596613 596613 Vansorn, Frederick, of Suthwark, goldsmith 0
5554963 2521453 2521453 defendant Galaway William smith 596613 596613 Galaway, William, of Suthwark, smith 4
5561488 2523340 2523340 defendant Osbarne Thomas tailor 596613 596613 Osbarne, Thomas, of Suthwark, tailor 0
5593419 2532923 2532923 plaintiff Fannestrete Cornelius   596613 596613 Fannestrete, Cornelius, of Suthwark, tapestry maker 1
5593828 2533055 2533055 defendant Dyker Joan widow 596613 596613 Dyker, Joan, of Suthwark, widow 1
5595131 2533446 2533446 defendant Wryght Thomas tailor 596613 596613 Wryght, Thomas, of Suthwark, tailor 2
5595147 2533451 2533451 defendant Wryght Thomas tailor 596613 596613 Wryght, Thomas, of Suthwark, tailor 0
5596852 2533936 2533936 defendant Massyngham Thomas gent 596613 596613 Massyngham, Thomas, of Suthwark, gent 0
5596856 2533936 2533936 defendant Coke Christopher yeoman 596613 596613 Coke, Christopher, of Suthwark, yeoman 4
5596864 2533938 2533938 defendant Curteys Robert yeoman 596613 596613 Curteys, Robert, of Suthwark, yeoman 4
5599529 2534746 2534746 defendant Goldsmyth Richard brasier 596613 596613 Goldsmyth, Richard, of Suthwark, brasier 1

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