names

17 rows where place_id = 755384

✎ 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
4427870 2173557 2173557 plaintiff Smythes Philip le chaplain 755384 755384 Smythes, Philip le, of Chiltenham, chaplain 0
4544883 2214318 2214318 defendant Devenysshe Richard   755384 755384 Devenysshe, Richard, of Chiltenham 0
4607485 2233451 2233451 defendant Webbe Thomas   755384 755384 Webbe, Thomas, of Chiltenham 0
4656599 2247956 2247956 plaintiff Chamberleyn Richard husbandman 755384 755384 Chamberleyn, Richard, of Chiltenham, husbandman 0
4656603 2247956 2247956 defendant Bochour Richard butcher 755384 755384 Bochour, Richard, of Chiltenham, butcher 3
4657697 2248294 2248294 defendant Webbe Thomas courser 755384 755384 Webbe, Thomas, of Chiltenham, courser 0
4663284 2249986 2249986 defendant Lok Thomas laborer 755384 755384 Lok, Thomas, of Chiltenham, laborer 0
4717585 2270835 2270835 defendant Nightyngale John husbandman 755384 755384 Nightyngale, John, of Chiltenham, husbandman 2
4745324 2279143 2279143 defendant Chiltenham John husbandman 755384 755384 Chiltenham, John, of Chiltenham, husbandman 3
4781235 2290144 2290144 defendant Webbe Thomas courser 755384 755384 Webbe, Thomas, of Chiltenham, courser 1
4784735 2291231 2291231 defendant Tanner Robert tanner 755384 755384 Tanner, Robert, of Chiltenham, tanner 0
4800666 2296390 2296390 defendant Chaloner Walter chaloner 755384 755384 Chaloner, Walter, of Chiltenham, chaloner 0
4806865 2298353 2298353 defendant Webbe Thomas husbandman 755384 755384 Webbe, Thomas, of Chiltenham, husbandman 1
4815229 2300875 2300875 defendant Mulleward Richard husbandman 755384 755384 Mulleward, Richard, of Chiltenham, husbandman 0
4818325 2301814 2301814 defendant Dyer John dyer 755384 755384 Dyer, John, of Chiltenham, dyer 0
4877645 2319967 2319967 defendant Lokke Thomas husbandman 755384 755384 Lokke, Thomas, of Chiltenham, husbandman 0
5628573 2552905 2552905 defendant Deyer William husbandman 755384 755384 Deyer, William, of Chiltenham, 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);