names

54 rows where place_id = 616418

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3714271 1930762 1930762 defendant Myngey William husbandman 616418 616418 Myngey, William, of Hempnall, husbandman 1
3916018 1995743 1995743 defendant Sendall John husbandman 616418 616418 Sendall, John, of Hempnall, husbandman 0
3980494 2017792 2017792 defendant Cheney William tailor 616418 616418 Cheney, William, of Hempnall, tailor 0
3986707 2019986 2019986 defendant Clerke Robert weaver 616418 616418 Clerke, Robert, of Hempnall, weaver 0
4008555 2027824 2027824 defendant Lyncolne Nicholas carpenter 616418 616418 Lyncolne, Nicholas, of Hempnall, carpenter 0
4015008 2030073 2030073 defendant Kyrke John tanner 616418 616418 Kyrke, John, of Hempnall, tanner 0
4029598 2035222 2035222 defendant Cowper Robert husbandman 616418 616418 Cowper, Robert, of Hempnall, husbandman 0
4032017 2036119 2036119 defendant Clarke Robert carpenter 616418 616418 Clarke, Robert, of Hempnall, carpenter 2
4032018 2036119 2036119 defendant Harryes Henry shoemaker 616418 616418 Harryes, Henry, of Hempnall, shoemaker 3
4035656 2037429 2037429 defendant Chettylborowe John husbandman 616418 616418 Chettylborowe, John, of Hempnall, husbandman 0
4040262 2039021 2039021 defendant Goldsmyth Andrew husbandman 616418 616418 Goldsmyth, Andrew, of Hempnall, husbandman 0
4057306 2044997 2044997 defendant Turnor John husbandman 616418 616418 Turnor, John, of Hempnall, husbandman 0
4057307 2044997 2044997 defendant Harrys Henry cordwainer 616418 616418 Harrys, Henry, of Hempnall, cordwainer 1
4059228 2045698 2045698 defendant Fayerman Thomas clerk 616418 616418 Fayerman, Thomas, of Hempnall, clerk 1
4074347 2051128 2051128 defendant Jermyn Edmund husbandman 616418 616418 Jermyn, Edmund, of Hempnall, husbandman 0
4077658 2052297 2052297 defendant Wilson James husbandman 616418 616418 Wilson, James, of Hempnall, husbandman 0
4103067 2061387 2061387 defendant Knyght Thomas laborer 616418 616418 Knyght, Thomas, of Hempnall, laborer 1
4105538 2062262 2062262 defendant Fayerman Thomas clerk 616418 616418 Fayerman, Thomas, of Hempnall, clerk 0
4106377 2062572 2062572 defendant Kyrke John tanner 616418 616418 Kyrke, John, of Hempnall, tanner 0
4106378 2062572 2062572 defendant Dowe Henry carpenter 616418 616418 Dowe, Henry, of Hempnall, carpenter 1
4156724 2080430 2080430 defendant Fayerman Thomas clerk 616418 616418 Fayerman, Thomas, of Hempnall, clerk 0
4251475 2113473 2113473 defendant Knyght Thomas spooner 616418 616418 Knyght, Thomas, of Hempnall, spooner 2
4275776 2121478 2121478 defendant Read Robert yeoman 616418 616418 Read, Robert, of Hempnall, yeoman 0
4275777 2121478 2121478 defendant Read Edmund (legal representative) 616418 616418 Read, Edmund, of Hempnall, yeoman, executrix of 1
4275778 2121478 2121478 defendant Read Mary widow 616418 616418 Read, Mary, of Hempnall, widow 2
4276221 2121627 2121627 defendant Clarke John joiner 616418 616418 Clarke, John, of Hempnall, joiner 1
4277090 2121919 2121919 defendant Goldsmythe Robert yeoman 616418 616418 Goldsmythe, Robert, of Hempnall, yeoman 0
4286608 2125257 2125257 defendant Reade Edmund (legal representative) 616418 616418 Reade, Edmund, of Hempnall, yeman, executrix of 3
4286609 2125257 2125257 defendant Reade Mary widow 616418 616418 Reade, Mary, of Hempnall, widow 4
4287005 2125405 2125405 defendant Dunt John yeoman 616418 616418 Dunt, John, of Hempnall, yeoman 2
4290177 2126555 2126555 defendant Reade Anne widow 616418 616418 Reade, Anne, of Hempnall, widow 0
4290794 2126764 2126764 defendant Goldsmyth Robert yeoman 616418 616418 Goldsmyth, Robert, of Hempnall, yeoman 0
4312787 2134601 2134601 defendant Clarke John joiner 616418 616418 Clarke, John, of Hempnall, joiner 2
4314297 2135110 2135110 defendant Harrys Henry shoemaker 616418 616418 Harrys, Henry, of Hempnall, shoemaker 0
4326630 2139266 2139266 defendant Sporle Stephen husbandman 616418 616418 Sporle, Stephen, of Hempnall, husbandman 0
4332296 2141094 2141094 defendant Gouldsmyth Robert yeoman 616418 616418 Gouldsmyth, Robert, of Hempnall, yeoman 0
4332297 2141094 2141094 defendant Reade Mary widow 616418 616418 Reade, Mary, of Hempnall, widow 1
4336656 2142548 2142548 defendant Sendell Geoffrey yeoman 616418 616418 Sendell, Geoffrey, of Hempnall, yeoman 0
4348863 2146862 2146862 defendant Estawe Robert yeoman 616418 616418 Estawe, Robert, of Hempnall, yeoman 3
4350018 2147264 2147264 defendant Reade Edmund (legal representative) 616418 616418 Reade, Edmund, of Hempnall, yeoman, executrix of 2
4350019 2147264 2147264 defendant Reade Mary widow 616418 616418 Reade, Mary, of Hempnall, widow 3
4369309 2154086 2154086 defendant Sendall Geoffrey yeoman 616418 616418 Sendall, Geoffrey, of Hempnall, yeoman 0
4369311 2154087 2154087 defendant Sendall Edward yeoman 616418 616418 Sendall, Edward, of Hempnall, yeoman 0
4388655 2160841 2160841 defendant Reade Edmund (legal representative) 616418 616418 Reade, Edmund, of Hempnall, yeoman, executrix of 0
4388656 2160841 2160841 defendant Reade Mary widow 616418 616418 Reade, Mary, of Hempnall, widow 1
4397038 2163577 2163577 defendant Sendall Edward   616418 616418 Sendall, Edward, of Hempnall, yeoman, son of Geoffrey Sendall, of Hempnall 0
4398130 2163954 2163954 defendant Dawson George husbandman 616418 616418 Dawson, George, of Hempnall, husbandman 3
4402776 2165511 2165511 defendant Sporle Stephen yeoman 616418 616418 Sporle, Stephen, of Hempnall, yeoman 2
4402777 2165511 2165511 defendant Sporle Edward yeoman 616418 616418 Sporle, Edward, of Hempnall, yeoman 3
4403465 2165730 2165730 defendant Sporle Robert yeoman 616418 616418 Sporle, Robert, of Hempnall, yeoman 0
4404830 2166182 2166182 defendant Reade William weaver 616418 616418 Reade, William, of Hempnall, weaver 1
4405803 2166507 2166507 defendant Leggood John yeoman 616418 616418 Leggood, John, of Hempnall, yeoman 2
4411351 2168386 2168386 defendant Warnes William husbandman 616418 616418 Warnes, William, of Hempnall, husbandman 0
5404604 2476393 2476393 defendant Chetilborough Thomas husbandman 616418 616418 Chetilborough, Thomas, of Hempnall, 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);