names

159 rows where place_id = 594871

✎ 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
3617914 1873227 1873227 defendant Newe John tailor 594871 594871 Newe, John, of Devyses, tailor 0
3617949 1873239 1873239 defendant Botley John (legal representative) 594871 594871 Botley, John, of Devyses, executors of 0
3617951 1873239 1873239 defendant Botley William glover 594871 594871 Botley, William, of Devyses, glover 2
3764642 1946603 1946603 defendant Knyght Robert clothier 594871 594871 Knyght, Robert, of Devyses, clothier 2
3776410 1950376 1950376 defendant Cardyff John baker 594871 594871 Cardyff, John, of Devyses, baker 0
3820832 1964407 1964407 plaintiff Rede Thomas (legal representative) 594871 594871 Rede, Thomas, of Devyses, clothier, executors of 0
3860790 1977100 1977100 defendant Noryngton John clothman 594871 594871 Noryngton, John, of Devyses, clothman 0
3869052 1979895 1979895 defendant Stompe Thomas husbandman 594871 594871 Stompe, Thomas, of Devyses, husbandman 0
3896551 1989052 1989052 defendant Woodman Alice widow 594871 594871 Woodman, Alice, of Devyses, widow 1
3920277 1997118 1997118 defendant Spryngall John brewer 594871 594871 Spryngall, John, of Devyses, brewer 0
3923446 1998147 1998147 defendant Hasselambe Hugh merchant 594871 594871 Hasselambe, Hugh, of Devyses, merchant 0
3967921 2013408 2013408 defendant Stephen Morgan   594871 594871 Stephen, Morgan, of Devyses, card maker 1
3978252 2016977 2016977 defendant Farre Roger mercer 594871 594871 Farre, Roger, of Devyses, mercer 0
3978285 2016987 2016987 defendant Maundrell Richard yeoman 594871 594871 Maundrell, Richard, of Devyses, yeoman 0
3978296 2016992 2016992 defendant Sweper William butcher 594871 594871 Sweper, William, of Devyses, butcher 0
4007798 2027571 2027571 defendant Cley Phinch mercer 594871 594871 Cley, Phinch, of Devyses, mercer 0
4083796 2054479 2054479 defendant Potter John shoemaker 594871 594871 Potter, John, of Devyses, shoemaker 0
4447640 2184183 2184183 defendant Muleward John   594871 594871 Muleward, John, of Devyses 0
4455447 2186706 2186706 plaintiff Milleward John   594871 594871 Milleward, John, of Devyses 0
4455914 2186866 2186866 defendant Buchard John tanner 594871 594871 Buchard, John, of Devyses, tanner 2
4455915 2186866 2186866 defendant Love John   594871 594871 Love, John, of Devyses 3
4455926 2186869 2186869 plaintiff Mulleward John   594871 594871 Mulleward, John, of Devyses 0
4459431 2188001 2188001 plaintiff Ryngesbourne William   594871 594871 Ryngesbourne, William, of Devyses 0
4490851 2197837 2197837 plaintiff Webbe Henry   594871 594871 Webbe, Henry, of Devyses 0
4537687 2212060 2212060 defendant Sadeler John   594871 594871 Sadeler, John, of Devyses 0
4614856 2235651 2235651 defendant Sompnour William   594871 594871 Sompnour, William, of Devyses 1
4614857 2235651 2235651 defendant Broghton Joan   594871 594871 Broghton, Joan, of Devyses 2
4615327 2235802 2235802 defendant Shether William   594871 594871 Shether, William, of Devyses 2
4620215 2237303 2237303 defendant Spenser William   594871 594871 Spenser, William, of Devyses 0
4628665 2239889 2239889 defendant Irmonger Peter frenchman 594871 594871 Irmonger, Peter, of Devyses, frenchman 1
4628667 2239889 2239889 defendant Pateney John tailor 594871 594871 Pateney, John, of Devyses, tailor 3
4629106 2240028 2240028 plaintiff Skynnere Simon   594871 594871 Skynnere, Simon, of Devyses 0
4629108 2240028 2240028 plaintiff Gylbard John   594871 594871 Gylbard, John, of Devyses 2
4646424 2245018 2245018 defendant Rendeway John   594871 594871 Rendeway, John, of Devyses 0
4652191 2246626 2246626 defendant Brewere John butcher 594871 594871 Brewere, John, of Devyses, butcher 0
4653740 2247093 2247093 defendant Renewhey or Revewhey John   594871 594871 Renewhey or Revewhey, John, of Devyses, net maker 2
4656363 2247882 2247882 defendant Kynggeston John wheeler 594871 594871 Kynggeston, John, of Devyses, wheeler 0
4656440 2247909 2247909 defendant Stafford John tanner 594871 594871 Stafford, John, of Devyses, tanner 0
4658445 2248522 2248522 plaintiff Coventre John   594871 594871 Coventre, John, of Devyses 0
4677048 2258437 2258437 plaintiff Gyllard John   594871 594871 Gyllard, John, of Devyses 0
4677049 2258437 2258437 defendant Smyth William weaver & son of Robert Smyth 594871 594871 Smyth, William, of Devyses, weaver & son of Robert Smyth 0
4685898 2261181 2261181 defendant Sadeler John sadler 594871 594871 Sadeler, John, of Devyses, sadler 0
4742637 2278350 2278350 defendant Ferrour William smith 594871 594871 Ferrour, William, of Devyses, smith 0
4770908 2286879 2286879 defendant Scarlet Thomas   594871 594871 Scarlet, Thomas, of Devyses, bailiff 0
4780631 2289941 2289941 defendant Hosyer Richard hosier 594871 594871 Hosyer, Richard, of Devyses, hosier 0
4782735 2290617 2290617 plaintiff Coventry John merchant 594871 594871 Coventry, John, of Devyses, merchant 0
4783249 2290779 2290779 defendant Scarlet Thomas husbandman 594871 594871 Scarlet, Thomas, of Devyses, husbandman 1
4796175 2294955 2294955 defendant Coventre Thomas merchant 594871 594871 Coventre, Thomas, of Devyses, merchant 0
4796176 2294955 2294955 defendant Cove or Cone John, senior merchant 594871 594871 Cove or Cone, John, senior, of Devyses, merchant 1
4796177 2294955 2294955 defendant Coventre William merchant 594871 594871 Coventre, William, of Devyses, merchant 2
4801039 2296514 2296514 defendant Goldsmyth Thomas goldsmith 594871 594871 Goldsmyth, Thomas, of Devyses, goldsmith 0
4804874 2297727 2297727 defendant Warner Robert husbandman 594871 594871 Warner, Robert, of Devyses, husbandman 1
4820778 2302576 2302576 defendant Eton Robert chandler 594871 594871 Eton, Robert, of Devyses, chandler 0
4820779 2302576 2302576 defendant Bremesgrove William merchant 594871 594871 Bremesgrove, William, of Devyses, merchant 1
4831461 2305871 2305871 plaintiff Smyth William   594871 594871 Smyth, William, of Devyses 2
4834394 2306763 2306763 defendant Skynner John skinner 594871 594871 Skynner, John, of Devyses, skinner 3
4834395 2306763 2306763 defendant Flour Thomas baker 594871 594871 Flour, Thomas, of Devyses, baker 4
4853071 2312379 2312379 defendant Baker John chapman 594871 594871 Baker, John, of Devyses, chapman 0
4871968 2318212 2318212 defendant Barbour Thomas barber 594871 594871 Barbour, Thomas, of Devyses, barber 0
4880653 2320859 2320859 defendant Smyth William merchant 594871 594871 Smyth, William, of Devyses, merchant 0
4898365 2326144 2326144 defendant Curteys John smith 594871 594871 Curteys, John, of Devyses, smith 2
4899152 2326378 2326378 defendant Whitborn Thomas tucker 594871 594871 Whitborn, Thomas, of Devyses, tucker 2
4901567 2327089 2327089 defendant Smyth Thomas smith 594871 594871 Smyth, Thomas, of Devyses, smith 3
4901568 2327089 2327089 defendant Gurley William butcher 594871 594871 Gurley, William, of Devyses, butcher 4
4914193 2330954 2330954 plaintiff Coventre John   594871 594871 Coventre, John, of Devyses, son of John Coventre 0
4914218 2330962 2330962 plaintiff Coventre John   594871 594871 Coventre, John, of Devyses 1
4927874 2335154 2335154 plaintiff Selwode William merchant 594871 594871 Selwode, William, of Devyses, merchant 0
4934918 2337324 2337324 defendant Hode John yeoman 594871 594871 Hode, John, of Devyses, yeoman 1
4955974 2343753 2343753 plaintiff Touker Richard   594871 594871 Touker, Richard, of Devyses 0
4955975 2343753 2343753 defendant Brasyer Hugh mercer 594871 594871 Brasyer, Hugh, of Devyses, mercer 0
4955976 2343753 2343753 defendant Carpenter Robert chaplain 594871 594871 Carpenter, Robert, of Devyses, chaplain 1
4957735 2344287 2344287 defendant Ussher John yeoman 594871 594871 Ussher, John, of Devyses, yeoman 3
4960255 2345041 2345041 defendant Hede William tailor 594871 594871 Hede, William, of Devyses, tailor 3
4969942 2347959 2347959 defendant Bradeford Robert hosier 594871 594871 Bradeford, Robert, of Devyses, hosier 0
4973859 2349139 2349139 defendant Ismel Robert merchant 594871 594871 Ismel, Robert, of Devyses, merchant 0
4973860 2349139 2349139 defendant Coventre Thomas merchant 594871 594871 Coventre, Thomas, of Devyses, merchant 1
4991974 2354487 2354487 plaintiff Coventre John merchant 594871 594871 Coventre, John, of Devyses, merchant 0
4991976 2354487 2354487 defendant Harry Thomas mercer 594871 594871 Harry, Thomas, of Devyses, mercer 1
5028474 2365200 2365200 defendant Bowyer Henry weaver 594871 594871 Bowyer, Henry, of Devyses, weaver 1
5032407 2366359 2366359 defendant Henlowe Robert husbandman 594871 594871 Henlowe, Robert, of Devyses, husbandman 0
5034894 2367062 2367062 defendant Croke Thomas pardoner 594871 594871 Croke, Thomas, of Devyses, pardoner 2
5037804 2367935 2367935 defendant Taylloure William tailor 594871 594871 Taylloure, William, of Devyses, tailor 2
5066070 2376376 2376376 defendant Ismell Robert merchant 594871 594871 Ismell, Robert, of Devyses, merchant 0
5066435 2376489 2376489 defendant Warner Robert yeoman 594871 594871 Warner, Robert, of Devyses, yeoman 0
5066436 2376489 2376489 defendant Warner John weaver 594871 594871 Warner, John, of Devyses, weaver 1
5068380 2377042 2377042 defendant Brewer alias Cuffe or Cusse Nicholas butcher 594871 594871 Brewer alias Cuffe or Cusse, Nicholas, of Devyses, butcher 0
5072697 2378319 2378319 defendant Henlowe William draper 594871 594871 Henlowe, William, of Devyses, draper 0
5072698 2378319 2378319 defendant Raynold Thomas draper 594871 594871 Raynold, Thomas, of Devyses, draper 1
5072699 2378319 2378319 defendant Nasshe William weaver 594871 594871 Nasshe, William, of Devyses, weaver 2
5082468 2381256 2381256 defendant Huchecok William weaver 594871 594871 Huchecok, William, of Devyses, weaver 2
5094693 2384863 2384863 defendant Tarry Walter husbandman 594871 594871 Tarry, Walter, of Devyses, husbandman 0
5094694 2384863 2384863 defendant Bouke or Bonke William weaver 594871 594871 Bouke or Bonke, William, of Devyses, weaver 1
5094695 2384863 2384863 defendant Gray John tanner 594871 594871 Gray, John, of Devyses, tanner 2
5098192 2385900 2385900 defendant Haukyns Thomas cordwainer 594871 594871 Haukyns, Thomas, of Devyses, cordwainer 9
5098992 2386135 2386135 defendant Cley Thomas cordwainer 594871 594871 Cley, Thomas, of Devyses, cordwainer 0
5098993 2386135 2386135 defendant Story John fisher 594871 594871 Story, John, of Devyses, fisher 1
5102053 2387025 2387025 defendant Corbet William weaver 594871 594871 Corbet, William, of Devyses, weaver 3
5102054 2387025 2387025 defendant Dyker John laborer 594871 594871 Dyker, John, of Devyses, laborer 4
5115028 2390812 2390812 plaintiff Mere Nicholas clothmaker 594871 594871 Mere, Nicholas, of Devyses, clothmaker 0
5115029 2390812 2390812 defendant Smyth Thomas gent 594871 594871 Smyth, Thomas, of Devyses, gent 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);