names

24 rows where place_id = 601099

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643846 1908504 1908504 defendant Fermehalgh Richard yeoman 601099 601099 Fermehalgh, Richard, of Heyton, yeoman 0
3643847 1908504 1908504 defendant Fermehalgh Ellen widow 601099 601099 Fermehalgh, Ellen, of Heyton, widow 1
3684095 1921161 1921161 defendant Hyggynbotham John yeoman 601099 601099 Hyggynbotham, John, of Heyton, yeoman 0
3684096 1921161 1921161 defendant Fernehalgh Richard yeoman 601099 601099 Fernehalgh, Richard, of Heyton, yeoman 1
3684098 1921161 1921161 defendant Clous Katherine widow 601099 601099 Clous, Katherine, of Heyton, widow 3
3719585 1932390 1932390 defendant North John yeoman 601099 601099 North, John, of Heyton, yeoman 1
3887817 1986178 1986178 defendant Peke Thomas, junior husbandman 601099 601099 Peke, Thomas, junior, of Heyton, husbandman 0
3894586 1988398 1988398 defendant Towers William gent 601099 601099 Towers, William, of Heyton, gent 3
4102973 2061353 2061353 defendant Mydgeley Robert yeoman 601099 601099 Mydgeley, Robert, of Heyton, yeoman 1
4102974 2061353 2061353 defendant Mydgeley Edward clothier 601099 601099 Mydgeley, Edward, of Heyton, clothier 2
4103424 2061509 2061509 defendant Sheperd David husbandman 601099 601099 Sheperd, David, of Heyton, husbandman 0
4365760 2152791 2152791 defendant Joyner Peter yeoman 601099 601099 Joyner, Peter, of Heyton, yeoman 2
4391933 2161928 2161928 defendant Stempe James, senior gent 601099 601099 Stempe, James, senior, of Heyton, gent 0
4515617 2205308 2205308 plaintiff Clebury James   601099 601099 Clebury, James, of Heyton 0
4548589 2215499 2215499 plaintiff Cleobury James   601099 601099 Cleobury, James, of Heyton 0
4922674 2333504 2333504 defendant Nonyley Roger yeoman 601099 601099 Nonyley, Roger, of Heyton, yeoman 0
4941682 2339420 2339420 defendant Noneley Roger yeoman 601099 601099 Noneley, Roger, of Heyton, yeoman 0
4947891 2341323 2341323 defendant Foueley or Foneley Roger yeoman 601099 601099 Foueley or Foneley, Roger, of Heyton, yeoman 0
5104041 2387606 2387606 defendant Novele or Nonele Robert yeoman 601099 601099 Novele or Nonele, Robert, of Heyton, yeoman 1
5185676 2411559 2411559 defendant Taillour John tailor 601099 601099 Taillour, John, of Heyton, tailor 5
5204878 2417178 2417178 defendant Taillour John tailor 601099 601099 Taillour, John, of Heyton, tailor 5
5566523 2524801 2524801 defendant Lucas Richard mercer 601099 601099 Lucas, Richard, of Heyton, mercer 0
5570817 2526025 2526025 defendant Hemyngwey Thomas laborer 601099 601099 Hemyngwey, Thomas, of Heyton, laborer 0
5631477 2553854 2553854 plaintiff Smyth Roger   601099 601099 Smyth, Roger, of Heyton 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);