names

89 rows where place_id = 586273

✎ 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
3588320 1863998 1863998 defendant Thomerard James laborer 586273 586273 Thomerard, James, of Pensans, laborer 0
3602002 1868286 1868286 defendant Treruse William husbandman 586273 586273 Treruse, William, of Pensans, husbandman 2
3603713 1868831 1868831 defendant Vyvyan Richard tailor 586273 586273 Vyvyan, Richard, of Pensans, tailor 4
3604326 1869017 1869017 plaintiff Harry Robert   586273 586273 Harry, Robert, of Pensans 1
3610470 1870935 1870935 defendant Thourobard James mariner 586273 586273 Thourobard, James, of Pensans, mariner 0
3624549 1875215 1875215 defendant Myles Nicholas merchant 586273 586273 Myles, Nicholas, of Pensans, merchant 1
3628624 1903827 1903827 defendant Jakvenny Robert fisher 586273 586273 Jakvenny, Robert, of Pensans, fisher 0
3643811 1908492 1908492 defendant Althyun Richard Jack fisher 586273 586273 Althyun, Richard Jack, of Pensans, fisher 2
3646985 1909458 1909458 defendant Beauchamp James   586273 586273 Beauchamp, James, of Pensans, franklin 0
3666532 1915472 1915472 defendant Foster John mariner 586273 586273 Foster, John, of Pensans, mariner 1
3711706 1929973 1929973 defendant Saundry John fisher 586273 586273 Saundry, John, of Pensans, fisher 0
3759321 1944906 1944906 defendant Holla Robart mariner 586273 586273 Holla, Robart, of Pensans, mariner 0
3777282 1950640 1950640 defendant Huchyn John carpenter 586273 586273 Huchyn, John, of Pensans, carpenter 0
3838523 1969973 1969973 defendant Ronnell Robert carpenter 586273 586273 Ronnell, Robert, of Pensans, carpenter 1
3869038 1979889 1979889 plaintiff Trengove Henry   586273 586273 Trengove, Henry, of Pensans 0
3886958 1985903 1985903 defendant Vyvyan James gent 586273 586273 Vyvyan, James, of Pensans, gent 0
3886960 1985903 1985903 defendant Harry John laborer 586273 586273 Harry, John, of Pensans, laborer 2
3890058 1986910 1986910 defendant Chynals John merchant 586273 586273 Chynals, John, of Pensans, merchant 0
3893403 1988026 1988026 defendant Lawry Robert fisher 586273 586273 Lawry, Robert, of Pensans, fisher 0
3893404 1988026 1988026 defendant Rychard John fisher 586273 586273 Rychard, John, of Pensans, fisher 1
3893405 1988026 1988026 defendant John Barnard fisher 586273 586273 John, Barnard, of Pensans, fisher 2
3893406 1988026 1988026 defendant Jeffrey John fisher 586273 586273 Jeffrey, John, of Pensans, fisher 3
3893407 1988026 1988026 defendant Alorche Matthew fisher 586273 586273 Alorche, Matthew, of Pensans, fisher 4
3893408 1988026 1988026 defendant Wemouth Peter fisher 586273 586273 Wemouth, Peter, of Pensans, fisher 5
3893409 1988026 1988026 defendant Laregon William fisher 586273 586273 Laregon, William, of Pensans, fisher 6
3893410 1988026 1988026 defendant Tom William fisher 586273 586273 Tom, William, of Pensans, fisher 7
3894917 1988509 1988509 defendant Beachampe Martin gent 586273 586273 Beachampe, Martin, of Pensans, gent 0
3896421 1989008 1989008 defendant Chynals John merchant 586273 586273 Chynals, John, of Pensans, merchant 0
3900987 1990559 1990559 defendant Vyvyan James gent 586273 586273 Vyvyan, James, of Pensans, gent 0
3900989 1990559 1990559 defendant Harry John laborer 586273 586273 Harry, John, of Pensans, laborer 2
3901006 1990564 1990564 plaintiff Chynals John   586273 586273 Chynals, John, of Pensans 0
3904178 1991642 1991642 defendant Chynale John merchant 586273 586273 Chynale, John, of Pensans, merchant 0
3920367 1997153 1997153 defendant Jenkyn Michael fisher 586273 586273 Jenkyn, Michael, of Pensans, fisher 0
3922566 1997862 1997862 defendant Thomas David fisher 586273 586273 Thomas, David, of Pensans, fisher 0
3926615 1999234 1999234 defendant Jenkyn Michael fisher 586273 586273 Jenkyn, Michael, of Pensans, fisher 0
3932987 2001326 2001326 defendant Luar alias Richard John merchant 586273 586273 Luar alias Richard, John, of Pensans, merchant 0
3938254 2003132 2003132 defendant Hunt Roger gent 586273 586273 Hunt, Roger, of Pensans, gent 0
4070031 2049570 2049570 plaintiff Maddurne John merchant 586273 586273 Maddurne, John, of Pensans, merchant 0
4472330 2192018 2192018 defendant Cosyn John   586273 586273 Cosyn, John, of Pensans 0
4549473 2215780 2215780 defendant Pensans Robert   586273 586273 Pensans, Robert, of Pensans 7
4570079 2222215 2222215 defendant Ude Richard   586273 586273 Ude, Richard, of Pensans 0
4622474 2238011 2238011 plaintiff Lukky John   586273 586273 Lukky, John, of Pensans 0
4644338 2244435 2244435 plaintiff Luky John   586273 586273 Luky, John, of Pensans 0
4644736 2244540 2244540 defendant Gof Thomas   586273 586273 Gof, Thomas, of Pensans 3
4666638 2251049 2251049 defendant Adowe Harvy fisher 586273 586273 Adowe, Harvy, of Pensans, fisher 0
4666640 2251049 2251049 defendant Raynold William mariner 586273 586273 Raynold, William, of Pensans, mariner 2
4727104 2273738 2273738 defendant Nycoldoure John mariner 586273 586273 Nycoldoure, John, of Pensans, mariner 0
4753178 2281378 2281378 defendant Coly John fisher 586273 586273 Coly, John, of Pensans, fisher 0
4766975 2285660 2285660 plaintiff Luky John merchant 586273 586273 Luky, John, of Pensans, merchant 0
4776943 2288775 2288775 defendant Treher John merchant 586273 586273 Treher, John, of Pensans, merchant 3
4791338 2293385 2293385 plaintiff Luky John merchant 586273 586273 Luky, John, of Pensans, merchant 0
4796572 2295080 2295080 defendant Deveros or Deneros John husbandman 586273 586273 Deveros or Deneros, John, of Pensans, husbandman 1
4803066 2297146 2297146 defendant Luky John merchant 586273 586273 Luky, John, of Pensans, merchant 0
4807053 2298404 2298404 defendant Jakkerchyn Martin fisher 586273 586273 Jakkerchyn, Martin, of Pensans, fisher 0
4807054 2298404 2298404 defendant Williamcolowe Roger fisher 586273 586273 Williamcolowe, Roger, of Pensans, fisher 1
4822093 2302987 2302987 defendant Martyn Robert mariner 586273 586273 Martyn, Robert, of Pensans, mariner 0
4825214 2303928 2303928 defendant Trewethunev James yeoman 586273 586273 Trewethunev, James, of Pensans, yeoman 1
4856585 2313442 2313442 defendant Herry John baker 586273 586273 Herry, John, of Pensans, baker 0
4896550 2325590 2325590 defendant Pennans John husbandman 586273 586273 Pennans, John, of Pensans, husbandman 7
4939410 2338708 2338708 defendant Michell Nicholas mariner 586273 586273 Michell, Nicholas, of Pensans, mariner 0
4939411 2338708 2338708 defendant Penros William chaplain 586273 586273 Penros, William, of Pensans, chaplain 1
4943090 2339813 2339813 defendant Berry John husbandman 586273 586273 Berry, John, of Pensans, husbandman 0
4948543 2341522 2341522 defendant Bray Reginald yeoman 586273 586273 Bray, Reginald, of Pensans, yeoman 0
4956115 2343792 2343792 defendant Martyn Robert merchant 586273 586273 Martyn, Robert, of Pensans, merchant 0
4972566 2348726 2348726 defendant Mercer John merchant 586273 586273 Mercer, John, of Pensans, merchant 1
4972567 2348726 2348726 defendant Olyver John merchant 586273 586273 Olyver, John, of Pensans, merchant 2
4976549 2349946 2349946 defendant Harryleg John fisher 586273 586273 Harryleg, John, of Pensans, fisher 1
5009282 2359602 2359602 defendant Martyn Robert merchant 586273 586273 Martyn, Robert, of Pensans, merchant 0
5088224 2382928 2382928 defendant Den William fisher 586273 586273 Den, William, of Pensans, fisher 1
5088458 2383000 2383000 defendant Hervy Michael mariner 586273 586273 Hervy, Michael, of Pensans, mariner 0
5121983 2392847 2392847 defendant Jakke John fisher 586273 586273 Jakke, John, of Pensans, fisher 3
5121984 2392847 2392847 defendant Mercer John mercer 586273 586273 Mercer, John, of Pensans, mercer 4
5121985 2392847 2392847 defendant Richard Vivian fisher 586273 586273 Richard, Vivian, of Pensans, fisher 5
5121986 2392847 2392847 defendant Martyn Robert merchant 586273 586273 Martyn, Robert, of Pensans, merchant 6
5249864 2430071 2430071 defendant William John, junior yeoman 586273 586273 William, John, junior, of Pensans, yeoman 5
5253198 2431096 2431096 defendant John Watty Robert merchant 586273 586273 John Watty, Robert, of Pensans, merchant 1
5283693 2440278 2440278 defendant Jankyn Henry weaver 586273 586273 Jankyn, Henry, of Pensans, weaver 0
5315062 2449559 2449559 defendant Hervy John yeoman 586273 586273 Hervy, John, of Pensans, yeoman 0
5327319 2453242 2453242 defendant Chyres Peter husbandman 586273 586273 Chyres, Peter, of Pensans, husbandman 1
5340676 2457283 2457283 defendant Marten John merchant 586273 586273 Marten, John, of Pensans, merchant 0
5340678 2457284 2457284 defendant Marten John merchant 586273 586273 Marten, John, of Pensans, merchant 0
5340702 2457293 2457293 defendant Tregarn James gent 586273 586273 Tregarn, James, of Pensans, gent 1
5482177 2499611 2499611 defendant Trewardavowe John fisher 586273 586273 Trewardavowe, John, of Pensans, fisher 4
5554983 2521460 2521460 defendant Jakvenny John fisher 586273 586273 Jakvenny, John, of Pensans, fisher 1
5570357 2525898 2525898 defendant Treruse William fisher 586273 586273 Treruse, William, of Pensans, fisher 3
5584567 2530243 2530243 defendant Clemowe William merchant 586273 586273 Clemowe, William, of Pensans, merchant 0
5603847 2536071 2536071 defendant Treruff William yeoman 586273 586273 Treruff, William, of Pensans, yeoman 0
5625199 2551820 2551820 defendant Goef Thomas smith 586273 586273 Goef, Thomas, of Pensans, smith 2
5625207 2551821 2551821 defendant Boef Thomas smith 586273 586273 Boef, Thomas, of Pensans, smith 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);