names

50 rows where place_id = 605698

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649243 1910152 1910152 defendant Hawell alias Holle John carrier 605698 605698 Hawell alias Holle, John, of Pynne, , carrier 0
3662607 1914224 1914224 defendant Bygnay Richard   605698 605698 Bygnay, Richard, of Pynne, groom 3
3662608 1914224 1914224 defendant Rowlyn John laborer 605698 605698 Rowlyn, John, of Pynne, laborer 4
3668397 1916065 1916065 defendant Hole John carrier 605698 605698 Hole, John, of Pynne, carrier 0
3668399 1916066 1916066 defendant Hole John carrier 605698 605698 Hole, John, of Pynne, carrier 0
3681805 1920411 1920411 defendant Bydney Thomas husbandman 605698 605698 Bydney, Thomas, of Pynne, husbandman 0
3712763 1930309 1930309 defendant Bidney Thomas carrier 605698 605698 Bidney, Thomas, of Pynne, carrier 0
3988701 2020702 2020702 defendant Lee John laborer 605698 605698 Lee, John, of Pynne, laborer 0
3988702 2020702 2020702 defendant Lee Edmund laborer 605698 605698 Lee, Edmund, of Pynne, laborer 1
3988703 2020702 2020702 defendant Kelley George laborer 605698 605698 Kelley, George, of Pynne, laborer 2
4674516 2257643 2257643 defendant German John, senior husbandman 605698 605698 German, John, senior, of Pynne, husbandman 0
4674517 2257643 2257643 defendant German John, junior laborer 605698 605698 German, John, junior, of Pynne, laborer 1
4674518 2257643 2257643 defendant German William laborer 605698 605698 German, William, of Pynne, laborer 2
4674519 2257643 2257643 defendant Shepherd John laborer 605698 605698 Shepherd, John, of Pynne, laborer 3
4777185 2288848 2288848 defendant Fauconer Simon husbandman 605698 605698 Fauconer, Simon, of Pynne, husbandman 0
4813495 2300330 2300330 defendant Newecombe Robert   605698 605698 Newecombe, Robert, of Pynne, bailiff 4
4889305 2323443 2323443 plaintiff Cheyne John   605698 605698 Cheyne, John, of Pynne 0
4990730 2354137 2354137 plaintiff Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 0
4990736 2354138 2354138 plaintiff Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 0
4990744 2354139 2354139 plaintiff Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 0
5017524 2362011 2362011 plaintiff Cheyne John   605698 605698 Cheyne, John, of Pynne 0
5017526 2362012 2362012 plaintiff Cheyne John   605698 605698 Cheyne, John, of Pynne 0
5039053 2368327 2368327 defendant Peng John butcher 605698 605698 Peng, John, of Pynne, butcher 0
5039058 2368329 2368329 defendant Peng John butcher 605698 605698 Peng, John, of Pynne, butcher 0
5043491 2369675 2369675 defendant tylke John, senior husbandman 605698 605698 tylke, John, senior, of Pynne, husbandman 2
5090347 2383559 2383559 defendant Cheyne John   605698 605698 Cheyne, John, of Pynne, esq, sheriff 0
5104991 2387901 2387901 plaintiff Cheyne John   605698 605698 Cheyne, John, of Pynne, sheriff of Soms 0
5137818 2397571 2397571 defendant Baron John husbandman 605698 605698 Baron, John, of Pynne, husbandman 0
5137822 2397572 2397572 defendant Baron John husbandman 605698 605698 (Baron, John, of Pynne, husbandman 1
5144987 2399684 2399684 plaintiff Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 2
5145033 2399692 2399692 plaintiff Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 2
5179914 2409862 2409862 plaintiff Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 2
5202133 2416392 2416392 plaintiff Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 2
5249639 2430013 2430013 defendant Cheyne John   605698 605698 Cheyne, John, of Pynne 0
5268304 2435851 2435851 defendant Bradeford William husbandman 605698 605698 Bradeford, William, of Pynne, husbandman 0
5278267 2438743 2438743 defendant Bradeford William husbandman 605698 605698 Bradeford, William, of Pynne, husbandman 0
5288524 2441659 2441659 plaintiff Cheyne John   605698 605698 Cheyne, John, of Pynne 2
5314976 2449531 2449531 plaintiff Cheyne John   605698 605698 Cheyne, John, of Pynne, sheriff 0
5332299 2454724 2454724 plaintiff Cheyne John   605698 605698 Cheyne, John, of Pynne, sheriff of Devon 0
5332301 2454725 2454725 plaintiff Cheyne John   605698 605698 Cheyne, John, of Pynne 0
5350827 2460368 2460368 defendant Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 1
5375316 2467867 2467867 defendant Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 0
5391701 2472700 2472700 defendant Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 0
5404713 2476427 2476427 defendant Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 0
5417859 2480269 2480269 defendant Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 0
5443710 2488042 2488042 plaintiff Chayne John esq 605698 605698 Chayne, John, of Pynne, esq 0
5478468 2498587 2498587 defendant Abbot John yeoman 605698 605698 Abbot, John, of Pynne, yeoman 1
5479535 2498891 2498891 plaintiff Cheyne John esq 605698 605698 Cheyne, John, of Pynne, esq 0
5499759 2504871 2504871 defendant Penge William butcher 605698 605698 Penge, William, of Pynne, butcher 1
5508781 2507601 2507601 defendant Forde William laborer 605698 605698 Forde, William, of Pynne, laborer 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);