names

29 rows where place_id = 670793

✎ 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
3998856 2024347 2024347 defendant Nailer Henry merchant 670793 670793 Nailer, Henry, of Islington, Middx, merchant 0
3998892 2024363 2024363 plaintiff Foster Henry innholder 670793 670793 Foster, Henry, of Islington, Middx, innholder 0
4006311 2027036 2027036 defendant Hoode Thomas baker 670793 670793 Hoode, Thomas, of Islington, Middx, baker 1
4008102 2027662 2027662 plaintiff Maynerd Thomas innholder 670793 670793 Maynerd, Thomas, of Islington, Middx, innholder 0
4018857 2031475 2031475 plaintiff Walker John innholder 670793 670793 Walker, John, of Islington, Middx, innholder 0
4048174 2041785 2041785 defendant Barons Richard yeoman 670793 670793 Barons, Richard, of Islington, Middx, yeoman 0
4048176 2041786 2041786 defendant Barons Richard yeoman 670793 670793 Barons, Richard, of Islington, Middx, yeoman 0
4049936 2042409 2042409 defendant Cosen John yeoman 670793 670793 Cosen, John, of Islington, Middx, yeoman 0
4051973 2043126 2043126 defendant Cosen John yeoman 670793 670793 Cosen, John, of Islington, Middx, yeoman 0
4083469 2054361 2054361 defendant Benson Thomas tailor 670793 670793 Benson, Thomas, of Islington, Middx, tailor 2
4126286 2069695 2069695 defendant Sedgwicke Edward gent 670793 670793 Sedgwicke, Edward, of Islington, Middx, gent 0
4160187 2081626 2081626 defendant Byggyns Robert gent 670793 670793 Byggyns, Robert, of Islington, Middx, gent 0
4162042 2082281 2082281 defendant Biggens Lionel gent 670793 670793 Biggens, Lionel, of Islington, Middx, gent 1
4186421 2090736 2090736 defendant Tyrwett Elizabeth widow 670793 670793 Tyrwett, Elizabeth, of Islington, Middx, widow 1
4227679 2105163 2105163 defendant Worrell John yeman 670793 670793 Worrell, John, of Islington, Middx, yeman 1
4252990 2113993 2113993 defendant Worrall John yeoman 670793 670793 Worrall, John, of Islington, Middx, yeoman 0
4266410 2118410 2118410 defendant Worrall John yeoman 670793 670793 Worrall, John, of Islington, Middx, yeoman 0
4274037 2120863 2120863 defendant Gee Henry brewer 670793 670793 Gee, Henry, of Islington, Middx, brewer 0
4302173 2130878 2130878 defendant Wilkes Christopher goldsmith 670793 670793 Wilkes, Christopher, of Islington, Middx, or of London, goldsmith 2
4327090 2139392 2139392 defendant Martyn Thomas yeoman 670793 670793 Martyn, Thomas, of Islington, Middx, yeoman 1
4341097 2144157 2144157 defendant Cocker Nicholas yeoman 670793 670793 Cocker, Nicholas, of Islington, Middx, yeoman 0
4345986 2145856 2145856 defendant Harrys William carpenter 670793 670793 Harrys, William, of Islington, Middx, carpenter 1
4346792 2146129 2146129 defendant Anson John clerk 670793 670793 Anson, John, of Islington, Middx, clerk 2
4350906 2147571 2147571 defendant Cooke alias Saunders John yeoman 670793 670793 Cooke alias Saunders, John, of Islington, Middx, yeoman 0
4356153 2149374 2149374 defendant Wylson Edward baker 670793 670793 Wylson, Edward, of Islington, Middx, baker 0
4360426 2150895 2150895 defendant Anson John clerk 670793 670793 Anson, John, of Islington, Middx, clerk 0
4371737 2154951 2154951 defendant Brickland Godfrey innholder 670793 670793 Brickland, Godfrey, of Islington, Middx, innholder 0
4373458 2155575 2155575 defendant Pearcey Joan widow 670793 670793 Pearcey, Joan, of Islington, Middx, widow 1
4396531 2163414 2163414 defendant Grimes   innholder 670793 670793 Grimes, ,of Islington, Middx, innholder 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);