names

17 rows where place_id = 596447

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624821 1875299 1875299 defendant Curteys Thomas husbandman 596447 596447 Curteys, Thomas, of Waldryngfeld, husbandman 1
3971280 2014511 2014511 defendant Gyrlynge William husbandman 596447 596447 Gyrlynge, William, of Waldryngfeld, husbandman 0
4582578 2225992 2225992 defendant Michell John shipman 596447 596447 Michell, John, of Waldryngfeld, shipman 2
4894973 2325091 2325091 defendant Hert John   596447 596447 Hert, John, of Waldryngfeld, tile maker 0
5066508 2376511 2376511 defendant Hert William   596447 596447 Hert, William, of Waldryngfeld, wright 0
5142543 2398946 2398946 defendant Hert William carpenter 596447 596447 Hert, William, of Waldryngfeld, carpenter 0
5163899 2405177 2405177 defendant Hert William carpenter 596447 596447 Hert, William, of Waldryngfeld, carpenter 0
5177379 2409078 2409078 defendant Hert William carpenter 596447 596447 Hert, William, of Waldryngfeld, carpenter 0
5177381 2409079 2409079 defendant Hert William carpenter 596447 596447 Hert, William, of Waldryngfeld, carpenter 0
5194565 2414140 2414140 defendant Wyles William clerk 596447 596447 Wyles, William, of Waldryngfeld, clerk 1
5200377 2415871 2415871 defendant Hert William carpenter 596447 596447 Hert, William, of Waldryngfeld, carpenter 0
5200379 2415872 2415872 defendant Hert William carpenter 596447 596447 Hert, William, of Waldryngfeld, carpenter 0
5208806 2418301 2418301 defendant Wyles William clerk 596447 596447 Wyles, William, of Waldryngfeld, clerk 1
5216202 2420472 2420472 defendant Hert Robert carpenter 596447 596447 Hert, Robert, of Waldryngfeld, carpenter 0
5499943 2504935 2504935 defendant Beltham John clothmaker 596447 596447 Beltham, John, of Waldryngfeld, clothmaker 0
5525832 2512671 2512671 plaintiff Hert John   596447 596447 Hert, John, of Waldryngfeld 0
5546761 2519055 2519055 defendant Curteys Thomas husbandman 596447 596447 Curteys, Thomas, of Waldryngfeld, husbandman 3

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