names

91 rows where place_id = 608325

✎ 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
3673209 1917633 1917633 defendant Whyte John, junior gent 608325 608325 Whyte, John, junior, of Launceston, Cornw, gent 0
3675442 1918357 1918357 defendant Pyers Thomas merchant 608325 608325 Pyers, Thomas, of Launceston, Cornw, merchant 0
3689817 1922972 1922972 defendant White John gent 608325 608325 White, John, of Launceston, Cornw, gent 1
3703909 1927504 1927504 defendant Whyte John, junior gent 608325 608325 Whyte, John, junior, of Launceston, Cornw, gent 0
3711136 1929797 1929797 defendant Carlyon Benedict gent 608325 608325 Carlyon, Benedict, of Launceston, Cornw, gent 0
3712673 1930278 1930278 defendant Whyte John, junior gent 608325 608325 Whyte, John, junior, of Launceston, Cornw, gent 0
3771301 1948714 1948714 defendant Carlyan Benedict yeoman 608325 608325 Carlyan, Benedict, of Launceston, Cornw, yeoman 0
3786679 1953628 1953628 defendant William John mercer 608325 608325 William, John, of Launceston, Cornw, mercer 1
3788901 1954339 1954339 defendant Carlyan Benedict yeoman 608325 608325 Carlyan, Benedict, of Launceston, Cornw, yeoman 0
3802585 1958703 1958703 defendant Guyne John cordwainer 608325 608325 Guyne, John, of Launceston, Cornw, cordwainer 0
3827920 1966595 1966595 defendant Dowe Stephen butcher 608325 608325 Dowe, Stephen, of Launceston, Cornw, butcher 0
3827922 1966596 1966596 defendant Dewe Stephen butcher 608325 608325 Dewe, Stephen, of Launceston, Cornw, butcher 0
3837977 1969789 1969789 defendant Samewell Anne widow 608325 608325 Samewell, Anne, of Launceston, Cornw, widow 1
3848027 1972957 1972957 defendant Ketyll Benedict husbandman 608325 608325 Ketyll, Benedict, of Launceston, Cornw, husbandman 5
3863980 1978132 1978132 plaintiff Kendall William gent 608325 608325 Kendall, William, of Launceston, Cornw, gent 0
3865377 1978635 1978635 defendant Kendall William gent 608325 608325 (Kendall, William, of Launceston, Cornw, gent 1
3878528 1983063 1983063 plaintiff Lenne William (legal representative) 608325 608325 Lenne, William, of Launceston, Cornw, executors of 0
3878531 1983064 1983064 plaintiff Lenne William (legal representative) 608325 608325 Lenne, William, of Launceston, Cornw, merchant, executors of 0
3879393 1983360 1983360 defendant Kendall William gent 608325 608325 (Kendall, William, of Launceston, Cornw, gent 1
3911232 1994081 1994081 defendant Jeynkyns William clerk 608325 608325 Jeynkyns, William, of Launceston, Cornw, clerk 2
3915701 1995626 1995626 defendant Chaunterell Hugh gent 608325 608325 Chaunterell, Hugh, of Launceston, Corn, gent 0
3918636 1996558 1996558 defendant Cover Geoffrey mercer 608325 608325 Cover, Geoffrey, of Launceston, Cornw, mercer 1
3926496 1999192 1999192 plaintiff Kendall William gent 608325 608325 Kendall, William, of Launceston, Cornw, gent 0
3960945 2010926 2010926 defendant Blyghe Digory gent 608325 608325 Blyghe, Digory, of Launceston, Cornw, gent 3
4019116 2031577 2031577 defendant Kever or Cover Geoffrey husbandman 608325 608325 Kever or Cover, Geoffrey, of Launceston, Cornw, husbandman 0
4066868 2048447 2048447 defendant Carwythan John gent 608325 608325 Carwythan, John, of Launceston, Cornw, gent 0
4089733 2056624 2056624 defendant Lovys Thomas esq 608325 608325 Lovys, Thomas, of Launceston, Cornw, or of Torrington Magna, Devon, esq 0
4111722 2064441 2064441 defendant Wise John gent 608325 608325 Wise, John, of Launceston, Cornw, gent 1
4112017 2064549 2064549 defendant Wyse William gent 608325 608325 Wyse, William, of Launceston, Cornw, gent 1
4115681 2065894 2065894 defendant Wyse William, senior gent 608325 608325 Wyse, William, senior, of Launceston, Cornw, gent 2
4179385 2088264 2088264 defendant Hick Digory gent 608325 608325 Hick, Digory, of Launceston, Cornw, gent 0
4191455 2092579 2092579 defendant Hick Digory gent 608325 608325 Hick, Digory, of Launceston, Cornw, gent 0
4219556 2102342 2102342 defendant Knebone Anthony cordwainer 608325 608325 Knebone, Anthony, of Launceston, Cornw, cordwainer 0
4244424 2111112 2111112 defendant Grenvyle Digory gent 608325 608325 Grenvyle, Digory, of Launceston, Cornw, gent 0
4269971 2119539 2119539 defendant Knebone Anthony cordwainer 608325 608325 Knebone, Anthony, of Launceston, Cornw, cordwainer 0
4307417 2132732 2132732 defendant Bennett Thomas tanner 608325 608325 Bennett, Thomas, of Launceston, Cornw, tanner 0
4315200 2135433 2135433 defendant Grenvyle Digory gent 608325 608325 Grenvyle, Digory, of Launceston, Cornw, gent 0
4315202 2135434 2135434 defendant Grenvyle Digory gent 608325 608325 Grenvyle, Digory, of Launceston, Cornw, gent 0
4330989 2140663 2140663 defendant Grenevyle Difory gent 608325 608325 Grenevyle, Difory, of Launceston, Cornw, gent 0
4359139 2150432 2150432 defendant Chanler Nicholas saddler 608325 608325 Chanler, Nicholas, of Launceston, Cornw, saddler 1
4369465 2154140 2154140 defendant Breeme William   608325 608325 Breeme, William, of Launceston, Cornw, Doctor of Medicine 1
4383348 2159142 2159142 defendant Greynvile Digory esq 608325 608325 Greynvile, Digory, of Launceston, Cornw, esq 0
4387420 2160436 2160436 defendant Rowse William yeoman 608325 608325 Rowse, William, of Launceston, Cornw, yeoman 0
4400654 2164808 2164808 defendant Noble William husbandman 608325 608325 Noble, William, of Launceston, Cornw, husbandman 0
4658550 2248552 2248552 defendant Body Henry husbandman 608325 608325 Body, Henry, of Launceston, Cornw, husbandman 3
4680617 2259549 2259549 defendant Kioche Alan husbandman 608325 608325 Kioche, Alan, of Launceston, Cornw, husbandman 0
4683735 2260514 2260514 defendant Caddele John chapman 608325 608325 Caddele, John, of Launceston, Cornw, chapman 2
4742574 2278330 2278330 defendant Cobethorne Walter chapman 608325 608325 Cobethorne, Walter, of Launceston, Cornw, chapman 0
4795862 2294856 2294856 defendant Poul Richard, senior husbandman 608325 608325 Poul, Richard, senior, of Launceston, Cornw, husbandman 0
4835542 2307106 2307106 defendant Toume John yeoman 608325 608325 Toume, John, of Launceston, Cornw, yeoman 1
4841929 2309010 2309010 defendant Tomme John yeoman 608325 608325 Tomme, John, of Launceston, Cornw, yeoman 1
4855867 2313207 2313207 defendant Kitte Alan yeoman 608325 608325 Kitte, Alan, of Launceston, Cornw, yeoman 4
4860855 2314752 2314752 defendant Hamme William husbandman 608325 608325 Hamme, William, of Launceston, Cornw, husbandman 4
4887534 2322938 2322938 defendant Bolepitte William yeoman 608325 608325 Bolepitte, William, of Launceston, Cornw, yeoman 1
4903462 2327690 2327690 defendant Skeynek William gent 608325 608325 Skeynek, William, of Launceston, Cornw, gent 1
4930847 2336050 2336050 defendant John Benedict yeoman 608325 608325 John, Benedict, of Launceston, Cornw, groom, Sedwell, William, of Launceston, yeoman 1
4945810 2340676 2340676 defendant Lome Richard saddler 608325 608325 Lome, Richard, of Launceston, Cornw, saddler 0
4975710 2349697 2349697 defendant Lawys John gent 608325 608325 Lawys, John, of Launceston, Cornw, gent 1
4978705 2350583 2350583 defendant Mustard William husbandman 608325 608325 Mustard, William, of Launceston, Cornw, husbandman 0
4979753 2350901 2350901 defendant Dassell Thomas barber 608325 608325 (Dassell, Thomas, of Launceston, Cornw, barber 1
5009377 2359628 2359628 defendant Lanoy Thomas gent 608325 608325 Lanoy, Thomas, of Launceston, Cornw, gent 8
5046527 2370601 2370601 defendant Tremayle William gent 608325 608325 Tremayle, William, of Launceston, Cornw, gent 0
5060259 2374638 2374638 defendant Bray Henry yeoman 608325 608325 Bray, Henry, of Launceston, Cornw, yeoman 0
5125179 2393841 2393841 defendant Skeynek William gent 608325 608325 Skeynek, William, of Launceston, Cornw, gent 5
5127924 2394644 2394644 defendant Burnebury John fuller of cloth 608325 608325 Burnebury, John, of Launceston, Cornw, fuller of cloth 0
5135946 2397025 2397025 defendant Geffray Richard yeoman 608325 608325 Geffray, Richard, of Launceston, Cornw, yeoman 0
5135950 2397027 2397027 defendant Hamme William yeoman 608325 608325 Hamme, William, of Launceston, Cornw, yeoman 0
5141604 2398655 2398655 defendant Adam William skinner 608325 608325 Adam, William, of launceston, Cornw, skinner 0
5213452 2419667 2419667 defendant Colle Walter clerk 608325 608325 Colle, Walter, of Launceston, Cornw, clerk 0
5213455 2419668 2419668 defendant Colle Walter clerk 608325 608325 Colle, Walter, of Launceston, Cornw, clerk 0
5213656 2419729 2419729 defendant Palmer John gent 608325 608325 Palmer, John, of Launceston, Cornw, gent 0
5223250 2422496 2422496 defendant Palmer John gent 608325 608325 Palmer, John, of Launceston, Cornw, gent 0
5268352 2435868 2435868 defendant Hygowe Benedict gent 608325 608325 Hygowe, Benedict, of Launceston, Cornw, gent 3
5306035 2446791 2446791 defendant Page William yeoman 608325 608325 Page, William, of Launceston, Cornw, yeoman 4
5306336 2446879 2446879 defendant Page William yeoman 608325 608325 Page, William,of Launceston, Cornw, yeoman 4
5315163 2449590 2449590 defendant Corke Thomas gent 608325 608325 Corke, Thomas, of Launceston, Cornw, gent 0
5315386 2449661 2449661 defendant Burneby Thomas esq 608325 608325 Burneby, Thomas, of Launceston, Cornw, esq 0
5317150 2450209 2450209 defendant Combe Thomas yeoman 608325 608325 Combe, Thomas, of Launceston, Cornw, yeoman 0
5323879 2452224 2452224 defendant Wyndesore John gent 608325 608325 Wyndesore, John, of Launceston, Cornw, gent 2
5323883 2452225 2452225 plaintiff Wyndesore John gent 608325 608325 Wyndesore, John, of Launceston, Cornw, gent 2
5344699 2458517 2458517 defendant Tregarrek David gent 608325 608325 Tregarrek, David, of Launceston, Cornw, gent 0
5362761 2463996 2463996 defendant Tregarrek David gent 608325 608325 Tregarrek, David, of Launceston, Cornw, gent 0
5366962 2465316 2465316 defendant Rowelond William yeoman 608325 608325 Rowelond, William, of Launceston, Cornw, yeoman 0
5372217 2466905 2466905 defendant Corke John gent 608325 608325 Corke, John, of Launceston, Cornw, gent 0
5372397 2466964 2466964 defendant Corke John gent 608325 608325 Corke, John, of Launceston, Cornw, gent 0
5429822 2483862 2483862 defendant Lewes Thomas chapman 608325 608325 Lewes, Thomas, of Launceston, Cornw, chapman 0
5435403 2485529 2485529 defendant Taillour John chapman 608325 608325 Taillour, John, of Launceston, Cornw, chapman 3
5525536 2512578 2512578 defendant Jane William chapman 608325 608325 Jane, William, of Launceston, Cornw, chapman 0
5525541 2512579 2512579 defendant Jane William chapman 608325 608325 Jane, William, of Launceston, Cornw, chapman 1
5605775 2536693 2536693 defendant Gourde John yeoman 608325 608325 Gourde, John, of Launceston, Cornw, yeoman 0
5633227 2554397 2554397 defendant Hewet Thomas chapman 608325 608325 Hewet, Thomas, of Launceston, Cornw, chapman 1

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