names

55 rows where place_id = 588497

✎ 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
3594726 1865974 1865974 defendant Alsy John clothmaker 588497 588497 Alsy, John, of Holyngbourn, clothmaker 0
3607662 1870051 1870051 defendant at Wode Thomas carpenter 588497 588497 at Wode, Thomas, of Holyngbourn, carpenter 1
3619495 1873662 1873662 defendant Beket Simon husbandman 588497 588497 Beket, Simon, of Holyngbourn, husbandman 0
3680178 1919873 1919873 plaintiff Raynold William   588497 588497 Raynold, William, of Holyngbourn 0
3742287 1939459 1939459 plaintiff Tong John   588497 588497 Tong, John, of Holyngbourn 0
3766758 1947264 1947264 defendant Atwode Henry husbandman 588497 588497 Atwode, Henry, of Holyngbourn, husbandman 0
3834830 1968833 1968833 defendant Rede William yoman 588497 588497 Rede, William, of Holyngbourn, yoman 0
4646475 2245033 2245033 defendant Eyet John   588497 588497 Eyet, John, of Holyngbourn 0
4646476 2245033 2245033 defendant Dygon Richard   588497 588497 Dygon, Richard, of Holyngbourn 1
4660548 2249123 2249123 defendant Hebbe John miller 588497 588497 Hebbe, John, of Holyngbourn, miller 3
4731312 2274993 2274993 defendant Tomelyn Emericus tailor 588497 588497 Tomelyn, Emericus, of Holyngbourn, tailor 1
4758112 2282911 2282911 defendant Davy James, sen weaver 588497 588497 Davy, James, sen, of Holyngbourn, weaver 2
4783253 2290781 2290781 defendant Eyette John yeoman 588497 588497 Eyette, John, of Holyngbourn, yeoman 0
4783262 2290784 2290784 defendant Eyette John yeoman 588497 588497 Eyette, John, of Holyngbourn, yeoman 0
4817132 2301450 2301450 plaintiff Meller Thomas   588497 588497 Meller, Thomas, of Holyngbourn 0
4817134 2301450 2301450 defendant Pageherst John laborer 588497 588497 Pageherst, John, of Holyngbourn, laborer 1
4875027 2319137 2319137 defendant Clethe William clerk 588497 588497 Clethe, William, of Holyngbourn, clerk 0
4897010 2325716 2325716 defendant Gyot John gent 588497 588497 Gyot, John, of Holyngbourn, gent 0
4897011 2325716 2325716 defendant Dygon Richard husbandman 588497 588497 Dygon, Richard, of Holyngbourn, husbandman 1
4959647 2344846 2344846 defendant Santer or Sauter Richard glover 588497 588497 Santer or Sauter, Richard, of Holyngbourn, glover 0
5078212 2379968 2379968 defendant Taillour John laborer 588497 588497 Taillour, John, of Holyngbourn, laborer 0
5200386 2415874 2415874 defendant Pyx John husbandman 588497 588497 Pyx, John, of Holyngbourn, husbandman 0
5200388 2415875 2415875 defendant Pyx John husbandman 588497 588497 Pyx, John, of Holyngbourn, husbandman 0
5264114 2434535 2434535 defendant Geryng William husbandman 588497 588497 Geryng, William, of Holyngbourn, husbandman 2
5269834 2436284 2436284 defendant Pycot John yeoman 588497 588497 Pycot, John, of Holyngbourn, yeoman 3
5281412 2439634 2439634 defendant Pycot John yeoman 588497 588497 Pycot, John, of Holyngbourn, yeoman 4
5281416 2439635 2439635 defendant Gylys Thomas summoner 588497 588497 Gylys, Thomas, of Holyngbourn, summoner 2
5281418 2439635 2439635 defendant Craft Edmund (legal representative) 588497 588497 Craft, Edmund, of Holyngbourn, smith, executors of 4
5289696 2441989 2441989 defendant Wode Thomas carpenter 588497 588497 Wode, Thomas, of Holyngbourn, carpenter 0
5289697 2441989 2441989 defendant Scot Thomas husbandman 588497 588497 Scot, Thomas, of Holyngbourn, husbandman 1
5300168 2445012 2445012 defendant Geryng William laborer 588497 588497 Geryng, William, of Holyngbourn, laborer 2
5315003 2449540 2449540 defendant Ayot John yeoman 588497 588497 Ayot, John, of Holyngbourn, yeoman, son of Ayot, William, yeoman 0
5315004 2449540 2449540 defendant Fylcotte William yeoman 588497 588497 Fylcotte, William, of Holyngbourn, yeoman 1
5315413 2449670 2449670 defendant Geryng William husbandman 588497 588497 Geryng, William, of Holyngbourn, husbandman 0
5325351 2452668 2452668 defendant Roinyng or Romyng William husbandman 588497 588497 Roinyng or Romyng, William, of Holyngbourn, husbandman 2
5325372 2452675 2452675 defendant Fyssher John husbandman 588497 588497 Fyssher, John, of Holyngbourn, husbandman 1
5354109 2461350 2461350 plaintiff Bedmanton Thomas yeoman 588497 588497 Bedmanton, Thomas, of Holyngbourn, yeoman 1
5358217 2462627 2462627 defendant Wode Thomas husbandman 588497 588497 Wode, Thomas, of Holyngbourn, husbandman 0
5360198 2463232 2463232 defendant Pygot John husbandman 588497 588497 Pygot, John, of Holyngbourn, husbandman 0
5361218 2463535 2463535 defendant Fylcot William husbandman 588497 588497 Fylcot, William, of Holyngbourn, husbandman 0
5361220 2463535 2463535 defendant atte Wode Thomas carpenter 588497 588497 atte Wode, Thomas, of Holyngbourn, carpenter 2
5374212 2467534 2467534 defendant Kyngesdowne William tailor 588497 588497 Kyngesdowne, William, of Holyngbourn, tailor 3
5376512 2468250 2468250 defendant Kyngesdowne William tailor 588497 588497 Kyngesdowne, William, of Holyngbourn, tailor 3
5385517 2470929 2470929 defendant Ayt John husbandman 588497 588497 Ayt, John, of Holyngbourn, husbandman 0
5430144 2483952 2483952 defendant Kygesdoun William tailor 588497 588497 Kygesdoun, William, of Holyngbourn, tailor 0
5441510 2487383 2487383 defendant Baker Lawrence husbandman 588497 588497 Baker, Lawrence, of Holyngbourn, husbandman 0
5446990 2488991 2488991 defendant (illegible) William tailor 588497 588497 _, William, of Holyngbourn, tailor 0
5454287 2491193 2491193 defendant Baker Lawrence husbandman 588497 588497 Baker, Lawrence, of Holyngbourn, husbandman 0
5466164 2494822 2494822 defendant Baker Lawrence husbandman 588497 588497 Baker, Lawrence, of Holyngbourn, husbandman 0
5493012 2502817 2502817 defendant Peny William husbandman 588497 588497 Peny, William, of Holyngbourn, husbandman 1
5493014 2502817 2502817 defendant Greneherst John butcher 588497 588497 Greneherst, John, of Holyngbourn, butcher 3
5509756 2507882 2507882 defendant Ewen John husbandman 588497 588497 Ewen, John, of Holyngbourn, husbandman 1
5517261 2510233 2510233 defendant Waryn John laborer 588497 588497 Waryn, John, of Holyngbourn, laborer 1
5521141 2511427 2511427 defendant Highsted John husbandman 588497 588497 Highsted, John, of Holyngbourn, husbandman 2
5584340 2530167 2530167 defendant Seman John yeoman 588497 588497 Seman, John, of Holyngbourn, yeoman 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);