names

19 rows where place_id = 669704

✎ 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
3994153 2022660 2022660 plaintiff Clerke Henry   669704 669704 Clerke, Henry, of Wynfarthinge 0
4135869 2073159 2073159 defendant Arborowe Henry husbandman 669704 669704 Arborowe, Henry, of Wynfarthinge, husbandman 0
4157936 2080846 2080846 plaintiff Nwbye Thomas   669704 669704 Nwbye, Thomas, of Wynfarthinge 0
4159707 2081463 2081463 defendant Goldingham Francis gent 669704 669704 Goldingham, Francis, of Wynfarthinge, gent 0
4202130 2096290 2096290 defendant Johnson Henry husbandman 669704 669704 Johnson, Henry, of Wynfarthinge, husbandman 3
4223580 2103735 2103735 defendant Johnson Thomas sawyer 669704 669704 Johnson, Thomas, of Wynfarthinge, sawyer 1
4276808 2121818 2121818 defendant Alden Margaret widow 669704 669704 Alden, Margaret, of Wynfarthinge, widow 3
4281705 2123506 2123506 defendant Haylett Robert gent 669704 669704 Haylett, Robert, of Wynfarthinge, gent 0
4284771 2124601 2124601 defendant Heylott Robert gent 669704 669704 Heylott, Robert, of Wynfarthinge, gent 0
4293591 2127772 2127772 defendant Heylott Robert gent 669704 669704 Heylott, Robert, of Wynfarthinge, gent 0
4327786 2139617 2139617 defendant Hallyet Elizabeth widow 669704 669704 Hallyet, Elizabeth, of Wynfarthinge, widow 0
4327787 2139617 2139617 defendant Hallyet John gent 669704 669704 Hallyet, John, of Wynfarthinge, gent 1
4334560 2141831 2141831 defendant Hallyett Robert gent 669704 669704 Hallyett, Robert, of Wynfarthinge, gent 0
4348770 2146830 2146830 defendant Hallyett Elizabeth widow 669704 669704 Hallyett, Elizabeth, of Wynfarthinge, widow 0
4348777 2146831 2146831 defendant Johnson Thomas sawyer 669704 669704 Johnson, Thomas , of Wynfarthinge, sawyer 2
4372814 2155355 2155355 defendant Tylney Mathew husbandman 669704 669704 Tylney, Mathew, of Wynfarthinge, husbandman 0
4372815 2155355 2155355 defendant Blacke William husbandman 669704 669704 Blacke, William, of Wynfarthinge, husbandman 1
4400891 2164890 2164890 defendant Tylney Mathew husbandman 669704 669704 Tylney, Mathew, of Wynfarthinge, husbandman 0
4400892 2164890 2164890 defendant Blake William husbandman 669704 669704 Blake, William, of Wynfarthinge, 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);