names

70 rows where place_id = 614922

✎ 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
3706277 1928251 1928251 defendant Metcalff Leonard laborer 614922 614922 Metcalff, Leonard, of Swynton, laborer 0
3713336 1930485 1930485 defendant Hunt Robert yeoman 614922 614922 Hunt, Robert, of Swynton, yeoman 0
3751600 1942415 1942415 defendant Hobson Thomas yeoman 614922 614922 Hobson, Thomas, of Swynton, yeoman 0
3767962 1947616 1947616 defendant Hobson Thomas yeoman 614922 614922 Hobson, Thomas, of Swynton, yeoman 0
3778565 1951008 1951008 defendant Mankyn William laborer 614922 614922 Mankyn, William, of Swynton, laborer 0
3785493 1953252 1953252 defendant Staceley Alan gent 614922 614922 Staceley, Alan, of Swynton, gent 0
3809387 1960818 1960818 defendant Coyll William draper 614922 614922 Coyll, William, of Swynton, draper 2
3819452 1963968 1963968 defendant Staveley Alan gent 614922 614922 Staveley, Alan, of Swynton, gent 0
3851789 1974148 1974148 defendant Sheperd Thomas yeoman 614922 614922 Sheperd, Thomas, of Swynton, yeoman 0
3897176 1989274 1989274 defendant Hunt William husbandman 614922 614922 Hunt, William, of Swynton, husbandman 0
4025689 2033839 2033839 defendant Bromhede Edward yeoman 614922 614922 Bromhede, Edward, of Swynton, yeoman 0
4025690 2033839 2033839 defendant Whyteacres Henry laborer 614922 614922 Whyteacres, Henry, of Swynton, laborer 1
4025692 2033840 2033840 defendant Bromhede Edward yeoman 614922 614922 Bromhede, Edward, of Swynton, yeoman 0
4025693 2033840 2033840 defendant Whyteacres Henry laborer 614922 614922 Whyteacres, Henry, of Swynton, laborer 1
4059745 2045878 2045878 plaintiff Cotes James gent 614922 614922 Cotes, James, of Swynton, gent 0
4059747 2045879 2045879 plaintiff Cotes James gent 614922 614922 Cotes, James, of Swynton, gent 0
4082240 2053961 2053961 defendant Wylcocke Leonard butcher 614922 614922 Wylcocke, Leonard, of Swynton, butcher 0
4105143 2062111 2062111 defendant Barnaston John yeoman 614922 614922 Barnaston, John, of Swynton, yeoman 2
4115501 2065831 2065831 defendant Wylcocke Leonard butcher 614922 614922 Wylcocke, Leonard, of Swynton, butcher 0
4126378 2069725 2069725 defendant Mendlove Thomas, senior husbandman 614922 614922 Mendlove, Thomas, senior, of Swynton, husbandman 0
4126379 2069725 2069725 defendant Mendlove Thomas, junior   614922 614922 Mendlove, Thomas, junior, of Swynton 1
4126380 2069725 2069725 defendant Bawdwynson John laborer 614922 614922 Bawdwynson, John, of Swynton, laborer 2
4126381 2069725 2069725 defendant White Thomas laborer 614922 614922 White, Thomas, of Swynton, laborer 3
4154006 2079494 2079494 defendant Pearson Thomas yeoman 614922 614922 Pearson, Thomas, of Swynton, yeoman 0
4178153 2087830 2087830 defendant Staveley John gent 614922 614922 Staveley, John, of Swynton, gent 0
4178154 2087830 2087830 defendant Wanson Christopher yeoman 614922 614922 Wanson, Christopher, of Swynton, yeoman 1
4228217 2105351 2105351 defendant Foster John husbandman 614922 614922 Foster, John, of Swynton, husbandman 0
4411295 2168363 2168363 defendant Cutt Nicholas laborer 614922 614922 Cutt, Nicholas, of Swynton, laborer 1
4412742 2168855 2168855 defendant Norton Robert gent 614922 614922 Norton, Robert, of Swynton, gent 0
4546910 2214967 2214967 plaintiff Bryan John   614922 614922 Bryan, John, of Swynton 0
4580823 2225484 2225484 defendant Pygot Richard   614922 614922 Pygot, Richard, of Swynton 3
4616180 2236063 2236063 defendant Walker Richard   614922 614922 Walker, Richard, of Swynton 1
4670441 2256440 2256440 plaintiff Bryan John   614922 614922 Bryan, John, of Swynton 0
4675355 2257901 2257901 defendant Bonde John yeoman 614922 614922 Bonde, John, of Swynton, yeoman 2
4685849 2261165 2261165 defendant Baker John husbandman 614922 614922 Baker, John, of Swynton, husbandman 0
4714503 2269867 2269867 defendant Hunt John, sen husbandman 614922 614922 Hunt, John, sen, of Swynton, husbandman 0
4714505 2269867 2269867 defendant Notte Richard husbandman 614922 614922 Notte, Richard, of Swynton, husbandman 2
4736931 2276679 2276679 defendant Hunt John   614922 614922 Hunt, John, of Swynton, husbandman, son of John Hunt, sen 4
4752798 2281273 2281273 defendant Hunt John husbandman 614922 614922 Hunt, John, of Swynton, husbandman 0
4764555 2284901 2284901 defendant Bryan John yeoman 614922 614922 Bryan, John, of Swynton, yeoman 0
4765873 2285321 2285321 defendant Hunt John   614922 614922 Hunt, John, of Swynton 0
4776142 2288535 2288535 defendant Anon or Avon Thomas husbandman 614922 614922 Anon or Avon, Thomas, of Swynton, husbandman 4
4788057 2292333 2292333 defendant Swynton John gent 614922 614922 Swynton, John, of Swynton, gent 0
4788058 2292333 2292333 defendant Wodcok John gent 614922 614922 Wodcok, John, of Swynton, gent 1
4788520 2292471 2292471 defendant Brian John yeoman 614922 614922 Brian, John, of Swynton, yeoman 0
4818681 2301927 2301927 defendant Staveley John gent 614922 614922 Staveley, John, of Swynton, gent 0
4863946 2315699 2315699 defendant Bryan John husbandman 614922 614922 Bryan, John, of Swynton, husbandman 2
4864652 2315916 2315916 defendant Stanelay or Stavelay John gent 614922 614922 Stanelay or Stavelay, John, of Swynton, gent 1
4886019 2322487 2322487 defendant Stanelay or Stavelay John gent 614922 614922 Stanelay or Stavelay, John, of Swynton, gent 0
4903202 2327610 2327610 defendant Carter John husbandman 614922 614922 Carter, John, of Swynton, husbandman 0
4903203 2327610 2327610 defendant Carter John, junior husbandman 614922 614922 Carter, John, junior, of Swynton, husbandman 1
4903204 2327610 2327610 defendant Carter William husbandman 614922 614922 Carter, William, of Swynton, husbandman 2
4922501 2333453 2333453 defendant Swynton William gent 614922 614922 Swynton, William, of Swynton, gent, son & heir of John Swynton, of Swynton, gent 0
4947656 2341255 2341255 defendant Swynton William gent 614922 614922 Swynton, William, of Swynton, gent, son of Swynton, John, of Swynton, gent 0
4949419 2341808 2341808 defendant Swynton William gent 614922 614922 Swynton, William, of Swynton, gent 0
4960449 2345089 2345089 defendant Smyth Robert husbandman 614922 614922 Smyth, Robert, of Swynton, husbandman 1
4987159 2353108 2353108 defendant Smyth William husbandman 614922 614922 Smyth, William, of Swynton, husbandman 2
4987160 2353108 2353108 defendant Acrodes William husbandman 614922 614922 Acrodes, William, of Swynton, husbandman 3
4987161 2353108 2353108 defendant Smyth Robert husbandman 614922 614922 Smyth, Robert, of Swynton, husbandman 4
4987162 2353108 2353108 defendant Parlyngton Robert husbandman 614922 614922 Parlyngton, Robert, of Swynton, husbandman 5
5011443 2360212 2360212 defendant Smyth Robert husbandman 614922 614922 Smyth, Robert, of Swynton, husbandman 3
5026590 2364653 2364653 defendant Bayne William yeoman 614922 614922 Bayne, William, of Swynton, yeoman 4
5056420 2373494 2373494 defendant Fediller Thomas husbandman 614922 614922 Fediller, Thomas, of Swynton, husbandman 0
5146883 2400228 2400228 plaintiff Cawton William   614922 614922 Cawton, William, of Swynton 0
5282660 2439992 2439992 defendant Yattes John slater 614922 614922 Yattes, John, of Swynton, slater 2
5367482 2465476 2465476 defendant Smyth John husbandman 614922 614922 Smyth, John, of Swynton, husbandman 0
5607036 2537096 2537096 defendant Hunte Robert husbandman 614922 614922 Hunte, Robert, of Swynton, husbandman 0
5607037 2537096 2537096 defendant Hunte William husbandman 614922 614922 Hunte, William, of Swynton, husbandman 1
5619414 2549918 2549918 defendant Somercotes Alice de daugther of William 614922 614922 Somercotes, Alice de, of Swynton, daugther of William 2
5634510 2554793 2554793 defendant Smyth John husbandman 614922 614922 Smyth, John, of Swynton, husbandman 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);