names

22 rows where place_id = 610982

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686144 1921827 1921827 defendant Bekyrton William yeoman 610982 610982 Bekyrton, William, of Alcestre, Warks, yeoman 0
3812496 1961796 1961796 defendant Davy Robert carpenter 610982 610982 Davy, Robert, of Alcestre, Warks, carpenter 0
3812500 1961797 1961797 defendant Davy Robert carpenter 610982 610982 Davy, Robert, of Alcestre, Warks, carpenter 0
3974003 2015477 2015477 defendant Page Richard husbandman 610982 610982 Page, Richard, of Alcestre, Warks, husbandman 0
4869695 2317487 2317487 defendant Bulnaker John husbandman 610982 610982 Bulnaker, John, of Alcestre, Warks, husbandman 0
4884756 2322133 2322133 defendant Mullyng Ralph chapman 610982 610982 Mullyng, Ralph, of Alcestre, Warks, chapman 0
4896419 2325547 2325547 defendant Mullyng Ralph chapman 610982 610982 Mullyng, Ralph, of Alcestre, Warks, chapman 0
5098266 2385921 2385921 defendant Hogges Nicholas barker 610982 610982 Hogges, Nicholas, of Alcestre, Warks, barker 1
5216113 2420443 2420443 defendant Elderbek Herman goldsmith 610982 610982 Elderbek, Herman, of Alcestre, Warks, goldsmith 0
5222532 2422305 2422305 defendant Goldsmyth alias Enderbek Herman goldsmith 610982 610982 Goldsmyth alias Enderbek, Herman, of Alcestre, Warks, goldsmith 0
5222534 2422306 2422306 defendant Goldsmyth alias Enderbek Herman goldsmith 610982 610982 Goldsmyth alias Enderbek, Herman, of Alcestre, Warks, goldsmith 0
5226555 2423431 2423431 defendant Elderbek Herman goldsmith 610982 610982 Elderbek, Herman, of Alcestre, Warks, goldsmith 0
5226558 2423432 2423432 defendant Elderbek Herman goldsmith 610982 610982 Elderbek, Herman, of Alcestre, Warks, goldsmith 0
5229320 2424186 2424186 defendant Lyndryche John tucker 610982 610982 Lyndryche, John, of Alcestre, Warks, tucker 0
5239467 2427125 2427125 defendant Cokkes Thomas   610982 610982 Cokkes, Thomas, of Alcestre, Warks, mason 1
5314673 2449423 2449423 defendant Spycer John mercer 610982 610982 Spycer, John, of Alcestre, Warks, mercer 0
5314676 2449424 2449424 defendant Spicer John mercer 610982 610982 Spicer, John, of Alcestre, Warks, mercer 0
5361618 2463656 2463656 defendant Panter Henry yeoman 610982 610982 Panter, Henry, of Alcestre, Warks, yeoman 1
5537246 2516132 2516132 defendant Blagge George yeoman 610982 610982 Blagge, George, of Alcestre, Warks, yeoman 0
5537248 2516133 2516133 defendant Hall Thomas draper 610982 610982 Hall, Thomas, of Alcestre, Warks, draper 0
5537258 2516138 2516138 defendant Sha John, senior yeoman 610982 610982 Sha, John, senior, of Alcestre, Warks, yeoman 0
5537262 2516140 2516140 defendant Typpyng Henry yeoman 610982 610982 Typpyng, Henry, of Alcestre, Warks, 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);