names

18 rows where place_id = 757035

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4442545 2182619 2182619 defendant Gylle Richard   757035 757035 Gylle, Richard, of West Merseye 2
4447189 2184026 2184026 defendant Gylle Richard   757035 757035 Gylle, Richard, of West Merseye 2
4493999 2198812 2198812 defendant Stefenes John   757035 757035 Stefenes, John, of West Merseye 8
4494000 2198812 2198812 defendant Stephenes Richard   757035 757035 Stephenes, Richard, of West Merseye 9
4494001 2198812 2198812 defendant Pod John   757035 757035 Pod, John, of West Merseye 10
4494002 2198812 2198812 defendant Balent John   757035 757035 Balent, John, of West Merseye 11
4494003 2198812 2198812 defendant Martell Richard   757035 757035 Martell, Richard, of West Merseye 12
4494004 2198812 2198812 defendant Busshe Richard   757035 757035 Busshe, Richard, of West Merseye 13
4494193 2198874 2198874 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 12
4494479 2198969 2198969 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 12
4494494 2198970 2198970 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 12
4496876 2199689 2199689 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 12
4503685 2201724 2201724 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 12
4504073 2201821 2201821 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 12
4504641 2201994 2201994 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 13
4506623 2202551 2202551 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 12
4507304 2202749 2202749 defendant Stephene Richard   757035 757035 Stephene, Richard, of West Merseye 12
4658208 2248447 2248447 defendant Wolnet Robert yeoman 757035 757035 Wolnet, Robert, of West Merseye, yeoman 1

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