names

17 rows where place_id = 602014

✎ 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
3648055 1909789 1909789 defendant Walsall Thomas gent 602014 602014 Walsall, Thomas, of Malpas, Cheshire, gent 0
3823809 1965337 1965337 defendant Brereton Randolph esq 602014 602014 Brereton, Randolph, of Malpas, Cheshire, esq 4
3862510 1977657 1977657 defendant Brereton Elizabeth widow 602014 602014 Brereton, Elizabeth, of Malpas, Cheshire, widow 1
3975344 2015943 2015943 defendant Brereton Randolph esq 602014 602014 Brereton, Randolph, of Malpas, Cheshire, esq 0
3975347 2015944 2015944 defendant Brereton Randolph esq 602014 602014 Brereton, Randolph, of Malpas, Cheshire, esq 0
4064868 2047721 2047721 defendant Brereton Ralph   602014 602014 Brereton, Ralph, of Malpas, Cheshire, knight 0
4218346 2101914 2101914 defendant Maffen John husbandman 602014 602014 Maffen, John, of Malpas, Cheshire, husbandman 0
4245416 2111442 2111442 defendant Sharpe Lionel gent 602014 602014 Sharpe, Lionel, of Malpas, Cheshire, clerk, or of London, gent 0
4268340 2119015 2119015 defendant Maffen John husbandman 602014 602014 Maffen, John, of Malpas, Cheshire, husbandman 0
4269577 2119414 2119414 defendant Sharpe Lionel gent 602014 602014 Sharpe, Lionel, of Malpas, Cheshire, clerk, or of London, gent 0
4345529 2145707 2145707 defendant Penkeman Richard husbandman 602014 602014 Penkeman, Richard, of Malpas, Cheshire, husbandman 1
5062059 2375211 2375211 defendant de Brereton Randolph esq 602014 602014 de Brereton, Randolph, of Malpas, Cheshire, esq 0
5100831 2386658 2386658 defendant de Brereton Randolph esq 602014 602014 de Brereton, Randolph, of Malpas, Cheshire, or of Ipstones, Staffs, esq 0
5195497 2414432 2414432 defendant Brereton Randolf esq 602014 602014 Brereton, Randolf, of Malpas, Cheshire, esq 0
5359723 2463080 2463080 defendant Breerton Randolph   602014 602014 Breerton, Randolph, of Malpas, Cheshire, knight 1
5488710 2501504 2501504 defendant Madesen David yeoman 602014 602014 Madesen, David, of Malpas, Cheshire, yeoman 0
5488715 2501505 2501505 defendant Masesen David yeoman 602014 602014 Masesen, David, of Malpas, Cheshire, yeoman 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);