names

12 rows where place_id = 650897

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3914541 1995208 1995208 defendant Snede Richard   650897 650897 Snede, Richard, of Crewe, Cheshire 2
3914545 1995209 1995209 defendant Fulleshurst Thomas   650897 650897 Fulleshurst, Thomas, of Crewe, Cheshire, knight 0
3954676 2008701 2008701 defendant Fulleshurst Robert esq 650897 650897 Fulleshurst, Robert, of Crewe, Cheshire, esq 1
3984622 2019258 2019258 defendant Fulleshurst Robert esq 650897 650897 Fulleshurst, Robert, of Crewe, Cheshire, esq 0
4025590 2033807 2033807 defendant Fullehurst Robert   650897 650897 Fullehurst, Robert, of Crewe, Cheshire, esq, son of Thomas Fullehurst, knight 0
4025592 2033808 2033808 defendant Fullehurst Robert   650897 650897 Fullehurst, Robert, of Crewe, Cheshire, esq, son of Thomas, Fullehurst, knight 0
4136318 2073334 2073334 defendant Erdley Thomas yeoman 650897 650897 Erdley, Thomas, of Crewe, Cheshire, yeoman 1
4314027 2135016 2135016 defendant Woodd Thomas gent 650897 650897 Woodd, Thomas, of Crewe, Cheshire, gent 1
5307236 2447166 2447166 defendant Fouleshurste Robert gentleman 650897 650897 Fouleshurste, Robert, of Crewe, Cheshire, gentleman 1
5340666 2457280 2457280 defendant Broke John yeoman 650897 650897 Broke, John, of Crewe, Cheshire, yeoman 2
5382643 2470093 2470093 defendant Fulfist Robert   650897 650897 Fulfist, Robert, of Crewe, Cheshire 2
5548264 2519523 2519523 defendant Fouleshurst Thomas esq 650897 650897 Fouleshurst, Thomas, of Crewe, Cheshire, esq 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);