names

35 rows where place_id = 607827

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640130 1907359 1907359 defendant Cade John (legal representative) 607827 607827 Cade, John, of Hoxne, Suff, husbandman, executor of 0
3653789 1911443 1911443 defendant Cade John (legal representative) 607827 607827 Cade, John, of Hoxne, Suff, husbandman, executor of 0
3670949 1916884 1916884 plaintiff Cantrell Ralph yeoman 607827 607827 Cantrell, Ralph, of Hoxne, Suff, yeoman 0
3670951 1916885 1916885 plaintiff Cantrell Ralph yeoman 607827 607827 Cantrell, Ralph, of Hoxne, Suff, yeoman 0
3794259 1956076 1956076 plaintiff Cantrell Ralph gent 607827 607827 Cantrell, Ralph, of Hoxne, Suff, gent 0
3797793 1957207 1957207 defendant Monforth John yeoman 607827 607827 Monforth, John, of Hoxne, Suff, yeoman 0
3797796 1957208 1957208 defendant Monforth John yeoman 607827 607827 Monforth, John, of Hoxne, Suff, yeoman 0
3828159 1966674 1966674 defendant Grynston William gent 607827 607827 Grynston, William, of Hoxne, Suff, gent 0
3836363 1969281 1969281 plaintiff Remching John   607827 607827 Remching, John, of Hoxne, Suff, notary public 0
3836365 1969282 1969282 plaintiff Remchyng John   607827 607827 Remchyng, John, of Hoxne, Suff, notary public 0
3860267 1976931 1976931 defendant Redmayne Richard clerk 607827 607827 Redmayne, Richard, of Hoxne, Suff, clerk 0
3860269 1976932 1976932 defendant Redmayne Richard clerk 607827 607827 Redmayne, Richard, of Hoxne, Suff, clerk 0
3869970 1980198 1980198 defendant Lacy Richard yeoman 607827 607827 Lacy, Richard, of Hoxne, Suff, yeoman 0
3869972 1980199 1980199 defendant Lacy Richard yeoman 607827 607827 Lacy, Richard, of Hoxne, Suff, yeoman 0
3871469 1980701 1980701 defendant Cantrell Ralph gent 607827 607827 Cantrell, Ralph, of Hoxne, Suff, gent 2
3874337 1981641 1981641 defendant Ferrour Thomas yeoman 607827 607827 Ferrour, Thomas, of Hoxne, Suff, yeoman 1
3876050 1982243 1982243 defendant Samon Thomas clerk 607827 607827 Samon, Thomas, of Hoxne, Suff, clerk 0
3885052 1985262 1985262 defendant Ratclyffe Thomas chapman 607827 607827 Ratclyffe, Thomas, of Hoxne, Suff, chapman 0
3885057 1985264 1985264 defendant Ratclyffe Thomas chapman 607827 607827 Ratclyffe, Thomas, of Hoxne, Suff, chapman 1
3897533 1989390 1989390 defendant Barett John smith 607827 607827 Barett, John, of Hoxne, Suff, smith 0
3898187 1989599 1989599 defendant Lacy Richard yeoman 607827 607827 Lacy, Richard, of Hoxne, Suff, yeoman 0
3966636 2012966 2012966 defendant Sherwood John yeoman 607827 607827 Sherwood, John, of Hoxne, Suff, yeoman 0
4074639 2051232 2051232 defendant Gower Peter yeoman 607827 607827 Gower, Peter, of Hoxne, Suff, yeoman 1
4081795 2053793 2053793 defendant Bradley William Master of Arts of Cambridge 607827 607827 Bradley, William, of Hoxne, Suff, Master of Arts of Cambridge 3
4152268 2078905 2078905 defendant Fulcher Simon yeoman 607827 607827 Fulcher, Simon, of Hoxne, Suff, yeoman 0
4241880 2110276 2110276 defendant Wrighte Thomas   607827 607827 Wrighte, Thomas, of Hoxne, Suff, mason 2
4241913 2110286 2110286 defendant Wright Thomas   607827 607827 Wright, Thomas, of Hoxne, Suff, mason 2
4277581 2122082 2122082 defendant Kewe John tanner 607827 607827 Kewe, John, of Hoxne, Suff, tanner 0
4285694 2124934 2124934 defendant Gislingham Nicholas yeoman 607827 607827 Gislingham, Nicholas, of Hoxne, Suff, yeoman 0
4286607 2125257 2125257 defendant Peyne Thomas butcher 607827 607827 Peyne, Thomas, of Hoxne, Suff, butcher 2
4916994 2331820 2331820 defendant Mannyng Simon butcher 607827 607827 Mannyng, Simon, of Hoxne, Suff, butcher 4
5530995 2514209 2514209 defendant Everard Stephem yeoman 607827 607827 Everard, Stephem, of Hoxne, Suff, yeoman 3
5554628 2521384 2521384 defendant Botomley John yeoman 607827 607827 Botomley, John, of Hoxne, Suff, yeoman 3
5554637 2521385 2521385 defendant Botomley John yeoman 607827 607827 Botomley, John, of Hoxne, Suff, yeoman 3
5554641 2521385 2521385 defendant Smyth John yeoman 607827 607827 Smyth, John, of Hoxne, Suff, yeoman 7

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