names

21 rows where place_id = 755549

✎ 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
4429147 2173923 2173923 defendant Cokhird Adam butcher 755549 755549 Cokhird, Adam, of Helmeslay, butcher 0
4457387 2187323 2187323 plaintiff Percy John   755549 755549 Percy, John, of Helmeslay 0
4457388 2187323 2187323 defendant Barker Nicholas   755549 755549 Barker, Nicholas, of Helmeslay 0
4468126 2190703 2190703 defendant Blagrys John   755549 755549 Blagrys, John, of Helmeslay 0
4470520 2191426 2191426 defendant Overton William   755549 755549 Overton, William, of Helmeslay 0
4492871 2198473 2198473 defendant Blagrys John   755549 755549 Blagrys, John, of Helmeslay 3
4562121 2219718 2219718 plaintiff Plummer John   755549 755549 Plummer, John, of Helmeslay 0
4689558 2262291 2262291 defendant Bemeslay John dyer 755549 755549 Bemeslay, John, of Helmeslay, dyer 0
4760294 2283572 2283572 defendant Sproxton John de chaplain 755549 755549 Sproxton, John de, of Helmeslay, chaplain 2
4814650 2300696 2300696 defendant Hamerton William tanner 755549 755549 Hamerton, William, of Helmeslay, tanner 0
4814651 2300696 2300696 defendant Barton John tailor 755549 755549 Barton, John, of Helmeslay, tailor 1
4814653 2300697 2300697 defendant Hamerton William tanner 755549 755549 Hamerton, William, of Helmeslay, tanner 0
4822905 2303246 2303246 defendant Prosest Peter smith 755549 755549 Prosest, Peter, of Helmeslay, smith 0
4868144 2317011 2317011 defendant Ryvaux John chaplain 755549 755549 Ryvaux, John, of Helmeslay, chaplain 0
5086667 2382492 2382492 defendant Henryson Thomas weaver 755549 755549 Henryson, Thomas, of Helmeslay, weaver 3
5113154 2390244 2390244 defendant Danby John, senior husbandman 755549 755549 Danby, John, senior, of Helmeslay, or of Dogilby on le Wald, husbandman 0
5113155 2390244 2390244 defendant Danby John, junior husbandman 755549 755549 Danby, John, junior, of Helmeslay, or of Dogilby on le Wald, husbandman 1
5614400 2548297 2548297 defendant Danby John   755549 755549 Danby, John, of Helmeslay 0
5616152 2548844 2548844 defendant Driffeld William de   755549 755549 Driffeld, William de, of Helmeslay, vicar 0
5630458 2553537 2553537 plaintiff Salton William   755549 755549 Salton, William, of Helmeslay 0
5630459 2553537 2553537 defendant Helmeslay John yeoman 755549 755549 Helmeslay, John, of Helmeslay, son of Thomas Webster, of Helmeslay, Lincs, yeoman 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);