names

54 rows where place_id = 753167

✎ 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
4411668 2168499 2168499 defendant Walbye Thomas gent 753167 753167 Walbye, Thomas, of Middlesex, gent 0
4483680 2195588 2195588 defendant Stoket William   753167 753167 Stoket, William, of Middlesex 0
4499495 2200489 2200489 defendant Henle Nicholas   753167 753167 Henle, Nicholas, of Middlesex 2
4510605 2203777 2203777 defendant Feltewell Thomas   753167 753167 Feltewell, Thomas, of Middlesex 0
4510612 2203778 2203778 defendant Feltewell Thomas   753167 753167 Feltewell, Thomas, of Middlesex 0
4530135 2209714 2209714 defendant Swanlond William   753167 753167 Swanlond, William, of Middlesex 2
4544128 2214077 2214077 defendant Bury William   753167 753167 Bury, William, of Middlesex 1
4547556 2215169 2215169 defendant Ivory John   753167 753167 Ivory, John, of Middlesex 1
4548557 2215489 2215489 defendant Wolpit John   753167 753167 Wolpit, John, of Middlesex 1
4548558 2215489 2215489 defendant Whyte Nicholas   753167 753167 Whyte, Nicholas, of Middlesex 2
4548683 2215529 2215529 defendant Wolpit John   753167 753167 Wolpit, John, of Middlesex 1
4548684 2215529 2215529 defendant Whyte Nicholas   753167 753167 Whyte, Nicholas, of Middlesex 2
4550051 2215954 2215954 defendant Bernard William   753167 753167 Bernard, William, of Middlesex 0
4550052 2215954 2215954 defendant Bernard John   753167 753167 Bernard, John, of Middlesex 1
4552076 2216601 2216601 defendant Stokes John   753167 753167 Stokes, John, of Middlesex 0
4553663 2217071 2217071 defendant Londoneys John   753167 753167 Londoneys, John, of Middlesex 0
4554214 2217244 2217244 defendant Taillour Roger   753167 753167 Taillour, Roger, of Middlesex 0
4571099 2222528 2222528 defendant Hardebache William   753167 753167 Hardebache, William, of Middlesex 0
4573144 2223134 2223134 defendant Standon Robert   753167 753167 Standon, Robert, of Middlesex, inn keeper 2
4577903 2224594 2224594 plaintiff Charlton Thomas   753167 753167 Charlton, Thomas, of Middlesex 0
4577906 2224595 2224595 plaintiff Charlton Thomas   753167 753167 Charlton, Thomas, of Middlesex 0
4583907 2226383 2226383 defendant Wykes Nicholas   753167 753167 Wykes, Nicholas, of Middlesex 0
4594358 2229493 2229493 plaintiff Pollard Adam   753167 753167 Pollard, Adam, of Middlesex 0
4611724 2234730 2234730 defendant Botirwyk Robert   753167 753167 Botirwyk, Robert, of Middlesex 1
4612746 2235053 2235053 defendant Straunge Roger   753167 753167 Straunge, Roger, of Middlesex, knight 0
4612747 2235053 2235053 defendant Stanwell Nicholas   753167 753167 Stanwell, Nicholas, of Middlesex 1
4612750 2235054 2235054 defendant Straunge Roger   753167 753167 Straunge, Roger, of Middlesex, knight 0
4612751 2235054 2235054 defendant Stanwell Nicholas   753167 753167 Stanwell, Nicholas, of Middlesex 1
4620603 2237433 2237433 defendant Shelton John glover 753167 753167 Shelton, John, of Middlesex, glover 0
4621123 2237590 2237590 plaintiff Knyght Robert   753167 753167 Knyght, Robert, of Middlesex 0
4628942 2239984 2239984 defendant White Stephen   753167 753167 White, Stephen, of Middlesex 0
4629010 2239996 2239996 defendant White Stephen   753167 753167 White, Stephen, of Middlesex 0
4632116 2240925 2240925 defendant Kendale Stephen   753167 753167 Kendale, Stephen, of Middlesex 0
4640108 2243225 2243225 defendant Lanwell Thomas   753167 753167 Lanwell, Thomas, of Middlesex 2
4640114 2243226 2243226 defendant Lanwell Thomas   753167 753167 Lanwell, Thomas, of Middlesex 2
4642763 2243996 2243996 defendant Webbe William   753167 753167 Webbe, William, of Middlesex 4
4645486 2244748 2244748 defendant Mayhewe Richard   753167 753167 Mayhewe, Richard, of Middlesex 0
4675758 2258025 2258025 plaintiff Freberne Richard   753167 753167 Freberne, Richard, of Middlesex, wire drawer 0
4701032 2265727 2265727 plaintiff Freberne Richard   753167 753167 Freberne, Richard, of Middlesex, wire drawer 0
4758227 2282947 2282947 defendant Grey Richard husbandman of the parish of St Sepulcre without London's West Smithfield Bar 753167 753167 Grey, Richard, of Middlesex, husbandman of the parish of St Sepulcre without London's West Smithfield Bar 1
4758230 2282948 2282948 defendant Grey Richard husbandman of the parish of St Sepulcre without London's West Smithfield Bar 753167 753167 Grey, Richard, of Middlesex, husbandman of the parish of St Sepulcre without London's West Smithfield Bar 1
4923108 2333644 2333644 defendant Bathe William   753167 753167 Bathe, William, of Middlesex, wax chandler 1
5033016 2366542 2366542 defendant Boucer William butcher 753167 753167 Boucer, William, of Middlesex, butcher 4
5137693 2397538 2397538 defendant Browne John gent 753167 753167 Browne, John, of Middlesex, gent 0
5159358 2403852 2403852 plaintiff Rothewell Thomas esq 753167 753167 Rothewell, Thomas, of Middlesex, esq 0
5159360 2403853 2403853 plaintiff Rothewell Thomas esq 753167 753167 Rothewell, Thomas, of Middlesex, esq 0
5174524 2408250 2408250 plaintiff Rothewell Thomas esq 753167 753167 Rothewell, Thomas, of Middlesex, esq 0
5195263 2414361 2414361 plaintiff Rothewell Thomas esq 753167 753167 Rothewell, Thomas, of Middlesex, esq 0
5209194 2418419 2418419 plaintiff Rothewell Thomas esq 753167 753167 Rothewell, Thomas, of Middlesex, esq 0
5420737 2481127 2481127 defendant Barbour (illegible) innholder 753167 753167 Barbour, _, of Middlesex, innholder 4
5425076 2482462 2482462 defendant W_dbroke Henry butcher 753167 753167 W_dbroke, Henry, of Middlesex, butcher 1
5466077 2494789 2494789 defendant Dynham Oliver clerk & Alderman 753167 753167 Dynham, Oliver, of Middlesex, clerk & Alderman 0
5473563 2497057 2497057 defendant Prank William baker 753167 753167 Prank, William, of Middlesex, baker 3
5609100 2537752 2537752 defendant Smyth Richard husbandman 753167 753167 Smyth, Richard, of Middlesex, husbandman 2

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