names

19 rows where case_id = 2483739

✎ 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
5429435 2483739 2483739 plaintiff Grenehyll John     Grenehyll, John 0
5429436 2483739 2483739 defendant Bloodwell Richard clerk 586395 586395 Bloodwell, Richard, of Alderton, clerk 0
5429437 2483739 2483739 defendant Huntbache Thomas husbandman 636775 636775 Huntbache, Thomas, of Tedyngton, Worcs, husbandman 1
5429438 2483739 2483739 defendant Sooyte Thomas husbandman 646705 646705 Sooyte, Thomas, of Dyxton, husbandman 2
5429439 2483739 2483739 defendant Sooyte Robert husbandman 646705 646705 Sooyte, Robert, of Dyxton, husbandman 3
5429440 2483739 2483739 defendant Whytyng John husbandman 646705 646705 Whytyng, John, of Dyxton, husbandman 4
5429441 2483739 2483739 defendant Knyght John husbandman 598218 598218 Knyght, John, of Stanley, husbandman 5
5429442 2483739 2483739 defendant Fyscher John husbandman 586395 586395 Fyscher, John, of Alderton, husbandman 6
5429443 2483739 2483739 defendant Heyn John husbandman 586395 586395 Heyn, John, of Alderton, husbandman 7
5429444 2483739 2483739 defendant Wykys William husbandman 586395 586395 Wykys, William, of Alderton, husbandman 8
5429445 2483739 2483739 defendant Carpenter Robert husbandman 586395 586395 Carpenter, Robert, of Alderton, husbandman 9
5429446 2483739 2483739 defendant Hyggens John husbandman 586395 586395 Hyggens, John, of Alderton, husbandman 10
5429447 2483739 2483739 defendant Taunton John, sen husbandman 586395 586395 Taunton, John, sen, of Alderton, husbandman 11
5429448 2483739 2483739 defendant Tawndon John jun, of Alderton, husbandman   Tawndon, John, jun, of Alderton, husbandman 12
5429449 2483739 2483739 defendant Cryse Thomas   586395 586395 Cryse, Thomas, of Alderton 13
5429450 2483739 2483739 defendant Reve Thomas husbandman 590990 590990 Reve, Thomas, of Newenton, husbandman 14
5429451 2483739 2483739 defendant Mason Thomas husbandman 596691 596691 Mason, Thomas, of Stanley St Leonard, husbandman 15
5429452 2483739 2483739 defendant Creese John husbandman 586395 586395 Creese, John, of Alderton, husbandman 16
5429453 2483739 2483739 defendant Hyggyns William husbandman 586395 586395 Hyggyns, William, of Alderton, husbandman 17

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