names

209 rows where place_id = 586249

✎ 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
3588261 1863983 1863983 defendant Ballard Thomas thatcher 586249 586249 Ballard, Thomas, of Est Mallyng, thatcher 0
3607715 1870067 1870067 plaintiff Selby Thomas (legal representative) 586249 586249 Selby, Thomas, of Est Mallyng, administrator of Selby, Robert, executors of 0
3607720 1870068 1870068 plaintiff Selby Thomas (legal representative) 586249 586249 Selby, Thomas, of Est Mallyng, executors of 0
3613780 1871964 1871964 defendant Code William laborer 586249 586249 Code, William, of Est Mallyng, laborer 2
3613824 1871980 1871980 defendant Bacheler Reginald husbandman 586249 586249 Bacheler, Reginald, of Est Mallyng, husbandman 0
3615265 1872420 1872420 defendant Gilian Thomas husbandman 586249 586249 Gilian, Thomas, of Est Mallyng, husbandman 0
3625212 1875421 1875421 defendant Sedde John husbandman 586249 586249 Sedde, John, of Est Mallyng, husbandman 0
3625213 1875421 1875421 defendant Bore John husbandman 586249 586249 Bore, John, of Est Mallyng, husbandman 1
3640533 1907475 1907475 defendant Venor John husbandman 586249 586249 Venor, John, of Est Mallyng, husbandman 0
3659944 1913368 1913368 defendant Terre Nicholas clothier 586249 586249 Terre, Nicholas, of East Mallyng, clothier 0
3670931 1916876 1916876 defendant Holywell alias Smyth John smith 586249 586249 Holywell alias Smyth, John, of Est Mallyng, smith 0
3672105 1917277 1917277 plaintiff Cowherd William tailor 586249 586249 Cowherd, William, of Est Mallyng, tailor 0
3672106 1917277 1917277 plaintiff Mason Edmund tailor 586249 586249 Mason, Edmund, of Est Mallyng, tailor 1
3672107 1917277 1917277 plaintiff Loder Clement husbandman 586249 586249 Loder, Clement, of Est Mallyng, husbandman 2
3672108 1917277 1917277 plaintiff Bechyng John weaver 586249 586249 Bechyng, John, of Est Mallyng, weaver 3
3672116 1917278 1917278 defendant Aldregge John laborer 586249 586249 Aldregge, John, of Est Mallyng, laborer 2
3672117 1917278 1917278 defendant Reson William husbandman 586249 586249 Reson, William, of Est Mallyng, husbandman 3
3672913 1917541 1917541 defendant Hartragge Richard husbandman 586249 586249 Hartragge, Richard, of Est Mallyng, husbandman 1
3675121 1918247 1918247 defendant Cutler John husbandman 586249 586249 Cutler, John, of Est Mallyng, husbandman 4
3675274 1918305 1918305 defendant Colen William laborer 586249 586249 Colen, William, of Est Mallyng, laborer 4
3676178 1918594 1918594 defendant Petman John mariner 586249 586249 Petman, John, of Est Mallyng, mariner 0
3676180 1918594 1918594 defendant Stovers John husbandman 586249 586249 Stovers, John, of Est Mallyng, husbandman 2
3678870 1919457 1919457 defendant Fyssher Thomas tailor 586249 586249 Fyssher, Thomas, of Est Mallyng, tailor 2
3681125 1920178 1920178 defendant Julyan Thomas yeoman 586249 586249 Julyan, Thomas, of Est Mallyng, yeoman 4
3683992 1921125 1921125 defendant Millys Robert (legal representative) 586249 586249 Millys, Robert, of Est Mallyng, gent, executrix of 0
3683993 1921125 1921125 defendant Millys Margaret widow 586249 586249 Millys, Margaret, of Est Mallyng, widow 1
3688892 1922685 1922685 defendant Culter John husbandman 586249 586249 Culter, John, of Est Mallyng, husbandman 0
3690166 1923081 1923081 defendant Mosse Richard (legal representative) 586249 586249 Mosse, Richard, of Est Mallyng, executrix of 2
3690167 1923081 1923081 defendant Mosse Joan widow 586249 586249 Mosse, Joan, of Est Mallyng, widow 3
3695576 1924845 1924845 defendant Terry Nicholas weaver 586249 586249 Terry, Nicholas, of Est Mallyng, weaver 0
3697856 1925550 1925550 defendant Stopersfeld William husbandman 586249 586249 Stopersfeld, William, of Est Mallyng, husbandman 0
3699158 1925948 1925948 defendant Doole John yeoman 586249 586249 Doole, John, of Est Mallyng, yeoman 2
3702007 1926883 1926883 defendant Stopersfelde William husbandman 586249 586249 Stopersfelde, William, of Est Mallyng, husbandman 0
3702009 1926883 1926883 defendant Culter John husbandman 586249 586249 Culter, John, of East Mallyng, husbandman 2
3703466 1927356 1927356 defendant Stopersfelde William husbandman 586249 586249 Stopersfelde, William, of Est Mallyng, husbandman 1
3705847 1928111 1928111 defendant Petman John mariner 586249 586249 Petman, John, of Est Mallyng, mariner 0
3709209 1929176 1929176 defendant Petman John yeoman 586249 586249 Petman, John, of Est Mallyng, yeoman 0
3709210 1929176 1929176 defendant Juliane Richard husbandman 586249 586249 Juliane, Richard, of Est Mallyng, husbandman 1
3713301 1930470 1930470 defendant Culter John husbandman 586249 586249 Culter, John, of Est Mallyng, husbandman 0
3713302 1930470 1930470 defendant Fenner Richard mariner 586249 586249 Fenner, Richard, of Est Mallyng, mariner 1
3715915 1931263 1931263 defendant Catlyn Joyce widow 586249 586249 Catlyn, Joyce, of Est Mallyng, widow 0
3715917 1931264 1931264 defendant Catlyn Joyce widow 586249 586249 Catlyn, Joyce, of Est Mallyng, widow 0
3716240 1931371 1931371 defendant Tunbregge Nicholas pavier 586249 586249 Tunbregge, Nicholas, of Est Mallyng, pavier 0
3716871 1931564 1931564 defendant Tomlyn John, junior yeoman 586249 586249 Tomlyn, John, junior, of Est Mallyng, yeoman 3
3719561 1932383 1932383 defendant Ame Thomas   586249 586249 Ame, Thomas, of Est Mallyng, parish clerk 0
3719957 1932510 1932510 defendant Petman John mariner 586249 586249 Petman, John, of Est Mallyng, mariner 0
3722542 1933310 1933310 defendant Saunder Thomas yeoman 586249 586249 Saunder, Thomas, of Est Mallyng, yeoman 0
3722543 1933310 1933310 defendant Vennar Richard yeoman 586249 586249 Vennar, Richard, of Est Mallyng, yeoman 1
3731860 1936194 1936194 defendant Tomlyn John, junior husbandman 586249 586249 Tomlyn, John, junior, of Est Mallyng, husbandman 0
3732757 1936474 1936474 defendant Petman John mariner 586249 586249 Petman, John, of Est Mallyng, mariner 2
3735555 1937356 1937356 defendant Saunder Thomas husbandman 586249 586249 Saunder, Thomas, of Est Mallyng, husbandman 0
3738267 1938183 1938183 defendant Saunder Thomas yeoman 586249 586249 Saunder, Thomas, of Est Mallyng, yeoman 0
3740034 1938737 1938737 defendant Tomblyn John mariner 586249 586249 Tomblyn, John, of Est Mallyng, mariner 0
3740035 1938737 1938737 defendant Saunder Thomas mariner 586249 586249 Saunder, Thomas, of Est Mallyng, mariner 1
3746907 1940949 1940949 defendant Petman John mariner 586249 586249 Petman, John, of Est Mallyng, mariner 2
3761609 1945645 1945645 defendant Stevenson William yeoman 586249 586249 Stevenson, William, of Est Mallyng, yeoman 0
3761610 1945645 1945645 defendant Style John shoemaker 586249 586249 Style, John, of Est Mallyng, shoemaker 1
3761611 1945645 1945645 defendant Hykmote Nicholas shoemaker 586249 586249 Hykmote, Nicholas, of Est Mallyng, shoemaker 2
3763362 1946168 1946168 defendant Ame Thomas weaver 586249 586249 Ame, Thomas, of Est Mallyng, weaver 4
3764203 1946456 1946456 defendant Mathewson John husbandman 586249 586249 Mathewson, John, of Est Mallyng, husbandman 0
3768940 1947938 1947938 defendant Ame Thomas weaver 586249 586249 Ame, Thomas, of Est Mallyng, weaver 1
3768941 1947938 1947938 defendant Dowle John weaver 586249 586249 Dowle, John, of Est Mallyng, weaver 2
3769275 1948044 1948044 defendant Broke John husbandman 586249 586249 Broke, John, of Est Mallyng, husbandman 2
3773558 1949441 1949441 defendant Hartrige Richard innholder 586249 586249 Hartrige, Richard, of Est Mallyng, innholder 0
3773576 1949447 1949447 defendant Hartrige Richard innholder 586249 586249 Hartrige, Richard, of Est Mallyng, innholder 0
3778995 1951152 1951152 defendant Mason Edmund tailor 586249 586249 Mason, Edmund, of Est Mallyng, tailor 0
3782178 1952178 1952178 defendant Hertregge Richard yeoman 586249 586249 Hertregge, Richard, of Est Mallyng, yeoman 2
3782184 1952179 1952179 defendant Petman John mariner 586249 586249 Petman, John, of Est Mallyng, mariner 3
3782187 1952180 1952180 defendant Mathewson John husbandman 586249 586249 Mathewson, John, of Est Mallyng, husbandman 0
3782710 1952335 1952335 defendant Hartrege Richard yeoman 586249 586249 Hartrege, Richard, of Est Mallyng, yeoman 0
3786381 1953526 1953526 defendant Loder Clement weaver 586249 586249 Loder, Clement, of Est Mallyng, weaver 1
3790804 1954949 1954949 defendant Claygaet Geoffrey tailor 586249 586249 Claygaet, Geoffrey, of Est Mallyng, tailor 3
3790809 1954950 1954950 defendant Claygatt Geoffrey tailor 586249 586249 Claygatt, Geoffrey, of Est Mallyng, tailor 2
3792785 1955594 1955594 defendant Broke John husbandman 586249 586249 Broke, John, of East Mallyng, husbandman 0
3794166 1956045 1956045 defendant Stopersfeld William husbandman 586249 586249 Stopersfeld, William, of Est Mallyng, husbandman 0
3794417 1956130 1956130 defendant Terry John   586249 586249 Terry, John, of Est Mallyng, rope maker 1
3795157 1956350 1956350 defendant Reason William weaver 586249 586249 Reason, William, of Est Mallyng, weaver 2
3795520 1956479 1956479 defendant Mosse John yeoman 586249 586249 Mosse, John, of Est Mallyng, yeoman 0
3820172 1964188 1964188 defendant Loder Clement weaver 586249 586249 Loder, Clement, of Est Mallyng, weaver 1
3824673 1965590 1965590 defendant Tunbrygge James   586249 586249 Tunbrygge, James, of Est Mallyng, tallow chandler 4
3828370 1966747 1966747 defendant Hallywelle John smith 586249 586249 Hallywelle, John, of East Mallyng, smith 1
3828371 1966747 1966747 defendant Harterege Richard yeoman 586249 586249 Harterege, Richard, of East Mallyng, yeoman 2
3828874 1966910 1966910 defendant Fennar Richard mariner 586249 586249 Fennar, Richard, of Est Mallyng, mariner 0
3828875 1966910 1966910 defendant Millys John roper 586249 586249 Millys, John, of Est Mallyng, roper 1
3829400 1967083 1967083 defendant Nele Nicholas husbandman 586249 586249 Nele, Nicholas, of Est Mallyng, husbandman 1
3829404 1967084 1967084 defendant Nele Nicholas husbandman 586249 586249 Nele, Nicholas, of Est Mallyng, husbandman 1
3847814 1972893 1972893 defendant Braunche John mariner 586249 586249 Braunche, John, of Est Mallyng, mariner 0
3847816 1972894 1972894 defendant Roger Richard   586249 586249 Roger, Richard, of Est Mallyng, shipwright 0
3854255 1974967 1974967 defendant Rose Julia widow 586249 586249 Rose, Julia, of Est Mallyng, widow 0
3857454 1975967 1975967 plaintiff at Wode Lawrence   586249 586249 at Wode, Lawrence, of Est Mallyng 0
3859285 1976598 1976598 defendant Carter John (legal representative) 586249 586249 Carter, John, of Est Mallyng, husbandman, executors of 0
3859286 1976598 1976598 defendant Regeman Thomas yeoman 586249 586249 (Regeman, Thomas, of Est Mallyng, yeoman 1
3859806 1976780 1976780 defendant Harterege Richard yeoman 586249 586249 Harterege, Richard, of Est Mallyng, yeoman 1
3862496 1977651 1977651 defendant Braunche John mariner 586249 586249 Braunche, John, of Est Mallyng, mariner 0
3863106 1977860 1977860 defendant Braunche John mariner 586249 586249 Braunche, John, of Est Mallyng, mariner 0
3865405 1978644 1978644 defendant Julyan Richard husbandman 586249 586249 Julyan, Richard, of Est mallyng, husbandman 0
3877298 1982650 1982650 defendant Herthrop Richard husbandman 586249 586249 Herthrop, Richard, of Est Mallyng, husbandman 0
3877299 1982650 1982650 defendant Thomas John laborer 586249 586249 Thomas, John, of Est Mallyng, laborer 1
3878579 1983082 1983082 defendant Sompner Stephen shingler 586249 586249 Sompner, Stephen, of Est Mallyng, shingler 0
3879403 1983364 1983364 defendant Julian alias Jevane Richard husbandman 586249 586249 Julian alias Jevane, Richard, of Est Mallyng, husbandman 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);