names

42 rows where place_id = 594897

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618043 1873265 1873265 defendant Kelet Robert clerk 594897 594897 Kelet, Robert, of Okham, clerk 0
3618044 1873265 1873265 defendant Frelond William husbandman 594897 594897 Frelond, William, of Okham, husbandman 1
3713710 1930585 1930585 defendant Stampe John husbandman 594897 594897 Stampe, John, of Okham, husbandman 0
3715577 1931159 1931159 defendant Morecroft Richard yeoman 594897 594897 Morecroft, Richard, of Okham, yeoman 1
3739513 1938566 1938566 defendant Jervys Henry yeoman 594897 594897 Jervys, Henry, of Okham, yeoman 2
3747274 1941069 1941069 defendant Waren James gent 594897 594897 Waren, James, of Okham, gent 0
3782943 1952411 1952411 plaintiff Jervis Henry   594897 594897 Jervis, Henry, of Okham, bailiff 0
3801336 1958348 1958348 plaintiff Weston John   594897 594897 Weston, John, of Okham 1
3818829 1963796 1963796 plaintiff Weston John   594897 594897 Weston, John, of Okham 1
4290815 2126772 2126772 defendant Cole Thomas butcher 594897 594897 Cole, Thomas, of Okham, yeoman, butcher 0
4310443 2133808 2133808 defendant Graye Clement   594897 594897 Graye, Clement, of Okham, woollen draper 0
4310445 2133809 2133809 defendant Hopper William yeoman 594897 594897 Hopper, William, of Okham, yeoman 0
4310447 2133810 2133810 defendant Cole Thomas butcher 594897 594897 Cole, Thomas, of Okham, butcher 0
4310614 2133859 2133859 defendant Bickerton Thomas tailor 594897 594897 Bickerton, Thomas, of Okham, tailor 1
4310742 2133901 2133901 defendant Mayxson Roger   594897 594897 Mayxson, Roger, of Okham, tallow chandler 0
4314530 2135193 2135193 defendant Beeson George mercer 594897 594897 Beeson, George, of Okham, mercer 0
4320700 2137334 2137334 defendant Manxson Roger   594897 594897 Manxson, Roger, of Okham, tallow chandler 0
4419284 2170912 2170912 defendant Turkeys Joan   594897 594897 Turkeys, Joan, of Okham, formerly wife of John 0
4442627 2182643 2182643 defendant Trowehay John de   594897 594897 Trowehay, John de, of Okham, shepherd 0
4452023 2185618 2185618 plaintiff H--y Robert   594897 594897 H--y, Robert, of Okham 0
4484411 2195816 2195816 defendant Melton John shoemaker 594897 594897 Melton, John, of Okham, shoemaker 0
4521006 2206904 2206904 defendant Otho Broke Thomas   594897 594897 Otho Broke, Thomas, of Okham 0
4576910 2224282 2224282 defendant Forde John   594897 594897 Forde, John, of Okham 0
4621428 2237694 2237694 defendant Dene Thomas skinner 594897 594897 Dene, Thomas, of Okham, skinner 1
4663429 2250036 2250036 defendant Campe Robert husbandman 594897 594897 Campe, Robert, of Okham, husbandman 0
4663430 2250036 2250036 defendant Eltham Richard   594897 594897 Eltham, Richard, of Okham, marchment maker 1
4803063 2297145 2297145 defendant Germyn John husbandman 594897 594897 Germyn, John, of Okham, husbandman 0
4803064 2297145 2297145 defendant Jorge William laborer & son of Katherine Germyn 594897 594897 Jorge, William, of Okham, laborer & son of Katherine Germyn 1
4831415 2305858 2305858 defendant Hammes Robert husbandman 594897 594897 Hammes, Robert, of Okham, husbandman 0
4839259 2308204 2308204 defendant Pleynmour Robert husbandman 594897 594897 Pleynmour, Robert, of Okham, husbandman 4
4858302 2313970 2313970 defendant Hammes Robert husbandman 594897 594897 Hammes, Robert, of Okham, husbandman 0
4973923 2349162 2349162 defendant Kendale Thomas yeoman 594897 594897 Kendale, Thomas, of Okham, yeoman 2
5006977 2358940 2358940 defendant Leche William husbandman 594897 594897 Leche, William, of Okham, husbandman 1
5060353 2374672 2374672 defendant Boteler John, senior yeoman 594897 594897 Boteler, John, senior, of Okham, yeoman 0
5092340 2384138 2384138 defendant Grymee John husbandman 594897 594897 Grymee, John, of Okham, husbandman 1
5122720 2393080 2393080 defendant Gonby Thomas chapman 594897 594897 Gonby, Thomas, of Okham, chapman 3
5122725 2393081 2393081 defendant Gonby Thomas chapman 594897 594897 Gonby, Thomas, of Okham, chapman 3
5284701 2440537 2440537 defendant Frelond John husbandman 594897 594897 Frelond, John, of Okham, husbandman 2
5351982 2460722 2460722 defendant Hamme John yeoman 594897 594897 Hamme, John, of Okham, yeoman 0
5422511 2481678 2481678 defendant Lyre John clerk 594897 594897 Lyre, John, of Okham, clerk 0
5423030 2481837 2481837 defendant Gyre or Oyre John clerk 594897 594897 Gyre or Oyre, John, of Okham, clerk 0
5523786 2512261 2512261 defendant Frelande Robert yeoman 594897 594897 Frelande, Robert, of Okham, yeoman 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);