names

27 rows where place_id = 625660

✎ 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
3765509 1946877 1946877 defendant Hykmotte Robert chapman 625660 625660 Hykmotte, Robert, of Sutton Valence, Kent, chapman 0
3766674 1947239 1947239 defendant Hepy Ralph weaver 625660 625660 Hepy, Ralph, of Sutton Valence, Kent, weaver 1
3778383 1950953 1950953 defendant Clyfford Nicholas   625660 625660 Clyfford, Nicholas, of Sutton Valence, Kent, esq, son of Clyfford, Lewis 0
3884571 1985111 1985111 defendant Clyfford Nicholas esq 625660 625660 Clyfford, Nicholas, of Sutton Valence, Kent, esq 1
3898207 1989608 1989608 defendant Clyfford Nicholas esq 625660 625660 Clyfford, Nicholas, of Sutton Valence, Kent, esq 0
3906479 1992459 1992459 defendant Clyfford Nicholas gent 625660 625660 Clyfford, Nicholas, of Sutton Valence, Kent, gent 4
3913592 1994884 1994884 defendant Forde Stephen mercer 625660 625660 Forde, Stephen, of Sutton Valence, Kent, mercer 0
4106911 2062764 2062764 defendant Moore Edward esq 625660 625660 Moore, Edward, of Sutton Valence, Kent, or of London, esq 0
4697051 2264557 2264557 defendant Clyfford William esq 625660 625660 Clyfford, William, of Sutton Valence, Kent, esq 0
4721915 2272186 2272186 defendant Clifford William esq 625660 625660 Clifford, William, of Sutton Valence, Kent, esq 0
4738622 2277168 2277168 defendant Shirborne John gent 625660 625660 Shirborne, John, of Sutton Valence, Kent, gent 1
4742847 2278417 2278417 defendant Clifford William esq 625660 625660 Clifford, William, of Sutton Valence, Kent, esq 0
4742850 2278418 2278418 defendant Clifford William esq 625660 625660 Clifford, William, of Sutton Valence, Kent, esq 0
4765187 2285093 2285093 defendant Clifford William esq 625660 625660 Clifford, William, of Sutton Valence, Kent, esq 0
4777968 2289094 2289094 defendant Clifford William esq 625660 625660 Clifford, William, of Sutton Valence, Kent, esq 0
4856423 2313385 2313385 defendant Clyfford William esq 625660 625660 Clyfford, William, of Sutton Valence, Kent, esq 0
4856427 2313386 2313386 defendant Clyfford William esq 625660 625660 Clyfford, William, of Sutton Valence, Kent, esq 1
4890707 2323846 2323846 defendant Clyfford William esq 625660 625660 Clyfford, William, of Sutton Valence, Kent, esq 0
4897234 2325791 2325791 defendant Clyfford William esq 625660 625660 Clyfford, William, of Sutton Valence, Kent, esq 0
5017128 2361907 2361907 defendant Goldryng Lawrence clerk 625660 625660 Goldryng, Lawrence, of Sutton Valence, Kent, clerk 0
5113796 2390428 2390428 defendant Rotyng William smith 625660 625660 Rotyng, William, of Sutton Valence, Kent, smith 3
5113802 2390429 2390429 defendant Rotyng William smith 625660 625660 Rotyng, William, of Sutton Valence, Kent, smith 3
5128475 2394799 2394799 defendant Hadde William husbandman 625660 625660 Hadde, William, of Sutton Valence, Kent, husbandman 0
5147974 2400552 2400552 defendant Hadde William husbandman 625660 625660 Hadde, William, of Sutton Valence, Kent, husbandman 0
5167442 2406210 2406210 defendant Hadde William husbandman 625660 625660 Hadde, William, of Sutton Valence, Kent, husbandman 0
5377952 2468684 2468684 plaintiff Parke William yeoman 625660 625660 Parke, William, of Sutton Valence, Kent, yeoman 1
5496827 2503977 2503977 defendant Osmere George gent 625660 625660 Osmere, George, of Sutton Valence, Kent, gent 1

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