names

20 rows where place_id = 629285

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3787347 1953835 1953835 defendant Stafford Robert husbandman 629285 629285 Stafford, Robert, of High Rothyng, husbandman 1
3787499 1953879 1953879 defendant Turnour Henry laborer 629285 629285 Turnour, Henry, of High Rothyng, laborer 1
3846102 1972339 1972339 defendant Blonderell Robert husbandman 629285 629285 Blonderell, Robert, of High Rothyng, husbandman 0
3860310 1976949 1976949 defendant Blounderell Robert husbandman 629285 629285 Blounderell, Robert, of High Rothyng, husbandman 0
3861942 1977454 1977454 defendant Harvy Thomas husbandman 629285 629285 Harvy, Thomas, of High Rothyng, husbandman 0
4417289 2170290 2170290 defendant Clerk John le   629285 629285 Clerk, John le, of High Rothyng 2
4445851 2183645 2183645 defendant Marath John   629285 629285 Marath, John, of High Rothyng 2
4519655 2206509 2206509 defendant Draper Stephen   629285 629285 Draper, Stephen, of High Rothyng 0
4533467 2210734 2210734 defendant Marlere John   629285 629285 Marlere, John, of High Rothyng 5
4680363 2259471 2259471 defendant Weston Thomas clerk & parson 629285 629285 Weston, Thomas, of High Rothyng, clerk & parson 1
4720467 2271737 2271737 defendant Foundour William laborer 629285 629285 Foundour, William, of High Rothyng, laborer 0
4734625 2275991 2275991 plaintiff Marchall William   629285 629285 Marchall, William, of High Rothyng, parson 2
4734630 2275992 2275992 plaintiff Marchall William   629285 629285 Marchall, William, of High Rothyng 2
4834819 2306893 2306893 defendant Marchaunt John husbandman 629285 629285 Marchaunt, John, of High Rothyng, husbandman 0
4834820 2306893 2306893 defendant Gybbe John husbandman 629285 629285 Gybbe, John, of High Rothyng, husbandman 1
4900982 2326935 2326935 defendant Davy William yeoman 629285 629285 Davy, William, of High Rothyng, yeoman 0
5044488 2369982 2369982 defendant Glastok Robert yeoman 629285 629285 Glastok, Robert, of High Rothyng, yeoman 1
5223809 2422648 2422648 defendant Spety John yeoman 629285 629285 Spety, John, of High Rothyng, yeoman 1
5526774 2512943 2512943 plaintiff Josselyn John gent 629285 629285 Josselyn, John, of High Rothyng, gent 0
5620378 2550232 2550232 defendant Grotton Nicholas   629285 629285 Grotton, Nicholas, of High Rothyng 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);