names

39 rows where place_id = 699141

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4127561 2070148 2070148 defendant Nicoll George woolman 699141 699141 Nicoll, George, of Ashwell, woolman 0
4154796 2079772 2079772 defendant Barlye John yeoman 699141 699141 Barlye, John, of Ashwell, yeoman 1
4156231 2080253 2080253 defendant Barley John yeoman 699141 699141 Barley, John, of Ashwell, yeoman 0
4170633 2085230 2085230 defendant Raynard William husbandman 699141 699141 Raynard, William, of Ashwell, husbandman 1
4179873 2088435 2088435 defendant Colvyle Richard miller 699141 699141 Colvyle, Richard, of Ashwell, miller 2
4187682 2091194 2091194 defendant Wrangle Thomas husbandman 699141 699141 Wrangle, Thomas, of Ashwell, husbandman 1
4202915 2096565 2096565 defendant Rayner William husbandman 699141 699141 Rayner, William, of Ashwell, husbandman 0
4217256 2101532 2101532 defendant Barlye Elizabeth widow 699141 699141 Barlye, Elizabeth, of Ashwell, widow 0
4217257 2101532 2101532 defendant Trigge John husbandman 699141 699141 Trigge, John, of Ashwell, husbandman 1
4220262 2102591 2102591 defendant Tunnacke or Tunnicke Thomas yeoman 699141 699141 Tunnacke or Tunnicke, Thomas, of Ashwell, yeoman 0
4220265 2102592 2102592 defendant Tunnacke or Tunnicke Thomas yeoman 699141 699141 Tunnacke or Tunnicke, Thomas, of Ashwell, yeoman 0
4220873 2102794 2102794 defendant Bygrave Robert   699141 699141 Bygrave, Robert, of Ashwell, freemason 1
4220874 2102794 2102794 defendant Nicoll John, junior yeoman 699141 699141 Nicoll, John, junior, of Ashwell, yeoman 2
4220935 2102817 2102817 defendant Bygrave Robert   699141 699141 Bygrave, Robert, of Ashwell, freemason 1
4220936 2102817 2102817 defendant Nicoll John, junior yeoman 699141 699141 Nicoll, John, junior, of Ashwell, yeoman 2
4234942 2107771 2107771 defendant Barlye Elizabeth widow 699141 699141 Barlye, Elizabeth, of Ashwell, widow 0
4234943 2107771 2107771 defendant Trigge John husbandman 699141 699141 Trigge, John, of Ashwell, husbandman 1
4274619 2121065 2121065 defendant Frogge John yeoman 699141 699141 Frogge, John, of Ashwell, yeoman 1
4276921 2121858 2121858 defendant Tunnick Thomas husbandman 699141 699141 Tunnick, Thomas, of Ashwell, husbandman 0
4276923 2121859 2121859 defendant Tunnick Thomas husbandman 699141 699141 Tunnick, Thomas, of Ashwell, husbandman 0
4277232 2121968 2121968 defendant Rayner William husbandman 699141 699141 Rayner, William, of Ashwell, husbandman 2
4277233 2121968 2121968 defendant Nicoll John husbandman 699141 699141 Nicoll, John, of Ashwell, husbandman 3
4278897 2122554 2122554 defendant Sewster John gent 699141 699141 Sewster, John, of Ashwell, gent 0
4279349 2122703 2122703 defendant Tunnick Thomas husbandman 699141 699141 Tunnick, Thomas, of Ashwell, husbandman 0
4279352 2122703 2122703 defendant Barley John yeoman 699141 699141 Barley, John, of Ashwell, yeoman 3
4279802 2122854 2122854 defendant Bygrave Robert   699141 699141 Bygrave, Robert, of Ashwell, freemason 0
4279804 2122854 2122854 defendant Rooke Thomas husbandman 699141 699141 Rooke, Thomas, of Ashwell, husbandman 2
4313466 2134818 2134818 defendant Nicholl John yeoman 699141 699141 Nicholl, John, of Ashwell, yeoman 0
4313467 2134818 2134818 defendant Bygrave Robert   699141 699141 Bygrave, Robert, of Ashwell, freemason 1
4343054 2144841 2144841 defendant Barly John, junior singleman 699141 699141 Barly, John, junior, of Ashwell, singleman 1
4343055 2144841 2144841 defendant Furley John   699141 699141 Furley, John, of Ashwell, malt carrier 2
4370125 2154375 2154375 defendant Godsalve William gent 699141 699141 Godsalve, William, of Ashwell, gent 2
4382345 2158795 2158795 defendant Bayly John, senior yeoman 699141 699141 Bayly, John, senior, of Ashwell, yeoman 0
4382346 2158795 2158795 defendant Bayly John, junior yeoman 699141 699141 Bayly, John, junior, of Ashwell, yeoman 1
4409765 2167869 2167869 defendant Reynerd William husbandman 699141 699141 Reynerd, William, of Ashwell, husbandman 0
4489989 2197579 2197579 defendant Edmund John clerk 699141 699141 Edmund, John, of Ashwell, clerk 1
4956994 2344049 2344049 defendant Smyth John smith 699141 699141 Smyth, John, of Ashwell, smith 2
4956995 2344049 2344049 defendant Everdon William husbandman 699141 699141 Everdon, William, of Ashwell, husbandman 3
5409848 2477911 2477911 defendant Grey John husbandman 699141 699141 Grey, John, of Ashwell, husbandman 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);