names

216 rows where place_id = 586749

✎ 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
3589525 1864360 1864360 defendant Legge Robert clerk 586749 586749 Legge, Robert, of Okeham, clerk 0
3589526 1864360 1864360 defendant Palady Robert clerk 586749 586749 Palady, Robert, of Okeham, clerk 1
3591394 1864934 1864934 defendant Bayly Robert butcher 586749 586749 Bayly, Robert, of Okeham, butcher 0
3591401 1864936 1864936 defendant Bocher John butcher 586749 586749 Bocher, John, of Okeham, butcher 3
3591980 1865105 1865105 defendant Ball John cordwainer 586749 586749 Ball, John, of Okeham, cordwainer 0
3597627 1866883 1866883 defendant Ashwell Robert shoemaker 586749 586749 Ashwell, Robert, of Okeham, shoemaker 0
3608517 1870324 1870324 defendant Underwode John yeoman 586749 586749 Underwode, John, of Okeham, yeoman 0
3608520 1870324 1870324 defendant Bailly Robert butcher 586749 586749 Bailly, Robert, of Okeham, butcher 3
3727203 1934779 1934779 defendant Jerves Henry yeoman 586749 586749 Jerves, Henry, of Okeham, yeoman 4
3739038 1938416 1938416 defendant Symmys William husbandman 586749 586749 Symmys, William, of Okeham, husbandman 1
3739614 1938605 1938605 plaintiff Plavys William brasier 586749 586749 Plavys, William, of Okeham, brasier 0
3761733 1945680 1945680 defendant Elen or Glen William yeoman 586749 586749 Elen or Glen, William, of Okeham, yeoman 0
3761734 1945680 1945680 defendant Thorpe John husbandman 586749 586749 Thorpe, John, of Okeham, husbandman 1
3783473 1952582 1952582 plaintiff Plavye William   586749 586749 Plavye, William, of Okeham 1
3790967 1955009 1955009 defendant Archer John yeoman 586749 586749 Archer, John, of Okeham, yeoman 0
3814219 1962352 1962352 defendant Overend Agnes widow 586749 586749 Overend, Agnes, of Okeham, widow 1
3819653 1964026 1964026 defendant Kyng Thomas yeoman 586749 586749 Kyng, Thomas, of Okeham, yeoman 2
3825385 1965790 1965790 defendant Harryson John pewterer 586749 586749 Harryson, John, of Okeham, pewterer 0
3851693 1974117 1974117 defendant Jakson John shoemaker 586749 586749 Jakson, John, of Okeham, shoemaker 0
3865937 1978837 1978837 defendant Lockewood William husbandman 586749 586749 Lockewood, William, of Okeham, husbandman 3
3879979 1983562 1983562 defendant Kyrke John butcher 586749 586749 Kyrke, John, of Okeham, butcher 1
3881689 1984123 1984123 defendant Stampe John yeoman 586749 586749 Stampe, John, of Okeham, yeoman 0
3881690 1984123 1984123 defendant Stampe Thomas husbandman 586749 586749 Stampe, Thomas, of Okeham, husbandman 1
3887732 1986152 1986152 defendant Webster Thomas yeoman 586749 586749 Webster, Thomas, of Okeham, yeoman 0
3915384 1995514 1995514 defendant Glen William yeoman 586749 586749 Glen, William, of Okeham, yeoman 0
3915385 1995514 1995514 defendant Fyrkyll William husbandman 586749 586749 Fyrkyll, William, of Okeham, husbandman 1
3950326 2007196 2007196 plaintiff Fulshawe William   586749 586749 Fulshawe, William, of Okeham 0
3950329 2007196 2007196 defendant Carpenter William, junior husbandman 586749 586749 Carpenter, William, junior, of Okeham, husbandman 1
3973827 2015414 2015414 defendant Humbelton William husbandman 586749 586749 Humbelton, William, of Okeham, husbandman 2
4079424 2052942 2052942 defendant Browne Nicholas shoemaker 586749 586749 Browne, Nicholas, of Okeham, shoemaker 0
4079425 2052942 2052942 defendant Blofold Richard tanner 586749 586749 Blofold, Richard, of Okeham, tanner 1
4157964 2080856 2080856 defendant Greye Robert   586749 586749 Greye, Robert, of Okeham, woollen draper 0
4189254 2091736 2091736 defendant Blofeld Richard tanner 586749 586749 Blofeld, Richard, of Okeham, tanner 0
4215820 2101030 2101030 defendant Shortred William yeoman 586749 586749 Shortred, William, of Okeham, yeoman 0
4217798 2101717 2101717 defendant Gray Simon husbandman 586749 586749 Gray, Simon, of Okeham, butcher, husbandman 0
4219691 2102392 2102392 defendant Gray Simon grasier 586749 586749 Gray, Simon, of Okeham, butcher, grasier 0
4295329 2128414 2128414 defendant Blackburne John yeoman 586749 586749 Blackburne, John, of Okeham, yeoman 1
4310391 2133790 2133790 defendant Graye Robert yeoman 586749 586749 Graye, Robert, of Okeham, yeoman 0
4310613 2133859 2133859 defendant Manxson Roger   586749 586749 Manxson, Roger, of Okeham, tallow chandler 0
4311411 2134133 2134133 defendant Shortred William yeoman 586749 586749 Shortred, William, of Okeham, yeoman 0
4314989 2135354 2135354 defendant Shortred William yeoman 586749 586749 Shortred, William, of Okeham, yeoman 0
4324428 2138564 2138564 defendant Manxson Roger   586749 586749 Manxson, Roger, of Okeham, tallow chandler 0
4324429 2138564 2138564 defendant Bickerton Thomas tailor 586749 586749 Bickerton, Thomas, of Okeham, tailor 1
4329038 2140023 2140023 defendant Thorpe William, junior tailor 586749 586749 Thorpe, William, junior, of Okeham, tailor 0
4332819 2141258 2141258 defendant Manxson Roger   586749 586749 Manxson, Roger, of Okeham, tallow chandler 0
4385058 2159692 2159692 defendant Smyth Roger, junior gent 586749 586749 Smyth, Roger, junior, of Okeham, gent 0
4392361 2162070 2162070 defendant Bestone George yeoman 586749 586749 Bestone, George, of Okeham, yeoman 3
4409877 2167906 2167906 defendant Thorpe Hugh, senior husbandman 586749 586749 Thorpe, Hugh, senior, of Okeham, husbandman 0
4409878 2167906 2167906 defendant Dooffote John sherman 586749 586749 Dooffote, John, of Okeham, sherman 1
4448318 2184398 2184398 plaintiff Flore William   586749 586749 Flore, William, of Okeham, on his own account 0
4452280 2185702 2185702 plaintiff Janecok Thomas   586749 586749 Janecok, Thomas, of Okeham, on his own account 0
4457878 2187485 2187485 plaintiff Porter Thomas   586749 586749 Porter, Thomas, of Okeham 0
4471105 2191624 2191624 defendant Thressher William   586749 586749 Thressher, William, of Okeham 0
4503270 2201589 2201589 defendant Porter Henry   586749 586749 Porter, Henry, of Okeham 0
4515667 2205321 2205321 defendant atte Brook Thomas   586749 586749 atte Brook, Thomas, of Okeham 0
4539633 2212656 2212656 defendant Belton John   586749 586749 Belton, John, of Okeham 0
4539634 2212656 2212656 defendant Leghe Henry   586749 586749 Leghe, Henry, of Okeham 1
4551778 2216502 2216502 defendant Swet Roger   586749 586749 Swet, Roger, of Okeham 0
4551779 2216502 2216502 defendant Leche Richard   586749 586749 Leche, Richard, of Okeham 1
4553191 2216932 2216932 defendant Spencer Ralph   586749 586749 Spencer, Ralph, of Okeham 2
4553193 2216932 2216932 defendant Pykwell John   586749 586749 Pykwell, John, of Okeham 4
4557596 2218310 2218310 defendant Cristyon John   586749 586749 Cristyon, John, of Okeham 0
4559604 2218955 2218955 defendant Pilton Richard   586749 586749 Pilton, Richard, of Okeham 0
4559605 2218955 2218955 defendant Pikwell John   586749 586749 Pikwell, John, of Okeham 1
4559607 2218956 2218956 defendant Pilton Richard   586749 586749 Pilton, Richard, of Okeham 0
4559608 2218956 2218956 defendant Pykwell John   586749 586749 Pykwell, John, of Okeham 1
4559749 2219003 2219003 plaintiff Milner Richard   586749 586749 Milner, Richard, of Okeham 0
4579476 2225059 2225059 plaintiff Cotler Robert   586749 586749 Cotler, Robert, of Okeham 0
4579477 2225059 2225059 defendant Stoke Thomas   586749 586749 Stoke, Thomas, of Okeham 0
4579478 2225060 2225060 plaintiff Cotler Robert   586749 586749 Cotler, Robert, of Okeham 0
4579479 2225060 2225060 defendant Stoke Thomas   586749 586749 Stoke, Thomas, of Okeham 0
4583116 2226140 2226140 plaintiff Flore Roger   586749 586749 Flore, Roger, of Okeham 0
4583117 2226140 2226140 defendant Hyppe Richard   586749 586749 Hyppe, Richard, of Okeham 0
4583118 2226140 2226140 defendant Malkyn Robert   586749 586749 Malkyn, Robert, of Okeham 1
4583120 2226141 2226141 plaintiff Flore Roger   586749 586749 Flore, Roger, of Okeham 0
4592508 2229009 2229009 defendant Malkyn Robert   586749 586749 Malkyn, Robert, of Okeham 1
4597463 2230451 2230451 plaintiff Sherman John   586749 586749 Sherman, John, of Okeham 0
4621420 2237692 2237692 defendant Bene Thomas skinner 586749 586749 Bene, Thomas, of Okeham, skinner 0
4627200 2239453 2239453 defendant Rede John   586749 586749 Rede, John, of Okeham 1
4631606 2240774 2240774 defendant Penfax John merchant 586749 586749 Penfax, John, of Okeham, merchant 0
4646761 2245120 2245120 defendant Rudde John   586749 586749 Rudde, John, of Okeham 2
4647730 2245395 2245395 plaintiff Smyth John fishmonger 586749 586749 Smyth, John, of Okeham, fishmonger 0
4647731 2245395 2245395 defendant Coteler Robert   586749 586749 Coteler, Robert, of Okeham 0
4662190 2249650 2249650 plaintiff Flore Roger   586749 586749 Flore, Roger, of Okeham 0
4670204 2256385 2256385 defendant Elham Richard   586749 586749 Elham, Richard, of Okeham, parchment maker 0
4670572 2256472 2256472 defendant Chapman John chapman 586749 586749 Chapman, John, of Okeham, chapman 1
4680631 2259554 2259554 defendant Colle William husbandman 586749 586749 Colle, William, of Okeham, husbandman 0
4685906 2261183 2261183 defendant Brygg John woolman 586749 586749 Brygg, John, of Okeham, woolman 0
4702022 2266044 2266044 defendant Jakes John   586749 586749 Jakes, John, of Okeham, parchment maker 0
4709792 2268419 2268419 defendant Wryght John husbandman 586749 586749 Wryght, John, of Okeham, husbandman 0
4709793 2268419 2268419 defendant Milner Robert miller 586749 586749 Milner, Robert, of Okeham, miller 1
4716945 2270633 2270633 defendant Attekyn John   586749 586749 Attekyn, John, of Okeham, shoe maker 0
4716946 2270633 2270633 defendant Stanhogh Alexander   586749 586749 Stanhogh, Alexander, of Okeham, shoe maker 1
4723218 2272570 2272570 defendant Eltham Richard husbandman 586749 586749 Eltham, Richard, of Okeham, husbandman 0
4757942 2282861 2282861 defendant Hippe Richard husbandman 586749 586749 Hippe, Richard, of Okeham, husbandman 0
4767485 2285809 2285809 defendant Campe Robert   586749 586749 Campe, Robert, of Okeham, formerly of Barlethorp, Rutland 0
4791861 2293558 2293558 defendant Campe Robert yeoman 586749 586749 Campe, Robert, of Okeham, formerly of Barlethorp, yeoman 0
4792544 2293758 2293758 defendant Smyth Thomas, senior smith 586749 586749 Smyth, Thomas, senior, of Okeham, smith 0
4792545 2293758 2293758 defendant Smyth Thomas, junior smith 586749 586749 Smyth, Thomas, junior, of Okeham, smith 1
4794234 2294335 2294335 defendant Trotter John skinner 586749 586749 Trotter, John, of Okeham, skinner 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);