names

25 rows where place_id = 759101

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4459160 2187909 2187909 plaintiff Ropere John   759101 759101 Ropere, John, of Westgate by Canterbury 0
4485500 2196171 2196171 plaintiff Rapere John   759101 759101 Rapere, John, of Westgate by Canterbury 0
4520452 2206741 2206741 defendant Bertylot Richard (legal representative) 759101 759101 Bertylot, Richard, of Westgate by Canterbury, administrator of 0
4520455 2206742 2206742 defendant Bertylot Richard (legal representative) 759101 759101 Bertylot, Richard, of Westgate by Canterbury, administratrix of 0
4545196 2214419 2214419 defendant Reynold William butcher 759101 759101 Reynold, William, of Westgate by Canterbury, butcher 0
4545197 2214419 2214419 defendant Bolde Henry weaver 759101 759101 Bolde, Henry, of Westgate by Canterbury, weaver 1
4563660 2220199 2220199 defendant Kyrkeby William   759101 759101 Kyrkeby, William, of Westgate by Canterbury 0
4579894 2225200 2225200 defendant Sacry John   759101 759101 Sacry, John, of Westgate by Canterbury 0
4644709 2244534 2244534 plaintiff Maryon William   759101 759101 Maryon, William, of Westgate by Canterbury 0
4644712 2244534 2244534 defendant Morlee William   759101 759101 Morlee, William, of Westgate by Canterbury 2
4692722 2263234 2263234 plaintiff atte Wode Richard baker 759101 759101 atte Wode, Richard, of Westgate by Canterbury, baker 0
4698632 2265050 2265050 defendant Cook John brewer 759101 759101 Cook, John, of Westgate by Canterbury, brewer 0
4699314 2265249 2265249 plaintiff Philpot John yeoman 759101 759101 Philpot, John, of Westgate by Canterbury, yeoman 1
4699315 2265249 2265249 defendant Robert John   759101 759101 Robert, John, of Westgate by Canterbury 0
4758595 2283067 2283067 defendant Plunket John yeoman 759101 759101 Plunket, John, of Westgate by Canterbury, yeoman 0
4814749 2300729 2300729 plaintiff Kelarace Thomas (legal representative) 759101 759101 Kelarace, Thomas, of Westgate by Canterbury, executors of 0
4816542 2301266 2301266 defendant Topclyve Joan   759101 759101 Topclyve, Joan, of Westgate by Canterbury, widow, formerly wife of John Topclyve 0
4817242 2301485 2301485 defendant Bartelot John butcher 759101 759101 Bartelot, John, of Westgate by Canterbury, butcher 0
4817244 2301485 2301485 defendant Grene William tailor 759101 759101 (Grene, William, of Westgate by Canterbury, tailor 2
4910628 2329834 2329834 defendant Bertlot William gent 759101 759101 Bertlot, William, of Westgate by Canterbury, gent 0
4986611 2352926 2352926 plaintiff Hardy Richard   759101 759101 Hardy, Richard, of Westgate by Canterbury 1
4994370 2355190 2355190 defendant atte Halle Stephen husbandman 759101 759101 atte Halle, Stephen, of Westgate by Canterbury, husbandman 0
4997554 2356121 2356121 defendant Honywodl John husbandman 759101 759101 Honywodl, John, of Westgate by Canterbury, husbandman 2
5012078 2360380 2360380 defendant atte Halle Stephen husbandman 759101 759101 atte Halle, Stephen, of Westgate by Canterbury, husbandman 0
5179033 2409594 2409594 defendant Luton William butcher 759101 759101 Luton, William, of Westgate by Canterbury, butcher 2

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);