names

37 rows where place_id = 705854

✎ 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
4159965 2081554 2081554 defendant Mather Christopher gent 705854 705854 Mather, Christopher, of Secroft, gent 0
4406255 2166656 2166656 defendant Mather James yeoman 705854 705854 Mather, James, of Secroft, yeoman 1
4550397 2216068 2216068 defendant West William   705854 705854 West, William, of Secroft 0
4550398 2216068 2216068 defendant Coteler Robert   705854 705854 Coteler, Robert, of Secroft 1
4550400 2216068 2216068 defendant Burle Thomas   705854 705854 Burle, Thomas, of Secroft 3
4550401 2216068 2216068 defendant Maundevyll Thomas   705854 705854 Maundevyll, Thomas, of Secroft 4
4820822 2302597 2302597 defendant Norton William parker 705854 705854 Norton, William, of Secroft, parker 0
4877080 2319801 2319801 defendant Skelbroke Nicholas gent 705854 705854 Skelbroke, Nicholas, of Secroft, gent 0
4893919 2324799 2324799 defendant Norton Agnes widow 705854 705854 Norton, Agnes, of Secroft, widow 0
4893920 2324799 2324799 defendant Norton William   705854 705854 Norton, William, of Secroft, servant 1
4893921 2324799 2324799 defendant Symson William   705854 705854 Symson, William, of Secroft, servant 2
4893923 2324800 2324800 defendant Norton Agnes widow 705854 705854 Norton, Agnes, of Secroft, widow 0
4893924 2324800 2324800 defendant Norton William   705854 705854 Norton, William, of Secroft, servant 1
4893925 2324800 2324800 defendant Symson William   705854 705854 Symson, William, of Secroft, servant 2
4896692 2325630 2325630 defendant Norton Agnes widow 705854 705854 Norton, Agnes, of Secroft, widow 0
4896693 2325630 2325630 defendant Norton William   705854 705854 Norton, William, of Secroft, servant 1
4896694 2325630 2325630 defendant Symson William   705854 705854 Symson, William, of Secroft, servant 2
4896761 2325644 2325644 defendant Norton Agnes widow 705854 705854 Norton, Agnes, of Secroft, widow 0
4896762 2325644 2325644 defendant Norton William   705854 705854 Norton, William, of Secroft, servant 1
4896763 2325644 2325644 defendant Symson William   705854 705854 Symson, William, of Secroft, servant 2
5070303 2377611 2377611 defendant Beverley John laborer 705854 705854 Beverley, John, of Secroft, laborer 0
5070304 2377611 2377611 defendant Beverley William laborer 705854 705854 Beverley, William, of Secroft, laborer 1
5071472 2377963 2377963 defendant Hancok Richard husbandman 705854 705854 Hancok, Richard, of Secroft, husbandman 3
5105841 2388153 2388153 defendant Helde John smith 705854 705854 Helde, John, of Secroft, smith 0
5105848 2388154 2388154 defendant Helde John smith 705854 705854 Helde, John, of Secroft, smith 0
5154314 2402419 2402419 defendant Beket Christopher smith 705854 705854 Beket, Christopher, of Secroft, smith 3
5171425 2407367 2407367 defendant Beket Christopher smith 705854 705854 Beket, Christopher, of Secroft, smith 3
5218975 2421279 2421279 defendant Norton Thomas laborer 705854 705854 Norton, Thomas, of Secroft, laborer 0
5218977 2421280 2421280 defendant Norton Thomas laborer 705854 705854 Norton, Thomas, of Secroft, laborer 0
5272808 2437122 2437122 defendant Noeton William smith 705854 705854 Noeton, William, of Secroft, smith 3
5281527 2439663 2439663 defendant Quynteyn Robert   705854 705854 Quynteyn, Robert, of Secroft, wire drawer 1
5281546 2439668 2439668 defendant Quynteyn Robert smith 705854 705854 Quynteyn, Robert, of Secroft, smith 3
5287579 2441393 2441393 defendant Beket John   705854 705854 Beket, John, of Secroft, wire drawer 1
5287582 2441394 2441394 defendant Beket John   705854 705854 Beket, John, of Secroft, wire drawer 1
5288176 2441560 2441560 defendant Heldes John smith 705854 705854 Heldes, John, of Secroft, smith 1
5288177 2441560 2441560 defendant Norton Thomas smith 705854 705854 Norton, Thomas, of Secroft, smith 2
5316113 2449893 2449893 defendant Helde John smith 705854 705854 Helde, John, of Secroft, smith 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);