names

81 rows where place_id = 592105

✎ 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
3606587 1869733 1869733 defendant Underwode John yeoman 592105 592105 Underwode, John, of Okeham, Rutland, yeoman 1
3635444 1905881 1905881 defendant Gerves Henry yeoman 592105 592105 Gerves, Henry, of Okeham, Rutland, yeoman 0
3683824 1921076 1921076 defendant Jervys Henry yeoman 592105 592105 Jervys, Henry, of Okeham, Rutland, yeoman 3
3694574 1924507 1924507 defendant Jerves Henry yeoman 592105 592105 Jerves, Henry, of Okeham, Rutland, yeoman 3
3727207 1934780 1934780 defendant Jervys Henry yeoman 592105 592105 Jervys, Henry, of Okeham, Rutland, yeoman 2
3727448 1934859 1934859 defendant Plaves William brasier 592105 592105 Plaves, William, of Okeham, Rutland, brasier 0
3740031 1938736 1938736 defendant Wright William miller 592105 592105 Wright, William, of Okeham, Rutland, miller 1
3747221 1941049 1941049 defendant Jerves Henry yeoman 592105 592105 Jerves, Henry, of Okeham, Rutland, yeoman 0
3810960 1961328 1961328 defendant Sheperd William husbandman 592105 592105 Sheperd, William, of Okeham, Rutland, husbandman 1
3819651 1964026 1964026 defendant Dowye William husbandman 592105 592105 Dowye, William, of Okeham, Rutland, husbandman 0
3891469 1987414 1987414 defendant Fancell Hugh yeoman 592105 592105 Fancell, Hugh, of Okeham, Rutland, yeoman 1
3903217 1991300 1991300 defendant Perkyns Thomas (legal representative) 592105 592105 Perkyns, Thomas, of Okeham, Rutland, chapman, executors of 3
3950328 2007196 2007196 defendant Carpenter William, senior husbandman 592105 592105 Carpenter, William, senior, of Okeham, Rutland, husbandman 0
3973826 2015414 2015414 defendant Cutt William yeoman 592105 592105 Cutt, William, of Okeham, Rutland, yeoman 1
4118380 2066863 2066863 defendant Williams Edward   592105 592105 Williams, Edward, of Okeham, Rutland, surgeon 0
4118382 2066864 2066864 defendant Wylliams Edward   592105 592105 Wylliams, Edward, of Okeham, Rutland, surgeon 0
4179421 2088279 2088279 defendant Thorp Hugh yeoman 592105 592105 Thorp, Hugh, of Okeham, Rutland, yeoman 0
4183113 2089577 2089577 defendant Greye Robert   592105 592105 Greye, Robert, of Okeham, Rutland, woollen draper 0
4188218 2091382 2091382 defendant Normanton Henry husbandman 592105 592105 Normanton, Henry, of Okeham, Rutland, husbandman 1
4217664 2101672 2101672 defendant Grey Clement   592105 592105 Grey, Clement, of Okeham, Rutland, woollen draper 0
4295328 2128414 2128414 defendant Cole Thomas butcher 592105 592105 Cole, Thomas, of Okeham, Rutland, butcher 0
4372925 2155393 2155393 defendant Woodcock John draper 592105 592105 Woodcock, John, of Okeham, Rutland, draper 0
4372929 2155394 2155394 defendant Graye Clement draper 592105 592105 Graye, Clement, of Okeham, Rutland, draper 0
4539671 2212668 2212668 defendant (illegible) William   592105 592105 _, William, of Okeham, Rutland 3
4559637 2218968 2218968 defendant Pensax John   592105 592105 Pensax, John, of Okeham, Rutland 0
4559639 2218969 2218969 defendant Pensax John   592105 592105 Pensax, John, of Okeham, Rutland 0
4636764 2242318 2242318 defendant Malkyn Robert chapman 592105 592105 Malkyn, Robert, of Okeham, Rutland, chapman 0
4661927 2249577 2249577 defendant Hewe Roger barber 592105 592105 Hewe, Roger, of Okeham, Rutland, barber 0
4831401 2305853 2305853 defendant Cranowe John baker 592105 592105 Cranowe, John, of Okeham, Rutland, baker 0
4837714 2307729 2307729 defendant Jancokes Richard chapman 592105 592105 Jancokes, Richard, of Okeham, Rutland, chapman 1
4857376 2313696 2313696 defendant Asshewell John yeoman 592105 592105 Asshewell, John, of Okeham, Rutland, yeoman 0
4959822 2344900 2344900 defendant More William   592105 592105 More, William, of Okeham, Rutland, "elyman" 1
4976828 2350020 2350020 defendant Kendale Thomas yeoman 592105 592105 Kendale, Thomas, of Okeham, Rutland, yeoman 3
4979674 2350876 2350876 defendant Dukworth Cecily widow 592105 592105 Dukworth, Cecily, of Okeham, Rutland, widow 3
4983361 2351929 2351929 defendant Flore Thomas esq 592105 592105 Flore, Thomas, of Okeham, Rutland, esq 0
4983364 2351930 2351930 defendant Flore Thomas esq 592105 592105 Flore, Thomas, of Okeham, Rutland, esq 0
4994578 2355238 2355238 defendant Lewys William merchant 592105 592105 Lewys, William, of Okeham, Rutland, merchant 11
5057925 2373943 2373943 defendant Waryn James merchant 592105 592105 Waryn, James, of Okeham, Rutland, merchant 0
5059990 2374551 2374551 defendant Flore Thomas esq 592105 592105 Flore, Thomas, of Okeham, Rutland, esq 0
5066607 2376537 2376537 defendant Waryn James   592105 592105 together with Waryn, James, of Okeham, Rutland, franklin 2
5075205 2379076 2379076 defendant Waryn James merchant 592105 592105 Waryn, James, of Okeham, Rutland, merchant 0
5106657 2388376 2388376 defendant Hubberd Robert chapman 592105 592105 Hubberd, Robert, of Okeham, Rutland, chapman 0
5160651 2404212 2404212 defendant Coward John yeoman 592105 592105 Coward, John, of Okeham, Rutland, yeoman 0
5163443 2405040 2405040 defendant Flore John esq 592105 592105 Flore, John, of Okeham, Rutland, esq 0
5176779 2408896 2408896 defendant Gouby Thomas chapman 592105 592105 Gouby, Thomas, of Okeham, Rutland, chapman 0
5176784 2408897 2408897 defendant Gouby Thomas chapman 592105 592105 Gouby, Thomas, of Okeham, Rutland, chapman 0
5177092 2408991 2408991 defendant Flor John esq 592105 592105 Flor, John, of Okeham, Rutland, esq 0
5192826 2413625 2413625 defendant Towerys Thomas merchant 592105 592105 Towerys, Thomas, of Okeham, Rutland, merchant 0
5199165 2415509 2415509 defendant Gonby Thomas chapman 592105 592105 Gonby, Thomas, of Okeham, Rutland, chapman 0
5199170 2415510 2415510 defendant Gouby Thomas chapman 592105 592105 Gouby, Thomas, of Okeham, Rutland, chapman 0
5199810 2415691 2415691 defendant Flor Thomas esq 592105 592105 Flor, Thomas, of Okeham, Rutland, esq 0
5199825 2415698 2415698 defendant Flor Thomas esq 592105 592105 Flor, Thomas, of Okeham, Rutland, esq 0
5207886 2418040 2418040 defendant Towerys Thomas merchant 592105 592105 Towerys, Thomas, of Okeham, Rutland, merchant 0
5212519 2419408 2419408 defendant Flore Thomas esq 592105 592105 Flore, Thomas, of Okeham, Rutland, esq 0
5223096 2422464 2422464 defendant More William miller 592105 592105 More, William, of Okeham, Rutland, miller 0
5238079 2426726 2426726 defendant Towre Thomas merchant 592105 592105 Towre, Thomas, of Okeham, Rutland, merchant 0
5247974 2429545 2429545 defendant Gomby Thomas chapman 592105 592105 Gomby, Thomas, of Okeham, Rutland, chapman 0
5281403 2439632 2439632 defendant Smyth William chapman 592105 592105 Smyth, William, of Okeham, Rutland, chapman 1
5281405 2439633 2439633 defendant Smyth William chapman 592105 592105 Smyth, William, of Okeham, Rutland, chapman 0
5288940 2441770 2441770 defendant Smyth William chapman 592105 592105 Smyth, William, of Okeham, Rutland, chapman 0
5292881 2442913 2442913 plaintiff Scryvener Thomas husbandman 592105 592105 Scryvener, Thomas, of Okeham, Rutland, husbandman 0
5292892 2442914 2442914 plaintiff Scryvener Thomas husbandman 592105 592105 Scryvener, Thomas, of Okeham, Rutland, husbandman 0
5294654 2443418 2443418 defendant Hubberd Robert mercer 592105 592105 Hubberd, Robert, of Okeham, Rutland, mercer 0
5303362 2446002 2446002 defendant Collys Thomas mercer 592105 592105 Collys, Thomas, of Okeham, Rutland, mercer 2
5304079 2446226 2446226 defendant Weston John miller 592105 592105 Weston, John, of Okeham, Rutland, miller 0
5304083 2446227 2446227 defendant Weston John miller 592105 592105 Weston, John, of Okeham, Rutland, miller 0
5305224 2446567 2446567 defendant Colles Thomas mercer 592105 592105 Colles, Thomas, of Okeham, Rutland, mercer 1
5310694 2448235 2448235 defendant Smyth William mercer 592105 592105 Smyth, William, of Okeham, Rutland, mercer 1
5318751 2450699 2450699 defendant Smyth William chapman 592105 592105 Smyth, William, of Okeham, Rutland, chapman 2
5332272 2454717 2454717 defendant Fery Thomas brasier 592105 592105 Fery, Thomas, of Okeham, Rutland, brasier 1
5332277 2454718 2454718 defendant Fery Thomas brasier 592105 592105 Fery, Thomas, of Okeham, Rutland, brasier 1
5343968 2458301 2458301 defendant Obard Robert chapman 592105 592105 Obard, Robert, of Okeham, Rutland, chapman 0
5344026 2458309 2458309 defendant Obard Robert chapman 592105 592105 Obard, Robert, of Okeham, Rutland, chapman 0
5344031 2458310 2458310 defendant Obard Robert chapman 592105 592105 Obard, Robert, of Okeham, Rutland, chapman 0
5345699 2458805 2458805 defendant Hobarde Thomas chapman 592105 592105 Hobarde, Thomas, of Okeham, Rutland, chapman 4
5345710 2458806 2458806 defendant Hobarde Thomas chapman 592105 592105 Hobarde, Thomas, of Okeham, Rutland, chapman 5
5361874 2463739 2463739 defendant Hubberd Robert mercer 592105 592105 Hubberd, Robert, of Okeham, Rutland, mercer 0
5520144 2511123 2511123 defendant Bailly Robert innholder 592105 592105 Bailly, Robert, of Okeham, Rutland, innholder 0
5520150 2511124 2511124 defendant Bailly Robert innholder 592105 592105 Bailly, Robert, of Okeham, Rutland, innholder 0
5590025 2531866 2531866 defendant Tylston or Tylson William yeoman 592105 592105 Tylston or Tylson, William, of Okeham, Rutland, yeoman 0
5633120 2554361 2554361 defendant Peyntour John painter 592105 592105 Peyntour, John, of Okeham, Rutland, painter 0

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