names

25 rows where place_id = 615925

✎ 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
3711504 1929907 1929907 defendant Courtys Richard husbandman 615925 615925 Courtys, Richard, of Hele, husbandman 0
3711505 1929907 1929907 defendant Bray John husbandman 615925 615925 Bray, John, of Hele, husbandman 1
3746434 1940805 1940805 defendant Seward Richard tanner 615925 615925 Seward, Richard, of Hele, tanner 0
3843562 1971524 1971524 plaintiff Clotworthy John (legal representative) 615925 615925 Clotworthy, John, of Hele, executors of 0
3937364 2002833 2002833 defendant Tompson Hugh husbandman 615925 615925 Tompson, Hugh, of Hele, husbandman 0
4445469 2183539 2183539 plaintiff Crokker William   615925 615925 Crokker, William, of Hele 0
4535650 2211425 2211425 plaintiff Smyth Robert   615925 615925 Smyth, Robert, of Hele 0
4547060 2215016 2215016 defendant Gybbes Walter   615925 615925 Gybbes, Walter, of Hele 0
4550006 2215937 2215937 plaintiff Crokkere Robert   615925 615925 Crokkere, Robert, of Hele 2
4550009 2215938 2215938 plaintiff Crokkere John   615925 615925 Crokkere, John, of Hele 0
4570120 2222228 2222228 defendant Houghles William   615925 615925 Houghles, William, of Hele 0
4570122 2222228 2222228 defendant Waryner John   615925 615925 Waryner, John, of Hele 2
4585155 2226778 2226778 plaintiff Crokkere John   615925 615925 (Crokkere, John, of Hele 1
4611317 2234604 2234604 defendant Croker John   615925 615925 Croker, John, of Hele 0
4763852 2284686 2284686 defendant Elys Robert husbandman 615925 615925 Elys, Robert, of Hele, husbandman 2
4778764 2289333 2289333 defendant Fria John husbandman 615925 615925 Fria, John, of Hele, husbandman 0
4953872 2343122 2343122 defendant Wylle Roger husbandman 615925 615925 Wylle, Roger, of Hele, husbandman 0
4953873 2343122 2343122 defendant Hoper Thomas husbandman 615925 615925 Hoper, Thomas, of Hele, husbandman 1
4953874 2343122 2343122 defendant atte Wylle William   615925 615925 atte Wylle, William, of Hele, mason 2
5056398 2373486 2373486 defendant Fraunceys Henry esq 615925 615925 Fraunceys, Henry, of Hele, esq 0
5242875 2428119 2428119 defendant Hayward John husbandman 615925 615925 Hayward, John, of Hele, husbandman 1
5301848 2445508 2445508 plaintiff Torner John   615925 615925 Torner, John, of Hele 3
5301853 2445509 2445509 plaintiff Torner John   615925 615925 Torner, John, of Hele 3
5349144 2459861 2459861 defendant Broun John husbandman 615925 615925 Broun, John, of Hele, husbandman 2
5561370 2523303 2523303 defendant Rodman Walter smith 615925 615925 Rodman, Walter, of Hele, 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);