names

32 rows where place_id = 587548

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591712 1865026 1865026 defendant Mayne William gent 587548 587548 Mayne, William, of Wylton, Wilts, gent 0
3619127 1873586 1873586 defendant Mustall or Muscall Thomas butcher 587548 587548 Mustall or Muscall, Thomas, of Wylton, Wilts, butcher 0
3650200 1910433 1910433 defendant Willoughby Anthony esq 587548 587548 Willoughby, Anthony, of Wylton, Wilts, esq 0
3752127 1942589 1942589 defendant Syms Thomas butcher 587548 587548 Syms, Thomas, of Wylton, Wilts, butcher 1
3837836 1969747 1969747 defendant Hyllysdon Richard gent 587548 587548 Hyllysdon, Richard, of Wylton, Wilts, gent 1
3849892 1973551 1973551 defendant Reynoldys Walter clothier 587548 587548 Reynoldys, Walter, of Wylton, Wilts, clothier 3
3898610 1989743 1989743 defendant Clement Edward gent 587548 587548 Clement, Edward, of Wylton, Wilts, gent 1
3926571 1999218 1999218 defendant Willoughby Christopher esq 587548 587548 Willoughby, Christopher, of Wylton, Wilts, esq 2
3928333 1999812 1999812 plaintiff Besford or Befford Gilbert clother 587548 587548 Besford or Befford, Gilbert, of Wylton, Wilts, clother 0
3945861 2005627 2005627 plaintiff Browne alias Clement Edward gent 587548 587548 Browne alias Clement, Edward, of Wylton, Wilts, gent 0
4097994 2059611 2059611 defendant Halcott William butcher 587548 587548 Halcott, William, of Wylton, Wilts, yeoman, butcher 0
4131476 2071577 2071577 defendant Foxe george yeoman 587548 587548 Foxe, george, of Wylton, Wilts, yeoman 1
4203899 2096918 2096918 defendant Potycarier Thomas clothier 587548 587548 Potycarier, Thomas, of Wylton, Wilts, clothier 2
4561988 2219679 2219679 defendant Harleston John   587548 587548 Harleston, John, of Wylton, Wilts 0
4672670 2257094 2257094 defendant Ardy John husbandman 587548 587548 Ardy, John, of Wylton, Wilts, husbandman 1
4680768 2259604 2259604 defendant Shyrborne John butcher 587548 587548 Shyrborne, John, of Wylton, Wilts, butcher 0
4902037 2327244 2327244 defendant Peper Robert butcher 587548 587548 Peper, Robert, of Wylton, Wilts, butcher 1
4947300 2341148 2341148 defendant Rose John brewer 587548 587548 Rose, John, of Wylton, Wilts, brewer 0
4994985 2355359 2355359 defendant Wastyll William chapman 587548 587548 Wastyll, William, of Wylton, Wilts, chapman 2
4994993 2355360 2355360 defendant Wastyll William chapman 587548 587548 Wastyll, William, of Wylton, Wilts, chapman 2
4999527 2356732 2356732 defendant Moreton Robert clerk 587548 587548 Moreton, Robert, of Wylton, Wilts, clerk 0
5004100 2358087 2358087 defendant Blyke John fuller 587548 587548 Blyke, John, of Wylton, Wilts, fuller 0
5028436 2365192 2365192 defendant Turpyn John   587548 587548 Turpyn, John, of Wylton, Wilts, franklin 2
5061569 2375049 2375049 defendant Cole John clothmaker 587548 587548 Cole, John, of Wylton, Wilts, clothmaker 4
5083816 2381659 2381659 defendant Crede John yeoman 587548 587548 Crede, John, of Wylton,Wilts, yeoman 4
5190168 2412867 2412867 defendant Yong John butcher 587548 587548 Yong, John, of Wylton, Wilts, butcher 2
5214342 2419929 2419929 defendant Seward Joan widow 587548 587548 Seward, Joan, of Wylton, Wilts, widow 1
5295482 2443670 2443670 defendant Fenne Robert gent 587548 587548 Fenne, Robert, of Wylton, Wilts, gent 0
5370180 2466259 2466259 defendant Pole John gent 587548 587548 Pole, John, of Wylton, Wilts, gent 0
5398029 2474504 2474504 defendant Paleset John skinner 587548 587548 Paleset, John, of Wylton, Wilts, skinner 2
5411244 2478323 2478323 defendant Paleser John skinner 587548 587548 Paleser, John, of Wylton, Wilts, skinner 2
5536556 2515918 2515918 defendant Worcester Robert chaplain 587548 587548 Worcester, Robert, of Wylton, Wilts, chaplain 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);