names

23 rows where place_id = 588258

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593857 1865718 1865718 defendant Berde Richard husbandman 588258 588258 Berde, Richard, of Pedynghoo, husbandman 0
3593858 1865718 1865718 defendant Berde Henry husbandman 588258 588258 Berde, Henry, of Pedynghoo, husbandman 1
3593859 1865718 1865718 defendant Clever John laborer 588258 588258 Clever, John, of Pedynghoo, laborer 2
3593860 1865718 1865718 defendant Clever William laborer 588258 588258 Clever, William, of Pedynghoo, laborer 3
3624360 1875154 1875154 defendant Berd Richard husbandman 588258 588258 Berd, Richard, of Pedynghoo, husbandman 0
3654309 1911608 1911608 defendant Capoll John laborer 588258 588258 Capoll, John, of Pedynghoo, laborer 0
3795760 1956541 1956541 defendant Rykware Richard husbandman 588258 588258 Rykware, Richard, of Pedynghoo, husbandman 0
3818380 1963647 1963647 defendant Rylwater alias Rykward Richard husbandman 588258 588258 Rylwater alias Rykward, Richard, of Pedynghoo, husbandman 1
3818478 1963678 1963678 defendant Rykewater alias Rykeward Richard husbandman 588258 588258 Rykewater alias Rykeward, Richard, of Pedynghoo, husbandman 0
3819185 1963888 1963888 defendant Rykwater alias Rykwarde Richard yeoman 588258 588258 Rykwater alias Rykwarde, Richard, of Pedynghoo, yeoman 0
3820709 1964366 1964366 defendant Rykewater alias Rykewarde Richard husbandman 588258 588258 Rykewater alias Rykewarde, Richard, of Pedynghoo, husbandman 0
4006468 2027091 2027091 defendant Colvyle Richard yeoman 588258 588258 Colvyle, Richard, of Pedynghoo, yeoman 0
4125976 2069574 2069574 defendant Woodd Thomas husbandman 588258 588258 Woodd, Thomas, of Pedynghoo, husbandman 0
4125977 2069574 2069574 defendant Hylles John husbandman 588258 588258 Hylles, John, of Pedynghoo, husbandman 1
4135123 2072880 2072880 defendant Ersey Richard yeoman 588258 588258 Ersey, Richard, of Pedynghoo, yeoman 0
4135126 2072881 2072881 defendant Ersey Richard yeoman 588258 588258 Ersey, Richard, of Pedynghoo, yeoman 0
4177539 2087621 2087621 defendant Tuppyn Thomas husbandman 588258 588258 Tuppyn, Thomas, of Pedynghoo, husbandman 1
4177859 2087729 2087729 defendant Shoulder Richard yeoman 588258 588258 Shoulder, Richard, of Pedynghoo, yeoman 1
4234283 2107526 2107526 defendant Walkott John yeoman 588258 588258 Walkott, John, of Pedynghoo, yeoman 1
4368485 2153775 2153775 defendant Acton George husbandman 588258 588258 Acton, George, of Pedynghoo, husbandman 0
5304330 2446297 2446297 defendant Gunne John, sen laborer 588258 588258 Gunne, John, sen, of Pedynghoo, laborer 0
5304376 2446307 2446307 defendant Emme John laborer 588258 588258 Emme, John, of Pedynghoo, laborer 0
5306668 2446982 2446982 defendant Shulder William laborer 588258 588258 Shulder, William, of Pedynghoo, laborer 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);