names

21 rows where place_id = 621196

✎ 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
3740133 1938773 1938773 defendant Chapman Joan widow 621196 621196 Chapman, Joan, of Borden, Kent, widow 0
3740135 1938774 1938774 defendant Chapman Joan widow 621196 621196 Chapman, Joan, of Borden, Kent, widow 0
3898654 1989758 1989758 defendant Skorne John yeoman 621196 621196 Skorne, John, of Borden, Kent, yeoman 1
4044425 2040460 2040460 plaintiff Reader or Reyther William gent 621196 621196 Reader or Reyther, William, of Borden, Kent, or of Newyngton, Surrey, gent 0
4044427 2040461 2040461 plaintiff Reader or Reyther William gent 621196 621196 Reader or Reyther, William, of Borden, Kent, or of Newyngton, Surrey, gent 0
4162814 2082542 2082542 defendant Pett Jerome gent 621196 621196 Pett, Jerome, of Borden, Kent, gent 0
4194842 2093757 2093757 defendant Fynche Christopher gent 621196 621196 Fynche, Christopher, of Borden, Kent, gent 0
4223666 2103763 2103763 defendant Pett Thomas yeoman 621196 621196 Pett, Thomas, of Borden, Kent, yeoman 0
4298826 2129677 2129677 defendant Garrard John yeoman 621196 621196 Garrard, John, of Borden, Kent, yeoman 1
4319493 2136930 2136930 defendant Tomlyn Walter merchant 621196 621196 Tomlyn, Walter, of Borden, Kent, merchant 0
4371803 2154976 2154976 defendant Tomlyn Walter merchant 621196 621196 Tomlyn, Walter, of Borden, Kent, merchant 0
4716828 2270589 2270589 defendant Frensshe Richard   621196 621196 Frensshe, Richard, of Borden, Kent, vicar & clerk 1
4737846 2276941 2276941 defendant Grangeman William   621196 621196 Grangeman, William, of Borden, Kent, administrators of 0
4777672 2289012 2289012 defendant Haydon Peter draper 621196 621196 Haydon, Peter, of Borden, Kent, draper 0
4884735 2322128 2322128 defendant Swerdere John, junior husbandman 621196 621196 Swerdere, John, junior, of Borden, Kent, husbandman 2
5287142 2441253 2441253 defendant Strangbowe John husbandman 621196 621196 Strangbowe, John,of Borden, Kent, husbandman 0
5300363 2445065 2445065 defendant Groveman William gent 621196 621196 Groveman, William, of Borden, Kent, gent 0
5300365 2445066 2445066 defendant Groveman William gent 621196 621196 Groveman, William, of Borden, Kent, gent 0
5306480 2446928 2446928 defendant Berlyng William husbandman 621196 621196 Berlyng, William, of Borden, Kent, husbandman 0
5332234 2454710 2454710 defendant Greveman William gent 621196 621196 Greveman, William, of Borden, Kent, gent 0
5332240 2454711 2454711 defendant Groveman William gent 621196 621196 Groveman, William, of Borden, Kent, gent 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);