names

25 rows where place_id = 594915

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618116 1873289 1873289 defendant Micche Joan widow 594915 594915 Micche, Joan, of Bukden, widow 1
4713174 2269447 2269447 defendant Daud John yeoman 594915 594915 Daud, John, of Bukden, yeoman 1
4728955 2274293 2274293 defendant Pulter John husbandman 594915 594915 Pulter, John, of Bukden, husbandman 1
4884444 2322036 2322036 defendant Wright John   594915 594915 Wright, John, of Bukden, wright 0
4899278 2326416 2326416 defendant Britte Henry husbandman 594915 594915 Britte, Henry, of Bukden, husbandman 0
4906093 2328501 2328501 defendant Astell alias Wryghte John carpenter 594915 594915 Astell alias Wryghte, John, of Bukden, carpenter 0
4906094 2328501 2328501 defendant Walton William carpenter 594915 594915 Walton, William, of Bukden, carpenter 1
4906095 2328501 2328501 defendant Oborgh John husbandman 594915 594915 Oborgh, John, of Bukden, husbandman 2
4931634 2336282 2336282 defendant Donkeley William husbandman 594915 594915 Donkeley, William, of Bukden, husbandman 0
4938371 2338380 2338380 defendant Ferrour or Smith William husbandman 594915 594915 Ferrour or Smith, William, of Bukden, husbandman 1
4957106 2344081 2344081 defendant Byrt Henry husbandman 594915 594915 Byrt, Henry, of Bukden, husbandman 0
4975944 2349767 2349767 defendant Wryght John husbandman 594915 594915 Wryght, John, of Bukden, husbandman 2
4983587 2352010 2352010 defendant Byrt Henry husbandman 594915 594915 Byrt, Henry, of Bukden, husbandman 0
4983589 2352011 2352011 defendant Byrt Henry husbandman 594915 594915 Byrt, Henry, of Bukden, husbandman 0
5093811 2384590 2384590 defendant Ferrour or Smith John husbandman 594915 594915 Ferrour or Smith, John, of Bukden, husbandman 2
5118064 2391713 2391713 defendant Fuller Robert fishmonger 594915 594915 Fuller, Robert, of Bukden, fishmonger 0
5264194 2434561 2434561 defendant Fuller Robert fishmonger 594915 594915 Fuller, Robert, of Bukden, fishmonger 0
5294172 2443269 2443269 defendant Daud or Dand John, junior husbandman 594915 594915 Daud or Dand, John, junior, of Bukden, husbandman 3
5294173 2443269 2443269 defendant Felde John goldsmith 594915 594915 Felde, John, of Bukden, goldsmith 4
5294174 2443269 2443269 defendant Clement William husbandman 594915 594915 Clement, William, of Bukden, husbandman 5
5294175 2443269 2443269 defendant Fuller John husbandman 594915 594915 Fuller, John, of Bukden, husbandman 6
5294176 2443269 2443269 defendant Hamond John husbandman 594915 594915 Hamond, John, of Bukden, husbandman 7
5294177 2443269 2443269 defendant Bundy John, junior husbandman 594915 594915 Bundy, John, junior, of Bukden, husbandman 8
5302890 2445851 2445851 defendant Bentam Henry chapman 594915 594915 Bentam, Henry, of Bukden, chapman 0
5332566 2454807 2454807 defendant Fuller John husbandman 594915 594915 Fuller, John, of Bukden, 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);