names

219 rows where place_id = 590478

✎ 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
3601334 1868084 1868084 defendant Broke Edward yeoman 590478 590478 Broke, Edward, of Sandwich, Kent, yeoman 2
3613859 1871989 1871989 defendant Broke Thomas draper 590478 590478 Broke, Thomas, of Sandwich, Kent, draper 3
3623624 1874921 1874921 defendant Salman William merchant 590478 590478 Salman, William, of Sandwich, Kent, merchant 0
3623629 1874922 1874922 defendant Salman William merchant 590478 590478 Salman, William, of Sandwich, Kent, merchant 0
3663054 1914356 1914356 defendant Eden Thomas gent 590478 590478 Eden, Thomas, of Sandwich, Kent, gent 0
3663058 1914357 1914357 defendant Eden Thomas gent 590478 590478 (Eden, Thomas, of Sandwich, Kent, gent 1
3815322 1962708 1962708 defendant Halyngbury William grocer 590478 590478 Halyngbury, William, of Sandwich, Kent, grocer 0
3832563 1968105 1968105 defendant Engham Vincent brewer 590478 590478 Engham, Vincent, of Sandwich, Kent, brewer 0
3837459 1969622 1969622 defendant Halyngbury William yeoman 590478 590478 Halyngbury, William, of Sandwich, Kent, yeoman 0
3891620 1987451 1987451 defendant Wyngfeld Thomas gent 590478 590478 Wyngfeld, Thomas, of Sandwich, Kent, gent 1
3922527 1997850 1997850 defendant Orpey Richard yeoman 590478 590478 Orpey, Richard, of Sandwich, Kent, yeoman 0
3936302 2002466 2002466 defendant Warde Alice widow 590478 590478 Warde, Alice, of Sandwich, Kent, widow 5
3942405 2004471 2004471 defendant Pennock Thomas merchant 590478 590478 Pennock, Thomas, of Sandwich, Kent, merchant 2
3955089 2008843 2008843 defendant Harryson Robert gent 590478 590478 Harryson, Robert, of Sandwich, Kent, gent 1
3957243 2009598 2009598 defendant Saxpease William tailor 590478 590478 Saxpease, William, of Sandwich, Kent, tailor 1
3971468 2014581 2014581 defendant Crofte Ralph shoemaker 590478 590478 Crofte, Ralph, of Sandwich, Kent, shoemaker 0
3972249 2014856 2014856 plaintiff Frende Oliver merchant 590478 590478 Frende, Oliver, of Sandwich, Kent, merchant 0
3976173 2016233 2016233 defendant Pynocke Jerome merchant 590478 590478 Pynocke, Jerome, of Sandwich, Kent, merchant 2
3989105 2020843 2020843 defendant Cunstable Nicholas blacksmith 590478 590478 Cunstable, Nicholas, of Sandwich, Kent, blacksmith 2
3995314 2023064 2023064 defendant Lynch Thomas gent 590478 590478 Lynch, Thomas, of Sandwich, Kent, gent 0
3998117 2024084 2024084 defendant Peeke Edmund gent 590478 590478 Peeke, Edmund, of Sandwich, Kent, gent 3
3998138 2024085 2024085 defendant Peeke Edmund gent 590478 590478 Peeke, Edmund, of Sandwich, Kent, gent 3
4005585 2026773 2026773 defendant Cuttell Thomas mariner 590478 590478 Cuttell, Thomas, of Sandwich, Kent, mariner 0
4005799 2026850 2026850 defendant Shuxborowe John gent 590478 590478 Shuxborowe, John, of Sandwich, Kent, gent 3
4014837 2030020 2030020 defendant Halle John merchant 590478 590478 Halle, John, of Sandwich, Kent, merchant 1
4041364 2039403 2039403 defendant Haryson Thomas yeoman 590478 590478 Haryson, Thomas, of Sandwich, Kent, yeoman 1
4041367 2039404 2039404 defendant Harryson Thomas yeoman 590478 590478 Harryson, Thomas, of Sandwich, Kent, yeoman 1
4046183 2041076 2041076 plaintiff Sheterden Walter (legal representative) 590478 590478 Sheterden, Walter, of Sandwich, Kent, merchant, executors of 0
4053374 2043584 2043584 defendant Fynche Thomas grocer 590478 590478 Fynche, Thomas, of Sandwich, Kent, grocer 0
4071282 2050032 2050032 defendant Lynche Thomas gent 590478 590478 Lynche, Thomas, of Sandwich, Kent, gent 0
4072575 2050496 2050496 defendant Harwood John gent 590478 590478 Harwood, John, of Sandwich, Kent, gent 0
4075500 2051539 2051539 plaintiff Rutton Mathew beer brewer 590478 590478 Rutton, Mathew, of Sandwich, Kent, beer brewer 0
4081112 2053556 2053556 defendant Evers William merchant 590478 590478 Evers, William, of Sandwich, Kent, merchant 0
4083473 2054362 2054362 defendant Horwood John gent 590478 590478 Horwood, John, of Sandwich, Kent, gent 1
4111923 2064513 2064513 defendant Beale John innholder 590478 590478 Beale, John, of Sandwich, Kent, innholder 0
4123339 2068649 2068649 defendant Berrell Martin chapman 590478 590478 Berrell, Martin, of Sandwich, Kent, chapman 0
4129341 2070798 2070798 defendant Pynnock Jerome grocer 590478 590478 Pynnock, Jerome, of Sandwich, Kent, grocer 0
4131237 2071492 2071492 defendant Burbedge Edward haberdasher 590478 590478 Burbedge, Edward, of Sandwich, Kent, haberdasher 2
4131502 2071586 2071586 defendant Hasnold Walter merchant 590478 590478 Hasnold, Walter, of Sandwich, Kent, merchant 0
4154207 2079567 2079567 defendant Burbery Edward haberdasher 590478 590478 Burbery, Edward, of Sandwich, Kent, haberdasher 0
4163045 2082609 2082609 defendant Sethe Thomas chapman 590478 590478 Sethe, Thomas, of Sandwich, Kent, chapman 3
4164398 2083066 2083066 defendant Cripps Thomas merchant 590478 590478 Cripps, Thomas, of Sandwich, Kent, merchant 0
4164458 2083088 2083088 defendant Sea John ironmonger 590478 590478 Sea, John, of Sandwich, Kent, ironmonger 0
4178363 2087906 2087906 defendant Burbery Edward chapman 590478 590478 Burbery, Edward, of Sandwich, Kent, chapman 0
4201861 2096194 2096194 defendant Burbery Edward haberdasher 590478 590478 Burbery, Edward, of Sandwich, Kent, haberdasher 0
4201864 2096195 2096195 defendant Wymattes Augustine   590478 590478 Wymattes, Augustine, of Sandwich, Kent, gent, "publicus attornatus" 0
4207032 2098005 2098005 defendant Lawrence Thomas chapman 590478 590478 Lawrence, Thomas, of Sandwich, Kent, chapman 0
4211769 2099672 2099672 defendant Lawrence Thomas chapman 590478 590478 Lawrence, Thomas, of Sandwich, Kent, chapman 3
4237027 2108532 2108532 defendant Aldey Charles gent 590478 590478 Aldey, Charles, of Sandwich, Kent, gent 0
4254706 2114565 2114565 defendant Rooke Stephen, senior chapman 590478 590478 Rooke, Stephen, senior, of Sandwich, Kent, chapman 0
4257407 2115453 2115453 defendant Rucke Stephen mercer 590478 590478 Rucke, Stephen, of Sandwich, Kent, mercer 0
4267328 2118708 2118708 defendant Rooke Stephen, senior chapman 590478 590478 Rooke, Stephen, senior, of Sandwich, Kent, chapman 0
4275684 2121441 2121441 defendant Lylly John maltster 590478 590478 Lylly, John, of Sandwich, Kent, maltster 0
4347944 2146533 2146533 defendant Robynson Thomas merchant 590478 590478 Robynson, Thomas, of Sandwich, Kent, merchant 0
4357472 2149843 2149843 defendant Lucas Edward butcher 590478 590478 Lucas, Edward, of Sandwich, Kent, butcher 0
4357790 2149963 2149963 defendant Tenche John, junior yeoman 590478 590478 Tenche, John, junior, of Sandwich, Kent, yeoman 0
4402500 2165421 2165421 defendant Verall or Verrold John yeoman 590478 590478 Verall or Verrold, John, of Sandwich, Kent, yeoman 0
4665129 2250574 2250574 defendant Clyfforde Hugh yeoman 590478 590478 Clyfforde, Hugh, of Sandwich, Kent, yeoman 0
4683556 2260460 2260460 defendant Brampton John vinter 590478 590478 (Brampton, John, of Sandwich, Kent, vinter 2
4689196 2262179 2262179 defendant Bryse Henry husbandman 590478 590478 Bryse, Henry, of Sandwich, Kent, husbandman 2
4691605 2262902 2262902 defendant Skryvener Thomas   590478 590478 Skryvener, Thomas, of Sandwich, Kent 1
4695312 2264016 2264016 defendant Panyot John chapman 590478 590478 Panyot, John, of Sandwich, Kent, chapman 0
4713147 2269436 2269436 defendant Moland John mariner alias merchant of Bristol 590478 590478 Moland, John, of Sandwich, Kent, mariner alias merchant of Bristol 0
4713149 2269437 2269437 defendant Moland John merchant 590478 590478 Moland, John, of Sandwich, Kent, mariner, alias of Bristol, merchant 0
4717909 2270941 2270941 defendant Broke William shipman 590478 590478 Broke, William, of Sandwich, Kent, shipman 4
4719056 2271308 2271308 defendant Whitney John gent 590478 590478 Whitney, John, of Sandwich, Kent, gent 0
4724055 2272819 2272819 defendant Rys Hugh merchant 590478 590478 Rys, Hugh, of Sandwich, Kent, merchant 0
4734551 2275973 2275973 defendant Bryse Henry chapman 590478 590478 Bryse, Henry, of Sandwich, Kent, chapman 2
4749000 2280192 2280192 defendant Chirche Robert merchant 590478 590478 Chirche, Robert, of Sandwich, Kent, merchant 0
4749003 2280193 2280193 defendant Pratte John merchant 590478 590478 Pratte, John, of Sandwich, Kent, merchant 0
4758878 2283126 2283126 defendant Grove John chandler 590478 590478 Grove, John, of Sandwich, Kent, chandler 0
4762448 2284239 2284239 defendant Mollond John mariner 590478 590478 Mollond, John, of Sandwich, Kent, mariner 1
4770708 2286819 2286819 defendant Merssh John shipman 590478 590478 Merssh, John, of Sandwich, Kent, shipman 0
4784545 2291172 2291172 defendant Henford William tailor 590478 590478 Henford, William, of Sandwich, Kent, tailor 0
4785549 2291503 2291503 defendant Chirche Robert gent 590478 590478 Chirche, Robert, of Sandwich, Kent, gent 4
4788034 2292327 2292327 defendant Martyn Andrew merchant 590478 590478 Martyn, Andrew, of Sandwich, Kent, merchant 0
4788802 2292553 2292553 defendant Alby Stephen merchant 590478 590478 Alby, Stephen, of Sandwich, Kent, merchant 1
4792909 2293869 2293869 defendant Pratte John merchant 590478 590478 Pratte, John, of Sandwich, Kent, merchant 0
4792912 2293870 2293870 defendant Pratte John merchant 590478 590478 Pratte, John, of Sandwich, Kent, merchant 0
4818555 2301883 2301883 defendant Hopere John   590478 590478 Hopere, John, of Sandwich, Kent, hoke or hook maker 0
4818559 2301884 2301884 defendant Hopere John hookmaker 590478 590478 Hopere, John, of Sandwich, Kent, hookmaker 0
4818810 2301968 2301968 defendant Egerdenne Thomas   590478 590478 Egerdenne, Thomas, of Sandwich, Kent, sergeaunt 0
4818816 2301969 2301969 defendant Egerdenne Thomas   590478 590478 Egerdenne, Thomas, of Sandwich, Kent, sergeaunt 0
4820785 2302580 2302580 defendant Alfrey (illegible) baker 590478 590478 Alfrey, ----, of Sandwich, Kent, baker 1
4851275 2311846 2311846 defendant Ridere John fishmonger 590478 590478 Ridere, John, of Sandwich, Kent, jun, fishmonger 1
4873298 2318601 2318601 defendant Fraunceys John husbandman 590478 590478 Fraunceys, John, of Sandwich, Kent, husbandman 2
4873564 2318678 2318678 defendant Bedelles John smith 590478 590478 Bedelles, John, of Sandwich, Kent, smith 3
4897200 2325778 2325778 defendant Connour John mariner 590478 590478 Connour, John, of Sandwich, Kent, mariner 0
4907680 2328969 2328969 defendant Wenyngton Robert merchant 590478 590478 Wenyngton, Robert, of Sandwich, Kent, merchant 0
4935804 2337588 2337588 defendant Cok John gent 590478 590478 Cok, John, of Sandwich, Kent, gent 0
4966193 2346821 2346821 defendant Brok Thomas draper 590478 590478 Brok, Thomas, of Sandwich, Kent, draper 0
4966196 2346822 2346822 defendant Carter John brewer 590478 590478 Carter, John, of Sandwich, Kent, brewer 0
4966199 2346823 2346823 defendant Hayward John mariner 590478 590478 Hayward, John, of Sandwich, Kent, mariner 0
4969066 2347713 2347713 defendant Porter John yeoman 590478 590478 Porter, John, of Sandwich, Kent, yeoman 0
5005160 2358407 2358407 defendant Kyng Thomas shipman 590478 590478 Kyng, Thomas, of Sandwich, Kent, shipman 1
5006024 2358650 2358650 defendant Rowe Robert vintner 590478 590478 Rowe, Robert, of Sandwich, Kent, vintner 0
5006027 2358651 2358651 defendant Rowe Robert vintner 590478 590478 Rowe, Robert, of Sandwich, Kent, vintner 0
5010155 2359834 2359834 defendant Heyward John mariner 590478 590478 Heyward, John, of Sandwich, Kent, mariner 0
5010210 2359851 2359851 defendant Hayward John draper 590478 590478 Hayward, John, of Sandwich, Kent, draper 0
5019719 2362647 2362647 defendant Brok Thomas draper 590478 590478 Brok, Thomas, of Sandwich, kent, draper 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);