names

36 rows where place_id = 754185

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4418393 2170631 2170631 plaintiff West Richard   754185 754185 West, Richard, of Stykeney 0
4493440 2198654 2198654 plaintiff Baret John   754185 754185 Baret, John, of Stykeney 0
4752502 2281192 2281192 defendant Symondes Thomas husbandman 754185 754185 Symondes, Thomas, of Stykeney, husbandman 0
4787911 2292285 2292285 defendant Poryell John husbandman 754185 754185 Poryell, John, of Stykeney, husbandman 5
4788417 2292438 2292438 defendant Theker Lawrence laborer 754185 754185 Theker, Lawrence, of Stykeney, laborer 0
4821913 2302926 2302926 defendant Quadryng Richard   754185 754185 Quadryng, Richard, of Stykeney, franklin 3
4822644 2303159 2303159 defendant Gyrll John (legal representative) 754185 754185 Gyrll, John, of Stykeney, husbandman, executors of 4
4822645 2303159 2303159 defendant Herryson John husbandman 754185 754185 (Herryson, John, of Stykeney, husbandman 5
4834049 2306655 2306655 defendant Beneuncle John husbandman 754185 754185 Beneuncle, John, of Stykeney, husbandman 0
4835514 2307100 2307100 plaintiff Deye Thomas (legal representative) 754185 754185 Deye, Thomas, of Stykeney, executors of 0
4841498 2308871 2308871 defendant Symond Elizabeth   754185 754185 Symond, Elizabeth, of Stykeney, widow, formerly wife of Thomas 1
4879483 2320513 2320513 defendant Symson Albus husbandman 754185 754185 Symson, Albus, of Stykeney, husbandman 0
4915445 2331334 2331334 defendant Symond Thomas husbandman 754185 754185 Symond, Thomas, of Stykeney, husbandman 0
4941474 2339352 2339352 defendant Dyke Thomas husbandman 754185 754185 Dyke, Thomas, of Stykeney, husbandman 0
4958246 2344435 2344435 defendant Thakker Lawrence laborer 754185 754185 Thakker, Lawrence, of Stykeney, laborer 1
4965183 2346513 2346513 defendant Dyker Thomas husbandman 754185 754185 Dyker, Thomas, of Stykeney, husbandman 0
4965184 2346513 2346513 defendant Symson Albon carrier 754185 754185 Symson, Albon, of Stykeney, carrier 1
4973901 2349156 2349156 defendant Symson Albun pulter 754185 754185 Symson, Albun, of Stykeney, pulter 2
4980868 2351211 2351211 defendant Symson Albun pulter 754185 754185 Symson, Albun, of Stykeney, pulter 0
5020824 2362987 2362987 defendant Dyker Thomas yeoman 754185 754185 Dyker, Thomas, of Stykeney, yeoman 0
5025896 2364469 2364469 defendant Barett Richard husbandman 754185 754185 Barett, Richard, of Stykeney, husbandman 2
5060749 2374795 2374795 defendant Walles Richard yeoman 754185 754185 Walles, Richard, of Stykeney, yeoman 0
5083191 2381470 2381470 defendant Poryell Robert husbandman 754185 754185 Poryell, Robert, of Stykeney, husbandman 8
5117996 2391694 2391694 defendant Simond Hugh husbandman 754185 754185 Simond, Hugh, of Stykeney, husbandman 0
5137896 2397594 2397594 defendant Hardy Thomas husbandman 754185 754185 Hardy, Thomas, of Stykeney, husbandman 0
5158600 2403636 2403636 defendant Hardy Thomas husbandman 754185 754185 Hardy, Thomas, of Stykeney, husbandman 0
5194513 2414126 2414126 defendant Hardy Thomas husbandman 754185 754185 Hardy, Thomas, of Stykeney, husbandman 0
5200128 2415791 2415791 defendant Davy William husbandman 754185 754185 Davy, William, of Stykeney, husbandman 0
5227420 2423648 2423648 defendant Fouler Thomas husbandman 754185 754185 Fouler, Thomas, of Stykeney, husbandman 4
5234293 2425617 2425617 defendant Race John husbandman 754185 754185 Race, John, of Stykeney, husbandman 0
5234299 2425619 2425619 defendant Symond Hugh   754185 754185 Symond, Hugh, of Stykeney 0
5245305 2428786 2428786 defendant Ruston Henry chapman 754185 754185 Ruston, Henry, of Stykeney, chapman 0
5264836 2434762 2434762 defendant Dalby Thomas laborer 754185 754185 Dalby, Thomas, of Stykeney, laborer 3
5264846 2434762 2434762 defendant Poryell Robert husbandman 754185 754185 Poryell, Robert, of Stykeney, husbandman 13
5633144 2554369 2554369 plaintiff Symond Thomas   754185 754185 Symond, Thomas, of Stykeney 0
5633147 2554370 2554370 plaintiff Symond Thomas   754185 754185 Symond, Thomas, of Stykeney 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);