names

27 rows where place_id = 631730

✎ 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
3802419 1958654 1958654 defendant Nayler Lawrence clothier 631730 631730 Nayler, Lawrence, of Westerton, clothier 0
3979235 2017322 2017322 plaintiff Nayler Lawrence clothier 631730 631730 Nayler, Lawrence, of Westerton, clothier 0
3979239 2017323 2017323 plaintiff Nayler Lawrence clothier 631730 631730 Nayler, Lawrence, of Westerton, clothier 0
3979242 2017324 2017324 plaintiff Nayler Lawrence clothier 631730 631730 Nayler, Lawrence, of Westerton, clothier 0
4642296 2243866 2243866 defendant Pursere John   631730 631730 Pursere, John, of Westerton 0
4670702 2256517 2256517 defendant Purser John laborer 631730 631730 Purser, John, of Westerton, laborer 0
4678189 2258787 2258787 defendant Rose Thomas husbandman 631730 631730 Rose, Thomas, of Westerton, husbandman 0
4678531 2258891 2258891 defendant Rose Thomas husbandman 631730 631730 Rose, Thomas, of Westerton, husbandman 0
4693071 2263339 2263339 defendant Rose Thomas husbandman 631730 631730 Rose, Thomas, of Westerton, husbandman 1
4693072 2263339 2263339 defendant Purser William husbandman 631730 631730 Purser, William, of Westerton, husbandman 2
4696325 2264333 2264333 defendant Purser William laborer 631730 631730 Purser, William, of Westerton, laborer 1
4696326 2264333 2264333 defendant Clavour William laborer 631730 631730 Clavour, William, of Westerton, laborer 2
4709962 2268471 2268471 defendant Mortymer William laborer 631730 631730 Mortymer, William, of Westerton, laborer 3
4709963 2268471 2268471 defendant Clavyr William laborer 631730 631730 Clavyr, William, of Westerton, laborer 4
4711383 2268892 2268892 defendant Rose Thomas husbandman 631730 631730 Rose, Thomas, of Westerton, husbandman 3
4743390 2278597 2278597 defendant Purser William husbandman 631730 631730 Purser, William, of Westerton, husbandman 0
4834497 2306798 2306798 plaintiff Creswell Richard   631730 631730 Creswell, Richard, of Westerton 0
4834499 2306799 2306799 plaintiff Creswell Richard   631730 631730 Creswell, Richard, of Westerton 0
4850347 2311563 2311563 defendant Purser William husbandman 631730 631730 Purser, William, of Westerton, husbandman 0
4878432 2320197 2320197 defendant Purser William husbandman 631730 631730 Purser, William, of Westerton, husbandman 0
4986315 2352832 2352832 defendant Rose Thomas husbandman 631730 631730 Rose, Thomas, of Westerton, husbandman 1
4992072 2354521 2354521 plaintiff Creswellar Richard (legal representative) 631730 631730 Creswellar, Richard, of Westerton, executors of 0
5031995 2366230 2366230 defendant Selwyn John laborer 631730 631730 Selwyn, John, of Westerton, laborer 0
5423409 2481962 2481962 defendant Rose John husbandman 631730 631730 Rose, John, of Westerton, husbandman 4
5442785 2487755 2487755 defendant Rose John husbandman 631730 631730 Rose, John, of Westerton, husbandman 4
5562996 2523772 2523772 defendant Taillour John husbandman 631730 631730 Taillour, John, of Westerton, husbandman 5
5606116 2536804 2536804 plaintiff Tailiour John   631730 631730 Tailiour, John, of Westerton 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);