names

18 rows where place_id = 767197

✎ 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
4426237 2173012 2173012 defendant Thirne Ralph de   767197 767197 Thirne, Ralph de, of Neketon, parson 1
4536639 2211738 2211738 defendant Rumy Henry   767197 767197 Rumy, Henry, of Neketon 2
4548749 2215549 2215549 plaintiff Spark John   767197 767197 (Spark, John, of Neketon 1
4548759 2215550 2215550 plaintiff Spark John   767197 767197 (Spark, John, of Neketon 1
4598536 2230778 2230778 plaintiff Spicer John   767197 767197 Spicer, John, of Neketon 0
4634294 2241569 2241569 defendant Fysshere John clerk 767197 767197 Fysshere, John, of Neketon, clerk 0
4659481 2248824 2248824 defendant Soutere John shoemaker 767197 767197 Soutere, John, of Neketon, shoemaker 4
4719301 2271383 2271383 defendant Kyng Thomas   767197 767197 Kyng, Thomas, of Neketon, bailiff 1
4758347 2282983 2282983 defendant Kyng Thomas husbandman 767197 767197 Kyng, Thomas, of Neketon, husbandman 3
4777823 2289055 2289055 defendant Kyng Thome yeoman 767197 767197 Kyng, Thome, of Neketon, yeoman 2
4811161 2299600 2299600 defendant Tweyte Robert yeoman 767197 767197 Tweyte, Robert, of Neketon, yeoman 1
4847448 2310704 2310704 defendant Kyng Thomas husbandman 767197 767197 Kyng, Thomas, of Neketon, husbandman 2
4928748 2335419 2335419 defendant Thweyt Richard laborer 767197 767197 Thweyt, Richard, of Neketon, laborer 0
5092709 2384246 2384246 defendant Goodale John, senior yeoman 767197 767197 Goodale, John, senior, of Neketon, yeoman 0
5095887 2385224 2385224 defendant Chaumbirleyn John   767197 767197 Chaumbirleyn, John, of Neketon, hair maker 4
5100012 2386441 2386441 defendant Lemmer Richard husbandman 767197 767197 Lemmer, Richard, of Neketon, husbandman 0
5211882 2419214 2419214 defendant Skarlet John mercer 767197 767197 Skarlet, John, of Neketon, mercer 1
5632461 2554189 2554189 defendant Merssh Anice or Avice widow 767197 767197 Merssh, Anice or Avice, of Neketon, widow 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);