names

24 rows where place_id = 649963

✎ 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
3909514 1993484 1993484 defendant Wottes Robert butcher 649963 649963 Wottes, Robert, of Castelcombe, butcher 0
3956578 2009365 2009365 defendant Cowper Thomas clerk 649963 649963 Cowper, Thomas, of Castelcombe, clerk 0
3956579 2009365 2009365 defendant Batten John weaver 649963 649963 Batten, John, of Castelcombe, weaver 1
4662817 2249831 2249831 defendant Riche Richard husbandman 649963 649963 Riche, Richard, of Castelcombe, husbandman 0
4889587 2323540 2323540 defendant Newebolte Simon tucker 649963 649963 Newebolte, Simon, of Castelcombe, tucker 0
4899113 2326364 2326364 defendant atte Mille William husbandman 649963 649963 atte Mille, William, of Castelcombe, husbandman 0
4938253 2338344 2338344 defendant Croston or Crofton John tucker 649963 649963 Croston or Crofton, John, of Castelcombe, tucker 0
4945755 2340659 2340659 defendant Milward William yeoman 649963 649963 Milward, William, of Castelcombe, yeoman 0
4945756 2340659 2340659 defendant Milward Ralph   649963 649963 Milward, Ralph, of Castelcombe, servant 1
4956163 2343805 2343805 plaintiff Truledek Richard weaver 649963 649963 Truledek, Richard, of Castelcombe, weaver 0
4956165 2343805 2343805 defendant Blakemon alias Bullok John fuller 649963 649963 Blakemon alias Bullok, John, of Castelcombe, fuller 1
4969945 2347959 2347959 defendant Hopkyns William husbandman 649963 649963 Hopkyns, William, of Castelcombe, husbandman 3
5053148 2372537 2372537 defendant Jonys Edward tucker 649963 649963 Jonys, Edward, of Castelcombe, tucker 0
5053675 2372701 2372701 defendant Piers Henry fuller 649963 649963 Piers, Henry, of Castelcombe, fuller 6
5053676 2372701 2372701 defendant Cokkushale John weaver 649963 649963 Cokkushale, John, of Castelcombe, weaver 7
5115713 2391022 2391022 defendant Sampson William husbandman 649963 649963 Sampson, William, of Castelcombe, husbandman 0
5280517 2439379 2439379 defendant Lyllyngston Richard weaver 649963 649963 Lyllyngston, Richard, of Castelcombe, weaver 1
5280518 2439379 2439379 defendant Walflete Robert weaver 649963 649963 Walflete, Robert, of Castelcombe, weaver 2
5280521 2439379 2439379 defendant Taylour William tailor 649963 649963 Taylour, William, of Castelcombe, tailor 5
5280528 2439380 2439380 defendant Ityssh Ricard laborer 649963 649963 together with Ityssh, Ricard, of Castelcombe, laborer 4
5280529 2439380 2439380 defendant Lyllyngston Richard weaver 649963 649963 Lyllyngston, Richard, of Castelcombe, weaver 5
5280530 2439380 2439380 defendant Walflete Robert weaver 649963 649963 Walflete, Robert, of Castelcombe, weaver 6
5291993 2442663 2442663 defendant Hobyn Nicholas butcher 649963 649963 Hobyn, Nicholas, of Castelcombe, butcher 0
5601085 2535225 2535225 defendant Insale Thomas husbandman 649963 649963 Insale, Thomas, of Castelcombe, 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);