names

32 rows where place_id = 601814

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647141 1909497 1909497 defendant Beverley William husbandman 601814 601814 Beverley, William, of Kirton in Holand, husbandman 0
4653511 2247031 2247031 defendant Stalworth John husbandman 601814 601814 Stalworth, John, of Kirton in Holand, son of Alexander Stalworth, of Kirton in Holand, Lincs, husbandman 0
4754923 2281921 2281921 defendant Foule John yeoman 601814 601814 Foule, John, of Kirton in Holand, yeoman 0
4754924 2281921 2281921 defendant Foule Edmund yeoman 601814 601814 Foule, Edmund, of Kirton in Holand, yeoman 1
4805331 2297872 2297872 defendant Ailleward Matilda widow 601814 601814 Ailleward, Matilda, of Kirton in Holand, widow 0
4826907 2304452 2304452 defendant Jacson John husbandman 601814 601814 Jacson, John, of Kirton in Holand, husbandman 0
4848359 2310958 2310958 defendant Bykirswayn Robert husbandman 601814 601814 Bykirswayn, Robert, of Kirton in Holand, husbandman 0
4900708 2326860 2326860 defendant Belle Richard   601814 601814 Belle, Richard, of Kirton in Holand, wright 2
4900710 2326861 2326861 defendant Smyth William husbandman 601814 601814 Smyth, William, of Kirton in Holand, husbandman 0
4907738 2328983 2328983 defendant Bryce William yeoman 601814 601814 Bryce, William, of Kirton in Holand, yeoman 1
4907743 2328984 2328984 defendant Bryce William yeoman 601814 601814 Bryce, William, of Kirton in Holand, yeoman 0
4913300 2330660 2330660 defendant Smyth John husbandman 601814 601814 Smyth, John, of Kirton in Holand, husbandman 0
4923606 2333817 2333817 defendant Bailly Eleanor widow 601814 601814 Bailly, Eleanor, of Kirton in Holand, widow 0
4923607 2333817 2333817 defendant Bailly John husbandman 601814 601814 Bailly, John, of Kirton in Holand, husbandman 1
4930141 2335834 2335834 defendant Alaynson Thomas husbandman 601814 601814 Alaynson, Thomas, of Kirton in Holand, husbandman 0
4945041 2340432 2340432 defendant Copildyke William husbandman 601814 601814 Copildyke, William, of Kirton in Holand, husbandman 0
4952977 2342853 2342853 defendant Stowe William   601814 601814 Stowe, William, of Kirton in Holand 0
4968772 2347629 2347629 defendant Heyland William husbandman 601814 601814 Heyland, William, of Kirton in Holand, husbandman 0
4968773 2347629 2347629 defendant Heyland John   601814 601814 Heyland, John, of Kirton in Holand, servant 1
4968774 2347629 2347629 defendant heyland Alice   601814 601814 heyland, Alice, of Kirton in Holand, servant 2
4968884 2347657 2347657 defendant Lambard John husbandman 601814 601814 Lambard, John, of Kirton in Holand, husbandman 0
4968885 2347657 2347657 defendant Anderton Richard husbandman 601814 601814 Anderton, Richard, of Kirton in Holand, husbandman 1
4968886 2347657 2347657 defendant Hervy Alan husbandman 601814 601814 Hervy, Alan, of Kirton in Holand, husbandman 2
4968887 2347657 2347657 defendant Halle Richard husbandman 601814 601814 Halle, Richard, of Kirton in Holand, husbandman 3
5082879 2381383 2381383 defendant Echard Alice widow 601814 601814 (Echard, Alice, of Kirton in Holand, widow 1
5082880 2381383 2381383 defendant Echard Thomas husbandman 601814 601814 Echard, Thomas, of Kirton in Holand, husbandman 2
5082881 2381383 2381383 defendant Echard Alan husbandman 601814 601814 Echard, Alan, of Kirton in Holand, husbandman 3
5095372 2385067 2385067 defendant Cony John yeoman 601814 601814 Cony, John, of Kirton in Holand, yeoman 0
5165170 2405556 2405556 defendant Bate Robert yeoman 601814 601814 Bate, Robert, of Kirton in Holand, yeoman 0
5468608 2495551 2495551 defendant Sil_ William husbandman 601814 601814 Sil_, William, of Kirton in Holand, husbandman 0
5468609 2495551 2495551 defendant Tomson Agnes widow 601814 601814 Tomson, Agnes, of Kirton in Holand, widow 1
5468610 2495551 2495551 defendant Barmby Katherine widow 601814 601814 Barmby, Katherine, of Kirton in Holand, widow 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);