names

22 rows where place_id = 767543

✎ 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
4540552 2212944 2212944 plaintiff West John   767543 767543 West, John, of Newecherche 0
4540554 2212945 2212945 plaintiff West John   767543 767543 West, John, of Newecherche 0
4566754 2221174 2221174 defendant Thomelyn Richard   767543 767543 Thomelyn, Richard, of Newecherche 2
4566760 2221174 2221174 defendant Elys Robert   767543 767543 Elys, Robert, of Newecherche 8
4577363 2224434 2224434 defendant Adam Thomas   767543 767543 Adam, Thomas, of Newecherche 1
4577365 2224435 2224435 defendant Spone John   767543 767543 Spone, John, of Newecherche 0
4587279 2227428 2227428 plaintiff Hughe John   767543 767543 Hughe, John, of Newecherche 0
4656829 2248031 2248031 defendant Poltone John, senior laborer 767543 767543 Poltone, John, senior, of Newecherche, laborer 4
4656830 2248031 2248031 defendant Polton John, junior laborer 767543 767543 Polton, John, junior, of Newecherche, laborer 5
4721164 2271954 2271954 defendant Knoldene John (legal representative) 767543 767543 Knoldene, John, of Newecherche, executors of 0
4721165 2271954 2271954 defendant Northene John husbandman 767543 767543 (Northene, John, of Newecherche, husbandman 1
4730791 2274832 2274832 defendant Thomelyn Walter yeoman 767543 767543 Thomelyn, Walter, of Newecherche, yeoman 0
4752732 2281256 2281256 plaintiff Tomelyn John, senior   767543 767543 Tomelyn, John, senior, of Newecherche, on his own account 0
4757167 2282609 2282609 defendant Holde Stephen laborer 767543 767543 Holde, Stephen, of Newecherche, laborer 2
4757171 2282610 2282610 defendant Holde Stephen laborer 767543 767543 Holde, Stephen, of Newecherche, laborer 2
4766666 2285565 2285565 defendant Tracy Richard laborer 767543 767543 Tracy, Richard, of Newecherche, laborer 2
4779174 2289461 2289461 defendant Holde Stephen laborer 767543 767543 Holde, Stephen, of Newecherche, laborer 2
4799303 2295957 2295957 defendant Poltowene John laborer 767543 767543 Poltowene, John, of Newecherche, laborer 0
4863556 2315571 2315571 defendant Stokker John laborer 767543 767543 Stokker, John, of Newecherche, laborer 0
4871506 2318055 2318055 defendant Burgheld John husbandman 767543 767543 Burgheld, John, of Newecherche, husbandman 0
5023014 2363639 2363639 defendant Stokpeny Robert husbandman 767543 767543 Stokpeny, Robert, of Newecherche, husbandman 1
5312273 2448707 2448707 defendant Cobbe William gent 767543 767543 together with Cobbe, William, of Newecherche, gent 2

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