names

24 rows where place_id = 604096

✎ 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
3656829 1912392 1912392 defendant Stede William gent 604096 604096 Stede, William, of Fransham, gent 0
3656831 1912393 1912393 defendant Stede William gent 604096 604096 Stede, William, of Fransham, gent 0
3923736 1998247 1998247 plaintiff Stede William (legal representative) 604096 604096 Stede, William, of Fransham, administrator of 0
3923739 1998248 1998248 plaintiff Stede William (legal representative) 604096 604096 Stede, William, of Fransham, administrator of 0
4105005 2062063 2062063 defendant Dymmynge Richard husbandman 604096 604096 Dymmynge, Richard, of Fransham, husbandman 0
4105006 2062063 2062063 defendant Hardyng John husbandman 604096 604096 Hardyng, John, of Fransham, husbandman 1
4158876 2081173 2081173 defendant Harwyn John laborer 604096 604096 Harwyn, John, of Fransham, laborer 1
4168563 2084489 2084489 defendant Balye Margaret widow 604096 604096 Balye, Margaret, of Fransham, widow 0
4182274 2089276 2089276 defendant Harwyn John laborer 604096 604096 Harwyn, John, of Fransham, laborer 0
4201414 2096042 2096042 defendant Burston Thomas blacksmith 604096 604096 Burston, Thomas, of Fransham, blacksmith 1
4255146 2114711 2114711 defendant Hickes Adam miller 604096 604096 Hickes, Adam, of Fransham, miller 2
4262397 2117092 2117092 defendant Wood John husbandman 604096 604096 Wood, John, of Fransham, husbandman 1
4325469 2138893 2138893 defendant Mynne Henry gent 604096 604096 Mynne, Henry, of Fransham, gent 0
4336286 2142424 2142424 defendant Mynn Nicholas gent 604096 604096 Mynn, Nicholas, of Fransham, gent 0
4403754 2165828 2165828 defendant Nalson Robert tailor 604096 604096 Nalson, Robert, of Fransham, tailor 2
4458747 2187782 2187782 defendant Beston John   604096 604096 Beston, John, of Fransham 0
4458749 2187783 2187783 defendant Vynche Simon   604096 604096 Vynche, Simon, of Fransham, parson 0
4459097 2187889 2187889 defendant Beston John de   604096 604096 Beston, John de, of Fransham 0
4459272 2187946 2187946 defendant Vynche Simon   604096 604096 Vynche, Simon, of Fransham, parson 0
4502117 2201257 2201257 defendant Womar-- alias Wryghte Richard   604096 604096 Womar-- alias Wryghte, Richard, of Fransham 4
4640421 2243311 2243311 defendant Brakke Thomas   604096 604096 Brakke, Thomas, of Fransham 7
4659092 2248713 2248713 defendant Sewode Nicholas yeoman 604096 604096 Sewode, Nicholas, of Fransham, yeoman 0
4713463 2269534 2269534 defendant Colyn Adam yeoman 604096 604096 Colyn, Adam, of Fransham, yeoman 0
5192585 2413564 2413564 plaintiff Curde John   604096 604096 Curde, John, of Fransham 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);