names

71 rows where place_id = 598464

✎ 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
3632617 1905020 1905020 defendant Corse Thomas husbandman 598464 598464 Corse, Thomas, of Erdyngton, husbandman 0
3632621 1905020 1905020 defendant Verne John laborer 598464 598464 Verne, John, of Erdyngton, laborer 4
3632622 1905020 1905020 defendant Corse Robert yeoman 598464 598464 Corse, Robert, of Erdyngton, yeoman 5
3913584 1994882 1994882 defendant Roper John   598464 598464 Roper, John, of Erdyngton 0
3942211 2004412 2004412 defendant Hopkyns William husbandman 598464 598464 Hopkyns, William, of Erdyngton, husbandman 0
3952169 2007831 2007831 defendant Eddyall John husbandman 598464 598464 Eddyall, John, of Erdyngton, husbandman 0
3986887 2020051 2020051 defendant Chamberleyn William gent 598464 598464 Chamberleyn, William, of Erdyngton, gent 3
4003041 2025851 2025851 plaintiff Holden Simon yeoman 598464 598464 Holden, Simon, of Erdyngton, yeoman 0
4028526 2034855 2034855 plaintiff Corbett Simon yeoman 598464 598464 Corbett, Simon, of Erdyngton, yeoman 0
4028529 2034856 2034856 plaintiff Corbett Simon yeoman 598464 598464 Corbett, Simon, of Erdyngton, yeoman 0
4160703 2081819 2081819 defendant Bloxsiche Richard yeoman 598464 598464 Bloxsiche, Richard, of Erdyngton, yeoman 0
4167981 2084285 2084285 defendant Westwood alias Oldbury William yeoman 598464 598464 Westwood alias Oldbury, William, of Erdyngton, yeoman 2
4416877 2170149 2170149 plaintiff Phelippes Richard   598464 598464 Phelippes, Richard, of Erdyngton 0
4416878 2170149 2170149 defendant Clerk William le   598464 598464 Clerk, William le, of Erdyngton 0
4424182 2172413 2172413 defendant Petrich Nicholas   598464 598464 Petrich, Nicholas, of Erdyngton 3
4426760 2173185 2173185 plaintiff Phelippes Richard   598464 598464 Phelippes, Richard, of Erdyngton 0
4426761 2173185 2173185 defendant Clerk William le   598464 598464 Clerk, William le, of Erdyngton 0
4427557 2173452 2173452 plaintiff Say William le   598464 598464 Say, William le, of Erdyngton 0
4427558 2173452 2173452 defendant Pype Richard de   598464 598464 Pype, Richard de, of Erdyngton 0
4578004 2224626 2224626 defendant Hubald Roger   598464 598464 Hubald, Roger, of Erdyngton 0
4656823 2248030 2248030 defendant Weston Richard yeoman 598464 598464 Weston, Richard, of Erdyngton, yeoman 0
4671877 2256849 2256849 defendant Weston Richard yeoman 598464 598464 Weston, Richard, of Erdyngton, yeoman 0
4671880 2256850 2256850 defendant Weston Richard yeoman 598464 598464 Weston, Richard, of Erdyngton, yeoman 0
4727809 2273941 2273941 defendant Holden Margaret   598464 598464 Holden, Margaret, of Erdyngton, widow, formerly wife of Richard 1
4769017 2286286 2286286 plaintiff Taylour Thomas   598464 598464 Taylour, Thomas, of Erdyngton 1
4769018 2286286 2286286 defendant Deyster William husbandman 598464 598464 Deyster, William, of Erdyngton, husbandman 0
4770627 2286796 2286796 defendant Roger Thomas husbandman 598464 598464 Roger, Thomas, of Erdyngton, husbandman 0
4770859 2286866 2286866 plaintiff Roggers John   598464 598464 Roggers, John, of Erdyngton 0
4772782 2287455 2287455 defendant Gybbes John husbandman 598464 598464 Gybbes, John, of Erdyngton, husbandman 0
4772783 2287455 2287455 defendant atte Lane Richard husbandman 598464 598464 atte Lane, Richard, of Erdyngton, husbandman 1
4793574 2294099 2294099 plaintiff Taillour Thomas   598464 598464 Taillour, Thomas, of Erdyngton 1
4793575 2294099 2294099 defendant Deister William husbandman 598464 598464 Deister, William, of Erdyngton, husbandman 0
4810476 2299422 2299422 defendant Bodyn John husbandman 598464 598464 Bodyn, John, of Erdyngton, husbandman 1
4810478 2299422 2299422 defendant Kykkes William husbandman 598464 598464 Kykkes, William, of Erdyngton, husbandman 3
4813708 2300398 2300398 defendant Deye William butcher 598464 598464 Deye, William, of Erdyngton, butcher 0
4864196 2315778 2315778 defendant Laury Ralph chaplain 598464 598464 Laury, Ralph, of Erdyngton, chaplain 1
4864198 2315778 2315778 defendant Bryd John butcher 598464 598464 Bryd, John, of Erdyngton, butcher 3
4959308 2344750 2344750 defendant Erdyngton Thomas   598464 598464 Erdyngton, Thomas, of Erdyngton, knight 1
5059098 2374286 2374286 defendant Ascott John husbandman 598464 598464 Ascott, John, of Erdyngton, husbandman 0
5067592 2376804 2376804 defendant Tracy John husbandman 598464 598464 Tracy, John, of Erdyngton, husbandman 0
5067593 2376804 2376804 defendant Jurden John smith 598464 598464 Jurden, John, of Erdyngton, smith 1
5081256 2380902 2380902 defendant Crofte William turner 598464 598464 Crofte, William, of Erdyngton, turner 0
5108064 2388798 2388798 defendant Holden John   598464 598464 Holden, John, of Erdyngton, servant 0
5108065 2388798 2388798 defendant Newehay William   598464 598464 Newehay, William, of Erdyngton, servant 1
5117034 2391407 2391407 defendant Barne William yeoman 598464 598464 Barne, William, of Erdyngton, yeoman 0
5117035 2391407 2391407 defendant Barne Edward yeoman 598464 598464 Barne, Edward, of Erdyngton, yeoman 1
5117227 2391470 2391470 plaintiff Peyto John   598464 598464 Peyto, John, of Erdyngton 0
5130393 2395378 2395378 defendant Tracy John husbandman 598464 598464 Tracy, John, of Erdyngton, husbandman 0
5139624 2398066 2398066 defendant Holden (illegible) yeoman 598464 598464 Holden, ----, of Erdyngton, yeoman 1
5139630 2398067 2398067 defendant Holden Thomas yeoman 598464 598464 Holden, Thomas, of Erdyngton, yeoman 1
5142901 2399053 2399053 defendant Wyse Thomas husbandman 598464 598464 Wyse, Thomas, of Erdyngton, husbandman 0
5149766 2401067 2401067 defendant Tracy John husbandman 598464 598464 Tracy, John, of Erdyngton, husbandman 0
5160275 2404101 2404101 defendant Holden Thomas yeoman 598464 598464 Holden, Thomas, of Erdyngton, yeoman 0
5164282 2405291 2405291 defendant Wyse Thomas husbandman 598464 598464 Wyse, Thomas, of Erdyngton, husbandman 0
5177573 2409135 2409135 defendant Wyse Thomas husbandman 598464 598464 Wyse, Thomas, of Erdyngton, husbandman 0
5209407 2418486 2418486 defendant Holdon Thomas jun gent 598464 598464 Holdon Thomas, jun, of Erdyngton, gent 3
5211623 2419137 2419137 defendant Wyse Thomas husbandman 598464 598464 Wyse, Thomas, of Erdyngton, husbandman 0
5217163 2420755 2420755 defendant Holden Thomas   598464 598464 Holden, Thomas, of Erdyngton, yeoman, son of Holden, Thomas 0
5260615 2433452 2433452 defendant Newenham Richard husbandman 598464 598464 Newenham, Richard, of Erdyngton, husbandman 6
5276983 2438347 2438347 defendant Gower Thomas, junior husbandman 598464 598464 Gower, Thomas, junior, of Erdyngton, husbandman 1
5349966 2460120 2460120 defendant Baron Edward yeoman 598464 598464 Baron, Edward, of Erdyngton, yeoman 0
5359018 2462871 2462871 defendant Holden Thomas gent 598464 598464 Holden, Thomas, of Erdyngton, gent 0
5378828 2468963 2468963 defendant Holden Thomas gent 598464 598464 Holden, Thomas, of Erdyngton, gent 0
5378830 2468964 2468964 defendant Holden Thomas gent 598464 598464 Holden, Thomas, of Erdyngton, gent 0
5389471 2472038 2472038 defendant Lane William smith 598464 598464 Lane, William, of Erdyngton, smith 0
5540027 2517003 2517003 defendant Mayoo William   598464 598464 Mayoo, William, of Erdyngton, wheelwright 1
5540030 2517004 2517004 defendant Mayoo William   598464 598464 Mayoo, William, of Erdyngton, wheelwright 1
5544260 2518308 2518308 defendant Massy Robert gent 598464 598464 Massy, Robert, of Erdyngton, gent 0
5635987 2555209 2555209 defendant Holdon William husbandman 598464 598464 Holdon, William, of Erdyngton, husbandman 0
5635988 2555209 2555209 defendant James Henry   598464 598464 James, Henry, of Erdyngton 1
5635989 2555209 2555209 defendant Deye William laborer 598464 598464 Deye, William, of Erdyngton, laborer 2

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