names

19 rows where place_id = 608860

✎ 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
3675832 1918475 1918475 defendant Hogekynson Isabel widow 608860 608860 Hogekynson, Isabel, of Wardlowe, widow 0
3689741 1922948 1922948 defendant James James husbabndman 608860 608860 James, James, of Wardlowe, husbabndman 2
3691733 1923574 1923574 defendant Rutter Christopher husbandman 608860 608860 Rutter, Christopher, of Wardlowe, husbandman 4
3691734 1923574 1923574 defendant Goodhyne Richard husbandman 608860 608860 Goodhyne, Richard, of Wardlowe, husbandman 5
3691735 1923574 1923574 defendant Frythe William husbandman 608860 608860 Frythe, William, of Wardlowe, husbandman 6
3691736 1923574 1923574 defendant Wood Robert husbandman 608860 608860 Wood, Robert, of Wardlowe, husbandman 7
3691737 1923574 1923574 defendant Richardson alias Jameson James husbandman 608860 608860 Richardson alias Jameson, James, of Wardlowe, husbandman 8
3729300 1935416 1935416 defendant Richardson alias James James yeoman 608860 608860 Richardson alias James, James, of Wardlowe, yeoman 1
3744922 1940315 1940315 defendant Rutter Christopher husbandman 608860 608860 Rutter, Christopher, of Wardlowe, husbandman 1
3757368 1944283 1944283 defendant Rechardson James laborer 608860 608860 Rechardson, James, of Wardlowe, laborer 0
3765738 1946949 1946949 defendant Ritter Christopher husbandman 608860 608860 Ritter, Christopher, of Wardlowe, husbandman 1
3778448 1950974 1950974 defendant Jamys Richard husbandman 608860 608860 Jamys, Richard, of Wardlowe, husbandman 0
4214937 2100725 2100725 defendant James Henry   608860 608860 James, Henry, of Wardlowe husbandman 1
4216122 2101129 2101129 defendant James Henry yeoman 608860 608860 James, Henry, of Wardlowe, yeoman 1
4298399 2129528 2129528 defendant Raworth Philip yeoman 608860 608860 Raworth, Philip, of Wardlowe, yeoman 0
4360764 2151022 2151022 defendant Hardye Thomas miner 608860 608860 Hardye, Thomas, of Wardlowe, miner 1
4766826 2285619 2285619 defendant Jacson Richard yeoman 608860 608860 Jacson, Richard, of Wardlowe, yeoman 0
4791176 2293342 2293342 defendant Jacson Richard yeoman 608860 608860 Jacson, Richard, of Wardlowe, yeoman 0
5593997 2533113 2533113 defendant Hogekynson John husbandman 608860 608860 Hogekynson, John, of Wardlowe, 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);