names

12 rows where place_id = 641274

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3860546 1977021 1977021 defendant Mundy William mercer 641274 641274 Mundy, William, of Aldeborne, mercer 0
4466672 2190252 2190252 defendant Adam John   641274 641274 Adam, John, of Aldeborne 0
4557888 2218399 2218399 plaintiff Crook John   641274 641274 (Crook, John, of Aldeborne, vicar 1
4611155 2234552 2234552 defendant Chepman John   641274 641274 Chepman, John, of Aldeborne 0
4648228 2245545 2245545 defendant Connyng John   641274 641274 Connyng, John, of Aldeborne 5
4654193 2247193 2247193 defendant Flory Agnes widow 641274 641274 Flory, Agnes, of Aldeborne, widow 1
4686124 2261253 2261253 defendant Conyng John butcher 641274 641274 Conyng, John, of Aldeborne, butcher 0
4745688 2279251 2279251 defendant Laurence Richard weaver 641274 641274 Laurence, Richard, of Aldeborne, weaver 1
4973296 2348951 2348951 defendant Bonoure John husbandman 641274 641274 Bonoure, John, of Aldeborne, husbandman 1
4985850 2352684 2352684 defendant Ingram John gent 641274 641274 Ingram, John, of Aldeborne, gent 0
5012954 2360621 2360621 defendant Walrond Ingelram gent 641274 641274 Walrond, Ingelram, of Aldeborne, gent 0
5541440 2517435 2517435 defendant White Richard chapman 641274 641274 White, Richard, of Aldeborne, chapman 1

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