names

33 rows where place_id = 585994

✎ 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
3587650 1863782 1863782 defendant Burgh Thomas gent 585994 585994 Burgh, Thomas, of Kyrton, Lincs, gent 0
3594093 1865794 1865794 defendant Kyme or Kynne Philip gent 585994 585994 Kyme or Kynne, Philip, of Kyrton, Lincs, gent 2
3601266 1868060 1868060 defendant Burgh Thomas gent 585994 585994 Burgh, Thomas, of Kyrton, Lincs, gent 0
3736845 1937779 1937779 defendant Stevenson Robert husbandman 585994 585994 Stevenson, Robert, of Kyrton, Lincs, husbandman 0
3749015 1941623 1941623 defendant Cony William, junior yeoman 585994 585994 Cony, William, junior, of Kyrton, Lincs, yeoman 0
3890131 1986934 1986934 defendant Ireby John gent 585994 585994 Ireby, John, of Kyrton, Lincs, gent 0
3891098 1987289 1987289 defendant Meyres Anthony gent 585994 585994 Meyres, Anthony, of Kyrton, Lincs, gent 0
3891426 1987400 1987400 defendant Mason Thomas smith 585994 585994 Mason, Thomas, of Kyrton, Lincs, smith 0
3901381 1990683 1990683 defendant Irby John gent 585994 585994 Irby, John, of Kyrton, Lincs, gent 0
3904291 1991682 1991682 defendant Irby John gent 585994 585994 Irby, John, of Kyrton, Lincs, gent 0
3912044 1994352 1994352 defendant Brombe Thomas yeoman 585994 585994 Brombe, Thomas, of Kyrton, Lincs, yeoman 0
3912045 1994352 1994352 defendant Step James yeoman 585994 585994 Step, James, of Kyrton, Lincs, yeoman 1
3923508 1998170 1998170 defendant Irby John gent 585994 585994 Irby, John, of Kyrton, Lincs, gent 0
3926146 1999065 1999065 defendant Irby John gent 585994 585994 Irby, John, of Kyrton, Lincs, gent 0
3926373 1999145 1999145 defendant Steper James yeoman 585994 585994 Steper, James, of Kyrton, Lincs, yeoman 0
3962884 2011611 2011611 defendant Wentworth William gent 585994 585994 Wentworth, William, of Kyrton, Lincs, gent 0
4068912 2049171 2049171 defendant Browne Robert chapman 585994 585994 Browne, Robert, of Kyrton, Lincs, chapman 0
4139662 2074547 2074547 defendant Thewe Thomas yeoman 585994 585994 Thewe, Thomas, of Kyrton, Lincs, yeoman 0
4159278 2081315 2081315 defendant Steper William yeoman 585994 585994 Steper, William, of Kyrton, Lincs, yeoman 0
4757319 2282662 2282662 defendant Kyrketon John husbandman 585994 585994 Kyrketon, John, of Kyrton, Lincs, husbandman 1
4827935 2304792 2304792 defendant Lytylbury Humphrey gent 585994 585994 Lytylbury, Humphrey, of Kyrton, Lincs, gent 2
4842201 2309094 2309094 defendant Lytylbury Humphrey gent 585994 585994 Lytylbury, Humphrey, of Kyrton, Lincs, gent 2
4991068 2354218 2354218 defendant Lyttelbury Robert gent 585994 585994 Lyttelbury, Robert, of Kyrton, Lincs, gent 1
5260442 2433399 2433399 defendant Lytelbury Robert   585994 585994 Lytelbury, Robert, of Kyrton, Lincs, knight 0
5286475 2441048 2441048 defendant Kyme Philip yeoman 585994 585994 Kyme, Philip, of Kyrton, Lincs, yeoman 0
5286477 2441049 2441049 defendant Lyme Philip yeoman 585994 585994 Lyme, Philip, of Kyrton, Lincs, yeoman 0
5336161 2455897 2455897 plaintiff Hamelyn William yeoman 585994 585994 Hamelyn, William, of Kyrton, Lincs, yeoman 0
5337137 2456183 2456183 defendant A Mers Thomas esq 585994 585994 A Mers, Thomas, of Kyrton, Lincs, esq 2
5516615 2510024 2510024 defendant Corbrigge Robert mercer 585994 585994 Corbrigge, Robert, of Kyrton, Lincs, mercer 1
5537748 2516293 2516293 defendant Murdok John gent 585994 585994 Murdok, John, of Kyrton, Lincs, gent 0
5550164 2520081 2520081 defendant Burgh Thomas gent 585994 585994 Burgh, Thomas, of Kyrton, Lincs, gent 0
5560296 2522973 2522973 defendant Robert Simon husbandman 585994 585994 Robert, Simon, of Kyrton, Lincs, husbandman 0
5560301 2522974 2522974 defendant Robert Simon husbandman 585994 585994 Robert, Simon, of Kyrton, Lincs, husbandman 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);