names

49 rows where place_id = 754654

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4421870 2171717 2171717 defendant Fraunkes Alan   754654 754654 Fraunkes, Alan, of Askeby 0
4432407 2174914 2174914 plaintiff Croftes William in the   754654 754654 Croftes, William in the, of Askeby, junior 0
4439594 2181649 2181649 plaintiff Bande Edmund   754654 754654 Bande, Edmund, of Askeby 0
4439595 2181649 2181649 defendant Gayton or Dayton John   754654 754654 Gayton or Dayton, John, of Askeby 0
4441252 2182196 2182196 plaintiff Bolle Robert   754654 754654 Bolle, Robert, of Askeby 0
4464437 2189547 2189547 plaintiff Meburn Stephen   754654 754654 Meburn, Stephen, of Askeby, parson 5
4525523 2208311 2208311 defendant Nene John   754654 754654 Nene, John, of Askeby 0
4535907 2211502 2211502 defendant Laund Edmund de   754654 754654 Laund, Edmund de, of Askeby 0
4535908 2211502 2211502 defendant Ward John   754654 754654 Ward, John, of Askeby 1
4546056 2214707 2214707 plaintiff Bracebrigg John   754654 754654 Bracebrigg, John, of Askeby 0
4613238 2235179 2235179 defendant Scotte Richard   754654 754654 Scotte, Richard, of Askeby 5
4613239 2235179 2235179 defendant Atkynson John   754654 754654 Atkynson, John, of Askeby 6
4613240 2235179 2235179 defendant Shephird Thomas   754654 754654 Shephird, Thomas, of Askeby 7
4613245 2235179 2235179 defendant Bone William   754654 754654 Bone, William, of Askeby 12
4613246 2235179 2235179 defendant Clibburnman John   754654 754654 Clibburnman, John, of Askeby 13
4613248 2235179 2235179 defendant Wilson John   754654 754654 Wilson, John, of Askeby 15
4628550 2239853 2239853 defendant Hoggesson Thomas   754654 754654 Hoggesson, Thomas, of Askeby 0
4644902 2244576 2244576 plaintiff Menburn Stephen   754654 754654 Menburn, Stephen, of Askeby, parson of the church 0
4659948 2248962 2248962 defendant Unthank Thomas yeoman 754654 754654 Unthank, Thomas, of Askeby, yeoman 0
4660392 2249076 2249076 defendant Hogeson Thomas husbandman 754654 754654 Hogeson, Thomas, of Askeby, husbandman 0
4660394 2249076 2249076 defendant Mayle John yeoman 754654 754654 Mayle, John, of Askeby, yeoman 2
4674045 2257493 2257493 defendant Wilson Tomson Thomas yeoman 754654 754654 Wilson Tomson, Thomas, of Askeby, yeoman 1
4692288 2263104 2263104 plaintiff Askeby alias Meburne Stephen   754654 754654 Askeby alias Meburne, Stephen, of Askeby, parson 0
4709291 2268276 2268276 defendant Mayon William clerk 754654 754654 Mayon, William, of Askeby, clerk 0
4720563 2271766 2271766 defendant Caly John yeoman 754654 754654 Caly, John, of Askeby, yeoman 1
4723893 2272773 2272773 defendant Maddour John   754654 754654 Maddour, John, of Askeby, wright 8
4730901 2274862 2274862 plaintiff Menburn Stephen de   754654 754654 Menburn, Stephen de, of Askeby, parson 0
4731190 2274956 2274956 plaintiff Monburne Stephen de   754654 754654 Monburne, Stephen de, of Askeby, parson 0
4732364 2275300 2275300 defendant Elys Richard   754654 754654 Elys, Richard, of Askeby, parson 0
4732365 2275300 2275300 defendant Estgate William   754654 754654 Estgate, William, of Askeby, shepherd 1
4881391 2321078 2321078 defendant the Person of Askeby Walter clerk 754654 754654 the Person of Askeby, Walter, of Askeby, clerk 0
4888330 2323154 2323154 defendant Dykson Adam yeoman 754654 754654 Dykson, Adam, of Askeby, yeoman 0
4888331 2323154 2323154 defendant Dykson Robert Atkynson yeoman 754654 754654 Dykson, Robert Atkynson, of Askeby, yeoman 1
4888332 2323154 2323154 defendant Scotte Adam yeoman 754654 754654 Scotte, Adam, of Askeby, yeoman 2
4888333 2323154 2323154 defendant Scotte Richard yeoman 754654 754654 Scotte, Richard, of Askeby, yeoman 3
4945967 2340726 2340726 defendant Cotson Richard yeoman 754654 754654 Cotson, Richard, of Askeby, yeoman 0
4964790 2346379 2346379 defendant Johnson Simon yeoman 754654 754654 Johnson, Simon, of Askeby, yeoman 1
4986958 2353041 2353041 defendant Hyesson William husbandman 754654 754654 Hyesson, William, of Askeby, husbandman 1
5001965 2357475 2357475 defendant Cawdrey Richard husbandman 754654 754654 Cawdrey, Richard, of Askeby, husbandman 3
5001966 2357475 2357475 defendant Tupholme Alan husbandman 754654 754654 Tupholme, Alan, of Askeby, husbandman 4
5004862 2358321 2358321 plaintiff Ratforf Thomas esq 754654 754654 Ratforf, Thomas, of Askeby, esq 0
5160563 2404181 2404181 defendant Godard Thomas laborer 754654 754654 Godard, Thomas, of Askeby, laborer 0
5196456 2414715 2414715 defendant Edward Thomas laborer 754654 754654 Edward, Thomas, of Askeby, laborer 0
5209663 2418565 2418565 defendant Godard Thomas laborer 754654 754654 Godard, Thomas, of Askeby, laborer 0
5567109 2524963 2524963 defendant Bukmonger Adam husbandman 754654 754654 Bukmonger, Adam, of Askeby, husbandman 0
5567110 2524963 2524963 defendant Bukmonger Peter husbandman 754654 754654 Bukmonger, Peter, of Askeby, husbandman 1
5610790 2547097 2547097 plaintiff Baunebury John de   754654 754654 Baunebury, John de, of Askeby, formerly parson, in the diocese of Lincoln 0
5628038 2552741 2552741 defendant Mayon William clerk 754654 754654 Mayon, William, of Askeby, clerk 0
5628039 2552741 2552741 defendant Grene Adam husbandman 754654 754654 Grene, Adam, of Askeby, husbandman 1

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