names

26 rows where place_id = 586774

✎ 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
3589582 1864381 1864381 defendant Bulbek William baker 586774 586774 Bulbek, William, of St Johns Strete, Middx, baker 0
3589585 1864382 1864382 defendant Hicson Thomas baker 586774 586774 Hicson, Thomas, of St Johns Strete, Middx, baker 0
3590272 1864602 1864602 defendant Mors Thomas butcher 586774 586774 Mors, Thomas, of St Johns Strete, Middx, butcher 4
3590279 1864603 1864603 defendant More Thomas butcher 586774 586774 More, Thomas, of St Johns Strete, Middx, butcher 5
3625910 1902959 1902959 plaintiff Acton Hugh courser 586774 586774 Acton, Hugh, of St Johns Strete, Middx, courser 0
3625912 1902960 1902960 plaintiff Acton Hugh courser 586774 586774 Acton, Hugh, of St Johns Strete, Middx, courser 0
3626810 1903235 1903235 defendant Hatton Hugh courser 586774 586774 Hatton, Hugh, of St Johns Strete, Middx, courser 0
3632173 1904877 1904877 plaintiff Hatton Hugh courser 586774 586774 Hatton, Hugh, of St Johns Strete, Middx, courser 0
3846060 1972327 1972327 defendant Grey Elizabeth widow 586774 586774 Grey, Elizabeth, of St Johns Strete, Middx, widow 2
3855409 1975333 1975333 defendant Wellys Henry yeoman 586774 586774 Wellys, Henry, of St Johns Strete, Middx, yeoman 0
3855413 1975334 1975334 defendant Wellys Henry yeoman 586774 586774 Wellys, Henry, of St Johns Strete, Middx, yeoman 0
3855417 1975335 1975335 defendant Wellys Henry yeoman 586774 586774 Wellys, Henry, of St Johns Strete, Middx, yeoman 0
3897588 1989405 1989405 defendant ap Robarte William baker 586774 586774 ap Robarte, William, of St Johns Strete, Middx, baker 0
3960202 2010668 2010668 plaintiff Steven Robert   586774 586774 Steven, Robert, of St Johns Strete, Middx 0
3985755 2019667 2019667 plaintiff Walton James innholder 586774 586774 Walton, James, of St Johns Strete, Middx, innholder 0
4017208 2030859 2030859 defendant Wood Alexander butcher 586774 586774 Wood, Alexander, of St Johns Strete, Middx, butcher 0
4026700 2034194 2034194 plaintiff Cannon Thomas skinner 586774 586774 Cannon, Thomas, of St Johns Strete, Middx, skinner 0
4082723 2054129 2054129 defendant Chamberleyn alias Johns William tailor 586774 586774 Chamberleyn alias Johns, William, of St Johns Strete, Middx, tailor 0
4086006 2055271 2055271 defendant Spencer Anthony yeoman 586774 586774 Spencer, Anthony, of St Johns Strete, Middx, yeoman 3
4184975 2090251 2090251 defendant Cooper John butcher 586774 586774 Cooper, John, of St Johns Strete, Middx, butcher 0
4203582 2096807 2096807 defendant Chamberlayne Robert esq 586774 586774 Chamberlayne, Robert, of St Johns Strete, Middx, esq 1
4277844 2122177 2122177 defendant Gould William blacksmith 586774 586774 Gould, William, of St Johns Strete, Middx, yeoman, blacksmith 0
5487899 2501270 2501270 defendant Anderton James butcher 586774 586774 Anderton, James, of St Johns Strete, Middx, butcher 0
5487901 2501271 2501271 defendant Anderton James butcher 586774 586774 Anderton, James, of St Johns Strete, Middx, butcher 0
5491871 2502478 2502478 defendant Henfre- William drover 586774 586774 Henfre-, William, of St Johns Strete, Middx, drover 0
5600098 2534915 2534915 plaintiff Hatton Hugh yeoman 586774 586774 Hatton, Hugh, of St Johns Strete, Middx, yeoman 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);