names

30 rows where place_id = 599172

✎ 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
3635590 1905934 1905934 plaintiff Peele Robert clerk 599172 599172 Peele, Robert, of Chylham, clerk 0
3649505 1910233 1910233 defendant Foxe William husbandman 599172 599172 Foxe, William, of Chylham, husbandman 0
3730204 1935672 1935672 defendant Copyn John yeoman 599172 599172 Copyn, John, of Chylham, yeoman 1
3742227 1939437 1939437 defendant Edward John butcher 599172 599172 Edward, John, of Chylham, butcher 0
3744106 1940054 1940054 defendant Pole Robert clerk 599172 599172 Pole, Robert, of Chylham, clerk 0
3745259 1940425 1940425 defendant Amyas William gent 599172 599172 Amyas, William, of Chylham, gent 0
3787489 1953877 1953877 defendant Payn Thomas yeoman 599172 599172 Payn, Thomas, of Chylham, yeoman 2
3791913 1955315 1955315 defendant Payne Thomas yeoman 599172 599172 Payne, Thomas, of Chylham, yeoman 0
3791914 1955315 1955315 defendant Hardyman Moise yeoman 599172 599172 Hardyman, Moise, of Chylham, yeoman 1
3791915 1955315 1955315 defendant Bedford Quintin husbandman 599172 599172 Bedford, Quintin, of Chylham, husbandman 2
3829319 1967054 1967054 defendant Petite William gent 599172 599172 (Petite, William, of Chylham, gent 1
4098777 2059892 2059892 defendant Hadd Arnold gent 599172 599172 Hadd, Arnold, of Chylham, gent 0
4098778 2059892 2059892 defendant Cobbe Thomas gent 599172 599172 Cobbe, Thomas, of Chylham, gent 1
4152462 2078973 2078973 defendant Strensham or Streynsham John gent 599172 599172 Strensham or Streynsham, John, of Chylham, or of Stone, gent 0
4230294 2106087 2106087 defendant Strensham John gent 599172 599172 Strensham, John, of Chylham, gent 0
4261046 2116659 2116659 defendant Strensham or Streynsham John gent 599172 599172 Strensham or Streynsham, John, of Chylham, gent 0
4312789 2134602 2134602 defendant Clyfford Edward yeoman 599172 599172 Clyfford, Edward, of Chylham, yeoman 0
4318195 2136470 2136470 defendant Packnam Richard husbandman 599172 599172 Packnam, Richard, of Chylham, or of Charinge, husbandman 1
4905448 2328297 2328297 defendant Symonde Robert husbandman 599172 599172 Symonde, Robert, of Chylham, husbandman 0
4958188 2344417 2344417 defendant Goldhacche Thomas wheeler 599172 599172 Goldhacche, Thomas, of Chylham, wheeler 1
5238452 2426836 2426836 defendant Beverle Thomas gent 599172 599172 Beverle, Thomas, of Chylham, gent 0
5248686 2429738 2429738 defendant Beverle Thomas gent 599172 599172 Beverle, Thomas, of Chylham, gent 0
5415549 2479592 2479592 defendant Segger Robert butcher 599172 599172 Segger, Robert, of Chylham, butcher 0
5549018 2519749 2519749 defendant Godard Robert smith 599172 599172 Godard, Robert, of Chylham, smith 0
5561407 2523313 2523313 defendant Fox William husbandman 599172 599172 Fox, William, of Chylham, husbandman 0
5603608 2536003 2536003 plaintiff Peele Robert clerk 599172 599172 Peele, Robert, of Chylham, clerk 0
5603610 2536003 2536003 defendant Fox William, senior husbandman 599172 599172 Fox, William, senior, of Chylham, husbandman 1
5603967 2536107 2536107 defendant Atwode Clement husbandman 599172 599172 Atwode, Clement, of Chylham, husbandman 0
5603968 2536107 2536107 defendant Fynegh John (legal representative) 599172 599172 Fynegh, John, of Chylham, carpenter, executrix of 1
5603969 2536107 2536107 defendant Fynegh Isolda widow 599172 599172 Fynegh, Isolda, of Chylham, widow 2

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);