names

56 rows where place_id = 608095

✎ 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
3672164 1917292 1917292 defendant Messynger John, junior yeoman 608095 608095 Messynger, John, junior, of Trusthorp, yeoman 0
3743833 1939957 1939957 plaintiff Smythe John   608095 608095 Smythe, John, of Trusthorp 1
3753540 1943045 1943045 plaintiff Smythe John   608095 608095 Smythe, John, of Trusthorp 0
3755573 1943698 1943698 defendant Bust John husbandman 608095 608095 Bust, John, of Trusthorp, husbandman 0
3763397 1946180 1946180 defendant Bradeley Robert mariner 608095 608095 Bradeley, Robert, of Trusthorp, mariner 0
3831733 1967826 1967826 defendant Kirke John yeoman 608095 608095 Kirke, John, of Trusthorp, yeoman 0
3904619 1991798 1991798 defendant More William husbandman 608095 608095 More, William, of Trusthorp, husbandman 0
3922327 1997781 1997781 defendant Harnesse John husbandman 608095 608095 Harnesse, John, of Trusthorp, husbandman 0
4439584 2181645 2181645 plaintiff Banane R--   608095 608095 Banane, R--, of Trusthorp 0
4550166 2215995 2215995 defendant Warry William   608095 608095 Warry, William, of Trusthorp 0
4550168 2215996 2215996 defendant Warry William   608095 608095 Warry, William, of Trusthorp 0
4550344 2216048 2216048 plaintiff Bavant Robert   608095 608095 Bavant, Robert, of Trusthorp 2
4580188 2225292 2225292 plaintiff Bavant Robert   608095 608095 Bavant, Robert, of Trusthorp 2
4591860 2228807 2228807 defendant Wilkynson John   608095 608095 Wilkynson, John, of Trusthorp 0
4595728 2229918 2229918 defendant Banand Robert   608095 608095 Banand, Robert, of Trusthorp 0
4596034 2230008 2230008 defendant Wylkynson John   608095 608095 Wylkynson, John, of Trusthorp 0
4604091 2232446 2232446 defendant atte Marre Robert   608095 608095 atte Marre, Robert, of Trusthorp 2
4605730 2232909 2232909 defendant Darry Robert   608095 608095 Darry, Robert, of Trusthorp 0
4653589 2247055 2247055 defendant Graa William husbandman 608095 608095 Graa, William, of Trusthorp, husbandman 0
4657852 2248342 2248342 defendant Graa William husbandman 608095 608095 Graa, William, of Trusthorp, husbandman 0
4667323 2255508 2255508 defendant Darry Robert shoemaker 608095 608095 Darry, Robert, of Trusthorp, shoemaker 1
4690132 2262470 2262470 defendant Bynbrok John   608095 608095 Bynbrok, John, of Trusthorp, parson 0
4716130 2270351 2270351 defendant Pashlewe Robert chaplain 608095 608095 Pashlewe, Robert, of Trusthorp, chaplain 0
4784114 2291030 2291030 plaintiff Catour William   608095 608095 Catour, William, of Trusthorp 2
4806038 2298099 2298099 plaintiff Bynbrok John clerk 608095 608095 Bynbrok, John, of Trusthorp, clerk 0
4811886 2299831 2299831 defendant Darry Robert shoemaker 608095 608095 Darry, Robert, of Trusthorp, shoemaker 0
4832232 2306114 2306114 plaintiff Bynbroke John   608095 608095 Bynbroke, John, of Trusthorp, parson of the church 0
4832235 2306115 2306115 plaintiff Bynbroke John   608095 608095 Bynbroke, John, of Trusthorp, parson 1
4834791 2306882 2306882 defendant Tipshethe John husbandman 608095 608095 Tipshethe, John, of Trusthorp, husbandman 1
4835133 2306988 2306988 defendant Well John husbandman 608095 608095 Well, John, of Trusthorp, husbandman 1
4835271 2307030 2307030 defendant Typsheth John gent 608095 608095 Typsheth, John, of Trusthorp, gent 0
4857539 2313745 2313745 defendant Hudson John chaplain 608095 608095 Hudson, John, of Trusthorp, chaplain 0
4861747 2315046 2315046 defendant Typschete John gent 608095 608095 Typschete, John, of Trusthorp, gent 0
4878899 2320334 2320334 defendant Hopkynson John husbandman 608095 608095 Hopkynson, John, of Trusthorp, husbandman 0
4887780 2323009 2323009 defendant Darry Robert courser 608095 608095 Darry, Robert, of Trusthorp, courser 4
4887781 2323009 2323009 defendant Darry John yeoman 608095 608095 Darry, John, of Trusthorp, yeoman 5
4915846 2331453 2331453 defendant Roberdson John husbandman 608095 608095 Roberdson, John, of Trusthorp, husbandman 9
4918064 2332164 2332164 defendant Typshoth John, senior gent 608095 608095 Typshoth, John, senior, of Trusthorp, gent 0
4918065 2332164 2332164 defendant Typsheth Thomas, junior gent 608095 608095 Typsheth, Thomas, junior, of Trusthorp, gent 1
4932464 2336550 2336550 plaintiff Wilkynson Robert (legal representative) 608095 608095 Wilkynson, Robert, of Trusthorp, executors of 0
5026221 2364562 2364562 defendant Gra Thomas courser 608095 608095 Gra, Thomas, of Trusthorp, courser 0
5060121 2374596 2374596 defendant Robert alias Robertson Wylkynson John husbandman 608095 608095 Robert alias Robertson Wylkynson, John, of Trusthorp, husbandman 0
5150272 2401213 2401213 defendant Hopkynson Thomas husbandman 608095 608095 Hopkynson, Thomas, of Trusthorp, husbandman 0
5161797 2404558 2404558 defendant Cator John yeoman 608095 608095 Cator, John, of Trusthorp, yeoman 0
5369595 2466076 2466076 defendant Stut William husbandman 608095 608095 Stut, William, of Trusthorp, husbandman 1
5369596 2466076 2466076 defendant Tomlynson John husbandman 608095 608095 Tomlynson, John, of Trusthorp, husbandman 2
5424779 2482370 2482370 plaintiff Cadale John   608095 608095 Cadale, John, of Trusthorp, parson 0
5424781 2482370 2482370 defendant Austyn John husbandman 608095 608095 Austyn, John, of Trusthorp, husbandman 1
5443479 2487961 2487961 plaintiff Cadale John   608095 608095 Cadale, John, of Trusthorp, parson 0
5446058 2488705 2488705 plaintiff Gadale John   608095 608095 Gadale, John, of Trusthorp, parson 0
5446059 2488705 2488705 defendant Austyn John husbandman 608095 608095 Austyn, John, of Trusthorp, husbandman 0
5479252 2498811 2498811 defendant Austyn John husbandman 608095 608095 Austyn, John, of Trusthorp, husbandman 0
5533380 2514990 2514990 defendant Tomson John husbandman 608095 608095 Tomson, John, of Trusthorp, husbandman 0
5533381 2514990 2514990 defendant Roke Thomas smith 608095 608095 Roke, Thomas, of Trusthorp, smith 1
5622824 2551066 2551066 defendant Raulynson John   608095 608095 Raulynson, John, of Trusthorp 0
5622825 2551066 2551066 defendant Raulynson Walter   608095 608095 Raulynson, Walter, of Trusthorp 1

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