names

64 rows where place_id = 691063

✎ 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
4088153 2056054 2056054 defendant Matham Arthur clothier 691063 691063 Matham, Arthur, of Oxfordshire, clothier 1
4420843 2171416 2171416 defendant Langeleye Thomas de   691063 691063 Langeleye, Thomas de, of Oxfordshire 0
4420845 2171416 2171416 defendant Laundels John   691063 691063 Laundels, John, of Oxfordshire, knight 2
4426832 2173210 2173210 defendant Laundels John   691063 691063 Laundels, John, of Oxfordshire 2
4432323 2174889 2174889 plaintiff Combe Nicholas (legal representative) 691063 691063 Combe, Nicholas, of Oxfordshire, clerk, executors of 0
4440673 2181993 2181993 defendant Harcourt Thomas   691063 691063 Harcourt, Thomas, of Oxfordshire, knight 0
4440863 2182057 2182057 defendant Harcourt Thomas   691063 691063 Harcourt, Thomas, of Oxfordshire, knight 0
4440865 2182058 2182058 defendant Harcourt Thomas   691063 691063 Harcourt, Thomas, of Oxfordshire, knight 0
4445391 2183508 2183508 defendant Cheyne William   691063 691063 Cheyne, William, of Oxfordshire 0
4452025 2185619 2185619 plaintiff Hyde John de la   691063 691063 Hyde, John de la, of Oxfordshire 0
4455176 2186620 2186620 defendant Herdewyk John   691063 691063 Herdewyk, John, of Oxfordshire 0
4455180 2186622 2186622 defendant Whitefeld Katherine   691063 691063 Whitefeld, Katherine, of Oxfordshire 0
4457814 2187460 2187460 defendant Dorn Walter   691063 691063 Dorn, Walter, of Oxfordshire 0
4457816 2187461 2187461 defendant Boon Walter   691063 691063 Boon, Walter, of Oxfordshire 0
4481581 2194935 2194935 defendant Holcote John   691063 691063 Holcote, John, of Oxfordshire 5
4484911 2195977 2195977 defendant Lekenore Robert esq 691063 691063 Lekenore, Robert, of Oxfordshire, esq 2
4487755 2196888 2196888 defendant Foster Lambert   691063 691063 Foster, Lambert, of Oxfordshire 1
4489420 2197410 2197410 defendant Janyns Walter   691063 691063 Janyns, Walter, of Oxfordshire 0
4491113 2197910 2197910 plaintiff Westeby Robert   691063 691063 Westeby, Robert, of Oxfordshire 0
4492274 2198262 2198262 defendant Forster Lambert   691063 691063 Forster, Lambert, of Oxfordshire 1
4502784 2201448 2201448 defendant Brenepston Thomas   691063 691063 Brenepston, Thomas, of Oxfordshire 3
4556451 2217959 2217959 defendant Power Robert   691063 691063 Power, Robert, of Oxfordshire 0
4561126 2219436 2219436 plaintiff Paiable Nicholas   691063 691063 Paiable, Nicholas, of Oxfordshire 0
4573556 2223248 2223248 defendant Roundell William   691063 691063 Roundell, William, of Oxfordshire 0
4573963 2223376 2223376 defendant Stokkes Thomas   691063 691063 Stokkes, Thomas, of Oxfordshire 0
4579960 2225219 2225219 defendant Streteley Edmund   691063 691063 Streteley, Edmund, of Oxfordshire 1
4579963 2225220 2225220 defendant Streteley Edmund   691063 691063 Streteley, Edmund, of Oxfordshire 1
4582543 2225984 2225984 defendant Prouf William   691063 691063 Prouf, William, of Oxfordshire 2
4606959 2233285 2233285 defendant Lancastell John   691063 691063 Lancastell, John, of Oxfordshire 1
4612129 2234860 2234860 defendant Longey Hugh   691063 691063 Longey, Hugh, of Oxfordshire 0
4612132 2234861 2234861 defendant Lyngey Hugh   691063 691063 Lyngey, Hugh, of Oxfordshire 0
4612372 2234940 2234940 defendant Leukenore Robert esq 691063 691063 Leukenore, Robert, of Oxfordshire, esq 1
4614031 2235402 2235402 defendant Freynssh Alice   691063 691063 Freynssh, Alice, of Oxfordshire 0
4615160 2235749 2235749 defendant Sper Stephen   691063 691063 Sper, Stephen, of Oxfordshire 0
4620311 2237335 2237335 defendant Benet John   691063 691063 Benet, John, of Oxfordshire 1
4620316 2237336 2237336 defendant Benet John   691063 691063 Benet, John, of Oxfordshire 1
4634939 2241771 2241771 defendant Bokebynder Walter   691063 691063 Bokebynder, Walter, of Oxfordshire 0
4635503 2241964 2241964 defendant Draper Henry   691063 691063 Draper, Henry, of Oxfordshire 2
4636348 2242204 2242204 defendant Wetnale John   691063 691063 Wetnale, John, of Oxfordshire 1
4638048 2242662 2242662 plaintiff Burton Gilbert   691063 691063 Burton, Gilbert, of Oxfordshire 0
4646041 2244915 2244915 defendant Schelyngton John chaplain 691063 691063 Schelyngton, John, of Oxfordshire, chaplain 0
4646659 2245086 2245086 defendant Wolf Hugh   691063 691063 Wolf, Hugh, of Oxfordshire, knight 3
4650393 2246139 2246139 plaintiff Willycotys John   691063 691063 Willycotys, John, of Oxfordshire 0
4650395 2246139 2246139 defendant Spere John   691063 691063 Spere, John, of Oxfordshire 0
4650724 2246230 2246230 plaintiff Wyllycotys John   691063 691063 Wyllycotys, John, of Oxfordshire 0
4650726 2246230 2246230 defendant Spere John   691063 691063 Spere, John, of Oxfordshire 0
4650837 2246264 2246264 defendant Ralegh John   691063 691063 Ralegh, John, of Oxfordshire 0
4655425 2247591 2247591 defendant Harpeden John esq 691063 691063 Harpeden, John, of Oxfordshire, esq 0
4733318 2275597 2275597 plaintiff Quatermayne Richard esq 691063 691063 Quatermayne, Richard, of Oxfordshire, esq 0
4744654 2278957 2278957 defendant Blount John (legal representative) 691063 691063 Blount, John, of Oxfordshire, esq, executors of 0
4820374 2302444 2302444 plaintiff Quatremayn Richard esq 691063 691063 Quatremayn, Richard, of Oxfordshire, esq, on his own account 0
4822469 2303099 2303099 plaintiff Skyrmote William gent 691063 691063 Skyrmote, William, of Oxfordshire, gent 0
4833218 2306401 2306401 defendant Attilbrigge John (legal representative) 691063 691063 Attilbrigge, John, of Oxfordshire, executor of 0
5004858 2358319 2358319 plaintiff Rassh William gent 691063 691063 Rassh, William, of Oxfordshire, gent 0
5004860 2358320 2358320 plaintiff Rassh William gent 691063 691063 Rassh, William, of Oxfordshire, gent 0
5007062 2358960 2358960 defendant Glover William glover maker 691063 691063 Glover, William, of Oxfordshire, glover maker 0
5045555 2370300 2370300 plaintiff Langford Edward   691063 691063 Langford, Edward, of Oxfordshire, sheriff 0
5136266 2397125 2397125 plaintiff Noreys John esq & sheriff 691063 691063 Noreys, John, of Oxfordshire, esq & sheriff 0
5388673 2471816 2471816 defendant Da_ William gent 691063 691063 Da_, William, of Oxfordshire, gent 0
5393899 2473316 2473316 defendant Mayhewe Richard husbandman 691063 691063 Mayhewe, Richard, of Oxfordshire, husbandman 1
5394743 2473560 2473560 defendant Holme Thomas   691063 691063 Holme, Thomas, of Oxfordshire 0
5442392 2487646 2487646 defendant Bray Robert mercer 691063 691063 Bray, Robert, of Oxfordshire, mercer 1
5611047 2547173 2547173 defendant Tuwe John   691063 691063 Tuwe, John, of Oxfordshire 0
5613011 2547846 2547846 defendant Lyght Richard   691063 691063 Lyght, Richard, of Oxfordshire 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);