names

75 rows where place_id = 764902

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4511053 2203908 2203908 defendant Brygyngdon William   764902 764902 Brygyngdon, William, of Axebrigge 0
4522557 2207393 2207393 defendant Welles John   764902 764902 Welles, John, of Axebrigge 0
4522559 2207393 2207393 defendant Puyte Christine   764902 764902 Puyte, Christine, of Axebrigge 2
4529490 2209505 2209505 defendant Furnour Robert   764902 764902 Furnour, Robert, of Axebrigge 0
4531335 2210077 2210077 defendant Hayne John   764902 764902 Hayne, John, of Axebrigge 1
4531336 2210077 2210077 defendant Fournour Stephen   764902 764902 Fournour, Stephen, of Axebrigge 2
4531338 2210077 2210077 defendant Payn Thomas   764902 764902 Payn, Thomas, of Axebrigge 4
4604212 2232488 2232488 defendant Spryng William   764902 764902 Spryng, William, of Axebrigge 0
4651420 2246449 2246449 defendant Reede John tanner 764902 764902 Reede, John, of Axebrigge, tanner 0
4679616 2259242 2259242 defendant Merser Henry tanner 764902 764902 Merser, Henry, of Axebrigge, tanner 0
4679617 2259242 2259242 defendant Nony or Novy Thomas merchant 764902 764902 Nony or Novy, Thomas, of Axebrigge, merchant 1
4679618 2259242 2259242 defendant Lyrebeke Thomas shoemaker 764902 764902 Lyrebeke, Thomas, of Axebrigge, shoemaker 2
4679619 2259242 2259242 defendant Frensshe Robert shoemaker 764902 764902 Frensshe, Robert, of Axebrigge, shoemaker 3
4679620 2259242 2259242 defendant Cade Richard shoemaker 764902 764902 Cade, Richard, of Axebrigge, shoemaker 4
4679621 2259242 2259242 defendant Yoman Henry tanner 764902 764902 with Yoman, Henry, of Axebrigge, tanner 5
4679623 2259243 2259243 defendant Yoman Henry tanner 764902 764902 Yoman, Henry, of Axebrigge, tanner 0
4696221 2264301 2264301 defendant Russell Thomas husbandman 764902 764902 Russell, Thomas, of Axebrigge, husbandman 0
4701263 2265795 2265795 defendant Nony Thomas gent 764902 764902 Nony, Thomas, of Axebrigge, gent 0
4701646 2265907 2265907 defendant Spryng William baker 764902 764902 Spryng, William, of Axebrigge, baker 3
4708379 2267989 2267989 defendant fitz Thomas husbandman 764902 764902 fitz, Thomas, of Axebrigge, husbandman 0
4708380 2267989 2267989 defendant Fitz John husbandman 764902 764902 together with Fitz, John, of Axebrigge, husbandman 1
4708382 2267990 2267990 defendant fitz John husbandman 764902 764902 fitz, John, of Axebrigge, husbandman 0
4708383 2267990 2267990 defendant Fitz Thomas husbandman 764902 764902 together with Fitz, Thomas, of Axebrigge, husbandman 1
4747820 2279870 2279870 defendant Rede Thomas tanner 764902 764902 Rede, Thomas, of Axebrigge, tanner 0
4765398 2285162 2285162 defendant Punter John   764902 764902 Punter, John, of Axebrigge, shoe maker 0
4765399 2285162 2285162 defendant Martyn Walter husbandman 764902 764902 Martyn, Walter, of Axebrigge, husbandman 1
4765400 2285162 2285162 defendant Pedewell John   764902 764902 Pedewell, John, of Axebrigge, shoe maker 2
4780429 2289877 2289877 defendant Payn William husbandman 764902 764902 Payn, William, of Axebrigge, husbandman 0
4795882 2294863 2294863 defendant Waleys John husbandman 764902 764902 Waleys, John, of Axebrigge, husbandman 0
4795883 2294863 2294863 defendant Wodeward Roger husbandman 764902 764902 Wodeward, Roger, of Axebrigge, husbandman 1
4795884 2294863 2294863 defendant Tremell Philip husbandman 764902 764902 Tremell, Philip, of Axebrigge, husbandman 2
4802961 2297112 2297112 defendant Crodemede John dyer 764902 764902 Crodemede, John, of Axebrigge, dyer 0
4806696 2298303 2298303 defendant Lane Thomas tanner 764902 764902 Lane, Thomas, of Axebrigge, tanner 0
4806822 2298344 2298344 defendant Kyngdon John shoemaker 764902 764902 Kyngdon, John, of Axebrigge, shoemaker 2
4811594 2299735 2299735 defendant Courteys John husbandman 764902 764902 Courteys, John, of Axebrigge, husbandman 0
4824165 2303632 2303632 defendant Kyngdon John shoemaker 764902 764902 Kyngdon, John, of Axebrigge, shoemaker 1
4825931 2304141 2304141 defendant Webbe John fisher & son of William Webbe 764902 764902 Webbe, John, of Axebrigge, fisher & son of William Webbe 2
4826435 2304305 2304305 defendant Spere John shoemaker 764902 764902 Spere, John, of Axebrigge, shoemaker 1
4826436 2304305 2304305 defendant Lane Thomas tanner 764902 764902 Lane, Thomas, of Axebrigge, tanner 2
4826437 2304305 2304305 defendant William John shoemaker 764902 764902 William, John, of Axebrigge, shoemaker 3
4827527 2304657 2304657 defendant Aprys William merchant 764902 764902 Aprys, William, of Axebrigge, merchant 0
4827593 2304681 2304681 defendant Crodemede John dyer 764902 764902 Crodemede, John, of Axebrigge, dyer 0
4833108 2306373 2306373 defendant Kyngton John shoemaker 764902 764902 Kyngton, John, of Axebrigge, shoemaker 5
4833123 2306375 2306375 defendant Wodeward Roger   764902 764902 Wodeward, Roger, of Axebrigge, shoe maker 0
4833125 2306375 2306375 defendant Arnold Thomas   764902 764902 Arnold, Thomas, of Axebrigge, shoe maker 2
4833126 2306375 2306375 defendant Wyther John summoner 764902 764902 Wyther, John, of Axebrigge, summoner 3
4833131 2306376 2306376 defendant Yevan John tanner 764902 764902 Yevan, John, of Axebrigge, tanner 3
4833135 2306376 2306376 defendant Kyngdon John   764902 764902 Kyngdon, John, of Axebrigge, shoe maker 7
4833136 2306376 2306376 defendant Hilpe Richard tanner 764902 764902 Hilpe, Richard, of Axebrigge, tanner 8
4833142 2306377 2306377 defendant fitz John   764902 764902 fitz, John, of Axebrigge, parish clerk 0
4833143 2306377 2306377 defendant Wodeward Roger   764902 764902 Wodeward, Roger, of Axebrigge, shoe maker 1
4852636 2312246 2312246 defendant Spryng John, sen tanner 764902 764902 Spryng, John, sen, of Axebrigge, tanner 0
4852637 2312246 2312246 defendant Wether John summoner 764902 764902 Wether, John, of Axebrigge, summoner 1
4852640 2312246 2312246 defendant Doune John husbandman 764902 764902 Doune, John, of Axebrigge, husbandman 4
4852641 2312246 2312246 defendant Skynner Richard husbandman 764902 764902 Skynner, Richard, of Axebrigge, husbandman 5
4878207 2320135 2320135 defendant Kyngdon John shoemaker 764902 764902 Kyngdon, John, of Axebrigge, shoemaker 1
4997436 2356082 2356082 defendant Hayne John fuller 764902 764902 Hayne, John, of Axebrigge, fuller 1
5050078 2371645 2371645 defendant Smok Thomas clothmaker 764902 764902 Smok, Thomas, of Axebrigge, clothmaker 0
5050079 2371645 2371645 defendant Wyther John clothmaker 764902 764902 Wyther, John, of Axebrigge, clothmaker 1
5067382 2376752 2376752 defendant Fitz John   764902 764902 Fitz, John, of Axebrigge, court holder 0
5070603 2377703 2377703 defendant Kyngdon Christine widow 764902 764902 Kyngdon, Christine, of Axebrigge, widow 1
5082426 2381240 2381240 defendant Fitz John   764902 764902 Fitz, John, of Axebrigge 5
5107845 2388731 2388731 defendant Payne John merchant 764902 764902 Payne, John, of Axebrigge, merchant 0
5121239 2392643 2392643 defendant Hayne John tucker 764902 764902 Hayne, John, of Axebrigge, tucker 0
5121240 2392643 2392643 defendant Gryce John tucker 764902 764902 Gryce, John, of Axebrigge, tucker 1
5136027 2397048 2397048 defendant Roynon John gent 764902 764902 Roynon, John, of Axebrigge, gent 0
5136029 2397048 2397048 defendant Roynon William, junior gent 764902 764902 Roynon, William, junior, of Axebrigge, gent 2
5136031 2397049 2397049 defendant Roynon John gent 764902 764902 Roynon, John, of Axebrigge, gent 0
5136033 2397049 2397049 defendant Roynon William gent 764902 764902 Roynon, William, of Axebrigge, gent 2
5192148 2413432 2413432 defendant Roynon John gent 764902 764902 Roynon, John, of Axebrigge, gent 0
5353803 2461257 2461257 defendant Wareyn Thomas chaplain 764902 764902 Wareyn, Thomas, of Axebrigge, chaplain 0
5353804 2461257 2461257 defendant Cachemay Thomas tucker 764902 764902 Cachemay, Thomas, of Axebrigge, tucker 1
5353805 2461257 2461257 defendant Hopkyns John tucker 764902 764902 Hopkyns, John, of Axebrigge, tucker 2
5353806 2461257 2461257 defendant Pole John   764902 764902 Pole, John, of Axebrigge, millward 3
5353807 2461257 2461257 defendant Mersshe John mercer 764902 764902 Mersshe, John, of Axebrigge, mercer 4

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