names

91 rows where place_id = 598401

✎ 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
3589709 1864420 1864420 defendant Parker James   598401 598401 Parker, James, of King's household, knight 0
3624192 1875099 1875099 defendant Mershe Richard esq 598401 598401 Mershe, Richard, of king's household, Westminster, esq 1
3632306 1904924 1904924 plaintiff Heron John esq 598401 598401 Heron, John, of King's household, esq 0
3633966 1905432 1905432 defendant Guldeford Edward   598401 598401 Guldeford, Edward, of king's household, knight 2
3638740 1906934 1906934 plaintiff Twysaday Thomas esq 598401 598401 Twysaday, Thomas, of King's household, esq 0
3638748 1906937 1906937 defendant Hastynges Richard   598401 598401 Hastynges, Richard, of king's household, knight 0
3641026 1907633 1907633 defendant Damporte Ralph clerk of the larder 598401 598401 Damporte, Ralph, of King's household, gent, clerk of the larder 1
3672649 1917446 1917446 plaintiff Day John   598401 598401 Day, John, of King's household 0
3676295 1918629 1918629 plaintiff Hylton Elias yeoman 598401 598401 Hylton, Elias, of King's household, yeoman 0
3679156 1919548 1919548 plaintiff Parkyns Henry gent 598401 598401 Parkyns, Henry, of King's household, gent 0
3685997 1921780 1921780 plaintiff Blakeden Cuthbert gent 598401 598401 Blakeden, Cuthbert, of King's household, gent 0
3686008 1921784 1921784 plaintiff Blekendon Cuthbert gent 598401 598401 Blekendon, Cuthbert, of King's household, gent 0
3692798 1923938 1923938 defendant Holden William yeoman 598401 598401 Holden, William, of King's household, yeoman 3
3692799 1923938 1923938 defendant Holland Oliver yeoman 598401 598401 Holland, Oliver, of King's household, yeoman 4
3709767 1929369 1929369 plaintiff Ricroft John esq 598401 598401 Ricroft, John, of King's household, esq 0
3719157 1932276 1932276 plaintiff Grove Joh   598401 598401 Grove, Joh, of king's household 0
3734951 1937167 1937167 plaintiff Grove John   598401 598401 Grove, John, of King's household 0
3737556 1937978 1937978 defendant Champernon Philip   598401 598401 Champernon, Philip, of king's household 2
3740294 1938829 1938829 plaintiff Ricroft John esq 598401 598401 Ricroft, John, of King's household, esq 0
3758618 1944691 1944691 plaintiff Byrch William   598401 598401 Byrch, William, of king's household, groom porter 0
3762157 1945808 1945808 defendant Prestlond Randolph (legal representative) 598401 598401 Prestlond, Randolph, of King's household, executors of 1
3762162 1945809 1945809 defendant Prestlond Randolph (legal representative) 598401 598401 Prestlond, Randolph, of king's household, executors of 1
3769877 1948234 1948234 plaintiff Rycrofte John esq 598401 598401 Rycrofte, John, of King's household, esq 0
3772335 1949033 1949033 plaintiff Vaghan John gent 598401 598401 Vaghan, John, of King's household, gent 0
3775203 1949980 1949980 plaintiff Bekket Roger gent 598401 598401 Bekket, Roger, of King's household, gent 0
3778721 1951061 1951061 plaintiff Dawson Thomas   598401 598401 Dawson, Thomas, of King's household 0
3797219 1957012 1957012 defendant Sakevyle Thomas gent 598401 598401 Sakevyle, Thomas, of King's household, gent 0
3803924 1959142 1959142 plaintiff Rycrofte John esq 598401 598401 Rycrofte, John, of King's household, esq 0
3807227 1960157 1960157 defendant Darkenald Robert gent 598401 598401 Darkenald, Robert, of king's household, gent 0
3807616 1960285 1960285 defendant Raynshawe Richard gent 598401 598401 (Raynshawe, Richard, of King's household, gent 1
3811377 1961453 1961453 plaintiff Carter Nicholas   598401 598401 Carter, Nicholas, of King's household 0
3819547 1963991 1963991 defendant Burton Simon gent 598401 598401 Burton, Simon, of King's household, gent 4
3832941 1968225 1968225 defendant Phillipps John yeoman 598401 598401 Phillipps, John, of King's household, yeoman 4
3841198 1970826 1970826 defendant Wynbusshe William (legal representative) 598401 598401 Wynbusshe, William, of King's household, executrix of 0
3841909 1971039 1971039 defendant Josselyn Gabriel gent 598401 598401 Josselyn, Gabriel, of King's household, gent 2
3912906 1994648 1994648 defendant Bellyngham Thomas gent 598401 598401 (Bellyngham, Thomas, of king's household, gent 2
3912907 1994648 1994648 defendant Shelton Mary gentlewoman 598401 598401 Shelton, Mary, of king's household, gentlewoman 3
3912911 1994649 1994649 defendant Bellyngham Thomas gent 598401 598401 (Bellyngham, Thomas, of king's household, gent 2
3912912 1994649 1994649 defendant Shelton Mary gentlewoman 598401 598401 Shelton, Mary, of king's household, gentlewoman 3
3912916 1994650 1994650 defendant Bellyngham Thomas gent 598401 598401 (Bellyngham, Thomas, of king's household, gent 2
3912917 1994650 1994650 defendant Shelton Mary gentlewoman 598401 598401 Shelton, Mary, of king's household, gentlewoman 3
3916511 1995899 1995899 defendant Darcy Thomas   598401 598401 Darcy, Thomas, of king's household, knight 1
3925227 1998748 1998748 defendant Alegh Adam yeoman waferer 598401 598401 Alegh, Adam, of king's household, yeoman waferer 0
4873550 2318675 2318675 plaintiff Petham Richard   598401 598401 Petham, Richard, of King's household 0
4903517 2327710 2327710 plaintiff Thorley John   598401 598401 Thorley, John, of King's household 1
4974518 2349342 2349342 plaintiff Mayster John   598401 598401 Mayster, John, of King's household 0
4978472 2350508 2350508 plaintiff Roger John esq 598401 598401 Roger, John, of King's household, esq 0
4980102 2350999 2350999 plaintiff Prat William   598401 598401 Prat, William, of king's household 2
4980106 2351000 2351000 plaintiff Prat William   598401 598401 Prat, William, of King's household 2
5015996 2361564 2361564 plaintiff Brook Robert   598401 598401 Brook, Robert, of King's household 0
5015998 2361565 2361565 plaintiff Brook Robert   598401 598401 Brook, Robert, of King's household 0
5021990 2363323 2363323 plaintiff Fysshewyk Philip (legal representative) 598401 598401 Fysshewyk, Philip, of King's household, executors of 0
5025810 2364449 2364449 plaintiff Knyght Thomas esq 598401 598401 Knyght, Thomas, of King's household, esq 0
5025813 2364450 2364450 plaintiff Knyght Thomas esq 598401 598401 Knyght, Thomas, of King's household, esq 0
5035784 2367321 2367321 defendant Reynford John esq 598401 598401 Reynford, John, of King's household, of Westminster, esq 0
5035787 2367322 2367322 defendant Reynford John esq 598401 598401 Reynford, John, of King's household, of Westminster, esq 0
5075493 2379165 2379165 defendant Say William yeoman 598401 598401 Say, William, of king's household, yeoman butler, or of Bermondeseye, Surry, yeoman 2
5077390 2379737 2379737 plaintiff Blakney John   598401 598401 Blakney, John, of King's household 0
5079789 2380433 2380433 plaintiff Chamberleyn Robert   598401 598401 Chamberleyn, Robert, of king's household 0
5079792 2380434 2380434 plaintiff Chamberleyn Robert   598401 598401 Chamberleyn, Robert, of King's household 0
5083297 2381505 2381505 plaintiff Eyre Thomas   598401 598401 Eyre, Thomas, of king's household 0
5087669 2382780 2382780 defendant Derby Richard gent 598401 598401 Derby, Richard, of King's household, Westminster, gent 3
5098724 2386056 2386056 plaintiff Wetenhale William   598401 598401 Wetenhale, William, of king's household 1
5103305 2387397 2387397 defendant Blake Edmund esq 598401 598401 Blake, Edmund, of king's household, Westminster, esq 0
5107660 2388671 2388671 defendant Umfray John gent 598401 598401 Umfray, John, of King's household, or of Cirencester, Glos, gent 2
5282068 2439829 2439829 plaintiff Curteys Peter   598401 598401 Curteys, Peter, of King's household 0
5282070 2439830 2439830 plaintiff Curteys Peter   598401 598401 Curteys, Peter, of King's household 0
5282198 2439859 2439859 plaintiff Danyell Thomas   598401 598401 Danyell, Thomas, of King's household 0
5285128 2440675 2440675 plaintiff Gregory Robert   598401 598401 Gregory, Robert, of King's household 0
5293451 2443055 2443055 defendant Mauncell Richard yeoman 598401 598401 Mauncell, Richard, of King's household, Westminster, yeoman 1
5311769 2448546 2448546 plaintiff Abyngdon Henry gent 598401 598401 Abyngdon, Henry, of King's household, gent 0
5316052 2449877 2449877 plaintiff Curteys Peter   598401 598401 Curteys, Peter, of King's household 0
5326954 2453135 2453135 plaintiff Cornyssh Thomas   598401 598401 Cornyssh, Thomas, of King's household 1
5333343 2455045 2455045 plaintiff Curteys Peter   598401 598401 Curteys, Peter, of king's household 0
5339287 2456859 2456859 plaintiff Mason Alexander   598401 598401 Mason, Alexander, of King's household 0
5339290 2456860 2456860 plaintiff Mason Alexander   598401 598401 Mason, Alexander, of King's household 0
5494538 2503252 2503252 plaintiff Fyssher Thomas   598401 598401 Fyssher, Thomas, of King's household 0
5494539 2503252 2503252 defendant Cramp Richard esq 598401 598401 Cramp, Richard, of King's household, esq 0
5509978 2507960 2507960 plaintiff Greffeth John esq 598401 598401 Greffeth, John, of King's household, esq 0
5527120 2513054 2513054 plaintiff Lamberd Gilbert   598401 598401 Lamberd, Gilbert, of king's household 0
5536074 2515779 2515779 defendant Crawethorn William gent 598401 598401 Crawethorn, William, of king's household, gent 0
5545397 2518640 2518640 plaintiff Smyth William gent 598401 598401 Smyth, William, of king's household, gent 0
5545399 2518641 2518641 plaintiff Smyth William gent 598401 598401 Smyth, William, of king's household, gent 0
5545401 2518642 2518642 plaintiff Smyth William gent 598401 598401 Smyth, William, of king's household, gent 0
5575319 2527370 2527370 plaintiff Spacheherst Richard yeoman 598401 598401 Spacheherst, Richard, of King's household, yeoman 0
5577140 2527899 2527899 plaintiff Warde Richard gent 598401 598401 Warde, Richard, of King's household, gent 0
5577836 2528138 2528138 plaintiff Wygan Richard footman 598401 598401 Wygan, Richard, of King's household, footman 0
5595137 2533447 2533447 defendant Reynesford Henry (legal representative) 598401 598401 Reynesford, Henry, of King's household, administratrix of 4
5600267 2534968 2534968 defendant Lyngen William gent 598401 598401 Lyngen, William, of king's household, gent 0
5607873 2537367 2537367 defendant Baker Mathew esq 598401 598401 Baker, Mathew, of King's household, esq 0
5607875 2537367 2537367 defendant Hastynges Richard esq 598401 598401 Hastynges, Richard, of King's household, esq 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);