names

174 rows where place_id = 603499

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654736 1911738 1911738 defendant Heymer Thomas vintner 603499 603499 Heymer, Thomas, of Suthwerk, Surr, vintner 2
3654755 1911744 1911744 defendant Heymer Thomas vintner 603499 603499 Heymer, Thomas, of Suthwerk, Surr, vintner 2
3658451 1912895 1912895 defendant Sherburn Henry   603499 603499 Sherburn, Henry, of Suthwerk, Surr, knight 0
3658455 1912896 1912896 defendant Sherburn Henry   603499 603499 Sherburn, Henry, of Suthwerk, Surr, knight 0
3660064 1913411 1913411 defendant Dawson Christopher yeoman 603499 603499 Dawson, Christopher, of Suthwerk, Surr, yeoman 1
3660581 1913568 1913568 defendant Averey Richard   603499 603499 Averey, Richard, of Suthwerk, Surr, iron smith 3
3663652 1914564 1914564 defendant Prowe William dyer 603499 603499 Prowe, William, of Suthwerk, Surr, dyer 0
3664930 1914976 1914976 defendant Flowre Franics glasier 603499 603499 Flowre, Franics, of Suthwerk, Surr, glasier 2
3933078 2001356 2001356 defendant Lylly alias Glover James glover 603499 603499 Lylly alias Glover, James, of Suthwerk, Surr, glover 1
3933082 2001357 2001357 defendant Lylly alias Glover James glover 603499 603499 Lylly alias Glover, James, of Suthwerk, Surr, glover 1
3933453 2001476 2001476 defendant Allen Thomas   603499 603499 Allen, Thomas, of Suthwerk, Surr 1
3936804 2002640 2002640 defendant Eylisfyld Hugh leather seller 603499 603499 Eylisfyld, Hugh, of Suthwerk, Surr, leather seller 0
4668709 2255928 2255928 defendant Cassus John esq 603499 603499 Cassus, John, of Suthwerk, Surr, esq 0
4670105 2256351 2256351 defendant Wilchar alias Cook John yeoman 603499 603499 Wilchar alias Cook, John, of Suthwerk, Surr, yeoman 0
4671184 2256648 2256648 defendant Weel alias Wolverton Thomas chaplain 603499 603499 Weel alias Wolverton, Thomas, of Suthwerk, Surr, chaplain 0
4676276 2258193 2258193 defendant Mymms William chapman 603499 603499 Mymms, William, of Suthwerk, Surr, chapman 0
4681832 2259929 2259929 defendant Hannay John yeoman 603499 603499 Hannay, John, of suthwerk, Surr, yeoman 3
4689931 2262404 2262404 defendant Vyncent John capper 603499 603499 Vyncent, John, of Suthwerk, Surr, capper 1
4718165 2271019 2271019 defendant Caldewell John yeoman 603499 603499 Caldewell, John, of Suthwerk, Surr, yeoman 2
4749762 2280409 2280409 defendant Short John spicer 603499 603499 Short, John, of Suthwerk, Surr, spicer 2
4750221 2280542 2280542 defendant Goostrawe William embroiderer 603499 603499 Goostrawe, William, of Suthwerk, Surr, embroiderer 0
4753004 2281328 2281328 defendant Cromwell John dyer 603499 603499 Cromwell, John, of Suthwerk, Surr, dyer 4
4753010 2281329 2281329 defendant Cromwell John dyer 603499 603499 Cromwell, John, of Suthwerk, Surr, dyer 4
4760468 2283626 2283626 defendant Waldern Joan widow 603499 603499 Waldern, Joan, of Suthwerk, Surr, widow 0
4803327 2297231 2297231 defendant Hastyngg Edward   603499 603499 Hastyngg, Edward, of Suthwerk, Surr, knight & Lord Hastyngg 0
4804701 2297669 2297669 defendant Blakbourn John husbandman 603499 603499 Blakbourn, John, of Suthwerk, Surr, husbandman 1
4805679 2297984 2297984 defendant Magot Richard butcher 603499 603499 Magot, Richard, of Suthwerk, Surr, butcher 2
4807657 2298586 2298586 defendant Overton Roger ostler 603499 603499 Overton, Roger, of Suthwerk, Surr, ostler 0
4807942 2298667 2298667 defendant Hodys Thomas felmonger 603499 603499 Hodys, Thomas, of Suthwerk, Surr, felmonger 0
4813471 2300325 2300325 defendant Balle Thomas draper 603499 603499 Balle, Thomas, of Suthwerk, Surr, draper 2
4813476 2300326 2300326 defendant Balle Thomas draper 603499 603499 Balle, Thomas, of Suthwerk, Surr, draper 2
4815202 2300866 2300866 defendant Grendon William gent 603499 603499 Grendon, William, of Suthwerk, Surr, gent 0
4816132 2301134 2301134 defendant Blakbourne John   603499 603499 Blakbourne, John, of Suthwerk, Surr, esq, administrators of 0
4817457 2301548 2301548 defendant Bryde Thomas felmonger 603499 603499 Bryde, Thomas, of Suthwerk, Surr, felmonger 1
4820784 2302580 2302580 defendant Galon Henry brewer 603499 603499 Galon, Henry, of Suthwerk, Surr, brewer 0
4825415 2303992 2303992 defendant Milton William husbandman 603499 603499 Milton, William, of Suthwerk, Surr, husbandman 0
4825565 2304034 2304034 defendant Basyngham John shoemaker 603499 603499 Basyngham, John, of Suthwerk, Surr, shoemaker 0
4825567 2304035 2304035 defendant Basyngham John shoemaker 603499 603499 Basyngham, John, of Suthwerk, Surr, shoemaker 0
4908245 2329130 2329130 defendant Redston William, junior gent 603499 603499 Redston, William, junior, of Suthwerk, Surr, gent 1
4910039 2329663 2329663 defendant Borford Lawence husbandman 603499 603499 Borford, Lawence, of Suthwerk, Surr, husbandman 3
4911056 2329970 2329970 defendant Lysle George esq 603499 603499 Lysle, George, of Suthwerk, surr, esq 0
4911061 2329971 2329971 defendant Lysle George esq 603499 603499 Lysle, George, of Suthwerk, Surr, esq 0
4911502 2330099 2330099 plaintiff Broun Hugh butcher 603499 603499 Broun, Hugh, of Suthwerk, Surr, butcher 0
4912920 2330537 2330537 defendant Thornbury Willam esq 603499 603499 Thornbury, Willam, of Suthwerk, Surr, esq 0
4913616 2330755 2330755 defendant Jemys Richard brewer 603499 603499 Jemys, Richard, of Suthwerk, Surr, brewer 0
4913618 2330756 2330756 defendant Jemys Richard butcher 603499 603499 Jemys, Richard, of Suthwerk, Surr, butcher 0
4915732 2331420 2331420 defendant Norn William husbandman 603499 603499 Norn, William, of Suthwerk, Surr, husbandman 1
4916552 2331683 2331683 defendant Tesedale William goldsmith 603499 603499 Tesedale, William, of Suthwerk, Surr, goldsmith 0
4917504 2331989 2331989 defendant Copewode Geoffrey dyer 603499 603499 Copewode, Geoffrey, of Suthwerk, Surr, dyer 0
4918710 2332369 2332369 defendant Tygale John yeoman 603499 603499 Tygale, John, of Suthwerk, Surr, yeoman 0
4919819 2332705 2332705 defendant Pecok Robert clerk 603499 603499 Pecok, Robert, of suthwerk, Surr, clerk 0
4925983 2334556 2334556 defendant Byllysdon Nicholas clerk 603499 603499 Byllysdon, Nicholas, of Suthwerk, Surr, clerk 3
4926445 2334690 2334690 defendant Sutton Robert gent 603499 603499 Sutton, Robert, of Suthwerk, Surr, gent 2
4926448 2334691 2334691 defendant Sutton Robert gent [ see 199 fronts ] 603499 603499 Sutton, Robert, of Suthwerk, Surr, gent [ see 199 fronts ] 1
4926468 2334699 2334699 defendant Birford Lawrence hostiller 603499 603499 Birford, Lawrence, of Suthwerk, Surr, hostiller 0
4927361 2334990 2334990 defendant Mercer Margaret brewer 603499 603499 Mercer, Margaret, of Suthwerk, Surr, brewer 0
4930121 2335829 2335829 plaintiff Thomas John brewer 603499 603499 Thomas, John, of Suthwerk, Surr, brewer 0
4996847 2355914 2355914 defendant Ausyn Richard clerk 603499 603499 Ausyn, Richard, of Suthwerk, Surr, clerk 0
5039545 2368476 2368476 defendant Calwey John hosier 603499 603499 Calwey, John, of Suthwerk, Surr, hosier 1
5039553 2368478 2368478 defendant Calewey John hosier 603499 603499 Calewey, John, of suthwerk, Surr, hosier 1
5044969 2370127 2370127 defendant Blakstone Walter   603499 603499 Blakstone, Walter, of Suthwerk, Surr, tallow chandler 3
5045108 2370168 2370168 defendant Egyrmond John (legal representative) 603499 603499 Egyrmond, John, of Suthwerk, Surr, yeoman, executors of 0
5046617 2370618 2370618 defendant Lylye John yeoman 603499 603499 Lylye, John, of Suthwerk, Surr, yeoman 4
5046662 2370624 2370624 defendant Lylye John yeoman 603499 603499 Lylye, John, of Suthwerk, Surr, yeoman 4
5048078 2371048 2371048 defendant Mynde Nicholas brewer 603499 603499 Mynde, Nicholas, of Suthwerk, Surr, brewer 3
5124420 2393601 2393601 defendant Fayreford Alexander esq 603499 603499 Fayreford, Alexander, of Suthwerk, Surr, esq 0
5124543 2393641 2393641 defendant Miller William draper 603499 603499 Miller, William, of Suthwerk, Surr, draper 0
5125276 2393872 2393872 defendant Farford Alexander gent 603499 603499 Farford, Alexander, of Suthwerk, Surr, gent 0
5127318 2394469 2394469 defendant Miller William draper 603499 603499 Miller, William, of Suthwerk, Surr, draper 0
5134535 2396594 2396594 defendant Port William esq 603499 603499 (Port, William, of Suthwerk, Surr, esq 1
5134968 2396728 2396728 defendant Rule John tailor 603499 603499 Rule, John, of Suthwerk, Surr, tailor 3
5136792 2397281 2397281 defendant Bradfeld Henry clerk 603499 603499 Bradfeld, Henry, of Suthwerk, Surr, clerk 0
5137355 2397438 2397438 defendant Morton John, senior glover 603499 603499 Morton, John, senior, of Suthwerk, Surr, glover 0
5137356 2397438 2397438 defendant Morton John, junior glover 603499 603499 Morton, John, junior, of Suthwerk, Surr, glover 1
5138204 2397687 2397687 defendant Cardyffe Thomas brewer 603499 603499 Cardyffe, Thomas, of Suthwerk, Surr, brewer 0
5139082 2397922 2397922 defendant Henricson Baldewin esq 603499 603499 Henricson, Baldewin, of Suthwerk, Surr, esq 0
5140640 2398372 2398372 defendant Leventhorp Katherine widow 603499 603499 Leventhorp, Katherine, of Suthwerk, Surr, widow 0
5150093 2401166 2401166 defendant Fayreford Alexander esq 603499 603499 Fayreford, Alexander, of Suthwerk, Surr, esq 1
5151648 2401637 2401637 defendant Herwode John butcher 603499 603499 Herwode, John, of Suthwerk, Surr, butcher 2
5165388 2405625 2405625 defendant Mersshman John sadler 603499 603499 Mersshman, John, of Suthwerk, Surr, sadler 0
5166390 2405895 2405895 defendant Miller William draper 603499 603499 Miller, William, of Suthwerk, Surr, draper 0
5167709 2406274 2406274 defendant Fayreford Alexander gent 603499 603499 Fayreford, Alexander, of Suthwerk, Surr, gent 0
5168786 2406601 2406601 defendant Fayreford Alexander esq 603499 603499 Fayreford, Alexander, of Suthwerk, Surr, esq 1
5169283 2406751 2406751 defendant Fayreford Alexander esq 603499 603499 Fayreford, Alexander, of Suthwerk, Surr, esq 0
5172119 2407564 2407564 defendant Fayreford Alexander esq 603499 603499 Fayreford, Alexander, of Suthwerk, Surr, esq 2
5173163 2407861 2407861 defendant Merssheman John sadler 603499 603499 Merssheman, John, of Suthwerk, Surr, sadler 0
5174446 2408228 2408228 defendant Bradcok John carpenter 603499 603499 Bradcok, John, of Suthwerk, Surr, carpenter 1
5182957 2410761 2410761 defendant Went Thomas gent 603499 603499 Went, Thomas, of Suthwerk, Surr, gent 0
5184902 2411333 2411333 defendant Fayreford Alexander esq 603499 603499 Fayreford, Alexander, of Suthwerk, Surr, esq 1
5184906 2411334 2411334 defendant Fayreford Alexander esq 603499 603499 Fayreford, Alexander, of Suthwerk, Surr, esq 1
5208908 2418330 2418330 defendant Croft John shoemaker 603499 603499 Croft, John, of Suthwerk, Surr, shoemaker 0
5268700 2435961 2435961 defendant Forster William   603499 603499 Forster, William, of Suthwerk, Surr, yeoman, staying at the close of St Katherine within the Tower of London 0
5270312 2436419 2436419 defendant Teweke John   603499 603499 Teweke, John, of Suthwerk, Surr, notary 2
5270771 2436551 2436551 defendant Fayrforth Alexander   603499 603499 Fayrforth, Alexander, of Suthwerk, Surr 0
5272852 2437135 2437135 defendant Houghton Christopher   603499 603499 Houghton, Christopher, of Suthwerk, Surr 0
5273010 2437181 2437181 defendant atte Welle Richard yeoman 603499 603499 atte Welle, Richard, of Suthwerk, Surr, yeoman 0
5274982 2437764 2437764 defendant Broun John ostler 603499 603499 Broun, John, of Suthwerk, Surr, ostler 3
5274985 2437765 2437765 defendant Tomson Robert baker 603499 603499 Tomson, Robert, of Suthwerk, Surr, baker 0
5276625 2438243 2438243 defendant Denys Walter esq 603499 603499 Denys, Walter, of Suthwerk, Surr, esq 1
5276816 2438300 2438300 defendant Badcok John carpenter 603499 603499 Badcok, John, of Suthwerk, Surr, carpenter 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);