names

60 rows where place_id = 596528

✎ 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
3625137 1875396 1875396 defendant Kent William tanner 596528 596528 Kent, William, of Wytney, Oxon, tanner 2
3673598 1917771 1917771 defendant Waynman Richard merchant 596528 596528 Waynman, Richard, of Wytney, Oxon, merchant 0
3714418 1930805 1930805 defendant Marten Richard yeoman 596528 596528 Marten, Richard, of Wytney, Oxon, yeoman 1
3727569 1934903 1934903 plaintiff Wenman Richard merchant of the staple 596528 596528 Wenman, Richard, of Wytney, Oxon, merchant of the staple 0
3746072 1940677 1940677 defendant Holnes John mercer 596528 596528 Holnes, John, of Wytney, Oxon, mercer 0
3801287 1958327 1958327 defendant Wayneman Richard merchant of the staple 596528 596528 Wayneman, Richard, of Wytney, Oxon, merchant of the staple 0
3865252 1978586 1978586 defendant Ryng Eleanor widow 596528 596528 Ryng, Eleanor, of Wytney, Oxon, widow 1
3884965 1985235 1985235 defendant Temple Robert chapman 596528 596528 Temple, Robert, of Wytney, Oxon, chapman 0
3902296 1991001 1991001 defendant Able William smith 596528 596528 Able, William, of Wytney, Oxon, smith 3
3950688 2007314 2007314 defendant Busshe Thomas chapman 596528 596528 Busshe, Thomas, of Wytney, Oxon, chapman 0
3960690 2010838 2010838 defendant Penny William yeoman 596528 596528 Penny, William, of Wytney, Oxon, yeoman 0
3966296 2012839 2012839 defendant Margerys Randolph tailor 596528 596528 Margerys, Randolph, of Wytney, Oxon, tailor 2
3987558 2020301 2020301 plaintiff Yate Thomas clothier 596528 596528 Yate, Thomas, of Wytney, Oxon, clothier 0
3995684 2023201 2023201 defendant Malyn Humphrey   596528 596528 Malyn, Humphrey, of Wytney, Oxon, woollen draper 0
4032369 2036244 2036244 defendant Malyn Humphrey draper 596528 596528 Malyn, Humphrey, of Wytney, Oxon, draper 0
4046655 2041255 2041255 defendant Wylshere Roger shoemaker 596528 596528 Wylshere, Roger, of Wytney, Oxon, shoemaker 0
4067891 2048826 2048826 plaintiff Jones Henry clothier 596528 596528 Jones, Henry, of Wytney, Oxon, clothier 0
4067893 2048827 2048827 plaintiff Jones Henry clothier 596528 596528 Jones, Henry, of Wytney, Oxon, clothier 0
4119306 2067199 2067199 defendant Wyckes William gent 596528 596528 Wyckes, William, of Wytney, Oxon, gent 0
4119308 2067200 2067200 defendant Wykes William gent 596528 596528 Wykes, William, of Wytney, Oxon, gent 0
4119847 2067388 2067388 defendant Showell Richard mercer 596528 596528 Showell, Richard, of Wytney, Oxon, mercer 0
4135486 2073013 2073013 defendant Savery Richard mercer 596528 596528 Savery, Richard, of Wytney, Oxon, mercer 0
4145299 2076515 2076515 defendant Petoe William tailor 596528 596528 Petoe, William, of Wytney, Oxon, tailor 0
4148157 2077488 2077488 defendant Wyxe William gent 596528 596528 Wyxe, William, of Wytney, Oxon, gent 0
4200400 2095696 2095696 defendant Collyer John clothier 596528 596528 Collyer, John, of Wytney, Oxon, clothier 0
4203898 2096918 2096918 defendant Weekes William yeoman 596528 596528 Weekes, William, of Wytney, Oxon, yeoman 1
4241510 2110142 2110142 defendant Dalton Thomas yeoman 596528 596528 Dalton, Thomas, of Wytney, Oxon, yeoman 0
4283643 2124186 2124186 defendant Johnson Richard collier 596528 596528 Johnson, Richard, of Wytney, Oxon, collier 0
4283650 2124188 2124188 defendant Collyar John yeoman 596528 596528 Collyar, John, of Wytney, Oxon, yeoman 0
4284272 2124426 2124426 defendant Yorke Humphrey innholder 596528 596528 Yorke, Humphrey, of Wytney, Oxon, innholder 2
4341240 2144209 2144209 defendant Box Thomas yeoman 596528 596528 Box, Thomas, of Wytney, Oxon, yeoman 0
4356949 2149662 2149662 defendant Yates Richard clothier 596528 596528 Yates, Richard, of Wytney, Oxon, clothier 1
4359286 2150484 2150484 defendant Crucheley William gent 596528 596528 Crucheley, William, of Wytney, Oxon, gent 0
4808735 2298898 2298898 defendant Martyn John   596528 596528 Martyn, John, of Wytney, Oxon 4
4809159 2299041 2299041 defendant Hikkes John dyer 596528 596528 Hikkes, John, of Wytney, Oxon, dyer 0
4810572 2299455 2299455 defendant Brayn John fuller 596528 596528 Brayn, John, of Wytney, Oxon, fuller 0
4850444 2311597 2311597 defendant Pynchpole Thomas husbandman 596528 596528 Pynchpole, Thomas, of Wytney, Oxon, husbandman 0
4852570 2312226 2312226 defendant Hickes John   596528 596528 Hickes, John, of Wytney, Oxon 0
4852578 2312228 2312228 defendant Hickes John dyer 596528 596528 Hickes, John, of Wytney, Oxon, dyer 0
4894726 2325022 2325022 defendant Hykkys John dyer 596528 596528 Hykkys, John, of Wytney, Oxon, dyer 2
4899782 2326568 2326568 defendant Hyckes John dyer 596528 596528 Hyckes, John, of Wytney, Oxon, dyer 0
4909307 2329453 2329453 defendant Payn Thomas chapman 596528 596528 Payn, Thomas, of Wytney, Oxon, chapman 3
4958817 2344611 2344611 defendant Payn Thomas chapman 596528 596528 Payn, Thomas, of Wytney, Oxon, chapman 1
4958822 2344612 2344612 defendant Payn Thomas chapman 596528 596528 Payn, Thomas, of Wytney, Oxon, chapman 1
4989793 2353864 2353864 defendant Burton John chapman 596528 596528 Burton, John, of Wytney, Oxon, chapman 3
4989798 2353865 2353865 defendant Burton John chapman 596528 596528 Burton, John, of Wytney, Oxon, chapman 3
5003448 2357904 2357904 defendant Wade Robert dyer 596528 596528 Wade, Robert, of Wytney, Oxon, dyer 4
5003454 2357905 2357905 defendant Wade Robert dyer 596528 596528 Wade, Robert, of Wytney, Oxon, dyer 4
5249372 2429933 2429933 defendant Assh Richard yeoman 596528 596528 Assh, Richard, of Wytney, Oxon, yeoman 0
5249379 2429934 2429934 defendant Assh Richard yeoman 596528 596528 Assh, Richard, of Wytney, Oxon, yeoman 0
5313267 2449005 2449005 defendant Holme Thomas dyer 596528 596528 Holme, Thomas, of Wytney, Oxon, dyer 1
5383121 2470245 2470245 defendant Holme Thomas dyer 596528 596528 Holme, Thomas, of Wytney, Oxon, dyer 0
5414187 2479180 2479180 defendant Gilson Henry yeoman 596528 596528 Gilson, Henry, of Wytney, Oxon, yeoman 2
5500114 2504988 2504988 defendant Fox Richard dyer 596528 596528 Fox, Richard, of Wytney, Oxon, dyer 3
5505348 2506584 2506584 defendant Wynslowe Richard brasier 596528 596528 Wynslowe, Richard, of Wytney, Oxon, brasier 4
5521925 2511673 2511673 defendant Michell Thomas mercer 596528 596528 Michell, Thomas, of Wytney, Oxon, mercer 1
5562048 2523499 2523499 defendant Clerk Richard tanner 596528 596528 Clerk, Richard, of Wytney, Oxon, tanner 0
5562052 2523500 2523500 defendant Clerke Richard tanner 596528 596528 Clerke, Richard, of Wytney, Oxon, tanner 0
5566260 2524729 2524729 defendant Yell Thomas husbandman 596528 596528 Yell, Thomas, of Wytney, Oxon, husbandman 2
5600615 2535084 2535084 defendant Byrde Richard yeoman 596528 596528 Byrde, Richard, of Wytney, Oxon, yeoman 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);