names

78 rows where place_id = 608440

✎ 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
3673712 1917805 1917805 defendant Heywod Simon yeoman 608440 608440 Heywod, Simon, of Whytchurche, yeoman 1
3682959 1920785 1920785 defendant Rawe Richard yeoman 608440 608440 Rawe, Richard, of Whytchurche, yeoman 0
3759734 1945037 1945037 plaintiff Collys Richard yeoman 608440 608440 Collys, Richard, of Whytchurche, yeoman 0
3765704 1946939 1946939 defendant Wylson John husbandman 608440 608440 Wylson, John, of Whytchurche, husbandman 3
3769349 1948069 1948069 defendant Sutton Thomas husbandman 608440 608440 Sutton, Thomas, of Whytchurche, husbandman 3
3776143 1950282 1950282 defendant Alee John tailor 608440 608440 Alee, John, of Whytchurche, tailor 0
3776144 1950282 1950282 defendant Barefote William mercer 608440 608440 Barefote, William, of Whytchurche, mercer 1
3847821 1972895 1972895 defendant More Otto yeoman 608440 608440 More, Otto, of Whytchurche, yeoman 2
3865532 1978690 1978690 defendant Nevet Thomas husbandman 608440 608440 Nevet, Thomas, of Whytchurche, husbandman 0
3874229 1981602 1981602 defendant Wylson John yeoman 608440 608440 Wylson, John, of Whytchurche, yeoman 4
3891883 1987537 1987537 defendant Jones William clerk 608440 608440 Jones, William, of Whytchurche, clerk 0
3914134 1995073 1995073 defendant Spry Thomas husbandman 608440 608440 Spry, Thomas, of Whytchurche, husbandman 0
3915485 1995548 1995548 defendant Platt Richard husbandman 608440 608440 Platt, Richard, of Whytchurche, husbandman 2
3925819 1998953 1998953 defendant Wykystyde William yeoman 608440 608440 Wykystyde, William, of Whytchurche, yeoman 0
3929395 2000177 2000177 defendant Gyll John gent 608440 608440 Gyll, John, of Whytchurche, gent 0
3929396 2000177 2000177 defendant Kegyll John husbandman 608440 608440 Kegyll, John, of Whytchurche, husbandman 1
3933946 2001653 2001653 defendant Kente John smith 608440 608440 Kente, John, of Whytchurche, smith 0
3938824 2003326 2003326 defendant Hamond William yeoman 608440 608440 Hamond, William, of Whytchurche, yeoman 0
3946235 2005761 2005761 defendant Chydlowe William gent 608440 608440 Chydlowe, William, of Whytchurche, gent 5
3951919 2007733 2007733 defendant Howper Elizeus or Elias husbandman 608440 608440 Howper, Elizeus or Elias, of Whytchurche, husbandman 0
3951921 2007734 2007734 defendant Goodyng John yeoman 608440 608440 Goodyng, John, of Whytchurche, yeoman 0
3966953 2013073 2013073 defendant Cotton John tanner 608440 608440 Cotton, John, of Whytchurche, tanner 1
3966954 2013073 2013073 defendant Cotton Roger mercer 608440 608440 Cotton, Roger, of Whytchurche, mercer 2
3983028 2018708 2018708 defendant Edmonde Richard husbandman 608440 608440 Edmonde, Richard, of Whytchurche, husbandman 0
4008792 2027905 2027905 defendant Hopkyn George husbandman 608440 608440 Hopkyn, George, of Whytchurche, or of the Newe Woodhowse, husbandman 0
4010910 2028679 2028679 defendant Russell John husbandman 608440 608440 Russell, John, of Whytchurche, husbandman 0
4041076 2039299 2039299 defendant Wareham Thomas husbandman 608440 608440 Wareham, Thomas, of Whytchurche, husbandman 0
4052773 2043425 2043425 defendant Humber Stephen husbandman 608440 608440 Humber, Stephen, of Whytchurche, or of Whatcome, husbandman 0
4058817 2045548 2045548 defendant Hopkyn George husbandman 608440 608440 Hopkyn, George, of Whytchurche, husbandman 0
4065555 2047971 2047971 defendant Longe Nicholas (legal representative) 608440 608440 Longe, Nicholas, of Whytchurche, yeoman, executor of 0
4071294 2050037 2050037 defendant Coton John yeoman 608440 608440 Coton, John, of Whytchurche, yeoman 1
4071828 2050223 2050223 defendant Longe John yeoman 608440 608440 Longe, John, of Whytchurche, yeoman 0
4071829 2050223 2050223 defendant Longe Roger yeoman 608440 608440 Longe, Roger, of Whytchurche, yeoman 1
4071830 2050223 2050223 defendant Myllyns Thomas yeoman 608440 608440 Myllyns, Thomas, of Whytchurche, yeoman 2
4080095 2053188 2053188 defendant Myllyns John yeoman 608440 608440 Myllyns, John, of Whytchurche, yeoman 0
4083368 2054336 2054336 defendant Powell John gent 608440 608440 Powell, John, of Whytchurche, gent 0
4086624 2055502 2055502 defendant Molleyns John husbandman 608440 608440 Molleyns, John, of Whytchurche, husbandman 5
4093003 2057810 2057810 defendant Langley Hugh gent 608440 608440 Langley, Hugh, of Whytchurche, gent 0
4095619 2058761 2058761 defendant Chapman William husbandman 608440 608440 Chapman, William, of Whytchurche, husbandman 0
4102672 2061255 2061255 defendant Lye John, senior sherman 608440 608440 Lye, John, senior, of Whytchurche, sherman 0
4102674 2061255 2061255 defendant Lye John, junior clerk 608440 608440 Lye, John, junior, of Whytchurche, clerk 2
4134018 2072498 2072498 defendant Mullens Andrew husbandman 608440 608440 Mullens, Andrew, of Whytchurche, husbandman 1
4134019 2072498 2072498 defendant Chepman Richard husbandman 608440 608440 Chepman, Richard, of Whytchurche, husbandman 2
4134020 2072498 2072498 defendant Mullins George husbandman 608440 608440 Mullins, George, of Whytchurche, husbandman 3
4146761 2077019 2077019 defendant Mullyns John yeoman 608440 608440 Mullyns, John, of Whytchurche, yeoman 1
4148792 2077697 2077697 defendant Grenge John husbandman 608440 608440 Grenge, John, of Whytchurche, husbandman 1
4169437 2084813 2084813 defendant Gaye Thomas husbandman 608440 608440 Gaye, Thomas, of Whytchurche, husbandman 1
4173524 2086194 2086194 defendant Lyllywhyte John husbandman 608440 608440 Lyllywhyte, John, of Whytchurche, husbandman 1
4173525 2086194 2086194 defendant Gaye Thomas husbandman 608440 608440 Gaye, Thomas, of Whytchurche, husbandman 2
4183246 2089622 2089622 defendant Longe Walter victualer 608440 608440 Longe, Walter, of Whytchurche, victualer 0
4186516 2090768 2090768 defendant Mollyng John yeoman 608440 608440 Mollyng, John, of Whytchurche, yeoman 2
4186520 2090769 2090769 defendant Chapman John yeoman 608440 608440 Chapman, John, of Whytchurche, yeoman 2
4191086 2092445 2092445 defendant Grandge John innholder 608440 608440 Grandge, John, of Whytchurche, innholder 1
4196874 2094457 2094457 defendant Lyllywhyte John husbandman 608440 608440 Lyllywhyte, John, of Whytchurche, husbandman 1
4196875 2094457 2094457 defendant Gaye Thomas husbandman 608440 608440 Gaye, Thomas, of Whytchurche, husbandman 2
4287583 2125608 2125608 defendant Loveridge Daniel tailor 608440 608440 Loveridge, Daniel, of Whytchurche, or of Birporte, tailor 0
4303791 2131455 2131455 defendant Keate Richard yeoman 608440 608440 Keate, Richard, of Whytchurche, yeoman 0
4308347 2133070 2133070 defendant Glandvild Ralph merchant 608440 608440 Glandvild, Ralph, of Whytchurche, or of Tavistock, merchant 0
4324167 2138486 2138486 defendant Mullyns Thomas yeoman 608440 608440 Mullyns, Thomas, of Whytchurche, yeoman 0
4324168 2138486 2138486 defendant Hodder Mark yeoman 608440 608440 Hodder, Mark, of Whytchurche, yeoman 1
4328491 2139844 2139844 defendant Heskye or Hoskye John husbandman 608440 608440 Heskye or Hoskye, John, of Whytchurche, husbandman 0
4330493 2140496 2140496 defendant Chapman William   608440 608440 Chapman, William, of Whytchurche, shepherd 0
4330494 2140496 2140496 defendant Polden John yeoman 608440 608440 Polden, John, of Whytchurche, yeoman 1
4330495 2140496 2140496 defendant Stone Robert   608440 608440 Stone, Robert, of Whytchurche, shepherd 2
4397825 2163851 2163851 defendant Jesoppe William   608440 608440 Jesoppe, William, of Whytchurche, yeoman, administratotrs of 0
4417046 2170204 2170204 defendant Ayllaf John   608440 608440 Ayllaf, John, of Whytchurche 4
4417048 2170204 2170204 defendant Soutere Robert le   608440 608440 Soutere, Robert le, of Whytchurche, son of Reginald 6
4447101 2184003 2184003 defendant Tollehunt John   608440 608440 Tollehunt, John, of Whytchurche 1
4447102 2184003 2184003 defendant Milton Margery   608440 608440 Milton, Margery, of Whytchurche 2
4602436 2231981 2231981 defendant Elleworth Lawrence   608440 608440 Elleworth, Lawrence, of Whytchurche 0
5241522 2427721 2427721 defendant Senyer William butcher 608440 608440 Senyer, William, of Whytchurche, butcher 2
5542743 2517851 2517851 defendant Roke John gent 608440 608440 Roke, John, of Whytchurche, gent 1
5542745 2517851 2517851 defendant Puggyslegh Richard husbandman 608440 608440 Puggyslegh, Richard, of Whytchurche, husbandman 3
5546642 2519020 2519020 defendant Rocheford William gent 608440 608440 Rocheford, William, of Whytchurche, gent 0
5565247 2524421 2524421 defendant Sparhauk William husbandman 608440 608440 Sparhauk, William, of Whytchurche, husbandman 1
5565248 2524421 2524421 defendant Sperhauk John husbandman 608440 608440 Sperhauk, John, of Whytchurche, husbandman 2
5565249 2524421 2524421 defendant Chamber William laborer 608440 608440 Chamber, William, of Whytchurche, laborer 3
5574988 2527259 2527259 defendant Haywod John husbandman 608440 608440 Haywod, John, of Whytchurche, husbandman 0

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