names

51 rows where place_id = 619418

✎ 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
3729862 1935597 1935597 defendant Leder William yeoman 619418 619418 Leder, William, of Cawode, yeoman 0
3729863 1935597 1935597 defendant Runkorne William glover 619418 619418 Runkorne, William, of Cawode, glover 1
3729864 1935597 1935597 defendant Alen William husbandman 619418 619418 Alen, William, of Cawode, husbandman 2
3729865 1935597 1935597 defendant Pye Richard husbandman 619418 619418 Pye, Richard, of Cawode, husbandman 3
4460908 2188478 2188478 defendant Stede Robert othe   619418 619418 Stede, Robert othe, of Cawode 2
4497224 2199784 2199784 defendant del Strode Robert   619418 619418 del Strode, Robert, of Cawode 0
4498724 2200236 2200236 defendant Brewer John   619418 619418 Brewer, John, of Cawode 1
4504005 2201809 2201809 defendant Cawod John de   619418 619418 Cawod, John de, of Cawode 0
4528388 2209154 2209154 defendant Brewehous John   619418 619418 Brewehous, John, of Cawode 0
4528390 2209155 2209155 defendant Brewehous John   619418 619418 Brewehous, John, of Cawode 0
4572677 2222995 2222995 plaintiff atte Stede Robert   619418 619418 atte Stede, Robert, of Cawode 0
4583339 2226209 2226209 defendant Cawode John tailor 619418 619418 Cawode, John, of Cawode, tailor 2
4600670 2231437 2231437 defendant Sted Robert   619418 619418 Sted, Robert, of Cawode 0
4648477 2245604 2245604 defendant Steed Robert   619418 619418 Steed, Robert, of Cawode 0
4712730 2269294 2269294 defendant Carlell William husbandman 619418 619418 Carlell, William, of Cawode, husbandman 2
4722835 2272455 2272455 defendant Frere John husbandman 619418 619418 Frere, John, of Cawode, husbandman 0
4728770 2274235 2274235 defendant del Stede Robert yeoman 619418 619418 del Stede, Robert, of Cawode, yeoman 0
4814007 2300487 2300487 defendant Catlyn William yeoman 619418 619418 Catlyn, William, of Cawode, yeoman 0
4814008 2300487 2300487 defendant Tyler Robert yeoman 619418 619418 Tyler, Robert, of Cawode, yeoman 1
4814011 2300488 2300488 defendant Catlyn William yeoman 619418 619418 Catlyn, William, of Cawode, yeoman 0
4814012 2300488 2300488 defendant Tyler Robert yeoman 619418 619418 Tyler, Robert, of Cawode, yeoman 1
4854220 2312730 2312730 defendant Cawode Peter gent 619418 619418 Cawode, Peter, of Cawode, gent 0
4854222 2312731 2312731 defendant Cawode Peter gent 619418 619418 Cawode, Peter, of Cawode, gent 0
4867295 2316735 2316735 defendant Spaunton Walter yeoman 619418 619418 Spaunton, Walter, of Cawode, yeoman 0
4867296 2316735 2316735 defendant Watson William flesshewer or butcher 619418 619418 Watson, William, of Cawode, flesshewer or butcher 1
4887702 2322982 2322982 defendant Clune or Clime Richard turner 619418 619418 Clune or Clime, Richard, of Cawode, turner 0
4887704 2322982 2322982 defendant Taillour John tailor 619418 619418 Taillour, John, of Cawode, tailor 2
4920869 2333041 2333041 defendant Watson William butcher 619418 619418 Watson, William, of Cawode, butcher 0
4964977 2346441 2346441 defendant Kyrkeby John turner 619418 619418 Kyrkeby, John, of Cawode, turner 0
5036329 2367476 2367476 defendant Katelyn John yeoman 619418 619418 Katelyn, John, of Cawode, yeoman 1
5054699 2372984 2372984 defendant Cawode John esq 619418 619418 Cawode, John, of Cawode, esq 2
5058055 2373977 2373977 defendant Cawode John gent 619418 619418 Cawode, John, of Cawode, gent 0
5345270 2458693 2458693 defendant Rayson William tailor 619418 619418 Rayson, William, of Cawode, tailor 0
5345272 2458694 2458694 defendant Rayson William tailor 619418 619418 Rayson, William, of Cawode, tailor 0
5391496 2472639 2472639 defendant Sharp John laborer 619418 619418 Sharp, John, of Cawode, laborer 3
5416329 2479802 2479802 plaintiff Aklom Richard esq 619418 619418 Aklom, Richard, of Cawode, esq 1
5416331 2479802 2479802 defendant Rafin Thomas yeoman 619418 619418 Rafin, Thomas, of Cawode, yeoman 1
5433108 2484868 2484868 plaintiff Acclom Richard esq 619418 619418 Acclom, Richard, of Cawode, esq 1
5433110 2484868 2484868 defendant Rason Thomas yeoman 619418 619418 Rason, Thomas, of Cawode, yeoman 1
5496683 2503928 2503928 defendant Palden Robert   619418 619418 Palden, Robert, of Cawode, mason 0
5500269 2505029 2505029 defendant Perche Alexander yeoman 619418 619418 Perche, Alexander, of Cawode, yeoman 0
5569659 2525696 2525696 defendant Youle or Yonle Thomas butcher 619418 619418 Youle or Yonle, Thomas, of Cawode, butcher 1
5578663 2528393 2528393 defendant Peerson Thomas husbandman 619418 619418 Peerson, Thomas, of Cawode, husbandman 1
5578664 2528393 2528393 defendant Halys Robert, junior husbandman 619418 619418 Halys, Robert, junior, of Cawode, husbandman 2
5578665 2528393 2528393 defendant Plommer Henry husbandman 619418 619418 Plommer, Henry, of Cawode, husbandman 3
5578666 2528393 2528393 defendant Forman Thomas husbandman 619418 619418 Forman, Thomas, of Cawode, husbandman 4
5578667 2528393 2528393 defendant Bethom Robert husbandman 619418 619418 Bethom, Robert, of Cawode, husbandman 5
5578668 2528393 2528393 defendant Acastre William husbandman 619418 619418 Acastre, William, of Cawode, husbandman 6
5578669 2528393 2528393 defendant Bowys Thomas husbandman 619418 619418 Bowys, Thomas, of Cawode, husbandman 7
5582767 2529682 2529682 defendant Bryndholme John yeoman 619418 619418 Bryndholme, John, of Cawode, yeoman 0
5596783 2533913 2533913 defendant Watson alias Bowes Thomas yeoman 619418 619418 Watson alias Bowes, Thomas, of Cawode, yeoman 2

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