names

34 rows where place_id = 591980

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606187 1869605 1869605 defendant Smyth William husbandman 591980 591980 Smyth, William, of Calcote, husbandman 2
3683537 1920983 1920983 defendant Sly Robert husbandman 591980 591980 Sly, Robert, of Calcote, husbandman 2
3685557 1921632 1921632 defendant Archepole Roger carpenter 591980 591980 Archepole, Roger, of Calcote, carpenter 0
3706102 1928202 1928202 defendant Rawlot Robert husbandman 591980 591980 Rawlot, Robert, of Calcote, husbandman 0
3865959 1978846 1978846 defendant Hygges Thomas laborer 591980 591980 Hygges, Thomas, of Calcote, laborer 1
3884746 1985172 1985172 defendant Howson Thomas, junior husbandman 591980 591980 Howson, Thomas, junior, of Calcote, husbandman 1
3924672 1998566 1998566 defendant Underyll Christine widow 591980 591980 Underyll, Christine, of Calcote, widow 1
4381033 2158332 2158332 defendant Purefey or Puresey Francis gent 591980 591980 Purefey or Puresey, Francis, of Calcote, gent 3
4546781 2214919 2214919 defendant Morell William   591980 591980 Morell, William, of Calcote 0
4621900 2237830 2237830 defendant Lombe John   591980 591980 Lombe, John, of Calcote 3
4671101 2256626 2256626 defendant Toures Robert husbandman 591980 591980 Toures, Robert, of Calcote, husbandman 0
4671102 2256626 2256626 defendant Mason Thomas husbandman 591980 591980 Mason, Thomas, of Calcote, husbandman 1
4693576 2263493 2263493 defendant Page William laborer 591980 591980 Page, William, of Calcote, laborer 0
4746666 2279516 2279516 defendant Calcote Thomas gent 591980 591980 Calcote, Thomas, of Calcote, gent 0
4772570 2287389 2287389 defendant Palmer John yeoman 591980 591980 Palmer, John, of Calcote, yeoman 0
4795729 2294814 2294814 defendant Maweclerk Thomas husbandman 591980 591980 Maweclerk, Thomas, of Calcote, husbandman 2
4850654 2311662 2311662 defendant Falewell John husbandman 591980 591980 Falewell, John, of Calcote, husbandman 0
4991469 2354333 2354333 defendant Palmer Robert husbandman 591980 591980 Palmer, Robert, of Calcote, husbandman 0
5033940 2366799 2366799 defendant Rycard William husbandman 591980 591980 Rycard, William, of Calcote, husbandman 2
5254671 2431581 2431581 defendant Wright John husbandman 591980 591980 Wright, John, of Calcote, husbandman 1
5255064 2431698 2431698 defendant Bakewell William miller 591980 591980 Bakewell, William, of Calcote, miller 1
5271581 2436784 2436784 defendant Watkyns Nicholas husbandman 591980 591980 Watkyns, Nicholas, of Calcote, husbandman 2
5297109 2444152 2444152 plaintiff Wyngore John (legal representative) 591980 591980 Wyngore, John, of Calcote, administrator of 0
5297111 2444152 2444152 defendant Passewater John clerk 591980 591980 Passewater, John, of Calcote, clerk 0
5308567 2447595 2447595 defendant Found John carpenter 591980 591980 Found, John, of Calcote, carpenter 3
5326023 2452876 2452876 defendant Benet Stephen husbandman 591980 591980 Benet, Stephen, of Calcote, husbandman 0
5326024 2452876 2452876 defendant Benet William husbandman 591980 591980 Benet, William, of Calcote, husbandman 1
5326025 2452876 2452876 defendant Palmer William husbandman 591980 591980 Palmer, William, of Calcote, husbandman 2
5445327 2488499 2488499 defendant Neubone John husbandman 591980 591980 Neubone, John, of Calcote, husbandman 0
5463062 2493866 2493866 defendant Scales John yeoman 591980 591980 Scales, John, of Calcote, yeoman 0
5481816 2499494 2499494 defendant Scales John yeoman 591980 591980 Scales, John, of Calcote, yeoman 2
5540285 2517090 2517090 plaintiff Haweke Robert   591980 591980 Haweke, Robert, of Calcote 0
5545154 2518585 2518585 defendant Rowse Hugh husbandman 591980 591980 Rowse, Hugh, of Calcote, husbandman 2
5579847 2528777 2528777 defendant Calcote Robert yeoman 591980 591980 Calcote, Robert, of Calcote, yeoman 2

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