names

24 rows where place_id = 609305

✎ 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
3677906 1919141 1919141 defendant Alburgh Anthony gent 609305 609305 Alburgh, Anthony, of Knaresburgh, Yorks, gent 0
3768913 1947928 1947928 defendant Medcalff Leonard mercer 609305 609305 Medcalff, Leonard, of Knaresburgh, Yorks, mercer 0
3768915 1947929 1947929 defendant Medcalffe Leonard mercer 609305 609305 Medcalffe, Leonard, of Knaresburgh, Yorks, mercer 0
3784993 1953087 1953087 defendant Sondall Richard chaplain 609305 609305 Sondall, Richard, of Knaresburgh, Yorks, chaplain 0
3801458 1958375 1958375 defendant Aldburgh Anthony gent 609305 609305 Aldburgh, Anthony, of Knaresburgh, Yorks, gent 0
3802969 1958826 1958826 defendant Metcalff Leonard chapman 609305 609305 Metcalff, Leonard, of Knaresburgh, Yorks, chapman 3
4676169 2258160 2258160 defendant Bremand John gent 609305 609305 Bremand, John, of Knaresburgh, Yorks, gent 0
4693596 2263498 2263498 defendant Urry John smith 609305 609305 Urry, John, of Knaresburgh, Yorks, smith 0
4703026 2266329 2266329 defendant Birnand John gent 609305 609305 Birnand, John, of Knaresburgh, Yorks, gent 2
4719499 2271441 2271441 defendant Wyntryngham Thomas gent 609305 609305 Wyntryngham, Thomas, of Knaresburgh, Yorks, gent 0
4727678 2273898 2273898 defendant Birnand John gent 609305 609305 Birnand, John, of Knaresburgh, Yorks, gent 3
4756291 2282336 2282336 defendant Burton John   609305 609305 Burton, John, of Knaresburgh, Yorks, vicar 4
4881858 2321225 2321225 plaintiff Wyntryngh Thomas merchant 609305 609305 Wyntryngh, Thomas, of Knaresburgh, Yorks, merchant 0
4909096 2329384 2329384 defendant Broune John   609305 609305 Broune, John, of Knaresburgh, Yorks, vicar 0
5021246 2363114 2363114 defendant Plumpton William   609305 609305 Plumpton, William, of Knaresburgh, Yorks, knight 1
5040765 2368853 2368853 defendant Fosse John merchant 609305 609305 Fosse, John, of Knaresburgh, Yorks, merchant 4
5093021 2384349 2384349 defendant Plompton William   609305 609305 Plompton, William, of Knaresburgh, Yorks, knight 0
5093023 2384350 2384350 defendant Plumpton William   609305 609305 Plumpton, William, of Knaresburgh, Yorks, knight 0
5095256 2385030 2385030 defendant Birnand John gent 609305 609305 Birnand, John, of Knaresburgh, Yorks, gent 3
5302372 2445678 2445678 defendant Bolton Robert   609305 609305 Bolton, Robert, of Knaresburgh, Yorks 0
5305511 2446652 2446652 defendant Askham John gent 609305 609305 Askham, John, of Knaresburgh, Yorks, gent 0
5305513 2446653 2446653 defendant Askham John gent 609305 609305 Askham, John, of Knaresburgh, Yorks, gent 0
5331957 2454633 2454633 defendant Wade Thomas yeoman 609305 609305 (Wade, Thomas, of Knaresburgh, Yorks, yeoman 2
5444301 2488200 2488200 defendant Plane John yeoman 609305 609305 Plane, John, of Knaresburgh, Yorks, yeoman 4

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