names

52 rows where place_id = 593082

✎ 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
3610361 1870899 1870899 defendant Sachet John yeoman 593082 593082 Sachet, John, of Wynkelegh, yeoman 0
3669699 1916464 1916464 defendant Efford William husbandman 593082 593082 Efford, William, of Wynkelegh, husbandman 0
3752963 1942858 1942858 defendant Powe John fuller 593082 593082 Powe, John, of Wynkelegh, fuller 0
3769904 1948243 1948243 defendant Powe or Polke John fuller 593082 593082 Powe or Polke, John, of Wynkelegh, fuller 0
3849817 1973528 1973528 defendant Luxton William husbandman 593082 593082 Luxton, William, of Wynkelegh, husbandman 0
3858916 1976472 1976472 defendant Whyte Richard husbandman 593082 593082 Whyte, Richard, of Wynkelegh, husbandman 0
3864027 1978150 1978150 defendant Luxton Richard husbandman 593082 593082 Luxton, Richard, of Wynkelegh, husbandman 0
3865711 1978754 1978754 defendant Norden John tanner 593082 593082 Norden, John, of Wynkelegh, tanner 0
4523996 2207837 2207837 defendant Keynes John   593082 593082 Keynes, John, of Wynkelegh 0
4651566 2246488 2246488 defendant Archebold Robert   593082 593082 Archebold, Robert, of Wynkelegh, bailiff 11
4652038 2246571 2246571 defendant Baddecok Roger husbandman 593082 593082 Baddecok, Roger, of Wynkelegh, husbandman 2
4661794 2249531 2249531 defendant Smyth John smith 593082 593082 Smyth, John, of Wynkelegh, smith 2
4674994 2257790 2257790 defendant Smyth John (legal representative) 593082 593082 Smyth, John, of Wynkelegh, executors of 0
4674995 2257790 2257790 defendant Michell William husbandman 593082 593082 (Michell, William, of Wynkelegh, husbandman 1
4684228 2260671 2260671 defendant atte Staple Walter yeoman 593082 593082 atte Staple, Walter, of Wynkelegh, yeoman 1
4700347 2265523 2265523 defendant Sachell John husbandman 593082 593082 Sachell, John, of Wynkelegh, husbandman 3
4779406 2289542 2289542 defendant Uppecote Robert husbandman 593082 593082 Uppecote, Robert, of Wynkelegh, husbandman 3
4779411 2289543 2289543 defendant Uppecote Robert husbandman 593082 593082 Uppecote, Robert, of Wynkelegh, husbandman 2
4779644 2289621 2289621 defendant Michell William husbandman 593082 593082 Michell, William, of Wynkelegh, husbandman 0
4779645 2289621 2289621 defendant Smyth Walter husbandman 593082 593082 Smyth, Walter, of Wynkelegh, husbandman 1
4779646 2289621 2289621 defendant Coldecote Nicholas husbandman 593082 593082 Coldecote, Nicholas, of Wynkelegh, husbandman 2
4781413 2290194 2290194 defendant Michell William husbandman 593082 593082 Michell, William, of Wynkelegh, husbandman 0
4781414 2290194 2290194 defendant Alrigge William husbandman 593082 593082 Alrigge, William, of Wynkelegh, husbandman 1
4810293 2299365 2299365 defendant Smyth John (legal representative) 593082 593082 Smyth, John, of Wynkelegh, executors of 0
4810294 2299365 2299365 defendant Michell William husbandman 593082 593082 (Michell, William, of Wynkelegh, husbandman 1
4813232 2300253 2300253 defendant Michell William, junior laborer 593082 593082 with Michell, William, junior, of Wynkelegh, laborer 1
4813233 2300253 2300253 defendant Boure William laborer 593082 593082 Boure, William, of Wynkelegh, laborer 2
4818092 2301733 2301733 defendant Kyngdon Nicholas husbandman 593082 593082 Kyngdon, Nicholas, of Wynkelegh, husbandman 0
4818093 2301733 2301733 defendant Kyngdon Richard husbandman 593082 593082 Kyngdon, Richard, of Wynkelegh, husbandman 1
4818094 2301733 2301733 defendant Kyngdon John husbandman 593082 593082 Kyngdon, John, of Wynkelegh, husbandman 2
4906487 2328614 2328614 defendant Michell William   593082 593082 Michell, William, of Wynkelegh, franklin 0
4917640 2332032 2332032 defendant Asshelegh John husbandman 593082 593082 Asshelegh, John, of Wynkelegh, husbandman 1
4933486 2336860 2336860 defendant Athelerd Roger yeoman 593082 593082 Athelerd, Roger, of Wynkelegh, yeoman 0
4933487 2336860 2336860 defendant Born e John yeoman 593082 593082 Born,e John, of Wynkelegh, yeoman 1
4933488 2336860 2336860 defendant Neuton John yeoman 593082 593082 Neuton, John, of Wynkelegh, yeoman 2
4937246 2338014 2338014 defendant Kyndon Nicholas husbandman 593082 593082 Kyndon, Nicholas, of Wynkelegh, husbandman 0
4945701 2340636 2340636 defendant Neweton John mercer 593082 593082 Neweton, John, of Wynkelegh, mercer 0
4953035 2342874 2342874 defendant Smale Alice widow 593082 593082 Smale, Alice, of Wynkelegh, widow 0
4958762 2344590 2344590 defendant Athelard Roger husbandman 593082 593082 Athelard, Roger, of Wynkelegh, husbandman 2
4958764 2344590 2344590 defendant Borne John husbandman 593082 593082 Borne, John, of Wynkelegh, husbandman 4
4971233 2348335 2348335 defendant Lake John, senior carpenter 593082 593082 Lake, John, senior, of Wynkelegh, carpenter 0
4971234 2348335 2348335 defendant Lake John, junior carpenter 593082 593082 Lake, John, junior, of Wynkelegh, carpenter 1
4971235 2348335 2348335 defendant Lake Walter   593082 593082 Lake, Walter, of Wynkelegh, holy water clerk 2
4974498 2349335 2349335 defendant Norys Thomas husbandman 593082 593082 Norys, Thomas, of Wynkelegh, husbandman 0
4985236 2352511 2352511 defendant Hoygge Thomas   593082 593082 Hoygge, Thomas, of Wynkelegh, bailiff 4
5070092 2377549 2377549 defendant Pytteford John yeoman 593082 593082 Pytteford, John, of Wynkelegh, yeoman 0
5070094 2377549 2377549 defendant Norys Thomas husbandman 593082 593082 Norys, Thomas, of Wynkelegh, husbandman 2
5250725 2430335 2430335 defendant Touker Edmund husbandman 593082 593082 Touker, Edmund, of Wynkelegh, husbandman 3
5523483 2512173 2512173 defendant Adam John husbandman 593082 593082 Adam, John, of Wynkelegh, husbandman 1
5568279 2525268 2525268 defendant Mychell William yeoman 593082 593082 Mychell, William, of Wynkelegh, yeoman 1
5635964 2555201 2555201 defendant Athelard Roger   593082 593082 Athelard, Roger, of Wynkelegh, friary clerk 3
5635967 2555201 2555201 defendant Batecok Henry tailor 593082 593082 Batecok, Henry, of Wynkelegh, tailor 6

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