names

73 rows where place_id = 587394

✎ 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
3591281 1864898 1864898 defendant Nekton Robert chaplain 587394 587394 Nekton, Robert, of Marche, chaplain 2
3591285 1864899 1864899 defendant Nekton Robert chaplain 587394 587394 Nekton, Robert, of Marche, chaplain 1
3673281 1917659 1917659 defendant Karsey Thomas (legal representative) 587394 587394 Karsey, Thomas, of Marche, pike monger, executor of 0
3774976 1949908 1949908 defendant Faunteleroy Peter esq 587394 587394 Faunteleroy, Peter, of Marche, esq 0
3781112 1951829 1951829 defendant Smarwhayt Thomas gent 587394 587394 Smarwhayt, Thomas, of Marche, gent 1
3781113 1951829 1951829 defendant Smyrscth Thomas brewer 587394 587394 Smyrscth, Thomas, of Marche, brewer 2
3790172 1954745 1954745 defendant Shepard William yeoman 587394 587394 Shepard, William, of Marche, yeoman 1
3790173 1954745 1954745 defendant Wadde William yeoman 587394 587394 Wadde, William, of Marche, yeoman 2
3804476 1959340 1959340 defendant Sadde William yeoman 587394 587394 Sadde, William, of Marche, yeoman 1
3804480 1959341 1959341 defendant Sadde William yeoman 587394 587394 Sadde, William, of Marche, yeoman 1
3934844 2001955 2001955 defendant Sothewelde Thomas yeoman 587394 587394 Sothewelde, Thomas, of Marche, yeoman 1
4049158 2042146 2042146 defendant Fage Thomas yeoman 587394 587394 Fage, Thomas, of Marche, yeoman 1
4216008 2101092 2101092 defendant Shepperde Ralph fishmonger 587394 587394 Shepperde, Ralph, of Marche, fishmonger 1
4242152 2110368 2110368 defendant Shepperde Ralph fishmonger 587394 587394 Shepperde, Ralph, of Marche, fishmonger 1
4802378 2296936 2296936 defendant Payn William husbandman 587394 587394 Payn, William, of Marche, husbandman 0
4823354 2303391 2303391 defendant Halle William husbandman 587394 587394 Halle, William, of Marche, husbandman 0
4824534 2303722 2303722 plaintiff Thetford William   587394 587394 Thetford, William, of Marche, on his own account 0
4824535 2303722 2303722 defendant Witlessey Thomas yeoman 587394 587394 Witlessey, Thomas, of Marche, yeoman 0
4834373 2306757 2306757 defendant Baldewyn John clerk 587394 587394 Baldewyn, John, of Marche, clerk 5
4899287 2326420 2326420 defendant Payn William husbandman 587394 587394 Payn, William, of Marche, husbandman 0
4899288 2326420 2326420 defendant Clerk John husbandman 587394 587394 Clerk, John, of Marche, husbandman 1
4906090 2328500 2328500 defendant Staucke or Stancke Philip husbandman 587394 587394 Staucke or Stancke, Philip, of Marche, husbandman 0
4906091 2328500 2328500 defendant Jankynson Thomas husbandman 587394 587394 Jankynson, Thomas, of Marche, husbandman 1
4928039 2335202 2335202 defendant Bonyng Simon husbandman 587394 587394 Bonyng, Simon, of Marche, husbandman 1
4934879 2337310 2337310 defendant Mobbe Geoffrey husbandman 587394 587394 Mobbe, Geoffrey, of Marche, husbandman 0
5004770 2358298 2358298 defendant Grymston Thomas husbandman 587394 587394 Grymston, Thomas, of Marche, husbandman 7
5004773 2358298 2358298 defendant Colvyle John gent 587394 587394 Colvyle, John,of Marche, gent 10
5004782 2358298 2358298 defendant Snowe John husbandman 587394 587394 Snowe, John, of Marche, husbandman 19
5004800 2358302 2358302 defendant Grymston Thomas husbandman 587394 587394 Grymston, Thomas, of Marche, husbandman 6
5004803 2358302 2358302 defendant Colbylede John gent 587394 587394 Colbylede, John, of Marche, gent 9
5004812 2358302 2358302 defendant Snowe John husbandman 587394 587394 Snowe, John, of Marche, husbandman 18
5018196 2362209 2362209 defendant Clerke John husbandman 587394 587394 Clerke, John, of Marche, husbandman 4
5018201 2362211 2362211 plaintiff Colvyle John esq 587394 587394 Colvyle, John, of Marche, esq 2
5018206 2362211 2362211 defendant Clerke John yeoman 587394 587394 Clerke, John, of Marche, yeoman 1
5018207 2362211 2362211 defendant Neuton Thomas husbandman or yeoman 587394 587394 Neuton, Thomas, of Marche, husbandman or yeoman 2
5018211 2362212 2362212 plaintiff Colvyle John esq 587394 587394 Colvyle, John, of Marche, esq 2
5047587 2370897 2370897 defendant Warde Thomas husbandman 587394 587394 Warde, Thomas, of Marche, husbandman 0
5047588 2370897 2370897 defendant Chetteryse Thomas husbandman 587394 587394 Chetteryse, Thomas, of Marche, husbandman 1
5055856 2373319 2373319 defendant Mathewe John yeoman 587394 587394 Mathewe, John, of Marche, yeoman 1
5055861 2373320 2373320 defendant Mathewe John yeoman 587394 587394 Mathewe, John, of Marche, yeoman 1
5089979 2383445 2383445 defendant Spynke John husbandman 587394 587394 Spynke, John, of Marche, husbandman 2
5102198 2387065 2387065 defendant Whynell or Whyvell Richard husbandman 587394 587394 Whynell or Whyvell, Richard, of Marche, husbandman 0
5153017 2402025 2402025 defendant Horton John carter 587394 587394 Horton, John, of Marche, carter 0
5170599 2407123 2407123 defendant Horton John carter 587394 587394 Horton, John, of Marche, carter 0
5171593 2407411 2407411 defendant Lythold Thomas husbandman 587394 587394 Lythold, Thomas, of Marche, husbandman 1
5180869 2410147 2410147 defendant Baret William husbandman 587394 587394 Baret, William, of Marche, husbandman 3
5212900 2419515 2419515 defendant Whynell or Whyvell Richard husbandman 587394 587394 Whynell or Whyvell, Richard, of Marche, husbandman 2
5234118 2425571 2425571 plaintiff Colvyle John alderman of Gild of St Mary Virgin of Tydde St Giles 587394 587394 Colvyle, John, of Marche, alderman of Gild of St Mary Virgin of Tydde St Giles 0
5241465 2427703 2427703 defendant Mody John husbandman 587394 587394 Mody, John, of Marche, husbandman 0
5241467 2427704 2427704 defendant Faukes William husbandman 587394 587394 Faukes, William, of Marche, husbandman 0
5274592 2437650 2437650 defendant Payn John husbandman 587394 587394 Payn, John, of Marche, husbandman 1
5278245 2438735 2438735 defendant Mobbys Richard, junior husbandman 587394 587394 Mobbys, Richard, junior, of Marche, husbandman 0
5350633 2460312 2460312 defendant Baret John   587394 587394 Baret, John, of Marche, pike monger or husbandman 0
5356130 2461994 2461994 defendant Walbot William yeoman 587394 587394 Walbot, William, of Marche, yeoman 0
5393573 2473224 2473224 plaintiff Warbotte Richard   587394 587394 Warbotte, Richard, of Marche 1
5393574 2473224 2473224 defendant Barette John   587394 587394 Barette, John, of Marche, pike monger 0
5393575 2473224 2473224 defendant Carsey Robert   587394 587394 Carsey, Robert, of Marche, pike monger 1
5404143 2476264 2476264 defendant Sperard Philip skinner 587394 587394 Sperard, Philip, of Marche, skinner 0
5417289 2480090 2480090 defendant Sperard Philip skinner 587394 587394 Sperard, Philip, of Marche, skinner 0
5419910 2480871 2480871 plaintiff Walbotte Richard   587394 587394 Walbotte, Richard, of Marche, junior 1
5419911 2480871 2480871 defendant Barett John pikemonger 587394 587394 Barett, John, of Marche, pikemonger 0
5419912 2480871 2480871 defendant Carsey Robert pikemonger or fishmonger 587394 587394 Carsey, Robert, of Marche, pikemonger or fishmonger 1
5434532 2485271 2485271 defendant Shepard John skinner 587394 587394 Shepard, John, of Marche, skinner 0
5438467 2486440 2486440 defendant Carsey Robert   587394 587394 Carsey, Robert, of marche, pike monger or fish monger 0
5466702 2494990 2494990 defendant Lithehall Thomas husbandman 587394 587394 Lithehall, Thomas, of Marche, husbandman 0
5466703 2494990 2494990 defendant Mobbe Richard husbandman 587394 587394 Mobbe, Richard, of Marche, husbandman 1
5501516 2505408 2505408 defendant Byrd William butcher 587394 587394 Byrd, William, of Marche, butcher 1
5501517 2505408 2505408 defendant Mobe or Move John husbandman 587394 587394 Mobe or Move, John, of Marche, husbandman 2
5511978 2508604 2508604 defendant Kysby Geffrey husbandman 587394 587394 Kysby, Geffrey, of Marche, husbandman 0
5511979 2508604 2508604 defendant Neyton Robert chaplain 587394 587394 Neyton, Robert, of Marche, chaplain 1
5511980 2508604 2508604 defendant Prestman John husbandman 587394 587394 Prestman, John, of Marche, husbandman 2
5570158 2525845 2525845 defendant Walbot William, junior brewer 587394 587394 Walbot, William, junior, of Marche, brewer 2
5607982 2537403 2537403 defendant Tryplorde Richard husbandman 587394 587394 Tryplorde, Richard, of Marche, husbandman 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);