names

22 rows where case_id = 2436860

✎ 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
5271843 2436860 2436860 plaintiff Hert William gent & draper 653365 653365 Hert, William, of Fleet Street, London, gent & draper, on his own account 0
5271844 2436860 2436860 defendant Fayreford Alexander gent 866874 866874 Fayreford, Alexander, of Little Marlowe, Bucks & Suthwerk, Surr, gent 0
5271845 2436860 2436860 defendant Odychewell John gent 866875 866875 Odychewell, John, of Grymston, Norff, gent 1
5271846 2436860 2436860 defendant Calverley Robert gent 585869 585869 Calverley, Robert, of London, gent 2
5271847 2436860 2436860 defendant Wederyngton William gent 633018 633018 Wederyngton, William, of Wederyngton, Northumb, gent 3
5271848 2436860 2436860 defendant Malpas John clothman 780768 780768 Malpas, John, of Worcester, Worcs, clothman 4
5271849 2436860 2436860 defendant Playfoowe Thomas yeoman 604408 604408 Playfoowe, Thomas, of Guildford, Surr, yeoman 5
5271850 2436860 2436860 defendant Hert William carpenter 585869 585869 Hert, William, of London, carpenter 6
5271851 2436860 2436860 defendant Credy John brewer 585869 585869 Credy, John, of London, brewer 7
5271852 2436860 2436860 defendant Credy Alice     Alice, his wife 8
5271853 2436860 2436860 defendant George John merchant 585925 585925 George, John, of Bristol, merchant 9
5271854 2436860 2436860 defendant George Joan     Joan, his wife, formerly widow of London 10
5271855 2436860 2436860 defendant Condon John mercer 585869 585869 Condon, John, of London, mercer 11
5271856 2436860 2436860 defendant Condon Robert founder 585869 585869 Condon, Robert, of London, founder 12
5271857 2436860 2436860 defendant Passhe Thomas yeoman 603464 603464 Passhe, Thomas, of Bedford, Beds, yeoman 13
5271858 2436860 2436860 defendant Jenkyn Richard skinner 585869 585869 Jenkyn, Richard, of London, skinner 14
5271859 2436860 2436860 defendant Swynfeld Robert clerk 826376 826376 Swynfeld, Robert, of Rokyng, Kent, clerk 15
5271860 2436860 2436860 defendant Wroxham Richard gent 590201 590201 Wroxham, Richard, of Berkyng, Essex, gent 16
5271861 2436860 2436860 defendant Smyth William husbandman 866876 866876 Smyth, William, of Great Stanmare, Midd, husbandman 17
5271862 2436860 2436860 defendant Taylour alias Castul Combe Geoffrey merchant 585925 585925 Taylour alias Castul Combe, Geoffrey, of Bristol, merchant 18
5271863 2436860 2436860 defendant Cartyngton John gent 585869 585869 Cartyngton, John, of London, gent 19
5271864 2436860 2436860 defendant Clakston Robert   866877 866877 Clakston, Robert, of Horden, county Durham, knight 20

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