names

44 rows where place_id = 753558

✎ 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
4414246 2169364 2169364 defendant Costyn John   753558 753558 Costyn, John, of Kerseye 0
4431491 2174616 2174616 defendant Webbe John le   753558 753558 Webbe, John le, of Kerseye, son of Nicholas 0
4432706 2174982 2174982 defendant Boxsted John de   753558 753558 Boxsted, John de, of Kerseye, son of William 1
4440704 2182005 2182005 plaintiff Berte John   753558 753558 Berte, John, of Kerseye 0
4440790 2182036 2182036 defendant Calle Richard   753558 753558 Calle, Richard, of kerseye 0
4455630 2186771 2186771 defendant Wasset Thomas   753558 753558 Wasset, Thomas, of Kerseye 2
4456619 2187093 2187093 defendant Calle Richard   753558 753558 Calle, Richard, of Kerseye 0
4490867 2197841 2197841 plaintiff Webbe John   753558 753558 Webbe, John, of Kerseye 0
4490868 2197841 2197841 defendant Jakelot Richard   753558 753558 Jakelot, Richard, of Kerseye 0
4503707 2201728 2201728 plaintiff Polstede John   753558 753558 Polstede, John, of Kerseye, prior, on his own acocunt 0
4509004 2203296 2203296 plaintiff Aspelon Robert   753558 753558 Aspelon, Robert, of Kerseye 0
4509006 2203297 2203297 plaintiff Aspelon Robert   753558 753558 Aspelon, Robert, of Kerseye, on his own account 0
4509599 2203477 2203477 defendant Mollere John   753558 753558 Mollere, John, of Kerseye 0
4557084 2218143 2218143 defendant Ku John   753558 753558 Ku, John, of Kerseye 0
4579721 2225143 2225143 defendant Newehawe John   753558 753558 Newehawe, John, of Kerseye 0
4604129 2232459 2232459 defendant Bondemr John   753558 753558 Bondemr, John, of Kerseye 0
4609630 2234109 2234109 defendant Arnald John   753558 753558 Arnald, John, of Kerseye 0
4625508 2238942 2238942 defendant Medwe John   753558 753558 Medwe, John, of Kerseye 1
4625509 2238942 2238942 defendant Cayly John   753558 753558 Cayly, John, of Kerseye 2
4625510 2238942 2238942 defendant Wryghte John   753558 753558 Wryghte, John, of Kerseye 3
4648680 2245667 2245667 defendant Boudener John   753558 753558 Boudener, John, of Kerseye 3
4665672 2250733 2250733 defendant Clovyer John husbandman 753558 753558 Clovyer, John, of Kerseye, husbandman 0
4676084 2258132 2258132 defendant Hacon John fuller 753558 753558 Hacon, John, of Kerseye, fuller 0
4676822 2258368 2258368 defendant Hacon John fuller 753558 753558 Hacon, John, of Kerseye, fuller 0
4678381 2258846 2258846 defendant Hacon John fuller 753558 753558 Hacon, John, of Kerseye, fuller 0
4702079 2266058 2266058 defendant Hacon John fuller 753558 753558 Hacon, John, of Kerseye, fuller 0
4703855 2266585 2266585 defendant Hacon John fuller 753558 753558 Hacon, John, of Kerseye, fuller 0
4740832 2277833 2277833 defendant Kwe John yeoman 753558 753558 Kwe, John, of Kerseye, yeoman 1
4748703 2280104 2280104 defendant Cook John butcher 753558 753558 Cook, John, of Kerseye, formerly of South Wolde, butcher 0
4762854 2284364 2284364 defendant Hacoun John husbandman 753558 753558 Hacoun, John, of Kerseye, husbandman 3
4777368 2288914 2288914 defendant Craton Nicholas   753558 753558 Craton, Nicholas, of Kerseye, wright 0
4782826 2290646 2290646 defendant Hakon John fuller 753558 753558 Hakon, John, of Kerseye, fuller 2
4782827 2290646 2290646 defendant Whethereld Edmund fuller 753558 753558 Whethereld, Edmund, of Kerseye, fuller 3
4784283 2291082 2291082 defendant Skeet John husbandman 753558 753558 Skeet, John, of Kerseye, husbandman 1
4784284 2291082 2291082 defendant Stevene Thomas fuller 753558 753558 Stevene, Thomas, of Kerseye, fuller 2
4784285 2291082 2291082 defendant Fynche William chandler 753558 753558 Fynche, William, of Kerseye, chandler 3
4784286 2291082 2291082 defendant Whithereld Edmund dyer 753558 753558 Whithereld, Edmund, of Kerseye, dyer 4
4784317 2291092 2291092 defendant Whithereld Edmund dyer 753558 753558 Whithereld, Edmund, of Kerseye, dyer 3
4786563 2291847 2291847 defendant Hacom John husbandman 753558 753558 Hacom, John, of Kerseye, husbandman 1
4791707 2293503 2293503 defendant Smyth Richard smith 753558 753558 Smyth, Richard, of Kerseye, smith 4
4871397 2318021 2318021 defendant Lonetoppe or Lovetoppe William yeoman 753558 753558 Lonetoppe or Lovetoppe, William, of Kerseye, yeoman 3
4871398 2318021 2318021 defendant Fynch William yeoman 753558 753558 Fynch, William, of Kerseye, yeoman 4
5623920 2551427 2551427 defendant Wryghte John husbandman 753558 753558 Wryghte, John, of Kerseye, husbandman 3
5624946 2551738 2551738 defendant Wright John yeoman 753558 753558 Wright, John, of Kerseye, yeoman 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);