names

17 rows where place_id = 620664

✎ 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
3736911 1937797 1937797 defendant Butler Thomas esq 620664 620664 Butler, Thomas, of Warryngton, Lancs, esq 1
3852033 1974226 1974226 defendant Moylle William chapman 620664 620664 Moylle, William, of Warryngton, Lancs, chapman 1
3852036 1974227 1974227 defendant Moylle William chapman 620664 620664 Moylle, William, of Warryngton, Lancs, chapman 1
3852039 1974228 1974228 defendant Moylle William chapman 620664 620664 Moylle, William, of Warryngton, Lancs, chapman 1
3945069 2005369 2005369 defendant Clarke John chapman 620664 620664 Clarke, John, of Warryngton, Lancs, chapman 0
3953360 2008243 2008243 defendant Skelycorne John gent 620664 620664 Skelycorne, John, of Warryngton, Lancs, gent 0
3953930 2008445 2008445 defendant Skyllycorne John gent 620664 620664 Skyllycorne, John, of Warryngton, Lancs, gent 0
3981764 2018236 2018236 defendant Marbury Robert gent 620664 620664 Marbury, Robert, of Warryngton, Lancs, gent 1
4006374 2027056 2027056 defendant Marbury Robert gent 620664 620664 Marbury, Robert, of Warryngton, Lancs, gent 0
4015556 2030260 2030260 defendant Rychardson Robert draper 620664 620664 Rychardson, Robert, of Warryngton, Lancs, draper 2
4024410 2033408 2033408 defendant Marshall James   620664 620664 Marshall, James, of Warryngton, Lancs, woollen draper 0
4024412 2033409 2033409 defendant Patten Thomas painter 620664 620664 Patten, Thomas, of Warryngton, Lancs, painter 0
4182236 2089266 2089266 defendant Asmoole or Aspenall Humphrey yeoman 620664 620664 Asmoole or Aspenall, Humphrey, of Warryngton, Lancs, yeoman 0
4182240 2089267 2089267 defendant Asmoyle alias Aspenall Humphrey yeoman 620664 620664 Asmoyle alias Aspenall, Humphrey, of Warryngton, Lancs, yeoman 0
4183387 2089670 2089670 defendant Taylyor Elizabeth widow 620664 620664 Taylyor, Elizabeth, of Warryngton, Lancs, widow 0
4257242 2115401 2115401 defendant Spencer Robert yeoman 620664 620664 Spencer, Robert, of Warryngton, Lancs, yeoman 1
4382659 2158908 2158908 defendant Shert Hugh vintner 620664 620664 Shert, Hugh, of Warryngton, Lancs, vintner 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);