names

30 rows where place_id = 670167

✎ 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
3995940 2023301 2023301 defendant Thompson Lawrence yeoman 670167 670167 Thompson, Lawrence, of Enfeild, Middx, yeoman 2
4021696 2032485 2032485 defendant Hunsdon John, junior maltman 670167 670167 Hunsdon, John, junior, of Enfeild, Middx, maltman 0
4021699 2032486 2032486 defendant Hunsdon John, junior maltman 670167 670167 Hunsdon, John, junior, of Enfeild, Middx, maltman 0
4128639 2070536 2070536 defendant Newman William maltman 670167 670167 Newman, William, of Enfeild, Middx, maltman 0
4154199 2079564 2079564 defendant Deales alias Herrfourde John maltman 670167 670167 Deales alias Herrfourde, John, of Enfeild, Middx, maltman 0
4163543 2082771 2082771 defendant Wrothe Robert esq 670167 670167 Wrothe, Robert, of Enfeild, Middx, esq 0
4187103 2090981 2090981 defendant Wrothe Robert esq 670167 670167 Wrothe, Robert, of Enfeild, Middx, esq 0
4190465 2092219 2092219 defendant Taylor Jonas gent 670167 670167 Taylor, Jonas, of Enfeild, Middx, gent 1
4214198 2100484 2100484 defendant Eden William gent 670167 670167 Eden, William, of Enfeild, Middx, or of Barnards Inn, Holborne, gent 0
4214946 2100728 2100728 defendant Lawe Robert maltman 670167 670167 Lawe, Robert, of Enfeild, Middx, maltman 0
4218631 2102014 2102014 defendant Thymbleby William esq 670167 670167 Thymbleby, William, of Enfeild, Middx, esq 0
4227205 2104994 2104994 defendant Thymelbie William esq 670167 670167 Thymelbie, William, of Enfeild, Middx, esq 0
4228108 2105311 2105311 defendant Thimolbye William esq 670167 670167 Thimolbye, William, of Enfeild, Middx, esq 0
4232600 2106906 2106906 defendant Lawe Robert maltman 670167 670167 Lawe, Robert, of Enfeild, Middx, maltman 0
4234825 2107731 2107731 defendant Palfreyman Thomas (legal representative) 670167 670167 Palfreyman, Thomas, of Enfeild, Middx, gent, executors of 1
4261280 2116738 2116738 defendant Hodges Thomas   670167 670167 Hodges, Thomas, of Enfeild, Middx, meal man 0
4261282 2116739 2116739 defendant Hodges Thomas mealman 670167 670167 Hodges, Thomas, of Enfeild, Middx, mealman 0
4266861 2118558 2118558 defendant Palfreyman Thomas (legal representative) 670167 670167 Palfreyman, Thomas, of Enfeild, Middx, gent, executors of 1
4271689 2120112 2120112 defendant Herringford John gent 670167 670167 Herringford, John, of Enfeild, Middx, gent 0
4275408 2121334 2121334 defendant Hill Edward yeoman 670167 670167 Hill, Edward, of Enfeild, Middx, yeoman 0
4278988 2122583 2122583 defendant Thumbleby William esq 670167 670167 Thumbleby, William, of Enfeild, Middx, esq 0
4340697 2144019 2144019 defendant Hunsdon John maltman 670167 670167 Hunsdon, John, of Enfeild, Middx, maltman 0
4352696 2148175 2148175 defendant Pepper Robert gent 670167 670167 Pepper, Robert, of Enfeild, Middx, gent 0
4355293 2149071 2149071 defendant Hunsdon John maltman 670167 670167 Hunsdon, John, of Enfeild, Middx, maltman 0
4355295 2149072 2149072 defendant Deane alias Heringford Robert maltman 670167 670167 Deane alias Heringford, Robert, of Enfeild, Middx, maltman 0
4359836 2150680 2150680 defendant Deconson Thomas yeoman 670167 670167 Deconson, Thomas, of Enfeild, Middx, yeoman 2
4365319 2152661 2152661 defendant Jersey John loader 670167 670167 Jersey, John, of Enfeild, Middx, loader 0
4391363 2161728 2161728 defendant Bowles Thomas yeoman 670167 670167 Bowles, Thomas, of Enfeild, Middx, yeoman 2
4411921 2168581 2168581 defendant Edwardes William yeoman 670167 670167 Edwardes, William, of Enfeild, Middx, yeoman 0
5474865 2497466 2497466 defendant Aye John maltman 670167 670167 Aye, John, of Enfeild, Middx, maltman 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);