names

80 rows where place_id = 753732

✎ 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
4415502 2169735 2169735 plaintiff Pakeman Simon   753732 753732 Pakeman, Simon, of Kereby 2
4416786 2170119 2170119 plaintiff Pakeman Simon   753732 753732 Pakeman, Simon, of Kereby 0
4537450 2211980 2211980 defendant Louthe John   753732 753732 Louthe, John, of Kereby 0
4583897 2226381 2226381 plaintiff Garde Agnes   753732 753732 Garde, Agnes, of Kereby 0
4583898 2226381 2226381 defendant Louther John de   753732 753732 Louther, John de, of Kereby 0
4583900 2226381 2226381 defendant Carter Walter   753732 753732 Carter, Walter, of Kereby 2
4626752 2239311 2239311 defendant Butre Thomas de   753732 753732 Butre, Thomas de, of Kereby 0
4756269 2282330 2282330 defendant George John husbandman 753732 753732 George, John, of Kereby, husbandman 1
4761724 2284010 2284010 defendant Oneley or Oveley William yeoman 753732 753732 Oneley or Oveley, William, of Kereby, yeoman 0
4761727 2284010 2284010 defendant Cooke John   753732 753732 Cooke, John, of Kereby, cook 3
4761728 2284010 2284010 defendant Gryse William husbandman 753732 753732 Gryse, William, of Kereby, husbandman 4
4761731 2284011 2284011 defendant Pener Roger husbandman 753732 753732 Pener, Roger, of Kereby, husbandman 0
4761732 2284011 2284011 defendant Flegge John yeoman 753732 753732 Flegge, John, of Kereby, yeoman 1
4761733 2284011 2284011 defendant Warner Simon husbandman 753732 753732 Warner, Simon, of Kereby, husbandman 2
4761737 2284013 2284013 defendant Hastynges Robert   753732 753732 Hastynges, Robert, of Kereby, single man 0
4761738 2284013 2284013 defendant Welford Thomas baker 753732 753732 Welford, Thomas, of Kereby, baker 1
4761739 2284013 2284013 defendant Chymney John yeoman 753732 753732 Chymney, John, of Kereby, yeoman 2
4761740 2284013 2284013 defendant Andrewe John yeoman 753732 753732 Andrewe, John, of Kereby, yeoman 3
4763474 2284561 2284561 defendant Pare Henry gent 753732 753732 Pare, Henry, of Kereby, gent 0
4789977 2292941 2292941 defendant Hastynges Robert singleman 753732 753732 Hastynges, Robert, of Kereby, singleman 0
4789978 2292941 2292941 defendant Welford Thomas baker 753732 753732 Welford, Thomas, of Kereby, baker 1
4789979 2292941 2292941 defendant Chynney John yeoman 753732 753732 Chynney, John, of Kereby, yeoman 2
4789980 2292941 2292941 defendant Andrewe John yeoman 753732 753732 Andrewe, John, of Kereby, yeoman 3
4789981 2292942 2292942 defendant Oveley or Oneley William yeoman 753732 753732 Oveley or Oneley, William, of Kereby, yeoman 0
4789982 2292942 2292942 defendant Cade William, junior carter 753732 753732 Cade, William, junior, of Kereby, carter 1
4789984 2292942 2292942 defendant Cooke John   753732 753732 Cooke, John, of Kereby, cook 3
4789985 2292942 2292942 defendant Gryse William husbandman 753732 753732 Gryse, William, of Kereby, husbandman 4
4789986 2292942 2292942 defendant West John, junior husbandman 753732 753732 West, John, junior, of Kereby, husbandman 5
4789987 2292943 2292943 defendant Pever or Pener Roger husbandman 753732 753732 Pever or Pener, Roger, of Kereby, husbandman 0
4789988 2292943 2292943 defendant Flegge John yeoman 753732 753732 Flegge, John, of Kereby, yeoman 1
4789989 2292943 2292943 defendant Warner Simon husbandman 753732 753732 Warner, Simon, of Kereby, husbandman 2
4790004 2292948 2292948 defendant Fleg John yeoman 753732 753732 Fleg, John, of Kereby, yeoman 3
4790005 2292948 2292948 defendant Warner Simon husbandman 753732 753732 Warner, Simon, of Kereby, husbandman 4
4825634 2304055 2304055 defendant Andrew John gent 753732 753732 Andrew, John, of Kereby, gent 7
4825639 2304057 2304057 defendant Cade John husbandman 753732 753732 Cade, John, of Kereby, husbandman 0
4902667 2327454 2327454 defendant Ledys John gent 753732 753732 Ledys, John, of Kereby, gent 0
4946437 2340880 2340880 plaintiff Kent John   753732 753732 Kent, John, of Kereby 0
4983086 2351843 2351843 defendant Herfeld John yeoman 753732 753732 Herfeld, John, of Kereby, yeoman 0
5048786 2371273 2371273 defendant Shirlok Richard husbandman 753732 753732 Shirlok, Richard, of Kereby, husbandman 0
5048787 2371273 2371273 defendant Herfeld John husbandman 753732 753732 Herfeld, John, of Kereby, husbandman 1
5048788 2371273 2371273 defendant del Stede Richard husbandman 753732 753732 del Stede, Richard, of Kereby, husbandman 2
5048789 2371273 2371273 defendant Pole Thomas husbandman 753732 753732 Pole, Thomas, of Kereby, husbandman 3
5053318 2372595 2372595 defendant Fanne Geoffrey yeoman 753732 753732 Fanne, Geoffrey, of Kereby, yeoman 1
5059195 2374315 2374315 defendant Fanne Geoffrey yeoman 753732 753732 Fanne, Geoffrey, of Kereby, yeoman 1
5069567 2377397 2377397 defendant Shyrlok Richard husbandman 753732 753732 Shyrlok, Richard, of Kereby, husbandman 0
5069568 2377397 2377397 defendant Herfeld John husbandman 753732 753732 Herfeld, John, of Kereby, husbandman 1
5069569 2377397 2377397 defendant del Stede Richard husbandman 753732 753732 del Stede, Richard, of Kereby, husbandman 2
5069570 2377397 2377397 defendant Pole Thomas husbandman 753732 753732 Pole, Thomas, of Kereby, husbandman 3
5076136 2379365 2379365 defendant Fanne Geoffrey yeoman 753732 753732 Fanne, Geoffrey, of Kereby, yeoman 1
5096387 2385377 2385377 defendant del Stede John husbandman 753732 753732 del Stede, John, of Kereby, husbandman 0
5096436 2385391 2385391 defendant Bysshop John husbandman 753732 753732 Bysshop, John, of Kereby, husbandman 3
5138302 2397711 2397711 defendant Shirlok Richard husbandman 753732 753732 Shirlok, Richard, of Kereby, husbandman 0
5138303 2397711 2397711 defendant Herfeld John husbandman 753732 753732 Herfeld, John, of Kereby, husbandman 1
5138304 2397711 2397711 defendant del Stede Richard husbandman 753732 753732 del Stede, Richard, of Kereby, husbandman 2
5138305 2397711 2397711 defendant Pole Thomas husbandman 753732 753732 Pole, Thomas, of Kereby, husbandman 3
5367832 2465566 2465566 defendant Besse William husbandman 753732 753732 Besse, William, of Kereby, husbandman 3
5367833 2465566 2465566 defendant Lamle William husbandman 753732 753732 Lamle, William, of Kereby, husbandman 4
5386236 2471126 2471126 defendant Busse William husbandman 753732 753732 Busse, William, of Kereby, husbandman 3
5386237 2471126 2471126 defendant Lambe William husbandman 753732 753732 Lambe, William, of Kereby, husbandman 4
5398484 2474626 2474626 defendant Busse William husbandman 753732 753732 Busse, William, of Kereby, husbandman 3
5398485 2474626 2474626 defendant Lambe William husbandman 753732 753732 Lambe, William, of Kereby, husbandman 4
5398490 2474627 2474627 defendant Busse William husbandman 753732 753732 Busse, William, of Kereby, husbandman 3
5398491 2474627 2474627 defendant Lambe William husbandman 753732 753732 Lambe, William, of Kereby, husbandman 4
5537793 2516308 2516308 defendant Wyghtman William, junior husbandman 753732 753732 Wyghtman, William, junior, of Kereby, husbandman 1
5537794 2516308 2516308 defendant Bolton Ralph   753732 753732 Bolton, Ralph, of Kereby, franklin 2
5545893 2518790 2518790 defendant Wyghtman William husbandman 753732 753732 Wyghtman, William, of Kereby, husbandman 0
5545894 2518790 2518790 defendant Wightman Richard laborer 753732 753732 Wightman, Richard, of Kereby, laborer 1
5545895 2518790 2518790 defendant Wightman Thomas husbandman 753732 753732 Wightman, Thomas, of Kereby, husbandman 2
5545896 2518790 2518790 defendant Stedeman Robert husbandman 753732 753732 Stedeman, Robert, of Kereby, husbandman 3
5545897 2518790 2518790 defendant Scurre Willianm husbandman 753732 753732 Scurre, Willianm, of Kereby, husbandman 4
5545899 2518791 2518791 defendant Wyghtman William husbandman 753732 753732 Wyghtman, William, of Kereby, husbandman 0
5545900 2518791 2518791 defendant Wyghtman Richard laborer 753732 753732 Wyghtman, Richard, of Kereby, laborer 1
5545901 2518791 2518791 defendant Wyghtman Thomas husbandman 753732 753732 Wyghtman, Thomas, of Kereby, husbandman 2
5545902 2518791 2518791 defendant Stedeman Robert husbandman 753732 753732 Stedeman, Robert, of Kereby, husbandman 3
5545903 2518791 2518791 defendant Scurre William husbandman 753732 753732 Scurre, William, of Kereby, husbandman 4
5545905 2518792 2518792 defendant Wyghtman William husbandman 753732 753732 Wyghtman, William, of Kereby, husbandman 0
5545906 2518792 2518792 defendant Wyghtman Richard laborer 753732 753732 Wyghtman, Richard, of Kereby, laborer 1
5545907 2518792 2518792 defendant Wyghtman Thomas husbandman 753732 753732 Wyghtman, Thomas, of Kereby, husbandman 2
5545908 2518792 2518792 defendant Stedeman Robert husbandman 753732 753732 Stedeman, Robert, of Kereby, husbandman 3
5545909 2518792 2518792 defendant Scurre Willianm husbandman 753732 753732 Scurre, Willianm, of Kereby, husbandman 4

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