names

123 rows where place_id = 589494

✎ 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
3597786 1866924 1866924 defendant Brygdale Nicholas husbandman 589494 589494 Brygdale, Nicholas, of Northflete, husbandman 2
3618366 1873376 1873376 defendant Wombewell John gent 589494 589494 Wombewell, John, of Northflete, gent 0
3633245 1905213 1905213 defendant Page William husbandman 589494 589494 Page, William, of Northflete, husbandman 0
3651576 1910847 1910847 defendant Pyerce Robert husbandman 589494 589494 Pyerce, Robert, of Northflete, husbandman 0
3653497 1911359 1911359 plaintiff Womwell John gent 589494 589494 Womwell, John, of Northflete, gent 0
3666426 1915450 1915450 defendant Clement John butcher 589494 589494 Clement, John, of Northflete, butcher 0
3678727 1919414 1919414 defendant Fyrmynger William laborer 589494 589494 Fyrmynger, William, of Northflete, laborer 0
3680180 1919873 1919873 defendant Maye Thomas husbandman 589494 589494 Maye, Thomas, of Northflete, husbandman 1
3687690 1922318 1922318 defendant Hale John clerk 589494 589494 Hale, John, of Northflete, clerk 0
3689667 1922927 1922927 defendant Norman Richard husbandman 589494 589494 Norman, Richard, of Northflete, husbandman 0
3712191 1930129 1930129 defendant Mathewe Thomas husbandman 589494 589494 Mathewe, Thomas, of Northflete, husbandman 1
3712192 1930129 1930129 defendant Thornton John husbandman 589494 589494 Thornton, John, of Northflete, husbandman 2
3712193 1930129 1930129 defendant Andrewe Margaret widow 589494 589494 Andrewe, Margaret, of Northflete, widow 3
3718188 1931973 1931973 defendant Hunte Joan widow 589494 589494 Hunte, Joan, of Northflete, widow 0
3750656 1942127 1942127 defendant Fuller Thomas husbandman 589494 589494 Fuller, Thomas, of Northflete, husbandman 2
3751189 1942298 1942298 defendant Wombewell Thomas gent 589494 589494 Wombewell, Thomas, of Northflete, gent 1
3767325 1947425 1947425 defendant Getour John husbandman 589494 589494 Getour, John, of Northflete, husbandman 1
3776172 1950292 1950292 defendant Davy William (legal representative) 589494 589494 Davy, William, of Northflete, gent, administratrix of 0
3776173 1950292 1950292 defendant Davy Alice widow 589494 589494 Davy, Alice, of Northflete, widow 1
3839634 1970320 1970320 defendant Posyer William yeoman 589494 589494 Posyer, William, of Northflete, yeoman 1
3842152 1971095 1971095 plaintiff Brampston John (legal representative) 589494 589494 Brampston, John, of Northflete, gent, executors of 0
3842156 1971096 1971096 plaintiff Brampston John (legal representative) 589494 589494 Brampston, John, of Northflete, gent, executors of 0
3842160 1971097 1971097 plaintiff Brampston John (legal representative) 589494 589494 Brampston, John, of Northflete, gent, executors of 0
3969820 2014050 2014050 defendant Francke William gent 589494 589494 Francke, William, of Northflete, gent 0
3969821 2014050 2014050 defendant Swanne William gent 589494 589494 Swanne, William, of Northflete, gent 1
3972859 2015080 2015080 plaintiff Swanne William gent 589494 589494 Swanne, William, of Northflete, gent 1
4067971 2048852 2048852 defendant Idenden John yeoman 589494 589494 Idenden, John, of Northflete, yeoman 0
4106482 2062610 2062610 plaintiff Parker Richard gent 589494 589494 Parker, Richard, of Northflete, gent 0
4115140 2065703 2065703 defendant Idenden or Edenden John husbandman 589494 589494 Idenden or Edenden, John, of Northflete, or of Boughton Mallard, husbandman 0
4132820 2072066 2072066 defendant Swanne William gent 589494 589494 Swanne, William, of Northflete, gent 1
4132821 2072066 2072066 defendant Hennaker Alexander yeoman 589494 589494 Hennaker, Alexander, of Northflete, yeoman 2
4147561 2077289 2077289 defendant Swan William gent 589494 589494 Swan, William, of Northflete, gent 0
4190335 2092139 2092139 defendant Swanne William gent 589494 589494 Swanne, William, of Northflete, or of Hazell, gent 0
4192423 2092905 2092905 defendant Swanne William gent 589494 589494 Swanne, William, of Northflete, gent 0
4226294 2104669 2104669 defendant Wembell Michael (legal representative) 589494 589494 Wembell, Michael, of Northflete, gent, executor of 0
4481266 2194826 2194826 defendant Craft Richard   589494 589494 Craft, Richard, of Northflete 0
4519723 2206526 2206526 defendant Chaumberleyn Robert   589494 589494 Chaumberleyn, Robert, of Northflete 0
4542451 2213527 2213527 defendant Hallum Robert master & parson 589494 589494 Hallum, Robert, of Northflete, master & parson 0
4557400 2218253 2218253 defendant Hallum Robert master & parson 589494 589494 Hallum, Robert, of Northflete, master & parson 0
4563238 2220073 2220073 defendant Hardy William   589494 589494 Hardy, William, of Northflete 0
4655232 2247520 2247520 defendant Rose William laborer 589494 589494 Rose, William, of Northflete, laborer 0
4679961 2259337 2259337 defendant Ingram Richard tailor 589494 589494 Ingram, Richard, of Northflete, tailor 0
4679963 2259338 2259338 defendant Ingram Richard tailor 589494 589494 Ingram, Richard, of Northflete, tailor 0
4691257 2262786 2262786 defendant Wylshyre Richard laborer 589494 589494 Wylshyre, Richard, of Northflete, laborer 0
4704886 2266904 2266904 defendant Dyer Joan widow 589494 589494 Dyer, Joan, of Northflete, widow 3
4734398 2275926 2275926 defendant Baron William dyer 589494 589494 Baron, William, of Northflete, dyer 0
4786960 2291986 2291986 plaintiff Gold John (legal representative) 589494 589494 Gold, John, of Northflete, executors of 0
4786962 2291986 2291986 plaintiff Hunte Richard   589494 589494 Hunte, Richard, of Northflete 2
4792574 2293768 2293768 defendant Brykhill John (legal representative) 589494 589494 Brykhill, John, of Northflete, executrix of 2
4796062 2294921 2294921 defendant Craft John ostler 589494 589494 Craft, John, of Northflete, ostler 0
4796063 2294921 2294921 defendant Barre Thomas ploughman 589494 589494 Barre, Thomas, of Northflete, ploughman 1
4871089 2317934 2317934 plaintiff Meapham Richard   589494 589494 Meapham, Richard, of Northflete 0
4879606 2320545 2320545 defendant Straunge Walter, junior smith 589494 589494 Straunge, Walter, junior, of Northflete, smith 4
4912045 2330270 2330270 defendant Rous John husbandman 589494 589494 Rous, John, of Northflete, husbandman 0
4917737 2332061 2332061 defendant Hauker Richard husbandman 589494 589494 Hauker, Richard, of Northflete, husbandman 0
4928553 2335359 2335359 defendant Veyse Roger husbandman 589494 589494 Veyse, Roger, of Northflete, husbandman 0
4969297 2347777 2347777 defendant Smyth John   589494 589494 Smyth, John, of Northflete, tile maker 0
4969690 2347880 2347880 defendant Caunterbury John husbandman 589494 589494 Caunterbury, John, of Northflete, husbandman 5
4970314 2348070 2348070 plaintiff Haukere Richard   589494 589494 Haukere, Richard, of Northflete 0
4970370 2348084 2348084 plaintiff Haweker Richard   589494 589494 Haweker, Richard, of Northflete 0
4970371 2348084 2348084 defendant Flukke Thomas husbandman 589494 589494 Flukke, Thomas, of Northflete, husbandman 0
4970372 2348084 2348084 defendant Smyth William chalker 589494 589494 Smyth, William, of Northflete, chalker 1
4980408 2351080 2351080 defendant Smyth William boatman 589494 589494 Smyth, William, of Northflete, boatman 4
4988076 2353407 2353407 defendant Hauker Richard husbandman 589494 589494 Hauker, Richard, of Northflete, husbandman 0
5014572 2361128 2361128 defendant Hauk or Hank Henry husbandman 589494 589494 Hauk or Hank, Henry, of Northflete, husbandman 0
5023805 2363871 2363871 defendant Alisaunder William   589494 589494 Alisaunder, William, of Northflete, court holder 0
5023807 2363872 2363872 defendant Alisaunder William   589494 589494 Alisaunder, William, of Northflete, court holder 0
5034825 2367040 2367040 defendant Ile John baker 589494 589494 Ile, John, of Northflete, baker 1
5036290 2367464 2367464 defendant Langefeld Richard husbandman 589494 589494 Langefeld, Richard, of Northflete, husbandman 3
5062202 2375253 2375253 plaintiff Hawekere Richard   589494 589494 Hawekere, Richard, of Northflete 0
5062205 2375253 2375253 defendant Everard Richard tiler 589494 589494 Everard, Richard, of Northflete, tiler 2
5062206 2375254 2375254 plaintiff Hawekere Richard yeoman 589494 589494 Hawekere, Richard, of Northflete, yeoman 0
5062208 2375255 2375255 plaintiff Hawekere Richard yeoman 589494 589494 Hawekere, Richard, of Northflete, yeoman 0
5062209 2375255 2375255 defendant Longfeld Richard husbandman 589494 589494 Longfeld, Richard, of Northflete, husbandman 0
5068358 2377038 2377038 defendant Hawker Richard yeoman 589494 589494 Hawker, Richard, of Northflete, yeoman 1
5080242 2380581 2380581 defendant Clerk William butcher 589494 589494 Clerk, William, of Northflete, butcher 0
5086241 2382370 2382370 defendant Corveser Richard laborer 589494 589494 Corveser, Richard, of Northflete, laborer 0
5087566 2382744 2382744 defendant Pakker Robert laborer 589494 589494 Pakker, Robert, of Northflete, laborer 0
5094327 2384747 2384747 defendant Clerk William husbandman 589494 589494 Clerk, William, of Northflete, husbandman 0
5112987 2390192 2390192 defendant Gervays Richard husbandman 589494 589494 Gervays, Richard, of Northflete, husbandman 0
5135687 2396948 2396948 defendant Heyward John husbandman 589494 589494 Heyward, John, of Northflete, husbandman 0
5154742 2402540 2402540 defendant Gerard Walter husbandman 589494 589494 Gerard, Walter, of Northflete, husbandman 0
5249600 2429999 2429999 defendant Peper Thomas gent 589494 589494 Peper, Thomas, of Northflete, gent 0
5249945 2430095 2430095 defendant Peers John butcher 589494 589494 Peers, John, of Northflete, butcher 2
5251553 2430590 2430590 defendant Peirs Thomas laborer 589494 589494 Peirs, Thomas, of Northflete, laborer 1
5286114 2440947 2440947 defendant Romayn William husbandman 589494 589494 Romayn, William, of Northflete, husbandman 3
5288125 2441545 2441545 defendant Wakelyng John yeoman 589494 589494 Wakelyng, John, of Northflete, yeoman 0
5288126 2441545 2441545 defendant Hauker or Hanker William yeoman 589494 589494 Hauker or Hanker, William, of Northflete, yeoman 1
5313884 2449174 2449174 defendant Gerard Walter husbandman 589494 589494 Gerard, Walter, of Northflete, husbandman 1
5314529 2449377 2449377 defendant Walkelyne John husbandman 589494 589494 Walkelyne, John, of Northflete, husbandman 0
5314530 2449377 2449377 defendant Clerke John husbandman 589494 589494 Clerke, John, of Northflete, husbandman 1
5325369 2452674 2452674 defendant Alisaunder William yeoman 589494 589494 Alisaunder, William, of Northflete, yeoman 0
5335623 2455727 2455727 plaintiff Gorney John (legal representative) 589494 589494 Gorney, John, of Northflete, executors of 0
5335766 2455763 2455763 defendant Braybroke Robert yeoman 589494 589494 Braybroke, Robert, of Northflete, yeoman 0
5345867 2458842 2458842 plaintiff Wombewell Thomas gent 589494 589494 Wombewell, Thomas, of Northflete, gent 0
5357154 2462301 2462301 defendant Alisaunder William gent 589494 589494 Alisaunder, William, of Northflete, gent 0
5386756 2471279 2471279 defendant Halman William   589494 589494 Halman, William, of Northflete 0
5390512 2472349 2472349 defendant Ingram William husbandman 589494 589494 Ingram, William, of Northflete, husbandman 3
5420695 2481115 2481115 defendant Alisaunder William gent 589494 589494 Alisaunder, William, of Northflete, gent 0
5488977 2501574 2501574 defendant Davy William gent 589494 589494 Davy, William, of Northflete, gent 0

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