names

19 rows where place_id = 588715

✎ 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
3595359 1866180 1866180 defendant Peny or Pevy William husbandman 588715 588715 Peny or Pevy, William, of Holyngborn, husbandman 2
5001552 2357348 2357348 defendant Eytherst William laborer 588715 588715 Eytherst, William, of Holyngborn, laborer 0
5060218 2374626 2374626 defendant Isoude Robert husbandman 588715 588715 Isoude, Robert, of Holyngborn, husbandman 3
5107985 2388776 2388776 defendant Casnell John butcer 588715 588715 Casnell, John, of Holyngborn, butcer 3
5107987 2388777 2388777 defendant Geryng William husbandman 588715 588715 Geryng, William, of Holyngborn, husbandman 0
5130363 2395369 2395369 defendant Goryng William husbandman 588715 588715 Goryng, William, of Holyngborn, husbandman 2
5136046 2397054 2397054 defendant atte Wode Thomas carpenter 588715 588715 atte Wode, Thomas, of Holyngborn, carpenter 0
5149720 2401050 2401050 defendant Geryng William husbandman 588715 588715 Geryng, William, of Holyngborn, husbandman 2
5155938 2402896 2402896 defendant atte Wode Thomas carpenter 588715 588715 atte Wode, Thomas, of Holyngborn, carpenter 0
5155944 2402897 2402897 defendant atte Wode Thomas carpenter 588715 588715 atte Wode, Thomas, of Holyngborn, carpenter 0
5255495 2431839 2431839 defendant Pytot John yeoman 588715 588715 Pytot, John, of Holyngborn, yeoman 0
5292917 2442919 2442919 defendant Geryng William husbandman 588715 588715 Geryng, William, of Holyngborn, husbandman 2
5315006 2449541 2449541 defendant Bedmanton Thomas, senior husbandman 588715 588715 Bedmanton, Thomas, senior, of Holyngborn, husbandman 0
5359167 2462905 2462905 defendant atte Wode Thomas husbandman 588715 588715 atte Wode, Thomas, of Holyngborn, husbandman 1
5360233 2463240 2463240 defendant Pygot John husbandman 588715 588715 Pygot, John, of Holyngborn, husbandman 3
5405636 2476686 2476686 defendant Ayot John husbandman 588715 588715 Ayot, John, of Holyngborn, husbandman 0
5474554 2497365 2497365 defendant Dygon William husbandman 588715 588715 Dygon, William, of Holyngborn, husbandman 0
5479451 2498871 2498871 defendant Peny William husbandman 588715 588715 Peny, William, of Holyngborn, husbandman 1
5572841 2526607 2526607 defendant Hyghsted Thomas   588715 588715 Hyghsted, Thomas, of Holyngborn, horse collar maker 4

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