names

7 rows where place_id = 680252

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4039603 2038780 2038780 defendant Fulford John yeoman 680252 680252 Fulford, John, of Borington, yeoman 13
4039620 2038781 2038781 defendant Fulford John yeoman 680252 680252 Fulford, John, of Borington, yeoman 13
4055274 2044285 2044285 defendant Palmer John yeoman 680252 680252 Palmer, John, of Borington, yeoman 1
4108125 2063179 2063179 defendant Burie Robery gent 680252 680252 Burie, Robery, of Borington, gent 0
4108127 2063179 2063179 defendant Paddon John gent 680252 680252 Paddon, John, of Borington, gent 2
4200101 2095587 2095587 defendant Hayne alias Woode Richard blacksmith 680252 680252 Hayne alias Woode, Richard, of Borington, blacksmith 0
4258137 2115692 2115692 defendant Palmer John husbandman 680252 680252 Palmer, John, of Borington, husbandman 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);