names

22 rows where place_id = 588769

✎ 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
3595516 1866232 1866232 defendant Rokes Thomas esq 588769 588769 Rokes, Thomas, of Falley, Bucks, esq 0
3598754 1867238 1867238 defendant Rokes Thomas, senior esq 588769 588769 Rokes, Thomas, senior, of Falley, Bucks, esq 0
3608218 1870226 1870226 defendant Rokes Thomas, senior esq 588769 588769 Rokes, Thomas, senior, of Falley, Bucks, esq 0
3617757 1873178 1873178 defendant Rokes Thomas, junior   588769 588769 Rokes, Thomas, junior, of Falley, Bucks, hent 1
3640192 1907374 1907374 defendant Rokes Thomas esq 588769 588769 Rokes, Thomas, of Falley, Bucks, esq 3
3682987 1920792 1920792 defendant Rokes Thomas esq 588769 588769 Rokes, Thomas, of Falley, Bucks, esq 0
3687434 1922248 1922248 defendant Berd William yeoman 588769 588769 Berd, William, of Falley, Bucks, yeoman 1
3765841 1946982 1946982 defendant Jemot Humphrey husbandman 588769 588769 Jemot, Humphrey, of Falley, Bucks, husbandman 0
4514989 2205094 2205094 plaintiff Caysho John   588769 588769 Caysho, John, of Falley, Bucks, parson 0
4882087 2321295 2321295 defendant Sakevyle Thomas   588769 588769 Sakevyle, Thomas, of Falley, Bucks, knight 0
4894946 2325082 2325082 defendant Sakevyle Thomas   588769 588769 Sakevyle, Thomas, of Falley, Bucks, knight 0
5243916 2428412 2428412 plaintiff Parker Thomas   588769 588769 Parker, Thomas, of Falley, Bucks 0
5342303 2457790 2457790 defendant Rokys Thomas esq 588769 588769 Rokys, Thomas, of Falley, Bucks, esq 0
5358145 2462610 2462610 defendant Rokes Thomas esq 588769 588769 Rokes, Thomas, of Falley, Bucks, esq 2
5358198 2462620 2462620 defendant Rokes Thomas esq 588769 588769 Rokes, Thomas, of Falley, Bucks, esq 0
5376137 2468128 2468128 defendant Rokes Thomas esq 588769 588769 Rokes, Thomas, of Falley, Bucks, esq 0
5553872 2521172 2521172 defendant Rokys Thomas gent 588769 588769 Rokys, Thomas, of Falley, Bucks, gent 0
5559268 2522678 2522678 defendant Rokes Thomas, senior gent 588769 588769 Rokes, Thomas, senior, of Falley, Bucks, gent 0
5581412 2529255 2529255 defendant Rokes Thomas esq 588769 588769 Rokes, Thomas, of Falley, Bucks, esq 0
5591935 2532464 2532464 defendant Rokes Thomas esq 588769 588769 Rokes, Thomas, of Falley, Bucks, esq 0
5592470 2532631 2532631 defendant Rokes Thomas gent 588769 588769 Rokes, Thomas, of Falley, Bucks, gent 0
5602586 2535704 2535704 defendant Rokes Thomas gent 588769 588769 Rokes, Thomas, of Falley, Bucks, gent 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);