names

23 rows where place_id = 593638

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612712 1871621 1871621 defendant Ricardes alias Fermour Emmote widow 593638 593638 Ricardes alias Fermour, Emmote, of Wytteney, Oxon, widow 0
3660635 1913588 1913588 defendant Hille Richard   593638 593638 Hille, Richard, of Wytteney, Oxon, inn holder 0
4605746 2232914 2232914 defendant Houghlond Richard baker 593638 593638 Houghlond, Richard, of Wytteney, Oxon, baker 1
4634275 2241561 2241561 defendant Drake William   593638 593638 Drake, William, of Wytteney, Oxon 0
4686975 2261534 2261534 defendant Rede Edward husbandman 593638 593638 Rede, Edward, of Wytteney, Oxon, husbandman 1
4843987 2309632 2309632 defendant Jurdan John   593638 593638 Jurdan, John, of Wytteney, Oxon, holy water clerk 4
4845784 2310191 2310191 defendant Martyn John chapman 593638 593638 Martyn, John, of Wytteney, Oxon, chapman 1
4882221 2321346 2321346 defendant Brayn John fuller 593638 593638 Brayn, John, of Wytteney, Oxon, fuller 0
4888866 2323305 2323305 defendant Mace John husbandman 593638 593638 Mace, John, of Wytteney, Oxon, husbandman 0
4951197 2342340 2342340 defendant Martyn John woolpacker 593638 593638 Martyn, John, of Wytteney, Oxon, woolpacker 0
5002754 2357713 2357713 defendant Cantelet John chapman 593638 593638 Cantelet, John, of Wytteney, Oxon, chapman 2
5028357 2365176 2365176 defendant Cornnell or Cornuell William skinner 593638 593638 Cornnell or Cornuell, William, of Wytteney, Oxon, skinner 3
5028362 2365177 2365177 defendant Cornnell or Cornuell William skinner 593638 593638 Cornnell or Cornuell, William, of Wytteney, Oxon, skinner 3
5193767 2413900 2413900 defendant Mundy John dyer 593638 593638 Mundy, John, of Wytteney, Oxon, dyer 0
5208349 2418168 2418168 defendant Mundy John dyer 593638 593638 Mundy, John, of Wytteney, Oxon, dyer 0
5208355 2418169 2418169 defendant Mundy John dyer 593638 593638 Mundy, John, of Wytteney, Oxon, dyer 0
5350076 2460147 2460147 defendant Welby William   593638 593638 Welby, William, of Wytteney, Oxon, gent, household of Bishop of Winchester 0
5350080 2460148 2460148 defendant Welby William   593638 593638 Welby, William, of Wytteney, Oxon, gent, household of Bishop of Winchester 0
5355257 2461717 2461717 defendant Aisshe Richard husbandman 593638 593638 Aisshe, Richard, of Wytteney, Oxon, husbandman 0
5414774 2479356 2479356 defendant Wadde William, sen miller 593638 593638 Wadde, William, sen, of Wytteney, Oxon, miller 0
5423134 2481879 2481879 defendant Flewellyng Henry gent 593638 593638 Flewellyng, Henry, of Wytteney, Oxon, gent 0
5427863 2483287 2483287 plaintiff Famour Thomas merchant & woolman 593638 593638 Famour, Thomas, of Wytteney, Oxon, merchant & woolman 0
5427975 2483318 2483318 plaintiff Fermour Thomas merchant & woolman 593638 593638 Fermour, Thomas, of Wytteney, Oxon, merchant & woolman 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);