names

36 rows where place_id = 617009

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3717343 1931707 1931707 defendant Osteler Robert merchant 617009 617009 Osteler, Robert, of Yarmouth, Norf, merchant 0
3723408 1933587 1933587 defendant Bactour William yeoman 617009 617009 Bactour, William, of Yarmouth, Norf, yeoman 7
3751786 1942479 1942479 defendant Tailler Brian gent 617009 617009 Tailler, Brian, of Yarmouth, Norf, gent 2
3891564 1987443 1987443 defendant Sawnders Robert merchant 617009 617009 Sawnders, Robert, of Yarmouth, Norf, merchant 0
3892727 1987819 1987819 defendant Rycheman Simon   617009 617009 Rycheman, Simon, of Yarmouth, Norf 1
3929914 2000347 2000347 defendant Borow William, junior chapman 617009 617009 Borow, William, junior, of Yarmouth, Norf, chapman 0
3929917 2000348 2000348 defendant Borowe William chapman 617009 617009 Borowe, William, of Yarmouth, Norf, chapman 0
3939202 2003416 2003416 defendant Pape John yeoman 617009 617009 Pape, John, of Yarmouth, Norf, yeoman 1
3990570 2021378 2021378 defendant Wythe John   617009 617009 Wythe, John, of Yarmouth, Norf 1
4191902 2092728 2092728 defendant Lambe Thomas butcher 617009 617009 Lambe, Thomas, of Yarmouth, Norf, butcher 1
4407885 2167203 2167203 defendant Mayham Richard grocer 617009 617009 Mayham, Richard, of Yarmouth, Norf, grocer 0
4668854 2255962 2255962 defendant Pampynges Geoffrey   617009 617009 Pampynges, Geoffrey, of Yarmouth, Norf, mercahtn 0
4669478 2256158 2256158 defendant Freman James merchant 617009 617009 Freman, James, of Yarmouth, Norf, merchant 1
4683580 2260467 2260467 defendant Pereles John draper 617009 617009 Pereles, John, of Yarmouth, Norf, draper 0
4685851 2261165 2261165 defendant Naulton Roger clerk 617009 617009 Naulton, Roger, of Yarmouth, Norf, clerk 2
4690066 2262443 2262443 defendant Kelle Nicholas woolman 617009 617009 Kelle, Nicholas, of Yarmouth, Norf, woolman 3
4739832 2277531 2277531 defendant Reman Robert merchant 617009 617009 Reman, Robert, of Yarmouth, Norf, merchant 0
4773310 2287628 2287628 defendant Elys Robert merchant 617009 617009 Elys, Robert, of Yarmouth, Norf, merchant 2
4805803 2298021 2298021 defendant Marnham Thomas chapman 617009 617009 Marnham, Thomas, of Yarmouth, Norf, chapman 0
4911535 2330109 2330109 defendant Dengayne Thomas gent 617009 617009 Dengayne, Thomas, of Yarmouth, Norf, gent 2
4912080 2330280 2330280 defendant Fuller John merchant 617009 617009 Fuller, John, of Yarmouth, Norf, merchant 0
4918703 2332367 2332367 defendant Elys Richard merchant 617009 617009 Elys, Richard, of Yarmouth, Norf, merchant 0
5000071 2356906 2356906 defendant Edmondes Robert chapman 617009 617009 Edmondes, Robert, of Yarmouth, Norf, chapman 0
5039302 2368397 2368397 defendant Lampet Ralph esq 617009 617009 Lampet, Ralph, of Yarmouth, Norf, esq 0
5047171 2370775 2370775 defendant Pynne John merchant 617009 617009 Pynne, John, of Yarmouth, Norf, merchant 4
5134961 2396726 2396726 defendant Lampet Ralph esq 617009 617009 Lampet, Ralph, of Yarmouth, Norf, esq 0
5155015 2402623 2402623 defendant Lampet Ralph esq 617009 617009 Lampet, Ralph, of Yarmouth, Norf, esq 0
5171809 2407475 2407475 defendant Lampet Ralph esq 617009 617009 Lampet, Ralph, of Yarmouth, Norf, esq 0
5207006 2417786 2417786 defendant Lampet Ralph esq 617009 617009 Lampet, Ralph, of Yarmouth, Norf, esq 0
5275386 2437870 2437870 defendant Crowemer Robert gent 617009 617009 Crowemer, Robert, of Yarmouth, Norf, gent 3
5370040 2466213 2466213 defendant Moy Christopher merchant 617009 617009 Moy, Christopher, of Yarmouth, Norf, merchant 0
5376720 2468316 2468316 defendant Chenyn William mariner 617009 617009 Chenyn, William, of Yarmouth, Norf, mariner 0
5376722 2468317 2468317 defendant Chenyn William miariner 617009 617009 Chenyn, William, of Yarmouth, Norf, miariner 0
5387848 2471583 2471583 defendant Mey Christopher merchant 617009 617009 Mey, Christopher, of Yarmouth, Norf, merchant 1
5408718 2477562 2477562 defendant (illegible) John mariner 617009 617009 _, John, of Yarmouth, Norf, mariner 1
5474690 2497413 2497413 defendant Maye Christopher merchant 617009 617009 Maye, Christopher, of Yarmouth, Norf, merchant 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);