names

18 rows where case_id = 2418863

✎ 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
5210677 2418863 2418863 plaintiff Uffenham John     Uffenham, John 0
5210678 2418863 2418863 defendant Reynold Nicholas   592904 592904 Reynold, Nicholas, of Dychampton, bailiff 0
5210679 2418863 2418863 defendant Shetewell John   602891 602891 Shetewell, John, of East Harnam, bailiff 1
5210680 2418863 2418863 defendant Tonprest Edward yeoman 856052 856052 Tonprest, Edward, of Wylton by Salisbury, yeoman 2
5210681 2418863 2418863 defendant Berne Andrew husbandman 859672 859672 Berne, Andrew, of Bulbrygge, by Wylton, husbandman 3
5210682 2418863 2418863 defendant London Thomas chandler 586859 586859 London, Thomas, of Salisbury, chandler 4
5210683 2418863 2418863 defendant Clerk John husbandman 859673 859673 Clerk, John, of Stypul Langford, husbandman 5
5210684 2418863 2418863 defendant Carter Thomas husbandman 591972 591972 Carter, Thomas, of Stapulford, husbandman 6
5210685 2418863 2418863 defendant Coke William carpenter 859674 859674 Coke, William, of Cold Berwyk, carpenter 7
5210686 2418863 2418863 defendant Shyllyng William (legal representative)   Shyllyng, William, executors of 8
5210687 2418863 2418863 defendant Brewe David husbandman 817402 817402 (Brewe, David, of East Dounton, husbandman 9
5210688 2418863 2418863 defendant Whyte William husbandman 817402 817402 Whyte, William, of East Dounton, husbandman 10
5210689 2418863 2418863 defendant Whyte Gillian     Gillian, his wife 11
5210690 2418863 2418863 defendant Lyme Nicholas (legal representative)   Lyme, Nicholas, executors of 12
5210691 2418863 2418863 defendant Lyme John   858174 858174 (Lyme, John, of Combe Bysset, linen weaver 13
5210692 2418863 2418863 defendant God Thomas husbandman 858174 858174 God, Thomas, of Combe Bysset, husbandman 14
5210693 2418863 2418863 defendant Mortymer William husbandman 858174 858174 Mortymer, William, of Combe Bysset, husbandman 15
5210694 2418863 2418863 defendant Mortymer Agnes formerly wife of Nicholas Lyme   Agnes, his wife, formerly wife of Nicholas Lyme 16

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