names

63 rows where place_id = 586502

✎ 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
3588895 1864173 1864173 defendant Baylly William husbandman 586502 586502 Baylly, William, of Wykeham, husbandman 6
3613193 1871781 1871781 defendant Wryght Robert husbandman 586502 586502 Wryght, Robert, of Wykeham, husbandman 1
3613194 1871781 1871781 defendant Bailly Nicholas husbandman 586502 586502 Bailly, Nicholas, of Wykeham, husbandman 2
3618829 1873499 1873499 defendant Crippys Henry yeoman 586502 586502 Crippys, Henry, of Wykeham, yeoman 0
3720507 1932696 1932696 defendant Burges Thomas gent 586502 586502 Burges, Thomas, of Wykeham, gent 0
3736286 1937588 1937588 defendant Burges Thomas gent 586502 586502 Burges, Thomas, of Wykeham, gent 0
3736297 1937592 1937592 defendant Burges Thomas gent 586502 586502 Burges, Thomas, of Wykeham, gent 0
3736298 1937593 1937593 plaintiff Husse James gent 586502 586502 Husse, James, of Wykeham, gent 0
3736299 1937593 1937593 defendant Burges Thomas gent 586502 586502 Burges, Thomas, of Wykeham, gent 0
3743129 1939709 1939709 defendant Jumper Robert husbandman 586502 586502 Jumper, Robert, of Wykeham, husbandman 0
3758545 1944670 1944670 defendant Ede William husbandman 586502 586502 Ede, William, of Wykeham, husbandman 0
3758547 1944670 1944670 defendant Gyrlyng Thomas husbandman 586502 586502 Gyrlyng, Thomas, of Wykeham, husbandman 2
3831521 1967745 1967745 defendant Dacy alias Jumper or Juniper Robert husbandman 586502 586502 Dacy alias Jumper or Juniper, Robert, of Wykeham, husbandman 0
3831522 1967745 1967745 defendant Sparkys Thomas carpenter 586502 586502 Sparkys, Thomas, of Wykeham, carpenter 1
3831523 1967745 1967745 defendant Colswayne Henry fuller 586502 586502 Colswayne, Henry, of Wykeham, fuller 2
3840219 1970507 1970507 defendant Enderby Robert husbandman 586502 586502 Enderby, Robert, of Wykeham, husbandman 2
3840220 1970507 1970507 defendant Enderby John husbandman 586502 586502 Enderby, John, of Wykeham, husbandman 3
3852644 1974433 1974433 defendant Enderby Robert husbandman 586502 586502 Enderby, Robert, of Wykeham, husbandman 1
3862776 1977743 1977743 defendant Harryson Robert yeoman 586502 586502 Harryson, Robert, of Wykeham, yeoman 0
3877652 1982767 1982767 defendant Uvedale Arthur esq 586502 586502 Uvedale, Arthur, of Wykeham, esq 0
3941533 2004180 2004180 defendant Woodman Stephen yeoman 586502 586502 Woodman, Stephen, of Wykeham, yeoman 0
4046536 2041212 2041212 defendant Sellars Henry husbandman 586502 586502 Sellars, Henry, of Wykeham, husbandman 0
4057073 2044912 2044912 defendant Sellers Henry husbandman 586502 586502 Sellers, Henry, of Wykeham, husbandman 0
4083414 2054350 2054350 defendant Todd Ralph husbandman 586502 586502 Todd, Ralph, of Wykeham, husbandman 0
4305083 2131919 2131919 defendant Francke John yeoman 586502 586502 Francke, John, of Wykeham, yeoman 0
4450670 2185169 2185169 defendant Nalle John   586502 586502 Nalle, John, of Wykeham, senior 0
4471714 2191820 2191820 defendant Cook John   586502 586502 Cook, John, of Wykeham 1
4484420 2195820 2195820 defendant Whityng John   586502 586502 Whityng, John, of Wykeham 0
4487328 2196751 2196751 defendant Smyth William   586502 586502 Smyth, William, of Wykeham 2
4490840 2197832 2197832 defendant Whitynges John   586502 586502 Whitynges, John, of Wykeham 1
4525958 2208420 2208420 plaintiff Kent Emma   586502 586502 Kent, Emma, of Wykeham 0
4533912 2210876 2210876 defendant Squyry Thomas   586502 586502 Squyry, Thomas, of Wykeham 1
4638139 2242693 2242693 defendant Whabbe Richard sawyer 586502 586502 Whabbe, Richard, of Wykeham, sawyer 0
4706008 2267252 2267252 defendant Pulter Thomas chapman 586502 586502 Pulter, Thomas, of Wykeham, chapman 2
4791968 2293592 2293592 defendant Rilkyn Simon husbandman 586502 586502 Rilkyn, Simon, of Wykeham, husbandman 1
4825656 2304063 2304063 defendant Bury John gent 586502 586502 Bury, John, of Wykeham, gent 0
4827321 2304592 2304592 defendant Haukyns Thomas fuller 586502 586502 Haukyns, Thomas, of Wykeham, fuller 1
4831902 2306003 2306003 defendant Westipale Denis sadler 586502 586502 Westipale, Denis, of Wykeham, sadler 0
4865684 2316232 2316232 defendant Whyte Richard laborer 586502 586502 Whyte, Richard, of Wykeham, laborer 0
4876444 2319594 2319594 defendant Colynson Thomas yeoman 586502 586502 Colynson, Thomas, of Wykeham, yeoman 2
4928272 2335269 2335269 defendant Horewode Thomas yeoman 586502 586502 Horewode, Thomas, of Wykeham, yeoman 0
4940832 2339159 2339159 defendant Haukyns Robert husbandman 586502 586502 Haukyns, Robert, of Wykeham, husbandman 3
4946745 2340983 2340983 defendant Persons William husbandman 586502 586502 Persons, William, of Wykeham, husbandman 0
4968629 2347584 2347584 defendant Deraunt John fuller 586502 586502 Deraunt, John, of Wykeham, fuller 0
5023061 2363652 2363652 defendant Douse or Donse John chapman 586502 586502 Douse or Donse, John, of Wykeham, chapman 0
5081736 2381038 2381038 defendant Nall Richard husbandman 586502 586502 Nall, Richard, of Wykeham, husbandman 2
5180465 2410030 2410030 defendant Bek Robert slater 586502 586502 Bek, Robert, of Wykeham, slater 2
5349322 2459919 2459919 defendant Robynson James husbandman 586502 586502 Robynson, James, of Wykeham, husbandman 0
5427378 2483133 2483133 defendant Meyby John husbandman 586502 586502 Meyby, John, of Wykeham, husbandman 0
5427379 2483133 2483133 defendant Mooby Thomas laborer 586502 586502 Mooby, Thomas, of Wykeham, laborer 1
5427380 2483133 2483133 defendant Oldelond Thomas husbandman 586502 586502 Oldelond, Thomas, of Wykeham, husbandman 2
5427381 2483133 2483133 defendant Oldelond John husbandman 586502 586502 Oldelond, John, of Wykeham, husbandman 3
5457853 2492245 2492245 defendant Morby John husbandman 586502 586502 Morby, John, of Wykeham, husbandman 0
5457854 2492245 2492245 defendant Morby Thomas laborer 586502 586502 Morby, Thomas, of Wykeham, laborer 1
5457855 2492245 2492245 defendant Oldelond Thomas husbandman 586502 586502 Oldelond, Thomas, of Wykeham, husbandman 2
5457856 2492245 2492245 defendant Oldelond John husbandman 586502 586502 Oldelond, John, of Wykeham, husbandman 3
5490420 2502030 2502030 plaintiff Bocher John   586502 586502 Bocher, John, of Wykeham 0
5516254 2509920 2509920 defendant Folkys Thomas husbandman 586502 586502 Folkys, Thomas, of Wykeham, husbandman 0
5545308 2518629 2518629 defendant Tukker John yeoman 586502 586502 Tukker, John, of Wykeham, yeoman 0
5589428 2531695 2531695 defendant Chalwen William yeoman 586502 586502 Chalwen, William, of Wykeham, yeoman 0
5589430 2531696 2531696 defendant Chalwen William yeoman 586502 586502 Chalwen, William, of Wykeham, yeoman 0
5597481 2534113 2534113 plaintiff Crossewell William yeoman 586502 586502 Crossewell, William, of Wykeham, yeoman 0
5627290 2552503 2552503 defendant Whityng John husbandman 586502 586502 Whityng, John, of Wykeham, husbandman 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);