names

13 rows where place_id = 798938

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4764633 2284924 2284924 defendant Michell John husbandman 798938 798938 Michell, John, of Lodyswyll, husbandman 0
4785003 2291323 2291323 defendant Elys John husbandman 798938 798938 Elys, John, of Lodyswyll, husbandman 2
4785004 2291323 2291323 defendant Boway John husbandman 798938 798938 Boway, John, of Lodyswyll, husbandman 3
4785005 2291323 2291323 defendant Taillour Robert husbandman 798938 798938 Taillour, Robert, of Lodyswyll, husbandman 4
4788855 2292570 2292570 defendant Troute or Tronte Henry yeoman 798938 798938 Troute or Tronte, Henry, of Lodyswyll, yeoman 1
4788860 2292571 2292571 defendant Tront or Trout Henry yeoman 798938 798938 Tront or Trout, Henry, of Lodyswyll, yeoman 2
4797117 2295266 2295266 defendant Crempe Robert butcher 798938 798938 Crempe, Robert, of Lodyswyll, butcher 2
5031989 2366228 2366228 defendant Ryder John husbandman 798938 798938 Ryder, John, of Lodyswyll, husbandman 1
5039917 2368582 2368582 defendant Toly William butcher 798938 798938 Toly, William, of Lodyswyll, butcher 1
5054961 2373046 2373046 plaintiff Bowye John husbandman 798938 798938 Bowye, John, of Lodyswyll, husbandman 0
5074696 2378937 2378937 plaintiff Wose John   798938 798938 Wose, John,of Lodyswyll 0
5314378 2449323 2449323 defendant Smyth Walter yeoman 798938 798938 Smyth, Walter, of Lodyswyll, yeoman 0
5352809 2460965 2460965 defendant Hervy Elias husbandman 798938 798938 Hervy, Elias, of Lodyswyll, husbandman 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);