names

22 rows where place_id = 657694

✎ 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
3945380 2005469 2005469 defendant Yarner John baker 657694 657694 Yarner, John, of Wellingborowe, baker 2
4193315 2093229 2093229 defendant Eston Robert husbandman 657694 657694 Eston, Robert, of Wellingborowe, husbandman 0
4198859 2095157 2095157 defendant Henchman alias Crosborowe Thomas, junior chapman 657694 657694 Henchman alias Crosborowe, Thomas, junior, of Wellingborowe, chapman 1
4207772 2098281 2098281 defendant Robert John   657694 657694 Robert, John, of Wellingborowe, rough mason 0
4255061 2114687 2114687 defendant Bowyer Thomas vintner 657694 657694 Bowyer, Thomas, of Wellingborowe, vintner 1
4267610 2118800 2118800 defendant Bowyer Thomas vintner 657694 657694 Bowyer, Thomas, of Wellingborowe, vintner 1
4278645 2122463 2122463 defendant Bawe Robert husbandman 657694 657694 Bawe, Robert, of Wellingborowe, husbandman 0
4319905 2137068 2137068 defendant Harryson Peter weaver 657694 657694 Harryson, Peter, of Wellingborowe, weaver 0
4325548 2138920 2138920 defendant Tompson Christopher chapman 657694 657694 Tompson, Christopher, of Wellingborowe, chapman 0
4325549 2138920 2138920 defendant Hackney Robert yeoman 657694 657694 Hackney, Robert, of Wellingborowe, yeoman 1
4325550 2138920 2138920 defendant Hensman William husbandman 657694 657694 Hensman, William, of Wellingborowe, husbandman 2
4328520 2139855 2139855 defendant Yarner Amote husbandman 657694 657694 Yarner, Amote, of Wellingborowe, husbandman 0
4328521 2139855 2139855 defendant Lunde John husbandman 657694 657694 Lunde, John, of Wellingborowe, husbandman 1
4329126 2140054 2140054 defendant Weston John   657694 657694 Weston, John, of Wellingborowe yeoman 2
4344734 2145439 2145439 defendant Chaldener Richard (legal representative) 657694 657694 Chaldener, Richard, of Wellingborowe, yeoman, executrix of 0
4344735 2145439 2145439 defendant Chauldener Anne widow 657694 657694 Chauldener, Anne, of Wellingborowe, widow 1
4346062 2145878 2145878 defendant Blunston Robert yeoman 657694 657694 Blunston, Robert, of Wellingborowe, yeoman 1
4349108 2146948 2146948 defendant Robynson Thomas yeoman 657694 657694 Robynson, Thomas, of Wellingborowe, yeoman 0
4350700 2147497 2147497 defendant Cull or Bull Francis glasier 657694 657694 Cull or Bull, Francis, of Wellingborowe, glasier 2
4352357 2148061 2148061 defendant Ball James draper 657694 657694 Ball, James, of Wellingborowe, draper 0
4386583 2160188 2160188 defendant Cornyshe Framcis husbandman 657694 657694 Cornyshe, Framcis, of Wellingborowe, husbandman 0
4412767 2168865 2168865 defendant Jakeson or Jacson George draper 657694 657694 Jakeson or Jacson, George, of Wellingborowe, or of Heigham Ferrers, draper 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);