names

33 rows where place_id = 595417

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620422 1873970 1873970 defendant Makehey Thomas clerk 595417 595417 Makehey, Thomas, of Spaldyngton, clerk 5
3739502 1938562 1938562 defendant Vavasour Peter   595417 595417 Vavasour, Peter, of Spaldyngton, knight 0
3739504 1938563 1938563 defendant Vavasour Peter   595417 595417 Vavasour, Peter, of Spaldyngton, knight 0
3915697 1995625 1995625 plaintiff Dent William husbandman 595417 595417 Dent, William, of Spaldyngton, husbandman 0
4045880 2040974 2040974 plaintiff Shafton William   595417 595417 Shafton, William, of Spaldyngton 0
4045882 2040975 2040975 plaintiff Shafton William   595417 595417 Shafton, William, of Spaldyngton 0
4079963 2053137 2053137 plaintiff Vavasour Peter (legal representative) 595417 595417 Vavasour, Peter, of Spaldyngton, esq, executor of 0
4115262 2065750 2065750 plaintiff Vavasour Peter (legal representative) 595417 595417 Vavasour, Peter, of Spaldyngton, esq, executor of 0
4441695 2182343 2182343 defendant Goldsmyth William   595417 595417 Goldsmyth, William, of Spaldyngton 0
4441699 2182343 2182343 defendant Fissher Robert   595417 595417 Fissher, Robert, of Spaldyngton 4
4444781 2183343 2183343 defendant Rag Nicholas   595417 595417 Rag, Nicholas, of Spaldyngton 0
4444787 2183343 2183343 defendant Stevenson Robert   595417 595417 Stevenson, Robert, of Spaldyngton 6
4458589 2187735 2187735 defendant Day Henry   595417 595417 Day, Henry, of Spaldyngton 2
4580557 2225406 2225406 plaintiff del Hay Peter   595417 595417 del Hay, Peter, of Spaldyngton 0
4580564 2225407 2225407 plaintiff del Hay Peter   595417 595417 del Hay, Peter, of Spaldyngton 0
4580570 2225408 2225408 plaintiff del Hay Peter   595417 595417 del Hay, Peter, of Spaldyngton 0
4580574 2225409 2225409 plaintiff del Hay Peter   595417 595417 del Hay, Peter, of Spaldyngton 0
4580579 2225410 2225410 plaintiff del Hay Peter   595417 595417 del Hay, Peter, of Spaldyngton 0
4580584 2225411 2225411 plaintiff del Hay Peter   595417 595417 del Hay, Peter, of Spaldyngton 0
4580588 2225412 2225412 plaintiff del Hay Peter   595417 595417 del Hay, Peter, of Spaldyngton 0
4580594 2225413 2225413 plaintiff del Hay Peter   595417 595417 del Hay, Peter, of Spaldyngton 0
4580611 2225417 2225417 plaintiff del Haye Peter   595417 595417 del Haye, Peter, of Spaldyngton 0
4784171 2291049 2291049 plaintiff del Hay Peter esq 595417 595417 del Hay, Peter, of Spaldyngton, esq 0
4809012 2298995 2298995 plaintiff del Hay Peter esq 595417 595417 del Hay, Peter, of Spaldyngton, esq 0
5249732 2430041 2430041 plaintiff Vavasour John   595417 595417 Vavasour, John, of Spaldyngton 0
5295605 2443704 2443704 defendant Thykholyns Thomas yeoman 595417 595417 Thykholyns, Thomas, of Spaldyngton, yeoman 0
5327577 2453322 2453322 plaintiff Vavasour John esq 595417 595417 Vavasour, John, of Spaldyngton, esq 0
5327582 2453323 2453323 plaintiff Vavasour John esq 595417 595417 Vavasour, John, of Spaldyngton, esq 0
5362825 2464016 2464016 plaintiff Vavasour John   595417 595417 Vavasour, John, of Spaldyngton 0
5394039 2473355 2473355 plaintiff Vavasour John, senior esq 595417 595417 Vavasour, John, senior, of Spaldyngton, esq 0
5399414 2474907 2474907 defendant Bonde Henry husbandman 595417 595417 Bonde, Henry, of Spaldyngton, husbandman 2
5412388 2478651 2478651 defendant Paarke Robert (legal representative) 595417 595417 Paarke, Robert, of Spaldyngton, executors of 0
5613757 2548077 2548077 defendant del Hay John   595417 595417 del Hay, John, of Spaldyngton 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);