names

107 rows where place_id = 603616

✎ 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
3655133 1911866 1911866 defendant Harrison John hsubandman 603616 603616 Harrison, John, of Cley next the Sea, hsubandman 0
3664035 1914700 1914700 defendant Dobbys William cooper 603616 603616 Dobbys, William, of Cley next the Sea, cooper 0
3665903 1915273 1915273 plaintiff Symondys John (legal representative) 603616 603616 Symondys, John, of Cley next the Sea, executor of Robert Pallyng of Cley next the Sea, executor of 0
3666454 1915459 1915459 defendant Dalle William husbandman 603616 603616 Dalle, William, of Cley next the Sea, husbandman 0
3927082 1999395 1999395 defendant Maundforde William yeoman 603616 603616 Maundforde, William, of Cley next the Sea, yeoman 1
3927083 1999395 1999395 defendant Grenewey Thomas yeoman 603616 603616 Grenewey, Thomas, of Cley next the Sea, yeoman 2
3927088 1999396 1999396 defendant Maundforde William yeoman 603616 603616 Maundforde, William, of Cley next the Sea, yeoman 1
3927089 1999396 1999396 defendant Grenewey Thomas yeoman 603616 603616 Grenewey, Thomas, of Cley next the Sea, yeoman 2
3927831 1999647 1999647 defendant Miller John draper 603616 603616 Miller, John, of Cley next the sea, draper 0
3968155 2013489 2013489 defendant Myller John merchant 603616 603616 Myller, John, of Cley next the Sea, merchant 0
4036961 2037894 2037894 defendant Lytle Robert (legal representative) 603616 603616 Lytle, Robert, of Cley next the Sea, merchant, administratrix of 0
4248347 2112438 2112438 defendant Chambers William mariner 603616 603616 Chambers, William, of Cley next the Sea, mariner 0
4698114 2264897 2264897 defendant Clerk Geoffrey   603616 603616 Clerk, Geoffrey, of Cley next the Sea, holy water clerk 0
4711221 2268860 2268860 defendant Wagstafe John shipman 603616 603616 Wagstafe, John, of Cley next the sea, shipman 1
4729591 2274470 2274470 defendant Clerk Richard husbandman 603616 603616 Clerk, Richard, of Cley next the Sea, husbandman 0
4733294 2275589 2275589 defendant Benyngham William (legal representative) 603616 603616 Benyngham, William, of Cley next the Sea, parson, executor of 1
4733295 2275589 2275589 defendant Piers Thomas husbandman 603616 603616 Piers, Thomas, of Cley next the Sea, husbandman 2
4733298 2275590 2275590 defendant Dowe Nicholas yeoman 603616 603616 Dowe, Nicholas, of Cley next the sea, yeoman 0
4754882 2281906 2281906 defendant Smyth Adam husbandman 603616 603616 Smyth, Adam, of Cley next the sea, husbandman 0
4768821 2286226 2286226 defendant Pynnys John husbandman 603616 603616 Pynnys, John, of Cley next the Sea, husbandman 0
4808689 2298885 2298885 defendant Pynnes John husbandman 603616 603616 Pynnes, John, of Cley next the sea, husbandman 1
4818353 2301822 2301822 defendant Pynnes John husbandman 603616 603616 Pynnes, John, of Cley next the sea, husbandman 3
4847695 2310773 2310773 defendant Bocher John husbandman 603616 603616 Bocher, John, of Cley next the Sea, husbandman 0
4854009 2312663 2312663 defendant Jegge Bartholomew yeoman 603616 603616 Jegge, Bartholomew, of Cley next the Sea, yeoman 0
4913321 2330665 2330665 plaintiff Clement Edmund   603616 603616 Clement, Edmund, of Cley next the sea 0
4913322 2330665 2330665 defendant Cosshe Geoffrey yeoman 603616 603616 Cosshe, Geoffrey, of Cley next the sea, yeoman 0
4928318 2335281 2335281 defendant Coyshe Geoffrey husbandman 603616 603616 Coyshe, Geoffrey, of Cley next the Sea, husbandman 0
5002471 2357633 2357633 defendant Osbern William chaplain 603616 603616 Osbern, William, of Cley next the sea, chaplain 10
5038413 2368124 2368124 defendant Bryg William fuller 603616 603616 Bryg, William, of Cley next the sea, fuller 2
5038414 2368124 2368124 defendant Brandon Richard cooper 603616 603616 Brandon, Richard, of Cley next the sea, cooper 3
5040443 2368745 2368745 plaintiff Broun William merchant 603616 603616 Broun, William, of Cley next the sea, merchant 1
5042765 2369442 2369442 defendant Horn Adam (legal representative) 603616 603616 Horn, Adam, of Cley next the sea, executors of 0
5042767 2369442 2369442 defendant Horn William yeoman 603616 603616 Horn, William, of Cley next the sea, yeoman 2
5043215 2369591 2369591 plaintiff Ferys alias Verrys John   603616 603616 Ferys alias Verrys, John, of Cley next the sea 0
5047128 2370763 2370763 defendant Ferys John husbandman 603616 603616 Ferys, John, of Cley next the sea, husbandman 0
5047141 2370766 2370766 defendant Ferys John husbandman 603616 603616 with Ferys, John, of Cley next the sea, husbandman 1
5047491 2370870 2370870 defendant Parys Henry (legal representative) 603616 603616 Parys, Henry, of Cley next the sea, husbandman, executors of 0
5047492 2370870 2370870 defendant Wotton Henry husbandman 603616 603616 (Wotton, Henry, of Cley next the sea, husbandman 1
5047493 2370870 2370870 defendant Charlys John husbandman 603616 603616 Charlys, John, of Cley next the sea, husbandman 2
5051490 2372059 2372059 defendant Fuller Thomas fuller 603616 603616 Fuller, Thomas, of Cley next the sea, fuller 1
5125318 2393887 2393887 defendant Bene Henry   603616 603616 Bene, Henry, of Cley next the sea, shipwright 0
5125675 2393999 2393999 defendant Broune William merchant 603616 603616 Broune, William, of Cley next the sea, merchant 0
5125676 2393999 2393999 defendant Giles John yeoman 603616 603616 Giles, John, of Cley next the sea, yeoman 1
5125679 2394000 2394000 defendant Broune William merchant 603616 603616 Broune, William, of Cley next the sea, merchant 0
5125680 2394000 2394000 defendant Giles John yeoman 603616 603616 Giles, John, of Cley next the sea, yeoman 1
5132804 2396089 2396089 defendant Broun William merchant 603616 603616 with Broun, William, of Cley next the sea, merchant 2
5133082 2396162 2396162 plaintiff Hooker Robert   603616 603616 Hooker, Robert, of Cley next the sea 0
5136735 2397266 2397266 defendant Gyles (illegible) yeoman 603616 603616 Gyles, --, of Cley next the sea, yeoman 1
5138813 2397852 2397852 defendant Torald Robert   603616 603616 Torald, Robert, of Cley next the sea, ship wright 1
5139902 2398151 2398151 defendant Charles John husbandman 603616 603616 Charles, John, of Cley next the sea, husbandman 3
5143514 2399237 2399237 defendant Bene Henry   603616 603616 Bene, Henry, of Cley next the Sea, shipwright 0
5148076 2400583 2400583 defendant Wyndeler Robert merchant 603616 603616 Wyndeler, Robert, of Cley next the sea, merchant 3
5154534 2402479 2402479 defendant Shragger Richard woolman 603616 603616 Shragger, Richard, of Cley next the Sea, woolman 0
5157305 2403276 2403276 defendant Giles John   603616 603616 together with Giles, John, of Cley next the sea 1
5160004 2404027 2404027 defendant Torald Robert   603616 603616 Torald, Robert, of Cley next the sea, shipwright 1
5160625 2404202 2404202 defendant Giles John yeoman 603616 603616 Giles, John, of Cley next the sea, yeoman 1
5167527 2406232 2406232 defendant Wyndeler Robert merchant 603616 603616 Wyndeler, Robert, of Cley next the sea, merchant 3
5175381 2408489 2408489 defendant Giles John yeoman 603616 603616 Giles, John, of Cley next the sea, yeoman 1
5175536 2408527 2408527 defendant Cherles John husbandman 603616 603616 Cherles, John, of Cley next the sea, husbandman 3
5187616 2412094 2412094 plaintiff Hecker William   603616 603616 Hecker, William, of Cley next the sea 1
5198916 2415436 2415436 defendant Wagstaff John, sen yeoman 603616 603616 Wagstaff, John, sen, of Cley next the Sea, yeoman 0
5201286 2416134 2416134 defendant Bene Henry   603616 603616 Bene, Henry, of Cley next the Sea, ship wright 0
5203712 2416835 2416835 defendant Wyndeler Robert merchant 603616 603616 Wyndeler, Robert, of Cley next the sea, merchant 2
5205392 2417331 2417331 plaintiff Hagon Alice (legal representative) 603616 603616 Hagon, Alice, of Cley next the Sea, formerly wife of Thomas Hagon, executors of 0
5206015 2417492 2417492 plaintiff Horn William   603616 603616 Horn, William, of Cley next the Sea 0
5210821 2418899 2418899 defendant Wagstaff John, sen yeoman 603616 603616 Wagstaff, John, sen, of Cley next the Sea, yeoman 0
5269514 2436187 2436187 plaintiff Charlys John   603616 603616 Charlys, John, of Cley next the Sea 0
5274235 2437543 2437543 defendant Brygge John gent 603616 603616 Brygge, John, of Cley next the sea, gent 0
5298566 2444556 2444556 defendant Hakker John shoemaker 603616 603616 Hakker, John, of Cley next the Sea, shoemaker 2
5298572 2444557 2444557 defendant Fowler Robert yeoman 603616 603616 Fowler, Robert, of Cley next the Sea, yeoman 2
5300071 2444987 2444987 defendant Hakker John yeoman 603616 603616 Hakker, John, of Cley next the Sea, yeoman 0
5303054 2445903 2445903 defendant Balston John draper 603616 603616 (Balston, John, of Cley next the sea, draper 5
5303186 2445945 2445945 defendant Hokker John husbandman 603616 603616 Hokker, John, of Cley next the sea, husbandman 0
5310327 2448119 2448119 defendant Hecker John yeoman 603616 603616 Hecker, John, of Cley next the Sea, yeoman 1
5366441 2465158 2465158 defendant Hulle Edmund mariner 603616 603616 Hulle, Edmund, of Cley next the sea, mariner 1
5369554 2466064 2466064 defendant Skennesby John butcher 603616 603616 Skennesby, John, of Cley next the Sea, butcher 0
5384526 2470658 2470658 defendant Pyrt Robert   603616 603616 Pyrt, Robert, of Cley next the Sea, tallow chandler 0
5385456 2470911 2470911 defendant Broun Simon yeoman 603616 603616 Broun, Simon, of Cley next the sea, yeoman 1
5385457 2470911 2470911 defendant Child Thomas yeoman 603616 603616 Child, Thomas, of Cley next the sea, yeoman 2
5386958 2471337 2471337 defendant Skendelesby Roger yeoman 603616 603616 Skendelesby, Roger, of Cley next the Sea, yeoman 0
5390715 2472405 2472405 defendant (illegible) Thomas yeoman 603616 603616 _, Thomas, of Cley next the sea, yeoman 0
5392816 2473016 2473016 plaintiff Skendelby Roger   603616 603616 Skendelby, Roger, of Cley next the sea 0
5395684 2473847 2473847 defendant Collys Thomas yeoman 603616 603616 Collys, Thomas, of Cley next the sea, yeoman 0
5400699 2475262 2475262 defendant Yemmys John   603616 603616 Yemmys, John, of Cley next the sea, shoe maker 1
5410011 2477960 2477960 defendant Willys William yeoman 603616 603616 Willys, William, of Cley next the sea, yeoman 13
5413393 2478936 2478936 defendant Pyktoo Robert   603616 603616 Pyktoo, Robert, of Cley next the sea 0
5413394 2478936 2478936 defendant Cillys Thomas yeoman 603616 603616 Cillys, Thomas, of Cley next the sea, yeoman 1
5415006 2479420 2479420 defendant Bacon William   603616 603616 Bacon, William, of Cley next the sea, pedlar 3
5419547 2480767 2480767 defendant Pyrte Robert   603616 603616 Pyrte, Robert, of Cley next the sea, tallow chandler 0
5428698 2483498 2483498 defendant Ponyour Richard shearman 603616 603616 Ponyour, Richard, of Cley next the sea, shearman 3
5428706 2483499 2483499 defendant Ponyour Richard sheerman 603616 603616 Ponyour, Richard, of Cley next the sea, sheerman 3
5428711 2483500 2483500 defendant Pyktoo Robert yeoman 603616 603616 Pyktoo, Robert, of Cley next the sea, yeoman 0
5428713 2483501 2483501 defendant Pyktoo Robert yeoman 603616 603616 Pyktoo, Robert, of Cley next the Sea, yeoman 0
5430779 2484144 2484144 defendant Brygge John gent 603616 603616 Brygge, John, of Cley next the Sea, gent 10
5435080 2485424 2485424 defendant Laurence Robert yeoman 603616 603616 Laurence, Robert, of Cley next the sea, yeoman 0
5443451 2487955 2487955 defendant Willys William yeoman 603616 603616 Willys, William, of Cley next the sea, yeoman 1
5443722 2488045 2488045 defendant Yemmes John shoemaker 603616 603616 Yemmes, John, of Cley next the sea, shoemaker 2
5445957 2488679 2488679 defendant Ponyour Richard sheerman 603616 603616 Ponyour, Richard, of Cley next the sea, sheerman 3
5445962 2488680 2488680 defendant Pyktoo Robert yeoman 603616 603616 Pyktoo, Robert, of Cley next the Sea, yeoman 0
5456173 2491764 2491764 defendant Wyllys William yeoman 603616 603616 Wyllys, William, of Cley next the sea, yeoman 1

Next page

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