names

26 rows where case_id = 1961734

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3812250 1961734 1961734 plaintiff Cookyssey William attorney   Cookyssey, William, attorney 0
3812251 1961734 1961734 defendant Staunton John husbandman 592611 592611 Staunton, John, of Fekenham, husbandman 0
3812252 1961734 1961734 defendant Pycholett John yeoman 602417 602417 Pycholett, John, of Estham, yeoman 1
3812253 1961734 1961734 defendant Oldnall Richard husbandman 608210 608210 Oldnall, Richard, of Chaddesley Corbett, husbandman 2
3812254 1961734 1961734 defendant Coke William husbandman 608210 608210 Coke, William, of Chaddesley Corbett, husbandman 3
3812255 1961734 1961734 defendant Turbutt Thomas mercer 591688 591688 Turbutt, Thomas, of Parshore, mercer 4
3812256 1961734 1961734 defendant Clopton or Cloperton Henry gent 621827 621827 Clopton or Cloperton, Henry, of Bradwell, Glos, gent 5
3812257 1961734 1961734 defendant Chaundeler John husbandman 591688 591688 Chaundeler, John, of Parshore, husbandman 6
3812258 1961734 1961734 defendant Davyce Roger husbandman 633358 633358 Davyce, Roger, of Aldermynston, husbandman 7
3812259 1961734 1961734 defendant Brodwey John laborer 614287 614287 Brodwey, John, of Streynsham, laborer 8
3812260 1961734 1961734 defendant Launde Richard     Launde, Richard 9
3812261 1961734 1961734 defendant Ball William     Ball, William 10
3812262 1961734 1961734 defendant Cropthorne Richard     Cropthorne, Richard 11
3812263 1961734 1961734 defendant Dyson Thomas     Dyson, Thomas 12
3812264 1961734 1961734 defendant Hemyng Edmund     Hemyng, Edmund 13
3812265 1961734 1961734 defendant Hoggys Christopher     Hoggys, Christopher 14
3812266 1961734 1961734 defendant Harryson John     Harryson, John 15
3812267 1961734 1961734 defendant Hanley John     Hanley, John 16
3812268 1961734 1961734 defendant Hyggens Thomas     Hyggens, Thomas 17
3812269 1961734 1961734 defendant Kempstowe Thomas     Kempstowe, Thomas 18
3812270 1961734 1961734 defendant Lowe Guy     Lowe, Guy 19
3812271 1961734 1961734 defendant Mylle George     Mylle, George 20
3812272 1961734 1961734 defendant Munde Roger     Munde, Roger 21
3812273 1961734 1961734 defendant Sheffyld Richard     Sheffyld, Richard 22
3812274 1961734 1961734 defendant Best John (legal representative)   Best, John, administratrix of 23
3812275 1961734 1961734 defendant Best Joan     Best, Joan 24

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