names

58 rows where place_id = 597672

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629407 1904054 1904054 plaintiff Croker Richard merchant 597672 597672 Croker, Richard, of Faryngdon, merchant 0
3637425 1906510 1906510 defendant Abraham William husbandman 597672 597672 Abraham, William, of Faryngdon, husbandman 0
3643402 1908361 1908361 plaintiff Croker Richard merchant 597672 597672 Croker, Richard, of Faryngdon, merchant 0
3673600 1917772 1917772 defendant Colyer Edward clerk 597672 597672 Colyer, Edward, of Faryngdon, clerk 0
3743220 1939745 1939745 plaintiff Wescott John   597672 597672 Wescott, John, of Faryngdon 0
3744151 1940070 1940070 defendant Colyer Edward clerk 597672 597672 Colyer, Edward, of Faryngdon, clerk 0
3756277 1943924 1943924 defendant Colyer Edward clerk 597672 597672 Colyer, Edward, of Faryngdon, clerk 0
3776937 1950529 1950529 defendant Wescote John husbandman 597672 597672 Wescote, John, of Faryngdon, husbandman 1
3782766 1952355 1952355 defendant Colyn Richard tailor 597672 597672 Colyn, Richard, of Faryngdon, tailor 0
3782768 1952355 1952355 defendant Baker German baker 597672 597672 Baker, German, of Faryngdon, baker 2
3806129 1959844 1959844 defendant Jaclyn John husbandman 597672 597672 Jaclyn, John, of Faryngdon, husbandman 0
3806131 1959845 1959845 defendant Jaklyn John husbandman 597672 597672 Jaklyn, John, of Faryngdon, husbandman 0
3808790 1960628 1960628 defendant Hewyk William glover 597672 597672 Hewyk, William, of Faryngdon, glover 0
3813698 1962196 1962196 defendant Westecote John husbandman 597672 597672 Westecote, John, of Faryngdon, husbandman 0
3822574 1964963 1964963 defendant Colyer Edward clerk 597672 597672 Colyer, Edward, of Faryngdon, clerk 0
3822788 1965032 1965032 defendant Wescote John husbandman 597672 597672 Wescote, John, of Faryngdon, husbandman 0
3824712 1965603 1965603 defendant Westcote John husbandman 597672 597672 Westcote, John, of Faryngdon, husbandman 0
3844952 1971968 1971968 defendant Hunte Richard husbandman 597672 597672 Hunte, Richard, of Faryngdon, husbandman 0
3860788 1977099 1977099 defendant Hunt Richard husbandman 597672 597672 Hunt, Richard, of Faryngdon, husbandman 0
3876303 1982316 1982316 defendant Wynter Robert husbandman 597672 597672 Wynter, Robert, of Faryngdon, husbandman 0
3882856 1984531 1984531 defendant Wescott John husbandman 597672 597672 Wescott, John, of Faryngdon, husbandman 0
3904856 1991888 1991888 defendant Wescot John husbandman 597672 597672 Wescot, John, of Faryngdon, husbandman 0
3906116 1992336 1992336 defendant Knolles Richard cordwainer 597672 597672 Knolles, Richard, of Faryngdon, cordwainer 0
3915876 1995688 1995688 defendant Wescott Thomas husbandman 597672 597672 Wescott, Thomas, of Faryngdon, husbandman 0
3929399 2000178 2000178 defendant Hunt John husandman 597672 597672 Hunt, John, of Faryngdon, husandman 1
3941852 2004286 2004286 defendant Wescott John husbandman 597672 597672 Wescott, John, of Faryngdon, husbandman 0
3998887 2024361 2024361 plaintiff Fosse John husbandman 597672 597672 Fosse, John, of Faryngdon, husbandman 0
4464494 2189563 2189563 defendant Baillif Robert   597672 597672 Baillif, Robert, of Faryngdon 2
4496534 2199590 2199590 defendant Crouche John   597672 597672 Crouche, John, of Faryngdon 1
4523949 2207825 2207825 defendant Webbe Henry   597672 597672 Webbe, Henry, of Faryngdon 0
4553659 2217069 2217069 defendant Beston Robert   597672 597672 Beston, Robert, of Faryngdon, vicar 0
4611964 2234801 2234801 defendant Bole John   597672 597672 Bole, John, of Faryngdon 2
4631206 2240659 2240659 defendant Werkman William   597672 597672 Werkman, William, of Faryngdon 0
4631211 2240660 2240660 defendant Bocher Henry   597672 597672 Bocher, Henry, of Faryngdon 3
4648661 2245664 2245664 defendant Werkman William   597672 597672 Werkman, William, of Faryngdon 0
4665229 2250613 2250613 defendant Marschal John chaplain 597672 597672 Marschal, John, of Faryngdon, chaplain 0
4706445 2267397 2267397 defendant Wescote William husbandman 597672 597672 Wescote, William, of Faryngdon, husbandman 0
4725881 2273383 2273383 plaintiff Godeman Richard   597672 597672 Godeman, Richard, of Faryngdon, glove maker 0
4796021 2294904 2294904 defendant Cook John chapman 597672 597672 Cook, John, of Faryngdon, chapman 0
4831336 2305831 2305831 defendant Hyde John husbandman 597672 597672 together with Hyde, John, of Faryngdon, husbandman 1
4831337 2305831 2305831 defendant Carter John   597672 597672 Carter, John, of Faryngdon, husbandman, 2
4896565 2325594 2325594 defendant Moyn John chapman 597672 597672 Moyn, John, of Faryngdon, chapman 3
4941925 2339458 2339458 defendant Shepherd Thomas husbandman 597672 597672 Shepherd, Thomas, of Faryngdon, husbandman 0
4949293 2341765 2341765 defendant Uphome Richard husbandman 597672 597672 Uphome, Richard, of Faryngdon, husbandman 0
4980990 2351246 2351246 defendant Jurdan Maud widow 597672 597672 Jurdan, Maud, of Faryngdon, widow 2
5061178 2374923 2374923 defendant Shepherd Thomas husbandman 597672 597672 together with Shepherd, Thomas, of Faryngdon, husbandman 1
5115540 2390971 2390971 defendant Langherst Thomas butcher 597672 597672 Langherst, Thomas, of Faryngdon, butcher 0
5138856 2397866 2397866 defendant Olyver Thomas   597672 597672 Olyver, Thomas, of Faryngdon, shoe maker 2
5229141 2424129 2424129 plaintiff Barton William   597672 597672 (Barton, William, of Faryngdon, chantry chaplain 1
5236568 2426282 2426282 defendant Germyn John gent 597672 597672 Germyn, John, of Faryngdon, gent 0
5266198 2435181 2435181 defendant Mere Philip husbandman 597672 597672 Mere, Philip, of Faryngdon, husbandman 0
5307446 2447237 2447237 defendant Knyght John husbandman 597672 597672 Knyght, John, of Faryngdon, husbandman 0
5308813 2447676 2447676 defendant Heynys John clerk & parson 597672 597672 Heynys, John, of Faryngdon, clerk & parson 0
5336749 2456059 2456059 defendant Faryngdon John gent 597672 597672 Faryngdon, John, of Faryngdon, gent 0
5336750 2456059 2456059 defendant Uphome Richard husbandman 597672 597672 Uphome, Richard, of Faryngdon, husbandman 1
5498381 2504477 2504477 defendant Wodee Thomas weaver 597672 597672 Wodee, Thomas, of Faryngdon, weaver 1
5547906 2519413 2519413 defendant Hoppyng John yeoman 597672 597672 Hoppyng, John, of Faryngdon, yeoman 0
5628316 2552813 2552813 defendant Yole John husbandman 597672 597672 Yole, John, of Faryngdon, 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);