names

49 rows where place_id = 586174

✎ 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
3588081 1863921 1863921 defendant Hervy Elizabeth widow 586174 586174 Hervy, Elizabeth, of Watton atte Stone, widow 3
3588082 1863921 1863921 defendant Bordell Richard butcher 586174 586174 Bordell, Richard, of Watton atte Stone, butcher 4
3610581 1870974 1870974 defendant Burton William husbandman 586174 586174 Burton, William, of Watton atte Stone, husbandman 0
3610582 1870974 1870974 defendant Burton Henry husbandman 586174 586174 Burton, Henry, of Watton atte Stone, husbandman 1
3610798 1871042 1871042 defendant Bordell William   586174 586174 Bordell, William, of Watton atte Stone, ash burner 0
3610800 1871043 1871043 defendant Stytyll Richard husbandman 586174 586174 Stytyll, Richard, of Watton atte Stone, husbandman 0
3617814 1873197 1873197 defendant Coll John   586174 586174 Coll, John, of Watton atte Stone, holy water clerk 0
4436694 2176216 2176216 plaintiff Stodeye Robert de   586174 586174 Stodeye, Robert de, of Watton atte Stone, parson 0
4436696 2176217 2176217 plaintiff Stodeye Robert de   586174 586174 Stodeye, Robert de, of Watton atte Stone, parson 0
4448016 2184302 2184302 plaintiff Ferour William   586174 586174 Ferour, William, of Watton atte Stone 0
4456427 2187032 2187032 plaintiff Northwode Sampson   586174 586174 Northwode, Sampson, of Watton atte Stone 0
4486564 2196509 2196509 defendant Heynone Simon   586174 586174 Heynone, Simon, of Watton atte Stone 1
4529465 2209495 2209495 defendant Heyghnon John   586174 586174 Heyghnon, John, of Watton atte Stone 2
4564362 2220423 2220423 plaintiff Sandon William (legal representative) 586174 586174 Sandon, William, of Watton atte Stone, executors of 0
4564364 2220423 2220423 plaintiff Disseford John   586174 586174 Disseford, John, of Watton atte Stone 2
4564368 2220424 2220424 plaintiff Sandon William (legal representative) 586174 586174 Sandon, William, of Watton atte Stone, executors of 0
4564370 2220424 2220424 plaintiff Disseford John   586174 586174 Disseford, John, of Watton atte Stone, parson 2
4627104 2239429 2239429 defendant Heynon Simon   586174 586174 Heynon, Simon, of Watton atte Stone 0
4677689 2258638 2258638 defendant Burgeys Thomas fuller 586174 586174 Burgeys, Thomas, of Watton atte Stone, fuller 2
4710291 2268574 2268574 plaintiff Chaundeler Richard   586174 586174 Chaundeler, Richard, of Watton atte Stone, parson 2
4710671 2268696 2268696 defendant Heynon Simon husbandman 586174 586174 Heynon, Simon, of Watton atte Stone, husbandman 0
4803952 2297417 2297417 defendant Ailberne William maltman 586174 586174 Ailberne, William, of Watton atte Stone, maltman 1
4884514 2322061 2322061 plaintiff Hogge William   586174 586174 Hogge, William, of Watton atte Stone 0
4908546 2329230 2329230 defendant Clerk John   586174 586174 Clerk, John, of Watton atte Stone, brass worker 0
4908549 2329231 2329231 defendant Clerke John   586174 586174 Clerke, John, of Watton atte Stone, brass worker 0
5074225 2378778 2378778 defendant Frensheman William   586174 586174 Frensheman, William, of Watton atte Stone, servant 0
5087816 2382817 2382817 defendant Wrottyng Geoffrey husbandman 586174 586174 Wrottyng, Geoffrey, of Watton atte Stone, husbandman 2
5087818 2382817 2382817 defendant Carpenter William carpenter 586174 586174 Carpenter, William, of Watton atte Stone, carpenter 4
5101001 2386704 2386704 defendant Fesaunt John butcher 586174 586174 Fesaunt, John, of Watton atte Stone, butcher 1
5151660 2401642 2401642 defendant Malter William butcher 586174 586174 Malter, William, of Watton Atte Stone, butcher 0
5187885 2412168 2412168 defendant Walter William butcher 586174 586174 Walter, William, of Watton atte Stone, butcher 0
5187887 2412168 2412168 defendant Laurens William butcher 586174 586174 Laurens, William, of Watton atte Stone, butcher 2
5187889 2412168 2412168 defendant Seell Edmund butcher 586174 586174 Seell, Edmund, of Watton atte Stone, butcher 4
5195056 2414302 2414302 defendant Cherchesey Thomas husbandman alias miller 586174 586174 Cherchesey, Thomas, of Watton atte Stone, husbandman alias miller 1
5195063 2414305 2414305 defendant Cherchesey Thomas husbandman alias miller 586174 586174 Cherchesey, Thomas, of Watton atte Stone, husbandman alias miller 1
5209077 2418387 2418387 defendant Cherchesey Thomas husbandman alias miller 586174 586174 Cherchesey, Thomas, of Watton atte Stone, husbandman alias miller 1
5212241 2419319 2419319 defendant Grene Robert husbandman 586174 586174 Grene, Robert, of Watton atte Stone, husbandman 2
5212242 2419319 2419319 defendant Tussull Ellen widow 586174 586174 Tussull, Ellen, of Watton atte Stone, widow 3
5227002 2423550 2423550 defendant Abell Nicholas husbandman 586174 586174 Abell, Nicholas, of Watton atte Stone, husbandman 0
5349787 2460072 2460072 plaintiff Boteler John   586174 586174 Boteler, John, of Watton atte Stone 3
5349796 2460073 2460073 plaintiff Botiller John   586174 586174 Botiller, John, of Watton atte Stone 3
5364772 2464647 2464647 defendant Bukke Henry husbandman 586174 586174 Bukke, Henry, of Watton atte Stone, husbandman 1
5409870 2477920 2477920 defendant Bordell Richard   586174 586174 Bordell, Richard, of Watton atte Stone 0
5454865 2491374 2491374 defendant Bordell Richard yeoman 586174 586174 Bordell, Richard, of Watton atte Stone, yeoman 0
5462604 2493727 2493727 defendant Bordell Richard yeoman 586174 586174 Bordell, Richard, of Watton atte Stone, yeoman 0
5462609 2493728 2493728 defendant Bordell Richard yeoman 586174 586174 Bordell, Richard, of Watton atte Stone, yeoman 0
5483068 2499878 2499878 defendant Bordell Richard yeoman 586174 586174 Bordell, Richard, of Watton atte Stone, yeoman 0
5526980 2513006 2513006 plaintiff Bardolf Edmund gent 586174 586174 Bardolf, Edmund, of Watton atte Stone, gent 1
5560673 2523088 2523088 defendant Offa John yeoman 586174 586174 Offa, John, of Watton atte Stone, 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);