names

122 rows where place_id = 600523

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599916 1867629 1867629 defendant Paule Richard husbandman 600523 600523 Paule, Richard, of St Columbe, husbandman 0
3599921 1867630 1867630 defendant Paule Richard husbandman 600523 600523 Paule, Richard, of St Columbe le Over, husbandman 1
3615382 1872454 1872454 defendant Stephyn Richard cordwainer 600523 600523 Stephyn, Richard, of St Columbe le Over, cordwainer 0
3641371 1907755 1907755 defendant Herrys John gent 600523 600523 Herrys, John, of St Columbe the Over, gent 0
3641374 1907755 1907755 defendant Peryn William butcher 600523 600523 Peryn, William, of St Columbe the Over, butcher 3
3649064 1910099 1910099 defendant Body John husbandman 600523 600523 Body, John, of St Columbe the Over, husbandman 0
3649065 1910099 1910099 defendant Pyper Peter husbandman 600523 600523 Pyper, Peter, of St Columbe the Over, husbandman 1
3651031 1910688 1910688 defendant Robyn Mark weaver 600523 600523 Robyn, Mark, of St Columbe the Over, weaver 0
3663915 1914655 1914655 defendant Robyn Mark butcher 600523 600523 Robyn, Mark, of St Columbe, butcher 0
3680596 1920011 1920011 defendant Luke John husbandman 600523 600523 Luke, John, of St Columbe le Over, husbandman 5
3700986 1926558 1926558 defendant Michell John gent 600523 600523 Michell, John, of St Columbe the Over, gent 0
3704488 1927700 1927700 defendant Gobyll Thomas mercer 600523 600523 Gobyll, Thomas, of St Columbe le Over, mercer 0
3706615 1928353 1928353 defendant Trelawgan Ralph husbandman 600523 600523 Trelawgan, Ralph, of St Columbe le Nether, husbandman 0
3706616 1928353 1928353 defendant Trelawgan John husbandman 600523 600523 Trelawgan, John, of St Columbe le Nether, husbandman 1
3729679 1935534 1935534 defendant Gobull Thomas chapman 600523 600523 Gobull, Thomas, of St Columbe le Over, chapman 0
3729813 1935580 1935580 defendant Bastard John Roche tinner 600523 600523 Bastard, John Roche, of St Columbe le Over, tinner 2
3746301 1940756 1940756 defendant Bavdyn Reginald cordwainer 600523 600523 Bavdyn, Reginald, of St Columbe the Over, cordwainer 0
3754659 1943414 1943414 defendant Teacke Richard husbandman 600523 600523 Teacke, Richard, of St Columbe le Over, husbandman 0
3754660 1943414 1943414 defendant Peryn William husbandman 600523 600523 Peryn, William, of St Columbe, husbandman 1
3754664 1943416 1943416 defendant Peryn William husbandman 600523 600523 Peryn, William, of St Columbe le Over, husbandman 0
3754666 1943417 1943417 defendant Teacke Richard husbandman 600523 600523 Teacke, Richard, of St Columbe le Over, husbandman 0
3757403 1944296 1944296 defendant Pawle Robert   600523 600523 Pawle, Robert, of St Columbe the Over, groom 0
3757404 1944296 1944296 defendant Reterrek Thomas husbandman 600523 600523 Reterrek, Thomas, of St Columbe the Over, husbandman 1
3757405 1944296 1944296 defendant Michell Richard   600523 600523 Michell, Richard, of St Columbe the Over, groom 2
3757406 1944296 1944296 defendant Corveser Edward shoemaker 600523 600523 Corveser, Edward, of St Columbe the Over, shoemaker 3
3765629 1946915 1946915 defendant Retorrek Thomas, senior tailor 600523 600523 Retorrek, Thomas, senior, of St Columbe the Over, tailor 0
3765630 1946915 1946915 defendant Retorrek Thomas, junior   600523 600523 Retorrek, Thomas, junior, of St Columbe the Over, groom 1
3765631 1946915 1946915 defendant Powle Robert   600523 600523 Powle, Robert, of St Columbe the Over, groom 2
3765632 1946915 1946915 defendant Boddyscastell Nicholas husbandman 600523 600523 Boddyscastell, Nicholas, of St Columbe the Over, husbandman 3
3765633 1946915 1946915 defendant Michell Richard yeoman 600523 600523 Michell, Richard, of St Columbe the Over, yeoman 4
3766505 1947182 1947182 defendant Luky William husbandman 600523 600523 Luky, William, of St Columbe the Nether, husbandman 1
3778202 1950890 1950890 defendant Robert Richard yeoman 600523 600523 Robert, Richard, of St Columbe the Nether, yeoman 0
3778203 1950890 1950890 defendant Robert Thomas husbandman 600523 600523 Robert, Thomas, of St Columbe the Nether, husbandman 1
3783966 1952764 1952764 defendant Bette William yeoman 600523 600523 Bette, William, of St Columbe, yeoman 0
3784720 1953009 1953009 defendant Cole Nicholas smith 600523 600523 Cole, Nicholas, of St Columbe the Over, smith 1
3800242 1957996 1957996 defendant Michell John merchant 600523 600523 Michell, John, of St Columbe the Over, merchant 0
3806730 1960004 1960004 defendant Tommyowe Thomas gent 600523 600523 Tommyowe, Thomas, of St Columbe the Over, gent 0
3816114 1962941 1962941 defendant Colwey "Lollalum" yeoman 600523 600523 Colwey, "Lollalum", of St Columbe the Over, yeoman 0
3824361 1965490 1965490 defendant Tymmyowe Thomas gent 600523 600523 Tymmyowe, Thomas, of St Columbe the Over, gent 0
3824757 1965616 1965616 defendant Rowe John smith 600523 600523 Rowe, John, of St Columbe the Over, smith 0
3839199 1970186 1970186 defendant Gobell Emot widow 600523 600523 Gobell, Emot, of St Columbe the Over, widow 0
3840633 1970635 1970635 defendant Darre Richard husbandman 600523 600523 Darre, Richard, of St Columbe the Over, husbandman 0
3845867 1972262 1972262 defendant Rawe John smith 600523 600523 Rawe, John, of St Columbe the Over, smith 0
3849157 1973332 1973332 defendant Peryn William yeoman 600523 600523 Peryn, William, of St Columbe the Over, yeoman 4
3852228 1974297 1974297 defendant Mayow Richard husbandman 600523 600523 Mayow, Richard, of St Columbe the Over, husbandman 1
3852454 1974374 1974374 defendant Powle Robert yeoman 600523 600523 Powle, Robert, of St Columbe the Over, yeoman 3
3856521 1975666 1975666 defendant Gobyll Emota widow 600523 600523 Gobyll, Emota, of St Columbe the Over, widow 3
3866232 1978931 1978931 defendant Engoff Nicholas husbandman 600523 600523 Engoff, Nicholas, of St Columbe the Nether, husbandman 2
3880552 1983754 1983754 defendant Trevysicke John gent 600523 600523 Trevysicke, John, of St Columbe the Nether, gent 0
3892316 1987680 1987680 defendant Teak Rawlin yeoman 600523 600523 Teak, Rawlin, of St Columbe le Over, yeoman 0
3892317 1987680 1987680 defendant Meryfeld Thomas gent 600523 600523 Meryfeld, Thomas, of St Columbe le Over, gent 1
3892319 1987680 1987680 defendant Tomyowe Thomas esq 600523 600523 Tomyowe, Thomas, of St Columbe le Over, esq 3
3914682 1995254 1995254 defendant Bayly George yeoman 600523 600523 Bayly, George, of St Columbe the Nether, yeoman 1
3931560 2000854 2000854 defendant Rawlyn alias Scrivener Thomas husbandman 600523 600523 Rawlyn alias Scrivener, Thomas, of St Columbe, husbandman 3
3960937 2010924 2010924 defendant Mayowe Thomas husbandman 600523 600523 Mayowe, Thomas, of St Columbe the Over, husbandman 1
4180840 2088778 2088778 defendant Sprey Richard, senior potter 600523 600523 Sprey, Richard, senior, of St Columbe le Higher, potter 0
4251911 2113629 2113629 defendant Calway John gent 600523 600523 Calway, John, of St Columbe le Hyer, gent 0
4251913 2113630 2113630 defendant Calwaye John gent 600523 600523 Calwaye, John, of St Columbe le Hyer, gent 0
4585905 2227016 2227016 plaintiff Haukyn Lawrence   600523 600523 Haukyn, Lawrence, of St Columbe, parson 0
4857608 2313767 2313767 defendant Coth Michael skinner 600523 600523 Coth, Michael, of St Columbe the Over, skinner 3
4959397 2344777 2344777 defendant Hikkewarchy John husbandman 600523 600523 Hikkewarchy, John, of St Columbe the Nether, husbandman 1
5097923 2385822 2385822 defendant James John smith 600523 600523 James, John, of St Columbe the Over, smith 6
5198372 2415275 2415275 defendant Shirdewyne John   600523 600523 Shirdewyne, John, of St Columbe, the Over or Higher, shoe maker 0
5210502 2418806 2418806 defendant Shirdewyne John shoemaker 600523 600523 Shirdewyne, John, of St Columbe the Over, shoemaker 0
5210505 2418807 2418807 defendant Shirdewyne John   600523 600523 Shirdewyne, John, of St Columbe the Over, shoe maker 0
5261591 2433736 2433736 defendant Cruqowe Thomas husbandman 600523 600523 Cruqowe, Thomas, of St Columbe the Over, husbandman 1
5261592 2433736 2433736 defendant Tomyowe Lawrence husbandman 600523 600523 Tomyowe, Lawrence, of St Columbe the Over, husbandman 2
5261597 2433736 2433736 defendant Watte John husbandman 600523 600523 Watte, John, of St Columbe the Over, husbandman 7
5266039 2435129 2435129 defendant Peen William skinner 600523 600523 Peen, William, of St Columbe the Over, skinner 4
5295207 2443590 2443590 defendant Michell Thomas mercer 600523 600523 Michell, Thomas, of St Columbe the Over, mercer 1
5295208 2443590 2443590 defendant Tregher Thomas tailor 600523 600523 Tregher, Thomas, of St Columbe the Over, tailor 2
5310108 2448054 2448054 defendant Michell Thomas mercer 600523 600523 Michell, Thomas, of St Columbe the Over, mercer 2
5310109 2448054 2448054 defendant Tragher Thomas tailor 600523 600523 Tragher, Thomas, of St Columbe, the Over, tailor 3
5322348 2451760 2451760 plaintiff Michell John (legal representative) 600523 600523 Michell, John, of St Columbe, executor of 0
5322350 2451760 2451760 defendant Crugowe Thomas   600523 600523 Crugowe, Thomas, of St Columbe le Over, franklin 0
5328637 2453645 2453645 defendant Moyll Odo yeoman 600523 600523 Moyll, Odo, of St Columbe the Over, yeoman 2
5328643 2453646 2453646 defendant Moyll Odo yeoman 600523 600523 Moyll, Odo, of St Columbe the Over, yeoman 2
5337270 2456219 2456219 defendant Moyle Odo merchant 600523 600523 Moyle, Odo, of St Columbe the Over, merchant 0
5337271 2456219 2456219 defendant Moone Stephen smith 600523 600523 Moone, Stephen, of St Columbe the Over, smith 1
5359555 2463023 2463023 defendant Moyle Odo husbandman 600523 600523 Moyle, Odo, of St Columbe the Over, husbandman 2
5386891 2471314 2471314 defendant Trebarwyth Thomas husbandman 600523 600523 Trebarwyth, Thomas, of St Columbe, husbandman 0
5424528 2482306 2482306 defendant Moyle Odo gent 600523 600523 Moyle, Odo, of St Columbe the Over, gent 0
5426991 2483007 2483007 defendant Gregory Ralph husbandman 600523 600523 Gregory, Ralph, of St Columbe, husbandman 3
5483889 2500123 2500123 defendant Trypkunyn Walter gent 600523 600523 Trypkunyn, Walter, of St Columbe the Over, gent 1
5492629 2502708 2502708 defendant William Joan widow 600523 600523 William, Joan, of St Columbe the Over, widow 3
5498954 2504623 2504623 defendant Tregoys Thomas gent 600523 600523 Tregoys, Thomas, of St Columbe the Over, gent 0
5502503 2505701 2505701 defendant Carn or Carver Vivian husbandman 600523 600523 Carn or Carver, Vivian, of St Columbe the Over, husbandman 3
5516698 2510048 2510048 defendant Tregoys Thomas gent 600523 600523 Tregoys, Thomas, of St Columbe the Over, gent 0
5517210 2510217 2510217 defendant Tregoys Thomas gent 600523 600523 Tregoys, Thomas, of St Columbe the Over, gent 0
5519620 2510968 2510968 defendant Coswaron Richard   600523 600523 Coswaron, Richard, of St Columbe, franklin 0
5519627 2510971 2510971 defendant Cofaron or Bofaron Richard yeoman 600523 600523 Cofaron or Bofaron, Richard, of St Columbe the Over, yeoman 1
5520961 2511376 2511376 defendant Coyswaryn Richard gent 600523 600523 Coyswaryn, Richard, of St Columbe the Over, gent 0
5520963 2511377 2511377 defendant Pawele Richard husbandman 600523 600523 Pawele, Richard, of St Columbe the Over, husbandman 0
5532305 2514645 2514645 defendant Michell John, junior   600523 600523 Michell, John, junior, of St Columbe the Over, gent, son of Michell, John, senior 0
5542260 2517711 2517711 defendant Retalek Reginald husbandman 600523 600523 Retalek, Reginald, of St Columbe le Over, husbandman 0
5542262 2517711 2517711 defendant Pawele John husbandman 600523 600523 Pawele, John, of St Columbe le Over, husbandman 2
5542263 2517711 2517711 defendant Retalek Robert husbandman 600523 600523 Retalek, Robert, of St Columbe le Over, husbandman 3
5542830 2517878 2517878 defendant Raulyn Mark husbandman 600523 600523 Raulyn, Mark, of St Columbe le Over, husbandman 0
5545750 2518748 2518748 defendant Sherthewynde Ranfrew glover 600523 600523 Sherthewynde, Ranfrew, of St Columbe le Ober, glover 0
5546306 2518916 2518916 defendant Michell John, junior   600523 600523 Michell, John, junior, of St Columbe le Over, gent, son of Michell, John 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);