names

8 rows where place_id = 622532

✎ 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
3747548 1941148 1941148 defendant Codner William yeoman 622532 622532 Codner, William, of St Mary Churche, yeoman 0
3747550 1941149 1941149 defendant Drewe Roger yeoman 622532 622532 Drewe, Roger, of St Mary Churche, yeoman 0
3747552 1941150 1941150 defendant Drewe Thomas yeoman 622532 622532 Drewe, Thomas, of St Mary Churche, yeoman 0
4982123 2351570 2351570 defendant Michell Thomas shipman 622532 622532 Michell, Thomas, of St Mary Churche, shipman 0
5087415 2382696 2382696 defendant Murry John   622532 622532 Murry, John, of St Mary Churche, bailiff 15
5236573 2426284 2426284 defendant Michell Thomas seaman 622532 622532 Michell, Thomas, of St Mary Churche, seaman 0
5239071 2427021 2427021 plaintiff Heckeway Walter   622532 622532 Heckeway, Walter, of St Mary Churche 0
5324061 2452284 2452284 defendant Murrey John yeoman 622532 622532 Murrey, John, of St Mary Churche, 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);