names

20 rows where case_id = 2454318

✎ 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
5330929 2454318 2454318 plaintiff Bourghchier John knight   Bourghchier, John, knight 0
5330930 2454318 2454318 plaintiff Grey Edward knight   Grey, Edward, knight 1
5330931 2454318 2454318 plaintiff Temple Nicholas     Temple, Nicholas 2
5330932 2454318 2454318 plaintiff Jakes Robert     Jakes, Robert 3
5330933 2454318 2454318 defendant Wodlond John butcher 592745 592745 Wodlond, John, of Hynkeley, butcher 0
5330934 2454318 2454318 defendant Wodlond John, junior husbandman 592745 592745 Wodlond, John, junior, of Hynkeley, husbandman 1
5330935 2454318 2454318 defendant Jakes Thomas husbandman 592745 592745 Jakes, Thomas, of Hynkeley, husbandman 2
5330936 2454318 2454318 defendant Hyll John husbandman 592745 592745 Hyll, John, of Hynkeley, husbandman 3
5330937 2454318 2454318 defendant Max John tailor 592745 592745 Max, John, of Hynkeley, tailor 4
5330938 2454318 2454318 defendant Wodlond Robert husbandman 592745 592745 Wodlond, Robert, of Hynkeley, husbandman 5
5330939 2454318 2454318 defendant Wodlond Henry husbandman 592745 592745 Wodlond, Henry, of Hynkeley, husbandman 6
5330940 2454318 2454318 defendant Baudewyn William husbandman 592745 592745 Baudewyn, William, of Hynkeley, husbandman 7
5330941 2454318 2454318 defendant Tanwell Richard busbandman 592745 592745 Tanwell, Richard, of Hynkeley, busbandman 8
5330942 2454318 2454318 defendant Reson John husbandman 592745 592745 Reson, John, of Hynkeley, husbandman 9
5330943 2454318 2454318 defendant Wylson John mercer 592745 592745 Wylson, John, of Hynkeley, mercer 10
5330944 2454318 2454318 defendant Barley John weaver 592745 592745 Barley, John, of Hynkeley, weaver 11
5330945 2454318 2454318 defendant Galofer Robert husbandman 586459 586459 Galofer, Robert, of Stoke, husbandman 12
5330946 2454318 2454318 defendant Maryot Thomas husbandman 586459 586459 Maryot, Thomas, of Stoke, husbandman 13
5330947 2454318 2454318 defendant Mason John husbandman 592752 592752 Mason, John, of Lynley, husbandman 14
5330948 2454318 2454318 defendant Brycheley Richard husbandman 612876 612876 Brycheley, Richard, of Wyken, husbandman 15

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