names

17 rows where place_id = 619532

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3730437 1935751 1935751 defendant Elyard Edward chapman 619532 619532 Elyard, Edward, of Sandewich, Kent, chapman 1
3811488 1961484 1961484 defendant Pyman John yeoman 619532 619532 Pyman, John, of Sandewich, Kent, yeoman 2
3921586 1997563 1997563 defendant Owtrede John chapman 619532 619532 Owtrede, John, of Sandewich, Kent, chapman 2
4858738 2314109 2314109 defendant Heddon Thomas merchant 619532 619532 Heddon, Thomas, of Sandewich, Kent, merchant 0
4873572 2318679 2318679 defendant Bedell John smith 619532 619532 Bedell, John, of Sandewich, Kent, smith 3
4966202 2346824 2346824 defendant Veer Richard gent 619532 619532 Veer, Richard, of Sandewich, Kent, gent 0
5021585 2363212 2363212 defendant Loveryk Alice widow 619532 619532 (Loveryk, Alice, of Sandewich, Kent, widow 2
5076504 2379472 2379472 defendant Kellowe Henry merchant 619532 619532 Kellowe, Henry, of Sandewich, Kent, merchant 2
5098194 2385901 2385901 defendant Spert Simon merchant 619532 619532 Spert, Simon, of Sandewich, Kent, merchant 0
5105215 2387964 2387964 defendant Boneyre Richard tailor 619532 619532 Boneyre, Richard, of Sandewich, Kent, tailor 0
5118886 2391954 2391954 defendant Moweherst Thomas   619532 619532 Moweherst, Thomas, of Sandewich, Kent, yeoman, of King's household 2
5243614 2428326 2428326 defendant Palmer Thomas gent 619532 619532 Palmer, Thomas, of Sandewich, Kent, gent 0
5256677 2432209 2432209 defendant William Thomas master of the ship le Nycholas of Hampton 619532 619532 William, Thomas, of Sandewich, Kent, or of Southampton, mariner, master of the ship le Nycholas of Hampton 0
5357433 2462390 2462390 defendant Est John merchant 619532 619532 Est, John, of Sandewich, Kent, merchant 1
5557019 2522011 2522011 defendant Somers John merchant 619532 619532 (Somers, John, of Sandewich, Kent, merchant 1
5557125 2522040 2522040 defendant Trysam Thomasine   619532 619532 Trysam, Thomasine, of Sandewich, Kent, widow of Trysam, Richard 1
5574906 2527232 2527232 defendant Somer John merchant 619532 619532 (Somer, John, of Sandewich, Kent, merchant 1

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);