names

29 rows where place_id = 589221

✎ 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
3596945 1866677 1866677 defendant Doweghty Thomas clerk 589221 589221 Doweghty, Thomas, of Kyrkby, clerk 0
3662269 1914113 1914113 defendant Laugton Cuthbert gent 589221 589221 Laugton, Cuthbert, of Kyrkby, gent 0
3705252 1927929 1927929 defendant Vynter Thomas   589221 589221 Vynter, Thomas, of Kyrkby, shepherd 0
3705253 1927929 1927929 defendant Langton John husbandman 589221 589221 Langton, John, of Kyrkby, husbandman 1
3839826 1970386 1970386 defendant Hertley Michael chaplain 589221 589221 Hertley, Michael, of Kyrkby, chaplain 0
3917600 1996246 1996246 plaintiff Hall Richard husbandman 589221 589221 Hall, Richard, of Kyrkby under Bayn, husbandman 1
3924985 1998672 1998672 defendant Combys William turner 589221 589221 Combys, William, of Kyrkby, turner 0
3927909 1999673 1999673 plaintiff Barnett Robert yeoman 589221 589221 Barnett, Robert, of Kyrkby, yeoman 0
3927910 1999673 1999673 plaintiff Wales Robert yeoman 589221 589221 Wales, Robert, of Kyrkby, yeoman 1
3965861 2012676 2012676 defendant Hennage John gent 589221 589221 Hennage, John, of Kyrkby, gent 0
3989834 2021114 2021114 defendant Clyfton William yeoman 589221 589221 Clyfton, William, of Kyrkby, yeoman 4
4127284 2070051 2070051 defendant Hunter Anthony glover 589221 589221 Hunter, Anthony, of Kyrkby, glover 0
4127286 2070052 2070052 defendant Hunter Anthony glover 589221 589221 Hunter, Anthony, of Kyrkby, glover 0
4152597 2079021 2079021 defendant Irishe Henry husbandman 589221 589221 Irishe, Henry, of Kyrkby, husbandman 2
4156779 2080448 2080448 defendant Davell Robert gent 589221 589221 Davell, Robert, of Kyrkby, gent 0
4174891 2086683 2086683 defendant Towers William yeoman 589221 589221 Towers, William, of Kyrkby, yeoman 3
4200278 2095650 2095650 defendant Tayler Thomas husbandman 589221 589221 Tayler, Thomas, of Kyrkby, husbandman 1
4200279 2095650 2095650 defendant Iryshe Henry husbandman 589221 589221 Iryshe, Henry, of Kyrkby, husbandman 2
4233437 2107210 2107210 defendant Maltbye Walter yeoman 589221 589221 Maltbye, Walter, of Kyrkby, yeoman 0
4662735 2249803 2249803 defendant Hyll Henry husbandman 589221 589221 Hyll, Henry, of Kyrkby, husbandman 0
4725860 2273375 2273375 defendant Gybson John husbandman 589221 589221 Gybson, John, of Kyrkby Over Blavere, husbandman 0
5041317 2369012 2369012 defendant Lee John mylner 589221 589221 Lee, John, of Kyrkby, mylner 0
5599721 2534802 2534802 defendant Godryk Richard husbandman 589221 589221 Godryk, Richard, of Kyrkby, husbandman 1
5599722 2534802 2534802 defendant Hed Robert husbandman 589221 589221 Hed, Robert, of Kyrkby, husbandman 2
5599723 2534802 2534802 defendant Adam William husbandman 589221 589221 Adam, William, of Kyrkby, husbandman 3
5599725 2534803 2534803 defendant Litster William husbandman 589221 589221 Litster, William, of Kyrkby, husbandman 0
5599726 2534803 2534803 defendant Godryk Richard husbandman 589221 589221 Godryk, Richard, of Kyrkby, husbandman 1
5599727 2534803 2534803 defendant Hed Robert husbandman 589221 589221 Hed, Robert, of Kyrkby, husbandman 2
5599728 2534803 2534803 defendant Adam William husbandman 589221 589221 Adam, William, of Kyrkby, husbandman 3

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