names

15 rows where place_id = 794779

✎ 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
4552360 2216690 2216690 defendant Bedyl Thomas   794779 794779 Bedyl, Thomas, of St Margaret's, in Rochester 1
4742468 2278297 2278297 defendant White Thomas yeoman 794779 794779 White, Thomas, of St Margaret's, Rochester, yeoman 0
4742766 2278391 2278391 defendant Fort Richard butcher 794779 794779 Fort, Richard, of St Margaret's, butcher 1
4996584 2355833 2355833 defendant Cokeham Michael laborer 794779 794779 Cokeham, Michael, of St Margaret's, by Rochester, laborer 0
5004623 2358255 2358255 defendant Gerold John husbandman 794779 794779 Gerold, John, of St Margaret's, by Rochester, husbandman 0
5041928 2369185 2369185 defendant Day William fisher 794779 794779 Day, William, of St Margaret's, fisher 3
5041929 2369185 2369185 defendant Williamson John lorimer 794779 794779 Williamson, John, of St Margaret's, lorimer 4
5131455 2395684 2395684 defendant Sclater John slater 794779 794779 Sclater, John, of St Margaret's in Leicester, slater 1
5136101 2397070 2397070 defendant Copyn William husbandman 794779 794779 Copyn, William, of St Margaret's near Dover, husbandman 0
5158755 2403681 2403681 defendant Grene John sawyer 794779 794779 Grene, John, of St Margaret's, by Rochester, sawyer 1
5174181 2408147 2408147 defendant Grene John sawyer 794779 794779 Grene, John, of St Margaret's, by Rochester, sawyer 1
5416817 2479947 2479947 defendant Broke Anne widow 794779 794779 Broke, Anne, of St Margaret's, Westminster, widow 0
5439061 2486603 2486603 defendant Pilcher Richard husbandman 794779 794779 Pilcher, Richard, of St Margaret's, by Rochester, husbandman 2
5461607 2493410 2493410 defendant Broke Anne widow 794779 794779 Broke, Anne, of St Margaret's, Westminster, widow 0
5473170 2496933 2496933 defendant Broke Anne widow 794779 794779 Broke, Anne, of St Margaret's, Westminster, widow 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);