names

83 rows where place_id = 592910

✎ 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
3609344 1870583 1870583 defendant Hopkynson William clerk 592910 592910 Hopkynson, William, of Wath, clerk 0
3625239 1875430 1875430 plaintiff West Robert   592910 592910 West, Robert, of Wath 0
3629352 1904040 1904040 plaintiff Crescy John gent 592910 592910 Crescy, John, of Wath, gent 0
3665671 1915212 1915212 defendant Crokeld Thomas husbandman 592910 592910 Crokeld, Thomas, of Wath, husbandman 0
3689324 1922825 1922825 defendant Colynson Ralph yeoman 592910 592910 Colynson, Ralph, of Wath, yeoman 1
3691027 1923358 1923358 defendant West Thomas   592910 592910 West, Thomas, of Wath 0
3691028 1923358 1923358 defendant Crokyll Thomas husbandman 592910 592910 Crokyll, Thomas, of Wath, husbandman 1
3699237 1925973 1925973 defendant Crescy Joan widow 592910 592910 Crescy, Joan, of Wath, widow 0
3700940 1926540 1926540 defendant West Thomas gent 592910 592910 West, Thomas, of Wath, gent 0
3709337 1929217 1929217 defendant Tunstall Richard laborer 592910 592910 Tunstall, Richard, of Wath, laborer 0
3712747 1930302 1930302 defendant Cressy Joan widow 592910 592910 Cressy, Joan, of Wath, widow 0
3713332 1930483 1930483 defendant Bacon Robert yeoman 592910 592910 Bacon, Robert, of Wath, yeoman 0
3742243 1939443 1939443 defendant Bacon Robert yeoman 592910 592910 Bacon, Robert, of Wath, yeoman 0
3749955 1941904 1941904 defendant Colynson Ralph gent 592910 592910 Colynson, Ralph, of Wath, gent 1
3779423 1951287 1951287 defendant Wade John husbandman 592910 592910 Wade, John, of Wath, husbandman 0
3809164 1960748 1960748 defendant Lightfoytt John chaplain 592910 592910 Lightfoytt, John, of Wath, chaplain 0
3824352 1965486 1965486 defendant Taylour John husbandman 592910 592910 Taylour, John, of Wath, husbandman 0
3855787 1975441 1975441 defendant Brodbent John smith 592910 592910 Brodbent, John, of Wath, smith 0
3870101 1980243 1980243 defendant Colynson Ralph gent 592910 592910 Colynson, Ralph, of Wath, gent 1
3930181 2000440 2000440 plaintiff Colenson Katherine widow 592910 592910 Colenson, Katherine, of Wath, widow 0
4113726 2065192 2065192 defendant Hanson Thomas yeoman 592910 592910 Hanson, Thomas, of Wath, yeoman 3
4124554 2069077 2069077 defendant Hanson Edmund husbandman 592910 592910 Hanson, Edmund, of Wath, husbandman 0
4124555 2069077 2069077 defendant Wright Alvered husbandman 592910 592910 Wright, Alvered, of Wath, husbandman 1
4124556 2069077 2069077 defendant Hanson Edward husbandman 592910 592910 Hanson, Edward, of Wath, husbandman 2
4186256 2090677 2090677 defendant Mallynson Thomas laborer 592910 592910 Mallynson, Thomas, of Wath, laborer 1
4319383 2136886 2136886 defendant Fixbie Roger husbandman 592910 592910 Fixbie, Roger, of Wath, husbandman 1
4321607 2137646 2137646 defendant Barnes Richard yeoman 592910 592910 Barnes, Richard, of Wath, yeoman 2
4458873 2187820 2187820 defendant Stele John   592910 592910 Stele, John, of Wath 1
4465308 2189822 2189822 defendant Walkere William   592910 592910 Walkere, William, of Wath 0
4504135 2201845 2201845 plaintiff Ranyerd Thomas   592910 592910 Ranyerd, Thomas, of Wath, parson, administrators of 0
4510662 2203792 2203792 plaintiff Barton Richard de   592910 592910 Barton, Richard de, of Wath 0
4510664 2203792 2203792 defendant Anable William   592910 592910 Anable, William, of Wath 1
4528448 2209177 2209177 defendant Appelby John   592910 592910 Appelby, John, of Wath, parson 0
4545811 2214619 2214619 defendant Bailly Robert   592910 592910 Bailly, Robert, of Wath 0
4559042 2218788 2218788 plaintiff Quynton Richard de   592910 592910 (Quynton, Richard de, of Wath, parson 1
4563019 2219999 2219999 plaintiff Quynton Richard de   592910 592910 Quynton, Richard de, of Wath, parson 0
4570392 2222314 2222314 defendant Hunter Roger   592910 592910 Hunter, Roger, of Wath 0
4574848 2223659 2223659 defendant Wode John   592910 592910 Wode, John, of Wath 3
4592494 2229004 2229004 defendant Owenton Richard de   592910 592910 Owenton, Richard de, of Wath, parson 0
4608318 2233712 2233712 defendant Pulforth John   592910 592910 Pulforth, John, of Wath 0
4608319 2233712 2233712 defendant Beton Peter   592910 592910 Beton, Peter, of Wath 1
4660298 2249051 2249051 defendant Pulforth John yeoman 592910 592910 Pulforth, John, of Wath, yeoman 0
4705877 2267214 2267214 defendant Tille John yeoman 592910 592910 Tille, John, of Wath, yeoman 0
4773952 2287835 2287835 plaintiff Toveton Thomas   592910 592910 Toveton, Thomas, of Wath, parson 0
4809419 2299122 2299122 defendant Coke William husbandman 592910 592910 Coke, William, of Wath, husbandman 1
4809421 2299122 2299122 defendant Bocher John butcher 592910 592910 Bocher, John, of Wath, butcher 3
4809953 2299273 2299273 defendant Frankyssh John husbandman 592910 592910 Frankyssh, John, of Wath, husbandman 1
4831127 2305767 2305767 defendant Corbryg John yeoman 592910 592910 Corbryg, John, of Wath, yeoman 0
4858080 2313897 2313897 defendant Corbryge John yeoman 592910 592910 Corbryge, John, of Wath, yeoman 0
4954320 2343262 2343262 defendant Pereson William husbandman 592910 592910 Pereson, William, of Wath, husbandman 4
4954357 2343271 2343271 defendant Strafford Robert husbandman 592910 592910 Strafford, Robert, of Wath, husbandman 0
5034427 2366929 2366929 defendant Waldman Thomas husbandman 592910 592910 Waldman, Thomas, of Wath, husbandman 2
5073853 2378668 2378668 defendant Hunte Joan widow 592910 592910 Hunte, Joan, of Wath, widow 2
5104870 2387861 2387861 defendant Flemmyng William esq 592910 592910 Flemmyng, William, of Wath, esq 0
5105164 2387949 2387949 defendant Flemmyng William esq 592910 592910 Flemmyng, William, of Wath, esq 0
5108737 2388993 2388993 defendant Tynley Robert yeoman 592910 592910 Tynley, Robert, of Wath, yeoman 0
5113493 2390333 2390333 defendant Ive William husbandman 592910 592910 Ive, William, of Wath, husbandman 0
5150311 2401223 2401223 defendant Cressy Thomas   592910 592910 Cressy, Thomas, of Wath, servant 2
5150319 2401224 2401224 defendant Cressy Thomas   592910 592910 Cressy, Thomas, of Wath, servant 2
5177804 2409211 2409211 defendant Pierson Idonea   592910 592910 Pierson, Idonea, of Wath, widow, formerly wife of William 0
5217585 2420883 2420883 defendant Flemmyng Anne widow 592910 592910 Flemmyng, Anne, of Wath, widow 0
5234185 2425588 2425588 defendant Flemmyng William gent 592910 592910 Flemmyng, William, of Wath, gent 3
5263097 2434201 2434201 defendant Robyns Robert miller 592910 592910 Robyns, Robert, of Wath, miller 0
5271682 2436818 2436818 defendant Flemmyng William esq 592910 592910 Flemmyng, William, of Wath, esq 0
5282882 2440054 2440054 defendant Flemmyng William esq 592910 592910 Flemmyng, William, of Wath, esq 0
5339724 2457000 2457000 defendant Tharold John husbandman 592910 592910 Tharold, John, of Wath, husbandman 0
5384124 2470550 2470550 plaintiff Baton Richard   592910 592910 Baton, Richard, of Wath 0
5407105 2477092 2477092 defendant Jamys John laborer 592910 592910 Jamys, John, of Wath, laborer 3
5439891 2486877 2486877 plaintiff West Robert   592910 592910 West, Robert, of Wath 0
5459060 2492606 2492606 defendant Wystowe John yeoman 592910 592910 Wystowe, John, of Wath, yeoman 0
5478336 2498547 2498547 defendant Nicholson John clerk 592910 592910 Nicholson, John, of Wath, clerk 0
5478338 2498548 2498548 defendant Nicholson John clerk 592910 592910 Nicholson, John, of Wath, clerk 0
5584379 2530178 2530178 defendant Strafford John husbandman 592910 592910 Strafford, John, of Wath, husbandman 0
5584380 2530178 2530178 defendant Strafford Robert husbandman 592910 592910 Strafford, Robert, of Wath, husbandman 1
5584381 2530178 2530178 defendant Fawkes John   592910 592910 Fawkes, John, of Wath, parish clerk 2
5584695 2530285 2530285 defendant Bacon Robert yeoman 592910 592910 Bacon, Robert, of Wath, yeoman 0
5599813 2534830 2534830 defendant West Robert yeoman 592910 592910 West, Robert, of Wath, yeoman 0
5599814 2534830 2534830 defendant Clerke Richard laborer 592910 592910 Clerke, Richard, of Wath, laborer 1
5599815 2534830 2534830 defendant Pigot Thomas husbandman 592910 592910 Pigot, Thomas, of Wath, husbandman 2
5599816 2534830 2534830 defendant Pudsey William husbandman 592910 592910 Pudsey, William, of Wath, husbandman 3
5599817 2534830 2534830 defendant Strafford John husbandman 592910 592910 Strafford, John, of Wath, husbandman 4
5599818 2534830 2534830 defendant Strafford Robert husbandman 592910 592910 Strafford, Robert, of Wath, husbandman 5
5599819 2534830 2534830 defendant Hawme Robert husbandman 592910 592910 Hawme, Robert, of Wath, husbandman 6

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);