names

45 rows where place_id = 638421

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3842414 1971161 1971161 defendant Borton John husbandman 638421 638421 Borton, John, of Burstall, husbandman 0
4189138 2091693 2091693 defendant Nayler Robert yeoman 638421 638421 Nayler, Robert, of Burstall, yeoman 0
4219775 2102419 2102419 defendant Stubley Richard yeoman 638421 638421 Stubley, Richard, of Burstall, yeoman 0
4223794 2103807 2103807 defendant Matson Christopher shoemaker 638421 638421 Matson, Christopher, of Burstall, shoemaker 2
4235372 2107939 2107939 defendant Lyborne John husbandman 638421 638421 Lyborne, John, of Burstall, husbandman 0
4380526 2158148 2158148 defendant Crofte Thomas laborer 638421 638421 Crofte, Thomas, of Burstall, laborer 0
4462014 2188817 2188817 defendant Campe John   638421 638421 Campe, John, of Burstall 3
4462030 2188821 2188821 defendant Coupere John   638421 638421 Coupere, John, of Burstall 3
4466079 2190049 2190049 defendant Milner William   638421 638421 Milner, William, of Burstall 0
4508579 2203159 2203159 defendant Parmenter John   638421 638421 Parmenter, John, of Burstall 0
4587650 2227543 2227543 defendant Rote John   638421 638421 Rote, John, of Burstall 2
4601414 2231679 2231679 defendant Bedell Thomas   638421 638421 Bedell, Thomas, of Burstall 0
4601415 2231679 2231679 defendant Brewer William   638421 638421 Brewer, William, of Burstall 1
4631140 2240638 2240638 defendant Smyth John   638421 638421 Smyth, John, of Burstall 0
4634596 2241672 2241672 defendant Broun James   638421 638421 Broun, James, of Burstall 3
4660741 2249183 2249183 defendant Bunne Walter   638421 638421 Bunne, Walter, of Burstall, wright 1
4797652 2295445 2295445 defendant Sybeston John husbandman 638421 638421 Sybeston, John, of Burstall, husbandman 2
4815697 2301013 2301013 defendant Aleyn John, junior husbandman 638421 638421 Aleyn, John, junior, of Burstall, formerly of Cold Newton, husbandman 0
4815698 2301013 2301013 defendant Aleyn Thomas husbandman 638421 638421 Aleyn, Thomas, of Burstall, formerly of Cold Newton, husbandman 1
4886628 2322682 2322682 defendant Wode John yeoman 638421 638421 Wode, John, of Burstall, yeoman 1
4922127 2333332 2333332 defendant Boton John husbandman 638421 638421 Boton, John, of Burstall, husbandman 1
4922128 2333332 2333332 defendant Rydell John husbandman 638421 638421 Rydell, John, of Burstall, husbandman 2
4922129 2333332 2333332 defendant Nores Robert husbandman 638421 638421 Nores, Robert, of Burstall, husbandman 3
4963018 2345848 2345848 defendant Bugden William chaplain 638421 638421 Bugden, William, of Burstall, chaplain 0
4965047 2346466 2346466 defendant Fuller Nicholas husbandman 638421 638421 Fuller, Nicholas, of Burstall, husbandman 1
4980694 2351162 2351162 defendant Oode or Code John yeoman 638421 638421 Oode or Code, John, of Burstall, yeoman 0
4989267 2353722 2353722 defendant Taillour John husbandman 638421 638421 Taillour, John, of Burstall, husbandman 3
4989268 2353722 2353722 defendant Bayth Ralph husbandman 638421 638421 Bayth, Ralph, of Burstall, husbandman 4
4989997 2353919 2353919 defendant Hanson or Hauson Robert husbandman 638421 638421 Hanson or Hauson, Robert, of Burstall, husbandman 0
4989998 2353919 2353919 defendant Subston John husbandman 638421 638421 Subston, John, of Burstall, husbandman 1
5009242 2359587 2359587 defendant Aleyn Thomas husbandman 638421 638421 Aleyn, Thomas, of Burstall, husbandman 1
5023753 2363852 2363852 defendant Ody John yeoman 638421 638421 Ody, John, of Burstall, yeoman 0
5066161 2376403 2376403 defendant Ody John husbandman 638421 638421 Ody, John, of Burstall, husbandman 2
5104280 2387671 2387671 defendant Gyffard Walter yeoman 638421 638421 Gyffard, Walter, of Burstall, yeoman 7
5236302 2426206 2426206 defendant Ody John carpenter 638421 638421 Ody, John, of Burstall, carpenter 0
5238043 2426717 2426717 defendant Spere Thomas husbandman 638421 638421 Spere, Thomas, of Burstall, husbandman 0
5238044 2426717 2426717 defendant Spere John husbandman 638421 638421 Spere, John, of Burstall, husbandman 1
5269252 2436111 2436111 defendant Codyngton William chaplain 638421 638421 Codyngton, William, of Burstall, chaplain 8
5304966 2446489 2446489 defendant _dy John carpenter 638421 638421 _dy, John, of Burstall, carpenter 2
5320619 2451259 2451259 defendant Ody John carpenter 638421 638421 Ody, John, of Burstall, carpenter 2
5345154 2458649 2458649 defendant Ody John yeoman 638421 638421 Ody, John, of Burstall, yeoman 0
5403777 2476155 2476155 defendant Scott Nicholas yeoman 638421 638421 Scott, Nicholas, of Burstall, yeoman 1
5416999 2479995 2479995 defendant Scott Nicholas yeoman 638421 638421 Scott, Nicholas, of Burstall, yeoman 0
5434014 2485126 2485126 defendant Scott Nicholas yeoman 638421 638421 Scott, Nicholas, of Burstall, yeoman 0
5580845 2529086 2529086 defendant Bunne John husbandman 638421 638421 Bunne, John, of Burstall, 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);