names

49 rows where place_id = 806103

✎ 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
4812819 2300127 2300127 defendant Smert Robert chaplain 806103 806103 Smert, Robert, of Torpennowe, chaplain 0
4872075 2318225 2318225 defendant Dobson Robert yeoman 806103 806103 Dobson, Robert, of Torpennowe, yeoman 2
5339822 2457029 2457029 defendant Floter John yeoman 806103 806103 Floter, John, of Torpennowe, yeoman 0
5339823 2457029 2457029 defendant Dobson John yeoman 806103 806103 Dobson, John, of Torpennowe, yeoman 1
5339824 2457029 2457029 defendant Paye John yeoman 806103 806103 Paye, John, of Torpennowe, yeoman 2
5339825 2457029 2457029 defendant Wayte John yeoman 806103 806103 Wayte, John, of Torpennowe, yeoman 3
5339826 2457029 2457029 defendant Coke Robert yeoman 806103 806103 Coke, Robert, of Torpennowe, yeoman 4
5339828 2457030 2457030 defendant Floter John yeoman 806103 806103 Floter, John, of Torpennowe, yeoman 0
5339829 2457030 2457030 defendant Dobson John yeoman 806103 806103 Dobson, John, of Torpennowe, yeoman 1
5339830 2457030 2457030 defendant Wayte John yeoman 806103 806103 Wayte, John, of Torpennowe, yeoman 2
5339831 2457030 2457030 defendant Coke Robert yeoman 806103 806103 Coke, Robert, of Torpennowe, yeoman 3
5339833 2457031 2457031 defendant Huchonson John yeoman 806103 806103 Huchonson, John, of Torpennowe, yeoman 0
5339834 2457031 2457031 defendant Dobson Robert yeoman 806103 806103 Dobson, Robert, of Torpennowe, yeoman 1
5339835 2457031 2457031 defendant Ranson or Rauson John yeoman 806103 806103 Ranson or Rauson, John, of Torpennowe, yeoman 2
5339836 2457031 2457031 defendant Tayllour John, junior yeoman 806103 806103 Tayllour, John, junior, of Torpennowe, yeoman 3
5339837 2457031 2457031 defendant Mires Richard yeoman 806103 806103 Mires, Richard, of Torpennowe, yeoman 4
5339839 2457032 2457032 defendant Huchonson John yeoman 806103 806103 Huchonson, John, of Torpennowe, yeoman 0
5339840 2457032 2457032 defendant Dobson Robert yeoman 806103 806103 Dobson, Robert, of Torpennowe, yeoman 1
5339841 2457032 2457032 defendant Ranson or Rauson John yeoman 806103 806103 Ranson or Rauson, John, of Torpennowe, yeoman 2
5339842 2457032 2457032 defendant Tayllour John, junior yeoman 806103 806103 Tayllour, John, junior, of Torpennowe, yeoman 3
5339843 2457032 2457032 defendant Mires Richard yeoman 806103 806103 Mires, Richard, of Torpennowe, yeoman 4
5339847 2457034 2457034 defendant Leygh Thomas gent 806103 806103 Leygh, Thomas, of Torpennowe, gent 0
5339848 2457034 2457034 defendant Walker William yeoman 806103 806103 Walker, William, of Torpennowe, yeoman 1
5339849 2457034 2457034 defendant Stamper Thomas yeoman 806103 806103 Stamper, Thomas, of Torpennowe, yeoman 2
5339850 2457034 2457034 defendant Scale Agnes widow 806103 806103 Scale, Agnes, of Torpennowe, widow 3
5339851 2457034 2457034 defendant Saundirson Christine widow 806103 806103 Saundirson, Christine, of Torpennowe, widow 4
5339853 2457035 2457035 defendant Parker Robert yeoman 806103 806103 Parker, Robert, of Torpennowe, yeoman 0
5339854 2457035 2457035 defendant Fynglave or Fynglane John yeoman 806103 806103 Fynglave or Fynglane, John, of Torpennowe, yeoman 1
5339855 2457035 2457035 defendant Tayllour John yeoman 806103 806103 Tayllour, John, of Torpennowe, yeoman 2
5339856 2457035 2457035 defendant Tayllour Thomas yeoman 806103 806103 Tayllour, Thomas, of Torpennowe, yeoman 3
5339857 2457035 2457035 defendant Botiller Robert yeoman 806103 806103 Botiller, Robert, of Torpennowe, yeoman 4
5339859 2457036 2457036 defendant Parker Robert yeoman 806103 806103 Parker, Robert, of Torpennowe, yeoman 0
5339860 2457036 2457036 defendant Fynglave or Fynglane John yeoman 806103 806103 Fynglave or Fynglane, John, of Torpennowe, yeoman 1
5339861 2457036 2457036 defendant Tayllour John yeoman 806103 806103 Tayllour, John, of Torpennowe, yeoman 2
5339862 2457036 2457036 defendant Tayllour Thomas yeoman 806103 806103 Tayllour, Thomas, of Torpennowe, yeoman 3
5339863 2457036 2457036 defendant Botiller Robert yeoman 806103 806103 Botiller, Robert, of Torpennowe, yeoman 4
5339865 2457037 2457037 defendant Richeman Robert yeoman 806103 806103 Richeman, Robert, of Torpennowe, yeoman 0
5339866 2457037 2457037 defendant Dobson John, junior yeoman 806103 806103 Dobson, John, junior, of Torpennowe, yeoman 1
5339867 2457037 2457037 defendant Denyes John yeoman 806103 806103 Denyes, John, of Torpennowe, yeoman 2
5339868 2457037 2457037 defendant Lamyngham John yeoman 806103 806103 Lamyngham, John, of Torpennowe, yeoman 3
5339869 2457037 2457037 defendant Clement John yeoman 806103 806103 Clement, John, of Torpennowe, yeoman 4
5339871 2457038 2457038 defendant Richeman Robert yeoman 806103 806103 Richeman, Robert, of Torpennowe, yeoman 0
5339872 2457038 2457038 defendant Dokson John, junior yeoman 806103 806103 Dokson, John, junior, of Torpennowe, yeoman 1
5339873 2457038 2457038 defendant Denyes or Devyes John yeoman 806103 806103 Denyes or Devyes, John, of Torpennowe, yeoman 2
5339874 2457038 2457038 defendant Lamyngham John yeoman 806103 806103 Lamyngham, John, of Torpennowe, yeoman 3
5339877 2457039 2457039 defendant Walker William yeoman 806103 806103 Walker, William, of Torpennowe, yeoman 0
5339878 2457039 2457039 defendant Stamper Thomas yeoman 806103 806103 Stamper, Thomas, of Torpennowe, yeoman 1
5339879 2457039 2457039 defendant Scale Agnes widow 806103 806103 Scale, Agnes, of Torpennowe, widow 2
5339880 2457039 2457039 defendant Saundirson Christine widow 806103 806103 Saundirson, Christine, of Torpennowe, widow 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);