names

16 rows where place_id = 600157

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639924 1907301 1907301 defendant Nycols John weaver 600157 600157 Nycols, John, of Cranebrok, weaver 2
3654812 1911764 1911764 defendant Benchekyn John weaver 600157 600157 Benchekyn, John, of Cranebrok, weaver 3
3656943 1912429 1912429 defendant Feyrewey Robert weaver 600157 600157 Feyrewey, Robert, of Cranebrok, weaver 1
3656944 1912429 1912429 defendant Benden John butcher 600157 600157 Benden, John, of Cranebrok, butcher 2
3656945 1912429 1912429 defendant Stede Alexander sheer man 600157 600157 Stede, Alexander, of Cranebrok, sheer man 3
4094099 2058218 2058218 defendant Baker Thomas yeoman 600157 600157 Baker, Thomas, of Cranebrok, yeoman 1
4094100 2058218 2058218 defendant Adams Christopher yeoman 600157 600157 Adams, Christopher, of Cranebrok, yeoman 2
4137137 2073632 2073632 defendant Prettye Francis yeoman 600157 600157 Prettye, Francis, of Cranebrok, yeoman 0
4156704 2080423 2080423 defendant Kelsden Henry clothier 600157 600157 Kelsden, Henry, of Cranebrok, clothier 0
4438420 2181307 2181307 defendant Harcherigge Michael   600157 600157 Harcherigge, Michael, of Cranebrok 3
4571286 2222597 2222597 defendant Cressy John de   600157 600157 Cressy, John de, of Cranebrok 1
4609337 2234020 2234020 defendant Elynden Thomas   600157 600157 Elynden, Thomas, of Cranebrok 0
5058145 2373998 2373998 defendant Godard William husbandman 600157 600157 Godard, William, of Cranebrok, husbandman 2
5236315 2426210 2426210 defendant Ponte Richard butcher 600157 600157 Ponte, Richard, of Cranebrok, butcher 0
5528705 2513495 2513495 defendant Bassek William clothmaker 600157 600157 Bassek, William, of Cranebrok, clothmaker 0
5603663 2536013 2536013 defendant Hix William barber 600157 600157 Hix, William, of Cranebrok, barber 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);