names

31 rows where place_id = 759535

✎ 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
4462262 2188896 2188896 plaintiff Swynford William de (legal representative) 759535 759535 Swynford, William de, of Neubold, executors of 0
4462263 2188896 2188896 plaintiff Swynford Alice de sister of William 759535 759535 (Swynford, Alice de, of Neubold, sister of William 1
4462270 2188897 2188897 plaintiff Swynford William de (legal representative) 759535 759535 Swynford, William de, of Neubold, executors of 0
4522797 2207467 2207467 defendant Lawe Adam carpenter 759535 759535 Lawe, Adam, of Neubold, carpenter 0
4526276 2208505 2208505 plaintiff Knyfsmyth Robert   759535 759535 Knyfsmyth, Robert, of Neubold 0
4526277 2208505 2208505 defendant Perkynson John   759535 759535 Perkynson, John, of Neubold 0
4526278 2208506 2208506 plaintiff Knyfsmyth Robert   759535 759535 Knyfsmyth, Robert, of Neubold 0
4526279 2208506 2208506 plaintiff Date William   759535 759535 Date, William, of Neubold 1
4526280 2208506 2208506 defendant Sobynson Peter   759535 759535 Sobynson, Peter, of Neubold 0
4534950 2211210 2211210 defendant Wetson John   759535 759535 Wetson, John, of Neubold 0
4570824 2222444 2222444 plaintiff Wylye Richard (legal representative) 759535 759535 Wylye, Richard, of Neubold, formerly vicar, executors of 0
4570825 2222444 2222444 plaintiff Tofte Richard   759535 759535 (Tofte, Richard, of Neubold, vicar 1
4661227 2249334 2249334 defendant Bromhale William yeoman 759535 759535 Bromhale, William, of Neubold, yeoman 0
4742474 2278299 2278299 plaintiff Cateby John   759535 759535 Cateby, John, of Neubold, on his own account 0
4795677 2294801 2294801 defendant Smyth Richard husbandman 759535 759535 Smyth, Richard, of Neubold, husbandman 1
4912581 2330436 2330436 defendant Perkyns John husbandman & son of Thomas Perkyns 759535 759535 Perkyns, John, of Neubold, husbandman & son of Thomas Perkyns 0
4973914 2349161 2349161 defendant Hogges John husbandman 759535 759535 Hogges, John, of Neubold, husbandman 0
4973915 2349161 2349161 defendant Parkyns John husbandman 759535 759535 Parkyns, John, of Neubold, husbandman 1
5317814 2450416 2450416 defendant Fox Nicholas (legal representative) 759535 759535 Fox, Nicholas, of Neubold, scythe smith, executors of 0
5369358 2466017 2466017 defendant Stubbyng Edmund husbandman 759535 759535 Stubbyng, Edmund, of Neubold, husbandman 5
5369369 2466018 2466018 defendant Stubbyng Giles husbandman 759535 759535 Stubbyng, Giles, of Neubold, husbandman 5
5428310 2483393 2483393 defendant Neubold William husbandman 759535 759535 Neubold, William, of Neubold, husbandman 2
5428311 2483393 2483393 defendant Neubold John husbandman 759535 759535 Neubold, John, of Neubold, husbandman 3
5445697 2488601 2488601 defendant Neubold William husbandman 759535 759535 Neubold, William, of Neubold, husbandman 2
5445698 2488601 2488601 defendant Neubold John husbandman 759535 759535 Neubold, John, of Neubold, husbandman 3
5458450 2492420 2492420 defendant Neubold William husbandman 759535 759535 Neubold, William, of Neubold, husbandman 2
5458451 2492420 2492420 defendant Neubold John husbandman 759535 759535 Neubold, John, of Neubold, husbandman 3
5458456 2492421 2492421 defendant Neubold William husbandman 759535 759535 Neubold, William, of Neubold, husbandman 1
5458457 2492421 2492421 defendant Neubold John husbandman 759535 759535 Neubold, John, of Neubold, husbandman 2
5481499 2499396 2499396 defendant Neubold William husbandman 759535 759535 Neubold, William, of Neubold, husbandman 1
5481500 2499396 2499396 defendant Neubold John husbandman 759535 759535 Neubold, John, of Neubold, husbandman 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);