names

21 rows where case_id = 2386652

✎ 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
5100778 2386652 2386652 plaintiff Aldhous Thomas     Aldhous, Thomas 0
5100779 2386652 2386652 defendant Grundeshawe Richard husbandman 589159 589159 Grundeshawe, Richard, of Codenham, husbandman 0
5100780 2386652 2386652 defendant Crosford or Crofford Robert husbadman 609456 609456 Crosford or Crofford, Robert, of Buxlowe, husbadman 1
5100781 2386652 2386652 defendant Brook John clerk 594179 594179 Brook, John, of Cotton, clerk 2
5100782 2386652 2386652 defendant Brook Nicholas husbandman 594179 594179 Brook, Nicholas, of Cotton, husbandman 3
5100783 2386652 2386652 defendant Norwold John clerk 814306 814306 Norwold, John, of Onhous, clerk 4
5100784 2386652 2386652 defendant Berkwey Richard husbandman 606964 606964 Berkwey, Richard, of Cretyng All Saints, husbandman 5
5100785 2386652 2386652 defendant Dobbes Robert carver 601374 601374 Dobbes, Robert, of Botesdale, carver 6
5100786 2386652 2386652 defendant Joly Hugh husbandman 640610 640610 Joly, Hugh, of Wyverston, husbandman 7
5100787 2386652 2386652 defendant Thweyt James husbandman 597361 597361 Thweyt, James, of Thrandeston, husbandman 8
5100788 2386652 2386652 defendant Hert William fuller 586405 586405 Hert, William, of Nedham Market, fuller 9
5100789 2386652 2386652 defendant Hert Henry husbandman 586408 586408 Hert, Henry, of Wederyngset, husbandman 10
5100790 2386652 2386652 defendant Hert Richard fuller 586408 586408 Hert, Richard, of Wederyngset, fuller 11
5100791 2386652 2386652 defendant Smyth John smith 592390 592390 Smyth, John, of Dysse, Norf, smith 12
5100792 2386652 2386652 defendant Herry John weaver 587882 587882 Herry, John, of Lavenham, weaver 13
5100793 2386652 2386652 defendant Blomvyll Edmund husbandman 609860 609860 Blomvyll, Edmund, of Parva Stonham, husbandman 14
5100794 2386652 2386652 defendant Couper Thomas husbandman 586818 586818 Couper, Thomas, of Stowemarket, husbandman 15
5100795 2386652 2386652 defendant Reve Thomas dyer 586818 586818 Reve, Thomas, of Stowemarket, dyer 16
5100796 2386652 2386652 defendant Lote Thomas husbandman 588029 588029 Lote, Thomas, of Westhale, husbandman 17
5100797 2386652 2386652 defendant Lacy Thomas husbandman 640610 640610 Lacy, Thomas, of Wyverston, husbandman 18
5100798 2386652 2386652 defendant Herry Thomas weaver 587882 587882 Herry, Thomas, of Lavenham, weaver 19

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