names

20 rows where place_id = 632765

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3808542 1960548 1960548 defendant Caunton Richard weaver 632765 632765 Caunton, Richard, of Tonbrigge, weaver 0
4577953 2224609 2224609 defendant Lotte John   632765 632765 Lotte, John, of Tonbrigge 3
4601686 2231745 2231745 defendant Buksted Simon   632765 632765 Buksted, Simon, of Tonbrigge 2
4601691 2231746 2231746 defendant Buksted Simon   632765 632765 Buksted, Simon, of Tonbrigge 2
4860405 2314618 2314618 defendant Chamber Thomas chaplain 632765 632765 Chamber, Thomas, of Tonbrigge, chaplain 0
4961532 2345414 2345414 defendant Bocher Thomas butcher 632765 632765 Bocher, Thomas, of Tonbrigge, butcher 0
5030915 2365913 2365913 defendant Partriche William (legal representative) 632765 632765 Partriche, William, of Tonbrigge, executrix of 0
5141424 2398608 2398608 defendant Balden Richard wheler 632765 632765 Balden, Richard, of Tonbrigge, wheler 0
5141426 2398608 2398608 defendant Bourner Robert butcher 632765 632765 Bourner, Robert, of Tonbrigge, butcher 2
5176561 2408828 2408828 defendant Balden Richard   632765 632765 Balden, Richard, of Tonbrigge, wheel wright 0
5176563 2408828 2408828 defendant Bourner Robert butcher 632765 632765 Bourner, Robert, of Tonbrigge, butcher 2
5260243 2433331 2433331 defendant Neubourgh William barber 632765 632765 Neubourgh, William, of Tonbrigge, barber 0
5263846 2434448 2434448 defendant Nutworth Richard yeoman 632765 632765 Nutworth, Richard, of Tonbrigge, yeoman 1
5308887 2447699 2447699 defendant Wyllys Henry dyer 632765 632765 Wyllys, Henry, of Tonbrigge, dyer 4
5327738 2453364 2453364 defendant Tygherst John yeoman 632765 632765 Tygherst, John, of Tonbrigge, yeoman 0
5362779 2464001 2464001 defendant Cordewener Nicholas cordwainer 632765 632765 Cordewener, Nicholas, of Tonbrigge, cordwainer 1
5509867 2507925 2507925 defendant Wyott Thomas butcher 632765 632765 Wyott, Thomas, of Tonbrigge, butcher 0
5515261 2509619 2509619 defendant Hall John gent 632765 632765 Hall, John, of Tonbrigge, gent 0
5599406 2534700 2534700 defendant More Edward gent 632765 632765 More, Edward, of Tonbrigge, gent 0
5599407 2534700 2534700 defendant Halle John gent 632765 632765 Halle, John, of Tonbrigge, gent 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);