names

42 rows where place_id = 780104

✎ 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
4666205 2250902 2250902 defendant Danners or Danvers Richard esq 780104 780104 Danners or Danvers, Richard, of Bannebury, Oxon, esq 1
4666211 2250903 2250903 defendant Danvers Richard esq 780104 780104 Danvers, Richard, of Bannebury, Oxon, esq 4
4680677 2259570 2259570 defendant Hurst William sheerman 780104 780104 Hurst, William, of Bannebury, Oxon, sheerman 0
4787995 2292312 2292312 defendant Blakenhale John dyer 780104 780104 Blakenhale, John, of Bannebury, Oxon, dyer 0
4793473 2294068 2294068 defendant Thorp Simon cutler 780104 780104 Thorp, Simon, of Bannebury, Oxon, chapman;Golde, John, of Gloucester, cutler 0
4805039 2297781 2297781 defendant Mason Thomas gent 780104 780104 Mason, Thomas, of Bannebury, Oxon, gent 0
4814991 2300798 2300798 defendant Chaundeler Thomas chaundeler 780104 780104 Chaundeler, Thomas, of Bannebury, Oxon, chaundeler 3
4824103 2303612 2303612 defendant Heryng alias Barbour Thomas barber or butcher 780104 780104 Heryng alias Barbour, Thomas, of Bannebury, Oxon, barber or butcher 2
4883795 2321839 2321839 defendant Barbour alias Bocher Thomas butcher 780104 780104 Barbour, alias Bocher Thomas, of Bannebury, Oxon, butcher 2
4897972 2326032 2326032 defendant Vaus John slater 780104 780104 Vaus, John, of Bannebury, Oxon, slater 0
4907642 2328956 2328956 defendant Smale John shoemaker 780104 780104 Smale, John, of Bannebury, Oxon, shoemaker 0
4917278 2331911 2331911 defendant Thurston alias Isowede John chapman 780104 780104 Thurston alias Isowede, John, of Bannebury, Oxon, chapman 0
4940831 2339159 2339159 defendant Haynes John carpenter 780104 780104 Haynes, John, of Bannebury, Oxon, carpenter 2
4963996 2346142 2346142 defendant Adyngton Nicholas draper 780104 780104 Adyngton, Nicholas, of Bannebury, Oxon, draper 0
4964007 2346147 2346147 defendant Norcote Lawrence tailor 780104 780104 Norcote, Lawrence, of Bannebury, Oxon, tailor 0
5021686 2363241 2363241 defendant Fairhell Thomas husbandman 780104 780104 Fairhell, Thomas, of Bannebury, Oxon, husbandman 0
5021688 2363242 2363242 defendant Fairhell Thomas husbandman 780104 780104 Fairhell, Thomas, of Bannebury, Oxon, husbandman 0
5040036 2368618 2368618 defendant Wynde John yeoman 780104 780104 Wynde, John, of Bannebury, Oxon, yeoman 0
5040039 2368619 2368619 defendant Wynde John yeoman 780104 780104 Wynde, John, of Bannebury, Oxon, yeoman 0
5041035 2368946 2368946 defendant Hawkes Richard draper 780104 780104 Hawkes, Richard, of Bannebury, Oxon, draper 0
5054999 2373058 2373058 defendant Offchirche William weaver 780104 780104 Offchirche, William, of Bannebury, Oxon, weaver 0
5056734 2373589 2373589 defendant Adyngdon Nicholas yeoman or draper 780104 780104 Adyngdon, Nicholas, of Bannebury, Oxon, yeoman or draper 0
5056736 2373590 2373590 defendant Adyngton Nicholas yeoman or draper 780104 780104 Adyngton, Nicholas, of Bannebury, Oxon, yeoman or draper 0
5065958 2376342 2376342 defendant Barbour Walter barber 780104 780104 Barbour, Walter, of Bannebury, Oxon, barber 0
5076683 2379525 2379525 defendant Kyrkeby Thomas yeoman 780104 780104 Kyrkeby, Thomas, of Bannebury, Oxon, yeoman 0
5078120 2379941 2379941 defendant of Churche John weaver 780104 780104 of Churche, John, of Bannebury, Oxon, or of Shenyngdon, Glos, weaver 0
5111307 2389697 2389697 defendant Saundres William woolman 780104 780104 Saundres, William, of Bannebury, Oxon, woolman 0
5131180 2395610 2395610 defendant Leyght John tailor 780104 780104 Leyght, John, of Bannebury, Oxon, tailor 0
5141301 2398579 2398579 defendant Saundres William woolman 780104 780104 Saundres, William, of Bannebury, Oxon, woolman 1
5216280 2420499 2420499 defendant Fyppes John, senior yeoman 780104 780104 Fyppes, John, senior, of Bannebury, Oxon, yeoman 0
5221155 2421889 2421889 defendant Grene Lawrence dyer 780104 780104 Grene, Lawrence, of Bannebury, Oxon, dyer 3
5221210 2421903 2421903 defendant Edon Henry chapman 780104 780104 Edon, Henry, of Bannebury, Oxon, chapman 1
5223521 2422569 2422569 defendant Asshewell alias Spycer Thomas spicer or chapman 780104 780104 Asshewell alias Spycer, Thomas, of Bannebury, Oxon, spicer or chapman 4
5231224 2424731 2424731 defendant Wynwyk William weaver 780104 780104 Wynwyk, William, of Bannebury, Oxon, weaver 0
5274042 2437485 2437485 defendant Jorge John mercer 780104 780104 Jorge, John, of Bannebury, Oxon, mercer 0
5382560 2470073 2470073 defendant Yardeley Richard   780104 780104 Yardeley, Richard, of Bannebury, Oxon, apprentice 1
5485930 2500683 2500683 defendant mainpernors for Maker Richard chapman 780104 780104 mainpernors for Maker, Richard, of Bannebury, Oxon, chapman 4
5532714 2514782 2514782 defendant Croke Nicholas yeoman 780104 780104 Croke, Nicholas, of Bannebury, Oxon, yeoman 0
5626437 2552240 2552240 defendant Temple John spicer 780104 780104 Temple, John, of Bannebury, Oxon, spicer 0
5626439 2552241 2552241 defendant Temple John spicer or husbandman 780104 780104 Temple, John, of Bannebury, Oxon, spicer or husbandman 0
5626441 2552242 2552242 defendant Temple John spicer or husbandman 780104 780104 Temple, John, of Bannebury, Oxon, spicer or husbandman 0
5630479 2553543 2553543 defendant Nicollys John draper 780104 780104 Nicollys, John, of Bannebury, Oxon, draper 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);