names

139 rows where place_id = 598642

✎ 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
3602753 1868528 1868528 plaintiff Cheyne Thomas   598642 598642 Cheyne, Thomas, of Irtlyngburgh, knight 0
3633395 1905258 1905258 defendant Berrewyke Thomas husbandman 598642 598642 Berrewyke, Thomas, of Irtlyngburgh, husbandman 1
3640110 1907352 1907352 defendant Grene Thomas husbandman 598642 598642 Grene, Thomas, of Irtlyngburgh, husbandman 2
3756813 1944103 1944103 defendant Drage Thomas husbandman 598642 598642 Drage, Thomas, of irtlyngburgh, husbandman 0
3851974 1974207 1974207 defendant Brage or Drage Thomas husbandman 598642 598642 Brage or Drage, Thomas, of Irtlyngburgh, husbandman 0
4453486 2186096 2186096 defendant Smyth Thomas   598642 598642 Smyth, Thomas, of Irtlyngburgh 0
4469120 2191010 2191010 defendant Chaundelere John   598642 598642 Chaundelere, John, of Irtlyngburgh 0
4477727 2193699 2193699 defendant Ratheby Thomas   598642 598642 Ratheby, Thomas, of Irtlyngburgh 0
4484491 2195841 2195841 defendant Coke Thomas   598642 598642 Coke, Thomas, of Irtlyngburgh 0
4503530 2201678 2201678 defendant Pyel Nicholas   598642 598642 Pyel, Nicholas, of Irtlyngburgh 0
4503531 2201678 2201678 defendant Parkere John   598642 598642 Parkere, John, of Irtlyngburgh 1
4511012 2203893 2203893 defendant Trewe John   598642 598642 Trewe, John, of Irtlyngburgh 1
4513927 2204776 2204776 defendant Forthyngton John   598642 598642 Forthyngton, John, of Irtlyngburgh 0
4526579 2208590 2208590 defendant Pyell Nicholas   598642 598642 Pyell, Nicholas, of Irtlyngburgh 0
4528486 2209190 2209190 defendant Body William   598642 598642 Body, William, of Irtlyngburgh 0
4528490 2209191 2209191 defendant Body William   598642 598642 Body, William, of Irtlyngburgh 0
4528492 2209191 2209191 defendant Cokes Geoffrey   598642 598642 Cokes, Geoffrey, of Irtlyngburgh 2
4528493 2209191 2209191 defendant Forthyngton John   598642 598642 Forthyngton, John, of Irtlyngburgh 3
4532637 2210475 2210475 plaintiff Pyel Nicholas   598642 598642 Pyel, Nicholas, of Irtlyngburgh 0
4532638 2210475 2210475 defendant Ratheby Thomas   598642 598642 Ratheby, Thomas, of Irtlyngburgh 0
4532640 2210476 2210476 plaintiff Pyell Nicholas   598642 598642 Pyell, Nicholas, of Irtlyngburgh 0
4532993 2210590 2210590 defendant Flaun or Flaim John   598642 598642 Flaun or Flaim, John, of Irtlyngburgh 1
4532998 2210591 2210591 defendant Stones Agnes   598642 598642 Stones, Agnes, of Irtlyngburgh 2
4533010 2210593 2210593 defendant Baker Richard   598642 598642 Baker, Richard, of Irtlyngburgh 3
4545278 2214446 2214446 defendant Cokes Geoffrey   598642 598642 Cokes, Geoffrey, of Irtlyngburgh 0
4559352 2218877 2218877 defendant Geffye Thomas   598642 598642 Geffye, Thomas, of Irtlyngburgh 0
4561872 2219646 2219646 defendant Pyel Nicholas   598642 598642 Pyel, Nicholas, of Irtlyngburgh 0
4561874 2219647 2219647 defendant Ratheby Thomas   598642 598642 Ratheby, Thomas, of Irtlyngburgh 0
4569685 2222102 2222102 defendant Body William   598642 598642 Body, William, of Irtlyngburgh 0
4593981 2229391 2229391 defendant Lord Richard   598642 598642 Lord, Richard, of Irtlyngburgh 0
4618875 2236898 2236898 defendant Ratheby Thomas   598642 598642 Ratheby, Thomas, of Irtlyngburgh 0
4619409 2237063 2237063 defendant Geffes Thomas   598642 598642 Geffes, Thomas, of Irtlyngburgh 0
4652004 2246562 2246562 defendant Medebourne Thomas   598642 598642 Medebourne, Thomas, of Irtlyngburgh 0
4654382 2247244 2247244 defendant Trewes John husbandman 598642 598642 Trewes, John, of Irtlyngburgh, husbandman 0
4654383 2247244 2247244 defendant Hayward John husbandman 598642 598642 Hayward, John, of Irtlyngburgh, husbandman 1
4663498 2250059 2250059 defendant Lord Richard   598642 598642 Lord, Richard, of Irtlyngburgh, franklin 0
4663499 2250059 2250059 defendant Warde John husbandman 598642 598642 Warde, John, of Irtlyngburgh, husbandman 1
4663500 2250059 2250059 defendant Ratheby Thomas husbandman 598642 598642 Ratheby, Thomas, of Irtlyngburgh, husbandman 2
4669293 2256105 2256105 defendant Taillour John thresher 598642 598642 Taillour, John, of Irtlyngburgh, thresher 0
4676583 2258293 2258293 defendant Galdecote John husbandman 598642 598642 Galdecote, John, of Irtlyngburgh, husbandman 0
4676584 2258293 2258293 defendant Wmygh William ploughman 598642 598642 Wmygh, William, of Irtlyngburgh, ploughman 1
4683750 2260520 2260520 defendant Caldecote John husbandman 598642 598642 Caldecote, John, of Irtlyngburgh, husbandman 0
4683756 2260523 2260523 defendant Geffes Thomas husbandman 598642 598642 Geffes, Thomas, of Irtlyngburgh, husbandman 0
4697677 2264766 2264766 defendant Aylove Henry husbandman 598642 598642 Aylove, Henry, of Irtlyngburgh, husbandman 0
4697678 2264766 2264766 defendant Aylove John husbandman 598642 598642 Aylove, John, of Irtlyngburgh, husbandman 1
4702225 2266105 2266105 defendant Weldon William husbandman 598642 598642 Weldon, William, of Irtlyngburgh, husbandman 0
4703749 2266553 2266553 defendant Sayer John clerk 598642 598642 Sayer, John, of Irtlyngburgh, clerk 0
4703750 2266553 2266553 defendant Fryday William clerk 598642 598642 Fryday, William, of Irtlyngburgh, clerk 1
4709272 2268269 2268269 plaintiff Peek alias Peke William (legal representative) 598642 598642 Peek alias Peke, William, of Irtlyngburgh, parson of All Saints church, executors of 0
4709276 2268269 2268269 defendant More Thomas   598642 598642 More, Thomas, of Irtlyngburgh, dean of the collegiate church or St Peter 0
4711822 2269024 2269024 defendant Fyssher William husbandman 598642 598642 Fyssher, William, of Irtlyngburgh, husbandman 0
4711824 2269025 2269025 defendant Baker Richard husbandman 598642 598642 Baker, Richard, of Irtlyngburgh, husbandman 0
4711826 2269026 2269026 defendant Geffes Thomas husbandman 598642 598642 Geffes, Thomas, of Irtlyngburgh, husbandman 0
4713893 2269670 2269670 defendant Cook John husbandman 598642 598642 Cook, John, of Irtlyngburgh, husbandman 0
4732605 2275374 2275374 defendant More Thomas   598642 598642 More, Thomas, of Irtlyngburgh, deacon of the college of St Peter 0
4757532 2282736 2282736 defendant Aspelond John   598642 598642 Aspelond, John, of Irtlyngburgh, shepherd 0
4769743 2286507 2286507 defendant Wattes John husbandman 598642 598642 Wattes, John, of Irtlyngburgh, husbandman 3
4769744 2286507 2286507 defendant Higdon John husbandman 598642 598642 Higdon, John, of Irtlyngburgh, husbandman 4
4791119 2293322 2293322 defendant Geffes Thomas husbandman 598642 598642 Geffes, Thomas, of Irtlyngburgh, husbandman 0
4794266 2294346 2294346 defendant Wattes John husbandman 598642 598642 Wattes, John, of Irtlyngburgh, husbandman 3
4806167 2298135 2298135 defendant Beverygge John laborer 598642 598642 Beverygge, John, of Irtlyngburgh, laborer 3
4836037 2307252 2307252 defendant Hykeden John husbandman 598642 598642 Hykeden, John, of Irtlyngburgh, husbandman 1
4858097 2313905 2313905 plaintiff Braunspath William esq 598642 598642 Braunspath, William, of Irtlyngburgh, esq 0
4909012 2329362 2329362 plaintiff Baker Richard   598642 598642 Baker, Richard, of Irtlyngburgh 0
4909014 2329362 2329362 defendant Benerythe or Beverythe John husbandman 598642 598642 Benerythe or Beverythe, John, of Irtlyngburgh, husbandman 1
4909016 2329362 2329362 defendant Hykedon John husbandman 598642 598642 Hykedon, John, of Irtlyngburgh, husbandman 3
4911075 2329976 2329976 plaintiff Brauncepath William (legal representative) 598642 598642 Brauncepath, William, of Irtlyngburgh, knight, executrix of 0
4911079 2329977 2329977 plaintiff Brauncepath William (legal representative) 598642 598642 Brauncepath, William, of Irtlyngburgh, knight, executrix of 0
4928918 2335467 2335467 defendant Pekke John husbandman 598642 598642 Pekke, John, of Irtlyngburgh, husbandman 3
4931658 2336290 2336290 defendant Weldon John husbandman 598642 598642 Weldon, John, of Irtlyngburgh, husbandman 2
4931661 2336290 2336290 defendant Miles John husbandman 598642 598642 Miles, John, of Irtlyngburgh, husbandman 5
4951079 2342301 2342301 defendant Hunte John husbandman 598642 598642 Hunte, John, of Irtlyngburgh, husbandman 0
4951080 2342301 2342301 defendant Hunte William husbandman 598642 598642 Hunte, William, of Irtlyngburgh, husbandman 1
4951081 2342301 2342301 defendant Hunte Richard husbandman 598642 598642 Hunte, Richard, of Irtlyngburgh, husbandman 2
4957072 2344070 2344070 defendant Soffyngdale or Sossyngdale Robert laborer 598642 598642 Soffyngdale or Sossyngdale, Robert, of Irtlyngburgh, laborer 0
4957073 2344070 2344070 defendant Weldon William butcher 598642 598642 Weldon, William, of Irtlyngburgh, butcher 1
4957074 2344070 2344070 defendant Blofeld John husbandman 598642 598642 Blofeld, John, of Irtlyngburgh, husbandman 2
4957083 2344074 2344074 defendant Chaundeler William husbandman 598642 598642 Chaundeler, William, of Irtlyngburgh, husbandman 0
4963271 2345925 2345925 defendant Smyth William husbandman 598642 598642 Smyth, William, of Irtlyngburgh, husbandman 0
4968865 2347653 2347653 defendant Lorde John husbandman 598642 598642 Lorde, John, of Irtlyngburgh, husbandman 1
4968866 2347653 2347653 defendant Caldecote John husbandman 598642 598642 Caldecote, John, of Irtlyngburgh, husbandman 2
4977075 2350098 2350098 defendant Caldecote John yeoman 598642 598642 Caldecote, John, of Irtlyngburgh, yeoman 0
4983084 2351842 2351842 defendant Weldon William butcher 598642 598642 Weldon, William, of Irtlyngburgh, butcher 1
4983473 2351970 2351970 defendant Wedon William butcher 598642 598642 Wedon, William, of Irtlyngburgh, butcher 0
4983474 2351970 2351970 defendant Blofeld John husbandman 598642 598642 Blofeld, John, of Irtlyngburgh, husbandman 1
5004686 2358275 2358275 defendant Ppage Thomas yeoman 598642 598642 Ppage, Thomas, of Irtlyngburgh, yeoman 1
5004688 2358275 2358275 defendant Hunt Richard yeoman 598642 598642 Hunt, Richard, of Irtlyngburgh, yeoman 3
5013972 2360943 2360943 defendant Caldecote John courser 598642 598642 Caldecote, John, of Irtlyngburgh, courser 0
5039514 2368467 2368467 plaintiff Blanchard John   598642 598642 Blanchard, John, of Irtlyngburgh, dean of the collegiate church of St Peter 0
5047830 2370967 2370967 defendant Caldecote John yeoman 598642 598642 Caldecote, John, of Irtlyngburgh, yeoman 1
5086807 2382538 2382538 defendant Chaundeler William husbandman 598642 598642 Chaundeler, William, of Irtlyngburgh, husbandman 0
5086842 2382548 2382548 defendant Bloufeld John husbandman 598642 598642 Bloufeld, John, of Irtlyngburgh, husbandman 0
5101838 2386959 2386959 defendant Summerby John husbandman 598642 598642 Summerby, John, of Irtlyngburgh, husbandman 2
5102613 2387172 2387172 defendant Bloufeld or Blonfeld John husbandman 598642 598642 Bloufeld or Blonfeld, John, of Irtlyngburgh, husbandman 1
5114464 2390629 2390629 defendant Bacon John yeoman 598642 598642 Bacon, John, of Irtlyngburgh, yeoman 0
5114787 2390736 2390736 defendant Bacon John yeoman 598642 598642 Bacon, John, of Irtlyngburgh, yeoman 4
5117336 2391503 2391503 defendant Hikdon John   598642 598642 Hikdon, John, of Irtlyngburgh, fair carter 0
5122273 2392940 2392940 defendant Benet Thomas   598642 598642 Benet, Thomas, of Irtlyngburgh, shepherd 0
5133317 2396234 2396234 defendant Fyssher Thomas husbandman 598642 598642 Fyssher, Thomas, of Irtlyngburgh, husbandman 0
5137346 2397436 2397436 plaintiff Hicdon John   598642 598642 Hicdon, John, of Irtlyngburgh 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);