names

36 rows where place_id = 658130

✎ 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
3947159 2006072 2006072 plaintiff Clampe Isabel widow 658130 658130 Clampe, Isabel, of Huntington, Hunts, widow 0
3950806 2007351 2007351 defendant Symcote William gent 658130 658130 Symcote, William, of Huntington, Hunts, gent 0
3951730 2007662 2007662 defendant Smyth Gilbert chapman 658130 658130 Smyth, Gilbert, of Huntington, Hunts, chapman 0
3958983 2010222 2010222 defendant Whitlay Richard clerk 658130 658130 Whitlay, Richard, of Huntington, Hunts, clerk 0
3958989 2010224 2010224 defendant Whitley Richard clerk 658130 658130 Whitley, Richard, of Huntington, Hunts, clerk 0
3965380 2012507 2012507 defendant Dackam Henry gent 658130 658130 Dackam, Henry, of Huntington, Hunts, gent 0
3976627 2016400 2016400 defendant Dylcham Henry gent 658130 658130 Dylcham, Henry, of Huntington, Hunts, gent 0
3981160 2018020 2018020 defendant Symcott William gent 658130 658130 Symcott, William, of Huntington, Hunts, gent 0
3981446 2018131 2018131 defendant Dackam Henry gent 658130 658130 Dackam, Henry, of Huntington, Hunts, gent 0
3984975 2019384 2019384 defendant Dackam Henry gent 658130 658130 Dackam, Henry, of Huntington, Hunts, gent 0
3992792 2022174 2022174 defendant Woodroff Clement yeoman 658130 658130 Woodroff, Clement, of Huntington, Hunts, yeoman 0
3993965 2022592 2022592 defendant Bedford Thomas chapman 658130 658130 Bedford, Thomas, of Huntington, Hunts, chapman 0
3993970 2022594 2022594 defendant Fotherby John chapman 658130 658130 Fotherby, John, of Huntington, Hunts, chapman 0
3996186 2023386 2023386 defendant Symcott William innkeeper 658130 658130 Symcott, William, of Huntington, Hunts, innkeeper 1
4001527 2025327 2025327 defendant Edwardes Thomas merchant 658130 658130 Edwardes, Thomas, of Huntington, Hunts, merchant 0
4018069 2031181 2031181 defendant Bedforde thomas chapman 658130 658130 Bedforde, thomas, of Huntington, Hunts, chapman 1
4018803 2031456 2031456 defendant Cottysmore Henry vintner 658130 658130 Cottysmore, Henry, of Huntington, Hunts, vintner 0
4042400 2039763 2039763 defendant Bullyngham John   658130 658130 Bullyngham, John, of Huntington, Hunts, Doctor of Divinity, prebendary of Wenlock Barne in St Pauls Cathedral 0
4067764 2048782 2048782 defendant Wylkes Christopher draper 658130 658130 Wylkes, Christopher, of Huntington, Hunts, draper 0
4076003 2051714 2051714 defendant Bevill Robert   658130 658130 Bevill, Robert, of Huntington, Hunts 0
4076005 2051715 2051715 defendant Bevyll Robert   658130 658130 Bevyll, Robert, of Huntington,, Hunts 0
4078164 2052492 2052492 defendant Richarde John gent 658130 658130 Richarde, John, of Huntington, Hunts, gent 10
4089312 2056462 2056462 defendant Wilk Christopher draper 658130 658130 Wilk, Christopher, of Huntington, Hunts, draper 0
4115565 2065853 2065853 defendant Cottismore Henry vintner 658130 658130 Cottismore, Henry, of Huntington, Hunts, vintner 1
4122522 2068361 2068361 defendant Edward William chapman 658130 658130 Edward, William, of Huntington, Hunts, chapman 2
4123223 2068607 2068607 defendant Edward William chapman 658130 658130 Edward, William, of Huntington, Hunts, chapman 0
4123585 2068737 2068737 defendant Wylkes Christopher draper 658130 658130 Wylkes, Christopher, of Huntington, Hunts, draper 0
4124578 2069085 2069085 defendant Edward William chapman 658130 658130 Edward, William, of Huntington, Hunts, chapman 2
4139401 2074453 2074453 defendant Edward William chapman 658130 658130 Edward, William, of Huntington, Hunts, chapman 0
4140985 2075006 2075006 defendant Hexam John gent 658130 658130 Hexam, John, of Huntington, Hunts, gent 0
4148616 2077641 2077641 defendant Adlyngton Henry chapman 658130 658130 Adlyngton, Henry, of Huntington, Hunts, chapman 2
4150742 2078400 2078400 defendant Wylkes Christopher draper 658130 658130 Wylkes, Christopher, of Huntington, Hunts, draper 0
4167797 2084226 2084226 defendant Baxter William yeoman 658130 658130 Baxter, William, of Huntington, Hunts, yeoman 1
4226451 2104723 2104723 defendant Firckleton or Frecleton Ferdinand gent 658130 658130 Firckleton or Frecleton, Ferdinand, of Huntington, Hunts, gent 0
4341962 2144468 2144468 defendant Johnson Thomas chapman 658130 658130 Johnson, Thomas, of Huntington, Hunts, chapman 2
4983217 2351882 2351882 defendant Chiksond John yeoman 658130 658130 Chiksond, John, of Huntington, Hunts, yeoman 3

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