names

70 rows where place_id = 589723

✎ 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
3598505 1867160 1867160 defendant Robynson Thomas husbandman 589723 589723 Robynson, Thomas, of Botheby, husbandman 0
3677995 1919161 1919161 defendant Thomson Edward husbandman 589723 589723 Thomson, Edward, of Botheby, husbandman 0
3724115 1933825 1933825 defendant Vesse William clerk 589723 589723 Vesse, William, of Botheby, clerk 1
3805699 1959727 1959727 plaintiff Tomson William   589723 589723 Tomson, William, of Botheby 0
3811619 1961531 1961531 defendant Letters Thomas gent 589723 589723 Letters, Thomas, of Botheby, gent 0
3844184 1971731 1971731 defendant Penson John husbandman 589723 589723 Penson, John, of Botheby, husbandman 1
3961237 2011025 2011025 plaintiff Tomson John (legal representative) 589723 589723 Tomson, John, of Botheby, executrix of 0
3961239 2011025 2011025 defendant Wynter Thomas husbandman 589723 589723 Wynter, Thomas, of Botheby, husbandman 0
3961242 2011026 2011026 defendant Wynter Thomas husbandman 589723 589723 Wynter, Thomas, of Botheby, husbandman 0
4420577 2171339 2171339 defendant Pynsoun Richard   589723 589723 Pynsoun, Richard, of Botheby, parson 0
4448337 2184407 2184407 plaintiff Folkesthorp Thomas de   589723 589723 Folkesthorp, Thomas de, of Botheby, parson 0
4448342 2184409 2184409 plaintiff Folkethorp Thomas de   589723 589723 Folkethorp, Thomas de, of Botheby, parson 0
4452540 2185794 2185794 defendant Lettores Stephen   589723 589723 Lettores, Stephen, of Botheby 2
4452567 2185806 2185806 defendant Letteres Stephen   589723 589723 Letteres, Stephen, of Botheby 1
4476178 2193211 2193211 plaintiff Fowerthorp Thomas de   589723 589723 Fowerthorp, Thomas de, of Botheby, parson 0
4489666 2197486 2197486 plaintiff Toures Thomas   589723 589723 Toures, Thomas, of Botheby 0
4503344 2201619 2201619 plaintiff Paynell John   589723 589723 Paynell, John, of Botheby, knight 0
4503349 2201620 2201620 plaintiff Paynell John   589723 589723 Paynell, John, of Botheby, knight 0
4533425 2210724 2210724 plaintiff Rigge Thomas   589723 589723 Rigge, Thomas, of Botheby 0
4545617 2214551 2214551 defendant Rygh Thomas   589723 589723 Rygh, Thomas, of Botheby 0
4566808 2221188 2221188 defendant Paynell John   589723 589723 Paynell, John, of Botheby, knight 0
4566824 2221189 2221189 defendant Paynell John   589723 589723 Paynell, John, of Botheby, knight 0
4569391 2222018 2222018 plaintiff Wellyngton John   589723 589723 Wellyngton, John, of Botheby, parson 0
4569392 2222018 2222018 defendant Letteres Nicholas   589723 589723 Letteres, Nicholas, of Botheby 0
4569393 2222018 2222018 defendant Folkerthorp Thomas de (legal representative) 589723 589723 Folkerthorp, Thomas de, of Botheby, parson, executors of 1
4569404 2222021 2222021 plaintiff Welyngton John   589723 589723 Welyngton, John, of Botheby, parson 0
4569405 2222021 2222021 defendant Letteres Nicholas   589723 589723 Letteres, Nicholas, of Botheby 0
4577532 2224484 2224484 defendant Spynke Richard   589723 589723 Spynke, Richard, of Botheby 0
4577546 2224488 2224488 defendant Welby Richard de   589723 589723 Welby, Richard de, of Botheby 0
4577547 2224488 2224488 defendant Spynk Richard   589723 589723 Spynk, Richard, of Botheby 1
4577551 2224488 2224488 defendant Turnour Richard   589723 589723 Turnour, Richard, of Botheby 5
4578895 2224879 2224879 defendant Welby Richard   589723 589723 Welby, Richard, of Botheby 0
4589322 2228035 2228035 plaintiff Letters Nicholas   589723 589723 Letters, Nicholas, of Botheby 0
4592832 2229093 2229093 defendant Spynk Richard   589723 589723 Spynk, Richard, of Botheby 0
4592841 2229094 2229094 defendant Spynk Richard   589723 589723 Spynk, Richard, of Botheby 0
4600669 2231437 2231437 plaintiff Toures Thomas   589723 589723 Toures, Thomas, of Botheby 0
4602472 2231994 2231994 defendant Lettres Nicholas   589723 589723 Lettres, Nicholas, of Botheby 0
4602473 2231995 2231995 plaintiff Welyngton John   589723 589723 Welyngton, John, of Botheby, parson 0
4637178 2242427 2242427 defendant Pole John   589723 589723 Pole, John, of Botheby 0
4659419 2248806 2248806 defendant Bukley Henry yeoman 589723 589723 Bukley, Henry, of Botheby, yeoman 1
4660269 2249044 2249044 defendant Daye Robert husbandman 589723 589723 Daye, Robert, of Botheby, husbandman 0
4679680 2259260 2259260 defendant Tomson Thomas husbandman 589723 589723 Tomson, Thomas, of Botheby, husbandman 0
4719607 2271474 2271474 defendant Rede William laborer 589723 589723 Rede, William, of Botheby, laborer 0
4734079 2275843 2275843 plaintiff Rygge Thomas   589723 589723 Rygge, Thomas, of Botheby 0
4736424 2276523 2276523 defendant Denys John husbandman 589723 589723 Denys, John, of Botheby, husbandman 0
4737546 2276855 2276855 defendant Scot John husbandman 589723 589723 Scot, John, of Botheby, husbandman 1
4746866 2279584 2279584 defendant Scott John husbandman 589723 589723 Scott, John, of Botheby, husbandman 4
4770995 2286907 2286907 defendant Paynell John   589723 589723 Paynell, John, of Botheby, knight 0
4795806 2294838 2294838 defendant Howys Thomas yeoman 589723 589723 Howys, Thomas, of Botheby, yeoman 0
4803802 2297369 2297369 defendant Tylle Richard, junior   589723 589723 Tylle, Richard, junior, of Botheby 0
4814115 2300515 2300515 defendant Paynell John (legal representative) 589723 589723 Paynell, John, of Botheby, administrator of 0
4814116 2300515 2300515 defendant Pyke John husbandman 589723 589723 Pyke, John, of Botheby, husbandman 1
4816632 2301296 2301296 defendant Paynell John (legal representative) 589723 589723 Paynell, John, of Botheby, esq, administrator of 0
4940227 2338975 2338975 plaintiff Deye Robert   589723 589723 (Deye, Robert, of Botheby 1
4947335 2341161 2341161 defendant Webster John husbandman 589723 589723 Webster, John, of Botheby, husbandman 0
4955581 2343633 2343633 defendant Rygge Robert gent 589723 589723 Rygge, Robert, of Botheby, gent 0
5077774 2379847 2379847 defendant Bateman Nicholas clerk 589723 589723 Bateman, Nicholas, of Botheby, or of Bryngston, Suff, clerk 0
5251874 2430695 2430695 defendant Ryggys John gent 589723 589723 Ryggys, John, of Botheby, gent 0
5263770 2434423 2434423 plaintiff Rigge John gent 589723 589723 Rigge, John, of Botheby, gent 0
5267433 2435575 2435575 defendant Honley or Houley John yeoman 589723 589723 Honley or Houley, John, of Botheby, yeoman 12
5406694 2476981 2476981 defendant Tille Thomas husbandman 589723 589723 Tille, Thomas, of Botheby, husbandman 2
5419865 2480855 2480855 defendant Tille Thomas husbandman 589723 589723 Tille, Thomas, of Botheby, husbandman 2
5438381 2486412 2486412 defendant Tille Thomas husbandman 589723 589723 Tille, Thomas, of Botheby, husbandman 2
5438486 2486446 2486446 defendant Tylle Thomas husbandman 589723 589723 Tylle, Thomas, of Botheby, husbandman 2
5532320 2514650 2514650 defendant Veste William clerk 589723 589723 Veste, William, of Botheby, clerk 0
5555971 2521740 2521740 defendant Letters William gent 589723 589723 Letters, William, of Botheby, gent 0
5568499 2525334 2525334 defendant Lettyrs William gent 589723 589723 Lettyrs, William, of Botheby, gent 4
5616124 2548839 2548839 defendant Gamel Wiliam   589723 589723 Gamel, Wiliam, of Botheby 0
5617489 2549290 2549290 plaintiff Letteres Stephen   589723 589723 Letteres, Stephen, of Botheby 0
5620078 2550141 2550141 plaintiff Rigges Thomas   589723 589723 Rigges, Thomas, of Botheby 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);