names

31 rows where place_id = 632898

✎ 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
3809467 1960843 1960843 defendant Wellys Thomas husbandman 632898 632898 Wellys, Thomas, of Saxlingham, husbandman 0
3972808 2015061 2015061 defendant Fasset Thomas husbandman 632898 632898 Fasset, Thomas, of Saxlingham, husbandman 2
3986709 2019986 2019986 defendant Colman Thomas shoemaker 632898 632898 Colman, Thomas, of Saxlingham, shoemaker 2
3991338 2021656 2021656 plaintiff Brampson Francis husbandman 632898 632898 Brampson, Francis, of Saxlingham, or of Yarmouth, husbandman 0
3999815 2024697 2024697 plaintiff Gasington or Easington William gent 632898 632898 Gasington or Easington, William, of Saxlingham, gent 0
4095414 2058683 2058683 defendant Spence James yeoman 632898 632898 Spence, James, of Saxlingham, yeoman 0
4111451 2064343 2064343 defendant Dade Elias husbandman 632898 632898 Dade, Elias, of Saxlingham, husbandman 1
4176698 2087320 2087320 defendant Huson William husbandman 632898 632898 Huson, William, of Saxlingham, husbandman 0
4211992 2099743 2099743 defendant Looze or Love Adam   632898 632898 Looze or Love, Adam, of Saxlingham, mason 0
4211993 2099743 2099743 defendant Randoll John laborer 632898 632898 Randoll, John, of Saxlingham, laborer 1
4211994 2099743 2099743 defendant Lesse Bartholomew weaver 632898 632898 Lesse, Bartholomew, of Saxlingham, weaver 2
4279664 2122805 2122805 defendant Skete Thomas husbandman 632898 632898 Skete, Thomas, of Saxlingham, husbandman 1
4284858 2124631 2124631 defendant Heydon Christopher esq 632898 632898 Heydon, Christopher, of Saxlingham, esq 0
4285223 2124765 2124765 defendant Herne William yeoman 632898 632898 Herne, William, of Saxlingham, yeoman 0
4289503 2126306 2126306 defendant Davyson John knacker 632898 632898 Davyson, John, of Saxlingham, knacker 0
4290630 2126706 2126706 defendant Bett Daniel carpenter 632898 632898 Bett, Daniel, of Saxlingham, carpenter 1
4290838 2126779 2126779 defendant Goodwyn Brachiel tailor 632898 632898 Goodwyn, Brachiel, of Saxlingham, tailor 2
4334532 2141822 2141822 defendant Jermyn Barnarde husbandman 632898 632898 Jermyn, Barnarde, of Saxlingham, husbandman 2
4334694 2141871 2141871 defendant Cheverey Robert yeoman 632898 632898 Cheverey, Robert, of Saxlingham, yeoman 3
4351297 2147704 2147704 defendant Tuttell Thomas husbandman 632898 632898 Tuttell, Thomas, of Saxlingham, husbandman 0
4355874 2149273 2149273 defendant Fenne William husbandman 632898 632898 Fenne, William, of Saxlingham, husbandman 1
4386934 2160293 2160293 defendant Holmes Alexander husbandman 632898 632898 Holmes, Alexander, of Saxlingham, husbandman 0
4386952 2160296 2160296 defendant Stevenson John husbandman 632898 632898 Stevenson, John, of Saxlingham, husbandman 0
4386953 2160296 2160296 defendant Stevenson Alice spinster 632898 632898 Stevenson, Alice, of Saxlingham, spinster 1
4386954 2160296 2160296 defendant Stevenson Elizabeth spinster 632898 632898 Stevenson, Elizabeth, of Saxlingham, spinster 2
4395805 2163180 2163180 defendant Randall John yeoman 632898 632898 Randall, John, of Saxlingham, yeoman 1
4395806 2163180 2163180 defendant Chambers Thomas yeoman 632898 632898 Chambers, Thomas, of Saxlingham, yeoman 2
4407367 2167025 2167025 defendant Bett Daniel yeoman 632898 632898 Bett, Daniel, of Saxlingham, yeoman 3
4923916 2333919 2333919 defendant Baxstere John yeoman 632898 632898 Baxstere, John, of Saxlingham, yeoman 4
4923918 2333919 2333919 defendant Ballys John yeoman 632898 632898 Ballys, John, of Saxlingham, yeoman 6
5176299 2408757 2408757 defendant Totyll Richard   632898 632898 Totyll, Richard, of Saxlingham husbandman 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);