names

21 rows where place_id = 587954

✎ 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
3592927 1865407 1865407 defendant Gode Thomas merchant 587954 587954 Gode, Thomas, of Bolyngbroke, Lincs, merchant 0
3592943 1865414 1865414 defendant Gode Thomas merchant 587954 587954 Gode, Thomas, of Bolyngbroke, Lincs, merchant 0
3661023 1913721 1913721 defendant Unkyll John gent 587954 587954 Unkyll, John, of Bolyngbroke, Lincs, gent 1
3677935 1919145 1919145 defendant Michel John glover 587954 587954 Michel, John, of Bolyngbroke, Lincs, glover 0
3861329 1977258 1977258 defendant Bryan John gent 587954 587954 Bryan, John, of Bolyngbroke, Lincs, gent 0
3865139 1978543 1978543 defendant Bryan John merchant of the staple 587954 587954 Bryan, John, of Bolyngbroke, Lincs, merchant of the staple 0
3879197 1983295 1983295 defendant Bryan John merchant of the staple 587954 587954 Bryan, John, of Bolyngbroke, Lincs, merchant of the staple 0
3879199 1983296 1983296 defendant Bryan John merchant of the staple 587954 587954 Bryan, John, of Bolyngbroke, Lincs, merchant of the staple 0
4872145 2318246 2318246 defendant Smyth John chaplain 587954 587954 Smyth, John, of Bolyngbroke, Lincs, chaplain 2
5125764 2394020 2394020 defendant Bosse Thomas merchant 587954 587954 Bosse, Thomas, of Bolyngbroke, Lincs, merchant 0
5125769 2394021 2394021 defendant Gosse Thomas merchant 587954 587954 Gosse, Thomas, of Bolyngbroke, Lincs, merchant 0
5144377 2399512 2399512 defendant Gosse Thomas merchant 587954 587954 Gosse, Thomas, of Bolyngbroke, Lincs, merchant 0
5144382 2399513 2399513 defendant Gosse Thomas merchant 587954 587954 Gosse, Thomas, of Bolyngbroke, Lincs, merchant 0
5165251 2405580 2405580 defendant Gosse Thomas merchant 587954 587954 Gosse, Thomas, of Bolyngbroke, Lincs, merchant 0
5165256 2405581 2405581 defendant Gosse Thomas merchant 587954 587954 Gosse, Thomas, of Bolyngbroke, Lincs, merchant 0
5165257 2405581 2405581 defendant Apo Richard merchant 587954 587954 Apo, Richard, of Bolyngbroke, Lincs, merchant 1
5362638 2463963 2463963 defendant Goosse John merchant 587954 587954 Goosse, John, of Bolyngbroke, Lincs, merchant 0
5387856 2471585 2471585 defendant Uncle Thomas, senior merchant 587954 587954 Uncle, Thomas, senior, of Bolyngbroke, Lincs, merchant 1
5400463 2475201 2475201 defendant Uncle Thomas, senior merchant 587954 587954 Uncle, Thomas, senior, of Bolyngbroke, Lincs, merchant 1
5413455 2478951 2478951 defendant Uncle Thomas, sen   587954 587954 Uncle, Thomas, sen, of Bolyngbroke, Lincs 0
5571163 2526129 2526129 defendant Pennyngton Adam gent 587954 587954 Pennyngton, Adam, of Bolyngbroke, Lincs, gent 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);