names

42 rows where place_id = 596965

✎ 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
3626772 1903220 1903220 defendant Sympson John laborer 596965 596965 Sympson, John, of Whethamsted, laborer 0
3632460 1904968 1904968 defendant Sympson John laborer 596965 596965 Sympson, John, of Whethamsted, laborer 1
3633555 1905305 1905305 defendant Decon Andrew laborer 596965 596965 Decon, Andrew, of Whethamsted, laborer 0
3756635 1944057 1944057 defendant Russell John husbandman 596965 596965 Russell, John, of Whethamsted, husbandman 0
3758064 1944508 1944508 plaintiff Brokett John   596965 596965 Brokett John, of Whethamsted 2
3761016 1945448 1945448 defendant Samon Richard laborer 596965 596965 Samon, Richard, of Whethamsted, laborer 0
3761017 1945448 1945448 defendant Carpenter William yeoman 596965 596965 Carpenter, William, of Whethamsted, yeoman 1
3772461 1949075 1949075 defendant Halsey Joan widow 596965 596965 Halsey, Joan, of Whethamsted, widow 1
3821700 1964676 1964676 defendant Stevyns William yeoman 596965 596965 Stevyns, William, of Whethamsted, yeoman 1
3821701 1964676 1964676 defendant Archebould Edward shoemaker 596965 596965 Archebould, Edward, of Whethamsted, shoemaker 2
3836703 1969379 1969379 defendant Dunne Griffin   596965 596965 Dunne, Griffin, of Whethamsted, knight 0
3859553 1976684 1976684 defendant Carter Richard yeoman 596965 596965 Carter, Richard, of Whethamsted, yeoman 0
3859554 1976684 1976684 defendant Carter William yeoman 596965 596965 Carter, William, of Whethamsted, yeoman 1
3902491 1991064 1991064 defendant Sybley William husbandman 596965 596965 Sybley, William, of Whethamsted, husbandman 0
3921519 1997539 1997539 plaintiff Boteler John esq 596965 596965 Boteler, John, of Whethamsted, esq 2
3921526 1997540 1997540 plaintiff Boteler John esq 596965 596965 Boteler, John, of Whethamsted, esq 2
3921532 1997541 1997541 plaintiff Boteler John esq 596965 596965 Boteler, John, of Whethamsted, esq 2
3924719 1998582 1998582 defendant Bristowe Nicholas esq 596965 596965 Bristowe, Nicholas, of Whethamsted, esq 0
4213784 2100338 2100338 defendant Fyntch Richard husbandman 596965 596965 Fyntch, Richard, of Whethamsted, or of Hitchin, Herts, husbandman 1
4360945 2151087 2151087 defendant Fletcher Walter husbandman 596965 596965 Fletcher, Walter, of Whethamsted, husbandman 0
4412564 2168791 2168791 defendant Fletcher Walter yeoman 596965 596965 Fletcher, Walter, of Whethamsted, yeoman 2
4669545 2256180 2256180 defendant Ballard John smith 596965 596965 Ballard, John, of Whethamsted, smith 3
5106850 2388430 2388430 defendant Sewall William miller 596965 596965 Sewall, William, of Whethamsted, miller 3
5107502 2388624 2388624 defendant Landy or Laudy Thomas yeoman 596965 596965 Landy or Laudy, Thomas, of Whethamsted, yeoman 0
5107506 2388625 2388625 defendant Landy or Laudy Thomas yeoman 596965 596965 Landy or Laudy, Thomas, of Whethamsted, yeoman 0
5116586 2391282 2391282 defendant White Thomas gent 596965 596965 White, Thomas, of Whethamsted, gent 0
5121038 2392583 2392583 defendant Sawyer Thomas carpenter 596965 596965 Sawyer, Thomas, of Whethamsted, carpenter 0
5122355 2392967 2392967 defendant Sewall William miller 596965 596965 Sewall, William, of Whethamsted, miller 3
5349791 2460072 2460072 defendant Wurlych Richard gent 596965 596965 Wurlych, Richard, of Whethamsted, gent 0
5363772 2464322 2464322 defendant Bygge John, junior husbandman 596965 596965 Bygge, John, junior, of Whethamsted, husbandman 2
5429548 2483774 2483774 defendant Fulthorp John yeoman 596965 596965 Fulthorp, John, of Whethamsted, yeoman 0
5429570 2483781 2483781 defendant Fulthorp John yeoman 596965 596965 Fulthorp, John, of Whethamsted, yeoman 0
5433831 2485088 2485088 defendant Coldham John butcher 596965 596965 Coldham, John, of Whethamsted, butcher 4
5433837 2485089 2485089 defendant Coldham John butcher 596965 596965 Coldham, John, of Whethamsted, butcher 4
5440901 2487191 2487191 defendant Coldham John butcher 596965 596965 Coldham, John, of Whethamsted, butcher 3
5446528 2488849 2488849 defendant Fulthorp John yeoman 596965 596965 Fulthorp, John, of Whethamsted, yeoman 0
5446530 2488850 2488850 defendant Fulthorp John yeoman 596965 596965 Fulthorp, John, of Whethamsted, yeoman 0
5482555 2499724 2499724 defendant Bulle William chaplain 596965 596965 Bulle, William, of Whethamsted, chaplain 0
5482556 2499724 2499724 defendant Fulthorp John yeoman 596965 596965 Fulthorp, John, of Whethamsted, yeoman 1
5499131 2504684 2504684 defendant Sybyly William husbandman 596965 596965 Sybyly, William, of Whethamsted, husbandman 0
5598088 2534299 2534299 defendant Sybbeley John maltman 596965 596965 Sybbeley, John, of Whethamsted, maltman 0
5598091 2534300 2534300 defendant Sybbeley John maltman 596965 596965 Sybbeley, John, of Whethamsted, maltman 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);