names

24 rows where place_id = 651449

✎ 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
3743701 1939911 1939911 defendant Seton Alexander husbandman 651449 651449 Seton, Alexander, of Bocton under Blean, husbandman 3
3917826 1996323 1996323 plaintiff Harwarde Henry gent 651449 651449 Harwarde, Henry, of Bocton, gent 0
4053760 2043725 2043725 defendant Perne William gent 651449 651449 Perne, William, of Bocton, gent 0
4119448 2067248 2067248 defendant Arnold William gent 651449 651449 Arnold, William, of Bocton, gent 0
4142409 2075517 2075517 defendant Arnold William gent 651449 651449 Arnold, William, of Bocton, gent 0
4243323 2110757 2110757 defendant Perne William gent 651449 651449 Perne, William, of Bocton, gent 0
4328551 2139865 2139865 defendant Claxton Thomas gent 651449 651449 Claxton, Thomas, of Bocton, gent 1
4594815 2229633 2229633 defendant Purs John   651449 651449 Purs, John, of Bocton 0
4651741 2246508 2246508 defendant Ricard John husbandman 651449 651449 Ricard, John, of Bocton under Bleen, husbandman 20
4651742 2246508 2246508 defendant atte Thorne Philip husbandman 651449 651449 atte Thorne, Philip, of Bocton under Bleen, husbandman 21
4651743 2246508 2246508 defendant Bodyll Henry husbandman 651449 651449 Bodyll, Henry, of Bocton under Bleen, husbandman 22
4655289 2247540 2247540 defendant Curteys Thomas husbandman 651449 651449 Curteys, Thomas, of Bocton, husbandman 0
4656862 2248042 2248042 defendant Yevan Philip yeoman 651449 651449 Yevan, Philip, of Bocton under Bleen, yeoman 1
4659103 2248718 2248718 defendant de Leghe William husbandman 651449 651449 de Leghe, William, of Bocton under Blean, husbandman 0
4875662 2319343 2319343 defendant Hayte Thomas laborer 651449 651449 Hayte, Thomas, of Bocton under Blen, laborer 0
4917354 2331940 2331940 defendant Bole Robert husbandman 651449 651449 Bole, Robert, of Bocton under Blean, husbandman 0
4940899 2339177 2339177 defendant Sare Robert husbandman 651449 651449 Sare, Robert, of Bocton under Blen, husbandman 0
4956898 2344022 2344022 defendant Norman Henry husbandman 651449 651449 Norman, Henry, of Bocton under Blen, husbandman 0
5214171 2419871 2419871 defendant Serles John (legal representative) 651449 651449 Serles, John, of Bocton under Blean, yeoman, executors of 0
5227260 2423602 2423602 defendant Dodyngton Thomas smith 651449 651449 Dodyngton, Thomas, of Bocton under Bleen, smith 3
5279416 2439065 2439065 defendant Best Thomas (legal representative) 651449 651449 Best, Thomas, of Bocton under Blean, executors of 1
5539947 2516977 2516977 defendant Kenworth John butcher 651449 651449 Kenworth, John, of Bocton under Blene, butcher 0
5626859 2552375 2552375 defendant Waterman William yeoman 651449 651449 Waterman, William, of Bocton under Blean, yeoman 0
5626861 2552376 2552376 defendant Waterman William yeoman 651449 651449 Waterman, William, of Bocton under Blean, 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);