names

45 rows where place_id = 610680

✎ 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
3634034 1905443 1905443 defendant Legh John   610680 610680 Legh, John, of Isle of Wight, knight 1
3684677 1921340 1921340 defendant Hodson Richard husbandman 610680 610680 Hodson, Richard, of Isle of Wight, husbandman 0
3687408 1922238 1922238 defendant Long Richard mariner 610680 610680 Long, Richard, of Isle of Wight, mariner 2
3845362 1972109 1972109 defendant Wyndat Nicholas gent 610680 610680 Wyndat, Nicholas, of Isle of Wight, gent 0
3864439 1978304 1978304 defendant Stoward William merchant 610680 610680 Stoward, William, of Isle of Wight, merchant 0
3874978 1981854 1981854 defendant Potnall William chapman 610680 610680 Potnall, William, of Isle of Wight, chapman 1
3875012 1981868 1981868 defendant Stower William merchant 610680 610680 Stower, William, of Isle of Wight, merchant 0
3944727 2005255 2005255 defendant Worseley Giles (legal representative) 610680 610680 Worseley, Giles, of Isle of Wight, gent, executrix of 0
3944728 2005255 2005255 defendant Worsseley Margaret widow 610680 610680 Worsseley, Margaret, of Isle of Wight, widow 1
3954974 2008803 2008803 plaintiff Lye Barnaby (legal representative) 610680 610680 Lye, Barnaby, of Isle of Wight, gent, executor of 0
3962693 2011535 2011535 defendant Cotton Robert haberdasher 610680 610680 Cotton, Robert, of Isle of Wight, haberdasher 3
3963034 2011669 2011669 defendant Cooke John gent 610680 610680 Cooke, John, of Isle of Wight, gent 0
4028889 2034977 2034977 defendant Eston Thomas gent 610680 610680 Eston, Thomas, of Isle of Wight, gent 7
4042846 2039916 2039916 defendant Cornelys Joan widow 610680 610680 Cornelys, Joan, of Isle of Wight, widow 1
4101647 2060896 2060896 defendant Bradley Thomas yeoman 610680 610680 Bradley, Thomas, of Isle of Wight, yeoman 0
4256834 2115257 2115257 defendant Jeames Richard chapman 610680 610680 Jeames, Richard, of Isle of Wight, chapman 0
4264111 2117649 2117649 defendant Norwood Elizabeth widow 610680 610680 Norwood, Elizabeth, of Isle of Wight, widow 2
4269105 2119260 2119260 defendant James Richard   610680 610680 James, Richard, of Isle of Wight, Hants chapman 0
4558738 2218687 2218687 defendant Taillour Robert   610680 610680 (Taillour, Robert, of Isle of Wight 1
4661617 2249469 2249469 defendant daughter Margery   610680 610680 Margery daughter, of Ralph Ive, of Isle of Wight 3
4786606 2291861 2291861 defendant Veer Walter esq 610680 610680 Veer, Walter, of Isle of Wight, esq 0
4787082 2292021 2292021 defendant Coun or Conn Philip mariner 610680 610680 Coun or Conn, Philip, of Isle of Wight, mariner 2
4789479 2292777 2292777 defendant Parker Thomas esq 610680 610680 Parker, Thomas, of Isle of Wight, yeoman, dwelling with Walter Veer, esq 1
4789484 2292778 2292778 defendant Parker Thomas esq 610680 610680 Parker, Thomas, of Isle of Wight, yeoman, dwelling with Walter Veer, esq 1
4971194 2348322 2348322 defendant Borrard Geoffrey   610680 610680 Borrard, Geoffrey, of Isle of Wight 0
4971200 2348324 2348324 defendant Borrard Geoffrey   610680 610680 Borrard, Geoffrey, of Isle of Wight 0
5052333 2372299 2372299 defendant Metebole Thomas yeoman 610680 610680 Metebole, Thomas, of Isle of Wight, yeoman 0
5052334 2372299 2372299 defendant Blower Robert gent 610680 610680 Blower, Robert, of Isle of Wight, gent 1
5142229 2398848 2398848 defendant (illegible) Thomas yeoman 610680 610680 --, Thomas, of Isle of Wight, yeoman 1
5228610 2423977 2423977 plaintiff West John husbandman 610680 610680 West, John, of Isle of Wight, husbandman 0
5228779 2424028 2424028 defendant Busshette John taverner 610680 610680 Busshette, John, of Isle of Wight, taverner 2
5240456 2427422 2427422 plaintiff Jolyff Thomas   610680 610680 Jolyff, Thomas, of Isle of Wight 0
5240461 2427422 2427422 defendant Stoure George miller 610680 610680 Stoure, George, of Isle of Wight, miller 4
5480126 2499041 2499041 defendant Sanell or Savell John   610680 610680 Sanell or Savell, John, of Isle of Wight, knight 0
5500439 2505074 2505074 defendant Moryn Thomas yeoman 610680 610680 Moryn, Thomas, of Isle of Wight, yeoman 0
5509508 2507818 2507818 defendant Gylbert John chapman 610680 610680 Gylbert, John, of Isle of Wight, chapman 0
5509518 2507819 2507819 defendant Gylbert John chapman 610680 610680 Gylbert, John, of Isle of Wight, chapman 0
5571871 2526313 2526313 plaintiff Lygh John   610680 610680 Lygh, John, of Isle of Wight, knight 0
5577469 2528012 2528012 defendant Seman Nicholas mercer 610680 610680 Seman, Nicholas, of Isle of Wight, mercer 2
5598879 2534525 2534525 defendant Legh John   610680 610680 Legh, John, of Isle of Wight, knight 0
5601867 2535481 2535481 defendant Leigh John   610680 610680 Leigh, John, of Isle of Wight, knight 1
5624481 2551599 2551599 defendant Frere Alexander   610680 610680 Frere, Alexander, of Isle of Wight, holy water clerk 1
5634535 2554800 2554800 plaintiff Veer John   610680 610680 Veer, John, of Isle of Wight 0
5634539 2554801 2554801 plaintiff Veer John   610680 610680 Veer, John, of Isle of Wight 0
5634543 2554802 2554802 plaintiff Veer John   610680 610680 Veer, John, of Isle of Wight 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);