names

13 rows where place_id = 636138

✎ 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
3675871 1918490 1918490 defendant Benge John (legal representative) 636138 636138 Benge, John, of Wadhurst, Sussex, gent, executor of 0
3829109 1966985 1966985 defendant May Thomas gent 636138 636138 May, Thomas, of Wadhurst, Sussex, gent 1
3890940 1987234 1987234 defendant Chidley George clerk 636138 636138 Chidley, George, of Wadhurst, Sussex, clerk 0
4049294 2042194 2042194 defendant Turke Agnes widow 636138 636138 Turke, Agnes, of Wadhurst, Sussex, widow 0
4125403 2069370 2069370 defendant Baker Thomas yeoman 636138 636138 Baker, Thomas, of Wadhurst, Sussex, yeoman 0
4346458 2146013 2146013 defendant Gawson John chapman 636138 636138 Gawson, John, of Wadhurst, Sussex, chapman 0
4369145 2154030 2154030 defendant Ganson John innholder 636138 636138 Ganson, John, of Wadhurst, Sussex, innholder 1
4383957 2159340 2159340 defendant Burckham James smith 636138 636138 Burckham, James, of Wadhurst, Sussex, smith 2
4769022 2286287 2286287 defendant Luk Gilbert chapman 636138 636138 Luk, Gilbert, of Wadhurst, Sussex, chapman 2
5146637 2400154 2400154 defendant Shapp Richard yeoman 636138 636138 Shapp, Richard, of Wadhurst, Sussex, yeoman 2
5183686 2410962 2410962 defendant Kyngewode Thomas tanner 636138 636138 Kyngewode, Thomas, of Wadhurst, Sussex, tanner 1
5183690 2410963 2410963 defendant Kyngewode Thomas tanner 636138 636138 Kyngewode, Thomas, of Wadhurst, Sussex, tanner 1
5203959 2416907 2416907 defendant Kyngewode Thomas tanner 636138 636138 Kyngewode, Thomas, of Wadhurst, Sussex, tanner 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);