names

29 rows where place_id = 826054

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3807573 1960276 1960276 defendant Fenne Richard   826054 826054 Fenne, Richard, of Berton juxta Smalbergh, worsted weaver 0
4948152 2341395 2341395 defendant Magges William husbandman 826054 826054 together with Magges, William, of Berton juxta Smalbergh, husbandman 7
4948153 2341395 2341395 defendant atte Wode Richard husbandman 826054 826054 atte Wode, Richard, of Berton juxta Smalbergh, husbandman 8
4948156 2341396 2341396 defendant Gilberd John laborer 826054 826054 Gilberd, John, of Berton juxta Smalbergh, laborer 1
4948157 2341396 2341396 defendant Magges William husbandman 826054 826054 Magges, William, of Berton juxta Smalbergh, husbandman 2
4948158 2341396 2341396 defendant atte Wode Richard husbandman 826054 826054 atte Wode, Richard, of Berton juxta Smalbergh, husbandman 3
4954960 2343442 2343442 defendant Hetirsete William husbandman 826054 826054 Hetirsete, William, of Berton juxta Smalbergh, husbandman 0
4954961 2343442 2343442 defendant Mors Henry husbandman 826054 826054 Mors, Henry, of Berton juxta Smalbergh, husbandman 1
5056214 2373435 2373435 defendant Bertram Thomas yeoman 826054 826054 Bertram, Thomas, of Berton juxta Smalbergh, yeoman 0
5056215 2373435 2373435 defendant Bertram Andrew yeoman 826054 826054 together with Bertram, Andrew, of Berton juxta Smalbergh, yeoman 1
5056216 2373435 2373435 defendant Bertram Henry yeoman 826054 826054 Bertram, Henry, of Berton juxta Smalbergh, yeoman 2
5056217 2373435 2373435 defendant Amys Thomas yeoman 826054 826054 Amys, Thomas, of Berton juxta Smalbergh, yeoman 3
5056218 2373435 2373435 defendant Stucle Robert husbandman 826054 826054 Stucle, Robert, of Berton juxta Smalbergh, husbandman 4
5085551 2382167 2382167 defendant Scrape Robert butcher or husbandman 826054 826054 Scrape, Robert, of Berton juxta Smalbergh, butcher or husbandman 0
5095244 2385026 2385026 defendant Hawes Thomas gent 826054 826054 Hawes, Thomas, of Berton juxta Smalbergh, gent 0
5226234 2423335 2423335 defendant Wilkyns Thomas   826054 826054 Wilkyns, Thomas, of Berton juxta Smalbergh, worsted weaver 2
5248991 2429828 2429828 defendant Stukele Robert husbandman 826054 826054 Stukele, Robert, of Berton juxta Smalbergh, husbandman 2
5265391 2434932 2434932 defendant Idewyn John clerk 826054 826054 Idewyn, John, of Berton juxta Smalbergh, clerk 0
5278640 2438860 2438860 defendant Iwyns John husbandman 826054 826054 Iwyns, John, of Berton juxta Smalbergh, husbandman 21
5332531 2454794 2454794 defendant Iwyns John husbandman 826054 826054 Iwyns, John, of Berton juxta Smalbergh, husbandman 0
5478871 2498698 2498698 defendant Crede Henry husbandman 826054 826054 Crede, Henry, of Berton juxta Smalbergh, husbandman 5
5534707 2515398 2515398 defendant Amys Christopher yeoman 826054 826054 Amys, Christopher, of Berton juxta Smalbergh, yeoman 0
5534708 2515398 2515398 defendant Gylberd Thomas husbandman 826054 826054 Gylberd, Thomas, of Berton juxta Smalbergh, husbandman 1
5536850 2516013 2516013 defendant Cooke William esq 826054 826054 Cooke, William, of Berton juxta Smalbergh, esq 0
5536853 2516014 2516014 defendant Cooke William esq 826054 826054 Cooke, William, of Berton juxta Smalbergh, esq 0
5539960 2516982 2516982 defendant Humfrey Roger clerk 826054 826054 Humfrey, Roger, of Berton juxta Smalbergh, clerk 0
5585620 2530572 2530572 defendant Coke William esq 826054 826054 Coke, William, of Berton juxta Smalbergh, esq 0
5592823 2532756 2532756 defendant Joye Robert carpenter 826054 826054 Joye, Robert, of Berton juxta Smalbergh, carpenter 0
5592824 2532756 2532756 defendant Corpe William   826054 826054 Corpe, William, of Berton juxta Smalbergh, worsted weaver 1

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