names

19 rows where place_id = 619950

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3732816 1936492 1936492 defendant Poly John husbandman 619950 619950 Poly, John, of Whersted, husbandman 3
3746422 1940801 1940801 defendant Cawston Anne widow 619950 619950 Cawston, Anne, of Whersted, widow 0
3777602 1950747 1950747 defendant Cawston Anne widow 619950 619950 Cawston, Anne, of Whersted, widow 0
3794369 1956117 1956117 defendant Caston Anne widow 619950 619950 Caston, Anne, of Whersted, widow 0
3794371 1956118 1956118 defendant Caston Anne widow 619950 619950 Caston, Anne, of Whersted, widow 0
3806140 1959848 1959848 defendant Thacker William husbandman 619950 619950 Thacker, William, of Whersted, husbandman 1
3900717 1990469 1990469 plaintiff Caston Thomas (legal representative) 619950 619950 Caston, Thomas, of Whersted, yeoman, executrix of 0
3928321 1999807 1999807 defendant Hobard Roger yeoman 619950 619950 Hobard, Roger, of Whersted, yeoman 0
4167318 2084068 2084068 defendant Fokes Thomas yeoman 619950 619950 Fokes, Thomas, of Whersted, yeoman 2
4190791 2092342 2092342 defendant Fookes Thomas yeoman 619950 619950 Fookes, Thomas, of Whersted, yeoman 2
4303243 2131261 2131261 defendant Gooche Richard yeoman 619950 619950 Gooche, Richard, of Whersted, yeoman 0
4338684 2143284 2143284 defendant Bennett William blacksmith 619950 619950 Bennett, William, of Whersted, blacksmith 2
4356403 2149467 2149467 defendant Gooche Richard yeoman 619950 619950 Gooche, Richard, of Whersted, yeoman 0
5162873 2404861 2404861 defendant Pyman Thomas tailor 619950 619950 Pyman, Thomas, of Whersted, tailor 3
5176756 2408887 2408887 defendant Pyman Thomas tailor 619950 619950 Pyman, Thomas, of Whersted, tailor 1
5210957 2418936 2418936 defendant Pyman Thomas tailor 619950 619950 Pyman, Thomas, of Whersted, tailor 3
5349179 2459869 2459869 defendant Meryell John husbandman 619950 619950 Meryell, John, of Whersted, husbandman 0
5481237 2499336 2499336 defendant Meryall John husbandman 619950 619950 Meryall, John, of Whersted, husbandman 4
5491427 2502321 2502321 defendant Meriell John husbandman 619950 619950 Meriell, John, of Whersted, husbandman 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);