names

51 rows where place_id = 594609

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616811 1872886 1872886 defendant Wheler Richard husbandman 594609 594609 Wheler, Richard, of Draycote, husbandman 3
3622923 1874699 1874699 defendant Roche Thomas husbandman 594609 594609 Roche, Thomas, of Draycote, Chedder, husbandman 1
3622930 1874700 1874700 defendant Roche Thomas husbandman 594609 594609 Roche, Thomas, of Draycote, Chedder, husbandman 2
3653844 1911465 1911465 defendant Long Henry   594609 594609 Long, Henry, of Draycote, knight 0
3727109 1934746 1934746 defendant Dabkyn Robert yeoman 594609 594609 Dabkyn, Robert, of Draycote, yeoman 0
3756670 1944065 1944065 defendant Balyden John yeoman 594609 594609 Balyden, John, of Draycote, yeoman 2
3798124 1957309 1957309 defendant Draycote John yeoman 594609 594609 Draycote, John, of Draycote, yeoman 1
3804485 1959343 1959343 defendant Pateman Roger husbandman 594609 594609 Pateman, Roger, of Draycote, husbandman 0
3906955 1992614 1992614 defendant Robothom John husbandman 594609 594609 Robothom, John, of Draycote, husbandman 4
3985376 2019529 2019529 defendant Skyllynge William esq 594609 594609 Skyllynge, William, of Draycote, or of Rolston, esq 0
4412148 2168657 2168657 defendant Shepie Hugh laborer 594609 594609 Shepie, Hugh, of Draycote, laborer 1
4433214 2175140 2175140 defendant atte Churchestyle John   594609 594609 atte Churchestyle, John, of Draycote 0
4471347 2191705 2191705 defendant Sutton John   594609 594609 Sutton, John, of Draycote 0
4481281 2194833 2194833 defendant Fyssher Roger   594609 594609 Fyssher, Roger, of Draycote 0
4481286 2194834 2194834 defendant Fyssher Roger   594609 594609 Fyssher, Roger, of Draycote 0
4510052 2203629 2203629 defendant Smyth John   594609 594609 Smyth, John, of Draycote 0
4527931 2209015 2209015 defendant Hynton John   594609 594609 Hynton, John, of Draycote 0
4640155 2243234 2243234 defendant Abbot Nicholas   594609 594609 Abbot, Nicholas, of Draycote 3
4668148 2255745 2255745 defendant Baron William husbandman 594609 594609 Baron, William, of Draycote, husbandman 0
4677333 2258530 2258530 defendant Smale John yeoman 594609 594609 Smale, John, of Draycote, yeoman 0
4682224 2260062 2260062 defendant Erle Thomas ploughman 594609 594609 Erle, Thomas, of Draycote, ploughman 0
4696915 2264514 2264514 defendant Abbot Nicholas husbandman 594609 594609 Abbot, Nicholas, of Draycote, husbandman 2
4748151 2279969 2279969 defendant Hale John husbandman 594609 594609 Hale, John, of Draycote, husbandman 2
4761228 2283860 2283860 defendant Lyndesey Walter husbandman 594609 594609 Lyndesey, Walter, of Draycote, husbandman 0
4767117 2285699 2285699 defendant Crop Richard chaplain 594609 594609 Crop, Richard, of Draycote, chaplain 0
4794770 2294503 2294503 defendant Lydndesey Walter   594609 594609 Lydndesey, Walter, of Draycote, "bagger" 4
4805301 2297861 2297861 defendant Taillour Thomas husbandman 594609 594609 Taillour, Thomas, of Draycote, husbandman 0
4808866 2298941 2298941 defendant Warner Henry yeoman 594609 594609 Warner, Henry, of Draycote, yeoman 0
4827213 2304561 2304561 defendant Dounbell John husbandman 594609 594609 Dounbell, John, of Draycote, husbandman 0
4835589 2307121 2307121 defendant Taillour Thomas husbandman 594609 594609 Taillour, Thomas, of Draycote, husbandman 2
4853175 2312409 2312409 defendant Walke Robert husbandman 594609 594609 Walke, Robert, of Draycote, husbandman 2
4889907 2323632 2323632 defendant Coton Henry husbandman 594609 594609 Coton, Henry, of Draycote, husbandman 2
4904833 2328110 2328110 defendant Hykkys Roger husbandman 594609 594609 Hykkys, Roger, of Draycote, husbandman 3
4954656 2343349 2343349 defendant Tebald Henry husbandman 594609 594609 Tebald, Henry, of Draycote, husbandman 2
4954657 2343349 2343349 defendant Warner John husbandman 594609 594609 Warner, John, of Draycote, husbandman 3
4968784 2347632 2347632 defendant Helyer William husbandman 594609 594609 Helyer, William, of Draycote, husbandman 0
5005719 2358567 2358567 defendant Hale John husbandman 594609 594609 Hale, John, of Draycote, husbandman 0
5052776 2372426 2372426 defendant Wright John yeoman 594609 594609 Wright, John, of Draycote, yeoman 0
5052780 2372427 2372427 defendant Wryght John yeoman 594609 594609 Wryght, John, of Draycote, yeoman 0
5053679 2372701 2372701 defendant Fynamore John husbandman 594609 594609 Fynamore, John, of Draycote, husbandman 10
5060383 2374682 2374682 defendant Rycote Richard husbandman 594609 594609 Rycote, Richard, of Draycote, husbandman 1
5117423 2391527 2391527 defendant Tayllour Thomas husbandman 594609 594609 Tayllour, Thomas, of Draycote, Chedder, husbandman 1
5118129 2391736 2391736 defendant Scarlet John, senior husbandman 594609 594609 Scarlet, John, senior, of Draycote, husbandman 0
5118130 2391736 2391736 defendant Scarlet John, junior husbandman 594609 594609 Scarlet, John, junior, of Draycote, husbandman 1
5239426 2427112 2427112 defendant Waren William yeoman 594609 594609 Waren, William, of Draycote under Nedwode, yeoman 4
5248446 2429673 2429673 defendant Wabbecan Thomas husbandman 594609 594609 Wabbecan, Thomas, of Draycote, husbandman 0
5501422 2505377 2505377 defendant Churchehous John carpenter 594609 594609 Churchehous, John, of Draycote, carpenter 0
5607867 2537365 2537365 defendant Agard John gent 594609 594609 Agard, John, of Draycote, gent 0
5619461 2549935 2549935 defendant Rode Adam de   594609 594609 Rode, Adam de, of Draycote 2
5620400 2550239 2550239 defendant Gilbard Thomas   594609 594609 Gilbard, Thomas, of Draycote 0
5623469 2551274 2551274 defendant Basset Roger   594609 594609 Basset, Roger, of Draycote 7

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