names

17 rows where place_id = 597355

✎ 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
3628242 1903691 1903691 defendant Keye John weaver 597355 597355 Keye, John, of Castlacre, weaver 0
3628309 1903716 1903716 defendant Foster Richard   597355 597355 Foster, Richard, of Castlacre, collar maker 0
3628310 1903716 1903716 defendant Fyllyp Robert husbandman 597355 597355 Fyllyp, Robert, of Castlacre, husbandman 1
3628314 1903717 1903717 defendant Fyllyp Robert husbandman 597355 597355 Fyllyp, Robert, of Castlacre, husbandman 2
3633791 1905383 1905383 defendant Marche Thomas husbandman 597355 597355 Marche, Thomas, of Castlacre, husbandman 1
3670304 1916662 1916662 defendant Holle John yeoman 597355 597355 Holle, John, of Castlacre, yeoman 1
3680704 1920046 1920046 defendant Blisse John clerk 597355 597355 Blisse, John, of Castlacre, clerk 0
3747671 1941192 1941192 defendant Lakford John butcher 597355 597355 Lakford, John, of Castlacre, butcher 0
3750546 1942087 1942087 defendant Lakford John butcher 597355 597355 Lakford, John, of Castlacre, butcher 0
3776160 1950287 1950287 defendant Lakford John butcher 597355 597355 Lakford, John, of Castlacre, butcher 0
3776217 1950308 1950308 plaintiff Brown John (legal representative) 597355 597355 Brown, John, of Castlacre, weaver, executors of 0
3781814 1952057 1952057 defendant Pykerd William husbandman 597355 597355 Pykerd, William, of Castlacre, husbandman 2
3784191 1952841 1952841 defendant Scottyng William baker 597355 597355 Scottyng, William, of Castlacre, baker 1
3784192 1952841 1952841 defendant Scottyng John baker 597355 597355 Scottyng, John, of Castlacre, baker 2
3786390 1953530 1953530 defendant Clement Thomas tailor 597355 597355 Clement, Thomas, of Castlacre, tailor 0
3913281 1994773 1994773 plaintiff Bathecome John   597355 597355 Bathecome, John, of Castlacre 0
3913282 1994773 1994773 defendant Mason Robert baker 597355 597355 Mason, Robert, of Castlacre, baker 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);