names

19 rows where place_id = 600572

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641598 1907833 1907833 defendant Waterhous Simon husbandman 600572 600572 Waterhous, Simon, of Kynnesbury, husbandman 0
3679942 1919792 1919792 defendant Wynnall John gent 600572 600572 Wynnall, John, of Kynnesbury, gent 2
3699268 1925985 1925985 defendant Caryngton Henry husbandman 600572 600572 Caryngton, Henry, of Kynnesbury, husbandman 0
3707440 1928621 1928621 defendant Caryngton Henry husbandman 600572 600572 Caryngton, Henry, of Kynnesbury, husbandman 1
3945499 2005502 2005502 defendant Lychefeld Thomas husbandman 600572 600572 Lychefeld, Thomas, of Kynnesbury, husbandman 1
3945500 2005502 2005502 defendant Edyngdall Thomas husbandman 600572 600572 Edyngdall, Thomas, of Kynnesbury, husbandman 2
3945501 2005502 2005502 defendant Carter John husbandman 600572 600572 Carter, John, of Kynnesbury, husbandman 3
3945502 2005502 2005502 defendant Awhateley William tailor 600572 600572 Awhateley, William, of Kynnesbury, tailor 4
4494542 2198985 2198985 plaintiff Hope John   600572 600572 Hope, John, of Kynnesbury, vicar 5
4574761 2223627 2223627 defendant Mulleward John   600572 600572 Mulleward, John, of Kynnesbury 0
4641080 2243482 2243482 defendant Freman John   600572 600572 Freman, John, of Kynnesbury, vicar 0
4650877 2246278 2246278 defendant Mulward John   600572 600572 Mulward, John, of Kynnesbury 1
4676666 2258319 2258319 defendant Deye Geoffrey yeoman 600572 600572 Deye, Geoffrey, of Kynnesbury, yeoman 0
4676667 2258319 2258319 defendant Dale Roger yeoman 600572 600572 Dale, Roger, of Kynnesbury, yeoman 1
4725232 2273185 2273185 defendant Bailly Roger husbandman 600572 600572 Bailly, Roger, of Kynnesbury, husbandman 0
4926462 2334696 2334696 defendant Serche Henry husbandman 600572 600572 Serche, Henry, of Kynnesbury, husbandman 1
5117628 2391591 2391591 defendant Bracebrigge Richard esq 600572 600572 Bracebrigge, Richard, of Kynnesbury, esq 0
5441257 2487300 2487300 defendant Brasebrigge Richard esq 600572 600572 Brasebrigge, Richard, of Kynnesbury, esq 0
5577895 2528159 2528159 defendant Dunham William yeoman 600572 600572 Dunham, William, of Kynnesbury, yeoman 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);