names

53 rows where place_id = 638927

✎ 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
3650476 1910516 1910516 plaintiff Scote Robert (legal representative) 638927 638927 Scote, Robert, of North Somercotes, executors of 0
3845720 1972207 1972207 defendant Langton Thomas husbandman 638927 638927 Langton, Thomas, of North Somercotes, husbandman 0
3942678 2004557 2004557 defendant Fraunceys Thomas (legal representative) 638927 638927 Fraunceys, Thomas, of North Somercotes, husbandman, executors of 2
4175519 2086909 2086909 defendant Gunney Thomas husbandman 638927 638927 Gunney, Thomas, of North Somercotes, husbandman 0
4175521 2086910 2086910 defendant Gunney Thomas husbandman 638927 638927 Gunney, Thomas, of North Somercotes, husbandman 0
4183773 2089815 2089815 defendant Gunney Thomas husbandman 638927 638927 Gunney, Thomas, of North Somercotes, husbandman 0
4207472 2098168 2098168 defendant Gunney Thomas husbandman 638927 638927 Gunney, Thomas, of North Somercotes, husbandman 0
4276934 2121864 2121864 defendant Thompson Roger yeoman 638927 638927 Thompson, Roger, of North Somercotes, yeoman 0
4276936 2121864 2121864 defendant Cockerill Thomas husbandman 638927 638927 Cockerill, Thomas, of North Somercotes, husbandman 2
4277865 2122187 2122187 defendant Thompson Roger yeoman 638927 638927 Thompson, Roger, of North Somercotes, yeoman 0
4280263 2123002 2123002 defendant West William yeoman 638927 638927 West, William, of North Somercotes, yeoman 0
4280264 2123002 2123002 defendant Gatton William fisher 638927 638927 Gatton, William, of North Somercotes, fisher 1
4298397 2129527 2129527 defendant Hill John brewster 638927 638927 Hill, John, of North Somercotes, brewster 2
4363383 2151976 2151976 defendant Elie William husbandman 638927 638927 Elie, William, of North Somercotes, husbandman 1
4373695 2155661 2155661 defendant Goodricke John yeoman 638927 638927 Goodricke, John, of North Somercotes, yeoman 0
4450114 2184995 2184995 plaintiff Hakke William   638927 638927 Hakke, William, of North Somercotes 0
4450116 2184995 2184995 defendant Scot John   638927 638927 Scot, John, of North Somercotes 0
4450117 2184995 2184995 defendant Scot William   638927 638927 Scot, William, of North Somercotes 1
4820503 2302484 2302484 defendant Langton John yeoman 638927 638927 Langton, John, of North Somercotes, yeoman 3
4993139 2354829 2354829 defendant Marshall Thomas laborer 638927 638927 Marshall, Thomas, of North Somercotes, laborer 0
4993140 2354829 2354829 defendant Oste Geoffrey husbandman 638927 638927 Oste, Geoffrey, of North Somercotes, husbandman 1
5119693 2392196 2392196 defendant Belesby Thomas fisher 638927 638927 Belesby, Thomas, of North Somercotes, fisher 0
5192124 2413425 2413425 defendant Ferra John husbandman 638927 638927 Ferra, John, of North Somercotes, husbandman 1
5196320 2414674 2414674 defendant Auncell Thomas husbandman 638927 638927 Auncell, Thomas, of North Somercotes, husbandman 0
5207621 2417970 2417970 defendant Ferra John husbandman 638927 638927 Ferra, John, of North Somercotes, husbandman 1
5240535 2427445 2427445 defendant Govylde John shipman 638927 638927 Govylde, John, of North Somercotes, shipman 2
5244218 2428502 2428502 defendant Ludforth William laborer 638927 638927 Ludforth, William, of North Somercotes, laborer 7
5255155 2431726 2431726 defendant Cawode Thomas chapman 638927 638927 Cawode, Thomas, of North Somercotes, chapman 0
5258889 2432896 2432896 defendant Goderyk William husbandman 638927 638927 Goderyk, William, of North Somercotes, husbandman 3
5258890 2432896 2432896 defendant Gold John husbandman 638927 638927 Gold, John, of North Somercotes, husbandman 4
5264273 2434583 2434583 defendant Goderyk Rchard husbandman 638927 638927 Goderyk, Rchard, of North Somercotes, husbandman 0
5264274 2434583 2434583 defendant Goderyk William, senior husbandman 638927 638927 Goderyk, William, senior, of North Somercotes, husbandman 1
5264275 2434583 2434583 defendant Pyrson John husbandman 638927 638927 Pyrson, John, of North Somercotes, husbandman 2
5266784 2435365 2435365 defendant Goderyk Richard husbandman 638927 638927 Goderyk, Richard, of North Somercotes, husbandman 5
5284915 2440609 2440609 plaintiff Goderyk William   638927 638927 Goderyk, William, of North Somercotes 0
5284916 2440609 2440609 defendant Dadde Thomas husbandman 638927 638927 Dadde, Thomas, of North Somercotes, husbandman 0
5284917 2440609 2440609 defendant Johnson Robert fisher 638927 638927 Johnson, Robert, of North Somercotes, fisher 1
5285392 2440749 2440749 plaintiff Gunnes or Emmes John   638927 638927 Gunnes or Emmes, John, of North Somercotes 0
5285393 2440749 2440749 defendant Dadde Thomas husbandman 638927 638927 Dadde, Thomas, of North Somercotes, husbandman 0
5285394 2440749 2440749 defendant Johnson Robert fisher 638927 638927 Johnson, Robert, of North Somercotes, fisher 1
5285395 2440749 2440749 defendant Langton William yeoman 638927 638927 Langton. William, of North Somercotes, yeoman 2
5302110 2445587 2445587 defendant Hornse Thomas husbandman 638927 638927 Hornse, Thomas, of North Somercotes, husbandman 0
5302111 2445587 2445587 defendant Langton William   638927 638927 Langton, William, of North Somercotes 1
5315836 2449809 2449809 defendant Cawode Thomas chapman 638927 638927 Cawode, Thomas, of North Somercotes, chapman 1
5333047 2454953 2454953 defendant Mauguns or Manguns John mariner 638927 638927 Mauguns or Manguns, John, of North Somercotes, mariner 0
5333048 2454953 2454953 defendant Mauguns or Manguns Robert mariner 638927 638927 Mauguns or Manguns, Robert, of North Somercotes, mariner 1
5339729 2457001 2457001 defendant Arthrugh John husbandman 638927 638927 Arthrugh, John, of North Somercotes, husbandman 0
5339735 2457002 2457002 defendant Arthrugh John husbandman 638927 638927 Arthrugh, John, of North Somercotes, husbandman 0
5342152 2457739 2457739 defendant Droury Robert husbandman 638927 638927 Droury, Robert, of North Somercotes, husbandman 0
5342153 2457739 2457739 defendant Droury William husbandman 638927 638927 Droury, William, of North Somercotes, husbandman 1
5342154 2457739 2457739 defendant Langton John laborer 638927 638927 Langton, John, of North Somercotes, laborer 2
5343023 2458005 2458005 defendant Betenes Elizabeth widow 638927 638927 Betenes, Elizabeth, of North Somercotes, widow 1
5370368 2466319 2466319 defendant Goderik Richard, senior husbandman 638927 638927 Goderik, Richard, senior, of North Somercotes, 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);