names

12 rows where place_id = 587984

✎ 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
3593033 1865449 1865449 defendant Pedder Alan innholder 587984 587984 Pedder, Alan, of Babram, Cams, innholder 0
3593036 1865450 1865450 defendant Pedder Alan innholder 587984 587984 Pedder, Alan, of Babram, Cams, innholder 0
3651614 1910862 1910862 defendant Middilton Alvared gent 587984 587984 Middilton, Alvared, of Babram, Cams, gent 0
3651616 1910863 1910863 defendant Middilton Alvered gent 587984 587984 Middilton, Alvered, of Babram, Cams, gent 0
3669511 1916402 1916402 defendant Cherche William clerk 587984 587984 Cherche, William, of Babram, Cams, clerk 2
3675539 1918386 1918386 defendant Wykson John yeoman 587984 587984 Wykson, John, of Babram, Cams, yeoman 0
3842522 1971191 1971191 defendant Parmyter Thomas innholder 587984 587984 Parmyter, Thomas, of Babram, Cams, innholder 2
3842529 1971192 1971192 defendant Parmyter Thomas innholder 587984 587984 Parmyter, Thomas, of Babram, Cams, innholder 2
5115917 2391084 2391084 defendant Chirche John gent 587984 587984 Chirche, John, of Babram, Cams, gent 1
5576931 2527828 2527828 defendant Dounes Geoffrey   587984 587984 Dounes, Geoffrey, of Babram, Cams 3
5580005 2528826 2528826 defendant Pynke William yeoman 587984 587984 Pynke, William, of Babram,, Cams, yeoman 2
5599917 2534857 2534857 defendant Scott John yeoman 587984 587984 Scott, John, of Babram, Cams, 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);