names

24 rows where place_id = 626876

✎ 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
3772728 1949166 1949166 defendant Hawke William gent 626876 626876 Hawke, William, of Westgate, Canterbury, gent 0
3790355 1954799 1954799 defendant Hawke William gent 626876 626876 Hawke, William, of Westgate, Canterbury, gent 0
3806530 1959956 1959956 defendant Hawke William gent 626876 626876 Hawke, William, of Westgate, Canterbury, gent 0
4577121 2224352 2224352 defendant Bartelot John butcher 626876 626876 Bartelot, John, of Westgate, Canterbury, butcher 0
4652824 2246818 2246818 defendant Not William skinner 626876 626876 Not, William, of Westgate, Canterbury, skinner 0
4664065 2250249 2250249 defendant Bolde Henry weaver 626876 626876 Bolde, Henry, of Westgate, Canterbury, weaver 0
4666139 2250877 2250877 defendant Cook John brewer 626876 626876 Cook, John, of Westgate, Canterbury, brewer 0
4859958 2314482 2314482 plaintiff Chauntour John tanner 626876 626876 Chauntour, John, of Westgate, Canterbury, tanner 0
4892864 2324500 2324500 defendant Bertlot William gent 626876 626876 Bertlot, William, of Westgate, Canterbury, gent 0
4893793 2324754 2324754 defendant Brande Richard laborer 626876 626876 Brande, Richard, of Westgate, Canterbury, laborer 0
4893797 2324755 2324755 defendant Wortyng Walter husbandman 626876 626876 Wortyng, Walter, of Westgate, Canterbury, husbandman 2
4915494 2331344 2331344 defendant Hope John butcher 626876 626876 Hope, John, of Westgate, Canterbury, butcher 0
4920297 2332861 2332861 defendant Hope John butcher 626876 626876 Hope, John, of Westgate, Canterbury, butcher 0
4935679 2337546 2337546 defendant Fygge John husbandman 626876 626876 Fygge, John, of Westgate, Canterbury, husbandman 1
4943210 2339847 2339847 defendant Yerland James clerk 626876 626876 Yerland, James, of Westgate, Canterbury, clerk 0
4946511 2340902 2340902 defendant Formager William weaver 626876 626876 Formager, William, of Westgate, Canterbury, weaver 0
4952418 2342681 2342681 defendant Langebroke Geoffrey clerk 626876 626876 Langebroke, Geoffrey, of Westgate, Canterbury, clerk 0
4961752 2345478 2345478 defendant atte Welle Thomas weaver 626876 626876 atte Welle, Thomas, of Westgate, Canterbury, weaver 1
5057175 2373725 2373725 defendant Yonge John yeoman 626876 626876 Yonge, John, of Westgate, Canterbury, yeoman 2
5080390 2380625 2380625 defendant Yonge John yeoman 626876 626876 Yonge, John, of Westgate, Canterbury, yeoman 11
5080393 2380626 2380626 defendant Yonge John yeoman 626876 626876 Yonge, John, of Westgate, Canterbury, yeoman 1
5107961 2388768 2388768 defendant Couper William plumber 626876 626876 Couper, William, of Westgate, Canterbury, plumber 1
5551775 2520564 2520564 defendant Mepeham Thomas butcher 626876 626876 Mepeham, Thomas, of Westgate, Canterbury, butcher 0
5551776 2520564 2520564 defendant Melford William butcher 626876 626876 Melford, William, of Westgate, Canterbury, butcher 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);