names

25 rows where place_id = 620834

✎ 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
3737963 1938090 1938090 defendant Bulwer Roger yeoman 620834 620834 Bulwer, Roger, of Dallyng, yeoman 2
3737974 1938092 1938092 defendant Bulwar Roger yeoman 620834 620834 Bulwar, Roger, of Dallyng, yeoman 2
4015060 2030076 2030076 defendant Bulward Roger gent 620834 620834 Bulward, Roger, of Dallyng, gent 11
4427882 2173560 2173560 defendant Brunham John de   620834 620834 Brunham, John de, of Dallyng, parson 0
4616628 2236203 2236203 defendant Jagge John   620834 620834 Jagge, John, of Dallyng 3
4622244 2237939 2237939 plaintiff Look Richard   620834 620834 Look, Richard, of Dallyng 0
4650816 2246258 2246258 plaintiff Wynter John   620834 620834 Wynter, John, of Dallyng 0
4659715 2248889 2248889 defendant Franken William yeoman 620834 620834 Franken, William, of Dallyng, yeoman 2
4674058 2257497 2257497 plaintiff Dockyng Robert   620834 620834 Dockyng, Robert, of Dallyng, on his own account 0
4676848 2258378 2258378 defendant Selche Thomas yeoman 620834 620834 Selche, Thomas, of Dallyng, yeoman 0
4676925 2258400 2258400 defendant Jagge John yeoman 620834 620834 Jagge, John, of Dallyng, yeoman 0
4682697 2260203 2260203 defendant Jagge John yeoman 620834 620834 Jagge, John, of Dallyng, yeoman 0
4717934 2270948 2270948 defendant Wodcroft Richard   620834 620834 Wodcroft, Richard, of Dallyng, bailiff 0
4724911 2273083 2273083 defendant Wodecro_ Richard   620834 620834 Wodecro_, Richard, of Dallyng, bailiff 1
4726256 2273498 2273498 defendant Waryn Gilbert yeoman 620834 620834 Waryn, Gilbert, of Dallyng, yeoman 0
4726296 2273508 2273508 defendant Woderost Richard yeoman 620834 620834 Woderost, Richard, of Dallyng, yeoman 0
4768562 2286147 2286147 defendant Ayleward Simon husbandman 620834 620834 Ayleward, Simon, of Dallyng, husbandman 0
4768563 2286147 2286147 defendant Ayleward Thomas laborer 620834 620834 Ayleward, Thomas, of Dallyng, laborer 1
4888387 2323167 2323167 defendant Massenger John   620834 620834 Massenger, John, of Dallyng 2
4897909 2326003 2326003 defendant Massenger John   620834 620834 Massenger, John, of Dallyng 2
4949622 2341878 2341878 defendant Sadde Clement husbandman 620834 620834 Sadde, Clement, of Dallyng, husbandman 1
5391598 2472665 2472665 defendant Bulwar Simon butcher 620834 620834 Bulwar, Simon, of Dallyng, butcher 10
5404618 2476394 2476394 defendant Bulwar Simon butcher 620834 620834 Bulwar, Simon, of Dallyng, butcher 10
5491207 2502266 2502266 defendant Wodecrofte Thomas husbandman 620834 620834 Wodecrofte, Thomas, of Dallyng, husbandman 2
5537553 2516235 2516235 plaintiff Crane John   620834 620834 Crane, John, of Dallyng 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);