names

30 rows where place_id = 609256

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3677680 1919064 1919064 defendant Hyllyng Nicholas gent 609256 609256 Hyllyng, Nicholas, of Rewe, gent 0
3701767 1926800 1926800 defendant Hake William yeoman 609256 609256 Hake, William, of Rewe, yeoman 0
3756650 1944060 1944060 defendant Baron John husbandman 609256 609256 Baron, John, of Rewe, husbandman 4
3796257 1956695 1956695 defendant Halse John husbandman 609256 609256 Halse, John, of Rewe, husbandman 0
3800595 1958095 1958095 defendant Drake Thomas husbandman 609256 609256 Drake, Thomas, of Rewe, husbandman 0
3807355 1960205 1960205 defendant Tetbury Robert clerk 609256 609256 Tetbury, Robert, of Rewe, clerk 0
3844929 1971958 1971958 defendant Webber John weaver 609256 609256 Webber, John, of Rewe, weaver 0
3860846 1977119 1977119 defendant Palmer Edward husbandman 609256 609256 Palmer, Edward, of Rewe, husbandman 0
3923416 1998138 1998138 defendant Collys John, senior husbandman 609256 609256 Collys, John, senior, of Rewe, husbandman 0
3923417 1998138 1998138 defendant Collys John, junior husbandman 609256 609256 Collys, John, junior, of Rewe, husbandman 1
3923418 1998138 1998138 defendant Collys William husbandman 609256 609256 Collys, William, of Rewe, husbandman 2
3923419 1998138 1998138 defendant Barne James husbandman 609256 609256 Barne, James, of Rewe, husbandman 3
3923420 1998138 1998138 defendant Penston Richard   609256 609256 Penston, Richard, of Rewe, parish clerk 4
3923421 1998138 1998138 defendant Elyott Nichola widow 609256 609256 Elyott, Nichola, of Rewe, widow 5
3923422 1998138 1998138 defendant Pyme John husbandman 609256 609256 Pyme, John, of Rewe, husbandman 6
3923423 1998138 1998138 defendant Andrewe William husbandman 609256 609256 Andrewe, William, of Rewe, husbandman 7
4045292 2040774 2040774 plaintiff Rychard John husbandman 609256 609256 Rychard, John, of Rewe, husbandman 0
4119930 2067418 2067418 defendant Marshall John husbandman 609256 609256 Marshall, John, of Rewe, husbandman 0
4119931 2067418 2067418 defendant Drake John husbandman 609256 609256 Drake, John, of Rewe, husbandman 1
4378650 2157433 2157433 defendant Drake Robert yeoman 609256 609256 Drake, Robert, of Rewe, yeoman 2
4394164 2162647 2162647 defendant Pynce Robert husbandman 609256 609256 Pynce, Robert, of Rewe, husbandman 1
4547687 2215218 2215218 plaintiff Carbonel John (legal representative) 609256 609256 Carbonel, John, of Rewe, parson, executors of 0
4662318 2249689 2249689 defendant Chesulden John esq 609256 609256 Chesulden, John, of Rewe, esq 0
5069501 2377375 2377375 defendant Fissher John fisher 609256 609256 Fissher, John, of Rewe, fisher 7
5079534 2380370 2380370 defendant Wode John laborer 609256 609256 Wode, John, of Rewe, laborer 1
5236566 2426281 2426281 defendant Seman Thomas husbandman 609256 609256 Seman, Thomas, of Rewe, husbandman 1
5459990 2492917 2492917 defendant bykkombe Robert yeoman 609256 609256 bykkombe, Robert, of Rewe, yeoman 0
5471627 2496462 2496462 defendant Bykkombe Robert yeoman 609256 609256 Bykkombe, Robert, of Rewe, yeoman 0
5544068 2518254 2518254 defendant Drake John miller 609256 609256 Drake, John, of Rewe, miller 0
5560985 2523183 2523183 plaintiff Taylour Thomas (legal representative) 609256 609256 Taylour, Thomas, of Rewe, executrix of 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);