names

39 rows where place_id = 675473

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4018812 2031460 2031460 defendant Fletcher John husbandman 675473 675473 Fletcher, John, of Chipping Norton, husbandman 0
4018813 2031460 2031460 defendant Turner Richard carpenter 675473 675473 Turner, Richard, of Chipping Norton, carpenter 1
4069864 2049506 2049506 defendant Knowle John   675473 675473 Knowle, John, of Chipping Norton, or of Old Kington, innholder, his son 1
4226182 2104630 2104630 defendant Willott John draper 675473 675473 Willott, John, of Chipping Norton, draper 1
4281198 2123332 2123332 defendant Mesheborne Richard glover 675473 675473 Mesheborne, Richard, of Chipping Norton, glover 0
4283847 2124262 2124262 defendant Herne John chapman 675473 675473 Herne, John, of Chipping Norton, chapman 2
4302130 2130869 2130869 defendant Trowte James shoemaker 675473 675473 Trowte, James, of Chipping Norton, shoemaker 0
4308116 2132984 2132984 defendant Meshborn Richard glover 675473 675473 Meshborn, Richard, of Chipping Norton, glover 1
4370073 2154353 2154353 defendant Chadwell Edward   675473 675473 Chadwell, Edward, of Chipping Norton, Oxon gent 0
4372084 2155081 2155081 defendant Chadwell Edward   675473 675473 Chadwell, Edward, of Chipping Norton, Oxon gent 0
4376211 2156557 2156557 defendant Gorwey Edward innholder 675473 675473 Gorwey, Edward, of Chipping Norton, innholder 2
4418361 2170622 2170622 defendant Bradeford John de   675473 675473 Bradeford, John de, of Chipping Norton 0
4535580 2211405 2211405 plaintiff Smyth John   675473 675473 Smyth, John, of Chipping Norton 0
4542814 2213643 2213643 defendant Stokes John   675473 675473 Stokes, John, of Chipping Norton 0
4548083 2215342 2215342 plaintiff Chapman John   675473 675473 Chapman, John, of Chipping Norton 0
4555384 2217619 2217619 plaintiff Hendy Thomas (legal representative) 675473 675473 Hendy, Thomas, of Chipping Norton, executors of 0
4555386 2217619 2217619 plaintiff Yonge John   675473 675473 Yonge, John, of Chipping Norton 2
4557296 2218218 2218218 defendant Stok John   675473 675473 Stok, John, of Chipping Norton 1
4570088 2222219 2222219 defendant Whale Thomas   675473 675473 Whale, Thomas, of Chipping Norton 0
4587951 2227629 2227629 defendant Stokes John   675473 675473 Stokes, John, of Chipping Norton 0
4692494 2263169 2263169 plaintiff Thomas William   675473 675473 Thomas, William, of Chipping Norton 2
4718012 2270974 2270974 plaintiff Thommes William   675473 675473 Thommes, William, of Chipping Norton 2
4730816 2274838 2274838 defendant Skynner John skinner 675473 675473 Skynner, John, of Chipping Norton, skinner 0
4761572 2283963 2283963 defendant Chapman John yeoman 675473 675473 Chapman, John, of Chipping Norton, yeoman 0
4767808 2285905 2285905 plaintiff Melbourne John   675473 675473 Melbourne, John, of Chipping Norton 0
4837829 2307763 2307763 defendant Cokkes Roger   675473 675473 Cokkes, Roger, of Chipping Norton, bailiff 2
4996400 2355781 2355781 defendant Reyhold Robert woolman 675473 675473 Reyhold, Robert, of Chipping Norton, woolman 0
4998181 2356324 2356324 defendant Knyght William husbandman 675473 675473 Knyght, William, of Chipping Norton, husbandman 0
5141795 2398716 2398716 defendant Smyth Thomas   675473 675473 Smyth, Thomas, of Chipping Norton, Gloucs smith 0
5164405 2405322 2405322 plaintiff Yonge Isabel widow 675473 675473 Yonge, Isabel, of Chipping Norton, widow 0
5164411 2405323 2405323 plaintiff Gerveys Thomas   675473 675473 Gerveys, Thomas, of Chipping Norton 1
5180469 2410032 2410032 defendant Edward Richard butcher 675473 675473 Edward, Richard, of Chipping Norton, butcher 0
5196462 2414717 2414717 plaintiff Smyth Elizabeth of Chipping Norton 675473 675473 Elizabeth, his wife, of Chipping Norton 1
5197165 2414910 2414910 defendant Granger John weaver 675473 675473 Granger, John, of Chipping Norton, weaver 0
5197169 2414911 2414911 defendant Granger john weaver 675473 675473 Granger, john, of Chipping Norton, weaver 0
5202431 2416475 2416475 defendant Edward Richard butcher 675473 675473 Edward, Richard, of Chipping Norton, butcher 0
5303083 2445912 2445912 plaintiff Gerves Thomas   675473 675473 Gerves, Thomas, of Chipping Norton 0
5304512 2446342 2446342 defendant Stokes John husbandman 675473 675473 Stokes, John, of Chipping Norton, husbandman 0
5438459 2486437 2486437 defendant Stokes Robert yeoman 675473 675473 Stokes, Robert, of Chipping Norton, yeoman 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);