names

12 rows where place_id = 592067

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606453 1869687 1869687 defendant Austyn William husbandman 592067 592067 Austyn, William, of Catworth, Hunts, husbandman 0
4794836 2294530 2294530 defendant Bokyngham William chaplain 592067 592067 Bokyngham, William, of Catworth, Hunts, chaplain 2
4999524 2356731 2356731 defendant Grove Simon husbandman 592067 592067 Grove, Simon, of Catworth, Hunts, husbandman 2
5119818 2392233 2392233 defendant Bayes William woolman 592067 592067 Bayes, William, of Catworth, Hunts, woolman 0
5130096 2395290 2395290 defendant Bayis William husbandman 592067 592067 Bayis, William, of Catworth, Hunts, husbandman 0
5135052 2396749 2396749 defendant Baysse Richard husbandman 592067 592067 Baysse, Richard, of Catworth, Hunts, husbandman 0
5196090 2414602 2414602 defendant Bays William woolman 592067 592067 Bays, William, of Catworth, Hunts, woolman 2
5255200 2431742 2431742 defendant Bayns John woolman 592067 592067 Bayns, John, of Catworth, Hunts, woolman 0
5353164 2461064 2461064 defendant Gold John husbandman 592067 592067 Gold, John, of Catworth, Hunts, husbandman 11
5425329 2482548 2482548 defendant Tookynton Henry gent 592067 592067 Tookynton, Henry, of Catworth, Hunts, gent 0
5456595 2491894 2491894 defendant Torkyngton Henry gent 592067 592067 Torkyngton, Henry, of Catworth, Hunts, gent 0
5573677 2526864 2526864 defendant Bayes John husbandman 592067 592067 Bayes, John, of Catworth, Hunts, 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);