names

10 rows where place_id = 599058

✎ 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
3635021 1905752 1905752 defendant Goldyng Richard husbandman 599058 599058 Goldyng, Richard, of Normanton, Derbs, husbandman 1
3644734 1908758 1908758 defendant Wyng Thomas chaplain 599058 599058 Wyng, Thomas, of Normanton, Derbs, chaplain 1
3823290 1965198 1965198 defendant Symson Richard husbandman 599058 599058 Symson, Richard, of Normanton, Derbs, husbandman 1
3930846 2000656 2000656 defendant Babyngton Augustine gent 599058 599058 Babyngton, Augustine, of Normanton, Derbs, gent 0
3930848 2000657 2000657 defendant Babyngton Augustine gent 599058 599058 Babyngton, Augustine, of Normanton, Derbs, gent 0
4210089 2099091 2099091 defendant Babington John gent 599058 599058 Babington, John, of Normanton, Derbs, gent 0
4211453 2099559 2099559 defendant Babyngton John gent 599058 599058 Babyngton, John, of Normanton, Derbs, gent 0
4708783 2268117 2268117 defendant Chellardeston Thomas   599058 599058 Chellardeston, Thomas, of Normanton, Derbs, parson 1
4909360 2329467 2329467 defendant Bygge John husbandman 599058 599058 Bygge, John, of Normanton, DERbs, husbandman 1
5262105 2433895 2433895 defendant Brygge Richard husbandman 599058 599058 Brygge, Richard, of Normanton, Derbs, husbandman 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);