names

32 rows where place_id = 611604

✎ 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
3689122 1922760 1922760 defendant Gate John husbandman 611604 611604 Gate, John, of Cowfold, husbandman 0
3703770 1927459 1927459 defendant Berd Ralph yeoman 611604 611604 Berd, Ralph, of Cowfold, yeoman 0
3763205 1946126 1946126 defendant Dunstall John yeoman 611604 611604 Dunstall, John, of Cowfold, yeoman 1
3808907 1960665 1960665 defendant Dunstall John husbandman 611604 611604 Dunstall, John, of Cowfold, husbandman 0
3808908 1960665 1960665 defendant Bulle John husbandman 611604 611604 Bulle, John, of Cowfold, husbandman 1
3808909 1960665 1960665 defendant Graveley William husbandman 611604 611604 Graveley, William, of Cowfold, husbandman 2
3808910 1960665 1960665 defendant Selkeden Richard husbandman 611604 611604 Selkeden, Richard, of Cowfold, husbandman 3
3808914 1960666 1960666 defendant Bulle John husbandman 611604 611604 Bulle, John, of Cowfold, husbandman 1
3808915 1960666 1960666 defendant Graveley William husbandman 611604 611604 Graveley, William, of Cowfold, husbandman 2
3808916 1960666 1960666 defendant Selkeden Richard husbandman 611604 611604 Selkeden, Richard, of Cowfold, husbandman 3
3830879 1967540 1967540 defendant Frogebroke John husbandman 611604 611604 Frogebroke, John, of Cowfold, husbandman 3
3853192 1974619 1974619 defendant Colkok Richard yeoman 611604 611604 Colkok, Richard, of Cowfold, yeoman 0
3893378 1988017 1988017 defendant Coke Joan widow 611604 611604 (Coke, Joan, of Cowfold, widow 1
3906283 1992390 1992390 defendant Gower John chapman 611604 611604 Gower, John, of Cowfold, chapman 5
3918001 1996388 1996388 defendant Gratwyke Stephen husbandman 611604 611604 Gratwyke, Stephen, of Cowfold, husbandman 0
4050992 2042796 2042796 defendant Turner Richard grocer 611604 611604 Turner, Richard, of Cowfold, chapman, or of Dycheninge, grocer 0
4083679 2054435 2054435 defendant Cheyney Thomas gent 611604 611604 Cheyney, Thomas, of Cowfold, gent 3
4127791 2070228 2070228 defendant Tanner William gent 611604 611604 Tanner, William, of Cowfold, gent 0
4132867 2072083 2072083 defendant Cowper John husbandman 611604 611604 Cowper, John, of Cowfold, husbandman 2
4136942 2073560 2073560 defendant Baarde Joan widow 611604 611604 Baarde, Joan, of Cowfold, widow 1
4136946 2073561 2073561 defendant Bearde Joan widow 611604 611604 Bearde, Joan, of Cowfold, widow 1
4167842 2084239 2084239 defendant Asshton Richard clerk 611604 611604 Asshton, Richard, of Cowfold, clerk 0
4167843 2084239 2084239 defendant Asshton John yeoman 611604 611604 Asshton, John, of Cowfold, yeoman 1
4179494 2088305 2088305 defendant Gate Edith widow 611604 611604 (Gate, Edith, of Cowfold, widow 1
4179495 2088305 2088305 defendant Gate John husbandman 611604 611604 Gate, John, of Cowfold, husbandman 2
4371316 2154806 2154806 defendant Chatterden Richard husbandman 611604 611604 Chatterden, Richard, of Cowfold, husbandman 2
4724323 2272906 2272906 plaintiff Eston Richard   611604 611604 Eston, Richard, of Cowfold, vicar 0
4768680 2286181 2286181 defendant Pitknoll Robert husbandman 611604 611604 Pitknoll, Robert, of Cowfold, husbandman 0
4980379 2351074 2351074 defendant Couper John husbandman 611604 611604 Couper, John, of Cowfold, husbandman 0
5030356 2365752 2365752 defendant Grove John laborer 611604 611604 Grove, John, of Cowfold, laborer 0
5042737 2369435 2369435 plaintiff Dunstall John   611604 611604 Dunstall, John, of Cowfold 0
5047093 2370756 2370756 defendant Walshe William husbandman 611604 611604 Walshe, William, of Cowfold, husbandman 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);