names

213 rows where place_id = 586373

✎ 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
3588544 1864060 1864060 defendant Nicholas Arnold mercer 586373 586373 Nicholas, Arnold, of Yevell, mercer 0
3610415 1870917 1870917 defendant Sendall John spicer 586373 586373 Sendall, John, of Yevell, spicer 0
3610416 1870917 1870917 defendant Alwyn Richard spicer 586373 586373 Alwyn, Richard, of Yevell, spicer 1
3622882 1874685 1874685 defendant Martok John husbandman 586373 586373 Martok, John, of Yevell, husbandman 0
3917563 1996233 1996233 plaintiff Hacker alias Baker John baker 586373 586373 Hacker alias Baker, John, of Yevell, baker 0
4012235 2029098 2029098 defendant Harryson Joan spinster 586373 586373 Harryson, Joan, of Yevell, spinster 1
4045597 2040874 2040874 defendant Cooke Andrew yeoman 586373 586373 Cooke, Andrew, of Yevell, yeoman 0
4078473 2052599 2052599 defendant Shewre or Shewe alias Barthelmewe John baker 586373 586373 Shewre or Shewe alias Barthelmewe, John, of Yevell, baker 1
4089092 2056393 2056393 defendant Kynge Robert husbandman 586373 586373 Kynge, Robert, of Yevell, husbandman 1
4089093 2056393 2056393 defendant Jacobbe thomas yeoman 586373 586373 Jacobbe, thomas, of Yevell, yeoman 2
4100163 2060391 2060391 defendant Hawker John gent 586373 586373 Hawker, John, of Yevell, gent 0
4100165 2060392 2060392 defendant Hawker John gent 586373 586373 Hawker, John, of Yevell, gent 0
4109626 2063701 2063701 defendant Gillett John husbandman 586373 586373 Gillett, John, of Yevell, husbandman 0
4123285 2068630 2068630 defendant Pytman Thomas husbandman 586373 586373 Pytman, Thomas, of Yevell, husbandman 1
4126714 2069841 2069841 defendant Jacobbe Valentine husbandman 586373 586373 Jacobbe, Valentine, of Yevell, husbandman 0
4128757 2070581 2070581 defendant Lucocke Richard   586373 586373 Lucocke, Richard, of Yevell, linen draper 0
4135743 2073112 2073112 defendant Androwes William husbandman 586373 586373 Androwes, William, of Yevell, husbandman 0
4135744 2073112 2073112 defendant Pytman Thomas husbandman 586373 586373 Pytman, Thomas, of Yevell, husbandman 1
4149160 2077833 2077833 defendant Fanstone or Faustone Mathew innholder 586373 586373 Fanstone or Faustone, Mathew, of Yevell, yeoman, innholder 0
4150642 2078361 2078361 defendant Platten Peter skinner 586373 586373 Platten, Peter, of Yevell, skinner 0
4229211 2105700 2105700 defendant Grubham Richard   586373 586373 Grubham, Richard, of Yevell, husbandman, linen draper 2
4248836 2112600 2112600 defendant Strachleighe Andrew yeoman 586373 586373 Strachleighe, Andrew, of Yevell, yeoman 0
4283815 2124248 2124248 defendant Frauncis John husbandman 586373 586373 Frauncis, John, of Yevell, husbandman 0
4289656 2126366 2126366 defendant Compton Henry gent 586373 586373 Compton, Henry, of Yevell, or of Newton Smavile, gent 0
4289657 2126366 2126366 defendant Hollys Reginald gent 586373 586373 Hollys, Reginald, of Yevell, gent 1
4289658 2126366 2126366 defendant Compton Joseph gent 586373 586373 Compton, Joseph, of Yevell, gent 2
4370399 2154466 2154466 defendant Phelpes Giles gent 586373 586373 Phelpes, Giles, of Yevell, gent 0
4370400 2154466 2154466 defendant Edwardes Hugh yeoman 586373 586373 Edwardes, Hugh, of Yevell, yeoman 1
4370402 2154467 2154467 defendant Phelpes Giles gent 586373 586373 Phelpes, Giles, of Yevell, gent 0
4377154 2156903 2156903 defendant Chaplyn Lionel husbandman 586373 586373 Chaplyn, Lionel, of Yevell, husbandman 0
4377155 2156903 2156903 defendant Chaplyn Henry tailor 586373 586373 Chaplyn, Henry, of Yevell, tailor 1
4381194 2158387 2158387 defendant Becke Stuckley yeoman 586373 586373 Becke, Stuckley, of Yevell, yeoman 0
4469728 2191203 2191203 defendant Shetyere William   586373 586373 Shetyere, William, of Yevell 0
4506752 2202583 2202583 defendant Glovere John   586373 586373 Glovere, John, of Yevell 0
4527495 2208877 2208877 defendant glover John   586373 586373 glover, John, of Yevell 4
4593134 2229162 2229162 defendant Babbe John   586373 586373 Babbe, John, of Yevell 0
4593136 2229162 2229162 defendant Bodyll John   586373 586373 Bodyll, John, of Yevell 2
4593139 2229163 2229163 defendant Babbe John   586373 586373 Babbe, John, of Yevell 0
4593140 2229163 2229163 defendant Taillour William   586373 586373 Taillour, William, of Yevell 1
4593141 2229163 2229163 defendant Bodyll John   586373 586373 Bodyll, John, of Yevell 2
4609419 2234045 2234045 defendant Grenger William   586373 586373 Grenger, William, of Yevell 3
4628445 2239817 2239817 defendant Brasyeter Roger   586373 586373 Brasyeter, Roger, of Yevell 4
4632573 2241077 2241077 defendant White Richard   586373 586373 White, Richard, of Yevell 0
4647591 2245351 2245351 defendant Bryd Richard   586373 586373 Bryd, Richard, of Yevell 3
4647592 2245351 2245351 defendant Gelet John tanner 586373 586373 Gelet, John, of Yevell, tanner 4
4647593 2245351 2245351 defendant White William   586373 586373 White, William, of Yevell 5
4666160 2250885 2250885 defendant Kemer John courser 586373 586373 Kemer, John, of Yevell, courser 1
4667951 2255680 2255680 plaintiff Baker Thomas   586373 586373 Baker, Thomas, of Yevell, on his own account 0
4678481 2258878 2258878 defendant Nowhite John shoemaker 586373 586373 Nowhite, John, of Yevell, shoemaker 2
4678486 2258878 2258878 defendant Batefford William smith 586373 586373 Batefford, William, of Yevell, smith 7
4678491 2258879 2258879 defendant Lane John weaver 586373 586373 Lane, John, of Yevell, weaver 0
4678495 2258880 2258880 defendant Lane John weaver 586373 586373 Lane, John, of Yevell, weaver 0
4678541 2258895 2258895 defendant Jose John weaver 586373 586373 Jose, John, of Yevell, weaver 1
4678542 2258895 2258895 defendant Skynner William skinner 586373 586373 Skynner, William, of Yevell, skinner 2
4684129 2260638 2260638 defendant Dygon Henry   586373 586373 Dygon, Henry, of Yevell, shepherd 0
4687688 2261723 2261723 defendant Baker Benedict   586373 586373 Baker, Benedict, of Yevell, milward 0
4687689 2261723 2261723 defendant Cosyn Thomas   586373 586373 Cosyn, Thomas, of Yevell, milward 1
4687691 2261724 2261724 defendant Baker Benedict   586373 586373 Baker, Benedict, of Yevell, milward 0
4687692 2261724 2261724 defendant Cosyn Thomas   586373 586373 Cosyn, Thomas, of Yevell, milward 1
4718585 2271150 2271150 defendant Manston Ralph husbandman 586373 586373 Manston, Ralph, of Yevell, husbandman 0
4719819 2271544 2271544 defendant Fugge Bartholomew weaver 586373 586373 Fugge, Bartholomew, of Yevell, weaver 2
4719821 2271544 2271544 defendant Goldwegge John brewer 586373 586373 Goldwegge, John, of Yevell, brewer 4
4723635 2272697 2272697 defendant Hayne Walter husbandman 586373 586373 Hayne, Walter, of Yevell, husbandman 1
4723636 2272697 2272697 defendant Jaye Walter draper 586373 586373 Jaye, Walter, of Yevell, draper 2
4723637 2272697 2272697 defendant Kyng William weaver 586373 586373 Kyng, William, of Yevell, weaver 3
4729127 2274336 2274336 defendant Freman Richard (legal representative) 586373 586373 Freman, Richard, of Yevell, executrix of 4
4734377 2275921 2275921 defendant Coker John chapman 586373 586373 Coker, John, of Yevell, chapman 0
4734379 2275922 2275922 defendant Coker John chapman 586373 586373 Coker, John, of Yevell, chapman 0
4734383 2275923 2275923 defendant Wyseman Geoffrey draper 586373 586373 Wyseman, Geoffrey, of Yevell, draper 2
4738781 2277218 2277218 defendant Fugge Bartholomew weaver 586373 586373 Fugge, Bartholomew, of Yevell, weaver 2
4738783 2277218 2277218 defendant Goldwegge John brewer 586373 586373 Goldwegge, John, of Yevell, brewer 4
4763093 2284437 2284437 defendant Walssh John chapman 586373 586373 Walssh, John, of Yevell, chapman 2
4779832 2289688 2289688 defendant Dogge Robert husbandman 586373 586373 Dogge, Robert, of Yevell, husbandman 0
4780215 2289809 2289809 defendant Norton John dyer 586373 586373 Norton, John, of Yevell, dyer 3
4787104 2292029 2292029 defendant Stele Edward brasier 586373 586373 Stele, Edward, of Yevell, brasier 0
4790624 2293155 2293155 defendant Mewe John saddler 586373 586373 Mewe, John, of Yevell, saddler 0
4794818 2294524 2294524 defendant Franke John husbandman 586373 586373 Franke, John, of Yevell, husbandman 0
4801340 2296608 2296608 defendant Wyseman Geoffrey chapman 586373 586373 Wyseman, Geoffrey, of Yevell, chapman 1
4802084 2296836 2296836 defendant Wyseman Geoffrey draper 586373 586373 Wyseman, Geoffrey, of Yevell, draper 2
4804220 2297505 2297505 defendant Avene Henry chapman 586373 586373 Avene, Henry, of Yevell, chapman 0
4804763 2297689 2297689 defendant Baker Peter baker 586373 586373 Baker, Peter, of Yevell, baker 0
4810948 2299539 2299539 defendant Coke John shoemaker 586373 586373 Coke, John, of Yevell, shoemaker 4
4813857 2300444 2300444 defendant Deye John smith 586373 586373 Deye, John, of Yevell, smith 3
4819242 2302097 2302097 defendant Maudyte John husbandman 586373 586373 Maudyte, John, of Yevell, husbandman 0
4855556 2313101 2313101 defendant Bathe John tanner 586373 586373 Bathe, John, of Yevell, tanner 0
4857121 2313609 2313609 plaintiff Beskham Thomas chapman 586373 586373 Beskham, Thomas, of Yevell,chapman 0
4864335 2315824 2315824 defendant Holme Thomas   586373 586373 Holme, Thomas, of Yevell, bailiff 0
4875097 2319164 2319164 defendant Sackewebbe John husbandman 586373 586373 Sackewebbe, John, of Yevell, husbandman 4
4882864 2321557 2321557 defendant Halton John husbandman 586373 586373 (Halton, John, of Yevell, husbandman 5
4882865 2321557 2321557 defendant Bathe John husbandman 586373 586373 Bathe, John, of Yevell, husbandman 6
4884796 2322144 2322144 defendant Wyseman Geoffrey chapman 586373 586373 Wyseman, Geoffrey, of Yevell, chapman 3
4884884 2322169 2322169 defendant Holme Thomas yeoman 586373 586373 Holme, Thomas, of Yevell, yeoman 0
4885281 2322286 2322286 defendant Bathe John husbandman 586373 586373 Bathe, John, of Yevell, husbandman 1
4885286 2322286 2322286 defendant Hill John carpenter 586373 586373 Hill, John, of Yevell, carpenter 6
4890289 2323731 2323731 defendant Halton John husbandman 586373 586373 (Halton, John, of Yevell, husbandman 5
4890290 2323731 2323731 defendant Bathe John husbandman 586373 586373 Bathe, John, of Yevell, husbandman 6
4895616 2325300 2325300 defendant Gilberd John husbandman 586373 586373 Gilberd, John, of Yevell, husbandman 0
4895617 2325300 2325300 defendant Frank John husbandman 586373 586373 Frank, John, of Yevell, husbandman 1
4895618 2325300 2325300 defendant Carpenter Thomas carpenter 586373 586373 Carpenter, Thomas, of Yevell, carpenter 2
4896505 2325577 2325577 defendant Bonard Richard ostler 586373 586373 Bonard, Richard, of Yevell, ostler 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);