names

35 rows where place_id = 591293

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603959 1868906 1868906 defendant Kenynggale Robert merchant 591293 591293 Kenynggale, Robert, of Harwyche, merchant 0
3675257 1918300 1918300 plaintiff Harrys William merchant 591293 591293 Harrys, William, of Harwyche, merchant 0
3723480 1933610 1933610 defendant Browne John merchant 591293 591293 Browne, John, of Harwyche, merchant 0
3730641 1935817 1935817 defendant Clyff John mariner 591293 591293 Clyff, John, of Harwyche, mariner 0
3744010 1940018 1940018 defendant Wodward John sherman 591293 591293 Wodward, John, of Harwyche, sherman 0
3754247 1943280 1943280 defendant Leg Robert merchant 591293 591293 Leg, Robert, of Harwyche, merchant 0
3755723 1943751 1943751 plaintiff Wymbull Thomas (legal representative) 591293 591293 Wymbull, Thomas, of Harwyche, executors of 0
3793483 1955825 1955825 defendant Sacke John merchant 591293 591293 Sacke, John, of Harwyche, merchant 3
3794088 1956017 1956017 defendant Sakke John merchant 591293 591293 Sakke, John, of Harwyche, merchant 0
3806283 1959884 1959884 defendant Kyldgrave Hans   591293 591293 Kyldgrave, Hans, of Harwyche, organ maker 0
3842104 1971082 1971082 defendant A See John (legal representative) 591293 591293 A See, John, of Harwyche, Whitstaple, mariner, executors of 2
3842109 1971083 1971083 defendant A See John (legal representative) 591293 591293 A See, John, of Harwyche, Whitstaple, mariner, executors of 2
3865154 1978549 1978549 defendant Sak John beer brewer 591293 591293 Sak, John, of Harwyche, beer brewer 0
3872529 1981035 1981035 defendant Brown John mariner 591293 591293 Brown, John, of Harwyche, mariner 1
3872860 1981138 1981138 defendant Harvye Maurice mariner 591293 591293 Harvye, Maurice, of Harwyche, mariner 0
3895925 1988843 1988843 defendant Horlocke Thomas merchant 591293 591293 Horlocke, Thomas, of Harwyche, merchant 0
3901080 1990587 1990587 defendant Torr James merchant 591293 591293 Torr, James, of Harwyche, merchant 0
3906359 1992412 1992412 defendant Hurlok Thomas merchant 591293 591293 Hurlok, Thomas, of Harwyche, merchant 0
3927267 1999456 1999456 defendant Broke Francis merchant 591293 591293 Broke, Francis, of Harwyche, merchant 1
3941106 2004028 2004028 defendant Decke John merchant 591293 591293 Decke, John, of Harwyche, merchant 0
3941117 2004031 2004031 defendant Broke Francis merchant 591293 591293 Broke, Francis, of Harwyche, merchant 1
4282073 2123630 2123630 defendant Harryson Margaret spinster 591293 591293 Harryson, Margaret, of Harwyche, spinster 1
5040208 2368670 2368670 plaintiff Broke Henry merchant 591293 591293 Broke, Henry, of Harwyche, merchant 0
5235834 2426060 2426060 plaintiff Dove John merchant 591293 591293 Dove, John, of Harwyche, merchant 0
5376887 2468366 2468366 defendant Hobbys Thomas butcher 591293 591293 Hobbys, Thomas, of Harwyche, butcher 0
5400460 2475200 2475200 defendant Felawe Rose merchant 591293 591293 Felawe, Rose, of Harwyche, widow & formerly wife of John Felawe, of Harwich, merchant 0
5413442 2478946 2478946 defendant Felawe Rose merchant 591293 591293 Felawe, Rose, of Harwyche, widow, formerly wife of John Felawe, of Harwich, merchant 0
5491960 2502505 2502505 defendant Busshe Henry husbandman 591293 591293 Busshe, Henry, of Harwyche, husbandman 0
5491961 2502505 2502505 defendant Hobbys John, senior butcher 591293 591293 Hobbys, John, senior, of Harwyche, butcher 1
5491962 2502505 2502505 defendant Hobbys Thomas, junior butcher 591293 591293 Hobbys, Thomas, junior, of Harwyche, butcher 2
5509102 2507701 2507701 defendant Kenynghale Robert husbandman 591293 591293 Kenynghale, Robert, of Harwyche, husbandman 1
5540912 2517280 2517280 defendant Barbour John tailor 591293 591293 Barbour, John, of Harwyche, tailor 0
5569297 2525579 2525579 defendant Holdre Edmund roper 591293 591293 Holdre, Edmund, of Harwyche, roper 0
5573472 2526801 2526801 plaintiff Perse William   591293 591293 Perse, William, of Harwyche 0
5573972 2526952 2526952 defendant Fleccher John yeoman 591293 591293 Fleccher, John, of Harwyche, yeoman 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);