names

47 rows where place_id = 639219

✎ 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
3847638 1972831 1972831 defendant Markys John clerk 639219 639219 Markys, John, of Weymouth, Dorset, clerk 0
3862809 1977754 1977754 defendant Marke John clerk 639219 639219 Marke, John, of Weymouth, Dorset, clerk 0
3898467 1989700 1989700 defendant Jorden Thomas merchant 639219 639219 Jorden, Thomas, of Weymouth, Dorset, merchant 1
3908961 1993290 1993290 defendant Holman John gunner 639219 639219 Holman, John, of Weymouth, Dorset, gunner 0
3950324 2007195 2007195 defendant Bagge George gent 639219 639219 Bagge, George, of Weymouth, Dorset, gent 0
3952238 2007857 2007857 defendant Charles Hugh   639219 639219 Charles, Hugh, of Weymouth, Dorset, freemason 0
3989585 2021021 2021021 defendant Strete Thomas yeoman 639219 639219 Strete, Thomas, of Weymouth, Dorset, yeoman 0
4004777 2026485 2026485 defendant Randall Hugh merchant 639219 639219 Randall, Hugh, of Weymouth, Dorset, merchant 0
4007246 2027371 2027371 defendant Roberd Henry merchant 639219 639219 Roberd, Henry, of Weymouth, Dorset, merchant 0
4037218 2037974 2037974 defendant Randall Hugh merchant 639219 639219 Randall, Hugh, of Weymouth, Dorset, merchant 0
4097105 2059287 2059287 defendant Randall Hugh merchant 639219 639219 Randall, Hugh, of Weymouth, Dorset, merchant 1
4323907 2138406 2138406 defendant Johnes Nicholas gent 639219 639219 Johnes, Nicholas, of Weymouth, Dorset, gent 0
4397363 2163696 2163696 defendant Page Roger merchant 639219 639219 Page, Roger, of Weymouth, Dorset, merchant 0
4660827 2249211 2249211 defendant Bassyngbourne John merchant 639219 639219 Bassyngbourne, John, of Weymouth, Dorset, merchant 1
4695698 2264135 2264135 defendant Abbot John merchant 639219 639219 Abbot, John, of Weymouth, Dorset, merchant 0
4698105 2264893 2264893 defendant Golde William chapman 639219 639219 Golde, William, of Weymouth, Dorset, chapman 1
4698109 2264895 2264895 defendant Golde William chapman 639219 639219 Golde, William, of Weymouth, Dorset, chapman 0
4718717 2271193 2271193 defendant Abbot John merchant 639219 639219 Abbot, John, of Weymouth, Dorset, merchant 0
4759041 2283180 2283180 defendant Wyot William merchant 639219 639219 Wyot, William, of Weymouth, Dorset, merchant 1
4846132 2310297 2310297 defendant Payn William yeoman 639219 639219 Payn, William, of Weymouth, Dorset, yeoman 1
4943252 2339861 2339861 defendant Starre Nicholas merchant 639219 639219 Starre, Nicholas, of Weymouth, Dorset, merchant 0
4943451 2339920 2339920 defendant Sirla John gent 639219 639219 Sirla, John, of Weymouth, Dorset, gent 0
4943453 2339921 2339921 defendant Sirla John gent 639219 639219 Sirla, John, of Weymouth, Dorset, gent 0
4947144 2341097 2341097 defendant Bank John merchant 639219 639219 Bank, John, of Weymouth, Dorset, merchant 0
4961339 2345357 2345357 defendant Sue Richard mariner 639219 639219 Sue, Richard, of Weymouth, Dorset, mariner 2
4961343 2345358 2345358 defendant Snethelyng Richard shipman 639219 639219 Snethelyng, Richard, of Weymouth, Dorset, shipman 1
5032216 2366303 2366303 defendant Abbot Nicholas merchant 639219 639219 Abbot, Nicholas, of Weymouth, Dorset, merchant 1
5032220 2366304 2366304 defendant Abbot Nicholas merchant 639219 639219 Abbot, Nicholas, of Weymouth, Dorset, merchant 1
5032953 2366525 2366525 defendant Gower John merchant 639219 639219 Gower, John, of Weymouth, Dorset, merchant 1
5060314 2374659 2374659 defendant James Ralph merchant 639219 639219 James, Ralph, of Weymouth, Dorset, merchant 1
5067987 2376926 2376926 defendant Serla John gent 639219 639219 Serla, John, of Weymouth, Dorset, gent 3
5094525 2384808 2384808 plaintiff Russell Henry   639219 639219 Russell, Henry, of Weymouth, Dorset 0
5096514 2385413 2385413 defendant Ker Nicholas merchant 639219 639219 Ker, Nicholas, of Weymouth, Dorset, merchant 1
5150849 2401391 2401391 defendant Clerk John merchant 639219 639219 Clerk, John, of Weymouth, Dorset, merchant 0
5156895 2403165 2403165 defendant Martin John merchant 639219 639219 Martin, John, of Weymouth, Dorset, merchant 0
5172940 2407808 2407808 defendant Martyn John merchant 639219 639219 Martyn, John, of Weymouth, Dorset, merchant 0
5185793 2411591 2411591 defendant Clerk John merchant 639219 639219 Clerk, John, of Weymouth, Dorset, merchant 0
5197662 2415054 2415054 defendant Bursey Henry   639219 639219 Bursey, Henry, of Weymouth, Dorset, wax chandler 3
5210233 2418720 2418720 defendant Bursey Henry   639219 639219 Bursey, Henry, of Weymouth, Dorset, wax chandler 3
5265048 2434829 2434829 defendant Stephens Walter yeoman 639219 639219 Stephens, Walter, of Weymouth, Dorset, yeoman 1
5283332 2440183 2440183 defendant Abbot Nicholas merchant 639219 639219 Abbot, Nicholas, of Weymouth, Dorset, merchant 0
5292804 2442890 2442890 defendant Stephyns Walter yeoman 639219 639219 Stephyns, Walter, of Weymouth, Dorset, yeoman 1
5295726 2443746 2443746 defendant Abbot Nicholas merchant 639219 639219 Abbot, Nicholas, of Weymouth, Dorset, merchant 0
5304699 2446401 2446401 defendant Weymonth Thomas merchant 639219 639219 Weymonth, Thomas, of Weymouth, Dorset, merchant 0
5331593 2454529 2454529 defendant Abbot Nicholas merchant 639219 639219 Abbot, Nicholas, of Weymouth, Dorset, merchant 1
5627151 2552459 2552459 defendant James John merchant 639219 639219 James, John, of Weymouth, Dorset, merchant 2
5627168 2552462 2552462 defendant Bakere John merchant 639219 639219 Bakere, John, of Weymouth, Dorset, merchant 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);