names

25 rows where place_id = 781719

✎ 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
4674047 2257494 2257494 defendant Neve John husbandman 781719 781719 Neve, John, of Earls Soham, husbandman 0
4927921 2335168 2335168 defendant Dale William husbandman 781719 781719 Dale, William, of Earls Soham, husbandman 0
5129402 2395087 2395087 defendant Fox Thomas husbandman 781719 781719 Fox, Thomas, of Earls Soham, husbandman 1
5135075 2396755 2396755 defendant Ingot William husbandman 781719 781719 Ingot, William, of Earls Soham, husbandman 2
5146417 2400084 2400084 defendant Wardeyn John husbandman 781719 781719 Wardeyn, John, of Earls Soham, husbandman 3
5148696 2400743 2400743 defendant Fox Thomas husbandman 781719 781719 Fox, Thomas, of Earls Soham, husbandman 1
5155165 2402658 2402658 defendant Ingot William husbandman 781719 781719 Ingot, William, of Earls Soham, husbandman 2
5166593 2405948 2405948 defendant Wardeyn John husbandman 781719 781719 Wardeyn, John, of Earls Soham, husbandman 3
5167904 2406325 2406325 defendant Fox Thomas husbandman 781719 781719 Fox, Thomas, of Earls Soham, husbandman 1
5183604 2410940 2410940 defendant Fox Thomas husbandman 781719 781719 Fox, Thomas, of Earls Soham, husbandman 1
5204697 2417119 2417119 defendant Folkard John laborer 781719 781719 Folkard, John, of Earls Soham, laborer 1
5416526 2479860 2479860 defendant Revet John smith 781719 781719 Revet, John, of Earls Soham, smith 0
5427678 2483235 2483235 defendant Hayman Alexander yeoman 781719 781719 Hayman, Alexander, of Earls Soham, yeoman 0
5430867 2484173 2484173 defendant Campell John laborer 781719 781719 Campell, John, of Earls Soham, laborer 1
5430871 2484174 2484174 defendant Campell John laborer 781719 781719 Campell, John, of Earls Soham, laborer 1
5434144 2485167 2485167 defendant Rodon William clerk 781719 781719 Rodon, William, of Earls Soham, clerk 0
5436013 2485711 2485711 defendant (not given) William rector of Rodon 781719 781719 Rodon, William, of Earls Soham, clerk, chaplain & rector of Cresforth 0
5445358 2488510 2488510 defendant Harman (illegible) yeoman 781719 781719 Harman, _, of Earls Soham, yeoman 0
5449612 2489776 2489776 defendant Rodon William clerk 781719 781719 Rodon, William, of Earls Soham, clerk 0
5450861 2490145 2490145 defendant (not given) William rector of Roden 781719 781719 Roden, William, of Earls Soham, chaplain & rector of Gresforth 0
5460412 2493055 2493055 defendant Renet John yeoman 781719 781719 Renet, John, of Earls Soham, yeoman 0
5461786 2493468 2493468 defendant Rodon William clerk 781719 781719 Rodon, William, of Earls Soham, clerk 0
5462975 2493836 2493836 defendant Rodon William chaplain & rector 781719 781719 Rodon, William, of Earls Soham, chaplain & rector 0
5469817 2495900 2495900 defendant Harman Alexander yeoman 781719 781719 Harman, Alexander, of Earls Soham, yeoman 0
5472004 2496587 2496587 defendant Roo John yeoman 781719 781719 Roo, John, of Earls Soham, 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);