names

31 rows where place_id = 795899

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4748284 2280007 2280007 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4752212 2281119 2281119 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4752214 2281120 2281120 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4752216 2281121 2281121 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4753000 2281328 2281328 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4773177 2287579 2287579 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4774729 2288086 2288086 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4776178 2288545 2288545 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4776198 2288548 2288548 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4776203 2288549 2288549 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4779483 2289561 2289561 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4779486 2289562 2289562 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4792448 2293723 2293723 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, or of Nottingham, knight 0
4798463 2295702 2295702 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4798634 2295750 2295750 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4816161 2301139 2301139 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4816163 2301140 2301140 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4819278 2302109 2302109 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4819322 2302120 2302120 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4819792 2302261 2302261 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4842751 2309271 2309271 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4842767 2309277 2309277 defendant Bowet Nicholas maltman 795899 795899 Bowet, Nicholas, of Repynghale, Lincs, maltman 0
4849954 2311458 2311458 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4849962 2311459 2311459 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4870456 2317731 2317731 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4871483 2318047 2318047 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
4919762 2332685 2332685 defendant Bow Nicholas   795899 795899 Bow, Nicholas, of Repynghale, Lincs, knight 2
5030636 2365831 2365831 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
5040405 2368732 2368732 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
5052257 2372283 2372283 defendant Bowet Nicholas   795899 795899 Bowet, Nicholas, of Repynghale, Lincs, knight 0
5289632 2441968 2441968 defendant Hylton Thomas clerk 795899 795899 Hylton, Thomas, of Repynghale, Lincs, clerk 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);