names

60 rows where place_id = 593808

✎ 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
3613411 1871842 1871842 defendant Cady William husbandman 593808 593808 Cady, William, of Akenham, husbandman 0
3678649 1919384 1919384 defendant Downyng John laborer 593808 593808 Downyng, John, of Akenham, laborer 0
3731146 1935966 1935966 defendant Newman William husbandman 593808 593808 Newman, William, of Akenham, husbandman 0
3754682 1943424 1943424 defendant Shymmyng Robert husbandman 593808 593808 Shymmyng, Robert, of Akenham, husbandman 0
3760379 1945250 1945250 defendant Rose William laborer 593808 593808 Rose, William, of Akenham, laborer 3
3787280 1953814 1953814 defendant Rose William, junior husbandman 593808 593808 Rose, William, junior, of Akenham, husbandman 0
3792583 1955538 1955538 defendant Kese John   593808 593808 Kese, John, of Akenham, brick maker 0
3792584 1955538 1955538 defendant Toly John husbandman 593808 593808 Toly, John, of Akenham, husbandman 1
3893918 1988189 1988189 defendant Stedde William husbandman 593808 593808 Stedde, William, of Akenham, husbandman 0
4003706 2026092 2026092 plaintiff Huggen Richard husbandman 593808 593808 Huggen, Richard, of Akenham, husbandman 0
4214371 2100533 2100533 defendant Withepoll Peter gent 593808 593808 Withepoll, Peter, of Akenham, gent 0
4276641 2121764 2121764 defendant Gosse William husbandman 593808 593808 Gosse, William, of Akenham, husbandman 1
4305441 2132045 2132045 defendant Withipoll Peter esq 593808 593808 Withipoll, Peter, of Akenham, esq 0
4343006 2144827 2144827 defendant Withepoll Edward gent 593808 593808 Withepoll, Edward, of Akenham, or of Wenham Magna, Suff, gent 0
4559356 2218878 2218878 defendant Dryver John   593808 593808 Dryver, John, of Akenham 2
4802125 2296857 2296857 defendant Kent John husbandman 593808 593808 Kent, John, of Akenham, husbandman 0
4854879 2312881 2312881 plaintiff Abraham Robert   593808 593808 Abraham, Robert, of Akenham 0
4854884 2312882 2312882 plaintiff Abraham Robert   593808 593808 Abraham, Robert, of Akenham 0
4997395 2356071 2356071 defendant Bernard John gent 593808 593808 Bernard, John, of Akenham, gent 0
4997397 2356071 2356071 defendant Smyth Nicholas laborer 593808 593808 Smyth, Nicholas, of Akenham, laborer 2
5053452 2372637 2372637 plaintiff Barnard John   593808 593808 Barnard, John, of Akenham 0
5054097 2372820 2372820 defendant Shrobbe John laborer 593808 593808 Shrobbe, John, of Akenham, laborer 0
5071074 2377840 2377840 defendant Bernard John   593808 593808 Bernard, John, of Akenham 0
5077109 2379654 2379654 plaintiff Bernard John   593808 593808 Bernard, John, of Akenham 0
5077115 2379655 2379655 plaintiff Bernard John   593808 593808 Bernard, John, of Akenham 0
5082116 2381146 2381146 defendant Heryng Thomas yeoman 593808 593808 Heryng, Thomas, of Akenham, yeoman 3
5086694 2382499 2382499 defendant Pytt John laborer 593808 593808 Pytt, John, of Akenham, laborer 3
5086696 2382500 2382500 defendant Bernard John gent 593808 593808 Bernard, John, of Akenham, gent 0
5086697 2382500 2382500 defendant Quyntyn Walter yeoman 593808 593808 together with Quyntyn, Walter, of Akenham, yeoman 1
5086698 2382500 2382500 defendant Boughton William laborer 593808 593808 Boughton, William, of Akenham, laborer 2
5086699 2382500 2382500 defendant Ducheman John   593808 593808 Ducheman, John, of Akenham, servant 3
5086701 2382501 2382501 defendant Quyntyn Walter yeoman 593808 593808 Quyntyn, Walter, of Akenham, yeoman 0
5086702 2382501 2382501 defendant Boughton William laborer 593808 593808 Boughton, William, of Akenham, laborer 1
5086703 2382501 2382501 defendant Ducheman John   593808 593808 Ducheman, John, of Akenham, servant 2
5086704 2382501 2382501 defendant Bernard John gent 593808 593808 together with Bernard, John, of Akenham, gent 3
5098325 2385940 2385940 defendant Bernard John gent 593808 593808 Bernard, John, of Akenham, gent 0
5098330 2385941 2385941 defendant Quyntyn Walter yeoman 593808 593808 Quyntyn, Walter, of Akenham, yeoman 0
5098333 2385942 2385942 defendant Quyntyn Walter yeoman 593808 593808 Quyntyn, Walter, of Akenham, yeoman 0
5098338 2385944 2385944 defendant Quyntyn Walter yeoman 593808 593808 Quyntyn, Walter, of Akenham, yeoman 0
5098339 2385944 2385944 defendant Pytte John laborer 593808 593808 Pytte, John, of Akenham, laborer 1
5098341 2385944 2385944 defendant Boughton William husbandman 593808 593808 Boughton, William, of Akenham, husbandman 3
5098342 2385944 2385944 defendant Pye Stephen   593808 593808 Pye, Stephen, of Akenham, shepherd 4
5098343 2385944 2385944 defendant Ducheman John laborer 593808 593808 Ducheman, John, of Akenham, laborer 5
5212454 2419386 2419386 defendant Bernard John gent 593808 593808 Bernard, John, of Akenham, gent 0
5252864 2431011 2431011 plaintiff Bernard John (legal representative) 593808 593808 Bernard, John, of Akenham, gent, executrix of 0
5277216 2438419 2438419 defendant Skalpy William yeoman 593808 593808 Skalpy, William, of Akenham, yeoman 1
5277225 2438420 2438420 defendant Skalpy William yeoman 593808 593808 Skalpy, William, of Akenham, yeoman 1
5298099 2444457 2444457 plaintiff Barnard John (legal representative) 593808 593808 Barnard, John, of Akenham, gent, administrator of 0
5298100 2444457 2444457 plaintiff Hargill Roland gent 593808 593808 Hargill, Roland, of Akenham, gent 1
5312596 2448802 2448802 plaintiff Barnard John (legal representative) 593808 593808 Barnard, John, of Akenham, gent, administrator of 0
5312597 2448802 2448802 plaintiff Hargyll Roland gent 593808 593808 Hargyll, Roland, of Akenham, gent 1
5313092 2448951 2448951 plaintiff Bernard John (legal representative) 593808 593808 Bernard, John, of Akenham, administrator of 0
5313093 2448951 2448951 plaintiff Hargill Roland gent 593808 593808 Hargill, Roland, of Akenham, gent 1
5334459 2455380 2455380 defendant Hargyll Roland yeoman 593808 593808 Hargyll, Roland, of Akenham, yeoman 0
5535456 2515618 2515618 defendant Audeley John   593808 593808 Audeley, John, of Akenham, knight 0
5536791 2515992 2515992 defendant Ody John husbandman 593808 593808 Ody, John, of Akenham, husbandman 0
5550808 2520266 2520266 defendant Barnard William gent 593808 593808 Barnard, William, of Akenham, gent 2
5555261 2521543 2521543 defendant Lyncolne Robert husbandman 593808 593808 Lyncolne, Robert, of Akenham, husbandman 1
5580997 2529128 2529128 defendant Barnard William gent 593808 593808 Barnard, William, of Akenham, gent 0
5629186 2553104 2553104 plaintiff Kent John   593808 593808 Kent, John, of Akenham 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);