names

32 rows where place_id = 792342

✎ 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
4728993 2274304 2274304 defendant Fulwode John yeoman 792342 792342 Fulwode, John, of Tamworth, Warws, yeoman 0
4757616 2282758 2282758 defendant Bate Robert   792342 792342 Bate, Robert, of Tamworth, Warws 0
4832980 2306334 2306334 defendant Dalton John chapman 792342 792342 Dalton, John, of Tamworth, Warws, chapman 0
4928532 2335351 2335351 defendant Bailly John hosier 792342 792342 Bailly, John, of Tamworth, Warws, hosier 0
4932831 2336655 2336655 defendant Boton John yeoman 792342 792342 Boton, John, of Tamworth, Warws, yeoman 2
5005472 2358502 2358502 defendant Danyell Ralph butcher 792342 792342 Danyell, Ralph, of Tamworth, Warws, butcher 0
5049589 2371506 2371506 defendant Ferrers Thomas, senior esq 792342 792342 Ferrers, Thomas, senior, of Tamworth, Warws, esq 0
5049590 2371506 2371506 defendant Ferrers Thomas, junior esq 792342 792342 Ferrers, Thomas, junior, of Tamworth, Warws, esq 1
5132410 2395975 2395975 defendant Ferrers Thomas esq 792342 792342 Ferrers, Thomas, of Tamworth, Warws, esq 1
5153468 2402168 2402168 defendant Fletcher John yeoman 792342 792342 Fletcher, John, of Tamworth, Warws, yeoman 0
5160281 2404102 2404102 defendant Walker John walker 792342 792342 Walker, John, of Tamworth, Warws, servant of John Walker, walker 3
5160283 2404102 2404102 defendant Boteler Thomas butcher 792342 792342 Boteler,Thomas, of Tamworth, Warws, butcher 5
5160287 2404102 2404102 defendant Pete John walker 792342 792342 Pete, John, of Tamworth, Warws, walker 9
5164304 2405297 2405297 defendant Jacob Humphrey gent 792342 792342 Jacob, Humphrey, of Tamworth, Warws, gent 0
5174220 2408158 2408158 defendant Fletcher John yeoman 792342 792342 Fletcher, John, of Tamworth, Warws, yeoman, alias Barker, John, yeoman 0
5175117 2408418 2408418 defendant Coton Thomas   792342 792342 Coton, Thomas, of Tamworth, Warws, gold beater 0
5175118 2408418 2408418 defendant Walker John butcher 792342 792342 Walker, John, of Tamworth, Warws, butcher 1
5175122 2408418 2408418 defendant Boteler Thomas butcher 792342 792342 Boteler, Thomas, of Tamworth, Warws, butcher 5
5175123 2408418 2408418 defendant Walker Humphrey   792342 792342 Walker, Humphrey, of Tamworth, Warws, laborer, servant of John 6
5175126 2408418 2408418 defendant Pete John walker 792342 792342 Pete, John, of Tamworth, Warws, walker 9
5184715 2411279 2411279 defendant Barbour Walter barber 792342 792342 Barbour, Walter, of Tamworth, Warws, barber 0
5185229 2411426 2411426 defendant Barbour Walter barber 792342 792342 Barbour, Walter, of Tamworth, Warws, barber 0
5268526 2435915 2435915 defendant Ferrers Thomas   792342 792342 Ferrers, Thomas, of Tamworth, Warws, knight 0
5272326 2436976 2436976 defendant Bothe Richard yeoman 792342 792342 Bothe, Richard, of Tamworth, Warws, yeoman 0
5273790 2437415 2437415 defendant Bale Richard yeoman 792342 792342 Bale, Richard, of Tamworth, Warws, yeoman 0
5311494 2448465 2448465 defendant Walter Thomas chapman 792342 792342 Walter, Thomas, of Tamworth, Warws, chapman 2
5381955 2469895 2469895 defendant Hart John   792342 792342 Hart, John, of Tamworth, Warws 0
5381958 2469895 2469895 defendant Jacob Humphrey gentleman 792342 792342 Jacob, Humphrey, of Tamworth, Warws, gentleman 3
5388879 2471883 2471883 defendant Hart John tanner 792342 792342 Hart, John, of Tamworth, Warws, tanner 0
5390301 2472291 2472291 defendant Hart John tanner 792342 792342 Hart, John, of Tamworth, Warws, tanner 0
5392663 2472966 2472966 defendant Ferrers John   792342 792342 Ferrers, John, of Tamworth, Warws, knight 0
5432881 2484800 2484800 defendant Jacob Humphrey gent 792342 792342 Jacob, Humphrey, of Tamworth, Warws, gent 1

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);