names

22 rows where place_id = 689644

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4081326 2053632 2053632 defendant Chester George yeoman 689644 689644 Chester, George, of Tattershall, yeoman 0
4119326 2067207 2067207 defendant Sympson Henry yeoman 689644 689644 Sympson, Henry, of Tattershall, yeoman 0
4148436 2077583 2077583 defendant Spaldynge William yeoman 689644 689644 Spaldynge, William, of Tattershall, yeoman 0
4163374 2082716 2082716 defendant Burton John yeoman 689644 689644 Burton, John, of Tattershall, yeoman 1
4207735 2098268 2098268 defendant Simpson Henry yeoman 689644 689644 Simpson, Henry, of Tattershall, yeoman 0
4215906 2101062 2101062 defendant Sherborne Robert yeoman 689644 689644 Sherborne, Robert, of Tattershall, or of Copthall, Essex, yeoman 1
4215907 2101062 2101062 defendant Ryse William tailor 689644 689644 Ryse, William, of Tattershall, or of Westminster, tailor 2
4215908 2101062 2101062 defendant Graye William shoemaker 689644 689644 Graye, William, of Tattershall, or of Westminster, shoemaker 3
4242992 2110652 2110652 defendant Fairebanck Edward clothier 689644 689644 Fairebanck, Edward, of Tattershall, yeoman, clothier 1
4245147 2111365 2111365 defendant Fairbankes Edward clothier 689644 689644 Fairbankes, Edward, of Tattershall, clothier 0
4245149 2111365 2111365 defendant Pantrie Alice widow 689644 689644 Pantrie, Alice, of Tattershall, widow 2
4245301 2111410 2111410 defendant Fayrbanke Edward clothier 689644 689644 Fayrbanke, Edward, of Tattershall, clothier 0
4278311 2122352 2122352 defendant Allyn William brewer 689644 689644 Allyn, William, of Tattershall, brewer 0
4278382 2122375 2122375 defendant Kirke Leo or Lionel yeoman 689644 689644 Kirke, Leo or Lionel, of Tattershall, yeoman 1
4291299 2126960 2126960 defendant Kyrke Leo or Lionel gent 689644 689644 Kyrke, Leo or Lionel, of Tattershall, gent 0
4291303 2126962 2126962 defendant Empringham Robert gent 689644 689644 Empringham, Robert, of Tattershall, gent 0
4299022 2129745 2129745 defendant Dawson William fishmonger 689644 689644 Dawson, William, of Tattershall, fishmonger 0
4336634 2142539 2142539 defendant Hodgson John baker 689644 689644 Hodgson, John, of Tattershall, baker 2
4364819 2152470 2152470 defendant Fairbanck Peter laborer 689644 689644 Fairbanck, Peter, of Tattershall, laborer 0
4364820 2152470 2152470 defendant Hudson Roland laborer 689644 689644 Hudson, Roland, of Tattershall, laborer 1
5275906 2438024 2438024 defendant Gregory John   689644 689644 Gregory, John, of Tattershall, warden of Holy Trinity College 0
5400685 2475259 2475259 plaintiff Gigur or Gygor John   689644 689644 Gigur or Gygor, John, of Tattershall, warden of the College of the Holy Trinity 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);