names

13 rows where place_id = 802139

✎ 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
4785795 2291593 2291593 defendant Colepeper Nicholas esq 802139 802139 Colepeper, Nicholas, of Pepyngbury, esq 2
4861053 2314815 2314815 defendant Gyles John   802139 802139 Gyles, John, of Pepyngbury 2
4874292 2318904 2318904 defendant Sampson William clerk 802139 802139 Sampson, William, of Pepyngbury, clerk 0
4939115 2338619 2338619 defendant Nusse Simon butcher 802139 802139 Nusse, Simon, of Pepyngbury, butcher 0
4964825 2346393 2346393 defendant Burdon Thomas husbandman 802139 802139 Burdon, Thomas, of Pepyngbury, husbandman 0
4991260 2354269 2354269 defendant Aleyn Richard husbandman 802139 802139 Aleyn, Richard, of Pepyngbury, husbandman 0
5095065 2384970 2384970 defendant Benge William husbandman 802139 802139 Benge, William, of Pepyngbury, husbandman 1
5095317 2385050 2385050 defendant Watte William husbandman 802139 802139 Watte, William, of Pepyngbury, husbandman 0
5326674 2453047 2453047 defendant Aleyn Thomas husbandman 802139 802139 Aleyn, Thomas, of Pepyngbury, husbandman 2
5484260 2500218 2500218 defendant Aleyn Thomas yeoman 802139 802139 Aleyn, Thomas, of Pepyngbury, yeoman 3
5484265 2500219 2500219 defendant Aleyn Thomas yeoman 802139 802139 Aleyn, Thomas, of Pepyngbury, yeoman 3
5608760 2537640 2537640 defendant Geld--- Richard shoemaker 802139 802139 Geld---, Richard, of Pepyngbury, shoemaker 0
5609595 2537896 2537896 defendant Aleyn Thomas yeoman 802139 802139 Aleyn, Thomas, of Pepyngbury, yeoman 1

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