names

122 rows where place_id = 667940

✎ 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
3987017 2020097 2020097 defendant Andrews Walter gent 667940 667940 Andrews, Walter, of Wellington, gent 0
3994897 2022926 2022926 plaintiff Cooke John tanner 667940 667940 Cooke, John, of Wellington, tanner 0
4019665 2031761 2031761 defendant Baggwell Edmund yeoman 667940 667940 Baggwell, Edmund, of Wellington, yeoman 0
4042520 2039792 2039792 defendant Wood Edward husbandman 667940 667940 Wood, Edward, of Wellington, husbandman 0
4059663 2045850 2045850 defendant Lee Thomas innholder 667940 667940 Lee, Thomas, of Wellington, innholder 2
4068954 2049185 2049185 defendant Bennett John tanner 667940 667940 Bennett, John, of Wellington, tanner 2
4084224 2054631 2054631 defendant Gyfforde John butcher 667940 667940 Gyfforde, John, of Wellington, butcher 0
4085941 2055248 2055248 defendant Bodley John   667940 667940 Bodley, John, of Wellington, yeoman, bachelor 0
4085942 2055248 2055248 defendant Bodley William husbandman 667940 667940 Bodley, William, of Wellington, husbandman 1
4085944 2055249 2055249 defendant Gardyner John husbandman 667940 667940 Gardyner, John, of Wellington, husbandman 0
4109884 2063795 2063795 defendant Poole Nicholas husbandman 667940 667940 Poole, Nicholas, of Wellington, husbandman 0
4109886 2063796 2063796 defendant Poole Nicholas husbandman 667940 667940 Poole, Nicholas, of Wellington, husbandman 0
4117894 2066692 2066692 defendant Vynche Henry yeoman 667940 667940 Vynche, Henry, of Wellington, yeoman 0
4123302 2068636 2068636 defendant Thomas alias Hancocke John fisher or fishmonger 667940 667940 Thomas alias Hancocke, John, of Wellington, fisher or fishmonger 0
4123717 2068784 2068784 defendant Wood John husbandman 667940 667940 Wood, John, of Wellington, husbandman 0
4124487 2069053 2069053 defendant Parsons Philip weaver 667940 667940 Parsons, Philip, of Wellington, weaver 0
4128402 2070450 2070450 defendant Dynham John tanner 667940 667940 Dynham, John, of Wellington, tanner 0
4128403 2070450 2070450 defendant Berrye Geoffrey husbandman 667940 667940 Berrye, Geoffrey, of Wellington, husbandman 1
4131285 2071510 2071510 defendant Dynham Robert tanner 667940 667940 Dynham, Robert, of Wellington, tanner 0
4131286 2071510 2071510 defendant Spyringe Peter husbandman 667940 667940 Spyringe, Peter, of Wellington, husbandman 1
4133804 2072425 2072425 defendant Norman Thomas husbandman 667940 667940 Norman, Thomas, of Wellington, husbandman 1
4133805 2072425 2072425 defendant Norman Robert husbandman 667940 667940 Norman, Robert, of Wellington, husbandman 2
4134014 2072497 2072497 defendant Southeye William husbandman 667940 667940 Southeye, William, of Wellington, husbandman 1
4134015 2072497 2072497 defendant Parsons Richard weaver 667940 667940 Parsons, Richard, of Wellington, weaver 2
4134023 2072499 2072499 defendant Glasse Alexander husbandman 667940 667940 Glasse, Alexander, of Wellington, husbandman 1
4134024 2072499 2072499 defendant Perrey William husbandman 667940 667940 Perrey, William, of Wellington, husbandman 2
4134027 2072500 2072500 defendant Denham Robert tanner 667940 667940 Denham, Robert, of Wellington, tanner 1
4134028 2072500 2072500 defendant Manley John clothier 667940 667940 Manley, John, of Wellington, clothier 2
4137366 2073714 2073714 defendant Cade William husbandman 667940 667940 Cade, William, of Wellington, husbandman 0
4137368 2073715 2073715 defendant Roe Thomas weaver 667940 667940 Roe, Thomas, of Wellington, weaver 0
4144067 2076089 2076089 defendant Thomas alias Hancocke Nicholas yeoman 667940 667940 Thomas alias Hancocke, Nicholas, of Wellington, yeoman 0
4144069 2076089 2076089 defendant Veng or Vinges George husbandman 667940 667940 Veng or Vinges, George, of Wellington, husbandman 2
4144070 2076089 2076089 defendant Reede Martin husbandman 667940 667940 Reede, Martin, of Wellington, husbandman 3
4146164 2076808 2076808 defendant Wood John husbandman 667940 667940 Wood, John, of Wellington, husbandman 0
4146165 2076808 2076808 defendant Hancocke John husbandman 667940 667940 Hancocke, John, of Wellington, husbandman 1
4147212 2077163 2077163 defendant Lye William weaver 667940 667940 Lye, William, of Wellington, weaver 0
4147213 2077163 2077163 defendant Wright Humphrey weaver 667940 667940 Wright, Humphrey, of Wellington, weaver 1
4147651 2077319 2077319 defendant Parsons Philip weaver 667940 667940 Parsons, Philip, of Wellington, weaver 0
4149990 2078130 2078130 defendant Gameham alias Cheshire Hugh glover 667940 667940 Gameham alias Cheshire, Hugh, of Wellington, glover 0
4149992 2078131 2078131 defendant Gameham alias Cheshire Hugh glover 667940 667940 Gameham alias Cheshire, Hugh, of Wellington, glover 0
4150249 2078218 2078218 defendant Lee Thomas   667940 667940 Lee, Thomas, of Wellington, broad weaver 0
4150250 2078218 2078218 defendant Frend Thomas glover 667940 667940 Frend, Thomas, of Wellington, glover 1
4151132 2078524 2078524 defendant Leighe Thomas weaver 667940 667940 Leighe, Thomas, of Wellington, weaver 1
4151133 2078524 2078524 defendant Trustram John tailor 667940 667940 Trustram, John, of Wellington, tailor 2
4151907 2078776 2078776 defendant Burton John tucker 667940 667940 Burton, John, of Wellington, tucker 0
4157789 2080797 2080797 defendant Norman Thomas husbandman 667940 667940 Norman, Thomas, of Wellington, husbandman 1
4157790 2080797 2080797 defendant Norman Robert husbandman 667940 667940 Norman, Robert, of Wellington, husbandman 2
4158074 2080892 2080892 defendant Pery Hugh husbandman 667940 667940 Pery, Hugh, of Wellington, husbandman 2
4158075 2080892 2080892 defendant Cade William husbandman 667940 667940 Cade, William, of Wellington, husbandman 3
4158466 2081033 2081033 defendant Manley John weaver 667940 667940 Manley, John, of Wellington, or of Uploman, Devon, husbandman, weaver 0
4163708 2082829 2082829 defendant Woode Richard yeoman 667940 667940 Woode, Richard, of Wellington, yeoman 0
4165278 2083363 2083363 defendant Springe Peter husbandman 667940 667940 Springe, Peter, of Wellington, husbandman 1
4182588 2089386 2089386 defendant Wheeler Walter yeoman 667940 667940 Wheeler, Walter, of Wellington, yeoman 1
4188138 2091352 2091352 defendant Southaye William husbandman 667940 667940 Southaye, William, of Wellington, husbandman 1
4188139 2091352 2091352 defendant Parsons Richard weaver 667940 667940 Parsons, Richard, of Wellington, weaver 2
4207152 2098046 2098046 defendant Sowthey William husbandman 667940 667940 Sowthey, William, of Wellington, husbandman 1
4223035 2103547 2103547 defendant Haworth John, senior yeoman 667940 667940 Haworth, John, senior, of Wellington, yeoman 2
4226965 2104905 2104905 defendant Callowe alias Calwey William dyer 667940 667940 Callowe alias Calwey, William, of Wellington, dyer 1
4230589 2106195 2106195 defendant Brace William yeoman 667940 667940 Brace, William, of Wellington, yeoman 1
4248357 2112442 2112442 defendant Haworthe John, senior yeoman 667940 667940 Haworthe, John, senior, of Wellington, yeoman 2
4284876 2124638 2124638 defendant Furslande Edward yeoman 667940 667940 Furslande, Edward, of Wellington, yeoman 0
4291368 2126986 2126986 defendant Norden Anthony tailor 667940 667940 Norden, Anthony, of Wellington, tailor 3
4291607 2127075 2127075 defendant Berry William husbandman 667940 667940 Berry, William, of Wellington, husbandman 0
4291841 2127156 2127156 defendant Seward Thomas yeoman 667940 667940 Seward, Thomas, of Wellington, yeoman 0
4292157 2127265 2127265 defendant Growe Robert yeoman 667940 667940 Growe, Robert, of Wellington, yeoman 0
4292158 2127265 2127265 defendant Clemente Anne widow 667940 667940 Clemente, Anne, of Wellington, widow 1
4294803 2128226 2128226 defendant Frie John shoemaker 667940 667940 Frie, John, of Wellington, shoemaker 0
4294926 2128270 2128270 defendant Berrye William husbandman 667940 667940 Berrye, William, of Wellington, husbandman 0
4298081 2129417 2129417 defendant Thomas Robert yeoman 667940 667940 Thomas, Robert, of Wellington, yeoman 2
4299225 2129819 2129819 defendant Parson Richard husbandman 667940 667940 Parson, Richard, of Wellington, husbandman 3
4299227 2129820 2129820 defendant Raynsbery William husbandman 667940 667940 Raynsbery, William, of Wellington, husbandman 0
4299229 2129820 2129820 defendant Jenkyns Thomas fuller 667940 667940 Jenkyns, Thomas, of Wellington, fuller 2
4299234 2129821 2129821 defendant Parson Richard husbandman 667940 667940 Parson, Richard, of Wellington, husbandman 3
4300908 2130425 2130425 defendant Roulson John husbandman 667940 667940 Roulson, John, of Wellington, husbandman 0
4307563 2132784 2132784 defendant Penny Thomas, senior baker 667940 667940 Penny, Thomas, senior, of Wellington, baker 0
4307564 2132784 2132784 defendant Penny Thomas, junior baker 667940 667940 Penny, Thomas, junior, of Wellington, baker 1
4307565 2132784 2132784 defendant Hunte William yeoman 667940 667940 Hunte, William, of Wellington, yeoman 2
4309498 2133484 2133484 defendant Kynnersley Humphrey carrier 667940 667940 Kynnersley, Humphrey, of Wellington, carrier 0
4310768 2133909 2133909 defendant Bull Alexander gent 667940 667940 Bull, Alexander, of Wellington, or of Middle Temple, gent 0
4312462 2134495 2134495 defendant Winnall Nicholas capper 667940 667940 Winnall, Nicholas, of Wellington, capper 3
4313792 2134932 2134932 defendant Carter William weaver 667940 667940 Carter, William, of Wellington, weaver 2
4323179 2138166 2138166 defendant Gredy Edward yeoman 667940 667940 Gredy, Edward, of Wellington, yeoman 2
4323231 2138185 2138185 defendant Colman Roger husbandman 667940 667940 Colman, Roger, of Wellington, husbandman 0
4325839 2139014 2139014 defendant Wymall Nicholas cooper 667940 667940 Wymall, Nicholas, of Wellington, cooper 3
4326143 2139113 2139113 defendant Frend Thomas butcher 667940 667940 Frend, Thomas, of Wellington, butcher 0
4328013 2139689 2139689 defendant Watson John yeoman 667940 667940 Watson, John, of Wellington, yeoman 1
4331211 2140736 2140736 defendant Thomas Robert yeoman 667940 667940 Thomas, Robert, of Wellington, yeoman 2
4342061 2144504 2144504 defendant Bennett William laborer 667940 667940 Bennett, William, of Wellington, laborer 1
4342062 2144504 2144504 defendant Ashley John laborer 667940 667940 Ashley John, of Wellington, laborer 2
4357996 2150038 2150038 defendant Peiers Thomas husbandman 667940 667940 Peiers, Thomas, of Wellington, husbandman 1
4357998 2150038 2150038 defendant Lovell Alice widow 667940 667940 Lovell, Alice, of Wellington, widow 3
4359240 2150466 2150466 defendant Perrey Thomas gent 667940 667940 Perrey, Thomas, of Wellington, gent 0
4366564 2153090 2153090 defendant Pryce Thomas gent 667940 667940 Pryce, Thomas, of Wellington, gent 0
4367643 2153481 2153481 defendant Reade Thomas   667940 667940 Reade, Thomas, of Wellington, felt maker 0
4369277 2154076 2154076 defendant Kynnerley Humphrey yeoman 667940 667940 Kynnerley, Humphrey, of Wellington, yeoman 0
4375873 2156432 2156432 defendant Towsend Nicholas fisher 667940 667940 Towsend, Nicholas, of Wellington, fisher 0
4379546 2157773 2157773 defendant Mayes Elizabeth widow 667940 667940 Mayes, Elizabeth, of Wellington, widow 0
4384233 2159420 2159420 defendant Raynsberie Thomas weaver 667940 667940 Raynsberie, Thomas, of Wellington, weaver 0
4387854 2160570 2160570 defendant Ellyott John yeoman 667940 667940 Ellyott, John, of Wellington, yeoman 1
4400393 2164727 2164727 defendant Jewkes Richard mercer 667940 667940 Jewkes, Richard, of Wellington, mercer 0

Next page

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