names

126 rows where place_id = 590033

✎ 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
3599650 1867533 1867533 plaintiff van Best Marcus   590033 590033 van Best, Marcus, of Calais 0
3622860 1874677 1874677 plaintiff Robyns John merchant 590033 590033 Robyns, John, of Calais, merchant 0
3627933 1903590 1903590 defendant Banester Humphrey esq 590033 590033 Banester, Humphrey, of Calais, esq 0
3627960 1903601 1903601 defendant Banaster Humphrey esq 590033 590033 Banaster, Humphrey, of Calais, esq 0
3640182 1907372 1907372 defendant Talbot Gilbert, senior   590033 590033 Talbot, Gilbert, senior, of Calais, knight 3
3736279 1937586 1937586 defendant Norton Sampson gent 590033 590033 Norton, Sampson, of Calais, gent 3
3749565 1941775 1941775 defendant Norton Sampson (legal representative) 590033 590033 Norton, Sampson, of Calais, gent, executors of 2
3756565 1944033 1944033 defendant Redhed Thomas merchant of the staple 590033 590033 Redhed, Thomas, of Calais, merchant of the staple 0
3772284 1949019 1949019 defendant Knyght Thomas merchant of the staple 590033 590033 Knyght, Thomas, of Calais, merchant of the staple 0
3807790 1960321 1960321 defendant Long William soldier 590033 590033 Long, William, of Calais, soldier 0
3807794 1960322 1960322 defendant Long William soldier 590033 590033 Long, William, of Calais, soldier 0
3829562 1967136 1967136 defendant Bryswood William gent 590033 590033 Bryswood, William, of Calais, gent 0
3833044 1968258 1968258 plaintiff Knyght Thomas merchant 590033 590033 Knyght, Thomas, of Calais, merchant 0
3837845 1969751 1969751 defendant Broke Ralph esq 590033 590033 Broke, Ralph, of Calais, esq 0
3840412 1970563 1970563 defendant Kychyn William soldier 590033 590033 Kychyn, William, of Calais, soldier 0
3857338 1975927 1975927 plaintiff Appendred Griffin draper 590033 590033 Appendred, Griffin, of Calais, draper 0
3857340 1975928 1975928 plaintiff Appendred Griffin draper 590033 590033 Appendred, Griffin, of Calais, draper 0
3857342 1975929 1975929 plaintiff Appendred Griffin draper 590033 590033 Appendred, Griffin, of Calais, draper 0
3870734 1980457 1980457 plaintiff A Courte Thomas soldier 590033 590033 A Courte, Thomas, of Calais, soldier 0
3882068 1984263 1984263 plaintiff Stawton Richard   590033 590033 Stawton, Richard, of Calais 0
3882069 1984263 1984263 plaintiff Acowrt Thomas   590033 590033 Acowrt, Thomas, of Calais 1
3935750 2002266 2002266 plaintiff Lawley Thomas   590033 590033 Lawley, Thomas, of Calais, staple merchant 0
3935756 2002267 2002267 plaintiff Lawley Thomas   590033 590033 Lawley, Thomas, of Calais, staple merchant 0
3941630 2004213 2004213 defendant Lechefylde Benedict victualler 590033 590033 Lechefylde, Benedict, of Calais, victualler 0
4570443 2222328 2222328 plaintiff Wotton Lawrence   590033 590033 Wotton, Lawrence, of Calais, burgess 0
4570444 2222328 2222328 plaintiff Selby Thomas   590033 590033 Selby, Thomas, of Calais, burgess 1
4748682 2280101 2280101 plaintiff Lenyng John, senior   590033 590033 Lenyng, John, senior, of Calais 7
4748695 2280102 2280102 plaintiff Lenyng John, senior   590033 590033 Lenyng, John, senior, of Calais 6
4760258 2283561 2283561 plaintiff Coton Richard   590033 590033 Coton, Richard, of Calais, burgess 0
4779773 2289666 2289666 defendant Sellyng Richard esq 590033 590033 Sellyng, Richard, of Calais, or of Kent, esq 0
4779776 2289667 2289667 defendant Sellyng Richard esq 590033 590033 Sellyng, Richard, of Calais, or of Kent, esq 0
4801281 2296589 2296589 defendant Sellyng Richard esq 590033 590033 Sellyng, Richard, of Calais, or of Kent, esq 0
4811660 2299757 2299757 defendant Coton Richard draper 590033 590033 Coton, Richard, of Calais, draper 1
4820030 2302342 2302342 defendant Clyderhowe Robert esq 590033 590033 Clyderhowe, Robert, of Calais, esq 1
4857762 2313804 2313804 plaintiff Botillere William   590033 590033 Botillere, William, of Calais 0
4857766 2313805 2313805 plaintiff Botillere William   590033 590033 Botillere, William, of Calais 0
4859009 2314197 2314197 plaintiff Butler William   590033 590033 Butler, William, of Calais 0
4859011 2314198 2314198 plaintiff Butlier William   590033 590033 Butlier, William, of Calais 0
4864075 2315739 2315739 defendant Roun William esq 590033 590033 Roun, William, of Calais, esq 1
4880402 2320778 2320778 plaintiff Waylond Walter   590033 590033 Waylond, Walter, of Calais 0
4880404 2320779 2320779 plaintiff Waylond Walter   590033 590033 Waylond, Walter, of Calais 0
4880406 2320780 2320780 plaintiff Waylond Walter   590033 590033 Waylond, Walter, of Calais 0
4881677 2321168 2321168 plaintiff Wykham Robert   590033 590033 Wykham, Robert, of Calais 0
4881678 2321168 2321168 plaintiff Wylden Nicholas   590033 590033 Wylden, Nicholas, of Calais 1
4893178 2324585 2324585 plaintiff Roun William   590033 590033 Roun, William, of Calais 3
4893179 2324585 2324585 defendant Foxton Thomas   590033 590033 Foxton, Thomas, of Calais, knight 0
4893180 2324585 2324585 defendant Isaac Thomas   590033 590033 Isaac, Thomas, of Calais 1
4893181 2324585 2324585 defendant Treverdowe Thomas esq 590033 590033 Treverdowe, Thomas, of Calais, esq 2
4893182 2324585 2324585 defendant Appulton Thomas esq 590033 590033 Appulton, Thomas, of Calais, esq 3
4893183 2324585 2324585 defendant Oldhall William   590033 590033 Oldhall, William, of Calais, knight 4
4893184 2324585 2324585 defendant Sellyng Richard esq 590033 590033 Sellyng, Richard, of Calais, esq 5
4893185 2324585 2324585 defendant Orewell William esq 590033 590033 Orewell, William, of Calais, esq 6
4893186 2324585 2324585 defendant Sutton John esq 590033 590033 Sutton, John, of Calais, esq 7
4897163 2325770 2325770 defendant Peverell Thomas gent 590033 590033 Peverell, Thomas, of Calais, gent 0
4902390 2327363 2327363 plaintiff Veer Richard   590033 590033 Veer, Richard, of Calais 0
4936268 2337743 2337743 plaintiff Boteller William   590033 590033 Boteller, William, of Calais 0
4964316 2346240 2346240 plaintiff Clederowe Robert esq 590033 590033 Clederowe, Robert, of Calais, esq 0
4977984 2350382 2350382 plaintiff Rede Andrew   590033 590033 Rede, Andrew, of Calais 0
4986919 2353030 2353030 plaintiff Barton Simon (legal representative) 590033 590033 Barton, Simon, of Calais, formerly parson of the church of the BVM, executors of 0
5013209 2360697 2360697 plaintiff Asshynden Thomas   590033 590033 Asshynden, Thomas, of Calais 0
5016227 2361630 2361630 plaintiff Brown Robert merchant 590033 590033 Brown, Robert, of Calais, merchant 0
5022273 2363410 2363410 plaintiff Gerveys William (legal representative) 590033 590033 Gerveys, William, of Calais, executor of 0
5022276 2363411 2363411 plaintiff Gerveys William (legal representative) 590033 590033 Gerveys, William, of Calais, executor of 0
5026499 2364631 2364631 defendant Dyer Henry gent 590033 590033 Dyer, Henry, of Calais, gent 1
5037297 2367780 2367780 defendant Bate Richard husbandman 590033 590033 Bate, Richard, of Calais, draper, or of Redyng, husbandman 0
5057162 2373723 2373723 plaintiff Clyderowe Robert gent 590033 590033 Clyderowe, Robert, of Calais, gent 0
5057167 2373724 2373724 plaintiff Clyderowe Robert gent 590033 590033 Clyderowe, Robert, of Calais, gent 0
5080885 2380775 2380775 defendant Pyle Richard gent 590033 590033 Pyle, Richard, of Calais, or of London, gent 0
5080886 2380775 2380775 defendant Knyvesworth William yeoman 590033 590033 Knyvesworth, William, of Calais, or of London, yeoman 1
5103805 2387538 2387538 defendant Fynay Bartholomew soldier 590033 590033 Fynay, Bartholomew, of Calais, soldier 1
5109354 2389164 2389164 plaintiff Gardebray William   590033 590033 Gardebray, William, of Calais 0
5109356 2389165 2389165 plaintiff Gardebray William   590033 590033 Gardebray, William, of Calais 0
5110102 2389368 2389368 plaintiff Grene James   590033 590033 Grene, James, of Calais 0
5110106 2389369 2389369 plaintiff Grene James esq 590033 590033 Grene, James, of Calais, esq 0
5121169 2392618 2392618 plaintiff Sybsey George gent 590033 590033 Sybsey, George, of Calais, gent 0
5121171 2392619 2392619 plaintiff Sybsey George gent 590033 590033 Sybsey, George, of Calais, gent 0
5136143 2397083 2397083 plaintiff Neuwerk Robert merchant 590033 590033 Neuwerk, Robert, of Calais, merchant 0
5156458 2403043 2403043 plaintiff Neuwerke Robert merchant 590033 590033 Neuwerke, Robert, of Calais, merchant 0
5161363 2404418 2404418 plaintiff Stowe Robert merchant of the Staple 590033 590033 Stowe, Robert, of Calais, merchant of the Staple 0
5172663 2407732 2407732 plaintiff Neuwerke Robert merchant 590033 590033 Neuwerke, Robert, of Calais, merchant 0
5194494 2414120 2414120 plaintiff Pyrton William esq 590033 590033 Pyrton, William, of Calais, esq 0
5194496 2414121 2414121 plaintiff Pyrton William esq 590033 590033 Pyrton, William, of Calais, esq 0
5208767 2418288 2418288 plaintiff Pyrton William esq 590033 590033 Pyrton, William, of Calais, esq 0
5212594 2419431 2419431 defendant Newark Thomas merchant 590033 590033 Newark, Thomas, of Calais, merchant 1
5216590 2420582 2420582 plaintiff Denstonys or Deustones John merchant 590033 590033 Denstonys or Deustones, John, of Calais, merchant 0
5218521 2421148 2421148 defendant Gerrard Richard gent 590033 590033 Gerrard, Richard, of Calais, gent 0
5223896 2422674 2422674 plaintiff Pecke John (legal representative) 590033 590033 Pecke, John, of Calais, bailiff of Marke and Oye, gent, executors of 0
5223897 2422674 2422674 plaintiff Feney Richard alderman 590033 590033 (Feney, Richard, of Calais, alderman 1
5235159 2425862 2425862 plaintiff Danyell William soldier 590033 590033 Danyell, William, of Calais, soldier 0
5250764 2430350 2430350 plaintiff Wodehous John esq 590033 590033 Wodehous, John, of Calais, esq 0
5250767 2430351 2430351 plaintiff Wodehous John esq 590033 590033 Wodehous, John, of Calais, esq 0
5250770 2430352 2430352 plaintiff Wodehous John esq 590033 590033 Wodehous, John, of Calais, esq 0
5250871 2430384 2430384 plaintiff Worsley Otewell esq 590033 590033 Worsley, Otewell, of Calais, esq 0
5250887 2430387 2430387 plaintiff Worsley Otwell esq 590033 590033 Worsley, Otwell, of Calais, esq 0
5250891 2430388 2430388 plaintiff Worsley Otwell esq 590033 590033 Worsley, Otwell, of Calais, esq 0
5265483 2434966 2434966 plaintiff Sybsey George gent 590033 590033 Sybsey, George, of Calais, or of Holbech, gent 0
5266129 2435158 2435158 plaintiff Turnebull John soldier 590033 590033 Turnebull, John, of Calais, soldier 0
5267273 2435525 2435525 plaintiff Wodehous John   590033 590033 Wodehous, John, of Calais 0
5267275 2435526 2435526 plaintiff Wodehous John   590033 590033 Wodehous, John, of Calais 0
5270068 2436352 2436352 plaintiff Croke John   590033 590033 Croke, John, of Calais, staple merchant 0

Next page

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