names

60 rows where place_id = 588710

✎ 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
3595327 1866169 1866169 defendant Scure Richard husbandman 588710 588710 Scure, Richard, of Bromfeld, husbandman 0
3626978 1903295 1903295 defendant Pare Thomas laborer 588710 588710 Pare, Thomas, of Bromfeld, laborer 0
3627707 1903527 1903527 defendant Pare Thomas laborer 588710 588710 Pare, Thomas, of Bromfeld, laborer 0
3642692 1908159 1908159 defendant Lother Leonard chaplain 588710 588710 Lother, Leonard, of Bromfeld, chaplain 2
3642695 1908160 1908160 defendant Henryson John husbandman 588710 588710 Henryson, John, of Bromfeld, husbandman 0
3642708 1908164 1908164 defendant Roper Edward husbandman 588710 588710 Roper, Edward, of Bromfeld, husbandman 2
3642709 1908164 1908164 defendant Hogh Alexander husbandman 588710 588710 Hogh, Alexander, of Bromfeld, husbandman 3
3652592 1911146 1911146 defendant Byglond John husbandman 588710 588710 Byglond, John, of Bromfeld, husbandman 0
3716862 1931562 1931562 defendant Stephyns William husbandman 588710 588710 Stephyns, William, of Bromfeld, husbandman 0
3720445 1932674 1932674 defendant Bedyll Thomas smith 588710 588710 Bedyll, Thomas, of Bromfeld, smith 0
3816457 1963056 1963056 defendant Coldall Richard, senior husbandman 588710 588710 Coldall, Richard, senior, of Bromfeld, husbandman 0
3816458 1963056 1963056 defendant Colldall Micheal husbandman 588710 588710 Colldall, Micheal, of Bromfeld, husbandman 1
3820023 1964143 1964143 defendant Robyns alias Robynson William laborer 588710 588710 Robyns alias Robynson, William, of Bromfeld, laborer 3
3841029 1970764 1970764 defendant Bathehurste Thomas miller 588710 588710 Bathehurste, Thomas, of Bromfeld, miller 4
3894646 1988415 1988415 defendant Straffeld William husbandman 588710 588710 Straffeld, William, of Bromfeld, husbandman 0
3941426 2004140 2004140 defendant Jones alias Asbeche John husbandman 588710 588710 Jones alias Asbeche, John, of Bromfeld, husbandman 0
4040927 2039243 2039243 defendant Dawson John yeoman 588710 588710 Dawson, John, of Bromfeld, yeoman 0
4040928 2039243 2039243 defendant Cuttyng John husbandman 588710 588710 Cuttyng, John, of Bromfeld, husbandman 1
4195394 2093935 2093935 defendant Newbold Henry, senior yeoman 588710 588710 Newbold, Henry, senior, of Bromfeld, yeoman 1
4279617 2122788 2122788 defendant Brett Thomas gent 588710 588710 Brett, Thomas, of Bromfeld, gent 1
4438308 2181275 2181275 defendant Scot Robert   588710 588710 Scot, Robert, of Bromfeld 2
4438314 2181278 2181278 defendant Botyld William   588710 588710 Botyld, William, of Bromfeld 0
4478864 2194060 2194060 plaintiff Holewell John   588710 588710 Holewell, John, of Bromfeld 0
4485252 2196093 2196093 defendant Sparewe Robert   588710 588710 Sparewe, Robert, of Bromfeld 1
4521129 2206948 2206948 defendant Melle John   588710 588710 Melle, John, of Bromfeld 2
4537537 2212013 2212013 defendant Cowyk Thomas   588710 588710 Cowyk, Thomas, of Bromfeld 0
4617003 2236326 2236326 defendant Taillour John   588710 588710 Taillour, John, of Bromfeld 0
4632915 2241167 2241167 plaintiff Waleys John (legal representative) 588710 588710 Waleys, John, of Bromfeld, executor of 0
4646107 2244933 2244933 defendant atte Melle John   588710 588710 atte Melle, John, of Bromfeld 0
4656112 2247791 2247791 defendant Burgh John laborer 588710 588710 Burgh, John, of Bromfeld, laborer 0
4669212 2256075 2256075 defendant Derby John husbandman 588710 588710 Derby, John, of Bromfeld, husbandman 2
4689811 2262373 2262373 defendant Derby John (legal representative) 588710 588710 Derby, John, of Bromfeld, executrix of 4
4705134 2266977 2266977 defendant Bromfeld John laborer 588710 588710 Bromfeld, John, of Bromfeld, laborer 2
4710230 2268552 2268552 defendant Hunte William butcher 588710 588710 Hunte, William, of Bromfeld, butcher 0
4732883 2275462 2275462 plaintiff Pole John   588710 588710 Pole, John, of Bromfeld 0
4744829 2279008 2279008 defendant Poole John gent 588710 588710 Poole, John, of Bromfeld, gent 3
4768990 2286279 2286279 plaintiff Osmondirlawe Thomas gent 588710 588710 Osmondirlawe, Thomas, of Bromfeld, gent 0
4768991 2286279 2286279 plaintiff Osmondirlaw William de gent 588710 588710 Osmondirlaw, William de, of Bromfeld, gent 1
4784887 2291281 2291281 defendant Scot John husbandman 588710 588710 Scot, John, of Bromfeld, husbandman 1
4831754 2305955 2305955 defendant Wateres William yeoman 588710 588710 Wateres, William, of Bromfeld, yeoman 1
4858615 2314067 2314067 defendant Wateres William yeoman 588710 588710 Wateres, William, of Bromfeld, yeoman 1
5004974 2358351 2358351 defendant Pope Thomas carpenter 588710 588710 Pope, Thomas, of Bromfeld, carpenter 0
5004976 2358351 2358351 defendant Herde John thatcher 588710 588710 Herde, John, of Bromfeld, thatcher 2
5079064 2380226 2380226 defendant Scot John, senior husbandman 588710 588710 Scot, John, senior, of Bromfeld, husbandman 1
5140000 2398177 2398177 defendant Skot John, junior husbandman 588710 588710 Skot, John, junior, of Bromfeld, husbandman 0
5197321 2414956 2414956 plaintiff Stotte John   588710 588710 Stotte, John, of Bromfeld 0
5209368 2418476 2418476 plaintiff Scot John, sen   588710 588710 Scot, John, sen, of Bromfeld 0
5252019 2430734 2430734 defendant Browene John laborer or thatcher 588710 588710 Browene, John, of Bromfeld, laborer or thatcher 0
5252020 2430734 2430734 defendant Scot John, senior husbandman 588710 588710 Scot, John, senior, of Bromfeld, husbandman 1
5294715 2443435 2443435 defendant Bole alias Hoggys John clerk 588710 588710 Bole alias Hoggys, John, of Bromfeld, or of Oke Soms, clerk 0
5320648 2451269 2451269 defendant Biglon John butcher 588710 588710 Biglon, John, of Bromfeld, butcher 0
5342290 2457785 2457785 defendant Coke John, senior butcher 588710 588710 Coke, John, senior, of Bromfeld, butcher 0
5353024 2461034 2461034 defendant Coke John butcher 588710 588710 Coke, John, of Bromfeld, butcher 1
5383147 2470252 2470252 defendant Eyne Robert   588710 588710 Eyne, Robert, of Bromfeld 4
5390724 2472408 2472408 defendant Stotte John husbandman 588710 588710 Stotte, John, of Bromfeld, husbandman 3
5479450 2498871 2498871 defendant West Henry laborer 588710 588710 West, Henry, of Bromfeld, laborer 0
5538198 2516432 2516432 defendant Kyng John husbandman 588710 588710 Kyng, John, of bromfeld, husbandman 4
5565492 2524502 2524502 defendant Rolfe John gent 588710 588710 Rolfe, John, of Bromfeld, gent 0
5595154 2533454 2533454 defendant Polley John husbandman 588710 588710 Polley, John, of Bromfeld, husbandman 0
5603686 2536021 2536021 defendant Gynes or Eynes Robert yeoman 588710 588710 Gynes or Eynes, Robert, of Bromfeld, yeoman 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);