names

168 rows where place_id = 587426

✎ 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
3591383 1864929 1864929 defendant Wynscote Henry tucker 587426 587426 Wynscote, Henry, of Canyngton, tucker 1
3593601 1865636 1865636 defendant Tylly Thomas gent 587426 587426 Tylly, Thomas, of Canyngton, gent 0
3593615 1865638 1865638 defendant Pyleman John husbandman 587426 587426 Pyleman, John, of Canyngton, husbandman 0
3593616 1865638 1865638 defendant Venney Robert tucker 587426 587426 Venney, Robert, of Canyngton, tucker 1
3593617 1865638 1865638 defendant Faukener William   587426 587426 Faukener, William, of Canyngton, groom 2
3593621 1865639 1865639 defendant Tylly Thomas gent 587426 587426 Tylly, Thomas, of Canyngton, gent 0
3595041 1866082 1866082 defendant Northern Robert yeoman 587426 587426 Northern, Robert, of Canyngton, yeoman 0
3595042 1866082 1866082 defendant Hyet John weaver 587426 587426 Hyet, John, of Canyngton, weaver 1
3623188 1874776 1874776 defendant Coke John yeoman 587426 587426 Coke, John, of Canyngton, yeoman 2
3629013 1903949 1903949 defendant Way Robert tailor 587426 587426 Way, Robert, of Canyngton, tailor 0
3636001 1906055 1906055 defendant Stone Walter husbandman 587426 587426 Stone, Walter, of Canyngton, husbandman 0
3643438 1908373 1908373 defendant Tryvett Edward husbandman 587426 587426 Tryvett, Edward, of Canyngton, husbandman 1
3711818 1930011 1930011 defendant Porcor Thomas butcher 587426 587426 Porcor, Thomas, of Canyngton, butcher 0
3711819 1930011 1930011 defendant Porcor Roger butcher 587426 587426 Porcor, Roger, of Canyngton, butcher 1
3724082 1933818 1933818 defendant Grove Walter laborer 587426 587426 Grove, Walter, of Canyngton, laborer 0
3724083 1933818 1933818 defendant Howleg alias Dowleg Thomas laborer 587426 587426 Howleg alias Dowleg, Thomas, of Canyngton, laborer 1
3724085 1933819 1933819 defendant Tylby Thomas gent 587426 587426 Tylby, Thomas, of Canyngton, gent 0
3724086 1933819 1933819 defendant Benet Alexander laborer 587426 587426 Benet, Alexander, of Canyngton, laborer 1
3724087 1933819 1933819 defendant Wyat Walter laborer 587426 587426 Wyat, Walter, of Canyngton, laborer 2
3724088 1933819 1933819 defendant Tryved Edward laborer 587426 587426 Tryved, Edward, of Canyngton, laborer 3
3724089 1933819 1933819 defendant Freman Walter tiler 587426 587426 Freman, Walter, of Canyngton, tiler 4
3724090 1933819 1933819 defendant Hardewell John miller 587426 587426 Hardewell, John, of Canyngton, miller 5
3724091 1933819 1933819 defendant Battyng John miller 587426 587426 Battyng, John, of Canyngton, miller 6
3724093 1933820 1933820 defendant Tylby Thomas gent 587426 587426 Tylby, Thomas, of Canyngton, gent 0
3724094 1933820 1933820 defendant Benet Alexander laborer 587426 587426 Benet, Alexander, of Canyngton, laborer 1
3724095 1933820 1933820 defendant Wyat Walter laborer 587426 587426 Wyat, Walter, of Canyngton, laborer 2
3724096 1933820 1933820 defendant Tryved Edward laborer 587426 587426 Tryved, Edward, of Canyngton, laborer 3
3724097 1933820 1933820 defendant Freman Walter tiler 587426 587426 Freman, Walter, of Canyngton, tiler 4
3724098 1933820 1933820 defendant Hardewell John miller 587426 587426 Hardewell, John, of Canyngton, miller 5
3724099 1933820 1933820 defendant Battyng John   587426 587426 Battyng, John, of Canyngton 6
3726811 1934653 1934653 defendant Batyn John miller 587426 587426 Batyn, John, of Canyngton, miller 1
3805260 1959590 1959590 defendant Tylly Thomas gent 587426 587426 Tylly, Thomas, of Canyngton, gent 0
3805261 1959590 1959590 defendant Grove Walter laborer 587426 587426 Grove, Walter, of Canyngton, laborer 1
3805262 1959590 1959590 defendant Cornysshe John laborer 587426 587426 Cornysshe, John, of Canyngton, laborer 2
3805263 1959590 1959590 defendant Founteney John, junior laborer 587426 587426 Founteney, John, junior, of Canyngton, laborer 3
3805264 1959590 1959590 defendant Grove Robert laborer 587426 587426 Grove, Robert, of Canyngton, laborer 4
3823550 1965268 1965268 defendant Hogges Margaret widow 587426 587426 Hogges, Margaret, of Canyngton, widow 0
3823551 1965268 1965268 defendant Grove Robert husbandman 587426 587426 Grove, Robert, of Canyngton, husbandman 1
3823552 1965268 1965268 defendant Stone Walter husbandman 587426 587426 Stone, Walter, of Canyngton, husbandman 2
3823553 1965268 1965268 defendant Rede John   587426 587426 Rede, John, of Canyngton, groom 3
3847760 1972871 1972871 defendant Porker Thomas butcher 587426 587426 Porker, Thomas, of Canyngton, butcher 0
3855115 1975233 1975233 defendant Grove Robert husbandman 587426 587426 Grove, Robert, of Canyngton, husbandman 1
3869258 1979961 1979961 defendant Grove Robert husbandman 587426 587426 Grove, Robert, of Canyngton, husbandman 1
3908186 1993036 1993036 defendant Hurle Walter tucker 587426 587426 Hurle, Walter, of Canyngton, tucker 0
3953188 2008182 2008182 defendant Longe Thomas husbandman 587426 587426 Longe, Thomas, of Canyngton, husbandman 0
4443348 2182878 2182878 defendant atte Hille Richard   587426 587426 atte Hille, Richard, of Canyngton 2
4471355 2191708 2191708 defendant Marchall John   587426 587426 Marchall, John, of Canyngton 0
4471358 2191708 2191708 defendant Bruton John   587426 587426 Bruton, John, of Canyngton 3
4525081 2208186 2208186 defendant Strete William   587426 587426 Strete, William, of Canyngton 0
4548218 2215385 2215385 plaintiff Chedelton Joan   587426 587426 Chedelton, Joan, of Canyngton, prioress 0
4720151 2271646 2271646 defendant Pedegru John husbandman 587426 587426 Pedegru, John, of Canyngton, husbandman 0
4736345 2276498 2276498 plaintiff Sydenham John   587426 587426 Sydenham, John, of Canyngton 0
4749749 2280405 2280405 defendant Taberer John husbandman 587426 587426 Taberer, John, of Canyngton, husbandman 2
4750300 2280565 2280565 defendant Taberer John husbandman 587426 587426 Taberer, John, of Canyngton, husbandman 0
4759476 2283305 2283305 defendant Webbe John husbandman 587426 587426 Webbe, John, of Canyngton, husbandman 0
4794985 2294573 2294573 defendant Fulbourn John husbandman 587426 587426 Fulbourn, John, of Canyngton, husbandman 0
4804710 2297672 2297672 defendant Pym Roger gent 587426 587426 Pym, Roger, of Canyngton, gent 0
4812943 2300161 2300161 defendant Hatherigge Isabel widow 587426 587426 Hatherigge, Isabel, of Canyngton, widow 0
4812945 2300161 2300161 defendant Mase John husbandman 587426 587426 Mase, John, of Canyngton, husbandman 2
4812946 2300161 2300161 defendant Hatherigge William, senior   587426 587426 Hatherigge, William, senior, of Canyngton 3
4846726 2310484 2310484 defendant Cary Hugh gent 587426 587426 Cary, Hugh, of Canyngton, gent 0
4846743 2310490 2310490 defendant Lynde Thomas tailor 587426 587426 Lynde, Thomas, of Canyngton, tailor 0
4856598 2313445 2313445 defendant Martyn John brewer 587426 587426 Martyn, John, of Canyngton, brewer 0
4856600 2313446 2313446 defendant Martyn John brewer 587426 587426 Martyn, John, of Canyngton, brewer 0
4858443 2314014 2314014 defendant Doderham William gent 587426 587426 Doderham, William, of Canyngton, gent 0
4859406 2314321 2314321 defendant Taberer John husbandman 587426 587426 Taberer, John, of Canyngton, husbandman 0
4859407 2314321 2314321 defendant Taberer Thomas weaver 587426 587426 Taberer, Thomas, of Canyngton, weaver 1
4890227 2323713 2323713 defendant Castelman Walter husbandman 587426 587426 Castelman, Walter, of Canyngton, husbandman 2
4926160 2334610 2334610 defendant de Ile John yeoman 587426 587426 de Ile, John, of Canyngton, yeoman 0
4962315 2345629 2345629 defendant William David yeoman 587426 587426 William, David, of Canyngton, yeoman 0
4969103 2347726 2347726 defendant William David yeoman 587426 587426 William, David, of Canyngton, yeoman 0
4969114 2347727 2347727 defendant William David yeoman 587426 587426 William, David, of Canyngton, yeoman 0
4975070 2349516 2349516 defendant Dere Thomas yeoman 587426 587426 Dere, Thomas, of Canyngton, yeoman 0
4975071 2349516 2349516 defendant Walsheman Thomas yeoman 587426 587426 Walsheman, Thomas, of Canyngton, yeoman 1
4988808 2353607 2353607 defendant William David yeoman 587426 587426 William, David, of Canyngton, yeoman 0
4995955 2355639 2355639 plaintiff Grendo_ John   587426 587426 Grendo_, John, of Canyngton, vicar 0
5023082 2363658 2363658 defendant Wylsone John husbandman 587426 587426 Wylsone, John, of Canyngton, husbandman 0
5023083 2363658 2363658 defendant Rogger Robert husbandman 587426 587426 Rogger, Robert, of Canyngton, husbandman 1
5028127 2365099 2365099 defendant Pym Philip gent 587426 587426 Pym, Philip, of Canyngton, gent 0
5028130 2365099 2365099 defendant Grene John clerk 587426 587426 Grene, John, of Canyngton, clerk 3
5028131 2365099 2365099 defendant Preston William yeoman 587426 587426 Preston, William, of Canyngton, yeoman 4
5028132 2365099 2365099 defendant Palwebbe William tailor 587426 587426 Palwebbe, William, of Canyngton, tailor 5
5028133 2365099 2365099 defendant Benne John   587426 587426 Benne, John, of Canyngton, mason 6
5043419 2369655 2369655 defendant Hatcheford alias Aysshford John gent 587426 587426 Hatcheford alias Aysshford, John, of Canyngton, gent 0
5062279 2375280 2375280 plaintiff Hedy Alexander   587426 587426 Hedy, Alexander, of Canyngton 0
5066618 2376542 2376542 plaintiff Mychell Walter gent 587426 587426 Mychell, Walter, of Canyngton, gent 0
5068696 2377133 2377133 defendant Haccheford John gent 587426 587426 Haccheford, John, of Canyngton, gent 0
5079105 2380238 2380238 defendant Benet Hugh   587426 587426 Benet, Hugh, of Canyngton, millward 0
5079106 2380238 2380238 defendant Tryvet Walter gent 587426 587426 together with Tryvet, Walter, of Canyngton, gent 1
5079108 2380238 2380238 defendant Dodesham William gent 587426 587426 Dodesham, William, of Canyngton, gent 3
5079109 2380238 2380238 defendant Martyn John husbandman 587426 587426 Martyn, John, of Canyngton, husbandman 4
5079110 2380238 2380238 defendant Hode John, senior tucker 587426 587426 Hode, John, senior, of Canyngton, tucker 5
5079122 2380242 2380242 defendant Martyn John husbandman 587426 587426 Martyn, John, of Canyngton, husbandman 0
5079123 2380242 2380242 defendant Hode John, senior tucker 587426 587426 Hode, John, senior, of Canyngton, tucker 1
5079825 2380445 2380445 defendant Wolmere John   587426 587426 Wolmere, John, of Canyngton, court holder 2
5079832 2380446 2380446 defendant Wolmere John   587426 587426 Wolmere, John, of Canyngton, court holder 3
5083996 2381715 2381715 defendant Haccheford or Ayshford John gent 587426 587426 Haccheford or Ayshford, John, of Canyngton, gent 0
5086824 2382543 2382543 defendant Dodesham William gent 587426 587426 together with Dodesham, William, of Canyngton, gent 3
5086827 2382544 2382544 defendant Tylly Leonard gent 587426 587426 Tylly, Leonard, of Canyngton, gent 0
5086833 2382544 2382544 defendant Lyfe Walter husbandman 587426 587426 Lyfe, Walter, of Canyngton, husbandman 6

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