names

21 rows where place_id = 763487

✎ 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
4497653 2199912 2199912 defendant Hobbes Thomas   763487 763487 Hobbes, Thomas, of Brytford 0
4639150 2242966 2242966 defendant Cook Walter   763487 763487 Cook, Walter, of Brytford 3
4755262 2282034 2282034 defendant Fyssher Nicholas fishmonger 763487 763487 Fyssher, Nicholas, of Brytford, fishmonger 0
4773494 2287680 2287680 defendant Fyssher Nicholas fishmonger 763487 763487 Fyssher, Nicholas, of Brytford, fishmonger 3
4805556 2297952 2297952 plaintiff Brys William yeoman 763487 763487 Brys, William, of Brytford, yeoman 0
4839400 2308244 2308244 defendant Stonyng Richard husbandman 763487 763487 Stonyng, Richard, of Brytford, husbandman 0
4840245 2308497 2308497 defendant Bryd Nicholas fishmonger 763487 763487 Bryd, Nicholas, of Brytford, fishmonger 0
4877743 2320000 2320000 defendant Spyne or Spyve William husbandman 763487 763487 Spyne or Spyve, William, of Brytford, husbandman 0
4887719 2322987 2322987 defendant Grey John husbandman 763487 763487 Grey, John, of Brytford, husbandman 0
4902325 2327336 2327336 defendant Grey John husbandman 763487 763487 (Grey, John, of Brytford, husbandman 2
4928255 2335264 2335264 defendant White Richard husbandman 763487 763487 White, Richard, of Brytford, husbandman 0
4974701 2349401 2349401 defendant Wygmore Henry merchant 763487 763487 Wygmore, Henry, of Brytford, clerk, merchant 0
5040906 2368899 2368899 defendant Wygmore Henry clerk 763487 763487 Wygmore, Henry, of Brytford, clerk 0
5041234 2368986 2368986 defendant Brys Henry (legal representative) 763487 763487 Brys, Henry, of Brytford, yeoman, executors of 0
5102050 2387025 2387025 defendant Markus John husbandman 763487 763487 Markus, John, of Brytford, husbandman 0
5102051 2387025 2387025 defendant Rose Walter husbandman 763487 763487 Rose, Walter, of Brytford, husbandman 1
5276543 2438216 2438216 defendant Farnyll John husbandman 763487 763487 Farnyll, John, of Brytford, husbandman 0
5286491 2441054 2441054 defendant Affernhill John yeoman 763487 763487 Affernhill, John, of Brytford, yeoman 0
5296410 2443939 2443939 defendant Farnyll or Farvyll John husbandman 763487 763487 Farnyll or Farvyll, John, of Brytford, husbandman 0
5310979 2448321 2448321 defendant Farnell John yeoman 763487 763487 Farnell, John, of Brytford, yeoman 2
5570434 2525921 2525921 defendant Stowte Richard husbandman 763487 763487 Stowte, Richard, of Brytford, husbandman 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);