names

32 rows where place_id = 589256

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597031 1866695 1866695 defendant Howell William clothmaker 589256 589256 Howell, William, of Newebery, Berks, clothmaker 0
4003385 2025971 2025971 defendant Chamberlen Brian clothier 589256 589256 Chamberlen, Brian, of Newebery, Berks, clothier 0
4672044 2256905 2256905 defendant Messenger Nicholas husbandman 589256 589256 Messenger, Nicholas, of Newebery, Berks, husbandman 0
4727970 2273994 2273994 defendant Hille Henry   589256 589256 Hille, Henry, of Newebery, Berks, "velman" 0
4812637 2300070 2300070 defendant Warde John fuller 589256 589256 Warde, John, of Newebery, Berks, fuller 0
4867167 2316691 2316691 defendant Godard Thomas chapman 589256 589256 Godard, Thomas, of Newebery, Berks, chapman 0
4876261 2319536 2319536 defendant Breton William chapman 589256 589256 Breton, William, of Newebery, Berks, chapman 0
4889151 2323395 2323395 defendant Makus Henry chapman 589256 589256 Makus, Henry, of Newebery, Berks, chapman 1
4896093 2325438 2325438 defendant Makus John chapman 589256 589256 Makus, John, of Newebery, Berks, chapman 0
4896103 2325440 2325440 defendant Northcote Henry chapman 589256 589256 Northcote, Henry, of Newebery, Berks, chapman 0
4896127 2325445 2325445 defendant Makus Henry chapman 589256 589256 Makus, Henry, of Newebery, Berks, chapman 1
4899305 2326425 2326425 defendant Northcote Henry chapman 589256 589256 Northcote, Henry, of Newebery, Berks, chapman 0
4953193 2342914 2342914 defendant Godard Thomas hosteler 589256 589256 Godard, Thomas, of Newebery, Berks, hosteler 0
4958387 2344476 2344476 defendant Toke Roger shoemaker 589256 589256 Toke, Roger, of Newebery, Berks, shoemaker 0
4973368 2348975 2348975 defendant Halle William skinner 589256 589256 Halle, William, of Newebery, Berks, skinner 2
5087781 2382809 2382809 defendant Champ Richard   589256 589256 Champ, Richard, of Newebery, Berks, kersey man 0
5104014 2387598 2387598 defendant Smyth William yeoman 589256 589256 Smyth, William, of Newebery, Berks, yeoman 2
5112312 2389987 2389987 defendant Ingelby John   589256 589256 Ingelby, John, of Newebery, Berks 1
5333367 2455054 2455054 defendant Reynold William butcher 589256 589256 Reynold, William, of Newebery, Berks, butcher 0
5505037 2506486 2506486 plaintiff Bedford Nicholas draper 589256 589256 Bedford, Nicholas, of Newebery, Berks, draper 0
5525546 2512581 2512581 plaintiff Harre Robert draper 589256 589256 Harre, Robert, of Newebery, Berks, draper 0
5532397 2514674 2514674 defendant Adamys John grocer 589256 589256 Adamys, John, of Newebery, Berks, grocer 1
5532400 2514675 2514675 defendant Adamys John grocer 589256 589256 Adamys, John, of Newebery, Berks, grocer 1
5544313 2518332 2518332 defendant Feynold John dyer 589256 589256 Feynold, John, of Newebery, Berks, dyer 3
5549026 2519753 2519753 defendant Repyn Thomas fuller 589256 589256 Repyn, Thomas, of Newebery, Berks, fuller 0
5560187 2522942 2522942 defendant Adam John yeoman 589256 589256 Adam, John, of Newebery, Berks, yeoman 1
5560197 2522944 2522944 defendant Adam John yeoman 589256 589256 Adam, John, of Newebery, Berks, yeoman 0
5562585 2523660 2523660 defendant Hall Thomas dyer 589256 589256 Hall, Thomas, of Newebery, Berks, dyer 0
5562590 2523661 2523661 defendant Halle Thomas dyer 589256 589256 Halle, Thomas, of Newebery, Berks, dyer 0
5576307 2527646 2527646 defendant Garrat Cornelius yeoman 589256 589256 Garrat, Cornelius, of Newebery, Berks, yeoman 1
5588211 2531317 2531317 defendant Strynger Robert mercer 589256 589256 Strynger, Robert, of Newebery, Berks, mercer 0
5588215 2531318 2531318 defendant Strynger Robert mercer 589256 589256 Strynger, Robert, of Newebery, Berks, mercer 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);