names

34 rows where place_id = 619617

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3730929 1935902 1935902 defendant Grey John barber 619617 619617 Grey, John, of Stowe St Mary, barber 0
3773340 1949375 1949375 defendant Spre John husbandman 619617 619617 Spre, John, of Stowe St Mary, husbandman 0
3773342 1949375 1949375 defendant Toll Thomas laborer 619617 619617 Toll, Thomas, of Stowe St Mary, laborer 2
3773343 1949375 1949375 defendant Cornyshe John husbandman 619617 619617 Cornyshe, John, of Stowe St Mary, husbandman 3
3773344 1949375 1949375 defendant Waren Thomas, senior husbandman 619617 619617 Waren, Thomas, senior, of Stowe St Mary, husbandman 4
3773345 1949375 1949375 defendant Waren Thomas, junior husbandman 619617 619617 Waren, Thomas, junior, of Stowe St Mary, husbandman 5
3781842 1952067 1952067 defendant Roche William gent 619617 619617 (Roche, William, of Stowe St Mary, gent 1
3781843 1952067 1952067 defendant Hynde Thomas chaplain 619617 619617 Hynde, Thomas, of Stowe St Mary, chaplain 2
3791110 1955054 1955054 defendant Waren John, junior laborer 619617 619617 Waren, John, junior, of Stowe St Mary, laborer 2
3791111 1955054 1955054 defendant Cornysshe John husbandman 619617 619617 Cornysshe, John, of Stowe St Mary, husbandman 3
3791112 1955054 1955054 defendant Waren Thomas, senior husbandman 619617 619617 Waren, Thomas, senior, of Stowe St Mary, husbandman 4
4020193 2031944 2031944 defendant Wyvell Oliver yeoman 619617 619617 Wyvell, Oliver, of Stowe St Mary, yeoman 0
4434268 2175477 2175477 defendant Hervy John   619617 619617 Hervy, John, of Stowe St Mary, son of William 0
4451320 2185380 2185380 defendant Brande Alice   619617 619617 Brande, Alice, of Stowe St Mary, formerly wife of John Brande, who died intestate 0
4451322 2185381 2185381 defendant Brande John (legal representative) 619617 619617 Brande, John, of Stowe St Mary, administratrix of 0
4452662 2185838 2185838 defendant Couper Robert   619617 619617 Couper, Robert, of Stowe St Mary 0
4503845 2201765 2201765 defendant Veisy Robert   619617 619617 Veisy, Robert, of Stowe St Mary 0
4595461 2229836 2229836 defendant Gybson Richard   619617 619617 Gybson, Richard, of Stowe St Mary 0
4602208 2231909 2231909 defendant Bacheler William   619617 619617 Bacheler, William, of Stowe St Mary 0
4602210 2231909 2231909 defendant Rothewell John   619617 619617 Rothewell, John, of Stowe St Mary 2
4617607 2236515 2236515 plaintiff Scarburgh Thomas   619617 619617 Scarburgh, Thomas, of Stowe St Mary 1
4671512 2256735 2256735 defendant Pays William husbandman 619617 619617 Pays, William, of Stowe St Mary, husbandman 1
4707095 2267604 2267604 defendant Bryde Adam husbandman 619617 619617 Bryde, Adam, of Stowe St Mary, husbandman 0
4837508 2307668 2307668 plaintiff Franke Robert   619617 619617 Franke, Robert, of Stowe St Mary, vicar 0
4964317 2346240 2346240 defendant Wastnes Richard esq 619617 619617 Wastnes, Richard, of Stowe St Mary, esq 0
5039443 2368447 2368447 defendant Feld Thomas weaver 619617 619617 Feld, Thomas, of Stowe St Mary, weaver 2
5130299 2395346 2395346 defendant Sutton John   619617 619617 Sutton, John, of Stowe St Mary 0
5265957 2435108 2435108 defendant Manby John esq 619617 619617 Manby, John, of Stowe St Mary, esq 0
5283554 2440243 2440243 defendant Aleyn Thomas husbandman 619617 619617 Aleyn, Thomas, of Stowe St Mary, husbandman 1
5283906 2440327 2440327 defendant Boseby Thomas merchant 619617 619617 Boseby, Thomas, of Stowe St Mary, merchant 0
5297180 2444172 2444172 defendant Hatman William clerk 619617 619617 Hatman, William, of Stowe St Mary, clerk 0
5621900 2550757 2550757 defendant Clobyry William   619617 619617 Clobyry, William, of Stowe St Mary, vicar 0
5631427 2553834 2553834 defendant Smyth Thomas   619617 619617 Smyth, Thomas, of Stowe St Mary 0
5635215 2554987 2554987 defendant Scarburgh Thomas   619617 619617 Scarburgh, Thomas, of Stowe St Mary 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);