names

11 rows where place_id = 594714

✎ 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
3617269 1873025 1873025 defendant Whytlok John laborer 594714 594714 Whytlok, John, of Heytesbury, laborer 0
3676134 1918576 1918576 plaintiff Hungerford Edward   594714 594714 Hungerford, Edward, of Heytesbury, knight 0
4847573 2310739 2310739 defendant Walter John butcher 594714 594714 Walter, John, of Heytesbury, butcher 0
4847574 2310739 2310739 defendant Taillour John tailor 594714 594714 Taillour, John, of Heytesbury, tailor 1
5035813 2367332 2367332 plaintiff Towekere Thomas   594714 594714 Towekere, Thomas, of Heytesbury 0
5035815 2367333 2367333 plaintiff Towekere Thomas   594714 594714 Towekere, Thomas, of Heytesbury 0
5076725 2379537 2379537 defendant Prynce Robert husbandman 594714 594714 Prynce, Robert, of Heytesbury, husbandman 0
5076726 2379537 2379537 defendant Heryng John fisher 594714 594714 Heryng, John, of Heytesbury, fisher 1
5229798 2424337 2424337 defendant Englysshe Peter yeoman 594714 594714 Englysshe, Peter, of Heytesbury, yeoman 1
5245332 2428794 2428794 defendant Mervyn John esq 594714 594714 Mervyn, John, of Heytesbury, esq 4
5245337 2428795 2428795 defendant Mervyn John esq 594714 594714 Mervyn, John, of Heytesbury, esq 3

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);