names

14 rows where case_id = 2482947

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5426755 2482947 2482947 plaintiff Daume Simon     Daume, Simon, on his own account 0
5426756 2482947 2482947 defendant Wygour Robert yeoman 589536 589536 Wygour, Robert, of Shotesham, yeoman 0
5426757 2482947 2482947 defendant Machon Robert husbandman 655131 655131 Machon, Robert, of Canston, husbandman 1
5426758 2482947 2482947 defendant Bircham John tanner 599088 599088 Bircham, John, of Thornage, tanner 2
5426759 2482947 2482947 defendant Cokkys John husbandman 586471 586471 Cokkys, John, of Aylesham, husbandman 3
5426760 2482947 2482947 defendant Wethy Henry husbandman 761744 761744 Wethy, Henry, of Great Ryburgh, husbandman 4
5426761 2482947 2482947 defendant Estgate Roger gent 589000 589000 Estgate, Roger, of Bradfeld, gent 5
5426762 2482947 2482947 defendant Clerk John husbandman 641966 641966 Clerk, John, of Clyppysby, husbandman 6
5426763 2482947 2482947 defendant Pyke Robert shoemaker 586102 586102 Pyke, Robert, of Hengham, shoemaker 7
5426764 2482947 2482947 defendant Bysshop Nicholas yeoman 637874 637874 Bysshop, Nicholas, of Bawdeswell, yeoman 8
5426765 2482947 2482947 defendant Pecok William yeoman 585933 585933 Pecok, William, of Great Yarmouth, yeoman 9
5426766 2482947 2482947 defendant Whall Thomas husbandman 617565 617565 Whall, Thomas, of Erpyngham, husbandman 10
5426767 2482947 2482947 defendant Styward Thomas yeoman 588931 588931 Styward, Thomas, of Horsham St Faith, yeoman 11
5426768 2482947 2482947 defendant Barnard Thomas     Barnard, Thomas 12

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