names

31 rows where place_id = 607663

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3670248 1916640 1916640 defendant Shodwell John scrivener 607663 607663 Shodwell, John, of Southwerk, Surrey, scrivener 1
3672366 1917360 1917360 defendant Magior Nicholas saddler 607663 607663 Magior, Nicholas, of Southwerk, Surrey, saddler 0
3681957 1920461 1920461 defendant Quadlyng John butcher 607663 607663 Quadlyng, John, of Southwerk, Surrey, butcher 1
3686284 1921864 1921864 defendant Cokkys John whitawer 607663 607663 Cokkys, John, of Southwerk, Surrey, whitawer 0
3887130 1985960 1985960 defendant Cockes John   607663 607663 Cockes, John, of Southwerk, Surrey, parchment maker 1
4692472 2263163 2263163 defendant Barton Thomas esq 607663 607663 Barton, Thomas, of Southwerk, Surrey, esq 0
4698219 2264928 2264928 defendant Totewyll William brewer 607663 607663 Totewyll, William, of Southwerk, Surrey, brewer 0
4699996 2265420 2265420 defendant Burgh Thomas clerk 607663 607663 Burgh, Thomas, of Southwerk, Surrey, clerk 2
4702862 2266290 2266290 defendant Rede John master of the hospital of St Thomas the martyr 607663 607663 Rede, John, of Southwerk, Surrey, master of the hospital of St Thomas the martyr 0
4703106 2266348 2266348 defendant Seman Walter skinner 607663 607663 Seman, Walter, of Southwerk, Surrey, skinner 0
4723243 2272578 2272578 defendant atte Pynde William glasier 607663 607663 atte Pynde, William, of Southwerk, Surrey, glasier 1
4758360 2282987 2282987 defendant Shirlond William baker 607663 607663 Shirlond, William, of Southwerk, Surrey, baker 0
4777982 2289098 2289098 defendant Coumbe John cordwainer 607663 607663 Coumbe, John, of Southwerk, Surrey, cordwainer 0
4899229 2326400 2326400 defendant Warmyngton Christopher gent 607663 607663 Warmyngton, Christopher, of Southwerk, Surrey, gent 3
4988893 2353630 2353630 defendant Mathewe John hosier 607663 607663 Mathewe, John, of Southwerk, Surrey, hosier 2
4991905 2354467 2354467 defendant Walsyngham Walter carpenter 607663 607663 Walsyngham, Walter, of Southwerk, Surrey, carpenter 0
5118379 2391811 2391811 defendant Gairgrave Agnes widow 607663 607663 Gairgrave, Agnes, of Southwerk, Surrey, widow 1
5148622 2400721 2400721 defendant Hopday Richard   607663 607663 Hopday, Richard, of Southwerk, Surrey, hackney man 0
5150019 2401139 2401139 defendant Fayreford Alexander esq 607663 607663 Fayreford, Alexander, of Southwerk, Surrey, esq 0
5155513 2402772 2402772 defendant Fayreford Alexander esq 607663 607663 Fayreford, Alexander, of Southwerk, Surrey, esq 2
5168343 2406458 2406458 defendant Ponynges Robert esq 607663 607663 Ponynges, Robert, of Southwerk, Surrey, esq 0
5168345 2406459 2406459 defendant Ponynges Robert esq 607663 607663 Ponynges, Robert, of Southwerk, Surrey, esq 0
5189267 2412593 2412593 defendant Hayward Robert yeoman 607663 607663 Hayward, Robert, of Southwerk, Surrey, yeoman 2
5191244 2413178 2413178 defendant Fayreford Alexander esq 607663 607663 Fayreford, Alexander, of Southwerk, Surrey, esq 1
5196983 2414862 2414862 defendant Kyrton William gent 607663 607663 Kyrton, William, of Southwerk, Surrey, gent 0
5206457 2417619 2417619 defendant Hayward Robert yeoman 607663 607663 Hayward, Robert, of Southwerk, Surrey, yeoman 2
5209889 2418625 2418625 defendant Kyrton William gent 607663 607663 Kyrton, William, of Southwerk, Surrey, gent 0
5223557 2422577 2422577 defendant Walkyngton John clerk 607663 607663 Walkyngton, John, of Southwerk, Surrey, clerk 4
5280064 2439245 2439245 defendant Cokkys Robert   607663 607663 Cokkys, Robert, of Southwerk, Surrey, yeomajn 0
5504737 2506399 2506399 defendant Avery Thomas gent 607663 607663 Avery, Thomas, of Southwerk, Surrey, gent 0
5590705 2532066 2532066 defendant Bevyll Robert yeoman 607663 607663 Bevyll, Robert, of Southwerk, Surrey, yeoman 3

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);