names

20 rows where place_id = 598356

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632106 1904858 1904858 defendant Grave William mariner 598356 598356 Grave, William, of Walberyswyk, mariner 0
4861902 2315100 2315100 defendant Cobbe Cecily widow 598356 598356 Cobbe, Cecily, of Walberyswyk, widow 0
4899510 2326485 2326485 defendant Bertram John butcher 598356 598356 Bertram, John, of Walberyswyk, butcher 3
4937627 2338142 2338142 defendant Ducheman Henry husbandman 598356 598356 Ducheman, Henry, of Walberyswyk, husbandman 4
4942915 2339760 2339760 defendant Calshawe John chaplain 598356 598356 Calshawe, John, of Walberyswyk, chaplain 0
4949388 2341795 2341795 defendant Cok John husbandman 598356 598356 Cok, John, of Walberyswyk, husbandman 1
4966357 2346872 2346872 defendant Calfhawe john clerk 598356 598356 Calfhawe, john, of Walberyswyk, clerk 0
4968453 2347531 2347531 defendant Basset John baker 598356 598356 Basset, John, of Walberyswyk, baker 1
5019975 2362723 2362723 defendant Basset John baker 598356 598356 Basset, John, of Walberyswyk, baker 1
5028158 2365107 2365107 defendant Basset John baker 598356 598356 Basset, John, of Walberyswyk, baker 1
5127167 2394423 2394423 plaintiff Bucke Thomas   598356 598356 Bucke, Thomas, of Walberyswyk 0
5322294 2451739 2451739 defendant Wene or Weve William carpenter 598356 598356 Wene or Weve, William, of Walberyswyk, or of Becclys, carpenter 0
5408343 2477467 2477467 defendant Rowe John merchant 598356 598356 Rowe, John, of Walberyswyk, merchant 0
5440607 2487097 2487097 defendant Breton John merchant 598356 598356 Breton, John, of Walberyswyk, merchant 0
5440609 2487098 2487098 defendant Rowe John mariner 598356 598356 Rowe, John, of Walberyswyk, mariner 0
5453919 2491061 2491061 defendant Bredon John merchant 598356 598356 Bredon, John, of Walberyswyk, merchant 0
5465816 2494692 2494692 defendant Couper Henry   598356 598356 Couper, Henry, of Walberyswyk, rope maker 1
5465818 2494693 2494693 defendant Breton John merchant 598356 598356 Breton, John, of Walberyswyk, merchant 0
5477279 2498216 2498216 defendant Breton John merchant 598356 598356 Breton, John, of Walberyswyk, merchant 0
5477280 2498216 2498216 defendant Couper Henry   598356 598356 Couper, Henry, of Walberyswyk, rope maker 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);