names

35 rows where place_id = 681058

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4043295 2040070 2040070 defendant Wante or Waute John baker 681058 681058 Wante or Waute, John, of Bridporte, baker 1
4044118 2040350 2040350 defendant Wante John baker 681058 681058 Wante, John, of Bridporte, baker 1
4124010 2068887 2068887 defendant Holcombe Andrew yeoman 681058 681058 Holcombe, Andrew, of Bridporte, yeoman 2
4125201 2069300 2069300 defendant Russell Hugh roper 681058 681058 Russell, Hugh, of Bridporte, roper 2
4146763 2077019 2077019 defendant Alforde William butcher 681058 681058 Alforde, William, of Bridporte, butcher 3
4191148 2092466 2092466 defendant Wood Richard yeoman 681058 681058 Wood, Richard, of Bridporte, yeoman 2
4208377 2098478 2098478 defendant Alforde Richard yeoman 681058 681058 Alforde, Richard, of Bridporte, yeoman 0
4209969 2099050 2099050 defendant Plucknett David chandler 681058 681058 Plucknett, David, of Bridporte, chandler 0
4212093 2099778 2099778 defendant Alforde William victualer 681058 681058 Alforde, William, of Bridporte, victualer 2
4234026 2107426 2107426 defendant Pounde Henry yeoman 681058 681058 Pounde, Henry, of Bridporte, or of Martock, Soms, yeoman 0
4294831 2128236 2128236 defendant Russell Richard gent 681058 681058 Russell, Richard, of Bridporte, gent 0
4296071 2128691 2128691 defendant Russell Richard gent 681058 681058 Russell, Richard, of Bridporte, gent 0
4296487 2128845 2128845 defendant Boys Anthony miller 681058 681058 Boys, Anthony, of Bridporte, miller 0
4301026 2130470 2130470 defendant Hodder Thomas merchant 681058 681058 Hodder, Thomas, of Bridporte, merchant 0
4301028 2130471 2130471 defendant Tyggyns John merchant 681058 681058 Tyggyns, John, of Bridporte, merchant 0
4305223 2131965 2131965 defendant Norwoode John yeoman 681058 681058 Norwoode, John, of Bridporte, yeoman 1
4305224 2131965 2131965 defendant Gollope Thomas yeoman 681058 681058 Gollope, Thomas, of Bridporte, yeoman 2
4305549 2132074 2132074 defendant Hellier Giles yeoman 681058 681058 Hellier, Giles, of Bridporte, yeoman 0
4306743 2132497 2132497 defendant Hellier Giles yeoman 681058 681058 Hellier, Giles, of Bridporte, yeoman 1
4307088 2132613 2132613 defendant Moone Richard merchant 681058 681058 Moone, Richard, of Bridporte, merchant 0
4333269 2141410 2141410 defendant Holman Gilbert merchant 681058 681058 Holman, Gilbert, of Bridporte, merchant 0
4360075 2150767 2150767 defendant Bowes or Bolles Robert cordwainer 681058 681058 Bowes or Bolles, Robert, of Bridporte, cordwainer 0
4365962 2152864 2152864 defendant Bulston Richard sherman 681058 681058 Bulston, Richard, of Bridporte, sherman 0
4368539 2153794 2153794 defendant Akerman Henry roper 681058 681058 Akerman, Henry, of Bridporte, roper 0
4368710 2153861 2153861 defendant Bowles Robert cordwainer 681058 681058 Bowles, Robert, of Bridporte, cordwainer 0
4376112 2156520 2156520 defendant Hellyer Giles yeoman 681058 681058 Hellyer, Giles, of Bridporte, yeoman 0
4380193 2158019 2158019 defendant Moone alias Holman Gilbert merchant 681058 681058 Moone alias Holman, Gilbert, of Bridporte, merchant 0
4392817 2162214 2162214 defendant Saule Barnaby   681058 681058 Saule, Barnaby, of Bridporte, or of Dartmouth, Devon, Doctor in Physic 0
4400859 2164879 2164879 defendant Keate Robert innkeeper 681058 681058 Keate, Robert, of Bridporte, innkeeper 2
4400981 2164918 2164918 defendant Holman Gilbert merchant 681058 681058 Holman, Gilbert, of Bridporte, merchant 0
4400982 2164918 2164918 defendant Holman Christopher merchant 681058 681058 Holman, Christopher, of Bridporte, merchant 1
4400983 2164918 2164918 defendant Southe Charles gent 681058 681058 Southe, Charles, of Bridporte, gent 2
4410138 2167991 2167991 defendant Moone Gilbert merchant 681058 681058 Moone, Gilbert, of Bridporte, merchant 0
5031794 2366169 2366169 defendant Boule Christian widow 681058 681058 Boule, Christian, of Bridporte, widow 0
5031796 2366170 2366170 defendant Boule Christian widow 681058 681058 Boule, Christian, of Bridporte, widow 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);