names

17 rows where place_id = 589719

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598497 1867158 1867158 defendant Denton William gent 589719 589719 Denton, William, of Bassyngbourne, Cams, gent 2
3631861 1904774 1904774 defendant Combys William shoemaker 589719 589719 Combys, William, of Bassyngbourne, Cams, shoemaker 2
3920079 1997049 1997049 defendant Pynke Margaret widow 589719 589719 Pynke, Margaret, of Bassyngbourne, Cams, widow 5
4046163 2041068 2041068 defendant Lynne John esq 589719 589719 Lynne, John, of Bassyngbourne, Cams, esq 0
4046165 2041069 2041069 defendant Lyne or Lynne John esq 589719 589719 Lyne or Lynne, John, of Bassyngbourne, Cams, esq 0
4658793 2248622 2248622 defendant Taillour John butcher 589719 589719 Taillour, John, of Bassyngbourne, Cams, butcher 1
4666369 2250956 2250956 defendant Bene William husbandman 589719 589719 Bene, William, of Bassyngbourne, Cams, husbandman 1
4864118 2315755 2315755 defendant Burdwaux John carter 589719 589719 Burdwaux, John, of Bassyngbourne, Cams, carter 3
4873956 2318792 2318792 defendant Molt Thomas maltman 589719 589719 Molt, Thomas, of Bassyngbourne, Cams, maltman 0
4883632 2321795 2321795 defendant Chirche John gent 589719 589719 Chirche, John, of Bassyngbourne, Cams, gent 0
4888200 2323115 2323115 defendant Waleys Richard fuller 589719 589719 Waleys, Richard, of Bassyngbourne, Cams, fuller 3
4889813 2323605 2323605 defendant Chirche John gent 589719 589719 Chirche, John, of Bassyngbourne, Cams, gent 0
4942217 2339555 2339555 defendant White Warren (legal representative) 589719 589719 White, Warren, of Bassyngbourne, Cams, executor of 0
5118480 2391841 2391841 defendant Turpyn John husbandman 589719 589719 Turpyn, John, of Bassyngbourne, Cams, husbandman 0
5230621 2424566 2424566 defendant Taylour John butcher 589719 589719 Taylour, John, of Bassyngbourne, Cams, butcher 2
5284342 2440438 2440438 defendant Pynke Thomas yeoman 589719 589719 Pynke, Thomas, of Bassyngbourne, Cams, yeoman 1
5533773 2515110 2515110 defendant Bolnest Thomas husbandman 589719 589719 Bolnest, Thomas, of Bassyngbourne, Cams, husbandman 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);