names

56 rows where place_id = 588123

✎ 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
3593450 1865585 1865585 defendant Coo alias Spycer Robert spicer 588123 588123 Coo alias Spycer, Robert, of Wantage, Berks, spicer 1
3604131 1868958 1868958 defendant Clerk William husbandman 588123 588123 Clerk, William, of Wantage, Berks, husbandman 0
3604321 1869015 1869015 defendant Collys Robert clothier 588123 588123 Collys, Robert, of Wantage, Berks, clothier 0
3619712 1873736 1873736 defendant Norreys Thomas woolman 588123 588123 Norreys, Thomas, of Wantage, Berks, woolman 0
3619716 1873737 1873737 defendant Norreys Thomas woolman 588123 588123 Norreys, Thomas, of Wantage, Berks, woolman 0
3657267 1912532 1912532 defendant Grete Barnard yeoman 588123 588123 Grete, Barnard, of Wantage, Berks, yeoman 3
3661773 1913963 1913963 defendant Endall Denise smith 588123 588123 Endall, Denise, of Wantage, Berks, smith 7
3671683 1917130 1917130 defendant Hall Robert chapman 588123 588123 Hall, Robert, of Wantage, berks, chapman 0
3718838 1932172 1932172 defendant Leche Thomas butcher 588123 588123 Leche, Thomas, of Wantage, berks, butcher 0
3790547 1954867 1954867 defendant Tyddar Elias clothier 588123 588123 Tyddar, Elias, of Wantage, Berks, clothier 3
3832638 1968135 1968135 defendant Scotter Oliver yeoman 588123 588123 Scotter, Oliver, of Wantage, Berks, yeoman 0
3853908 1974859 1974859 defendant Yate Edmund yeoman 588123 588123 Yate, Edmund, of Wantage, Berks, yeoman 0
3900146 1990273 1990273 defendant Yate Edmund mercer 588123 588123 Yate, Edmund, of Wantage, Berks, mercer 1
3902886 1991197 1991197 defendant Koxeter John mercer 588123 588123 Koxeter, John, of Wantage, Berks, mercer 2
3986727 2019993 2019993 plaintiff Wickes Thomas draper 588123 588123 Wickes, Thomas, of Wantage, Berks, draper 0
3988100 2020488 2020488 defendant Blage Richard chapman 588123 588123 Blage, Richard, of Wantage, Berks, chapman 1
4027539 2034495 2034495 defendant Geste William chapman 588123 588123 Geste, William, of Wantage, Berks, chapman 0
4033236 2036542 2036542 defendant Gest William chapman 588123 588123 Gest, William, of Wantage, Berks, chapman 0
4087313 2055753 2055753 defendant White Eustace chapman 588123 588123 White, Eustace, of Wantage, Berks, chapman 0
4106222 2062518 2062518 defendant White Eustace chapman 588123 588123 White, Eustace, of Wantage, Berks, chapman 0
4120910 2067767 2067767 defendant Horsley Martin chapman 588123 588123 Horsley, Martin, of Wantage, Berks, chapman 0
4121376 2067939 2067939 defendant Wythyns John clerk 588123 588123 Wythyns, John, of Wantage, Berks, clerk 3
4123348 2068652 2068652 defendant Webbe Bartholomew yeoman 588123 588123 Webbe, Bartholomew, of Wantage, Berks, yeoman 0
4124622 2069103 2069103 defendant Clarke Richard yeoman 588123 588123 Clarke, Richard, of Wantage, Berks, yeoman 0
4202072 2096268 2096268 defendant Garrett Andrew gent 588123 588123 Garrett, Andrew, of Wantage, Berks, gent 0
4231377 2106476 2106476 defendant Wallington William chapman 588123 588123 Wallington, William, of Wantage, Berks, chapman 0
4263199 2117357 2117357 defendant Wallington William chapman 588123 588123 Wallington, William, of Wantage, Berks, chapman 0
4291503 2127034 2127034 defendant Stade Henry yeoman 588123 588123 Stade, Henry, of Wantage, Berks, yeoman 1
4641046 2243472 2243472 defendant Lane John   588123 588123 Lane, John, of Wantage, Berks 0
4697620 2264744 2264744 defendant Hardyng William husbandman 588123 588123 Hardyng, William, of Wantage, Berks, husbandman 0
4697622 2264745 2264745 defendant Hardyng William husbandman 588123 588123 Hardyng, William, of Wantage, Berks, husbandman 0
4703810 2266569 2266569 defendant Wydeford Thomas gent 588123 588123 Wydeford, Thomas, of Wantage, Berks, gent 1
4703815 2266570 2266570 defendant Wydeford Thomas gent 588123 588123 Wydeford, Thomas, of Wantage, Berks, gent 1
4828642 2304997 2304997 defendant Lee William clerk 588123 588123 Lee, William, of Wantage, Berks, clerk 0
4844440 2309773 2309773 defendant Scorsour Roger husbandman 588123 588123 Scorsour, Roger, of Wantage, Berks, husbandman 1
4846414 2310385 2310385 defendant Holt John clerk 588123 588123 Holt, John, of Wantage, Berks, clerk 1
5001499 2357329 2357329 defendant Lerebeke Thomas   588123 588123 Lerebeke, Thomas, of Wantage, Berks, vicar 0
5044740 2370061 2370061 defendant atte Ley William chapman 588123 588123 atte Ley, William, of Wantage, Berks, chapman 3
5143650 2399277 2399277 defendant Aldeworth John tanner 588123 588123 Aldeworth, John, of Wantage, Berks, tanner 2
5143654 2399278 2399278 defendant Aldeworth John tanner 588123 588123 Aldeworth, John, of Wantage, Berks, tanner 2
5162201 2404678 2404678 defendant Colyns John gent 588123 588123 Colyns, John, of Wantage, Berks, gent 2
5164798 2405436 2405436 defendant Aldeworth John tanner 588123 588123 Aldeworth, John, of Wantage, Berks, tanner 2
5176369 2408777 2408777 defendant Colyns John gent 588123 588123 Colyns, John, of Wantage, Berks, gent 2
5178577 2409448 2409448 defendant Bray Robert chapman 588123 588123 Bray, Robert, of Wantage, Berks, chapman 3
5201512 2416200 2416200 defendant Bray Robert chapman 588123 588123 Bray, Robert, of Wantage, Berks, chapman 3
5287031 2441216 2441216 defendant Cookys John husbandman 588123 588123 Cookys, John, of Wantage, Berks, husbandman 1
5298115 2444463 2444463 defendant Kelyngale William chapman 588123 588123 Kelyngale, William, of Wantage, Berks, chapman 0
5342183 2457746 2457746 defendant Lee William mercer 588123 588123 Lee, William, of Wantage, Berks, mercer 3
5347860 2459477 2459477 defendant Fynch Richard chapman 588123 588123 Fynch, Richard, of Wantage, Berks, chapman 2
5480537 2499150 2499150 defendant Colles Robert clothier 588123 588123 Colles, Robert, of Wantage, Berks, clothier 0
5552006 2520627 2520627 defendant Preker Thomas tanner 588123 588123 (Preker, Thomas, of Wantage, Berks, tanner 1
5552050 2520640 2520640 defendant Preker Thomas tanner 588123 588123 (Preker, Thomas, of Wantage, Berks, tanner 1
5571851 2526308 2526308 defendant Tate Robert (legal representative) 588123 588123 Tate, Robert, of Wantage, Berks, gent, administrator of 1
5580683 2529040 2529040 defendant Leche Thomas butcher 588123 588123 Leche, Thomas, of Wantage, Berks, butcher 0
5585557 2530552 2530552 defendant Frankeleyn William tanner 588123 588123 (Frankeleyn, William, of Wantage, Berks, tanner 1
5600814 2535142 2535142 defendant Grete Bernard gent 588123 588123 Grete, Bernard, of Wantage, Berks, gent 0

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