names

36 rows where place_id = 623717

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3753947 1943184 1943184 defendant Knott Thomas husbandman 623717 623717 Knott, Thomas, of Sowe, husbandman 0
3935692 2002246 2002246 plaintiff Lapworth Edward   623717 623717 Lapworth, Edward, of Sowe, Warw yeoman 0
4412551 2168787 2168787 defendant Horne Nicholas husbandman 623717 623717 Horne, Nicholas, of Sowe, husbandman 0
4412552 2168787 2168787 defendant Horne William husbandman 623717 623717 Horne, William, of Sowe, husbandman 1
4417483 2170351 2170351 defendant Shirford Robert de, senior   623717 623717 Shirford, Robert de, senior, of Sowe 1
4417728 2170424 2170424 defendant Eyneys Robert   623717 623717 Eyneys, Robert, of Sowe, son of William 0
4427754 2173517 2173517 defendant Shireford Robert de, senior   623717 623717 Shireford, Robert de, senior, of Sowe 1
4473132 2192258 2192258 defendant Baton John   623717 623717 Baton, John, of Sowe, formerly bailiff 0
4503555 2201685 2201685 defendant Huchyns John   623717 623717 Huchyns, John, of Sowe 0
4533005 2210592 2210592 defendant Deynnemere John   623717 623717 Deynnemere, John, of Sowe 3
4535096 2211258 2211258 defendant Lordyng William   623717 623717 Lordyng, William, of Sowe 0
4549845 2215886 2215886 defendant Wynner John   623717 623717 Wynner, John, of Sowe 0
4580414 2225358 2225358 defendant Huchon John   623717 623717 Huchon, John, of Sowe 0
4618303 2236734 2236734 defendant Wylner Richard   623717 623717 Wylner, Richard, of Sowe 2
4661626 2249473 2249473 defendant Huchyns John parker 623717 623717 Huchyns, John, of Sowe, parker 0
4683293 2260380 2260380 defendant Huchons John farmer 623717 623717 Huchons, John, of Sowe, farmer 0
4697291 2264633 2264633 defendant Levyng Roger husbandman 623717 623717 Levyng, Roger, of Sowe, husbandman 0
4790417 2293088 2293088 defendant Wynnere John husbandman 623717 623717 Wynnere, John, of Sowe, husbandman 1
4828815 2305048 2305048 defendant Seymmer Thomas husbandman 623717 623717 Seymmer, Thomas, of Sowe, husbandman 0
4856561 2313435 2313435 defendant Huchyns Henry yeoman 623717 623717 Huchyns, Henry, of Sowe, yeoman 0
4913818 2330824 2330824 defendant Wynmer John husbandman 623717 623717 Wynmer, John, of Sowe, husbandman 1
4919532 2332611 2332611 defendant Wynmer William husbandman 623717 623717 Wynmer, William, of Sowe, husbandman 4
4945366 2340527 2340527 defendant Willemer John husbandman 623717 623717 Willemer, John, of Sowe, husbandman 0
5046434 2370575 2370575 plaintiff Methewe or Mathewe William carpenter 623717 623717 Methewe or Mathewe, William, of Sowe, carpenter 0
5046436 2370575 2370575 defendant Grene Thomas husbandman 623717 623717 Grene, Thomas, of Sowe, husbandman 0
5119248 2392058 2392058 defendant Smyth John smith 623717 623717 Smyth, John, of Sowe, smith 0
5148221 2400621 2400621 defendant Huchyns John husbandman 623717 623717 Huchyns, John, of Sowe, husbandman 1
5148226 2400621 2400621 defendant Nawesby Thomas husbandman 623717 623717 Nawesby, Thomas, of Sowe, husbandman 6
5215305 2420204 2420204 defendant Welmer John yeoman 623717 623717 Welmer, John, of Sowe, yeoman 1
5255063 2431698 2431698 defendant Mace Richard husbandman 623717 623717 Mace, Richard, of Sowe, husbandman 0
5269376 2436139 2436139 plaintiff Peche Richard   623717 623717 Peche, Richard, of Sowe 2
5314629 2449410 2449410 plaintiff Candell Thomas (legal representative) 623717 623717 Candell, Thomas, of Sowe, chaplain, bachelor of laws, executors of 0
5314631 2449410 2449410 plaintiff Peche Richard   623717 623717 Peche, Richard, of Sowe 2
5314634 2449411 2449411 plaintiff Candell Thomas (legal representative) 623717 623717 Candell, Thomas, of Sowe, chaplain, bachelor of laws, executors of 0
5314636 2449411 2449411 plaintiff Peche Richard   623717 623717 Peche, Richard, of Sowe 2
5575366 2527385 2527385 defendant Wylmere Richard yeoman 623717 623717 Wylmere, Richard, of Sowe, yeoman 1

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