names

22 rows where place_id = 608771

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3675315 1918321 1918321 defendant Palmer Robert carpenter 608771 608771 Palmer, Robert, of Felbrygge, carpenter 3
3881796 1984163 1984163 defendant Lokesmyth Leonard husbandman 608771 608771 Lokesmyth, Leonard, of Felbrygge, husbandman 0
4118405 2066875 2066875 defendant Wyndam Roger esq 608771 608771 Wyndam, Roger, of Felbrygge, esq 0
4207912 2098325 2098325 defendant Wyndham Roger esq 608771 608771 Wyndham, Roger, of Felbrygge, esq 0
4535336 2211322 2211322 defendant Warner Robert   608771 608771 Warner, Robert, of Felbrygge 0
4627038 2239405 2239405 plaintiff Reed Edmund   608771 608771 Reed, Edmund, of Felbrygge 0
4627039 2239405 2239405 defendant Reyner alias Deye William   608771 608771 Reyner alias Deye, William, of Felbrygge 0
4654998 2247446 2247446 defendant Gayne Thomas esq 608771 608771 Gayne, Thomas, of Felbrygge, esq 1
4655005 2247447 2247447 defendant Gayne Thomas esq 608771 608771 Gayne, Thomas, of Felbrygge, esq 1
4666257 2250917 2250917 defendant Engayn Thomas gent 608771 608771 Engayn, Thomas, of Felbrygge, gent 4
4809710 2299200 2299200 defendant Alwyn John yeoman 608771 608771 Alwyn, John, of Felbrygge, yeoman 0
4938423 2338396 2338396 defendant Trewe Alice widow 608771 608771 Trewe, Alice, of Felbrygge, widow 4
5065194 2376126 2376126 defendant Mody John, senior husbandman 608771 608771 Mody, John, senior, of Felbrygge, husbandman 0
5065195 2376126 2376126 defendant Mody John, junior shipman 608771 608771 Mody, John, junior, of Felbrygge, shipman 1
5270187 2436382 2436382 defendant Magnus Nicholas   608771 608771 Magnus, Nicholas, of Felbrygge, shepherd 1
5370388 2466325 2466325 defendant Magnus Nicholas (legal representative) 608771 608771 Magnus, Nicholas, of Felbrygge, shepherd, executors of 0
5370389 2466325 2466325 defendant Magnus Joan widow 608771 608771 (Magnus, Joan, of Felbrygge, widow 1
5400818 2475298 2475298 defendant Magnus Nicholas (legal representative) 608771 608771 Magnus, Nicholas, of Felbrygge, shepherd, executor of 0
5538043 2516384 2516384 defendant Rammysbury William gent 608771 608771 Rammysbury, William, of Felbrygge, gent 11
5608824 2537662 2537662 defendant Magnus Icholas (legal representative) 608771 608771 Magnus, Icholas, of Felbrygge, shepherd, executors of 0
5608825 2537662 2537662 defendant Magnus Joan widow 608771 608771 (Magnus, Joan, of Felbrygge, widow 1
5632215 2554101 2554101 plaintiff Staundon John   608771 608771 Staundon, John, of Felbrygge 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);