names

14 rows where place_id = 615131

✎ 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
3707325 1928580 1928580 defendant Fysours John gent 615131 615131 Fysours, John, of Bishops Frome, Herefs, gent 2
4067528 2048702 2048702 defendant Browne Christopher   615131 615131 Browne, Christopher, of Bishops Frome, Herefs, gebt 0
4067532 2048704 2048704 defendant Browne Richard gent 615131 615131 Browne, Richard, of Bishops Frome, Herefs, gent 0
4067534 2048705 2048705 defendant Browne Roger gent 615131 615131 Browne, Roger, of Bishops Frome, Herefs, gent 0
4103094 2061396 2061396 defendant Whome Thomas yeoman or chapman 615131 615131 Whome, Thomas, of Bishops Frome, Herefs, yeoman or chapman 2
4105196 2062133 2062133 defendant Smyth Richard husbandman 615131 615131 Smyth, Richard, of Bishops Frome, Herefs, husbandman 0
4167952 2084277 2084277 defendant Browne Christopher gent 615131 615131 Browne, Christopher, of Bishops Frome, Herefs, gent 2
4167956 2084278 2084278 defendant Browne Christopher gent 615131 615131 Browne, Christopher, of Bishops Frome, Herefs, gent 2
4242500 2110491 2110491 defendant Dowdinge Richard gent 615131 615131 Dowdinge, Richard, of Bishops Frome, Herefs, gent 0
4252383 2113791 2113791 defendant Dowdinge Richard Gent 615131 615131 Dowdinge, Richard, of Bishops Frome, Herefs, Gent 0
4968230 2347451 2347451 defendant Hopton John gent 615131 615131 Hopton, John, of Bishops Frome, Herefs, gent 0
4968233 2347452 2347452 defendant Vysor Percival husbandman 615131 615131 Vysor, Percival, of Bishops Frome, Herefs, husbandman 0
5019366 2362546 2362546 defendant Hopton John gent 615131 615131 Hopton, John, of Bishops Frome, Herefs, gent 0
5572521 2526505 2526505 defendant Browne Thomas gent 615131 615131 Browne, Thomas, of Bishops Frome, Herefs, 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);