names

27 rows where place_id = 596942

✎ 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
3626707 1903199 1903199 defendant Burton John clerk 596942 596942 Burton, John, of Nedgyng, clerk 0
3644087 1908581 1908581 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 1
3662055 1914064 1914064 defendant Burtne Roger clerk 596942 596942 Burtne, Roger, of Nedgyng, clerk 11
3674592 1918105 1918105 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 0
3684245 1921204 1921204 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 0
3687584 1922292 1922292 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 0
3703884 1927494 1927494 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 0
3759480 1944958 1944958 defendant Mores Thomas thatcher 596942 596942 Mores, Thomas, of Nedgyng, thatcher 1
3759481 1944958 1944958 defendant Gefford Henry laborer 596942 596942 Gefford, Henry, of Nedgyng, laborer 2
3759586 1944988 1944988 defendant Fuller Richard yeoman 596942 596942 Fuller, Richard, of Nedgyng, yeoman 0
3759587 1944988 1944988 defendant Fuller Hugh husbandman 596942 596942 Fuller, Hugh, of Nedgyng, husbandman 1
3759588 1944988 1944988 defendant Fuller William husbandman 596942 596942 Fuller, William, of Nedgyng, husbandman 2
3852477 1974382 1974382 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 1
3859270 1976593 1976593 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 2
3866695 1979095 1979095 defendant Lylly Robert laborer 596942 596942 Lylly, Robert, of Nedgyng, laborer 0
3869879 1980171 1980171 defendant Fuller Richard yeoman 596942 596942 Fuller, Richard, of Nedgyng, yeoman 0
3869880 1980171 1980171 defendant Wade Robert husbandman 596942 596942 Wade, Robert, of Nedgyng, husbandman 1
3873481 1981347 1981347 defendant Fuller Hugh husbandman 596942 596942 Fuller, Hugh, of Nedgyng, husbandman 2
3919370 1996810 1996810 defendant Crofte Robert clerk 596942 596942 Crofte, Robert, of Nedgyng, clerk 0
4289907 2126451 2126451 defendant Pamant John miller 596942 596942 Pamant, John, of Nedgyng, miller 0
4330594 2140527 2140527 defendant Monnyng Thomas gent 596942 596942 Monnyng, Thomas, of Nedgyng, gent 1
5341823 2457635 2457635 defendant Baker William yeoman 596942 596942 Baker, William, of Nedgyng, yeoman 2
5434521 2485267 2485267 defendant Baker Edward yeoman 596942 596942 Baker, Edward, of Nedgyng, yeoman 2
5495598 2503583 2503583 defendant Baker William husbandman 596942 596942 Baker, William, of Nedgyng, husbandman 2
5596750 2533901 2533901 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 0
5604764 2536352 2536352 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 1
5607451 2537226 2537226 defendant Fuller Richard husbandman 596942 596942 Fuller, Richard, of Nedgyng, husbandman 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);