names

16 rows where place_id = 640311

✎ 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
3854567 1975072 1975072 defendant Chadwyk Arthur clerk 640311 640311 Chadwyk, Arthur, of St Sepulchre, London, clerk 0
3876267 1982302 1982302 defendant Bulloke Richard gent 640311 640311 Bulloke, Richard, of St Sepulchre, London, gent 4
3968459 2013602 2013602 plaintiff Chylde Agnes widow 640311 640311 Agnes his wife, alias Agnes Rudkyn, of St Sepulchre, London, widow 1
4012686 2029261 2029261 plaintiff Parkyns Henry weaver 640311 640311 Parkyns, Henry, of St Sepulchre, London, weaver 1
4018378 2031305 2031305 plaintiff Tyson Brian (legal representative) 640311 640311 Tyson, Brian, of St Sepulchre, London, gent, administrator of 0
4240534 2109817 2109817 defendant Conwaye William grocer 640311 640311 Conwaye, William, of St Sepulchre, London, grocer 1
4263498 2117455 2117455 defendant Conwaye William grocer 640311 640311 Conwaye, William, of St Sepulchre, London, grocer 1
4267366 2118722 2118722 defendant Arye or Ayre Christopher tailor 640311 640311 Arye or Ayre, Christopher, of St Sepulchre, London, tailor 1
4288483 2125928 2125928 defendant Swetman William cutler 640311 640311 Swetman, William, of St Sepulchre, London, cutler 2
4298952 2129720 2129720 defendant Griffin Ralph victualer 640311 640311 Griffin, Ralph, of St Sepulchre, London, victualer 0
4335246 2142061 2142061 defendant Homes Robert porter 640311 640311 Homes, Robert, of St Sepulchre, London, porter 2
4346736 2146112 2146112 defendant Strange George saddler 640311 640311 Strange, George, of St Sepulchre, London, saddler 1
5307081 2447118 2447118 defendant Smyth John yeoman 640311 640311 Smyth, John, of St Sepulchre, London, yeoman 0
5483706 2500077 2500077 plaintiff Chamberleyn John ironmonger 640311 640311 Chamberleyn, John, of St Sepulchre, London, ironmonger 1
5483709 2500078 2500078 plaintiff Chamberleyn John ironmonger 640311 640311 Chamberleyn, John, of St Sepulchre, London, ironmonger 1
5567991 2525203 2525203 defendant Grenrigge John cordwainer 640311 640311 Grenrigge, John, of St Sepulchre, London, cordwainer 5

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