names

24 rows where place_id = 592507

✎ 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
3607908 1870123 1870123 defendant Hykman Stephen yeoman 592507 592507 Hykman, Stephen, of Twyford, Bucks, yeoman 0
3647226 1909518 1909518 defendant Frankeleyn Henry miller 592507 592507 Frankeleyn, Henry, of Twyford, Bucks, miller 4
3659051 1913094 1913094 defendant Gyfford Thomas (legal representative) 592507 592507 Gyfford, Thomas, of Twyford, Bucks, esq, executrix of 0
3680923 1920115 1920115 defendant Mantfeld John yeoman 592507 592507 Mantfeld, John, of Twyford, Bucks, yeoman 0
4128239 2070384 2070384 defendant Poole Thomas gent 592507 592507 Poole, Thomas, of Twyford, Bucks, or of Winsloe, Bucks, gent 0
4147299 2077194 2077194 defendant Huffer Edward husbandman 592507 592507 Huffer, Edward, of Twyford, Bucks, husbandman 0
4160885 2081880 2081880 defendant Poole Thomas gent 592507 592507 Poole, Thomas, of Twyford, Bucks, gent 0
4184349 2090026 2090026 defendant Poole Thomas gent 592507 592507 Poole, Thomas, of Twyford, Bucks, gent 0
4184351 2090027 2090027 defendant Poole Thomas gent 592507 592507 Poole, Thomas, of Twyford, Bucks, gent 0
4467795 2190605 2190605 defendant Dormer Robert   592507 592507 Dormer, Robert, of Twyford, Bucks 0
4467798 2190606 2190606 defendant Dormer Robert   592507 592507 Dormer, Robert, of Twyford, Bucks 0
4947046 2341070 2341070 defendant Gyfford Thomas esq 592507 592507 Gyfford, Thomas, of Twyford, Bucks, esq 1
5007183 2358991 2358991 defendant Gyfford Thomas esq 592507 592507 Gyfford, Thomas, of Twyford, Bucks, esq 1
5007187 2358992 2358992 defendant Gyfford Thomas esq 592507 592507 Gyfford, Thomas, of Twyford, Bucks, esq 1
5042796 2369452 2369452 defendant Gyfford Thomas esq 592507 592507 Gyfford, Thomas, of Twyford, Bucks, esq 0
5066377 2376470 2376470 defendant Gyfford Thomas esq 592507 592507 Gyfford, Thomas, of Twyford, Bucks, esq 0
5066379 2376471 2376471 defendant Gyfford Thomas esq 592507 592507 Gyfford, Thomas, of Twyford, Bucks, esq 0
5221741 2422055 2422055 defendant mainpernors for Gifford Thomas esq 592507 592507 mainpernors for Gifford, Thomas, of Twyford, Bucks, esq 4
5248558 2429704 2429704 defendant Gyfford Thomas esq 592507 592507 Gyfford, Thomas, of Twyford, Bucks, esq 0
5413609 2478995 2478995 defendant Gyfford John esq 592507 592507 Gyfford, John, of Twyford, Bucks, esq 0
5428938 2483572 2483572 defendant Gyfford John esq 592507 592507 Gyfford, John, of Twyford, Bucks, esq 0
5428944 2483575 2483575 defendant Gyfford John esq 592507 592507 Gyfford, John, of Twyford, Bucks, esq 0
5479523 2498887 2498887 defendant Gyfford Thomas gent 592507 592507 Gyfford, Thomas, of Twyford, Bucks, gent 1
5542763 2517857 2517857 defendant Gyfford John esq 592507 592507 Gyfford, John, of Twyford, Bucks, esq 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);