names

98 rows where place_id = 592959

✎ 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
3609563 1870657 1870657 defendant Bulle Thomas yeoman 592959 592959 Bulle, Thomas, of Plymmouth, Devon, yeoman 0
3613879 1871995 1871995 defendant Orange Richard merchant 592959 592959 Orange, Richard, of Plymmouth, Devon, merchant 0
3619489 1873659 1873659 defendant Millowe William butcher 592959 592959 Millowe, William, of Plymmouth, Devon, butcher 0
3619614 1873704 1873704 defendant Orynge Richard merchant 592959 592959 Orynge, Richard, of Plymmouth, Devon, merchant 0
3619619 1873706 1873706 defendant Pynd or Pynder Roger merchant 592959 592959 Pynd or Pynder, Roger, of Plymmouth, Devon, merchant 1
3647811 1909709 1909709 defendant Creswell Edward yeoman of the crown 592959 592959 Creswell, Edward, of Plymmouth, Devon, yeoman of the crown 2
3670188 1916623 1916623 defendant Paynter John, junior merchant 592959 592959 Paynter, John, junior, of Plymmouth, Devon, merchant 0
3670192 1916624 1916624 defendant Paynter John, junior merchant 592959 592959 Paynter, John, junior, of Plymmouth, Devon, merchant 0
3687496 1922268 1922268 defendant Anys or Avys William merchant 592959 592959 Anys or Avys, William, of Plymmouth, Devon, merchant 1
3691459 1923485 1923485 defendant Carleton John mercer 592959 592959 Carleton, John, of Plymmouth, Devon, mercer 0
3691464 1923486 1923486 defendant Carleton John mercer 592959 592959 Carleton, John, of Plymmouth, Devon, mercer 0
3709448 1929257 1929257 defendant Vowell Thomas gent 592959 592959 Vowell, Thomas, of Plymmouth, Devon, gent 1
3719908 1932496 1932496 defendant Horswell James gent 592959 592959 Horswell, James, of Plymmouth, Devon, gent 0
3720345 1932641 1932641 defendant Paynter John, junior merchant 592959 592959 Paynter, John, junior, of Plymmouth, Devon, merchant 2
3720522 1932700 1932700 defendant Wyse John esq 592959 592959 Wyse, John, of Plymmouth, Devon, esq 1
3731940 1936220 1936220 defendant Dykton Robert merchant 592959 592959 Dykton, Robert, of Plymmouth, Devon, merchant 0
3761841 1945712 1945712 defendant Peyrs Stephen merchant 592959 592959 Peyrs, Stephen, of Plymmouth, Devon, merchant 0
3766875 1947305 1947305 defendant Corem John yeoman 592959 592959 Corem, John, of Plymmouth, Devon, yeoman 2
3780194 1951530 1951530 defendant Paynter John merchant 592959 592959 Paynter, John, of Plymmouth, Devon, merchant 0
3781079 1951818 1951818 defendant Carewe John yeoman 592959 592959 Carewe, John, of Plymmouth, Devon, yeoman 0
3788199 1954107 1954107 defendant Herford John merchant 592959 592959 Herford, John, of Plymmouth, Devon, merchant 0
3788202 1954108 1954108 defendant Herofrd John merchant 592959 592959 Herofrd, John, of Plymmouth, Devon, merchant 0
3807295 1960180 1960180 defendant Vowell Thomas gent 592959 592959 Vowell, Thomas, of Plymmouth, Devon, gent 0
3807811 1960327 1960327 defendant Vowell Thomas gent 592959 592959 Vowell, Thomas, of Plymmouth, Devon, gent 0
3831368 1967699 1967699 defendant Elyott John gent 592959 592959 Elyott, John, of Plymmouth, Devon, gent 0
3849718 1973498 1973498 defendant Horswell James yeoman 592959 592959 Horswell, James, of Plymmouth, Devon, yeoman 0
3955397 2008953 2008953 defendant Edgecombe or Agcomb William merchant 592959 592959 Edgecombe or Agcomb, William, of Plymmouth, Devon, merchant 0
4863121 2315443 2315443 defendant Sampson John esq 592959 592959 Sampson, John, of Plymmouth, Devon, esq 0
4863849 2315669 2315669 defendant Facy Thomas yeoman 592959 592959 Facy, Thomas, of Plymmouth, Devon, yeoman 0
4874665 2319019 2319019 defendant Dillard Reginald husbandman 592959 592959 Dillard, Reginald, of Plymmouth, Devon, husbandman 1
4875902 2319423 2319423 defendant Leche John husbandman 592959 592959 Leche, John, of Plymmouth, Devon, husbandman 0
4879020 2320365 2320365 defendant Ware Thomas merchant 592959 592959 Ware, Thomas, of Plymmouth, Devon, merchant 0
4897416 2325850 2325850 defendant Sampson James gent 592959 592959 Sampson, James, of Plymmouth, Devon, gent 1
4902781 2327488 2327488 defendant Coweley John husbandman 592959 592959 Coweley, John, of Plymmouth, Devon, husbandman 1
4907082 2328786 2328786 defendant Bennall Edward mariner 592959 592959 Bennall, Edward, of Plymmouth, Devon, mariner 0
4937677 2338161 2338161 defendant Mason John, junior mercer 592959 592959 Mason, John, junior, of Plymmouth, Devon, mercer 1
4947563 2341232 2341232 defendant Maporder John joiner 592959 592959 Maporder, John, of Plymmouth, Devon, joiner 1
4949074 2341701 2341701 defendant Grene William chaplain 592959 592959 Grene, William, of Plymmouth, Devon, chaplain 0
4956718 2343963 2343963 defendant Gewe Richard butcher 592959 592959 Gewe, Richard, of Plymmouth, Devon, butcher 0
4956799 2343993 2343993 defendant Alen William merchant 592959 592959 Alen, William, of Plymmouth, Devon, merchant 0
4959774 2344887 2344887 defendant Chasty John gent 592959 592959 (Chasty, John, of Plymmouth, Devon, gent 5
4961733 2345472 2345472 defendant Nycoll William merchant 592959 592959 Nycoll, William, of Plymmouth, Devon, merchant 0
4975306 2349570 2349570 defendant Pylkynton Thomas gent 592959 592959 Pylkynton, Thomas, of Plymmouth, Devon, gent 0
4979811 2350918 2350918 defendant Carwynnek John gent 592959 592959 (Carwynnek, John, of Plymmouth, Devon, gent 1
5019928 2362709 2362709 defendant Chepman Stephen yeoman 592959 592959 Chepman, Stephen, of Plymmouth, Devon, yeoman 0
5022117 2363361 2363361 defendant Ley Walter mariner 592959 592959 Ley, Walter, of Plymmouth, Devon, mariner 0
5025171 2364258 2364258 defendant Jayowe William merchant 592959 592959 Jayowe, William, of Plymmouth, Devon, merchant 1
5026332 2364592 2364592 defendant Bromboyte John gent 592959 592959 Bromboyte, John, of Plymmouth, Devon, gent 1
5068110 2376967 2376967 defendant Hill Thomas gent 592959 592959 Hill, Thomas, of Plymmouth, Devon, gent 0
5068112 2376968 2376968 defendant Hill Thomas gent 592959 592959 Hill, Thomas, of Plymmouth, Devon, gent 0
5078061 2379921 2379921 defendant Nicoll William merchant 592959 592959 Nicoll, William, of Plymmouth, Devon, merchant 0
5079472 2380353 2380353 defendant Kydde John mariner 592959 592959 Kydde, John, of Plymmouth, Devon, mariner 0
5086405 2382420 2382420 defendant Bole Thomas merchant 592959 592959 Bole, Thomas, of Plymmouth, Devon, merchant 0
5087718 2382793 2382793 defendant Nichol William merchant 592959 592959 Nichol, William, of Plymmouth, Devon, merchant 0
5089476 2383292 2383292 defendant Manger or Mauger John merchant 592959 592959 Manger or Mauger, John, of Plymmouth, Devon, merchant 2
5090571 2383623 2383623 defendant Halle Thomas merchant 592959 592959 Halle, Thomas, of Plymmouth, Devon, merchant 1
5091151 2383812 2383812 defendant Burnard Walter yeoman 592959 592959 Burnard, Walter, of Plymmouth, Devon, yeoman 0
5091158 2383813 2383813 defendant Totewylle Sybil widow 592959 592959 Totewylle, Sybil, of Plymmouth, Devon, widow 1
5092910 2384310 2384310 defendant Hille Thomas gent 592959 592959 Hille, Thomas, of Plymmouth, Devon, merchant, gent 0
5094467 2384788 2384788 defendant Nichol William merchant 592959 592959 Nichol, William, of Plymmouth, Devon, merchant 0
5094470 2384789 2384789 defendant Nicholl William merchant 592959 592959 Nicholl, William, of Plymmouth, Devon, merchant 0
5094480 2384793 2384793 defendant Nicholl William merchant 592959 592959 Nicholl, William, of Plymmouth, Devon, merchant 0
5097320 2385647 2385647 defendant Morys John merchant 592959 592959 Morys, John, of Plymmouth, Devon, merchant 4
5100054 2386454 2386454 defendant Waryn John merchant 592959 592959 Waryn, John, of Plymmouth, Devon, merchant 0
5100169 2386490 2386490 defendant Nere John merchant 592959 592959 Nere, John, of Plymmouth, Devon, merchant 1
5103773 2387526 2387526 defendant Bysshupp John merchant 592959 592959 Bysshupp, John, of Plymmouth, Devon, merchant 0
5111330 2389705 2389705 defendant Quarell Nicholas tailor 592959 592959 Quarell, Nicholas, of Plymmouth, Devon, tailor 0
5121906 2392842 2392842 defendant Page John merchant 592959 592959 Page, John, of Plymmouth, Devon, merchant 1
5121912 2392843 2392843 defendant Nicoll William merchant 592959 592959 Nicoll, William, of Plymmouth, Devon, merchant 1
5121943 2392844 2392844 defendant Nicoll William merchant 592959 592959 together with Nicoll, William, of Plymmouth, Devon, merchant 1
5121975 2392845 2392845 defendant Nicoll William   592959 592959 Nicoll, William, of Plymmouth, Devon, merchant, and others 0
5212498 2419400 2419400 defendant Fox Richard husbandman 592959 592959 Fox, Richard, of Plymmouth, Devon, husbandman 2
5215995 2420406 2420406 defendant Wymond Nicholas mariner 592959 592959 Wymond, Nicholas, of Plymmouth, Devon, mariner 0
5220743 2421757 2421757 defendant Dabernon Richard merchant 592959 592959 Dabernon, Richard, of Plymmouth, Devon, merchant 0
5224817 2422929 2422929 defendant Moreys John merchant 592959 592959 Moreys, John, of Plymmouth, Devon, merchant 0
5224820 2422930 2422930 defendant Savage William merchant 592959 592959 Savage, William, of Plymmouth, Devon, merchant 0
5224823 2422931 2422931 defendant Vele Geoffrey merchant 592959 592959 Vele, Geoffrey, of Plymmouth, Devon, merchant 0
5225189 2423039 2423039 defendant de Nyger Galeas merchant 592959 592959 de Nyger, Galeas, of Plymmouth, Devon, merchant 0
5225329 2423079 2423079 defendant Grenefeld John gent 592959 592959 Grenefeld, John, of Plymmouth, Devon, gent 3
5239498 2427137 2427137 defendant Savage William merchant 592959 592959 Savage, William, of Plymmouth, Devon, merchant 0
5285687 2440840 2440840 plaintiff Lucas William merchant 592959 592959 Lucas, William, of Plymmouth, Devon, merchant 1
5291194 2442428 2442428 defendant Vele Geoffrey merchant 592959 592959 Vele, Geoffrey, of Plymmouth, Devon, merchant 2
5297274 2444195 2444195 plaintiff Yogge William merchant 592959 592959 Yogge, William, of Plymmouth, Devon, merchant 0
5319495 2450922 2450922 defendant Lucas William yeoman 592959 592959 Lucas, William, of Plymmouth, Devon, yeoman 4
5336847 2456085 2456085 defendant Lucas William yeoman 592959 592959 Lucas, William, of Plymmouth, Devon, yeoman 0
5349979 2460124 2460124 defendant Nicoll William mariner 592959 592959 Nicoll, William, of Plymmouth, Devon, mariner 0
5357833 2462521 2462521 defendant Pynke John shipman 592959 592959 Pynke, John, of Plymmouth, Devon, shipman 1
5357850 2462524 2462524 defendant Pynke John shipman 592959 592959 Pynke, John, of Plymmouth, Devon, shipman 0
5477690 2498347 2498347 defendant Croppe Thomas mariner 592959 592959 Croppe, Thomas, of Plymmouth, Devon, mariner 0
5495124 2503440 2503440 defendant Tregarthen Thomas, senior gent 592959 592959 Tregarthen, Thomas, senior, of Plymmouth, Devon, gent 0
5545098 2518571 2518571 defendant Trykpeny William yeoman 592959 592959 Trykpeny, William, of Plymmouth, Devon, yeoman 2
5550110 2520066 2520066 defendant Rowe John yeoman 592959 592959 Rowe, John, of Plymmouth, Devon, yeoman 4
5558935 2522564 2522564 defendant Plomer Thomas yeoman 592959 592959 Plomer, Thomas, of Plymmouth, Devon, yeoman 0
5568683 2525391 2525391 defendant Bre William gent 592959 592959 Bre, William, of Plymmouth, Devon, gent 0
5574709 2527165 2527165 defendant Creswell Edward yeoman 592959 592959 Creswell, Edward, of Plymmouth, Devon, yeoman 0
5576599 2527731 2527731 defendant Ilcombe John merchant 592959 592959 Ilcombe, John, of Plymmouth, Devon, merchant 0
5581414 2529255 2529255 defendant Courtnay Richard yeoman 592959 592959 Courtnay, Richard, of Plymmouth, Devon, yeoman 2
5587833 2531209 2531209 defendant Gyll John yeoman 592959 592959 Gyll, John, of Plymmouth, Devon, yeoman 3

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