names

38 rows where place_id = 594885

✎ 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
3617968 1873245 1873245 defendant Fynche Henry gent 594885 594885 Fynche, Henry, of Plukle, gent 0
3641277 1907723 1907723 defendant Munde Robert clothmaker 594885 594885 Munde, Robert, of Plukle, clothmaker 0
3650035 1910379 1910379 defendant Peryn Stephen laborer 594885 594885 Peryn, Stephen, of Plukle, laborer 1
4558777 2218701 2218701 defendant Holnherst Richard   594885 594885 Holnherst, Richard, of Plukle 0
4621876 2237823 2237823 defendant Pevell Richard   594885 594885 Pevell, Richard, of Plukle 0
4654364 2247239 2247239 defendant Curtays Thomas brewer 594885 594885 Curtays, Thomas, of Plukle, brewer 1
4663403 2250027 2250027 defendant Elys Robert collier 594885 594885 Elys, Robert, of Plukle, collier 0
4778570 2289282 2289282 plaintiff Bernes John   594885 594885 Bernes, John, of Plukle 0
4855294 2313008 2313008 defendant Malmayn Richard gent 594885 594885 Malmayn, Richard, of Plukle, gent 0
4871025 2317913 2317913 defendant Malmayn Richard gent 594885 594885 Malmayn, Richard, of Plukle, gent 0
4873616 2318687 2318687 defendant Pemell John baker 594885 594885 Pemell, John, of Plukle, baker 0
4883714 2321818 2321818 defendant Philpot Thomas husbandman 594885 594885 Philpot, Thomas, of Plukle, husbandman 0
4883716 2321818 2321818 defendant Godard Robert weaver 594885 594885 Godard, Robert, of Plukle, weaver 2
4887378 2322889 2322889 defendant Tylman Richard husbandman 594885 594885 Tylman, Richard, of Plukle, husbandman 0
4896994 2325710 2325710 defendant Malmayn Richard gent 594885 594885 Malmayn, Richard, of Plukle, gent 0
4897017 2325719 2325719 defendant Malmayn Richard gent 594885 594885 Malmayn, Richard, of Plukle, gent 0
4952380 2342666 2342666 defendant Danys or Davys John husbandman 594885 594885 Danys or Davys, John, of Plukle, husbandman 0
4955457 2343594 2343594 defendant Tylgheman John husbandman 594885 594885 Tylgheman, John, of Plukle, husbandman 0
4961155 2345299 2345299 plaintiff Betehnham Thomas   594885 594885 Betehnham, Thomas, of Plukle 0
4976304 2349868 2349868 plaintiff Pakynham Richard   594885 594885 Pakynham, Richard, of Plukle 0
4976305 2349868 2349868 defendant Godard Richard, senior husbandman 594885 594885 Godard, Richard, senior, of Plukle, husbandman 0
5018353 2362253 2362253 defendant Pakenham Richard tailor 594885 594885 Pakenham, Richard, of Plukle, tailor 0
5157032 2403196 2403196 defendant Munde William   594885 594885 Munde, William, of Plukle 5
5233487 2425385 2425385 defendant Welde Ralph yeoman 594885 594885 Welde, Ralph, of Plukle, yeoman 0
5239743 2427211 2427211 defendant Bettyngham Thomas gent 594885 594885 Bettyngham, Thomas, of Plukle, gent 0
5285014 2440639 2440639 defendant Boureman Thomas carpenter 594885 594885 Boureman, Thomas, of Plukle, carpenter 2
5285772 2440864 2440864 defendant Whatlowe William husbandman 594885 594885 Whatlowe, William, of Plukle, husbandman 0
5286928 2441181 2441181 defendant Doule or Donle Robert yeoman 594885 594885 Doule or Donle, Robert, of Plukle, yeoman 1
5286935 2441182 2441182 defendant Donle or Doule Robert yeoman 594885 594885 Donle or Doule, Robert, of Plukle, yeoman 3
5316022 2449868 2449868 defendant Frende William yeoman 594885 594885 Frende, William, of Plukle, yeoman 0
5332310 2454728 2454728 defendant Bocher John yeoman 594885 594885 Bocher, John, of Plukle, yeoman 0
5368367 2465723 2465723 defendant Deryng Agnes widow 594885 594885 Deryng, Agnes, of Plukle, widow 0
5482910 2499832 2499832 defendant Bettenham Thomas (legal representative) 594885 594885 Bettenham, Thomas, of Plukle, gent, executrix of 0
5482911 2499832 2499832 defendant Betnam Thomasine widow 594885 594885 Betnam, Thomasine, of Plukle, widow 1
5515219 2509606 2509606 defendant Bocher John (legal representative) 594885 594885 Bocher, John, of Plukle, yeoman, executor of 0
5515220 2509606 2509606 defendant Bocher Nicholas husbandman 594885 594885 Bocher, Nicholas, of Plukle, husbandman 1
5629190 2553105 2553105 defendant Tallour Robert husbandman 594885 594885 Tallour, Robert, of Plukle, husbandman 0
5630706 2553612 2553612 defendant Clyfton Thomas husbandman 594885 594885 Clyfton, Thomas, of Plukle, husbandman 2

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