names

10 rows where place_id = 627250

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3775085 1949939 1949939 defendant Bull William carpenter 627250 627250 Bull, William, of Wetyng, Norf, carpenter 0
3829869 1967233 1967233 defendant Barbour alias Hukson John laborer 627250 627250 Barbour alias Hukson, John, of Wetyng, Norf, laborer 4
4942906 2339757 2339757 defendant Bate John soldier or husbandman 627250 627250 Bate, John, of Wetyng, Norf, soldier or husbandman 0
5123863 2393436 2393436 defendant Aleyn or Aldyn Thomas husbandman 627250 627250 Aleyn or Aldyn, Thomas, of Wetyng, Norf, husbandman 3
5260376 2433373 2433373 defendant Aleyn Thomas yeoman 627250 627250 (Aleyn, Thomas, of Wetyng, Norf, yeoman 1
5278976 2438962 2438962 defendant Maykot Robert husbandman 627250 627250 (Maykot, Robert, of Wetyng, Norf, husbandman 4
5385447 2470908 2470908 defendant Spilmery Thomas clerk 627250 627250 Spilmery, Thomas, of Wetyng, Norf, clerk 10
5397584 2474375 2474375 defendant Spilmery Thomas clerk 627250 627250 Spilmery, Thomas, of Wetyng, Norf, clerk 10
5490284 2501981 2501981 defendant Kentyng John gent 627250 627250 Kentyng, John, of Wetyng, Norf, gent 0
5529687 2513788 2513788 defendant Wryght Robert husbandman 627250 627250 Wryght, Robert, of Wetyng, Norf, husbandman 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);