names

73 rows where place_id = 597064

✎ 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
3627157 1903351 1903351 defendant Trejer Udo tailor 597064 597064 Trejer, Udo, of Redruth, tailor 1
3655153 1911872 1911872 defendant Hervy William yeoman 597064 597064 Hervy, William, of Redruth, yeoman 3
3701230 1926629 1926629 defendant Laurens Jake or James husbandman 597064 597064 Laurens, Jake or James, of Redruth, husbandman 1
3701231 1926629 1926629 defendant Thomas John laborer 597064 597064 Thomas, John, of Redruth, laborer 2
3714819 1930936 1930936 defendant Richard William husbandman 597064 597064 Richard, William, of Redruth, husbandman 0
3717833 1931882 1931882 defendant Trenowyth John husbandman 597064 597064 Trenowyth, John, of Redruth, husbandman 0
3782902 1952396 1952396 defendant Trenowyth John husbandman 597064 597064 Trenowyth, John, of Redruth, husbandman 0
3782906 1952396 1952396 defendant Smyth Nicholas smith 597064 597064 Smyth, Nicholas, of Redruth, smith 4
3782907 1952396 1952396 defendant Roger William husbandman 597064 597064 Roger, William, of Redruth, husbandman 5
3786531 1953580 1953580 defendant Mercer John tinner 597064 597064 Mercer, John, of redruth, tinner 0
3787524 1953888 1953888 defendant Parkyn George husbandman 597064 597064 Parkyn, George, of Redruth, husbandman 0
3879569 1983416 1983416 defendant Skevereaw John, junior husbandman 597064 597064 Skevereaw, John, junior, of Redruth, husbandman 0
3879571 1983417 1983417 defendant Skevereaw John, junior husbandman 597064 597064 Skevereaw, John, junior, of Redruth, husbandman 0
3887954 1986221 1986221 defendant Lyell John laborer 597064 597064 Lyell, John, of Redruth, laborer 0
3887955 1986221 1986221 defendant Foterell John laborer 597064 597064 Foterell, John, of Redruth, laborer 1
3901934 1990874 1990874 defendant Fotell John laborer 597064 597064 Fotell, John, of Redruth, laborer 1
3941119 2004032 2004032 defendant William Jerman alias Angeve smith 597064 597064 William, Jerman alias Angeve, of Redruth, smith 0
3960958 2010931 2010931 defendant Remfrey George tinner 597064 597064 Remfrey, George, of Redruth, tinner 1
4018672 2031411 2031411 defendant Renfrye Henry husbandman 597064 597064 Renfrye, Henry, of Redruth, husbandman 3
4294279 2128031 2128031 defendant Pennarth William husbandman 597064 597064 Pennarth, William, of Redruth, husbandman 0
4294280 2128031 2128031 defendant Hawes John husbandman 597064 597064 Hawes, John, of Redruth, husbandman 1
4294281 2128031 2128031 defendant Tynner Roger husbandman 597064 597064 Tynner, Roger, of Redruth, husbandman 2
4516942 2205704 2205704 defendant Geffre John   597064 597064 Geffre, John, of Redruth 0
4526355 2208523 2208523 defendant Goof Ralph   597064 597064 Goof, Ralph, of Redruth 11
4526367 2208524 2208524 defendant Goof Ralph   597064 597064 Goof, Ralph, of Redruth 9
4543220 2213763 2213763 defendant Gerveys John   597064 597064 Gerveys, John, of Redruth 2
4554982 2217486 2217486 plaintiff Harry Joan   597064 597064 Harry, Joan, of Redruth, formerly wife of John 0
4554983 2217486 2217486 defendant Jolyf Thomas   597064 597064 Jolyf, Thomas, of Redruth 0
4610104 2234248 2234248 defendant Jolyf Nicholas   597064 597064 Jolyf, Nicholas, of Redruth 0
4661604 2249465 2249465 defendant Geffrey John   597064 597064 Geffrey, John, of Redruth 0
4687097 2261569 2261569 defendant Trerys John   597064 597064 Trerys, John, of Redruth, mason 0
4699189 2265210 2265210 defendant Vyvyan Lawrence husbandman 597064 597064 Vyvyan, Lawrence, of Redruth, husbandman 2
4709428 2268304 2268304 plaintiff Penpone John   597064 597064 Penpone, John, of Redruth 0
4709432 2268305 2268305 defendant Bast John husbandman 597064 597064 Bast, John, of Redruth, husbandman 1
4712123 2269102 2269102 defendant Trerys John   597064 597064 Trerys, John, of Redruth, mason 0
4729812 2274525 2274525 defendant Cardrewe Peter husbandman 597064 597064 Cardrewe, Peter, of Redruth, husbandman 2
4738751 2277209 2277209 defendant Joyf Nicholas tinner 597064 597064 Joyf, Nicholas, of Redruth, tinner 0
4738753 2277209 2277209 defendant Pastowe Thomas husbandman 597064 597064 Pastowe, Thomas, of Redruth, husbandman 2
4796713 2295125 2295125 defendant Wynan or Wyvan Thomas husbandman 597064 597064 Wynan or Wyvan, Thomas, of Redruth, husbandman 0
4872868 2318466 2318466 defendant Treru Walter husbandman 597064 597064 Treru, Walter, of Redruth, husbandman 3
4874843 2319072 2319072 defendant Hamly Thomas   597064 597064 Hamly, Thomas, of Redruth, groom 3
4879147 2320415 2320415 defendant Penpons Richard gent 597064 597064 Penpons, Richard, of Redruth, gent 0
4879149 2320416 2320416 defendant Penpons Richard gent 597064 597064 Penpons, Richard, of Redruth, gent 0
4892039 2324247 2324247 defendant Turne Walter husbandman 597064 597064 Turne, Walter, of Redruth, husbandman 3
4899952 2326622 2326622 defendant Penpons Richard gent 597064 597064 Penpons, Richard, of Redruth, gent 0
4902832 2327500 2327500 defendant Kembre Robert yeoman 597064 597064 Kembre, Robert, of Redruth, yeoman 7
4930661 2335999 2335999 defendant Penpons Richard gent 597064 597064 Penpons, Richard, of Redruth, gent 0
4930663 2336000 2336000 defendant Penpons Richard gent 597064 597064 Penpons, Richard, of Redruth, gent 0
4943410 2339909 2339909 defendant Goff John smith 597064 597064 Goff, John, of Redruth, smith 4
4943416 2339910 2339910 defendant Goff John smith 597064 597064 Goff, John, of Redruth, smith 4
4956107 2343790 2343790 defendant Penpons Richard gent 597064 597064 Penpons, Richard, of Redruth, gent 0
4991839 2354444 2354444 defendant Cornowe Michael butcher 597064 597064 Cornowe, Michael, of Redruth, butcher 2
5162044 2404633 2404633 defendant Laurens Arthur husbandman 597064 597064 Laurens, Arthur, of Redruth, husbandman 2
5179693 2409799 2409799 defendant Laurence Arthur yeoman 597064 597064 Laurence, Arthur, of Redruth, yeoman 1
5249336 2429924 2429924 defendant Baker John yeoman 597064 597064 Baker, John, of Redruth, yeoman 2
5274190 2437533 2437533 defendant Wodeward Robert husbandman 597064 597064 Wodeward, Robert, of Redruth, husbandman 0
5274191 2437533 2437533 defendant Watkyn Richard husbandman 597064 597064 Watkyn, Richard, of Redruth, husbandman 1
5274192 2437533 2437533 defendant Hiknansowe John husbandman 597064 597064 Hiknansowe, John, of Redruth, husbandman 2
5274193 2437533 2437533 defendant Angogh John husbandman 597064 597064 Angogh, John, of Redruth, husbandman 3
5274194 2437533 2437533 defendant Alan John clerk 597064 597064 Alan, John, of Redruth, clerk 4
5274195 2437533 2437533 defendant Edward William husbandman 597064 597064 Edward, William, of Redruth, husbandman 5
5274196 2437533 2437533 defendant Perkyn Walter husbandman 597064 597064 Perkyn, Walter, of Redruth, husbandman 6
5274197 2437533 2437533 defendant Cardrewe Randolf husbandman 597064 597064 Cardrewe, Randolf, of Redruth, husbandman 7
5274198 2437533 2437533 defendant Cardrewe John husbandman 597064 597064 Cardrewe, John, of Redruth, husbandman 8
5274199 2437533 2437533 defendant Laurence Henry husbandman 597064 597064 Laurence, Henry, of Redruth, husbandman 9
5319343 2450879 2450879 defendant Wodewall Robert yeoman 597064 597064 Wodewall, Robert, of Redruth, yeoman 3
5320681 2451280 2451280 defendant Wodewall Robert yeoman 597064 597064 Wodewall, Robert, of Redruth, yeoman 3
5326104 2452900 2452900 defendant Wodewall Robert yeoman 597064 597064 Wodewall, Robert, of Redruth, yeoman 3
5478850 2498694 2498694 defendant Nicoll Harvy laborer 597064 597064 Nicoll, Harvy, of Redruth, laborer 0
5478851 2498694 2498694 defendant Hervy William laborer 597064 597064 Hervy, William, of Redruth, laborer 1
5478852 2498694 2498694 defendant Cardrew Renfrew laborer 597064 597064 Cardrew, Renfrew, of Redruth, laborer 2
5478853 2498694 2498694 defendant Cardrewe John laborer 597064 597064 Cardrewe, John, of Redruth, laborer 3
5634157 2554668 2554668 defendant Trefula John yeoman 597064 597064 Trefula, John, of Redruth, yeoman 2

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