names

17 rows where place_id = 617663

✎ 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
3720637 1932741 1932741 defendant Dowe Robert husbandman 617663 617663 Dowe, Robert, of Sypton, husbandman 0
3938820 2003325 2003325 plaintiff Chapman alias Edmund yeoman 617663 617663 Chapman alias, Edmund, of Sypton, yeoman 1
3962266 2011382 2011382 defendant Sooldyng or Scoldyng John yeoman 617663 617663 Sooldyng or Scoldyng, John, of Sypton, yeoman 0
3962267 2011382 2011382 defendant Hayle William yeoman 617663 617663 Hayle, William, of Sypton, yeoman 1
3962268 2011382 2011382 defendant Bery William yeoman 617663 617663 Bery, William, of Sypton, yeoman 2
3998551 2024221 2024221 defendant Wever George laborer 617663 617663 Wever, George, of Sypton, laborer 0
4061893 2046650 2046650 defendant Shawe Margaret widow 617663 617663 Shawe, Margaret, of Sypton, widow 0
4125434 2069377 2069377 defendant Nutfeld William husbandman 617663 617663 Nutfeld, William, of Sypton, husbandman 0
4127622 2070170 2070170 defendant Atkynson Anne widow 617663 617663 Atkynson, Anne, of Sypton, widow 1
4150949 2078461 2078461 defendant Nutfeild William yeoman 617663 617663 Nutfeild, William, of Sypton, yeoman 3
5036976 2367683 2367683 defendant Kyte Andrew husbandman 617663 617663 Kyte, Andrew, of Sypton, husbandman 0
5215775 2420337 2420337 defendant Padmore John yeoman 617663 617663 Padmore, John, of Sypton, yeoman 0
5281103 2439548 2439548 defendant Seman John yeoman 617663 617663 Seman, John, of Sypton, yeoman 0
5281104 2439548 2439548 defendant Punce William husbandman 617663 617663 Punce, William, of Sypton, husbandman 1
5281108 2439549 2439549 defendant Seman John yeoman 617663 617663 Seman, John, of Sypton, yeoman 0
5281109 2439549 2439549 defendant Punte William husbandman 617663 617663 Punte, William, of Sypton, husbandman 1
5358112 2462602 2462602 plaintiff Palgrave John (legal representative) 617663 617663 Palgrave, John, of Sypton, husbandman, executor of 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);