names

15 rows where place_id = 659473

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3749794 1941845 1941845 defendant Devereux Walter   659473 659473 Devereux, Walter, of Chartley, knight, Lord Ferres 0
3834525 1968741 1968741 plaintiff Devereaux Walter   659473 659473 Devereaux, Walter, of Chartley, knight 2
3850098 1973626 1973626 plaintiff Devereux Walter   659473 659473 Devereux, Walter, of Chartley, knight, Lord Ferrers 1
3864985 1978495 1978495 plaintiff Devereux Walter   659473 659473 Devereux, Walter, of Chartley, knight, Lord Ferrers 1
3892195 1987643 1987643 plaintiff Devereux Walter   659473 659473 Devereux, Walter, of Chartley, knight, Lord Ferrers 1
3952583 2007974 2007974 plaintiff Holbeche Thomas gent 659473 659473 Holbeche, Thomas, of Chartley, gent 0
3969965 2014094 2014094 defendant Deveroux Christopher gent 659473 659473 Deveroux, Christopher, of Chartley, gent 1
3969967 2014094 2014094 defendant Norton George gent 659473 659473 Norton, George, of Chartley, gent 3
3969970 2014095 2014095 defendant Deveroux Christopher gent 659473 659473 Deveroux, Christopher, of Chartley, gent 1
3969972 2014095 2014095 defendant Norton George gent 659473 659473 Norton, George, of Chartley, gent 3
4007235 2027367 2027367 defendant Pygen Edward gent 659473 659473 Pygen, Edward, of Chartley, gent 1
4218237 2101882 2101882 defendant Raggdall John gent 659473 659473 Raggdall, John, of Chartley, gent 2
4227473 2105090 2105090 defendant Raggdall John gent 659473 659473 Raggdall, John, of Chartley, gent 2
5098415 2385964 2385964 defendant Norman Nicholas gent 659473 659473 Norman, Nicholas, of Chartley, gent 0
5353318 2461113 2461113 defendant Devereux Walter   659473 659473 Devereux, Walter, of Chartley, knight, Lord Ferrers 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);