names

20 rows where place_id = 801351

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4779732 2289653 2289653 defendant Heker John maltman 801351 801351 Heker, John, of Mersshefeld, Glos, maltman 0
4780092 2289777 2289777 defendant Halle Richard maltman 801351 801351 Halle, Richard, of Mersshefeld, Glos, maltman 0
4793969 2294242 2294242 defendant London William husbandman 801351 801351 London, William, of Mersshefeld, Glos, husbandman 3
4801130 2296541 2296541 defendant Laurence Thomas   801351 801351 Laurence, Thomas, of Mersshefeld, Glos, gent, receiver general for William Bourghier, knight and Anne, Countess of Stafford, his consort 0
4801182 2296551 2296551 defendant Laurence Thomas   801351 801351 Laurence, Thomas, of Mersshefeld, Glos, gent, receiver general for William Bourgchier, knight, and Anne Countess of Stafford 0
4945533 2340581 2340581 defendant Gryce Edward chapman 801351 801351 Gryce, Edward, of Mersshefeld, Glos, chapman 1
5017171 2361920 2361920 defendant Corveser Alexander cordwainer 801351 801351 Corveser, Alexander, of Mersshefeld, Glos, cordwainer 0
5017222 2361923 2361923 defendant Bisshop John maltman 801351 801351 Bisshop, John, of Mersshefeld, Glos, maltman 10
5056544 2373538 2373538 defendant Corveser Alexander cordwainer 801351 801351 Corveser, Alexander, of Mersshefeld, Glos, cordwainer 0
5056578 2373540 2373540 defendant Bysshop John maltman 801351 801351 Bysshop, John, of Mersshefeld, Glos, maltman 8
5063005 2375468 2375468 defendant Bole William gent 801351 801351 Bole, William, of Mersshefeld, Glos, gent 0
5063008 2375469 2375469 defendant Bole William gent 801351 801351 Bole, William, of Mersshefeld, Glos, gent 1
5074708 2378940 2378940 defendant Hopkyns John husbandman 801351 801351 Hopkyns, John, of Mersshefeld, Glos, husbandman 2
5079737 2380425 2380425 defendant Corveser Alexander cordwainer 801351 801351 Corveser, Alexander, of Mersshefeld, Glos, cordwainer 0
5096499 2385407 2385407 defendant Dollyng John husbandman 801351 801351 Dollyng, John, of Mersshefeld, Glos, husbandman 2
5123270 2393243 2393243 defendant Bole William gent 801351 801351 Bole, William, of Mersshefeld, Glos, gent 1
5228143 2423838 2423838 defendant Bole William clerk 801351 801351 Bole, William, of Mersshefeld, Glos, clerk 1
5251751 2430655 2430655 defendant Wyvell Robert maltman 801351 801351 Wyvell, Robert, of Mersshefeld, Glos, maltman 0
5280519 2439379 2439379 defendant Sprynghole Thomas yeoman 801351 801351 together with Sprynghole, Thomas, of Mersshefeld, Glos, yeoman 3
5549136 2519790 2519790 defendant Pryde John husbandman 801351 801351 Pryde, John, of Mersshefeld, Glos, husbandman 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);