names

34 rows where place_id = 593952

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613923 1872009 1872009 defendant Shepard William yeoman 593952 593952 Shepard, William, of Tutbury, Staffs, yeoman 0
3735466 1937329 1937329 defendant Fynche James baker 593952 593952 Fynche, James, of Tutbury, Staffs, baker 0
3743181 1939731 1939731 defendant Mason Thomas yeoman 593952 593952 Mason, Thomas, of Tutbury, Staffs, yeoman 0
3767201 1947383 1947383 defendant Vyllers Charles gent 593952 593952 Vyllers, Charles, of Tutbury, Staffs, gent 0
3778505 1950993 1950993 defendant Wetton William yeoman 593952 593952 Wetton, William, of Tutbury, Staffs, yeoman 3
3784972 1953083 1953083 defendant Vyllers Charles gent 593952 593952 Vyllers, Charles, of Tutbury, Staffs, gent 1
3784976 1953084 1953084 defendant Vyllers Charles gent 593952 593952 Vyllers, Charles, of Tutbury, Staffs, gent 0
3792263 1955433 1955433 defendant Wetten William innholder 593952 593952 Wetten, William, of Tutbury, Staffs, innholder 0
3793220 1955738 1955738 defendant Heth Ralph gent 593952 593952 Heth, Ralph, of Tutbury, Staffs, gent 1
3802280 1958611 1958611 defendant Wetton Edmund yeoman of the crown 593952 593952 Wetton, Edmund, of Tutbury, Staffs, yeoman of the crown 0
3819764 1964061 1964061 defendant Wetton Edmund yeoman of the crown 593952 593952 Wetton, Edmund, of Tutbury, Staffs, yeoman of the crown 0
3841516 1970927 1970927 defendant Byckley John gent 593952 593952 Byckley, John, of Tutbury, Staffs, gent 3
3841521 1970928 1970928 defendant Byckley John gent 593952 593952 Byckley, John, of Tutbury, Staffs, gent 3
3841526 1970929 1970929 defendant Byckley John gent 593952 593952 Byckley, John, of Tutbury, Staffs, gent 3
3899404 1990016 1990016 defendant Meverell Arthur clerk 593952 593952 Meverell, Arthur, of Tutbury, Staffs, clerk 0
3940381 2003802 2003802 defendant Cotton John chapman 593952 593952 Cotton, John, of Tutbury, Staffs, chapman 2
4059992 2045969 2045969 defendant Dykynson Edward yeoman 593952 593952 Dykynson, Edward, of Tutbury, Staffs, yeoman 1
4079140 2052840 2052840 defendant Stone Christopher yeoman 593952 593952 Stone, Christopher, of Tutbury, Staffs, yeoman 3
4133820 2072431 2072431 defendant Cavendyshe Henry esq 593952 593952 Cavendyshe, Henry, of Tutbury, Staffs, esq 0
4134246 2072573 2072573 defendant Cavendyshe Henry esq 593952 593952 Cavendyshe, Henry, of Tutbury, Staffs, esq 0
4182473 2089348 2089348 defendant Swynerton Thomas gent 593952 593952 Swynerton, Thomas, of Tutbury, Staffs, gent 0
4302933 2131149 2131149 defendant Mathewe Arthur yeoman 593952 593952 Mathewe, Arthur, of Tutbury, Staffs, yeoman 0
4303980 2131524 2131524 defendant Heathcott Anthony tailor 593952 593952 Heathcott, Anthony, of Tutbury, Staffs, tailor 3
4740974 2277870 2277870 defendant Cade John butcher 593952 593952 Cade, John, of Tutbury, Staffs, butcher 1
4763889 2284698 2284698 defendant Parker Thomas chapman 593952 593952 Parker, Thomas, of Tutbury, Staffs, chapman 1
4881359 2321074 2321074 defendant Donyngton Robert chaplain 593952 593952 Donyngton, Robert, of Tutbury, Staffs, chaplain 2
4924629 2334138 2334138 defendant Smyth John smith 593952 593952 Smyth, John, of Tutbury, Staffs, smith 2
4946296 2340830 2340830 defendant Isoke Richard yeoman 593952 593952 Isoke, Richard, of Tutbury, Staffs, yeoman 1
4975466 2349628 2349628 defendant Pante or Paute John esq 593952 593952 Pante or Paute, John, of Tutbury, Staffs, esq 0
5478386 2498564 2498564 defendant Pete Thomas smith 593952 593952 Pete, Thomas, of Tutbury, Staffs, smith 0
5478388 2498565 2498565 defendant Pete Thomas smith 593952 593952 Pete, Thomas, of Tutbury, Staffs, smith 0
5490369 2502012 2502012 defendant Sheppard William yeoman 593952 593952 Sheppard, William, of Tutbury, Staffs, yeoman 0
5528308 2513411 2513411 defendant Shephard Henry yeoman 593952 593952 Shephard, Henry, of Tutbury, Staffs, yeoman 2
5549362 2519864 2519864 defendant Alensonne Thomas   593952 593952 Alensonne, Thomas, of Tutbury, Staffs 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);