names

78 rows where place_id = 669115

✎ 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
3991869 2021848 2021848 plaintiff Browne John gent 669115 669115 Browne, John, of Skirbek, gent 0
4441472 2182271 2182271 plaintiff Botiller Richard   669115 669115 Botiller, Richard, of Skirbek 0
4458934 2187841 2187841 defendant Saundresson John   669115 669115 Saundresson, John, of Skirbek 5
4480818 2194666 2194666 defendant Everay Jaceminus   669115 669115 Everay, Jaceminus, of Skirbek 0
4499777 2200562 2200562 defendant Murre Peter, junior   669115 669115 Murre, Peter, junior, of Skirbek 0
4507988 2202965 2202965 defendant Marche John   669115 669115 Marche, John, of Skirbek 0
4518695 2206221 2206221 plaintiff Doo Willam   669115 669115 Doo, Willam, of Skirbek 0
4526894 2208690 2208690 defendant Teleby William   669115 669115 Teleby, William, of Skirbek 0
4557694 2218341 2218341 defendant Marche John   669115 669115 Marche, John, of Skirbek 0
4560938 2219374 2219374 defendant Michell John fishmonger 669115 669115 Michell, John, of Skirbek, fishmonger 1
4602317 2231941 2231941 plaintiff Wedewe Thomas   669115 669115 Wedewe, Thomas, of Skirbek 0
4604082 2232445 2232445 defendant Marche Robert   669115 669115 Marche, Robert, of Skirbek 0
4604083 2232445 2232445 defendant Busche Simon   669115 669115 Busche, Simon, of Skirbek 1
4604084 2232445 2232445 defendant Busche Athelard   669115 669115 Busche, Athelard, of Skirbek 2
4604085 2232445 2232445 defendant Watson Busche William   669115 669115 Watson Busche, William, of Skirbek 3
4604086 2232445 2232445 defendant Abraham John   669115 669115 Abraham, John, of Skirbek 4
4604087 2232445 2232445 defendant Diconson Morre John   669115 669115 Diconson Morre, John, of Skirbek 5
4641715 2243677 2243677 defendant Marche John   669115 669115 Marche, John, of Skirbek 1
4659778 2248908 2248908 defendant Marche John husbandman 669115 669115 Marche, John, of Skirbek, husbandman 0
4675650 2257993 2257993 defendant Beke John chapman 669115 669115 Beke, John, of Skirbek, chapman 3
4679500 2259202 2259202 defendant Busshy William, junior fisher 669115 669115 Busshy, William, junior, of Skirbek, fisher 0
4687898 2261779 2261779 defendant Gretham Thomas de chaplain 669115 669115 Gretham, Thomas de, of Skirbek, chaplain 0
4688108 2261850 2261850 defendant Drowery Simon fowler 669115 669115 Drowery, Simon, of Skirbek, fowler 0
4688113 2261851 2261851 defendant Drowery Randolf husbandman 669115 669115 Drowery, Randolf, of Skirbek, husbandman 1
4716771 2270568 2270568 defendant Abraham Stephen fisher 669115 669115 Abraham, Stephen, of Skirbek, fisher 0
4717089 2270674 2270674 defendant Flayne Richard carter 669115 669115 Flayne, Richard, of Skirbek, carter 0
4731342 2275004 2275004 plaintiff Morton Robert   669115 669115 Morton, Robert, of Skirbek, parson 0
4736570 2276569 2276569 defendant Taillour Lambert draper 669115 669115 Taillour, Lambert, of Skirbek, draper 2
4746521 2279474 2279474 defendant Gelson William husbandman 669115 669115 Gelson, William, of Skirbek, husbandman 3
4759561 2283331 2283331 defendant Overay John husbandman 669115 669115 Overay, John, of Skirbek, husbandman 0
4764263 2284816 2284816 defendant Gelson Thomas gent 669115 669115 Gelson, Thomas, of Skirbek, gent 0
4768240 2286038 2286038 plaintiff Morton Robert   669115 669115 Morton, Robert, of Skirbek, parson 0
4768242 2286039 2286039 plaintiff Morton Robert   669115 669115 Morton, Robert, of Skirbek, parson of the parish church 0
4768243 2286039 2286039 defendant Thomson Alan husbandman 669115 669115 Thomson, Alan, of Skirbek, husbandman 0
4768244 2286039 2286039 defendant Overay John husbandman 669115 669115 Overay, John, of Skirbek, husbandman 1
4768245 2286039 2286039 defendant Wiske Henry yeoman 669115 669115 Wiske, Henry, of Skirbek, yeoman 2
4768246 2286039 2286039 defendant Overay Robert husbandman 669115 669115 Overay, Robert, of Skirbek, husbandman 3
4771395 2287035 2287035 defendant Paulyn John husbandman 669115 669115 Paulyn, John, of Skirbek, husbandman 1
4771396 2287035 2287035 defendant Marche Robert (legal representative) 669115 669115 Marche, Robert, of Skirbek, executors of 2
4803613 2297316 2297316 defendant March John, junior husbandman 669115 669115 March, John, junior, of Skirbek, husbandman 3
4807915 2298660 2298660 defendant Overay Robert husbandman 669115 669115 Overay, Robert, of Skirbek, husbandman 0
4819017 2302028 2302028 defendant Marche John   669115 669115 Marche, John, of Skirbek, husbandman, son of Robert Marche 0
4822720 2303184 2303184 defendant Smyth Kkatherine laborer 669115 669115 Smyth, Kkatherine, of Skirbek, laborer 1
4850007 2311472 2311472 defendant Overa Robert yeoman 669115 669115 Overa, Robert, of Skirbek, yeoman 3
4852086 2312084 2312084 defendant Derby William chapman alias yeoman 669115 669115 Derby, William, of Skirbek, chapman alias yeoman 0
4861169 2314853 2314853 defendant Overey Robert husbandman 669115 669115 Overey, Robert, of Skirbek, husbandman 1
4865362 2316134 2316134 defendant Boteler Eleanor widow 669115 669115 Boteler, Eleanor, of Skirbek, widow 2
4867108 2316675 2316675 defendant Forman John, senior husbandman 669115 669115 Forman, John, senior, of Skirbek, husbandman 0
4869177 2317338 2317338 defendant Ward Henry husbandman 669115 669115 Ward, Henry, of Skirbek, husbandman 0
4869178 2317338 2317338 defendant Potter Ranulph husbandman 669115 669115 Potter, Ranulph, of Skirbek, husbandman 1
4869179 2317338 2317338 defendant Murre Thomas husbandman 669115 669115 Murre, Thomas, of Skirbek, husbandman 2
4884300 2321996 2321996 defendant Fendyk Richard husbandman 669115 669115 Fendyk, Richard, of Skirbek, husbandman 2
4901046 2326952 2326952 defendant Murre John husbandman 669115 669115 Murre, John, of Skirbek, husbandman 2
4901047 2326952 2326952 defendant Warde Henry husbandman 669115 669115 Warde, Henry, of Skirbek, husbandman 3
4901048 2326952 2326952 defendant Warrewyk Richard husbandman 669115 669115 Warrewyk, Richard, of Skirbek, husbandman 4
4926583 2334731 2334731 defendant Bouer John laborer 669115 669115 Bouer, John, of Skirbek, laborer 5
4954155 2343212 2343212 defendant Hudson Simon smith 669115 669115 Hudson, Simon, of Skirbek, smith 2
4956356 2343864 2343864 defendant Enold Robert husbandman 669115 669115 (Enold, Robert, of Skirbek, husbandman 1
4958634 2344550 2344550 defendant Race Reginald husbandman 669115 669115 Race, Reginald, of Skirbek, husbandman 0
4960462 2345094 2345094 defendant Warwyke Richard husbandman 669115 669115 Warwyke, Richard, of Skirbek, husbandman 0
5093315 2384441 2384441 defendant Couper Philip yeoman 669115 669115 Couper, Philip, of Skirbek, yeoman 0
5114513 2390644 2390644 defendant Warde John husbandman 669115 669115 Warde, John, of Skirbek, husbandman 0
5119788 2392225 2392225 defendant Proctour John husbandman 669115 669115 Proctour, John, of Skirbek, husbandman 4
5161724 2404531 2404531 defendant Warwyk Richard husbandman 669115 669115 Warwyk, Richard, of Skirbek, husbandman 0
5162506 2404763 2404763 defendant Horsley John laborer 669115 669115 Horsley, John, of Skirbek, laborer 0
5162508 2404763 2404763 defendant Payntour John laborer 669115 669115 Payntour, John, of Skirbek, laborer 2
5162513 2404764 2404764 defendant Payntour John laborer 669115 669115 Payntour, John, of Skirbek, laborer 1
5182613 2410671 2410671 defendant Warde John husbandman 669115 669115 Warde, John, of Skirbek, husbandman 1
5198015 2415158 2415158 defendant Fyrsshney William   669115 669115 Fyrsshney, William, of Skirbek, tile maker 0
5200164 2415801 2415801 defendant Wright Richard husbandman 669115 669115 Wright, Richard, of Skirbek, husbandman 2
5228014 2423805 2423805 defendant Colyour Alan laborer 669115 669115 Colyour, Alan, of Skirbek, laborer 1
5237898 2426667 2426667 defendant Harnes John husbandman 669115 669115 Harnes, John, of Skirbek, husbandman 0
5278897 2438939 2438939 defendant Roper Henry husbandman 669115 669115 Roper, Henry, of Skirbek, husbandman 2
5295434 2443657 2443657 defendant Albene John   669115 669115 Albene, John, of Skirbek, shipwright 1
5320773 2451303 2451303 defendant Proctour Philip yeoman 669115 669115 Proctour, Philip, of Skirbek, yeoman 2
5510110 2507998 2507998 defendant Swag John husbandman 669115 669115 Swag, John, of Skirbek, husbandman 3
5618713 2549689 2549689 plaintiff Murre John   669115 669115 Murre, John, of Skirbek 0
5619008 2549792 2549792 defendant Neucomen William   669115 669115 Neucomen, William, of Skirbek 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);