names

31 rows where place_id = 760892

✎ 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
4441828 2182380 2182380 defendant Kerde Margaret (legal representative) 760892 760892 Kerde, Margaret, of Frome Braunche, executor of 0
4441833 2182381 2182381 defendant Kerde Margaret (legal representative) 760892 760892 Kerde, Margaret, of Frome Braunche, executors of 0
4441838 2182382 2182382 defendant Kerde Margaret (legal representative) 760892 760892 Kerde, Margaret, of Frome Braunche, executors of 0
4474265 2192605 2192605 defendant Ridelere Nicholas   760892 760892 Ridelere, Nicholas, of Frome Braunche 0
4476900 2193433 2193433 defendant Souter Ralph   760892 760892 Souter, Ralph, of Frome Braunche 0
4476901 2193433 2193433 defendant Prestes John, junior   760892 760892 Prestes, John, junior, of Frome Braunche, 1
4493899 2198786 2198786 defendant Knyght Hugh   760892 760892 Knyght, Hugh, of Frome Braunche 0
4538806 2212411 2212411 plaintiff Twyneo William   760892 760892 Twyneo, William, of Frome Braunche 0
4538810 2212412 2212412 plaintiff Twynoo William   760892 760892 Twynoo, William, of Frome Braunche 0
4666018 2250845 2250845 defendant Gillotte John husbandman 760892 760892 Gillotte, John, of Frome Braunche, husbandman 0
4712262 2269151 2269151 defendant Saundre John weaver 760892 760892 Saundre, John, of Frome Braunche, weaver 3
4712264 2269151 2269151 defendant Osbern Richard   760892 760892 Osbern, Richard, of Frome Braunche, cloth maker 5
4757027 2282569 2282569 plaintiff Bogleygh Robert weaver 760892 760892 Bogleygh, Robert, of Frome Braunche, weaver 0
4757028 2282569 2282569 defendant Craas Robert draper 760892 760892 Craas, Robert, of Frome Braunche, draper 0
4764330 2284839 2284839 defendant Crase Robert clothier 760892 760892 Crase, Robert, of Frome Braunche, clothier 0
4764331 2284839 2284839 defendant Lotsam Richard yeoman 760892 760892 Lotsam, Richard, of Frome Braunche, yeoman 1
4775750 2288412 2288412 defendant Tyler Henry tiler 760892 760892 Tyler, Henry, of Frome Braunche, tiler 0
4778964 2289399 2289399 plaintiff Bogleigh Robert weaver 760892 760892 Bogleigh, Robert, of Frome Braunche, weaver 0
4778965 2289399 2289399 defendant Craas Robert draper 760892 760892 Craas, Robert, of Frome Braunche, draper 0
4815775 2301037 2301037 defendant Austyn William fuller 760892 760892 Austyn, William, of Frome Braunche, fuller 0
4816124 2301131 2301131 defendant Rulys John husbandman 760892 760892 Rulys, John, of Frome Braunche, husbandman 0
4820165 2302379 2302379 defendant Puttok Thomas clerk 760892 760892 Puttok, Thomas, of Frome Braunche, clerk 0
4885178 2322253 2322253 defendant Leversegge Robert gent 760892 760892 Leversegge, Robert, of Frome Braunche, gent 0
4897968 2326030 2326030 defendant Leversegge Robert esq 760892 760892 Leversegge, Robert, of Frome Braunche, esq 0
4907613 2328946 2328946 defendant (illegible) illegible, junior laborer 760892 760892 ---, ----, junior, of Frome Braunche, laborer 0
4917873 2332101 2332101 defendant Anyn Richard, junior laborer 760892 760892 Anyn, Richard, junior, of Frome Braunche, laborer 0
4929254 2335568 2335568 defendant Roulond Thomas fuller 760892 760892 Roulond, Thomas, of Frome Braunche, fuller 1
4932192 2336466 2336466 defendant Twyneho Henry merchant 760892 760892 Twyneho, Henry, of Frome Braunche, merchant 0
4959985 2344949 2344949 defendant Austyn John tucker 760892 760892 Austyn, John, of Frome Braunche, tucker 0
5001657 2357378 2357378 defendant P_th William weaver 760892 760892 P_th, William, of Frome Braunche, weaver 1
5001658 2357378 2357378 defendant Greynton John husbandman 760892 760892 Greynton, John, of Frome Braunche, husbandman 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);