names

36 rows where place_id = 592083

✎ 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
3606498 1869706 1869706 defendant Peyntenen or Peynteven John, senior husbandman 592083 592083 Peyntenen or Peynteven, John, senior, of Wymbyssh, husbandman 0
3710333 1929549 1929549 defendant Turtyll Thomas husbandman 592083 592083 Turtyll, Thomas, of Wymbyssh, husbandman 0
3729468 1935464 1935464 defendant Petyte Richard laborer 592083 592083 Petyte, Richard, of Wymbyssh, laborer 0
3864017 1978146 1978146 defendant Constable John husbandman 592083 592083 Constable, John, of Wymbyssh, husbandman 0
3864019 1978147 1978147 defendant Seryche William husbandman 592083 592083 Seryche, William, of Wymbyssh, husbandman 0
4621878 2237824 2237824 defendant Baker alias Shepherde Richard   592083 592083 Baker alias Shepherde, Richard, of Wymbyssh 0
4629964 2240292 2240292 defendant Whityng John   592083 592083 Whityng, John, of Wymbyssh, parson 0
4668338 2255813 2255813 defendant Brodok Thomas husbandman 592083 592083 Brodok, Thomas, of Wymbyssh, husbandman 0
4689077 2262144 2262144 defendant Lykand Simon laborer 592083 592083 Lykand, Simon, of Wymbyssh, laborer 0
4689079 2262145 2262145 defendant Bagge John, senior husbandman 592083 592083 Bagge, John, senior, of Wymbyssh, husbandman 0
4690459 2262577 2262577 defendant Bagge John skinner 592083 592083 Bagge, John, of Wymbyssh, skinner 0
4696228 2264304 2264304 defendant Curtays Thomas yeoman 592083 592083 Curtays, Thomas, of Wymbyssh, yeoman 0
4704881 2266903 2266903 defendant Brodoak Thomas gent 592083 592083 Brodoak, Thomas, of Wymbyssh, gent 0
4716273 2270399 2270399 defendant Bagge John skinner 592083 592083 Bagge, John, of Wymbyssh, skinner 0
4717794 2270906 2270906 plaintiff Arnold John wheeler 592083 592083 Arnold, John, of Wymbyssh, wheeler 0
4724081 2272829 2272829 plaintiff Edmond John   592083 592083 Edmond, John, of Wymbyssh 0
4725895 2273386 2273386 defendant Hokkele Thomas clerk 592083 592083 Hokkele, Thomas, of Wymbyssh, clerk 3
4817285 2301498 2301498 defendant Coo John husbandman 592083 592083 Coo, John, of Wymbyssh, husbandman 2
4842393 2309155 2309155 defendant Parker John, sen husbandman 592083 592083 Parker, John, sen, of Wymbyssh, husbandman 1
4845150 2309996 2309996 plaintiff Edmond John   592083 592083 Edmond, John, of Wymbyssh 2
4849396 2311288 2311288 defendant Grigge John husbandman 592083 592083 Grigge, John, of Wymbyssh, husbandman 0
4850825 2311707 2311707 defendant Petit Thomas, sen husbandman 592083 592083 Petit, Thomas, sen, of Wymbyssh, husbandman 0
4850829 2311708 2311708 defendant Mede John husbandman 592083 592083 Mede, John, of Wymbyssh, husbandman 0
4850830 2311708 2311708 defendant Colwell John husbandman 592083 592083 Colwell, John, of Wymbyssh, husbandman 1
4854663 2312830 2312830 defendant Bagge John husbandman 592083 592083 Bagge, John, of Wymbyssh, husbandman 1
4861163 2314851 2314851 defendant Grygge John husbandman 592083 592083 Grygge, John, of Wymbyssh, husbandman 0
4879394 2320485 2320485 defendant Grygge John, senior husbandman 592083 592083 Grygge, John, senior, of Wymbyssh, husbandman 0
4879395 2320485 2320485 defendant Mede John husbandman 592083 592083 Mede, John, of Wymbyssh, husbandman 1
4886809 2322730 2322730 defendant Yerdele William husbandman 592083 592083 Yerdele, William, of Wymbyssh, husbandman 1
4891522 2324084 2324084 defendant Grygge John, senior husbandman 592083 592083 Grygge, John, senior, of Wymbyssh, husbandman 0
4954091 2343189 2343189 defendant Barkere John husbandman 592083 592083 Barkere, John, of Wymbyssh, husbandman 0
4956782 2343986 2343986 defendant Grygge John, senior husbandman 592083 592083 Grygge, John, senior, of Wymbyssh, husbandman 0
4986628 2352933 2352933 defendant Barker John, sen farmer 592083 592083 Barker, John, sen, of Wymbyssh, farmer 2
5023441 2363764 2363764 defendant Bagge John husbandman 592083 592083 Bagge, John, of Wymbyssh, husbandman 0
5026104 2364531 2364531 defendant Hogge John husbandman 592083 592083 Hogge, John, of Wymbyssh, husbandman 0
5255357 2431791 2431791 defendant Colwell Thomas husbandman 592083 592083 Colwell, Thomas, of Wymbyssh, husbandman 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);