names

44 rows where place_id = 585987

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587632 1863776 1863776 defendant Burgeys John wheeler 585987 585987 Burgeys, John, of Buksted, wheeler 0
3587636 1863777 1863777 defendant Burgeys John wheeler 585987 585987 Burgeys, John, of Buksted, wheeler 0
3598049 1867014 1867014 defendant atte Welle Thomas yeoman 585987 585987 atte Welle, Thomas, of Buksted, yeoman 1
3598055 1867015 1867015 defendant atte Welle Thomas yeoman 585987 585987 atte Welle, Thomas, of Buksted, yeoman 0
3601231 1868047 1868047 defendant Burges John wheeler 585987 585987 Burges, John, of Buksted, wheeler 1
3654330 1911614 1911614 defendant Roote William clerk 585987 585987 Roote, William, of Buksted, clerk 0
3658524 1912920 1912920 plaintiff Fechett William   585987 585987 Fechett, William, of Buksted 0
3662757 1914274 1914274 defendant Wellis John gent 585987 585987 Wellis, John, of Buksted, gent 0
3678569 1919354 1919354 defendant Wellys John gent 585987 585987 Wellys, John, of Buksted, gent 0
3698596 1925778 1925778 defendant Sleche John yeoman 585987 585987 Sleche, John, of Buksted, yeoman 0
3698597 1925778 1925778 defendant Smythe William carpenter 585987 585987 Smythe, William, of Buksted, carpenter 1
3698601 1925778 1925778 defendant Marten John laborer 585987 585987 Marten, John, of Buksted, laborer 5
3698602 1925778 1925778 defendant West John bricklayer 585987 585987 West, John, of Buksted, bricklayer 6
3712180 1930127 1930127 defendant Sleche John yeoman 585987 585987 Sleche, John, of Buksted, yeoman 0
3712181 1930127 1930127 defendant Smythe William carpenter 585987 585987 Smythe, William, of Buksted, carpenter 1
3712185 1930127 1930127 defendant Marten John laborer 585987 585987 Marten, John, of Buksted, laborer 5
3712186 1930127 1930127 defendant West John bricklayer 585987 585987 West, John, of Buksted, bricklayer 6
3792704 1955571 1955571 defendant Wykys William miller 585987 585987 Wykys, William, of Buksted, miller 0
3821947 1964758 1964758 defendant Atwell John yeoman 585987 585987 Atwell, John, of Buksted, yeoman 0
3826672 1966189 1966189 defendant Yong Richard   585987 585987 Yong, Richard, of Buksted, "rypyer" 0
3828707 1966855 1966855 defendant Smyth Richard husbandman 585987 585987 Smyth, Richard, of Buksted, husbandman 0
4738398 2277106 2277106 plaintiff Weston William (legal representative) 585987 585987 Weston, William, of Buksted, executors of 0
4801638 2296697 2296697 defendant Telyon Richard laborer 585987 585987 Telyon, Richard, of Buksted, laborer 0
4818880 2301989 2301989 defendant Drynkewater Thomas turner & son of Robert Drynkewater 585987 585987 Drynkewater, Thomas, of Buksted, turner & son of Robert Drynkewater 0
4944004 2340090 2340090 defendant Gylderegge Thomas baker 585987 585987 Gylderegge, Thomas, of Buksted, baker 0
5009073 2359535 2359535 defendant Mascall John yeoman 585987 585987 Mascall, John, of Buksted, yeoman 2
5011221 2360137 2360137 defendant Swayneslond John husbandman 585987 585987 Swayneslond, John, of Buksted, husbandman 0
5346278 2458977 2458977 defendant Burgeys Nicholas husbandman 585987 585987 Burgeys, Nicholas, of Buksted, husbandman 2
5346676 2459114 2459114 defendant Atwelle Thomas yeoman 585987 585987 Atwelle, Thomas, of Buksted, yeoman 0
5383974 2470504 2470504 defendant Maschall Thomas husbandman 585987 585987 Maschall, Thomas, of Buksted, husbandman 0
5383975 2470504 2470504 defendant Ludwell John laborer & singleman 585987 585987 Ludwell, John, of Buksted, laborer & singleman 1
5383985 2470507 2470507 defendant Roule Stephen yeoman 585987 585987 Roule, Stephen, of Buksted, yeoman 3
5453751 2491015 2491015 defendant Hert John husbandman 585987 585987 Hert, John, of Buksted, husbandman 0
5465633 2494631 2494631 defendant Hert John husbandman 585987 585987 Hert, John, of Buksted, husbandman 0
5477140 2498171 2498171 defendant Hert John husbandman 585987 585987 Hert, John, of Buksted, husbandman 0
5495869 2503659 2503659 defendant Puksty Nicholas husbandman 585987 585987 Puksty, Nicholas, of Buksted, husbandman 6
5526387 2512830 2512830 defendant Brokpole John yeoman 585987 585987 Brokpole, John, of Buksted, yeoman 1
5526388 2512830 2512830 defendant Gower Richard husbandman 585987 585987 Gower, Richard, of Buksted, husbandman 2
5526389 2512830 2512830 defendant Harper John husbandman 585987 585987 Harper, John, of Buksted, husbandman 3
5526391 2512830 2512830 defendant Weller John husbandman 585987 585987 Weller, John, of Buksted, husbandman 5
5526392 2512830 2512830 defendant Delve or Delne William husbandman 585987 585987 Delve or Delne, William, of Buksted, husbandman 6
5526393 2512830 2512830 defendant Gobard Robert laborer 585987 585987 Gobard, Robert, of Buksted, laborer 7
5526394 2512830 2512830 defendant Burgeys Henry husbandman 585987 585987 Burgeys, Henry, of Buksted, husbandman 8
5526395 2512830 2512830 defendant Burgeys Andrew husbandman 585987 585987 Burgeys, Andrew, of Buksted, husbandman 9

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