names

86 rows where place_id = 592936

✎ 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
3609458 1870623 1870623 defendant Rotheley William yeoman 592936 592936 Rotheley, William, of Depford, yeoman 1
3612420 1871512 1871512 defendant Rodley William yeoman 592936 592936 Rodley, William, of Depford, yeoman 0
3671852 1917196 1917196 defendant Breden Elias brewer 592936 592936 Breden, Elias, of Depford, brewer 1
3749889 1941880 1941880 defendant Sprygge Thomas smith 592936 592936 Sprygge, Thomas, of Depford, smith 0
3752757 1942791 1942791 plaintiff Robynson William (legal representative) 592936 592936 Robynson, William, of Depford, chaplain, executor of 0
3752759 1942791 1942791 defendant Tebbys Edmund gent 592936 592936 Tebbys, Edmund, of Depford, gent 0
3812596 1961826 1961826 defendant Brygges Edward smith 592936 592936 Brygges, Edward, of Depford, smith 4
3812598 1961827 1961827 defendant Brygges Edward smith 592936 592936 Brygges, Edward, of Depford, smith 0
3835519 1969048 1969048 defendant Busshell Michael smith 592936 592936 Busshell, Michael, of Depford, smith 0
4510258 2203694 2203694 defendant Aleyn Thomas   592936 592936 Aleyn, Thomas, of Depford 0
4514220 2204865 2204865 defendant Cheseman John   592936 592936 Cheseman, John, of Depford 0
4536589 2211721 2211721 defendant Lichefeld William boder 592936 592936 Lichefeld, William, of Depford, boder 0
4571288 2222598 2222598 defendant Lichefeld William   592936 592936 Lichefeld, William, of Depford 0
4627232 2239466 2239466 defendant Spaldyng John   592936 592936 Spaldyng, John, of Depford 0
4627840 2239634 2239634 plaintiff Rumsey John   592936 592936 Rumsey, John, of Depford 0
4662259 2249668 2249668 defendant Whalet Henry butcher 592936 592936 Whalet, Henry, of Depford, butcher 3
4698430 2264985 2264985 defendant Cheseman John yeoman 592936 592936 Cheseman, John, of Depford, yeoman 0
4755997 2282259 2282259 plaintiff Bate William   592936 592936 Bate, William, of Depford 0
4786592 2291856 2291856 defendant Ludlowe John brewer 592936 592936 Ludlowe, John, of Depford, brewer 0
4787828 2292258 2292258 defendant Clerk John shipman 592936 592936 Clerk, John, of Depford, shipman 0
4801285 2296590 2296590 plaintiff Wiltshire William   592936 592936 Wiltshire, William, of Depford, cook 0
4801832 2296755 2296755 defendant Wellys John laborer 592936 592936 Wellys, John, of Depford, laborer 0
4843845 2309595 2309595 plaintiff Meryweder Robert   592936 592936 Meryweder, Robert, of Depford 0
4843846 2309595 2309595 plaintiff Sullam John   592936 592936 Sullam, John, of Depford 1
4843847 2309595 2309595 defendant Whyte John husbandman 592936 592936 Whyte, John, of Depford, husbandman 0
4853906 2312631 2312631 plaintiff Wylton Richard   592936 592936 Wylton, Richard, of Depford 0
4853907 2312631 2312631 defendant Meryweder Robert husbandman 592936 592936 Meryweder, Robert, of Depford, husbandman 0
4853908 2312631 2312631 defendant Sullam John husbandman 592936 592936 Sullam, John, of Depford, husbandman 1
4925735 2334483 2334483 plaintiff Pode John   592936 592936 Pode, John, of Depford 0
4942008 2339482 2339482 defendant Pode John smith 592936 592936 Pode, John, of Depford, smith 0
4957446 2344196 2344196 defendant Neweman John husbandman 592936 592936 Neweman, John, of Depford, husbandman 0
4957447 2344196 2344196 defendant Wilton John husbandman 592936 592936 Wilton, John, of Depford, husbandman 1
5028725 2365278 2365278 defendant Ferrour or Smith John smith 592936 592936 Ferrour or Smith, John, of Depford, smith 0
5053223 2372565 2372565 defendant Clerk John husbandman 592936 592936 Clerk, John, of Depford, husbandman 2
5070383 2377634 2377634 defendant Newman John butcher 592936 592936 Newman, John, of Depford, butcher 1
5090235 2383513 2383513 defendant White John farmer 592936 592936 White, John, of Depford, farmer 0
5111249 2389680 2389680 defendant Fraunceys John brewer 592936 592936 Fraunceys, John, of Depford, brewer 0
5114489 2390635 2390635 defendant Deny John smith 592936 592936 Deny, John, of Depford, smith 2
5119903 2392256 2392256 defendant Drwe or Drewe John husbandman 592936 592936 Drwe or Drewe, John, of Depford, husbandman 0
5197192 2414918 2414918 defendant Spark William yeoman 592936 592936 together with Spark, William, of Depford, yeoman 3
5255223 2431748 2431748 defendant Mathewe Thomas yeoman 592936 592936 Mathewe, Thomas, of Depford, yeoman 0
5320549 2451232 2451232 defendant Ferrour Thomas yeoman 592936 592936 Ferrour, Thomas, of Depford, yeoman 0
5324063 2452284 2452284 defendant Lovet Robert yeoman 592936 592936 Lovet, Robert, of Depford, yeoman 2
5324064 2452284 2452284 defendant Mathewe Thomas yeoman 592936 592936 Mathewe, Thomas, of Depford, yeoman 3
5332497 2454783 2454783 defendant Lovet Richard husbandman 592936 592936 Lovet, Richard, of Depford, husbandman 0
5343727 2458221 2458221 defendant Mathewe Thomas   592936 592936 Mathewe, Thomas, of Depford, franklin 0
5346960 2459208 2459208 defendant Vyolet John smith 592936 592936 Vyolet, John, of Depford, smith 0
5346961 2459208 2459208 defendant Vyolet Edmund smith 592936 592936 Vyolet, Edmund, of Depford, smith 1
5349755 2460061 2460061 defendant Vyolet Edmund smith 592936 592936 Vyolet, Edmund, of Depford, smith 0
5349757 2460062 2460062 defendant Vyolet Edmund smith 592936 592936 Vyolet, Edmund, of Depford, smith 0
5356082 2461980 2461980 defendant Cruse Thomas yeoman 592936 592936 Cruse, Thomas, of Depford, yeoman 0
5356083 2461980 2461980 defendant Swayn Thomas baker 592936 592936 Swayn, Thomas, of Depford, baker 1
5356084 2461980 2461980 defendant Grene William brewer 592936 592936 Grene, William, of Depford, brewer 2
5362957 2464061 2464061 defendant Vyolet John smith 592936 592936 Vyolet, John, of Depford, smith 0
5362958 2464061 2464061 defendant Vyolet Edmund smith 592936 592936 Vyolet, Edmund, of Depford, smith 1
5366170 2465082 2465082 defendant Blak John yeoman 592936 592936 Blak, John, of Depford, yeoman 5
5379078 2469052 2469052 defendant Lussheborn Richard laborer 592936 592936 Lussheborn, Richard, of Depford, laborer 1
5383914 2470484 2470484 defendant Blake Richard yeoman 592936 592936 Blake, Richard, of Depford, yeoman 0
5395726 2473860 2473860 defendant Blake Richard yeoman 592936 592936 Blake, Richard, of Depford, yeoman 0
5398003 2474497 2474497 defendant Vyolet Edmund smith or ferrour 592936 592936 Vyolet, Edmund, of Depford, smith or ferrour 0
5409024 2477662 2477662 defendant Blake Richard yeoman 592936 592936 Blake, Richard, of Depford, yeoman 0
5409026 2477663 2477663 defendant Blake Richard yeoman 592936 592936 Blake, Richard, of Depford, yeoman 0
5416322 2479800 2479800 defendant Rylond Ralph yeoman 592936 592936 Rylond, Ralph, of Depford, yeoman 3
5422397 2481646 2481646 defendant Blake Richard yeoman 592936 592936 Blake, Richard, of Depford, yeoman 0
5429038 2483607 2483607 defendant Elston William husbandman 592936 592936 Elston, William, of Depford, husbandman 0
5433083 2484859 2484859 defendant Rylond Ralph yeoman 592936 592936 Rylond, Ralph, of Depford, yeoman 1
5443748 2488053 2488053 defendant Waller Thomas husbandman 592936 592936 Waller, Thomas, of Depford, husbandman 1
5444970 2488381 2488381 defendant Harry John, senior husbandman 592936 592936 Harry, John, senior, of Depford, husbandman 0
5446214 2488754 2488754 defendant Elston William husbandman 592936 592936 Elston, William, of Depford, husbandman 0
5455758 2491621 2491621 defendant Lovet Richard yeoman 592936 592936 Lovet, Richard, of Depford, yeoman 3
5467757 2495290 2495290 defendant Lovett Richard yeoman 592936 592936 Lovett, Richard, of Depford, yeoman 0
5477953 2498430 2498430 defendant Blake Richard yeoman 592936 592936 Blake, Richard, of Depford, yeoman 0
5478883 2498704 2498704 defendant Blak Richard yeoman 592936 592936 Blak, Richard, of Depford, yeoman 0
5482181 2499612 2499612 defendant Elston William husbandman 592936 592936 Elston, William, of Depford, husbandman 0
5494202 2503169 2503169 defendant Hanson Richard husbandman 592936 592936 Hanson, Richard, of Depford, husbandman 0
5494204 2503169 2503169 defendant Woodale John husbandman 592936 592936 Woodale, John, of Depford, husbandman 2
5502875 2505814 2505814 defendant Waller Thomas husbandman 592936 592936 Waller, Thomas, of Depford, husbandman 0
5505310 2506572 2506572 plaintiff Blake Richard yeoman 592936 592936 Blake, Richard, of Depford, yeoman 0
5519235 2510862 2510862 defendant Belton Thomas   592936 592936 Belton, Thomas, of Depford, shipwright 0
5525904 2512693 2512693 defendant Wallyng Richard butcher 592936 592936 Wallyng, Richard, of Depford, butcher 0
5538676 2516578 2516578 defendant Johnson Robert husbandman 592936 592936 Johnson, Robert, of Depford, husbandman 1
5544878 2518504 2518504 defendant Lusshe Henry husbandman 592936 592936 Lusshe, Henry, of Depford, husbandman 0
5559840 2522837 2522837 defendant Rodley William yeoman 592936 592936 Rodley, William, of Depford, yeoman 2
5571021 2526088 2526088 defendant Pymme William baker 592936 592936 Pymme, William, of Depford, baker 0
5571022 2526088 2526088 defendant Sturmy Roger baker 592936 592936 Sturmy, Roger, of Depford, baker 1
5606871 2537038 2537038 defendant Radley John yeoman 592936 592936 Radley, John, of Depford, yeoman 0

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