names

18 rows where place_id = 593391

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611619 1871303 1871303 defendant Foxe John wheeler 593391 593391 Foxe, John, of Pytmyster, wheeler 0
3612342 1871493 1871493 defendant Roke Thomas yeoman 593391 593391 Roke, Thomas, of Pytmyster, yeoman 1
3612343 1871493 1871493 defendant Hernowe Walter yeoman 593391 593391 Hernowe, Walter, of Pytmyster, yeoman 2
3612344 1871493 1871493 defendant Lambert Robert yeoman 593391 593391 Lambert, Robert, of Pytmyster, yeoman 3
3612345 1871493 1871493 defendant Colbrond William yeoman 593391 593391 Colbrond, William, of Pytmyster, yeoman 4
3671086 1916924 1916924 defendant Jonys William carver 593391 593391 Jonys, William, of Pytmyster, carver 4
3963324 2011772 2011772 defendant Hyllynge Robert husbandman 593391 593391 Hyllynge, Robert, of Pytmyster, husbandman 0
4006104 2026954 2026954 defendant Gyll John victualer 593391 593391 Gyll, John, of Pytmyster, victualer 0
4010033 2028355 2028355 defendant Willes William yeoman 593391 593391 Willes, William, of Pytmyster, yeoman 0
4173933 2086340 2086340 defendant Wylles John   593391 593391 Wylles, John, of Pytmyster 0
5069547 2377389 2377389 defendant Salter Henry husbandman 593391 593391 Salter, Henry, of Pytmyster, husbandman 2
5085701 2382215 2382215 defendant Godard Thomas butcher 593391 593391 Godard, Thomas, of Pytmyster, butcher 2
5286064 2440933 2440933 defendant Danyell John husbandman 593391 593391 Danyell, John, of Pytmyster, husbandman 0
5424764 2482365 2482365 defendant Dyer Thomas clerk 593391 593391 Dyer, Thomas, of Pytmyster, clerk 0
5424768 2482366 2482366 defendant Dyer Thomas clerk 593391 593391 Dyer, Thomas, of Pytmyster, clerk 0
5443470 2487957 2487957 defendant Dyer Thomas   593391 593391 Dyer, Thomas, of Pytmyster 0
5443471 2487957 2487957 defendant Clenmowe Thomas clerk 593391 593391 Clenmowe, Thomas, of Pytmyster, clerk 1
5478000 2498443 2498443 defendant Cutboll Richard yeoman 593391 593391 Cutboll, Richard, of Pytmyster, 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);