names

119 rows where place_id = 593728

✎ 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
3603940 1868902 1868902 defendant Woley John   593728 593728 Woley, John, of Horsley, scythe smith 0
3609471 1870626 1870626 defendant Stanysby Richard   593728 593728 Stanysby, Richard, of Horsley, scythe smith 0
3613106 1871752 1871752 defendant Smyth Joan widow 593728 593728 Smyth, Joan, of Horsley, widow 0
3617364 1873050 1873050 defendant Woley John   593728 593728 Woley, John, of Horsley, scythe smith 0
3620589 1874015 1874015 defendant Lane Nicholas husbandman 593728 593728 Lane, Nicholas, of Horsley, husbandman 4
3634355 1905542 1905542 defendant Clerk Robert husbandman 593728 593728 Clerk, Robert, of Horsley, husbandman 0
3686957 1922087 1922087 defendant Wrentham John husbandman 593728 593728 Wrentham, John, of Horsley, husbandman 0
3715454 1931120 1931120 defendant Godard Anthony grasier 593728 593728 Godard, Anthony, of Horsley, grasier 1
3735456 1937327 1937327 defendant Lees Joan widow 593728 593728 Lees, Joan, of Horsley, widow 0
3735457 1937327 1937327 defendant Mylner Robert   593728 593728 Mylner, Robert, of Horsley, scythe smith 1
3735458 1937327 1937327 defendant Cowper Robert husbandman 593728 593728 Cowper, Robert, of Horsley, husbandman 2
3735460 1937328 1937328 defendant Statham Henry, junior gent 593728 593728 Statham, Henry, junior, of Horsley, gent 0
3735461 1937328 1937328 defendant Clerke Robert yeoman 593728 593728 Clerke, Robert, of Horsley, yeoman 1
3735463 1937328 1937328 defendant Grene Thomas   593728 593728 Grene, Thomas, of Horsley, scythe smith 3
3735779 1937429 1937429 defendant Balle Henry   593728 593728 Balle, Henry, of Horsley, scythe smith 0
3747889 1941264 1941264 defendant Launder Roger tailor 593728 593728 Launder, Roger, of Horsley, tailor 0
3750962 1942225 1942225 defendant Godard Anthony yeoman 593728 593728 Godard, Anthony, of Horsley, yeoman 0
3767394 1947446 1947446 defendant Godard Anthony yeoman 593728 593728 Godard, Anthony, of Horsley, yeoman 0
3840108 1970479 1970479 defendant Lord John laborer 593728 593728 Lord, John, of Horsley, laborer 0
3840110 1970479 1970479 defendant Bruer Thomas laborer 593728 593728 Bruer, Thomas, of Horsley, laborer 2
3861613 1977344 1977344 defendant Lynnet John, junior carpenter 593728 593728 Lynnet, John, junior, of Horsley, carpenter 0
3862038 1977491 1977491 defendant Robynson Robert   593728 593728 Robynson, Robert, of Horsley, scythe smith 0
3872450 1981010 1981010 defendant Robynson Robert   593728 593728 Robynson, Robert, of Horsley, scythe smith 0
3944216 2005082 2005082 defendant Clarke Thomas yeoman 593728 593728 Clarke, Thomas, of Horsley, yeoman 0
3979373 2017371 2017371 plaintiff Newton Robert gent 593728 593728 Newton, Robert, of Horsley, gent 0
4002026 2025503 2025503 defendant Horsley Thomas nailer 593728 593728 Horsley, Thomas, of Horsley, nailer 1
4010154 2028402 2028402 defendant Byngham alias Cowper Richard   593728 593728 Byngham alias Cowper, Richard, of Horsley, scythe smith 0
4163215 2082664 2082664 defendant Mylwartt Richard husbandman 593728 593728 Mylwartt, Richard, of Horsley, husbandman 0
4163218 2082665 2082665 defendant Mylwartt Richard husbandman 593728 593728 Mylwartt, Richard, of Horsley, husbandman 0
4170124 2085045 2085045 defendant Ashmore Henry   593728 593728 Ashmore, Henry, of Horsley, "stonpecker" 2
4171463 2085484 2085484 defendant Sydaye John yeoman 593728 593728 Sydaye, John, of Horsley, yeoman 0
4182778 2089456 2089456 defendant Beydon George weaver 593728 593728 Beydon, George, of Horsley, weaver 0
4182779 2089456 2089456 defendant Peyton Walter weaver 593728 593728 Peyton, Walter, of Horsley, weaver 1
4212298 2099847 2099847 defendant Elkyngton Thomas clothier 593728 593728 Elkyngton, Thomas, of Horsley, clothier 0
4315793 2135633 2135633 defendant Lynnett Richard husbandman 593728 593728 Lynnett, Richard, of Horsley, husbandman 0
4332740 2141233 2141233 defendant Puplett Henry yeoman 593728 593728 Puplett, Henry, of Horsley, yeoman 2
4425626 2172834 2172834 defendant Thorp Adam de   593728 593728 Thorp, Adam de, of Horsley 10
4425648 2172835 2172835 defendant Thorp Adam de   593728 593728 Thorp, Adam de, of Horsley 10
4435063 2175727 2175727 defendant Thorp Adam de   593728 593728 Thorp, Adam de, of Horsley 11
4529229 2209422 2209422 plaintiff Milner Thomas smith 593728 593728 Milner, Thomas, of Horsley, smith 0
4536598 2211725 2211725 defendant Webster Henry   593728 593728 Webster, Henry, of Horsley 0
4559755 2219005 2219005 plaintiff Milner Thomas smith 593728 593728 Milner, Thomas, of Horsley, smith 0
4576700 2224222 2224222 defendant Shepherd Thomas   593728 593728 Shepherd, Thomas, of Horsley 2
4581100 2225573 2225573 defendant Milner Thomas   593728 593728 Milner, Thomas, of Horsley 0
4619932 2237215 2237215 defendant Hylton Henry   593728 593728 Hylton, Henry, of Horsley 0
4645093 2244634 2244634 plaintiff Milner Thomas   593728 593728 Milner, Thomas, of Horsley 0
4651174 2246373 2246373 defendant Normanton William ironmonger 593728 593728 Normanton, William, of Horsley, ironmonger 0
4658830 2248633 2248633 defendant Halum John laborer 593728 593728 Halum, John, of Horsley, laborer 2
4661508 2249431 2249431 plaintiff Elot John   593728 593728 Elot, John, of Horsley 0
4776814 2288737 2288737 defendant Shosmyth William nailer 593728 593728 Shosmyth, William, of Horsley, nailer 0
4776815 2288737 2288737 defendant Dandy Richard nailer 593728 593728 Dandy, Richard, of Horsley, nailer 1
4777770 2289041 2289041 defendant Milner Thomas smith 593728 593728 Milner, Thomas, of Horsley, smith 1
4787188 2292059 2292059 defendant Shosmyth William nailer 593728 593728 Shosmyth, William, of Horsley, nailer 1
4791691 2293498 2293498 defendant Saunderson William yeoman 593728 593728 Saunderson, William, of Horsley, yeoman 3
4791822 2293540 2293540 defendant Blaunchard William yeoman 593728 593728 Blaunchard, William, of Horsley, yeoman 0
4804585 2297627 2297627 plaintiff Bonde Richard yeoman 593728 593728 Bonde, Richard, of Horsley, yeoman 0
4815748 2301027 2301027 defendant Stacy Thomas   593728 593728 Stacy, Thomas, of Horsley, vicar 1
4820740 2302561 2302561 defendant Bonde Richard yeoman 593728 593728 Bonde, Richard, of Horsley, yeoman 0
4820741 2302561 2302561 defendant Calton Roger yeoman 593728 593728 Calton, Roger, of Horsley, yeoman 1
4820773 2302573 2302573 defendant Delwere John laborer & son of William Delwere 593728 593728 Delwere, John, of Horsley, laborer & son of William Delwere 0
4820774 2302573 2302573 defendant Lye Hugh laborer 593728 593728 Lye, Hugh, of Horsley, laborer 1
4842302 2309123 2309123 defendant Normanton Roger gent 593728 593728 Normanton, Roger, of Horsley, gent 1
4862036 2315139 2315139 defendant Hareboroo Henry smith 593728 593728 Hareboroo, Henry, of Horsley, smith 2
4921114 2333120 2333120 defendant Stacy Thomas   593728 593728 Stacy, Thomas, of Horsley, vicar 0
4929913 2335767 2335767 defendant Mauncell William carter 593728 593728 Mauncell, William, of Horsley, carter 0
4934693 2337244 2337244 defendant Birchour Robert husbandman 593728 593728 Birchour, Robert, of Horsley, husbandman 0
4974763 2349421 2349421 defendant Seler William tailor 593728 593728 Seler, William, of Horsley, tailor 0
4989165 2353696 2353696 defendant Trees Robert   593728 593728 Trees, Robert, of Horsley, scythe smith 4
5029263 2365437 2365437 defendant Milner John   593728 593728 Milner, John, of Horsley, scythe smith 0
5056019 2373371 2373371 defendant Moyne Thomas husbandman 593728 593728 Moyne, Thomas, of Horsley, husbandman 0
5057005 2373676 2373676 defendant Johnson Robert husbandman 593728 593728 Johnson, Robert, of Horsley, husbandman 0
5078795 2380145 2380145 defendant Shefeld alias Shentowe William chaplain 593728 593728 Shefeld alias Shentowe, William, of Horsley, chaplain 1
5118332 2391798 2391798 defendant Edegar John butcher 593728 593728 Edegar, John, of Horsley, butcher 1
5118819 2391935 2391935 defendant Edegar John butcher 593728 593728 Edegar, John, of Horsley, butcher 1
5140056 2398196 2398196 plaintiff Stathum John (legal representative) 593728 593728 Stathum, John, of Horsley, executors of 0
5140065 2398197 2398197 plaintiff Stathum John (legal representative) 593728 593728 Stathum, John, of Horsley, executors of 0
5140071 2398198 2398198 plaintiff Stathum John (legal representative) 593728 593728 Stathum, John, of Horsley, executors of 0
5140081 2398199 2398199 plaintiff Stathum John (legal representative) 593728 593728 Stathum, John, of Horsley, executors of 0
5156301 2402995 2402995 defendant Ricardes Agnes widow 593728 593728 Ricardes, Agnes, of Horsley, widow 0
5161078 2404344 2404344 plaintiff Stathum John (legal representative) 593728 593728 Stathum, John, of Horsley, esq, executors of 0
5161087 2404345 2404345 plaintiff Stathum John (legal representative) 593728 593728 Stathum, John, of Horsley, esq, executors of 0
5161096 2404346 2404346 plaintiff Stathum John (legal representative) 593728 593728 Stathum, John, of Horsley, executors of 0
5172535 2407693 2407693 defendant Ricardes Agnes widow 593728 593728 Ricardes, Agnes, of Horsley, widow 0
5197021 2414873 2414873 plaintiff Stathum John (legal representative) 593728 593728 Stathum, John, of Horsley, esq, executors of 0
5207605 2417964 2417964 defendant Ricardes Agnes widow 593728 593728 Ricardes, Agnes, of Horsley, widow 0
5248943 2429815 2429815 defendant Trees Thomas   593728 593728 Trees, Thomas, of Horsley, scythe smith 0
5264813 2434756 2434756 defendant Tannesley Henry ironmonger 593728 593728 Tannesley, Henry, of Horsley, ironmonger 1
5352652 2460922 2460922 defendant Smyth John   593728 593728 Smyth, John, of Horsley, scythe smith 0
5352653 2460922 2460922 defendant Shirwode John   593728 593728 Shirwode, John, of Horsley, scythe smith 1
5353591 2461195 2461195 defendant Tayllour William husbandman 593728 593728 Tayllour, William, of Horsley, husbandman 1
5363183 2464138 2464138 defendant Agland Thomas   593728 593728 Agland, Thomas, of Horsley, scythe smith 2
5379197 2469090 2469090 defendant Lynnek John yeoman 593728 593728 Lynnek, John, of Horsley, yeoman 0
5400060 2475097 2475097 defendant Kays John yeoman 593728 593728 Kays, John, of Horsley, yeoman 0
5413072 2478839 2478839 defendant Kays John yeoman 593728 593728 Kays, John, of Horsley, yeoman 0
5423965 2482121 2482121 defendant Ivy Richard husbandman 593728 593728 Ivy, Richard, of Horsley, husbandman 1
5427225 2483084 2483084 defendant Smyth John smith 593728 593728 Smyth, John, of Horsley, smith 2
5428138 2483357 2483357 defendant Kays John yeoman 593728 593728 Kays, John, of Horsley, yeoman 0
5428145 2483358 2483358 defendant Kays John yeoman 593728 593728 Kays, John, of Horsley, yeoman 0
5428152 2483359 2483359 defendant Kays John yeoman 593728 593728 Kays, John, of Horsley, yeoman 0
5438094 2486330 2486330 defendant Lye William yeoman 593728 593728 Lye, William, of Horsley, yeoman 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);