names

124 rows where place_id = 591656

✎ 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
3605116 1869265 1869265 defendant Hythe Simon yeoman 591656 591656 Hythe, Simon, of Walcote, yeoman 2
3619559 1873685 1873685 defendant Auncell John husbandman 591656 591656 Auncell, John, of Walcote, husbandman 2
3627272 1903376 1903376 defendant Walcote Humphrey gent 591656 591656 Walcote, Humphrey, of Walcote, gent 0
3656315 1912220 1912220 defendant Tyrell John baker 591656 591656 Tyrell, John, of Walcote, baker 2
3656320 1912221 1912221 defendant Tyrell John baker 591656 591656 Tyrell, John, of Walcote, baker 2
3663929 1914659 1914659 defendant Stretton John husbandman 591656 591656 Stretton, John, of Walcote, husbandman 0
3663930 1914659 1914659 defendant Ansty William laborer 591656 591656 Ansty, William, of Walcote, laborer 1
3670429 1916707 1916707 defendant Turner John gent 591656 591656 Turner, John, of Walcote, gent 0
3687726 1922329 1922329 defendant Turvey Richard yeoman 591656 591656 Turvey, Richard, of Walcote, yeoman 0
3691633 1923541 1923541 defendant Leche Thomas yeoman 591656 591656 Leche, Thomas, of Walcote, yeoman 0
3704584 1927723 1927723 defendant Benell or Bevell Thomas husbandman 591656 591656 Benell or Bevell, Thomas, of Walcote, husbandman 1
3707480 1928631 1928631 defendant Brykwode Richard husbandman 591656 591656 Brykwode, Richard, of Walcote, husbandman 1
3707481 1928631 1928631 defendant Stretton William, junior husbandman 591656 591656 Stretton, William, junior, of Walcote, husbandman 2
3721187 1932926 1932926 defendant Warde Edmund husbandman 591656 591656 Warde, Edmund, of Walcote, husbandman 0
3735420 1937316 1937316 defendant Leche Thomas husbandman 591656 591656 Leche, Thomas, of Walcote, husbandman 1
3736697 1937729 1937729 defendant Walcote Alexander gent 591656 591656 Walcote, Alexander, of Walcote, gent 0
3748147 1941348 1941348 defendant Tourner John gent 591656 591656 Tourner, John, of Walcote, gent 0
3748967 1941609 1941609 defendant Leche Thomas husbandman 591656 591656 Leche, Thomas, of Walcote, husbandman 0
3762267 1945843 1945843 defendant Tourner John gent 591656 591656 Tourner, John, of Walcote, gent 0
3772964 1949246 1949246 defendant Creysour Thomas husbandman 591656 591656 Creysour, Thomas, of Walcote, husbandman 0
3772965 1949246 1949246 defendant Daunce Edmund husbandman 591656 591656 Daunce, Edmund, of Walcote, husbandman 1
3774262 1949670 1949670 defendant Egerton Richard laborer 591656 591656 Egerton, Richard, of Walcote, laborer 1
3778475 1950983 1950983 defendant Leche Thomas husbandman 591656 591656 Leche, Thomas, of Walcote, husbandman 1
3855811 1975448 1975448 defendant Saunders Thomas yeoman 591656 591656 Saunders, Thomas, of Walcote, yeoman 1
3895229 1988612 1988612 defendant Warde Robert, junior tailor 591656 591656 Warde, Robert, junior, of Walcote, tailor 0
3930127 2000421 2000421 defendant Hagatt Richard husbandman 591656 591656 Hagatt, Richard, of Walcote, husbandman 3
3938632 2003263 2003263 defendant Forster Robert husbandman 591656 591656 Forster, Robert, of Walcote, husbandman 3
3960154 2010655 2010655 defendant Watson John yeoman 591656 591656 Watson, John, of Walcote, yeoman 0
3960155 2010655 2010655 defendant Cooke Edmund yeoman 591656 591656 Cooke, Edmund, of Walcote, yeoman 1
3960159 2010656 2010656 defendant Watson John yeoman 591656 591656 Watson, John, of Walcote, yeoman 0
3960161 2010656 2010656 defendant Cooke Edmund yeoman 591656 591656 Cooke, Edmund, of Walcote, yeoman 2
3982257 2018422 2018422 defendant Watson John yeoman 591656 591656 Watson, John, of Walcote, yeoman 0
3982258 2018422 2018422 defendant Coke William yeoman 591656 591656 Coke, William, of Walcote, yeoman 1
3982259 2018422 2018422 defendant Warde John yeoman 591656 591656 Warde, John, of Walcote, yeoman 2
3986130 2019811 2019811 defendant Warde Robert yeoman 591656 591656 Warde, Robert, of Walcote, yeoman 0
3988077 2020478 2020478 defendant Watson John yeoman 591656 591656 Watson, John, of Walcote, yeoman 0
4000633 2024999 2024999 defendant Watson John husbandman 591656 591656 Watson, John, of Walcote, husbandman 0
4015056 2030076 2030076 defendant Warde Robert husbandman 591656 591656 Warde, Robert, of Walcote, husbandman 7
4018781 2031449 2031449 plaintiff Walcott George gent 591656 591656 Walcott, George, of Walcote, ,gent 0
4030095 2035411 2035411 defendant Page Thomas yeoman 591656 591656 Page, Thomas, of Walcote, yeoman 1
4040731 2039179 2039179 defendant Warde Robert, senior yeoman 591656 591656 Warde, Robert, senior, of Walcote, yeoman 0
4086556 2055477 2055477 defendant Watson John yeoman 591656 591656 Watson, John, of Walcote, yeoman 0
4115949 2065991 2065991 defendant Warde Robert, junior husbandman 591656 591656 Warde, Robert, junior, of Walcote, husbandman 0
4143622 2075926 2075926 defendant Wright William yeoman 591656 591656 Wright, William, of Walcote, yeoman 1
4172102 2085704 2085704 defendant Cawde Robert husbandman 591656 591656 Cawde, Robert, of Walcote, husbandman 1
4415441 2169725 2169725 defendant Lane Julia in the   591656 591656 Lane, Julia in the, of Walcote, formerly wife of Luke in the Lane 1
4432835 2175025 2175025 defendant Gerbode Simon   591656 591656 Gerbode, Simon, of Walcote 0
4459884 2188146 2188146 plaintiff Walcote Simon de   591656 591656 Walcote, Simon de, of Walcote, parson 4
4476704 2193373 2193373 plaintiff Geffecok John   591656 591656 Geffecok, John, of Walcote 0
4476705 2193373 2193373 defendant Lyssell Thomas   591656 591656 Lyssell, Thomas, of Walcote 0
4486145 2196367 2196367 plaintiff Rose Annice   591656 591656 Rose, Annice, of Walcote 0
4492086 2198215 2198215 defendant Prat William   591656 591656 Prat, William, of Walcote 0
4503125 2201547 2201547 defendant Wallepole John   591656 591656 Wallepole, John, of Walcote 0
4504379 2201921 2201921 defendant Note Robert   591656 591656 Note, Robert, of Walcote 0
4534749 2211148 2211148 defendant Othe Dyke John   591656 591656 Othe Dyke, John, of Walcote 3
4539373 2212573 2212573 plaintiff Walcote Katherine   591656 591656 Walcote, Katherine, of Walcote 0
4546084 2214718 2214718 defendant Crisp William   591656 591656 Crisp, William, of Walcote 0
4546085 2214718 2214718 defendant Crisp Thomas   591656 591656 Crisp, Thomas, of Walcote 1
4579996 2225230 2225230 defendant Joye Thomas   591656 591656 Joye, Thomas, of Walcote 0
4587778 2227582 2227582 defendant Carter Roger   591656 591656 Carter, Roger, of Walcote 7
4602804 2232091 2232091 defendant Dycon Thomas   591656 591656 Dycon, Thomas, of Walcote 0
4606350 2233102 2233102 defendant Deye Thomas   591656 591656 Deye, Thomas, of Walcote 0
4619687 2237142 2237142 defendant Deye Thomas   591656 591656 Deye, Thomas, of Walcote 0
4634313 2241576 2241576 defendant Catour John   591656 591656 Catour, John, of Walcote 1
4634872 2241759 2241759 defendant Gauns Nicholas   591656 591656 Gauns, Nicholas, of Walcote 0
4643109 2244094 2244094 defendant Smyth Henry   591656 591656 Smyth, Henry, of Walcote 0
4645647 2244791 2244791 defendant Hoges Thomas   591656 591656 Hoges, Thomas, of Walcote 0
4656086 2247783 2247783 defendant Deye William   591656 591656 Deye, William, of Walcote, swine drover 0
4664928 2250511 2250511 plaintiff Helwys John   591656 591656 Helwys, John, of Walcote 0
4674699 2257697 2257697 defendant Walcote John de gent 591656 591656 Walcote, John de, of Walcote, gent 0
4724998 2273113 2273113 defendant Goudeby John husbandman 591656 591656 Goudeby, John, of Walcote, husbandman 0
4738894 2277255 2277255 defendant Hoddes Thomas husbandman 591656 591656 Hoddes, Thomas, of Walcote, husbandman 1
4755197 2282013 2282013 defendant Shepherd John husbandman 591656 591656 Shepherd, John, of Walcote, husbandman 0
4765778 2285293 2285293 defendant Swarby John husbandman 591656 591656 Swarby, John, of Walcote, husbandman 1
4767557 2285831 2285831 defendant Mylys Geoffrey husbandman 591656 591656 Mylys, Geoffrey, of Walcote, husbandman 0
4776551 2288660 2288660 defendant Alyn Robert miller 591656 591656 Alyn, Robert, of Walcote, miller 0
4782293 2290465 2290465 defendant Vicory William husbandman 591656 591656 Vicory, William, of Walcote, husbandman 1
4790459 2293104 2293104 defendant Peper Walter husbandman 591656 591656 Peper, Walter, of Walcote, husbandman 0
4794109 2294292 2294292 defendant Bryghtred John   591656 591656 Bryghtred, John, of Walcote, wright 0
4804649 2297649 2297649 defendant Walcote John de   591656 591656 Walcote, John de, of Walcote 0
4887815 2323017 2323017 defendant Mayster John husbandman 591656 591656 Mayster, John, of Walcote, husbandman 1
4891697 2324145 2324145 defendant Mayster John husbandman 591656 591656 Mayster, John, of Walcote, husbandman 1
4900049 2326646 2326646 defendant Walcote William gent 591656 591656 Walcote, William, of Walcote, gent 0
4971851 2348512 2348512 defendant Hoddesson Richard clerk 591656 591656 Hoddesson, Richard, of Walcote, clerk 0
5008559 2359398 2359398 defendant ap Reryt Jerome husbandman 591656 591656 ap Reryt, Jerome, of Walcote, husbandman 1
5046022 2370438 2370438 plaintiff Lussell Henry   591656 591656 Lussell, Henry, of Walcote 0
5070247 2377594 2377594 defendant Parhaunt Robert husbandman 591656 591656 Parhaunt, Robert, of Walcote, husbandman 0
5070250 2377595 2377595 defendant Parhaunt Robert husbandman 591656 591656 Parhaunt, Robert, of Walcote, husbandman 0
5073517 2378563 2378563 plaintiff Walcote Thomas   591656 591656 Walcote, Thomas, of Walcote 1
5078412 2380041 2380041 defendant Newehous Adam husbandman 591656 591656 Newehous, Adam, of Walcote, husbandman 0
5099324 2386232 2386232 defendant Waver John gent 591656 591656 Waver, John, of Walcote, gent 0
5119225 2392050 2392050 plaintiff Fillyng Lawrence   591656 591656 Fillyng, Lawrence, of Walcote 1
5121285 2392660 2392660 defendant Raus or Rans Thomas husbandman 591656 591656 Raus or Rans, Thomas, of Walcote, husbandman 1
5135432 2396873 2396873 defendant Rede Simon tailor 591656 591656 Rede, Simon, of Walcote, tailor 2
5139006 2397900 2397900 plaintiff Fillyng Lawrence   591656 591656 Fillyng, Lawrence, of Walcote 1
5155680 2402819 2402819 defendant Rede Simon laborer 591656 591656 Rede, Simon, of Walcote, laborer 2
5160743 2404240 2404240 defendant Parant Roger laborer 591656 591656 Parant, Roger, of Walcote, laborer 1
5175433 2408508 2408508 defendant Parant Roger laborer 591656 591656 Parant, Roger, of Walcote, laborer 1
5190658 2413013 2413013 defendant Pulham John yeoman 591656 591656 Pulham, John, of Walcote, yeoman 0
5196634 2414770 2414770 defendant Paraunt Roger laborer 591656 591656 Paraunt, Roger, of Walcote, laborer 1

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