names

158 rows where place_id = 591010

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603001 1868606 1868606 defendant Jenyn Simon merchant 591010 591010 Jenyn, Simon, of Penryn, merchant 0
3603002 1868606 1868606 defendant Polgweste Richard stainer 591010 591010 Polgweste, Richard, of Penryn, stainer 1
3660974 1913704 1913704 defendant Dawe William husbandman 591010 591010 Dawe, William, of Penryn, husbandman 0
3662452 1914168 1914168 defendant Pyper Roger yeoman 591010 591010 Pyper, Roger, of Penryn, yeoman 0
3662453 1914168 1914168 defendant Roger John yeoman 591010 591010 Roger, John, of Penryn, yeoman 1
3663133 1914383 1914383 defendant Kellegrewe John gent 591010 591010 Kellegrewe, John, of Penryn, gent 0
3666259 1915395 1915395 defendant Tawarn John yeoman 591010 591010 Tawarn, John, of Penryn, yeoman 4
3671962 1917230 1917230 defendant Petytt Thomas gent 591010 591010 Petytt, Thomas, of Penryn, gent 0
3671965 1917231 1917231 defendant Weynam John yeoman 591010 591010 Weynam, John, of Penryn, yeoman 0
3671966 1917231 1917231 defendant Harry Thomas yeoman 591010 591010 Harry, Thomas, of Penryn, yeoman 1
3671967 1917231 1917231 defendant Robert Nicholas yeoman 591010 591010 Robert, Nicholas, of Penryn, yeoman 2
3681903 1920441 1920441 defendant Petyt Thomas gent 591010 591010 Petyt, Thomas, of Penryn, gent 0
3681905 1920441 1920441 defendant Weynam John yeoman 591010 591010 Weynam, John, of Penryn, yeoman 2
3681906 1920441 1920441 defendant Harry Thomas yeoman 591010 591010 Harry, Thomas, of Penryn, yeoman 3
3681907 1920441 1920441 defendant Robert Nicholas yeoman 591010 591010 Robert, Nicholas, of Penryn, yeoman 4
3688027 1922417 1922417 defendant Petit Thomas gent 591010 591010 Petit, Thomas, of Penryn, gent 0
3688028 1922417 1922417 defendant Vynan Thomas yeoman 591010 591010 Vynan, Thomas, of Penryn, yeoman 1
3689263 1922803 1922803 plaintiff Enys Thomas   591010 591010 Enys, Thomas, of Penryn 0
3692569 1923862 1923862 defendant Perys Henry pewterer 591010 591010 Perys, Henry, of Penryn, pewterer 2
3696259 1925051 1925051 defendant Prowte Roger smith 591010 591010 Prowte, Roger, of Penryn, smith 2
3717855 1931887 1931887 plaintiff Enys Thomas   591010 591010 Enys, Thomas, of Penryn 0
3717858 1931887 1931887 defendant Jerret John mercer 591010 591010 Jerret, John, of Penryn, mercer 2
3717859 1931887 1931887 defendant Harry John yeoman 591010 591010 Harry, John, of Penryn, yeoman 3
3721101 1932897 1932897 defendant Collogger Thomas mercer 591010 591010 Collogger, Thomas, of Penryn, mercer 0
3721104 1932897 1932897 defendant Love John cordwainer 591010 591010 Love, John, of Penryn, cordwainer 3
3721105 1932897 1932897 defendant Enys Michael   591010 591010 Enys, Michael, of Penryn, groom 4
3729871 1935598 1935598 defendant Kyrrye Reginald tailor 591010 591010 Kyrrye, Reginald, of Penryn, tailor 3
3729872 1935598 1935598 defendant Pascowe John fisher 591010 591010 Pascowe, John, of Penryn, fisher 4
3733616 1936758 1936758 defendant Richard Michael John laborer 591010 591010 Richard, Michael John, of Penryn, laborer 2
3733621 1936758 1936758 defendant Willay John tanner 591010 591010 Willay, John, of Penryn, tanner 7
3733622 1936758 1936758 defendant Botterell Otis   591010 591010 Botterell, Otis, of Penryn, mason 8
3733623 1936758 1936758 defendant Pastowe or Pascowe John smith 591010 591010 Pastowe or Pascowe, John, of Penryn, smith 9
3733624 1936758 1936758 defendant Gerard John mercer 591010 591010 Gerard, John, of Penryn, mercer 10
3742683 1939583 1939583 defendant Guys or Enys Thomas   591010 591010 Guys or Enys, Thomas, of Penryn, franklin 0
3764916 1946692 1946692 defendant Wennyng Thomas husbandman 591010 591010 Wennyng, Thomas, of Penryn, husbandman 1
3770233 1948358 1948358 defendant Morell Henry yeoman 591010 591010 Morell, Henry, of Penryn, yeoman 1
3775335 1950025 1950025 plaintiff Nycoll John   591010 591010 Nycoll, John, of Penryn 3
3782903 1952396 1952396 defendant Wemyng Thomas husbandman 591010 591010 Wemyng, Thomas, of Penryn, husbandman 1
3790017 1954699 1954699 defendant Enys Thomas   591010 591010 Enys, Thomas, of Penryn, franklin 0
3794351 1956110 1956110 defendant Knyth William   591010 591010 Knyth, William, of Penryn, fish hook maker 0
3848826 1973221 1973221 defendant Carvanell William yeoman of the guard 591010 591010 Carvanell, William, of Penryn, yeoman of the guard 2
3851635 1974099 1974099 defendant Carnsewe William merchant 591010 591010 Carnsewe, William, of Penryn, merchant 0
3869039 1979889 1979889 defendant Bevylle James gent 591010 591010 Bevylle, James, of Penryn, gent 0
3874477 1981692 1981692 defendant Harrys Richard   591010 591010 Harrys, Richard, of Penryn, tin merchant 1
3874512 1981697 1981697 defendant Harrys Richard   591010 591010 Harrys, Richard, of Penryn, tin merchant 1
3888523 1986418 1986418 defendant Nane or Nave John yeoman 591010 591010 Nane or Nave, John, of Penryn, yeoman 0
3897156 1989266 1989266 defendant Nans John yeoman 591010 591010 Nans, John, of Penryn, yeoman 1
3915878 1995689 1995689 defendant Boyer John yeoman 591010 591010 Boyer, John, of Penryn, yeoman 0
3916190 1995800 1995800 defendant Carvanell Alexander yeoman 591010 591010 (Carvanell, Alexander, of Penryn, yeoman 1
3930530 2000554 2000554 defendant Odger Stephen miller 591010 591010 Odger, Stephen, of Penryn, miller 1
3930531 2000554 2000554 defendant Udy Henry miller 591010 591010 Udy, Henry, of Penryn, miller 2
3954948 2008793 2008793 defendant Bonythen Edmund gent 591010 591010 Bonythen, Edmund, of Penryn, gent 0
3954949 2008793 2008793 defendant Skemynyan Colea widow 591010 591010 Skemynyan, Colea, of Penryn, widow 1
3965760 2012641 2012641 defendant Gybbes John Laborer 591010 591010 Gybbes, John, of Penryn, Laborer 3
3965761 2012641 2012641 defendant Pound Thomas sherman 591010 591010 Pound, Thomas, of Penryn, sherman 4
3994707 2022858 2022858 defendant Mackyng alis Bruar Martin husbandman 591010 591010 Mackyng alis Bruar, Martin, of Penryn, husbandman 0
4002751 2025750 2025750 defendant Fyttacke Philip yeoman 591010 591010 Fyttacke, Philip, of Penryn, yeoman 2
4005541 2026756 2026756 defendant Graye Simon husbandman 591010 591010 Graye, Simon, of Penryn, husbandman 0
4011140 2028751 2028751 defendant Bowyer John yeoman 591010 591010 Bowyer, John, of Penryn, yeoman 4
4136733 2073485 2073485 defendant Killigrewe Peter esq 591010 591010 Killigrewe, Peter, of Penryn, esq 1
4156350 2080294 2080294 defendant Woode William vintner 591010 591010 Woode, William, of Penryn, vintner 0
4176685 2087315 2087315 defendant Alexander John carpenter 591010 591010 Alexander, John, of Penryn, carpenter 0
4182371 2089308 2089308 defendant Hall Roger yeoman 591010 591010 Hall, Roger, of Penryn, yeoman 0
4182639 2089407 2089407 defendant Hooper John husbandman 591010 591010 Hooper, John, of Penryn, husbandman 0
4188248 2091391 2091391 defendant Allyn Michael yeoman 591010 591010 Allyn, Michael, of Penryn, yeoman 2
4205955 2097626 2097626 defendant Hall Roger yeoman 591010 591010 Hall, Roger, of Penryn, yeoman 0
4214793 2100680 2100680 defendant Cowche Ralph gent 591010 591010 Cowche, Ralph, of Penryn, gent 1
4235618 2108027 2108027 defendant Gadscombe John husbandman 591010 591010 Gadscombe, John, of Penryn, husbandman 0
4235619 2108027 2108027 defendant Axforde Richard husbandman 591010 591010 Axforde, Richard, of Penryn, husbandman 1
4244641 2111193 2111193 defendant Wearne James husbandman 591010 591010 Wearne, James, of Penryn, husbandman 0
4244642 2111193 2111193 defendant Bewse Thomas yeoman 591010 591010 Bewse, Thomas, of Penryn, yeoman 1
4273009 2120533 2120533 defendant Mondye Anthony gent 591010 591010 Mondye, Anthony, of Penryn, gent 0
4279566 2122769 2122769 defendant Pascowe William merchant 591010 591010 Pascowe, William, of Penryn, merchant 0
4279567 2122769 2122769 defendant Proves Thomas merchant 591010 591010 Proves, Thomas, of Penryn, merchant 1
4283877 2124273 2124273 defendant ap Owen David ap John ap Gruff   591010 591010 ap Owen, David ap John ap Gruff, of Penryn, gent, administrators of 1
4283878 2124273 2124273 defendant ap Owen John ap Cadwalader gent 591010 591010 (ap Owen, John ap Cadwalader, of Penryn, gent 2
4297180 2129094 2129094 defendant Pascowe William merchant 591010 591010 Pascowe, William, of Penryn, merchant 0
4297181 2129094 2129094 defendant Proves Thomas merchant 591010 591010 Proves, Thomas, of Penryn, merchant 1
4310766 2133908 2133908 defendant Cowche Ralph gent 591010 591010 Cowche, Ralph, of Penryn, gent 0
4324597 2138618 2138618 defendant Cowche Ralph gent 591010 591010 Cowche, Ralph, of Penryn, gent 0
4362272 2151555 2151555 defendant Ryder George yeoman 591010 591010 Ryder, George, of Penryn, yeoman 0
4438090 2181213 2181213 plaintiff Amydeu John   591010 591010 Amydeu, John, of Penryn 0
4519974 2206585 2206585 defendant Northwode John   591010 591010 Northwode, John, of Penryn 0
4519976 2206585 2206585 defendant Polgeren John, sen   591010 591010 Polgeren, John, sen, of Penryn 2
4519979 2206585 2206585 defendant Helier Nicholas   591010 591010 Helier, Nicholas, of Penryn 5
4519980 2206585 2206585 defendant Man John   591010 591010 Man, John, of Penryn 6
4519981 2206585 2206585 defendant Taillour David   591010 591010 Taillour, David, of Penryn 7
4519982 2206585 2206585 defendant Skynner Nicholas   591010 591010 Skynner, Nicholas, of Penryn 8
4519983 2206585 2206585 defendant Tybot Richard   591010 591010 Tybot, Richard, of Penryn 9
4572198 2222852 2222852 defendant Caleys Thomas   591010 591010 Caleys, Thomas, of Penryn 10
4577705 2224533 2224533 defendant Beauchamp John   591010 591010 Beauchamp, John, of Penryn 0
4578239 2224692 2224692 defendant Gilbert Henry   591010 591010 Gilbert, Henry, of Penryn 0
4609848 2234175 2234175 defendant Wilcok John   591010 591010 Wilcok, John, of Penryn 1
4618835 2236886 2236886 plaintiff Cornys John   591010 591010 Cornys, John, of Penryn 1
4621009 2237555 2237555 defendant Penbro Michael   591010 591010 Penbro, Michael, of Penryn 0
4626280 2239178 2239178 defendant Bloyowe John   591010 591010 Bloyowe, John, of Penryn 0
4626285 2239179 2239179 defendant Bloyowe John   591010 591010 together with Bloyowe, John, of Penryn 3
4666641 2251049 2251049 defendant Polleskeu John butcher 591010 591010 Polleskeu, John, of Penryn, butcher 3
4666642 2251049 2251049 defendant William James weaver 591010 591010 William, James, of Penryn, weaver 4
4681509 2259830 2259830 defendant Rosmorda Eleanor widow 591010 591010 Rosmorda, Eleanor, of Penryn, widow 2

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