names

107 rows where place_id = 593851

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613595 1871898 1871898 defendant Seman Nicholas merchant 593851 593851 Seman, Nicholas, of Neuport, Isle of Wight, merchant 1
3615586 1872514 1872514 defendant Redclyff Christopher husbandman 593851 593851 Redclyff, Christopher, of Neuport, Isle of Wight, husbandman 0
4426628 2173138 2173138 defendant Payn William   593851 593851 Payn, William, of Neuport, Isle of Wight, son of Thomas 0
4435581 2175891 2175891 plaintiff Payn John   593851 593851 Payn, John, of Neuport, Isle of Wight 0
4435586 2175892 2175892 plaintiff Payn John   593851 593851 Payn, John, of Neuport, Isle of Wight 0
4590160 2228288 2228288 defendant Best John   593851 593851 Best, John, of Neuport, Isle of Wight 0
4651999 2246561 2246561 defendant Fyvyan Richard laborer 593851 593851 Fyvyan, Richard, of Neuport, Isle of Wight, laborer 1
4653383 2246993 2246993 defendant Crente John laborer 593851 593851 Crente, John, of Neuport, Isle of Wight, laborer 5
4656755 2248006 2248006 defendant Barbour John soldier 593851 593851 Barbour, John, of Neuport, Isle of Wight, soldier 6
4662065 2249612 2249612 defendant Malverne John husbandman 593851 593851 Malverne, John, of Neuport, Isle of Wight, husbandman 0
4676506 2258267 2258267 defendant Wortmele John chandler 593851 593851 Wortmele, John, of Neuport, Isle of Wight,chandler 0
4682978 2260290 2260290 defendant Rawebon John   593851 593851 Rawebon, John, of Neuport, Isle of Wight, milward 0
4723608 2272688 2272688 plaintiff Diere John   593851 593851 Diere, John, of Neuport, Isle of Wight 0
4724291 2272894 2272894 defendant Garton John chapman 593851 593851 Garton, John, of Neuport, Isle of Wight, chapman 0
4778418 2289229 2289229 defendant Taylyour Roger tailor 593851 593851 Taylyour, Roger, of Neuport, Isle of Wight, tailor 1
4778868 2289366 2289366 defendant Mason John brewer 593851 593851 Mason, John, of Neuport, Isle of Wight, brewer 0
4779567 2289594 2289594 defendant Baker John baker 593851 593851 Baker, John, of Neuport, Isle of Wight, baker 0
4782393 2290498 2290498 defendant Martyn Henry husbandman 593851 593851 Martyn, Henry, of Neuport, Isle of Wight, husbandman 0
4786587 2291855 2291855 defendant Taupener Robert miller 593851 593851 Taupener, Robert, of Neuport, Isle of Wight, miller 6
4801046 2296517 2296517 plaintiff White John   593851 593851 White, John, of Neuport, Isle of Wight 0
4801852 2296761 2296761 defendant Seygnour John cordwainer 593851 593851 Seygnour, John, of Neuport, Isle of Wight, cordwainer 1
4826374 2304288 2304288 defendant Lombe William potter 593851 593851 Lombe, William, of Neuport, Isle of Wight, potter 0
4871841 2318164 2318164 plaintiff Mudforde Walter   593851 593851 Mudforde, Walter, of Neuport, Isle of Wight 0
4888972 2323339 2323339 defendant Stowere John gent 593851 593851 Stowere, John, of Neuport, Isle of Wight, gent 1
4896130 2325446 2325446 defendant Stowere John gent 593851 593851 Stowere, John, of Neuport, Isle of Wight, gent 1
4949345 2341781 2341781 defendant Wyppe Richard weaver 593851 593851 Wyppe, Richard, of Neuport, Isle of Wight, weaver 0
4956529 2343910 2343910 defendant Priour William   593851 593851 Priour, William, of Neuport, Isle of Wight, servant 1
4956733 2343968 2343968 plaintiff Vyncent John weaver 593851 593851 Vyncent, John, of Neuport, Isle of Wight, weaver 0
5018135 2362191 2362191 defendant Waleys John merchant 593851 593851 Waleys, John, of Neuport, Isle of Wight, or of Portesmouth, merchant 3
5018531 2362301 2362301 defendant Kerman Richard tucker 593851 593851 Kerman, Richard, of Neuport, Isle of Wight, tucker 0
5021263 2363119 2363119 plaintiff Feveresham Thomas   593851 593851 Feveresham, Thomas, of Neuport, Isle of Wight 0
5028280 2365149 2365149 defendant Spenne John yeoman 593851 593851 Spenne, John, of Neuport, Isle of Wight, yeoman 0
5028521 2365216 2365216 defendant Snedon Richard butcher 593851 593851 Snedon, Richard, of Neuport, Isle of Wight, butcher 0
5028523 2365216 2365216 defendant Lavender Richard butcher 593851 593851 Lavender, Richard, of Neuport, Isle of Wight, butcher 2
5028525 2365216 2365216 defendant Mabyll John skinner 593851 593851 Mabyll, John, of Neuport, Isle of Wight, skinner 4
5033629 2366719 2366719 defendant Golt Richard husbandman 593851 593851 Golt, Richard, of Neuport, Isle of Wight, husbandman 1
5034274 2366881 2366881 defendant de Spenne John yeoman 593851 593851 de Spenne, John, of Neuport, Isle of Wight, yeoman 0
5034277 2366882 2366882 defendant de Spenne John yeoman 593851 593851 de Spenne, John, of Neuport, Isle of Wight, yeoman 0
5037282 2367777 2367777 plaintiff White John kerseyman or mercer 593851 593851 White, John, of Neuport, Isle of Wight, kerseyman or mercer 0
5038204 2368062 2368062 defendant Dykeman John gent 593851 593851 Dykeman, John, of Neuport, Isle of Wight, gent 0
5057668 2373859 2373859 defendant Baker Lawrence baker 593851 593851 Baker, Lawrence, of Neuport, Isle of Wight, baker 0
5065282 2376156 2376156 defendant Boket William dyer 593851 593851 Boket, William, of Neuport, Isle of Wight, dyer 0
5069331 2377317 2377317 defendant Goode John butcher 593851 593851 Goode, John, of Neuport, Isle of Wight, butcher 0
5069332 2377317 2377317 defendant Baret Thomas butcher 593851 593851 Baret, Thomas, of Neuport, Isle of Wight, butcher 1
5076498 2379470 2379470 defendant Aleyn Thomas weaver 593851 593851 Aleyn, Thomas, of Neuport, Isle of Wight, weaver 0
5078252 2379982 2379982 defendant Hasard William laborer 593851 593851 Hasard, William, of Neuport, Isle of Wight,laborer 0
5078738 2380130 2380130 defendant Furssy Denis Robertservant laborer 593851 593851 Furssy, Denis Robertservant, of Neuport, Isle of Wight, laborer 0
5083715 2381632 2381632 defendant Boure Edmund gent 593851 593851 Boure, Edmund, of Neuport, Isle of Wight, gent 0
5083716 2381632 2381632 defendant Alyn Thomas weaver 593851 593851 Alyn, Thomas, of Neuport, Isle of Wight, weaver 1
5089925 2383433 2383433 defendant Dutysshman John merchant 593851 593851 Dutysshman, John, of Neuport, Isle of Wight, merchant 0
5094232 2384719 2384719 defendant Blay Nicholas yeoman 593851 593851 Blay, Nicholas, of Neuport, Isle of Wight, yeoman 0
5094233 2384719 2384719 defendant Yonge John husbandman 593851 593851 Yonge, John, of Neuport, Isle of Wight, husbandman 1
5096733 2385482 2385482 defendant Tyrell Thomas mariner 593851 593851 Tyrell, Thomas, of Neuport, Isle of Wight, mariner 0
5098735 2386059 2386059 defendant Dykeman John gent 593851 593851 Dykeman, John, of Neuport, Isle of Wight, gent 1
5098810 2386082 2386082 defendant Fynyan Walter chapman 593851 593851 Fynyan, Walter, of Neuport, Isle of Wight, chapman 0
5098884 2386106 2386106 defendant Cane or Cave Robert yeoman 593851 593851 Cane or Cave, Robert, of Neuport, Isle of Wight, yeoman 1
5220041 2421571 2421571 defendant Colkyn John husbandman 593851 593851 Colkyn, John, of Neuport, Isle of Wight, husbandman 1
5224184 2422744 2422744 defendant Laney or Lavey Thomas merchant 593851 593851 Laney or Lavey, Thomas, of Neuport, Isle of Wight, merchant 1
5224473 2422828 2422828 defendant Tredyngton John husbandman 593851 593851 Tredyngton, John, of Neuport, Isle of Wight, husbandman 0
5227977 2423793 2423793 defendant Dykeman John gent 593851 593851 Dykeman, John, of Neuport, Isle of Wight, gent 3
5228778 2424028 2424028 defendant Pyper Henry mercer 593851 593851 Pyper, Henry, of Neuport, Isle of Wight, mercer 1
5228780 2424028 2424028 defendant Hogekyn Richard weaver 593851 593851 Hogekyn, Richard, of Neuport, Isle of Wight, weaver 3
5228781 2424028 2424028 defendant Aleyn Richard hosteler 593851 593851 Aleyn, Richard, of Neuport, Isle of Wight, hosteler 4
5232062 2424949 2424949 defendant Weste John drover 593851 593851 Weste, John, of Neuport, Isle of Wight, drover 0
5240457 2427422 2427422 defendant Colman Richard husbandman 593851 593851 Colman, Richard, of Neuport, Isle of Wight, husbandman 0
5242005 2427862 2427862 defendant Herman John bowyer 593851 593851 Herman, John, of Neuport, Isle of Wight, bowyer 0
5251742 2430651 2430651 defendant Buschet John taverner 593851 593851 Buschet, John, of Neuport, Isle of Wight, taverner 0
5253607 2431238 2431238 defendant Waverley William merchant 593851 593851 Waverley, William, of Neuport, Isle of Wight, merchant 0
5254936 2431656 2431656 defendant Sprynge William chapman 593851 593851 Sprynge, William, of Neuport, Isle of Wight, chapman 1
5264658 2434703 2434703 defendant Slade William chapman 593851 593851 Slade, William, of Neuport, Isle of Wight, chapman 0
5267209 2435506 2435506 defendant Wynet or Wyvet John husbandman 593851 593851 Wynet or Wyvet, John, of Neuport, Isle of Wight, husbandman 0
5267211 2435506 2435506 defendant Wynet or Wyvet Agnes widow 593851 593851 Wynet or Wyvet, Agnes, of Neuport, Isle of Wight, widow 2
5295950 2443804 2443804 defendant West John husbandman 593851 593851 West, John, of Neuport, Isle of Wight, husbandman 0
5340417 2457205 2457205 defendant Keybell Richard mercer 593851 593851 Keybell, Richard, of Neuport, Isle of Wight, mercer 0
5341857 2457649 2457649 plaintiff Reve John (legal representative) 593851 593851 Reve, John, of Neuport, Isle of Wight, executors of 0
5341859 2457649 2457649 defendant Bultyng John (legal representative) 593851 593851 Bultyng, John, of Neuport, Isle of Wight, chapman, executors of 0
5341860 2457649 2457649 defendant Dagvyle Simon shoemaker 593851 593851 (Dagvyle, Simon, of Neuport, Isle of Wight, shoemaker 1
5354620 2461521 2461521 defendant White William weaver 593851 593851 White, William, of Neuport, Isle of Wight, weaver 0
5354621 2461521 2461521 defendant Saunder Robert fuller 593851 593851 Saunder, Robert, of Neuport, Isle of Wight, fuller 1
5354622 2461521 2461521 defendant Sokerman John butcher 593851 593851 Sokerman, John, of Neuport, Isle of Wight, butcher 2
5451298 2490262 2490262 defendant Graunger Stephen husbandman 593851 593851 Graunger, Stephen, of Neuport, Isle of Wight, husbandman 1
5464346 2494245 2494245 defendant White William yeoman 593851 593851 White, William, of Neuport, Isle of Wight, yeoman 0
5484528 2500292 2500292 defendant Seman Nicholas yeoman 593851 593851 Seman, Nicholas, of Neuport, Isle of Wight, yeoman 0
5490440 2502036 2502036 defendant Hughlyn Thomas cordwainer 593851 593851 Hughlyn, Thomas, of Neuport, Isle of Wight, cordwainer 0
5491641 2502390 2502390 defendant Boket John merchant 593851 593851 Boket, John, of Neuport, Isle of Wight, merchant 0
5491643 2502391 2502391 defendant Boket John merchant 593851 593851 Boket, John, of Neuport, Isle of Wight, merchant 0
5502178 2505607 2505607 defendant Hughlyn Thomas cordwainer 593851 593851 Hughlyn, Thomas, of Neuport, Isle of Wight, cordwainer 0
5502179 2505607 2505607 defendant Taillour Thomas yeoman 593851 593851 Taillour, Thomas, of Neuport, Isle of Wight, yeoman 1
5502181 2505608 2505608 defendant Hughlyn Thomas cordwainer 593851 593851 Hughlyn, Thomas, of Neuport, Isle of Wight, cordwainer 0
5502228 2505621 2505621 defendant Heughlyn Thomas cordwainer 593851 593851 Heughlyn, Thomas, of Neuport, Isle of Wight, cordwainer 0
5505372 2506594 2506594 defendant Carleon John yeoman 593851 593851 Carleon, John, of Neuport, Isle of Wight, yeoman 0
5528223 2513387 2513387 defendant Seman Nicholas chapman 593851 593851 Seman, Nicholas, of Neuport, Isle of Wight, chapman 1
5535924 2515738 2515738 defendant Porter William nercer 593851 593851 Porter, William, of Neuport, Isle of Wight, nercer 0
5582323 2529547 2529547 defendant Prat John fuller 593851 593851 Prat, John, of Neuport, Isle of Wight, fuller 0
5582324 2529547 2529547 defendant Percyvale John pinner 593851 593851 Percyvale, John, of Neuport, Isle of Wight, pinner 1
5582325 2529547 2529547 defendant Pratt Nicholas fuller 593851 593851 Pratt, Nicholas, of Neuport, Isle of Wight, fuller 2
5613687 2548056 2548056 defendant Fersey Geoffrey   593851 593851 Fersey, Geoffrey, of Neuport, Isle of Wight 0
5625642 2551962 2551962 defendant Shepherd John crocker 593851 593851 Shepherd, John, of Neuport, Isle of Wight, crocker 2
5627621 2552609 2552609 defendant Leche John laborer 593851 593851 Leche, John, of Neuport, Isle of Wight, laborer 0
5627910 2552700 2552700 defendant Irlond John glover 593851 593851 Irlond, John, of Neuport, Isle of Wight, glover 0

Next page

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