names

19 rows where place_id = 609860

✎ 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
3680770 1920066 1920066 defendant Rous Edmund gent 609860 609860 Rous, Edmund, of Parva Stonham, gent 3
3732348 1936353 1936353 defendant Mykelfeld Nicholas engraver 609860 609860 Mykelfeld, Nicholas, of Parva Stonham, engraver 0
3974255 2015562 2015562 defendant Mattres William yeoman 609860 609860 Mattres, William, of Parva Stonham, yeoman 0
4138667 2074195 2074195 defendant Blomefeld Arthur yeoman 609860 609860 Blomefeld, Arthur, of Parva Stonham, yeoman 0
4878813 2320311 2320311 plaintiff Sengylton Thomas esq 609860 609860 Sengylton, Thomas, of Parva Stonham, esq 1
5017655 2362039 2362039 defendant Bradwey Robert yeoman 609860 609860 Bradwey, Robert, of Parva Stonham, yeoman 0
5028042 2365081 2365081 defendant Crane Robert (legal representative) 609860 609860 Crane, Robert, of Parva Stonham, gent, executors of 4
5028050 2365082 2365082 defendant Crane Robert (legal representative) 609860 609860 Crane, Robert, of Parva Stonham, gent, executors of 4
5093061 2384357 2384357 defendant Blomvyll John yeoman 609860 609860 Blomvyll, John, of Parva Stonham, yeoman 7
5100793 2386652 2386652 defendant Blomvyll Edmund husbandman 609860 609860 Blomvyll, Edmund, of Parva Stonham, husbandman 14
5100956 2386693 2386693 defendant Hill William carpenter 609860 609860 Hill, William, of Parva Stonham, carpenter 0
5100957 2386693 2386693 defendant Blomvyle Edmund yeoman 609860 609860 Blomvyle, Edmund, of Parva Stonham, yeoman 1
5106961 2388468 2388468 defendant Seford John yeoman 609860 609860 Seford, John, of Parva Stonham, yeoman 0
5124111 2393508 2393508 defendant Seford John yeoiman 609860 609860 Seford, John, of Parva Stonham, yeoiman 0
5244895 2428682 2428682 defendant Denny John husbandman 609860 609860 Denny, John, of Parva Stonham, husbandman 0
5255097 2431706 2431706 defendant Radclyf Henry esq 609860 609860 Radclyf, Henry, of Parva Stonham, esq 0
5255098 2431706 2431706 defendant Crowe Thomas yeoman 609860 609860 Crowe, Thomas, of Parva Stonham, yeoman 1
5278753 2438894 2438894 plaintiff Blomvyle Robert   609860 609860 Blomvyle, Robert, of Parva Stonham, son of Blomvyle, John, of Parva Stonham 0
5546399 2518947 2518947 defendant Jonson William shoemaker 609860 609860 Jonson, William, of Parva Stonham, shoemaker 2

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