names

22 rows where place_id = 600771

✎ 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
3642447 1908081 1908081 defendant Horwell Thomas gent 600771 600771 Horwell, Thomas, of Aston, Warks, gent 3
3737726 1938021 1938021 defendant Broke Simon clerk 600771 600771 Broke, Simon, of Aston, Warks, clerk 2
3807684 1960296 1960296 defendant Arden Thomas esq 600771 600771 Arden, Thomas, of Aston, Warks, esq 3
3856083 1975525 1975525 defendant Arderne Thomas esq 600771 600771 Arderne, Thomas, of Aston, Warks, esq 1
3856802 1975751 1975751 defendant Arderne Thomas esq 600771 600771 Arderne, Thomas, of Aston, Warks, esq 1
3856807 1975752 1975752 defendant Arderne Thomas esq 600771 600771 Arderne, Thomas, of Aston, Warks, esq 1
3999705 2024656 2024656 defendant Harryson John chapman 600771 600771 Harryson, John, of Aston, Warks, chapman 3
4013006 2029384 2029384 defendant Sherwyn Edward   600771 600771 Sherwyn, Edward, of Aston, Warks, yeoman, son of Humphrey 1
4078524 2052617 2052617 defendant Hasterley John smith 600771 600771 Hasterley, John, of Aston, Warks, smith 1
4178038 2087789 2087789 defendant Wirley Abraham gent 600771 600771 Wirley, Abraham, of Aston, Warks, gent 0
4204894 2097252 2097252 defendant Hedges John yeoman 600771 600771 Hedges, John, of Aston, Warks, yeoman 0
4943615 2339972 2339972 defendant Holt John esq 600771 600771 Holt, John, of Aston, Warks, esq 0
4943617 2339973 2339973 defendant Holt John esq 600771 600771 Holt, John, of Aston, Warks, esq 0
4957424 2344188 2344188 defendant Holte John esq 600771 600771 Holte, John, of Aston, Warks, esq 0
4963806 2346086 2346086 defendant Ardern Robert esq 600771 600771 Ardern, Robert, of Aston, Warks, esq 2
4976847 2350026 2350026 defendant Holt John gent 600771 600771 Holt, John, of Aston, Warks, gent 4
4981348 2351343 2351343 defendant Holt John esq 600771 600771 Holt, John, of Aston, Warks, esq 1
4981354 2351344 2351344 defendant Holt John esq 600771 600771 Holt, John, of Aston, Warks, esq 4
4984370 2352254 2352254 defendant Holt John esq 600771 600771 Holt, John, of Aston, Warks, esq 1
5084339 2381826 2381826 defendant Holt John esq 600771 600771 Holt, John, of Aston, Warks, esq 1
5089450 2383286 2383286 defendant Holt John esq 600771 600771 Holt, John, of Aston, Warks, esq 4
5482588 2499733 2499733 defendant Ardern Walter gent 600771 600771 Ardern, Walter, of Aston, Warks, gent 5

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