names

69 rows where place_id = 671846

✎ 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
3999820 2024699 2024699 defendant Bartylmewe John   671846 671846 Bartylmewe, John, of Cleye juxta Mare, or ship master 0
4003266 2025926 2025926 defendant Alyson James mercer 671846 671846 Alyson, James, of Cleye juxta mare, mercer 0
4003267 2025926 2025926 defendant Tyvydall Robert draper 671846 671846 Tyvydall, Robert, of Cleye juxta Mare, draper 1
4036962 2037894 2037894 defendant Lytele Margery widow 671846 671846 Lytele, Margery, of Cleye juxta Mare, widow 1
4652627 2246778 2246778 defendant Lutton William baker 671846 671846 Lutton, William, of Cleye juxta Mare, baker 0
4653685 2247079 2247079 plaintiff Pers Thomas   671846 671846 Pers, Thomas, of Cleye juxta Mare 2
4783153 2290746 2290746 defendant Baas John husbandman 671846 671846 Baas, John, of Cleye juxta Mare, husbandman 0
4866583 2316509 2316509 defendant Bulwere John yeoman 671846 671846 Bulwere, John, of Cleye juxta Mare,, yeoman 4
4902529 2327409 2327409 defendant Bulwere John yeoman 671846 671846 Bulwere, John, of Cleye juxta Mare, yeoman 0
4905061 2328192 2328192 plaintiff Horn Adam   671846 671846 Horn, Adam, of Cleye juxta Mare 0
4905063 2328192 2328192 plaintiff Broun William   671846 671846 Broun, William, of Cleye juxta Mare 2
4938951 2338573 2338573 defendant Godknape Simon yeoman 671846 671846 Godknape, Simon, of Cleye juxta Mare, yeoman 0
4943009 2339788 2339788 defendant Horn Adam yeoman 671846 671846 Horn, Adam, of Cleye juxta Mare, yeoman 3
4951001 2342275 2342275 defendant Horne Adam yeoman 671846 671846 Horne, Adam, of Cleye juxta Mare, yeoman 0
4963917 2346118 2346118 defendant Baron Adam smith 671846 671846 Baron, Adam, of Cleye juxta Mare, smith 1
4975819 2349734 2349734 defendant Horne Adam merchant 671846 671846 Horne, Adam, of Cleye juxta Mare, merchant 1
4975823 2349735 2349735 defendant Horne Adam merchant 671846 671846 Horne, Adam, of Cleye juxta Mare, merchant 2
5018151 2362198 2362198 defendant Mason William   671846 671846 Mason, William, of Cleye juxta Mare, mason 0
5029219 2365424 2365424 defendant Verreys John yeoman 671846 671846 Verreys, John, of Cleye juxta Mare, yeoman 0
5035377 2367205 2367205 defendant Bernabe John shipman 671846 671846 Bernabe, John, of Cleye juxta Mare, shipman 0
5052512 2372344 2372344 defendant Scheder or Schethere Richard mariner 671846 671846 Scheder or Schethere, Richard, of Cleye juxta Mare, mariner 1
5052622 2372375 2372375 defendant Goodknape Simon husbandman 671846 671846 Goodknape, Simon, of Cleye juxta Mare, husbandman 0
5070615 2377708 2377708 defendant Horn William merchant 671846 671846 Horn, William, of Cleye juxta Mare, merchant 0
5072894 2378378 2378378 defendant Goodknape Simon yeoman 671846 671846 Goodknape, Simon, of Cleye juxta Mare, yeoman 0
5073051 2378426 2378426 defendant Conyngton or Covyngton William yeoman 671846 671846 Conyngton or Covyngton, William, of Cleye juxta Mare, yeoman 0
5098490 2385989 2385989 defendant Wagstaf Bartholomew fishmonger 671846 671846 Wagstaf, Bartholomew, of Cleye juxta Mare, fishmonger 0
5103273 2387387 2387387 defendant Giles John yeoman 671846 671846 Giles, John, of Cleye juxta Mare, yeoman 0
5104847 2387853 2387853 defendant Baron Adam smith 671846 671846 Baron, Adam, of Cleye juxta Mare, smith 1
5106633 2388368 2388368 defendant Torald Robert   671846 671846 Torald, Robert, of Cleye juxta Mare, shipwright 1
5229086 2424115 2424115 defendant Horne William husbandman 671846 671846 Horne, William, of Cleye juxta Mare, husbandman 3
5258570 2432799 2432799 plaintiff Halle Nicholas   671846 671846 Halle, Nicholas, of Cleye juxta Mare 0
5277209 2438417 2438417 defendant Brygge John gent 671846 671846 Brygge, John, of Cleye juxta Mare, gent 1
5277403 2438469 2438469 defendant Welle Henry mariner 671846 671846 Welle, Henry, of Cleye juxta Mare, mariner 1
5280458 2439357 2439357 defendant Betys John   671846 671846 Betys, John, of Cleye juxta Mare, shepherd 0
5290438 2442208 2442208 defendant Brygge John gent 671846 671846 Brygge, John, of Cleye juxta Mare, gent 1
5290586 2442249 2442249 defendant Colman Walter clerk 671846 671846 Colman, Walter, of Cleye juxta Mare, clerk 1
5296155 2443867 2443867 defendant Brigge John gent 671846 671846 Brigge, John, of Cleye juxta Mare, gent 0
5312989 2448915 2448915 defendant Pyrte Robert raffman 671846 671846 Pyrte, Robert, of Cleye juxta Mare, raffman 3
5316366 2449979 2449979 defendant Multon Robrt husbandman 671846 671846 Multon, Robrt, of Cleye juxta Mare, husbandman 0
5316453 2450001 2450001 defendant Hekker John (legal representative) 671846 671846 Hekker, John, of Cleye juxta Mare, yeoman, executors of 0
5316454 2450001 2450001 defendant Hekker William shoemaker 671846 671846 (Hekker, William, of Cleye juxta Mare, shoemaker 1
5316455 2450001 2450001 defendant Hekker Margaret widow 671846 671846 Hekker, Margaret, of Cleye juxta Mare, widow 2
5332131 2454687 2454687 defendant Andrewes William fishmonger 671846 671846 Andrewes, William, of Cleye juxta Mare, fishmonger 0
5332432 2454765 2454765 defendant Colman Walter clerk 671846 671846 Colman, Walter, of Cleye juxta Mare, clerk 1
5332435 2454766 2454766 defendant Colman Walter clerk 671846 671846 Colman, Walter, of Cleye juxta Mare, clerk 1
5341039 2457398 2457398 defendant Andrewes William fishmonger 671846 671846 Andrewes, William, of Cleye juxta Mare, fishmonger 0
5341533 2457541 2457541 defendant Rough Robert yeoman 671846 671846 Rough, Robert, of Cleye juxta Mare, yeoman 0
5341534 2457541 2457541 defendant Laurence Robert yeoman 671846 671846 Laurence, Robert, of Cleye juxta Mare, yeoman 1
5343127 2458041 2458041 plaintiff Smyth Thomas   671846 671846 Smyth, Thomas, of Cleye juxta Mare 0
5347824 2459471 2459471 defendant Pyrte Robert raffman 671846 671846 Pyrte, Robert, of Cleye juxta Mare, raffman 2
5347830 2459472 2459472 defendant Pyrte Robert raffman 671846 671846 Pyrte, Robert, of Cleye juxta Mare, raffman 2
5349879 2460096 2460096 defendant Skendilby Roger yeoman 671846 671846 Skendilby, Roger, of Cleye juxta Mare, yeoman 4
5353027 2461035 2461035 defendant Rough Robert husbandman 671846 671846 Rough, Robert, of Cleye juxta Mare, husbandman 0
5353448 2461154 2461154 defendant Hecker Margaret widow 671846 671846 Hecker, Margaret, of Cleye juxta Mare, widow 3
5360571 2463337 2463337 defendant Parre Roger shipman 671846 671846 Parre, Roger, of Cleye juxta Mare, shipman 0
5478717 2498658 2498658 defendant Wyllys William yeoman 671846 671846 Wyllys, William, of Cleye juxta Mare, yeoman 3
5482072 2499570 2499570 defendant Pyrt Robert raffman 671846 671846 Pyrt, Robert, of Cleye juxta Mare, raffman 0
5493821 2503057 2503057 defendant Collys Thomas yeoman 671846 671846 Collys, Thomas, of Cleye juxta Mare, yeoman 0
5493959 2503100 2503100 defendant Collys Thomas yeoman 671846 671846 Collys, Thomas, of Cleye juxta Mare, yeoman 0
5495635 2503595 2503595 defendant Pyrte Robert husbandman 671846 671846 Pyrte, Robert, of Cleye juxta Mare, husbandman 2
5508966 2507660 2507660 defendant Pyrt Robert raffman 671846 671846 Pyrt, Robert, of Cleye juxta Mare, raffman 0
5509417 2507793 2507793 defendant Colles Thomas husbandman 671846 671846 Colles, Thomas, of Cleye juxta Mare, husbandman 0
5512973 2508909 2508909 defendant Pyrte Robert husbandman 671846 671846 Pyrte, Robert, of Cleye juxta Mare, husbandman 0
5513467 2509058 2509058 defendant Elys John mariner 671846 671846 Elys, John, of Cleye juxta Mare, mariner 0
5560640 2523078 2523078 defendant Barnard Thomas baker 671846 671846 Barnard, Thomas, of Cleye juxta Mare, baker 0
5574661 2527149 2527149 defendant Smyth James cooper 671846 671846 Smyth, James, of Cleye juxta Mare, cooper 1
5629183 2553103 2553103 defendant Austyn Roger shipman 671846 671846 Austyn, Roger, of Cleye juxta Mare, shipman 1
5632276 2554124 2554124 defendant Bulwer John   671846 671846 Bulwer, John, of Cleye juxta Mare 0
5632278 2554125 2554125 defendant Bulwer John   671846 671846 Bulwer, John, of Cleye juxta Mare 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);