names

19 rows where place_id = 591581

✎ 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
3604886 1869193 1869193 defendant Martyn Robert yeoman 591581 591581 Martyn, Robert, of Lambehith, Surrey, yeoman 0
3605001 1869227 1869227 defendant Martyn Robert yeoman 591581 591581 Martyn, Robert, of Lambehith, Surrey, yeoman 0
3677199 1918911 1918911 defendant Huggon Robert gent 591581 591581 Huggon, Robert, of Lambehith, Surrey, gent 1
3677472 1919004 1919004 defendant Dune Humphrey gent 591581 591581 Dune, Humphrey, of Lambehith, Surrey, gent 4
3677479 1919005 1919005 defendant Dune Humphrey gent 591581 591581 Dune, Humphrey, of Lambehith, Surrey, gent 4
3861316 1977256 1977256 defendant Cranmere Edward clerk 591581 591581 Cranmere, Edward, of Lambehith, Surrey, clerk 0
3875432 1982028 1982028 defendant Cranmer Edmund clerk 591581 591581 Cranmer, Edmund, of Lambehith, Surrey, clerk 0
3895535 1988711 1988711 defendant Nebbe William yeoman and innholder 591581 591581 Nebbe, William, of Lambehith, Surrey, yeoman and innholder 1
3895545 1988713 1988713 defendant Nebbe William yeoman and innholder 591581 591581 Nebbe, William, of Lambehith, Surrey, yeoman and innholder 1
4004895 2026532 2026532 plaintiff Josselyn John gent 591581 591581 Josselyn, John, of Lambehith, Surrey, gent 0
4942348 2339596 2339596 defendant Banastre Henry gent 591581 591581 Banastre, Henry, of Lambehith, Surrey, gent 0
4942409 2339610 2339610 defendant Banastre Henry gent 591581 591581 Banastre, Henry, of Lambehith, Surrey, gent 4
4978845 2350629 2350629 defendant Banastre Henry gent 591581 591581 Banastre, Henry, of Lambehith, Surrey, gent 0
4994702 2355270 2355270 defendant Banastre Henry gent 591581 591581 Banastre, Henry, of Lambehith, Surrey, gent 0
5023358 2363738 2363738 defendant Deverose Thomas brewer 591581 591581 Deverose, Thomas, of Lambehith, Surrey, brewer 2
5543442 2518066 2518066 defendant Taillour William yeoman 591581 591581 Taillour, William, of Lambehith, Surrey, yeoman 2
5549229 2519822 2519822 plaintiff Bevyngton John (legal representative) 591581 591581 Bevyngton, John, of Lambehith, Surrey, yeoman, executors of 0
5582206 2529507 2529507 defendant Grete William clothmaker 591581 591581 Grete, William, of Lambehith, Surrey, clothmaker 0
5596997 2533974 2533974 defendant Ambrose William yeoman 591581 591581 Ambrose, William, of Lambehith, Surrey, yeoman 3

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