names

25 rows where place_id = 621045

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3739151 1938456 1938456 defendant Cheles John husbandman 621045 621045 Cheles, John, of Wynthorpe, husbandman 0
3785239 1953167 1953167 defendant Wesylhede William husbandman 621045 621045 Wesylhede, William, of Wynthorpe, husbandman 0
3903549 1991415 1991415 defendant Grene William husbandman 621045 621045 Grene, William, of Wynthorpe, husbandman 0
3946807 2005952 2005952 defendant Walker Thomas yeoman 621045 621045 Walker, Thomas, of Wynthorpe, yeoman 0
3954906 2008782 2008782 defendant Walker Thomas yeoman 621045 621045 Walker, Thomas, of Wynthorpe, yeoman 0
3955565 2009015 2009015 plaintiff Mawer Anthony   621045 621045 Mawer, Anthony, of Wynthorpe 0
3956183 2009236 2009236 plaintiff Mylnes William (legal representative) 621045 621045 Mylnes, William, of Wynthorpe, husbandman, executors of 0
3974230 2015552 2015552 plaintiff Harryson Thomas husbandman 621045 621045 Harryson, Thomas, of Wynthorpe, husbandman 0
4056683 2044778 2044778 defendant Richardson Robert yeoman 621045 621045 Richardson, Robert, of Wynthorpe, yeoman 0
4061058 2046362 2046362 defendant Stevenson John yeoman 621045 621045 Stevenson, John, of Wynthorpe, yeoman 5
4089387 2056491 2056491 defendant Playnt Richard tailor 621045 621045 Playnt, Richard, of Wynthorpe, tailor 0
4135255 2072928 2072928 defendant Melson Charles yeoman 621045 621045 Melson, Charles, of Wynthorpe, yeoman 0
4135256 2072928 2072928 defendant Dixon Thomas yeoman 621045 621045 Dixon, Thomas, of Wynthorpe, yeoman 1
4153085 2079179 2079179 defendant Haighe Nicholas clerk 621045 621045 Haighe, Nicholas, of Wynthorpe, clerk 0
4192286 2092863 2092863 defendant Allen Richard husbandman 621045 621045 Allen, Richard, of Wynthorpe, husbandman 1
4227288 2105026 2105026 defendant Fisher Margery widow 621045 621045 Fisher, Margery, of Wynthorpe, widow 0
4227290 2105027 2105027 defendant Fissher Margery widow 621045 621045 Fissher, Margery, of Wynthorpe, widow 0
4234455 2107592 2107592 defendant Phillipson William yeoman 621045 621045 Phillipson, William, of Wynthorpe, yeoman 0
4239414 2109405 2109405 defendant Wade Thomas clerk 621045 621045 Wade, Thomas, of Wynthorpe, clerk 0
4240040 2109642 2109642 defendant Moore William gent 621045 621045 Moore, William, of Wynthorpe, gent 0
4240041 2109642 2109642 defendant Bougham Robert   621045 621045 Bougham, Robert, of Wynthorpe 1
4240042 2109642 2109642 defendant Dakers Margaret spinster 621045 621045 Dakers, Margaret, of Wynthorpe, spinster 2
4273348 2120648 2120648 defendant Moore William gent 621045 621045 Moore, William, of Wynthorpe, gent 0
4273349 2120648 2120648 defendant Bougham Robert laborer 621045 621045 Bougham, Robert, of Wynthorpe, laborer 1
4273350 2120648 2120648 defendant Dakers Margaret spinster 621045 621045 Dakers, Margaret, of Wynthorpe, spinster 2

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