names

16 rows where place_id = 601198

✎ 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
3625942 1902971 1902971 plaintiff Addys John (legal representative) 601198 601198 Addys, John, of Pauntley, executors of 0
3644292 1908642 1908642 defendant Whitington Robert gent 601198 601198 Whitington, Robert, of Pauntley, gent 1
3644294 1908642 1908642 defendant Cokkes Richard yeoman 601198 601198 Cokkes, Richard, of Pauntley, yeoman 3
3644295 1908642 1908642 defendant Pulton Roger yeoman 601198 601198 Pulton, Roger, of Pauntley, yeoman 4
3644304 1908642 1908642 defendant Monmouth William tailor 601198 601198 Monmouth, William, of Pauntley, tailor 13
3819042 1963847 1963847 defendant Wall Thomas yeoman 601198 601198 Wall, Thomas, of Pauntley, yeoman 2
3904900 1991900 1991900 defendant Philippes John laborer 601198 601198 Philippes, John, of Pauntley, laborer 12
3904901 1991900 1991900 defendant Bond John laborer 601198 601198 Bond, John, of Pauntley, laborer 13
3904904 1991901 1991901 defendant Clarke Robert husbandman 601198 601198 Clarke, Robert, of Pauntley, husbandman 0
3974763 2015738 2015738 plaintiff Hill John yeoman 601198 601198 Hill, John, of Pauntley, yeoman 0
4006833 2027223 2027223 defendant Wall William (legal representative) 601198 601198 Wall, William, of Pauntley, yeoman, executrix of 2
4006834 2027223 2027223 defendant Wall Eleanor widow 601198 601198 Wall, Eleanor, of Pauntley, widow 3
4243040 2110662 2110662 defendant Adys Thomas husbandman 601198 601198 Adys, Thomas, of Pauntley, husbandman 3
5079117 2380240 2380240 defendant Adys Nicholas husbandman 601198 601198 Adys, Nicholas, of Pauntley, husbandman 2
5582640 2529638 2529638 defendant Arundell Humphrey yeoman 601198 601198 Arundell, Humphrey, of Pauntley, yeoman 0
5582643 2529639 2529639 defendant Arundell Humphrey yeoman 601198 601198 Arundell, Humphrey, of Pauntley, 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);