names

16 rows where case_id = 2331453

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4915836 2331453 2331453 plaintiff Dursfeld Richard     Dursfeld, Richard 0
4915837 2331453 2331453 defendant Curtays John husbandman 758428 758428 Curtays, John, of Walde Neuton, husbandman 0
4915838 2331453 2331453 defendant John of Benyngworth parson   John, of Benyngworth, parson 1
4915839 2331453 2331453 defendant Tomson Willam shipman 762374 762374 Tomson, Willam, of Saltflet Haven, shipman 2
4915840 2331453 2331453 defendant Mouper John cooper 821487 821487 Mouper, John, of Glammford Bridge, cooper 3
4915841 2331453 2331453 defendant Rede John husbandman 593113 593113 Rede, John, of Grymesby, husbandman 4
4915842 2331453 2331453 defendant Skendelby John butcher 593113 593113 Skendelby, John, of Grymesby, butcher 5
4915843 2331453 2331453 defendant Ive Willam chapman 593113 593113 Ive, Willam, of Grymesby, chapman 6
4915844 2331453 2331453 defendant Markham William chapman 593113 593113 Markham, William, of Grymesby, chapman 7
4915845 2331453 2331453 defendant Shirref John   590061 590061 Shirref, John, of Barton 8
4915846 2331453 2331453 defendant Roberdson John husbandman 608095 608095 Roberdson, John, of Trusthorp, husbandman 9
4915847 2331453 2331453 defendant Kelsay Peter husbandman 770847 770847 Kelsay, Peter, of Thorp by Waynflete, husbandman 10
4915848 2331453 2331453 defendant Lister Robert husbandman 594154 594154 Lister, Robert, of Laghton, husbandman 11
4915849 2331453 2331453 defendant Devenshire John (legal representative)   Devenshire, John, executors of 12
4915850 2331453 2331453 defendant Swan John husbandman 821488 821488 (Swan, John, of Rexby, husbandman 13
4915851 2331453 2331453 defendant his wife formerly wife of Testator   his wife, formerly wife of Testator 14

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