names

24 rows where place_id = 603281

✎ 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
3654050 1911530 1911530 defendant Roodys Roger carver 603281 603281 Roodys, Roger, of Middx, carver 0
3661635 1913916 1913916 defendant Clowdesley Thomas yeoman 603281 603281 Clowdesley, Thomas, of Middx, yeoman 1
3688474 1922550 1922550 plaintiff Dalyson George yeoman 603281 603281 Dalyson, George, of Middx, yeoman 0
3776489 1950400 1950400 defendant Hartwell Robert husbandman 603281 603281 Hartwell, Robert, of Middx, husbandman 2
3959986 2010592 2010592 plaintiff Spencer Thomas skinner 603281 603281 Spencer, Thomas, of Middx, skinner 0
4000355 2024894 2024894 plaintiff Goultye Miles tailor 603281 603281 Goultye, Miles, of Middx, tailor 0
4004194 2026275 2026275 defendant George Isaac (legal representative) 603281 603281 George, Isaac, of Middx, gent, executor of 0
4030178 2035442 2035442 plaintiff Duckett Jasper gent 603281 603281 Duckett, Jasper, of Middx, gent 0
4071733 2050189 2050189 defendant James William gent 603281 603281 James, William, of Middx, gent 0
4330907 2140637 2140637 defendant Clarke Richard yeoman 603281 603281 Clarke, Richard, of Middx, yeoman 1
4715328 2270128 2270128 defendant London Ranulph   603281 603281 London, Ranulph, of Middx, abbot of the monastery of St Mary Graces, by the Tower of London 0
4715331 2270129 2270129 defendant London Ranulph   603281 603281 London, Ranulph, of Middx, abbot of the monastery of St Mary Graces, by the Tower of London 0
4787010 2292003 2292003 plaintiff Gomursall William   603281 603281 Gomursall, William, of Middx 0
4787016 2292004 2292004 plaintiff Gomursall William   603281 603281 Gomursall, William, of Middx 0
4883448 2321745 2321745 plaintiff Acton or Atton Thomas gent or vintner 603281 603281 Acton or Atton, Thomas, of Middx or of London, gent or vintner 0
4963253 2345918 2345918 defendant Byllyngey Nicholas yeoman 603281 603281 Byllyngey, Nicholas, of Middx, yeoman 0
4970240 2348053 2348053 plaintiff Haseley Thomas esq 603281 603281 Haseley, Thomas, of Middx, esq 0
4970243 2348054 2348054 plaintiff Haseley Thomas esq 603281 603281 Haseley, Thomas, of Middx, esq 0
5042859 2369474 2369474 plaintiff Elryngton Simon gent 603281 603281 Elryngton, Simon, of Middx, gent 0
5118341 2391801 2391801 defendant Halom William esq 603281 603281 Halom, William,of Middx, esq 1
5395046 2473650 2473650 defendant Parke William carpenter 603281 603281 Parke, William, of Middx, carpenter 1
5422566 2481698 2481698 plaintiff Barley William maltman 603281 603281 Barley, William, of Middx, maltman 0
5625124 2551795 2551795 plaintiff Lovell Thomas esq 603281 603281 Lovell, Thomas, of Middx, esq 0
5625957 2552077 2552077 plaintiff Maydeston Richard   603281 603281 Maydeston, Richard, of Middx 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);