names

71 rows where place_id = 593924

✎ 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
3613854 1871988 1871988 defendant Bekker John butcher 593924 593924 Bekker, John, of Calthorp, butcher 3
3700606 1926436 1926436 defendant Rocliff Brian esq 593924 593924 Rocliff, Brian, of Calthorp, esq 0
3707123 1928515 1928515 defendant Downys Thomas glover 593924 593924 Downys, Thomas, of Calthorp, glover 0
3722807 1933401 1933401 defendant Fouller William clerk 593924 593924 Fouller, William, of Calthorp, clerk 0
3722809 1933402 1933402 defendant Fouller William clerk 593924 593924 Fouller, William, of Calthorp, clerk 0
3735422 1937316 1937316 defendant Bond Thomas husbandman 593924 593924 Bond, Thomas, of Calthorp, husbandman 3
3772568 1949112 1949112 plaintiff Waller John   593924 593924 Waller, John, of Calthorp, collar maker 0
3790252 1954766 1954766 plaintiff Waller John   593924 593924 Waller, John, of Calthorp, collar maker 0
3823494 1965249 1965249 defendant Powle Richard husbandman 593924 593924 Powle, Richard, of Calthorp, husbandman 1
3824028 1965392 1965392 plaintiff Waller John   593924 593924 Waller, John, of Calthorp, collar maker 0
3878157 1982942 1982942 defendant Tubbyng William husbandman 593924 593924 Tubbyng, William, of Calthorp, husbandman 0
3932379 2001124 2001124 defendant Lenton John husbandman 593924 593924 Lenton, John, of Calthorp, husbandman 4
3953918 2008441 2008441 defendant Searles Robert   593924 593924 Searles, Robert, of Calthorp, worsted weaver 0
3960150 2010653 2010653 defendant Searles Robert   593924 593924 Searles, Robert, of Calthorp, or of Tuttyngtowne, worsted weaver 0
4222534 2103373 2103373 defendant Armiger Henry yeoman 593924 593924 Armiger , Henry, of Calthorp, yeoman 3
4325038 2138757 2138757 defendant Grave Adam laborer 593924 593924 Grave, Adam, of Calthorp, laborer 3
4431671 2174673 2174673 defendant Jakkys Ralph   593924 593924 Jakkys, Ralph, of Calthorp 0
4539501 2212614 2212614 plaintiff Walker William   593924 593924 Walker, William, of Calthorp 0
4574333 2223503 2223503 defendant Lyghtfoot Thomas   593924 593924 Lyghtfoot, Thomas, of Calthorp 0
4630312 2240392 2240392 plaintiff Stevunes John (legal representative) 593924 593924 Stevunes, John, of Calthorp, executors of 0
4718113 2271005 2271005 defendant Croppe Nicholas husbandman 593924 593924 Croppe, Nicholas, of Calthorp, husbandman 6
4742341 2278252 2278252 defendant Woderove Richard yeoman 593924 593924 Woderove, Richard, of Calthorp, yeoman 1
4751474 2280915 2280915 plaintiff Skypwyth John (legal representative) 593924 593924 Skypwyth, John, of Calthorp, executors of 0
4829258 2305190 2305190 defendant Woderove Richard husbandman 593924 593924 Woderove, Richard, of Calthorp, husbandman 1
4846253 2310330 2310330 defendant Elgold Simon widower 593924 593924 Elgold, Simon, of Calthorp, widower 4
4913777 2330810 2330810 defendant Acrys or Atrys Ralph yeoman 593924 593924 Acrys or Atrys, Ralph, of Calthorp, yeoman 0
4954343 2343267 2343267 defendant Scorer Thomas husbandman 593924 593924 Scorer, Thomas, of Calthorp, husbandman 4
5023486 2363778 2363778 defendant Kyttys John husbandman 593924 593924 Kyttys, John, of Calthorp, husbandman 0
5034375 2366914 2366914 plaintiff Sterysman John   593924 593924 Sterysman, John, of Calthorp 0
5089988 2383447 2383447 defendant Jerveys John, junior husbandman 593924 593924 Jerveys, John, junior, of Calthorp, husbandman 3
5102783 2387232 2387232 defendant Jerveys John yeoman 593924 593924 Jerveys, John, of Calthorp, yeoman 1
5102786 2387232 2387232 defendant Calthorp Oliver gent 593924 593924 Calthorp, Oliver, of Calthorp, gent 4
5241779 2427798 2427798 defendant Shipmedowe John   593924 593924 Shipmedowe, John, of Calthorp, parson of Kesewyk 1
5241809 2427805 2427805 defendant Shipmedowe John   593924 593924 Shipmedowe, John, of Calthorp, parson of Kesewyk 1
5251138 2430460 2430460 defendant Swevyn Richard   593924 593924 Swevyn, Richard, of Calthorp, plough wright 1
5252937 2431032 2431032 defendant Jerveys John husbandman 593924 593924 Jerveys, John, of Calthorp, husbandman 1
5278400 2438790 2438790 defendant Phippys William husbandman 593924 593924 Phippys, William, of Calthorp, husbandman 0
5282144 2439847 2439847 defendant Jerveys John yeoman 593924 593924 Jerveys, John, of Calthorp, yeoman 6
5282155 2439848 2439848 defendant Jerveys John yeoman 593924 593924 Jerveys, John, of Calthorp, yeoman 6
5284761 2440561 2440561 plaintiff Gerveys John yeoman 593924 593924 Gerveys, John, of Calthorp, yeoman 0
5314590 2449396 2449396 defendant Kyttys John husbandman 593924 593924 Kyttys, John, of Calthorp, husbandman 0
5314592 2449396 2449396 defendant Bokker John husbandman 593924 593924 Bokker, John, of Calthorp, husbandman 2
5337684 2456344 2456344 defendant Gerveys John husbandman 593924 593924 Gerveys, John, of Calthorp, husbandman 1
5348646 2459707 2459707 defendant Jerveys John yeoman 593924 593924 Jerveys, John, of Calthorp, yeoman 1
5362699 2463982 2463982 defendant Bekker Thomas butcher 593924 593924 Bekker, Thomas, of Calthorp, butcher 1
5372011 2466839 2466839 plaintiff Jerveys John   593924 593924 Jerveys, John, of Calthorp 0
5410455 2478073 2478073 defendant Glover Robert laborer 593924 593924 Glover, Robert, of Calthorp, laborer 3
5412764 2478767 2478767 defendant Glover Robert husbandman 593924 593924 Glover, Robert, of Calthorp, husbandman 0
5415130 2479466 2479466 plaintiff Jerveys John   593924 593924 Jerveys, John, of Calthorp 0
5417425 2480130 2480130 defendant Glover Robert husbandman 593924 593924 Glover, Robert, of Calthorp, husbandman 12
5424324 2482241 2482241 defendant Glover Robert laborer 593924 593924 Glover, Robert, of Calthorp, laborer 3
5424327 2482242 2482242 defendant Groute William engraver 593924 593924 Groute, William, of Calthorp, engraver 1
5424329 2482242 2482242 defendant Glover Robert laborer 593924 593924 Glover, Robert, of Calthorp, laborer 3
5427688 2483238 2483238 defendant Glover Robert husbandman 593924 593924 Glover, Robert, of Calthorp, husbandman 2
5427692 2483239 2483239 defendant Glover Robert husbandman 593924 593924 Glover, Robert, of Calthorp, husbandman 2
5431252 2484293 2484293 plaintiff Jerveys John   593924 593924 Jerveys, John, of Calthorp 0
5434784 2485340 2485340 defendant Glover Robert husbandman 593924 593924 Glover, Robert, of Calthorp, husbandman 11
5443489 2487962 2487962 defendant Keswyk Thomas husbandman 593924 593924 Keswyk, Thomas, of Calthorp, husbandman 5
5447158 2489041 2489041 plaintiff Herveys John   593924 593924 Herveys, John, of Calthorp 0
5447762 2489209 2489209 plaintiff Jerveys John   593924 593924 Jerveys, John, of Calthorp 0
5474175 2497249 2497249 defendant Glove Robert husbandman 593924 593924 Glove, Robert, of Calthorp, husbandman 2
5476432 2497954 2497954 defendant Bekker Thomas butcher 593924 593924 Bekker, Thomas, of Calthorp, butcher 1
5483192 2499914 2499914 plaintiff Jerveys John   593924 593924 Jerveys, John, of Calthorp 0
5487958 2501286 2501286 defendant Bekker Thomas butcher 593924 593924 Bekker, Thomas, of Calthorp, butcher 1
5491092 2502233 2502233 defendant Gerveys John yeoman 593924 593924 Gerveys, John, of Calthorp, yeoman 0
5511420 2508417 2508417 plaintiff Jerveys John   593924 593924 Jerveys, John, of Calthorp 0
5511422 2508417 2508417 defendant Lewede John husbandman 593924 593924 Lewede, John, of Calthorp, husbandman 1
5530744 2514133 2514133 defendant Grave John yeoman 593924 593924 Grave, John, of Calthorp, yeoman 1
5580486 2528984 2528984 defendant Godfrey William husbandman 593924 593924 Godfrey, William, of Calthorp, husbandman 1
5581967 2529441 2529441 defendant Bate Robert (legal representative) 593924 593924 Bate, Robert, of Calthorp, husbandman, executors of 4
5581968 2529441 2529441 defendant Thomlynson John husbandman 593924 593924 (Thomlynson, John, of Calthorp, husbandman 5

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