names

60 rows where place_id = 590344

✎ 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
3600721 1867880 1867880 defendant Nonyngton William smith 590344 590344 Nonyngton, William, of Humberston, smith 2
3602403 1868413 1868413 defendant Glasyner John yeoman 590344 590344 Glasyner, John, of Humberston, yeoman 1
3673315 1917668 1917668 defendant Down John miller 590344 590344 Down, John, of Humberston, miller 2
3675125 1918248 1918248 defendant Down John miller 590344 590344 Down, John, of Humberston, miller 2
3681472 1920294 1920294 defendant Blount Christopher husbandman 590344 590344 Blount, Christopher, of Humberston, husbandman 1
3681475 1920295 1920295 defendant Blount Christopher husbandman 590344 590344 Blount, Christopher, of Humberston, husbandman 1
3724860 1934062 1934062 defendant Blount Christopher husbandman 590344 590344 Blount, Christopher, of Humberston, husbandman 1
3724861 1934062 1934062 defendant Pawmer William   590344 590344 Pawmer, William, of Humberston. Husbandman 2
3724862 1934062 1934062 defendant Kyng John husbandman 590344 590344 Kyng, John, of Humberston, husbandman 3
3724863 1934062 1934062 defendant Tolleys John husbandman 590344 590344 Tolleys, John, of Humberston, husbandman 4
3724864 1934062 1934062 defendant Tyrrewastell John husbandman 590344 590344 Tyrrewastell, John, of Humberston, husbandman 5
3775136 1949956 1949956 defendant Tharald Thomas husbandman 590344 590344 Tharald, Thomas, of Humberston, husbandman 0
3878224 1982964 1982964 defendant Webster Thomas husbandman 590344 590344 Webster, Thomas, of Humberston, husbandman 3
3936347 2002479 2002479 defendant Barcock Jasper yeoman 590344 590344 Barcock, Jasper, of Humberston, yeoman 0
3936349 2002479 2002479 defendant Chamberlyn John husbandman 590344 590344 Chamberlyn, John, of Humberston, husbandman 2
3947380 2006158 2006158 defendant Sympson Thomas husbandman 590344 590344 Sympson, Thomas, of Humberston, husbandman 0
3953162 2008172 2008172 defendant Grene Thomas yeoman 590344 590344 Grene, Thomas, of Humberston Gate, Leicester, yeoman 3
3993645 2022472 2022472 defendant Kebell Henry (legal representative) 590344 590344 Kebell, Henry, of Humberston, gent, executrix of 0
3993646 2022472 2022472 defendant Kebell Jane widow 590344 590344 Kebell, Jane, of Humberston, widow 1
4016714 2030686 2030686 defendant Wentworth John gent 590344 590344 Wentworth, John, of Humberston, gent 0
4016718 2030686 2030686 defendant Hawdenby Robert gent 590344 590344 Hawdenby, Robert, of Humberston, gent 4
4029238 2035101 2035101 defendant Kebel Jane widow 590344 590344 Kebel, Jane, of Humberston, widow 1
4050681 2042676 2042676 defendant Allen Richard yeoman 590344 590344 Allen, Richard, of Humberston, yeoman 0
4073860 2050942 2050942 defendant Presgrave John yeoman 590344 590344 Presgrave, John, of Humberston, yeoman 0
4073861 2050942 2050942 defendant Presgrave Francis   590344 590344 Presgrave, Francis, of Humberston, yeoman, his son 1
4075971 2051703 2051703 defendant Snyte William laborer 590344 590344 Snyte, William, of Humberston, laborer 0
4098225 2059692 2059692 defendant Wentworth John gent 590344 590344 Wentworth, John, of Humberston, gent 0
4111416 2064329 2064329 defendant Neave Henry husbandman 590344 590344 Neave, Henry, of Humberston, husbandman 0
4196624 2094365 2094365 defendant Ithell Robert gent 590344 590344 Ithell, Robert, of Humberston gate, Leicester, gent 0
4232916 2107021 2107021 defendant Clithero John husbandman 590344 590344 Clithero, John, of Humberston, husbandman 0
4232917 2107021 2107021 defendant Hurton John husbandman 590344 590344 Hurton, John, of Humberston, husbandman 1
4667286 2255498 2255498 plaintiff Hotoft Richard   590344 590344 (Hotoft, Richard, of Humberston 1
4708163 2267931 2267931 plaintiff Neuland Robert   590344 590344 Neuland, Robert, of Humberston 0
4720328 2271698 2271698 defendant Hotoft Richard gent 590344 590344 (Hotoft, Richard, of Humberston, gent 1
4765113 2285067 2285067 plaintiff Hotoft Richard esq 590344 590344 Hotoft, Richard, of Humberston, esq 0
4825628 2304055 2304055 defendant Hotoft Thomas gent 590344 590344 Hotoft, Thomas, of Humberston, gent 1
4825629 2304055 2304055 defendant Hotoft Richard, junior gent 590344 590344 Hotoft, Richard, junior, of Humberston, gent 2
4842314 2309126 2309126 defendant Hewet William husbandman 590344 590344 Hewet, William, of Humberston, husbandman 0
4842315 2309126 2309126 defendant Atkyn Eustace husbandman 590344 590344 Atkyn, Eustace, of Humberston, husbandman 1
4861031 2314808 2314808 defendant Milner John miller 590344 590344 Milner, John, of Humberston, miller 0
4869494 2317427 2317427 defendant Sotby William husbandman 590344 590344 Sotby, William, of Humberston, husbandman 1
4920193 2332829 2332829 defendant Neweland John gent 590344 590344 Neweland, John, of Humberston, gent 0
4999426 2356699 2356699 defendant Kynde John smith 590344 590344 Kynde, John, of Humberston, smith 1
4999429 2356700 2356700 defendant Kynde John smith 590344 590344 Kynde, John, of Humberston, smith 1
5044841 2370094 2370094 plaintiff Hotoft Richard   590344 590344 Hotoft, Richard, of Humberston 0
5061996 2375188 2375188 defendant Humberston Richard husbandman 590344 590344 Humberston, Richard, of Humberston, husbandman 2
5076223 2379390 2379390 defendant Robynson William husbandman 590344 590344 Robynson, William, of Humberston, husbandman 2
5108760 2388998 2388998 defendant Balard William yeoman 590344 590344 Balard, William, of Humberston, yeoman 2
5189911 2412791 2412791 defendant Baihewe Thomas husbandman 590344 590344 Baihewe, Thomas, of Humberston, husbandman 2
5243057 2428173 2428173 defendant Aleyn William husbandman 590344 590344 Aleyn, William, of Humberston, husbandman 0
5243058 2428173 2428173 defendant Belesby Walter husbandman 590344 590344 Belesby, Walter, of Humberston, husbandman 1
5278709 2438879 2438879 defendant Hotoft Richard esq 590344 590344 Hotoft, Richard, of Humberston, esq 0
5278710 2438879 2438879 defendant Hotoft Thomas gent 590344 590344 Hotoft, Thomas, of Humberston, gent 1
5307604 2447290 2447290 defendant Butteler John yeoman alias scrivenor 590344 590344 Butteler, John, of Humberston, yeoman alias scrivenor 0
5309284 2447814 2447814 defendant Keym Thomas   590344 590344 Keym, Thomas, of Humberston. Husbandman 0
5313624 2449102 2449102 defendant Seyne or Seyve William yeoman 590344 590344 Seyne or Seyve, William, of Humberston, yeoman 1
5417793 2480247 2480247 defendant Bekeryng John   590344 590344 Bekeryng, John, of Humberston, notary & scrivenor 0
5450335 2489986 2489986 defendant Bekeryng John   590344 590344 Bekeryng, John, of Humberston, notary & scrivenor 0
5514000 2509226 2509226 defendant Bekryng John   590344 590344 Bekryng, John, of Humberston, notary or scrivener 0
5611730 2547406 2547406 defendant Lotoft William   590344 590344 Lotoft, William, of Humberston 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);