names

35 rows where place_id = 592436

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607690 1870060 1870060 plaintiff Hore Richard brewer 592436 592436 Hore, Richard, of Southwarke, brewer 1
3681706 1920375 1920375 defendant Bradley John smith 592436 592436 Bradley, John, of Southwarke, smith 2
3765147 1946761 1946761 defendant Mayes William waterman 592436 592436 Mayes, William, of Southwarke, waterman 0
3804408 1959315 1959315 defendant Streyttysley John yeoman 592436 592436 Streyttysley, John, of Southwarke, yeoman 0
3805981 1959806 1959806 defendant Boyar John butcher 592436 592436 Boyar, John, of Southwarke, butcher 1
3805986 1959807 1959807 defendant Boyar John butcher 592436 592436 Boyar, John, of Southwarke, butcher 1
3812673 1961854 1961854 plaintiff Crosse John brewer 592436 592436 Crosse, John, of Southwarke, brewer 0
3812675 1961855 1961855 plaintiff Crosse John innholder 592436 592436 Crosse, John, of Southwarke, innholder 0
3841908 1971039 1971039 defendant Acton Robert gent 592436 592436 Acton, Robert, of Southwarke, gent 1
3845777 1972227 1972227 defendant Kellet William merchant tailor 592436 592436 Kellet, William, of Southwarke, merchant tailor 2
3853891 1974852 1974852 defendant Rowley John yeoman 592436 592436 (Rowley, John, of Southwarke, yeoman 1
3871976 1980863 1980863 plaintiff Barwycke John tailor 592436 592436 Barwycke, John, of Southwarke, tailor 0
3881349 1984027 1984027 defendant Halle Robert laborer 592436 592436 Halle, Robert, of Southwarke, laborer 0
3894861 1988488 1988488 defendant Alen John butcher 592436 592436 Alen, John, of Southwarke, butcher 0
3899362 1989999 1989999 plaintiff Benett John tailor 592436 592436 Benett, John, of Southwarke, tailor 0
3912095 1994368 1994368 defendant Norman John tailor 592436 592436 Norman, John, of Southwarke, tailor 0
3913417 1994824 1994824 plaintiff Benett John tailor 592436 592436 Benett, John, of Southwarke, tailor 0
3913419 1994825 1994825 plaintiff Benett John tailor 592436 592436 Benett, John, of Southwarke, tailor 0
3950725 2007328 2007328 plaintiff Gent Thomas yeoman 592436 592436 Gent, Thomas, of Southwarke, yeoman 0
3953051 2008131 2008131 defendant Grynder William yeoman 592436 592436 Grynder, William, of Southwarke, yeoman 1
4104262 2061802 2061802 defendant Hyckes Richard gent 592436 592436 Hyckes, Richard, of Southwarke, gent 0
4138116 2073997 2073997 defendant Brooke Thomas carman 592436 592436 Brooke, Thomas, of Southwarke, carman 0
4163153 2082643 2082643 defendant Downynge William chandler 592436 592436 Downynge, William, of Southwarke, chandler 0
4185710 2090505 2090505 defendant Johnson James shoemaker 592436 592436 Johnson, James, of Southwarke, shoemaker 0
4353007 2148280 2148280 defendant Clarke William yeoman 592436 592436 Clarke, William, of Southwarke, yeoman 0
4363347 2151962 2151962 defendant Bowman Agnes widow 592436 592436 Bowman, Agnes, of Southwarke, widow 1
4392383 2162078 2162078 defendant Rodes Ralph draper 592436 592436 Rodes, Ralph, of Southwarke, draper 1
4392386 2162079 2162079 defendant Rodes Ralph draper 592436 592436 Rodes, Ralph, of Southwarke, draper 1
5350855 2460380 2460380 defendant Marche Robert butcher 592436 592436 Marche, Robert, of Southwarke, butcher 0
5350856 2460380 2460380 defendant Short John butcher 592436 592436 Short, John, of Southwarke, butcher 1
5350857 2460380 2460380 defendant Hamond Robert butcher 592436 592436 Hamond, Robert, of Southwarke, butcher 2
5595125 2533444 2533444 defendant Dyneley or Dyveley Francis gent 592436 592436 Dyneley or Dyveley, Francis, of Southwarke, gent 2
5600554 2535064 2535064 defendant Donmowe Thomas waterman 592436 592436 Donmowe, Thomas, of Southwarke, waterman 0
5600555 2535064 2535064 defendant Standysshe Roger sawyer 592436 592436 Standysshe, Roger, of Southwarke, sawyer 1
5600556 2535064 2535064 defendant Messenger Richard butcher 592436 592436 Messenger, Richard, of Southwarke, butcher 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);