names

27 rows where place_id = 614809

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3705643 1928046 1928046 defendant Golleffer William mercer 614809 614809 Golleffer, William, of Brewton, mercer 0
3744624 1940213 1940213 defendant Samway Robert innholder 614809 614809 Samway, Robert, of Brewton, innholder 1
3797427 1957083 1957083 defendant Hill Robert yeoman 614809 614809 Hill, Robert, of Brewton, yeoman 0
3797428 1957083 1957083 defendant Anattys or Avattys Thomas painter 614809 614809 Anattys or Avattys, Thomas, of Brewton, painter 1
3934573 2001858 2001858 defendant Myles John yeoman 614809 614809 Myles, John, of Brewton, yeoman 0
4004097 2026238 2026238 defendant Morgan John tucker 614809 614809 Morgan, John, of Brewton, tucker 0
4007513 2027471 2027471 defendant Davadgem Robert Soms, chapman 614809 614809 Davadgem Robert, of Brewton, Soms, chapman 0
4026373 2034075 2034075 defendant Northe John vintner 614809 614809 Northe, John, of Brewton, vintner 0
4051427 2042931 2042931 defendant Lambell Nicholas mercer 614809 614809 Lambell, Nicholas, of Brewton, mercer 0
4077360 2052187 2052187 plaintiff Spencer or Spicer Edward yeoman 614809 614809 Spencer or Spicer, Edward, of Brewton, yeoman 0
4121065 2067823 2067823 defendant Cope Thomas yeoman 614809 614809 Cope, Thomas, of Brewton, or of West Lydford, yeoman 0
4178150 2087829 2087829 defendant Deverell John mercer 614809 614809 Deverell, John, of Brewton, yeoman, mercer 0
4201382 2096034 2096034 defendant Deverell John   614809 614809 Deverell, John, of Brewton, woollen draper 0
4201383 2096034 2096034 defendant Ellyott John baker 614809 614809 Ellyott, John, of Brewton, baker 1
4240489 2109800 2109800 defendant Valleys Thomas gent 614809 614809 Valleys, Thomas, of Brewton, or of Silton, Dorset, gent 0
4240490 2109800 2109800 defendant Willoughbee William esq 614809 614809 Willoughbee, William, of Brewton, or of Silton, esq 1
4276133 2121599 2121599 defendant Davys Robert butcher 614809 614809 Davys, Robert, of Brewton, butcher 0
4279093 2122619 2122619 defendant Emlen Thomas husbandman 614809 614809 Emlen, Thomas, of Brewton, husbandman 0
4279094 2122619 2122619 defendant Dyser Edward yeoman 614809 614809 Dyser, Edward, of Brewton, yeoman 1
4279095 2122619 2122619 defendant Holwey Thomas yeoman 614809 614809 Holwey, Thomas, of Brewton, yeoman 2
4286209 2125121 2125121 defendant Dycer Richard butcher 614809 614809 Dycer, Richard, of Brewton, butcher 2
4290150 2126545 2126545 defendant Ames Richard vintner 614809 614809 Ames, Richard, of Brewton, or of Welles, vintner 0
4303856 2131480 2131480 defendant Sheppard John husbandman 614809 614809 Sheppard, John, of Brewton, husbandman 2
4319614 2136973 2136973 defendant Colborne John yeoman 614809 614809 Colborne, John, of Brewton, yeoman 1
4332368 2141117 2141117 defendant Witche William yeoman 614809 614809 Witche, William, of Brewton, yeoman 1
4368529 2153790 2153790 defendant Langer John husbandman 614809 614809 Langer, John, of Brewton, husbandman 1
5569219 2525553 2525553 defendant Samwyse Robert innholder 614809 614809 Samwyse, Robert, of Brewton, innholder 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);