names

20 rows where case_id = 2358302

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5004793 2358302 2358302 plaintiff (not given) John abbot of Rameseye   Rameseye, John, abbot, of 0
5004794 2358302 2358302 defendant Redesdale Robert fishmonger 833766 833766 Redesdale, Robert, of Benewyck, Cambs, fishmonger 0
5004795 2358302 2358302 defendant Hyll John husbandman 655085 655085 Hyll, John, of Marche, Cambs, husbandman 1
5004796 2358302 2358302 defendant Feryer John husbandman 791239 791239 Feryer, John, of Marcheford, Cambs, husbandman 2
5004797 2358302 2358302 defendant Carter John shoemaker 761702 761702 Carter, John, of Marcheford, shoemaker 3
5004798 2358302 2358302 defendant Baret William brewer 761702 761702 Baret, William, of Marcheford, brewer 4
5004799 2358302 2358302 defendant Weng Robert yeoman 655085 655085 Weng, Robert, of Marche, Cambs, yeoman 5
5004800 2358302 2358302 defendant Grymston Thomas husbandman 587394 587394 Grymston, Thomas, of Marche, husbandman 6
5004801 2358302 2358302 defendant Southwold John jun, of Marcheford, husbandman   Southwold, John, jun, of Marcheford, husbandman 7
5004802 2358302 2358302 defendant Spencer Lewis husbandman 833763 833763 Spencer, Lewis, of Dodyngton, Cambs, husbandman 8
5004803 2358302 2358302 defendant Colbylede John gent 587394 587394 Colbylede, John, of Marche, gent 9
5004804 2358302 2358302 defendant Neuton Thomas yeoman 761702 761702 Neuton, Thomas, of Marcheford, yeoman 10
5004805 2358302 2358302 defendant Neuton Ivan husbandman 761702 761702 Neuton, Ivan, of Marcheford, husbandman 11
5004806 2358302 2358302 defendant Whitefote William fishmonger 833762 833762 Whitefote, William,of Benewyk, Cambs, fishmonger 12
5004807 2358302 2358302 defendant Doget William husbandman 761702 761702 Doget, William,of Marcheford, husbandman 13
5004808 2358302 2358302 defendant Estmond Robert husbandman 761702 761702 Estmond, Robert, of Marcheford, husbandman 14
5004809 2358302 2358302 defendant Jankynson Thomas husbandman 761702 761702 Jankynson, Thomas, of Marcheford, husbandman 15
5004810 2358302 2358302 defendant Stank William husbandman 761702 761702 Stank, William, of Marcheford, husbandman 16
5004811 2358302 2358302 defendant Mobbe William husbandman 761702 761702 Mobbe, William, of Marcheford, husbandman 17
5004812 2358302 2358302 defendant Snowe John husbandman 587394 587394 Snowe, John, of Marche, husbandman 18

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