names

22 rows where place_id = 609139

✎ 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
3677194 1918909 1918909 defendant Lawes John butcher 609139 609139 Lawes, John, of Barnhambrome, butcher 0
3698106 1925633 1925633 defendant Hoggys John carpenter 609139 609139 Hoggys, John, of Barnhambrome, carpenter 0
3698107 1925633 1925633 defendant Osborn John husbandman 609139 609139 Osborn, John, of Barnhambrome, husbandman 1
3710519 1929612 1929612 defendant Martyns Thomas miller 609139 609139 Martyns, Thomas, of Barnhambrome, miller 1
3710520 1929612 1929612 defendant Lowth John husbandman 609139 609139 Lowth, John, of Barnhambrome, husbandman 2
3710521 1929612 1929612 defendant Quentrell Thomas smith 609139 609139 Quentrell, Thomas, of Barnhambrome, smith 3
3725686 1934321 1934321 defendant Lowthe John husbandman 609139 609139 Lowthe, John, of Barnhambrome, husbandman 0
3725687 1934321 1934321 defendant Whentyll Thomas smith 609139 609139 Whentyll, Thomas, of Barnhambrome, smith 1
3725688 1934321 1934321 defendant Debney George laborer 609139 609139 Debney, George, of Barnhambrome, laborer 2
3740681 1938948 1938948 defendant Queyntrell Thomas husbandman 609139 609139 Queyntrell, Thomas, of Barnhambrome, husbandman 1
3741585 1939238 1939238 defendant Lowth John husbandman 609139 609139 Lowth, John, of Barnhambrome, husbandman 0
3741586 1939238 1939238 defendant Whentrell Thomas smith 609139 609139 Whentrell, Thomas, of Barnhambrome, smith 1
3741587 1939238 1939238 defendant Debney George laborer 609139 609139 Debney, George, of Barnhambrome, laborer 2
3768772 1947884 1947884 defendant Lowth John husbandman 609139 609139 Lowth, John, of Barnhambrome, husbandman 0
3772473 1949081 1949081 defendant Lowth Thomas husbandman 609139 609139 Lowth, Thomas, of Barnhambrome, husbandman 0
3785705 1953321 1953321 defendant Lowe John husbandman 609139 609139 Lowe, John, of Barnhambrome, husbandman 1
3785706 1953321 1953321 defendant Kent John husbandman 609139 609139 Kent, John, of Barnhambrome, husbandman 2
3786574 1953595 1953595 defendant Lowthe John, senior husbandman 609139 609139 Lowthe, John, senior, of Barnhambrome, husbandman 0
3789836 1954649 1954649 defendant Lowe John husbandman 609139 609139 Lowe, John, of Barnhambrome, husbandman 3
3789837 1954649 1954649 defendant Bukke William husbandman 609139 609139 Bukke, William, of Barnhambrome, husbandman 4
5599868 2534844 2534844 plaintiff Hamlyng John clerk 609139 609139 Hamlyng, John, of Barnhambrome, clerk 0
5607308 2537176 2537176 defendant Laws Thomas, senior husbandman 609139 609139 Laws, Thomas, senior, of Barnhambrome, 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);