names

36 rows where place_id = 610372

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3683203 1920864 1920864 defendant Craas John gent 610372 610372 Craas, John, of Frome Selwode, Soms, gent 0
3699622 1926108 1926108 defendant George John tucker 610372 610372 George, John, of Frome Selwode, Soms, tucker 0
3703435 1927347 1927347 defendant Style Henry yeoman 610372 610372 Style, Henry, of Frome Selwode, Soms, yeoman 5
3754019 1943208 1943208 defendant Champeys Anthony gent 610372 610372 Champeys, Anthony, of Frome Selwode, Soms, gent 0
3771281 1948710 1948710 defendant Champneys Anthony gent 610372 610372 Champneys, Anthony, of Frome Selwode, Soms, gent 0
3854576 1975075 1975075 defendant Leversage Robert gent 610372 610372 Leversage, Robert, of Frome Selwode, Soms, gent 2
3854581 1975076 1975076 defendant Leversage Robert gent 610372 610372 Leversage, Robert, of Frome Selwode, Soms, gent 2
3989982 2021171 2021171 defendant Blackborowe Peter clothier 610372 610372 Blackborowe, Peter, of Frome Selwode, Soms, clothier 0
4019526 2031711 2031711 defendant Pyke Edward   610372 610372 Pyke, Edward, of Frome Selwode, Soms 0
4199402 2095340 2095340 defendant Chubbe William clerk 610372 610372 Chubbe, William, of Frome Selwode, Soms, clerk 2
4687570 2261697 2261697 defendant Rydon Thomas chapman 610372 610372 Rydon, Thomas, of Frome Selwode, Soms, chapman 3
4826409 2304296 2304296 defendant Anglessey John dyer 610372 610372 Anglessey, John, of Frome Selwode, Soms, dyer 1
4911886 2330221 2330221 defendant Baker John baker 610372 610372 Baker, John, of Frome Selwode, Soms, baker 0
4930869 2336056 2336056 defendant Raulyns John tailor 610372 610372 Raulyns, John, of Frome Selwode, Soms, tailor 1
4941272 2339292 2339292 defendant Grove Thomas draper 610372 610372 Grove, Thomas, of Frome Selwode, Soms, draper 0
4950930 2342256 2342256 defendant Zebote or Sebote John butcher 610372 610372 Zebote or Sebote, John, of Frome Selwode, Soms, butcher 0
4965217 2346518 2346518 defendant Brownewyne John husbandman 610372 610372 Brownewyne, John, of Frome Selwode, Soms, husbandman 4
5041797 2369147 2369147 defendant Sawer John weaver 610372 610372 Sawer, John, of Frome Selwode, Soms, weaver 3
5045163 2370183 2370183 defendant Fysshe John clothman 610372 610372 Fysshe, John, of Frome Selwode, Soms, clothman 1
5051651 2372111 2372111 defendant Napper John, junior chapman 610372 610372 Napper, John, junior, of Frome Selwode, Soms, chapman 2
5051658 2372112 2372112 defendant Napper John, junior chapman 610372 610372 Napper, John, junior, of Frome Selwode, Soms, chapman 2
5121353 2392677 2392677 defendant Baker John clothmaker 610372 610372 Baker, John, of Frome Selwode, Soms, clothmaker 2
5142144 2398823 2398823 defendant Nicholas alias Osteler Thomas clothman 610372 610372 Nicholas alias Osteler, Thomas, of Frome Selwode, Soms, clothman 0
5151728 2401666 2401666 defendant Nicoll Thomas   610372 610372 Nicoll, Thomas, of Frome Selwode, Soms, cloth maker 0
5163297 2405000 2405000 defendant Nicholas Thomas   610372 610372 Nicholas, Thomas, of Frome Selwode, Soms, cloth man 0
5237649 2426592 2426592 defendant Stokton John clothmaker 610372 610372 Stokton, John, of Frome Selwode, Soms, clothmaker 0
5242101 2427890 2427890 defendant Stokton John clothier 610372 610372 Stokton, John, of Frome Selwode, Soms, clothier 0
5242124 2427898 2427898 defendant Stokton John clothmaker 610372 610372 Stokton, John, of Frome Selwode, Soms, clothmaker 0
5249420 2429943 2429943 defendant Kaymysham John glover 610372 610372 Kaymysham, John, of Frome Selwode, Soms, glover 0
5388002 2471624 2471624 defendant Osbern Margery widow 610372 610372 Osbern, Margery, of Frome Selwode, Soms, widow 8
5395264 2473719 2473719 defendant Wyncote Robert yeoman 610372 610372 Wyncote, Robert, of Frome Selwode, Soms, yeoman 1
5478193 2498505 2498505 defendant Wyncot Robert draper 610372 610372 (Wyncot, Robert, of Frome Selwode, Soms, draper 1
5522972 2512013 2512013 defendant Wattys John yeoman 610372 610372 Wattys, John, of Frome Selwode, Soms, yeoman 1
5580432 2528965 2528965 defendant Ricardys William (legal representative) 610372 610372 Ricardys, William, of Frome Selwode, Soms, clothier, executrix of 0
5591194 2532221 2532221 defendant Eystas Richard butcher 610372 610372 Eystas, Richard, of Frome Selwode, Soms, butcher 4
5591201 2532222 2532222 defendant Eustas otr Gustas Richard butcher 610372 610372 Eustas otr Gustas, Richard, of Frome Selwode, Soms, butcher 5

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