names

65 rows where place_id = 598794

✎ 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
3634095 1905460 1905460 defendant Aburgh Peter laborer 598794 598794 Aburgh, Peter, of Mayden Bradley, laborer 6
3634096 1905460 1905460 defendant A Mill William yeoman 598794 598794 A Mill, William, of Mayden Bradley, yeoman 7
3634097 1905460 1905460 defendant Stourton William yeoman 598794 598794 Stourton, William, of Mayden Bradley, yeoman 8
3634098 1905460 1905460 defendant Fawekener Nicholas yeoman 598794 598794 Fawekener, Nicholas, of Mayden Bradley, yeoman 9
3647576 1909633 1909633 defendant A Burgh Peter laborer 598794 598794 A Burgh, Peter, of Mayden Bradley, laborer 6
3647577 1909633 1909633 defendant A Myll William yeoman 598794 598794 A Myll, William, of Mayden Bradley, yeoman 7
3647578 1909633 1909633 defendant Sturton William yeoman 598794 598794 Sturton, William, of Mayden Bradley, yeoman 8
3647579 1909633 1909633 defendant Fawkener Nicholas yeoman 598794 598794 Fawkener, Nicholas, of Mayden Bradley, yeoman 9
3647587 1909634 1909634 defendant A Burgh Peter laborer 598794 598794 A Burgh, Peter, of Mayden Bradley, laborer 6
3647588 1909634 1909634 defendant A Myll William yeoman 598794 598794 A Myll, William, of Mayden Bradley, yeoman 7
3647589 1909634 1909634 defendant Bolde William yeoman 598794 598794 Bolde, William, of Mayden Bradley, yeoman 8
3647590 1909634 1909634 defendant Fawkener Nicholas yeoman 598794 598794 Fawkener, Nicholas, of Mayden Bradley, yeoman 9
3647895 1909737 1909737 defendant Chapman John yeoman 598794 598794 Chapman, John, of Mayden Bradley, yeoman 0
3651050 1910694 1910694 defendant Jenyn Thomas yeoman 598794 598794 Jenyn, Thomas, of Mayden Bradley, yeoman 1
3651051 1910694 1910694 defendant Jenyn John yeoman 598794 598794 Jenyn, John, of Mayden Bradley, yeoman 2
3720700 1932766 1932766 defendant Niprede John husbandman 598794 598794 Niprede, John, of Mayden Bradley, husbandman 0
3735582 1937363 1937363 defendant Danyell Alexander husbandman 598794 598794 Danyell, Alexander, of Mayden Bradley, husbandman 0
3735583 1937363 1937363 defendant Stourton William yeoman 598794 598794 Stourton, William, of Mayden Bradley, yeoman 1
3735584 1937363 1937363 defendant Lammas William yeoman 598794 598794 Lammas, William, of Mayden Bradley, yeoman 2
3735585 1937363 1937363 defendant Demned John yeoman 598794 598794 Demned, John, of Mayden Bradley, yeoman 3
3746078 1940678 1940678 defendant Rider John butcher 598794 598794 Rider, John, of Mayden Bradley, butcher 0
3749892 1941881 1941881 defendant Mompesson Richard gent 598794 598794 Mompesson, Richard, of Mayden Bradley, gent 1
3749895 1941882 1941882 defendant Mompesson Richard gent 598794 598794 Mompesson, Richard, of Mayden Bradley, gent 1
3750145 1941960 1941960 plaintiff Lambard Christopher   598794 598794 Lambard, Christopher, of Mayden Bradley 0
3750146 1941960 1941960 defendant Bugden John fuller 598794 598794 Bugden, John, of Mayden Bradley, fuller 0
3756120 1943871 1943871 defendant Sacheverell John clerk 598794 598794 Sacheverell, John, of Mayden Bradley, clerk 1
3756124 1943872 1943872 defendant Sacheverell John clerk 598794 598794 Sacheverell, John, of Mayden Bradley, clerk 1
3765450 1946859 1946859 plaintiff Lambard Christopher   598794 598794 Lambard, Christopher, of Mayden Bradley 0
3765451 1946859 1946859 defendant Bugden John fuller 598794 598794 Bugden, John, of Mayden Bradley, fuller 0
3765481 1946868 1946868 defendant Bugden John tucker 598794 598794 Bugden, John, of Mayden Bradley, tucker 0
3981519 2018150 2018150 defendant Baylye Richard butcher 598794 598794 Baylye, Richard, of Mayden Bradley, butcher 1
3981520 2018150 2018150 defendant Androwes John laborer 598794 598794 Androwes, John, of Mayden Bradley, laborer 2
4060969 2046331 2046331 defendant Chamyn William butcher 598794 598794 Chamyn, William, of Mayden Bradley, butcher 0
4060971 2046331 2046331 defendant Humfrey John timberman 598794 598794 Humfrey, John, of Mayden Bradley, timberman 2
4070068 2049585 2049585 defendant Baylye John husbandman 598794 598794 Baylye, John, of Mayden Bradley, husbandman 1
4070069 2049585 2049585 defendant Bungey John yeoman 598794 598794 Bungey, John, of Mayden Bradley, yeoman 2
4278327 2122359 2122359 defendant Marvyn Andrew chapman 598794 598794 Marvyn, Andrew, of Mayden Bradley, chapman 0
4786316 2291764 2291764 defendant Short John weaver 598794 598794 Short, John, of Mayden Bradley, weaver 1
4789490 2292780 2292780 defendant Frensshe Walter chapman 598794 598794 Frensshe, Walter, of Mayden Bradley, chapman 0
4794315 2294363 2294363 defendant Copper John carpenter 598794 598794 Copper, John, of Mayden Bradley, carpenter 0
4807365 2298500 2298500 defendant Granger John tanner 598794 598794 Granger, John, of Mayden Bradley, tanner 1
4977302 2350169 2350169 defendant Shepherd Thomas butcher 598794 598794 Shepherd, Thomas, of Mayden Bradley, butcher 0
5063321 2375563 2375563 defendant Broun John   598794 598794 Broun, John, of Mayden Bradley 0
5077251 2379699 2379699 defendant Bony or Bovy Nicholas husbandman 598794 598794 Bony or Bovy, Nicholas, of Mayden Bradley, husbandman 0
5092863 2384294 2384294 defendant Reve Walter yeoman 598794 598794 Reve, Walter, of Mayden Bradley, yeoman 2
5131482 2395692 2395692 defendant Bony of Bovy Nicholas butcher 598794 598794 Bony of Bovy, Nicholas, of Mayden Bradley, butcher 2
5212621 2419440 2419440 defendant Garyet Thomas yeoman 598794 598794 Garyet, Thomas, of Mayden Bradley, yeoman 0
5216903 2420685 2420685 defendant Chapman Richard butcher 598794 598794 Chapman, Richard, of Mayden Bradley, butcher 0
5246209 2429051 2429051 defendant Harres William husbandman 598794 598794 Harres, William, of Mayden Bradley, husbandman 2
5249421 2429943 2429943 defendant Bony Nicholas butcher 598794 598794 Bony, Nicholas, of Mayden Bradley, butcher 1
5398368 2474597 2474597 defendant Phelyppys John mercer 598794 598794 Phelyppys, John, of Mayden Bradley, mercer 1
5420104 2480930 2480930 defendant Pheliyppys John mercer 598794 598794 Pheliyppys, John, of Mayden Bradley, mercer 0
5425142 2482483 2482483 defendant (not given) William prior of Westbury 598794 598794 Westbury, William, of Mayden Bradley, prior of the house of priory of the BM 0
5491735 2502425 2502425 defendant Holway John husbandman 598794 598794 Holway, John, of Mayden Bradley, husbandman 0
5498607 2504526 2504526 defendant Holwey John husbandman 598794 598794 Holwey, John, of Mayden Bradley, husbandman 0
5521189 2511444 2511444 plaintiff Chapman Richard   598794 598794 Chapman, Richard, of Mayden Bradley 0
5521194 2511445 2511445 plaintiff Chapman Richard   598794 598794 Chapman, Richard, of Mayden Bradley 0
5527114 2513053 2513053 defendant Howell William laborer 598794 598794 Howell, William, of Mayden Bradley, laborer 0
5527115 2513053 2513053 defendant Bede Thomas laborer 598794 598794 Bede, Thomas, of Mayden Bradley, laborer 1
5527116 2513053 2513053 defendant Gelde Thomas laborer 598794 598794 Gelde, Thomas, of Mayden Bradley, laborer 2
5527117 2513053 2513053 defendant Sexe Thomas laborer 598794 598794 Sexe, Thomas, of Mayden Bradley, laborer 3
5527118 2513053 2513053 defendant Andrewe Thomas laborer 598794 598794 Andrewe, Thomas, of Mayden Bradley, laborer 4
5565925 2524637 2524637 plaintiff Chapman Richard (legal representative) 598794 598794 Chapman, Richard, of Mayden Bradley, butcher, executor of 0
5585629 2530575 2530575 defendant Porter William butcher 598794 598794 Porter, William, of Mayden Bradley, butcher 0
5601940 2535501 2535501 defendant Jenyns Thomas yeoman 598794 598794 Jenyns, Thomas, of Mayden Bradley, yeoman 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);