names

24 rows where place_id = 593418

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611734 1871332 1871332 defendant Herman Alexander yeoman 593418 593418 Herman, Alexander, of Soham Earl, yeoman 0
3672667 1917454 1917454 defendant Harman William husbandman 593418 593418 Harman, William, of Soham Earl, husbandman 0
3686600 1921961 1921961 defendant Harman William husbandman 593418 593418 Harman, William, of Soham Earl, husbandman 0
3690447 1923179 1923179 defendant Harman alias Hermer William yeoman 593418 593418 Harman alias Hermer, William, of Soham Earl, yeoman 1
3719672 1932419 1932419 defendant Deve Thomas husbandman 593418 593418 Deve, Thomas, of Soham Earl, husbandman 2
3719673 1932419 1932419 defendant Revett Thomas husbandman 593418 593418 Revett, Thomas, of Soham Earl, husbandman 3
3727321 1934820 1934820 defendant Abell Richard husbandman 593418 593418 Abell, Richard, of Soham Earl, husbandman 2
3746194 1940717 1940717 defendant Mordoke Robert yeoman 593418 593418 Mordoke, Robert, of Soham Earl, yeoman 2
3747456 1941119 1941119 plaintiff Eme John   593418 593418 Eme, John, of Soham Earl 0
3748360 1941417 1941417 defendant Payntor William clerk 593418 593418 Payntor, William, of Soham Earl, clerk 1
3824532 1965544 1965544 defendant Harman William yeoman 593418 593418 Harman, William, of Soham Earl, yeoman 0
3874854 1981809 1981809 plaintiff Dene Oliver   593418 593418 Dene, Oliver, of Soham Earl 0
3874856 1981810 1981810 plaintiff Dene Oliver   593418 593418 Dene, Oliver, of Soham Earl 0
3882383 1984371 1984371 defendant Deve Oliver yeoman 593418 593418 Deve, Oliver, of Soham Earl, yeoman 0
3903525 1991406 1991406 defendant Sheppard William carpenter 593418 593418 Sheppard, William, of Soham Earl, carpenter 2
4059239 2045700 2045700 defendant Corbell Thomas yeoman 593418 593418 Corbell, Thomas, of Soham Earl, yeoman 2
4233948 2107397 2107397 defendant Goodige John husbandman 593418 593418 Goodige, John, of Soham Earl, husbandman 22
5122853 2393115 2393115 defendant Peyntour Robert husbandman 593418 593418 Peyntour, Robert, of Soham Earl, husbandman 0
5214050 2419840 2419840 defendant Cade James clerk 593418 593418 (Cade, James, of Soham Earl, clerk 1
5222051 2422152 2422152 defendant Ingot William husbandman 593418 593418 Ingot, William, of Soham Earl, husbandman 3
5352353 2460834 2460834 defendant Drymedewe Robert husbandman 593418 593418 Drymedewe, Robert, of Soham Earl, husbandman 0
5480522 2499145 2499145 defendant Rodon William clerk 593418 593418 Rodon, William, of Soham Earl, clerk 0
5486125 2500736 2500736 defendant (not given) William rector of Rodon 593418 593418 Rodon, William, of Soham Earl, chaplain, rector of Gresforth 0
5550646 2520213 2520213 defendant Howard Thomas husbandman 593418 593418 Howard, Thomas, of Soham Earl, husbandman 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);