names

53 rows where place_id = 601769

✎ 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
3646933 1909439 1909439 defendant Whythed John yeoman 601769 601769 Whythed, John, of Howell, yeoman 0
3646934 1909439 1909439 defendant Whythed Emma spinster 601769 601769 Whythed, Emma, of Howell, spinster 1
3669830 1916508 1916508 defendant Knolles Richard yeoman 601769 601769 Knolles, Richard, of Howell, yeoman 0
3685343 1921570 1921570 defendant Johnson Robert husbandman 601769 601769 Johnson, Robert, of Howell, husbandman 0
3717902 1931900 1931900 defendant Knolles Richard yeoman 601769 601769 Knolles, Richard, of Howell, yeoman 0
3749969 1941909 1941909 defendant Pell Thomas husbandman 601769 601769 Pell, Thomas, of Howell, husbandman 0
3783931 1952749 1952749 defendant Knolles Richard yeoman 601769 601769 Knolles, Richard, of Howell, yeoman 0
3796153 1956661 1956661 defendant Coke John husbandman 601769 601769 Coke, John, of Howell, husbandman 0
3905045 1991950 1991950 defendant Coke John husbandman 601769 601769 Coke, John, of Howell, husbandman 1
4094862 2058495 2058495 defendant Spayne Robert husbandman 601769 601769 Spayne, Robert, of Howell, husbandman 0
4450322 2185059 2185059 plaintiff Hanworth John (legal representative) 601769 601769 Hanworth, John, of Howell, parson & of Nokton Park, executors of 0
4605067 2232745 2232745 defendant Andrewe Robert chaplain 601769 601769 Andrewe, Robert, of Howell, chaplain 0
4682510 2260157 2260157 defendant Deconson Henry husbandman 601769 601769 Deconson, Henry, of Howell, husbandman 0
4750686 2280689 2280689 defendant Betonson Henry husbandman 601769 601769 Betonson, Henry, of Howell, husbandman 0
4833537 2306496 2306496 defendant Andreweson Robert chaplain 601769 601769 Andreweson, Robert, of Howell, chaplain 0
4833538 2306496 2306496 defendant Collonge Richard husbandman 601769 601769 Collonge, Richard, of Howell, husbandman 1
4833539 2306496 2306496 defendant Bardeyn John husbandman 601769 601769 Bardeyn, John, of Howell, husbandman 2
4833540 2306496 2306496 defendant Oke Henry husbandman 601769 601769 Oke, Henry, of Howell, husbandman 3
4848717 2311066 2311066 defendant Almot William, sen husbandman 601769 601769 Almot, William, sen, of Howell, husbandman 0
4913066 2330584 2330584 defendant Bardeyn John husbandman 601769 601769 Bardeyn, John, of Howell, husbandman 0
4913067 2330584 2330584 defendant Collyng Richard husbandman 601769 601769 Collyng, Richard, of Howell, husbandman 1
4935832 2337596 2337596 defendant Dymmok Philip   601769 601769 Dymmok, Philip, of Howell, knight 0
4937370 2338055 2338055 defendant Taillour Thomas husbandman 601769 601769 Taillour, Thomas, of Howell, husbandman 1
4947169 2341104 2341104 defendant in the Hirne John husbandman 601769 601769 in the Hirne, John, of Howell, husbandman 2
4986828 2352999 2352999 defendant Boteler Richard husbandman 601769 601769 Boteler, Richard, of Howell, husbandman 2
5131625 2395730 2395730 defendant Coke John husbandman 601769 601769 Coke, John, of Howell, husbandman 6
5151107 2401464 2401464 defendant Coke John husbandman 601769 601769 Coke, John, of Howell, husbandman 6
5169383 2406778 2406778 defendant Coke John husbandman 601769 601769 Coke, John, of Howell, husbandman 6
5209363 2418474 2418474 defendant Sybsay William husbandman 601769 601769 Sybsay, William, of Howell, husbandman 1
5209364 2418474 2418474 defendant Raylly William husbandman 601769 601769 Raylly, William, of Howell, husbandman 2
5216702 2420620 2420620 defendant Almot John husbandman 601769 601769 Almot, John, of Howell, husbandman 0
5218362 2421103 2421103 defendant Sybsey William husbandman 601769 601769 Sybsey, William, of Howell, husbandman 2
5218363 2421103 2421103 defendant Watlot William husbandman 601769 601769 Watlot, William, of Howell, husbandman 3
5227394 2423639 2423639 defendant Moll Richard husbandman 601769 601769 Moll, Richard, of Howell, husbandman 2
5234645 2425720 2425720 defendant Rande Robert husbandman 601769 601769 Rande, Robert, of Howell, husbandman 0
5251508 2430577 2430577 defendant Smyth Richard husbandman 601769 601769 Smyth, Richard, of Howell, husbandman 0
5257390 2432433 2432433 defendant Smyth Robert husbandman 601769 601769 Smyth, Robert, of Howell, husbandman 2
5258880 2432894 2432894 defendant Almot John husbandman 601769 601769 Almot, John, of Howell, husbandman 10
5265924 2435095 2435095 defendant Smyth Robert husbandman 601769 601769 Smyth, Robert, of Howell, husbandman 0
5265926 2435096 2435096 defendant Smyth Robert husbandman 601769 601769 Smyth, Robert, of Howell, husbandman 0
5350601 2460303 2460303 defendant Curson Nicholas gent 601769 601769 Curson, Nicholas, of Howell, gent 1
5393089 2473093 2473093 defendant Martyn Thomas   601769 601769 Martyn, Thomas, of Howell 0
5402399 2475758 2475758 defendant Smyth John yeoman 601769 601769 Smyth, John, of Howell, yeoman 4
5415315 2479518 2479518 defendant Smyth John yeoman 601769 601769 Smyth, John, of Howell, yeoman 2
5415330 2479521 2479521 defendant Smyth John yeoman 601769 601769 Smyth, John, of Howell, yeoman 4
5439316 2486688 2486688 defendant Smyth John yeoman 601769 601769 Smyth, John, of Howell, yeoman 3
5447924 2489262 2489262 defendant Smyth John yeoman 601769 601769 Smyth, John, of Howell, yeoman 2
5453125 2490817 2490817 defendant Smyth John   601769 601769 Smyth, John, of Howell 3
5465093 2494464 2494464 defendant Smyth John yeoman 601769 601769 Smyth, John, of Howell, yeoman 3
5476611 2497999 2497999 defendant (illegible) John yeoman 601769 601769 _, John, of Howell, yeoman 2
5501105 2505280 2505280 defendant Skynner Robert husbandman 601769 601769 Skynner, Robert, of Howell, husbandman 0
5556825 2521957 2521957 defendant Rayne John husbandman 601769 601769 Rayne, John, of Howell, husbandman 0
5615883 2548768 2548768 plaintiff Hanworth John   601769 601769 Hanworth, John, of Howell, parson 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);