names

31 rows where place_id = 673774

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4011315 2028823 2028823 defendant Marshe John butcher 673774 673774 Marshe, John, of Barking, Essex, butcher 0
4095614 2058759 2058759 defendant Sisley Anne widow 673774 673774 Sisley, Anne, of Barking, Essex, widow 1
4159087 2081248 2081248 defendant Stakes Thomas (legal representative) 673774 673774 Stakes, Thomas, of Barking, Essex, white baker, administratrix of 0
4282120 2123648 2123648 defendant Sell Richard   673774 673774 Sell, Richard, of Barking, Essex, basket maker 0
4282377 2123736 2123736 defendant Rivett Thomas gent 673774 673774 Rivett, Thomas, of Barking, Essex, gent 0
4364060 2152200 2152200 plaintiff Davys John (legal representative) 673774 673774 Davys, John, of Barking, Essex, gent, executors of 0
4693104 2263348 2263348 defendant Catour Richard   673774 673774 Catour, Richard, of Barking, Essex, "catour" 4
4724769 2273045 2273045 defendant Wilton Henry clerk 673774 673774 Wilton, Henry, of Barking, Essex, clerk 0
4762977 2284404 2284404 defendant Moor Roger yeoman 673774 673774 Moor, Roger, of Barking, Essex, yeoman 0
4992246 2354573 2354573 defendant Stokedale Thomas gent 673774 673774 Stokedale, Thomas, of Barking, Essex, gent 1
5007802 2359175 2359175 defendant Thurkyld John shipman 673774 673774 Thurkyld, John, of Barking, Essex, shipman 3
5011303 2360166 2360166 defendant Payn John gent 673774 673774 Payn, John, of Barking, Essex, gent 0
5158023 2403469 2403469 defendant Serle John dyer 673774 673774 Serle, John, of Barking, Essex, dyer 4
5173745 2408017 2408017 defendant Serle John dyer 673774 673774 Serle, John, of Barking, Essex, dyer 4
5175694 2408574 2408574 defendant Barre Walter yeoman 673774 673774 Barre, Walter, of Barking, Essex, yeoman 0
5180330 2409988 2409988 defendant Grenyng John   673774 673774 Grenyng, John, of Barking, Essex, vicar 0
5180332 2409989 2409989 defendant (not given) John vicar of Grenyng 673774 673774 Grenyng, John, of Barking, Essex, vicar of the parish church 0
5192881 2413641 2413641 defendant Dryland John chapman 673774 673774 Dryland, John, of Barking, Essex, chapman 2
5198967 2415451 2415451 defendant Harleston William husbandman 673774 673774 (Harleston, William, of Barking, Essex, husbandman 1
5198973 2415452 2415452 defendant Harleston William husbandman 673774 673774 (Harleston, William, of Barking, Essex, husbandman 1
5210863 2418909 2418909 defendant Harleston William husbandman 673774 673774 (Harleston, William, of Barking, Essex, husbandman 1
5210865 2418909 2418909 defendant Lyman John yeoman 673774 673774 Lyman, John, of Barking, Essex, yeoman 3
5424383 2482257 2482257 defendant Curson John tanner 673774 673774 Curson, John, of Barking, Essex, tanner 2
5426341 2482833 2482833 defendant Shuldham Hugh esq 673774 673774 Shuldham, Hugh, of Barking, Essex, esq 0
5433600 2485014 2485014 defendant Bedyngham Thomas yeoman 673774 673774 Bedyngham, Thomas, of Barking, Essex, yeoman 0
5460792 2493175 2493175 defendant Horn John fisher 673774 673774 Horn, John, of Barking, Essex, fisher 3
5467753 2495289 2495289 defendant Frost John yeoman 673774 673774 Frost, John, of Barking, Essex, yeoman 0
5472380 2496705 2496705 defendant Horn John fisher 673774 673774 Horn, John, of Barking, Essex, fisher 3
5472386 2496706 2496706 defendant Horn John fisher 673774 673774 Horn, John, of Barking, Essex, fisher 3
5473082 2496907 2496907 defendant Bedyngham Thomas   673774 673774 Bedyngham, Thomas, of Barking, Essex 0
5473670 2497092 2497092 defendant Bedyngham Thomas   673774 673774 Bedyngham, Thomas, of Barking, Essex 0

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