names

71 rows where place_id = 604452

✎ 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
3654359 1911624 1911624 defendant Meratt Robert   604452 604452 Meratt, Robert, of Devizes, Wilts, cloth maker 1
3658032 1912767 1912767 plaintiff Drewe John clothman 604452 604452 Drewe, John, of Devizes, Wilts, clothman 0
3931787 2000935 2000935 defendant Smythe John clothier 604452 604452 Smythe, John, of Devizes, Wilts, clothier 0
3936643 2002582 2002582 defendant Haslonde Robert chapman 604452 604452 Haslonde, Robert, of Devizes, Wilts, chapman 0
3936647 2002583 2002583 defendant Haslonde Robert chapman 604452 604452 Haslonde, Robert, of Devizes, Wilts, chapman 0
3941840 2004283 2004283 defendant Farr Roger yeoman 604452 604452 (Farr, Roger, of Devizes, Wilts, yeoman 2
4032929 2036422 2036422 defendant Barrett William vintner or wine drawer 604452 604452 Barrett, William, of Devizes, Wilts, vintner or wine drawer 2
4192367 2092888 2092888 defendant Chyffynche Nicholas glover 604452 604452 Chyffynche, Nicholas, of Devizes, Wilts, glover 0
4209919 2099030 2099030 defendant Barrett William vintner 604452 604452 Barrett, William, of Devizes, Wilts, vintner 0
4211768 2099672 2099672 defendant Burde John chapman 604452 604452 Burde, John, of Devizes, Wilts, chapman 2
4262383 2117088 2117088 defendant Willis George chapman 604452 604452 Willis, George, of Devizes, Wilts, chapman 0
4273143 2120578 2120578 defendant Wallis George chapman 604452 604452 Wallis, George, of Devizes, Wilts, chapman 0
4332877 2141279 2141279 defendant Sherer Richard chapman 604452 604452 Sherer, Richard, of Devizes, Wilts, chapman 0
4336171 2142382 2142382 defendant Cordrye Robert chapman 604452 604452 Cordrye, Robert, of Devizes, Wilts, chapman 2
4341570 2144326 2144326 defendant Hadnett John yeoman 604452 604452 Hadnett, John, of Devizes, Wilts, yeoman 2
4341648 2144357 2144357 defendant Horte Anthony yeoman 604452 604452 Horte, Anthony, of Devizes, Wilts, yeoman 0
4348020 2146560 2146560 defendant Cannon John chapman 604452 604452 Cannon, John, of Devizes, Wilts, chapman 1
4371904 2155012 2155012 defendant Cannon John chapman 604452 604452 Cannon, John, of Devizes, Wilts, chapman 1
4506177 2202442 2202442 defendant Gylmyn John tanner 604452 604452 Gylmyn, John, of Devizes, Wilts, tanner 0
4723114 2272540 2272540 defendant Archer Henry yeoman 604452 604452 Archer, Henry, of Devizes, Wilts, yeoman 0
4728381 2274113 2274113 defendant Palfrey John skinner 604452 604452 Palfrey, John, of Devizes, Wilts, skinner 1
4760239 2283555 2283555 defendant Malter John mercer 604452 604452 Malter, John, of Devizes, Wilts, mercer 1
4806675 2298298 2298298 defendant Hichecok John carpenter 604452 604452 Hichecok, John, of Devizes, Wilts, carpenter 0
4807448 2298522 2298522 defendant Crall William weaver 604452 604452 Crall, William, of Devizes, Wilts, weaver 3
4807453 2298523 2298523 defendant Crall William weaver 604452 604452 Crall, William, of Devizes, Wilts, weaver 3
4834374 2306758 2306758 plaintiff Coventre John   604452 604452 Coventre, John, of Devizes, Wilts 0
4834377 2306759 2306759 plaintiff Coventre John   604452 604452 Coventre, John, of Devizes, Wilts 0
4834401 2306766 2306766 plaintiff Coventry John   604452 604452 Coventry, John, of Devizes, Wilts 0
4843446 2309467 2309467 defendant Skynner William skinner 604452 604452 Skynner, William, of Devizes, Wilts, skinner 0
4853739 2312583 2312583 defendant Covyntre William   604452 604452 Covyntre, William, of Devizes, Wilts, burgess 0
4853744 2312584 2312584 defendant Covyntre William   604452 604452 Covyntre, William, of Devizes, Wilts, burgess 0
4924378 2334063 2334063 defendant Englysshe John hosier 604452 604452 Englysshe, John, of Devizes, Wilts, hosier 0
4930042 2335803 2335803 defendant Draper Hugh hosier 604452 604452 Draper, Hugh, of Devizes, Wilts, hosier 0
4930045 2335804 2335804 defendant Draper Hugh hosier 604452 604452 Draper, Hugh, of Devizes, Wilts, hosier 0
5003451 2357905 2357905 defendant Estmond John carrier 604452 604452 Estmond, John, of Devizes, Wilts, carrier 1
5042736 2369434 2369434 defendant Henlowe William clothman 604452 604452 Henlowe, William, of Devizes, Wilts, clothman 0
5048851 2371289 2371289 defendant Hendelove William weaver 604452 604452 Hendelove, William, of Devizes, Wilts, weaver 0
5194171 2414028 2414028 defendant Smalbroke Thomas chapman 604452 604452 Smalbroke, Thomas, of Devizes, Wilts, chapman 3
5208594 2418242 2418242 defendant Smalbroke Thomas chapman 604452 604452 Smalbroke, Thomas, of Devizes, Wilts, chapman 3
5208601 2418243 2418243 defendant Smalbroke Thomas chapman 604452 604452 Smalbroke, Thomas, of Devizes, Wilts, chapman 3
5371263 2466596 2466596 defendant Strong John clothman 604452 604452 Strong, John, of Devizes, Wilts, clothman 1
5371266 2466597 2466597 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5371269 2466598 2466598 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5375326 2467872 2467872 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5382682 2470107 2470107 defendant Hochden Hugh clothmaker 604452 604452 Hochden, Hugh, of Devizes, Wilts, clothmaker 2
5383868 2470472 2470472 defendant Gilbard William   604452 604452 Gilbard, William, of Devizes, Wilts 0
5389069 2471923 2471923 defendant Noreys Thomas gent 604452 604452 Noreys, Thomas, of Devizes, Wilts, gent 0
5395655 2473840 2473840 defendant Gilbardy William weaver 604452 604452 Gilbardy, William, of Devizes, Wilts, weaver 0
5401763 2475565 2475565 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5401774 2475569 2475569 defendant Noreys Thomas gent 604452 604452 Noreys, Thomas, of Devizes, Wilts, gent 0
5401777 2475570 2475570 defendant Norreys Thomas gent 604452 604452 Norreys, Thomas, of Devizes, Wilts, gent 0
5402096 2475664 2475664 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5406570 2476948 2476948 plaintiff Stronge John clothier 604452 604452 Stronge, John, of Devizes, Wilts, clothier 0
5408888 2477618 2477618 defendant Bak_ William gent 604452 604452 Bak_, William, of Devizes, Wilts, gent 0
5414571 2479295 2479295 defendant Baker William   604452 604452 Baker, William, of Devizes, Wilts 0
5421938 2481495 2481495 defendant Baker William   604452 604452 Baker, William, of Devizes, Wilts 0
5423275 2481924 2481924 defendant Slye Thomas hosteller 604452 604452 Slye, Thomas, of Devizes, Wilts, hosteller 1
5430376 2484020 2484020 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5430569 2484077 2484077 defendant Baker William baker 604452 604452 Baker, William, of Devizes, Wilts, baker 0
5430571 2484078 2484078 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5438131 2486339 2486339 plaintiff Stronge John clothier 604452 604452 Stronge, John, of Devizes, Wilts, clothier 0
5438133 2486340 2486340 plaintiff Stronge John clothier 604452 604452 Stronge, John, of Devizes, Wilts, clothier 0
5438971 2486576 2486576 plaintiff Trymmell William clothman 604452 604452 Trymmell, William, of Devizes, Wilts, clothman 0
5438978 2486578 2486578 plaintiff Trymnell William clothman 604452 604452 Trymnell, William, of Devizes, Wilts, clothman 0
5447139 2489035 2489035 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5452868 2490737 2490737 plaintiff Trymnell William clothman 604452 604452 Trymnell, William, of Devizes, Wilts, clothman 0
5464811 2494391 2494391 plaintiff Trymnell William clothman 604452 604452 Trymnell, William, of Devizes, Wilts, clothman 0
5471423 2496396 2496396 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5476326 2497923 2497923 plaintiff Trymnell William clothman 604452 604452 Trymnell, William, of Devizes, Wilts, clothman 0
5609306 2537813 2537813 defendant Baker William gent 604452 604452 Baker, William, of Devizes, Wilts, gent 0
5609494 2537865 2537865 defendant Hocheon Hugh clothmaker 604452 604452 Hocheon, Hugh, of Devizes, Wilts, clothmaker 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);