names

56 rows where place_id = 596992

✎ 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
3626849 1903249 1903249 defendant Wankelyn or Waukelyn John husbandman 596992 596992 Wankelyn or Waukelyn, John, of Kymbalton, husbandman 0
3699441 1926050 1926050 defendant Stougthon William yeoman 596992 596992 Stougthon, William, of Kymbalton, yeoman 1
3699442 1926050 1926050 defendant Bayly Edward sherman 596992 596992 Bayly, Edward, of of Kymbalton, sherman 2
3757211 1944238 1944238 defendant Wright William courser 596992 596992 Wright, William, of Kymbalton, courser 0
3781468 1951942 1951942 defendant Dyxye Richard butcher 596992 596992 Dyxye, Richard, of Kymbalton, butcher 0
4159374 2081347 2081347 defendant Wancklen or Waucklen William gent 596992 596992 Wancklen or Waucklen, William, of Kymbalton, gent 3
4297233 2129117 2129117 defendant Tue John butcher 596992 596992 Tue, John, of Kymbalton, butcher 0
4407239 2166985 2166985 defendant Becke Gilbert yeoman 596992 596992 Becke, Gilbert, of Kymbalton, yeoman 2
4466709 2190258 2190258 defendant Clare Henry   596992 596992 Clare, Henry, of Kymbalton 0
4636315 2242192 2242192 defendant Stokton Thomas   596992 596992 Stokton, Thomas, of Kymbalton 0
4723136 2272547 2272547 defendant Merisoule Roger husbandman 596992 596992 Merisoule, Roger, of Kymbalton, husbandman 1
4784542 2291171 2291171 plaintiff Donwe or Douwe John dyer 596992 596992 Donwe or Douwe, John, of Kymbalton, dyer 0
4796340 2295003 2295003 defendant Wryght Roger husbandman 596992 596992 Wryght, Roger, of Kymbalton, husbandman 2
4874189 2318868 2318868 defendant Clare John husbandman 596992 596992 (Clare, John, of Kymbalton, husbandman 4
4926867 2334833 2334833 defendant Dey Richard laborer 596992 596992 Dey, Richard, of Kymbalton, laborer 2
5003142 2357823 2357823 defendant Simmyng William husbandman 596992 596992 Simmyng, William, of Kymbalton, husbandman 1
5045180 2370189 2370189 defendant Broun Thomas husbandman 596992 596992 Broun, Thomas, of Kymbalton, husbandman 4
5114669 2390704 2390704 defendant Crane John   596992 596992 Crane, John, of Kymbalton, "chopchirche" 5
5114769 2390732 2390732 defendant Crane Robert   596992 596992 Crane, Robert, of Kymbalton, "chopchirche" 6
5139125 2397936 2397936 defendant Coward William yeoman 596992 596992 Coward, William, of Kymbalton, yeoman 0
5159984 2404020 2404020 defendant Coward William yeoman 596992 596992 Coward, William, of Kymbalton, yeoman 0
5159985 2404020 2404020 defendant Nebelet Richard husbandman 596992 596992 Nebelet, Richard, of Kymbalton, husbandman 1
5174919 2408361 2408361 defendant Coward William yeoman 596992 596992 Coward, William, of Kymbalton, yeoman 0
5174920 2408361 2408361 defendant Nebelet Richard husbandman 596992 596992 Nebelet, Richard, of Kymbalton, husbandman 1
5174922 2408362 2408362 defendant Coward William yeoman 596992 596992 Coward, William, of Kymbalton, yeoman 0
5174923 2408362 2408362 defendant Nobelet Richard husbandman 596992 596992 Nobelet, Richard, of Kymbalton, husbandman 1
5179491 2409737 2409737 defendant Bowlast Thomas yeoman 596992 596992 Bowlast, Thomas, of Kymbalton, yeoman 1
5179492 2409737 2409737 defendant Baret Thomas yeoman 596992 596992 Baret, Thomas, of Kymbalton, yeoman 2
5179493 2409737 2409737 defendant Fyssher John glover 596992 596992 Fyssher, John, of Kymbalton, glover 3
5179494 2409737 2409737 defendant Walsshman Roger yeoman 596992 596992 Walsshman, Roger, of Kymbalton, yeoman 4
5179495 2409737 2409737 defendant Mynt Thomas yeoman 596992 596992 Mynt, Thomas, of Kymbalton, yeoman 5
5200014 2415758 2415758 defendant Bowelast Thomas yeoman 596992 596992 Bowelast, Thomas, of Kymbalton, yeoman 1
5200015 2415758 2415758 defendant Baret Thomas yeoman 596992 596992 Baret, Thomas, of Kymbalton, yeoman 2
5200016 2415758 2415758 defendant Fyssher John   596992 596992 Fyssher, John, of Kymbalton, glove maker 3
5200018 2415758 2415758 defendant Walsshe Roger yeoman 596992 596992 Walsshe, Roger, of Kymbalton, yeoman 5
5202838 2416595 2416595 defendant Mynt Thomas yeoman 596992 596992 Mynt, Thomas, of Kymbalton, yeoman 5
5202839 2416595 2416595 defendant Crakke Henry yeoman 596992 596992 Crakke, Henry, of Kymbalton, yeoman 6
5202840 2416595 2416595 defendant Rysley Richard yeoman 596992 596992 Rysley, Richard, of Kymbalton, yeoman 7
5211343 2419048 2419048 defendant Bowelast Thomas yeoman 596992 596992 Bowelast, Thomas, of Kymbalton, yeoman 1
5211347 2419048 2419048 defendant Walssheman Roger yeoman 596992 596992 Walssheman, Roger, of Kymbalton, yeoman 5
5211348 2419048 2419048 defendant Rysley Richard yeoman 596992 596992 Rysley, Richard, of Kymbalton, yeoman 6
5211349 2419048 2419048 defendant Mynt Thomas yeoman 596992 596992 Mynt, Thomas, of Kymbalton, yeoman 7
5211350 2419048 2419048 defendant Crak Henry yeoman 596992 596992 Crak, Henry, of Kymbalton, yeoman 8
5256260 2432080 2432080 defendant Pateshale John gent 596992 596992 Pateshale, John, of Kymbalton, gent 0
5286198 2440973 2440973 defendant Idelet or Iglet William yeoman 596992 596992 Idelet or Iglet, William, of Kymbalton, yeoman 0
5315790 2449795 2449795 defendant Broun Thomas husbandman 596992 596992 Broun, Thomas, of Kymbalton, husbandman 0
5315793 2449795 2449795 defendant Haryot Simon butcher 596992 596992 Haryot, Simon, of Kymbalton, butcher 3
5322102 2451682 2451682 defendant Morgan Philip   596992 596992 Morgan, Philip, of Kymbalton, Hunts. Stainer 2
5384135 2470553 2470553 defendant Bokenell William husbandman 596992 596992 Bokenell, William, of Kymbalton, husbandman 0
5393226 2473115 2473115 defendant Couper Thomas tailor 596992 596992 Couper, Thomas, of Kymbalton, tailor 1
5419447 2480735 2480735 defendant (illegible) Thomas tailor 596992 596992 _, Thomas, of Kymbalton, tailor 0
5424963 2482432 2482432 defendant Broune Thomas, sen husbandman 596992 596992 Broune, Thomas, sen, of Kymbalton, husbandman 1
5501881 2505512 2505512 defendant Gowe John   596992 596992 Gowe, John, of Kymbalton, Hunts tailor 1
5501885 2505513 2505513 defendant Gowe John   596992 596992 Gowe, John, of Kymbalton, Hunts tailor 2
5516456 2509975 2509975 defendant Broun Thomas, junior butcher 596992 596992 Broun, Thomas, junior, of Kymbalton, butcher 1
5516463 2509976 2509976 defendant Broun Thomas, junior butcher 596992 596992 Broun, Thomas, junior, of Kymbalton, butcher 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);