names

37 rows where place_id = 763252

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3745993 1940653 1940653 plaintiff Cavendysshe Thomas (legal representative) 763252 763252 Cavendysshe, Thomas, of the Exchequer, executors of 0
3759024 1944810 1944810 plaintiff Cavendysshe Thomas (legal representative) 763252 763252 Cavendysshe, Thomas, of the Exchequer, executrix of 0
3780212 1951537 1951537 defendant Fyfeld alias Lowe Ralph (legal representative) 763252 763252 Fyfeld alias Lowe, Ralph, of the Exchequer, executors of 0
3782498 1952272 1952272 plaintiff Humberslawe John   763252 763252 Humberslawe, John, of the Exchequer 0
3813162 1962027 1962027 plaintiff Dod John (legal representative) 763252 763252 Dod, John, of the Exchequer, gent, executor of 0
3864154 1978199 1978199 defendant Saunders Thomas gent 763252 763252 Saunders, Thomas, of the Inner Temple, gent 0
3867385 1979326 1979326 plaintiff Saunders Thomas gent 763252 763252 Saunders, Thomas, of the Inner Temple, gent 0
3872085 1980895 1980895 plaintiff Baynard Richard gunner 763252 763252 Baynard, Richard, of the Tower, gunner 0
3890401 1987045 1987045 plaintiff Holbroke Richard yeoman 763252 763252 Holbroke, Richard, of the King's household, yeoman 0
3925721 1998919 1998919 plaintiff Wylkok John (legal representative) 763252 763252 Wylkok, John, of the Exchequer, executors of 0
3929039 2000051 2000051 plaintiff Brown Christopher gent 763252 763252 Brown, Christopher, of the Inner Temple, gent 0
4495603 2199307 2199307 defendant Orcherd Henry   763252 763252 Orcherd, Henry, of the 0
4498119 2200066 2200066 plaintiff Feld Isabell   763252 763252 Feld, Isabell, of the, on her own account 0
4527040 2208737 2208737 defendant Heth John (legal representative) 763252 763252 Heth, John, of the, executors of 2
4545148 2214401 2214401 defendant Gren William   763252 763252 Gren, William, of the 2
4578589 2224792 2224792 plaintiff Clynkynthorp John de merchant 763252 763252 Clynkynthorp, John de, of the German Hansa, merchant 0
4644371 2244446 2244446 plaintiff Grene William   763252 763252 Grene, William, of the Exeter diocese 1
4752371 2281153 2281153 plaintiff Becklys Thomas de   763252 763252 Becklys, Thomas de, of the same order, previous prior 4
5005844 2358608 2358608 plaintiff Ryculf or Ryoulf Thomas clerk 763252 763252 Ryculf or Ryoulf, Thomas, of the King's Exchequer, clerk 0
5040898 2368897 2368897 plaintiff Cawode Robert   763252 763252 Cawode, Robert, of the King's Exchequer 0
5042830 2369464 2369464 plaintiff Gloucestre John   763252 763252 Gloucestre, John, of the King's Exchequer 1
5146788 2400205 2400205 plaintiff Stable William   763252 763252 Stable, William, of the 1
5166756 2406003 2406003 plaintiff Stable William   763252 763252 Stable, William, of the 1
5166760 2406004 2406004 plaintiff Stable William   763252 763252 Stable, William, of the 1
5172474 2407676 2407676 defendant See Brian   763252 763252 See, Brian, of the 0
5179747 2409813 2409813 plaintiff Bohun Edmund   763252 763252 Bohun, Edmund, of the Exchequer 0
5188982 2412511 2412511 defendant Thornbury Thomas   763252 763252 Thornbury, Thomas, of the 5
5309167 2447781 2447781 plaintiff (not given)   dean & chapter of St Paul's cathedral church 763252 763252 St Paul's cathedral church, dean & chapter, of the 0
5338529 2456617 2456617 plaintiff Lekehampton Thomas   763252 763252 Lekehampton, Thomas, of the Exchequer 0
5341118 2457415 2457415 plaintiff Plumer John   763252 763252 Plumer, John, of the king's household chapel 0
5439104 2486619 2486619 plaintiff Cutte John   763252 763252 Cutte, John, of the King's household, now in Somerset 2
5462997 2493842 2493842 defendant Skynner William yeoman 763252 763252 Skynner, William, of the Sokeof Winchester, yeoman 1
5505728 2506710 2506710 plaintiff Bristall Robert   763252 763252 Bristall, Robert, of the Exchequer 0
5505976 2506791 2506791 plaintiff Brystall Robert gent 763252 763252 Brystall, Robert, of the Exchequer, gent 0
5536577 2515926 2515926 plaintiff Castell John   763252 763252 Castell, John, of the Exchequer 0
5547472 2519278 2519278 plaintiff Whytyngton John   763252 763252 Whytyngton, John, of the King's chamber 0
5577145 2527901 2527901 plaintiff Warde Richard   763252 763252 Warde, Richard, of the king's household 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);