names

152 rows where place_id = 600457

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641115 1907667 1907667 defendant Conk John dyer 600457 600457 Conk, John, of Malton, dyer 0
3661482 1913864 1913864 plaintiff Lampray John (legal representative) 600457 600457 Lampray, John, of Malton, executors of 0
3683738 1921048 1921048 defendant Watson John husbandman 600457 600457 Watson, John, of Malton, husbandman 0
3683739 1921048 1921048 defendant Appilgarth Robert husbandman 600457 600457 Appilgarth, Robert, of Malton, husbandman 1
3727052 1934725 1934725 defendant Paget John yeoman 600457 600457 Paget, John, of Malton, yeoman 4
3751495 1942382 1942382 defendant Percy Owen gent 600457 600457 Percy, Owen, of Malton, gent 0
3783709 1952669 1952669 defendant Spaven John yeoman 600457 600457 Spaven, John, of Malton, yeoman 1
3837022 1969491 1969491 defendant Pynder Edward butcher 600457 600457 Pynder, Edward, of Malton, butcher 0
3852682 1974446 1974446 defendant Erend or Grend Thomas yeoman 600457 600457 Erend or Grend, Thomas, of Malton, yeoman 0
3853867 1974842 1974842 defendant Amond Elizabeth widow 600457 600457 Amond, Elizabeth, of Malton, widow 0
3883324 1984687 1984687 defendant Resson Richard draper 600457 600457 Resson, Richard, of Malton, draper 1
3885894 1985538 1985538 defendant Stearne John gent 600457 600457 Stearne, John, of Malton, gent 0
4112964 2064906 2064906 defendant Ruddock Alan yeoman 600457 600457 Ruddock, Alan, of Malton, yeoman 0
4160611 2081786 2081786 defendant Blande Francis chapman 600457 600457 Blande, Francis, of Malton, chapman 1
4179284 2088231 2088231 defendant Ingland Thomas yeoman 600457 600457 Ingland, Thomas, of Malton, yeoman 1
4188629 2091503 2091503 defendant Bell Roger yeoman 600457 600457 Bell, Roger, of Malton, yeoman 2
4188899 2091597 2091597 defendant Kighley Walter vintner 600457 600457 Kighley, Walter, of Malton, innholder, vintner 0
4235537 2107997 2107997 defendant Yowarde William gent 600457 600457 Yowarde, William, of Malton, gent 0
4265186 2117993 2117993 defendant Meward William draper 600457 600457 Meward, William, of Malton, draper 0
4270028 2119557 2119557 defendant Yeward William draper 600457 600457 Yeward, William, of Malton, draper 0
4336512 2142506 2142506 defendant Hall William   600457 600457 Hall, William, of Malton, yeoman, or of Crake, "gresman" 0
4373234 2155494 2155494 defendant Marsengale Bartholomew yeoman 600457 600457 Marsengale, Bartholomew, of Malton, yeoman 2
4376057 2156499 2156499 defendant Raysinge Christopher vintner 600457 600457 Raysinge, Christopher, of Malton, vintner 2
4404865 2166197 2166197 defendant Jackson William gent 600457 600457 Jackson, William, of Malton, gent 0
4404866 2166197 2166197 defendant Newlove Peter yeoman 600457 600457 Newlove, Peter, of Malton, yeoman 1
4453956 2186256 2186256 defendant Wellom Joan de   600457 600457 Wellom, Joan de, of Malton 0
4456646 2187104 2187104 defendant Wastel John   600457 600457 Wastel, John, of Malton 0
4478118 2193830 2193830 defendant Plumpton Geoffrey de dyer 600457 600457 Plumpton, Geoffrey de, of Malton, dyer 2
4478120 2193830 2193830 defendant Brigg John   600457 600457 Brigg, John, of Malton 4
4481225 2194809 2194809 defendant Wryght Thomas   600457 600457 Wryght, Thomas, of Malton 1
4488465 2197111 2197111 defendant Fermory Edmund   600457 600457 Fermory, Edmund, of Malton 1
4504418 2201934 2201934 defendant More Robert   600457 600457 More, Robert, of Malton 5
4527470 2208871 2208871 defendant Barbour William   600457 600457 Barbour, William, of Malton 1
4527474 2208872 2208872 defendant Byset John   600457 600457 Byset, John, of Malton 2
4533709 2210811 2210811 defendant Colson Agnes   600457 600457 Colson, Agnes, of Malton 2
4547471 2215139 2215139 plaintiff Bysset John   600457 600457 Bysset, John, of Malton 0
4552574 2216758 2216758 defendant Graunt Robert   600457 600457 Graunt, Robert, of Malton 0
4552575 2216759 2216759 plaintiff Flesshewere Stephen   600457 600457 Flesshewere, Stephen, of Malton 0
4552576 2216759 2216759 defendant Brygge John   600457 600457 Brygge, John, of Malton 0
4552578 2216759 2216759 defendant Drax Thomas   600457 600457 Drax, Thomas, of Malton 2
4552582 2216760 2216760 defendant Rothewelle John   600457 600457 Rothewelle, John, of Malton 0
4555147 2217543 2217543 defendant Milner Thomas   600457 600457 Milner, Thomas, of Malton 0
4557290 2218217 2218217 defendant Baxster Thomas   600457 600457 Baxster, Thomas, of Malton 0
4557292 2218217 2218217 defendant Walker Robert   600457 600457 Walker, Robert, of Malton 2
4558683 2218669 2218669 defendant Birlay Henry   600457 600457 Birlay, Henry, of Malton 4
4558684 2218669 2218669 defendant Byset John   600457 600457 Byset, John, of Malton 5
4559158 2218816 2218816 plaintiff Martyn John   600457 600457 Martyn, John, of Malton 0
4559159 2218816 2218816 defendant Redeman Thomas   600457 600457 Redeman, Thomas, of Malton 0
4559211 2218835 2218835 plaintiff Mason Richard   600457 600457 Mason, Richard, of Malton 0
4559213 2218836 2218836 plaintiff Mason Richard   600457 600457 Mason, Richard, of Malton 0
4564498 2220461 2220461 defendant Barbour William   600457 600457 Barbour, William, of Malton 0
4564511 2220462 2220462 defendant Barbour William   600457 600457 Barbour, William, of Malton 4
4566698 2221159 2221159 defendant Chapman Robert   600457 600457 Chapman, Robert, of malton 0
4571487 2222662 2222662 defendant Littestere John   600457 600457 Littestere, John, of Malton 2
4573404 2223213 2223213 plaintiff Barker Philip   600457 600457 Barker, Philip, of Malton 0
4573641 2223269 2223269 defendant Spenser Richard   600457 600457 Spenser, Richard, of Malton 0
4591636 2228742 2228742 plaintiff More William de   600457 600457 More, William de, of Malton 0
4604944 2232708 2232708 defendant Litster John   600457 600457 Litster, John, of Malton 0
4604955 2232711 2232711 defendant Beset John   600457 600457 Beset, John, of Malton 0
4615947 2235984 2235984 defendant Smalware John   600457 600457 Smalware, John, of Malton 0
4617500 2236484 2236484 defendant Aylewyn Andrew fuller 600457 600457 Aylewyn, Andrew, of Malton, fuller 0
4617911 2236604 2236604 defendant Whirill William   600457 600457 Whirill, William, of Malton, wright 0
4621057 2237570 2237570 defendant Barton William shoemaker 600457 600457 Barton William, of Malton, shoemaker 1
4628294 2239776 2239776 defendant Malton Robert   600457 600457 Malton, Robert, of Malton 0
4629861 2240263 2240263 defendant Tryche John   600457 600457 Tryche, John, of Malton, glove maker 5
4635214 2241854 2241854 defendant Pynner William   600457 600457 Pynner, William, of Malton 1
4646887 2245151 2245151 defendant Stracy Nicholas tanner 600457 600457 Stracy, Nicholas, of Malton, tanner 1
4652867 2246832 2246832 defendant Pelson John barber 600457 600457 Pelson, John, of Malton, barber 0
4655193 2247508 2247508 defendant Litster John husbandman 600457 600457 Litster, John, of Malton, husbandman 2
4655503 2247614 2247614 defendant Trope John, junior yeoman 600457 600457 Trope, John, junior, of Malton, yeoman 0
4655505 2247614 2247614 defendant Chapman Thomas yeoman 600457 600457 Chapman, Thomas, of Malton, yeoman 2
4656702 2247989 2247989 plaintiff Chapman Thomas   600457 600457 Chapman, Thomas, of Malton 0
4662169 2249642 2249642 plaintiff Flesshewer John (legal representative) 600457 600457 Flesshewer, John, of Malton, courser, executrix of 0
4664657 2250423 2250423 defendant Trop John, junior yeoman 600457 600457 Trop, John, junior, of Malton, yeoman 0
4664659 2250423 2250423 defendant Henryson Thomas husbandman 600457 600457 Henryson, Thomas, of Malton, husbandman 2
4666624 2251042 2251042 defendant Flesshewer Simon butcher 600457 600457 Flesshewer, Simon, of Malton, butcher 1
4666800 2255345 2255345 defendant Wymeswold Geoffrey   600457 600457 Wymeswold, Geoffrey, of Malton, prior 0
4679252 2259119 2259119 defendant Westby (illegible) butcher 600457 600457 Westby, ----, of Malton, butcher 2
4696006 2264236 2264236 defendant Senyour William yeoman 600457 600457 Senyour, William, of Malton, yeoman 0
4696007 2264236 2264236 defendant Tracy Nicholas tanner 600457 600457 Tracy, Nicholas, of Malton, tanner 1
4696008 2264236 2264236 defendant Cartewryght William husbandman 600457 600457 Cartewryght, William, of Malton, husbandman 2
4703324 2266418 2266418 defendant Bulmere John yeoman 600457 600457 Bulmere, John, of Malton, yeoman 1
4703325 2266418 2266418 defendant Heypsen Thomas yeoman 600457 600457 Heypsen, Thomas, of Malton, yeoman 2
4703326 2266418 2266418 defendant Traty Nicholas yeoman 600457 600457 Traty, Nicholas, of Malton, yeoman 3
4705162 2266985 2266985 defendant Tracy Nicholas barber 600457 600457 Tracy, Nicholas, of Malton, barber 2
4706648 2267458 2267458 defendant Tray Nicholas tanner 600457 600457 Tray, Nicholas, of Malton, tanner 1
4712453 2269210 2269210 defendant Furnas Nicholas   600457 600457 Furnas, Nicholas, of Malton, wright 0
4724925 2273087 2273087 defendant Wilde John yeoman 600457 600457 Wilde, John, of Malton, yeoman 1
4730287 2274677 2274677 defendant Chapman Thomas chapman 600457 600457 Chapman, Thomas, of Malton, chapman 1
4735870 2276370 2276370 defendant Seigyour William husbandman 600457 600457 Seigyour, William, of Malton, husbandman 0
4742644 2278353 2278353 plaintiff Chapman Alice   600457 600457 Chapman, Alice, of Malton, formerly wife of Robert Chapman 0
4749737 2280402 2280402 defendant Silveres William hosier 600457 600457 Silveres, William, of Malton, hosier 2
4752934 2281310 2281310 defendant Seynyour William husbandman 600457 600457 Seynyour, William, of Malton, husbandman 0
4788059 2292333 2292333 defendant Malton Robert gent 600457 600457 Malton, Robert, of Malton, gent 2
4806193 2298142 2298142 defendant Henryson Thomas yeoman 600457 600457 Henryson, Thomas, of Malton, yeoman 0
4808081 2298703 2298703 defendant Fanwedyr William   600457 600457 Fanwedyr, William, of Malton 11
4808082 2298703 2298703 defendant Trope John yeoman 600457 600457 Trope, John, of Malton, yeoman 12
4808666 2298876 2298876 defendant Herryson Thomas tailor 600457 600457 Herryson, Thomas, of Malton, tailor 0
4816114 2301129 2301129 defendant Chapman Thomas husbandman 600457 600457 Chapman, Thomas, of Malton, husbandman 1
4816115 2301129 2301129 defendant Seymour William   600457 600457 Seymour, William, of Malton, franklin 2

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