names

12 rows where place_id = 626329

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3769480 1948115 1948115 defendant Jermyn Robert husbandman 626329 626329 Jermyn, Robert, of Grene Hamerton, husbandman 0
3769481 1948115 1948115 defendant Fletcher Thomas husbandman 626329 626329 Fletcher, Thomas, of Grene Hamerton, husbandman 1
3906293 1992392 1992392 defendant Wawyn Ralph yeoman 626329 626329 Wawyn, Ralph, of Grene Hamerton, yeoman 1
4417022 2170196 2170196 plaintiff Proctor John le   626329 626329 Proctor, John le, of Grene Hamerton, son of Roger 0
4417024 2170196 2170196 defendant Agnes Bakester   626329 626329 Agnes, Bakester, of Grene Hamerton, formerly wife of John 1
4417025 2170197 2170197 plaintiff Procuratour John le   626329 626329 Procuratour, John le, of Grene Hamerton, son of Roger 0
4616185 2236063 2236063 defendant Brereton Richard   626329 626329 Brereton, Richard, of Grene Hamerton 6
4695994 2264233 2264233 defendant Hogeson John yeoman 626329 626329 Hogeson, John, of Grene Hamerton, yeoman 1
4758302 2282972 2282972 defendant Fetcher William husbandman 626329 626329 Fetcher, William, of Grene Hamerton, husbandman 0
4785879 2291616 2291616 plaintiff Flescher William   626329 626329 Flescher, William, of Grene Hamerton 0
5215223 2420178 2420178 defendant Harryson Robert yeoman 626329 626329 Harryson, Robert, of Grene Hamerton, yeoman 0
5462355 2493642 2493642 defendant Benson William yeoman 626329 626329 Benson, William, of Grene Hamerton, yeoman 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);