names

39 rows where place_id = 590508

✎ 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
3589213 1864270 1864270 plaintiff Broun Robert (legal representative) 590508 590508 Broun, Robert, of Thweyt, executors of 0
3601419 1868103 1868103 defendant Reve alias Wright Edward yeoman 590508 590508 Reve alias Wright, Edward, of Thweyt, yeoman 0
3602511 1868444 1868444 defendant Reve alias Wright Edward yeoman 590508 590508 Reve alias Wright, Edward, of Thweyt, yeoman 0
3770540 1948468 1948468 defendant Lynde Thomas husbandman 590508 590508 Lynde, Thomas, of Thweyt, husbandman 3
3870322 1980325 1980325 plaintiff Wulcy John smith 590508 590508 Wulcy, John, of Thweyt, smith 1
3870323 1980325 1980325 defendant Thomson Thomas husbandman 590508 590508 Thomson, Thomas, of Thweyt, husbandman 0
4595679 2229910 2229910 defendant Purre Roger   590508 590508 Purre, Roger, of Thweyt 2
4615940 2235982 2235982 defendant Quyntyn Stephen   590508 590508 Quyntyn, Stephen, of Thweyt 1
4627149 2239440 2239440 defendant Qwyntyn Stephen   590508 590508 Qwyntyn, Stephen, of Thweyt 4
4685469 2261052 2261052 plaintiff Rycherys John (legal representative) 590508 590508 Rycherys, John, of Thweyt, executors of 0
4685474 2261053 2261053 plaintiff Rycherys John (legal representative) 590508 590508 Rycherys, John, of Thweyt, executors of 0
4742215 2278213 2278213 defendant Whyte Robert   590508 590508 Whyte, Robert, of Thweyt, parson 2
4822579 2303138 2303138 defendant Qwyntyn Stephen yeoman 590508 590508 Qwyntyn, Stephen, of Thweyt, yeoman 0
4855126 2312953 2312953 defendant Qwyntyn Stephen yeoman 590508 590508 Qwyntyn, Stephen, of Thweyt, yeoman 0
4888459 2323188 2323188 defendant Wulmere John yeoman 590508 590508 Wulmere, John, of Thweyt, yeoman 4
4894966 2325088 2325088 defendant Quynton Stephen husbandman 590508 590508 Quynton, Stephen, of Thweyt, husbandman 0
4911697 2330159 2330159 defendant Sherman William   590508 590508 Sherman, William, of Thweyt, parson 2
4918570 2332324 2332324 defendant Ovynntyn Stephen yeoman 590508 590508 Ovynntyn, Stephen, of Thweyt, yeoman 0
4944243 2340171 2340171 defendant Quyntyn Stephen yeoman 590508 590508 Quyntyn, Stephen, of Thweyt, yeoman 0
4961245 2345329 2345329 defendant Childerhous John   590508 590508 Childerhous, John, of Thweyt, wright 2
4969997 2347977 2347977 defendant Quyntyn Stephen yeoman 590508 590508 Quyntyn, Stephen, of Thweyt, yeoman 0
4983353 2351927 2351927 defendant Herman Walter yeoman 590508 590508 (Herman, Walter, of Thweyt, yeoman 3
5053369 2372611 2372611 defendant Quyntyn Stephen yeoman 590508 590508 Quyntyn, Stephen, of Thweyt, yeoman 0
5053370 2372611 2372611 defendant Quyntyn Roger yeoman 590508 590508 Quyntyn, Roger, of Thweyt, yeoman 1
5137945 2397610 2397610 defendant Skynner John, senior weaver 590508 590508 Skynner, John, senior, of Thweyt, weaver 0
5137947 2397610 2397610 defendant Pope John husbandman 590508 590508 Pope, John, of Thweyt, husbandman 2
5157836 2403418 2403418 defendant Turnour Richard turner 590508 590508 Turnour, Richard, of Thweyt, turner 1
5173600 2407980 2407980 defendant Turnour Richard turner 590508 590508 Turnour, Richard, of Thweyt, turner 1
5269242 2436110 2436110 defendant Hastyng William husbandman 590508 590508 Hastyng, William, of Thweyt, husbandman 0
5269244 2436111 2436111 defendant Quyntyn Roger yeoman 590508 590508 Quyntyn, Roger, of Thweyt, yeoman 0
5278754 2438894 2438894 defendant Hastyng William husbandman 590508 590508 Hastyng, William, of Thweyt, husbandman 0
5359268 2462935 2462935 defendant Cosset alias Turnour Richard husbandman 590508 590508 Cosset alias Turnour, Richard, of Thweyt, husbandman 0
5359271 2462936 2462936 defendant Qwyntyne Roger husbandman 590508 590508 Qwyntyne, Roger, of Thweyt, husbandman 0
5359281 2462939 2462939 defendant Bace Robert husbandman 590508 590508 Bace, Robert, of Thweyt, husbandman 0
5359282 2462939 2462939 defendant Brastret Thomas husbandman 590508 590508 Brastret, Thomas, of Thweyt, husbandman 1
5385480 2470917 2470917 defendant Hastynges William husbandman 590508 590508 Hastynges, William, of Thweyt, husbandman 2
5410722 2478152 2478152 defendant Hastynges William husbandman 590508 590508 Hastynges, William, of Thweyt, husbandman 2
5424790 2482373 2482373 defendant Hastynges William husbandman 590508 590508 Hastynges, William, of Thweyt, husbandman 0
5623960 2551440 2551440 defendant Shopman Stephen mercer 590508 590508 Shopman, Stephen, of Thweyt, mercer 1

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