names

77 rows where place_id = 587817

✎ 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
3591027 1864820 1864820 plaintiff Davy John   587817 587817 Davy, John, of Fowey, administrators of 0
3591031 1864821 1864821 plaintiff Davy John yeoman of the crown 587817 587817 Davy, John, of Fowey, yeoman of the crown, administrators of 0
3592521 1865275 1865275 defendant Daly John   587817 587817 Daly, John, of Fowey 1
3618204 1873318 1873318 defendant Pester Henry merchant 587817 587817 Pester, Henry, of Fowey, merchant 1
3618205 1873318 1873318 defendant Neweport John merchant 587817 587817 Neweport, John, of Fowey, merchant 2
3618206 1873318 1873318 defendant Herford John merchant 587817 587817 Herford, John, of Fowey, merchant 3
3618207 1873318 1873318 defendant Forgan Thomas mariner 587817 587817 Forgan, Thomas, of Fowey, mariner 4
3626262 1903069 1903069 defendant Henlegh William yeoman 587817 587817 Henlegh, William, of Fowey, yeoman 0
3626263 1903069 1903069 defendant Halys Thomas yeoman 587817 587817 Halys, Thomas, of Fowey, yeoman 1
3645948 1909125 1909125 plaintiff Haryngton Richard   587817 587817 Haryngton, Richard, of Fowey 0
3653991 1911512 1911512 defendant Breuer Thomas merchant 587817 587817 Breuer, Thomas, of Fowey, merchant 0
3695634 1924865 1924865 defendant Haryngdon Richard (legal representative) 587817 587817 Haryngdon, Richard, of Fowey, merchant, executors of 0
3695636 1924865 1924865 defendant Coghe William yeoman 587817 587817 Coghe, William, of Fowey, yeoman 2
3719708 1932432 1932432 defendant Basser William mariner 587817 587817 Basser, William, of Fowey, mariner 0
3723129 1933501 1933501 defendant Henley William (legal representative) 587817 587817 Henley, William, of Fowey, merchant, executrix of 0
3723132 1933502 1933502 defendant Henley William (legal representative) 587817 587817 Henley, William, of Fowey, merchant, executrix of 0
3754627 1943406 1943406 defendant Goodryck John merchant 587817 587817 Goodryck, John, of Fowey, merchant 0
3754629 1943406 1943406 defendant Hyll John merchant 587817 587817 Hyll, John, of Fowey, merchant 2
3790880 1954977 1954977 defendant Brewer Nicholas   587817 587817 Brewer, Nicholas, of Fowey, groom 4
3859591 1976701 1976701 plaintiff Clerk Thomas   587817 587817 Clerk, Thomas, of Fowey 0
3887114 1985954 1985954 defendant Raysshley Philip merchant 587817 587817 Raysshley, Philip, of Fowey, merchant 1
3887172 1985973 1985973 plaintiff Cokk John   587817 587817 Cokk, John, of Fowey 0
3887173 1985973 1985973 defendant Pester William gent 587817 587817 Pester, William, of Fowey, gent 0
3899415 1990019 1990019 defendant Benny John merchant 587817 587817 Benny, John, of Fowey, merchant 3
3899416 1990019 1990019 defendant Kooke John mariner 587817 587817 Kooke, John, of Fowey, mariner 4
3929803 2000305 2000305 defendant Mogham or Mohun Reginald esq Sheriff of Cornwall 587817 587817 Mogham or Mohun, Reginald, of Fowey, esq Sheriff of Cornwall 0
3929828 2000315 2000315 defendant Mogham or Mohun Reginald esq Sheriff of Cornwall 587817 587817 Mogham or Mohun, Reginald, of Fowey, esq Sheriff of Cornwall 0
3937489 2002873 2002873 defendant Esteens John husbandman 587817 587817 Esteens, John, of Fowey, husbandman 0
4012318 2029127 2029127 defendant Allyn William mercer 587817 587817 Allyn, William, of Fowey, or of Lostwithiell, Cornw, mercer 0
4177497 2087605 2087605 defendant Moodye John grocer 587817 587817 Moodye, John, of Fowey, grocer 0
4296904 2128992 2128992 defendant Wyett Robert yeoman 587817 587817 Wyett, Robert, of Fowey, yeoman 0
4310758 2133905 2133905 defendant Mundy William gent 587817 587817 Mundy, William, of Fowey, gent 2
4410346 2168056 2168056 defendant Pawle Stephen husbandman 587817 587817 Pawle, Stephen, of Fowey, husbandman 0
4410347 2168056 2168056 defendant Jollyffe Timothy husbandman 587817 587817 Jollyffe, Timothy, of Fowey, husbandman 1
4535628 2211421 2211421 plaintiff Smyth Richard   587817 587817 Smyth, Richard, of Fowey 0
4535629 2211421 2211421 defendant Russell William   587817 587817 Russell, William, of Fowey 0
4547501 2215149 2215149 defendant Stonard Richard   587817 587817 Stonard, Richard, of Fowey 0
4757245 2282638 2282638 defendant Smyth John merchant 587817 587817 Smyth, John, of Fowey, merchant 1
4766517 2285520 2285520 defendant Heynes Thomas husbandman 587817 587817 Heynes, Thomas, of Fowey, husbandman 1
4845493 2310104 2310104 defendant Russell John mariner 587817 587817 Russell, John, of Fowey, mariner 1
4848885 2311118 2311118 plaintiff Smyth John merchant 587817 587817 Smyth, John, of Fowey, merchant 0
4913796 2330816 2330816 defendant Smyth Thomas smith 587817 587817 Smyth, Thomas, of Fowey, smith 2
4964475 2346282 2346282 defendant Code Walter gent 587817 587817 Code, Walter, of Fowey, gent 17
4964476 2346282 2346282 defendant Trefrye Thomas gent 587817 587817 Trefrye, Thomas, of Fowey, gent 18
5049041 2371347 2371347 defendant Walssh Thomas shipman 587817 587817 Walssh, Thomas, of Fowey, shipman 3
5080510 2380661 2380661 defendant Stonard Thomas merchant 587817 587817 Stonard, Thomas, of Fowey, merchant 0
5085925 2382276 2382276 defendant Botrugan or Bodrugan Henry esq 587817 587817 Botrugan or Bodrugan, Henry, of Fowey, esq 0
5129694 2395172 2395172 defendant Cornewe John mariner 587817 587817 Cornewe, John, of Fowey, mariner 1
5131312 2395645 2395645 defendant Smyth Richard gent 587817 587817 Smyth, Richard, of Fowey, gent 3
5183551 2410924 2410924 defendant Ballard Robert tailor 587817 587817 Ballard, Robert, of Fowey, tailor 2
5195494 2414431 2414431 plaintiff Salter John gent 587817 587817 Salter, John, of Fowey, gent 0
5241142 2427611 2427611 plaintiff Lante Richard merchant 587817 587817 Lante, Richard, of Fowey, merchant 0
5243368 2428256 2428256 defendant Dawe John husbandman 587817 587817 (Dawe, John, of Fowey, husbandman 1
5276073 2438076 2438076 defendant Philipp Edward mariner 587817 587817 Philipp, Edward, of Fowey, mariner 0
5296070 2443841 2443841 defendant Stansley John mariner 587817 587817 Stansley, John, of Fowey, mariner 3
5296072 2443841 2443841 defendant Court Margery widow 587817 587817 Court, Margery, of Fowey, widow 5
5313049 2448936 2448936 defendant Wytbury John merchant 587817 587817 Wytbury, John, of Fowey, merchant 0
5315746 2449776 2449776 defendant Jamys John smith 587817 587817 Jamys, John, of Fowey, smith 0
5318170 2450529 2450529 defendant Julian Martin yeoman 587817 587817 Julian, Martin, of Fowey, yeoman 1
5334927 2455514 2455514 defendant Ponse or Pouse William yeoman 587817 587817 Ponse or Pouse, William, of Fowey, yeoman 1
5335562 2455709 2455709 defendant Vynche Thomas mariner 587817 587817 Vynche, Thomas, of Fowey, mariner 0
5337272 2456219 2456219 defendant Bruer William mariner 587817 587817 Bruer, William, of Fowey, mariner 2
5349154 2459864 2459864 defendant Petyt Mathew mariner 587817 587817 Petyt, Mathew, of Fowey, mariner 0
5350781 2460355 2460355 defendant Barbour Nicholas merchant or mariner 587817 587817 Barbour, Nicholas, of Fowey, merchant or mariner 0
5374752 2467699 2467699 defendant Ude Tristram merchant 587817 587817 Ude, Tristram, of Fowey, merchant 1
5374754 2467699 2467699 defendant Davy John merchant 587817 587817 Davy, John, of Fowey, merchant 3
5388706 2471825 2471825 plaintiff Haryngton Richard merchant 587817 587817 Haryngton, Richard, of Fowey, merchant 0
5401314 2475436 2475436 plaintiff Haryngton Ralph mercer 587817 587817 Haryngton, Ralph, of Fowey, mercer 0
5459409 2492729 2492729 plaintiff Haryngton Richard merchant 587817 587817 Haryngton, Richard, of Fowey, merchant 0
5481579 2499419 2499419 defendant Phelyp Edward merchant 587817 587817 Phelyp, Edward, of Fowey, merchant 1
5481580 2499419 2499419 defendant Barbour Nicholas mariner 587817 587817 Barbour, Nicholas, of Fowey, mariner 2
5519624 2510970 2510970 defendant Pester Henry merchant 587817 587817 Pester, Henry, of Fowey, merchant 0
5554139 2521253 2521253 defendant Raulyn John carpenter 587817 587817 Raulyn, John, of Fowey, carpenter 0
5560326 2522981 2522981 defendant Walsshe Joan widow 587817 587817 Walsshe, Joan, of Fowey, widow 0
5560327 2522981 2522981 defendant Beket Joan widow 587817 587817 Beket, Joan, of Fowey, widow 1
5584618 2530260 2530260 defendant Pester Henry merchant 587817 587817 Pester, Henry, of Fowey, merchant 2
5602109 2535555 2535555 defendant Robyn Thomas mariner 587817 587817 Robyn, Thomas, of Fowey, mariner 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);