names

32 rows where place_id = 645745

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3887164 1985970 1985970 defendant Morton Robert, senior esq 645745 645745 Morton, Robert, senior, of Holborne St Andrew, Middx, esq 0
3954541 2008659 2008659 defendant Lloyd Lewis innholder 645745 645745 Lloyd, Lewis, of Holborne St Andrew, Middx, innholder 0
3954741 2008724 2008724 plaintiff Lloid Lewis yeoman 645745 645745 Lloid, Lewis, of Holborne St Andrew, Middx, yeoman 0
3961689 2011189 2011189 defendant Gryffyn Anne widow 645745 645745 Gryffyn, Anne, of Holborne St Andrew, Middx, widow 1
3983454 2018858 2018858 defendant Lloyd Lewis innholder 645745 645745 Lloyd, Lewis, of Holborne St Andrew, Middx, innholder 1
3987078 2020121 2020121 defendant Couper John gent 645745 645745 Couper, John, of Holborne St Andrew, Middx, gent 0
4000069 2024791 2024791 defendant Madock John gent 645745 645745 Madock, John, of Holborne St Andrew, Middx, gent 0
4018611 2031388 2031388 plaintiff Vesse William bricklayer 645745 645745 Vesse, William, of Holborne St Andrew, Middx, bricklayer 0
4126352 2069715 2069715 defendant Pigott John gent 645745 645745 Pigott, John, of Holborne St Andrew, Middx, gent 0
4135614 2073060 2073060 defendant Homes John tailor 645745 645745 Homes, John, of Holborne St Andrew, Middx, tailor 2
4243083 2110678 2110678 defendant Lever John clothworker 645745 645745 Lever, John, of Holborne St Andrew, Middx, clothworker 0
4253373 2114119 2114119 defendant Lever John clothworker 645745 645745 Lever, John, of Holborne St Andrew, Middx, clothworker 0
4267012 2118608 2118608 defendant Lapworth Richard gent 645745 645745 Lapworth, Richard, of Holborne St Andrew, Middx, gent 2
4273457 2120680 2120680 defendant Laverock Thomas   645745 645745 Laverock, Thomas, of Holborne St Andrew, Middx, gun maker 0
4273833 2120794 2120794 defendant Hutton Roger gent 645745 645745 Hutton, Roger, of Holborne St Andrew, Middx, gent 0
4292038 2127225 2127225 defendant Medley Clement gent 645745 645745 Medley, Clement, of Holborne St Andrew, Middx, gent 1
4307103 2132620 2132620 defendant Tyncker William grocer 645745 645745 Tyncker, William, of Holborne St Andrew, Middx, grocer 0
4327242 2139438 2139438 defendant Tinson Samuel cordwainer 645745 645745 Tinson, Samuel, of Holborne St Andrew, Middx, cordwainer 0
4349790 2147186 2147186 defendant Asheley Anthony   645745 645745 Asheley, Anthony, of Holborne St Andrew, Middx, knight 0
4356702 2149574 2149574 defendant Towers Richard tailor 645745 645745 Towers, Richard, of Holborne St Andrew, Middx, tailor 0
4358041 2150054 2150054 defendant Gyle Thomas gent 645745 645745 Gyle, Thomas, of Holborne St Andrew, Middx, gent 1
4370232 2154414 2154414 defendant Hannam Richard yeoman 645745 645745 Hannam, Richard, of Holborne St Andrew, Middx, yeoman 0
4392533 2162122 2162122 defendant Taylor Faith fletcher 645745 645745 Taylor, Faith, of Holborne St Andrew, Middx, fletcher 1
5060894 2374832 2374832 defendant Fulbroke Robert gent 645745 645745 Fulbroke, Robert, of Holborne St Andrew, Middx, gent 1
5094348 2384752 2384752 defendant Hyde William gent 645745 645745 Hyde, William, of Holborne St Andrew, Middx, gent 1
5094351 2384753 2384753 defendant Hyde William gent 645745 645745 Hyde, William, of Holborne St Andrew, Middx, gent 1
5107051 2388493 2388493 defendant Cotes Hugh esq 645745 645745 Cotes, Hugh, of Holborne St Andrew, Middx, esq 2
5107124 2388515 2388515 plaintiff Dee Richard (legal representative) 645745 645745 Dee, Richard, of Holborne St Andrew, Middx, executors of 0
5107129 2388516 2388516 plaintiff Dee Richard (legal representative) 645745 645745 Dee, Richard, of Holborne St Andrew, Middx, executors of 0
5107134 2388517 2388517 plaintiff Dee Richard (legal representative) 645745 645745 Dee, Richard, of Holborne St Andrew, Middx, executors of 0
5218136 2421039 2421039 defendant Holbeme Robert gent 645745 645745 Holbeme, Robert, of Holborne St Andrew, Middx, gent 3
5251016 2430424 2430424 defendant Lymbery Thomas gent 645745 645745 Lymbery, Thomas, of Holborne St Andrew, Middx, gent 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);