names

41 rows where place_id = 719277

✎ 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
4228859 2105572 2105572 defendant Hampton Mary widow 719277 719277 Hampton, Mary, of Biddenden, widow 1
4245956 2111628 2111628 defendant Hampton Mary widow 719277 719277 Hampton, Mary, of Biddenden, widow 1
4259480 2116147 2116147 defendant Beale Richard clothier 719277 719277 Beale, Richard, of Biddenden, clothier 0
4273014 2120535 2120535 defendant Gates John clothier 719277 719277 Gates, John, of Biddenden, clothier 0
4283507 2124136 2124136 defendant Walter Mathew clothier 719277 719277 Walter, Mathew, of Biddenden, clothier 0
4292162 2127267 2127267 defendant Walter Mathew clothier 719277 719277 Walter, Mathew, of Biddenden, clothier 0
4313178 2134722 2134722 defendant Welden Clement hammerman 719277 719277 Welden, Clement, of Biddenden, hammerman 0
4313179 2134722 2134722 defendant Houffenden of Houssenden John   719277 719277 Houffenden of Houssenden, John, of Biddenden, broad weaver 1
4313598 2134862 2134862 defendant Saywell John sherman 719277 719277 Saywell, John, of Biddenden, sherman 0
4322095 2137808 2137808 defendant Bateman James clothier 719277 719277 Bateman, James, of Biddenden, clothier 0
4322097 2137809 2137809 defendant Gates John clothier 719277 719277 Gates, John, of Biddenden, clothier 0
4332193 2141062 2141062 defendant Prettye Thomas clothier 719277 719277 Prettye, Thomas, of Biddenden, clothier 0
4350337 2147378 2147378 defendant Bateman James yeoman 719277 719277 Bateman, James, of Biddenden, yeoman 0
4362023 2151462 2151462 defendant Fludd Simon weaver 719277 719277 Fludd, Simon, of Biddenden, weaver 0
4362024 2151462 2151462 defendant Fele Thomas weaver 719277 719277 Fele, Thomas, of Biddenden, weaver 1
4362025 2151462 2151462 defendant Brumfilde Stephen husbandman 719277 719277 Brumfilde, Stephen, of Biddenden, husbandman 2
4369093 2154013 2154013 defendant Doggett John husbandman 719277 719277 Doggett, John, of Biddenden, husbandman 0
4370942 2154664 2154664 defendant Weller John, junior   719277 719277 Weller, John, junior, of Biddenden, Kent, clothier, his son 1
4373294 2155516 2155516 defendant Lambe William husbandman 719277 719277 Lambe, William, of Biddenden, husbandman 2
4376540 2156678 2156678 defendant Lytle Robert tanner 719277 719277 Lytle, Robert, of Biddenden, tanner 0
4377327 2156967 2156967 defendant Fily Thomas   719277 719277 Fily, Thomas, of Biddenden, broad weaver 0
4378839 2157508 2157508 defendant Stowe John   719277 719277 Stowe, John, of Biddenden, petty chapman 1
4384223 2159416 2159416 defendant Walter Andrew weaver 719277 719277 Walter, Andrew, of Biddenden, weaver 0
4401570 2165122 2165122 defendant Strynger Edmund yeoman 719277 719277 Strynger, Edmund, of Biddenden, yeoman 0
4407321 2167009 2167009 defendant Fylye Thomas weaver 719277 719277 Fylye, Thomas, of Biddenden, weaver 1
4691667 2262927 2262927 defendant Brykynden Walter tanner 719277 719277 Brykynden, Walter, of Biddenden, tanner 2
4703791 2266564 2266564 defendant Roger Richard laborer 719277 719277 Roger, Richard, of Biddenden, laborer 3
4703926 2266605 2266605 defendant Trynteherst Simon husbandman 719277 719277 Trynteherst, Simon, of Biddenden, husbandman 0
4709400 2268293 2268293 defendant Andrewe Robert laborer 719277 719277 Andrewe, Robert, of Biddenden, laborer 2
4759366 2283272 2283272 defendant Rawlyn Geoffrey yeoman 719277 719277 Rawlyn, Geoffrey, of Biddenden, yeoman 0
4770730 2286825 2286825 defendant Peancron Thomas husbandman 719277 719277 Peancron, Thomas, of Biddenden, husbandman 1
4774421 2287983 2287983 defendant Pikynden John fuller 719277 719277 Pikynden, John, of Biddenden, fuller 0
4834056 2306658 2306658 defendant Harry Thomas draper 719277 719277 Harry, Thomas, of Biddenden, draper 0
4834748 2306868 2306868 defendant Amyot William husbandman 719277 719277 Amyot, William, of Biddenden, husbandman 0
4850250 2311537 2311537 defendant Wylot William carpenter 719277 719277 Wylot, William, of Biddenden, carpenter 0
4850396 2311580 2311580 defendant Roger Robert laborer 719277 719277 Roger, Robert, of Biddenden, laborer 1
4996696 2355868 2355868 defendant Adam John shoemaker 719277 719277 Adam, John, of Biddenden, shoemaker 0
5169317 2406761 2406761 defendant atte Hope Henry weaver 719277 719277 atte Hope, Henry, of Biddenden, weaver 0
5205029 2417226 2417226 defendant atte Hope Henry weaver 719277 719277 atte Hope, Henry, of Biddenden, weaver 0
5305000 2446495 2446495 defendant Berowe William clothmaker 719277 719277 Berowe, William, of Biddenden, clothmaker 0
5467848 2495323 2495323 defendant Taylour Walter yeoman 719277 719277 Taylour, Walter, of Biddenden, yeoman 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);