names

59 rows where place_id = 593964

✎ 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
3614001 1872038 1872038 defendant Jakeson George yeoman 593964 593964 Jakeson, George, of Hardewyk, yeoman 0
3658046 1912770 1912770 defendant Broun Archibald husbandman 593964 593964 Broun, Archibald, of Hardewyk, husbandman 0
3672951 1917551 1917551 defendant Broun Archebald husbandman 593964 593964 Broun, Archebald, of Hardewyk, husbandman 0
3703735 1927448 1927448 defendant Broun Archebold yeoman 593964 593964 Broun, Archebold, of Hardewyk, yeoman 0
3729064 1935340 1935340 defendant Bery Edmund husbandman 593964 593964 Bery, Edmund, of Hardewyk, husbandman 1
3735603 1937369 1937369 defendant Smyth Thomas yeoman 593964 593964 Smyth, Thomas, of Hardewyk, yeoman 0
3750609 1942110 1942110 defendant Cauntwell Thomas clerk 593964 593964 Cauntwell, Thomas, of Hardewyk, clerk 0
4476382 2193279 2193279 plaintiff Frost John   593964 593964 Frost, John, of Hardewyk 0
4485703 2196233 2196233 defendant Warde Roger   593964 593964 Warde, Roger, of Hardewyk 7
4485711 2196234 2196234 defendant Warde Roger   593964 593964 Warde, Roger, of Hardewyk 7
4504017 2201810 2201810 defendant Otir John   593964 593964 Otir, John, of Hardewyk 1
4521806 2207155 2207155 defendant Wortley Thomas de   593964 593964 Wortley, Thomas de, of Hardewyk 0
4549124 2215662 2215662 defendant Saltere John   593964 593964 Saltere, John, of Hardewyk 0
4698362 2264966 2264966 defendant Derham John   593964 593964 Derham, John, of Hardewyk, parson of the church 2
4710911 2268768 2268768 defendant Mansthorp Richard husbandman 593964 593964 Mansthorp, Richard, of Hardewyk, husbandman 4
4723605 2272686 2272686 defendant Wortley John husbandman 593964 593964 Wortley, John, of Hardewyk, husbandman 0
4823866 2303545 2303545 defendant Hoton William gent 593964 593964 Hoton, William, of Hardewyk, gent 0
4877021 2319786 2319786 defendant Clerke John husbandman 593964 593964 Clerke, John, of Hardewyk, husbandman 1
4877022 2319786 2319786 defendant Howytson Thomas husbandman 593964 593964 Howytson, Thomas, of Hardewyk, husbandman 2
4897761 2325967 2325967 defendant Babyngle Robert laborer 593964 593964 Babyngle, Robert, of Hardewyk, laborer 0
4916106 2331537 2331537 defendant Carter John husbandman 593964 593964 Carter, John, of Hardewyk, husbandman 4
4920549 2332939 2332939 defendant Hamond William clerk 593964 593964 Hamond, William, of Hardewyk, clerk 0
4920550 2332939 2332939 defendant Lont Robert husbandman 593964 593964 Lont, Robert, of Hardewyk, husbandman 1
4920552 2332940 2332940 defendant Hamond William clerk 593964 593964 Hamond, William, of Hardewyk, clerk 0
4920553 2332940 2332940 defendant Love Robert husbandman 593964 593964 Love, Robert, of Hardewyk, husbandman 1
4932216 2336476 2336476 defendant Sutton Thomas husbandman 593964 593964 Sutton, Thomas, of Hardewyk, husbandman 0
4937892 2338231 2338231 defendant Thressher Robert butcher 593964 593964 Thressher, Robert, of Hardewyk, butcher 2
4942663 2339677 2339677 defendant Smyth John husbandman 593964 593964 Smyth, John, of Hardewyk, husbandman 0
4942664 2339677 2339677 defendant Halle John husbandman 593964 593964 Halle, John, of Hardewyk, husbandman 1
4949871 2341941 2341941 defendant Cobald Roger butcher 593964 593964 Cobald, Roger, of Hardewyk, butcher 5
4960941 2345236 2345236 defendant Wellyng Thomas carpenter 593964 593964 Wellyng, Thomas, of Hardewyk, carpenter 0
4965595 2346625 2346625 defendant Sutton John husbandman 593964 593964 Sutton, John, of Hardewyk, husbandman 0
5023432 2363760 2363760 defendant Mason Roger husbandman 593964 593964 Mason, Roger, of Hardewyk, husbandman 0
5026167 2364547 2364547 defendant Halle John, junior husbandman 593964 593964 Halle, John, junior, of Hardewyk, husbandman 2
5095085 2384977 2384977 defendant Pelly John gent 593964 593964 Pelly, John, of Hardewyk, gent 0
5240342 2427389 2427389 defendant Berwyke William husbandman 593964 593964 Berwyke, William, of Hardewyk, husbandman 0
5303025 2445894 2445894 defendant Perpoynt Robert gent 593964 593964 Perpoynt, Robert, of Hardewyk, gent 0
5326715 2453057 2453057 defendant Laman John husbandman 593964 593964 Laman, John, of Hardewyk, husbandman 3
5327691 2453349 2453349 defendant Ives or Ines Richard husbandman 593964 593964 Ives or Ines, Richard, of Hardewyk, husbandman 0
5327693 2453349 2453349 defendant Smyth Robert clerk 593964 593964 Smyth, Robert, of Hardewyk, clerk 2
5354936 2461615 2461615 defendant Ivys Richard husbandman 593964 593964 Ivys, Richard, of Hardewyk, husbandman 7
5354958 2461623 2461623 defendant Paylady Hugh husbandman 593964 593964 Paylady, Hugh, of Hardewyk, husbandman 0
5389632 2472097 2472097 defendant Ombersley Richard yeoman 593964 593964 Ombersley, Richard, of Hardewyk, yeoman 1
5402359 2475748 2475748 defendant Ombersley Richard yeoman 593964 593964 Ombersley, Richard, of Hardewyk, yeoman 1
5483023 2499863 2499863 defendant Bedyll Henry husbandman 593964 593964 Bedyll, Henry, of Hardewyk, husbandman 1
5499090 2504668 2504668 plaintiff Pelly John   593964 593964 Pelly, John, of Hardewyk, administrators of 0
5499094 2504669 2504669 plaintiff Pelly John   593964 593964 Pelly, John, of Hardewyk, administrators of 0
5502445 2505683 2505683 defendant Coweley Thomas yeoman 593964 593964 Coweley, Thomas, of Hardewyk, yeoman 1
5504864 2506441 2506441 defendant Fendyk William husbandman 593964 593964 Fendyk, William, of Hardewyk, husbandman 1
5516882 2510103 2510103 defendant Coweley Thomas yeoman 593964 593964 Coweley, Thomas, of Hardewyk, yeoman 0
5539671 2516888 2516888 defendant Randyll William gent 593964 593964 Randyll, William, of Hardewyk, gent 0
5544441 2518373 2518373 defendant Gamelyng William weaver 593964 593964 Gamelyng, William, of Hardewyk, weaver 0
5544442 2518373 2518373 defendant Wattys Thomas laborer 593964 593964 Wattys, Thomas, of Hardewyk, laborer 1
5544443 2518373 2518373 defendant Gamelyng John weaver 593964 593964 Gamelyng, John, of Hardewyk, weaver 2
5580428 2528963 2528963 defendant Malet Thomas husbandman 593964 593964 Malet, Thomas, of Hardewyk, husbandman 0
5602412 2535647 2535647 defendant Wortley Roger gent 593964 593964 Wortley, Roger, of Hardewyk, gent 0
5605063 2536454 2536454 defendant Fyssher Alice widow 593964 593964 Fyssher, Alice, of Hardewyk, widow 0
5632953 2554313 2554313 defendant Stones John (legal representative) 593964 593964 Stones, John, of Hardewyk, executor of 0
5632954 2554313 2554313 defendant Stones John husbandman 593964 593964 Stones, John, of Hardewyk, husbandman 1

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