names

40 rows where place_id = 670476

✎ 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
3997248 2023786 2023786 defendant Jackson Richard yeoman 670476 670476 Jackson, Richard, of Cottingham, yeoman 0
4023962 2033274 2033274 defendant Jackson Richard yeoman 670476 670476 Jackson, Richard, of Cottingham, yeoman 1
4030729 2035653 2035653 plaintiff Elwald Thomas gent 670476 670476 Elwald, Thomas, of Cottingham, gent 0
4041618 2039496 2039496 plaintiff Normavell Thomas esq 670476 670476 Normavell, Thomas, of Cottingham, esq 0
4041621 2039497 2039497 plaintiff Normavill Thomas esq 670476 670476 Normavill, Thomas, of Cottingham, esq 0
4060317 2046089 2046089 defendant Pecke Richard esq 670476 670476 Pecke, Richard, of Cottingham, esq 0
4094284 2058293 2058293 defendant Richardson John husbandman 670476 670476 Richardson, John, of Cottingham, husbandman 0
4095766 2058819 2058819 defendant Elwalde Thomas (legal representative) 670476 670476 Elwalde, Thomas, of Cottingham, gent, executor of 0
4095767 2058819 2058819 defendant Elwalde William gent 670476 670476 Elwalde, William, of Cottingham, gent 1
4095895 2058863 2058863 defendant Bell alias Hope Edward husbandman 670476 670476 Bell alias Hope, Edward, of Cottingham, husbandman 2
4110697 2064083 2064083 defendant Burrell William yeoman 670476 670476 Burrell, William, of Cottingham, yeoman 0
4143902 2076031 2076031 defendant Elwood Thomas gent 670476 670476 Elwood, Thomas, of Cottingham, gent 0
4160523 2081754 2081754 defendant Elwalde William gent 670476 670476 Elwalde, William, of Cottingham, gent 0
4165613 2083475 2083475 defendant Backon Thomas yeoman 670476 670476 Backon, Thomas, of Cottingham, yeoman 0
4165614 2083475 2083475 defendant Elwald William, senior gent 670476 670476 Elwald, William, senior, of Cottingham, gent 1
4165615 2083475 2083475 defendant Burton Thomas husbandman 670476 670476 Burton, Thomas, of Cottingham, husbandman 2
4170461 2085161 2085161 defendant Ellwood Thomas gent 670476 670476 Ellwood, Thomas, of Cottingham, gent 0
4176214 2087157 2087157 defendant Dunne John yeoman 670476 670476 Dunne, John, of Cottingham, yeoman 0
4176215 2087157 2087157 defendant Awmonde Thomas yeoman 670476 670476 Awmonde, Thomas, of Cottingham, yeoman 1
4181472 2088997 2088997 defendant Farrey or Farrer Christopher yeoman 670476 670476 Farrey or Farrer, Christopher, of Cottingham, yeoman 1
4213541 2100253 2100253 defendant Browne Henry yeoman 670476 670476 Browne, Henry, of Cottingham, yeoman 0
4215526 2100927 2100927 defendant Houghton Peter clerk 670476 670476 Houghton, Peter, of Cottingham, clerk 0
4216218 2101162 2101162 defendant Beard William blacksmith 670476 670476 Beard, William, of Cottingham, blacksmith 3
4222701 2103431 2103431 defendant Haughton Peter clerk 670476 670476 Haughton, Peter, of Cottingham, clerk 0
4222702 2103431 2103431 defendant Hope alias Bell Edward husbandman 670476 670476 Hope alias Bell, Edward, of Cottingham, husbandman 1
4265161 2117987 2117987 defendant Houghton Peter clerk 670476 670476 Houghton, Peter, of Cottingham, clerk 0
4265957 2118251 2118251 defendant Beard William blacksmith 670476 670476 Beard, William, of Cottingham, blacksmith 3
4272035 2120212 2120212 defendant Norwood William yeoman 670476 670476 Norwood, William, of Cottingham, yeoman 2
4284843 2124624 2124624 defendant Ferrer of Ferrey George yeoman 670476 670476 Ferrer of Ferrey, George, of Cottingham, yeoman 0
4308696 2133192 2133192 defendant Grene John esq 670476 670476 Grene, John, of Cottingham, or of Barmebie on Dune, esq 0
4315972 2135700 2135700 defendant Grene John esq 670476 670476 Grene, John, of Cottingham, or of Barneby, esq 0
4342672 2144709 2144709 defendant Smyth George yeoman 670476 670476 Smyth, George, of Cottingham, yeoman 0
4342673 2144709 2144709 defendant Awmond Thomas yeoman 670476 670476 Awmond, Thomas, of Cottingham, yeoman 1
4393699 2162495 2162495 defendant Smith George yeoman 670476 670476 Smith, George, of Cottingham, yeoman 0
4393700 2162495 2162495 defendant Awmond Thomas yeoman 670476 670476 Awmond, Thomas, of Cottingham, yeoman 1
4393708 2162498 2162498 defendant See Peter yeoman 670476 670476 See, Peter, of Cottingham, yeoman 0
4393709 2162498 2162498 defendant Almond Thomas yeoman 670476 670476 Almond, Thomas, of Cottingham, yeoman 1
4397995 2163907 2163907 defendant Conyers Richard gent 670476 670476 Conyers Richard, of Cottingham, gent 2
4764510 2284885 2284885 plaintiff Ruston John   670476 670476 Ruston, John, of Cottingham 2
5201021 2416054 2416054 defendant Alman John husbandman 670476 670476 Alman, John, of Cottingham, husbandman 4

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