names

33 rows where place_id = 616584

✎ 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
3715156 1931035 1931035 defendant Bulkyn John yeoman 616584 616584 Bulkyn, John, of Keston, Hunts, yeoman 0
3715163 1931037 1931037 defendant Bulkyn John yeoman 616584 616584 Bulkyn, John, of Keston, Hunts, yeoman 0
3742775 1939597 1939597 defendant Bulkyn William yeoman 616584 616584 Bulkyn, William, of Keston, Hunts, yeoman 0
3768854 1947906 1947906 defendant Bulkyn John, junior yeoman 616584 616584 Bulkyn, John, junior, of Keston, Hunts, yeoman 0
3814198 1962344 1962344 defendant Bulkyn John yeoman 616584 616584 Bulkyn, John, of Keston, Hunts, yeoman 0
3879395 1983361 1983361 defendant Bulken John yeoman 616584 616584 Bulken, John, of Keston, Hunts, yeoman 0
4159670 2081450 2081450 defendant Carter Henry carpenter 616584 616584 Carter, Henry, of Keston, Hunts, carpenter 0
4228213 2105349 2105349 defendant Clyfford Walter gent 616584 616584 Clyfford, Walter, of Keston, Hunts, gent 0
4621628 2237751 2237751 defendant Kyng Richard   616584 616584 Kyng, Richard, of Keston, Hunts 1
4647860 2245440 2245440 defendant Kyng John   616584 616584 Kyng, John, of Keston, Hunts 1
4707922 2267848 2267848 defendant Dycon John husbandman 616584 616584 Dycon, John, of Keston, Hunts, husbandman 0
4707930 2267850 2267850 defendant Dycon John husbandman 616584 616584 Dycon, John, of Keston, Hunts, husbandman 0
4707931 2267850 2267850 defendant Lutton Thomas husbandman 616584 616584 Lutton, Thomas, of Keston, Hunts, husbandman 1
4932647 2336605 2336605 defendant Bernewell Robert   616584 616584 Bernewell, Robert, of Keston, Hunts 0
4983445 2351958 2351958 defendant Bullok John husbandman 616584 616584 Bullok, John, of Keston, Hunts, husbandman 0
5038718 2368227 2368227 defendant Okeham John husbandman 616584 616584 Okeham, John, of Keston, Hunts, husbandman 3
5038724 2368228 2368228 defendant Okeham John husbandman 616584 616584 Okeham, John, of Keston, Hunts, husbandman 3
5073704 2378621 2378621 defendant Bullok John husbandman 616584 616584 Bullok, John, of Keston, Hunts, husbandman 0
5073708 2378622 2378622 defendant Bullok John husbandman 616584 616584 Bullok, John, of Keston, Hunts, husbandman 0
5073712 2378623 2378623 defendant Durant Augustine gent 616584 616584 Durant, Augustine, of Keston, Hunts, gent 0
5073715 2378624 2378624 defendant Durant Augustine husbandman 616584 616584 Durant, Augustine, of Keston, Hunts, husbandman 0
5196995 2414865 2414865 defendant Andrewe Richard husbandman 616584 616584 Andrewe, Richard, of Keston, Hunts, husbandman 0
5209892 2418626 2418626 defendant Andrewe Richard husbandman 616584 616584 Andrewe, Richard, of Keston, Hunts, husbandman 0
5322103 2451682 2451682 defendant Medeflowre Henry shoemaker 616584 616584 Medeflowre, Henry, of Keston, Hunts, shoemaker 3
5358456 2462697 2462697 defendant Goore Thomas husbandman 616584 616584 Goore, Thomas, of Keston, Hunts, husbandman 0
5434869 2485361 2485361 defendant Gore Richard chaplain 616584 616584 Gore, Richard, of Keston, Hunts, chaplain 1
5439547 2486763 2486763 defendant Gore Thomas yeoman 616584 616584 Gore, Thomas, of Keston, Hunts, yeoman 0
5450118 2489923 2489923 defendant Gore Richard chaplain 616584 616584 Gore, Richard, of Keston, Hunts, chaplain 1
5453298 2490869 2490869 defendant Gore Thomas yeoman 616584 616584 Gore, Thomas, of Keston, Hunts, yeoman 0
5465244 2494510 2494510 defendant Gore Thomas yeoman 616584 616584 Gore, Thomas, of Keston, Hunts, yeoman 0
5496500 2503862 2503862 defendant Asteley Oliver tailor 616584 616584 Asteley, Oliver, of Keston, Hunts, tailor 0
5496502 2503863 2503863 defendant Gore Thomas farmer of Keston rectory 616584 616584 Gore, Thomas, of Keston, Hunts, husbandman, farmer of Keston rectory 0
5604622 2536306 2536306 defendant Bulkyn John yeoman 616584 616584 Bulkyn, John, of Keston, Hunts, 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);