names

88 rows where place_id = 594880

✎ 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
3617947 1873238 1873238 defendant Reynoldson Thomas yeoman 594880 594880 Reynoldson, Thomas, of Wynton, yeoman 0
3975750 2016080 2016080 plaintiff Hylton Henry (legal representative) 594880 594880 Hylton, Henry, of Wynton, gent, executor of 0
3975753 2016081 2016081 plaintiff Hylton Henry (legal representative) 594880 594880 Hylton, Henry, of Wynton, gent, executor of 0
4404611 2166113 2166113 defendant Marwood James yeoman 594880 594880 Marwood, James, of Wynton, yeoman 2
4404612 2166113 2166113 defendant Marwood Christopher yeoman 594880 594880 Marwood, Christopher, of Wynton, yeoman 3
4413668 2169168 2169168 defendant Kirkeby John de   594880 594880 Kirkeby, John de, of Wynton or Winchester 0
4413669 2169168 2169168 defendant Lynne Lawrence de   594880 594880 Lynne, Lawrence de, of Wynton 1
4413670 2169168 2169168 defendant Russel Robert   594880 594880 Russel, Robert, of Wynton 2
4421127 2171500 2171500 defendant Wandlesworth Nicholas de   594880 594880 Wandlesworth, Nicholas de, of Wynton 0
4443683 2182992 2182992 defendant Croftes Hugh   594880 594880 Croftes, Hugh, of Wynton 0
4443785 2183028 2183028 plaintiff Chaumberlayn Richard draper 594880 594880 Chaumberlayn, Richard, of Wynton or Winchester, draper 0
4444202 2183167 2183167 defendant Gradevere John   594880 594880 Gradevere, John, of Wynton 1
4448323 2184400 2184400 plaintiff Fode Ralph   594880 594880 Fode, Ralph, of wynton 0
4462119 2188852 2188852 defendant Dunstaple Philip   594880 594880 Dunstaple, Philip, of Wynton 0
4462135 2188854 2188854 defendant Poghele Richard   594880 594880 Poghele, Richard, of Wynton 0
4465831 2189983 2189983 plaintiff Haym Stephen   594880 594880 Haym, Stephen, of Wynton 5
4478214 2193858 2193858 plaintiff Haym Stephen   594880 594880 Haym, Stephen, of Wynton, or Winchester 0
4480847 2194680 2194680 plaintiff le Fayre Mark merchant 594880 594880 le Fayre, Mark, of Wynton or Winchester, merchant 0
4486454 2196474 2196474 defendant Hore William   594880 594880 Hore, William, of Wynton 2
4519548 2206474 2206474 plaintiff Emmot Simon   594880 594880 Emmot, Simon, of Wynton 0
4527044 2208738 2208738 defendant Marchaunt John butcher 594880 594880 Marchaunt, John, of Wynton, butcher 0
4591597 2228731 2228731 defendant Kyrton Richard   594880 594880 Kyrton, Richard, of Wynton 4
4615020 2235709 2235709 plaintiff Estbury John sadler 594880 594880 Estbury, John, of Wynton, sadler 0
4629055 2240012 2240012 defendant Isbury John sadler 594880 594880 Isbury, John, of Wynton, sadler 0
4639642 2243109 2243109 defendant Garth Thomas   594880 594880 Garth, Thomas, of Wynton 0
4639643 2243109 2243109 defendant Morland Robert de   594880 594880 Morland, Robert de, of Wynton 1
4639644 2243109 2243109 defendant Jonson Nicholas   594880 594880 Jonson, Nicholas, of Wynton 2
4639645 2243109 2243109 defendant Morland John de   594880 594880 Morland, John de, of Wynton 3
4642731 2243991 2243991 defendant Archer Rbert   594880 594880 Archer, Rbert, of Wynton 0
4642732 2243991 2243991 defendant Wastneys Thomas   594880 594880 Wastneys, Thomas, of Wynton 1
4642734 2243992 2243992 defendant Archer Robert   594880 594880 Archer, Robert, of Wynton 0
4642735 2243992 2243992 defendant Wastneys Thomas   594880 594880 Wastneys, Thomas, of Wynton or Winchester 1
4649055 2245772 2245772 defendant Langynow Edward   594880 594880 Langynow, Edward, of Wynton 0
4649817 2245970 2245970 defendant Serle John   594880 594880 Serle, John, of Wynton 0
4660388 2249076 2249076 plaintiff de Wynton William (legal representative) 594880 594880 de Wynton, William, of Wynton, executors of 0
4660395 2249077 2249077 plaintiff de Wynton William (legal representative) 594880 594880 de Wynton, William, of Wynton, executors of 0
4663613 2250098 2250098 defendant Bost John husbandman 594880 594880 Bost, John, of Wynton, husbandman 2
4667083 2255438 2255438 plaintiff Archer Robert mercer 594880 594880 Archer, Robert, of Wynton, mercer 0
4685889 2261178 2261178 defendant Bost John yeoman 594880 594880 Bost, John, of Wynton, yeoman 0
4691027 2262718 2262718 defendant Taylard William weaver 594880 594880 Taylard, William, of Wynton or Winchester, weaver 0
4697247 2264621 2264621 defendant Wynton William de yeoman 594880 594880 Wynton, William de, of Wynton, yeoman 0
4709023 2268190 2268190 plaintiff Parkere John   594880 594880 Parkere, John, of Wynton or Winchester 0
4718430 2271102 2271102 defendant Bost John husbandman 594880 594880 Bost, John, of Wynton, husbandman 0
4734927 2276083 2276083 defendant Boste John yeoman 594880 594880 Boste, John, of Wynton, yeoman 1
4780088 2289776 2289776 defendant Garth Thomas yeoman 594880 594880 Garth, Thomas, of Wynton, yeoman 0
4797202 2295296 2295296 defendant Walker Robert yeoman 594880 594880 Walker, Robert, of Wynton, yeoman 3
4807677 2298592 2298592 defendant Nicolson Thomas   594880 594880 Nicolson, Thomas, of Wynton or Winchester 2
4808215 2298747 2298747 defendant Lowyn Thomas fuller 594880 594880 Lowyn, Thomas, of Wynton, fuller 1
4811278 2299637 2299637 plaintiff Fromond William   594880 594880 Fromond, William, of Wynton, on his own account 0
4814982 2300796 2300796 defendant Reynaldson John husbandman 594880 594880 Reynaldson, John, of Wynton, husbandman 0
4814983 2300796 2300796 defendant Morland William, senior husbandman & son of John Morland 594880 594880 Morland, William, senior, of Wynton, husbandman & son of John Morland 1
4814984 2300796 2300796 defendant Morland William, junior husbandman & son of John Morland 594880 594880 Morland, William, junior, of Wynton, husbandman & son of John Morland 2
4815914 2301073 2301073 defendant Daud Thomas husbandman 594880 594880 Daud, Thomas, of Wynton, husbandman 6
4815935 2301075 2301075 defendant Daud Thomas husbandman 594880 594880 Daud, Thomas, of Wynton, husbandman 7
4822725 2303186 2303186 defendant Wynk Robert haulier or slater 594880 594880 Wynk, Robert, of Wynton, haulier or slater 1
4827009 2304490 2304490 defendant Bost John chapman 594880 594880 Bost, John, of Wynton, chapman 0
4835267 2307029 2307029 defendant Wynton William de yeoman 594880 594880 Wynton, William de, of Wynton, yeoman 2
4851928 2312038 2312038 plaintiff Walker William   594880 594880 Walker, William, of Wynton 0
4852295 2312142 2312142 defendant Walker Robert husbandman 594880 594880 Walker, Robert, of Wynton, husbandman 3
4862520 2315268 2315268 defendant Chapman William yeoman 594880 594880 Chapman, William, of Wynton, yeoman 0
4862641 2315301 2315301 defendant de Wynton William yeoman 594880 594880 de Wynton, William, of Wynton, yeoman 0
4867045 2316657 2316657 defendant Wynton William yeoman 594880 594880 Wynton, William, of Wynton, yeoman 2
4873603 2318683 2318683 defendant Chapman William yeoman 594880 594880 Chapman, William, of Wynton, yeoman 8
4873604 2318683 2318683 defendant Morland William yeoman 594880 594880 Morland, William, of Wynton, yeoman 9
4873605 2318683 2318683 defendant Westmorland William yeoman 594880 594880 Westmorland, William, of Wynton, yeoman 10
4873606 2318683 2318683 defendant Hobson John yeoman 594880 594880 Hobson, John, of Wynton, yeoman 11
4876808 2319717 2319717 defendant Thomson John husbandman 594880 594880 together with Thomson, John, of Wynton, husbandman 4
4879923 2320635 2320635 plaintiff Walker William   594880 594880 Walker, William, of Wynton or Winchester 0
4881857 2321224 2321224 defendant Walker William walker 594880 594880 Walker, William, of Wynton, walker 2
4905137 2328208 2328208 defendant Johnson Thomas yeoman 594880 594880 Johnson, Thomas, of Wynton, yeoman 2
4905138 2328208 2328208 defendant Johnson Richard yeoman 594880 594880 Johnson, Richard, of Wynton, yeoman 3
4905142 2328209 2328209 defendant Johnson Thomas yeoman 594880 594880 Johnson, Thomas, of Wynton, yeoman 2
4905143 2328209 2328209 defendant Johnson Richard yeoman 594880 594880 Johnson, Richard, of Wynton, yeoman 3
4910945 2329935 2329935 defendant Tevell William husbandman 594880 594880 Tevell, William, of Wynton, husbandman 4
4914948 2331182 2331182 defendant Chapman William yeoman 594880 594880 Chapman, William, of Wynton, yeoman 1
5002236 2357557 2357557 defendant Walker Robert yeoman 594880 594880 Walker, Robert, of Wynton, yeoman 3
5249542 2429983 2429983 plaintiff Tylborowth Robert   594880 594880 Tylborowth, Robert, of Wynton 0
5310727 2448244 2448244 defendant Caunton William yeoman 594880 594880 Caunton, William, of Wynton, yeoman 2
5435649 2485600 2485600 defendant Howell Henry yeoman 594880 594880 Howell, Henry, of Wynton or Winchester, yeoman 0
5435652 2485601 2485601 defendant Howell Henry yeoman 594880 594880 Howell, Henry, of Wynton, yeoman 0
5452320 2490567 2490567 plaintiff Surteys William clerk & master of the hospital of the BMM 594880 594880 Surteys, William, of Wynton, clerk & master of the hospital of the BMM 0
5455897 2491671 2491671 defendant Eversham William haberdasher 594880 594880 Eversham, William, of Wynton, haberdasher 0
5469854 2495910 2495910 defendant Hertfild John merchant 594880 594880 Hertfild, John, of Wynton, merchant 0
5611220 2547238 2547238 plaintiff Blake John   594880 594880 Blake, John, of Wynton or Winchester 0
5614273 2548247 2548247 plaintiff Edward Robert sadler 594880 594880 Edward, Robert, of Wynton, sadler 0
5615088 2548509 2548509 defendant Morene William   594880 594880 Morene, William, of Wynton or Winchester 0
5622682 2551026 2551026 plaintiff Warner Thomas   594880 594880 Warner, Thomas, of Wynton of Winchester 0
5634003 2554618 2554618 defendant Sadeler John saddler 594880 594880 Sadeler, John, of Wynton, saddler 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);