names

57 rows where place_id = 756499

✎ 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
4438272 2181265 2181265 defendant Procture Thomas   756499 756499 Procture, Thomas, of Caldebek 0
4493542 2198685 2198685 plaintiff Barton Thomas de   756499 756499 Barton, Thomas de, of Caldebek, parson 0
4493545 2198685 2198685 defendant Atkynson Richard   756499 756499 Atkynson, Richard, of Caldebek 1
4526091 2208456 2208456 defendant Scot William   756499 756499 Scot, William, of Caldebek 1
4526092 2208456 2208456 defendant Prestman Robert   756499 756499 Prestman, Robert, of Caldebek 2
4531568 2210146 2210146 defendant Scot John   756499 756499 Scot, John, of Caldebek 1
4542962 2213691 2213691 plaintiff Barton Thomas de   756499 756499 Barton, Thomas de, of Caldebek, parson 2
4544412 2214162 2214162 defendant Mathewe John   756499 756499 Mathewe, John, of Caldebek 0
4544413 2214162 2214162 defendant Wilde John   756499 756499 Wilde, John, of Caldebek 1
4544414 2214162 2214162 defendant Wilde Thomas   756499 756499 Wilde, Thomas, of Caldebek 2
4544415 2214162 2214162 defendant Richardson John   756499 756499 Richardson, John, of Caldebek 3
4550669 2216152 2216152 defendant Allderstogh Robert de   756499 756499 Allderstogh, Robert de, of Caldebek 0
4586989 2227331 2227331 defendant Wright Robert   756499 756499 Wright, Robert, of Caldebek 1
4600529 2231387 2231387 defendant Waverton Richard   756499 756499 Waverton, Richard, of Caldebek 0
4672618 2257078 2257078 defendant Caldebek John yeoman 756499 756499 Caldebek, John, of Caldebek, yeoman 0
4729091 2274331 2274331 defendant Louther Guy   756499 756499 Louther, Guy, of Caldebek, parson 3
4729933 2274568 2274568 plaintiff Louther Guy de   756499 756499 Louther, Guy de, of Caldebek, parson 0
4729935 2274569 2274569 plaintiff Louther Guy   756499 756499 Louther, Guy, of Caldebek, parson 0
4755046 2281964 2281964 defendant Kirkehouse Alan yeoman 756499 756499 Kirkehouse, Alan, of Caldebek, yeoman 0
4757771 2282805 2282805 defendant Abbot William yeoman 756499 756499 Abbot, William, of Caldebek, yeoman 2
4802235 2296888 2296888 defendant Joly Robert husbandman 756499 756499 Joly, Robert, of Caldebek, husbandman 3
4815285 2300891 2300891 defendant Scot Henry yeoman 756499 756499 Scot, Henry, of Caldebek, yeoman 1
4827188 2304551 2304551 defendant Alanby Thomas gent 756499 756499 Alanby, Thomas, of Caldebek, gent 0
4829220 2305180 2305180 defendant Taillour William yeoman 756499 756499 Taillour, William, of Caldebek, yeoman 3
4848677 2311056 2311056 defendant Corbryg Patrick yeoman 756499 756499 Corbryg, Patrick, of Caldebek, yeoman 6
4848695 2311061 2311061 defendant Scotte Robert yeoman 756499 756499 Scotte, Robert, of Caldebek, yeoman 0
4848696 2311061 2311061 defendant Abbot William yeoman 756499 756499 Abbot, William, of Caldebek, yeoman 1
4848697 2311061 2311061 defendant Caldebek John yeoman 756499 756499 Caldebek, John, of Caldebek, yeoman 2
4862208 2315194 2315194 defendant Abbot William yeoman 756499 756499 Abbot, William, of Caldebek, yeoman 0
4869394 2317397 2317397 defendant Scot Henry yeoman 756499 756499 Scot, Henry, of Caldebek, yeoman 0
4869395 2317397 2317397 defendant Scot Robert yeoman 756499 756499 Scot, Robert, of Caldebek, yeoman 1
4869396 2317397 2317397 defendant Abbot William yeoman 756499 756499 Abbot, William, of Caldebek, yeoman 2
4869398 2317397 2317397 defendant Caldebek John yeoman 756499 756499 Caldebek, John, of Caldebek, yeoman 4
4876338 2319561 2319561 defendant Corbrygg Patrick yeoman 756499 756499 Corbrygg, Patrick, of Caldebek, yeoman 5
4880898 2320933 2320933 defendant Scott Robert yeoman 756499 756499 Scott, Robert, of Caldebek, yeoman 0
4896022 2325419 2325419 defendant Abbot William yeoman 756499 756499 Abbot, William, of Caldebek, yeoman 3
4896029 2325420 2325420 defendant Prestman John yeoman 756499 756499 Prestman, John, of Caldebek, yeoman 5
4949127 2341717 2341717 defendant Abbot of William yeoman 756499 756499 Abbot, of William, of Caldebek, yeoman 3
4975065 2349514 2349514 defendant Abbote William yeoman 756499 756499 Abbote, William, of Caldebek, yeoman 8
5005960 2358646 2358646 defendant Scott Richard yeoman 756499 756499 Scott, Richard, of Caldebek, yeoman 1
5005961 2358646 2358646 defendant Abbote William yeoman 756499 756499 Abbote, William, of Caldebek, yeoman 2
5005962 2358646 2358646 defendant Haltelowe Hugh gent 756499 756499 Haltelowe, Hugh, of Caldebek, gent 3
5022558 2363501 2363501 defendant Wylson Robert husbandman 756499 756499 Wylson, Robert, of Caldebek, husbandman 1
5085240 2382082 2382082 defendant Sclater Nicholas yeoman 756499 756499 Sclater, Nicholas, of Caldebek, yeoman 0
5085241 2382082 2382082 defendant Litster Richard yeoman 756499 756499 Litster, Richard, of Caldebek, yeoman 1
5085242 2382082 2382082 defendant Nycholson John yeoman 756499 756499 Nycholson, John, of Caldebek, yeoman 2
5085243 2382082 2382082 defendant Nycholson Robert yeoman 756499 756499 Nycholson, Robert, of Caldebek, yeoman 3
5085244 2382082 2382082 defendant Todhunter Richard yeoman 756499 756499 Todhunter, Richard, of Caldebek, yeoman 4
5085246 2382082 2382082 defendant Denyson Roger yeoman 756499 756499 Denyson,Roger, of Caldebek, yeoman 6
5085247 2382082 2382082 defendant Richerdson John yeoman 756499 756499 Richerdson, John, of Caldebek, yeoman 7
5085253 2382082 2382082 defendant Sethwayte Thomas tailor 756499 756499 Sethwayte, Thomas, of Caldebek, tailor 13
5085254 2382082 2382082 defendant Watson William yeoman 756499 756499 Watson, William, of Caldebek, yeoman 14
5170824 2407188 2407188 defendant Gibson John chaplain 756499 756499 Gibson, John, of Caldebek, chaplain 1
5351423 2460546 2460546 defendant Scotte Robert yeoman 756499 756499 Scotte, Robert, of Caldebek, yeoman 0
5351424 2460546 2460546 defendant Tomson Richard yeoman 756499 756499 Tomson, Richard, of Caldebek, yeoman 1
5351425 2460546 2460546 defendant Cuek William yeoman 756499 756499 Cuek, William, of Caldebek, yeoman 2
5351426 2460546 2460546 defendant Prestman Robert yeoman 756499 756499 Prestman, Robert, of Caldebek, yeoman 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);