names

41 rows where place_id = 594918

✎ 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
3618136 1873297 1873297 defendant Alyn Richard glover 594918 594918 Alyn, Richard, of Kyrdeford, glover 0
3665704 1915222 1915222 defendant Wade Richard husbandman 594918 594918 Wade, Richard, of Kyrdeford, husbandman 0
3674170 1917960 1917960 defendant Strodwyke John glasier 594918 594918 Strodwyke, John, of Kyrdeford, glasier 1
3704694 1927754 1927754 defendant Trybe or Tryve Nicholas husbandman 594918 594918 Trybe or Tryve, Nicholas, of Kyrdeford, husbandman 4
3718690 1932125 1932125 defendant Trye Nicholas husbandman 594918 594918 Trye, Nicholas, of Kyrdeford, husbandman 4
3718696 1932126 1932126 defendant Trybe Nicholas husbandman 594918 594918 Trybe, Nicholas, of Kyrdeford, husbandman 4
3766919 1947318 1947318 defendant Strodewyke John, senior yeoman 594918 594918 Strodewyke, John, senior, of Kyrdeford, yeoman 1
3778852 1951100 1951100 defendant Humfrey Edward yeoman 594918 594918 Humfrey, Edward, of Kyrdeford, yeoman 0
3783855 1952721 1952721 defendant Mylle John yeoman 594918 594918 Mylle, John, of Kyrdeford, yeoman 0
3783857 1952722 1952722 defendant Mylle John yeoman 594918 594918 Mylle, John, of Kyrdeford, yeoman 0
3783859 1952723 1952723 defendant Strodewyk Henry yeoman 594918 594918 Strodewyk, Henry, of Kyrdeford, yeoman 0
3797837 1957219 1957219 defendant Broker Henry weaver 594918 594918 Broker, Henry, of Kyrdeford, weaver 0
3810381 1961137 1961137 defendant Strudwyle John, junior glazier 594918 594918 Strudwyle, John, junior, of Kyrdeford, glazier 1
3820520 1964303 1964303 defendant Hole Richard husbandman 594918 594918 Hole, Richard, of Kyrdeford, husbandman 0
3823632 1965289 1965289 defendant Strodewyke John, junior galsier 594918 594918 Strodewyke, John, junior, of Kyrdeford, galsier 0
3866273 1978948 1978948 defendant Strudewyke alias Rumwold John   594918 594918 Strudewyke alias Rumwold, John, of Kyrdeford, glass carrier 0
3923864 1998291 1998291 plaintiff Strodwyke Henry yeoman 594918 594918 Strodwyke, Henry, of Kyrdeford, yeoman 0
3923866 1998292 1998292 plaintiff Strodwyke Henry yeoman 594918 594918 Strodwyke, Henry, of Kyrdeford, yeoman 0
3923868 1998293 1998293 plaintiff Strodwyke Henry yeoman 594918 594918 Strodwyke, Henry, of Kyrdeford, yeoman 0
4132164 2071815 2071815 defendant Strudwicke William yeoman 594918 594918 Strudwicke, William, of Kyrdeford, yeoman 0
4680450 2259498 2259498 defendant Barkefold John husbndman 594918 594918 Barkefold, John, of Kyrdeford, husbndman 2
4680451 2259498 2259498 defendant Seriant Richard laborer 594918 594918 Seriant, Richard, of Kyrdeford, laborer 3
4749507 2280336 2280336 defendant Wasshail William husbandman 594918 594918 Wasshail, William, of Kyrdeford, husbandman 0
4895232 2325168 2325168 defendant Phylip William husbandman 594918 594918 Phylip, William, of Kyrdeford, husbandman 0
4981611 2351415 2351415 defendant Bocher John clothier 594918 594918 Bocher, John, of Kyrdeford, clothier 0
5000265 2356954 2356954 defendant Palshudde Richard husbandman 594918 594918 Palshudde, Richard, of Kyrdeford, husbandman 0
5021031 2363048 2363048 defendant Hybernowe Richard husbandman 594918 594918 Hybernowe, Richard, of Kyrdeford, husbandman 1
5022941 2363619 2363619 defendant Wassell Thomas husbandman 594918 594918 Wassell, Thomas, of Kyrdeford, husbandman 0
5034679 2366999 2366999 defendant Mechewyk Idonia widow 594918 594918 (Mechewyk, Idonia, of Kyrdeford, widow 2
5034680 2366999 2366999 defendant Mechewyk John, junior husbandman 594918 594918 Mechewyk, John, junior, of Kyrdeford, husbandman 3
5034681 2367000 2367000 plaintiff Strodewyk Richard (legal representative) 594918 594918 Strodewyk, Richard, of Kyrdeford, executors of 0
5034686 2367001 2367001 plaintiff Strodewyk Richard (legal representative) 594918 594918 Strodewyk, Richard, of Kyrdeford, executors of 0
5064745 2375995 2375995 defendant Fordyn Robert husbandman 594918 594918 Fordyn, Robert, of Kyrdeford, husbandman 0
5064746 2375995 2375995 defendant Grenestrete Thomas husbandman 594918 594918 Grenestrete, Thomas, of Kyrdeford, husbandman 1
5113876 2390448 2390448 defendant Jotyn Thomas husbandman 594918 594918 Jotyn, Thomas, of Kyrdeford, husbandman 0
5125471 2393934 2393934 defendant Machewyk John husbandman & glasyer or glass maker 594918 594918 Machewyk, John, of Kyrdeford, husbandman & glasyer or glass maker 0
5289684 2441985 2441985 defendant Grenstrete Thomas husbandman 594918 594918 Grenstrete, Thomas, of Kyrdeford, husbandman 1
5390749 2472417 2472417 defendant Cheseman John, junior husbandman 594918 594918 Cheseman, John, junior, of Kyrdeford, husbandman 0
5442821 2487766 2487766 defendant Grenstede Thomas husbandman 594918 594918 Grenstede, Thomas, of Kyrdeford, husbandman 3
5523067 2512039 2512039 defendant Umfrey Richard husbandman 594918 594918 Umfrey, Richard, of Kyrdeford, husbandman 3
5529090 2513614 2513614 defendant Magewike Richard yeoman 594918 594918 Magewike, Richard, of Kyrdeford, yeoman 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);