names

18 rows where case_id = 2386973

✎ 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
5101875 2386973 2386973 plaintiff Basset Robert     Basset, Robert 0
5101876 2386973 2386973 plaintiff Ouldpen John     Ouldpen, John 1
5101877 2386973 2386973 plaintiff Gryme William chaplain   Gryme, William, chaplain 2
5101878 2386973 2386973 defendant Stevenys Agnes widow 794901 794901 Stevenys, Agnes, of Chepyng Campeden, widow 0
5101879 2386973 2386973 defendant Stevenys John   846540 846540 Stevenys, John, of Chepyng Campeden, scholar 1
5101880 2386973 2386973 defendant Warner William   846541 846541 Warner, William, of Brode Capeden, franklin 2
5101881 2386973 2386973 defendant Haselford William husbandman 846542 846542 Haselford, William, of Hydecoteboys, husbandman 3
5101882 2386973 2386973 defendant Bailly William husbandman 794901 794901 Bailly, William,of Chepyng Campeden, husbandman 4
5101883 2386973 2386973 defendant Gybbys William yeoman 731503 731503 Gybbys, William, of Charyngworth, yeoman 5
5101884 2386973 2386973 defendant Bayly Thomas husbandman 731503 731503 Bayly, Thomas, of Charyngworth, husbandman 6
5101885 2386973 2386973 defendant Hereward John husbandman 616508 616508 Hereward, John, of Weston Underegge, husbandman 7
5101886 2386973 2386973 defendant Herward Thomas husbandman 616508 616508 Herward, Thomas, of Weston Underegge, husbandman 8
5101887 2386973 2386973 defendant Ayleworth John gent 829174 829174 Ayleworth, John, of Ayleworth, gent 9
5101888 2386973 2386973 defendant Chadwell John husbandman 846543 846543 Chadwell, John, of Magna Rosyngdon, husbandman 10
5101889 2386973 2386973 defendant Lecche John husbandman 846544 846544 Lecche, John, of Magna Rosyngton, husbandman 11
5101890 2386973 2386973 defendant Hereward Richard husbandman 594649 594649 Hereward, Richard, of Pebworth, husbandman 12
5101891 2386973 2386973 defendant Chadwell John husbandman 843746 843746 Chadwell, John, of Parva Barnyngton, husbandman 13
5101892 2386973 2386973 defendant Beamount John   846545 846545 Beamount, John, of Dorsyngton, husbandan 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);