names

49 rows where place_id = 766214

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4497770 2199948 2199948 plaintiff Elvered John   766214 766214 Elvered, John, of Oxeburgh, parson 0
4525856 2208382 2208382 defendant Ode Thomas   766214 766214 Ode, Thomas, of Oxeburgh 0
4530467 2209824 2209824 plaintiff Ode Thomas   766214 766214 Ode, Thomas, of Oxeburgh 0
4545656 2214566 2214566 defendant Redberd Edmund   766214 766214 Redberd, Edmund, of Oxeburgh 1
4560820 2219342 2219342 defendant Redberd Edmund   766214 766214 Redberd, Edmund, of Oxeburgh 0
4560826 2219342 2219342 defendant Kyng John   766214 766214 Kyng, John, of Oxeburgh 6
4576852 2224264 2224264 defendant Blaunch Lawrence   766214 766214 Blaunch, Lawrence, of Oxeburgh 0
4580802 2225478 2225478 defendant Redberd Edmund   766214 766214 Redberd, Edmund, of Oxeburgh 0
4581631 2225704 2225704 defendant Spylman Edmund   766214 766214 Spylman, Edmund, of Oxeburgh 0
4581633 2225704 2225704 defendant Talliot Lawrence   766214 766214 Talliot, Lawrence, of Oxeburgh 2
4583829 2226358 2226358 defendant Spilman Edmund   766214 766214 Spilman, Edmund, of Oxeburgh 2
4585972 2227037 2227037 plaintiff Hawe John   766214 766214 Hawe, John, of Oxeburgh 0
4596828 2230243 2230243 plaintiff Samme John   766214 766214 Samme, John, of Oxeburgh 0
4610073 2234237 2234237 defendant Haghwe John   766214 766214 Haghwe, John, of Oxeburgh 0
4610075 2234237 2234237 defendant Ode William   766214 766214 Ode, William, of Oxeburgh 2
4621574 2237735 2237735 defendant Ode Thomas   766214 766214 Ode, Thomas, of Oxeburgh 0
4695088 2263957 2263957 defendant Sellyng John yeoman 766214 766214 Sellyng, John, of Oxeburgh, yeoman 1
4695089 2263957 2263957 defendant Pye Thomas chaplain 766214 766214 Pye, Thomas, of Oxeburgh, chaplain 2
4708577 2268054 2268054 defendant Hawe John husbandman 766214 766214 Hawe, John, of Oxeburgh, husbandman 0
4720938 2271880 2271880 defendant Reed Richard gent 766214 766214 Reed, Richard, of Oxeburgh, gent 3
4725106 2273149 2273149 defendant Ode Thomas husbandman 766214 766214 Ode, Thomas, of Oxeburgh, husbandman 0
4733529 2275662 2275662 defendant Ode Thomas husbandman 766214 766214 Ode, Thomas, of Oxeburgh, husbandman 1
4733532 2275663 2275663 defendant Chene William   766214 766214 Chene, William, of Oxeburgh 1
4738653 2277178 2277178 plaintiff Whytemete William   766214 766214 Whytemete, William, of Oxeburgh, parson 0
4738654 2277178 2277178 defendant Hawe John husbandman 766214 766214 Hawe, John, of Oxeburgh, husbandman 0
4738655 2277178 2277178 defendant Warde William laborer 766214 766214 Warde, William, of Oxeburgh, laborer 1
4749021 2280197 2280197 defendant Helde Richard yeoman 766214 766214 Helde, Richard, of Oxeburgh, yeoman 3
4750152 2280517 2280517 defendant Hawe John yeoman 766214 766214 Hawe, John, of Oxeburgh, yeoman 0
4750154 2280518 2280518 defendant Hawe John yeoman 766214 766214 Hawe, John, of Oxeburgh, yeoman 0
4751983 2281074 2281074 defendant Hawe John yeoman 766214 766214 Hawe, John, of Oxeburgh, yeoman 0
4751990 2281077 2281077 defendant Hawe John yeoman 766214 766214 Hawe, John, of Oxeburgh, yeoman 0
4752117 2281101 2281101 defendant Talbot Roger yeoman 766214 766214 Talbot, Roger, of Oxeburgh, yeoman 1
4752118 2281101 2281101 defendant Cheene William yeoman 766214 766214 Cheene, William, of Oxeburgh, yeoman 2
4760720 2283694 2283694 defendant Ode Thomas husbandman 766214 766214 Ode, Thomas, of Oxeburgh, husbandman 3
4760726 2283695 2283695 defendant Ode Thomas husbandman 766214 766214 Ode, Thomas, of Oxeburgh, husbandman 3
4770054 2286606 2286606 defendant Lane William clerk 766214 766214 Lane, William, of Oxeburgh, clerk 0
4779928 2289721 2289721 defendant Ode Thomas yeoman 766214 766214 Ode, Thomas, of Oxeburgh, yeoman 0
4794701 2294481 2294481 defendant Lane William clerk 766214 766214 Lane, William, of Oxeburgh, clerk 0
4835791 2307189 2307189 defendant Fraunceys William yeoman 766214 766214 Fraunceys, William, of Oxeburgh, yeoman 0
4889719 2323580 2323580 defendant Reed Richard gent 766214 766214 Reed, Richard, of Oxeburgh, gent 0
4900845 2326895 2326895 defendant Fraunceys William yeoman 766214 766214 Fraunceys, William, of Oxeburgh, yeoman 0
4909602 2329539 2329539 defendant Stradesete Roger husbandman 766214 766214 Stradesete, Roger, of Oxeburgh, husbandman 0
4914614 2331089 2331089 defendant Saweser John yeoman 766214 766214 Saweser, John, of Oxeburgh, yeoman 1
4914618 2331090 2331090 defendant Setweser John yeoman 766214 766214 Setweser, John, of Oxeburgh, yeoman 1
4926700 2334770 2334770 plaintiff Reed Richard (legal representative) 766214 766214 Reed, Richard, of Oxeburgh, executrix of 0
4957099 2344079 2344079 defendant Reed Richard (legal representative) 766214 766214 Reed, Richard, of Oxeburgh, executors of 0
5219337 2421380 2421380 defendant Hewer John butcher 766214 766214 Hewer, John, of Oxeburgh, butcher 0
5219339 2421381 2421381 defendant Hewer John butcher 766214 766214 Hewer, John, of Oxeburgh, butcher 0
5625120 2551793 2551793 defendant Bocher Robert butcher 766214 766214 Bocher, Robert, of Oxeburgh, butcher 2

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);