names

82 rows where place_id = 600403

✎ 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
3640912 1907601 1907601 defendant Antom John yeoman 600403 600403 Antom, John, of Hoghton, yeoman 0
3661639 1913918 1913918 defendant Sekker John husbandman 600403 600403 Sekker, John, of Hoghton, husbandman 0
3685560 1921633 1921633 defendant Anton John, senior husbandman 600403 600403 Anton, John, senior, of Hoghton, husbandman 1
3685563 1921634 1921634 defendant Anton John, senior husbandman 600403 600403 Anton, John, senior, of Hoghton, husbandman 1
3817533 1963389 1963389 defendant Gray Henry   600403 600403 Gray, Henry, of Hoghton, wheelwright 2
3817534 1963389 1963389 defendant Hyncheclyffe John   600403 600403 Hyncheclyffe, John, of Hoghton, wheelwright 3
4105577 2062275 2062275 defendant Dyneley Arthur gent 600403 600403 Dyneley, Arthur, of Hoghton, gent 1
4438470 2181318 2181318 defendant Lewes John   600403 600403 Lewes, John, of Hoghton, millward 0
4438980 2181485 2181485 defendant Athelard John   600403 600403 Athelard, John, of Hoghton 2
4453472 2186091 2186091 defendant Thurleby Alan de   600403 600403 Thurleby, Alan de, of Hoghton 2
4466980 2190344 2190344 plaintiff Athelard Robert (legal representative) 600403 600403 Athelard, Robert, of Hoghton, executrix of 0
4478746 2194020 2194020 defendant Benge James   600403 600403 Benge, James, of Hoghton 0
4496762 2199655 2199655 defendant Jonson Thomas   600403 600403 Jonson, Thomas, of Hoghton 2
4496772 2199658 2199658 defendant Frost John   600403 600403 Frost, John, of Hoghton 1
4506260 2202459 2202459 defendant del Leighes William   600403 600403 del Leighes, William, of Hoghton 4
4541609 2213270 2213270 defendant Bayly Richard   600403 600403 Bayly, Richard, of Hoghton 0
4547754 2215236 2215236 defendant Thomson Richard   600403 600403 Thomson, Richard, of Hoghton 3
4555041 2217505 2217505 defendant Coly John   600403 600403 Coly, John, of Hoghton 2
4562254 2219762 2219762 defendant Bailly Thomas   600403 600403 Bailly, Thomas, of Hoghton 1
4562667 2219882 2219882 defendant Breuster Robert   600403 600403 Breuster, Robert, of Hoghton 1
4562907 2219963 2219963 defendant Hawe Thomas othe   600403 600403 Hawe, Thomas othe, of Hoghton 1
4568768 2221815 2221815 defendant Buttele William   600403 600403 Buttele, William, of Hoghton 0
4569111 2221928 2221928 defendant Purdien John   600403 600403 Purdien, John, of Hoghton 0
4593713 2229307 2229307 defendant Milward John, sen   600403 600403 Milward, John, sen, of Hoghton 1
4611141 2234549 2234549 defendant Lyghtfot Wiliam   600403 600403 Lyghtfot, Wiliam, of Hoghton 1
4665255 2250620 2250620 defendant Burt or Bust Stephen yeoman 600403 600403 Burt or Bust, Stephen, of Hoghton, yeoman 1
4676994 2258421 2258421 defendant Cook Henry husbandman 600403 600403 Cook, Henry, of Hoghton, husbandman 1
4680519 2259519 2259519 defendant Welman John husbandman 600403 600403 Welman, John, of Hoghton, husbandman 0
4680942 2259665 2259665 defendant Yate Thomas laborer 600403 600403 Yate, Thomas, of Hoghton, laborer 1
4698965 2265154 2265154 defendant Welman John husbandman 600403 600403 Welman, John, of Hoghton, husbandman 0
4698966 2265154 2265154 defendant Frost Nicholas husbandman 600403 600403 Frost, Nicholas, of Hoghton, husbandman 1
4698967 2265154 2265154 defendant Ulff Adam husbandman 600403 600403 Ulff, Adam, of Hoghton, husbandman 2
4704411 2266754 2266754 defendant Farndon John husbandman 600403 600403 Farndon, John, of Hoghton, husbandman 0
4710507 2268644 2268644 defendant Smyth John smith 600403 600403 Smyth, John, of Hoghton, smith 0
4729955 2274574 2274574 defendant Lynne John yeoman 600403 600403 Lynne, John, of Hoghton, yeoman 1
4747325 2279720 2279720 defendant Stevene John husbandman 600403 600403 Stevene, John, of Hoghton, husbandman 0
4748099 2279954 2279954 defendant Assheby William gent 600403 600403 Assheby, William, of Hoghton, gent 0
4755436 2282079 2282079 defendant Tyell Richard husbandman 600403 600403 Tyell, Richard, of Hoghton, husbandman 4
4755443 2282080 2282080 defendant Tyell Richard husbandman 600403 600403 Tyell, Richard, of Hoghton, husbandman 4
4756054 2282274 2282274 defendant Assheby William gent 600403 600403 Assheby, William, of Hoghton, gent 0
4758535 2283049 2283049 defendant Warde John husbandman 600403 600403 Warde, John, of Hoghton, husbandman 1
4760554 2283653 2283653 defendant Aleynesson John yeoman 600403 600403 Aleynesson, John, of Hoghton, yeoman 1
4770437 2286725 2286725 defendant Fuller William fuller 600403 600403 Fuller, William, of Hoghton, fuller 1
4770447 2286729 2286729 defendant Eyryk Thomas   600403 600403 Eyryk, Thomas, of Hoghton 0
4783739 2290936 2290936 defendant Assheby William gent 600403 600403 Assheby, William, of Hoghton, gent 0
4788204 2292382 2292382 defendant Mawer Geoffrey yeoman 600403 600403 Mawer, Geoffrey, of Hoghton, Cumber, yeoman 3
4818043 2301720 2301720 defendant Lynne John yeoman 600403 600403 Lynne, John, of Hoghton, yeoman 2
4820803 2302588 2302588 defendant Broghton Richard husbandman 600403 600403 Broghton, Richard, of Hoghton, husbandman 1
4840316 2308518 2308518 defendant Pesemy John laborer 600403 600403 Pesemy, John, of Hoghton, laborer 2
4842789 2309283 2309283 defendant Pereson Roger yeoman 600403 600403 together with Pereson, Roger, of Hoghton, yeoman 2
4862308 2315220 2315220 defendant Tynegate Thomas yeoman 600403 600403 Tynegate, Thomas, of Hoghton, yeoman 5
4862924 2315388 2315388 defendant Nicolson John yeoman 600403 600403 Nicolson, John, of Hoghton, yeoman 6
4894391 2324920 2324920 defendant Nicholson John yeoman 600403 600403 Nicholson, John, of Hoghton, yeoman 0
4894392 2324920 2324920 defendant Tynegate Thomas yeoman 600403 600403 Tynegate, Thomas, of Hoghton, yeoman 1
4894393 2324920 2324920 defendant Lyn John yeoman 600403 600403 Lyn, John, of Hoghton, yeoman 2
4894394 2324920 2324920 defendant Pereson John yeoman 600403 600403 Pereson, John, of Hoghton, yeoman 3
4930781 2336034 2336034 defendant Pottys Thomas   600403 600403 Pottys, Thomas, of Hoghton, mason 1
4970557 2348136 2348136 defendant Whitamore Ralph husbandman 600403 600403 Whitamore, Ralph, of Hoghton, husbandman 1
4999475 2356716 2356716 defendant Page John husbandman 600403 600403 Page, John, of Hoghton, husbandman 0
5004848 2358316 2358316 defendant Graunt William husbandman 600403 600403 Graunt, William, of Hoghton, husbandman 0
5020404 2362853 2362853 defendant Lynne Thomas husbandman 600403 600403 Lynne, Thomas, of Hoghton, husbandman 0
5112063 2389914 2389914 plaintiff Sudbury John chaplain 600403 600403 Sudbury, John, of Hoghton, chaplain 1
5112065 2389914 2389914 defendant Vicary John, junior husbandman 600403 600403 Vicary, John, junior, of Hoghton, husbandman 1
5120983 2392570 2392570 plaintiff Sudbury John chaplain 600403 600403 Sudbury, John, of Hoghton, chaplain 0
5120984 2392570 2392570 defendant Vycary John husbandman 600403 600403 Vycary, John, of Hoghton, husbandman 0
5120985 2392570 2392570 defendant Frost John husbandman 600403 600403 Frost, John, of Hoghton, husbandman 1
5120986 2392570 2392570 defendant Wattys John husbandman 600403 600403 Wattys, John, of Hoghton, husbandman 2
5120988 2392570 2392570 defendant Vycary John, senior husbandman 600403 600403 Vycary, John, senior, of Hoghton, husbandman 4
5268002 2435754 2435754 defendant Forster Richard esq 600403 600403 Forster, Richard, of Hoghton, esq 0
5283802 2440301 2440301 defendant Kember William husbandman 600403 600403 Kember, William, of Hoghton, husbandman 12
5346991 2459218 2459218 defendant Graunte John husbandman 600403 600403 Graunte, John, of Hoghton, husbandman 1
5346992 2459218 2459218 defendant Batte Robert husbandman 600403 600403 Batte, Robert, of Hoghton, husbandman 2
5353888 2461281 2461281 defendant Topclyf Robert yeoman 600403 600403 Topclyf, Robert, of Hoghton, yeoman 5
5448502 2489449 2489449 defendant Forster Parnel widow 600403 600403 (Forster, Parnel, of Hoghton, widow 1
5514934 2509511 2509511 defendant Carpynter John yeoman 600403 600403 Carpynter, John, of Hoghton, yeoman 0
5514935 2509511 2509511 defendant Alston Richard husbandman 600403 600403 Alston, Richard, of Hoghton, husbandman 1
5514936 2509511 2509511 defendant Carpynter Thomas husbandman 600403 600403 Carpynter, Thomas, of Hoghton, husbandman 2
5594836 2533354 2533354 defendant Stanhop Elizabeth widow 600403 600403 Stanhop, Elizabeth, of Hoghton, widow 2
5610127 2546875 2546875 defendant Hendeson Roger   600403 600403 Hendeson, Roger, of Hoghton 4
5621172 2550504 2550504 defendant Typper John   600403 600403 Typper, John, of Hoghton 0
5631277 2553784 2553784 defendant Cook John husbandman 600403 600403 Cook, John, of Hoghton, husbandman 6
5631278 2553784 2553784 defendant Aleynson John husbandman 600403 600403 Aleynson, John, of Hoghton, husbandman 7

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