names

31 rows where place_id = 686373

✎ 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
4066505 2048312 2048312 plaintiff Hooper William yeoman 686373 686373 Hooper, William, of Warminster, Wilts, yeoman 0
4122752 2068429 2068429 defendant Alford William gent 686373 686373 Alford, William, of Warminster, Wilts, gent 0
4179296 2088235 2088235 defendant Chamberlayn John yeoman 686373 686373 Chamberlayn, John, of Warminster, Wilts, yeoman 1
4203736 2096863 2096863 defendant Townsende John baker 686373 686373 Townsende, John, of Warminster, Wilts, baker 0
4210805 2099337 2099337 defendant Wardar John chapman 686373 686373 Wardar, John, of Warminster, Wilts, chapman 0
4292136 2127258 2127258 defendant Jourdon Thomas merchant 686373 686373 Jourdon, Thomas, of Warminster, Wilts, merchant 0
4323542 2138292 2138292 defendant Olden Robert yeoman 686373 686373 Olden, Robert, of Warminster, Wilts, yeoman 2
4710324 2268585 2268585 defendant Mohun William gent 686373 686373 Mohun, William, of Warminster, Wilts, gent 0
4739110 2277322 2277322 defendant Kedwelly Edmund husbandman 686373 686373 Kedwelly, Edmund, of Warminster, Wilts, husbandman 2
4759455 2283298 2283298 defendant Kedwelly Edmund husbandman 686373 686373 Kedwelly, Edmund, of Warminster, Wilts, husbandman 3
4760238 2283555 2283555 defendant Cardemaker William   686373 686373 Cardemaker, William, of Warminster, Wilts, card maker 0
4911776 2330184 2330184 defendant Atheler John shoemaker 686373 686373 Atheler, John, of Warminster, Wilts, shoemaker 0
4919534 2332612 2332612 defendant Sore John cooper 686373 686373 Sore, John, of Warminster, Wilts, cooper 0
4921001 2333081 2333081 defendant Skyte John chapman 686373 686373 Skyte, John, of Warminster, Wilts, chapman 0
4921244 2333159 2333159 defendant Skyte John chapman 686373 686373 Skyte, John, of Warminster, Wilts, chapman 0
4922361 2333404 2333404 defendant Blanchard Thomas gent 686373 686373 Blanchard, Thomas, of Warminster, Wilts, gent 0
5003583 2357940 2357940 defendant Brent Nicholas   686373 686373 Brent, Nicholas, of Warminster, Wilts, cloth maker 1
5003589 2357941 2357941 defendant Brent Nicholas   686373 686373 Brent, Nicholas, of Warminster, Wilts, cloth maker 1
5039684 2368512 2368512 defendant Tysbury John clothier 686373 686373 Tysbury, John, of Warminster, Wilts, clothier 1
5039688 2368513 2368513 defendant Tysbury John clothier 686373 686373 Tysbury, John, of Warminster, Wilts, clothier 1
5175731 2408585 2408585 defendant Bray Robert yeoman 686373 686373 Bray, Robert, of Warminster, Wilts, yeoman 0
5197204 2414921 2414921 defendant Bray Robert yeoman 686373 686373 Bray, Robert, of Warminster, Wilts, yeoman 0
5197207 2414922 2414922 defendant Bray Robert yeoman 686373 686373 Bray, Robert, of Warminster, Wilts, yeoman 0
5209966 2418647 2418647 defendant Bray Robert yeoman 686373 686373 Bray, Robert, of Warminster, Wilts, yeoman 0
5306076 2446804 2446804 defendant Bekyngham Richard dyer 686373 686373 Bekyngham, Richard, of Warminster, Wilts, dyer 1
5415239 2479499 2479499 defendant Brent William gent 686373 686373 Brent, William, of Warminster, Wilts, gent 3
5415264 2479503 2479503 defendant (illegible) William gent 686373 686373 _, William, of Warminster, Wilts, gent 3
5429837 2483866 2483866 defendant Bray Robert mercer 686373 686373 Bray, Robert, of Warminster, Wilts, mercer 1
5472039 2496595 2496595 defendant Bray Robert mercer 686373 686373 Bray, Robert, of Warminster, Wilts, mercer 1
5472553 2496758 2496758 defendant Bekyngham Richard chapman 686373 686373 Bekyngham, Richard, of Warminster, Wilts, chapman 2
5609057 2537738 2537738 defendant Brent William gent 686373 686373 Brent, William, of Warminster, Wilts, gent 2

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