names

18 rows where place_id = 633616

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3813807 1962231 1962231 defendant Asshewell William collier 633616 633616 Asshewell, William, of Toneworth, collier 4
4415029 2169599 2169599 defendant atte Berne John   633616 633616 atte Berne, John, of Toneworth 0
4427284 2173367 2173367 defendant fulwode William de   633616 633616 fulwode, William de, of Toneworth 2
4450511 2185123 2185123 plaintiff Hartour John   633616 633616 Hartour, John, of Toneworth 0
4486932 2196629 2196629 defendant Waryn Thomas   633616 633616 Waryn, Thomas, of Toneworth 0
4497598 2199895 2199895 defendant Creweley John   633616 633616 Creweley, John, of Toneworth 0
4563877 2220271 2220271 defendant Archer Thomas   633616 633616 Archer, Thomas, of Toneworth 0
4580967 2225523 2225523 defendant Cowerne Richard   633616 633616 Cowerne, Richard, of Toneworth 0
4624087 2238511 2238511 plaintiff Mountford William   633616 633616 Mountford, William, of Toneworth 0
4660839 2249216 2249216 defendant atte Yate Robert husbandman 633616 633616 atte Yate, Robert, of Toneworth, husbandman 0
5022741 2363563 2363563 defendant Waryng Thomas esq 633616 633616 Waryng, Thomas, of Toneworth, esq 0
5059106 2374289 2374289 defendant Archer Richard esq 633616 633616 Archer, Richard, of Toneworth, esq 0
5059108 2374290 2374290 defendant Archer Richard esq 633616 633616 Archer, Richard, of Toneworth, esq 0
5068615 2377107 2377107 defendant Archer Richard esq 633616 633616 Archer, Richard, of Toneworth, esq 0
5188060 2412219 2412219 defendant Dolphyn John husbandman 633616 633616 Dolphyn, John, of Toneworth, husbandman 3
5205856 2417447 2417447 defendant Dolphyn John husbandman 633616 633616 Dolphyn, John, of Toneworth, husbandman 3
5407856 2477325 2477325 defendant Hethe alias Swan Thomas collier & son & heir of Henry Hethe 633616 633616 Hethe alias Swan, Thomas, of Toneworth, collier & son & heir of Henry Hethe 1
5494380 2503221 2503221 defendant Lemyng William carpenter 633616 633616 Lemyng, William, of Toneworth, carpenter 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);