names

12 rows where place_id = 799207

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4766131 2285396 2285396 defendant Dryghteyene Thomas gent 799207 799207 Dryghteyene, Thomas, of Bernham Brome, gent 4
4911293 2330038 2330038 defendant Edmund Richard husbandman 799207 799207 Edmund, Richard, of Bernham Brome, husbandman 0
4914620 2331090 2331090 defendant Hobbys William   799207 799207 Hobbys, William, of Bernham Brome, bailiff 3
5024049 2363944 2363944 defendant Burgh Robert yeoman 799207 799207 Burgh, Robert, of Bernham Brome, yeoman 1
5036051 2367400 2367400 defendant Burgh Robert husbandman 799207 799207 Burgh, Robert, of Bernham Brome, husbandman 2
5049317 2371428 2371428 defendant Kyrgate Nicholas husbandman 799207 799207 Kyrgate, Nicholas, of Bernham Brome, husbandman 0
5122228 2392922 2392922 defendant Burgh Robert husbandman 799207 799207 Burgh, Robert, of Bernham Brome, husbandman 0
5145225 2399744 2399744 defendant Lawes Henry husbandman 799207 799207 Lawes, Henry, of Bernham Brome, husbandman 0
5165737 2405724 2405724 defendant Lawes Henry husbandman 799207 799207 Lawes, Henry, of Bernham Brome, husbandman 0
5180243 2409960 2409960 defendant Lawes Henry husbandman 799207 799207 Lawes, Henry, of Bernham Brome, husbandman 0
5254449 2431514 2431514 defendant Lawys Stacy husbandman 799207 799207 (Lawys, Stacy, of Bernham Brome, husbandman 5
5325122 2452598 2452598 defendant Lawes John husbandman 799207 799207 Lawes, John, of Bernham Brome, 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);