names

32 rows where place_id = 653005

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3926860 1999315 1999315 defendant Smyth alias Dyer John yeoman 653005 653005 Smyth alias Dyer, John, of Ipswich, Suffolk, yeoman 1
4636101 2242122 2242122 defendant Rous John   653005 653005 Rous, John, of Ipswich, Suffolk 0
4693493 2263465 2263465 defendant Haverlle Lawrence   653005 653005 Haverlle, Lawrence, of Ipswich, Suffolk, tile maker 2
4695946 2264217 2264217 defendant Toke Hugh merchant 653005 653005 Toke, Hugh, of Ipswich, Suffolk, merchant 3
4712078 2269090 2269090 defendant (not given) William prior of Blome 653005 653005 Blome, William, of Ipswich, Suffolk, prior of St Peters 0
4720962 2271887 2271887 defendant Caunceller John yeoman 653005 653005 Caunceller, John, of Ipswich, Suffolk, yeoman 1
4757758 2282802 2282802 defendant Greyne John merchant 653005 653005 Greyne, John, of Ipswich, Suffolk, merchant 0
4827968 2304798 2304798 defendant Joye John merchant 653005 653005 Joye, John, of Ipswich, Suffolk, merchant 0
4827975 2304799 2304799 defendant Debenham (illegible) merchant 653005 653005 Debenham, _, of Ipswich, Suffolk, merchant 0
4836232 2307312 2307312 defendant Frenssh John, sen husbandman 653005 653005 Frenssh, John, sen, of Ipswich, Suffolk, husbandman 0
4843986 2309632 2309632 defendant Wode Robert gent 653005 653005 Wode, Robert, of Ipswich, Suffolk, gent 3
4843995 2309634 2309634 defendant Twayte John gent 653005 653005 Twayte, John, of Ipswich, Suffolk, gent 0
4847823 2310806 2310806 defendant Joye John vintner 653005 653005 Joye, John, of Ipswich, Suffolk, vintner 0
4990436 2354051 2354051 defendant Pynnote John   653005 653005 Pynnote, John, of Ipswich, Suffolk, servant 3
4999000 2356582 2356582 defendant Kasnell Adam chaplain 653005 653005 (Kasnell, Adam, of Ipswich, Suffolk, chaplain 1
5002468 2357633 2357633 defendant Herryson Rumbaldus beer brewer 653005 653005 Herryson, Rumbaldus, of Ipswich, Suffolk, beer brewer 7
5008281 2359312 2359312 defendant Skynner William merchant 653005 653005 Skynner, William, of Ipswich, Suffolk, merchant 0
5146624 2400151 2400151 defendant Martyn Robert merchant 653005 653005 Martyn, Robert, of Ipswich, Suffolk, merchant 0
5148372 2400661 2400661 defendant Keche William merchant 653005 653005 Keche, William, of Ipswich, Suffolk, merchant 0
5148373 2400661 2400661 defendant Pryour John chaplain 653005 653005 Pryour, John, of Ipswich, Suffolk, chaplain 1
5157070 2403207 2403207 defendant Keche William merchant 653005 653005 Keche, William, of Ipswich, Suffolk, merchant 0
5181634 2410370 2410370 defendant Martyn Robert merchant 653005 653005 Martyn, Robert, of Ipswich, Suffolk, merchant 0
5186643 2411842 2411842 defendant Burre William grocer 653005 653005 Burre, William, of Ipswich, Suffolk, grocer 3
5192952 2413666 2413666 defendant Keche William merchant 653005 653005 Keche, William, of Ipswich, Suffolk, merchant 0
5199206 2415520 2415520 defendant (not given) Geoffrey prior of Peryn 653005 653005 (Peryn, Geoffrey, of Ipswich, Suffolk, prior of St Peter's 1
5204920 2417188 2417188 defendant Felowe Richard merchant 653005 653005 Felowe, Richard, of Ipswich, Suffolk, merchant 1
5209762 2418591 2418591 defendant Palmer John fishmonger 653005 653005 Palmer, John, of Ipswich, Suffolk, fishmonger 0
5210331 2418750 2418750 defendant Sokelyng John merchant 653005 653005 Sokelyng, John, of Ipswich, Suffolk, merchant 0
5210412 2418778 2418778 defendant Palmer John fishmonger 653005 653005 Palmer, John, of Ipswich, Suffolk, fishmonger 0
5211003 2418952 2418952 defendant (not given) Geoffrey prior of Peryn 653005 653005 (Peryn, Geoffrey, of Ipswich, Suffolk, prior of St Peter's 1
5299675 2444874 2444874 defendant Wynter Edmund pewterer 653005 653005 Wynter, Edmund, of Ipswich, Suffolk, pewterer 0
5304498 2446339 2446339 defendant Stokenham Cuthbert merchant 653005 653005 Stokenham, Cuthbert, of Ipswich, Suffolk, merchant 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);