names

37 rows where place_id = 586492

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588861 1864166 1864166 defendant Bowe Stephen chapman 586492 586492 Bowe, Stephen, of Maydston, Kent, chapman 3
3588866 1864167 1864167 defendant Bowe Stephen chapman 586492 586492 Bowe, Stephen, of Maydston, Kent, chapman 2
3644939 1908826 1908826 defendant Lee Richard gent 586492 586492 Lee, Richard, of Maydston, Kent, gent 1
3673615 1917778 1917778 defendant Fyssher John gent 586492 586492 Fyssher, John, of Maydston, Kent, gent 1
3678700 1919404 1919404 defendant Coveney John clothier 586492 586492 Coveney, John, of Maydston, Kent, clothier 0
3678821 1919444 1919444 defendant Coveney John clothier 586492 586492 Coveney, John, of Maydston, Kent, clothier 0
3696906 1925253 1925253 defendant Toby or Tovy Thomas (legal representative) 586492 586492 Toby or Tovy, Thomas, of Maydston, Kent, tailor, executrix of 0
3749441 1941741 1941741 defendant Lorkyn Thomas carpenter 586492 586492 Lorkyn, Thomas, of Maydston, Kent, carpenter 0
3750816 1942178 1942178 defendant Audeley John yeoman 586492 586492 Audeley, John, of Maydston, Kent, yeoman 3
3763882 1946346 1946346 defendant Herynden Walter gent 586492 586492 Herynden, Walter, of Maydston, Kent, gent 0
3836003 1969173 1969173 defendant Boram David chapman 586492 586492 Boram, David, of Maydston, Kent, chapman 0
3837462 1969622 1969622 defendant Osborne George yeoman 586492 586492 Osborne, George, of Maydston, Kent, yeoman 3
3857525 1975989 1975989 defendant Herde Robert baker 586492 586492 Herde, Robert, of Maydston, Kent, baker 0
3886743 1985824 1985824 defendant Dodson John husbandman 586492 586492 Dodson, John, of Maydston, Kent, husbandman 1
3898775 1989791 1989791 defendant Barham David   586492 586492 Barham, David, of Maydston, Kent, millwright 4
3902888 1991197 1991197 defendant Bodyam Mark   586492 586492 Bodyam, Mark, of Maydston, Kent 4
3919448 1996837 1996837 defendant Wylcokys John smith 586492 586492 Wylcokys, John, of Maydston, Kent, smith 0
3958218 2009947 2009947 defendant Reve Richard   586492 586492 Reve, Richard, of Maydston, Kent 2
4012138 2029067 2029067 defendant Goore Robert yeoman 586492 586492 Goore, Robert, of Maydston, Kent, yeoman 0
4029351 2035140 2035140 defendant Mockett William saddler 586492 586492 Mockett, William, of Maydston, Kent, saddler 2
4049376 2042222 2042222 defendant Lylle or Lylly William gent 586492 586492 Lylle or Lylly, William, of Maydston, kent, gent 1
4066987 2048489 2048489 defendant Goore Robert yeoman 586492 586492 Goore, Robert, of Maydston, Kent, yeoman 0
4073030 2050651 2050651 defendant Capon John yeoman or apothecary 586492 586492 Capon, John, of Maydston, Kent, yeoman or apothecary 0
4088795 2056294 2056294 defendant Foster Thomas saddler 586492 586492 Foster, Thomas, of Maydston, Kent, saddler 2
4320013 2137105 2137105 defendant Kelsham Francis gent 586492 586492 Kelsham, Francis, of Maydston, Kent, gent 0
4343333 2144941 2144941 defendant Vyney Walter chapman 586492 586492 Vyney, Walter, of Maydston, Kent, chapman 1
4343896 2145146 2145146 defendant Willard Richard saddler 586492 586492 Willard, Richard, of Maydston, Kent, saddler 0
4356060 2149341 2149341 defendant Balser James gent 586492 586492 Balser, James, of Maydston, Kent, gent 1
4371749 2154955 2154955 defendant Parker Thomas chapman 586492 586492 Parker, Thomas, of Maydston, Kent, chapman 0
4388125 2160656 2160656 defendant Balsar James gent 586492 586492 Balsar, James, of Maydston, Kent, gent 0
4970956 2348257 2348257 defendant Broun Robert glover 586492 586492 Broun, Robert, of Maydston, Kent, glover 1
5249995 2430111 2430111 defendant Walter Thomas clothmaker 586492 586492 Walter, Thomas, of Maydston, Kent, clothmaker 0
5558961 2522571 2522571 defendant Cheley Thomas husbandman 586492 586492 Cheley, Thomas, of Maydston, Kent, husbandman 3
5581924 2529429 2529429 defendant Lynley Robert tailor 586492 586492 Lynley, Robert, of Maydston, Kent, tailor 0
5582208 2529507 2529507 defendant Coveney John dyer 586492 586492 Coveney, John, of Maydston, Kent, dyer 2
5599567 2534757 2534757 defendant Couper Thomas chapman 586492 586492 Couper, Thomas, of Maydston, Kent, chapman 3
5603767 2536046 2536046 defendant Gore Thomas (legal representative) 586492 586492 Gore, Thomas, of Maydston, Kent, freemason, executor of 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);