names

25 rows where place_id = 618371

✎ 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
3724233 1933867 1933867 defendant Tredenek Stephen clerk 618371 618371 Tredenek, Stephen, of Heanok, clerk 0
4440224 2181858 2181858 plaintiff Belhameslond William   618371 618371 Belhameslond, William, of Heanok, rector 2
4440232 2181859 2181859 plaintiff Belhameslond William   618371 618371 Belhameslond, William, of Heanok, rector 2
4464722 2189635 2189635 plaintiff Wenlak Thomas   618371 618371 Wenlak, Thomas, of Heanok, vicar, on his own account 0
4464727 2189636 2189636 plaintiff Wenlok Thomas   618371 618371 Wenlok, Thomas, of Heanok, vicar 0
4464730 2189637 2189637 plaintiff Wenlok Thomas   618371 618371 Wenlok, Thomas, of Heanok, vicar 0
4464735 2189638 2189638 plaintiff Wenlok Thomas   618371 618371 Wenlok, Thomas, of Heanok, vicar, on his own account 0
4798690 2295767 2295767 defendant Cok William clerk 618371 618371 Cok, William, of Heanok, clerk 0
5017624 2362030 2362030 defendant Langelegh Thomas husbandman 618371 618371 Langelegh, Thomas, of Heanok, husbandman 3
5120508 2392428 2392428 defendant May William husbandman 618371 618371 May, William, of Heanok, husbandman 1
5120509 2392428 2392428 defendant Germyn John husbandman 618371 618371 Germyn, John, of Heanok, husbandman 2
5120510 2392428 2392428 defendant Perre Peter husbandman 618371 618371 Perre, Peter, of Heanok, husbandman 3
5120511 2392428 2392428 defendant Tuyscombe John husbandman 618371 618371 Tuyscombe, John, of Heanok, husbandman 4
5352513 2460879 2460879 defendant Calwa Richard clerk 618371 618371 Calwa, Richard, of Heanok, clerk 0
5399977 2475079 2475079 defendant Stoddon Robert husbandman 618371 618371 Stoddon, Robert, of Heanok, husbandman 0
5399978 2475079 2475079 defendant Grene William husbandman 618371 618371 Grene, William, of Heanok, husbandman 1
5399979 2475079 2475079 defendant Grene John husbandman 618371 618371 Grene, John, of Heanok, husbandman 2
5399980 2475079 2475079 defendant Kelwa Richard clerk 618371 618371 Kelwa, Richard, of Heanok, clerk 3
5412969 2478821 2478821 defendant Stodden Robert husbandman 618371 618371 Stodden, Robert, of Heanok, husbandman 0
5412970 2478821 2478821 defendant Grene William husbandman 618371 618371 Grene, William, of Heanok, husbandman 1
5412971 2478821 2478821 defendant Grene John husbandman 618371 618371 Grene, John, of Heanok, husbandman 2
5412972 2478821 2478821 defendant Kelwa Richard clerk 618371 618371 Kelwa, Richard, of Heanok, clerk 3
5428023 2483335 2483335 defendant Stodden Robert husbandman 618371 618371 Stodden, Robert, of Heanok, husbandman Grene, William, of Heanok, husbandman 0
5428024 2483335 2483335 defendant Grene John husbandman 618371 618371 Grene, John, of Heanok, husbandman 1
5428025 2483335 2483335 defendant Kolwa Richard clerk 618371 618371 Kolwa, Richard, of Heanok, clerk 2

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);