names

25 rows where place_id = 633195

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3811266 1961420 1961420 defendant Skrutton William butcher 633195 633195 Skrutton, William, of Faltenham, butcher 0
4095344 2058656 2058656 defendant Clarke Robert husbandman 633195 633195 Clarke, Robert, of Faltenham, husbandman 3
4194068 2093480 2093480 defendant Maye Robert husbandman 633195 633195 Maye, Robert, of Faltenham, husbandman 1
4194069 2093480 2093480 defendant Mauster Robert tailor 633195 633195 Mauster, Robert, of Faltenham, tailor 2
4261227 2116721 2116721 defendant Margett Richard yeoman 633195 633195 Margett, Richard, of Faltenham, yeoman 0
4383284 2159127 2159127 defendant Garrard Henry   633195 633195 Garrard, Henry, of Faltenham, poldave weaver 0
4383285 2159127 2159127 defendant Scott Robert sawyer 633195 633195 Scott, Robert, of Faltenham, sawyer 1
4399396 2164387 2164387 defendant Parke George husbandman 633195 633195 Parke, George, of Faltenham, husbandman 0
4408617 2167475 2167475 defendant Reynold Humphrey husbandman 633195 633195 Reynold, Humphrey, of Faltenham, husbandman 1
4408619 2167475 2167475 defendant Richman William husbandman 633195 633195 Richman, William, of Faltenham, husbandman 3
4585067 2226751 2226751 defendant Greneman William   633195 633195 Greneman, William, of Faltenham 3
4593389 2229218 2229218 defendant Saxe Robert   633195 633195 Saxe, Robert, of Faltenham 1
4787115 2292033 2292033 defendant Wryghte John husbandman 633195 633195 Wryghte, John, of Faltenham, husbandman 0
4938212 2338328 2338328 defendant Insclyff Roger yeoman 633195 633195 Insclyff, Roger, of Faltenham, yeoman 1
4938216 2338329 2338329 defendant Insclyff Roger yeoman 633195 633195 Insclyff, Roger, of Faltenham, yeoman 1
4956825 2344002 2344002 defendant Insclyff Roger yeoman 633195 633195 Insclyff, Roger, of Faltenham, yeoman 0
4956826 2344002 2344002 defendant Margarete Robert husbandman 633195 633195 together with Margarete, Robert, of Faltenham, husbandman 1
4956827 2344002 2344002 defendant Scot John fisher 633195 633195 Scot, John, of Faltenham, fisher 2
4956828 2344002 2344002 defendant Bryghtled Thomas fisher 633195 633195 Bryghtled, Thomas, of Faltenham, fisher 3
4956829 2344002 2344002 defendant Smyth Peter laborer 633195 633195 Smyth, Peter, of Faltenham, laborer 4
4966495 2346914 2346914 defendant Sax John husbandman 633195 633195 Sax, John, of Faltenham, husbandman 0
5214951 2420094 2420094 defendant Holbroke Richard butcher 633195 633195 Holbroke, Richard, of Faltenham, butcher 2
5329851 2453996 2453996 defendant Bast Thomas butcher 633195 633195 Bast, Thomas, of Faltenham, butcher 0
5540410 2517131 2517131 defendant Coweper William yeoman 633195 633195 Coweper, William, of Faltenham, yeoman 0
5561781 2523430 2523430 defendant Bumpsted Robert yeoman 633195 633195 Bumpsted, Robert, of Faltenham, yeoman 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);