names

21 rows where case_id = 2358298

✎ 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
5004762 2358298 2358298 plaintiff (not given) John abbot of Ramesey   Ramesey, John, abbot, of 0
5004763 2358298 2358298 defendant Redesdale Robert fishmonger 833762 833762 Redesdale, Robert, of Benewyk, Cambs, fishmonger 0
5004764 2358298 2358298 defendant Hill John husbandman 655085 655085 Hill, John, of Marche, Cambs, husbandman 1
5004765 2358298 2358298 defendant Feryer John husbandman 791239 791239 Feryer, John, of Marcheford, Cambs, husbandman 2
5004766 2358298 2358298 defendant Carter John husbandman 761702 761702 Carter, John, of Marcheford, husbandman 3
5004767 2358298 2358298 defendant Emnethe Simon shoemaker 761702 761702 Emnethe, Simon, of Marcheford, shoemaker 4
5004768 2358298 2358298 defendant Baret William brewer 761702 761702 Baret, William, of Marcheford, brewer 5
5004769 2358298 2358298 defendant Went Robert yeoman 655085 655085 Went, Robert, of Marche, Cambs, yeoman 6
5004770 2358298 2358298 defendant Grymston Thomas husbandman 587394 587394 Grymston, Thomas, of Marche, husbandman 7
5004771 2358298 2358298 defendant Southwold John jun, of Marcheford, husbandman   Southwold, John,jun, of Marcheford, husbandman 8
5004772 2358298 2358298 defendant Spenser Lewis husbandman 833763 833763 Spenser, Lewis, of Dodyngton, Cambs, husbandman 9
5004773 2358298 2358298 defendant Colvyle John gent 587394 587394 Colvyle, John,of Marche, gent 10
5004774 2358298 2358298 defendant Neuton Thomas yeoman 833764 833764 Neuton, Thomas, of Marchefeld, yeoman 11
5004775 2358298 2358298 defendant Neuton Ivan husbandman 761702 761702 Neuton, Ivan, of Marcheford, husbandman 12
5004776 2358298 2358298 defendant Whitefote William fishmonger 833765 833765 Whitefote, William, of Denewyk, Cambs, fishmonger 13
5004777 2358298 2358298 defendant Doget William of Marcheford husbandman   Doget, William of Marcheford, husbandman 14
5004778 2358298 2358298 defendant Estmond Robert husbandman 761702 761702 Estmond, Robert, of Marcheford, husbandman 15
5004779 2358298 2358298 defendant Jaynkynson thomas husbandman 761702 761702 Jaynkynson, thomas, of Marcheford, husbandman 16
5004780 2358298 2358298 defendant Stank William husbandman 761702 761702 Stank, William, of Marcheford, husbandman 17
5004781 2358298 2358298 defendant Mobbe William husbandman 761702 761702 Mobbe, William, of Marcheford, husbandman 18
5004782 2358298 2358298 defendant Snowe John husbandman 587394 587394 Snowe, John, of Marche, husbandman 19

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