names

72 rows where place_id = 590308

✎ 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
3600584 1867830 1867830 defendant Forster Humphrey esq 590308 590308 Forster, Humphrey, of Westhorp, esq 1
3639742 1907238 1907238 defendant Beyston Peter yeoman 590308 590308 Beyston, Peter, of Westhorp, yeoman 0
3671451 1917052 1917052 defendant Alan Christopher yeoman 590308 590308 Alan, Christopher, of Westhorp, yeoman 0
3697289 1925374 1925374 defendant Broun Thomas carpenter 590308 590308 Broun, Thomas, of Westhorp, carpenter 1
3697292 1925375 1925375 plaintiff Stokkys William   590308 590308 Stokkys, William, of Westhorp 0
3698498 1925750 1925750 defendant Lytelton Henry husbandman 590308 590308 Lytelton, Henry, of Westhorp, husbandman 1
3714516 1930837 1930837 defendant Stokkys William, senior husbandman 590308 590308 Stokkys, William, senior, of Westhorp, husbandman 0
3714517 1930837 1930837 defendant Stokkys William, junior laborer 590308 590308 Stokkys, William, junior, of Westhorp, laborer 1
3714520 1930838 1930838 defendant Stokkys William, senior husbandman 590308 590308 Stokkys, William, senior, of Westhorp, husbandman 0
3715116 1931025 1931025 defendant Payntour Thomas husbandman 590308 590308 Payntour, Thomas, of Westhorp, husbandman 0
3732805 1936490 1936490 defendant Garlond Thomas husbandman 590308 590308 Garlond, Thomas, of Westhorp, husbandman 0
3732806 1936490 1936490 defendant Unchevalle or Vuchevalle Thomas husbandman 590308 590308 Unchevalle or Vuchevalle, Thomas, of Westhorp, husbandman 1
3845881 1972266 1972266 defendant Drewe Katherine widow 590308 590308 Drewe, Katherine, of Westhorp, widow 2
3901194 1990624 1990624 defendant Sanson Lawrence husbandman 590308 590308 Sanson, Lawrence, of Westhorp, husbandman 2
3934467 2001823 2001823 defendant Coke John husbandman 590308 590308 Coke, John, of Westhorp, husbandman 0
3975319 2015936 2015936 defendant Pye John (legal representative) 590308 590308 Pye, John, of Westhorp, yeoman, executors of 0
4417957 2170490 2170490 defendant Royle John de   590308 590308 Royle, John de, of Westhorp 0
4434508 2175548 2175548 defendant Elmham Henry de   590308 590308 Elmham, Henry de, of Westhorp 0
4449025 2184637 2184637 defendant Pakard John   590308 590308 Pakard, John, of Westhorp 1
4457400 2187328 2187328 defendant Sone or Sove Arnold   590308 590308 Sone or Sove, Arnold, of Westhorp, parson 0
4615942 2235982 2235982 defendant Knyght Edmund   590308 590308 Knyght, Edmund, of Westhorp 3
4624192 2238548 2238548 defendant Coytes John   590308 590308 Coytes, John, of Westhorp 1
4636868 2242349 2242349 defendant Knyght Edmund   590308 590308 Knyght, Edmund, of Westhorp 0
4637671 2242565 2242565 defendant Knyght Edmund   590308 590308 Knyght, Edmund, of Westhorp 0
4661212 2249331 2249331 defendant Knyght Edmund   590308 590308 Knyght, Edmund, of Westhorp, "cornledere" 0
4661221 2249333 2249333 defendant Knyght Edmund   590308 590308 Knyght, Edmund, of Westhorp, "cornledere" 1
4663883 2250189 2250189 defendant Bulle Thomas husbandman 590308 590308 Bulle, Thomas, of Westhorp, husbandman 0
4663884 2250189 2250189 defendant Bulle Henry husbandman 590308 590308 Bulle, Henry, of Westhorp, husbandman 1
4695422 2264046 2264046 defendant Knyght Edmund husbandman 590308 590308 Knyght, Edmund, of Westhorp, husbandman 0
4695423 2264046 2264046 defendant Knyght John chaplain 590308 590308 Knyght, John, of Westhorp, chaplain 1
4706660 2267464 2267464 defendant Russell John gent 590308 590308 Russell, John, of Westhorp, gent 0
4712208 2269131 2269131 defendant Elmot John   590308 590308 Elmot, John, of Westhorp, wright 1
4744434 2278893 2278893 defendant Shepherd Henry husbandman 590308 590308 Shepherd, Henry, of Westhorp, husbandman 0
4744435 2278893 2278893 defendant Shepherd Thomas husbandman 590308 590308 Shepherd, Thomas, of Westhorp, husbandman 1
4761626 2283981 2283981 defendant Shepherd Henry husbandman 590308 590308 Shepherd, Henry, of Westhorp, husbandman 0
4761627 2283981 2283981 defendant Shepherd Thomas husbandman 590308 590308 Shepherd, Thomas, of Westhorp, husbandman 1
4770410 2286715 2286715 defendant Shepherd Henry husbandman 590308 590308 Shepherd, Henry, of Westhorp, husbandman 0
4795143 2294627 2294627 defendant Shepherd Henry husbandman 590308 590308 Shepherd, Henry, of Westhorp, husbandman 0
4814448 2300627 2300627 defendant Cokes Henry shoemaker 590308 590308 Cokes, Henry, of Westhorp, shoemaker 0
4814449 2300627 2300627 defendant George John shoemaker 590308 590308 George, John, of Westhorp, shoemaker 1
4814451 2300628 2300628 defendant Coket Henry shoemaker 590308 590308 Coket, Henry, of Westhorp, shoemaker 0
4814452 2300628 2300628 defendant George John shoemaker 590308 590308 George, John, of Westhorp, shoemaker 1
4818180 2301760 2301760 defendant in-the-Lane Richard husbandman 590308 590308 in-the-Lane, Richard, of Westhorp, husbandman 6
4818181 2301760 2301760 defendant Sampson Hugh husbandman 590308 590308 Sampson, Hugh, of Westhorp, husbandman 7
4837461 2307653 2307653 defendant Hobbes Robert yeoman 590308 590308 Hobbes, Robert, of Westhorp, yeoman 0
4837462 2307653 2307653 defendant Blome Adam miller 590308 590308 Blome, Adam, of Westhorp, miller 1
4840911 2308693 2308693 defendant Knyght William yeoman 590308 590308 Knyght, William, of Westhorp, yeoman 2
4947284 2341141 2341141 defendant Baude John husbandman 590308 590308 Baude, John, of Westhorp, husbandman 1
5066870 2376619 2376619 defendant Welyngton John husbandman 590308 590308 Welyngton, John, of Westhorp, husbandman 0
5109013 2389054 2389054 defendant Baker Robert husbandman 590308 590308 Baker, Robert, of Westhorp, husbandman 0
5138174 2397676 2397676 defendant Dolet John husbandman 590308 590308 Dolet, John, of Westhorp, husbandman 0
5143893 2399354 2399354 defendant Smyth John   590308 590308 Smyth, John, of Westhorp, horse dealer 1
5158923 2403728 2403728 defendant Dolet John husbandman 590308 590308 Dolet, John, of Westhorp, husbandman 0
5164934 2405481 2405481 defendant Smyth John   590308 590308 Smyth, John, of Westhorp, horse dealer 1
5178526 2409432 2409432 defendant Smyth John   590308 590308 Smyth, John, of Westhorp, horse dealer 1
5201486 2416192 2416192 defendant Smyth John   590308 590308 Smyth, John, of Westhorp, horse dealer 1
5228384 2423907 2423907 defendant Wybbe William husbandman or weaver 590308 590308 Wybbe, William, of Westhorp, husbandman or weaver 18
5228964 2424075 2424075 defendant Osbern Bartholomew husbandman 590308 590308 Osbern, Bartholomew, of Westhorp, husbandman 2
5275525 2437911 2437911 defendant Fysshe William   590308 590308 Fysshe, William, of Westhorp 0
5327999 2453441 2453441 defendant Rowe Thomas husbandman 590308 590308 Rowe, Thomas, of Westhorp, husbandman 1
5348404 2459645 2459645 defendant Hert John yeoman 590308 590308 Hert, John, of Westhorp, yeoman 0
5377961 2468687 2468687 defendant Seynys Richard yeoman 590308 590308 Seynys, Richard, of Westhorp, yeoman 1
5492533 2502678 2502678 defendant Gough John yeoman 590308 590308 Gough, John, of Westhorp, yeoman 0
5495982 2503692 2503692 defendant Wotton Thomas yeoman 590308 590308 Wotton, Thomas, of Westhorp, yeoman 2
5543822 2518176 2518176 defendant Typshede Thomas yeoman 590308 590308 Typshede, Thomas, of Westhorp, yeoman 1
5553121 2520950 2520950 defendant Wynne Richard carpenter 590308 590308 Wynne, Richard, of Westhorp, carpenter 3
5571473 2526210 2526210 defendant Baker Thomas yeoman 590308 590308 Baker, Thomas, of Westhorp, yeoman 0
5590738 2532077 2532077 defendant Hart Thomas yeoman 590308 590308 Hart, Thomas, of Westhorp, yeoman 1
5591405 2532284 2532284 defendant Lane John yeoman 590308 590308 Lane, John, of Westhorp, yeoman 5
5592040 2532500 2532500 defendant Lane John yeoman 590308 590308 Lane, John, of Westhorp, yeoman 4
5601692 2535429 2535429 defendant Tryppe John yeoman 590308 590308 Tryppe, John, of Westhorp, yeoman 0
5618951 2549769 2549769 defendant Weston Ralph   590308 590308 Weston, Ralph, of Westhorp 3

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