names

20 rows where place_id = 625033

✎ 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
3761720 1945675 1945675 defendant Atkyns Thomas husbandman 625033 625033 Atkyns, Thomas, of Sondey, husbandman 1
3761721 1945675 1945675 defendant Alderigge Thomas husbandman 625033 625033 Alderigge, Thomas, of Sondey, husbandman 2
3809967 1961003 1961003 defendant Ryggys Edward yeoman 625033 625033 Ryggys, Edward, of Sondey, yeoman 0
4257507 2115485 2115485 defendant Underwood John yeoman 625033 625033 Underwood, John, of Sondey, yeoman 0
4712617 2269264 2269264 plaintiff Smyth William   625033 625033 Smyth, William, of Sondey 0
4719016 2271294 2271294 defendant Cheleston John yeoman 625033 625033 Cheleston, John, of Sondey, yeoman 2
4750802 2280716 2280716 defendant Lilye John clerk 625033 625033 Lilye, John, of Sondey, clerk 0
4750803 2280716 2280716 defendant Godale John chaplain 625033 625033 Godale, John, of Sondey, chaplain 1
4750804 2280716 2280716 defendant Parson-servant Peter the Frenchman 625033 625033 Parson-servant, Peter the, of Sondey, Frenchman 2
4772339 2287314 2287314 defendant Chelaston John warrener 625033 625033 Chelaston, John, of Sondey, warrener 1
4821515 2302815 2302815 plaintiff Rycheman Henry   625033 625033 Rycheman, Henry, of Sondey 0
4879276 2320454 2320454 defendant Richeman Henry husbandman 625033 625033 Richeman, Henry, of Sondey, husbandman 1
4920506 2332928 2332928 defendant Balewey Peter yeoman 625033 625033 Balewey, Peter, of Sondey, yeoman 1
4972029 2348572 2348572 defendant Bussh Richard husbandman 625033 625033 Bussh, Richard, of Sondey, husbandman 0
5085354 2382110 2382110 defendant Thornton William yeoman 625033 625033 Thornton, William, of Sondey, yeoman 1
5395188 2473697 2473697 plaintiff Abdy Robert (legal representative) 625033 625033 Abdy, Robert, of Sondey, Master & rector, executors of 0
5395193 2473698 2473698 plaintiff Abdy Robert Master & rector 625033 625033 Abdy, Robert, of Sondey, Master & rector 0
5408427 2477493 2477493 plaintiff Abdy Robert clerk 625033 625033 Abdy, Robert, of Sondey, clerk, executors of: , clerk 0
5550241 2520103 2520103 defendant Byngham Simon husbandman 625033 625033 Byngham, Simon, of Sondey, husbandman 1
5550243 2520103 2520103 defendant Maddyng William husbandman 625033 625033 Maddyng, William, of Sondey, husbandman 3

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