names

14 rows where place_id = 609788

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3680325 1919922 1919922 defendant Begons Henry yeoman 609788 609788 Begons, Henry, of Batcombe, Soms, yeoman 2
3748262 1941384 1941384 defendant Catcott John   609788 609788 Catcott, John, of Batcombe, Soms 0
3790281 1954777 1954777 defendant George George yeoman 609788 609788 George, George, of Batcombe, Soms, yeoman 0
3806398 1959913 1959913 defendant Gorge George clothier 609788 609788 Gorge, George, of Batcombe, Soms, clothier 0
3836904 1969444 1969444 defendant Catcote John yeoman of the guard 609788 609788 Catcote, John, of Batcombe, Soms, yeoman of the guard 0
3847298 1972715 1972715 defendant Catcote John gent 609788 609788 Catcote, John, of Batcombe, Soms, gent 2
3847304 1972716 1972716 defendant Catcote John gent 609788 609788 Catcote, John, of Batcombe, Soms, gent 2
3849043 1973295 1973295 plaintiff Lamberte Christopher gent 609788 609788 Lamberte, Christopher, of Batcombe, Soms, gent 0
3957886 2009819 2009819 defendant Morgan Richard gent 609788 609788 Morgan, Richard, of Batcombe, Soms, gent 0
4075124 2051408 2051408 defendant Parsons Thomas husbandman 609788 609788 Parsons, Thomas, of Batcombe, Soms, husbandman 0
4712506 2269229 2269229 defendant Walyngton William husbandman 609788 609788 Walyngton, William, of Batcombe, Soms, husbandman 0
5227335 2423621 2423621 defendant Dokett or Bokett John gent 609788 609788 Dokett or Bokett, John, of Batcombe, Soms, gent 1
5277459 2438487 2438487 defendant Milward Thomas clothier 609788 609788 Milward, Thomas, of Batcombe, Soms, clothier 0
5294802 2443463 2443463 defendant Yerbury Lawrence clothmaker 609788 609788 Yerbury, Lawrence, of Batcombe, Soms, clothmaker 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);