names

79 rows where place_id = 597969

✎ 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
3630581 1904394 1904394 defendant Ancell Richard husbandman 597969 597969 Ancell, Richard, of Thurgarton, husbandman 1
3637600 1906570 1906570 defendant Tatersall William husbandman 597969 597969 Tatersall, William, of Thurgarton, husbandman 1
3639240 1907084 1907084 plaintiff Warnall John clerk 597969 597969 Warnall, John, of Thurgarton, clerk 0
3686446 1921915 1921915 defendant Blakburn Robert husbandman 597969 597969 Blakburn, Robert, of Thurgarton, husbandman 0
3694131 1924369 1924369 defendant Lawes John butcher 597969 597969 Lawes, John, of Thurgarton, butcher 0
3698776 1925833 1925833 defendant Blakburn Robert husbandman 597969 597969 Blakburn, Robert, of Thurgarton, husbandman 0
3733660 1936768 1936768 defendant Wulffe John husbandman 597969 597969 Wulffe, John, of Thurgarton, husbandman 3
3748978 1941612 1941612 defendant Lawes Thomas husbandman 597969 597969 Lawes, Thomas, of Thurgarton, husbandman 0
3770539 1948468 1948468 defendant Pynchyn John husbandman 597969 597969 Pynchyn, John, of Thurgarton, husbandman 2
3770541 1948468 1948468 defendant Lawes Thomas husbandman 597969 597969 Lawes, Thomas, of Thurgarton, husbandman 4
3787899 1954006 1954006 defendant Hydys Hugh yeoman 597969 597969 Hydys, Hugh, of Thurgarton, yeoman 2
3788252 1954122 1954122 defendant Lawes Thomas husbandman 597969 597969 Lawes, Thomas, of Thurgarton, husbandman 1
3876728 1982458 1982458 defendant Spurrell William husbandman 597969 597969 Spurrell, William, of Thurgarton, husbandman 0
3878598 1983091 1983091 defendant Ulffe John husbandman 597969 597969 Ulffe, John, of Thurgarton, husbandman 0
3882710 1984481 1984481 defendant Fuller John husbandman 597969 597969 Fuller, John, of Thurgarton, husbandman 0
3893186 1987961 1987961 defendant Mason John yeoman 597969 597969 Mason, John, of Thurgarton, yeoman 0
3895233 1988613 1988613 defendant Flaxman Thomas carpenter 597969 597969 Flaxman, Thomas, of Thurgarton, carpenter 1
3902575 1991094 1991094 defendant Bramford alias Wulverton Oliver clerk 597969 597969 Bramford alias Wulverton, Oliver, of Thurgarton, clerk 2
3907363 1992752 1992752 defendant Sporell William husbandman 597969 597969 Sporell, William, of Thurgarton, husbandman 1
3944716 2005252 2005252 defendant Marys William butcher 597969 597969 Marys, William, of Thurgarton, butcher 0
3951179 2007481 2007481 defendant Bokkyng Thomas husbandman 597969 597969 Bokkyng, Thomas, of Thurgarton, husbandman 0
3995446 2023114 2023114 plaintiff Cowper Thomas esq 597969 597969 Cowper, Thomas, of Thurgarton, esq 0
3995448 2023115 2023115 plaintiff Cowper Thomas esq 597969 597969 Cowper, Thomas, of Thurgarton, esq 0
4060162 2046034 2046034 defendant Dawson Thomas miller 597969 597969 Dawson, Thomas, of Thurgarton,, miller 0
4130826 2071336 2071336 defendant Blowfilde John gent 597969 597969 Blowfilde, John, of Thurgarton, gent 0
4148271 2077525 2077525 defendant Brettyngham Nicholas husbandman 597969 597969 Brettyngham, Nicholas, of Thurgarton, husbandman 2
4387642 2160504 2160504 defendant Godbold John yeoman 597969 597969 Godbold, John, of Thurgarton, yeoman 0
4506490 2202527 2202527 defendant Bryght John tanner 597969 597969 Bryght, John, of Thurgarton, tanner 0
4507406 2202781 2202781 plaintiff Webster John, junior   597969 597969 Webster, John, junior, of Thurgarton 0
4564404 2220436 2220436 plaintiff Sapurton William   597969 597969 Sapurton, William, of Thurgarton, prior 0
4602311 2231940 2231940 plaintiff Webster John   597969 597969 Webster, John, of Thurgarton 0
4661719 2249506 2249506 defendant Louth William yeoman 597969 597969 Louth, William, of Thurgarton, yeoman 0
4712972 2269373 2269373 defendant Cole Robert husbandman 597969 597969 Cole, Robert, of Thurgarton, husbandman 0
4765956 2285344 2285344 defendant Wulveden Robert another brother in the same priory 597969 597969 Wulveden, Robert, of Thurgarton, another brother in the same priory 3
4794309 2294361 2294361 defendant Colle Hugh   597969 597969 Colle, Hugh, of Thurgarton, wright 3
4814200 2300547 2300547 defendant Wykete John yeoman 597969 597969 Wykete, John, of Thurgarton, yeoman 0
4872139 2318245 2318245 defendant Chaumberleyn John yeoman 597969 597969 Chaumberleyn, John, of Thurgarton, yeoman 8
4908240 2329128 2329128 defendant Haley Richard   597969 597969 Haley, Richard, of Thurgarton, Notts, prior 0
4909782 2329581 2329581 defendant Underwod Thomas butcher 597969 597969 Underwod, Thomas, of Thurgarton, butcher 0
4932678 2336611 2336611 plaintiff Wolveden Robert   597969 597969 (Wolveden, Robert, of Thurgarton, prior 1
4932685 2336612 2336612 plaintiff Wolveden Robert   597969 597969 (Wolveden, Robert, of Thurgarton, prior 1
4946391 2340862 2340862 defendant Wayneman John yeoman 597969 597969 Wayneman, John, of Thurgarton, yeoman 0
4949856 2341940 2341940 defendant Underwode Thomas thatcher 597969 597969 Underwode, Thomas, of Thurgarton, thatcher 8
5032667 2366439 2366439 defendant Underwode Thomas reeder 597969 597969 Underwode, Thomas, of Thurgarton, reeder 3
5044330 2369935 2369935 defendant Thirkeld Walter husbandman 597969 597969 Thirkeld, Walter, of Thurgarton, husbandman 2
5076455 2379454 2379454 defendant Dynggyll William chaplain 597969 597969 Dynggyll, William, of Thurgarton, chaplain 5
5120874 2392537 2392537 defendant Haket Thomas slater 597969 597969 Haket, Thomas, of Thurgarton, slater 1
5120875 2392537 2392537 defendant Isham Richard slater 597969 597969 Isham, Richard, of Thurgarton, slater 2
5124411 2393597 2393597 defendant Gunthorp William   597969 597969 Gunthorp, William, of Thurgarton 0
5124412 2393597 2393597 defendant Hawys Richard husbandman 597969 597969 Hawys, Richard, of Thurgarton, husbandman 1
5132123 2395886 2395886 plaintiff Haley Richard   597969 597969 Haley, Richard, of Thurgarton, Notts, prior 0
5138141 2397665 2397665 defendant Haley Richard   597969 597969 Haley, Richard, of Thurgarton, Notts, prior 0
5140405 2398295 2398295 defendant Halye Richard   597969 597969 Halye, Richard, of Thurgarton, Notts, prior 0
5140419 2398299 2398299 defendant Halye Richard   597969 597969 Halye, Richard, of Thurgarton, Notts, prior 0
5151740 2401670 2401670 plaintiff Halye Richard   597969 597969 Halye, Richard, of Thurgarton, prior 0
5158857 2403715 2403715 defendant Haley Richard   597969 597969 Haley, Richard, of Thurgarton, Notts, prior 0
5169810 2406915 2406915 plaintiff (not given) Richard prior of Halye 597969 597969 Halye, Richard, of Thurgarton, prior of 0
5186907 2411913 2411913 plaintiff Hale Richard   597969 597969 Hale, Richard, of Thurgarton 0
5186989 2411933 2411933 plaintiff Halys Richard   597969 597969 Halys, Richard, of Thurgarton, prior 0
5203784 2416858 2416858 plaintiff Cresy John (legal representative) 597969 597969 Cresy, John, of Thurgarton, yeoman, executors of 0
5203788 2416859 2416859 plaintiff Cresy John (legal representative) 597969 597969 Cresy, John, of Thurgarton, yeoman, executors of 0
5247130 2429317 2429317 defendant Gunthorp William turner 597969 597969 Gunthorp, William, of Thurgarton, turner 1
5247131 2429317 2429317 defendant Hortop John husbandman 597969 597969 Hortop, John, of Thurgarton, husbandman 2
5250897 2430390 2430390 defendant Smyth William husbandman 597969 597969 Smyth, William, of Thurgarton, husbandman 0
5250898 2430390 2430390 defendant Hortop John husbandman 597969 597969 Hortop, John, of Thurgarton, husbandman 1
5250899 2430390 2430390 defendant Wright John husbandman 597969 597969 Wright, John, of Thurgarton, husbandman 2
5250900 2430390 2430390 defendant Smyth John husbandman 597969 597969 Smyth, John, of Thurgarton, husbandman 3
5250901 2430390 2430390 defendant Gunthorp William husbandman 597969 597969 Gunthorp, William, of Thurgarton, husbandman 4
5251096 2430445 2430445 defendant Horton John husbandman 597969 597969 Horton, John, of Thurgarton, husbandman 1
5251097 2430445 2430445 defendant Hortop William laborer 597969 597969 Hortop, William, of Thurgarton, laborer 2
5272248 2436957 2436957 defendant Gunthorp Thomas tuner 597969 597969 Gunthorp, Thomas, of Thurgarton, tuner 1
5315217 2449607 2449607 defendant Beaumount Richard laborer 597969 597969 Beaumount, Richard, of Thurgarton, laborer 0
5315219 2449607 2449607 defendant Bekband Robert laborer 597969 597969 Bekband, Robert, of Thurgarton, laborer 2
5327927 2453421 2453421 defendant North Edward husbandman 597969 597969 North, Edward, of Thurgarton, husbandman 2
5353936 2461293 2461293 defendant North Edward husbandman 597969 597969 North, Edward, of Thurgarton, husbandman 5
5378129 2468737 2468737 plaintiff Thurgarton Richard   597969 597969 Thurgarton, Richard, of Thurgarton, prior 0
5420632 2481095 2481095 defendant Bokenham Thomas clerk 597969 597969 Bokenham, Thomas, of Thurgarton, clerk 3
5450612 2490064 2490064 defendant Scotte John husbandman 597969 597969 Scotte, John, of Thurgarton, husbandman 1
5609905 2546803 2546803 defendant del Hill Henry   597969 597969 del Hill, Henry, of Thurgarton 4

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