names

33 rows where place_id = 609233

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3677569 1919025 1919025 defendant Brereton Ralph gent 609233 609233 Brereton, Ralph, of Whitchurche, Salop, gent 7
3804803 1959445 1959445 defendant Coton Roger   609233 609233 Coton, Roger, of Whitchurche, Salop 0
3901663 1990784 1990784 defendant Paynter William chapman 609233 609233 Paynter, William, of Whitchurche, Salop, chapman 3
3946663 2005898 2005898 defendant Cardiff John gent 609233 609233 Cardiff, John, of Whitchurche, Salop, gent 0
3966952 2013073 2013073 defendant Hopkyn Roger butcher 609233 609233 Hopkyn, Roger, of Whitchurche, Salop, butcher 0
3975612 2016032 2016032 defendant Bartle Thomas drover 609233 609233 Bartle, Thomas, of Whitchurche, Salop, drover 4
3977250 2016614 2016614 defendant Cotton John tanner 609233 609233 Cotton, John, of Whitchurche, Salop, tanner 0
3983987 2019042 2019042 defendant Cotton Roger chapman 609233 609233 Cotton, Roger, of Whitchurche, Salop, chapman 0
3985135 2019436 2019436 defendant Cotton Roger chapman 609233 609233 Cotton, Roger, of Whitchurche, Salop, chapman 0
4028820 2034957 2034957 plaintiff Cowper William   609233 609233 Cowper, William, of Whitchurche, Salop 0
4028824 2034958 2034958 plaintiff Cowper William   609233 609233 Cowper, William, of Whitchurche, Salop 0
4042751 2039882 2039882 defendant Amery Roger chapman 609233 609233 Amery, Roger, of Whitchurche, Salop, chapman 0
4062844 2047012 2047012 defendant Cotton George yeoman 609233 609233 Cotton, George, of Whitchurche, Salop, yeoman 0
4124502 2069060 2069060 defendant Tayler William chapman 609233 609233 Tayler, William, of Whitchurche, Salop, chapman 0
4124504 2069061 2069061 defendant Taylor Rand chapman 609233 609233 Taylor, Rand, of Whitchurche, Salop, chapman 0
4147190 2077157 2077157 defendant Amerye Ralph chapman 609233 609233 Amerye, Ralph, of Whitchurche, Salop, chapman 0
4150938 2078458 2078458 defendant Cotton Roger yeoman 609233 609233 Cotton, Roger, of Whitchurche, Salop, yeoman 1
4194340 2093570 2093570 defendant Constantyne Richard gent 609233 609233 Constantyne, Richard, of Whitchurche, Salop, gent 0
4194342 2093571 2093571 defendant Telior Randolph draper 609233 609233 Telior, Randolph, of Whitchurche, Salop, draper 0
4200803 2095840 2095840 defendant Warde Francis gent 609233 609233 (Warde, Francis, of Whitchurche, Salop, gent 1
4214550 2100595 2100595 defendant Gyll Roger yeoman 609233 609233 Gyll, Roger, of Whitchurche, Salop, yeoman 0
4219843 2102443 2102443 defendant Brooke James   609233 609233 Brooke, James, of Whitchurche, Salop 0
4308407 2133094 2133094 defendant Donne Thomas gent 609233 609233 Donne, Thomas, of Whitchurche, Salop, gent 2
4313096 2134700 2134700 defendant Rigbye William mercer 609233 609233 Rigbye, William, of Whitchurche, Salop, mercer 0
4321394 2137575 2137575 defendant Cley John mercer 609233 609233 Cley, John, of Whitchurche, Salop, mercer 0
4330501 2140499 2140499 defendant Paynter William chapman 609233 609233 Paynter, William, of Whitchurche, Salop, chapman 0
4345547 2145713 2145713 defendant Gerard John goldsmith 609233 609233 Gerard, John, of Whitchurche, Salop, gent, or of London, goldsmith 0
4360569 2150948 2150948 defendant Wixsted William draper 609233 609233 Wixsted, William, of Whitchurche, Salop, draper 1
4369377 2154112 2154112 defendant Gerard John goldsmith 609233 609233 Gerard, John, of Whitchurche, Salop, gent, or of London, goldsmith 0
5253804 2431304 2431304 defendant Fyssher John yeoman 609233 609233 Fyssher, John, of Whitchurche, Salop, yeoman 0
5267241 2435516 2435516 defendant Wyn Richard chapman 609233 609233 Wyn, Richard, of Whitchurche, Salop, chapman 4
5332551 2454802 2454802 defendant Maideley Henry chapman 609233 609233 Maideley, Henry, of Whitchurche, Salop, chapman 1
5479751 2498954 2498954 defendant Wynne William (legal representative) 609233 609233 Wynne, William, of Whitchurche, Salop, chapman, executrix of 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);