names

12 rows where place_id = 670495

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3970484 2014272 2014272 defendant Panell John mercer 670495 670495 Panell, John, of St Clement Danes without Temple Bar, Middx, yeoman, alias John Plamer, of London, mercer 0
3997312 2023810 2023810 defendant Buck Richard tailor 670495 670495 Buck, Richard, of St Clement Danes without Temple Bar, Middx, tailor 0
4009887 2028312 2028312 defendant Cooke Robert gent 670495 670495 Cooke, Robert, of St Clement Danes without Temple Bar, Middx, gent 0
4066777 2048418 2048418 defendant Tompson Robert chandler 670495 670495 Tompson, Robert, of St Clement Danes without Temple Bar, Middx, chandler 1
4099666 2060204 2060204 defendant Francklyn William tailor 670495 670495 Francklyn, William, of St Clement Danes without Temple Bar, Middx, tailor 0
4136087 2073248 2073248 defendant Dwelly Andrew gent 670495 670495 Dwelly, Andrew, of St Clement Danes without Temple Bar, Middx, gent 0
4138246 2074046 2074046 defendant Kynwelmarshe John gent 670495 670495 Kynwelmarshe, John, of St Clement Danes without Temple Bar, Middx, gent 0
4155385 2079976 2079976 defendant Grene John butcher 670495 670495 Grene, John, of St Clement Danes without Temple Bar, Middx, butcher 2
4165231 2083348 2083348 defendant Lumey or Linney or Luney John tailor 670495 670495 Lumey or Linney or Luney, John, of St Clement Danes without Temple Bar, Middx, tailor 1
4202431 2096390 2096390 defendant Peirson John scrivener 670495 670495 Peirson, John, of St Clement Danes without Temple Bar, Middx, scrivener 1
4204140 2097001 2097001 defendant Higham John tailor 670495 670495 Higham, John, of St Clement Danes without Temple Bar, Middx, tailor 2
4297145 2129079 2129079 defendant Kidgell John cutler 670495 670495 Kidgell, John, of St Clement Danes without Temple Bar, Middx, cutler 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);