names

24 rows where place_id = 714003

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4201839 2096185 2096185 defendant Tanckard Francis gent 714003 714003 Tanckard, Francis, of Pannall, gent 0
4201840 2096185 2096185 defendant West Henry yeoman 714003 714003 West, Henry, of Pannall, yeoman 1
4201841 2096185 2096185 defendant Thornton George yeoman 714003 714003 Thornton, George, of Pannall, yeoman 2
4826132 2304204 2304204 defendant Dobson Richard husbandman 714003 714003 Dobson, Richard, of Pannall, husbandman 0
4873749 2318727 2318727 defendant Pillesworth Nicholas yeoman 714003 714003 Pillesworth, Nicholas, of Pannall, yeoman 15
4887661 2322970 2322970 defendant Robynson Thomas yeoman 714003 714003 Robynson, Thomas, of Pannall, yeoman 2
4895863 2325375 2325375 defendant Deconson Thomas butcher 714003 714003 Deconson, Thomas, of Pannall, butcher 3
4941956 2339468 2339468 defendant Parke Thomas yeoman 714003 714003 Parke, Thomas, of Pannall, yeoman 0
4941958 2339469 2339469 defendant Parke Thomas yeoman 714003 714003 Parke, Thomas, of Pannall, yeoman 0
4971848 2348511 2348511 defendant Frank Robert yeoman 714003 714003 Frank, Robert, of Pannall, yeoman 2
5012505 2360503 2360503 defendant Bullyng John husbandman 714003 714003 Bullyng, John, of Pannall, husbandman 1
5052162 2372258 2372258 defendant Bulkyng John husbandman 714003 714003 Bulkyng, John, of Pannall, husbandman 0
5114911 2390776 2390776 defendant Hill Geoffrey yeoman 714003 714003 Hill, Geoffrey, of Pannall, yeoman 0
5114912 2390776 2390776 defendant Redshawe William yeoman 714003 714003 Redshawe, William, of Pannall, yeoman 1
5114913 2390776 2390776 defendant Smyth John, senior yeoman 714003 714003 Smyth, John, senior, of Pannall, yeoman 2
5114914 2390776 2390776 defendant Smyth Thomas laborer 714003 714003 Smyth, Thomas, of Pannall, laborer 3
5114915 2390776 2390776 defendant Smyth John, junior yeoman 714003 714003 Smyth, John, junior, of Pannall, yeoman 4
5173543 2407965 2407965 defendant Pyllesworth Nicholas brewer 714003 714003 Pyllesworth, Nicholas, of Pannall, brewer 1
5262111 2433897 2433897 defendant Atkynson John yeoman 714003 714003 Atkynson, John, of Pannall, yeoman 0
5289008 2441792 2441792 defendant Rowedon William yeoman 714003 714003 Rowedon, William, of Pannall, yeoman 0
5333403 2455059 2455059 defendant Neelson John yeoman 714003 714003 Neelson, John, of Pannall, yeoman 3
5349301 2459911 2459911 defendant Fraunke Richard yeoman 714003 714003 Fraunke, Richard, of Pannall, yeoman 0
5435149 2485443 2485443 defendant Bekwyth Thomas husbandman 714003 714003 Bekwyth, Thomas, of Pannall, husbandman 0
5435153 2485445 2485445 defendant Bekwith Thomas husbandman 714003 714003 Bekwith, Thomas, of Pannall, husbandman 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);